Statistical Regions and Provinces Dataset Collection 2017

The dataset collection in question is a comprehensive assembly of related data tables. Originating from the Statistics Finland's (Tilastokeskus) web service interface in Finland, this collection forms a cohesive group of data tables, each containing related data arranged in a structured format of columns and rows. The data encapsulated in this collection provides valuable insights and detailed information that is instrumental for comprehensive statistical analysis. The data tables within this collection are sourced from a reputable platform, ensuring the reliability and accuracy of the information provided. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

Regions of 2017 at a 1:1,000,000 ScaleTSV
The table, part of a dataset collection, consists of a variety of information related to 'Regions 2017' (translated from Finnish 'Maakunnat 2017'). The data in the table is sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. It contains several columns with diverse types of data, which can be utilized for data analytics purposes. The columns include two special ones, 'extract_date' and '_row_number'. The former indicates when the data row was extracted, while the latter specifies the row number in the extracted data. These two columns together make each data row uniquely identifiable. Additionally, there are multiple 'geom' prefixed columns that encapsulate geographic information, useful for geospatial data analytics. The geographic coordinates are presented using...
Version History of Regions 2017 (1:1 000 000) - Historical RecordsTSV
The 'table__history' is a rich dataset that contains historical records from the 'Provinces 2017' data collection, sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. The table encapsulates the version history of its base table, providing a temporal perspective on the geographical data it stores. This information offers a unique blend of temporal and spatial data, making it a valuable resource for various forms of data analytics. The table comprises columns that store geographical information, such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain geographic data in various formats, including GeoJSON and Geotext, which can be utilized for geospatial data analytics. The geographical...

Column Descriptions

Regions of 2017 at a 1:1,000,000 Scale

Column	Type	Comment
_extract_date	date	This column is a special field that contains the date when the data on the row of the table was retrieved from the data source.
_row_number	long	This special column records the row number in the data extracted from the source on the extract date specified by the _extract_date column. Combined with _extract_date, it uniquely identifies each row.
geom_geojson	string	This column contains Geospatial data in GeoJSON format representing geographical features.
geom_geotext	string	This column holds the Geospatial data in text format.
geom_type	string	This column describes the type of Geospatial data stored in the table.
geom_centroid	string	This column contains the centroid coordinates of the Geospatial data.
geom_center_x	double	This field denotes the x-coordinate of the center of the Geospatial data.
geom_center_y	double	This column indicates the y-coordinate of the center of the Geospatial data.
gml_id	string	This column holds a unique identifier for each row, which is a combination of the dataset name and row number.
maakunta	string	This column contains codes representing different provinces in Finland.
name	string	This column lists the English names of the provinces.
namn	string	This column provides the names of the provinces in Swedish.
nimi	string	This column includes the names of the provinces in Finnish.
vuosi	double	This column denotes the year the data was recorded.

Version History of Regions 2017 (1:1 000 000) - Historical Records

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source, marking the beginning of the period for which the information is valid.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source, marking the end of the period. If it 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. Together with '_start_date', it uniquely identifies each row in this version history table.
geom_geojson	string	This column contains the geometric data of the area in the GeoJSON format, which is a geospatial data interchange format based on JavaScript Object Notation (JSON).
geom_geotext	string	This column contains the geometric data of the area in text format. The data is presented as a multipolygon, which is a collection of polygons that describes the shape of the area.
geom_type	string	This column defines the type of the geometric object. In this table, the type is 'ST_MULTIPOLYGON', which represents a shape consisting of multiple polygons.
geom_centroid	string	This column contains the centroid of the geometric data. The centroid is the center point of the geometric object.
geom_center_x	double	This column contains the x-coordinate of the center of the geometric object.
geom_center_y	double	This column contains the y-coordinate of the center of the geometric object.
gml_id	string	This column contains the unique identifier of the row in the GML (Geography Markup Language) format.
maakunta	string	This column contains an identifier for the region. It is a string data type.
name	string	This column contains the English name of the region.
namn	string	This column contains the Swedish name of the region.
nimi	string	This column contains the Finnish name of the region.
vuosi	double	This column contains the year, represented as a real number. In the context of this table, it represents the year of the data.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024