Slaughter Statistics
Department for Environment, Food and Rural Affairs
@ukgov.slaughter_statistics
Department for Environment, Food and Rural Affairs
@ukgov.slaughter_statistics
CREATE TABLE food_slaughter_supplies_1985_to_june_2015 (
"food_slgter_supplies_26jun15_csv" VARCHAR,
"by_quarter" VARCHAR,
"uk_production_total_meat" DOUBLE,
"total_imported" DOUBLE,
"total_exported_carcase_meat" DOUBLE,
"total_exported_live" DOUBLE,
"total_new_supply" DOUBLE,
"total_uk_production_as_of_supply" DOUBLE,
"uk_beef_and_veal_uk_production" DOUBLE,
"beef_and_veal_imported_fresh_and_chilled" DOUBLE,
"beef_and_veal_imported_frozen" DOUBLE,
"beef_and_veal_exported_carcase_meat" DOUBLE,
"beef_and_veal_exported_live" VARCHAR,
"beef_and_veal_totsl_new_supply" DOUBLE,
"beef_and_veal" DOUBLE,
"mutton_and_lamb_uk_production" DOUBLE,
"mutton_and_lamb_imported" DOUBLE,
"mutton_and_lamb_exported_carcase_weight" DOUBLE,
"mutton_and_lamb_exported_live" DOUBLE,
"mutton_and_lamb_total_new_supply" DOUBLE,
"mutton_and_lamb_uk_production_as_of_supply" DOUBLE,
"pigmeat_uk_production" DOUBLE,
"pigmeat_imported" DOUBLE,
"pigmeat_exported_carcase_weight" DOUBLE,
"pigmeat_exported_live" DOUBLE,
"pigmeat_total_new_supply" DOUBLE,
"pigmeat_uk_production_as_of_supply" DOUBLE,
"poultry_uk_production" DOUBLE,
"poultry_imported" DOUBLE,
"poultry_exported" DOUBLE,
"poultry_total_new_supply" DOUBLE,
"uk_production_as_a_poultry" DOUBLE
);
CREATE TABLE uk_annual_numbers_of_livestock_slaughtered_1973_to_2014 (
"uk_annual_numbers_of_livestock_slaughtered" VARCHAR,
"unnamed_1" VARCHAR,
"prime_cattle_calves_thousand_head" DOUBLE,
"prime_cattle_steers_thousand_head" DOUBLE,
"prime_cattle_heifers_thousand_head" DOUBLE,
"prime_cattle_young_bulls_thousand_head" VARCHAR,
"prime_cattle_total_thousand_head" DOUBLE,
"adult_cows_thousand_head" DOUBLE,
"adult_bulls_thousand_head" DOUBLE,
"adult_total_thousand_head" DOUBLE,
"sheep_lambs_thousand_head" DOUBLE,
"ewes_rams_thousand_head" DOUBLE,
"clean_pigs_thousand_head" DOUBLE,
"sows_boars_thousand_head" VARCHAR
);
CREATE TABLE uk_annual_numbers_of_livestock_slaughtered_by_country__b1ce5ea9 (
"uk_annual_numbers_of_livestock_slaughtered_by_country" VARCHAR,
"unnamed_1" VARCHAR,
"england_and_wales_prime_cattle_calves_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_steers_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_heifers_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_young_bulls_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_total_thousand_head" DOUBLE,
"england_and_wales_adult_cattle_thousand_head" DOUBLE,
"england_and_wales_sheep_lambs_thousand_head" DOUBLE,
"england_and_wales_ewes_rams_thousand_head" DOUBLE,
"england_and_wales_clean_pigs_thousand_head" DOUBLE,
"england_and_wales_sows_boars_thousand_head" VARCHAR,
"scotland_prime_cattle_calves_thousand_head" DOUBLE,
"scotland_prime_cattle_steers_thousand_head" DOUBLE,
"scotland_prime_cattle_heifers_thousand_head" DOUBLE,
"scotland_prime_cattle_young_bulls_thousand_head" DOUBLE,
"scotland_prime_cattle_total_thousand_head" DOUBLE,
"scotland_adult_cattle_thousand_head" DOUBLE,
"scotland_prime_cattle_sheep_lambs_thousand_head" DOUBLE,
"scotland_prime_cattle_ewes_rams_thousand_head" DOUBLE,
"scotland_prime_cattle_clean_pigs_thousand_head" DOUBLE,
"scotland_prime_cattle_sows_boars_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_calves_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_steers_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_heifers_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_young_bulls_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_total_thousand_head" DOUBLE,
"northern_ireland_adult_cattle_thousand_head" DOUBLE,
"northern_ireland_sheep_lambs_thousand_head" DOUBLE,
"northern_ireland_ewes_rams_thousand_head" DOUBLE,
"northern_ireland_clean_pigs_thousand_head" DOUBLE,
"northern_ireland_sows_boars_thousand_head" DOUBLE
);
CREATE TABLE uk_home_killed_annual_dressed_carcase_weights_average__dd7a4fa0 (
"uk_home_killed_annual_dressed_carcase_weights_average" BIGINT,
"prime_cattle_calves_kg_head" DOUBLE,
"prime_cattle_steers_kg_head" DOUBLE,
"prime_cattle_heifers_kg_head" DOUBLE,
"prime_cattle_young_bulls_kg_head" DOUBLE,
"prime_cattleaverage_kg_head" DOUBLE,
"adult_cows_kg_head" DOUBLE,
"adult_bulls_kg_head" DOUBLE,
"sheep_lambs_kg_head" DOUBLE,
"ewes_rams_kg_head" DOUBLE,
"clean_pigs_kg_head" DOUBLE,
"sows_boars_kg_head" DOUBLE
);
CREATE TABLE uk_home_killed_monthly_meat_production_based_on_statis_799779fa (
"uk_monthly_numbers_of_livestock_slaughtered_by_country_947cb194" VARCHAR,
"unnamed_1" VARCHAR,
"england_and_wales_prime_cattle_calves_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_steers_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_heifers_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_young_bulls_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_total_thousand_head" DOUBLE,
"england_and_wales_adult_cattle_thousand_head" DOUBLE,
"england_and_wales_sheep_lambs_thousand_head" DOUBLE,
"england_and_wales_ewes_rams_thousand_head" DOUBLE,
"england_and_wales_clean_pigs_thousand_head" DOUBLE,
"england_and_wales_sows_boars_thousand_head" VARCHAR,
"scotland_prime_cattle_calves_thousand_head" DOUBLE,
"scotland_prime_cattle_steers_thousand_head" DOUBLE,
"scotland_prime_cattle_heifers_thousand_head" DOUBLE,
"scotland_prime_cattle_young_bulls_thousand_head" DOUBLE,
"scotland_prime_cattle_total_thousand_head" DOUBLE,
"scotland_adult_cattle_thousand_head" DOUBLE,
"scotland_prime_cattle_sheep_lambs_thousand_head" DOUBLE,
"scotland_prime_cattle_ewes_rams_thousand_head" DOUBLE,
"scotland_prime_cattle_clean_pigs_thousand_head" DOUBLE,
"scotland_prime_cattle_sows_boars_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_calves_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_steers_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_heifers_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_young_bulls_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_total_thousand_head" DOUBLE,
"northern_ireland_adult_cattle_thousand_head" DOUBLE,
"northern_ireland_sheep_lambs_thousand_head" DOUBLE,
"northern_ireland_ewes_rams_thousand_head" DOUBLE,
"northern_ireland_clean_pigs_thousand_head" DOUBLE,
"northern_ireland_sows_boars_thousand_head" DOUBLE
);
CREATE TABLE uk_monthly_numbers_of_livestock_slaughtered_based_on_s_86b01d1c (
"updated_on" VARCHAR,
"unnamed_1" VARCHAR,
"n_17_sep_15" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"contact" VARCHAR,
"leigh_riley_room_201_2nd_floor_ykf_gtn_5137_5095" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR
);
CREATE TABLE uk_monthly_numbers_of_livestock_slaughtered_by_country_ba636886 (
"uk_monthly_numbers_of_livestock_slaughtered_by_country_947cb194" VARCHAR,
"unnamed_1" VARCHAR,
"england_and_wales_prime_cattle_calves_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_steers_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_heifers_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_young_bulls_thousand_head" DOUBLE,
"england_and_wales_prime_cattle_total_thousand_head" DOUBLE,
"england_and_wales_adult_cattle_thousand_head" DOUBLE,
"england_and_wales_sheep_lambs_thousand_head" DOUBLE,
"england_and_wales_ewes_rams_thousand_head" DOUBLE,
"england_and_wales_clean_pigs_thousand_head" DOUBLE,
"england_and_wales_sows_boars_thousand_head" VARCHAR,
"scotland_prime_cattle_calves_thousand_head" DOUBLE,
"scotland_prime_cattle_steers_thousand_head" DOUBLE,
"scotland_prime_cattle_heifers_thousand_head" DOUBLE,
"scotland_prime_cattle_young_bulls_thousand_head" DOUBLE,
"scotland_prime_cattle_total_thousand_head" DOUBLE,
"scotland_adult_cattle_thousand_head" DOUBLE,
"scotland_prime_cattle_sheep_lambs_thousand_head" DOUBLE,
"scotland_prime_cattle_ewes_rams_thousand_head" DOUBLE,
"scotland_prime_cattle_clean_pigs_thousand_head" DOUBLE,
"scotland_prime_cattle_sows_boars_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_calves_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_steers_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_heifers_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_young_bulls_thousand_head" DOUBLE,
"northern_ireland_prime_cattle_total_thousand_head" DOUBLE,
"northern_ireland_adult_cattle_thousand_head" DOUBLE,
"northern_ireland_sheep_lambs_thousand_head" DOUBLE,
"northern_ireland_ewes_rams_thousand_head" DOUBLE,
"northern_ireland_clean_pigs_thousand_head" DOUBLE,
"northern_ireland_sows_boars_thousand_head" DOUBLE
);
CREATE TABLE uk_weekly_numbers_of_livestock_slaughtered_average_per_bedaf987 (
"uk_weekly_numbers_of_livestock_slaughtered_average_per_week" VARCHAR,
"n_5_week_months_also_occuring_in_a_53_week_year" VARCHAR,
"prime_cattle_calves_thousand_head" DOUBLE,
"prime_cattle_steers_thousand_head" DOUBLE,
"prime_cattle_heifers_thousand_head" DOUBLE,
"prime_cattle_young_bulls_thousand_head" VARCHAR,
"prime_cattle_total_thousand_head" DOUBLE,
"adult_cows_thousand_head" DOUBLE,
"adult_bulls_thousand_head" VARCHAR,
"total_thousand_head" DOUBLE,
"sheep_lambs_thousand_head" DOUBLE,
"ewes_rams_thousand_head" DOUBLE,
"clean_pigs_thousand_head" DOUBLE,
"sows_boars_thousand_head" VARCHAR
);
Anyone who has the link will be able to view this.