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?
What Makes the NJSHAD Query Special?
How to Cite Query Results
How To Build a Query
For more information about these features and step-by-step examples see the NJSHAD Query System Tutorial.
See the Query Help page or the Query Tips page for more query system information.
Exporting/Downloading Query Result Tables
Exporting/Copying Query Result Graphs
Datasets Currently Included (and Year Each Was Added)
Datasets Being Considered for Inclusion in the System
Help!
Data Uses
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.
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).
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.
NJSHAD also contains health status indicator reports with pre-tabulated data, graphs, and contextual information.
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.
- Select a dataset from the menu buttons on the left.
- Select a measure. Click one of the links on the dataset's Outcome Measure Selection page (e.g., counts or rates).
- 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.
- Submit query. After you have built your query, click the "Submit" button below the last step to run your query.
- 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 Tutorial.
See the Query Help page or the Query Tips page for more query system information.
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.
Instructions for putting query result graphs into other software packages (e.g., PowerPoint or Excel)
are given on the Copying NJSHAD Graphs page.
- Birth (2008)
- Death (2009)
- Fetal Death (2010)
- Infant Death (2010)
- Inpatient Hospital Discharge (2015)
- Behavioral Risk Factor Survey (2015)
- Emergency Department Visit (2016)
- Communicable Disease Incidence (2017)
- Pregnancy Risk Assessment Monitoring System (2017)
- School Immunization Status (2017)
- STD Incidence (2018)
- Life Expectancy (2019)
- HIV Cases and Deaths (2021)
- Fatal and Non-Fatal Injury
- Perinatal Death
- Years of Potential Life Lost
Use the Query Help button in the left navigation menu
for definitions, information, instructions, and examples.
Help icons like these 
throughout the query modules also provide information necessary to make specific query-related selections.
throughout the query modules also provide information necessary to make specific query-related selections.
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.
