EU Solidarity Fund (cases 2002 To 2021)

EC-SOLIDARITY-FUND@ec.europa.eu

@esifunds.n_7a49_av34

Table List

1 table(26.81 KB)

Table 1

@esifunds.n_7a49_av34.table_1

26.81 KB
178 rows
18 columns

year_of_occurance Year Of Occurance	cci_number Cci Number	applicant_country Applicant Country	name_of_disaster Name Of Disaster	disaster_type Disaster Type	status Status	first_damage_date First Damage Date	date_of_initial_application Date Of Initial Application	days_from_disaster_to Days From Disaster To	major_regional_neighbouring Major Regional Neighbouring	total_direct_damage_accepted Total Direct Damage Accepted	cost_of_eligible_emergency Cost Of Eligible Emergency	eligible_cost_total_damage Eligible Cost Total Damage	paid Paid
2002	2002ATSPO001	AT	Flooding Austria 2002	Floods	Accepted	Sat Jun 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	accepted retroactively		Major	2900	1200	41.40%	134
2002	2002DESPO001	DE	Flooding Germany 2002	Floods	Accepted	Tue Oct 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	accepted retroactively		Major	9100	1699	18.70%	444
2002	2002CZSPO001	CZ	Flooding Czechia 2002	Floods	Accepted	Wed May 08 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	accepted retroactively		Major	2300	1186	51.60%	129
2002	2002FRSPO001	FR	Flooding France 2002	Floods	Accepted	Fri Aug 09 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	accepted retroactively		Regional	834.5	225	27.00%	21
2003	2003ESSPO001	ES	Prestige Oil spill 2003	Man Made	Accepted	Tue Nov 19 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-01-13T00:00:00.000	55	Regional	436	416	95.40%	8.626
2003	2003IT16SPO002	IT	Earthquake Molise 2003	Earthquake/Volcanic	Accepted	Thu Oct 31 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-01-13T00:00:00.000	74	Regional	1558	248	15.90%	30.826
2003	2003IT16SPO003	IT	Etna Volcanic eruption & quakes 2003	Earthquake/Volcanic	Accepted	Sat Oct 26 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-01-13T00:00:00.000	79	Regional	849	204	24.00%	16.798
2003	2003IT16SPO001	IT	North Italy Flooding 2003	Floods	Rejected	Sun Nov 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-01-31T00:00:00.000	68	Regional
2003	2003GR16SPO001	GR	Adverse winter weather 2003	Adverse weather	Rejected	Sat Jan 12 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-02-28T00:00:00.000	89	Regional
2003	2003PTSPO001	PT	Forest fires 2003	Forest fires/drought	Accepted	Sun Jul 20 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	2003-08-13T00:00:00.000	24	Major	1228	104	8.50%	48.539


CREATE TABLE table_1 (
  "year_of_occurance" BIGINT,
  "cci_number" VARCHAR,
  "applicant_country" VARCHAR,
  "name_of_disaster" VARCHAR,
  "disaster_type" VARCHAR,
  "status" VARCHAR,
  "first_damage_date" TIMESTAMP,
  "date_of_initial_application" VARCHAR,
  "days_from_disaster_to" DOUBLE,
  "major_regional_neighbouring" VARCHAR,
  "total_direct_damage_accepted" DOUBLE,
  "public_damage_eur_million" DOUBLE,
  "public_total_damage" DOUBLE,
  "cost_of_eligible_emergency" DOUBLE,
  "eligible_cost_total_damage" VARCHAR,
  "paid" DOUBLE,
  "advanced_payment_post_2015" DOUBLE,
  "potential_aid_amount_eur_m" DOUBLE
);