Connecticut Fire Department Incidents (2012-2022)
State of Connecticut
@usgov.state_of_connecticut_connecticut_fire_department_incid_6bf24fa4
State of Connecticut
@usgov.state_of_connecticut_connecticut_fire_department_incid_6bf24fa4
CREATE TABLE table_1 (
"reporting_year" BIGINT,
"fire_department_header_key" VARCHAR,
"fire_department_name" VARCHAR,
"incident_date" TIMESTAMP,
"incident_number" DOUBLE,
"exposure_number" BIGINT,
"fire_department_station" VARCHAR,
"incident_type_code" DOUBLE,
"incident_type" VARCHAR,
"aid_given_or_received_code" VARCHAR,
"aid_given_or_received" VARCHAR,
"number_of_alarms" VARCHAR,
"alarm_date_and_time" VARCHAR,
"arrival_date_and_time" VARCHAR,
"incident_controlled_date_and_time" VARCHAR,
"last_unit_cleared_date_and_time" VARCHAR,
"fire_department_shift" VARCHAR,
"actions_taken_1" VARCHAR,
"actions_taken_2" VARCHAR,
"actions_taken_3" VARCHAR,
"number_of_suppression_apparatus" DOUBLE,
"number_of_suppression_personnel" DOUBLE,
"number_of_ems_apparatus" DOUBLE,
"number_of_ems_personnel" DOUBLE,
"number_of_other_apparatus" DOUBLE,
"number_of_other_personnel" DOUBLE,
"property_value" DOUBLE,
"propery_loss" DOUBLE,
"contents_value" DOUBLE,
"contents_loss" DOUBLE,
"fire_service_deaths" DOUBLE,
"fire_service_injuries" DOUBLE,
"other_fire_deaths" DOUBLE,
"other_fire_injuries" DOUBLE,
"detector_alerted_code" VARCHAR,
"detector_alerted_occupants" VARCHAR,
"hazardous_materials_released_code" VARCHAR,
"hazardous_materials_released" VARCHAR,
"mized_use_property_codes" VARCHAR,
"mixed_use_property" VARCHAR,
"property_use_code" VARCHAR,
"property_use" VARCHAR,
"incident_street_address" VARCHAR,
"incident_apartment_number" VARCHAR,
"incident_city" VARCHAR,
"incident_zip_code" VARCHAR,
"census_tract" DOUBLE,
"location" VARCHAR
);
Anyone who has the link will be able to view this.