Historic HPMS Data (Universe) - 2006

CREATE TABLE table_1 (
  "year" BIGINT,
  "state_code" BIGINT,
  "is_metric" BIGINT,
  "county_code" BIGINT,
  "section_id" VARCHAR,
  "is_sample" BIGINT,
  "is_donut" BIGINT,
  "is_grouped" BIGINT,
  "lrs_id" VARCHAR,
  "begin_lrs" DOUBLE,
  "end_lrs" DOUBLE,
  "rural_urban" BIGINT,
  "sampling_tech" BIGINT,
  "urban_code" BIGINT,
  "nonatt_code" BIGINT,
  "f_system" BIGINT,
  "gf_system" BIGINT,
  "nhs" BIGINT,
  "unbuilt_facility" BIGINT,
  "inter_route_number" VARCHAR,
  "route_signing" BIGINT,
  "route_qualifier" BIGINT,
  "route_number" VARCHAR,
  "ownership" BIGINT,
  "special_systems" BIGINT,
  "type_facility" BIGINT,
  "truck_route" BIGINT,
  "toll" BIGINT,
  "section_length" DOUBLE,
  "donut_volume_group" BIGINT,
  "std_volume_group" DOUBLE,
  "aadt" BIGINT,
  "through_lanes" BIGINT,
  "iri" DOUBLE,
  "psr" DOUBLE,
  "hov" BIGINT,
  "surv_a" BIGINT,
  "surv_b" BIGINT,
  "surv_c" BIGINT,
  "surv_d" BIGINT,
  "surv_e" BIGINT,
  "surv_f" BIGINT,
  "surv_g" BIGINT,
  "surv_h" BIGINT,
  "surv_i" BIGINT
);