Name: Speedtest Data By Ookla
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Speedtest Data By Ookla

Context

Ookla is the global leader in network intelligence and connectivity insights. The company owns the world-renowned Speedtest platform which is the definitive way to test the speed and performance of your internet connection. Every day, over ten million unique tests are actively initiated by Ookla's users in the locations and at the times when their connectivity matters to them.

Since Speedtest's founding in 2006, an unparalleled total of more than 40 billion tests have been taken with the platform.

Content

The datasets provide global fixed broadband and mobile (cellular) network performance metrics in zoom level 16 web mercator tiles (approximately 610.8 meters by 610.8 meters at the equator). Download speed, upload speed, and latency are collected via the Speedtest by Ookla applications for Android and iOS and averaged for each tile. Measurements are filtered to results containing GPS-quality location accuracy.

Source

The performance datasets are available via AWS S3 at the s3://ookla-open-data bucket, where individual Parquet time series and compressed Shapefiles are organized by

• file format (shapefiles or parquet)
• service type (fixed or mobile)
• year (2020)
• quarter (for example, 1 corresponds to the Q1 period starting 2020-01-01)

Inspiration

• Have we entered the era of Super Fast Internet?
• How fixed broadband speeds compare to mobile broadband?
• Where in the world could someone find the best speeds?
• Does internet performance improve over time? Is this consistent among countries?

These are examples of interesting questions that could be answered by analyzing this dataset.

If you are interested, please have a look at the Tableau dashboard that I have created to help answer the above questions.
Tableau dashboard: https://public.tableau.com/app/profile/dimitris.angelides/viz/OoklaSpeedtestGlobalIndex/OoklaSpeedtestGlobalIndex

Tables

Fixed Year 2020 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2020_quarter_01

22.96 kB
234 rows
11 columns

CREATE TABLE fixed_year_2020_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2020 Quarter 02

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2020_quarter_02

23.04 kB
235 rows
11 columns

CREATE TABLE fixed_year_2020_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2020 Quarter 03

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2020_quarter_03

22.96 kB
234 rows
11 columns

CREATE TABLE fixed_year_2020_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2020 Quarter 04

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2020_quarter_04

22.94 kB
236 rows
11 columns

CREATE TABLE fixed_year_2020_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2021 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2021_quarter_01

22.99 kB
235 rows
11 columns

CREATE TABLE fixed_year_2021_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2021 Quarter 02

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2021_quarter_02

22.95 kB
236 rows
11 columns

CREATE TABLE fixed_year_2021_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2021 Quarter 03

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2021_quarter_03

23.02 kB
236 rows
11 columns

CREATE TABLE fixed_year_2021_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2021 Quarter 04

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2021_quarter_04

22.96 kB
236 rows
11 columns

CREATE TABLE fixed_year_2021_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2022 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2022_quarter_01

23.07 kB
238 rows
11 columns

CREATE TABLE fixed_year_2022_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2022 Quarter 02

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2022_quarter_02

23.11 kB
238 rows
11 columns

CREATE TABLE fixed_year_2022_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2022 Quarter 03

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2022_quarter_03

23.14 kB
239 rows
11 columns

CREATE TABLE fixed_year_2022_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2020 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2020_quarter_01

21.84 kB
224 rows
11 columns

CREATE TABLE mobile_year_2020_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2020 Quarter 02

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2020_quarter_02

21.86 kB
224 rows
11 columns

CREATE TABLE mobile_year_2020_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2020 Quarter 03

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2020_quarter_03

21.86 kB
224 rows
11 columns

CREATE TABLE mobile_year_2020_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2020 Quarter 04

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2020_quarter_04

21.97 kB
226 rows
11 columns

CREATE TABLE mobile_year_2020_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2021 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2021_quarter_01

21.86 kB
224 rows
11 columns

CREATE TABLE mobile_year_2021_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2021 Quarter 02

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2021_quarter_02

21.97 kB
226 rows
11 columns

CREATE TABLE mobile_year_2021_quarter_02 (
  "name" VARCHAR,
  "number_of_record" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2021 Quarter 03

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2021_quarter_03

21.89 kB
224 rows
11 columns

CREATE TABLE mobile_year_2021_quarter_03 (
  "name" VARCHAR,
  "number_of_record" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2021 Quarter 04

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2021_quarter_04

21.78 kB
224 rows
11 columns

CREATE TABLE mobile_year_2021_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2022 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2022_quarter_01

21.98 kB
225 rows
11 columns

CREATE TABLE mobile_year_2022_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2022 Quarter 02

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2022_quarter_02

22.5 kB
233 rows
11 columns

CREATE TABLE mobile_year_2022_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Mobile Year 2022 Quarter 03

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2022_quarter_03

22.46 kB
233 rows
11 columns

CREATE TABLE mobile_year_2022_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT  -- Avg. Avg U Kbps,
  "avg_avg_d_kbps" BIGINT  -- Avg. Avg D Kbps,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT  -- Avg. Pop2005,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);