Baselight

Population And Employment - National Accounts

Eurostat code: nama_10_pe ยท (1975 - 2024)

@eurostat.nama_10_pe

Population And Employment - National Accounts - Unpivoted
@eurostat.nama_10_pe.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.

  • 70.31 KB
  • 15877 rows
  • 6 columns
freq

Freq

unit

Unit

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualPercentage change on previous period (based on persons)Total employment domestic conceptDenmark1975-1
AnnualPercentage change on previous period (based on persons)Total employment domestic conceptNorway19751.7
AnnualPercentage change on previous period (based on persons)Total employment national conceptDenmark1975-1
AnnualPercentage change on previous period (based on persons)Total employment national conceptNorway19751.8
AnnualPercentage change on previous period (based on persons)Total population national conceptDenmark19750.3
AnnualPercentage change on previous period (based on persons)Total population national conceptNorway19750.6
AnnualPercentage change on previous period (based on persons)Employees domestic conceptDenmark1975-0.8
AnnualPercentage change on previous period (based on persons)Employees domestic conceptNorway19752.2
AnnualPercentage change on previous period (based on persons)Employees national conceptDenmark1975-0.8
AnnualPercentage change on previous period (based on persons)Employees national conceptNorway19752.5

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

Share link

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