Consultation Of A Medical Doctor (in Private Practice Or As Outpatient) Per Inhabitant - Historical Data (1960-2013)

Eurostat code: hlth_hc_phys · (1960 - 2021)

@eurostat.hlth_hc_phys

Table List

2 tables(60.57 KB)

Consultation Of A Medical Doctor (in Private Practice Or As Outpatient) Per Inhabitant - Historical Data (1960-2013) - Raw

Consultation Of A Medical Doctor (in Private Practice Or As Outpatient) Per Inhabitant - Historical Data (1960-2013) - Unpivoted

Consultation Of A Medical Doctor (in Private Practice Or As Outpatient) Per Inhabitant - Historical Data (1960-2013) - Unpivoted

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

9.77 KB
1299 rows
6 columns

freq Freq	unit Unit	med_spec Med Spec	geo Geo	time_period Time Period	value Value
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Austria	1960	4.3
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Greece	1960	5.2
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Poland	1960	3.3
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Türkiye	1960	0.7
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Austria	1961	4.5
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Greece	1961	5.28
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Türkiye	1961	0.7
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Austria	1962	4.4
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Greece	1962	5.83
Annual	Number per inhabitant	Generalist and specialist medical practitioners	Türkiye	1962	0.7


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

Share link

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