Statistical Areas Regional Grouping 2024 Data Collection

This dataset collection is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The tables provide an array of valuable data from the Statistics Finland's service interface. Each table in this collection is meticulously organized into columns and rows, presenting a wealth of data in an easily readable format. This dataset collection offers a comprehensive view of specific subjects, allowing for in-depth analysis and research. 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 Version Records of Regional Units 2024 (1:1 000 000)TSV
The 'table__history' is a historical record of the 'Regions 2024 (1:1 000 000)' table, sourced from the Statistics Finland (Tilastokeskus) website. This table provides a rich set of data, including geographical and temporal information, which can be utilized for various purposes in data analytics. The table contains version history of its base table rows, which could be used to track changes over time in different regions. The table includes geographic information, such as the type of geometry, geographical text, geojson, centroid, and center coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This geospatial data could be employed in geographical information systems (GIS) analytics...
Regional Units 2024 (Scale 1:1,000,000) - Data TableTSV
The table in question is a part of a larger dataset collection, which is primarily related to the regional statistics of Finland. The dataset collection references the planned regional divisions for the year 2024, as stated in the Finish Statistics Bureau's website, 'Tilastokeskus'. The table contains various columns which include geospatial data and other related information about different regions. The columns in this table contain information such as the date of data extraction, the row number, geometric information in various formats, the names of the regions in different languages, and the year associated with the data. More specifically, the 'geom_' columns contain geographic information which can be crucial for geospatial data analytics. They represent geospatial data in...

Column Descriptions

Regional Units 2024 (Scale 1:1,000,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 data source. It helps to identify when the data was fetched.
_row_number	long	This column contains the row number of the data extracted from the source on the extract date specified by the column '_extract_date'. Each number is unique and helps to identify each row.
geom_geojson	string	This column contains the geospatial data in GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext	string	This column contains the geospatial data in text format. It can be used to visually represent the geographic area.
geom_type	string	This column indicates the type of the geographical data. In this table, it is 'ST_POLYGON' indicating that the geographical data represents a polygon.
geom_centroid	string	This column provides the centroid of the geographical data, which is the arithmetic mean position of all the points in the shape.
geom_center_x	double	This column provides the X-coordinate of the center of the geographical data.
geom_center_y	double	This column provides the Y-coordinate of the center of the geographical data.
gml_id	string	This column provides a unique identifier for each row of data.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in Swedish.
nimi	string	This column contains the name of the region in Finnish.
seutukunta	string	This column contains a coded value representing the region.
vuosi	long	This column contains the year associated with the data in the row. In this dataset, it is the year 2024.

Historical Version Records of Regional Units 2024 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when each row was extracted from the data source. It, together with the '_row_number', uniquely identifies each row in the table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number	long	This column contains the row number in the raw data extracted from the data source. It is part of the unique identifier for each row when combined with '_start_date'.
geom_geojson	string	This column contains geometric data of the areas in the GeoJSON format, a widely used format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geographic data in a text format.
geom_type	string	This column indicates the type of the geometric data, whether it's a polygon or a multipolygon.
geom_centroid	string	This column contains the geometric center (centroid) of the area.
geom_center_x	double	This column represents the x-coordinate of the geometric center of the area.
geom_center_y	double	This column represents the y-coordinate of the geometric center of the area.
gml_id	string	This column contains a unique identifier for each row.
name	string	This column contains the English name of the area.
namn	string	This column contains the name of the area in another language.
nimi	string	This column contains the name of the area in another language.
seutukunta	string	This column contains a specific code representing the area.
vuosi	long	This column contains the year of the data.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024