johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94 rows where confirmed = 6811 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074556 | 1074556 | 2022-12-28 | US | Colorado | Morgan | 8087 | 6811 | 145 | 0 | 40.2627981 | -103.8093302 | 2022-12-29 04:21:01 | Morgan, Colorado, US | |
797245 | 797245 | 2022-10-24 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-25 04:21:53 | Jasper, South Carolina, US | |
3279700 | 3279700 | 2022-10-23 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-24 04:22:29 | Jasper, South Carolina, US | |
2270738 | 2270738 | 2022-10-22 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-23 04:22:46 | Jasper, South Carolina, US | |
1595038 | 1595038 | 2022-10-21 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-22 04:22:53 | Jasper, South Carolina, US | |
2274754 | 2274754 | 2022-10-20 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-21 04:22:23 | Jasper, South Carolina, US | |
201089 | 201089 | 2022-10-19 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-20 04:22:59 | Jasper, South Carolina, US | |
2759750 | 2759750 | 2022-10-18 | US | South Carolina | Jasper | 45053 | 6811 | 95 | 0 | 32.43171982 | -81.02487495 | 2022-10-19 04:22:26 | Jasper, South Carolina, US | |
3253482 | 3253482 | 2022-10-11 | US | Virginia | Dinwiddie | 51053 | 6811 | 101 | 0 | 37.07544585 | -77.63451754 | 2022-10-12 04:22:51 | Dinwiddie, Virginia, US | |
2018235 | 2018235 | 2022-09-20 | US | Louisiana | Grant | 22043 | 6811 | 95 | 0 | 31.59882456 | -92.56124347 | 2022-09-21 04:23:22 | Grant, Louisiana, US | |
2831534 | 2831534 | 2022-08-25 | US | Puerto Rico | Aibonito | 72009 | 6811 | 0 | 0 | 18.131361 | -66.264131 | 2022-08-26 04:21:02 | Aibonito, Puerto Rico, US | |
3953090 | 3953090 | 2022-08-17 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-18 04:21:11 | Seminole, Oklahoma, US | |
993592 | 993592 | 2022-08-16 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-17 04:20:59 | Seminole, Oklahoma, US | |
2496631 | 2496631 | 2022-08-15 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-16 04:20:58 | Seminole, Oklahoma, US | |
3650181 | 3650181 | 2022-08-14 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-15 04:20:59 | Seminole, Oklahoma, US | |
1971187 | 1971187 | 2022-08-13 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-14 04:20:55 | Seminole, Oklahoma, US | |
2890996 | 2890996 | 2022-08-12 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-13 04:20:52 | Seminole, Oklahoma, US | |
3910601 | 3910601 | 2022-08-11 | US | Oklahoma | Seminole | 40133 | 6811 | 136 | 0 | 35.16478725 | -96.61686741 | 2022-08-12 04:20:54 | Seminole, Oklahoma, US | |
2792141 | 2792141 | 2022-07-10 | US | Texas | Hale | 48189 | 6811 | 245 | 0 | 34.07044901 | -101.8268114 | 2022-07-11 04:20:46 | Hale, Texas, US | |
1649904 | 1649904 | 2022-06-23 | US | Louisiana | Plaquemines | 22075 | 6811 | 46 | 0 | 29.42245447 | -89.60322085 | 2022-06-24 04:20:58 | Plaquemines, Louisiana, US | |
560375 | 560375 | 2022-06-16 | US | Maine | Waldo | 23027 | 6811 | 61 | 0 | 44.4858305 | -69.12061935 | 2022-06-17 04:20:56 | Waldo, Maine, US | |
3890347 | 3890347 | 2022-06-06 | US | Puerto Rico | Camuy | 72027 | 6811 | 0 | 0 | 18.418578 | -66.860206 | 2022-06-07 04:21:08 | Camuy, Puerto Rico, US | |
973442 | 973442 | 2022-06-01 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-06-02 05:20:39 | Van Wert, Ohio, US | |
231974 | 231974 | 2022-05-31 | US | Puerto Rico | Hatillo | 72065 | 6811 | 0 | 0 | 18.410928 | -66.796326 | 2022-06-01 04:20:55 | Hatillo, Puerto Rico, US | |
231749 | 231749 | 2022-05-31 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-06-01 04:20:55 | Van Wert, Ohio, US | |
3188514 | 3188514 | 2022-05-30 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-05-31 04:20:51 | Van Wert, Ohio, US | |
3200663 | 3200663 | 2022-05-29 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-05-30 04:20:50 | Van Wert, Ohio, US | |
2727541 | 2727541 | 2022-05-28 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-05-29 04:20:53 | Van Wert, Ohio, US | |
1316722 | 1316722 | 2022-05-27 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-05-28 04:21:07 | Van Wert, Ohio, US | |
1852514 | 1852514 | 2022-05-26 | US | Ohio | Van Wert | 39161 | 6811 | 148 | 0 | 40.8554138 | -84.591117 | 2022-05-27 04:20:56 | Van Wert, Ohio, US | |
3538403 | 3538403 | 2022-05-10 | US | Tennessee | Grainger | 47057 | 6811 | 110 | 0 | 36.27469206 | -83.51254721 | 2022-05-11 04:20:48 | Grainger, Tennessee, US | |
3731110 | 3731110 | 2022-04-03 | US | Georgia | Sumter | 13261 | 6811 | 165 | 0 | 32.03650571 | -84.19821492 | 2022-04-04 04:20:51 | Sumter, Georgia, US | |
500545 | 500545 | 2022-04-02 | US | Georgia | Sumter | 13261 | 6811 | 165 | 0 | 32.03650571 | -84.19821492 | 2022-04-03 04:20:48 | Sumter, Georgia, US | |
3351530 | 3351530 | 2022-04-01 | US | Georgia | Sumter | 13261 | 6811 | 165 | 0 | 32.03650571 | -84.19821492 | 2022-04-02 04:20:47 | Sumter, Georgia, US | |
2481491 | 2481491 | 2022-03-30 | US | West Virginia | Upshur | 54097 | 6811 | 92 | 0 | 38.89285061 | -80.23689136 | 2022-03-31 04:20:56 | Upshur, West Virginia, US | |
2141880 | 2141880 | 2022-03-09 | US | Minnesota | Cass | 27021 | 6811 | 79 | 0 | 46.95043611 | -94.32603968 | 2022-03-10 04:20:48 | Cass, Minnesota, US | |
1549047 | 1549047 | 2022-03-07 | US | Indiana | Clay | 18021 | 6811 | 84 | 0 | 39.39561833 | -87.11723506 | 2022-03-08 04:20:54 | Clay, Indiana, US | |
943622 | 943622 | 2022-02-28 | US | Georgia | Dawson | 13085 | 6811 | 97 | 0 | 34.44244079 | -84.16964071 | 2022-03-01 04:21:09 | Dawson, Georgia, US | |
72172 | 72172 | 2022-02-07 | US | Indiana | Decatur | 18031 | 6811 | 126 | 0 | 39.30712658 | -85.50087166 | 2022-02-08 04:21:15 | Decatur, Indiana, US | |
3843993 | 3843993 | 2022-01-15 | US | West Virginia | Greenbrier | 54025 | 6811 | 123 | 0 | 37.9463652 | -80.45335881 | 2022-01-16 04:21:12 | Greenbrier, West Virginia, US | |
1218228 | 1218228 | 2022-01-08 | US | Pennsylvania | Clarion | 42031 | 6811 | 178 | 0 | 41.19265812 | -79.42413524 | 2022-01-09 04:21:46 | Clarion, Pennsylvania, US | |
1435378 | 1435378 | 2021-12-28 | US | South Carolina | Chester | 45023 | 6811 | 123 | 0 | 34.69249168 | -81.1583216 | 2021-12-29 03:21:43 | Chester, South Carolina, US | |
733339 | 733339 | 2021-12-27 | US | South Carolina | Chester | 45023 | 6811 | 123 | 0 | 34.69249168 | -81.1583216 | 2021-12-28 04:21:47 | Chester, South Carolina, US | |
2114511 | 2114511 | 2021-12-26 | US | South Carolina | Chester | 45023 | 6811 | 123 | 0 | 34.69249168 | -81.1583216 | 2021-12-27 04:21:58 | Chester, South Carolina, US | |
3607883 | 3607883 | 2021-12-25 | US | South Carolina | Chester | 45023 | 6811 | 123 | 0 | 34.69249168 | -81.1583216 | 2021-12-26 04:21:50 | Chester, South Carolina, US | |
2966201 | 2966201 | 2021-12-24 | US | South Carolina | Chester | 45023 | 6811 | 123 | 0 | 34.69249168 | -81.1583216 | 2021-12-25 04:21:37 | Chester, South Carolina, US | |
3819233 | 3819233 | 2021-12-23 | US | South Carolina | Chester | 45023 | 6811 | 123 | 0 | 34.69249168 | -81.1583216 | 2021-12-24 04:21:34 | Chester, South Carolina, US | |
3496940 | 3496940 | 2021-12-15 | US | Georgia | Baldwin | 13009 | 6811 | 199 | 0 | 33.06882326 | -83.24701748 | 2021-12-16 04:22:11 | Baldwin, Georgia, US | |
907588 | 907588 | 2021-11-24 | US | Virginia | Shenandoah | 51171 | 6811 | 171 | 0 | 38.85905135 | -78.56813762 | 2021-11-25 04:22:33 | Shenandoah, Virginia, US | |
3640538 | 3640538 | 2021-11-08 | US | Illinois | Effingham | 17049 | 6811 | 102 | 0 | 39.05935711 | -88.58969584 | 2021-11-09 04:21:36 | Effingham, Illinois, US | |
700707 | 700707 | 2021-11-04 | US | North Carolina | Chatham | 37037 | 6811 | 91 | 0 | 35.70394416 | -79.25541492 | 2021-11-05 04:21:54 | Chatham, North Carolina, US | |
44062 | 44062 | 2021-11-02 | US | Alabama | Chilton | 1021 | 6811 | 164 | 0 | 32.85044126 | -86.7173256 | 2021-11-03 06:22:09 | Chilton, Alabama, US | |
1277582 | 1277582 | 2021-10-03 | US | Virgin Islands | 78 | 6811 | 71 | 0 | 18.3358 | -64.8963 | 2021-10-04 04:21:31 | Virgin Islands, US | ||
3931335 | 3931335 | 2021-10-02 | US | Virgin Islands | 78 | 6811 | 71 | 0 | 18.3358 | -64.8963 | 2021-10-03 04:21:24 | Virgin Islands, US | ||
1263551 | 1263551 | 2021-09-09 | US | Georgia | Camden | 13039 | 6811 | 75 | 0 | 30.92951916 | -81.66601818 | 2021-09-10 04:21:20 | Camden, Georgia, US | |
69379 | 69379 | 2021-09-01 | US | North Carolina | Granville | 37077 | 6811 | 91 | 0 | 36.30337451 | -78.65184241 | 2021-09-02 04:21:15 | Granville, North Carolina, US | |
3165640 | 3165640 | 2021-08-23 | Japan | Ishikawa | 6811 | 121 | 0 | 36.769464 | 136.771027 | 2021-08-24 04:21:19 | Ishikawa, Japan | |||
2177186 | 2177186 | 2021-08-22 | US | Michigan | Grand Traverse | 26055 | 6811 | 101 | 0 | 44.69565625 | -85.55585247 | 2021-08-23 04:21:27 | Grand Traverse, Michigan, US | |
3557282 | 3557282 | 2021-08-21 | US | Michigan | Grand Traverse | 26055 | 6811 | 101 | 0 | 44.69565625 | -85.55585247 | 2021-08-22 04:21:29 | Grand Traverse, Michigan, US | |
1855624 | 1855624 | 2021-08-20 | US | Michigan | Grand Traverse | 26055 | 6811 | 101 | 0 | 44.69565625 | -85.55585247 | 2021-08-21 04:21:38 | Grand Traverse, Michigan, US | |
2519750 | 2519750 | 2021-08-18 | US | Maryland | Cecil | 24015 | 6811 | 161 | 0 | 39.56647682 | -75.94627411 | 2021-08-19 04:21:15 | Cecil, Maryland, US | |
651499 | 651499 | 2021-08-09 | US | Louisiana | St. Mary | 22101 | 6811 | 155 | 0 | 29.69262097 | -91.44702164 | 2021-08-10 04:21:27 | St. Mary, Louisiana, US | |
650579 | 650579 | 2021-08-09 | US | Colorado | Eagle | 8037 | 6811 | 27 | 0 | 39.62754308 | -106.6933637 | 2021-08-10 04:21:27 | Eagle, Colorado, US | |
3906481 | 3906481 | 2021-07-31 | US | Ohio | Scioto | 39145 | 6811 | 111 | 0 | 38.80270163 | -82.98907345 | 2021-08-01 04:21:50 | Scioto, Ohio, US | |
3296664 | 3296664 | 2021-07-30 | US | Arkansas | Greene | 5055 | 6811 | 80 | 0 | 36.11735460000001 | -90.55832668 | 2021-07-31 04:21:35 | Greene, Arkansas, US | |
781178 | 781178 | 2021-07-08 | US | South Carolina | Georgetown | 45043 | 6811 | 141 | 0 | 33.43443342 | -79.33202141 | 2021-07-09 04:21:21 | Georgetown, South Carolina, US | |
1443400 | 1443400 | 2021-07-07 | US | South Carolina | Georgetown | 45043 | 6811 | 141 | 0 | 33.43443342 | -79.33202141 | 2021-07-08 04:21:26 | Georgetown, South Carolina, US | |
2696505 | 2696505 | 2021-07-06 | US | South Carolina | Georgetown | 45043 | 6811 | 141 | 0 | 33.43443342 | -79.33202141 | 2021-07-07 04:21:20 | Georgetown, South Carolina, US | |
1935254 | 1935254 | 2021-07-05 | US | South Carolina | Georgetown | 45043 | 6811 | 141 | 0 | 33.43443342 | -79.33202141 | 2021-07-06 04:21:32 | Georgetown, South Carolina, US | |
3383081 | 3383081 | 2021-06-13 | US | Minnesota | Crow Wing | 27035 | 6811 | 94 | 0 | 46.48096553 | -94.06755609 | 2021-06-14 04:22:46 | Crow Wing, Minnesota, US | |
3092820 | 3092820 | 2021-05-30 | US | Virginia | Rockingham | 51165 | 6811 | 108 | 0 | 38.51006137 | -78.87260325 | 2021-05-31 03:08:59 | Rockingham, Virginia, US | |
2453274 | 2453274 | 2021-05-02 | US | Ohio | Ross | 39141 | 6811 | 158 | 0 | 39.33705391 | -83.06000914 | 2021-05-03 04:20:39 | Ross, Ohio, US | |
171663 | 171663 | 2021-04-16 | US | Michigan | Clinton | 26037 | 6811 | 79 | 0 | 42.94400871 | -84.60145248 | 2021-04-17 04:20:40 | Clinton, Michigan, US | |
2551121 | 2551121 | 2021-04-15 | US | New York | Ontario | 36069 | 6811 | 91 | 0 | 42.85145728 | -77.30874425 | 2021-04-16 04:20:46 | Ontario, New York, US | |
389369 | 389369 | 2021-04-04 | US | Indiana | Wayne | 18177 | 6811 | 196 | 0 | 39.8633444 | -85.01044989 | 2021-04-05 04:20:35 | Wayne, Indiana, US | |
1207071 | 1207071 | 2021-03-22 | US | Utah | Tooele | 49045 | 6811 | 39 | 0 | 40.44862644 | -113.1295715 | 2021-03-23 05:26:18 | Tooele, Utah, US | |
58147 | 58147 | 2021-03-07 | US | Virginia | Hanover | 51085 | 6811 | 138 | 0 | 37.7583355 | -77.49464673 | 2021-03-08 05:24:48 | Hanover, Virginia, US | |
998934 | 998934 | 2021-03-01 | US | Arkansas | Lonoke | 5085 | 6811 | 105 | 0 | 6706 | 34.75392199 | -91.88742357 | 2021-03-02 05:23:30 | Lonoke, Arkansas, US |
3542973 | 3542973 | 2021-02-12 | US | West Virginia | Wood | 54107 | 6811 | 125 | 0 | 6686 | 39.20967886 | -81.5162836 | 2021-02-13 05:22:12 | Wood, West Virginia, US |
3979272 | 3979272 | 2021-02-10 | US | Florida | Highlands | 12055 | 6811 | 282 | 0 | 6529 | 27.34254618 | -81.34071957 | 2021-02-11 05:23:55 | Highlands, Florida, US |
774515 | 774515 | 2021-01-12 | Peru | Pasco | 6811 | 366 | 0 | 6445 | -10.39655 | -75.307635 | 2021-01-13 05:22:15 | Pasco, Peru | ||
191762 | 191762 | 2021-01-11 | US | Minnesota | Carver | 27019 | 6811 | 34 | 0 | 6777 | 44.82017001 | -93.8009918 | 2021-01-12 05:22:15 | Carver, Minnesota, US |
2349874 | 2349874 | 2020-12-07 | US | Ohio | Fairfield | 39045 | 6811 | 98 | 0 | 6713 | 39.75107189 | -82.63088163 | 2020-12-08 05:27:42 | Fairfield, Ohio, US |
2537472 | 2537472 | 2020-12-01 | Mexico | Campeche | 6811 | 920 | 0 | 5891 | 19.8301 | -90.5349 | 2020-12-02 05:27:41 | Campeche, Mexico | ||
1585902 | 1585902 | 2020-11-30 | US | Minnesota | Olmsted | 27109 | 6811 | 34 | 0 | 6777 | 44.00374114 | -92.40209944 | 2020-12-01 05:26:18 | Olmsted, Minnesota, US |
1352539 | 1352539 | 2020-11-24 | US | New York | Dutchess | 36027 | 6811 | 185 | 0 | 6626 | 41.76486060000001 | -73.74356679 | 2020-11-25 05:27:20 | Dutchess, New York, US |
3170769 | 3170769 | 2020-11-16 | US | Indiana | Tippecanoe | 18157 | 6811 | 23 | 0 | 6788 | 40.38872739 | -86.89413959 | 2020-11-17 05:25:54 | Tippecanoe, Indiana, US |
3802096 | 3802096 | 2020-10-05 | Russia | Kalmykia Republic | 6811 | 75 | 4031 | 2705 | 46.2313018 | 45.3275745 | 2020-10-06 04:23:33 | Kalmykia Republic, Russia | ||
2870665 | 2870665 | 2020-09-13 | US | Missouri | St. Louis City | 29510 | 6811 | 219 | 0 | 6592 | 38.63555736 | -90.24349225 | 2020-09-14 04:26:00 | St. Louis City, Missouri, US |
1354380 | 1354380 | 2020-09-03 | Luxembourg | 6811 | 124 | 6074 | 613 | 49.8153 | 6.1296 | 2020-09-04 04:28:26 | Luxembourg | |||
194282 | 194282 | 2020-08-31 | Russia | Leningrad Oblast | 6811 | 79 | 4975 | 1757 | 60.1853296 | 32.3925325 | 2020-09-01 04:28:31 | Leningrad Oblast, Russia | ||
2807807 | 2807807 | 2020-08-02 | Russia | Chuvashia Republic | 6811 | 56 | 3857 | 2898 | 55.4259922 | 47.0849429 | 2020-08-03 04:34:35 | Chuvashia Republic, Russia | ||
327025 | 327025 | 2020-07-20 | Italy | Marche | 6811 | 987 | 5678 | 146 | 43.61675973 | 13.5188753 | 2020-07-21 04:38:46 | Marche, Italy | ||
121930 | 121930 | 2020-07-19 | Italy | Marche | 6811 | 987 | 5674 | 150 | 43.61675973 | 13.5188753 | 2020-07-20 05:34:40 | Marche, Italy |
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]);