Welcome to Clinical Query 2 (CQ2)

Clinical Query 2 (CQ2) is a website that allows you to search the BIDMC Clinical Data Repository (CDR) for research purposes, such as obtaining preliminary patient counts for a grant or IRB proposal. CQ2 contains two tools:

Feature Description
Aggregate Query Tool After entering inclusion and exclusion criteria, CQ2 will tell you the number of matching patients in the CDR. You do not need an IRB protocol to run these aggregate count queries.
Data Download Tool If you have IRB approval, you can download patient level data, such as the medical record numbers (MRNs), for the patients who matched an aggregate count query that you previously ran in CQ2.

Important notes about the Data Download Tool: By default, only Principal Investigators (PIs) of protocols approved by the BIDMC IRB can use the Data Download Tool; however, PIs can grant access to Co-Investigators (see instructions within the Data Download Tool). Note that, in most cases, protocols approved by other institutions (e.g., DFCI) are not sufficient to use the Data Download Tool. This is because of technical limitations in how auditing in CQ2 works and the data collected by the BIDMC electronic IRB system. We are working on a solution to this problem. Please see the the section below on "Help and Support" for information on how the BIDMC InSIGHT Core can assist with accessing BIDMC clinical data.

Begin Using CQ2

In order to use CQ2, you will first need to complete HIPAA training (if you have not done so already), and then login to the website using your ITS username and password.

Username      Password     

Help and Support

For questions about using CQ2, please contact Griffin Weber at gweber@bidmc.harvard.edu or Academic Computing at research@bidmc.harvard.edu.

The InSIGHT Core is a research core at BIDMC that was created to help investigators extract custom datasets from clinical systems at BIDMC. In particular, the InSIGHT Core can access data that are not in CQ2, and they can format the data in ways that are not possible through CQ2. The InSIGHT Core can also access the list of patients who matched a query you previously ran using the Aggregate Query Tool. To get started, please contact Karla Pollick from the InSIGHT Core at kpollick@bidmc.harvard.edu.

User Feedback

CQ2 is an evolving product. We continually add new data and features based on feedback from investigators. Please send your suggestions on how we can improve CQ2 to Griffin Weber at gweber@bidmc.harvard.edu.

CQ2 Database Status

The CQ2 database contains most, but not all of the data inside the CDR. Data is not included in CQ2 if it cannot be mapped to a standard medical coding system. This can occur due to data entry errors, missing data, the use of codes that are now obsolete, or other reasons. We will continue to improve the data mapping and add new types of data in the future.

The last complete update of the CQ2 database was performed on 07/15/2018. However, there could be a delay of a month or more until clinical data enters the CDR. As a result, the CQ2 update date does not mean that all clinical data through that date has been loaded into CQ2. The table below provides details on each of the sources of data.

Data Type Coding Description
Demographics CQ2 Demographic data are obtained primarily from patient billing information, with BIDMC-specific codes consolidated into CQ2 categories, which include patient age, gender, and race. CQ2 contains demographic data for 2,748,495 patients.
Diagnoses ICD-9
ICD-10
Diagnoses are obtained from ED, inpatient, and outpatient (OMR) records. Both primary and secondary diagnoses are included in CQ2. CQ2 contains 49,411,581 diagnosis codes for 1,497,252 patients. Most diagnoses after October 1, 2015, use ICD-10 codes instead of ICD-9.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records (Millions)
6
3
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records / Patients
20
10
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
Medications RxNorm Medications are obtained from both inpatient (POE) and outpatient (OMR) records. CQ2 contains 41,455,879 medication records for 867,473 patients. This represents 82% of the medications in the CDR. The remaining medications have not been mapped to RxNorm yet.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records (Millions)
4
2
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records / Patients
20
10
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
Laboratory Tests LOINC Laboratory tests are obtained from inpatient and outpatient records. CQ2 contains 198,974,797 laboratory test results for 889,041 patients. This represents 95% of the laboratory test results in the CDR. The remaining tests have not been mapped to LOINC yet.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records (Millions)
20
10
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records / Patients
100
50
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
Procedures CPT-4 Procedure codes are obtained from billing records. CQ2 contains 39,851,508 CPT-4 codes for 1,374,660 patients. CPT-4 codes for Pathology & Laboratory and Radiology are currently not included in CQ2.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records (Millions)
4
2
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records / Patients
20
10
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
ICD-9
ICD-10
CQ2 contains 7,191,324 ICD-9 procedure codes for 826,369 patients. Note that most procedures are only coded as CPT-4 starting January 1, 2010; and, ICD-10 replaced ICD-9 codes starting October 1, 2015.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records (Millions)
1
0.5
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records / Patients
6
3
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
Vital Signs LOINC Vital signs are obtained from OMR sheet records. CQ2 contains 36,404,550 vital signs results for 590,253 patients starting in 2006.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records (Millions)
6
3
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Records / Patients
30
15
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
Visits   CQ2 contains data for 1,091,654 emergency visits for 455,437 patients.
Patients (Thousands)
60
30
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Visits (Thousands)
80
40
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Visits / Patients
2
1
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
CQ2 contains data for 813,816 inpatient visits for 447,945 patients.
Patients (Thousands)
60
30
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Visits (Thousands)
60
30
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Visits / Patients
2
1
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table
CQ2 contains data for 30,227,706 outpatient visits for 1,306,513 patients.
Patients (Thousands)
400
200
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Visits (Millions)
4
2
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
Visits / Patients
8
4
0
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
97
00
05
10
15
20
Year
show table

Shared Health Research Information Network (SHRINE)

The Shared Health Research Information Network (SHRINE) is a federated research network across multiple hospitals, including BIDMC. CQ2 and SHRINE are based on similar software, but they differ in several important ways:

Attribute Clinical Query 2 SHRINE
Requirements ITS username and password, HIPAA training ITS username and password, BIDMC employee, HIPAA training, faculty rank of Instructor or above (or Post-Docs with a sponsor who is an Instructor or above), HMS eCommons ID, approved topic query
Hospitals BIDMC Only BIDMC, BWH, MGH, Childrens, DFCI
Types of Queries Aggregate counts, detailed patient data via the InSIGHT Core Only aggregate counts
Type of Data demographics, diagnoses, medications, laboratory tests, procedures, vital signs, visits demographics, diagnoses, medications (limited), laboratory tests (limited)
Business Owner BIDMC (Research and Academic Affairs) HMS (Harvard Catalyst)

Release History

The following dates indicate major updates to the Clinical Query 2 website:

Date Description
12/31/2015 Diagnosis and procedure codes were updated to support the switch from ICD-9 to ICD-10 that occurred on October 1, 2015.
04/28/2015 A Data Download Tool was added to CQ2 to enable investigators who have IRB approval to extract patient level data.
02/10/2015 The CQ2 home page was expanded to include release history and display the number of patients per year with each data type. New functionality includes temporal queries, demographic breakdowns on query results, and a new Workplace section to bookmark commonly used concepts or save previous queries.
10/28/2014 Vital signs were added.
08/18/2013 Visit details (emergency, inpatient, outpatient, length of stay) were added. Users can now search for concepts that were observed in the same financial encounter.
10/01/2012 CQ2 was launched.