Ad Hoc Queries for Training- March 2018

Making basic analyzer choices

  1. In 2017, how many clients served in SUD treatment had graduated from High School?
  2. In the most current 4 months for which we have data, which month saw the greatest number of admissions to SUD treatment?
  3. From July 2016 through June 2017, how many MH Requests for service resulted in an intake service having been received?

Cross-tabulating Variables

  1. In 2017, how many non-whites males were admitted to Detox?
  2. In 2017, which BHO had the most MH requests for service for women?
  3. Between July 2016 through June 2017, in the Greater Columbia BHO, how many female clients that were served in treatment had any heroin use? Did more men or women use heroin in that BHO?

Adding statistical options to your query

  1. In 2017, what percentage of total clients that were served in Detox were served by the North Sound BHO?
  2. For patients discharged from MH Inpatient facilities in 2017, do a higher percentage of males or females report that they are current smokers?
  3. For those admitted to treatment in the first six months of 2017, what is the average age of 1st use for females whose primary drug is heroin? How does that compare to females whose primary drug is methamphetamine? (Note: use the summary format on the Substance Used (primary) variable).

Filtering and Multiple Tables

  1. Among women, which BHO had the highest percentage of any opioid use, among those served in that BHO in SUD treatment in 2017?
  2. For men served in SUD treatment in King County in 2016, which primary drug was most common? What percentage of men used the most common primary drug?
  3. In the most current 6 months, how many white men requested a MH service, by BHO? How many non-white women did the same? (answer this query using the multiple table feature)

Charting Options

  1. In 2017, which BHO had the highest percentage of youth admissions across all BHOs? Which BHO had the lowest percentage of adult admissions among all BHOs?