Statistical Areas Large Region 1000k 2023 Collection

This dataset collection consists of a series of interconnected data tables that provide statistical data from the Finnish statistical authority, Tilastokeskus. The tables contain an extensive range of data, organized in a structured table format including rows and columns for easy understanding and interpretation. The data has been sourced directly from the service interface of Tilastokeskus, ensuring its reliability and accuracy. This collection serves as a rich resource for anyone looking to delve into Finnish statistics. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Historical Version Records of Large Areas 2023 (1:1 000 000)TSV
The 'table__history' is a vital component of the larger data group 'tilastointialueet_suuralue1000k_2023'. This table is a history table and serves as a detailed archive for the version history of its base table rows. The base table represents the 'Suuralueet 2023' or 'Major Areas 2023' at a scale of 1:1 000 000. This table is characterized by several columns, each holding specific information. The '_row_number' column indicates the sequence of the row in the raw data extracted from the data source. Along with '_start_date', it uniquely identifies every row in this table. '_start_date' and '_end_date' are particular columns which specify when the row was extracted and when a new version of the row was obtained, respectively. If the '_end_date' is null, it indicates that the row is the...
Large Areas Projection for 2023 (Scale 1:1,000,000)TSV
The table, part of the 'tilastointialueet_suuralue1000k_2023' dataset, is a comprehensive compilation of data relating to the 'Major Areas 2023'. This dataset is sourced from Finland's 'Tilastokeskus' (Statistics Finland) website. The table is organized into several columns, each providing unique and crucial information. For instance, there are columns that provide geographic information such as multipolygon data, centroid points and x,y coordinates, which are invaluable for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also includes identifiers such as 'name', 'namn', and 'nimi', which provide the names of the major areas in different languages....

Column Descriptions

Large Areas Projection for 2023 (Scale 1:1,000,000)

Column	Type	Comment
_extract_date	date	This special column specifies the date when the data on each row of the table was extracted from the source. The format of the date is YYYY-MM-DD.
_row_number	long	This special column represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table.
geom_geojson	string	This column contains the geometric data of the region in GeoJSON format, a type of open standard format designed for representing simple geographical features.
geom_geotext	string	This column holds the geometric data of the region in a textual form.
geom_type	string	This column describes the type of the geometric data, for example, 'ST_MULTIPOLYGON', which represents a multi-polygonal area.
geom_centroid	string	This column contains the geometric center (centroid) of the region, represented as a point in the form of 'POINT (x y)'.
geom_center_x	double	This column contains the X-coordinate of the geometric center of the region.
geom_center_y	double	This column contains the Y-coordinate of the geometric center of the region.
gml_id	string	This column contains a unique identifier for each row, usually in the format 'suuralue1000k_<year>.<region_number>'.
name	string	This column contains the name of the region in English.
namn	string	This column contains the name of the region in Swedish.
nimi	string	This column contains the name of the region in Finnish.
suuralue	string	This column contains the code for the region.
vuosi	long	This column contains the year related to the data, represented as an integer.

Historical Version Records of Large Areas 2023 (1:1 000 000)

Column	Type	Comment
_start_date	date	The column '_start_date' indicates the date when the row data was extracted from the data source. It is part of the unique identifier for each row in the version history table, along with '_row_number'.
_end_date	date	The column '_end_date' denotes the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	The '_row_number' 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	The 'geom_geojson' column represents the geographical data of the region in GeoJSON format, a popular format for encoding geographic data structures.
geom_geotext	string	The 'geom_geotext' column stores the geographical data in a textual format, specifically as a multipolygon, which is a collection of polygons that define the region.
geom_type	string	The 'geom_type' column indicates the type of the geometry used to represent the region. In this case, it is a multipolygon.
geom_centroid	string	The 'geom_centroid' column contains the geographical center point of the region, represented as a point in space.
geom_center_x	double	The 'geom_center_x' column holds the x-coordinate (longitude) of the geographical center point of the region.
geom_center_y	double	The 'geom_center_y' column holds the y-coordinate (latitude) of the geographical center point of the region.
gml_id	string	The 'gml_id' column is an identifier for the region.
name	string	The 'name' column stores the English name of the region.
namn	string	The 'namn' column contains the name of the region in Swedish.
nimi	string	The 'nimi' column holds the name of the region in Finnish.
suuralue	string	The 'suuralue' column is a numeric identifier for the region.
vuosi	long	The 'vuosi' column contains the year for which the data is relevant.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024