Executive Summary
From 2000 to 2022, average internet usage increased from about one in ten people globally to seven in ten. The global average exceeded 50% for the first time in 2016, thanks in part to a steep rise in internet use in East Asia. Africa remains the region with the lowest internet adoption rate, while the small and wealthy nations of the Middle East consistently score close to 100% adoption rates.
Of the top third most populous nations, the following nations are the five most internet-dependent:
- Saudi Arabia — 100%
- Malaysia — 97.4%
- South Korea — 97.2%
- United States — 97.1%
- United Kingdom — 95.3%
Other large nations of interest:
- China — 75.6%
- Russian Federation — 90.4%
- Japan — 84.9%
Freedom of the Internet
China holds the distinctive title as the world's most aggressive internet censor, consistently ranking as the least free country for information available via the internet, according to Freedom House's Freedom on the Net (FOTN) survey. Of the 71 nations surveyed in 2024, only ten received a rating of "Free".
SELECT *
FROM 'continents.csv'-- Explore the data in the table
SELECT *
FROM 'countries.csv'-- Explore the data in the table
SELECT *
FROM 'recent_usage_trend.csv'-- Explore the data in the table
SELECT *
FROM 'internet_usage_year.csv'-- Explore the data in the table
SELECT *
FROM 'fotn_2024.csv'-- Explore the data in the table
SELECT *
FROM 'population_2022.csv'top_ten_top_third identifies the top ten nations by internet adoption rate whose populations are in the top third globally. These nations also collectively represent approximately 8.5% of the world's population.
SELECT i.country_code AS Country_Code, country_name AS Country, region_group AS Region, pct_usage AS Adoption_Rate
FROM internet_usage_year i
JOIN countries c
ON i.country_code = c.country_code
JOIN continents n
ON i.country_code = n.country_code
JOIN population_2022 p
ON i.country_code = p.country_code
WHERE year = 2022 AND population_2022 >
(SELECT population_2022
FROM (
SELECT population_2022,
NTILE(3) OVER (ORDER BY population_2022 DESC) AS tile_number
FROM population_2022) AS population_rank
WHERE tile_number = 2
ORDER BY population_2022 DESC
LIMIT 1)
ORDER BY Adoption_Rate DESC
LIMIT 10WITH top_ten AS (
SELECT SUM(population_2022) AS top_ten_pop
FROM population_2022
WHERE country_code IN (
SELECT country_code
FROM top_ten_top_third)
)
SELECT (SELECT top_ten_pop FROM top_ten) / SUM(population_2022) AS t3t10_pop_pct
FROM population_2022
SELECT country_name AS Country, population_2022 AS Population, pct_usage AS Adoption_Rate, total_score AS Freedom_Score, edition AS Freedom_Rating
FROM countries c
JOIN population_2022 p
ON c.country_code = p.country_code
JOIN internet_usage_year i
ON c.country_code = i.country_code
JOIN fotn_2024 f
ON c.country_code = f.country_code
WHERE country_name IN ('China', 'Russian Federation')SELECT country_name, total_score, edition
FROM countries c
JOIN fotn_2024 f
ON c.country_code = f.country_code
ORDER BY total_score ASC