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

452 rows where country_or_region = "Canada" and province_or_state = "Grand Princess" sorted by day descending

View and edit SQL

Suggested facets: confirmed, recovered, active, latitude, longitude, day (date), last_update (date)

province_or_state

  • Grand Princess · 452

country_or_region

  • Canada · 452
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222693 2021-06-14 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
214725 2021-06-13 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
281295 2021-06-12 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1633394 2021-06-11 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
662680 2021-06-10 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
881784 2021-06-09 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1709783 2021-06-08 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1465627 2021-06-07 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
993394 2021-06-06 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
158184 2021-06-05 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1516169 2021-06-04 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1140480 2021-06-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
426924 2021-06-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
539431 2021-06-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
786616 2021-05-31 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1330014 2021-05-30 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
67223 2021-05-29 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
195409 2021-05-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
938668 2021-05-27 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1226343 2021-05-26 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1337982 2021-05-25 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
202814 2021-05-24 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
98978 2021-05-23 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
523497 2021-05-22 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
859192 2021-05-21 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
720615 2021-05-20 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
407746 2021-05-19 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
782632 2021-05-18 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1422774 2021-05-17 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
739960 2021-05-16 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1116493 2021-05-15 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1587002 2021-05-14 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1674919 2021-05-13 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
802546 2021-05-12 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1180934 2021-05-11 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
324724 2021-05-10 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
603871 2021-05-09 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
985618 2021-05-08 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
434100 2021-05-07 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
900881 2021-05-06 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
71207 2021-05-05 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
790600 2021-05-04 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1613130 2021-05-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
885768 2021-05-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
511473 2021-05-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
14409 2021-04-30 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1124513 2021-04-29 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
461810 2021-04-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1314516 2021-04-27 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1548943 2021-04-26 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1629410 2021-04-25 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
353550 2021-04-24 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
724599 2021-04-23 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1469611 2021-04-22 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1222359 2021-04-21 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
457826 2021-04-20 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1300014 2021-04-19 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1069593 2021-04-18 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1045475 2021-04-17 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
596751 2021-04-16 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1621167 2021-04-15 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
950598 2021-04-14 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
592767 2021-04-13 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
32706 2021-04-12 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1371721 2021-04-11 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1666973 2021-04-10 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1159589 2021-04-09 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1057424 2021-04-08 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1500213 2021-04-07 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1207418 2021-04-06 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
122719 2021-04-05 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1254520 2021-04-04 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1128497 2021-04-03 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
269888 2021-04-02 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1173220 2021-04-01 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
515531 2021-03-31 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
289260 2021-03-30 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1574797 2021-03-29 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
631074 2021-03-28 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
607855 2021-03-27 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1333998 2021-03-26 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
150437 2021-03-25 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1597958 2021-03-24 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
403762 2021-03-23 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1387299 2021-03-22 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
304786 2021-03-21 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
253835 2021-03-20 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1230591 2021-03-19 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
974516 2021-03-18 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1532151 2021-03-17 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
55345 2021-03-16 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
562658 2021-03-15 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
851227 2021-03-14 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
942652 2021-03-13 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1310532 2021-03-12 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1077370 2021-03-11 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
954582 2021-03-10 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
543415 2021-03-09 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
1520153 2021-03-08 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand Princess, Canada
866434 2021-03-07 Canada Grand Princess     13 0 13 0 37.6489 0.0 2020-12-21 13:27:30 Grand 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]);