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-07-02T04:06:40Z

Tables

Approved Food Establishments As At 1 July 2025

@ukgov.approved_food_establishments.approved_food_establishments_as_at_1_july_2025

450.4 kB
5,213 rows
71 columns

CREATE TABLE approved_food_establishments_as_at_1_july_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 0, General Activity Establishment,
  "part_a_section_i_meat_of_domestic_ungulates" VARCHAR  -- Part A, Section I, Meat Of Domestic Ungulates,
  "part_a_section_ii_meat_from_poultry_and_lagomorphs" VARCHAR  -- Part A, Section II, Meat From Poultry And Lagomorphs,
  "part_a_section_iii_meat_of_farmed_game" VARCHAR  -- Part A, Section III, Meat Of Farmed Game,
  "part_a_section_iv_wild_game_meat" VARCHAR  -- Part A, Section IV, Wild Game Meat,
  "part_a_section_v_minced_meat_meat_preparations_and_mec_993a55ef" VARCHAR  -- Part A, Section V, Minced Meat, Meat Preparations And Mechanically Separated Meat,
  "part_a_section_vi_meat_products" VARCHAR  -- Part A, Section VI, Meat Products,
  "part_a_section_vii_live_bivalve_molluscs" VARCHAR  -- Part A, Section VII, Live Bivalve Molluscs,
  "part_a_section_viii_fishery_products" VARCHAR  -- Part A, Section VIII, Fishery Products,
  "part_a_section_ix_raw_milk_and_dairy_products" VARCHAR  -- Part A, Section IX, Raw Milk And Dairy Products,
  "part_a_section_x_eggs_and_egg_products" VARCHAR  -- Part A, Section X, Eggs And Egg Products,
  "part_a_section_xi_frog_s_legs_and_snails" VARCHAR  -- Part A, Section XI, Frog S Legs And Snails,
  "part_a_section_xii_rendered_animal_fats_and_greaves" VARCHAR  -- Part A, Section XII, Rendered Animal Fats And Greaves,
  "part_a_section_xiii_treated_stomachs_bladders_and_intestines" VARCHAR  -- Part A, Section XIII, Treated Stomachs, Bladders And Intestines,
  "part_a_section_xiv_gelatine" VARCHAR  -- Part A, Section XIV, Gelatine,
  "part_a_section_xv_collagen" VARCHAR  -- Part A, Section XV, Collagen,
  "part_a_section_xvi_highly_refined_product" VARCHAR  -- Part A, Section XVI, Highly Refined Product,
  "part_b_section_i_sprouts" VARCHAR  -- Part B, Section I, Sprouts,
  "part_a_all_sections" VARCHAR  -- Part A, All Sections,
  "part_b_all_sections" VARCHAR  -- Part B, All Sections,
  "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
);