Name: Internet Inclusivity Index 2017 - 2021
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Internet Inclusivity Index 2017 - 2021

Context

The Inclusive Internet Index, commissioned by Facebook and developed by The Economist Intelligence Unit, seeks to measure the extent to which the Internet is not only accessible and affordable, but also relevant to all, allowing usage that enables positive social and economic outcomes at the individual and group level.

Content

Now in its fifth year, beginning 2017 - 2021, the index assesses the performance of 120 countries in four categories of inclusion: Accessibility, Affordability, Relevance and Readiness. Each category incorporates key indicators of Internet inclusion, including quantitative measures such as network coverage and pricing, and qualitative measures such as the presence of e-inclusion policies and the availability of local-language content.

Acknowledgements

The greatest appreciation goes to The Economist Intelligence Unit for making this data set available to the general public for free and to Facebook for commissioning it.

Tables

Internet Inclusivity Index Data Table

@kaggle.kwamsahortor_internet_inclusivity_index_2017_2021.internet_inclusivity_index_data_table

193.58 kB
600 rows
86 columns

CREATE TABLE internet_inclusivity_index_data_table (
  "country" VARCHAR,
  "edition" VARCHAR,
  "n_1_1_1_internet_users" DOUBLE  -- 1.1.1) Internet Users,
  "n_1_1_2_fixed_line_broadband_subscribers" DOUBLE  -- 1.1.2) Fixed-line Broadband Subscribers,
  "n_1_1_3_mobile_subscribers" DOUBLE  -- 1.1.3) Mobile Subscribers,
  "n_1_1_4_gender_gap_in_internet_access" DOUBLE  -- 1.1.4) Gender Gap In Internet Access,
  "n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE  -- 1.1.5) Gender Gap In Mobile Phone Access,
  "n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE  -- 1.2.1) Average Fixed Broadband Upload Speed,
  "n_1_2_2_average_fixed_broadband_download_speed" DOUBLE  -- 1.2.2) Average Fixed Broadband Download Speed,
  "n_1_2_3_average_fixed_broadband_latency" DOUBLE  -- 1.2.3) Average Fixed Broadband Latency,
  "n_1_2_4_average_mobile_upload_speed" DOUBLE  -- 1.2.4) Average Mobile Upload Speed,
  "n_1_2_5_average_mobile_download_speed" DOUBLE  -- 1.2.5) Average Mobile Download Speed,
  "n_1_2_6_average_mobile_latency" DOUBLE  -- 1.2.6) Average Mobile Latency,
  "n_1_2_7_bandwidth_capacity" DOUBLE  -- 1.2.7) Bandwidth Capacity,
  "n_1_3_1_network_coverage_min_2g" DOUBLE  -- 1.3.1) Network Coverage (min. 2G),
  "n_1_3_2_network_coverage_min_3g" DOUBLE  -- 1.3.2) Network Coverage (min. 3G),
  "n_1_3_3_network_coverage_min_4g" DOUBLE  -- 1.3.3) Network Coverage (min. 4G),
  "n_1_3_4_5g_deployment" DOUBLE  -- 1.3.4) 5G Deployment,
  "n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.5) Government Initiatives To Make Wi-Fi Available,
  "n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.6) Private Sector Initiatives To Make Wi-Fi Available,
  "n_1_3_7_unlicensed_spectrum_policy" DOUBLE  -- 1.3.7) Unlicensed Spectrum Policy,
  "n_1_3_8_internet_exchange_points" DOUBLE  -- 1.3.8) Internet Exchange Points,
  "n_1_4_1_urban_electricity_access" DOUBLE  -- 1.4.1) Urban Electricity Access,
  "n_1_4_2_rural_electricity_access" DOUBLE  -- 1.4.2) Rural Electricity Access,
  "n_2_1_1_smartphone_cost_handset" DOUBLE  -- 2.1.1) Smartphone Cost (handset),
  "n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE  -- 2.1.2) Mobile Phone Cost (prepaid Tariff),
  "n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE  -- 2.1.3) Mobile Phone Cost (postpaid Tariff),
  "n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE  -- 2.1.4) Fixed-line Monthly Broadband Cost,
  "n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE  -- 2.2.1) Average Revenue Per User (ARPU, Annualized),
  "n_2_2_2_wireless_operators_market_share" BIGINT  -- 2.2.2) Wireless Operators\u0027 Market Share,
  "n_2_2_3_broadband_operators_market_share" BIGINT  -- 2.2.3) Broadband Operators\u0027 Market Share,
  "n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE  -- 3.1.1) Availability Of Local News In Local Languages,
  "n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE  -- 3.1.2) Concentration Of Websites Using Country-level Domains,
  "n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE  -- 3.1.3) Availability Of E-Government Services In The Local Language,
  "n_3_2_1_e_finance_content" DOUBLE  -- 3.2.1) E-Finance Content,
  "n_3_2_2_value_of_e_finance" DOUBLE  -- 3.2.2) Value Of E-finance,
  "n_3_2_3_e_health_content" DOUBLE  -- 3.2.3) E-Health Content,
  "n_3_2_4_value_of_e_health" DOUBLE  -- 3.2.4) Value Of E-health,
  "n_3_2_5_e_entertainment_usage" DOUBLE  -- 3.2.5) E-Entertainment Usage,
  "n_3_2_6_e_commerce_content" DOUBLE  -- 3.2.6) E-Commerce Content,
  "n_3_2_7_value_of_e_commerce" DOUBLE  -- 3.2.7) Value Of E-Commerce,
  "n_3_2_8_open_data_policies" DOUBLE  -- 3.2.8) Open Data Policies,
  "n_4_1_1_level_of_literacy" DOUBLE  -- 4.1.1) Level Of Literacy,
  "n_4_1_2_educational_attainment" DOUBLE  -- 4.1.2) Educational Attainment,
  "n_4_1_3_support_for_digital_literacy" DOUBLE  -- 4.1.3) Support For Digital Literacy,
  "n_4_1_4_level_of_web_accessibility" DOUBLE  -- 4.1.4) Level Of Web Accessibility,
  "n_4_2_1_privacy_regulations" DOUBLE  -- 4.2.1) Privacy Regulations,
  "n_4_2_2_trust_in_online_privacy" DOUBLE  -- 4.2.2) Trust In Online Privacy,
  "n_4_2_3_trust_in_government_websites_and_apps" DOUBLE  -- 4.2.3) Trust In Government Websites And Apps,
  "n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE  -- 4.2.4) Trust In Non-government Websites And Apps,
  "n_4_2_5_trust_in_information_from_social_media" DOUBLE  -- 4.2.5) Trust In Information From Social Media,
  "n_4_2_6_e_commerce_safety" DOUBLE  -- 4.2.6) E-Commerce Safety,
  "n_4_3_1_national_female_e_inclusion_policies" DOUBLE  -- 4.3.1) National Female E-inclusion Policies,
  "n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE  -- 4.3.1.1) Comprehensive Female E-inclusion Plan,
  "n_4_3_1_2_female_digital_skills_training_plan" DOUBLE  -- 4.3.1.2) Female Digital Skills Training Plan,
  "n_4_3_1_3_female_stem_education_plan" DOUBLE  -- 4.3.1.3) Female STEM Education Plan,
  "n_4_3_2_government_e_inclusion_strategy" DOUBLE  -- 4.3.2) Government E-inclusion Strategy,
  "n_4_3_3_national_broadband_strategy" DOUBLE  -- 4.3.3) National Broadband Strategy,
  "n_4_3_4_funding_for_broadband_buildout" DOUBLE  -- 4.3.4) Funding For Broadband Buildout,
  "n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE  -- 4.3.5) Technology-neutrality Policy For Spectrum Use,
  "n_4_3_6_national_digital_identification_system" BIGINT  -- 4.3.6) National Digital Identification System,
  "n_4_3_7_government_efforts_to_promote_5g" DOUBLE  -- 4.3.7) Government Efforts To Promote 5G,
  "bg1_nominal_gdp" DOUBLE  -- BG1) Nominal GDP,
  "bg2_population" DOUBLE  -- BG2) Population,
  "bg3_urban_population" DOUBLE  -- BG3) Urban Population,
  "bg4_gni_per_capita" BIGINT  -- BG4) GNI Per Capita,
  "bg5_gini_coefficient" DOUBLE  -- BG5) GINI Coefficient,
  "bg6_population_under_the_poverty_line" DOUBLE  -- BG6) Population Under The Poverty Line,
  "bg7_total_electricity_access" DOUBLE  -- BG7) Total Electricity Access,
  "bg8_cable_landing_stations" DOUBLE  -- BG8) Cable Landing Stations,
  "bg9_percentage_of_schools_with_internet_access" DOUBLE  -- BG9) Percentage Of Schools With Internet Access,
  "bg10_global_peace_index" DOUBLE  -- BG10) Global Peace Index,
  "bg11_democracy_index" DOUBLE  -- BG11) Democracy Index,
  "bg12_corruption_perceptions_index" BIGINT  -- BG12) Corruption Perceptions Index,
  "bg13_eiu_business_environment_rankings" DOUBLE  -- BG13) EIU Business Environment Rankings,
  "bg14_un_e_government_development_index" DOUBLE  -- BG14) UN E-Government Development Index,
  "bg15_internet_users_population" DOUBLE  -- BG15) Internet Users (population),
  "bg16_offline_population" DOUBLE  -- BG16) Offline Population,
  "bg17_internet_access_gender_gap" DOUBLE  -- BG17) Internet Access Gender Gap,
  "bg18_mobile_phone_access_gender_gap" DOUBLE  -- BG18) Mobile Phone Access Gender Gap,
  "bg19_internet_users_percent_of_population" DOUBLE  -- BG19) Internet Users (percent Of Population),
  "bg20_male_internet_users" DOUBLE  -- BG20) Male Internet Users,
  "bg21_female_internet_users" DOUBLE  -- BG21) Female Internet Users,
  "bg22_male_mobile_phone_subscribers" DOUBLE  -- BG22) Male Mobile Phone Subscribers,
  "bg23_female_mobile_phone_subscribers" DOUBLE  -- BG23) Female Mobile Phone Subscribers,
  "bg24_total_fixed_line_broadband_subscribers" BIGINT  -- BG24) Total Fixed Line Broadband Subscribers
);

