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 = "Niue" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367887 | 367887 | 2020-07-16 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-17 04:34:50 | Niue, New Zealand | ||
371864 | 371864 | 2020-08-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-09 04:34:54 | Niue, New Zealand | ||
372335 | 372335 | 2022-09-13 | New Zealand | Niue | 77 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-14 04:20:44 | Niue, New Zealand | |||
379877 | 379877 | 2020-11-06 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-11-07 05:24:52 | Niue, New Zealand | ||
383891 | 383891 | 2021-04-30 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-01 04:20:47 | Niue, New Zealand | ||
384362 | 384362 | 2022-09-23 | New Zealand | Niue | 80 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-24 04:21:40 | Niue, New Zealand | |||
391921 | 391921 | 2021-04-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-04-05 04:20:35 | Niue, New Zealand | ||
395932 | 395932 | 2020-11-27 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-11-28 05:25:50 | Niue, New Zealand | ||
396403 | 396403 | 2022-10-07 | New Zealand | Niue | 81 | 0 | 0 | -19.0544 | -169.8672 | 2022-10-08 04:22:56 | Niue, New Zealand | |||
403962 | 403962 | 2021-06-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-06-30 04:21:41 | Niue, New Zealand | ||
407978 | 407978 | 2021-12-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-12-08 04:22:46 | Niue, 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 | ||
415828 | 415828 | 2020-07-05 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-06 04:33:57 | Niue, New Zealand | ||
415912 | 415912 | 2020-01-26 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 1/26/20 16:00 | ||||
419003 | 419003 | 2020-04-18 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-18 22:32:47 | Niue, New Zealand | ||
419474 | 419474 | 2022-09-18 | New Zealand | Niue | 79 | 0 | 0 | -19.0544 | -169.8672 | 2022-09-19 04:21:49 | Niue, New Zealand | |||
427035 | 427035 | 2021-10-10 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-11 04:21:31 | Niue, New Zealand | ||
431025 | 431025 | 2020-09-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-09-08 04:28:25 | Niue, New Zealand | ||
431496 | 431496 | 2022-11-03 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-04 04:22:11 | Niue, New Zealand | |||
439055 | 439055 | 2021-01-21 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-01-22 05:22:10 | Niue, New Zealand | ||
443023 | 443023 | 2020-07-26 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-27 04:35:02 | Niue, New Zealand | ||
447039 | 447039 | 2021-10-20 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-21 04:21:18 | Niue, New Zealand | ||
451055 | 451055 | 2021-11-17 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-18 04:21:33 | Niue, New Zealand | ||
451526 | 451526 | 2022-12-21 | New Zealand | Niue | 314 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-22 04:20:56 | Niue, New Zealand | |||
459048 | 459048 | 2020-08-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-08 04:34:53 | Niue, New Zealand | ||
463064 | 463064 | 2022-02-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-02-03 04:21:21 | Niue, New Zealand | ||
467080 | 467080 | 2022-05-02 | New Zealand | Niue | 9 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-05-03 04:21:00 | Niue, New Zealand | ||
471096 | 471096 | 2021-10-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-08 04:21:25 | Niue, New Zealand | ||
475110 | 475110 | 2021-02-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-02-20 05:22:51 | Niue, New Zealand | ||
479126 | 479126 | 2022-06-26 | New Zealand | Niue | 10 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-06-27 04:21:00 | Niue, New Zealand | ||
479258 | 479258 | 2020-02-25 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-02-25T15:23:04 | ||||
479729 | 479729 | 2022-11-08 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-09 04:21:22 | Niue, 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 | ||
487759 | 487759 | 2022-11-25 | New Zealand | Niue | 108 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-26 04:21:11 | Niue, New Zealand | |||
495320 | 495320 | 2021-10-14 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-15 04:21:26 | Niue, New Zealand | ||
499336 | 499336 | 2021-11-06 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-07 04:21:53 | Niue, New Zealand | ||
503352 | 503352 | 2022-04-02 | New Zealand | Niue | 7 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-04-03 04:20:48 | Niue, New Zealand | ||
503823 | 503823 | 2022-12-17 | New Zealand | Niue | 226 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-18 04:21:03 | Niue, New Zealand | |||
511382 | 511382 | 2021-08-14 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-15 04:21:41 | Niue, New Zealand | ||
515396 | 515396 | 2021-08-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-20 04:21:33 | Niue, New Zealand | ||
515867 | 515867 | 2022-10-15 | New Zealand | Niue | 83 | 0 | 0 | -19.0544 | -169.8672 | 2022-10-16 04:22:39 | Niue, New Zealand | |||
522541 | 522541 | 2020-04-21 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-21 23:30:50 | Niue, New Zealand | ||
526555 | 526555 | 2021-06-09 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-06-10 04:23:17 | Niue, New Zealand | ||
530390 | 530390 | 2020-07-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-05 04:33:46 | Niue, New Zealand | ||
534404 | 534404 | 2021-02-22 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-02-23 05:23:41 | Niue, New Zealand | ||
538420 | 538420 | 2021-10-27 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-28 04:22:08 | Niue, New Zealand | ||
538891 | 538891 | 2022-10-26 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-10-27 04:22:01 | Niue, New Zealand | |||
542907 | 542907 | 2022-12-15 | New Zealand | Niue | 212 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-16 04:21:01 | Niue, New Zealand | |||
550442 | 550442 | 2020-09-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-09-13 04:30:52 | Niue, New Zealand | ||
554458 | 554458 | 2021-12-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-12-09 04:22:49 | Niue, New Zealand | ||
558474 | 558474 | 2022-01-16 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-01-17 04:21:08 | Niue, New Zealand | ||
562490 | 562490 | 2022-06-16 | New Zealand | Niue | 9 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-06-17 04:20:56 | Niue, New Zealand | ||
562651 | 562651 | 2020-03-01 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-01T10:13:19 | ||||
566665 | 566665 | 2021-06-22 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-06-23 04:21:46 | Niue, New Zealand | ||
566772 | 566772 | 2020-02-06 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-02-06T23:23:02 | ||||
570788 | 570788 | 2021-10-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-30 04:22:03 | Niue, New Zealand | ||
574500 | 574500 | 2020-06-06 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-06-07 03:53:30 | Niue, New Zealand | ||
578516 | 578516 | 2022-02-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-02-26 04:21:12 | Niue, 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 | ||
586511 | 586511 | 2020-08-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-14 04:51:19 | Niue, New Zealand | ||
589312 | 589312 | 2020-04-05 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-05 23:06:45 | Niue, 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 | ||
597342 | 597342 | 2022-07-01 | New Zealand | Niue | 15 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-02 04:21:16 | Niue, New Zealand | ||
601358 | 601358 | 2021-10-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-20 04:21:00 | Niue, New Zealand | ||
605373 | 605373 | 2021-09-23 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-09-24 04:21:44 | Niue, New Zealand | ||
609387 | 609387 | 2021-04-09 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-04-10 04:20:59 | Niue, New Zealand | ||
613373 | 613373 | 2020-08-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-30 04:28:22 | Niue, New Zealand | ||
617387 | 617387 | 2021-02-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-02-09 05:23:30 | Niue, New Zealand | ||
617530 | 617530 | 2020-02-27 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-02-27T12:13:14 | ||||
618001 | 618001 | 2022-11-05 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-06 04:21:24 | Niue, New Zealand | |||
625562 | 625562 | 2022-05-22 | New Zealand | Niue | 9 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-05-26 04:20:50 | Niue, New Zealand | ||
629576 | 629576 | 2021-07-10 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-07-11 04:21:43 | Niue, New Zealand | ||
633592 | 633592 | 2022-07-12 | New Zealand | Niue | 25 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-13 04:20:58 | Niue, New Zealand | ||
637608 | 637608 | 2021-10-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-14 04:21:29 | Niue, New Zealand | ||
641622 | 641622 | 2021-03-31 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-04-01 04:27:05 | Niue, New Zealand | ||
645636 | 645636 | 2021-09-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-09-08 04:21:31 | Niue, New Zealand | ||
649650 | 649650 | 2021-05-05 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-06 04:20:38 | Niue, 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 | ||
657680 | 657680 | 2021-10-22 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-23 04:21:32 | Niue, New Zealand | ||
657982 | 657982 | 2020-03-09 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-09T14:33:03 | ||||
661998 | 661998 | 2022-05-13 | New Zealand | Niue | 9 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-05-14 04:20:48 | Niue, New Zealand | ||
665977 | 665977 | 2020-08-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-12 04:27:29 | Niue, New Zealand | ||
669967 | 669967 | 2020-09-16 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-09-17 04:22:00 | Niue, New Zealand | ||
673983 | 673983 | 2022-07-21 | New Zealand | Niue | 29 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-22 04:21:15 | Niue, New Zealand | ||
677999 | 677999 | 2022-07-30 | New Zealand | Niue | 47 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-31 04:21:02 | Niue, New Zealand | ||
682009 | 682009 | 2020-11-23 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-11-24 05:27:31 | Niue, New Zealand | ||
686025 | 686025 | 2021-10-24 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-25 04:22:31 | Niue, New Zealand | ||
690041 | 690041 | 2021-11-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-14 04:21:31 | Niue, New Zealand | ||
690512 | 690512 | 2022-12-23 | New Zealand | Niue | 349 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-24 04:21:02 | Niue, New Zealand | |||
698073 | 698073 | 2022-03-17 | New Zealand | Niue | 1 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-18 04:20:55 | Niue, New Zealand | ||
702089 | 702089 | 2021-11-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-05 04:21:54 | Niue, New Zealand | ||
706103 | 706103 | 2021-03-16 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-03-17 05:25:07 | Niue, New Zealand | ||
710118 | 710118 | 2021-09-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-09-30 04:21:20 | Niue, New Zealand | ||
710589 | 710589 | 2022-11-01 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-02 04:22:09 | Niue, New Zealand | |||
718150 | 718150 | 2021-11-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-13 04:21:38 | Niue, New Zealand | ||
718621 | 718621 | 2022-12-04 | New Zealand | Niue | 169 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-05 04:20:58 | Niue, New Zealand | |||
726182 | 726182 | 2021-11-20 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-21 04:22:13 | Niue, New Zealand | ||
730196 | 730196 | 2021-05-22 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-23 04:20:51 | Niue, New Zealand | ||
734212 | 734212 | 2021-12-27 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-12-28 04:21:47 | Niue, New Zealand | ||
737987 | 737987 | 2020-06-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-06-13 03:33:14 | Niue, 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]);