Dataset: Cyclistic

About this Dataset

Cyclistic

Historical trip data available to the public. The Data
Each trip is anonymized and includes:

Trip start day and time
Trip end day and time
Trip start station
Trip end station
Rider type (Member, Single Ride, and Day Pass)
The data has been made available by
Motivate International Inc. under this https://divvybikes.com/data-license-agreement

Tables

N 202301 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202301_divvy_tripdata

9.19 MB
190301 rows
13 columns


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

N 202302 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202302_divvy_tripdata

7.03 MB
190445 rows
13 columns


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

N 202303 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202303_divvy_tripdata

12.91 MB
258678 rows
13 columns


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

N 202304 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202304_divvy_tripdata

21.02 MB
426590 rows
13 columns


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

N 202305 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202305_divvy_tripdata

30.02 MB
604827 rows
13 columns


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

N 202306 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202306_divvy_tripdata

35.42 MB
719618 rows
13 columns


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

N 202307 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202307_divvy_tripdata

37.26 MB
767650 rows
13 columns


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

N 202308 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202308_divvy_tripdata

37.37 MB
771693 rows
13 columns


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

N 202309 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202309_divvy_tripdata

32.43 MB
666371 rows
13 columns


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

N 202310 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202310_divvy_tripdata

25.72 MB
537113 rows
13 columns


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

N 202311 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202311_divvy_tripdata

17.86 MB
362518 rows
13 columns


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

N 202312 Divvy Tripdata

@kaggle.yomarisortiz_cyclistic.n_202312_divvy_tripdata

11.16 MB
224073 rows
13 columns


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