Baselight
Sign In

Persons Who Have Experienced Physical/sexual Violence, By Sex And Type Of Perpetrator

Eurostat code: gbv_vtp_perp ยท (2021 - 2021)

@eurostat.gbv_vtp_perp

Persons Who Have Experienced Physical/sexual Violence, By Sex And Type Of Perpetrator - Unpivoted
@eurostat.gbv_vtp_perp.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.27 KB
  • 553 rows
  • 7 columns
freq

Freq

perp

Perp

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFamily member or relative - male or femaleFemalesPercentageBelgium20215.5
AnnualFamily member or relative - male or femaleFemalesPercentageEstonia20213
AnnualFamily member or relative - male or femaleFemalesPercentageFinland20216.5
AnnualFamily member or relative - male or femaleFemalesPercentageFrance20215.4
AnnualFamily member or relative - male or femaleFemalesPercentageCroatia20212.8
AnnualFamily member or relative - male or femaleFemalesPercentageLithuania20212.1
AnnualFamily member or relative - male or femaleFemalesPercentageLatvia20212
AnnualFamily member or relative - male or femaleFemalesPercentageMalta20213.5
AnnualFamily member or relative - male or femaleFemalesPercentageNetherlands20216.5
AnnualFamily member or relative - male or femaleFemalesPercentagePortugal20212.8

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