ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56,809 rows where state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 37183 592
- 37037 589
- 37025 583
- 37067 583
- 37101 583
- 37119 583
- 37133 583
- 37191 582
- 37019 581
- 37049 581
- 37085 581
- 37189 580
- 37195 580
- 37063 579
- 37097 578
- 37163 578
- 37071 577
- 37081 577
- 37093 577
- 37109 577
- 37125 577
- 37129 577
- 37031 575
- 37057 575
- 37069 575
- 37135 575
- 37139 575
- 37147 575
- 37159 575
- 37167 575
- …
county
- Wake 592
- Chatham 589
- Cabarrus 583
- Forsyth 583
- Johnston 583
- Mecklenburg 583
- Onslow 583
- Wayne 582
- Brunswick 581
- Craven 581
- Harnett 581
- Watauga 580
- Wilson 580
- Durham 579
- Iredell 578
- Sampson 578
- Gaston 577
- Guilford 577
- Hoke 577
- Lincoln 577
- Moore 577
- New Hanover 577
- Carteret 575
- Davidson 575
- Franklin 575
- Orange 575
- Pasquotank 575
- Pitt 575
- Rowan 575
- Stanly 575
- …
state
- North Carolina · 56,809 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 1818520 | 1818520 | 2021-10-15 | Alamance | North Carolina | 37001 | 25869 | 332 |
| 1818521 | 1818521 | 2021-10-15 | Alexander | North Carolina | 37003 | 6353 | 112 |
| 1818522 | 1818522 | 2021-10-15 | Alleghany | North Carolina | 37005 | 1590 | 6 |
| 1818523 | 1818523 | 2021-10-15 | Anson | North Carolina | 37007 | 3781 | 77 |
| 1818524 | 1818524 | 2021-10-15 | Ashe | North Carolina | 37009 | 3381 | 48 |
| 1818525 | 1818525 | 2021-10-15 | Avery | North Carolina | 37011 | 2675 | 32 |
| 1818526 | 1818526 | 2021-10-15 | Beaufort | North Carolina | 37013 | 6934 | 124 |
| 1818527 | 1818527 | 2021-10-15 | Bertie | North Carolina | 37015 | 2434 | 49 |
| 1818528 | 1818528 | 2021-10-15 | Bladen | North Carolina | 37017 | 5407 | 94 |
| 1818529 | 1818529 | 2021-10-15 | Brunswick | North Carolina | 37019 | 15967 | 230 |
| 1818530 | 1818530 | 2021-10-15 | Buncombe | North Carolina | 37021 | 27486 | 422 |
| 1818531 | 1818531 | 2021-10-15 | Burke | North Carolina | 37023 | 15474 | 213 |
| 1818532 | 1818532 | 2021-10-15 | Cabarrus | North Carolina | 37025 | 32263 | 325 |
| 1818533 | 1818533 | 2021-10-15 | Caldwell | North Carolina | 37027 | 13023 | 204 |
| 1818534 | 1818534 | 2021-10-15 | Camden | North Carolina | 37029 | 1087 | 8 |
| 1818535 | 1818535 | 2021-10-15 | Carteret | North Carolina | 37031 | 8194 | 81 |
| 1818536 | 1818536 | 2021-10-15 | Caswell | North Carolina | 37033 | 3138 | 37 |
| 1818537 | 1818537 | 2021-10-15 | Catawba | North Carolina | 37035 | 27883 | 409 |
| 1818538 | 1818538 | 2021-10-15 | Chatham | North Carolina | 37037 | 6649 | 91 |
| 1818539 | 1818539 | 2021-10-15 | Cherokee | North Carolina | 37039 | 4613 | 74 |
| 1818540 | 1818540 | 2021-10-15 | Chowan | North Carolina | 37041 | 2247 | 40 |
| 1818541 | 1818541 | 2021-10-15 | Clay | North Carolina | 37043 | 1634 | 35 |
| 1818542 | 1818542 | 2021-10-15 | Cleveland | North Carolina | 37045 | 18044 | 300 |
| 1818543 | 1818543 | 2021-10-15 | Columbus | North Carolina | 37047 | 9894 | 221 |
| 1818544 | 1818544 | 2021-10-15 | Craven | North Carolina | 37049 | 14051 | 152 |
| 1818545 | 1818545 | 2021-10-15 | Cumberland | North Carolina | 37051 | 44099 | 451 |
| 1818546 | 1818546 | 2021-10-15 | Currituck | North Carolina | 37053 | 2656 | 25 |
| 1818547 | 1818547 | 2021-10-15 | Dare | North Carolina | 37055 | 3683 | 12 |
| 1818548 | 1818548 | 2021-10-15 | Davidson | North Carolina | 37057 | 25347 | 296 |
| 1818549 | 1818549 | 2021-10-15 | Davie | North Carolina | 37059 | 6286 | 70 |
| 1818550 | 1818550 | 2021-10-15 | Duplin | North Carolina | 37061 | 9811 | 176 |
| 1818551 | 1818551 | 2021-10-15 | Durham | North Carolina | 37063 | 34435 | 257 |
| 1818552 | 1818552 | 2021-10-15 | Edgecombe | North Carolina | 37065 | 7817 | 124 |
| 1818553 | 1818553 | 2021-10-15 | Forsyth | North Carolina | 37067 | 50752 | 540 |
| 1818554 | 1818554 | 2021-10-15 | Franklin | North Carolina | 37069 | 9701 | 60 |
| 1818555 | 1818555 | 2021-10-15 | Gaston | North Carolina | 37071 | 39320 | 595 |
| 1818556 | 1818556 | 2021-10-15 | Gates | North Carolina | 37073 | 1059 | 18 |
| 1818557 | 1818557 | 2021-10-15 | Graham | North Carolina | 37075 | 1311 | 27 |
| 1818558 | 1818558 | 2021-10-15 | Granville | North Carolina | 37077 | 7789 | 99 |
| 1818559 | 1818559 | 2021-10-15 | Greene | North Carolina | 37079 | 3257 | 56 |
| 1818560 | 1818560 | 2021-10-15 | Guilford | North Carolina | 37081 | 66455 | 857 |
| 1818561 | 1818561 | 2021-10-15 | Halifax | North Carolina | 37083 | 7739 | 134 |
| 1818562 | 1818562 | 2021-10-15 | Harnett | North Carolina | 37085 | 18056 | 249 |
| 1818563 | 1818563 | 2021-10-15 | Haywood | North Carolina | 37087 | 7258 | 138 |
| 1818564 | 1818564 | 2021-10-15 | Henderson | North Carolina | 37089 | 14918 | 195 |
| 1818565 | 1818565 | 2021-10-15 | Hertford | North Carolina | 37091 | 2787 | 70 |
| 1818566 | 1818566 | 2021-10-15 | Hoke | North Carolina | 37093 | 7003 | 78 |
| 1818567 | 1818567 | 2021-10-15 | Hyde | North Carolina | 37095 | 822 | 12 |
| 1818568 | 1818568 | 2021-10-15 | Iredell | North Carolina | 37097 | 28258 | 314 |
| 1818569 | 1818569 | 2021-10-15 | Jackson | North Carolina | 37099 | 5534 | 70 |
| 1818570 | 1818570 | 2021-10-15 | Johnston | North Carolina | 37101 | 31817 | 316 |
| 1818571 | 1818571 | 2021-10-15 | Jones | North Carolina | 37103 | 1297 | 29 |
| 1818572 | 1818572 | 2021-10-15 | Lee | North Carolina | 37105 | 9299 | 105 |
| 1818573 | 1818573 | 2021-10-15 | Lenoir | North Carolina | 37107 | 9369 | 148 |
| 1818574 | 1818574 | 2021-10-15 | Lincoln | North Carolina | 37109 | 14677 | 107 |
| 1818575 | 1818575 | 2021-10-15 | Macon | North Carolina | 37113 | 4867 | 54 |
| 1818576 | 1818576 | 2021-10-15 | Madison | North Carolina | 37115 | 2718 | 57 |
| 1818577 | 1818577 | 2021-10-15 | Martin | North Carolina | 37117 | 3578 | 67 |
| 1818578 | 1818578 | 2021-10-15 | McDowell | North Carolina | 37111 | 8461 | 121 |
| 1818579 | 1818579 | 2021-10-15 | Mecklenburg | North Carolina | 37119 | 154718 | 1211 |
| 1818580 | 1818580 | 2021-10-15 | Mitchell | North Carolina | 37121 | 1986 | 18 |
| 1818581 | 1818581 | 2021-10-15 | Montgomery | North Carolina | 37123 | 4438 | 108 |
| 1818582 | 1818582 | 2021-10-15 | Moore | North Carolina | 37125 | 13404 | 245 |
| 1818583 | 1818583 | 2021-10-15 | Nash | North Carolina | 37127 | 15116 | 226 |
| 1818584 | 1818584 | 2021-10-15 | New Hanover | North Carolina | 37129 | 28341 | 281 |
| 1818585 | 1818585 | 2021-10-15 | Northampton | North Carolina | 37131 | 2563 | 62 |
| 1818586 | 1818586 | 2021-10-15 | Onslow | North Carolina | 37133 | 28084 | 249 |
| 1818587 | 1818587 | 2021-10-15 | Orange | North Carolina | 37135 | 11600 | 109 |
| 1818588 | 1818588 | 2021-10-15 | Pamlico | North Carolina | 37137 | 1681 | 24 |
| 1818589 | 1818589 | 2021-10-15 | Pasquotank | North Carolina | 37139 | 4994 | 101 |
| 1818590 | 1818590 | 2021-10-15 | Pender | North Carolina | 37141 | 8709 | 97 |
| 1818591 | 1818591 | 2021-10-15 | Perquimans | North Carolina | 37143 | 1496 | 15 |
| 1818592 | 1818592 | 2021-10-15 | Person | North Carolina | 37145 | 5036 | 87 |
| 1818593 | 1818593 | 2021-10-15 | Pitt | North Carolina | 37147 | 29209 | 139 |
| 1818594 | 1818594 | 2021-10-15 | Polk | North Carolina | 37149 | 2273 | 44 |
| 1818595 | 1818595 | 2021-10-15 | Randolph | North Carolina | 37151 | 21297 | 303 |
| 1818596 | 1818596 | 2021-10-15 | Richmond | North Carolina | 37153 | 7012 | 134 |
| 1818597 | 1818597 | 2021-10-15 | Robeson | North Carolina | 37155 | 24681 | 422 |
| 1818598 | 1818598 | 2021-10-15 | Rockingham | North Carolina | 37157 | 11705 | 192 |
| 1818599 | 1818599 | 2021-10-15 | Rowan | North Carolina | 37159 | 25869 | 437 |
| 1818600 | 1818600 | 2021-10-15 | Rutherford | North Carolina | 37161 | 11191 | 302 |
| 1818601 | 1818601 | 2021-10-15 | Sampson | North Carolina | 37163 | 11069 | 130 |
| 1818602 | 1818602 | 2021-10-15 | Scotland | North Carolina | 37165 | 5636 | 106 |
| 1818603 | 1818603 | 2021-10-15 | Stanly | North Carolina | 37167 | 11421 | 179 |
| 1818604 | 1818604 | 2021-10-15 | Stokes | North Carolina | 37169 | 6052 | 104 |
| 1818605 | 1818605 | 2021-10-15 | Surry | North Carolina | 37171 | 12044 | 221 |
| 1818606 | 1818606 | 2021-10-15 | Swain | North Carolina | 37173 | 1932 | 22 |
| 1818607 | 1818607 | 2021-10-15 | Transylvania | North Carolina | 37175 | 3842 | 48 |
| 1818608 | 1818608 | 2021-10-15 | Tyrrell | North Carolina | 37177 | 542 | 7 |
| 1818609 | 1818609 | 2021-10-15 | Union | North Carolina | 37179 | 35655 | 328 |
| 1818610 | 1818610 | 2021-10-15 | Vance | North Carolina | 37181 | 6627 | 98 |
| 1818611 | 1818611 | 2021-10-15 | Wake | North Carolina | 37183 | 128440 | 881 |
| 1818612 | 1818612 | 2021-10-15 | Warren | North Carolina | 37185 | 2322 | 28 |
| 1818613 | 1818613 | 2021-10-15 | Washington | North Carolina | 37187 | 1560 | 37 |
| 1818614 | 1818614 | 2021-10-15 | Watauga | North Carolina | 37189 | 6478 | 38 |
| 1818615 | 1818615 | 2021-10-15 | Wayne | North Carolina | 37191 | 15619 | 297 |
| 1818616 | 1818616 | 2021-10-15 | Wilkes | North Carolina | 37193 | 10393 | 174 |
| 1818617 | 1818617 | 2021-10-15 | Wilson | North Carolina | 37195 | 13019 | 226 |
| 1818618 | 1818618 | 2021-10-15 | Yadkin | North Carolina | 37197 | 5890 | 70 |
| 1818619 | 1818619 | 2021-10-15 | Yancey | North Carolina | 37199 | 2751 | 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);