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

447 rows where country_or_region = "Canada" and province_or_state = "Nunavut" sorted by day descending

View and edit SQL

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

province_or_state

  • Nunavut · 447

country_or_region

  • Canada · 447
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222699 2021-06-14 Canada Nunavut     657 4 644 9 70.2998 -83.1076 2021-06-15 04:22:22 Nunavut, Canada
214731 2021-06-13 Canada Nunavut     657 4 644 9 70.2998 -83.1076 2021-06-14 04:22:46 Nunavut, Canada
281301 2021-06-12 Canada Nunavut     657 4 644 9 70.2998 -83.1076 2021-06-13 04:22:44 Nunavut, Canada
1633400 2021-06-11 Canada Nunavut     654 4 644 6 70.2998 -83.1076 2021-06-12 04:22:22 Nunavut, Canada
662686 2021-06-10 Canada Nunavut     650 4 644 2 70.2998 -83.1076 2021-06-11 04:23:20 Nunavut, Canada
881790 2021-06-09 Canada Nunavut     649 4 644 1 70.2998 -83.1076 2021-06-10 04:23:17 Nunavut, Canada
1709789 2021-06-08 Canada Nunavut     649 4 644 1 70.2998 -83.1076 2021-06-09 04:23:31 Nunavut, Canada
1465633 2021-06-07 Canada Nunavut     649 4 644 1 70.2998 -83.1076 2021-06-08 04:22:35 Nunavut, Canada
993400 2021-06-06 Canada Nunavut     649 4 642 3 70.2998 -83.1076 2021-06-07 04:22:51 Nunavut, Canada
158190 2021-06-05 Canada Nunavut     649 4 642 3 70.2998 -83.1076 2021-06-06 04:24:03 Nunavut, Canada
1516175 2021-06-04 Canada Nunavut     649 4 635 10 70.2998 -83.1076 2021-06-05 04:23:03 Nunavut, Canada
1140486 2021-06-03 Canada Nunavut     648 4 635 9 70.2998 -83.1076 2021-06-04 04:23:37 Nunavut, Canada
426930 2021-06-02 Canada Nunavut     648 4 635 9 70.2998 -83.1076 2021-06-03 04:23:32 Nunavut, Canada
539437 2021-06-01 Canada Nunavut     648 4 635 9 70.2998 -83.1076 2021-06-02 04:24:34 Nunavut, Canada
786622 2021-05-31 Canada Nunavut     648 4 635 9 70.2998 -83.1076 2021-06-01 04:23:09 Nunavut, Canada
1330020 2021-05-30 Canada Nunavut     648 4 634 10 70.2998 -83.1076 2021-05-31 03:08:59 Nunavut, Canada
67229 2021-05-29 Canada Nunavut     648 4 632 12 70.2998 -83.1076 2021-05-30 04:20:55 Nunavut, Canada
195415 2021-05-28 Canada Nunavut     648 4 629 15 70.2998 -83.1076 2021-05-29 04:20:41 Nunavut, Canada
938674 2021-05-27 Canada Nunavut     647 4 622 21 70.2998 -83.1076 2021-05-28 04:20:36 Nunavut, Canada
1226349 2021-05-26 Canada Nunavut     647 4 621 22 70.2998 -83.1076 2021-05-27 04:20:59 Nunavut, Canada
1337988 2021-05-25 Canada Nunavut     640 4 623 13 70.2998 -83.1076 2021-05-26 04:20:35 Nunavut, Canada
202820 2021-05-24 Canada Nunavut     639 4 618 17 70.2998 -83.1076 2021-05-25 04:21:08 Nunavut, Canada
98984 2021-05-23 Canada Nunavut     638 4 606 28 70.2998 -83.1076 2021-05-24 04:20:53 Nunavut, Canada
523503 2021-05-22 Canada Nunavut     638 4 595 39 70.2998 -83.1076 2021-05-23 04:20:51 Nunavut, Canada
859198 2021-05-21 Canada Nunavut     637 4 588 45 70.2998 -83.1076 2021-05-22 04:20:45 Nunavut, Canada
720621 2021-05-20 Canada Nunavut     636 4 577 55 70.2998 -83.1076 2021-05-21 04:20:43 Nunavut, Canada
407752 2021-05-19 Canada Nunavut     634 4 567 63 70.2998 -83.1076 2021-05-20 04:21:05 Nunavut, Canada
782638 2021-05-18 Canada Nunavut     630 4 562 64 70.2998 -83.1076 2021-05-19 04:20:42 Nunavut, Canada
1422780 2021-05-17 Canada Nunavut     624 4 555 65 70.2998 -83.1076 2021-05-18 04:20:33 Nunavut, Canada
739966 2021-05-16 Canada Nunavut     624 4 552 68 70.2998 -83.1076 2021-05-17 04:20:34 Nunavut, Canada
1116499 2021-05-15 Canada Nunavut     623 4 545 74 70.2998 -83.1076 2021-05-16 04:20:49 Nunavut, Canada
1587008 2021-05-14 Canada Nunavut     618 4 536 78 70.2998 -83.1076 2021-05-15 04:20:58 Nunavut, Canada
1674925 2021-05-13 Canada Nunavut     606 4 528 74 70.2998 -83.1076 2021-05-14 04:20:41 Nunavut, Canada
802552 2021-05-12 Canada Nunavut     594 4 521 69 70.2998 -83.1076 2021-05-13 04:20:51 Nunavut, Canada
1180940 2021-05-11 Canada Nunavut     586 4 507 75 70.2998 -83.1076 2021-05-12 04:21:29 Nunavut, Canada
324730 2021-05-10 Canada Nunavut     572 4 498 70 70.2998 -83.1076 2021-05-11 04:20:41 Nunavut, Canada
603877 2021-05-09 Canada Nunavut     565 4 489 72 70.2998 -83.1076 2021-05-10 04:20:38 Nunavut, Canada
985624 2021-05-08 Canada Nunavut     560 4 482 74 70.2998 -83.1076 2021-05-09 04:20:35 Nunavut, Canada
434106 2021-05-07 Canada Nunavut     553 4 472 77 70.2998 -83.1076 2021-05-08 04:21:04 Nunavut, Canada
900887 2021-05-06 Canada Nunavut     552 4 462 86 70.2998 -83.1076 2021-05-07 04:20:40 Nunavut, Canada
71213 2021-05-05 Canada Nunavut     540 4 454 82 70.2998 -83.1076 2021-05-06 04:20:38 Nunavut, Canada
790606 2021-05-04 Canada Nunavut     535 4 446 85 70.2998 -83.1076 2021-05-05 04:20:43 Nunavut, Canada
1613136 2021-05-03 Canada Nunavut     528 4 439 85 70.2998 -83.1076 2021-05-04 04:20:34 Nunavut, Canada
885774 2021-05-02 Canada Nunavut     520 4 436 80 70.2998 -83.1076 2021-05-03 04:20:39 Nunavut, Canada
511479 2021-05-01 Canada Nunavut     509 4 432 73 70.2998 -83.1076 2021-05-02 04:20:48 Nunavut, Canada
14415 2021-04-30 Canada Nunavut     501 4 430 67 70.2998 -83.1076 2021-05-01 04:20:47 Nunavut, Canada
1124519 2021-04-29 Canada Nunavut     490 4 425 61 70.2998 -83.1076 2021-04-30 04:21:03 Nunavut, Canada
461816 2021-04-28 Canada Nunavut     478 4 424 50 70.2998 -83.1076 2021-04-29 04:20:55 Nunavut, Canada
1314522 2021-04-27 Canada Nunavut     472 4 419 49 70.2998 -83.1076 2021-04-28 04:20:32 Nunavut, Canada
1548949 2021-04-26 Canada Nunavut     464 4 413 47 70.2998 -83.1076 2021-04-27 04:20:52 Nunavut, Canada
1629416 2021-04-25 Canada Nunavut     455 4 404 47 70.2998 -83.1076 2021-04-26 04:21:04 Nunavut, Canada
353556 2021-04-24 Canada Nunavut     448 4 403 41 70.2998 -83.1076 2021-04-25 04:20:32 Nunavut, Canada
724605 2021-04-23 Canada Nunavut     441 4 400 37 70.2998 -83.1076 2021-04-24 04:20:38 Nunavut, Canada
1469617 2021-04-22 Canada Nunavut     432 4 392 36 70.2998 -83.1076 2021-04-23 04:20:52 Nunavut, Canada
1222365 2021-04-21 Canada Nunavut     429 4 392 33 70.2998 -83.1076 2021-04-22 04:20:53 Nunavut, Canada
457832 2021-04-20 Canada Nunavut     428 4 391 33 70.2998 -83.1076 2021-04-21 04:21:14 Nunavut, Canada
1300020 2021-04-19 Canada Nunavut     423 4 391 28 70.2998 -83.1076 2021-04-20 04:20:41 Nunavut, Canada
1069599 2021-04-18 Canada Nunavut     417 4 391 22 70.2998 -83.1076 2021-04-19 04:20:57 Nunavut, Canada
1045481 2021-04-17 Canada Nunavut     414 4 391 19 70.2998 -83.1076 2021-04-18 04:20:41 Nunavut, Canada
596757 2021-04-16 Canada Nunavut     408 4 391 13 70.2998 -83.1076 2021-04-17 04:20:40 Nunavut, Canada
1621173 2021-04-15 Canada Nunavut     396 4 391 1 70.2998 -83.1076 2021-04-16 04:20:46 Nunavut, Canada
950604 2021-04-14 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-15 04:20:54 Nunavut, Canada
592773 2021-04-13 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-14 04:20:41 Nunavut, Canada
32712 2021-04-12 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-13 04:20:37 Nunavut, Canada
1371727 2021-04-11 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-12 04:21:00 Nunavut, Canada
1666979 2021-04-10 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-11 04:20:56 Nunavut, Canada
1159595 2021-04-09 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-10 04:20:59 Nunavut, Canada
1057430 2021-04-08 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-09 04:21:13 Nunavut, Canada
1500219 2021-04-07 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-08 04:21:13 Nunavut, Canada
1207424 2021-04-06 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-07 04:20:53 Nunavut, Canada
122725 2021-04-05 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-06 04:20:32 Nunavut, Canada
1254526 2021-04-04 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-05 04:20:35 Nunavut, Canada
1128503 2021-04-03 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-04 04:20:49 Nunavut, Canada
269894 2021-04-02 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-03 04:20:44 Nunavut, Canada
1173226 2021-04-01 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-02 04:20:36 Nunavut, Canada
515537 2021-03-31 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-04-01 04:27:05 Nunavut, Canada
289266 2021-03-30 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-31 04:26:25 Nunavut, Canada
1574803 2021-03-29 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-30 04:26:23 Nunavut, Canada
631080 2021-03-28 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-29 04:28:35 Nunavut, Canada
607861 2021-03-27 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-28 05:28:10 Nunavut, Canada
1334004 2021-03-26 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-27 05:25:04 Nunavut, Canada
150443 2021-03-25 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-26 05:26:55 Nunavut, Canada
1597964 2021-03-24 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-25 05:27:00 Nunavut, Canada
403768 2021-03-23 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-24 05:25:40 Nunavut, Canada
1387305 2021-03-22 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-23 05:26:18 Nunavut, Canada
304792 2021-03-21 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-22 05:25:43 Nunavut, Canada
253841 2021-03-20 Canada Nunavut     395 4 391 0 70.2998 -83.1076 2021-03-21 05:25:44 Nunavut, Canada
1230597 2021-03-19 Canada Nunavut     395 4 389 2 70.2998 -83.1076 2021-03-20 05:25:46 Nunavut, Canada
974522 2021-03-18 Canada Nunavut     395 4 389 2 70.2998 -83.1076 2021-03-19 05:26:09 Nunavut, Canada
1532157 2021-03-17 Canada Nunavut     383 1 380 2 70.2998 -83.1076 2021-03-18 05:26:22 Nunavut, Canada
55351 2021-03-16 Canada Nunavut     383 1 380 2 70.2998 -83.1076 2021-03-17 05:25:07 Nunavut, Canada
562664 2021-03-15 Canada Nunavut     383 1 380 2 70.2998 -83.1076 2021-03-16 05:25:13 Nunavut, Canada
851233 2021-03-14 Canada Nunavut     383 1 374 8 70.2998 -83.1076 2021-03-15 05:25:51 Nunavut, Canada
942658 2021-03-13 Canada Nunavut     383 1 374 8 70.2998 -83.1076 2021-03-14 05:25:37 Nunavut, Canada
1310538 2021-03-12 Canada Nunavut     381 1 368 12 70.2998 -83.1076 2021-03-13 05:25:15 Nunavut, Canada
1077376 2021-03-11 Canada Nunavut     381 1 360 20 70.2998 -83.1076 2021-03-12 05:26:50 Nunavut, Canada
954588 2021-03-10 Canada Nunavut     381 1 358 22 70.2998 -83.1076 2021-03-11 05:25:48 Nunavut, Canada
543421 2021-03-09 Canada Nunavut     381 1 357 23 70.2998 -83.1076 2021-03-10 05:24:35 Nunavut, Canada
1520159 2021-03-08 Canada Nunavut     381 1 357 23 70.2998 -83.1076 2021-03-09 05:28:19 Nunavut, Canada
866440 2021-03-07 Canada Nunavut     381 1 355 25 70.2998 -83.1076 2021-03-08 05:24:48 Nunavut, 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]);