Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Stitching Across Data Seams - SLU

Stitching Across Data Seams - SLU

C07da636fa8428f90daa78b89c90bafb?s=128

Christopher Prener

March 08, 2021
Tweet

Transcript

  1. Stitching Across Data Seams Tracking COVID-19 Disparities in Missouri Christopher

    Prener, Ph.D. Assistant Professor of Sociology, SLU 03.08.2021
  2. Tracking COVID-19 Disparities in Missouri Christopher Prener, Ph.D. Assistant Professor

    of Sociology, SLU 03.08.2021 Stitching Across Data Seams
  3. Acknowledgments Saint Louis University Department of Computer Science Especially Chair

    Michael Goldwasser, PhD and David Ferry, PhD Student Contributors: Alvin Do, Metta Pham, and Eric Quach University Honors Program Robert Pampel, PhD
  4. AGENDA 1. Preface 2. How can the public find information

    on COVID? 3. What is wrong with this arrangement for COVID data? 4. What does the sewing kit look like for my COVID work? 5. What COIVD disparities exist in Missouri and St. Louis? 6. Discussion: Why are there issues with vaccination access in Missouri and globally? How can we redesign the vaccination system to increase equity? SAINT LOUIS UNIVERSITY | ST. LOUIS, MO | 03.08.2021
  5. ▸ Medical and urban sociologist with an interest in spatial

    and computational methods ▸ Affiliations: • Core Faculty, SLU’s Advanced HEAlth Data Research Institute • SLU’s Institute for Healing Justice and Equity • Northeastern University’s Institute for Health Equity and Social Justice Research 1. PREFACE “HI, I’M CHRIS”
  6. ▸ Medical and urban sociologist with an interest in spatial

    and computational methods ▸ Teaching: • SOC 1120 - Introduction to Sociology (Diversity and Health) • I always offer an honors seminar alongside this class - we meet three times to go in-depth on a topic; also focus on op-eds • SOC 4650 - Introduction to GIS 1. PREFACE “HI, I’M CHRIS”
  7. 1. PREFACE INTELLECTUAL TRAJECTORY

  8. How can the public find information on COVID? ?

  9. Everybody's got a dashboard these days…

  10. NEWS SITES

  11. MISSOURI DHSS

  12. ST. LOUIS COUNTY PUBLIC HEALTH

  13. What is wrong with this arrangement for COVID data? ?

  14. DIFFERENT TOOLS Dashboards are being powered by a number of

    different commercial tools, including ESRI, Microsoft, Tableau, and in-house solutions.
  15. DIFFERENT TOOLS Dashboards are being powered by a number of

    different commercial tools, including ESRI, Microsoft, Tableau, and in-house solutions.
  16. DIFFERENT TOOLS Dashboards are being powered by a number of

    different commercial tools, including ESRI, Microsoft, Tableau, and in-house solutions.
  17. DIFFERENT TOOLS Dashboards are being powered by a number of

    different commercial tools, including ESRI, Microsoft, Tableau, and in-house solutions.
  18. 3. DATA SEAMS DATA ARE OFTEN POORLY VISUALIZED Basic rules,

    like using per capita rates, are often ignored.
  19. DASHBOARDS ≠ OPEN DATA Few dashboards provide easy access to

    underlying data, though it is there if you know where to look. There is also little to no standardization.
  20. DASHBOARDS ≠ OPEN DATA Few dashboards provide easy access to

    underlying data, though it is there if you know where to look. There is also little to no standardization.
  21. Similar fabric panels with jagged edges that we need to

    stitch together. Data Seams.
  22. What does the sewing kit look like for my COVID

    work? ?
  23. Navigating these seems requires an array of computational tools for

    scraping and standardizing various jurisdictions’ data.
  24. 4. THE SEWING KIT PULLING THE FABRIC TOGETHER New York

    Times COVID-19 Database (via GitHub) County Public Health Zip Code Data (via scrapers+API calls) Missouri COVID Tracking Database State of Missouri and Illinois (via scrapers) CMS Nursing Home Data (via API) HHS Hospitalization Data (via API) Census Bureau (via API)
  25. 4. THE SEWING KIT PULLING THE FABRIC TOGETHER

  26. THE TWEET THAT LAUNCHED… MANY MORE TWEETS

  27. None
  28. None
  29. None
  30. What COVID disparities exist in Missouri and St. Louis? ?

  31. None
  32. None
  33. FOR THE PROBLEM OF THE TWENTIETH CENTURY IS THE PROBLEM

    OF COLOR LINE W.E.B. Du Bois The Souls of Black Folk (1903) Wikimedia Commons
  34. None
  35. None
  36. None
  37. None
  38. None
  39. None
  40. None
  41. None
  42. None
  43. Why are there vaccination disparities in Missouri and globally? ?

  44. How could we redesign the vaccination system to increase equity?

    ?
  45. 6. FINAL THOUGHTS REFLECTIONS ▸ Research, data, and communication are

    not the first priority: ▸ COVID-19 data sources suffer from a lack of standardization, often cannot be accessed. ▸ COVID-19 “dashboards” are all the rage, but there are frequent issues across jurisdictions with how similar metrics are being communicated. ▸ This has increased demand for my COVID tracking project. ▸ Iterating on analyses is not something we always get to do, but it is tremendously gratifying. ▸ Open data and science are also about community and communication.
  46. Slides available via SpeakerDeck Follow on the web: speakerdeck.com/chrisprener/ stitching-across-data-seams-slu

    Raw data, code available via GitHub github.com/slu-openGIS/ MO_HEALTH_Covid_Tracking chris.prener@slu.edu chris-prener.github.io LEARN MORE THANKS FOR COMING! @chrisprener Visualization code available via GitHub github.com/slu-openGIS/ covid_daily_viz slu-opengis.github.io/ covid_daily_viz/ chrisprener.substack.com