⚠️ 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

448 rows where country_or_region = "Canada" and province_or_state = "Diamond Princess" sorted by day descending

View and edit SQL

Suggested facets: confirmed, active, day (date), last_update (date)

province_or_state

  • Diamond Princess · 448

country_or_region

  • Canada · 448
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234681 2021-06-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
471629 2021-06-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
626687 2021-06-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
226707 2021-06-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1472229 2021-06-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1303470 2021-06-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
303072 2021-06-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
885902 2021-06-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
41799 2021-06-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1704621 2021-06-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1660892 2021-06-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
318968 2021-06-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
618713 2021-06-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
591722 2021-06-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
272600 2021-06-10 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1637658 2021-06-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1744271 2021-06-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
576814 2021-06-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
245677 2021-06-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
673654 2021-06-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
552917 2021-06-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1460314 2021-06-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1399307 2021-06-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1708654 2021-06-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
18884 2021-05-31 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1497277 2021-05-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
622700 2021-05-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
80556 2021-05-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1425831 2021-05-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1548799 2021-05-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1200375 2021-05-25 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
149368 2021-05-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
689521 2021-05-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
387135 2021-05-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
969450 2021-05-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
57412 2021-05-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
463674 2021-05-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1275630 2021-05-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
230694 2021-05-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1158909 2021-05-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1008465 2021-05-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
804577 2021-05-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1192405 2021-05-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
685534 2021-05-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
128934 2021-05-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1256939 2021-05-10 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
120960 2021-05-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
88530 2021-05-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
522028 2021-05-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1684652 2021-05-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
22871 2021-05-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1330813 2021-05-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1035400 2021-05-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
913590 2021-05-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1756556 2021-05-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1456327 2021-04-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1614141 2021-04-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
483540 2021-04-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
334578 2021-04-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1357623 2021-04-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
495579 2021-04-25 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1112178 2021-04-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
487527 2021-04-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1169912 2021-04-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1403383 2021-04-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1712641 2021-04-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
606770 2021-04-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
917577 2021-04-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1318888 2021-04-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
988580 2021-04-16 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
379684 2021-04-15 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
905634 2021-04-14 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1078861 2021-04-13 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
354097 2021-04-12 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1180546 2021-04-11 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1188418 2021-04-10 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1692604 2021-04-09 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
568843 2021-04-08 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1345662 2021-04-07 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
350030 2021-04-06 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1043355 2021-04-05 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
214675 2021-04-04 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1700634 2021-04-03 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
953323 2021-04-02 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
124947 2021-04-01 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1515839 2021-03-31 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1716628 2021-03-30 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
732615 2021-03-29 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
421919 2021-03-28 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1732310 2021-03-27 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
402753 2021-03-26 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1353636 2021-03-25 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
507326 2021-03-24 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1590243 2021-03-23 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
839635 2021-03-22 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
720875 2021-03-21 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
442018 2021-03-20 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
544960 2021-03-19 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
1349649 2021-03-18 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada
84543 2021-03-17 Canada Diamond Princess     0 1 0   0.0 0.0 2020-12-21 13:27:30 Diamond Princess, Canada

Next page

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] INTEGER,
   [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]);