search

simonw / covid-19-datasette

Deploys a Datasette instance of COVID-19 data from Johns Hopkins CSSE and the New York Times
https://covid-19.datasettes.com/
61 stars 6 forks source link

Query issue #13

Closed cakesoft-yash closed 4 years ago

cakesoft-yash commented 4 years ago

select * from johns_hopkins_csse_daily_reports where country_or_region='US'; I tried to hit this query but not getting all the data. Thank you.

simonw commented 4 years ago

You need pagination, which isn't supported on the query page. You can paginate here:

https://covid-19.datasettes.com/covid/johns_hopkins_csse_daily_reports?country_or_region=US

That page also offers an option to export ALL matching rows as CSV - https://covid-19.datasettes.com/covid/johns_hopkins_csse_daily_reports?country_or_region=US#export - check the "stream all rows" button.