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

Query Builder for New Jersey Hospital Inpatient Discharge Data - Crude Rates for Counties

Query Builder Page Options

  • Selecting years

    Use Ctrl to make multiple selections or drag the mouse to select consecutive years.

    Select year(s). Default is most recent year.

Jump to Submit

  • Choose age groups below.

Jump to Submit

  • Choose a coding scheme to use for race and ethnicity. Default is race/ethnicity combined, all races/ethnicities.

  • Race

    Race groups include both Hispanics and non-Hispanics.

  • Ethnicity

    Ethnicity groups include persons of any race.

Jump to Submit

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

Jump to Submit

  • Select the diagnoses to include in your query. Default is all diagnoses.

  • Hospital Discharges for Select Health Indicators

    In this section, data can be queried based on primary and/or secondary diagnoses. For each, the default is all diagnoses, so you must actively select Primary Diagnosis, Secondary Diagnosis, or a combination of the choices to produce the correct results.

  • Primary Diagnosis

    Each hospitalization record may contain up to 13 diagnoses. Primary diagnosis refers to the first-listed (main) diagnosis.

    How to Specify ICD-10-CM Codes

    Enter the codes, 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, discharges 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.

    Injury codes included are Nature of Injury codes (S00-T98), not Cause of Injury codes (V01-Y98).






  • Any Diagnosis

    Each hospitalization record may contain up to 13 diagnoses. Any diagnosis refers to any of the diagnoses in the record. For data based only on the main/first diagnosis, choose "User-defined ICD-9/10-CM diagnosis codes - primary diagnosis" above.

    How to Specify ICD-10-CM Codes

    Enter the codes, 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, discharges 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.

    Injury codes included are Nature of Injury codes (S00-T98), not Cause of Injury codes (V01-Y98).






Jump to Submit

  • Choose county of residence. The default is all counties.

Jump to Submit

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.

Optional Map Visualization

Defines the optional map graphic to display.

NOTE: Maps are only available when the category is set to a geographical area and does not have a series defined.

The data and information provided through the NJSHAD Query System are intended to support individuals or entities engaged in activities designed solely to enhance the well-being of a specific community. Allowed activities include informing evidence-based decision making and planning, improving 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 identification of any 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.