The Human Freedom Index
A global measurement of personal, civil, and economic freedom
@kaggle.gsutters_the_human_freedom_index
A global measurement of personal, civil, and economic freedom
@kaggle.gsutters_the_human_freedom_index
CREATE TABLE hfi_cc_2018 (
"year" BIGINT,
"iso_code" VARCHAR,
"countries" VARCHAR,
"region" VARCHAR,
"pf_rol_procedural" DOUBLE,
"pf_rol_civil" DOUBLE,
"pf_rol_criminal" DOUBLE,
"pf_rol" DOUBLE,
"pf_ss_homicide" DOUBLE,
"pf_ss_disappearances_disap" DOUBLE,
"pf_ss_disappearances_violent" DOUBLE,
"pf_ss_disappearances_organized" DOUBLE,
"pf_ss_disappearances_fatalities" DOUBLE,
"pf_ss_disappearances_injuries" DOUBLE,
"pf_ss_disappearances" DOUBLE,
"pf_ss_women_fgm" DOUBLE,
"pf_ss_women_missing" DOUBLE,
"pf_ss_women_inheritance_widows" DOUBLE,
"pf_ss_women_inheritance_daughters" DOUBLE,
"pf_ss_women_inheritance" DOUBLE,
"pf_ss_women" DOUBLE,
"pf_ss" DOUBLE,
"pf_movement_domestic" DOUBLE,
"pf_movement_foreign" DOUBLE,
"pf_movement_women" DOUBLE,
"pf_movement" DOUBLE,
"pf_religion_estop_establish" DOUBLE,
"pf_religion_estop_operate" DOUBLE,
"pf_religion_estop" DOUBLE,
"pf_religion_harassment" DOUBLE,
"pf_religion_restrictions" DOUBLE,
"pf_religion" DOUBLE,
"pf_association_association" DOUBLE,
"pf_association_assembly" DOUBLE,
"pf_association_political_establish" DOUBLE,
"pf_association_political_operate" DOUBLE,
"pf_association_political" DOUBLE,
"pf_association_prof_establish" DOUBLE,
"pf_association_prof_operate" DOUBLE,
"pf_association_prof" DOUBLE,
"pf_association_sport_establish" DOUBLE,
"pf_association_sport_operate" DOUBLE,
"pf_association_sport" DOUBLE,
"pf_association" DOUBLE,
"pf_expression_killed" DOUBLE,
"pf_expression_jailed" DOUBLE,
"pf_expression_influence" DOUBLE,
"pf_expression_control" DOUBLE,
"pf_expression_cable" DOUBLE,
"pf_expression_newspapers" DOUBLE,
"pf_expression_internet" DOUBLE,
"pf_expression" DOUBLE,
"pf_identity_legal" DOUBLE,
"pf_identity_parental_marriage" DOUBLE,
"pf_identity_parental_divorce" DOUBLE,
"pf_identity_parental" DOUBLE,
"pf_identity_sex_male" DOUBLE,
"pf_identity_sex_female" DOUBLE,
"pf_identity_sex" DOUBLE,
"pf_identity_divorce" DOUBLE,
"pf_identity" DOUBLE,
"pf_score" DOUBLE,
"pf_rank" DOUBLE,
"ef_government_consumption" DOUBLE,
"ef_government_transfers" DOUBLE,
"ef_government_enterprises" DOUBLE,
"ef_government_tax_income" DOUBLE,
"ef_government_tax_payroll" DOUBLE,
"ef_government_tax" DOUBLE,
"ef_government" DOUBLE,
"ef_legal_judicial" DOUBLE,
"ef_legal_courts" DOUBLE,
"ef_legal_protection" DOUBLE,
"ef_legal_military" DOUBLE,
"ef_legal_integrity" DOUBLE,
"ef_legal_enforcement" DOUBLE,
"ef_legal_restrictions" DOUBLE,
"ef_legal_police" DOUBLE,
"ef_legal_crime" DOUBLE,
"ef_legal_gender" DOUBLE,
"ef_legal" DOUBLE,
"ef_money_growth" DOUBLE,
"ef_money_sd" DOUBLE,
"ef_money_inflation" DOUBLE,
"ef_money_currency" DOUBLE,
"ef_money" DOUBLE,
"ef_trade_tariffs_revenue" DOUBLE,
"ef_trade_tariffs_mean" DOUBLE,
"ef_trade_tariffs_sd" DOUBLE,
"ef_trade_tariffs" DOUBLE,
"ef_trade_regulatory_nontariff" DOUBLE,
"ef_trade_regulatory_compliance" DOUBLE,
"ef_trade_regulatory" DOUBLE,
"ef_trade_black" DOUBLE,
"ef_trade_movement_foreign" DOUBLE,
"ef_trade_movement_capital" DOUBLE,
"ef_trade_movement_visit" DOUBLE,
"ef_trade_movement" DOUBLE,
"ef_trade" DOUBLE,
"ef_regulation_credit_ownership" DOUBLE
);
CREATE TABLE hfi_cc_2019 (
"year" BIGINT,
"iso_code" VARCHAR,
"countries" VARCHAR,
"region" VARCHAR,
"hf_score" VARCHAR,
"hf_rank" VARCHAR,
"hf_quartile" VARCHAR,
"pf_rol_procedural" VARCHAR,
"pf_rol_civil" VARCHAR,
"pf_rol_criminal" VARCHAR,
"pf_rol" VARCHAR,
"pf_ss_homicide" VARCHAR,
"pf_ss_disappearances_disap" VARCHAR,
"pf_ss_disappearances_violent" VARCHAR,
"pf_ss_disappearances_organized" VARCHAR,
"pf_ss_disappearances_fatalities" VARCHAR,
"pf_ss_disappearances_injuries" VARCHAR,
"pf_ss_disappearances" VARCHAR,
"pf_ss_women_fgm" VARCHAR,
"pf_ss_women_inheritance_widows" VARCHAR,
"pf_ss_women_inheritance_daughters" VARCHAR,
"pf_ss_women_inheritance" VARCHAR,
"pf_ss_women" VARCHAR,
"pf_ss" VARCHAR,
"pf_movement_domestic" VARCHAR,
"pf_movement_foreign" VARCHAR,
"pf_movement_women" VARCHAR,
"pf_movement" VARCHAR,
"pf_religion_estop_establish" VARCHAR,
"pf_religion_estop_operate" VARCHAR,
"pf_religion_estop" VARCHAR,
"pf_religion_harassment" VARCHAR,
"pf_religion_restrictions" VARCHAR,
"pf_religion" VARCHAR,
"pf_association_association" VARCHAR,
"pf_association_assembly" VARCHAR,
"pf_association_political_establish" VARCHAR,
"pf_association_political_operate" VARCHAR,
"pf_association_political" VARCHAR,
"pf_association_prof_establish" VARCHAR,
"pf_association_prof_operate" VARCHAR,
"pf_association_prof" VARCHAR,
"pf_association_sport_establish" VARCHAR,
"pf_association_sport_operate" VARCHAR,
"pf_association_sport" VARCHAR,
"pf_association" VARCHAR,
"pf_expression_killed" VARCHAR,
"pf_expression_jailed" VARCHAR,
"pf_expression_influence" VARCHAR,
"pf_expression_control" VARCHAR,
"pf_expression_cable" VARCHAR,
"pf_expression_newspapers" VARCHAR,
"pf_expression_internet" VARCHAR,
"pf_expression" VARCHAR,
"pf_identity_legal" VARCHAR,
"pf_identity_sex_male" VARCHAR,
"pf_identity_sex_female" VARCHAR,
"pf_identity_sex" VARCHAR,
"pf_identity_divorce" VARCHAR,
"pf_identity" VARCHAR,
"pf_score" VARCHAR,
"pf_rank" VARCHAR,
"ef_government_consumption" VARCHAR,
"ef_government_transfers" VARCHAR,
"ef_government_enterprises" VARCHAR,
"ef_government_tax_income" VARCHAR,
"ef_government_tax_payroll" VARCHAR,
"ef_government_tax" VARCHAR,
"ef_government_soa" VARCHAR,
"ef_government" VARCHAR,
"ef_legal_judicial" VARCHAR,
"ef_legal_courts" VARCHAR,
"ef_legal_protection" VARCHAR,
"ef_legal_military" VARCHAR,
"ef_legal_integrity" VARCHAR,
"ef_legal_enforcement" VARCHAR,
"ef_legal_restrictions" VARCHAR,
"ef_legal_police" VARCHAR,
"ef_legal_crime" VARCHAR,
"ef_legal_gender" VARCHAR,
"ef_legal" VARCHAR,
"ef_money_growth" VARCHAR,
"ef_money_sd" VARCHAR,
"ef_money_inflation" VARCHAR,
"ef_money_currency" VARCHAR,
"ef_money" VARCHAR,
"ef_trade_tariffs_revenue" VARCHAR,
"ef_trade_tariffs_mean" VARCHAR,
"ef_trade_tariffs_sd" VARCHAR,
"ef_trade_tariffs" VARCHAR,
"ef_trade_regulatory_nontariff" VARCHAR,
"ef_trade_regulatory_compliance" VARCHAR,
"ef_trade_regulatory" VARCHAR,
"ef_trade_black" VARCHAR,
"ef_trade_movement_foreign" VARCHAR,
"ef_trade_movement_capital" VARCHAR,
"ef_trade_movement_visit" VARCHAR,
"ef_trade_movement" VARCHAR,
"ef_trade" VARCHAR,
"ef_regulation_credit_ownership" VARCHAR
);
CREATE TABLE hfi_cc_2020 (
"unnamed_0" BIGINT,
"year" BIGINT,
"iso_code" VARCHAR,
"countries" VARCHAR,
"region" VARCHAR,
"hf_score" DOUBLE,
"hf_rank" DOUBLE,
"hf_quartile" DOUBLE,
"pf_rol_procedural" DOUBLE,
"pf_rol_civil" DOUBLE,
"pf_rol_criminal" DOUBLE,
"pf_rol" DOUBLE,
"pf_ss_homicide" DOUBLE,
"pf_ss_disappearances_disap" DOUBLE,
"pf_ss_disappearances_violent" DOUBLE,
"pf_ss_disappearances_organized" DOUBLE,
"pf_ss_disappearances_fatalities" DOUBLE,
"pf_ss_disappearances_injuries" DOUBLE,
"pf_ss_disappearances" DOUBLE,
"pf_ss_women_fgm" DOUBLE,
"pf_ss_women_inheritance" DOUBLE,
"pf_ss_women" DOUBLE,
"pf_ss" DOUBLE,
"pf_movement_domestic" DOUBLE,
"pf_movement_foreign" DOUBLE,
"pf_movement_women" DOUBLE,
"pf_movement" DOUBLE,
"pf_religion_freedom" DOUBLE,
"pf_religion_repression" DOUBLE,
"pf_religion_harassment" DOUBLE,
"pf_religion_restrictions" DOUBLE,
"pf_religion" DOUBLE,
"pf_association_entry" DOUBLE,
"pf_association_assembly" DOUBLE,
"pf_association_barries" DOUBLE,
"pf_association_bans" DOUBLE,
"pf_association_estopparties" DOUBLE,
"pf_association_opposition" DOUBLE,
"pf_association_civilrepression" DOUBLE,
"pf_association" DOUBLE,
"pf_expression_killed" DOUBLE,
"pf_expression_jailed" DOUBLE,
"pf_expression_media" DOUBLE,
"pf_expression_cable" DOUBLE,
"pf_expression_newspapers" DOUBLE,
"pf_expression_control" DOUBLE,
"pf_expression" DOUBLE,
"pf_identity_legal" DOUBLE,
"pf_identity_sex_male" DOUBLE,
"pf_identity_sex_female" DOUBLE,
"pf_identity_sex" DOUBLE,
"pf_identity_divorce" DOUBLE,
"pf_identity" DOUBLE,
"pf_score" DOUBLE,
"pf_rank" DOUBLE,
"ef_government_consumption" DOUBLE,
"ef_government_transfers" DOUBLE,
"ef_government_enterprises" DOUBLE,
"ef_government_tax_income" DOUBLE,
"ef_government_tax_payroll" DOUBLE,
"ef_government_tax" DOUBLE,
"ef_government_soa" DOUBLE,
"ef_government" DOUBLE,
"ef_legal_judicial" DOUBLE,
"ef_legal_courts" DOUBLE,
"ef_legal_protection" DOUBLE,
"ef_legal_military" DOUBLE,
"ef_legal_integrity" DOUBLE,
"ef_legal_enforcement" DOUBLE,
"ef_legal_regulatory" DOUBLE,
"ef_legal_police" DOUBLE,
"ef_legal_gender" DOUBLE,
"ef_legal" DOUBLE,
"ef_money_growth" DOUBLE,
"ef_money_sd" DOUBLE,
"ef_money_inflation" DOUBLE,
"ef_money_currency" DOUBLE,
"ef_money" DOUBLE,
"ef_trade_tariffs_revenue" DOUBLE,
"ef_trade_tariffs_mean" DOUBLE,
"ef_trade_tariffs_sd" DOUBLE,
"ef_trade_tariffs" DOUBLE,
"ef_trade_regulatory_nontariff" DOUBLE,
"ef_trade_regulatory_compliance" DOUBLE,
"ef_trade_regulatory" DOUBLE,
"ef_trade_black" DOUBLE,
"ef_trade_movement_foreign" DOUBLE,
"ef_trade_movement_capital" DOUBLE,
"ef_trade_movement_visit" DOUBLE,
"ef_trade_movement" DOUBLE,
"ef_trade" DOUBLE,
"ef_regulation_credit_ownership" DOUBLE,
"ef_regulation_credit_private" DOUBLE,
"ef_regulation_credit_interest" DOUBLE,
"ef_regulation_credit" DOUBLE,
"ef_regulation_labor_minwage" DOUBLE,
"ef_regulation_labor_firing" DOUBLE,
"ef_regulation_labor_bargain" DOUBLE,
"ef_regulation_labor_hours" DOUBLE,
"ef_regulation_labor_dismissal" DOUBLE
);
CREATE TABLE hfi_cc_2021 (
"year" BIGINT,
"countries" VARCHAR,
"iso" VARCHAR,
"region" VARCHAR,
"hf_score" DOUBLE,
"hf_rank" DOUBLE,
"hf_quartile" DOUBLE,
"pf_rol_procedural" DOUBLE,
"pf_rol_civil" DOUBLE,
"pf_rol_criminal" DOUBLE,
"pf_rol" DOUBLE,
"pf_ss_homicide" DOUBLE,
"pf_ss_disappearances_disap" DOUBLE,
"pf_ss_disappearances_violent" DOUBLE,
"pf_ss_disappearances_organized" DOUBLE,
"pf_ss_disappearances_fatalities" DOUBLE,
"pf_ss_disappearances_injuries" DOUBLE,
"pf_ss_disappearances_torture" DOUBLE,
"pf_ss_killings" DOUBLE,
"pf_ss_disappearances" DOUBLE,
"pf_ss" DOUBLE,
"pf_movement_vdem_foreign" DOUBLE,
"pf_movement_vdem_men" DOUBLE,
"pf_movement_vdem_women" DOUBLE,
"pf_movement_vdem" DOUBLE,
"pf_movement_cld" DOUBLE,
"pf_movement" DOUBLE,
"pf_religion_suppression" DOUBLE,
"pf_religion_freedom_vdem" DOUBLE,
"pf_religion_freedom_cld" DOUBLE,
"pf_religion_freedom" DOUBLE,
"pf_religion" DOUBLE,
"pf_assembly_entry" DOUBLE,
"pf_assembly_freedom_house" DOUBLE,
"pf_assembly_freedom_bti" DOUBLE,
"pf_assembly_freedom_cld" DOUBLE,
"pf_assembly_freedom" DOUBLE,
"pf_assembly_parties_barriers" DOUBLE,
"pf_assembly_parties_bans" DOUBLE,
"pf_assembly_parties_auton" DOUBLE,
"pf_assembly_parties" DOUBLE,
"pf_assembly_civil" DOUBLE,
"pf_assembly" DOUBLE,
"pf_assembly_rank" BIGINT,
"pf_expression_killed" DOUBLE,
"pf_expression_jailed" DOUBLE,
"pf_expression_media" DOUBLE,
"pf_expression_cultural" DOUBLE,
"pf_expression_gov" DOUBLE,
"pf_expression_internet" DOUBLE,
"pf_expression_harass" DOUBLE,
"pf_expression_selfcens" DOUBLE,
"pf_expression_freedom_bti" DOUBLE,
"pf_expression_freedom_cld" DOUBLE,
"pf_expression_freedom" DOUBLE,
"pf_expression" DOUBLE,
"pf_expression_rank" BIGINT,
"pf_identity_same_m" DOUBLE,
"pf_identity_same_f" DOUBLE,
"pf_identity_same" DOUBLE,
"pf_identity_divorce" DOUBLE,
"pf_identity_fgm" DOUBLE,
"pf_identity_inheritance_widows" DOUBLE,
"pf_identity_inheritance_daughters" DOUBLE,
"pf_identity_inheritance" DOUBLE,
"pf_identity" DOUBLE,
"pf_score" DOUBLE,
"pf_rank" DOUBLE,
"pf_womens" DOUBLE,
"ef_government_consumption" DOUBLE,
"ef_government_transfers" DOUBLE,
"ef_government_enterprises" DOUBLE,
"ef_government_tax_income" DOUBLE,
"ef_government_tax_payroll" DOUBLE,
"ef_government_tax" DOUBLE,
"ef_government_soa" DOUBLE,
"ef_government" DOUBLE,
"ef_legal_judicial" DOUBLE,
"ef_legal_courts" DOUBLE,
"ef_legal_protection" DOUBLE,
"ef_legal_military" DOUBLE,
"ef_legal_integrity" DOUBLE,
"ef_legal_enforcement" DOUBLE,
"ef_legal_regulatory" DOUBLE,
"ef_legal_police" DOUBLE,
"ef_legal" DOUBLE,
"ef_money_growth" DOUBLE,
"ef_money_sd" DOUBLE,
"ef_money_inflation" DOUBLE,
"ef_money_currency" DOUBLE,
"ef_money" DOUBLE,
"ef_trade_tariffs_revenue" DOUBLE,
"ef_trade_tariffs_mean" DOUBLE,
"ef_trade_tariffs_sd" DOUBLE,
"ef_trade_tariffs" DOUBLE,
"ef_trade_regulatory_nontariff" DOUBLE,
"ef_trade_regulatory_compliance" DOUBLE,
"ef_trade_regulatory" DOUBLE,
"ef_trade_black" DOUBLE,
"ef_trade_movement_foreign" DOUBLE
);
CREATE TABLE hfi_cc_2022 (
"year" BIGINT,
"countries" VARCHAR,
"region" VARCHAR,
"hf_score" DOUBLE,
"hf_rank" DOUBLE,
"hf_quartile" DOUBLE,
"pf_rol_procedural" DOUBLE,
"pf_rol_civil" DOUBLE,
"pf_rol_criminal" DOUBLE,
"pf_rol_vdem" DOUBLE,
"pf_rol" DOUBLE,
"pf_ss_homicide" DOUBLE,
"pf_ss_homicide_data" DOUBLE,
"pf_ss_disappearances_disap" DOUBLE,
"pf_ss_disappearances_violent" DOUBLE,
"pf_ss_disappearances_violent_data" DOUBLE,
"pf_ss_disappearances_organized" DOUBLE,
"pf_ss_disappearances_fatalities" DOUBLE,
"pf_ss_disappearances_fatalities_data" DOUBLE,
"pf_ss_disappearances_injuries" DOUBLE,
"pf_ss_disappearances_injuries_data" DOUBLE,
"pf_ss_disappearances_torture" DOUBLE,
"pf_ss_killings" DOUBLE,
"pf_ss_disappearances" DOUBLE,
"pf_ss" DOUBLE,
"pf_movement_vdem_foreign" DOUBLE,
"pf_movement_vdem_men" DOUBLE,
"pf_movement_vdem_women" DOUBLE,
"pf_movement_vdem" DOUBLE,
"pf_movement_cld" DOUBLE,
"pf_movement" DOUBLE,
"pf_religion_freedom_vdem" DOUBLE,
"pf_religion_freedom_cld" DOUBLE,
"pf_religion_freedom" DOUBLE,
"pf_religion_suppression" DOUBLE,
"pf_religion" DOUBLE,
"pf_assembly_entry" DOUBLE,
"pf_assembly_freedom_house" DOUBLE,
"pf_assembly_freedom_bti" DOUBLE,
"pf_assembly_freedom_cld" DOUBLE,
"pf_assembly_freedom" DOUBLE,
"pf_assembly_parties_barriers" DOUBLE,
"pf_assembly_parties_bans" DOUBLE,
"pf_assembly_parties_auton" DOUBLE,
"pf_assembly_parties" DOUBLE,
"pf_assembly_civil" DOUBLE,
"pf_assembly" DOUBLE,
"pf_expression_direct_killed" DOUBLE,
"pf_expression_direct_killed_data" BIGINT,
"pf_expression_direct_jailed" DOUBLE,
"pf_expression_direct_jailed_data" BIGINT,
"pf_expression_direct" DOUBLE,
"pf_expression_vdem_cultural" DOUBLE,
"pf_expression_vdem_harass" DOUBLE,
"pf_expression_vdem_gov" DOUBLE,
"pf_expression_vdem_internet" DOUBLE,
"pf_expression_vdem_selfcens" DOUBLE,
"pf_expression_vdem" DOUBLE,
"pf_expression_house" DOUBLE,
"pf_expression_bti" DOUBLE,
"pf_expression_cld" DOUBLE,
"pf_expression" DOUBLE,
"pf_identity_same_m" DOUBLE,
"pf_identity_same_f" DOUBLE,
"pf_identity_same" DOUBLE,
"pf_identity_divorce" DOUBLE,
"pf_identity_inheritance_widows" DOUBLE,
"pf_identity_inheritance_daughters" DOUBLE,
"pf_identity_inheritance" DOUBLE,
"pf_identity_fgm" DOUBLE,
"pf_identity" DOUBLE,
"pf_score" DOUBLE,
"pf_rank" DOUBLE,
"ef_government_consumption" DOUBLE,
"ef_government_consumption_data" DOUBLE,
"ef_government_transfers" DOUBLE,
"ef_government_transfers_data" DOUBLE,
"ef_government_investment" DOUBLE,
"ef_government_investment_data" DOUBLE,
"ef_government_tax_income" DOUBLE,
"ef_government_tax_income_data" VARCHAR,
"ef_government_tax_payroll" DOUBLE,
"ef_government_tax_payroll_data" VARCHAR,
"ef_government_tax" DOUBLE,
"ef_government_soa" DOUBLE,
"ef_government" DOUBLE,
"ef_legal_judicial" DOUBLE,
"ef_legal_courts" DOUBLE,
"ef_legal_protection" DOUBLE,
"ef_legal_military" DOUBLE,
"ef_legal_integrity" DOUBLE,
"ef_legal_enforcement" DOUBLE,
"ef_legal_regulatory" DOUBLE,
"ef_legal_police" DOUBLE,
"ef_gender" DOUBLE,
"ef_legal" DOUBLE,
"ef_money_growth" DOUBLE,
"ef_money_growth_data" DOUBLE,
"ef_money_sd" DOUBLE,
"ef_money_sd_data" DOUBLE
);
Anyone who has the link will be able to view this.