Internet Inclusivity Index 2017 - 2021
Accessibility, affordability, relevance, and usage of the internet.
@kaggle.kwamsahortor_internet_inclusivity_index_2017_2021
Accessibility, affordability, relevance, and usage of the internet.
@kaggle.kwamsahortor_internet_inclusivity_index_2017_2021
CREATE TABLE internet_inclusivity_index_data_table (
"country" VARCHAR,
"edition" VARCHAR,
"n_1_1_1_internet_users" DOUBLE,
"n_1_1_2_fixed_line_broadband_subscribers" DOUBLE,
"n_1_1_3_mobile_subscribers" DOUBLE,
"n_1_1_4_gender_gap_in_internet_access" DOUBLE,
"n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE,
"n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE,
"n_1_2_2_average_fixed_broadband_download_speed" DOUBLE,
"n_1_2_3_average_fixed_broadband_latency" DOUBLE,
"n_1_2_4_average_mobile_upload_speed" DOUBLE,
"n_1_2_5_average_mobile_download_speed" DOUBLE,
"n_1_2_6_average_mobile_latency" DOUBLE,
"n_1_2_7_bandwidth_capacity" DOUBLE,
"n_1_3_1_network_coverage_min_2g" DOUBLE,
"n_1_3_2_network_coverage_min_3g" DOUBLE,
"n_1_3_3_network_coverage_min_4g" DOUBLE,
"n_1_3_4_5g_deployment" DOUBLE,
"n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_7_unlicensed_spectrum_policy" DOUBLE,
"n_1_3_8_internet_exchange_points" DOUBLE,
"n_1_4_1_urban_electricity_access" DOUBLE,
"n_1_4_2_rural_electricity_access" DOUBLE,
"n_2_1_1_smartphone_cost_handset" DOUBLE,
"n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE,
"n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE,
"n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE,
"n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE,
"n_2_2_2_wireless_operators_market_share" BIGINT,
"n_2_2_3_broadband_operators_market_share" BIGINT,
"n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE,
"n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE,
"n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE,
"n_3_2_1_e_finance_content" DOUBLE,
"n_3_2_2_value_of_e_finance" DOUBLE,
"n_3_2_3_e_health_content" DOUBLE,
"n_3_2_4_value_of_e_health" DOUBLE,
"n_3_2_5_e_entertainment_usage" DOUBLE,
"n_3_2_6_e_commerce_content" DOUBLE,
"n_3_2_7_value_of_e_commerce" DOUBLE,
"n_3_2_8_open_data_policies" DOUBLE,
"n_4_1_1_level_of_literacy" DOUBLE,
"n_4_1_2_educational_attainment" DOUBLE,
"n_4_1_3_support_for_digital_literacy" DOUBLE,
"n_4_1_4_level_of_web_accessibility" DOUBLE,
"n_4_2_1_privacy_regulations" DOUBLE,
"n_4_2_2_trust_in_online_privacy" DOUBLE,
"n_4_2_3_trust_in_government_websites_and_apps" DOUBLE,
"n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE,
"n_4_2_5_trust_in_information_from_social_media" DOUBLE,
"n_4_2_6_e_commerce_safety" DOUBLE,
"n_4_3_1_national_female_e_inclusion_policies" DOUBLE,
"n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE,
"n_4_3_1_2_female_digital_skills_training_plan" DOUBLE,
"n_4_3_1_3_female_stem_education_plan" DOUBLE,
"n_4_3_2_government_e_inclusion_strategy" DOUBLE,
"n_4_3_3_national_broadband_strategy" DOUBLE,
"n_4_3_4_funding_for_broadband_buildout" DOUBLE,
"n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE,
"n_4_3_6_national_digital_identification_system" BIGINT,
"n_4_3_7_government_efforts_to_promote_5g" DOUBLE,
"bg1_nominal_gdp" DOUBLE,
"bg2_population" DOUBLE,
"bg3_urban_population" DOUBLE,
"bg4_gni_per_capita" BIGINT,
"bg5_gini_coefficient" DOUBLE,
"bg6_population_under_the_poverty_line" DOUBLE,
"bg7_total_electricity_access" DOUBLE,
"bg8_cable_landing_stations" DOUBLE,
"bg9_percentage_of_schools_with_internet_access" DOUBLE,
"bg10_global_peace_index" DOUBLE,
"bg11_democracy_index" DOUBLE,
"bg12_corruption_perceptions_index" BIGINT,
"bg13_eiu_business_environment_rankings" DOUBLE,
"bg14_un_e_government_development_index" DOUBLE,
"bg15_internet_users_population" DOUBLE,
"bg16_offline_population" DOUBLE,
"bg17_internet_access_gender_gap" DOUBLE,
"bg18_mobile_phone_access_gender_gap" DOUBLE,
"bg19_internet_users_percent_of_population" DOUBLE,
"bg20_male_internet_users" DOUBLE,
"bg21_female_internet_users" DOUBLE,
"bg22_male_mobile_phone_subscribers" DOUBLE,
"bg23_female_mobile_phone_subscribers" DOUBLE,
"bg24_total_fixed_line_broadband_subscribers" BIGINT
);
CREATE TABLE internet_inclusivity_index_score_default_weight_profile (
"country" VARCHAR,
"edition" VARCHAR,
"overall" DOUBLE,
"n_1_availability" DOUBLE,
"n_1_1_usage" DOUBLE,
"n_1_1_1_internet_users" DOUBLE,
"n_1_1_2_fixed_line_broadband_subscribers" DOUBLE,
"n_1_1_3_mobile_subscribers" DOUBLE,
"n_1_1_4_gender_gap_in_internet_access" DOUBLE,
"n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE,
"n_1_2_quality" DOUBLE,
"n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE,
"n_1_2_2_average_fixed_broadband_download_speed" DOUBLE,
"n_1_2_3_average_fixed_broadband_latency" DOUBLE,
"n_1_2_4_average_mobile_upload_speed" DOUBLE,
"n_1_2_5_average_mobile_download_speed" DOUBLE,
"n_1_2_6_average_mobile_latency" DOUBLE,
"n_1_2_7_bandwidth_capacity" DOUBLE,
"n_1_3_infrastructure" DOUBLE,
"n_1_3_1_network_coverage_min_2g" DOUBLE,
"n_1_3_2_network_coverage_min_3g" DOUBLE,
"n_1_3_3_network_coverage_min_4g" DOUBLE,
"n_1_3_4_5g_deployment" DOUBLE,
"n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_7_unlicensed_spectrum_policy" DOUBLE,
"n_1_3_8_internet_exchange_points" DOUBLE,
"n_1_4_electricity" DOUBLE,
"n_1_4_1_urban_electricity_access" DOUBLE,
"n_1_4_2_rural_electricity_access" DOUBLE,
"n_2_affordability" DOUBLE,
"n_2_1_price" DOUBLE,
"n_2_1_1_smartphone_cost_handset" DOUBLE,
"n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE,
"n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE,
"n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE,
"n_2_2_competitive_environment" DOUBLE,
"n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE,
"n_2_2_2_wireless_operators_market_share" BIGINT,
"n_2_2_3_broadband_operators_market_share" BIGINT,
"n_3_relevance" DOUBLE,
"n_3_1_local_content" DOUBLE,
"n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE,
"n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE,
"n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE,
"n_3_2_relevant_content" DOUBLE,
"n_3_2_1_e_finance_content" DOUBLE,
"n_3_2_2_value_of_e_finance" DOUBLE,
"n_3_2_3_e_health_content" DOUBLE,
"n_3_2_4_value_of_e_health" DOUBLE,
"n_3_2_5_e_entertainment_usage" DOUBLE,
"n_3_2_6_e_commerce_content" DOUBLE,
"n_3_2_7_value_of_e_commerce" DOUBLE,
"n_3_2_8_open_data_policies" DOUBLE,
"n_4_readiness" DOUBLE,
"n_4_1_literacy" DOUBLE,
"n_4_1_1_level_of_literacy" DOUBLE,
"n_4_1_2_educational_attainment" DOUBLE,
"n_4_1_3_support_for_digital_literacy" DOUBLE,
"n_4_1_4_level_of_web_accessibility" DOUBLE,
"n_4_2_trust_safety" DOUBLE,
"n_4_2_1_privacy_regulations" DOUBLE,
"n_4_2_2_trust_in_online_privacy" DOUBLE,
"n_4_2_3_trust_in_government_websites_and_apps" DOUBLE,
"n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE,
"n_4_2_5_trust_in_information_from_social_media" DOUBLE,
"n_4_2_6_e_commerce_safety" DOUBLE,
"n_4_3_policy" DOUBLE,
"n_4_3_1_national_female_e_inclusion_policies" DOUBLE,
"n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE,
"n_4_3_1_2_female_digital_skills_training_plan" DOUBLE,
"n_4_3_1_3_female_stem_education_plan" DOUBLE,
"n_4_3_2_government_e_inclusion_strategy" DOUBLE,
"n_4_3_3_national_broadband_strategy" DOUBLE,
"n_4_3_4_funding_for_broadband_buildout" DOUBLE,
"n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE,
"n_4_3_6_national_digital_identification_system" BIGINT,
"n_4_3_7_government_efforts_to_promote_5g" DOUBLE
);
CREATE TABLE internet_inclusivity_index_score_equal_domain_weights__95e58f1d (
"country" VARCHAR,
"edition" VARCHAR,
"overall" DOUBLE,
"n_1_availability" DOUBLE,
"n_1_1_usage" DOUBLE,
"n_1_1_1_internet_users" DOUBLE,
"n_1_1_2_fixed_line_broadband_subscribers" DOUBLE,
"n_1_1_3_mobile_subscribers" DOUBLE,
"n_1_1_4_gender_gap_in_internet_access" DOUBLE,
"n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE,
"n_1_2_quality" DOUBLE,
"n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE,
"n_1_2_2_average_fixed_broadband_download_speed" DOUBLE,
"n_1_2_3_average_fixed_broadband_latency" DOUBLE,
"n_1_2_4_average_mobile_upload_speed" DOUBLE,
"n_1_2_5_average_mobile_download_speed" DOUBLE,
"n_1_2_6_average_mobile_latency" DOUBLE,
"n_1_2_7_bandwidth_capacity" DOUBLE,
"n_1_3_infrastructure" DOUBLE,
"n_1_3_1_network_coverage_min_2g" DOUBLE,
"n_1_3_2_network_coverage_min_3g" DOUBLE,
"n_1_3_3_network_coverage_min_4g" DOUBLE,
"n_1_3_4_5g_deployment" DOUBLE,
"n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_7_unlicensed_spectrum_policy" DOUBLE,
"n_1_3_8_internet_exchange_points" DOUBLE,
"n_1_4_electricity" DOUBLE,
"n_1_4_1_urban_electricity_access" DOUBLE,
"n_1_4_2_rural_electricity_access" DOUBLE,
"n_2_affordability" DOUBLE,
"n_2_1_price" DOUBLE,
"n_2_1_1_smartphone_cost_handset" DOUBLE,
"n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE,
"n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE,
"n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE,
"n_2_2_competitive_environment" DOUBLE,
"n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE,
"n_2_2_2_wireless_operators_market_share" BIGINT,
"n_2_2_3_broadband_operators_market_share" BIGINT,
"n_3_relevance" DOUBLE,
"n_3_1_local_content" DOUBLE,
"n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE,
"n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE,
"n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE,
"n_3_2_relevant_content" DOUBLE,
"n_3_2_1_e_finance_content" DOUBLE,
"n_3_2_2_value_of_e_finance" DOUBLE,
"n_3_2_3_e_health_content" DOUBLE,
"n_3_2_4_value_of_e_health" DOUBLE,
"n_3_2_5_e_entertainment_usage" DOUBLE,
"n_3_2_6_e_commerce_content" DOUBLE,
"n_3_2_7_value_of_e_commerce" DOUBLE,
"n_3_2_8_open_data_policies" DOUBLE,
"n_4_readiness" DOUBLE,
"n_4_1_literacy" DOUBLE,
"n_4_1_1_level_of_literacy" DOUBLE,
"n_4_1_2_educational_attainment" DOUBLE,
"n_4_1_3_support_for_digital_literacy" DOUBLE,
"n_4_1_4_level_of_web_accessibility" DOUBLE,
"n_4_2_trust_safety" DOUBLE,
"n_4_2_1_privacy_regulations" DOUBLE,
"n_4_2_2_trust_in_online_privacy" DOUBLE,
"n_4_2_3_trust_in_government_websites_and_apps" DOUBLE,
"n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE,
"n_4_2_5_trust_in_information_from_social_media" DOUBLE,
"n_4_2_6_e_commerce_safety" DOUBLE,
"n_4_3_policy" DOUBLE,
"n_4_3_1_national_female_e_inclusion_policies" DOUBLE,
"n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE,
"n_4_3_1_2_female_digital_skills_training_plan" DOUBLE,
"n_4_3_1_3_female_stem_education_plan" DOUBLE,
"n_4_3_2_government_e_inclusion_strategy" DOUBLE,
"n_4_3_3_national_broadband_strategy" DOUBLE,
"n_4_3_4_funding_for_broadband_buildout" DOUBLE,
"n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE,
"n_4_3_6_national_digital_identification_system" BIGINT,
"n_4_3_7_government_efforts_to_promote_5g" DOUBLE
);
CREATE TABLE internet_inclusivity_index_score_equal_indicator_weigh_d7a33cd4 (
"country" VARCHAR,
"edition" VARCHAR,
"overall" DOUBLE,
"n_1_availability" DOUBLE,
"n_1_1_usage" DOUBLE,
"n_1_1_1_internet_users" DOUBLE,
"n_1_1_2_fixed_line_broadband_subscribers" DOUBLE,
"n_1_1_3_mobile_subscribers" DOUBLE,
"n_1_1_4_gender_gap_in_internet_access" DOUBLE,
"n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE,
"n_1_2_quality" DOUBLE,
"n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE,
"n_1_2_2_average_fixed_broadband_download_speed" DOUBLE,
"n_1_2_3_average_fixed_broadband_latency" DOUBLE,
"n_1_2_4_average_mobile_upload_speed" DOUBLE,
"n_1_2_5_average_mobile_download_speed" DOUBLE,
"n_1_2_6_average_mobile_latency" DOUBLE,
"n_1_2_7_bandwidth_capacity" DOUBLE,
"n_1_3_infrastructure" DOUBLE,
"n_1_3_1_network_coverage_min_2g" DOUBLE,
"n_1_3_2_network_coverage_min_3g" DOUBLE,
"n_1_3_3_network_coverage_min_4g" DOUBLE,
"n_1_3_4_5g_deployment" DOUBLE,
"n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE,
"n_1_3_7_unlicensed_spectrum_policy" DOUBLE,
"n_1_3_8_internet_exchange_points" DOUBLE,
"n_1_4_electricity" DOUBLE,
"n_1_4_1_urban_electricity_access" DOUBLE,
"n_1_4_2_rural_electricity_access" DOUBLE,
"n_2_affordability" DOUBLE,
"n_2_1_price" DOUBLE,
"n_2_1_1_smartphone_cost_handset" DOUBLE,
"n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE,
"n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE,
"n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE,
"n_2_2_competitive_environment" DOUBLE,
"n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE,
"n_2_2_2_wireless_operators_market_share" BIGINT,
"n_2_2_3_broadband_operators_market_share" BIGINT,
"n_3_relevance" DOUBLE,
"n_3_1_local_content" DOUBLE,
"n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE,
"n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE,
"n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE,
"n_3_2_relevant_content" DOUBLE,
"n_3_2_1_e_finance_content" DOUBLE,
"n_3_2_2_value_of_e_finance" DOUBLE,
"n_3_2_3_e_health_content" DOUBLE,
"n_3_2_4_value_of_e_health" DOUBLE,
"n_3_2_5_e_entertainment_usage" DOUBLE,
"n_3_2_6_e_commerce_content" DOUBLE,
"n_3_2_7_value_of_e_commerce" DOUBLE,
"n_3_2_8_open_data_policies" DOUBLE,
"n_4_readiness" DOUBLE,
"n_4_1_literacy" DOUBLE,
"n_4_1_1_level_of_literacy" DOUBLE,
"n_4_1_2_educational_attainment" DOUBLE,
"n_4_1_3_support_for_digital_literacy" DOUBLE,
"n_4_1_4_level_of_web_accessibility" DOUBLE,
"n_4_2_trust_safety" DOUBLE,
"n_4_2_1_privacy_regulations" DOUBLE,
"n_4_2_2_trust_in_online_privacy" DOUBLE,
"n_4_2_3_trust_in_government_websites_and_apps" DOUBLE,
"n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE,
"n_4_2_5_trust_in_information_from_social_media" DOUBLE,
"n_4_2_6_e_commerce_safety" DOUBLE,
"n_4_3_policy" DOUBLE,
"n_4_3_1_national_female_e_inclusion_policies" DOUBLE,
"n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE,
"n_4_3_1_2_female_digital_skills_training_plan" DOUBLE,
"n_4_3_1_3_female_stem_education_plan" DOUBLE,
"n_4_3_2_government_e_inclusion_strategy" DOUBLE,
"n_4_3_3_national_broadband_strategy" DOUBLE,
"n_4_3_4_funding_for_broadband_buildout" DOUBLE,
"n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE,
"n_4_3_6_national_digital_identification_system" BIGINT,
"n_4_3_7_government_efforts_to_promote_5g" DOUBLE
);
Anyone who has the link will be able to view this.