Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Degree Of Urbanisation

Eurostat code: gbv_vtp_du · (2021 - 2021)

@eurostat.gbv_vtp_du

Table List

2 tables(13.56 KB)

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Degree Of Urbanisation - Raw

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Degree Of Urbanisation - Unpivoted

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Degree Of Urbanisation - Unpivoted

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

7.08 KB
290 rows
8 columns

freq Freq	deg_urb Deg Urb	perp Perp	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cities	Intimate partner - male or female	Females	Percentage	Belgium	2021	35.5
Annual	Cities	Intimate partner - male or female	Females	Percentage	Estonia	2021	40.6
Annual	Cities	Intimate partner - male or female	Females	Percentage	Finland	2021	53
Annual	Cities	Intimate partner - male or female	Females	Percentage	France	2021	33.3
Annual	Cities	Intimate partner - male or female	Females	Percentage	Croatia	2021	31.9
Annual	Cities	Intimate partner - male or female	Females	Percentage	Lithuania	2021	31.1
Annual	Cities	Intimate partner - male or female	Females	Percentage	Latvia	2021	29.7
Annual	Cities	Intimate partner - male or female	Females	Percentage	Malta	2021	28.4
Annual	Cities	Intimate partner - male or female	Females	Percentage	Netherlands	2021	35.5
Annual	Cities	Intimate partner - male or female	Females	Percentage	Portugal	2021	23.9


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

Share link

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