Add county mobility data section that leaves viewers with a clear understanding of the mobility impacts of distancing efforts/quarantines and then shows how quickly/slowly people have responded to the gradual re-opening of the economy.

This analysis should include include:

1. graphically representing rates of mobility change versus a baseline position on a daily basis (i.e., April 26, 2020 had 40% less movement than April 26, 2019; April 27 had 35% less movement than April 27, 2019)

2. breakdown data to show where people are going/not going (e.g., 40% decline in visiting restaurants on April 26 changed to 20% decline in visiting restaurants on May 6). See charts below from Google.

On County Explorer page, if a county is selected, you can't hover over other counties in that Trauma Service Area because the fill option in leaflet is layered at the front, which blocks any sort of "OnHover" events that trigger the tooltip. While fixing the layering issue would be ideal, perhaps switching to a bolder outline of the TSAs more prominent is the best immediate solution.

One piece of feedback we received was that the Unemployment rate for March 1 caught people off guard, because most other data is recent. To reduce this surprise, help people understand the schedules for which data updates are received.

Link for the Data is Here. Will need to check on licensing the data.

Matt - Our team asked about adding info to flag which counties have shown higher than average case growth in the past week. Maybe something like other maps on the 2036 website. For May 5-May 12, Texas overall case growth was about 23%. There are 41 counties whose case growth was more than double that amount (46% growth in a week) and of those, 15 counties had fewer than 5 cases on 5/12. Maybe a map that shows these “hot spots” for the prior week, but with a distinction between counties with 5+ cases vs. fewer than? (Another option – look at this in combination with total cases per 100K. There could be two maps – one with last week’s growth, and one that shows cases per capita. Some of these high growth counties for the past week are still below the state’s average # cases/1000.)

Using TWC data, add to the county explorer tab the total job losses since March 21 for each county. This should include

• Data point: total jobs lost
• Data point: total jobs lost as a percentage of labor market
• Graph: county-level job losses/gains by week (line or bar chart)
• Graph: county-level job losses/gains by sector (bar chart)

While the Google mobility and SafeGraph data is more important, we also have the option of linking into the data that powers DriveTexas.org. While I'm not immediately aware of what we would learn from this source vs. Google/SafeGraph, it is worth pursuing (a) to establish a relationship that will be longer-lasting and (b) they might collect data points we don't even know about yet. I could imagine them having data that helps project motor fuels tax revenues.

Dr. Lazar noted that https://over-haul.com/ has data that could help us determine freight movements and other economic activity. This would be great to incorporate into version 2.0 but we should definitely try to have it by 3.0.

Stakeholders have requested that we track excess mortality that has occurred during this COVID period. CDC data for Texas is readily available: https://www.cdc.gov/nchs/nvss/vsrr/covid19/excess_deaths.htm

In playing with the CDC data, my initial reaction is that we appear to be having a greater number of excess deaths caused by non-COVID issues.

DSHS has requested that we visualize a multi-criteria map of Texas. The way I envision the vague direction is as follows:

• Start with a state map with toggle boxes to the side
• label the boxes things like "Tier 1 county" "Tier 2 county" "Growth rate above 5%" etc
• as people click those boxes, they'll see which counties hit the various criteria

This would need to make sense in conjunction with the state trend map, issue #34, which I still think is important.

Add statewide mobility data section that leaves viewers with a clear understanding of the mobility impacts of distancing efforts/quarantines and then show how quickly/slowly people respond to the gradual re-opening of the economy.

This analysis should include include
(a) graphically representing overall rate of mobility change versus a baseline position on a daily basis (i.e., April 26, 2020 had 40% less movement than April 26, 2019);

(b) using a state map with a time-elapse function to show where people were more/less active at different times. This would operate like the time-elapse infection map in one of the other issues -- basically, you click play at the bottom of a map of Texas and see the counties dip into varying depths of blue due to movement reduction, then as we reach May, it starts to lighten and may reach baseline (white) or increased (red) in certain pockets. This would use daily data, starting around March 1.

(c) breakdown data to show where people are going (e.g., 40% decline in visiting restaurants on April 26 changed to 20% decline in visiting restaurants on May 6) like what google

has.

Will need to link MSA's to Counties using the NCHS Classification Dataset, which is found in the COVID Workbook.Rmd File. Homebase data feeds are also in this workbook.

On the back-end, the data has already been cut to report on incidence and fatalities by Race, Age, and Gender at the statewide level. We now just need to draw the charts. My initial ideas were to start integrating some horizontally stacked bar charts to visualize these. Something that would look a lot like the charts below. We may do pie charts, but that may feel bulky in our current layout and pie charts have a lot of controversy around them that I'd like to avoid.

The fitbounds function in the leaflet code (found inside of COVID Workbook.Rmd) needs to be adjusted so the Texas County map fits in it's container across desktop platforms and mobile platforms. Currently, it is not fitting properly in the container on mobile and some tablets.

iPhone Example

iPad Portrait Example

Because the Homebase data are best estimates based off of a sample of companies they work with in Texas, we need to make sure and communicate that these figures are best estimates of small business dynamics.

TWC's childcare capacity data will be an important metric for tracking the ability of parents to return to the workforce. This should be linked to the economic data portion of the state explorer and should be included in the county explorer if TWC data is sufficiently granular.

Let's try to get this into 2.0, but it can be pushed to 3.0 if necessary.

Request of Dell Med

In re-opening tab, remove county-level ILI/CLI tab. Consider replacing with text that says the state is no longer receiving data from a sufficient number of locations to ensure geographic/statistical validity.

Request from Dell Med

Replace it with something that says, "Pulling the latest data and updating our charts."

Under the Current Testing Section, test positivity is mislabeled as "vent_avail_rate"

@mathisonian did we ever resolve this metric? I think it was the Lone Ranger that didn't get nailed down during that first big lift on enhanced COVID-19 estimates.

We have a donor request that we add the ability to compare two counties side-by-side. This will involve creating a new tab on the navigation panel to a "Compare Counties" window, as well as whatever it takes to actually compare the counties.

Link to info and app: https://www.safegraph.com/blog/safegraph-provides-cdc-fed-and-1000-organizations-with-data-to-fight-the-covid-19-crisis

For immediate action, change text to "Recovered (Est.)" and "Active (Est.)"

For long term, we should have a non-obtrusive button someone can click that redirects them to our data page with a more fulsome explanation of the data.

Need better explanation of the tool's purpose and data sources.

We need to think through a "what has happened since May 1" explainer.

Here are my initial thoughts on what people will find helpful:

• by county, what has happened to the "daily new cases" trend line (potentially with 7-day smoothing to reflect DSHS calculations)
• compare "tier one" county trends (per 100,000) to "tier two" county trends (per 100,000)
• show google mobility data per county, comparing rates of movement 1 & 2 weeks prior to May 1, with 1 & 2 weeks after May 1
• show homebase "business opened" statewide data in a way that estimates increased business activity. For the explainer, we should try to figure out how many of the sample businesses are in Tier 1 counties (my guess is almost all, if not 100%)

On most pages, the disclaimer language sits quietly at the bottom of the page. But on the reopening tab, once you scroll to the bottom of the page, the disclaimer language appears and won't leave as you scroll back up. It ends up taking up a good portion of the screen.

Statewide

• Tests Per 100,000
• Available Ventilators Per COVID-19 Case
• Available ICU Beds Per COVID-19 Case
• Case Growth Rate
• Doubling Every X days
• 1 and 7-day rates of change for cumulative cases, daily new cases, daily new deaths, and daily new hospitalized
• Positive/Negative Testing. Current and TS.

County-Level Metrics

• Crosswalk the NCHS and Trauma Service Area Data.
• Integrate DSHS Tests Per County Data
• Tests Per 100,000
• Available Ventilators Per COVID-19 Case
• Available ICU Beds Per COVID-19 Case
• Case Growth Rate
• Doubling Every X days
• 1 and 7-day rates of change for cumulative cases, daily new cases, daily new deaths, and daily new hospitalized
• Positive/Negative Testing. Current and TS. (If we can get comprehensive data on testing at the county level. To my knowledge, COVID-tracking only produces this at a statewide-level).

Work with TCEQ to identify air quality measures that can be depicted either in chart or over a Texas map to determine whether COVID has impacted the state's air quality as traffic has reduced.

https://files.nc.gov/ncdhhs/documents/files/covid-19/Weekly-COVID19-Ongoing-Outbreaks.pdf
NYTimes has data on clusters 50+, which shows many in TX - jails/prisons, LTC facilities, meat packing plants.

Add All Credits, Acknowledgement, and Required Licensing Language

For both the landing page, the "Reopening Analysis" site, and both of the profiles, we need to optimize css for mobile as much as possible. Right now, when pages are loaded, it's like a massive text vomit of bold Montserrat that is overwhelming. Currently, a third of users access the site on mobile, but we haven't really launched, so over time mobile usage will likely increase.

For Version 2.5 (the narrative to quickly follow 2.0), we should add a state map that has a time-elapse function (click play or drag a slider at the bottom) and shows case per 100,000 trends for every county over the past 2 months (using daily intervals of the 7-day rolling average for daily new cases). What I'm thinking, basically, is an interactive version of this, but using 7-day averages rather than weekly data:

It would need to be structured to automatically update daily.

Request of state leaders to add "Active Cases" to the Statewide/County profiles, alongside cumulative cases, deaths, and recovered.

When you click on "county data" on navigation window, it sometimes goes to middle of county page or bottom, and not the top. Forces user to pull the page down in order to see the content.

We need to reach out to Google and/or read the terms of use they've published for their COVID Mobility data to see if they're okay with us integrating their data.

The goal here would be that when you click on "state explorer" or "county explorer," three options drop down: health data, economic data, and mobility data. When you click on economic data or mobility data, you jump to that portion of the explorer page.

((As of May 2, the data does not exist to do this))

Many stakeholders have requested that we find a way to show how much of an outbreak is tied to an isolated event, such as a nursing home or meatpacking plant. The idea is to differentiate true community spread events from concentrated super-spread events.

Request of Dell Med

I think all the data to do this is available here: https://rt.live/