crash-details.txt

                      column_name                       
--------------------------------------------------------
 crash_id
 record_type
 vehicle_id
 participant_id
 participant_display_seq
 vehicle_coded_seq
 participant_vehicle_seq
 serial_
 city_section_id
 urban_area_code
 functional_class_code
 nhs_flag
 highway_number
 highway_suffix
 roadway_number
 highway_component
 mileage_type
 connection_number
 linear_reference_system_lrs
 special_jurisdiction
 jurisdiction_group
 street_number
 nearest_intersecting_street_number
 intersection_sequence_number
 distance_from_intersection
 direction_from_intersection
 milepoint
 posted_speed_limit
 road_character
 off_roadway_flag
 intersection_type
 intersection_related_flag
 roundabout_flag
 driveway_related_flag
 number_of_lanes
 number_of_turning_legs
 median_type
 impact_location
 crash_type
 collision_type
 crash_severity
 weather_condition
 road_surface_condition
 light_condition
 traffic_control_device_tcd
 tcd_functional_flag
 investigating_agency
 crash_level_event_1_code
 crash_level_event_2_code
 crash_level_event_3_code
 crash_level_cause_1_code
 crash_level_cause_2_code
 crash_level_cause_3_code
 school_zone_indicator
 work_zone_indicator
 alcoholinvolved_flag
 drugs_involved_flag
 speed_involved_flag
 crash_level_hit__run_flag
 population_range_code
 road_control
 route_type
 route_number
 region_id
 district_id
 segment_marker_id
 segment_point_lrs_measure
 unlocatable_flag
 total_vehicle
 total_fatality
 total_serious_injury_inja
 total_moderate_injury_injb
 total_minor_injury_injc
 total_nonfatal_injury
 total_uninjured_children_age_0004
 total_uninjured_persons
 total_pedestrian
 total_pedestrian_fatality
 total_pedestrian_nonfatal_injury
 total_pedalcyclist
 total_pedalcyclist_fatality
 total_pedalcyclist_nonfatal_injury
 total_unknown_nonmotorist
 total_unknown_nonmotorist_fatality
 total_unknown_nonmotorist_injury
 total_vehicle_occupant
 total_persons_involved
 total_quantity_of_persons_using_safety_equipment_
 total_quantity_of_persons_not_using_safety_equipment
 total_quantity_of_persons_safety_equipment_use_unknown
 vehicle_ownership_code
 vehicle_special_use_code
 vehicle_type_code
 emergency_use_flag
 number_of_trailers
 vehicle_movement_code
 vehicle_travel_direction_from
 vehicle_travel_direction_to
 vehicle_action_code
 vehicle_cause_1_code
 vehicle_cause_2_code
 vehicle_cause_3_code
 vehicle_event_1_code
 vehicle_event_2_code
 vehicle_event_3_code
 vehicle_exceeded_posted_speed_flag
 vehicle_hit__run_flag
 safety_equipment_used_quantity
 safety_equipment_unused_quantity
 safety_equipment_use_unknown_quantity
 vehicle_occupant
 vehicle_striking_flag
 participant_type_code
 participant_hit__run_flag
 public_employee_flag
 sex
 age
 driver_license_status
 driver_residence
 injury_severity
 participant_safety_equipment_use_code
 airbag_deployment
 nonmotorist_movement_code
 nonmotorist_travel_direction_from
 nonmotorist_travel_direction_to
 nonmotorist_location
 participant_action
 participant_error_1_code
 participant_error_2_code
 participant_error_3_code
 participant_cause_1_code
 participant_cause_2_code
 participant_cause_3_code
 participant_event_1_code
 participant_event_2_code
 participant_event_3_code
 bac_test_results_code
 alcohol_use_reported
 drug_use_reported
 participant_striker_flag
 lat
 lon
 date
 geom
(144 rows)