About this Dataset

E-Scooter Trips - 2020

Electric scooter trips taken during the 2020 Chicago pilot program. For more information on the pilot, see https://www.chicago.gov/scooters.

In contrast to the 2019 E-Scooters dataset (https://data.cityofchicago.org/d/2kfw-zvte), vendor names are included. Additionally, 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 - 2020" dataset (https://data.cityofchicago.org/d/3srm-twg4).
Organization: City of Chicago
Last updated: 2021-08-07T18:00:33.803396
Tags: 2020, e-scooter, scooter, transportation

Tables

Table 1

@usgov.city_of_chicago_e_scooter_trips_2020.table_1

31.84 MB
630,816 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
);