Physicians By Medical Speciality - Historical Data (1985-2016)

Eurostat code: hlth_rs_spec · (1985 - 2021)

@eurostat.hlth_rs_spec

Table List

2 tables(329.49 KB)

Physicians By Medical Speciality - Historical Data (1985-2016) - Raw

Physicians By Medical Speciality - Historical Data (1985-2016) - Unpivoted

Physicians By Medical Speciality - Historical Data (1985-2016) - Unpivoted

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

127.51 KB
33557 rows
6 columns

freq Freq	unit Unit	med_spec Med Spec	geo Geo	time_period Time Period	value Value
Annual	Number	Generalist medical practitioners	Austria	1985	6770
Annual	Number	Generalist medical practitioners	Switzerland	1985	1887
Annual	Number	Generalist medical practitioners	Cyprus	1985
Annual	Number	Generalist medical practitioners	Croatia	1985	3488
Annual	Number	Generalist medical practitioners	Luxembourg	1985	240
Annual	Number	Generalist medical practitioners	North Macedonia	1985	1704
Annual	Number	Generalist medical practitioners	Portugal	1985	17997
Annual	Number	Generalist medical practitioners	Türkiye	1985	15549
Annual	Number	Generalist medical practitioners	United Kingdom	1985	32406
Annual	Number	Other generalist medical practitioners	Austria	1985	1845


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.