Production: Crops And Livestock Products

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
);