From a 500-row sample across 24 columns.
latitudelotstreet_name+7latitudelotblock+5lotblockbinlatitudelotblock+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| job_filing_name | job_type | bin | borough | house_no | street_name | block | lot | zip_code | submitted_date | c_of_o_status | c_of_o_sequence |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 120954770 | ALTERATION TYPE 1 | 1001905 | Manhattan | 361 | BROADWAY | 174 | 7505 | 10013 | 2022-02-15T00:00:00.000 | CO Issued | 15514 |
| 321383560 | NEW BUILDING |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job_filing_name | text | The filing sequence indicator | 0% | 321197058321188852320591944 |
job_type | categorical | Overall job type for the application | 0% | ALTERATION TYPE 1NEW BUILDINGAlteration COof 5 |
bin | text | Building Identification Number assigned by Department of City Planning | 0% | 333588410342241022667 |
borough | categorical | A name to indicate the NYC borough where the proposed work will take place | 0% | Manhattan |
GET /api/datasets/pkdm-hqz6 GET /api/datasets/pkdm-hqz6/quality GET /api/datasets/pkdm-hqz6/related GET /api/columns?dataset=pkdm-hqz6
latitudecommunity_boardlongitude+2latitudestreet_namecommunity_board+3latitudelotstreet_name+6latitudelotblock+4| 3128179 |
| Brooklyn |
| 639 |
| FOSTER AVENUE |
| 5428 |
| 92 |
| 11230 |
| 2021-04-08T00:00:00.000 |
| CO Issued |
| 80 |
| M00941174 | Alteration CO | 1026775 | Manhattan | 446 | WEST 54 STREET | 1063 | 55 | 10019 | 2025-06-17T00:00:00.000 | CO Issued | 76926 |
| S00927100 | Alteration CO | 5051059 | Staten Island | 120 | JEFFERSON AVENUE | 3557 | 41 | 10306 | 2024-08-26T00:00:00.000 | CO Issued | 59719 |
| 410070925 | ALTERATION TYPE 1 | 4456886 | Queens | 271-10 | GRAND CENTRAL PARKWAY | 8489 | 1 | 11005 | 2023-11-13T00:00:00.000 | CO Issued | 47263 |
| 122614224 | ALTERATION TYPE 1 | 1009754 | Manhattan | 175 | VARICK STREET | 580 | 65 | 10014 | 2023-11-06T00:00:00.000 | CO Issued | 46320 |
| S00521744 | New Building | 5174852 | Staten Island | 16 | BARTOW STREET | 5097 | 15 | 10308 | 2022-07-11T00:00:00.000 | CO Issued | 22453 |
| 340748338 | ALTERATION TYPE 1 | 3058478 | Brooklyn | 265 | CARLTON AVE | 2090 | 3 | 11205 | 2021-12-02T00:00:00.000 | CO Issued | 12115 |
| 220518571 | ALTERATION TYPE 1 | 2018236 | Bronx | 3322 | BAINBRIDGE AVENUE | 3343 | 340 | 10467 | 2022-01-26T00:00:00.000 | CO Issued | 14443 |
| Q00697282 | New Building | 4624195 | Queens | 15-42 GAR | 150 STREET | 4663 | 29 | 11357 | 2024-04-18T00:00:00.000 | CO Issued | 53928 |
Showing 12 of 24 columns. All of them are listed below.
BrooklynQueenshouse_no | text | The house number for the building owner's address. | 0% | 120020 |
street_name | text | The street name for the building owner's address. | 0% | BROADWAYMADISON AVENUEPARK AVENUE |
block | text | Tax Block assigned to the location of the proposed work by the Department of Finance. | 0% | 1171164452 |
lot | text | Tax Lot assigned to the location of the proposed work by the Department of Finance. | 0% | 175017502 |
zip_code | text | The Zip Code for the filing representative's address. | 0% | 112011110110013 |
submitted_date | datetime | The date the Certificate of Occupancy request is submitted to the Department of Buildings | 0% | 2024-10-07T00:00:00.0002025-12-01T00:00:00.0002023-02-06T00:00:00.000 |
c_of_o_status | text | The status of the Certificate of Occupancy | 0% | CO Issuedof 1 |
c_of_o_sequence | integer | The nominal ordering of Certificate of Occupancy requests in a series | 0% | 5381710057364835 |
c_of_o_filing_type | categorical | The type of Certificate of Occupancy requested | 0% | Renewal Without ChangeFinalInitialof 4 |
community_board | integer | NYC Community Board | 0% | 105301302 |
c_of_o_issuance_date | text | The date the Certificate of Occupancy is issued | 0% | 11/13/23 4:03:11 PM03/24/25 10:10:06 AM07/24/26 2:16:06 PM |
application_number | text | The Certificate of Occupancy number | 0% | CO-000055565CO-000064835CO-000100573 |
number_of_dwelling_units | text | — | 24% | 021 |
c_of_o_number | text | — | 0% | 4620994-00000061091057-00000051090280-0000005 |
latitude | float | — | 0% | 40.69726840.75484840.755167 |
longitude | float | — | 0% | -73.844856-73.986451-73.98083 |
citycouncildistrict | text | — | 0% | 030401 |
bbl | text | — | 2% | 100972000140201800011012660001 |
censustract2010 | integer | — | 0% | 332137 |
ntaname | text | — | 0% | Midtown-Times SquareMidtown South-Flatiron-U…Chelsea-Hudson Yards |