Baselight

Fetal, Peri- And Neonatal Mortality Rates By Country Of Occurrence

Eurostat code: hlth_cd_aperrto ยท (2011 - 2023)

@eurostat.hlth_cd_aperrto

Fetal, Peri- And Neonatal Mortality Rates By Country Of Occurrence - Unpivoted
@eurostat.hlth_cd_aperrto.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.

  • 8.13 KB
  • 1697 rows
  • 7 columns
freq

Freq

unit

Unit

resid

Resid

indic_de

Indic De

geo

Geo

time_period

Time Period

value

Value

AnnualRateAll deaths reported in the countryEarly neonatal mortality rateAustria20112
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateBelgium20111.9
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateBulgaria20113.9
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateSwitzerland20112.7
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateCyprus20111.4
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateCzechia20111.1
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateGermany20111.9
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateDenmark20112.4
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateEstonia20111.1
AnnualRateAll deaths reported in the countryEarly neonatal mortality rateGreece20111.3

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

Share link

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