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

Query Builder for New Jersey Sexually Transmitted Disease Data - Count

Query Builder Page Options

  • Selecting diseases

    Use Ctrl to make multiple selections or drag the mouse to select diseases listed consecutively.

    Choose diseases of interest. Default is all reported STDs.

Jump to Submit

  • 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 race, ethnicity, or race and ethnicity combined. Default selection is race/ethnicity combined for all races/ethnicities. Note that race and ethnicity are missing on more than a quarter of STD reports. INTERPRET WITH CAUTION.

  • Race

    Race groups include both Hispanics and non-Hispanics.

  • Ethnicity

    Ethnicity groups include persons of any race.

Jump to Submit

  • Choose other characteristics to include in your analysis. The default is all persons.

  • Selecting age groups

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

Jump to Submit

  • Choose the geographic areas to include in your analysis. The default is all New Jersey residents.

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.
Sexually Transmitted Disease Program, Division of HIV, STD and TB Services; New Jersey Department of Health; PO Box 363; Trenton, NJ 08625-0369 (https://nj.gov/health/hivstdtb/stds/)