Baselight

Speedtest Data By Ookla

Fixed and Mobile Broadband Tests - 2020 to 2022

@kaggle.dimitrisangelide_speedtest_data_by_ookla

Loading...
Loading...

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

Mobile Year 2020 Quarter 04

@kaggle.dimitrisangelide_speedtest_data_by_ookla.mobile_year_2020_quarter_04
  • 21.45 KB
  • 226 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2020_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 22.48 KB
  • 236 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2021_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 21.97 KB
  • 233 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2022_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.45 KB
  • 226 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2021_quarter_02 (
  "name" VARCHAR,
  "number_of_record" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 22.56 KB
  • 238 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2022_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Fixed Year 2020 Quarter 01

@kaggle.dimitrisangelide_speedtest_data_by_ookla.fixed_year_2020_quarter_01
  • 22.42 KB
  • 234 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2020_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 22.53 KB
  • 238 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2022_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.42 KB
  • 236 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2021_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.4 KB
  • 236 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2020_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 22.6 KB
  • 239 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2022_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.38 KB
  • 224 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2021_quarter_03 (
  "name" VARCHAR,
  "number_of_record" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.47 KB
  • 225 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2022_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 21.94 KB
  • 233 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2022_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.42 KB
  • 234 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2020_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.34 KB
  • 224 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2020_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.42 KB
  • 236 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2021_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.33 KB
  • 224 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2020_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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
  • 22.5 KB
  • 235 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2020_quarter_02 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.45 KB
  • 235 rows
  • 11 columns
Loading...

CREATE TABLE fixed_year_2021_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.34 KB
  • 224 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2020_quarter_03 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.35 KB
  • 224 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2021_quarter_01 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "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.27 KB
  • 224 rows
  • 11 columns
Loading...

CREATE TABLE mobile_year_2021_quarter_04 (
  "name" VARCHAR,
  "number_of_records" BIGINT,
  "devices" BIGINT,
  "tests" BIGINT,
  "avg_avg_u_kbps" BIGINT,
  "avg_avg_d_kbps" BIGINT,
  "avg_lat_ms" BIGINT,
  "avg_pop2005" BIGINT,
  "rank_upload" BIGINT,
  "rank_download" BIGINT,
  "rank_latency" BIGINT
);

Share link

Anyone who has the link will be able to view this.