Statistical Area Large Region 1000K 2024

This dataset collection contains related data tables that are sourced from the Statistics Centre (Tilastokeskus), Finland. The data within these tables are organized in rows and columns, making it easy to understand and analyze the information. The dataset collection primarily focuses on statistical areas and provides a comprehensive overview of the 'large area 1000k' for the year 2024. The data is accessed via the Statistics Centre's service interface (WFS), ensuring its reliability and accuracy. This dataset collection is vital for researchers, policymakers, and anyone interested in understanding the statistical landscape of Finland in 2024. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Large Regions Forecast 2024 (Scale 1:1,000,000) Data TableTSV
The table, part of the 'tilastointialueet_suuralue1000k_2024' dataset collection, provides detailed information about the 'Large Areas 2024' in Finland, sourced from the 'Statistics Finland' (Tilastokeskus) website. The data is organized into various columns, each containing specific types of information. For instance, there are columns that contain the date the data was extracted, the row number in the data source, geographic information, and information about the large areas in multiple languages. The geographic data can be utilized for geospatial analytics, as they are presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude. Particularly noteworthy are the special columns '_extract_date' and '_row_number'. The '_extract_date' column...
Version History of Major Areas 2024 Table (1:1 000 000)TSV
The 'table__history' is a historical data table that is part of the 'tilastointialueet_suuralue1000k_2024' dataset collection. It is specifically a history table, which means it keeps track of the version history of its base table rows. This table was sourced from the 'Tilastokeskus' website, based in Finland. The base table content, translated into English, is 'Large Areas 2024 (1:1 000 000)'. The table presents a variety of data through its columns, such as specific dates indicating when data was extracted and updated, unique row numbers, and geographic information. The geographic information is particularly valuable as it allows for geospatial data analytics, with coordinates presented using the WGS 84 coordinate reference system. This system prioritizes longitude first, followed by...

Column Descriptions

Large Regions Forecast 2024 (Scale 1:1,000,000) Data Table

Column	Type	Comment
_extract_date	date	This column holds the date when the data on the row was extracted from the data source. This, in combination with the '_row_number', uniquely identifies each row.
_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, in conjunction with the '_extract_date', uniquely identifies each row.
geom_geojson	string	This column contains geometric data in GeoJSON format, which is a standard format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geometric data in text format, representing various geographic data structures.
geom_type	string	This column contains the geometric type of the geographic data structures, typically represented as 'ST_MULTIPOLYGON'.
geom_centroid	string	This column contains the geometric centroid of the geographic data structures, usually represented as a point.
geom_center_x	double	This column contains the X component of the geometric center of the geographic data structures.
geom_center_y	double	This column contains the Y component of the geometric center of the geographic data structures.
gml_id	string	This column stores the unique identifier for the geographic data, typically represented in the format 'suuralue1000k_2024.x'.
name	string	This column contains the English name of the geographic area.
namn	string	This column contains the name of the geographic area in Swedish.
nimi	string	This column contains the name of the geographic area in Finnish.
suuralue	string	This column contains a numeric identifier for the geographic area.
vuosi	long	This column contains the year the data was collected, represented as an integer.

Version History of Major Areas 2024 Table (1:1 000 000)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' to identify each row in the version history table.
_end_date	date	This column contains the date when a new version of the row was extracted. If the value is null, it means 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 source. It forms a unique combination with the '_start_date' to identify each row in the version history table.
geom_geojson	string	This column contains the geographic data in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains the geographic data in text format, representing the shapes of geographic features.
geom_type	string	This column specifies the type of the geographic data. For example, 'ST_MULTIPOLYGON' represents a shape formed by multiple polygons.
geom_centroid	string	This column contains the geographic point that represents the centroid of the geographic shape.
geom_center_x	double	This column contains the x-coordinate of the center point of the geographic shape.
geom_center_y	double	This column contains the y-coordinate of the center point of the geographic shape.
gml_id	string	This column contains a unique identifier for each row.
name	string	This column contains the name of the geographic area in English.
namn	string	This column contains the name of the geographic area in Swedish.
nimi	string	This column contains the name of the geographic area in Finnish.
suuralue	string	This column contains an identifier representing a larger geographic area to which the row's geographic area belongs.
vuosi	long	This column contains the year associated with the data in the row.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024