1. Home
  2. Datasets
  3. Statistical Regions and ...
To download the data set, please sign up or log in

Statistical Regions and Municipalities Data Collection 2022

The dataset collection under review encompasses a series of related data tables, sourced from 'Tilastokeskus' (Statistics Finland) website, a trusted data provider based in Finland. These tables share a common theme and are organized in a user-friendly manner, with data laid out in rows and columns. The information contained within this collection is retrieved from the service interface of the Statistics Finland, ensuring reliable and accurate data. This dataset collection provides valuable insights and could be instrumental for various analytical tasks. 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 Municipalities 2022 (Scale 1:1 000 000)TSV

    The 'table__history' is a unique resource that compiles version history data of its base table rows, part of the 'tilastointialueet_kunta1000k_2022' collection. The table primarily focuses on geographic information, particularly beneficial for geospatial data analytics. It provides a detailed account of various geographic features, such as polygons and multipolygons, along with their centroid points and center coordinates, all expressed through the WGS 84 coordinate reference system, with longitude preceding latitude. The table also contains information about different areas ('kunta'), denoted with a unique identifier, alongside their respective names presented in various languages. This table also records the year ('vuosi') related to each entry. A unique feature of this table is the...

  • Municipalities 2022 (Scale 1:1,000,000) - Data TableTSV

    The table in discussion is a part of a dataset collection that contains valuable geographic and demographic data. This data is specifically relevant to municipalities in Finland for the year 2022, as indicated by the table content description 'Kunnat 2022 (1:1 1,000,000)' which translates to 'Municipalities 2022 (1:1 1,000,000)'. The table has been sourced from the website of 'Tilastokeskus' (Statistics Finland), a reliable source for comprehensive statistics in Finland. The table comprises of various columns including special ones like 'extract_date' and '_row_number'. The '_extract_date' indicates the date when the data was retrieved from the source, while the '_row_number' represents the row number in the extracted data. Together, they uniquely identify each row in the table. Other...

Column Descriptions

Municipalities 2022 (Scale 1:1,000,000) - Data Table

Column Type Comment
_extract_date date This column contains the date when the data on the row of the table was extracted from the data source. It aids in tracking the recency of the data.
_row_number long This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It helps in uniquely identifying each row.
geom_geojson string This column contains geojson data representing geographical features. It is typically used in mapping and spatial analysis.
geom_geotext string This column contains geotext data, a textual representation of geographical features. It's an alternative to the geojson data present in the 'geom_geojson' column.
geom_type string This column describes the type of the geographical feature represented in the 'geom_geojson' and 'geom_geotext' columns. It can be a polygon or a multipolygon.
geom_centroid string This column contains the centroid of the geographical feature represented. It is the center point of the feature.
geom_center_x double This column contains the x-coordinate of the center of the geographical feature. It is part of the spatial data used to plot the feature.
geom_center_y double This column contains the y-coordinate of the center of the geographical feature. It is part of the spatial data used to plot the feature.
gml_id string This column contains a unique identifier for each row, typically used in Geographical Markup Language (GML) for referencing purposes.
kunta string This column contains a code representing a municipality. It aids in identifying the geographical area to which the row data pertains.
name string This column contains the name of the municipality in English. It aids in identifying the geographical area to which the row data pertains.
namn string This column contains the name of the municipality in Swedish. This is useful for multilingual data analysis and interpretation.
nimi string This column contains the name of the municipality in Finnish. This is useful for multilingual data analysis and interpretation.
vuosi long This column contains the year pertaining to the data row. It helps in understanding the temporal context of the data.

Historical Versioning of Municipalities 2022 (Scale 1:1 000 000)

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source, serving as a starting point of a particular version of the row. For example, a row may have a start date of '2024-11-11'.
_end_date date This column contains the date when a new version of the row was extracted from the data source, marking the end of the current version. 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 data source. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson string This column contains geographical data in GeoJSON format, describing the boundaries of an area. The value can be a Polygon or a MultiPolygon.
geom_geotext string This column contains geographical data in geotext format, a textual representation of the boundaries of an area. The format can be a Polygon or a MultiPolygon.
geom_type string This column specifies the type of geographical data stored in 'geom_geojson' and 'geom_geotext'. The type can be either 'ST_POLYGON' or 'ST_MULTIPOLYGON'.
geom_centroid string This column contains the geographical point that represents the center of an area. The value is a point in a specific coordinate system.
geom_center_x double This column contains the x-coordinate of the center of an area. It is part of the geographical point that represents the center of an area.
geom_center_y double This column contains the y-coordinate of the center of an area. It is part of the geographical point that represents the center of an area.
gml_id string This string column contains a unique identifier for each row. The identifier is a combination of the year and a unique number.
kunta string This string column contains a unique code representing a specific municipality.
name string This string column contains the name of the municipality in English.
namn string This string column contains the name of the municipality in Swedish.
nimi string This string column contains the name of the municipality in Finnish.
vuosi long This integer column contains the year that the row data pertains to. For example, the value may be '2022' indicating that the row data is for that year.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024