Fish Farms Dataset Collection

Tables

• Fish Farms Area DimensionTSV

  This table contains data from 'Luke', which is the Natural Resources Institute Finland, on fish farms in Finland. The data in this table includes the extraction date, row number, code, and label. This table can be used for various data analytics purposes, such as analyzing the growth patterns of fish farms over time, identifying trends in the fish farming industry, and comparing different fish farm locations in Finland.

• Fish Farms Dimension by YearTSV

  This table contains information about fish farms in Finland. The data is sourced from the web site of Luke, which is the Natural Resources Institute Finland. It provides details such as the extraction date, row number, code, and label for each fish farm. This table can be utilized in data analytics to analyze the trends and patterns in the fish farming industry in Finland, identify the distribution of fish farms across different regions, track the changes in the number or size of fish farms over time, and compare the performance of different fish farms based on their labels. The information in this table can also be used to study the impact of fish farming on the local environment and the sustainability of the industry.

• Fish Farms FactTSV

  This table contains data on fish farms from the country of Finland. The data is sourced from the website of Luke. The table includes information such as the extraction date, row number, area, production line, year, and fish farms. The data in this table can be utilized in data analytics to analyze trends and patterns in fish farm production, identify the most productive areas and production lines, track changes in fish farm production over time, and compare the performance of different fish farms.

• Fish Farms Fact History from Luke Web Site in FinlandTSV

  This table contains the version history of the rows in the fish farms fact table. It provides information about the start and end dates of each version of the rows, as well as the area, production line, year, and fish farms associated with each version. The data in this table is sourced from the website of the Natural Resources Institute Finland (Luke), which originates from the country with the ISO country code 'FI', representing Finland. The table can be utilized in data analytics for various purposes, such as tracking changes in fish farm production over time, analyzing the effects of different production lines on fish farm performance, and identifying trends and patterns in fish farm area distribution across different years.

• History of Fish Farms Area (Luke - Finland)TSV

  This table contains the version history of the rows extracted from the 'Luke' website, originating from Finland. The data in this table is sourced from the base table 'fish_farms__dim_area'. The rows in this table are identified by a unique row number. The '_start_date' column indicates the date when a particular version of a row was extracted, 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 means that the row is the most recent version available. The 'code' column contains the code associated with each row, and the 'label' column provides a label or description for the row. This version history table serves as a valuable resource for data analytics. For example, it can be utilized to track...

• Production Line Dimension - Fish FarmsTSV

  The fish farms production line dimension table contains information about various production lines in fish farms. The data in this table is sourced from the website of Luke, which is an organization based in Finland (ISO country code: FI). This table includes information such as the extraction date, row number, code, and label for each production line. The data in this table can be utilized in data analytics for various purposes such as analyzing production trends, comparing performance across different production lines, and identifying patterns in fish farm production.

• Version History of Fish Farm Production Lines (Luke, Finland)TSV

  This table contains the version history of fish farms' production line information. It is sourced from the web site of 'Luke' which originates from the country Finland (ISO country code 'FI'). The table includes the start date and end date of each row, denoted by '_start_date' and '_end_date', respectively. Additionally, the table has columns for row number, production line code, and label. The data in this table can be utilized for various data analytics purposes, such as tracking changes in production line information over time, identifying trends in production line labels, or analyzing the lifecycle of different production lines in fish farms.

• Version History of Fish Farms by Year from Luke (Finland)TSV

  This table contains the version history of the fish farms and years. It represents a historical record of the base table 'fish_farms__dim_year'. Each row in this table represents a version of a fish farm and its associated year. 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 from the data source. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table includes additional columns such as '_row_number', 'code', and 'label' which provide further information about each fish farm and year. The data in this table can be utilized for various data analytics purposes, such as tracking changes in fish farm...