Standardised Death Rate Due To Homicide By Sex

Eurostat code: sdg_16_10 · (2000 - 2022)

@eurostat.sdg_16_10

Table List

2 tables(38.73 KB)

Standardised Death Rate Due To Homicide By Sex - Raw

Standardised Death Rate Due To Homicide By Sex - Unpivoted

Standardised Death Rate Due To Homicide By Sex - Unpivoted

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

10.69 KB
2298 rows
8 columns

freq Freq	unit Unit	icd10 Icd10	age Age	sex Sex	geo Geo	time_period Time Period	value Value
Annual	Rate	Assault	Total	Females	Austria	2000	1.2
Annual	Rate	Assault	Total	Females	Bulgaria	2000	2.1
Annual	Rate	Assault	Total	Females	Switzerland	2000	0.8
Annual	Rate	Assault	Total	Females	Czechia	2000	1
Annual	Rate	Assault	Total	Females	Germany	2000	0.7
Annual	Rate	Assault	Total	Females	Denmark	2000	1.1
Annual	Rate	Assault	Total	Females	Estonia	2000	4.9
Annual	Rate	Assault	Total	Females	Greece	2000	0.8
Annual	Rate	Assault	Total	Females	Spain	2000	0.5
Annual	Rate	Assault	Total	Females	Finland	2000	1.6


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "icd10" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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