Provinces 2019 (1:4,500,000) - Table from the Finnish Statistics Dataset Collection

To download the data set, please sign up or log in

Click here for a data sample

The table in question encompasses data pertaining to the Finnish regions as of 2019. This includes both geographic and informational data about different parts of Finland. The data is sourced from the Finnish statistical authority, 'Tilastokeskus'.

The table contains geographic data that can be used for geospatial data analytics. Specifically, it includes detailed geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This geographic data is held within multiple columns, including those that hold geotext, centroids, and center points.

Additionally, the table holds unique identifiers for each region, as well as names in different languages including Finnish, Swedish, and English. This allows for multi-lingual analysis and can be used to display data in the end users' native languages.

Two special columns, '_extract_date' and '_row_number', are also present in this table. '_extract_date' contains the date when the data on the row of the table was extracted from the data source and '_row_number' contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of these columns uniquely identifies each row.

This data could be utilized in many ways in data analytics. For example, the geographic data could be used to create detailed maps of Finland's regions, with the ability to overlay additional data points from other sources. The language-specific names can be used to build multi-lingual data visualizations or to cross-reference with other multi-lingual data sources. Finally, the extract date and row number could be used to track changes in the data over time, or to ensure data integrity during analysis.

Field Descriptions

Name Data type Description
_extract_datedateThe date when the data on the row was extracted from the data source. This column, in conjunction with '_row_number', uniquely identifies each row.
_row_numberlongThe row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in conjunction with '_extract_date', uniquely identifies each row.
geom_geojsonstringThe geographical data of the region in GeoJSON format.
geom_geotextstringThe geographical data of the region in geotext format.
geom_typestringThe type of the geographical data.
geom_centroidstringThe centroid of the geographical data.
geom_center_xdoubleThe x-coordinate of the center of the geographical data.
geom_center_ydoubleThe y-coordinate of the center of the geographical data.
gml_idstringThe unique identifier of the row in the dataset.
maakuntastringThe region identifier.
namestringThe English name of the region.
namnstringThe name of the region in Swedish.
nimistringThe name of the region in Finnish.
vuosilongThe year of the data.

No sample for this dataset

Additional Information

Last updated November 11, 2024
Created November 11, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id17ff6df0-e8bc-483b-af3d-7285332f11e3
Package ide51a3a4c-9147-4ab7-8d86-490497dfd885
Revision idb2b329d1-3c28-437b-87b6-29af2fc203e1
Stateactive
Tabletilastointialueet_maakunta4500k_2019__table