Statistical Areas Data Compilation, 2019 Edition

The dataset collection in question compiles a set of related data tables which are originated from the Statistical Service Interface (Tilastokeskuksen palvelurajapinta) in Finland (Tilastokeskus). These tables provide various statistical insights and are compiled to offer a comprehensive view of the data subject. The compilation aims to facilitate data-driven decision making, by providing organized and accessible data. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

AVI Regions 2019 Scaled 1:1,000,000 - Statistical Data TableTSV
The table in focus is part of a larger dataset collection, particularly relating to regional statistics. This table contains a variety of data, including specific geographic information, unique identifiers, and other details, all of which are sourced from the 'Tilastokeskus' website in Finland. This table is a detailed representation of the AVI regions for the year 2019 at a scale of 1:1 000 000. The table includes information such as specific regional identifiers ('avi'), names in various languages ('name', 'namn', 'nimi'), and the year of data ('vuosi'). Additionally, the table also includes geographic data through a series of 'geom_' prefixed columns. These include 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which provide...
Historical Versions of AVI Regions 2019 (1:1 000 000)TSV
The 'table__history' is a comprehensive dataset that records the version history of its base table rows, specifically pertaining to the AVI regions in Finland for the year 2019. This data originates from 'Tilastokeskus' (Statistics Finland), a Finnish institution known for data accuracy and credibility. The table offers a time-stamped version history of each row and is particularly useful for tracking changes over time. The table includes columns for both the start and end date of each row's validity, allowing users to trace the lineage of data changes. Notably, if the end date value is null, it indicates that the row is the most recent version. The table also offers a unique row identification system, where the row number combined with the start date creates a unique identifier for...

Column Descriptions

AVI Regions 2019 Scaled 1:1,000,000 - Statistical Data Table

Column	Type	Comment
_extract_date	date	This column signifies the date when the data in the table row was extracted from the original data source.
_row_number	long	This column contains the unique row number of the data extracted from the original source, corresponding with the extraction date specified in the '_extract_date' column.
avi	string	This column represents a code, potentially identifying different geographical regions or administrative units.
geom_geojson	string	This column stores geographic data in the GeoJSON format, typically defining geographic features such as points, lines, and polygons.
geom_geotext	string	This column contains the geographic data in the text format, likely representing the same geographic features found in the 'geom_geojson' column.
geom_type	string	This column identifies the type of geometric data stored in the aforementioned 'geom' columns. In this case, all entries are multi-polygon shapes.
geom_centroid	string	This column holds data representing the geometric center point, or centroid, of the geographic shapes defined in the 'geom' columns.
geom_center_x	double	This column contains the x-coordinate of the centroid of the geographic shapes.
geom_center_y	double	This column contains the y-coordinate of the centroid of the geographic shapes.
gml_id	string	This column might be an identifier for the geographic shapes defined in the 'geom' columns.
id	long	This column likely contains unique identifiers for the rows in the table.
name	string	This column consists of names, possibly denoting different regions or administrative units.
namn	string	This column also contains names, possibly in a different language than the 'name' column.
nimi	string	Yet another column containing names, presumably in another language, possibly Finnish.
vuosi	long	This column contains the year, possibly indicating when the corresponding data was collected or relevant.

Historical Versions of AVI Regions 2019 (1:1 000 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, combined with '_row_number', uniquely identifies each row in the table.
_end_date	date	The date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source.
avi	string	A string value, which is part of the original data from the base table.
geom_geojson	string	A representation of the geographic features in GeoJSON format.
geom_geotext	string	A text representation of the geographic features in the form of a MultiPolygon.
geom_type	string	The type of the geographic feature, which in this case is a MultiPolygon.
geom_centroid	string	The centroid or geometric center of the MultiPolygon.
geom_center_x	double	The x-coordinate of the geometric center of the MultiPolygon.
geom_center_y	double	The y-coordinate of the geometric center of the MultiPolygon.
gml_id	string	An identifier for the data row, provided in the format of the base table.
id	long	A unique numerical identifier for the row, as provided in the base table.
name	string	The English name of the AVI (Administrative District) the data refers to.
namn	string	The name of the AVI in Swedish.
nimi	string	The name of the AVI in Finnish.
vuosi	long	The year associated with the data row, as an integer.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024