johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
76 rows where confirmed = 8241 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754932 | 2754932 | 2022-12-29 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-30 04:21:04 | Ravalli, Montana, US | |
1075938 | 1075938 | 2022-12-28 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-29 04:21:01 | Ravalli, Montana, US | |
329935 | 329935 | 2022-12-27 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-28 04:21:04 | Ravalli, Montana, US | |
220008 | 220008 | 2022-12-26 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-27 04:21:07 | Ravalli, Montana, US | |
3224465 | 3224465 | 2022-12-25 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-26 04:21:06 | Ravalli, Montana, US | |
1020379 | 1020379 | 2022-12-24 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-25 04:21:04 | Ravalli, Montana, US | |
692402 | 692402 | 2022-12-23 | US | Montana | Ravalli | 30081 | 8241 | 174 | 0 | 46.08520862 | -114.1189164 | 2022-12-24 04:21:02 | Ravalli, Montana, US | |
2927457 | 2927457 | 2022-11-11 | Russia | Nenets Autonomous Okrug | 8241 | 103 | 0 | 68.27557185 | 57.1686375 | 2022-11-12 04:20:41 | Nenets Autonomous Okrug, Russia | |||
539286 | 539286 | 2022-10-26 | US | Arkansas | St. Francis | 5123 | 8241 | 104 | 0 | 35.02201976 | -90.74828138 | 2022-10-27 04:22:01 | St. Francis, Arkansas, US | |
2760464 | 2760464 | 2022-10-18 | US | Wisconsin | Door | 55029 | 8241 | 79 | 0 | 44.95856458 | -87.30002707 | 2022-10-19 04:22:26 | Door, Wisconsin, US | |
2532150 | 2532150 | 2022-10-06 | US | Puerto Rico | Morovis | 72101 | 8241 | 0 | 0 | 18.316963 | -66.420383 | 2022-10-07 04:23:08 | Morovis, Puerto Rico, US | |
3990189 | 3990189 | 2022-09-15 | US | Wisconsin | Lincoln | 55069 | 8241 | 153 | 0 | 45.33737523 | -89.73411273 | 2022-09-16 04:21:19 | Lincoln, Wisconsin, US | |
3748499 | 3748499 | 2022-09-07 | US | Virginia | Orange | 51137 | 8241 | 98 | 0 | 38.24530219 | -78.015604 | 2022-09-08 04:21:02 | Orange, Virginia, US | |
2856388 | 2856388 | 2022-08-22 | US | West Virginia | Wyoming | 54109 | 8241 | 125 | 0 | 37.612327 | -81.54511071 | 2022-08-23 04:20:56 | Wyoming, West Virginia, US | |
3546837 | 3546837 | 2022-08-08 | US | Virginia | Gloucester | 51073 | 8241 | 107 | 0 | 37.40809042 | -76.53524337 | 2022-08-09 04:20:34 | Gloucester, Virginia, US | |
960398 | 960398 | 2022-07-19 | US | Louisiana | De Soto | 22031 | 8241 | 135 | 0 | 32.05457447 | -93.74130302 | 2022-07-20 04:20:59 | De Soto, Louisiana, US | |
1423843 | 1423843 | 2022-06-08 | US | Puerto Rico | Dorado | 72051 | 8241 | 0 | 0 | 18.436115 | -66.278669 | 2022-06-09 04:20:54 | Dorado, Puerto Rico, US | |
1851971 | 1851971 | 2022-05-26 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-27 04:20:56 | Warren, Missouri, US | |
2049847 | 2049847 | 2022-05-25 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-26 04:20:50 | Warren, Missouri, US | |
3001285 | 3001285 | 2022-05-24 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-25 04:20:56 | Warren, Missouri, US | |
3595006 | 3595006 | 2022-05-23 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-24 04:20:57 | Warren, Missouri, US | |
623858 | 623858 | 2022-05-22 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-26 04:20:50 | Warren, Missouri, US | |
1111554 | 1111554 | 2022-05-21 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-22 04:20:52 | Warren, Missouri, US | |
1171178 | 1171178 | 2022-05-20 | US | Missouri | Warren | 29219 | 8241 | 102 | 0 | 38.76529479 | -91.16124662 | 2022-05-21 04:20:58 | Warren, Missouri, US | |
2254086 | 2254086 | 2022-04-19 | US | Pennsylvania | Clarion | 42031 | 8241 | 202 | 0 | 41.19265812 | -79.42413524 | 2022-04-20 04:20:45 | Clarion, Pennsylvania, US | |
2445765 | 2445765 | 2022-04-13 | US | Tennessee | White | 47185 | 8241 | 129 | 0 | 35.92929884 | -85.45591799 | 2022-04-13 23:21:06 | White, Tennessee, US | |
1951522 | 1951522 | 2022-04-12 | US | Tennessee | White | 47185 | 8241 | 129 | 0 | 35.92929884 | -85.45591799 | 2022-04-13 04:21:03 | White, Tennessee, US | |
2526499 | 2526499 | 2022-03-02 | US | Indiana | Ripley | 18137 | 8241 | 131 | 0 | 39.10235626 | -85.26212744 | 2022-03-03 04:21:01 | Ripley, Indiana, US | |
1993793 | 1993793 | 2022-03-01 | US | Indiana | Ripley | 18137 | 8241 | 129 | 0 | 39.10235626 | -85.26212744 | 2022-03-02 04:21:07 | Ripley, Indiana, US | |
2450162 | 2450162 | 2022-02-22 | US | Virginia | Petersburg | 51730 | 8241 | 131 | 0 | 37.20530399 | -77.39368102 | 2022-02-23 04:21:09 | Petersburg, Virginia, US | |
1465456 | 1465456 | 2022-02-10 | US | Kentucky | Bell | 21013 | 8241 | 124 | 0 | 36.73355174 | -83.67766671 | 2022-02-11 04:21:09 | Bell, Kentucky, US | |
1297530 | 1297530 | 2022-02-05 | US | West Virginia | Marshall | 54051 | 8241 | 143 | 0 | 39.86064362 | -80.66591062 | 2022-02-06 04:21:00 | Marshall, West Virginia, US | |
2835059 | 2835059 | 2022-01-22 | US | New York | Chenango | 36017 | 8241 | 107 | 0 | 42.49430041 | -75.60887553 | 2022-01-23 04:21:13 | Chenango, New York, US | |
3832043 | 3832043 | 2021-12-21 | US | Wisconsin | Pierce | 55093 | 8241 | 59 | 0 | 44.71850291 | -92.4224416 | 2021-12-22 04:21:54 | Pierce, Wisconsin, US | |
407230 | 407230 | 2021-12-07 | US | Tennessee | Dyer | 47045 | 8241 | 156 | 0 | 36.05931946 | -89.41542855 | 2021-12-08 04:22:46 | Dyer, Tennessee, US | |
1031449 | 1031449 | 2021-12-06 | US | Indiana | Cass | 18017 | 8241 | 128 | 0 | 40.76135835 | -86.34830753 | 2021-12-07 04:22:34 | Cass, Indiana, US | |
1145921 | 1145921 | 2021-12-01 | US | Illinois | Grundy | 17063 | 8241 | 90 | 0 | 41.28569601 | -88.41905692 | 2021-12-02 04:22:37 | Grundy, Illinois, US | |
760772 | 760772 | 2021-11-26 | US | Ohio | Athens | 39009 | 8241 | 98 | 0 | 39.33425634 | -82.04278644 | 2021-11-27 04:22:45 | Athens, Ohio, US | |
1016572 | 1016572 | 2021-11-21 | US | New York | Genesee | 36037 | 8241 | 142 | 0 | 43.0022601 | -78.19135193 | 2021-11-22 04:22:20 | Genesee, New York, US | |
2044358 | 2044358 | 2021-10-18 | US | Arkansas | Mississippi | 5093 | 8241 | 137 | 0 | 35.76271485 | -90.05194370000002 | 2021-10-19 04:20:54 | Mississippi, Arkansas, US | |
1493874 | 1493874 | 2021-10-12 | US | New York | Sullivan | 36105 | 8241 | 83 | 0 | 41.71579493 | -74.76394559 | 2021-10-13 04:20:51 | Sullivan, New York, US | |
2077764 | 2077764 | 2021-09-26 | US | Mississippi | Lafayette | 28071 | 8241 | 137 | 0 | 34.35687874 | -89.48490961 | 2021-09-27 04:21:16 | Lafayette, Mississippi, US | |
1726316 | 1726316 | 2021-09-25 | US | Mississippi | Lafayette | 28071 | 8241 | 137 | 0 | 34.35687874 | -89.48490961 | 2021-09-26 04:21:29 | Lafayette, Mississippi, US | |
1923036 | 1923036 | 2021-09-24 | US | Mississippi | Lafayette | 28071 | 8241 | 137 | 0 | 34.35687874 | -89.48490961 | 2021-09-25 04:21:31 | Lafayette, Mississippi, US | |
809361 | 809361 | 2021-09-20 | Chile | Aysen | 8241 | 78 | 0 | -45.9864 | -73.7669 | 2021-09-21 04:21:26 | Aysen, Chile | |||
2618404 | 2618404 | 2021-09-17 | US | Alabama | Dale | 1045 | 8241 | 151 | 0 | 31.43037123 | -85.61095742 | 2021-09-18 04:21:24 | Dale, Alabama, US | |
645046 | 645046 | 2021-09-07 | US | Texas | Harrison | 48203 | 8241 | 128 | 0 | 32.54935988 | -94.36934071 | 2021-09-08 04:21:31 | Harrison, Texas, US | |
1484931 | 1484931 | 2021-08-13 | US | Kentucky | Bullitt | 21029 | 8241 | 85 | 0 | 37.97162523 | -85.68955617 | 2021-08-14 04:21:25 | Bullitt, Kentucky, US | |
2900947 | 2900947 | 2021-08-12 | US | Kansas | Butler | 20015 | 8241 | 93 | 0 | 37.78134351 | -96.83878537 | 2021-08-13 04:21:24 | Butler, Kansas, US | |
1343551 | 1343551 | 2021-08-11 | US | Kansas | Butler | 20015 | 8241 | 93 | 0 | 37.78134351 | -96.83878537 | 2021-08-12 04:21:25 | Butler, Kansas, US | |
1956982 | 1956982 | 2021-08-05 | US | Arizona | Santa Cruz | 4023 | 8241 | 182 | 0 | 31.52508998 | -110.8479088 | 2021-08-06 04:21:18 | Santa Cruz, Arizona, US | |
2373268 | 2373268 | 2021-07-20 | US | Minnesota | Rice | 27131 | 8241 | 111 | 0 | 44.3543376 | -93.29658715 | 2021-07-21 04:21:40 | Rice, Minnesota, US | |
1495629 | 1495629 | 2021-07-03 | Japan | Nara | 8241 | 131 | 8037 | 73 | 34.317451 | 135.871644 | 2021-07-04 04:21:38 | Nara, Japan | ||
1710013 | 1710013 | 2021-06-02 | US | Minnesota | Clay | 27027 | 8241 | 92 | 0 | 46.89289518 | -96.48761922 | 2021-06-03 04:23:32 | Clay, Minnesota, US | |
2105831 | 2105831 | 2021-06-01 | US | Minnesota | Clay | 27027 | 8241 | 92 | 0 | 46.89289518 | -96.48761922 | 2021-06-02 04:24:34 | Clay, Minnesota, US | |
1772144 | 1772144 | 2021-05-23 | US | Georgia | Glynn | 13127 | 8241 | 176 | 0 | 31.23279254 | -81.53811412 | 2021-05-24 04:20:53 | Glynn, Georgia, US | |
1085319 | 1085319 | 2021-05-14 | US | Virginia | Roanoke | 51161 | 8241 | 144 | 0 | 37.26865804 | -80.06396753 | 2021-05-15 04:20:58 | Roanoke, Virginia, US | |
2249586 | 2249586 | 2021-04-07 | US | New Mexico | Lea | 35025 | 8241 | 158 | 0 | 32.79215361 | -103.4123733 | 2021-04-08 04:21:13 | Lea, New Mexico, US | |
243737 | 243737 | 2021-04-02 | US | Ohio | Marion | 39101 | 8241 | 136 | 0 | 40.58610662 | -83.15736305 | 2021-04-03 04:20:44 | Marion, Ohio, US | |
1747474 | 1747474 | 2021-03-20 | US | Tennessee | Hamblen | 47063 | 8241 | 169 | 0 | 36.21990035 | -83.26586179 | 2021-03-21 05:25:44 | Hamblen, Tennessee, US | |
2184553 | 2184553 | 2021-02-26 | US | Illinois | DeKalb | 17037 | 8241 | 112 | 0 | 8129 | 41.89373302 | -88.76958483 | 2021-02-27 05:22:28 | DeKalb, Illinois, US |
3050245 | 3050245 | 2021-02-16 | Mali | 8241 | 342 | 6206 | 1693 | 17.570692 | -3.996166000000001 | 2021-02-17 05:23:10 | Mali | |||
2639614 | 2639614 | 2021-02-11 | US | Missouri | Franklin | 29071 | 8241 | 148 | 0 | 8093 | 38.41127108 | -91.07522826 | 2021-02-12 05:23:29 | Franklin, Missouri, US |
1686679 | 1686679 | 2021-02-02 | US | New Mexico | Chaves | 35005 | 8241 | 133 | 0 | 8108 | 33.36406072 | -104.4665365 | 2021-02-03 05:22:52 | Chaves, New Mexico, US |
237777 | 237777 | 2021-01-18 | US | California | El Dorado | 6017 | 8241 | 47 | 0 | 8219 | 38.77965956 | -120.5233166 | 2021-01-19 05:22:15 | El Dorado, California, US |
1012544 | 1012544 | 2020-12-30 | US | New York | Niagara | 36063 | 8241 | 174 | 0 | 8067 | 43.19898042 | -78.74777412 | 2020-12-31 05:22:49 | Niagara, New York, US |
1011368 | 1011368 | 2020-12-30 | US | Indiana | Clark | 18019 | 8241 | 124 | 0 | 8117 | 38.48015445 | -85.70510334 | 2020-12-31 05:22:49 | Clark, Indiana, US |
766459 | 766459 | 2020-12-29 | Pakistan | Azad Jammu and Kashmir | 8241 | 220 | 7577 | 444 | 34.027401 | 73.947253 | 2020-12-30 05:22:34 | Azad Jammu and Kashmir, Pakistan | ||
2407493 | 2407493 | 2020-12-23 | US | Delaware | Kent | 10001 | 8241 | 181 | 0 | 8060 | 39.08646628 | -75.56884914 | 2020-12-24 05:23:04 | Kent, Delaware, US |
1903962 | 1903962 | 2020-12-18 | US | South Carolina | Berkeley | 45015 | 8241 | 109 | 0 | 8132 | 33.20222596 | -79.94654523 | 2020-12-19 05:27:52 | Berkeley, South Carolina, US |
1602503 | 1602503 | 2020-12-10 | US | North Carolina | Cabarrus | 37025 | 8241 | 111 | 0 | 8130 | 35.3877799 | -80.55267168 | 2020-12-11 05:26:59 | Cabarrus, North Carolina, US |
1006731 | 1006731 | 2020-12-06 | US | Arizona | Coconino | 4005 | 8241 | 182 | 0 | 8059 | 35.83883429 | -111.7707178 | 2020-12-07 05:26:14 | Coconino, Arizona, US |
3801809 | 3801809 | 2020-10-05 | Germany | Hamburg | 8241 | 273 | 6823 | 1243 | 53.5511 | 9.9937 | 2020-10-06 04:23:33 | Hamburg, Germany | ||
2299775 | 2299775 | 2020-08-22 | Tajikistan | 8241 | 66 | 7072 | 1103 | 38.861 | 71.2761 | 2020-08-23 04:27:48 | Tajikistan | |||
3264662 | 3264662 | 2020-07-31 | Ukraine | Kiev | 8241 | 132 | 2941 | 5168 | 50.4501 | 30.5234 | 2020-08-01 04:36:27 | Kiev, Ukraine | ||
3847124 | 3847124 | 2020-05-13 | US | Massachusetts | Worcester | 25027 | 8241 | 489 | 0 | 7752 | 42.35026951 | -71.90493363 | 2020-05-14 03:32:28 | Worcester, Massachusetts, 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]);