Regional Statistics Area Dataset Collection

The dataset collection at hand is a comprehensive compilation of statistical region data, sourced from Statistics Finland ('Tilastokeskus'). It consists of related data tables that provide in-depth insights into regional statistics. The information within this collection spans multiple years, allowing for a detailed analysis and comparison over time. This collection is crucial for anyone interested in understanding regional trends and changes in Finland. 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 Regions (1:1 000 000)TSV
The 'table__history' is a significant part of a larger dataset collection, storing valuable information on regional units (Seutukunnat) at a scale of 1:1,000,000. This information is sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland). The table serves as a historical record, storing version history of its base table rows. This historical data is useful in tracking changes over time and understanding trends. For instance, it could be instrumental in analyzing changes in regional boundaries or populations, among other things. The table contains a set of columns with diverse types of information. These include unique identifiers for each row, geographic data, and other details about the regional units. Importantly, the table uniquely identifies each row with...
Regional Units (1:1 000 000) from Finnish Statistics Dataset CollectionTSV
The table in question hails from the dataset collection 'tilastointialueet_seutukunta1000k' and contains a variety of valuable information. The contents of the table, sourced from the 'Tilastokeskus' website in Finland, are primarily built around regions (Seutukunnat) at a 1:1,000,000 scale. This essentially means that the data within this table is closely related to regional statistics and geospatial data in Finland. The table is composed of a variety of columns, each serving its own unique purpose. There are two special columns: '_extract_date' and '_row_number'. The former includes the date when the data on the row was extracted from the source, while the latter contains the row number in the extracted data. These two columns in combination uniquely identify each row. In addition to...

Column Descriptions

Regional Units (1:1 000 000) from Finnish Statistics Dataset Collection

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the source. The format of the date is YYYY-MM-DD.
_row_number	long	This column contains the row number of the data extracted from the source on the extract date specified by the column '_extract_date'. This column along with the '_extract_date' column uniquely identifies each row.
geom_geojson	string	This column contains the geographic data in GeoJSON format. The data represents the geographic area related to the other data in the row.
geom_geotext	string	This column contains the geographic data in text format. The data represents the geographic area related to the other data in the row.
geom_type	string	This column describes the type of the geographic data stored in the 'geom_geojson' and 'geom_geotext' columns. The types can be either ST_MULTIPOLYGON or ST_POLYGON.
geom_centroid	string	This column contains the geographic coordinates of the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns. The format of the data is POINT (longitude latitude).
geom_center_x	double	This column contains the longitude of the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	This column contains the latitude of the centroid of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	This column contains a unique identifier for the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
name	string	This column contains the English name of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
namn	string	This column contains the Swedish name of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
nimi	string	This column contains the Finnish name of the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
seutukunta	string	This column contains a unique code for the geographic area represented by the 'geom_geojson' and 'geom_geotext' columns.
vuosi	long	This column contains the year associated with the data in the row.

Historical Version Records of Regions (1:1 000 000)

Column	Type	Comment
_start_date	date	Indicates the date when the row was extracted from the data source. This column, along with '_row_number', uniquely identifies each row in this version history table.
_end_date	date	Contains 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	Represents the number of the row in the raw data extracted from the data source. This column, in conjunction with '_start_date', uniquely identifies each row in this version history table.
geom_geojson	string	Stores the geometric data of the regions in GeoJSON format.
geom_geotext	string	Contains the geometric data of the regions in textual format.
geom_type	string	Specifies the type of the geometric data, which can be either 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	Indicates the centroid of the geometric data.
geom_center_x	double	Represents the x-coordinate of the center of the geometric data.
geom_center_y	double	Indicates the y-coordinate of the center of the geometric data.
gml_id	string	A unique identifier for each row, provided by the source.
name	string	The English name of the region.
namn	string	The name of the region in Swedish.
nimi	string	The name of the region in Finnish.
seutukunta	string	A unique code assigned to each region.
vuosi	long	The year when the data was collected.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024