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 65 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BRONX2019-01-1899
BROOKLYN2019-01-1899
MANHATTAN2019-01-18910
QUEENS2019-01-1893
STATEN ISLAND2019-01-1891
BRONX2019-01-18104
BROOKLYN2019-01-18109
MANHATTAN2019-01-18102
QUEENS2019-01-18103
STATEN ISLAND2019-01-18102
BRONX2019-01-18113
BROOKLYN2019-01-18115
MANHATTAN2019-01-18115
QUEENS2019-01-18114
BRONX2019-01-18122
BROOKLYN2019-01-18128
MANHATTAN2019-01-18127
QUEENS2019-01-18127
BRONX2019-01-18137
BROOKLYN2019-01-18135
MANHATTAN2019-01-18133
QUEENS2019-01-18139
BRONX2019-01-18147
BROOKLYN2019-01-18148
MANHATTAN2019-01-18146