Name: Cyclistic Bike-share
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Cyclistic Bike-share

These public datasets have been made available by Motivate International Inc. which you can use to explore how different customer types are using Cyclistic bikes. But note that data-privacy issues prohibit you from using riders’ personally identiable information.This means that you won’t be able to connect pass purchases to credit card numbers to determine if casual riders live in the Cyclistic service area or if they have purchased multiple single passes.

Tables

Divvy Trips 2019 Q1

@kaggle.bernardberginald_cyclistic_bike_share.divvy_trips_2019_q1

12.1 MB
365,069 rows
12 columns

CREATE TABLE divvy_trips_2019_q1 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" DOUBLE,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE
);

Divvy Trips 2020 Q1

@kaggle.bernardberginald_cyclistic_bike_share.divvy_trips_2020_q1

20.37 MB
426,887 rows
13 columns

CREATE TABLE divvy_trips_2020_q1 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "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
);