Baselight
Sign In

Employment (thousand Hours Worked) By NUTS 2 Region

Eurostat code: nama_10r_2emhrw · (1995 - 2023)

@eurostat.nama_10r_2emhrw

Employment (thousand Hours Worked) By NUTS 2 Region - Unpivoted
@eurostat.nama_10r_2emhrw.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.

  • 2.58 MB
  • 381447 rows
  • 7 columns
freq

Freq

unit

Unit

wstatus

Wstatus

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualThousandEmployed personsAgriculture, forestry and fishingCyprus199562539
AnnualThousandEmployed personsAgriculture, forestry and fishingKýpros199562539
AnnualThousandEmployed personsAgriculture, forestry and fishingKýpros199562539
AnnualThousandEmployed personsAgriculture, forestry and fishingCzechia1995531439
AnnualThousandEmployed personsAgriculture, forestry and fishingČesko1995531439
AnnualThousandEmployed personsAgriculture, forestry and fishingPraha19954710
AnnualThousandEmployed personsAgriculture, forestry and fishingStřední Čechy199572439
AnnualThousandEmployed personsAgriculture, forestry and fishingJihozápad199595183
AnnualThousandEmployed personsAgriculture, forestry and fishingSeverozápad199545128
AnnualThousandEmployed personsAgriculture, forestry and fishingSeverovýchod199594060

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