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 recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, latitude, longitude, combined_key, day (date), last_update (date)
province_or_state 2
- Cook Islands 1,073
- Niue 1,073
country_or_region 1
- New Zealand · 3,188 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
332041 | 332041 | 2021-08-04 | New Zealand | 2880 | 28 | 2824 | 30 | -40.9006 | 174.886 | 2021-08-05 04:21:51 | New Zealand | |||
3468312 | 3468312 | 2021-08-03 | New Zealand | 2879 | 28 | 2824 | 29 | -40.9006 | 174.886 | 2021-08-04 04:21:25 | New Zealand | |||
3683586 | 3683586 | 2021-08-02 | New Zealand | 2877 | 28 | 2821 | 30 | -40.9006 | 174.886 | 2021-08-03 04:21:39 | New Zealand | |||
3015485 | 3015485 | 2021-08-01 | New Zealand | 2877 | 28 | 2814 | 37 | -40.9006 | 174.886 | 2021-08-02 04:21:36 | New Zealand | |||
3904108 | 3904108 | 2021-07-31 | New Zealand | 2873 | 28 | 2811 | 36 | -40.9006 | 174.886 | 2021-08-01 04:21:50 | New Zealand | |||
3296313 | 3296313 | 2021-07-30 | New Zealand | 2870 | 28 | 2799 | 45 | -40.9006 | 174.886 | 2021-07-31 04:21:35 | New Zealand | |||
3385524 | 3385524 | 2021-07-29 | New Zealand | 2870 | 28 | 2799 | 45 | -40.9006 | 174.886 | 2021-07-30 04:21:34 | 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 | |||
1306290 | 1306290 | 2021-07-27 | New Zealand | 2864 | 28 | 2795 | 43 | -40.9006 | 174.886 | 2021-07-28 04:21:39 | New Zealand | |||
3218433 | 3218433 | 2021-07-26 | New Zealand | 2863 | 28 | 2785 | 52 | -40.9006 | 174.886 | 2021-07-27 04:21:18 | New Zealand | |||
1378642 | 1378642 | 2021-07-25 | New Zealand | 2863 | 28 | 2783 | 54 | -40.9006 | 174.886 | 2021-07-26 04:21:28 | New Zealand | |||
1330382 | 1330382 | 2021-07-24 | New Zealand | 2862 | 28 | 2778 | 58 | -40.9006 | 174.886 | 2021-07-25 04:22:12 | New Zealand | |||
3137686 | 3137686 | 2021-07-23 | New Zealand | 2855 | 28 | 2749 | 80 | -40.9006 | 174.886 | 2021-07-24 00:21:36 | New Zealand | |||
3476446 | 3476446 | 2021-07-22 | New Zealand | 2855 | 28 | 2749 | 80 | -40.9006 | 174.886 | 2021-07-23 04:21:29 | New Zealand | |||
3331665 | 3331665 | 2021-07-21 | New Zealand | 2835 | 28 | 2747 | 62 | -40.9006 | 174.886 | 2021-07-22 04:21:19 | New Zealand | |||
2371646 | 2371646 | 2021-07-20 | New Zealand | 2828 | 28 | 2746 | 56 | -40.9006 | 174.886 | 2021-07-21 04:21:40 | 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 | |||
2673948 | 2673948 | 2021-07-18 | New Zealand | 2817 | 28 | 2744 | 47 | -40.9006 | 174.886 | 2021-07-19 04:21:24 | New Zealand | |||
3706260 | 3706260 | 2021-07-17 | New Zealand | 2814 | 28 | 2743 | 45 | -40.9006 | 174.886 | 2021-07-18 04:22:07 | New Zealand | |||
296147 | 296147 | 2021-07-15 | New Zealand | 2803 | 28 | 2729 | 48 | -40.9006 | 174.886 | 2021-07-16 04:21:22 | New Zealand | |||
2947491 | 2947491 | 2021-07-16 | New Zealand | 2803 | 28 | 2729 | 48 | -40.9006 | 174.886 | 2021-07-17 04:22:22 | New Zealand | |||
3632092 | 3632092 | 2021-07-14 | New Zealand | 2794 | 28 | 2723 | 45 | -40.9006 | 174.886 | 2021-07-15 04:21:48 | 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 | |||
3741216 | 3741216 | 2021-07-12 | New Zealand | 2786 | 28 | 2717 | 43 | -40.9006 | 174.886 | 2021-07-13 04:21:18 | New Zealand | |||
3659729 | 3659729 | 2021-07-11 | New Zealand | 2768 | 28 | 2709 | 33 | -40.9006 | 174.886 | 2021-07-12 04:21:34 | 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 | |||
778496 | 778496 | 2021-07-08 | New Zealand | 2765 | 28 | 2707 | 32 | -40.9006 | 174.886 | 2021-07-09 04:21:21 | New Zealand | |||
829732 | 829732 | 2021-07-09 | New Zealand | 2765 | 28 | 2707 | 32 | -40.9006 | 174.886 | 2021-07-10 04:21:25 | New Zealand | |||
1440718 | 1440718 | 2021-07-07 | New Zealand | 2764 | 28 | 2697 | 41 | -40.9006 | 174.886 | 2021-07-08 04:21:26 | New Zealand | |||
2693823 | 2693823 | 2021-07-06 | New Zealand | 2763 | 28 | 2697 | 40 | -40.9006 | 174.886 | 2021-07-07 04:21:20 | New Zealand | |||
1932572 | 1932572 | 2021-07-05 | New Zealand | 2758 | 28 | 2696 | 36 | -40.9006 | 174.886 | 2021-07-06 04:21:32 | New Zealand | |||
1165303 | 1165303 | 2021-07-04 | New Zealand | 2758 | 28 | 2693 | 39 | -40.9006 | 174.886 | 2021-07-05 04:21:28 | New Zealand | |||
1495737 | 1495737 | 2021-07-03 | New Zealand | 2751 | 28 | 2693 | 32 | -40.9006 | 174.886 | 2021-07-04 04:21:38 | New Zealand | |||
2072052 | 2072052 | 2021-07-02 | New Zealand | 2742 | 28 | 2689 | 27 | -40.9006 | 174.886 | 2021-07-03 04:21:37 | 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 | |||
1893276 | 1893276 | 2021-06-30 | New Zealand | 2742 | 28 | 2685 | 31 | -40.9006 | 174.886 | 2021-07-01 04:21:19 | New Zealand | |||
2765068 | 2765068 | 2021-07-01 | New Zealand | 2742 | 28 | 2685 | 31 | -40.9006 | 174.886 | 2021-07-02 04:21:47 | New Zealand | |||
3125642 | 3125642 | 2021-06-28 | New Zealand | 2741 | 28 | 2685 | 30 | -40.9006 | 174.886 | 2021-06-29 04:21:28 | New Zealand | |||
2590137 | 2590137 | 2021-06-27 | New Zealand | 2738 | 28 | 2684 | 28 | -40.9006 | 174.886 | 2021-06-28 04:21:29 | New Zealand | |||
1712460 | 1712460 | 2021-06-25 | New Zealand | 2729 | 28 | 2682 | 21 | -40.9006 | 174.886 | 2021-06-26 04:21:43 | New Zealand | |||
3958641 | 3958641 | 2021-06-26 | New Zealand | 2729 | 28 | 2682 | 21 | -40.9006 | 174.886 | 2021-06-27 04:21:39 | New Zealand | |||
2295585 | 2295585 | 2021-06-24 | New Zealand | 2725 | 28 | 2680 | 19 | -40.9006 | 174.886 | 2021-06-25 04:21:33 | New Zealand | |||
563102 | 563102 | 2021-06-22 | New Zealand | 2723 | 28 | 2673 | 24 | -40.9006 | 174.886 | 2021-06-23 04:21:46 | New Zealand | |||
2423025 | 2423025 | 2021-06-23 | New Zealand | 2723 | 28 | 2673 | 24 | -40.9006 | 174.886 | 2021-06-24 04:21:55 | New Zealand | |||
2884503 | 2884503 | 2021-06-20 | New Zealand | 2720 | 28 | 2671 | 23 | -40.9006 | 174.886 | 2021-06-21 04:21:41 | New Zealand | |||
3358804 | 3358804 | 2021-06-21 | New Zealand | 2720 | 28 | 2671 | 23 | -40.9006 | 174.886 | 2021-06-22 04:21:34 | New Zealand | |||
107586 | 107586 | 2021-06-19 | New Zealand | 2718 | 28 | 2670 | 22 | -40.9006 | 174.886 | 2021-06-20 04:21:48 | New Zealand | |||
1125729 | 1125729 | 2021-06-18 | New Zealand | 2714 | 28 | 2665 | 23 | -40.9006 | 174.886 | 2021-06-19 04:22:33 | New Zealand | |||
2911307 | 2911307 | 2021-06-17 | New Zealand | 2714 | 28 | 2665 | 23 | -40.9006 | 174.886 | 2021-06-18 04:22:16 | New Zealand | |||
3030424 | 3030424 | 2021-06-16 | New Zealand | 2713 | 28 | 2663 | 24 | -40.9006 | 174.886 | 2021-06-17 04:22:36 | New Zealand | |||
2339530 | 2339530 | 2021-06-15 | New Zealand | 2711 | 28 | 2662 | 23 | -40.9006 | 174.886 | 2021-06-16 04:22:32 | New Zealand | |||
1564226 | 1564226 | 2021-06-14 | New Zealand | 2709 | 28 | 2656 | 27 | -40.9006 | 174.886 | 2021-06-15 04:22:22 | New Zealand | |||
3381509 | 3381509 | 2021-06-13 | New Zealand | 2709 | 28 | 2656 | 27 | -40.9006 | 174.886 | 2021-06-14 04:22:46 | New Zealand | |||
1736643 | 1736643 | 2021-06-12 | New Zealand | 2708 | 28 | 2655 | 27 | -40.9006 | 174.886 | 2021-06-13 04:22:44 | 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 | |||
2717106 | 2717106 | 2021-06-10 | New Zealand | 2702 | 28 | 2647 | 29 | -40.9006 | 174.886 | 2021-06-11 04:23:20 | New Zealand | |||
3970684 | 3970684 | 2021-06-11 | New Zealand | 2702 | 28 | 2647 | 29 | -40.9006 | 174.886 | 2021-06-12 04:22:22 | New Zealand | |||
3472431 | 3472431 | 2021-06-08 | New Zealand | 2696 | 28 | 2646 | 24 | -40.9006 | 174.886 | 2021-06-09 04:23:31 | New Zealand | |||
3145715 | 3145715 | 2021-06-07 | New Zealand | 2692 | 28 | 2644 | 22 | -40.9006 | 174.886 | 2021-06-08 04:22:35 | New Zealand | |||
825717 | 825717 | 2021-06-06 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-07 04:22:51 | New Zealand | |||
1448721 | 1448721 | 2021-06-03 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-04 04:23:37 | New Zealand | |||
2315436 | 2315436 | 2021-06-04 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-05 04:23:03 | New Zealand | |||
2586122 | 2586122 | 2021-06-05 | New Zealand | 2682 | 28 | 2639 | 17 | -40.9006 | 174.886 | 2021-06-06 04:24:03 | New Zealand | |||
1708445 | 1708445 | 2021-06-02 | New Zealand | 2681 | 28 | 2638 | 17 | -40.9006 | 174.886 | 2021-06-03 04:23:32 | New Zealand | |||
2104263 | 2104263 | 2021-06-01 | New Zealand | 2679 | 28 | 2635 | 18 | -40.9006 | 174.886 | 2021-06-02 04:24:34 | New Zealand | |||
50925 | 50925 | 2021-05-29 | New Zealand | 2672 | 28 | 2630 | 16 | -40.9006 | 174.886 | 2021-05-30 04:20:55 | New Zealand | |||
1188879 | 1188879 | 2021-05-31 | New Zealand | 2673 | 28 | 2630 | 17 | -40.9006 | 174.886 | 2021-06-01 04:23:09 | New Zealand | |||
3089556 | 3089556 | 2021-05-30 | New Zealand | 2673 | 28 | 2630 | 17 | -40.9006 | 174.886 | 2021-05-31 03:08:59 | New Zealand | |||
20504 | 20504 | 2021-05-28 | New Zealand | 2670 | 28 | 2623 | 21 | -40.9006 | 174.886 | 2021-05-29 04:20:41 | New Zealand | |||
1310302 | 1310302 | 2021-05-26 | New Zealand | 2670 | 28 | 2623 | 21 | -40.9006 | 174.886 | 2021-05-27 04:20:59 | New Zealand | |||
1806879 | 1806879 | 2021-05-27 | New Zealand | 2670 | 28 | 2623 | 21 | -40.9006 | 174.886 | 2021-05-28 04:20:36 | New Zealand | |||
83228 | 83228 | 2021-05-25 | New Zealand | 2669 | 28 | 2621 | 22 | -40.9006 | 174.886 | 2021-05-26 04:20:35 | New Zealand | |||
1413190 | 1413190 | 2021-05-24 | New Zealand | 2669 | 28 | 2621 | 22 | -40.9006 | 174.886 | 2021-05-25 04:21:08 | 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 | |||
1771476 | 1771476 | 2021-05-23 | New Zealand | 2668 | 28 | 2615 | 27 | -40.9006 | 174.886 | 2021-05-24 04:20:53 | New Zealand | |||
1913345 | 1913345 | 2021-05-20 | New Zealand | 2662 | 28 | 2613 | 23 | -40.9006 | 174.886 | 2021-05-21 04:20:43 | New Zealand | |||
1952646 | 1952646 | 2021-05-21 | New Zealand | 2662 | 28 | 2613 | 23 | -40.9006 | 174.886 | 2021-05-22 04:20:45 | New Zealand | |||
2255866 | 2255866 | 2021-05-19 | New Zealand | 2659 | 28 | 2609 | 24 | -40.9006 | 174.886 | 2021-05-20 04:21:05 | New Zealand | |||
2390904 | 2390904 | 2021-05-18 | New Zealand | 2658 | 28 | 2608 | 24 | -40.9006 | 174.886 | 2021-05-19 04:20:42 | New Zealand | |||
3574729 | 3574729 | 2021-05-17 | New Zealand | 2653 | 28 | 2608 | 19 | -40.9006 | 174.886 | 2021-05-18 04:20:33 | New Zealand | |||
2939459 | 2939459 | 2021-05-16 | New Zealand | 2651 | 28 | 2607 | 18 | -40.9006 | 174.886 | 2021-05-17 04:20:34 | New Zealand | |||
1082058 | 1082058 | 2021-05-14 | New Zealand | 2645 | 28 | 2601 | 18 | -40.9006 | 174.886 | 2021-05-15 04:20:58 | New Zealand | |||
1873089 | 1873089 | 2021-05-15 | New Zealand | 2646 | 28 | 2601 | 19 | -40.9006 | 174.886 | 2021-05-16 04:20:49 | New Zealand | |||
3054324 | 3054324 | 2021-05-13 | New Zealand | 2645 | 28 | 2601 | 18 | -40.9006 | 174.886 | 2021-05-14 04:20:41 | New Zealand | |||
2004794 | 2004794 | 2021-05-12 | New Zealand | 2644 | 28 | 2600 | 18 | -40.9006 | 174.886 | 2021-05-13 04:20:51 | New Zealand | |||
1425236 | 1425236 | 2021-05-09 | New Zealand | 2644 | 28 | 2591 | 27 | -40.9006 | 174.886 | 2021-05-10 04:20:38 | New Zealand | |||
2820904 | 2820904 | 2021-05-10 | New Zealand | 2644 | 28 | 2591 | 27 | -40.9006 | 174.886 | 2021-05-11 04:20:41 | New Zealand | |||
3954625 | 3954625 | 2021-05-11 | New Zealand | 2643 | 28 | 2591 | 26 | -40.9006 | 174.886 | 2021-05-12 04:21:29 | New Zealand | |||
1552104 | 1552104 | 2021-05-08 | New Zealand | 2642 | 28 | 2589 | 27 | -40.9006 | 174.886 | 2021-05-09 04:20:35 | New Zealand | |||
2502162 | 2502162 | 2021-05-07 | New Zealand | 2634 | 28 | 2582 | 26 | -40.9006 | 174.886 | 2021-05-08 04:21:04 | New Zealand | |||
3113618 | 3113618 | 2021-05-06 | New Zealand | 2634 | 28 | 2582 | 26 | -40.9006 | 174.886 | 2021-05-07 04:20:40 | 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 | |||
3675785 | 3675785 | 2021-05-04 | New Zealand | 2629 | 28 | 2578 | 25 | -40.9006 | 174.886 | 2021-05-05 04:20:43 | New Zealand | |||
2761052 | 2761052 | 2021-05-03 | New Zealand | 2623 | 28 | 2573 | 24 | -40.9006 | 174.886 | 2021-05-04 04:20:34 | New Zealand | |||
2450905 | 2450905 | 2021-05-02 | New Zealand | 2622 | 28 | 2571 | 25 | -40.9006 | 174.886 | 2021-05-03 04:20:39 | New Zealand | |||
2824918 | 2824918 | 2021-05-01 | New Zealand | 2618 | 28 | 2568 | 24 | -40.9006 | 174.886 | 2021-05-02 04:20:48 | 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 | |||
1636449 | 1636449 | 2021-04-29 | New Zealand | 2613 | 28 | 2564 | 23 | -40.9006 | 174.886 | 2021-04-30 04:21:03 | New Zealand | |||
3393528 | 3393528 | 2021-04-28 | New Zealand | 2613 | 28 | 2564 | 23 | -40.9006 | 174.886 | 2021-04-29 04:20:55 | New Zealand | |||
888253 | 888253 | 2021-04-26 | New Zealand | 2609 | 28 | 2547 | 36 | -40.9006 | 174.886 | 2021-04-27 04:20:52 | 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]);