Historic HPMS Data (Sample) - 1981

CREATE TABLE table_1 (
  "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,
  "federal_aid_system_status" BIGINT,
  "route_signing" BIGINT,
  "route_number" VARCHAR,
  "governmental_level_of_control" BIGINT,
  "federal_state_and_local_domain" BIGINT,
  "special_systems" BIGINT,
  "type_of_facility" BIGINT,
  "trucks_commercial_vehicles_designated_truck_route" BIGINT,
  "toll" BIGINT,
  "section_grouped_length" DOUBLE,
  "aadt" BIGINT,
  "number_of_through_lanes" BIGINT,
  "work_functional_class_code" BIGINT,
  "sample_number" VARCHAR,
  "sample_subdivision" BIGINT,
  "aadt_volume_group_identifier" BIGINT,
  "expansion_factor" DOUBLE,
  "surface_pavement_type" BIGINT,
  "pavement_section" BIGINT,
  "structural_number" DOUBLE,
  "pavement_condition" DOUBLE,
  "access_control" BIGINT,
  "lane_width" BIGINT,
  "approach_width" BIGINT,
  "shoulder_type" BIGINT,
  "right_shoulder_width" BIGINT,
  "left_shoulder_width" BIGINT,
  "median_type" BIGINT,
  "median_width" BIGINT,
  "existing_right_of_way_width" BIGINT,
  "is_widening_feasible" BIGINT,
  "horizontal_alignment_adequacy" BIGINT,
  "number_class_a_curves" BIGINT,
  "length_class_a_curves" DOUBLE,
  "number_class_b_curves" BIGINT,
  "length_class_b_curves" DOUBLE,
  "number_class_c_curves" BIGINT,
  "length_class_c_curves" DOUBLE,
  "number_class_d_curves" BIGINT,
  "length_class_d_curves" DOUBLE,
  "number_class_e_curves" BIGINT,
  "length_class_e_curves" DOUBLE,
  "number_class_f_curves" BIGINT,
  "length_class_f_curves" DOUBLE,
  "number_class_g_curves" BIGINT,
  "length_class_g_curves" DOUBLE,
  "number_class_h_curves" BIGINT,
  "length_class_h_curves" DOUBLE,
  "number_class_i_curves" BIGINT,
  "length_class_i_curves" DOUBLE,
  "number_class_j_curves" BIGINT,
  "length_class_j_curves" DOUBLE,
  "number_class_k_curves" BIGINT,
  "length_class_k_curves" DOUBLE,
  "number_class_l_curves" BIGINT,
  "length_class_l_curves" DOUBLE,
  "number_class_m_curves" BIGINT,
  "length_class_m_curves" DOUBLE,
  "vertical_alignment_adequacy" BIGINT,
  "number_class_a_grades" BIGINT,
  "length_class_a_grades" DOUBLE,
  "number_class_b_grades" BIGINT,
  "length_class_b_grades" DOUBLE,
  "number_class_c_grades" BIGINT,
  "length_class_c_grades" DOUBLE,
  "number_class_d_grades" BIGINT,
  "length_class_d_grades" DOUBLE,
  "number_class_e_grades" BIGINT,
  "length_class_e_grades" DOUBLE,
  "number_class_f_grades" BIGINT,
  "length_class_f_grades" DOUBLE,
  "percent_passing_sight_distance" BIGINT,
  "speed_limit" BIGINT,
  "weighted_design_speed" BIGINT,
  "peak_percent_trucks" BIGINT,
  "off_peak_percent_trucks" BIGINT,
  "k_factor" BIGINT,
  "directional_factor" BIGINT,
  "peak_capacity" BIGINT,
  "off_peak_capacity" BIGINT,
  "prevailing_type_of_signalization" BIGINT,
  "typical_percent_green_time" BIGINT,
  "peak_parking" BIGINT,
  "off_peak_parking" BIGINT,
  "future_aadt" BIGINT,
  "drainage_adequacy" BIGINT,
  "type_of_terrain" BIGINT,
  "type_of_development" BIGINT,
  "urban_location" BIGINT,
  "number_of_at_grade_intersections_signals" BIGINT
);