johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
114 rows where active = 0, country_or_region = "Canada" and province_or_state = "Prince Edward Island" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98430 | 98430 | 2020-08-04 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-05 04:34:43 | Prince Edward Island, Canada | ||
107225 | 107225 | 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 | ||
210017 | 210017 | 2020-10-29 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-10-30 04:24:49 | Prince Edward Island, Canada | ||
217294 | 217294 | 2020-06-08 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-09 03:33:03 | Prince Edward Island, Canada | ||
268369 | 268369 | 2020-05-21 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-22 02:36:51 | Prince Edward Island, Canada | ||
287302 | 287302 | 2020-06-15 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-16 04:33:09 | Prince Edward Island, Canada | ||
295786 | 295786 | 2021-07-15 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-16 04:21:22 | Prince Edward Island, Canada | ||
303174 | 303174 | 2020-07-01 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-07-02 04:33:46 | Prince Edward Island, Canada | ||
331680 | 331680 | 2021-08-04 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-05 04:21:51 | Prince Edward Island, Canada | ||
371495 | 371495 | 2020-08-08 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-09 04:34:54 | Prince Edward Island, Canada | ||
408068 | 408068 | 2021-07-28 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-29 04:21:33 | Prince Edward Island, Canada | ||
458679 | 458679 | 2020-08-07 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-08 04:34:53 | Prince Edward Island, Canada | ||
483364 | 483364 | 2021-07-19 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-20 04:21:48 | Prince Edward Island, Canada | ||
562741 | 562741 | 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 | ||
574146 | 574146 | 2020-06-06 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-07 03:53:30 | Prince Edward Island, Canada | ||
578606 | 578606 | 2021-07-13 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-14 04:21:35 | Prince Edward Island, Canada | ||
662077 | 662077 | 2020-08-11 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-12 04:27:29 | Prince Edward Island, Canada | ||
737625 | 737625 | 2020-06-12 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-13 03:33:14 | Prince Edward Island, Canada | ||
753633 | 753633 | 2020-08-01 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-02 04:34:47 | Prince Edward Island, Canada | ||
805446 | 805446 | 2020-06-01 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-02 02:33:08 | Prince Edward Island, Canada | ||
875649 | 875649 | 2020-05-24 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-25 02:32:44 | Prince Edward Island, Canada | ||
891897 | 891897 | 2020-11-05 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-11-06 05:24:55 | Prince Edward Island, Canada | ||
997840 | 997840 | 2020-05-23 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-24 02:32:43 | Prince Edward Island, Canada | ||
1041239 | 1041239 | 2020-05-26 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-27 02:32:31 | Prince Edward Island, Canada | ||
1104969 | 1104969 | 2020-05-25 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-26 02:32:35 | Prince Edward Island, Canada | ||
1105331 | 1105331 | 2020-09-02 | Canada | Prince Edward Island | 44 | 0 | 44 | 0 | 46.5107 | -63.4168 | 2020-09-03 04:28:22 | Prince Edward Island, Canada | ||
1125368 | 1125368 | 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 | ||
1136208 | 1136208 | 2020-06-26 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-27 04:33:35 | Prince Edward Island, Canada | ||
1195976 | 1195976 | 2020-06-17 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-18 04:33:18 | Prince Edward Island, Canada | ||
1210867 | 1210867 | 2020-06-09 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-10 04:07:00 | Prince Edward Island, Canada | ||
1269843 | 1269843 | 2020-06-05 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-06 02:33:00 | Prince Edward Island, Canada | ||
1273595 | 1273595 | 2020-06-11 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-12 05:09:52 | Prince Edward Island, Canada | ||
1281312 | 1281312 | 2020-06-04 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-05 02:33:06 | Prince Edward Island, Canada | ||
1305929 | 1305929 | 2021-07-27 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-28 04:21:39 | Prince Edward Island, Canada | ||
1330021 | 1330021 | 2021-07-24 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-25 04:22:12 | Prince Edward Island, Canada | ||
1378281 | 1378281 | 2021-07-25 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-26 04:21:28 | Prince Edward Island, Canada | ||
1404451 | 1404451 | 2020-05-14 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-15 02:33:02 | Prince Edward Island, Canada | ||
1431952 | 1431952 | 2020-05-20 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-21 02:32:48 | Prince Edward Island, Canada | ||
1510714 | 1510714 | 2020-06-22 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-23 04:33:22 | Prince Edward Island, Canada | ||
1522520 | 1522520 | 2020-06-23 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-24 04:33:28 | Prince Edward Island, Canada | ||
1691624 | 1691624 | 2020-06-19 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-20 04:33:19 | Prince Edward Island, Canada | ||
1712099 | 1712099 | 2021-06-25 | Canada | Prince Edward Island | 206 | 0 | 206 | 0 | 46.5107 | -63.4168 | 2021-06-26 04:21:43 | Prince Edward Island, Canada | ||
1790451 | 1790451 | 2020-05-29 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-30 02:32:48 | Prince Edward Island, Canada | ||
1794017 | 1794017 | 2020-05-31 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-01 02:32:46 | Prince Edward Island, Canada | ||
1829561 | 1829561 | 2020-05-16 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-17 02:32:32 | Prince Edward Island, Canada | ||
1837253 | 1837253 | 2020-06-14 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-15 03:33:14 | Prince Edward Island, Canada | ||
1864863 | 1864863 | 2020-05-22 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-23 02:32:42 | Prince Edward Island, Canada | ||
1920518 | 1920518 | 2020-08-10 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-11 04:35:08 | Prince Edward Island, Canada | ||
1928505 | 1928505 | 2020-07-30 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-07-31 04:35:18 | Prince Edward Island, Canada | ||
2039927 | 2039927 | 2020-06-27 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-28 04:34:04 | Prince Edward Island, Canada | ||
2059660 | 2059660 | 2020-09-01 | Canada | Prince Edward Island | 44 | 0 | 44 | 0 | 46.5107 | -63.4168 | 2020-09-02 04:28:25 | Prince Edward Island, Canada | ||
2079709 | 2079709 | 2020-10-31 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-11-01 04:36:19 | Prince Edward Island, Canada | ||
2234689 | 2234689 | 2020-07-03 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-07-04 04:33:51 | Prince Edward Island, Canada | ||
2243162 | 2243162 | 2020-10-30 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-10-31 04:24:44 | Prince Edward Island, Canada | ||
2295224 | 2295224 | 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 | ||
2306592 | 2306592 | 2020-06-28 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-29 04:33:44 | Prince Edward Island, Canada | ||
2339170 | 2339170 | 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 | ||
2371285 | 2371285 | 2021-07-20 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-21 04:21:40 | Prince Edward Island, Canada | ||
2386739 | 2386739 | 2020-06-16 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-17 04:33:21 | Prince Edward Island, Canada | ||
2390195 | 2390195 | 2020-05-19 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-20 02:32:19 | Prince Edward Island, Canada | ||
2422664 | 2422664 | 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 | ||
2438046 | 2438046 | 2020-06-20 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-21 04:33:19 | Prince Edward Island, Canada | ||
2497796 | 2497796 | 2020-11-03 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-11-04 05:25:09 | Prince Edward Island, Canada | ||
2548276 | 2548276 | 2020-05-27 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-28 02:32:31 | Prince Edward Island, Canada | ||
2555909 | 2555909 | 2020-06-02 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-03 02:33:13 | Prince Edward Island, Canada | ||
2589776 | 2589776 | 2021-06-27 | Canada | Prince Edward Island | 206 | 0 | 206 | 0 | 46.5107 | -63.4168 | 2021-06-28 04:21:29 | Prince Edward Island, Canada | ||
2625195 | 2625195 | 2020-06-25 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-26 04:33:43 | Prince Edward Island, Canada | ||
2633029 | 2633029 | 2020-06-29 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-30 04:33:48 | Prince Edward Island, Canada | ||
2673587 | 2673587 | 2021-07-18 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-19 04:21:24 | Prince Edward Island, Canada | ||
2700835 | 2700835 | 2020-06-24 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-25 05:26:54 | Prince Edward Island, Canada | ||
2712330 | 2712330 | 2020-05-28 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-29 02:32:50 | Prince Edward Island, Canada | ||
2740313 | 2740313 | 2020-08-03 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-04 04:41:59 | Prince Edward Island, Canada | ||
2800090 | 2800090 | 2020-06-07 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-08 03:33:22 | Prince Edward Island, Canada | ||
2808065 | 2808065 | 2020-08-02 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-03 04:34:35 | Prince Edward Island, Canada | ||
2864037 | 2864037 | 2020-06-10 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-11 03:33:41 | Prince Edward Island, Canada | ||
2884142 | 2884142 | 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 | ||
2910946 | 2910946 | 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 | ||
2918959 | 2918959 | 2020-11-04 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-11-05 06:05:03 | Prince Edward Island, Canada | ||
2947130 | 2947130 | 2021-07-16 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-17 04:22:22 | Prince Edward Island, Canada | ||
2958673 | 2958673 | 2020-07-29 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-07-30 04:35:05 | Prince Edward Island, Canada | ||
2974552 | 2974552 | 2020-06-30 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-07-01 04:33:52 | Prince Edward Island, Canada | ||
3015124 | 3015124 | 2021-08-01 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-08-02 04:21:36 | Prince Edward Island, Canada | ||
3030064 | 3030064 | 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 | ||
3045483 | 3045483 | 2020-07-02 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-07-03 04:33:54 | Prince Edward Island, Canada | ||
3061305 | 3061305 | 2020-06-13 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-14 03:33:15 | Prince Edward Island, Canada | ||
3125281 | 3125281 | 2021-06-28 | Canada | Prince Edward Island | 206 | 0 | 206 | 0 | 46.5107 | -63.4168 | 2021-06-29 04:21:28 | Prince Edward Island, Canada | ||
3137325 | 3137325 | 2021-07-23 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-24 00:21:36 | Prince Edward Island, Canada | ||
3185289 | 3185289 | 2020-07-28 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-07-29 04:35:11 | Prince Edward Island, Canada | ||
3218072 | 3218072 | 2021-07-26 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-27 04:21:18 | Prince Edward Island, Canada | ||
3249453 | 3249453 | 2020-06-21 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-06-22 04:33:20 | Prince Edward Island, Canada | ||
3260933 | 3260933 | 2020-05-18 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-19 02:32:18 | Prince Edward Island, Canada | ||
3264798 | 3264798 | 2020-07-31 | Canada | Prince Edward Island | 36 | 0 | 36 | 0 | 46.5107 | -63.4168 | 2020-08-01 04:36:27 | Prince Edward Island, Canada | ||
3276277 | 3276277 | 2020-05-15 | Canada | Prince Edward Island | 27 | 0 | 27 | 0 | 46.5107 | -63.4168 | 2020-05-16 02:32:19 | Prince Edward Island, Canada | ||
3295952 | 3295952 | 2021-07-30 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-31 04:21:35 | Prince Edward Island, Canada | ||
3303971 | 3303971 | 2020-11-02 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-11-03 06:00:16 | Prince Edward Island, Canada | ||
3315995 | 3315995 | 2020-09-22 | Canada | Prince Edward Island | 57 | 0 | 57 | 0 | 46.5107 | -63.4168 | 2020-09-23 04:23:00 | Prince Edward Island, Canada | ||
3331304 | 3331304 | 2021-07-21 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-22 04:21:19 | Prince Edward Island, Canada | ||
3358443 | 3358443 | 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 | ||
3385163 | 3385163 | 2021-07-29 | Canada | Prince Edward Island | 208 | 0 | 208 | 0 | 46.5107 | -63.4168 | 2021-07-30 04:21:34 | Prince Edward Island, Canada | ||
3409220 | 3409220 | 2020-11-01 | Canada | Prince Edward Island | 64 | 0 | 64 | 0 | 46.5107 | -63.4168 | 2020-11-02 05:25:04 | Prince Edward Island, Canada |
Advanced export
JSON shape: default, array, newline-delimited
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]);