Baselight

Persons Who Have Experienced Physical/sexual Violence By Sex, Type Of Perpetrator And Person/support Service To Whom Violence Was Reported

Eurostat code: gbv_vtp_rp ยท (2021 - 2021)

@eurostat.gbv_vtp_rp

Persons Who Have Experienced Physical/sexual Violence By Sex, Type Of Perpetrator And Person/support Service To Whom Violence Was Reported - Unpivoted
@eurostat.gbv_vtp_rp.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.22 KB
  • 502 rows
  • 8 columns
freq

Freq

pers_serv

Pers Serv

perp

Perp

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageBelgium202181.2
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageEstonia202175.6
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageFinland202155.8
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageFrance202173.8
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageCroatia202169.6
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageLithuania202173.1
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageLatvia202176.5
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageMalta202184.8
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentageNetherlands202166.2
AnnualAny person or serviceIntimate partner - male or femaleFemalesPercentagePortugal202152.2

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