Dataset: Cyclistic 6 Month Data

About this Dataset

Cyclistic 6 Month Data

The data has been made available by Motivate International Inc. under this license. This is public data that you can use to explore how different customer types are using Cyclistic bikes. The name of the company and dataset don't match because Cyclistic is a hypothetical company used to build a scenario for analysis.

Please note that data-privacy issues prohibit you from using riders’ personally identifiable information. This means that you won’t be able to connect pass purchases to credit card numbers to determine the location of casual riders or if they have purchased multiple single passes.

Tables

Divvy Trips 2019 Q4

@kaggle.syedalibokhari_cyclistic_6_month_data.divvy_trips_2019_q4

12.25 MB
704054 rows
11 columns


CREATE TABLE divvy_trips_2019_q4 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "day_of_week" BIGINT,
  "end_time" TIMESTAMP,
  "ride_length" VARCHAR,
  "bikeid" BIGINT,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR
);

Divvy Trips 2020 Q1

@kaggle.syedalibokhari_cyclistic_6_month_data.divvy_trips_2020_q1

15.12 MB
426887 rows
15 columns


CREATE TABLE divvy_trips_2020_q1 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "day_of_week" BIGINT,
  "ended_at" TIMESTAMP,
  "ride_length" VARCHAR,
  "start_station_name" VARCHAR,
  "start_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);