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

Eurostat code: isoc_ci_it_h · (2003 - 2021)

@eurostat.isoc_ci_it_h

Table List

2 tables(682.11 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.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.

233.04 KB
95945 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: other broadband	Percentage of households	Single person	Denmark	2003	0.37
Annual	Household internet connection type: other broadband	Percentage of households	Single person	Spain	2003	0.7
Annual	Household internet connection type: other broadband	Percentage of households	Single person	Finland	2003	0.66
Annual	Household internet connection type: other broadband	Percentage of households	Single person	Luxembourg	2003	1.17
Annual	Household internet connection type: other broadband	Percentage of households	Single person	Norway	2003	2.69
Annual	Household internet connection type: other broadband	Percentage of households	Single person with dependent children	Denmark	2003
Annual	Household internet connection type: other broadband	Percentage of households	Single person with dependent children	Finland	2003
Annual	Household internet connection type: other broadband	Percentage of households	Single person with dependent children	Luxembourg	2003
Annual	Household internet connection type: other broadband	Percentage of households	Single person with dependent children	Norway	2003
Annual	Household internet connection type: other broadband	Percentage of households	Two adults	Denmark	2003	0.11


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.