Loading...

National Institute of Mental Health Data Archive (NDA) Sign In
NDA

Enter the email address associated with your existing NDA Account and click Continue Linking Process.

If you do not have an existing NDA account, click Go Back.

Warning Notice This is a U.S. Government computer system, which may be accessed and used only for authorized Government business by authorized personnel. Unauthorized access or use of this computer system may subject violators to criminal, civil, and/or administrative action. All information on this computer system may be intercepted, recorded, read, copied, and disclosed by and to authorized personnel for official purposes, including criminal investigations. Such information includes sensitive data encrypted to comply with confidentiality and privacy requirements. Access or use of this computer system by any person, whether authorized or unauthorized, constitutes consent to these terms. There is no right of privacy in this system.
National Institute of Mental Health Data Archive (NDA) Sign In
NDA

Success! An email is on its way!

Please check your email to complete the linking process. The link you receive is only valid for 30 minutes.

Check your spam or junk folder if you do not receive the email in the next few minutes.

Warning Notice This is a U.S. Government computer system, which may be accessed and used only for authorized Government business by authorized personnel. Unauthorized access or use of this computer system may subject violators to criminal, civil, and/or administrative action. All information on this computer system may be intercepted, recorded, read, copied, and disclosed by and to authorized personnel for official purposes, including criminal investigations. Such information includes sensitive data encrypted to comply with confidentiality and privacy requirements. Access or use of this computer system by any person, whether authorized or unauthorized, constitutes consent to these terms. There is no right of privacy in this system.
Create or Link an Existing NDA Account

Warning Notice

This is a U.S. Government computer system, which may be accessed and used only for authorized Government business by authorized personnel. Unauthorized access or use of this computer system may subject violators to criminal, civil, and/or administrative action. All information on this computer system may be intercepted, recorded, read, copied, and disclosed by and to authorized personnel for official purposes, including criminal investigations. Such information includes sensitive data encrypted to comply with confidentiality and privacy requirements. Access or use of this computer system by any person, whether authorized or unauthorized, constitutes consent to these terms. There is no right of privacy in this system.

NIMH Data Archive (NDA) Sign In or Create An Account
Update Password

You have logged in with a temporary password. Please update your password. Passwords must contain 8 or more characters and must contain at least 3 of the following types of characters:

  • Uppercase
  • Lowercase
  • Numbers
  • Special Characters limited to: %,_,!,@,#,$,-,%,&,+,=,),(,*,^,:,;
Update Password

Subscribe to our mailing list

Mailing List(s)
Email Format

You are now leaving the NIMH Data Archive (NDA) web site to go to:

Click on the address above if the page does not change within 10 seconds.

Disclaimer

NDA is not responsible for the content of this external site and does not monitor other web sites for accuracy.

Accept Terms
Data Access Terms - Decline Terms

Are you sure you want to cancel? This will decline terms and you will not be authorized for access.

NIMH Data Archive
Filter Cart
No filters selected
Description
Value Range
Notes
Data Structures with shared data
No filters have been selected
helpcenter.filter-cart

NDA Help Center

Filter Cart

Viewable at the top right of NDA pages, the Filter Cart is a temporary holder for filters and data they select. Filters are added to the Workspace first, before being submitted to The Filter Cart. Data selected by filters in the Filter Cart can be added to a Data Package or an NDA Study from the Data Packaging Page, by clicking the 'Create Data Package / Add Data to Study' button.

The filter cart supports combining multiple filters together, and depending on filter type will use "AND" or "OR" when combining filters.

Multiple selections from the same filter type will result in those selections being applied with an ‘OR’ condition. For example, if you add an NDA Collection Filter with selections for both collections 2112 and 2563 to an empty Workspace, the subjects from NDA Collection 2112 ‘OR’ NDA Collection 2563 will be added to your Workspace even if a subject is in both NDA Collections. You can then add other NDA Collections to your Workspace which further extends the ‘OR’ condition.

If a different filter type is added to your Workspace, or a filter has already been submitted to the Filter Cart, the operation then performs a logical ‘AND’ operation. This means that given the subjects returned from the first filter, only those subjects that matched the first filter are returned by the second filter (i.e., subjects that satisfied both filters).

When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

