johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
215 rows where confirmed = 3988 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754165 | 2754165 | 2022-12-29 | US | Iowa | Wright | 19197 | 3988 | 70 | 0 | 42.73305373 | -93.73515113 | 2022-12-30 04:21:04 | Wright, Iowa, US | |
1075171 | 1075171 | 2022-12-28 | US | Iowa | Wright | 19197 | 3988 | 70 | 0 | 42.73305373 | -93.73515113 | 2022-12-29 04:21:01 | Wright, Iowa, US | |
452015 | 452015 | 2022-12-21 | US | Colorado | Grand | 8049 | 3988 | 30 | 0 | 40.10603347 | -106.1178042 | 2022-12-22 04:20:56 | Grand, Colorado, US | |
871768 | 871768 | 2022-12-11 | US | Tennessee | Lewis | 47101 | 3988 | 67 | 0 | 35.52853208 | -87.49022694 | 2022-12-12 04:21:01 | Lewis, Tennessee, US | |
1985708 | 1985708 | 2022-12-07 | US | Illinois | Washington | 17189 | 3988 | 36 | 0 | 38.35309213 | -89.40982703 | 2022-12-08 04:21:07 | Washington, Illinois, US | |
1243090 | 1243090 | 2022-11-28 | US | Virginia | Westmoreland | 51193 | 3988 | 57 | 0 | 38.11021557 | -76.80213247 | 2022-11-29 04:21:05 | Westmoreland, Virginia, US | |
2275508 | 2275508 | 2022-10-20 | US | Wisconsin | Rusk | 55107 | 3988 | 61 | 0 | 45.47498854 | -91.1333012 | 2022-10-21 04:22:23 | Rusk, Wisconsin, US | |
1977154 | 1977154 | 2022-09-25 | US | Arkansas | Van Buren | 5141 | 3988 | 64 | 0 | 35.58095779 | -92.51295036 | 2022-09-26 04:20:52 | Van Buren, Arkansas, US | |
1892519 | 1892519 | 2022-09-14 | US | Virginia | Martinsville | 51690 | 3988 | 129 | 0 | 36.68212094 | -79.86352771 | 2022-09-15 04:21:02 | Martinsville, Virginia, US | |
2395437 | 2395437 | 2022-09-12 | US | Colorado | Las Animas | 8071 | 3988 | 45 | 0 | 37.3153406 | -104.0376458 | 2022-09-13 04:20:57 | Las Animas, Colorado, US | |
254306 | 254306 | 2022-09-08 | US | Illinois | Greene | 17061 | 3988 | 47 | 0 | 39.35907414 | -90.388865 | 2022-09-09 04:21:11 | Greene, Illinois, US | |
3748412 | 3748412 | 2022-09-07 | US | Virginia | Alleghany | 51005 | 3988 | 103 | 0 | 37.78636074 | -80.00222498 | 2022-09-08 04:21:02 | Alleghany, Virginia, US | |
2346504 | 2346504 | 2022-08-31 | US | Texas | Duval | 48131 | 3988 | 70 | 0 | 27.68184592 | -98.50864568 | 2022-09-01 04:21:03 | Duval, Texas, US | |
2345711 | 2345711 | 2022-08-31 | US | New York | Yates | 36123 | 3988 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-09-01 04:21:03 | Yates, New York, US | |
1254288 | 1254288 | 2022-08-23 | US | Wisconsin | Bayfield | 55007 | 3988 | 42 | 0 | 46.52868768 | -91.19716729 | 2022-08-24 04:20:46 | Bayfield, Wisconsin, US | |
3546656 | 3546656 | 2022-08-08 | US | Texas | Madison | 48313 | 3988 | 57 | 0 | 30.96694679 | -95.93003775 | 2022-08-09 04:20:34 | Madison, Texas, US | |
3620347 | 3620347 | 2022-08-01 | US | Texas | Zapata | 48505 | 3988 | 55 | 0 | 27.00156391 | -99.16987152 | 2022-08-02 04:20:53 | Zapata, Texas, US | |
677251 | 677251 | 2022-07-30 | US | Tennessee | Decatur | 47039 | 3988 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-07-31 04:21:02 | Decatur, Tennessee, US | |
1490671 | 1490671 | 2022-07-26 | US | Texas | Falls | 48145 | 3988 | 67 | 0 | 31.25350609 | -96.93630086 | 2022-07-27 04:21:04 | Falls, Texas, US | |
898881 | 898881 | 2022-07-24 | US | Puerto Rico | Ciales | 72039 | 3988 | 0 | 0 | 18.28885 | -66.516475 | 2022-07-25 04:20:51 | Ciales, Puerto Rico, US | |
1611355 | 1611355 | 2022-07-20 | US | Texas | Freestone | 48161 | 3988 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-07-21 04:21:10 | Freestone, Texas, US | |
2152151 | 2152151 | 2022-07-16 | US | Arkansas | Howard | 5061 | 3988 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-07-17 04:21:15 | Howard, Arkansas, US | |
2419377 | 2419377 | 2022-07-15 | US | Arkansas | Franklin | 5047 | 3988 | 73 | 0 | 35.51202821 | -93.89299569 | 2022-07-16 04:21:05 | Franklin, Arkansas, US | |
1200173 | 1200173 | 2022-07-06 | US | Alabama | Crenshaw | 1041 | 3988 | 102 | 0 | 31.72941803 | -86.31593104 | 2022-07-07 04:20:55 | Crenshaw, Alabama, US | |
2149303 | 2149303 | 2022-06-27 | US | Michigan | Manistee | 26101 | 3988 | 93 | 0 | 44.33352407 | -86.05626916 | 2022-06-28 04:20:58 | Manistee, Michigan, US | |
477104 | 477104 | 2022-06-26 | US | Michigan | Manistee | 26101 | 3988 | 93 | 0 | 44.33352407 | -86.05626916 | 2022-06-27 04:21:00 | Manistee, Michigan, US | |
940479 | 940479 | 2022-06-25 | US | Michigan | Manistee | 26101 | 3988 | 93 | 0 | 44.33352407 | -86.05626916 | 2022-06-26 04:21:02 | Manistee, Michigan, US | |
3348299 | 3348299 | 2022-06-24 | US | Michigan | Manistee | 26101 | 3988 | 93 | 0 | 44.33352407 | -86.05626916 | 2022-06-25 04:20:57 | Manistee, Michigan, US | |
1650040 | 1650040 | 2022-06-23 | US | Michigan | Manistee | 26101 | 3988 | 93 | 0 | 44.33352407 | -86.05626916 | 2022-06-24 04:20:58 | Manistee, Michigan, US | |
2189275 | 2189275 | 2022-06-22 | US | Michigan | Manistee | 26101 | 3988 | 93 | 0 | 44.33352407 | -86.05626916 | 2022-06-23 04:20:55 | Manistee, Michigan, US | |
1424669 | 1424669 | 2022-06-08 | US | Wisconsin | Marquette | 55077 | 3988 | 62 | 0 | 43.81911946 | -89.40073763 | 2022-06-09 04:20:54 | Marquette, Wisconsin, US | |
3727473 | 3727473 | 2022-06-07 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-08 04:20:55 | Winneshiek, Iowa, US | |
3888875 | 3888875 | 2022-06-06 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-07 04:21:08 | Winneshiek, Iowa, US | |
3508644 | 3508644 | 2022-06-05 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-06 04:20:57 | Winneshiek, Iowa, US | |
3530627 | 3530627 | 2022-06-04 | US | Texas | Llano | 48299 | 3988 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-06-05 04:20:55 | Llano, Texas, US | |
3528721 | 3528721 | 2022-06-04 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-05 04:20:55 | Winneshiek, Iowa, US | |
3134807 | 3134807 | 2022-06-03 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-04 04:20:58 | Winneshiek, Iowa, US | |
3579882 | 3579882 | 2022-06-02 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-03 04:20:58 | Winneshiek, Iowa, US | |
972175 | 972175 | 2022-06-01 | US | Iowa | Winneshiek | 19191 | 3988 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-02 05:20:39 | Winneshiek, Iowa, US | |
3187473 | 3187473 | 2022-05-30 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-31 04:20:51 | Washington, Kentucky, US | |
3199622 | 3199622 | 2022-05-29 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-30 04:20:50 | Washington, Kentucky, US | |
2726500 | 2726500 | 2022-05-28 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-29 04:20:53 | Washington, Kentucky, US | |
1315681 | 1315681 | 2022-05-27 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-28 04:21:07 | Washington, Kentucky, US | |
1851473 | 1851473 | 2022-05-26 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-27 04:20:56 | Washington, Kentucky, US | |
2049349 | 2049349 | 2022-05-25 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-26 04:20:50 | Washington, Kentucky, US | |
3000787 | 3000787 | 2022-05-24 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-25 04:20:56 | Washington, Kentucky, US | |
3596638 | 3596638 | 2022-05-23 | US | Wyoming | Lincoln | 56023 | 3988 | 31 | 0 | 42.26376367 | -110.6563997 | 2022-05-24 04:20:57 | Lincoln, Wyoming, US | |
3594508 | 3594508 | 2022-05-23 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-24 04:20:57 | Washington, Kentucky, US | |
623360 | 623360 | 2022-05-22 | US | Kentucky | Washington | 21229 | 3988 | 62 | 0 | 37.75599461 | -85.17407732 | 2022-05-26 04:20:50 | Washington, Kentucky, US | |
1113186 | 1113186 | 2022-05-21 | US | Wyoming | Lincoln | 56023 | 3988 | 31 | 0 | 42.26376367 | -110.6563997 | 2022-05-22 04:20:52 | Lincoln, Wyoming, US | |
1172810 | 1172810 | 2022-05-20 | US | Wyoming | Lincoln | 56023 | 3988 | 31 | 0 | 42.26376367 | -110.6563997 | 2022-05-21 04:20:58 | Lincoln, Wyoming, US | |
3899573 | 3899573 | 2022-05-19 | US | Wyoming | Lincoln | 56023 | 3988 | 31 | 0 | 42.26376367 | -110.6563997 | 2022-05-20 04:20:57 | Lincoln, Wyoming, US | |
1188357 | 1188357 | 2022-05-18 | US | Wyoming | Lincoln | 56023 | 3988 | 31 | 0 | 42.26376367 | -110.6563997 | 2022-05-19 04:20:54 | Lincoln, Wyoming, US | |
3586254 | 3586254 | 2022-05-17 | US | Wyoming | Lincoln | 56023 | 3988 | 31 | 0 | 42.26376367 | -110.6563997 | 2022-05-18 04:20:50 | Lincoln, Wyoming, US | |
2536976 | 2536976 | 2022-05-12 | US | Wisconsin | Richland | 55103 | 3988 | 48 | 0 | 43.3762778 | -90.43012729 | 2022-05-13 04:20:51 | Richland, Wisconsin, US | |
3538773 | 3538773 | 2022-05-10 | US | Virginia | Buckingham | 51029 | 3988 | 57 | 0 | 37.57242268 | -78.52518834 | 2022-05-11 04:20:48 | Buckingham, Virginia, US | |
225308 | 225308 | 2022-05-09 | US | Virginia | Buckingham | 51029 | 3988 | 57 | 0 | 37.57242268 | -78.52518834 | 2022-05-10 04:20:50 | Buckingham, Virginia, US | |
1329596 | 1329596 | 2022-04-26 | US | Virginia | Greene | 51079 | 3988 | 61 | 0 | 38.29545894 | -78.46525378 | 2022-04-27 04:20:52 | Greene, Virginia, US | |
2030898 | 2030898 | 2022-04-24 | US | Nebraska | Unassigned | 90031 | 3988 | 764 | 0 | 42.8997274 | 0.0 | 2022-04-25 04:20:56 | Unassigned, Nebraska, US | |
748473 | 748473 | 2022-04-23 | US | Nebraska | Unassigned | 90031 | 3988 | 764 | 0 | 42.8997274 | 0.0 | 2022-04-24 04:20:56 | Unassigned, Nebraska, US | |
2254958 | 2254958 | 2022-04-19 | US | Wisconsin | Burnett | 55013 | 3988 | 43 | 0 | 45.86303537 | -92.36711412 | 2022-04-20 04:20:45 | Burnett, Wisconsin, US | |
3419864 | 3419864 | 2022-04-17 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-18 04:21:12 | Grundy, Tennessee, US | |
306813 | 306813 | 2022-04-16 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-17 04:20:59 | Grundy, Tennessee, US | |
2672758 | 2672758 | 2022-04-15 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-16 04:20:48 | Grundy, Tennessee, US | |
1226543 | 1226543 | 2022-04-14 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-15 04:20:57 | Grundy, Tennessee, US | |
2445701 | 2445701 | 2022-04-13 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-13 23:21:06 | Grundy, Tennessee, US | |
1951458 | 1951458 | 2022-04-12 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-13 04:21:03 | Grundy, Tennessee, US | |
3209211 | 3209211 | 2022-04-11 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-12 04:20:49 | Grundy, Tennessee, US | |
1579097 | 1579097 | 2022-04-10 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-11 04:21:02 | Grundy, Tennessee, US | |
1655339 | 1655339 | 2022-04-09 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-10 04:20:52 | Grundy, Tennessee, US | |
2118661 | 2118661 | 2022-04-08 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-09 04:20:42 | Grundy, Tennessee, US | |
3323185 | 3323185 | 2022-04-07 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-08 04:20:48 | Grundy, Tennessee, US | |
2803721 | 2803721 | 2022-04-06 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-07 04:20:53 | Grundy, Tennessee, US | |
3870490 | 3870490 | 2022-04-05 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-06 04:20:49 | Grundy, Tennessee, US | |
2751832 | 2751832 | 2022-04-04 | US | Tennessee | Grundy | 47061 | 3988 | 73 | 0 | 35.38433717 | -85.72142731 | 2022-04-05 04:20:48 | Grundy, Tennessee, US | |
3733178 | 3733178 | 2022-04-03 | US | Tennessee | Grundy | 47061 | 3988 | 71 | 0 | 35.38433717 | -85.72142731 | 2022-04-04 04:20:51 | Grundy, Tennessee, US | |
502613 | 502613 | 2022-04-02 | US | Tennessee | Grundy | 47061 | 3988 | 71 | 0 | 35.38433717 | -85.72142731 | 2022-04-03 04:20:48 | Grundy, Tennessee, US | |
3353598 | 3353598 | 2022-04-01 | US | Tennessee | Grundy | 47061 | 3988 | 71 | 0 | 35.38433717 | -85.72142731 | 2022-04-02 04:20:47 | Grundy, Tennessee, US | |
1542903 | 1542903 | 2022-03-31 | US | Tennessee | Grundy | 47061 | 3988 | 71 | 0 | 35.38433717 | -85.72142731 | 2022-04-01 04:20:28 | Grundy, Tennessee, US | |
2480916 | 2480916 | 2022-03-30 | US | Tennessee | Grundy | 47061 | 3988 | 71 | 0 | 35.38433717 | -85.72142731 | 2022-03-31 04:20:56 | Grundy, Tennessee, US | |
877321 | 877321 | 2022-03-27 | US | Illinois | Warren | 17187 | 3988 | 82 | 0 | 40.84925021 | -90.6147432 | 2022-03-28 04:20:33 | Warren, Illinois, US | |
2164604 | 2164604 | 2022-03-26 | US | Illinois | Warren | 17187 | 3988 | 82 | 0 | 40.84925021 | -90.6147432 | 2022-03-27 04:20:47 | Warren, Illinois, US | |
1721540 | 1721540 | 2022-03-25 | US | Illinois | Warren | 17187 | 3988 | 82 | 0 | 40.84925021 | -90.6147432 | 2022-03-26 04:20:23 | Warren, Illinois, US | |
2202764 | 2202764 | 2022-03-06 | US | Texas | Houston | 48225 | 3988 | 107 | 0 | 31.31925973 | -95.42226208 | 2022-03-07 04:20:47 | Houston, Texas, US | |
2095221 | 2095221 | 2022-03-05 | US | Texas | Houston | 48225 | 3988 | 107 | 0 | 31.31925973 | -95.42226208 | 2022-03-06 04:20:49 | Houston, Texas, US | |
944258 | 944258 | 2022-02-28 | US | Kentucky | Knott | 21119 | 3988 | 55 | 0 | 37.35388197 | -82.94981134 | 2022-03-01 04:21:09 | Knott, Kentucky, US | |
318590 | 318590 | 2022-02-12 | US | Pennsylvania | Fulton | 42057 | 3988 | 62 | 0 | 39.92913544 | -78.11163677 | 2022-02-13 04:21:00 | Fulton, Pennsylvania, US | |
1465233 | 1465233 | 2022-02-10 | US | Indiana | Vermillion | 18165 | 3988 | 69 | 0 | 39.8523352 | -87.46160542 | 2022-02-11 04:21:09 | Vermillion, Indiana, US | |
1464557 | 1464557 | 2022-02-10 | US | Arkansas | Clay | 5021 | 3988 | 81 | 0 | 36.36826212 | -90.4148172 | 2022-02-11 04:21:09 | Clay, Arkansas, US | |
1144106 | 1144106 | 2022-01-23 | US | Texas | Panola | 48365 | 3988 | 115 | 0 | 32.163959600000005 | -94.30552481 | 2022-01-24 04:21:12 | Panola, Texas, US | |
1143405 | 1143405 | 2022-01-23 | US | Ohio | Meigs | 39105 | 3988 | 80 | 0 | 39.09224872 | -82.0305041 | 2022-01-24 04:21:12 | Meigs, Ohio, US | |
3843610 | 3843610 | 2022-01-15 | US | Texas | Gonzales | 48177 | 3988 | 91 | 0 | 29.45634206 | -97.49424032 | 2022-01-16 04:21:12 | Gonzales, Texas, US | |
3613564 | 3613564 | 2022-01-12 | US | Arkansas | Lawrence | 5075 | 3988 | 64 | 0 | 36.04188196 | -91.10867198 | 2022-01-13 08:00:09 | Lawrence, Arkansas, US | |
129411 | 129411 | 2022-01-09 | US | Pennsylvania | Juniata | 42067 | 3988 | 152 | 0 | 40.53358749 | -77.39975129999998 | 2022-01-10 04:22:07 | Juniata, Pennsylvania, US | |
2610707 | 2610707 | 2022-01-06 | US | Colorado | Teller | 8119 | 3988 | 54 | 0 | 38.88133511 | -105.16148929999999 | 2022-01-07 04:22:09 | Teller, Colorado, US | |
2610561 | 2610561 | 2022-01-06 | US | Arkansas | Ouachita | 5103 | 3988 | 91 | 0 | 33.58839816 | -92.87795984 | 2022-01-07 04:22:09 | Ouachita, Arkansas, US | |
1671476 | 1671476 | 2021-12-29 | US | Texas | Austin | 48015 | 3988 | 57 | 0 | 29.88548725 | -96.27736949 | 2021-12-30 04:21:25 | Austin, Texas, US | |
3802 | 3802 | 2021-12-02 | US | West Virginia | Boone | 54005 | 3988 | 62 | 0 | 38.01974191 | -81.69888019 | 2021-12-03 04:23:05 | Boone, West Virginia, US | |
1147755 | 1147755 | 2021-12-01 | US | South Carolina | Jasper | 45053 | 3988 | 82 | 0 | 32.43171982 | -81.02487495 | 2021-12-02 04:22:37 | Jasper, South Carolina, US | |
3402966 | 3402966 | 2021-11-30 | US | Louisiana | Pointe Coupee | 22077 | 3988 | 85 | 0 | 30.71409502 | -91.60209535 | 2021-12-01 04:22:29 | Pointe Coupee, 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]);