Name: Cyclistic Bike Share (divvy-tripdata)
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Cyclistic Bike Share (divvy-tripdata)

The data sources were downloaded from the divvy-tripdata repository on Amazon AWS: https://divvy-tripdata.s3.amazonaws.com/index.html
It was extracted 12 csv files, one per month, from 2020-09 to 2021-08, representing the previous 12 months.
The data is up to date and the accessibility is public to read and download but not to modify.

Tables

N 202009 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202009_divvy_tripdata

28.95 MB
532,958 rows
13 columns

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

N 202010 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202010_divvy_tripdata

22.14 MB
388,653 rows
13 columns

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

N 202011 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202011_divvy_tripdata

14.95 MB
259,716 rows
13 columns

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

N 202012 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202012_divvy_tripdata

7.25 MB
131,573 rows
13 columns

CREATE TABLE n_202012_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 202101 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202101_divvy_tripdata

5.45 MB
96,834 rows
13 columns

CREATE TABLE n_202101_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 202102 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202102_divvy_tripdata

2.77 MB
49,622 rows
13 columns

CREATE TABLE n_202102_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 202103 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202103_divvy_tripdata

11.59 MB
228,496 rows
13 columns

CREATE TABLE n_202103_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 202104 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202104_divvy_tripdata

17.36 MB
337,230 rows
13 columns

CREATE TABLE n_202104_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 202105 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202105_divvy_tripdata

27.23 MB
531,633 rows
13 columns

CREATE TABLE n_202105_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 202106 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202106_divvy_tripdata

37.68 MB
729,595 rows
13 columns

CREATE TABLE n_202106_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 202107 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202107_divvy_tripdata

41.64 MB
822,410 rows
13 columns

CREATE TABLE n_202107_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 202108 Divvy Tripdata

@kaggle.gustavofc_divvytripdata.n_202108_divvy_tripdata

40.43 MB
804,352 rows
13 columns

CREATE TABLE n_202108_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
);