Statistics Area Wellness Zone 4500k Forecast for 2023

The dataset collection at hand contains a set of related data tables, sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland. These tables are organized in a user-friendly format with rows and columns for easy accessibility and understanding. The dataset is specifically obtained from the service interface of Tilastokeskus, providing key statistical data. While the collection may include one or more tables, each one is carefully curated to ensure the relatedness and coherence of the data within. The contents of this collection primarily focus on wellbeing and statistical areas, based on the data available for the year 2023. Please note that this comprehensive dataset collection is intended to facilitate in-depth analysis and research in the related fields. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Data of Welfare Regions 2023 (1:4 500 000)TSV
The table 'table__history' is a comprehensive collection of data that is a part of the dataset 'tilastointialueet_hyvinvointialue4500k_2023'. This table specifically focuses on the history of its base table rows, tracking the changes made over time. It contains a wealth of information about Finnish 'Wellbeing Areas' for the year 2023, as mapped on a 1:4 500 000 scale. The table utilizes columns to represent different aspects of these wellbeing areas. For instance, there are columns that denote the start and end dates of a data row's respective version, which serve as a unique identifier for each row in combination with the row number. Additionally, the table features a number of geographic information columns, such as geojson, geotext, centroid, and center coordinates, all of which...
Wellbeing Areas 2023 (1:4 500 000) - Data TableTSV
The table, sourced from Finland's 'Tilastokeskus' (Statistics Finland), contains data on 'Hyvinvointialueet 2023' (Well-being Areas 2023). It includes various types of columns, each serving a distinct purpose. The special columns 'extract_date' and '_row_number' store the date of data extraction and the row number from the source, respectively, making each row uniquely identifiable. Columns with prefix 'geom' hold geographic information, useful for geospatial data analytics, represented in the WGS 84 coordinate reference system, with longitude first, followed by latitude. The table also includes columns that provide names of the well-being areas in different languages, and a column 'vuosi' indicating the year of the data. This data can be highly beneficial in various data analytic...

Column Descriptions

Wellbeing Areas 2023 (1:4 500 000) - Data Table

Column	Type	Comment
_extract_date	date	This column holds the date when data from a row in the table was extracted. It's crucial for data traceability and understanding when the data was recorded.
_row_number	long	This column contains the row number as extracted from the source. It's used in combination with the '_extract_date' to uniquely identify each row in the table.
geom_geojson	string	This column contains the geographic data in GeoJSON format. It represents the geometry of the area in terms of polygons or multipolygons.
geom_geotext	string	Similar to 'geom_geojson', this column holds geographic data, but in text format. It's useful for visualizing and understanding the geographic layout of the area.
geom_type	string	This column indicates the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. It could be either a polygon or a multipolygon.
geom_centroid	string	This column contains the geographic point data representing the centroid of the area. The centroid is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column represents the X-coordinate (longitude) of the geometric center of the area.
geom_center_y	double	This column represents the Y-coordinate (latitude) of the geometric center of the area.
gml_id	string	This column contains a unique identifier for each row in the table.
hyvinvointialue	string	This column holds a code that represents a specific area. It's useful for categorizing the data based on geographic regions.
name	string	This column contains the English name of the area.
namn	string	This column contains the name of the area in the Swedish language.
nimi	string	This column contains the name of the area in the Finnish language.
vuosi	long	This column holds the year related to the data row. It's useful for understanding the time context of the data.

Historical Data of Welfare Regions 2023 (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date at which a particular row was extracted from the original data source. This, along with '_row_number', uniquely identifies each row in this version history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If this field is null, it indicates that the row is the most recent version.
_row_number	long	This column represents the number of the row as it appears in the raw data extracted from the data source. Together with '_start_date', this field uniquely identifies each row in the history table.
geom_geojson	string	This column contains the geographical data in GeoJSON format, representing the shape of the wellbeing area.
geom_geotext	string	This column holds the geographical data in text format, representing the shape of the wellbeing area.
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 contains the geographical point at the center of the wellbeing area.
geom_center_x	double	This column contains the x-coordinate of the center point of the wellbeing area.
geom_center_y	double	This column contains the y-coordinate of the center point of the wellbeing area.
gml_id	string	This column contains a unique identifier for the wellbeing area.
hyvinvointialue	string	This column contains a code for 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 contains the year the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024