Dataset: Ride Hailing Transaction

About this Dataset

Ride Hailing Transaction

This dataset contains synthetic data generated to simulate a ride-sharing platform's operations. It includes detailed records across four key tables: fact_rides, vouchers, drivers, and users.

fact_rides: Captures information about individual ride transactions, including ride IDs, timestamps, distances, durations, and fare amounts.
vouchers: Contains details about promotional vouchers, discount percentage, and dates.
drivers: Provides profiles of drivers, including their IDs, names, and vehicle details.
users: Includes user profiles.

This dataset is ideal for data analysis, machine learning model development, and exploration of trends and behaviors in a ride-sharing context. Since it's generated synthetically, it is free from privacy concerns, making it perfect for public use and academic research.

Tables

Fact Rides

@kaggle.galihwardiana_ride_hailing_transaction.fact_rides

1.32 MB
25003 rows
15 columns


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
);

Users

@kaggle.galihwardiana_ride_hailing_transaction.users

915.35 KB
11000 rows
9 columns


CREATE TABLE users (
  "user_id" BIGINT,
  "username" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "email" VARCHAR,
  "password_hash" VARCHAR,
  "phone_number" VARCHAR,
  "gender" VARCHAR,
  "created_at" TIMESTAMP
);

Vouchers

@kaggle.galihwardiana_ride_hailing_transaction.vouchers

32.38 KB
1000 rows
6 columns


CREATE TABLE vouchers (
  "voucher_code" VARCHAR,
  "discount_amount" DOUBLE,
  "start_date" BIGINT,
  "end_date" BIGINT,
  "updated_at" BIGINT,
  "discount_perc" BIGINT
);

Drivers

@kaggle.galihwardiana_ride_hailing_transaction.drivers

79.66 KB
1000 rows
9 columns


CREATE TABLE drivers (
  "driver_id" BIGINT,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "email" VARCHAR,
  "phone_number" VARCHAR,
  "car_make" VARCHAR,
  "car_model" VARCHAR,
  "license_plate" VARCHAR,
  "created_at" TIMESTAMP
);