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 March 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_7fb2da18

79.33 kB
335 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_7fb2da18 (
  "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 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_8a654bbb

79.6 kB
334 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_8a654bbb (
  "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 2025

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_8c9eeea6

80.02 kB
345 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_8c9eeea6 (
  "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 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_9dd20ecf

79.63 kB
341 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_9dd20ecf (
  "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 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_9de1fb53

78.15 kB
326 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_9de1fb53 (
  "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 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_a8046bc4

78.91 kB
327 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_a8046bc4 (
  "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 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_ad3e71de

79.08 kB
329 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_ad3e71de (
  "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 2025

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_bbd4b84c

80.11 kB
346 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_bbd4b84c (
  "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 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_c95dd99d

79.44 kB
330 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_c95dd99d (
  "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 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_c9d899bc

79.41 kB
336 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_c9d899bc (
  "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 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_cb081dd5

78.23 kB
328 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_cb081dd5 (
  "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 2023

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_ccf9530f

79.46 kB
338 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_ccf9530f (
  "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 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_d1f34d65

79.7 kB
343 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_d1f34d65 (
  "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 2025

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_d3852ef2

80.4 kB
344 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_d3852ef2 (
  "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 2024

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_d6663ef3

80.18 kB
348 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_d6663ef3 (
  "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 2021

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_d6d6b148

78.29 kB
328 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_d6d6b148 (
  "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 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_e6da08dc

78.91 kB
325 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_e6da08dc (
  "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 August 2022

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_f0ee1952

79.18 kB
329 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_f0ee1952 (
  "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 2025

@ukgov.approved_food_establishments_in_northern_ireland.approved_food_establishments_in_northern_ireland_as_at_f4759bf2

80.14 kB
347 rows
71 columns

CREATE TABLE approved_food_establishments_in_northern_ireland_as_at_f4759bf2 (
  "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
);