johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
165 rows where confirmed = 4881 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952146 | 2952146 | 2022-12-20 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-21 04:21:03 | Ben Hill, Georgia, US | |
3174548 | 3174548 | 2022-12-19 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-20 04:21:04 | Ben Hill, Georgia, US | |
1629065 | 1629065 | 2022-12-18 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-19 04:21:03 | Ben Hill, Georgia, US | |
504444 | 504444 | 2022-12-17 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-18 04:21:03 | Ben Hill, Georgia, US | |
3325016 | 3325016 | 2022-12-16 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-17 04:21:04 | Ben Hill, Georgia, US | |
543528 | 543528 | 2022-12-15 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-16 04:21:01 | Ben Hill, Georgia, US | |
349056 | 349056 | 2022-12-14 | US | Georgia | Ben Hill | 13017 | 4881 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-12-15 04:20:58 | Ben Hill, Georgia, US | |
1833309 | 1833309 | 2022-10-25 | US | Texas | Lamb | 48279 | 4881 | 125 | 0 | 34.06859623 | -102.3516289 | 2022-10-26 04:22:19 | Lamb, Texas, US | |
797570 | 797570 | 2022-10-24 | US | Texas | Lamb | 48279 | 4881 | 125 | 0 | 34.06859623 | -102.3516289 | 2022-10-25 04:21:53 | Lamb, Texas, US | |
3280025 | 3280025 | 2022-10-23 | US | Texas | Lamb | 48279 | 4881 | 125 | 0 | 34.06859623 | -102.3516289 | 2022-10-24 04:22:29 | Lamb, Texas, US | |
2271063 | 2271063 | 2022-10-22 | US | Texas | Lamb | 48279 | 4881 | 125 | 0 | 34.06859623 | -102.3516289 | 2022-10-23 04:22:46 | Lamb, Texas, US | |
1595363 | 1595363 | 2022-10-21 | US | Texas | Lamb | 48279 | 4881 | 125 | 0 | 34.06859623 | -102.3516289 | 2022-10-22 04:22:53 | Lamb, Texas, US | |
3746092 | 3746092 | 2022-09-07 | US | Illinois | De Witt | 17039 | 4881 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-09-08 04:21:02 | De Witt, Illinois, US | |
1251753 | 1251753 | 2022-08-23 | US | Illinois | Hancock | 17067 | 4881 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-08-24 04:20:46 | Hancock, Illinois, US | |
2154864 | 2154864 | 2022-07-16 | US | Texas | Reeves | 48389 | 4881 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-07-17 04:21:15 | Reeves, Texas, US | |
596644 | 596644 | 2022-07-01 | US | Tennessee | Polk | 47139 | 4881 | 80 | 0 | 35.12245443 | -84.52075859 | 2022-07-02 04:21:16 | Polk, Tennessee, US | |
3943576 | 3943576 | 2022-06-30 | US | West Virginia | Taylor | 54091 | 4881 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-07-01 04:21:10 | Taylor, West Virginia, US | |
3943045 | 3943045 | 2022-06-30 | US | Tennessee | Polk | 47139 | 4881 | 80 | 0 | 35.12245443 | -84.52075859 | 2022-07-01 04:21:10 | Polk, Tennessee, US | |
2492565 | 2492565 | 2022-06-29 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-30 04:21:01 | Craig, Oklahoma, US | |
2241947 | 2241947 | 2022-06-28 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-29 04:20:59 | Craig, Oklahoma, US | |
2150189 | 2150189 | 2022-06-27 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-28 04:20:58 | Craig, Oklahoma, US | |
477990 | 477990 | 2022-06-26 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-27 04:21:00 | Craig, Oklahoma, US | |
476907 | 476907 | 2022-06-26 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-27 04:21:00 | Powell, Kentucky, US | |
941365 | 941365 | 2022-06-25 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-26 04:21:02 | Craig, Oklahoma, US | |
940282 | 940282 | 2022-06-25 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-26 04:21:02 | Powell, Kentucky, US | |
3349185 | 3349185 | 2022-06-24 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-25 04:20:57 | Craig, Oklahoma, US | |
3348102 | 3348102 | 2022-06-24 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-25 04:20:57 | Powell, Kentucky, US | |
1650926 | 1650926 | 2022-06-23 | US | Oklahoma | Craig | 40035 | 4881 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-24 04:20:58 | Craig, Oklahoma, US | |
1649843 | 1649843 | 2022-06-23 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-24 04:20:58 | Powell, Kentucky, US | |
2189078 | 2189078 | 2022-06-22 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-23 04:20:55 | Powell, Kentucky, US | |
167509 | 167509 | 2022-06-21 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-22 04:20:54 | Powell, Kentucky, US | |
1764792 | 1764792 | 2022-06-20 | US | Kentucky | Powell | 21197 | 4881 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-06-21 04:20:56 | Powell, Kentucky, US | |
230330 | 230330 | 2022-05-31 | US | Indiana | Jay | 18075 | 4881 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-06-01 04:20:55 | Jay, Indiana, US | |
3187095 | 3187095 | 2022-05-30 | US | Indiana | Jay | 18075 | 4881 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-31 04:20:51 | Jay, Indiana, US | |
3199244 | 3199244 | 2022-05-29 | US | Indiana | Jay | 18075 | 4881 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-30 04:20:50 | Jay, Indiana, US | |
2726122 | 2726122 | 2022-05-28 | US | Indiana | Jay | 18075 | 4881 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-29 04:20:53 | Jay, Indiana, US | |
1315303 | 1315303 | 2022-05-27 | US | Indiana | Jay | 18075 | 4881 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-28 04:21:07 | Jay, Indiana, US | |
3595984 | 3595984 | 2022-05-23 | US | Tennessee | Humphreys | 47085 | 4881 | 75 | 0 | 36.03958805 | -87.77992872 | 2022-05-24 04:20:57 | Humphreys, Tennessee, US | |
624836 | 624836 | 2022-05-22 | US | Tennessee | Humphreys | 47085 | 4881 | 75 | 0 | 36.03958805 | -87.77992872 | 2022-05-26 04:20:50 | Humphreys, Tennessee, US | |
1112532 | 1112532 | 2022-05-21 | US | Tennessee | Humphreys | 47085 | 4881 | 75 | 0 | 36.03958805 | -87.77992872 | 2022-05-22 04:20:52 | Humphreys, Tennessee, US | |
1172156 | 1172156 | 2022-05-20 | US | Tennessee | Humphreys | 47085 | 4881 | 75 | 0 | 36.03958805 | -87.77992872 | 2022-05-21 04:20:58 | Humphreys, Tennessee, US | |
3445816 | 3445816 | 2022-05-11 | US | Illinois | Clark | 17023 | 4881 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-05-12 04:20:54 | Clark, Illinois, US | |
3536433 | 3536433 | 2022-05-10 | US | Illinois | Clark | 17023 | 4881 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-05-11 04:20:48 | Clark, Illinois, US | |
3855129 | 3855129 | 2022-04-27 | US | Virginia | Buchanan | 51027 | 4881 | 120 | 0 | 37.26818323 | -82.03749726 | 2022-04-28 04:20:47 | Buchanan, Virginia, US | |
1329559 | 1329559 | 2022-04-26 | US | Virginia | Buchanan | 51027 | 4881 | 120 | 0 | 37.26818323 | -82.03749726 | 2022-04-27 04:20:52 | Buchanan, Virginia, US | |
3725513 | 3725513 | 2022-04-25 | US | Virginia | Buchanan | 51027 | 4881 | 119 | 0 | 37.26818323 | -82.03749726 | 2022-04-26 04:20:51 | Buchanan, Virginia, US | |
2254737 | 2254737 | 2022-04-19 | US | Virginia | Buchanan | 51027 | 4881 | 118 | 0 | 37.26818323 | -82.03749726 | 2022-04-20 04:20:45 | Buchanan, Virginia, US | |
1576936 | 1576936 | 2022-04-10 | US | Georgia | Cook | 13075 | 4881 | 74 | 0 | 31.16068491 | -83.42947229 | 2022-04-11 04:21:02 | Cook, Georgia, US | |
1653178 | 1653178 | 2022-04-09 | US | Georgia | Cook | 13075 | 4881 | 74 | 0 | 31.16068491 | -83.42947229 | 2022-04-10 04:20:52 | Cook, Georgia, US | |
2116500 | 2116500 | 2022-04-08 | US | Georgia | Cook | 13075 | 4881 | 74 | 0 | 31.16068491 | -83.42947229 | 2022-04-09 04:20:42 | Cook, Georgia, US | |
3321024 | 3321024 | 2022-04-07 | US | Georgia | Cook | 13075 | 4881 | 74 | 0 | 31.16068491 | -83.42947229 | 2022-04-08 04:20:48 | Cook, Georgia, US | |
1647793 | 1647793 | 2022-03-03 | US | Washington | Adams | 53001 | 4881 | 37 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-04 04:21:09 | Adams, Washington, US | |
2528796 | 2528796 | 2022-03-02 | US | Washington | Adams | 53001 | 4881 | 37 | 0 | 46.98299757 | -118.56017340000001 | 2022-03-03 04:21:01 | Adams, Washington, US | |
2736499 | 2736499 | 2022-02-27 | US | West Virginia | Brooke | 54009 | 4881 | 102 | 0 | 40.27367263 | -80.57915332 | 2022-02-28 04:21:05 | Brooke, West Virginia, US | |
3049652 | 3049652 | 2022-02-26 | US | West Virginia | Brooke | 54009 | 4881 | 102 | 0 | 40.27367263 | -80.57915332 | 2022-02-27 04:21:04 | Brooke, West Virginia, US | |
578307 | 578307 | 2022-02-25 | US | West Virginia | Brooke | 54009 | 4881 | 102 | 0 | 40.27367263 | -80.57915332 | 2022-02-26 04:21:12 | Brooke, West Virginia, US | |
3856335 | 3856335 | 2022-02-18 | US | Arkansas | Lincoln | 5079 | 4881 | 62 | 0 | 33.95317155 | -91.74002806 | 2022-02-19 04:21:11 | Lincoln, Arkansas, US | |
73802 | 73802 | 2022-02-07 | US | Pennsylvania | Wyoming | 42131 | 4881 | 97 | 0 | 41.51955538 | -76.01074915 | 2022-02-08 04:21:15 | Wyoming, Pennsylvania, US | |
2474353 | 2474353 | 2022-02-03 | US | Alabama | Pickens | 1107 | 4881 | 93 | 0 | 33.28094866 | -88.08818103 | 2022-02-04 04:21:10 | Pickens, Alabama, US | |
459778 | 459778 | 2022-02-02 | US | Alabama | Pickens | 1107 | 4881 | 93 | 0 | 33.28094866 | -88.08818103 | 2022-02-03 04:21:21 | Pickens, Alabama, US | |
980880 | 980880 | 2022-02-01 | US | Missouri | McDonald | 29119 | 4881 | 62 | 0 | 36.62869595 | -94.34867205 | 2022-02-02 04:21:09 | McDonald, Missouri, US | |
555317 | 555317 | 2022-01-16 | US | Arkansas | Sevier | 5133 | 4881 | 63 | 0 | 33.99780401 | -94.2424869 | 2022-01-17 04:21:08 | Sevier, Arkansas, US | |
3688920 | 3688920 | 2022-01-13 | US | Kentucky | Marion | 21155 | 4881 | 64 | 0 | 37.55218078 | -85.26898542 | 2022-01-14 04:21:54 | Marion, Kentucky, US | |
3688299 | 3688299 | 2022-01-13 | US | Georgia | Harris | 13145 | 4881 | 96 | 0 | 32.73709786 | -84.90538572 | 2022-01-14 04:21:54 | Harris, Georgia, US | |
1669964 | 1669964 | 2021-12-29 | US | Louisiana | Franklin | 22041 | 4881 | 144 | 0 | 32.13675181 | -91.67589857 | 2021-12-30 04:21:25 | Franklin, Louisiana, US | |
1434079 | 1434079 | 2021-12-28 | US | Louisiana | Jefferson Davis | 22053 | 4881 | 133 | 0 | 30.26896765 | -92.81210004 | 2021-12-29 03:21:43 | Jefferson Davis, Louisiana, US | |
784538 | 784538 | 2021-12-13 | US | Nevada | Nye | 32023 | 4881 | 173 | 0 | 38.04264256 | -116.47227020000001 | 2021-12-14 04:22:38 | Nye, Nevada, US | |
3402407 | 3402407 | 2021-11-30 | US | Illinois | Bureau | 17011 | 4881 | 97 | 0 | 41.40385234 | -89.5283051 | 2021-12-01 04:22:29 | Bureau, Illinois, US | |
150823 | 150823 | 2021-11-29 | US | Georgia | Lumpkin | 13187 | 4881 | 109 | 0 | 34.57286511 | -84.00425681 | 2021-11-30 04:22:53 | Lumpkin, Georgia, US | |
1232159 | 1232159 | 2021-11-28 | US | Arkansas | St. Francis | 5123 | 4881 | 69 | 0 | 35.02201976 | -90.74828138 | 2021-11-29 04:22:30 | St. Francis, Arkansas, US | |
1015680 | 1015680 | 2021-11-21 | US | Kansas | Seward | 20175 | 4881 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-22 04:22:20 | Seward, Kansas, US | |
723844 | 723844 | 2021-11-20 | US | Kansas | Seward | 20175 | 4881 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-21 04:22:13 | Seward, Kansas, US | |
163374 | 163374 | 2021-11-19 | US | Kansas | Seward | 20175 | 4881 | 53 | 0 | 37.19324632 | -100.85072009999999 | 2021-11-20 04:22:17 | Seward, Kansas, US | |
3345813 | 3345813 | 2021-11-16 | US | Texas | Palo Pinto | 48363 | 4881 | 120 | 0 | 32.75310985 | -98.31319001 | 2021-11-17 04:21:48 | Palo Pinto, Texas, US | |
3345454 | 3345454 | 2021-11-16 | US | South Carolina | Marlboro | 45069 | 4881 | 83 | 0 | 34.59905577 | -79.67561152 | 2021-11-17 04:21:48 | Marlboro, South Carolina, US | |
715873 | 715873 | 2021-11-12 | US | Kentucky | Grayson | 21085 | 4881 | 95 | 0 | 37.46231118 | -86.34248968 | 2021-11-13 04:21:38 | Grayson, Kentucky, US | |
443871 | 443871 | 2021-10-20 | US | Arkansas | Poinsett | 5111 | 4881 | 98 | 0 | 35.57433534 | -90.66268713 | 2021-10-21 04:21:18 | Poinsett, Arkansas, US | |
1276643 | 1276643 | 2021-10-03 | US | North Carolina | Person | 37145 | 4881 | 85 | 0 | 36.38989032 | -78.97217358 | 2021-10-04 04:21:31 | Person, North Carolina, US | |
1275722 | 1275722 | 2021-10-03 | US | Kentucky | Logan | 21141 | 4881 | 77 | 0 | 36.85949479 | -86.877635 | 2021-10-04 04:21:31 | Logan, Kentucky, US | |
3930396 | 3930396 | 2021-10-02 | US | North Carolina | Person | 37145 | 4881 | 85 | 0 | 36.38989032 | -78.97217358 | 2021-10-03 04:21:24 | Person, North Carolina, US | |
2134376 | 2134376 | 2021-10-01 | US | North Carolina | Person | 37145 | 4881 | 85 | 0 | 36.38989032 | -78.97217358 | 2021-10-02 04:21:25 | Person, North Carolina, US | |
2776469 | 2776469 | 2021-09-30 | US | West Virginia | Logan | 54045 | 4881 | 121 | 0 | 37.8299889 | -81.93528571 | 2021-10-01 04:21:35 | Logan, West Virginia, US | |
602717 | 602717 | 2021-09-23 | US | Illinois | Morgan | 17137 | 4881 | 96 | 0 | 39.71654544 | -90.20255104 | 2021-09-24 04:21:44 | Morgan, Illinois, US | |
2810319 | 2810319 | 2021-09-16 | US | Maryland | Calvert | 24009 | 4881 | 91 | 0 | 38.53961642 | -76.56820632 | 2021-09-17 04:21:46 | Calvert, Maryland, US | |
1387088 | 1387088 | 2021-09-13 | US | Kentucky | Perry | 21193 | 4881 | 76 | 0 | 37.25023553 | -83.22922731 | 2021-09-14 04:21:41 | Perry, Kentucky, US | |
2792742 | 2792742 | 2021-08-28 | Barbados | 4881 | 48 | 0 | 13.1939 | -59.5432 | 2021-08-29 04:21:14 | Barbados | ||||
2519272 | 2519272 | 2021-08-18 | US | Indiana | Huntington | 18069 | 4881 | 83 | 0 | 40.82907273 | -85.48822092 | 2021-08-19 04:21:15 | Huntington, Indiana, US | |
1345853 | 1345853 | 2021-08-11 | US | Wisconsin | Monroe | 55081 | 4881 | 51 | 0 | 43.94641218 | -90.61881899999999 | 2021-08-12 04:21:25 | Monroe, Wisconsin, US | |
3685167 | 3685167 | 2021-08-02 | US | Minnesota | Goodhue | 27049 | 4881 | 74 | 0 | 44.40849741 | -92.7234195 | 2021-08-03 04:21:39 | Goodhue, Minnesota, US | |
409340 | 409340 | 2021-07-28 | US | Illinois | Stephenson | 17177 | 4881 | 86 | 0 | 42.35129217 | -89.662598 | 2021-07-29 04:21:33 | Stephenson, Illinois, US | |
1307572 | 1307572 | 2021-07-27 | US | Kentucky | Jessamine | 21113 | 4881 | 74 | 0 | 37.87119786 | -84.58252003 | 2021-07-28 04:21:39 | Jessamine, Kentucky, US | |
3478188 | 3478188 | 2021-07-22 | US | Missouri | Camden | 29029 | 4881 | 97 | 0 | 38.02199522 | -92.76083747 | 2021-07-23 04:21:29 | Camden, Missouri, US | |
3332447 | 3332447 | 2021-07-21 | US | Idaho | Bingham | 16011 | 4881 | 77 | 0 | 43.21672879999999 | -112.3978437 | 2021-07-22 04:21:19 | Bingham, Idaho, US | |
2674825 | 2674825 | 2021-07-18 | US | Illinois | Macoupin | 17117 | 4881 | 89 | 0 | 39.26119767 | -89.92424028 | 2021-07-19 04:21:24 | Macoupin, Illinois, US | |
3707137 | 3707137 | 2021-07-17 | US | Illinois | Macoupin | 17117 | 4881 | 89 | 0 | 39.26119767 | -89.92424028 | 2021-07-18 04:22:07 | Macoupin, Illinois, US | |
2948368 | 2948368 | 2021-07-16 | US | Illinois | Macoupin | 17117 | 4881 | 89 | 0 | 39.26119767 | -89.92424028 | 2021-07-17 04:22:22 | Macoupin, Illinois, US | |
1934926 | 1934926 | 2021-07-05 | US | Ohio | Mercer | 39107 | 4881 | 86 | 0 | 40.54043046 | -84.62912742 | 2021-07-06 04:21:32 | Mercer, Ohio, US | |
1167657 | 1167657 | 2021-07-04 | US | Ohio | Mercer | 39107 | 4881 | 86 | 0 | 40.54043046 | -84.62912742 | 2021-07-05 04:21:28 | Mercer, Ohio, US | |
1498091 | 1498091 | 2021-07-03 | US | Ohio | Mercer | 39107 | 4881 | 86 | 0 | 40.54043046 | -84.62912742 | 2021-07-04 04:21:38 | Mercer, Ohio, US | |
2074406 | 2074406 | 2021-07-02 | US | Ohio | Mercer | 39107 | 4881 | 86 | 0 | 40.54043046 | -84.62912742 | 2021-07-03 04:21:37 | Mercer, Ohio, 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]);