Baselight
Sign In

Employment And Activity By Sex And Age (1989-2020) - Quarterly Data

Eurostat code: lfsi_emp_q_h ยท (1989-Q1 - 2020-Q4)

@eurostat.lfsi_emp_q_h

Employment And Activity By Sex And Age (1989-2020) - Quarterly Data - Unpivoted
@eurostat.lfsi_emp_q_h.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.

  • 1.88 MB
  • 715992 rows
  • 9 columns
freq

Freq

unit

Unit

sex

Sex

indic_em

Indic Em

age

Age

s_adj

S Adj

geo

Geo

time_period

Time Period

value

Value

QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 24 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Japan1989-Q141.7
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 24 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)United States1989-Q161.4
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 24 yearsSeasonally adjusted data, not calendar adjusted dataJapan1989-Q144
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 24 yearsSeasonally adjusted data, not calendar adjusted dataUnited States1989-Q164
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Japan1989-Q154.7
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 64 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)United States1989-Q167
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 64 yearsSeasonally adjusted data, not calendar adjusted dataJapan1989-Q156.1
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 15 to 64 yearsSeasonally adjusted data, not calendar adjusted dataUnited States1989-Q167.5
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 25 to 54 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Japan1989-Q162.2
QuarterlyPercentage of total populationFemalesPersons in the labour force (former name: active persons)From 25 to 54 yearsUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)United States1989-Q173.6

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "indic_em" VARCHAR,
  "age" VARCHAR,
  "s_adj" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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