Version History of Average Variation in Butterfly Populations in Agricultural Environments
Click here for a data sample
This table contains the version history of the rows from the base table 'average_variation_in_butterfly_populations_in_agricultural_environments__dim_year'. The rows in this table represent the different versions of the butterfly populations in agricultural environments, with each row having a start date and an end date. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version. The table can be used for data analytics purposes, such as tracking the changes in butterfly populations over time in agricultural environments. By analyzing the start and end dates, researchers can examine the trends and fluctuations in butterfly populations and their impact on agricultural ecosystems. The data in this table is sourced from the web site of 'Luke' (Natural Resources Institute Finland) and originates from Finland (ISO country code 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | A timestamp indicating the start date of the validity period for the row version. |
_end_date | date | A timestamp indicating the end date of the validity period for the row version. |
_row_number | long | An auto-generated sequential number assigned to each row version in the table. |
code | int | A code that identifies the specific row version in the base table. |
label | int | A label or name associated with the row version in the base table. |