Consultation Of A Medical Doctor Per Inhabitant

Eurostat code: hlth_hc_phys2 · (1960 - 2022)

@eurostat.hlth_hc_phys2

Table List

2 tables(56.27 KB)

Consultation Of A Medical Doctor Per Inhabitant - Raw

Consultation Of A Medical Doctor Per Inhabitant - Unpivoted

Consultation Of A Medical Doctor Per Inhabitant - Unpivoted

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

7.76 KB
998 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number per inhabitant	Greece	1960	5.2
Annual	Number per inhabitant	Poland	1960	3.3
Annual	Number per inhabitant	Türkiye	1960	0.7
Annual	Number per inhabitant	Greece	1961	5.28
Annual	Number per inhabitant	Türkiye	1961	0.7
Annual	Number per inhabitant	Greece	1962	5.83
Annual	Number per inhabitant	Türkiye	1962	0.7
Annual	Number per inhabitant	Greece	1963	5.86
Annual	Number per inhabitant	Türkiye	1963	0.7
Annual	Number per inhabitant	Greece	1964	6.4


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

Share link

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