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 38 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
MANHATTAN2019-01-1111
BROOKLYN2019-01-1121
MANHATTAN2019-01-1121
QUEENS2019-01-1122
BROOKLYN2019-01-1141
QUEENS2019-01-1141
MANHATTAN2019-01-1151
QUEENS2019-01-1154
BRONX2019-01-1161
MANHATTAN2019-01-1162
QUEENS2019-01-1164
BRONX2019-01-1174
BROOKLYN2019-01-1174
MANHATTAN2019-01-1172
QUEENS2019-01-1177
STATEN ISLAND2019-01-1171
BRONX2019-01-1188
BROOKLYN2019-01-1185
MANHATTAN2019-01-1186
QUEENS2019-01-1188
STATEN ISLAND2019-01-1181
BRONX2019-01-1196
BROOKLYN2019-01-1198
MANHATTAN2019-01-1194
QUEENS2019-01-1199