Federal Emergencies And Disasters, 1953-Present

Has the number of emergencies declared by the president risen over time?

@kaggle.fema_federal_disasters

Table List

1 table(298.56 KB)

Database

@kaggle.fema_federal_disasters.database

298.56 KB
46185 rows
14 columns

declaration_number Declaration Number	declaration_type Declaration Type	declaration_date Declaration Date	state State	county County	disaster_type Disaster Type	disaster_title Disaster Title	start_date Start Date	end_date End Date	close_date Close Date	individual_assistance_program Individual Assistance Program	individuals_households_program Individuals \u0026 Households Program	public_assistance_program Public Assistance Program	hazard_mitigation_program Hazard Mitigation Program
DR-1	Disaster	Sat May 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	GA	nan	Tornado	Tornado	Sat May 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat May 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 01 1954 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-2	Disaster	Fri May 15 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	TX	nan	Tornado	Tornado and Heavy Rainfall	Fri May 15 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 15 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1958 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-3	Disaster	Fri May 29 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	LA	nan	Flood	Flood	Fri May 29 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri May 29 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 01 1960 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-4	Disaster	Tue Jun 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	MI	nan	Tornado	Tornado	Tue Jun 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 01 1956 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-5	Disaster	Sat Jun 06 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	MT	nan	Flood	Floods	Sat Jun 06 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jun 06 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 01 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-6	Disaster	Tue Jun 09 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	MI	nan	Tornado	Tornado	Tue Jun 09 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Jun 09 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 30 1956 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-7	Disaster	Thu Jun 11 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	MA	nan	Tornado	Tornado	Thu Jun 11 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 11 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 1956 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-8	Disaster	Thu Jun 11 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	IA	nan	Flood	Flood	Thu Jun 11 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jun 11 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 01 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-9	Disaster	Fri Jun 19 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	TX	nan	Flood	Flood	Fri Jun 19 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 19 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 01 1958 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes
DR-11	Disaster	Thu Jul 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	NH	nan	Fire	Forest Fire	Thu Jul 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jul 02 1953 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Feb 01 1956 00:00:00 GMT+0000 (Coordinated Universal Time)	Yes	No	Yes	Yes


CREATE TABLE database (
  "declaration_number" VARCHAR,
  "declaration_type" VARCHAR,
  "declaration_date" TIMESTAMP,
  "state" VARCHAR,
  "county" VARCHAR,
  "disaster_type" VARCHAR,
  "disaster_title" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "close_date" TIMESTAMP,
  "individual_assistance_program" VARCHAR,
  "individuals_households_program" VARCHAR,
  "public_assistance_program" VARCHAR,
  "hazard_mitigation_program" VARCHAR
);