Comparison: ESF Achievements And Finances

@esifunds.geke_2ngg

Table List

1 table(23.06 KB)

Table 1

@esifunds.geke_2ngg.table_1

23.06 KB
1000 rows
20 columns

ms Ms	cci Cci	lead_dg Lead Dg	prg_version Prg Version	ir_version Ir Version	ir_year Ir Year	ir_status_name Ir Status Name	fund Fund	pa Pa	cat_of_region Cat Of Region	to To	ip Ip	intervention Intervention	indicator_type Indicator Type	indicator Indicator	cumulative_total Cumulative Total	total_eligible_cost_amount Total Eligible Cost Amount	comparison_eligible_cost_to_achievements Comparison Eligible Cost To Achievements	total_expend_declared_amount Total Expend Declared Amount	comparison_declared_expenditure_to_achievements Comparison Declared Expenditure To Achievements
CZ	2014CZ05M2OP001	EMPL	5	2022	2022	Accepted by EC	ESF	3	Less developed	9	9ii	110	Output	CO22	5	200198529.77	40039705.954	126218238.36	25243647.672
BG	2014BG05M2OP001	EMPL	5	2022	2022	Accepted by EC	ESF	2	Less developed	10	10iii	117	Result	CR06		26440633.51		12833242.76
BE	2014BE05M9OP002	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	2	More developed	8	8i	102	Output	CO06a	44037	38567678	875.801666780208	38567678	875.801666780208
DE	2014DE05SFOP015	EMPL	6	9999	9999	Sent	ESF	B	More developed	9	9i	109	Output	CO05
DE	2014DE05SFOP002	EMPL	6	9999	9999	Sent	ESF	A	Transition	8	8iv	105	Output	CO20
UK	2014UK05SFOP004	EMPL	5	9999	9999	Sent	ESF	1	Transition	8	8ii	103	Output	CO10
DE	2014DE05SFOP009	EMPL	5	9999	9999	Sent	ESF	A	Transition	8	8iii	104	Output	CO20
DE	2014DE05SFOP002	EMPL	6	9999	9999	Sent	ESF	C	Transition	10	10iv	118	Result	CR06
DE	2014DE05SFOP008	EMPL	3	9999	9999	Sent	ESF	REACT	REACT-EU	13	13i		Output	CO09
DE	2014DE05SFOP012	EMPL	8	9999	9999	Sent	ESF	B	More developed	9	9i	109	Result	CR09


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "cci" VARCHAR,
  "lead_dg" VARCHAR,
  "prg_version" DOUBLE,
  "ir_version" DOUBLE,
  "ir_year" BIGINT,
  "ir_status_name" VARCHAR,
  "fund" VARCHAR,
  "pa" VARCHAR,
  "cat_of_region" VARCHAR,
  "to" BIGINT,
  "ip" VARCHAR,
  "intervention" DOUBLE,
  "indicator_type" VARCHAR,
  "indicator" VARCHAR,
  "cumulative_total" BIGINT,
  "total_eligible_cost_amount" DOUBLE,
  "comparison_eligible_cost_to_achievements" DOUBLE,
  "total_expend_declared_amount" DOUBLE,
  "comparison_declared_expenditure_to_achievements" DOUBLE
);