daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,685 rows where "day" is on date 2020-06-03 sorted by day
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-06-03 | US | Missouri | Audrain | 29007 | 97 | 0 | 0 | 97 | 39.215877 | -91.84242683 | 2020-06-04 02:33:14 | Audrain, Missouri, US |
2020-06-03 | US | Iowa | Audubon | 19009 | 13 | 1 | 0 | 12 | 41.6844628 | -94.90581859 | 2020-06-04 02:33:14 | Audubon, Iowa, US |
2020-06-03 | US | Ohio | Auglaize | 39011 | 76 | 1 | 0 | 75 | 40.55998859 | -84.22421429999999 | 2020-06-04 02:33:14 | Auglaize, Ohio, US |
2020-06-03 | US | Virginia | Augusta | 51015 | 115 | 2 | 0 | 113 | 38.16404586 | -79.12461614 | 2020-06-04 02:33:14 | Augusta, Virginia, US |
2020-06-03 | US | South Dakota | Aurora | 46003 | 27 | 0 | 0 | 27 | 43.71757685 | -98.56050467 | 2020-06-04 02:33:14 | Aurora, South Dakota, US |
2020-06-03 | US | Texas | Austin | 48015 | 20 | 0 | 0 | 27 | 29.88548725 | -96.27736949 | 2020-06-04 02:33:14 | Austin, Texas, US |
2020-06-03 | US | Alabama | Autauga | 1001 | 241 | 5 | 0 | 236 | 32.53952745 | -86.64408227 | 2020-06-04 02:33:14 | Autauga, Alabama, US |
2020-06-03 | US | North Carolina | Avery | 37011 | 2 | 0 | 0 | 2 | 36.07569796 | -81.92308483 | 2020-06-04 02:33:14 | Avery, North Carolina, US |
2020-06-03 | US | Louisiana | Avoyelles | 22009 | 141 | 9 | 0 | 132 | 31.07796211 | -92.00079449 | 2020-06-04 02:33:14 | Avoyelles, Louisiana, US |
2020-06-03 | US | Colorado | Baca | 8009 | 12 | 0 | 0 | 12 | 37.31940883 | -102.5603223 | 2020-06-04 02:33:14 | Baca, Colorado, US |
2020-06-03 | US | Georgia | Bacon | 13005 | 136 | 3 | 0 | 133 | 31.55456473 | -82.45936528 | 2020-06-04 02:33:14 | Bacon, Georgia, US |
2020-06-03 | US | Texas | Bailey | 48017 | 20 | 0 | 0 | 19 | 34.06854817 | -102.8299707 | 2020-06-04 02:33:14 | Bailey, Texas, US |
2020-06-03 | US | Florida | Baker | 12003 | 29 | 4 | 0 | 25 | 30.33060121 | -82.28467476 | 2020-06-04 02:33:14 | Baker, Florida, US |
2020-06-03 | US | Georgia | Baker | 13007 | 34 | 2 | 0 | 32 | 31.32669878 | -84.44218806 | 2020-06-04 02:33:14 | Baker, Georgia, US |
2020-06-03 | US | Oregon | Baker | 41001 | 1 | 0 | 0 | 1 | 44.70915557 | -117.6749883 | 2020-06-04 02:33:14 | Baker, Oregon, US |
2020-06-03 | US | Alabama | Baldwin | 1003 | 302 | 9 | 0 | 293 | 30.72774991 | -87.72207058 | 2020-06-04 02:33:14 | Baldwin, Alabama, US |
2020-06-03 | US | Georgia | Baldwin | 13009 | 352 | 27 | 0 | 325 | 33.06882326 | -83.24701748 | 2020-06-04 02:33:14 | Baldwin, Georgia, US |
2020-06-03 | US | Kentucky | Ballard | 21007 | 12 | 0 | 0 | 12 | 37.05842757 | -88.99427697 | 2020-06-04 02:33:14 | Ballard, Kentucky, US |
2020-06-03 | US | Maryland | Baltimore | 24005 | 6457 | 366 | 0 | 6091 | 39.45784712 | -76.62911955 | 2020-06-04 02:33:14 | Baltimore, Maryland, US |
2020-06-03 | US | Maryland | Baltimore City | 24510 | 5801 | 266 | 0 | 5535 | 39.30211911 | -76.61151012 | 2020-06-04 02:33:14 | Baltimore City, Maryland, US |
2020-06-03 | US | South Carolina | Bamberg | 45009 | 23 | 0 | 0 | 23 | 33.21927586 | -81.05659969 | 2020-06-04 02:33:14 | Bamberg, South Carolina, US |
2020-06-03 | US | Texas | Bandera | 48019 | 7 | 0 | 0 | 6 | 29.74619598 | -99.24598147 | 2020-06-04 02:33:14 | Bandera, Texas, US |
2020-06-03 | US | Georgia | Banks | 13011 | 86 | 1 | 0 | 85 | 34.35607081 | -83.49644388 | 2020-06-04 02:33:14 | Banks, Georgia, US |
2020-06-03 | US | Idaho | Bannock | 16005 | 34 | 1 | 0 | 33 | 42.67002716 | -112.2233311 | 2020-06-04 02:33:14 | Bannock, Idaho, US |
2020-06-03 | US | Michigan | Baraga | 26013 | 1 | 0 | 0 | 1 | 46.6720582 | -88.36363591 | 2020-06-04 02:33:14 | Baraga, Michigan, US |
2020-06-03 | US | Kansas | Barber | 20007 | 1 | 0 | 0 | 1 | 37.2288586 | -98.68460053 | 2020-06-04 02:33:14 | Barber, Kansas, US |
2020-06-03 | US | Alabama | Barbour | 1005 | 181 | 1 | 0 | 180 | 31.868263 | -85.3871286 | 2020-06-04 02:33:14 | Barbour, Alabama, US |
2020-06-03 | US | West Virginia | Barbour | 54001 | 8 | 1 | 0 | 7 | 39.1307219 | -80.00350858 | 2020-06-04 02:33:14 | Barbour, West Virginia, US |
2020-06-03 | US | North Dakota | Barnes | 38003 | 6 | 0 | 0 | 5 | 46.93579637 | -98.06605978 | 2020-06-04 02:33:14 | Barnes, North Dakota, US |
2020-06-03 | US | Massachusetts | Barnstable | 25001 | 1435 | 121 | 0 | 1314 | 41.72980578 | -70.28854339 | 2020-06-04 02:33:14 | Barnstable, Massachusetts, US |
2020-06-03 | US | South Carolina | Barnwell | 45011 | 48 | 1 | 0 | 47 | 33.26679302 | -81.43584352 | 2020-06-04 02:33:14 | Barnwell, South Carolina, US |
2020-06-03 | US | Kentucky | Barren | 21009 | 49 | 1 | 0 | 48 | 36.96469836 | -85.93338945 | 2020-06-04 02:33:14 | Barren, Kentucky, US |
2020-06-03 | US | Wisconsin | Barron | 55005 | 21 | 0 | 0 | 21 | 45.42372701 | -91.84833627 | 2020-06-04 02:33:14 | Barron, Wisconsin, US |
2020-06-03 | US | Georgia | Barrow | 13013 | 333 | 18 | 0 | 315 | 33.99148694 | -83.71436292 | 2020-06-04 02:33:14 | Barrow, Georgia, US |
2020-06-03 | US | Michigan | Barry | 26015 | 64 | 2 | 0 | 62 | 42.59513984 | -85.30834519 | 2020-06-04 02:33:14 | Barry, Michigan, US |
2020-06-03 | US | Missouri | Barry | 29009 | 9 | 0 | 0 | 9 | 36.70978521 | -93.82919888 | 2020-06-04 02:33:14 | Barry, Missouri, US |
2020-06-03 | US | Indiana | Bartholomew | 18005 | 522 | 42 | 0 | 480 | 39.20744865 | -85.89558181 | 2020-06-04 02:33:14 | Bartholomew, Indiana, US |
2020-06-03 | US | Kansas | Barton | 20009 | 44 | 1 | 0 | 43 | 38.47889676 | -98.75636726 | 2020-06-04 02:33:14 | Barton, Kansas, US |
2020-06-03 | US | Georgia | Bartow | 13015 | 496 | 39 | 0 | 457 | 34.23732119 | -84.83887523 | 2020-06-04 02:33:14 | Bartow, Georgia, US |
2020-06-03 | US | Texas | Bastrop | 48021 | 160 | 3 | 0 | 228 | 30.10370699 | -97.31206354 | 2020-06-04 02:33:14 | Bastrop, Texas, US |
2020-06-03 | US | Missouri | Bates | 29013 | 10 | 1 | 0 | 9 | 38.25271289 | -94.34113157 | 2020-06-04 02:33:14 | Bates, Missouri, US |
2020-06-03 | US | Kentucky | Bath | 21011 | 9 | 1 | 0 | 8 | 38.14735938 | -83.74588932 | 2020-06-04 02:33:14 | Bath, Kentucky, US |
2020-06-03 | US | Virginia | Bath | 51017 | 0 | 0 | 0 | 0 | 38.05852573 | -79.73912095 | 2020-06-04 02:33:14 | Bath, Virginia, US |
2020-06-03 | US | Arkansas | Baxter | 5005 | 12 | 0 | 0 | 12 | 36.28784385 | -92.33782872 | 2020-06-04 02:33:14 | Baxter, Arkansas, US |
2020-06-03 | US | Florida | Bay | 12005 | 105 | 3 | 0 | 102 | 30.26548745 | -85.62122584 | 2020-06-04 02:33:14 | Bay, Florida, US |
2020-06-03 | US | Michigan | Bay | 26017 | 322 | 24 | 0 | 298 | 43.70639106 | -83.98731479 | 2020-06-04 02:33:14 | Bay, Michigan, US |
2020-06-03 | US | Wisconsin | Bayfield | 55007 | 3 | 1 | 0 | 2 | 46.52868768 | -91.19716729 | 2020-06-04 02:33:14 | Bayfield, Wisconsin, US |
2020-06-03 | US | South Dakota | Beadle | 46005 | 308 | 5 | 0 | 303 | 44.41464384 | -98.27858469 | 2020-06-04 02:33:14 | Beadle, South Dakota, US |
2020-06-03 | US | Utah | Bear River | 305 | 2 | 0 | 303 | 41.52106798 | -113.0832816 | 2020-06-04 02:33:14 | Bear River, Utah, US | |
2020-06-03 | US | North Carolina | Beaufort | 37013 | 36 | 0 | 0 | 36 | 35.48531943 | -76.84325809 | 2020-06-04 02:33:14 | Beaufort, North Carolina, US |
2020-06-03 | US | South Carolina | Beaufort | 45013 | 398 | 14 | 0 | 384 | 32.39226291 | -80.72619758 | 2020-06-04 02:33:14 | Beaufort, South Carolina, US |
2020-06-03 | US | Louisiana | Beauregard | 22011 | 81 | 4 | 0 | 77 | 30.64836518 | -93.34173616 | 2020-06-04 02:33:14 | Beauregard, Louisiana, US |
2020-06-03 | US | Oklahoma | Beaver | 40007 | 24 | 0 | 0 | 24 | 36.7496847 | -100.4758872 | 2020-06-04 02:33:14 | Beaver, Oklahoma, US |
2020-06-03 | US | Pennsylvania | Beaver | 42007 | 590 | 74 | 0 | 516 | 40.6825484 | -80.34921611 | 2020-06-04 02:33:14 | Beaver, Pennsylvania, US |
2020-06-03 | US | Montana | Beaverhead | 30001 | 1 | 0 | 0 | 1 | 45.13434354 | -112.8984694 | 2020-06-04 02:33:14 | Beaverhead, Montana, US |
2020-06-03 | US | Minnesota | Becker | 27005 | 41 | 0 | 0 | 41 | 46.93479392 | -95.67158144 | 2020-06-04 02:33:14 | Becker, Minnesota, US |
2020-06-03 | US | Oklahoma | Beckham | 40009 | 7 | 0 | 0 | 7 | 35.26862449 | -99.68128023 | 2020-06-04 02:33:14 | Beckham, Oklahoma, US |
2020-06-03 | US | Pennsylvania | Bedford | 42009 | 42 | 2 | 0 | 40 | 40.00522157 | -78.48998442 | 2020-06-04 02:33:14 | Bedford, Pennsylvania, US |
2020-06-03 | US | Tennessee | Bedford | 47003 | 299 | 4 | 0 | 291 | 35.51123746 | -86.45549096 | 2020-06-04 02:33:14 | Bedford, Tennessee, US |
2020-06-03 | US | Virginia | Bedford | 51019 | 62 | 2 | 0 | 60 | 37.3080028 | -79.5281964 | 2020-06-04 02:33:14 | Bedford, Virginia, US |
2020-06-03 | US | Texas | Bee | 48025 | 8 | 0 | 0 | 11 | 28.41761668 | -97.74215593 | 2020-06-04 02:33:14 | Bee, Texas, US |
2020-06-03 | US | New Hampshire | Belknap | 33001 | 63 | 0 | 0 | 63 | 43.51637314 | -71.41684235 | 2020-06-04 02:33:14 | Belknap, New Hampshire, US |
2020-06-03 | US | Kentucky | Bell | 21013 | 1 | 0 | 0 | 1 | 36.73355174 | -83.67766671 | 2020-06-04 02:33:14 | Bell, Kentucky, US |
2020-06-03 | US | Texas | Bell | 48027 | 72 | 4 | 0 | 407 | 31.03736027 | -97.4785025 | 2020-06-04 02:33:14 | Bell, Texas, US |
2020-06-03 | US | Ohio | Belmont | 39013 | 439 | 19 | 0 | 420 | 40.01625942 | -80.9924051 | 2020-06-04 02:33:14 | Belmont, Ohio, US |
2020-06-03 | US | Minnesota | Beltrami | 27007 | 18 | 0 | 0 | 18 | 47.97373527 | -94.93732139 | 2020-06-04 02:33:14 | Beltrami, Minnesota, US |
2020-06-03 | US | Georgia | Ben Hill | 13017 | 81 | 1 | 0 | 80 | 31.76095874 | -83.22145359 | 2020-06-04 02:33:14 | Ben Hill, Georgia, US |
2020-06-03 | US | Idaho | Benewah | 16009 | 12 | 0 | 0 | 12 | 47.21754179 | -116.6586851 | 2020-06-04 02:33:14 | Benewah, Idaho, US |
2020-06-03 | US | Vermont | Bennington | 50003 | 64 | 1 | 0 | 63 | 43.03519828 | -73.09048868 | 2020-06-04 02:33:14 | Bennington, Vermont, US |
2020-06-03 | US | North Dakota | Benson | 38005 | 1 | 0 | 0 | 1 | 48.0683985 | -99.35916363 | 2020-06-04 02:33:14 | Benson, North Dakota, US |
2020-06-03 | US | Colorado | Bent | 8011 | 3 | 0 | 0 | 2 | 37.95474293 | -103.0720195 | 2020-06-04 02:33:14 | Bent, Colorado, US |
2020-06-03 | US | Arkansas | Benton | 5007 | 700 | 3 | 0 | 697 | 36.33644656 | -94.25680817 | 2020-06-04 02:33:14 | Benton, Arkansas, US |
2020-06-03 | US | Indiana | Benton | 18007 | 32 | 0 | 0 | 32 | 40.60626947 | -87.31093999 | 2020-06-04 02:33:14 | Benton, Indiana, US |
2020-06-03 | US | Iowa | Benton | 19011 | 44 | 1 | 0 | 43 | 42.08011739 | -92.06463573 | 2020-06-04 02:33:14 | Benton, Iowa, US |
2020-06-03 | US | Minnesota | Benton | 27009 | 181 | 3 | 0 | 178 | 45.69804958 | -93.99514135 | 2020-06-04 02:33:14 | Benton, Minnesota, US |
2020-06-03 | US | Mississippi | Benton | 28009 | 14 | 0 | 0 | 14 | 34.81681228 | -89.18945516 | 2020-06-04 02:33:14 | Benton, Mississippi, US |
2020-06-03 | US | Missouri | Benton | 29015 | 11 | 0 | 0 | 11 | 38.29503305 | -93.28756116 | 2020-06-04 02:33:14 | Benton, Missouri, US |
2020-06-03 | US | Oregon | Benton | 41003 | 57 | 5 | 0 | 52 | 44.49167306 | -123.4316987 | 2020-06-04 02:33:14 | Benton, Oregon, US |
2020-06-03 | US | Tennessee | Benton | 47005 | 7 | 1 | 0 | 6 | 36.07110411 | -88.06849355 | 2020-06-04 02:33:14 | Benton, Tennessee, US |
2020-06-03 | US | Washington | Benton | 53005 | 855 | 68 | 0 | 787 | 46.23946995 | -119.5120834 | 2020-06-04 02:33:14 | Benton, Washington, US |
2020-06-03 | US | Michigan | Benzie | 26019 | 4 | 0 | 0 | 4 | 44.63899297 | -86.01608482 | 2020-06-04 02:33:14 | Benzie, Michigan, US |
2020-06-03 | US | New Jersey | Bergen | 34003 | 18451 | 1595 | 0 | 16856 | 40.96010917 | -74.07164325 | 2020-06-04 02:33:14 | Bergen, New Jersey, US |
2020-06-03 | US | South Carolina | Berkeley | 45015 | 242 | 16 | 0 | 226 | 33.20222596 | -79.94654523 | 2020-06-04 02:33:14 | Berkeley, South Carolina, US |
2020-06-03 | US | West Virginia | Berkeley | 54003 | 326 | 7 | 0 | 319 | 39.46704621 | -78.02414609 | 2020-06-04 02:33:14 | Berkeley, West Virginia, US |
2020-06-03 | US | Pennsylvania | Berks | 42011 | 4120 | 322 | 0 | 3798 | 40.41570541 | -75.92457766 | 2020-06-04 02:33:14 | Berks, Pennsylvania, US |
2020-06-03 | US | Massachusetts | Berkshire | 25003 | 566 | 40 | 0 | 526 | 42.37428441 | -73.20524838 | 2020-06-04 02:33:14 | Berkshire, Massachusetts, US |
2020-06-03 | US | New Mexico | Bernalillo | 35001 | 1524 | 72 | 0 | 1452 | 35.05163625 | -106.6703554 | 2020-06-04 02:33:14 | Bernalillo, New Mexico, US |
2020-06-03 | US | Georgia | Berrien | 13019 | 48 | 0 | 0 | 48 | 31.27590016 | -83.22529920000002 | 2020-06-04 02:33:14 | Berrien, Georgia, US |
2020-06-03 | US | Michigan | Berrien | 26021 | 643 | 53 | 0 | 590 | 41.95447397 | -86.41313079999998 | 2020-06-04 02:33:14 | Berrien, Michigan, US |
2020-06-03 | US | North Carolina | Bertie | 37015 | 126 | 4 | 0 | 122 | 36.0688473 | -76.96545943 | 2020-06-04 02:33:14 | Bertie, North Carolina, US |
2020-06-03 | US | Alaska | Bethel | 2050 | 3 | 0 | 0 | 3 | 60.90980451 | -159.8561831 | 2020-06-04 02:33:14 | Bethel, Alaska, US |
2020-06-03 | US | Texas | Bexar | 48029 | 3000 | 75 | 0 | 2807 | 29.44928723 | -98.52019748 | 2020-06-04 02:33:14 | Bexar, Texas, US |
2020-06-03 | US | Alabama | Bibb | 1007 | 78 | 1 | 0 | 77 | 32.99642064 | -87.12511459999996 | 2020-06-04 02:33:14 | Bibb, Alabama, US |
2020-06-03 | US | Georgia | Bibb | 13021 | 481 | 29 | 0 | 452 | 32.80904227 | -83.70489165 | 2020-06-04 02:33:14 | Bibb, Georgia, US |
2020-06-03 | US | Louisiana | Bienville | 22013 | 149 | 23 | 0 | 126 | 32.34569994 | -93.05398492 | 2020-06-04 02:33:14 | Bienville, Louisiana, US |
2020-06-03 | US | Montana | Big Horn | 30003 | 31 | 0 | 0 | 31 | 45.42335905 | -107.492347 | 2020-06-04 02:33:14 | Big Horn, Montana, US |
2020-06-03 | US | Wyoming | Big Horn | 56003 | 6 | 0 | 0 | 6 | 44.52405055 | -107.9960365 | 2020-06-04 02:33:14 | Big Horn, Wyoming, US |
2020-06-03 | US | Minnesota | Big Stone | 27011 | 8 | 0 | 0 | 8 | 45.42712824 | -96.41403739 | 2020-06-04 02:33:14 | Big Stone, Minnesota, US |
2020-06-03 | US | Idaho | Bingham | 16011 | 8 | 0 | 0 | 8 | 43.21672879999999 | -112.3978437 | 2020-06-04 02:33:14 | Bingham, Idaho, US |
2020-06-03 | US | Iowa | Black Hawk | 19013 | 1759 | 46 | 0 | 1713 | 42.4704581 | -92.30524729 | 2020-06-04 02:33:14 | Black Hawk, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;