johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,011 rows where country_or_region = "Canada" and province_or_state = "Northwest Territories" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
392007 | 392007 | 2020-11-27 | Canada | Northwest Territories | 15 | 0 | 15 | 0 | 64.8255 | -124.8457 | 2020-11-28 05:25:50 | Northwest Territories,Canada | ||
396019 | 396019 | 2022-10-07 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-10-08 04:22:56 | Northwest Territories,Canada | |||
400034 | 400034 | 2021-06-29 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-30 04:21:41 | Northwest Territories,Canada | ||
404048 | 404048 | 2021-12-07 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-08 04:22:46 | Northwest Territories,Canada | |||
408064 | 408064 | 2021-07-28 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-29 04:21:33 | Northwest Territories,Canada | ||
415429 | 415429 | 2020-07-05 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-07-06 04:33:57 | Northwest Territories, Canada | ||
418754 | 418754 | 2020-04-18 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-04-18 22:40:03 | Northwest Territories, Canada | ||
419090 | 419090 | 2022-09-18 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-09-19 04:21:49 | Northwest Territories,Canada | |||
423105 | 423105 | 2021-10-10 | Canada | Northwest Territories | 1456 | 6 | 0 | 64.8255 | -124.8457 | 2021-10-11 04:21:31 | Northwest Territories,Canada | |||
427110 | 427110 | 2020-09-07 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-08 04:28:25 | Northwest Territories,Canada | ||
431112 | 431112 | 2022-11-03 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-11-04 04:22:11 | Northwest Territories,Canada | |||
435127 | 435127 | 2021-01-21 | Canada | Northwest Territories | 31 | 0 | 24 | 7 | 64.8255 | -124.8457 | 2021-01-22 05:22:10 | Northwest Territories,Canada | ||
442615 | 442615 | 2020-07-26 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-07-27 04:35:02 | Northwest Territories, Canada | ||
443109 | 443109 | 2021-10-20 | Canada | Northwest Territories | 1712 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-21 04:21:18 | Northwest Territories,Canada | |||
447125 | 447125 | 2021-11-17 | Canada | Northwest Territories | 2029 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-18 04:21:33 | Northwest Territories,Canada | |||
451142 | 451142 | 2022-12-21 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-22 04:20:56 | Northwest Territories,Canada | |||
458641 | 458641 | 2020-08-07 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-08 04:34:53 | Northwest Territories, Canada | ||
459134 | 459134 | 2022-02-02 | Canada | Northwest Territories | 6221 | 15 | 0 | 64.8255 | -124.8457 | 2022-02-03 04:21:21 | Northwest Territories,Canada | |||
463151 | 463151 | 2022-05-02 | Canada | Northwest Territories | 11373 | 22 | 0 | 64.8255 | -124.8457 | 2022-05-03 04:21:00 | Northwest Territories,Canada | |||
467166 | 467166 | 2021-10-07 | Canada | Northwest Territories | 1360 | 6 | 0 | 64.8255 | -124.8457 | 2021-10-08 04:21:25 | Northwest Territories,Canada | |||
471182 | 471182 | 2021-02-19 | Canada | Northwest Territories | 42 | 0 | 39 | 8 | 64.8255 | -124.8457 | 2021-02-20 05:22:51 | Northwest Territories,Canada | ||
475197 | 475197 | 2022-06-26 | Canada | Northwest Territories | 11499 | 22 | 0 | 64.8255 | -124.8457 | 2022-06-27 04:21:00 | Northwest Territories,Canada | |||
479345 | 479345 | 2022-11-08 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-11-09 04:21:22 | Northwest Territories,Canada | |||
483360 | 483360 | 2021-07-19 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-20 04:21:48 | Northwest Territories,Canada | ||
487375 | 487375 | 2022-11-25 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-11-26 04:21:11 | Northwest Territories,Canada | |||
491390 | 491390 | 2021-10-14 | Canada | Northwest Territories | 1580 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-15 04:21:26 | Northwest Territories,Canada | |||
495406 | 495406 | 2021-11-06 | Canada | Northwest Territories | 1886 | 11 | 0 | 64.8255 | -124.8457 | 2021-11-07 04:21:53 | Northwest Territories,Canada | |||
499423 | 499423 | 2022-04-02 | Canada | Northwest Territories | 10951 | 21 | 0 | 64.8255 | -124.8457 | 2022-04-03 04:20:48 | Northwest Territories,Canada | |||
503439 | 503439 | 2022-12-17 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-18 04:21:03 | Northwest Territories,Canada | |||
507454 | 507454 | 2021-08-14 | Canada | Northwest Territories | 131 | 0 | 0 | 64.8255 | -124.8457 | 2021-08-15 04:21:41 | Northwest Territories,Canada | |||
511468 | 511468 | 2021-08-19 | Canada | Northwest Territories | 259 | 0 | 0 | 64.8255 | -124.8457 | 2021-08-20 04:21:33 | Northwest Territories,Canada | |||
515483 | 515483 | 2022-10-15 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-10-16 04:22:39 | Northwest Territories,Canada | |||
522292 | 522292 | 2020-04-21 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-04-21 23:38:53 | Northwest Territories, Canada | ||
522627 | 522627 | 2021-06-09 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-10 04:23:17 | Northwest Territories,Canada | ||
529991 | 529991 | 2020-07-04 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-07-05 04:33:46 | Northwest Territories, Canada | ||
530476 | 530476 | 2021-02-22 | Canada | Northwest Territories | 42 | 0 | 42 | 5 | 64.8255 | -124.8457 | 2021-02-23 05:23:41 | Northwest Territories,Canada | ||
534490 | 534490 | 2021-10-27 | Canada | Northwest Territories | 1843 | 10 | 0 | 64.8255 | -124.8457 | 2021-10-28 04:22:08 | Northwest Territories,Canada | |||
538507 | 538507 | 2022-10-26 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-10-27 04:22:01 | Northwest Territories,Canada | |||
542523 | 542523 | 2022-12-15 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-16 04:21:01 | Northwest Territories,Canada | |||
546527 | 546527 | 2020-09-12 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-13 04:30:52 | Northwest Territories,Canada | ||
550528 | 550528 | 2021-12-08 | Canada | Northwest Territories | 2069 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-09 04:22:49 | Northwest Territories,Canada | |||
554544 | 554544 | 2022-01-16 | Canada | Northwest Territories | 3741 | 12 | 0 | 64.8255 | -124.8457 | 2022-01-17 04:21:08 | Northwest Territories,Canada | |||
558561 | 558561 | 2022-06-16 | Canada | Northwest Territories | 11495 | 22 | 0 | 64.8255 | -124.8457 | 2022-06-17 04:20:56 | Northwest Territories,Canada | |||
562737 | 562737 | 2021-06-22 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-06-23 04:21:46 | Northwest Territories,Canada | ||
566858 | 566858 | 2021-10-29 | Canada | Northwest Territories | 1863 | 11 | 0 | 64.8255 | -124.8457 | 2021-10-30 04:22:03 | Northwest Territories,Canada | |||
574110 | 574110 | 2020-06-06 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-07 03:53:30 | Northwest Territories, Canada | ||
574587 | 574587 | 2022-02-25 | Canada | Northwest Territories | 8682 | 19 | 0 | 64.8255 | -124.8457 | 2022-02-26 04:21:12 | Northwest Territories,Canada | |||
578602 | 578602 | 2021-07-13 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-14 04:21:35 | Northwest Territories,Canada | ||
582605 | 582605 | 2020-08-13 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-14 04:51:19 | Northwest Territories,Canada | ||
589064 | 589064 | 2020-04-05 | Canada | Northwest Territories | 4 | 0 | 0 | 4 | 64.8255 | -124.8457 | 2020-04-05 23:13:28 | ,Northwest Territories,Canada | ||
589398 | 589398 | 2021-08-08 | Canada | Northwest Territories | 130 | 0 | 0 | 64.8255 | -124.8457 | 2021-08-09 04:21:24 | Northwest Territories,Canada | |||
593413 | 593413 | 2022-07-01 | Canada | Northwest Territories | 11499 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-02 04:21:16 | Northwest Territories,Canada | |||
597428 | 597428 | 2021-10-19 | Canada | Northwest Territories | 1694 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-20 04:21:00 | Northwest Territories,Canada | |||
601444 | 601444 | 2021-09-23 | Canada | Northwest Territories | 852 | 2 | 0 | 64.8255 | -124.8457 | 2021-09-24 04:21:44 | Northwest Territories,Canada | |||
605459 | 605459 | 2021-04-09 | Canada | Northwest Territories | 43 | 0 | 48 | 1 | 64.8255 | -124.8457 | 2021-04-10 04:20:59 | Northwest Territories,Canada | ||
609462 | 609462 | 2020-08-29 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-30 04:28:22 | Northwest Territories,Canada | ||
613459 | 613459 | 2021-02-08 | Canada | Northwest Territories | 32 | 0 | 31 | 7 | 64.8255 | -124.8457 | 2021-02-09 05:23:30 | Northwest Territories,Canada | ||
617617 | 617617 | 2022-11-05 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-11-06 04:21:24 | Northwest Territories,Canada | |||
621633 | 621633 | 2022-05-22 | Canada | Northwest Territories | 11426 | 22 | 0 | 64.8255 | -124.8457 | 2022-05-26 04:20:50 | Northwest Territories,Canada | |||
625648 | 625648 | 2021-07-10 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-11 04:21:43 | Northwest Territories,Canada | ||
629663 | 629663 | 2022-07-12 | Canada | Northwest Territories | 11499 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-13 04:20:58 | Northwest Territories,Canada | |||
633678 | 633678 | 2021-10-13 | Canada | Northwest Territories | 1537 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-14 04:21:29 | Northwest Territories,Canada | |||
637694 | 637694 | 2021-03-31 | Canada | Northwest Territories | 42 | 0 | 47 | 0 | 64.8255 | -124.8457 | 2021-04-01 04:27:05 | Northwest Territories,Canada | ||
641708 | 641708 | 2021-09-07 | Canada | Northwest Territories | 499 | 1 | 0 | 64.8255 | -124.8457 | 2021-09-08 04:21:31 | Northwest Territories,Canada | |||
645722 | 645722 | 2021-05-05 | Canada | Northwest Territories | 85 | 0 | 57 | 34 | 64.8255 | -124.8457 | 2021-05-06 04:20:38 | Northwest Territories,Canada | ||
649736 | 649736 | 2021-08-09 | Canada | Northwest Territories | 130 | 0 | 0 | 64.8255 | -124.8457 | 2021-08-10 04:21:27 | Northwest Territories,Canada | |||
653750 | 653750 | 2021-10-22 | Canada | Northwest Territories | 1763 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-23 04:21:32 | Northwest Territories,Canada | |||
658069 | 658069 | 2022-05-13 | Canada | Northwest Territories | 11426 | 22 | 0 | 64.8255 | -124.8457 | 2022-05-14 04:20:48 | Northwest Territories,Canada | |||
662073 | 662073 | 2020-08-11 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-12 04:27:29 | Northwest Territories,Canada | ||
666052 | 666052 | 2020-09-16 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-09-17 04:22:00 | Northwest Territories,Canada | ||
670054 | 670054 | 2022-07-21 | Canada | Northwest Territories | 11506 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-22 04:21:15 | Northwest Territories,Canada | |||
674070 | 674070 | 2022-07-30 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-07-31 04:21:02 | Northwest Territories,Canada | |||
678085 | 678085 | 2020-11-23 | Canada | Northwest Territories | 15 | 0 | 13 | 2 | 64.8255 | -124.8457 | 2020-11-24 05:27:31 | Northwest Territories,Canada | ||
682095 | 682095 | 2021-10-24 | Canada | Northwest Territories | 1786 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-25 04:22:31 | Northwest Territories,Canada | |||
686111 | 686111 | 2021-11-13 | Canada | Northwest Territories | 2001 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-14 04:21:31 | Northwest Territories,Canada | |||
690128 | 690128 | 2022-12-23 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-24 04:21:02 | Northwest Territories,Canada | |||
694144 | 694144 | 2022-03-17 | Canada | Northwest Territories | 9790 | 20 | 0 | 64.8255 | -124.8457 | 2022-03-18 04:20:55 | Northwest Territories,Canada | |||
698159 | 698159 | 2021-11-04 | Canada | Northwest Territories | 1886 | 11 | 0 | 64.8255 | -124.8457 | 2021-11-05 04:21:54 | Northwest Territories,Canada | |||
702175 | 702175 | 2021-03-16 | Canada | Northwest Territories | 42 | 0 | 46 | 1 | 64.8255 | -124.8457 | 2021-03-17 05:25:07 | Northwest Territories,Canada | ||
706189 | 706189 | 2021-09-29 | Canada | Northwest Territories | 1019 | 6 | 0 | 64.8255 | -124.8457 | 2021-09-30 04:21:20 | Northwest Territories,Canada | |||
710205 | 710205 | 2022-11-01 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-11-02 04:22:09 | Northwest Territories,Canada | |||
714220 | 714220 | 2021-11-12 | Canada | Northwest Territories | 1951 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-13 04:21:38 | Northwest Territories,Canada | |||
718237 | 718237 | 2022-12-04 | Canada | Northwest Territories | 11511 | 22 | 0 | 64.8255 | -124.8457 | 2022-12-02 18:21:06 | Northwest Territories,Canada | |||
722252 | 722252 | 2021-11-20 | Canada | Northwest Territories | 2036 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-21 04:22:13 | Northwest Territories,Canada | |||
726268 | 726268 | 2021-05-22 | Canada | Northwest Territories | 127 | 0 | 118 | 9 | 64.8255 | -124.8457 | 2021-05-23 04:20:51 | Northwest Territories,Canada | ||
730282 | 730282 | 2021-12-27 | Canada | Northwest Territories | 2090 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-28 04:21:47 | Northwest Territories,Canada | |||
737588 | 737588 | 2020-06-12 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-06-13 03:33:14 | Northwest Territories, Canada | ||
738073 | 738073 | 2020-12-02 | Canada | Northwest Territories | 15 | 0 | 15 | 0 | 64.8255 | -124.8457 | 2020-12-03 05:28:22 | Northwest Territories,Canada | ||
742084 | 742084 | 2021-02-20 | Canada | Northwest Territories | 42 | 0 | 39 | 8 | 64.8255 | -124.8457 | 2021-02-21 05:24:33 | Northwest Territories,Canada | ||
746099 | 746099 | 2022-04-23 | Canada | Northwest Territories | 11217 | 22 | 0 | 64.8255 | -124.8457 | 2022-04-24 04:20:56 | Northwest Territories,Canada | |||
753595 | 753595 | 2020-08-01 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-08-02 04:34:47 | Northwest Territories, Canada | ||
754075 | 754075 | 2020-10-28 | Canada | Northwest Territories | 9 | 0 | 8 | 1 | 64.8255 | -124.8457 | 2020-10-29 04:24:49 | Northwest Territories,Canada | ||
758082 | 758082 | 2021-11-26 | Canada | Northwest Territories | 2059 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-27 04:22:45 | Northwest Territories,Canada | |||
762087 | 762087 | 2020-10-18 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-10-19 04:24:16 | Northwest Territories,Canada | ||
766092 | 766092 | 2020-12-29 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2020-12-30 05:22:34 | Northwest Territories,Canada | ||
770103 | 770103 | 2021-10-23 | Canada | Northwest Territories | 1786 | 9 | 0 | 64.8255 | -124.8457 | 2021-10-24 04:21:22 | Northwest Territories,Canada | |||
774119 | 774119 | 2021-01-12 | Canada | Northwest Territories | 24 | 0 | 24 | 0 | 64.8255 | -124.8457 | 2021-01-13 05:22:15 | Northwest Territories,Canada | ||
778131 | 778131 | 2021-07-08 | Canada | Northwest Territories | 128 | 0 | 128 | 0 | 64.8255 | -124.8457 | 2021-07-09 04:21:21 | Northwest Territories,Canada | ||
782145 | 782145 | 2021-12-13 | Canada | Northwest Territories | 2071 | 12 | 0 | 64.8255 | -124.8457 | 2021-12-14 04:22:38 | Northwest Territories,Canada | |||
786150 | 786150 | 2020-10-15 | Canada | Northwest Territories | 5 | 0 | 5 | 0 | 64.8255 | -124.8457 | 2020-10-16 04:24:01 | Northwest Territories,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]);