daily_reports (view)
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)
Suggested facets: longitude, day (date), last_update (date)
province_or_state 2
- Cook Islands 1,073
- Niue 1,073
country_or_region 1
- New Zealand · 3,188 ✖
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-12-03 04:23:05 | Cook Islands, New Zealand | |||
2021-12-02 | New Zealand | 11992 | 41 | 0 | -40.9006 | 174.886 | 2021-12-03 04:23:05 | New Zealand | ||||
2021-12-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-12-03 04:23:05 | Niue, New Zealand | ||
2021-10-28 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-10-29 04:22:03 | Cook Islands, New Zealand | |||
2021-10-28 | New Zealand | 6124 | 30 | 0 | -40.9006 | 174.886 | 2021-10-29 04:22:03 | New Zealand | ||||
2021-10-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-29 04:22:03 | Niue, New Zealand | ||
2020-10-25 | New Zealand | 1940 | 26 | 1841 | 74 | -40.9006 | 174.886 | 2020-10-26 04:25:02 | New Zealand | |||
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 | ||
2020-10-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-10-26 04:25:02 | Niue, New Zealand | ||
2021-01-26 | New Zealand | 2295 | 27 | 2201 | 69 | -40.9006 | 174.886 | 2021-01-27 05:23:41 | New Zealand | |||
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 | ||
2021-01-26 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-01-27 05:23:41 | Niue, New Zealand | ||
2021-09-18 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-19 04:21:34 | Cook Islands, New Zealand | |||
2021-09-18 | New Zealand | 4060 | 29 | 0 | -40.9006 | 174.886 | 2021-09-19 04:21:34 | New Zealand | ||||
2021-09-18 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-09-19 04:21:34 | Niue, New Zealand | ||
2021-05-28 | New Zealand | 2670 | 28 | 2623 | 21 | -40.9006 | 174.886 | 2021-05-29 04:20:41 | New Zealand | |||
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 | ||
2021-05-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-29 04:20:41 | Niue, New Zealand | ||
2022-03-20 | New Zealand | Cook Islands | 743 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-21 04:20:50 | Cook Islands, New Zealand | |||
2022-03-20 | New Zealand | 497731 | 273 | 0 | -40.9006 | 174.886 | 2022-03-21 04:20:50 | New Zealand | ||||
2022-03-20 | New Zealand | Niue | 1 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-03-21 04:20:50 | Niue, New Zealand | ||
2021-11-11 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-12 04:22:01 | Cook Islands, New Zealand | |||
2021-11-11 | New Zealand | 8306 | 31 | 0 | -40.9006 | 174.886 | 2021-11-12 04:22:01 | New Zealand | ||||
2021-11-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-12 04:22:01 | Niue, New Zealand | ||
2021-08-25 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-26 04:21:28 | Cook Islands, New Zealand | |||
2021-08-25 | New Zealand | 3227 | 28 | 0 | -40.9006 | 174.886 | 2021-08-26 04:21:28 | New Zealand | ||||
2021-08-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-26 04:21:28 | Niue, New Zealand | ||
2021-04-12 | New Zealand | 2587 | 28 | 2459 | 102 | -40.9006 | 174.886 | 2021-04-13 04:20:37 | New Zealand | |||
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 | ||
2021-04-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-04-13 04:20:37 | Niue, New Zealand | ||
2020-03-05 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
2020-03-05 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-05T14:53:03 | ||||
2020-03-05 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-05T14:53:03 | ||||
2020-04-13 | New Zealand | 1349 | 12 | 546 | 798 | -40.9006 | 174.886 | 2020-04-13 23:07:34 | New Zealand | |||
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 | ||
2020-04-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-13 23:07:54 | Niue, New Zealand | ||
2021-11-02 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-03 06:22:09 | Cook Islands, New Zealand | |||
2021-11-02 | New Zealand | 6832 | 31 | 0 | -40.9006 | 174.886 | 2021-11-03 06:22:09 | New Zealand | ||||
2021-11-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-03 06:22:09 | Niue, New Zealand | ||
2020-04-17 | New Zealand | 1409 | 12 | 816 | 582 | -40.9006 | 174.886 | 2020-04-17 23:30:32 | New Zealand | |||
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 | ||
2020-04-17 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-17 23:30:52 | Niue, New Zealand | ||
2021-05-29 | New Zealand | 2672 | 28 | 2630 | 16 | -40.9006 | 174.886 | 2021-05-30 04:20:55 | New Zealand | |||
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 | ||
2021-05-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-30 04:20:55 | Niue, New Zealand | ||
2021-03-07 | New Zealand | 2405 | 28 | 2301 | 78 | -40.9006 | 174.886 | 2021-03-08 05:24:48 | New Zealand | |||
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 | ||
2021-03-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-03-08 05:24:48 | Niue, New Zealand | ||
2020-07-23 | New Zealand | 1556 | 23 | 1513 | 21 | -40.9006 | 174.886 | 2020-07-24 05:30:40 | New Zealand | |||
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 | ||
2020-07-23 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-07-24 05:30:40 | Niue, New Zealand | ||
2020-03-07 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
2020-03-07 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-07T11:13:04 | ||||
2020-03-07 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-07T11:13:04 | ||||
2022-11-12 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-11-13 04:21:14 | Cook Islands, New Zealand | |||
2022-11-12 | New Zealand | Niue | 85 | 0 | 0 | -19.0544 | -169.8672 | 2022-11-13 04:21:14 | Niue, New Zealand | |||
2022-11-12 | New Zealand | 1872459 | 2119 | 0 | -40.9006 | 174.886 | 2022-11-13 04:21:14 | New Zealand | ||||
2021-09-01 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-02 04:21:15 | Cook Islands, New Zealand | |||
2021-09-01 | New Zealand | 3645 | 29 | 0 | -40.9006 | 174.886 | 2021-09-02 04:21:15 | New Zealand | ||||
2021-09-01 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-09-02 04:21:15 | Niue, New Zealand | ||
2022-02-07 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-08 04:21:15 | Cook Islands, New Zealand | |||
2022-02-07 | New Zealand | 18253 | 52 | 0 | -40.9006 | 174.886 | 2022-02-08 04:21:15 | New Zealand | ||||
2022-02-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-02-08 04:21:15 | Niue, New Zealand | ||
2020-12-03 | New Zealand | 2069 | 26 | 1983 | 61 | -40.9006 | 174.886 | 2020-12-04 05:27:27 | New Zealand | |||
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 | ||
2020-12-03 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-12-04 05:27:27 | Niue, New Zealand | ||
2020-10-14 | New Zealand | 1876 | 26 | 1809 | 42 | -40.9006 | 174.886 | 2020-10-15 04:24:28 | New Zealand | |||
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 | ||
2020-10-14 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-10-15 04:24:28 | Niue, New Zealand | ||
2021-05-25 | New Zealand | 2669 | 28 | 2621 | 22 | -40.9006 | 174.886 | 2021-05-26 04:20:35 | New Zealand | |||
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 | ||
2021-05-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-05-26 04:20:35 | Niue, New Zealand | ||
2021-11-09 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-11-10 04:21:38 | Cook Islands, New Zealand | |||
2021-11-09 | New Zealand | 7922 | 31 | 0 | -40.9006 | 174.886 | 2021-11-10 04:21:38 | New Zealand | ||||
2021-11-09 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-11-10 04:21:38 | Niue, New Zealand | ||
2022-07-23 | New Zealand | Cook Islands | 5847 | 1 | 0 | -21.2367 | -159.7777 | 2022-07-24 04:20:47 | Cook Islands, New Zealand | |||
2022-07-23 | New Zealand | 1563510 | 1410 | 0 | -40.9006 | 174.886 | 2022-07-24 04:20:47 | New Zealand | ||||
2022-07-23 | New Zealand | Niue | 29 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-24 04:20:47 | Niue, New Zealand | ||
2020-08-04 | New Zealand | 1569 | 23 | 1523 | 24 | -40.9006 | 174.886 | 2020-08-05 04:34:43 | New Zealand | |||
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 | ||
2020-08-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-08-05 04:34:43 | Niue, New Zealand | ||
2020-03-04 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
2020-03-04 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-04T12:53:03 | ||||
2020-03-04 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-04T12:53:03 | ||||
2022-01-14 | New Zealand | Cook Islands | 2 | 0 | 0 | -21.2367 | -159.7777 | 2022-01-15 04:21:07 | Cook Islands, New Zealand | |||
2022-01-14 | New Zealand | 15001 | 51 | 0 | -40.9006 | 174.886 | 2022-01-15 04:21:07 | New Zealand | ||||
2022-01-14 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-01-15 04:21:07 | Niue, New Zealand | ||
2021-08-15 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-08-16 04:21:31 | Cook Islands, New Zealand | |||
2021-08-15 | New Zealand | 2926 | 28 | 0 | -40.9006 | 174.886 | 2021-08-16 04:21:31 | New Zealand | ||||
2021-08-15 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-08-16 04:21:31 | Niue, New Zealand | ||
2020-02-15 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-02-15T23:13:05 | ||||
2020-02-15 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-02-15T23:13:05 | ||||
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 | ||
2021-06-19 | New Zealand | 2718 | 28 | 2670 | 22 | -40.9006 | 174.886 | 2021-06-20 04:21:48 | New Zealand | |||
2021-06-19 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-06-20 04:21:48 | Niue, New Zealand | ||
2020-05-08 | New Zealand | 1492 | 21 | 1368 | 103 | -40.9006 | 174.886 | 2020-05-09 02:32:35 | New Zealand | |||
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 | ||
2020-05-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-05-09 02:32:35 | Niue, New Zealand | ||
2022-09-06 | New Zealand | Cook Islands | 6379 | 1 | 0 | -21.2367 | -159.7777 | 2022-09-07 04:20:59 | Cook Islands, New Zealand | |||
2022-09-06 | New Zealand | 1753182 | 1939 | 0 | -40.9006 | 174.886 | 2022-09-07 04:20:59 | New Zealand |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;