johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
167 rows where confirmed = 4616 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754667 | 2754667 | 2022-12-29 | US | Minnesota | Redwood | 27127 | 4616 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-12-30 04:21:04 | Redwood, Minnesota, US | |
3174848 | 3174848 | 2022-12-19 | US | Illinois | Wabash | 17185 | 4616 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-12-20 04:21:04 | Wabash, Illinois, US | |
2063709 | 2063709 | 2022-11-19 | China | Shaanxi | 4616 | 3 | 0 | 35.1917 | 108.8701 | 2022-11-20 04:21:08 | Shaanxi, China | |||
3995589 | 3995589 | 2022-09-27 | US | Idaho | Minidoka | 16067 | 4616 | 66 | 0 | 42.85518524 | -113.6357257 | 2022-09-28 04:23:01 | Minidoka, Idaho, US | |
2769917 | 2769917 | 2022-09-26 | US | Idaho | Minidoka | 16067 | 4616 | 66 | 0 | 42.85518524 | -113.6357257 | 2022-09-27 04:23:01 | Minidoka, Idaho, US | |
3989941 | 3989941 | 2022-09-15 | US | Virginia | Buckingham | 51029 | 4616 | 61 | 0 | 37.57242268 | -78.52518834 | 2022-09-16 04:21:19 | Buckingham, Virginia, US | |
375440 | 375440 | 2022-09-13 | US | Texas | Tyler | 48457 | 4616 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-09-14 04:20:44 | Tyler, Texas, US | |
2398042 | 2398042 | 2022-09-12 | US | Texas | Tyler | 48457 | 4616 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-09-13 04:20:57 | Tyler, Texas, US | |
2636878 | 2636878 | 2022-09-05 | US | Texas | Lavaca | 48285 | 4616 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-09-06 04:21:02 | Lavaca, Texas, US | |
2634751 | 2634751 | 2022-09-05 | US | Illinois | Mercer | 17131 | 4616 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-09-06 04:21:02 | Mercer, Illinois, US | |
2990442 | 2990442 | 2022-09-04 | US | Texas | Lavaca | 48285 | 4616 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-09-05 04:21:01 | Lavaca, Texas, US | |
2988315 | 2988315 | 2022-09-04 | US | Illinois | Mercer | 17131 | 4616 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-09-05 04:21:01 | Mercer, Illinois, US | |
2716127 | 2716127 | 2022-09-03 | US | Texas | Lavaca | 48285 | 4616 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-09-04 04:21:22 | Lavaca, Texas, US | |
2714000 | 2714000 | 2022-09-03 | US | Illinois | Mercer | 17131 | 4616 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-09-04 04:21:22 | Mercer, Illinois, US | |
1396832 | 1396832 | 2022-09-02 | US | Texas | Lavaca | 48285 | 4616 | 123 | 0 | 29.38508402 | -96.93186692 | 2022-09-03 04:21:04 | Lavaca, Texas, US | |
1394705 | 1394705 | 2022-09-02 | US | Illinois | Mercer | 17131 | 4616 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-09-03 04:21:04 | Mercer, Illinois, US | |
2346064 | 2346064 | 2022-08-31 | US | Oregon | Tillamook | 41057 | 4616 | 73 | 0 | 45.46248721 | -123.712066 | 2022-09-01 04:21:03 | Tillamook, Oregon, US | |
1534673 | 1534673 | 2022-08-26 | US | Puerto Rico | Guayanilla | 72059 | 4616 | 0 | 0 | 18.039942 | -66.79186 | 2022-08-27 04:20:57 | Guayanilla, Puerto Rico, US | |
2829889 | 2829889 | 2022-08-25 | US | Indiana | Carroll | 18015 | 4616 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-08-26 04:21:02 | Carroll, Indiana, US | |
2324422 | 2324422 | 2022-08-24 | US | Indiana | Carroll | 18015 | 4616 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-08-25 04:21:13 | Carroll, Indiana, US | |
3953415 | 3953415 | 2022-08-17 | US | Tennessee | Cannon | 47015 | 4616 | 68 | 0 | 35.80990797 | -86.05738983 | 2022-08-18 04:21:11 | Cannon, Tennessee, US | |
1069416 | 1069416 | 2022-07-28 | US | Wisconsin | Crawford | 55023 | 4616 | 30 | 0 | 43.23870316 | -90.93073686 | 2022-07-29 04:20:45 | Crawford, Wisconsin, US | |
1069033 | 1069033 | 2022-07-28 | US | Texas | Lee | 48287 | 4616 | 62 | 0 | 30.31120597 | -96.97045773 | 2022-07-29 04:20:45 | Lee, Texas, US | |
93900 | 93900 | 2022-07-23 | US | Puerto Rico | Loiza | 72087 | 4616 | 0 | 0 | 18.425688 | -65.89943 | 2022-07-24 04:20:47 | Loiza, Puerto Rico, US | |
3211343 | 3211343 | 2022-07-18 | US | Illinois | White | 17193 | 4616 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-19 04:20:58 | White, Illinois, US | |
3408960 | 3408960 | 2022-07-17 | US | West Virginia | Monroe | 54063 | 4616 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-07-18 04:20:59 | Monroe, West Virginia, US | |
2155160 | 2155160 | 2022-07-16 | US | West Virginia | Monroe | 54063 | 4616 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-07-17 04:21:15 | Monroe, West Virginia, US | |
2422393 | 2422393 | 2022-07-15 | US | West Virginia | Monroe | 54063 | 4616 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-07-16 04:21:05 | Monroe, West Virginia, US | |
2242923 | 2242923 | 2022-06-28 | US | West Virginia | Wetzel | 54103 | 4616 | 87 | 0 | 39.6065771 | -80.6401654 | 2022-06-29 04:20:59 | Wetzel, West Virginia, US | |
2149406 | 2149406 | 2022-06-27 | US | Minnesota | Roseau | 27135 | 4616 | 45 | 0 | 48.77501878 | -95.81079919 | 2022-06-28 04:20:58 | Roseau, Minnesota, US | |
3983153 | 3983153 | 2022-06-15 | US | California | Colusa | 6011 | 4616 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-06-16 04:20:55 | Colusa, California, US | |
3582059 | 3582059 | 2022-06-02 | US | Washington | Asotin | 53003 | 4616 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-03 04:20:58 | Asotin, Washington, US | |
974352 | 974352 | 2022-06-01 | US | Washington | Asotin | 53003 | 4616 | 67 | 0 | 46.18894415 | -117.2022851 | 2022-06-02 05:20:39 | Asotin, Washington, US | |
3899156 | 3899156 | 2022-05-19 | US | Texas | Panola | 48365 | 4616 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-05-20 04:20:57 | Panola, Texas, US | |
1187940 | 1187940 | 2022-05-18 | US | Texas | Panola | 48365 | 4616 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-05-19 04:20:54 | Panola, Texas, US | |
2310051 | 2310051 | 2022-04-20 | US | Puerto Rico | Morovis | 72101 | 4616 | 0 | 0 | 18.316963 | -66.420383 | 2022-04-21 04:20:46 | Morovis, Puerto Rico, US | |
2254192 | 2254192 | 2022-04-19 | US | Puerto Rico | Naranjito | 72105 | 4616 | 0 | 0 | 18.288019 | -66.252703 | 2022-04-20 04:20:45 | Naranjito, Puerto Rico, US | |
1579532 | 1579532 | 2022-04-10 | US | Virginia | New Kent | 51127 | 4616 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-04-11 04:21:02 | New Kent, Virginia, US | |
1578879 | 1578879 | 2022-04-10 | US | Puerto Rico | Camuy | 72027 | 4616 | 0 | 0 | 18.418578 | -66.860206 | 2022-04-11 04:21:02 | Camuy, Puerto Rico, US | |
1655774 | 1655774 | 2022-04-09 | US | Virginia | New Kent | 51127 | 4616 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-04-10 04:20:52 | New Kent, Virginia, US | |
2119096 | 2119096 | 2022-04-08 | US | Virginia | New Kent | 51127 | 4616 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-04-09 04:20:42 | New Kent, Virginia, US | |
3630086 | 3630086 | 2022-03-13 | US | Nebraska | Unassigned | 90031 | 4616 | 1796 | 0 | 42.8997274 | 0.0 | 2022-03-14 04:20:46 | Unassigned, Nebraska, US | |
952994 | 952994 | 2022-03-12 | US | Nebraska | Unassigned | 90031 | 4616 | 1796 | 0 | 42.8997274 | 0.0 | 2022-03-13 04:20:49 | Unassigned, Nebraska, US | |
358455 | 358455 | 2022-03-11 | US | Nebraska | Unassigned | 90031 | 4616 | 1796 | 0 | 42.8997274 | 0.0 | 2022-03-12 04:20:50 | Unassigned, Nebraska, US | |
1996054 | 1996054 | 2022-03-01 | US | Virginia | Prince Edward | 51147 | 4616 | 64 | 0 | 37.22554789 | -78.43597949 | 2022-03-02 04:21:07 | Prince Edward, Virginia, US | |
1299457 | 1299457 | 2022-02-17 | US | Kentucky | Garrard | 21079 | 4616 | 67 | 0 | 37.638866799999995 | -84.53289319 | 2022-02-18 04:21:04 | Garrard, Kentucky, US | |
2644671 | 2644671 | 2022-02-14 | US | Tennessee | Bledsoe | 47007 | 4616 | 47 | 0 | 35.59942968 | -85.20611967 | 2022-02-15 04:21:09 | Bledsoe, Tennessee, US | |
187487 | 187487 | 2022-02-13 | US | Kentucky | Henry | 21103 | 4616 | 45 | 0 | 38.44942688 | -85.11587507 | 2022-02-14 04:20:51 | Henry, Kentucky, US | |
317333 | 317333 | 2022-02-12 | US | Kentucky | Henry | 21103 | 4616 | 45 | 0 | 38.44942688 | -85.11587507 | 2022-02-13 04:21:00 | Henry, Kentucky, US | |
234659 | 234659 | 2022-02-11 | US | Kentucky | Henry | 21103 | 4616 | 45 | 0 | 38.44942688 | -85.11587507 | 2022-02-12 04:21:06 | Henry, Kentucky, US | |
1365691 | 1365691 | 2022-02-08 | US | Virginia | Fluvanna | 51065 | 4616 | 34 | 0 | 37.84157909 | -78.27715475 | 2022-02-09 04:21:04 | Fluvanna, Virginia, US | |
2013679 | 2013679 | 2022-02-06 | US | Illinois | Clark | 17023 | 4616 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-07 04:21:05 | Clark, Illinois, US | |
1295008 | 1295008 | 2022-02-05 | US | Illinois | Clark | 17023 | 4616 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-06 04:21:00 | Clark, Illinois, US | |
2328336 | 2328336 | 2022-02-04 | US | Illinois | Clark | 17023 | 4616 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-05 04:21:05 | Clark, Illinois, US | |
462876 | 462876 | 2022-02-02 | US | West Virginia | McDowell | 54047 | 4616 | 59 | 0 | 37.38002939 | -81.65083669 | 2022-02-03 04:21:21 | McDowell, West Virginia, US | |
980895 | 980895 | 2022-02-01 | US | Missouri | Perry | 29157 | 4616 | 44 | 0 | 37.70660776 | -89.82741088 | 2022-02-02 04:21:09 | Perry, Missouri, US | |
1320430 | 1320430 | 2022-01-26 | US | New Mexico | Taos | 35055 | 4616 | 78 | 0 | 36.58006022 | -105.63101979999999 | 2022-01-27 04:21:19 | Taos, New Mexico, US | |
1319045 | 1319045 | 2022-01-26 | US | Georgia | Jones | 13169 | 4616 | 100 | 0 | 33.02512137 | -83.56019163 | 2022-01-27 04:21:19 | Jones, Georgia, US | |
2053297 | 2053297 | 2022-01-25 | US | Kentucky | Hart | 21099 | 4616 | 85 | 0 | 37.29943898 | -85.88461055 | 2022-01-26 04:21:07 | Hart, Kentucky, US | |
2835988 | 2835988 | 2022-01-22 | US | Texas | Limestone | 48293 | 4616 | 116 | 0 | 31.5454767 | -96.58095444 | 2022-01-23 04:21:13 | Limestone, Texas, US | |
1475297 | 1475297 | 2022-01-17 | US | Texas | Moore | 48341 | 4616 | 97 | 0 | 35.83769242 | -101.8930281 | 2022-01-18 04:21:04 | Moore, Texas, US | |
557928 | 557928 | 2022-01-16 | US | Texas | Karnes | 48255 | 4616 | 58 | 0 | 28.90705334 | -97.85960149 | 2022-01-17 04:21:08 | Karnes, Texas, US | |
101854 | 101854 | 2022-01-14 | US | Ohio | Wyandot | 39175 | 4616 | 97 | 0 | 40.84339621 | -83.30734173 | 2022-01-15 04:21:07 | Wyandot, Ohio, US | |
1117062 | 1117062 | 2022-01-11 | US | West Virginia | Boone | 54005 | 4616 | 62 | 0 | 38.01974191 | -81.69888019 | 2022-01-12 04:21:44 | Boone, West Virginia, US | |
1286353 | 1286353 | 2022-01-04 | US | Alabama | Bibb | 1007 | 4616 | 95 | 0 | 32.99642064 | -87.12511459999996 | 2022-01-05 04:21:59 | Bibb, Alabama, US | |
3522207 | 3522207 | 2022-01-02 | US | Puerto Rico | Rio Grande | 72119 | 4616 | 0 | 0 | 18.346329 | -65.813742 | 2022-01-03 02:22:25 | Rio Grande, Puerto Rico, US | |
2168032 | 2168032 | 2022-01-01 | US | Arkansas | Carroll | 5015 | 4616 | 81 | 0 | 36.34038560000001 | -93.54270261 | 2022-01-02 04:20:52 | Carroll, Arkansas, US | |
2115240 | 2115240 | 2021-12-26 | US | Wisconsin | Door | 55029 | 4616 | 49 | 0 | 44.95856458 | -87.30002707 | 2021-12-27 04:21:58 | Door, Wisconsin, US | |
3608612 | 3608612 | 2021-12-25 | US | Wisconsin | Door | 55029 | 4616 | 49 | 0 | 44.95856458 | -87.30002707 | 2021-12-26 04:21:50 | Door, Wisconsin, US | |
2966930 | 2966930 | 2021-12-24 | US | Wisconsin | Door | 55029 | 4616 | 49 | 0 | 44.95856458 | -87.30002707 | 2021-12-25 04:21:37 | Door, Wisconsin, US | |
1261263 | 1261263 | 2021-12-18 | US | Ohio | Henry | 39069 | 4616 | 91 | 0 | 41.333964200000004 | -84.06830637 | 2021-12-19 04:21:11 | Henry, Ohio, US | |
3071732 | 3071732 | 2021-11-23 | US | Minnesota | Brown | 27015 | 4616 | 57 | 0 | 44.24205652 | -94.72562874 | 2021-11-24 04:22:14 | Brown, Minnesota, US | |
448144 | 448144 | 2021-11-17 | US | Georgia | Chattooga | 13055 | 4616 | 106 | 0 | 34.47197698 | -85.34535662 | 2021-11-18 04:21:33 | Chattooga, Georgia, US | |
2288908 | 2288908 | 2021-11-15 | US | Kentucky | Montgomery | 21173 | 4616 | 60 | 0 | 38.03253032 | -83.9145241 | 2021-11-16 04:21:10 | Montgomery, Kentucky, US | |
1322605 | 1322605 | 2021-11-14 | US | Alabama | Geneva | 1061 | 4616 | 133 | 0 | 31.09389027 | -85.83572839 | 2021-11-15 04:21:36 | Geneva, Alabama, US | |
3640939 | 3640939 | 2021-11-08 | US | Kentucky | Carter | 21043 | 4616 | 60 | 0 | 38.31690743 | -83.05092385 | 2021-11-09 04:21:36 | Carter, Kentucky, US | |
2002897 | 2002897 | 2021-11-07 | US | New York | Franklin | 36033 | 4616 | 25 | 0 | 44.59040891 | -74.29926032 | 2021-11-08 04:21:43 | Franklin, New York, US | |
444245 | 444245 | 2021-10-20 | US | Georgia | Unassigned | 90013 | 4616 | 9 | 0 | 34.91369188 | 0.0 | 2021-10-21 04:21:18 | Unassigned, Georgia, US | |
444142 | 444142 | 2021-10-20 | US | Georgia | Dawson | 13085 | 4616 | 66 | 0 | 34.44244079 | -84.16964071 | 2021-10-21 04:21:18 | Dawson, Georgia, US | |
598461 | 598461 | 2021-10-19 | US | Georgia | Dawson | 13085 | 4616 | 66 | 0 | 34.44244079 | -84.16964071 | 2021-10-20 04:21:00 | Dawson, Georgia, US | |
636130 | 636130 | 2021-10-13 | US | New Mexico | Rio Arriba | 35039 | 4616 | 83 | 0 | 36.51072137 | -106.69316740000001 | 2021-10-14 04:21:29 | Rio Arriba, New Mexico, US | |
635429 | 635429 | 2021-10-13 | US | Louisiana | Franklin | 22041 | 4616 | 136 | 0 | 32.13675181 | -91.67589857 | 2021-10-14 04:21:29 | Franklin, Louisiana, US | |
1494154 | 1494154 | 2021-10-12 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-13 04:20:51 | Garvin, Oklahoma, US | |
3009887 | 3009887 | 2021-10-11 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-12 04:21:09 | Garvin, Oklahoma, US | |
425903 | 425903 | 2021-10-10 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-11 04:21:31 | Garvin, Oklahoma, US | |
2878760 | 2878760 | 2021-10-09 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-10 04:21:38 | Garvin, Oklahoma, US | |
2961926 | 2961926 | 2021-10-08 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-09 04:21:34 | Garvin, Oklahoma, US | |
469964 | 469964 | 2021-10-07 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-08 04:21:25 | Garvin, Oklahoma, US | |
2461344 | 2461344 | 2021-10-06 | US | Oklahoma | Garvin | 40049 | 4616 | 92 | 0 | 34.70418038 | -97.30811132 | 2021-10-07 04:21:36 | Garvin, Oklahoma, US | |
1275972 | 1275972 | 2021-10-03 | US | Michigan | Sanilac | 26151 | 4616 | 130 | 0 | 43.42406072 | -82.82055898 | 2021-10-04 04:21:31 | Sanilac, Michigan, US | |
1275799 | 1275799 | 2021-10-03 | US | Louisiana | Jefferson Davis | 22053 | 4616 | 121 | 0 | 30.26896765 | -92.81210004 | 2021-10-04 04:21:31 | Jefferson Davis, Louisiana, US | |
3929725 | 3929725 | 2021-10-02 | US | Michigan | Sanilac | 26151 | 4616 | 130 | 0 | 43.42406072 | -82.82055898 | 2021-10-03 04:21:24 | Sanilac, Michigan, US | |
3929552 | 3929552 | 2021-10-02 | US | Louisiana | Jefferson Davis | 22053 | 4616 | 121 | 0 | 30.26896765 | -92.81210004 | 2021-10-03 04:21:24 | Jefferson Davis, Louisiana, US | |
2133705 | 2133705 | 2021-10-01 | US | Michigan | Sanilac | 26151 | 4616 | 130 | 0 | 43.42406072 | -82.82055898 | 2021-10-02 04:21:25 | Sanilac, Michigan, US | |
2133532 | 2133532 | 2021-10-01 | US | Louisiana | Jefferson Davis | 22053 | 4616 | 121 | 0 | 30.26896765 | -92.81210004 | 2021-10-02 04:21:25 | Jefferson Davis, Louisiana, US | |
1335114 | 1335114 | 2021-09-28 | US | Georgia | Lumpkin | 13187 | 4616 | 90 | 0 | 34.57286511 | -84.00425681 | 2021-09-29 04:21:45 | Lumpkin, Georgia, US | |
3760460 | 3760460 | 2021-09-21 | US | Tennessee | Scott | 47151 | 4616 | 54 | 0 | 36.42325673 | -84.50360494 | 2021-09-22 04:21:45 | Scott, Tennessee, US | |
1888267 | 1888267 | 2021-09-12 | US | Utah | Southeast Utah | 4616 | 34 | 0 | 38.99617072 | -110.70139579999999 | 2021-09-13 04:21:15 | Southeast Utah, Utah, US | ||
3809170 | 3809170 | 2021-09-11 | US | Utah | Southeast Utah | 4616 | 34 | 0 | 38.99617072 | -110.70139579999999 | 2021-09-12 04:21:13 | Southeast Utah, Utah, US | ||
3452110 | 3452110 | 2021-09-10 | US | Utah | Southeast Utah | 4616 | 34 | 0 | 38.99617072 | -110.70139579999999 | 2021-09-11 04:21:30 | Southeast Utah, Utah, 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]);