2019 Statistical Area Data Collection for Regional Community Areas

The dataset collection under consideration contains a series of related data tables sourced from the website of the Finnish Statistics Bureau, 'Tilastokeskus'. This collection is built upon the Statistics Bureau's service interface (WFS), offering a rich assemblage of statistical data. It is an essential resource for researchers, policy makers, and others who are interested in understanding comprehensive statistical information. The data tables within this collection are meticulously organized into rows and columns, making it easy for users to navigate and extract the required information. The data covers a broad range of categories, providing a holistic view of the statistical landscape. 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 2019 - Geographic Data at 1:4 500 000 ScaleTSV
The table is a comprehensive collection of related data that provides details about statistical regions for the year 2019 at a scale of 1:4,500,000, sourced from the 'Tilastokeskus' website in Finland. It comprises of various columns, each representing unique information. There are two special columns: one indicating the date when the data was extracted, and the other specifying the unique row number for each extraction. These two columns together form a unique identifier for each data row. The table also includes a variety of geographic details, which allows for in-depth geospatial data analysis. These geographic attributes are represented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. The information in the table could prove valuable in a...
Version History of Regional Units 2019 (1:4 500 000) TableTSV
The 'table__history' is a rich source of historical data, offering insights into the evolution of various regions in Finland. It is part of the 'tilastointialueet_seutukunta4500k_2019' dataset collection, which collates relevant data tables. The history table maintains a version history for each row in its base table, allowing users to track data changes over time. This is particularly useful in trend analysis and predictive modeling. The table comprises several columns, each contributing unique information. For instance, some columns carry geographic information, which can be leveraged in 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. Two additional...

Column Descriptions

Regional Units 2019 - Geographic Data at 1:4 500 000 Scale

Column	Type	Comment
_extract_date	date	This column represents the date when the row's data was extracted from the source. The format of the dates is YYYY-MM-DD.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains the geometric data in GeoJSON format. GeoJSON is a type of data format used for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geometric data in text format. This format is useful for visualizing the data in applications that do not support GeoJSON.
geom_type	string	This column describes the type of the geometric data. The sample value 'ST_MULTIPOLYGON' indicates that the geometric data represents multiple polygons.
geom_centroid	string	This column contains the centroid of the geometric data. The centroid is the geometric center of the shape.
geom_center_x	double	This column contains the X coordinate of the geometric center.
geom_center_y	double	This column contains the Y coordinate of the geometric center.
gml_id	string	This column contains a unique identifier for each row. The ID is a combination of the dataset name and a unique number.
name	string	This column contains the name of the statistical area in English.
namn	string	This column contains the name of the statistical area in Swedish.
nimi	string	This column contains the name of the statistical area in Finnish.
seutukunta	string	This column contains the code of the statistical area. This is a unique identifier used by the Finnish statistical authority.
vuosi	long	This column represents the year that the data pertains to. The data in the sample is from 2019.

Version History of Regional Units 2019 (1:4 500 000) Table

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column.
_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 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 uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geometric data in GeoJSON format. This data represents the geographical structures related to the data.
geom_geotext	string	This column contains the geometric data in text format, representing the geographical structures related to the data.
geom_type	string	This column specifies the type of the geographical structure represented by the geometric data.
geom_centroid	string	This column contains the centroid of the geographical structure represented by the geometric data.
geom_center_x	double	This column contains the X-coordinate of the center point of the geographical structure.
geom_center_y	double	This column contains the Y-coordinate of the center point of the geographical structure.
gml_id	string	This column contains the unique identifier of the row in the base table.
name	string	This column contains the name in English of the geographical entity represented by the row.
namn	string	This column contains the name in Swedish of the geographical entity represented by the row.
nimi	string	This column contains the name in Finnish of the geographical entity represented by the row.
seutukunta	string	This column contains a unique code representing the geographical entity.
vuosi	long	This column contains the year when the data was collected.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024