Name: Historic HPMS Data (Universe) - 1988
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Historic HPMS Data (Universe) - 1988

Historic Highway Performance Monitoring System universe data for the year 1988
Organization: Department of Transportation
Last updated: 2022-07-20T06:13:01.400525
Tags: highway, highway-performance-monitoring, highway-performance-monitoring-system, highways, hpms

Tables

Table 1

@usgov.dot_gov_historic_hpms_data_universe_1988.table_1

10.33 MB
937,601 rows
22 columns

CREATE TABLE table_1 (
  "date_year" BIGINT,
  "state_fips_code" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sampling_technique" BIGINT,
  "urbanized_area_code" BIGINT,
  "federal_aid_system" BIGINT,
  "federal_aid_system_status" BIGINT,
  "route_signing" VARCHAR,
  "route_number" BIGINT,
  "governmental_level_of_control" BIGINT,
  "special_systems" BIGINT,
  "type_of_facility" BIGINT,
  "designated_truck_route_parkway" BIGINT,
  "toll" VARCHAR,
  "section_grouped_length" BIGINT,
  "aadt" BIGINT,
  "number_of_through_lanes" BIGINT,
  "unnamed_column" BIGINT,
  "unnamed_column_1" BIGINT,
  "unnamed_column_2" DOUBLE,
  "unnamed_column_3" BIGINT,
  "unnamed_column_4" BIGINT
);