johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
132 rows where confirmed = 6552 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
693379 | 693379 | 2022-12-23 | US | Tennessee | Unicoi | 47171 | 6552 | 105 | 0 | 36.10890856 | -82.43709629 | 2022-12-24 04:21:02 | Unicoi, Tennessee, US | |
1631670 | 1631670 | 2022-12-18 | US | Virginia | King George | 51099 | 6552 | 51 | 0 | 38.26818502 | -77.15852768 | 2022-12-19 04:21:03 | King George, Virginia, US | |
507049 | 507049 | 2022-12-17 | US | Virginia | King George | 51099 | 6552 | 51 | 0 | 38.26818502 | -77.15852768 | 2022-12-18 04:21:03 | King George, Virginia, US | |
3327621 | 3327621 | 2022-12-16 | US | Virginia | King George | 51099 | 6552 | 51 | 0 | 38.26818502 | -77.15852768 | 2022-12-17 04:21:04 | King George, Virginia, US | |
1620546 | 1620546 | 2022-11-22 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-23 04:21:06 | Saint Kitts and Nevis | ||||
3460434 | 3460434 | 2022-11-21 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-22 04:20:47 | Saint Kitts and Nevis | ||||
1640619 | 1640619 | 2022-11-20 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-21 04:21:05 | Saint Kitts and Nevis | ||||
2064176 | 2064176 | 2022-11-19 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-20 04:21:08 | Saint Kitts and Nevis | ||||
1755570 | 1755570 | 2022-11-18 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-19 04:21:14 | Saint Kitts and Nevis | ||||
3026563 | 3026563 | 2022-11-17 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-18 04:21:15 | Saint Kitts and Nevis | ||||
2486274 | 2486274 | 2022-11-16 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-17 04:21:11 | Saint Kitts and Nevis | ||||
292285 | 292285 | 2022-11-15 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-16 04:21:09 | Saint Kitts and Nevis | ||||
3597315 | 3597315 | 2022-11-14 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-15 04:21:16 | Saint Kitts and Nevis | ||||
312173 | 312173 | 2022-11-13 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-14 04:21:09 | Saint Kitts and Nevis | ||||
63334 | 63334 | 2022-11-12 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-13 04:21:14 | Saint Kitts and Nevis | ||||
2927496 | 2927496 | 2022-11-11 | Saint Kitts and Nevis | 6552 | 46 | 0 | 17.357822 | -62.782998 | 2022-11-12 04:20:41 | Saint Kitts and Nevis | ||||
2442301 | 2442301 | 2022-11-07 | US | Wisconsin | Kewaunee | 55061 | 6552 | 63 | 0 | 44.51727459 | -87.61468386 | 2022-11-08 04:21:21 | Kewaunee, Wisconsin, US | |
518462 | 518462 | 2022-10-15 | US | Puerto Rico | Catano | 72033 | 6552 | 0 | 0 | 18.437269 | -66.143306 | 2022-10-16 04:22:39 | Catano, Puerto Rico, US | |
2035519 | 2035519 | 2022-10-14 | US | Puerto Rico | Catano | 72033 | 6552 | 0 | 0 | 18.437269 | -66.143306 | 2022-10-15 04:22:00 | Catano, Puerto Rico, US | |
2532938 | 2532938 | 2022-10-06 | US | Wisconsin | Jackson | 55053 | 6552 | 45 | 0 | 44.31864893 | -90.80566792 | 2022-10-07 04:23:08 | Jackson, Wisconsin, US | |
2019653 | 2019653 | 2022-09-20 | US | Tennessee | Chester | 47023 | 6552 | 100 | 0 | 35.42527478 | -88.6095842 | 2022-09-21 04:23:22 | Chester, Tennessee, US | |
420464 | 420464 | 2022-09-18 | US | Indiana | Owen | 18119 | 6552 | 131 | 0 | 39.31145587 | -86.83900724 | 2022-09-19 04:21:49 | Owen, Indiana, US | |
3374488 | 3374488 | 2022-09-17 | US | Indiana | Owen | 18119 | 6552 | 131 | 0 | 39.31145587 | -86.83900724 | 2022-09-18 04:22:50 | Owen, Indiana, US | |
2356596 | 2356596 | 2022-09-16 | US | Indiana | Owen | 18119 | 6552 | 131 | 0 | 39.31145587 | -86.83900724 | 2022-09-17 04:20:19 | Owen, Indiana, US | |
1251607 | 1251607 | 2022-08-23 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-24 04:20:46 | Monroe, Georgia, US | |
2853711 | 2853711 | 2022-08-22 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-23 04:20:56 | Monroe, Georgia, US | |
2403683 | 2403683 | 2022-08-21 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-22 04:20:38 | Monroe, Georgia, US | |
3798761 | 3798761 | 2022-08-20 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-21 04:20:44 | Monroe, Georgia, US | |
2364347 | 2364347 | 2022-08-19 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-20 04:21:01 | Monroe, Georgia, US | |
1162018 | 1162018 | 2022-08-18 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-19 04:20:54 | Monroe, Georgia, US | |
3951342 | 3951342 | 2022-08-17 | US | Georgia | Monroe | 13207 | 6552 | 178 | 0 | 33.014289 | -83.92097166 | 2022-08-18 04:21:11 | Monroe, Georgia, US | |
992503 | 992503 | 2022-08-16 | US | Louisiana | Grant | 22043 | 6552 | 95 | 0 | 31.59882456 | -92.56124347 | 2022-08-17 04:20:59 | Grant, Louisiana, US | |
3873138 | 3873138 | 2022-07-31 | US | Maryland | Caroline | 24011 | 6552 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-08-01 04:21:03 | Caroline, Maryland, US | |
677311 | 677311 | 2022-07-30 | US | Tennessee | Smith | 47159 | 6552 | 87 | 0 | 36.25359775 | -85.95411046 | 2022-07-31 04:21:02 | Smith, Tennessee, US | |
675892 | 675892 | 2022-07-30 | US | Maryland | Caroline | 24011 | 6552 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-07-31 04:21:02 | Caroline, Maryland, US | |
1785091 | 1785091 | 2022-07-29 | US | Maryland | Caroline | 24011 | 6552 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-07-30 04:20:42 | Caroline, Maryland, US | |
3430014 | 3430014 | 2022-07-14 | US | Illinois | Shelby | 17173 | 6552 | 77 | 0 | 39.39133527 | -88.80611122 | 2022-07-15 04:20:53 | Shelby, Illinois, US | |
1202742 | 1202742 | 2022-07-06 | US | Tennessee | DeKalb | 47041 | 6552 | 102 | 0 | 35.97616272 | -85.83689361 | 2022-07-07 04:20:55 | DeKalb, Tennessee, US | |
3272890 | 3272890 | 2022-06-19 | US | Virginia | Mecklenburg | 51117 | 6552 | 123 | 0 | 36.67882005 | -78.36131056 | 2022-06-20 04:21:01 | Mecklenburg, Virginia, US | |
3400802 | 3400802 | 2022-06-18 | US | Virginia | Mecklenburg | 51117 | 6552 | 123 | 0 | 36.67882005 | -78.36131056 | 2022-06-19 04:20:51 | Mecklenburg, Virginia, US | |
2314679 | 2314679 | 2022-06-17 | US | Virginia | Mecklenburg | 51117 | 6552 | 123 | 0 | 36.67882005 | -78.36131056 | 2022-06-18 04:21:10 | Mecklenburg, Virginia, US | |
3985679 | 3985679 | 2022-06-15 | US | Texas | DeWitt | 48123 | 6552 | 99 | 0 | 29.08101855 | -97.3568117 | 2022-06-16 04:20:55 | DeWitt, Texas, US | |
3727893 | 3727893 | 2022-06-07 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-08 04:20:55 | Oceana, Michigan, US | |
3889295 | 3889295 | 2022-06-06 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-07 04:21:08 | Oceana, Michigan, US | |
3509064 | 3509064 | 2022-06-05 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-06 04:20:57 | Oceana, Michigan, US | |
3529141 | 3529141 | 2022-06-04 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-05 04:20:55 | Oceana, Michigan, US | |
3135797 | 3135797 | 2022-06-03 | US | New York | Lewis | 36049 | 6552 | 50 | 0 | 43.7844157 | -75.44903992 | 2022-06-04 04:20:58 | Lewis, New York, US | |
3135227 | 3135227 | 2022-06-03 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-04 04:20:58 | Oceana, Michigan, US | |
3580302 | 3580302 | 2022-06-02 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-03 04:20:58 | Oceana, Michigan, US | |
972595 | 972595 | 2022-06-01 | US | Michigan | Oceana | 26127 | 6552 | 90 | 0 | 43.64124435 | -86.26726673 | 2022-06-02 05:20:39 | Oceana, Michigan, US | |
3537748 | 3537748 | 2022-05-10 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-11 04:20:48 | Anson, North Carolina, US | |
224283 | 224283 | 2022-05-09 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-10 04:20:50 | Anson, North Carolina, US | |
2333668 | 2333668 | 2022-05-08 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-09 04:20:54 | Anson, North Carolina, US | |
363106 | 363106 | 2022-05-07 | US | Puerto Rico | Moca | 72099 | 6552 | 0 | 0 | 18.377805 | -67.080952 | 2022-05-08 04:20:49 | Moca, Puerto Rico, US | |
362630 | 362630 | 2022-05-07 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-08 04:20:49 | Anson, North Carolina, US | |
1399981 | 1399981 | 2022-05-06 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-07 04:21:09 | Anson, North Carolina, US | |
2600336 | 2600336 | 2022-05-05 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-06 04:21:00 | Anson, North Carolina, US | |
3267785 | 3267785 | 2022-05-04 | US | North Carolina | Anson | 37007 | 6552 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-05 04:20:55 | Anson, North Carolina, US | |
3917165 | 3917165 | 2022-05-01 | US | Indiana | Posey | 18129 | 6552 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-05-02 04:21:10 | Posey, Indiana, US | |
2841969 | 2841969 | 2022-04-30 | US | Indiana | Posey | 18129 | 6552 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-05-01 04:20:57 | Posey, Indiana, US | |
1158282 | 1158282 | 2022-04-29 | US | Indiana | Posey | 18129 | 6552 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-04-30 04:21:05 | Posey, Indiana, US | |
2735740 | 2735740 | 2022-02-27 | US | Puerto Rico | Aguadilla | 72005 | 6552 | 0 | 0 | 18.459681 | -67.12081500000001 | 2022-02-28 04:21:05 | Aguadilla, Puerto Rico, US | |
2448644 | 2448644 | 2022-02-22 | US | Missouri | Barry | 29009 | 6552 | 107 | 0 | 36.70978521 | -93.82919888 | 2022-02-23 04:21:09 | Barry, Missouri, US | |
1301459 | 1301459 | 2022-02-17 | US | Virginia | Russell | 51167 | 6552 | 95 | 0 | 36.93028320000001 | -82.10095486 | 2022-02-18 04:21:04 | Russell, Virginia, US | |
2645238 | 2645238 | 2022-02-14 | US | West Virginia | Hancock | 54029 | 6552 | 132 | 0 | 40.51943859 | -80.57461608 | 2022-02-15 04:21:09 | Hancock, West Virginia, US | |
1467386 | 1467386 | 2022-02-10 | US | Virginia | Amherst | 51009 | 6552 | 76 | 0 | 37.60308293 | -79.14548696 | 2022-02-11 04:21:09 | Amherst, Virginia, US | |
980850 | 980850 | 2022-02-01 | US | Missouri | Dunklin | 29069 | 6552 | 93 | 0 | 36.27167174 | -90.09122243 | 2022-02-02 04:21:09 | Dunklin, Missouri, US | |
1782947 | 1782947 | 2022-01-27 | US | Wisconsin | Lincoln | 55069 | 6552 | 126 | 0 | 45.33737523 | -89.73411273 | 2022-01-28 04:21:09 | Lincoln, Wisconsin, US | |
1032902 | 1032902 | 2021-12-06 | US | Ohio | Williams | 39171 | 6552 | 116 | 0 | 41.56052014 | -84.58429552 | 2021-12-07 04:22:34 | Williams, Ohio, US | |
1805220 | 1805220 | 2021-11-25 | US | Ohio | Highland | 39071 | 6552 | 124 | 0 | 39.1839264 | -83.60331456 | 2021-11-26 04:22:33 | Highland, Ohio, US | |
906654 | 906654 | 2021-11-24 | US | Ohio | Highland | 39071 | 6552 | 124 | 0 | 39.1839264 | -83.60331456 | 2021-11-25 04:22:33 | Highland, Ohio, US | |
3750896 | 3750896 | 2021-11-22 | US | Minnesota | Steele | 27147 | 6552 | 30 | 0 | 44.02240351 | -93.22627088 | 2021-11-23 04:22:39 | Steele, Minnesota, US | |
30246 | 30246 | 2021-11-11 | US | Mississippi | Marshall | 28093 | 6552 | 139 | 0 | 34.76216286 | -89.50299462 | 2021-11-12 04:22:01 | Marshall, Mississippi, US | |
2846685 | 2846685 | 2021-11-10 | US | Mississippi | Marshall | 28093 | 6552 | 139 | 0 | 34.76216286 | -89.50299462 | 2021-11-11 04:21:45 | Marshall, Mississippi, US | |
683860 | 683860 | 2021-10-24 | US | Louisiana | Natchitoches | 22069 | 6552 | 133 | 0 | 31.72321584 | -93.09816516 | 2021-10-25 04:22:31 | Natchitoches, Louisiana, US | |
771868 | 771868 | 2021-10-23 | US | Louisiana | Natchitoches | 22069 | 6552 | 133 | 0 | 31.72321584 | -93.09816516 | 2021-10-24 04:21:22 | Natchitoches, Louisiana, US | |
655515 | 655515 | 2021-10-22 | US | Louisiana | Natchitoches | 22069 | 6552 | 133 | 0 | 31.72321584 | -93.09816516 | 2021-10-23 04:21:32 | Natchitoches, Louisiana, US | |
2044940 | 2044940 | 2021-10-18 | US | Indiana | Gibson | 18051 | 6552 | 113 | 0 | 38.30393723 | -87.58054938 | 2021-10-19 04:20:54 | Gibson, Indiana, US | |
1912354 | 1912354 | 2021-10-17 | US | Texas | Kerr | 48265 | 6552 | 127 | 0 | 30.06040006 | -99.34930144 | 2021-10-18 04:21:10 | Kerr, Texas, US | |
937943 | 937943 | 2021-10-16 | US | Texas | Kerr | 48265 | 6552 | 127 | 0 | 30.06040006 | -99.34930144 | 2021-10-17 04:21:29 | Kerr, Texas, US | |
2946505 | 2946505 | 2021-10-15 | US | Texas | Lamar | 48277 | 6552 | 199 | 0 | 33.66981763 | -95.57404777 | 2021-10-16 04:21:15 | Lamar, Texas, US | |
2946498 | 2946498 | 2021-10-15 | US | Texas | Kerr | 48265 | 6552 | 126 | 0 | 30.06040006 | -99.34930144 | 2021-10-16 04:21:15 | Kerr, Texas, US | |
1494046 | 1494046 | 2021-10-12 | US | Ohio | Auglaize | 39011 | 6552 | 104 | 0 | 40.55998859 | -84.22421429999999 | 2021-10-13 04:20:51 | Auglaize, Ohio, US | |
3808604 | 3808604 | 2021-09-11 | US | Pennsylvania | Union | 42119 | 6552 | 91 | 0 | 40.96188846 | -77.05996014 | 2021-09-12 04:21:13 | Union, Pennsylvania, US | |
3451502 | 3451502 | 2021-09-10 | US | Pennsylvania | Columbia | 42037 | 6552 | 139 | 0 | 41.04821986 | -76.40565017 | 2021-09-11 04:21:30 | Columbia, Pennsylvania, US | |
251757 | 251757 | 2021-09-04 | US | Ohio | Huron | 39077 | 6552 | 126 | 0 | 41.14651175 | -82.59867951 | 2021-09-05 04:21:33 | Huron, Ohio, US | |
33411 | 33411 | 2021-08-25 | US | Illinois | Jackson | 17077 | 6552 | 70 | 0 | 37.78595185 | -89.38232563 | 2021-08-26 04:21:28 | Jackson, Illinois, US | |
3167802 | 3167802 | 2021-08-23 | US | New Jersey | Salem | 34033 | 6552 | 192 | 0 | 39.58719656 | -75.34696629999998 | 2021-08-24 04:21:19 | Salem, New Jersey, US | |
2177257 | 2177257 | 2021-08-22 | US | Minnesota | Chisago | 27025 | 6552 | 55 | 0 | 45.5021011 | -92.90861945 | 2021-08-23 04:21:27 | Chisago, Minnesota, US | |
3557353 | 3557353 | 2021-08-21 | US | Minnesota | Chisago | 27025 | 6552 | 55 | 0 | 45.5021011 | -92.90861945 | 2021-08-22 04:21:29 | Chisago, Minnesota, US | |
1855695 | 1855695 | 2021-08-20 | US | Minnesota | Chisago | 27025 | 6552 | 55 | 0 | 45.5021011 | -92.90861945 | 2021-08-21 04:21:38 | Chisago, Minnesota, US | |
332382 | 332382 | 2021-08-04 | US | Arkansas | Crittenden | 5035 | 6552 | 99 | 0 | 35.21247318 | -90.30839406 | 2021-08-05 04:21:51 | Crittenden, Arkansas, US | |
3018071 | 3018071 | 2021-08-01 | US | Puerto Rico | Caguas | 72025 | 6552 | 0 | 0 | 18.211615 | -66.050779 | 2021-08-02 04:21:36 | Caguas, Puerto Rico, US | |
411643 | 411643 | 2021-07-28 | US | Virginia | Harrisonburg | 51660 | 6552 | 94 | 0 | 38.43542574 | -78.87536254 | 2021-07-29 04:21:33 | Harrisonburg, Virginia, US | |
487119 | 487119 | 2021-07-19 | US | Wisconsin | Calumet | 55015 | 6552 | 56 | 0 | 44.0816316 | -88.21780273 | 2021-07-20 04:21:48 | Calumet, Wisconsin, US | |
3961014 | 3961014 | 2021-06-26 | US | Ohio | Scioto | 39145 | 6552 | 108 | 0 | 38.80270163 | -82.98907345 | 2021-06-27 04:21:39 | Scioto, Ohio, US | |
3960098 | 3960098 | 2021-06-26 | US | Massachusetts | Berkshire | 25003 | 6552 | 246 | 0 | 42.37428441 | -73.20524838 | 2021-06-27 04:21:39 | Berkshire, Massachusetts, US | |
1713917 | 1713917 | 2021-06-25 | US | Massachusetts | Berkshire | 25003 | 6552 | 246 | 0 | 42.37428441 | -73.20524838 | 2021-06-26 04:21:43 | Berkshire, Massachusetts, US | |
563582 | 563582 | 2021-06-22 | US | Colorado | Fremont | 8043 | 6552 | 64 | 0 | 38.47362326 | -105.4399667 | 2021-06-23 04:21:46 | Fremont, Colorado, US | |
3362101 | 3362101 | 2021-06-21 | US | Washington | Cowlitz | 53015 | 6552 | 90 | 0 | 46.19074721 | -122.6782231 | 2021-06-22 04:21:34 | Cowlitz, Washington, 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]);