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

34,980 rows where province_or_state = "North Carolina" sorted by day descending

View and edit SQL

province_or_state

  • North Carolina · 34,980

country_or_region

  • US 34,980
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
955597 2021-03-05 US North Carolina Alamance 37001 15888 230 0 15658 36.0434701 -79.39976137 2021-03-06 04:23:41 Alamance, North Carolina, US
955598 2021-03-05 US North Carolina Alexander 37003 3947 76 0 3871 35.922379600000006 -81.17751948 2021-03-06 04:23:41 Alexander, North Carolina, US
955599 2021-03-05 US North Carolina Alleghany 37005 920 5 0 915 36.49360862 -81.12857041 2021-03-06 04:23:41 Alleghany, North Carolina, US
955600 2021-03-05 US North Carolina Anson 37007 2316 52 0 2264 34.97403241 -80.09953279 2021-03-06 04:23:41 Anson, North Carolina, US
955601 2021-03-05 US North Carolina Ashe 37009 1888 40 0 1848 36.43296207 -81.49862729 2021-03-06 04:23:41 Ashe, North Carolina, US
955602 2021-03-05 US North Carolina Avery 37011 1848 20 0 1828 36.07569796 -81.92308483 2021-03-06 04:23:41 Avery, North Carolina, US
955603 2021-03-05 US North Carolina Beaufort 37013 4281 82 0 4199 35.48531943 -76.84325809 2021-03-06 04:23:41 Beaufort, North Carolina, US
955604 2021-03-05 US North Carolina Bertie 37015 1662 41 0 1621 36.0688473 -76.96545943 2021-03-06 04:23:41 Bertie, North Carolina, US
955605 2021-03-05 US North Carolina Bladen 37017 2973 40 0 2933 34.61296243 -78.56180059 2021-03-06 04:23:41 Bladen, North Carolina, US
955606 2021-03-05 US North Carolina Brunswick 37019 8084 137 0 7947 34.070565 -78.22814204 2021-03-06 04:23:41 Brunswick, North Carolina, US
955607 2021-03-05 US North Carolina Buncombe 37021 15726 293 0 15433 35.61113393 -82.53305 2021-03-06 04:23:41 Buncombe, North Carolina, US
955608 2021-03-05 US North Carolina Burke 37023 9275 141 0 9134 35.74989637 -81.70755735 2021-03-06 04:23:41 Burke, North Carolina, US
955609 2021-03-05 US North Carolina Cabarrus 37025 18689 236 0 18453 35.3877799 -80.55267168 2021-03-06 04:23:41 Cabarrus, North Carolina, US
955610 2021-03-05 US North Carolina Caldwell 37027 8692 78 0 8614 35.95204977 -81.54799522 2021-03-06 04:23:41 Caldwell, North Carolina, US
955611 2021-03-05 US North Carolina Camden 37029 594 5 0 589 36.33804939 -76.15568396 2021-03-06 04:23:41 Camden, North Carolina, US
955612 2021-03-05 US North Carolina Carteret 37031 4473 44 0 4429 34.8932941 -76.54120135 2021-03-06 04:23:41 Carteret, North Carolina, US
955613 2021-03-05 US North Carolina Caswell 37033 1989 24 0 1965 36.39312665 -79.33353281 2021-03-06 04:23:41 Caswell, North Carolina, US
955614 2021-03-05 US North Carolina Catawba 37035 17567 285 0 17282 35.66211129 -81.2132617 2021-03-06 04:23:41 Catawba, North Carolina, US
955615 2021-03-05 US North Carolina Chatham 37037 4162 78 0 4084 35.70394416 -79.25541492 2021-03-06 04:23:41 Chatham, North Carolina, US
955616 2021-03-05 US North Carolina Cherokee 37039 2129 19 0 2110 35.1349263 -84.05970864 2021-03-06 04:23:41 Cherokee, North Carolina, US
955617 2021-03-05 US North Carolina Chowan 37041 1382 22 0 1360 36.12908077 -76.60118385 2021-03-06 04:23:41 Chowan, North Carolina, US
955618 2021-03-05 US North Carolina Clay 37043 660 18 0 642 35.05704275 -83.74353633 2021-03-06 04:23:41 Clay, North Carolina, US
955619 2021-03-05 US North Carolina Cleveland 37045 10389 217 0 10172 35.33553364 -81.55204486 2021-03-06 04:23:41 Cleveland, North Carolina, US
955620 2021-03-05 US North Carolina Columbus 37047 5921 147 0 5774 34.26744084 -78.65801424 2021-03-06 04:23:41 Columbus, North Carolina, US
955621 2021-03-05 US North Carolina Craven 37049 8410 115 0 8295 35.11833364 -77.08398081 2021-03-06 04:23:41 Craven, North Carolina, US
955622 2021-03-05 US North Carolina Cumberland 37051 24411 280 0 24131 35.04762133 -78.82623165 2021-03-06 04:23:41 Cumberland, North Carolina, US
955623 2021-03-05 US North Carolina Currituck 37053 1392 15 0 1377 36.36123664 -75.95876401 2021-03-06 04:23:41 Currituck, North Carolina, US
955624 2021-03-05 US North Carolina Dare 37055 1866 8 0 1858 35.66520691 -75.71767334 2021-03-06 04:23:41 Dare, North Carolina, US
955625 2021-03-05 US North Carolina Davidson 37057 14725 164 0 14561 35.79115496 -80.21256572 2021-03-06 04:23:41 Davidson, North Carolina, US
955626 2021-03-05 US North Carolina Davie 37059 3563 31 0 3532 35.93099927 -80.54496571 2021-03-06 04:23:41 Davie, North Carolina, US
955627 2021-03-05 US North Carolina Duplin 37061 5757 128 0 5629 34.93449805 -77.93140529 2021-03-06 04:23:41 Duplin, North Carolina, US
955628 2021-03-05 US North Carolina Durham 37063 21717 206 0 21511 36.03638492 -78.87608331 2021-03-06 04:23:41 Durham, North Carolina, US
955629 2021-03-05 US North Carolina Edgecombe 37065 4719 100 0 4619 35.91230639 -77.59436892 2021-03-06 04:23:41 Edgecombe, North Carolina, US
955630 2021-03-05 US North Carolina Forsyth 37067 32132 345 0 31787 36.12859861 -80.25459052 2021-03-06 04:23:41 Forsyth, North Carolina, US
955631 2021-03-05 US North Carolina Franklin 37069 5495 45 0 5450 36.081519 -78.28708884 2021-03-06 04:23:41 Franklin, North Carolina, US
955632 2021-03-05 US North Carolina Gaston 37071 23938 377 0 23561 35.29373559 -81.17477045 2021-03-06 04:23:41 Gaston, North Carolina, US
955633 2021-03-05 US North Carolina Gates 37073 677 12 0 665 36.44667547 -76.69749701 2021-03-06 04:23:41 Gates, North Carolina, US
955634 2021-03-05 US North Carolina Graham 37075 566 12 0 554 35.3506925 -83.83369267 2021-03-06 04:23:41 Graham, North Carolina, US
955635 2021-03-05 US North Carolina Granville 37077 5280 76 0 5204 36.30337451 -78.65184241 2021-03-06 04:23:41 Granville, North Carolina, US
955636 2021-03-05 US North Carolina Greene 37079 2142 39 0 2103 35.48544173 -77.67578087 2021-03-06 04:23:41 Greene, North Carolina, US
955637 2021-03-05 US North Carolina Guilford 37081 40361 557 0 39804 36.07959451 -79.78824948 2021-03-06 04:23:41 Guilford, North Carolina, US
955638 2021-03-05 US North Carolina Halifax 37083 5021 97 0 4924 36.25669272 -77.6556109 2021-03-06 04:23:41 Halifax, North Carolina, US
955639 2021-03-05 US North Carolina Harnett 37085 9797 155 0 9642 35.36731853 -78.87243571 2021-03-06 04:23:41 Harnett, North Carolina, US
955640 2021-03-05 US North Carolina Haywood 37087 3882 86 0 3796 35.55269063 -82.98196486 2021-03-06 04:23:41 Haywood, North Carolina, US
955641 2021-03-05 US North Carolina Henderson 37089 8965 149 0 8816 35.33788927 -82.4766782 2021-03-06 04:23:41 Henderson, North Carolina, US
955642 2021-03-05 US North Carolina Hertford 37091 1963 61 0 1902 36.3607755 -76.98104134 2021-03-06 04:23:41 Hertford, North Carolina, US
955643 2021-03-05 US North Carolina Hoke 37093 4158 54 0 4104 35.01888303 -79.23651674 2021-03-06 04:23:41 Hoke, North Carolina, US
955644 2021-03-05 US North Carolina Hyde 37095 628 8 0 620 35.42017674 -76.15180542 2021-03-06 04:23:41 Hyde, North Carolina, US
955645 2021-03-05 US North Carolina Iredell 37097 16620 194 0 16426 35.80950511 -80.8743128 2021-03-06 04:23:41 Iredell, North Carolina, US
955646 2021-03-05 US North Carolina Jackson 37099 3369 54 0 3315 35.28814273 -83.14093385 2021-03-06 04:23:41 Jackson, North Carolina, US
955647 2021-03-05 US North Carolina Johnston 37101 18167 197 0 17970 35.51745004 -78.36622717 2021-03-06 04:23:41 Johnston, North Carolina, US
955648 2021-03-05 US North Carolina Jones 37103 734 16 0 718 35.02254606 -77.35870791 2021-03-06 04:23:41 Jones, North Carolina, US
955649 2021-03-05 US North Carolina Lee 37105 5497 72 0 5425 35.47623147 -79.17569362 2021-03-06 04:23:41 Lee, North Carolina, US
955650 2021-03-05 US North Carolina Lenoir 37107 5485 106 0 5379 35.24032589999999 -77.64245615 2021-03-06 04:23:41 Lenoir, North Carolina, US
955651 2021-03-05 US North Carolina Lincoln 37109 8885 71 0 8814 35.48508185 -81.21740317 2021-03-06 04:23:41 Lincoln, North Carolina, US
955652 2021-03-05 US North Carolina Macon 37113 2583 28 0 2555 35.14867843 -83.41696617 2021-03-06 04:23:41 Macon, North Carolina, US
955653 2021-03-05 US North Carolina Madison 37115 1369 39 0 1330 35.85402722 -82.71346418 2021-03-06 04:23:41 Madison, North Carolina, US
955654 2021-03-05 US North Carolina Martin 37117 2087 37 0 2050 35.84326734 -77.10860251 2021-03-06 04:23:41 Martin, North Carolina, US
955655 2021-03-05 US North Carolina McDowell 37111 4864 61 0 4803 35.67736232 -82.0482425 2021-03-06 04:23:41 McDowell, North Carolina, US
955656 2021-03-05 US North Carolina Mecklenburg 37119 97767 874 0 96893 35.24469268 -80.8317671 2021-03-06 04:23:41 Mecklenburg, North Carolina, US
955657 2021-03-05 US North Carolina Mitchell 37121 1245 16 0 1229 36.01059309 -82.1582442 2021-03-06 04:23:41 Mitchell, North Carolina, US
955658 2021-03-05 US North Carolina Montgomery 37123 3092 88 0 3004 35.33155144 -79.90416657 2021-03-06 04:23:41 Montgomery, North Carolina, US
955659 2021-03-05 US North Carolina Moore 37125 8056 177 0 7879 35.30885257 -79.48474178 2021-03-06 04:23:41 Moore, North Carolina, US
955660 2021-03-05 US North Carolina Nash 37127 9837 172 0 9665 35.96575634 -77.98422508 2021-03-06 04:23:41 Nash, North Carolina, US
955661 2021-03-05 US North Carolina New Hanover 37129 16416 152 0 16264 34.25758282 -77.87075626 2021-03-06 04:23:41 New Hanover, North Carolina, US
955662 2021-03-05 US North Carolina Northampton 37131 1725 33 0 1692 36.41736238 -77.39769443 2021-03-06 04:23:41 Northampton, North Carolina, US
955663 2021-03-05 US North Carolina Onslow 37133 14807 134 0 14673 34.72607366 -77.42908179 2021-03-06 04:23:41 Onslow, North Carolina, US
955664 2021-03-05 US North Carolina Orange 37135 7817 95 0 7722 36.06092947 -79.12167935 2021-03-06 04:23:41 Orange, North Carolina, US
955665 2021-03-05 US North Carolina Pamlico 37137 973 10 0 963 35.15253315 -76.66559823 2021-03-06 04:23:41 Pamlico, North Carolina, US
955666 2021-03-05 US North Carolina Pasquotank 37139 3086 78 0 3008 36.26723798 -76.25134778 2021-03-06 04:23:41 Pasquotank, North Carolina, US
955667 2021-03-05 US North Carolina Pender 37141 4751 60 0 4691 34.52265624 -77.90352133 2021-03-06 04:23:41 Pender, North Carolina, US
955668 2021-03-05 US North Carolina Perquimans 37143 923 8 0 915 36.17847453 -76.40603143 2021-03-06 04:23:41 Perquimans, North Carolina, US
955669 2021-03-05 US North Carolina Person 37145 3028 64 0 2964 36.38989032 -78.97217358 2021-03-06 04:23:41 Person, North Carolina, US
955670 2021-03-05 US North Carolina Pitt 37147 17665 83 0 17582 35.59535426 -77.37353178 2021-03-06 04:23:41 Pitt, North Carolina, US
955671 2021-03-05 US North Carolina Polk 37149 1361 27 0 1334 35.27820615 -82.16812354 2021-03-06 04:23:41 Polk, North Carolina, US
955672 2021-03-05 US North Carolina Randolph 37151 13436 205 0 13231 35.71015088 -79.80570339 2021-03-06 04:23:41 Randolph, North Carolina, US
955673 2021-03-05 US North Carolina Richmond 37153 4238 89 0 4149 35.00417719 -79.74491009 2021-03-06 04:23:41 Richmond, North Carolina, US
955674 2021-03-05 US North Carolina Robeson 37155 15310 212 0 15098 34.64244496 -79.10250529999998 2021-03-06 04:23:41 Robeson, North Carolina, US
955675 2021-03-05 US North Carolina Rockingham 37157 6889 61 0 6828 36.39593137 -79.77504841 2021-03-06 04:23:41 Rockingham, North Carolina, US
955676 2021-03-05 US North Carolina Rowan 37159 15004 289 0 14715 35.64003916 -80.52446628 2021-03-06 04:23:41 Rowan, North Carolina, US
955677 2021-03-05 US North Carolina Rutherford 37161 6781 200 0 6581 35.40114178 -81.92112099 2021-03-06 04:23:41 Rutherford, North Carolina, US
955678 2021-03-05 US North Carolina Sampson 37163 6921 92 0 6829 34.98820368 -78.36914061 2021-03-06 04:23:41 Sampson, North Carolina, US
955679 2021-03-05 US North Carolina Scotland 37165 3505 76 0 3429 34.8386299 -79.4757978 2021-03-06 04:23:41 Scotland, North Carolina, US
955680 2021-03-05 US North Carolina Stanly 37167 6904 111 0 6793 35.31647813 -80.25093221 2021-03-06 04:23:41 Stanly, North Carolina, US
955681 2021-03-05 US North Carolina Stokes 37169 3688 74 0 3614 36.4017975 -80.23893369 2021-03-06 04:23:41 Stokes, North Carolina, US
955682 2021-03-05 US North Carolina Surry 37171 7426 140 0 7286 36.41689489 -80.69102283 2021-03-06 04:23:41 Surry, North Carolina, US
955683 2021-03-05 US North Carolina Swain 37173 1169 16 0 1153 35.48665845 -83.48748932 2021-03-06 04:23:41 Swain, North Carolina, US
955684 2021-03-05 US North Carolina Transylvania 37175 1940 27 0 1913 35.20383864 -82.79638423 2021-03-06 04:23:41 Transylvania, North Carolina, US
955685 2021-03-05 US North Carolina Tyrrell 37177 305 6 0 299 35.87147226 -76.17055253 2021-03-06 04:23:41 Tyrrell, North Carolina, US
955686 2021-03-05 US North Carolina Unassigned 90037 1 0 0 1 36.49360862 0.0 2021-03-06 04:23:41 Unassigned, North Carolina, US
955687 2021-03-05 US North Carolina Union 37179 20980 200 0 20780 34.98960527 -80.52955873 2021-03-06 04:23:41 Union, North Carolina, US
955688 2021-03-05 US North Carolina Vance 37181 4406 81 0 4325 36.36880673 -78.40670845 2021-03-06 04:23:41 Vance, North Carolina, US
955689 2021-03-05 US North Carolina Wake 37183 75405 541 0 74864 35.78879266 -78.65249174 2021-03-06 04:23:41 Wake, North Carolina, US
955690 2021-03-05 US North Carolina Warren 37185 1608 18 0 1590 36.39728256 -78.10652228 2021-03-06 04:23:41 Warren, North Carolina, US
955691 2021-03-05 US North Carolina Washington 37187 997 31 0 966 35.83810081 -76.57299037 2021-03-06 04:23:41 Washington, North Carolina, US
955692 2021-03-05 US North Carolina Watauga 37189 4003 30 0 3973 36.23103603 -81.70033724 2021-03-06 04:23:41 Watauga, North Carolina, US
955693 2021-03-05 US North Carolina Wayne 37191 10324 225 0 10099 35.36438125 -78.00027268 2021-03-06 04:23:41 Wayne, North Carolina, US
955694 2021-03-05 US North Carolina Wilkes 37193 6043 104 0 5939 36.2084135 -81.16232895 2021-03-06 04:23:41 Wilkes, North Carolina, US
955695 2021-03-05 US North Carolina Wilson 37195 8520 150 0 8370 35.70625477 -77.917978 2021-03-06 04:23:41 Wilson, North Carolina, US
955696 2021-03-05 US North Carolina Yadkin 37197 3666 46 0 3620 36.16222629 -80.66239436 2021-03-06 04:23:41 Yadkin, North Carolina, 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]);