1. Home
  2. Datasets
  3. 2019 Statistical Area Data ...
To download the data set, please sign up or log in

2019 Statistical Area Data Collection

The dataset collection in question comprises of related data tables obtained from the 'Tilastokeskus' (Statistics Centre) website in Finland. These tables are organized into rows and columns to represent interrelated data effectively. The content of the dataset is sourced from Tilastokeskuksen palvelurajapinta (Statistics Centre's Service Interface), indicating its high reliability. It's aimed to provide comprehensive statistical data for users interested in Finnish demographics, economy, environment, or other research areas. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Municipalities 2019 (Scale 1:4 500 000) from Dataset Collection 'tilastointialueet_kunta4500k_2019'TSV

    The table is a part of a larger dataset collection that focuses on municipal data from 2019 on a scale of 1:4,500,000. This data, sourced from 'Tilastokeskus' (Statistics Finland), provides a unique insight into the geographic and demographical landscape of Finland. The table incorporates a wide range of data, all of which can be utilized for different data analytics tasks. For instance, the geographic information contained in columns starting with 'geom_' can be used for geospatial data analytics, with coordinates presented using the WGS 84 reference system. This includes longitude first, followed by latitude. Furthermore, the table includes a pair of special columns, '_extract_date' and '_row_number', which offer detailed information about the extraction process of the data. The...

  • Version History of Municipalities 2019 (1:4 500 000) TableTSV

    The 'table__history' is a comprehensive and informative dataset that originates from the 'Tilastokeskus' website in Finland. This history table is part of the larger dataset collection and serves as a version history of its base table rows. It contains the detailed history of municipalities in 2019 at a scale of 1:4 500 000. It has preserved the entire transition of municipalities, tracking changes over time. Each row in the table represents a unique timestamp of the data extraction, presented by the '_start_date' and '_row_number' columns. These two columns together form a unique identifier for each row in the table. The '_end_date' column indicates when a new version of the row was extracted, with a null value signifying the most recent version. The dataset contains several columns...

Column Descriptions

Municipalities 2019 (Scale 1:4 500 000) from Dataset Collection 'tilastointialueet_kunta4500k_2019'

Column Type Comment
_extract_date date This column records the date when the data on the row was extracted from the source. This can be useful for tracking when changes or updates were made to 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 serves as a unique identifier for each row.
geom_geojson string This column contains geographical data in the GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext string This column contains geographical data in text format. It is similar to the 'geom_geojson' column, but the data is represented as text.
geom_type string This column indicates the type of geometry represented in the 'geom_geojson' and 'geom_geotext' columns. In the given sample, the type of geometry is 'ST_MULTIPOLYGON', which represents a shape formed by multiple polygons.
geom_centroid string This column records the geographical centroid of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns. The centroid is the geographical center point of the shape.
geom_center_x double This column records the x-coordinate of the geographical center of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y double This column records the y-coordinate of the geographical center of the geometry represented in the 'geom_geojson' and 'geom_geotext' columns.
gml_id string This column contains a unique identifier for the geographical data in the row. The identifier is in the form of a string.
kunta string This column contains a string-based identifier for a municipality in Finland.
name string This column contains the English name of the municipality represented in the row.
namn string This column contains the Swedish name of the municipality represented in the row.
nimi string This column contains the Finnish name of the municipality represented in the row.
vuosi long This column contains the year of the data. It is a numerical value in the format of 'Integer64'.

Version History of Municipalities 2019 (1:4 500 000) Table

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It is a part of a unique identifier for every row in this version history table, along with '_row_number'.
_end_date date The '_end_date' column contains the date when a new version of the row was extracted from the data source. If its value is null, it indicates that the row version is the most recent one.
_row_number long The '_row_number' column holds the number of the row as it appeared 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 The 'geom_geojson' column contains the geometric information of the area represented in GeoJSON format, a widely used standardized format for encoding a variety of geographic data structures.
geom_geotext string The 'geom_geotext' column stores the geometric information of the area represented in a text format.
geom_type string The 'geom_type' column describes the type of the geometric figure, in this case, it is a multipolygon.
geom_centroid string The 'geom_centroid' column contains the coordinates of the geometric center (centroid) of the area represented.
geom_center_x double The 'geom_center_x' column represents the X-coordinate (longitude) of the geometric center of the area.
geom_center_y double The 'geom_center_y' column represents the Y-coordinate (latitude) of the geometric center of the area.
gml_id string The 'gml_id' column contains the unique identifier of the area based on the source data.
kunta string The 'kunta' column holds the municipal code of the area.
name string The 'name' column contains the name of the area in English.
namn string The 'namn' column contains the name of the area in Swedish.
nimi string The 'nimi' column stores the name of the area in Finnish.
vuosi long The 'vuosi' column contains the year of the data.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024