EMPRES Global Animal Disease Surveillance
Global animal disease outbreaks from the last 2 years
@kaggle.tentotheminus9_empres_global_animal_disease_surveillance
Global animal disease outbreaks from the last 2 years
@kaggle.tentotheminus9_empres_global_animal_disease_surveillance
Data downloaded from the EMPRES Global Animal Disease Information System.
Data shows the when, where and what of animal disease outbreaks from the last 2 years, including African swine fever, Foot and mouth disease and bird-flu. Numbers of cases, deaths, etc are also included.
This data is from the Food and Agriculture Organization of the United Nations. The EMPRES-i system can be access here
Read more about the details of the system here
CREATE TABLE outbreak_240817 (
  "id" BIGINT,
  "source" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "region" VARCHAR,
  "country" VARCHAR,
  "admin1" VARCHAR,
  "localityname" VARCHAR,
  "localityquality" VARCHAR,
  "observationdate" TIMESTAMP,
  "reportingdate" TIMESTAMP,
  "status" VARCHAR,
  "disease" VARCHAR,
  "serotypes" VARCHAR,
  "speciesdescription" VARCHAR,
  "sumatrisk" DOUBLE,
  "sumcases" DOUBLE,
  "sumdeaths" DOUBLE,
  "sumdestroyed" DOUBLE,
  "sumslaughtered" DOUBLE,
  "humansgenderdesc" VARCHAR,
  "humansage" DOUBLE,
  "humansaffected" DOUBLE,
  "humansdeaths" DOUBLE
);Anyone who has the link will be able to view this.