Wellbeing Areas Statistical Data Collection 2023

This dataset collection contains an extensive group of related data tables that have been sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. The tables in this collection are meticulously organized in a format consisting of rows and columns to facilitate easy data interpretation. The dataset's contents are derived from the 'Tilastokeskus' service interface (WFS), ensuring a high level of accuracy and reliability. Each table in this dataset collection is interconnected, providing a comprehensive picture of the subject matter. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

History Table of Wellbeing Regions 2023 (1:1 000 000) Version RecordsTSV
The 'table__history' is a comprehensive repository that captures the version history of its base table rows. This table is a part of the larger dataset collection, illustrating the interconnected nature of the data. This history table is sourced from the 'Tilastokeskus' website, based in Finland. The table provides a rich amount of data, ranging from temporal information to geospatial data. The temporal information, such as the start and end dates of a row's extraction, offers insights into the evolution of the data, allowing analysts to track changes over time. For instance, if the '_end_date' field is null, this signifies that the data is the most recent version extracted. Geospatial data, denoted by the 'geom_' prefix, offers geographic information that can be utilized for geospatial...
Wellbeing Areas 2023 (1:1 000 000) - Key Dataset TableTSV
The table belongs to a larger dataset that provides a detailed overview of the 'Wellbeing Areas 2023' at a scale of 1:1 000 000. It is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The data content of the table consists of a mix of geographic and welfare area information. This includes geographic coordinates, area names in multiple languages (Finnish, Swedish, and English), and an identifier for each wellbeing area. The geographic information, represented in columns starting with 'geom_', is based on the WGS 84 coordinate reference system, with longitude preceding latitude, making it suitable for geospatial data analytics. For example, the 'geom_centroid' provides the geographic center of each area, while the 'geom_geojson' and 'geom_geotext' offer...

Column Descriptions

Wellbeing Areas 2023 (1:1 000 000) - Key Dataset Table

Column	Type	Comment
_extract_date	date	This column holds the date when the data row was extracted from the data source. It helps in tracking the chronology of data extraction.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date. Combined with '_extract_date', it uniquely identifies each row.
geom_geojson	string	This column contains geometric data of the specific area in GeoJSON format. This data is useful for spatial analysis and mapping.
geom_geotext	string	This column contains geometric data of the specific area in textual format. It is another representation of spatial data useful for location-based analysis.
geom_type	string	This column indicates the type of the geometrical figure used to represent the specific area. It can be a multipolygon or a polygon.
geom_centroid	string	This column contains the centroid of the geometric figure representing the specific area. It is represented as a point with coordinates.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geometric figure. This spatial data is used in location-based analysis.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geometric figure. This spatial data is used in location-based analysis.
gml_id	string	This column contains the unique identifier of the specific area in GML format. It is useful for data linking and referencing.
hyvinvointialue	string	This column contains an identifier of the welfare area. It helps in categorizing the data based on different welfare areas.
name	string	This column contains the name of the specific area in English. It aids in identifying the area in the dataset.
namn	string	This column contains the name of the specific area in Swedish. It provides a multilingual approach to data identification.
nimi	string	This column contains the name of the specific area in Finnish. It enhances the localization of the dataset.
vuosi	long	This column contains the year for the data row. It helps in tracking the temporal aspect of the data.

History Table of Wellbeing Regions 2023 (1:1 000 000) Version Records

Column	Type	Comment
_start_date	date	This column contains the date when a particular row was extracted from the data source. It is part of a unique identifier for each row in the version history table, together with the '_row_number' column.
_end_date	date	This column contains the date when a new version of a particular row was extracted from the data source. If the value is null, it indicates that 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 data source. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column.
geom_geojson	string	This column contains the geographical data of a specific area in GeoJSON format. This data is associated with the welfare area represented by the row.
geom_geotext	string	This column contains the geographical data of a specific area in textual format. This data is associated with the welfare area represented by the row.
geom_type	string	This column specifies the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns. The data can be of type 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column contains the geographical coordinates of the centroid, or geometric center, of the area represented by the row.
geom_center_x	double	This column contains the x-coordinate of the centroid of the area represented by the row.
geom_center_y	double	This column contains the y-coordinate of the centroid of the area represented by the row.
gml_id	string	This column contains a unique identifier for each row, which is tied to the welfare area and the year represented by the row.
hyvinvointialue	string	This column contains a numeric identifier for the welfare area represented by the row.
name	string	This column contains the English name of the welfare area represented by the row.
namn	string	This column contains the Swedish name of the welfare area represented by the row.
nimi	string	This column contains the Finnish name of the welfare area represented by the row.
vuosi	long	This column contains the year to which the data in the row corresponds.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024