johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
178 rows where confirmed = 4485 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3526398 | 3526398 | 2022-11-24 | US | Tennessee | Grundy | 47061 | 4485 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-11-25 04:21:06 | Grundy, Tennessee, US | |
1641742 | 1641742 | 2022-11-20 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-21 04:21:05 | Clinton, Kentucky, US | |
2065299 | 2065299 | 2022-11-19 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-20 04:21:08 | Clinton, Kentucky, US | |
1756693 | 1756693 | 2022-11-18 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-19 04:21:14 | Clinton, Kentucky, US | |
3027686 | 3027686 | 2022-11-17 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-18 04:21:15 | Clinton, Kentucky, US | |
2487397 | 2487397 | 2022-11-16 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-17 04:21:11 | Clinton, Kentucky, US | |
2485807 | 2485807 | 2022-11-16 | China | Shaanxi | 4485 | 3 | 0 | 35.1917 | 108.8701 | 2022-11-17 04:21:11 | Shaanxi, China | |||
293408 | 293408 | 2022-11-15 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-16 04:21:09 | Clinton, Kentucky, US | |
293072 | 293072 | 2022-11-15 | US | Illinois | Wabash | 17185 | 4485 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-11-16 04:21:09 | Wabash, Illinois, US | |
3598438 | 3598438 | 2022-11-14 | US | Kentucky | Clinton | 21053 | 4485 | 57 | 0 | 36.72581156 | -85.13377529 | 2022-11-15 04:21:16 | Clinton, Kentucky, US | |
797807 | 797807 | 2022-10-24 | US | Virginia | Patrick | 51141 | 4485 | 99 | 0 | 36.6801638 | -80.2865648 | 2022-10-25 04:21:53 | Patrick, Virginia, US | |
3998028 | 3998028 | 2022-09-27 | US | Virginia | Patrick | 51141 | 4485 | 99 | 0 | 36.6801638 | -80.2865648 | 2022-09-28 04:23:01 | Patrick, Virginia, US | |
2017748 | 2017748 | 2022-09-20 | US | Illinois | Mason | 17125 | 4485 | 65 | 0 | 40.23917274 | -89.91824452 | 2022-09-21 04:23:22 | Mason, Illinois, US | |
1892448 | 1892448 | 2022-09-14 | US | Virginia | Appomattox | 51011 | 4485 | 57 | 0 | 37.37569884 | -78.81340003 | 2022-09-15 04:21:02 | Appomattox, Virginia, US | |
1889664 | 1889664 | 2022-09-14 | US | Arkansas | Polk | 5113 | 4485 | 152 | 0 | 34.48254879 | -94.22728802 | 2022-09-15 04:21:02 | Polk, Arkansas, US | |
3745618 | 3745618 | 2022-09-07 | US | Arkansas | Madison | 5087 | 4485 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-09-08 04:21:02 | Madison, Arkansas, US | |
1087107 | 1087107 | 2022-08-09 | US | Illinois | Moultrie | 17139 | 4485 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-08-10 04:20:57 | Moultrie, Illinois, US | |
1071743 | 1071743 | 2022-08-07 | US | Mississippi | Smith | 28129 | 4485 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-08-08 04:21:08 | Smith, Mississippi, US | |
1942331 | 1942331 | 2022-08-06 | US | Mississippi | Smith | 28129 | 4485 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-08-07 04:20:54 | Smith, Mississippi, US | |
882130 | 882130 | 2022-08-05 | US | Mississippi | Smith | 28129 | 4485 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-08-06 04:20:56 | Smith, Mississippi, US | |
2010541 | 2010541 | 2022-08-04 | US | Mississippi | Smith | 28129 | 4485 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-08-05 04:20:52 | Smith, Mississippi, US | |
3874716 | 3874716 | 2022-07-31 | US | Texas | Lavaca | 48285 | 4485 | 122 | 0 | 29.38508402 | -96.93186692 | 2022-08-01 04:21:03 | Lavaca, Texas, US | |
677470 | 677470 | 2022-07-30 | US | Texas | Lavaca | 48285 | 4485 | 122 | 0 | 29.38508402 | -96.93186692 | 2022-07-31 04:21:02 | Lavaca, Texas, US | |
1786669 | 1786669 | 2022-07-29 | US | Texas | Lavaca | 48285 | 4485 | 122 | 0 | 29.38508402 | -96.93186692 | 2022-07-30 04:20:42 | Lavaca, Texas, US | |
2242747 | 2242747 | 2022-06-28 | US | Virginia | Goochland | 51075 | 4485 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-06-29 04:20:59 | Goochland, Virginia, US | |
3200863 | 3200863 | 2022-05-29 | US | Puerto Rico | Barceloneta | 72017 | 4485 | 0 | 0 | 18.445533 | -66.560531 | 2022-05-30 04:20:50 | Barceloneta, Puerto Rico, US | |
2048848 | 2048848 | 2022-05-25 | US | Illinois | De Witt | 17039 | 4485 | 39 | 0 | 40.17514519 | -88.90959682 | 2022-05-26 04:20:50 | De Witt, Illinois, US | |
3596337 | 3596337 | 2022-05-23 | US | Virginia | Bristol | 51520 | 4485 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-05-24 04:20:57 | Bristol, Virginia, US | |
622859 | 622859 | 2022-05-22 | US | Illinois | De Witt | 17039 | 4485 | 39 | 0 | 40.17514519 | -88.90959682 | 2022-05-26 04:20:50 | De Witt, Illinois, US | |
3538681 | 3538681 | 2022-05-10 | US | Texas | Shelby | 48419 | 4485 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-11 04:20:48 | Shelby, Texas, US | |
225216 | 225216 | 2022-05-09 | US | Texas | Shelby | 48419 | 4485 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-10 04:20:50 | Shelby, Texas, US | |
2334601 | 2334601 | 2022-05-08 | US | Texas | Shelby | 48419 | 4485 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-09 04:20:54 | Shelby, Texas, US | |
363563 | 363563 | 2022-05-07 | US | Texas | Shelby | 48419 | 4485 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-08 04:20:49 | Shelby, Texas, US | |
1400914 | 1400914 | 2022-05-06 | US | Texas | Shelby | 48419 | 4485 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-07 04:21:09 | Shelby, Texas, US | |
1573141 | 1573141 | 2022-05-03 | US | Illinois | Johnson | 17087 | 4485 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-05-04 04:20:59 | Johnson, Illinois, US | |
3917604 | 3917604 | 2022-05-01 | US | Maine | Washington | 23029 | 4485 | 55 | 0 | 45.01607142 | -67.62813524 | 2022-05-02 04:21:10 | Washington, Maine, US | |
2842408 | 2842408 | 2022-04-30 | US | Maine | Washington | 23029 | 4485 | 55 | 0 | 45.01607142 | -67.62813524 | 2022-05-01 04:20:57 | Washington, Maine, US | |
3353420 | 3353420 | 2022-04-01 | US | Puerto Rico | Naranjito | 72105 | 4485 | 0 | 0 | 18.288019 | -66.252703 | 2022-04-02 04:20:47 | Naranjito, Puerto Rico, US | |
1542725 | 1542725 | 2022-03-31 | US | Puerto Rico | Naranjito | 72105 | 4485 | 0 | 0 | 18.288019 | -66.252703 | 2022-04-01 04:20:28 | Naranjito, Puerto Rico, US | |
2321056 | 2321056 | 2022-03-16 | US | Minnesota | Houston | 27055 | 4485 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-17 04:20:56 | Houston, Minnesota, US | |
2320761 | 2320761 | 2022-03-16 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-17 04:20:56 | Lawrence, Kentucky, US | |
263256 | 263256 | 2022-03-15 | US | Minnesota | Houston | 27055 | 4485 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-16 04:20:50 | Houston, Minnesota, US | |
262961 | 262961 | 2022-03-15 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-16 04:20:50 | Lawrence, Kentucky, US | |
2265320 | 2265320 | 2022-03-14 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-15 04:20:47 | Lawrence, Kentucky, US | |
3631389 | 3631389 | 2022-03-13 | US | Washington | Asotin | 53003 | 4485 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-14 04:20:46 | Asotin, Washington, US | |
3629386 | 3629386 | 2022-03-13 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-14 04:20:46 | Lawrence, Kentucky, US | |
954297 | 954297 | 2022-03-12 | US | Washington | Asotin | 53003 | 4485 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-13 04:20:49 | Asotin, Washington, US | |
952294 | 952294 | 2022-03-12 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-13 04:20:49 | Lawrence, Kentucky, US | |
359758 | 359758 | 2022-03-11 | US | Washington | Asotin | 53003 | 4485 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-12 04:20:50 | Asotin, Washington, US | |
357755 | 357755 | 2022-03-11 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-12 04:20:50 | Lawrence, Kentucky, US | |
1866907 | 1866907 | 2022-03-10 | US | Kentucky | Lawrence | 21127 | 4485 | 59 | 0 | 38.07136018 | -82.72882223 | 2022-03-11 04:20:50 | Lawrence, Kentucky, US | |
2200131 | 2200131 | 2022-03-06 | US | Arkansas | Hempstead | 5057 | 4485 | 58 | 0 | 33.73325583 | -93.66935133 | 2022-03-07 04:20:47 | Hempstead, Arkansas, US | |
2092588 | 2092588 | 2022-03-05 | US | Arkansas | Hempstead | 5057 | 4485 | 58 | 0 | 33.73325583 | -93.66935133 | 2022-03-06 04:20:49 | Hempstead, Arkansas, US | |
2736607 | 2736607 | 2022-02-27 | US | Wisconsin | Sawyer | 55113 | 4485 | 58 | 0 | 45.87931905 | -91.14504927 | 2022-02-28 04:21:05 | Sawyer, Wisconsin, US | |
3049760 | 3049760 | 2022-02-26 | US | Wisconsin | Sawyer | 55113 | 4485 | 58 | 0 | 45.87931905 | -91.14504927 | 2022-02-27 04:21:04 | Sawyer, Wisconsin, US | |
578415 | 578415 | 2022-02-25 | US | Wisconsin | Sawyer | 55113 | 4485 | 58 | 0 | 45.87931905 | -91.14504927 | 2022-02-26 04:21:12 | Sawyer, Wisconsin, US | |
3075836 | 3075836 | 2022-02-09 | US | Mississippi | Calhoun | 28013 | 4485 | 57 | 0 | 33.93683395 | -89.33686647 | 2022-02-10 04:21:14 | Calhoun, Mississippi, US | |
1364363 | 1364363 | 2022-02-08 | US | Montana | Lincoln | 30053 | 4485 | 77 | 0 | 48.54265777 | -115.4046155 | 2022-02-09 04:21:04 | Lincoln, Montana, US | |
1362836 | 1362836 | 2022-02-08 | US | Arkansas | Drew | 5043 | 4485 | 58 | 0 | 33.59035001 | -91.71777921 | 2022-02-09 04:21:04 | Drew, Arkansas, US | |
73939 | 73939 | 2022-02-07 | US | South Dakota | Beadle | 46005 | 4485 | 52 | 0 | 44.41464384 | -98.27858469 | 2022-02-08 04:21:15 | Beadle, South Dakota, US | |
460166 | 460166 | 2022-02-02 | US | Georgia | Crisp | 13081 | 4485 | 129 | 0 | 31.92289565 | -83.76811843 | 2022-02-03 04:21:21 | Crisp, Georgia, US | |
3303293 | 3303293 | 2022-01-30 | US | Texas | Fayette | 48149 | 4485 | 98 | 0 | 29.87788372 | -96.92076062 | 2022-01-31 04:21:09 | Fayette, Texas, US | |
3063867 | 3063867 | 2022-01-29 | US | Missouri | Andrew | 29003 | 4485 | 44 | 0 | 39.98492163 | -94.80163024 | 2022-01-30 04:21:26 | Andrew, Missouri, US | |
2052762 | 2052762 | 2022-01-25 | US | Georgia | Tattnall | 13267 | 4485 | 120 | 0 | 32.04785085 | -82.05539188 | 2022-01-26 04:21:07 | Tattnall, Georgia, US | |
1960950 | 1960950 | 2022-01-20 | US | Alabama | Monroe | 1099 | 4485 | 67 | 0 | 31.56729412 | -87.36995001 | 2022-01-21 04:21:09 | Monroe, Alabama, US | |
1115269 | 1115269 | 2022-01-11 | US | Michigan | Otsego | 26137 | 4485 | 84 | 0 | 45.02085831 | -84.59898295 | 2022-01-12 04:21:44 | Otsego, Michigan, US | |
1695499 | 1695499 | 2022-01-10 | US | Texas | Moore | 48341 | 4485 | 95 | 0 | 35.83769242 | -101.8930281 | 2022-01-11 04:22:01 | Moore, Texas, US | |
1693997 | 1693997 | 2022-01-10 | US | Michigan | Otsego | 26137 | 4485 | 84 | 0 | 45.02085831 | -84.59898295 | 2022-01-11 04:22:01 | Otsego, Michigan, US | |
1218320 | 1218320 | 2022-01-08 | US | Puerto Rico | Juncos | 72077 | 4485 | 0 | 0 | 18.223793 | -65.909109 | 2022-01-09 04:21:46 | Juncos, Puerto Rico, US | |
2612335 | 2612335 | 2022-01-06 | US | North Carolina | Anson | 37007 | 4485 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-07 04:22:09 | Anson, North Carolina, US | |
2611629 | 2611629 | 2022-01-06 | US | Maryland | Garrett | 24023 | 4485 | 98 | 0 | 39.52786077 | -79.27355126 | 2022-01-07 04:22:09 | Garrett, Maryland, US | |
1284126 | 1284126 | 2022-01-05 | US | Nevada | Churchill | 32001 | 4485 | 92 | 0 | 39.58105744 | -118.3394607 | 2022-01-06 04:22:09 | Churchill, Nevada, US | |
2170557 | 2170557 | 2022-01-01 | US | Tennessee | Smith | 47159 | 4485 | 64 | 0 | 36.25359775 | -85.95411046 | 2022-01-02 04:20:52 | Smith, Tennessee, US | |
1434366 | 1434366 | 2021-12-28 | US | Mississippi | Covington | 28031 | 4485 | 96 | 0 | 31.63225413 | -89.55389939 | 2021-12-29 03:21:43 | Covington, Mississippi, US | |
2966109 | 2966109 | 2021-12-24 | US | Puerto Rico | Arecibo | 72013 | 4485 | 0 | 0 | 18.406631 | -66.675077 | 2021-12-25 04:21:37 | Arecibo, Puerto Rico, US | |
3819141 | 3819141 | 2021-12-23 | US | Puerto Rico | Arecibo | 72013 | 4485 | 0 | 0 | 18.406631 | -66.675077 | 2021-12-24 04:21:34 | Arecibo, Puerto Rico, US | |
798541 | 798541 | 2021-12-22 | Monaco | 4485 | 37 | 0 | 43.7333 | 7.4167 | 2021-12-23 04:21:21 | Monaco | ||||
3828581 | 3828581 | 2021-12-21 | Monaco | 4485 | 37 | 0 | 43.7333 | 7.4167 | 2021-12-22 04:21:54 | Monaco | ||||
1804178 | 1804178 | 2021-11-25 | US | Kentucky | Lincoln | 21137 | 4485 | 102 | 0 | 37.45475628 | -84.6565327 | 2021-11-26 04:22:33 | Lincoln, Kentucky, US | |
3072191 | 3072191 | 2021-11-23 | US | New Hampshire | Sullivan | 33019 | 4485 | 39 | 0 | 43.36094111 | -72.22203125 | 2021-11-24 04:22:14 | Sullivan, New Hampshire, US | |
165072 | 165072 | 2021-11-19 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-20 04:22:17 | Cass, Texas, US | |
162523 | 162523 | 2021-11-19 | US | Arkansas | Jackson | 5067 | 4485 | 46 | 0 | 35.59802983 | -91.21494602 | 2021-11-20 04:22:17 | Jackson, Arkansas, US | |
3291959 | 3291959 | 2021-11-18 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-19 04:21:40 | Cass, Texas, US | |
450415 | 450415 | 2021-11-17 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-18 04:21:33 | Cass, Texas, US | |
449525 | 449525 | 2021-11-17 | US | New Hampshire | Carroll | 33003 | 4485 | 20 | 0 | 43.87498583 | -71.20430216 | 2021-11-18 04:21:33 | Carroll, New Hampshire, US | |
3345665 | 3345665 | 2021-11-16 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-17 04:21:48 | Cass, Texas, US | |
2290501 | 2290501 | 2021-11-15 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-16 04:21:10 | Cass, Texas, US | |
1325275 | 1325275 | 2021-11-14 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-15 04:21:36 | Cass, Texas, US | |
689401 | 689401 | 2021-11-13 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-14 04:21:31 | Cass, Texas, US | |
717510 | 717510 | 2021-11-12 | US | Texas | Cass | 48067 | 4485 | 152 | 0 | 33.07499881 | -94.34646905 | 2021-11-13 04:21:38 | Cass, Texas, US | |
3513640 | 3513640 | 2021-11-01 | US | New York | Franklin | 36033 | 4485 | 22 | 0 | 44.59040891 | -74.29926032 | 2021-11-02 04:22:03 | Franklin, New York, US | |
3493620 | 3493620 | 2021-10-26 | US | Kentucky | Mercer | 21167 | 4485 | 75 | 0 | 37.81474237 | -84.87488475 | 2021-10-27 04:22:32 | Mercer, Kentucky, US | |
685184 | 685184 | 2021-10-24 | US | South Carolina | Union | 45087 | 4485 | 101 | 0 | 34.68835752 | -81.61730349 | 2021-10-25 04:22:31 | Union, South Carolina, US | |
684138 | 684138 | 2021-10-24 | US | Mississippi | Copiah | 28029 | 4485 | 92 | 0 | 31.86977774 | -90.44565118 | 2021-10-25 04:22:31 | Copiah, Mississippi, US | |
773192 | 773192 | 2021-10-23 | US | South Carolina | Union | 45087 | 4485 | 101 | 0 | 34.68835752 | -81.61730349 | 2021-10-24 04:21:22 | Union, South Carolina, US | |
772146 | 772146 | 2021-10-23 | US | Mississippi | Copiah | 28029 | 4485 | 92 | 0 | 31.86977774 | -90.44565118 | 2021-10-24 04:21:22 | Copiah, Mississippi, US | |
656839 | 656839 | 2021-10-22 | US | South Carolina | Union | 45087 | 4485 | 101 | 0 | 34.68835752 | -81.61730349 | 2021-10-23 04:21:32 | Union, South Carolina, US | |
655793 | 655793 | 2021-10-22 | US | Mississippi | Copiah | 28029 | 4485 | 92 | 0 | 31.86977774 | -90.44565118 | 2021-10-23 04:21:32 | Copiah, Mississippi, US | |
2125540 | 2125540 | 2021-10-21 | US | Mississippi | Copiah | 28029 | 4485 | 92 | 0 | 31.86977774 | -90.44565118 | 2021-10-22 04:21:14 | Copiah, Mississippi, US | |
2945613 | 2945613 | 2021-10-15 | US | New York | Otsego | 36077 | 4485 | 54 | 0 | 42.63492579 | -75.03151402 | 2021-10-16 04:21:15 | Otsego, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);