Animal Bites

Data on over 9,000 bites, including rabies tests

@kaggle.rtatman_animal_bites

Table List

1 table(118.33 KB)

Health Animalbites

@kaggle.rtatman_animal_bites.health_animalbites

118.33 KB
9003 rows
15 columns

bite_date Bite Date	speciesiddesc SpeciesIDDesc	breediddesc BreedIDDesc	genderiddesc GenderIDDesc	color Color	vaccination_yrs Vaccination Yrs	vaccination_date Vaccination Date	victim_zip Victim Zip	advissuedyndesc AdvIssuedYNDesc	wherebitteniddesc WhereBittenIDDesc	quarantine_date Quarantine Date	dispositioniddesc DispositionIDDesc	resultsiddesc ResultsIDDesc
1985-05-05 00:00:00	DOG	nan	FEMALE	LIG. BROWN	1	Thu Jun 20 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	40229	NO	BODY	Sun May 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	UNKNOWN	UNKNOWN
1986-02-12 00:00:00	DOG	nan	UNKNOWN	BRO & BLA			40218	NO	BODY	Wed Feb 12 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	UNKNOWN	UNKNOWN
1987-05-07 00:00:00	DOG	nan	UNKNOWN	nan			40219	NO	BODY	Mon May 07 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	UNKNOWN	UNKNOWN
1988-10-02 00:00:00	DOG	nan	MALE	BLA & BRO			nan	NO	BODY	Tue Oct 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	UNKNOWN	UNKNOWN
1989-08-29 00:00:00	DOG	nan	FEMALE	BLK-WHT			nan	NO	BODY		UNKNOWN	UNKNOWN
1989-11-24 00:00:00	DOG	nan	UNKNOWN	nan			40211	NO	BODY		UNKNOWN	UNKNOWN
1990-02-08 00:00:00	DOG	nan	FEMALE	BLACK/WHIT	1	Tue Feb 13 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	40203	NO	BODY	Mon Feb 12 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	UNKNOWN	UNKNOWN
1990-02-22 00:00:00	DOG	nan	MALE	BLK-WHT			nan	NO	BODY	Fri Feb 23 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	RELEASED	UNKNOWN
1990-08-02 00:00:00	DOG	nan	MALE	BROWN			nan	NO	BODY	Thu Aug 02 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	UNKNOWN	UNKNOWN
1990-08-19 00:00:00	DOG	nan	UNKNOWN	BRN-TAN			nan	NO	BODY	Mon Aug 20 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	RELEASED	UNKNOWN


CREATE TABLE health_animalbites (
  "bite_date" VARCHAR,
  "speciesiddesc" VARCHAR,
  "breediddesc" VARCHAR,
  "genderiddesc" VARCHAR,
  "color" VARCHAR,
  "vaccination_yrs" DOUBLE,
  "vaccination_date" TIMESTAMP,
  "victim_zip" VARCHAR,
  "advissuedyndesc" VARCHAR,
  "wherebitteniddesc" VARCHAR,
  "quarantine_date" TIMESTAMP,
  "dispositioniddesc" VARCHAR,
  "head_sent_date" TIMESTAMP,
  "release_date" TIMESTAMP,
  "resultsiddesc" VARCHAR
);