Population On 1 January By Age, Sex And Legal Marital Status

Eurostat code: demo_pjanmarsta · (1960 - 2024)

@eurostat.demo_pjanmarsta

Table List

2 tables(7.44 MB)

Population On 1 January By Age, Sex And Legal Marital Status - Raw

Population On 1 January By Age, Sex And Legal Marital Status - Unpivoted

Population On 1 January By Age, Sex And Legal Marital Status - Unpivoted

@eurostat.demo_pjanmarsta.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.

3.29 MB
1086777 rows
8 columns

freq Freq	unit Unit	sex Sex	age Age	marsta Marsta	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Total	Divorced persons	Hungary	1960	101611
Annual	Number	Females	Total	Married persons	Hungary	1960	2524414
Annual	Number	Females	Total	Single persons (never in legal union)	Hungary	1960	1914541
Annual	Number	Females	Total	Widowed persons	Hungary	1960	616435
Annual	Number	Females	Unknown	Divorced persons	Hungary	1960
Annual	Number	Females	Unknown	Married persons	Hungary	1960
Annual	Number	Females	Unknown	Single persons (never in legal union)	Hungary	1960
Annual	Number	Females	Unknown	Widowed persons	Hungary	1960
Annual	Number	Females	1 year	Married persons	Hungary	1960
Annual	Number	Females	1 year	Single persons (never in legal union)	Hungary	1960	73444


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

Share link

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