Baselight

Level Of Trust By Income Quintile, Household Composition, Degree Of Urbanisation And Domain

Eurostat code: ilc_pw04b ยท (2013 - 2013)

@eurostat.ilc_pw04b

Level Of Trust By Income Quintile, Household Composition, Degree Of Urbanisation And Domain - Unpivoted
@eurostat.ilc_pw04b.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.

  • 21.36 KB
  • 13549 rows
  • 10 columns
freq

Freq

domain

Domain

statinfo

Statinfo

deg_urb

Deg Urb

hhcomp

Hhcomp

quant_inc

Quant Inc

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Austria20135.5
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Belgium20135.1
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Bulgaria20133
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Switzerland20136.6
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Cyprus20133.4
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Czechia20133.4
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Germany20134.8
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Denmark20137.2
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Estonia20134.9
AnnualLegal systemAverageCitiesOne adultFirst quintileRating (0-10)Greece20132.9

CREATE TABLE tidy (
  "freq" VARCHAR,
  "domain" VARCHAR,
  "statinfo" VARCHAR,
  "deg_urb" VARCHAR,
  "hhcomp" VARCHAR,
  "quant_inc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.