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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 2
- Niue 1,040
- Cook Islands 1,039
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118435 | 118435 | 2022-09-06 | New Zealand | Niue | 74 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-07 04:20:59 | Niue, New Zealand | ||
122295 | 122295 | 2020-07-19 | New Zealand | 1554 | 23 | 1506 | 26 | -40.9006 | 174.886 | 2020-07-20 05:34:40 | New Zealand | |||
122364 | 122364 | 2020-07-19 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-07-20 05:34:40 | Cook Islands, New Zealand | ||
122391 | 122391 | 2020-07-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-20 05:34:40 | Niue, New Zealand | ||
122836 | 122836 | 2020-11-18 | New Zealand | 2010 | 26 | 1948 | 37 | -40.9006 | 174.886 | 2020-11-19 05:25:23 | New Zealand | |||
126374 | 126374 | 2020-11-18 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-11-19 05:25:23 | Cook Islands, New Zealand | ||
126401 | 126401 | 2020-11-18 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-11-19 05:25:23 | Niue, 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 | ||||
130417 | 130417 | 2022-01-09 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-01-10 04:22:07 | Niue, 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 | ||||
137542 | 137542 | 2020-04-29 | New Zealand | 1476 | 20 | 1241 | 216 | -40.9006 | 174.886 | 2020-04-30 02:32:27 | New Zealand | |||
137608 | 137608 | 2020-04-29 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-30 02:32:27 | Cook Islands, New Zealand | ||
137639 | 137639 | 2020-04-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-30 02:32:27 | Niue, 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 | ||||
141655 | 141655 | 2021-12-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-12-05 04:22:25 | Niue, 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 | ||||
145671 | 145671 | 2022-07-09 | New Zealand | Niue | 23 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-10 04:20:54 | Niue, New Zealand | ||
146102 | 146102 | 2020-08-15 | New Zealand | 1622 | 23 | 1531 | 69 | -40.9006 | 174.886 | 2020-08-16 04:27:42 | New Zealand | |||
149625 | 149625 | 2020-08-15 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-08-16 04:27:42 | Cook Islands, New Zealand | ||
149652 | 149652 | 2020-08-15 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-16 04:27:42 | Niue, 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 | ||||
153668 | 153668 | 2021-11-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-30 04:22:53 | Niue, New Zealand | ||
154115 | 154115 | 2021-01-08 | New Zealand | 2188 | 26 | 2101 | 62 | -40.9006 | 174.886 | 2021-01-09 05:22:18 | New Zealand | |||
157653 | 157653 | 2021-01-08 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-01-09 05:22:18 | Cook Islands, New Zealand | ||
157680 | 157680 | 2021-01-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-01-09 05:22:18 | Niue, 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 | ||||
161696 | 161696 | 2022-03-29 | New Zealand | Niue | 5 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-30 04:20:45 | Niue, 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 | ||||
165712 | 165712 | 2021-11-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-20 04:22:17 | Niue, 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 | ||||
169728 | 169728 | 2022-06-21 | New Zealand | Niue | 10 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-06-22 04:20:54 | Niue, New Zealand | ||
170177 | 170177 | 2021-04-16 | New Zealand | 2591 | 28 | 2464 | 101 | -40.9006 | 174.886 | 2021-04-17 04:20:40 | New Zealand | |||
173715 | 173715 | 2021-04-16 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-04-17 04:20:40 | Cook Islands, New Zealand | ||
173742 | 173742 | 2021-04-16 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-04-17 04:20:40 | Niue, New Zealand | ||
177613 | 177613 | 2020-07-27 | New Zealand | 1557 | 23 | 1514 | 21 | -40.9006 | 174.886 | 2020-07-28 04:58:43 | New Zealand | |||
177683 | 177683 | 2020-07-27 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-07-28 04:58:43 | Cook Islands, New Zealand | ||
177710 | 177710 | 2020-07-27 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-28 04:58:43 | Niue, 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 | ||||
181724 | 181724 | 2021-09-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-09-03 04:21:20 | Niue, New Zealand | ||
182173 | 182173 | 2021-02-21 | New Zealand | 2357 | 28 | 2277 | 54 | -40.9006 | 174.886 | 2021-02-22 05:24:21 | New Zealand | |||
185711 | 185711 | 2021-02-21 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-02-22 05:24:21 | Cook Islands, New Zealand | ||
185738 | 185738 | 2021-02-21 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-02-22 05:24:21 | Niue, 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 | ||||
189754 | 189754 | 2022-02-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-02-14 04:20:51 | Niue, New Zealand | ||
190201 | 190201 | 2021-01-11 | New Zealand | 2222 | 27 | 2120 | 77 | -40.9006 | 174.886 | 2021-01-12 05:22:15 | New Zealand | |||
193739 | 193739 | 2021-01-11 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-01-12 05:22:15 | Cook Islands, New Zealand | ||
193766 | 193766 | 2021-01-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-01-12 05:22:15 | Niue, New Zealand | ||
194197 | 194197 | 2020-08-31 | New Zealand | 1752 | 25 | 1598 | 132 | -40.9006 | 174.886 | 2020-09-01 04:28:31 | New Zealand | |||
197729 | 197729 | 2020-08-31 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-09-01 04:28:31 | Cook Islands, New Zealand | ||
197756 | 197756 | 2020-08-31 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-09-01 04:28:31 | Niue, 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 | ||||
202388 | 202388 | 2020-12-25 | New Zealand | 2128 | 26 | 2054 | 49 | -40.9006 | 174.886 | 2020-12-26 05:22:28 | New Zealand | |||
205926 | 205926 | 2020-12-25 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-12-26 05:22:28 | Cook Islands, New Zealand | ||
205953 | 205953 | 2020-12-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-12-26 05:22:28 | Niue, New Zealand | ||
206384 | 206384 | 2020-08-19 | New Zealand | 1654 | 23 | 1531 | 101 | -40.9006 | 174.886 | 2020-08-20 04:27:43 | New Zealand | |||
209911 | 209911 | 2020-08-19 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-08-20 04:27:43 | Cook Islands, New Zealand | ||
209938 | 209938 | 2020-08-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-20 04:27:43 | Niue, New Zealand | ||
210371 | 210371 | 2020-10-29 | New Zealand | 1950 | 26 | 1857 | 68 | -40.9006 | 174.886 | 2020-10-30 04:24:49 | New Zealand | |||
213907 | 213907 | 2020-10-29 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-10-30 04:24:49 | Cook Islands, New Zealand | ||
213934 | 213934 | 2020-10-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-10-30 04:24:49 | Niue, New Zealand | ||
217552 | 217552 | 2020-06-08 | New Zealand | 1504 | 23 | 1482 | 0 | -40.9006 | 174.886 | 2020-06-09 03:33:03 | New Zealand | |||
217616 | 217616 | 2020-06-08 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-06-09 03:33:03 | Cook Islands, New Zealand | ||
217647 | 217647 | 2020-06-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-06-09 03:33:03 | Niue, 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 | ||||
225679 | 225679 | 2022-05-09 | New Zealand | Niue | 9 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-05-10 04:20:50 | Niue, New Zealand | ||
228796 | 228796 | 2020-04-30 | New Zealand | 1479 | 20 | 1252 | 208 | -40.9006 | 174.886 | 2020-05-01 02:32:28 | New Zealand | |||
228863 | 228863 | 2020-04-30 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-05-01 02:32:28 | Cook Islands, New Zealand | ||
228894 | 228894 | 2020-04-30 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-05-01 02:32:28 | Niue, 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 | ||||
232910 | 232910 | 2022-05-31 | New Zealand | Niue | 9 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-06-01 04:20:55 | Niue, 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 | ||||
236926 | 236926 | 2022-02-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-02-12 04:21:06 | Niue, New Zealand | ||
237373 | 237373 | 2021-01-18 | New Zealand | 2262 | 27 | 2152 | 85 | -40.9006 | 174.886 | 2021-01-19 05:22:15 | New Zealand | |||
240912 | 240912 | 2021-01-18 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-01-19 05:22:15 | Cook Islands, New Zealand | ||
240939 | 240939 | 2021-01-18 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-01-19 05:22:15 | Niue, New Zealand | ||
241388 | 241388 | 2021-04-02 | New Zealand | 2501 | 28 | 2408 | 67 | -40.9006 | 174.886 | 2021-04-03 04:20:44 | New Zealand | |||
244926 | 244926 | 2021-04-02 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-04-03 04:20:44 | Cook Islands, 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]);