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 37 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
QUEENS2019-01-10197
BRONX2019-01-10204
BROOKLYN2019-01-10205
MANHATTAN2019-01-10202
QUEENS2019-01-10201
STATEN ISLAND2019-01-10201
BRONX2019-01-10212
BROOKLYN2019-01-10213
MANHATTAN2019-01-10212
QUEENS2019-01-10212
BRONX2019-01-10222
BROOKLYN2019-01-10225
MANHATTAN2019-01-10221
QUEENS2019-01-10223
BRONX2019-01-10233
BROOKLYN2019-01-10232
MANHATTAN2019-01-10231
QUEENS2019-01-10231
STATEN ISLAND2019-01-10231
BRONX2019-01-1102
BROOKLYN2019-01-1104
MANHATTAN2019-01-1101
QUEENS2019-01-1102
STATEN ISLAND2019-01-1101
BROOKLYN2019-01-1111