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

Number of Pigs by Municipality on 1/4 in Finland

This dataset collection contains information about the number of pigs in different municipalities in Finland. The data is sourced from the website of Luke, the Natural Resources Institute Finland. Luke provides comprehensive statistics on pig populations in each municipality in the country. The dataset tables in this collection provide details on the number of pigs present on 1st April for various years. The data is organized by municipality, allowing users to analyze pig population patterns across different regions in Finland.

Tables

  • Historical Version of Number of Pigs by Municipality on 1/4 - Dimension Variable (Luke - Finland)TSV

    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...

  • Number of Pigs by Municipality on 1/4TSV

    This table contains data on the number of pigs by municipality in Finland downloaded from the web site of 'Luke'. The data includes information on the extraction date, row number, municipality code, and label. The municipality code represents the unique identifier for each municipality in Finland. This dataset can be utilized in various data analytics tasks, such as analyzing the distribution of pigs across different municipalities, identifying trends in pig populations over time, and comparing the pig populations of different regions within Finland. The data source, 'Luke', is an organization based in Finland (ISO country code 'fi') that provides agricultural and environmental data.

  • Number of Pigs by Municipality on 1/4, by YearTSV

    This table contains the number of pigs by municipality on 1/4 for each year. The data is sourced from the 'Luke' website, which originates from Finland (ISO country code 'FI'). The table consists of columns such as 'extract date', 'row number', 'code', and 'label'. These columns can be used in various data analytics scenarios to analyze the distribution and trends of pig populations across different municipalities and years in Finland.

  • Number of Pigs by Municipality on 1/4, Variable DimensionTSV

    This table contains information about the number of pigs by municipality on April 1st. The data is sourced from the website of Luke, which is the Natural Resources Institute Finland. It originates from Finland (ISO country code: FI). The table consists of columns '_extract_date', '_row_number', 'code', and 'label'. The data in this table can be utilized in data analytics to analyze trends in pig populations across different municipalities, monitor changes in pig numbers over time, study the distribution of pigs in different areas, and assess the impact of various factors on pig farming in Finland.

  • Version History of Number of Pigs by Municipality on 1/4TSV

    This table contains the version history of the 'Number of Pigs by Municipality on 1-4' dataset from 'Luke' website in Finland. It is a historical representation of the base table 'Number of Pigs by Municipality on 1-4'. The table includes information about the start and end date of each version, a unique row number, municipality code, and a label. The data in this table can be utilized in data analytics to track changes in the number of pigs in different municipalities over time, identify trends, analyze growth patterns, and compare pig populations between municipalities. The historical nature of the data allows for analyzing the evolution of pig populations in different regions of Finland.

  • Version History of Number of Pigs by Municipality on 1/4 in Finland from Data Source 'Luke'TSV

    This table contains the version history of the 'number_of_pigs_by_municipality_on_1_4__dim_year' table sourced from the web site of 'Luke'. The data in this table is extracted from a web page originating from Finland. The table includes the columns '_start_date' and '_end_date' which represent the extraction dates of each row. Additionally, the table includes the columns '_row_number', 'code', and 'label'. These columns contain data related to the number of pigs by municipality and the respective year. Analyzing this data can provide insights into the changing trends of pig populations across different municipalities and years. By comparing the start and end dates, one can track the changes and understand the progression of pig populations over time in Finland.

Column Descriptions

Number of Pigs by Municipality on 1/4, Variable Dimension

Column Type Comment
_extract_date date The date on which the data was extracted.
_row_number long The unique identifier for each row in the table.
code string The code associated with a particular label.
label string The description or name associated with a particular code.

Historical Version of Number of Pigs by Municipality on 1/4 - Dimension Variable (Luke - Finland)

Column Type Comment
_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.

Number of Pigs by Municipality on 1/4, by Year

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long The row number of the data entry in the table.
code int A unique code assigned to each entry.
label int The label or name associated with each code.

Version History of Number of Pigs by Municipality on 1/4 in Finland from Data Source 'Luke'

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 each row version.
code int The code associated with the row version.
label int The label or description of the row version.

Number of Pigs by Municipality on 1/4

Column Type Comment
_extract_date date The date the data was extracted
_row_number long The sequential row number
code int The code associated with the item
label string The label or description of the item

Version History of Number of Pigs by Municipality on 1/4

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 assigned to each row version
code int The code associated with the row version
label string The label or name of the row version

Additional Info

Last Updated May 20, 2024
Created October 1, 2023