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

2018 Statistical Regional Dataset Collection

This dataset collection is a compilation of related data tables pertaining to statistical regions, sourced from the 'Tilastokeskus' website, based in Finland. The contents of the tables are obtained via the Statistical Office's service interface (WFS), providing valuable data about the specific region. The collection consists of several tables, each presenting data in a structured format of rows and columns, making it easy to identify relationships and draw insights. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

  • Regional Units 2018 (Scale 1:4,500,000) - Dataset TableTSV

    The table is part of a larger dataset collection and includes geographically oriented data, specifically focused on the regions of Finland in 2018, as indicated by the Finnish Statistical Bureau (Tilastokeskus). The data in the table includes information about specific regions, each identified by unique codes, names presented in multiple languages, and the year to which the data pertains. The geographic information is represented in several formats, including GeoJSON, GeoText, and geometric types, along with the geographic center coordinates. This geospatial data is presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. The data in the table is further organized by a unique extract date and row number, which together provide a unique...

  • Version History of Regional Units 2018 (Scale 1:4 500 000)TSV

    The 'table__history' is a historical dataset that encapsulates the version history of its base data. This table is a part of the larger dataset collection, 'tilastointialueet_seutukunta4500k_2018'. It provides a meticulous record of how the data in the base table has evolved over time. This is particularly useful for keeping track of changes and spotting trends, which are crucial in data analytics. The table includes columns that provide geographic information, which can be exploited for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. In addition to the base table columns, the history table includes two special columns: a start date and an end date. These...

Column Descriptions

Regional Units 2018 (Scale 1:4,500,000) - Dataset Table

Column Type Comment
_extract_date date This column contains the date when the data on the row was extracted from the source.
_row_number long This column contains the row number of the data extracted from the source on the extract date specified by the column '_extract_date'.
geom_geojson string This column contains the geographical data in GeoJSON format, representing the geographical area of interest.
geom_geotext string This column contains the geographical data in text format, representing the geographical area of interest.
geom_type string This column specifies the type of the geographical data.
geom_centroid string This column contains the geographical point that represents the centroid of the geographical area of interest.
geom_center_x double This column contains the x-coordinate of the center of the geographical area of interest.
geom_center_y double This column contains the y-coordinate of the center of the geographical area of interest.
gml_id string This column contains the unique identifier of the geographical area of interest.
name string This column contains the name of the geographical area of interest.
namn string This column contains an alternate name of the geographical area of interest.
nimi string This column contains another alternate name of the geographical area of interest.
seutukunta string This column contains a code that represents the regional unit of the geographical area of interest.
vuosi long This column contains the year when the data was collected.

Version History of Regional Units 2018 (Scale 1:4 500 000)

Column Type Comment
_start_date date This column holds the date when the row was extracted from the source. It is part of a combination with '_row_number' that uniquely identifies each row in the version history.
_end_date date This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates the row is the most recent version.
_row_number long This column represents the number of the row in the raw data extracted from the data source. It forms a unique pair with '_start_date' to identify each row in the version history.
geom_geojson string This column holds the geographical data in the GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext string This column contains geographical data represented as text, specifically in the form of multipolygons.
geom_type string This column specifies the type of the geometric data included in the row. For example, the type could be a multi-polygon.
geom_centroid string This column contains the central point of the geometric data, represented as a point.
geom_center_x double This column holds the X-coordinate of the geometric center of the data.
geom_center_y double This column holds the Y-coordinate of the geometric center of the data.
gml_id string This column contains a unique identifier for each row.
name string This column holds the name of the area, in English.
namn string This column contains the name of the area in a different language.
nimi string This column contains the name of the area in another language.
seutukunta string This column contains a code representing a specific region within Finland.
vuosi long This column contains the year related to the data in the row, represented as an integer.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024