Skip to content
TAXI NYC ’19, home

Optional

AI settings

Everything on this site works without AI. To try “Ask the data”, paste your own API key. Your browser sends it straight to the provider you pick. It is never sent to this site's server, never logged, and calls are billed to your account.

Provider
AI provider

Default. Cheapest and fastest; $1 / $5 per million input / output tokens.

No key saved for this provider. Create one at platform.claude.com. A key with a low spending limit is a good idea.

Collisions

NYPD motor-vehicle collisions per borough, day and hour (2021 BigQuery export).

32,705 rows Download CSV
collisions_hourly, page 32 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BROOKLYN2019-01-09128
MANHATTAN2019-01-09124
QUEENS2019-01-09126
BRONX2019-01-09134
BROOKLYN2019-01-09136
MANHATTAN2019-01-09133
QUEENS2019-01-091311
BRONX2019-01-09145
BROOKLYN2019-01-09143
MANHATTAN2019-01-09145
QUEENS2019-01-09147
STATEN ISLAND2019-01-09141
BRONX2019-01-09152
BROOKLYN2019-01-09159
MANHATTAN2019-01-09152
QUEENS2019-01-09153
STATEN ISLAND2019-01-09151
BRONX2019-01-09165
BROOKLYN2019-01-09165
MANHATTAN2019-01-09161
QUEENS2019-01-09167
STATEN ISLAND2019-01-09161
BRONX2019-01-09171
BROOKLYN2019-01-091711
MANHATTAN2019-01-09174