daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

7,205 rows where province_or_state = "North Carolina" sorted by day descending

View and edit SQL

province_or_state

  • North Carolina · 7,205

country_or_region

  • US 7,205
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-03 US North Carolina Alamance 37001 413 29 0 384 36.0434701 -79.39976137 2020-06-04 02:33:14 Alamance, North Carolina, US
2020-06-03 US North Carolina Alexander 37003 38 0 0 38 35.922379600000006 -81.17751948 2020-06-04 02:33:14 Alexander, North Carolina, US
2020-06-03 US North Carolina Alleghany 37005 24 0 0 24 36.49360862 -81.12857041 2020-06-04 02:33:14 Alleghany, North Carolina, US
2020-06-03 US North Carolina Anson 37007 68 1 0 67 34.97403241 -80.09953279 2020-06-04 02:33:14 Anson, North Carolina, US
2020-06-03 US North Carolina Ashe 37009 37 0 0 37 36.43296207 -81.49862729 2020-06-04 02:33:14 Ashe, North Carolina, US
2020-06-03 US North Carolina Avery 37011 2 0 0 2 36.07569796 -81.92308483 2020-06-04 02:33:14 Avery, North Carolina, US
2020-06-03 US North Carolina Beaufort 37013 36 0 0 36 35.48531943 -76.84325809 2020-06-04 02:33:14 Beaufort, North Carolina, US
2020-06-03 US North Carolina Bertie 37015 126 4 0 122 36.0688473 -76.96545943 2020-06-04 02:33:14 Bertie, North Carolina, US
2020-06-03 US North Carolina Bladen 37017 106 2 0 104 34.61296243 -78.56180059 2020-06-04 02:33:14 Bladen, North Carolina, US
2020-06-03 US North Carolina Brunswick 37019 110 3 0 107 34.070565 -78.22814204 2020-06-04 02:33:14 Brunswick, North Carolina, US
2020-06-03 US North Carolina Buncombe 37021 361 30 0 331 35.61113393 -82.53305 2020-06-04 02:33:14 Buncombe, North Carolina, US
2020-06-03 US North Carolina Burke 37023 477 16 0 461 35.74989637 -81.70755735 2020-06-04 02:33:14 Burke, North Carolina, US
2020-06-03 US North Carolina Cabarrus 37025 511 22 0 489 35.3877799 -80.55267168 2020-06-04 02:33:14 Cabarrus, North Carolina, US
2020-06-03 US North Carolina Caldwell 37027 161 3 0 158 35.95204977 -81.54799522 2020-06-04 02:33:14 Caldwell, North Carolina, US
2020-06-03 US North Carolina Camden 37029 3 0 0 3 36.33804939 -76.15568396 2020-06-04 02:33:14 Camden, North Carolina, US
2020-06-03 US North Carolina Carteret 37031 37 9 0 28 34.8932941 -76.54120135 2020-06-04 02:33:14 Carteret, North Carolina, US
2020-06-03 US North Carolina Caswell 37033 94 1 0 93 36.39312665 -79.33353281 2020-06-04 02:33:14 Caswell, North Carolina, US
2020-06-03 US North Carolina Catawba 37035 255 9 0 246 35.66211129 -81.2132617 2020-06-04 02:33:14 Catawba, North Carolina, US
2020-06-03 US North Carolina Chatham 37037 660 27 0 633 35.70394416 -79.25541492 2020-06-04 02:33:14 Chatham, North Carolina, US
2020-06-03 US North Carolina Cherokee 37039 30 1 0 29 35.1349263 -84.05970864 2020-06-04 02:33:14 Cherokee, North Carolina, US
2020-06-03 US North Carolina Chowan 37041 17 0 0 17 36.12908077 -76.60118385 2020-06-04 02:33:14 Chowan, North Carolina, US
2020-06-03 US North Carolina Clay 37043 8 0 0 8 35.05704275 -83.74353633 2020-06-04 02:33:14 Clay, North Carolina, US
2020-06-03 US North Carolina Cleveland 37045 109 2 0 107 35.33553364 -81.55204486 2020-06-04 02:33:14 Cleveland, North Carolina, US
2020-06-03 US North Carolina Columbus 37047 349 27 0 322 34.26744084 -78.65801424 2020-06-04 02:33:14 Columbus, North Carolina, US
2020-06-03 US North Carolina Craven 37049 210 5 0 205 35.11833364 -77.08398081 2020-06-04 02:33:14 Craven, North Carolina, US
2020-06-03 US North Carolina Cumberland 37051 721 25 0 696 35.04762133 -78.82623165 2020-06-04 02:33:14 Cumberland, North Carolina, US
2020-06-03 US North Carolina Currituck 37053 14 0 0 14 36.36123664 -75.95876401 2020-06-04 02:33:14 Currituck, North Carolina, US
2020-06-03 US North Carolina Dare 37055 22 3 0 19 35.66520691 -75.71767334 2020-06-04 02:33:14 Dare, North Carolina, US
2020-06-03 US North Carolina Davidson 37057 446 13 0 433 35.79115496 -80.21256572 2020-06-04 02:33:14 Davidson, North Carolina, US
2020-06-03 US North Carolina Davie 37059 105 2 0 103 35.93099927 -80.54496571 2020-06-04 02:33:14 Davie, North Carolina, US
2020-06-03 US North Carolina Duplin 37061 890 20 0 870 34.93449805 -77.93140529 2020-06-04 02:33:14 Duplin, North Carolina, US
2020-06-03 US North Carolina Durham 37063 1828 49 0 1779 36.03638492 -78.87608331 2020-06-04 02:33:14 Durham, North Carolina, US
2020-06-03 US North Carolina Edgecombe 37065 210 9 0 201 35.91230639 -77.59436892 2020-06-04 02:33:14 Edgecombe, North Carolina, US
2020-06-03 US North Carolina Forsyth 37067 1517 14 0 1503 36.12859861 -80.25459052 2020-06-04 02:33:14 Forsyth, North Carolina, US
2020-06-03 US North Carolina Franklin 37069 167 22 0 145 36.081519 -78.28708884 2020-06-04 02:33:14 Franklin, North Carolina, US
2020-06-03 US North Carolina Gaston 37071 297 7 0 290 35.29373559 -81.17477045 2020-06-04 02:33:14 Gaston, North Carolina, US
2020-06-03 US North Carolina Gates 37073 24 1 0 23 36.44667547 -76.69749701 2020-06-04 02:33:14 Gates, North Carolina, US
2020-06-03 US North Carolina Graham 37075 2 0 0 2 35.3506925 -83.83369267 2020-06-04 02:33:14 Graham, North Carolina, US
2020-06-03 US North Carolina Granville 37077 324 11 0 313 36.30337451 -78.65184241 2020-06-04 02:33:14 Granville, North Carolina, US
2020-06-03 US North Carolina Greene 37079 81 2 0 79 35.48544173 -77.67578087 2020-06-04 02:33:14 Greene, North Carolina, US
2020-06-03 US North Carolina Guilford 37081 1415 71 0 1344 36.07959451 -79.78824948 2020-06-04 02:33:14 Guilford, North Carolina, US
2020-06-03 US North Carolina Halifax 37083 197 1 0 196 36.25669272 -77.6556109 2020-06-04 02:33:14 Halifax, North Carolina, US
2020-06-03 US North Carolina Harnett 37085 306 28 0 278 35.36731853 -78.87243571 2020-06-04 02:33:14 Harnett, North Carolina, US
2020-06-03 US North Carolina Haywood 37087 53 0 0 53 35.55269063 -82.98196486 2020-06-04 02:33:14 Haywood, North Carolina, US
2020-06-03 US North Carolina Henderson 37089 352 47 0 305 35.33788927 -82.4766782 2020-06-04 02:33:14 Henderson, North Carolina, US
2020-06-03 US North Carolina Hertford 37091 132 3 0 129 36.3607755 -76.98104134 2020-06-04 02:33:14 Hertford, North Carolina, US
2020-06-03 US North Carolina Hoke 37093 255 1 0 254 35.01888303 -79.23651674 2020-06-04 02:33:14 Hoke, North Carolina, US
2020-06-03 US North Carolina Hyde 37095 1 0 0 1 35.42017674 -76.15180542 2020-06-04 02:33:14 Hyde, North Carolina, US
2020-06-03 US North Carolina Iredell 37097 280 6 0 274 35.80950511 -80.8743128 2020-06-04 02:33:14 Iredell, North Carolina, US
2020-06-03 US North Carolina Jackson 37099 38 1 0 37 35.28814273 -83.14093385 2020-06-04 02:33:14 Jackson, North Carolina, US
2020-06-03 US North Carolina Johnston 37101 513 23 0 490 35.51745004 -78.36622717 2020-06-04 02:33:14 Johnston, North Carolina, US
2020-06-03 US North Carolina Jones 37103 28 3 0 25 35.02254606 -77.35870791 2020-06-04 02:33:14 Jones, North Carolina, US
2020-06-03 US North Carolina Lee 37105 486 4 0 482 35.47623147 -79.17569362 2020-06-04 02:33:14 Lee, North Carolina, US
2020-06-03 US North Carolina Lenoir 37107 222 7 0 215 35.24032589999999 -77.64245615 2020-06-04 02:33:14 Lenoir, North Carolina, US
2020-06-03 US North Carolina Lincoln 37109 78 0 0 78 35.48508185 -81.21740317 2020-06-04 02:33:14 Lincoln, North Carolina, US
2020-06-03 US North Carolina Macon 37113 89 1 0 88 35.14867843 -83.41696617 2020-06-04 02:33:14 Macon, North Carolina, US
2020-06-03 US North Carolina Madison 37115 4 0 0 4 35.85402722 -82.71346418 2020-06-04 02:33:14 Madison, North Carolina, US
2020-06-03 US North Carolina Martin 37117 74 4 0 70 35.84326734 -77.10860251 2020-06-04 02:33:14 Martin, North Carolina, US
2020-06-03 US North Carolina McDowell 37111 82 1 0 81 35.67736232 -82.0482425 2020-06-04 02:33:14 McDowell, North Carolina, US
2020-06-03 US North Carolina Mecklenburg 37119 4670 97 0 4573 35.24469268 -80.8317671 2020-06-04 02:33:14 Mecklenburg, North Carolina, US
2020-06-03 US North Carolina Mitchell 37121 15 0 0 15 36.01059309 -82.1582442 2020-06-04 02:33:14 Mitchell, North Carolina, US
2020-06-03 US North Carolina Montgomery 37123 162 5 0 157 35.33155144 -79.90416657 2020-06-04 02:33:14 Montgomery, North Carolina, US
2020-06-03 US North Carolina Moore 37125 235 10 0 225 35.30885257 -79.48474178 2020-06-04 02:33:14 Moore, North Carolina, US
2020-06-03 US North Carolina Nash 37127 213 4 0 209 35.96575634 -77.98422508 2020-06-04 02:33:14 Nash, North Carolina, US
2020-06-03 US North Carolina New Hanover 37129 225 5 0 220 34.25758282 -77.87075626 2020-06-04 02:33:14 New Hanover, North Carolina, US
2020-06-03 US North Carolina Northampton 37131 165 14 0 151 36.41736238 -77.39769443 2020-06-04 02:33:14 Northampton, North Carolina, US
2020-06-03 US North Carolina Onslow 37133 114 2 0 112 34.72607366 -77.42908179 2020-06-04 02:33:14 Onslow, North Carolina, US
2020-06-03 US North Carolina Orange 37135 364 40 0 324 36.06092947 -79.12167935 2020-06-04 02:33:14 Orange, North Carolina, US
2020-06-03 US North Carolina Pamlico 37137 10 0 0 10 35.15253315 -76.66559823 2020-06-04 02:33:14 Pamlico, North Carolina, US
2020-06-03 US North Carolina Pasquotank 37139 112 13 0 99 36.26723798 -76.25134778 2020-06-04 02:33:14 Pasquotank, North Carolina, US
2020-06-03 US North Carolina Pender 37141 93 1 0 92 34.52265624 -77.90352133 2020-06-04 02:33:14 Pender, North Carolina, US
2020-06-03 US North Carolina Perquimans 37143 25 2 0 23 36.17847453 -76.40603143 2020-06-04 02:33:14 Perquimans, North Carolina, US
2020-06-03 US North Carolina Person 37145 54 1 0 53 36.38989032 -78.97217358 2020-06-04 02:33:14 Person, North Carolina, US
2020-06-03 US North Carolina Pitt 37147 321 2 0 319 35.59535426 -77.37353178 2020-06-04 02:33:14 Pitt, North Carolina, US
2020-06-03 US North Carolina Polk 37149 39 4 0 35 35.27820615 -82.16812354 2020-06-04 02:33:14 Polk, North Carolina, US
2020-06-03 US North Carolina Randolph 37151 728 14 0 714 35.71015088 -79.80570339 2020-06-04 02:33:14 Randolph, North Carolina, US
2020-06-03 US North Carolina Richmond 37153 170 3 0 167 35.00417719 -79.74491009 2020-06-04 02:33:14 Richmond, North Carolina, US
2020-06-03 US North Carolina Robeson 37155 885 26 0 859 34.64244496 -79.10250529999998 2020-06-04 02:33:14 Robeson, North Carolina, US
2020-06-03 US North Carolina Rockingham 37157 102 2 0 100 36.39593137 -79.77504841 2020-06-04 02:33:14 Rockingham, North Carolina, US
2020-06-03 US North Carolina Rowan 37159 688 38 0 650 35.64003916 -80.52446628 2020-06-04 02:33:14 Rowan, North Carolina, US
2020-06-03 US North Carolina Rutherford 37161 186 7 0 179 35.40114178 -81.92112099 2020-06-04 02:33:14 Rutherford, North Carolina, US
2020-06-03 US North Carolina Sampson 37163 510 4 0 506 34.98820368 -78.36914061 2020-06-04 02:33:14 Sampson, North Carolina, US
2020-06-03 US North Carolina Scotland 37165 87 0 0 87 34.8386299 -79.4757978 2020-06-04 02:33:14 Scotland, North Carolina, US
2020-06-03 US North Carolina Stanly 37167 92 4 0 88 35.31647813 -80.25093221 2020-06-04 02:33:14 Stanly, North Carolina, US
2020-06-03 US North Carolina Stokes 37169 75 0 0 75 36.4017975 -80.23893369 2020-06-04 02:33:14 Stokes, North Carolina, US
2020-06-03 US North Carolina Surry 37171 231 2 0 229 36.41689489 -80.69102283 2020-06-04 02:33:14 Surry, North Carolina, US
2020-06-03 US North Carolina Swain 37173 21 0 0 21 35.48665845 -83.48748932 2020-06-04 02:33:14 Swain, North Carolina, US
2020-06-03 US North Carolina Transylvania 37175 15 0 0 15 35.20383864 -82.79638423 2020-06-04 02:33:14 Transylvania, North Carolina, US
2020-06-03 US North Carolina Tyrrell 37177 4 0 0 4 35.87147226 -76.17055253 2020-06-04 02:33:14 Tyrrell, North Carolina, US
2020-06-03 US North Carolina Unassigned 90037 0 0 0 0 36.49360862 0.0 2020-06-04 02:33:14 Unassigned, North Carolina, US
2020-06-03 US North Carolina Union 37179 506 21 0 485 34.98960527 -80.52955873 2020-06-04 02:33:14 Union, North Carolina, US
2020-06-03 US North Carolina Vance 37181 337 23 0 314 36.36880673 -78.40670845 2020-06-04 02:33:14 Vance, North Carolina, US
2020-06-03 US North Carolina Wake 37183 1901 40 0 1861 35.78879266 -78.65249174 2020-06-04 02:33:14 Wake, North Carolina, US
2020-06-03 US North Carolina Warren 37185 70 2 0 68 36.39728256 -78.10652228 2020-06-04 02:33:14 Warren, North Carolina, US
2020-06-03 US North Carolina Washington 37187 32 3 0 29 35.83810081 -76.57299037 2020-06-04 02:33:14 Washington, North Carolina, US
2020-06-03 US North Carolina Watauga 37189 31 0 0 31 36.23103603 -81.70033724 2020-06-04 02:33:14 Watauga, North Carolina, US
2020-06-03 US North Carolina Wayne 37191 1188 20 0 1168 35.36438125 -78.00027268 2020-06-04 02:33:14 Wayne, North Carolina, US
2020-06-03 US North Carolina Wilkes 37193 500 6 0 494 36.2084135 -81.16232895 2020-06-04 02:33:14 Wilkes, North Carolina, US
2020-06-03 US North Carolina Wilson 37195 384 11 0 373 35.70625477 -77.917978 2020-06-04 02:33:14 Wilson, North Carolina, US
2020-06-03 US North Carolina Yadkin 37197 203 3 0 200 36.16222629 -80.66239436 2020-06-04 02:33:14 Yadkin, North Carolina, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 2116.956ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette