Historical Version Records of Municipalities 2013 (1:1,000,000 Scale)
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 data extracted from the source.
The table also exhibits a rich array of geographic data under columns starting with 'geom_'. This includes geographic coordinates presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These coordinates, along with other geospatial data can be leveraged for geospatial data analytics. For instance, the 'geom_centroid' column provides the geographic center of each municipality, and could be used to calculate distances between municipalities or to plot the municipalities on a map.
Data analytics can further use the data to study the evolution of municipalities over time, assess changes in their geographic boundaries, or even build predictive models for future changes. The 'vuosi' (year) column can be particularly useful in time-series analysis.
The 'table__history' is sourced from the website of 'Tilastokeskus' (Statistics Finland), based in Finland.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | c37e3e01-4ec6-4b9c-b285-c50916e563b4 |
| Package id | ed67b535-ad6f-415d-a526-5182deea8cdc |
| Position | 1 |
| Revision id | 26362ff6-6abf-4203-aded-66060cf70ca4 |
| State | active |
| Table | tilastointialueet_kunta1000k_2013__table__history |