Households - Type Of Connection To The Internet (2003-2021)

Eurostat code: isoc_ci_it_h$dv_513

@eurostat.isoc_ci_it_h_dv_513

Table List

2 tables(47.95 KB)

Households - Type Of Connection To The Internet (2003-2021) - Raw

Households - Type Of Connection To The Internet (2003-2021) - Unpivoted

Households - Type Of Connection To The Internet (2003-2021) - Unpivoted

@eurostat.isoc_ci_it_h_dv_513.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.

21.52 KB
2880 rows
7 columns

freq Freq	indic_is Indic Is	unit Unit	hhtyp Hhtyp	geo Geo	time_period Time Period	value Value
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Austria	2015	69.12
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Belgium	2015	74.66
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Bulgaria	2015	67.69
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Cyprus	2015	73.72
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Czechia	2015	82.59
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Germany	2015	84.39
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Denmark	2015	76.31
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Euro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)	2015	75.56
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Estonia	2015	80.17
Annual	Household internet connection type: fixed broadband	Percentage of households	Households located in cities	Greece	2015	73.45


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_is" VARCHAR,
  "unit" VARCHAR,
  "hhtyp" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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