Ride Hailing Transaction

Comprehensive Synthetic Data for Ride Hailing Analytics and Machine Learning

@kaggle.galihwardiana_ride_hailing_transaction

Table List

4 tables(2.32 MB)

Fact Rides

Users

Vouchers

Drivers

Fact Rides

@kaggle.galihwardiana_ride_hailing_transaction.fact_rides

1.32 MB
25003 rows
15 columns

ride_id Ride Id	customer_id Customer Id	driver_id Driver Id	start_location Start Location	end_location End Location	city City	country Country	ride_date Ride Date	ride_time Ride Time	ride_duration_minutes Ride Duration Minutes	fare_amount Fare Amount	ride_distance_miles Ride Distance Miles	payment_method Payment Method	voucher Voucher	rating Rating
5883	242	353	9 Ohio Avenue	2087 Oak Crossing	Lubień	Poland	Fri Oct 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	21:18	14	97.15	6.8	cash	nan	5
7978	7660	861	017 Raven Hill	1 Rockefeller Lane	Springfield	United States	Sun Jan 21 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	08:13	63	11.54	8.9	credit card	nan	3
7765	1235	892	60542 La Follette Road	3 Blackbird Pass	Ob’	Russia	Sat May 25 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	13:38	52	41.04	0.8	cash	nan	4
2106	10548	9	8 Fuller Park	649 Hooker Court	Chilmāri	Bangladesh	Sat Jun 29 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	21:27	12	66.56	10.1	mobile wallet	nan	2
8936	3087	66	365 Manufacturers Crossing	83 Superior Hill	Jixing	China	Mon May 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	01:06	78	32.56	3.5	credit card	nan	4
5014	7880	771	923 Hanover Drive	102 Pankratz Junction	Krasni Okny	Ukraine	Wed Jan 17 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	19:32	39	20.25	15.2	mobile wallet	nan	3
6009	6711	155	83 American Drive	3 Sheridan Terrace	Nyíregyháza	Hungary	Tue Feb 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	20:33	55	43.72	10.4	mobile wallet	nan	5
7217	8315	896	6361 Vera Lane	75 Schurz Hill	Aranhas	Portugal	Tue Aug 20 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	13:05	99	97.43	1.4	credit card	nan	4
6442	2838	238	7776 Harbort Plaza	614 Harbort Park	Linmansangan	Philippines	Wed Dec 11 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	15:39	16	15.05	4.7	credit card	nan	4
6232	10523	365	20 Straubel Trail	79 Dryden Place	Juatuba	Brazil	Wed Nov 27 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	17:05	9	26.09	17.1	credit card	456JKL	3


CREATE TABLE fact_rides (
  "ride_id" DOUBLE,
  "customer_id" DOUBLE,
  "driver_id" DOUBLE,
  "start_location" VARCHAR,
  "end_location" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "ride_date" TIMESTAMP,
  "ride_time" VARCHAR,
  "ride_duration_minutes" DOUBLE,
  "fare_amount" DOUBLE,
  "ride_distance_miles" DOUBLE,
  "payment_method" VARCHAR,
  "voucher" VARCHAR,
  "rating" DOUBLE
);