covid

⚠️ 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.

Custom SQL query returning 101 rows (hide)

rowiddaycountry_or_regionprovince_or_stateadmin2fipsconfirmeddeathsrecoveredactivelatitudelongitudelast_updatecombined_key
177675 2020-07-13 US South Carolina Abbeville 45001 157 1 0 156 34.22333378 -82.46170658 2020-07-14 04:34:46 Abbeville, South Carolina, US
177676 2020-07-13 US Louisiana Acadia 22001 1383 45 0 1338 30.2950649 -92.41419698 2020-07-14 04:34:46 Acadia, Louisiana, US
177677 2020-07-13 US Virginia Accomack 51001 1041 14 0 1027 37.76707161 -75.63234615 2020-07-14 04:34:46 Accomack, Virginia, US
177678 2020-07-13 US Idaho Ada 16001 4448 25 0 4423 43.4526575 -116.24155159999998 2020-07-14 04:34:46 Ada, Idaho, US
177679 2020-07-13 US Iowa Adair 19001 17 0 0 17 41.33075609 -94.47105874 2020-07-14 04:34:46 Adair, Iowa, US
177680 2020-07-13 US Kentucky Adair 21001 142 19 0 123 37.10459774 -85.28129668 2020-07-14 04:34:46 Adair, Kentucky, US
177681 2020-07-13 US Missouri Adair 29001 100 0 0 100 40.19058551 -92.60078167 2020-07-14 04:34:46 Adair, Missouri, US
177682 2020-07-13 US Oklahoma Adair 40001 137 4 0 133 35.88494195 -94.65859267 2020-07-14 04:34:46 Adair, Oklahoma, US
177683 2020-07-13 US Colorado Adams 8001 4788 158 0 4630 39.87432092 -104.3362578 2020-07-14 04:34:46 Adams, Colorado, US
177684 2020-07-13 US Idaho Adams 16003 12 0 0 12 44.89333571 -116.4545247 2020-07-14 04:34:46 Adams, Idaho, US
177685 2020-07-13 US Illinois Adams 17001 189 1 0 188 39.98815591 -91.18786813 2020-07-14 04:34:46 Adams, Illinois, US
177686 2020-07-13 US Indiana Adams 18001 49 1 0 48 40.7457653 -84.93671406 2020-07-14 04:34:46 Adams, Indiana, US
177687 2020-07-13 US Iowa Adams 19003 8 0 0 8 41.02903567 -94.69932645 2020-07-14 04:34:46 Adams, Iowa, US
177688 2020-07-13 US Mississippi Adams 28001 367 20 0 347 31.47669768 -91.35326037 2020-07-14 04:34:46 Adams, Mississippi, US
177689 2020-07-13 US Nebraska Adams 31001 314 11 0 303 40.52449420000001 -98.50117804 2020-07-14 04:34:46 Adams, Nebraska, US
177690 2020-07-13 US Ohio Adams 39001 28 2 0 26 38.84541072 -83.4718964 2020-07-14 04:34:46 Adams, Ohio, US
177691 2020-07-13 US Pennsylvania Adams 42001 398 14 0 384 39.87140411 -77.21610347 2020-07-14 04:34:46 Adams, Pennsylvania, US
177692 2020-07-13 US Washington Adams 53001 238 0 0 238 46.98299757 -118.5601734 2020-07-14 04:34:46 Adams, Washington, US
177693 2020-07-13 US Wisconsin Adams 55001 41 2 0 39 43.96974651 -89.76782777 2020-07-14 04:34:46 Adams, Wisconsin, US
177694 2020-07-13 US Vermont Addison 50001 68 2 0 66 44.03217337 -73.14130877 2020-07-14 04:34:46 Addison, Vermont, US
177695 2020-07-13 US South Carolina Aiken 45003 735 13 0 722 33.54338026 -81.63645384 2020-07-14 04:34:46 Aiken, South Carolina, US
177696 2020-07-13 US Minnesota Aitkin 27001 16 0 0 16 46.60962049 -93.4116826 2020-07-14 04:34:46 Aitkin, Minnesota, US
177697 2020-07-13 US Florida Alachua 12001 2173 12 0 2161 29.67866525 -82.35928158 2020-07-14 04:34:46 Alachua, Florida, US
177698 2020-07-13 US North Carolina Alamance 37001 1480 37 0 1443 36.0434701 -79.39976137 2020-07-14 04:34:46 Alamance, North Carolina, US
177699 2020-07-13 US California Alameda 6001 7976 148 0 7828 37.64629437 -121.8929271 2020-07-14 04:34:46 Alameda, California, US
177700 2020-07-13 US Colorado Alamosa 8003 204 6 0 198 37.57250606 -105.7885451 2020-07-14 04:34:46 Alamosa, Colorado, US
177701 2020-07-13 US New York Albany 36001 2225 121 0 2104 42.60060306 -73.97723916 2020-07-14 04:34:46 Albany, New York, US
177702 2020-07-13 US Wyoming Albany 56001 49 0 0 49 41.65498705 -105.7235415 2020-07-14 04:34:46 Albany, Wyoming, US
177703 2020-07-13 US Virginia Albemarle 51003 563 10 0 553 38.02080697 -78.55481085 2020-07-14 04:34:46 Albemarle, Virginia, US
177704 2020-07-13 US Michigan Alcona 26001 24 1 0 23 44.6846864 -83.59507875 2020-07-14 04:34:46 Alcona, Michigan, US
177705 2020-07-13 US Mississippi Alcorn 28003 111 2 0 109 34.88084463 -88.57996173 2020-07-14 04:34:46 Alcorn, Mississippi, US
177706 2020-07-13 US Alaska Aleutians West 2016 1 0 0 1 52.3233 -174.1596 2020-07-14 04:34:46 Aleutians West, Alaska, US
177707 2020-07-13 US Illinois Alexander 17003 25 0 0 25 37.18049267 -89.32910838 2020-07-14 04:34:46 Alexander, Illinois, US
177708 2020-07-13 US North Carolina Alexander 37003 174 1 0 173 35.922379600000006 -81.17751948 2020-07-14 04:34:46 Alexander, North Carolina, US
177709 2020-07-13 US Virginia Alexandria 51510 2456 57 0 2399 38.814003 -77.08183073 2020-07-14 04:34:46 Alexandria, Virginia, US
177710 2020-07-13 US Oklahoma Alfalfa 40003 1 0 0 1 36.73090616 -98.32408495 2020-07-14 04:34:46 Alfalfa, Oklahoma, US
177711 2020-07-13 US Michigan Alger 26003 4 0 0 4 46.41292944 -86.60260122 2020-07-14 04:34:46 Alger, Michigan, US
177712 2020-07-13 US Iowa Allamakee 19005 138 4 0 134 43.28383218 -91.37860922 2020-07-14 04:34:46 Allamakee, Iowa, US
177713 2020-07-13 US Michigan Allegan 26005 378 7 0 371 42.59147037 -85.89102866 2020-07-14 04:34:46 Allegan, Michigan, US
177714 2020-07-13 US Maryland Allegany 24001 218 18 0 200 39.62357628 -78.69280486 2020-07-14 04:34:46 Allegany, Maryland, US
177715 2020-07-13 US New York Allegany 36003 66 1 0 65 42.25748406 -78.02750466 2020-07-14 04:34:46 Allegany, New York, US
177716 2020-07-13 US North Carolina Alleghany 37005 42 0 0 42 36.49360862 -81.12857041 2020-07-14 04:34:46 Alleghany, North Carolina, US
177717 2020-07-13 US Virginia Alleghany 51005 52 2 0 50 37.78636074 -80.00222498 2020-07-14 04:34:46 Alleghany, Virginia, US
177718 2020-07-13 US Pennsylvania Allegheny 42003 5033 197 0 4836 40.46809875 -79.98167747 2020-07-14 04:34:46 Allegheny, Pennsylvania, US
177719 2020-07-13 US Indiana Allen 18003 2971 134 0 2837 41.09194313 -85.06800636 2020-07-14 04:34:46 Allen, Indiana, US
177720 2020-07-13 US Kansas Allen 20001 8 0 0 8 37.88582951 -95.30030847 2020-07-14 04:34:46 Allen, Kansas, US
177721 2020-07-13 US Kentucky Allen 21003 191 7 0 184 36.75197631 -86.19457544 2020-07-14 04:34:46 Allen, Kentucky, US
177722 2020-07-13 US Louisiana Allen 22003 480 12 0 468 30.65385745 -92.82442028 2020-07-14 04:34:46 Allen, Louisiana, US
177723 2020-07-13 US Ohio Allen 39003 385 41 0 344 40.77285242 -84.10802343 2020-07-14 04:34:46 Allen, Ohio, US
177724 2020-07-13 US South Carolina Allendale 45005 88 3 0 85 32.98837386 -81.35321066 2020-07-14 04:34:46 Allendale, South Carolina, US
177725 2020-07-13 US Michigan Alpena 26007 123 12 0 111 45.03477666 -83.62212411 2020-07-14 04:34:46 Alpena, Michigan, US
177726 2020-07-13 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-07-14 04:34:46 Alpine, California, US
177727 2020-07-13 US California Amador 6005 40 0 0 40 38.44583082 -120.65696 2020-07-14 04:34:46 Amador, California, US
177728 2020-07-13 US Virginia Amelia 51007 51 1 0 50 37.34081025 -77.98584649 2020-07-14 04:34:46 Amelia, Virginia, US
177729 2020-07-13 US Virginia Amherst 51009 40 0 0 40 37.60308293 -79.14548696 2020-07-14 04:34:46 Amherst, Virginia, US
177730 2020-07-13 US Mississippi Amite 28005 111 3 0 108 31.17467303 -90.80501621 2020-07-14 04:34:46 Amite, Mississippi, US
177731 2020-07-13 US Alaska Anchorage 2020 740 8 0 732 61.14998174 -149.14269860000005 2020-07-14 04:34:46 Anchorage, Alaska, US
177732 2020-07-13 US Kansas Anderson 20003 15 0 0 15 38.21413251 -95.29272815 2020-07-14 04:34:46 Anderson, Kansas, US
177733 2020-07-13 US Kentucky Anderson 21005 31 1 0 30 38.00671029 -84.99171713 2020-07-14 04:34:46 Anderson, Kentucky, US
177734 2020-07-13 US South Carolina Anderson 45007 1067 20 0 1047 34.51828081 -82.63959517 2020-07-14 04:34:46 Anderson, South Carolina, US
177735 2020-07-13 US Tennessee Anderson 47001 211 2 0 209 36.12684348 -84.19965764 2020-07-14 04:34:46 Anderson, Tennessee, US
177736 2020-07-13 US Texas Anderson 48001 1890 3 0 1887 31.81534745 -95.65354823 2020-07-14 04:34:46 Anderson, Texas, US
177737 2020-07-13 US Missouri Andrew 29003 55 1 0 54 39.98492163 -94.80163024 2020-07-14 04:34:46 Andrew, Missouri, US
177738 2020-07-13 US Texas Andrews 48003 169 2 0 167 32.30468633 -102.6376548 2020-07-14 04:34:46 Andrews, Texas, US
177739 2020-07-13 US Maine Androscoggin 23001 502 4 0 498 44.1664747 -70.20380627 2020-07-14 04:34:46 Androscoggin, Maine, US
177740 2020-07-13 US Texas Angelina 48005 743 9 0 734 31.25457347 -94.60901487 2020-07-14 04:34:46 Angelina, Texas, US
177741 2020-07-13 US Maryland Anne Arundel 24003 5562 210 0 5352 39.00670238 -76.60329337 2020-07-14 04:34:46 Anne Arundel, Maryland, US
177742 2020-07-13 US Minnesota Anoka 27003 2458 111 0 2347 45.27476015 -93.24604565 2020-07-14 04:34:46 Anoka, Minnesota, US
177743 2020-07-13 US North Carolina Anson 37007 208 2 0 206 34.97403241 -80.09953279 2020-07-14 04:34:46 Anson, North Carolina, US
177744 2020-07-13 US Nebraska Antelope 31003 16 1 0 15 42.17695516 -98.0666283 2020-07-14 04:34:46 Antelope, Nebraska, US
177745 2020-07-13 US Michigan Antrim 26009 27 0 0 27 44.99690221 -85.15503082 2020-07-14 04:34:46 Antrim, Michigan, US
177746 2020-07-13 US Arizona Apache 4001 2580 104 0 2476 35.39465006 -109.4892383 2020-07-14 04:34:46 Apache, Arizona, US
177747 2020-07-13 US Iowa Appanoose 19007 24 3 0 21 40.74324454 -92.86865906 2020-07-14 04:34:46 Appanoose, Iowa, US
177748 2020-07-13 US Georgia Appling 13001 349 14 0 335 31.74847232 -82.28909114 2020-07-14 04:34:46 Appling, Georgia, US
177749 2020-07-13 US Virginia Appomattox 51011 48 0 0 48 37.37569884 -78.81340003 2020-07-14 04:34:46 Appomattox, Virginia, US
177750 2020-07-13 US Texas Aransas 48007 56 0 0 56 28.10556197 -96.9995047 2020-07-14 04:34:46 Aransas, Texas, US
177751 2020-07-13 US Colorado Arapahoe 8005 5682 349 0 5333 39.64977461 -104.3353617 2020-07-14 04:34:46 Arapahoe, Colorado, US
177752 2020-07-13 US Texas Archer 48009 10 0 0 10 33.61569967 -98.68754589 2020-07-14 04:34:46 Archer, Texas, US
177753 2020-07-13 US Colorado Archuleta 8007 12 0 0 12 37.19474156 -107.04768670000001 2020-07-14 04:34:46 Archuleta, Colorado, US
177754 2020-07-13 US Michigan Arenac 26011 38 2 0 36 44.0636262 -83.89277559 2020-07-14 04:34:46 Arenac, Michigan, US
177755 2020-07-13 US Arkansas Arkansas 5001 60 0 0 60 34.29145151 -91.37277296 2020-07-14 04:34:46 Arkansas, Arkansas, US
177756 2020-07-13 US Virginia Arlington 51013 2626 134 0 2492 38.8767675 -77.10139853 2020-07-14 04:34:46 Arlington, Virginia, US
177757 2020-07-13 US Pennsylvania Armstrong 42005 86 6 0 80 40.81665618 -79.46290811 2020-07-14 04:34:46 Armstrong, Pennsylvania, US
177758 2020-07-13 US Texas Armstrong 48011 3 0 0 3 34.96507426 -101.3574874 2020-07-14 04:34:46 Armstrong, Texas, US
177759 2020-07-13 US Maine Aroostook 23003 24 1 0 23 46.65926321 -68.59841248 2020-07-14 04:34:46 Aroostook, Maine, US
177760 2020-07-13 US Nebraska Arthur 31005 0 0 0 0 41.56896142 -101.6959559 2020-07-14 04:34:46 Arthur, Nebraska, US
177761 2020-07-13 US Louisiana Ascension 22005 1622 64 0 1558 30.20406249 -90.91328409999998 2020-07-14 04:34:46 Ascension, Louisiana, US
177762 2020-07-13 US North Carolina Ashe 37009 64 1 0 63 36.43296207 -81.49862729 2020-07-14 04:34:46 Ashe, North Carolina, US
177763 2020-07-13 US Ohio Ashland 39005 69 2 0 67 40.84772277 -82.27280781 2020-07-14 04:34:46 Ashland, Ohio, US
177764 2020-07-13 US Wisconsin Ashland 55003 8 0 0 8 46.31956891 -90.67837132 2020-07-14 04:34:46 Ashland, Wisconsin, US
177765 2020-07-13 US Arkansas Ashley 5003 110 3 0 107 33.19153461 -91.7698471 2020-07-14 04:34:46 Ashley, Arkansas, US
177766 2020-07-13 US Ohio Ashtabula 39007 452 44 0 408 41.70860332 -80.74830218 2020-07-14 04:34:46 Ashtabula, Ohio, US
177767 2020-07-13 US Washington Asotin 53003 21 2 0 19 46.18894415 -117.2022851 2020-07-14 04:34:46 Asotin, Washington, US
177768 2020-07-13 US Louisiana Assumption 22007 430 16 0 414 29.89946234 -91.06461642 2020-07-14 04:34:46 Assumption, Louisiana, US
177769 2020-07-13 US Texas Atascosa 48013 275 2 0 273 28.89333001 -98.52730485 2020-07-14 04:34:46 Atascosa, Texas, US
177770 2020-07-13 US Kansas Atchison 20005 44 0 0 44 39.53185661 -95.30870026 2020-07-14 04:34:46 Atchison, Kansas, US
177771 2020-07-13 US Missouri Atchison 29005 6 0 0 6 40.43238737 -95.42970639 2020-07-14 04:34:46 Atchison, Missouri, US
177772 2020-07-13 US Ohio Athens 39009 192 1 0 191 39.33425634 -82.04278644 2020-07-14 04:34:46 Athens, Ohio, US
177773 2020-07-13 US Georgia Atkinson 13003 196 2 0 194 31.29633502 -82.87545866 2020-07-14 04:34:46 Atkinson, Georgia, US
177774 2020-07-13 US New Jersey Atlantic 34001 3023 232 0 2791 39.47538693 -74.65848483 2020-07-14 04:34:46 Atlantic, New Jersey, US
177775 2020-07-13 US Oklahoma Atoka 40005 34 0 0 34 34.37366573 -96.03802487 2020-07-14 04:34:46 Atoka, Oklahoma, US
Powered by Datasette · Query took 93.968ms · About: simonw/covid-19-datasette