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

14,275 rows where province_or_state = "North Carolina" sorted by day descending

View and edit SQL

province_or_state

  • North Carolina · 14,275

country_or_region

  • US 14,275
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
136312 2020-08-12 US North Carolina Alamance 37001 2526 41 0 2485 36.0434701 -79.39976137 2020-08-13 04:29:15 Alamance, North Carolina, US
136313 2020-08-12 US North Carolina Alexander 37003 314 2 0 312 35.922379600000006 -81.17751948 2020-08-13 04:29:15 Alexander, North Carolina, US
136314 2020-08-12 US North Carolina Alleghany 37005 170 0 0 170 36.49360862 -81.12857041 2020-08-13 04:29:15 Alleghany, North Carolina, US
136315 2020-08-12 US North Carolina Anson 37007 339 3 0 336 34.97403241 -80.09953279 2020-08-13 04:29:15 Anson, North Carolina, US
136316 2020-08-12 US North Carolina Ashe 37009 166 1 0 165 36.43296207 -81.49862729 2020-08-13 04:29:15 Ashe, North Carolina, US
136317 2020-08-12 US North Carolina Avery 37011 109 0 0 109 36.07569796 -81.92308483 2020-08-13 04:29:15 Avery, North Carolina, US
136318 2020-08-12 US North Carolina Beaufort 37013 437 2 0 435 35.48531943 -76.84325809 2020-08-13 04:29:15 Beaufort, North Carolina, US
136319 2020-08-12 US North Carolina Bertie 37015 287 5 0 282 36.0688473 -76.96545943 2020-08-13 04:29:15 Bertie, North Carolina, US
136320 2020-08-12 US North Carolina Bladen 37017 627 7 0 620 34.61296243 -78.56180059 2020-08-13 04:29:15 Bladen, North Carolina, US
136321 2020-08-12 US North Carolina Brunswick 37019 1273 22 0 1251 34.070565 -78.22814204 2020-08-13 04:29:15 Brunswick, North Carolina, US
136322 2020-08-12 US North Carolina Buncombe 37021 1929 50 0 1879 35.61113393 -82.53305 2020-08-13 04:29:15 Buncombe, North Carolina, US
136323 2020-08-12 US North Carolina Burke 37023 1776 28 0 1748 35.74989637 -81.70755735 2020-08-13 04:29:15 Burke, North Carolina, US
136324 2020-08-12 US North Carolina Cabarrus 37025 2681 50 0 2631 35.3877799 -80.55267168 2020-08-13 04:29:15 Cabarrus, North Carolina, US
136325 2020-08-12 US North Carolina Caldwell 37027 1234 16 0 1218 35.95204977 -81.54799522 2020-08-13 04:29:15 Caldwell, North Carolina, US
136326 2020-08-12 US North Carolina Camden 37029 75 2 0 73 36.33804939 -76.15568396 2020-08-13 04:29:15 Camden, North Carolina, US
136327 2020-08-12 US North Carolina Carteret 37031 376 6 0 370 34.8932941 -76.54120135 2020-08-13 04:29:15 Carteret, North Carolina, US
136328 2020-08-12 US North Carolina Caswell 37033 196 2 0 194 36.39312665 -79.33353281 2020-08-13 04:29:15 Caswell, North Carolina, US
136329 2020-08-12 US North Carolina Catawba 37035 2180 30 0 2150 35.66211129 -81.2132617 2020-08-13 04:29:15 Catawba, North Carolina, US
136330 2020-08-12 US North Carolina Chatham 37037 1308 55 0 1253 35.70394416 -79.25541492 2020-08-13 04:29:15 Chatham, North Carolina, US
136331 2020-08-12 US North Carolina Cherokee 37039 296 4 0 292 35.1349263 -84.05970864 2020-08-13 04:29:15 Cherokee, North Carolina, US
136332 2020-08-12 US North Carolina Chowan 37041 158 2 0 156 36.12908077 -76.60118385 2020-08-13 04:29:15 Chowan, North Carolina, US
136333 2020-08-12 US North Carolina Clay 37043 76 0 0 76 35.05704275 -83.74353633 2020-08-13 04:29:15 Clay, North Carolina, US
136334 2020-08-12 US North Carolina Cleveland 37045 1217 22 0 1195 35.33553364 -81.55204486 2020-08-13 04:29:15 Cleveland, North Carolina, US
136335 2020-08-12 US North Carolina Columbus 37047 931 48 0 883 34.26744084 -78.65801424 2020-08-13 04:29:15 Columbus, North Carolina, US
136336 2020-08-12 US North Carolina Craven 37049 753 15 0 738 35.11833364 -77.08398081 2020-08-13 04:29:15 Craven, North Carolina, US
136337 2020-08-12 US North Carolina Cumberland 37051 3286 54 0 3232 35.04762133 -78.82623165 2020-08-13 04:29:15 Cumberland, North Carolina, US
136338 2020-08-12 US North Carolina Currituck 37053 77 0 0 77 36.36123664 -75.95876401 2020-08-13 04:29:15 Currituck, North Carolina, US
136339 2020-08-12 US North Carolina Dare 37055 210 2 0 208 35.66520691 -75.71767334 2020-08-13 04:29:15 Dare, North Carolina, US
136340 2020-08-12 US North Carolina Davidson 37057 1817 18 0 1799 35.79115496 -80.21256572 2020-08-13 04:29:15 Davidson, North Carolina, US
136341 2020-08-12 US North Carolina Davie 37059 431 7 0 424 35.93099927 -80.54496571 2020-08-13 04:29:15 Davie, North Carolina, US
136342 2020-08-12 US North Carolina Duplin 37061 2015 48 0 1967 34.93449805 -77.93140529 2020-08-13 04:29:15 Duplin, North Carolina, US
136343 2020-08-12 US North Carolina Durham 37063 6231 80 0 6151 36.03638492 -78.87608331 2020-08-13 04:29:15 Durham, North Carolina, US
136344 2020-08-12 US North Carolina Edgecombe 37065 672 13 0 659 35.91230639 -77.59436892 2020-08-13 04:29:15 Edgecombe, North Carolina, US
136345 2020-08-12 US North Carolina Forsyth 37067 5381 53 0 5328 36.12859861 -80.25459052 2020-08-13 04:29:15 Forsyth, North Carolina, US
136346 2020-08-12 US North Carolina Franklin 37069 891 26 0 865 36.081519 -78.28708884 2020-08-13 04:29:15 Franklin, North Carolina, US
136347 2020-08-12 US North Carolina Gaston 37071 3392 55 0 3337 35.29373559 -81.17477045 2020-08-13 04:29:15 Gaston, North Carolina, US
136348 2020-08-12 US North Carolina Gates 37073 47 2 0 45 36.44667547 -76.69749701 2020-08-13 04:29:15 Gates, North Carolina, US
136349 2020-08-12 US North Carolina Graham 37075 43 0 0 43 35.3506925 -83.83369267 2020-08-13 04:29:15 Graham, North Carolina, US
136350 2020-08-12 US North Carolina Granville 37077 1278 29 0 1249 36.30337451 -78.65184241 2020-08-13 04:29:15 Granville, North Carolina, US
136351 2020-08-12 US North Carolina Greene 37079 333 3 0 330 35.48544173 -77.67578087 2020-08-13 04:29:15 Greene, North Carolina, US
136352 2020-08-12 US North Carolina Guilford 37081 5753 156 0 5597 36.07959451 -79.78824948 2020-08-13 04:29:15 Guilford, North Carolina, US
136353 2020-08-12 US North Carolina Halifax 37083 721 6 0 715 36.25669272 -77.6556109 2020-08-13 04:29:15 Halifax, North Carolina, US
136354 2020-08-12 US North Carolina Harnett 37085 1337 40 0 1297 35.36731853 -78.87243571 2020-08-13 04:29:15 Harnett, North Carolina, US
136355 2020-08-12 US North Carolina Haywood 37087 441 15 0 426 35.55269063 -82.98196486 2020-08-13 04:29:15 Haywood, North Carolina, US
136356 2020-08-12 US North Carolina Henderson 37089 1505 55 0 1450 35.33788927 -82.4766782 2020-08-13 04:29:15 Henderson, North Carolina, US
136357 2020-08-12 US North Carolina Hertford 37091 358 11 0 347 36.3607755 -76.98104134 2020-08-13 04:29:15 Hertford, North Carolina, US
136358 2020-08-12 US North Carolina Hoke 37093 738 11 0 727 35.01888303 -79.23651674 2020-08-13 04:29:15 Hoke, North Carolina, US
136359 2020-08-12 US North Carolina Hyde 37095 46 0 0 46 35.42017674 -76.15180542 2020-08-13 04:29:15 Hyde, North Carolina, US
136360 2020-08-12 US North Carolina Iredell 37097 1905 18 0 1887 35.80950511 -80.8743128 2020-08-13 04:29:15 Iredell, North Carolina, US
136361 2020-08-12 US North Carolina Jackson 37099 457 7 0 450 35.28814273 -83.14093385 2020-08-13 04:29:15 Jackson, North Carolina, US
136362 2020-08-12 US North Carolina Johnston 37101 3357 46 0 3311 35.51745004 -78.36622717 2020-08-13 04:29:15 Johnston, North Carolina, US
136363 2020-08-12 US North Carolina Jones 37103 99 8 0 91 35.02254606 -77.35870791 2020-08-13 04:29:15 Jones, North Carolina, US
136364 2020-08-12 US North Carolina Lee 37105 1306 11 0 1295 35.47623147 -79.17569362 2020-08-13 04:29:15 Lee, North Carolina, US
136365 2020-08-12 US North Carolina Lenoir 37107 599 12 0 587 35.24032589999999 -77.64245615 2020-08-13 04:29:15 Lenoir, North Carolina, US
136366 2020-08-12 US North Carolina Lincoln 37109 869 10 0 859 35.48508185 -81.21740317 2020-08-13 04:29:15 Lincoln, North Carolina, US
136367 2020-08-12 US North Carolina Macon 37113 480 4 0 476 35.14867843 -83.41696617 2020-08-13 04:29:15 Macon, North Carolina, US
136368 2020-08-12 US North Carolina Madison 37115 49 0 0 49 35.85402722 -82.71346418 2020-08-13 04:29:15 Madison, North Carolina, US
136369 2020-08-12 US North Carolina Martin 37117 268 6 0 262 35.84326734 -77.10860251 2020-08-13 04:29:15 Martin, North Carolina, US
136370 2020-08-12 US North Carolina McDowell 37111 690 16 0 674 35.67736232 -82.0482425 2020-08-13 04:29:15 McDowell, North Carolina, US
136371 2020-08-12 US North Carolina Mecklenburg 37119 22612 243 0 22369 35.24469268 -80.8317671 2020-08-13 04:29:15 Mecklenburg, North Carolina, US
136372 2020-08-12 US North Carolina Mitchell 37121 120 3 0 117 36.01059309 -82.1582442 2020-08-13 04:29:15 Mitchell, North Carolina, US
136373 2020-08-12 US North Carolina Montgomery 37123 740 14 0 726 35.33155144 -79.90416657 2020-08-13 04:29:15 Montgomery, North Carolina, US
136374 2020-08-12 US North Carolina Moore 37125 1031 20 0 1011 35.30885257 -79.48474178 2020-08-13 04:29:15 Moore, North Carolina, US
136375 2020-08-12 US North Carolina Nash 37127 1220 12 0 1208 35.96575634 -77.98422508 2020-08-13 04:29:15 Nash, North Carolina, US
136376 2020-08-12 US North Carolina New Hanover 37129 2696 20 0 2676 34.25758282 -77.87075626 2020-08-13 04:29:15 New Hanover, North Carolina, US
136377 2020-08-12 US North Carolina Northampton 37131 351 16 0 335 36.41736238 -77.39769443 2020-08-13 04:29:15 Northampton, North Carolina, US
136378 2020-08-12 US North Carolina Onslow 37133 1138 11 0 1127 34.72607366 -77.42908179 2020-08-13 04:29:15 Onslow, North Carolina, US
136379 2020-08-12 US North Carolina Orange 37135 1361 58 0 1303 36.06092947 -79.12167935 2020-08-13 04:29:15 Orange, North Carolina, US
136380 2020-08-12 US North Carolina Pamlico 37137 73 1 0 72 35.15253315 -76.66559823 2020-08-13 04:29:15 Pamlico, North Carolina, US
136381 2020-08-12 US North Carolina Pasquotank 37139 423 20 0 403 36.26723798 -76.25134778 2020-08-13 04:29:15 Pasquotank, North Carolina, US
136382 2020-08-12 US North Carolina Pender 37141 669 3 0 666 34.52265624 -77.90352133 2020-08-13 04:29:15 Pender, North Carolina, US
136383 2020-08-12 US North Carolina Perquimans 37143 88 2 0 86 36.17847453 -76.40603143 2020-08-13 04:29:15 Perquimans, North Carolina, US
136384 2020-08-12 US North Carolina Person 37145 228 2 0 226 36.38989032 -78.97217358 2020-08-13 04:29:15 Person, North Carolina, US
136385 2020-08-12 US North Carolina Pitt 37147 2105 11 0 2094 35.59535426 -77.37353178 2020-08-13 04:29:15 Pitt, North Carolina, US
136386 2020-08-12 US North Carolina Polk 37149 164 6 0 158 35.27820615 -82.16812354 2020-08-13 04:29:15 Polk, North Carolina, US
136387 2020-08-12 US North Carolina Randolph 37151 2199 38 0 2161 35.71015088 -79.80570339 2020-08-13 04:29:15 Randolph, North Carolina, US
136388 2020-08-12 US North Carolina Richmond 37153 524 9 0 515 35.00417719 -79.74491009 2020-08-13 04:29:15 Richmond, North Carolina, US
136389 2020-08-12 US North Carolina Robeson 37155 2854 55 0 2799 34.64244496 -79.10250529999998 2020-08-13 04:29:15 Robeson, North Carolina, US
136390 2020-08-12 US North Carolina Rockingham 37157 567 8 0 559 36.39593137 -79.77504841 2020-08-13 04:29:15 Rockingham, North Carolina, US
136391 2020-08-12 US North Carolina Rowan 37159 2248 49 0 2199 35.64003916 -80.52446628 2020-08-13 04:29:15 Rowan, North Carolina, US
136392 2020-08-12 US North Carolina Rutherford 37161 781 15 0 766 35.40114178 -81.92112099 2020-08-13 04:29:15 Rutherford, North Carolina, US
136393 2020-08-12 US North Carolina Sampson 37163 1511 18 0 1493 34.98820368 -78.36914061 2020-08-13 04:29:15 Sampson, North Carolina, US
136394 2020-08-12 US North Carolina Scotland 37165 374 5 0 369 34.8386299 -79.4757978 2020-08-13 04:29:15 Scotland, North Carolina, US
136395 2020-08-12 US North Carolina Stanly 37167 1103 31 0 1072 35.31647813 -80.25093221 2020-08-13 04:29:15 Stanly, North Carolina, US
136396 2020-08-12 US North Carolina Stokes 37169 296 3 0 293 36.4017975 -80.23893369 2020-08-13 04:29:15 Stokes, North Carolina, US
136397 2020-08-12 US North Carolina Surry 37171 967 10 0 957 36.41689489 -80.69102283 2020-08-13 04:29:15 Surry, North Carolina, US
136398 2020-08-12 US North Carolina Swain 37173 121 2 0 119 35.48665845 -83.48748932 2020-08-13 04:29:15 Swain, North Carolina, US
136399 2020-08-12 US North Carolina Transylvania 37175 145 1 0 144 35.20383864 -82.79638423 2020-08-13 04:29:15 Transylvania, North Carolina, US
136400 2020-08-12 US North Carolina Tyrrell 37177 99 1 0 98 35.87147226 -76.17055253 2020-08-13 04:29:15 Tyrrell, North Carolina, US
136401 2020-08-12 US North Carolina Unassigned 90037 0 0 0 0 36.49360862 0.0 2020-08-13 04:29:15 Unassigned, North Carolina, US
136402 2020-08-12 US North Carolina Union 37179 3170 43 0 3127 34.98960527 -80.52955873 2020-08-13 04:29:15 Union, North Carolina, US
136403 2020-08-12 US North Carolina Vance 37181 787 41 0 746 36.36880673 -78.40670845 2020-08-13 04:29:15 Vance, North Carolina, US
136404 2020-08-12 US North Carolina Wake 37183 12263 178 0 12085 35.78879266 -78.65249174 2020-08-13 04:29:15 Wake, North Carolina, US
136405 2020-08-12 US North Carolina Warren 37185 261 7 0 254 36.39728256 -78.10652228 2020-08-13 04:29:15 Warren, North Carolina, US
136406 2020-08-12 US North Carolina Washington 37187 136 4 0 132 35.83810081 -76.57299037 2020-08-13 04:29:15 Washington, North Carolina, US
136407 2020-08-12 US North Carolina Watauga 37189 316 0 0 316 36.23103603 -81.70033724 2020-08-13 04:29:15 Watauga, North Carolina, US
136408 2020-08-12 US North Carolina Wayne 37191 2445 42 0 2403 35.36438125 -78.00027268 2020-08-13 04:29:15 Wayne, North Carolina, US
136409 2020-08-12 US North Carolina Wilkes 37193 852 12 0 840 36.2084135 -81.16232895 2020-08-13 04:29:15 Wilkes, North Carolina, US
136410 2020-08-12 US North Carolina Wilson 37195 1514 35 0 1479 35.70625477 -77.917978 2020-08-13 04:29:15 Wilson, North Carolina, US
136411 2020-08-12 US North Carolina Yadkin 37197 557 6 0 551 36.16222629 -80.66239436 2020-08-13 04:29:15 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]);
Powered by Datasette · Query took 2195.398ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette