johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "New Zealand" and province_or_state = "Cook Islands" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
province_or_state 1
- Cook Islands · 1,073 ✖
country_or_region 1
- New Zealand · 1,073 ✖
combined_key 1 ✖
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 | |||
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 | |||
11998 | 11998 | 2020-10-25 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-10-26 04:25:02 | Cook Islands, New Zealand | ||
16012 | 16012 | 2021-01-26 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-01-27 05:23:41 | Cook Islands, 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 | |||
24041 | 24041 | 2021-05-28 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-05-29 04:20:41 | Cook Islands, 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 | |||
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 | |||
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 | |||
40101 | 40101 | 2021-04-12 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-04-13 04:20:37 | Cook Islands, New Zealand | ||
40306 | 40306 | 2020-03-05 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-05T14:53:03 | ||||
43345 | 43345 | 2020-04-13 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-13 23:07:54 | Cook Islands, New Zealand | ||
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 | |||
50444 | 50444 | 2020-04-17 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-17 23:30:52 | Cook Islands, New Zealand | ||
54462 | 54462 | 2021-05-29 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-05-30 04:20:55 | Cook Islands, New Zealand | ||
58476 | 58476 | 2021-03-07 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-03-08 05:24:48 | Cook Islands, New Zealand | ||
62441 | 62441 | 2020-07-23 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-07-24 05:30:40 | Cook Islands, New Zealand | ||
62698 | 62698 | 2020-03-07 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 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 | |||
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 | |||
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 | |||
78759 | 78759 | 2020-12-03 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-12-04 05:27:27 | Cook Islands, New Zealand | ||
82752 | 82752 | 2020-10-14 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-10-15 04:24:28 | Cook Islands, New Zealand | ||
86766 | 86766 | 2021-05-25 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-05-26 04:20:35 | Cook Islands, 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 | |||
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 | |||
98771 | 98771 | 2020-08-04 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-08-05 04:34:43 | Cook Islands, New Zealand | ||
98963 | 98963 | 2020-03-04 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 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 | |||
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 | |||
107104 | 107104 | 2020-02-15 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-02-15T23:13:05 | ||||
107585 | 107585 | 2021-06-19 | New Zealand | Cook Islands | 1 | 0 | 0 | 1 | -21.2367 | -159.7777 | 2021-06-20 04:21:48 | Cook Islands, New Zealand | ||
114388 | 114388 | 2020-05-08 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-05-09 02:32:35 | Cook Islands, New Zealand | ||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
197803 | 197803 | 2020-01-24 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 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 | ||||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
261169 | 261169 | 2020-03-03 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 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 | |||
268621 | 268621 | 2020-05-21 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-05-22 02:36:51 | Cook Islands, New Zealand | ||
271822 | 271822 | 2020-04-28 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-29 02:32:29 | Cook Islands, New Zealand | ||
275824 | 275824 | 2020-11-10 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-11-11 05:25:30 | Cook Islands, 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 | |||
283854 | 283854 | 2021-02-24 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-02-25 05:24:57 | Cook Islands, New Zealand | ||
287637 | 287637 | 2020-06-15 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-06-16 04:33:09 | Cook Islands, 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 | |||
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 | |||
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 | ||
303509 | 303509 | 2020-07-01 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-07-02 04:33:46 | Cook Islands, New Zealand | ||
304004 | 304004 | 2022-04-16 | New Zealand | Cook Islands | 3941 | 0 | 0 | -21.2367 | -159.7777 | 2022-04-17 04:20:59 | Cook Islands, New Zealand | |||
308022 | 308022 | 2022-12-13 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-14 04:21:04 | Cook Islands, New Zealand | |||
312038 | 312038 | 2022-11-13 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-11-14 04:21:09 | Cook Islands, New Zealand | |||
316052 | 316052 | 2022-02-12 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-13 04:21:00 | Cook Islands, New Zealand | |||
320070 | 320070 | 2022-10-30 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-10-31 04:21:36 | Cook Islands, New Zealand | |||
327547 | 327547 | 2020-07-20 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-07-21 04:38:46 | Cook Islands, New Zealand | ||
328044 | 328044 | 2022-12-27 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-28 04:21:04 | Cook Islands, 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 | ||
336072 | 336072 | 2022-03-18 | New Zealand | Cook Islands | 676 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-19 04:20:47 | Cook Islands, New Zealand | |||
339929 | 339929 | 2020-03-21 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-21T10:13:08 | ||||
343947 | 343947 | 2021-02-03 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-02-04 05:22:26 | Cook Islands, New Zealand | ||
347937 | 347937 | 2020-09-14 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-09-15 03:22:50 | Cook Islands, New Zealand | ||
348434 | 348434 | 2022-12-14 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-15 04:20:58 | Cook Islands, New Zealand | |||
355967 | 355967 | 2021-03-11 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2021-03-12 05:26:50 | Cook Islands, New Zealand | ||
356462 | 356462 | 2022-03-11 | New Zealand | Cook Islands | 247 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-12 04:20:50 | Cook Islands, New Zealand | |||
360478 | 360478 | 2022-05-07 | New Zealand | Cook Islands | 5267 | 1 | 0 | -21.2367 | -159.7777 | 2022-05-08 04:20:49 | 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]);