johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
110 rows where confirmed = 5789 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1629283 | 1629283 | 2022-12-18 | US | Illinois | Clay | 17025 | 5789 | 75 | 0 | 38.75388572 | -88.48914513 | 2022-12-19 04:21:03 | Clay, Illinois, US | |
504662 | 504662 | 2022-12-17 | US | Illinois | Clay | 17025 | 5789 | 75 | 0 | 38.75388572 | -88.48914513 | 2022-12-18 04:21:03 | Clay, Illinois, US | |
3325234 | 3325234 | 2022-12-16 | US | Illinois | Clay | 17025 | 5789 | 75 | 0 | 38.75388572 | -88.48914513 | 2022-12-17 04:21:04 | Clay, Illinois, US | |
1620729 | 1620729 | 2022-11-22 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-23 04:21:06 | La Paz, Arizona, US | |
3463122 | 3463122 | 2022-11-21 | US | Tennessee | Humphreys | 47085 | 5789 | 83 | 0 | 36.03958805 | -87.77992872 | 2022-11-22 04:20:47 | Humphreys, Tennessee, US | |
3460617 | 3460617 | 2022-11-21 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-22 04:20:47 | La Paz, Arizona, US | |
1640802 | 1640802 | 2022-11-20 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-21 04:21:05 | La Paz, Arizona, US | |
2064359 | 2064359 | 2022-11-19 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-20 04:21:08 | La Paz, Arizona, US | |
1755753 | 1755753 | 2022-11-18 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-19 04:21:14 | La Paz, Arizona, US | |
3026746 | 3026746 | 2022-11-17 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-18 04:21:15 | La Paz, Arizona, US | |
2486457 | 2486457 | 2022-11-16 | US | Arizona | La Paz | 4012 | 5789 | 152 | 0 | 33.72854224 | -113.9810029 | 2022-11-17 04:21:11 | La Paz, Arizona, US | |
3041118 | 3041118 | 2022-10-27 | US | Puerto Rico | Santa Isabel | 72133 | 5789 | 0 | 0 | 17.994525 | -66.388913 | 2022-10-28 04:22:31 | Santa Isabel, Puerto Rico, US | |
256789 | 256789 | 2022-09-08 | US | West Virginia | Brooke | 54009 | 5789 | 106 | 0 | 40.27367263 | -80.57915332 | 2022-09-09 04:21:11 | Brooke, West Virginia, US | |
1488064 | 1488064 | 2022-07-26 | US | Arkansas | Conway | 5029 | 5789 | 66 | 0 | 35.26205537 | -92.70506566 | 2022-07-27 04:21:04 | Conway, Arkansas, US | |
1487785 | 1487785 | 2022-07-26 | Russia | Chukotka Autonomous Okrug | 5789 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-07-27 04:21:04 | Chukotka Autonomous Okrug, Russia | |||
961097 | 961097 | 2022-07-19 | US | New Mexico | Lincoln | 35027 | 5789 | 68 | 0 | 33.74526079 | -105.4586166 | 2022-07-20 04:20:59 | Lincoln, New Mexico, US | |
3967412 | 3967412 | 2022-07-05 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-07-06 04:20:58 | Pierce, Georgia, US | |
3078923 | 3078923 | 2022-07-04 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-07-05 04:20:45 | Pierce, Georgia, US | |
1768205 | 1768205 | 2022-07-03 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-07-04 04:20:54 | Pierce, Georgia, US | |
3366191 | 3366191 | 2022-07-02 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-07-03 04:20:59 | Pierce, Georgia, US | |
594520 | 594520 | 2022-07-01 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-07-02 04:21:16 | Pierce, Georgia, US | |
3940921 | 3940921 | 2022-06-30 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-07-01 04:21:10 | Pierce, Georgia, US | |
2490879 | 2490879 | 2022-06-29 | US | Georgia | Pierce | 13229 | 5789 | 130 | 0 | 31.35928155 | -82.21598442 | 2022-06-30 04:21:01 | Pierce, Georgia, US | |
1651386 | 1651386 | 2022-06-23 | US | Tennessee | Wayne | 47181 | 5789 | 72 | 0 | 35.23868267 | -87.78644456 | 2022-06-24 04:20:58 | Wayne, Tennessee, US | |
948205 | 948205 | 2022-06-14 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-15 04:20:54 | Sumner, Kansas, US | |
2980613 | 2980613 | 2022-06-13 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-14 04:20:52 | Sumner, Kansas, US | |
2236739 | 2236739 | 2022-06-12 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-13 04:21:14 | Sumner, Kansas, US | |
3142937 | 3142937 | 2022-06-11 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-12 04:20:53 | Sumner, Kansas, US | |
1945853 | 1945853 | 2022-06-10 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-11 04:21:01 | Sumner, Kansas, US | |
3158992 | 3158992 | 2022-06-09 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-10 04:20:55 | Sumner, Kansas, US | |
1422459 | 1422459 | 2022-06-08 | US | Kansas | Sumner | 20191 | 5789 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-06-09 04:20:54 | Sumner, Kansas, US | |
3580536 | 3580536 | 2022-06-02 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-06-03 04:20:58 | Henry, Missouri, US | |
972829 | 972829 | 2022-06-01 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-06-02 05:20:39 | Henry, Missouri, US | |
232267 | 232267 | 2022-05-31 | US | Texas | Calhoun | 48057 | 5789 | 48 | 0 | 28.47048236 | -96.61633945 | 2022-06-01 04:20:55 | Calhoun, Texas, US | |
231136 | 231136 | 2022-05-31 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-06-01 04:20:55 | Henry, Missouri, US | |
3187901 | 3187901 | 2022-05-30 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-05-31 04:20:51 | Henry, Missouri, US | |
3200050 | 3200050 | 2022-05-29 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-05-30 04:20:50 | Henry, Missouri, US | |
2726928 | 2726928 | 2022-05-28 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-05-29 04:20:53 | Henry, Missouri, US | |
1316109 | 1316109 | 2022-05-27 | US | Missouri | Henry | 29083 | 5789 | 87 | 0 | 38.38482826 | -93.79293734 | 2022-05-28 04:21:07 | Henry, Missouri, US | |
225278 | 225278 | 2022-05-09 | US | Vermont | Caledonia | 50005 | 5789 | 25 | 0 | 44.46548598 | -72.10314651 | 2022-05-10 04:20:50 | Caledonia, Vermont, US | |
466677 | 466677 | 2022-05-02 | US | Vermont | Addison | 50001 | 5789 | 15 | 0 | 44.03217337 | -73.14130877 | 2022-05-03 04:21:00 | Addison, Vermont, US | |
2310038 | 2310038 | 2022-04-20 | US | Puerto Rico | Juana Diaz | 72075 | 5789 | 0 | 0 | 18.050764 | -66.49458100000001 | 2022-04-21 04:20:46 | Juana Diaz, Puerto Rico, US | |
3320883 | 3320883 | 2022-04-07 | US | Colorado | Morgan | 8087 | 5789 | 138 | 0 | 40.26279810000001 | -103.8093302 | 2022-04-08 04:20:48 | Morgan, Colorado, US | |
2801419 | 2801419 | 2022-04-06 | US | Colorado | Morgan | 8087 | 5789 | 138 | 0 | 40.26279810000001 | -103.8093302 | 2022-04-07 04:20:53 | Morgan, Colorado, US | |
3868188 | 3868188 | 2022-04-05 | US | Colorado | Morgan | 8087 | 5789 | 138 | 0 | 40.26279810000001 | -103.8093302 | 2022-04-06 04:20:49 | Morgan, Colorado, US | |
944576 | 944576 | 2022-02-28 | US | Minnesota | Meeker | 27093 | 5789 | 74 | 0 | 45.12328869 | -94.52839455 | 2022-03-01 04:21:09 | Meeker, Minnesota, US | |
1301428 | 1301428 | 2022-02-17 | US | Virginia | Mecklenburg | 51117 | 5789 | 107 | 0 | 36.67882005 | -78.36131056 | 2022-02-18 04:21:04 | Mecklenburg, Virginia, US | |
3075154 | 3075154 | 2022-02-09 | US | Indiana | LaGrange | 18087 | 5789 | 97 | 0 | 41.64232188 | -85.42674232 | 2022-02-10 04:21:14 | LaGrange, Indiana, US | |
1366018 | 1366018 | 2022-02-08 | United Kingdom | Turks and Caicos Islands | 5789 | 35 | 0 | 21.69400000000001 | -71.7979 | 2022-02-09 04:21:04 | Turks and Caicos Islands, United Kingdom | |||
1363461 | 1363461 | 2022-02-08 | US | Indiana | LaGrange | 18087 | 5789 | 97 | 0 | 41.64232188 | -85.42674232 | 2022-02-09 04:21:04 | LaGrange, Indiana, US | |
74756 | 74756 | 2022-02-07 | United Kingdom | Turks and Caicos Islands | 5789 | 35 | 0 | 21.69400000000001 | -71.7979 | 2022-02-08 04:21:15 | Turks and Caicos Islands, United Kingdom | |||
980920 | 980920 | 2022-02-01 | US | Missouri | Stoddard | 29207 | 5789 | 114 | 0 | 36.85571651 | -89.9444155 | 2022-02-02 04:21:09 | Stoddard, Missouri, US | |
2053515 | 2053515 | 2022-01-25 | US | Michigan | Emmet | 26047 | 5789 | 65 | 0 | 45.52625509 | -84.89083249 | 2022-01-26 04:21:07 | Emmet, Michigan, US | |
2053407 | 2053407 | 2022-01-25 | US | Louisiana | Plaquemines | 22075 | 5789 | 43 | 0 | 29.42245447 | -89.60322085 | 2022-01-26 04:21:07 | Plaquemines, Louisiana, US | |
1229246 | 1229246 | 2022-01-24 | US | Michigan | Emmet | 26047 | 5789 | 65 | 0 | 45.52625509 | -84.89083249 | 2022-01-25 04:21:05 | Emmet, Michigan, US | |
3428096 | 3428096 | 2022-01-21 | US | Texas | Kleberg | 48273 | 5789 | 133 | 0 | 27.42435506 | -97.69894948 | 2022-01-22 04:21:13 | Kleberg, Texas, US | |
3229838 | 3229838 | 2022-01-19 | US | Virginia | Orange | 51137 | 5789 | 69 | 0 | 38.24530219 | -78.01560400000002 | 2022-01-20 04:21:07 | Orange, Virginia, US | |
3465281 | 3465281 | 2022-01-18 | US | Indiana | Jennings | 18079 | 5789 | 76 | 0 | 38.99588883 | -85.62710784 | 2022-01-19 04:21:23 | Jennings, Indiana, US | |
1114431 | 1114431 | 2022-01-11 | US | Georgia | Madison | 13195 | 5789 | 85 | 0 | 34.12920917 | -83.21218732 | 2022-01-12 04:21:44 | Madison, Georgia, US | |
130195 | 130195 | 2022-01-09 | US | Washington | Stevens | 53065 | 5789 | 116 | 0 | 48.40035475 | -117.8542701 | 2022-01-10 04:22:07 | Stevens, Washington, US | |
1219030 | 1219030 | 2022-01-08 | US | Washington | Stevens | 53065 | 5789 | 116 | 0 | 48.40035475 | -117.8542701 | 2022-01-09 04:21:46 | Stevens, Washington, US | |
1393123 | 1393123 | 2022-01-07 | US | Washington | Stevens | 53065 | 5789 | 116 | 0 | 48.40035475 | -117.8542701 | 2022-01-08 04:21:53 | Stevens, Washington, US | |
1289459 | 1289459 | 2022-01-04 | US | Washington | Okanogan | 53047 | 5789 | 106 | 0 | 48.54855019 | -119.73872240000001 | 2022-01-05 04:21:59 | Okanogan, Washington, US | |
3658297 | 3658297 | 2021-12-10 | US | Pennsylvania | Tioga | 42117 | 5789 | 159 | 0 | 41.77255149 | -77.25433032 | 2021-12-11 04:22:45 | Tioga, Pennsylvania, US | |
3345129 | 3345129 | 2021-11-16 | US | Ohio | Putnam | 39137 | 5789 | 122 | 0 | 41.02094889 | -84.1336111 | 2021-11-17 04:21:48 | Putnam, Ohio, US | |
496004 | 496004 | 2021-11-06 | US | Alabama | Chambers | 1017 | 5789 | 144 | 0 | 32.91360079 | -85.39072749 | 2021-11-07 04:21:53 | Chambers, Alabama, US | |
444253 | 444253 | 2021-10-20 | US | Georgia | Wayne | 13305 | 5789 | 167 | 0 | 31.5521809 | -81.91894878 | 2021-10-21 04:21:18 | Wayne, Georgia, US | |
2959392 | 2959392 | 2021-10-08 | Japan | Saga | 5789 | 29 | 0 | 33.286977 | 130.115738 | 2021-10-09 04:21:34 | Saga, Japan | |||
2134513 | 2134513 | 2021-10-01 | US | Ohio | Mercer | 39107 | 5789 | 92 | 0 | 40.54043046 | -84.62912742 | 2021-10-02 04:21:25 | Mercer, Ohio, US | |
2774649 | 2774649 | 2021-09-30 | US | Michigan | Newaygo | 26123 | 5789 | 71 | 0 | 43.554373999999996 | -85.80070107 | 2021-10-01 04:21:35 | Newaygo, Michigan, US | |
708105 | 708105 | 2021-09-29 | US | Michigan | Newaygo | 26123 | 5789 | 71 | 0 | 43.554373999999996 | -85.80070107 | 2021-09-30 04:21:20 | Newaygo, Michigan, US | |
2811993 | 2811993 | 2021-09-16 | US | Texas | Waller | 48473 | 5789 | 62 | 0 | 30.01058447 | -95.99011759 | 2021-09-17 04:21:46 | Waller, Texas, US | |
3809392 | 3809392 | 2021-09-11 | US | West Virginia | Marion | 54049 | 5789 | 63 | 0 | 39.50984542 | -80.24244659 | 2021-09-12 04:21:13 | Marion, West Virginia, US | |
3107284 | 3107284 | 2021-08-24 | US | Mississippi | Neshoba | 28099 | 5789 | 186 | 0 | 32.75339664 | -89.11726492 | 2021-08-25 04:21:41 | Neshoba, Mississippi, US | |
3332359 | 3332359 | 2021-07-21 | US | Georgia | Laurens | 13175 | 5789 | 173 | 0 | 32.46325233 | -82.92221316 | 2021-07-22 04:21:19 | Laurens, Georgia, US | |
2766215 | 2766215 | 2021-07-01 | US | Kansas | Ford | 20057 | 5789 | 76 | 0 | 37.69200114 | -99.88825298 | 2021-07-02 04:21:47 | Ford, Kansas, US | |
1894423 | 1894423 | 2021-06-30 | US | Kansas | Ford | 20057 | 5789 | 76 | 0 | 37.69200114 | -99.88825298 | 2021-07-01 04:21:19 | Ford, Kansas, US | |
2423859 | 2423859 | 2021-06-23 | US | Illinois | Clinton | 17027 | 5789 | 91 | 0 | 38.60704876 | -89.42385254 | 2021-06-24 04:21:55 | Clinton, Illinois, US | |
563936 | 563936 | 2021-06-22 | US | Illinois | Clinton | 17027 | 5789 | 91 | 0 | 38.60704876 | -89.42385254 | 2021-06-23 04:21:46 | Clinton, Illinois, US | |
3359638 | 3359638 | 2021-06-21 | US | Illinois | Clinton | 17027 | 5789 | 91 | 0 | 38.60704876 | -89.42385254 | 2021-06-22 04:21:34 | Clinton, Illinois, US | |
2885337 | 2885337 | 2021-06-20 | US | Illinois | Clinton | 17027 | 5789 | 91 | 0 | 38.60704876 | -89.42385254 | 2021-06-21 04:21:41 | Clinton, Illinois, US | |
108420 | 108420 | 2021-06-19 | US | Illinois | Clinton | 17027 | 5789 | 91 | 0 | 38.60704876 | -89.42385254 | 2021-06-20 04:21:48 | Clinton, Illinois, US | |
107222 | 107222 | 2021-06-19 | Canada | Nova Scotia | 5789 | 90 | 5611 | 88 | 44.682 | -63.7443 | 2021-06-20 04:21:48 | Nova Scotia, Canada | ||
1126563 | 1126563 | 2021-06-18 | US | Illinois | Clinton | 17027 | 5789 | 91 | 0 | 38.60704876 | -89.42385254 | 2021-06-19 04:22:33 | Clinton, Illinois, US | |
1913505 | 1913505 | 2021-05-20 | Spain | Ceuta | 5789 | 114 | 163 | 5512 | 35.8894 | -5.3213 | 2021-05-21 04:20:43 | Ceuta, Spain | ||
1874510 | 1874510 | 2021-05-15 | US | Maine | Penobscot | 23019 | 5789 | 90 | 0 | 45.40194593 | -68.65020455 | 2021-05-16 04:20:49 | Penobscot, Maine, US | |
2250897 | 2250897 | 2021-04-07 | US | West Virginia | Raleigh | 54081 | 5789 | 74 | 0 | 37.76936795 | -81.2456041 | 2021-04-08 04:21:13 | Raleigh, West Virginia, US | |
3424504 | 3424504 | 2021-03-19 | US | Wisconsin | Waupaca | 55135 | 5789 | 157 | 0 | 44.47068056 | -88.96534501 | 2021-03-20 05:25:46 | Waupaca, Wisconsin, US | |
999872 | 999872 | 2021-03-01 | US | Kentucky | McCracken | 21145 | 5789 | 69 | 0 | 5720 | 37.05350953 | -88.70445755 | 2021-03-02 05:23:30 | McCracken, Kentucky, US |
3053138 | 3053138 | 2021-02-16 | US | Tennessee | McMinn | 47107 | 5789 | 88 | 0 | 5686 | 35.42812616 | -84.61520715 | 2021-02-17 05:23:10 | McMinn, Tennessee, US |
3052678 | 3052678 | 2021-02-16 | US | Ohio | Scioto | 39145 | 5789 | 95 | 0 | 5694 | 38.80270163 | -82.98907345 | 2021-02-17 05:23:10 | Scioto, Ohio, US |
908977 | 908977 | 2021-01-19 | US | Georgia | Gordon | 13129 | 5789 | 77 | 0 | 5712 | 34.50487351 | -84.87296253 | 2021-01-20 05:21:54 | Gordon, Georgia, US |
190867 | 190867 | 2021-01-11 | US | Georgia | Glynn | 13127 | 5789 | 138 | 0 | 5651 | 31.23279254 | -81.53811412 | 2021-01-12 05:22:15 | Glynn, Georgia, US |
190374 | 190374 | 2021-01-11 | Sweden | Blekinge | 5789 | 52 | 0 | 5737 | 56.2784 | 15.018 | 2021-01-12 05:22:15 | Blekinge, Sweden | ||
2626177 | 2626177 | 2021-01-10 | Sweden | Blekinge | 5789 | 52 | 0 | 5737 | 56.2784 | 15.018 | 2021-01-11 05:21:50 | Blekinge, Sweden | ||
3900265 | 3900265 | 2021-01-09 | Sweden | Blekinge | 5789 | 52 | 0 | 5737 | 56.2784 | 15.018 | 2021-01-10 05:22:12 | Blekinge, Sweden | ||
154288 | 154288 | 2021-01-08 | Sweden | Blekinge | 5789 | 52 | 0 | 5737 | 56.2784 | 15.018 | 2021-01-09 05:22:18 | Blekinge, Sweden | ||
2406711 | 2406711 | 2020-12-23 | Djibouti | 5789 | 61 | 5681 | 47 | 11.8251 | 42.5903 | 2020-12-24 05:23:04 | Djibouti | |||
3152637 | 3152637 | 2020-12-16 | US | Texas | Comal | 48091 | 5789 | 122 | 0 | 5298 | 29.80811278 | -98.27647225 | 2020-12-17 05:28:12 | Comal, Texas, US |
1632965 | 1632965 | 2020-12-05 | US | Delaware | Kent | 10001 | 5789 | 139 | 0 | 5650 | 39.08646628 | -75.56884914 | 2020-12-06 05:26:18 | Kent, Delaware, 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]);