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

2020 Statistical Area Data Collection

This dataset collection is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The data tables contain information from the statistical service interface, known as the 'WFS', provided by Tilastokeskus. The dataset collection comprises one or more tables, each housing related data organized in a table format with respective columns and rows. The contents of the collection are meticulously updated and maintained, ensuring accurate and useful data for research and analysis. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • History of Municipalities 2020 (Scale 1:4 500 000) Version ChangesTSV

    The 'table__history' is a rich source of data, part of the dataset collection 'tilastointialueet_kunta4500k_2020'. This table primarily serves as a historical record, tracking the changes and updates made to its base table over time. This is achieved through the use of special columns that record the chronological details of each entry, allowing for a detailed view of the data evolution. The table is sourced from the Statistical Centre's (Tilastokeskus) website in Finland. The data contained within the table is a reflection of the Municipalities in 2020 at a scale of 1:4 500 000. It includes various features such as unique identifiers, names of municipalities, and the year of data collection. Each row is uniquely identified by the combination of the start date of the data extraction...

  • Municipalities 2020 (Scale 1:4,500,000) - Dataset TableTSV

    The table, which is a part of a larger dataset collection, contains information about different municipalities in Finland. The data is sourced from the 'Tilastokeskus' website, also known as the Statistic Centre of Finland. The table represents data related to the year 2020, showcasing each municipality's unique identifier, name, and geographical data. This geographical data includes various forms of presentation, such as GeoJSON, Geotext, and centroid points, all represented using the WGS 84 coordinate reference system. Each row in the table is uniquely identified by an extract date and a row number, marking when the specific data was extracted from the source. This table can be highly useful in data analytics, especially in spatial analysis. For instance, it can provide insights into...

Column Descriptions

Municipalities 2020 (Scale 1:4,500,000) - Dataset Table

Column Type Comment
_extract_date date This column captures the date when the data row was extracted from the source. It plays a crucial role in identifying each row uniquely in combination with the '_row_number' column.
_row_number long This column represents the row number in the data extracted from the source. Along with '_extract_date', it helps in unique identification of each row.
geom_geojson string This column contains geometric data in GeoJSON format, which is a format for encoding geographic data structures.
geom_geotext string This column stores geometric data as text. It complements the 'geom_geojson' column by providing a textual representation of geographical data.
geom_type string This column specifies the type of geometric shape represented by the data in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid string This column provides the centroid of the geometric shape represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x double This column contains the x coordinate of the geometric shape's center, providing a more precise location reference.
geom_center_y double This column contains the y coordinate of the geometric shape's center, complementing the 'geom_center_x' column.
gml_id string This column contains an identifier for the row. The identifier is unique to the dataset and is used for reference and indexing purposes.
kunta string This column contains a string representation of the municipality code.
name string This column holds the name of the municipality in English.
namn string This column holds the name of the municipality in a different language, possibly local or regional.
nimi string This column holds another version of the municipality name. The difference between 'name', 'namn', and 'nimi' could be due to regional language variations.
vuosi long This column contains an integer representing the year associated with the row data.

History of Municipalities 2020 (Scale 1:4 500 000) Version Changes

Column Type Comment
_start_date date The date this version of the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in the version history table 'table__history'.
_end_date date The date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most current version.
_row_number long The number of the row in the raw data extracted from the Statistics Finland (Tilastokeskus) data source. Together with '_start_date', it uniquely identifies each row in the version history table 'table__history'.
geom_geojson string Represents the geometric shape of the area related to the row in GeoJSON format.
geom_geotext string Represents the geometric shape of the area related to the row in a text format.
geom_type string Specifies the type of geometric shape that is represented in the 'geom_geojson' and 'geom_geotext' columns. In this case, the type is ST_POLYGON, which refers to a polygon shape.
geom_centroid string Represents the centroid (geometric center) of the area related to the row.
geom_center_x double Specifies the x-coordinate of the centroid of the area related to the row.
geom_center_y double Specifies the y-coordinate of the centroid of the area related to the row.
gml_id string Uniquely identifies each row in the base table from the Statistics Finland (Tilastokeskus) data source.
kunta string The code of the municipality related to the row.
name string The name of the municipality associated with the row in English.
namn string The name of the municipality associated with the row in Swedish.
nimi string The name of the municipality associated with the row in Finnish.
vuosi long The year related to the data of the row.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024