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

Query Builder for New Jersey HIV Data: 2010-2021 - Count of New Diagnoses

Query Builder Page Options

  • Select year grouping and year(s). Default is single years, most recent year.

  • Selecting years

    Year is year of first HIV diagnosis.

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

Jump to Submit

  • Choose demographic characteristics to include in the analysis. The default is all cases.

  • Sex

    Sex designations based on a person's reported sex at birth.

  • Gender

    Refers to a person's internal understanding of their own gender, or gender with which a person identifies.

Jump to Submit

  • Choose additional categories to include in your analysis. The default is all categories.

  • Stage at Diagnosis

    The CDC case definition for HIV, stage 3 (AIDS) met by the patient; calculated based on lab information and opportunistic diseases entered for a person.

Jump to Submit

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

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.