Version History of Regions 2014 (1:1 000 000)
The 'table__history' is a comprehensive data collection that holds the version history of its base table rows. This table is a part of a larger dataset collection that includes potentially several related tables. This specific table is a history table, which means it stores the version history of data entries, allowing the tracking of changes over time. The table originates from the 'Tilastokeskus' (Statistics Finland) website from Finland.
The table includes critical columns like '_start_date', '_end_date', and '_row_number'. Together, '_start_date' and '_row_number' uniquely identify each row in this table. The '_start_date' represents the date when the row was extracted from the data source, and '_end_date' signifies when a new version of the row was extracted. If the '_end_date' is null, it implies that the row is the most current version.
Additionally, this table contains geographic information in columns starting with 'geom_', which is crucial 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 base table content description indicates 'Regions 2014 (1:1 000 000)', suggesting it contains information about different regions for the year 2014. The data in this table could be useful in various data analytics scenarios. For instance, researchers could track the changes in geographic boundaries of regions over time, or policy makers could analyze population changes in different regions based on data updates.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This, along with the '_row_number', uniquely identifies each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. This, along with the '_start_date', uniquely identifies each row in this version history table. |
| geom_geojson | string | Contains geographical data in the GeoJSON format. This data represents the shape and location of the region. |
| geom_geotext | string | Contains geographical data in text format. This data represents the shape and location of the region. |
| geom_type | string | Specifies the type of the geographical object represented in 'geom_geojson' and 'geom_geotext'. In this case, it is a multipolygon. |
| geom_centroid | string | Contains the geographical coordinates of the centroid of the region represented by the 'geom_geojson' and 'geom_geotext'. |
| geom_center_x | double | Provides the x-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext'. |
| geom_center_y | double | Provides the y-coordinate of the center of the region represented by the 'geom_geojson' and 'geom_geotext'. |
| gml_id | string | The unique identifier of the region in the original data source. |
| maakunta | string | A string representing the region. It is a unique identifier for each region. |
| name | string | The English name of the region. |
| namn | string | The Swedish name of the region. |
| nimi | string | The Finnish name of the region. |
| vuosi | long | The year when the data was collected. This is an integer value. |
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 | f43fe090-4bc5-4bfd-a4ff-7552f43626da |
| Package id | 385633e8-883c-4faf-8470-473bf012d89b |
| Position | 1 |
| Revision id | 3486596b-71a8-4c19-851f-78f024dd1f45 |
| State | active |
| Table | tilastointialueet_maakunta1000k_2014__table__history |