Baselight

Deaths (total) By Other Typologies

Eurostat code: urt_deaths ยท (1990 - 2022)

@eurostat.urt_deaths

Deaths (total) By Other Typologies - Unpivoted
@eurostat.urt_deaths.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.

  • 56.42 KB
  • 8785 rows
  • 6 columns
freq

Freq

unit

Unit

terrtypo

Terrtypo

geo

Geo

time_period

Time Period

value

Value

AnnualNumberBorder regionsAustria199073500
AnnualNumberBorder regionsBelgium199078242
AnnualNumberBorder regionsBulgaria199063710
AnnualNumberBorder regionsSwitzerland199058850
AnnualNumberBorder regionsEstonia199010500
AnnualNumberBorder regionsSpain199073500
AnnualNumberBorder regionsFinland199013498
AnnualNumberBorder regionsHungary1990104479
AnnualNumberBorder regionsLiechtenstein1990195
AnnualNumberBorder regionsLithuania199031533

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

Share link

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