ILOSTAT
@owid.ilostat
@owid.ilostat
CREATE TABLE owid_ilostat (
"country" VARCHAR,
"year" INTEGER,
"sex" VARCHAR,
"classif1" VARCHAR,
"average_hourly_earnings_employees_by_sex" FLOAT,
"employment_by_sex_and_status_in_employment" FLOAT,
"female_share_of_low_pay_earners" FLOAT,
"gender_wage_gap_by_occupation" FLOAT,
"informal_employment_rate_by_sex" FLOAT,
"labour_force_by_sex_and_age" FLOAT,
"labour_force_participation_rate_by_sex_and_age" FLOAT,
"sdg_10_4_1_labour_income_share" FLOAT,
"sdg_1_1_1_working_poverty_rate" FLOAT,
"sdg_1_3_1_population_covered_by_social_protection" FLOAT,
"sdg_5_5_2_women_in_management" FLOAT,
"sdg_5_5_2_women_in_senior_middle_management" FLOAT,
"sdg_8_2_1_growth_rate_output_per_worker" FLOAT,
"sdg_8_3_1_informal_employment" FLOAT,
"sdg_8_5_1_average_hourly_earnings" FLOAT,
"sdg_8_5_2_unemployment_rate" FLOAT,
"sdg_8_5_2_unemployment_rate_by_disability_status" FLOAT,
"sdg_8_6_1_youth_neet" FLOAT,
"sdg_8_7_1_children_engaged_in_economic_activity" FLOAT,
"sdg_8_7_1_children_engaged_in_economic_activity_and_ho_e006f5f6" FLOAT,
"sdg_8_8_1_fatal_occupational_injuries" FLOAT,
"sdg_8_8_1_non_fatal_occupational_injuries" FLOAT,
"sdg_8_8_2_national_compliance_labour_rights" FLOAT,
"sdg_8_b_1_national_strategy_youth_employment" FLOAT,
"sdg_9_2_2_manufacturing_employment" FLOAT,
"share_of_children_in_child_labour_by_sex_and_age" FLOAT,
"unemployment_rate_by_sex_and_age" FLOAT
);
CREATE TABLE owid_regions (
"country" VARCHAR,
"year" INTEGER,
"ilo_region" VARCHAR,
"ilo_subregion" VARCHAR
);
Anyone who has the link will be able to view this.