About this Dataset

Approved Food Establishments - Daily Update

A full list of establishments approved to handle, prepare or produce products of animal origin for which requirements are laid down in Regulation (EC) No 853/2004. This data is automatically updated daily at 7am to give the most up to date status of an Approved Food Establishment (as of close of business previous day). Note: the schema for this data differs to the monthly snap shot of the data 'Approved Food Establishment'. Multiple values within a column are now separated by double pipes '||'. TSE_Feed_ban_registrations_authorisations and X and Ys have been removed from the dataset.
Publisher name: Food Standards Agency
Last updated: 2025-01-28T04:03:18Z

Tables

Approved Food Establishments Daily Dataset

@ukgov.approved_food_establishments_daily_update.approved_food_establishments_daily_dataset

459.39 kB
5,529 rows
69 columns

CREATE TABLE approved_food_establishments_daily_dataset (
  "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,
  "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,
  "addresswithheld" VARCHAR,
  "inserteddate" TIMESTAMP
);