Regions of 2017 at a 1:1,000,000 Scale
The table, part of a dataset collection, consists of a variety of information related to 'Regions 2017' (translated from Finnish 'Maakunnat 2017'). The data in the table is sourced from the 'Statistics Finland' (Tilastokeskus) website in Finland. It contains several columns with diverse types of data, which can be utilized for data analytics purposes.
The columns include two special ones, 'extract_date' and '_row_number'. The former indicates when the data row was extracted, while the latter specifies the row number in the extracted data. These two columns together make each data row uniquely identifiable. Additionally, there are multiple 'geom' prefixed columns that encapsulate geographic information, useful for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The data in the table can be utilized in various ways. For instance, the geographic information can be used to create visualizations of the regions, or 'maakunta', to gain a better understanding of the geographic distribution of the data. Similarly, the '_extract_date' and '_row_number' columns could be used to track the evolution of the data over time, revealing possible trends or patterns. Moreover, the table could be used to perform comparative studies on the data from different regions or years, potentially unearthing interesting insights.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column is a special field that contains the date when the data on the row of the table was retrieved from the data source. |
| _row_number | long | This special column records the row number in the data extracted from the source on the extract date specified by the _extract_date column. Combined with _extract_date, it uniquely identifies each row. |
| geom_geojson | string | This column contains Geospatial data in GeoJSON format representing geographical features. |
| geom_geotext | string | This column holds the Geospatial data in text format. |
| geom_type | string | This column describes the type of Geospatial data stored in the table. |
| geom_centroid | string | This column contains the centroid coordinates of the Geospatial data. |
| geom_center_x | double | This field denotes the x-coordinate of the center of the Geospatial data. |
| geom_center_y | double | This column indicates the y-coordinate of the center of the Geospatial data. |
| gml_id | string | This column holds a unique identifier for each row, which is a combination of the dataset name and row number. |
| maakunta | string | This column contains codes representing different provinces in Finland. |
| name | string | This column lists the English names of the provinces. |
| namn | string | This column provides the names of the provinces in Swedish. |
| nimi | string | This column includes the names of the provinces in Finnish. |
| vuosi | double | This column denotes the year 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 | c63eb2d2-159f-4111-a126-d0d897fffd59 |
| Package id | 9f5319d9-adf2-4760-8ab0-f7e0584a05a1 |
| Revision id | 7d492931-f476-4783-9c8d-7ca2f2717c22 |
| State | active |
| Table | tilastointialueet_maakunta1000k_2017__table |