COVID-19 CDC Data Analyses

Owned by Julia Skapik (Deactivated)
Last updated: Sept 16, 2021
2 min read

Denominator1: UDS patients or patients with a medic{al encounter in 2019 or beyond

Denominator2: Patients who received a COVID-19 related service (testing, vaccine, other screening for SDOH) without a medical visit or meeting UDS criteria


Risk:

  1. Demographics

    1. Race & Ethnicity

    2. Gender

    3. Age (categories)

    4. Location (Zip or Partial Zip/State)-- include state at a minimum

    5. SOGI

  2. SDOH

    1. Food Insecurity
    2. Housing Insecurity/Homelessness

Testing:

  1. Unique # of patients who had each following type of COVID-19 tests and their corresponding results
    1. PCR
    2. Antigen
    3. Antibody (Omit - non-diagnostic)
      1. IgG
      2. IgM
      3. Others
  2. Total # of unique patients tested by result for diagnostic tests: positive, negative, indeterminate
    1. Positive Test, Undiagnosed
    2. No Test, Diagnosed
    3. Negative Test, Diagnosed
  3. Unique # of patients tested with positive results (diagnostic only)
  4. Average number of tests per unique patient
  5. Antibody tests and results by unique patient: positive, negative, indeterminant (Omit, non-diagnostic)
  6. What is the percent of patients who had a positive Antigen test had a follow-up molecular/PCR test?
  7. What is the average time from a positive Antigen test result to a molecular/PCR report? 

Planned Next Analytics:

1) Determine risk factors that predict COVID infection

  • Look at proportion of patients with COVID diagnosis and see how many have also a positive test.
  • Look at number of patients who had a positive test but no recorded COVID diagnosis. 
  • See how many encounters patients in the positive test-no diagnosis had in the dataset.
  • Work with team to determine whether to include "positive test only" patients in the denominator or not based on amount of missing data for those patients.
  • Perform logistic regression to look at risk for COVID diagnosis based on demographics: age, location, race/ethnicity, number of comorbidities, 

Vaccination:

Number of Denominator1 who are vaccinated (unique patients):

  1. To Flu:
    1. At FQHC affiliated site
    2. All other flu vaccine history in 2020
  2. To COVID-19: 
    1. At FQHC affiliated site
    2. All other COVID-19 vaccine history in 2020

Number of Denominator2 patients who received vaccination with:

  1. Flu at the FQHC affiliated site
  2. COVID-19 at the FQHC affiliated site

Diagnoses:

  1. Number of patients with codes for COVID-19 exposure, suspected COVID, COVID-19+ diagnosis
    1. Look at how many COVID-19 diagnosed patients have a positive test
  2. Number of comorbidities per positive patients



Encounters: exclude Denominator2:

  1. Number of encounters per patient by week or month
  2. Number of encounters per COVID-19 + patient
  3. Encounters for Post-COVID

Outcomes:

  1. Post-COVID syndromes
    1. How many patients were diagnosed with PASC, MISC, Long COVID, Post-COVID syndromes?
      1. By month
  2. Death: How many patients with COVID-19 + were noted to have died 
  3. Hospitalizations
  4. Complications

Dear Confluence Users, If you need support for use of Atlassian tools, please contact informatics@nachc.com whether you have technical issues, need feature assistance, or simply have questions.