Statistical Areas and Well-being Regions Dataset Collection

The dataset collection under consideration is a compilation of significant data tables, all of which are closely related. Originating from the Statistics Centre's web service interface in Finland, known as 'Tilastokeskus', the collection includes a couple of tables that are rich in information. These tables contain data that are meticulously organized in a table format, which includes rows and columns for easy comprehension. One table provides a future perspective by showcasing data projected for the year 2024, thereby offering invaluable insights for forward-thinking analysis. However, both tables collectively contribute to providing a comprehensive understanding of the well-being area with a significant population of 4500 thousand, thereby making it an invaluable resource for analysts and researchers alike. 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 Welfare Regions (1:4 500 000)TSV
The 'table__history' is a version history table that captures the evolution of its base table over time. It's a part of the dataset collection associated with the theme of well-being areas at a 1:4 500 000 scale. This dataset collection is sourced from 'Tilastokeskus' (Statistics Finland) in Finland. The table consists of various columns capturing different facets of the data. For instance, it includes columns that provide unique identifiers for each row, and two special columns capture the version history of each row. One column records the date when the row was extracted from the source, while another column records when a new version of the same row was extracted. This allows tracking of the most recent version of the row, which is indicated by a null value in the column capturing...
Wellbeing Areas at Scale 1:4,500,000 - Data TableTSV
The table in question, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), contains information related to the 'Hyvinvointialueet' which translates to 'Wellbeing Areas' at a scale of 1:4 500 000. It is a part of a larger dataset collection focusing on wellbeing areas. This table carries a set of columns showcasing various types of data. Two of these columns, '_extract_date' and '_row_number', are used to provide unique identification for each row. The '_extract_date' indicates the date when the data was extracted, while the '_row_number' assigns a unique number to each row of data from the source on the specified extract date. Several columns in this table provide geographic information and are prefixed with 'geom_'. These columns include 'geom_geojson',...

Column Descriptions

Wellbeing Areas at Scale 1:4,500,000 - Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. It is one of the special columns in the table and helps in identifying the time of data extraction.
_row_number	long	This special column contains the row number of the data extracted from the source. Together with '_extract_date', it uniquely identifies each row in the table.
geom_geojson	string	This column contains geometric data in GeoJSON format. This data represents the geographic boundaries of the well-being areas.
geom_geotext	string	This column features geometric data in text format. Similar to 'geom_geojson', it represents the geographic boundaries of the well-being areas.
geom_type	string	This column indicates the type of geometric data represented in the 'geom_geojson' and 'geom_geotext' columns, such as multipolygon or polygon.
geom_centroid	string	This column contains the geographic point that represents the centroid or the geometric center of the well-being area.
geom_center_x	double	This column represents the X-coordinate of the geometric center of the well-being area.
geom_center_y	double	This column represents the Y-coordinate of the geometric center of the well-being area.
gml_id	string	This column contains a unique identifier for each well-being area. It is a string value.
hyvinvointialue	string	This column contains the identifier for the well-being area. It is a string value.
name	string	This column holds 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 features the name of the well-being area in Finnish.
vuosi	long	This column records the year of the data. It is an integer value.

Version History of Welfare Regions (1:4 500 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify each version of the row in this history table.
_end_date	date	It contains the date when a new version of the row was extracted. If its 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. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains geometric data in the GeoJSON format, which represents various geographical features.
geom_geotext	string	This column contains geometric data as text, offering another way to represent the geographical features.
geom_type	string	This column indicates the type of the geometric feature represented, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column contains the centroid point of the geometric feature, which is the center point of the shape.
geom_center_x	double	This column contains the x-coordinate of the center point of the geometric feature.
geom_center_y	double	This column contains the y-coordinate of the center point of the geometric feature.
gml_id	string	This column contains the GML ID, which is a unique identifier for each entry.
hyvinvointialue	string	This column contains the wellbeing area code, which is a unique identifier for each wellbeing area.
name	string	This column contains the English name for the wellbeing area.
namn	string	This column contains the Swedish name for the wellbeing area.
nimi	string	This column contains the Finnish name for the wellbeing area.
vuosi	long	This column contains the year associated with each record.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024