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 35 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
MANHATTAN2019-01-1082
QUEENS2019-01-1088
STATEN ISLAND2019-01-1081
BRONX2019-01-1091
BROOKLYN2019-01-1096
MANHATTAN2019-01-1098
QUEENS2019-01-1098
BRONX2019-01-10103
BROOKLYN2019-01-10107
MANHATTAN2019-01-10107
QUEENS2019-01-10107
BRONX2019-01-10113
BROOKLYN2019-01-10118
MANHATTAN2019-01-10113
QUEENS2019-01-10117
BRONX2019-01-10126
BROOKLYN2019-01-10128
MANHATTAN2019-01-10124
QUEENS2019-01-10127
BRONX2019-01-10132
BROOKLYN2019-01-10132
MANHATTAN2019-01-10134
QUEENS2019-01-10138
STATEN ISLAND2019-01-10131
BRONX2019-01-10147