EU Solidarity Fund (cases 2002 To 2021)
EC-SOLIDARITY-FUND@ec.europa.eu
@esifunds.n_7a49_av34
EC-SOLIDARITY-FUND@ec.europa.eu
@esifunds.n_7a49_av34
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
);
Anyone who has the link will be able to view this.