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-25 | 20 | 3 |
| MANHATTAN | 2019-01-25 | 20 | 3 |
| QUEENS | 2019-01-25 | 20 | 5 |
| BROOKLYN | 2019-01-25 | 21 | 4 |
| MANHATTAN | 2019-01-25 | 21 | 6 |
| QUEENS | 2019-01-25 | 21 | 7 |
| STATEN ISLAND | 2019-01-25 | 21 | 1 |
| BRONX | 2019-01-25 | 22 | 3 |
| BROOKLYN | 2019-01-25 | 22 | 8 |
| MANHATTAN | 2019-01-25 | 22 | 1 |
| QUEENS | 2019-01-25 | 22 | 3 |
| BRONX | 2019-01-25 | 23 | 2 |
| BROOKLYN | 2019-01-25 | 23 | 4 |
| MANHATTAN | 2019-01-25 | 23 | 2 |
| QUEENS | 2019-01-25 | 23 | 3 |
| BRONX | 2019-01-26 | 0 | 4 |
| BROOKLYN | 2019-01-26 | 0 | 6 |
| MANHATTAN | 2019-01-26 | 0 | 4 |
| QUEENS | 2019-01-26 | 0 | 6 |
| BRONX | 2019-01-26 | 1 | 3 |
| MANHATTAN | 2019-01-26 | 1 | 4 |
| QUEENS | 2019-01-26 | 1 | 1 |
| BRONX | 2019-01-26 | 2 | 1 |
| BROOKLYN | 2019-01-26 | 2 | 4 |
| MANHATTAN | 2019-01-26 | 2 | 2 |