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 Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
File Modified | 0000-00-00 |
File Created | 0000-00-00 |