Name: Cleaned Divvy Bikeshare Datasets (Google Capstone)
Creator: Kaggle
License: https://opendatacommons.org/licenses/by/1-0/index.html

About this Dataset

Cleaned Divvy Bikeshare Datasets (Google Capstone)

These two datasets have been cleaned for use in the fictional "Cyclist" scenario outlined for the Google Data Analytics Certificate. This has been made public by Lyft Bikes and Scooters, LLC (“Bikeshare”), which operate the City of Chicago’s (“City”) Divvy bicycle sharing service.

The data has been made available by Motivate International Inc. under this license:
https://divvybikes.com/data-license-agreement

The original dataset can be found here:
https://divvy-tripdata.s3.amazonaws.com/index.html

Tables

Divvy 2019 Q1

@kaggle.grigricarter777_cleaned_divvy_bikeshare_datasets_googl_78057812.divvy_2019_q1

5.71 MB
365,069 rows
11 columns

CREATE TABLE divvy_2019_q1 (
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "start_station_id" BIGINT,
  "start_station_name" VARCHAR,
  "end_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "usertype" VARCHAR,
  "ride_length" VARCHAR,
  "weekday" BIGINT
);

Divvy 2020 Q1

@kaggle.grigricarter777_cleaned_divvy_bikeshare_datasets_googl_78057812.divvy_2020_q1

6.71 MB
426,770 rows
11 columns

CREATE TABLE divvy_2020_q1 (
  "start_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_date" TIMESTAMP,
  "end_time" VARCHAR,
  "start_station_id" BIGINT,
  "start_station_name" VARCHAR,
  "end_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "usertype" VARCHAR,
  "ride_length" VARCHAR,
  "weekday" BIGINT
);