Collection of Statistical Regions: Yearly Data Tables (2013-2024)

This dataset collection comprises of several related data tables sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland. The tables contain statistical data spanning across various years. The information in this collection is organized in a tabular format, with each table consisting of related data presented in rows and columns. The contents of these tables are derived from the service interface of the Statistics Finland, which adds to the reliability and authenticity of the data. The dataset collection provides valuable insights into the statistical areas of interest over the years, making it a significant resource for anyone seeking in-depth understanding of these areas. 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 Administration Areas (1:4 500 000) Data TableTSV
The table, part of the 'tilastointialueet_avi4500k' dataset, contains information about AVI areas on a scale of 1:4,500,000, originating from the 'Tilastokeskus' (Statistics Finland) website. The data includes various geographical and administrative details, making it a valuable resource for geospatial data analytics. The columns in the table provide a range of valuable information. The uniqueness of each row in the table is ensured by an extract date and a row number, offering a clear chronology of data extraction. The data includes geographic information represented in various formats like geojson, geotext, and centroid point. It also contains the type of geometry used and the X and Y coordinates of the geometric center. All geographic coordinates are presented using the WGS 84...
Version History of AVI Areas (1:4 500 000) Data TableTSV
The 'table__history' is a historical dataset that tracks the version history of its base table rows. It's part of a larger dataset collection called 'tilastointialueet_avi4500k'. This historical table is sourced from 'Tilastokeskus' (Statistics Finland) and primarily contains information about the AVI areas in Finland represented at a scale of 1:4 500 000. The data includes elements such as region names in different languages and unique identifiers for each area. It also includes a variety of geographic information that can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Unique identifiers for each row are formed by a combination of the start date and...

Column Descriptions

Regional Administration Areas (1:4 500 000) Data Table

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source. It forms part of a unique identifier for the row when combined with the '_row_number' column.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It forms part of a unique identifier for the row when combined with the '_extract_date' column.
avi	string	This string column represents a unique identifier for a specific region.
geom_geojson	string	This column contains geographic data in GeoJSON format. It could represent the shape and boundaries of a specific area.
geom_geotext	string	This column provides geographic data in a text-based format. It might represent the shape and boundaries of a specific area, similar to the 'geom_geojson' column.
geom_type	string	This column specifies the type of geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. It could be a polygon, multipolygon, etc.
geom_centroid	string	This column provides the geographic center point of the shape defined in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	This column provides the x-coordinate of the geographic center point of the shape defined in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column provides the y-coordinate of the geographic center point of the shape defined in the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This string column contains a unique identifier for each row.
id	long	This integer column represents a unique identifier for each row.
name	string	This string column contains the English name of a specific region.
namn	string	This string column contains the Finnish name of a specific region.
nimi	string	This string column contains the Swedish name of a specific region.
vuosi	long	This integer column represents the year of the data.

Version History of AVI Areas (1:4 500 000) Data Table

Column	Type	Comment
_start_date	date	This column stores the date when a specific row was extracted from the data source, serving as a starting point for the row's version history. It is part of a combination with the '_row_number' column that uniquely identifies each row in this history table.
_end_date	date	The '_end_date' column contains the date when a new version of the row was extracted from the data source, marking the end of the current version's validity. A null value in this column indicates that the row represents the most recent version.
_row_number	long	The '_row_number' column is a unique identifier for each row, representing the order of extraction from the data source. It is part of a combination with the '_start_date' column that uniquely identifies each row in this history table.
avi	string	This column represents a unique string identifier.
geom_geojson	string	This column stores the geographical data in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext	string	The 'geom_geotext' column contains the textual representation of the geographical data.
geom_type	string	This column specifies the type of geographical data stored in the row, for example, whether it's a polygon or multipolygon.
geom_centroid	string	The 'geom_centroid' column contains the centroid point of the geographical data.
geom_center_x	double	This column represents the X coordinate of the centroid point of the geographical data.
geom_center_y	double	The 'geom_center_y' column represents the Y coordinate of the centroid point of the geographical data.
gml_id	string	The 'gml_id' column is a unique string identifier for the geographical data.
id	long	This column is an integer identifier for each row.
name	string	The 'name' column contains the English name of the region.
namn	string	The 'namn' column contains the name of the region in another language.
nimi	string	The 'nimi' column contains the name of the region in another language, providing multilingual support.
vuosi	long	The 'vuosi' column represents the year associated with the data in the row.

Additional Info

Last Updated	November 12, 2024
Created	November 8, 2024