Baselight
Sign In

Approved Food Establishments In Northern Ireland

Food Standards Agency

@ukgov.approved_food_establishments_in_northern_ireland

Loading...
Loading...

About this Dataset

Approved Food Establishments In Northern Ireland

A full list of establishments in Northern Ireland approved to handle, prepare or produce products of animal origin for which requirements are laid down in Regulation (EC) No 853/2004.
Publisher name: Food Standards Agency
Last updated: 2025-05-03T04:00:21Z

Tables

Approved Food Establishments In Northern Ireland As At 1 April 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_00a45d9a
  • 78.91 kB
  • 325 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_00a45d9a (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 September 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_0112c722
  • 79.37 kB
  • 338 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_0112c722 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 December 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_0728e51d
  • 78.96 kB
  • 328 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_0728e51d (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 December 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_0830e20d
  • 79.52 kB
  • 333 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_0830e20d (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 August2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_08b35d6f
  • 79.48 kB
  • 339 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_08b35d6f (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 April 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_13762ae7
  • 79.63 kB
  • 341 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_13762ae7 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 March 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_1c260ee6
  • 79.09 kB
  • 329 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_1c260ee6 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 May 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_1f3762a0
  • 79.5 kB
  • 338 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_1f3762a0 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 January 2025

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_22f0f5c9
  • 80.17 kB
  • 348 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_22f0f5c9 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 October 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_25323f7b
  • 79.83 kB
  • 345 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_25323f7b (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 April 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_2738c39e
  • 77.83 kB
  • 320 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_2738c39e (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 March 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_29319566
  • 77.7 kB
  • 320 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_29319566 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 October 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_35bf23fa
  • 79.44 kB
  • 330 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_35bf23fa (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 December 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_362ae83e
  • 79.58 kB
  • 341 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_362ae83e (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 February 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_37587d33
  • 79.6 kB
  • 342 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_37587d33 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 February 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_3b9d016b
  • 79.09 kB
  • 329 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_3b9d016b (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 January 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_45a9d434
  • 79.58 kB
  • 341 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_45a9d434 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 November 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_54eb676e
  • 78.91 kB
  • 327 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_54eb676e (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 May 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_59c56aad
  • 78.1 kB
  • 324 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_59c56aad (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 October 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_5ac362b7
  • 79.39 kB
  • 339 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_5ac362b7 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 July 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_5e60c60a
  • 79.05 kB
  • 328 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_5e60c60a (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 January 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_66b1fbb7
  • 79.56 kB
  • 334 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_66b1fbb7 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 June 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_6fc9e933
  • 78.24 kB
  • 325 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_6fc9e933 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 February 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_78c01986
  • 79.59 kB
  • 334 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_78c01986 (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Approved Food Establishments In Northern Ireland As At 1 November 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_7d9e7a3a
  • 79.42 kB
  • 339 rows
  • 71 columns
Loading... 
CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_7d9e7a3a (
  "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" VARCHAR,
  "y" VARCHAR,
  "addresswithheld" VARCHAR
);

Share link

Anyone who has the link will be able to view this.