Historic HPMS Data (Universe) - 1998

CREATE TABLE table_1 (
  "year" BIGINT,
  "state" BIGINT,
  "metric_english" BIGINT,
  "county" BIGINT,
  "section_id" VARCHAR,
  "has_sample" BIGINT,
  "has_hov" BIGINT,
  "has_suveil" BIGINT,
  "is_donut" BIGINT,
  "lrs_id" VARCHAR,
  "begin_lrs" DOUBLE,
  "end_lrs" DOUBLE,
  "type_section" BIGINT,
  "rural_urban" BIGINT,
  "urbanized_sample" BIGINT,
  "urbanized_code" BIGINT,
  "nonattainment_area_code" BIGINT,
  "functional_system" BIGINT,
  "gen_functional_system" BIGINT,
  "national_highway_system" BIGINT,
  "unbuilt_facility" BIGINT,
  "official_inter_rt_num" DOUBLE,
  "route_signing" BIGINT,
  "route_qualifier" BIGINT,
  "signed_route_number" VARCHAR,
  "governmental_ownership" BIGINT,
  "special_system" BIGINT,
  "type_facility" BIGINT,
  "designated_truck_route" BIGINT,
  "toll" BIGINT,
  "section_length" DOUBLE,
  "donut_aadt_volume" BIGINT,
  "standard_aadt_volume" BIGINT,
  "aadt" BIGINT,
  "aadt_derivation" BIGINT,
  "number_lanes" BIGINT,
  "urban_location" BIGINT,
  "access_control" BIGINT,
  "median_type" BIGINT,
  "median_width" BIGINT,
  "roughness" BIGINT,
  "pavement_condition" DOUBLE
);