Internet Inclusivity Index Score Default Weight Profile

@kaggle.kwamsahortor_internet_inclusivity_index_2017_2021.internet_inclusivity_index_score_default_weight_profile

151.35 kB
600 rows
78 columns

CREATE TABLE internet_inclusivity_index_score_default_weight_profile (
  "country" VARCHAR,
  "edition" VARCHAR,
  "overall" DOUBLE,
  "n_1_availability" DOUBLE  -- 1) AVAILABILITY,
  "n_1_1_usage" DOUBLE  -- 1.1) Usage,
  "n_1_1_1_internet_users" DOUBLE  -- 1.1.1) Internet Users,
  "n_1_1_2_fixed_line_broadband_subscribers" DOUBLE  -- 1.1.2) Fixed-line Broadband Subscribers,
  "n_1_1_3_mobile_subscribers" DOUBLE  -- 1.1.3) Mobile Subscribers,
  "n_1_1_4_gender_gap_in_internet_access" DOUBLE  -- 1.1.4) Gender Gap In Internet Access,
  "n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE  -- 1.1.5) Gender Gap In Mobile Phone Access,
  "n_1_2_quality" DOUBLE  -- 1.2) Quality,
  "n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE  -- 1.2.1) Average Fixed Broadband Upload Speed,
  "n_1_2_2_average_fixed_broadband_download_speed" DOUBLE  -- 1.2.2) Average Fixed Broadband Download Speed,
  "n_1_2_3_average_fixed_broadband_latency" DOUBLE  -- 1.2.3) Average Fixed Broadband Latency,
  "n_1_2_4_average_mobile_upload_speed" DOUBLE  -- 1.2.4) Average Mobile Upload Speed,
  "n_1_2_5_average_mobile_download_speed" DOUBLE  -- 1.2.5) Average Mobile Download Speed,
  "n_1_2_6_average_mobile_latency" DOUBLE  -- 1.2.6) Average Mobile Latency,
  "n_1_2_7_bandwidth_capacity" DOUBLE  -- 1.2.7) Bandwidth Capacity,
  "n_1_3_infrastructure" DOUBLE  -- 1.3) Infrastructure,
  "n_1_3_1_network_coverage_min_2g" DOUBLE  -- 1.3.1) Network Coverage (min. 2G),
  "n_1_3_2_network_coverage_min_3g" DOUBLE  -- 1.3.2) Network Coverage (min. 3G),
  "n_1_3_3_network_coverage_min_4g" DOUBLE  -- 1.3.3) Network Coverage (min. 4G),
  "n_1_3_4_5g_deployment" DOUBLE  -- 1.3.4) 5G Deployment,
  "n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.5) Government Initiatives To Make Wi-Fi Available,
  "n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.6) Private Sector Initiatives To Make Wi-Fi Available,
  "n_1_3_7_unlicensed_spectrum_policy" DOUBLE  -- 1.3.7) Unlicensed Spectrum Policy,
  "n_1_3_8_internet_exchange_points" DOUBLE  -- 1.3.8) Internet Exchange Points,
  "n_1_4_electricity" DOUBLE  -- 1.4) Electricity,
  "n_1_4_1_urban_electricity_access" DOUBLE  -- 1.4.1) Urban Electricity Access,
  "n_1_4_2_rural_electricity_access" DOUBLE  -- 1.4.2) Rural Electricity Access,
  "n_2_affordability" DOUBLE  -- 2) AFFORDABILITY,
  "n_2_1_price" DOUBLE  -- 2.1) Price,
  "n_2_1_1_smartphone_cost_handset" DOUBLE  -- 2.1.1) Smartphone Cost (handset),
  "n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE  -- 2.1.2) Mobile Phone Cost (prepaid Tariff),
  "n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE  -- 2.1.3) Mobile Phone Cost (postpaid Tariff),
  "n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE  -- 2.1.4) Fixed-line Monthly Broadband Cost,
  "n_2_2_competitive_environment" DOUBLE  -- 2.2) Competitive Environment,
  "n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE  -- 2.2.1) Average Revenue Per User (ARPU, Annualized),
  "n_2_2_2_wireless_operators_market_share" BIGINT  -- 2.2.2) Wireless Operators\u0027 Market Share,
  "n_2_2_3_broadband_operators_market_share" BIGINT  -- 2.2.3) Broadband Operators\u0027 Market Share,
  "n_3_relevance" DOUBLE  -- 3) RELEVANCE,
  "n_3_1_local_content" DOUBLE  -- 3.1) Local Content,
  "n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE  -- 3.1.1) Availability Of Local News In Local Languages,
  "n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE  -- 3.1.2) Concentration Of Websites Using Country-level Domains,
  "n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE  -- 3.1.3) Availability Of E-Government Services In The Local Language,
  "n_3_2_relevant_content" DOUBLE  -- 3.2) Relevant Content,
  "n_3_2_1_e_finance_content" DOUBLE  -- 3.2.1) E-Finance Content,
  "n_3_2_2_value_of_e_finance" DOUBLE  -- 3.2.2) Value Of E-finance,
  "n_3_2_3_e_health_content" DOUBLE  -- 3.2.3) E-Health Content,
  "n_3_2_4_value_of_e_health" DOUBLE  -- 3.2.4) Value Of E-health,
  "n_3_2_5_e_entertainment_usage" DOUBLE  -- 3.2.5) E-Entertainment Usage,
  "n_3_2_6_e_commerce_content" DOUBLE  -- 3.2.6) E-Commerce Content,
  "n_3_2_7_value_of_e_commerce" DOUBLE  -- 3.2.7) Value Of E-Commerce,
  "n_3_2_8_open_data_policies" DOUBLE  -- 3.2.8) Open Data Policies,
  "n_4_readiness" DOUBLE  -- 4) READINESS,
  "n_4_1_literacy" DOUBLE  -- 4.1) Literacy,
  "n_4_1_1_level_of_literacy" DOUBLE  -- 4.1.1) Level Of Literacy,
  "n_4_1_2_educational_attainment" DOUBLE  -- 4.1.2) Educational Attainment,
  "n_4_1_3_support_for_digital_literacy" DOUBLE  -- 4.1.3) Support For Digital Literacy,
  "n_4_1_4_level_of_web_accessibility" DOUBLE  -- 4.1.4) Level Of Web Accessibility,
  "n_4_2_trust_safety" DOUBLE  -- 4.2) Trust \u0026 Safety,
  "n_4_2_1_privacy_regulations" DOUBLE  -- 4.2.1) Privacy Regulations,
  "n_4_2_2_trust_in_online_privacy" DOUBLE  -- 4.2.2) Trust In Online Privacy,
  "n_4_2_3_trust_in_government_websites_and_apps" DOUBLE  -- 4.2.3) Trust In Government Websites And Apps,
  "n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE  -- 4.2.4) Trust In Non-government Websites And Apps,
  "n_4_2_5_trust_in_information_from_social_media" DOUBLE  -- 4.2.5) Trust In Information From Social Media,
  "n_4_2_6_e_commerce_safety" DOUBLE  -- 4.2.6) E-Commerce Safety,
  "n_4_3_policy" DOUBLE  -- 4.3) Policy,
  "n_4_3_1_national_female_e_inclusion_policies" DOUBLE  -- 4.3.1) National Female E-inclusion Policies,
  "n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE  -- 4.3.1.1) Comprehensive Female E-inclusion Plan,
  "n_4_3_1_2_female_digital_skills_training_plan" DOUBLE  -- 4.3.1.2) Female Digital Skills Training Plan,
  "n_4_3_1_3_female_stem_education_plan" DOUBLE  -- 4.3.1.3) Female STEM Education Plan,
  "n_4_3_2_government_e_inclusion_strategy" DOUBLE  -- 4.3.2) Government E-inclusion Strategy,
  "n_4_3_3_national_broadband_strategy" DOUBLE  -- 4.3.3) National Broadband Strategy,
  "n_4_3_4_funding_for_broadband_buildout" DOUBLE  -- 4.3.4) Funding For Broadband Buildout,
  "n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE  -- 4.3.5) Technology-neutrality Policy For Spectrum Use,
  "n_4_3_6_national_digital_identification_system" BIGINT  -- 4.3.6) National Digital Identification System,
  "n_4_3_7_government_efforts_to_promote_5g" DOUBLE  -- 4.3.7) Government Efforts To Promote 5G
);

