Statistics Bureau Data Collection 2017

This dataset collection consists of a group of related tables that contain statistics sourced from the website of 'Tilastokeskus' (Statistical Bureau) in Finland. The data is organized in a tabular format, where each row and column represents a specific subset of data. The primary focus of this collection is to provide a statistical service interface, as indicated by the description provided by the source. Each table in the collection contributes to the overall theme, ensuring a comprehensive representation of the subject matter. 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 Municipalities 2017 (1:4 500 000)TSV
The 'table__history' is a history table that forms an integral part of a larger dataset, and it primarily contains version history of base table rows. It is sourced from the 'Tilastokeskus' website in Finland. The table is enriched with a variety of data columns, each playing a unique role in data analytics. The table holds a rich collection of geographic data, encapsulated within columns that start with 'geom_'. These columns provide geojson, geotext, and centroid information, as well as the type of geometry and the center coordinates in x and y. This geographic information, presented using the WGS 84 coordinate reference system (longitude followed by latitude), can be particularly useful for geospatial data analytics. For example, one could utilize this data to map out regions,...
Municipalities 2017 (1:4 500 000) - Dataset TableTSV
The table, sourced from the Statistics Finland (Tilastokeskus) website, serves as a detailed representation of the Finnish municipalities as of 2017. The table includes geographic and demographic data for each municipality, allowing for comprehensive analysis of the region. The table is part of a larger dataset collection, providing an in-depth look at various aspects of the municipalities. Each row in the table represents a unique municipality, identified by a combination of the date when the data was extracted and the row number. This combination ensures that each row is distinct and identifiable. The table is enriched with geographic data, including information on the type of geographic shape, centroid, and center points of each municipality. These data points use the WGS 84...

Column Descriptions

Municipalities 2017 (1:4 500 000) - Dataset Table

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the Tilastokeskus (Statistics Finland).
_row_number	long	The row number in the data extracted from the source on the extract date. Combined with '_extract_date', this uniquely identifies each row.
geom_geojson	string	Contains geometric data in the format of GeoJSON, representing the geographical area associated with the row.
geom_geotext	string	Contains geometric data as text, representing the geographical area associated with the row.
geom_type	string	Specifies the type of the geometric data. For example, it can be a point, line, polygon, etc.
geom_centroid	string	Contains the centroid of the geometrical area associated with the row. The centroid is represented as a point.
geom_center_x	double	The X-coordinate (longitude) of the centroid of the geometric area.
geom_center_y	double	The Y-coordinate (latitude) of the centroid of the geometric area.
gml_id	string	A unique identifier for each row in the table.
kunta	string	A string that represents the municipality associated with the row.
name	string	The name of the area or location associated with the row.
namn	string	This is another name for the area or location associated with the row, possibly in a different language.
nimi	string	This is yet another name for the area or location associated with the row, possibly in a different language.
vuosi	double	A real number representing the year associated with the data in the row.

Historical Version Records of Municipalities 2017 (1:4 500 000)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. Together with '_row_number', it forms a combination that uniquely identifies each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. It contributes to a unique identifier for each row when combined with '_start_date' in this version history table.
geom_geojson	string	Contains geospatial data in GeoJSON format, representing geographical features with their geometries.
geom_geotext	string	Contains geospatial data in text format, representing geographical features with their geometries.
geom_type	string	Specifies the type of the geometric object represented in the 'geom_geojson' and 'geom_geotext' columns.
geom_centroid	string	Represents the centroid (geometric center) of the geometrical object described in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_x	double	Represents the x-coordinate of the center of the geometrical object described in the 'geom_geojson' and 'geom_geotext' columns.
geom_center_y	double	Represents the y-coordinate of the center of the geometrical object described in the 'geom_geojson' and 'geom_geotext' columns.
gml_id	string	Identifies the geographic markup language (GML) element associated with the row.
kunta	string	String type data representing the municipality related to the data row.
name	string	String type data representing the name related to the data row.
namn	string	String type data representing another name related to the data row.
nimi	string	String type data representing another name related to the data row.
vuosi	double	Real type data representing the year related to the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024