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 day
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 | |||||
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 | ||||
1527316 | 1527316 | 2020-03-08 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
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 | ||||
657804 | 657804 | 2020-03-09 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
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 | ||||
3752949 | 3752949 | 2020-03-10 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
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 | ||||
2127578 | 2127578 | 2020-03-11 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
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 | ||||
2283012 | 2283012 | 2020-03-12 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
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 | ||||
3765376 | 3765376 | 2020-03-13 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-11T20:00:00 | |||||
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 | ||||
2111255 | 2111255 | 2020-03-14 | New Zealand | 6 | 0 | 0 | -40.9006 | 174.886 | 2020-03-14T20:53:02 | |||||
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 | ||||
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 | ||||
2910710 | 2910710 | 2020-03-22 | New Zealand | 102 | 0 | 0 | 102 | -40.9006 | 174.886 | 3/22/20 23:45 | New Zealand | |||
2910825 | 2910825 | 2020-03-22 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 3/22/20 23:45 | Cook Islands, New Zealand | ||
2910856 | 2910856 | 2020-03-22 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 3/22/20 23:45 | Niue, New Zealand | ||
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 | ||
809167 | 809167 | 2020-03-27 | New Zealand | 368 | 0 | 37 | 331 | -40.9006 | 174.886 | 2020-03-27 23:23:03 | 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 | ||
3947119 | 3947119 | 2020-03-28 | New Zealand | 451 | 0 | 50 | 401 | -40.9006 | 174.886 | 3/28/20 23:05 | New Zealand | |||
3947181 | 3947181 | 2020-03-28 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 3/28/20 23:05 | Cook Islands, New Zealand | ||
3947212 | 3947212 | 2020-03-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 3/28/20 23:05 | Niue, New Zealand | ||
2875783 | 2875783 | 2020-03-29 | New Zealand | 514 | 1 | 56 | 457 | -40.9006 | 174.886 | 3/29/20 23:08 | New Zealand | |||
2875845 | 2875845 | 2020-03-29 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 3/29/20 23:08 | Cook Islands, New Zealand | ||
2875876 | 2875876 | 2020-03-29 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 3/29/20 23:08 | Niue, New Zealand | ||
1872547 | 1872547 | 2020-03-30 | New Zealand | 589 | 1 | 63 | 525 | -40.9006 | 174.886 | 3/30/20 22:52 | New Zealand | |||
1872609 | 1872609 | 2020-03-30 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 3/30/20 22:52 | Cook Islands, New Zealand | ||
1872640 | 1872640 | 2020-03-30 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 3/30/20 22:52 | Niue, 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 | ||
3701700 | 3701700 | 2020-04-02 | New Zealand | 797 | 1 | 92 | 704 | -40.9006 | 174.886 | 4/2/20 23:25 | New Zealand | |||
3701764 | 3701764 | 2020-04-02 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 4/2/20 23:25 | Cook Islands, New Zealand | ||
3701795 | 3701795 | 2020-04-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 4/2/20 23:25 | 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 | ||
1750859 | 1750859 | 2020-04-04 | New Zealand | 950 | 1 | 127 | 822 | -40.9006 | 174.886 | 4/4/20 23:34 | New Zealand | |||
1750923 | 1750923 | 2020-04-04 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 4/4/20 23:34 | Cook Islands, New Zealand | ||
1750954 | 1750954 | 2020-04-04 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 4/4/20 23:34 | 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 | ||
3627528 | 3627528 | 2020-04-06 | New Zealand | 1106 | 4 | 176 | 929 | -40.9006 | 174.886 | 4/6/20 23:21 | New Zealand | |||
3627594 | 3627594 | 2020-04-06 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 4/6/20 23:22 | Cook Islands, New Zealand | ||
3627625 | 3627625 | 2020-04-06 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 4/6/20 23:22 | 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 |
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]);