Statistical Area and Region Collection

This dataset collection is a comprehensive aggregation of related data tables that provide statistical information from the 'Tilastokeskus' (Statistics Finland) website. It includes a range of data tables which have been organized in column-row format for ease of analysis. The data tables in this collection provide a broad spectrum of data covering various aspects. Each table is a source of related data, and together they form a dataset collection that provides a detailed statistical overview. The data sourced from Statistics Finland is delivered through their service interface (WFS), ensuring reliable and up-to-date information. This dataset collection is valuable for anyone seeking detailed statistical data from Finland. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regional Units History (1:4 500 000) Version HistoryTSV
The 'table__history' is a historical record sourced from the Finnish website 'Tilastokeskus' (Statistics Finland). This table is part of the 'tilastointialueet_seutukunta4500k' dataset collection and provides valuable chronological data on regions (Seutukunnat) at a scale of 1:4,500,000. The table records changes over time, tracking the version history of each row from its base table. The table's contents include geographical data, names of regions, and time-bound details. The geographic coordinates in the table are presented using the WGS 84 coordinate reference system, with the axis order of longitude first, followed by latitude, making it a useful resource for geospatial data analytics. The table also comprises various columns containing the start date and row number, which...
Regional Units Statistical Data (Scale 1:4,500,000)TSV
The table originates from the 'Tilastokeskus' website, based in Finland. It holds a collection of data pertaining to regional districts, classified at a 1:4 500 000 scale. The table is part of a larger dataset, illustrating the interconnection and relevance of the data across multiple tables. The data within the table is organized into several columns, each representing a specific attribute of the regional districts. Two special columns, '_extract_date' and '_row_number', are used to uniquely identify each row. The '_extract_date' indicates the date when the corresponding data was extracted, and '_row_number' denotes the position of the row in the extraction sequence. A significant portion of the table's data is geographical, represented in columns beginning with 'geom_'. This includes...

Column Descriptions

Regional Units Statistical Data (Scale 1:4,500,000)

Column	Type	Comment
_extract_date	date	This column contains the date on which the data row was extracted from the data source. The format of the date is YYYY-MM-DD.
_row_number	long	This column contains the row number corresponding to the data extracted from the source on the date specified in the '_extract_date' column. This column, in combination with the '_extract_date' column, uniquely identifies each row.
geom_geojson	string	This column contains geometrical data in the GeoJSON format. The GeoJSON data represents various geometrical shapes, such as polygons and multipolygons.
geom_geotext	string	This column contains geometrical data in the text format. The data represents various geometrical shapes, such as polygons and multipolygons.
geom_type	string	This column contains the type of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	This column contains the coordinates of the centroid of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column contains the X-coordinate of the center of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column contains the Y-coordinate of the center of the geometrical shape represented in the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This column contains a unique identifier for each row.
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 code that represents a specific region.
vuosi	long	This column contains the year corresponding to the data row.

Regional Units History (1:4 500 000) Version History

Column	Type	Comment
_start_date	date	This column represents the date when the row was extracted from the data source. It forms a combination with '_row_number' that uniquely identifies each row in this version history table.
_end_date	date	This column represents 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 forms a unique combination with '_start_date' to identify each row in this version history table.
geom_geojson	string	This column contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographical data in text format. It provides a textual representation of the geographical data.
geom_type	string	This column identifies the type of the geographical data. It indicates whether the data is a MultiPolygon or a Polygon.
geom_centroid	string	This column contains the centroid of the geographical data. The centroid is the geometric center of a shape.
geom_center_x	double	This column represents the X-coordinate of the geometric center of a shape.
geom_center_y	double	This column represents the Y-coordinate of the geometric center of a shape.
gml_id	string	This column contains the unique identifier of the data row.
name	string	This column contains the English name of the area.
namn	string	This column contains the name of the area in the local language.
nimi	string	This column contains the name of the area in another local language.
seutukunta	string	This column contains a unique code representing a specific region in Finland.
vuosi	long	This column represents the year when the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024