Roadside Prices of Roundwood by Year

This dataset collection includes information about roadside prices of roundwood in Finland. It consists of one or more dataset tables sourced from the website of Luke, the Natural Resources Institute Finland.

Tables

Roadside Prices of Roundwood by YearTSV
This table contains data on the roadside prices of roundwood by year. It is sourced from 'Luke' website in Finland.
Roadside Prices of Roundwood by Year - Fact History (Source: Luke, Finland)TSV
This table contains the version history of the rows in the 'roadside_prices_of_roundwood_by_year__fact' table. It tracks the changes made to the rows over time by including additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the extraction date of each row from the data source, while the '_end_date' column indicates the date a new version of the same row was extracted. If a row has a null value in the '_end_date' column, it means it is the most recent version of the row. The data in this table is sourced from the 'Luke' website, which originates from Finland (ISO country code 'fi').
Roadside Prices of Roundwood by Year - FinlandTSV
This table contains roadside prices of roundwood by year. It provides data from the 'Luke' website, which originates from Finland.
Version History of Roadside Prices of Roundwood by YearTSV
This table contains the version history of the rows in the roadside prices of roundwood by year dimension table. It tracks the changes made to the base table rows over time. The table has additional columns '_start_date' and '_end_date', which indicate the extraction dates of each row version. The table is sourced from the Luke website, which originates from Finland (ISO country code 'fi'). It provides valuable data for data analytics purposes, allowing users to perform trend analysis, price comparison, and forecasting of roadside prices of roundwood by year. This data can be utilized to gain insights into the pricing trends, identify patterns, and make informed decisions in the forestry and wood industry.

Column Descriptions

Roadside Prices of Roundwood by Year - Finland

Column	Type	Comment
_extract_date	date	The date the data was extracted from the source system.
_row_number	long	The row number of the record in the table.
code	int	A unique code associated with the record.
label	int	A human-readable label that describes the record.

Version History of Roadside Prices of Roundwood by Year

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period for the row version.
_end_date	date	This column indicates the end date of the validity period for the row version.
_row_number	long	This column represents the sequential number assigned to each row version.
code	int	This column stores a code associated with the row version.
label	int	This column stores a label or description for the row version.

Roadside Prices of Roundwood by Year

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The index of the row in the table.
year	int	The year of the recorded data.
price_region	int	The region for which the price of roundwood is recorded.
roundwood_assortment	string	The type of roundwood assortment.
roadside_prices_of_roundwood	int	The prices of roundwood at the roadside.

Roadside Prices of Roundwood by Year - Fact History (Source: Luke, Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The unique identifier for each row version.
year	int	The year associated with the row version.
price_region	int	The region associated with the row version's price information.
roundwood_assortment	string	The type of roundwood assortment associated with the row version.
roadside_prices_of_roundwood	int	The roadside prices of roundwood associated with the row version.

Additional Info

Last Updated	May 20, 2024
Created	October 1, 2023