Statistical Region Data Collection 2020

This dataset collection contains tables sourced from the Statistics Finland (Tilastokeskus) website. The tables in the collection encompass a range of related data with respect to statistical areas in Finland. The source describes the data as 'Statistical Service Interface (WFS)', indicating that it pertains to statistical information accessed through a web feature service. The data is organized in an easy-to-understand table format with distinct rows and columns, making it simple to interpret and analyze. 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 Versioning of Finnish Regions 2020 (1:1 000 000)TSV
The history table, part of a dataset collection, maintains a record of version history for its base table rows. It comprises a rich set of columns, including those related to geographic information which is particularly useful for geospatial analytics. This spatial data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table contains data from the 'Regions 2020 (1:1 000 000)' base table, which gives information about various regions. For each region, data such as the region's name in different languages and geographic information in various formats are captured. The geospatial data, for instance, includes the region's shape represented in geojson and geotext formats, the type of the geographic shape, and the...
Provinces 2020 - Detailed Geographical Dataset (1:1 000 000 Scale)TSV
The 'table' is part of the larger dataset collection 'tilastointialueet_maakunta1000k_2020'. It is a structured collection of data that provides a snapshot of regions in Finland for the year 2020, sourced from the Finnish statistical agency, 'Tilastokeskus'. The table contains a variety of information, including geographic data and unique identifiers for each region. Each row in the table represents a specific region, with unique attributes recorded in various columns. The geographic information is captured using the WGS 84 coordinate reference system, where longitude comes first, followed by latitude. This allows for detailed geospatial data analysis, such as understanding regional boundaries and calculating centroid points. In addition to the geographic information, the table also...

Column Descriptions

Provinces 2020 - Detailed Geographical Dataset (1:1 000 000 Scale)

Column	Type	Comment
_extract_date	date	This column represents the date when the data on the respective row was extracted from the source. It is a special column that, in combination with '_row_number', uniquely identifies each row in the table.
_row_number	long	This column provides the row number in the data as it was extracted from the source. This is a special column that, along with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column represents the geographical shape of the Finnish region in geojson format. Geojson is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column provides the geographical shape of the respective Finnish region in geotext format, which is a textual representation of the geographical data.
geom_type	string	This column indicates the geometric data type of the region's geographic shape, which could be either 'ST_MULTIPOLYGON' for multiple polygons or 'ST_POLYGON' for a single polygon.
geom_centroid	string	This column represents the geographical center point of the region in the form of a 'POINT' with coordinates.
geom_center_x	double	This column contains the x-coordinate of the geographical center point of the region.
geom_center_y	double	This column contains the y-coordinate of the geographical center point of the region.
gml_id	string	This column contains a unique identifier for each row, following the format 'maakunta1000k_2020.[row_number]'.
maakunta	string	This column contains a code representing the Finnish region.
name	string	This column contains the English name of the Finnish region.
namn	string	This column contains the Swedish name of the Finnish region.
nimi	string	This column contains the Finnish name of the region.
vuosi	long	This column represents the year for which the data is relevant. In the provided dataset, all the data is for the year 2020.

Historical Versioning of Finnish Regions 2020 (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It is a key part of the combination that uniquely identifies each row in the version history table.
_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 indicates 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 original data source. It forms part of the unique identifier for each row in this version history table.
geom_geojson	string	This column contains geographical data in the GeoJSON format, representing various geographical structures such as polygons and multipolygons.
geom_geotext	string	This column contains geographical data in a text format, representing various geographical structures such as polygons and multipolygons.
geom_type	string	This column specifies the type of geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns, such as polygon or multipolygon.
geom_centroid	string	This column contains the geographical coordinates of the centroid of the geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical structure represented in the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This column contains a unique identifier for each row, provided by the data source.
maakunta	string	This column contains an identifier for the region, provided by the data source.
name	string	This column contains the English name of the region represented by the row.
namn	string	This column contains the Swedish name of the region represented by the row.
nimi	string	This column contains the Finnish name of the region represented by the row.
vuosi	long	This column contains the year of the data represented by the row. The values are in integer format.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024