Basic Tillage of Agricultural Area by Region

This dataset collection contains information about the basic tillage of agricultural areas in different regions. The tables in this collection are sourced from the website of Luke, which is the Natural Resources Institute Finland. The data is specific to the country Finland.

Tables

Basic Tillage of Agricultural Area by Region - Dim InfoTSV
This table contains information on basic tillage of agricultural area by region. It is sourced from 'Luke' website, which originates from Finland (ISO country code 'fi'). The table provides data on the extraction date, row number, code, and label of various tillage activities. The data in this table can be utilized in data analytics to analyze the distribution and trends of basic tillage practices across different regions. It can also be used to compare the effectiveness of tillage methods in different agricultural areas.
Basic Tillage of Agricultural Area by Region - FactTSV
This table contains data on the basic tillage of agricultural area in different regions over the years. The data is sourced from the web site of 'Luke' which originates from Finland.
Basic Tillage of Agricultural Area by Region and YearTSV
This table provides information on the basic tillage of agricultural areas by region and year. The data is sourced from 'Luke' website, which originates from Finland.
Basic Tillage of Agricultural Area by Region in ELY CentreTSV
This table contains information on the basic tillage of agricultural areas by region. The data is sourced from the website of 'Luke' which originates from Finland.
Version History of Basic Tillage of Agricultural Area by RegionTSV
This table contains the version history of the rows in the 'Basic Tillage of Agricultural Area by Region' table. The data is sourced from the website of Luke, which is a Finnish organization. The table provides information about the tillage of agricultural areas in different regions. Each row represents a specific version of the data, with additional columns indicating the start and end dates of each version. The 'code' column contains a unique identifier for each region, while the 'label' column provides the corresponding label or name for the region. The table can be utilized in data analytics to track changes in the tillage of agricultural areas over time, compare tillage practices between different regions, and analyze trends in agricultural land use.
Version History of Basic Tillage of Agricultural Area by Region and YearTSV
This table contains the version history of the rows in the 'basic_tillage_of_agricultural_area_by_region__dim_year' table. It provides information on the basic tillage of agricultural areas by region, along with the years associated with each record. The table includes columns such as '_start_date', '_end_date', 'code', and 'label'. The '_start_date' column represents the date when the 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' value is null, it indicates that the row is the most recent version. The data in this table could be utilized in data analytics to analyze the historical trends and changes in basic tillage practices across different regions and years. It enables users to...
Version History of Basic Tillage of Agricultural Area by Region in ELY CentreTSV
This table contains the version history of the rows from the basic_tillage_of_agricultural_area_by_region__dim_ely_centre table. It includes information about the start and end dates of each row version. The data in this table is sourced from the website of 'Luke', an organization based in Finland (country ISO code 'fi'). The table can be used for data analytics purposes, such as tracking changes in the tillage of agricultural areas by region over time, identifying trends, and analyzing historical patterns.
Version History of Basic Tillage of Agricultural Area by Region in Finland from Luke WebsiteTSV
This table, sourced from the website of Luke, provides the version history of the base table 'basic_tillage_of_agricultural_area_by_region__fact'. It contains information related to the basic tillage of agricultural areas by region. The table includes the '_start_date' and '_end_date' columns, which represent the extraction dates of each row. The 'year' column represents the year in which the data was recorded. The 'ely_centre' column contains the name of the center for Economic Development, Transport and the Environment responsible for the region. The 'info' column provides additional information pertaining to the tillage of agricultural areas. Lastly, the 'basic_tillage_of_agricultural_area' column contains details about the actual tillage activities performed on the agricultural...

Column Descriptions

Basic Tillage of Agricultural Area by Region - Dim Info

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
code	string	The code associated with the entry.
label	string	The label or name of the entry.

Version History of Basic Tillage of Agricultural Area by Region

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	An internal identifier for the row version.
code	string	The code associated with the row version.
label	string	The label or name associated with the row version.

Basic Tillage of Agricultural Area by Region and Year

Column	Type	Comment
_extract_date	date	Date when the row was extracted.
_row_number	long	Sequential number assigned to each row.
code	string	Unique code assigned to each entry.
label	string	Label associated with each code.

Version History of Basic Tillage of Agricultural Area by Region and Year

Column	Type	Comment
_start_date	date	The date and time when the row version starts to be valid.
_end_date	date	The date and time when the row version is no longer valid.
_row_number	long	The sequential number assigned to each row version in the table.
code	string	The unique identifier associated with each row version.
label	string	The descriptive label or name for each row version.

Basic Tillage of Agricultural Area by Region - Fact

Column	Type	Comment
_extract_date	date	The date of data extraction.
_row_number	long	The row number of the data entry.
year	string	The year of the data entry.
ely_centre	int	The centre of the Ely.
info	string	Additional information about the data entry.
basic_tillage_of_agricultural_area	int	The basic tillage of the agricultural area.

Version History of Basic Tillage of Agricultural Area by Region in Finland from Luke Website

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 the row version.
year	string	The year value associated with the row version.
ely_centre	int	The ELY centre information associated with the row version.
info	string	Additional information related to the row version.
basic_tillage_of_agricultural_area	int	The basic tillage information of the agricultural area associated with the row version.

Basic Tillage of Agricultural Area by Region in ELY Centre

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source system.
_row_number	long	The unique identifier for each row in the table.
code	int	A code that represents a specific data value.
label	string	The label or name associated with a specific code.

Version History of Basic Tillage of Agricultural Area by Region in ELY Centre

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 of the version in the version history table.
code	int	The code associated with the row version.
label	string	The label associated with the row version.

Additional Info

Last Updated	May 20, 2024
Created	October 2, 2023