Baselight

Distribution Of Households With Children By Number Of Children

Eurostat code: ilc_lvph05 ยท (2003 - 2024)

@eurostat.ilc_lvph05

Distribution Of Households With Children By Number Of Children - Unpivoted
@eurostat.ilc_lvph05.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.

  • 11.43 KB
  • 3088 rows
  • 6 columns
freq

Freq

n_child

N Child

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual1 childPercentageAustria200347.9
Annual1 childPercentageBelgium200345.4
Annual1 childPercentageDenmark200341.7
Annual1 childPercentageGreece200346.5
Annual1 childPercentageIreland200340
Annual1 childPercentageLuxembourg200343.5
Annual1 childPercentageNorway200341.6
Annual2 childrenPercentageAustria200338.6
Annual2 childrenPercentageBelgium200336.8
Annual2 childrenPercentageDenmark200343

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

Share link

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