U.S. Fish & Wildlife Service
National Wild Fish Health Survey Database
NWFHS CSV File Metadata
  • Description:
  • A comma-separated values (CSV) file is a delimited text file that uses commas to separate values. CSV is commonly used to store tabular data. This makes it a good format for use in spreadsheet and database applications.
  • Attribute Descriptions:
    • Search Options: The search criteria used to generate the data file is included. Only the fields included in the search criteria are listed in data file.
    • Start: All data collected on or after this date is included.
    • End: All data collected on or before this date is included.
    • Pathogen: The pathogen searched for.
    • Species: The family,genus, or species searched for.
    • Waterbody: Waterbody or geographic feature name associated with sample site.
    • State: State containing the sample site.
    • Partner Agency: Agency associated with sample site.
    • Map Bounds: The map bounding box coordinates used to filter the sample sites.
    • Column Descriptions: The following columns are included in the CSV data file.
    • id: Unique record identifier (NOT immutable)
    • lab: USFWS Fish Health Center responsible for managing the case.
    • casenumber: Unique identifier assigned to each case by managing Fish Health Center
    • agency: Primary Organization collaborating on case, usually assisting with sample collection
    • agency2: Primary Organization collaborating on case, usually assisting with sample collection
    • collectiondate: Date of sample collection
    • datereceived: Date samples were received by the Fish Health Center
    • datecompleted: Date case was completed
    • waterbody: Name of the geographic feature sampled as designated by the U.S. Board on Geographic Names
    • sitename: Sample site identifier(name) assigned at the time of sample collection
    • sitedescription: Supplemental description of the sample site
    • gnisid: Permanent, unique feature record identifier assigned to the sampled geographic feature by the U.S. Board on Geographic Names
    • latitude: The latitude of the sample site
    • longitude: The longitude of the sample site
    • datum: The geodetic reference system used to determine the latitude and longitude of the sample site
    • watertemp: Sample site water temperature in degrees Celsius at the time of collection
    • elevation: The elevation of the sample site in meters
    • statename: Name of the state where sample site is located
    • county: Name of the county in which sample site is located
    • huc: 8-digit hydrologic unit code (HUC) of the watershed that contains the sample site location
    • hucname: Name associated with the 8-digit hydrologic unit code (HUC)
    • commonname: The common name of the sampled species
    • species: The full scientific name of the sampled species
    • speciescode: The three-letter code representing the sampled species. The code is assigned and maintained by the USFWS National Fish Health Database Coordinator.
    • itistsn: Taxonomic Serial Number, the unique identifier assigned to the sampled species in the Integrated Taxonomic Information System (ITIS)
    • numbercollected: The number of individual animals collected of the species
    • collectionmethod: The collection method used to obtain species samples
    • specimen: The tissue, or combination of tissues, collected from the sample
    • numbertested: The total number of individual samples (animals) from which the associated specimen was taken for the indicated assay(s)
    • pathogentested: The pathogen for which the specimen was analyzed
    • prelimassay: This is the first method that is applied to specimens to be tested. The current list of preliminary methods is available in the NWFHS Laboratory Procedures Manual.
    • prelimpoolstested: Number of pools analyzed using the preliminary assay
    • prelimpoolsdetected: Number of pools in which the pathogen was detected using the preliminary assay
    • corrobassay: This is the second method that might be used to test a specimen when the preliminary procedure indicates the possible presence of a pathogen. The current list of corroborative methods is available in the NWFHS Laboratory Procedures Manual.
    • corrobpoolstested: Number of pools analyzed using the corroborative assay
    • corrobpoolsdetected: Number of pools in which the pathogen was detected using the corroborative assay
    • pathogendetected: The pathogen that was detected in the specimen by the preliminary assay and confirmed by the corroborative assay.