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 43 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BRONX2019-01-12102
BROOKLYN2019-01-12104
MANHATTAN2019-01-12103
QUEENS2019-01-12107
STATEN ISLAND2019-01-12101
BRONX2019-01-12111
BROOKLYN2019-01-12116
MANHATTAN2019-01-12118
QUEENS2019-01-12115
BRONX2019-01-12124
BROOKLYN2019-01-12127
MANHATTAN2019-01-12122
QUEENS2019-01-12128
STATEN ISLAND2019-01-12124
BRONX2019-01-12137
BROOKLYN2019-01-12136
MANHATTAN2019-01-12134
QUEENS2019-01-12137
STATEN ISLAND2019-01-12133
BRONX2019-01-12145
BROOKLYN2019-01-12143
MANHATTAN2019-01-12145
QUEENS2019-01-121411
STATEN ISLAND2019-01-12141
BRONX2019-01-12153