Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

8.9 MB across 1 part, newest sealed 10 October 2026 at 23:50 UTC. The first build wrote 1 part and 370,752 rows.

All 7 checks passed.
  • Grain unique passed.
  • Hour in range passed.
  • Zone in range passed.
  • Zone named passed.
  • Fare present passed.
  • Daily continuity passed.
  • Enough rows passed.

company

string

The high-volume for-hire company that dispatched the trips: Uber, Lyft, Juno or Via.

  • Uber51%
  • Lyft49%
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

license_number

string

The TLC high-volume license number of the company, such as HV0003 for Uber and HV0005 for Lyft.

2 distinct values, no chart

Valid
370,752 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

pickup_date

date

The calendar day of pickup, in New York local time.

Timeline per month: 2026-08-01, 370,752
2026-08-01

per month

Valid
370,752 · 100%
Missing
0 · 0%
Distinct
31 · 0% of valid

pickup_hour

integer

The hour of pickup, 0 to 23, in New York local time.

Histogram: 0 to 1, 30,446; 2 to 3, 29,464; 4 to 5, 29,986; 6 to 7, 30,694; 8 to 9, 31,037; 10 to 11, 31,149; 12 to 13, 31,356; 14 to 15, 31,445; 16 to 17, 31,444; 18 to 19, 31,409; 20 to 21, 31,245; 22 to 23, 31,077
023
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
24 · 0% of valid
Min
0
25%
6
Median
12
75%
18
Max
23

pickup_zone_id

integer

The TLC taxi zone ID where the trips began, 1 to 265.

262 distinct values, no chart

Valid
370,752 · 100%
Missing
0 · 0%
Distinct
262 · 0.1% of valid
Min
1
25%
68
Median
136
75%
201
Max
265

borough

string

The borough of the pickup zone, from the TLC taxi zone lookup.

  • Queens26%
  • Manhattan26%
  • Brooklyn24%
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
7 · 0% of valid

zone_name

string

The name of the pickup zone, from the TLC taxi zone lookup.

  • Corona1%
  • Allerton/Pelham Gardens0%
  • Astoria0%
  • Other (249)
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
261 · 0.1% of valid

trips

integer

The number of trips that began in this zone, hour and company.

Histogram: 1 to 117, 325,222; 118 to 234, 37,073; 235 to 351, 5,994; 352 to 468, 1,379; 469 to 585, 583; 586 to 702, 302; 703 to 819, 149; 820 to 936, 50
1936
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
809 · 0.2% of valid
Min
1
25%
14
Median
34
75%
71
Max
936

shared_trips

integer

Trips where the rider asked to share and was matched with another rider.

Histogram: 0 to 5, 364,955; 6 to 10, 4,229; 11 to 15, 924; 16 to 20, 366; 21 to 26, 187; 27 to 31, 58; 32 to 36, 25; 37 to 41, 8
041
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
42 · 0% of valid
Min
0
25%
0
Median
0
75%
0
Max
41

trip_miles_total

decimal

The total passenger trip distance, in miles.

Histogram: 0.01 to 2119.8325000000004, 368,052; 2119.8325000000004 to 4239.6550000000007, 1,513; 4239.6550000000007 to 6359.4775000000009, 551; 6359.4775000000009 to 8479.3000000000011, 305; 8479.3000000000011 to 10599.122500000001, 205; 10599.122500000001 to 12718.945000000002, 81; 12718.945000000002 to 14838.767500000002, 35; 14838.767500000002 to 16958.59, 10
0.0116958.59
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
85,074 · 22.9% of valid
Min
0.01
25%
65.65
Median
154.74
75%
323.30
Max
16958.59

trip_minutes_total

decimal

The total passenger trip time, in minutes.

Histogram: 0.02 to 6480.8212500000009, 366,166; 6480.8212500000009 to 12961.622500000001, 3,475; 12961.622500000001 to 19442.423750000002, 611; 19442.423750000002 to 25923.225000000002, 301; 25923.225000000002 to 32404.026250000003, 142; 32404.026250000003 to 38884.827499999999, 43; 38884.827499999999 to 45365.628749999996, 12; 45365.628749999996 to 51846.43, 2
0.0251846.43
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
142,707 · 38.5% of valid
Min
0.02
25%
222.12
Median
572.37
75%
1279.80
Max
51846.43

base_fare_total_usd

decimal

The total base passenger fare, in US dollars, before taxes, tolls and fees.

Histogram: 0 to 10307.188749999999, 366,600; 10307.188749999999 to 20614.377499999999, 2,850; 20614.377499999999 to 30921.566249999996, 550; 30921.566249999996 to 41228.754999999997, 376; 41228.754999999997 to 51535.943749999999, 252; 51535.943749999999 to 61843.132499999992, 94; 61843.132499999992 to 72150.321249999994, 24; 72150.321249999994 to 82457.509999999995, 6
0.0082457.51
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
207,139 · 55.9% of valid
Min
0.00
25%
315.71
Median
769.60
75%
1665.84
Max
82457.51

tips_total_usd

decimal

The total tips paid to drivers, in US dollars.

Histogram: 0 to 815.25125000000003, 368,154; 815.25125000000003 to 1630.5025000000001, 1,654; 1630.5025000000001 to 2445.7537499999999, 439; 2445.7537499999999 to 3261.0050000000001, 322; 3261.0050000000001 to 4076.2562500000004, 141; 4076.2562500000004 to 4891.5074999999997, 32; 4891.5074999999997 to 5706.75875, 9; 5706.75875 to 6522.0100000000002, 1
0.006522.01
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
37,876 · 10.2% of valid
Min
0.00
25%
7.00
Median
23.77
75%
68.40
Max
6522.01

driver_pay_total_usd

decimal

