Export and Import of Manure by Region

This dataset collection contains information about the export and import of manure by region. The tables in this collection are sourced from the website of Luke in Finland.

Tables

Export and Import of Manure by RegionTSV
This table contains data on the export and import of manure by region. The data is sourced from Luke, which is a web site from Finland (country code: FI). The table includes information such as the extraction date, row number, year, ELY center, variable, direction, type, and the export and import of manure. This data can be utilized in various data analytics scenarios such as analyzing trends in manure export and import over time, comparing the export and import volumes between different regions, and examining the types and directions of manure trade.
Export and Import of Manure by Region (Dim Elykeskus) - Version HistoryTSV
This table contains the version history of the rows in the 'Export and Import of Manure by Region - Dim Elykeskus' table. It provides information about the start date, end date, row number, code, and label of each version. The '_start_date' column indicates the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it means the row is the most recent version. The data in this table can be utilized in various data analytics scenarios, such as tracking changes over time, identifying trends in manure export and import by region, comparing different versions of the data, and analyzing the impact of updates on specific regions. The table is sourced from the website...
Export and Import of Manure by Region (Dimension Direction) History from Luke (Finland)TSV
This table contains the version history of the base table 'export_and_import_of_manure_by_region__dim_direction'. It tracks the changes in the data rows over time, indicating when a row was extracted from the data source and when it was replaced by a newer version. The table includes columns such as '_start_date', '_end_date', '_row_number', 'code', and 'label'. Instead of describing each individual column, let's explore a few potential applications of the data in this table for data analytics. One possible analysis could involve examining the changes in 'code' and 'label' over time to identify trends or patterns in the export and import of manure by region and direction. By comparing different versions of the rows, it is possible to gain insights into how the data has evolved over...
Export and Import of Manure by Region - Dimension TypeTSV
This table contains export and import data of manure categorized by region and dimension type. The data is sourced from 'Luke' website which originates from Finland (ISO country code: fi). The table includes columns such as '_extract_date', '_row_number', 'code', and 'label'. This data can be utilized in various data analytics scenarios, such as analyzing the trends in manure export and import by region, comparing different dimension types, and identifying patterns or correlations between manure exports and imports in different regions. Furthermore, it can assist in monitoring the overall manure trading activities in Finland and supporting decision-making processes related to the management of manure resources.
Export and Import of Manure by Region - ELY CentreTSV
This table contains data on the export and import of manure by region. The data is sourced from the website of Luke, which originates from the country Finland (ISO country code: 'fi'). The table includes columns such as '_extract_date' which represents the date of extraction, '_row_number' which indicates the row number, 'code' which represents the code related to a specific region, and 'label' which provides the label or name of the region. These data can be utilized in data analytics to analyze the trends and patterns of manure export and import across different regions in Finland, identify the regions with the highest and lowest export or import volumes, track the changes in export and import over time, and compare the manure trade between different regions.
Export and Import of Manure by Region - Variable DimensionTSV
This table contains data from the 'export_and_import_of_manure_by_region__dim_variable' database table sourced from the 'Luke' website in Finland. It provides information about the export and import of manure by region. The table includes columns such as '_extract_date', '_row_number', 'code', and 'label'. The data in this table can be utilized for data analytics purposes, such as analyzing trends and patterns in manure exports and imports across different regions. It can also be used to compare the quantities of manure exported and imported by region, identify regions with high or low export/import volumes, and track changes over time. This data is valuable for making informed decisions related to manure management and agriculture in Finland.
Export and Import of Manure by Region - YearTSV
This dataset contains information on the export and import of manure by region and year. The data is sourced from the Luke website, which is an agricultural research center in Finland (ISO country code: 'fi'). The table includes columns such as '_extract_date', '_row_number', 'code', and 'label'. The data in this table can be utilized in various data analytics scenarios, such as analyzing trends in manure imports and exports over time, identifying regions with the highest import or export volumes, and comparing manure trade between different years and regions.
Manure Export and Import by Region and DirectionTSV
This table provides information on the export and import of manure by region and direction. The data is sourced from the website of Luke, which is an organization in Finland (ISO country code 'fi'). The table contains information such as the extract date, row number, code, and label. The data in this table can be utilized for data analytics purposes to understand the trends and patterns in manure export and import across different regions. It can help in analyzing the flow of manure and identifying regions with high export or import activities. Additionally, the data can be used to track changes over time and assess the impact of manure import/export on agricultural practices and environmental sustainability.
Version History of Export and Import of Manure by RegionTSV
This table contains the version history of the rows extracted from the export and import of manure by region, dimension type dataset. It includes information about the start and end dates of each row version, as well as a unique row number, code, and label for identification purposes. The data in this table, sourced from the Luke website, originated from the country Finland (ISO country code: FI). The table can be utilized for various data analytics tasks such as tracking changes and trends in manure export and import by region and dimension type over time, conducting historical analysis, and comparing different versions of the data for insights and decision-making.
Version History of Export and Import of Manure by RegionTSV
This table contains the version history of the base table rows from the 'export_and_import_of_manure_by_regionfact' table. The rows in this table are extracted from the 'export_and_import_of_manure_by_regionfact' data source, which is sourced from the website of Luke. Luke is an organization that operates in Finland, a country with the ISO country code 'fi'. The table includes information such as the start date and end date of each row, the row number, the year, the elykeskus, the variable, the direction, the type, and the export and import of manure. The start date indicates the date when the row was extracted from the data source, while the end date indicates the date when a new version of the row was extracted. If the end date is null, it means that the row is the most recent...
Version History of Export and Import of Manure by Region and Year from Luke (Finland)TSV
This table contains the version history of the data from the 'Export and Import of Manure by Region' dataset, sourced from the Luke website, originating from Finland (ISO country code 'fi'). It is a historical record of the base table 'Export and Import of Manure by Region - Year' with additional columns '_start_date' and '_end_date'. The '_start_date' column represents the date when a specific version of a row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. This table provides valuable data for analyzing the export and import trends of manure by different regions and years. It enables data analysts to track changes...
Version History of Export and Import of Manure by Region: Variable Dimension (Source: Luke - Finland)TSV
This table contains the version history of the rows in the 'export_and_import_of_manure_by_region__dim_variable' table. Each row represents a record extracted from the 'Luke' data source, which originates from Finland. The row includes information about the start date, end date, row number, code, and label. The start date indicates when the row was extracted, while the end date shows the date when a new version of the row was extracted. If the end date value is null, it means that the row is the most recent version. The data in this table can be analyzed to understand the historical changes in the export and import of manure by region and variable, enabling insights into trends and patterns over time.

