Inequality Comparisons Across Time And Datasets
@owid.inequality_comparison
@owid.inequality_comparison
CREATE TABLE owid_inequality_comparison (
"country" VARCHAR,
"year" INTEGER,
"ref_year" INTEGER,
"reference_years" VARCHAR,
"only_all_series" VARCHAR,
"gini_pip_disposable_percapita" FLOAT,
"gini_wid_pretaxnational_peradult" FLOAT,
"p90p100share_pip_disposable_percapita" FLOAT,
"p90p100share_wid_pretaxnational_peradult" FLOAT,
"p99p100share_wid_pretaxnational_peradult" FLOAT,
"palmaratio_pip_disposable_percapita" FLOAT,
"palmaratio_wid_pretaxnational_peradult" FLOAT
);
CREATE TABLE owid_inequality_comparison_analysis (
"country" VARCHAR,
"year" INTEGER,
"ref_year" INTEGER,
"reference_years" VARCHAR,
"excluded_years" VARCHAR,
"maximum_distances" VARCHAR,
"only_all_series" VARCHAR,
"pipwelfare" VARCHAR,
"pipreportinglevel" VARCHAR,
"gini_pip_disposable_percapita" FLOAT,
"gini_wid_pretaxnational_peradult" FLOAT,
"p90p100share_pip_disposable_percapita" FLOAT,
"p90p100share_wid_pretaxnational_peradult" FLOAT,
"p99p100share_wid_pretaxnational_peradult" FLOAT,
"palmaratio_pip_disposable_percapita" FLOAT,
"palmaratio_wid_pretaxnational_peradult" FLOAT
);
Anyone who has the link will be able to view this.