daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
488 rows where deaths = 546 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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-25 | Japan | Okayama | 388741 | 546 | 0 | 34.89246 | 133.826252 | 2022-12-26 04:21:06 | Okayama, Japan | |||
2022-12-19 | US | Virginia | Chesapeake | 51550 | 61609 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-20 04:21:04 | Chesapeake, Virginia, US | |
2022-12-18 | US | Virginia | Chesapeake | 51550 | 61459 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-19 04:21:03 | Chesapeake, Virginia, US | |
2022-12-17 | US | Virginia | Chesapeake | 51550 | 61459 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-18 04:21:03 | Chesapeake, Virginia, US | |
2022-12-16 | US | Virginia | Chesapeake | 51550 | 61459 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-17 04:21:04 | Chesapeake, Virginia, US | |
2022-12-15 | US | Virginia | Chesapeake | 51550 | 61399 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-16 04:21:01 | Chesapeake, Virginia, US | |
2022-12-14 | US | Virginia | Chesapeake | 51550 | 61340 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-15 04:20:58 | Chesapeake, Virginia, US | |
2022-12-14 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-15 04:20:58 | Hays, Texas, US | |
2022-12-13 | US | Virginia | Chesapeake | 51550 | 61288 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-14 04:21:04 | Chesapeake, Virginia, US | |
2022-12-13 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-14 04:21:04 | Hays, Texas, US | |
2022-12-12 | US | Virginia | Chesapeake | 51550 | 61243 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-13 04:21:01 | Chesapeake, Virginia, US | |
2022-12-12 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-13 04:21:01 | Hays, Texas, US | |
2022-12-11 | US | Virginia | Chesapeake | 51550 | 61128 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-12 04:21:01 | Chesapeake, Virginia, US | |
2022-12-11 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-12 04:21:01 | Hays, Texas, US | |
2022-12-10 | US | Virginia | Chesapeake | 51550 | 61128 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-11 04:20:50 | Chesapeake, Virginia, US | |
2022-12-10 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-11 04:20:50 | Hays, Texas, US | |
2022-12-09 | US | Virginia | Chesapeake | 51550 | 61128 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-10 04:21:02 | Chesapeake, Virginia, US | |
2022-12-09 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-10 04:21:02 | Hays, Texas, US | |
2022-12-08 | US | Virginia | Chesapeake | 51550 | 61083 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-09 04:21:05 | Chesapeake, Virginia, US | |
2022-12-08 | US | Texas | Hays | 48209 | 75576 | 546 | 0 | 30.05669873 | -98.02944344 | 2022-12-09 04:21:05 | Hays, Texas, US | |
2022-12-07 | US | Virginia | Chesapeake | 51550 | 61042 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-08 04:21:07 | Chesapeake, Virginia, US | |
2022-12-06 | US | Virginia | Chesapeake | 51550 | 61001 | 546 | 0 | 36.67670048 | -76.30545744 | 2022-12-07 04:20:58 | Chesapeake, Virginia, US | |
2022-12-06 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-07 04:20:58 | Minnehaha, South Dakota, US | |
2022-12-05 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-06 04:21:03 | Minnehaha, South Dakota, US | |
2022-12-04 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-05 04:20:58 | Minnehaha, South Dakota, US | |
2022-12-03 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-04 04:20:56 | Minnehaha, South Dakota, US | |
2022-12-02 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-03 04:21:02 | Minnehaha, South Dakota, US | |
2022-12-01 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-02 04:21:07 | Minnehaha, South Dakota, US | |
2022-11-30 | US | South Dakota | Minnehaha | 46099 | 63033 | 546 | 0 | 43.67441641 | -96.7910885 | 2022-12-01 04:21:03 | Minnehaha, South Dakota, US | |
2022-11-29 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-30 04:21:07 | Lebanon, Pennsylvania, US | |
2022-11-28 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-29 04:21:05 | Lebanon, Pennsylvania, US | |
2022-11-27 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-28 04:21:02 | Lebanon, Pennsylvania, US | |
2022-11-26 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-27 04:21:05 | Lebanon, Pennsylvania, US | |
2022-11-25 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-26 04:21:11 | Lebanon, Pennsylvania, US | |
2022-11-24 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-25 04:21:06 | Lebanon, Pennsylvania, US | |
2022-11-23 | US | Pennsylvania | Lebanon | 42075 | 42818 | 546 | 0 | 40.36680311 | -76.45651841 | 2022-11-24 04:21:09 | Lebanon, Pennsylvania, US | |
2022-11-09 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-10 04:21:16 | Dalarna, Sweden | |||
2022-11-08 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-09 04:21:22 | Dalarna, Sweden | |||
2022-11-07 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-08 04:21:21 | Dalarna, Sweden | |||
2022-11-06 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-07 04:21:26 | Dalarna, Sweden | |||
2022-11-05 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-06 04:21:24 | Dalarna, Sweden | |||
2022-11-04 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-05 04:21:52 | Dalarna, Sweden | |||
2022-11-03 | Sweden | Dalarna | 75286 | 546 | 0 | 61.0917 | 14.6664 | 2022-11-04 04:22:11 | Dalarna, Sweden | |||
2022-11-01 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-11-02 04:22:09 | Floyd, Georgia, US | |
2022-10-31 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-11-01 04:22:36 | Floyd, Georgia, US | |
2022-10-30 | US | Virginia | Richmond City | 51760 | 58309 | 546 | 0 | 37.53255773 | -77.47966921 | 2022-10-31 04:21:36 | Richmond City, Virginia, US | |
2022-10-30 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-10-31 04:21:36 | Floyd, Georgia, US | |
2022-10-29 | US | Virginia | Richmond City | 51760 | 58309 | 546 | 0 | 37.53255773 | -77.47966921 | 2022-10-30 04:22:14 | Richmond City, Virginia, US | |
2022-10-29 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-10-30 04:22:14 | Floyd, Georgia, US | |
2022-10-28 | US | Virginia | Richmond City | 51760 | 58309 | 546 | 0 | 37.53255773 | -77.47966921 | 2022-10-29 04:21:13 | Richmond City, Virginia, US | |
2022-10-28 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-10-29 04:21:13 | Floyd, Georgia, US | |
2022-10-27 | US | Virginia | Richmond City | 51760 | 58264 | 546 | 0 | 37.53255773 | -77.47966921 | 2022-10-28 04:22:31 | Richmond City, Virginia, US | |
2022-10-27 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-10-28 04:22:31 | Floyd, Georgia, US | |
2022-10-26 | US | Virginia | Richmond City | 51760 | 58178 | 546 | 0 | 37.53255773 | -77.47966921 | 2022-10-27 04:22:01 | Richmond City, Virginia, US | |
2022-10-26 | US | Illinois | Peoria | 17143 | 56007 | 546 | 0 | 40.78702156 | -89.76078901 | 2022-10-27 04:22:01 | Peoria, Illinois, US | |
2022-10-26 | US | Georgia | Floyd | 13115 | 30827 | 546 | 0 | 34.26268279 | -85.21577392 | 2022-10-27 04:22:01 | Floyd, Georgia, US | |
2022-10-25 | US | Virginia | Richmond City | 51760 | 58116 | 546 | 0 | 37.53255773 | -77.47966921 | 2022-10-26 04:22:19 | Richmond City, Virginia, US | |
2022-10-25 | US | Illinois | Peoria | 17143 | 55966 | 546 | 0 | 40.78702156 | -89.76078901 | 2022-10-26 04:22:19 | Peoria, Illinois, US | |
2022-10-21 | Japan | Mie | 263803 | 546 | 0 | 34.508018 | 136.376013 | 2022-10-22 04:22:53 | Mie, Japan | |||
2022-10-20 | Japan | Mie | 263330 | 546 | 0 | 34.508018 | 136.376013 | 2022-10-21 04:22:23 | Mie, Japan | |||
2022-10-19 | US | Arkansas | Garland | 5051 | 26057 | 546 | 0 | 34.57692074 | -93.14921604 | 2022-10-20 04:22:59 | Garland, Arkansas, US | |
2022-10-19 | Japan | Mie | 262808 | 546 | 0 | 34.508018 | 136.376013 | 2022-10-20 04:22:59 | Mie, Japan | |||
2022-10-18 | US | Arkansas | Garland | 5051 | 26053 | 546 | 0 | 34.57692074 | -93.14921604 | 2022-10-19 04:22:26 | Garland, Arkansas, US | |
2022-10-18 | Japan | Nara | 226268 | 546 | 0 | 34.317451 | 135.871644 | 2022-10-19 04:22:26 | Nara, Japan | |||
2022-10-18 | Japan | Mie | 262057 | 546 | 0 | 34.508018 | 136.376013 | 2022-10-19 04:22:26 | Mie, Japan | |||
2022-10-17 | US | Arkansas | Garland | 5051 | 26047 | 546 | 0 | 34.57692074 | -93.14921604 | 2022-10-18 04:22:42 | Garland, Arkansas, US | |
2022-10-17 | Japan | Nara | 225918 | 546 | 0 | 34.317451 | 135.871644 | 2022-10-18 04:22:42 | Nara, Japan | |||
2022-10-16 | US | Arkansas | Garland | 5051 | 26047 | 546 | 0 | 34.57692074 | -93.14921604 | 2022-10-17 04:20:31 | Garland, Arkansas, US | |
2022-10-16 | Japan | Nara | 225824 | 546 | 0 | 34.317451 | 135.871644 | 2022-10-17 04:20:31 | Nara, Japan | |||
2022-10-15 | US | Arkansas | Garland | 5051 | 26044 | 546 | 0 | 34.57692074 | -93.14921604 | 2022-10-16 04:22:39 | Garland, Arkansas, US | |
2022-10-15 | Japan | Nara | 225432 | 546 | 0 | 34.317451 | 135.871644 | 2022-10-16 04:22:39 | Nara, Japan | |||
2022-10-14 | US | Arkansas | Garland | 5051 | 26028 | 546 | 0 | 34.57692074 | -93.14921604 | 2022-10-15 04:22:00 | Garland, Arkansas, US | |
2022-10-05 | Japan | Kagoshima | 301029 | 546 | 0 | 31.009484 | 130.430665 | 2022-10-06 04:21:22 | Kagoshima, Japan | |||
2022-09-14 | US | Colorado | Larimer | 8069 | 99489 | 546 | 0 | 40.66671597 | -105.4625784 | 2022-09-15 04:21:02 | Larimer, Colorado, US | |
2022-09-13 | US | Colorado | Larimer | 8069 | 99410 | 546 | 0 | 40.66671597 | -105.4625784 | 2022-09-14 04:20:44 | Larimer, Colorado, US | |
2022-09-12 | US | New York | Broome | 36007 | 53423 | 546 | 0 | 42.15903158 | -75.81326086 | 2022-09-13 04:20:57 | Broome, New York, US | |
2022-09-06 | Barbados | 101624 | 546 | 0 | 13.1939 | -59.5432 | 2022-09-07 04:20:59 | Barbados | ||||
2022-08-24 | US | Maryland | Frederick | 24021 | 52807 | 546 | 0 | 39.47296601 | -77.39999394 | 2022-08-25 04:21:13 | Frederick, Maryland, US | |
2022-08-24 | US | Arkansas | Sebastian | 5131 | 36387 | 546 | 0 | 35.19605503 | -94.27162713 | 2022-08-25 04:21:13 | Sebastian, Arkansas, US | |
2022-08-23 | US | Maryland | Frederick | 24021 | 52763 | 546 | 0 | 39.47296601 | -77.39999394 | 2022-08-24 04:20:46 | Frederick, Maryland, US | |
2022-08-10 | US | Wisconsin | Dane | 55025 | 158007 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-11 04:20:49 | Dane, Wisconsin, US | |
2022-08-09 | US | Wisconsin | Dane | 55025 | 157828 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-10 04:20:57 | Dane, Wisconsin, US | |
2022-08-08 | US | Wisconsin | Dane | 55025 | 157678 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-09 04:20:34 | Dane, Wisconsin, US | |
2022-08-08 | Italy | Valle d'Aosta | 42536 | 546 | 0 | 45.73750286 | 7.320149366 | 2022-08-09 04:20:34 | Valle d'Aosta, Italy | |||
2022-08-07 | US | Wisconsin | Dane | 55025 | 157137 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-08 04:21:08 | Dane, Wisconsin, US | |
2022-08-07 | Italy | Valle d'Aosta | 42514 | 546 | 0 | 45.73750286 | 7.320149366 | 2022-08-08 04:21:08 | Valle d'Aosta, Italy | |||
2022-08-06 | US | Wisconsin | Dane | 55025 | 157137 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-07 04:20:54 | Dane, Wisconsin, US | |
2022-08-06 | Italy | Valle d'Aosta | 42446 | 546 | 0 | 45.73750286 | 7.320149366 | 2022-08-07 04:20:54 | Valle d'Aosta, Italy | |||
2022-08-05 | US | Wisconsin | Dane | 55025 | 157137 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-06 04:20:56 | Dane, Wisconsin, US | |
2022-08-04 | US | Wisconsin | Dane | 55025 | 156880 | 546 | 0 | 43.06601594 | -89.41733797 | 2022-08-05 04:20:52 | Dane, Wisconsin, US | |
2022-07-27 | US | New York | Albany | 36001 | 69040 | 546 | 0 | 42.60060306 | -73.97723916 | 2022-07-28 04:20:56 | Albany, New York, US | |
2022-07-12 | US | Alaska | Anchorage | 2020 | 113277 | 546 | 0 | 61.14998174 | -149.1426986 | 2022-07-13 04:20:58 | Anchorage, Alaska, US | |
2022-07-11 | US | Alaska | Anchorage | 2020 | 113277 | 546 | 0 | 61.14998174 | -149.1426986 | 2022-07-12 04:20:51 | Anchorage, Alaska, US | |
2022-07-10 | US | Alaska | Anchorage | 2020 | 113277 | 546 | 0 | 61.14998174 | -149.1426986 | 2022-07-11 04:20:46 | Anchorage, Alaska, US | |
2022-07-09 | US | Alaska | Anchorage | 2020 | 113277 | 546 | 0 | 61.14998174 | -149.1426986 | 2022-07-10 04:20:54 | Anchorage, Alaska, US | |
2022-07-08 | US | Alaska | Anchorage | 2020 | 113277 | 546 | 0 | 61.14998174 | -149.1426986 | 2022-07-09 04:20:59 | Anchorage, Alaska, US | |
2022-07-08 | Australia | South Australia | 618429 | 546 | 0 | -34.9285 | 138.6007 | 2022-07-09 04:20:59 | South Australia, Australia | |||
2022-07-07 | US | Alaska | Anchorage | 2020 | 113277 | 546 | 0 | 61.14998174 | -149.1426986 | 2022-07-08 04:20:56 | Anchorage, Alaska, US | |
2022-07-07 | Australia | South Australia | 618429 | 546 | 0 | -34.9285 | 138.6007 | 2022-07-08 04:20:56 | South Australia, Australia | |||
2022-07-06 | US | Minnesota | St. Louis | 27137 | 51870 | 546 | 0 | 47.6048407 | -92.46879855 | 2022-07-07 04:20:55 | St. Louis, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;