Statistical Areas - ELY 1000K Comprehensive Dataset Collection

This dataset collection is a compilation of related data tables, sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The tables in this collection encompass a variety of information across different timeframes, ranging from 2014 to 2024. Each table within this collection contains related data, organized in a structured format, with columns and rows for easy interpretation and analysis. The data originates from the Statistics Finland's service interface (WFS). The dataset collection, overall, provides a comprehensive view of the statistical areas, making it immensely valuable for researchers, policymakers, and data analysts. This dataset is licensed under CC BY 4.0 (Creative Commons Attribution 4.0, https://creativecommons.org/licenses/by/4.0/deed.fi).

Tables

ELY Areas Data Table (Scale 1:1 000 000)TSV
The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), is a structured collection of data, part of the 'tilastointialueet_ely1000k' dataset. It contains information on ELY areas (Centres for Economic Development, Transport and the Environment) at a scale of 1:1,000,000, offering a comprehensive overview of these entities within Finland. The table contains several columns, each offering unique insights into the ELY areas. For instance, there are columns indicating unique identifiers, names of the ELY centres in various languages, and the year of data extraction. Specific columns like 'ely', 'name', 'namn', 'nimi', 'vuosi' offer detailed information about the ELY centres such as their ID, their Finnish and other language names, and the year of the data....
Version History of ELY Areas (1:1 000 000)TSV
The 'table__history' is a rich data table that maintains the version history of its base table rows. It forms part of the 'tilastointialueet_ely1000k' dataset collection and contains information about the ELY-areas, or 'Centre for Economic Development, Transport and the Environment' areas on a 1:1 000 000 scale, a concept relevant in Finland. The data is sourced from the 'Statistics Finland' (Tilastokeskus) website. The table is equipped with special columns to track the history of each row, with columns capturing the start and end dates for each row version. If the end date column is null, this indicates that the version is the most recent. Each row is uniquely identified by a combination of the start date and row number. The table also contains a range of geographical data,...

Column Descriptions

ELY Areas Data Table (Scale 1:1 000 000)

Column	Type	Comment
_extract_date	date	This column holds the date on which the specific row of data was extracted from the source. It helps in understanding when the data was last updated.
_row_number	long	This column contains the sequential row number from the data extracted from the source, unique for each extraction date. It helps in identifying each row of data uniquely in combination with the extract date.
ely	string	This column stores a coded string representation related to a specific region or area.
geom_geojson	string	This column holds the geographical data in GeoJSON format, representing the geography of the region or area in a spatial format that can be easily processed.
geom_geotext	string	This column contains the geographical data in a text format, which can be used to represent the geographical area or region.
geom_type	string	This column indicates the type of geometric data stored, such as 'ST_MULTIPOLYGON' or 'ST_POLYGON', giving an idea about the complexity of the geographical area represented.
geom_centroid	string	This column holds the geographical central point of the area or region represented, in POINT format.
geom_center_x	double	This column contains the X coordinate of the geographical center of the area or region represented.
geom_center_y	double	This column contains the Y coordinate of the geographical center of the area or region represented.
gml_id	string	This column holds a unique identifier for each row in GML (Geography Markup Language) format.
id	long	This column stores an integer value that serves as a unique identifier for each row of data.
name	string	This column contains the English name of the region or area represented in the data.
namn	string	This column holds the Swedish name of the region or area represented in the data.
nimi	string	This column contains the Finnish name of the region or area represented in the data.
vuosi	long	This column holds an integer value representing the year pertaining to the data.

Version History of ELY Areas (1:1 000 000)

Column	Type	Comment
_start_date	date	This column holds the date when the row was extracted from the data source. It forms a unique identifier combination with the '_row_number' column for each row in this history table.
_end_date	date	This column contains the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	This column contains the row number from the raw data extracted from the data source. It forms a unique identifier with the '_start_date' column for each row in this history table.
ely	string	This string type column holds the identifier for the Centre for Economic Development, Transport and the Environment in Finland.
geom_geojson	string	This column contains the geographical information in GeoJSON format, describing the geometry of the regions.
geom_geotext	string	This column holds the geographical information in WKT (Well-known text) format, describing the geometry of the regions.
geom_type	string	This column specifies the type of the geometry of the regions. It can be either 'ST_MULTIPOLYGON' or 'ST_POLYGON'.
geom_centroid	string	This column contains the geographical point that represents the centroid (geometric center) of the regions.
geom_center_x	double	This column holds the x-coordinate (longitude) of the geometric center of the regions.
geom_center_y	double	This column holds the y-coordinate (latitude) of the geometric center of the regions.
gml_id	string	This string type column contains the unique identifier for the geographical markup language data.
id	long	This integer type column holds the unique identifier for each row.
name	string	This string type column contains the English name of the Centre for Economic Development, Transport and the Environment.
namn	string	This column contains the Swedish name of the Centre for Economic Development, Transport and the Environment.
nimi	string	This column holds the Finnish name of the Centre for Economic Development, Transport and the Environment.
vuosi	long	This integer type column holds the year related to the data row.

Additional Info

Last Updated	November 11, 2024
Created	November 11, 2024