{"slug":"nyc.2019_yellow_taxi_trip_data","dataset_type_slug":"2019_yellow_taxi_trip_data","city_id":"nyc","api_description":"Civic dataset from NYC Open Data, migrated 2026-04-19.","storage_backend":"ducklake","ducklake_table_name":"nyc__2019_yellow_taxi_trip_data","row_count":84155513,"byte_size":null,"last_updated":"2026-04-19T16:17:51.064733+00:00","schema":[{"name":"id","type":"BIGINT","nullable":true},{"name":"vendorid","type":"VARCHAR","nullable":true},{"name":"tpep_pickup_datetime","type":"VARCHAR","nullable":true},{"name":"tpep_dropoff_datetime","type":"VARCHAR","nullable":true},{"name":"passenger_count","type":"VARCHAR","nullable":true},{"name":"trip_distance","type":"VARCHAR","nullable":true},{"name":"ratecodeid","type":"VARCHAR","nullable":true},{"name":"store_and_fwd_flag","type":"VARCHAR","nullable":true},{"name":"pulocationid","type":"VARCHAR","nullable":true},{"name":"dolocationid","type":"VARCHAR","nullable":true},{"name":"payment_type","type":"VARCHAR","nullable":true},{"name":"fare_amount","type":"VARCHAR","nullable":true},{"name":"extra","type":"VARCHAR","nullable":true},{"name":"mta_tax","type":"VARCHAR","nullable":true},{"name":"tip_amount","type":"VARCHAR","nullable":true},{"name":"tolls_amount","type":"VARCHAR","nullable":true},{"name":"improvement_surcharge","type":"VARCHAR","nullable":true},{"name":"total_amount","type":"VARCHAR","nullable":true},{"name":"bbl","type":"VARCHAR","nullable":true},{"name":"city_id","type":"VARCHAR","nullable":true},{"name":"created_at","type":"TIMESTAMP WITH TIME ZONE","nullable":true},{"name":"congestion_surcharge","type":"VARCHAR","nullable":true}]}