daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,776 rows where "last_update" is on date 2020-06-14 sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, last_update
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-13 | US | Mississippi | Attala | 28007 | 328 | 23 | 0 | 305 | 33.08658803 | -89.57838564 | 2020-06-14 03:33:15 | Attala, Mississippi, US |
2020-06-13 | US | Missouri | Audrain | 29007 | 122 | 1 | 0 | 121 | 39.215877 | -91.84242683 | 2020-06-14 03:33:15 | Audrain, Missouri, US |
2020-06-13 | US | Iowa | Audubon | 19009 | 13 | 1 | 0 | 12 | 41.6844628 | -94.90581859 | 2020-06-14 03:33:15 | Audubon, Iowa, US |
2020-06-13 | US | Ohio | Auglaize | 39011 | 84 | 1 | 0 | 83 | 40.55998859 | -84.22421429999999 | 2020-06-14 03:33:15 | Auglaize, Ohio, US |
2020-06-13 | US | Virginia | Augusta | 51015 | 143 | 2 | 0 | 141 | 38.16404586 | -79.12461614 | 2020-06-14 03:33:15 | Augusta, Virginia, US |
2020-06-13 | US | South Dakota | Aurora | 46003 | 33 | 0 | 0 | 33 | 43.71757685 | -98.56050467 | 2020-06-14 03:33:15 | Aurora, South Dakota, US |
2020-06-13 | US | Texas | Austin | 48015 | 33 | 0 | 0 | 34 | 29.88548725 | -96.27736949 | 2020-06-14 03:33:15 | Austin, Texas, US |
2020-06-13 | US | Alabama | Autauga | 1001 | 361 | 6 | 0 | 355 | 32.53952745 | -86.64408227 | 2020-06-14 03:33:15 | Autauga, Alabama, US |
2020-06-13 | US | North Carolina | Avery | 37011 | 6 | 0 | 0 | 6 | 36.07569796 | -81.92308483 | 2020-06-14 03:33:15 | Avery, North Carolina, US |
2020-06-13 | US | Louisiana | Avoyelles | 22009 | 184 | 9 | 0 | 175 | 31.07796211 | -92.00079449 | 2020-06-14 03:33:15 | Avoyelles, Louisiana, US |
2020-06-13 | US | Colorado | Baca | 8009 | 12 | 0 | 0 | 12 | 37.31940883 | -102.5603223 | 2020-06-14 03:33:15 | Baca, Colorado, US |
2020-06-13 | US | Georgia | Bacon | 13005 | 174 | 3 | 0 | 171 | 31.55456473 | -82.45936528 | 2020-06-14 03:33:15 | Bacon, Georgia, US |
2020-06-13 | US | Texas | Bailey | 48017 | 28 | 0 | 0 | 34 | 34.06854817 | -102.8299707 | 2020-06-14 03:33:15 | Bailey, Texas, US |
2020-06-13 | US | Florida | Baker | 12003 | 30 | 4 | 0 | 26 | 30.33060121 | -82.28467476 | 2020-06-14 03:33:15 | Baker, Florida, US |
2020-06-13 | US | Georgia | Baker | 13007 | 37 | 3 | 0 | 34 | 31.32669878 | -84.44218806 | 2020-06-14 03:33:15 | Baker, Georgia, US |
2020-06-13 | US | Oregon | Baker | 41001 | 1 | 0 | 0 | 1 | 44.70915557 | -117.6749883 | 2020-06-14 03:33:15 | Baker, Oregon, US |
2020-06-13 | US | Alabama | Baldwin | 1003 | 367 | 9 | 0 | 358 | 30.72774991 | -87.72207058 | 2020-06-14 03:33:15 | Baldwin, Alabama, US |
2020-06-13 | US | Georgia | Baldwin | 13009 | 423 | 31 | 0 | 392 | 33.06882326 | -83.24701748 | 2020-06-14 03:33:15 | Baldwin, Georgia, US |
2020-06-13 | US | Kentucky | Ballard | 21007 | 14 | 0 | 0 | 14 | 37.05842757 | -88.99427697 | 2020-06-14 03:33:15 | Ballard, Kentucky, US |
2020-06-13 | US | Maryland | Baltimore | 24005 | 7107 | 416 | 0 | 6691 | 39.45784712 | -76.62911955 | 2020-06-14 03:33:15 | Baltimore, Maryland, US |
2020-06-13 | US | Maryland | Baltimore City | 24510 | 6633 | 297 | 0 | 6336 | 39.30211911 | -76.61151012 | 2020-06-14 03:33:15 | Baltimore City, Maryland, US |
2020-06-13 | US | South Carolina | Bamberg | 45009 | 41 | 0 | 0 | 41 | 33.21927586 | -81.05659969 | 2020-06-14 03:33:15 | Bamberg, South Carolina, US |
2020-06-13 | US | Texas | Bandera | 48019 | 9 | 0 | 0 | 7 | 29.74619598 | -99.24598147 | 2020-06-14 03:33:15 | Bandera, Texas, US |
2020-06-13 | US | Georgia | Banks | 13011 | 108 | 1 | 0 | 107 | 34.35607081 | -83.49644388 | 2020-06-14 03:33:15 | Banks, Georgia, US |
2020-06-13 | US | Nebraska | Banner | 31007 | 1 | 0 | 0 | 1 | 41.54634427 | -103.7114332 | 2020-06-14 03:33:15 | Banner, Nebraska, US |
2020-06-13 | US | Idaho | Bannock | 16005 | 59 | 1 | 0 | 58 | 42.67002716 | -112.2233311 | 2020-06-14 03:33:15 | Bannock, Idaho, US |
2020-06-13 | US | Michigan | Baraga | 26013 | 1 | 0 | 0 | 1 | 46.6720582 | -88.36363591 | 2020-06-14 03:33:15 | Baraga, Michigan, US |
2020-06-13 | US | Kansas | Barber | 20007 | 1 | 0 | 0 | 1 | 37.2288586 | -98.68460053 | 2020-06-14 03:33:15 | Barber, Kansas, US |
2020-06-13 | US | Alabama | Barbour | 1005 | 233 | 1 | 0 | 232 | 31.868263 | -85.3871286 | 2020-06-14 03:33:15 | Barbour, Alabama, US |
2020-06-13 | US | West Virginia | Barbour | 54001 | 10 | 1 | 0 | 9 | 39.1307219 | -80.00350858 | 2020-06-14 03:33:15 | Barbour, West Virginia, US |
2020-06-13 | US | North Dakota | Barnes | 38003 | 9 | 0 | 0 | 9 | 46.93579637 | -98.06605978 | 2020-06-14 03:33:15 | Barnes, North Dakota, US |
2020-06-13 | US | Massachusetts | Barnstable | 25001 | 1486 | 128 | 0 | 1358 | 41.72980578 | -70.28854339 | 2020-06-14 03:33:15 | Barnstable, Massachusetts, US |
2020-06-13 | US | South Carolina | Barnwell | 45011 | 54 | 1 | 0 | 53 | 33.26679302 | -81.43584352 | 2020-06-14 03:33:15 | Barnwell, South Carolina, US |
2020-06-13 | US | Kentucky | Barren | 21009 | 65 | 2 | 0 | 63 | 36.96469836 | -85.93338945 | 2020-06-14 03:33:15 | Barren, Kentucky, US |
2020-06-13 | US | Wisconsin | Barron | 55005 | 24 | 0 | 0 | 24 | 45.42372701 | -91.84833627 | 2020-06-14 03:33:15 | Barron, Wisconsin, US |
2020-06-13 | US | Georgia | Barrow | 13013 | 382 | 23 | 0 | 359 | 33.99148694 | -83.71436292 | 2020-06-14 03:33:15 | Barrow, Georgia, US |
2020-06-13 | US | Michigan | Barry | 26015 | 91 | 2 | 0 | 89 | 42.59513984 | -85.30834519 | 2020-06-14 03:33:15 | Barry, Michigan, US |
2020-06-13 | US | Missouri | Barry | 29009 | 10 | 0 | 0 | 10 | 36.70978521 | -93.82919888 | 2020-06-14 03:33:15 | Barry, Missouri, US |
2020-06-13 | US | Indiana | Bartholomew | 18005 | 549 | 45 | 0 | 504 | 39.20744865 | -85.89558181 | 2020-06-14 03:33:15 | Bartholomew, Indiana, US |
2020-06-13 | US | Kansas | Barton | 20009 | 48 | 2 | 0 | 46 | 38.47889676 | -98.75636726 | 2020-06-14 03:33:15 | Barton, Kansas, US |
2020-06-13 | US | Missouri | Barton | 29011 | 1 | 0 | 0 | 1 | 37.50207671 | -94.34757022 | 2020-06-14 03:33:15 | Barton, Missouri, US |
2020-06-13 | US | Georgia | Bartow | 13015 | 542 | 39 | 0 | 503 | 34.23732119 | -84.83887523 | 2020-06-14 03:33:15 | Bartow, Georgia, US |
2020-06-13 | US | Texas | Bastrop | 48021 | 229 | 4 | 0 | 289 | 30.10370699 | -97.31206354 | 2020-06-14 03:33:15 | Bastrop, Texas, US |
2020-06-13 | US | Missouri | Bates | 29013 | 12 | 1 | 0 | 11 | 38.25271289 | -94.34113157 | 2020-06-14 03:33:15 | Bates, Missouri, US |
2020-06-13 | US | Kentucky | Bath | 21011 | 10 | 1 | 0 | 9 | 38.14735938 | -83.74588932 | 2020-06-14 03:33:15 | Bath, Kentucky, US |
2020-06-13 | US | Virginia | Bath | 51017 | 0 | 0 | 0 | 0 | 38.05852573 | -79.73912095 | 2020-06-14 03:33:15 | Bath, Virginia, US |
2020-06-13 | US | Arkansas | Baxter | 5005 | 14 | 0 | 0 | 14 | 36.28784385 | -92.33782872 | 2020-06-14 03:33:15 | Baxter, Arkansas, US |
2020-06-13 | US | Florida | Bay | 12005 | 141 | 4 | 0 | 137 | 30.26548745 | -85.62122584 | 2020-06-14 03:33:15 | Bay, Florida, US |
2020-06-13 | US | Michigan | Bay | 26017 | 376 | 28 | 0 | 348 | 43.70639106 | -83.98731479 | 2020-06-14 03:33:15 | Bay, Michigan, US |
2020-06-13 | US | Wisconsin | Bayfield | 55007 | 3 | 1 | 0 | 2 | 46.52868768 | -91.19716729 | 2020-06-14 03:33:15 | Bayfield, Wisconsin, US |
2020-06-13 | US | Texas | Baylor | 48023 | 1 | 0 | 0 | 1 | 33.61640794 | -99.21352901 | 2020-06-14 03:33:15 | Baylor, Texas, US |
2020-06-13 | US | South Dakota | Beadle | 46005 | 434 | 6 | 0 | 428 | 44.41464384 | -98.27858469 | 2020-06-14 03:33:15 | Beadle, South Dakota, US |
2020-06-13 | US | Utah | Bear River | 955 | 2 | 0 | 953 | 41.52106798 | -113.0832816 | 2020-06-14 03:33:15 | Bear River, Utah, US | |
2020-06-13 | US | North Carolina | Beaufort | 37013 | 51 | 0 | 0 | 51 | 35.48531943 | -76.84325809 | 2020-06-14 03:33:15 | Beaufort, North Carolina, US |
2020-06-13 | US | South Carolina | Beaufort | 45013 | 566 | 14 | 0 | 552 | 32.39226291 | -80.72619758 | 2020-06-14 03:33:15 | Beaufort, South Carolina, US |
2020-06-13 | US | Louisiana | Beauregard | 22011 | 134 | 6 | 0 | 128 | 30.64836518 | -93.34173616 | 2020-06-14 03:33:15 | Beauregard, Louisiana, US |
2020-06-13 | US | Oklahoma | Beaver | 40007 | 30 | 0 | 0 | 30 | 36.7496847 | -100.4758872 | 2020-06-14 03:33:15 | Beaver, Oklahoma, US |
2020-06-13 | US | Pennsylvania | Beaver | 42007 | 607 | 75 | 0 | 532 | 40.6825484 | -80.34921611 | 2020-06-14 03:33:15 | Beaver, Pennsylvania, US |
2020-06-13 | US | Montana | Beaverhead | 30001 | 1 | 0 | 0 | 1 | 45.13434354 | -112.8984694 | 2020-06-14 03:33:15 | Beaverhead, Montana, US |
2020-06-13 | US | Minnesota | Becker | 27005 | 49 | 0 | 0 | 49 | 46.93479392 | -95.67158144 | 2020-06-14 03:33:15 | Becker, Minnesota, US |
2020-06-13 | US | Oklahoma | Beckham | 40009 | 7 | 0 | 0 | 7 | 35.26862449 | -99.68128023 | 2020-06-14 03:33:15 | Beckham, Oklahoma, US |
2020-06-13 | US | Pennsylvania | Bedford | 42009 | 48 | 2 | 0 | 46 | 40.00522157 | -78.48998442 | 2020-06-14 03:33:15 | Bedford, Pennsylvania, US |
2020-06-13 | US | Tennessee | Bedford | 47003 | 379 | 4 | 0 | 375 | 35.51123746 | -86.45549096 | 2020-06-14 03:33:15 | Bedford, Tennessee, US |
2020-06-13 | US | Virginia | Bedford | 51019 | 91 | 2 | 0 | 89 | 37.3080028 | -79.5281964 | 2020-06-14 03:33:15 | Bedford, Virginia, US |
2020-06-13 | US | Texas | Bee | 48025 | 16 | 0 | 0 | 31 | 28.41761668 | -97.74215593 | 2020-06-14 03:33:15 | Bee, Texas, US |
2020-06-13 | US | New Hampshire | Belknap | 33001 | 74 | 1 | 0 | 73 | 43.51637314 | -71.41684235 | 2020-06-14 03:33:15 | Belknap, New Hampshire, US |
2020-06-13 | US | Kentucky | Bell | 21013 | 4 | 0 | 0 | 4 | 36.73355174 | -83.67766671 | 2020-06-14 03:33:15 | Bell, Kentucky, US |
2020-06-13 | US | Texas | Bell | 48027 | 162 | 6 | 0 | 599 | 31.03736027 | -97.4785025 | 2020-06-14 03:33:15 | Bell, Texas, US |
2020-06-13 | US | Ohio | Belmont | 39013 | 466 | 20 | 0 | 446 | 40.01625942 | -80.9924051 | 2020-06-14 03:33:15 | Belmont, Ohio, US |
2020-06-13 | US | Minnesota | Beltrami | 27007 | 21 | 0 | 0 | 21 | 47.97373527 | -94.93732139 | 2020-06-14 03:33:15 | Beltrami, Minnesota, US |
2020-06-13 | US | Georgia | Ben Hill | 13017 | 102 | 1 | 0 | 101 | 31.76095874 | -83.22145359 | 2020-06-14 03:33:15 | Ben Hill, Georgia, US |
2020-06-13 | US | Idaho | Benewah | 16009 | 19 | 0 | 0 | 19 | 47.21754179 | -116.6586851 | 2020-06-14 03:33:15 | Benewah, Idaho, US |
2020-06-13 | US | Vermont | Bennington | 50003 | 67 | 1 | 0 | 66 | 43.03519828 | -73.09048868 | 2020-06-14 03:33:15 | Bennington, Vermont, US |
2020-06-13 | US | North Dakota | Benson | 38005 | 3 | 0 | 0 | 3 | 48.0683985 | -99.35916363 | 2020-06-14 03:33:15 | Benson, North Dakota, US |
2020-06-13 | US | Colorado | Bent | 8011 | 3 | 0 | 0 | 3 | 37.95474293 | -103.0720195 | 2020-06-14 03:33:15 | Bent, Colorado, US |
2020-06-13 | US | Arkansas | Benton | 5007 | 1362 | 7 | 0 | 1355 | 36.33644656 | -94.25680817 | 2020-06-14 03:33:15 | Benton, Arkansas, US |
2020-06-13 | US | Indiana | Benton | 18007 | 37 | 0 | 0 | 37 | 40.60626947 | -87.31093999 | 2020-06-14 03:33:15 | Benton, Indiana, US |
2020-06-13 | US | Iowa | Benton | 19011 | 46 | 1 | 0 | 45 | 42.08011739 | -92.06463573 | 2020-06-14 03:33:15 | Benton, Iowa, US |
2020-06-13 | US | Minnesota | Benton | 27009 | 190 | 3 | 0 | 187 | 45.69804958 | -93.99514135 | 2020-06-14 03:33:15 | Benton, Minnesota, US |
2020-06-13 | US | Mississippi | Benton | 28009 | 17 | 0 | 0 | 17 | 34.81681228 | -89.18945516 | 2020-06-14 03:33:15 | Benton, Mississippi, US |
2020-06-13 | US | Missouri | Benton | 29015 | 14 | 0 | 0 | 14 | 38.29503305 | -93.28756116 | 2020-06-14 03:33:15 | Benton, Missouri, US |
2020-06-13 | US | Oregon | Benton | 41003 | 63 | 5 | 0 | 58 | 44.49167306 | -123.4316987 | 2020-06-14 03:33:15 | Benton, Oregon, US |
2020-06-13 | US | Tennessee | Benton | 47005 | 8 | 1 | 0 | 7 | 36.07110411 | -88.06849355 | 2020-06-14 03:33:15 | Benton, Tennessee, US |
2020-06-13 | US | Washington | Benton | 53005 | 1128 | 74 | 0 | 1054 | 46.23946995 | -119.5120834 | 2020-06-14 03:33:15 | Benton, Washington, US |
2020-06-13 | US | Michigan | Benzie | 26019 | 5 | 0 | 0 | 5 | 44.63899297 | -86.01608482 | 2020-06-14 03:33:15 | Benzie, Michigan, US |
2020-06-13 | US | New Jersey | Bergen | 34003 | 18903 | 1664 | 0 | 17239 | 40.96010917 | -74.07164325 | 2020-06-14 03:33:15 | Bergen, New Jersey, US |
2020-06-13 | US | South Carolina | Berkeley | 45015 | 364 | 19 | 0 | 345 | 33.20222596 | -79.94654523 | 2020-06-14 03:33:15 | Berkeley, South Carolina, US |
2020-06-13 | US | West Virginia | Berkeley | 54003 | 386 | 9 | 0 | 377 | 39.46704621 | -78.02414609 | 2020-06-14 03:33:15 | Berkeley, West Virginia, US |
2020-06-13 | US | Pennsylvania | Berks | 42011 | 4288 | 338 | 0 | 3950 | 40.41570541 | -75.92457766 | 2020-06-14 03:33:15 | Berks, Pennsylvania, US |
2020-06-13 | US | Massachusetts | Berkshire | 25003 | 580 | 42 | 0 | 538 | 42.37428441 | -73.20524838 | 2020-06-14 03:33:15 | Berkshire, Massachusetts, US |
2020-06-13 | US | New Mexico | Bernalillo | 35001 | 1682 | 78 | 0 | 1604 | 35.05163625 | -106.6703554 | 2020-06-14 03:33:15 | Bernalillo, New Mexico, US |
2020-06-13 | US | Georgia | Berrien | 13019 | 66 | 0 | 0 | 66 | 31.27590016 | -83.22529920000002 | 2020-06-14 03:33:15 | Berrien, Georgia, US |
2020-06-13 | US | Michigan | Berrien | 26021 | 822 | 57 | 0 | 765 | 41.95447397 | -86.41313079999998 | 2020-06-14 03:33:15 | Berrien, Michigan, US |
2020-06-13 | US | North Carolina | Bertie | 37015 | 135 | 4 | 0 | 131 | 36.0688473 | -76.96545943 | 2020-06-14 03:33:15 | Bertie, North Carolina, US |
2020-06-13 | US | Alaska | Bethel | 2050 | 4 | 0 | 0 | 4 | 60.90980451 | -159.8561831 | 2020-06-14 03:33:15 | Bethel, Alaska, US |
2020-06-13 | US | Texas | Bexar | 48029 | 4365 | 84 | 0 | 3928 | 29.44928723 | -98.52019748 | 2020-06-14 03:33:15 | Bexar, Texas, US |
2020-06-13 | US | Alabama | Bibb | 1007 | 106 | 1 | 0 | 105 | 32.99642064 | -87.12511459999996 | 2020-06-14 03:33:15 | Bibb, Alabama, US |
2020-06-13 | US | Georgia | Bibb | 13021 | 533 | 35 | 0 | 498 | 32.80904227 | -83.70489165 | 2020-06-14 03:33:15 | Bibb, Georgia, US |
2020-06-13 | US | Louisiana | Bienville | 22013 | 172 | 24 | 0 | 148 | 32.34569994 | -93.05398492 | 2020-06-14 03:33:15 | Bienville, Louisiana, US |
2020-06-13 | US | Montana | Big Horn | 30003 | 44 | 1 | 0 | 43 | 45.42335905 | -107.492347 | 2020-06-14 03:33:15 | Big Horn, Montana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;