About this Dataset

Strategic Measure Percent Change In Average Vehicle Travel Time Along Major City Corridors

This dataset supports measure M.A.5.b of SD 2023. The source of the data is the anonymous travel time data provided by third party vendor INRIX. Each row represents the average travel time for each hour in a day for major corridors on weekdays for each year. This dataset can be used to gain insight into the changes in average vehicle travel time along major City corridors.

View more details and insights related to this measure on the story page: https://data.austintexas.gov/stories/s/M-A-5-b-Percent-change-in-average-vehicle-travel-t/9f4v-kau2/
Organization: City of Austin
Last updated: 2020-11-12T13:28:43.158670
Tags: austin-transportation-department, city-of-austin, transportation

Tables

Table 1

@usgov.city_of_austin_strategic_measure_percent_change_in_ave_c34f9c4c.table_1

23.01 kB
6 rows
31 columns

CREATE TABLE table_1 (
  "time" VARCHAR,
  "n_12_00_am" DOUBLE  -- 12:00 AM,
  "n_1_00_am" DOUBLE  -- 1:00 AM,
  "n_2_00_am" DOUBLE  -- 2:00 AM,
  "n_3_00_am" DOUBLE  -- 3:00 AM,
  "n_4_00_am" DOUBLE  -- 4:00 AM,
  "n_5_00_am" DOUBLE  -- 5:00 AM,
  "n_6_00_am" DOUBLE  -- 6:00 AM,
  "n_7_00_am" DOUBLE  -- 7:00 AM,
  "n_8_00_am" DOUBLE  -- 8:00 AM,
  "n_9_00_am" DOUBLE  -- 9:00 AM,
  "n_10_00_am" DOUBLE  -- 10:00 AM,
  "n_11_00_am" DOUBLE  -- 11:00 AM,
  "n_12_00_pm" DOUBLE  -- 12:00 PM,
  "n_1_00_pm" DOUBLE  -- 1:00 PM,
  "n_2_00_pm" DOUBLE  -- 2:00 PM,
  "n_3_00_pm" DOUBLE  -- 3:00 PM,
  "n_4_00_pm" DOUBLE  -- 4:00 PM,
  "n_5_00_pm" DOUBLE  -- 5:00 PM,
  "n_6_00_pm" DOUBLE  -- 6:00 PM,
  "n_7_00_pm" DOUBLE  -- 7:00 PM,
  "n_8_00_pm" DOUBLE  -- 8:00 PM,
  "n_9_00_pm" DOUBLE  -- 9:00 PM,
  "n_10_00_pm" DOUBLE  -- 10:00 PM,
  "n_11_00_pm" DOUBLE  -- 11:00 PM,
  "average_6_am_to_8_pm" DOUBLE,
  "year" BIGINT,
  "percent_change" DOUBLE,
  "year_date" TIMESTAMP,
  "date_uploaded" TIMESTAMP,
  "record_id" BIGINT
);