Internet Inclusivity Index Score Equal Domain Weights, 95e58f1d

@kaggle.kwamsahortor_internet_inclusivity_index_2017_2021.internet_inclusivity_index_score_equal_domain_weights__95e58f1d

151.22 kB
600 rows
78 columns

CREATE TABLE internet_inclusivity_index_score_equal_domain_weights__95e58f1d (
  "country" VARCHAR,
  "edition" VARCHAR,
  "overall" DOUBLE,
  "n_1_availability" DOUBLE  -- 1) AVAILABILITY,
  "n_1_1_usage" DOUBLE  -- 1.1) Usage,
  "n_1_1_1_internet_users" DOUBLE  -- 1.1.1) Internet Users,
  "n_1_1_2_fixed_line_broadband_subscribers" DOUBLE  -- 1.1.2) Fixed-line Broadband Subscribers,
  "n_1_1_3_mobile_subscribers" DOUBLE  -- 1.1.3) Mobile Subscribers,
  "n_1_1_4_gender_gap_in_internet_access" DOUBLE  -- 1.1.4) Gender Gap In Internet Access,
  "n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE  -- 1.1.5) Gender Gap In Mobile Phone Access,
  "n_1_2_quality" DOUBLE  -- 1.2) Quality,
  "n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE  -- 1.2.1) Average Fixed Broadband Upload Speed,
  "n_1_2_2_average_fixed_broadband_download_speed" DOUBLE  -- 1.2.2) Average Fixed Broadband Download Speed,
  "n_1_2_3_average_fixed_broadband_latency" DOUBLE  -- 1.2.3) Average Fixed Broadband Latency,
  "n_1_2_4_average_mobile_upload_speed" DOUBLE  -- 1.2.4) Average Mobile Upload Speed,
  "n_1_2_5_average_mobile_download_speed" DOUBLE  -- 1.2.5) Average Mobile Download Speed,
  "n_1_2_6_average_mobile_latency" DOUBLE  -- 1.2.6) Average Mobile Latency,
  "n_1_2_7_bandwidth_capacity" DOUBLE  -- 1.2.7) Bandwidth Capacity,
  "n_1_3_infrastructure" DOUBLE  -- 1.3) Infrastructure,
  "n_1_3_1_network_coverage_min_2g" DOUBLE  -- 1.3.1) Network Coverage (min. 2G),
  "n_1_3_2_network_coverage_min_3g" DOUBLE  -- 1.3.2) Network Coverage (min. 3G),
  "n_1_3_3_network_coverage_min_4g" DOUBLE  -- 1.3.3) Network Coverage (min. 4G),
  "n_1_3_4_5g_deployment" DOUBLE  -- 1.3.4) 5G Deployment,
  "n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.5) Government Initiatives To Make Wi-Fi Available,
  "n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.6) Private Sector Initiatives To Make Wi-Fi Available,
  "n_1_3_7_unlicensed_spectrum_policy" DOUBLE  -- 1.3.7) Unlicensed Spectrum Policy,
  "n_1_3_8_internet_exchange_points" DOUBLE  -- 1.3.8) Internet Exchange Points,
  "n_1_4_electricity" DOUBLE  -- 1.4) Electricity,
  "n_1_4_1_urban_electricity_access" DOUBLE  -- 1.4.1) Urban Electricity Access,
  "n_1_4_2_rural_electricity_access" DOUBLE  -- 1.4.2) Rural Electricity Access,
  "n_2_affordability" DOUBLE  -- 2) AFFORDABILITY,
  "n_2_1_price" DOUBLE  -- 2.1) Price,
  "n_2_1_1_smartphone_cost_handset" DOUBLE  -- 2.1.1) Smartphone Cost (handset),
  "n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE  -- 2.1.2) Mobile Phone Cost (prepaid Tariff),
  "n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE  -- 2.1.3) Mobile Phone Cost (postpaid Tariff),
  "n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE  -- 2.1.4) Fixed-line Monthly Broadband Cost,
  "n_2_2_competitive_environment" DOUBLE  -- 2.2) Competitive Environment,
  "n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE  -- 2.2.1) Average Revenue Per User (ARPU, Annualized),
  "n_2_2_2_wireless_operators_market_share" BIGINT  -- 2.2.2) Wireless Operators\u0027 Market Share,
  "n_2_2_3_broadband_operators_market_share" BIGINT  -- 2.2.3) Broadband Operators\u0027 Market Share,
  "n_3_relevance" DOUBLE  -- 3) RELEVANCE,
  "n_3_1_local_content" DOUBLE  -- 3.1) Local Content,
  "n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE  -- 3.1.1) Availability Of Local News In Local Languages,
  "n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE  -- 3.1.2) Concentration Of Websites Using Country-level Domains,
  "n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE  -- 3.1.3) Availability Of E-Government Services In The Local Language,
  "n_3_2_relevant_content" DOUBLE  -- 3.2) Relevant Content,
  "n_3_2_1_e_finance_content" DOUBLE  -- 3.2.1) E-Finance Content,
  "n_3_2_2_value_of_e_finance" DOUBLE  -- 3.2.2) Value Of E-finance,
  "n_3_2_3_e_health_content" DOUBLE  -- 3.2.3) E-Health Content,
  "n_3_2_4_value_of_e_health" DOUBLE  -- 3.2.4) Value Of E-health,
  "n_3_2_5_e_entertainment_usage" DOUBLE  -- 3.2.5) E-Entertainment Usage,
  "n_3_2_6_e_commerce_content" DOUBLE  -- 3.2.6) E-Commerce Content,
  "n_3_2_7_value_of_e_commerce" DOUBLE  -- 3.2.7) Value Of E-Commerce,
  "n_3_2_8_open_data_policies" DOUBLE  -- 3.2.8) Open Data Policies,
  "n_4_readiness" DOUBLE  -- 4) READINESS,
  "n_4_1_literacy" DOUBLE  -- 4.1) Literacy,
  "n_4_1_1_level_of_literacy" DOUBLE  -- 4.1.1) Level Of Literacy,
  "n_4_1_2_educational_attainment" DOUBLE  -- 4.1.2) Educational Attainment,
  "n_4_1_3_support_for_digital_literacy" DOUBLE  -- 4.1.3) Support For Digital Literacy,
  "n_4_1_4_level_of_web_accessibility" DOUBLE  -- 4.1.4) Level Of Web Accessibility,
  "n_4_2_trust_safety" DOUBLE  -- 4.2) Trust \u0026 Safety,
  "n_4_2_1_privacy_regulations" DOUBLE  -- 4.2.1) Privacy Regulations,
  "n_4_2_2_trust_in_online_privacy" DOUBLE  -- 4.2.2) Trust In Online Privacy,
  "n_4_2_3_trust_in_government_websites_and_apps" DOUBLE  -- 4.2.3) Trust In Government Websites And Apps,
  "n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE  -- 4.2.4) Trust In Non-government Websites And Apps,
  "n_4_2_5_trust_in_information_from_social_media" DOUBLE  -- 4.2.5) Trust In Information From Social Media,
  "n_4_2_6_e_commerce_safety" DOUBLE  -- 4.2.6) E-Commerce Safety,
  "n_4_3_policy" DOUBLE  -- 4.3) Policy,
  "n_4_3_1_national_female_e_inclusion_policies" DOUBLE  -- 4.3.1) National Female E-inclusion Policies,
  "n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE  -- 4.3.1.1) Comprehensive Female E-inclusion Plan,
  "n_4_3_1_2_female_digital_skills_training_plan" DOUBLE  -- 4.3.1.2) Female Digital Skills Training Plan,
  "n_4_3_1_3_female_stem_education_plan" DOUBLE  -- 4.3.1.3) Female STEM Education Plan,
  "n_4_3_2_government_e_inclusion_strategy" DOUBLE  -- 4.3.2) Government E-inclusion Strategy,
  "n_4_3_3_national_broadband_strategy" DOUBLE  -- 4.3.3) National Broadband Strategy,
  "n_4_3_4_funding_for_broadband_buildout" DOUBLE  -- 4.3.4) Funding For Broadband Buildout,
  "n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE  -- 4.3.5) Technology-neutrality Policy For Spectrum Use,
  "n_4_3_6_national_digital_identification_system" BIGINT  -- 4.3.6) National Digital Identification System,
  "n_4_3_7_government_efforts_to_promote_5g" DOUBLE  -- 4.3.7) Government Efforts To Promote 5G
);

