Baselight

Divvy Trips 2020 Q1 Dataset (Raw)

Raw trip data from Chicago’s Divvy bike-share system for(2019 Q1, 2020 Q1)

@kaggle.hamzajawad123_divvy_trips_2020_q1_datasets

Loading...
Loading...

About this Dataset

Divvy Trips 2020 Q1 Dataset (Raw)

This dataset contains the raw trip-level data for the first quarter of 2020 from the Divvy bike-share program in Chicago.

Coverage

  • January 1, 2020 – March 31, 2020

Content

  • Each row represents one ride, including:
    • Start time
    • End time
    • Station IDs
    • Bike type
    • Rider type

Purpose

This raw data is provided for cleaning, transformation, and analysis.
It has not been modified, so issues such as missing values, duplicates, or inconsistent formatting may exist.

This dataset is useful for:

  • Practicing data cleaning and preprocessing
  • Performing exploratory data analysis (EDA)
  • Comparing raw vs. cleaned datasets in a portfolio project

Tables

Divvy Trips 2020 Q1

@kaggle.hamzajawad123_divvy_trips_2020_q1_datasets.divvy_trips_2020_q1
  • 20.37 MB
  • 426,887 rows
  • 13 columns
Loading...
CREATE TABLE divvy_trips_2020_q1 (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" BIGINT,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "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.