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

2019 Regional Statistics Dataset Collection from Finland

This dataset collection is an assembly of related data tables sourced from the 'Tilastokeskus' website, based in Finland. The collection includes a table that provides data from the Statistical Centre's service interface (WFS). It brings together a variety of information in a structured format, organized in rows and columns for easy interpretation. This comprehensive collection provides valuable insights and is an essential resource for anyone seeking to understand the service interface of the Statistical Centre. 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 Divisions 2019 (Scale 1:1,000,000)TSV

    The table belongs to a dataset collection that encompasses data on the regional divisions of Finland in 2019 at a scale of 1:1,000,000. This table includes several columns that contain various types of valuable data. The geographic information, provided in columns beginning with 'geom_', is especially useful for geospatial data analytics. These columns present geographic coordinates using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. The data in these columns could be used, for example, to create detailed maps or to analyse spatial patterns and trends. For instance, the 'geom_centroid' column provides the central point of each region, which could be used to determine the geographic centre of various phenomena or to calculate...

  • Version History of Sub-regions 2019 (1:1 000 000) - Historical DataTSV

    The 'table__history' is a history table that holds the version history of its base table rows, providing a comprehensive record of changes over time. This table belongs to the dataset collection 'tilastointialueet_seutukunta1000k_2019', sourced from the 'Tilastokeskus' website in Finland. It is primarily focused on the 'Seutukunnat 2019' data, which translates to 'Subregions 2019' in English. The table comprises of numerous columns, each serving a unique role. The '_row_number' column, for example, identifies the row number in the raw data extracted from the data source. Coupled with the '_start_date' column, these two form a unique identifier for each row in the table. The '_start_date' and '_end_date' columns indicate the timeframe during which a specific row was considered valid. If...

Column Descriptions

Regional Divisions 2019 (Scale 1:1,000,000)

Column Type Comment
_extract_date date This column contains the date when the data on each row was extracted from the source. This, in combination with the '_row_number' column, allows for unique identification of each row.
_row_number long This column holds the row number of the data that was extracted on the date specified in the '_extract_date' column. Together with '_extract_date', this provides a unique identifier for each row.
geom_geojson string This is a geometric column that holds the spatial data in GeoJSON format, a common format for encoding a variety of geographic data structures.
geom_geotext string This column contains the spatial data in text format, providing a human-readable representation of the geographic data structures.
geom_type string This column indicates the type of the geometric object represented in the 'geom_geojson' and 'geom_geotext' columns. The sample value 'ST_MULTIPOLYGON' suggests that the data points form multiple polygon shapes.
geom_centroid string This column contains the geometric center or centroid of the polygon shape defined in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x double This column holds the x-coordinate of the geometric center of the polygon shape defined in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y double This column holds the y-coordinate of the geometric center of the polygon shape defined in the 'geom_geojson' and 'geom_geotext' columns.
gml_id string This is an identifier column holding unique string values.
name string This column contains the names of geographical areas.
namn string This column seems to hold the names of geographical areas in a different language, possibly Swedish, as suggested by the sample values.
nimi string This column also holds the names of geographical areas, possibly in Finnish, as suggested by the sample values.
seutukunta string This column contains identifiers for the geographical areas represented in the 'name', 'namn', and 'nimi' columns.
vuosi long This column holds the year value, as suggested by the sample value '2019'. This might indicate the year the data was collected or to which the data refers.

Version History of Sub-regions 2019 (1:1 000 000) - Historical Data

Column Type Comment
_start_date date The '_start_date' column indicates the date when the row was extracted from the data source, marking the beginning of the row's version history. The format of the date is 'YYYY-MM-DD'.
_end_date date The '_end_date' column represents 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 recent version.
_row_number long The '_row_number' column contains the number of the row in the raw data, helping to uniquely identify each row in this version history table when combined with '_start_date'.
geom_geojson string The 'geom_geojson' column contains the geometric representation of the data in geojson format, which can include multiple polygons.
geom_geotext string The 'geom_geotext' column holds the geometric representation of the data in textual format, which can include multiple polygons.
geom_type string The 'geom_type' column specifies the type of geometric data contained in the row, for example, 'ST_MULTIPOLYGON'.
geom_centroid string The 'geom_centroid' column contains the centroid point of the geometric data, which represents the center point of the geometric shape.
geom_center_x double The 'geom_center_x' column indicates the 'x' coordinate of the center of the geometric data.
geom_center_y double The 'geom_center_y' column indicates the 'y' coordinate of the center of the geometric data.
gml_id string The 'gml_id' column contains a unique identifier for each row, which is a combination of the dataset name and the row number.
name string The 'name' column contains the name of the location or region in English.
namn string The 'namn' column contains the name of the location or region in Swedish.
nimi string The 'nimi' column contains the name of the location or region in Finnish.
seutukunta string The 'seutukunta' column contains a numerical code that represents a specific region or area.
vuosi long The 'vuosi' column indicates the year associated with the row's data.

Additional Info

Last Updated November 12, 2024
Created November 11, 2024