Name: Register Of Quota Holdings Fixed Quota Allocation (FQA Register)
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Register Of Quota Holdings Fixed Quota Allocation (FQA Register)

The FQA (Fixed Quota Allocation) Register is a list of fishing vessel licence and entitlement holders who hold FQA units. Details are given of the FQA units attributable to each licence and entitlement including for the latter those held on PO 'dummy licences' together with the provenance (beneficial holders) of such units. In line with the arrangements outlined in the Fisheries Concordat signed by UK ministers in May 2012, fish quotas that the UK receives from EU are first apportioned to each of the four fisheries administrations (FAs) by the UK Government on the basis of the FQA units associated with those licences administered by each FA. Once apportioned, respective FAs have discretion on how they allocate their share of the UK quotas. Please note that these data is now being updated in real time. The following link should take you the real time version, where all future update can be found: https://www.fqaregister.service.gov.uk/
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2024-09-15T08:30:00Z

Tables

Register Of Quota Holdings Fixed Quota Allocation (FQA Register)

@ukgov.register_of_quota_holdings_fixed_quota_allocation_fqa_register.register_of_quota_holdings_fixed_quota_allocation_fqa_register

208.38 KB
1181 rows
113 columns


CREATE TABLE register_of_quota_holdings_fixed_quota_allocation_fqa_register (
  "licence_entitlement_number" BIGINT,
  "licence_type" VARCHAR,
  "holding_type_relevant_only_to_dummy_licences" VARCHAR,
  "vessel_entitlement_part_of_producer_organisation_y_n" VARCHAR,
  "producer_organisation_name_or_sector" VARCHAR,
  "vessel_name" VARCHAR,
  "date_licence_entitlement_valid_to" VARCHAR,
  "company_individual_or_other" VARCHAR,
  "full_name" VARCHAR,
  "full_address" VARCHAR,
  "total_fqas" DOUBLE,
  "anglers_vii" DOUBLE,
  "greater_silver_smelt_v_vii" DOUBLE,
  "atlanto_scandian_herring" DOUBLE,
  "blue_ling_vi_vii" DOUBLE,
  "boarfish" DOUBLE,
  "black_scabbardfish_v_vii_xii" DOUBLE,
  "clyde_herring" DOUBLE,
  "cod_i_iib_spitz_bergen" DOUBLE,
  "cod_i_ii_norway" DOUBLE,
  "cod_vib" DOUBLE,
  "cod_viia" DOUBLE,
  "cod_viib_k" DOUBLE,
  "cod_nafo_xiv_greenland" DOUBLE,
  "cod_nafo_area_3m" DOUBLE,
  "deep_sea_shark_v_ix" DOUBLE,
  "faroes_cod_haddock" DOUBLE,
  "faroes_ling_blue_ling" DOUBLE,
  "faroes_other" DOUBLE,
  "faroes_redfish" DOUBLE,
  "faroes_saithe" DOUBLE,
  "forkbeard_v_vi_vii" DOUBLE,
  "greenland_halibut_i_ii_norway" DOUBLE,
  "greenland_halibut_v_xiv_greenland" DOUBLE,
  "greenland_halibut_ii_iv_vi" DOUBLE,
  "haddock_i_ii_norway" DOUBLE,
  "haddock_via" DOUBLE,
  "haddock_vib" DOUBLE,
  "haddock_vii" DOUBLE,
  "herring_viief" DOUBLE,
  "herring_viighjk" DOUBLE,
  "herring_viia_irish_sea" DOUBLE,
  "ling_iv" DOUBLE,
  "ling_vi_x_xii_xiv" DOUBLE,
  "mackerel_3a_4bc" DOUBLE,
  "mackerel_flex_box_iva" DOUBLE,
  "megrim_vii" DOUBLE,
  "nephrops_vii" DOUBLE,
  "norway_anglers" DOUBLE,
  "norway_ling" DOUBLE,
  "norway_nephrops" DOUBLE,
  "norway_others" DOUBLE,
  "norway_tusk" DOUBLE,
  "ns_anglers" DOUBLE,
  "ns_cod" DOUBLE,
  "ns_dabs_flounders" DOUBLE,
  "ns_spurdog" DOUBLE,
  "ns_haddock" DOUBLE,
  "ns_hake" DOUBLE,
  "ns_herring" DOUBLE,
  "ns_horse_mackerel" DOUBLE,
  "ns_lemons_witches" DOUBLE,
  "ns_mackerel" DOUBLE,
  "ns_megrim" DOUBLE,
  "ns_nephrops" DOUBLE,
  "norway_pout" DOUBLE,
  "ns_plaice" DOUBLE,
  "northern_prawn" DOUBLE,
  "ns_saithe" DOUBLE,
  "ns_sandeels" DOUBLE,
  "ns_skates_rays" DOUBLE,
  "ns_sole" DOUBLE,
  "ns_sprat" DOUBLE,
  "ns_turbot_brill" VARCHAR,
  "ns_whiting" DOUBLE,
  "plaice_viia" DOUBLE,
  "plaice_viide" DOUBLE,
  "plaice_viifg" DOUBLE,
  "plaice_viihjk" DOUBLE,
  "saithe_i_ii_norway" DOUBLE,
  "pollack_vii" DOUBLE,
  "redfish_va_iceland" DOUBLE,
  "redfish_i_ii_norway" DOUBLE,
  "redfish_v_iv_greenland" DOUBLE,
  "roundnose_grenadier_vb_vi_vii" DOUBLE,
  "saithe_vii" DOUBLE,
  "herring_ivc_viid" DOUBLE,
  "sole_viia" DOUBLE,
  "sole_viid" DOUBLE,
  "sole_viie" DOUBLE,
  "sole_viifg" DOUBLE,
  "sole_viihjk" DOUBLE,
  "sprats_viide" DOUBLE,
  "tusk_iv" DOUBLE,
  "tusk_v_vi_vii" DOUBLE,
  "northern_blue_whiting" DOUBLE,
  "whiting_viia" DOUBLE,
  "whiting_viibk" DOUBLE,
  "ws_anglers" DOUBLE,
  "ws_cod_via" DOUBLE
);