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

462 rows where country_or_region = "Canada" and province_or_state = "Newfoundland and Labrador" sorted by day descending

View and edit SQL

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

province_or_state

  • Newfoundland and Labrador · 462

country_or_region

  • Canada · 462
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168229 2021-06-19 Canada Newfoundland and Labrador     1383 7 1350 26 53.1355 -57.6604 2021-06-20 04:21:48 Newfoundland and Labrador, Canada
685754 2021-06-18 Canada Newfoundland and Labrador     1383 7 1350 26 53.1355 -57.6604 2021-06-19 04:22:33 Newfoundland and Labrador, Canada
957811 2021-06-17 Canada Newfoundland and Labrador     1383 7 1340 36 53.1355 -57.6604 2021-06-18 04:22:16 Newfoundland and Labrador, Canada
1281178 2021-06-16 Canada Newfoundland and Labrador     1382 7 1336 39 53.1355 -57.6604 2021-06-17 04:22:36 Newfoundland and Labrador, Canada
681768 2021-06-15 Canada Newfoundland and Labrador     1381 7 1329 45 53.1355 -57.6604 2021-06-16 04:22:32 Newfoundland and Labrador, Canada
372322 2021-06-14 Canada Newfoundland and Labrador     1379 7 1329 43 53.1355 -57.6604 2021-06-15 04:22:22 Newfoundland and Labrador, Canada
1223138 2021-06-13 Canada Newfoundland and Labrador     1375 7 1329 39 53.1355 -57.6604 2021-06-14 04:22:46 Newfoundland and Labrador, Canada
80419 2021-06-12 Canada Newfoundland and Labrador     1374 7 1323 44 53.1355 -57.6604 2021-06-13 04:22:44 Newfoundland and Labrador, Canada
969722 2021-06-11 Canada Newfoundland and Labrador     1368 7 1303 58 53.1355 -57.6604 2021-06-12 04:22:22 Newfoundland and Labrador, Canada
1438295 2021-06-10 Canada Newfoundland and Labrador     1365 7 1303 55 53.1355 -57.6604 2021-06-11 04:23:20 Newfoundland and Labrador, Canada
1156794 2021-06-09 Canada Newfoundland and Labrador     1360 7 1296 57 53.1355 -57.6604 2021-06-10 04:23:17 Newfoundland and Labrador, Canada
1231110 2021-06-08 Canada Newfoundland and Labrador     1357 7 1284 66 53.1355 -57.6604 2021-06-09 04:23:31 Newfoundland and Labrador, Canada
360106 2021-06-07 Canada Newfoundland and Labrador     1354 6 1274 74 53.1355 -57.6604 2021-06-08 04:22:35 Newfoundland and Labrador, Canada
1075734 2021-06-06 Canada Newfoundland and Labrador     1352 6 1274 72 53.1355 -57.6604 2021-06-07 04:22:51 Newfoundland and Labrador, Canada
1613126 2021-06-05 Canada Newfoundland and Labrador     1347 6 1266 75 53.1355 -57.6604 2021-06-06 04:24:03 Newfoundland and Labrador, Canada
1125412 2021-06-04 Canada Newfoundland and Labrador     1342 6 1252 84 53.1355 -57.6604 2021-06-05 04:23:03 Newfoundland and Labrador, Canada
317868 2021-06-03 Canada Newfoundland and Labrador     1340 6 1240 94 53.1355 -57.6604 2021-06-04 04:23:37 Newfoundland and Labrador, Canada
1133381 2021-06-02 Canada Newfoundland and Labrador     1334 6 1234 94 53.1355 -57.6604 2021-06-03 04:23:32 Newfoundland and Labrador, Canada
291558 2021-06-01 Canada Newfoundland and Labrador     1317 6 1217 94 53.1355 -57.6604 2021-06-02 04:24:34 Newfoundland and Labrador, Canada
1651509 2021-05-31 Canada Newfoundland and Labrador     1311 6 1200 105 53.1355 -57.6604 2021-06-01 04:23:09 Newfoundland and Labrador, Canada
980737 2021-05-30 Canada Newfoundland and Labrador     1309 6 1195 108 53.1355 -57.6604 2021-05-31 03:08:59 Newfoundland and Labrador, Canada
841118 2021-05-29 Canada Newfoundland and Labrador     1302 6 1192 104 53.1355 -57.6604 2021-05-30 04:20:55 Newfoundland and Labrador, Canada
697690 2021-05-28 Canada Newfoundland and Labrador     1293 6 1187 100 53.1355 -57.6604 2021-05-29 04:20:41 Newfoundland and Labrador, Canada
1369191 2021-05-27 Canada Newfoundland and Labrador     1279 6 1180 93 53.1355 -57.6604 2021-05-28 04:20:36 Newfoundland and Labrador, Canada
1292276 2021-05-26 Canada Newfoundland and Labrador     1273 6 1170 97 53.1355 -57.6604 2021-05-27 04:20:59 Newfoundland and Labrador, Canada
602647 2021-05-25 Canada Newfoundland and Labrador     1269 6 1166 97 53.1355 -57.6604 2021-05-26 04:20:35 Newfoundland and Labrador, Canada
1365205 2021-05-24 Canada Newfoundland and Labrador     1258 6 1159 93 53.1355 -57.6604 2021-05-25 04:21:08 Newfoundland and Labrador, Canada
419718 2021-05-23 Canada Newfoundland and Labrador     1253 6 1156 91 53.1355 -57.6604 2021-05-24 04:20:53 Newfoundland and Labrador, Canada
54057 2021-05-22 Canada Newfoundland and Labrador     1230 6 1155 69 53.1355 -57.6604 2021-05-23 04:20:51 Newfoundland and Labrador, Canada
368336 2021-05-21 Canada Newfoundland and Labrador     1226 6 1146 74 53.1355 -57.6604 2021-05-22 04:20:45 Newfoundland and Labrador, Canada
1024135 2021-05-20 Canada Newfoundland and Labrador     1216 6 1134 76 53.1355 -57.6604 2021-05-21 04:20:43 Newfoundland and Labrador, Canada
1678761 2021-05-19 Canada Newfoundland and Labrador     1212 6 1124 82 53.1355 -57.6604 2021-05-20 04:21:05 Newfoundland and Labrador, Canada
64748 2021-05-18 Canada Newfoundland and Labrador     1209 6 1116 87 53.1355 -57.6604 2021-05-19 04:20:42 Newfoundland and Labrador, Canada
1242820 2021-05-17 Canada Newfoundland and Labrador     1203 6 1100 97 53.1355 -57.6604 2021-05-18 04:20:33 Newfoundland and Labrador, Canada
1067668 2021-05-16 Canada Newfoundland and Labrador     1193 6 1098 89 53.1355 -57.6604 2021-05-17 04:20:34 Newfoundland and Labrador, Canada
504796 2021-05-15 Canada Newfoundland and Labrador     1184 6 1096 82 53.1355 -57.6604 2021-05-16 04:20:49 Newfoundland and Labrador, Canada
892401 2021-05-14 Canada Newfoundland and Labrador     1179 6 1083 90 53.1355 -57.6604 2021-05-15 04:20:58 Newfoundland and Labrador, Canada
531736 2021-05-13 Canada Newfoundland and Labrador     1173 6 1081 86 53.1355 -57.6604 2021-05-14 04:20:41 Newfoundland and Labrador, Canada
1719023 2021-05-12 Canada Newfoundland and Labrador     1166 6 1075 85 53.1355 -57.6604 2021-05-13 04:20:51 Newfoundland and Labrador, Canada
1723009 2021-05-11 Canada Newfoundland and Labrador     1156 6 1069 81 53.1355 -57.6604 2021-05-12 04:21:29 Newfoundland and Labrador, Canada
1164766 2021-05-10 Canada Newfoundland and Labrador     1141 6 1064 71 53.1355 -57.6604 2021-05-11 04:20:41 Newfoundland and Labrador, Canada
1168752 2021-05-09 Canada Newfoundland and Labrador     1138 6 1061 71 53.1355 -57.6604 2021-05-10 04:20:38 Newfoundland and Labrador, Canada
1659539 2021-05-08 Canada Newfoundland and Labrador     1133 6 1056 71 53.1355 -57.6604 2021-05-09 04:20:35 Newfoundland and Labrador, Canada
799637 2021-05-07 Canada Newfoundland and Labrador     1127 6 1054 67 53.1355 -57.6604 2021-05-08 04:21:04 Newfoundland and Labrador, Canada
1219152 2021-05-06 Canada Newfoundland and Labrador     1120 6 1052 62 53.1355 -57.6604 2021-05-07 04:20:40 Newfoundland and Labrador, Canada
415732 2021-05-05 Canada Newfoundland and Labrador     1114 6 1046 62 53.1355 -57.6604 2021-05-06 04:20:38 Newfoundland and Labrador, Canada
673753 2021-05-04 Canada Newfoundland and Labrador     1108 6 1042 60 53.1355 -57.6604 2021-05-05 04:20:43 Newfoundland and Labrador, Canada
1087777 2021-05-03 Canada Newfoundland and Labrador     1104 6 1038 60 53.1355 -57.6604 2021-05-04 04:20:34 Newfoundland and Labrador, Canada
1726995 2021-05-02 Canada Newfoundland and Labrador     1099 6 1038 55 53.1355 -57.6604 2021-05-03 04:20:39 Newfoundland and Labrador, Canada
1083791 2021-05-01 Canada Newfoundland and Labrador     1081 6 1038 37 53.1355 -57.6604 2021-05-02 04:20:48 Newfoundland and Labrador, Canada
1388319 2021-04-30 Canada Newfoundland and Labrador     1076 6 1033 37 53.1355 -57.6604 2021-05-01 04:20:47 Newfoundland and Labrador, Canada
38138 2021-04-29 Canada Newfoundland and Labrador     1068 6 1031 31 53.1355 -57.6604 2021-04-30 04:21:03 Newfoundland and Labrador, Canada
11711 2021-04-28 Canada Newfoundland and Labrador     1066 6 1029 31 53.1355 -57.6604 2021-04-29 04:20:55 Newfoundland and Labrador, Canada
853094 2021-04-27 Canada Newfoundland and Labrador     1062 6 1028 28 53.1355 -57.6604 2021-04-28 04:20:32 Newfoundland and Labrador, Canada
1063682 2021-04-26 Canada Newfoundland and Labrador     1062 6 1024 32 53.1355 -57.6604 2021-04-27 04:20:52 Newfoundland and Labrador, Canada
1475932 2021-04-25 Canada Newfoundland and Labrador     1058 6 1023 29 53.1355 -57.6604 2021-04-26 04:21:04 Newfoundland and Labrador, Canada
743553 2021-04-24 Canada Newfoundland and Labrador     1056 6 1023 27 53.1355 -57.6604 2021-04-25 04:20:32 Newfoundland and Labrador, Canada
1430352 2021-04-23 Canada Newfoundland and Labrador     1053 6 1020 27 53.1355 -57.6604 2021-04-24 04:20:38 Newfoundland and Labrador, Canada
96181 2021-04-22 Canada Newfoundland and Labrador     1052 6 1016 30 53.1355 -57.6604 2021-04-23 04:20:52 Newfoundland and Labrador, Canada
849108 2021-04-21 Canada Newfoundland and Labrador     1049 6 1012 31 53.1355 -57.6604 2021-04-22 04:20:53 Newfoundland and Labrador, Canada
826726 2021-04-20 Canada Newfoundland and Labrador     1048 6 1011 31 53.1355 -57.6604 2021-04-21 04:21:14 Newfoundland and Labrador, Canada
770437 2021-04-19 Canada Newfoundland and Labrador     1046 6 1011 29 53.1355 -57.6604 2021-04-20 04:20:41 Newfoundland and Labrador, Canada
1415746 2021-04-18 Canada Newfoundland and Labrador     1043 6 1011 26 53.1355 -57.6604 2021-04-19 04:20:57 Newfoundland and Labrador, Canada
984723 2021-04-17 Canada Newfoundland and Labrador     1039 6 1011 22 53.1355 -57.6604 2021-04-18 04:20:41 Newfoundland and Labrador, Canada
237786 2021-04-16 Canada Newfoundland and Labrador     1039 6 1011 22 53.1355 -57.6604 2021-04-17 04:20:40 Newfoundland and Labrador, Canada
579515 2021-04-15 Canada Newfoundland and Labrador     1036 6 1011 19 53.1355 -57.6604 2021-04-16 04:20:46 Newfoundland and Labrador, Canada
1266143 2021-04-14 Canada Newfoundland and Labrador     1034 6 1010 18 53.1355 -57.6604 2021-04-15 04:20:54 Newfoundland and Labrador, Canada
701676 2021-04-13 Canada Newfoundland and Labrador     1031 6 1010 15 53.1355 -57.6604 2021-04-14 04:20:41 Newfoundland and Labrador, Canada
1670789 2021-04-12 Canada Newfoundland and Labrador     1030 6 1010 14 53.1355 -57.6604 2021-04-13 04:20:37 Newfoundland and Labrador, Canada
784494 2021-04-11 Canada Newfoundland and Labrador     1030 6 1010 14 53.1355 -57.6604 2021-04-12 04:21:00 Newfoundland and Labrador, Canada
1392305 2021-04-10 Canada Newfoundland and Labrador     1029 6 1009 14 53.1355 -57.6604 2021-04-11 04:20:56 Newfoundland and Labrador, Canada
965736 2021-04-09 Canada Newfoundland and Labrador     1025 6 1007 12 53.1355 -57.6604 2021-04-10 04:20:59 Newfoundland and Labrador, Canada
689740 2021-04-08 Canada Newfoundland and Labrador     1022 6 1007 9 53.1355 -57.6604 2021-04-09 04:21:13 Newfoundland and Labrador, Canada
1277192 2021-04-07 Canada Newfoundland and Labrador     1021 6 1007 8 53.1355 -57.6604 2021-04-08 04:21:13 Newfoundland and Labrador, Canada
88211 2021-04-06 Canada Newfoundland and Labrador     1020 6 1007 7 53.1355 -57.6604 2021-04-07 04:20:53 Newfoundland and Labrador, Canada
122593 2021-04-05 Canada Newfoundland and Labrador     1020 6 1006 8 53.1355 -57.6604 2021-04-06 04:20:32 Newfoundland and Labrador, Canada
73095 2021-04-04 Canada Newfoundland and Labrador     1020 6 1006 8 53.1355 -57.6604 2021-04-05 04:20:35 Newfoundland and Labrador, Canada
791711 2021-04-03 Canada Newfoundland and Labrador     1020 6 1006 8 53.1355 -57.6604 2021-04-04 04:20:49 Newfoundland and Labrador, Canada
1020149 2021-04-02 Canada Newfoundland and Labrador     1020 6 1006 8 53.1355 -57.6604 2021-04-03 04:20:44 Newfoundland and Labrador, Canada
1350311 2021-04-01 Canada Newfoundland and Labrador     1020 6 1006 8 53.1355 -57.6604 2021-04-02 04:20:36 Newfoundland and Labrador, Canada
1690697 2021-03-31 Canada Newfoundland and Labrador     1019 6 1006 7 53.1355 -57.6604 2021-04-01 04:27:05 Newfoundland and Labrador, Canada
873066 2021-03-30 Canada Newfoundland and Labrador     1018 6 1004 8 53.1355 -57.6604 2021-03-31 04:26:25 Newfoundland and Labrador, Canada
1400113 2021-03-29 Canada Newfoundland and Labrador     1016 6 1004 6 53.1355 -57.6604 2021-03-30 04:26:23 Newfoundland and Labrador, Canada
1624516 2021-03-28 Canada Newfoundland and Labrador     1016 6 1004 6 53.1355 -57.6604 2021-03-29 04:28:35 Newfoundland and Labrador, Canada
1471946 2021-03-27 Canada Newfoundland and Labrador     1015 6 1004 5 53.1355 -57.6604 2021-03-28 05:28:10 Newfoundland and Labrador, Canada
720493 2021-03-26 Canada Newfoundland and Labrador     1015 6 1004 5 53.1355 -57.6604 2021-03-27 05:25:04 Newfoundland and Labrador, Canada
1617112 2021-03-25 Canada Newfoundland and Labrador     1015 6 1004 5 53.1355 -57.6604 2021-03-26 05:26:55 Newfoundland and Labrador, Canada
469773 2021-03-24 Canada Newfoundland and Labrador     1015 6 1002 7 53.1355 -57.6604 2021-03-25 05:27:00 Newfoundland and Labrador, Canada
1584813 2021-03-23 Canada Newfoundland and Labrador     1014 6 1002 6 53.1355 -57.6604 2021-03-24 05:25:40 Newfoundland and Labrador, Canada
716507 2021-03-22 Canada Newfoundland and Labrador     1014 6 1000 8 53.1355 -57.6604 2021-03-23 05:26:18 Newfoundland and Labrador, Canada
1674775 2021-03-21 Canada Newfoundland and Labrador     1014 6 999 9 53.1355 -57.6604 2021-03-22 05:25:43 Newfoundland and Labrador, Canada
1746714 2021-03-20 Canada Newfoundland and Labrador     1014 6 999 9 53.1355 -57.6604 2021-03-21 05:25:44 Newfoundland and Labrador, Canada
229836 2021-03-19 Canada Newfoundland and Labrador     1014 6 978 30 53.1355 -57.6604 2021-03-20 05:25:46 Newfoundland and Labrador, Canada
477771 2021-03-18 Canada Newfoundland and Labrador     1014 6 970 38 53.1355 -57.6604 2021-03-19 05:26:09 Newfoundland and Labrador, Canada
1426366 2021-03-17 Canada Newfoundland and Labrador     1013 6 967 40 53.1355 -57.6604 2021-03-18 05:26:22 Newfoundland and Labrador, Canada
1592954 2021-03-16 Canada Newfoundland and Labrador     1013 6 958 49 53.1355 -57.6604 2021-03-17 05:25:07 Newfoundland and Labrador, Canada
1175953 2021-03-15 Canada Newfoundland and Labrador     1012 6 952 54 53.1355 -57.6604 2021-03-16 05:25:13 Newfoundland and Labrador, Canada
275638 2021-03-14 Canada Newfoundland and Labrador     1012 6 950 56 53.1355 -57.6604 2021-03-15 05:25:51 Newfoundland and Labrador, Canada
1160780 2021-03-13 Canada Newfoundland and Labrador     1012 6 949 57 53.1355 -57.6604 2021-03-14 05:25:37 Newfoundland and Labrador, Canada
22287 2021-03-12 Canada Newfoundland and Labrador     1012 6 945 61 53.1355 -57.6604 2021-03-13 05:25:15 Newfoundland and Labrador, 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]);