FSA Audits Of Approved Meat Establishments

CREATE TABLE meat_establishments_audits_nov_2012_aug_2014 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "n_2_animal_welfare_slaughterhouse_only_compliance_with_b671b9ce" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "hygienic_production" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "environmental_hygiene" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

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_i_meat_of_domestic_ungulates" VARCHAR,
  "part_a_section_ii_meat_from_poultry_and_lagomorphs" VARCHAR,
  "part_a_section_iii_meat_of_farmed_game" VARCHAR,
  "part_a_section_iv_wild_game_meat" VARCHAR,
  "part_a_section_v_minced_meat_meat_preparations_and_mec_993a55ef" VARCHAR,
  "part_a_section_vi_meat_products" VARCHAR,
  "part_a_section_vii_live_bivalve_molluscs" VARCHAR,
  "part_a_section_viii_fishery_products" VARCHAR,
  "part_a_section_ix_raw_milk_and_dairy_products" VARCHAR,
  "part_a_section_x_eggs_and_egg_products" VARCHAR,
  "part_a_section_xi_frog_s_legs_and_snails" VARCHAR,
  "part_a_section_xii_rendered_animal_fats_and_greaves" VARCHAR,
  "part_a_section_xiii_treated_stomachs_bladders_and_intestines" VARCHAR,
  "part_a_section_xiv_gelatine" VARCHAR,
  "part_a_section_xv_collagen" VARCHAR,
  "part_a_section_xvi_honey" VARCHAR,
  "part_b_section_i_sprouts" VARCHAR,
  "part_a_all_sections" VARCHAR,
  "part_b_all_sections" VARCHAR,
  "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
);