Historical Version Records of Regional Units 2024 (1:1 000 000)
The 'table__history' is a historical record of the 'Regions 2024 (1:1 000 000)' table, sourced from the Statistics Finland (Tilastokeskus) website. This table provides a rich set of data, including geographical and temporal information, which can be utilized for various purposes in data analytics. The table contains version history of its base table rows, which could be used to track changes over time in different regions.
The table includes geographic information, such as the type of geometry, geographical text, geojson, centroid, and center coordinates. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This geospatial data could be employed in geographical information systems (GIS) analytics to visualize and analyze the spatial patterns and relationships of different regions.
In addition to the geographic information, the table contains information about the region names in different languages, and a unique identifier for each region. Such multilingual data could be used in multi-cultural or international data analytics to understand regional differences and similarities.
Moreover, the table includes the start and end dates of the data extraction, which allows tracking the version history of each row. The row number, in combination with the start date, uniquely identifies each row in this history table. If the end date of a row is null, it indicates that the row is the most recent version. This historical data could be utilized to analyze the trend and evolution of the regions over time.
In summary, the 'table__history' provides a comprehensive set of data suitable for a wide range of data analytics applications, from GIS analytics and multi-cultural studies to trend analysis and historical research.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when each row was extracted from the data source. It, together with the '_row_number', uniquely identifies each row in the table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version. |
| _row_number | long | This column contains the row number in the raw data extracted from the data source. It is part of the unique identifier for each row when combined with '_start_date'. |
| geom_geojson | string | This column contains geometric data of the areas in the GeoJSON format, a widely used format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geographic data in a text format. |
| geom_type | string | This column indicates the type of the geometric data, whether it's a polygon or a multipolygon. |
| geom_centroid | string | This column contains the geometric center (centroid) of the area. |
| geom_center_x | double | This column represents the x-coordinate of the geometric center of the area. |
| geom_center_y | double | This column represents the y-coordinate of the geometric center of the area. |
| gml_id | string | This column contains a unique identifier for each row. |
| name | string | This column contains the English name of the area. |
| namn | string | This column contains the name of the area in another language. |
| nimi | string | This column contains the name of the area in another language. |
| seutukunta | string | This column contains a specific code representing the area. |
| vuosi | long | This column contains the year of the data. |
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 | 24dfbb5e-c5bc-4eb4-abc2-00de513d070c |
| Package id | 2b30b2b0-1662-4d20-8335-5907b4b9c5bd |
| Position | 1 |
| Revision id | 898ef092-cfb4-4c16-862f-e0e76f61b994 |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2024__table__history |