katcorr
commented
3 years ago Shiny App → Blog Post brainstorming April 2021 PUG 5: Alison, Caroline, Sabrina (Food and PUG Administration)
Update 1: Your Plan (checkpoint) (1) We plan to continue working with data from our Shiny App for this final blog project. (a) When we made our Shiny App the Kaiser Family Foundation had only published two sets of data regarding vaccine distribution by race and ethnicity, which were two weeks apart. They are now publishing this data weekly so we would like to add a time component to our existing visualizations to see how patterns may have changed over time, especially following April 19th when all adults in the US became eligible for the Covid-19 vaccine. We have collected this data for the following release dates: March 1, March 15, March 29, April 5, April 12, April 19, April 26. We anticipate more data being published before our final blog post is due so that we can show at least two full months of vaccine distribution. (b) We would also like to consider adding data regarding the public’s sentiments towards the vaccine over time. The Kaiser Family Foundation presents this by race and ethnicity as determined by monthly surveys. They only present data for 3 groups (White, Black, Hispanic) so we will look to see if other websites present more complete data. (c) To get more practice with spatial data we hope to look at some states at the county level. We will aim to look at a few (?) states that had Covid hotspots at some time during the pandemic, as long as they report racial and ethnic vaccine distribution data at the country level. We could consider presenting this information with data on socioeconomic measures (average income per county) or Covid-19 health outcomes (number of deaths or cases per county) (d) Overall we each made comments about how to improve our individual components of the Shiny App so we hope to address these changes for our blog post (2) We imagine our final product will include a published Shiny App so that our visualizations are still interactive while also including more text to explain the patterns that our visualizations demonstrate. (3) Checkpoints (a) Update 1: Thursday 4/29 -- submit update, find the datasets we want to export and wrangle for our blog post (i) Alison: a few states racial/ethnic vaccine distribution at the county level (NY, Florida, Michigan … Arizona, California, Texas) 1) NY - no data available to download but can web-scrape this and/or this. NYT has something (only includes NYC) but the data isn’t in their github 2) Florida - vaccination data for race in each county only available via pdf 3) Michigan doesn’t have data by race or ethnicity (publicly accessible) for county level - only state level. Dashboard but here information for one county 4) Arizona - data dashboard but no download option unless we find way to webscrape - only has 15 counties 5) California 6) Texas (main dashboard) and by race -- TX has 254 counties (ii) Caroline: sentiment towards Covid19 by race and ethnicity? And cases or deaths by race/ethnicity (iii) Sabrina: KFF dataset, what dates are available? How do we include the time aspect (row, column)? → March 1 - April 26th, exported raw files to github folder to wrangle fo next checkpoint, will save date as a column
(b) Update 2: Tuesday 5/4 -- completed dataset (i) Everyone wrangles their dataset and we combine them to be used for our visualizations (c) Clarify which visualizations we will be making by Thursday ⅚ (i) Attempt to make the visualizations (d) Update 3: Tuesday 5/11 -- progress on shiny app (e) Presentation: Tuesday 5/18 (f) Final blog post: Wednesday 5/19
Ways to expand on our individual components of the Shiny App …
Overall
- Add credits somewhere (link to KFF data, CDC data, etc), add names somewhere
- Can we have some summary that shows how many states are above share or below share for each group? (... vaccine distributions by demographic -- at a glance)
- Assign the demographic metric values to a number (1 = extremely below share, 5 = extremely above share) -- find average for each state/group? Hexbin Map
- Allow users to hover over a hexagon (state) to see the actual demographic metric
- More interactivity? Timeline of data on March 1st, March 15th, March 29th, etc. … time series ~Ayo’s group
- Add KFF messaging about interest in/hesitations around vaccine by race/ethnicity, or link to specific articles about each demographic group?
- See if any states’ vaccine rollout prioritized different groups
- VT, for example, explicitly made minorities eligible for a vaccine before the general (adult) population … short term advantage (April 8th through 19th)
- https://khn.org/news/article/vermont-gives-blacks-and-other-minority-residents-vaccine-priority/
- Add data on what proportion of a state’s cases or deaths have been in each demographic group Scatterplot
- Add something to show the range of “proportionate share” for the demographic metric? (or show all ranges, 5 total) Table
- Make it so that the reset button clears the whole main panel (right now the button clears the select portions but the previous table stays there)
- Also want to make it so that the state stays regardless - right now you can actually delete the state column so i want to make it so that it is permanent.
- Add in the sidebar the definitions of our metric and what something like White Vaccine means
- Including dates on the data? And including covid cases?
- Might be too much but adding personalization with CSS?
- SABRINA - is there a way to show aggregate data for the whole country or a given region?
aortizdimas21
sabrinatrombetta
PUG5_shiny-->blog post brainstorming.docx