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 1 of 3
source_fileTEXTcolumn_nameTEXTmissingINTEGERrowsINTEGER
2019-01any column48848877696617
2019-01passenger_count286727696617
2019-01RatecodeID286727696617
2019-01store_and_fwd_flag286727696617
2019-01congestion_surcharge48848877696617
2019-02any column296637049370
2019-02passenger_count296637049370
2019-02RatecodeID296637049370
2019-02store_and_fwd_flag296637049370
2019-02congestion_surcharge296637049370
2019-03any column334747866620
2019-03passenger_count334747866620
2019-03RatecodeID334747866620
2019-03store_and_fwd_flag334747866620
2019-03congestion_surcharge334747866620
2019-04any column424567475949
2019-04passenger_count424567475949
2019-04RatecodeID424567475949
2019-04store_and_fwd_flag424567475949
2019-04congestion_surcharge424567475949
2019-05any column327707598445
2019-05passenger_count327707598445
2019-05RatecodeID327707598445
2019-05store_and_fwd_flag327707598445
2019-05congestion_surcharge327707598445