GDP Per Hour Worked
Data behind the Economist's analysis of GDP and productivity
@kaggle.joebeachcapital_gdp_per_hour_worked
Data behind the Economist's analysis of GDP and productivity
@kaggle.joebeachcapital_gdp_per_hour_worked
CREATE TABLE gdp_decomposition_pop_weighted_average (
"year" BIGINT,
"gdp_over_pop_pop_weighted_average" DOUBLE,
"gdp_over_pop_adjust_prices_pop_weighted_average" DOUBLE,
"gdp_over_pop_adjust_prices_working_age_pop_weighted_average" DOUBLE,
"gdp_over_pop_adjust_prices_working_age_emp_only_pop_we_feaeeb32" DOUBLE,
"gdp_over_pop_adjust_prices_working_age_emp_hours_worke_fac3a240" DOUBLE,
"gdp_over_pop_usa" DOUBLE
);
CREATE TABLE gdp_over_hours_worked (
"iso2c" VARCHAR,
"year" BIGINT,
"country" VARCHAR,
"iso3c" VARCHAR,
"pop" DOUBLE,
"labor_force" DOUBLE,
"gdp_ppp_c" DOUBLE,
"gdp_ppp" DOUBLE,
"gdp" DOUBLE,
"gdp_c" DOUBLE,
"unemployment_r" DOUBLE,
"pop_over_65" DOUBLE,
"working_age_pop_pct" DOUBLE,
"employment_rate" DOUBLE,
"hours_worked" DOUBLE,
"total_hours" DOUBLE,
"hours_per_employed" DOUBLE,
"employed" DOUBLE,
"total_hours_alternative" DOUBLE,
"gdp_over_k_hours_worked" DOUBLE,
"gdp_ppp_over_k_hours_worked" DOUBLE,
"gdp_over_pop" DOUBLE,
"gdp_ppp_over_pop" DOUBLE,
"gdp_ppp_over_labor_force" DOUBLE,
"gdp_ppp_over_pop_c" DOUBLE,
"gdp_over_pop_c" DOUBLE,
"gdp_ppp_over_k_hours_worked_c" DOUBLE
);
Anyone who has the link will be able to view this.