daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
142 rows where confirmed = 5476 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-26 | US | Illinois | Johnson | 17087 | 5476 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-27 04:21:07 | Johnson, Illinois, US | |
2022-12-25 | US | Illinois | Johnson | 17087 | 5476 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-26 04:21:06 | Johnson, Illinois, US | |
2022-12-24 | US | Illinois | Johnson | 17087 | 5476 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-25 04:21:04 | Johnson, Illinois, US | |
2022-12-23 | US | Illinois | Johnson | 17087 | 5476 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-24 04:21:02 | Johnson, Illinois, US | |
2022-12-20 | US | Puerto Rico | Loiza | 72087 | 5476 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-21 04:21:03 | Loiza, Puerto Rico, US | |
2022-12-19 | US | Puerto Rico | Loiza | 72087 | 5476 | 0 | 0 | 18.425688 | -65.89943 | 2022-12-20 04:21:04 | Loiza, Puerto Rico, US | |
2022-11-22 | US | Tennessee | Polk | 47139 | 5476 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-23 04:21:06 | Polk, Tennessee, US | |
2022-11-03 | US | Texas | Deaf Smith | 48117 | 5476 | 117 | 0 | 34.96522957 | -102.6054267 | 2022-11-04 04:22:11 | Deaf Smith, Texas, US | |
2022-11-02 | US | Texas | Deaf Smith | 48117 | 5476 | 117 | 0 | 34.96522957 | -102.6054267 | 2022-11-03 04:22:05 | Deaf Smith, Texas, US | |
2022-10-24 | US | Colorado | Chaffee | 8015 | 5476 | 56 | 0 | 38.74745778 | -106.1926573 | 2022-10-25 04:21:53 | Chaffee, Colorado, US | |
2022-10-19 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-20 04:22:59 | McIntosh, Oklahoma, US | |
2022-10-19 | US | Colorado | Alamosa | 8003 | 5476 | 64 | 0 | 37.57250606 | -105.7885451 | 2022-10-20 04:22:59 | Alamosa, Colorado, US | |
2022-10-18 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-19 04:22:26 | McIntosh, Oklahoma, US | |
2022-10-17 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-18 04:22:42 | McIntosh, Oklahoma, US | |
2022-10-16 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-17 04:20:31 | McIntosh, Oklahoma, US | |
2022-10-15 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-16 04:22:39 | McIntosh, Oklahoma, US | |
2022-10-14 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-15 04:22:00 | McIntosh, Oklahoma, US | |
2022-10-13 | US | Oklahoma | McIntosh | 40091 | 5476 | 128 | 0 | 35.37235506 | -95.66599306 | 2022-10-14 04:22:28 | McIntosh, Oklahoma, US | |
2022-09-22 | US | Wisconsin | Sawyer | 55113 | 5476 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-09-23 04:23:13 | Sawyer, Wisconsin, US | |
2022-08-18 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-19 04:20:54 | New Madrid, Missouri, US | |
2022-08-17 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-18 04:21:11 | New Madrid, Missouri, US | |
2022-08-16 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-17 04:20:59 | New Madrid, Missouri, US | |
2022-08-15 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-16 04:20:58 | New Madrid, Missouri, US | |
2022-08-14 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-15 04:20:59 | New Madrid, Missouri, US | |
2022-08-13 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-14 04:20:55 | New Madrid, Missouri, US | |
2022-08-12 | US | Missouri | New Madrid | 29143 | 5476 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-08-13 04:20:52 | New Madrid, Missouri, US | |
2022-07-24 | US | Virginia | Colonial Heights | 51570 | 5476 | 101 | 0 | 37.26420587 | -77.39609676 | 2022-07-25 04:20:51 | Colonial Heights, Virginia, US | |
2022-07-23 | US | Virginia | Colonial Heights | 51570 | 5476 | 101 | 0 | 37.26420587 | -77.39609676 | 2022-07-24 04:20:47 | Colonial Heights, Virginia, US | |
2022-07-22 | US | Virginia | Colonial Heights | 51570 | 5476 | 101 | 0 | 37.26420587 | -77.39609676 | 2022-07-23 04:20:53 | Colonial Heights, Virginia, US | |
2022-07-12 | US | Tennessee | Crockett | 47033 | 5476 | 88 | 0 | 35.81830662 | -89.14916269 | 2022-07-13 04:20:58 | Crockett, Tennessee, US | |
2022-06-21 | US | Virginia | King George | 51099 | 5476 | 40 | 0 | 38.26818502 | -77.15852768 | 2022-06-22 04:20:54 | King George, Virginia, US | |
2022-06-17 | US | Puerto Rico | Aguas Buenas | 72007 | 5476 | 0 | 0 | 18.251619 | -66.126806 | 2022-06-18 04:21:10 | Aguas Buenas, Puerto Rico, US | |
2022-06-15 | US | Arkansas | Clark | 5019 | 5476 | 82 | 0 | 34.04613432 | -93.17484713 | 2022-06-16 04:20:55 | Clark, Arkansas, US | |
2022-06-09 | US | Puerto Rico | San German | 72125 | 5476 | 0 | 0 | 18.111484 | -67.038581 | 2022-06-10 04:20:55 | San German, Puerto Rico, US | |
2022-06-07 | US | Oregon | Wasco | 41065 | 5476 | 63 | 0 | 45.16292781 | -121.1670954 | 2022-06-08 04:20:55 | Wasco, Oregon, US | |
2022-06-01 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-06-02 05:20:39 | Wyandot, Ohio, US | |
2022-05-31 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-06-01 04:20:55 | Wyandot, Ohio, US | |
2022-05-30 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-05-31 04:20:51 | Wyandot, Ohio, US | |
2022-05-29 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-05-30 04:20:50 | Wyandot, Ohio, US | |
2022-05-28 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-05-29 04:20:53 | Wyandot, Ohio, US | |
2022-05-27 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-05-28 04:21:07 | Wyandot, Ohio, US | |
2022-05-26 | US | Ohio | Wyandot | 39175 | 5476 | 105 | 0 | 40.84339621 | -83.30734173 | 2022-05-27 04:20:56 | Wyandot, Ohio, US | |
2022-03-26 | Russia | Chukotka Autonomous Okrug | 5476 | 41 | 0 | 66.0006475 | 169.4900869 | 2022-03-27 04:20:47 | Chukotka Autonomous Okrug, Russia | |||
2022-03-17 | US | Illinois | Lawrence | 17101 | 5476 | 42 | 0 | 38.71987914 | -87.72884035 | 2022-03-18 04:20:55 | Lawrence, Illinois, US | |
2022-03-09 | US | Missouri | Adair | 29001 | 5476 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-10 04:20:48 | Adair, Missouri, US | |
2022-03-02 | US | California | Unassigned | 90006 | 5476 | 3 | 0 | 41.74228275 | 0.0 | 2022-03-03 04:21:01 | Unassigned, California, US | |
2022-03-01 | US | Puerto Rico | Corozal | 72047 | 5476 | 0 | 0 | 18.304264 | -66.327738 | 2022-03-02 04:21:07 | Corozal, Puerto Rico, US | |
2022-02-28 | US | Puerto Rico | Corozal | 72047 | 5476 | 0 | 0 | 18.304264 | -66.327738 | 2022-03-01 04:21:09 | Corozal, Puerto Rico, US | |
2022-02-27 | US | Puerto Rico | Corozal | 72047 | 5476 | 0 | 0 | 18.304264 | -66.327738 | 2022-02-28 04:21:05 | Corozal, Puerto Rico, US | |
2022-02-15 | US | Maryland | Garrett | 24023 | 5476 | 112 | 0 | 39.52786077 | -79.27355126 | 2022-02-16 04:21:10 | Garrett, Maryland, US | |
2022-02-14 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-15 04:21:09 | Sumner, Kansas, US | |
2022-02-13 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-14 04:20:51 | Sumner, Kansas, US | |
2022-02-12 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-13 04:21:00 | Sumner, Kansas, US | |
2022-02-11 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-12 04:21:06 | Sumner, Kansas, US | |
2022-02-10 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-11 04:21:09 | Sumner, Kansas, US | |
2022-02-09 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-10 04:21:14 | Sumner, Kansas, US | |
2022-02-08 | US | Kentucky | Bourbon | 21017 | 5476 | 46 | 0 | 38.2054607 | -84.21827874 | 2022-02-09 04:21:04 | Bourbon, Kentucky, US | |
2022-02-08 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-09 04:21:04 | Sumner, Kansas, US | |
2022-02-07 | US | Kansas | Sumner | 20191 | 5476 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-08 04:21:15 | Sumner, Kansas, US | |
2022-01-30 | US | Kentucky | Harrison | 21097 | 5476 | 58 | 0 | 38.44188174 | -84.32869741 | 2022-01-31 04:21:09 | Harrison, Kentucky, US | |
2022-01-29 | US | Kentucky | Harrison | 21097 | 5476 | 58 | 0 | 38.44188174 | -84.32869741 | 2022-01-30 04:21:26 | Harrison, Kentucky, US | |
2022-01-28 | US | Kentucky | Harrison | 21097 | 5476 | 58 | 0 | 38.44188174 | -84.32869741 | 2022-01-29 04:21:10 | Harrison, Kentucky, US | |
2022-01-24 | US | Kentucky | Allen | 21003 | 5476 | 87 | 0 | 36.75197631 | -86.19457544 | 2022-01-25 04:21:05 | Allen, Kentucky, US | |
2021-12-26 | US | Washington | Kittitas | 53037 | 5476 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-27 04:21:58 | Kittitas, Washington, US | |
2021-12-25 | US | Washington | Kittitas | 53037 | 5476 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-26 04:21:50 | Kittitas, Washington, US | |
2021-12-24 | US | Washington | Kittitas | 53037 | 5476 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-25 04:21:37 | Kittitas, Washington, US | |
2021-12-23 | US | Washington | Kittitas | 53037 | 5476 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-24 04:21:34 | Kittitas, Washington, US | |
2021-12-17 | US | Alabama | Marion | 1093 | 5476 | 132 | 0 | 34.13697363 | -87.88704173 | 2021-12-18 02:22:20 | Marion, Alabama, US | |
2021-12-05 | US | Georgia | Upson | 13293 | 5476 | 189 | 0 | 32.87920671 | -84.30024826 | 2021-12-06 04:22:34 | Upson, Georgia, US | |
2021-12-04 | US | Georgia | Upson | 13293 | 5476 | 189 | 0 | 32.87920671 | -84.30024826 | 2021-12-05 04:22:25 | Upson, Georgia, US | |
2021-12-03 | US | Georgia | Upson | 13293 | 5476 | 189 | 0 | 32.87920671 | -84.30024826 | 2021-12-04 04:22:18 | Upson, Georgia, US | |
2021-11-26 | US | Pennsylvania | Tioga | 42117 | 5476 | 148 | 0 | 41.77255149 | -77.25433032 | 2021-11-27 04:22:45 | Tioga, Pennsylvania, US | |
2021-11-08 | US | Nebraska | Platte | 31141 | 5476 | 50 | 0 | 41.57246836 | -97.52144359 | 2021-11-09 04:21:36 | Platte, Nebraska, US | |
2021-11-02 | US | Kentucky | Taylor | 21217 | 5476 | 81 | 0 | 37.3677562 | -85.3329931 | 2021-11-03 06:22:09 | Taylor, Kentucky, US | |
2021-11-02 | US | Indiana | Wabash | 18169 | 5476 | 105 | 0 | 40.84704239 | -85.79328272 | 2021-11-03 06:22:09 | Wabash, Indiana, US | |
2021-10-31 | US | Tennessee | Claiborne | 47025 | 5476 | 110 | 0 | 36.48319149 | -83.65947309 | 2021-11-01 04:22:01 | Claiborne, Tennessee, US | |
2021-10-31 | US | North Carolina | Bladen | 37017 | 5476 | 95 | 0 | 34.61296243 | -78.56180059 | 2021-11-01 04:22:01 | Bladen, North Carolina, US | |
2021-10-31 | US | Mississippi | Lincoln | 28085 | 5476 | 135 | 0 | 31.53288662 | -90.45391915 | 2021-11-01 04:22:01 | Lincoln, Mississippi, US | |
2021-10-30 | US | North Carolina | Bladen | 37017 | 5476 | 95 | 0 | 34.61296243 | -78.56180059 | 2021-10-31 04:22:08 | Bladen, North Carolina, US | |
2021-10-30 | US | Mississippi | Lincoln | 28085 | 5476 | 135 | 0 | 31.53288662 | -90.45391915 | 2021-10-31 04:22:08 | Lincoln, Mississippi, US | |
2021-10-29 | US | North Carolina | Bladen | 37017 | 5476 | 95 | 0 | 34.61296243 | -78.56180059 | 2021-10-30 04:22:03 | Bladen, North Carolina, US | |
2021-10-29 | US | Mississippi | Lincoln | 28085 | 5476 | 135 | 0 | 31.53288662 | -90.45391915 | 2021-10-30 04:22:03 | Lincoln, Mississippi, US | |
2021-09-28 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-29 04:21:45 | Sioux, Iowa, US | |
2021-09-27 | US | Missouri | Howell | 29091 | 5476 | 66 | 0 | 36.77383887 | -91.88683935 | 2021-09-28 04:21:28 | Howell, Missouri, US | |
2021-09-27 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-28 04:21:28 | Sioux, Iowa, US | |
2021-09-26 | US | Tennessee | Marion | 47115 | 5476 | 52 | 0 | 35.12997174 | -85.62265895 | 2021-09-27 04:21:16 | Marion, Tennessee, US | |
2021-09-26 | US | Missouri | Howell | 29091 | 5476 | 66 | 0 | 36.77383887 | -91.88683935 | 2021-09-27 04:21:16 | Howell, Missouri, US | |
2021-09-26 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-27 04:21:16 | Sioux, Iowa, US | |
2021-09-25 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-26 04:21:29 | Sioux, Iowa, US | |
2021-09-24 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-25 04:21:31 | Sioux, Iowa, US | |
2021-09-23 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-24 04:21:44 | Sioux, Iowa, US | |
2021-09-22 | US | Missouri | Webster | 29225 | 5476 | 85 | 0 | 37.2813734 | -92.876329 | 2021-09-23 04:21:43 | Webster, Missouri, US | |
2021-09-22 | US | Iowa | Sioux | 19167 | 5476 | 76 | 0 | 43.08221074 | -96.17675679999999 | 2021-09-23 04:21:43 | Sioux, Iowa, US | |
2021-09-18 | United Kingdom | Gibraltar | 5476 | 97 | 0 | 36.1408 | -5.3536 | 2021-09-19 04:21:34 | Gibraltar, United Kingdom | |||
2021-09-17 | Japan | Yamaguchi | 5476 | 88 | 0 | 34.201190000000004 | 131.573293 | 2021-09-18 04:21:24 | Yamaguchi, Japan | |||
2021-08-23 | US | Kentucky | Barren | 21009 | 5476 | 108 | 0 | 36.96469836 | -85.93338945 | 2021-08-24 04:21:19 | Barren, Kentucky, US | |
2021-08-11 | US | Ohio | Washington | 39167 | 5476 | 111 | 0 | 39.45690571 | -81.49121382 | 2021-08-12 04:21:25 | Washington, Ohio, US | |
2021-08-06 | US | Kentucky | Henderson | 21101 | 5476 | 80 | 0 | 37.79344553 | -87.57392021 | 2021-08-07 04:21:30 | Henderson, Kentucky, US | |
2021-08-03 | US | Ohio | Darke | 39037 | 5476 | 131 | 0 | 40.13412966 | -84.6194517 | 2021-08-04 04:21:25 | Darke, Ohio, US | |
2021-07-20 | US | Mississippi | Washington | 28151 | 5476 | 139 | 0 | 33.28392041 | -90.94196237 | 2021-07-21 04:21:40 | Washington, Mississippi, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;