Wellbeing Area Statistical Collection 2022

The dataset collection under consideration is a compilation of related data tables that have been sourced from the 'Tilastokeskus' (Statistics Finland) website, based in Finland. The collection includes data regarding statistical areas and wellness areas, presented in a precise and easily navigable format of rows and columns. The information is extracted from the service interface (WFS) provided by the Statistics Finland, ensuring a high level of reliability and authenticity. This dataset collection serves as a valuable resource for understanding and analyzing trends and patterns related to wellness areas in Finland. It can be beneficial for researchers, policymakers, and analysts in making informed decisions and strategies. 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 Welfare Areas 2022 (1:1 000 000)TSV
The 'History' table is part of the 'Wellbeing Areas 2022 (1:1 000 000)' dataset and serves as a version history record of the base table rows. This table is primarily sourced from the 'Tilastokeskus' website based in Finland. The table is organized in such a way that each row is uniquely identified by the combination of 'start_date' and '_row_number'. The '_start_date' indicates the date when the row was extracted from the data source and '_end_date' signifies when a new version of the row was extracted. If the '_end_date' is null, it implies that the row is the most recent version. The table contains geographic information denoted by columns starting with 'geom', which can be used for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate...
Wellbeing Areas 2022 (1:1 000 000) - Data TableTSV
The table under consideration is derived from the 'Tilastokeskus' website, based in Finland. It is a part of a larger dataset collection that revolves around the theme of 'Wellbeing Areas 2022' at a scale of 1:1,000,000. The table comprises various columns, each containing specific information related to the theme. Two special columns are '_extract_date' and '_row_number', which store the date when the data was extracted and the row number in the extracted data respectively. These two columns in combination provide a unique identity to each row. The table also provides a wealth of geospatial data, with several columns starting with 'geom_' that contain geographic information. These columns can be utilized for geospatial data analytics, with geographic coordinates being presented using...

Column Descriptions

Wellbeing Areas 2022 (1:1 000 000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source. It allows tracking of the extraction history of each row.
_row_number	long	This column contains the sequential row number in the data extracted from the source on the extract date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains geometric data in GeoJSON format, which is a format for encoding geographical data structures. It can include data such as polygons or multipolygons representing specific areas.
geom_geotext	string	This column contains geometric data in text format, which provides a human-readable representation of the geographical data structures. It can include data such as polygons or multipolygons representing specific areas.
geom_type	string	This column indicates the type of geometric data represented in the 'geom_geojson' and 'geom_geotext' columns. It typically includes values such as 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the centroid point of the geometric shape in 'POINT' format. The centroid is the geometric center of a shape.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geometric shape. It represents the longitude of the center point.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geometric shape. It represents the latitude of the center point.
gml_id	string	This is a unique identifier for each row. It is typically composed of the name of the well-being area and the year.
hyvinvointialue	string	This column contains the identifier for the well-being area. The identifier is a unique number assigned to each well-being area.
name	string	This column contains the English name of the well-being area.
namn	string	This column contains the Swedish name of the well-being area.
nimi	string	This column contains the Finnish name of the well-being area.
vuosi	long	This column contains the year to which the data pertains.

Version History of Welfare Areas 2022 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column represents the date when the row data was extracted from the data source. It forms a unique identifier for each row in conjunction with the _row_number column.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most current version.
_row_number	long	This column represents the number of the row as it appears in the raw data sourced from the data source. It forms a unique identifier for each row in conjunction with the _start_date column.
geom_geojson	string	This column contains the geographical data of the wellbeing area in GeoJSON format, which may represent polygons or multipolygons.
geom_geotext	string	This column contains the geographical data of the wellbeing area in textual format, which may represent polygons or multipolygons.
geom_type	string	This column indicates the type of the geographical data, which can be either a polygon or a multipolygon.
geom_centroid	string	This column represents the centroid point of the geographical area.
geom_center_x	double	This column represents the x-coordinate of the center of the geographical area.
geom_center_y	double	This column represents the y-coordinate of the center of the geographical area.
gml_id	string	This column contains a unique identifier for the row in the data source.
hyvinvointialue	string	This column represents a code associated with the wellbeing area.
name	string	This column contains the English name of the wellbeing area.
namn	string	This column contains the Swedish name of the wellbeing area.
nimi	string	This column contains the Finnish name of the wellbeing area.
vuosi	long	This column represents the year associated with the data row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024