Name: Kristina's Bicycle Case Study Data: Google Capsto
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Kristina's Bicycle Case Study Data: Google Capsto

The data used for this project has been made available by Motivate International Inc. under the license.

Lyft Bikes and Scooters, LLC “Bikeshare.” City of Chicago’s City Divvy Bicycle Sharing Service. Index of bucket “divvy-tripdata.” Accessed July 3rd, 2024.
https://divvy-tripdata.s3.amazonaws.com/index.html

Tables

N 202305 Divvy Tripdata

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202305_divvy_tripdata

31.47 MB
604,827 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.kristinacramb_kristinas_bicycle_case_study_data.n_202306_divvy_tripdata

37.14 MB
719,618 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.kristinacramb_kristinas_bicycle_case_study_data.n_202307_divvy_tripdata

39.07 MB
767,650 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.kristinacramb_kristinas_bicycle_case_study_data.n_202308_divvy_tripdata

39.18 MB
771,693 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.kristinacramb_kristinas_bicycle_case_study_data.n_202309_divvy_tripdata

34.01 MB
666,371 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.kristinacramb_kristinas_bicycle_case_study_data.n_202310_divvy_tripdata

26.97 MB
537,113 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.kristinacramb_kristinas_bicycle_case_study_data.n_202311_divvy_tripdata

18.72 MB
362,518 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.kristinacramb_kristinas_bicycle_case_study_data.n_202312_divvy_tripdata

11.7 MB
224,073 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
);

N 202401 Divvy Tripdata

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202401_divvy_tripdata

7.57 MB
144,873 rows
13 columns

CREATE TABLE n_202401_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 202402 Divvy Tripdata

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202402_divvy_tripdata

11.29 MB
223,164 rows
13 columns

CREATE TABLE n_202402_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 202403 Divvy Tripdata

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202403_divvy_tripdata

15.54 MB
301,687 rows
13 columns

CREATE TABLE n_202403_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 202404 Divvy Tripdata

@kaggle.kristinacramb_kristinas_bicycle_case_study_data.n_202404_divvy_tripdata

21.35 MB
415,025 rows
13 columns

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