Baselight
Sign In

Number Of Households By Migration Status, Working Status And Household Composition

Eurostat code: lfst_hhmgscomp · (2021 - 2024)

@eurostat.lfst_hhmgscomp

Number Of Households By Migration Status, Working Status And Household Composition - Unpivoted
@eurostat.lfst_hhmgscomp.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.

  • 228.6 KB
  • 76598 rows
  • 8 columns
freq

Freq

hhwkstat

Hhwkstat

hhcomp

Hhcomp

mgstatus

Mgstatus

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsAustria2021153
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsBosnia and Herzegovina20211.5
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsBelgium2021187.3
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsCyprus202117.8
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsCzechia202154.3
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsGermany20211841.7
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsDenmark202177.3
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsEuro area – 20 countries (from 2023)20214894.5
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsEstonia202123.5
AnnualAll adults workingSingle adult - totalAdults foreign-born (first generation)Thousand householdsGreece202125.8

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

Share link

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