Note that only the subjects specific to your filter will be added to your Filter Cart and only on data shared with the research community. Other data for those same subjects may exist (i.e., within another NDA Collection, associated with a data structure that was not requested in the query, etc.). So, users should select ‘Find all Subjects Data’ to identify all data for those specific subjects.

Additional Tips:

  • You may query the data without an account, but to gain access you will need to create an NDA user account and apply for access. Most data access requires that you or your lab are sponsored by an NIH recognized institution with Federal Wide Assurance (FWA). Without access, you will not be able to obtain individual-level data.

Once you have selected data of interest you can:

  • Create a data package - This allows you to specify format for access/download
  • Assign to Study Cohort - Associate the data to an NDA Study allowing for a DOI to be generated and the data to be linked directly to a finding, publication, or data release.
  • Find All Subject Data - Depending on filter types being used, not all data associated with a subject will be selected. Data may be restricted by data structure, NDA Collection, or outcome variables (e.g., NDA Study). ‘Find All Data’ expands the filter criteria by replacing all filters in your Filter Cart with a single Query by GUID filter for all subjects selected by those filters.

Please Note:

  • When running a query, it may take a moment to populate the Filter Cart. Queries happen in the background so you can define other queries during this time.
  • When you add your first filter, all data associated with your query will be added to the Filter Cart (e.g., a Concept, an NDA Collection, a Data Structure/Element, etc.). As you add additional filters, they will also display in the Filter Cart. Only the name of filter will be shown in the Filter Cart, not the underlying structures.
  • Information about the contents of the Filter Cart can be seen by clicking "Edit”.
  • Once your results appear in the Filter Cart, you can create a data package or assign subjects to a study by selecting the 'Package/Assign to Study' option. You can also 'Edit' or 'Clear' filters.

Frequently Asked Questions

  • What is a Filter Cart?
    Viewable at the top right of NDA pages, the Filter Cart is a temporary holder of data identified by the user, through querying or browsing, as being of some potential interest. The Filter Cart is where you send the data from your Workspace after it has been filtered.
  • What do I do after filters are added to the Filter Cart?
    After filters are added to the Filter Cart, users have options to ‘Create a Package’ for download, ‘Associate to Study Cohort’, or ‘Find All Subject Data’. Selecting ‘Find All Subject Data’ identifies and pulls all data for the subjects into the Filter Cart. Choosing ‘Create a Package’ allows users to package and name their query information for download. Choosing ‘Associate to Study Cohort’ gives users the opportunity to choose the Study Cohort they wish to associate this data.
  • Are there limitations on the amount of data a user can download?

    NDA limits the rate at which individual users can transfer data out of Amazon Web Services (AWS) S3 Object storage to non-AWS internet addresses. All users have a download limit of 20 Terabytes. This limit applies to the volume of data an individual user can transfer within a 30-day window. Only downloads to non-AWS internet addresses will be counted against the limit.

  • How does Filter Cart Boolean logic work?

    The Filter Cart currently employs basic AND/OR Boolean logic. A single filter may contain multiple selections for that filter type, e.g., a single NDA Study filter might contain NDA Study 1 and NDA Study 2. A subject that is in EITHER 1 OR 2 will be returned. Adding multiple filters to the cart, regardless of type, will AND the result of each filter. If NDA Study 1 and NDA Study 2 are added as individual filters, data for a subject will only be selected if the subject is included in BOTH 1 AND 2.

    When combining other filters with the GUID filter, please note the GUID filter should be added last. Otherwise, preselected data may be lost. For example, a predefined filter from Featured Datasets may select a subset of data available for a subject. When combined with a GUID filter for the same subject, the filter cart will contain all data available from that subject, data structure, and dataset; this may be more data than was selected in the predefined filter for that subject. Again, you should add the GUID Filter as the last filter to your cart. This ensures 'AND' logic between filters and will limit results to the subjects, data structures, and datasets already included in your filter cart.

Glossary

  • Workspace
    The Workspace within the General Query Tool is a holding area where you can review your pending filters prior to adding them to Filter Cart. Therefore, the first step in accessing data is to select one or more items and move it into the Workspace.
  • Filter Cart
    Viewable at the top right of NDA pages, the Filter Cart is a temporary holder of data identified by the user through querying or browsing as being of some potential interest. The Filter Cart adds data using an AND condition. The opportunity to further refine data to determine what will be downloaded or sent to a miNDAR is available on the Data Packaging Page, the next step after the Filter Cart. Subsequent access to data is restricted by User Permission or Privilege; however Filter Cart use is not.
