Surgical Procedures

Eurostat code: hlth_co_proc3 · (1990 - 2022)

@eurostat.hlth_co_proc3

Table List

2 tables(632.76 KB)

Surgical Procedures - Unpivoted

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

278.19 KB
68646 rows
7 columns

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


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

Share link

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