Baselight

Hospital Beds By Type Of Care - Historical Data (1960-2020)

Eurostat code: hlth_rs_bds ยท (1960 - 2020)

@eurostat.hlth_rs_bds

Hospital Beds By Type Of Care - Historical Data (1960-2020) - Unpivoted
@eurostat.hlth_rs_bds.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.

  • 106.22 KB
  • 16247 rows
  • 6 columns
freq

Freq

unit

Unit

facility

Facility

geo

Geo

time_period

Time Period

value

Value

AnnualInhabitants per ...Available beds in hospitals (HP.1)Greece1960172.72
AnnualInhabitants per ...Available beds in hospitals (HP.1)Italy1960111.42
AnnualInhabitants per ...Available beds in hospitals (HP.1)Lithuania1960127.81
AnnualInhabitants per ...Available beds in hospitals (HP.1)Sweden196070.54
AnnualInhabitants per ...Curative care beds in hospitals (HP.1)Netherlands1960198.05
AnnualInhabitants per ...Curative care beds in hospitals (HP.1)Poland1960219.52
AnnualNumberAvailable beds in hospitals (HP.1)Greece196048239
AnnualNumberAvailable beds in hospitals (HP.1)Italy1960450539
AnnualNumberAvailable beds in hospitals (HP.1)Lithuania196021740
AnnualNumberAvailable beds in hospitals (HP.1)Sweden1960106106

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.