daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
124,928 rows where deaths = 1 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Loving | 48301 | 369 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-12-30 04:21:04 | Loving, Texas, US | |
2022-12-29 | US | North Dakota | Billings | 38007 | 167 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-12-30 04:21:04 | Billings, North Dakota, US | |
2022-12-29 | US | Nebraska | Thomas | 31171 | 112 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-12-30 04:21:04 | Thomas, Nebraska, US | |
2022-12-29 | US | Nebraska | Sioux | 31165 | 81 | 1 | 0 | 42.48932059 | -103.7576544 | 2022-12-30 04:21:04 | Sioux, Nebraska, US | |
2022-12-29 | US | Nebraska | McPherson | 31117 | 74 | 1 | 0 | 41.56797682 | -101.0599362 | 2022-12-30 04:21:04 | McPherson, Nebraska, US | |
2022-12-29 | US | Nebraska | Arthur | 31005 | 34 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-12-30 04:21:04 | Arthur, Nebraska, US | |
2022-12-29 | US | Montana | Treasure | 30103 | 147 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-30 04:21:04 | Treasure, Montana, US | |
2022-12-29 | US | Montana | Petroleum | 30069 | 42 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-30 04:21:04 | Petroleum, Montana, US | |
2022-12-29 | US | Montana | Judith Basin | 30045 | 277 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-12-30 04:21:04 | Judith Basin, Montana, US | |
2022-12-29 | US | Kentucky | Unassigned | 90021 | 2504 | 1 | 0 | 38.97065142 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Kentucky, US | |
2022-12-29 | US | Iowa | Unassigned | 90019 | 3 | 1 | 0 | 43.38107862 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Iowa, US | |
2022-12-29 | US | Idaho | Clark | 16033 | 117 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-12-30 04:21:04 | Clark, Idaho, US | |
2022-12-29 | US | Georgia | Unassigned | 90013 | 12646 | 1 | 0 | 34.91369188 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Georgia, US | |
2022-12-29 | US | Alaska | Wrangell | 2275 | 775 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-30 04:21:04 | Wrangell, Alaska, US | |
2022-12-29 | US | Alaska | Haines | 2100 | 789 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-30 04:21:04 | Haines, Alaska, US | |
2022-12-29 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-30 04:21:04 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-12-29 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-30 04:21:04 | Cook Islands, New Zealand | |||
2022-12-29 | Nauru | 4621 | 1 | 0 | -0.5228 | 166.9315 | 2022-12-30 04:21:04 | Nauru | ||||
2022-12-29 | China | Zhejiang | 6235 | 1 | 0 | 29.1832 | 120.0934 | 2022-12-30 04:21:04 | Zhejiang, China | |||
2022-12-29 | China | Jiangxi | 1971 | 1 | 0 | 27.614 | 115.7221 | 2022-12-30 04:21:04 | Jiangxi, China | |||
2022-12-29 | China | Inner Mongolia | 8394 | 1 | 0 | 44.0935 | 113.9448 | 2022-12-30 04:21:04 | Inner Mongolia, China | |||
2022-12-29 | China | Fujian | 7651 | 1 | 0 | 26.0789 | 117.9874 | 2022-12-30 04:21:04 | Fujian, China | |||
2022-12-29 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
2022-12-28 | US | Texas | Loving | 48301 | 369 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-12-29 04:21:01 | Loving, Texas, US | |
2022-12-28 | US | North Dakota | Billings | 38007 | 167 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-12-29 04:21:01 | Billings, North Dakota, US | |
2022-12-28 | US | Nebraska | Thomas | 31171 | 112 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-12-29 04:21:01 | Thomas, Nebraska, US | |
2022-12-28 | US | Nebraska | Sioux | 31165 | 81 | 1 | 0 | 42.48932059 | -103.7576544 | 2022-12-29 04:21:01 | Sioux, Nebraska, US | |
2022-12-28 | US | Nebraska | McPherson | 31117 | 74 | 1 | 0 | 41.56797682 | -101.0599362 | 2022-12-29 04:21:01 | McPherson, Nebraska, US | |
2022-12-28 | US | Nebraska | Arthur | 31005 | 34 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-12-29 04:21:01 | Arthur, Nebraska, US | |
2022-12-28 | US | Montana | Treasure | 30103 | 147 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-29 04:21:01 | Treasure, Montana, US | |
2022-12-28 | US | Montana | Petroleum | 30069 | 42 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-29 04:21:01 | Petroleum, Montana, US | |
2022-12-28 | US | Montana | Judith Basin | 30045 | 277 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-12-29 04:21:01 | Judith Basin, Montana, US | |
2022-12-28 | US | Idaho | Clark | 16033 | 117 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-12-29 04:21:01 | Clark, Idaho, US | |
2022-12-28 | US | Georgia | Unassigned | 90013 | 12646 | 1 | 0 | 34.91369188 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Georgia, US | |
2022-12-28 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-29 04:21:01 | Jackson, Colorado, US | |
2022-12-28 | US | Alaska | Wrangell | 2275 | 775 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-29 04:21:01 | Wrangell, Alaska, US | |
2022-12-28 | US | Alaska | Haines | 2100 | 789 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-29 04:21:01 | Haines, Alaska, US | |
2022-12-28 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-29 04:21:01 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-12-28 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-29 04:21:01 | Cook Islands, New Zealand | |||
2022-12-28 | Nauru | 4621 | 1 | 0 | -0.5228 | 166.9315 | 2022-12-29 04:21:01 | Nauru | ||||
2022-12-28 | China | Zhejiang | 6235 | 1 | 0 | 29.1832 | 120.0934 | 2022-12-29 04:21:01 | Zhejiang, China | |||
2022-12-28 | China | Jiangxi | 1971 | 1 | 0 | 27.614 | 115.7221 | 2022-12-29 04:21:01 | Jiangxi, China | |||
2022-12-28 | China | Inner Mongolia | 8394 | 1 | 0 | 44.0935 | 113.9448 | 2022-12-29 04:21:01 | Inner Mongolia, China | |||
2022-12-28 | China | Fujian | 7651 | 1 | 0 | 26.0789 | 117.9874 | 2022-12-29 04:21:01 | Fujian, China | |||
2022-12-28 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
2022-12-27 | US | Texas | Loving | 48301 | 364 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-12-28 04:21:04 | Loving, Texas, US | |
2022-12-27 | US | North Dakota | Billings | 38007 | 167 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-12-28 04:21:04 | Billings, North Dakota, US | |
2022-12-27 | US | Nebraska | Thomas | 31171 | 112 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-12-28 04:21:04 | Thomas, Nebraska, US | |
2022-12-27 | US | Nebraska | Sioux | 31165 | 81 | 1 | 0 | 42.48932059 | -103.7576544 | 2022-12-28 04:21:04 | Sioux, Nebraska, US | |
2022-12-27 | US | Nebraska | McPherson | 31117 | 74 | 1 | 0 | 41.56797682 | -101.0599362 | 2022-12-28 04:21:04 | McPherson, Nebraska, US | |
2022-12-27 | US | Nebraska | Arthur | 31005 | 34 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-12-28 04:21:04 | Arthur, Nebraska, US | |
2022-12-27 | US | Montana | Treasure | 30103 | 147 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-28 04:21:04 | Treasure, Montana, US | |
2022-12-27 | US | Montana | Petroleum | 30069 | 42 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-28 04:21:04 | Petroleum, Montana, US | |
2022-12-27 | US | Montana | Judith Basin | 30045 | 277 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-12-28 04:21:04 | Judith Basin, Montana, US | |
2022-12-27 | US | Idaho | Clark | 16033 | 116 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-12-28 04:21:04 | Clark, Idaho, US | |
2022-12-27 | US | Georgia | Unassigned | 90013 | 12657 | 1 | 0 | 34.91369188 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Georgia, US | |
2022-12-27 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-28 04:21:04 | Jackson, Colorado, US | |
2022-12-27 | US | Alaska | Wrangell | 2275 | 775 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-28 04:21:04 | Wrangell, Alaska, US | |
2022-12-27 | US | Alaska | Haines | 2100 | 789 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-28 04:21:04 | Haines, Alaska, US | |
2022-12-27 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-28 04:21:04 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-12-27 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-28 04:21:04 | Cook Islands, New Zealand | |||
2022-12-27 | Nauru | 4621 | 1 | 0 | -0.5228 | 166.9315 | 2022-12-28 04:21:04 | Nauru | ||||
2022-12-27 | China | Zhejiang | 6235 | 1 | 0 | 29.1832 | 120.0934 | 2022-12-28 04:21:04 | Zhejiang, China | |||
2022-12-27 | China | Jiangxi | 1971 | 1 | 0 | 27.614 | 115.7221 | 2022-12-28 04:21:04 | Jiangxi, China | |||
2022-12-27 | China | Inner Mongolia | 8394 | 1 | 0 | 44.0935 | 113.9448 | 2022-12-28 04:21:04 | Inner Mongolia, China | |||
2022-12-27 | China | Fujian | 7651 | 1 | 0 | 26.0789 | 117.9874 | 2022-12-28 04:21:04 | Fujian, China | |||
2022-12-27 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
2022-12-26 | US | Texas | Loving | 48301 | 364 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-12-27 04:21:07 | Loving, Texas, US | |
2022-12-26 | US | North Dakota | Billings | 38007 | 167 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-12-27 04:21:07 | Billings, North Dakota, US | |
2022-12-26 | US | Nebraska | Thomas | 31171 | 112 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-12-27 04:21:07 | Thomas, Nebraska, US | |
2022-12-26 | US | Nebraska | Sioux | 31165 | 81 | 1 | 0 | 42.48932059 | -103.7576544 | 2022-12-27 04:21:07 | Sioux, Nebraska, US | |
2022-12-26 | US | Nebraska | McPherson | 31117 | 74 | 1 | 0 | 41.56797682 | -101.0599362 | 2022-12-27 04:21:07 | McPherson, Nebraska, US | |
2022-12-26 | US | Nebraska | Arthur | 31005 | 34 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-12-27 04:21:07 | Arthur, Nebraska, US | |
2022-12-26 | US | Montana | Treasure | 30103 | 147 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-27 04:21:07 | Treasure, Montana, US | |
2022-12-26 | US | Montana | Petroleum | 30069 | 42 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-27 04:21:07 | Petroleum, Montana, US | |
2022-12-26 | US | Montana | Judith Basin | 30045 | 277 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-12-27 04:21:07 | Judith Basin, Montana, US | |
2022-12-26 | US | Idaho | Clark | 16033 | 116 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-12-27 04:21:07 | Clark, Idaho, US | |
2022-12-26 | US | Georgia | Unassigned | 90013 | 12657 | 1 | 0 | 34.91369188 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Georgia, US | |
2022-12-26 | US | Colorado | Jackson | 8057 | 194 | 1 | 0 | 40.6659387 | -106.3408905 | 2022-12-27 04:21:07 | Jackson, Colorado, US | |
2022-12-26 | US | Alaska | Wrangell | 2275 | 774 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-12-27 04:21:07 | Wrangell, Alaska, US | |
2022-12-26 | US | Alaska | Haines | 2100 | 788 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-12-27 04:21:07 | Haines, Alaska, US | |
2022-12-26 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1222 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-12-27 04:21:07 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2022-12-26 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-27 04:21:07 | Cook Islands, New Zealand | |||
2022-12-26 | Nauru | 4621 | 1 | 0 | -0.5228 | 166.9315 | 2022-12-27 04:21:07 | Nauru | ||||
2022-12-26 | China | Zhejiang | 6235 | 1 | 0 | 29.1832 | 120.0934 | 2022-12-27 04:21:07 | Zhejiang, China | |||
2022-12-26 | China | Jiangxi | 1971 | 1 | 0 | 27.614 | 115.7221 | 2022-12-27 04:21:07 | Jiangxi, China | |||
2022-12-26 | China | Inner Mongolia | 8394 | 1 | 0 | 44.0935 | 113.9448 | 2022-12-27 04:21:07 | Inner Mongolia, China | |||
2022-12-26 | China | Fujian | 7651 | 1 | 0 | 26.0789 | 117.9874 | 2022-12-27 04:21:07 | Fujian, China | |||
2022-12-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | |||
2022-12-25 | US | Texas | Loving | 48301 | 364 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-12-26 04:21:06 | Loving, Texas, US | |
2022-12-25 | US | North Dakota | Billings | 38007 | 167 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-12-26 04:21:06 | Billings, North Dakota, US | |
2022-12-25 | US | Nebraska | Thomas | 31171 | 112 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-12-26 04:21:06 | Thomas, Nebraska, US | |
2022-12-25 | US | Nebraska | Sioux | 31165 | 81 | 1 | 0 | 42.48932059 | -103.7576544 | 2022-12-26 04:21:06 | Sioux, Nebraska, US | |
2022-12-25 | US | Nebraska | McPherson | 31117 | 74 | 1 | 0 | 41.56797682 | -101.0599362 | 2022-12-26 04:21:06 | McPherson, Nebraska, US | |
2022-12-25 | US | Nebraska | Arthur | 31005 | 34 | 1 | 0 | 41.56896142 | -101.6959559 | 2022-12-26 04:21:06 | Arthur, Nebraska, US | |
2022-12-25 | US | Montana | Treasure | 30103 | 147 | 1 | 0 | 46.2097322 | -107.2666516 | 2022-12-26 04:21:06 | Treasure, Montana, US | |
2022-12-25 | US | Montana | Petroleum | 30069 | 42 | 1 | 0 | 47.1182463 | -108.2508876 | 2022-12-26 04:21:06 | Petroleum, Montana, US | |
2022-12-25 | US | Montana | Judith Basin | 30045 | 277 | 1 | 0 | 47.04581276 | -110.2660688 | 2022-12-26 04:21:06 | Judith Basin, Montana, US | |
2022-12-25 | US | Idaho | Clark | 16033 | 116 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-12-26 04:21:06 | Clark, Idaho, US | |
2022-12-25 | US | Georgia | Unassigned | 90013 | 12657 | 1 | 0 | 34.91369188 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;