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

Statistical Areas Collection 2019

The dataset collection in question is a comprehensive assembly of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. These tables are organized in a structured format consisting of columns and rows, providing a clear and efficient way to display information. The content of these tables is derived from the Statistical Service Interface (WFS), offering detailed statistical data. This collection is a valuable resource for a wide range of analytical and research 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

  • Regional Division of Finland - ELY Areas 2019 Scaled 1:1 000 000TSV

    The table under consideration is a part of a dataset collection that compiles related tables. This specific table is packed with valuable information pertaining to the ELY-areas for the year 2019, as indicated by the data source. This data is key to understanding the geography and administrative divisions of Finland, as sourced from the Finnish statistical authority, 'Tilastokeskus'. The table includes a range of columns, each providing unique insights into the ELY-areas. To understand when the data was extracted from the source, one can refer to the '_extract_date' column, while the '_row_number' gives a sequence to the extracted data, with each row being uniquely identifiable by a combination of these two columns. Examples of other columns include identifiers for the ELY-areas, their...

  • Version History of ELY Areas 2019 (1:1 000 000)TSV

    The 'table__history' is a historical data table that stores the version history of its base table rows. It belongs to a dataset collection named 'tilastointialueet_ely1000k_2019'. It provides a comprehensive catalog of the ELY areas in Finland for the year 2019, at a scale of 1:1,000,000. The table includes a unique identifier for each row in the raw data, which is a combination of the date when the data was extracted and the row number. It also includes the date when a new version of the row was extracted. This feature allows for easy tracking and analysis of changes to the base table over time. The table contains geographic information, which can be used to perform geospatial data analytics. This includes the type of geographic feature, its geographic coordinates, its textual...

Column Descriptions

Regional Division of Finland - ELY Areas 2019 Scaled 1:1 000 000

Column Type Comment
_extract_date date This is a special column that records the date when the data on the row of the table was extracted from the source. It helps in tracking the timeline of data extraction.
_row_number long This is another special column that records the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date', uniquely identifies each row.
ely string This string type column represents certain codes, perhaps related to regional or organizational identifiers.
geom_geojson string This column contains geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext string This column seems to contain geographic data represented in a textual format, likely corresponding to the GeoJSON data in the 'geom_geojson' column.
geom_type string This column specifies the type of the geographic data represented in the 'geom_geojson' and 'geom_geotext' columns. In the given sample, it is 'ST_MULTIPOLYGON' which suggests the data represents multiple polygonal areas.
geom_centroid string This column contains the coordinates of the centroid, or geometric center, of the geographic area represented in the row.
geom_center_x double This column records the X-coordinate (longitude) of the geographic center of the area represented in the row.
geom_center_y double This column records the Y-coordinate (latitude) of the geographic center of the area represented in the row.
gml_id string This string type column contains unique identifiers for each row, perhaps related to the data source or the geographic area represented.
id long This is an integral column that provides a unique numerical identifier for each row.
name string This string column contains names, possibly of geographical regions or organizations, in English.
namn string This is a string column that appears to contain names similar to those found in the 'name' column, but in a different language, possibly Finnish or Swedish.
nimi string This is another string column that holds names similar to those in the 'name' and 'namn' columns, but in another language, possibly Finnish.
vuosi long This integral column records a year, possibly the year the data in the row was collected or pertains to.

Version History of ELY Areas 2019 (1:1 000 000)

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It's part of a combination with '_row_number' that uniquely identifies each row in this version history table.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means 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. It's part of a combination with '_start_date' that uniquely identifies each row in this version history table.
ely string This column contains a string value representing a unique identifier for the ELY Centre, which is a regional centre for economic development, transport and the environment in Finland.
geom_geojson string This column contains a GeoJSON representation of the geometry of the ELY Centre region.
geom_geotext string This column contains a text representation of the geometry of the ELY Centre region.
geom_type string This column contains the type of the geometry, which in this case is 'ST_MULTIPOLYGON', indicating the region is represented by multiple polygons.
geom_centroid string This column contains the coordinates of the centroid of the geometry of the ELY Centre region.
geom_center_x double This column contains the x-coordinate (longitude) of the center of the geometry of the ELY Centre region.
geom_center_y double This column contains the y-coordinate (latitude) of the center of the geometry of the ELY Centre region.
gml_id string This column contains a string value representing the GML (Geography Markup Language) identifier for the data row.
id long This column contains an integer value representing a unique identifier for the data row.
name string This column contains a string value representing the English name of the ELY Centre.
namn string This column contains a string value representing the name of the ELY Centre in Swedish.
nimi string This column contains a string value representing the name of the ELY Centre in Finnish.
vuosi long This column contains an integer value representing the year the data row was recorded or updated.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024