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

Fish farms by area

This dataset collection includes information about fish farms in Finland. The data is sourced from the web site of Luke (Natural Resources Institute Finland), which is the official website of the Finnish government organization responsible for promoting the sustainable use of natural resources. It provides data on fish farms located in various areas of Finland. The collection consists of one or more dataset tables containing detailed information about the fish farms, such as their names, locations, production numbers, and related attributes.

Tables

  • Fish Farms by AreaTSV

    This table contains data on fish farms by area in Ely Centre. The data is sourced from the website of Luke, which is an organization in Finland (ISO country code: fi). It provides information on fish farms including the extraction date, row number, code, and label. This data can be utilized for various data analytics purposes such as analyzing trends in fish farm distribution, identifying areas with a high number of fish farms, and comparing fish farm sizes in different regions.

  • Fish Farms by Area - FactTSV

    This table contains data on fish farms by area from the country Finland. The data is sourced from Luke, a web site that provides various information related to agriculture and forestry. The table includes information such as the extraction date of the data, row numbers, ELY centres, production lines, years, and fish farms. This data can be utilized in data analytics to analyze trends in fish farm production over different years, compare production between different ELY centres, understand the distribution of fish farms across different production lines, and track changes in fish farm numbers over time.

  • Fish Farms by Area, Year DimensionTSV

    This table provides information on fish farms in Finland sourced from the website of Luke (Natural Resources Institute Finland). The dataset includes data for different aquatic areas categorized by year. The table consists of four columns: '_extract_date', '_row_number', 'code', and 'label'. The '_extract_date' column represents the date when the data was extracted from the website. The '_row_number' column indicates the row number of each record. The 'code' column contains the unique code associated with each fish farm area. The 'label' column provides the corresponding label or name of the fish farm area. This table can be utilized in various data analytics scenarios, such as analyzing the distribution of fish farms across different years and areas, identifying trends in fish farm...

  • Fish Farms by Area: Production LineTSV

    This table contains data from the fish farming industry in Finland. It is sourced from the website of Luke, the Natural Resources Institute Finland. The data provides information about fish farms in various areas, along with production line details. The table consists of four columns: '_extract_date', which represents the date the data was extracted; '_row_number', which indicates the row number; 'code', which corresponds to a specific code related to the fish farms; and 'label', which represents the label associated with each code. This data can be utilized for various data analytics purposes, such as analyzing trends in fish farm production, identifying the distribution of fish farms across different areas, or studying the efficiency of production lines in the fish farming industry.

  • Historical Version of Fish Farms by Area in Ely Centre from Luke Website - FinlandTSV

    This table contains the version history of the rows in the 'Fish Farms by Area - Dim Elycentre' table. It is sourced from the website of Luke, which originates from Finland. The table provides information on the start and end dates of each version of the rows, along with a unique 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' is null, it means that the row is the most recent version. The data in this table can be utilized in data analytics for various purposes such as tracking changes over time, analyzing historical trends, identifying updates or modifications made to specific rows, and evaluating the...

  • Version History of Fish Farms by AreaTSV

    This table contains the version history of the rows in the 'fish_farms_by_area__fact' table. It is sourced from the website of Luke, which originates from Finland. The table provides information about the start and end dates of each version of the rows in the base table. The '_start_date' column represents the date when 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 value of the '_end_date' column is null, it indicates that the row is the most recent version. The table can be used for data analytics to analyze the changes and updates made to the fish farms data over time. By comparing the start and end dates, trends and patterns in fish farm production, location, and other attributes can be...

  • Version History of Fish Farms by Area and Production Line (from Luke - Finland)TSV

    The table contains the version history of the rows extracted from the data source of 'Luke' from Finland. It is a historical record of the base table 'fish_farms_by_area__dim_production_line'. The table includes columns such as '_start_date' and '_end_date' which indicate the extraction dates of each row version. The other columns, such as 'code' and 'label', provide additional information about the fish farms and production lines. The table is useful for conducting data analytics on the evolution and changes of fish farms and production lines over time. For example, it can be used to analyze the growth or decline of specific fish farm areas, track changes in production line labels, or identify trends in the fish farming industry in Finland.

  • Version History of Fish Farms by Area and YearTSV

    This table contains the version history of fish farm data by area and year. It is sourced from the 'Luke' website, which originates from Finland. The table provides historical records of fish farm data, including the start and end dates of each version. The table can be used for data analytics to track changes in fish farm statistics over time, analyze trends in different areas, compare production levels between years, and identify any changes or updates made to the data. It allows researchers and analysts to gain insights into the evolution of fish farming in Finland and make informed decisions based on the historical data.

Column Descriptions

Fish Farms by Area

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The sequential number of the row in the table.
code string A unique code assigned to an item.
label string The label or name given to an item.

Historical Version of Fish Farms by Area in Ely Centre from Luke Website - Finland

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

Fish Farms by Area - Fact

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier of the row.
elycentre string The identifier for the Ely Centre.
production_line string The identifier for the production line.
year int The year of the data.
fish_farms int The number of fish farms.

Version History of Fish Farms by Area

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 the row version.
elycentre string The identifier for the Ely Centre.
production_line string The identifier for the production line.
year int The year of the row version.
fish_farms int The identifier for the fish farms.

Fish Farms by Area: Production Line

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long The sequential number of the row in the dataset.
code string A code that represents a specific value or category.
label string A descriptive label or name associated with a code.

Version History of Fish Farms by Area and Production Line (from Luke - Finland)

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 number assigned to each row version
code string The code associated with the row version
label string The label associated with the row version

Fish Farms by Area, Year Dimension

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the data entry in the table.
code int The unique code assigned to the entry.
label int The label associated with the entry.

Version History of Fish Farms by Area and Year

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 for each row version in the table.
code int A code associated with the row version.
label int A label or description for the row version.

Additional Info

Last Updated May 20, 2024
Created October 1, 2023