Create a new version of paste:

#!/bin/bash
# New version: https://github.com/Fabian42/bash_scripts/blob/main/corona.sh

# Feedback: fabianroeling@googlemail.com
# maybe TODO for reliability & less effort: translate into Google Sheets script?

worldometers(){
 # $1 is the number of leading rows to remove for alignment of all tables on 2020-05-25
 # $2 is the series name to be searched
 # find series name on website, get number list ("data"), remove prefix, remove suffix, "null"→"0", negatives→0, split on commas, align to 2020-05-25
 echo -n "$page" | grep -im 1 --after-context=5 "name: '$2'" | grep "data" | sed -E "s/ *data\\: \\[//" | sed -E "s/\\] *\\} *\\]? *\\,? *\\{? *//" | sed -E "s/null/0/g" | sed -E "s/\\-[0-9]+/0/g" | sed -E "s/\\,/\\n/g" | tail -n +$1
}

### START
# open sheet
(firefox "docs.google.com/spreadsheets/d/1uDTghO_ZYBs5nfs2kDc0Ms6e9bbx7clx_QgkWii7OMY" &> /dev/null & disown)

# print old state in case something goes wrong
cat ~/misc/corona_storage
echo

# Hannover cases and deaths, Lehrte cases and new (first because of highest probability of failure)
# This breaks if 20 or more articles were published today after the Corona update. I could fix that, but it's extremely unlikely. Changes to the website break stuff way more often.
# In case of a missed day: Replace »$(date "+%Y\\/%m\\/%d")« with e.g. »2021\\/03\\/29«
links=$(wget --no-check-certificate -qO - "www.altkreisblitz.de/region-hannover" | grep -E "<div class\\=\\\"news\\-list\\-item\\-title\\\"><h2><a href\\=\\\"https\\:\\/\\/www\\.altkreisblitz\\.de\\/aktuelles\\/datum\\/$(date "+%Y\\/%m\\/%d")" | grep -Eo "https[^\\\"]+")
found=0
for link in $links; do # $links not quoted, because that makes it only one long string
 page=$(wget -qO - "$link" | sed -E "s/\\r\\n?/\\n/g")
 # find HTML line with current cases table, remove everything before title (might include another table), take top value (yesterday), remove date
 temp=$(echo -n "$page" | grep --after-context=1 -Ee "Aktuell( |\\&nbsp\\;)+*Infizierte.*" -e "Aktuell( |\\&nbsp\\;)+registrierte( |\\&nbsp\\;)+Infizierte.*" | sed -E "s/.*Aktuell( |\\&nbsp\\;)+//" | grep -Eo "[0-9]+\\.[0-9]+\\.[0-9]*\\:( |\\&nbsp\\;)+[0-9\\.]+" | head -n 1 | sed -E "s/[0-9]+\\.[0-9]+\\.[0-9]*\\:( |\\&nbsp\\;)+//" | sed -E "s/\\.//")
 if [[ "$temp" != "" ]]; then
  cases_hannover="$temp"
  temp=""
 fi
 # find new cases sentence, extract number, convert words into numbers
 # They keep finding new ways to break my script, dammit. Who knows what they'll do for 0. This code used to look so clean…
 temp=$(echo -n "$page" | grep -Eom 1 "Menschen( |\&nbsp\;)+registriert\\,( |\&nbsp\;)+die( |\&nbsp\;)+sich( |\&nbsp\;)+in( |\&nbsp\;)+der( |\&nbsp\;)+Region( |\&nbsp\;)+mit( |\&nbsp\;)+dem( |\&nbsp\;)+Coronavirus( |\&nbsp\;)+infiziert( |\&nbsp\;)+haben\\.( |\&nbsp\;)+Das( |\&nbsp\;)+(sind|ist)( |\&nbsp\;)+[0-9a-zöü\\.]+( |\&nbsp\;)+(Fälle|Fall)( |\&nbsp\;)+mehr( |\&nbsp\;)+als" | sed -E "s/Menschen( |\&nbsp\;)+registriert\\,( |\&nbsp\;)+die( |\&nbsp\;)+sich( |\&nbsp\;)+in( |\&nbsp\;)+der( |\&nbsp\;)+Region( |\&nbsp\;)+mit( |\&nbsp\;)+dem( |\&nbsp\;)+Coronavirus( |\&nbsp\;)+infiziert( |\&nbsp\;)+haben\\.( |\&nbsp\;)+Das( |\&nbsp\;)+(sind|ist)( |\&nbsp\;)+//" | sed -E "s/( |\&nbsp\;)+(Fälle|Fall)( |\&nbsp\;)+mehr( |\&nbsp\;)+als//" | sed -E "s/\\.//" | sed -E "s/zwei/2/" | sed -E "s/drei/3/" | sed -E "s/vier/4/" | sed -E "s/fünf/5/" | sed -E "s/sechs/6/" | sed -E "s/sieben/7/" | sed -E "s/acht/8/" | sed -E "s/neun/9/" | sed -E "s/zehn/10/" | sed -E "s/elf/11/" | sed -E "s/zwölf/12/")
 # if numbers got corrected downwards, fallback to 0 new cases
 if [[ "$temp" == "" && "$(echo -n "$page" | grep -Eo "Menschen( |\&nbsp\;)+registriert\\,( |\&nbsp\;)+die( |\&nbsp\;)+sich( |\&nbsp\;)+in( |\&nbsp\;)+der( |\&nbsp\;)+Region( |\&nbsp\;)+mit( |\&nbsp\;)+dem( |\&nbsp\;)+Coronavirus( |\&nbsp\;)+infiziert( |\&nbsp\;)+haben\\.( |\&nbsp\;)+Das( |\&nbsp\;)+(sind|ist)( |\&nbsp\;)+[0-9a-zöü\\.]+( |\&nbsp\;)+(Fälle|Fall)( |\&nbsp\;)+weniger( |\&nbsp\;)+als")" != "" ]]; then
  temp=0
 fi
 if [[ "$temp" != "" ]]; then
  new_cases_hannover="$temp"
  temp=""
 fi
 # find (total) deaths sentence, extract number
 temp=$(echo -n "$page" | grep -Eo "[0-9\\.]+( |\&nbsp\;)+Menschen( |\&nbsp\;)+sind( |\&nbsp\;)+infolge( |\&nbsp\;)+einer( |\&nbsp\;)+nachgewiesenen( |\&nbsp\;)+oder( |\&nbsp\;)+mutmaßlichen( |\&nbsp\;)+Corona\\-Infektion( |\&nbsp\;)+in( |\&nbsp\;)+der( |\&nbsp\;)+Region( |\&nbsp\;)+verstorben" | grep -Eo "[0-9\\.]+" | sed -E "s/\\.//")
 if [[ "$temp" != "" ]]; then
  dead_hannover_now="$temp"
  # calculate difference from previous saved value
  deaths_hannover=$(qalc -t "$dead_hannover_now-$(cat ~/misc/corona_storage | head -n 1)" | sed -E "s/−[0-9]+/0/" | sed -E "s/\"//g")
  temp=""
 fi
 # find current cases Lehrte based on some super specific HTML formatting (may break any day), extract number
 temp=$(echo -n "$page" | grep -Eo "Lehrte<\\/p>( |\&nbsp\;)*<\\/td>( |\&nbsp\;)*<td>( |\&nbsp\;)*<p class\\=\\\"bodytext\\\">( |\&nbsp\;)*[0-9\\.]+" | grep -Eo "[0-9\\.]+" | sed -E "s/\\.//")
 if [[ "$temp" != "" ]]; then
  cases_lehrte="$temp"
  temp=""
 fi
 # even more specific HTML formatting, wider range behind it, get last/second number
 temp=$(echo -n "$page" | grep -Eo "Lehrte<\\/p>( |\&nbsp\;)*<\\/td>( |\&nbsp\;)*<td>( |\&nbsp\;)*<p class\\=\\\"bodytext\\\">( |\&nbsp\;)*[0-9\\.]+( |\&nbsp\;)*<\\/p>( |\&nbsp\;)*<\\/td>( |\&nbsp\;)*<td>( |\&nbsp\;)*<p class\\=\\\"bodytext\\\">( |\&nbsp\;)*[0-9\\.]+" | grep -Eo "[0-9\\.]+" | tail -n 1 | sed -E "s/\\.//")
 if [[ "$temp" != "" ]]; then
  total_lehrte="$temp"
  # calculate difference from previous saved value
  new_cases_lehrte=$(qalc -t "$total_lehrte-$(cat ~/misc/corona_storage | tail -n 1)" | sed -E "s/−[0-9]+/0/" | sed -E "s/\\\"//g")
 fi
 if [[ "$cases_hannover" != "" ]] && [[ "$new_cases_hannover" != "" ]] && [[ "$dead_hannover_now" != "" ]] && [[ "$cases_lehrte" != "" ]] && [[ "$total_lehrte" != "" ]]; then
  found=1
  break
 fi
