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

Query Builder for New Jersey Emergency Department Visit Data - Crude Rates for the State

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 a coding scheme to use for age groups. Default is 11 pre-defined age groups, all ages.

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

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.