Iowa Fire Department Census
State of Iowa
@usgov.state_of_iowa_iowa_fire_department_census
State of Iowa
@usgov.state_of_iowa_iowa_fire_department_census
This dataset is a subset of the National Fire Department Census which provides an address listing of U.S. fire departments registered with U.S. Fire Administration (USFA) as well as some basic information about each fire department. The purpose of the census is to create a national database for use by the fire protection and prevention communities, allied professions, the general public and the U.S. Fire Administration (USFA). USFA uses the database to conduct special studies, guide program decisionmaking, and to improve direct communication with individual fire departments.
Organization: State of Iowa
Last updated: 2023-01-20T00:00:16.888114
Tags: fema, fire-department, u-s-fire-administration, usfa
CREATE TABLE table_1 (
"fire_dept_id" VARCHAR,
"fire_department_name" VARCHAR,
"headquarters_address_1" VARCHAR,
"headquarters_address_2" VARCHAR,
"headquarters_state" VARCHAR,
"headquarters_city" VARCHAR,
"headquarters_zip_code" VARCHAR,
"headquarters_location" VARCHAR,
"mail_address_1" VARCHAR,
"mail_address_2" VARCHAR,
"mail_po_box" VARCHAR,
"mail_city" VARCHAR,
"mail_state" VARCHAR,
"mail_zip_code" VARCHAR,
"headquarters_phone" VARCHAR,
"headquarters_fax" VARCHAR,
"county" VARCHAR,
"department_type" VARCHAR,
"organization_type" VARCHAR,
"website" VARCHAR,
"number_of_stations" BIGINT,
"active_firefighters_career" BIGINT -- Active Firefighters - Career,
"active_firefighters_volunteer" BIGINT -- Active Firefighters - Volunteer,
"active_firefighters_paid_per_call" BIGINT -- Active Firefighters - Paid Per Call,
"civilian_employees" BIGINT,
"non_firefighting_volunteers" BIGINT,
"primary_emergency_management" VARCHAR
);Anyone who has the link will be able to view this.