From a 500-row sample across 22 columns.
bblbincouncil_district+3bblbinlongitude+1Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| open_data_crash_id | crash_date | crash_time | crash_police_precinct | crash_borough | total_non_severe_injuries | total_severe_injuries | total_fatalities | latitude | longitude | on_street | cross_street |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4492364 | 2022-01-01T00:00:00.000 | 01:28 | 46 | Bronx | 1 | 1 | 0 | 40.8587070 | -73.9037000 | JEROME AVENUE | EAST 183 STREET |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
open_data_crash_id | integer | Unique ID assigned to the crash event. | 3% | 459766647903664660857 |
crash_date | datetime | Date of the crash. | 3% | 2022-05-21T00:00:00.0002024-07-11T00:00:00.0002022-06-15T00:00:00.000 |
crash_time | text | Time of the crash. | 3% | 00:0015:0018:00 |
crash_police_precinct | integer | The police precinct number for the location of the crash. | 3% | 1097540 |
GET /api/datasets/xeqp-qz8h GET /api/datasets/xeqp-qz8h/quality GET /api/datasets/xeqp-qz8h/related GET /api/columns?dataset=xeqp-qz8h
on_streetbblbincouncil_district+5| 4491159 |
| 2022-01-01T00:00:00.000 |
| 04:33 |
| 46 |
| Bronx |
| 0 |
| 1 |
| 0 |
| — |
| — |
| JEROME AVENUE |
| — |
| 4491487 | 2022-01-01T00:00:00.000 | 05:55 | 47 | Bronx | 0 | 1 | 0 | 40.8715500 | -73.8642800 | — | — |
| 4491223 | 2022-01-01T00:00:00.000 | 10:42 | 43 | Bronx | 0 | 1 | 0 | 40.8236730 | -73.8723300 | BRONX RIVER PARKWAY | — |
| 4491418 | 2022-01-01T00:00:00.000 | 20:55 | 49 | Bronx | 0 | 1 | 0 | 40.8639450 | -73.8645200 | BOSTON ROAD | WALLACE AVENUE |
| 4491395 | 2022-01-02T00:00:00.000 | 00:32 | 41 | Bronx | 0 | 1 | 0 | — | — | E 163 STREET AND SOUTHERN BOULEVARD | — |
| 4491529 | 2022-01-02T00:00:00.000 | 01:22 | 52 | Bronx | 0 | 0 | 1 | 40.8822170 | -73.8804600 | EAST GUN HILL ROAD | DEKALB AVENUE |
| 4491605 | 2022-01-02T00:00:00.000 | 22:20 | 45 | Bronx | 1 | 1 | 0 | 40.8358270 | -73.8288040 | EDISON AVENUE | BAISLEY AVENUE |
| 4494322 | 2022-01-03T00:00:00.000 | 03:20 | 44 | Bronx | 1 | 1 | 0 | 40.8309940 | -73.9281160 | WEST 162 STREET | ANDERSON AVENUE |
| 4491685 | 2022-01-03T00:00:00.000 | 04:47 | 49 | Bronx | 1 | 1 | 0 | — | — | PELHAM PARKWAY NORTH | WHITE PLAINS ROAD |
Showing 12 of 22 columns. All of them are listed below.
crash_borough | categorical | The borough of the location of the crash. | 4% | BrooklynQueensManhattanof 5 |
total_non_severe_injuries | categorical | Number of crash injuries that are non-severe. | 3% | 012of 16 |
total_severe_injuries | categorical | Number of injuries resulting from the crash. | 3% | 102of 8 |
total_fatalities | categorical | Total number of fatalities resulting from the crash. | 3% | 012of 6 |
latitude | float | Total number of fatalities resulting from the crash. | 21% | 40.8156940.662780040.83648 |
longitude | float | The longitude coordinates in decimal degree for the location of the crash. | 21% | -73.9464900-73.8906860-73.9314 |
on_street | text | The street name for the location of the crash. | 22% | BROADWAYBELT PARKWAYMAJOR DEEGAN EXPRESSWAY |
cross_street | text | The closest cross street name for the location of the crash. | 41% | BROADWAY3 AVENUE3 AVE |
address | text | If available, the street address of the crash location. | 81% | 107 EAST DRIVE71 EAST DRIVE450 FLATBUSH AVEN… |
highway_reference_marker | text | The highway location reference marker for crashes on the freeway. | 92% | 295IX5M12017495IX5M14125907LX4M12071 |
zipcode | text | The five digit postal code for the location of the crash. | 41% | 112361120711212 |
similar_fatalities_severe | categorical | Number of fatalities and severe injuries resulting from crashes of the same type at the same location in the past three (3) years. | 13% | 012of 9 |
similar_fatalities_all | integer | Number of fatalities and injuries resulting from crashes of the same type at the same location in the past three (3) years. | 3% | 012 |
community_board | integer | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. | 72% | 105301212 |
council_district | integer | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. To find your own Council District, go here. | 72% | 3178 |
bin | integer | A unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 80% | 300000040000003428715 |
bbl | integer | A combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) -- designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 80% | 302110750110097200013075767501 |
census_tract_2020_ | integer | 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 | 72% | 143119222 |
neighborhood_tabulation_area_nta_2020_ | text | NTAs are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area.. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitively represent neighborhood boundaries. | 72% | MN0502BX0101MN0401 |