Socio-Economic Database For Latin America And The Caribbean (SEDLAC)
@owid.sedlac
@owid.sedlac
CREATE TABLE owid_sedlac_1 (
"country" VARCHAR,
"year" VARCHAR,
"survey_number" INTEGER,
"survey" VARCHAR,
"table" VARCHAR,
"national_headcount_ratio" FLOAT,
"national_poverty_gap_index" FLOAT,
"national_fgt2" FLOAT,
"gini" FLOAT,
"theil" FLOAT,
"cv" FLOAT,
"a_05" FLOAT,
"a_1" FLOAT,
"a_2" FLOAT,
"e_0" FLOAT,
"decile1_share" FLOAT,
"decile2_share" FLOAT,
"decile3_share" FLOAT,
"decile4_share" FLOAT,
"decile5_share" FLOAT,
"decile6_share" FLOAT,
"decile7_share" FLOAT,
"decile8_share" FLOAT,
"decile9_share" FLOAT,
"decile10_share" FLOAT,
"n__10_1_ratio" FLOAT,
"n__90_10_ratio" FLOAT,
"n__95_5_ratio" FLOAT,
"n__95_50_ratio" FLOAT,
"n__50_5_ratio" FLOAT,
"n__95_80_ratio" FLOAT
);
CREATE TABLE owid_sedlac_2 (
"country" VARCHAR,
"year" VARCHAR,
"survey_number" INTEGER,
"survey" VARCHAR,
"table" VARCHAR,
"national_headcount_ratio" FLOAT,
"national_poverty_gap_index" FLOAT,
"national_fgt2" FLOAT,
"gini" FLOAT,
"theil" FLOAT,
"cv" FLOAT,
"a_05" FLOAT,
"a_1" FLOAT,
"a_2" FLOAT,
"e_0" FLOAT,
"decile1_share" FLOAT,
"decile2_share" FLOAT,
"decile3_share" FLOAT,
"decile4_share" FLOAT,
"decile5_share" FLOAT,
"decile6_share" FLOAT,
"decile7_share" FLOAT,
"decile8_share" FLOAT,
"decile9_share" FLOAT,
"decile10_share" FLOAT,
"n__10_1_ratio" FLOAT,
"n__90_10_ratio" FLOAT,
"n__95_5_ratio" FLOAT,
"n__95_50_ratio" FLOAT,
"n__50_5_ratio" FLOAT,
"n__95_80_ratio" FLOAT
);
CREATE TABLE owid_sedlac_no_spells_1 (
"country" VARCHAR,
"year" INTEGER,
"table" VARCHAR,
"national_headcount_ratio" FLOAT,
"national_poverty_gap_index" FLOAT,
"national_fgt2" FLOAT,
"gini" FLOAT,
"theil" FLOAT,
"cv" FLOAT,
"a_05" FLOAT,
"a_1" FLOAT,
"a_2" FLOAT,
"e_0" FLOAT,
"decile1_share" FLOAT,
"decile2_share" FLOAT,
"decile3_share" FLOAT,
"decile4_share" FLOAT,
"decile5_share" FLOAT,
"decile6_share" FLOAT,
"decile7_share" FLOAT,
"decile8_share" FLOAT,
"decile9_share" FLOAT,
"decile10_share" FLOAT,
"n__10_1_ratio" FLOAT,
"n__90_10_ratio" FLOAT,
"n__95_5_ratio" FLOAT,
"n__95_50_ratio" FLOAT,
"n__50_5_ratio" FLOAT,
"n__95_80_ratio" FLOAT
);
CREATE TABLE owid_sedlac_no_spells_2 (
"country" VARCHAR,
"year" INTEGER,
"table" VARCHAR,
"national_headcount_ratio" FLOAT,
"national_poverty_gap_index" FLOAT,
"national_fgt2" FLOAT,
"gini" FLOAT,
"theil" FLOAT,
"cv" FLOAT,
"a_05" FLOAT,
"a_1" FLOAT,
"a_2" FLOAT,
"e_0" FLOAT,
"decile1_share" FLOAT,
"decile2_share" FLOAT,
"decile3_share" FLOAT,
"decile4_share" FLOAT,
"decile5_share" FLOAT,
"decile6_share" FLOAT,
"decile7_share" FLOAT,
"decile8_share" FLOAT,
"decile9_share" FLOAT,
"decile10_share" FLOAT,
"n__10_1_ratio" FLOAT,
"n__90_10_ratio" FLOAT,
"n__95_5_ratio" FLOAT,
"n__95_50_ratio" FLOAT,
"n__50_5_ratio" FLOAT,
"n__95_80_ratio" FLOAT
);
Anyone who has the link will be able to view this.