Luxembourg Income Study (LIS, 2023)
@owid.luxembourg_income_study
@owid.luxembourg_income_study
CREATE TABLE owid_lis_percentiles_1 (
"country" VARCHAR,
"year" INTEGER,
"welfare" VARCHAR,
"equivalization" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"share" FLOAT,
"avg" FLOAT
);
CREATE TABLE owid_lis_percentiles_2 (
"country" VARCHAR,
"year" INTEGER,
"welfare" VARCHAR,
"equivalization" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"share" FLOAT,
"avg" FLOAT
);
CREATE TABLE owid_lis_percentiles_3 (
"country" VARCHAR,
"year" INTEGER,
"welfare" VARCHAR,
"equivalization" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"share" FLOAT,
"avg" FLOAT
);
CREATE TABLE owid_lis_percentiles_adults_1 (
"country" VARCHAR,
"year" INTEGER,
"welfare" VARCHAR,
"equivalization" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"share" FLOAT,
"avg" FLOAT
);
CREATE TABLE owid_lis_percentiles_adults_2 (
"country" VARCHAR,
"year" INTEGER,
"welfare" VARCHAR,
"equivalization" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"share" FLOAT,
"avg" FLOAT
);
CREATE TABLE owid_lis_percentiles_adults_3 (
"country" VARCHAR,
"year" INTEGER,
"welfare" VARCHAR,
"equivalization" VARCHAR,
"percentile" INTEGER,
"thr" FLOAT,
"share" FLOAT,
"avg" FLOAT
);
CREATE TABLE owid_luxembourg_income_study_1 (
"country" VARCHAR,
"year" INTEGER,
"avg_p100_dhci_eq" FLOAT,
"avg_p100_dhci_pc" FLOAT,
"avg_p100_dhi_eq" FLOAT,
"avg_p100_dhi_pc" FLOAT,
"avg_p100_mi_eq" FLOAT,
"avg_p100_mi_pc" FLOAT,
"avg_p10_dhci_eq" FLOAT,
"avg_p10_dhci_pc" FLOAT,
"avg_p10_dhi_eq" FLOAT,
"avg_p10_dhi_pc" FLOAT,
"avg_p10_mi_eq" FLOAT,
"avg_p10_mi_pc" FLOAT,
"avg_p20_dhci_eq" FLOAT,
"avg_p20_dhci_pc" FLOAT,
"avg_p20_dhi_eq" FLOAT,
"avg_p20_dhi_pc" FLOAT,
"avg_p20_mi_eq" FLOAT,
"avg_p20_mi_pc" FLOAT,
"avg_p30_dhci_eq" FLOAT,
"avg_p30_dhci_pc" FLOAT,
"avg_p30_dhi_eq" FLOAT,
"avg_p30_dhi_pc" FLOAT,
"avg_p30_mi_eq" FLOAT,
"avg_p30_mi_pc" FLOAT,
"avg_p40_dhci_eq" FLOAT,
"avg_p40_dhci_pc" FLOAT,
"avg_p40_dhi_eq" FLOAT,
"avg_p40_dhi_pc" FLOAT,
"avg_p40_mi_eq" FLOAT,
"avg_p40_mi_pc" FLOAT,
"avg_p50_dhci_eq" FLOAT,
"avg_p50_dhci_pc" FLOAT,
"avg_p50_dhi_eq" FLOAT,
"avg_p50_dhi_pc" FLOAT,
"avg_p50_mi_eq" FLOAT,
"avg_p50_mi_pc" FLOAT,
"avg_p60_dhci_eq" FLOAT,
"avg_p60_dhci_pc" FLOAT,
"avg_p60_dhi_eq" FLOAT,
"avg_p60_dhi_pc" FLOAT,
"avg_p60_mi_eq" FLOAT,
"avg_p60_mi_pc" FLOAT,
"avg_p70_dhci_eq" FLOAT,
"avg_p70_dhci_pc" FLOAT,
"avg_p70_dhi_eq" FLOAT,
"avg_p70_dhi_pc" FLOAT,
"avg_p70_mi_eq" FLOAT,
"avg_p70_mi_pc" FLOAT,
"avg_p80_dhci_eq" FLOAT,
"avg_p80_dhci_pc" FLOAT,
"avg_p80_dhi_eq" FLOAT,
"avg_p80_dhi_pc" FLOAT,
"avg_p80_mi_eq" FLOAT,
"avg_p80_mi_pc" FLOAT,
"avg_p90_dhci_eq" FLOAT,
"avg_p90_dhci_pc" FLOAT,
"avg_p90_dhi_eq" FLOAT,
"avg_p90_dhi_pc" FLOAT,
"avg_p90_mi_eq" FLOAT,
"avg_p90_mi_pc" FLOAT,
"avg_shortfall_40_median_dhci_eq" FLOAT,
"avg_shortfall_40_median_dhci_pc" FLOAT,
"avg_shortfall_40_median_dhi_eq" FLOAT,
"avg_shortfall_40_median_dhi_pc" FLOAT,
"avg_shortfall_40_median_mi_eq" FLOAT,
"avg_shortfall_40_median_mi_pc" FLOAT,
"avg_shortfall_50_median_dhci_eq" FLOAT,
"avg_shortfall_50_median_dhci_pc" FLOAT,
"avg_shortfall_50_median_dhi_eq" FLOAT,
"avg_shortfall_50_median_dhi_pc" FLOAT,
"avg_shortfall_50_median_mi_eq" FLOAT,
"avg_shortfall_50_median_mi_pc" FLOAT,
"avg_shortfall_60_median_dhci_eq" FLOAT,
"avg_shortfall_60_median_dhci_pc" FLOAT,
"avg_shortfall_60_median_dhi_eq" FLOAT,
"avg_shortfall_60_median_dhi_pc" FLOAT,
"avg_shortfall_60_median_mi_eq" FLOAT,
"avg_shortfall_60_median_mi_pc" FLOAT,
"avg_shortfall_dhci_eq_100" FLOAT,
"avg_shortfall_dhci_eq_1000" FLOAT,
"avg_shortfall_dhci_eq_200" FLOAT,
"avg_shortfall_dhci_eq_2000" FLOAT,
"avg_shortfall_dhci_eq_215" FLOAT,
"avg_shortfall_dhci_eq_3000" FLOAT,
"avg_shortfall_dhci_eq_365" FLOAT,
"avg_shortfall_dhci_eq_4000" FLOAT,
"avg_shortfall_dhci_eq_500" FLOAT,
"avg_shortfall_dhci_eq_685" FLOAT,
"avg_shortfall_dhci_pc_100" FLOAT,
"avg_shortfall_dhci_pc_1000" FLOAT,
"avg_shortfall_dhci_pc_200" FLOAT,
"avg_shortfall_dhci_pc_2000" FLOAT,
"avg_shortfall_dhci_pc_215" FLOAT,
"avg_shortfall_dhci_pc_3000" FLOAT,
"avg_shortfall_dhci_pc_365" FLOAT,
"avg_shortfall_dhci_pc_4000" FLOAT,
"avg_shortfall_dhci_pc_500" FLOAT,
"avg_shortfall_dhci_pc_685" FLOAT
);
CREATE TABLE owid_luxembourg_income_study_2 (
"country" VARCHAR,
"year" INTEGER,
"mean_dhci_pc" FLOAT,
"mean_dhci_eq" FLOAT,
"mean_dhi_pc" FLOAT,
"mean_dhi_eq" FLOAT,
"mean_mi_pc" FLOAT,
"mean_mi_eq" FLOAT,
"median_dhci_pc" FLOAT,
"median_dhci_eq" FLOAT,
"median_dhi_pc" FLOAT,
"median_dhi_eq" FLOAT,
"median_mi_pc" FLOAT,
"median_mi_eq" FLOAT,
"gini_dhci_pc" FLOAT,
"gini_dhci_eq" FLOAT,
"gini_dhi_pc" FLOAT,
"gini_dhi_eq" FLOAT,
"gini_mi_pc" FLOAT,
"gini_mi_eq" FLOAT,
"headcount_ratio_40_median_dhci_pc" FLOAT,
"headcount_ratio_40_median_dhci_eq" FLOAT,
"headcount_ratio_40_median_dhi_pc" FLOAT,
"headcount_ratio_40_median_dhi_eq" FLOAT,
"headcount_ratio_40_median_mi_pc" FLOAT,
"headcount_ratio_40_median_mi_eq" FLOAT,
"headcount_ratio_50_median_dhci_pc" FLOAT,
"headcount_ratio_50_median_dhci_eq" FLOAT,
"headcount_ratio_50_median_dhi_pc" FLOAT,
"headcount_ratio_50_median_dhi_eq" FLOAT,
"headcount_ratio_50_median_mi_pc" FLOAT,
"headcount_ratio_50_median_mi_eq" FLOAT,
"headcount_ratio_60_median_dhci_pc" FLOAT,
"headcount_ratio_60_median_dhci_eq" FLOAT,
"headcount_ratio_60_median_dhi_pc" FLOAT,
"headcount_ratio_60_median_dhi_eq" FLOAT,
"headcount_ratio_60_median_mi_pc" FLOAT,
"headcount_ratio_60_median_mi_eq" FLOAT,
"poverty_gap_index_40_median_dhci_pc" FLOAT,
"poverty_gap_index_40_median_dhci_eq" FLOAT,
"poverty_gap_index_40_median_dhi_pc" FLOAT,
"poverty_gap_index_40_median_dhi_eq" FLOAT,
"poverty_gap_index_40_median_mi_pc" FLOAT,
"poverty_gap_index_40_median_mi_eq" FLOAT,
"poverty_gap_index_50_median_dhci_pc" FLOAT,
"poverty_gap_index_50_median_dhci_eq" FLOAT,
"poverty_gap_index_50_median_dhi_pc" FLOAT,
"poverty_gap_index_50_median_dhi_eq" FLOAT,
"poverty_gap_index_50_median_mi_pc" FLOAT,
"poverty_gap_index_50_median_mi_eq" FLOAT,
"poverty_gap_index_60_median_dhci_pc" FLOAT,
"poverty_gap_index_60_median_dhci_eq" FLOAT,
"poverty_gap_index_60_median_dhi_pc" FLOAT,
"poverty_gap_index_60_median_dhi_eq" FLOAT,
"poverty_gap_index_60_median_mi_pc" FLOAT,
"poverty_gap_index_60_median_mi_eq" FLOAT,
"headcount_40_median_dhci_pc" UINTEGER,
"headcount_40_median_dhci_eq" UINTEGER,
"headcount_40_median_dhi_pc" UINTEGER,
"headcount_40_median_dhi_eq" UINTEGER,
"headcount_40_median_mi_pc" UINTEGER,
"headcount_40_median_mi_eq" UINTEGER,
"income_gap_ratio_40_median_dhci_pc" FLOAT,
"income_gap_ratio_40_median_dhci_eq" FLOAT,
"income_gap_ratio_40_median_dhi_pc" FLOAT,
"income_gap_ratio_40_median_dhi_eq" FLOAT,
"income_gap_ratio_40_median_mi_pc" FLOAT,
"income_gap_ratio_40_median_mi_eq" FLOAT,
"avg_shortfall_40_median_dhci_pc" FLOAT,
"avg_shortfall_40_median_dhci_eq" FLOAT,
"avg_shortfall_40_median_dhi_pc" FLOAT,
"avg_shortfall_40_median_dhi_eq" FLOAT,
"avg_shortfall_40_median_mi_pc" FLOAT,
"avg_shortfall_40_median_mi_eq" FLOAT,
"total_shortfall_40_median_dhci_pc" BIGINT,
"total_shortfall_40_median_dhci_eq" BIGINT,
"total_shortfall_40_median_dhi_pc" BIGINT,
"total_shortfall_40_median_dhi_eq" BIGINT,
"total_shortfall_40_median_mi_pc" BIGINT,
"total_shortfall_40_median_mi_eq" BIGINT,
"headcount_50_median_dhci_pc" UINTEGER,
"headcount_50_median_dhci_eq" UINTEGER,
"headcount_50_median_dhi_pc" UINTEGER,
"headcount_50_median_dhi_eq" UINTEGER,
"headcount_50_median_mi_pc" UINTEGER,
"headcount_50_median_mi_eq" UINTEGER,
"income_gap_ratio_50_median_dhci_pc" FLOAT,
"income_gap_ratio_50_median_dhci_eq" FLOAT,
"income_gap_ratio_50_median_dhi_pc" FLOAT,
"income_gap_ratio_50_median_dhi_eq" FLOAT,
"income_gap_ratio_50_median_mi_pc" FLOAT,
"income_gap_ratio_50_median_mi_eq" FLOAT,
"avg_shortfall_50_median_dhci_pc" FLOAT,
"avg_shortfall_50_median_dhci_eq" FLOAT,
"avg_shortfall_50_median_dhi_pc" FLOAT,
"avg_shortfall_50_median_dhi_eq" FLOAT,
"avg_shortfall_50_median_mi_pc" FLOAT,
"avg_shortfall_50_median_mi_eq" FLOAT,
"total_shortfall_50_median_dhci_pc" BIGINT,
"total_shortfall_50_median_dhci_eq" BIGINT
);
CREATE TABLE owid_luxembourg_income_study_3 (
"country" VARCHAR,
"year" INTEGER,
"mean_dhci_pc" FLOAT,
"mean_dhci_eq" FLOAT,
"mean_dhi_pc" FLOAT,
"mean_dhi_eq" FLOAT,
"mean_mi_pc" FLOAT,
"mean_mi_eq" FLOAT,
"median_dhci_pc" FLOAT,
"median_dhci_eq" FLOAT,
"median_dhi_pc" FLOAT,
"median_dhi_eq" FLOAT,
"median_mi_pc" FLOAT,
"median_mi_eq" FLOAT,
"gini_dhci_pc" FLOAT,
"gini_dhci_eq" FLOAT,
"gini_dhi_pc" FLOAT,
"gini_dhi_eq" FLOAT,
"gini_mi_pc" FLOAT,
"gini_mi_eq" FLOAT,
"headcount_ratio_40_median_dhci_pc" FLOAT,
"headcount_ratio_40_median_dhci_eq" FLOAT,
"headcount_ratio_40_median_dhi_pc" FLOAT,
"headcount_ratio_40_median_dhi_eq" FLOAT,
"headcount_ratio_40_median_mi_pc" FLOAT,
"headcount_ratio_40_median_mi_eq" FLOAT,
"headcount_ratio_50_median_dhci_pc" FLOAT,
"headcount_ratio_50_median_dhci_eq" FLOAT,
"headcount_ratio_50_median_dhi_pc" FLOAT,
"headcount_ratio_50_median_dhi_eq" FLOAT,
"headcount_ratio_50_median_mi_pc" FLOAT,
"headcount_ratio_50_median_mi_eq" FLOAT,
"headcount_ratio_60_median_dhci_pc" FLOAT,
"headcount_ratio_60_median_dhci_eq" FLOAT,
"headcount_ratio_60_median_dhi_pc" FLOAT,
"headcount_ratio_60_median_dhi_eq" FLOAT,
"headcount_ratio_60_median_mi_pc" FLOAT,
"headcount_ratio_60_median_mi_eq" FLOAT,
"poverty_gap_index_40_median_dhci_pc" FLOAT,
"poverty_gap_index_40_median_dhci_eq" FLOAT,
"poverty_gap_index_40_median_dhi_pc" FLOAT,
"poverty_gap_index_40_median_dhi_eq" FLOAT,
"poverty_gap_index_40_median_mi_pc" FLOAT,
"poverty_gap_index_40_median_mi_eq" FLOAT,
"poverty_gap_index_50_median_dhci_pc" FLOAT,
"poverty_gap_index_50_median_dhci_eq" FLOAT,
"poverty_gap_index_50_median_dhi_pc" FLOAT,
"poverty_gap_index_50_median_dhi_eq" FLOAT,
"poverty_gap_index_50_median_mi_pc" FLOAT,
"poverty_gap_index_50_median_mi_eq" FLOAT,
"poverty_gap_index_60_median_dhci_pc" FLOAT,
"poverty_gap_index_60_median_dhci_eq" FLOAT,
"poverty_gap_index_60_median_dhi_pc" FLOAT,
"poverty_gap_index_60_median_dhi_eq" FLOAT,
"poverty_gap_index_60_median_mi_pc" FLOAT,
"poverty_gap_index_60_median_mi_eq" FLOAT,
"headcount_40_median_dhci_pc" UINTEGER,
"headcount_40_median_dhci_eq" UINTEGER,
"headcount_40_median_dhi_pc" UINTEGER,
"headcount_40_median_dhi_eq" UINTEGER,
"headcount_40_median_mi_pc" UINTEGER,
"headcount_40_median_mi_eq" UINTEGER,
"income_gap_ratio_40_median_dhci_pc" FLOAT,
"income_gap_ratio_40_median_dhci_eq" FLOAT,
"income_gap_ratio_40_median_dhi_pc" FLOAT,
"income_gap_ratio_40_median_dhi_eq" FLOAT,
"income_gap_ratio_40_median_mi_pc" FLOAT,
"income_gap_ratio_40_median_mi_eq" FLOAT,
"avg_shortfall_40_median_dhci_pc" FLOAT,
"avg_shortfall_40_median_dhci_eq" FLOAT,
"avg_shortfall_40_median_dhi_pc" FLOAT,
"avg_shortfall_40_median_dhi_eq" FLOAT,
"avg_shortfall_40_median_mi_pc" FLOAT,
"avg_shortfall_40_median_mi_eq" FLOAT,
"total_shortfall_40_median_dhci_pc" BIGINT,
"total_shortfall_40_median_dhci_eq" BIGINT,
"total_shortfall_40_median_dhi_pc" BIGINT,
"total_shortfall_40_median_dhi_eq" BIGINT,
"total_shortfall_40_median_mi_pc" BIGINT,
"total_shortfall_40_median_mi_eq" BIGINT,
"headcount_50_median_dhci_pc" UINTEGER,
"headcount_50_median_dhci_eq" UINTEGER,
"headcount_50_median_dhi_pc" UINTEGER,
"headcount_50_median_dhi_eq" UINTEGER,
"headcount_50_median_mi_pc" UINTEGER,
"headcount_50_median_mi_eq" UINTEGER,
"income_gap_ratio_50_median_dhci_pc" FLOAT,
"income_gap_ratio_50_median_dhci_eq" FLOAT,
"income_gap_ratio_50_median_dhi_pc" FLOAT,
"income_gap_ratio_50_median_dhi_eq" FLOAT,
"income_gap_ratio_50_median_mi_pc" FLOAT,
"income_gap_ratio_50_median_mi_eq" FLOAT,
"avg_shortfall_50_median_dhci_pc" FLOAT,
"avg_shortfall_50_median_dhci_eq" FLOAT,
"avg_shortfall_50_median_dhi_pc" FLOAT,
"avg_shortfall_50_median_dhi_eq" FLOAT,
"avg_shortfall_50_median_mi_pc" FLOAT,
"avg_shortfall_50_median_mi_eq" FLOAT,
"total_shortfall_50_median_dhci_pc" BIGINT,
"total_shortfall_50_median_dhci_eq" BIGINT
);
CREATE TABLE owid_luxembourg_income_study_adults_1 (
"country" VARCHAR,
"year" INTEGER,
"avg_p100_dhci_eq" FLOAT,
"avg_p100_dhci_pc" FLOAT,
"avg_p100_dhi_eq" FLOAT,
"avg_p100_dhi_pc" FLOAT,
"avg_p100_mi_eq" FLOAT,
"avg_p100_mi_pc" FLOAT,
"avg_p10_dhci_eq" FLOAT,
"avg_p10_dhci_pc" FLOAT,
"avg_p10_dhi_eq" FLOAT,
"avg_p10_dhi_pc" FLOAT,
"avg_p10_mi_eq" FLOAT,
"avg_p10_mi_pc" FLOAT,
"avg_p20_dhci_eq" FLOAT,
"avg_p20_dhci_pc" FLOAT,
"avg_p20_dhi_eq" FLOAT,
"avg_p20_dhi_pc" FLOAT,
"avg_p20_mi_eq" FLOAT,
"avg_p20_mi_pc" FLOAT,
"avg_p30_dhci_eq" FLOAT,
"avg_p30_dhci_pc" FLOAT,
"avg_p30_dhi_eq" FLOAT,
"avg_p30_dhi_pc" FLOAT,
"avg_p30_mi_eq" FLOAT,
"avg_p30_mi_pc" FLOAT,
"avg_p40_dhci_eq" FLOAT,
"avg_p40_dhci_pc" FLOAT,
"avg_p40_dhi_eq" FLOAT,
"avg_p40_dhi_pc" FLOAT,
"avg_p40_mi_eq" FLOAT,
"avg_p40_mi_pc" FLOAT,
"avg_p50_dhci_eq" FLOAT,
"avg_p50_dhci_pc" FLOAT,
"avg_p50_dhi_eq" FLOAT,
"avg_p50_dhi_pc" FLOAT,
"avg_p50_mi_eq" FLOAT,
"avg_p50_mi_pc" FLOAT,
"avg_p60_dhci_eq" FLOAT,
"avg_p60_dhci_pc" FLOAT,
"avg_p60_dhi_eq" FLOAT,
"avg_p60_dhi_pc" FLOAT,
"avg_p60_mi_eq" FLOAT,
"avg_p60_mi_pc" FLOAT,
"avg_p70_dhci_eq" FLOAT,
"avg_p70_dhci_pc" FLOAT,
"avg_p70_dhi_eq" FLOAT,
"avg_p70_dhi_pc" FLOAT,
"avg_p70_mi_eq" FLOAT,
"avg_p70_mi_pc" FLOAT,
"avg_p80_dhci_eq" FLOAT,
"avg_p80_dhci_pc" FLOAT,
"avg_p80_dhi_eq" FLOAT,
"avg_p80_dhi_pc" FLOAT,
"avg_p80_mi_eq" FLOAT,
"avg_p80_mi_pc" FLOAT,
"avg_p90_dhci_eq" FLOAT,
"avg_p90_dhci_pc" FLOAT,
"avg_p90_dhi_eq" FLOAT,
"avg_p90_dhi_pc" FLOAT,
"avg_p90_mi_eq" FLOAT,
"avg_p90_mi_pc" FLOAT,
"avg_shortfall_40_median_dhci_eq" FLOAT,
"avg_shortfall_40_median_dhci_pc" FLOAT,
"avg_shortfall_40_median_dhi_eq" FLOAT,
"avg_shortfall_40_median_dhi_pc" FLOAT,
"avg_shortfall_40_median_mi_eq" FLOAT,
"avg_shortfall_40_median_mi_pc" FLOAT,
"avg_shortfall_50_median_dhci_eq" FLOAT,
"avg_shortfall_50_median_dhci_pc" FLOAT,
"avg_shortfall_50_median_dhi_eq" FLOAT,
"avg_shortfall_50_median_dhi_pc" FLOAT,
"avg_shortfall_50_median_mi_eq" FLOAT,
"avg_shortfall_50_median_mi_pc" FLOAT,
"avg_shortfall_60_median_dhci_eq" FLOAT,
"avg_shortfall_60_median_dhci_pc" FLOAT,
"avg_shortfall_60_median_dhi_eq" FLOAT,
"avg_shortfall_60_median_dhi_pc" FLOAT,
"avg_shortfall_60_median_mi_eq" FLOAT,
"avg_shortfall_60_median_mi_pc" FLOAT,
"avg_shortfall_dhci_eq_100" FLOAT,
"avg_shortfall_dhci_eq_1000" FLOAT,
"avg_shortfall_dhci_eq_200" FLOAT,
"avg_shortfall_dhci_eq_2000" FLOAT,
"avg_shortfall_dhci_eq_215" FLOAT,
"avg_shortfall_dhci_eq_3000" FLOAT,
"avg_shortfall_dhci_eq_365" FLOAT,
"avg_shortfall_dhci_eq_4000" FLOAT,
"avg_shortfall_dhci_eq_500" FLOAT,
"avg_shortfall_dhci_eq_685" FLOAT,
"avg_shortfall_dhci_pc_100" FLOAT,
"avg_shortfall_dhci_pc_1000" FLOAT,
"avg_shortfall_dhci_pc_200" FLOAT,
"avg_shortfall_dhci_pc_2000" FLOAT,
"avg_shortfall_dhci_pc_215" FLOAT,
"avg_shortfall_dhci_pc_3000" FLOAT,
"avg_shortfall_dhci_pc_365" FLOAT,
"avg_shortfall_dhci_pc_4000" FLOAT,
"avg_shortfall_dhci_pc_500" FLOAT,
"avg_shortfall_dhci_pc_685" FLOAT
);
CREATE TABLE owid_luxembourg_income_study_adults_2 (
"country" VARCHAR,
"year" INTEGER,
"mean_dhci_pc" FLOAT,
"mean_dhci_eq" FLOAT,
"mean_dhi_pc" FLOAT,
"mean_dhi_eq" FLOAT,
"mean_mi_pc" FLOAT,
"mean_mi_eq" FLOAT,
"median_dhci_pc" FLOAT,
"median_dhci_eq" FLOAT,
"median_dhi_pc" FLOAT,
"median_dhi_eq" FLOAT,
"median_mi_pc" FLOAT,
"median_mi_eq" FLOAT,
"gini_dhci_pc" FLOAT,
"gini_dhci_eq" FLOAT,
"gini_dhi_pc" FLOAT,
"gini_dhi_eq" FLOAT,
"gini_mi_pc" FLOAT,
"gini_mi_eq" FLOAT,
"headcount_ratio_40_median_dhci_pc" FLOAT,
"headcount_ratio_40_median_dhci_eq" FLOAT,
"headcount_ratio_40_median_dhi_pc" FLOAT,
"headcount_ratio_40_median_dhi_eq" FLOAT,
"headcount_ratio_40_median_mi_pc" FLOAT,
"headcount_ratio_40_median_mi_eq" FLOAT,
"headcount_ratio_50_median_dhci_pc" FLOAT,
"headcount_ratio_50_median_dhci_eq" FLOAT,
"headcount_ratio_50_median_dhi_pc" FLOAT,
"headcount_ratio_50_median_dhi_eq" FLOAT,
"headcount_ratio_50_median_mi_pc" FLOAT,
"headcount_ratio_50_median_mi_eq" FLOAT,
"headcount_ratio_60_median_dhci_pc" FLOAT,
"headcount_ratio_60_median_dhci_eq" FLOAT,
"headcount_ratio_60_median_dhi_pc" FLOAT,
"headcount_ratio_60_median_dhi_eq" FLOAT,
"headcount_ratio_60_median_mi_pc" FLOAT,
"headcount_ratio_60_median_mi_eq" FLOAT,
"poverty_gap_index_40_median_dhci_pc" FLOAT,
"poverty_gap_index_40_median_dhci_eq" FLOAT,
"poverty_gap_index_40_median_dhi_pc" FLOAT,
"poverty_gap_index_40_median_dhi_eq" FLOAT,
"poverty_gap_index_40_median_mi_pc" FLOAT,
"poverty_gap_index_40_median_mi_eq" FLOAT,
"poverty_gap_index_50_median_dhci_pc" FLOAT,
"poverty_gap_index_50_median_dhci_eq" FLOAT,
"poverty_gap_index_50_median_dhi_pc" FLOAT,
"poverty_gap_index_50_median_dhi_eq" FLOAT,
"poverty_gap_index_50_median_mi_pc" FLOAT,
"poverty_gap_index_50_median_mi_eq" FLOAT,
"poverty_gap_index_60_median_dhci_pc" FLOAT,
"poverty_gap_index_60_median_dhci_eq" FLOAT,
"poverty_gap_index_60_median_dhi_pc" FLOAT,
"poverty_gap_index_60_median_dhi_eq" FLOAT,
"poverty_gap_index_60_median_mi_pc" FLOAT,
"poverty_gap_index_60_median_mi_eq" FLOAT,
"headcount_40_median_dhci_pc" UINTEGER,
"headcount_40_median_dhci_eq" UINTEGER,
"headcount_40_median_dhi_pc" UINTEGER,
"headcount_40_median_dhi_eq" UINTEGER,
"headcount_40_median_mi_pc" UINTEGER,
"headcount_40_median_mi_eq" UINTEGER,
"income_gap_ratio_40_median_dhci_pc" FLOAT,
"income_gap_ratio_40_median_dhci_eq" FLOAT,
"income_gap_ratio_40_median_dhi_pc" FLOAT,
"income_gap_ratio_40_median_dhi_eq" FLOAT,
"income_gap_ratio_40_median_mi_pc" FLOAT,
"income_gap_ratio_40_median_mi_eq" FLOAT,
"avg_shortfall_40_median_dhci_pc" FLOAT,
"avg_shortfall_40_median_dhci_eq" FLOAT,
"avg_shortfall_40_median_dhi_pc" FLOAT,
"avg_shortfall_40_median_dhi_eq" FLOAT,
"avg_shortfall_40_median_mi_pc" FLOAT,
"avg_shortfall_40_median_mi_eq" FLOAT,
"total_shortfall_40_median_dhci_pc" BIGINT,
"total_shortfall_40_median_dhci_eq" BIGINT,
"total_shortfall_40_median_dhi_pc" BIGINT,
"total_shortfall_40_median_dhi_eq" BIGINT,
"total_shortfall_40_median_mi_pc" BIGINT,
"total_shortfall_40_median_mi_eq" BIGINT,
"headcount_50_median_dhci_pc" UINTEGER,
"headcount_50_median_dhci_eq" UINTEGER,
"headcount_50_median_dhi_pc" UINTEGER,
"headcount_50_median_dhi_eq" UINTEGER,
"headcount_50_median_mi_pc" UINTEGER,
"headcount_50_median_mi_eq" UINTEGER,
"income_gap_ratio_50_median_dhci_pc" FLOAT,
"income_gap_ratio_50_median_dhci_eq" FLOAT,
"income_gap_ratio_50_median_dhi_pc" FLOAT,
"income_gap_ratio_50_median_dhi_eq" FLOAT,
"income_gap_ratio_50_median_mi_pc" FLOAT,
"income_gap_ratio_50_median_mi_eq" FLOAT,
"avg_shortfall_50_median_dhci_pc" FLOAT,
"avg_shortfall_50_median_dhci_eq" FLOAT,
"avg_shortfall_50_median_dhi_pc" FLOAT,
"avg_shortfall_50_median_dhi_eq" FLOAT,
"avg_shortfall_50_median_mi_pc" FLOAT,
"avg_shortfall_50_median_mi_eq" FLOAT,
"total_shortfall_50_median_dhci_pc" BIGINT,
"total_shortfall_50_median_dhci_eq" BIGINT
);
CREATE TABLE owid_luxembourg_income_study_adults_3 (
"country" VARCHAR,
"year" INTEGER,
"mean_dhci_pc" FLOAT,
"mean_dhci_eq" FLOAT,
"mean_dhi_pc" FLOAT,
"mean_dhi_eq" FLOAT,
"mean_mi_pc" FLOAT,
"mean_mi_eq" FLOAT,
"median_dhci_pc" FLOAT,
"median_dhci_eq" FLOAT,
"median_dhi_pc" FLOAT,
"median_dhi_eq" FLOAT,
"median_mi_pc" FLOAT,
"median_mi_eq" FLOAT,
"gini_dhci_pc" FLOAT,
"gini_dhci_eq" FLOAT,
"gini_dhi_pc" FLOAT,
"gini_dhi_eq" FLOAT,
"gini_mi_pc" FLOAT,
"gini_mi_eq" FLOAT,
"headcount_ratio_40_median_dhci_pc" FLOAT,
"headcount_ratio_40_median_dhci_eq" FLOAT,
"headcount_ratio_40_median_dhi_pc" FLOAT,
"headcount_ratio_40_median_dhi_eq" FLOAT,
"headcount_ratio_40_median_mi_pc" FLOAT,
"headcount_ratio_40_median_mi_eq" FLOAT,
"headcount_ratio_50_median_dhci_pc" FLOAT,
"headcount_ratio_50_median_dhci_eq" FLOAT,
"headcount_ratio_50_median_dhi_pc" FLOAT,
"headcount_ratio_50_median_dhi_eq" FLOAT,
"headcount_ratio_50_median_mi_pc" FLOAT,
"headcount_ratio_50_median_mi_eq" FLOAT,
"headcount_ratio_60_median_dhci_pc" FLOAT,
"headcount_ratio_60_median_dhci_eq" FLOAT,
"headcount_ratio_60_median_dhi_pc" FLOAT,
"headcount_ratio_60_median_dhi_eq" FLOAT,
"headcount_ratio_60_median_mi_pc" FLOAT,
"headcount_ratio_60_median_mi_eq" FLOAT,
"poverty_gap_index_40_median_dhci_pc" FLOAT,
"poverty_gap_index_40_median_dhci_eq" FLOAT,
"poverty_gap_index_40_median_dhi_pc" FLOAT,
"poverty_gap_index_40_median_dhi_eq" FLOAT,
"poverty_gap_index_40_median_mi_pc" FLOAT,
"poverty_gap_index_40_median_mi_eq" FLOAT,
"poverty_gap_index_50_median_dhci_pc" FLOAT,
"poverty_gap_index_50_median_dhci_eq" FLOAT,
"poverty_gap_index_50_median_dhi_pc" FLOAT,
"poverty_gap_index_50_median_dhi_eq" FLOAT,
"poverty_gap_index_50_median_mi_pc" FLOAT,
"poverty_gap_index_50_median_mi_eq" FLOAT,
"poverty_gap_index_60_median_dhci_pc" FLOAT,
"poverty_gap_index_60_median_dhci_eq" FLOAT,
"poverty_gap_index_60_median_dhi_pc" FLOAT,
"poverty_gap_index_60_median_dhi_eq" FLOAT,
"poverty_gap_index_60_median_mi_pc" FLOAT,
"poverty_gap_index_60_median_mi_eq" FLOAT,
"headcount_40_median_dhci_pc" UINTEGER,
"headcount_40_median_dhci_eq" UINTEGER,
"headcount_40_median_dhi_pc" UINTEGER,
"headcount_40_median_dhi_eq" UINTEGER,
"headcount_40_median_mi_pc" UINTEGER,
"headcount_40_median_mi_eq" UINTEGER,
"income_gap_ratio_40_median_dhci_pc" FLOAT,
"income_gap_ratio_40_median_dhci_eq" FLOAT,
"income_gap_ratio_40_median_dhi_pc" FLOAT,
"income_gap_ratio_40_median_dhi_eq" FLOAT,
"income_gap_ratio_40_median_mi_pc" FLOAT,
"income_gap_ratio_40_median_mi_eq" FLOAT,
"avg_shortfall_40_median_dhci_pc" FLOAT,
"avg_shortfall_40_median_dhci_eq" FLOAT,
"avg_shortfall_40_median_dhi_pc" FLOAT,
"avg_shortfall_40_median_dhi_eq" FLOAT,
"avg_shortfall_40_median_mi_pc" FLOAT,
"avg_shortfall_40_median_mi_eq" FLOAT,
"total_shortfall_40_median_dhci_pc" BIGINT,
"total_shortfall_40_median_dhci_eq" BIGINT,
"total_shortfall_40_median_dhi_pc" BIGINT,
"total_shortfall_40_median_dhi_eq" BIGINT,
"total_shortfall_40_median_mi_pc" BIGINT,
"total_shortfall_40_median_mi_eq" BIGINT,
"headcount_50_median_dhci_pc" UINTEGER,
"headcount_50_median_dhci_eq" UINTEGER,
"headcount_50_median_dhi_pc" UINTEGER,
"headcount_50_median_dhi_eq" UINTEGER,
"headcount_50_median_mi_pc" UINTEGER,
"headcount_50_median_mi_eq" UINTEGER,
"income_gap_ratio_50_median_dhci_pc" FLOAT,
"income_gap_ratio_50_median_dhci_eq" FLOAT,
"income_gap_ratio_50_median_dhi_pc" FLOAT,
"income_gap_ratio_50_median_dhi_eq" FLOAT,
"income_gap_ratio_50_median_mi_pc" FLOAT,
"income_gap_ratio_50_median_mi_eq" FLOAT,
"avg_shortfall_50_median_dhci_pc" FLOAT,
"avg_shortfall_50_median_dhci_eq" FLOAT,
"avg_shortfall_50_median_dhi_pc" FLOAT,
"avg_shortfall_50_median_dhi_eq" FLOAT,
"avg_shortfall_50_median_mi_pc" FLOAT,
"avg_shortfall_50_median_mi_eq" FLOAT,
"total_shortfall_50_median_dhci_pc" BIGINT,
"total_shortfall_50_median_dhci_eq" BIGINT
);
Anyone who has the link will be able to view this.