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 90 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BRONX2019-01-2502
BROOKLYN2019-01-2504
QUEENS2019-01-2502
MANHATTAN2019-01-2511
STATEN ISLAND2019-01-2511
BRONX2019-01-2531
QUEENS2019-01-2531
MANHATTAN2019-01-2541
BRONX2019-01-2552
BROOKLYN2019-01-2551
BRONX2019-01-2561
BROOKLYN2019-01-2565
MANHATTAN2019-01-2564
QUEENS2019-01-2563
BRONX2019-01-2572
BROOKLYN2019-01-2573
MANHATTAN2019-01-2573
QUEENS2019-01-2575
STATEN ISLAND2019-01-2571
BRONX2019-01-2589
BROOKLYN2019-01-25810
MANHATTAN2019-01-2587
QUEENS2019-01-2588
STATEN ISLAND2019-01-2582
BRONX2019-01-2596