Fixed Telephone Line And Mobile Phone Penetration Rate, ENP-East Countries

Eurostat code: enpe_isoc_penrt · (2005 - 2023)

@eurostat.enpe_isoc_penrt

Table List

2 tables(22.01 KB)

Fixed Telephone Line And Mobile Phone Penetration Rate, ENP-East Countries - Raw

Fixed Telephone Line And Mobile Phone Penetration Rate, ENP-East Countries - Unpivoted

Fixed Telephone Line And Mobile Phone Penetration Rate, ENP-East Countries - Unpivoted

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

5.75 KB
193 rows
6 columns

freq Freq	ict Ict	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Mobile phone	Per thousand inhabitants	Armenia	2005	211
Annual	Mobile phone	Per thousand inhabitants	Azerbaijan	2005	268
Annual	Mobile phone	Per thousand inhabitants	Belarus	2005	426
Annual	Mobile phone	Per thousand inhabitants	Georgia	2005	302
Annual	Mobile phone	Per thousand inhabitants	Moldova	2005	303
Annual	Mobile phone	Per thousand inhabitants	Ukraine	2005	642
Annual	Fixed telephone	Per thousand inhabitants	Armenia	2005	594
Annual	Fixed telephone	Per thousand inhabitants	Azerbaijan	2005	131
Annual	Fixed telephone	Per thousand inhabitants	Belarus	2005	354
Annual	Fixed telephone	Per thousand inhabitants	Georgia	2005	140


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

Share link

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