Baselight

Persons Who Cannot Afford A Telephone

Eurostat code: ilc_mddu01 ยท (2003 - 2021)

@eurostat.ilc_mddu01

Persons Who Cannot Afford A Telephone - Unpivoted
@eurostat.ilc_mddu01.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.

  • 44.82 KB
  • 31049 rows
  • 7 columns
freq

Freq

hhtyp

Hhtyp

incgrp

Incgrp

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualSingle personAbove 60% of median equivalised incomePercentageAustria20034.9
AnnualSingle personAbove 60% of median equivalised incomePercentageBelgium20031.8
AnnualSingle personAbove 60% of median equivalised incomePercentageDenmark2003
AnnualSingle personAbove 60% of median equivalised incomePercentageGreece20031.3
AnnualSingle personAbove 60% of median equivalised incomePercentageIreland20030.7
AnnualSingle personAbove 60% of median equivalised incomePercentageLuxembourg20030.4
AnnualSingle personAbove 60% of median equivalised incomePercentageNorway20030.1
AnnualSingle personBelow 60% of median equivalised incomePercentageAustria20038.3
AnnualSingle personBelow 60% of median equivalised incomePercentageBelgium20034.3
AnnualSingle personBelow 60% of median equivalised incomePercentageDenmark2003

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

Share link

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