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

Query Builder for New Jersey HIV Data as of 2021 - Count of Persons Living with HIV

Query Builder Page Options

  • 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.