Historic HPMS Data (Universe) - 1990

CREATE TABLE table_1 (
  "data_year" BIGINT,
  "state_fips_code" BIGINT,
  "county_fips_code" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sampling_technique" BIGINT,
  "urbanized_area_code" BIGINT,
  "type_of_section" BIGINT,
  "section_identification" VARCHAR,
  "functional_class" BIGINT,
  "federal_aid_system" BIGINT,
  "route_signing" BIGINT,
  "federal_aid_system_status" BIGINT,
  "route_signing_1" BIGINT,
  "route_number" VARCHAR,
  "governmental_level_of_control" BIGINT,
  "federal_state_and_local_domain" BIGINT,
  "special_systems" BIGINT,
  "type_of_facility" BIGINT,
  "toll" BIGINT,
  "section_grouped_length" DOUBLE,
  "aadt" BIGINT,
  "number_of_through_lanes" BIGINT
);