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