SELECT date, confirmed,deaths, confirmed - LAG ( confirmed, 1, 0 ) OVER ( ORDER BY date ) DailyCases, deaths - LAG ( deaths, 1, 0 ) OVER ( ORDER BY date ) DailyDeaths FROM JHUDATA where country = "Sweden"
select enddate, sum(...), ... from ( select date(cast(julianday(datecolumn)-1721061.5 as integer)/7*7+1721067.5) as enddate, * from theTable ) group by enddate order by enddate;
sudo curl -bla /ihave/idea ./ wget --no-parent -r http://mysite.ie/mydirectory
Web-site: https://ourworldindata.org/
Github Repo: https://github.com/owid/covid-19-data