The total driver pay, in US dollars, excluding tips.

Histogram: 0 to 7840.9549999999999, 367,082; 7840.9549999999999 to 15681.91, 2,499; 15681.91 to 23522.864999999998, 558; 23522.864999999998 to 31363.82, 336; 31363.82 to 39204.775000000001, 193; 39204.775000000001 to 47045.729999999996, 59; 47045.729999999996 to 54886.684999999998, 23; 54886.684999999998 to 62727.639999999999, 2
0.0062727.64
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
188,216 · 50.8% of valid
Min
0.00
25%
247.98
Median
615.28
75%
1346.05
Max
62727.64

base_fare_avg_usd

decimal

The average base passenger fare per trip, in US dollars, before taxes, tolls and fees.

Histogram: 0 to 30.97625, 303,943; 30.97625 to 61.952500000000001, 63,077; 61.952500000000001 to 92.928750000000008, 3,216; 92.928750000000008 to 123.905, 434; 123.905 to 154.88124999999999, 53; 154.88124999999999 to 185.85750000000002, 14; 185.85750000000002 to 216.83375000000001, 8; 216.83375000000001 to 247.81, 7
0.00247.81
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
7,998 · 2.2% of valid
Min
0.00
25%
18.69
Median
22.28
75%
28.16
Max
247.81

trip_miles_avg

decimal

The average trip distance, in miles.

Histogram: 0.01 to 9.6624999999999996, 355,624; 9.6624999999999996 to 19.315000000000001, 13,978; 19.315000000000001 to 28.967500000000001, 1,024; 28.967500000000001 to 38.619999999999997, 88; 38.619999999999997 to 48.272500000000001, 25; 48.272500000000001 to 57.924999999999997, 6; 57.924999999999997 to 67.577500000000001, 4; 67.577500000000001 to 77.230000000000004, 3
0.0177.23
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
2,516 · 0.7% of valid
Min
0.01
25%
3.61
Median
4.48
75%
5.68
Max
77.23

trip_minutes_avg

decimal

The average trip time, in minutes.

Histogram: 0.02 to 14.08, 80,402; 14.08 to 28.140000000000001, 278,680; 28.140000000000001 to 42.200000000000003, 9,791; 42.200000000000003 to 56.260000000000005, 1,404; 56.260000000000005 to 70.319999999999993, 416; 70.319999999999993 to 84.379999999999995, 43; 84.379999999999995 to 98.439999999999998, 13; 98.439999999999998 to 112.5, 3
0.02112.50
Valid
370,752 · 100%
Missing
0 · 0%
Distinct
5,145 · 1.4% of valid
Min
0.02
25%
14.47
Median
17.03
75%
20.00
Max
112.50

Table profile

Profile of the served version, all rows, computed 16 Nov 2026, 17:34 UTC

WarningFreshnessLatest event 41 d before this version
PassedGapsNo empty days
PassedAnomaliesNo spikes or dips
PassedUnique keysEvery company · pickup_date · pickup_hour · pickup_zone_id is unique
Rows per day
Rows per day, 31 buckets from 1 Aug 2026 to 31 Aug 2026, at most 12,099 rows.20k1 Aug 2026: 12,099 rows2 Aug 2026: 12,040 rows3 Aug 2026: 11,914 rows4 Aug 2026: 11,910 rows5 Aug 2026: 11,935 rows6 Aug 2026: 11,924 rows7 Aug 2026: 11,978 rows8 Aug 2026: 12,063 rows9 Aug 2026: 12,052 rows10 Aug 2026: 11,949 rows11 Aug 2026: 11,888 rows12 Aug 2026: 11,888 rows13 Aug 2026: 11,948 rows14 Aug 2026: 11,971 rows15 Aug 2026: 12,027 rows16 Aug 2026: 12,022 rows17 Aug 2026: 11,891 rows18 Aug 2026: 11,901 rows19 Aug 2026: 11,925 rows20 Aug 2026: 11,913 rows21 Aug 2026: 11,945 rows22 Aug 2026: 12,044 rows23 Aug 2026: 12,006 rows24 Aug 2026: 11,920 rows25 Aug 2026: 11,891 rows26 Aug 2026: 11,891 rows27 Aug 2026: 11,881 rows28 Aug 2026: 11,966 rows29 Aug 2026: 12,059 rows30 Aug 2026: 12,037 rows31 Aug 2026: 11,874 rows
Rows per day by company · pickup_hour · pickup_zone_id, 10 of 12,403
Rows per day by company · pickup_hour · pickup_zone_id, 10 of 12,403, with the share of days that have rows on the right.Lyft · 0 · 3100%Lyft · 0 · 4100%Lyft · 0 · 7100%Lyft · 0 · 10100%Lyft · 0 · 13100%Lyft · 0 · 14100%Lyft · 0 · 16100%Lyft · 0 · 17100%Lyft · 0 · 18100%Lyft · 0 · 20100%Lyft · 0 · 3: 31 rows, 0 of 31 buckets emptyLyft · 0 · 4: 31 rows, 0 of 31 buckets emptyLyft · 0 · 7: 31 rows, 0 of 31 buckets emptyLyft · 0 · 10: 31 rows, 0 of 31 buckets emptyLyft · 0 · 13: 31 rows, 0 of 31 buckets emptyLyft · 0 · 14: 31 rows, 0 of 31 buckets emptyLyft · 0 · 16: 31 rows, 0 of 31 buckets emptyLyft · 0 · 17: 31 rows, 0 of 31 buckets emptyLyft · 0 · 18: 31 rows, 0 of 31 buckets emptyLyft · 0 · 20: 31 rows, 0 of 31 buckets empty1 Aug8 Aug15 Aug22 Aug

Support

Talk to Mostly Right

Loading chat…