Baselight

Broadband Internet Coverage By Speed

Eurostat code: isoc_cbs ยท (2013 - 2023)

@eurostat.isoc_cbs

Broadband Internet Coverage By Speed - Unpivoted
@eurostat.isoc_cbs.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 9.57 KB
  • 1176 rows
  • 7 columns
freq

Freq

unit

Unit

inet_spd

Inet Spd

terrtypo

Terrtypo

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalAustria201343.2
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalBelgium201391.9
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalBulgaria20132
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalSwitzerland201397.4
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalCyprus201343.7
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalCzechia201338.6
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalGermany201356.4
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalDenmark201346.8
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalEstonia201351.5
AnnualPercentage of householdsMore than 100 megabits per second (Mbps)TotalGreece20130.4

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "inet_spd" VARCHAR,
  "terrtypo" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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