Sample-Based Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects

This dataset collection contains information about animal protection inspections on production animal farms and the proportion of neglects. The data is sourced from the website of Luke, the Natural Resources Institute Finland, in the country of Finland.

Tables

Animal Protection Inspections and Proportion of Neglects in Production Animal FarmsTSV
This table contains data on animal protection inspections conducted on production animal farms and the proportion of neglects in a sample-based approach. The data is sourced from the web site of Luke, which originates from Finland (ISO country code 'fi'). The table includes columns such as 'year', 'animal_species', and 'data', which can be utilized in various data analytics scenarios. For example, the data can be analyzed to identify trends in animal protection inspections over time, assess the proportion of neglects for different animal species, and compare the data across different years and species.
Animal Protection Inspections on Production Animal Farms and Proportion of Neglect: Sample-based Inspections on Farms in FinlandTSV
This table contains data on animal protection inspections conducted on production animal farms, focusing on the proportion of neglects in different animal species. The data is sourced from the website of Luke, which is an organization in Finland (ISO country code: FI). It includes information such as the extraction date, row number, code, and label. This table can be utilized in data analytics to analyze the trends in neglects across different animal species over time, identify areas or farms with higher neglect rates, and assess the effectiveness of animal protection measures implemented on production animal farms in Finland.
Animal Protection Inspections on Production Animal Farms and Proportion of Neglects (Luke, Finland)TSV
This table contains data from 'Luke' website which originates from Finland (ISO country code: 'fi'). The table stores information about animal protection inspections on production animal farms and the proportion of neglects. This data can be utilized in various data analytics tasks such as analyzing trends in neglects over time, identifying farms with the highest number of neglect cases, assessing the effectiveness of animal welfare regulations, and comparing the level of neglects between different regions in Finland.
Animal Protection Inspections on Production Animal Farms and Proportion of Neglects in FinlandTSV
This table contains data on animal protection inspections conducted on production animal farms, specifically focusing on the proportion of neglects. The data is sourced from the website of 'Luke' which is an agricultural research center in Finland, a country with the ISO country code 'FI'. The table includes information such as the extraction date, row number, code, and label. The data in this table can be utilized in various data analytics scenarios, such as tracking the trend of neglects over time, identifying farms with the highest number of neglect cases, analyzing the distribution of neglects by different codes, or comparing the proportion of neglects across different years.
Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects (Version History)TSV
This table contains the version history of rows from the sample-based animal protection inspections on production animal farms and the proportion of neglects. It is a historical record of data sourced from the 'Luke' website, originating from Finland (ISO country code: FI). The rows in this table represent different versions of the base table, capturing the changes in the data over time. Each row is characterized by the columns '_start_date' and '_end_date', indicating the extraction dates of the row from the data source. The 'year' column represents the year of the inspection, while 'animal_species' provides information about the species of animals involved. The 'data' column contains the specific data related to the inspections and proportion of neglects. Finally, the...
Version History of Animal Protection Inspections on Production Animal Farms and Proportion of NeglectsTSV
The table contains the version history of inspections on production animal farms and the proportion of neglects along with the year dimension. It is sourced from the web site of Luke, which originates from Finland.
Version History of Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects (Data Source: Luke, Country: Finland)TSV
This table provides the version history of the rows in the base table 'sample_based_animal_protection_inspections_on_production_animal_farms_and_the_proportion_of_neglects__dim_data'. It contains additional columns '_start_date' and '_end_date' which represent the extraction dates of each row from the data source. The data in this table is sourced from the website of 'Luke' which originates from Finland (ISO country code: 'fi'). The table can be used for data analytics purposes, such as analyzing trends and changes in the animal protection inspections on production animal farms and the proportion of neglects over time. By examining the start and end dates, one can identify when each version of a row was extracted and observe any patterns or developments in the data. The code and label...
Version History of Sample-based Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects by Animal Species (From Luke, Finland)TSV
This table contains the version history of the base table 'sample_based_animal_protection_inspections_on_production_animal_farms_and_the_proportion_of_neglects__dim_animal_species'. It includes additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row from the data source. The data in this table is sourced from the website of 'Luke', a data source originating from Finland (ISO country code: fi). The table can be used for various data analytics purposes, such as analyzing trends in animal protection inspections on production animal farms, monitoring changes in the proportion of neglects over time based on different animal species, and identifying patterns or correlations in the data.

Column Descriptions

Animal Protection Inspections on Production Animal Farms and Proportion of Neglect: Sample-based Inspections on Farms in Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The number assigned to each row in the table.
code	string	A unique code assigned to each item.
label	string	A descriptive label for each item.

Version History of Sample-based Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects by Animal Species (From Luke, Finland)

Column	Type	Comment
_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 unique identifier for each row version.
code	string	The code associated with the row version.
label	string	The label or name given to the row version.

Animal Protection Inspections on Production Animal Farms and Proportion of Neglects (Luke, Finland)

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The sequential row number of the data.
code	string	A unique identifier code for each entry.
label	string	The label or name associated with an entry.

Version History of Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects (Data Source: Luke, Country: Finland)

Column	Type	Comment
_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 unique identifier for each row version.
code	string	The code associated with the row version.
label	string	The label associated with the row version.

Animal Protection Inspections on Production Animal Farms and Proportion of Neglects in Finland

Column	Type	Comment
_extract_date	date	The date on which the row was extracted from the source
_row_number	long	A sequential number assigned to each row in the table
code	int	The code associated with the data value
label	int	The label or description of the data value

Version History of Animal Protection Inspections on Production Animal Farms and Proportion of Neglects

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The unique identifier of a row version.
code	int	The code associated with the row version.
label	int	The label or description of the row version.

Animal Protection Inspections and Proportion of Neglects in Production Animal Farms

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number where the record is located.
year	int	The year when the data was recorded.
animal_species	string	The species of the animal being referred to.
data	string	The actual data being recorded for the specific animal species.
samplebased_animal_protection_inspections_on_production_animal_farms_and_the_proportion_of_neglects	int	The proportion of neglects found during sample-based animal protection inspections on production animal farms.

Animal Protection Inspections on Production Animal Farms and the Proportion of Neglects (Version History)

Column	Type	Comment
_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	A unique identifier for each row version in the table.
year	int	The year associated with the data.
animal_species	string	The species of the animal.
data	string	The data associated with the row version.
samplebased_animal_protection_inspections_on_production_animal_farms_and_the_proportion_of_neglects	int	The proportion of neglects found during sample-based animal protection inspections on production animal farms.

Additional Info

Last Updated	May 19, 2024
Created	May 16, 2024