daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
357 rows where deaths = 827 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-09 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-10 04:21:16 | Tuscaloosa, Alabama, US | |
2022-11-08 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-09 04:21:22 | Tuscaloosa, Alabama, US | |
2022-11-07 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-08 04:21:21 | Tuscaloosa, Alabama, US | |
2022-11-06 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-07 04:21:26 | Tuscaloosa, Alabama, US | |
2022-11-05 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-06 04:21:24 | Tuscaloosa, Alabama, US | |
2022-11-04 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-05 04:21:52 | Tuscaloosa, Alabama, US | |
2022-11-03 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-04 04:22:11 | Tuscaloosa, Alabama, US | |
2022-11-02 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-03 04:22:05 | Tuscaloosa, Alabama, US | |
2022-11-02 | Cote d'Ivoire | 87781 | 827 | 0 | 7.54 | -5.5471 | 2022-11-03 04:22:05 | Cote d'Ivoire | ||||
2022-11-01 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-02 04:22:09 | Tuscaloosa, Alabama, US | |
2022-11-01 | Cote d'Ivoire | 87781 | 827 | 0 | 7.54 | -5.5471 | 2022-11-02 04:22:09 | Cote d'Ivoire | ||||
2022-10-31 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-11-01 04:22:36 | Tuscaloosa, Alabama, US | |
2022-10-31 | Cote d'Ivoire | 87774 | 827 | 0 | 7.54 | -5.5471 | 2022-11-01 04:22:36 | Cote d'Ivoire | ||||
2022-10-30 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-31 04:21:36 | Tuscaloosa, Alabama, US | |
2022-10-30 | Cote d'Ivoire | 87773 | 827 | 0 | 7.54 | -5.5471 | 2022-10-31 04:21:36 | Cote d'Ivoire | ||||
2022-10-29 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-30 04:22:14 | Tuscaloosa, Alabama, US | |
2022-10-29 | Cote d'Ivoire | 87753 | 827 | 0 | 7.54 | -5.5471 | 2022-10-30 04:22:14 | Cote d'Ivoire | ||||
2022-10-28 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-29 04:21:13 | Tuscaloosa, Alabama, US | |
2022-10-28 | Cote d'Ivoire | 87753 | 827 | 0 | 7.54 | -5.5471 | 2022-10-29 04:21:13 | Cote d'Ivoire | ||||
2022-10-27 | US | Alabama | Tuscaloosa | 1125 | 66232 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-28 04:22:31 | Tuscaloosa, Alabama, US | |
2022-10-27 | Cote d'Ivoire | 87731 | 827 | 0 | 7.54 | -5.5471 | 2022-10-28 04:22:31 | Cote d'Ivoire | ||||
2022-10-26 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-27 04:22:01 | Tuscaloosa, Alabama, US | |
2022-10-26 | Cote d'Ivoire | 87720 | 827 | 0 | 7.54 | -5.5471 | 2022-10-27 04:22:01 | Cote d'Ivoire | ||||
2022-10-25 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-26 04:22:19 | Tuscaloosa, Alabama, US | |
2022-10-25 | Cote d'Ivoire | 87720 | 827 | 0 | 7.54 | -5.5471 | 2022-10-26 04:22:19 | Cote d'Ivoire | ||||
2022-10-24 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-25 04:21:53 | Tuscaloosa, Alabama, US | |
2022-10-24 | Cote d'Ivoire | 87700 | 827 | 0 | 7.54 | -5.5471 | 2022-10-25 04:21:53 | Cote d'Ivoire | ||||
2022-10-23 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-24 04:22:29 | Tuscaloosa, Alabama, US | |
2022-10-23 | Cote d'Ivoire | 87700 | 827 | 0 | 7.54 | -5.5471 | 2022-10-24 04:22:29 | Cote d'Ivoire | ||||
2022-10-22 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-23 04:22:46 | Tuscaloosa, Alabama, US | |
2022-10-22 | Cote d'Ivoire | 87693 | 827 | 0 | 7.54 | -5.5471 | 2022-10-23 04:22:46 | Cote d'Ivoire | ||||
2022-10-21 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-22 04:22:53 | Tuscaloosa, Alabama, US | |
2022-10-21 | Cote d'Ivoire | 87691 | 827 | 0 | 7.54 | -5.5471 | 2022-10-22 04:22:53 | Cote d'Ivoire | ||||
2022-10-20 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-21 04:22:23 | Hinds, Mississippi, US | |
2022-10-20 | US | Alabama | Tuscaloosa | 1125 | 66125 | 827 | 0 | 33.28726072 | -87.52556818 | 2022-10-21 04:22:23 | Tuscaloosa, Alabama, US | |
2022-10-20 | Cote d'Ivoire | 87676 | 827 | 0 | 7.54 | -5.5471 | 2022-10-21 04:22:23 | Cote d'Ivoire | ||||
2022-10-19 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-20 04:22:59 | Hinds, Mississippi, US | |
2022-10-19 | Cote d'Ivoire | 87657 | 827 | 0 | 7.54 | -5.5471 | 2022-10-20 04:22:59 | Cote d'Ivoire | ||||
2022-10-18 | US | Virginia | Chesterfield | 51041 | 91913 | 827 | 0 | 37.37373208 | -77.5868014 | 2022-10-19 04:22:26 | Chesterfield, Virginia, US | |
2022-10-18 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-19 04:22:26 | Hinds, Mississippi, US | |
2022-10-18 | Cote d'Ivoire | 87602 | 827 | 0 | 7.54 | -5.5471 | 2022-10-19 04:22:26 | Cote d'Ivoire | ||||
2022-10-17 | US | Virginia | Chesterfield | 51041 | 91858 | 827 | 0 | 37.37373208 | -77.5868014 | 2022-10-18 04:22:42 | Chesterfield, Virginia, US | |
2022-10-17 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-18 04:22:42 | Hinds, Mississippi, US | |
2022-10-17 | Cote d'Ivoire | 87602 | 827 | 0 | 7.54 | -5.5471 | 2022-10-18 04:22:42 | Cote d'Ivoire | ||||
2022-10-16 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-17 04:20:31 | Hinds, Mississippi, US | |
2022-10-16 | Cote d'Ivoire | 87598 | 827 | 0 | 7.54 | -5.5471 | 2022-10-17 04:20:31 | Cote d'Ivoire | ||||
2022-10-15 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-16 04:22:39 | Hinds, Mississippi, US | |
2022-10-15 | Cote d'Ivoire | 87535 | 827 | 0 | 7.54 | -5.5471 | 2022-10-16 04:22:39 | Cote d'Ivoire | ||||
2022-10-14 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-15 04:22:00 | Hinds, Mississippi, US | |
2022-10-13 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-14 04:22:28 | Hinds, Mississippi, US | |
2022-10-12 | US | Mississippi | Hinds | 28049 | 63453 | 827 | 0 | 32.2656285 | -90.44435448 | 2022-10-13 04:22:39 | Hinds, Mississippi, US | |
2022-09-08 | US | New York | Oneida | 36065 | 63085 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-09 04:21:11 | Oneida, New York, US | |
2022-09-07 | US | New York | Oneida | 36065 | 63017 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-08 04:21:02 | Oneida, New York, US | |
2022-09-06 | US | New York | Oneida | 36065 | 62970 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-07 04:20:59 | Oneida, New York, US | |
2022-09-05 | US | New York | Oneida | 36065 | 62938 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-06 04:21:02 | Oneida, New York, US | |
2022-09-04 | US | New York | Oneida | 36065 | 62901 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-05 04:21:01 | Oneida, New York, US | |
2022-09-03 | US | New York | Oneida | 36065 | 62865 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-04 04:21:22 | Oneida, New York, US | |
2022-09-02 | US | New York | Oneida | 36065 | 62824 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-03 04:21:04 | Oneida, New York, US | |
2022-09-01 | US | Washington | Yakima | 53077 | 79642 | 827 | 0 | 46.45738486 | -120.7380126 | 2022-09-02 04:21:07 | Yakima, Washington, US | |
2022-09-01 | US | New York | Oneida | 36065 | 62779 | 827 | 0 | 43.24375382 | -75.43710392 | 2022-09-02 04:21:07 | Oneida, New York, US | |
2022-08-31 | US | Washington | Yakima | 53077 | 79642 | 827 | 0 | 46.45738486 | -120.7380126 | 2022-09-01 04:21:03 | Yakima, Washington, US | |
2022-08-10 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-11 04:20:49 | Utah, Utah, US | |
2022-08-09 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-10 04:20:57 | Utah, Utah, US | |
2022-08-08 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-09 04:20:34 | Utah, Utah, US | |
2022-08-07 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-08 04:21:08 | Utah, Utah, US | |
2022-08-06 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-07 04:20:54 | Utah, Utah, US | |
2022-08-05 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-06 04:20:56 | Utah, Utah, US | |
2022-08-04 | US | Utah | Utah | 49049 | 215269 | 827 | 0 | 40.1166722 | -111.6657662 | 2022-08-05 04:20:52 | Utah, Utah, US | |
2022-06-23 | US | California | Merced | 6047 | 75148 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-24 04:20:58 | Merced, California, US | |
2022-06-22 | US | California | Merced | 6047 | 74836 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-23 04:20:55 | Merced, California, US | |
2022-06-22 | Russia | Sakhalin Oblast | 64967 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-23 04:20:55 | Sakhalin Oblast, Russia | |||
2022-06-21 | US | California | Merced | 6047 | 74804 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-22 04:20:54 | Merced, California, US | |
2022-06-21 | Russia | Sakhalin Oblast | 64962 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-22 04:20:54 | Sakhalin Oblast, Russia | |||
2022-06-20 | US | California | Merced | 6047 | 74778 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-21 04:20:56 | Merced, California, US | |
2022-06-20 | Russia | Sakhalin Oblast | 64961 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-21 04:20:56 | Sakhalin Oblast, Russia | |||
2022-06-19 | US | California | Merced | 6047 | 74362 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-20 04:21:01 | Merced, California, US | |
2022-06-19 | Russia | Sakhalin Oblast | 64958 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-20 04:21:01 | Sakhalin Oblast, Russia | |||
2022-06-18 | US | California | Merced | 6047 | 74352 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-19 04:20:51 | Merced, California, US | |
2022-06-18 | Russia | Sakhalin Oblast | 64947 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-19 04:20:51 | Sakhalin Oblast, Russia | |||
2022-06-17 | US | California | Merced | 6047 | 74348 | 827 | 0 | 37.18922369 | -120.7209035 | 2022-06-18 04:21:10 | Merced, California, US | |
2022-06-17 | Russia | Sakhalin Oblast | 64935 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-18 04:21:10 | Sakhalin Oblast, Russia | |||
2022-06-16 | Russia | Sakhalin Oblast | 64929 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-17 04:20:56 | Sakhalin Oblast, Russia | |||
2022-06-15 | Russia | Sakhalin Oblast | 64924 | 827 | 0 | 49.7219665 | 143.448533 | 2022-06-16 04:20:55 | Sakhalin Oblast, Russia | |||
2022-06-02 | US | Virginia | Virginia Beach | 51810 | 94296 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-06-03 04:20:58 | Virginia Beach, Virginia, US | |
2022-06-01 | US | Virginia | Virginia Beach | 51810 | 94148 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-06-02 05:20:39 | Virginia Beach, Virginia, US | |
2022-05-31 | US | Virginia | Virginia Beach | 51810 | 93999 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-06-01 04:20:55 | Virginia Beach, Virginia, US | |
2022-05-31 | US | Illinois | Winnebago | 17201 | 81468 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-06-01 04:20:55 | Winnebago, Illinois, US | |
2022-05-30 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-31 04:20:51 | Virginia Beach, Virginia, US | |
2022-05-30 | US | Nebraska | Unassigned | 90031 | 7920 | 827 | 0 | 42.8997274 | 0.0 | 2022-05-31 04:20:51 | Unassigned, Nebraska, US | |
2022-05-30 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-31 04:20:51 | Winnebago, Illinois, US | |
2022-05-29 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-30 04:20:50 | Virginia Beach, Virginia, US | |
2022-05-29 | US | Nebraska | Unassigned | 90031 | 7920 | 827 | 0 | 42.8997274 | 0.0 | 2022-05-30 04:20:50 | Unassigned, Nebraska, US | |
2022-05-29 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-30 04:20:50 | Winnebago, Illinois, US | |
2022-05-28 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-29 04:20:53 | Virginia Beach, Virginia, US | |
2022-05-28 | US | Nebraska | Unassigned | 90031 | 7998 | 827 | 0 | 42.8997274 | 0.0 | 2022-05-29 04:20:53 | Unassigned, Nebraska, US | |
2022-05-28 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-29 04:20:53 | Winnebago, Illinois, US | |
2022-05-27 | US | Virginia | Virginia Beach | 51810 | 93508 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-28 04:21:07 | Virginia Beach, Virginia, US | |
2022-05-27 | US | Illinois | Winnebago | 17201 | 81025 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-28 04:21:07 | Winnebago, Illinois, US | |
2022-05-26 | US | Virginia | Virginia Beach | 51810 | 93356 | 827 | 0 | 36.73285734 | -76.04566934 | 2022-05-27 04:20:56 | Virginia Beach, Virginia, US | |
2022-05-26 | US | Illinois | Winnebago | 17201 | 80876 | 827 | 0 | 42.33641854 | -89.16085327 | 2022-05-27 04:20:56 | Winnebago, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;