Historical Version of Number of Pigs by Municipality on 1/4 - Dimension Variable (Luke - Finland)
Click here for a data sample
This table contains the version history of the rows in the 'number_of_pigs_by_municipality_on_1_4__dim_variable' table. Each row in this table represents a specific version of a row in the base table. The '_start_date' column indicates the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' column has a null value, it means that the row is the most recent version. The 'code' column represents a code associated with the municipality, and the 'label' column contains the label of the variable. This data can be utilized in various data analytics tasks, such as tracking changes to the number of pigs in different municipalities over time, identifying trends or patterns in pig populations, and analyzing the impact of variables on the number of pigs in a particular municipality. The data in this table is sourced from the web site of Luke, which originates from Finland (ISO country code 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date indicating the beginning of the validity period for the row version. |
_end_date | date | The end date indicating the end of the validity period for the row version. |
_row_number | long | The number assigned to the row version to indicate its position in the version history. |
code | string | The code value associated with the row version. |
label | string | The label or name associated with the row version. |