Job Vacancy Statistics - JVS

European Central Bank

@ecb.job_vacancy_statistics_jvs

Table List

1 table(27.35 KB)

Table 1

@ecb.job_vacancy_statistics_jvs.table_1

27.35 KB
5550 rows
27 columns

key KEY	freq FREQ	ref_area REF AREA	region REGION	seasonal_adjust SEASONAL ADJUST	indicator INDICATOR	activity ACTIVITY	sizeclass SIZECLASS	occupation OCCUPATION	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	comment_ts COMMENT TS	compiling_org COMPILING ORG	decimals DECIMALS	time_per_collect TIME PER COLLECT	title TITLE	unit_measure UNIT MEASURE
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2010-Q2	0.5	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2010-Q3	0.4	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2010-Q4	0.4	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2011-Q1	0.6	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2011-Q2	0.9	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2011-Q3	0.7	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2011-Q4	1.2	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2012-Q1	1	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2012-Q2	0.8	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT
JVS.Q.B5._Z.N.JVR.B._T._T	Q	B5	_Z	N	JVR	B	_T	_T	2012-Q3	0.7	A	F	P3M	EU28 (fixed composition) as of 1 July 2013 - Job vacancy rate,Mining and quarrying;All enterprises/local units;Neither seasonally adjusted nor calendar adjusted	4D0	1	A	Job vacancy rate	PT


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "region" VARCHAR,
  "seasonal_adjust" VARCHAR,
  "indicator" VARCHAR,
  "activity" VARCHAR,
  "sizeclass" VARCHAR,
  "occupation" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "embargo_time" VARCHAR,
  "time_format" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "coverage" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "diss_org" VARCHAR,
  "time_per_collect" VARCHAR,
  "title" VARCHAR,
  "unit_measure" VARCHAR,
  "unit_mult" BIGINT
);