How to Construct a Query in the WISH System - A Step-by-Step Example Using the Cancer Incidence Module

Within each module of the WISH system, you begin a query by selecting a measure. This selection creates a central data construct from which additional query options are possible (cancer site, region of residence, and demographic characteristics). In the Cancer Incidence Module you can focus on any of three measures:

  • Number of cancer cases
  • Cancer incidence crude rate
  • Cancer incidence age-adjusted rate

Next you can select a specific cancer site and further specify query criteria if desired. Submitting a request at this point creates output for Wisconsin statewide for the most recent year of stored data, giving you a quick, broad view of the data measure you requested. Alternatively, go to the next section of the query page to select a specific region or county or to choose years or demographic characteristics.

Any time you submit a request, you will first see a pop-up screen that shows what your query will include. The example below is for Lung and Bronchus cancer.

WISH Query Confirmation

You are querying:
Data Set: WISH -- Cancer Module
Measure: Age-adjusted Cancer Incidence Rate (per 100,000 pop.)
Cancer Site: Lung and Bronchus
Geographic Area: Region of Residence
Years: 5 or 10 year Group
Row Variable: Region of Residence
Column Variable:  
Sex: All
Race: All
Ethnicity: All
Years: 2007-2011

Click OK to obtain the desired output, or choose CANCEL to return to the selection criteria. When the output table is displayed, you may print it using your browser print features. Here is an example output table for Lung and Bronchus cancer:

Query: Wisconsin Cancer Incidence (Wisconsin 1995 - 2011)
  • ( (Sites = Lung and Bronchus) )
  • and ( (2007 <= Year <= 2011) )

Age-Adjusted Cancer Incidence Rate (incidence per 100,000 population)
(age-adjusted to the 2000 U.S. standard population)

Region of Residence Detail Information
  Cancer Incidence Population Cancer Incidence Rate 95% Confidence Interval
Southern 3516 5456877 59.9 58.0 - 62.0
Southeastern 7231 10467263 66.1 64.5 - 67.6
Northeastern 4343 6105005 61.1 59.3 - 63.0
Western 2486 3858405 56.5 54.3 - 58.8
Northern 2003 2436911 62.0 59.3 - 64.8


Note: Cell Suppression and Cells with Counts of Zero: An "X" indicates that one or more values within a row or column is less than 6 (but more than zero) and has been suppressed to protect confidentiality. To obscure the value of the suppressed cell, some values greater than 5 and corresponding rate or percent values may also be displayed as an "X." A period (.) indicates there are zero cases in that cell. If all values in a row or column are zero, that row or column is not displayed.

To save these results or copy them into a word processing or spreadsheet program:
     Using your mouse, select (highlight) the output you want to save.
     Include all titles and query parameters in your selection.
     Using your browser, select EDIT, COPY.
     PASTE the output into your word processing or spreadsheet program.

Start a new query within the same module by clicking NEXT QUERY. Other options shown on an output table include DATA SOURCE, INTERPRETATION, and HELP. These provide additional information and explanations for reading output from your query. At the end of each option is a BACK function to return you to the current output table.


Last Revised: February 10, 2016