johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,188 rows where country_or_region = "New Zealand" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 2
- Cook Islands 1,073
- Niue 1,073
country_or_region 1
- New Zealand · 3,088 ✖
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
376313 | 376313 | 2020-11-06 | New Zealand | 1976 | 26 | 1908 | 43 | -40.9006 | 174.886 | 2020-11-07 05:24:52 | New Zealand | |||
380326 | 380326 | 2021-04-30 | New Zealand | 2613 | 28 | 2564 | 23 | -40.9006 | 174.886 | 2021-05-01 04:20:47 | New Zealand | |||
384363 | 384363 | 2022-09-23 | New Zealand | 1769694 | 1972 | 0 | -40.9006 | 174.886 | 2022-09-24 04:21:40 | New Zealand | ||||
388356 | 388356 | 2021-04-04 | New Zealand | 2507 | 28 | 2420 | 61 | -40.9006 | 174.886 | 2021-04-05 04:20:35 | New Zealand | |||
392367 | 392367 | 2020-11-27 | New Zealand | 2050 | 26 | 1956 | 69 | -40.9006 | 174.886 | 2020-11-28 05:25:50 | New Zealand | |||
396404 | 396404 | 2022-10-07 | New Zealand | 1789425 | 2038 | 0 | -40.9006 | 174.886 | 2022-10-08 04:22:56 | New Zealand | ||||
400399 | 400399 | 2021-06-29 | New Zealand | 2742 | 28 | 2685 | 31 | -40.9006 | 174.886 | 2021-06-30 04:21:41 | New Zealand | |||
404430 | 404430 | 2021-12-07 | New Zealand | 12516 | 42 | 0 | -40.9006 | 174.886 | 2021-12-08 04:22:46 | New Zealand | ||||
408429 | 408429 | 2021-07-28 | New Zealand | 2867 | 28 | 2795 | 46 | -40.9006 | 174.886 | 2021-07-29 04:21:33 | New Zealand | |||
415738 | 415738 | 2020-07-05 | New Zealand | 1534 | 23 | 1490 | 22 | -40.9006 | 174.886 | 2020-07-06 04:33:57 | New Zealand | |||
418906 | 418906 | 2020-04-18 | New Zealand | 1422 | 12 | 867 | 544 | -40.9006 | 174.886 | 2020-04-18 22:32:28 | New Zealand | |||
419475 | 419475 | 2022-09-18 | New Zealand | 1762125 | 1962 | 0 | -40.9006 | 174.886 | 2022-09-19 04:21:49 | New Zealand | ||||
423487 | 423487 | 2021-10-10 | New Zealand | 4659 | 30 | 0 | -40.9006 | 174.886 | 2021-10-11 04:21:31 | New Zealand | ||||
427466 | 427466 | 2020-09-07 | New Zealand | 1782 | 25 | 1635 | 123 | -40.9006 | 174.886 | 2020-09-08 04:28:25 | New Zealand | |||
431497 | 431497 | 2022-11-03 | New Zealand | 1851689 | 2106 | 0 | -40.9006 | 174.886 | 2022-11-04 04:22:11 | New Zealand | ||||
435489 | 435489 | 2021-01-21 | New Zealand | 2276 | 27 | 2178 | 73 | -40.9006 | 174.886 | 2021-01-22 05:22:10 | New Zealand | |||
442926 | 442926 | 2020-07-26 | New Zealand | 1556 | 23 | 1513 | 21 | -40.9006 | 174.886 | 2020-07-27 04:35:02 | New Zealand | |||
443491 | 443491 | 2021-10-20 | New Zealand | 5315 | 30 | 0 | -40.9006 | 174.886 | 2021-10-21 04:21:18 | New Zealand | ||||
447507 | 447507 | 2021-11-17 | New Zealand | 9452 | 36 | 0 | -40.9006 | 174.886 | 2021-11-18 04:21:33 | New Zealand | ||||
451527 | 451527 | 2022-12-21 | New Zealand | 2062384 | 2288 | 0 | -40.9006 | 174.886 | 2022-12-22 04:20:56 | New Zealand | ||||
458953 | 458953 | 2020-08-07 | New Zealand | 1569 | 23 | 1524 | 23 | -40.9006 | 174.886 | 2020-08-08 04:34:53 | New Zealand | |||
459516 | 459516 | 2022-02-02 | New Zealand | 17005 | 52 | 0 | -40.9006 | 174.886 | 2022-02-03 04:21:21 | New Zealand | ||||
463533 | 463533 | 2022-05-02 | New Zealand | 952697 | 697 | 0 | -40.9006 | 174.886 | 2022-05-03 04:21:00 | New Zealand | ||||
467548 | 467548 | 2021-10-07 | New Zealand | 4527 | 30 | 0 | -40.9006 | 174.886 | 2021-10-08 04:21:25 | New Zealand | ||||
471545 | 471545 | 2021-02-19 | New Zealand | 2350 | 28 | 2273 | 51 | -40.9006 | 174.886 | 2021-02-20 05:22:51 | New Zealand | |||
475580 | 475580 | 2022-06-26 | New Zealand | 1314145 | 1106 | 0 | -40.9006 | 174.886 | 2022-06-27 04:21:00 | New Zealand | ||||
479208 | 479208 | 2020-02-25 | New Zealand | 0 | 0 | 0 | 2020-02-25T12:13:14 | |||||||
479730 | 479730 | 2022-11-08 | New Zealand | 1872459 | 2119 | 0 | -40.9006 | 174.886 | 2022-11-09 04:21:22 | New Zealand | ||||
483725 | 483725 | 2021-07-19 | New Zealand | 2822 | 28 | 2745 | 51 | -40.9006 | 174.886 | 2021-07-20 04:21:48 | New Zealand | |||
487760 | 487760 | 2022-11-25 | New Zealand | 1918070 | 2182 | 0 | -40.9006 | 174.886 | 2022-11-26 04:21:11 | New Zealand | ||||
491772 | 491772 | 2021-10-14 | New Zealand | 4897 | 30 | 0 | -40.9006 | 174.886 | 2021-10-15 04:21:26 | New Zealand | ||||
495788 | 495788 | 2021-11-06 | New Zealand | 7456 | 31 | 0 | -40.9006 | 174.886 | 2021-11-07 04:21:53 | New Zealand | ||||
499805 | 499805 | 2022-04-02 | New Zealand | 693219 | 365 | 0 | -40.9006 | 174.886 | 2022-04-03 04:20:48 | New Zealand | ||||
503824 | 503824 | 2022-12-17 | New Zealand | 2019685 | 2257 | 0 | -40.9006 | 174.886 | 2022-12-18 04:21:03 | New Zealand | ||||
507819 | 507819 | 2021-08-14 | New Zealand | 2919 | 28 | 0 | -40.9006 | 174.886 | 2021-08-15 04:21:41 | New Zealand | ||||
511833 | 511833 | 2021-08-19 | New Zealand | 2968 | 28 | 0 | -40.9006 | 174.886 | 2021-08-20 04:21:33 | New Zealand | ||||
515868 | 515868 | 2022-10-15 | New Zealand | 1800602 | 2055 | 0 | -40.9006 | 174.886 | 2022-10-16 04:22:39 | New Zealand | ||||
522444 | 522444 | 2020-04-21 | New Zealand | 1445 | 18 | 1006 | 426 | -40.9006 | 174.886 | 2020-04-21 23:30:30 | New Zealand | |||
522991 | 522991 | 2021-06-09 | New Zealand | 2697 | 28 | 2647 | 24 | -40.9006 | 174.886 | 2021-06-10 04:23:17 | New Zealand | |||
530300 | 530300 | 2020-07-04 | New Zealand | 1533 | 23 | 1490 | 21 | -40.9006 | 174.886 | 2020-07-05 04:33:46 | New Zealand | |||
530839 | 530839 | 2021-02-22 | New Zealand | 2363 | 28 | 2277 | 60 | -40.9006 | 174.886 | 2021-02-23 05:23:41 | New Zealand | |||
534872 | 534872 | 2021-10-27 | New Zealand | 5995 | 30 | 0 | -40.9006 | 174.886 | 2021-10-28 04:22:08 | New Zealand | ||||
538892 | 538892 | 2022-10-26 | New Zealand | 1831233 | 2095 | 0 | -40.9006 | 174.886 | 2022-10-27 04:22:01 | New Zealand | ||||
542908 | 542908 | 2022-12-15 | New Zealand | 2019685 | 2257 | 0 | -40.9006 | 174.886 | 2022-12-16 04:21:01 | New Zealand | ||||
546883 | 546883 | 2020-09-12 | New Zealand | 1797 | 25 | 1676 | 97 | -40.9006 | 174.886 | 2020-09-13 04:30:52 | New Zealand | |||
550910 | 550910 | 2021-12-08 | New Zealand | 12621 | 42 | 0 | -40.9006 | 174.886 | 2021-12-09 04:22:49 | New Zealand | ||||
554926 | 554926 | 2022-01-16 | New Zealand | 15127 | 51 | 0 | -40.9006 | 174.886 | 2022-01-17 04:21:08 | New Zealand | ||||
558944 | 558944 | 2022-06-16 | New Zealand | 1265455 | 993 | 0 | -40.9006 | 174.886 | 2022-06-17 04:20:56 | New Zealand | ||||
562599 | 562599 | 2020-03-01 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
563102 | 563102 | 2021-06-22 | New Zealand | 2723 | 28 | 2673 | 24 | -40.9006 | 174.886 | 2021-06-23 04:21:46 | New Zealand | |||
567240 | 567240 | 2021-10-29 | New Zealand | 6285 | 30 | 0 | -40.9006 | 174.886 | 2021-10-30 04:22:03 | New Zealand | ||||
574405 | 574405 | 2020-06-06 | New Zealand | 1504 | 23 | 1481 | 1 | -40.9006 | 174.886 | 2020-06-07 03:53:30 | New Zealand | |||
574969 | 574969 | 2022-02-25 | New Zealand | 71122 | 64 | 0 | -40.9006 | 174.886 | 2022-02-26 04:21:12 | New Zealand | ||||
578967 | 578967 | 2021-07-13 | New Zealand | 2790 | 28 | 2722 | 42 | -40.9006 | 174.886 | 2021-07-14 04:21:35 | New Zealand | |||
582961 | 582961 | 2020-08-13 | New Zealand | 1602 | 23 | 1531 | 49 | -40.9006 | 174.886 | 2020-08-14 04:51:19 | New Zealand | |||
589216 | 589216 | 2020-04-05 | New Zealand | 1039 | 4 | 156 | 882 | -40.9006 | 174.886 | 2020-04-05 23:06:26 | New Zealand | |||
589763 | 589763 | 2021-08-08 | New Zealand | 2890 | 28 | 0 | -40.9006 | 174.886 | 2021-08-09 04:21:24 | New Zealand | ||||
593796 | 593796 | 2022-07-01 | New Zealand | 1352688 | 1106 | 0 | -40.9006 | 174.886 | 2022-07-02 04:21:16 | New Zealand | ||||
597810 | 597810 | 2021-10-19 | New Zealand | 5213 | 30 | 0 | -40.9006 | 174.886 | 2021-10-20 04:21:00 | New Zealand | ||||
601826 | 601826 | 2021-09-23 | New Zealand | 4144 | 29 | 0 | -40.9006 | 174.886 | 2021-09-24 04:21:44 | New Zealand | ||||
605822 | 605822 | 2021-04-09 | New Zealand | 2571 | 28 | 2440 | 105 | -40.9006 | 174.886 | 2021-04-10 04:20:59 | New Zealand | |||
609818 | 609818 | 2020-08-29 | New Zealand | 1729 | 23 | 1570 | 137 | -40.9006 | 174.886 | 2020-08-30 04:28:22 | New Zealand | |||
613821 | 613821 | 2021-02-08 | New Zealand | 2322 | 28 | 2230 | 67 | -40.9006 | 174.886 | 2021-02-09 05:23:30 | New Zealand | |||
617479 | 617479 | 2020-02-27 | New Zealand | 0 | 0 | 0 | 2020-02-27T12:13:10 | |||||||
618002 | 618002 | 2022-11-05 | New Zealand | 1851689 | 2106 | 0 | -40.9006 | 174.886 | 2022-11-06 04:21:24 | New Zealand | ||||
622016 | 622016 | 2022-05-22 | New Zealand | 1129749 | 845 | 0 | -40.9006 | 174.886 | 2022-05-26 04:20:50 | New Zealand | ||||
626013 | 626013 | 2021-07-10 | New Zealand | 2767 | 28 | 2707 | 34 | -40.9006 | 174.886 | 2021-07-11 04:21:43 | New Zealand | |||
630046 | 630046 | 2022-07-12 | New Zealand | 1462257 | 1304 | 0 | -40.9006 | 174.886 | 2022-07-13 04:20:58 | New Zealand | ||||
634060 | 634060 | 2021-10-13 | New Zealand | 4831 | 30 | 0 | -40.9006 | 174.886 | 2021-10-14 04:21:29 | New Zealand | ||||
638057 | 638057 | 2021-03-31 | New Zealand | 2501 | 28 | 2408 | 67 | -40.9006 | 174.886 | 2021-04-01 04:27:05 | New Zealand | |||
642073 | 642073 | 2021-09-07 | New Zealand | 3829 | 29 | 0 | -40.9006 | 174.886 | 2021-09-08 04:21:31 | New Zealand | ||||
646085 | 646085 | 2021-05-05 | New Zealand | 2633 | 28 | 2579 | 28 | -40.9006 | 174.886 | 2021-05-06 04:20:38 | New Zealand | |||
650101 | 650101 | 2021-08-09 | New Zealand | 2902 | 28 | 0 | -40.9006 | 174.886 | 2021-08-10 04:21:27 | New Zealand | ||||
654132 | 654132 | 2021-10-22 | New Zealand | 5554 | 30 | 0 | -40.9006 | 174.886 | 2021-10-23 04:21:32 | New Zealand | ||||
657804 | 657804 | 2020-03-09 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
658451 | 658451 | 2022-05-13 | New Zealand | 1037855 | 750 | 0 | -40.9006 | 174.886 | 2022-05-14 04:20:48 | New Zealand | ||||
662429 | 662429 | 2020-08-11 | New Zealand | 1570 | 23 | 1526 | 22 | -40.9006 | 174.886 | 2020-08-12 04:27:29 | New Zealand | |||
666408 | 666408 | 2020-09-16 | New Zealand | 1809 | 26 | 1707 | 77 | -40.9006 | 174.886 | 2020-09-17 04:22:00 | New Zealand | |||
670437 | 670437 | 2022-07-21 | New Zealand | 1549589 | 1410 | 0 | -40.9006 | 174.886 | 2022-07-22 04:21:15 | New Zealand | ||||
674453 | 674453 | 2022-07-30 | New Zealand | 1616341 | 1502 | 0 | -40.9006 | 174.886 | 2022-07-31 04:21:02 | New Zealand | ||||
678444 | 678444 | 2020-11-23 | New Zealand | 2031 | 26 | 1953 | 53 | -40.9006 | 174.886 | 2020-11-24 05:27:31 | New Zealand | |||
682477 | 682477 | 2021-10-24 | New Zealand | 5749 | 30 | 0 | -40.9006 | 174.886 | 2021-10-25 04:22:31 | New Zealand | ||||
686493 | 686493 | 2021-11-13 | New Zealand | 8692 | 31 | 0 | -40.9006 | 174.886 | 2021-11-14 04:21:31 | New Zealand | ||||
690513 | 690513 | 2022-12-23 | New Zealand | 2062384 | 2288 | 0 | -40.9006 | 174.886 | 2022-12-24 04:21:02 | New Zealand | ||||
694526 | 694526 | 2022-03-17 | New Zealand | 452670 | 180 | 0 | -40.9006 | 174.886 | 2022-03-18 04:20:55 | New Zealand | ||||
698541 | 698541 | 2021-11-04 | New Zealand | 7138 | 31 | 0 | -40.9006 | 174.886 | 2021-11-05 04:21:54 | New Zealand | ||||
702538 | 702538 | 2021-03-16 | New Zealand | 2434 | 28 | 2311 | 97 | -40.9006 | 174.886 | 2021-03-17 05:25:07 | New Zealand | |||
706571 | 706571 | 2021-09-29 | New Zealand | 4273 | 29 | 0 | -40.9006 | 174.886 | 2021-09-30 04:21:20 | New Zealand | ||||
710590 | 710590 | 2022-11-01 | New Zealand | 1851689 | 2106 | 0 | -40.9006 | 174.886 | 2022-11-02 04:22:09 | New Zealand | ||||
714602 | 714602 | 2021-11-12 | New Zealand | 8482 | 31 | 0 | -40.9006 | 174.886 | 2021-11-13 04:21:38 | New Zealand | ||||
718622 | 718622 | 2022-12-04 | New Zealand | 1979614 | 2235 | 0 | -40.9006 | 174.886 | 2022-12-05 04:20:58 | New Zealand | ||||
722634 | 722634 | 2021-11-20 | New Zealand | 9972 | 36 | 0 | -40.9006 | 174.886 | 2021-11-21 04:22:13 | New Zealand | ||||
726631 | 726631 | 2021-05-22 | New Zealand | 2668 | 28 | 2615 | 27 | -40.9006 | 174.886 | 2021-05-23 04:20:51 | New Zealand | |||
730664 | 730664 | 2021-12-27 | New Zealand | 13932 | 48 | 0 | -40.9006 | 174.886 | 2021-12-28 04:21:47 | New Zealand | ||||
737898 | 737898 | 2020-06-12 | New Zealand | 1504 | 23 | 1482 | 0 | -40.9006 | 174.886 | 2020-06-13 03:33:14 | New Zealand | |||
738433 | 738433 | 2020-12-02 | New Zealand | 2069 | 26 | 1974 | 70 | -40.9006 | 174.886 | 2020-12-03 05:28:22 | New Zealand | |||
742447 | 742447 | 2021-02-20 | New Zealand | 2350 | 28 | 2273 | 51 | -40.9006 | 174.886 | 2021-02-21 05:24:33 | New Zealand | |||
746481 | 746481 | 2022-04-23 | New Zealand | 884289 | 585 | 0 | -40.9006 | 174.886 | 2022-04-24 04:20:56 | New Zealand | ||||
753907 | 753907 | 2020-08-01 | New Zealand | 1565 | 23 | 1518 | 25 | -40.9006 | 174.886 | 2020-08-02 04:34:47 | New Zealand | |||
754433 | 754433 | 2020-10-28 | New Zealand | 1949 | 26 | 1854 | 70 | -40.9006 | 174.886 | 2020-10-29 04:24:49 | New Zealand |
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]);