Baselight

Production: Crops And Livestock Products

@owid.animals_used_for_food

Loading...
Loading...

About this Dataset

Production: Crops And Livestock Products

Tables

Animals Used For Food

@owid.animals_used_for_food.owid_animals_used_for_food_1
  • 1.03 MB
  • 14370 rows
  • 39 columns
Loading...

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

Animals Used For Food

@owid.animals_used_for_food.owid_animals_used_for_food_2
  • 3.21 MB
  • 530487 rows
  • 28 columns
Loading...

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

Share link

Anyone who has the link will be able to view this.