johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
163 rows where deaths = 2 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: combined_key
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2519085 | 2519085 | 2021-08-18 | US | Hawaii | Kauai | 15007 | 894 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-19 04:21:15 | Kauai, Hawaii, US | |
246177 | 246177 | 2021-08-17 | US | Hawaii | Kauai | 15007 | 868 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-18 04:21:35 | Kauai, Hawaii, US | |
1605140 | 1605140 | 2021-08-16 | US | Hawaii | Kauai | 15007 | 853 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-17 04:21:49 | Kauai, Hawaii, US | |
104234 | 104234 | 2021-08-15 | US | Hawaii | Kauai | 15007 | 839 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-16 04:21:31 | Kauai, Hawaii, US | |
508592 | 508592 | 2021-08-14 | US | Hawaii | Kauai | 15007 | 793 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-15 04:21:41 | Kauai, Hawaii, US | |
1484464 | 1484464 | 2021-08-13 | US | Hawaii | Kauai | 15007 | 778 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-14 04:21:25 | Kauai, Hawaii, US | |
2900594 | 2900594 | 2021-08-12 | US | Hawaii | Kauai | 15007 | 732 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-13 04:21:24 | Kauai, Hawaii, US | |
1343198 | 1343198 | 2021-08-11 | US | Hawaii | Kauai | 15007 | 682 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-12 04:21:25 | Kauai, Hawaii, US | |
2352345 | 2352345 | 2021-08-10 | US | Hawaii | Kauai | 15007 | 665 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-11 04:21:58 | Kauai, Hawaii, US | |
650874 | 650874 | 2021-08-09 | US | Hawaii | Kauai | 15007 | 650 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-10 04:21:27 | Kauai, Hawaii, US | |
590536 | 590536 | 2021-08-08 | US | Hawaii | Kauai | 15007 | 634 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-09 04:21:24 | Kauai, Hawaii, US | |
2204548 | 2204548 | 2021-08-07 | US | Hawaii | Kauai | 15007 | 612 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-08 04:21:33 | Kauai, Hawaii, US | |
1118498 | 1118498 | 2021-08-06 | US | Hawaii | Kauai | 15007 | 595 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-07 04:21:30 | Kauai, Hawaii, US | |
1957435 | 1957435 | 2021-08-05 | US | Hawaii | Kauai | 15007 | 586 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-06 04:21:18 | Kauai, Hawaii, US | |
332814 | 332814 | 2021-08-04 | US | Hawaii | Kauai | 15007 | 579 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-05 04:21:51 | Kauai, Hawaii, US | |
3469085 | 3469085 | 2021-08-03 | US | Hawaii | Kauai | 15007 | 574 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-04 04:21:25 | Kauai, Hawaii, US | |
3684359 | 3684359 | 2021-08-02 | US | Hawaii | Kauai | 15007 | 568 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-03 04:21:39 | Kauai, Hawaii, US | |
3016258 | 3016258 | 2021-08-01 | US | Hawaii | Kauai | 15007 | 554 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-02 04:21:36 | Kauai, Hawaii, US | |
3904881 | 3904881 | 2021-07-31 | US | Hawaii | Kauai | 15007 | 548 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-08-01 04:21:50 | Kauai, Hawaii, US | |
3297086 | 3297086 | 2021-07-30 | US | Hawaii | Kauai | 15007 | 539 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-31 04:21:35 | Kauai, Hawaii, US | |
3386297 | 3386297 | 2021-07-29 | US | Hawaii | Kauai | 15007 | 531 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-30 04:21:34 | Kauai, Hawaii, US | |
409202 | 409202 | 2021-07-28 | US | Hawaii | Kauai | 15007 | 522 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-29 04:21:33 | Kauai, Hawaii, US | |
1307063 | 1307063 | 2021-07-27 | US | Hawaii | Kauai | 15007 | 519 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-28 04:21:39 | Kauai, Hawaii, US | |
3219206 | 3219206 | 2021-07-26 | US | Hawaii | Kauai | 15007 | 515 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-27 04:21:18 | Kauai, Hawaii, US | |
1379415 | 1379415 | 2021-07-25 | US | Hawaii | Kauai | 15007 | 514 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-26 04:21:28 | Kauai, Hawaii, US | |
1331155 | 1331155 | 2021-07-24 | US | Hawaii | Kauai | 15007 | 508 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-25 04:22:12 | Kauai, Hawaii, US | |
3138459 | 3138459 | 2021-07-23 | US | Hawaii | Kauai | 15007 | 500 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-24 00:21:36 | Kauai, Hawaii, US | |
3477219 | 3477219 | 2021-07-22 | US | Hawaii | Kauai | 15007 | 488 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-23 04:21:29 | Kauai, Hawaii, US | |
3332438 | 3332438 | 2021-07-21 | US | Hawaii | Kauai | 15007 | 480 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-22 04:21:19 | Kauai, Hawaii, US | |
2372419 | 2372419 | 2021-07-20 | US | Hawaii | Kauai | 15007 | 476 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-21 04:21:40 | Kauai, Hawaii, US | |
484498 | 484498 | 2021-07-19 | US | Hawaii | Kauai | 15007 | 475 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-20 04:21:48 | Kauai, Hawaii, US | |
2674721 | 2674721 | 2021-07-18 | US | Hawaii | Kauai | 15007 | 471 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-19 04:21:24 | Kauai, Hawaii, US | |
3707033 | 3707033 | 2021-07-17 | US | Hawaii | Kauai | 15007 | 465 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-18 04:22:07 | Kauai, Hawaii, US | |
2948264 | 2948264 | 2021-07-16 | US | Hawaii | Kauai | 15007 | 453 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-17 04:22:22 | Kauai, Hawaii, US | |
296920 | 296920 | 2021-07-15 | US | Hawaii | Kauai | 15007 | 444 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-16 04:21:22 | Kauai, Hawaii, US | |
3632865 | 3632865 | 2021-07-14 | US | Hawaii | Kauai | 15007 | 430 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-15 04:21:48 | Kauai, Hawaii, US | |
579740 | 579740 | 2021-07-13 | US | Hawaii | Kauai | 15007 | 428 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-14 04:21:35 | Kauai, Hawaii, US | |
3741989 | 3741989 | 2021-07-12 | US | Hawaii | Kauai | 15007 | 424 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-13 04:21:18 | Kauai, Hawaii, US | |
3660502 | 3660502 | 2021-07-11 | US | Hawaii | Kauai | 15007 | 417 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-12 04:21:34 | Kauai, Hawaii, US | |
626786 | 626786 | 2021-07-10 | US | Hawaii | Kauai | 15007 | 409 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-11 04:21:43 | Kauai, Hawaii, US | |
830505 | 830505 | 2021-07-09 | US | Hawaii | Kauai | 15007 | 407 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-10 04:21:25 | Kauai, Hawaii, US | |
779269 | 779269 | 2021-07-08 | US | Hawaii | Kauai | 15007 | 400 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-09 04:21:21 | Kauai, Hawaii, US | |
1441491 | 1441491 | 2021-07-07 | US | Hawaii | Kauai | 15007 | 394 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-08 04:21:26 | Kauai, Hawaii, US | |
2694596 | 2694596 | 2021-07-06 | US | Hawaii | Kauai | 15007 | 394 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-07 04:21:20 | Kauai, Hawaii, US | |
1933345 | 1933345 | 2021-07-05 | US | Hawaii | Kauai | 15007 | 393 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-06 04:21:32 | Kauai, Hawaii, US | |
1166076 | 1166076 | 2021-07-04 | US | Hawaii | Kauai | 15007 | 392 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-05 04:21:28 | Kauai, Hawaii, US | |
1496510 | 1496510 | 2021-07-03 | US | Hawaii | Kauai | 15007 | 388 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-04 04:21:38 | Kauai, Hawaii, US | |
2072825 | 2072825 | 2021-07-02 | US | Hawaii | Kauai | 15007 | 377 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-03 04:21:37 | Kauai, Hawaii, US | |
2765841 | 2765841 | 2021-07-01 | US | Hawaii | Kauai | 15007 | 368 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-02 04:21:47 | Kauai, Hawaii, US | |
1894049 | 1894049 | 2021-06-30 | US | Hawaii | Kauai | 15007 | 361 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-07-01 04:21:19 | Kauai, Hawaii, US | |
401172 | 401172 | 2021-06-29 | US | Hawaii | Kauai | 15007 | 361 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-30 04:21:41 | Kauai, Hawaii, US | |
3126415 | 3126415 | 2021-06-28 | US | Hawaii | Kauai | 15007 | 361 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-29 04:21:28 | Kauai, Hawaii, US | |
2590910 | 2590910 | 2021-06-27 | US | Hawaii | Kauai | 15007 | 361 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-28 04:21:29 | Kauai, Hawaii, US | |
3959414 | 3959414 | 2021-06-26 | US | Hawaii | Kauai | 15007 | 358 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-27 04:21:39 | Kauai, Hawaii, US | |
1713233 | 1713233 | 2021-06-25 | US | Hawaii | Kauai | 15007 | 358 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-26 04:21:43 | Kauai, Hawaii, US | |
2296358 | 2296358 | 2021-06-24 | US | Hawaii | Kauai | 15007 | 356 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-25 04:21:33 | Kauai, Hawaii, US | |
2423797 | 2423797 | 2021-06-23 | US | Hawaii | Kauai | 15007 | 349 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-24 04:21:55 | Kauai, Hawaii, US | |
563874 | 563874 | 2021-06-22 | US | Hawaii | Kauai | 15007 | 348 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-23 04:21:46 | Kauai, Hawaii, US | |
3359576 | 3359576 | 2021-06-21 | US | Hawaii | Kauai | 15007 | 347 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-22 04:21:34 | Kauai, Hawaii, US | |
2885275 | 2885275 | 2021-06-20 | US | Hawaii | Kauai | 15007 | 348 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-21 04:21:41 | Kauai, Hawaii, US | |
108358 | 108358 | 2021-06-19 | US | Hawaii | Kauai | 15007 | 346 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-20 04:21:48 | Kauai, Hawaii, US | |
1126501 | 1126501 | 2021-06-18 | US | Hawaii | Kauai | 15007 | 344 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-19 04:22:33 | Kauai, Hawaii, US | |
2912079 | 2912079 | 2021-06-17 | US | Hawaii | Kauai | 15007 | 343 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-18 04:22:16 | Kauai, Hawaii, US | |
3031195 | 3031195 | 2021-06-16 | US | Hawaii | Kauai | 15007 | 339 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-17 04:22:36 | Kauai, Hawaii, US | |
2340301 | 2340301 | 2021-06-15 | US | Hawaii | Kauai | 15007 | 338 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-16 04:22:32 | Kauai, Hawaii, US | |
1564997 | 1564997 | 2021-06-14 | US | Hawaii | Kauai | 15007 | 335 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-15 04:22:22 | Kauai, Hawaii, US | |
3382280 | 3382280 | 2021-06-13 | US | Hawaii | Kauai | 15007 | 328 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-14 04:22:46 | Kauai, Hawaii, US | |
1737414 | 1737414 | 2021-06-12 | US | Hawaii | Kauai | 15007 | 328 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-13 04:22:44 | Kauai, Hawaii, US | |
3971455 | 3971455 | 2021-06-11 | US | Hawaii | Kauai | 15007 | 327 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-12 04:22:22 | Kauai, Hawaii, US | |
2717877 | 2717877 | 2021-06-10 | US | Hawaii | Kauai | 15007 | 327 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-11 04:23:20 | Kauai, Hawaii, US | |
523762 | 523762 | 2021-06-09 | US | Hawaii | Kauai | 15007 | 325 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-10 04:23:17 | Kauai, Hawaii, US | |
3473202 | 3473202 | 2021-06-08 | US | Hawaii | Kauai | 15007 | 325 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-09 04:23:31 | Kauai, Hawaii, US | |
3146486 | 3146486 | 2021-06-07 | US | Hawaii | Kauai | 15007 | 324 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-08 04:22:35 | Kauai, Hawaii, US | |
826488 | 826488 | 2021-06-06 | US | Hawaii | Kauai | 15007 | 325 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-07 04:22:51 | Kauai, Hawaii, US | |
2586893 | 2586893 | 2021-06-05 | US | Hawaii | Kauai | 15007 | 325 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-06 04:24:03 | Kauai, Hawaii, US | |
2316207 | 2316207 | 2021-06-04 | US | Hawaii | Kauai | 15007 | 324 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-05 04:23:03 | Kauai, Hawaii, US | |
1449492 | 1449492 | 2021-06-03 | US | Hawaii | Kauai | 15007 | 324 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-04 04:23:37 | Kauai, Hawaii, US | |
1709216 | 1709216 | 2021-06-02 | US | Hawaii | Kauai | 15007 | 323 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-03 04:23:32 | Kauai, Hawaii, US | |
2105034 | 2105034 | 2021-06-01 | US | Hawaii | Kauai | 15007 | 324 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-02 04:24:34 | Kauai, Hawaii, US | |
1189650 | 1189650 | 2021-05-31 | US | Hawaii | Kauai | 15007 | 321 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-06-01 04:23:09 | Kauai, Hawaii, US | |
3090327 | 3090327 | 2021-05-30 | US | Hawaii | Kauai | 15007 | 320 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-31 03:08:59 | Kauai, Hawaii, US | |
51696 | 51696 | 2021-05-29 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-30 04:20:55 | Kauai, Hawaii, US | |
21275 | 21275 | 2021-05-28 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-29 04:20:41 | Kauai, Hawaii, US | |
1807650 | 1807650 | 2021-05-27 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-28 04:20:36 | Kauai, Hawaii, US | |
1311073 | 1311073 | 2021-05-26 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-27 04:20:59 | Kauai, Hawaii, US | |
83999 | 83999 | 2021-05-25 | US | Hawaii | Kauai | 15007 | 318 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-26 04:20:35 | Kauai, Hawaii, US | |
1413961 | 1413961 | 2021-05-24 | US | Hawaii | Kauai | 15007 | 317 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-25 04:21:08 | Kauai, Hawaii, US | |
1772247 | 1772247 | 2021-05-23 | US | Hawaii | Kauai | 15007 | 317 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-24 04:20:53 | Kauai, Hawaii, US | |
727402 | 727402 | 2021-05-22 | US | Hawaii | Kauai | 15007 | 316 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-23 04:20:51 | Kauai, Hawaii, US | |
1953417 | 1953417 | 2021-05-21 | US | Hawaii | Kauai | 15007 | 316 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-22 04:20:45 | Kauai, Hawaii, US | |
1914116 | 1914116 | 2021-05-20 | US | Hawaii | Kauai | 15007 | 313 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-21 04:20:43 | Kauai, Hawaii, US | |
2256637 | 2256637 | 2021-05-19 | US | Hawaii | Kauai | 15007 | 313 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-20 04:21:05 | Kauai, Hawaii, US | |
2391675 | 2391675 | 2021-05-18 | US | Hawaii | Kauai | 15007 | 312 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-19 04:20:42 | Kauai, Hawaii, US | |
3575500 | 3575500 | 2021-05-17 | US | Hawaii | Kauai | 15007 | 309 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-18 04:20:33 | Kauai, Hawaii, US | |
2940230 | 2940230 | 2021-05-16 | US | Hawaii | Kauai | 15007 | 309 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-17 04:20:34 | Kauai, Hawaii, US | |
1873860 | 1873860 | 2021-05-15 | US | Hawaii | Kauai | 15007 | 309 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-16 04:20:49 | Kauai, Hawaii, US | |
1082829 | 1082829 | 2021-05-14 | US | Hawaii | Kauai | 15007 | 308 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-15 04:20:58 | Kauai, Hawaii, US | |
3055095 | 3055095 | 2021-05-13 | US | Hawaii | Kauai | 15007 | 306 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-14 04:20:41 | Kauai, Hawaii, US | |
2005565 | 2005565 | 2021-05-12 | US | Hawaii | Kauai | 15007 | 306 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-13 04:20:51 | Kauai, Hawaii, US | |
3955396 | 3955396 | 2021-05-11 | US | Hawaii | Kauai | 15007 | 306 | 2 | 0 | 22.03935037 | -159.5966786 | 2021-05-12 04:21:29 | Kauai, Hawaii, US |
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]);