Communication

Eurostat code: med_ps33 · (2005 - 2018)

@eurostat.med_ps33

Table List

2 tables(18.73 KB)

Communication - Unpivoted

@eurostat.med_ps33.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.64 KB
178 rows
5 columns

freq Freq	indic_md Indic Md	geo Geo	time_period Time Period	value Value
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Algeria	2005	78.1
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Egypt	2005	144
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Israel	2005	278
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Jordan	2005	112
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Morocco	2005	45
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Palestine*	2005	94
Annual	Number of main telephone lines per 1,000 inhabitants (per 1000 Inhab)	Tunisia	2005	124.5
Annual	Number of subscriptions to cellular mobile telephone services per 1,000 inhabitants (per 1000 Inhab)	Algeria	2005	415.2
Annual	Number of subscriptions to cellular mobile telephone services per 1,000 inhabitants (per 1000 Inhab)	Egypt	2005	191
Annual	Number of subscriptions to cellular mobile telephone services per 1,000 inhabitants (per 1000 Inhab)	Israel	2005	595


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

Share link

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