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

507,912 rows sorted by day descending

View and edit SQL

These facets timed out: 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
154545 2020-07-31 US South Carolina Abbeville 45001 282 7 0 275 34.22333378 -82.46170658 2020-08-01 04:36:27 Abbeville, South Carolina, US
154546 2020-07-31 US Louisiana Acadia 22001 2331 71 0 2260 30.295064899999996 -92.41419698 2020-08-01 04:36:27 Acadia, Louisiana, US
154547 2020-07-31 US Virginia Accomack 51001 1074 15 0 1059 37.76707161 -75.63234615 2020-08-01 04:36:27 Accomack, Virginia, US
154548 2020-07-31 US Idaho Ada 16001 7828 60 0 7768 43.4526575 -116.24155159999998 2020-08-01 04:36:27 Ada, Idaho, US
154549 2020-07-31 US Iowa Adair 19001 20 0 0 20 41.33075609 -94.47105874 2020-08-01 04:36:27 Adair, Iowa, US
154550 2020-07-31 US Kentucky Adair 21001 201 19 0 182 37.10459774 -85.28129668 2020-08-01 04:36:27 Adair, Kentucky, US
154551 2020-07-31 US Missouri Adair 29001 132 0 0 132 40.19058551 -92.60078167 2020-08-01 04:36:27 Adair, Missouri, US
154552 2020-07-31 US Oklahoma Adair 40001 283 5 0 278 35.88494195 -94.65859267 2020-08-01 04:36:27 Adair, Oklahoma, US
154553 2020-07-31 US Colorado Adams 8001 5957 171 0 5786 39.87432092 -104.3362578 2020-08-01 04:36:27 Adams, Colorado, US
154554 2020-07-31 US Idaho Adams 16003 18 0 0 18 44.89333571 -116.4545247 2020-08-01 04:36:27 Adams, Idaho, US
154555 2020-07-31 US Illinois Adams 17001 393 1 0 392 39.98815591 -91.18786813 2020-08-01 04:36:27 Adams, Illinois, US
154556 2020-07-31 US Indiana Adams 18001 74 2 0 72 40.7457653 -84.93671406 2020-08-01 04:36:27 Adams, Indiana, US
154557 2020-07-31 US Iowa Adams 19003 15 0 0 15 41.02903567 -94.69932645 2020-08-01 04:36:27 Adams, Iowa, US
154558 2020-07-31 US Mississippi Adams 28001 565 23 0 542 31.47669768 -91.35326037 2020-08-01 04:36:27 Adams, Mississippi, US
154559 2020-07-31 US Nebraska Adams 31001 339 11 0 328 40.52449420000001 -98.50117804 2020-08-01 04:36:27 Adams, Nebraska, US
154560 2020-07-31 US North Dakota Adams 38001 2 0 0 2 46.09686891 -102.5285397 2020-08-01 04:36:27 Adams, North Dakota, US
154561 2020-07-31 US Ohio Adams 39001 53 2 0 51 38.84541072 -83.4718964 2020-08-01 04:36:27 Adams, Ohio, US
154562 2020-07-31 US Pennsylvania Adams 42001 462 20 0 442 39.87140411 -77.21610347 2020-08-01 04:36:27 Adams, Pennsylvania, US
154563 2020-07-31 US Washington Adams 53001 374 3 0 371 46.98299757 -118.5601734 2020-08-01 04:36:27 Adams, Washington, US
154564 2020-07-31 US Wisconsin Adams 55001 69 2 0 67 43.96974651 -89.76782777 2020-08-01 04:36:27 Adams, Wisconsin, US
154565 2020-07-31 US Vermont Addison 50001 71 2 0 69 44.03217337 -73.14130877 2020-08-01 04:36:27 Addison, Vermont, US
154566 2020-07-31 US Puerto Rico Adjuntas 72001 82 0 0 82 18.180117000000006 -66.754367 2020-08-01 04:36:27 Adjuntas, Puerto Rico, US
154567 2020-07-31 US Puerto Rico Aguada 72003 99 0 0 99 18.360255 -67.17513100000001 2020-08-01 04:36:27 Aguada, Puerto Rico, US
154568 2020-07-31 US Puerto Rico Aguadilla 72005 168 0 0 168 18.459681 -67.12081500000001 2020-08-01 04:36:27 Aguadilla, Puerto Rico, US
154569 2020-07-31 US Puerto Rico Aguas Buenas 72007 102 0 0 102 18.251619 -66.126806 2020-08-01 04:36:27 Aguas Buenas, Puerto Rico, US
154570 2020-07-31 US Puerto Rico Aibonito 72009 73 0 0 73 18.131361 -66.264131 2020-08-01 04:36:27 Aibonito, Puerto Rico, US
154571 2020-07-31 US South Carolina Aiken 45003 1491 24 0 1467 33.54338026 -81.63645384 2020-08-01 04:36:27 Aiken, South Carolina, US
154572 2020-07-31 US Minnesota Aitkin 27001 27 0 0 27 46.60962049 -93.4116826 2020-08-01 04:36:27 Aitkin, Minnesota, US
154573 2020-07-31 US Florida Alachua 12001 3526 21 0 3505 29.67866525 -82.35928158 2020-08-01 04:36:27 Alachua, Florida, US
154574 2020-07-31 US North Carolina Alamance 37001 2148 41 0 2107 36.0434701 -79.39976137 2020-08-01 04:36:27 Alamance, North Carolina, US
154575 2020-07-31 US California Alameda 6001 11139 182 0 10957 37.64629437 -121.8929271 2020-08-01 04:36:27 Alameda, California, US
154576 2020-07-31 US Colorado Alamosa 8003 224 9 0 215 37.57250606 -105.7885451 2020-08-01 04:36:27 Alamosa, Colorado, US
154577 2020-07-31 US New York Albany 36001 2503 126 0 2377 42.60060306 -73.97723916 2020-08-01 04:36:27 Albany, New York, US
154578 2020-07-31 US Wyoming Albany 56001 84 0 0 84 41.65498705 -105.7235415 2020-08-01 04:36:27 Albany, Wyoming, US
154579 2020-07-31 US Virginia Albemarle 51003 735 11 0 724 38.02080697 -78.55481085 2020-08-01 04:36:27 Albemarle, Virginia, US
154580 2020-07-31 US Michigan Alcona 26001 28 1 0 27 44.6846864 -83.59507875 2020-08-01 04:36:27 Alcona, Michigan, US
154581 2020-07-31 US Mississippi Alcorn 28003 335 3 0 332 34.88084463 -88.57996173 2020-08-01 04:36:27 Alcorn, Mississippi, US
154582 2020-07-31 US Alaska Aleutians East 2013 1 0 0 1 55.32222414 -161.9722021 2020-08-01 04:36:27 Aleutians East, Alaska, US
154583 2020-07-31 US Alaska Aleutians West 2016 5 0 0 5 52.3233 -174.1596 2020-08-01 04:36:27 Aleutians West, Alaska, US
154584 2020-07-31 US Illinois Alexander 17003 35 0 0 35 37.18049267 -89.32910838 2020-08-01 04:36:27 Alexander, Illinois, US
154585 2020-07-31 US North Carolina Alexander 37003 295 2 0 293 35.922379600000006 -81.17751948 2020-08-01 04:36:27 Alexander, North Carolina, US
154586 2020-07-31 US Virginia Alexandria 51510 2798 58 0 2740 38.814003 -77.08183073 2020-08-01 04:36:27 Alexandria, Virginia, US
154587 2020-07-31 US Oklahoma Alfalfa 40003 4 0 0 4 36.73090616 -98.32408495 2020-08-01 04:36:27 Alfalfa, Oklahoma, US
154588 2020-07-31 US Michigan Alger 26003 8 0 0 8 46.41292944 -86.60260122 2020-08-01 04:36:27 Alger, Michigan, US
154589 2020-07-31 US Iowa Allamakee 19005 148 4 0 144 43.28383218 -91.37860922 2020-08-01 04:36:27 Allamakee, Iowa, US
154590 2020-07-31 US Michigan Allegan 26005 495 7 0 488 42.59147037 -85.89102866 2020-08-01 04:36:27 Allegan, Michigan, US
154591 2020-07-31 US Maryland Allegany 24001 266 18 0 248 39.62357628 -78.69280486 2020-08-01 04:36:27 Allegany, Maryland, US
154592 2020-07-31 US New York Allegany 36003 74 1 0 73 42.25748406 -78.02750466 2020-08-01 04:36:27 Allegany, New York, US
154593 2020-07-31 US North Carolina Alleghany 37005 67 0 0 67 36.49360862 -81.12857041 2020-08-01 04:36:27 Alleghany, North Carolina, US
154594 2020-07-31 US Virginia Alleghany 51005 56 3 0 53 37.78636074 -80.00222498 2020-08-01 04:36:27 Alleghany, Virginia, US
154595 2020-07-31 US Pennsylvania Allegheny 42003 8094 230 0 7864 40.46809875 -79.98167747 2020-08-01 04:36:27 Allegheny, Pennsylvania, US
154596 2020-07-31 US Indiana Allen 18003 3509 157 0 3352 41.09194313 -85.06800636 2020-08-01 04:36:27 Allen, Indiana, US
154597 2020-07-31 US Kansas Allen 20001 14 0 0 14 37.88582951 -95.30030847 2020-08-01 04:36:27 Allen, Kansas, US
154598 2020-07-31 US Kentucky Allen 21003 216 8 0 208 36.75197631 -86.19457544 2020-08-01 04:36:27 Allen, Kentucky, US
154599 2020-07-31 US Louisiana Allen 22003 1036 19 0 1017 30.65385745 -92.82442028 2020-08-01 04:36:27 Allen, Louisiana, US
154600 2020-07-31 US Ohio Allen 39003 628 42 0 586 40.77285242 -84.10802343 2020-08-01 04:36:27 Allen, Ohio, US
154601 2020-07-31 US South Carolina Allendale 45005 173 3 0 170 32.98837386 -81.35321066 2020-08-01 04:36:27 Allendale, South Carolina, US
154602 2020-07-31 US Michigan Alpena 26007 125 13 0 112 45.03477666 -83.62212411 2020-08-01 04:36:27 Alpena, Michigan, US
154603 2020-07-31 US California Alpine 6003 2 0 0 2 38.59678594 -119.8223594 2020-08-01 04:36:27 Alpine, California, US
154604 2020-07-31 US California Amador 6005 115 0 0 115 38.44583082 -120.65696 2020-08-01 04:36:27 Amador, California, US
154605 2020-07-31 US Virginia Amelia 51007 72 1 0 71 37.34081025 -77.98584649 2020-08-01 04:36:27 Amelia, Virginia, US
154606 2020-07-31 US Virginia Amherst 51009 105 0 0 105 37.60308293 -79.14548696 2020-08-01 04:36:27 Amherst, Virginia, US
154607 2020-07-31 US Mississippi Amite 28005 193 4 0 189 31.17467303 -90.80501621 2020-08-01 04:36:27 Amite, Mississippi, US
154608 2020-07-31 US Puerto Rico Anasco 72011 108 0 0 108 18.287985 -67.120611 2020-08-01 04:36:27 Anasco, Puerto Rico, US
154609 2020-07-31 US Alaska Anchorage 2020 1659 11 0 1648 61.14998174 -149.14269860000005 2020-08-01 04:36:27 Anchorage, Alaska, US
154610 2020-07-31 US Kansas Anderson 20003 27 0 0 27 38.21413251 -95.29272815 2020-08-01 04:36:27 Anderson, Kansas, US
154611 2020-07-31 US Kentucky Anderson 21005 72 1 0 71 38.00671029 -84.99171713 2020-08-01 04:36:27 Anderson, Kentucky, US
154612 2020-07-31 US South Carolina Anderson 45007 1939 43 0 1896 34.51828081 -82.63959517 2020-08-01 04:36:27 Anderson, South Carolina, US
154613 2020-07-31 US Tennessee Anderson 47001 571 5 0 566 36.12684348 -84.19965764 2020-08-01 04:36:27 Anderson, Tennessee, US
154614 2020-07-31 US Texas Anderson 48001 2196 8 0 2188 31.81534745 -95.65354823 2020-08-01 04:36:27 Anderson, Texas, US
154615 2020-07-31 US Missouri Andrew 29003 81 1 0 80 39.98492163 -94.80163024 2020-08-01 04:36:27 Andrew, Missouri, US
154616 2020-07-31 US Texas Andrews 48003 255 6 0 249 32.30468633 -102.6376548 2020-08-01 04:36:27 Andrews, Texas, US
154617 2020-07-31 US Maine Androscoggin 23001 548 7 0 541 44.1664747 -70.20380627 2020-08-01 04:36:27 Androscoggin, Maine, US
154618 2020-07-31 US Texas Angelina 48005 1606 32 0 1574 31.25457347 -94.60901487 2020-08-01 04:36:27 Angelina, Texas, US
154619 2020-07-31 US Maryland Anne Arundel 24003 6770 216 0 6554 39.00670238 -76.60329337 2020-08-01 04:36:27 Anne Arundel, Maryland, US
154620 2020-07-31 US Minnesota Anoka 27003 3245 112 0 3133 45.27476015 -93.24604565 2020-08-01 04:36:27 Anoka, Minnesota, US
154621 2020-07-31 US North Carolina Anson 37007 301 2 0 299 34.97403241 -80.09953279 2020-08-01 04:36:27 Anson, North Carolina, US
154622 2020-07-31 US Nebraska Antelope 31003 18 1 0 17 42.17695516 -98.0666283 2020-08-01 04:36:27 Antelope, Nebraska, US
154623 2020-07-31 US Michigan Antrim 26009 36 0 0 36 44.99690221 -85.15503082 2020-08-01 04:36:27 Antrim, Michigan, US
154624 2020-07-31 US Arizona Apache 4001 2994 130 0 2864 35.39465006 -109.4892383 2020-08-01 04:36:27 Apache, Arizona, US
154625 2020-07-31 US Iowa Appanoose 19007 40 3 0 37 40.74324454 -92.86865906 2020-08-01 04:36:27 Appanoose, Iowa, US
154626 2020-07-31 US Georgia Appling 13001 555 16 0 539 31.74847232 -82.28909114 2020-08-01 04:36:27 Appling, Georgia, US
154627 2020-07-31 US Virginia Appomattox 51011 68 0 0 68 37.37569884 -78.81340003 2020-08-01 04:36:27 Appomattox, Virginia, US
154628 2020-07-31 US Texas Aransas 48007 153 12 0 141 28.10556197 -96.9995047 2020-08-01 04:36:27 Aransas, Texas, US
154629 2020-07-31 US Colorado Arapahoe 8005 6877 362 0 6515 39.64977461 -104.3353617 2020-08-01 04:36:27 Arapahoe, Colorado, US
154630 2020-07-31 US Texas Archer 48009 17 0 0 17 33.61569967 -98.68754589 2020-08-01 04:36:27 Archer, Texas, US
154631 2020-07-31 US Colorado Archuleta 8007 32 0 0 32 37.19474156 -107.04768670000001 2020-08-01 04:36:27 Archuleta, Colorado, US
154632 2020-07-31 US Puerto Rico Arecibo 72013 240 0 0 240 18.406631 -66.675077 2020-08-01 04:36:27 Arecibo, Puerto Rico, US
154633 2020-07-31 US Michigan Arenac 26011 40 3 0 37 44.0636262 -83.89277559 2020-08-01 04:36:27 Arenac, Michigan, US
154634 2020-07-31 US Arkansas Arkansas 5001 189 1 0 188 34.29145151 -91.37277296 2020-08-01 04:36:27 Arkansas, Arkansas, US
154635 2020-07-31 US Virginia Arlington 51013 2897 136 0 2761 38.8767675 -77.10139853 2020-08-01 04:36:27 Arlington, Virginia, US
154636 2020-07-31 US Pennsylvania Armstrong 42005 179 6 0 173 40.81665618 -79.46290811 2020-08-01 04:36:27 Armstrong, Pennsylvania, US
154637 2020-07-31 US Texas Armstrong 48011 5 0 0 5 34.96507426 -101.3574874 2020-08-01 04:36:27 Armstrong, Texas, US
154638 2020-07-31 US Maine Aroostook 23003 32 1 0 31 46.65926321 -68.59841248 2020-08-01 04:36:27 Aroostook, Maine, US
154639 2020-07-31 US Puerto Rico Arroyo 72015 76 0 0 76 17.998457000000005 -66.056546 2020-08-01 04:36:27 Arroyo, Puerto Rico, US
154640 2020-07-31 US Nebraska Arthur 31005 0 0 0 0 41.56896142 -101.6959559 2020-08-01 04:36:27 Arthur, Nebraska, US
154641 2020-07-31 US Louisiana Ascension 22005 2458 68 0 2390 30.20406249 -90.91328409999998 2020-08-01 04:36:27 Ascension, Louisiana, US
154642 2020-07-31 US North Carolina Ashe 37009 114 1 0 113 36.43296207 -81.49862729 2020-08-01 04:36:27 Ashe, North Carolina, US
154643 2020-07-31 US Ohio Ashland 39005 126 3 0 123 40.84772277 -82.27280781 2020-08-01 04:36:27 Ashland, Ohio, US
154644 2020-07-31 US Wisconsin Ashland 55003 15 0 0 15 46.31956891 -90.67837132 2020-08-01 04:36:27 Ashland, Wisconsin, 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
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
                ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
                ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
                ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
                ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Query took 2224.029ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette