ny_times_us_counties

⚠️ 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 license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

11,108 rows where state = "North Carolina" sorted by date descending

View and edit SQL

fips

county

state

  • North Carolina · 11,108
Link rowid date ▲ county state fips cases deaths
336242 2020-07-15 Alamance North Carolina 37001 1535 37
336243 2020-07-15 Alexander North Carolina 37003 186 1
336244 2020-07-15 Alleghany North Carolina 37005 44 0
336245 2020-07-15 Anson North Carolina 37007 218 1
336246 2020-07-15 Ashe North Carolina 37009 67 1
336247 2020-07-15 Avery North Carolina 37011 36 0
336248 2020-07-15 Beaufort North Carolina 37013 163 0
336249 2020-07-15 Bertie North Carolina 37015 161 4
336250 2020-07-15 Bladen North Carolina 37017 457 5
336251 2020-07-15 Brunswick North Carolina 37019 879 12
336252 2020-07-15 Buncombe North Carolina 37021 957 50
336253 2020-07-15 Burke North Carolina 37023 1245 21
336254 2020-07-15 Cabarrus North Carolina 37025 1754 33
336255 2020-07-15 Caldwell North Carolina 37027 685 6
336256 2020-07-15 Camden North Carolina 37029 42 1
336257 2020-07-15 Carteret North Carolina 37031 152 3
336258 2020-07-15 Caswell North Carolina 37033 156 2
336259 2020-07-15 Catawba North Carolina 37035 1327 14
336260 2020-07-15 Chatham North Carolina 37037 1072 46
336261 2020-07-15 Cherokee North Carolina 37039 91 2
336262 2020-07-15 Chowan North Carolina 37041 39 0
336263 2020-07-15 Clay North Carolina 37043 16 0
336264 2020-07-15 Cleveland North Carolina 37045 558 9
336265 2020-07-15 Columbus North Carolina 37047 650 39
336266 2020-07-15 Craven North Carolina 37049 483 8
336267 2020-07-15 Cumberland North Carolina 37051 1729 43
336268 2020-07-15 Currituck North Carolina 37053 33 0
336269 2020-07-15 Dare North Carolina 37055 226 1
336270 2020-07-15 Davidson North Carolina 37057 1296 16
336271 2020-07-15 Davie North Carolina 37059 259 3
336272 2020-07-15 Duplin North Carolina 37061 1720 33
336273 2020-07-15 Durham North Carolina 37063 4788 72
336274 2020-07-15 Edgecombe North Carolina 37065 409 9
336275 2020-07-15 Forsyth North Carolina 37067 3850 40
336276 2020-07-15 Franklin North Carolina 37069 533 22
336277 2020-07-15 Gaston North Carolina 37071 2003 17
336278 2020-07-15 Gates North Carolina 37073 31 2
336279 2020-07-15 Graham North Carolina 37075 10 0
336280 2020-07-15 Granville North Carolina 37077 974 25
336281 2020-07-15 Greene North Carolina 37079 238 3
336282 2020-07-15 Guilford North Carolina 37081 3840 129
336283 2020-07-15 Halifax North Carolina 37083 433 4
336284 2020-07-15 Harnett North Carolina 37085 815 32
336285 2020-07-15 Haywood North Carolina 37087 142 0
336286 2020-07-15 Henderson North Carolina 37089 982 51
336287 2020-07-15 Hertford North Carolina 37091 181 11
336288 2020-07-15 Hoke North Carolina 37093 482 4
336289 2020-07-15 Hyde North Carolina 37095 31 0
336290 2020-07-15 Iredell North Carolina 37097 1195 10
336291 2020-07-15 Jackson North Carolina 37099 221 3
336292 2020-07-15 Johnston North Carolina 37101 2218 38
336293 2020-07-15 Jones North Carolina 37103 39 3
336294 2020-07-15 Lee North Carolina 37105 952 8
336295 2020-07-15 Lenoir North Carolina 37107 439 11
336296 2020-07-15 Lincoln North Carolina 37109 473 2
336297 2020-07-15 Macon North Carolina 37113 337 1
336298 2020-07-15 Madison North Carolina 37115 18 0
336299 2020-07-15 Martin North Carolina 37117 173 6
336300 2020-07-15 McDowell North Carolina 37111 339 2
336301 2020-07-15 Mecklenburg North Carolina 37119 15950 169
336302 2020-07-15 Mitchell North Carolina 37121 57 1
336303 2020-07-15 Montgomery North Carolina 37123 417 9
336304 2020-07-15 Moore North Carolina 37125 653 14
336305 2020-07-15 Nash North Carolina 37127 686 6
336306 2020-07-15 New Hanover North Carolina 37129 1594 8
336307 2020-07-15 Northampton North Carolina 37131 200 16
336308 2020-07-15 Onslow North Carolina 37133 454 3
336309 2020-07-15 Orange North Carolina 37135 1015 43
336310 2020-07-15 Pamlico North Carolina 37137 39 1
336311 2020-07-15 Pasquotank North Carolina 37139 258 17
336312 2020-07-15 Pender North Carolina 37141 425 2
336313 2020-07-15 Perquimans North Carolina 37143 40 2
336314 2020-07-15 Person North Carolina 37145 135 1
336315 2020-07-15 Pitt North Carolina 37147 1000 6
336316 2020-07-15 Polk North Carolina 37149 101 4
336317 2020-07-15 Randolph North Carolina 37151 1580 33
336318 2020-07-15 Richmond North Carolina 37153 375 7
336319 2020-07-15 Robeson North Carolina 37155 1731 46
336320 2020-07-15 Rockingham North Carolina 37157 322 2
336321 2020-07-15 Rowan North Carolina 37159 1602 45
336322 2020-07-15 Rutherford North Carolina 37161 438 11
336323 2020-07-15 Sampson North Carolina 37163 1228 8
336324 2020-07-15 Scotland North Carolina 37165 177 2
336325 2020-07-15 Stanly North Carolina 37167 597 5
336326 2020-07-15 Stokes North Carolina 37169 176 1
336327 2020-07-15 Surry North Carolina 37171 604 3
336328 2020-07-15 Swain North Carolina 37173 73 1
336329 2020-07-15 Transylvania North Carolina 37175 61 1
336330 2020-07-15 Tyrrell North Carolina 37177 62 1
336331 2020-07-15 Union North Carolina 37179 2004 30
336332 2020-07-15 Vance North Carolina 37181 593 40
336333 2020-07-15 Wake North Carolina 37183 8096 83
336334 2020-07-15 Warren North Carolina 37185 193 6
336335 2020-07-15 Washington North Carolina 37187 54 3
336336 2020-07-15 Watauga North Carolina 37189 142 0
336337 2020-07-15 Wayne North Carolina 37191 2039 34
336338 2020-07-15 Wilkes North Carolina 37193 640 7
336339 2020-07-15 Wilson North Carolina 37195 1024 26
336340 2020-07-15 Yadkin North Carolina 37197 395 5
336341 2020-07-15 Yancey North Carolina 37199 63 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1893.107ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette