E-Scooter Trips - 2019 Pilot by US Government | Transportation and Logistics

About this Dataset

E-Scooter Trips - 2019 Pilot

Electronic scooter trips taken during the 2019 Chicago pilot program. For more information on the pilot, see https://www.chicago.gov/scooters.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:16.950925
Tags: 2019, e-scooter, link-to-article-present, scooter, transportation

Tables

Table 1

@usgov.city_of_chicago_e_scooter_trips_2019_pilot.table_1

33.72 MB
710839 rows
18 columns


CREATE TABLE table_1 (
  "trip_id" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "trip_distance" BIGINT,
  "trip_duration" BIGINT,
  "accuracy" BIGINT,
  "start_census_tract" DOUBLE,
  "end_census_tract" DOUBLE,
  "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
);