From a 500-row sample across 24 columns.
binbblblock+7binbblblock+4bbllatitudezip_code+1binbbllatitude+1Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| device_number | device_type | device_status | status_date | periodic_report_year | cat1_report_year | cat1_latest_report_filed | cat5_latest_report_filed | periodic_latest_inspection | bin | borough | house_number |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1P14518 | Elevator | Active | 2021-12-29T00:00:00.000 | 2025 | 2025 | 2025-09-25T00:00:00.000 | 2023-04-19T00:00:00.000 | 2025-06-26T00:00:00.000 | 1001627 | Manhattan | 85 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
device_number | text | The devices identification number | 0% | 3P104574F3764P2392 |
device_type | categorical | The type of device group | 0% | ElevatorAccessibility LiftPersonnel Hoistof 8 |
device_status | categorical | The status of the device | 0% | ActiveRemovedWork in Progressof 7 |
status_date | datetime | The date of the elevator device's current status | 0% | 1988-07-11T00:00:00.000 |
GET /api/datasets/e5aq-a4j2 GET /api/datasets/e5aq-a4j2/quality GET /api/datasets/e5aq-a4j2/related GET /api/columns?dataset=e5aq-a4j2
binbblhouse_number+3binbblblock+3binbblblock+3| 4P1000100 | Elevator | Work in Progress | 2024-07-25T00:00:00.000 | — | — | — | — | — | 4143518 | Queens | 141-32 |
| 2W12120 | Accessibility Lift | Removed | 2010-03-23T00:00:00.000 | — | 2014 | 2014-06-09T00:00:00.000 | 2010-06-14T00:00:00.000 | — | 2017315 | Bronx | 3005 |
| 3F2219 | Elevator | Removed | 2013-11-27T00:00:00.000 | — | — | — | — | — | 3329396 | Brooklyn | 139 |
| 1P43871 | Elevator | Removed | 2024-09-11T00:00:00.000 | 2022 | 2022 | 2022-12-29T00:00:00.000 | 2017-10-12T00:00:00.000 | 2022-05-18T00:00:00.000 | 1086548 | Manhattan | 123 |
| 1P8115 | Elevator | Active | 2020-05-04T00:00:00.000 | 2024 | 2024 | 2024-12-06T00:00:00.000 | 2020-05-08T00:00:00.000 | 2024-08-09T00:00:00.000 | 1083724 | Manhattan | 147 |
| 1P16074 | Elevator | Active | 2021-10-02T00:00:00.000 | 2026 | 2026 | 2026-04-18T00:00:00.000 | 2025-04-24T00:00:00.000 | 2026-08-10T00:00:00.000 | 1015254 | Manhattan | 1375 |
| 1W548 | Accessibility Lift | Active | 1995-11-14T00:00:00.000 | 2025 | 2026 | 2026-09-17T00:00:00.000 | — | 2025-07-08T00:00:00.000 | 1031607 | Manhattan | 300 |
| 1P23480 | Elevator | Active | 1991-11-01T00:00:00.000 | 2026 | 2025 | 2025-09-20T00:00:00.000 | 2023-04-18T00:00:00.000 | 2026-06-03T00:00:00.000 | 1036206 | Manhattan | 485 |
| 1P0986603 | Elevator | Active | 2018-09-21T00:00:00.000 | 2026 | 2025 | 2025-06-12T00:00:00.000 | 2024-11-14T00:00:00.000 | 2026-05-27T00:00:00.000 | 1024727 | Manhattan | 1535 |
Showing 12 of 24 columns. All of them are listed below.
2020-11-11T00:00:00.0002009-01-15T00:00:00.000equipment_type | text | The specific type of elevator equipment | 84% | ElectricElevatorsHydraulicElevatorsPlatformStairwayChairLif… |
periodic_report_year | categorical | The year of the periodic report filing | 27% | 202620252024of 7 |
cat1_report_year | text | The reporting year for the Category 1 report | 21% | 202620252024 |
cat1_latest_report_filed | datetime | The latest filing date of the Category 1 report | 21% | 2025-12-30T00:00:00.0002026-06-30T00:00:00.0002025-12-31T00:00:00.000 |
cat5_latest_report_filed | datetime | The latest filing date of the Category 5 report | 35% | 2016-06-01T00:00:00.0001960-01-01T00:00:00.0002021-12-17T00:00:00.000 |
periodic_latest_inspection | datetime | The most recent date of inspection | 27% | 2026-04-15T00:00:00.0002026-04-14T00:00:00.0002026-03-18T00:00:00.000 |
bin | text | Building Identification Number assigned by Department of City Planning | 0% | 108896110263181813360 |
borough | categorical | A name to indicate the NYC borough where the proposed work will take place | 0% | ManhattanBrooklynQueensof 5 |
house_number | text | The house number for the building owner's address. | 0% | 120010 |
street_name | text | The street name for the building owner's address. | 0% | BROADWAY5 AVENUEPARK AVENUE |
block | text | Tax Block assigned to the location of the proposed work by the Department of Finance. | 0% | 167021171 |
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% | 100011001910022 |
latitude | float | Latitude of the building's location | 1% | 40.75304540.76757140.755641 |
longitude | float | Longitude of the building's location | 1% | -74.000282-73.982249-73.975109 |
communitydistrict | text | The Community Board field indicates the New York City Community District where the building is located | 1% | 105101108 |
citycouncildistrict | text | The Council District field indicates the New York City Council District where the building is located | 1% | 040301 |
bbl | text | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City | 2% | 100702750110097200011010497501 |
censustract | text | The Census Tract (Census 2020) field indicates the U.S. Census Tract where the building is located. Please note that as part of the geocoding process, leading and trailing zeros are dropped | 1% | 72133 |
ntaname | text | The Neighborhood Tabulation Area (Census 2020) field indicates the New York City Neighborhood area where the building is located | 1% | Midtown-Times SquareMidtown South-Flatiron-U…Financial District-Batte… |