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 recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
16490 | 16490 | 2021-09-18 | New Zealand | 4060 | 29 | 0 | -40.9006 | 174.886 | 2021-09-19 04:21:34 | 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 | ||||
40231 | 40231 | 2020-03-05 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
43844 | 43844 | 2021-11-02 | New Zealand | 6832 | 31 | 0 | -40.9006 | 174.886 | 2021-11-03 06:22:09 | New Zealand | ||||
62572 | 62572 | 2020-03-07 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
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 | ||||
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 | ||||
98893 | 98893 | 2020-03-04 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
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 | ||||
114889 | 114889 | 2022-09-06 | New Zealand | 1753182 | 1939 | 0 | -40.9006 | 174.886 | 2022-09-07 04:20:59 | 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 | ||||
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 | ||||
150120 | 150120 | 2021-11-29 | New Zealand | 11576 | 41 | 0 | -40.9006 | 174.886 | 2021-11-30 04:22:53 | 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 | ||||
178161 | 178161 | 2021-09-02 | New Zealand | 3729 | 29 | 0 | -40.9006 | 174.886 | 2021-09-03 04:21:20 | New Zealand | ||||
186207 | 186207 | 2022-02-13 | New Zealand | 21573 | 53 | 0 | -40.9006 | 174.886 | 2022-02-14 04:20:51 | New Zealand | ||||
198398 | 198398 | 2022-10-19 | New Zealand | 1814890 | 2065 | 0 | -40.9006 | 174.886 | 2022-10-20 04:22:59 | 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 | ||||
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 | ||||
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 | ||||
261139 | 261139 | 2020-03-03 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
261669 | 261669 | 2022-03-15 | New Zealand | 399342 | 180 | 0 | -40.9006 | 174.886 | 2022-03-16 04:20:50 | New Zealand | ||||
276319 | 276319 | 2021-11-03 | New Zealand | 6972 | 31 | 0 | -40.9006 | 174.886 | 2021-11-04 04:22:20 | 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 | ||||
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 | ||||
312040 | 312040 | 2022-11-13 | New Zealand | 1894029 | 2154 | 0 | -40.9006 | 174.886 | 2022-11-14 04:21:09 | New Zealand | ||||
316053 | 316053 | 2022-02-12 | New Zealand | 19777 | 52 | 0 | -40.9006 | 174.886 | 2022-02-13 04:21:00 | New Zealand | ||||
320072 | 320072 | 2022-10-30 | New Zealand | 1851689 | 2106 | 0 | -40.9006 | 174.886 | 2022-10-31 04:21:36 | New Zealand | ||||
328046 | 328046 | 2022-12-27 | New Zealand | 2094354 | 2331 | 0 | -40.9006 | 174.886 | 2022-12-28 04:21:04 | New Zealand | ||||
336073 | 336073 | 2022-03-18 | New Zealand | 471225 | 180 | 0 | -40.9006 | 174.886 | 2022-03-19 04:20:47 | New Zealand | ||||
339789 | 339789 | 2020-03-21 | New Zealand | 52 | 0 | 0 | -40.9006 | 174.886 | 2020-03-21T02:13:32 | |||||
348436 | 348436 | 2022-12-14 | New Zealand | 2019685 | 2257 | 0 | -40.9006 | 174.886 | 2022-12-15 04:20:58 | New Zealand | ||||
356463 | 356463 | 2022-03-11 | New Zealand | 347576 | 118 | 0 | -40.9006 | 174.886 | 2022-03-12 04:20:50 | New Zealand | ||||
360479 | 360479 | 2022-05-07 | New Zealand | 989946 | 697 | 0 | -40.9006 | 174.886 | 2022-05-08 04:20:49 | New Zealand | ||||
372336 | 372336 | 2022-09-13 | New Zealand | 1762125 | 1962 | 0 | -40.9006 | 174.886 | 2022-09-14 04:20:44 | New Zealand | ||||
384363 | 384363 | 2022-09-23 | New Zealand | 1769694 | 1972 | 0 | -40.9006 | 174.886 | 2022-09-24 04:21:40 | New Zealand | ||||
396404 | 396404 | 2022-10-07 | New Zealand | 1789425 | 2038 | 0 | -40.9006 | 174.886 | 2022-10-08 04:22:56 | New Zealand | ||||
404430 | 404430 | 2021-12-07 | New Zealand | 12516 | 42 | 0 | -40.9006 | 174.886 | 2021-12-08 04:22:46 | New Zealand | ||||
419475 | 419475 | 2022-09-18 | New Zealand | 1762125 | 1962 | 0 | -40.9006 | 174.886 | 2022-09-19 04:21:49 | New Zealand | ||||
423487 | 423487 | 2021-10-10 | New Zealand | 4659 | 30 | 0 | -40.9006 | 174.886 | 2021-10-11 04:21:31 | New Zealand | ||||
431497 | 431497 | 2022-11-03 | New Zealand | 1851689 | 2106 | 0 | -40.9006 | 174.886 | 2022-11-04 04:22:11 | New Zealand | ||||
443491 | 443491 | 2021-10-20 | New Zealand | 5315 | 30 | 0 | -40.9006 | 174.886 | 2021-10-21 04:21:18 | New Zealand | ||||
447507 | 447507 | 2021-11-17 | New Zealand | 9452 | 36 | 0 | -40.9006 | 174.886 | 2021-11-18 04:21:33 | New Zealand | ||||
451527 | 451527 | 2022-12-21 | New Zealand | 2062384 | 2288 | 0 | -40.9006 | 174.886 | 2022-12-22 04:20:56 | New Zealand | ||||
459516 | 459516 | 2022-02-02 | New Zealand | 17005 | 52 | 0 | -40.9006 | 174.886 | 2022-02-03 04:21:21 | New Zealand | ||||
463533 | 463533 | 2022-05-02 | New Zealand | 952697 | 697 | 0 | -40.9006 | 174.886 | 2022-05-03 04:21:00 | New Zealand | ||||
467548 | 467548 | 2021-10-07 | New Zealand | 4527 | 30 | 0 | -40.9006 | 174.886 | 2021-10-08 04:21:25 | New Zealand | ||||
475580 | 475580 | 2022-06-26 | New Zealand | 1314145 | 1106 | 0 | -40.9006 | 174.886 | 2022-06-27 04:21:00 | New Zealand | ||||
479730 | 479730 | 2022-11-08 | New Zealand | 1872459 | 2119 | 0 | -40.9006 | 174.886 | 2022-11-09 04:21:22 | New Zealand | ||||
487760 | 487760 | 2022-11-25 | New Zealand | 1918070 | 2182 | 0 | -40.9006 | 174.886 | 2022-11-26 04:21:11 | New Zealand | ||||
491772 | 491772 | 2021-10-14 | New Zealand | 4897 | 30 | 0 | -40.9006 | 174.886 | 2021-10-15 04:21:26 | New Zealand | ||||
495788 | 495788 | 2021-11-06 | New Zealand | 7456 | 31 | 0 | -40.9006 | 174.886 | 2021-11-07 04:21:53 | New Zealand | ||||
499805 | 499805 | 2022-04-02 | New Zealand | 693219 | 365 | 0 | -40.9006 | 174.886 | 2022-04-03 04:20:48 | New Zealand | ||||
503824 | 503824 | 2022-12-17 | New Zealand | 2019685 | 2257 | 0 | -40.9006 | 174.886 | 2022-12-18 04:21:03 | New Zealand | ||||
507819 | 507819 | 2021-08-14 | New Zealand | 2919 | 28 | 0 | -40.9006 | 174.886 | 2021-08-15 04:21:41 | New Zealand | ||||
511833 | 511833 | 2021-08-19 | New Zealand | 2968 | 28 | 0 | -40.9006 | 174.886 | 2021-08-20 04:21:33 | New Zealand | ||||
515868 | 515868 | 2022-10-15 | New Zealand | 1800602 | 2055 | 0 | -40.9006 | 174.886 | 2022-10-16 04:22:39 | New Zealand | ||||
534872 | 534872 | 2021-10-27 | New Zealand | 5995 | 30 | 0 | -40.9006 | 174.886 | 2021-10-28 04:22:08 | New Zealand | ||||
538892 | 538892 | 2022-10-26 | New Zealand | 1831233 | 2095 | 0 | -40.9006 | 174.886 | 2022-10-27 04:22:01 | New Zealand | ||||
542908 | 542908 | 2022-12-15 | New Zealand | 2019685 | 2257 | 0 | -40.9006 | 174.886 | 2022-12-16 04:21:01 | New Zealand | ||||
550910 | 550910 | 2021-12-08 | New Zealand | 12621 | 42 | 0 | -40.9006 | 174.886 | 2021-12-09 04:22:49 | New Zealand | ||||
554926 | 554926 | 2022-01-16 | New Zealand | 15127 | 51 | 0 | -40.9006 | 174.886 | 2022-01-17 04:21:08 | New Zealand | ||||
558944 | 558944 | 2022-06-16 | New Zealand | 1265455 | 993 | 0 | -40.9006 | 174.886 | 2022-06-17 04:20:56 | New Zealand | ||||
562599 | 562599 | 2020-03-01 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
567240 | 567240 | 2021-10-29 | New Zealand | 6285 | 30 | 0 | -40.9006 | 174.886 | 2021-10-30 04:22:03 | New Zealand | ||||
574969 | 574969 | 2022-02-25 | New Zealand | 71122 | 64 | 0 | -40.9006 | 174.886 | 2022-02-26 04:21:12 | New Zealand | ||||
589763 | 589763 | 2021-08-08 | New Zealand | 2890 | 28 | 0 | -40.9006 | 174.886 | 2021-08-09 04:21:24 | New Zealand | ||||
593796 | 593796 | 2022-07-01 | New Zealand | 1352688 | 1106 | 0 | -40.9006 | 174.886 | 2022-07-02 04:21:16 | New Zealand | ||||
597810 | 597810 | 2021-10-19 | New Zealand | 5213 | 30 | 0 | -40.9006 | 174.886 | 2021-10-20 04:21:00 | New Zealand | ||||
601826 | 601826 | 2021-09-23 | New Zealand | 4144 | 29 | 0 | -40.9006 | 174.886 | 2021-09-24 04:21:44 | New Zealand | ||||
618002 | 618002 | 2022-11-05 | New Zealand | 1851689 | 2106 | 0 | -40.9006 | 174.886 | 2022-11-06 04:21:24 | New Zealand | ||||
622016 | 622016 | 2022-05-22 | New Zealand | 1129749 | 845 | 0 | -40.9006 | 174.886 | 2022-05-26 04:20:50 | New Zealand | ||||
630046 | 630046 | 2022-07-12 | New Zealand | 1462257 | 1304 | 0 | -40.9006 | 174.886 | 2022-07-13 04:20:58 | New Zealand | ||||
634060 | 634060 | 2021-10-13 | New Zealand | 4831 | 30 | 0 | -40.9006 | 174.886 | 2021-10-14 04:21:29 | New Zealand | ||||
642073 | 642073 | 2021-09-07 | New Zealand | 3829 | 29 | 0 | -40.9006 | 174.886 | 2021-09-08 04:21:31 | New Zealand | ||||
650101 | 650101 | 2021-08-09 | New Zealand | 2902 | 28 | 0 | -40.9006 | 174.886 | 2021-08-10 04:21:27 | New Zealand | ||||
654132 | 654132 | 2021-10-22 | New Zealand | 5554 | 30 | 0 | -40.9006 | 174.886 | 2021-10-23 04:21:32 | New Zealand | ||||
657804 | 657804 | 2020-03-09 | New Zealand | 5 | 0 | 0 | -40.9006 | 174.886 | 2020-03-07T02:03:29 | |||||
658451 | 658451 | 2022-05-13 | New Zealand | 1037855 | 750 | 0 | -40.9006 | 174.886 | 2022-05-14 04:20:48 | New Zealand | ||||
670437 | 670437 | 2022-07-21 | New Zealand | 1549589 | 1410 | 0 | -40.9006 | 174.886 | 2022-07-22 04:21:15 | New Zealand | ||||
674453 | 674453 | 2022-07-30 | New Zealand | 1616341 | 1502 | 0 | -40.9006 | 174.886 | 2022-07-31 04:21:02 | 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]);