Hospital Beds By NUTS 2 Region - Historical Data (1993-2016)

Eurostat code: hlth_rs_bdsrg · (1993 - 2021)

@eurostat.hlth_rs_bdsrg

Table List

2 tables(940.23 KB)

Hospital Beds By NUTS 2 Region - Historical Data (1993-2016) - Raw

Hospital Beds By NUTS 2 Region - Historical Data (1993-2016) - Unpivoted

Hospital Beds By NUTS 2 Region - Historical Data (1993-2016) - Unpivoted

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

440.22 KB
88507 rows
6 columns

freq Freq	unit Unit	facility Facility	geo Geo	time_period Time Period	value Value
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Austria	1993	1294.31
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Niederösterreich	1993	1296.84
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Wien	1993	1035.2
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Kärnten	1993	1256.01
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Steiermark	1993	5513.78
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Oberösterreich	1993	1239.27
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Salzburg	1993	924.78
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Tirol	1993	859.5
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Vorarlberg	1993	817.95
Annual	Inhabitants per ...	Psychiatric care beds in hospitals (HP.1)	Belgium	1993	485.37


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

Share link

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