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

Annual Milk Production by Municipality in Finland

This dataset collection contains data on milk production by municipality on an annual basis. The tables in this collection are sourced from the website of 'Luke' (Natural Resources Institute Finland), which is an organization based in Finland. Luke provides comprehensive information and research on various natural resources, including agriculture and forestry. The dataset provides valuable insights into the milk production trends and patterns across different municipalities in Finland.

Tables

  • Annual Milk Production by MunicipalityTSV

    This table contains annual milk production data by municipality. The data is sourced from the web site of Luke, which originates from Finland (ISO country code: 'fi'). The table provides information on the milk production for different years, municipalities, and variables. The 'milk_production' column represents the amount of milk produced. This table can be utilized in data analytics to analyze trends and patterns in milk production across different municipalities and years. It can also be used to compare milk production between municipalities, identify the highest and lowest producing municipalities, and calculate average milk production per year or per municipality.

  • Annual Milk Production by Municipality (Luke, Finland)TSV

    This table contains data on milk production by municipality on an annual basis. The data is sourced from Luke, an organization in Finland. It includes information such as the extraction date, row number, municipality code, and label. This table can be utilized in data analytics to analyze trends in milk production across different municipalities in Finland over time, identify top-performing municipalities in terms of milk production, and compare the milk production of different municipalities.

  • Annual Milk Production by Municipality - FinlandTSV

    This table contains annual data on milk production by municipality. The data is sourced from Luke, which is an agricultural research center in Finland. The table includes information such as the extraction date, row number, municipality code, and label. The data in this table can be utilized in various data analytics scenarios. For example, it can be used to analyze the trends and patterns of milk production across different municipalities in Finland over the years. It can also be used to compare the milk production of various municipalities and identify top producers. Additionally, the data can be used to calculate the average milk production per municipality and track the changes over time.

  • Historical Version History of Milk Production by Municipality AnnuallyTSV

    This table contains the version history of the rows extracted from the 'Milk Production by Municipality Annually Dim Variable' data source, which originates from the country Finland (ISO country code: 'fi'). The rows in this table represent different versions of the rows in the base table. Each row in this table has additional columns, namely '_start_date' and '_end_date', which specify the extraction dates of the respective row versions. The table can be used in data analytics to analyze the changes and trends in milk production by municipality over time. By comparing the '_start_date' and '_end_date' columns, it is possible to track the historical changes in the data and identify the most recent version of each row. This information can be further utilized to perform various analyses,...

  • Milk Production by Municipality Annually (Historical Data)TSV

    This table contains the version history of milk production data by municipality on an annual basis. It is sourced from the web site of the Natural Resources Institute Finland (Luke), originating from the country Finland (ISO country code 'FI'). The table provides information about the different versions of milk production data with the additional columns '_start_date' and '_end_date'. The value in the '_start_date' column represents the date at which a specific version of the data was extracted from the source, while the value in the '_end_date' column represents the date when a new version of the data was extracted. If the '_end_date' column value is null, it indicates that the row represents the most recent version of the data. The table can be used for data analytics purposes, such...

  • Version History of Milk Production by Municipality AnnuallyTSV

    This table contains the version history of rows from the 'milk_production_by_municipality_annually__dim_year' table. Each row represents a specific version of milk production data by municipality on an annual basis. The data in this table is sourced from the website of 'Luke', a research institute in Finland. The columns in this table include '_start_date' which indicates the date the row was extracted from the data source, '_end_date' which represents the date of the next version of the row, '_row_number' which uniquely identifies each row, 'code' which contains the unique code of the municipality, and 'label' which provides a descriptive label for the municipality. This historical data can be utilized in various data analytics tasks such as studying the trends and patterns in milk...

Column Descriptions

Annual Milk Production by Municipality (Luke, Finland)

Column Type Comment
_extract_date date The date when the data was extracted from the source system.
_row_number long The sequential number assigned to each row in the table.
code string The unique code associated with a specific item.
label string The descriptive label or name assigned to a specific item.

Historical Version History of Milk Production by Municipality Annually

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 number assigned to each row version in the table.
code string The code associated with the row version.
label string The label or name given to the row version.

Annual Milk Production by Municipality - Finland

Column Type Comment
_extract_date date The date on which the data was extracted.
_row_number long The row number of the record.
code int The code representing a certain value.
label int The label associated with a certain code.

Version History of Milk Production by Municipality Annually

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

Annual Milk Production by Municipality

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long A unique row identifier.
year int The year of the milk production data.
municipality int The name of the municipality where the milk is produced.
variable string The variable associated with the milk production.
milk_production int The quantity of milk produced in liters.

Milk Production by Municipality Annually (Historical Data)

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 row number or identifier of the row version.
year int The year of the milk production record.
municipality int The municipality associated with the milk production record.
variable string A variable or type of measurement for the milk production.
milk_production int The amount of milk production recorded for a specific year, municipality, and variable.

Additional Info

Last Updated May 20, 2024
Created October 2, 2023