FSA Audits Of Approved Meat Establishments

CREATE TABLE meat_establishments_audits_nov_2012_aug_2014 (
  "unnamed_0" VARCHAR  -- Unnamed: 0,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "n_2_animal_welfare_slaughterhouse_only_compliance_with_b671b9ce" VARCHAR  -- 2 Animal Welfare (Slaughterhouse Only) Compliance With The Welfare Of Animals At The Time Of Killing Regulations 2014 And Regulation (EC) No 1099/2009,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "hygienic_production" VARCHAR,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "environmental_hygiene" VARCHAR,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

CREATE TABLE meat_establishments_audits_sep_2014_jan_2016 (
  "competentauthority" VARCHAR,
  "tradingname" VARCHAR,
  "appno" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "address3" VARCHAR,
  "town" VARCHAR,
  "postcode" VARCHAR,
  "country" VARCHAR,
  "addresswithheld" 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_honey" VARCHAR  -- Part A, Section XVI: Honey,
  "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),
  "all_activities" VARCHAR,
  "species" VARCHAR,
  "remarks" VARCHAR,
  "poultry" VARCHAR,
  "bovine" VARCHAR,
  "caprine" VARCHAR,
  "lagomorphs" VARCHAR,
  "ovine" VARCHAR,
  "porcine" VARCHAR,
  "solipeds" VARCHAR,
  "ratite" VARCHAR,
  "wild_birds" VARCHAR,
  "wild_lagomorphs" VARCHAR,
  "wild_ungulates" VARCHAR,
  "wild_land_mammals_other_than_wild_ungulates_and_wild_lagomorphs" VARCHAR,
  "auction_hall" VARCHAR,
  "collection_centre" VARCHAR,
  "cutting_plant" VARCHAR,
  "cold_store" VARCHAR,
  "dispatch_centre" VARCHAR,
  "packing_centre" VARCHAR,
  "fresh_fishery_products_plant" VARCHAR,
  "factory_vessel" VARCHAR,
  "game_handling_establishment" VARCHAR,
  "liquid_egg_plant" VARCHAR,
  "mince_meat_establishment" VARCHAR,
  "meat_preparation_establishment" VARCHAR,
  "mechanically_separated_meat_establishment" VARCHAR,
  "purification_centre" VARCHAR,
  "producing_plant" VARCHAR,
  "processing_plant" VARCHAR,
  "reefer_vessel" VARCHAR,
  "re_wrappingand_repackaging_establishment" VARCHAR,
  "slaughterhouse" VARCHAR,
  "tannery" VARCHAR,
  "wholesale_market" VARCHAR,
  "freezer_vessel" VARCHAR,
  "geographiclocalauthority" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR
);