home / covid-19-uk
select Date, Country, AreaCode, Area, TotalCases from cases where date("Date") = :p0 and (Country < :p5 or Country is null or (Country = :p5 and ((Date > :p1) or (Date = :p1 and Country > :p2) or (Date = :p1 and Country = :p2 and AreaCode > :p3) or (Date = :p1 and Country = :p2 and AreaCode = :p3 and Area > :p4)))) order by Country desc, Date, Country, AreaCode, Area limit 101
p0
p5
p1
p2
p3
p4
Format SQL
This data as json, CSV