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 194 of 1309
boroughTEXTdateTEXThourINTEGERcollisionsINTEGER
BROOKLYN2019-02-2205
MANHATTAN2019-02-2201
QUEENS2019-02-2203
BRONX2019-02-2211
BROOKLYN2019-02-2211
MANHATTAN2019-02-2212
QUEENS2019-02-2213
QUEENS2019-02-2222
MANHATTAN2019-02-2233
BROOKLYN2019-02-2241
QUEENS2019-02-2242
BROOKLYN2019-02-2251
QUEENS2019-02-2252
BRONX2019-02-2261
BROOKLYN2019-02-2261
MANHATTAN2019-02-2261
QUEENS2019-02-2263
BRONX2019-02-2274
BROOKLYN2019-02-2274
MANHATTAN2019-02-2272
STATEN ISLAND2019-02-2271
BRONX2019-02-2285
BROOKLYN2019-02-2286
MANHATTAN2019-02-2284
QUEENS2019-02-2284