From a 500-row sample across 23 columns.
ntajob_numbercommunity_board+5community_boardlongitudebin+4community_boardcensus_tractlongitude+5ntacommunity_boardcensus_tract+6Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| bin | housenumber | streetname | borough | cbno | workpermitnumber | ahv_permit_number | ahvpermitstatus | variancetype | reasonforvariance | variance_start_date_time | variance_end_date_time |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1022706 | 1251 | 6 AVENUE | Manhattan | 105 | M01395941-I1-GC | M1006234 | AHV Permit Issued | Initial | Public Safety | 2026-09-18T18:00:00.000 | 2026-09-18T22:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bin | text | Building Identification Number assigned by Department of City Planning. | 0% | 107619310462521036082 |
housenumber | text | The house number for the building owner's address. | 0% | 1200345 |
streetname | text | The street name for the building owner's address. | 0% | BROADWAYPARK AVENUEMADISON AVENUE |
borough | categorical | A number to indicate the NYC borough where the proposed work will take place. | 0% | MANHATTANBROOKLYNQUEENS |
GET /api/datasets/g76y-dcqj GET /api/datasets/g76y-dcqj/quality GET /api/datasets/g76y-dcqj/related GET /api/columns?dataset=g76y-dcqj
binboroughntacommunity_boardcensus_tract+6ntastreetnamecensus_tract+6ntacommunity_boardcensus_tract+5| 3048495 |
| 739 |
| MYRTLE AVENUE |
| Brooklyn |
| 303 |
| B01263086-I1-GC |
| B6103623 |
| AHV Permit Issued |
| Initial |
| Undue Hardship |
| 2026-09-17T18:00:00.000 |
| 2026-09-17T21:00:00.000 |
| 3430633 | 263 | PROSPECT AVENUE | Brooklyn | 307 | B00656247-I1-GC | B3492049 | AHV Permit Issued | Initial | Public Safety | 2025-07-03T06:00:00.000 | 2025-07-03T07:00:00.000 |
| 5113169 | 715 | OCEAN TERRACE | Staten Island | 502 | S01194712-I1-SH | S1972616 | AHV Permit Issued | Initial | Undue Hardship | 2026-09-19T07:00:00.000 | 2026-09-19T16:00:00.000 |
| 4440330 | 203-02 | 109 AVENUE | Queens | 412 | Q00752501-I1-GC | Q8635227 | AHV Permit Issued | Initial | City Construction Project | 2026-09-13T06:00:00.000 | 2026-09-13T19:00:00.000 |
| 5106979 | 161 | PARK AVENUE | Staten Island | 501 | S01126553-I1-GC | S4455118 | AHV Permit Issued | Initial | City Construction Project | 2026-09-29T18:00:00.000 | 2026-09-29T23:00:00.000 |
| 1054786 | 2351 | 1 AVENUE | Manhattan | 111 | M00946139-I1-GC-CX | M6997720 | AHV Permit Issued | Renewal | City Construction Project | 2026-11-17T18:00:00.000 | 2026-11-18T00:00:00.000 |
| 1035347 | 6 | EAST 43 STREET | Manhattan | 105 | M01297210-S2-MS | M6951261 | AHV Permit Issued | Renewal | Construction activities with minimal noise impact | 2026-09-15T18:00:00.000 | 2026-09-15T23:59:00.000 |
| 3336349 | 9216 | 7 AVENUE | Brooklyn | 310 | B01221502-I1-GC, B01225902-S1-MS, B01221502-S1-ST | B5913608 | AHV Permit Issued | Initial | Public Safety | 2026-09-12T09:00:00.000 | 2026-09-12T17:00:00.000 |
| 1085735 | 200 | PARK AVENUE | Manhattan | 105 | M01242646-I1-GC | M6206613 | AHV Permit Issued | Initial | Public Safety | 2026-09-14T18:00:00.000 | 2026-09-15T02:00:00.000 |
Showing 12 of 23 columns. All of them are listed below.
cbno | integer | A number to indicate the NYC borough where the proposed work will take place. | 2% | 105101106 |
job_number | text | The DOB job number(s) assigned when the applicant begins the application. | 99% | M00227442-I1M00105672-I1M00078455-I1 |
workpermitnumber | text | The DOB work permit(s) associated with the after hours variance | 1% | B00641149-I1-GCM00635724-I1-STM00559123-I1-GC |
ahv_permit_number | text | The DOB AHV Permit Number assigned when the after hours variance is issued | 0% | M9161714M3765742M4923412 |
ahvpermitstatus | categorical | The status of the after hours variance | 0% | AHV Permit IssuedAHV Permit RejectedApprovedof 19 |
variancetype | categorical | The type of variance issued (initial or renewal) | 0% | InitialRenewalof 2 |
reasonforvariance | categorical | The reason the after hours variance has been sought | 0% | Public SafetyCity Construction Projec…Construction activities …of 5 |
variance_start_date_time | datetime | Date when the after hours variance initiates | 0% | 2026-10-08T18:00:00.0002026-10-07T18:00:00.0002026-10-09T18:00:00.000 |
variance_end_date_time | datetime | Date when the after hours variance expires | 0% | 2026-08-08T17:00:00.0002026-08-15T17:00:00.0002026-10-10T17:00:00.000 |
residence_200ft | boolean | Indicates whether or not a residence is located within 200 feet of the address of the after hours variance | 0% | TrueFalseof 2 |
enclosed_work | boolean | Indicates whether or not the after hours variance applies to work being done in an enclosed building | 0% | FalseTrueof 2 |
demolition | boolean | Indicates whether or not the after hours variance involves full or partial demolition | 0% | FalseTrueof 2 |
crane_use | boolean | Indicates whether or not the after hours variance involves use of a crane | 0% | FalseTrueof 2 |
latitude | float | — | 0% | 40.76021640.76045940.76402 |
longitude | float | — | 0% | -73.985334-73.958196-73.973189 |
community_board | integer | — | 0% | 512 |
council_district | integer | — | 0% | 431 |
census_tract | integer | — | 0% | 125102100 |
bbl | integer | — | 2% | 101019750210096275011014740040 |
nta | text | — | 0% | Midtown-Times SquareEast Midtown-Turtle BayFinancial District-Batte… |