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
  • 37.37 MB
  • 771693 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
  • 32.43 MB
  • 666371 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
  • 25.72 MB
  • 537113 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
  • 17.86 MB
  • 362518 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.16 MB
  • 224073 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.22 MB
  • 144873 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
  • 10.76 MB
  • 223164 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
  • 14.82 MB
  • 301687 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
  • 20.36 MB
  • 415025 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
  • 29.5 MB
  • 609493 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
  • 33.75 MB
  • 710721 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
  • 33.84 MB
  • 748962 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.