done
if [[ $found == 1 ]]; then
 echo "found"
else
 echo -e "Couldn't find/parse article, skipping. Links checked:\n$links"
 dead_hannover_now=$(cat ~/misc/corona_storage | head -n 1)
 total_lehrte=$(cat ~/misc/corona_storage | tail -n 1)
 echo "cases_hannover: $cases_hannover"
 echo "new_cases_hannover: $new_cases_hannover"
 echo "(dead_hannover_now: $dead_hannover_now)"
 echo "deaths_hannover: $deaths_hannover"
 echo "cases_lehrte: $cases_lehrte"
 echo "(total_lehrte: $total_lehrte)"
 echo "new_cases_lehrte: $new_cases_lehrte"
 echo
fi

# vaccination de, world, at
page=$(wget -qO - "https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/vaccinations/vaccinations.csv")
# get area-specific rows, start at 2021-01-15, extract 6th column
vaccination_de=$(echo -n "$page" | grep "Germany" | tail -n +22 | sed -E "s/([^\,]+\,){5}([^\,]+)\,.+/\2/")
vaccination_world=$(echo -n "$page" | grep "World" | tail -n +47 | sed -E "s/([^\,]+\,){5}([^\,]+)\,.+/\2/")
vaccination_at=$(echo -n "$page" | grep "Austria" | tail -n +22 | sed -E "s/([^\,]+\,){5}([^\,]+)\,.+/\2/")

