Version History of Municipalities (Scale 1:4,500,000)
The 'table__history' is a rich and comprehensive history table, capturing the version history of its base table rows. The table is part of a larger dataset collection, providing in-depth insights into the municipalities of Finland, as sourced from 'Tilastokeskus' (Statistics Finland).
This table comprises a variety of columns, each serving a unique purpose. For instance, the '_start_date' and '_end_date' columns represent the time span for which a specific version of a row remained valid. The '_row_number' column is used to identify each row uniquely in combination with '_start_date'. If '_end_date' is null, it indicates that the row is the most recent version.
Notably, the table includes several 'geom_' prefixed columns which hold geographic information. This can be utilized for geospatial data analytics, presenting geographic coordinates using the WGS 84 coordinate reference system, with the axis order of longitude first, followed by latitude.
The table also includes a number of other columns that capture detailed information about each municipality, such as its name, ID, and specific geographic details.
The data in this table can be utilized in various ways for data analytics. For instance, the geographic data can be used to perform spatial analysis and create detailed geographic visualizations of the municipalities. The version history can be leveraged to track changes over time, potentially revealing trends or patterns related to the municipalities. Furthermore, this data could also be combined with other socio-economic data to perform comprehensive, multifaceted analyses of Finland's municipalities.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It aids in tracking the changes in data over time in the 'table__history' table. |
| _end_date | date | This column denotes the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the latest version. |
| _row_number | long | This column contains the number of the row as it appeared in the original data from the data source. Together with '_start_date', it uniquely identifies each row in the history table. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. GeoJSON is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data in a textual format. It represents the shapes and locations of geographical entities. |
| geom_type | string | This column specifies the type of the geographical data structure, such as Polygon or MultiPolygon. |
| geom_centroid | string | This column contains the centroid of the geographical entity, represented as a point. |
| geom_center_x | double | This column contains the X-coordinate of the geographical entity's center. |
| geom_center_y | double | This column contains the Y-coordinate of the geographical entity's center. |
| gml_id | string | This column contains unique identifiers for each row, as provided by the data source. |
| kunta | string | This column represents a specific attribute of the dataset, as provided by the data source. |
| name | string | This column contains the English names of the entities. |
| namn | string | This column contains names of the entities in a different language. |
| nimi | string | This column also contains the names of the entities, possibly in another language. |
| vuosi | long | This column contains integer values, representing a specific attribute of the entities, possibly the year. |
No sample for this dataset
Additional Information
| Last updated | January 2, 2025 |
|---|---|
| Created | January 2, 2025 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2025-01-02 |
| Id | 69c2b713-e2db-42ae-8416-cddcaffd87d5 |
| Package id | 98d301a9-da2a-4c32-9071-f0263b6d101e |
| Position | 1 |
| Revision id | 933e414b-8a08-408e-aa89-0fec34a3d5c2 |
| State | active |
| Table | tilastointialueet_kunta4500k__table__history |