ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,809 rows where state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37183 591
- 37037 588
- 37025 582
- 37067 582
- 37101 582
- 37119 582
- 37133 582
- 37191 581
- 37019 580
- 37049 580
- 37085 580
- 37189 579
- 37195 579
- 37063 578
- 37097 577
- 37163 577
- 37071 576
- 37081 576
- 37093 576
- 37109 576
- 37125 576
- 37129 576
- 37031 574
- 37057 574
- 37069 574
- 37135 574
- 37139 574
- 37147 574
- 37159 574
- 37167 574
- …
county >30
- Wake 591
- Chatham 588
- Cabarrus 582
- Forsyth 582
- Johnston 582
- Mecklenburg 582
- Onslow 582
- Wayne 581
- Brunswick 580
- Craven 580
- Harnett 580
- Watauga 579
- Wilson 579
- Durham 578
- Iredell 577
- Sampson 577
- Gaston 576
- Guilford 576
- Hoke 576
- Lincoln 576
- Moore 576
- New Hanover 576
- Carteret 574
- Davidson 574
- Franklin 574
- Orange 574
- Pasquotank 574
- Pitt 574
- Rowan 574
- Stanly 574
- …
state 1
- North Carolina · 56,709 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1815271 | 1815271 | 2021-10-14 | Alamance | North Carolina | 37001 | 25839 | 332 |
1815272 | 1815272 | 2021-10-14 | Alexander | North Carolina | 37003 | 6342 | 112 |
1815273 | 1815273 | 2021-10-14 | Alleghany | North Carolina | 37005 | 1589 | 5 |
1815274 | 1815274 | 2021-10-14 | Anson | North Carolina | 37007 | 3769 | 77 |
1815275 | 1815275 | 2021-10-14 | Ashe | North Carolina | 37009 | 3372 | 48 |
1815276 | 1815276 | 2021-10-14 | Avery | North Carolina | 37011 | 2675 | 32 |
1815277 | 1815277 | 2021-10-14 | Beaufort | North Carolina | 37013 | 6921 | 124 |
1815278 | 1815278 | 2021-10-14 | Bertie | North Carolina | 37015 | 2432 | 49 |
1815279 | 1815279 | 2021-10-14 | Bladen | North Carolina | 37017 | 5395 | 94 |
1815280 | 1815280 | 2021-10-14 | Brunswick | North Carolina | 37019 | 15915 | 229 |
1815281 | 1815281 | 2021-10-14 | Buncombe | North Carolina | 37021 | 27410 | 421 |
1815282 | 1815282 | 2021-10-14 | Burke | North Carolina | 37023 | 15425 | 212 |
1815283 | 1815283 | 2021-10-14 | Cabarrus | North Carolina | 37025 | 32215 | 325 |
1815284 | 1815284 | 2021-10-14 | Caldwell | North Carolina | 37027 | 13004 | 204 |
1815285 | 1815285 | 2021-10-14 | Camden | North Carolina | 37029 | 1080 | 8 |
1815286 | 1815286 | 2021-10-14 | Carteret | North Carolina | 37031 | 8167 | 81 |
1815287 | 1815287 | 2021-10-14 | Caswell | North Carolina | 37033 | 3134 | 37 |
1815288 | 1815288 | 2021-10-14 | Catawba | North Carolina | 37035 | 27822 | 409 |
1815289 | 1815289 | 2021-10-14 | Chatham | North Carolina | 37037 | 6639 | 91 |
1815290 | 1815290 | 2021-10-14 | Cherokee | North Carolina | 37039 | 4602 | 74 |
1815291 | 1815291 | 2021-10-14 | Chowan | North Carolina | 37041 | 2244 | 40 |
1815292 | 1815292 | 2021-10-14 | Clay | North Carolina | 37043 | 1627 | 35 |
1815293 | 1815293 | 2021-10-14 | Cleveland | North Carolina | 37045 | 17991 | 299 |
1815294 | 1815294 | 2021-10-14 | Columbus | North Carolina | 37047 | 9881 | 221 |
1815295 | 1815295 | 2021-10-14 | Craven | North Carolina | 37049 | 14026 | 152 |
1815296 | 1815296 | 2021-10-14 | Cumberland | North Carolina | 37051 | 43989 | 451 |
1815297 | 1815297 | 2021-10-14 | Currituck | North Carolina | 37053 | 2650 | 25 |
1815298 | 1815298 | 2021-10-14 | Dare | North Carolina | 37055 | 3677 | 12 |
1815299 | 1815299 | 2021-10-14 | Davidson | North Carolina | 37057 | 25308 | 296 |
1815300 | 1815300 | 2021-10-14 | Davie | North Carolina | 37059 | 6269 | 70 |
1815301 | 1815301 | 2021-10-14 | Duplin | North Carolina | 37061 | 9774 | 176 |
1815302 | 1815302 | 2021-10-14 | Durham | North Carolina | 37063 | 34392 | 256 |
1815303 | 1815303 | 2021-10-14 | Edgecombe | North Carolina | 37065 | 7805 | 124 |
1815304 | 1815304 | 2021-10-14 | Forsyth | North Carolina | 37067 | 50639 | 539 |
1815305 | 1815305 | 2021-10-14 | Franklin | North Carolina | 37069 | 9674 | 60 |
1815306 | 1815306 | 2021-10-14 | Gaston | North Carolina | 37071 | 39208 | 593 |
1815307 | 1815307 | 2021-10-14 | Gates | North Carolina | 37073 | 1056 | 18 |
1815308 | 1815308 | 2021-10-14 | Graham | North Carolina | 37075 | 1306 | 27 |
1815309 | 1815309 | 2021-10-14 | Granville | North Carolina | 37077 | 7775 | 99 |
1815310 | 1815310 | 2021-10-14 | Greene | North Carolina | 37079 | 3251 | 55 |
1815311 | 1815311 | 2021-10-14 | Guilford | North Carolina | 37081 | 66300 | 855 |
1815312 | 1815312 | 2021-10-14 | Halifax | North Carolina | 37083 | 7715 | 133 |
1815313 | 1815313 | 2021-10-14 | Harnett | North Carolina | 37085 | 18009 | 248 |
1815314 | 1815314 | 2021-10-14 | Haywood | North Carolina | 37087 | 7237 | 138 |
1815315 | 1815315 | 2021-10-14 | Henderson | North Carolina | 37089 | 14869 | 195 |
1815316 | 1815316 | 2021-10-14 | Hertford | North Carolina | 37091 | 2765 | 70 |
1815317 | 1815317 | 2021-10-14 | Hoke | North Carolina | 37093 | 6991 | 78 |
1815318 | 1815318 | 2021-10-14 | Hyde | North Carolina | 37095 | 822 | 12 |
1815319 | 1815319 | 2021-10-14 | Iredell | North Carolina | 37097 | 28210 | 313 |
1815320 | 1815320 | 2021-10-14 | Jackson | North Carolina | 37099 | 5516 | 70 |
1815321 | 1815321 | 2021-10-14 | Johnston | North Carolina | 37101 | 31743 | 316 |
1815322 | 1815322 | 2021-10-14 | Jones | North Carolina | 37103 | 1296 | 29 |
1815323 | 1815323 | 2021-10-14 | Lee | North Carolina | 37105 | 9285 | 105 |
1815324 | 1815324 | 2021-10-14 | Lenoir | North Carolina | 37107 | 9355 | 148 |
1815325 | 1815325 | 2021-10-14 | Lincoln | North Carolina | 37109 | 14635 | 107 |
1815326 | 1815326 | 2021-10-14 | Macon | North Carolina | 37113 | 4848 | 54 |
1815327 | 1815327 | 2021-10-14 | Madison | North Carolina | 37115 | 2711 | 57 |
1815328 | 1815328 | 2021-10-14 | Martin | North Carolina | 37117 | 3570 | 65 |
1815329 | 1815329 | 2021-10-14 | McDowell | North Carolina | 37111 | 8446 | 121 |
1815330 | 1815330 | 2021-10-14 | Mecklenburg | North Carolina | 37119 | 154435 | 1205 |
1815331 | 1815331 | 2021-10-14 | Mitchell | North Carolina | 37121 | 1979 | 18 |
1815332 | 1815332 | 2021-10-14 | Montgomery | North Carolina | 37123 | 4427 | 108 |
1815333 | 1815333 | 2021-10-14 | Moore | North Carolina | 37125 | 13375 | 245 |
1815334 | 1815334 | 2021-10-14 | Nash | North Carolina | 37127 | 15094 | 225 |
1815335 | 1815335 | 2021-10-14 | New Hanover | North Carolina | 37129 | 28286 | 281 |
1815336 | 1815336 | 2021-10-14 | Northampton | North Carolina | 37131 | 2557 | 62 |
1815337 | 1815337 | 2021-10-14 | Onslow | North Carolina | 37133 | 27932 | 246 |
1815338 | 1815338 | 2021-10-14 | Orange | North Carolina | 37135 | 11574 | 109 |
1815339 | 1815339 | 2021-10-14 | Pamlico | North Carolina | 37137 | 1678 | 24 |
1815340 | 1815340 | 2021-10-14 | Pasquotank | North Carolina | 37139 | 4970 | 101 |
1815341 | 1815341 | 2021-10-14 | Pender | North Carolina | 37141 | 8695 | 97 |
1815342 | 1815342 | 2021-10-14 | Perquimans | North Carolina | 37143 | 1488 | 15 |
1815343 | 1815343 | 2021-10-14 | Person | North Carolina | 37145 | 5026 | 87 |
1815344 | 1815344 | 2021-10-14 | Pitt | North Carolina | 37147 | 29150 | 138 |
1815345 | 1815345 | 2021-10-14 | Polk | North Carolina | 37149 | 2266 | 44 |
1815346 | 1815346 | 2021-10-14 | Randolph | North Carolina | 37151 | 21251 | 302 |
1815347 | 1815347 | 2021-10-14 | Richmond | North Carolina | 37153 | 6999 | 134 |
1815348 | 1815348 | 2021-10-14 | Robeson | North Carolina | 37155 | 24661 | 420 |
1815349 | 1815349 | 2021-10-14 | Rockingham | North Carolina | 37157 | 11657 | 192 |
1815350 | 1815350 | 2021-10-14 | Rowan | North Carolina | 37159 | 25827 | 433 |
1815351 | 1815351 | 2021-10-14 | Rutherford | North Carolina | 37161 | 11160 | 302 |
1815352 | 1815352 | 2021-10-14 | Sampson | North Carolina | 37163 | 11040 | 129 |
1815353 | 1815353 | 2021-10-14 | Scotland | North Carolina | 37165 | 5628 | 106 |
1815354 | 1815354 | 2021-10-14 | Stanly | North Carolina | 37167 | 11393 | 179 |
1815355 | 1815355 | 2021-10-14 | Stokes | North Carolina | 37169 | 6033 | 103 |
1815356 | 1815356 | 2021-10-14 | Surry | North Carolina | 37171 | 12024 | 220 |
1815357 | 1815357 | 2021-10-14 | Swain | North Carolina | 37173 | 1930 | 22 |
1815358 | 1815358 | 2021-10-14 | Transylvania | North Carolina | 37175 | 3834 | 48 |
1815359 | 1815359 | 2021-10-14 | Tyrrell | North Carolina | 37177 | 538 | 7 |
1815360 | 1815360 | 2021-10-14 | Union | North Carolina | 37179 | 35570 | 323 |
1815361 | 1815361 | 2021-10-14 | Vance | North Carolina | 37181 | 6611 | 97 |
1815362 | 1815362 | 2021-10-14 | Wake | North Carolina | 37183 | 128440 | 881 |
1815363 | 1815363 | 2021-10-14 | Warren | North Carolina | 37185 | 2318 | 28 |
1815364 | 1815364 | 2021-10-14 | Washington | North Carolina | 37187 | 1559 | 37 |
1815365 | 1815365 | 2021-10-14 | Watauga | North Carolina | 37189 | 6460 | 38 |
1815366 | 1815366 | 2021-10-14 | Wayne | North Carolina | 37191 | 15585 | 297 |
1815367 | 1815367 | 2021-10-14 | Wilkes | North Carolina | 37193 | 10370 | 174 |
1815368 | 1815368 | 2021-10-14 | Wilson | North Carolina | 37195 | 12987 | 226 |
1815369 | 1815369 | 2021-10-14 | Yadkin | North Carolina | 37197 | 5874 | 70 |
1815370 | 1815370 | 2021-10-14 | Yancey | North Carolina | 37199 | 2750 | 29 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);