johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
199 rows where confirmed = 4109 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
540509 | 540509 | 2022-10-26 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-27 04:22:01 | Pennington, Minnesota, US | |
1831910 | 1831910 | 2022-10-25 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-26 04:22:19 | Pennington, Minnesota, US | |
796171 | 796171 | 2022-10-24 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-25 04:21:53 | Pennington, Minnesota, US | |
3278626 | 3278626 | 2022-10-23 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-24 04:22:29 | Pennington, Minnesota, US | |
2269664 | 2269664 | 2022-10-22 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-23 04:22:46 | Pennington, Minnesota, US | |
1593964 | 1593964 | 2022-10-21 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-22 04:22:53 | Pennington, Minnesota, US | |
2275004 | 2275004 | 2022-10-20 | US | Texas | Duval | 48131 | 4109 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-10-21 04:22:23 | Duval, Texas, US | |
2273680 | 2273680 | 2022-10-20 | US | Minnesota | Pennington | 27113 | 4109 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-10-21 04:22:23 | Pennington, Minnesota, US | |
201339 | 201339 | 2022-10-19 | US | Texas | Duval | 48131 | 4109 | 73 | 0 | 27.68184592 | -98.50864568 | 2022-10-20 04:22:59 | Duval, Texas, US | |
2759944 | 2759944 | 2022-10-18 | US | Texas | Bandera | 48019 | 4109 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-10-19 04:22:26 | Bandera, Texas, US | |
2027778 | 2027778 | 2022-10-17 | US | Texas | Bandera | 48019 | 4109 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-10-18 04:22:42 | Bandera, Texas, US | |
2162691 | 2162691 | 2022-10-16 | US | Texas | Leon | 48289 | 4109 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-17 04:20:31 | Leon, Texas, US | |
518888 | 518888 | 2022-10-15 | US | Texas | Leon | 48289 | 4109 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-16 04:22:39 | Leon, Texas, US | |
2035945 | 2035945 | 2022-10-14 | US | Texas | Leon | 48289 | 4109 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-15 04:22:00 | Leon, Texas, US | |
3756633 | 3756633 | 2022-10-13 | US | Texas | Leon | 48289 | 4109 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-14 04:22:28 | Leon, Texas, US | |
3217458 | 3217458 | 2022-10-12 | US | Texas | Leon | 48289 | 4109 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-13 04:22:39 | Leon, Texas, US | |
2377829 | 2377829 | 2022-09-29 | US | New York | Yates | 36123 | 4109 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-09-30 04:23:09 | Yates, New York, US | |
2345629 | 2345629 | 2022-08-31 | US | New Mexico | Los Alamos | 35028 | 4109 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-09-01 04:21:03 | Los Alamos, New Mexico, US | |
1880252 | 1880252 | 2022-08-28 | US | Texas | Zapata | 48505 | 4109 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-08-29 04:21:06 | Zapata, Texas, US | |
2099379 | 2099379 | 2022-08-27 | US | Texas | Zapata | 48505 | 4109 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-08-28 04:21:02 | Zapata, Texas, US | |
1535194 | 1535194 | 2022-08-26 | US | Texas | Zapata | 48505 | 4109 | 56 | 0 | 27.00156391 | -99.16987152 | 2022-08-27 04:20:57 | Zapata, Texas, US | |
2406280 | 2406280 | 2022-08-21 | US | Washington | Jefferson | 53031 | 4109 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-08-22 04:20:38 | Jefferson, Washington, US | |
3801358 | 3801358 | 2022-08-20 | US | Washington | Jefferson | 53031 | 4109 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-08-21 04:20:44 | Jefferson, Washington, US | |
2366944 | 2366944 | 2022-08-19 | US | Washington | Jefferson | 53031 | 4109 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-08-20 04:21:01 | Jefferson, Washington, US | |
3648070 | 3648070 | 2022-08-14 | US | Arkansas | Franklin | 5047 | 4109 | 74 | 0 | 35.51202821 | -93.89299569 | 2022-08-15 04:20:59 | Franklin, Arkansas, US | |
1488888 | 1488888 | 2022-07-26 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-27 04:21:04 | Jackson, Kansas, US | |
1487952 | 1487952 | 2022-07-26 | US | Alabama | Crenshaw | 1041 | 4109 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-07-27 04:21:04 | Crenshaw, Alabama, US | |
2595334 | 2595334 | 2022-07-25 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-26 04:20:58 | Jackson, Kansas, US | |
897449 | 897449 | 2022-07-24 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-25 04:20:51 | Jackson, Kansas, US | |
92443 | 92443 | 2022-07-23 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-24 04:20:47 | Jackson, Kansas, US | |
901465 | 901465 | 2022-07-22 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-23 04:20:53 | Jackson, Kansas, US | |
671601 | 671601 | 2022-07-21 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-22 04:21:15 | Jackson, Kansas, US | |
1609564 | 1609564 | 2022-07-20 | US | Kansas | Jackson | 20085 | 4109 | 31 | 0 | 39.41673394 | -95.79356799 | 2022-07-21 04:21:10 | Jackson, Kansas, US | |
1213768 | 1213768 | 2022-07-11 | US | New Mexico | Socorro | 35053 | 4109 | 92 | 0 | 34.00715494 | -106.9298354 | 2022-07-12 04:20:51 | Socorro, New Mexico, US | |
1203111 | 1203111 | 2022-07-06 | US | Virginia | Appomattox | 51011 | 4109 | 53 | 0 | 37.37569884 | -78.81340003 | 2022-07-07 04:20:55 | Appomattox, Virginia, US | |
478917 | 478917 | 2022-06-26 | US | West Virginia | Braxton | 54007 | 4109 | 45 | 0 | 38.70036159 | -80.72011184 | 2022-06-27 04:21:00 | Braxton, West Virginia, US | |
942292 | 942292 | 2022-06-25 | US | West Virginia | Braxton | 54007 | 4109 | 45 | 0 | 38.70036159 | -80.72011184 | 2022-06-26 04:21:02 | Braxton, West Virginia, US | |
3350112 | 3350112 | 2022-06-24 | US | West Virginia | Braxton | 54007 | 4109 | 45 | 0 | 38.70036159 | -80.72011184 | 2022-06-25 04:20:57 | Braxton, West Virginia, US | |
3186350 | 3186350 | 2022-05-30 | US | Alabama | Clay | 1027 | 4109 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-05-31 04:20:51 | Clay, Alabama, US | |
3198499 | 3198499 | 2022-05-29 | US | Alabama | Clay | 1027 | 4109 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-05-30 04:20:50 | Clay, Alabama, US | |
2725377 | 2725377 | 2022-05-28 | US | Alabama | Clay | 1027 | 4109 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-05-29 04:20:53 | Clay, Alabama, US | |
1314558 | 1314558 | 2022-05-27 | US | Alabama | Clay | 1027 | 4109 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-05-28 04:21:07 | Clay, Alabama, US | |
3899555 | 3899555 | 2022-05-19 | US | Wisconsin | Washburn | 55129 | 4109 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-05-20 04:20:57 | Washburn, Wisconsin, US | |
3418317 | 3418317 | 2022-04-17 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-18 04:21:12 | Estill, Kentucky, US | |
305266 | 305266 | 2022-04-16 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-17 04:20:59 | Estill, Kentucky, US | |
2671211 | 2671211 | 2022-04-15 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-16 04:20:48 | Estill, Kentucky, US | |
1224996 | 1224996 | 2022-04-14 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-15 04:20:57 | Estill, Kentucky, US | |
2444154 | 2444154 | 2022-04-13 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-13 23:21:06 | Estill, Kentucky, US | |
1949911 | 1949911 | 2022-04-12 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-13 04:21:03 | Estill, Kentucky, US | |
3207664 | 3207664 | 2022-04-11 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-12 04:20:49 | Estill, Kentucky, US | |
1577550 | 1577550 | 2022-04-10 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-11 04:21:02 | Estill, Kentucky, US | |
1653792 | 1653792 | 2022-04-09 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-10 04:20:52 | Estill, Kentucky, US | |
2117114 | 2117114 | 2022-04-08 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-09 04:20:42 | Estill, Kentucky, US | |
3321638 | 3321638 | 2022-04-07 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-08 04:20:48 | Estill, Kentucky, US | |
2802174 | 2802174 | 2022-04-06 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-07 04:20:53 | Estill, Kentucky, US | |
3868943 | 3868943 | 2022-04-05 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-06 04:20:49 | Estill, Kentucky, US | |
2750285 | 2750285 | 2022-04-04 | US | Kentucky | Estill | 21065 | 4109 | 45 | 0 | 37.69241417 | -83.95956369 | 2022-04-05 04:20:48 | Estill, Kentucky, US | |
3630262 | 3630262 | 2022-03-13 | US | North Carolina | Chowan | 37041 | 4109 | 54 | 0 | 36.12908077 | -76.60118385 | 2022-03-14 04:20:46 | Chowan, North Carolina, US | |
953170 | 953170 | 2022-03-12 | US | North Carolina | Chowan | 37041 | 4109 | 54 | 0 | 36.12908077 | -76.60118385 | 2022-03-13 04:20:49 | Chowan, North Carolina, US | |
358631 | 358631 | 2022-03-11 | US | North Carolina | Chowan | 37041 | 4109 | 54 | 0 | 36.12908077 | -76.60118385 | 2022-03-12 04:20:50 | Chowan, North Carolina, US | |
1867783 | 1867783 | 2022-03-10 | US | North Carolina | Chowan | 37041 | 4109 | 54 | 0 | 36.12908077 | -76.60118385 | 2022-03-11 04:20:50 | Chowan, North Carolina, US | |
2140933 | 2140933 | 2022-03-09 | US | Georgia | Brantley | 13025 | 4109 | 103 | 0 | 31.19576557 | -81.97743999 | 2022-03-10 04:20:48 | Brantley, Georgia, US | |
920858 | 920858 | 2022-03-08 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-09 04:20:59 | Cedar, Iowa, US | |
1549145 | 1549145 | 2022-03-07 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-08 04:20:54 | Cedar, Iowa, US | |
2200814 | 2200814 | 2022-03-06 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-07 04:20:47 | Cedar, Iowa, US | |
2093271 | 2093271 | 2022-03-05 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-06 04:20:49 | Cedar, Iowa, US | |
2666971 | 2666971 | 2022-03-04 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-05 04:21:10 | Cedar, Iowa, US | |
1645536 | 1645536 | 2022-03-03 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-04 04:21:09 | Cedar, Iowa, US | |
2526539 | 2526539 | 2022-03-02 | US | Iowa | Cedar | 19031 | 4109 | 33 | 0 | 41.77233777 | -91.13246684 | 2022-03-03 04:21:01 | Cedar, Iowa, US | |
944708 | 944708 | 2022-02-28 | US | Missouri | Benton | 29015 | 4109 | 90 | 0 | 38.29503305 | -93.28756116 | 2022-03-01 04:21:09 | Benton, Missouri, US | |
3822332 | 3822332 | 2022-02-16 | US | Missouri | Cooper | 29053 | 4109 | 73 | 0 | 38.844478 | -92.80896081 | 2022-02-17 04:20:56 | Cooper, Missouri, US | |
187549 | 187549 | 2022-02-13 | US | Kentucky | Union | 21225 | 4109 | 53 | 0 | 37.66166713 | -87.94300009 | 2022-02-14 04:20:51 | Union, Kentucky, US | |
317395 | 317395 | 2022-02-12 | US | Kentucky | Union | 21225 | 4109 | 53 | 0 | 37.66166713 | -87.94300009 | 2022-02-13 04:21:00 | Union, Kentucky, US | |
234721 | 234721 | 2022-02-11 | US | Kentucky | Union | 21225 | 4109 | 53 | 0 | 37.66166713 | -87.94300009 | 2022-02-12 04:21:06 | Union, Kentucky, US | |
3077199 | 3077199 | 2022-02-09 | US | Texas | Lavaca | 48285 | 4109 | 107 | 0 | 29.38508402 | -96.93186692 | 2022-02-10 04:21:14 | Lavaca, Texas, US | |
2016138 | 2016138 | 2022-02-06 | US | Washington | Asotin | 53003 | 4109 | 56 | 0 | 46.18894415 | -117.2022851 | 2022-02-07 04:21:05 | Asotin, Washington, US | |
2015471 | 2015471 | 2022-02-06 | US | Puerto Rico | Morovis | 72101 | 4109 | 0 | 0 | 18.316963 | -66.420383 | 2022-02-07 04:21:05 | Morovis, Puerto Rico, US | |
1297467 | 1297467 | 2022-02-05 | US | Washington | Asotin | 53003 | 4109 | 56 | 0 | 46.18894415 | -117.2022851 | 2022-02-06 04:21:00 | Asotin, Washington, US | |
2330795 | 2330795 | 2022-02-04 | US | Washington | Asotin | 53003 | 4109 | 56 | 0 | 46.18894415 | -117.2022851 | 2022-02-05 04:21:05 | Asotin, Washington, US | |
2658785 | 2658785 | 2022-01-31 | US | Illinois | Hancock | 17067 | 4109 | 43 | 0 | 40.40423981 | -91.16313899 | 2022-02-01 04:21:11 | Hancock, Illinois, US | |
3813403 | 3813403 | 2022-01-28 | US | West Virginia | Barbour | 54001 | 4109 | 63 | 0 | 39.1307219 | -80.00350858 | 2022-01-29 04:21:10 | Barbour, West Virginia, US | |
2836327 | 2836327 | 2022-01-22 | US | West Virginia | McDowell | 54047 | 4109 | 57 | 0 | 37.38002939 | -81.65083669 | 2022-01-23 04:21:13 | McDowell, West Virginia, US | |
2832820 | 2832820 | 2022-01-22 | Japan | Fukui | 4109 | 38 | 0 | 35.846614 | 136.22465400000002 | 2022-01-23 04:21:13 | Fukui, Japan | |||
3228176 | 3228176 | 2022-01-19 | US | Minnesota | Hubbard | 27057 | 4109 | 52 | 0 | 47.10778564 | -94.91693868 | 2022-01-20 04:21:07 | Hubbard, Minnesota, US | |
3464699 | 3464699 | 2022-01-18 | US | Arkansas | Randolph | 5121 | 4109 | 69 | 0 | 36.3415714 | -91.02455531 | 2022-01-19 04:21:23 | Randolph, Arkansas, US | |
1117180 | 1117180 | 2022-01-11 | US | Wisconsin | Vilas | 55125 | 4109 | 77 | 0 | 46.05467334 | -89.51719204 | 2022-01-12 04:21:44 | Vilas, Wisconsin, US | |
3831995 | 3831995 | 2021-12-21 | US | West Virginia | Wyoming | 54109 | 4109 | 76 | 0 | 37.612327 | -81.54511071 | 2021-12-22 04:21:54 | Wyoming, West Virginia, US | |
2907123 | 2907123 | 2021-12-19 | US | Virginia | Salem | 51775 | 4109 | 81 | 0 | 37.2836193 | -80.06219455 | 2021-12-20 04:21:43 | Salem, Virginia, US | |
2906504 | 2906504 | 2021-12-19 | US | Puerto Rico | Vega Baja | 72145 | 4109 | 0 | 0 | 18.428262 | -66.397924 | 2021-12-20 04:21:43 | Vega Baja, Puerto Rico, US | |
1262196 | 1262196 | 2021-12-18 | US | Virginia | Salem | 51775 | 4109 | 81 | 0 | 37.2836193 | -80.06219455 | 2021-12-19 04:21:11 | Salem, Virginia, US | |
2402224 | 2402224 | 2021-12-17 | US | Virginia | Salem | 51775 | 4109 | 81 | 0 | 37.2836193 | -80.06219455 | 2021-12-18 02:22:20 | Salem, Virginia, US | |
1719907 | 1719907 | 2021-12-16 | US | Wisconsin | Jackson | 55053 | 4109 | 36 | 0 | 44.31864893 | -90.80566792 | 2021-12-17 04:22:14 | Jackson, Wisconsin, US | |
783438 | 783438 | 2021-12-13 | US | Illinois | Shelby | 17173 | 4109 | 54 | 0 | 39.39133527 | -88.80611122 | 2021-12-14 04:22:38 | Shelby, Illinois, US | |
1666919 | 1666919 | 2021-12-11 | US | Ohio | Holmes | 39075 | 4109 | 153 | 0 | 40.56163713 | -81.92635677 | 2021-12-12 04:22:12 | Holmes, Ohio, US | |
3290887 | 3290887 | 2021-11-18 | US | Missouri | Stone | 29209 | 4109 | 87 | 0 | 36.75000327 | -93.45256475 | 2021-11-19 04:21:40 | Stone, Missouri, US | |
1324843 | 1324843 | 2021-11-14 | US | Oregon | Columbia | 41009 | 4109 | 49 | 0 | 45.94464254 | -123.08908980000001 | 2021-11-15 04:21:36 | Columbia, Oregon, US | |
688969 | 688969 | 2021-11-13 | US | Oregon | Columbia | 41009 | 4109 | 49 | 0 | 45.94464254 | -123.08908980000001 | 2021-11-14 04:21:31 | Columbia, Oregon, US | |
717078 | 717078 | 2021-11-12 | US | Oregon | Columbia | 41009 | 4109 | 49 | 0 | 45.94464254 | -123.08908980000001 | 2021-11-13 04:21:38 | Columbia, Oregon, US | |
30937 | 30937 | 2021-11-11 | US | Ohio | Van Wert | 39161 | 4109 | 92 | 0 | 40.8554138 | -84.59111700000003 | 2021-11-12 04:22:01 | Van Wert, Ohio, US | |
700364 | 700364 | 2021-11-04 | US | Missouri | Saline | 29195 | 4109 | 48 | 0 | 39.13734288 | -93.20259964 | 2021-11-05 04:21:54 | Saline, Missouri, 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]);