Version History of Irrigation Methods by Production Sector
Click here for a data sample
This table contains the version history of rows from the base table 'irrigation_method_by_production_sectorfact'. The rows are extracted from the data source 'Luke' which originates from Finland (ISO country code 'fi'). The table includes columns '_start_date' and '_end_date' to indicate the extraction dates of each row. By analyzing the data in this table, one can gain insights into the changes over time in the 'irrigation_method_by_production_sectorfact' data. This historical data can be utilized for various data analytics purposes, such as identifying trends in irrigation methods used in different production sectors over the years or analyzing the effectiveness of specific irrigation methods in various contexts. The 'year' column provides information about the specific year each row corresponds to, while the 'production_sector' column specifies the sector of production. The 'method' column further describes the irrigation method used, and the 'irrigation_method' column provides additional details about the specific irrigation method employed in each case. The data in this table, combined with other relevant datasets, can facilitate comprehensive analysis and informed decision-making.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | A unique identifier for each row version in the version history table. |
year | int | The year corresponding to the row version. |
production_sector | int | The sector or industry associated with the row version. |
method | string | The method used in the row version. |
irrigation_method | int | The method of irrigation used in the row version. |