Curated Data Repository and Development Release Notes (R2020Q4R2 CDR)

CDR Version/

Version Date

Type

Public Release Note

R2020Q4R2_base

11/10/2020

Wearable Device

Added wearables data (e.g., Fitbit®) in non-OMOP supplemental tables, though all new tables and fields are recorded on the Available Fields tab of CDR Data Dictionary. These data, released as an initial pilot, contain both detailed and summary data for heart rate and physical activity level. The CDR contains at least some degree of Fitbit® data elements for 8,435 participants beginning December 10, 2008 through November 26, 2019. The total number of participants is representative of all individuals who selected to link their Fitbit data devices with the All of Us Research Program prior to November 26, 2019. All dates are shifted according to standard Registered Tier Privacy rules.

Surveys

Added data from the COVID-19 Participant Experience (COPE) survey. All participants who completed the Basics survey were eligible to complete a COPE survey in May, June, and July 2020. The CDR contains response data from all three survey versions and will be updated in the future to include data from additional versions. Response data specific to COVID-19 diagnoses and treatment have been suppressed from the Registered Tier dataset to protect participant privacy. Suppressed COPE survey concepts can be found in the Registered Tier CDR data dictionary. Unlike other data elements, the original date/time completion for COPE surveys has been preserved (e.g. these have not been date shifted). Custom concept IDs are noted below for each survey version:

• COPE Survey May 2020 (2100000002)
  • • Open 5/7/20-5/29/20
• COPE Survey June 2020 (2100000003)
  • • Open 6/2/20-6/26/20
• COPE Survey July 2020 (2100000004)
  • • Open 7/7/20 - 9/25/20

Added the custom concept “None Indicated,” 2100000001, to the person table for participants who did not indicate a race, only an ethnicity, in the Basics survey

Added custom concept to generalize household size, collected in the Basics survey, for privacy methodology:

• For households >10 members: 2000000013
• For households with >5 household members under 18: 2000000012

Added new gender identity response option “Two-Spirit” to the Basics survey beginning in Fall 2019, but is generalized to “Not man only, not woman only, prefer not to answer, or skipped (2000000002) in the CDR”

Fixed improper branching logic where previously existed in surveys - suppressed answers to child (e.g. follow up) questions that should not have been displayed to participants

Fixed

Dropped PIDs that have no EHR or PPI data present

Changed

List of suppressed State_of_residence data has changed, based on some states and territories obtaining 200 or more participants; 

• states with under 200 participants are generalized to a custom concept_id to protect privacy
• also generalized when state doesn’t match the state of the HPO

Added

State_of_residence fields added to person table

Added

Response to sexual orientation question was changed from single-select to select all that apply

• ONLY “Straight, that is, not gay or lesbian” is generalized to the “Straight” orientation value 
• If someone selects “Straight, that is, not gay or lesbian” and a second selection, it will be generalized to “Non-straight orientation, prefer not to answer, or skipped” (2000000003)

Added

COVID-19-related EHR data are suppressed

Added

New questions on disability added to The Basics module; no new privacy methodology applied

Changed

Stabilized Research ID (RID) across CDR versions (starting with R2019Q4R3), allowing for longitudinal research

Fixed

Fixed issue with some survey answers not mapping correctly, causing these rows to be missing value_concept_id

Fixed

PIIBirthInformation_BirthDate removed

CDR Version/

Version Date

Type

Public Release Note

R2020Q4R2

11/10/2020

Fixed

Dropped rows with 0 source and standard concept_ids 

Fixed

Fixed heart beat unit standardization error that converted both units and values to “beats per minute” when only the unit needed to be changed to “minutes”

Fixed

Removed Physical Measurements height and weight from the height and weight cleaning algorithm

Type

Public Release Note

Known Issue

EHR data from EHR site 925 will be out of temporal alignment with other data types due to a source anomaly. Source data was date shifted by the site prior to and in addition to curation-imposed date shift, so EHR data will not match other data types for affected participants.

Known Issue

value_as_number translation in COPE (came in as string when it needs to be number)

Known Issue

Approx. ~4,000 participants do not have ExtraConsent_TodaysDate value due to an issue with data collection; participants DID sign consent, data are just missing this date value