Comparison: ESF Achievements (results) And Finances

ESF managing authorities

@esifunds.n_7x3k_ss9v

Table List

1 table(45.51 KB)

Table 1

@esifunds.n_7x3k_ss9v.table_1

45.51 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
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	4	Transition	8	8i	102	Result	CR01+CR02+CR03+CR04	2222	29348766.05	13208.2655490549	15218632.76	6849.0696489649
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	6	REACT-EU	13	13i		Result	CR01+CR02+CR03+CR04	56813
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	4	Transition	8	8iv	105	Result	CR01+CR02+CR03+CR04	54	744575.25	13788.4305555556	675033.04	12500.6118518519
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	3	More developed	10	10i	115	Result	CR01+CR02+CR03+CR04	37292	265354215.88	7115.58017483643	242078475.75	6491.43182854232
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	4	Transition	8	8vi	107	Result	CR01+CR02+CR03+CR04
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	2	More developed	9	9i	109	Result	CR01+CR02+CR03+CR04	36611	266438884.22	7277.5636890552	226697546.15	6192.06102400918
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	1	More developed	8	8vi	107	Result	CR01+CR02+CR03+CR04		40399999.06		29311725.77
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	3	More developed	10	10iii	117	Result	CR01+CR02+CR03+CR04	10529	161100072.42	15300.6052255675	130467863.23	12391.2872286067
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	4	Transition	10	10i	115	Result	CR01+CR02+CR03+CR04	475	4303076.27	9059.10793684211	4283217.46	9017.29991578947
AT	2014AT05SFOP001	EMPL	9.1	2022.1	2022	Accepted by EC	ESF	4	Transition	10	10iii	117	Result	CR01+CR02+CR03+CR04	1047	7119683.02	6800.07929321872	4519579.45	4316.69479465138


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
);