daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
146 rows where confirmed = 5245 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-30 04:21:04 | Washington, Nebraska, US | |
2022-12-28 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-29 04:21:01 | Washington, Nebraska, US | |
2022-12-27 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-28 04:21:04 | Washington, Nebraska, US | |
2022-12-26 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-27 04:21:07 | Washington, Nebraska, US | |
2022-12-25 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-26 04:21:06 | Washington, Nebraska, US | |
2022-12-24 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-25 04:21:04 | Washington, Nebraska, US | |
2022-12-23 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-24 04:21:02 | Washington, Nebraska, US | |
2022-12-22 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-23 04:21:04 | Washington, Nebraska, US | |
2022-12-21 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-22 04:20:56 | Washington, Nebraska, US | |
2022-12-20 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-21 04:21:03 | Washington, Nebraska, US | |
2022-12-19 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-20 04:21:04 | Washington, Nebraska, US | |
2022-12-18 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-19 04:21:03 | Washington, Nebraska, US | |
2022-12-17 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-18 04:21:03 | Washington, Nebraska, US | |
2022-12-16 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-17 04:21:04 | Washington, Nebraska, US | |
2022-12-15 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-16 04:21:01 | Washington, Nebraska, US | |
2022-12-14 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-15 04:20:58 | Washington, Nebraska, US | |
2022-12-13 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-14 04:21:04 | Washington, Nebraska, US | |
2022-12-12 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-13 04:21:01 | Washington, Nebraska, US | |
2022-12-11 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-12 04:21:01 | Washington, Nebraska, US | |
2022-12-10 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-11 04:20:50 | Washington, Nebraska, US | |
2022-12-09 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-10 04:21:02 | Washington, Nebraska, US | |
2022-12-08 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-09 04:21:05 | Washington, Nebraska, US | |
2022-12-07 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-08 04:21:07 | Washington, Nebraska, US | |
2022-12-06 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-07 04:20:58 | Washington, Nebraska, US | |
2022-12-05 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-06 04:21:03 | Washington, Nebraska, US | |
2022-12-04 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-05 04:20:58 | Washington, Nebraska, US | |
2022-12-03 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-04 04:20:56 | Washington, Nebraska, US | |
2022-12-02 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-03 04:21:02 | Washington, Nebraska, US | |
2022-12-01 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-02 04:21:07 | Washington, Nebraska, US | |
2022-11-30 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-12-01 04:21:03 | Washington, Nebraska, US | |
2022-11-29 | US | Virginia | Grayson | 51077 | 5245 | 88 | 0 | 36.65677234 | -81.23215889 | 2022-11-30 04:21:07 | Grayson, Virginia, US | |
2022-11-29 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-11-30 04:21:07 | Washington, Nebraska, US | |
2022-11-28 | US | Nebraska | Washington | 31177 | 5245 | 53 | 0 | 41.52815707 | -96.22019892 | 2022-11-29 04:21:05 | Washington, Nebraska, US | |
2022-11-05 | US | Puerto Rico | Guayanilla | 72059 | 5245 | 0 | 0 | 18.039942 | -66.79186 | 2022-11-06 04:21:24 | Guayanilla, Puerto Rico, US | |
2022-10-17 | US | Tennessee | Benton | 47005 | 5245 | 100 | 0 | 36.07110411 | -88.06849355 | 2022-10-18 04:22:42 | Benton, Tennessee, US | |
2022-10-16 | US | Tennessee | Benton | 47005 | 5245 | 100 | 0 | 36.07110411 | -88.06849355 | 2022-10-17 04:20:31 | Benton, Tennessee, US | |
2022-10-15 | US | Tennessee | Benton | 47005 | 5245 | 100 | 0 | 36.07110411 | -88.06849355 | 2022-10-16 04:22:39 | Benton, Tennessee, US | |
2022-10-14 | US | Tennessee | Benton | 47005 | 5245 | 100 | 0 | 36.07110411 | -88.06849355 | 2022-10-15 04:22:00 | Benton, Tennessee, US | |
2022-10-09 | US | Texas | Reeves | 48389 | 5245 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-10-10 04:22:32 | Reeves, Texas, US | |
2022-10-08 | US | Texas | Reeves | 48389 | 5245 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-10-09 04:21:16 | Reeves, Texas, US | |
2022-10-07 | US | Texas | Reeves | 48389 | 5245 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-10-08 04:22:56 | Reeves, Texas, US | |
2022-09-20 | US | Illinois | Cass | 17017 | 5245 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-09-21 04:23:22 | Cass, Illinois, US | |
2022-09-13 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-14 04:20:44 | Hart, Georgia, US | |
2022-09-12 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-13 04:20:57 | Hart, Georgia, US | |
2022-09-11 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-12 04:20:58 | Hart, Georgia, US | |
2022-09-10 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-11 04:20:50 | Hart, Georgia, US | |
2022-09-09 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-10 04:21:10 | Hart, Georgia, US | |
2022-09-08 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-09 04:21:11 | Hart, Georgia, US | |
2022-09-07 | US | Georgia | Hart | 13147 | 5245 | 107 | 0 | 34.34626973 | -82.96567682 | 2022-09-08 04:21:02 | Hart, Georgia, US | |
2022-08-16 | US | Wisconsin | Taylor | 55119 | 5245 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-08-17 04:20:59 | Taylor, Wisconsin, US | |
2022-08-10 | US | Colorado | Alamosa | 8003 | 5245 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-08-11 04:20:49 | Alamosa, Colorado, US | |
2022-08-09 | US | Arkansas | Phillips | 5107 | 5245 | 100 | 0 | 34.43268455 | -90.84800154 | 2022-08-10 04:20:57 | Phillips, Arkansas, US | |
2022-08-08 | US | Arkansas | Cross | 5037 | 5245 | 88 | 0 | 35.29631396 | -90.77185818 | 2022-08-09 04:20:34 | Cross, Arkansas, US | |
2022-08-06 | US | California | Inyo | 6027 | 5245 | 57 | 0 | 36.51112084 | -117.4111978 | 2022-08-07 04:20:54 | Inyo, California, US | |
2022-08-05 | US | California | Inyo | 6027 | 5245 | 57 | 0 | 36.51112084 | -117.4111978 | 2022-08-06 04:20:56 | Inyo, California, US | |
2022-07-14 | US | New Mexico | Roosevelt | 35041 | 5245 | 98 | 0 | 34.02097406 | -103.4799493 | 2022-07-15 04:20:53 | Roosevelt, New Mexico, US | |
2022-07-13 | US | Texas | Burleson | 48051 | 5245 | 67 | 0 | 30.49273808 | -96.62158484 | 2022-07-14 04:20:57 | Burleson, Texas, US | |
2022-07-04 | US | Arkansas | Logan | 5083 | 5245 | 79 | 0 | 35.21413234 | -93.71951016 | 2022-07-05 04:20:45 | Logan, Arkansas, US | |
2022-06-08 | US | Puerto Rico | Aguas Buenas | 72007 | 5245 | 0 | 0 | 18.251619 | -66.126806 | 2022-06-09 04:20:54 | Aguas Buenas, Puerto Rico, US | |
2022-05-30 | US | Tennessee | Unicoi | 47171 | 5245 | 97 | 0 | 36.10890856 | -82.43709629 | 2022-05-31 04:20:51 | Unicoi, Tennessee, US | |
2022-05-10 | US | Virginia | Powhatan | 51145 | 5245 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-11 04:20:48 | Powhatan, Virginia, US | |
2022-05-10 | US | Maryland | Somerset | 24039 | 5245 | 74 | 0 | 38.1163542 | -75.75118623 | 2022-05-11 04:20:48 | Somerset, Maryland, US | |
2022-03-08 | US | Ohio | Carroll | 39019 | 5245 | 126 | 0 | 40.578968599999996 | -81.09178213 | 2022-03-09 04:20:59 | Carroll, Ohio, US | |
2022-03-07 | US | Ohio | Carroll | 39019 | 5245 | 126 | 0 | 40.578968599999996 | -81.09178213 | 2022-03-08 04:20:54 | Carroll, Ohio, US | |
2022-03-01 | US | Kentucky | Spencer | 21215 | 5245 | 50 | 0 | 38.03223971 | -85.32749335 | 2022-03-02 04:21:07 | Spencer, Kentucky, US | |
2022-02-28 | US | Indiana | Sullivan | 18153 | 5245 | 70 | 0 | 39.08952258 | -87.41414469 | 2022-03-01 04:21:09 | Sullivan, Indiana, US | |
2022-02-25 | US | Arkansas | Columbia | 5027 | 5245 | 83 | 0 | 33.21230701 | -93.22642793 | 2022-02-26 04:21:12 | Columbia, Arkansas, US | |
2022-02-16 | US | Puerto Rico | Cayey | 72035 | 5245 | 0 | 0 | 18.102851 | -66.14914 | 2022-02-17 04:20:56 | Cayey, Puerto Rico, US | |
2022-02-10 | US | Indiana | Fountain | 18045 | 5245 | 89 | 0 | 40.12361933 | -87.24217689 | 2022-02-11 04:21:09 | Fountain, Indiana, US | |
2022-02-05 | US | Puerto Rico | San Sebastian | 72131 | 5245 | 0 | 0 | 18.328646 | -66.971214 | 2022-02-06 04:21:00 | San Sebastian, Puerto Rico, US | |
2021-12-30 | US | Georgia | Lumpkin | 13187 | 5245 | 111 | 0 | 34.57286511 | -84.00425681 | 2021-12-31 04:21:50 | Lumpkin, Georgia, US | |
2021-12-18 | US | Kentucky | Carter | 21043 | 5245 | 73 | 0 | 38.31690743 | -83.05092385 | 2021-12-19 04:21:11 | Carter, Kentucky, US | |
2021-12-10 | US | Texas | Fannin | 48147 | 5245 | 154 | 0 | 33.59564294 | -96.10751083 | 2021-12-11 04:22:45 | Fannin, Texas, US | |
2021-12-01 | US | Texas | Howard | 48227 | 5245 | 143 | 0 | 32.30621324 | -101.4356444 | 2021-12-02 04:22:37 | Howard, Texas, US | |
2021-11-22 | US | Virginia | Prince George | 51149 | 5245 | 51 | 0 | 37.18497668 | -77.22922187 | 2021-11-23 04:22:39 | Prince George, Virginia, US | |
2021-11-22 | US | Indiana | Adams | 18001 | 5245 | 81 | 0 | 40.7457653 | -84.93671406 | 2021-11-23 04:22:39 | Adams, Indiana, US | |
2021-11-21 | US | North Carolina | Person | 37145 | 5245 | 88 | 0 | 36.38989032 | -78.97217358 | 2021-11-22 04:22:20 | Person, North Carolina, US | |
2021-11-20 | US | North Carolina | Person | 37145 | 5245 | 88 | 0 | 36.38989032 | -78.97217358 | 2021-11-21 04:22:13 | Person, North Carolina, US | |
2021-11-19 | US | North Carolina | Person | 37145 | 5245 | 88 | 0 | 36.38989032 | -78.97217358 | 2021-11-20 04:22:17 | Person, North Carolina, US | |
2021-11-18 | US | Missouri | Warren | 29219 | 5245 | 51 | 0 | 38.76529479 | -91.16124662 | 2021-11-19 04:21:40 | Warren, Missouri, US | |
2021-11-16 | US | Tennessee | Lauderdale | 47097 | 5245 | 69 | 0 | 35.75893438 | -89.63015909999999 | 2021-11-17 04:21:48 | Lauderdale, Tennessee, US | |
2021-11-15 | US | Ohio | Coshocton | 39031 | 5245 | 107 | 0 | 40.30096166 | -81.91729018 | 2021-11-16 04:21:10 | Coshocton, Ohio, US | |
2021-11-08 | US | Alabama | Dallas | 1047 | 5245 | 207 | 0 | 32.32688101 | -87.10866709999998 | 2021-11-09 04:21:36 | Dallas, Alabama, US | |
2021-11-01 | US | Ohio | Jackson | 39079 | 5245 | 93 | 0 | 39.01914254 | -82.61818559999998 | 2021-11-02 04:22:03 | Jackson, Ohio, US | |
2021-10-29 | US | Ohio | Perry | 39127 | 5245 | 80 | 0 | 39.73508655 | -82.23804971 | 2021-10-30 04:22:03 | Perry, Ohio, US | |
2021-10-26 | US | Tennessee | Scott | 47151 | 5245 | 60 | 0 | 36.42325673 | -84.50360494 | 2021-10-27 04:22:32 | Scott, Tennessee, US | |
2021-10-19 | US | Missouri | Laclede | 29105 | 5245 | 127 | 0 | 37.65896829 | -92.5888493 | 2021-10-20 04:21:00 | Laclede, Missouri, US | |
2021-10-19 | US | Illinois | Monroe | 17133 | 5245 | 103 | 0 | 38.27594376 | -90.17761038 | 2021-10-20 04:21:00 | Monroe, Illinois, US | |
2021-10-14 | US | Indiana | Wabash | 18169 | 5245 | 101 | 0 | 40.84704239 | -85.79328272 | 2021-10-15 04:21:26 | Wabash, Indiana, US | |
2021-10-13 | US | Oregon | Benton | 41003 | 5245 | 30 | 0 | 44.49167306 | -123.4316987 | 2021-10-14 04:21:29 | Benton, Oregon, US | |
2021-10-13 | US | New York | Warren | 36113 | 5245 | 81 | 0 | 43.56173026 | -73.8433699 | 2021-10-14 04:21:29 | Warren, New York, US | |
2021-09-15 | US | Wisconsin | Marinette | 55075 | 5245 | 77 | 0 | 45.38553432 | -88.03324599999998 | 2021-09-16 04:22:19 | Marinette, Wisconsin, US | |
2021-09-14 | US | New York | Madison | 36053 | 5245 | 94 | 0 | 42.91653905 | -75.67266639 | 2021-09-15 03:22:37 | Madison, New York, US | |
2021-09-09 | US | Mississippi | Pike | 28113 | 5245 | 128 | 0 | 31.17507789 | -90.40392572 | 2021-09-10 04:21:20 | Pike, Mississippi, US | |
2021-09-05 | US | Tennessee | Campbell | 47013 | 5245 | 66 | 0 | 36.40355516 | -84.15108559999999 | 2021-09-06 04:21:22 | Campbell, Tennessee, US | |
2021-08-28 | US | Arkansas | Independence | 5063 | 5245 | 141 | 0 | 35.74242707 | -91.57001641 | 2021-08-29 04:21:14 | Independence, Arkansas, US | |
2021-08-25 | US | North Carolina | Beaufort | 37013 | 5245 | 105 | 0 | 35.48531943 | -76.84325809 | 2021-08-26 04:21:28 | Beaufort, North Carolina, US | |
2021-08-12 | US | Illinois | Henry | 17073 | 5245 | 70 | 0 | 41.3533994 | -90.13296166 | 2021-08-13 04:21:24 | Henry, Illinois, US | |
2021-08-05 | US | Kentucky | Hopkins | 21107 | 5245 | 154 | 0 | 37.30939025 | -87.54670406 | 2021-08-06 04:21:18 | Hopkins, Kentucky, US | |
2021-08-04 | US | Louisiana | Lincoln | 22061 | 5245 | 96 | 0 | 32.6003154 | -92.6659741 | 2021-08-05 04:21:51 | Lincoln, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;