Dataset: E-Scooter Trips

About this Dataset

E-Scooter Trips

Electric scooter trips taken under the City of Chicago ongoing program. Similar datasets from the 2019 and 2020 pilot programs are at:

https://data.cityofchicago.org/d/2kfw-zvte (2019)
https://data.cityofchicago.org/d/3rse-fbp6 (2020)

Summary counts of trips between Census Tracts are provided in a separate dataset to allow for providing more data while still protecting privacy. See "E-Scooter Trips - Census Tract Summary" dataset (https://data.cityofchicago.org/d/cini-k95q).
Organization: City of Chicago
Last updated: 2023-07-29T09:49:51.579720
Tags: e-scooter, scooter, transportation

Tables

Table 1

@usgov.city_of_chicago_e_scooter_trips.table_1

486.62 MB
10515109 rows
16 columns


CREATE TABLE table_1 (
  "trip_id" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "trip_distance" BIGINT,
  "trip_duration" BIGINT,
  "vendor" VARCHAR,
  "start_community_area_number" DOUBLE,
  "end_community_area_number" DOUBLE,
  "start_community_area_name" VARCHAR,
  "end_community_area_name" VARCHAR,
  "start_centroid_latitude" DOUBLE,
  "start_centroid_longitude" DOUBLE,
  "start_centroid_location" VARCHAR,
  "end_centroid_latitude" DOUBLE,
  "end_centroid_longitude" DOUBLE,
  "end_centroid_location" VARCHAR
);