Contact NDA Help Desk
Switch User

Charlson Comorbidity Index

434 Shared Subjects

N/A
Clinical Assessments
Diagnostic
05/23/2017
cci01
04/17/2023
View Change History
01
Definition
Submission Template
Query Element Name Data Type Size Required Description Value Range Notes Aliases
subjectkey GUID Required The NDAR Global Unique Identifier (GUID) for research subject NDAR* nimhid
src_subject_id String 20 Required Subject ID how it's defined in lab/project id, ptid, subject_id, subjectid, subjid
interview_date Date Required Date on which the interview/genetic test/sampling/imaging/biospecimen was completed. MM/DD/YYYY charlson_date, hamddt, interview_date_charc, testdate, v1_hamd_date, v2_hamd_date, visit_date
interview_age Integer Required Age in months at the time of the interview/test/sampling/imaging. 0 :: 1260 Age is rounded to chronological month. If the research participant is 15-days-old at time of interview, the appropriate value would be 0 months. If the participant is 16-days-old, the value would be 1 month. age, v1_hamd_age, v2_hamd_age
sex String 20 Required Sex of subject at birth M;F; O; NR M = Male; F = Female; O=Other; NR = Not reported gender
crcid String 40 Recommended CRC ID/ROA ID
date Date Recommended Open Label Baseline date Complete only if starting Open Label Phase. OL Baseline contact is visit where participant is given active drug - included in random data set.
Query update Integer Recommended Updated form 0;1 1= yes; 0= no
Query lang_visit Integer Recommended Language during visit 0;1 1=Spanish; 0=English spanish
Query charc1 Integer Recommended CCI question 1: Ever had chest discomfort or been told that has angina;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_1
Query charc1a Integer Recommended CCI question 1a: Chest discomfort/angina occurs with exertion;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_1a
Query charc1b Integer Recommended CCI question 1b: Chest discomfort/angina occurs at rest or awakens from sleep;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_1b
Query charc2 Integer Recommended CCI question 2: Ever had to use any medication under tongue for chest discomfort;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_2
Query charc3 Integer Recommended CCI question 3: Ever been told that had a heart attack;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_3
Query charc3a Integer Recommended CCI question 3a: Number of heart attacks (77=Don't know, 88=Refused) 0;1;9 0=No; 1=Yes; 9=Missing cci_3a
Query charc3b Integer Recommended CCI question 3b: Time since last heart attack;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1;2;3;4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_3b
Query charc4 Integer Recommended CCI question 4: Ever had heart bypass surgery or angioplasty;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_4
Query charc5 Integer Recommended CCI question 5: Ever get short of breath;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_5
Query charc5a String 255 Recommended CCI question 5a: If CharC5=1, under what circumstances gets short of breath cci_5a
Query charc6 Integer Recommended CCI question 6: Ever been told that has congestive heart failure;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_6
Query charc6a Integer Recommended CCI question 6a: If 6=1, currently taking medication for heart failure;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_6a
Query charc7 Integer Recommended CCI question 7: Often notice heart beating fast or irregularly;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_7
Query charc7a Integer Recommended CCI question 7a: If 7=1, have seen doctor about heart beating fast/irregularly;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_7a
Query charc8 Integer Recommended CCI question 8: Have been told that has atrial fibrillation;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_8
Query charc9 Integer Recommended CCI question 9: Tend to cough a lot (nearly everyday or for weeks at a time);0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_9
Query charc9a Integer Recommended CCI question 9a: If 9=1, is coughing seasonal;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_9a
Query charc9b Integer Recommended CCI question 9b: If 9=1, is coughing related to exertion or exercise;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_9b
Query charc10 Integer Recommended CCI question 10: Ever noticed wheezing or making unusual noises when breathing;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_10
Query charc11 Integer Recommended CCI question 11: Ever been told has asthma;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_11
Query charc11a Integer Recommended CCI question 11a: If 11=1, been hospitalized for asthma in past 10 years;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_11a
Query charc11b Integer Recommended CCI question 11b: If 11=1, on regular medicine for asthma;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_11b
Query charc12 Integer Recommended CCI question 12: Calves/thighs cramp when walking if ambulatory, sleeping if not;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_12
Query charc12a Integer Recommended CCI question 12a: If 12=1 and ambulatory, cramping goes away with rest;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_12a
Query charc13 Integer Recommended CCI question 13: Ever been told that had a stroke;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_13
Query charc13a Integer Recommended CCI question 13a: If 13=1, has lasting effects from the stroke;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_13a
Query charc14 Integer Recommended CCI question 14: Has had loss of movement of limb/side of body, slurred speech, sudden fading vision, or been told that had TIA;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_14
Query charc14a Integer Recommended CCI question 14a: If CharC14=1, when symptoms/TIA last happened;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_14a
Query charc14b Integer Recommended CCI question 14b: If CharC14=1, number of times symptoms/TIA have happened;1-98=actual number,99=Too numerous to specify -1;0::87; 98; 99 0-98=actual number,99=Too numerous to specify; -1=Missing cci_14b
Query charc15 Integer Recommended CCI question 15: Has been told that has diabetes/high blood sugar;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_15
Query charc15a Integer Recommended CCI question 15a: If CharC15=1, age in years when first diagnosed with diabetes/high blood sugar -1;1::87 -1=Missing cci_15a
Query charc15b Integer Recommended CCI question 15b: If 15=1, currently taking medication for diabetes/high blood sugar;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_15b
Query charc16 Integer Recommended CCI question 16: Ever been told that has significant problems with kidneys;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_16
Query charc16a Integer Recommended CCI question 16a: If 16=1, ever been on dialysis;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_16a
Query charc17 Integer Recommended CCI question 17: Ever been told that has liver problems;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_17
charc17a String 255 Recommended CCI question 17a: If CharC17=1, what was/is liver problem? cci_17a
Query charc17b Integer Recommended CCI question 17b: If 17=1, has any lasting effects that continue until today;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_17b
Query charc17c Integer Recommended CCI question 17c: If 17=1, has any dietary or alcohol restrictions because of liver problems;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_17c
Query charc18 Integer Recommended CCI question 18: Ever been told that has stomach ulcer;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_18
Query charc18a Integer Recommended CCI question 18a: If 18=1, ever had bleeding ulcer;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_18a
Query charc18b Integer Recommended CCI question 18b: If 18=1, currently take medication for an ulcer;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_18b
Query charc19 Integer Recommended CCI question 19: Ever been told that had cancer;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_19
Query charc19a Integer Recommended CCI question 19a: If CharC19=1, when first diagnosed with cancer;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_19a
Query charc19b1 Integer Recommended CCI question 19b1: If CharC19=1, code of primary tumor site one -1;1::12;20 -1=Missing; 1=Bladder; 2=Breast; 3=Colorectal; 4=Kidney; 5=Lung and bronchus; 6=Lymphoma; 7=Oral cavity and pharynx; 8=Pancreas; 9=Prostate; 10=Skin [Non-Melanoma]; 11=Skin [Melanoma]; 12=Stomach; 20=Some Other Cancer cci_19b1
Query charc19b2 Integer Recommended CCI question 19b2: If CharC19=1, code of primary tumor site two -1;1::12;20 -1=Missing; 1=Bladder; 2=Breast; 3=Colorectal; 4=Kidney; 5=Lung and bronchus; 6=Lymphoma; 7=Oral cavity and pharynx; 8=Pancreas; 9=Prostate; 10=Skin [Non-Melanoma]; 11=Skin [Melanoma]; 12=Stomach; 20=Some Other Cancer cci_19b2
Query charc19b3 Integer Recommended CCI question 19b3: If CharC19=1, code of primary tumor site three -1;1::12;20 -1=Missing; 1=Bladder; 2=Breast; 3=Colorectal; 4=Kidney; 5=Lung and bronchus; 6=Lymphoma; 7=Oral cavity and pharynx; 8=Pancreas; 9=Prostate; 10=Skin [Non-Melanoma]; 11=Skin [Melanoma]; 12=Stomach; 20=Some Other Cancer cci_19b3
charc19b4 String 255 Recommended CCI question 19b4: If CharC19b1=20 or CharC19b2=20 or CharC19b3=20, specification of other primary tumor site cci_19b1_text
Query charc19c Integer Recommended CCI question 19c: If 19=1, tumor spread to other parts of body (any tumor ever);0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_19c
Query charc19d Integer Recommended CCI question 19d: If 19=1, received chemotherapy or radiation therapy (for any tumor ever);0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_19d
Query charc19e Integer Recommended CCI question 19e: If 19=1, did you have to be operated on for your cancer? (any tumor ever);0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_19e
Query charc19f Integer Recommended CCI question 19f: If CharC19=1, when were you last treated with chemotherapy, radiation, or surgery? (for any tumor ever);1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_19f
Query charc20 Integer Recommended CCI question 20: Ever been told that has/had leukemia;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_20
Query charc21 Integer Recommended CCI question 21: Ever been told that has/had serious problem with joints;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_21
charc21a String 255 Recommended CCI question 21a: If CharC21=1, what is/was the problem? cci_21a
Query charc22 Integer Recommended CCI question 22: Ever been tested HIV positive;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_22
Query charc22a Integer Recommended CCI question 22a: If 22=1, carries the diagnosis of AIDS;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_22a_2
Query charc22b Integer Recommended CCI question 22b: If 22=1, has had wasting;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_22b
Query charc23 Integer Recommended CCI question 23: Ever been told has problem with thyroid;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_23
Query charc23a Integer Recommended CCI question 23a: If CharC23=1, thyroid was underactive or overactive;1=Underactive,2=Overactive 1;2;9 1=Underactive; 2=Overactive; 9=Missing cci_23a
Query charc23b Integer Recommended CCI question 23b: If 23=1, currently takes medication for thyroid;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_23b
Query charc23c Integer Recommended CCI question 23c: If CharC23=1, when was last time medication was changed for thyroid condition?;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_23c
Query charc23d Integer Recommended CCI question 23d: If CharC23=1, when was last time had blood test to check thyroid?;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_23d
Query charc24 Integer Recommended CCI question 24: Has been told that has deficiency of vitamin B12 or anemia;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_24
Query charc24a Integer Recommended CCI question 24a: If 24=1, is currently receiving replacement shots (B12);0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_24a
Query charc25 Integer Recommended CCI question 25: Has been told that has Parkinson's Disease;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_25
Query charc25a Integer Recommended CCI question 25a: If CharC25=1, how long ago Parkinson's diagnosis was made;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_25a
Query charc25b Integer Recommended CCI question 25b: If 25=1, is currently taking medication for Parkinson's Disease;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_25b
Query charc25c Integer Recommended CCI question 25c: If CharC25=1, when was last time Parkinson's medication was changed?;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1::4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_25c
Query charc26 Integer Recommended CCI question 26: Has been told that has high blood pressure, or has been treated for it;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_26
Query charc27 Integer Recommended CCI question 27: Has been told by physician that subject has significant bleeding problem;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_27
Query charc28 Integer Recommended CCI question 28: Since age of 55, has had any fractures;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_28
Query charc28a1 Integer Recommended CCI question 28a1: If CharC28=1, code of first location that was fractured ;please see CharlsonCOPD28aCode 1::10 1=Spine; 2=Hip; 3=Face/Head; 4=Upper extremity; 5=Shoulder; 6=Lower extremity; 7=Pelvis; 10=Some other fracture; 9=Missing cci_28a1
Query charc28a2 Integer Recommended CCI question 28a2: If CharC28=1, code of second location that was fractured;please see CharlsonCOPD28aCode 1::10 1=Spine; 2=Hip; 3=Face/Head; 4=Upper extremity; 5=Shoulder; 6=Lower extremity; 7=Pelvis; 10=Some other fracture; 9=Missing cci_28a2
Query charc28a3 Integer Recommended CCI question 28a3: If CharC28=1, code of third location that was fractured;please see CharlsonCOPD28aCode 1::10 1=Spine; 2=Hip; 3=Face/Head; 4=Upper extremity; 5=Shoulder; 6=Lower extremity; 7=Pelvis; 10=Some other fracture; 9=Missing cci_28a3
Query charc28a4 String 255 Recommended CCI question 28a4: If CharC28a1=10 or CharC28a2=10 or CharC28a3=10, specification of other fracture location cci_28a1_txt
Query charc28b Integer Recommended CCI question 28b: If 28=1, age in years at time of most recent fracture (-2=Don't know; -3=Refused; -1=Missing) -3::999 -2=Don't know; -3=Refused; -1=Missing cci_28b
Query charc29 Integer Recommended CCI question 29: Wears eyeglasses or contact lenses;0=No,1=Just for reading,2=All the time,7=Don't know,8=Refused 0;1;2;7;8;9 0=No; 1=Just for reading; 2=All the time; 7=Don't know; 8=Refused; 9=Missing cci_29
Query charc30 Integer Recommended CCI question 30: Wears a hearing aid;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_30
Query charc31 Integer Recommended CCI question 31: Has smoked any cigarettes in past 6 months;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_31
Query charc31a Integer Recommended CCI question 31a: On average, number of cigarettes smoked per day -1::999 -1=Missing
Query charc32 Integer Recommended CCI question 32: Noticed any significant problems with memory;0=No,1=Yes 0;1;9 0=No; 1=Yes; 9=Missing cci_32
Query charc32a Integer Recommended CCI question 32a: How frequently has problem with memory;1=Rarely,2=Less than once per wk,3=More than once per wk 1;2;3;9 1=Rarely; 2=Less than once per wk; 3=More than once per wk; 9=Missing cci_32a
Query charc32b Integer Recommended CCI question 32b: How long memory symptoms have persisted;1=Within past 6 mos,2=More than 6 mos and up to 1 yr,3=More than 1 yr and up to 2 yrs,4=More than 2 yrs ago 1;2;3;4;9 1=Within past 6 mos; 2=More than 6 mos and up to 1 yr; 3=More than 1 yr and up to 2 yrs; 4=More than 2 yrs ago; 9=Missing cci_32b
Query charlson_score String 50 Recommended Final Charlson Score charlsontot_ssw
Query pchrlson Float Recommended Charlson variable computed from admissions prior to and including the event
Query xchrlson Float Recommended Charlson variable computed from the event admission only
pcomp String 1,000 Recommended Component variables for the Charlson variable observed on admissions prior to the event
xcomp String 1,000 Recommended Component variables for the Charlson variable which were observed on the event admission
aggregates String 1,000 Recommended Combinations of PCOMP and XCOMP variables which are used for final determination of the Charlson score
Query cci_19b1_other Integer Recommended Were there any other types of cancer? Answer if second cancer 0;1 0=No; 1=Yes
Query cci_19b2_other Integer Recommended Were there any other types of cancer? Answer if third cancer 0;1 0=No; 1=Yes
Query cci_28a_other Integer Recommended Were there any other fractures? Answer if second fracture 0;1 0=No; 1=Yes
Query cci_28a_other2 Integer Recommended Were there any other fractures? Answer if third fracture 0;1 0=No; 1=Yes
Query aescode Integer Recommended Staff code number of person completing this form 999= Missing Data charlson_interviewer
Query sub_tob3 Float Recommended Amount (in # of packs per day) 1 pack equals 20 cigarettes/cigarillos cci_31a
comments_misc String 4,000 Recommended Miscellaneous comments on study, interview, methodology relevant to this form data charlson_comments
Query dode String 10 Recommended Date of Data Entry charlson_entered
Query visit String 60 Recommended Visit name
Query charlson1_ssw Integer Recommended At present time, do you have any of the following: asthma, emphysema, or chronic bronchitis? Lowest Charlson Weight is 1; Highest Charlson Weight is 1. Study-specific weights may lie outside these ranges.
Query charlson2_ssw Integer Recommended At present time, do you have any of the following: arthritis or rheumatism? Lowest Charlson Weight is 0; Highest Charlson Weight is 1. Study-specific weights may lie outside these ranges.
Query charlson3_ssw Integer Recommended At present time, do you have any of the following: cancer, diagnosed in the past 3 years? Lowest Charlson Weight is 2; Highest Charlson Weight is 6. Study-specific weights may lie outside these ranges.
Query charlson4_ssw Integer Recommended At present time, do you have any of the following: diabetes? Lowest Charlson Weight is 1; Highest Charlson Weight is 2. Study-specific weights may lie outside these ranges.
Query charlson5_ssw Integer Recommended At present time, do you have any of the following: digestive problems (such as ulcer, colitis, or gallbladder disease? Lowest Charlson Weight is 0; Highest Charlson Weight is 1. Study-specific weights may lie outside these ranges.
Query charlson6_ssw Integer Recommended At present time, do you have any of the following: heart trouble (such as angina, congestive heart failure, or coronary artery disease? Lowest Charlson Weight is 0; Highest Charlson Weight is 2. Study-specific weights may lie outside these ranges.
Query charlson7_ssw Integer Recommended At present time, do you have any of the following: HIV illness or AIDS Lowest Charlson Weight is 0; Highest Charlson Weight is 6. Study-specific weights may lie outside these ranges.
Query charlson8_ssw Integer Recommended At present time, do you have any of the following: kidney disease Lowest Charlson Weight is 0; Highest Charlson Weight is 2. Study-specific weights may lie outside these ranges.
Query charlson9_ssw Integer Recommended At present time, do you have any of the following: liver problems (such as cirrhosis) Lowest Charlson Weight is 1; Highest Charlson Weight is 3. Study-specific weights may lie outside these ranges.
Query charlson10_ssw Integer Recommended At present time, do you have any of the following: stroke Lowest Charlson Weight is 1; Highest Charlson Weight is 1. Study-specific weights may lie outside these ranges.
study String 100 Recommended Study; The code for each individual study
cci_8_pastyear Integer Recommended In the past year, have you experienced Peptic Ulcer Disease? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_9_pastyear Integer Recommended In the past year, have you experienced Liver Disease? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_10_pastyear Integer Recommended In the past year, have you experienced Diabetes? 1::3; -9 1= None or Diet Controlled; 2= Uncomplicated; 3= End-organ damage; -9= Missing
cci_11_pastyear Integer Recommended In the past year, have you experienced Hemiplegia? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_12_pastyear Integer Recommended In the past year, have you experienced Moderate to Severe Chronic Kidney Disease? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_13_pastyear Integer Recommended In the past year, have you experienced Solid Tumor? 1::3; -9 1= None; 2= Localized; 3= Metastatic; -9= Missing
cci_14_pastyear Integer Recommended In the past year, have you experienced Leukemia? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_15_pastyear Integer Recommended In the past year, have you experienced Lymphoma? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_16_pastyear Integer Recommended In the past year, have you experienced AIDS? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_1_pastyear Integer Recommended In the past year, have you experienced Myocardial Infraction? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_2_pastyear Integer Recommended In the past year, have you experienced Congestive Heart Failure? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_3_pastyear Integer Recommended In the past year, have you experienced Peripheral Vascular Disease? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_4_pastyear Integer Recommended In the past year, have you experienced Cerebrovascular Accident or Transient Ischemic Attack (TIA)? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_5_pastyear Integer Recommended In the past year, have you experienced Dementia? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_6_pastyear Integer Recommended In the past year, have you experienced Chronic Obstructive Pulmonary Disease (COPD)? 1::2; -9 1= Yes; 2= No; -9= Missing
cci_7_pastyear Integer Recommended In the past year, have you experienced Connective Tissue Disease? 1::2; -9 1= Yes; 2= No; -9= Missing
Data Structure

This page displays the data structure defined for the measure identified in the title and structure short name. The table below displays a list of data elements in this structure (also called variables) and the following information:

  • Element Name: This is the standard element name
  • Data Type: Which type of data this element is, e.g. String, Float, File location.
  • Size: If applicable, the character limit of this element
  • Required: This column displays whether the element is Required for valid submissions, Recommended for valid submissions, Conditional on other elements, or Optional
  • Description: A basic description
  • Value Range: Which values can appear validly in this element (case sensitive for strings)
  • Notes: Expanded description or notes on coding of values
  • Aliases: A list of currently supported Aliases (alternate element names)
  • For valid elements with shared data, on the far left is a Filter button you can use to view a summary of shared data for that element and apply a query filter to your Cart based on selected value ranges

At the top of this page you can also:

  • Use the search bar to filter the elements displayed. This will not filter on the Size of Required columns
  • Download a copy of this definition in CSV format
  • Download a blank CSV submission template prepopulated with the correct structure header rows ready to fill with subject records and upload

Please email the The NDA Help Desk with any questions.