Roundwood Trade by Year (Version History)
Click here for a data sample
This table contains the version history of the rows in the 'roundwood_trade_by_year__fact' table. The rows in this table are extracted from the data source on different dates, and each row represents a specific version of the base table row. The columns in this table include '_start_date' which represents the date when the row was extracted, and '_end_date' which represents the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it indicates that the row is the most recent version of the base table row. The data in this table could be utilized in data analytics to track and analyze the changes that occurred over time in the roundwood trade by year. It can help in identifying trends, patterns, and fluctuations in roundwood trade for different years, price regions, and roundwood assortments. By comparing the different versions of the rows, analysts can gain insights into the historical changes in roundwood trade. The data in this table is sourced from the web site of 'Luke', which is an agricultural research institute in Finland (ISO country code: 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version in the table. |
|---|
| _end_date | date | The end date of the validity period of the row version in the table. |
|---|
| _row_number | long | The number of the row version in the table. |
|---|
| year | int | The year associated with the row version. |
|---|
| price_region | int | The region associated with the price in the row version. |
|---|
| roundwood_assortment | string | The type of round wood assortment in the row version. |
|---|
| roundwood_trade | int | The type of round wood trade in the row version. |
|---|
