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 34 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BROOKLYN2019-01-1005
MANHATTAN2019-01-1002
QUEENS2019-01-1002
BRONX2019-01-1011
MANHATTAN2019-01-1013
QUEENS2019-01-1011
QUEENS2019-01-1021
MANHATTAN2019-01-1031
QUEENS2019-01-1032
BRONX2019-01-1041
BROOKLYN2019-01-1042
QUEENS2019-01-1041
BRONX2019-01-1051
BROOKLYN2019-01-1051
MANHATTAN2019-01-1053
QUEENS2019-01-1051
BRONX2019-01-1061
BROOKLYN2019-01-1063
QUEENS2019-01-1061
BRONX2019-01-1071
BROOKLYN2019-01-1073
MANHATTAN2019-01-1072
QUEENS2019-01-1075
BRONX2019-01-1084
BROOKLYN2019-01-10811