Slaughter Statistics
Department for Environment, Food and Rural Affairs
@ukgov.slaughter_statistics
Department for Environment, Food and Rural Affairs
@ukgov.slaughter_statistics
Presents statistics on the slaughter of cattle, sheep and pigs, dressed carcase weights and meat production. Source agency: Environment, Food and Rural Affairs Designation: National Statistics Language: English Alternative title: Slaughter Statistics If you require the datasets in a more accessible format, please contact DEFRA.FISU@defra.gsi.gov.uk
Publisher name: Department for Environment, Food and Rural Affairs
Last updated: 2024-09-14T08:59:20Z
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 -- Total UK Production As % Of Supply,
"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 -- Mutton And Lamb UK Production As % Of Supply,
"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 -- Pigmeat UK Production As % Of Supply,
"poultry_uk_production" DOUBLE,
"poultry_imported" DOUBLE,
"poultry_exported" DOUBLE,
"poultry_total_new_supply" DOUBLE,
"uk_production_as_a_poultry" DOUBLE -- UK Production As A % Poultry
);CREATE TABLE uk_annual_numbers_of_livestock_slaughtered_1973_to_2014 (
"uk_annual_numbers_of_livestock_slaughtered" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"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 -- Sheep & Lambs Thousand Head,
"ewes_rams_thousand_head" DOUBLE -- Ewes & Rams Thousand Head,
"clean_pigs_thousand_head" DOUBLE,
"sows_boars_thousand_head" VARCHAR -- Sows & Boars Thousand Head
);CREATE TABLE uk_annual_numbers_of_livestock_slaughtered_by_country__b1ce5ea9 (
"uk_annual_numbers_of_livestock_slaughtered_by_country" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"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 Sheep & Lambs Thousand Head,
"england_and_wales_ewes_rams_thousand_head" DOUBLE -- England And Wales Ewes & Rams Thousand Head,
"england_and_wales_clean_pigs_thousand_head" DOUBLE,
"england_and_wales_sows_boars_thousand_head" VARCHAR -- England And Wales Sows & Boars Thousand Head,
"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 Sheep & Lambs Thousand Head,
"scotland_prime_cattle_ewes_rams_thousand_head" DOUBLE -- Scotland Prime Cattle Ewes & Rams Thousand Head,
"scotland_prime_cattle_clean_pigs_thousand_head" DOUBLE,
"scotland_prime_cattle_sows_boars_thousand_head" DOUBLE -- Scotland Prime Cattle Sows & Boars Thousand Head,
"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 Sheep & Lambs Thousand Head,
"northern_ireland_ewes_rams_thousand_head" DOUBLE -- Northern Ireland Ewes & Rams Thousand Head,
"northern_ireland_clean_pigs_thousand_head" DOUBLE,
"northern_ireland_sows_boars_thousand_head" DOUBLE -- Northern Ireland Sows & Boars Thousand Head
);CREATE TABLE uk_home_killed_annual_dressed_carcase_weights_average__dd7a4fa0 (
"uk_home_killed_annual_dressed_carcase_weights_average" BIGINT -- UK Home Killed Annual Dressed Carcase Weights (average),
"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 -- Sheep & Lambs Kg/head,
"ewes_rams_kg_head" DOUBLE -- Ewes & Rams Kg/head,
"clean_pigs_kg_head" DOUBLE,
"sows_boars_kg_head" DOUBLE -- Sows & Boars Kg/head
);CREATE TABLE uk_home_killed_monthly_meat_production_based_on_statis_799779fa (
"uk_monthly_numbers_of_livestock_slaughtered_by_country_947cb194" VARCHAR -- UK Monthly Numbers Of Livestock Slaughtered By Country (based On Statistical Months, Not Calendar Months),
"unnamed_1" VARCHAR -- Unnamed: 1,
"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 Sheep & Lambs Thousand Head,
"england_and_wales_ewes_rams_thousand_head" DOUBLE -- England And Wales Ewes & Rams Thousand Head,
"england_and_wales_clean_pigs_thousand_head" DOUBLE,
"england_and_wales_sows_boars_thousand_head" VARCHAR -- England And Wales Sows & Boars Thousand Head,
"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 Sheep & Lambs Thousand Head,
"scotland_prime_cattle_ewes_rams_thousand_head" DOUBLE -- Scotland Prime Cattle Ewes & Rams Thousand Head,
"scotland_prime_cattle_clean_pigs_thousand_head" DOUBLE,
"scotland_prime_cattle_sows_boars_thousand_head" DOUBLE -- Scotland Prime Cattle Sows & Boars Thousand Head,
"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 Sheep & Lambs Thousand Head,
"northern_ireland_ewes_rams_thousand_head" DOUBLE -- Northern Ireland Ewes & Rams Thousand Head,
"northern_ireland_clean_pigs_thousand_head" DOUBLE,
"northern_ireland_sows_boars_thousand_head" DOUBLE -- Northern Ireland Sows & Boars Thousand Head
);CREATE TABLE uk_monthly_numbers_of_livestock_slaughtered_based_on_s_86b01d1c (
"updated_on" VARCHAR -- Updated On:,
"unnamed_1" VARCHAR -- Unnamed: 1,
"n_17_sep_15" VARCHAR -- 17-Sep-15,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"contact" VARCHAR -- Contact:,
"leigh_riley_room_201_2nd_floor_ykf_gtn_5137_5095" VARCHAR -- Leigh Riley, Room 201, 2nd Floor, YKF, GTN: 5137–5095,
"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
);CREATE TABLE uk_monthly_numbers_of_livestock_slaughtered_by_country_ba636886 (
"uk_monthly_numbers_of_livestock_slaughtered_by_country_947cb194" VARCHAR -- UK Monthly Numbers Of Livestock Slaughtered By Country (based On Statistical Months, Not Calendar Months),
"unnamed_1" VARCHAR -- Unnamed: 1,
"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 Sheep & Lambs Thousand Head,
"england_and_wales_ewes_rams_thousand_head" DOUBLE -- England And Wales Ewes & Rams Thousand Head,
"england_and_wales_clean_pigs_thousand_head" DOUBLE,
"england_and_wales_sows_boars_thousand_head" VARCHAR -- England And Wales Sows & Boars Thousand Head,
"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 Sheep & Lambs Thousand Head,
"scotland_prime_cattle_ewes_rams_thousand_head" DOUBLE -- Scotland Prime Cattle Ewes & Rams Thousand Head,
"scotland_prime_cattle_clean_pigs_thousand_head" DOUBLE,
"scotland_prime_cattle_sows_boars_thousand_head" DOUBLE -- Scotland Prime Cattle Sows & Boars Thousand Head,
"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 Sheep & Lambs Thousand Head,
"northern_ireland_ewes_rams_thousand_head" DOUBLE -- Northern Ireland Ewes & Rams Thousand Head,
"northern_ireland_clean_pigs_thousand_head" DOUBLE,
"northern_ireland_sows_boars_thousand_head" DOUBLE -- Northern Ireland Sows & Boars Thousand Head
);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 -- 5 Week Months Also Occuring In A 53 Week Year,
"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 -- Sheep & Lambs Thousand Head,
"ewes_rams_thousand_head" DOUBLE -- Ewes & Rams Thousand Head,
"clean_pigs_thousand_head" DOUBLE,
"sows_boars_thousand_head" VARCHAR -- Sows & Boars Thousand Head
);Anyone who has the link will be able to view this.