daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
278 rows where active = 828 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-09-06 | Malaysia | Perlis | 2372 | 35 | 1509 | 828 | 6.4449 | 100.2048 | 2021-09-07 04:21:35 | Perlis, Malaysia | ||
2021-07-16 | Russia | Karachay-Cherkess Republic | 21535 | 220 | 20487 | 828 | 43.7368326 | 41.7267991 | 2021-07-17 04:22:22 | Karachay-Cherkess Republic, Russia | ||
2021-07-15 | Moldova | 257766 | 6219 | 250719 | 828 | 47.4116 | 28.3699 | 2021-07-16 04:21:22 | Moldova | |||
2021-06-25 | Moldova | 256475 | 6182 | 249465 | 828 | 47.4116 | 28.3699 | 2021-06-26 04:21:43 | Moldova | |||
2021-05-25 | Chile | Atacama | 20676 | 226 | 19622 | 828 | -27.5661 | -70.0503 | 2021-05-26 04:20:35 | Atacama, Chile | ||
2021-05-14 | Malaysia | Terengganu | 5409 | 18 | 4563 | 828 | 5.3117 | 103.1324 | 2021-05-15 04:20:58 | Terengganu, Malaysia | ||
2021-05-12 | Russia | Astrakhan Oblast | 33393 | 744 | 31821 | 828 | 47.1878186 | 47.608851 | 2021-05-13 04:20:51 | Astrakhan Oblast, Russia | ||
2021-04-07 | Colombia | Boyaca | 48698 | 1170 | 46700 | 828 | 5.4545 | -73.362 | 2021-04-08 04:21:13 | Boyaca, Colombia | ||
2021-03-29 | Russia | North Ossetia - Alania Republic | 16306 | 161 | 15317 | 828 | 42.79336110000001 | 44.6324493 | 2021-03-30 04:26:23 | North Ossetia - Alania Republic, Russia | ||
2021-03-15 | Russia | Mari El Republic | 12173 | 186 | 11159 | 828 | 56.5767504 | 47.8817512 | 2021-03-16 05:25:13 | Mari El Republic, Russia | ||
2021-03-14 | Eswatini | 17237 | 661 | 15748 | 828 | -26.5225 | 31.4659 | 2021-03-15 05:25:51 | Eswatini | |||
2021-03-13 | Russia | Mari El Republic | 12123 | 183 | 11112 | 828 | 56.5767504 | 47.8817512 | 2021-03-14 05:25:37 | Mari El Republic, Russia | ||
2021-03-13 | Colombia | Tolima | 65834 | 2121 | 62885 | 828 | 4.0925 | -75.1545 | 2021-03-14 05:25:37 | Tolima, Colombia | ||
2021-03-04 | US | Illinois | Marshall | 17123 | 843 | 15 | 0 | 828 | 41.0327901 | -89.34510444 | 2021-03-05 05:26:29 | Marshall, Illinois, US |
2021-02-27 | US | Puerto Rico | Barranquitas | 72019 | 828 | 0 | 0 | 828 | 18.201592 | -66.30963 | 2021-02-28 05:22:20 | Barranquitas, Puerto Rico, US |
2021-02-27 | India | Jammu and Kashmir | 126383 | 1956 | 123599 | 828 | 33.75943 | 76.612638 | 2021-02-28 05:22:20 | Jammu and Kashmir, India | ||
2021-02-26 | US | South Carolina | Allendale | 45005 | 843 | 15 | 0 | 828 | 32.98837386 | -81.35321066 | 2021-02-27 05:22:28 | Allendale, South Carolina, US |
2021-02-25 | Ukraine | Luhansk Oblast | 14896 | 457 | 13611 | 828 | 48.574 | 39.3078 | 2021-02-26 05:22:40 | Luhansk Oblast, Ukraine | ||
2021-02-22 | US | Georgia | Stewart | 13259 | 849 | 21 | 0 | 828 | 32.07996777 | -84.83208037 | 2021-02-23 05:23:41 | Stewart, Georgia, US |
2021-02-21 | US | Georgia | Stewart | 13259 | 849 | 21 | 0 | 828 | 32.07996777 | -84.83208037 | 2021-02-22 05:24:21 | Stewart, Georgia, US |
2021-02-21 | US | Georgia | Pulaski | 13235 | 866 | 38 | 0 | 828 | 32.23334561 | -83.47549959999998 | 2021-02-22 05:24:21 | Pulaski, Georgia, US |
2021-02-20 | US | Georgia | Stewart | 13259 | 849 | 21 | 0 | 828 | 32.07996777 | -84.83208037 | 2021-02-21 05:24:33 | Stewart, Georgia, US |
2021-02-19 | US | Georgia | Stewart | 13259 | 849 | 21 | 0 | 828 | 32.07996777 | -84.83208037 | 2021-02-20 05:22:51 | Stewart, Georgia, US |
2021-02-19 | US | Alabama | Coosa | 1037 | 851 | 23 | 0 | 828 | 32.93690146 | -86.24847739 | 2021-02-20 05:22:51 | Coosa, Alabama, US |
2021-02-14 | US | Puerto Rico | Aguas Buenas | 72007 | 828 | 0 | 0 | 828 | 18.251619 | -66.126806 | 2021-02-15 05:24:49 | Aguas Buenas, Puerto Rico, US |
2021-02-12 | US | New York | Schuyler | 36097 | 839 | 11 | 0 | 828 | 42.39184015 | -76.8773299 | 2021-02-13 05:22:12 | Schuyler, New York, US |
2021-02-12 | US | Missouri | Gasconade | 29073 | 864 | 36 | 0 | 828 | 38.43947277 | -91.50847147 | 2021-02-13 05:22:12 | Gasconade, Missouri, US |
2021-02-08 | US | Maine | Franklin | 23007 | 837 | 9 | 0 | 828 | 44.97330019 | -70.44381045 | 2021-02-09 05:23:30 | Franklin, Maine, US |
2021-02-08 | US | Georgia | Candler | 13043 | 877 | 49 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-09 05:23:30 | Candler, Georgia, US |
2021-02-07 | US | Georgia | Candler | 13043 | 877 | 49 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-08 05:22:39 | Candler, Georgia, US |
2021-02-06 | US | Georgia | Candler | 13043 | 877 | 49 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-07 05:23:00 | Candler, Georgia, US |
2021-02-05 | US | Iowa | Monroe | 19135 | 854 | 26 | 0 | 828 | 41.02988815 | -92.8690667 | 2021-02-06 05:23:55 | Monroe, Iowa, US |
2021-02-05 | US | Georgia | Candler | 13043 | 874 | 46 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-06 05:23:55 | Candler, Georgia, US |
2021-02-03 | US | Texas | Brewster | 48043 | 657 | 8 | 0 | 828 | 29.81008251 | -103.2520326 | 2021-02-04 05:22:26 | Brewster, Texas, US |
2021-02-03 | US | Georgia | Candler | 13043 | 872 | 44 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-04 05:22:26 | Candler, Georgia, US |
2021-02-02 | US | Texas | Castro | 48069 | 1088 | 25 | 0 | 828 | 34.53016752 | -102.2617243 | 2021-02-03 05:22:52 | Castro, Texas, US |
2021-02-01 | US | Texas | Brewster | 48043 | 657 | 8 | 0 | 828 | 29.81008251 | -103.2520326 | 2021-02-02 05:22:49 | Brewster, Texas, US |
2021-02-01 | US | Georgia | Candler | 13043 | 870 | 42 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-02 05:22:49 | Candler, Georgia, US |
2021-01-31 | US | Georgia | Candler | 13043 | 870 | 42 | 0 | 828 | 32.40209349 | -82.07702563 | 2021-02-01 05:22:53 | Candler, Georgia, US |
2021-01-29 | Chile | Nuble | 13595 | 262 | 12505 | 828 | -36.7226 | -71.7622 | 2021-01-30 05:22:49 | Nuble, Chile | ||
2021-01-27 | US | Georgia | Seminole | 13253 | 843 | 15 | 0 | 828 | 30.93464824 | -84.86823924 | 2021-01-28 05:22:24 | Seminole, Georgia, US |
2021-01-24 | US | Georgia | Dooly | 13093 | 859 | 31 | 0 | 828 | 32.15630737 | -83.79746561 | 2021-01-25 05:22:16 | Dooly, Georgia, US |
2021-01-23 | US | Wyoming | Washakie | 56043 | 853 | 25 | 0 | 828 | 43.90451606 | -107.68018700000002 | 2021-01-24 05:22:35 | Washakie, Wyoming, US |
2021-01-22 | US | Wyoming | Washakie | 56043 | 853 | 25 | 0 | 828 | 43.90451606 | -107.68018700000002 | 2021-01-23 05:22:03 | Washakie, Wyoming, US |
2021-01-22 | US | West Virginia | Morgan | 54065 | 838 | 10 | 0 | 828 | 39.55439028 | -78.26311676 | 2021-01-23 05:22:03 | Morgan, West Virginia, US |
2021-01-21 | US | West Virginia | Monroe | 54063 | 839 | 11 | 0 | 828 | 37.56274716 | -80.54577965 | 2021-01-22 05:22:10 | Monroe, West Virginia, US |
2021-01-21 | US | Georgia | Turner | 13287 | 855 | 27 | 0 | 828 | 31.71612656 | -83.62069378 | 2021-01-22 05:22:10 | Turner, Georgia, US |
2021-01-20 | US | Connecticut | Unassigned | 90009 | 833 | 5 | 0 | 828 | 41.85853803 | 0.0 | 2021-01-21 05:22:01 | Unassigned, Connecticut, US |
2021-01-19 | US | Georgia | Wilkes | 13317 | 841 | 13 | 0 | 828 | 33.78290391 | -82.74286107 | 2021-01-20 05:21:54 | Wilkes, Georgia, US |
2021-01-18 | US | Washington | Clallam | 53009 | 832 | 4 | 0 | 828 | 48.04754642 | -123.9226319 | 2021-01-19 05:22:15 | Clallam, Washington, US |
2021-01-17 | US | Washington | Clallam | 53009 | 832 | 4 | 0 | 828 | 48.04754642 | -123.9226319 | 2021-01-18 05:22:34 | Clallam, Washington, US |
2021-01-17 | US | Ohio | Harrison | 39067 | 856 | 28 | 0 | 828 | 40.29380509 | -81.09068544 | 2021-01-18 05:22:34 | Harrison, Ohio, US |
2021-01-16 | US | Kentucky | Trigg | 21221 | 831 | 3 | 0 | 828 | 36.80767017 | -87.87333656 | 2021-01-17 05:22:17 | Trigg, Kentucky, US |
2021-01-14 | US | Colorado | Las Animas | 8071 | 893 | 10 | 0 | 828 | 37.3153406 | -104.0376458 | 2021-01-15 05:22:24 | Las Animas, Colorado, US |
2021-01-13 | US | Illinois | Menard | 17129 | 834 | 6 | 0 | 828 | 40.02742725 | -89.80246001 | 2021-01-14 05:22:32 | Menard, Illinois, US |
2021-01-10 | US | Missouri | Barton | 29011 | 836 | 8 | 0 | 828 | 37.50207671 | -94.34757022 | 2021-01-11 05:21:50 | Barton, Missouri, US |
2021-01-07 | US | Pennsylvania | Wyoming | 42131 | 860 | 32 | 0 | 828 | 41.51955538 | -76.01074915 | 2021-01-08 05:22:42 | Wyoming, Pennsylvania, US |
2021-01-07 | US | Iowa | Unassigned | 90019 | 828 | 0 | 0 | 828 | 43.38107862 | 0.0 | 2021-01-08 05:22:42 | Unassigned, Iowa, US |
2021-01-05 | US | Oregon | Hood River | 41027 | 848 | 20 | 0 | 828 | 45.51872811 | -121.65520359999998 | 2021-01-06 05:22:16 | Hood River, Oregon, US |
2021-01-04 | US | Nebraska | Cuming | 31039 | 837 | 9 | 0 | 828 | 41.91637624 | -96.78730772 | 2021-01-05 05:21:49 | Cuming, Nebraska, US |
2021-01-04 | US | Iowa | Palo Alto | 19147 | 836 | 8 | 0 | 828 | 43.08193849 | -94.67824621 | 2021-01-05 05:21:49 | Palo Alto, Iowa, US |
2021-01-03 | US | Kansas | Osage | 20139 | 836 | 8 | 0 | 828 | 38.65235984 | -95.72707998 | 2021-01-04 05:22:02 | Osage, Kansas, US |
2021-01-02 | US | Kansas | Osage | 20139 | 836 | 8 | 0 | 828 | 38.65235984 | -95.72707998 | 2021-01-03 05:22:52 | Osage, Kansas, US |
2021-01-01 | US | Kansas | Osage | 20139 | 836 | 8 | 0 | 828 | 38.65235984 | -95.72707998 | 2021-01-02 05:22:33 | Osage, Kansas, US |
2021-01-01 | China | Hong Kong | 8888 | 149 | 7912 | 828 | 22.3 | 114.2 | 2021-01-02 05:22:33 | Hong Kong, China | ||
2020-12-28 | US | Virginia | Hopewell | 51670 | 838 | 10 | 0 | 828 | 37.29186313 | -77.29754684 | 2020-12-29 05:22:37 | Hopewell, Virginia, US |
2020-12-28 | US | Montana | Deer Lodge | 30023 | 838 | 10 | 0 | 828 | 46.05953325 | -113.073353 | 2020-12-29 05:22:37 | Deer Lodge, Montana, US |
2020-12-27 | US | Montana | Deer Lodge | 30023 | 838 | 10 | 0 | 828 | 46.05953325 | -113.073353 | 2020-12-28 05:22:06 | Deer Lodge, Montana, US |
2020-12-24 | US | Alabama | Wilcox | 1131 | 847 | 19 | 0 | 828 | 31.98773215 | -87.30891118 | 2020-12-25 05:22:48 | Wilcox, Alabama, US |
2020-12-22 | US | Kansas | Thomas | 20193 | 835 | 7 | 0 | 828 | 39.35107575 | -101.0553705 | 2020-12-23 05:22:03 | Thomas, Kansas, US |
2020-12-21 | US | Puerto Rico | Corozal | 72047 | 828 | 0 | 0 | 828 | 18.304264 | -66.327738 | 2020-12-22 05:22:33 | Corozal, Puerto Rico, US |
2020-12-21 | US | Kentucky | Caldwell | 21033 | 843 | 15 | 0 | 828 | 37.14749129 | -87.86948214 | 2020-12-22 05:22:33 | Caldwell, Kentucky, US |
2020-12-21 | US | Kansas | Thomas | 20193 | 835 | 7 | 0 | 828 | 39.35107575 | -101.0553705 | 2020-12-22 05:22:33 | Thomas, Kansas, US |
2020-12-20 | US | Virginia | Page | 51139 | 861 | 33 | 0 | 828 | 38.61807452 | -78.48797204 | 2020-12-21 05:27:58 | Page, Virginia, US |
2020-12-20 | US | Montana | Park | 30067 | 832 | 4 | 0 | 828 | 45.48965095 | -110.52643940000002 | 2020-12-21 05:27:58 | Park, Montana, US |
2020-12-20 | US | Minnesota | Faribault | 27043 | 836 | 8 | 0 | 828 | 43.67381499 | -93.94787458 | 2020-12-21 05:27:58 | Faribault, Minnesota, US |
2020-12-20 | US | Idaho | Owyhee | 16073 | 846 | 18 | 0 | 828 | 42.58016894 | -116.1693871 | 2020-12-21 05:27:58 | Owyhee, Idaho, US |
2020-12-19 | US | Texas | Ochiltree | 48357 | 945 | 10 | 0 | 828 | 36.27829105 | -100.8158184 | 2020-12-20 05:27:32 | Ochiltree, Texas, US |
2020-12-18 | US | Arkansas | Grant | 5053 | 838 | 10 | 0 | 828 | 34.29017991 | -92.42320562 | 2020-12-19 05:27:52 | Grant, Arkansas, US |
2020-12-17 | US | Texas | Freestone | 48161 | 918 | 20 | 0 | 828 | 31.70422788 | -96.15072516 | 2020-12-18 05:28:18 | Freestone, Texas, US |
2020-12-17 | US | Nebraska | Wayne | 31179 | 833 | 5 | 0 | 828 | 42.20934475 | -97.11926964 | 2020-12-18 05:28:18 | Wayne, Nebraska, US |
2020-12-17 | US | Idaho | Fremont | 16043 | 840 | 12 | 0 | 828 | 44.22800938 | -111.4809943 | 2020-12-18 05:28:18 | Fremont, Idaho, US |
2020-12-16 | US | Virginia | Manassas Park | 51685 | 836 | 8 | 0 | 828 | 38.77058531 | -77.44399307 | 2020-12-17 05:28:12 | Manassas Park, Virginia, US |
2020-12-16 | US | Tennessee | Jackson | 47087 | 908 | 17 | 0 | 828 | 36.36380466 | -85.67239905 | 2020-12-17 05:28:12 | Jackson, Tennessee, US |
2020-12-16 | US | Georgia | Bacon | 13005 | 852 | 24 | 0 | 828 | 31.55456473 | -82.45936528 | 2020-12-17 05:28:12 | Bacon, Georgia, US |
2020-12-14 | US | New York | Orleans | 36073 | 887 | 59 | 0 | 828 | 43.2516977 | -78.2320066 | 2020-12-15 05:26:38 | Orleans, New York, US |
2020-12-14 | Colombia | Caqueta | 14038 | 497 | 12713 | 828 | 0.8699 | -73.8419 | 2020-12-15 05:26:38 | Caqueta, Colombia | ||
2020-12-13 | US | Alabama | Lowndes | 1085 | 858 | 30 | 0 | 828 | 32.1597283 | -86.65158371 | 2020-12-14 05:26:27 | Lowndes, Alabama, US |
2020-12-12 | US | Pennsylvania | Elk | 42047 | 839 | 11 | 0 | 828 | 41.42822061 | -78.64524744 | 2020-12-13 05:27:20 | Elk, Pennsylvania, US |
2020-12-12 | US | Mississippi | Smith | 28129 | 845 | 17 | 0 | 828 | 32.01744532 | -89.50644846 | 2020-12-13 05:27:20 | Smith, Mississippi, US |
2020-12-12 | US | Illinois | Mason | 17125 | 857 | 29 | 0 | 828 | 40.23917274 | -89.91824452 | 2020-12-13 05:27:20 | Mason, Illinois, US |
2020-12-11 | US | South Carolina | Saluda | 45081 | 855 | 27 | 0 | 828 | 34.00795823 | -81.72713237 | 2020-12-12 05:26:19 | Saluda, South Carolina, US |
2020-12-11 | US | Iowa | Shelby | 19165 | 847 | 19 | 0 | 828 | 41.6850066 | -95.31015553 | 2020-12-12 05:26:19 | Shelby, Iowa, US |
2020-12-11 | US | Florida | Gilchrist | 12041 | 848 | 20 | 0 | 828 | 29.72856978 | -82.79880657 | 2020-12-12 05:26:19 | Gilchrist, Florida, US |
2020-12-08 | US | Missouri | Wright | 29229 | 843 | 15 | 0 | 828 | 37.27029221 | -92.46914488 | 2020-12-09 05:28:01 | Wright, Missouri, US |
2020-12-08 | US | Missouri | Livingston | 29117 | 844 | 16 | 0 | 828 | 39.78110272 | -93.54645978 | 2020-12-09 05:28:01 | Livingston, Missouri, US |
2020-12-08 | Lesotho | 2150 | 44 | 1278 | 828 | -29.61 | 28.2336 | 2020-12-09 05:28:01 | Lesotho | |||
2020-12-07 | Lesotho | 2150 | 44 | 1278 | 828 | -29.61 | 28.2336 | 2020-12-08 05:27:42 | Lesotho | |||
2020-12-06 | US | Indiana | Franklin | 18047 | 856 | 28 | 0 | 828 | 39.4142482 | -85.06062647 | 2020-12-07 05:26:14 | Franklin, Indiana, US |
2020-12-06 | Lesotho | 2150 | 44 | 1278 | 828 | -29.61 | 28.2336 | 2020-12-07 05:26:14 | Lesotho |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;