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

310,841 rows where country_or_region = "US" sorted by day descending

View and edit SQL

These facets timed out: province_or_state

country_or_region

  • US · 310,841
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
308507 2020-07-04 US South Carolina Abbeville 45001 119 0 0 119 34.22333378 -82.46170658 2020-07-05 04:33:46 Abbeville, South Carolina, US
308508 2020-07-04 US Louisiana Acadia 22001 968 39 0 929 30.2950649 -92.41419698 2020-07-05 04:33:46 Acadia, Louisiana, US
308509 2020-07-04 US Virginia Accomack 51001 1043 14 0 1029 37.76707161 -75.63234615 2020-07-05 04:33:46 Accomack, Virginia, US
308510 2020-07-04 US Idaho Ada 16001 2631 23 0 2608 43.4526575 -116.24155159999998 2020-07-05 04:33:46 Ada, Idaho, US
308511 2020-07-04 US Iowa Adair 19001 15 0 0 15 41.33075609 -94.47105874 2020-07-05 04:33:46 Adair, Iowa, US
308512 2020-07-04 US Kentucky Adair 21001 126 19 0 107 37.10459774 -85.28129668 2020-07-05 04:33:46 Adair, Kentucky, US
308513 2020-07-04 US Missouri Adair 29001 93 0 0 93 40.19058551 -92.60078167 2020-07-05 04:33:46 Adair, Missouri, US
308514 2020-07-04 US Oklahoma Adair 40001 120 4 0 116 35.88494195 -94.65859267 2020-07-05 04:33:46 Adair, Oklahoma, US
308515 2020-07-04 US Colorado Adams 8001 4322 156 0 4166 39.87432092 -104.3362578 2020-07-05 04:33:46 Adams, Colorado, US
308516 2020-07-04 US Idaho Adams 16003 11 0 0 11 44.89333571 -116.4545247 2020-07-05 04:33:46 Adams, Idaho, US
308517 2020-07-04 US Illinois Adams 17001 113 1 0 112 39.98815591 -91.18786813 2020-07-05 04:33:46 Adams, Illinois, US
308518 2020-07-04 US Indiana Adams 18001 50 1 0 49 40.7457653 -84.93671406 2020-07-05 04:33:46 Adams, Indiana, US
308519 2020-07-04 US Iowa Adams 19003 8 0 0 8 41.02903567 -94.69932645 2020-07-05 04:33:46 Adams, Iowa, US
308520 2020-07-04 US Mississippi Adams 28001 310 18 0 292 31.47669768 -91.35326037 2020-07-05 04:33:46 Adams, Mississippi, US
308521 2020-07-04 US Nebraska Adams 31001 299 11 0 288 40.52449420000001 -98.50117804 2020-07-05 04:33:46 Adams, Nebraska, US
308522 2020-07-04 US Ohio Adams 39001 23 1 0 22 38.84541072 -83.4718964 2020-07-05 04:33:46 Adams, Ohio, US
308523 2020-07-04 US Pennsylvania Adams 42001 349 13 0 336 39.87140411 -77.21610347 2020-07-05 04:33:46 Adams, Pennsylvania, US
308524 2020-07-04 US Washington Adams 53001 150 0 0 150 46.98299757 -118.5601734 2020-07-05 04:33:46 Adams, Washington, US
308525 2020-07-04 US Wisconsin Adams 55001 27 2 0 25 43.96974651 -89.76782777 2020-07-05 04:33:46 Adams, Wisconsin, US
308526 2020-07-04 US Vermont Addison 50001 68 2 0 66 44.03217337 -73.14130877 2020-07-05 04:33:46 Addison, Vermont, US
308527 2020-07-04 US South Carolina Aiken 45003 488 10 0 478 33.54338026 -81.63645384 2020-07-05 04:33:46 Aiken, South Carolina, US
308528 2020-07-04 US Minnesota Aitkin 27001 14 0 0 14 46.60962049 -93.4116826 2020-07-05 04:33:46 Aitkin, Minnesota, US
308529 2020-07-04 US Florida Alachua 12001 1506 12 0 1494 29.67866525 -82.35928158 2020-07-05 04:33:46 Alachua, Florida, US
308530 2020-07-04 US North Carolina Alamance 37001 1240 37 0 1203 36.0434701 -79.39976137 2020-07-05 04:33:46 Alamance, North Carolina, US
308531 2020-07-04 US California Alameda 6001 6556 140 0 6416 37.64629437 -121.8929271 2020-07-05 04:33:46 Alameda, California, US
308532 2020-07-04 US Colorado Alamosa 8003 200 4 0 196 37.57250606 -105.7885451 2020-07-05 04:33:46 Alamosa, Colorado, US
308533 2020-07-04 US New York Albany 36001 2145 121 0 2024 42.60060306 -73.97723916 2020-07-05 04:33:46 Albany, New York, US
308534 2020-07-04 US Wyoming Albany 56001 36 0 0 36 41.65498705 -105.7235415 2020-07-05 04:33:46 Albany, Wyoming, US
308535 2020-07-04 US Virginia Albemarle 51003 456 9 0 447 38.02080697 -78.55481085 2020-07-05 04:33:46 Albemarle, Virginia, US
308536 2020-07-04 US Michigan Alcona 26001 22 1 0 21 44.6846864 -83.59507875 2020-07-05 04:33:46 Alcona, Michigan, US
308537 2020-07-04 US Mississippi Alcorn 28003 68 2 0 66 34.88084463 -88.57996173 2020-07-05 04:33:46 Alcorn, Mississippi, US
308538 2020-07-04 US Illinois Alexander 17003 22 0 0 22 37.18049267 -89.32910838 2020-07-05 04:33:46 Alexander, Illinois, US
308539 2020-07-04 US North Carolina Alexander 37003 112 1 0 111 35.922379600000006 -81.17751948 2020-07-05 04:33:46 Alexander, North Carolina, US
308540 2020-07-04 US Virginia Alexandria 51510 2357 57 0 2300 38.814003 -77.08183073 2020-07-05 04:33:46 Alexandria, Virginia, US
308541 2020-07-04 US Oklahoma Alfalfa 40003 1 0 0 1 36.73090616 -98.32408495 2020-07-05 04:33:46 Alfalfa, Oklahoma, US
308542 2020-07-04 US Michigan Alger 26003 4 0 0 4 46.41292944 -86.60260122 2020-07-05 04:33:46 Alger, Michigan, US
308543 2020-07-04 US Iowa Allamakee 19005 128 4 0 124 43.28383218 -91.37860922 2020-07-05 04:33:46 Allamakee, Iowa, US
308544 2020-07-04 US Michigan Allegan 26005 331 7 0 324 42.59147037 -85.89102866 2020-07-05 04:33:46 Allegan, Michigan, US
308545 2020-07-04 US Maryland Allegany 24001 208 17 0 191 39.62357628 -78.69280486 2020-07-05 04:33:46 Allegany, Maryland, US
308546 2020-07-04 US New York Allegany 36003 63 1 0 62 42.25748406 -78.02750466 2020-07-05 04:33:46 Allegany, New York, US
308547 2020-07-04 US North Carolina Alleghany 37005 36 0 0 36 36.49360862 -81.12857041 2020-07-05 04:33:46 Alleghany, North Carolina, US
308548 2020-07-04 US Virginia Alleghany 51005 35 2 0 33 37.78636074 -80.00222498 2020-07-05 04:33:46 Alleghany, Virginia, US
308549 2020-07-04 US Pennsylvania Allegheny 42003 3430 190 0 3240 40.46809875 -79.98167747 2020-07-05 04:33:46 Allegheny, Pennsylvania, US
308550 2020-07-04 US Indiana Allen 18003 2737 129 0 2608 41.09194313 -85.06800636 2020-07-05 04:33:46 Allen, Indiana, US
308551 2020-07-04 US Kansas Allen 20001 4 0 0 4 37.88582951 -95.30030847 2020-07-05 04:33:46 Allen, Kansas, US
308552 2020-07-04 US Kentucky Allen 21003 171 7 0 164 36.75197631 -86.19457544 2020-07-05 04:33:46 Allen, Kentucky, US
308553 2020-07-04 US Louisiana Allen 22003 321 11 0 310 30.65385745 -92.82442028 2020-07-05 04:33:46 Allen, Louisiana, US
308554 2020-07-04 US Ohio Allen 39003 308 40 0 268 40.77285242 -84.10802343 2020-07-05 04:33:46 Allen, Ohio, US
308555 2020-07-04 US South Carolina Allendale 45005 58 3 0 55 32.98837386 -81.35321066 2020-07-05 04:33:46 Allendale, South Carolina, US
308556 2020-07-04 US Michigan Alpena 26007 123 11 0 112 45.03477666 -83.62212411 2020-07-05 04:33:46 Alpena, Michigan, US
308557 2020-07-04 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-07-05 04:33:46 Alpine, California, US
308558 2020-07-04 US California Amador 6005 31 0 0 31 38.44583082 -120.65696 2020-07-05 04:33:46 Amador, California, US
308559 2020-07-04 US Virginia Amelia 51007 45 1 0 44 37.34081025 -77.98584649 2020-07-05 04:33:46 Amelia, Virginia, US
308560 2020-07-04 US Virginia Amherst 51009 37 0 0 37 37.60308293 -79.14548696 2020-07-05 04:33:46 Amherst, Virginia, US
308561 2020-07-04 US Mississippi Amite 28005 89 2 0 87 31.17467303 -90.80501621 2020-07-05 04:33:46 Amite, Mississippi, US
308562 2020-07-04 US Alaska Anchorage 2020 525 7 0 518 61.14998174 -149.14269860000005 2020-07-05 04:33:46 Anchorage, Alaska, US
308563 2020-07-04 US Kansas Anderson 20003 4 0 0 4 38.21413251 -95.29272815 2020-07-05 04:33:46 Anderson, Kansas, US
308564 2020-07-04 US Kentucky Anderson 21005 29 1 0 28 38.00671029 -84.99171713 2020-07-05 04:33:46 Anderson, Kentucky, US
308565 2020-07-04 US South Carolina Anderson 45007 761 12 0 749 34.51828081 -82.63959517 2020-07-05 04:33:46 Anderson, South Carolina, US
308566 2020-07-04 US Tennessee Anderson 47001 134 2 0 132 36.12684348 -84.19965764 2020-07-05 04:33:46 Anderson, Tennessee, US
308567 2020-07-04 US Texas Anderson 48001 1070 2 0 1068 31.81534745 -95.65354823 2020-07-05 04:33:46 Anderson, Texas, US
308568 2020-07-04 US Missouri Andrew 29003 55 0 0 55 39.98492163 -94.80163024 2020-07-05 04:33:46 Andrew, Missouri, US
308569 2020-07-04 US Texas Andrews 48003 98 1 0 97 32.30468633 -102.6376548 2020-07-05 04:33:46 Andrews, Texas, US
308570 2020-07-04 US Maine Androscoggin 23001 494 4 0 490 44.1664747 -70.20380627 2020-07-05 04:33:46 Androscoggin, Maine, US
308571 2020-07-04 US Texas Angelina 48005 541 9 0 532 31.25457347 -94.60901487 2020-07-05 04:33:46 Angelina, Texas, US
308572 2020-07-04 US Maryland Anne Arundel 24003 5239 209 0 5030 39.00670238 -76.60329337 2020-07-05 04:33:46 Anne Arundel, Maryland, US
308573 2020-07-04 US Minnesota Anoka 27003 2180 107 0 2073 45.27476015 -93.24604565 2020-07-05 04:33:46 Anoka, Minnesota, US
308574 2020-07-04 US North Carolina Anson 37007 148 2 0 146 34.97403241 -80.09953279 2020-07-05 04:33:46 Anson, North Carolina, US
308575 2020-07-04 US Nebraska Antelope 31003 9 1 0 8 42.17695516 -98.0666283 2020-07-05 04:33:46 Antelope, Nebraska, US
308576 2020-07-04 US Michigan Antrim 26009 22 0 0 22 44.99690221 -85.15503082 2020-07-05 04:33:46 Antrim, Michigan, US
308577 2020-07-04 US Arizona Apache 4001 2423 91 0 2332 35.39465006 -109.4892383 2020-07-05 04:33:46 Apache, Arizona, US
308578 2020-07-04 US Iowa Appanoose 19007 20 3 0 17 40.74324454 -92.86865906 2020-07-05 04:33:46 Appanoose, Iowa, US
308579 2020-07-04 US Georgia Appling 13001 285 14 0 271 31.74847232 -82.28909114 2020-07-05 04:33:46 Appling, Georgia, US
308580 2020-07-04 US Virginia Appomattox 51011 43 0 0 43 37.37569884 -78.81340003 2020-07-05 04:33:46 Appomattox, Virginia, US
308581 2020-07-04 US Texas Aransas 48007 34 0 0 34 28.10556197 -96.9995047 2020-07-05 04:33:46 Aransas, Texas, US
308582 2020-07-04 US Colorado Arapahoe 8005 5329 345 0 4984 39.64977461 -104.3353617 2020-07-05 04:33:46 Arapahoe, Colorado, US
308583 2020-07-04 US Texas Archer 48009 8 0 0 8 33.61569967 -98.68754589 2020-07-05 04:33:46 Archer, Texas, US
308584 2020-07-04 US Colorado Archuleta 8007 10 0 0 10 37.19474156 -107.04768670000001 2020-07-05 04:33:46 Archuleta, Colorado, US
308585 2020-07-04 US Michigan Arenac 26011 38 2 0 36 44.0636262 -83.89277559 2020-07-05 04:33:46 Arenac, Michigan, US
308586 2020-07-04 US Arkansas Arkansas 5001 37 0 0 37 34.29145151 -91.37277296 2020-07-05 04:33:46 Arkansas, Arkansas, US
308587 2020-07-04 US Virginia Arlington 51013 2519 131 0 2388 38.8767675 -77.10139853 2020-07-05 04:33:46 Arlington, Virginia, US
308588 2020-07-04 US Pennsylvania Armstrong 42005 79 6 0 73 40.81665618 -79.46290811 2020-07-05 04:33:46 Armstrong, Pennsylvania, US
308589 2020-07-04 US Texas Armstrong 48011 3 0 0 3 34.96507426 -101.3574874 2020-07-05 04:33:46 Armstrong, Texas, US
308590 2020-07-04 US Maine Aroostook 23003 24 1 0 23 46.65926321 -68.59841248 2020-07-05 04:33:46 Aroostook, Maine, US
308591 2020-07-04 US Nebraska Arthur 31005 0 0 0 0 41.56896142 -101.6959559 2020-07-05 04:33:46 Arthur, Nebraska, US
308592 2020-07-04 US Louisiana Ascension 22005 1278 58 0 1220 30.20406249 -90.91328409999998 2020-07-05 04:33:46 Ascension, Louisiana, US
308593 2020-07-04 US North Carolina Ashe 37009 54 1 0 53 36.43296207 -81.49862729 2020-07-05 04:33:46 Ashe, North Carolina, US
308594 2020-07-04 US Ohio Ashland 39005 58 1 0 57 40.84772277 -82.27280781 2020-07-05 04:33:46 Ashland, Ohio, US
308595 2020-07-04 US Wisconsin Ashland 55003 3 0 0 3 46.31956891 -90.67837132 2020-07-05 04:33:46 Ashland, Wisconsin, US
308596 2020-07-04 US Arkansas Ashley 5003 80 1 0 79 33.19153461 -91.7698471 2020-07-05 04:33:46 Ashley, Arkansas, US
308597 2020-07-04 US Ohio Ashtabula 39007 431 44 0 387 41.70860332 -80.74830218 2020-07-05 04:33:46 Ashtabula, Ohio, US
308598 2020-07-04 US Washington Asotin 53003 21 2 0 19 46.18894415 -117.2022851 2020-07-05 04:33:46 Asotin, Washington, US
308599 2020-07-04 US Louisiana Assumption 22007 373 15 0 358 29.89946234 -91.06461642 2020-07-05 04:33:46 Assumption, Louisiana, US
308600 2020-07-04 US Texas Atascosa 48013 135 2 0 133 28.89333001 -98.52730485 2020-07-05 04:33:46 Atascosa, Texas, US
308601 2020-07-04 US Kansas Atchison 20005 39 0 0 39 39.53185661 -95.30870026 2020-07-05 04:33:46 Atchison, Kansas, US
308602 2020-07-04 US Missouri Atchison 29005 5 0 0 5 40.43238737 -95.42970639 2020-07-05 04:33:46 Atchison, Missouri, US
308603 2020-07-04 US Ohio Athens 39009 49 1 0 48 39.33425634 -82.04278644 2020-07-05 04:33:46 Athens, Ohio, US
308604 2020-07-04 US Georgia Atkinson 13003 162 2 0 160 31.29633502 -82.87545866 2020-07-05 04:33:46 Atkinson, Georgia, US
308605 2020-07-04 US New Jersey Atlantic 34001 2926 220 0 2706 39.47538693 -74.65848483 2020-07-05 04:33:46 Atlantic, New Jersey, US
308606 2020-07-04 US Oklahoma Atoka 40005 25 0 0 25 34.37366573 -96.03802487 2020-07-05 04:33:46 Atoka, Oklahoma, 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 4283.314ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette