For those that don\u2019t know the command line and cron this means \u201cat the top of the hour between 8am and 8pm open this url with the default browser\u201d<\/p>\n\n\n\n But just clicking around on the interactive dashboard didn\u2019t give me the information I wanted, so I dug deeper. On the dashboard, it had a link to the downloadable database that drove their chart.<\/p>\n\n\n\n There are various data files, basically CSV files that any spreadsheet can read, there for the taking.<\/p>\n\n\n\n So, I wrote the following program to pull what I wanted and filter it down to Texas data only. In this blog, those if statements are all one line.<\/p>\n\n\n\n #!\/bin\/zsh<\/strong><\/p>\n\n\n\n base=$HOME\/COVID-DATA<\/strong><\/p>\n\n\n\n mkdir $base 2> \/dev\/null<\/strong><\/p>\n\n\n\n find $base -ctime +4h -delete<\/strong><\/p>\n\n\n\n target=time_series_covid19_confirmed_US.csv<\/strong><\/p>\n\n\n\n if [[ !\u00a0 -e $base\/$target ]] ; then curl -o $base\/$target https:\/\/raw.githubusercontent.com\/CSSEGISandData\/COVID-19\/master\/csse_covid_19_data\/csse_covid_19_time_series\/$target ; else echo “exists”; fi<\/strong><\/p>\n\n\n\n echo “Dates,14,,,,,,,21,,,,,,,28,,,,April,,,,,,7,,,,,,,14,,,,,,,21″>$base\/Texas_confirmed.csv<\/strong><\/p>\n\n\n\n grep “,Texas,US,” <$base\/$target |cut -d , -f 6,66- >> $base\/Texas_confirmed.csv<\/strong><\/p>\n\n\n\n target=time_series_covid19_deaths_US.csv<\/strong><\/p>\n\n\n\n if [[ !\u00a0 -e $base\/$target ]] ; then curl -o $base\/$target https:\/\/raw.githubusercontent.com\/CSSEGISandData\/COVID-19\/master\/csse_covid_19_data\/csse_covid_19_time_series\/$target ; else echo “exists”; fi<\/strong><\/p>\n\n\n\n echo “Dates,14,,,,,,,21,,,,,,,28,,,,April,,,,,,7,,,,,,,14,,,,,,,21″>$base\/Texas_deaths.csv<\/strong><\/p>\n\n\n\n grep “,Texas,US,” <$base\/$target |cut -d , -f 6,67- >> $base\/Texas_deaths.csv<\/strong><\/p>\n<\/div><\/div>\n\n\n\n And I ran this program at 9pm everyday also using cron:<\/p>\n\n\n\n 0 21 * * * \/Users\/hmelton\/bin\/covid<\/strong><\/p>\n\n\n\n And now I had data I could work with with my spreadsheet. Every morning, I open up the COVID-DATA folder on my desktop and up pops a spread sheet with every county in Texas from March 14 to the current day, in alphabetical order. I sort the counties by the last column, with the current infections (or deaths in the case of the Texas_deaths spreadsheet) and them make my charts for the day.<\/p>\n\n\n\n My first chart plots the growth of the infection in the top twenty counties.\u00a0 This morning I noticed that Williamson County, where I live, had dropped out of the top twenty.\u00a0 That means that other, more rural counties are getting more infections.\u00a0 <\/p>\n\n\n\n That prompted me to make a stacked bar chart of how the counties compare.<\/p>\n\n\n\n In general, I vary which charts I make each day, depending on what I\u2019m interested in. I don\u2019t keep them, since I can always re-create them if necessary. I\u2019m sure there are more elegant tools than some shell scripts and cron to get what I need, but those work, and since it\u2019s just for my own eyes, those old tools are good enough.<\/p>\n","protected":false},"excerpt":{"rendered":" Strange times, and we all have different ways of coping with the strangeness. For several weeks now, I\u2019ve been taking a closer look at the Texas infection data. Since the beginning, I\u2019ve been putting up the John Hopkins dashboard on my secondary display, updated hourly automatically during my awake hours to keep myself from refreshing… Continue reading My Morning Routine (Plotting Covid-19)<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[548,547,549],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4t90x-Xe","_links":{"self":[{"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/posts\/3672"}],"collection":[{"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/comments?post=3672"}],"version-history":[{"count":3,"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/posts\/3672\/revisions"}],"predecessor-version":[{"id":3681,"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/posts\/3672\/revisions\/3681"}],"wp:attachment":[{"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/media?parent=3672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/categories?post=3672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/henrymelton.net\/2\/wp-json\/wp\/v2\/tags?post=3672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/henrymelton.net\/2\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-23-at-11.47.59-AM-2-1024x550.png\")
<\/figure><\/li><\/ul><\/figure>\n\n\n\n![\"\"](\"https:\/\/henrymelton.net\/2\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-23-at-12.30.07-PM-1-642x1024.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/henrymelton.net\/2\/wp-content\/uploads\/2020\/04\/Screen-Shot-2020-04-23-at-12.30.27-PM-946x1024.png\")
<\/figure>\n\n\n\n