johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
167 rows where confirmed = 3802 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454349 | 454349 | 2022-12-21 | US | Tennessee | Jackson | 47087 | 3802 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-12-22 04:20:56 | Jackson, Tennessee, US | |
2758121 | 2758121 | 2022-10-18 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-19 04:22:26 | Hamilton, Iowa, US | |
2025955 | 2025955 | 2022-10-17 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-18 04:22:42 | Hamilton, Iowa, US | |
2160733 | 2160733 | 2022-10-16 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-17 04:20:31 | Hamilton, Iowa, US | |
516930 | 516930 | 2022-10-15 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-16 04:22:39 | Hamilton, Iowa, US | |
2033987 | 2033987 | 2022-10-14 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-15 04:22:00 | Hamilton, Iowa, US | |
3754675 | 3754675 | 2022-10-13 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-14 04:22:28 | Hamilton, Iowa, US | |
3215500 | 3215500 | 2022-10-12 | US | Iowa | Hamilton | 19079 | 3802 | 79 | 0 | 42.38382428 | -93.70197703 | 2022-10-13 04:22:39 | Hamilton, Iowa, US | |
2968389 | 2968389 | 2022-10-10 | US | Illinois | Cumberland | 17035 | 3802 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-10-11 04:23:05 | Cumberland, Illinois, US | |
3098425 | 3098425 | 2022-10-09 | US | Illinois | Cumberland | 17035 | 3802 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-10-10 04:22:32 | Cumberland, Illinois, US | |
4003650 | 4003650 | 2022-10-08 | US | Illinois | Cumberland | 17035 | 3802 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-10-09 04:21:16 | Cumberland, Illinois, US | |
397247 | 397247 | 2022-10-07 | US | Illinois | Cumberland | 17035 | 3802 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-10-08 04:22:56 | Cumberland, Illinois, US | |
375625 | 375625 | 2022-09-13 | US | Virginia | Westmoreland | 51193 | 3802 | 56 | 0 | 38.11021557 | -76.80213247 | 2022-09-14 04:20:44 | Westmoreland, Virginia, US | |
374636 | 374636 | 2022-09-13 | US | North Dakota | Walsh | 38099 | 3802 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-09-14 04:20:44 | Walsh, North Dakota, US | |
1089450 | 1089450 | 2022-08-09 | US | Virginia | Martinsville | 51690 | 3802 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-08-10 04:20:57 | Martinsville, Virginia, US | |
1068936 | 1068936 | 2022-07-28 | US | Texas | Comanche | 48093 | 3802 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-07-29 04:20:45 | Comanche, Texas, US | |
3406082 | 3406082 | 2022-07-17 | US | Colorado | Grand | 8049 | 3802 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-07-18 04:20:59 | Grand, Colorado, US | |
2152282 | 2152282 | 2022-07-16 | US | Colorado | Grand | 8049 | 3802 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-07-17 04:21:15 | Grand, Colorado, US | |
2419515 | 2419515 | 2022-07-15 | US | Colorado | Grand | 8049 | 3802 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-07-16 04:21:05 | Grand, Colorado, US | |
2188025 | 2188025 | 2022-06-22 | US | Alabama | Washington | 1129 | 3802 | 59 | 0 | 31.4092794 | -88.20689944 | 2022-06-23 04:20:55 | Washington, Alabama, US | |
3269896 | 3269896 | 2022-06-19 | US | Alabama | Lamar | 1075 | 3802 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-06-20 04:21:01 | Lamar, Alabama, US | |
3397919 | 3397919 | 2022-06-18 | US | Arkansas | Howard | 5061 | 3802 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-06-19 04:20:51 | Howard, Arkansas, US | |
3397808 | 3397808 | 2022-06-18 | US | Alabama | Lamar | 1075 | 3802 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-06-19 04:20:51 | Lamar, Alabama, US | |
2311796 | 2311796 | 2022-06-17 | US | Arkansas | Howard | 5061 | 3802 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-06-18 04:21:10 | Howard, Arkansas, US | |
2311685 | 2311685 | 2022-06-17 | US | Alabama | Lamar | 1075 | 3802 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-06-18 04:21:10 | Lamar, Alabama, US | |
230440 | 230440 | 2022-05-31 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-06-01 04:20:55 | Kossuth, Iowa, US | |
3187205 | 3187205 | 2022-05-30 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-31 04:20:51 | Kossuth, Iowa, US | |
3199354 | 3199354 | 2022-05-29 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-30 04:20:50 | Kossuth, Iowa, US | |
2726232 | 2726232 | 2022-05-28 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-29 04:20:53 | Kossuth, Iowa, US | |
1315413 | 1315413 | 2022-05-27 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-28 04:21:07 | Kossuth, Iowa, US | |
1851205 | 1851205 | 2022-05-26 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-27 04:20:56 | Kossuth, Iowa, US | |
2050952 | 2050952 | 2022-05-25 | US | Texas | Falls | 48145 | 3802 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-05-26 04:20:50 | Falls, Texas, US | |
2049081 | 2049081 | 2022-05-25 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-26 04:20:50 | Kossuth, Iowa, US | |
624963 | 624963 | 2022-05-22 | US | Texas | Falls | 48145 | 3802 | 65 | 0 | 31.25350609 | -96.93630086 | 2022-05-26 04:20:50 | Falls, Texas, US | |
623092 | 623092 | 2022-05-22 | US | Iowa | Kossuth | 19109 | 3802 | 88 | 0 | 43.20405458 | -94.20691791 | 2022-05-26 04:20:50 | Kossuth, Iowa, US | |
3447565 | 3447565 | 2022-05-11 | US | Puerto Rico | Barceloneta | 72017 | 3802 | 0 | 0 | 18.445533 | -66.560531 | 2022-05-12 04:20:54 | Barceloneta, Puerto Rico, US | |
1573854 | 1573854 | 2022-05-03 | US | Minnesota | Faribault | 27043 | 3802 | 51 | 0 | 43.67381499 | -93.94787458 | 2022-05-04 04:20:59 | Faribault, Minnesota, US | |
466409 | 466409 | 2022-05-02 | US | Texas | Andrews | 48003 | 3802 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-05-03 04:21:00 | Andrews, Texas, US | |
465513 | 465513 | 2022-05-02 | US | Nebraska | Saline | 31151 | 3802 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-05-03 04:21:00 | Saline, Nebraska, US | |
3918152 | 3918152 | 2022-05-01 | US | Nebraska | Saline | 31151 | 3802 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-05-02 04:21:10 | Saline, Nebraska, US | |
2842956 | 2842956 | 2022-04-30 | US | Nebraska | Saline | 31151 | 3802 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-05-01 04:20:57 | Saline, Nebraska, US | |
2031825 | 2031825 | 2022-04-24 | US | Texas | Colorado | 48089 | 3802 | 63 | 0 | 29.622097999999998 | -96.5273805 | 2022-04-25 04:20:56 | Colorado, Texas, US | |
2251790 | 2251790 | 2022-04-19 | US | Alabama | Crenshaw | 1041 | 3802 | 99 | 0 | 31.72941803 | -86.31593104 | 2022-04-20 04:20:45 | Crenshaw, Alabama, US | |
1908484 | 1908484 | 2022-03-22 | US | Vermont | Lamoille | 50015 | 3802 | 17 | 0 | 44.60353043 | -72.64356694 | 2022-03-23 04:20:48 | Lamoille, Vermont, US | |
2142109 | 2142109 | 2022-03-09 | US | Missouri | Moniteau | 29135 | 3802 | 55 | 0 | 38.63571781 | -92.57976951 | 2022-03-10 04:20:48 | Moniteau, Missouri, US | |
1994643 | 1994643 | 2022-03-01 | US | Missouri | Wright | 29229 | 3802 | 77 | 0 | 37.27029221 | -92.46914488 | 2022-03-02 04:21:07 | Wright, Missouri, US | |
944817 | 944817 | 2022-02-28 | US | Missouri | Wright | 29229 | 3802 | 75 | 0 | 37.27029221 | -92.46914488 | 2022-03-01 04:21:09 | Wright, Missouri, US | |
1299440 | 1299440 | 2022-02-17 | US | Kentucky | Casey | 21045 | 3802 | 66 | 0 | 37.32533118 | -84.92726209 | 2022-02-18 04:21:04 | Casey, Kentucky, US | |
189162 | 189162 | 2022-02-13 | US | Texas | Freestone | 48161 | 3802 | 81 | 0 | 31.70422788 | -96.15072516 | 2022-02-14 04:20:51 | Freestone, Texas, US | |
460872 | 460872 | 2022-02-02 | US | Louisiana | Bienville | 22013 | 3802 | 102 | 0 | 32.34569994 | -93.05398492 | 2022-02-03 04:21:21 | Bienville, Louisiana, US | |
1781110 | 1781110 | 2022-01-27 | US | Minnesota | Houston | 27055 | 3802 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-01-28 04:21:09 | Houston, Minnesota, US | |
3841154 | 3841154 | 2022-01-15 | US | Colorado | Otero | 8089 | 3802 | 121 | 0 | 37.9014485 | -103.7173385 | 2022-01-16 04:21:12 | Otero, Colorado, US | |
3689920 | 3689920 | 2022-01-13 | US | Northern Mariana Islands | 69 | 3802 | 20 | 0 | 15.0979 | 145.6739 | 2022-01-14 04:21:54 | Northern Mariana Islands, US | ||
129492 | 129492 | 2022-01-09 | US | Puerto Rico | Manati | 72091 | 3802 | 0 | 0 | 18.420473 | -66.490461 | 2022-01-10 04:22:07 | Manati, Puerto Rico, US | |
3829233 | 3829233 | 2021-12-21 | US | Georgia | Burke | 13033 | 3802 | 86 | 0 | 33.05917989 | -81.99928721 | 2021-12-22 04:21:54 | Burke, Georgia, US | |
1255276 | 1255276 | 2021-12-20 | US | Arkansas | Logan | 5083 | 3802 | 53 | 0 | 35.21413234 | -93.71951016 | 2021-12-21 03:21:27 | Logan, Arkansas, US | |
784106 | 784106 | 2021-12-13 | US | Minnesota | Dodge | 27039 | 3802 | 12 | 0 | 44.02238415 | -92.86244324 | 2021-12-14 04:22:38 | Dodge, Minnesota, US | |
448024 | 448024 | 2021-11-17 | US | Colorado | Routt | 8107 | 3802 | 24 | 0 | 40.48596505 | -106.9905548 | 2021-11-18 04:21:33 | Routt, Colorado, US | |
3640371 | 3640371 | 2021-11-08 | US | Georgia | Harris | 13145 | 3802 | 88 | 0 | 32.73709786 | -84.90538572 | 2021-11-09 04:21:36 | Harris, Georgia, US | |
2001479 | 2001479 | 2021-11-07 | US | Georgia | Harris | 13145 | 3802 | 88 | 0 | 32.73709786 | -84.90538572 | 2021-11-08 04:21:43 | Harris, Georgia, US | |
496470 | 496470 | 2021-11-06 | US | Georgia | Harris | 13145 | 3802 | 88 | 0 | 32.73709786 | -84.90538572 | 2021-11-07 04:21:53 | Harris, Georgia, US | |
3122325 | 3122325 | 2021-11-05 | US | Georgia | Harris | 13145 | 3802 | 88 | 0 | 32.73709786 | -84.90538572 | 2021-11-06 04:21:51 | Harris, Georgia, US | |
277205 | 277205 | 2021-11-03 | US | Illinois | McDonough | 17109 | 3802 | 65 | 0 | 40.45674722 | -90.67775541 | 2021-11-04 04:22:20 | McDonough, Illinois, US | |
568232 | 568232 | 2021-10-29 | US | Indiana | Posey | 18129 | 3802 | 44 | 0 | 38.02097333 | -87.86480429 | 2021-10-30 04:22:03 | Posey, Indiana, US | |
5224 | 5224 | 2021-10-28 | US | Georgia | Tattnall | 13267 | 3802 | 106 | 0 | 32.04785085 | -82.05539188 | 2021-10-29 04:22:03 | Tattnall, Georgia, US | |
3797184 | 3797184 | 2021-10-25 | US | Vermont | Rutland | 50021 | 3802 | 28 | 0 | 43.57723578 | -73.03741676 | 2021-10-26 04:22:09 | Rutland, Vermont, US | |
3796872 | 3796872 | 2021-10-25 | US | Tennessee | Morgan | 47129 | 3802 | 48 | 0 | 36.13248031 | -84.64880098 | 2021-10-26 04:22:09 | Morgan, Tennessee, US | |
685291 | 685291 | 2021-10-24 | US | Tennessee | Haywood | 47075 | 3802 | 76 | 0 | 35.58332824 | -89.28536625 | 2021-10-25 04:22:31 | Haywood, Tennessee, US | |
773299 | 773299 | 2021-10-23 | US | Tennessee | Haywood | 47075 | 3802 | 76 | 0 | 35.58332824 | -89.28536625 | 2021-10-24 04:21:22 | Haywood, Tennessee, US | |
446154 | 446154 | 2021-10-20 | US | South Carolina | Abbeville | 45001 | 3802 | 49 | 0 | 34.22333378 | -82.46170658 | 2021-10-21 04:21:18 | Abbeville, South Carolina, US | |
470079 | 470079 | 2021-10-07 | US | Pennsylvania | Elk | 42047 | 3802 | 50 | 0 | 41.42822061 | -78.64524744 | 2021-10-08 04:21:25 | Elk, Pennsylvania, US | |
2774556 | 2774556 | 2021-09-30 | US | Maryland | Dorchester | 24019 | 3802 | 73 | 0 | 38.45413522 | -76.02752426 | 2021-10-01 04:21:35 | Dorchester, Maryland, US | |
3760130 | 3760130 | 2021-09-21 | US | Pennsylvania | Clarion | 42031 | 3802 | 100 | 0 | 41.19265812 | -79.42413524 | 2021-09-22 04:21:45 | Clarion, Pennsylvania, US | |
3759403 | 3759403 | 2021-09-21 | US | Missouri | Miller | 29131 | 3802 | 73 | 0 | 38.21450288 | -92.42610898 | 2021-09-22 04:21:45 | Miller, Missouri, US | |
2465674 | 2465674 | 2021-09-14 | US | South Dakota | Lawrence | 46081 | 3802 | 52 | 0 | 44.35919441 | -103.79294279999999 | 2021-09-15 03:22:37 | Lawrence, South Dakota, US | |
3451078 | 3451078 | 2021-09-10 | US | New York | Greene | 36039 | 3802 | 82 | 0 | 42.275797 | -74.12384884 | 2021-09-11 04:21:30 | Greene, New York, US | |
2280859 | 2280859 | 2021-09-08 | US | Minnesota | Carlton | 27017 | 3802 | 59 | 0 | 46.59180601 | -92.67601019 | 2021-09-09 04:21:27 | Carlton, Minnesota, US | |
2069636 | 2069636 | 2021-08-31 | US | Minnesota | Lyon | 27083 | 3802 | 54 | 0 | 44.41327865 | -95.83806103 | 2021-09-01 04:21:38 | Lyon, Minnesota, US | |
246330 | 246330 | 2021-08-17 | US | Indiana | Adams | 18001 | 3802 | 56 | 0 | 40.7457653 | -84.93671406 | 2021-08-18 04:21:35 | Adams, Indiana, US | |
106909 | 106909 | 2021-08-15 | US | Wisconsin | Trempealeau | 55121 | 3802 | 49 | 0 | 44.30360275 | -91.35893614 | 2021-08-16 04:21:31 | Trempealeau, Wisconsin, US | |
511267 | 511267 | 2021-08-14 | US | Wisconsin | Trempealeau | 55121 | 3802 | 49 | 0 | 44.30360275 | -91.35893614 | 2021-08-15 04:21:41 | Trempealeau, Wisconsin, US | |
1487139 | 1487139 | 2021-08-13 | US | Wisconsin | Trempealeau | 55121 | 3802 | 49 | 0 | 44.30360275 | -91.35893614 | 2021-08-14 04:21:25 | Trempealeau, Wisconsin, US | |
2354968 | 2354968 | 2021-08-10 | US | Wisconsin | Clark | 55019 | 3802 | 66 | 0 | 44.73483377 | -90.61207486 | 2021-08-11 04:21:58 | Clark, Wisconsin, US | |
3469058 | 3469058 | 2021-08-03 | US | Georgia | Toombs | 13279 | 3802 | 121 | 0 | 32.12059861 | -82.32957247 | 2021-08-04 04:21:25 | Toombs, Georgia, US | |
3479315 | 3479315 | 2021-07-22 | US | Tennessee | White | 47185 | 3802 | 74 | 0 | 35.92929884 | -85.45591799 | 2021-07-23 04:21:29 | White, Tennessee, US | |
3660556 | 3660556 | 2021-07-11 | US | Illinois | Bureau | 17011 | 3802 | 85 | 0 | 41.40385234 | -89.5283051 | 2021-07-12 04:21:34 | Bureau, Illinois, US | |
626840 | 626840 | 2021-07-10 | US | Illinois | Bureau | 17011 | 3802 | 85 | 0 | 41.40385234 | -89.5283051 | 2021-07-11 04:21:43 | Bureau, Illinois, US | |
830559 | 830559 | 2021-07-09 | US | Illinois | Bureau | 17011 | 3802 | 85 | 0 | 41.40385234 | -89.5283051 | 2021-07-10 04:21:25 | Bureau, Illinois, US | |
780277 | 780277 | 2021-07-08 | US | Missouri | Laclede | 29105 | 3802 | 75 | 0 | 37.65896829 | -92.5888493 | 2021-07-09 04:21:21 | Laclede, Missouri, US | |
1936051 | 1936051 | 2021-07-05 | US | Wyoming | Teton | 56039 | 3802 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-07-06 04:21:32 | Teton, Wyoming, US | |
1168782 | 1168782 | 2021-07-04 | US | Wyoming | Teton | 56039 | 3802 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-07-05 04:21:28 | Teton, Wyoming, US | |
1167115 | 1167115 | 2021-07-04 | US | Missouri | Polk | 29167 | 3802 | 38 | 0 | 37.6162296 | -93.39828174 | 2021-07-05 04:21:28 | Polk, Missouri, US | |
1499216 | 1499216 | 2021-07-03 | US | Wyoming | Teton | 56039 | 3802 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-07-04 04:21:38 | Teton, Wyoming, US | |
2075531 | 2075531 | 2021-07-02 | US | Wyoming | Teton | 56039 | 3802 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-07-03 04:21:37 | Teton, Wyoming, US | |
403689 | 403689 | 2021-06-29 | US | Virginia | York | 51199 | 3802 | 59 | 0 | 37.24374789 | -76.54412815 | 2021-06-30 04:21:41 | York, Virginia, US | |
3128932 | 3128932 | 2021-06-28 | US | Virginia | York | 51199 | 3802 | 59 | 0 | 37.24374789 | -76.54412815 | 2021-06-29 04:21:28 | York, Virginia, US | |
2593427 | 2593427 | 2021-06-27 | US | Virginia | York | 51199 | 3802 | 59 | 0 | 37.24374789 | -76.54412815 | 2021-06-28 04:21:29 | York, Virginia, US | |
2426314 | 2426314 | 2021-06-23 | US | Virginia | York | 51199 | 3802 | 57 | 0 | 37.24374789 | -76.54412815 | 2021-06-24 04:21:55 | York, Virginia, US | |
1736438 | 1736438 | 2021-06-12 | Guinea-Bissau | 3802 | 69 | 3545 | 188 | 11.8037 | -15.1804 | 2021-06-13 04:22:44 | Guinea-Bissau | |||
3970479 | 3970479 | 2021-06-11 | Guinea-Bissau | 3802 | 69 | 3545 | 188 | 11.8037 | -15.1804 | 2021-06-12 04:22:22 | Guinea-Bissau |
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]);