Statistical Areas and Wellbeing Zones 2024 Dataset Collection

This dataset collection is an assembly of tables that are closely related, sourced from the website of 'Tilastokeskus' (Statistics Finland), in Finland. These tables are structured in a manner that presents the data clearly in rows and columns, ensuring an easy understanding of the information provided. The data within these tables originates from the service interface of the Statistics Centre, providing a rich source of data for analysis and interpretation. The topics covered by this dataset collection are broad, offering a comprehensive view of statistical areas and well-being areas, predicted up to the year 2024. The dataset allows for in-depth research and exploration, making it a valuable resource for data analysts and researchers. 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 Record of Well-being Regions 2024 at 1:1,000,000 ScaleTSV
The 'table__history' is a version history table that tracks the changes over time in the 'Wellbeing Areas 2024 (1:1 000 000)' dataset. This dataset, sourced from the Finnish Central Statistical Office (Tilastokeskus), contains information about designated wellbeing areas in Finland for the year 2024. Each row in the table represents a version of a row from the base table, with the versioning information captured in two additional columns: '_start_date' and '_end_date'. These columns indicate the date when the data row was extracted from the source and when a new version was extracted respectively. If '_end_date' is null, it signifies that the version of the row is the most current one. The row number in the raw data extracted from the source is recorded in the '_row_number' column, and...
Well-being Areas 2024 (Scale 1:1,000,000) - Table ComponentTSV
The table at hand belongs to a dataset collection focusing on wellbeing regions for the year 2024 at a scale of 1:1,000,000. This table, sourced from the Statistics Finland ('Tilastokeskus') website, contains information about the wellbeing regions in Finland. Each row in the table represents a distinct wellbeing region, identified by a unique combination of extraction date and row number. The extraction date reflects when the data was sourced, ensuring the data's timeliness and relevance. The columns in the table store a variety of data, including geographic details and identifiers. The geographic data, present in columns starting with 'geom_', is particularly useful for geospatial analysis. These columns contain the type of geographic shape (polygon or multipolygon), geographic...

Column Descriptions

Well-being Areas 2024 (Scale 1:1,000,000) - Table Component

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source. It's a special column that, when combined with '_row_number', uniquely identifies each row.
_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's a special column that, when combined with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains geometric data in GeoJSON format, which represents the shape of the wellbeing area.
geom_geotext	string	This column contains geometric data in text format, also representing the shape of the wellbeing area.
geom_type	string	This column specifies the type of the geometric data stored in the columns 'geom_geojson' and 'geom_geotext'. The types can be either polygon or multipolygon.
geom_centroid	string	This column contains the central point of the geometric shape of the wellbeing area in point format.
geom_center_x	double	This column contains the X-coordinate of the center point of the geometric shape of the wellbeing area.
geom_center_y	double	This column contains the Y-coordinate of the center point of the geometric shape of the wellbeing area.
gml_id	string	This column contains a unique identifier for each row of the dataset in string format.
hyvinvointialue	string	This column contains the identifiers of the wellbeing areas.
name	string	This column contains the English names of the wellbeing areas.
namn	string	This column contains the Swedish names of the wellbeing areas.
nimi	string	This column contains the Finnish names of the wellbeing areas.
vuosi	long	This column contains the year the data pertains to, represented as an integer.

Historical Record of Well-being Regions 2024 at 1:1,000,000 Scale

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It helps in identifying each row uniquely in combination with the '_row_number' column 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 the value of this column is null, it means 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 helps in identifying each row uniquely in combination with the '_start_date' column.
geom_geojson	string	This column contains the geographic data in GeoJSON format. It represents the area of the well-being region.
geom_geotext	string	This column contains the geographic data in Geotext format. It represents the area of the well-being region.
geom_type	string	This column specifies the type of the geographic data available in the 'geom_geojson' and 'geom_geotext' columns. The type could be a Multipolygon or Polygon.
geom_centroid	string	This column contains the geographic coordinates of the centroid of the area represented by the geographic data in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column contains the x-coordinate of the centroid of the area represented by the geographic data in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column contains the y-coordinate of the centroid of the area represented by the geographic data in the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This is an identifier column.
hyvinvointialue	string	This column represents a well-being region.
name	string	This column contains the English name of the well-being region.
namn	string	This column contains the Swedish name of the well-being region.
nimi	string	This column contains the Finnish name of the well-being region.
vuosi	long	This column represents the year associated with the data in the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024