2021 Statistics Area Data Collection for Provinces

The dataset collection in focus compiles related data tables that provide valuable information drawn from the Statistics Centre's service interface (WFS). Originating from 'Tilastokeskus' (Statistics Finland) in Finland, these tables form a complete group, each contributing a distinct set of data to the comprehensive collection. This type of organized system ensures that the data gathered is not only relevant but also easily accessible and interpretable. The collective information within these tables can serve a variety of research and analytical purposes, making it a versatile and useful resource for data-driven endeavours. 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 of Regions 2021 (1:4 500 000)TSV
The 'table__history' is a history table that tracks the version history of its base table rows, focusing on regions in Finland. The contents of the table are sourced from 'Tilastokeskus' (Statistics Finland), and includes data such as 'Regions 2021 (1:4 500 000)'. The table is part of a larger dataset collection titled 'tilastointialueet_maakunta4500k_2021'. The table is comprised of various columns that contain precise information about each data entry. For instance, each row in the table is uniquely identified by a combination of its start date, represented by '_start_date' column, and the row number, represented by '_row_number' column. The '_start_date' column indicates when the row was first extracted from the data source, while '_end_date' signifies when a new version of the row...
Provinces 2021 - Detailed Geographical InformationTSV
The table under discussion is part of a dataset collection focusing on regional statistical areas in Finland. The table itself is named 'Regions 2021 (1:4 500 000)', providing a comprehensive view of Finland's regions for the year 2021. This table is sourced from the Finnish Statistics Bureau website ('Tilastokeskus') and offers a rich collection of information for each region, including geographic and demographic data. The table contains columns that cater to a variety of data points. Key among these are '_extract_date' and '_row_number'. The former provides the date when the data row was extracted, and the latter offers a unique identifier for each data row based on the extraction date. This combination ensures each row in the table is distinct and easily identifiable. Moving on to...

Column Descriptions

Provinces 2021 - Detailed Geographical Information

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It helps in tracking when the specific data was fetched for reference or analysis.
_row_number	long	This column contains the row number in the data extracted from the source on the specified extract date. It is part of a unique identifier for each row when coupled with the '_extract_date'.
geom_geojson	string	This column stores the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographic data in text format. It represents the shape of a geographic feature.
geom_type	string	This column indicates the type of the geographic data. For example, it can be a point, line, or polygon.
geom_centroid	string	This column contains the geographic coordinate of the centroid of the geometric shape. It represents the center point of the geographic feature.
geom_center_x	double	This column represents the X-coordinate of the geographic center of the feature. It's part of the geographic coordinate system.
geom_center_y	double	This column represents the Y-coordinate of the geographic center of the feature. It's also part of the geographic coordinate system.
gml_id	string	This column contains identifiers that are used to link geographic features to their descriptions.
maakunta	string	This column contains unique identifiers for regions in Finland.
name	string	This column contains the English names of the regions in Finland.
namn	string	This column contains the Swedish names of the regions in Finland.
nimi	string	This column contains the Finnish names of the regions in Finland.
vuosi	long	This column indicates the year the data row was collected or relevant for.

Historical Version Records of Regions 2021 (1:4 500 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, for instance '2024-11-11'.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version of the row.
_row_number	long	The number of the row in the raw data extracted from the data source. This number, together with the '_start_date', uniquely identifies each row in the history table.
geom_geojson	string	Contains geographical information in GeoJSON format, which can represent simple geographical features, along with their nonspatial attributes.
geom_geotext	string	Contains geographical coordinates in a text format, which can represent different geographical features.
geom_type	string	The type of geographic data stored in the 'geom_geojson' and 'geom_geotext' columns, such as 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid	string	The calculated center point (centroid) of the geographical polygon or multipolygon.
geom_center_x	double	The X coordinate of the calculated center point of the geographical polygon or multipolygon.
geom_center_y	double	The Y coordinate of the calculated center point of the geographical polygon or multipolygon.
gml_id	string	A unique identifier for each row in the table, such as 'maakunta4500k_2021.15'.
maakunta	string	A code representing a region in Finland, for example '16', '01', '18', or '07'.
name	string	The English name of the region represented by the 'maakunta' code, such as 'Central Ostrobothnia', 'Uusimaa', 'Kainuu', or 'Päijät-Häme'.
namn	string	The Swedish name of the region represented by the 'maakunta' code, such as 'Mellersta Österbotten', 'Nyland', 'Kajanaland', or 'Päijänne-Tavastland'.
nimi	string	The Finnish name of the region represented by the 'maakunta' code, such as 'Keski-Pohjanmaa', 'Uusimaa', 'Kainuu', or 'Päijät-Häme'.
vuosi	long	The year when the data was collected, for example '2021'.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024