Hospital Beds By Function And Type Of Care

Eurostat code: hlth_rs_bds1 · (1960 - 2022)

@eurostat.hlth_rs_bds1

Table List

2 tables(320.01 KB)

Hospital Beds By Function And Type Of Care - Raw

Hospital Beds By Function And Type Of Care - Unpivoted

Hospital Beds By Function And Type Of Care - Unpivoted

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

142.04 KB
22643 rows
7 columns

freq Freq	unit Unit	facility Facility	hlthcare Hlthcare	geo Geo	time_period Time Period	value Value
Annual	Inhabitants per ...	Available beds in hospitals (HP.1)	Total	Greece	1960	172.72
Annual	Inhabitants per ...	Available beds in hospitals (HP.1)	Total	Lithuania	1960	127.81
Annual	Inhabitants per ...	Available beds in hospitals (HP.1)	Total	Sweden	1960	70.54
Annual	Number	Available beds in hospitals (HP.1)	Total	Greece	1960	48239
Annual	Number	Available beds in hospitals (HP.1)	Total	Lithuania	1960	21740
Annual	Number	Available beds in hospitals (HP.1)	Total	Sweden	1960	106106
Annual	Per hundred thousand inhabitants	Available beds in hospitals (HP.1)	Total	Greece	1960	578.98
Annual	Per hundred thousand inhabitants	Available beds in hospitals (HP.1)	Total	Lithuania	1960	782.42
Annual	Per hundred thousand inhabitants	Available beds in hospitals (HP.1)	Total	Sweden	1960	1417.65
Annual	Inhabitants per ...	Available beds in hospitals (HP.1)	Total	Greece	1961	172.17


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

Share link

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