Version History of Fish Farms by Area
Click here for a data sample
This table contains the version history of the rows in the 'fish_farms_by_area__fact' table. It is sourced from the website of Luke, which originates from Finland. The table provides information about the start and end dates of each version of the rows in the base table. The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it indicates that the row is the most recent version. The table can be used for data analytics to analyze the changes and updates made to the fish farms data over time. By comparing the start and end dates, trends and patterns in fish farm production, location, and other attributes can be identified and analyzed.
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 number assigned to the row version. |
|---|
| elycentre | string | The identifier for the Ely Centre. |
|---|
| production_line | string | The identifier for the production line. |
|---|
| year | int | The year of the row version. |
|---|
| fish_farms | int | The identifier for the fish farms. |
|---|
