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

About the Custom Query System

The NJSHAD Query System provides a simple-to-use interface that allows users to step through data selection options and perform custom queries of New Jersey's public health databases.
What Is a Custom Data Query?
Short answer: It's a way for you to make your own tables and graphs of our data.

A custom data query is an interface (set of pages) where the user can select a dataset (e.g., birth) and a measure (e.g, count) and then filter the results to a year, age group, county, etc. to obtain specific data.
  • Available datasets are listed on the right as well as on the left navigation buttons.
  • Measures can include rates, counts, survey topics, top 10 lists, averages, etc.
  • The filter selections depend on the dataset. For example, mortality data can be filtered by year, cause of death, age, sex, and geography (county, municipality).

What Makes the NJSHAD Query Special?
There are thousands of possible combinations of variables and values that users can choose through the NJSHAD query builder screens. To achieve this degree of flexibility, pre-tabulated data and rates can not be used. Instead, true micro-level records feed the system which pulls from those datasets based on your variable and value selections.

NJSHAD also contains health status indicator reports with pre-tabulated data, graphs, and contextual information.

How to Cite Query Results
Use and reproduction of the information published on this website is encouraged and may be done without permission. Please refer to the NJSHAD Citation page for suggested citation styles.
How To Build a Query
  1. Select a dataset from the menu buttons on the left.
  2. Select a measure. Click one of the links on the dataset's Outcome Measure Selection page (e.g., counts or rates).
  3. Build your query. Follow the numbered steps (blue bars) on the Query Builder page to build your query. Click on a step bar to expand the step. Make selections to build your query. Making no selection on any or all steps will result in default values (usually "all") being used.
  4. Submit query. After you have built your query, click the "Submit" button below the last step to run your query.
  5. View and/or modify your results. From the results page you can select or change a graph, copy and paste to Excel, use the small arrows in the table headers to sort or filter data columns, use the Return to Selection Page button to modify your query selections, or start a new query. For more information about these features and step-by-step examples see the NJSHAD Query System Tutorials page.

See the Query Help page or the Query Tips page for more query system information.

Exporting/Downloading Query Result Tables
Click Output to Excel on the left-side menu of a query result page to save the results in Microsoft Excel format. Note that the file is saved with an .xls extension. When opening the .xls file in newer versions of Excel that use the .xlsx extension, you will see a warning message that the file is in a different format than specified in the extension. Click "yes" to proceed.

Exporting/Copying Query Result Graphs
Instructions for putting query result graphs into other software packages (e.g., PowerPoint or Excel) are given on the Copying NJSHAD Graphs page.

Datasets Being Considered for Inclusion in the System
  • Fatal and Non-Fatal Injury
  • Perinatal Death
  • STDs

Help!
Use the Query Help button in the left navigation menu for definitions, information, instructions, and examples. Help icons like these question bubble icon question link icon throughout the query modules also provide information necessary to make specific query-related selections.


Data Uses
The information provided through the NJSHAD query system is intended to support evidenced-based decision making in New Jersey to plan and improve service delivery, evaluate health care systems, and inform policy decisions. Other uses are not permissible.

Operating Systems and Browsers

NJSHAD was developed for desktop using Windows 7 and Google Chrome. Other operating systems and browsers may not render pages properly. Most notably, pre-Version 9 Internet Explorer will not show pages or run queries properly. Make sure your browser version is up to date. More info...
The information provided above is from the Department of Health's NJSHAD web site (https://nj.gov/health/shad). The information published on this website may be reproduced without permission. Please use the following citation: " Retrieved Mon, 11 December 2017 2:31:44 from Department of Health, New Jersey State Health Assessment Data Web site: https://nj.gov/health/shad ".

Content updated: Wed, 15 Nov 2017 07:52:42 EST