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 52 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
QUEENS2019-01-141711
STATEN ISLAND2019-01-14171
BRONX2019-01-14186
BROOKLYN2019-01-141812
MANHATTAN2019-01-14186
QUEENS2019-01-14188
STATEN ISLAND2019-01-14184
BRONX2019-01-14195
BROOKLYN2019-01-141911
MANHATTAN2019-01-14192
QUEENS2019-01-14193
BRONX2019-01-14204
BROOKLYN2019-01-14204
MANHATTAN2019-01-14203
QUEENS2019-01-14207
BRONX2019-01-14211
BROOKLYN2019-01-14214
MANHATTAN2019-01-14213
QUEENS2019-01-14211
BRONX2019-01-14222
BROOKLYN2019-01-14223
MANHATTAN2019-01-14222
QUEENS2019-01-14221
BROOKLYN2019-01-14233
MANHATTAN2019-01-14231