Baselight
Sign In

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Level Of Education

Eurostat code: gbv_vtp_ed ยท (2021 - 2021)

@eurostat.gbv_vtp_ed

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Level Of Education - Unpivoted
@eurostat.gbv_vtp_ed.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.5 KB
  • 296 rows
  • 8 columns
freq

Freq

isced11

Isced11

perp

Perp

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageBelgium202132.7
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageEstonia202147.5
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageFinland202144.5
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageFrance202123.2
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageCroatia202122.2
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageLithuania202144.6
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageLatvia202133.5
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageMalta202124.4
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentageNetherlands202125
AnnualLess than primary, primary and lower secondary education (levels 0-2)Intimate partner - male or femaleFemalesPercentagePortugal202121.3

CREATE TABLE tidy (
  "freq" VARCHAR,
  "isced11" 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.