Statistics Area Community Index 2013

This dataset collection focuses on statistical regional data, hailing from Finland. Specifically, the data tables within the collection originate from the 'Tilastokeskus' website, which serves as a national statistics service. The data contained within these tables provides comprehensive coverage of regional statistics for the year 2013. The structure of this data, organized into rows and columns, allows for efficient analysis and interpretation of the statistical regional information. The data tables in the collection are interconnected, forming a cohesive dataset that provides a detailed snapshot of Finland's statistical landscape during the specified time period. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

2013 Municipalities Spatial Distribution at 1:1 000 000 ScaleTSV
The table, sourced from the 'Tilastokeskus' (Statistics Finland) website, is part of a larger dataset collection. It contains a wealth of information specifically related to the municipalities in Finland for the year 2013. Each row in the table represents a unique data extraction event, identified by a specific extraction date and a row number. This allows for very precise tracking and identification of the data. The table includes a variety of geographical information, such as geospatial data in the form of MultiPolygon structures, geographic centroids, and the X and Y coordinates of the center of these geographic shapes. This geospatial data is presented using the WGS 84 coordinate reference system, with the longitude given first, followed by the latitude. In addition, the table hosts...
Historical Version Records of Municipalities 2013 (1:1,000,000 Scale)TSV
The 'table__history' is a historical data collection that is part of the 'tilastointialueet_kunta1000k_2013' dataset. This particular table presents an intriguing snapshot of the 'Kunnat 2013 (1:1 000 000)', translated to English as 'Municipalities 2013 (1:1 000 000)'. As a history table, it offers a version history of its base table rows, enriched with dates of extraction and unique identifiers for each row. The table includes additional columns '_start_date' and '_end_date' which signify the timestamps of data extraction, providing a temporal dimension to the data. If an '_end_date' entry is null, it signifies that the row is the most current version. Unique row identification is achieved by the combination of '_start_date' and '_row_number', the latter being the row number in the raw...

Column Descriptions

2013 Municipalities Spatial Distribution at 1:1 000 000 Scale

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row of the table was extracted from the data source.
_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'.
geom_geojson	string	This column holds the geographic data in GeoJSON format, a type of format for encoding a variety of geographic data structures.
geom_geotext	string	This column contains geospatial data in textual format.
geom_type	string	This column specifies the type of the geometric field, in this case, a MultiPolygon.
geom_centroid	string	This column contains the centroid or the geometric center of a shape.
geom_center_x	double	This column represents the X coordinate of the geometric center of a shape.
geom_center_y	double	This column represents the Y coordinate of the geometric center of a shape.
gml_id	string	This column contains a unique identifier for the geographic feature, named according to the Geography Markup Language (GML) standard.
kunta	string	This column refers to the municipality in Finland (kunta in Finnish).
name	string	This column contains the name of the municipality in English.
namn	string	This column contains the name of the municipality in Swedish, one of the official languages in Finland.
nimi	string	This column contains the name of the municipality in Finnish, the national language of Finland.
vuosi	long	This column indicates the year associated with the data row, which is 2013 in the given data.

Historical Version Records of Municipalities 2013 (1:1,000,000 Scale)

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source, contributing to the unique identification of each row in the version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. A null value indicates the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the source, contributing to the unique identification of each row in the version history table.
geom_geojson	string	Contains geojson formatted data, representing geographical features with their non-spatial attributes.
geom_geotext	string	Geospatial data in text format, providing a representation of various geographical features.
geom_type	string	The type of geographical object represented in the column, such as 'ST_MULTIPOLYGON'.
geom_centroid	string	The centroid or geometric center of a two-dimensional region, usually represented as a point.
geom_center_x	double	The x-coordinate of the geometric center of a region.
geom_center_y	double	The y-coordinate of the geometric center of a region.
gml_id	string	A unique identifier for each row.
kunta	string	A string data type that represents the municipality.
name	string	The English name of the municipality.
namn	string	Another representation of the municipality's name.
nimi	string	The municipality's name in another language.
vuosi	long	An integer data type that represents the year.

Additional Info

Last Updated	November 12, 2024
Created	November 11, 2024