Missing values by source file
Missing values per column in each monthly TLC file of 2019.
60 rows Download CSV
| source_fileTEXT | column_nameTEXT | missingINTEGER | rowsINTEGER |
|---|---|---|---|
| 2019-06 | any column | 30747 | 6971560 |
| 2019-06 | passenger_count | 30747 | 6971560 |
| 2019-06 | RatecodeID | 30747 | 6971560 |
| 2019-06 | store_and_fwd_flag | 30747 | 6971560 |
| 2019-06 | congestion_surcharge | 30747 | 6971560 |
| 2019-07 | any column | 33959 | 6310419 |
| 2019-07 | passenger_count | 33959 | 6310419 |
| 2019-07 | RatecodeID | 33959 | 6310419 |
| 2019-07 | store_and_fwd_flag | 33959 | 6310419 |
| 2019-07 | congestion_surcharge | 33959 | 6310419 |
| 2019-08 | any column | 33321 | 6073357 |
| 2019-08 | passenger_count | 33321 | 6073357 |
| 2019-08 | RatecodeID | 33321 | 6073357 |
| 2019-08 | store_and_fwd_flag | 33321 | 6073357 |
| 2019-08 | congestion_surcharge | 33321 | 6073357 |
| 2019-09 | any column | 34090 | 6567788 |
| 2019-09 | passenger_count | 34089 | 6567788 |
| 2019-09 | RatecodeID | 34089 | 6567788 |
| 2019-09 | store_and_fwd_flag | 34089 | 6567788 |
| 2019-09 | congestion_surcharge | 34090 | 6567788 |
| 2019-10 | any column | 46723 | 7213891 |
| 2019-10 | passenger_count | 46723 | 7213891 |
| 2019-10 | RatecodeID | 46723 | 7213891 |
| 2019-10 | store_and_fwd_flag | 46723 | 7213891 |
| 2019-10 | congestion_surcharge | 46723 | 7213891 |