johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

34 rows where country_or_region = "Canada" and province_or_state = "London, ON" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • London, ON · 34 ✖

country_or_region 1

  • Canada · 34 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1527377 1527377 2020-03-08 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
62631 62631 2020-03-07 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
3177619 3177619 2020-03-06 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
40261 40261 2020-03-05 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
98921 98921 2020-03-04 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
261128 261128 2020-03-03 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1152736 1152736 2020-03-02 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
562590 562590 2020-03-01 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
3205870 3205870 2020-02-29 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
2883990 2883990 2020-02-28 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
617471 617471 2020-02-27 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
2509825 2509825 2020-02-26 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
479199 479199 2020-02-25 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
3551259 3551259 2020-02-24 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
3173402 3173402 2020-02-23 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1085691 1085691 2020-02-22 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
2135773 2135773 2020-02-21 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
2263511 2263511 2020-02-20 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1720103 1720103 2020-02-19 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1783134 1783134 2020-02-18 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1243408 1243408 2020-02-17 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1888761 1888761 2020-02-16 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
107087 107087 2020-02-15 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1192506 1192506 2020-02-14 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
1559713 1559713 2020-02-13 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
2567302 2567302 2020-02-12 Canada London, ON     1 0 1   42.9849 -81.2453 2020-02-12T18:53:03  
3197761 3197761 2020-02-11 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
3089060 3089060 2020-02-10 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
3362429 3362429 2020-02-09 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
1366098 1366098 2020-02-08 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
3222057 3222057 2020-02-07 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
566725 566725 2020-02-06 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
2091718 2091718 2020-02-05 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  
3471935 3471935 2020-02-04 Canada London, ON     1 0 0   42.9849 -81.2453 2020-02-04T00:03:11  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);