For nearly twenty years, Looking Glass Analytics, Inc., has provided research, analytic, and technical support to a variety of local, state, and federal criminal justice partners. Clients include local police and sheriff’s departments, city and county jails, state corrections departments, local and federal prosecutors, public defenders, district courts, liquor control agencies, and national criminal justice research agencies. Further detail on some of this work can be found by clicking on the tabs below:
For nearly two decades, Looking Glass Analytics has provided a range of analytic products and consulting services that help city, county, and regional jails bridge the gap between their need for information and their ability to produce it efficiently. We add value to the volumes of administrative data jails collect to improve jail management, inform policy decisions, accomplish complex billing and accounting, comply with state and federal reporting requirements (e.g. SCAAP, Census counts, etc.), forecast future inmate populations, and meet a myriad of other needs. The types of services we provide include:
Jail4cast.com provides an easy-to-use, yet comprehensive
tool for creating monthly jail inmate population forecasts for Jail Admissions, Average Daily Population (ADP),
and Average Length of Stay (ALOS). Combining statistical trends from previous time periods with input from
local experts, users create forecasts for a number of unique jail sub-populations. This way, local
knowledge of future or past policy impacts can be used to modify a purely statistical result when
appropriate. Forecast results for each of these sub-populations can be evaluated, reviewed, and
updated independently anytime and flexibly rolled up into larger aggregate totals. Sub-populations
can represent one or more demographic and/or status groups such as sex, age, charge type
(e.g. misdemeanant/felon), sentence status (pretrial, sentenced), classification, custody
(secure, other), etc. Regular data updates of actual admissions, ADP, and ALOS numbers are tracked against
the forecasts. Find out more at Jail4cast.com.
Steps to create a forcast:
Steps to track new data against an existing forecast:
Acquisition of data extracts of booking, charge, classification, housing, billing, phone, and/or other jail management data on a daily, weekly, or monthly basis allow us to provide highly customized sets of management reports delivered electronically (e-mail, web site updates, etc.) to any number of constituents or stakeholders.
In addition to our jail4cast.com product, we host interactive analytic tools that allow jail staff or other stakeholders to conduct ad hoc analyses or generate pre-formatted reports updated with the latest data. Our use of the “Cloud” allows us to offer these tools via the Internet as “zero-footprint” computing services, removing nearly all the burden from the IT staff of providing analytic programming and infrastructure support. IT folks often have their hands full already maintaining the jail management and other systems.
The MCCC needed more information in finer detail about their court operations and case processing. An automated tool acting on raw data provided acquired from the State’s data system would provide consistent and easily accessible court performance metrics. In response, LGAN staff developed a web-based application to provide on demand data queries that supports the MCCC. Analytic topics include cases, charges, case processing time, terminations by trial and trial type. Additional variables are available for analytic drill down including time frame, case type (i.e. criminal, small claims, domestic, probate, etc.), case class (i.e. felony, misd, violation, etc) and others.
Initiated during the GW Bush administration, PSN was a federally funded effort to reduce gun crime through increased prosecution and stricter sentencing. PSN funding flowed locally to support U.S. Attorney jurisdictions across the country to best address local issues related to gun crime. LGAN was selected as PSN Research Partner for the US Attorney Districts of Western Washington and Guam. As research partner, we assisted a multi-agency task force consisting of representatives of law enforcement, prosecution, and corrections by using data to help define the gun crime problem, suggesting possible interventions, and evaluating the outcome of those interventions. LGAN also delivered an analytic tool that acquired, processed, and provided access to statistics related to gun crime in police and sheriff’s jurisdictions across Washington State. Uniform Crime Reporting (UCR) data were acquired from the Washington Sheriffs and Police Chiefs Association to support the web-based tool.
LGAN evaluated the success of three pilot courts across the state that received additional funds and consultation to improve the legal services provided to the indigent. LGAN analyzed court and attorney records to determine the effectiveness of the pilots in three areas: attorney caseload, access to legal representation and the quality of public defense services.
LGAN provided data processing and analytic support to a broader effort to assess the delivery of Superior Court services to children and families in King County. Results from this work included numerous iterations of case mix and case processing measures and geographic mapping and travel time analysis of court case participants.
Looking Glass Analytics provides analytic and program support to Federal, State, and Local public health agencies with a variety of products and services, examples of which include:
Tuberculosis disease (TB) is an immediate global emergency. Worldwide, 10 million people develop active TB and 1.6 million die every year.
1 million children get sick annually and 1 in 4 die. TB kills more people than any other infectious agent on the planet and is particularly
harmful of people living with HIV/AIDS, killing 1 in 4 of those who die. Approximately 4 of the 10 million annual cases go undetected or unreported.
Drug-resistant TB is on the rise as well. Amazingly, TB is treatable and often preventable and most cases can be cured for $30 US.
TBwarrior.com is a global health education, communication, and marketing enterprise supporting the global effort to eradicate TB.
The goal is to raise conscious awareness and de-stigmatize TB disease among patients and care providers to increase care seeking and care delivery,
ultimately saving lives. The online platform will reach millions of TB patients and care providers by delivering creative episodic storytelling
online (e.g., YouTube), amplified by the latest digital marketing and social media strategies.
Find out more at www.TBwarrior.com
In Washington State, the Student Assistance Prevention-Intervention Services Program (SAPISP) was created to address the problems of youth that have been
impacted by substance use/abuse and have experienced barriers to learning. Intervention specialists work in schools throughout the state to provide early
alcohol and other drug prevention and intervention services, to assist in referrals to treatment providers and to strengthen the transition back to school
where appropriate.
Since 2013 LGAN has maintained and enhanced the development of https://www.wasapisp.com/, a data collection and reporting application. The site gives interventionist
specialists a convenient and secure way to enter and retain data on students they serve as well as a series of reports to monitor student progress and
outcomes. LGAN works together on this project with staff at RMC Research and the Washington State Office of the Superintendent of Public Instruction.
Alaska Trauma Registry: A state-level trauma registry acquires injury data from most or all hospitals in a state. These data are highly valuable, supporting injury prevention planning, monitoring, and evaluation, and 2) quality control processes for improving injury care. As they are acquired, these records must be aggregated and processed further for analytic use. The State of Alaska recently contracted with Looking Glass Analytics to help routinize, update, and maintain processes that prepare and deliver trauma registry data, ready for analytic use.
Consistent Care Services: The goal of Consistent Care Services (CCS) is to engage social resources within the community and collaborate on comprehensive care plans that address the
health and social challenges faced by underserved patients. One problem they directly address is the inappropriate use of hospital emergency departments.
In 2015 Consistent Care contracted with LGAN for the analysis and evaluation of emergency department records. On a monthly basis since 2015, LGAN
analyses emergency department usage across the state and provides automating reporting that compares the use of this costly form of health care over time.
LGAN reporting documents the effectiveness of CCS case management services in reducing costly emergency care. https://consistentcare.org
In 2016, the Multnomah County Health Department was awarded a grant by the National Institutes of Health’s National
Institute on Drug Abuse (NIH/NIDA) to evaluate the impact of varying state and local polices on health, social, and
economic outcomes of legalized marijuana in Washington and Oregon. Along with researchers from RAND Corporation,
Oregon Health Authority, and the University of Washington, Looking Glass Analytics provided analytic support to this
project including:
Every community in the country has been affected by the misuse of opioids, but few communities have the information necessary to identify needs, resources and gaps in available services. With funding from the U.S. Department of Justice and the Washington State Department of Health, LGAN staff helped identify local community needs by mapping the locations and densities of adverse consequences of opioid use such as overdoses, hospitalizations, risky prescribing practices, etc.). We also created tools to identify community-level resources, like locations of treatment facilities, medication-assisted access and prescription drug disposal sites.
With an innovation grant from NIH/NIDA and assistance from researchers at the University of Washington, Looking Glass Analytics conducted mapping, analysis, reporting, and surveillance
of alcohol and drug use data in King County, Washington. Leveraging and integrating a variety of data sources, we produced analytic maps and reports of the patterns and trends in these
data over time. Examples of data sources include:
Rationale. Knowing how many people live in a particular area is critical to understanding and responding to outbreaks or
clusters of disease, planning prevention and treatment programs, and allocating public health resources. Population counts of
total population and certain sub-groups that define groups at risk (e.g. young, elderly, men, women, etc.) are necessary to
calculate rates of occurrence, which when compared, can help identify populations and places with that higher or lower impact
for any particular public health event or phenomenon.
It is very helpful to public health practitioners that the U.S. population is counted once every ten years during the national
decennial census. Unfortunately, the population is ever changing, just about everywhere. The smaller the area, the more likely
that population changes can impact public health statistics. For example, a new apartment complex or retirement community could
double the population in a neighborhood and radically change the age composition. Closing a military base could decimate a population
in that area but cause a boom in another. That is why estimating changes in population between censuses (intercensal estimates) are important.
Work for WA OFM. Over the past several years we have assisted the Washington State Office of Financial Management in producing small area population estimates
for intercensal years to improve per capita rate calculations for service use and other epidemiologic research. Estimation processes include trending,
synthetic estimation, and raking, against disparate data sources including decennial census base data plus Washington State annual state, county and city
population estimates and forecasts to produce annual population estimates with detailed demographics at small geographic levels – usually aggregations of
census blocks (i.e. census block groups, school districts, etc.). Demographically, all estimates are broken out into population subgroups defined by the
intersection of Age, Sex, Race, and Hispanic Origin.
With so many competing demands for public health funds and staff time, few resources are left for collection and analysis of case data.
Yet, you cannot manage a public health program, much less a disease outbreak, without quality data.
In partnership with JBS International, Inc., we developed EpiAnywhere™, an online tool where public health agencies and professionals—in
the United States and internationally—can track cases, analyze critical public health trends and program performance, and report case data
automatically to national and international health authorities (i.e., CDC and WHO). Over more than a decade, EpiAnywhere™ provided surveillance
for tuberculosis (TB), sexually transmitted diseases, and Hansen’s disease (leprosy).
Looking Glass Analytics maintains expertise in all phases of survey research including: project administration, data collection, sample design, questionnaire development, data analysis, report writing. We also have built an online platform for delivering survey results to the public and/or securely to authenticated users. This platform is customized to the content and reporting needs of each client. An example of this platform can be found at http://www.AskHYS.net.
www.AskHYS.net is an online service designed to access, analyze and disseminate data from the Washington State Healthy Youth Survey (HYS).
Via the web site, access to State and county-level HYS results are public and available to anyone, while school district and building level
results are available only to authenticated users. The system will suppress any data that has the potential to compromise participating students'
anonymity. LGAN designed and deployed the web service in 2007 and continues to host and update the service when new data are acquired or reports
are created.
Results from the biennial survey years 2002 - 2016 are available on the web site in the following formats:
LGAN was awarded contracts to administer the 2012, 2014 and 2016 HYS surveys to over 1000 schools across Washington State. This involves school recruitment and registration, shipping and receiving of survey booklets to and
from over 1000 schools, and processing/scanning over 200,000 completed surveys. The scanned results are used to produce analytic reports for particpating schools and school districts, create an analytic data set for
researchers, and serve as the data supporting the AskHYS.net web site.
The Healthy Youth Survey represents a collaborative effort among the Department of Health (DOH), the Office of Superintendent of Public Instruction (OSPI), the Department of Social and Health Services' Division of
Behavioral Health and Recovery (DBHR), the Department of Commerce (Commerce), the Family Policy Council (FPC), the Liquor Control Board (LCB), and contractors, Looking Glass Analytics and Rainier Theory.
To learn more or use the public access component of AskHYS.net, please visit http://www.askhys.net/.
One example of an online tool is the state-of-the-art Geographic Enforcement Management Service (GEMS™). While GEMS™ supports liquor law enforcement, the application can be modified to support other licensing or enforcement domains, such as tobacco, health inspections, medical licensing, etc.
Every community in the country has been affected by the misuse of opioids, but few communities have
the information necessary to identify needs, resources and gaps in available services. LGAN and
partners developed the Mapping Opioid and Other Drug Issues (MOODI) to fill this need for
communities in Washington State.
With funding from the U.S. Department of Justice, MOODI, an online mapping tool, was developed for
the Washington State Department of Health. MOODI lets users identify community needs by mapping
the locations and densities of adverse consequences of opioid use, such as overdoses and
hospitalizations, along with risky prescribing practices. In addition, users can identify community-level
resources, like locations of treatment facilities, and medication-assisted access point and prescription drug
disposal sites.
The maps available in MOODI show results for fixed geographies like counties or zip codes, and for
smaller areas based on the actual locations of events. Grid analyses are also available, with the size of
the grid based on the number of events being counted.
GEMS™ was designed and developed to support state alcohol and beverage control agencies and local law enforcement agencies in their efforts to conduct inspections and investigation of retail liquor businesses. Breaking ground on many fronts, the GEMS™ platform delivered seamless integration of multiple periodic data feeds into one stop data presentations and deployed a number of innovative interactive components during the development of the system including:
We have expertise in several GIS web services API environments and their collection of API modules, most prominently those associated with Bing! Maps web application development. We also maintain a full suite of ESRI Arc/Info-ArcGIS software licenses on site and licenses for other supporting products including MapInfo desktop GIS, SAS, SQL Server, etc.
Looking Glass Analytics, Inc. (LGAN) offers a diverse range of products and services to social and health services agencies. We provide sophisticated on-line management tools and analytic support to behavioral health agencies that oversee, manage, or provide substance abuse or mental health prevention or treatment services.
Analytic Services to Behavioral Health Programs
To run an efficient behavioral health agency or program, publicly-funded or otherwise, managers need timely information on a variety of important performance measures. To be most effective, they need this information for all entities that facilitate or provide care. State policymakers, regional treatment planners and local service providers all benefit from tools that provide that kind of information quickly, easily, and comprehensively.
For more than a decade, our web-based reporting solutions have been helping behavioral health programs to bridge the gap between their need for information and their ability to produce it efficiently. Our products and services allow clients to analyze data on the patients receiving services, the services provided, and their outcomes. Our tools add value to the volumes of administrative data that treatment programs collect by providing the information needed to improve the delivery of services, inform policy decisions, monitor program outcomes, comply with state and federal reporting requirements, and meet a myriad of other needs. The types of services we provide include:
Monitoring Performance Benchmarks: A Brief Case Study:
LGAN developed, maintains and hosts performance monitoring applications for the Washington State Department of Social and Health Services (DSHS), and has done so for the past decade. We take data from several different DSHS databases, process it as necessary and maintain a web portal so that authorized users can access and analyze the data. These services allow for the monitoring of many different measures, but recently DSHS requested a new monitoring report to use when evaluating the performance of both counties and providers. They were interested in monitoring patient retention, and had a complex algorithm for defining that concept involving admission and discharge dates, encounter dates and encounter types. Rather than performing that work in-house, or having the counties or providers doing their own analyses, they asked LGAN to capture this concept in series of reports and make them available to all authorized users. Our roles, in addition to publishing new reports on the web, were to provide research guidance in the formation of the measure and to perform ad hoc analysis to support their measure of choice. These reports are now available to the over 1000 authorized users of the service, and to any county or provider wishing to access it. Having it done by LGAN and incorporating it into our online analysis service means that the methods are consistent, regardless of which authorized user generates the report, and the reports are automatically updated monthly with new data.
How We Work with Clients
Though the needs of each client are unique, LGAN works with each client in a similar manner. The following steps are followed to insure that each client gets the information they need:
Flexible User Management
Complex healthcare systems typically include many people with a variety of different information needs. In addition, the data is sensitive. Confidentiality concerns and regulatory requirements usually mean that a system of differential access to information is necessary. LGAN’s user management tools make it easy to disseminate information, and to restrict that dissemination when it is appropriate to do so. For some clients, we’ve created a level of public access, so that those not directly involved in a behavioral healthcare system can be given aggregated performance statistics in a way that protects privacy and confidentiality of patients.
Automated Data Processing and Reporting
Acquisition of data extracts of admissions, discharges, treatment services, medications, and treatment settings on a daily, weekly, or monthly basis allow us to provide highly customized sets of management reports delivered electronically (e-mail, web site updates, etc.) to any number of constituents or stakeholders.
Cloud Computing Advantage
LGAN hosts interactive analytic tools that allow any authorized user to conduct ad hoc analyses or generate pre-formatted reports updated with the latest data. Our use of the “Cloud” allows us to offer these tools via the Internet as "zero-footprint" computing services, removing nearly all the burden from the IT staff of providing analytic programming and infrastructure support. This frees up core staff to use their resources on providing quality patient care.
Sample Analytic Topics & Tools