Query Tool

Vertical Tabs

Welcome

The LTRC Query Tool is a web-based utility that allows researchers to quickly search and identify appropriate LTRC cases to support their research projects. The results generated by the tool reflect the cohort as it was reported in the central database on September 6, 2017. There are a total of 4,325 cases enrolled into the LTRC study. The presence of records meeting your search criteria does not guarantee that specimens selected are available for study. A formal review of the central inventory will be conducted following approval of your request application to confirm availability.

Please note the following key features of the query tool:

  • All drop-down fields by default are set to “Any” and all fields marked with this option are not included in the query results.
  • Selecting “All” causes the query to add the field to the results but does not filter the case listing.
  • Selecting the “Exclude” modifier plus a specific field value removes cases from the results table with this value.
  • If multiple values are selected in your query, only cases which meet all of the specified conditions will be displayed.
  • Click “Submit” to generate query results and click "Reset" to remove all previous criteria selections.
  • A Summary tab will appear in the Content Area Menu to the left following the submission of a query. The Summary page will list all of the criteria selected in the query.
  • Click "Download Data" to download a csv formatted file to your computer containing the results of your query.

After you submit a query, a message will appear indicating the overall results, a unique query ID that can be stored for future reference, and a case listing table. You may modify selection criteria and add fields iteratively on the various content tabs to narrow down your search. Note: green highlights in the results table indicate the values matching specified criteria. A collapsible menu to contact the DCC with your current query results is available below the results table.

Demographics

Select demographic criteria from the list below.

Pulmonary Function Tests

Select pre- and post-bronchodilator PFT criteria from the lists below, or select desired GOLD stage. GOLD criteria are defined as follows:

In participants with FEV1/FVC ratio <0.70:

  • GOLD 1: FEV1 % predicted >=80
  • GOLD 2: FEV1 % predicted 50-79 (inclusive)
  • GOLD 3: FEV1 % predicted 30-49 (inclusive)
  • GOLD 4: FEV1 % predicted <30

Participants in LTRC with FEV1/FVC ratio >= 0.70 and FEV1 % predicted >= 80 are considered as having normal lung function.

Participants in LTRC with FEV1/FVC ratio >= 0.70 and FEV1 % predicted < 80 are considered as having unclassified GOLD criteria

Pre-bronchodilator Assessments
Post-bronchodilator Assessments
Smoking History

Select criteria for smoking history from the lists below.

Cigarettes
Cigars/Cigarillos/Pipes
Clinical Diagnosis

Select the desired clinical diagnosis category or specific clinical diagnosis using the lists below. The LTRC categorizes clinical diagnoses as follows:

COPD: Emphysema

ILD: Idiopathic pulmonary fibrosis, NSIP, Desquamative interstitial pneumonia, Respiratory bronchiolitis, Respiratory bronchiolitis-interstitial lung disease, Lymphocytic interstitial pneumonia, Cryptogenic Organizing Pneumonia, Acute Interstitial Pneumonia, Fibrosis-Uncharacterized, Hypersensitivity Pneumonitis, Autoimmune Disease (SLE, Sjogren, RA, Scleroderma, PM/DM, MCTD, and UCTD types)

Control: Normal, Carcinoma (non-small or small cell)

Other: Bronchiolitis (Constrictive, Proliferative, Cellular, Diffuse panbronchiolitis, Neuroendocrine Cell hyperplasia types), Vasculitis/Capillaritis, Eosinophilic Granuloma (EG, LCG), Eosinophilic Pneumonia, Granulomatous Infection (M Tuberculosis, Atypical Tuberculosis (MAI), Fungi, and NOS types)

Note clinical diagnoses are not mutually exclusive from pathology and radiology diagnoses.

Pathology Diagnosis

Select the desired pathology diagnosis category or specific pathology diagnosis using the lists below. The LTRC categorizes pathology diagnoses as follows:

COPD: Emphysema (centrilobular, panlobular, or paraseptal types)

ILD: Usual interstitial pneumonia, Non-specific interstitial pneumonia, Desquamative interstitial pneumonia, Respiratory bronchiolitis, Respiratory bronchiolitis-interstitial lung disease, Lymphocytic interstitial pneumonia, Organizing Pneumonia, Diffuse Alveolar Damage, Fibrosis-Uncharacterized, Hypersensitivity Pneumonitis (Cellular or Fibrotic)

Control: Normal

Other: Non-Diagnostic, Honeycomb Lung, Carcinoma (non-small or small cell), Lymphoma, Sarcoma, Sarcoid, Berylliosis, Bronchiolitis (Constrictive, Proliferative, Cellular, Diffuse panbronchiolitis, Neuroendocrine Cell hyperplasia types), Vasculitis/Capillaritis, Eosinophilic Granuloma (EG, LCG), Eosinophilic Pneumonia, Granulomatous Infection (M Tuberculosis, Atypical Tuberculosis (MAI), Fungi, and NOS types)

Note pathology diagnoses are not mutually exclusive from clinical and radiology diagnoses.

Radiology Diagnosis

Select the desired specific radiology diagnosis using the list below.

Note radiology diagnoses are not mutually exclusive from clinical and pathology diagnoses.

Specimen Inventory

Select the desired specimen types using the checkboxes below.

Gene Array Data
CT Scan Inventory