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.

Missing values by source file

Missing values per column in each monthly TLC file of 2019.

dq_missing, page 2 of 3
source_fileTEXTcolumn_nameTEXTmissingINTEGERrowsINTEGER
2019-06any column307476971560
2019-06passenger_count307476971560
2019-06RatecodeID307476971560
2019-06store_and_fwd_flag307476971560
2019-06congestion_surcharge307476971560
2019-07any column339596310419
2019-07passenger_count339596310419
2019-07RatecodeID339596310419
2019-07store_and_fwd_flag339596310419
2019-07congestion_surcharge339596310419
2019-08any column333216073357
2019-08passenger_count333216073357
2019-08RatecodeID333216073357
2019-08store_and_fwd_flag333216073357
2019-08congestion_surcharge333216073357
2019-09any column340906567788
2019-09passenger_count340896567788
2019-09RatecodeID340896567788
2019-09store_and_fwd_flag340896567788
2019-09congestion_surcharge340906567788
2019-10any column467237213891
2019-10passenger_count467237213891
2019-10RatecodeID467237213891
2019-10store_and_fwd_flag467237213891
2019-10congestion_surcharge467237213891