Physicians By Category

Eurostat code: hlth_rs_physcat · (1985 - 2022)

@eurostat.hlth_rs_physcat

Table List

2 tables(209.72 KB)

Physicians By Category - Unpivoted

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

87.1 KB
16402 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	Finland	1985	5436
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	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.