Global Jobs Indicators Database (JOIN)
Global jobs and employment data
@worldbank.global_jobs_indicators_database
Global jobs and employment data
@worldbank.global_jobs_indicators_database
The Global Jobs Indicators Database (JoIn) presents the standardized labor supply indicators most commonly used in country Jobs Diagnostics. These cover socio-demographics, labor force status and employment type, employment composition by sector and occupation, education level completed, hours worked, and earnings.
CREATE TABLE ji_tlf_totl_ru (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_tlf_totl_ur (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_tlf_totl_yg (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_fe_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_he_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_le_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_ma_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_ru_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_ur_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1524_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_fe_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_he_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_le_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_ma_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_ol_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_ru_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_ur_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_yg_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_1564_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_fe_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_he_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_le_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_ma_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_ru_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_ur_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_uem_neet_zs (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr_he (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr_le (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr_ol (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr_ru (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr_ur (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_gndr_yg (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_cn (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_df (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_fe_10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_fe_cn (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_fe_df (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_he_10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_he_cn (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_he_df (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_le_10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_le_cn (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_le_df (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_ma_10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_ma_cn (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_ma_df (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_ol_10 (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);CREATE TABLE ji_wag_hour_md_ol_cn (
"economy" VARCHAR,
"year" BIGINT,
"value" DOUBLE
);Anyone who has the link will be able to view this.