Historical Version Records of Regions 2023 (scale 1:4,500,000)
The history table, belonging to 'Seutukunnat 2023' dataset collection, stores critical data that reflects the version history of its base table rows. The table contains a variety of columns that hold valuable data, each with a unique purpose. It is sourced from the website of 'Tilastokeskus' in Finland.
The table has columns that contain the date when the row was extracted from the data source and the date when a new version of the row was extracted. If the end date is null, it indicates that the row is the most recent version. Together with the row number, these date columns uniquely identify each row in this version history table.
Geographic information is stored in columns that begin with 'geom_'. These columns can be used for geospatial data analytics. The geographic coordinates are represented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also includes columns that contain specific information such as the name of the region in different languages, the id of the region, and the year. These pieces of information can be beneficial for studies that involve regional analysis or studies that require chronological data.
Potential data analytics applications of this table could include studying trends over time based on the version history, performing geospatial analysis to understand regional characteristics, or conducting comparative studies between different regions based on the unique identifiers and names. The historical data could also provide valuable insights for predictive modeling and forecasting.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. |
| _end_date | date | This column indicates the date when a new version of the row was extracted from the data source. If it is null, it signifies that the row is the most recent version. |
| _row_number | long | This column represents the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains the geographical data of the area in GeoJSON format, which can include various types of geographical data structures such as polygons and multipolygons. |
| geom_geotext | string | This column holds the geographical data of the area in GeoTEXT format, another way of representing polygon and multipolygon structures. |
| geom_type | string | This column describes the type of geographical data structure used in 'geom_geojson' and 'geom_geotext' columns, such as polygon or multipolygon. |
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or the center point, of the area. |
| geom_center_x | double | This column holds the x-coordinate (longitude) of the centroid of the area. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the centroid of the area. |
| gml_id | string | This column contains a unique identifier for each row. |
| name | string | This column holds the English name of the area. |
| namn | string | This column contains the area's name in another language. |
| nimi | string | This column has the area's name in Finnish. |
| seutukunta | string | This column represents a code pertaining to the area. |
| vuosi | long | This column contains the year pertaining to the data row. |
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 | 97cdad07-6e4b-44d4-8a38-4718377eb11e |
| Package id | 88c8489a-62bf-4d37-a3e4-f3fef2b7f598 |
| Position | 1 |
| Revision id | 5ac8c788-4863-4cc1-9b2b-68427abe66ec |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2023__table__history |