johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
187 rows where confirmed = 4112 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
293225 | 293225 | 2022-11-15 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-16 04:21:09 | Jefferson, Iowa, US | |
3598255 | 3598255 | 2022-11-14 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-15 04:21:16 | Jefferson, Iowa, US | |
313113 | 313113 | 2022-11-13 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-14 04:21:09 | Jefferson, Iowa, US | |
64274 | 64274 | 2022-11-12 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-13 04:21:14 | Jefferson, Iowa, US | |
2928436 | 2928436 | 2022-11-11 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-12 04:20:41 | Jefferson, Iowa, US | |
2507272 | 2507272 | 2022-11-10 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-11 04:21:22 | Jefferson, Iowa, US | |
2432147 | 2432147 | 2022-11-09 | US | Iowa | Jefferson | 19101 | 4112 | 55 | 0 | 41.03192394 | -91.94849466 | 2022-11-10 04:21:16 | Jefferson, Iowa, US | |
3279894 | 3279894 | 2022-10-23 | US | Texas | Bandera | 48019 | 4112 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-10-24 04:22:29 | Bandera, Texas, US | |
2270932 | 2270932 | 2022-10-22 | US | Texas | Bandera | 48019 | 4112 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-10-23 04:22:46 | Bandera, Texas, US | |
1595232 | 1595232 | 2022-10-21 | US | Texas | Bandera | 48019 | 4112 | 80 | 0 | 29.74619598 | -99.24598147 | 2022-10-22 04:22:53 | Bandera, Texas, US | |
2275083 | 2275083 | 2022-10-20 | US | Texas | Leon | 48289 | 4112 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-21 04:22:23 | Leon, Texas, US | |
201418 | 201418 | 2022-10-19 | US | Texas | Leon | 48289 | 4112 | 95 | 0 | 31.29872538 | -95.9936328 | 2022-10-20 04:22:59 | Leon, Texas, US | |
2163065 | 2163065 | 2022-10-16 | US | Wisconsin | Bayfield | 55007 | 4112 | 44 | 0 | 46.52868768 | -91.19716729 | 2022-10-17 04:20:31 | Bayfield, Wisconsin, US | |
519262 | 519262 | 2022-10-15 | US | Wisconsin | Bayfield | 55007 | 4112 | 44 | 0 | 46.52868768 | -91.19716729 | 2022-10-16 04:22:39 | Bayfield, Wisconsin, US | |
2036319 | 2036319 | 2022-10-14 | US | Wisconsin | Bayfield | 55007 | 4112 | 44 | 0 | 46.52868768 | -91.19716729 | 2022-10-15 04:22:00 | Bayfield, Wisconsin, US | |
2020177 | 2020177 | 2022-09-20 | US | Washington | Klickitat | 53039 | 4112 | 53 | 0 | 45.87325839 | -120.7913598 | 2022-09-21 04:23:22 | Klickitat, Washington, US | |
3574050 | 3574050 | 2022-09-19 | US | Washington | Klickitat | 53039 | 4112 | 53 | 0 | 45.87325839 | -120.7913598 | 2022-09-20 04:22:48 | Klickitat, Washington, US | |
2494520 | 2494520 | 2022-08-15 | US | Arkansas | Franklin | 5047 | 4112 | 74 | 0 | 35.51202821 | -93.89299569 | 2022-08-16 04:20:58 | Franklin, Arkansas, US | |
1070950 | 1070950 | 2022-08-07 | US | Illinois | Wabash | 17185 | 4112 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-08-08 04:21:08 | Wabash, Illinois, US | |
1941538 | 1941538 | 2022-08-06 | US | Illinois | Wabash | 17185 | 4112 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-08-07 04:20:54 | Wabash, Illinois, US | |
881337 | 881337 | 2022-08-05 | US | Illinois | Wabash | 17185 | 4112 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-08-06 04:20:56 | Wabash, Illinois, US | |
3406480 | 3406480 | 2022-07-17 | US | Illinois | Massac | 17127 | 4112 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-07-18 04:20:59 | Massac, Illinois, US | |
2152680 | 2152680 | 2022-07-16 | US | Illinois | Massac | 17127 | 4112 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-07-17 04:21:15 | Massac, Illinois, US | |
2419913 | 2419913 | 2022-07-15 | US | Illinois | Massac | 17127 | 4112 | 71 | 0 | 37.22078441 | -88.71036614 | 2022-07-16 04:21:05 | Massac, Illinois, US | |
3113051 | 3113051 | 2022-07-13 | US | Wisconsin | Marquette | 55077 | 4112 | 62 | 0 | 43.81911946 | -89.40073763 | 2022-07-14 04:20:57 | Marquette, Wisconsin, US | |
1201568 | 1201568 | 2022-07-06 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-07 04:20:55 | Redwood, Minnesota, US | |
3968311 | 3968311 | 2022-07-05 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-06 04:20:58 | Redwood, Minnesota, US | |
3079822 | 3079822 | 2022-07-04 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-05 04:20:45 | Redwood, Minnesota, US | |
1769104 | 1769104 | 2022-07-03 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-04 04:20:54 | Redwood, Minnesota, US | |
3367090 | 3367090 | 2022-07-02 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-03 04:20:59 | Redwood, Minnesota, US | |
595419 | 595419 | 2022-07-01 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-02 04:21:16 | Redwood, Minnesota, US | |
3941820 | 3941820 | 2022-06-30 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-07-01 04:21:10 | Redwood, Minnesota, US | |
2491778 | 2491778 | 2022-06-29 | US | Minnesota | Redwood | 27127 | 4112 | 54 | 0 | 44.40555844 | -95.25207021 | 2022-06-30 04:21:01 | Redwood, Minnesota, US | |
2190880 | 2190880 | 2022-06-22 | US | Texas | Zavala | 48507 | 4112 | 68 | 0 | 28.86617238 | -99.76050829 | 2022-06-23 04:20:55 | Zavala, Texas, US | |
169311 | 169311 | 2022-06-21 | US | Texas | Zavala | 48507 | 4112 | 68 | 0 | 28.86617238 | -99.76050829 | 2022-06-22 04:20:54 | Zavala, Texas, US | |
229585 | 229585 | 2022-05-31 | US | Alabama | Clay | 1027 | 4112 | 82 | 0 | 33.26984193 | -85.85836077 | 2022-06-01 04:20:55 | Clay, Alabama, US | |
2535821 | 2535821 | 2022-05-12 | US | North Dakota | Richland | 38077 | 4112 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-05-13 04:20:51 | Richland, North Dakota, US | |
3724050 | 3724050 | 2022-04-25 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-26 04:20:51 | Smith, Mississippi, US | |
2030618 | 2030618 | 2022-04-24 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-25 04:20:56 | Smith, Mississippi, US | |
748193 | 748193 | 2022-04-23 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-24 04:20:56 | Smith, Mississippi, US | |
3438678 | 3438678 | 2022-04-22 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-23 04:20:50 | Smith, Mississippi, US | |
2894263 | 2894263 | 2022-04-21 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-22 04:20:45 | Smith, Mississippi, US | |
2309135 | 2309135 | 2022-04-20 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-21 04:20:46 | Smith, Mississippi, US | |
2307759 | 2307759 | 2022-04-20 | US | Arkansas | Clay | 5021 | 4112 | 93 | 0 | 36.36826212 | -90.4148172 | 2022-04-21 04:20:46 | Clay, Arkansas, US | |
2253274 | 2253274 | 2022-04-19 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-20 04:20:45 | Smith, Mississippi, US | |
1847824 | 1847824 | 2022-04-18 | US | Mississippi | Smith | 28129 | 4112 | 68 | 0 | 32.01744532 | -89.50644846 | 2022-04-19 04:21:00 | Smith, Mississippi, US | |
1906396 | 1906396 | 2022-03-22 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-23 04:20:48 | Hardin, Iowa, US | |
3241001 | 3241001 | 2022-03-21 | US | Pennsylvania | Fulton | 42057 | 4112 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-03-22 04:20:54 | Fulton, Pennsylvania, US | |
3239527 | 3239527 | 2022-03-21 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-22 04:20:54 | Hardin, Iowa, US | |
27074 | 27074 | 2022-03-20 | US | Pennsylvania | Fulton | 42057 | 4112 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-03-21 04:20:50 | Fulton, Pennsylvania, US | |
25600 | 25600 | 2022-03-20 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-21 04:20:50 | Hardin, Iowa, US | |
1659084 | 1659084 | 2022-03-19 | US | Pennsylvania | Fulton | 42057 | 4112 | 65 | 0 | 39.92913544 | -78.11163677 | 2022-03-20 04:20:45 | Fulton, Pennsylvania, US | |
1657610 | 1657610 | 2022-03-19 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-20 04:20:45 | Hardin, Iowa, US | |
337136 | 337136 | 2022-03-18 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-19 04:20:47 | Hardin, Iowa, US | |
695589 | 695589 | 2022-03-17 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-18 04:20:55 | Hardin, Iowa, US | |
694908 | 694908 | 2022-03-17 | US | Arkansas | Polk | 5113 | 4112 | 146 | 0 | 34.48254879 | -94.22728802 | 2022-03-18 04:20:55 | Polk, Arkansas, US | |
2320532 | 2320532 | 2022-03-16 | US | Iowa | Hardin | 19083 | 4112 | 60 | 0 | 42.38353877 | -93.23654611 | 2022-03-17 04:20:56 | Hardin, Iowa, US | |
2527142 | 2527142 | 2022-03-02 | US | Minnesota | Wadena | 27159 | 4112 | 52 | 0 | 46.58589171 | -94.96968506 | 2022-03-03 04:21:01 | Wadena, Minnesota, US | |
1994436 | 1994436 | 2022-03-01 | US | Minnesota | Wadena | 27159 | 4112 | 52 | 0 | 46.58589171 | -94.96968506 | 2022-03-02 04:21:07 | Wadena, Minnesota, US | |
1296778 | 1296778 | 2022-02-05 | US | Puerto Rico | Guayama | 72057 | 4112 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-02-06 04:21:00 | Guayama, Puerto Rico, US | |
1319202 | 1319202 | 2022-01-26 | US | Illinois | Ford | 17053 | 4112 | 62 | 0 | 40.59706922 | -88.22350769 | 2022-01-27 04:21:19 | Ford, Illinois, US | |
2054574 | 2054574 | 2022-01-25 | US | Pennsylvania | Montour | 42093 | 4112 | 83 | 0 | 41.03023987 | -76.66345939 | 2022-01-26 04:21:07 | Montour, Pennsylvania, US | |
1962181 | 1962181 | 2022-01-20 | US | Michigan | Cheboygan | 26031 | 4112 | 85 | 0 | 45.44787015 | -84.50122149 | 2022-01-21 04:21:09 | Cheboygan, Michigan, US | |
3228076 | 3228076 | 2022-01-19 | US | Michigan | Cheboygan | 26031 | 4112 | 85 | 0 | 45.44787015 | -84.50122149 | 2022-01-20 04:21:07 | Cheboygan, Michigan, US | |
3688300 | 3688300 | 2022-01-13 | US | Georgia | Hart | 13147 | 4112 | 76 | 0 | 34.34626973 | -82.96567682 | 2022-01-14 04:21:54 | Hart, Georgia, US | |
3687984 | 3687984 | 2022-01-13 | US | Arkansas | Logan | 5083 | 4112 | 56 | 0 | 35.21413234 | -93.71951016 | 2022-01-14 04:21:54 | Logan, Arkansas, US | |
3613996 | 3613996 | 2022-01-12 | US | Idaho | Cassia | 16031 | 4112 | 47 | 0 | 42.28347888 | -113.6012409 | 2022-01-13 08:00:09 | Cassia, Idaho, US | |
128177 | 128177 | 2022-01-09 | US | Kentucky | McCreary | 21147 | 4112 | 66 | 0 | 36.73874143 | -84.48102924 | 2022-01-10 04:22:07 | McCreary, Kentucky, US | |
1217012 | 1217012 | 2022-01-08 | US | Kentucky | McCreary | 21147 | 4112 | 66 | 0 | 36.73874143 | -84.48102924 | 2022-01-09 04:21:46 | McCreary, Kentucky, US | |
1391105 | 1391105 | 2022-01-07 | US | Kentucky | McCreary | 21147 | 4112 | 66 | 0 | 36.73874143 | -84.48102924 | 2022-01-08 04:21:53 | McCreary, Kentucky, US | |
4002038 | 4002038 | 2021-12-30 | US | Virginia | Page | 51139 | 4112 | 92 | 0 | 38.61807452 | -78.48797204 | 2021-12-31 04:21:50 | Page, Virginia, US | |
1671822 | 1671822 | 2021-12-29 | US | Virginia | Lee | 51105 | 4112 | 67 | 0 | 36.70586667 | -83.12606515 | 2021-12-30 04:21:25 | Lee, Virginia, US | |
1670325 | 1670325 | 2021-12-29 | US | Missouri | Adair | 29001 | 4112 | 53 | 0 | 40.19058551 | -92.60078167 | 2021-12-30 04:21:25 | Adair, Missouri, US | |
1433934 | 1433934 | 2021-12-28 | US | Kentucky | Anderson | 21005 | 4112 | 57 | 0 | 38.00671029 | -84.99171713 | 2021-12-29 03:21:43 | Anderson, Kentucky, US | |
1256513 | 1256513 | 2021-12-20 | US | Minnesota | Martin | 27091 | 4112 | 50 | 0 | 43.67429718 | -94.55099908 | 2021-12-21 03:21:27 | Martin, Minnesota, US | |
3499281 | 3499281 | 2021-12-15 | US | Texas | Frio | 48163 | 4112 | 78 | 0 | 28.86751206 | -99.10804207 | 2021-12-16 04:22:11 | Frio, Texas, US | |
2091469 | 2091469 | 2021-12-14 | US | West Virginia | Mason | 54053 | 4112 | 63 | 0 | 38.77071799 | -82.02524219 | 2021-12-15 03:22:16 | Mason, West Virginia, US | |
2088447 | 2088447 | 2021-12-14 | US | Arkansas | Cleburne | 5023 | 4112 | 97 | 0 | 35.53864922 | -92.02640019 | 2021-12-15 03:22:16 | Cleburne, Arkansas, US | |
1662903 | 1662903 | 2021-12-12 | US | Ohio | Holmes | 39075 | 4112 | 153 | 0 | 40.56163713 | -81.92635677 | 2021-12-13 04:22:02 | Holmes, Ohio, US | |
1617 | 1617 | 2021-12-02 | US | Kansas | Franklin | 20059 | 4112 | 63 | 0 | 38.56443815 | -95.28644341 | 2021-12-03 04:23:05 | Franklin, Kansas, US | |
1146799 | 1146799 | 2021-12-01 | US | Missouri | Audrain | 29007 | 4112 | 65 | 0 | 39.215877 | -91.84242683 | 2021-12-02 04:22:37 | Audrain, Missouri, US | |
1146216 | 1146216 | 2021-12-01 | US | Kansas | Franklin | 20059 | 4112 | 63 | 0 | 38.56443815 | -95.28644341 | 2021-12-02 04:22:37 | Franklin, Kansas, US | |
152295 | 152295 | 2021-11-29 | US | North Carolina | Dare | 37055 | 4112 | 15 | 0 | 35.66520691 | -75.71767334 | 2021-11-30 04:22:53 | Dare, North Carolina, US | |
3749552 | 3749552 | 2021-11-22 | US | Alaska | Juneau | 2110 | 4112 | 14 | 0 | 58.45031811 | -134.200436 | 2021-11-23 04:22:39 | Juneau, Alaska, US | |
164502 | 164502 | 2021-11-19 | US | Ohio | Henry | 39069 | 4112 | 80 | 0 | 41.333964200000004 | -84.06830637 | 2021-11-20 04:22:17 | Henry, Ohio, US | |
3291634 | 3291634 | 2021-11-18 | US | Puerto Rico | Arecibo | 72013 | 4112 | 0 | 0 | 18.406631 | -66.675077 | 2021-11-19 04:21:40 | Arecibo, Puerto Rico, US | |
2290638 | 2290638 | 2021-11-15 | US | Texas | Moore | 48341 | 4112 | 88 | 0 | 35.83769242 | -101.8930281 | 2021-11-16 04:21:10 | Moore, Texas, US | |
1325412 | 1325412 | 2021-11-14 | US | Texas | Moore | 48341 | 4112 | 88 | 0 | 35.83769242 | -101.8930281 | 2021-11-15 04:21:36 | Moore, Texas, US | |
1325237 | 1325237 | 2021-11-14 | US | Tennessee | Wayne | 47181 | 4112 | 39 | 0 | 35.23868267 | -87.78644456 | 2021-11-15 04:21:36 | Wayne, Tennessee, US | |
689538 | 689538 | 2021-11-13 | US | Texas | Moore | 48341 | 4112 | 88 | 0 | 35.83769242 | -101.8930281 | 2021-11-14 04:21:31 | Moore, Texas, US | |
689363 | 689363 | 2021-11-13 | US | Tennessee | Wayne | 47181 | 4112 | 39 | 0 | 35.23868267 | -87.78644456 | 2021-11-14 04:21:31 | Wayne, Tennessee, US | |
30042 | 30042 | 2021-11-11 | US | Michigan | Clare | 26035 | 4112 | 110 | 0 | 43.98794227 | -84.84819859999998 | 2021-11-12 04:22:01 | Clare, Michigan, US | |
2846481 | 2846481 | 2021-11-10 | US | Michigan | Clare | 26035 | 4112 | 110 | 0 | 43.98794227 | -84.84819859999998 | 2021-11-11 04:21:45 | Clare, Michigan, US | |
2723786 | 2723786 | 2021-10-30 | US | Puerto Rico | Unassigned | 72999 | 4112 | 3232 | 0 | 18.459681 | -67.336525 | 2021-10-31 04:22:08 | Unassigned, Puerto Rico, US | |
569888 | 569888 | 2021-10-29 | US | Puerto Rico | Unassigned | 72999 | 4112 | 3229 | 0 | 18.459681 | -67.336525 | 2021-10-30 04:22:03 | Unassigned, Puerto Rico, US | |
3797291 | 3797291 | 2021-10-25 | US | Virginia | Pulaski | 51155 | 4112 | 88 | 0 | 37.06474963 | -80.71229738 | 2021-10-26 04:22:09 | Pulaski, Virginia, US | |
3796994 | 3796994 | 2021-10-25 | US | Texas | Gray | 48179 | 4112 | 79 | 0 | 35.40081878 | -100.8129222 | 2021-10-26 04:22:09 | Gray, Texas, US | |
685440 | 685440 | 2021-10-24 | US | Texas | Gray | 48179 | 4112 | 79 | 0 | 35.40081878 | -100.8129222 | 2021-10-25 04:22:31 | Gray, Texas, US | |
773448 | 773448 | 2021-10-23 | US | Texas | Gray | 48179 | 4112 | 79 | 0 | 35.40081878 | -100.8129222 | 2021-10-24 04:21:22 | Gray, Texas, US | |
444919 | 444919 | 2021-10-20 | US | Maine | Somerset | 23025 | 4112 | 45 | 0 | 45.51229767 | -69.95995554 | 2021-10-21 04:21:18 | Somerset, Maine, 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]);