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) - Raw

@eurostat.hlth_rs_spec.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

201.97 KB
2438 rows
41 columns

freq Freq	unit Unit	med_spec Med Spec	geo Geo	n_1985 1985	n_1986 1986	n_1987 1987	n_1988 1988	n_1989 1989	n_1990 1990	n_1991 1991	n_1992 1992	n_1993 1993	n_1994 1994	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021
Annual	Number	Generalist medical practitioners	Austria	6770	6930	7239	7583	7900	8312	8698	9105	9364	9701	10032	10272	10558	10867	10771	10939	11228	11335	11488	11757	12065	12488	12725	12735	12979	13219	13403	13657	13924	14130	14275	13834	13745		13581	13280	13277
Annual	Number	Generalist medical practitioners	Belgium																12261	12303	12346	12394	12412	12405	12415	12336	12273	12286	12228	12290	12363	12483	12560	12693	12929	12992	13178	13425	13697
Annual	Number	Generalist medical practitioners	Bulgaria																		5760	5561	5685	5631	5521	5426	5043	5198	4961	4905	4789	4743	4703	4512	4610	4396	4322	4255	4174
Annual	Number	Generalist medical practitioners	Switzerland	1887	1996	2090	2163	2393	2438	2490	2538	2572	2583	2595	2626	2669	2698	2740	2812	2863	3262	3745	3884	3842	3920	4005	4581	4683	4748	8356	8618	8986	9225	9570	9601	9628	9683	9724	9848	9964
Annual	Number	Generalist medical practitioners	Cyprus		138			188	191	205	223	229		338					288														680	735	786	833	912	842
Annual	Number	Generalist medical practitioners	Czechia											7175					7465					7423	7404	7320	7332	7366	7369	7369	7386	7371						7330	7112
Annual	Number	Generalist medical practitioners	Germany							58515	60489	62805	64609	66217	67415	67861	68866	70243	72913	73605	73158	72686	70116	70036	68521	68026	69303	71218	74113	75252	75390	78608	80210	78201	79034	80184	81116	83049	85471
Annual	Number	Generalist medical practitioners	Denmark										2509	2746	2857	3211	3421	3503	3944	3970	3984	3972	4194	4168	4187	4187	4344	4350	4397	4422	4481	4459	4499	4575	4585	4617	4649	4641
Annual	Number	Generalist medical practitioners	Estonia														799	948	1048	913	969	1004	983	982	987	1017	1020	979	979	1001	959	1052	1057	1052	1061	1059	1097	1102	1084
Annual	Number	Generalist medical practitioners	Greece																					2911	2772	3499	3057	3124	3391	3369	3456	3494	4307	4396	4521	4651	4390	4732


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "med_spec" VARCHAR,
  "geo" VARCHAR,
  "n_1985" DOUBLE,
  "n_1986" DOUBLE,
  "n_1987" DOUBLE,
  "n_1988" DOUBLE,
  "n_1989" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE
);