daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where confirmed = 5729 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-28 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-29 04:21:01 | Holmes, Ohio, US | |
2022-12-27 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-28 04:21:04 | Holmes, Ohio, US | |
2022-12-26 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-27 04:21:07 | Holmes, Ohio, US | |
2022-12-25 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-26 04:21:06 | Holmes, Ohio, US | |
2022-12-24 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-25 04:21:04 | Holmes, Ohio, US | |
2022-12-23 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-24 04:21:02 | Holmes, Ohio, US | |
2022-12-22 | US | Ohio | Holmes | 39075 | 5729 | 191 | 0 | 40.56163713 | -81.92635677 | 2022-12-23 04:21:04 | Holmes, Ohio, US | |
2022-12-14 | US | Colorado | Elbert | 8039 | 5729 | 46 | 0 | 39.28656773 | -104.1358721 | 2022-12-15 04:20:58 | Elbert, Colorado, US | |
2022-12-12 | US | Colorado | Alamosa | 8003 | 5729 | 65 | 0 | 37.57250606 | -105.7885451 | 2022-12-13 04:21:01 | Alamosa, Colorado, US | |
2022-09-22 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-23 04:23:13 | Vernon, Missouri, US | |
2022-09-21 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-22 04:22:56 | Vernon, Missouri, US | |
2022-09-20 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-21 04:23:22 | Vernon, Missouri, US | |
2022-09-19 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-20 04:22:48 | Vernon, Missouri, US | |
2022-09-18 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-19 04:21:49 | Vernon, Missouri, US | |
2022-09-17 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-18 04:22:50 | Vernon, Missouri, US | |
2022-09-16 | US | Missouri | Vernon | 29217 | 5729 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-17 04:20:19 | Vernon, Missouri, US | |
2022-09-15 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-16 04:21:19 | Ray, Missouri, US | |
2022-09-14 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-15 04:21:02 | Ray, Missouri, US | |
2022-09-13 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-14 04:20:44 | Ray, Missouri, US | |
2022-09-12 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-13 04:20:57 | Ray, Missouri, US | |
2022-09-11 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-12 04:20:58 | Ray, Missouri, US | |
2022-09-11 | US | Kentucky | Mason | 21161 | 5729 | 110 | 0 | 38.59471935 | -83.82151043 | 2022-09-12 04:20:58 | Mason, Kentucky, US | |
2022-09-10 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-11 04:20:50 | Ray, Missouri, US | |
2022-09-10 | US | Kentucky | Mason | 21161 | 5729 | 110 | 0 | 38.59471935 | -83.82151043 | 2022-09-11 04:20:50 | Mason, Kentucky, US | |
2022-09-09 | US | Missouri | Ray | 29177 | 5729 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-10 04:21:10 | Ray, Missouri, US | |
2022-09-09 | US | Kentucky | Mason | 21161 | 5729 | 110 | 0 | 38.59471935 | -83.82151043 | 2022-09-10 04:21:10 | Mason, Kentucky, US | |
2022-09-08 | US | Kentucky | Mason | 21161 | 5729 | 110 | 0 | 38.59471935 | -83.82151043 | 2022-09-09 04:21:11 | Mason, Kentucky, US | |
2022-09-07 | US | Kentucky | Mason | 21161 | 5729 | 110 | 0 | 38.59471935 | -83.82151043 | 2022-09-08 04:21:02 | Mason, Kentucky, US | |
2022-09-06 | US | Kentucky | Mason | 21161 | 5729 | 110 | 0 | 38.59471935 | -83.82151043 | 2022-09-07 04:20:59 | Mason, Kentucky, US | |
2022-09-06 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-07 04:20:59 | La Paz, Arizona, US | |
2022-09-05 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-06 04:21:02 | La Paz, Arizona, US | |
2022-09-04 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-05 04:21:01 | La Paz, Arizona, US | |
2022-09-03 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-04 04:21:22 | La Paz, Arizona, US | |
2022-09-02 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-03 04:21:04 | La Paz, Arizona, US | |
2022-09-01 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-02 04:21:07 | La Paz, Arizona, US | |
2022-08-31 | US | Arizona | La Paz | 4012 | 5729 | 149 | 0 | 33.72854224 | -113.9810029 | 2022-09-01 04:21:03 | La Paz, Arizona, US | |
2022-08-14 | US | Wisconsin | Green Lake | 55047 | 5729 | 65 | 0 | 43.80025981 | -89.04679553 | 2022-08-15 04:20:59 | Green Lake, Wisconsin, US | |
2022-08-13 | US | Wisconsin | Green Lake | 55047 | 5729 | 65 | 0 | 43.80025981 | -89.04679553 | 2022-08-14 04:20:55 | Green Lake, Wisconsin, US | |
2022-08-12 | US | Wisconsin | Green Lake | 55047 | 5729 | 65 | 0 | 43.80025981 | -89.04679553 | 2022-08-13 04:20:52 | Green Lake, Wisconsin, US | |
2022-07-29 | US | Arkansas | Lawrence | 5075 | 5729 | 82 | 0 | 36.04188196 | -91.10867198 | 2022-07-30 04:20:42 | Lawrence, Arkansas, US | |
2022-07-06 | US | Virginia | Fluvanna | 51065 | 5729 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-07-07 04:20:55 | Fluvanna, Virginia, US | |
2022-07-05 | US | Puerto Rico | Aibonito | 72009 | 5729 | 0 | 0 | 18.131361 | -66.264131 | 2022-07-06 04:20:58 | Aibonito, Puerto Rico, US | |
2022-07-04 | US | Tennessee | Union | 47173 | 5729 | 78 | 0 | 36.28590426 | -83.83651902 | 2022-07-05 04:20:45 | Union, Tennessee, US | |
2022-07-04 | US | Arkansas | Ouachita | 5103 | 5729 | 109 | 0 | 33.58839816 | -92.87795984 | 2022-07-05 04:20:45 | Ouachita, Arkansas, US | |
2022-06-07 | US | Virginia | Fredericksburg | 51630 | 5729 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-06-08 04:20:55 | Fredericksburg, Virginia, US | |
2022-06-07 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-08 04:20:55 | Gladwin, Michigan, US | |
2022-06-06 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-07 04:21:08 | Gladwin, Michigan, US | |
2022-06-05 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-06 04:20:57 | Gladwin, Michigan, US | |
2022-06-04 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-05 04:20:55 | Gladwin, Michigan, US | |
2022-06-03 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-04 04:20:58 | Gladwin, Michigan, US | |
2022-06-02 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-03 04:20:58 | Gladwin, Michigan, US | |
2022-06-01 | US | Tennessee | Wayne | 47181 | 5729 | 72 | 0 | 35.23868267 | -87.78644456 | 2022-06-02 05:20:39 | Wayne, Tennessee, US | |
2022-06-01 | US | Michigan | Gladwin | 26051 | 5729 | 115 | 0 | 43.98901072 | -84.38774817 | 2022-06-02 05:20:39 | Gladwin, Michigan, US | |
2022-05-31 | Saint Kitts and Nevis | 5729 | 43 | 0 | 17.357822 | -62.782998 | 2022-06-01 04:20:55 | Saint Kitts and Nevis | ||||
2022-05-12 | US | Texas | Calhoun | 48057 | 5729 | 48 | 0 | 28.47048236 | -96.61633945 | 2022-05-13 04:20:51 | Calhoun, Texas, US | |
2022-05-11 | US | Texas | Calhoun | 48057 | 5729 | 48 | 0 | 28.47048236 | -96.61633945 | 2022-05-12 04:20:54 | Calhoun, Texas, US | |
2022-05-01 | US | Tennessee | Fentress | 47049 | 5729 | 128 | 0 | 36.38128818 | -84.92870012 | 2022-05-02 04:21:10 | Fentress, Tennessee, US | |
2022-04-30 | US | Tennessee | Fentress | 47049 | 5729 | 128 | 0 | 36.38128818 | -84.92870012 | 2022-05-01 04:20:57 | Fentress, Tennessee, US | |
2022-04-29 | US | Tennessee | Fentress | 47049 | 5729 | 128 | 0 | 36.38128818 | -84.92870012 | 2022-04-30 04:21:05 | Fentress, Tennessee, US | |
2022-04-28 | US | Vermont | Addison | 50001 | 5729 | 15 | 0 | 44.03217337 | -73.14130877 | 2022-04-29 04:20:59 | Addison, Vermont, US | |
2022-04-27 | US | Maryland | Garrett | 24023 | 5729 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-04-28 04:20:47 | Garrett, Maryland, US | |
2022-04-25 | US | Minnesota | Dodge | 27039 | 5729 | 21 | 0 | 44.02238415 | -92.86244324 | 2022-04-26 04:20:51 | Dodge, Minnesota, US | |
2022-04-18 | US | Virginia | Scott | 51169 | 5729 | 110 | 0 | 36.71466456 | -82.60171704 | 2022-04-19 04:21:00 | Scott, Virginia, US | |
2022-04-18 | US | Puerto Rico | Juana Diaz | 72075 | 5729 | 0 | 0 | 18.050764 | -66.49458100000001 | 2022-04-19 04:21:00 | Juana Diaz, Puerto Rico, US | |
2022-03-22 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-22 23:20:51 | Henry, Missouri, US | |
2022-03-20 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-21 04:20:50 | Henry, Missouri, US | |
2022-03-19 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-20 04:20:45 | Henry, Missouri, US | |
2022-03-18 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-19 04:20:47 | Henry, Missouri, US | |
2022-03-17 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-18 04:20:55 | Henry, Missouri, US | |
2022-03-16 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-17 04:20:56 | Henry, Missouri, US | |
2022-03-15 | US | Missouri | Henry | 29083 | 5729 | 80 | 0 | 38.38482826 | -93.79293734 | 2022-03-16 04:20:50 | Henry, Missouri, US | |
2022-03-02 | US | North Carolina | Greene | 37079 | 5729 | 56 | 0 | 35.48544173 | -77.67578087 | 2022-03-03 04:21:01 | Greene, North Carolina, US | |
2022-03-01 | US | Puerto Rico | Aguada | 72003 | 5729 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-03-02 04:21:07 | Aguada, Puerto Rico, US | |
2022-02-28 | US | Puerto Rico | Aguada | 72003 | 5729 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-03-01 04:21:09 | Aguada, Puerto Rico, US | |
2022-02-28 | US | Mississippi | Sunflower | 28133 | 5729 | 118 | 0 | 33.60192578 | -90.58882684 | 2022-03-01 04:21:09 | Sunflower, Mississippi, US | |
2022-02-28 | US | California | Unassigned | 90006 | 5729 | 4 | 0 | 41.74228275 | 0.0 | 2022-03-01 04:21:09 | Unassigned, California, US | |
2022-02-24 | US | New York | Seneca | 36099 | 5729 | 89 | 0 | 42.78081007 | -76.82497064 | 2022-02-25 04:21:11 | Seneca, New York, US | |
2022-02-20 | US | Kentucky | Johnson | 21115 | 5729 | 87 | 0 | 37.85106355 | -82.8264322 | 2022-02-21 04:21:05 | Johnson, Kentucky, US | |
2022-02-19 | US | Kentucky | Johnson | 21115 | 5729 | 87 | 0 | 37.85106355 | -82.8264322 | 2022-02-20 04:21:00 | Johnson, Kentucky, US | |
2022-02-18 | US | Kentucky | Johnson | 21115 | 5729 | 87 | 0 | 37.85106355 | -82.8264322 | 2022-02-19 04:21:11 | Johnson, Kentucky, US | |
2022-02-09 | US | Missouri | Washington | 29221 | 5729 | 119 | 0 | 37.96130078 | -90.87948158 | 2022-02-10 04:21:14 | Washington, Missouri, US | |
2022-02-01 | US | Kentucky | Letcher | 21133 | 5729 | 87 | 0 | 37.12306748 | -82.85346474 | 2022-02-02 04:21:09 | Letcher, Kentucky, US | |
2022-01-30 | US | Tennessee | DeKalb | 47041 | 5729 | 91 | 0 | 35.97616272 | -85.83689361 | 2022-01-31 04:21:09 | DeKalb, Tennessee, US | |
2022-01-27 | US | Georgia | Peach | 13225 | 5729 | 115 | 0 | 32.56934316 | -83.82937 | 2022-01-28 04:21:09 | Peach, Georgia, US | |
2022-01-13 | US | West Virginia | Mingo | 54059 | 5729 | 102 | 0 | 37.73048351 | -82.13338365 | 2022-01-14 04:21:54 | Mingo, West Virginia, US | |
2022-01-08 | US | Maryland | Queen Anne's | 24035 | 5729 | 86 | 0 | 39.06198912 | -76.03530977 | 2022-01-09 04:21:46 | Queen Anne's, Maryland, US | |
2022-01-06 | US | Alabama | Pike | 1109 | 5729 | 112 | 0 | 31.80396383 | -85.9408295 | 2022-01-07 04:22:09 | Pike, Alabama, US | |
2021-12-27 | Comoros | 5729 | 153 | 0 | -11.6455 | 43.3333 | 2021-12-28 04:21:47 | Comoros | ||||
2021-12-18 | US | West Virginia | Randolph | 54083 | 5729 | 60 | 0 | 38.769899 | -79.87919615 | 2021-12-19 04:21:11 | Randolph, West Virginia, US | |
2021-12-12 | US | Kentucky | Boyle | 21021 | 5729 | 109 | 0 | 37.62680923 | -84.8633779 | 2021-12-13 04:22:02 | Boyle, Kentucky, US | |
2021-11-29 | US | Illinois | Randolph | 17157 | 5729 | 103 | 0 | 38.05095369 | -89.82512254 | 2021-11-30 04:22:53 | Randolph, Illinois, US | |
2021-11-28 | US | Wisconsin | Oneida | 55085 | 5729 | 97 | 0 | 45.70677897 | -89.51944105 | 2021-11-29 04:22:30 | Oneida, Wisconsin, US | |
2021-11-27 | US | Wisconsin | Oneida | 55085 | 5729 | 97 | 0 | 45.70677897 | -89.51944105 | 2021-11-28 04:22:43 | Oneida, Wisconsin, US | |
2021-11-26 | US | Wisconsin | Oneida | 55085 | 5729 | 97 | 0 | 45.70677897 | -89.51944105 | 2021-11-27 04:22:45 | Oneida, Wisconsin, US | |
2021-11-25 | US | Wisconsin | Oneida | 55085 | 5729 | 97 | 0 | 45.70677897 | -89.51944105 | 2021-11-26 04:22:33 | Oneida, Wisconsin, US | |
2021-11-21 | US | New York | Allegany | 36003 | 5729 | 117 | 0 | 42.25748406 | -78.02750466 | 2021-11-22 04:22:20 | Allegany, New York, US | |
2021-11-11 | US | South Dakota | Codington | 46029 | 5729 | 84 | 0 | 44.97788119 | -97.18827677 | 2021-11-12 04:22:01 | Codington, South Dakota, US | |
2021-11-10 | US | South Dakota | Codington | 46029 | 5729 | 84 | 0 | 44.97788119 | -97.18827677 | 2021-11-11 04:21:45 | Codington, South Dakota, US | |
2021-11-10 | US | New York | Cortland | 36023 | 5729 | 87 | 0 | 42.59509207 | -76.07048931 | 2021-11-11 04:21:45 | Cortland, New York, US | |
2021-10-27 | US | Alabama | Chambers | 1017 | 5729 | 142 | 0 | 32.91360079 | -85.39072749 | 2021-10-28 04:22:08 | Chambers, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;