Internet Inclusivity Index Score Equal Indicator Weigh D7a33cd4

@kaggle.kwamsahortor_internet_inclusivity_index_2017_2021.internet_inclusivity_index_score_equal_indicator_weigh_d7a33cd4

151.25 kB
600 rows
78 columns

CREATE TABLE internet_inclusivity_index_score_equal_indicator_weigh_d7a33cd4 (
  "country" VARCHAR,
  "edition" VARCHAR,
  "overall" DOUBLE,
  "n_1_availability" DOUBLE  -- 1) AVAILABILITY,
  "n_1_1_usage" DOUBLE  -- 1.1) Usage,
  "n_1_1_1_internet_users" DOUBLE  -- 1.1.1) Internet Users,
  "n_1_1_2_fixed_line_broadband_subscribers" DOUBLE  -- 1.1.2) Fixed-line Broadband Subscribers,
  "n_1_1_3_mobile_subscribers" DOUBLE  -- 1.1.3) Mobile Subscribers,
  "n_1_1_4_gender_gap_in_internet_access" DOUBLE  -- 1.1.4) Gender Gap In Internet Access,
  "n_1_1_5_gender_gap_in_mobile_phone_access" DOUBLE  -- 1.1.5) Gender Gap In Mobile Phone Access,
  "n_1_2_quality" DOUBLE  -- 1.2) Quality,
  "n_1_2_1_average_fixed_broadband_upload_speed" DOUBLE  -- 1.2.1) Average Fixed Broadband Upload Speed,
  "n_1_2_2_average_fixed_broadband_download_speed" DOUBLE  -- 1.2.2) Average Fixed Broadband Download Speed,
  "n_1_2_3_average_fixed_broadband_latency" DOUBLE  -- 1.2.3) Average Fixed Broadband Latency,
  "n_1_2_4_average_mobile_upload_speed" DOUBLE  -- 1.2.4) Average Mobile Upload Speed,
  "n_1_2_5_average_mobile_download_speed" DOUBLE  -- 1.2.5) Average Mobile Download Speed,
  "n_1_2_6_average_mobile_latency" DOUBLE  -- 1.2.6) Average Mobile Latency,
  "n_1_2_7_bandwidth_capacity" DOUBLE  -- 1.2.7) Bandwidth Capacity,
  "n_1_3_infrastructure" DOUBLE  -- 1.3) Infrastructure,
  "n_1_3_1_network_coverage_min_2g" DOUBLE  -- 1.3.1) Network Coverage (min. 2G),
  "n_1_3_2_network_coverage_min_3g" DOUBLE  -- 1.3.2) Network Coverage (min. 3G),
  "n_1_3_3_network_coverage_min_4g" DOUBLE  -- 1.3.3) Network Coverage (min. 4G),
  "n_1_3_4_5g_deployment" DOUBLE  -- 1.3.4) 5G Deployment,
  "n_1_3_5_government_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.5) Government Initiatives To Make Wi-Fi Available,
  "n_1_3_6_private_sector_initiatives_to_make_wi_fi_available" DOUBLE  -- 1.3.6) Private Sector Initiatives To Make Wi-Fi Available,
  "n_1_3_7_unlicensed_spectrum_policy" DOUBLE  -- 1.3.7) Unlicensed Spectrum Policy,
  "n_1_3_8_internet_exchange_points" DOUBLE  -- 1.3.8) Internet Exchange Points,
  "n_1_4_electricity" DOUBLE  -- 1.4) Electricity,
  "n_1_4_1_urban_electricity_access" DOUBLE  -- 1.4.1) Urban Electricity Access,
  "n_1_4_2_rural_electricity_access" DOUBLE  -- 1.4.2) Rural Electricity Access,
  "n_2_affordability" DOUBLE  -- 2) AFFORDABILITY,
  "n_2_1_price" DOUBLE  -- 2.1) Price,
  "n_2_1_1_smartphone_cost_handset" DOUBLE  -- 2.1.1) Smartphone Cost (handset),
  "n_2_1_2_mobile_phone_cost_prepaid_tariff" DOUBLE  -- 2.1.2) Mobile Phone Cost (prepaid Tariff),
  "n_2_1_3_mobile_phone_cost_postpaid_tariff" DOUBLE  -- 2.1.3) Mobile Phone Cost (postpaid Tariff),
  "n_2_1_4_fixed_line_monthly_broadband_cost" DOUBLE  -- 2.1.4) Fixed-line Monthly Broadband Cost,
  "n_2_2_competitive_environment" DOUBLE  -- 2.2) Competitive Environment,
  "n_2_2_1_average_revenue_per_user_arpu_annualized" DOUBLE  -- 2.2.1) Average Revenue Per User (ARPU, Annualized),
  "n_2_2_2_wireless_operators_market_share" BIGINT  -- 2.2.2) Wireless Operators\u0027 Market Share,
  "n_2_2_3_broadband_operators_market_share" BIGINT  -- 2.2.3) Broadband Operators\u0027 Market Share,
  "n_3_relevance" DOUBLE  -- 3) RELEVANCE,
  "n_3_1_local_content" DOUBLE  -- 3.1) Local Content,
  "n_3_1_1_availability_of_local_news_in_local_languages" DOUBLE  -- 3.1.1) Availability Of Local News In Local Languages,
  "n_3_1_2_concentration_of_websites_using_country_level_domains" DOUBLE  -- 3.1.2) Concentration Of Websites Using Country-level Domains,
  "n_3_1_3_availability_of_e_government_services_in_the_l_cf76312f" DOUBLE  -- 3.1.3) Availability Of E-Government Services In The Local Language,
  "n_3_2_relevant_content" DOUBLE  -- 3.2) Relevant Content,
  "n_3_2_1_e_finance_content" DOUBLE  -- 3.2.1) E-Finance Content,
  "n_3_2_2_value_of_e_finance" DOUBLE  -- 3.2.2) Value Of E-finance,
  "n_3_2_3_e_health_content" DOUBLE  -- 3.2.3) E-Health Content,
  "n_3_2_4_value_of_e_health" DOUBLE  -- 3.2.4) Value Of E-health,
  "n_3_2_5_e_entertainment_usage" DOUBLE  -- 3.2.5) E-Entertainment Usage,
  "n_3_2_6_e_commerce_content" DOUBLE  -- 3.2.6) E-Commerce Content,
  "n_3_2_7_value_of_e_commerce" DOUBLE  -- 3.2.7) Value Of E-Commerce,
  "n_3_2_8_open_data_policies" DOUBLE  -- 3.2.8) Open Data Policies,
  "n_4_readiness" DOUBLE  -- 4) READINESS,
  "n_4_1_literacy" DOUBLE  -- 4.1) Literacy,
  "n_4_1_1_level_of_literacy" DOUBLE  -- 4.1.1) Level Of Literacy,
  "n_4_1_2_educational_attainment" DOUBLE  -- 4.1.2) Educational Attainment,
  "n_4_1_3_support_for_digital_literacy" DOUBLE  -- 4.1.3) Support For Digital Literacy,
  "n_4_1_4_level_of_web_accessibility" DOUBLE  -- 4.1.4) Level Of Web Accessibility,
  "n_4_2_trust_safety" DOUBLE  -- 4.2) Trust \u0026 Safety,
  "n_4_2_1_privacy_regulations" DOUBLE  -- 4.2.1) Privacy Regulations,
  "n_4_2_2_trust_in_online_privacy" DOUBLE  -- 4.2.2) Trust In Online Privacy,
  "n_4_2_3_trust_in_government_websites_and_apps" DOUBLE  -- 4.2.3) Trust In Government Websites And Apps,
  "n_4_2_4_trust_in_non_government_websites_and_apps" DOUBLE  -- 4.2.4) Trust In Non-government Websites And Apps,
  "n_4_2_5_trust_in_information_from_social_media" DOUBLE  -- 4.2.5) Trust In Information From Social Media,
  "n_4_2_6_e_commerce_safety" DOUBLE  -- 4.2.6) E-Commerce Safety,
  "n_4_3_policy" DOUBLE  -- 4.3) Policy,
  "n_4_3_1_national_female_e_inclusion_policies" DOUBLE  -- 4.3.1) National Female E-inclusion Policies,
  "n_4_3_1_1_comprehensive_female_e_inclusion_plan" DOUBLE  -- 4.3.1.1) Comprehensive Female E-inclusion Plan,
  "n_4_3_1_2_female_digital_skills_training_plan" DOUBLE  -- 4.3.1.2) Female Digital Skills Training Plan,
  "n_4_3_1_3_female_stem_education_plan" DOUBLE  -- 4.3.1.3) Female STEM Education Plan,
  "n_4_3_2_government_e_inclusion_strategy" DOUBLE  -- 4.3.2) Government E-inclusion Strategy,
  "n_4_3_3_national_broadband_strategy" DOUBLE  -- 4.3.3) National Broadband Strategy,
  "n_4_3_4_funding_for_broadband_buildout" DOUBLE  -- 4.3.4) Funding For Broadband Buildout,
  "n_4_3_5_technology_neutrality_policy_for_spectrum_use" DOUBLE  -- 4.3.5) Technology-neutrality Policy For Spectrum Use,
  "n_4_3_6_national_digital_identification_system" BIGINT  -- 4.3.6) National Digital Identification System,
  "n_4_3_7_government_efforts_to_promote_5g" DOUBLE  -- 4.3.7) Government Efforts To Promote 5G
);