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 264 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BROOKLYN2019-03-121710
MANHATTAN2019-03-12174
QUEENS2019-03-121710
BRONX2019-03-12184
BROOKLYN2019-03-12189
MANHATTAN2019-03-12186
QUEENS2019-03-12182
STATEN ISLAND2019-03-12181
BROOKLYN2019-03-12195
MANHATTAN2019-03-12191
QUEENS2019-03-12192
STATEN ISLAND2019-03-12192
BRONX2019-03-12201
BROOKLYN2019-03-12203
MANHATTAN2019-03-12204
QUEENS2019-03-12206
BRONX2019-03-12212
BROOKLYN2019-03-12214
QUEENS2019-03-12211
STATEN ISLAND2019-03-12211
BROOKLYN2019-03-12222
MANHATTAN2019-03-12222
QUEENS2019-03-12223
BROOKLYN2019-03-12234
MANHATTAN2019-03-12235