Dataset: Approved Food Establishments In England And Wales

About this Dataset

Approved Food Establishments In England And Wales

A full list of establishments in England and Wales approved to handle, prepare or produce products of animal origin for which requirements are laid down in Regulation (EC) No 853/2004. A monthly snap shot, as of 1st of every month, is available in this dataset from January 2018. Prior to May 2022, this list contained details of establishments in all of the UK. Details of establishments in Northern Ireland can now be found here ( https://data.food.gov.uk/catalog/datasets/dae35822-ca4e-41a2-b2af-b10b6163085a ) and establishments in Scotland, here ( https://www.foodstandards.gov.scot/publications-and-research/publications/approved-premises-register ).
Publisher name: Food Standards Agency
Last updated: 2025-06-04T04:00:45Z

Tables

Approved Food Establishments As At 1 June 2025

@ukgov.approved_food_establishments.approved_food_establishments_as_at_1_june_2025

439.24 KB
5199 rows
71 columns


CREATE TABLE approved_food_establishments_as_at_1_june_2025 (
  "appno" VARCHAR,
  "tradingname" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "town" VARCHAR,
  "postcode" VARCHAR,
  "country" VARCHAR,
  "all_activities" VARCHAR,
  "part_a_section_0_general_activity_establishment" VARCHAR,
  "part_a_section_i_meat_of_domestic_ungulates" VARCHAR,
  "part_a_section_ii_meat_from_poultry_and_lagomorphs" VARCHAR,
  "part_a_section_iii_meat_of_farmed_game" VARCHAR,
  "part_a_section_iv_wild_game_meat" VARCHAR,
  "part_a_section_v_minced_meat_meat_preparations_and_mec_993a55ef" VARCHAR,
  "part_a_section_vi_meat_products" VARCHAR,
  "part_a_section_vii_live_bivalve_molluscs" VARCHAR,
  "part_a_section_viii_fishery_products" VARCHAR,
  "part_a_section_ix_raw_milk_and_dairy_products" VARCHAR,
  "part_a_section_x_eggs_and_egg_products" VARCHAR,
  "part_a_section_xi_frog_s_legs_and_snails" VARCHAR,
  "part_a_section_xii_rendered_animal_fats_and_greaves" VARCHAR,
  "part_a_section_xiii_treated_stomachs_bladders_and_intestines" VARCHAR,
  "part_a_section_xiv_gelatine" VARCHAR,
  "part_a_section_xv_collagen" VARCHAR,
  "part_a_section_xvi_highly_refined_product" VARCHAR,
  "part_b_section_i_sprouts" VARCHAR,
  "part_a_all_sections" VARCHAR,
  "part_b_all_sections" VARCHAR,
  "species" VARCHAR,
  "remarks" VARCHAR,
  "tse_feed_ban_registrations_authorisations" VARCHAR,
  "poultry" VARCHAR,
  "bovine" VARCHAR,
  "caprine" VARCHAR,
  "lagomorphs" VARCHAR,
  "ovine" VARCHAR,
  "porcine" VARCHAR,
  "solipeds" VARCHAR,
  "ratite" VARCHAR,
  "wild_birds" VARCHAR,
  "wild_lagomorphs" VARCHAR,
  "wild_ungulates" VARCHAR,
  "wild_land_mammals_other_than_wild_ungulates_and_wild_lagomorphs" VARCHAR,
  "auction_hall" VARCHAR,
  "collection_centre" VARCHAR,
  "cutting_plant" VARCHAR,
  "cold_store" VARCHAR,
  "dispatch_centre" VARCHAR,
  "packing_centre" VARCHAR,
  "fresh_fishery_products_plant" VARCHAR,
  "factory_vessel" VARCHAR,
  "game_handling_establishment" VARCHAR,
  "liquid_egg_plant" VARCHAR,
  "mince_meat_establishment" VARCHAR,
  "meat_preparation_establishment" VARCHAR,
  "mechanically_separated_meat_establishment" VARCHAR,
  "purification_centre" VARCHAR,
  "producing_plant" VARCHAR,
  "processing_plant" VARCHAR,
  "reefer_vessel" VARCHAR,
  "re_wrappingand_repackaging_establishment" VARCHAR,
  "slaughterhouse" VARCHAR,
  "tannery" VARCHAR,
  "wholesale_market" VARCHAR,
  "freezer_vessel" VARCHAR,
  "competentauthority" VARCHAR,
  "geographiclocalauthority" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "addresswithheld" VARCHAR
);