# vaccination Saxony
# temporary file, because "7z -si" seems broken
wget -qO /tmp/co "https://www.rki.de/DE/Content/InfAZ/N/Neuartiges_Coronavirus/Daten/Impfquotenmonitoring.xlsx?__blob=publicationFile"
vaccination_saxony=$(7z e -so /tmp/co xl/worksheets/sheet2.xml | grep -Eo "r\=\"E16\" s\=\"[0-9]+\"><v>[0-9]+" | sed -E "s/r\=\"E16\" s\=\"[0-9]+\"><v>//")
rm /tmp/co

# vaccination North Saxony
#page=$(wget -qO - "coronavirus.sachsen.de/ueberblick-coronaschutzimpfungen-in-sachsen-9874.html")
#vaccination_north_saxony=$(echo -n "$page" | grep --after-context=2 "Nordsachsen" | grep -Eo "[0-9\\.]+" | tail -n 1 | sed -E "s/\\.//g")

# Germany
page=$(wget -qO - "worldometers.info/coronavirus/country/germany")
cases_de=$(worldometers 101 "Currently infected")
new_cases_de=$(worldometers 101 "New cases")
deaths_de=$(worldometers 101 "Daily deaths")

# world
page=$(wget -qO - "worldometers.info/coronavirus")
cases_world=$(worldometers 125 "Currently infected")
new_cases_world=$(worldometers 125 "Daily cases") # yay for consistency
deaths_world=$(worldometers 125 "Daily deaths")

# Austria
page=$(wget -qO - "worldometers.info/coronavirus/country/austria")
cases_at=$(worldometers 101 "Currently infected")
new_cases_at=$(worldometers 101 "New cases")
deaths_at=$(worldometers 101 "Daily deaths")

# if not found and not weekend, open page for manual check
weekday=$(qalc -t "weekday(today)" | sed -E "s/\\\"//g")
if [[ $found == 0 ]] && [[ $weekday -lt 6 ]]; then
 (firefox "www.altkreisblitz.de/region-hannover" &> /dev/null & disown)
else
 # focus latest console window, hopefully that's the one with this script
 wmctrl -ia $(wmctrl -l | grep "Konsole" | tail -n 1 | sed -E "s/ .+//")
fi

# output to clipboard for overwriting all or to console for appending one entry
echo -n "$vaccination_de" | xclip -selection clipboard; echo "paste vaccination_de"
if [[ $weekday == 5 ]]; then
 echo -n "$vaccination_saxony"", ""$vaccination_saxony"", ""$vaccination_saxony"; read
else
 echo -n "$vaccination_saxony"; read
fi
#echo -n "$vaccination_north_saxony"; read
echo -n "$vaccination_world" | xclip -selection clipboard; echo -n "paste vaccination_world"; read
echo -n "$vaccination_at" | xclip -selection clipboard; echo -n "paste vaccination_at"; read
echo -n "$cases_de" | xclip -selection clipboard; echo -n "paste cases_de"; read
echo -n "$new_cases_de" | xclip -selection clipboard; echo -n "paste new_cases_de"; read
echo -n "$deaths_de" | xclip -selection clipboard; echo -n "paste deaths_de"; read
echo -n "$cases_world" | xclip -selection clipboard; echo -n "paste cases_world"; read
echo -n "$new_cases_world" | xclip -selection clipboard; echo -n "paste new_cases_world"; read
echo -n "$deaths_world" | xclip -selection clipboard; echo "paste deaths_world"
if [[ $found == 1 ]]; then
 if [[ $weekday == 5 ]]; then
  echo "$cases_hannover"", ""$cases_hannover"", ""$cases_hannover"
  echo "$new_cases_hannover"", 0, 0"
  echo "$deaths_hannover"", 0, 0"
  echo "$cases_lehrte"", ""$cases_lehrte"", ""$cases_lehrte"
  echo -n "$new_cases_lehrte"", 0, 0"
 else
  echo "$cases_hannover"
  echo "$new_cases_hannover"
  echo "$deaths_hannover"
  echo "$cases_lehrte"
  echo -n "$new_cases_lehrte"
 fi
else
 echo -n "copy, 0, 0, copy, 0 (or see above)"
fi
read
echo -n "$cases_at" | xclip -selection clipboard; echo -n "paste cases_at"; read
echo -n "$new_cases_at" | xclip -selection clipboard; echo -n "paste new_cases_at"; read
echo -n "$deaths_at" | xclip -selection clipboard; echo "paste deaths_at"

echo -en "$dead_hannover_now\n$total_lehrte" > ~/misc/corona_storage