1. Home
  2. Datasets
  3. The Origin of Water Used for ...
To download the data set, please sign up or log in

The Origin of Water Used for Irrigation by Region

This dataset collection provides information on the origin of water used for irrigation by region. The collection consists of one or more dataset tables sourced from the website of Luke in Finland.

Tables

  • History of Water Origin for Irrigation by RegionTSV

    This table contains the version history of the rows in the 'the_origin_of_water_used_for_irrigation_by_region__dim_origin' table. It captures the changes in the rows over time by providing the start and end dates of each version. The table is sourced from the web site of 'Luke', which originates from the country Finland (ISO country code 'fi'). The table can be used for data analytics purposes, such as tracking the evolution of water sources used for irrigation by region. By analyzing the changes in the 'code' and 'label' columns over time, trends and patterns in the origin of water can be identified and studied.

  • Origin of Water Used for Irrigation by Region - YearTSV

    This table contains data from the web site of 'Luke', which is a data source from Finland. It provides information about the origin of water used for irrigation by region and year. The table includes columns such as '_extract_date', '_row_number', 'code', and 'label'. The data in this table can be used for various data analytics purposes, such as determining the distribution of water sources for irrigation across different regions and analyzing trends or patterns in the usage of water for irrigation over different years.

  • The Origin of Water Used for Irrigation by Region (Fact)TSV

    This table contains data on the origin of water used for irrigation by region. The data is sourced from the web site of Luke, which originates from Finland (ISO country code 'fi'). The table includes information such as the extraction date, row number, year, ELY centre, origin, and the specific origin of water used for irrigation. The data in this table can be utilized in various data analytics scenarios, such as analyzing the distribution of water sources for irrigation across different years and regions, identifying the most common water sources used for irrigation in specific ELY centres, or studying the trends in the origin of water used for irrigation over time.

  • The Origin of Water Used for Irrigation by Region in Ely CentreTSV

    This table contains information about the origin of water used for irrigation, categorized by region. The data is sourced from the website of Luke, which is a research organization in Finland. The table includes information about the extraction date, row number, code, and label. The data in this table can be utilized in data analytics to analyze patterns and trends in the origin of water used for irrigation across different regions in Finland.

  • Version History of the Origin of Water Used for Irrigation by Region in Ely Centre (Finland) - Luke WebsiteTSV

    This table contains a history of the versions of the rows from the base table 'The Origin of Water Used for Irrigation by Region - Dim Ely Centre'. It includes columns such as '_start_date', '_end_date', 'row_number', 'code', and 'label'. The '_start_date' column indicates 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 implies that the row is the most recent version. The data in this table can be utilized in various data analytics tasks. For example, it can be used to analyze the changes in water sources used for irrigation purposes by region over time. The information can also be aggregated to understand trends in water usage and identify areas...

  • Version History of Water Origin for Irrigation by Region over TimeTSV

    This table represents the version history of the rows in the base table 'the_origin_of_water_used_for_irrigation_by_region__dim_year' that captures information about the origin of water used for irrigation by region and year. The table contains additional columns compared to the base table: '_start_date' and '_end_date', which represent the extraction dates of the row versions. The data in this table is sourced from the website of 'Luke', which originates from Finland. The table allows for tracking changes in the origin of water used for irrigation over time, as each row version corresponds to a specific extraction date. The data in this table can be utilized in various data analytics scenarios, such as analyzing trends in water sources for irrigation across different regions and years,...

  • Version History of Water Origin Used for Irrigation by RegionTSV

    This table represents the version history of the rows in the base table 'The Origin of Water Used for Irrigation by Region - Fact'. It contains additional columns '_start_date' and '_end_date', which indicate the extraction dates of each row from the data source. The data in this table is sourced from the web site of 'Luke' which originates from the country Finland (ISO country code: FI). The table provides valuable information that can be utilized in various data analytics scenarios. For example, it can be used to analyze the changes over time in the origin of water used for irrigation in different regions. By tracking the start and end dates of each version, it is possible to understand the temporal patterns and trends in water sources for irrigation across different years and...

  • Water Origin for Irrigation by RegionTSV

    This table contains data on the origin of water used for irrigation, categorized by region. The data is sourced from Luke, which is an abbreviation for Natural Resources Institute Finland. The data is related to water resources and irrigation practices in Finland. It provides information on the extraction date and row numbers, as well as a code and label for each region. The table can be utilized in data analytics to analyze the distribution of water sources for irrigation across different regions in Finland, identify trends in water usage patterns, assess the impact of water availability on agricultural practices, and compare the utilization of different water sources for irrigation purposes.

Column Descriptions

The Origin of Water Used for Irrigation by Region (Fact)

Column Type Comment
_extract_date date The date of extraction for the record.
_row_number long The row number of the record in the table.
year int The year associated with the data entry.
ely_centre int The name of the Ely Centre.
origin string The origin of the data entry.
the_origin_of_water_used_for_irrigation int The origin of water used for irrigation.

Version History of Water Origin Used for Irrigation by Region

Column Type Comment
_start_date date The date when the row version becomes valid.
_end_date date The date when the row version becomes invalid.
_row_number long The unique number assigned to each row version in the table.
year int The year associated with the data in the row version.
ely_centre int The center of the ELY region where the data comes from.
origin string The origin of the data in the row version.
the_origin_of_water_used_for_irrigation int The description of the origin of water used for irrigation in the row version.

The Origin of Water Used for Irrigation by Region in Ely Centre

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier of the row.
code int The code corresponding to a particular entity or item.
label string The label or name associated with the entity or item.

Version History of the Origin of Water Used for Irrigation by Region in Ely Centre (Finland) - 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 A unique identifier for each row version in the table.
code int The code associated with the data in the row version.
label string The label or description associated with the data in the row version.

Water Origin for Irrigation by Region

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier for each row.
code string The code associated with a specific value.
label string The descriptive label for a specific value.

History of Water Origin for Irrigation by Region

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 A unique identifier for each row version.
code string A code associated with the row version.
label string A label or description for the row version.

Origin of Water Used for Irrigation by Region - Year

Column Type Comment
_extract_date date The date the data was extracted.
_row_number long A unique identifier for each row in the table.
code string A code that represents a specific concept or category.
label string A human-readable label or name for the concept or category.

Version History of Water Origin for Irrigation by Region over Time

Column Type Comment
_start_date date The start date indicating the beginning of the validity period of the row version
_end_date date The end date indicating the end of the validity period of the row version
_row_number long The row number of the version in the version history table
code string The code associated with the row version
label string The label or name associated with the row version

Additional Info

Last Updated May 20, 2024
Created October 2, 2023