Version History of Balance Sheet for Food Commodities (million kg)
Click here for a data sample
This table represents the version history of the rows in the 'balance_sheet_for_food_commodities_million_kg__fact' table. It contains additional columns '_start_date' and '_end_date' to track the extraction dates of the row versions. The data in this table is sourced from the website of 'Luke' which originates from the country Finland (ISO country code: FI). The table can be utilized in data analytics to analyze changes in the balance sheet for food commodities over time. Data analysts can use the 'year' column to explore trends and patterns in commodity balances. The 'commodity' column can be used to analyze the distribution of different food commodities. The 'data' column contains the actual data for each row version, which can be used for various calculations and comparisons. The 'balance_sheet_for_food_commodities' column indicates the specific balance sheet for which the row version belongs to. By analyzing the different versions of rows and their extraction dates, data analysts can gain insights into the historical changes in food commodity balances.
Field Descriptions
| Name |
Data type |
Description |
| _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 stores the row number of the version history. |
|---|
| year | int | This column contains the year associated with the base table row version. |
|---|
| commodity | string | This column represents the commodity associated with the base table row version. |
|---|
| data | string | This column stores the data associated with the base table row version. |
|---|
| balance_sheet_for_food_commodities | int | This column contains the balance sheet information for food commodities associated with the base table row version. |
|---|
