daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,829 rows where "day" is on date 2020-07-02 sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-02 | US | Texas | Travis | 48453 | 9050 | 128 | 0 | 9996 | 30.33432034 | -97.78535620000001 | 2020-07-03 04:33:54 | Travis, Texas, US |
2020-07-02 | US | Georgia | Colquitt | 13071 | 1016 | 18 | 0 | 998 | 31.18810588 | -83.7677946 | 2020-07-03 04:33:54 | Colquitt, Georgia, US |
2020-07-02 | US | North Carolina | Davidson | 37057 | 1012 | 15 | 0 | 997 | 35.79115496 | -80.21256572 | 2020-07-03 04:33:54 | Davidson, North Carolina, US |
2020-07-02 | US | Virginia | Stafford | 51179 | 1000 | 5 | 0 | 995 | 38.41758738 | -77.45917053 | 2020-07-03 04:33:54 | Stafford, Virginia, US |
2020-07-02 | US | New Mexico | Dona Ana | 35013 | 999 | 9 | 0 | 990 | 32.35275771 | -106.83293870000001 | 2020-07-03 04:33:54 | Dona Ana, New Mexico, US |
2020-07-02 | US | Kentucky | Jackson | 21109 | 113 | 14 | 0 | 99 | 37.41866422 | -83.99825483 | 2020-07-03 04:33:54 | Jackson, Kentucky, US |
2020-07-02 | US | Louisiana | LaSalle | 22059 | 99 | 0 | 0 | 99 | 31.67884782 | -92.15907765 | 2020-07-03 04:33:54 | LaSalle, Louisiana, US |
2020-07-02 | US | Georgia | Madison | 13195 | 103 | 4 | 0 | 99 | 34.12920917 | -83.21218732 | 2020-07-03 04:33:54 | Madison, Georgia, US |
2020-07-02 | US | Wisconsin | Manitowoc | 55071 | 100 | 1 | 0 | 99 | 44.11946801 | -87.80928853 | 2020-07-03 04:33:54 | Manitowoc, Wisconsin, US |
2020-07-02 | US | West Virginia | Ohio | 54069 | 100 | 1 | 0 | 99 | 40.0955451 | -80.62203992 | 2020-07-03 04:33:54 | Ohio, West Virginia, US |
2020-07-02 | US | Tennessee | Sullivan | 47163 | 104 | 2 | 0 | 99 | 36.51240691 | -82.30412917 | 2020-07-03 04:33:54 | Sullivan, Tennessee, US |
2020-07-02 | US | Georgia | Richmond | 13245 | 1041 | 53 | 0 | 988 | 33.35777107 | -82.07026432 | 2020-07-03 04:33:54 | Richmond, Georgia, US |
2020-07-02 | US | Louisiana | Livingston | 22063 | 1025 | 38 | 0 | 987 | 30.44143993 | -90.73061664 | 2020-07-03 04:33:54 | Livingston, Louisiana, US |
2020-07-02 | Ukraine | Kharkiv Oblast | 2207 | 84 | 1137 | 986 | 49.9935 | 36.2304 | 2020-07-03 04:33:54 | Kharkiv Oblast, Ukraine | ||
2020-07-02 | US | Georgia | Douglas | 13097 | 1021 | 36 | 0 | 985 | 33.70291126 | -84.77026156 | 2020-07-03 04:33:54 | Douglas, Georgia, US |
2020-07-02 | Sweden | Jamtland Harjedalen | 1039 | 54 | 0 | 985 | 63.1712 | 14.9592 | 2020-07-03 04:33:54 | Jamtland Harjedalen, Sweden | ||
2020-07-02 | US | District of Columbia | District of Columbia | 11001 | 10390 | 554 | 0 | 9836 | 38.90417773 | -77.01655992 | 2020-07-03 04:33:54 | District of Columbia, District of Columbia, US |
2020-07-02 | Italy | Lombardia | 94108 | 16671 | 67610 | 9827 | 45.46679409 | 9.190347404 | 2020-07-03 04:33:54 | Lombardia, Italy | ||
2020-07-02 | US | Oklahoma | Texas | 40139 | 986 | 6 | 0 | 980 | 36.74777635 | -101.4889765 | 2020-07-03 04:33:54 | Texas, Oklahoma, US |
2020-07-02 | Colombia | Magdalena | 1903 | 134 | 789 | 980 | 10.4113 | -74.4057 | 2020-07-03 04:33:54 | Magdalena, Colombia | ||
2020-07-02 | US | Ohio | Auglaize | 39011 | 99 | 1 | 0 | 98 | 40.55998859 | -84.22421429999999 | 2020-07-03 04:33:54 | Auglaize, Ohio, US |
2020-07-02 | US | New Mexico | Chaves | 35005 | 100 | 2 | 0 | 98 | 33.36406072 | -104.4665365 | 2020-07-03 04:33:54 | Chaves, New Mexico, US |
2020-07-02 | US | Missouri | Lincoln | 29113 | 99 | 1 | 0 | 98 | 39.05345619 | -90.95588181 | 2020-07-03 04:33:54 | Lincoln, Missouri, US |
2020-07-02 | US | Iowa | Mahaska | 19123 | 115 | 17 | 0 | 98 | 41.33521503 | -92.64083907 | 2020-07-03 04:33:54 | Mahaska, Iowa, US |
2020-07-02 | US | Montana | Missoula | 30063 | 99 | 1 | 0 | 98 | 47.03728583 | -113.92135079999998 | 2020-07-03 04:33:54 | Missoula, Montana, US |
2020-07-02 | Germany | Brandenburg | 3443 | 165 | 3200 | 98 | 52.4125 | 12.5316 | 2020-07-03 04:33:54 | Brandenburg, Germany | ||
2020-07-02 | US | Virginia | Norfolk | 51710 | 987 | 11 | 0 | 976 | 36.89934014 | -76.26420872 | 2020-07-03 04:33:54 | Norfolk, Virginia, US |
2020-07-02 | US | Idaho | Canyon | 16027 | 980 | 6 | 0 | 974 | 43.61970148 | -116.70954990000001 | 2020-07-03 04:33:54 | Canyon, Idaho, US |
2020-07-02 | Sweden | Kronoberg | 1068 | 96 | 0 | 972 | 56.7183 | 14.4115 | 2020-07-03 04:33:54 | Kronoberg, Sweden | ||
2020-07-02 | US | Virginia | Spotsylvania | 51177 | 1001 | 31 | 0 | 970 | 38.18574462 | -77.655399 | 2020-07-03 04:33:54 | Spotsylvania, Virginia, US |
2020-07-02 | Russia | Orenburg Oblast | 3929 | 20 | 2939 | 970 | 52.02692620000001 | 54.7276647 | 2020-07-03 04:33:54 | Orenburg Oblast, Russia | ||
2020-07-02 | US | South Carolina | Calhoun | 45017 | 99 | 2 | 0 | 97 | 33.66926881 | -80.77722168 | 2020-07-03 04:33:54 | Calhoun, South Carolina, US |
2020-07-02 | US | Arkansas | Cleburne | 5023 | 101 | 4 | 0 | 97 | 35.53864922 | -92.02640019 | 2020-07-03 04:33:54 | Cleburne, Arkansas, US |
2020-07-02 | US | New York | Clinton | 36019 | 101 | 4 | 0 | 97 | 44.74530905 | -73.67875352 | 2020-07-03 04:33:54 | Clinton, New York, US |
2020-07-02 | US | Oklahoma | Kay | 40071 | 104 | 7 | 0 | 97 | 36.81799745 | -97.14421435 | 2020-07-03 04:33:54 | Kay, Oklahoma, US |
2020-07-02 | US | Mississippi | Prentiss | 28117 | 100 | 3 | 0 | 97 | 34.61810501 | -88.51986294 | 2020-07-03 04:33:54 | Prentiss, Mississippi, US |
2020-07-02 | US | Kentucky | Pulaski | 21199 | 99 | 2 | 0 | 97 | 37.10466131 | -84.57629079 | 2020-07-03 04:33:54 | Pulaski, Kentucky, US |
2020-07-02 | US | Kentucky | Scott | 21209 | 97 | 0 | 0 | 97 | 38.29622293 | -84.5816631 | 2020-07-03 04:33:54 | Scott, Kentucky, US |
2020-07-02 | US | Florida | Hendry | 12051 | 993 | 25 | 0 | 968 | 26.55386945 | -81.16469006 | 2020-07-03 04:33:54 | Hendry, Florida, US |
2020-07-02 | US | Georgia | Glynn | 13127 | 972 | 6 | 0 | 966 | 31.23279254 | -81.53811412 | 2020-07-03 04:33:54 | Glynn, Georgia, US |
2020-07-02 | US | New Jersey | Hunterdon | 34019 | 1086 | 124 | 0 | 962 | 40.56335249 | -74.91284156 | 2020-07-03 04:33:54 | Hunterdon, New Jersey, US |
2020-07-02 | US | Ohio | Stark | 39151 | 1052 | 90 | 0 | 962 | 40.81482476 | -81.36437305 | 2020-07-03 04:33:54 | Stark, Ohio, US |
2020-07-02 | US | Georgia | Brantley | 13025 | 99 | 3 | 0 | 96 | 31.19576557 | -81.97743999 | 2020-07-03 04:33:54 | Brantley, Georgia, US |
2020-07-02 | US | Minnesota | Chisago | 27025 | 97 | 1 | 0 | 96 | 45.5021011 | -92.90861945 | 2020-07-03 04:33:54 | Chisago, Minnesota, US |
2020-07-02 | US | Tennessee | Hardin | 47071 | 109 | 7 | 0 | 96 | 35.19732531 | -88.18593755 | 2020-07-03 04:33:54 | Hardin, Tennessee, US |
2020-07-02 | US | Pennsylvania | Lawrence | 42073 | 105 | 9 | 0 | 96 | 40.99206278 | -80.33393706 | 2020-07-03 04:33:54 | Lawrence, Pennsylvania, US |
2020-07-02 | US | Iowa | Poweshiek | 19157 | 104 | 8 | 0 | 96 | 41.68625425 | -92.53155731 | 2020-07-03 04:33:54 | Poweshiek, Iowa, US |
2020-07-02 | US | Texas | Uvalde | 48463 | 51 | 1 | 0 | 96 | 29.35739637 | -99.76229172 | 2020-07-03 04:33:54 | Uvalde, Texas, US |
2020-07-02 | Comoros | 303 | 7 | 200 | 96 | -11.6455 | 43.3333 | 2020-07-03 04:33:54 | Comoros | |||
2020-07-02 | Djibouti | 4715 | 55 | 4564 | 96 | 11.8251 | 42.5903 | 2020-07-03 04:33:54 | Djibouti | |||
2020-07-02 | France | 197591 | 29794 | 72054 | 95743 | 46.2276 | 2.2137 | 2020-07-03 04:33:54 | France | |||
2020-07-02 | Switzerland | 31967 | 1810 | 29200 | 957 | 46.8182 | 8.2275 | 2020-07-03 04:33:54 | Switzerland | |||
2020-07-02 | Ukraine | Odessa Oblast | 1736 | 24 | 761 | 951 | 46.4846 | 30.7326 | 2020-07-03 04:33:54 | Odessa Oblast, Ukraine | ||
2020-07-02 | US | Oklahoma | Carter | 40019 | 96 | 1 | 0 | 95 | 34.25103751 | -97.28552485 | 2020-07-03 04:33:54 | Carter, Oklahoma, US |
2020-07-02 | US | Texas | Colorado | 48089 | 90 | 0 | 0 | 95 | 29.622097999999998 | -96.5273805 | 2020-07-03 04:33:54 | Colorado, Texas, US |
2020-07-02 | US | Arkansas | Howard | 5061 | 96 | 1 | 0 | 95 | 34.09007427 | -93.9934871 | 2020-07-03 04:33:54 | Howard, Arkansas, US |
2020-07-02 | US | Georgia | Jones | 13169 | 95 | 0 | 0 | 95 | 33.02512137 | -83.56019163 | 2020-07-03 04:33:54 | Jones, Georgia, US |
2020-07-02 | US | Virginia | King George | 51099 | 99 | 4 | 0 | 95 | 38.26818502 | -77.15852768 | 2020-07-03 04:33:54 | King George, Virginia, US |
2020-07-02 | US | Illinois | Lee | 17103 | 97 | 2 | 0 | 95 | 41.74583951 | -89.29977132 | 2020-07-03 04:33:54 | Lee, Illinois, US |
2020-07-02 | US | Georgia | McDuffie | 13189 | 102 | 7 | 0 | 95 | 33.47851918 | -82.48252774 | 2020-07-03 04:33:54 | McDuffie, Georgia, US |
2020-07-02 | US | Michigan | Montcalm | 26117 | 96 | 1 | 0 | 95 | 43.31082541 | -85.15252824 | 2020-07-03 04:33:54 | Montcalm, Michigan, US |
2020-07-02 | US | South Carolina | Union | 45087 | 95 | 0 | 0 | 95 | 34.68835752 | -81.61730349 | 2020-07-03 04:33:54 | Union, South Carolina, US |
2020-07-02 | US | Texas | Van Zandt | 48467 | 52 | 3 | 0 | 95 | 32.56483801 | -95.83766469 | 2020-07-03 04:33:54 | Van Zandt, Texas, US |
2020-07-02 | Russia | Kemerovo Oblast | 1744 | 9 | 788 | 947 | 54.53357809999999 | 87.342861 | 2020-07-03 04:33:54 | Kemerovo Oblast, Russia | ||
2020-07-02 | Peru | Moquegua | 983 | 38 | 0 | 945 | -16.860271 | -70.839046 | 2020-07-03 04:33:54 | Moquegua, Peru | ||
2020-07-02 | US | Illinois | Kendall | 17093 | 963 | 20 | 0 | 943 | 41.59081014 | -88.42869583 | 2020-07-03 04:33:54 | Kendall, Illinois, US |
2020-07-02 | India | Karnataka | 18016 | 272 | 8334 | 9410 | 14.70518 | 76.166436 | 2020-07-03 04:33:54 | Karnataka, India | ||
2020-07-02 | US | Vermont | Windham | 50025 | 97 | 3 | 0 | 94 | 42.986982 | -72.71268875 | 2020-07-03 04:33:54 | Windham, Vermont, US |
2020-07-02 | US | Virginia | Chesapeake | 51550 | 959 | 21 | 0 | 938 | 36.67670048 | -76.30545744 | 2020-07-03 04:33:54 | Chesapeake, Virginia, US |
2020-07-02 | Mexico | Jalisco | 7030 | 762 | 5332 | 936 | 20.6595 | -103.3494 | 2020-07-03 04:33:54 | Jalisco, Mexico | ||
2020-07-02 | US | Illinois | Lake | 17097 | 9752 | 418 | 0 | 9334 | 42.3224907 | -88.00367925 | 2020-07-03 04:33:54 | Lake, Illinois, US |
2020-07-02 | US | Colorado | Douglas | 8035 | 1163 | 53 | 0 | 932 | 39.33133796 | -104.930001 | 2020-07-03 04:33:54 | Douglas, Colorado, US |
2020-07-02 | Russia | Belgorod Oblast | 4637 | 42 | 3663 | 932 | 50.7080119 | 37.5837615 | 2020-07-03 04:33:54 | Belgorod Oblast, Russia | ||
2020-07-02 | US | Minnesota | Mower | 27099 | 932 | 2 | 0 | 930 | 43.67142874 | -92.75234549 | 2020-07-03 04:33:54 | Mower, Minnesota, US |
2020-07-02 | US | North Carolina | Beaufort | 37013 | 93 | 0 | 0 | 93 | 35.48531943 | -76.84325809 | 2020-07-03 04:33:54 | Beaufort, North Carolina, US |
2020-07-02 | US | Kentucky | Clark | 21049 | 98 | 5 | 0 | 93 | 37.9689263 | -84.14615986 | 2020-07-03 04:33:54 | Clark, Kentucky, US |
2020-07-02 | US | Texas | Fayette | 48149 | 83 | 2 | 0 | 93 | 29.87788372 | -96.92076062 | 2020-07-03 04:33:54 | Fayette, Texas, US |
2020-07-02 | US | Mississippi | Jefferson | 28063 | 96 | 3 | 0 | 93 | 31.73397872 | -91.03764977 | 2020-07-03 04:33:54 | Jefferson, Mississippi, US |
2020-07-02 | US | Texas | Kerr | 48265 | 75 | 1 | 0 | 93 | 30.06040006 | -99.34930144 | 2020-07-03 04:33:54 | Kerr, Texas, US |
2020-07-02 | US | Arkansas | Lawrence | 5075 | 102 | 9 | 0 | 93 | 36.04188196 | -91.10867198 | 2020-07-03 04:33:54 | Lawrence, Arkansas, US |
2020-07-02 | US | Georgia | Bibb | 13021 | 969 | 41 | 0 | 928 | 32.80904227 | -83.70489165 | 2020-07-03 04:33:54 | Bibb, Georgia, US |
2020-07-02 | Peru | Puno | 989 | 63 | 0 | 926 | -14.995826999999998 | -69.922726 | 2020-07-03 04:33:54 | Puno, Peru | ||
2020-07-02 | Korea, South | 12967 | 282 | 11759 | 926 | 35.90775700000001 | 127.766922 | 2020-07-03 04:33:54 | Korea, South | |||
2020-07-02 | Russia | Perm Krai | 3801 | 78 | 2800 | 923 | 58.5951603 | 56.3159546 | 2020-07-03 04:33:54 | Perm Krai, Russia | ||
2020-07-02 | US | Louisiana | Jefferson | 22051 | 9712 | 486 | 0 | 9226 | 29.74075478 | -90.11115756 | 2020-07-03 04:33:54 | Jefferson, Louisiana, US |
2020-07-02 | India | Telangana | 18570 | 275 | 9069 | 9226 | 18.1124 | 79.0193 | 2020-07-03 04:33:54 | Telangana, India | ||
2020-07-02 | US | North Carolina | Chatham | 37037 | 964 | 43 | 0 | 921 | 35.70394416 | -79.25541492 | 2020-07-03 04:33:54 | Chatham, North Carolina, US |
2020-07-02 | Peru | Tacna | 960 | 39 | 0 | 921 | -17.644160999999997 | -70.27756 | 2020-07-03 04:33:54 | Tacna, Peru | ||
2020-07-02 | US | Illinois | Adams | 17001 | 93 | 1 | 0 | 92 | 39.98815591 | -91.18786813 | 2020-07-03 04:33:54 | Adams, Illinois, US |
2020-07-02 | US | Texas | Castro | 48069 | 83 | 1 | 0 | 92 | 34.53016752 | -102.2617243 | 2020-07-03 04:33:54 | Castro, Texas, US |
2020-07-02 | US | Minnesota | Crow Wing | 27035 | 104 | 12 | 0 | 92 | 46.48096553 | -94.06755609 | 2020-07-03 04:33:54 | Crow Wing, Minnesota, US |
2020-07-02 | US | Iowa | Pocahontas | 19151 | 93 | 1 | 0 | 92 | 42.73420133 | -94.67862564 | 2020-07-03 04:33:54 | Pocahontas, Iowa, US |
2020-07-02 | US | Wyoming | Sweetwater | 56037 | 92 | 0 | 0 | 92 | 41.65943896 | -108.8827882 | 2020-07-03 04:33:54 | Sweetwater, Wyoming, US |
2020-07-02 | US | California | Yuba | 6115 | 93 | 1 | 0 | 92 | 39.26255932 | -121.35356440000001 | 2020-07-03 04:33:54 | Yuba, California, US |
2020-07-02 | US | Illinois | Rock Island | 17161 | 947 | 29 | 0 | 918 | 41.46613806 | -90.57042164 | 2020-07-03 04:33:54 | Rock Island, Illinois, US |
2020-07-02 | Russia | Tula Oblast | 6836 | 114 | 5805 | 917 | 53.9570701 | 37.369090899999996 | 2020-07-03 04:33:54 | Tula Oblast, Russia | ||
2020-07-02 | Nepal | 14519 | 31 | 5320 | 9168 | 28.1667 | 84.25 | 2020-07-03 04:33:54 | Nepal | |||
2020-07-02 | US | Louisiana | Bossier | 22015 | 947 | 32 | 0 | 915 | 32.67932307 | -93.60460152 | 2020-07-03 04:33:54 | Bossier, Louisiana, US |
2020-07-02 | US | Virginia | Harrisonburg | 51660 | 941 | 26 | 0 | 915 | 38.43542574 | -78.87536254 | 2020-07-03 04:33:54 | Harrisonburg, Virginia, US |
2020-07-02 | Russia | Buryatia Republic | 2991 | 19 | 2059 | 913 | 52.718242599999996 | 109.492143 | 2020-07-03 04:33:54 | Buryatia Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;