National Outbreak Reporting System

National Outbreak Reporting System (NORS)

Attachment 3_NORS_Flat_DataDictionary May2019.xlsx

National Outbreak Reporting System

OMB: 0920-1304

Document [xlsx]
Download: xlsx | pdf
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
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy