ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30,409 rows where state = "North Carolina" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 37183 328
- 37037 325
- 37025 319
- 37067 319
- 37101 319
- 37119 319
- 37133 319
- 37191 318
- 37019 317
- 37049 317
- 37085 317
- 37189 316
- 37195 316
- 37063 315
- 37097 314
- 37163 314
- 37071 313
- 37081 313
- 37093 313
- 37109 313
- 37125 313
- 37129 313
- 37031 311
- 37057 311
- 37069 311
- 37135 311
- 37139 311
- 37147 311
- 37159 311
- 37167 311
- ...
county
- Wake 328
- Chatham 325
- Cabarrus 319
- Forsyth 319
- Johnston 319
- Mecklenburg 319
- Onslow 319
- Wayne 318
- Brunswick 317
- Craven 317
- Harnett 317
- Watauga 316
- Wilson 316
- Durham 315
- Iredell 314
- Sampson 314
- Gaston 313
- Guilford 313
- Hoke 313
- Lincoln 313
- Moore 313
- New Hanover 313
- Carteret 311
- Davidson 311
- Franklin 311
- Orange 311
- Pasquotank 311
- Pitt 311
- Rowan 311
- Stanly 311
- ...
state
- North Carolina · 30,409 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 961366 | 961366 | 2021-01-24 | Alamance | North Carolina | 37001 | 13257 | 171 |
| 961367 | 961367 | 2021-01-24 | Alexander | North Carolina | 37003 | 3369 | 54 |
| 961368 | 961368 | 2021-01-24 | Alleghany | North Carolina | 37005 | 808 | 3 |
| 961369 | 961369 | 2021-01-24 | Anson | North Carolina | 37007 | 1929 | 40 |
| 961370 | 961370 | 2021-01-24 | Ashe | North Carolina | 37009 | 1634 | 33 |
| 961371 | 961371 | 2021-01-24 | Avery | North Carolina | 37011 | 1640 | 16 |
| 961372 | 961372 | 2021-01-24 | Beaufort | North Carolina | 37013 | 3636 | 69 |
| 961373 | 961373 | 2021-01-24 | Bertie | North Carolina | 37015 | 1480 | 27 |
| 961374 | 961374 | 2021-01-24 | Bladen | North Carolina | 37017 | 2465 | 30 |
| 961375 | 961375 | 2021-01-24 | Brunswick | North Carolina | 37019 | 6149 | 86 |
| 961376 | 961376 | 2021-01-24 | Buncombe | North Carolina | 37021 | 12662 | 257 |
| 961377 | 961377 | 2021-01-24 | Burke | North Carolina | 37023 | 8151 | 102 |
| 961378 | 961378 | 2021-01-24 | Cabarrus | North Carolina | 37025 | 15239 | 187 |
| 961379 | 961379 | 2021-01-24 | Caldwell | North Carolina | 37027 | 7595 | 34 |
| 961380 | 961380 | 2021-01-24 | Camden | North Carolina | 37029 | 440 | 5 |
| 961381 | 961381 | 2021-01-24 | Carteret | North Carolina | 37031 | 3610 | 19 |
| 961382 | 961382 | 2021-01-24 | Caswell | North Carolina | 37033 | 1628 | 11 |
| 961383 | 961383 | 2021-01-24 | Catawba | North Carolina | 37035 | 14889 | 227 |
| 961384 | 961384 | 2021-01-24 | Chatham | North Carolina | 37037 | 3550 | 69 |
| 961385 | 961385 | 2021-01-24 | Cherokee | North Carolina | 37039 | 1769 | 16 |
| 961386 | 961386 | 2021-01-24 | Chowan | North Carolina | 37041 | 1143 | 20 |
| 961387 | 961387 | 2021-01-24 | Clay | North Carolina | 37043 | 570 | 5 |
| 961388 | 961388 | 2021-01-24 | Cleveland | North Carolina | 37045 | 8979 | 175 |
| 961389 | 961389 | 2021-01-24 | Columbus | North Carolina | 37047 | 4871 | 106 |
| 961390 | 961390 | 2021-01-24 | Craven | North Carolina | 37049 | 6795 | 93 |
| 961391 | 961391 | 2021-01-24 | Cumberland | North Carolina | 37051 | 18887 | 178 |
| 961392 | 961392 | 2021-01-24 | Currituck | North Carolina | 37053 | 1025 | 13 |
| 961393 | 961393 | 2021-01-24 | Dare | North Carolina | 37055 | 1598 | 6 |
| 961394 | 961394 | 2021-01-24 | Davidson | North Carolina | 37057 | 12255 | 115 |
| 961395 | 961395 | 2021-01-24 | Davie | North Carolina | 37059 | 2842 | 17 |
| 961396 | 961396 | 2021-01-24 | Duplin | North Carolina | 37061 | 5097 | 102 |
| 961397 | 961397 | 2021-01-24 | Durham | North Carolina | 37063 | 18528 | 179 |
| 961398 | 961398 | 2021-01-24 | Edgecombe | North Carolina | 37065 | 3855 | 90 |
| 961399 | 961399 | 2021-01-24 | Forsyth | North Carolina | 37067 | 26545 | 271 |
| 961400 | 961400 | 2021-01-24 | Franklin | North Carolina | 37069 | 4397 | 40 |
| 961401 | 961401 | 2021-01-24 | Gaston | North Carolina | 37071 | 20549 | 304 |
| 961402 | 961402 | 2021-01-24 | Gates | North Carolina | 37073 | 505 | 12 |
| 961403 | 961403 | 2021-01-24 | Graham | North Carolina | 37075 | 511 | 12 |
| 961404 | 961404 | 2021-01-24 | Granville | North Carolina | 37077 | 4514 | 71 |
| 961405 | 961405 | 2021-01-24 | Greene | North Carolina | 37079 | 1850 | 35 |
| 961406 | 961406 | 2021-01-24 | Guilford | North Carolina | 37081 | 33119 | 377 |
| 961407 | 961407 | 2021-01-24 | Halifax | North Carolina | 37083 | 4037 | 74 |
| 961408 | 961408 | 2021-01-24 | Harnett | North Carolina | 37085 | 7849 | 109 |
| 961409 | 961409 | 2021-01-24 | Haywood | North Carolina | 37087 | 3149 | 76 |
| 961410 | 961410 | 2021-01-24 | Henderson | North Carolina | 37089 | 7295 | 100 |
| 961411 | 961411 | 2021-01-24 | Hertford | North Carolina | 37091 | 1731 | 54 |
| 961412 | 961412 | 2021-01-24 | Hoke | North Carolina | 37093 | 3507 | 40 |
| 961413 | 961413 | 2021-01-24 | Hyde | North Carolina | 37095 | 571 | 6 |
| 961414 | 961414 | 2021-01-24 | Iredell | North Carolina | 37097 | 13305 | 141 |
| 961415 | 961415 | 2021-01-24 | Jackson | North Carolina | 37099 | 2884 | 21 |
| 961416 | 961416 | 2021-01-24 | Johnston | North Carolina | 37101 | 14936 | 146 |
| 961417 | 961417 | 2021-01-24 | Jones | North Carolina | 37103 | 551 | 16 |
| 961418 | 961418 | 2021-01-24 | Lee | North Carolina | 37105 | 4620 | 52 |
| 961419 | 961419 | 2021-01-24 | Lenoir | North Carolina | 37107 | 4405 | 90 |
| 961420 | 961420 | 2021-01-24 | Lincoln | North Carolina | 37109 | 7451 | 43 |
| 961421 | 961421 | 2021-01-24 | Macon | North Carolina | 37113 | 2127 | 12 |
| 961422 | 961422 | 2021-01-24 | Madison | North Carolina | 37115 | 1143 | 27 |
| 961423 | 961423 | 2021-01-24 | Martin | North Carolina | 37117 | 1798 | 27 |
| 961424 | 961424 | 2021-01-24 | McDowell | North Carolina | 37111 | 4156 | 49 |
| 961425 | 961425 | 2021-01-24 | Mecklenburg | North Carolina | 37119 | 81933 | 739 |
| 961426 | 961426 | 2021-01-24 | Mitchell | North Carolina | 37121 | 1011 | 10 |
| 961427 | 961427 | 2021-01-24 | Montgomery | North Carolina | 37123 | 2600 | 56 |
| 961428 | 961428 | 2021-01-24 | Moore | North Carolina | 37125 | 6648 | 98 |
| 961429 | 961429 | 2021-01-24 | Nash | North Carolina | 37127 | 7611 | 136 |
| 961430 | 961430 | 2021-01-24 | New Hanover | North Carolina | 37129 | 12763 | 110 |
| 961431 | 961431 | 2021-01-24 | Northampton | North Carolina | 37131 | 1437 | 27 |
| 961432 | 961432 | 2021-01-24 | Onslow | North Carolina | 37133 | 12126 | 98 |
| 961433 | 961433 | 2021-01-24 | Orange | North Carolina | 37135 | 6380 | 77 |
| 961434 | 961434 | 2021-01-24 | Pamlico | North Carolina | 37137 | 708 | 6 |
| 961435 | 961435 | 2021-01-24 | Pasquotank | North Carolina | 37139 | 2558 | 71 |
| 961436 | 961436 | 2021-01-24 | Pender | North Carolina | 37141 | 3940 | 39 |
| 961437 | 961437 | 2021-01-24 | Perquimans | North Carolina | 37143 | 725 | 5 |
| 961438 | 961438 | 2021-01-24 | Person | North Carolina | 37145 | 2362 | 45 |
| 961439 | 961439 | 2021-01-24 | Pitt | North Carolina | 37147 | 14714 | 70 |
| 961440 | 961440 | 2021-01-24 | Polk | North Carolina | 37149 | 1120 | 16 |
| 961441 | 961441 | 2021-01-24 | Randolph | North Carolina | 37151 | 10744 | 166 |
| 961442 | 961442 | 2021-01-24 | Richmond | North Carolina | 37153 | 3464 | 65 |
| 961443 | 961443 | 2021-01-24 | Robeson | North Carolina | 37155 | 12771 | 174 |
| 961444 | 961444 | 2021-01-24 | Rockingham | North Carolina | 37157 | 6006 | 36 |
| 961445 | 961445 | 2021-01-24 | Rowan | North Carolina | 37159 | 12301 | 236 |
| 961446 | 961446 | 2021-01-24 | Rutherford | North Carolina | 37161 | 5978 | 161 |
| 961447 | 961447 | 2021-01-24 | Sampson | North Carolina | 37163 | 5929 | 78 |
| 961448 | 961448 | 2021-01-24 | Scotland | North Carolina | 37165 | 3088 | 63 |
| 961449 | 961449 | 2021-01-24 | Stanly | North Carolina | 37167 | 5738 | 92 |
| 961450 | 961450 | 2021-01-24 | Stokes | North Carolina | 37169 | 2925 | 53 |
| 961451 | 961451 | 2021-01-24 | Surry | North Carolina | 37171 | 6024 | 107 |
| 961452 | 961452 | 2021-01-24 | Swain | North Carolina | 37173 | 1019 | 11 |
| 961453 | 961453 | 2021-01-24 | Transylvania | North Carolina | 37175 | 1489 | 14 |
| 961454 | 961454 | 2021-01-24 | Tyrrell | North Carolina | 37177 | 247 | 6 |
| 961455 | 961455 | 2021-01-24 | Union | North Carolina | 37179 | 17337 | 139 |
| 961456 | 961456 | 2021-01-24 | Vance | North Carolina | 37181 | 3517 | 74 |
| 961457 | 961457 | 2021-01-24 | Wake | North Carolina | 37183 | 62731 | 413 |
| 961458 | 961458 | 2021-01-24 | Warren | North Carolina | 37185 | 1348 | 13 |
| 961459 | 961459 | 2021-01-24 | Washington | North Carolina | 37187 | 715 | 21 |
| 961460 | 961460 | 2021-01-24 | Watauga | North Carolina | 37189 | 3232 | 24 |
| 961461 | 961461 | 2021-01-24 | Wayne | North Carolina | 37191 | 8837 | 176 |
| 961462 | 961462 | 2021-01-24 | Wilkes | North Carolina | 37193 | 5108 | 87 |
| 961463 | 961463 | 2021-01-24 | Wilson | North Carolina | 37195 | 7132 | 123 |
| 961464 | 961464 | 2021-01-24 | Yadkin | North Carolina | 37197 | 3156 | 35 |
| 961465 | 961465 | 2021-01-24 | Yancey | North Carolina | 37199 | 1258 | 9 |
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]);