Historic HPMS Data (Universe) - 1980

CREATE TABLE table_1 (
  "data_year" BIGINT,
  "state_fips_code" BIGINT,
  "county_fips_code" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sampling_technique" VARCHAR,
  "urbanized_area_code" VARCHAR,
  "type_of_section" BIGINT,
  "section_identification" VARCHAR,
  "functional_class" BIGINT,
  "federal_aid_system" BIGINT,
  "federal_aid_system_status" VARCHAR,
  "route_signing" BIGINT,
  "route_number" VARCHAR,
  "governmental_level_of_control" BIGINT,
  "federal_state_and_local_domain" BIGINT  -- Federal, State And Local Domain,
  "special_systems" VARCHAR,
  "type_of_facility" VARCHAR,
  "trucks_commercial_vehicles_designated_truck_route" BIGINT,
  "toll" VARCHAR,
  "section_grouped_length" DOUBLE,
  "aadt" BIGINT,
  "number_of_through_lanes" BIGINT,
  "work_functional_class_code" BIGINT
);