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

467 rows where country_or_region = "Canada" and province_or_state = "Prince Edward Island" sorted by day descending

View and edit SQL

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

province_or_state

  • Prince Edward Island · 467

country_or_region

  • Canada · 467
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234690 2021-06-24 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-25 04:21:33 Prince Edward Island, Canada
471638 2021-06-23 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-24 04:21:55 Prince Edward Island, Canada
626696 2021-06-22 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-23 04:21:46 Prince Edward Island, Canada
226716 2021-06-21 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-22 04:21:34 Prince Edward Island, Canada
1472238 2021-06-20 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-21 04:21:41 Prince Edward Island, Canada
1303479 2021-06-19 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-20 04:21:48 Prince Edward Island, Canada
303081 2021-06-18 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-19 04:22:33 Prince Edward Island, Canada
885911 2021-06-17 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-18 04:22:16 Prince Edward Island, Canada
41808 2021-06-16 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-17 04:22:36 Prince Edward Island, Canada
1704630 2021-06-15 Canada Prince Edward Island     206 0 206 0 46.5107 -63.4168 2021-06-16 04:22:32 Prince Edward Island, Canada
1660901 2021-06-14 Canada Prince Edward Island     206 0 202 4 46.5107 -63.4168 2021-06-15 04:22:22 Prince Edward Island, Canada
318977 2021-06-13 Canada Prince Edward Island     206 0 202 4 46.5107 -63.4168 2021-06-14 04:22:46 Prince Edward Island, Canada
618722 2021-06-12 Canada Prince Edward Island     206 0 202 4 46.5107 -63.4168 2021-06-13 04:22:44 Prince Edward Island, Canada
591731 2021-06-11 Canada Prince Edward Island     206 0 202 4 46.5107 -63.4168 2021-06-12 04:22:22 Prince Edward Island, Canada
272609 2021-06-10 Canada Prince Edward Island     206 0 201 5 46.5107 -63.4168 2021-06-11 04:23:20 Prince Edward Island, Canada
1637667 2021-06-09 Canada Prince Edward Island     206 0 201 5 46.5107 -63.4168 2021-06-10 04:23:17 Prince Edward Island, Canada
1744280 2021-06-08 Canada Prince Edward Island     206 0 201 5 46.5107 -63.4168 2021-06-09 04:23:31 Prince Edward Island, Canada
576823 2021-06-07 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-08 04:22:35 Prince Edward Island, Canada
245686 2021-06-06 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-07 04:22:51 Prince Edward Island, Canada
673663 2021-06-05 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-06 04:24:03 Prince Edward Island, Canada
552926 2021-06-04 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-05 04:23:03 Prince Edward Island, Canada
1460323 2021-06-03 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-04 04:23:37 Prince Edward Island, Canada
1399316 2021-06-02 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-03 04:23:32 Prince Edward Island, Canada
1708663 2021-06-01 Canada Prince Edward Island     204 0 200 4 46.5107 -63.4168 2021-06-02 04:24:34 Prince Edward Island, Canada
18893 2021-05-31 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-06-01 04:23:09 Prince Edward Island, Canada
1497286 2021-05-30 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-05-31 03:08:59 Prince Edward Island, Canada
622709 2021-05-29 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-05-30 04:20:55 Prince Edward Island, Canada
80565 2021-05-28 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-05-29 04:20:41 Prince Edward Island, Canada
1425840 2021-05-27 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-05-28 04:20:36 Prince Edward Island, Canada
1548808 2021-05-26 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-05-27 04:20:59 Prince Edward Island, Canada
1200384 2021-05-25 Canada Prince Edward Island     200 0 187 13 46.5107 -63.4168 2021-05-26 04:20:35 Prince Edward Island, Canada
149377 2021-05-24 Canada Prince Edward Island     199 0 185 14 46.5107 -63.4168 2021-05-25 04:21:08 Prince Edward Island, Canada
689530 2021-05-23 Canada Prince Edward Island     199 0 185 14 46.5107 -63.4168 2021-05-24 04:20:53 Prince Edward Island, Canada
387144 2021-05-22 Canada Prince Edward Island     199 0 185 14 46.5107 -63.4168 2021-05-23 04:20:51 Prince Edward Island, Canada
969459 2021-05-21 Canada Prince Edward Island     199 0 185 14 46.5107 -63.4168 2021-05-22 04:20:45 Prince Edward Island, Canada
57421 2021-05-20 Canada Prince Edward Island     199 0 185 14 46.5107 -63.4168 2021-05-21 04:20:43 Prince Edward Island, Canada
463683 2021-05-19 Canada Prince Edward Island     199 0 185 14 46.5107 -63.4168 2021-05-20 04:21:05 Prince Edward Island, Canada
1275639 2021-05-18 Canada Prince Edward Island     194 0 184 10 46.5107 -63.4168 2021-05-19 04:20:42 Prince Edward Island, Canada
230703 2021-05-17 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-18 04:20:33 Prince Edward Island, Canada
1158918 2021-05-16 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-17 04:20:34 Prince Edward Island, Canada
1008474 2021-05-15 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-16 04:20:49 Prince Edward Island, Canada
804586 2021-05-14 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-15 04:20:58 Prince Edward Island, Canada
1192414 2021-05-13 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-14 04:20:41 Prince Edward Island, Canada
685543 2021-05-12 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-13 04:20:51 Prince Edward Island, Canada
128943 2021-05-11 Canada Prince Edward Island     187 0 179 8 46.5107 -63.4168 2021-05-12 04:21:29 Prince Edward Island, Canada
1256948 2021-05-10 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-11 04:20:41 Prince Edward Island, Canada
120969 2021-05-09 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-10 04:20:38 Prince Edward Island, Canada
88539 2021-05-08 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-09 04:20:35 Prince Edward Island, Canada
522037 2021-05-07 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-08 04:21:04 Prince Edward Island, Canada
1684661 2021-05-06 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-07 04:20:40 Prince Edward Island, Canada
22880 2021-05-05 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-06 04:20:38 Prince Edward Island, Canada
1330822 2021-05-04 Canada Prince Edward Island     183 0 176 7 46.5107 -63.4168 2021-05-05 04:20:43 Prince Edward Island, Canada
1035409 2021-05-03 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-04 04:20:34 Prince Edward Island, Canada
913599 2021-05-02 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-03 04:20:39 Prince Edward Island, Canada
1756565 2021-05-01 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-02 04:20:48 Prince Edward Island, Canada
1456336 2021-04-30 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-05-01 04:20:47 Prince Edward Island, Canada
1614150 2021-04-29 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-30 04:21:03 Prince Edward Island, Canada
483549 2021-04-28 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-29 04:20:55 Prince Edward Island, Canada
334587 2021-04-27 Canada Prince Edward Island     177 0 166 11 46.5107 -63.4168 2021-04-28 04:20:32 Prince Edward Island, Canada
1357632 2021-04-26 Canada Prince Edward Island     175 0 164 11 46.5107 -63.4168 2021-04-27 04:20:52 Prince Edward Island, Canada
495588 2021-04-25 Canada Prince Edward Island     175 0 164 11 46.5107 -63.4168 2021-04-26 04:21:04 Prince Edward Island, Canada
1112187 2021-04-24 Canada Prince Edward Island     175 0 164 11 46.5107 -63.4168 2021-04-25 04:20:32 Prince Edward Island, Canada
487536 2021-04-23 Canada Prince Edward Island     175 0 164 11 46.5107 -63.4168 2021-04-24 04:20:38 Prince Edward Island, Canada
1169921 2021-04-22 Canada Prince Edward Island     174 0 161 13 46.5107 -63.4168 2021-04-23 04:20:52 Prince Edward Island, Canada
1403392 2021-04-21 Canada Prince Edward Island     174 0 161 13 46.5107 -63.4168 2021-04-22 04:20:53 Prince Edward Island, Canada
1712650 2021-04-20 Canada Prince Edward Island     174 0 161 13 46.5107 -63.4168 2021-04-21 04:21:14 Prince Edward Island, Canada
606779 2021-04-19 Canada Prince Edward Island     173 0 160 13 46.5107 -63.4168 2021-04-20 04:20:41 Prince Edward Island, Canada
917586 2021-04-18 Canada Prince Edward Island     165 0 159 6 46.5107 -63.4168 2021-04-19 04:20:57 Prince Edward Island, Canada
1318897 2021-04-17 Canada Prince Edward Island     165 0 159 6 46.5107 -63.4168 2021-04-18 04:20:41 Prince Edward Island, Canada
988589 2021-04-16 Canada Prince Edward Island     165 0 159 6 46.5107 -63.4168 2021-04-17 04:20:40 Prince Edward Island, Canada
379693 2021-04-15 Canada Prince Edward Island     165 0 159 6 46.5107 -63.4168 2021-04-16 04:20:46 Prince Edward Island, Canada
905643 2021-04-14 Canada Prince Edward Island     165 0 159 6 46.5107 -63.4168 2021-04-15 04:20:54 Prince Edward Island, Canada
1078870 2021-04-13 Canada Prince Edward Island     165 0 159 6 46.5107 -63.4168 2021-04-14 04:20:41 Prince Edward Island, Canada
354106 2021-04-12 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-13 04:20:37 Prince Edward Island, Canada
1180555 2021-04-11 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-12 04:21:00 Prince Edward Island, Canada
1188427 2021-04-10 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-11 04:20:56 Prince Edward Island, Canada
1692613 2021-04-09 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-10 04:20:59 Prince Edward Island, Canada
568852 2021-04-08 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-09 04:21:13 Prince Edward Island, Canada
1345671 2021-04-07 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-08 04:21:13 Prince Edward Island, Canada
350039 2021-04-06 Canada Prince Edward Island     160 0 152 8 46.5107 -63.4168 2021-04-07 04:20:53 Prince Edward Island, Canada
1043364 2021-04-05 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-04-06 04:20:32 Prince Edward Island, Canada
214684 2021-04-04 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-04-05 04:20:35 Prince Edward Island, Canada
1700643 2021-04-03 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-04-04 04:20:49 Prince Edward Island, Canada
953332 2021-04-02 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-04-03 04:20:44 Prince Edward Island, Canada
124956 2021-04-01 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-04-02 04:20:36 Prince Edward Island, Canada
1515848 2021-03-31 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-04-01 04:27:05 Prince Edward Island, Canada
1716637 2021-03-30 Canada Prince Edward Island     159 0 145 14 46.5107 -63.4168 2021-03-31 04:26:25 Prince Edward Island, Canada
732624 2021-03-29 Canada Prince Edward Island     156 0 144 12 46.5107 -63.4168 2021-03-30 04:26:23 Prince Edward Island, Canada
421928 2021-03-28 Canada Prince Edward Island     156 0 144 12 46.5107 -63.4168 2021-03-29 04:28:35 Prince Edward Island, Canada
1732319 2021-03-27 Canada Prince Edward Island     156 0 144 12 46.5107 -63.4168 2021-03-28 05:28:10 Prince Edward Island, Canada
402762 2021-03-26 Canada Prince Edward Island     152 0 144 8 46.5107 -63.4168 2021-03-27 05:25:04 Prince Edward Island, Canada
1353645 2021-03-25 Canada Prince Edward Island     152 0 144 8 46.5107 -63.4168 2021-03-26 05:26:55 Prince Edward Island, Canada
507335 2021-03-24 Canada Prince Edward Island     152 0 144 8 46.5107 -63.4168 2021-03-25 05:27:00 Prince Edward Island, Canada
1590252 2021-03-23 Canada Prince Edward Island     152 0 144 8 46.5107 -63.4168 2021-03-24 05:25:40 Prince Edward Island, Canada
839644 2021-03-22 Canada Prince Edward Island     144 0 140 4 46.5107 -63.4168 2021-03-23 05:26:18 Prince Edward Island, Canada
720884 2021-03-21 Canada Prince Edward Island     144 0 140 4 46.5107 -63.4168 2021-03-22 05:25:43 Prince Edward Island, Canada
442027 2021-03-20 Canada Prince Edward Island     144 0 140 4 46.5107 -63.4168 2021-03-21 05:25:44 Prince Edward Island, Canada
544969 2021-03-19 Canada Prince Edward Island     144 0 140 4 46.5107 -63.4168 2021-03-20 05:25:46 Prince Edward Island, Canada
1349658 2021-03-18 Canada Prince Edward Island     144 0 140 4 46.5107 -63.4168 2021-03-19 05:26:09 Prince Edward Island, Canada
84552 2021-03-17 Canada Prince Edward Island     144 0 140 4 46.5107 -63.4168 2021-03-18 05:26:22 Prince Edward Island, 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]);