Statistics Area and Region Data Collection 2013

This dataset collection is sourced from the Statistics Finland ('Tilastokeskus') website, based in Finland. It comprises a group of related data tables that present a wide range of statistical data. The dataset features a service interface (WFS) provided by Statistics Finland, which delivers comprehensive and detailed statistical data. The data tables within this collection contain related data organized in a structured format, with information categorized into columns and rows for easy interpretation and analysis. Although technical in nature, the information is designed to provide a broad overview of statistical data in an accessible format. The dataset offers a valuable resource for those seeking to understand complex data patterns and trends. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions 2013 (1:1 000 000) - Data Table from Finnish Statistical Data CollectionTSV
The table is a rich collection of geospatial data pertaining to the regions in Finland, as sourced from the 'Tilastokeskus' (Statistics Finland) website. The table presents detailed information about regions defined in 2013, as indicated by the column 'vuosi'. Each row in the table represents a specific region, with unique identifiers provided by two special columns: '_extract_date', which indicates the date when the data was extracted, and '_row_number', which denotes the row number in the data extracted. The combination of these columns uniquely identifies each row. The table includes a wealth of geographic data, encoded in several different formats. Columns starting with 'geom_' contain geographic information which can be utilized for geospatial data analytics. For instance,...
Version History of Regions 2013 (Scale 1:1 000 000)TSV
The 'table__history' is a rich compilation of data, sourced from 'Tilastokeskus' (Statistics Finland), detailing the version history of its base table rows. This history table includes columns that offer a unique blend of temporal, geographical, and categorical information. The table, part of the 'tilastointialueet_maakunta1000k_2013' dataset collection, is essentially a historical record of Finnish regions as of 2013. The table's content is organized by a unique combination of '_start_date' and '_row_number', acting as a distinctive identifier for each row in this version history table. The '_start_date' denotes the date when the row was extracted from the data source, and the '_end_date' indicates when a new version of the row was extracted. If the '_end_date' value is null, it...

Column Descriptions

Regions 2013 (1:1 000 000) - Data Table from Finnish Statistical Data Collection

Column	Type	Comment
_extract_date	date	This is a special column that contains the date when the data on the row of the table was extracted from the source.
_row_number	long	This is another special column that contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson	string	The column contains geometric data in GeoJSON format, a common open standard format designed for representing simple geographical features.
geom_geotext	string	This column holds geometric data as text. The data is organized in the form of Multipolygons, which represent a specific geographic area.
geom_type	string	This column specifies the type of geometric data contained in the row. In this case, it's 'ST_MULTIPOLYGON', implying that the data represents multiple polygon shapes.
geom_centroid	string	This column contains the geographic coordinates of the centroid (geometric center) of the Multipolygon.
geom_center_x	double	This column contains the x-coordinate of the geometric center of the Multipolygon.
geom_center_y	double	This column contains the y-coordinate of the geometric center of the Multipolygon.
gml_id	string	This is a unique identifier for each row of the dataset.
maakunta	string	This column contains codes representing different regions or 'maakunta' in Finnish.
name	string	This column contains the English names of the regions.
namn	string	This column contains the Swedish names of the regions.
nimi	string	This column contains the Finnish names of the regions.
vuosi	long	This column indicates the year of the data record.

Version History of Regions 2013 (Scale 1:1 000 000)

Column	Type	Comment
_start_date	date	The date when the row was initially extracted from the data source. This field, along with '_row_number', uniquely identifies each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	This is the number of the row in the raw data extracted from the source. Together with '_start_date', it forms a unique identifier for each row in this version history table.
geom_geojson	string	This column holds the geometric data of the region in GeoJSON format, a type of open-standard file format for representing simple geographical features.
geom_geotext	string	This is the geometric data of the region in text format, often used for easier visualization of the data.
geom_type	string	The type of geometric data stored. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents a shape with multiple polygons.
geom_centroid	string	This column contains the centroid or geometric center of the region.
geom_center_x	double	The X-coordinate of the geometric center of the region.
geom_center_y	double	The Y-coordinate of the geometric center of the region.
gml_id	string	A unique identifier for each row in the table, provided by the data source.
maakunta	string	This column represents the code of the region or province in Finland.
name	string	The English name of the region or province in Finland.
namn	string	The name of the region or province in Swedish, one of the official languages of Finland.
nimi	string	The name of the region or province in Finnish, the national language of Finland.
vuosi	long	The year when the data was collected, in this case, it is 2013.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024