Historical Version Records for 'Regions 2021' Dataset Table
The 'table__history' is a rich source of geographic and historical data. It's part of a larger dataset collection designed to provide detailed information about regions in Finland. This specific table serves a key role in providing the version history of its base table rows, preserving a chronological record of the data.
The dataset was originally sourced from the Finnish website, 'Tilastokeskus' (Statistics Finland), a reliable authority for data on the country's regions.
The contents of the table are diverse and comprehensive. It includes a unique identification for each row, achieved through a combination of the row number and the date the row was extracted. This ensures that each version of the row is distinct and traceable in the table's history.
A key aspect of the table is its geospatial data. Several columns provide geographic details about the regions, presented in the WGS 84 coordinate reference system. This includes the type of geospatial shape (such as polygons or multipolygons) that describe the region's physical boundaries. Further, the table includes the coordinates of the geographic center of each region.
The table also contains columns detailing the region's name in different languages, including Finnish, Swedish, and English. Each record also includes the year it pertains to, providing a temporal context.
The 'table__history' is a valuable tool for data analytics. For instance, it could be used to track regional changes over time, providing insights into how regional boundaries or names may have evolved. Additionally, the geospatial data could be leveraged to analyze regional characteristics, such as size or proximity to other regions. The multilingual data could also be used to support international research or applications, ensuring accurate region identification across different languages.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | The date when the row was extracted from the data source, which helps in tracking the version history. |
_end_date | date | The date when a newer version of the row was extracted. If this is null, it indicates that the row is the most recent version. |
_row_number | long | The number of the row as it appears in the raw data from the data source. This, along with '_start_date', uniquely identifies each row in the version history. |
geom_geojson | string | A JSON representation of the geographical shape of the region. |
geom_geotext | string | A textual representation of the geographical shape of the region. |
geom_type | string | The type of geographical shape (e.g., multipolygon or polygon). |
geom_centroid | string | The coordinates of the center point of the geographical shape. |
geom_center_x | double | The X-coordinate of the center point of the geographical shape. |
geom_center_y | double | The Y-coordinate of the center point of the geographical shape. |
gml_id | string | A unique identifier for the row. |
maakunta | string | A code representing the region. |
name | string | The English name of the region. |
namn | string | The name of the region in Swedish. |
nimi | string | The name of the region in Finnish. |
vuosi | long | The year when the data was recorded. |
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 | 5d91e6d9-5e94-43ad-b7e5-f237f1fa57da |
Package id | beb44749-4b6c-4d13-96d1-77631d2e31ac |
Position | 1 |
Revision id | 4f8a42a7-3a06-4cd8-b7b4-63e8c9b5ea13 |
State | active |
Table | tilastointialueet_maakunta1000k_2021__table__history |