johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
101 rows where active = 6 and "day" is on date 2020-04-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
589248 | 589248 | 2020-04-05 | Somalia | 7 | 0 | 1 | 6 | 5.152149 | 46.199616 | 2020-04-05 23:06:26 | Somalia | |||
589244 | 589244 | 2020-04-05 | Sierra Leone | 6 | 0 | 0 | 6 | 8.460555000000001 | -11.779889 | 2020-04-05 23:06:26 | Sierra Leone | |||
589237 | 589237 | 2020-04-05 | Saint Vincent and the Grenadines | 7 | 0 | 1 | 6 | 12.9843 | -61.2872 | 2020-04-05 23:06:26 | Saint Vincent and the Grenadines | |||
589201 | 589201 | 2020-04-05 | Maldives | 19 | 0 | 13 | 6 | 3.2028 | 73.2207 | 2020-04-05 23:06:26 | Maldives | |||
589193 | 589193 | 2020-04-05 | Liberia | 10 | 1 | 3 | 6 | 6.4280550000000005 | -9.429499 | 2020-04-05 23:06:26 | Liberia | |||
589127 | 589127 | 2020-04-05 | Cabo Verde | 7 | 1 | 0 | 6 | 16.5388 | -23.0418 | 2020-04-05 23:06:26 | Cabo Verde | |||
589096 | 589096 | 2020-04-05 | Canada | Yukon | 6 | 0 | 0 | 6 | 64.2823 | -135.0 | 2020-04-05 23:13:28 | ,Yukon,Canada | ||
589056 | 589056 | 2020-04-05 | United Kingdom | Montserrat | 6 | 0 | 0 | 6 | 16.742498 | -62.187366000000004 | 2020-04-05 23:06:26 | Montserrat, United Kingdom | ||
588980 | 588980 | 2020-04-05 | US | Missouri | Wright | 29229 | 6 | 0 | 0 | 6 | 37.27029221 | -92.46914488 | 2020-04-05 23:06:45 | Wright, Missouri, US |
588969 | 588969 | 2020-04-05 | US | Illinois | Woodford | 17203 | 6 | 0 | 0 | 6 | 40.78579374 | -89.20973757 | 2020-04-05 23:06:45 | Woodford, Illinois, US |
588949 | 588949 | 2020-04-05 | US | Texas | Wilson | 48493 | 11 | 0 | 0 | 6 | 29.1732598 | -98.08693082 | 2020-04-05 23:06:45 | Wilson, Texas, US |
588855 | 588855 | 2020-04-05 | US | Georgia | Washington | 13303 | 6 | 0 | 0 | 6 | 32.96711864 | -82.79357039 | 2020-04-05 23:06:45 | Washington, Georgia, US |
588817 | 588817 | 2020-04-05 | US | Florida | Wakulla | 12129 | 6 | 0 | 0 | 6 | 30.16548905 | -84.39895211 | 2020-04-05 23:06:45 | Wakulla, Florida, US |
588812 | 588812 | 2020-04-05 | US | Minnesota | Wabasha | 27157 | 6 | 0 | 0 | 6 | 44.28424356 | -92.23121312 | 2020-04-05 23:06:45 | Wabasha, Minnesota, US |
588794 | 588794 | 2020-04-05 | US | Iowa | Van Buren | 19177 | 6 | 0 | 0 | 6 | 40.75326764 | -91.95017958 | 2020-04-05 23:06:45 | Van Buren, Iowa, US |
588776 | 588776 | 2020-04-05 | US | Mississippi | Union | 28145 | 6 | 0 | 0 | 6 | 34.49162015 | -89.00776006 | 2020-04-05 23:06:45 | Union, Mississippi, US |
588702 | 588702 | 2020-04-05 | US | New Mexico | Torrance | 35057 | 6 | 0 | 0 | 6 | 34.64048375 | -105.8508949 | 2020-04-05 23:06:45 | Torrance, New Mexico, US |
588691 | 588691 | 2020-04-05 | US | Indiana | Tipton | 18159 | 6 | 0 | 0 | 6 | 40.31123252 | -86.05234925 | 2020-04-05 23:06:45 | Tipton, Indiana, US |
588617 | 588617 | 2020-04-05 | US | North Carolina | Stokes | 37169 | 6 | 0 | 0 | 6 | 36.4017975 | -80.23893369 | 2020-04-05 23:06:45 | Stokes, North Carolina, US |
588610 | 588610 | 2020-04-05 | US | Indiana | Steuben | 18151 | 6 | 0 | 0 | 6 | 41.64423868 | -85.00101094 | 2020-04-05 23:06:45 | Steuben, Indiana, US |
588607 | 588607 | 2020-04-05 | US | Georgia | Stephens | 13257 | 6 | 0 | 0 | 6 | 34.55151201 | -83.29405315 | 2020-04-05 23:06:45 | Stephens, Georgia, US |
588605 | 588605 | 2020-04-05 | US | Minnesota | Stearns | 27145 | 6 | 0 | 0 | 6 | 45.55192576 | -94.61078221 | 2020-04-05 23:06:45 | Stearns, Minnesota, US |
588604 | 588604 | 2020-04-05 | US | Missouri | Ste. Genevieve | 29186 | 6 | 0 | 0 | 6 | 37.89090059 | -90.1949941 | 2020-04-05 23:06:45 | Ste. Genevieve, Missouri, US |
588602 | 588602 | 2020-04-05 | US | Texas | Starr | 48427 | 4 | 0 | 0 | 6 | 26.56150059 | -98.73892358 | 2020-04-05 23:06:45 | Starr, Texas, US |
588554 | 588554 | 2020-04-05 | US | New Mexico | Socorro | 35053 | 6 | 0 | 0 | 6 | 34.00715494 | -106.9298354 | 2020-04-05 23:06:45 | Socorro,New Mexico,US |
588527 | 588527 | 2020-04-05 | US | Iowa | Shelby | 19165 | 6 | 0 | 0 | 6 | 41.6850066 | -95.31015553 | 2020-04-05 23:06:45 | Shelby, Iowa, US |
588516 | 588516 | 2020-04-05 | US | Arkansas | Sevier | 5133 | 6 | 0 | 0 | 6 | 33.99780401 | -94.2424869 | 2020-04-05 23:06:45 | Sevier, Arkansas, US |
588489 | 588489 | 2020-04-05 | US | Georgia | Schley | 13249 | 6 | 0 | 0 | 6 | 32.2654021 | -84.31258912 | 2020-04-05 23:06:45 | Schley, Georgia, US |
588403 | 588403 | 2020-04-05 | US | New Mexico | Rio Arriba | 35039 | 6 | 0 | 0 | 6 | 36.51072137 | -106.69316740000001 | 2020-04-05 23:06:45 | Rio Arriba, New Mexico, US |
588365 | 588365 | 2020-04-05 | US | Mississippi | Quitman | 28119 | 6 | 0 | 0 | 6 | 34.25157572 | -90.28908 | 2020-04-05 23:06:45 | Quitman, Mississippi, US |
588362 | 588362 | 2020-04-05 | US | West Virginia | Putnam | 54079 | 6 | 0 | 0 | 6 | 38.50782345 | -81.9082131 | 2020-04-05 23:06:45 | Putnam, West Virginia, US |
588353 | 588353 | 2020-04-05 | US | Georgia | Pulaski | 13235 | 6 | 0 | 0 | 6 | 32.23334561 | -83.47549959999998 | 2020-04-05 23:06:45 | Pulaski, Georgia, US |
588319 | 588319 | 2020-04-05 | US | North Carolina | Polk | 37149 | 6 | 0 | 0 | 6 | 35.27820615 | -82.16812354 | 2020-04-05 23:06:45 | Polk, North Carolina, US |
588302 | 588302 | 2020-04-05 | US | Oklahoma | Pittsburg | 40121 | 6 | 0 | 0 | 6 | 34.92065823 | -95.75134320000001 | 2020-04-05 23:06:45 | Pittsburg, Oklahoma, US |
588240 | 588240 | 2020-04-05 | US | Texas | Parker | 48367 | 3 | 0 | 0 | 6 | 32.77757172 | -97.80500621 | 2020-04-05 23:06:45 | Parker, Texas, US |
588237 | 588237 | 2020-04-05 | US | Montana | Park | 30067 | 6 | 0 | 0 | 6 | 45.48965095 | -110.52643940000002 | 2020-04-05 23:06:45 | Park, Montana, US |
588140 | 588140 | 2020-04-05 | US | Oklahoma | Noble | 40103 | 6 | 0 | 0 | 6 | 36.38953329 | -97.22928674 | 2020-04-05 23:06:45 | Noble, Oklahoma, US |
588133 | 588133 | 2020-04-05 | US | Missouri | Newton | 29145 | 6 | 0 | 0 | 6 | 36.90519407 | -94.3394104 | 2020-04-05 23:06:45 | Newton, Missouri, US |
588074 | 588074 | 2020-04-05 | US | Texas | Moore | 48341 | 10 | 0 | 0 | 6 | 35.83769242 | -101.8930281 | 2020-04-05 23:06:45 | Moore, Texas, US |
588070 | 588070 | 2020-04-05 | US | Virginia | Montgomery | 51121 | 6 | 0 | 0 | 6 | 37.17746986 | -80.37868691 | 2020-04-05 23:06:45 | Montgomery, Virginia, US |
588059 | 588059 | 2020-04-05 | US | Kansas | Montgomery | 20125 | 6 | 0 | 0 | 6 | 37.19236568 | -95.74329258 | 2020-04-05 23:06:45 | Montgomery, Kansas, US |
588050 | 588050 | 2020-04-05 | US | Wisconsin | Monroe | 55081 | 6 | 0 | 0 | 6 | 43.94641218 | -90.61881899999999 | 2020-04-05 23:06:45 | Monroe, Wisconsin, US |
588049 | 588049 | 2020-04-05 | US | Tennessee | Monroe | 47123 | 6 | 0 | 0 | 6 | 35.44550387 | -84.24902965 | 2020-04-05 23:06:45 | Monroe, Tennessee, US |
588038 | 588038 | 2020-04-05 | US | Alabama | Monroe | 1099 | 6 | 0 | 0 | 6 | 31.56729412 | -87.36995001 | 2020-04-05 23:06:45 | Monroe, Alabama, US |
588036 | 588036 | 2020-04-05 | US | Iowa | Monona | 19133 | 6 | 0 | 0 | 6 | 42.05220391 | -95.95743843 | 2020-04-05 23:06:45 | Monona, Iowa, US |
587996 | 587996 | 2020-04-05 | US | Ohio | Mercer | 39107 | 7 | 1 | 0 | 6 | 40.54043046 | -84.62912742 | 2020-04-05 23:06:45 | Mercer, Ohio, US |
587930 | 587930 | 2020-04-05 | US | Tennessee | Marshall | 47117 | 6 | 0 | 0 | 6 | 35.45798777 | -86.76420988 | 2020-04-05 23:06:45 | Marshall, Tennessee, US |
587925 | 587925 | 2020-04-05 | US | Indiana | Marshall | 18099 | 6 | 0 | 0 | 6 | 41.32467367 | -86.26185087 | 2020-04-05 23:06:45 | Marshall, Indiana, US |
587876 | 587876 | 2020-04-05 | US | Georgia | Madison | 13195 | 7 | 1 | 0 | 6 | 34.12920917 | -83.21218732 | 2020-04-05 23:06:45 | Madison, Georgia, US |
587868 | 587868 | 2020-04-05 | US | Illinois | Macon | 17115 | 6 | 0 | 0 | 6 | 39.86064913 | -88.96342505 | 2020-04-05 23:06:45 | Macon, Illinois, US |
587866 | 587866 | 2020-04-05 | US | Alabama | Macon | 1087 | 6 | 0 | 0 | 6 | 32.38759944 | -85.69267724 | 2020-04-05 23:06:45 | Macon, Alabama, US |
587843 | 587843 | 2020-04-05 | US | Iowa | Louisa | 19115 | 6 | 0 | 0 | 6 | 41.21842119 | -91.26102611 | 2020-04-05 23:06:45 | Louisa, Iowa, US |
587834 | 587834 | 2020-04-05 | US | Oklahoma | Logan | 40083 | 6 | 0 | 0 | 6 | 35.91899576 | -97.44352845 | 2020-04-05 23:06:45 | Logan, Oklahoma, US |
587796 | 587796 | 2020-04-05 | US | Texas | Liberty | 48291 | 5 | 0 | 0 | 6 | 30.15152688 | -94.81205615 | 2020-04-05 23:06:45 | Liberty, Texas, US |
587750 | 587750 | 2020-04-05 | US | South Carolina | Laurens | 45059 | 6 | 0 | 0 | 6 | 34.48244419 | -82.00490796 | 2020-04-05 23:06:45 | Laurens, South Carolina, US |
587697 | 587697 | 2020-04-05 | US | Ohio | Knox | 39083 | 7 | 1 | 0 | 6 | 40.39830217 | -82.42027563 | 2020-04-05 23:06:45 | Knox, Ohio, US |
587650 | 587650 | 2020-04-05 | US | Michigan | Kalkaska | 26079 | 8 | 2 | 0 | 6 | 44.68512729 | -85.09085699 | 2020-04-05 23:06:45 | Kalkaska, Michigan, US |
587643 | 587643 | 2020-04-05 | US | Iowa | Jones | 19105 | 6 | 0 | 0 | 6 | 42.12118609 | -91.13139641 | 2020-04-05 23:06:45 | Jones, Iowa, US |
587642 | 587642 | 2020-04-05 | US | Georgia | Jones | 13169 | 6 | 0 | 0 | 6 | 33.02512137 | -83.56019163 | 2020-04-05 23:06:45 | Jones, Georgia, US |
587616 | 587616 | 2020-04-05 | US | Tennessee | Jefferson | 47089 | 6 | 0 | 0 | 6 | 36.04818632 | -83.45148924 | 2020-04-05 23:06:45 | Jefferson, Tennessee, US |
587562 | 587562 | 2020-04-05 | US | Georgia | Irwin | 13155 | 6 | 0 | 0 | 6 | 31.60213036 | -83.27501387 | 2020-04-05 23:06:45 | Irwin, Georgia, US |
587556 | 587556 | 2020-04-05 | US | Iowa | Iowa | 19095 | 6 | 0 | 0 | 6 | 41.68630265 | -92.0643373 | 2020-04-05 23:06:45 | Iowa, Iowa, US |
587475 | 587475 | 2020-04-05 | US | Kentucky | Henderson | 21101 | 6 | 0 | 0 | 6 | 37.79344553 | -87.57392021 | 2020-04-05 23:06:45 | Henderson, Kentucky, US |
587445 | 587445 | 2020-04-05 | US | Tennessee | Hardeman | 47069 | 6 | 0 | 0 | 6 | 35.20772017 | -88.99161161 | 2020-04-05 23:06:45 | Hardeman, Tennessee, US |
587441 | 587441 | 2020-04-05 | US | West Virginia | Hancock | 54029 | 6 | 0 | 0 | 6 | 40.51943859 | -80.57461608 | 2020-04-05 23:06:45 | Hancock, West Virginia, US |
587426 | 587426 | 2020-04-05 | US | Nebraska | Hamilton | 31081 | 6 | 0 | 0 | 6 | 40.87349452 | -98.02099117 | 2020-04-05 23:06:45 | Hamilton, Nebraska, US |
587391 | 587391 | 2020-04-05 | US | North Carolina | Greene | 37079 | 6 | 0 | 0 | 6 | 35.48544173 | -77.67578087 | 2020-04-05 23:06:45 | Greene, North Carolina, US |
587379 | 587379 | 2020-04-05 | US | Washington | Grays Harbor | 53027 | 6 | 0 | 0 | 6 | 47.14003705 | -123.7820567 | 2020-04-05 23:06:45 | Grays Harbor, Washington, US |
587194 | 587194 | 2020-04-05 | US | South Carolina | Edgefield | 45037 | 6 | 0 | 0 | 6 | 33.77221995 | -81.96231108 | 2020-04-05 23:06:45 | Edgefield, South Carolina, US |
587170 | 587170 | 2020-04-05 | US | Indiana | Dubois | 18037 | 6 | 0 | 0 | 6 | 38.36597551 | -86.87924170000002 | 2020-04-05 23:06:45 | Dubois, Indiana, US |
587090 | 587090 | 2020-04-05 | US | North Carolina | Dare | 37055 | 6 | 0 | 0 | 6 | 35.66520691 | -75.71767334 | 2020-04-05 23:06:45 | Dare, North Carolina, US |
587077 | 587077 | 2020-04-05 | US | New Mexico | Curry | 35009 | 6 | 0 | 0 | 6 | 34.57421077 | -103.34688759999999 | 2020-04-05 23:06:45 | Curry, New Mexico, US |
587063 | 587063 | 2020-04-05 | US | Minnesota | Crow Wing | 27035 | 6 | 0 | 0 | 6 | 46.48096553 | -94.06755609 | 2020-04-05 23:06:45 | Crow Wing, Minnesota, US |
587036 | 587036 | 2020-04-05 | US | Mississippi | Covington | 28031 | 6 | 0 | 0 | 6 | 31.63225413 | -89.55389939 | 2020-04-05 23:06:45 | Covington, Mississippi, US |
587027 | 587027 | 2020-04-05 | US | Alabama | Coosa | 1037 | 6 | 0 | 0 | 6 | 32.93690146 | -86.24847739 | 2020-04-05 23:06:45 | Coosa, Alabama, US |
587008 | 587008 | 2020-04-05 | US | Oregon | Columbia | 41009 | 6 | 0 | 0 | 6 | 45.94464254 | -123.08908980000001 | 2020-04-05 23:06:45 | Columbia, Oregon, US |
586965 | 586965 | 2020-04-05 | US | Colorado | Clear Creek | 8019 | 12 | 0 | 0 | 6 | 39.68864463 | -105.6463118 | 2020-04-05 23:06:45 | Clear Creek, Colorado, US |
586943 | 586943 | 2020-04-05 | US | Wisconsin | Clark | 55019 | 6 | 0 | 0 | 6 | 44.73483377 | -90.61207486 | 2020-04-05 23:06:45 | Clark, Wisconsin, US |
586940 | 586940 | 2020-04-05 | US | Ohio | Clark | 39023 | 8 | 2 | 0 | 6 | 39.91592258 | -83.78498252 | 2020-04-05 23:06:45 | Clark, Ohio, US |
586917 | 586917 | 2020-04-05 | US | Alabama | Choctaw | 1023 | 6 | 0 | 0 | 6 | 32.02227341 | -88.26564429999998 | 2020-04-05 23:06:45 | Choctaw, Alabama, US |
586907 | 586907 | 2020-04-05 | US | Tennessee | Chester | 47023 | 5 | 0 | 0 | 6 | 35.42527478 | -88.6095842 | 2020-04-05 23:06:45 | Chester, Tennessee, US |
586901 | 586901 | 2020-04-05 | US | Texas | Cherokee | 48073 | 6 | 0 | 0 | 6 | 31.837258000000002 | -95.16559897 | 2020-04-05 23:06:45 | Cherokee, Texas, US |
586859 | 586859 | 2020-04-05 | US | Georgia | Catoosa | 13047 | 6 | 0 | 0 | 6 | 34.89872298 | -85.13757014 | 2020-04-05 23:06:45 | Catoosa, Georgia, US |
586848 | 586848 | 2020-04-05 | US | Michigan | Cass | 26027 | 7 | 1 | 0 | 6 | 41.91522292 | -85.99405727 | 2020-04-05 23:06:45 | Cass, Michigan, US |
586815 | 586815 | 2020-04-05 | US | Tennessee | Cannon | 47015 | 6 | 0 | 0 | 6 | 35.80990797 | -86.05738983 | 2020-04-05 23:06:45 | Cannon, Tennessee, US |
586788 | 586788 | 2020-04-05 | US | Vermont | Caledonia | 50005 | 6 | 0 | 0 | 6 | 44.46548598 | -72.10314651 | 2020-04-05 23:06:45 | Caledonia, Vermont, US |
586740 | 586740 | 2020-04-05 | US | Texas | Brown | 48049 | 6 | 0 | 0 | 6 | 31.77430356 | -98.99907113 | 2020-04-05 23:06:45 | Brown, Texas, US |
586732 | 586732 | 2020-04-05 | US | Georgia | Brooks | 13027 | 6 | 0 | 0 | 6 | 30.83922642 | -83.58303423 | 2020-04-05 23:06:45 | Brooks, Georgia, US |
586699 | 586699 | 2020-04-05 | US | Idaho | Bonneville | 16019 | 6 | 0 | 0 | 6 | 43.38713372 | -111.6161537 | 2020-04-05 23:06:45 | Bonneville, Idaho, US |
586686 | 586686 | 2020-04-05 | US | Pennsylvania | Blair | 42013 | 6 | 0 | 0 | 6 | 40.47961444 | -78.34917412 | 2020-04-05 23:06:45 | Blair, Pennsylvania, US |
586675 | 586675 | 2020-04-05 | US | North Carolina | Bertie | 37015 | 7 | 1 | 0 | 6 | 36.0688473 | -76.96545943 | 2020-04-05 23:06:45 | Bertie, North Carolina, US |
586654 | 586654 | 2020-04-05 | US | Minnesota | Beltrami | 27007 | 6 | 0 | 0 | 6 | 47.97373527 | -94.93732139 | 2020-04-05 23:06:45 | Beltrami, Minnesota, US |
586628 | 586628 | 2020-04-05 | US | Michigan | Barry | 26015 | 6 | 0 | 0 | 6 | 42.59513984 | -85.30834519 | 2020-04-05 23:06:45 | Barry, Michigan, US |
586610 | 586610 | 2020-04-05 | US | Georgia | Bacon | 13005 | 6 | 0 | 0 | 6 | 31.55456473 | -82.45936528 | 2020-04-05 23:06:45 | Bacon, Georgia, US |
586603 | 586603 | 2020-04-05 | US | Ohio | Auglaize | 39011 | 6 | 0 | 0 | 6 | 40.55998859 | -84.22421429999999 | 2020-04-05 23:06:45 | Auglaize, Ohio, US |
586567 | 586567 | 2020-04-05 | US | Texas | Andrews | 48003 | 4 | 0 | 0 | 6 | 32.30468633 | -102.63765479999999 | 2020-04-05 23:06:45 | Andrews, Texas, US |
586559 | 586559 | 2020-04-05 | US | Virginia | Amherst | 51009 | 6 | 0 | 0 | 6 | 37.60308293 | -79.14548696 | 2020-04-05 23:06:45 | Amherst, Virginia, US |
586558 | 586558 | 2020-04-05 | US | Virginia | Amelia | 51007 | 6 | 0 | 0 | 6 | 37.34081025 | -77.98584649 | 2020-04-05 23:06:45 | Amelia, Virginia, US |
586546 | 586546 | 2020-04-05 | US | Maryland | Allegany | 24001 | 6 | 0 | 0 | 6 | 39.62357628 | -78.69280486 | 2020-04-05 23:06:45 | Allegany, Maryland, US |
586541 | 586541 | 2020-04-05 | US | Mississippi | Alcorn | 28003 | 6 | 0 | 0 | 6 | 34.88084463 | -88.57996173 | 2020-04-05 23:06:45 | Alcorn, Mississippi, 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]);