Statistical Areas and Well-being Index Dataset Collection

This dataset collection is a compilation of wellness area statistics, sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. It consists of several related data tables that offer a broad and in-depth look into wellbeing. The collection includes tables that cover different years, providing a multi-year perspective. The data within these tables is organized in an easy-to-understand format of columns and rows, which makes it simple to compare and analyze the different statistics. The data was originally provided through Tilastokeskus's service interface (WFS), and it offers valuable insights into the state of wellbeing across different areas. 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 for Well-being Areas (1:1 000 000)TSV
The 'table__history' is a dynamic and comprehensive record of the 'Wellbeing Areas' (Hyvinvointialueet) dataset, captured at the granularity of 1:1 000 000. This table is a part of a larger dataset collection, which provides an extensive overview of these areas. The table is sourced from the Finnish Statistics Bureau, 'Tilastokeskus', in Finland. The 'table__history' primarily serves to maintain a version history of its base table rows. It offers a unique combination of columns, '_start_date' and '_row_number', which identifies each row in this version history table. The '_start_date' refers to the date when the row was extracted from the data source, while the '_end_date' signifies the date when a new version of the row was extracted. If the '_end_date' is null, it indicates that the...
Wellbeing Regions Dataset Table (Scale 1:1 000 000)TSV
The table, which is part of a larger dataset collection, contains data related to 'Wellbeing Areas' at 1:1,000,000 scale. The data is sourced from 'Tilastokeskus' (Statistics Finland), based in Finland. Each row in the table represents a unique Wellness Area, identified by a row number and the date when the data was extracted from the source. The geographic coordinates, presented using the WGS 84 coordinate reference system (longitude first, then latitude), are provided which can be utilized for geospatial data analytics. Information about the geographic area, its type, centroid, and center are included. Each area is also identified with a unique 'gml_id'. Additionally, the table contains columns that detail the area's name in different languages and the year of the data. This table...

Column Descriptions

Wellbeing Regions Dataset Table (Scale 1:1 000 000)

Column	Type	Comment
_extract_date	date	This is a special column recording the date when the data on the row was extracted from the source.
_row_number	long	This is another special column capturing the row number in the data extracted from the source on the extraction date specified by '_extract_date'.
geom_geojson	string	This column contains geometric data in GeoJSON format, representing the geographic area associated with each row.
geom_geotext	string	This column contains geometric data in textual format, corresponding to the geographic area associated with each row.
geom_type	string	This column specifies the type of the geometric data associated with each row, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column contains the coordinates for the centroid (geometric center) of the area associated with each row.
geom_center_x	double	This column contains the x-coordinate of the geographic center of the area associated with each row.
geom_center_y	double	This column contains the y-coordinate of the geographic center of the area associated with each row.
gml_id	string	This column contains the unique identifier for each row, which is of type String.
hyvinvointialue	string	This column contains information about wellbeing areas, which is of type String.
name	string	This column contains English translations of the names of the wellbeing areas.
namn	string	This column contains Swedish translations of the names of the wellbeing areas.
nimi	string	This column contains Finnish names of the wellbeing areas.
vuosi	long	This column, of type Integer, captures the year associated with each row.

Version History for Well-being Areas (1:1 000 000)

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. It forms a unique combination with '_row_number' to identify each row in this version history table.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source. If the value in this column is null, it signifies that the row is the most recent version.
_row_number	long	This column indicates the number of the row in the raw data extracted from the source. It forms a unique combination with '_start_date' to identify each row in this version history table.
geom_geojson	string	This column contains geometric data for the well-being area in geojson format. The data could represent various geometric shapes like polygons or multipolygons.
geom_geotext	string	This column contains geometric data for the well-being area in text format. The data could represent various geometric shapes like polygons or multipolygons.
geom_type	string	This column denotes the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. It can be of types like 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the coordinates of the centroid of the geometric shape representing the well-being area.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geometric shape representing the well-being area.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geometric shape representing the well-being area.
gml_id	string	This is a unique identifier for each well-being area in the table.
hyvinvointialue	string	This column signifies the code for each well-being area.
name	string	This column contains the English name of the well-being area.
namn	string	This column contains the name of the well-being area in Swedish.
nimi	string	This column contains the name of the well-being area in Finnish.
vuosi	long	This column represents the year of the data. This table contains data from the year 2024.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024