Number of Pigs on 1/4 - Dim Year History from Luke (Finland)
Click here for a data sample
This table contains the version history of the 'Number of Pigs on 1/4' data, sourced from the web site of Luke in Finland. It serves as a historical record of the base table 'Number of Pigs on 1/4'. The table includes the '_start_date' column indicating the extraction date, the '_end_date' column representing the date of the subsequent version, and additional columns specific to the base table such as '_row_number', 'code', and 'label'. The '_end_date' column contains null values for the most recent rows. The data in this table can be utilized in various data analytics scenarios, such as analyzing trends and changes in the number of pigs over time, identifying outliers or anomalies, and comparing the distribution of pigs across different categories, indicated by the 'code' and 'label' columns.
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 each row version in the table. |
|---|
| code | int | The code associated with the row version. |
|---|
| label | int | The label or description of the row version. |
|---|
