Production: Crops And Livestock Products
@owid.animals_used_for_food
@owid.animals_used_for_food
CREATE TABLE owid_animals_used_for_food_1 (
"country" VARCHAR,
"year" INTEGER,
"cattle_killed" FLOAT,
"sheep_killed" FLOAT,
"goats_killed" FLOAT,
"pigs_killed" FLOAT,
"chickens_killed" FLOAT,
"rabbits_killed" FLOAT,
"ducks_killed" FLOAT,
"turkeys_killed" FLOAT,
"horses_killed" FLOAT,
"buffaloes_killed" FLOAT,
"geese_killed" FLOAT,
"camels_killed" FLOAT,
"pigeons_killed" FLOAT,
"snails_killed" FLOAT,
"donkeys_killed" FLOAT,
"game_killed" FLOAT,
"other_non_mammals_killed" FLOAT,
"other_rodents_killed" FLOAT,
"other_camelids_killed" FLOAT,
"mule_killed" FLOAT,
"cattle_alive" FLOAT,
"buffalo_alive" FLOAT,
"sheep_alive" FLOAT,
"goats_alive" FLOAT,
"pigs_alive" FLOAT,
"chickens_alive" FLOAT,
"turkeys_alive" FLOAT,
"horses_alive" FLOAT,
"donkeys_alive" FLOAT,
"mules_alive" FLOAT,
"rabbits_alive" FLOAT,
"bees_alive" FLOAT,
"ducks_alive" FLOAT,
"camels_alive" FLOAT,
"geese_alive" FLOAT,
"other_rodents_alive" FLOAT,
"other_camelids_alive" FLOAT
);
CREATE TABLE owid_animals_used_for_food_2 (
"country" VARCHAR,
"year" INTEGER,
"metric" VARCHAR,
"animal" VARCHAR,
"per_capita" BOOLEAN,
"estimate" VARCHAR,
"n_wild_fish_per_capita" FLOAT,
"n_farmed_fish_per_capita" FLOAT,
"n_farmed_crustaceans_per_capita" FLOAT,
"n_wild_fish" BIGINT,
"n_farmed_fish" BIGINT,
"n_farmed_crustaceans" BIGINT,
"n_wild_fish_low_per_capita" FLOAT,
"n_farmed_fish_low_per_capita" FLOAT,
"n_farmed_crustaceans_low_per_capita" FLOAT,
"n_wild_fish_low" BIGINT,
"n_farmed_fish_low" BIGINT,
"n_farmed_crustaceans_low" BIGINT,
"n_wild_fish_high_per_capita" FLOAT,
"n_farmed_fish_high_per_capita" FLOAT,
"n_farmed_crustaceans_high_per_capita" FLOAT,
"n_wild_fish_high" BIGINT,
"n_farmed_fish_high" BIGINT,
"n_farmed_crustaceans_high" BIGINT,
"n_animals_killed" BIGINT,
"n_animals_killed_per_capita" FLOAT,
"n_animals_alive" BIGINT,
"n_animals_alive_per_capita" FLOAT
);
Anyone who has the link will be able to view this.