Israel Covid Cases (Google Public data, BigQuery)
More testing maybe? From single digits to quadruple digits in 2 months :(
select country_region, date, confirmed, deaths, recovered, active,LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY date ASC) AS prev_day,confirmed - LAG(confirmed, 1) OVER (PARTITION BY country_region ORDER BY…