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 active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
465 | 465 | 2021-12-02 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-03 04:23:05 | Cook Islands, New Zealand | |||
466 | 466 | 2021-12-02 | New Zealand | 11992 | 41 | 0 | -40.9006 | 174.886 | 2021-12-03 04:23:05 | New Zealand | ||||
4481 | 4481 | 2021-10-28 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-10-29 04:22:03 | Cook Islands, New Zealand | |||
4482 | 4482 | 2021-10-28 | New Zealand | 6124 | 30 | 0 | -40.9006 | 174.886 | 2021-10-29 04:22:03 | New Zealand | ||||
16489 | 16489 | 2021-09-18 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-19 04:21:34 | Cook Islands, New Zealand | |||
16490 | 16490 | 2021-09-18 | New Zealand | 4060 | 29 | 0 | -40.9006 | 174.886 | 2021-09-19 04:21:34 | New Zealand | ||||
24536 | 24536 | 2022-03-20 | New Zealand | Cook Islands | 743 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-21 04:20:50 | Cook Islands, New Zealand | |||
24537 | 24537 | 2022-03-20 | New Zealand | 497731 | 273 | 0 | -40.9006 | 174.886 | 2022-03-21 04:20:50 | New Zealand | ||||
28551 | 28551 | 2021-11-11 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-12 04:22:01 | Cook Islands, New Zealand | |||
28552 | 28552 | 2021-11-11 | New Zealand | 8306 | 31 | 0 | -40.9006 | 174.886 | 2021-11-12 04:22:01 | New Zealand | ||||
32550 | 32550 | 2021-08-25 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-26 04:21:28 | Cook Islands, New Zealand | |||
32551 | 32551 | 2021-08-25 | New Zealand | 3227 | 28 | 0 | -40.9006 | 174.886 | 2021-08-26 04:21:28 | New Zealand | ||||
40231 | 40231 | 2020-03-05 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
40306 | 40306 | 2020-03-05 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-05T14:53:03 | ||||
40337 | 40337 | 2020-03-05 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-05T14:53:03 | ||||
43843 | 43843 | 2021-11-02 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-03 06:22:09 | Cook Islands, New Zealand | |||
43844 | 43844 | 2021-11-02 | New Zealand | 6832 | 31 | 0 | -40.9006 | 174.886 | 2021-11-03 06:22:09 | New Zealand | ||||
62572 | 62572 | 2020-03-07 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
62698 | 62698 | 2020-03-07 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-07T11:13:04 | ||||
62729 | 62729 | 2020-03-07 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-07T11:13:04 | ||||
63199 | 63199 | 2022-11-12 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-11-13 04:21:14 | Cook Islands, New Zealand | |||
63200 | 63200 | 2022-11-12 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-13 04:21:14 | Niue, New Zealand | |||
63201 | 63201 | 2022-11-12 | New Zealand | 1872459 | 2119 | 0 | -40.9006 | 174.886 | 2022-11-13 04:21:14 | New Zealand | ||||
67195 | 67195 | 2021-09-01 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-02 04:21:15 | Cook Islands, New Zealand | |||
67196 | 67196 | 2021-09-01 | New Zealand | 3645 | 29 | 0 | -40.9006 | 174.886 | 2021-09-02 04:21:15 | New Zealand | ||||
71226 | 71226 | 2022-02-07 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-08 04:21:15 | Cook Islands, New Zealand | |||
71227 | 71227 | 2022-02-07 | New Zealand | 18253 | 52 | 0 | -40.9006 | 174.886 | 2022-02-08 04:21:15 | New Zealand | ||||
87260 | 87260 | 2021-11-09 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-10 04:21:38 | Cook Islands, New Zealand | |||
87261 | 87261 | 2021-11-09 | New Zealand | 7922 | 31 | 0 | -40.9006 | 174.886 | 2021-11-10 04:21:38 | New Zealand | ||||
91278 | 91278 | 2022-07-23 | New Zealand | Cook Islands | 5847 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-24 04:20:47 | Cook Islands, New Zealand | |||
91279 | 91279 | 2022-07-23 | New Zealand | 1563510 | 1410 | 0 | -40.9006 | 174.886 | 2022-07-24 04:20:47 | New Zealand | ||||
98893 | 98893 | 2020-03-04 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
98963 | 98963 | 2020-03-04 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-04T12:53:03 | ||||
98994 | 98994 | 2020-03-04 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-04T12:53:03 | ||||
99461 | 99461 | 2022-01-14 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-15 04:21:07 | Cook Islands, New Zealand | |||
99462 | 99462 | 2022-01-14 | New Zealand | 15001 | 51 | 0 | -40.9006 | 174.886 | 2022-01-15 04:21:07 | New Zealand | ||||
103460 | 103460 | 2021-08-15 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-16 04:21:31 | Cook Islands, New Zealand | |||
103461 | 103461 | 2021-08-15 | New Zealand | 2926 | 28 | 0 | -40.9006 | 174.886 | 2021-08-16 04:21:31 | New Zealand | ||||
107104 | 107104 | 2020-02-15 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-02-15T23:13:05 | ||||
107135 | 107135 | 2020-02-15 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-02-15T23:13:05 | ||||
114888 | 114888 | 2022-09-06 | New Zealand | Cook Islands | 6379 | 1 | 0 | -21.2367 | -159.7777 | 2022-09-07 04:20:59 | Cook Islands, New Zealand | |||
114889 | 114889 | 2022-09-06 | New Zealand | 1753182 | 1939 | 0 | -40.9006 | 174.886 | 2022-09-07 04:20:59 | New Zealand | ||||
126868 | 126868 | 2022-01-09 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-10 04:22:07 | Cook Islands, New Zealand | |||
126869 | 126869 | 2022-01-09 | New Zealand | 14733 | 51 | 0 | -40.9006 | 174.886 | 2022-01-10 04:22:07 | New Zealand | ||||
130887 | 130887 | 2022-10-04 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-10-05 04:23:06 | Cook Islands, New Zealand | |||
130888 | 130888 | 2022-10-04 | New Zealand | Niue | 80 | 0 | 0 | -19.0544 | -169.8672 | 2022-10-05 04:23:06 | Niue, New Zealand | |||
130889 | 130889 | 2022-10-04 | New Zealand | 1789425 | 2038 | 0 | -40.9006 | 174.886 | 2022-10-05 04:23:06 | New Zealand | ||||
138106 | 138106 | 2021-12-04 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-05 04:22:25 | Cook Islands, New Zealand | |||
138107 | 138107 | 2021-12-04 | New Zealand | 12195 | 41 | 0 | -40.9006 | 174.886 | 2021-12-05 04:22:25 | New Zealand | ||||
142124 | 142124 | 2022-07-09 | New Zealand | Cook Islands | 5794 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-10 04:20:54 | Cook Islands, New Zealand | |||
142125 | 142125 | 2022-07-09 | New Zealand | 1429924 | 1180 | 0 | -40.9006 | 174.886 | 2022-07-10 04:20:54 | New Zealand | ||||
150119 | 150119 | 2021-11-29 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-30 04:22:53 | Cook Islands, New Zealand | |||
150120 | 150120 | 2021-11-29 | New Zealand | 11576 | 41 | 0 | -40.9006 | 174.886 | 2021-11-30 04:22:53 | New Zealand | ||||
158148 | 158148 | 2022-03-29 | New Zealand | Cook Islands | 1745 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-30 04:20:45 | Cook Islands, New Zealand | |||
158149 | 158149 | 2022-03-29 | New Zealand | 643875 | 365 | 0 | -40.9006 | 174.886 | 2022-03-30 04:20:45 | New Zealand | ||||
162163 | 162163 | 2021-11-19 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-20 04:22:17 | Cook Islands, New Zealand | |||
162164 | 162164 | 2021-11-19 | New Zealand | 9823 | 36 | 0 | -40.9006 | 174.886 | 2021-11-20 04:22:17 | New Zealand | ||||
166181 | 166181 | 2022-06-21 | New Zealand | Cook Islands | 5762 | 1 | 0 | -21.2367 | -159.7777 | 2022-06-22 04:20:54 | Cook Islands, New Zealand | |||
166182 | 166182 | 2022-06-21 | New Zealand | 1289128 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-22 04:20:54 | New Zealand | ||||
178160 | 178160 | 2021-09-02 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-03 04:21:20 | Cook Islands, New Zealand | |||
178161 | 178161 | 2021-09-02 | New Zealand | 3729 | 29 | 0 | -40.9006 | 174.886 | 2021-09-03 04:21:20 | New Zealand | ||||
186206 | 186206 | 2022-02-13 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-14 04:20:51 | Cook Islands, New Zealand | |||
186207 | 186207 | 2022-02-13 | New Zealand | 21573 | 53 | 0 | -40.9006 | 174.886 | 2022-02-14 04:20:51 | New Zealand | ||||
197803 | 197803 | 2020-01-24 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 1/24/20 17:00 | ||||
197835 | 197835 | 2020-01-24 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 1/24/20 17:00 | ||||
197894 | 197894 | 2020-01-29 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 1/29/20 19:30 | ||||
197926 | 197926 | 2020-01-29 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 1/29/20 19:30 | ||||
198396 | 198396 | 2022-10-19 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-10-20 04:22:59 | Cook Islands, New Zealand | |||
198397 | 198397 | 2022-10-19 | New Zealand | Niue | 83 | 0 | 0 | -19.0544 | -169.8672 | 2022-10-20 04:22:59 | Niue, New Zealand | |||
198398 | 198398 | 2022-10-19 | New Zealand | 1814890 | 2065 | 0 | -40.9006 | 174.886 | 2022-10-20 04:22:59 | New Zealand | ||||
218117 | 218117 | 2022-12-26 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-27 04:21:07 | Cook Islands, New Zealand | |||
218118 | 218118 | 2022-12-26 | New Zealand | Niue | 378 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-27 04:21:07 | Niue, New Zealand | |||
218119 | 218119 | 2022-12-26 | New Zealand | 2062384 | 2288 | 0 | -40.9006 | 174.886 | 2022-12-27 04:21:07 | New Zealand | ||||
222131 | 222131 | 2022-05-09 | New Zealand | Cook Islands | 5306 | 1 | 0 | -21.2367 | -159.7777 | 2022-05-10 04:20:50 | Cook Islands, New Zealand | |||
222132 | 222132 | 2022-05-09 | New Zealand | 1005674 | 750 | 0 | -40.9006 | 174.886 | 2022-05-10 04:20:50 | New Zealand | ||||
229363 | 229363 | 2022-05-31 | New Zealand | Cook Islands | 5675 | 1 | 0 | -21.2367 | -159.7777 | 2022-06-01 04:20:55 | Cook Islands, New Zealand | |||
229364 | 229364 | 2022-05-31 | New Zealand | 1170815 | 890 | 0 | -40.9006 | 174.886 | 2022-06-01 04:20:55 | New Zealand | ||||
233378 | 233378 | 2022-02-11 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-12 04:21:06 | Cook Islands, New Zealand | |||
233379 | 233379 | 2022-02-11 | New Zealand | 19777 | 52 | 0 | -40.9006 | 174.886 | 2022-02-12 04:21:06 | New Zealand | ||||
245403 | 245403 | 2021-08-17 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-18 04:21:35 | Cook Islands, New Zealand | |||
245404 | 245404 | 2021-08-17 | New Zealand | 2936 | 28 | 0 | -40.9006 | 174.886 | 2021-08-18 04:21:35 | New Zealand | ||||
249417 | 249417 | 2021-09-04 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-05 04:21:33 | Cook Islands, New Zealand | |||
249418 | 249418 | 2021-09-04 | New Zealand | 3768 | 29 | 0 | -40.9006 | 174.886 | 2021-09-05 04:21:33 | New Zealand | ||||
253450 | 253450 | 2022-09-08 | New Zealand | Cook Islands | 6381 | 1 | 0 | -21.2367 | -159.7777 | 2022-09-09 04:21:11 | Cook Islands, New Zealand | |||
253451 | 253451 | 2022-09-08 | New Zealand | 1756443 | 1944 | 0 | -40.9006 | 174.886 | 2022-09-09 04:21:11 | New Zealand | ||||
257467 | 257467 | 2022-12-10 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-11 04:20:50 | Cook Islands, New Zealand | |||
257468 | 257468 | 2022-12-10 | New Zealand | Niue | 191 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-11 04:20:50 | Niue, New Zealand | |||
257469 | 257469 | 2022-12-10 | New Zealand | 1979614 | 2235 | 0 | -40.9006 | 174.886 | 2022-12-11 04:20:50 | New Zealand | ||||
261139 | 261139 | 2020-03-03 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
261169 | 261169 | 2020-03-03 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-03T11:43:02 | ||||
261200 | 261200 | 2020-03-03 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-03T11:43:02 | ||||
261668 | 261668 | 2022-03-15 | New Zealand | Cook Islands | 379 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-16 04:20:50 | Cook Islands, New Zealand | |||
261669 | 261669 | 2022-03-15 | New Zealand | 399342 | 180 | 0 | -40.9006 | 174.886 | 2022-03-16 04:20:50 | New Zealand | ||||
276318 | 276318 | 2021-11-03 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-04 04:22:20 | Cook Islands, New Zealand | |||
276319 | 276319 | 2021-11-03 | New Zealand | 6972 | 31 | 0 | -40.9006 | 174.886 | 2021-11-04 04:22:20 | New Zealand | ||||
288131 | 288131 | 2021-10-31 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-01 04:22:01 | Cook Islands, New Zealand | |||
288132 | 288132 | 2021-10-31 | New Zealand | 6594 | 31 | 0 | -40.9006 | 174.886 | 2021-11-01 04:22:01 | New Zealand | ||||
292150 | 292150 | 2022-11-15 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-11-16 04:21:09 | Cook Islands, New Zealand | |||
292151 | 292151 | 2022-11-15 | New Zealand | Niue | 87 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-16 04:21:09 | Niue, New Zealand | |||
292152 | 292152 | 2022-11-15 | New Zealand | 1894029 | 2154 | 0 | -40.9006 | 174.886 | 2022-11-16 04:21:09 | 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]);