johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
102 rows where confirmed = 7707 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3278342 | 3278342 | 2022-10-23 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-24 04:22:29 | Russell, Kentucky, US | |
2269380 | 2269380 | 2022-10-22 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-23 04:22:46 | Russell, Kentucky, US | |
1593680 | 1593680 | 2022-10-21 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-22 04:22:53 | Russell, Kentucky, US | |
2273396 | 2273396 | 2022-10-20 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-21 04:22:23 | Russell, Kentucky, US | |
199731 | 199731 | 2022-10-19 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-20 04:22:59 | Russell, Kentucky, US | |
2758392 | 2758392 | 2022-10-18 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-19 04:22:26 | Russell, Kentucky, US | |
2026226 | 2026226 | 2022-10-17 | US | Kentucky | Russell | 21207 | 7707 | 94 | 0 | 36.99308373 | -85.06070117 | 2022-10-18 04:22:42 | Russell, Kentucky, US | |
3253236 | 3253236 | 2022-10-11 | US | Texas | Fannin | 48147 | 7707 | 190 | 0 | 33.59564294 | -96.10751083 | 2022-10-12 04:22:51 | Fannin, Texas, US | |
2970495 | 2970495 | 2022-10-10 | US | Texas | Fannin | 48147 | 7707 | 190 | 0 | 33.59564294 | -96.10751083 | 2022-10-11 04:23:05 | Fannin, Texas, US | |
131639 | 131639 | 2022-10-04 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-10-05 04:23:06 | Toombs, Georgia, US | |
2686586 | 2686586 | 2022-10-03 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-10-04 04:22:55 | Toombs, Georgia, US | |
2262710 | 2262710 | 2022-10-02 | US | Tennessee | Grainger | 47057 | 7707 | 114 | 0 | 36.27469206 | -83.51254721 | 2022-10-03 04:23:11 | Grainger, Tennessee, US | |
2260653 | 2260653 | 2022-10-02 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-10-03 04:23:11 | Toombs, Georgia, US | |
2996179 | 2996179 | 2022-10-01 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-10-02 04:21:23 | Toombs, Georgia, US | |
854505 | 854505 | 2022-09-30 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-10-01 04:23:01 | Toombs, Georgia, US | |
2376431 | 2376431 | 2022-09-29 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-09-30 04:23:09 | Toombs, Georgia, US | |
1560982 | 1560982 | 2022-09-28 | US | Georgia | Toombs | 13279 | 7707 | 208 | 0 | 32.12059861 | -82.32957247 | 2022-09-29 04:22:34 | Toombs, Georgia, US | |
1977696 | 1977696 | 2022-09-25 | US | Indiana | Clay | 18021 | 7707 | 95 | 0 | 39.39561833 | -87.11723506 | 2022-09-26 04:20:52 | Clay, Indiana, US | |
2650863 | 2650863 | 2022-09-24 | US | Indiana | Clay | 18021 | 7707 | 95 | 0 | 39.39561833 | -87.11723506 | 2022-09-25 04:23:31 | Clay, Indiana, US | |
385303 | 385303 | 2022-09-23 | US | Indiana | Clay | 18021 | 7707 | 95 | 0 | 39.39561833 | -87.11723506 | 2022-09-24 04:21:40 | Clay, Indiana, US | |
375393 | 375393 | 2022-09-13 | US | Texas | Palo Pinto | 48363 | 7707 | 155 | 0 | 32.75310985 | -98.31319001 | 2022-09-14 04:20:44 | Palo Pinto, Texas, US | |
2397995 | 2397995 | 2022-09-12 | US | Texas | Palo Pinto | 48363 | 7707 | 155 | 0 | 32.75310985 | -98.31319001 | 2022-09-13 04:20:57 | Palo Pinto, Texas, US | |
1349689 | 1349689 | 2022-08-10 | US | Virginia | Louisa | 51109 | 7707 | 85 | 0 | 37.97850256 | -77.96274807 | 2022-08-11 04:20:49 | Louisa, Virginia, US | |
1349638 | 1349638 | 2022-08-10 | US | Virginia | Carroll | 51035 | 7707 | 153 | 0 | 36.73066666 | -80.73455942 | 2022-08-11 04:20:49 | Carroll, Virginia, US | |
1101242 | 1101242 | 2022-08-03 | US | Texas | Hopkins | 48223 | 7707 | 183 | 0 | 33.14875072 | -95.56351139 | 2022-08-04 04:20:58 | Hopkins, Texas, US | |
2338938 | 2338938 | 2022-07-27 | US | Wisconsin | Door | 55029 | 7707 | 73 | 0 | 44.95856458 | -87.30002707 | 2022-07-28 04:20:56 | Door, Wisconsin, US | |
2790889 | 2790889 | 2022-07-10 | US | Mississippi | Tippah | 28139 | 7707 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-07-11 04:20:46 | Tippah, Mississippi, US | |
143842 | 143842 | 2022-07-09 | US | Mississippi | Tippah | 28139 | 7707 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-07-10 04:20:54 | Tippah, Mississippi, US | |
1418942 | 1418942 | 2022-07-08 | US | Mississippi | Tippah | 28139 | 7707 | 109 | 0 | 34.76872156 | -88.90988194 | 2022-07-09 04:20:59 | Tippah, Mississippi, US | |
1200088 | 1200088 | 2022-07-06 | Sierra Leone | 7707 | 125 | 0 | 8.460555 | -11.779889 | 2022-07-07 04:20:55 | Sierra Leone | ||||
1770071 | 1770071 | 2022-07-03 | US | Puerto Rico | Camuy | 72027 | 7707 | 0 | 0 | 18.418578 | -66.860206 | 2022-07-04 04:20:54 | Camuy, Puerto Rico, US | |
2491567 | 2491567 | 2022-06-29 | US | Louisiana | West Baton Rouge | 22121 | 7707 | 91 | 0 | 30.46058217 | -91.30989571 | 2022-06-30 04:21:01 | West Baton Rouge, Louisiana, US | |
3268243 | 3268243 | 2022-05-04 | US | Puerto Rico | Gurabo | 72063 | 7707 | 0 | 0 | 18.266461 | -65.979705 | 2022-05-05 04:20:55 | Gurabo, Puerto Rico, US | |
463939 | 463939 | 2022-05-02 | US | California | Calaveras | 6009 | 7707 | 120 | 0 | 38.20537103 | -120.552913 | 2022-05-03 04:21:00 | Calaveras, California, US | |
2445877 | 2445877 | 2022-04-13 | US | Texas | Hockley | 48219 | 7707 | 161 | 0 | 33.60771256 | -102.3431676 | 2022-04-13 23:21:06 | Hockley, Texas, US | |
2478865 | 2478865 | 2022-03-30 | US | Georgia | Upson | 13293 | 7707 | 230 | 0 | 32.87920671 | -84.30024826 | 2022-03-31 04:20:56 | Upson, Georgia, US | |
27103 | 27103 | 2022-03-20 | US | Pennsylvania | Susquehanna | 42115 | 7707 | 107 | 0 | 41.82147784 | -75.80071959 | 2022-03-21 04:20:50 | Susquehanna, Pennsylvania, US | |
1659113 | 1659113 | 2022-03-19 | US | Pennsylvania | Susquehanna | 42115 | 7707 | 107 | 0 | 41.82147784 | -75.80071959 | 2022-03-20 04:20:45 | Susquehanna, Pennsylvania, US | |
2449735 | 2449735 | 2022-02-22 | US | Tennessee | Lauderdale | 47097 | 7707 | 92 | 0 | 35.75893438 | -89.63015909999999 | 2022-02-23 04:21:09 | Lauderdale, Tennessee, US | |
3674850 | 3674850 | 2022-02-15 | US | Texas | Polk | 48373 | 7707 | 235 | 0 | 30.79472531 | -94.82766240000001 | 2022-02-16 04:21:10 | Polk, Texas, US | |
3672170 | 3672170 | 2022-02-15 | US | Arkansas | Poinsett | 5111 | 7707 | 111 | 0 | 35.57433534 | -90.66268713 | 2022-02-16 04:21:10 | Poinsett, Arkansas, US | |
1365748 | 1365748 | 2022-02-08 | US | Virginia | Prince George | 51149 | 7707 | 59 | 0 | 37.18497668 | -77.22922187 | 2022-02-09 04:21:04 | Prince George, Virginia, US | |
3812923 | 3812923 | 2022-01-28 | US | Tennessee | Scott | 47151 | 7707 | 98 | 0 | 36.42325673 | -84.50360494 | 2022-01-29 04:21:10 | Scott, Tennessee, US | |
1320875 | 1320875 | 2022-01-26 | US | Pennsylvania | Clarion | 42031 | 7707 | 184 | 0 | 41.19265812 | -79.42413524 | 2022-01-27 04:21:19 | Clarion, Pennsylvania, US | |
1229725 | 1229725 | 2022-01-24 | US | Nebraska | Platte | 31141 | 7707 | 50 | 0 | 41.57246836 | -97.52144359 | 2022-01-25 04:21:05 | Platte, Nebraska, US | |
127287 | 127287 | 2022-01-09 | US | California | Lake | 6033 | 7707 | 117 | 0 | 39.10124298 | -122.75362439999999 | 2022-01-10 04:22:07 | Lake, California, US | |
1703202 | 1703202 | 2022-01-03 | US | South Dakota | Brown | 46013 | 7707 | 108 | 0 | 45.58994323 | -98.35165355 | 2022-01-04 04:22:17 | Brown, South Dakota, US | |
799415 | 799415 | 2021-12-22 | US | Illinois | Effingham | 17049 | 7707 | 113 | 0 | 39.05935711 | -88.58969584 | 2021-12-23 04:21:21 | Effingham, Illinois, US | |
1718814 | 1718814 | 2021-12-16 | US | Ohio | Defiance | 39039 | 7707 | 131 | 0 | 41.32398837 | -84.49076944 | 2021-12-17 04:22:14 | Defiance, Ohio, US | |
1741639 | 1741639 | 2021-12-05 | US | Indiana | Jackson | 18071 | 7707 | 93 | 0 | 38.90915820000001 | -86.03851889 | 2021-12-06 04:22:34 | Jackson, Indiana, US | |
139071 | 139071 | 2021-12-04 | US | Indiana | Jackson | 18071 | 7707 | 93 | 0 | 38.90915820000001 | -86.03851889 | 2021-12-05 04:22:25 | Jackson, Indiana, US | |
2198299 | 2198299 | 2021-12-03 | US | Pennsylvania | Huntingdon | 42061 | 7707 | 181 | 0 | 40.42162652 | -77.97673273 | 2021-12-04 04:22:18 | Huntingdon, Pennsylvania, US | |
2196724 | 2196724 | 2021-12-03 | US | Indiana | Jackson | 18071 | 7707 | 93 | 0 | 38.90915820000001 | -86.03851889 | 2021-12-04 04:22:18 | Jackson, Indiana, US | |
3404276 | 3404276 | 2021-11-30 | US | South Carolina | Newberry | 45071 | 7707 | 148 | 0 | 34.28629098 | -81.59935761 | 2021-12-01 04:22:29 | Newberry, South Carolina, US | |
88198 | 88198 | 2021-11-09 | US | Indiana | Cass | 18017 | 7707 | 125 | 0 | 40.76135835 | -86.34830753 | 2021-11-10 04:21:38 | Cass, Indiana, US | |
3010609 | 3010609 | 2021-10-11 | US | Utah | TriCounty | 7707 | 62 | 0 | 40.12491499 | -109.5174415 | 2021-10-12 04:21:09 | TriCounty, Utah, US | ||
426625 | 426625 | 2021-10-10 | US | Utah | TriCounty | 7707 | 62 | 0 | 40.12491499 | -109.5174415 | 2021-10-11 04:21:31 | TriCounty, Utah, US | ||
2879482 | 2879482 | 2021-10-09 | US | Utah | TriCounty | 7707 | 62 | 0 | 40.12491499 | -109.5174415 | 2021-10-10 04:21:38 | TriCounty, Utah, US | ||
2962648 | 2962648 | 2021-10-08 | US | Utah | TriCounty | 7707 | 62 | 0 | 40.12491499 | -109.5174415 | 2021-10-09 04:21:34 | TriCounty, Utah, US | ||
2960791 | 2960791 | 2021-10-08 | US | Kentucky | Hopkins | 21107 | 7707 | 189 | 0 | 37.30939025 | -87.54670406 | 2021-10-09 04:21:34 | Hopkins, Kentucky, US | |
1336517 | 1336517 | 2021-09-28 | US | New York | Jefferson | 36045 | 7707 | 71 | 0 | 44.04200959 | -75.94653457 | 2021-09-29 04:21:45 | Jefferson, New York, US | |
1376046 | 1376046 | 2021-09-15 | US | Maine | Kennebec | 23011 | 7707 | 87 | 0 | 44.40759555 | -69.76738544 | 2021-09-16 04:22:19 | Kennebec, Maine, US | |
334731 | 334731 | 2021-08-04 | US | South Carolina | Laurens | 45059 | 7707 | 172 | 0 | 34.48244419 | -82.00490796 | 2021-08-05 04:21:51 | Laurens, South Carolina, US | |
3017710 | 3017710 | 2021-08-01 | US | North Carolina | Rutherford | 37161 | 7707 | 222 | 0 | 35.40114178 | -81.92112099 | 2021-08-02 04:21:36 | Rutherford, North Carolina, US | |
3906333 | 3906333 | 2021-07-31 | US | North Carolina | Rutherford | 37161 | 7707 | 222 | 0 | 35.40114178 | -81.92112099 | 2021-08-01 04:21:50 | Rutherford, North Carolina, US | |
3298538 | 3298538 | 2021-07-30 | US | North Carolina | Rutherford | 37161 | 7707 | 222 | 0 | 35.40114178 | -81.92112099 | 2021-07-31 04:21:35 | Rutherford, North Carolina, US | |
3219996 | 3219996 | 2021-07-26 | US | Minnesota | Blue Earth | 27013 | 7707 | 44 | 0 | 44.03554215 | -94.06699781 | 2021-07-27 04:21:18 | Blue Earth, Minnesota, US | |
2675317 | 2675317 | 2021-07-18 | US | Louisiana | Iberia | 22045 | 7707 | 166 | 0 | 29.86803617 | -91.75871777 | 2021-07-19 04:21:24 | Iberia, Louisiana, US | |
3707629 | 3707629 | 2021-07-17 | US | Louisiana | Iberia | 22045 | 7707 | 166 | 0 | 29.86803617 | -91.75871777 | 2021-07-18 04:22:07 | Iberia, Louisiana, US | |
2948860 | 2948860 | 2021-07-16 | US | Louisiana | Iberia | 22045 | 7707 | 166 | 0 | 29.86803617 | -91.75871777 | 2021-07-17 04:22:22 | Iberia, Louisiana, US | |
3362198 | 3362198 | 2021-06-21 | US | Wisconsin | Chippewa | 55017 | 7707 | 96 | 0 | 45.06939744 | -91.28068855 | 2021-06-22 04:21:34 | Chippewa, Wisconsin, US | |
2719994 | 2719994 | 2021-06-10 | US | Texas | Bowie | 48037 | 7707 | 222 | 0 | 33.44626922 | -94.41834132 | 2021-06-11 04:23:20 | Bowie, Texas, US | |
525879 | 525879 | 2021-06-09 | US | Texas | Bowie | 48037 | 7707 | 222 | 0 | 33.44626922 | -94.41834132 | 2021-06-10 04:23:17 | Bowie, Texas, US | |
3091642 | 3091642 | 2021-05-30 | US | New York | Chemung | 36015 | 7707 | 135 | 0 | 42.13891056 | -76.7638805 | 2021-05-31 03:08:59 | Chemung, New York, US | |
2392564 | 2392564 | 2021-05-18 | US | Mississippi | Forrest | 28035 | 7707 | 152 | 0 | 31.18961454 | -89.25832496 | 2021-05-19 04:20:42 | Forrest, Mississippi, US | |
2940187 | 2940187 | 2021-05-16 | US | Georgia | Rockdale | 13247 | 7707 | 171 | 0 | 33.65145002 | -84.02202167 | 2021-05-17 04:20:34 | Rockdale, Georgia, US | |
1428464 | 1428464 | 2021-05-09 | US | Virginia | Lynchburg | 51680 | 7707 | 147 | 0 | 37.40021399 | -79.19888138 | 2021-05-10 04:20:38 | Lynchburg, Virginia, US | |
3701955 | 3701955 | 2021-04-27 | Colombia | Choco | 7707 | 216 | 7203 | 288 | 5.2528 | -76.82600000000002 | 2021-04-28 04:20:32 | Choco, Colombia | ||
891268 | 891268 | 2021-04-26 | US | Texas | Liberty | 48291 | 7707 | 179 | 0 | 30.15152688 | -94.81205615 | 2021-04-27 04:20:52 | Liberty, Texas, US | |
890192 | 890192 | 2021-04-26 | US | Nebraska | Hall | 31079 | 7707 | 117 | 0 | 40.87257079 | -98.50218293 | 2021-04-27 04:20:52 | Hall, Nebraska, US | |
888857 | 888857 | 2021-04-26 | US | Florida | Walton | 12131 | 7707 | 87 | 0 | 30.64204028 | -86.16935664 | 2021-04-27 04:20:52 | Walton, Florida, US | |
1412376 | 1412376 | 2021-04-23 | US | Virginia | Frederick | 51069 | 7707 | 97 | 0 | 39.20172582 | -78.25974949 | 2021-04-24 04:20:38 | Frederick, Virginia, US | |
2024130 | 2024130 | 2021-04-20 | US | Virginia | Suffolk | 51800 | 7707 | 182 | 0 | 36.70155394 | -76.63603554 | 2021-04-21 04:21:14 | Suffolk, Virginia, US | |
1844598 | 1844598 | 2021-04-14 | US | Pennsylvania | Clearfield | 42033 | 7707 | 131 | 0 | 41.00110782 | -78.47592663 | 2021-04-15 04:20:54 | Clearfield, Pennsylvania, US | |
1884378 | 1884378 | 2021-03-26 | US | Virginia | Roanoke | 51161 | 7707 | 125 | 0 | 37.26865804 | -80.06396753 | 2021-03-27 05:25:04 | Roanoke, Virginia, US | |
3455492 | 3455492 | 2021-03-18 | US | Pennsylvania | Adams | 42001 | 7707 | 157 | 0 | 39.87140411 | -77.21610347 | 2021-03-19 05:26:09 | Adams, Pennsylvania, US | |
3621607 | 3621607 | 2021-03-17 | US | Arkansas | White | 5145 | 7707 | 115 | 0 | 35.25688493 | -91.74908296 | 2021-03-18 05:26:22 | White, Arkansas, US | |
1618870 | 1618870 | 2021-03-05 | US | Oregon | Umatilla | 41059 | 7707 | 82 | 0 | 7625 | 45.59073056 | -118.7353826 | 2021-03-06 04:23:41 | Umatilla, Oregon, US |
1762965 | 1762965 | 2021-01-24 | China | Unknown | 7707 | 0 | 0 | 0 | 2021-01-25 05:22:16 | Unknown, China | ||||
2467849 | 2467849 | 2021-01-22 | US | Illinois | Vermilion | 17183 | 7707 | 98 | 0 | 7609 | 40.18417171 | -87.73384359 | 2021-01-23 05:22:03 | Vermilion, Illinois, US |
2934845 | 2934845 | 2020-12-19 | Ukraine | Kirovohrad Oblast | 7707 | 223 | 3207 | 4277 | 48.5079 | 32.2623 | 2020-12-20 05:27:32 | Kirovohrad Oblast, Ukraine | ||
2937594 | 2937594 | 2020-11-28 | US | North Carolina | Union | 37179 | 7707 | 73 | 0 | 7634 | 34.98960527 | -80.52955873 | 2020-11-29 05:25:55 | Union, North Carolina, US |
1972665 | 1972665 | 2020-11-25 | Mexico | Chiapas | 7707 | 1172 | 0 | 6535 | 16.7569 | -93.1292 | 2020-11-26 05:27:44 | Chiapas, Mexico | ||
2915993 | 2915993 | 2020-11-14 | US | Georgia | Henry | 13151 | 7707 | 131 | 0 | 7576 | 33.4533428 | -84.14814659999998 | 2020-11-15 05:26:53 | Henry, Georgia, US |
1544126 | 1544126 | 2020-11-07 | Russia | Amur Oblast | 7707 | 68 | 6060 | 1579 | 52.8032368 | 128.437295 | 2020-11-08 05:24:56 | Amur Oblast, Russia | ||
2498593 | 2498593 | 2020-11-03 | US | California | Solano | 6095 | 7707 | 85 | 0 | 7624 | 38.26827353 | -121.9357113 | 2020-11-04 05:25:09 | Solano, California, US |
2858639 | 2858639 | 2020-10-16 | US | Mississippi | Hinds | 28049 | 7707 | 170 | 0 | 7537 | 32.2656285 | -90.44435448 | 2020-10-17 04:24:12 | Hinds, Mississippi, US |
3531636 | 3531636 | 2020-08-12 | Russia | Bryansk Oblast | 7707 | 35 | 6293 | 1379 | 52.8873315 | 33.41585300000001 | 2020-08-13 04:29:15 | Bryansk Oblast, Russia | ||
2955123 | 2955123 | 2020-07-29 | US | Pennsylvania | Allegheny | 42003 | 7707 | 227 | 0 | 7480 | 40.46809875 | -79.98167747 | 2020-07-30 04:35:05 | Allegheny, Pennsylvania, US |
2306355 | 2306355 | 2020-06-28 | Russia | Dagestan Republic | 7707 | 371 | 5615 | 1721 | 43.05749160000001 | 47.1332224 | 2020-06-29 04:33:44 | Dagestan Republic, Russia |
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]);