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

Statistics Area Municipalities 2023 Dataset Collection

This dataset collection comprises a group of interrelated data tables, each organized in a structured format with rows and columns. These tables were sourced from Statistics Finland (Tilastokeskuksen), a trusted statistical organization in Finland. The content within the dataset comes from Statistics Finland's service interface (WFS), providing a reliable and accurate source of data. The dataset collection essentially serves as a comprehensive statistical resource that can be utilized for various analytical purposes. 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 2023 (1:1 000 000) - Dataset TableTSV

    The table, which belongs to the dataset collection 'tilastointialueet_kunta1000k_2023', contains a vast amount of geospatial data pertaining to municipalities in the year 2023. The data is sourced from the website of the Finnish Statistical Centre, 'Tilastokeskus'. This table includes a variety of columns with unique identifiers, geographic information, and municipality details. Key columns like 'extract_date' and '_row_number' provide information about when the data was extracted and the unique row number in the extracted data. Together, these two columns can be used to uniquely identify each row. There are also several 'geom' columns that contain rich geographic data, which can be utilized for geospatial data analytics. These columns hold information about geographical shapes and...

  • Version History of Municipalities 2023 (1:1 000 000) TableTSV

    The 'table__history' belongs to the dataset collection 'tilastointialueet_kunta1000k_2023' and serves as a historical record of its base table rows. The name suggests it contains historical data, and indeed, it manages the version history of its base table rows. The base table contents, as described by the data source, 'Tilastokeskus' (Statistics Finland), is 'Municipalities 2023 (1:1 000 000)'. This refers to the municipalities in Finland for the year 2023 at a scale of 1:1 million. The table data is organized in columns that contain various types of information. The column for row numbers, for example, holds the number of the row in the raw data extracted from the data source. Two additional columns, '_start_date' and '_end_date', are peculiar to this history table. They record the...

Column Descriptions

Municipalities 2023 (1:1 000 000) - Dataset Table

Column Type Comment
_extract_date date The date when the data on the row of the table was extracted from the data source.
_row_number long The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojson string The geometric representation of an area in GeoJSON format.
geom_geotext string The geometric representation of an area in text format.
geom_type string The type of the geometric representation used (e.g., Polygon, MultiPolygon).
geom_centroid string The geometric center of the area in POINT format.
geom_center_x double The x-coordinate (longitude) of the geometric center of the area.
geom_center_y double The y-coordinate (latitude) of the geometric center of the area.
gml_id string The unique identifier of the area.
kunta string The technical code for the municipality in the Finnish statistical system.
name string The English name of the municipality.
namn string The Swedish name of the municipality.
nimi string The Finnish name of the municipality.
vuosi long The year the data was collected.

Version History of Municipalities 2023 (1:1 000 000) Table

Column Type Comment
_start_date date This column represents the date when the row was extracted from the data source, providing a record of when the specific data entry was made.
_end_date date This column indicates the date when a new version of the row was extracted from the data source. If this column has a null value, it suggests 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. This, combined with '_start_date', uniquely identifies each row in the history table.
geom_geojson string This column contains the geometric representation of the area in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext string This column includes the geometric representation of the area in text format.
geom_type string This column specifies the type of the geometric representation, for instance, a polygon.
geom_centroid string This column holds the geometric center of the area, represented as a point.
geom_center_x double This column contains the X-coordinate of the geometric center of the area.
geom_center_y double This column contains the Y-coordinate of the geometric center of the area.
gml_id string This column holds a unique identifier for each row.
kunta string This column contains a unique identifier code for the municipality.
name string This column contains the name of the municipality in English.
namn string This column contains the name of the municipality in Swedish.
nimi string This column contains the name of the municipality in Finnish.
vuosi long This column indicates the year the data row pertains to.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024