Welfare Zone Statistical Areas Data Collection 2024

This dataset collection comprises of related data tables that originate from the 'Tilastokeskus' website, located in Finland. The data tables are associated with the statistical service interface (WFS) by Tilastokeskus, providing a wealth of information. The collection offers an in-depth look into well-being regions and statistical areas, presumably for the year 2024. This information is organized in a clear and concise tabular format, facilitating easy data analysis and interpretation. The dataset is particularly useful for researchers, policymakers, and social scientists interested in Finland's social-economic indicators and their projected trends. 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 Wellbeing Regions 2024 (1:4 500 000)TSV
The 'table__history' is a part of the dataset collection 'tilastointialueet_hyvinvointialue4500k_2024'. It is a history table that provides a detailed record of changes over time for each row of its base table. The base table pertains to 'Wellbeing Regions 2024' at a scale of 1:4,500,000. The table contains a unique combination of '_start_date' and '_row_number' which acts as a unique identifier for each row. The column '_start_date' reflects the date of data extraction from the source, whilst the '_end_date' signifies the date when a new version of the row was extracted. If '_end_date' is null, the row represents the most recent version. The table also hosts a number of geography-related columns that start with 'geom_'. These columns contain geospatial data that can be used for...
Welfare Areas 2024 (Scale 1:4,500,000) - Data TableTSV
The table, part of the dataset collection titled 'tilastointialueet_hyvinvointialue4500k_2024', is a rich source of geographic and wellbeing information projected for the year 2024. It presents a comprehensive view of wellbeing areas in Finland, sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains a variety of columns, each offering unique insights into the areas studied. For instance, the columns starting with 'geom_' provide geographic data, useful for geospatial analytics. These columns offer information such as the type of geographic shape, the geojson and geotext data, and the center coordinates of the areas. It's important to note that the geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being...

Column Descriptions

Welfare Areas 2024 (Scale 1:4,500,000) - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source. It plays a key role in uniquely identifying each row in conjunction with the '_row_number' column.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It is a crucial component in uniquely identifying each row.
geom_geojson	string	This column holds geometric data in GeoJSON format, a widely-used format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometrical data in text format.
geom_type	string	This column specifies the type of the geometric data stored in the table, such as 'ST_POLYGON' indicating that the geometric data forms a polygon.
geom_centroid	string	This column holds the centroid of the geometric figure. The centroid is a point representing the center of the geometric figure.
geom_center_x	double	This column contains the X-coordinate of the center point of the geometric figure.
geom_center_y	double	This column contains the Y-coordinate of the center point of the geometric figure.
gml_id	string	This is a string type column which presumably holds a unique identifier for each row.
hyvinvointialue	string	This column is of type string, however, the specific content is not clarified in the provided information.
name	string	This column contains names of entities or areas in English.
namn	string	This column contains names of entities or areas in another language, presumably Finnish or Swedish.
nimi	string	This column contains names of entities or areas in another language, presumably Finnish.
vuosi	long	This column is of type integer and it seemingly holds year-related information.

Version History of Wellbeing Regions 2024 (1:4 500 000)

Column	Type	Comment
_start_date	date	Contains the date when the row was extracted from the data source. It is used in combination with '_row_number' to uniquely identify each row in the version history table.
_end_date	date	Contains the date when a new version of the row was extracted from the data source. If this column's value is null, it means that the row is the most recent version.
_row_number	long	Contains the number of the row in the raw data extracted from the data source. It is used in combination with '_start_date' to uniquely identify each row in the version history table.
geom_geojson	string	Contains the geographical data in GeoJSON format, which can be a polygon or multipolygon that represents the specified area.
geom_geotext	string	Contains the geographical data in text format, which can be a polygon or multipolygon that represents the specified area.
geom_type	string	Specifies the type of geographical data stored in 'geom_geojson' and 'geom_geotext', either a polygon or multipolygon.
geom_centroid	string	Contains the geographical point that represents the centroid of the specified area.
geom_center_x	double	Contains the X-coordinate of the geographical point that represents the center of the specified area.
geom_center_y	double	Contains the Y-coordinate of the geographical point that represents the center of the specified area.
gml_id	string	Contains a unique identifier for each row, which is associated with the 'hyvinvointialue' and 'vuosi' columns.
hyvinvointialue	string	Contains numerical codes representing different wellbeing areas.
name	string	Contains the English name of the wellbeing area.
namn	string	Contains the Swedish name of the wellbeing area.
nimi	string	Contains the Finnish name of the wellbeing area.
vuosi	long	Contains the year associated with the data of the wellbeing area.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024