Version History of Fish Farms by Year from Luke (Finland)

To download the data set, please sign up or log in

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_datedateThe start date of the validity period for the row version.
_end_datedateThe end date of the validity period for the row version.
_row_numberlongThe row number of the version in the table.
codeintThe code associated with the row version.
labelintThe label associated with the row version.

No sample for this dataset

Additional Information

Last updated May 12, 2024
Created May 12, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_luke
Extract date2018-09-29
Id00dd9fab-846e-4c20-baaf-3f53b916f499
Package id9e7c4223-2193-44c0-b14e-83a36ee84f5e
Position5
Revision idf83ac59a-5079-4322-a0a2-0790bed6778a
Stateactive
Tablefish_farms__dim_year__history