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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 2
- Niue 569
- Cook Islands 568
country_or_region 1
- New Zealand · 1,675 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2899821 | 2899821 | 2021-08-12 | New Zealand | 2914 | 28 | 0 | -40.9006 | 174.886 | 2021-08-13 04:21:24 | New Zealand | ||||
2903384 | 2903384 | 2021-08-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-13 04:21:24 | Niue, New Zealand | ||
1342424 | 1342424 | 2021-08-11 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-12 04:21:25 | Cook Islands, New Zealand | |||
1342425 | 1342425 | 2021-08-11 | New Zealand | 2913 | 28 | 0 | -40.9006 | 174.886 | 2021-08-12 04:21:25 | New Zealand | ||||
1345988 | 1345988 | 2021-08-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-12 04:21:25 | Niue, New Zealand | ||
2351571 | 2351571 | 2021-08-10 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-11 04:21:58 | Cook Islands, New Zealand | |||
2351572 | 2351572 | 2021-08-10 | New Zealand | 2904 | 28 | 0 | -40.9006 | 174.886 | 2021-08-11 04:21:58 | New Zealand | ||||
2355135 | 2355135 | 2021-08-10 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-11 04:21:58 | Niue, New Zealand | ||
650100 | 650100 | 2021-08-09 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-10 04:21:27 | Cook Islands, New Zealand | |||
650101 | 650101 | 2021-08-09 | New Zealand | 2902 | 28 | 0 | -40.9006 | 174.886 | 2021-08-10 04:21:27 | New Zealand | ||||
653664 | 653664 | 2021-08-09 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-10 04:21:27 | Niue, New Zealand | ||
589762 | 589762 | 2021-08-08 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-09 04:21:24 | Cook Islands, New Zealand | |||
589763 | 589763 | 2021-08-08 | New Zealand | 2890 | 28 | 0 | -40.9006 | 174.886 | 2021-08-09 04:21:24 | New Zealand | ||||
593326 | 593326 | 2021-08-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-09 04:21:24 | Niue, New Zealand | ||
2203774 | 2203774 | 2021-08-07 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-08 04:21:33 | Cook Islands, New Zealand | |||
2203775 | 2203775 | 2021-08-07 | New Zealand | 2886 | 28 | 0 | -40.9006 | 174.886 | 2021-08-08 04:21:33 | New Zealand | ||||
2207338 | 2207338 | 2021-08-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-08 04:21:33 | Niue, New Zealand | ||
1117724 | 1117724 | 2021-08-06 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-07 04:21:30 | Cook Islands, New Zealand | |||
1117725 | 1117725 | 2021-08-06 | New Zealand | 2880 | 28 | 0 | -40.9006 | 174.886 | 2021-08-07 04:21:30 | New Zealand | ||||
1121288 | 1121288 | 2021-08-06 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-07 04:21:30 | Niue, New Zealand | ||
1956661 | 1956661 | 2021-08-05 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-06 04:21:18 | Cook Islands, New Zealand | |||
1956662 | 1956662 | 2021-08-05 | New Zealand | 2880 | 28 | 0 | -40.9006 | 174.886 | 2021-08-06 04:21:18 | New Zealand | ||||
1960225 | 1960225 | 2021-08-05 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-06 04:21:18 | Niue, New Zealand | ||
332040 | 332040 | 2021-08-04 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-05 04:21:51 | Cook Islands, New Zealand | ||
332041 | 332041 | 2021-08-04 | New Zealand | 2880 | 28 | 2824 | 30 | -40.9006 | 174.886 | 2021-08-05 04:21:51 | New Zealand | |||
335604 | 335604 | 2021-08-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-05 04:21:51 | Niue, New Zealand | ||
3468311 | 3468311 | 2021-08-03 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-04 04:21:25 | Cook Islands, 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 | |||
3471875 | 3471875 | 2021-08-03 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-04 04:21:25 | Niue, New Zealand | ||
3683585 | 3683585 | 2021-08-02 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-03 04:21:39 | Cook Islands, 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 | |||
3687149 | 3687149 | 2021-08-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-03 04:21:39 | Niue, New Zealand | ||
3015484 | 3015484 | 2021-08-01 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-02 04:21:36 | Cook Islands, 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 | |||
3019048 | 3019048 | 2021-08-01 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-02 04:21:36 | Niue, New Zealand | ||
3904107 | 3904107 | 2021-07-31 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-08-01 04:21:50 | Cook Islands, 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 | |||
3907671 | 3907671 | 2021-07-31 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-01 04:21:50 | Niue, New Zealand | ||
3296312 | 3296312 | 2021-07-30 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-31 04:21:35 | Cook Islands, 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 | |||
3299876 | 3299876 | 2021-07-30 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-31 04:21:35 | Niue, New Zealand | ||
3385523 | 3385523 | 2021-07-29 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-30 04:21:34 | Cook Islands, 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 | |||
3389087 | 3389087 | 2021-07-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-30 04:21:34 | Niue, New Zealand | ||
408428 | 408428 | 2021-07-28 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-29 04:21:33 | Cook Islands, 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 | |||
411992 | 411992 | 2021-07-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-29 04:21:33 | Niue, New Zealand | ||
1306289 | 1306289 | 2021-07-27 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-28 04:21:39 | Cook Islands, 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 | |||
1309853 | 1309853 | 2021-07-27 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-28 04:21:39 | Niue, New Zealand | ||
3218432 | 3218432 | 2021-07-26 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-27 04:21:18 | Cook Islands, 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 | |||
3221996 | 3221996 | 2021-07-26 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-27 04:21:18 | Niue, New Zealand | ||
1378641 | 1378641 | 2021-07-25 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-26 04:21:28 | Cook Islands, 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 | |||
1382205 | 1382205 | 2021-07-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-26 04:21:28 | Niue, New Zealand | ||
1330381 | 1330381 | 2021-07-24 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-25 04:22:12 | Cook Islands, 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 | |||
1333945 | 1333945 | 2021-07-24 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-25 04:22:12 | Niue, New Zealand | ||
3137685 | 3137685 | 2021-07-23 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-24 00:21:36 | Cook Islands, 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 | |||
3141249 | 3141249 | 2021-07-23 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-24 00:21:36 | Niue, New Zealand | ||
3476445 | 3476445 | 2021-07-22 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-23 04:21:29 | Cook Islands, 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 | |||
3480009 | 3480009 | 2021-07-22 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-23 04:21:29 | Niue, New Zealand | ||
3331664 | 3331664 | 2021-07-21 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-22 04:21:19 | Cook Islands, 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 | |||
3335228 | 3335228 | 2021-07-21 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-22 04:21:19 | Niue, New Zealand | ||
2371645 | 2371645 | 2021-07-20 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-21 04:21:40 | Cook Islands, 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 | |||
2375209 | 2375209 | 2021-07-20 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-21 04:21:40 | Niue, New Zealand | ||
483724 | 483724 | 2021-07-19 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-20 04:21:48 | Cook Islands, 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 | |||
487288 | 487288 | 2021-07-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-20 04:21:48 | Niue, New Zealand | ||
2673947 | 2673947 | 2021-07-18 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-19 04:21:24 | Cook Islands, 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 | |||
2677511 | 2677511 | 2021-07-18 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-19 04:21:24 | Niue, New Zealand | ||
3706259 | 3706259 | 2021-07-17 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-18 04:22:07 | Cook Islands, 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 | |||
3709823 | 3709823 | 2021-07-17 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-18 04:22:07 | Niue, New Zealand | ||
2947490 | 2947490 | 2021-07-16 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-17 04:22:22 | Cook Islands, 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 | |||
2951054 | 2951054 | 2021-07-16 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-17 04:22:22 | Niue, New Zealand | ||
296146 | 296146 | 2021-07-15 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-16 04:21:22 | Cook Islands, 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 | |||
299710 | 299710 | 2021-07-15 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-16 04:21:22 | Niue, New Zealand | ||
3632091 | 3632091 | 2021-07-14 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-15 04:21:48 | Cook Islands, 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 | |||
3635655 | 3635655 | 2021-07-14 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-15 04:21:48 | Niue, New Zealand | ||
578966 | 578966 | 2021-07-13 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-14 04:21:35 | Cook Islands, 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 | |||
582530 | 582530 | 2021-07-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-14 04:21:35 | Niue, New Zealand | ||
3741215 | 3741215 | 2021-07-12 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-13 04:21:18 | Cook Islands, 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 | |||
3744779 | 3744779 | 2021-07-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-13 04:21:18 | Niue, New Zealand | ||
3659728 | 3659728 | 2021-07-11 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-12 04:21:34 | Cook Islands, 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 | |||
3663292 | 3663292 | 2021-07-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-12 04:21:34 | Niue, New Zealand | ||
626012 | 626012 | 2021-07-10 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-07-11 04:21:43 | Cook Islands, 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 |
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]);