Baselight

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Level Of Disability (activity Limitation)

Eurostat code: gbv_vtp_lim ยท (2021 - 2021)

@eurostat.gbv_vtp_lim

Persons Who Have Experienced Violence, By Sex, Type Of Perpetrator And Level Of Disability (activity Limitation) - Unpivoted
@eurostat.gbv_vtp_lim.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.66 KB
  • 460 rows
  • 8 columns
freq

Freq

lev_limit

Lev Limit

perp

Perp

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNoneIntimate partner - male or femaleFemalesPercentageBelgium202126.7
AnnualNoneIntimate partner - male or femaleFemalesPercentageEstonia202139.1
AnnualNoneIntimate partner - male or femaleFemalesPercentageFinland202147.2
AnnualNoneIntimate partner - male or femaleFemalesPercentageFrance202129.8
AnnualNoneIntimate partner - male or femaleFemalesPercentageCroatia202128
AnnualNoneIntimate partner - male or femaleFemalesPercentageLithuania202129.2
AnnualNoneIntimate partner - male or femaleFemalesPercentageLatvia202127.8
AnnualNoneIntimate partner - male or femaleFemalesPercentageMalta202124.7
AnnualNoneIntimate partner - male or femaleFemalesPercentageNetherlands202131.4
AnnualNoneIntimate partner - male or femaleFemalesPercentagePortugal202119.3

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