Skip directly to searchSkip directly to the site navigationSkip directly to the page's main content

NJSHAD Query System Tips

General Tips
  • For step-by-step query system examples see the Query System Tutorial arrow
  • Use age-adjusted rates when you want to compare areas, for example New Jersey and U.S. data.
  • Use the small arrows in the table headers to sort and filter data columns.
  • Be aware of data issues and data notes below the data table on the results page. They give information about the dataset that anyone using the data should know.
  • To import data tables into Excel, use the Output to Excel button or select the output table starting with its title and copy (Ctrl-C) it, then paste (Ctrl-V) into an Excel worksheet.
  • When looking for specifics on how something is measured or information about a topic or measure, check the Indicator List or corresponding Health Topics page.
  • Zero values do not show in table output, so if you get a table that appears to be missing rows, it means that the value for that category is zero.
  • If your table is all or mostly asterisks, that means the number of events is too small to calculate a reliable rate. Filter by fewer variables, group more years together, or broaden the geographic region to get usable data.

User-defined ICD codes
  • Use a hyphen to indicate a range of codes, 'C00-C97'.
  • Use a space or a comma between codes, 'I10, I12' or 'I10 I12'.
  • When entering more than one code in a box, such as 'I10, I12,' the results will display all the records that have I10 or I12, combined.
  • Codes can be entered in separate boxes to be displayed by each separate code.
Query System Tutorial
Illustrated step-by-step instructions for building a query in NJSHAD.

Acrobat icon Query Tutorial - PDF

  • Lists of ICD codes are available on the Help page.
  • Causes of death are listed alphabetically using NCHS terminology.
    For example, Cancer is listed as Malignant Neoplasms, Heart Disease as Diseases of Heart, Homicide as Assault, and so forth.

Hospital and ED
  • Enter ICD-9 E-codes with the E, for example E888 should be entered as 'E888'.

If you have a tip you would like to share please contact us!
The information provided above is from the Department of Health's NJSHAD web site ( The information published on this website may be reproduced without permission. Please use the following citation: " Retrieved Sun, 18 March 2018 22:58:18 from Department of Health, New Jersey State Health Assessment Data Web site: ".

Content updated: Wed, 28 Feb 2018 05:01:08 EST