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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 2
- Niue 1,030
- Cook Islands 1,029
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40337 | 40337 | 2020-03-05 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-05T14:53:03 | ||||
3177579 | 3177579 | 2020-03-06 | New Zealand | 4 | 0 | 0 | -40.9006 | 174.886 | 2020-03-06T01:29:39 | |||||
3177676 | 3177676 | 2020-03-06 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-06T14:23:04 | ||||
3177707 | 3177707 | 2020-03-06 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-06T14:23:04 | ||||
62572 | 62572 | 2020-03-07 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
657804 | 657804 | 2020-03-09 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
1527316 | 1527316 | 2020-03-08 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
2127578 | 2127578 | 2020-03-11 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
2283012 | 2283012 | 2020-03-12 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
3752949 | 3752949 | 2020-03-10 | 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 | ||||
1527456 | 1527456 | 2020-03-08 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-08T14:43:03 | ||||
1527487 | 1527487 | 2020-03-08 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-08T14:43:03 | ||||
657951 | 657951 | 2020-03-09 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-09T14:33:03 | ||||
657982 | 657982 | 2020-03-09 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-09T14:33:03 | ||||
3753022 | 3753022 | 2020-03-10 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-10T15:13:05 | ||||
3753053 | 3753053 | 2020-03-10 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-10T15:13:05 | ||||
2127648 | 2127648 | 2020-03-11 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-11T10:53:02 | ||||
2127679 | 2127679 | 2020-03-11 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-11T10:53:02 | ||||
3765376 | 3765376 | 2020-03-13 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-11T20:00:00 | |||||
2283080 | 2283080 | 2020-03-12 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-12T09:53:06 | ||||
2283111 | 2283111 | 2020-03-12 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-12T09:53:06 | ||||
3765516 | 3765516 | 2020-03-13 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-13T11:09:03 | ||||
3765547 | 3765547 | 2020-03-13 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-13T11:09:03 | ||||
2111337 | 2111337 | 2020-03-14 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-14T10:13:09 | ||||
2111368 | 2111368 | 2020-03-14 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-14T10:13:09 | ||||
2111255 | 2111255 | 2020-03-14 | New Zealand | 6 | 0 | 0 | -40.9006 | 174.886 | 2020-03-14T20:53:02 | |||||
1463628 | 1463628 | 2020-03-15 | New Zealand | 8 | 0 | 0 | -40.9006 | 174.886 | 2020-03-15T18:20:18 | |||||
1463721 | 1463721 | 2020-03-15 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-15T18:20:18 | ||||
1463752 | 1463752 | 2020-03-15 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-15T18:20:18 | ||||
2255292 | 2255292 | 2020-03-16 | New Zealand | 8 | 0 | 0 | -40.9006 | 174.886 | 2020-03-15T18:20:18 | |||||
2255386 | 2255386 | 2020-03-16 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-16T14:38:45 | ||||
2255417 | 2255417 | 2020-03-16 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-16T14:38:45 | ||||
3891486 | 3891486 | 2020-03-17 | New Zealand | 12 | 0 | 0 | -40.9006 | 174.886 | 2020-03-17T11:53:10 | |||||
3891584 | 3891584 | 2020-03-17 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-17T11:53:10 | ||||
3891615 | 3891615 | 2020-03-17 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-17T11:53:10 | ||||
1177047 | 1177047 | 2020-03-18 | New Zealand | 20 | 0 | 0 | -40.9006 | 174.886 | 2020-03-18T02:53:03 | |||||
1177161 | 1177161 | 2020-03-18 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-18T12:13:09 | ||||
1177192 | 1177192 | 2020-03-18 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-18T12:13:09 | ||||
1527045 | 1527045 | 2020-03-19 | New Zealand | 28 | 0 | 0 | -40.9006 | 174.886 | 2020-03-19T02:33:08 | |||||
1527165 | 1527165 | 2020-03-19 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-19T10:13:14 | ||||
1527196 | 1527196 | 2020-03-19 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-19T10:13:14 | ||||
3734090 | 3734090 | 2020-03-20 | New Zealand | 39 | 0 | 0 | -40.9006 | 174.886 | 2020-03-20T02:13:50 | |||||
3734221 | 3734221 | 2020-03-20 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-20T07:43:02 | ||||
3734252 | 3734252 | 2020-03-20 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-20T07:43:02 | ||||
339789 | 339789 | 2020-03-21 | New Zealand | 52 | 0 | 0 | -40.9006 | 174.886 | 2020-03-21T02:13:32 | |||||
339929 | 339929 | 2020-03-21 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-21T10:13:08 | ||||
339960 | 339960 | 2020-03-21 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-21T10:13:08 | ||||
2147218 | 2147218 | 2020-03-23 | New Zealand | 102 | 0 | 0 | 102 | -40.9006 | 174.886 | 2020-03-23 23:19:21 | New Zealand | |||
2147278 | 2147278 | 2020-03-23 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-23 23:19:34 | Cook Islands, New Zealand | ||
2147309 | 2147309 | 2020-03-23 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-23 23:19:34 | Niue, New Zealand | ||
1479164 | 1479164 | 2020-03-24 | New Zealand | 155 | 0 | 12 | 143 | -40.9006 | 174.886 | 2020-03-24 23:37:15 | New Zealand | |||
1479224 | 1479224 | 2020-03-24 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-24 23:37:31 | Cook Islands, New Zealand | ||
1479255 | 1479255 | 2020-03-24 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-24 23:37:31 | Niue, New Zealand | ||
1132659 | 1132659 | 2020-03-25 | New Zealand | 205 | 0 | 22 | 183 | -40.9006 | 174.886 | 2020-03-25 23:33:04 | New Zealand | |||
1132720 | 1132720 | 2020-03-25 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-25 23:33:19 | Cook Islands, New Zealand | ||
1132751 | 1132751 | 2020-03-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-25 23:33:19 | Niue, New Zealand | ||
919259 | 919259 | 2020-03-26 | New Zealand | 283 | 0 | 27 | 256 | -40.9006 | 174.886 | 2020-03-26 23:48:18 | New Zealand | |||
919321 | 919321 | 2020-03-26 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-26 23:48:35 | Cook Islands, New Zealand | ||
919352 | 919352 | 2020-03-26 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-26 23:48:35 | Niue, New Zealand | ||
809229 | 809229 | 2020-03-27 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-27 22:14:55 | Cook Islands, New Zealand | ||
809260 | 809260 | 2020-03-27 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-27 22:14:55 | Niue, New Zealand | ||
809167 | 809167 | 2020-03-27 | New Zealand | 368 | 0 | 37 | 331 | -40.9006 | 174.886 | 2020-03-27 23:23:03 | New Zealand | |||
3815996 | 3815996 | 2020-03-31 | New Zealand | 647 | 1 | 74 | 572 | -40.9006 | 174.886 | 2020-03-31 23:43:43 | New Zealand | |||
3816059 | 3816059 | 2020-03-31 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-31 23:43:56 | Cook Islands, New Zealand | ||
3816090 | 3816090 | 2020-03-31 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-31 23:43:56 | Niue, New Zealand | ||
3364903 | 3364903 | 2020-04-01 | New Zealand | 708 | 1 | 83 | 624 | -40.9006 | 174.886 | 2020-04-01 21:58:34 | New Zealand | |||
3364966 | 3364966 | 2020-04-01 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-01 21:58:49 | Cook Islands, New Zealand | ||
3364997 | 3364997 | 2020-04-01 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-01 21:58:49 | Niue, New Zealand | ||
3740670 | 3740670 | 2020-04-03 | New Zealand | 868 | 1 | 103 | 764 | -40.9006 | 174.886 | 2020-04-03 22:46:20 | New Zealand | |||
3740734 | 3740734 | 2020-04-03 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-03 22:46:37 | Cook Islands, New Zealand | ||
3740765 | 3740765 | 2020-04-03 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-03 22:46:37 | Niue, New Zealand | ||
589216 | 589216 | 2020-04-05 | New Zealand | 1039 | 4 | 156 | 882 | -40.9006 | 174.886 | 2020-04-05 23:06:26 | New Zealand | |||
589281 | 589281 | 2020-04-05 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-05 23:06:45 | Cook Islands, 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 | ||
3021846 | 3021846 | 2020-04-07 | New Zealand | 1160 | 4 | 241 | 918 | -40.9006 | 174.886 | 2020-04-07 23:04:29 | New Zealand | |||
3021911 | 3021911 | 2020-04-07 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-07 23:04:49 | Cook Islands, New Zealand | ||
3021942 | 3021942 | 2020-04-07 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-07 23:04:49 | Niue, New Zealand | ||
3562171 | 3562171 | 2020-04-08 | New Zealand | 1210 | 4 | 282 | 927 | -40.9006 | 174.886 | 2020-04-08 22:51:39 | New Zealand | |||
3562236 | 3562236 | 2020-04-08 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-08 22:51:58 | Cook Islands, New Zealand | ||
3562267 | 3562267 | 2020-04-08 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-08 22:51:58 | Niue, New Zealand | ||
3950064 | 3950064 | 2020-04-09 | New Zealand | 1239 | 4 | 317 | 921 | -40.9006 | 174.886 | 2020-04-09 23:02:19 | New Zealand | |||
3950129 | 3950129 | 2020-04-09 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-09 23:02:37 | Cook Islands, New Zealand | ||
3950160 | 3950160 | 2020-04-09 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-09 23:02:37 | Niue, New Zealand | ||
1250327 | 1250327 | 2020-04-10 | New Zealand | 1283 | 4 | 373 | 908 | -40.9006 | 174.886 | 2020-04-10 22:53:48 | New Zealand | |||
1250394 | 1250394 | 2020-04-10 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-10 22:54:07 | Cook Islands, New Zealand | ||
1250425 | 1250425 | 2020-04-10 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-10 22:54:07 | Niue, New Zealand | ||
2567142 | 2567142 | 2020-04-11 | New Zealand | 1312 | 4 | 422 | 886 | -40.9006 | 174.886 | 2020-04-11 22:45:13 | New Zealand | |||
2567209 | 2567209 | 2020-04-11 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-11 22:45:33 | Cook Islands, New Zealand | ||
2567240 | 2567240 | 2020-04-11 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-11 22:45:33 | Niue, New Zealand | ||
2578305 | 2578305 | 2020-04-12 | New Zealand | 1330 | 12 | 471 | 855 | -40.9006 | 174.886 | 2020-04-12 23:17:00 | New Zealand | |||
2578372 | 2578372 | 2020-04-12 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-12 23:18:00 | Cook Islands, New Zealand | ||
2578403 | 2578403 | 2020-04-12 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-12 23:18:00 | Niue, New Zealand | ||
43279 | 43279 | 2020-04-13 | New Zealand | 1349 | 12 | 546 | 798 | -40.9006 | 174.886 | 2020-04-13 23:07:34 | New Zealand | |||
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 | ||
43376 | 43376 | 2020-04-13 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-13 23:07:54 | Niue, New Zealand | ||
3338182 | 3338182 | 2020-04-14 | New Zealand | 1366 | 12 | 628 | 729 | -40.9006 | 174.886 | 2020-04-14 23:33:12 | New Zealand | |||
3338248 | 3338248 | 2020-04-14 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-14 23:33:31 | Cook Islands, New Zealand | ||
3338279 | 3338279 | 2020-04-14 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-14 23:33:31 | 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]);