Systematically link to Open Data Portal (from chart information and tracker boxes)

[mediajunkie]

Still to do:

• [x] review gaps and assumptions in Mchael's spreadsheet
• [ ] Explore rationale for our partially duplicative data dictionary entries

Needs some exploration.

Here is how SF does it.

[abquirarte]

FWIW- I made this ask :)

Currently we bury links to the open data versions of our data dashboards/charts. As best practice, I'd like to have a link to the open data of each viz close to the visualization.

[mediajunkie]

@m-sullivan7 let's discuss how to implement this across all the data page and trackers.

• If it requires design beyond content design we can loop in Adam
• If it requires code implementation we'll get eng involved

[m-sullivan7]

Off the top of my head, this may be as simple as putting a link in the Chart information drawers. I look forward to talking about it!

[mediajunkie]

That may well do the trick, and we could mock it up for discussion and review.

For the sake of argument let's consider how we might make the affordance visible by default without additional exploration required, as a further constraint.

[m-sullivan7]

I'd benefit from some coordination before I mock something up to:

• Identify the charts affected (I think this is every chart?)
• The data source to link to from that chart
• What you mean by "affordance"--new term for me!

[abquirarte]

For me: I want to make sure any dashboard/data viz on covid19 that has open data posted has the link to the open dataset next to the visualization. This could start with a link on the "data notes" accordion, but would prefer something more visible if we can figure something out.

This means we'll have to inventory our data vizes and work with CDPH open data team to see which ones also post open data.

This addressed needs of users that are more data savy. Academics, journalists, data scientists.

Thanks team! Cc @mediajunkie @m-sullivan7

[m-sullivan7]

Here's a spreadsheet of all our charts (plus a question about whether to include one map) with my best guesses as to what data source backs each up. Where I didn't have a good guess I left it blank.

@mediajunkie If you can fill any gaps and/or confirm my guesses, I'd love your assistance!

[mediajunkie]

on it!

On Fri, Oct 8, 2021 at 1:25 PM Michael Sullivan @.***> wrote:

Here's a spreadsheet of all our charts https://docs.google.com/spreadsheets/d/1pCYn_COc16VLmJmex9AF3eCLvsa_iAaOm5EuSkWAzng/edit?usp=sharing (plus a question about whether to include one map) with my best guesses as to what data source backs each up. Where I didn't have a good guess I left it blank.

@mediajunkie https://github.com/mediajunkie If you can fill any gaps and/or confirm my guesses, I'd love your assistance!

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cagov/covid19/issues/5353#issuecomment-939096511, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAYT54UPVGSZZLNBDYQ55KDUF5HR3ANCNFSM5ESNVAXQ .

-- Christian Crumlish Product Manager | Office of Digital Innovation Digital Crisis Standard https://github.com/cagov/covid19/wiki/Crisis-Standard - covid19.ca.gov 415-672-5759 | @.***

Follow us: web https://alpha.ca.gov/ | blog https://medium.com/cadotgov | twitter https://twitter.com/cadotgov

[m-sullivan7]

Here's a list of all the charts/tracker boxes we can't clearly identify an Open Data Portal source to back up between @mediajunkie and me. We need to provide this list to our data stewards so they can help us identify (or, if needed, establish) data sources to link to.

State dashboard

• Positivity rate in California

Health equity

