Annual Milk Production by Municipality 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 |