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

Statistics Bureau Interface Data Tables 2021

The dataset collection is a compilation of related data tables sourced from the website of Tilastokeskus (Statistics Finland) in Finland. The tables in this collection are organized in a tabular format consisting of rows and columns. The content of the dataset collection is derived from Tilastokeskuksen palvelurajapinta (Statistics Finland's service interface), providing a rich source of data. The information in this collection can provide insights and valuable information for statistical analysis 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

  • ELY Areas 2021 Version History (1:4 500 000)TSV

    The 'table__history' is a rich data repository capturing the version history of its core data rows. It's a key component of the comprehensive dataset 'tilastointialueet_ely4500k_2021'. The table contains crucial information about ELY-areas, essentially Economic Development, Transport and the Environment Centres in Finland, as of 2021, at a scale of 1:4,500,000. The data table encompasses several columns that track a variety of information. One of the key columns is '_row_number', which notes the row's position in the raw data extracted from the source. To uniquely identify each row in this version history table, a combination of '_start_date' and '_row_number' is used. The '_start_date' indicates the extraction date of the row from the source, while the '_end_date' signifies the date...

  • Regional Development and Administration Agencies in Finland 2021 (Scale: 1:4,500,000)TSV

    The table in question, part of the 'tilastointialueet_ely4500k_2021' dataset collection, is a compilation of data concerning ELY areas for the year 2021 at a scale of 1:4,500,000. Originating from the Finnish website 'Tilastokeskus' (Statistics Finland), this table provides a detailed view into various aspects of these areas. The table is equipped with a set of columns capturing unique and valuable data points. There are columns capturing geographical data, which can be extremely handy for geospatial data analytics. These columns begin with 'geom_' and include geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Two special columns in the table, '_extract_date' and '_row_number', play a crucial role in the...

Column Descriptions

Regional Development and Administration Agencies in Finland 2021 (Scale: 1:4,500,000)

Column Type Comment
_extract_date date The date when the data on the row of the table was extracted. This is a special column that, in combination with '_row_number', uniquely identifies each row. For example, a value could indicate that the data was extracted on November 11, 2024.
_row_number long The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This is a special column that, in combination with '_extract_date', uniquely identifies each row. For instance, a value could be 60, 92, 22, 88, or 50.
ely string A string identifier related to the data. Sample values include '13', '09', '02', '08', and '16'.
geom_geojson string Contains complex geometric data in the GeoJSON format. This could include a variety of geometric shapes like MultiPolygons and Polygons.
geom_geotext string Contains complex geometric data in text format. This often parallels the 'geom_geojson' column, including shapes like MultiPolygons and Polygons.
geom_type string Specifies the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. This could be, for example, 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid string Specifies the geometric center, or centroid, of the shape described in the 'geom_geojson' and 'geom_geotext' columns. This is often represented as a 'POINT' with corresponding coordinates.
geom_center_x double Represents the x-coordinate of the centroid of the geometric shape described in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y double Represents the y-coordinate of the centroid of the geometric shape described in the 'geom_geojson' and 'geom_geotext' columns.
gml_id string A string type identifier related to the data. This could be a unique identifier for each row in the table.
id long An integer type identifier that can be related to the data. This could be a unique identifier for each row in the table.
name string A string type column containing names related to the data. Sample values could include names of different ELY Centres or regions.
namn string A string type column containing names related to the data, possibly in a different language than the 'name' column.
nimi string A string type column containing names related to the data, possibly in a different language than both the 'name' and 'namn' columns.
vuosi long An integer type column containing years related to the data. For instance, it could indicate the year the data was collected or refers to.

ELY Areas 2021 Version History (1:4 500 000)

Column Type Comment
_start_date date This column represents the date on which a particular row was extracted from the data source. It forms part of a unique identifier for each row in this version history table, the other part being '_row_number'.
_end_date date This column contains the date when a new version of a row was extracted from the data source. If the column's value is null, it indicates 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. Together with '_start_date', it forms a unique identifier for each row in the version history table.
ely string This is a string type column in the base table that has no English description provided by the source.
geom_geojson string This column contains the geometric data of the region in GeoJSON format.
geom_geotext string This column contains the geometric data of the region in a textual format.
geom_type string This column represents the type of geometric data stored, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid string This column contains the centroid point of the geometric data of the region.
geom_center_x double This column represents the x-coordinate of the center point of the geometric data.
geom_center_y double This column represents the y-coordinate of the center point of the geometric data.
gml_id string This is a string type column in the base table with no English description provided by the source.
id long This is an integer type column in the base table with no English description provided by the source.
name string This is a string type column in the base table with no English description provided by the source.
namn string This is a string type column in the base table with no English description provided by the source.
nimi string This is a string type column in the base table with no English description provided by the source.
vuosi long This is an integer type column in the base table that has no English description provided by the source.

Additional Info

Last Updated November 11, 2024
Created November 11, 2024