Statistical Areas Wellbeing Data Collection 2022

The dataset collection in question consists of a group of related data tables which have been sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The content within these tables is organized in a tabular format, comprising of columns and rows that hold related data. The description provided by Tilastokeskus's service interface (WFS) indicates that this dataset collection contains statistical data on well-being in various regions. Therefore, this dataset collection offers a comprehensive overview of well-being data for different areas, making it a valuable resource for researchers, planners, and policy makers who are interested in studying and improving well-being in Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Version History of Well-being Areas 2022 (1:4 500 000) TableTSV
The 'table__history' is a part of the 'tilastointialueet_hyvinvointialue4500k_2022' dataset collection. This table is known as a history table, which keeps track of the version history of its base table rows. The base table's content, 'Hyvinvointialueet 2022 (1:4 500 000)', translates to 'Wellbeing Areas 2022 (1:4 500 000)' in English. This information suggests that the table contains geographic and demographic data relating to different wellbeing areas in the year 2022. The table has unique columns to maintain its historical nature. There is a column for the start date, indicating when the row was first added, and an end date, indicating when a new version of the row was added. If the end date is null, it signifies that the row is the most recent version. Another unique feature of...
Wellbeing Regions 2022 (1:4 500 000) - Data TableTSV
The table in question is part of a dataset collection associated with the 'Wellbeing Areas 2022' (Hyvinvointialueet 2022), an extensive data collection sourced from the website of Statistics Finland (Tilastokeskus). The data within this table provides a wealth of information intended for geospatial analysis, primarily focused around geographic and administrative regions. The table is composed of several columns, each acting as a unique identifier or providing specific details about the data. For instance, two notable columns are '_extract_date' and '_row_number'. The former contains the date when the data was extracted, and the latter holds the unique row number for the extracted data. Together, these two columns can uniquely identify any data row within the table. The table also...

Column Descriptions

Wellbeing Regions 2022 (1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	This column indicates the date when the row data was extracted from the source. It plays a crucial role in uniquely identifying each row in combination with the _row_number
_row_number	long	The _row_number column represents the sequence of the data as it was extracted from the source. It works hand in hand with the _extract_date to uniquely identify each row.
geom_geojson	string	This column contains the geometric representation of the data in GeoJSON format. It's useful for mapping and spatial analysis purposes.
geom_geotext	string	The geom_geotext column holds the geometric data in text format. It provides an alternative representation of the spatial data.
geom_type	string	This column specifies the type of the geometric data. It can be a Polygon or a MultiPolygon, which are types of spatial data.
geom_centroid	string	The geom_centroid column contains the centroid point of the geometric data. It's a central point that can be used for spatial analysis and mapping.
geom_center_x	double	This column holds the X coordinate of the center point of the geometric data. It's useful for mapping and spatial analysis.
geom_center_y	double	The geom_center_y column contains the Y coordinate of the center point of the geometric data. It's crucial for mapping and spatial analysis.
gml_id	string	This column holds a unique identifier for each row in the table. It's a string type column.
hyvinvointialue	string	The hyvinvointialue column signifies a specific area. It's a string type column.
name	string	The name column contains the English name of the wellbeing area. It's a string type column.
namn	string	This column holds the Swedish name of the wellbeing area. It's a string type column.
nimi	string	The nimi column represents the Finnish name of the wellbeing area. It's a string type column.
vuosi	long	This integer type column indicates the year.

Version History of Well-being Areas 2022 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with '_row_number'.
_end_date	date	This column comprises the date when a new version of the row was extracted from the data source. If the value is null, the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the source. It forms a unique identifier in combination with '_start_date'.
geom_geojson	string	This column contains geometric data of the wellness area in GeoJSON format, which can be a polygon or multiple polygons.
geom_geotext	string	This column contains geometric data of the wellness area in a plain text format, which can be a polygon or multiple polygons.
geom_type	string	This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a single polygon (ST_POLYGON) or multiple polygons (ST_MULTIPOLYGON).
geom_centroid	string	This column contains the geographical point that represents the centroid of the geometric shape of the wellness area.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geometric shape of the wellness area.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geometric shape of the wellness area.
gml_id	string	This column contains unique identifiers for each row.
hyvinvointialue	string	This column contains the wellness area identifier.
name	string	This column contains the English name of the wellness area.
namn	string	This column contains the Swedish name of the wellness area.
nimi	string	This column contains the Finnish name of the wellness area.
vuosi	long	This column contains the year for the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024