About this Dataset

E-Scooter Trips - Census Tract Summary

Electric scooter trips taken under the Chicago's ongoing program, summarized by census tract. The similar dataset from the 2020 pilot program is at https://data.cityofchicago.org/d/3srm-twg4.

For privacy reasons, some Census Tracts (accounting for fewer than 4% of trips as of the 2022 data) corresponding to very-low-frequency combinations have been removed. Note that some other Census Tract values may be blank due to limitations in the source data or being outside Chicago.
Organization: City of Chicago
Last updated: 2023-07-29T09:51:24.700254
Tags: e-scooter, scooter, transportation

Tables

Table 1

@usgov.city_of_chicago_e_scooter_trips_census_tract_summary.table_1

4.41 MB
179,858 rows
15 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "start_census_tract" VARCHAR,
  "end_census_tract" VARCHAR,
  "trip_count" BIGINT,
  "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,
  "unique_id" VARCHAR
);