National Outbreak Reporting System

NORS Data Dictionary for Flat Files - All Variables
Download variable order	Table/Tab Name	Variable Name	Form Marker	Form-Page and Section	Form Name	NORS Interface- Tab and Section	Format	Comments
1	NORSMain	CDCID	G1	Page 1, CDC Use Only	52.12 and 52.13	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
2	NORSMain	eFORSID	N/A	Page 1, CDC Use Only	52.12 and 52.13	N/A	Number	This is the unique ID previously assigned to a report originally entered in eFORS. All previous eFORS reports have been migrated into NORS.
3	NORSMain	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
4	NORSMain	NORSUserID	N/A	N/A	52.12 and 52.13	N/A	Text	User ID of person who created the report
5	NORSMain	RecordStatus	N/A	N/A	52.12 and 52.13	N/A	Text	Indicates whether the report is active, finalized, or deleted
6	NORSMain	CDCStatus	N/A	N/A	52.12 and 52.13	N/A	Text	NORS value for internal data management processes. Indicates whether a report has been excluded (e.g., due to multistate consolidation), cleaned, or closed out (data cleaning status applied for NORS reports for some primary modes)
7	NORSMain	CDCWaterStatus	N/A	N/A	52.12	N/A	Text	NORS value that indicates whether CDC has classified a waterborne disease outbreak report as excluded, cleaned, or closed out as a result of routine data cleaning and review activities.
8	NORSMain	StartTimeStamp	N/A	N/A	52.12 and 52.13	N/A	MM/DD/YYYY Time	Date NORS report was created.
9	NORSMain	FinalTimeStamp	N/A	N/A	52.12 and 52.13	N/A	MM/DD/YYYY Time	Date NORS report was most recently finalized, if any.
10	NORSMain	PrimaryMode	G3	Page 1, Primary mode of transmission	52.12 and 52.13	N/A	Text	Primary mode of transmission
11	NORSMain	InvestigationMethod1 InvestigationMethod2 InvestigationMethod3 InvestigationMethod4 InvestigationMethod5	G4	52.13 Page 1, Investigation Methods	52.12 and 52.13	General, Investigation Methods & Dates	Text	Name of method used to investigate outbreak
12	NORSMain	InvestigationFlag	N/A	N/A	52.12 and 52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
13	NORSMain	InvestigationComments	G5	Page 1, Investigation Methods	52.12 and 52.13	General, Investigation Methods & Dates	Text	Reporting site comments relating to the selected Investigation Method(s). See Investigation Method table/tab for selected investigation method(s)
14	NORSMain	DateFirstIll	G6	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Earliest date of reported illness onset
15	NORSMain	DateLastIll	G7	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Latest date of reported illness onset
16	NORSMain	InitialExposure	G8	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Earliest date of reported exposure
17	NORSMain	LastExposure	G9	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Latest date of reported exposure
18	NORSMain	CDCReportDate	G10	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Date of report to CDC other than the NORS report
19	NORSMain	LocalReportDate	G11	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Date of notification to State/Territory/Local Health authorities
20	NORSMain	ExposureState	G12	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Text	The state where the exposure occurred. For a single state of exposure, the state will be listed. For multiple states of exposure, "multistate exposure" will be listed.
21	NORSMain	ExposureStateCount	N/A	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Number	The case count for the exposure state.
22	NORSMain	MultiStateExposure	G13	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	True/False, 1/0, or -1/0 ,	Exposure occurred in multiple states. 0="False", 1 or -1="True" Format depends on export and import program
23	NORSMain	MultiStateResidence	G14	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	True/False, 1/0, or -1/0	Exposure occurred in a single state, but cases resided in another state or multiple states. 0="False", 1 or -1 ="True" Format depends on export and import program
24	NORSMain	State1 State2 State3 State4 State5 State6 State7 State8 State9 State10	G15	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Text	Name of each state involved in the outbreak. If multiple states were involved but there was only one exposure state, it will be included in the list of states.
25	NORSMain	StateCount1 StateCount2 StateCount3 StateCount4 StateCount5 StateCount6 StateCount7 StateCount8 StateCount9 StateCount10	G16	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Number	The case count for each state for multistate exposure or multistate residency outbreaks. This information can be entered on the reporting form when additional states are reported as part of a multistate exposure or multistate residency outbreak.
26	NORSMain	StateFlag	N/A	N/A	52.12 and 52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
27	NORSMain	ExposureCounty	G17	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Text	The county where the exposure occurred for a single state exposure outbreak. For a single county of exposure, the county will be listed. For multiple counties of exposure, "multicounty exposure" will be listed.'
28	NORSMain	MultiCountyExposure	G18	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	True/False, 1/0, or -1/0	Exposure occurred in multiple counties. 0="False", 1 or-1 ="True" Format depends on export and import program
29	NORSMain	MultiCountyResidence		Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	True/False, 1/0, or -1/0	Exposure occurred in a single county, but cases resided in another county or multiple counties. 0="False", 1 or -1 ="True" Format depends on export and import program
30	NORSMain	County1 County2 County3 County4 County5 County6 County7 County8 County9 County10	G20	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Text	Name of each county involved in the outbreak. If multiple counties were involved but there was only one exposure county, it will be included in the list of counties.
31	NORSMain	CountyFlag	N/A	N/A	52.12 and 52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
32	NORSMain	ExposureLocation	G21	Page 1, Geographic Location	52.12 and 52.13	General, Geographic Location	Text	Name of city, town, or place of exposure
33	NORSMain	ConfirmedPrimary	G22	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of laboratory confirmed primary cases
34	NORSMain	ProbablePrimary	G23	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of probable primary cases
35	NORSMain	EstimatedPrimary	G24	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Estimated total number of primary cases, including lab-confirmed and probable, based on the outbreak-specific definition.
36	NORSMain	DeathsNum	G25	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases who died
37	NORSMain	DeathsInfo	G26	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Total number of primary cases for whom information on survival is available
38	NORSMain	HospitalNum	G27	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases who were hospitalized
39	NORSMain	HospitalInfo	G28	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Total number of primary cases for whom information on hospitalization is available
40	NORSMain	ERNum	G29	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases who visited an emergency room
41	NORSMain	ERInfo	G30	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Total number of primary cases for whom information on ER visit is available
42	NORSMain	HealthcareNum	G31	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases who visited a health care provider
43	NORSMain	HealthcareInfo	G32	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Total number of primary cases for whom information on health care visit is available
44	NORSMain	NumberMale	G33	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases who are male
45	NORSMain	PercentMale	G34	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases who are male
46	NORSMain	NumberFemale	G35	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases who are female
47	NORSMain	PercentFemale	G36	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases who are female
48	NORSMain	NumberSexUnknown	G37	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases of unknown sex
49	NORSMain	PercentSexUnknown	G38	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases of unknown sex
50	NORSMain	NumberAgeUnder1	G39	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases age less than one year
51	NORSMain	PercentAgeUnder1	G40	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases aged less than one year
52	NORSMain	NumberAge1to4	G41	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases age one to four years
53	NORSMain	PercentAge1to4	G42	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases age one to four years
54	NORSMain	NumberAge5to9	G43	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases age five to nine years
55	NORSMain	PercentAge5to9	G44	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases age five to nine years
56	NORSMain	NumberAge10to19	G45	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases age ten to nineteen years
57	NORSMain	PercentAge10to19	G46	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases age 10 to 19 years
58	NORSMain	NumberAge20to49	G47	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases age 20 to 49 years
59	NORSMain	PercentAge20to49	G48	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases age 20 to 49 years
60	NORSMain	NumberAge50to74	G49	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases age 50 to 74 years
61	NORSMain	PercentAge50to74	G50	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases age 50 to 74 years
62	NORSMain	NumberAge75plus	G51	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases over 75 years of age
63	NORSMain	PercentAge75plus	G52	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases over 75 years of age
64	NORSMain	NumberAgeUnknown	G53	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Number of primary cases of unknown age
65	NORSMain	PercentAgeUnknown	G54	Page 1, Primary Cases	52.12 and 52.13	General, Primary Cases	Number	Percentage of primary cases of unknown age
66	NORSMain	IncShort	G55	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Number	Shortest incubation period, in selected units
67	NORSMain	IncShortUnit	G56	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Text	Units of shortest incubation time
68	NORSMain	IncMedian	G57	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Number	Median incubation period, in selected units
69	NORSMain	IncMedianUnit	G58	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Text	Units of median incubation time
70	NORSMain	IncLong	G59	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Number	Longest incubation period, in selected units
71	NORSMain	IncLongUnit	G60	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Text	Units of longest incubation time
72	NORSMain	IncubationNum	G61	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	Number	Number of primary cases for whom information on incubation period is available.
73	NORSMain	IncUnknown	G62	Page 2, Incubation Period	52.12 and 52.13	General, Incubation & Duration	True/False, 1/0, or -1/0	Information on incubation period is unknown. 0="False", 1 or -1 ="True" Format depends on export and import program
74	NORSMain	DurShort	G63	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Number	Shortest duration time, in selected units
75	NORSMain	DurShortUnit	G64	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Text	Units of shortest duration time
76	NORSMain	DurMedian	G65	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Number	Median duration time, in selected units
77	NORSMain	DurMedianUnit	G66	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Text	Units of median duration time
78	NORSMain	DurLong	G67	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Number	Longest duration time, in selected units
79	NORSMain	DurLongUnit	G68	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Text	Units of longest duration time
80	NORSMain	DurationNum	G69	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	Number	Number of primary cases for whom information on duration of illness is available.
81	NORSMain	DurUnknown	G70	Page 2, Duration of Illness	52.12 and 52.13	Gen-Pt2, Duration of Illness	True/False, 1/0, or -1/0	Information on duration of illness is unknown. 0="False", 1 or -1 ="True" Format depends on export and import program
82	NORSMain	Symptom1 Symptom2 Symptom3 Symptom4 Symptom5 Symptom6 Symptom7 Symptom8 Symptom9 Symptom10 Symptom11 Symptom12	G71	Page 2, Signs or Symptoms	52.12 and 52.13	General, Signs or Symptoms	Text	Name of sign or symptom
83	NORSMain	SymptomCases1 SymptomCases2 SymptomCases3 SymptomCases4 SymptomCases5 SymptomCases6 SymptomCases7 SymptomCases8 SymptomCases9 SymptomCases10 SymptomCases11 SymptomCases12	G72	Page 2, Signs or Symptoms	52.12 and 52.13	General, Signs or Symptoms	Number	Number of primary cases with sign or symptom
84	NORSMain	SymptomInfo1 SymptomInfo2 SymptomInfo3 SymptomInfo4 SymptomInfo5 SymptomInfo6 SymptomInfo7 SymptomInfo8 SymptomInfo9 SymptomInfo10 SymptomInfo11 SymptomInfo12	G73	Page 2, Signs or Symptoms	52.12 and 52.13	General, Signs or Symptoms	Number	Total number of primary cases for whom information on specified sign or symptom is available
85	NORSMain	SymptomFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
86	NORSMain	SecondaryFood	G74	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	True/False, 1/0, or -1/0	Food reported as a confirmed or suspected mode of secondary transmission. 1='confirmed or suspected secondary mode' 0='not a confirmed or suspected secondary mode'
87	NORSMain	SecondaryWater	G74	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	True/False, 1/0, or -1/0	Water reported as a confirmed or suspected mode of secondary transmission. 1='confirmed or suspected secondary mode' 0='not a confirmed or suspected secondary mode'
88	NORSMain	SecondaryAnimal	G74	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	True/False, 1/0, or -1/0	Animal contact reported as a confirmed or suspected mode of secondary transmission. 1='confirmed or suspected secondary mode' 0='not a confirmed or suspected secondary mode'
89	NORSMain	SecondaryPerson	G74	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	True/False, 1/0, or -1/0	Person-to-person transmission reported as a confirmed or suspected mode of secondary transmission. 1='confirmed or suspected secondary mode' 0='not a confirmed or suspected secondary mode'
90	NORSMain	SecondaryEnviron	G74	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	True/False, 1/0, or -1/0	Environmental contact reported as a confirmed or suspected mode of secondary transmission. 1='confirmed or suspected secondary mode' 0='not a confirmed or suspected secondary mode'
91	NORSMain	SecondaryOther	G74	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	True/False, 1/0, or -1/0	Another or an undetermined exposure reported as a confirmed or suspected mode of secondary transmission. 1='confirmed or suspected secondary mode' 0='not a confirmed or suspected secondary mode'
92	NORSMain	ConfirmedSecondary	G75	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	Number	Number of laboratory confirmed secondary cases
93	NORSMain	ProbableSecondary	G76	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	Number	Number of probable secondary cases
94	NORSMain	TotalSecondary	G77	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	Number	Total number of laboratory confirmed and probable secondary cases
95	NORSMain	TotalCases	G78	Page 2, Secondary Cases	52.12 and 52.13	General, Secondary Cases	Number	Estimated total number of secondary cases, including lab-confirmed and probable, based on the outbreak-specific definition
96	NORSMain	NEARSID1	G79	Page 2, Other CDC System IDs	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	This field is used to link NORS reports to environmental health investigation reports in the National Environmental Assessment Reporting System (NEARS) (formerly Environmental Health Specialists Network)
97	NORSMain	NEARSID2	G80	Page 2, Other CDC System IDs	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	This field is used to link NORS reports to environmental health investigation reports in the National Environmental Assessment Reporting System (NEARS) (formerly Environmental Health Specialists Network)
98	NORSMain	NEARSID3	G81	Page 2, Other CDC System IDs	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	This field is used to link NORS reports to environmental health investigation reports in the National Environmental Assessment Reporting System (NEARS) (formerly Environmental Health Specialists Network)
99	NORSMain	NEARSID4	G82	Page 2, Other CDC System IDs	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	This field is used to link NORS reports to environmental health investigation reports in the National Environmental Assessment Reporting System (NEARS) (formerly Environmental Health Specialists Network)
100	NORSMain	OHHABSID1	G83	Page 2, Other CDC System IDs	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	This field is used to link NORS reports to reports in the One Health Harmful Algal Bloom System (OHHABS)
101	NORSMain	OHHABSID2	G84	Page 2, Other CDC System IDs	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	This field is used to link NORS reports to reports in the One Health Harmful Algal Bloom System (OHHABS)
102	NORSMain	TracebackConducted	G85	Page 2, Traceback	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	True/False, 1/0, or -1/0	Traceback was conducted. 0="False", 1 or -1 ="True". Format depends on export and import program
103	NORSMain	TracebackSource1 TracebackSource2 TracebackSource3	G86	Page 2, Traceback	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	Name of source
104	NORSMain	TracebackType1 TracebackType2 TracebackType3	G87	Page 2, Traceback	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	Source type
105	NORSMain	TracebackState1 TracebackState2 TracebackState3	G88	Page 2, Traceback	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	State of source
106	NORSMain	TracebackCountry1 TracebackCountry2 TracebackCountry3	G89	Page 2, Traceback	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	Country of source
107	NORSMain	TracebackComments1 TracebackComments2 TracebackComments3	G90	Page 2, Traceback	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	Additional remarks concerning traceback
108	NORSMain	TracebackFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
109	NORSMain	Recall	G91	Page 2, Recall	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	True/False, 1/0, or -1/0	A food or bottled water product was recalled. 0="False", 1="True". Format depends on export and import program
110	NORSMain	RecallItem	G92	Page 2, Recall	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	Type of item recalled
111	NORSMain	RecallComments	G93	Page 2, Recall	52.12 and 52.13	General, Other CDC Systems, Traceback, & Recall	Text	Comments about the recall.
112	NORSMain	ReportingSite	G94	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Reporting site of the report author
113	NORSMain	AgencyName	G95	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Name of the NORS agency reporting the outbreak
114	NORSMain	AgencyContact	G96	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Name of primary agency contact
115	NORSMain	AgencyTitle	G97	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Title of agency contact
116	NORSMain	AgencyEmail	G98	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Email address of agency contact
117	NORSMain	AgencyPhone	G99	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Phone number of agency contact
118	NORSMain	AgencyFax	G100	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Fax number of agency contact
119	NORSMain	GeneralComments	G101	Page 2, General Remarks	52.12 and 52.13	General, Agency & Remarks	Text	General comments about the outbreak
120	NORSMain	CDCRemarks	N/A	N/A	N/A	General, Agency & Remarks	Text	General comments added by CDC NORS managing administrators
121	NORSMain	References	N/A	N/A	N/A	General, Agency & Remarks	Text	Publications or other references related to outbreak added by CDC
122	NORSMain	Attachment1 Attachment2	N/A	N/A	N/A	Attachments	True/False, 1/0, or -1/0	Indicates whether or not one or more attachments have been included in the NORS report. 0="False", 1 or -1="True" Format depends on export and import program
123	NORSMain	AttachmentName1 AttachmentName2	N/A	N/A	N/A	N/A	Text	The filename of the attachment(s) to the NORS report, if any
124	NORSMain	AttachmentUploadDate1 AttachmentUploadDate2	N/A	N/A	N/A	N/A	MM/DD/YYYY	Upload date of the attachment(s)
125	NORSMain	AttachmentFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
126	GenLab	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
127	GenLab	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
128	GenLab	SpecimenCollected	GL1	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether any specimens or environmental, food, or water samples were collected and tested. 0="False", 1 or -1 ="True" Format depends on export and import program
129	GenLab	SampleTypeHuman	GL2	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether human samples were tested. 0="False", 1 or -1 ="True" Format depends on export and import program
130	GenLab	SampleTypeHumanNum	GL3	Page 3, Etiology Section	52.13	Etiology, General Etiology	Number	Number of human specimens tested
131	GenLab	SampleTypeAnimal	GL4	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether animal samples were tested. 0="False", 1 or -1 ="True" Format depends on export and import program
132	GenLab	SampleTypeAnimalNum	GL5	Page 3, Etiology Section	52.13	Etiology, General Etiology	Number	Number of animal specimens tested
133	GenLab	SampleTypeFood	GL6	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether food samples were tested. 0="False", 1 or -1 ="True" Format depends on export and import program
134	GenLab	SampleTypeFoodNum	GL7	Page 3, Etiology Section	52.13	Etiology, General Etiology	Number	Number of food specimens tested
135	GenLab	SampleTypeWater	GL8	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether water samples were tested. 0="False", 1 or -1 ="True" Format depends on export and import program
136	GenLab	SampleTypeWaterNum	GL9	Page 3, Etiology Section	52.13	Etiology, General Etiology	Number	Number of water specimens tested
137	GenLab	SampleTypeOther	GL10	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether other samples were tested, specify in general remarks section. 0="False", 1 or -1 ="True" Format depends on export and import program
138	GenLab	SampleTypeOtherNum	GL11	Page 3, Etiology Section	52.13	Etiology, General Etiology	Number	Number of other samples that were tested.
139	GenLab	TestedBacteria	GL12	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	This field indicates whether collected specimens, if any, were tested for bacterial etiologies. 0="False", 1 or -1="True" Format depends on export and import program
140	GenLab	TestedViruses	GL13	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	This field indicates whether collected specimens, if any, were tested for viral etiologies. 0="False", 1 or -1="True" Format depends on export and import program
141	GenLab	TestedParasites	GL14	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	This field indicates whether collected specimens, if any, were tested for parasitic etiologies. 0="False", 1or -1="True" Format depends on export and import program
142	GenLab	TestedChemicals	GL15	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	This field indicates whether collected specimens, if any, were tested for chemical etiologies. 0="False", 1 or -1 ="True" Format depends on export and import program
143	GenLab	TestedUnknown	GL16	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	This field indicates that collected specimens/samples were tested, but for what they were tested is unknown. 0="False", 1or -1="True" Format depends on export and import program
144	GenLab	TestTypeChemical	GL17	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using chemical testing methods. 0="False", 1or -1="True" Format depends on export and import program
145	GenLab	TestTypeCulture	GL18	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using culture methods. 0="False", 1or -1="True" Format depends on export and import program
146	GenLab	TestTypePCR	GL19	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using DNA or RNA amplification methods. 0="False", 1or -1="True" Format depends on export and import program
147	GenLab	TestTypeMicro	GL20	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using microscopy methods. 0="False", 1or -1="True" Format depends on export and import program
148	GenLab	TestTypeSero	GL21	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using serological or imunological methods. 0="False", 1or -1="True" Format depends on export and import program
149	GenLab	TestTypeTissue	GL22	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using tissue culture infectivity assay. 0="False", 1or -1="True" Format depends on export and import program
150	GenLab	TestTypeOther	GL23	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using another method. 0="False", 1or -1="True" Format depends on export and import program
151	GenLab	TestTypeUnknown	GL24	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using an unknown methods. 0="False", 1or -1="True" Format depends on export and import program
152	GenLab	ASTPerformed	GL25	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether any samples were tested for antimicrobial resistance. 0="No", 1="Yes", 7="Unknown", null (blank) = no response
153	GenLab	ASTWhereClinical	GL26	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates if AST was done by a clinical lab (e.g., hospital). 0="False", 1or -1="True" Format depends on export and import program
154	GenLab	ASTWherePHLab	GL27	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates if AST was done by a public health lab. 0="False", 1or -1="True" Format depends on export and import program
155	GenLab	ASTWhereNARMS	GL28	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates if AST was done by the National Antimicrobial Resistance Monitoring System (NARMS). 0="False", 1or -1="True" Format depends on export and import program
156	GenLab	ASTWhereOther	GL29	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates if AST was done by another lab. 0="False", 1or -1="True" Format depends on export and import program
157	GenLab	ASTWhereUnknown	GL30	Page 3, Etiology	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates if AST testing is unknown. 0="False", 1or -1="True" Format depends on export and import program
158	GenLab	ASTOutbreak	GL31	Page 3, Etiology Section	52.13	Etiology, General Etiology	0/1/7/Null (blank)	Indicates whether any antimicrobial resistant strains were associated with the outbreak. 0="False", 1="True", 7="Unknown", null (blank) = no response
159	GenLab	EtiologyKnown	GL32	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates that there is at least one confirmed or suspected outbreak etiology (based on either laboratory confirmation or epidemiological evidence). 0="False", 1 or -1 ="True", Format depends on export and import program.
160	GenLab	GenusName1 GenusName2 GenusName3 GenusName4 GenusName5	GL33	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Genus of idendified etiology
161	GenLab	SpeciesName1 SpeciesName2 SpeciesName3 SpeciesName4 SpeciesName5	GL34	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Species of identified etiology
162	GenLab	SerotypeName1 SerotypeName2 SerotypeName3 SerotypeName4 SerotypeName5	GL35	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Serotype of identified etiology
163	GenLab	Polymerase1 Polymerase2 Polymerase3 Polymerase4 Polymerase5	GL35	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Polymerase type of a norovirus strain identified as an outbreak etiology
164	GenLab	Capsid1 Capsid2 Capsid3 Capsid4 Capsid5	GL35	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Capsid type of a norovirus strain identified as an outbreak etiology
165	GenLab	OtherCharacteristics1 OtherCharacteristics2 OtherCharacteristics3 OtherCharacteristics4 OtherCharacteristics5	GL36	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Other characteristics of identified etiology
166	GenLab	Confirmed1 Confirmed2 Confirmed3 Confirmed4 Confirmed5	GL37	Page 3, Etiology Section	52.13	Etiology, General Etiology	Text	Indicates whether or not the listed etiology is laboratory 'Confirmed' or 'Suspected'.
167	GenLab	NumberLabConfirmed1 NumberLabConfirmed2 NumberLabConfirmed3 NumberLabConfirmed4 NumberLabConfirmed5	GL38	Page 3, Etiology Section	52.13	Etiology, General Etiology	Number	Number of lab confirmed cases
168	GenLab	PatientSpecimen1 PatientSpecimen2 PatientSpecimen3 PatientSpecimen4 PatientSpecimen5	GL39	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Etiology was identified/detected in a patient specimen. 0="False", 1 or -1 ="True". Format depends on export and import program
169	GenLab	FoodSpecimen1 FoodSpecimen2 FoodSpecimen3 FoodSpecimen4 FoodSpecimen5	GL40	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Etiology was identified/detected in a food specimen. 0="False", 1 or -1="True". Format depends on export and import program
170	GenLab	EnvironmentSpecimen1 EnvironmentSpecimen2 EnvironmentSpecimen3 EnvironmentSpecimen4 EnvironmentSpecimen5	GL41	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Etiology was identified/detected in an environmental specimen. 0="False", 1 or -1 ="True". Format depends on export and import program
171	GenLab	FoodWorkerSpecimen1 FoodWorkerSpecimen2 FoodWorkerSpecimen3 FoodWorkerSpecimen4 FoodWorkerSpecimen5	GL42	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Etiology was identified/detected in a food worker specimen. 0="False", 1 or -1 ="True". Format depends on export and import program
172	GenLab	WaterSample1 WaterSample2 WaterSample3 WaterSample4 WaterSample5	GL43	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Etiology was identified/detected in a water sample specimen. 0="False", 1 or -1 ="True". Format depends on export and import program
173	GenLab	AnimalSpecimen1 AnimalSpecimen2 AnimalSpecimen3 AnimalSpecimen4 AnimalSpecimen5	GL44	Page 3, Etiology Section	52.13	Etiology, General Etiology	True/False, 1/0, or -1/0	Etiology was identified/detected in an animal specimen. 0="False", 1 or -1 ="True". Format depends on export and import program
174	GenLab	EtiologyValue1 EtiologyValue2 EtiologyValue3 EtiologyValue4 EtiologyValue5	N/A	N/A	N/A	Etiology, General Etiology	Text	Indicates whether listed etiology is bacterial, chemical, viral, parasitic, or hepatitis. Value is automatically assigned for analysis purposes.
175	GenLab	EtiologyFlag	N/A	N/A	N/A	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
176	GenLab	CDCSystem1 CDCSystem2 CDCSystem3 CDCSystem4 CDCSystem5	GL45	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	The CDC laboratory system with associated isolate or specimen data.
177	GenLab	StateLabID1 StateLabID2 StateLabID3 StateLabID4 StateLabID5	GL46	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	State PulseNet laboratory ID, CaliciNet key, Accession ID, or PulseNet key
178	GenLab	CDCLabOutbreakID1 CDCLabOutbreakID2 CDCLabOutbreakID3 CDCLabOutbreakID4 CDCLabOutbreakID5	GL47	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	PulseNet cluster code or CaliciNet outbreak number
179	GenLab	Enzyme1_1 Enzyme1_2 Enzyme1_3 Enzyme1_4 Enzyme1_5	GL48	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	CDC PulseNet pattern designation for enzyme 1. The numeral before the underscore identifies the pattern designation and the numeral after the underscore identifies the enzyme with which the pattern is associated. (e.g., FoodName1, Ingredient1_1, Ingredient2_1, Ingredient3_1, FoodName2, Ingredient1_2, Ingredient2_2, Ingredient3_2)
180	GenLab	Enzyme2_1 Enzyme2_2 Enzyme2_3 Enzyme2_4 Enzyme2_5	GL49	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	CDC PulseNet pattern designation for enzyme 2. The numeral before the underscore identifies the pattern designation and the numeral after the underscore identifies the enzyme with which the pattern is associated. (e.g., FoodName1, Ingredient1_1, Ingredient2_1, Ingredient3_1, FoodName2, Ingredient1_2, Ingredient2_2, Ingredient3_2)
181	GenLab	SequenceID1 SequenceID2 SequenceID3 SequenceID4 SequenceID5	GL50	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	Whole genome sequencing ID/CaliciNet sequenced region
182	GenLab	OtherMolecularDesignation1 OtherMolecularDesignation2 OtherMolecularDesignation3 OtherMolecularDesignation4 OtherMolecularDesignation5	GL51	Page 3, Isolates/Strains	52.13	Etiology, General Etiology	Text	Other molecular designation/ CaliciNet genotype/ PulseNet species or serotype
183	GenLab	NARMSResistance1 NARMSResistance2 NARMSResistance3 NARMSResistance4 NARMSResistance5				Etiology, General Etiology	Text	CDC NARMS predicted resistance pattern based on resistance determinants.
184	GenLab	NARMSAST1 NARMSAST2 NARMSAST3 NARMSAST4 NARMSAST5				Etiology, General Etiology	Text	CDC NARMS antimicrobial susceptibility testing (AST) results.
185	GenLab	SpecimenID1 SpecimenID2 SpecimenID3 SpecimenID4 SpecimenID5				Etiology, General Etiology	Text	State Lab Specimen ID from the CaliciNet database
186	GenLab	SourceType1 SourceType2 SourceType3 SourceType4 SourceType5				Etiology, General Etiology	Text	Source Type for the specimen from the CaliciNet database
187	GenLab	ArchivedSpecimensTaken	N/A	N/A	N/A	Etiology, General Etiology	0/1/7/Null (blank)	NORS question collected between Jan 2009 and Sept 2015. This question is no longer being collected, but the data entered during this period has been archived for reference.. If etiology is unknown, were patient specimens collected? 0="False", 1="True", 7="Unknown", null (blank) = no response
188	GenLab	ArchivedNumberSpecimens	N/A	N/A	N/A	Etiology, General Etiology	Number	NORS question collected between Jan 2009 and Sept 2015. This question is no longer being collected, but the data entered during this period has been archived for reference. Number of specimens collected for outbreak of unknown etiology.
189	GenLab	IsolatesFlag	N/A	N/A	N/A	Etiology, General Etiology	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
190	Foodborne	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
191	Foodborne	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
192	Foodborne	FoodVehicleUndetermined	F1	Page 4, Food	52.13	Food	True/False, 1/0, -1/0	Indicates if a food vehicle was not identified for the outbreak. Format depends on export and import program, 0="False", 1 or -1 ="True".
193	Foodborne	ReasonFoodEpi	F2	Page 4, Food	52.13	Food	True/False, 1/0, -1/0	Indicates whether epidemiologic evidence determined that the outbreak was foodborne, with an undetermined vehicle.
194	Foodborne	ReasonFoodLab	F3	Page 4, Food	52.13	Food	True/False, 1/0, -1/1	Indicates whether laboratory evidence determined that the outbreak was foodborne, with an undetermined vehicle.
195	Foodborne	ReasonFoodTrace	F4	Page 4, Food	52.13	Food	True/False, 1/0, -1/2	Indicates whether traceback or environmental evidence determined that the outbreak was foodborne, with an undetermined vehicle.
196	Foodborne	ReasonFoodOther	F5	Page 4, Food	52.13	Food	True/False, 1/0, -1/3	Indicates whether other evidence determined that the outbreak was foodborne, with an undetermined vehicle.
197	Foodborne	FoodName1 FoodName2 FoodName3	F6	Page 4, Food	52.13	Food	Text	Implicated food(s)
198	Foodborne	FoodConfirmed1 FoodConfirmed2 FoodConfirmed3	F7	Page 4, Food	52.13	Food	Text	Indicates whether the vehicle was confirmed or suspected.
199	Foodborne	ReasonSuspected1_1 ReasonSuspected2_1 ReasonSuspected3_1 ReasonSuspected1_2 ReasonSuspected2_2 ReasonSuspected3_2 ReasonSuspected1_3 ReasonSuspected2_3 ReasonSuspected3_3	F8	Page 4, Food	52.13	Food	Text	For the implicated food, indicates reason(s) suspected or confirmed.
200	Foodborne	IngredientName1_1 IngredientName2_1 IngredientName3_1 IngredientName1_2 IngredientName2_2 IngredientName3_2 IngredientName1_3 IngredientName2_3 IngredientName3_3	F9	Page 4, Food	52.13	Food	Text	For the implicated food suspected or investigated, indicates a single ingredient
201	Foodborne	ContaminatedIngredient1_1 ContaminatedIngredient2_1 ContaminatedIngredient3_1 ContaminatedIngredient1_2 ContaminatedIngredient2_2 ContaminatedIngredient3_2 ContaminatedIngredient1_3 ContaminatedIngredient2_3 ContaminatedIngredient3_3	F10	Page 4, Food	52.13	Food	True/False, 1/0, or -1/0	Among the ingredients previously listed, indicates a contaminated ingredient(s), 0="False", 1 or -1 ="True" Format depends on export and import program
202	Foodborne	FoodExposed1 FoodExposed2 FoodExposed3	F11	Page 4, Food	52.13	Food	Number	Number of cases exposed to the implicated food
203	Foodborne	MethodOfProcessing1_1 MethodOfProcessing2_1 MethodOfProcessing3_1 MethodOfProcessing1_2 MethodOfProcessing2_2 MethodOfProcessing3_2 MethodOfProcessing1_3 MethodOfProcessing2_3 MethodOfProcessing3_3	F12	Page 4, Food	52.13	Food	Text	For the implicated food, indicates method of processing
204	Foodborne	MethodOfPreparation1_1 MethodOfPreparation2_1 MethodOfPreparation3_1 MethodOfPreparation1_2 MethodOfPreparation2_2 MethodOfPreparation3_2 MethodOfPreparation1_3 MethodOfPreparation2_3 MethodOfPreparation3_3	F13	Page 4, Food	52.13	Food	Text	For the implicated food, indicates method of preparation
205	Foodborne	LevelofPreparation1_1 LevelofPreparation2_1 LevelofPreparation3_1 LevelofPreparation1_2 LevelofPreparation2_2 LevelofPreparation3_2 LevelofPreparation1_3 LevelofPreparation2_3 LevelofPreparation3_3	F14	Page 4, Food	52.13	Food	Text	For the implicated food, indicates level of preparation
206	Foodborne	Imported1 Imported2 Imported3	F15	Page 4, Food	52.13	Food	0/1/9/Null (blank)	Indicates if the implicated food was imported into the US, 0 ="No", 1 or -1= "Yes" 9= "Unknown", Null (blank)=No Response
207	Foodborne	CountryName1 CountryName2 CountryName3	F16	Page 4, Food	52.13	Food	Text	If the contaminated food was imported, indicate the name of the country if known.
208	Foodborne	ProduceAndSold1 ProduceAndSold2 ProduceAndSold3	F17	Page 4, Food	52.13	Food	0/1/7/Null (blank)	Indicates if the food product was both produced under domestic regulatory oversight (commercial product produced within US that is regulated by the FDA) and sold, 0 ="No", 1= "Yes", 7= "Unknown", Null (blank)=No Response
209	Foodborne	FoodNameFlag	N/A	N/A	52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
210	Foodborne	ArchivedTotalExpFood	N/A	N/A	52.13	N/A	Number	NORS question collected between Jan 2009 and May 2011. This question is no longer being collected, but the data entered during this period has been archived for reference. This variable indicates the number of cases exposed to at least one of the implicated foods reported.
211	Foodborne	WherePrepName1 WherePrepName2 WherePrepName3	F18	Page 5, Location where food was prepared	52.13	Factors	Text	Location of exposure of where food was prepared
212	Foodborne	WherePrepNameFlag	N/A	N/A	52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
213	Foodborne	WherePrepComments	F19	Page 5, Location where food was prepared	52.13	Factors	Text	Comments regarding the location of preparation
214	Foodborne	WhereEatenName1 WhereEatenName2 WhereEatenName3	F20	Page 5, Location of exposure	52.13	Factors	Text	Location of exposure of where food was eaten
215	Foodborne	WhereEatenNameFlag	N/A	N/A	52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
216	Foodborne	WhereEatenComments	F21	Page 5, Location of exposure	52.13	Factors	Text	Comments regarding the location of exposure
217	Foodborne	KitchenManager	F22	Page 5, Location of exposure	52.13	Food	0/1/7/Null (blank)	Indicates whether a kitchen manager at the location of preparation was certified in food safety (e.g., ServSafe). 0="No", 1="True", 7="Unknown", null (blank) = no response
218	Foodborne	ContributingFactorsUnknown	F23	Page 5, Contributing Factors	52.13	Food	True/False, 1/0, -1/0	Indicates if contributing factor is unknown, 0="False", 1 or -1="True". Format depends on export and import program
219	Foodborne	ContributingFactorName1 ContributingFactorName2 ContributingFactorName3 ContributingFactorName4 ContributingFactorName5 ContributingFactorName6 ContributingFactorName7 ContributingFactorName8 ContributingFactorName9 ContributingFactorName10	F24	Page 5, Contributing factors	52.13	Factors	Text	Name of contributing factor
220	Foodborne	ContributingFactorType1 ContributingFactorType2 ContributingFactorType3 ContributingFactorType4 ContributingFactorType5 ContributingFactorType6 ContributingFactorType7 ContributingFactorType8 ContributingFactorType9 ContributingFactorType10	F25	Page 5, Contributing factors	52.13	Factors	Text	Type of contributing factor
221	Foodborne	ContributingFactorTypeFlag	N/A	N/A	52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
222	Foodborne	ContributingFactorNameFlag	N/A	N/A	52.13	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
223	Foodborne	ContaminationPoint	F26	Page 5, Point of Contamination	52.13	Factors	Text	Indicates if point of contamination occurred "Before preparation," "Preparation," or "Unknown."
224	Foodborne	BeforePrepPreHarvest	F27	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	If point of contamination occurred 'before preparation', variable indicates during preharvest, 0="False", 1 or -1 ="True". Format depends on export and import program
225	Foodborne	BeforePrepProcessing	F28	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	If point of contamination occurred 'before preparation', variable indicates during processing, 0="False", 1 or -1="True". Format depends on export and import program
226	Foodborne	BeforePrepUnknown	F29	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	If point of contamination occurred 'before preparation', variable indicates when is unknown, 0="False", 1 or -1="True". Format depends on export and import program
227	Foodborne	EnvironmentalEvidence	F30	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	Environmental evidence is the reason why the confirmed or suspected point of contamination was assumed, 0="False", 1 or -1="True". Format depends on export and import program
228	Foodborne	EpidemiologyEvidence	F31	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	Indicates if epidemiologic evidence is the reason why the confirmed or suspected point of contamination was assumed, 0="False", 1 or -1="True". Format depends on export and import program
229	Foodborne	LabEvidence	F32	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	Lab evidence is the reason why the confirmed or suspected point of contamination was assumed, 0="False", 1 or -1="True". Format depends on export and import program
230	Foodborne	PriorExperience	F33	Page 5, Point of Contamination	52.13	Factors	True/False, 1/0, -1/0	Indicates if prior experience is the reason why the confirmed or suspected point of contamination was assumed, 0="False", 1 or -1="True". Format depends on export and import program
231	Foodborne	FoodWorkerImplicated	F34	Page 5, Contributing Factors	52.13	Food	0/1/7/Null (blank)	Indicates if food worker was implicated, 0="No", 1="True", 7="Unknown", null (blank) = no response
232	Foodborne	FoodWorkerImplicatedName	F35	Page 5, Contributing Factors	52.13	Food	Text	If food worker was implicated, indicates type of evidence that implicated the food worker
233	Foodborne	MultipleSchools	F36	Page 6, School questions	52.13	School	True/False, 1/0, -1/0	Did the outbreak involve a single or multiple schools? 0="False", 1 or -1="True", Format depends on export and import program
234	Foodborne	NumofMultipleSchools	F37	Page 6, School questions	52.13	School	Number	Number of schools if multiple schools were involved in the outbreak
235	Foodborne	TotalEnrollment	F38	Page 6, School questions	52.13	School	Number	Approximate number of students enrolled in the school
236	Foodborne	UnknownEnrollmentNumber	F39	Page 6, School questions	52.13	School	True/False, 1/0, -1/0	Indicates if the number of students enrolled is unknown. Format depends on import and export program, 0="False", 1 or -1="True".
237	Foodborne	GradeLevelK GradeLevel1 GradeLevel2 GradeLevel3 GradeLevel4 GradeLevel5 GradeLevel6 GradeLevel7 GradeLevel8 GradeLevel9 GradeLevel10 GradeLevel11 GradeLevel12 GradeLevelCollege GradeLevelUnknown	F40	Page 6, School questions	52.13	School	True/False, 1/0, -1/0	Indicates grade level of the students in the outbreak
238	Foodborne	SchoolFundingName	F41	Page 6, School questions	52.13	School	Text	Primary funding of involved schools
239	Foodborne	SchoolFoodPrepName1 SchoolFoodPrepName2 SchoolFoodPrepName3	F42	Page 6, School questions	52.13	School	Text	Indicates the preperation of the implicated item
240	Foodborne	SchoolInspectedName	F43	Page 6, School questions	52.13	School	Text	Indicates how many times the school cafeteria or kitchen has been inspected in the last 12 months by state, county, or local health departments.
241	Foodborne	HACCP	F44	Page 6, School questions	52.13	School	0/1/7/Null (blank)	Indicate whether the school involved in the outbreak has a HACCP plan in place for the school feeding program, 0 ="No", 1= "Yes", 7= "Unknown or Undetermined", Null (blank)= No Response
242	Foodborne	NationalSchoolProgram	F45	Page 6, School questions	52.13	School	0/1/7/Null (blank)	Was implicated food item provided to the school through the National School Lunch/Breakfast Program? 0 ="No", 1= "Yes", 7= "Unknown or Undetermined", Null (blank)= No Response
243	Foodborne	FoodItemPurchasedDonatedBy	F46	Page 6, School questions	52.13	School	Text	If school participated in the National School Lunch/Breakfast program, indicates the source of the implicated food items
244	Foodborne	PercentageGBConsumed	F47	Page 6, Ground Beef	52.13	Ground Beef	Number	Percentage of ill persons that ate ground beef raw or undercooked
245	Foodborne	CaseReady	F48	Page 6, Ground Beef	52.13	Ground Beef	0/1/7/Null (blank)	Indicates whether the ground beef was case ready, 0="No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
246	Foodborne	GBReground	F49	Page 6, Ground Beef	52.13	Ground Beef	0/1/7/Null (blank)	Indicates if the beef was ground or reground by the retailer, 0="No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
247	Foodborne	GBRegroundComment	F50	Page 6, Ground Beef	52.13	Ground Beef	Text	Additional comments if beef was ground or reground
248	Foodborne	ArchivedPHAGEType1 ArchivedPHAGEType2 ArchivedPHAGEType3 ArchivedPHAGEType4	N/A	Page 6, Additional Salmonella questions	52.13	Salmonella	Text	Phage types of patient isolates. NORS question collected between Jan 2009 and March 2017. This question is no longer being collected, but the data entered during this period has been archived for reference.
249	Foodborne	ArchivedRDNCNumber1 ArchivedRDNCNumber2 ArchivedRDNCNumber3 ArchivedRDNCNumber4	N/A	Page 6, Additional Salmonella questions	52.13	Salmonella	Text	If is RDNC ('Reacts, Does Not Conform), then what is the number? NORS question collected between Jan 2009 and March 2017. This question is no longer being collected, but the data entered during this period has been archived for reference.
250	Foodborne	EggName1 EggName2 EggName3 EggName4 EggName5 EggName6 EggName7	F51	Page 6, Eggs	52.13	Eggs	Text	Indicate if the eggs were ‘in shell, unpasteurized,’ ‘in shell, pasteurized,’ ‘packaged liquid or dry,’ ‘stored with inadequate refrigeration during or after sale,’ ‘consumed raw,’ ‘consumed undercooked,’ or ‘pooled’
251	Foodborne	SEFoundOnFarm	F52	Page 6, Eggs	52.13	Eggs	0/1/7/Null (blank)	Indicates if Salmonella enteritis was identified at the farm where the eggs originated, 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
252	Foodborne	EggComment	F53	Page 6, Eggs	52.13	Eggs	Text	Egg comments/remarks
253	Setting	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
254	Setting	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
255	Setting	MajorSetting	S1	Page 4, Major Setting of Exposure	N/A	P2P, Major setting of exposure	Text	Name of major setting where exposure occurred.
256	Setting	MajorSettingSpecify	S2	Page 4, Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Text	Additional details regarding major setting of exposure
257	Setting	GuestExposed	S3	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Number	Number of residents, guests, passengers, patients, etc. who were exposed in the major setting.
258	Setting	StaffExposed	S4	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Number	Number of staff, crew, etc. who were exposed in the major setting.
259	Setting	GuestIll	S5	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Number	Number of residents, guests, passengers, patients, etc. who were exposed in the major setting and became ill during the outbreak.
260	Setting	StaffIll	S6	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Number	Number of staff, crew, etc. who were exposed in the major setting and became ill during the outbreak.
261	Setting	GuestAR	S7	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Number	The attack rate among residents and guests, calculated by dividing the number of residents and guests ill by the number exposed.
262	Setting	StaffAR	S8	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Number	The attack rate among staff and crew, calculated by dividing the number of staff and crew ill by the number exposed.
263	Setting	OtherSetting1 OtherSetting2 OtherSetting3 OtherSetting4 OtherSetting5	S9	Page 4, Other Settings of Exposure	N/A	P2P, Attack rates for major setting of exposure	Text	The name(s) of any addtional settings of exposure for the outbreak
264	Setting	OtherSettingFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
265	Setting	OtherSettingDetails	S10	Page 4, Attack Rates for Major Setting of Exposure	N/A	P2P, Attack rates for major setting of exposure	Text	Additional details regarding other settings of exposure
266	Setting	ShigTravel	SH1	Page 3, Additional Shigella Questions	52.13	Settings, Shigella	0/1/7/Null (blank)	Indicates whether any case-patients report travel prior to illness onset.
267	Setting	ShigTravelType	SH2	Page 3, Additional Shigella Questions	52.13	Settings, Shigella	Text	Indicates whether travel was international, domestic, both, or unknown.
268	Setting	ShigImmun	SH3	Page 3, Additional Shigella Questions	52.13	Settings, Shigella	0/1/7/Null (blank)	Indicates whether any confirmed, suspected, or probable case-patients were immunocompromised.
269	Setting	ShigMSM	SH4	Page 3, Additional Shigella Questions	52.13	Settings, Shigella	0/1/7/Null (blank)	Indicates whether any confirmed, suspected, or probable cases were among men who have sex with men.
270	Animal	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
271	Animal	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
272	Animal	AnimalUndetermined	A1		52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates if an animal vehicle was not identified for the outbreak. Format depends on import and export program, 0="False", 1 or -1="True".
273	Animal	AnimalReasonEpi	A2	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether epidemiologic evidence determined that the outbreak was animal contact, with an undetermined vehicle.
274	Animal	AnimalReasonLab	A3	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether laboratory evidence determined that the outbreak was animal contact, with an undetermined vehicle.
275	Animal	AnimalReasonTrace	A4	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether traceback or environmental evidence determined that the outbreak was animal contact, with an undetermined vehicle.
276	Animal	AnimalReasonOther	A5	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether other evidence determined that the outbreak was animal contact, with an undetermined vehicle.
277	Animal	AnimalTypeName1 AnimalTypeName2 AnimalTypeName3	A6	Page 3, Animal Contact	52.13	Animal, Animal Contact	Text	Type(s) of animals involved
278	Animal	AnimalTypeSpecify1 AnimalTypeSpecify2 AnimalTypeSpecify3	A7	Page 3, Animal Contact	52.13	Animal, Animal Contact	Text	Specific animal type
279	Animal	AnimalConfirmed1 AnimalConfirmed2 AnimalConfirmed3	A8	Page 3, Animal Contact	52.13	Animal, Animal Contact		Indicate whether the animal vehicle was confirmed or suspected.
280	Animal	AnimalVehicleEpi1 AnimalVehicleEpi2 AnimalVehicleEpi3	A9	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether epidemiologic evidence helped identify the confirmed or suspected animal vehicle.
281	Animal	AnimalVehicleLab1 AnimalVehicleLab2 AnimalVehicleLab3	A10	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether laboratory evidence helped identify the confirmed or suspected animal vehicle.
282	Animal	AnimalVehicleTrace1 AnimalVehicleTrace2 AnimalVehicleTrace3	A11	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether environmental or traceback evidence helped identify the confirmed or suspected animal vehicle.
283	Animal	AnimalVehicleOther1 AnimalVehicleOther2 AnimalVehicleOther3	A12	Page 3, Animal Contact	52.13	Animal, Animal Contact	True/False, 1/0, or -1/0	Indicates whether other evidence helped identify the confirmed or suspected animal vehicle.
284	Animal	AnimalSetting1 AnimalSetting2 AnimalSetting3	A13	Page 3, Animal Contact	52.13	Animal, Animal Contact	Text	Name(s) of setting(s) of exposure.
285	Animal	AnimalFeedImplicated	A14	Page 3, Animal Contact	52.13	Animal, Animal Contact	0/1/7/Null (blank)	Indicates whether pet food or animal feed was implicated as a potential source of the outbreak. 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
286	Animal	AnimalFeedType1 AnimalFeedType2 AnimalFeedType3	A15	Page 3, Animal Contact	52.13	Animal, Animal Contact	Text	Indicates the type of pet food implicated.
287	Animal	AnimalLivestockPet	A16	Page 3, Animal Contact	52.13	Animal, Animal Contact	0/1/7/Null (blank)	Indicates whether any cases had exposure to livestock or household pets that were experiencing diarrhea. 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
288	Animal	AnimalCompendium	A17	Page 3, Animal Contact	52.13	Animal, Animal Contact	0/1/7/Null (blank)	Indicates whether the Compendium of Measures to Prevent Disease Associated with Animals in Public Settings was used in the investigation. 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
289	Animal	AnimalPrevention1 AnimalPrevention2 AnimalPrevention3	A18	Page 3, Animal Contact	52.13	Animal, Animal Contact	Text	Indicates what preventions measures or recommendations were used to stop the outbreak.
290	Animal	AnimalRemarks	A19	Page 3, Animal Contact	52.13	Animal, Animal Contact	Text	Animal remarks/comments
291	Animal	AnimalFlag	N/A	N/A	N/A	N/A	Text	Indicates whether or not additional rows of data are available in NORS that could not be downloaded in the flat file structure due to size limits. 0="False", 1="True" Format depends on export and import program
292	WaterGeneral_Etiology	CDCID	G1	Page 1, CDC Use Only	52.12 and 52.13	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
293	WaterGeneral_Etiology	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
294	WaterGeneral_Etiology	WaterExposure	W1	Page 3, Type of Water Exposure	52.12	Water, Type of Water Exposure	Text	The implicated type of water exposure for a waterborne disease outbreak.
295	WaterGeneral_Etiology	NumberExposed	W2	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	Estimated total number of persons with the primary water exposure, as determined by the epidemiologic investigation.
296	WaterGeneral_Etiology	ComparisonGroup	W3	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	0/1/7/Null (blank)	Question: Were data collected from comparison groups to estimate risk? 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
297	WaterGeneral_Etiology	CommonSource	W4	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	0/1/7/Null (blank)	Question: If response to EstimatedRisk=0 (No) or Unknown (7), was water the only common source shared by persons who were ill? 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
298	WaterGeneral_Etiology	EpiExposure1 EpiExposure2 EpiExposure3 EpiExposure4 EpiExposure5	W5	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Text	A vehicle of pathogen transmission, such as an exposure (e.g., swimming pool use) or setting (e.g., hotel stay), measured in an epidemiologic study.
299	WaterGeneral_Etiology	TotalExposed1 TotalExposed2 TotalExposed3 TotalExposed4 TotalExposed5	W6	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The total number of people that reported a specific exposure in an epidemiologic study
300	WaterGeneral_Etiology	IllExposed1 IllExposed2 IllExposed3 IllExposed4 IllExposed5	W7	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The total number of people that reported a specific exposure who also met the case definition in an epidemiologic study.
301	WaterGeneral_Etiology	NotExposed1 NotExposed2 NotExposed3 NotExposed4 NotExposed5	W8	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The total number of people that did not report a specific exposure in an epidemiologic study
302	WaterGeneral_Etiology	IllNotExposed1 IllNotExposed2 IllNotExposed3 IllNotExposed4 IllNotExposed5	W9	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The total number of people that did not report a specific exposure and did meet the case definition in an epidemiologic study.
303	WaterGeneral_Etiology	EpiAttackRate1 EpiAttackRate2 EpiAttackRate3 EpiAttackRate4 EpiAttackRate5	W10	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Percentage, 0.00-100.00	The percentage of people that reported a specific exposure and met the case definition in an epidemiologic study. This attack rate is automatically calculated by NORS using the following equation: AttackRate=IllExposed/TotalExposed
304	WaterGeneral_Etiology	OddsRatio1 OddsRatio2 OddsRatio3 OddsRatio4 OddsRatio5	W11	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The odds ratio, with reference to a vehicle of transmission investigated in a waterborne disease outbreak. Displays value up to two decimal places.
305	WaterGeneral_Etiology	RelativeRisk1 RelativeRisk2 RelativeRisk3 RelativeRisk4 RelativeRisk5	W12	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The relative risk, with reference to a vehicle of transmission investigated in a waterborne disease outbreak. Displays value up to two decimal places.
306	WaterGeneral_Etiology	pValue1 pValue2 pValue3 pValue4 pValue5	W13	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Number	The p-value, with reference to a vehicle of transmission investigated in a waterborne disease outbreak. Displays value up to four decimal places.
307	WaterGeneral_Etiology	ConfidenceInterval1 ConfidenceInterval2 ConfidenceInterval3 ConfidenceInterval4 ConfidenceInterval5	W14	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Text	The confidence interval, with reference to a vehicle of transmission investigated in a waterborne disease outbreak. The format for this variable is ##.## - ##.##.
308	WaterGeneral_Etiology	AttackRateRes	W15	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Percentage, 0.00-100.00	Provides information from the epidemiologic investigation about the attack rate for cases who were residents of the reporting state.
309	WaterGeneral_Etiology	AttackRateNonRes	W16	Page 3, Epidemiologic Data	52.12	Water, Epidemiologic Data	Percentage, 0.00-100.00	Provides information from the epidemiologic investigation about the attack rate for cases who were not residents of the reporting state.
310	WaterGeneral_Etiology	InReportingState	W17	Page 3, Geographic Location	52.12	Water, Epidemiologic Data	Percentage, 0.00-100.00	The percentage of primary cases in a waterborne disease outbreak that live in the reporting state.
311	WaterGeneral_Etiology	AssociatedEvent	W18	Page 3, Associated Events	52.12	Water, Epidemiologic Data	0/1/7/Null (blank)	Question: Was exposure associated with a specific event or gathering? 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
312	WaterGeneral_Etiology	EventName	W19	Page 3, Associated Events	52.12	Water, Epidemiologic Data	Text	The type of event or gathering (If the water exposure implicated in the outbreak investigation was associated with a specific event or gathering).
313	WaterGeneral_Etiology	EventStart	W20	Page 3, Associated Events	52.12	Water, Epidemiologic Data	MM/DD/YYYY Time	Date that the event ended.
314	WaterGeneral_Etiology	EventEnd	W21	Page 3, Associated Events	52.12	Water, Epidemiologic Data	MM/DD/YYYY Time	Date that the event started.
315	WaterGeneral_Etiology	RouteIngestion	W22	Page 3, Route of Entry	52.12	Water, Epidemiologic Data	True/False, 1/0, or -1/0	Indicates ingestion is a route of entry for the waterborne disease outbreak. An outbreak may have more than one route of entry.
316	WaterGeneral_Etiology	RouteContact	W22	Page 3, Route of Entry	52.12	Water, Epidemiologic Data	True/False, 1/0, or -1/0	Indicates contact is a route of entry for the waterborne disease outbreak. An outbreak may have more than one route of entry.
317	WaterGeneral_Etiology	RouteInhalation	W22	Page 3, Route of Entry	52.12	Water, Epidemiologic Data	True/False, 1/0, or -1/0	Indicates inhalation is a route of entry for the waterborne disease outbreak. An outbreak may have more than one route of entry.
318	WaterGeneral_Etiology	RouteOther	W22	Page 3, Route of Entry	52.12	Water, Epidemiologic Data	True/False, 1/0, or -1/0	Indicates 'other' as a route of entry for the waterborne disease outbreak. An outbreak may have more than one route of entry.
319	WaterGeneral_Etiology	RouteUnknown	W22	Page 3, Route of Entry	52.12	Water, Epidemiologic Data	True/False, 1/0, or -1/0	Indicates route of entry for the waterborne disease outbreak is unknown.
320	WaterGeneral_Etiology	EtiologyStatus1 EtiologyStatus2 EtiologyStatus3 EtiologyStatus4 EtiologyStatus5 EtiologyStatus6	W23	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Designates whether or not a reported etiologic agent for a waterborne disease outbreak is a confirmed or a suspected etiology.
321	WaterGeneral_Etiology	EtiologyGenus1 EtiologyGenus2 EtiologyGenus3 EtiologyGenus4 EtiologyGenus5 EtiologyGenus6	W24	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Genus reported in the Etiology table for waterborne disease outbreaks. This variable is also used to report chemicals and toxins. The Etiology table may be used to report confirmed and suspected etiologies, including when an outbreak etiology is unknown.
322	WaterGeneral_Etiology	EtiologySpecies1 EtiologySpecies2 EtiologySpecies3 EtiologySpecies4 EtiologySpecies5 EtiologySpecies6	W25	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Species reported in the Etiology table for waterborne disease outbreaks.
323	WaterGeneral_Etiology	EtiologySero1 EtiologySero2 EtiologySero3 EtiologySero4 EtiologySero5 EtiologySero6	W26	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Serotype/Serogroup/Serovar reported in the Etiology table for waterborne disease outbreaks.
324	WaterGeneral_Etiology	EtiologyGeno1 EtiologyGeno2 EtiologyGeno3 EtiologyGeno4 EtiologyGeno5 EtiologyGeno6	W27	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Genotype/Subtype reported in the Etiology table for waterborne disease outbreaks.
325	WaterGeneral_Etiology	EtiologyPolymerase1 EtiologyPolymerase2 EtiologyPolymerase3 EtiologyPolymerase4 EtiologyPolymerase5 EtiologyPolymerase6	W26	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Polymerase type of a norovirus strain identified as an outbreak etiology
326	WaterGeneral_Etiology	EtiologyCapsid1 EtiologyCapsid2 EtiologyCapsid3 EtiologyCapsid4 EtiologyCapsid5 EtiologyCapsid6	W26	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Capsid type of a norovirus strain identified as an outbreak etiology
327	WaterGeneral_Etiology	EtiologyDetectedIn1 EtiologyDetectedIn2 EtiologyDetectedIn3 EtiologyDetectedIn4 EtiologyDetectedIn5 EtiologyDetectedIn6	W28	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Text	Information on what types of specimens or samples this microbial pathogen or chemical/toxin was detected in (e.g., clinical specimens)
328	WaterGeneral_Etiology	TotalTested1 TotalTested2 TotalTested3 TotalTested4 TotalTested5 TotalTested6	W29	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Number	The number of people tested for an etiologic agent in a waterborne disease outbreak.
329	WaterGeneral_Etiology	TotalPositive1 TotalPositive2 TotalPositive3 TotalPositive4 TotalPositive5 TotalPositive6	W30	Page 4, Outbreak Etiology	52.12	Etiology & Lab, General Etiology	Number	The number of people tested for an etiologic agent in a waterborne disease outbreak who tested positive. The number should be less than or equal to the number of people reported in TotalTested
330	WaterGeneral_Etiology	EtiologyGroup1_1 EtiologyGroup2_1 EtiologyGroup1_2 EtiologyGroup2_2 EtiologyGroup1_3 EtiologyGroup2_3 EtiologyGroup1_4 EtiologyGroup2_4 EtiologyGroup1_5 EtiologyGroup2_5 EtiologyGroup1_6 EtiologyGroup2_6	N/A	N/A	N/A	N/A	Text	Indicates whether listed etiology is bacterial, chemical, viral, parasitic, etc. Value is automatically assigned for analysis purposes. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., EtiologyGroup1_1, EtiologyGroup2_1 are a set that link back to EtiologyStatus1, EtiologyGenus1, EtiologySpecies1, etc.)
331	WaterGeneral_Etiology	CDCLabSystem1 CDCLabSystem2 CDCLabSystem3 CDCLabSystem4 CDCLabSystem5	W31	Page 4, Outbreak Isolates	52.12	Etiology & Lab, General Etiology	Text	The CDC system that contains data about this isolate (e.g., PulseNet, CaliciNet)
332	WaterGeneral_Etiology	CDCLabSystemID1 CDCLabSystemID2 CDCLabSystemID3 CDCLabSystemID4 CDCLabSystemID5	W32	Page 4, Outbreak Isolates	52.12	Etiology & Lab, General Etiology	Text	A unique identifier by the CDC laboratory to assist with data management (e.g., PulseNet Tracking Number)
333	WaterGeneral_Etiology	StateLabSystemID1 StateLabSystemID2 StateLabSystemID3 StateLabSystemID4 StateLabSystemID5	W33	Page 4, Outbreak Isolates	52.12	Etiology & Lab, General Etiology	Text	A unique identifier assigned by the state laboratory to assist with tracking or other aspects of data management.
334	WaterGeneral_Etiology	MolecularDesignation1_1 MolecularDesignation2_1 MolecularDesignation1_2 MolecularDesignation2_2 MolecularDesignation1_3 MolecularDesignation2_3 MolecularDesignation1_4 MolecularDesignation2_4 MolecularDesignation1_5 MolecularDesignation2_5	W34	Page 4, Outbreak Isolates	52.12	Etiology & Lab, General Etiology	Text	The specimen profile for a clinical isolate. For example, the CDC PulseNet pattern designation for enzyme 1. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
335	WaterGeneral_Etiology	NARMSResistance1 NARMSResistance2 NARMSResistance3 NARMSResistance4 NARMSResistance5				Etiology & Lab, General Etiology	Text	CDC NARMS predicted resistance pattern based on resistance determinants.
336	WaterGeneral_Etiology	NARMSAST1 NARMSAST2 NARMSAST3 NARMSAST4 NARMSAST5				Etiology & Lab, General Etiology	Text	CDC NARMS antimicrobial susceptibility testing (AST) results.
337	WaterGeneral_Etiology	IsolateFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates additional isolate information is available in NORS and was not downloaded due to file size restrictions
338	WaterGeneral_Etiology	ClinicalSpecimens	W36	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	0/1/7/Null (blank)	Question: Were clinical diagnostic specimens taken from persons? 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
339	WaterGeneral_Etiology	SpecimenCount	W37	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	Number	The number of persons from whom clinical specimens were collected, if clinical diagnostic specimens were collected (waterborne disease outbreak).
340	WaterGeneral_Etiology	SpecimenType1 SpecimenType2 SpecimenType3 SpecimenType4 SpecimenType5	W38	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	Text	The type(s) of clinical specimens collected for a waterborne disease outbreak. Autopsy and biopsy specimens may have additional descriptions in the SpecimenSubtype field.
341	WaterGeneral_Etiology	SpecimenSubtype1 SpecimenSubtype2 SpecimenSubtype3 SpecimenSubtype4 SpecimenSubtype5	W39	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	Text	A variable that provides more information about autopsy and biopsy specimens collected in a waterborne disease outbreak.
342	WaterGeneral_Etiology	SpecimenTestedBacteria1 SpecimenTestedBacteria2 SpecimenTestedBacteria3 SpecimenTestedBacteria4 SpecimenTestedBacteria5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that a clinical specimen was tested for bacteria in a waterborne disease outbreak.
343	WaterGeneral_Etiology	SpecimenTestedChemicals1 SpecimenTestedChemicals2 SpecimenTestedChemicals3 SpecimenTestedChemicals4 SpecimenTestedChemicals5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that a clinical specimen was tested for chemicals in a waterborne disease outbreak.
344	WaterGeneral_Etiology	SpecimenTestedFungi1 SpecimenTestedFungi2 SpecimenTestedFungi3 SpecimenTestedFungi4 SpecimenTestedFungi5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that a clinical specimen was tested for fungi in a waterborne disease outbreak.
345	WaterGeneral_Etiology	SpecimenTestedParasites1 SpecimenTestedParasites2 SpecimenTestedParasites3 SpecimenTestedParasites4 SpecimenTestedParasites5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that a clinical specimen was tested for parasites in a waterborne disease outbreak.
346	WaterGeneral_Etiology	SpecimenTestedViruses1 SpecimenTestedViruses2 SpecimenTestedViruses3 SpecimenTestedViruses4 SpecimenTestedViruses5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that a clinical specimen was tested for viruses in a waterborne disease outbreak.
347	WaterGeneral_Etiology	SpecimenTestedOther1 SpecimenTestedOther2 SpecimenTestedOther3 SpecimenTestedOther4 SpecimenTestedOther5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that a clinical specimen was tested for an etiologic agent category not listed in a waterborne disease outbreak.
348	WaterGeneral_Etiology	SpecimenTestedUnknown1 SpecimenTestedUnknown2 SpecimenTestedUnknown3 SpecimenTestedUnknown4 SpecimenTestedUnknown5	W40	Page 4, Clinical Specimens	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that the etiologic agent category that a clinical specimen was tested for in a waterborne disease outbreak is unknown.
349	WaterGeneral_Etiology	EtiologyTestChem	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using chemical testing methods. 0="False", 1or -1="True" Format depends on export and import program
350	WaterGeneral_Etiology	EtiologyTestCulture	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using culture methods. 0="False", 1or -1="True" Format depends on export and import program
351	WaterGeneral_Etiology	EtiologyTestPCR	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using DNA or RNA amplification methods. 0="False", 1or -1="True" Format depends on export and import program
352	WaterGeneral_Etiology	EtiologyTestMicro	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using microscopy methods. 0="False", 1or -1="True" Format depends on export and import program
353	WaterGeneral_Etiology	EtiologyTestSero	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using serological or imunological methods. 0="False", 1or -1="True" Format depends on export and import program
354	WaterGeneral_Etiology	EtiologyTestTissue	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using tissue culture infectivity assay. 0="False", 1or -1="True" Format depends on export and import program
355	WaterGeneral_Etiology	EtiologyTestOther	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using another method. 0="False", 1or -1="True" Format depends on export and import program
356	WaterGeneral_Etiology	EtiologyTestUnknown	W41	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	True/False, 1/0, or -1/0	Indicates that specimens/samples were tested using an unknown methods. 0="False", 1or -1="True" Format depends on export and import program
357	WaterGeneral_Etiology	AST	W42	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	0/1/7/Null (blank)	Indicates whether any samples were tested for antimicrobial resistance. 0="No", 1="Yes", 7="Unknown", null (blank) = no response
358	WaterGeneral_Etiology	ASTSetting1 ASTSetting2 ASTSetting3	W43	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	Text	Indicates where AST was performed ('Clinical Lab', 'Public Health Lab', 'CDC-NARMS', 'Other', 'Unknown')
359	WaterGeneral_Etiology	ASTOutbreakStrains	W44	Page 4, Testing Information	52.12	Etiology & Lab, Clinical Specimens	0/1/7/Null (blank)	Question: "If yes, were any antimicrobial resistant strains associated with the outbreak?" 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No
360	WaterSamples	CDCID	G1	Page 1, CDC Use Only	52.12 and 52.13	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
361	WaterSamples	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
362	WaterSamples	WaterTested	W45	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	0/1/7/Null (blank)	Question: Was water tested? 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
363	WaterSamples	WaterSampleFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates additional water sample information is available in NORS and was not downloaded due to file size restrictions
364	WaterSamples	WaterSampleSourceFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates additional sample source information is available in NORS and was not downloaded due to file size restrictions
365	WaterSamples	WaterIndicatorFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates additional indicator information is available in NORS and was not downloaded due to file size restrictions
366	WaterSamples	WaterAnalysisFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates additional isolate information is available in NORS and was not downloaded due to file size restrictions
367	WaterSamples	SampleSource1_1 SampleSource2_1 SampleSource1_2 SampleSource2_2 SampleSource1_3 SampleSource2_3 SampleSource1_4 SampleSource2_4 SampleSource1_5 SampleSource2_5	W46	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Text	A description of the source or location of a water sample (e.g., pool, lake, hot water tank, cooling tower).
368	WaterSamples	SampleDescription1 SampleDescription2 SampleDescription3 SampleDescription4 SampleDescription5	W47	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Text	Written description of the sample (e.g., more detailed information about where it was collected)
369	WaterSamples	SampleDate1 SampleDate2 SampleDate3 SampleDate4 SampleDate5	W48	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	MM/DD/YYYY Time	Date that the water sample was collected and onsite measurements such as temperature, volume and pH were taken.
370	WaterSamples	Volume1 Volume2 Volume3 Volume4 Volume5	W49	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Number	The volume of water collected for a water sample.
371	WaterSamples	VolumeUnit1 VolumeUnit2 VolumeUnit3 VolumeUnit4 VolumeUnit5	W50	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Text	The unit of measure for the Volume variable.
372	WaterSamples	Temp1 Temp2 Temp3 Temp4 Temp5	W51	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Number	The temperature of the water sample.
373	WaterSamples	TempUnit1 TempUnit2 TempUnit3 TempUnit4 TempUnit5	W52	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Text	The unit of measure for the Temperature variable.
374	WaterSamples	Residual1 Residual2 Residual3 Residual4 Residual5	W53	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Number	The residual/free disinfectant level measured for a water sample.
375	WaterSamples	ResidualUnit1 ResidualUnit2 ResidualUnit3 ResidualUnit4 ResidualUnit5	W54	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Text	The unit of measure associated with the residual/free disinfectant level measured for a water sample.
376	WaterSamples	Combined1 Combined2 Combined3 Combined4 Combined5	W55	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Number	The combined disinfectant level measured for a water sample.
377	WaterSamples	CombinedUnit1 CombinedUnit2 CombinedUnit3 CombinedUnit4 CombinedUnit5	W56	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Text	The unit of measure associated with the combined disinfectant level measured for a water sample.
378	WaterSamples	pH1 pH2 pH3 pH4 pH5	W57	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Number	The pH measured for a water sample. Displays value up to two decimal places.
379	WaterSamples	Turbidity1 Turbidity2 Turbidity3 Turbidity4 Turbidity5	W58	Page 5, Water Samples	52.12	Etiology & Lab, Water Samples	Number	The turbidity (in NTU) measured for a water sample.
380	WaterSamples	IndicatorType1_1 IndicatorType2_1 IndicatorType3_1 IndicatorType4_1 IndicatorType1_2 IndicatorType2_2 IndicatorType3_2 IndicatorType4_2 IndicatorType1_3 IndicatorType2_3 IndicatorType3_3 IndicatorType4_3 IndicatorType1_4 IndicatorType2_4 IndicatorType3_4 IndicatorType4_4 IndicatorType1_5 IndicatorType2_5 IndicatorType3_5 IndicatorType4_5	W59	Page 5, Water Samples - Water Quality Indicators	52.12	Etiology & Lab, Water Samples	Text	The type of water quality indicator (e.g., fecal coliforms) measured for a water sample. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
381	WaterSamples	IndicatorConc1_1 IndicatorConc2_1 IIndicatorConc3_1 IndicatorConc4_1 IndicatorConc1_2 IndicatorConc2_2 IndicatorConc3_2 IndicatorConc4_2 IndicatorConc1_3 IndicatorConc2_3 IndicatorConc3_3 IndicatorConc4_3 IndicatorConc1_4 IndicatorConc2_4 IndicatorConc3_4 IndicatorConc4_4 IndicatorConc1_5 IndicatorConc2_5 IndicatorConc3_5 IndicatorConc4_5	W60	Page 5, Water Samples - Water Quality Indicators	52.12	Etiology & Lab, Water Samples	Number	Concentration reported for IndicatorType based on results from laboratory testing. See IndicatorUnit for the measurement unit associated with this value. Displays as a whole number. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
382	WaterSamples	IndicatorUnit1_1 IndicatorUnit2_1 IndicatorUnit3_1 IndicatorUnit4_1 IndicatorUnit1_2 IndicatorUnit2_2 IndicatorUnit3_2 IndicatorUnit4_2 IndicatorUnit1_3 IndicatorUnit2_3 IndicatorUnit3_3 IndicatorUnit4_3 IndicatorUnit1_4 IndicatorUnit2_4 IndicatorUnit3_4 IndicatorUnit4_4 IndicatorUnit1_5 IndicatorUnit2_5 IndicatorUnit3_5 IndicatorUnit4_5	W61	Page 5, Water Samples - Water Quality Indicators	52.12	Etiology & Lab, Water Samples	Text	Unit of measurement (e.g., CFU/100mL) for IndicatorConc based on results from laboratory testing. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
383	WaterSamples	AnalysisGenus1_1 AnalysisGenus2_1 AnalysisGenus3_1 AnalysisGenus4_1 AnalysisGenus1_2 AnalysisGenus2_2 AnalysisGenus3_2 AnalysisGenus4_2 AnalysisGenus1_3 AnalysisGenus2_3 AnalysisGenus3_3 AnalysisGenus4_3 AnalysisGenus1_4 AnalysisGenus2_4 AnalysisGenus3_4 AnalysisGenus4_4 AnalysisGenus1_5 AnalysisGenus2_5 AnalysisGenus3_5 AnalysisGenus4_5	W62	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Genus reported for water samples collected during waterborne disease outbreak investigations. This variable is also used to report chemicals and toxins. Positive and negative test results may be reported. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
384	WaterSamples	AnalysisSpecies1_1 AnalysisSpecies2_1 AnalysisSpecies3_1 AnalysisSpecies4_1 AnalysisSpecies1_2 AnalysisSpecies2_2 AnalysisSpecies3_2 AnalysisSpecies4_2 AnalysisSpecies1_3 AnalysisSpecies2_3 AnalysisSpecies3_3 AnalysisSpecies4_3 AnalysisSpecies1_4 AnalysisSpecies2_4 AnalysisSpecies3_4 AnalysisSpecies4_4 AnalysisSpecies1_5 AnalysisSpecies2_5 AnalysisSpecies3_5 AnalysisSpecies4_5	W63	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Species reported for water samples collected during waterborne disease outbreak investigations. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
385	WaterSamples	AnalysisSero1_1 AnalysisSero2_1 AnalysisSero3_1 AnalysisSero4_1 AnalysisSero1_2 AnalysisSero2_2 AnalysisSero3_2 AnalysisSero4_2 AnalysisSero1_3 AnalysisSero2_3 AnalysisSero3_3 AnalysisSero4_3 AnalysisSero1_4 AnalysisSero2_4 AnalysisSero3_4 AnalysisSero4_4 AnalysisSero1_5 AnalysisSero2_5 AnalysisSero3_5 AnalysisSero4_5	W64	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Serotype/Serogroup/Serovar reported for water samples collected during waterborne disease outbreak investigations. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
386	WaterSamples	AnalysisGeno1_1 AnalysisGeno2_1 AnalysisGeno3_1 AnalysisGeno4_1 AnalysisGeno1_2 AnalysisGeno2_2 AnalysisGeno3_2 AnalysisGeno4_2 AnalysisGeno1_3 AnalysisGeno2_3 AnalysisGeno3_3 AnalysisGeno4_3 AnalysisGeno1_4 AnalysisGeno2_4 AnalysisGeno3_4 AnalysisGeno4_4 AnalysisGeno1_5 AnalysisGeno2_5 AnalysisGeno3_5 AnalysisGeno4_5	W65	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Genotype/Subtype reported for water samples collected during waterborne disease outbreak investigations. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
387	WaterSamples	AnalysisPolymerase1_1 AnalysisPolymerase2_1 AnalysisPolymerase3_1 AnalysisPolymerase4_1 AnalysisPolymerase1_2 AnalysisPolymerase2_2 AnalysisPolymerase3_2 AnalysisPolymerase4_2 AnalysisPolymerase1_3 AnalysisPolymerase2_3 AnalysisPolymerase3_3 AnalysisPolymerase4_3 AnalysisPolymerase1_4 AnalysisPolymerase2_4 AnalysisPolymerase3_4 AnalysisPolymerase4_4 AnalysisPolymerase1_5 AnalysisPolymerase2_5 AnalysisPolymerase3_5 AnalysisPolymerase4_5	W64	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Polymerase type of a norovirus strain identified in a water sample
388	WaterSamples	AnalysisCapsid1_1 AnalysisCapsid2_1 AnalysisCapsid3_1 AnalysisCapsid4_1 AnalysisCapsid1_2 AnalysisCapsid2_2 AnalysisCapsid3_2 AnalysisCapsid4_2 AnalysisCapsid1_3 AnalysisCapsid2_3 AnalysisCapsid3_3 AnalysisCapsid4_3 AnalysisCapsid1_4 AnalysisCapsid2_4 AnalysisCapsid3_4 AnalysisCapsid4_4 AnalysisCapsid1_5 AnalysisCapsid2_5 AnalysisCapsid3_5 AnalysisCapsid4_5	W64	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Capsid type of a norovirus strain identified in a water sample
389	WaterSamples	AnalysisPFGE1_1 AnalysisPFGE2_1 AnalysisPFGE3_1 AnalysisPFGE4_1 AnalysisPFGE1_2 AnalysisPFGE2_2 AnalysisPFGE3_2 AnalysisPFGE4_2 AnalysisPFGE1_3 AnalysisPFGE2_3 AnalysisPFGE3_3 AnalysisPFGE4_3 AnalysisPFGE1_4 AnalysisPFGE2_4 AnalysisPFGE3_4 AnalysisPFGE4_4 AnalysisPFGE1_5 AnalysisPFGE2_5 AnalysisPFGE3_5 AnalysisPFGE4_5	W66	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	The PFGE pattern for an isolate obtained from a water sample. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
390	WaterSamples	AnalysisPositive1_1 AnalysisPositive2_1 AnalysisPositive3_1 AnalysisPositive4_1 AnalysisPositive1_2 AnalysisPositive2_2 AnalysisPositive3_2 AnalysisPositive4_2 AnalysisPositive1_3 AnalysisPositive2_3 AnalysisPositive3_3 AnalysisPositive4_3 AnalysisPositive1_4 AnalysisPositive2_4 AnalysisPositive3_4 AnalysisPositive4_4 AnalysisPositive1_5 AnalysisPositive2_5 AnalysisPositive3_5 AnalysisPositive4_5	W67	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	True/False, 1/0, or -1/0	Indicates whether or not an water sample tested positive for a microorganism, chemical or toxin. Value is automatically assigned for analysis purposes. 0="False, or Test Results Negative", 1="Yes, or Test Results Positive" Format depends on export and import program. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
391	WaterSamples	AnalysisConc1_1 AnalysisConc2_1 AnalysisConc3_1 AnalysisConc4_1 AnalysisConc1_2 AnalysisConc2_2 AnalysisConc3_2 AnalysisConc4_2 AnalysisConc1_3 AnalysisConc2_3 AnalysisConc3_3 AnalysisConc4_3 AnalysisConc1_4 AnalysisConc2_4 AnalysisConc3_4 AnalysisConc4_4 AnalysisConc1_5 AnalysisConc2_5 AnalysisConc3_5 AnalysisConc4_5	W68	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Number	Concentration reported for a water sample that was analyzed for microorganisms, chemicals or toxins. See AnalysisUnit for the measurement unit associated with this value. For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
392	WaterSamples	AnalysisUnit1_1 AnalysisUnit2_1 AnalysisUnit3_1 AnalysisUnit4_1 AnalysisUnit1_2 AnalysisUnit2_2 AnalysisUnit3_2 AnalysisUnit4_2 AnalysisUnit1_3 AnalysisUnit2_3 AnalysisUnit3_3 AnalysisUnit4_3 AnalysisUnit1_4 AnalysisUnit2_4 AnalysisUnit3_4 AnalysisUnit4_4 AnalysisUnit1_5 AnalysisUnit2_5 AnalysisUnit3_5 AnalysisUnit4_5	W69	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	Unit of measurement (e.g., CFU/100mL) for AnalysisConc based on results from laboratory testing for microorganisms, chemicals or toxins.For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
393	WaterSamples	AnalysisTestType1_1 AnalysisTestType2_1 AnalysisTestType3_1 AnalysisTestType4_1 AnalysisTestType1_2 AnalysisTestType2_2 AnalysisTestType3_2 AnalysisTestType4_2 AnalysisTestType1_3 AnalysisTestType2_3 AnalysisTestType3_3 AnalysisTestType4_3 AnalysisTestType1_4 AnalysisTestType2_4 AnalysisTestType3_4 AnalysisTestType4_4 AnalysisTestType1_5 AnalysisTestType2_5 AnalysisTestType3_5 AnalysisTestType4_5	W70	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	A description of the laboratory methods (e.g., microscopy, RNA/DNA tests) used to test for a microorganism, chemical or toxin in a water sample.For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
394	WaterSamples	AnalysisTestMethod1_1 AnalysisTestMethod2_1 AnalysisTestMethod3_1 AnalysisTestMethod4_1 AnalysisTestMethod1_2 AnalysisTestMethod2_2 AnalysisTestMethod3_2 AnalysisTestMethod4_2 AnalysisTestMethod1_3 AnalysisTestMethod2_3 AnalysisTestMethod3_3 AnalysisTestMethod4_3 AnalysisTestMethod1_4 AnalysisTestMethod2_4 AnalysisTestMethod3_4 AnalysisTestMethod4_4 AnalysisTestMethod1_5 AnalysisTestMethod2_5 AnalysisTestMethod3_5 AnalysisTestMethod4_5	W71	Page 5, Water Samples - Microbiology or Chemical/Toxin Analysis	52.12	Etiology & Lab, Water Samples	Text	The standardized laboratory method used to test a water sample for a microorganism, chemical or toxin. Abbreviated format used in NORS has the information ordered as follows: Method source, Method number and Method summary. E.g., ASTM D1293-pH (routine/continuous measurement). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
395	ImplicatedWater	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
396	ImplicatedWater	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
397	ImplicatedWater	WaterTypeFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether additional water type information is available in NORS and was not downloaded due to file size restrictions
398	ImplicatedWater	RecWaterTreatmentFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether additional treatment information is available in NORS and was not downloaded due to size restrictions
399	ImplicatedWater	FillWaterFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether additional fill water information is available in NORS and was not downloaded due to size restrictions
400	ImplicatedWater	RecTreatedVenue1 RecTreatedVenue2 RecTreatedVenue3 RecTreatedVenue4 RecTreatedVenue5	W72	Page 6, Recreational Water Venue Description	52.12	Rec. Treated,Water Venue	Text	Water venue of exposure (e.g. spa/whirlpool/hot tub; pool-swimming pool; pool-waterpark)
401	ImplicatedWater	RecTreatedSubType1 RecTreatedSubType2 RecTreatedSubType3 RecTreatedSubType4 RecTreatedSubType5	W73	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	Water venue subtype (i.e. indoor, outdoor, or unknown)
402	ImplicatedWater	RecTreatedSetting1 RecTreatedSetting2 RecTreatedSetting3 RecTreatedSetting4 RecTreatedSetting5	W74	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	Setting of exposure (e.g. club, requiring membership; hotel/motel/lodge/inn; waterpark)
403	ImplicatedWater	RecTreatment1_1 RecTreatment2_1 RecTreatment3_1 RecTreatment4_1 RecTreatment1_2 RecTreatment2_2 RecTreatment3_2 RecTreatment4_2 RecTreatment1_3 RecTreatment2_3 RecTreatment3_3 RecTreatment4_3 RecTreatment1_4 RecTreatment2_4 RecTreatment3_4 RecTreatment4_4 RecTreatment1_5 RecTreatment2_5 RecTreatment3_5 RecTreatment4_5	W75	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	The usual type of water treatment provided at venue (e.g. no treatment, coagulation, disinfection, floculation, filtration [pool], unknown). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
404	ImplicatedWater	RecTreatmentSub1_1 RecTreatmentSub2_1 RecTreatmentSub3_1 RecTreatmentSub4_1 RecTreatmentSub1_2 RecTreatmentSub2_2 RecTreatmentSub3_2 RecTreatmentSub4_2 RecTreatmentSub1_3 RecTreatmentSub2_3 RecTreatmentSub3_3 RecTreatmentSub4_3 RecTreatmentSub1_4 RecTreatmentSub2_4 RecTreatmentSub3_4 RecTreatmentSub4_4 RecTreatmentSub1_5 RecTreatmentSub2_5 RecTreatmentSub3_5 RecTreatmentSub4_5	W76	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	Venue treatment subtype (disinfection or pool filtration: e.g., UV; chlorine dioxide; bag filter; cartridge filter; unknown). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
405	ImplicatedWater	Chlorination1_1 Chlorination2_1 Chlorination3_1 Chlorination4_1 Chlorination1_2 Chlorination2_2 Chlorination3_2 Chlorination4_2 Chlorination1_3 Chlorination2_3 Chlorination3_3 Chlorination4_3 Chlorination1_4 Chlorination2_4 Chlorination3_4 Chlorination4_4 Chlorination1_5 Chlorination2_5 Chlorination3_5 Chlorination4_5	W77	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	Chlorination subtype (chlorine disinfection only: e.g., gaseous; sodium hypochlorite; cyanurates/stabilized chlorine). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
406	ImplicatedWater	FillType1_1 FillType2_1 FillType3_1 FillType4_1 FillType1_2 FillType2_2 FillType3_2 FillType4_2 FillType1_3 FillType2_3 FillType3_3 FillType4_3 FillType1_4 FillType2_4 FillType3_4 FillType4_4 FillType1_5 FillType2_5 FillType3_5 FillType4_5	W78	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	Fill water type (e.g., public water supply; sea water; untreated ground or surface water; unknown). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
407	ImplicatedWater	FillTreatment1_1 FillTreatment2_1 FillTreatment3_1 FillTreatment4_1 FillTreatment1_2 FillTreatment2_2 FillTreatment3_2 FillTreatment4_2 FillTreatment1_3 FillTreatment2_3 FillTreatment3_3 FillTreatment4_3 FillTreatment1_4 FillTreatment2_4 FillTreatment3_4 FillTreatment4_4 FillTreatment1_5 FillTreatment2_5 FillTreatment3_5 FillTreatment4_5	W79	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	If public water supply, usual water treatment provided before coming to the venue (e.g., no treatment; disinfection; filtration [treatment plant]; unknown). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
408	ImplicatedWater	FillTreatmentSub1_1 FillTreatmentSub2_1 FillTreatmentSub3_1 FillTreatmentSub4_1 FillTreatmentSub1_2 FillTreatmentSub2_2 FillTreatmentSub3_2 FillTreatmentSub4_2 FillTreatmentSub1_3 FillTreatmentSub2_3 FillTreatmentSub3_3 FillTreatmentSub4_3 FillTreatmentSub1_4 FillTreatmentSub2_4 FillTreatmentSub3_4 FillTreatmentSub4_4 FillTreatmentSub1_5 FillTreatmentSub2_5 FillTreatmentSub3_5 FillTreatmentSub4_5	W80	Page 5, Vehicle Description (Treated Rec Water)	52.12	Rec. Treated,Water Venue	Text	If public water supply, fill water treatment subtype (disinfection or filtration: e.g., UV; chlorine dioxide; bag filter; cartridge filter; unknown). For variables ending in the format #_#, the first number uniquely identifies its order in a set. The second number identifies the set to which it belongs and relates back to one or more variables ending in that same number (e.g., MolecularDesignation1_1 , MolecularDesignation2_1 are a set that link back to CDCLabSystem1, CDCLabSystemID1, StateLabSystemID1, etc.)
409	ImplicatedWater	TreatedQuality	W81	Page 5, Recreational Water Quality (Treated)	52.12	Rec. Treated, Water Quality	0/1/7/9/Null (blank)	Question: Did the venue meet state or local recreational water quality regulations? 0= "No", 1= "Yes", 7= "Unknown", 9= "Not Applicable", Null (blank)= No Response
410	ImplicatedWater	TreatedQualText	W82	Page 5, Recreational Water Quality (Treated)	52.12	Rec. Treated, Water Quality	Text	Additional description, if TreatedQuality=0 (No)
411	ImplicatedWater	TreatedPoolOp	W83	Page 5, Recreational Water Quality (Treated)	52.12	Rec. Treated, Water Quality	0/1/7/Null (blank)	Question: Was there a pool operator on the payroll with state-approved training or certification? 0= "No", 1= "Yes", 7= "Unknown", Null (blank)= No Response
412	ImplicatedWater	RecUntreatedVenue1 RecUntreatedVenue2 RecUntreatedVenue3	W87	Page 7, Vehicle Description (Untreated Rec Water)	52.12	Water-Untreated, Vehicle Description	Text	Water venue implicated (e.g., canal; lake; river/stream; ocean)
413	ImplicatedWater	RecUntreatedSubType1 RecUntreatedSubType2 RecUntreatedSubType3	W88	Page 7, Vehicle Description (Untreated Rec Water)	52.12	Water-Untreated, Vehicle Description	Text	IF SPRING OR HOT SPRING, water venue subtype description (i.e. 'indoor', 'outdoor' or 'unknown')
414	ImplicatedWater	RecUntreatedSetting1 RecUntreatedSetting2 RecUntreatedSetting3	W89	Page 7, Vehicle Description (Untreated Rec Water)	52.12	Water-Untreated, Vehicle Description	Text	Setting of exposure (e.g., beach-public; camp/cabin/recreational area)
415	ImplicatedWater	UntreatedQuality	W90	Page 8, Recreational Water Quality (Untreated)	52.12	Rec. Untreated, Water Quality	0/1/7/9/Null (blank)	Question: Did the venue meet state or local recreational water quality regulations? 0= "No", 1= "Yes", 7= "Unknown", 9= "Not Applicable", Null (blank)= No Response
416	ImplicatedWater	UntreatedQualText	W91	Page 8, Recreational Water Quality (Untreated)	52.12	Rec. Untreated, Water Quality	Text	Additional description, if UntreatedQuality=0 (No)
417	ImplicatedWater	UntreatedEPA	W92	Page 8, Recreational Water Quality (Untreated)	52.12	Rec. Untreated, Water Quality	0/1/7/9/Null (blank)	Question: Did the venue meet Environmental Protection Agency (EPA) recreational water quality standards? 0= "No", 1= "Yes", 7= "Unknown", 9= "Not Applicable", Null (blank)= No Response
418	ImplicatedWater	UntreatedEPAText	W93	Page 8, Recreational Water Quality (Untreated)	52.12	Rec. Untreated, Water Quality	Text	Additional description, if UntreatedEPA=0 (No)
419	ImplicatedWater	DWSystem1 DWSystem2 DWSystem3 DWSystem4	W94	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	Water system (e.g., commercially-bottled water, community water system, individual water system)
420	ImplicatedWater	EPAID1 EPAID2 EPAID3 EPAID4	W95	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	Public water system EPA ID number
421	ImplicatedWater	DWSource1 DWSource2 DWSource3 DWSource4	W96	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	Water source (select ground water, surface water or unknown)
422	ImplicatedWater	DWDescription1 DWDescription2 DWDescription3 DWDescription4	W97	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	Water source description (e.g. spring; well; lake)
423	ImplicatedWater	DWSetting1 DWSetting2 DWSetting3 DWSetting4	W98	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	Setting of exposure (e.g., airport, mobile home park)
424	ImplicatedWater	DWTreatment1 DWTreatment2 DWTreatment3 DWTreatment4	W99	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	USUAL water treatment provided (e.g.,no treatment, disinfection, home filtration)
425	ImplicatedWater	DWTreatmentSub1 DWTreatmentSub2 DWTreatmentSub3 DWTreatmentSub4	W100	Page 9, Vehicle Descrption (Drinking Water)	52.12	Drinking, Water System	Text	Water treatment subtype (disinfection or filtration: e.g., boiling; chlorine; rapid sand filter; reserve osmosis)
426	ImplicatedWater	DrinkingMonth	W101	Page 9, Drinking Water Quality	52.12	Drinking, Water Quality	0/1/7/9/Null (blank)	Question: Did the drinking water system have any monitoring violations in the 1 month prior to the outbreak? 0= "No", 1= "Yes", 7= "Unknown", 9= "Not Applicable", Null (blank)= No Response
427	ImplicatedWater	DrinkingMonthText	W102	Page 9, Drinking Water Quality	52.12	Drinking, Water Quality	Text	Additional description, if DrinkingMonth = 1 (Yes)
428	ImplicatedWater	DrinkingMCL	W103	Page 9, Drinking Water Quality	52.12	Drinking, Water Quality	0/1/7/9/Null (blank)	Question: Did the drinking water system have any maximum contaminant level (MCL) violations in the 1 month prior to the outbreak? 0= "No", 1= "Yes", 7= "Unknown", 9= "Not Applicable", Null (blank)= No Response
429	ImplicatedWater	DrinkingMCLText	W104	Page 9, Drinking Water Quality	52.12	Drinking, Water Quality	Text	Additional description, if DrinkingMCL = 1 (Yes)
430	ImplicatedWater	DrinkingYear	W105	Page 9, Drinking Water Quality	52.12	Drinking, Water Quality	0/1/7/9/Null (blank)	Question: Did the drinking water system have any violations in the 12 months prior to the outbreak? 0= "No", 1= "Yes", 7= "Unknown", 9= "Not Applicable", Null (blank)= No Response
431	ImplicatedWater	DrinkingYearText	W106	Page 9, Drinking Water Quality	52.12	Drinking, Water Quality	Text	Additional description, if PreviousYearResponse = 1 (Yes)
432	ImplicatedWater	IntendedUse1 IntendedUse2 IntendedUse3 IntendedUse4 IntendedUse5	W111	Page 13, Intent for Use	52.12	Other/Unknown, Intent for Use	Text	What was the intended use for the implicated water? (i.e. cooling/air conditioning, mister, ornamental, industrial/occupational, agricultural irrigation, wast water, other (specify), unknown)
433	ImplicatedWater	OtherType1 OtherType2 OtherType3 OtherType4 OtherType5 OtherType6	W112	Page 13, Vehicle Description (WNID/WUI)	52.12	Other/Unknown, Water Description	Text	Water type (e.g., cooling tower; drainage ditch; fountain - ornamental)
434	ImplicatedWater	SettingOther1 SettingOther2 SettingOther3 SettingOther4 SettingOther5 SettingOther6	W113	Page 13, Vehicle Description (WNID/WUI)	52.12	Other/Unknown, Water Description	Text	Setting of exposure (e.g, airport; hospital/health care facility; nursing home; park-state park)
435	ImplicatedWater	TreatmentOther1 TreatmentOther2 TreatmentOther3 TreatmentOther4 TreatmentOther5 TreatmentOther6	W114	Page 13, Vehicle Description (WNID/WUI)	52.12	Other/Unknown, Water Description	Text	Usual water treatment provided (e.g., no treatment; disinfection; settling/sedimentation)
436	ImplicatedWater	TreatmentSubOther1 TreatmentSubOther2 TreatmentSubOther3 TreatmentSubOther4 TreatmentSubOther5 TreatmentSubOther6	W115	Page 13, Vehicle Description (WNID/WUI)	52.12	Other/Unknown, Water Description	Text	Water treatment subtype (disinfection or filtration: e.g., boiling; chlorine; rapid sand filter; reverse osmosis)
437	ImplicatedWater	WaterRemarks	W86	Page 7, Remarks (Treated Rec Water); Page 8, Remarks (Untreated Rec Water); Page 11, Remarks (Drinking Water); Page 12, Remarks (Other/Unknown)	52.12	(Rec. Treated, Rec. Untreated, Drinking, Other/Unknown), Remarks	Text	Remarks field at the end of the NORS report for additional information about the waterborne disease outbreak investigation.
438	ContributingFactors	CDCID	G1	Page 1, CDC Use Only	52.12 and 52.13	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
439	ContributingFactors	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
440	ContributingFactors	SourceFactor	W107	Page 10, Factors Contributing to… (Drinking Water)	52.12	Drinking, Contributing Factors	0/1/7/Null (blank)	Indicates a problem with the source water contributed to the outbreak 0='No', 1='Yes' 7='Unknown'
441	ContributingFactors	TreatmentFactor	W108	Page 10, Factors Contributing to… (Drinking Water)	52.12	Drinking, Contributing Factors	0/1/7/Null (blank)	Indicates a problem with the water treatment contributed to the outbreak 0='No', 1='Yes' 7='Unknown'
442	ContributingFactors	DistributionFactor	W109	Page 11, Factors Contributing to… (Drinking Water)	52.12	Drinking, Contributing Factors	0/1/7/Null (blank)	Indicates a problem with the water distribution system contributed to the outbreak 0='No', 1='Yes' 7='Unknown'
443	ContributingFactors	NonUtilityFactor	W110	Page 11, Factors Contributing to… (Drinking Water)	52.12	Drinking, Contributing Factors	0/1/7/Null (blank)	Indicates a problem with the water outside of a water utility jurisdiction contributed to the outbreak 0='No', 1='Yes' 7='Unknown'
444	ContributingFactors	WaterFactor1 WaterFactor2 WaterFactor3 WaterFactor4 WaterFactor5 WaterFactor6 WaterFactor7 WaterFactor8 WaterFactor9 WaterFactor10 WaterFactor11 WaterFactor12 WaterFactor13 WaterFactor14 WaterFactor15	W84	Page 7, Contributing Factors (Treated), Page 8, Contributing Factors (Untreated), Page 10/11, Contributing Factors (Drinking), Page 12, Contributing Factors (Other/Unknown)	52.12	Rec. Treated, Contributing Factors; Rec. Untreated, Contributing Factors; Drinking, Contributing Factors; Other/Unknown, Contributing Factors	Text	Contributing factor
445	ContributingFactors	FactorStatus1 FactorStatus2 FactorStatus3 FactorStatus4 FactorStatus5 FactorStatus6 FactorStatus7 FactorStatus8 FactorStatus9 FactorStatus10 FactorStatus11 FactorStatus12 FactorStatus13 FactorStatus14 FactorStatus15	W85	Page 7, Contributing Factors (Treated), Page 8, Contributing Factors (Untreated), Page 10/11, Contributing Factors (Drinking), Page 12, Contributing Factors (Other/Unknown)	52.12	Rec. Treated, Contributing Factors; Rec. Untreated, Contributing Factors; Drinking, Contributing Factors; Other/Unknown, Contributing Factors	True/False, 1/0, or -1/0	Is the contributing factor confirmed or suspected? 1='Confirmed', 0='Suspected'
446	ContributingFactors	FactorType1 FactorType2 FactorType3 FactorType4 FactorType5 FactorType6 FactorType7 FactorType8 FactorType9 FactorType10 FactorType11 FactorType12 FactorType13 FactorType14 FactorType15	N/A	N/A	52.12	Rec. Treated, Contributing Factors; Rec. Untreated, Contributing Factors; Drinking, Contributing Factors; Other/Unknown, Contributing Factors	Text	What type of water exposure is associated with the selected contributing factor? ('Treated', 'Untreated', 'Other/Unknown', 'Drinking-source water', 'Drinking-treatment', 'Drinking-distribution and storage', 'Drinking-point-of-use')
447	ContributingFactors	WaterFactorFlag	N/A	N/A	N/A	N/A	True/False, 1/0, or -1/0	Indicates whether additional information is available in NORS and was not downloaded due to size restrictions
448	Admin	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
449	Admin	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
450	Admin	Strength	N/A	N/A	N/A	Water, Water Admin I	Text	Strength of evidence classification assigned to the outbreak report
451	Admin	MonthOnset	N/A	N/A	N/A	Water, Water Admin I	Number	Numeric variable for month of onset.
452	Admin	YearOnset	N/A	N/A	N/A	Water, Water Admin I	Number	4 digit year of outbreak onset, based on date first ill.
453	Admin	PublicationDate	N/A	N/A	N/A	Water, Water Admin I	Text	Surveillance period for the CDC surveillance summary publication that included this report.
454	Admin	CDCWaterCategory	N/A	N/A	N/A	Water, Water Admin I	Text	Categorical variable for water exposure.
455	Admin	ConfirmedIn	N/A	N/A	N/A	Water, Water Admin I	Text	Description of which samples had confirmed coliforms (Clinical Specimens, Water Samples, Both)
456	Admin	AgentCodeBacterial	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Bacterial etiologic agent
457	Admin	AgentCodeFungal	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Fungal etiologic agent
458	Admin	AgentCodeViral	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Viral etiologic agent
459	Admin	AgentCodeChemical	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Chemical etiologic agent
460	Admin	AgentCodeParasitic	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Parasitic etiologic agent
461	Admin	AgentCodeOther	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates other etiologic agent not listed by available categories.
462	Admin	AgentCodeUnknown	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates etiologic agent is unknown
463	Admin	IllnessAGI	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates AGI as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
464	Admin	IllnessARI	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates ARI as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
465	Admin	IllnessSkin	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Skin as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
466	Admin	IllnessEye	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Eye as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
467	Admin	IllnessEar	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Ear as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
468	Admin	IllnesHep	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Hep as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
469	Admin	IllnessLD	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates LD as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
470	Admin	IllnessLepto	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Lepto as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
471	Admin	IllnessNeuro	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Neuro as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
472	Admin	IllnessPF	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates PF as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
473	Admin	IllnessWound	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates LD as predominant illness according to surveillance system definitions. (e.g. SKIN='Skin infection, burn, or other condition', AGI='Acute Gastrointestinal Illness', NEURO='Neurologic Symptoms/Conditions', EYE='Keratitis, Infection, Irritation', ARI='Acute Respiratory Illness, HEP='Hepatitis', EAR='Ear Infection, Irritation', LD='Legionnaires Disease', PF='Pontiac Fever')
474	Admin	IllnessLeg	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates Leg (Legionella) as predominant illness according to surveillance system definitions.
475	Admin	IllnessOther	N/A	N/A	N/A	Water, Water Admin I	True/False, 1/0, or -1/0	Indicates an additional predominant illness, not listed by provided categories according to surveillance system definitions.
476	Admin	Deficiency1	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data: 1='Untreated surface water'
477	Admin	Deficiency2	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 2='Untreated ground water'
478	Admin	Deficiency3	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 3='Treatment deficiency (e.g., temporary interruption of disinfection, chronically inadequate disinfection, or inadequate or no filtration)'
479	Admin	Deficiency4	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 4='Distribution system deficiency, including storage (e.g., cross-connection, backflow, contamination of water mains during construction or repair)'
480	Admin	Deficiency5A	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 5a='Legionella spp. in drinking water system'
481	Admin	Deficiency5B	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 5b='Legionella spp. in other non-recreational water system'
482	Admin	Deficiency5C	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 5c='Legionella spp. in unknown water use'
483	Admin	Deficiency6	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 6='Plumbing system deficiency after the water meter or property line (e.g., cross-connection, backflow, or corrosion products)'
484	Admin	Deficiency7	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 7='Deficiency in building/home-specific water treatment after the water meter or property line'
485	Admin	Deficiency8	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 8='Deficiency or contamination of equipment using or distributing water (e.g., drink-mix machines)'
486	Admin	Deficiency9	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 9='Contamination or treatment deficiency during commercial bottling'
487	Admin	Deficiency10A	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 10a='Contamination during shipping, hauling, or storage: Drinking-tap water '
488	Admin	Deficiency10B	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 10b='Contamination during shipping, hauling, or storage: Drinking-commercially-bottled water'
489	Admin	Deficiency11A	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 11a='Contamination at point of use: Tap'
490	Admin	Deficiency11B	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 11b='Contamination at point of use: Hose'
491	Admin	Deficiency11C	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 11c='Contamination at point of use: Commercially-bottled water'
492	Admin	Deficiency11D	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 11d='Contamination at point of use: Container, bottle, or pitcher'
493	Admin	Deficiency11E	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data.11e='Contamination at point of use: Unknown'
494	Admin	Deficiency12	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 12='Drinking or contact with other non-recreational water'
495	Admin	Deficiency13A	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 13a='Current treatment processes not expected to remove a chemical contaminant (e.g.,pesticide contamination of ground water treated with disinfection only): Surface water'
496	Admin	Deficiency13B	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 13b='Current treatment processes not expected to remove a chemical contaminant (e.g.,pesticide contamination of ground water treated with disinfection only): Ground water'
497	Admin	Deficiency99A	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 99a='Unknown/Insufficient information: Drinking water-tap water'
498	Admin	Deficiency99B	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 99b='Unknown/Insufficient information: Drinking water- commercially-bottled water'
499	Admin	Deficiency99C	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 99c='Unknown/Insufficient information: Other non-recreational water'
500	Admin	Deficiency99D	N/A	N/A	N/A	Water, Water Admin II	True/False, 1/0, or -1/0	Deficiency classification(s) assigned to an outbreak based on a formal review of the outbreak report data. 99d='Unknown/Insufficient information: Unknown water use'
501	Admin	OutbreakSummary	N/A	N/A	N/A	Water,Water Admin II	Text	Summary description of the outbreak
502	Admin	Coliform	N/A	N/A	N/A	Water,Water Admin II	True/False, 1/0, or -1/0	Presence/Absence of coliforms. 0="False", 1="True" Format depends on export and import program
503	Admin	ColiformCode	N/A	N/A	N/A	Water,Water Admin II	Text	Description of when coliforms were found in relation to the outbreak, if applicable ('Before Outbreak', 'During Outbreak', 'After Outbreak')
504	Admin	DisinfectionCode	N/A	N/A	N/A	Water,Water Admin II	Text	Description of disinfection time in relation to outbreak, if applicable ('Before Outbreak', 'During Outbreak', 'After Outbreak')
505	Efors	CDCID	G1	Page 1, CDC Use Only	N/A	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
506	Efors	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
507	Efors	AgeLessThan1	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Approximate percentage of cases in each age group among the total number of primary cases for whom information is available
508	Efors	Age1to4	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Approximate percentage of cases in each age group among the total number of primary cases for whom information is available
509	Efors	Age5to19	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Approximate percentage of cases in each age group among the total number of primary cases for whom information is available
510	Efors	Age20to49	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Approximate percentage of cases in each age group among the total number of primary cases for whom information is available
511	Efors	AgeGreaterThanEqual50	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Approximate percentage of cases in each age group among the total number of primary cases for whom information is available
512	Efors	AgeUnknown	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Approximate percentage of cases in each age group among the total number of primary cases for whom information is available
513	Efors	IllExposed	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Number of persons who were exposed and became ill
514	Efors	Total	N/A	N/A	N/A	eFORS, Additional eFORS Data	Number	Total number of persons exposed to the implicated vehicle. The attack rate is applied to persons in a cohort who were exposed to the implicated vehicle. If the vehicle is unknown, then the attack rate should not be calculated.
515	Efors	ContributingFactorName1 ContributingFactorName2 ContributingFactorName3 ContributingFactorName4 ContributingFactorName5 ContributingFactorName6 ContributingFactorName7 ContributingFactorName8 ContributingFactorName9 ContributingFactorName10	N/A	N/A	N/A	eFORS, Additional eFORS Data	Text	Name of contributing factor
516	Efors	ContributingFactorType1 ContributingFactorType2 ContributingFactorType3 ContributingFactorType4 ContributingFactorType5 ContributingFactorType6 ContributingFactorType7 ContributingFactorType8 ContributingFactorType9 ContributingFactorType10	N/A	N/A	N/A	eFORS, Additional eFORS Data	Text	Type of contributing factor
517	Efors	FoodImplicatedID1 FoodImplicatedID2 FoodImplicatedID3	N/A	N/A	N/A	N/A	Number	NORS value for internal data management processes. Identifies the individual implicated food during the outbreak; each outbreak may have multiple implicated foods. Variable is a primary key.
518	Efors	MethodOfPreparationName1_1 MethodOfPreparationName2_1 MethodOfPreparationName3_1 MethodOfPreparationName1_2 MethodOfPreparationName2_2 MethodOfPreparationName3_2 MethodOfPreparationName1_3 MethodOfPreparationName2_3 MethodOfPreparationName3_3	N/A	N/A	N/A	eFORS, Additional eFORS Data	Text	For the implicated food, indicates method of preparation.
519	Finalization_Issues	CDCID	G1	Page 1, CDC Use Only	52.12 and 52.13	N/A	Number	The CDCID is an autogenerated unique ID that represents a single NORS report. Links record from a single NORS report across all tables of the flattened database.
520	Finalization_Issues	StateID	G2	Page 1	52.12 and 52.13	N/A	Text	The report ID entered by the reporting site. The StateID is unique to each report created by a NORS reporting agency.
521	Finalization_Issues	DateFirstIll	G6	Page 1, Dates	52.12 and 52.13	General, Investigation Methods & Dates	MM/DD/YYYY	Earliest date of reported illness onset
522	Finalization_Issues	PrimaryMode	G3	Page 1, Primary mode of transmission	52.12 and 52.13	N/A	Text	Primary mode of transmission
523	Finalization_Issues	RecordStatus	N/A	N/A	52.12 and 52.13	N/A	Text	Indicates whether the report is active, finalized, or deleted
524	Finalization_Issues	ReportingSite	G94	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Reporting site of the report author
525	Finalization_Issues	AgencyName	G95	Page 2, Reporting Agency	52.12 and 52.13	General, Agency & Remarks	Text	Name of the NORS agency reporting the outbreak
526	Finalization_Issues	NORSUserID	N/A	N/A	52.12 and 52.13	N/A	Text	User ID of person who created the report
527	Finalization_Issues	IssueStatus	N/A	N/A	N/A	Finalize	Text	Indicates whether the finalization issue for the report is open or closed
528	Finalization_Issues	IssueName	N/A	N/A	N/A	Finalize	Text	Name of the finalization issue flagged for the report
529	Finalization_Issues	IssueResponse	N/A	N/A	N/A	Finalize	Text	Response to finalization issue, if addressed (e.g., "Verified" for a checkbox, or free text for explanations)
530	Finalization_Issues	IssueDescription	N/A	N/A	N/A	Finalize	Text	Description of the finalization issue flagged for the report