Version History of Fish Farms by Year from Luke (Finland)
Click here for a data sample
This table contains the version history of the fish farms and years. It represents a historical record of the base table 'fish_farms__dim_year'. Each row in this table represents a version of a fish farm and its associated year. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted from the data source. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table includes additional columns such as '_row_number', 'code', and 'label' which provide further information about each fish farm and year. The data in this table can be utilized for various data analytics purposes, such as tracking changes in fish farm attributes over time, analyzing trends in fish farm growth, and comparing the performance of different fish farms based on their codes and labels. The table's data is sourced from the web site of the Finnish Natural Resources Institute (Luke), which is based in Finland (ISO country code 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The row number of the version in the table. |
code | int | The code associated with the row version. |
label | int | The label associated with the row version. |