• Latino death rate trackerbox (could be derived from COVID-19 Time-Series Metrics by County and State, but we aren't sure)
• Pacific islanders case rate trackerbox (could be derived from COVID-19 Time-Series Metrics by County and State, but we aren't sure)
• Black death rate trackerbox (could be derived from COVID-19 Time-Series Metrics by County and State, but we aren't sure)
• <$40K median income case rate trackerbox
• COVID-19 health equity metric
• Reporting by race and ethnicity/sexual orientation/gender identity in California
• Community case rate by median annual household income bracket
• Community case rate by amount of crowded housing
• Community case rate by health care access

[m-sullivan7]

Since we have data sources for everything on Vaccination progress data, I used that one to make a Google Doc mock up what links to data would look like.

• For a v1, I think our best option is to use a regular text link. I propose using the small-text class to make the link less obtrusive and take up less room.
• Responding to Angie's desire to have these links visible, I propose placing them outside Chart information drawers where they exist.
• To avoid a SiteImprove flag, each link will have unique link text. This makes the links more wordy, but also clearly states what chart the source data is for. Using small text will help with the longer chart titles.

[m-sullivan7]

Vaccination progress data has been published with data sources. I will alert engineers to look at the column width of the last three columns where it looks like the data source note extends to the left of the chart.

I will work on state dashboard and health equity tomorrow.

[abquirarte]

Thank you @m-sullivan7! 😄

[m-sullivan7]

@mediajunkie

Thanks to CDPH publishing the health equity Open Data Portal page, we can now add source data and Data and tools links to our pages. Here are Google Docs with those changes:

• Health equity revisions
• Data and tools - based on how the ODP data is listed, it seemed to make the most sense to create a separate accordion for each chart

I'll ask a potentially radical question: do we need data dictionaries on covid19.ca.gov if we're providing clear source data links? These links go to the landing page for each data set, which includes a clear link to the data dictionary for each data set. In fact, it's easier for people to find these definitions by following those source links than by going to a separate page and having to flip back and forth between charts and figure out for themselves what goes with what.

Perhaps good reasons for hosting this data on covid19.ca.gov still exist, but my outsider brain flagged this as something that didn't make initial sense. This would reduce duplicated content between our site and the Open Data Portal and reduce the content load on our site.

[mediajunkie]

I wonder this as well. Let me do two things:

• review Hannah’s docs that may have captured the reasons for doing this
• discuss with Angie

Feel free to do the latter yourself in the meantime if so inclined!

On Mon, Oct 25, 2021 at 4:51 PM Michael Sullivan @.***> wrote:

@mediajunkie https://github.com/mediajunkie

Thanks to CDPH publishing the health equity Open Data Portal page https://data.chhs.ca.gov/dataset/covid-19-equity-metrics, we can now add source data and Data and tools https://covid19.ca.gov/data-and-tools/ links to our pages. Here are Google Docs with those changes:

• Health equity revisions https://docs.google.com/document/d/16I_xWwfmLVpQ7Ma79Oal71OaXDMtSDaw4YLhCnkU_9Q/edit#
• Data and tools https://docs.google.com/document/d/1O1Qb-qGqQ3dIAefxteaEO_cOU3VilkZjdh41PlxhAZ8/edit#
• based on how the ODP data is listed, it seemed to make the most sense to create a separate accordion for each chart

I'll ask a potentially radical question: do we need data dictionaries on covid19.ca.gov if we're providing clear source data links? These links go to the landing page for each data set, which includes a clear link to the data dictionary for each data set. In fact, it's easier for people to find these definitions by following those source links than by going to a separate page and having to flip back and forth between charts and figure out for themselves what goes with what.

Perhaps good reasons for hosting this data on covid19.ca.gov still exist, but my outsider brain flagged this as something that didn't make initial sense. This would reduce duplicated content between our site and the Open Data Portal and reduce the content load on our site.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cagov/covid19/issues/5353#issuecomment-951320035, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAYT54QTYBI4FETZUC3BNRLUIW7NFANCNFSM5ESNVAXQ .

-- Christian Crumlish Product Manager | Office of Digital Innovation Digital Crisis Standard https://github.com/cagov/covid19/wiki/Crisis-Standard - covid19.ca.gov 415-672-5759 | @.***

Follow us: web https://alpha.ca.gov/ | blog https://medium.com/cadotgov | twitter https://twitter.com/cadotgov

[m-sullivan7]

I discovered that https://covid19.ca.gov/vaccination-progress-data/#overview has a link in the Tableau chart to https://covid19.ca.gov/data-and-tools/#COVID-19-VACCINE-DATA. It's the only Tableau chart that links to our Data and tools page. Perhaps we had links in old Tableau charts we've since replaced with D3 charts. That would explain why we have anchor links for each accordion.

I can't recall if the data dictionaries predate Hannah. Here's the archive folder of content drafts. The oldest useful draft is from March 2021. Don't think there's much that's helpful in there, but thought I'd share all the same. :smile:

[mediajunkie]

please do make the blocked changes above. I'm afraid the "radical" question distracted me from the straightforward one. (More on that separately.)

[m-sullivan7]

Data and tools is live. Jim is investigating getting a couple of links in the health equity page in the right place. Content is mostly staged and ready to go.

[m-sullivan7]

Health equity is live too now.

That leaves just one source data link missing @mediajunkie: the Positivity rate in California/county chart. I suspect that it's the same data as the neighboring chart, Total tests in California/county. If they use the same source data, it's an easy content fix to make the existing link cover both charts.

Do we want to continue the bigger Data and tools discussion in this issue or create a new issue so this issue can be closed (since the original purpose will be fulfilled)?

[mediajunkie]

It does appear that the same source that gives the total number of tests per county also gives the number of positive tests, so maybe the question to confirm with @jbum is whether that ratio is the source of the positivity rate we report, or if it we have another source that is documented elsewhere in the ODP.

[m-sullivan7]

Thanks for the initial look! I'll wait for final confirmation from @jbum before preparing a quick edit for state dashboard.

[m-sullivan7]

@mediajunkie I confirmed with Jim that the charts use the same source data. I drafted this content update to cover off our last piece of source data documentation. OK to publish?

I also updated our spreadsheet with this last piece.

[mediajunkie]

Yes, please!

[m-sullivan7]

The final source data link is on state dashboard. Do we want to have the Data and tools overhaul on this ticket or will we close this one and move that to a new ticket?

[mediajunkie]

new ticket, in backlog -- Christian Crumlish Product Manager | Office of Digital Innovation Digital Crisis Standard https://github.com/cagov/covid19/wiki/Crisis-Standard - covid19.ca.gov 415-672-5759 | @.***

Follow us: web https://alpha.ca.gov/ | blog https://medium.com/cadotgov | twitter https://twitter.com/cadotgov