johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where country_or_region = "US", deaths = 8 and province_or_state = "Hawaii" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 51 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3122421 | 3122421 | 2021-11-05 | US | Hawaii | Out of HI | 80015 | 2743 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-06 04:21:51 | Out of HI, Hawaii, US | |
699319 | 699319 | 2021-11-04 | US | Hawaii | Out of HI | 80015 | 2730 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-05 04:21:54 | Out of HI, Hawaii, US | |
277097 | 277097 | 2021-11-03 | US | Hawaii | Out of HI | 80015 | 2728 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-04 04:22:20 | Out of HI, Hawaii, US | |
44622 | 44622 | 2021-11-02 | US | Hawaii | Out of HI | 80015 | 2713 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-03 06:22:09 | Out of HI, Hawaii, US | |
3512318 | 3512318 | 2021-11-01 | US | Hawaii | Out of HI | 80015 | 2714 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-02 04:22:03 | Out of HI, Hawaii, US | |
288909 | 288909 | 2021-10-31 | US | Hawaii | Out of HI | 80015 | 2709 | 8 | 0 | 22.03935037 | 0.0 | 2021-11-01 04:22:01 | Out of HI, Hawaii, US | |
935712 | 935712 | 2021-10-16 | US | Hawaii | Kauai | 15007 | 2465 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-17 04:21:29 | Kauai, Hawaii, US | |
2944267 | 2944267 | 2021-10-15 | US | Hawaii | Kauai | 15007 | 2455 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-16 04:21:15 | Kauai, Hawaii, US | |
492547 | 492547 | 2021-10-14 | US | Hawaii | Kauai | 15007 | 2444 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-15 04:21:26 | Kauai, Hawaii, US | |
634835 | 634835 | 2021-10-13 | US | Hawaii | Kauai | 15007 | 2436 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-14 04:21:29 | Kauai, Hawaii, US | |
1492513 | 1492513 | 2021-10-12 | US | Hawaii | Kauai | 15007 | 2431 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-13 04:20:51 | Kauai, Hawaii, US | |
3008246 | 3008246 | 2021-10-11 | US | Hawaii | Kauai | 15007 | 2427 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-12 04:21:09 | Kauai, Hawaii, US | |
424262 | 424262 | 2021-10-10 | US | Hawaii | Kauai | 15007 | 2417 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-11 04:21:31 | Kauai, Hawaii, US | |
2877119 | 2877119 | 2021-10-09 | US | Hawaii | Kauai | 15007 | 2389 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-10 04:21:38 | Kauai, Hawaii, US | |
2960285 | 2960285 | 2021-10-08 | US | Hawaii | Kauai | 15007 | 2380 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-09 04:21:34 | Kauai, Hawaii, US | |
468323 | 468323 | 2021-10-07 | US | Hawaii | Kauai | 15007 | 2373 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-08 04:21:25 | Kauai, Hawaii, US | |
2459703 | 2459703 | 2021-10-06 | US | Hawaii | Kauai | 15007 | 2345 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-07 04:21:36 | Kauai, Hawaii, US | |
3833396 | 3833396 | 2021-10-05 | US | Hawaii | Kauai | 15007 | 2334 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-06 04:21:33 | Kauai, Hawaii, US | |
987889 | 987889 | 2021-10-04 | US | Hawaii | Kauai | 15007 | 2327 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-05 04:21:27 | Kauai, Hawaii, US | |
1275199 | 1275199 | 2021-10-03 | US | Hawaii | Kauai | 15007 | 2313 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-04 04:21:31 | Kauai, Hawaii, US | |
3928952 | 3928952 | 2021-10-02 | US | Hawaii | Kauai | 15007 | 2284 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-03 04:21:24 | Kauai, Hawaii, US | |
2132932 | 2132932 | 2021-10-01 | US | Hawaii | Kauai | 15007 | 2268 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-02 04:21:25 | Kauai, Hawaii, US | |
2773889 | 2773889 | 2021-09-30 | US | Hawaii | Kauai | 15007 | 2255 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-10-01 04:21:35 | Kauai, Hawaii, US | |
707345 | 707345 | 2021-09-29 | US | Hawaii | Kauai | 15007 | 2236 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-30 04:21:20 | Kauai, Hawaii, US | |
1335187 | 1335187 | 2021-09-28 | US | Hawaii | Kauai | 15007 | 2223 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-29 04:21:45 | Kauai, Hawaii, US | |
1236556 | 1236556 | 2021-09-27 | US | Hawaii | Kauai | 15007 | 2215 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-28 04:21:28 | Kauai, Hawaii, US | |
2076857 | 2076857 | 2021-09-26 | US | Hawaii | Kauai | 15007 | 2182 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-27 04:21:16 | Kauai, Hawaii, US | |
1725409 | 1725409 | 2021-09-25 | US | Hawaii | Kauai | 15007 | 2150 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-26 04:21:29 | Kauai, Hawaii, US | |
1922129 | 1922129 | 2021-09-24 | US | Hawaii | Kauai | 15007 | 2131 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-25 04:21:31 | Kauai, Hawaii, US | |
602600 | 602600 | 2021-09-23 | US | Hawaii | Kauai | 15007 | 2104 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-24 04:21:44 | Kauai, Hawaii, US | |
3012244 | 3012244 | 2021-09-22 | US | Hawaii | Kauai | 15007 | 2074 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-23 04:21:43 | Kauai, Hawaii, US | |
3758382 | 3758382 | 2021-09-21 | US | Hawaii | Kauai | 15007 | 2045 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-22 04:21:45 | Kauai, Hawaii, US | |
810485 | 810485 | 2021-09-20 | US | Hawaii | Kauai | 15007 | 2029 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-21 04:21:26 | Kauai, Hawaii, US | |
1815684 | 1815684 | 2021-09-19 | US | Hawaii | Kauai | 15007 | 1997 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-20 04:21:22 | Kauai, Hawaii, US | |
17264 | 17264 | 2021-09-18 | US | Hawaii | Kauai | 15007 | 1952 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-19 04:21:34 | Kauai, Hawaii, US | |
2618949 | 2618949 | 2021-09-17 | US | Hawaii | Kauai | 15007 | 1906 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-18 04:21:24 | Kauai, Hawaii, US | |
2809657 | 2809657 | 2021-09-16 | US | Hawaii | Kauai | 15007 | 1867 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-17 04:21:46 | Kauai, Hawaii, US | |
1375401 | 1375401 | 2021-09-15 | US | Hawaii | Kauai | 15007 | 1829 | 8 | 0 | 22.03935037 | -159.5966786 | 2021-09-16 04:22:19 | Kauai, Hawaii, US | |
428232 | 428232 | 2020-09-07 | US | Hawaii | Maui | 15009 | 358 | 8 | 0 | 350 | 20.86399628 | -156.56890969999995 | 2020-09-08 04:28:25 | Maui, Hawaii, US |
3162517 | 3162517 | 2020-09-06 | US | Hawaii | Maui | 15009 | 354 | 8 | 0 | 346 | 20.86399628 | -156.56890969999995 | 2020-09-07 04:28:30 | Maui, Hawaii, US |
814472 | 814472 | 2020-09-05 | US | Hawaii | Maui | 15009 | 352 | 8 | 0 | 344 | 20.86399628 | -156.56890969999995 | 2020-09-06 04:28:33 | Maui, Hawaii, US |
2662672 | 2662672 | 2020-09-04 | US | Hawaii | Maui | 15009 | 347 | 8 | 0 | 339 | 20.86399628 | -156.56890969999995 | 2020-09-05 04:28:19 | Maui, Hawaii, US |
1355212 | 1355212 | 2020-09-03 | US | Hawaii | Maui | 15009 | 346 | 8 | 0 | 338 | 20.86399628 | -156.56890969999995 | 2020-09-04 04:28:26 | Maui, Hawaii, US |
1106449 | 1106449 | 2020-09-02 | US | Hawaii | Maui | 15009 | 342 | 8 | 0 | 334 | 20.86399628 | -156.56890969999995 | 2020-09-03 04:28:22 | Maui, Hawaii, US |
2060778 | 2060778 | 2020-09-01 | US | Hawaii | Maui | 15009 | 340 | 8 | 0 | 332 | 20.86399628 | -156.56890969999995 | 2020-09-02 04:28:25 | Maui, Hawaii, US |
194963 | 194963 | 2020-08-31 | US | Hawaii | Maui | 15009 | 335 | 8 | 0 | 327 | 20.86399628 | -156.56890969999995 | 2020-09-01 04:28:31 | Maui, Hawaii, US |
3932922 | 3932922 | 2020-08-30 | US | Hawaii | Maui | 15009 | 334 | 8 | 0 | 326 | 20.86399628 | -156.56890969999995 | 2020-08-31 04:28:27 | Maui, Hawaii, US |
610584 | 610584 | 2020-08-29 | US | Hawaii | Maui | 15009 | 330 | 8 | 0 | 322 | 20.86399628 | -156.56890969999995 | 2020-08-30 04:28:22 | Maui, Hawaii, US |
1524079 | 1524079 | 2020-08-28 | US | Hawaii | Maui | 15009 | 324 | 8 | 0 | 316 | 20.86399628 | -156.56890969999995 | 2020-08-29 04:28:19 | Maui, Hawaii, US |
3501013 | 3501013 | 2020-04-25 | US | Hawaii | Honolulu | 15003 | 395 | 8 | 0 | 387 | 21.45803166 | -157.97121819999995 | 2020-04-26 02:30:51 | Honolulu, Hawaii, US |
1457420 | 1457420 | 2020-04-24 | US | Hawaii | Honolulu | 15003 | 392 | 8 | 0 | 384 | 21.45803166 | -157.97121819999995 | 2020-04-25 06:30:53 | Honolulu, 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]);