Column Descriptions

Export and Import of Manure by Region - Year

Column	Type	Comment
_extract_date	date	'Timestamp when the row was extracted from the source data.'
_row_number	long	'The number of the row within the table.'
code	int	'Identifier or code associated with the specific row.'
label	int	'Textual label or description for the specific row.'

Version History of Export and Import of Manure by Region and Year 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 of the row version.
code	int	The code associated with the row version.
label	int	The label or description associated with the row version.

Export and Import of Manure by Region - Dimension Type

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source.
_row_number	long	The sequential number of each row in the table.
code	string	The unique identifier for each record in the table.
label	string	The descriptive label associated with each record in the table.

Version History of Export and Import of Manure by Region

Column	Type	Comment
_start_date	date	Indicates the start date of the validity period for the row version.
_end_date	date	Indicates the end date of the validity period for the row version.
_row_number	long	Represents the unique identifier of the version history entry.
code	string	Contains the code associated with the base table row version.
label	string	Stores the label or name assigned to the base table row version.

Export and Import of Manure by Region - Variable Dimension

Column	Type	Comment
_extract_date	date	The date when the record was extracted from the source.
_row_number	long	The sequential number assigned to each row in the table.
code	string	The unique code representing a specific item.
label	string	The descriptive label assigned to a specific item.

Version History of Export and Import of Manure by Region: Variable Dimension (Source: 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	A unique identifier assigned to each row version.
code	string	The code associated with the row version.
label	string	The label describing the row version.

Export and Import of Manure by Region - ELY Centre

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier for each row in the table.
code	int	The code associated with a specific item.
label	string	The label or name associated with a specific item.

Export and Import of Manure by Region (Dim Elykeskus) - Version History

Column	Type	Comment
_start_date	date	The starting date of the validity period for the row version in the table.
_end_date	date	The ending date of the validity period for the row version in the table.
_row_number	long	A unique number assigned to each row version in the table.
code	int	The code associated with the row version in the table.
label	string	The label or name associated with the row version in the table.

Manure Export and Import by Region and Direction

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

Export and Import of Manure by Region (Dimension Direction) History 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	A sequential number assigned to each row version.
code	string	The code associated with the row version.
label	string	The label or name associated with the row version.

Export and Import of Manure by Region

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
year	int	The year of the data.
elykeskus	int	The regional center responsible for the data.
variable	string	The variable being measured or analyzed.
direction	string	The direction of the data, such as import or export.
type	string	The type of data or measurement.
export_and_import_of_manure	int	The export and import of manure data.

Version History of Export and Import of Manure by Region

Column	Type	Comment
_start_date	date	Indicates the start date of the validity period for the row version
_end_date	date	Indicates the end date of the validity period for the row version
_row_number	long	A unique identifier for each row
year	int	The year value associated with the data in the row
elykeskus	int	The center responsible for the data in the row
variable	string	The variable or parameter measured in the data row
direction	string	Indicates the direction of the data, such as incoming or outgoing
type	string	The type or category of the data in the row
export_and_import_of_manure	int	Indicates the export and import status of manure in the row

Additional Info

Last Updated	May 20, 2024
Created	September 29, 2023