Add BRFSS

[ramonawalls]

Need to add new variables from the BRFSS dataset at the county level in AZ.

A download of the data is available at https://docs.google.com/spreadsheets/d/1AgZk7ZNz1LezPq3XlgtcSUXy4HvciMM_/edit#gid=33910689

Need the following variables:
Under health outcomes category:

• Diagnosed diabetes among adults aged >=18 years
• Cancer (excluding skin cancer) among adults aged >=18 years
• Current asthma among adults aged >=18 years
• Obesity among adults aged >=18 years

Under health status category:

• Mental health not good for >=14 days among adults aged >=18 years

[ramonawalls]

Data source: https://chronicdata.cdc.gov/500-Cities-Places/PLACES-Local-Data-for-Better-Health-County-Data-20/swc5-untb/data

Original data include Crude prevalence and Age adjusted prevalence. Our dataset also includes both. Do we need both?

The tab for "ALL" (brfss_all.csv) includes all variables, including ones we aren't using. We only need to focus on the five variables mentioned above. The full datasets will be stored in CyVerse.

All variables are % of population.

[ramonawalls]

Can add five new classes to se_data_classes.csv

Parent class: UO:0000187 (percent)
Add subclass axiom for 'is about' the specific condition
Unit: percent of people in county

The range of 'is about' is entity, so we could use diseases (MONDO) here, even though the other percents are all about qualities. Therefore, I've used HPO classes

Diabetes: HP:0000819 (diabetes mellitus)
Cancer: HP:0002664 (neoplasm)
Asthma: HP:0002099 (asthma)
Obesity: HP:0001513 (obesity)
Poor mental health: HP:0033667 (diminished mental health)

@alma - Can you please check if the HP classes I chose will work for your study?

[ramonawalls]

For cancer, add XREF to https://www.cdc.gov/places/measure-definitions/health-outcomes/index.html#cancer
and Malignant neoplasms (ICD-10: C00-C97)

[ramonawalls]

Obesity definitions:

They also define obesity as "Respondents aged ≥18 years who have a body mass index (BMI) ≥30.0 kg/m² calculated from self-reported weight and height." So not sure if there is another definition that is more aligned with that rather than "Accumulation of substantial excess body fat."

Since it is more specific than HPO, we should create a subclass.