1. Home
  2. Datasets
  3. 2021 Statistical Areas - ...
To download the data set, please sign up or log in

2021 Statistical Areas - Regional Data Collection

The dataset collection contains grouped and organized data tables sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The data in this collection is accessed through the 'Tilastokeskuksen palvelurajapinta' (Statistics Finland service interface). The tables within this dataset collection contain related and systematically arranged data, providing a comprehensive and detailed overview of the subject matter. Please note that the data tables may consist of one or several related tables, providing a broad range of information in a structured format. 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 for 'Regions 2021' Dataset TableTSV

    The 'table__history' is a rich source of geographic and historical data. It's part of a larger dataset collection designed to provide detailed information about regions in Finland. This specific table serves a key role in providing the version history of its base table rows, preserving a chronological record of the data. The dataset was originally sourced from the Finnish website, 'Tilastokeskus' (Statistics Finland), a reliable authority for data on the country's regions. The contents of the table are diverse and comprehensive. It includes a unique identification for each row, achieved through a combination of the row number and the date the row was extracted. This ensures that each version of the row is distinct and traceable in the table's history. A key aspect of the table is its...

  • Regions 2021 (Scale 1:1 000 000) - Data Table from 2021 Finnish Statistical CollectionTSV

    The table under discussion is a part of a dataset collection that holds related data tables. This particular table is a comprehensive collection of data, organized in rows and columns, that provides information about the regions in Finland in 2021, as per the information sourced from 'Tilastokeskus' (Statistics Finland). This information includes the name of the region in various languages, the region's unique identifier, and the year of data collection. All geographic coordinates presented in the table follow the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The table also includes special columns like 'extract_date', which denotes the date when the data for a particular row was extracted, and '_row_number', which indicates the row...

Column Descriptions

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

Column Type Comment
_extract_date date This column specifies the date when the data on the row was extracted from the source. It helps track the freshness of the data.
_row_number long This column represents the row number in the data extracted from the source on a specific extract date. It helps uniquely identify each row in combination with '_extract_date'.
geom_geojson string This column contains the geometric data of the region in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext string This column stores the geometric data of the region as text, which can be used for visualization and spatial analysis.
geom_type string This column indicates the type of geometric data stored, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid string This column contains the coordinates of the centroid (geometric center) of the region.
geom_center_x double This column represents the X-coordinate of the geometric center of the region.
geom_center_y double This column represents the Y-coordinate of the geometric center of the region.
gml_id string This column provides a unique identifier for each row, most likely related to the region and year.
maakunta string This column contains an identifier for the region or province.
name string This column holds the name of the region or province in English.
namn string This column stores the name of the region or province in Swedish.
nimi string This column contains the name of the region or province in Finnish.
vuosi long This column specifies the year of the data.

Historical Version Records for 'Regions 2021' Dataset Table

Column Type Comment
_start_date date The date when the row was extracted from the data source, which helps in tracking the version history.
_end_date date The date when a newer version of the row was extracted. If this is null, it indicates that the row is the most recent version.
_row_number long The number of the row as it appears in the raw data from the data source. This, along with '_start_date', uniquely identifies each row in the version history.
geom_geojson string A JSON representation of the geographical shape of the region.
geom_geotext string A textual representation of the geographical shape of the region.
geom_type string The type of geographical shape (e.g., multipolygon or polygon).
geom_centroid string The coordinates of the center point of the geographical shape.
geom_center_x double The X-coordinate of the center point of the geographical shape.
geom_center_y double The Y-coordinate of the center point of the geographical shape.
gml_id string A unique identifier for the row.
maakunta string A code representing the region.
name string The English name of the region.
namn string The name of the region in Swedish.
nimi string The name of the region in Finnish.
vuosi long The year when the data was recorded.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024