johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

243,956 rows sorted by day descending

View and edit SQL

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
99591 2020-06-03 US South Carolina Abbeville 45001 46 0 0 46 34.22333378 -82.46170658 2020-06-04 02:33:14 Abbeville, South Carolina, US
99592 2020-06-03 US Louisiana Acadia 22001 446 26 0 420 30.2950649 -92.41419698 2020-06-04 02:33:14 Acadia, Louisiana, US
99593 2020-06-03 US Virginia Accomack 51001 953 12 0 941 37.76707161 -75.63234615 2020-06-04 02:33:14 Accomack, Virginia, US
99594 2020-06-03 US Idaho Ada 16001 818 22 0 796 43.4526575 -116.24155159999998 2020-06-04 02:33:14 Ada, Idaho, US
99595 2020-06-03 US Iowa Adair 19001 9 0 0 9 41.33075609 -94.47105874 2020-06-04 02:33:14 Adair, Iowa, US
99596 2020-06-03 US Kentucky Adair 21001 97 19 0 78 37.10459774 -85.28129668 2020-06-04 02:33:14 Adair, Kentucky, US
99597 2020-06-03 US Missouri Adair 29001 60 0 0 60 40.19058551 -92.60078167 2020-06-04 02:33:14 Adair, Missouri, US
99598 2020-06-03 US Oklahoma Adair 40001 91 4 0 87 35.88494195 -94.65859267 2020-06-04 02:33:14 Adair, Oklahoma, US
99599 2020-06-03 US Colorado Adams 8001 3379 127 0 3252 39.87432092 -104.3362578 2020-06-04 02:33:14 Adams, Colorado, US
99600 2020-06-03 US Idaho Adams 16003 3 0 0 3 44.89333571 -116.4545247 2020-06-04 02:33:14 Adams, Idaho, US
99601 2020-06-03 US Illinois Adams 17001 44 1 0 43 39.98815591 -91.18786813 2020-06-04 02:33:14 Adams, Illinois, US
99602 2020-06-03 US Indiana Adams 18001 20 1 0 19 40.7457653 -84.93671406 2020-06-04 02:33:14 Adams, Indiana, US
99603 2020-06-03 US Iowa Adams 19003 7 0 0 7 41.02903567 -94.69932645 2020-06-04 02:33:14 Adams, Iowa, US
99604 2020-06-03 US Mississippi Adams 28001 202 16 0 186 31.47669768 -91.35326037 2020-06-04 02:33:14 Adams, Mississippi, US
99605 2020-06-03 US Nebraska Adams 31001 273 11 0 262 40.52449420000001 -98.50117804 2020-06-04 02:33:14 Adams, Nebraska, US
99606 2020-06-03 US Ohio Adams 39001 10 1 0 9 38.84541072 -83.4718964 2020-06-04 02:33:14 Adams, Ohio, US
99607 2020-06-03 US Pennsylvania Adams 42001 260 8 0 252 39.87140411 -77.21610347 2020-06-04 02:33:14 Adams, Pennsylvania, US
99608 2020-06-03 US Washington Adams 53001 73 0 0 73 46.98299757 -118.5601734 2020-06-04 02:33:14 Adams, Washington, US
99609 2020-06-03 US Wisconsin Adams 55001 4 1 0 3 43.96974651 -89.76782777 2020-06-04 02:33:14 Adams, Wisconsin, US
99610 2020-06-03 US Vermont Addison 50001 64 2 0 62 44.03217337 -73.14130877 2020-06-04 02:33:14 Addison, Vermont, US
99611 2020-06-03 US South Carolina Aiken 45003 208 7 0 201 33.54338026 -81.63645384 2020-06-04 02:33:14 Aiken, South Carolina, US
99612 2020-06-03 US Minnesota Aitkin 27001 11 0 0 11 46.60962049 -93.4116826 2020-06-04 02:33:14 Aitkin, Minnesota, US
99613 2020-06-03 US Florida Alachua 12001 383 8 0 375 29.67866525 -82.35928158 2020-06-04 02:33:14 Alachua, Florida, US
99614 2020-06-03 US North Carolina Alamance 37001 413 29 0 384 36.0434701 -79.39976137 2020-06-04 02:33:14 Alamance, North Carolina, US
99615 2020-06-03 US California Alameda 6001 3548 97 0 3451 37.64629437 -121.8929271 2020-06-04 02:33:14 Alameda, California, US
99616 2020-06-03 US Colorado Alamosa 8003 84 2 0 82 37.57250606 -105.7885451 2020-06-04 02:33:14 Alamosa, Colorado, US
99617 2020-06-03 US New York Albany 36001 1920 112 0 1808 42.60060306 -73.97723916 2020-06-04 02:33:14 Albany, New York, US
99618 2020-06-03 US Wyoming Albany 56001 25 0 0 25 41.65498705 -105.7235415 2020-06-04 02:33:14 Albany, Wyoming, US
99619 2020-06-03 US Virginia Albemarle 51003 204 8 0 196 38.02080697 -78.55481085 2020-06-04 02:33:14 Albemarle, Virginia, US
99620 2020-06-03 US Michigan Alcona 26001 17 1 0 16 44.6846864 -83.59507875 2020-06-04 02:33:14 Alcona, Michigan, US
99621 2020-06-03 US Mississippi Alcorn 28003 19 1 0 18 34.88084463 -88.57996173 2020-06-04 02:33:14 Alcorn, Mississippi, US
99622 2020-06-03 US Illinois Alexander 17003 12 0 0 12 37.18049267 -89.32910838 2020-06-04 02:33:14 Alexander, Illinois, US
99623 2020-06-03 US North Carolina Alexander 37003 38 0 0 38 35.922379600000006 -81.17751948 2020-06-04 02:33:14 Alexander, North Carolina, US
99624 2020-06-03 US Virginia Alexandria 51510 2016 46 0 1970 38.814003 -77.08183073 2020-06-04 02:33:14 Alexandria, Virginia, US
99625 2020-06-03 US Oklahoma Alfalfa 40003 1 0 0 1 36.73090616 -98.32408495 2020-06-04 02:33:14 Alfalfa, Oklahoma, US
99626 2020-06-03 US Iowa Allamakee 19005 120 4 0 116 43.28383218 -91.37860922 2020-06-04 02:33:14 Allamakee, Iowa, US
99627 2020-06-03 US Michigan Allegan 26005 221 6 0 215 42.59147037 -85.89102866 2020-06-04 02:33:14 Allegan, Michigan, US
99628 2020-06-03 US Maryland Allegany 24001 182 17 0 165 39.62357628 -78.69280486 2020-06-04 02:33:14 Allegany, Maryland, US
99629 2020-06-03 US New York Allegany 36003 49 0 0 49 42.25748406 -78.02750466 2020-06-04 02:33:14 Allegany, New York, US
99630 2020-06-03 US North Carolina Alleghany 37005 24 0 0 24 36.49360862 -81.12857041 2020-06-04 02:33:14 Alleghany, North Carolina, US
99631 2020-06-03 US Virginia Alleghany 51005 24 2 0 22 37.78636074 -80.00222498 2020-06-04 02:33:14 Alleghany, Virginia, US
99632 2020-06-03 US Pennsylvania Allegheny 42003 1952 166 0 1786 40.46809875 -79.98167747 2020-06-04 02:33:14 Allegheny, Pennsylvania, US
99633 2020-06-03 US Indiana Allen 18003 1743 71 0 1672 41.09194313 -85.06800636 2020-06-04 02:33:14 Allen, Indiana, US
99634 2020-06-03 US Kansas Allen 20001 1 0 0 1 37.88582951 -95.30030847 2020-06-04 02:33:14 Allen, Kansas, US
99635 2020-06-03 US Kentucky Allen 21003 96 3 0 93 36.75197631 -86.19457544 2020-06-04 02:33:14 Allen, Kentucky, US
99636 2020-06-03 US Louisiana Allen 22003 185 10 0 175 30.65385745 -92.82442028 2020-06-04 02:33:14 Allen, Louisiana, US
99637 2020-06-03 US Ohio Allen 39003 214 33 0 181 40.77285242 -84.10802343 2020-06-04 02:33:14 Allen, Ohio, US
99638 2020-06-03 US South Carolina Allendale 45005 38 3 0 35 32.98837386 -81.35321066 2020-06-04 02:33:14 Allendale, South Carolina, US
99639 2020-06-03 US Michigan Alpena 26007 95 9 0 86 45.03477666 -83.62212411 2020-06-04 02:33:14 Alpena, Michigan, US
99640 2020-06-03 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-06-04 02:33:14 Alpine, California, US
99641 2020-06-03 US California Amador 6005 10 0 0 10 38.44583082 -120.65696 2020-06-04 02:33:14 Amador, California, US
99642 2020-06-03 US Virginia Amelia 51007 28 1 0 27 37.34081025 -77.98584649 2020-06-04 02:33:14 Amelia, Virginia, US
99643 2020-06-03 US Virginia Amherst 51009 27 0 0 27 37.60308293 -79.14548696 2020-06-04 02:33:14 Amherst, Virginia, US
99644 2020-06-03 US Mississippi Amite 28005 65 1 0 64 31.17467303 -90.80501621 2020-06-04 02:33:14 Amite, Mississippi, US
99645 2020-06-03 US Alaska Anchorage 2020 254 4 0 250 61.14998174 -149.14269860000005 2020-06-04 02:33:14 Anchorage, Alaska, US
99646 2020-06-03 US Kansas Anderson 20003 1 0 0 1 38.21413251 -95.29272815 2020-06-04 02:33:14 Anderson, Kansas, US
99647 2020-06-03 US Kentucky Anderson 21005 21 1 0 20 38.00671029 -84.99171713 2020-06-04 02:33:14 Anderson, Kentucky, US
99648 2020-06-03 US South Carolina Anderson 45007 244 9 0 235 34.51828081 -82.63959517 2020-06-04 02:33:14 Anderson, South Carolina, US
99649 2020-06-03 US Tennessee Anderson 47001 41 1 0 40 36.12684348 -84.19965764 2020-06-04 02:33:14 Anderson, Tennessee, US
99650 2020-06-03 US Texas Anderson 48001 78 0 0 78 31.81534745 -95.65354823 2020-06-04 02:33:14 Anderson, Texas, US
99651 2020-06-03 US Missouri Andrew 29003 31 0 0 31 39.98492163 -94.80163024 2020-06-04 02:33:14 Andrew, Missouri, US
99652 2020-06-03 US Texas Andrews 48003 27 0 0 27 32.30468633 -102.6376548 2020-06-04 02:33:14 Andrews, Texas, US
99653 2020-06-03 US Maine Androscoggin 23001 326 2 0 324 44.1664747 -70.20380627 2020-06-04 02:33:14 Androscoggin, Maine, US
99654 2020-06-03 US Texas Angelina 48005 232 5 0 227 31.25457347 -94.60901487 2020-06-04 02:33:14 Angelina, Texas, US
99655 2020-06-03 US Maryland Anne Arundel 24003 4009 178 0 3831 39.00670238 -76.60329337 2020-06-04 02:33:14 Anne Arundel, Maryland, US
99656 2020-06-03 US Minnesota Anoka 27003 1470 73 0 1397 45.27476015 -93.24604565 2020-06-04 02:33:14 Anoka, Minnesota, US
99657 2020-06-03 US North Carolina Anson 37007 68 1 0 67 34.97403241 -80.09953279 2020-06-04 02:33:14 Anson, North Carolina, US
99658 2020-06-03 US Nebraska Antelope 31003 8 0 0 8 42.17695516 -98.0666283 2020-06-04 02:33:14 Antelope, Nebraska, US
99659 2020-06-03 US Michigan Antrim 26009 12 0 0 12 44.99690221 -85.15503082 2020-06-04 02:33:14 Antrim, Michigan, US
99660 2020-06-03 US Arizona Apache 4001 1586 45 0 1541 35.39465006 -109.4892383 2020-06-04 02:33:14 Apache, Arizona, US
99661 2020-06-03 US Iowa Appanoose 19007 14 3 0 11 40.74324454 -92.86865906 2020-06-04 02:33:14 Appanoose, Iowa, US
99662 2020-06-03 US Georgia Appling 13001 170 13 0 157 31.74847232 -82.28909114 2020-06-04 02:33:14 Appling, Georgia, US
99663 2020-06-03 US Virginia Appomattox 51011 31 0 0 31 37.37569884 -78.81340003 2020-06-04 02:33:14 Appomattox, Virginia, US
99664 2020-06-03 US Texas Aransas 48007 5 0 0 5 28.10556197 -96.9995047 2020-06-04 02:33:14 Aransas, Texas, US
99665 2020-06-03 US Colorado Arapahoe 8005 4496 320 0 4176 39.64977461 -104.3353617 2020-06-04 02:33:14 Arapahoe, Colorado, US
99666 2020-06-03 US Texas Archer 48009 1 0 0 1 33.61569967 -98.68754589 2020-06-04 02:33:14 Archer, Texas, US
99667 2020-06-03 US Colorado Archuleta 8007 8 0 0 8 37.19474156 -107.04768670000001 2020-06-04 02:33:14 Archuleta, Colorado, US
99668 2020-06-03 US Michigan Arenac 26011 34 1 0 33 44.0636262 -83.89277559 2020-06-04 02:33:14 Arenac, Michigan, US
99669 2020-06-03 US Arkansas Arkansas 5001 7 0 0 7 34.29145151 -91.37277296 2020-06-04 02:33:14 Arkansas, Arkansas, US
99670 2020-06-03 US Virginia Arlington 51013 2142 120 0 2022 38.8767675 -77.10139853 2020-06-04 02:33:14 Arlington, Virginia, US
99671 2020-06-03 US Pennsylvania Armstrong 42005 64 5 0 59 40.81665618 -79.46290811 2020-06-04 02:33:14 Armstrong, Pennsylvania, US
99672 2020-06-03 US Texas Armstrong 48011 3 0 0 3 34.96507426 -101.3574874 2020-06-04 02:33:14 Armstrong, Texas, US
99673 2020-06-03 US Maine Aroostook 23003 10 1 0 9 46.65926321 -68.59841248 2020-06-04 02:33:14 Aroostook, Maine, US
99674 2020-06-03 US Nebraska Arthur 31005 0 0 0 0 41.56896142 -101.6959559 2020-06-04 02:33:14 Arthur, Nebraska, US
99675 2020-06-03 US Louisiana Ascension 22005 852 57 0 795 30.20406249 -90.91328409999998 2020-06-04 02:33:14 Ascension, Louisiana, US
99676 2020-06-03 US North Carolina Ashe 37009 37 0 0 37 36.43296207 -81.49862729 2020-06-04 02:33:14 Ashe, North Carolina, US
99677 2020-06-03 US Ohio Ashland 39005 21 0 0 21 40.84772277 -82.27280781 2020-06-04 02:33:14 Ashland, Ohio, US
99678 2020-06-03 US Wisconsin Ashland 55003 2 0 0 2 46.31956891 -90.67837132 2020-06-04 02:33:14 Ashland, Wisconsin, US
99679 2020-06-03 US Arkansas Ashley 5003 20 0 0 20 33.19153461 -91.7698471 2020-06-04 02:33:14 Ashley, Arkansas, US
99680 2020-06-03 US Ohio Ashtabula 39007 345 37 0 308 41.70860332 -80.74830218 2020-06-04 02:33:14 Ashtabula, Ohio, US
99681 2020-06-03 US Washington Asotin 53003 19 2 0 17 46.18894415 -117.2022851 2020-06-04 02:33:14 Asotin, Washington, US
99682 2020-06-03 US Louisiana Assumption 22007 252 14 0 238 29.89946234 -91.06461642 2020-06-04 02:33:14 Assumption, Louisiana, US
99683 2020-06-03 US Texas Atascosa 48013 37 2 0 35 28.89333001 -98.52730485 2020-06-04 02:33:14 Atascosa, Texas, US
99684 2020-06-03 US Kansas Atchison 20005 23 0 0 23 39.53185661 -95.30870026 2020-06-04 02:33:14 Atchison, Kansas, US
99685 2020-06-03 US Missouri Atchison 29005 3 0 0 3 40.43238737 -95.42970639 2020-06-04 02:33:14 Atchison, Missouri, US
99686 2020-06-03 US Ohio Athens 39009 18 1 0 17 39.33425634 -82.04278644 2020-06-04 02:33:14 Athens, Ohio, US
99687 2020-06-03 US Georgia Atkinson 13003 53 2 0 51 31.29633502 -82.87545866 2020-06-04 02:33:14 Atkinson, Georgia, US
99688 2020-06-03 US New Jersey Atlantic 34001 2284 163 0 2121 39.47538693 -74.65848483 2020-06-04 02:33:14 Atlantic, New Jersey, US
99689 2020-06-03 US Oklahoma Atoka 40005 4 0 0 4 34.37366573 -96.03802487 2020-06-04 02:33:14 Atoka, Oklahoma, US
99690 2020-06-03 US Mississippi Attala 28007 307 18 0 289 33.08658803 -89.57838564 2020-06-04 02:33:14 Attala, Mississippi, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 3528.102ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette