ESF Common Indicator Success Rates: Breakdown By CCI, IP

European Commission, Directorate-General for Employment, social affairs and inclusion

@esifunds.n_6dsf_6m94

Table List

1 table(19.51 KB)

Table 1

@esifunds.n_6dsf_6m94.table_1

19.51 KB
1000 rows
14 columns

ms Ms	cci Cci	ir_year Ir Year	ir_status Ir Status	pax Pax	fund Fund	ip Ip
LT	2014LT16MAOP001	9999	Open	14	ESF	13i
PL	2014PL16M2OP011	2017	Accepted by EC	6	ESF	9iv
IT	2014IT05SFOP021	2015	Accepted by EC	1	ESF	8iii
LT	2014LT16MAOP001	9999	Open	08	ESF	9i
FR	2014FR05M9OP002	2018	Accepted by EC	5	YEI	8ii
LT	2014LT16MAOP001	9999	Open	08	ESF	9iv
GR	2014GR05M9OP001	2017	Accepted by EC	9	ESF	10i
FR	2014FR16M0OP012	2016	Accepted by EC	5	YEI	8ii
GR	2014GR16M2OP006	2018	Accepted by EC	10	ESF	9v
RO	2014RO05M9OP001	2017	Accepted by EC	AP 4	ESF	9v


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "cci" VARCHAR,
  "ir_year" BIGINT,
  "ir_status" VARCHAR,
  "pax" VARCHAR,
  "fund" VARCHAR,
  "ip" VARCHAR,
  "in_jobsearch" DOUBLE,
  "in_education_or_training" DOUBLE,
  "gaining_a_qualification" DOUBLE,
  "in_employment" DOUBLE,
  "any_successful_outcome" DOUBLE,
  "in_employment_6_months_after_leaving" DOUBLE,
  "improved_labour_market_situation_6_months_after_leaving" DOUBLE
);