Taxi Trip Data Through Payment

Taxi Trip Data Based on Payment

@kaggle.anandshaw2001_taxi_dataset

Table List

1 table(223.2 MB)

Taxi Datset

@kaggle.anandshaw2001_taxi_dataset.taxi_datset

223.2 MB
11916667 rows
18 columns

vendorid VendorID	tpep_pickup_datetime Tpep Pickup Datetime	tpep_dropoff_datetime Tpep Dropoff Datetime	passenger_count Passenger Count	trip_distance Trip Distance	ratecodeid RatecodeID	store_and_fwd_flag Store And Fwd Flag	pulocationid PULocationID	dolocationid DOLocationID	payment_type Payment Type	fare_amount Fare Amount	extra Extra	mta_tax Mta Tax	tip_amount Tip Amount	improvement_surcharge Improvement Surcharge	total_amount Total Amount	congestion_surcharge Congestion Surcharge
1	01/01/2020 12:28:15 AM	01/01/2020 12:33:03 AM	1	1.2	1	N	238	239	1	6	3	0.5	1.47	0.3	11.27	2.5
1	01/01/2020 12:35:39 AM	01/01/2020 12:43:04 AM	1	1.2	1	N	239	238	1	7	3	0.5	1.5	0.3	12.3	2.5
1	01/01/2020 12:47:41 AM	01/01/2020 12:53:52 AM	1	0.6	1	N	238	238	1	6	3	0.5	1	0.3	10.8	2.5
1	01/01/2020 12:55:23 AM	01/01/2020 01:00:14 AM	1	0.8	1	N	238	151	1	5.5	0.5	0.5	1.36	0.3	8.16
2	01/01/2020 12:01:58 AM	01/01/2020 12:04:16 AM	1		1	N	193	193	2	3.5	0.5	0.5		0.3	4.8
2	01/01/2020 12:09:44 AM	01/01/2020 12:10:37 AM	1	0.03	1	N	7	193	2	2.5	0.5	0.5		0.3	3.8
2	01/01/2020 12:39:25 AM	01/01/2020 12:39:29 AM	1		1	N	193	193	1	2.5	0.5	0.5	0.01	0.3	3.81
2	12/18/2019 03:27:49 PM	12/18/2019 03:28:59 PM	1		5	N	193	193	1	0.01				0.3	2.81	2.5
2	12/18/2019 03:30:35 PM	12/18/2019 03:31:35 PM	4		1	N	193	193	1	2.5	0.5	0.5		0.3	6.3	2.5
1	01/01/2020 12:29:01 AM	01/01/2020 12:40:28 AM	2	0.7	1	N	246	48	1	8	3	0.5	2.35	0.3	14.15	2.5


CREATE TABLE taxi_datset (
  "vendorid" VARCHAR,
  "tpep_pickup_datetime" VARCHAR,
  "tpep_dropoff_datetime" VARCHAR,
  "passenger_count" DOUBLE,
  "trip_distance" DOUBLE,
  "ratecodeid" DOUBLE,
  "store_and_fwd_flag" VARCHAR,
  "pulocationid" DOUBLE,
  "dolocationid" DOUBLE,
  "payment_type" DOUBLE,
  "fare_amount" DOUBLE,
  "extra" DOUBLE,
  "mta_tax" DOUBLE,
  "tip_amount" DOUBLE,
  "tolls_amount" DOUBLE,
  "improvement_surcharge" DOUBLE,
  "total_amount" DOUBLE,
  "congestion_surcharge" DOUBLE
);