johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,034 rows where country_or_region = "New Zealand" and longitude = "174.886" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40231 | 40231 | 2020-03-05 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
62572 | 62572 | 2020-03-07 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
98893 | 98893 | 2020-03-04 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
261139 | 261139 | 2020-03-03 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
339789 | 339789 | 2020-03-21 | New Zealand | 52 | 0 | 0 | -40.9006 | 174.886 | 2020-03-21T02:13:32 | |||||
562599 | 562599 | 2020-03-01 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
657804 | 657804 | 2020-03-09 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
1152747 | 1152747 | 2020-03-02 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
1177047 | 1177047 | 2020-03-18 | New Zealand | 20 | 0 | 0 | -40.9006 | 174.886 | 2020-03-18T02:53:03 | |||||
1463628 | 1463628 | 2020-03-15 | New Zealand | 8 | 0 | 0 | -40.9006 | 174.886 | 2020-03-15T18:20:18 | |||||
1527045 | 1527045 | 2020-03-19 | New Zealand | 28 | 0 | 0 | -40.9006 | 174.886 | 2020-03-19T02:33:08 | |||||
1527316 | 1527316 | 2020-03-08 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
2111255 | 2111255 | 2020-03-14 | New Zealand | 6 | 0 | 0 | -40.9006 | 174.886 | 2020-03-14T20:53:02 | |||||
2127578 | 2127578 | 2020-03-11 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
2255292 | 2255292 | 2020-03-16 | New Zealand | 8 | 0 | 0 | -40.9006 | 174.886 | 2020-03-15T18:20:18 | |||||
2283012 | 2283012 | 2020-03-12 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
3177579 | 3177579 | 2020-03-06 | New Zealand | 4 | 0 | 0 | -40.9006 | 174.886 | 2020-03-06T01:29:39 | |||||
3734090 | 3734090 | 2020-03-20 | New Zealand | 39 | 0 | 0 | -40.9006 | 174.886 | 2020-03-20T02:13:50 | |||||
3752949 | 3752949 | 2020-03-10 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
3765376 | 3765376 | 2020-03-13 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-11T20:00:00 | |||||
3891486 | 3891486 | 2020-03-17 | New Zealand | 12 | 0 | 0 | -40.9006 | 174.886 | 2020-03-17T11:53:10 | |||||
466 | 466 | 2021-12-02 | New Zealand | 11992 | 41 | 0 | -40.9006 | 174.886 | 2021-12-03 04:23:05 | New Zealand | ||||
4482 | 4482 | 2021-10-28 | New Zealand | 6124 | 30 | 0 | -40.9006 | 174.886 | 2021-10-29 04:22:03 | New Zealand | ||||
8462 | 8462 | 2020-10-25 | New Zealand | 1940 | 26 | 1841 | 74 | -40.9006 | 174.886 | 2020-10-26 04:25:02 | New Zealand | |||
12473 | 12473 | 2021-01-26 | New Zealand | 2295 | 27 | 2201 | 69 | -40.9006 | 174.886 | 2021-01-27 05:23:41 | New Zealand | |||
16490 | 16490 | 2021-09-18 | New Zealand | 4060 | 29 | 0 | -40.9006 | 174.886 | 2021-09-19 04:21:34 | New Zealand | ||||
20504 | 20504 | 2021-05-28 | New Zealand | 2670 | 28 | 2623 | 21 | -40.9006 | 174.886 | 2021-05-29 04:20:41 | New Zealand | |||
24537 | 24537 | 2022-03-20 | New Zealand | 497731 | 273 | 0 | -40.9006 | 174.886 | 2022-03-21 04:20:50 | New Zealand | ||||
28552 | 28552 | 2021-11-11 | New Zealand | 8306 | 31 | 0 | -40.9006 | 174.886 | 2021-11-12 04:22:01 | New Zealand | ||||
32551 | 32551 | 2021-08-25 | New Zealand | 3227 | 28 | 0 | -40.9006 | 174.886 | 2021-08-26 04:21:28 | New Zealand | ||||
36563 | 36563 | 2021-04-12 | New Zealand | 2587 | 28 | 2459 | 102 | -40.9006 | 174.886 | 2021-04-13 04:20:37 | 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 | |||
43844 | 43844 | 2021-11-02 | New Zealand | 6832 | 31 | 0 | -40.9006 | 174.886 | 2021-11-03 06:22:09 | New Zealand | ||||
50378 | 50378 | 2020-04-17 | New Zealand | 1409 | 12 | 816 | 582 | -40.9006 | 174.886 | 2020-04-17 23:30:32 | New Zealand | |||
50925 | 50925 | 2021-05-29 | New Zealand | 2672 | 28 | 2630 | 16 | -40.9006 | 174.886 | 2021-05-30 04:20:55 | New Zealand | |||
54938 | 54938 | 2021-03-07 | New Zealand | 2405 | 28 | 2301 | 78 | -40.9006 | 174.886 | 2021-03-08 05:24:48 | New Zealand | |||
62340 | 62340 | 2020-07-23 | New Zealand | 1556 | 23 | 1513 | 21 | -40.9006 | 174.886 | 2020-07-24 05:30:40 | New Zealand | |||
63201 | 63201 | 2022-11-12 | New Zealand | 1872459 | 2119 | 0 | -40.9006 | 174.886 | 2022-11-13 04:21:14 | New Zealand | ||||
67196 | 67196 | 2021-09-01 | New Zealand | 3645 | 29 | 0 | -40.9006 | 174.886 | 2021-09-02 04:21:15 | New Zealand | ||||
71227 | 71227 | 2022-02-07 | New Zealand | 18253 | 52 | 0 | -40.9006 | 174.886 | 2022-02-08 04:21:15 | New Zealand | ||||
75221 | 75221 | 2020-12-03 | New Zealand | 2069 | 26 | 1983 | 61 | -40.9006 | 174.886 | 2020-12-04 05:27:27 | New Zealand | |||
79218 | 79218 | 2020-10-14 | New Zealand | 1876 | 26 | 1809 | 42 | -40.9006 | 174.886 | 2020-10-15 04:24:28 | New Zealand | |||
83228 | 83228 | 2021-05-25 | New Zealand | 2669 | 28 | 2621 | 22 | -40.9006 | 174.886 | 2021-05-26 04:20:35 | New Zealand | |||
87261 | 87261 | 2021-11-09 | New Zealand | 7922 | 31 | 0 | -40.9006 | 174.886 | 2021-11-10 04:21:38 | New Zealand | ||||
91279 | 91279 | 2022-07-23 | New Zealand | 1563510 | 1410 | 0 | -40.9006 | 174.886 | 2022-07-24 04:20:47 | New Zealand | ||||
98704 | 98704 | 2020-08-04 | New Zealand | 1569 | 23 | 1523 | 24 | -40.9006 | 174.886 | 2020-08-05 04:34:43 | New Zealand | |||
99462 | 99462 | 2022-01-14 | New Zealand | 15001 | 51 | 0 | -40.9006 | 174.886 | 2022-01-15 04:21:07 | New Zealand | ||||
103461 | 103461 | 2021-08-15 | New Zealand | 2926 | 28 | 0 | -40.9006 | 174.886 | 2021-08-16 04:21:31 | New Zealand | ||||
107586 | 107586 | 2021-06-19 | New Zealand | 2718 | 28 | 2670 | 22 | -40.9006 | 174.886 | 2021-06-20 04:21:48 | New Zealand | |||
114319 | 114319 | 2020-05-08 | New Zealand | 1492 | 21 | 1368 | 103 | -40.9006 | 174.886 | 2020-05-09 02:32:35 | New Zealand | |||
114889 | 114889 | 2022-09-06 | New Zealand | 1753182 | 1939 | 0 | -40.9006 | 174.886 | 2022-09-07 04:20:59 | New Zealand | ||||
122295 | 122295 | 2020-07-19 | New Zealand | 1554 | 23 | 1506 | 26 | -40.9006 | 174.886 | 2020-07-20 05:34:40 | New Zealand | |||
122836 | 122836 | 2020-11-18 | New Zealand | 2010 | 26 | 1948 | 37 | -40.9006 | 174.886 | 2020-11-19 05:25:23 | New Zealand | |||
126869 | 126869 | 2022-01-09 | New Zealand | 14733 | 51 | 0 | -40.9006 | 174.886 | 2022-01-10 04:22:07 | New Zealand | ||||
130889 | 130889 | 2022-10-04 | New Zealand | 1789425 | 2038 | 0 | -40.9006 | 174.886 | 2022-10-05 04:23:06 | New Zealand | ||||
137542 | 137542 | 2020-04-29 | New Zealand | 1476 | 20 | 1241 | 216 | -40.9006 | 174.886 | 2020-04-30 02:32:27 | New Zealand | |||
138107 | 138107 | 2021-12-04 | New Zealand | 12195 | 41 | 0 | -40.9006 | 174.886 | 2021-12-05 04:22:25 | New Zealand | ||||
142125 | 142125 | 2022-07-09 | New Zealand | 1429924 | 1180 | 0 | -40.9006 | 174.886 | 2022-07-10 04:20:54 | New Zealand | ||||
146102 | 146102 | 2020-08-15 | New Zealand | 1622 | 23 | 1531 | 69 | -40.9006 | 174.886 | 2020-08-16 04:27:42 | New Zealand | |||
150120 | 150120 | 2021-11-29 | New Zealand | 11576 | 41 | 0 | -40.9006 | 174.886 | 2021-11-30 04:22:53 | New Zealand | ||||
154115 | 154115 | 2021-01-08 | New Zealand | 2188 | 26 | 2101 | 62 | -40.9006 | 174.886 | 2021-01-09 05:22:18 | New Zealand | |||
158149 | 158149 | 2022-03-29 | New Zealand | 643875 | 365 | 0 | -40.9006 | 174.886 | 2022-03-30 04:20:45 | New Zealand | ||||
162164 | 162164 | 2021-11-19 | New Zealand | 9823 | 36 | 0 | -40.9006 | 174.886 | 2021-11-20 04:22:17 | New Zealand | ||||
166182 | 166182 | 2022-06-21 | New Zealand | 1289128 | 1046 | 0 | -40.9006 | 174.886 | 2022-06-22 04:20:54 | New Zealand | ||||
170177 | 170177 | 2021-04-16 | New Zealand | 2591 | 28 | 2464 | 101 | -40.9006 | 174.886 | 2021-04-17 04:20:40 | New Zealand | |||
177613 | 177613 | 2020-07-27 | New Zealand | 1557 | 23 | 1514 | 21 | -40.9006 | 174.886 | 2020-07-28 04:58:43 | New Zealand | |||
178161 | 178161 | 2021-09-02 | New Zealand | 3729 | 29 | 0 | -40.9006 | 174.886 | 2021-09-03 04:21:20 | New Zealand | ||||
182173 | 182173 | 2021-02-21 | New Zealand | 2357 | 28 | 2277 | 54 | -40.9006 | 174.886 | 2021-02-22 05:24:21 | New Zealand | |||
186207 | 186207 | 2022-02-13 | New Zealand | 21573 | 53 | 0 | -40.9006 | 174.886 | 2022-02-14 04:20:51 | New Zealand | ||||
190201 | 190201 | 2021-01-11 | New Zealand | 2222 | 27 | 2120 | 77 | -40.9006 | 174.886 | 2021-01-12 05:22:15 | New Zealand | |||
194197 | 194197 | 2020-08-31 | New Zealand | 1752 | 25 | 1598 | 132 | -40.9006 | 174.886 | 2020-09-01 04:28:31 | New Zealand | |||
198398 | 198398 | 2022-10-19 | New Zealand | 1814890 | 2065 | 0 | -40.9006 | 174.886 | 2022-10-20 04:22:59 | New Zealand | ||||
202388 | 202388 | 2020-12-25 | New Zealand | 2128 | 26 | 2054 | 49 | -40.9006 | 174.886 | 2020-12-26 05:22:28 | New Zealand | |||
206384 | 206384 | 2020-08-19 | New Zealand | 1654 | 23 | 1531 | 101 | -40.9006 | 174.886 | 2020-08-20 04:27:43 | New Zealand | |||
210371 | 210371 | 2020-10-29 | New Zealand | 1950 | 26 | 1857 | 68 | -40.9006 | 174.886 | 2020-10-30 04:24:49 | New Zealand | |||
217552 | 217552 | 2020-06-08 | New Zealand | 1504 | 23 | 1482 | 0 | -40.9006 | 174.886 | 2020-06-09 03:33:03 | New Zealand | |||
218119 | 218119 | 2022-12-26 | New Zealand | 2062384 | 2288 | 0 | -40.9006 | 174.886 | 2022-12-27 04:21:07 | New Zealand | ||||
222132 | 222132 | 2022-05-09 | New Zealand | 1005674 | 750 | 0 | -40.9006 | 174.886 | 2022-05-10 04:20:50 | New Zealand | ||||
228796 | 228796 | 2020-04-30 | New Zealand | 1479 | 20 | 1252 | 208 | -40.9006 | 174.886 | 2020-05-01 02:32:28 | New Zealand | |||
229364 | 229364 | 2022-05-31 | New Zealand | 1170815 | 890 | 0 | -40.9006 | 174.886 | 2022-06-01 04:20:55 | New Zealand | ||||
233379 | 233379 | 2022-02-11 | New Zealand | 19777 | 52 | 0 | -40.9006 | 174.886 | 2022-02-12 04:21:06 | New Zealand | ||||
237373 | 237373 | 2021-01-18 | New Zealand | 2262 | 27 | 2152 | 85 | -40.9006 | 174.886 | 2021-01-19 05:22:15 | New Zealand | |||
241388 | 241388 | 2021-04-02 | New Zealand | 2501 | 28 | 2408 | 67 | -40.9006 | 174.886 | 2021-04-03 04:20:44 | New Zealand | |||
245404 | 245404 | 2021-08-17 | New Zealand | 2936 | 28 | 0 | -40.9006 | 174.886 | 2021-08-18 04:21:35 | New Zealand | ||||
249418 | 249418 | 2021-09-04 | New Zealand | 3768 | 29 | 0 | -40.9006 | 174.886 | 2021-09-05 04:21:33 | New Zealand | ||||
253451 | 253451 | 2022-09-08 | New Zealand | 1756443 | 1944 | 0 | -40.9006 | 174.886 | 2022-09-09 04:21:11 | New Zealand | ||||
257469 | 257469 | 2022-12-10 | New Zealand | 1979614 | 2235 | 0 | -40.9006 | 174.886 | 2022-12-11 04:20:50 | New Zealand | ||||
261669 | 261669 | 2022-03-15 | New Zealand | 399342 | 180 | 0 | -40.9006 | 174.886 | 2022-03-16 04:20:50 | New Zealand | ||||
268553 | 268553 | 2020-05-21 | New Zealand | 1504 | 22 | 1455 | 28 | -40.9006 | 174.886 | 2020-05-22 02:36:51 | New Zealand | |||
271756 | 271756 | 2020-04-28 | New Zealand | 1474 | 20 | 1229 | 226 | -40.9006 | 174.886 | 2020-04-29 02:32:29 | New Zealand | |||
272286 | 272286 | 2020-11-10 | New Zealand | 1988 | 26 | 1911 | 52 | -40.9006 | 174.886 | 2020-11-11 05:25:30 | New Zealand | |||
276319 | 276319 | 2021-11-03 | New Zealand | 6972 | 31 | 0 | -40.9006 | 174.886 | 2021-11-04 04:22:20 | New Zealand | ||||
280316 | 280316 | 2021-02-24 | New Zealand | 2368 | 28 | 2277 | 65 | -40.9006 | 174.886 | 2021-02-25 05:24:57 | New Zealand | |||
287575 | 287575 | 2020-06-15 | New Zealand | 1506 | 23 | 1482 | 2 | -40.9006 | 174.886 | 2020-06-16 04:33:09 | New Zealand | |||
288132 | 288132 | 2021-10-31 | New Zealand | 6594 | 31 | 0 | -40.9006 | 174.886 | 2021-11-01 04:22:01 | New Zealand | ||||
292152 | 292152 | 2022-11-15 | New Zealand | 1894029 | 2154 | 0 | -40.9006 | 174.886 | 2022-11-16 04:21:09 | New Zealand | ||||
296147 | 296147 | 2021-07-15 | New Zealand | 2803 | 28 | 2729 | 48 | -40.9006 | 174.886 | 2021-07-16 04:21:22 | New Zealand | |||
303447 | 303447 | 2020-07-01 | New Zealand | 1530 | 23 | 1490 | 18 | -40.9006 | 174.886 | 2020-07-02 04:33:46 | New Zealand | |||
304005 | 304005 | 2022-04-16 | New Zealand | 824867 | 516 | 0 | -40.9006 | 174.886 | 2022-04-17 04:20:59 | New Zealand | ||||
308024 | 308024 | 2022-12-13 | New Zealand | 2019685 | 2257 | 0 | -40.9006 | 174.886 | 2022-12-14 04:21:04 | 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]);