IQUERY – archived project

Illinois Query or IQuery, is a web-based data query system for collecting and displaying health data. IQuery was a project of the Illinois Health Data Dissemination Initiative (IHDDI), a coalition of seven agencies of the State of Illinois, funded in part by the U.S. Centers for Disease Control and Prevention. The IHDDI and IQuery were administered by the Illinois Department of Public Health (IDPH), with project management by the Illinois Public Health Institute. The users of IQuery are state agency data stewards, staff from local health departments and community-based agencies including healthcare providers. Additionally, any member of the public can access IQuery online without the need to register or pay to access data. No personal or identifiable data is available through IQuery. The Illinois Public Health Institute (IPHI), hired as the agent of IDPH, created the IHDDI so it would accomplish the following three goals:

1)      Designed, developed, tested and deployed a simple and intuitive public-facing web-based data query system that allows users to create custom queries of locally-relevant public health data in tabular and graphical form

2)      Designed, developed, tested and deployed a flexible and comprehensive administrative system to allow data providers to upload, manage and publish their own data without the need for state-agency technical staff intervention.

3)      The IQuery system evolved to meet the needs of data stewards and public users as new datasets came available to allow for a variety of formats while maintaining consistency in the public interface and results format and the administrative interface. The design of IQuery allows for continued evolution and flexibility into the future.

IQuery launched in 2011 with data from the Illinois Department of Public Health: Vital Statistics, the Adverse Pregnancy Outcomes Reporting System (APORS), and census information for Illinois. Numerous other data sets will be added as other agencies and departments add their data to the system. This data is presented via age adjusted rates which are the rates of almost all causes of disease, injury, and death varied by age. Age adjustment is a technique for “removing” the effects of age from crude rates so as to allow meaningful comparisons across populations with different underlying age structures. A crude rate is a measure of some event, disease, or condition in reference to a population. Crude rates are calculated by dividing the number of events or cases by the population. Data is presented as it is collected and released by state agencies. The data collected, stored and displayed varies widely because of different laws and mandates for data collection, different collection methodologies, and different anticipated uses.