Adverse Food Events

90,000 product-related user-reported adverse medical events

@kaggle.fda_adverse_food_events

Table List

1 table(3.27 MB)

Caers Ascii 2004–2017q2

@kaggle.fda_adverse_food_events.caers_ascii_2004_2017q2

3.27 MB
90786 rows
12 columns

ra_report RA Report #	ra_caers_created_date RA CAERS Created Date	aec_event_start_date AEC Event Start Date	pri_product_role PRI Product Role	pri_reported_brand_product_name PRI Reported Brand/Product Name	pri_fda_industry_code PRI FDA Industry Code	pri_fda_industry_name PRI FDA Industry Name	ci_age_at_adverse_event CI Age At Adverse Event	ci_age_unit CI Age Unit	ci_gender CI Gender	aec_one_row_outcomes AEC One Row Outcomes	sym_one_row_coded_symptoms SYM One Row Coded Symptoms
65325	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 04 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspect	MIDWEST COUNTRY FAIR CHOCOLATE FLAVORED CHIPS	3	Bakery Prod/Dough/Mix/Icing	2	Year(s)	Female	VISITED AN ER, VISITED A HEALTH CARE PROVIDER, REQ. INTERVENTION TO PRVNT PERM. IMPRMNT., HOSPITALIZATION	SWELLING FACE, RASH, WHEEZING, COUGH, HOSPITALISATION, DYSPNOEA
65325	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 04 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspect	MIDWEST COUNTRY FAIR CHOCOLATE FLAVORED CHIPS	3	Bakery Prod/Dough/Mix/Icing	2	Year(s)	Female	VISITED AN ER, VISITED A HEALTH CARE PROVIDER, REQ. INTERVENTION TO PRVNT PERM. IMPRMNT., HOSPITALIZATION	SWELLING FACE, WHEEZING, COUGH, RASH, HOSPITALISATION, DYSPNOEA
65333	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)		Suspect	KROGER CLASSIC CREAM-DE-MINT CANDY MINT CHIP ICE CREAM	13	Ice Cream Prod		Not Available	Female	VISITED AN ER	NAUSEA, DYSGEUSIA, DIARRHOEA
65335	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 24 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspect	ENFAMIL LIPIL BABY FORMULA	40	Baby Food Prod	3	Month(s)	Not Available	NON-SERIOUS INJURIES/ ILLNESS	GASTROINTESTINAL DISORDER, VOMITING
65336	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)		Suspect	ENFIMIL LIPIL BABY FORMULA	40	Baby Food Prod		Not Available	Not Available	VISITED A HEALTH CARE PROVIDER	GASTROINTESTINAL DISORDER, PHYSICAL EXAMINATION
65345	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 21 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspect	FRITO LAY FUNYUNS ONION FLAVOR, ONION RINGS	7	Snack Food Item	10	Year(s)	Male	NON-SERIOUS INJURIES/ ILLNESS	CHOKING
65350	Thu Jan 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)		Suspect	GRAPE	20	Fruit/Fruit Prod		Not Available	Not Available	DEATH	DEATH, CHOKING
65353	Fri Jan 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Dec 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspect	HERBALIFE RELAX NOW	54	Vit/Min/Prot/Unconv Diet(Human/Animal)		Not Available	Female	VISITED A HEALTH CARE PROVIDER	PARANOIA, PHYSICAL EXAMINATION, DELUSION
65353	Fri Jan 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Dec 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	Suspect	HERBALIFE TOTAL CONTROL	54	Vit/Min/Prot/Unconv Diet(Human/Animal)		Not Available	Female	VISITED A HEALTH CARE PROVIDER	PARANOIA, PHYSICAL EXAMINATION, DELUSION
65354	Fri Jan 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)		Suspect	YOHIMBE	54	Vit/Min/Prot/Unconv Diet(Human/Animal)	66	Year(s)	Male	REQ. INTERVENTION TO PRVNT PERM. IMPRMNT.	BLOOD PRESSURE INCREASED


CREATE TABLE caers_ascii_2004_2017q2 (
  "ra_report" BIGINT,
  "ra_caers_created_date" TIMESTAMP,
  "aec_event_start_date" TIMESTAMP,
  "pri_product_role" VARCHAR,
  "pri_reported_brand_product_name" VARCHAR,
  "pri_fda_industry_code" BIGINT,
  "pri_fda_industry_name" VARCHAR,
  "ci_age_at_adverse_event" DOUBLE,
  "ci_age_unit" VARCHAR,
  "ci_gender" VARCHAR,
  "aec_one_row_outcomes" VARCHAR,
  "sym_one_row_coded_symptoms" VARCHAR
);