Surgical Operations And Procedures Performed In Hospitals By ICD-9-CM - Historical Data (1990-2016)

Eurostat code: hlth_co_proc2 · (1990 - 2021)

@eurostat.hlth_co_proc2

Table List

2 tables(820.1 KB)

Surgical Operations And Procedures Performed In Hospitals By ICD-9-CM - Historical Data (1990-2016) - Raw

Surgical Operations And Procedures Performed In Hospitals By ICD-9-CM - Historical Data (1990-2016) - Unpivoted

Surgical Operations And Procedures Performed In Hospitals By ICD-9-CM - Historical Data (1990-2016) - Unpivoted

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

358.37 KB
92008 rows
7 columns

freq Freq	icha_hc Icha Hc	unit Unit	icd9cm Icd9cm	geo Geo	time_period Time Period	value Value
Annual	Day patient	Number	Cataract surgery	Finland	1990	102
Annual	Day patient	Number	Stem cell transplantation	Spain	1990
Annual	Day patient	Number	Stem cell transplantation	Slovakia	1990
Annual	Day patient	Number	Transplantation of kidney	Czechia	1990
Annual	Day patient	Number	Transplantation of kidney	Spain	1990
Annual	Day patient	Number	Transplantation of kidney	Netherlands	1990
Annual	Day patient	Number	Caesarean section (74.0 to 74.2, 74.4 and 74.99)	Bulgaria	1990
Annual	Day patient	Number	Caesarean section (74.0 to 74.2, 74.4 and 74.99)	Czechia	1990
Annual	Day patient	Number	Caesarean section (74.0 to 74.2, 74.4 and 74.99)	Latvia	1990
Annual	Day patient	Number	Caesarean section (74.0 to 74.2, 74.4 and 74.99)	Netherlands	1990


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

Share link

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