Dataset: Public Bike Use Data 2014-2024 (MiBici)

About this Dataset

Public Bike Use Data 2014-2024 (MiBici)

This dataset includes data from the public shared bike service known as 'MiBici' in Guadalajara's metropolitan area (ZMG) in Jalisco, Mexico, from December 2014 to January 2024 (includes 110 months in total).

Contains data from 25,863,690 public bike trips and 372 public bike stations.

A data cleaning process was applied to the raw data to eliminate rows with empty cells, users under 16 years of age, and bike trips of less than one minute.
Also, two columns were added to show each users age ('Age') and the duration of each trip ('Duration').

The CSV file 'nomenclature_2024' contains the nomenclature of the different bike stations distributed throughout ZMG, their respective ID codes and coordinates.

*Note: * The encoding of both files is 'utf-8'.

Raw data was obtained directly from MiBici's official webpage:
https://www.mibici.net/es/datos-abiertos/

Tables

Nomenclature 2024

@kaggle.sebastianquirarte_over_9_years_of_real_public_bike_use_mibici.nomenclature_2024

24.46 KB
372 rows
7 columns


CREATE TABLE nomenclature_2024 (
  "id" BIGINT,
  "name" VARCHAR,
  "obcn" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "status" VARCHAR
);