johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
93 rows where confirmed = 7247 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
712724 | 712724 | 2022-11-01 | US | New York | Seneca | 36099 | 7247 | 94 | 0 | 42.78081007 | -76.82497064 | 2022-11-02 04:22:09 | Seneca, New York, US | |
3101043 | 3101043 | 2022-10-09 | US | Wisconsin | Waushara | 55137 | 7247 | 88 | 0 | 44.11324419 | -89.24317107 | 2022-10-10 04:22:32 | Waushara, Wisconsin, US | |
4006268 | 4006268 | 2022-10-08 | US | Wisconsin | Waushara | 55137 | 7247 | 88 | 0 | 44.11324419 | -89.24317107 | 2022-10-09 04:21:16 | Waushara, Wisconsin, US | |
399865 | 399865 | 2022-10-07 | US | Wisconsin | Waushara | 55137 | 7247 | 88 | 0 | 44.11324419 | -89.24317107 | 2022-10-08 04:22:56 | Waushara, Wisconsin, US | |
398985 | 398985 | 2022-10-07 | US | Puerto Rico | Aguas Buenas | 72007 | 7247 | 0 | 0 | 18.251619 | -66.126806 | 2022-10-08 04:22:56 | Aguas Buenas, Puerto Rico, US | |
133732 | 133732 | 2022-10-04 | US | Tennessee | Morgan | 47129 | 7247 | 92 | 0 | 36.13248031 | -84.64880098 | 2022-10-05 04:23:06 | Morgan, Tennessee, US | |
2990653 | 2990653 | 2022-09-04 | US | Virginia | Lee | 51105 | 7247 | 97 | 0 | 36.70586667 | -83.12606515 | 2022-09-05 04:21:01 | Lee, Virginia, US | |
2716338 | 2716338 | 2022-09-03 | US | Virginia | Lee | 51105 | 7247 | 97 | 0 | 36.70586667 | -83.12606515 | 2022-09-04 04:21:22 | Lee, Virginia, US | |
1397043 | 1397043 | 2022-09-02 | US | Virginia | Lee | 51105 | 7247 | 97 | 0 | 36.70586667 | -83.12606515 | 2022-09-03 04:21:04 | Lee, Virginia, US | |
3549066 | 3549066 | 2022-09-01 | US | Maine | Knox | 23013 | 7247 | 41 | 0 | 44.11486325 | -69.10529169 | 2022-09-02 04:21:07 | Knox, Maine, US | |
2495559 | 2495559 | 2022-08-15 | US | Louisiana | Plaquemines | 22075 | 7247 | 47 | 0 | 29.42245447 | -89.60322085 | 2022-08-16 04:20:58 | Plaquemines, Louisiana, US | |
1608917 | 1608917 | 2022-07-20 | US | Colorado | Routt | 8107 | 7247 | 30 | 0 | 40.48596505 | -106.9905548 | 2022-07-21 04:21:10 | Routt, Colorado, US | |
3432159 | 3432159 | 2022-07-14 | US | Texas | Palo Pinto | 48363 | 7247 | 154 | 0 | 32.75310985 | -98.31319001 | 2022-07-15 04:20:53 | Palo Pinto, Texas, US | |
630698 | 630698 | 2022-07-12 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-13 04:20:58 | Dawson, Georgia, US | |
1214960 | 1214960 | 2022-07-11 | US | Virginia | Russell | 51167 | 7247 | 116 | 0 | 36.9302832 | -82.10095486 | 2022-07-12 04:20:51 | Russell, Virginia, US | |
1212342 | 1212342 | 2022-07-11 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-12 04:20:51 | Dawson, Georgia, US | |
2789824 | 2789824 | 2022-07-10 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-11 04:20:46 | Dawson, Georgia, US | |
142777 | 142777 | 2022-07-09 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-10 04:20:54 | Dawson, Georgia, US | |
1417877 | 1417877 | 2022-07-08 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-09 04:20:59 | Dawson, Georgia, US | |
2741802 | 2741802 | 2022-07-07 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-08 04:20:56 | Dawson, Georgia, US | |
1200597 | 1200597 | 2022-07-06 | US | Georgia | Dawson | 13085 | 7247 | 101 | 0 | 34.44244079 | -84.16964071 | 2022-07-07 04:20:55 | Dawson, Georgia, US | |
948588 | 948588 | 2022-06-14 | US | Minnesota | Lyon | 27083 | 7247 | 74 | 0 | 44.41327865 | -95.83806103 | 2022-06-15 04:20:54 | Lyon, Minnesota, US | |
2238910 | 2238910 | 2022-06-12 | US | West Virginia | Wyoming | 54109 | 7247 | 119 | 0 | 37.612327 | -81.54511071 | 2022-06-13 04:21:14 | Wyoming, West Virginia, US | |
3145108 | 3145108 | 2022-06-11 | US | West Virginia | Wyoming | 54109 | 7247 | 119 | 0 | 37.612327 | -81.54511071 | 2022-06-12 04:20:53 | Wyoming, West Virginia, US | |
1948024 | 1948024 | 2022-06-10 | US | West Virginia | Wyoming | 54109 | 7247 | 119 | 0 | 37.612327 | -81.54511071 | 2022-06-11 04:21:01 | Wyoming, West Virginia, US | |
1424361 | 1424361 | 2022-06-08 | US | Texas | Willacy | 48489 | 7247 | 131 | 0 | 26.47411727 | -97.61535848 | 2022-06-09 04:20:54 | Willacy, Texas, US | |
2727744 | 2727744 | 2022-05-28 | US | Puerto Rico | Cabo Rojo | 72023 | 7247 | 0 | 0 | 18.040993 | -67.154391 | 2022-05-29 04:20:53 | Cabo Rojo, Puerto Rico, US | |
2533185 | 2533185 | 2022-05-12 | China | Guangdong | 7247 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-13 04:20:51 | Guangdong, China | |||
3538505 | 3538505 | 2022-05-10 | US | Texas | Cass | 48067 | 7247 | 196 | 0 | 33.07499881 | -94.34646905 | 2022-05-11 04:20:48 | Cass, Texas, US | |
2332316 | 2332316 | 2022-05-08 | US | Idaho | Elmore | 16039 | 7247 | 70 | 0 | 43.3507101 | -115.4701578 | 2022-05-09 04:20:54 | Elmore, Idaho, US | |
361278 | 361278 | 2022-05-07 | US | Idaho | Elmore | 16039 | 7247 | 70 | 0 | 43.3507101 | -115.4701578 | 2022-05-08 04:20:49 | Elmore, Idaho, US | |
1398629 | 1398629 | 2022-05-06 | US | Idaho | Elmore | 16039 | 7247 | 70 | 0 | 43.3507101 | -115.4701578 | 2022-05-07 04:21:09 | Elmore, Idaho, US | |
2599047 | 2599047 | 2022-05-05 | US | Illinois | Iroquois | 17075 | 7247 | 116 | 0 | 40.74717633 | -87.82466784 | 2022-05-06 04:21:00 | Iroquois, Illinois, US | |
3268620 | 3268620 | 2022-05-04 | US | Texas | Hopkins | 48223 | 7247 | 178 | 0 | 33.14875072 | -95.56351139 | 2022-05-05 04:20:55 | Hopkins, Texas, US | |
3725349 | 3725349 | 2022-04-25 | US | Texas | Kleberg | 48273 | 7247 | 147 | 0 | 27.42435506 | -97.69894948 | 2022-04-26 04:20:51 | Kleberg, Texas, US | |
2031917 | 2031917 | 2022-04-24 | US | Texas | Kleberg | 48273 | 7247 | 147 | 0 | 27.42435506 | -97.69894948 | 2022-04-25 04:20:56 | Kleberg, Texas, US | |
749492 | 749492 | 2022-04-23 | US | Texas | Kleberg | 48273 | 7247 | 147 | 0 | 27.42435506 | -97.69894948 | 2022-04-24 04:20:56 | Kleberg, Texas, US | |
3419668 | 3419668 | 2022-04-17 | US | Puerto Rico | Humacao | 72069 | 7247 | 0 | 0 | 18.145211 | -65.810174 | 2022-04-18 04:21:12 | Humacao, Puerto Rico, US | |
1908256 | 1908256 | 2022-03-22 | US | Texas | Cooke | 48097 | 7247 | 131 | 0 | 33.63979567 | -97.21240912 | 2022-03-23 04:20:48 | Cooke, Texas, US | |
27759 | 27759 | 2022-03-20 | US | Virginia | Isle of Wight | 51093 | 7247 | 109 | 0 | 36.90579348 | -76.70842863 | 2022-03-21 04:20:50 | Isle of Wight, Virginia, US | |
1659769 | 1659769 | 2022-03-19 | US | Virginia | Isle of Wight | 51093 | 7247 | 109 | 0 | 36.90579348 | -76.70842863 | 2022-03-20 04:20:45 | Isle of Wight, Virginia, US | |
339295 | 339295 | 2022-03-18 | US | Virginia | Isle of Wight | 51093 | 7247 | 109 | 0 | 36.90579348 | -76.70842863 | 2022-03-19 04:20:47 | Isle of Wight, Virginia, US | |
2141239 | 2141239 | 2022-03-09 | US | Indiana | Adams | 18001 | 7247 | 111 | 0 | 40.7457653 | -84.93671406 | 2022-03-10 04:20:48 | Adams, Indiana, US | |
1647671 | 1647671 | 2022-03-03 | US | Virginia | Botetourt | 51023 | 7247 | 93 | 0 | 37.55531756 | -79.80982182 | 2022-03-04 04:21:09 | Botetourt, Virginia, US | |
3719690 | 3719690 | 2022-02-21 | US | Louisiana | East Feliciana | 22037 | 7247 | 162 | 0 | 30.84425359 | -91.04976723 | 2022-02-22 04:21:01 | East Feliciana, Louisiana, US | |
187896 | 187896 | 2022-02-13 | US | Mississippi | Leflore | 28083 | 7247 | 160 | 0 | 33.55545125 | -90.29900733 | 2022-02-14 04:20:51 | Leflore, Mississippi, US | |
317742 | 317742 | 2022-02-12 | US | Mississippi | Leflore | 28083 | 7247 | 160 | 0 | 33.55545125 | -90.29900733 | 2022-02-13 04:21:00 | Leflore, Mississippi, US | |
235068 | 235068 | 2022-02-11 | US | Mississippi | Leflore | 28083 | 7247 | 160 | 0 | 33.55545125 | -90.29900733 | 2022-02-12 04:21:06 | Leflore, Mississippi, US | |
2475362 | 2475362 | 2022-02-03 | US | Kentucky | Grayson | 21085 | 7247 | 115 | 0 | 37.46231118 | -86.34248968 | 2022-02-04 04:21:10 | Grayson, Kentucky, US | |
1141280 | 1141280 | 2022-01-23 | US | Alabama | Dallas | 1047 | 7247 | 218 | 0 | 32.32688101 | -87.10866709999998 | 2022-01-24 04:21:12 | Dallas, Alabama, US | |
3227418 | 3227418 | 2022-01-19 | US | Illinois | Bureau | 17011 | 7247 | 115 | 0 | 41.40385234 | -89.5283051 | 2022-01-20 04:21:07 | Bureau, Illinois, US | |
3614526 | 3614526 | 2022-01-12 | US | Kentucky | Perry | 21193 | 7247 | 134 | 0 | 37.25023553 | -83.22922731 | 2022-01-13 08:00:09 | Perry, Kentucky, US | |
1257141 | 1257141 | 2021-12-20 | US | North Carolina | Stokes | 37169 | 7247 | 119 | 0 | 36.4017975 | -80.23893369 | 2021-12-21 03:21:27 | Stokes, North Carolina, US | |
2904717 | 2904717 | 2021-12-19 | US | Illinois | Jefferson | 17081 | 7247 | 148 | 0 | 38.29980057 | -88.9240025 | 2021-12-20 04:21:43 | Jefferson, Illinois, US | |
1259790 | 1259790 | 2021-12-18 | US | Illinois | Jefferson | 17081 | 7247 | 148 | 0 | 38.29980057 | -88.9240025 | 2021-12-19 04:21:11 | Jefferson, Illinois, US | |
2399818 | 2399818 | 2021-12-17 | US | Illinois | Jefferson | 17081 | 7247 | 148 | 0 | 38.29980057 | -88.9240025 | 2021-12-18 02:22:20 | Jefferson, Illinois, US | |
2089069 | 2089069 | 2021-12-14 | US | Indiana | Harrison | 18061 | 7247 | 102 | 0 | 38.19467379 | -86.10948271 | 2021-12-15 03:22:16 | Harrison, Indiana, US | |
140436 | 140436 | 2021-12-04 | US | Ohio | Fulton | 39051 | 7247 | 129 | 0 | 41.60213491 | -84.12571393 | 2021-12-05 04:22:25 | Fulton, Ohio, US | |
1380 | 1380 | 2021-12-02 | US | Illinois | Stephenson | 17177 | 7247 | 106 | 0 | 42.35129217 | -89.662598 | 2021-12-03 04:23:05 | Stephenson, Illinois, US | |
3292274 | 3292274 | 2021-11-18 | US | Virginia | James City | 51095 | 7247 | 95 | 0 | 37.31156958 | -76.76950618 | 2021-11-19 04:21:40 | James City, Virginia, US | |
2002086 | 2002086 | 2021-11-07 | US | Kentucky | Knox | 21121 | 7247 | 54 | 0 | 36.89225732 | -83.85403396 | 2021-11-08 04:21:43 | Knox, Kentucky, US | |
3123748 | 3123748 | 2021-11-05 | US | New York | Herkimer | 36043 | 7247 | 132 | 0 | 43.42034246 | -74.96145307 | 2021-11-06 04:21:51 | Herkimer, New York, US | |
3122913 | 3122913 | 2021-11-05 | US | Kentucky | Graves | 21083 | 7247 | 126 | 0 | 36.72292505 | -88.65143315 | 2021-11-06 04:21:51 | Graves, Kentucky, US | |
701947 | 701947 | 2021-11-04 | US | Wisconsin | Dunn | 55033 | 7247 | 47 | 0 | 44.94562799 | -91.8962481 | 2021-11-05 04:21:54 | Dunn, Wisconsin, US | |
3511959 | 3511959 | 2021-11-01 | US | California | Lassen | 6035 | 7247 | 45 | 0 | 40.67311306 | -120.59350990000002 | 2021-11-02 04:22:03 | Lassen, California, US | |
1238779 | 1238779 | 2021-09-27 | US | Texas | Jim Wells | 48249 | 7247 | 158 | 0 | 27.73103938 | -98.0904705 | 2021-09-28 04:21:28 | Jim Wells, Texas, US | |
2079080 | 2079080 | 2021-09-26 | US | Texas | Jim Wells | 48249 | 7247 | 158 | 0 | 27.73103938 | -98.0904705 | 2021-09-27 04:21:16 | Jim Wells, Texas, US | |
34125 | 34125 | 2021-08-25 | US | Minnesota | Crow Wing | 27035 | 7247 | 100 | 0 | 46.48096553 | -94.06755609 | 2021-08-26 04:21:28 | Crow Wing, Minnesota, US | |
510190 | 510190 | 2021-08-14 | US | Ohio | Ross | 39141 | 7247 | 167 | 0 | 39.33705391 | -83.06000914 | 2021-08-15 04:21:41 | Ross, Ohio, US | |
333910 | 333910 | 2021-08-04 | US | Montana | Lewis and Clark | 30049 | 7247 | 93 | 0 | 47.12610041 | -112.394698 | 2021-08-05 04:21:51 | Lewis and Clark, Montana, US | |
409678 | 409678 | 2021-07-28 | US | Kentucky | Christian | 21047 | 7247 | 108 | 0 | 36.89267803 | -87.49055367 | 2021-07-29 04:21:33 | Christian, Kentucky, US | |
400606 | 400606 | 2021-06-29 | US | Alabama | Autauga | 1001 | 7247 | 113 | 0 | 32.53952745 | -86.64408227 | 2021-06-30 04:21:41 | Autauga, Alabama, US | |
3125849 | 3125849 | 2021-06-28 | US | Alabama | Autauga | 1001 | 7247 | 113 | 0 | 32.53952745 | -86.64408227 | 2021-06-29 04:21:28 | Autauga, Alabama, US | |
1428369 | 1428369 | 2021-05-09 | US | Utah | Tooele | 49045 | 7247 | 41 | 0 | 40.44862644 | -113.1295715 | 2021-05-10 04:20:38 | Tooele, Utah, US | |
1554217 | 1554217 | 2021-05-08 | US | New York | Ontario | 36069 | 7247 | 92 | 0 | 42.85145728 | -77.30874425 | 2021-05-09 04:20:35 | Ontario, New York, US | |
985768 | 985768 | 2021-04-17 | US | South Carolina | Kershaw | 45055 | 7247 | 135 | 0 | 34.33988254 | -80.58763164 | 2021-04-18 04:20:41 | Kershaw, South Carolina, US | |
3644431 | 3644431 | 2021-03-30 | US | Georgia | Troup | 13285 | 7247 | 212 | 0 | 33.03349196 | -85.02812115 | 2021-03-31 04:26:25 | Troup, Georgia, US | |
1539270 | 1539270 | 2021-03-28 | US | Virginia | Hanover | 51085 | 7247 | 147 | 0 | 37.7583355 | -77.49464673 | 2021-03-29 04:28:35 | Hanover, Virginia, US | |
352594 | 352594 | 2021-03-11 | Spain | Melilla | 7247 | 74 | 125 | 7048 | 35.2923 | -2.9381 | 2021-03-12 05:26:50 | Melilla, Spain | ||
3666421 | 3666421 | 2021-03-09 | US | South Carolina | Greenwood | 45047 | 7247 | 159 | 0 | 34.15272415 | -82.12715789 | 2021-03-10 05:24:35 | Greenwood, South Carolina, US | |
3257600 | 3257600 | 2021-03-02 | US | Washington | Thurston | 53067 | 7247 | 78 | 0 | 7169 | 46.9291895 | -122.8290656 | 2021-03-03 05:23:28 | Thurston, Washington, US |
2370430 | 2370430 | 2021-02-28 | US | Tennessee | Greene | 47059 | 7247 | 145 | 0 | 7138 | 36.17470125 | -82.84691273 | 2021-03-01 05:23:01 | Greene, Tennessee, US |
3309726 | 3309726 | 2021-01-13 | US | Louisiana | St. Landry | 22097 | 7247 | 210 | 0 | 7037 | 30.59724262 | -92.00135806 | 2021-01-14 05:22:32 | St. Landry, Louisiana, US |
3308507 | 3308507 | 2021-01-13 | Suriname | 7247 | 139 | 6477 | 631 | 3.9193 | -56.0278 | 2021-01-14 05:22:32 | Suriname | |||
2130973 | 2130973 | 2020-12-17 | US | Tennessee | Sevier | 47155 | 7247 | 54 | 0 | 7092 | 35.78077323 | -83.52244332 | 2020-12-18 05:28:18 | Sevier, Tennessee, US |
3151875 | 3151875 | 2020-12-16 | US | North Carolina | Buncombe | 37021 | 7247 | 136 | 0 | 7111 | 35.61113393 | -82.53305 | 2020-12-17 05:28:12 | Buncombe, North Carolina, US |
1819734 | 1819734 | 2020-12-08 | US | Idaho | Twin Falls | 16083 | 7247 | 101 | 0 | 7146 | 42.35440512 | -114.6685381 | 2020-12-09 05:28:01 | Twin Falls, Idaho, US |
3481552 | 3481552 | 2020-10-26 | US | Iowa | Woodbury | 19193 | 7247 | 97 | 0 | 7150 | 42.38979414 | -96.0459439 | 2020-10-27 04:24:45 | Woodbury, Iowa, US |
1559193 | 1559193 | 2020-08-16 | US | Texas | Webb | 48479 | 7247 | 198 | 0 | 9354 | 27.7610369 | -99.33237355 | 2020-08-17 04:27:20 | Webb, Texas, US |
1556671 | 1556671 | 2020-08-16 | US | Florida | Marion | 12083 | 7247 | 113 | 0 | 7134 | 29.21227113 | -82.05803627 | 2020-08-17 04:27:20 | Marion, Florida, US |
146163 | 146163 | 2020-08-15 | Russia | Chuvashia Republic | 7247 | 68 | 5114 | 2065 | 55.4259922 | 47.0849429 | 2020-08-16 04:27:42 | Chuvashia Republic, Russia | ||
3042828 | 3042828 | 2020-07-02 | US | Florida | Duval | 12031 | 7247 | 68 | 0 | 7179 | 30.33225875 | -81.66976468 | 2020-07-03 04:33:54 | Duval, Florida, US |
1209554 | 1209554 | 2020-06-09 | US | Louisiana | Orleans | 22071 | 7247 | 513 | 0 | 6734 | 30.06971951 | -89.92660315 | 2020-06-10 04:07:00 | Orleans, Louisiana, 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]);