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