All of Us survey, data codebooks

 All of Us survey, data codebooks

https://docs.google.com/spreadsheets/d/1pODkE2bFN-kmVtYp89rtrJg7oXck4Fsex58237x47mA/edit?usp=sharing

pastbin

 https://pastebin.com/uBcFUXCA

1. import pandas as pd
2. dataset = %env WORKSPACE_CDR
3. query = """
4. SELECT
5. p.person_id AS person_id,
6. c.concept_name AS state_name
7. FROM `{dataset}.person` AS p
8. LEFT JOIN `{dataset}.concept` AS c ON p.state_of_residence_concept_id = c.concept_id
9. WHERE c.concept_name LIKE 'PII State: %'
10. """
11.  
12. state_df = pd.read_gbq(query.format(dataset = dataset))
13.  
14. state_df['state_of_residence'] = state_df['state_name'].str.replace('PII State: ', '')
15.  
16. state_df.head()
17. state_df.shape
18.  
19. homeless_state_df=state_df[state_df['person_id'].isin(homeless_respiratory_status['person_id'])]
20. homeless_state_df['state_of_residence'].value_counts()

All of us research platform, data explore for rural health research.

 All of us research platform, data explore for rural health research.

Zip3, observational table

Workspaces > Beginner Intro to AoU Data and the Workbench > Analysis >

00. Overview of Data Analysis Steps in AoU

In ‘test-state_data_v060523’, found sample on state, county, and zip3.

 

 

allofus, smoking study

 

https://academic.oup.com/jamia/advance-article/doi/10.1093/jamia/ocad205/7330649?utm_source=advanceaccess&utm_campaign=jamia&utm_medium=email&nbd=35144805721&nbd_source=campaigner&login=false

all of us training

https://allofus.nih.gov/about 

mission

https://support.researchallofus.org/hc/en-us/articles/14927774297620-The-new-VariantDataset-VDS-format-for-All-of-Us-short-read-WGS-data

genomic data

https://twitter.com/AllofUsCEO/status/1514996980661071879

CEO, Josh Danny, 

allofUs immigration status

 

Immigration status in AllofUs? 

culture change

change of food preference? 

 

Association of step counts over time with the risk of chronic disease in the All of Us Research Program

https://www.nature.com/articles/s41591-022-02012-w

AllOfUs location

 state location 

https://aousupporthelp.zendesk.com/hc/en-us/articles/4583333207956-Accessing-geolocation-data-

allofus research workbench log

 

https://docs.google.com/spreadsheets/d/1dsvJV8B7EXQj5EWa2XG-KAhs-l7FsQnyJSSFMstLF2U/edit#gid=225511499

https://aousupporthelp.zendesk.com/hc/en-us/articles/4614687617556-How-the-All-of-Us-Genomic-data-are-organized

https://aousupporthelp.zendesk.com/hc/en-us/categories/5942702296468-Working-with-Data

https://aousupporthelp.zendesk.com/hc/en-us/articles/360040452471-How-do-I-cite-the-Researcher-Workbench-in-my-grants-or-publications-

user support hub: submit ticket for questions. 

allofus research workbench

The 1 min summary? All of Us data are made available in a Curated Data Repository (CDR). Participants may contribute any combination of survey, physical measurement, and electronic health record data. Not all participants contribute all possible data types. Each unique piece of health data is given a unique identifier called a concept_id and organized into specific tables according to our Common Data Model. You can use these concept_ids to query the CDR and pull data on specific health topics relevant to your analysis. See the Researcher Workbench Support Hub section on Learning the Basics of the All of Us Dataset for more information.

What are concept sets?