Baselight

Persons Who Had Consequences Due To Experienced Physical/sexual Violence, By Sex, Perpetrator And Type Of Consequence

Eurostat code: gbv_vtp_cnq ยท (2021 - 2021)

@eurostat.gbv_vtp_cnq

Persons Who Had Consequences Due To Experienced Physical/sexual Violence, By Sex, Perpetrator And Type Of Consequence - Unpivoted
@eurostat.gbv_vtp_cnq.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.15 KB
  • 361 rows
  • 8 columns
freq

Freq

effect

Effect

perp

Perp

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageBelgium20219.5
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageEstonia202111.7
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageFinland202114.4
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageFrance20218.8
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageCroatia20216.2
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageLithuania202110.3
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageLatvia202110
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageMalta20218.7
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentageNetherlands20216.7
AnnualPhysical injuryIntimate partner - male or femaleFemalesPercentagePortugal20215.1

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