johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
180 rows where confirmed = 3849 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952178 | 2952178 | 2022-12-20 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-21 04:21:03 | Dade, Georgia, US | |
3174580 | 3174580 | 2022-12-19 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-20 04:21:04 | Dade, Georgia, US | |
1629097 | 1629097 | 2022-12-18 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-19 04:21:03 | Dade, Georgia, US | |
504476 | 504476 | 2022-12-17 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-18 04:21:03 | Dade, Georgia, US | |
3325048 | 3325048 | 2022-12-16 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-17 04:21:04 | Dade, Georgia, US | |
543560 | 543560 | 2022-12-15 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-16 04:21:01 | Dade, Georgia, US | |
349088 | 349088 | 2022-12-14 | US | Georgia | Dade | 13083 | 3849 | 39 | 0 | 34.8549167 | -85.50490424 | 2022-12-15 04:20:58 | Dade, Georgia, US | |
2439369 | 2439369 | 2022-11-07 | US | Colorado | Gunnison | 8051 | 3849 | 15 | 0 | 38.66611652 | -107.0320729 | 2022-11-08 04:21:21 | Gunnison, Colorado, US | |
2377045 | 2377045 | 2022-09-29 | US | Louisiana | Claiborne | 22027 | 3849 | 80 | 0 | 32.82308512 | -92.99526883 | 2022-09-30 04:23:09 | Claiborne, Louisiana, US | |
1561596 | 1561596 | 2022-09-28 | US | Louisiana | Claiborne | 22027 | 3849 | 80 | 0 | 32.82308512 | -92.99526883 | 2022-09-29 04:22:34 | Claiborne, Louisiana, US | |
2635185 | 2635185 | 2022-09-05 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-09-06 04:21:02 | Pendleton, Kentucky, US | |
2988749 | 2988749 | 2022-09-04 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-09-05 04:21:01 | Pendleton, Kentucky, US | |
2987912 | 2987912 | 2022-09-04 | US | Colorado | Grand | 8049 | 3849 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-09-05 04:21:01 | Grand, Colorado, US | |
2714434 | 2714434 | 2022-09-03 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-09-04 04:21:22 | Pendleton, Kentucky, US | |
2713597 | 2713597 | 2022-09-03 | US | Colorado | Grand | 8049 | 3849 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-09-04 04:21:22 | Grand, Colorado, US | |
1395139 | 1395139 | 2022-09-02 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-09-03 04:21:04 | Pendleton, Kentucky, US | |
1394302 | 1394302 | 2022-09-02 | US | Colorado | Grand | 8049 | 3849 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-09-03 04:21:04 | Grand, Colorado, US | |
3551088 | 3551088 | 2022-09-01 | US | Wisconsin | Rusk | 55107 | 3849 | 59 | 0 | 45.47498854 | -91.1333012 | 2022-09-02 04:21:07 | Rusk, Wisconsin, US | |
3548968 | 3548968 | 2022-09-01 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-09-02 04:21:07 | Pendleton, Kentucky, US | |
2344888 | 2344888 | 2022-08-31 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-09-01 04:21:03 | Pendleton, Kentucky, US | |
3775368 | 3775368 | 2022-08-30 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-31 04:20:57 | Pendleton, Kentucky, US | |
1681964 | 1681964 | 2022-08-29 | US | Kentucky | Pendleton | 21191 | 3849 | 40 | 0 | 38.69607718 | -84.35599463 | 2022-08-30 04:21:03 | Pendleton, Kentucky, US | |
2595025 | 2595025 | 2022-07-25 | US | Illinois | Greene | 17061 | 3849 | 46 | 0 | 39.35907414 | -90.388865 | 2022-07-26 04:20:58 | Greene, Illinois, US | |
2154814 | 2154814 | 2022-07-16 | US | Texas | Leon | 48289 | 3849 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-07-17 04:21:15 | Leon, Texas, US | |
632630 | 632630 | 2022-07-12 | US | Puerto Rico | Arroyo | 72015 | 3849 | 0 | 0 | 17.998457 | -66.056546 | 2022-07-13 04:20:58 | Arroyo, Puerto Rico, US | |
3967044 | 3967044 | 2022-07-05 | US | Arkansas | Howard | 5061 | 3849 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-07-06 04:20:58 | Howard, Arkansas, US | |
3078555 | 3078555 | 2022-07-04 | US | Arkansas | Howard | 5061 | 3849 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-07-05 04:20:45 | Howard, Arkansas, US | |
3367614 | 3367614 | 2022-07-02 | US | New York | Yates | 36123 | 3849 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-07-03 04:20:59 | Yates, New York, US | |
2240456 | 2240456 | 2022-06-28 | US | Illinois | Wabash | 17185 | 3849 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-06-29 04:20:59 | Wabash, Illinois, US | |
2239782 | 2239782 | 2022-06-28 | US | Alabama | Lamar | 1075 | 3849 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-06-29 04:20:59 | Lamar, Alabama, US | |
562196 | 562196 | 2022-06-16 | US | Virginia | Patrick | 51141 | 3849 | 97 | 0 | 36.6801638 | -80.2865648 | 2022-06-17 04:20:56 | Patrick, Virginia, US | |
1424586 | 1424586 | 2022-06-08 | US | West Virginia | Grant | 54023 | 3849 | 56 | 0 | 39.10314817 | -79.19440518 | 2022-06-09 04:20:54 | Grant, West Virginia, US | |
3585280 | 3585280 | 2022-05-17 | US | Oregon | Tillamook | 41057 | 3849 | 64 | 0 | 45.46248721 | -123.712066 | 2022-05-18 04:20:50 | Tillamook, Oregon, US | |
1506237 | 1506237 | 2022-05-16 | US | Oregon | Tillamook | 41057 | 3849 | 64 | 0 | 45.46248721 | -123.712066 | 2022-05-17 04:20:59 | Tillamook, Oregon, US | |
2334945 | 2334945 | 2022-05-08 | US | Wisconsin | Marquette | 55077 | 3849 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-09 04:20:54 | Marquette, Wisconsin, US | |
363907 | 363907 | 2022-05-07 | US | Wisconsin | Marquette | 55077 | 3849 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-08 04:20:49 | Marquette, Wisconsin, US | |
1401258 | 1401258 | 2022-05-06 | US | Wisconsin | Marquette | 55077 | 3849 | 61 | 0 | 43.81911946 | -89.40073763 | 2022-05-07 04:21:09 | Marquette, Wisconsin, US | |
3323819 | 3323819 | 2022-04-07 | US | Wisconsin | Richland | 55103 | 3849 | 47 | 0 | 43.3762778 | -90.43012729 | 2022-04-08 04:20:48 | Richland, Wisconsin, US | |
159256 | 159256 | 2022-03-29 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-30 04:20:45 | Tama, Iowa, US | |
1438942 | 1438942 | 2022-03-28 | US | North Carolina | Polk | 37149 | 3849 | 54 | 0 | 35.27820615 | -82.16812354 | 2022-03-29 04:20:46 | Polk, North Carolina, US | |
1437827 | 1437827 | 2022-03-28 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-29 04:20:46 | Tama, Iowa, US | |
877508 | 877508 | 2022-03-27 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-28 04:20:33 | Tama, Iowa, US | |
2164791 | 2164791 | 2022-03-26 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-27 04:20:47 | Tama, Iowa, US | |
1721727 | 1721727 | 2022-03-25 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-26 04:20:23 | Tama, Iowa, US | |
1469344 | 1469344 | 2022-03-24 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-25 04:20:46 | Tama, Iowa, US | |
3023518 | 3023518 | 2022-03-23 | US | Iowa | Tama | 19171 | 3849 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-03-24 04:20:43 | Tama, Iowa, US | |
3628385 | 3628385 | 2022-03-13 | US | Alaska | Ketchikan Gateway | 2130 | 3849 | 21 | 0 | 55.57445008 | -130.975561 | 2022-03-14 04:20:46 | Ketchikan Gateway, Alaska, US | |
951293 | 951293 | 2022-03-12 | US | Alaska | Ketchikan Gateway | 2130 | 3849 | 21 | 0 | 55.57445008 | -130.975561 | 2022-03-13 04:20:49 | Ketchikan Gateway, Alaska, US | |
356754 | 356754 | 2022-03-11 | US | Alaska | Ketchikan Gateway | 2130 | 3849 | 21 | 0 | 55.57445008 | -130.975561 | 2022-03-12 04:20:50 | Ketchikan Gateway, Alaska, US | |
1061113 | 1061113 | 2022-02-23 | US | Texas | Young | 48503 | 3849 | 86 | 0 | 33.17659707 | -98.68790885 | 2022-02-24 04:21:14 | Young, Texas, US | |
1299353 | 1299353 | 2022-02-17 | US | Kansas | Jackson | 20085 | 3849 | 27 | 0 | 39.41673394 | -95.79356799 | 2022-02-18 04:21:04 | Jackson, Kansas, US | |
3821739 | 3821739 | 2022-02-16 | US | Kansas | Jackson | 20085 | 3849 | 27 | 0 | 39.41673394 | -95.79356799 | 2022-02-17 04:20:56 | Jackson, Kansas, US | |
3821265 | 3821265 | 2022-02-16 | US | Georgia | Jeff Davis | 13161 | 3849 | 66 | 0 | 31.80405727 | -82.63724870000001 | 2022-02-17 04:20:56 | Jeff Davis, Georgia, US | |
3673034 | 3673034 | 2022-02-15 | US | Kentucky | Caldwell | 21033 | 3849 | 58 | 0 | 37.14749129 | -87.86948214 | 2022-02-16 04:21:10 | Caldwell, Kentucky, US | |
2015651 | 2015651 | 2022-02-06 | US | Tennessee | Grundy | 47061 | 3849 | 67 | 0 | 35.38433717 | -85.72142731 | 2022-02-07 04:21:05 | Grundy, Tennessee, US | |
2013733 | 2013733 | 2022-02-06 | US | Illinois | Mercer | 17131 | 3849 | 41 | 0 | 41.20596782 | -90.74290052 | 2022-02-07 04:21:05 | Mercer, Illinois, US | |
1295062 | 1295062 | 2022-02-05 | US | Illinois | Mercer | 17131 | 3849 | 41 | 0 | 41.20596782 | -90.74290052 | 2022-02-06 04:21:00 | Mercer, Illinois, US | |
2328390 | 2328390 | 2022-02-04 | US | Illinois | Mercer | 17131 | 3849 | 41 | 0 | 41.20596782 | -90.74290052 | 2022-02-05 04:21:05 | Mercer, Illinois, US | |
980823 | 980823 | 2022-02-01 | US | Missouri | Benton | 29015 | 3849 | 85 | 0 | 38.29503305 | -93.28756116 | 2022-02-02 04:21:09 | Benton, Missouri, US | |
2659514 | 2659514 | 2022-01-31 | US | Minnesota | Houston | 27055 | 3849 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-02-01 04:21:11 | Houston, Minnesota, US | |
2053832 | 2053832 | 2022-01-25 | US | Missouri | Pike | 29163 | 3849 | 56 | 0 | 39.34310674 | -91.16980779 | 2022-01-26 04:21:07 | Pike, Missouri, US | |
1143655 | 1143655 | 2022-01-23 | US | Puerto Rico | Guayama | 72057 | 3849 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-01-24 04:21:12 | Guayama, Puerto Rico, US | |
1282512 | 1282512 | 2022-01-05 | US | Arkansas | Randolph | 5121 | 3849 | 68 | 0 | 36.3415714 | -91.02455531 | 2022-01-06 04:22:09 | Randolph, Arkansas, US | |
1702585 | 1702585 | 2022-01-03 | US | New York | Essex | 36031 | 3849 | 48 | 0 | 44.11630765 | -73.77297842 | 2022-01-04 04:22:17 | Essex, New York, US | |
732869 | 732869 | 2021-12-27 | US | North Carolina | Martin | 37117 | 3849 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-28 04:21:47 | Martin, North Carolina, US | |
2114041 | 2114041 | 2021-12-26 | US | North Carolina | Martin | 37117 | 3849 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-27 04:21:58 | Martin, North Carolina, US | |
3607413 | 3607413 | 2021-12-25 | US | North Carolina | Martin | 37117 | 3849 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-26 04:21:50 | Martin, North Carolina, US | |
2965731 | 2965731 | 2021-12-24 | US | North Carolina | Martin | 37117 | 3849 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-25 04:21:37 | Martin, North Carolina, US | |
3818763 | 3818763 | 2021-12-23 | US | North Carolina | Martin | 37117 | 3849 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-24 04:21:34 | Martin, North Carolina, US | |
800771 | 800771 | 2021-12-22 | US | North Carolina | Martin | 37117 | 3849 | 75 | 0 | 35.84326734 | -77.10860251 | 2021-12-23 04:21:21 | Martin, North Carolina, US | |
3829015 | 3829015 | 2021-12-21 | US | California | Del Norte | 6015 | 3849 | 43 | 0 | 41.74228275 | -123.89740630000001 | 2021-12-22 04:21:54 | Del Norte, California, US | |
1081348 | 1081348 | 2021-12-09 | US | Virginia | Waynesboro | 51820 | 3849 | 53 | 0 | 38.06451466 | -78.90293905 | 2021-12-10 04:22:28 | Waynesboro, Virginia, US | |
405779 | 405779 | 2021-12-07 | US | Kentucky | Woodford | 21239 | 3849 | 32 | 0 | 38.04178222 | -84.7417556 | 2021-12-08 04:22:46 | Woodford, Kentucky, US | |
1148 | 1148 | 2021-12-02 | US | Georgia | Harris | 13145 | 3849 | 95 | 0 | 32.73709786 | -84.90538572 | 2021-12-03 04:23:05 | Harris, Georgia, US | |
450927 | 450927 | 2021-11-17 | US | Wisconsin | Kewaunee | 55061 | 3849 | 48 | 0 | 44.51727459 | -87.61468386 | 2021-11-18 04:21:33 | Kewaunee, Wisconsin, US | |
3344128 | 3344128 | 2021-11-16 | US | Louisiana | Grant | 22043 | 3849 | 78 | 0 | 31.59882456 | -92.56124347 | 2021-11-17 04:21:48 | Grant, Louisiana, US | |
31508 | 31508 | 2021-11-11 | US | Texas | Frio | 48163 | 3849 | 74 | 0 | 28.86751206 | -99.10804207 | 2021-11-12 04:22:01 | Frio, Texas, US | |
2847947 | 2847947 | 2021-11-10 | US | Texas | Frio | 48163 | 3849 | 74 | 0 | 28.86751206 | -99.10804207 | 2021-11-11 04:21:45 | Frio, Texas, US | |
90217 | 90217 | 2021-11-09 | US | Texas | Frio | 48163 | 3849 | 74 | 0 | 28.86751206 | -99.10804207 | 2021-11-10 04:21:38 | Frio, Texas, US | |
683865 | 683865 | 2021-10-24 | US | Louisiana | Pointe Coupee | 22077 | 3849 | 83 | 0 | 30.71409502 | -91.60209535 | 2021-10-25 04:22:31 | Pointe Coupee, Louisiana, US | |
771873 | 771873 | 2021-10-23 | US | Louisiana | Pointe Coupee | 22077 | 3849 | 83 | 0 | 30.71409502 | -91.60209535 | 2021-10-24 04:21:22 | Pointe Coupee, Louisiana, US | |
771779 | 771779 | 2021-10-23 | US | Kentucky | Letcher | 21133 | 3849 | 65 | 0 | 37.12306748 | -82.85346474 | 2021-10-24 04:21:22 | Letcher, Kentucky, US | |
655520 | 655520 | 2021-10-22 | US | Louisiana | Pointe Coupee | 22077 | 3849 | 83 | 0 | 30.71409502 | -91.60209535 | 2021-10-23 04:21:32 | Pointe Coupee, Louisiana, US | |
2046221 | 2046221 | 2021-10-18 | US | North Carolina | Transylvania | 37175 | 3849 | 48 | 0 | 35.20383864 | -82.79638423 | 2021-10-19 04:20:54 | Transylvania, North Carolina, US | |
2878991 | 2878991 | 2021-10-09 | US | Puerto Rico | Trujillo Alto | 72139 | 3849 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-10-10 04:21:38 | Trujillo Alto, Puerto Rico, US | |
2962157 | 2962157 | 2021-10-08 | US | Puerto Rico | Trujillo Alto | 72139 | 3849 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-10-09 04:21:34 | Trujillo Alto, Puerto Rico, US | |
1237187 | 1237187 | 2021-09-27 | US | Louisiana | Union | 22111 | 3849 | 99 | 0 | 32.83121059 | -92.3749373 | 2021-09-28 04:21:28 | Union, Louisiana, US | |
3760898 | 3760898 | 2021-09-21 | US | Virginia | Wythe | 51197 | 3849 | 87 | 0 | 36.91582035 | -81.07834059 | 2021-09-22 04:21:45 | Wythe, Virginia, US | |
812673 | 812673 | 2021-09-20 | US | Texas | Gray | 48179 | 3849 | 65 | 0 | 35.40081878 | -100.8129222 | 2021-09-21 04:21:26 | Gray, Texas, US | |
1817872 | 1817872 | 2021-09-19 | US | Texas | Gray | 48179 | 3849 | 65 | 0 | 35.40081878 | -100.8129222 | 2021-09-20 04:21:22 | Gray, Texas, US | |
19452 | 19452 | 2021-09-18 | US | Texas | Gray | 48179 | 3849 | 65 | 0 | 35.40081878 | -100.8129222 | 2021-09-19 04:21:34 | Gray, Texas, US | |
17427 | 17427 | 2021-09-18 | US | Indiana | Clay | 18021 | 3849 | 56 | 0 | 39.39561833 | -87.11723506 | 2021-09-19 04:21:34 | Clay, Indiana, US | |
2621545 | 2621545 | 2021-09-17 | US | West Virginia | Preston | 54077 | 3849 | 57 | 0 | 39.46770987 | -79.66712803 | 2021-09-18 04:21:24 | Preston, West Virginia, US | |
3194130 | 3194130 | 2021-09-06 | Netherlands | Sint Maarten | 3849 | 57 | 0 | 18.0425 | -63.0548 | 2021-09-07 04:21:35 | Sint Maarten, Netherlands | |||
2926336 | 2926336 | 2021-08-27 | US | Texas | Kleberg | 48273 | 3849 | 100 | 0 | 27.42435506 | -97.69894948 | 2021-08-28 04:21:28 | Kleberg, Texas, US | |
2521652 | 2521652 | 2021-08-18 | US | West Virginia | Fayette | 54019 | 3849 | 86 | 0 | 38.02974928 | -81.08286634 | 2021-08-19 04:21:15 | Fayette, West Virginia, US | |
1605603 | 1605603 | 2021-08-16 | US | Kentucky | Boyle | 21021 | 3849 | 80 | 0 | 37.62680923 | -84.8633779 | 2021-08-17 04:21:49 | Boyle, Kentucky, US | |
3686455 | 3686455 | 2021-08-02 | US | Tennessee | White | 47185 | 3849 | 75 | 0 | 35.92929884 | -85.45591799 | 2021-08-03 04:21:39 | White, Tennessee, US | |
1307117 | 1307117 | 2021-07-27 | US | Illinois | Bureau | 17011 | 3849 | 87 | 0 | 41.40385234 | -89.5283051 | 2021-07-28 04:21:39 | Bureau, Illinois, US | |
3219799 | 3219799 | 2021-07-26 | US | Louisiana | Evangeline | 22039 | 3849 | 100 | 0 | 30.72985248 | -92.39915924 | 2021-07-27 04:21:18 | Evangeline, 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]);