Baselight

Gross National Income (GNI) Per Capita

Eurostat code: nama_10_pp ยท (2020 - 2023)

@eurostat.nama_10_pp

Gross National Income (GNI) Per Capita - Unpivoted
@eurostat.nama_10_pp.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.

  • 5.35 KB
  • 112 rows
  • 5 columns
freq

Freq

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaAustria202037845
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaBelgium202036217
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaBulgaria202016878
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaCyprus202025870
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaCzechia202027708
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaGermany202038486
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaDenmark202041422
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaEstonia202025658
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaGreece202018700
AnnualCurrent prices, purchasing power standard (PPS, EU27 from 2020) per capitaSpain202025209

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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