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

Query Builder for NJ Provisional Death Data Query - 2021 Age-adjusted Rates (Deaths Per 100,000 Standard Population) for the State

About this dataset

THE DATA IN THIS QUERY MODULE ARE NOT FINALIZED. They come from the New Jersey Death Certificate database which consists of in-state deaths submitted to the New Jersey Department of Health, Office of Vital Statistics and Registry via the Electronic Death Reporting System (EDRS) and out-of-state deaths submitted to the New Jersey Department of Health via the State and Territorial Exchange of Vital Events (STEVE). All data shown are for New Jersey residents regardless of where the death occurred.

How to build your query

Follow the numbered steps below to narrow your query. When you are done filtering your query, open the last STEP bar to select which rows and columns you want in your data table. After that, click SUBMIT at the bottom left of the query builder steps to get your query result.

  • Choose race, ethnicity, or race and ethnicity combined. Click the yellow ? for more information.

  • Race

    Race groups include both Hispanics and non-Hispanics.

  • Ethnicity

    Ethnicity groups include persons of any race.

  • Choose which sex to include in your analysis. The default is all persons.

  • Underlying Cause of Death

    All causes of death in this NJSHAD module are underlying causes of death. There are a variety of predefined causes of death to choose from. If causes on the predefined lists do not meet your needs, you may enter your own ICD-10 codes by selecting "User-defined causes."
    Choose a grouping scheme below. Default is all causes of death. Hover over blue ? bubbles or click on yellow ? for more information.

  • COVID-19, Pneumonia, Influenza, and Other Causes

    ICD-10 codes are given in parentheses. More info

  • Leading Causes of Death

    ICD-10 codes are given in parentheses. More info

  • How to Specify ICD-10 Codes

    Enter the codes with or without the decimal point. Use a hyphen to indicate a range of codes. Use a space or comma between codes.

    Note that, for example, P23 includes all codes under P23 (congenital pneumonia), from P23.0 (Congenital pneumonia due to viral agent) to P23.9 (Congenital pneumonia, unspecified). Because the codes are alpha-numeric and not simply numeric, deaths coded simply P23_ [underscore added to show blank space] will not be included in a range from P23.0-P23.9 since P23_ is less than P23.0. P23-P24 would include all codes under P23 and P24.











Primary group by field

Defines the data's primary grouping dimension. The primary grouping is required and also controls the ordering of the result's data rows. In MS-Excel and other graphing packages this is typically referred to as the the "dataset's category". If viewing in a 2-d table layout then this value/dimension is associated with table's "row" values. Others will refer to this value as the first "cross by" or the first dimension.

Optional secondary group by field

Defines the 2nd field (or dimension) to be used to group and aggregate values by. MS-Excel chart users will commonly refer to this as the dataset's "series" field. If viewing in a 2-d table layout then this field is associated with data table's value columns. Series group bys are optional. Maps and some charts, like the "Pie" chart, are currently not programmed to handle datasets that have more than one group by e.g. they only work with the primary category type group by being specified.

Optional chart graph

Defines the optional chart graphic to display.

NOTE: Maps and some charts, like the "Pie" chart, are currently not programmed to handle datasets that have more than one group by e.g. they only work with the primary category type group by being specified. All other charts will only work with a maximum of 2 group bys e.g. if the fixed group by exists then the series group by can NOT be used with charting or maps.
The data and information provided through the NJSHAD Query System are intended to support any individuals or entities engaged in activities designed solely to enhance the well-being of a specific community, which may include the State. Activities include informing evidence-based decision making in the State to plan and improve health service delivery, evaluate health care interventions and systems, and inform health policy decisions. Other uses are not permissible.

As an NJSHAD Query System user, I AGREE TO:
  1. Use the data for statistical reporting and analysis only.
  2. Avoid any attempt to identify or contact individual(s) represented in the NJSHAD query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. Avoid linkage of NJSHAD query system data with other data that, after linkage, might allow identification of an individual represented in the NJSHAD query system data.
  5. Use appropriate safeguards to prevent the inappropriate use or disclosure of individual(s) represented in the data, including when disclosing NJSHAD Query System data to others.
  6. Report IMMEDIATELY any inadvertent or intentional identity disclosures or violations of this agreement of which I become aware to the Center for Health Statistics, NJ Department of Health.

I understand that any violation of the above conditions may result in prosecution under all relevant state and federal laws. If I am a state government employee, this may be grounds for immediate dismissal.
Center for Health Statistics, New Jersey Department of Health, PO Box 360, Trenton, NJ 08625-0360, Web: www.nj.gov/health/chs, e-mail: chs@doh.nj.gov
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 Fri, 09 June 2023 13:46:55 from Department of Health, New Jersey State Health Assessment Data Web site: https://nj.gov/health/shad ".

Content updated: Wed, 31 Dec 1969 19:00:01 EST