Institutions 2022: A Comprehensive Data Table from Finland
The table, belonging to the dataset collection 'oppilaitokset_oppilaitokset', contains a rich collection of data pertaining to 'Educational Institutions 2022', as sourced from the Finnish website, 'Tilastokeskus' (Statistics Finland). It is organized into a variety of columns, each holding specific information, and is part of a wider group of interrelated data tables.
Two special columns, '_extract_date' and '_row_number', provide context for the data extraction process. The '_extract_date' column indicates when the data was pulled from the source, while the '_row_number' helps to uniquely identify each row based on the extraction date.
The table also features a series of 'geom_' columns that contain geographic information, invaluable for geospatial data analytics. These columns provide detailed geographic coordinates using the WGS 84 coordinate reference system where longitude is presented first, followed by latitude.
The dataset could be used in a variety of ways in the field of data analytics. For instance, the geographic information could be leveraged to visualize the distribution of educational institutions across Finland. Analysts could also track changes over time using the '_extract_date' column, offering insights into the evolution of the educational landscape in Finland. Furthermore, the dataset could support strategic planning by revealing areas with a high or low density of certain types of educational institutions, guiding resource allocation and policy making.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| euref_x | double | A real data type column representing a geographical coordinate. |
| euref_y | double | A real data type column representing a geographical coordinate. |
| geom_geojson | string | Contains GeoJSON data, which is a format for encoding geographic data structures. |
| geom_geotext | string | Contains text representation of geographical data. |
| geom_type | string | Specifies the type of the geometry - in this case, a point. |
| geom_centroid | string | Contains the geographical point that represents the center (centroid) of the geometry. |
| geom_center_x | double | Represents the X coordinate of the center of the geometry. |
| geom_center_y | double | Represents the Y coordinate of the center of the geometry. |
| gml_id | string | A string identifier for the row, possibly linked to the source data. |
| olo | string | A column of string type, detailed description is unavailable. |
| oltyp | string | A string column, detailed description is unavailable. |
| oltyp_nimi | string | A string column, detailed description is unavailable. |
| onimi | string | A string column, detailed description is unavailable. |
| til_vuosi | long | An integer column representing a year. |
| tunn | string | A string column, detailed description is unavailable. |
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 | ab053edd-7256-4d03-b01c-aa6fbeb3f218 |
| Package id | b6ab36f5-17a0-41c7-9b8e-cda596f11a23 |
| Revision id | 96a008c7-2d4f-4e25-b1b1-73bd798b5ebb |
| State | active |
| Table | oppilaitokset_oppilaitokset__table |