Collisions
NYPD motor-vehicle collisions per borough, day and hour (2021 BigQuery export).
32,705 rows Download CSV
| boroughTEXT | dateTEXT | hourINTEGER | collisionsINTEGER |
|---|---|---|---|
| QUEENS | 2019-01-14 | 23 | 2 |
| BRONX | 2019-01-15 | 0 | 2 |
| BROOKLYN | 2019-01-15 | 0 | 4 |
| MANHATTAN | 2019-01-15 | 0 | 2 |
| QUEENS | 2019-01-15 | 1 | 2 |
| BRONX | 2019-01-15 | 2 | 1 |
| BROOKLYN | 2019-01-15 | 2 | 2 |
| MANHATTAN | 2019-01-15 | 2 | 1 |
| STATEN ISLAND | 2019-01-15 | 3 | 1 |
| BROOKLYN | 2019-01-15 | 4 | 1 |
| MANHATTAN | 2019-01-15 | 4 | 1 |
| QUEENS | 2019-01-15 | 4 | 1 |
| BRONX | 2019-01-15 | 5 | 1 |
| QUEENS | 2019-01-15 | 5 | 2 |
| BRONX | 2019-01-15 | 6 | 1 |
| BROOKLYN | 2019-01-15 | 6 | 2 |
| MANHATTAN | 2019-01-15 | 6 | 2 |
| QUEENS | 2019-01-15 | 6 | 4 |
| BRONX | 2019-01-15 | 7 | 4 |
| BROOKLYN | 2019-01-15 | 7 | 4 |
| MANHATTAN | 2019-01-15 | 7 | 3 |
| QUEENS | 2019-01-15 | 7 | 6 |
| STATEN ISLAND | 2019-01-15 | 7 | 1 |
| BRONX | 2019-01-15 | 8 | 5 |
| BROOKLYN | 2019-01-15 | 8 | 12 |