Primary Fields

IWasPoisoned DineSafe Data Dictionary

Report Identifiers & Metadata

Field	Description	Example	Notes
id	Unique identifier for the report	531759	-
created_date	Date and time when the report was created	7/14/2021 12:00	-
updated_date	Date report was last updated	7/14/2021 12:50
encrypted	Link to view the report page on IWP	Sample Link	Encrypted URL for report access
visibility	Shared on iwaspoisoned.com public website	1	1 = shared publicly 2= subscribers only

Business Details

Field	Description	Example	Comments
business_sector	Primary business activity	Restaurant	Primary category of business activity. Read more
business_type	Business sector subset	Restaurant	Subcategory of business_sector Read more
cuisine	Type of cuisine served	Chinese	The primary food category or self-identified specialty Read more
company_type	Ownership structure	Public	Public, Private
parent_company	Parent company name	Yum Brands	If applicable
procurement	Procurement method	Delivery	How the food was procured. Read more.

Location Information

Basic Location Data

Field	Description	Example	Notes
g_location	Full address	Waffle House, 4465 FL-520, Cocoa, FL 32926, USA	Complete location string
g_street	Street number	4465	Any valid street number
g_route	Street name	South Main Street	Full street name
g_city	City name	MIami	Any valid city name
g_state	State name	Florida	Any valid state name, not abbreviated
g_country	Country name	United States	Any country
g_postcode	Postal code	32926	Any valid postal code

Advanced Location Data

Field	Description	Example	Notes
g_county	County name	Brevard County	Any valid county name
g_neighborhood	Neighborhood name	West Village	Any valid neighborhood name
g_area	Broader area classification	Downtown District	District or subdivision
g_lat	Latitude	28.3594508	Decimal format
g_lon	Longitude	-80.7931008	Decimal format
locale	Location classification	Locale	Standardized, high-level categorization Read more
place_type	Classication of venue.	Bar	High-level cohort classification Read more

Incident Details

Field	Description	Example	Notes
body	User-provided description	"We ordered beef burgers at 1pm..."	Full report text
symptoms	Reported symptoms	Vomit, Fever	From fixed symptom list
medical	Medical diagnosis/event	Salmonella	Medical outcome or diagnosis Read more
persons	Number affected	2	Integer value
tag	Primary entity involved	Waffle House	Brand or business name
images	Media presence indicator	Yes	Yes or null

Classification & Analysis

Field	Description	Example	Notes
industry_id	Industry identifier	3194	-
place_type_si	Place type (business self identified)	supermarket, restaurant	Multiple values possible Read more
type	Report classification	Poisoned	Poisoned, Closure, Outbreak, Recall, Report
severity	Predicted severity	5	Scale of 1-5
allergens	Allergen relation confidence	87%	0-100%
contamination	Physical contamination confidence	92%	0-100%

Geographic Identifiers

Field	Description	Example	Notes
county_fips	County FIPS Code	12009	Place-specific numeric FIPS codes
full_fips	Complete FIPS code	120090625003010	Full Concatenated numeric FIPS codes
place_fips	Place FIPS code	1213225	Place-specific numeric FIPS codes
state_fips	State FIPS code	12	State-specific numeric FIPS codes
fda_region	FDA regional office	Denver_DEN_DO	FDA regional office code
radius	Recall coverage radius	200	In miles

Additional Data

Field	Description	Example	Notes
fe_tags	Associated tags	Doritos, Walmart	Brands, products, retailers
fetags_id	FE Tags identifier	294	Numeric ID
ocr_text	Image-extracted text	Receipt data	From attached images
source_notice	External source metadata	Public Health Notice	Source information
source_type	Report origin	Consumer Direct	Consumer Direct, Consumer Media Scan, Regulatory, News Media