UK_Seafood_Import_Data.xlsx

UK fisheries landings and seafood import data were collated from archived (Marine Management Organisation) UK Sea Fisheries Statistics annual reports for years 1890-2020 and from the 'Seafish' Trade and Tariff tool for years 2010-2020. Data were extracted biannually. All seafood weights are standardised to metric tonnes.This excel data file includes: total domestic UK fisheries landings, total annual UK seafood imports, annual UK imports by country of export, total number of exporting countries for each year, and product specific UK imports by country of export. The weighted average distance seafood was imported from each year was also calculated using the distance between London and the capital city of the exporting countries, and the tonnes of seafood coming from each country.<b>Imports vs domestic landings</b>This excel tab contains data on total annual UK seafood landings, total annual seafood imports by exporting country, and total annual imports.Labelled columns:<b>Decade</b><b>Country: </b>UK (domestic landings) and country of origin of imports<b>Total tonnes of fish imported: </b>fish imports (tonnes) each year<b>Average: </b>average tonnage of imports from each country over the decade.<b>Year</b><b>Total Imports (tonnes): </b>total imports from all countries in a given year.<b>UK Domestic Landings (tonnes): </b>total domestic landings in a given year.<b>Number of exporting countries</b>This excel tab contains the total number of countries exporting seafood to the UK in a given year.Labelled columns:<b>Year</b><b>No. countries: </b>total number of countries exporting seafood to the UK (data from UK Sea Fisheries Statistics reports)<b>No. countries (Seafish data): </b>total number of countries exporting seafood to UK (data from Seafish, years 2010-2020)<b>Seafood Products</b>This excel tab contains data on the different seafood products exported to the UK, by country of export. It also includes a table of the top 25 exporters to the UK, with associated primary exported product each year.Labelled columns:<b>Year</b><b>Country: </b>exporting country<b>Product/Species: </b>tonnes of each seafood product exported by each country<b>Products standardised</b>This excel tab contains the top ten seafood product imports (by weight over the time-series) by country of export, with other species/products being grouped into 'misc. fish' and 'misc. shellfish' categories.Labelled columns:<b>Year</b><b>Country: </b>country exporting seafood product to UK<b>Cod: </b>imports (tonnes) by country of origin<b>Haddock: </b>imports (tonnes) by country of origin<b>Salmon: </b>imports (tonnes) by country of origin<b>Tuna: </b>imports (tonnes) by country of origin<b>Shrimps/prawns: </b>imports (tonnes) by country of origin<b>Sardines: </b>imports (tonnes) by country of origin<b>Herring: </b>imports (tonnes) by country of origin<b>Mackerel: </b>imports (tonnes) by country of origin<b>Plaice: </b>imports (tonnes) by country of origin<b>Fish &amp; Marine mammal products: </b>imports (tonnes) by country of origin<b>Fish (misc.): </b>imports (tonnes) by country of origin<b>Shellfish (misc.): </b>imports (tonnes) by country of origin<b>Product totals/ Top exporters</b>This excel tab includes tables of: total quantities (tonnes) of each seafood product imported into the UK each year; the total tonnages of each product exported to the UK over the time-series by the top 25 exporting countries; and the top exporters of each seafood product.<b>Distances</b>This excel tab contains data on the distance from London to the capital city of each exporting country. There are also calculations for the weighted average distance seafood products were imported from each year.Labelled columns:<b>Country: </b>all countries that the UK imported from<b>Distance (km): </b>distance between the exporting country and the UK

英国渔业上岸量与海产品进口数据，整理自1890-2020年存档的（海洋管理组织，Marine Management Organisation）英国海洋渔业统计年报，以及2010-2020年的"Seafish"贸易与关税工具。数据为半年提取一次，所有海产品重量均已标准化为公吨。

该Excel数据文件包含以下内容：英国国内渔业总上岸量、英国海产品年度总进口量、按出口国划分的英国年度进口量、各年度出口国总数，以及按出口国划分的英国特定产品进口量。此外，还利用伦敦与各出口国首都之间的距离及各国海产品进口吨数，计算了每年海产品进口的加权平均距离。

<b>Imports vs domestic landings</b>
该Excel标签页包含英国海产品年度总上岸量、按出口国划分的英国海产品年度总进口量及年度总进口量数据。标签列如下：
<b>Decade</b>（十年期）
<b>Country: </b>英国（国内上岸量）及进口来源国
<b>Total tonnes of fish imported: </b>每年鱼类进口量（吨）
<b>Average: </b>十年内各国进口量的平均吨数
<b>Year</b>（年份）
<b>Total Imports (tonnes): </b>特定年份所有国家的进口总量
<b>UK Domestic Landings (tonnes): </b>特定年份国内上岸总量

<b>Number of exporting countries</b>
该Excel标签页包含特定年份向英国出口海产品的国家总数。标签列如下：
<b>Year</b>（年份）
<b>No. countries: </b>向英国出口海产品的国家总数（数据来自英国海洋渔业统计年报）
<b>No. countries (Seafish data): </b>向英国出口海产品的国家总数（数据来自Seafish，2010-2020年）

<b>Seafood Products</b>
该Excel标签页包含按出口国划分的、向英国出口的各类海产品数据，还包括英国前25大出口国的表格及各国每年的主要出口产品。标签列如下：
<b>Year</b>（年份）
<b>Country: </b>出口国
<b>Product/Species: </b>各国出口的各类海产品吨数

<b>Products standardised</b>
该Excel标签页包含按出口国划分的、时间序列内重量排名前十的海产品进口数据，其他物种/产品被归入"misc. fish"（其他鱼类）和"misc. shellfish"（其他贝类）类别。标签列如下：
<b>Year</b>（年份）
<b>Country: </b>向英国出口海产品的国家
<b>Cod: </b>按来源国划分的进口量（吨）
<b>Haddock: </b>按来源国划分的进口量（吨）
<b>Salmon: </b>按来源国划分的进口量（吨）
<b>Tuna: </b>按来源国划分的进口量（吨）
<b>Shrimps/prawns: </b>按来源国划分的进口量（吨）
<b>Sardines: </b>按来源国划分的进口量（吨）
<b>Herring: </b>按来源国划分的进口量（吨）
<b>Mackerel: </b>按来源国划分的进口量（吨）
<b>Plaice: </b>按来源国划分的进口量（吨）
<b>Fish &amp; Marine mammal products: </b>按来源国划分的进口量（吨）
<b>Fish (misc.): </b>按来源国划分的进口量（吨）
<b>Shellfish (misc.): </b>按来源国划分的进口量（吨）

<b>Product totals/ Top exporters</b>
该Excel标签页包含以下表格：每年进口到英国的各类海产品总量（吨）；时间序列内前25大出口国向英国出口的各类产品总吨数；以及各类海产品的主要出口国。

<b>Distances</b>
该Excel标签页包含伦敦与各出口国首都之间的距离数据，还包含每年海产品进口的加权平均距离计算结果。标签列如下：
<b>Country: </b>英国所有进口来源国
<b>Distance (km): </b>出口国与英国之间的距离