Use of Pesticides and Active Substances on Some Crops
Tables
-
Use of Pesticides and Active Substances on Some Crops (Variable Dimension)TSV
This table provides information on the use of pesticides and active substances on some crops. The data is sourced from the website of Luke, which originates from Finland (ISO country code: FI). The table contains various columns such as 'extract_date', 'row_number', 'code', and 'label'. The data in this table can be utilized in data analytics to analyze the trends in pesticide usage on different crops, identify the most commonly used active substances, compare pesticide usage across different time periods, and assess the impact of pesticide usage on crop productivity and environmental sustainability.
-
Use of Pesticides and Active Substances on Some Crops by YearTSV
This table contains data on the use of pesticides and active substances on some crops in a specific year. The data is sourced from the web site of 'Luke', which is a research organization in Finland (ISO country code: 'fi'). It provides information on the extraction date, row number, code, and label. The data in this table can be utilized in data analytics to analyze pesticide usage trends, track the usage of specific active substances, compare pesticide usage across different crops, and identify any patterns or correlations between pesticide use and crop yield or quality.
-
Version History of Pesticide and Active Substance Usage on Crops in Finland (by Year)TSV
This table contains the version history of the rows in the 'use_of_pesticides_and_active_substances_on_some_cropsdim_year' table. Each row in this table represents a specific version of a row in the base table. The '_start_date' column indicates the date when the specific version was extracted from the data source. The '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' column value is null, it means that the row is the most recent version. The table is sourced from the web site of 'Luke', which is the Natural Resources Institute Finland's data source. The data originates from Finland, which has the ISO country code 'FI'. This table can be used for data analytics to track the changes and updates made to the...
-
Version History of Pesticides and Active Substances Usage on CropsTSV
This table contains the version history of the base table 'use of pesticides and active substances on some crops (Dimension Variable)'. It includes information about the use of pesticides and active substances on various crops over time. The table has additional columns compared to the base table: 'Start Date' and 'End Date', which represent the dates when the rows were extracted from the data source. The data is sourced from the website of 'Luke' which originates from Finland (ISO country code: FI). The table can be utilized in data analytics to analyze trends and patterns in pesticide usage on different crops, track changes over time, identify the most recent versions of rows, and perform historical analysis of pesticide data.
Column Descriptions
Use of Pesticides and Active Substances on Some Crops by Year
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The sequential number of the row in the table. |
code | int | A unique code assigned to each record in the table. |
label | int | The label or name associated with the record in the table. |
Version History of Pesticide and Active Substance Usage on Crops in Finland (by Year)
Column | Type | Comment |
---|---|---|
_start_date | date | '_start_date' represents the start date of the validity period for the row version. |
_end_date | date | '_end_date' indicates the end date of the validity period for the row version. |
_row_number | long | '_row_number' is the unique identifier for each row version in the table. |
code | int | 'code' is a column containing a code value associated with the row version. |
label | int | 'label' represents a descriptive label associated with the row version. |
Use of Pesticides and Active Substances on Some Crops (Variable Dimension)
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The sequential number of the row. |
code | string | The code associated with a particular item. |
label | string | The label or name given to a particular item. |
Version History of Pesticides and Active Substances Usage on Crops
Column | Type | Comment |
---|---|---|
_start_date | date | '_start_date' column indicates the start date of the validity period for the row version. |
_end_date | date | '_end_date' column indicates the end date of the validity period for the row version. |
_row_number | long | '_row_number' column represents the unique identifier of the row version. |
code | string | 'code' column stores the code associated with the row version. |
label | string | 'label' column contains a descriptive label for the row version. |
Additional Info
Last Updated | May 20, 2024 |
---|---|
Created | October 2, 2023 |