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

Query Builder for New Jersey PRAMS Data - Pre-Pregnancy Diabetes

Query Builder Page Options

  • Select the percentage to calculate.

Jump to Submit

  • Selecting years

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

    Select year or years.

Jump to Submit

  • Making selections

    To include all respondents, leave boxes unchecked.

    Choose characteristics to include in your analysis. The default is all survey respondents.

  • Parity

    Analytic changes occurred for PRAMS Phases 6 (2009-2011), 8 (2016-2022), and 9 (2023 - Current) that could not be replicated for the previous phases. Please keep this in mind when making comparisons by year.

  • BMI

    Analytic changes occurred for PRAMS Phases 8 and 9 (2016 - Current) that could not be replicated for the previous phases. Please keep this in mind when making comparisons by year.

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.

Maternal and Child Health Epidemiology, Division of Family Health Services, New Jersey Department of Health, PO Box 360, Trenton, NJ 08625-0360, e-mail: https://www.nj.gov/health/fhs/maternalchild/contact.shtml (https://www.nj.gov/health/fhs/maternalchild/mchepi/)