About this Dataset

Shared Micromobility Vehicle Trips (2018-2022)

Effective March 1st, 2022, this dataset is no longer maintained. For current micromobility data, please refer to our 3rd-party data provider's dashboard: https://public.ridereport.com/austin.

Please note: Only aggregated data is currently available for micromobility trips. For several reasons, including privacy concerns, individual trip data is no longer being collected.

This dataset contains shared micromobility vehicle trip data reported to the City of Austin Transportation and Public Works Department as part of the Shared Small Vehicle Mobility Systems operating rules.

Note that our official trip reporting metrics only include trips which meet the following criteria:
- Trip distance greater than or equal to 0.1 miles and less than 500 miles
- Trip duration less than 24 hours

Read more at about Austin's dockless mobility services at https://austintexas.gov/micromobility
Organization: City of Austin
Last updated: 2020-11-12T13:22:56.184033
Tags: bicycles, bikes, dockless, e-bike, micromobility, mobility, scooters, tpw, transportation, trips

Tables

Table 1

@usgov.city_of_austin_shared_micromobility_vehicle_trips.table_1

794.92 MB
15,048,635 rows
18 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "device_id" VARCHAR,
  "vehicle_type" VARCHAR,
  "trip_duration" BIGINT,
  "trip_distance" DOUBLE,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "modified_date" VARCHAR,
  "month" BIGINT,
  "hour" BIGINT,
  "day_of_week" BIGINT,
  "council_district_start" VARCHAR  -- Council District (Start),
  "council_district_end" VARCHAR  -- Council District (End),
  "year_us_central" BIGINT  -- Year (US/Central),
  "census_tract_start" VARCHAR,
  "census_tract_end" VARCHAR,
  "start_time_us_central" VARCHAR  -- Start Time (US/Central),
  "end_time_us_central" VARCHAR  -- End Time (US/Central)
);