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

Query Builder for New Mexico's Behavioral Risk Factor Surveillance System (BRFSS) Data - Endoscopy (Ever, Adults age 50+)

Query Builder Page Options

  • Question

    Sigmoidoscopy and colonoscopy are exams in which a tube is inserted in the rectum to view the colon for signs of cancer or other health problems. Have you ever had either of these exams? (BRFSS query includes persons age 50+, in even-numbered years only.)

    Select the percentage to calculate.

Jump to Submit

  • Select the year or years you want to include.

Jump to Submit

  • Default is all survey respondents. Use the selection map (above) if you'd like to select geographic areas by clicking on them.

Jump to Submit

  • Age Groups

    To filter the dataset to an age group, select the group or groups from the drop-down box. For statewide analyses, leave specific age groups unchecked.

    To group your results by age group, choose a coding scheme here, and then select "Age group" in the last step, "How to display the data."

    Select an age group to filter the data or to use in the last step, "How to display the data."

  • How to Specify Age Groups

    Enter whole numbers from 18 to 99.

    Use a hyphen to indicate a range of ages (e.g., "5-8" will includes ages 5, 6, 7, and 8).

    You may use greater than (>) and less than (<) symbols. An entry of (<65) includes all adults under age 65 years.

    You may also use a plus sign (+) to indicate all ages equal to or greater than (e.g.,"85+" yields all those aged 85 and over).








Jump to Submit

  • Would you like to include only males or only females in the results? Default includes all data records.

Jump to Submit

  • Demographic Characteristics

    For statewide analyses, leave boxes unchecked.

    To group your results by these variables, select them in the last step, "How to display the data."

    Select below to filter to a specific group. To display by a specific group, use the "Display By" step, below.

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 NM-IBIS Query System are intended to support any individuals or entities engaged in activities designed solely to enhance the well-being of a specific community, which may include State of New Mexico. Allowed activities include informing evidence-based decision making in New Mexico to plan and improve health service delivery, evaluate health care interventions and systems, and inform health policy decisions. Other uses are not permissible.

As an NM-IBIS 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 NM-IBIS query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. Avoid linkage of NM-IBIS query system data with other data that, after linkage, might allow identification of an individual represented in the NM-IBIS query system data.
  5. Use appropriate safeguards to prevent the identification of any individual(s) represented in the data, including when disclosing NM-IBIS 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 Epidemiology and Response Division, New Mexico Department of Health, (505) 827-0006.

Behavioral Risk Factor Surveillance System, Epidemiology and Response Division, New Mexico Department of Health, Injury and Behavioral Epidemiology Bureau, Santa Fe, NM, 87502. Telephone: (505) 476-3595.