Statistics Interface Service - Regional Data Collection 2024

This dataset collection comprises a group of interrelated data tables that have been sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The data tables contain detailed and organized information, carefully structured in columns and rows for ease of interpretation. The collection's primary focus is to provide comprehensive statistical data related to different regions across the country. This dataset serves as a valuable resource for researchers and analysts who require in-depth knowledge about various areas in Finland, especially those looking at trends and patterns up until the year 2024. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Provinces 2024 - Geospatial Data (1:1 000 000 Scale)TSV
The table under consideration belongs to a dataset collection that focuses on regional statistics projected for the year 2024 in Finland. The data in the table comes from 'Tilastokeskus' (Statistics Finland), a reliable source of statistical information in the country. The table contains a rich set of information, with columns providing various types of data. Two special columns, '_extract_date' and '_row_number', play a crucial role in identifying each row uniquely. The '_extract_date' column indicates the date when the specific row of data was extracted, while '_row_number' marks the order of the row in the data extracted on that specific date. The table is particularly useful for geospatial data analytics, with several columns beginning with 'geom_' containing geographical...
Provinces 2024 - Version History (1:1 000 000)TSV
The 'table__history' is a historical dataset that stores the version history of its base data rows. It is a part of the 'tilastointialueet_maakunta1000k_2024' dataset collection. This table is sourced from 'Tilastokeskus' (Statistics Finland) and contains a record of provinces as projected for the year 2024 at a 1:1,000,000 scale. It includes geographic information such as polygons and multipolygons, centroid points, and center coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Such geospatial data can be utilized for analytics such as mapping, spatial distribution analysis, and trend analysis. The table also includes unique identifiers for each row, and start and end dates, which...

Column Descriptions

Provinces 2024 - Geospatial Data (1:1 000 000 Scale)

Column	Type	Comment
_extract_date	date	This column indicates the date when the data row was extracted from the data source.
_row_number	long	This column provides the row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojson	string	This column contains geospatial data in GeoJSON format, a popular format for encoding geographic data structures.
geom_geotext	string	This column contains geospatial data in text format.
geom_type	string	This column defines the type of geometric data contained in the 'geom' columns. For instance, it could be a Point, LineString, Polygon, etc.
geom_centroid	string	This column contains the centroid (geometric center) of the shape defined in the 'geom' columns.
geom_center_x	double	This column represents the X coordinate for the geometric center point of the shape defined in the 'geom' columns.
geom_center_y	double	This column represents the Y coordinate for the geometric center point of the shape defined in the 'geom' columns.
gml_id	string	This is a unique identifier for each row in the table.
maakunta	string	This column contains the code for the region in question.
name	string	This column contains the English name of the region in question.
namn	string	This column contains the Swedish name of the region in question.
nimi	string	This column contains the Finnish name of the region in question.
vuosi	long	This column contains the year for which the data is relevant.

Provinces 2024 - Version History (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was first extracted from the data source. The date format is YYYY-MM-DD (e.g., 2024-11-11).
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value is null, it denotes that the row is the most recent version.
_row_number	long	This column contains the number of the row as extracted from the raw data source. It helps in uniquely identifying each row in combination with the '_start_date' column.
geom_geojson	string	This column contains geographical data in the GeoJSON format, which represents simple geographical features with their non-spatial attributes.
geom_geotext	string	This column contains geographical data in the geotext format. It represents the geographical location of the area using coordinates.
geom_type	string	This column indicates the type of geographical data stored in the row, such as 'Polygon' or 'MultiPolygon'.
geom_centroid	string	This column contains the centroid or geometric center of the area represented in the row.
geom_center_x	double	This column contains the X-coordinate of the center of the geographical area represented in the row.
geom_center_y	double	This column contains the Y-coordinate of the center of the geographical area represented in the row.
gml_id	string	This column contains the unique ID for each row, typically following a specific naming convention (e.g., 'maakunta1000k_2024.9').
maakunta	string	This column contains a code representing the region or 'maakunta' in Finnish.
name	string	This column contains the name of the region in English (e.g., 'South Savo').
namn	string	This column contains the name of the region in Swedish (e.g., 'Södra Savolax').
nimi	string	This column contains the name of the region in Finnish (e.g., 'Etelä-Savo').
vuosi	long	This column contains the year related to the data in each row (e.g., 2024).

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024