Baselight
Sign In

Divvy Trip Data August 2023 - July 2024

Google Data Analytics Professional Certificate Case Study 1

@kaggle.clemensgersmann_divvy_trip_data_august_2023_july_2024

Loading...
Loading...

About this Dataset

Divvy Trip Data August 2023 - July 2024

This data was downloaded from https://divvy-tripdata.s3.amazonaws.com/index.html where Divvy offer their trip data for Chicago bicycle rentals under the following licence: https://divvybikes.com/data-license-agreement. The data used for this project is from the 12 months period of August 2023 - July 2024.

Tables

N 202308 Divvy Tripdata

@kaggle.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202308_divvy_tripdata
  • 39.18 MB
  • 771,693 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202309_divvy_tripdata
  • 34.01 MB
  • 666,371 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202310_divvy_tripdata
  • 26.97 MB
  • 537,113 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202311_divvy_tripdata
  • 18.72 MB
  • 362,518 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202312_divvy_tripdata
  • 11.7 MB
  • 224,073 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202401_divvy_tripdata
  • 7.57 MB
  • 144,873 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202402_divvy_tripdata
  • 11.29 MB
  • 223,164 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202403_divvy_tripdata
  • 15.54 MB
  • 301,687 rows
  • 13 columns
Loading... 
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.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202404_divvy_tripdata
  • 21.35 MB
  • 415,025 rows
  • 13 columns
Loading... 
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
);

N 202405 Divvy Tripdata

@kaggle.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202405_divvy_tripdata
  • 30.93 MB
  • 609,493 rows
  • 13 columns
Loading... 
CREATE TABLE n_202405_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 202406 Divvy Tripdata

@kaggle.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202406_divvy_tripdata
  • 35.39 MB
  • 710,721 rows
  • 13 columns
Loading... 
CREATE TABLE n_202406_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 202407 Divvy Tripdata

@kaggle.clemensgersmann_divvy_trip_data_august_2023_july_2024.n_202407_divvy_tripdata
  • 35.48 MB
  • 748,962 rows
  • 13 columns
Loading... 
CREATE TABLE n_202407_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
);

Share link

Anyone who has the link will be able to view this.