ESF Common Indicator Success Rates (YEI): Breakdown By CCI, IP

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

@esifunds.n_2y69_tz4v

Table List

1 table(29.11 KB)

Table 1

@esifunds.n_2y69_tz4v.table_1

29.11 KB
354 rows
22 columns

ms Ms	cci Cci	ir_year Ir Year	ir_status Ir Status	pax Pax	fund Fund	ip Ip
LT	2014LT16MAOP001	9999	Open	07	YEI	8ii
HR	2014HR05M9OP001	2019	Accepted by EC	1	YEI	8ii
FR	2014FR16M0OP014	2017	Accepted by EC	9	YEI	8ii
FR	2014FR16M0OP001	2019	Accepted by EC	2	YEI	8ii
FR	2014FR16M0OP008	9999	Open	5	YEI	8ii
FR	2014FR16M0OP008	2020	Accepted by EC	5	YEI	8ii
FR	2014FR16M0OP003	2019	Accepted by EC	AXE 7	YEI	8ii
FR	2014FR16M0OP011	2014	Sent	8 (1)	YEI	8ii
FR	2014FR16M0OP001	9999	Open	2	YEI	8ii
FR	2014FR16M0OP003	2015	Accepted by EC	AXE 7	YEI	8ii


CREATE TABLE table_1 (
  "ms" VARCHAR,
  "cci" VARCHAR,
  "ir_year" BIGINT,
  "ir_status" VARCHAR,
  "pax" VARCHAR,
  "fund" VARCHAR,
  "ip" VARCHAR,
  "completion_by_unemployed" DOUBLE,
  "in_receipt_of_an_offer_by_unemployed" DOUBLE,
  "positive_outcome_for_unemployed" DOUBLE,
  "completion_by_longterm_unemployed" DOUBLE,
  "receipt_of_an_offer_by_longterm_unemployed" DOUBLE,
  "positive_outcome_for_longterm_unemployed" DOUBLE,
  "completion_by_inactive" DOUBLE,
  "receipt_of_an_offer_by_inactive" DOUBLE,
  "positive_outcome_for_inactive" DOUBLE,
  "completion" DOUBLE,
  "receipt_of_an_offer" DOUBLE,
  "positive_outcome" DOUBLE,
  "positive_outcome_6months_after_leaving" DOUBLE,
  "in_employment_6months_after_leaving" DOUBLE,
  "in_selfemployment_6months_after_leaving" DOUBLE
);