daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

62,544 rows sorted by day descending

View and edit SQL

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
2020-04-08 US South Carolina Abbeville 45001 5 0 0 0 34.22333378 -82.46170658 2020-04-08 22:51:58 Abbeville, South Carolina, US
2020-04-08 US Louisiana Acadia 22001 86 2 0 0 30.295064899999996 -92.41419698 2020-04-08 22:51:58 Acadia, Louisiana, US
2020-04-08 US Virginia Accomack 51001 11 0 0 0 37.76707161 -75.63234615 2020-04-08 22:51:58 Accomack, Virginia, US
2020-04-08 US Idaho Ada 16001 438 3 0 0 43.4526575 -116.24155159999998 2020-04-08 22:51:58 Ada, Idaho, US
2020-04-08 US Iowa Adair 19001 1 0 0 0 41.33075609 -94.47105874 2020-04-08 22:51:58 Adair, Iowa, US
2020-04-08 US Kentucky Adair 21001 3 0 0 0 37.10459774 -85.28129668 2020-04-08 22:51:58 Adair, Kentucky, US
2020-04-08 US Missouri Adair 29001 11 0 0 0 40.19058551 -92.60078167 2020-04-08 22:51:58 Adair, Missouri, US
2020-04-08 US Oklahoma Adair 40001 25 2 0 0 35.88494195 -94.65859267 2020-04-08 22:51:58 Adair, Oklahoma, US
2020-04-08 US Colorado Adams 08001 417 14 0 0 39.87432092 -104.3362578 2020-04-08 22:51:58 Adams, Colorado, US
2020-04-08 US Idaho Adams 16003 1 0 0 0 44.89333571 -116.4545247 2020-04-08 22:51:58 Adams, Idaho, US
2020-04-08 US Illinois Adams 17001 1 0 0 0 39.98815591 -91.18786813 2020-04-08 22:51:58 Adams, Illinois, US
2020-04-08 US Indiana Adams 18001 2 0 0 0 40.7457653 -84.93671406 2020-04-08 22:51:58 Adams, Indiana, US
2020-04-08 US Mississippi Adams 28001 25 0 0 0 31.47669768 -91.35326037 2020-04-08 22:51:58 Adams, Mississippi, US
2020-04-08 US Nebraska Adams 31001 27 0 0 0 40.52449420000001 -98.50117804 2020-04-08 22:51:58 Adams, Nebraska, US
2020-04-08 US Ohio Adams 39001 2 0 0 0 38.84541072 -83.4718964 2020-04-08 22:51:58 Adams,Ohio,US
2020-04-08 US Pennsylvania Adams 42001 33 0 0 0 39.87140411 -77.21610347 2020-04-08 22:51:58 Adams, Pennsylvania, US
2020-04-08 US Washington Adams 53001 29 0 0 0 46.98299757 -118.56017340000001 2020-04-08 22:51:58 Adams, Washington, US
2020-04-08 US Wisconsin Adams 55001 2 0 0 0 43.96974651 -89.76782777 2020-04-08 22:51:58 Adams, Wisconsin, US
2020-04-08 US Vermont Addison 50001 47 0 0 0 44.03217337 -73.14130877 2020-04-08 22:51:58 Addison, Vermont, US
2020-04-08 US South Carolina Aiken 45003 28 1 0 0 33.54338026 -81.63645384 2020-04-08 22:51:58 Aiken, South Carolina, US
2020-04-08 US Florida Alachua 12001 144 0 0 0 29.67866525 -82.35928158 2020-04-08 22:51:58 Alachua, Florida, US
2020-04-08 US North Carolina Alamance 37001 30 0 0 0 36.0434701 -79.39976137 2020-04-08 22:51:58 Alamance, North Carolina, US
2020-04-08 US California Alameda 06001 674 16 0 0 37.64629437 -121.8929271 2020-04-08 22:51:58 Alameda, California, US
2020-04-08 US Colorado Alamosa 08003 5 0 0 0 37.57250606 -105.7885451 2020-04-08 22:51:58 Alamosa, Colorado, US
2020-04-08 US New York Albany 36001 342 9 0 0 42.60060306 -73.97723916 2020-04-08 22:51:58 Albany, New York, US
2020-04-08 US Wyoming Albany 56001 4 0 0 0 41.65498705 -105.72354150000001 2020-04-08 22:51:58 Albany, Wyoming, US
2020-04-08 US Virginia Albemarle 51003 41 0 0 0 38.02080697 -78.55481085 2020-04-08 22:51:58 Albemarle, Virginia, US
2020-04-08 US Mississippi Alcorn 28003 6 0 0 0 34.88084463 -88.57996173 2020-04-08 22:51:58 Alcorn, Mississippi, US
2020-04-08 US North Carolina Alexander 37003 2 0 0 0 35.922379600000006 -81.17751948 2020-04-08 22:51:58 Alexander, North Carolina, US
2020-04-08 US Virginia Alexandria 51510 143 1 0 0 38.814003 -77.08183073 2020-04-08 22:51:58 Alexandria, Virginia, US
2020-04-08 US Iowa Allamakee 19005 19 1 0 0 43.28383218 -91.37860922 2020-04-08 22:51:58 Allamakee, Iowa, US
2020-04-08 US Michigan Allegan 26005 18 0 0 0 42.59147037 -85.89102866 2020-04-08 22:51:58 Allegan, Michigan, US
2020-04-08 US Maryland Allegany 24001 6 0 0 0 39.62357628 -78.69280486 2020-04-08 22:51:58 Allegany, Maryland, US
2020-04-08 US New York Allegany 36003 21 1 0 0 42.25748406 -78.02750466 2020-04-08 22:51:58 Allegany, New York, US
2020-04-08 US North Carolina Alleghany 37005 2 0 0 0 36.49360862 -81.12857041 2020-04-08 22:51:58 Alleghany, North Carolina, US
2020-04-08 US Virginia Alleghany 51005 2 0 0 0 37.78636074 -80.00222498 2020-04-08 22:51:58 Alleghany, Virginia, US
2020-04-08 US Pennsylvania Allegheny 42003 720 10 0 0 40.46809875 -79.98167747 2020-04-08 22:51:58 Allegheny, Pennsylvania, US
2020-04-08 US Indiana Allen 18003 95 7 0 0 41.09194313 -85.06800636 2020-04-08 22:51:58 Allen, Indiana, US
2020-04-08 US Kentucky Allen 21003 2 0 0 0 36.75197631 -86.19457544 2020-04-08 22:51:58 Allen, Kentucky, US
2020-04-08 US Louisiana Allen 22003 65 5 0 0 30.65385745 -92.82442028 2020-04-08 22:51:58 Allen, Louisiana, US
2020-04-08 US Ohio Allen 39003 23 1 0 0 40.77285242 -84.10802343 2020-04-08 22:51:58 Allen, Ohio, US
2020-04-08 US South Carolina Allendale 45005 2 0 0 0 32.98837386 -81.35321066 2020-04-08 22:51:58 Allendale, South Carolina, US
2020-04-08 US California Alpine 06003 1 0 0 0 38.59678594 -119.82235940000001 2020-04-08 22:51:58 Alpine, California, US
2020-04-08 US California Amador 06005 3 0 0 0 38.44583082 -120.65696000000001 2020-04-08 22:51:58 Amador, California, US
2020-04-08 US Virginia Amelia 51007 8 0 0 0 37.34081025 -77.98584649 2020-04-08 22:51:58 Amelia, Virginia, US
2020-04-08 US Virginia Amherst 51009 8 0 0 0 37.60308293 -79.14548696 2020-04-08 22:51:58 Amherst, Virginia, US
2020-04-08 US Mississippi Amite 28005 7 1 0 0 31.17467303 -90.80501621 2020-04-08 22:51:58 Amite, Mississippi, US
2020-04-08 US Alaska Anchorage 02020 103 4 0 0 61.14998174 -149.14269860000005 2020-04-08 22:51:58 Anchorage, Alaska, US
2020-04-08 US Kansas Anderson 20003 0 0 0 0 38.21413251 -95.29272815 2020-04-08 22:51:58 Anderson, Kansas, US
2020-04-08 US Kentucky Anderson 21005 3 1 0 0 38.00671029 -84.99171713 2020-04-08 22:51:58 Anderson, Kentucky, US
2020-04-08 US South Carolina Anderson 45007 75 4 0 0 34.51828081 -82.63959517 2020-04-08 22:51:58 Anderson, South Carolina, US
2020-04-08 US Tennessee Anderson 47001 11 1 0 0 36.12684348 -84.19965764 2020-04-08 22:51:58 Anderson, Tennessee, US
2020-04-08 US Texas Anderson 48001 2 0 0 0 31.81534745 -95.65354823 2020-04-08 22:51:58 Anderson, Texas, US
2020-04-08 US Texas Andrews 48003 10 0 0 0 32.30468633 -102.63765479999999 2020-04-08 22:51:58 Andrews, Texas, US
2020-04-08 US Maine Androscoggin 23001 23 0 0 0 44.1664747 -70.20380627 2020-04-08 22:51:58 Androscoggin, Maine, US
2020-04-08 US Texas Angelina 48005 14 0 0 0 31.25457347 -94.60901487 2020-04-08 22:51:58 Angelina, Texas, US
2020-04-08 US Maryland Anne Arundel 24003 466 12 0 0 39.00670238 -76.60329337 2020-04-08 22:51:58 Anne Arundel, Maryland, US
2020-04-08 US Minnesota Anoka 27003 46 0 0 0 45.27476015 -93.24604565 2020-04-08 22:51:58 Anoka, Minnesota, US
2020-04-08 US North Carolina Anson 37007 6 0 0 0 34.97403241 -80.09953279 2020-04-08 22:51:58 Anson, North Carolina, US
2020-04-08 US Nebraska Antelope 31003 1 0 0 0 42.17695516 -98.06662829999999 2020-04-08 22:51:58 Antelope, Nebraska, US
2020-04-08 US Michigan Antrim 26009 6 0 0 0 44.99690221 -85.15503082 2020-04-08 22:51:58 Antrim, Michigan, US
2020-04-08 US Arizona Apache 04001 78 0 0 0 35.5313 -109.3783 2020-04-08 22:51:58 Apache,Arizona,US
2020-04-08 US Iowa Appanoose 19007 1 1 0 0 40.74324454 -92.86865906 2020-04-08 22:51:58 Appanoose, Iowa, US
2020-04-08 US Georgia Appling 13001 6 0 0 0 31.74847232 -82.28909114 2020-04-08 22:51:58 Appling, Georgia, US
2020-04-08 US Virginia Appomattox 51011 3 0 0 0 37.37569884 -78.81340003 2020-04-08 22:51:58 Appomattox, Virginia, US
2020-04-08 US Texas Aransas 48007 2 0 0 0 28.10556197 -96.9995047 2020-04-08 22:51:58 Aransas, Texas, US
2020-04-08 US Colorado Arapahoe 08005 764 19 0 0 39.64977461 -104.3353617 2020-04-08 22:51:58 Arapahoe, Colorado, US
2020-04-08 US Colorado Archuleta 08007 6 0 0 0 37.19474156 -107.04768670000001 2020-04-08 22:51:58 Archuleta, Colorado, US
2020-04-08 US Michigan Arenac 26011 4 0 0 0 44.0636262 -83.89277559 2020-04-08 22:51:58 Arenac, Michigan, US
2020-04-08 US Arkansas Arkansas 05001 1 0 0 0 34.29145151 -91.37277296 2020-04-08 22:51:58 Arkansas, Arkansas, US
2020-04-08 US Virginia Arlington 51013 254 2 0 0 38.8767675 -77.10139853 2020-04-08 22:51:58 Arlington, Virginia, US
2020-04-08 US Pennsylvania Armstrong 42005 19 0 0 0 40.81665618 -79.46290811 2020-04-08 22:51:58 Armstrong, Pennsylvania, US
2020-04-08 US Maine Aroostook 23003 2 0 0 0 46.65926321 -68.59841248 2020-04-08 22:51:58 Aroostook, Maine, US
2020-04-08 US Louisiana Ascension 22005 366 15 0 0 30.20406249 -90.91328409999998 2020-04-08 22:51:58 Ascension, Louisiana, US
2020-04-08 US North Carolina Ashe 37009 2 0 0 0 36.43296207 -81.49862729 2020-04-08 22:51:58 Ashe, North Carolina, US
2020-04-08 US Ohio Ashland 39005 3 0 0 0 40.84772277 -82.27280781 2020-04-08 22:51:58 Ashland, Ohio, US
2020-04-08 US Wisconsin Ashland 55003 1 0 0 0 46.31956891 -90.67837132 2020-04-08 22:51:58 Ashland, Wisconsin, US
2020-04-08 US Arkansas Ashley 05003 5 0 0 0 33.19153461 -91.76984709999999 2020-04-08 22:51:58 Ashley, Arkansas, US
2020-04-08 US Ohio Ashtabula 39007 20 0 0 0 41.70860332 -80.74830218 2020-04-08 22:51:58 Ashtabula, Ohio, US
2020-04-08 US Washington Asotin 53003 4 0 0 0 46.18894415 -117.2022851 2020-04-08 22:51:58 Asotin, Washington, US
2020-04-08 US Louisiana Assumption 22007 89 0 0 0 29.89946234 -91.06461642 2020-04-08 22:51:58 Assumption, Louisiana, US
2020-04-08 US Texas Atascosa 48013 5 0 0 0 28.89333001 -98.52730485 2020-04-08 22:51:58 Atascosa, Texas, US
2020-04-08 US Kansas Atchison 20005 2 0 0 0 39.53185661 -95.30870026 2020-04-08 22:51:58 Atchison, Kansas, US
2020-04-08 US Missouri Atchison 29005 1 0 0 0 40.43238737 -95.42970639 2020-04-08 22:51:58 Atchison, Missouri, US
2020-04-08 US Ohio Athens 39009 3 1 0 0 39.33425634 -82.04278644 2020-04-08 22:51:58 Athens, Ohio, US
2020-04-08 US Georgia Atkinson 13003 4 0 0 0 31.29633502 -82.87545866 2020-04-08 22:51:58 Atkinson, Georgia, US
2020-04-08 US New Jersey Atlantic 34001 168 4 0 0 39.47538693 -74.65848483 2020-04-08 22:51:58 Atlantic, New Jersey, US
2020-04-08 US Oklahoma Atoka 40005 1 0 0 0 34.37366573 -96.03802487 2020-04-08 22:51:58 Atoka, Oklahoma, US
2020-04-08 US Mississippi Attala 28007 15 0 0 0 33.08658803 -89.57838564 2020-04-08 22:51:58 Attala, Mississippi, US
2020-04-08 US Iowa Audubon 19009 1 0 0 0 41.6844628 -94.90581859 2020-04-08 22:51:58 Audubon, Iowa, US
2020-04-08 US Ohio Auglaize 39011 8 0 0 0 40.55998859 -84.22421429999999 2020-04-08 22:51:58 Auglaize, Ohio, US
2020-04-08 US Virginia Augusta 51015 13 0 0 0 38.16404586 -79.12461614 2020-04-08 22:51:58 Augusta, Virginia, US
2020-04-08 US South Dakota Aurora 46003 1 0 0 0 43.71757685 -98.56050467 2020-04-08 22:51:58 Aurora, South Dakota, US
2020-04-08 US Texas Austin 48015 7 0 0 0 29.88548725 -96.27736949 2020-04-08 22:51:58 Austin, Texas, US
2020-04-08 US Alabama Autauga 01001 12 1 0 0 32.53952745 -86.64408227 2020-04-08 22:51:58 Autauga, Alabama, US
2020-04-08 US Louisiana Avoyelles 22009 48 1 0 0 31.07796211 -92.00079449 2020-04-08 22:51:58 Avoyelles, Louisiana, US
2020-04-08 US Colorado Baca 08009 9 0 0 0 37.31940883 -102.5603223 2020-04-08 22:51:58 Baca, Colorado, US
2020-04-08 US Georgia Bacon 13005 13 0 0 0 31.55456473 -82.45936528 2020-04-08 22:51:58 Bacon, Georgia, US
2020-04-08 US Florida Baker 12003 15 1 0 0 30.33060121 -82.28467476 2020-04-08 22:51:58 Baker, Florida, US
2020-04-08 US Georgia Baker 13007 9 2 0 0 31.32669878 -84.44218806 2020-04-08 22:51:58 Baker, Georgia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 1891.961ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette