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 117
- 37037 114
- 37025 108
- 37067 108
- 37101 108
- 37119 108
- 37133 108
- 37191 107
- 37019 106
- 37049 106
- 37085 106
- 37189 105
- 37195 105
- 37063 104
- 37097 103
- 37163 103
- 37071 102
- 37081 102
- 37093 102
- 37109 102
- 37125 102
- 37129 102
- 37031 100
- 37057 100
- 37069 100
- 37135 100
- 37139 100
- 37147 100
- 37159 100
- 37167 100
- …
county >30
- Wake 117
- Chatham 114
- Cabarrus 108
- Forsyth 108
- Johnston 108
- Mecklenburg 108
- Onslow 108
- Wayne 107
- Brunswick 106
- Craven 106
- Harnett 106
- Watauga 105
- Wilson 105
- Durham 104
- Iredell 103
- Sampson 103
- Gaston 102
- Guilford 102
- Hoke 102
- Lincoln 102
- Moore 102
- New Hanover 102
- Carteret 100
- Davidson 100
- Franklin 100
- Orange 100
- Pasquotank 100
- Pitt 100
- Rowan 100
- Stanly 100
- …
state 1
- North Carolina · 9,308 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
279478 | 279478 | 2020-06-27 | Alamance | North Carolina | 37001 | 1066 | 36 |
279479 | 279479 | 2020-06-27 | Alexander | North Carolina | 37003 | 84 | 0 |
279480 | 279480 | 2020-06-27 | Alleghany | North Carolina | 37005 | 31 | 0 |
279481 | 279481 | 2020-06-27 | Anson | North Carolina | 37007 | 121 | 1 |
279482 | 279482 | 2020-06-27 | Ashe | North Carolina | 37009 | 52 | 1 |
279483 | 279483 | 2020-06-27 | Avery | North Carolina | 37011 | 9 | 0 |
279484 | 279484 | 2020-06-27 | Beaufort | North Carolina | 37013 | 74 | 0 |
279485 | 279485 | 2020-06-27 | Bertie | North Carolina | 37015 | 141 | 4 |
279486 | 279486 | 2020-06-27 | Bladen | North Carolina | 37017 | 349 | 3 |
279487 | 279487 | 2020-06-27 | Brunswick | North Carolina | 37019 | 466 | 6 |
279488 | 279488 | 2020-06-27 | Buncombe | North Carolina | 37021 | 536 | 36 |
279489 | 279489 | 2020-06-27 | Burke | North Carolina | 37023 | 1000 | 19 |
279490 | 279490 | 2020-06-27 | Cabarrus | North Carolina | 37025 | 1021 | 27 |
279491 | 279491 | 2020-06-27 | Caldwell | North Carolina | 37027 | 358 | 4 |
279492 | 279492 | 2020-06-27 | Camden | North Carolina | 37029 | 24 | 0 |
279493 | 279493 | 2020-06-27 | Carteret | North Carolina | 37031 | 70 | 3 |
279494 | 279494 | 2020-06-27 | Caswell | North Carolina | 37033 | 134 | 1 |
279495 | 279495 | 2020-06-27 | Catawba | North Carolina | 37035 | 686 | 10 |
279496 | 279496 | 2020-06-27 | Chatham | North Carolina | 37037 | 924 | 42 |
279497 | 279497 | 2020-06-27 | Cherokee | North Carolina | 37039 | 33 | 1 |
279498 | 279498 | 2020-06-27 | Chowan | North Carolina | 37041 | 22 | 0 |
279499 | 279499 | 2020-06-27 | Clay | North Carolina | 37043 | 9 | 0 |
279500 | 279500 | 2020-06-27 | Cleveland | North Carolina | 37045 | 268 | 3 |
279501 | 279501 | 2020-06-27 | Columbus | North Carolina | 37047 | 502 | 37 |
279502 | 279502 | 2020-06-27 | Craven | North Carolina | 37049 | 350 | 6 |
279503 | 279503 | 2020-06-27 | Cumberland | North Carolina | 37051 | 1101 | 41 |
279504 | 279504 | 2020-06-27 | Currituck | North Carolina | 37053 | 18 | 0 |
279505 | 279505 | 2020-06-27 | Dare | North Carolina | 37055 | 41 | 1 |
279506 | 279506 | 2020-06-27 | Davidson | North Carolina | 37057 | 908 | 15 |
279507 | 279507 | 2020-06-27 | Davie | North Carolina | 37059 | 183 | 3 |
279508 | 279508 | 2020-06-27 | Duplin | North Carolina | 37061 | 1422 | 27 |
279509 | 279509 | 2020-06-27 | Durham | North Carolina | 37063 | 3532 | 63 |
279510 | 279510 | 2020-06-27 | Edgecombe | North Carolina | 37065 | 302 | 9 |
279511 | 279511 | 2020-06-27 | Forsyth | North Carolina | 37067 | 2871 | 34 |
279512 | 279512 | 2020-06-27 | Franklin | North Carolina | 37069 | 326 | 21 |
279513 | 279513 | 2020-06-27 | Gaston | North Carolina | 37071 | 972 | 11 |
279514 | 279514 | 2020-06-27 | Gates | North Carolina | 37073 | 26 | 2 |
279515 | 279515 | 2020-06-27 | Graham | North Carolina | 37075 | 9 | 0 |
279516 | 279516 | 2020-06-27 | Granville | North Carolina | 37077 | 779 | 19 |
279517 | 279517 | 2020-06-27 | Greene | North Carolina | 37079 | 172 | 2 |
279518 | 279518 | 2020-06-27 | Guilford | North Carolina | 37081 | 2690 | 112 |
279519 | 279519 | 2020-06-27 | Halifax | North Carolina | 37083 | 291 | 4 |
279520 | 279520 | 2020-06-27 | Harnett | North Carolina | 37085 | 598 | 30 |
279521 | 279521 | 2020-06-27 | Haywood | North Carolina | 37087 | 86 | 0 |
279522 | 279522 | 2020-06-27 | Henderson | North Carolina | 37089 | 558 | 50 |
279523 | 279523 | 2020-06-27 | Hertford | North Carolina | 37091 | 160 | 10 |
279524 | 279524 | 2020-06-27 | Hoke | North Carolina | 37093 | 352 | 3 |
279525 | 279525 | 2020-06-27 | Hyde | North Carolina | 37095 | 9 | 0 |
279526 | 279526 | 2020-06-27 | Iredell | North Carolina | 37097 | 707 | 7 |
279527 | 279527 | 2020-06-27 | Jackson | North Carolina | 37099 | 91 | 1 |
279528 | 279528 | 2020-06-27 | Johnston | North Carolina | 37101 | 1346 | 29 |
279529 | 279529 | 2020-06-27 | Jones | North Carolina | 37103 | 32 | 3 |
279530 | 279530 | 2020-06-27 | Lee | North Carolina | 37105 | 770 | 8 |
279531 | 279531 | 2020-06-27 | Lenoir | North Carolina | 37107 | 358 | 10 |
279532 | 279532 | 2020-06-27 | Lincoln | North Carolina | 37109 | 232 | 1 |
279533 | 279533 | 2020-06-27 | Macon | North Carolina | 37113 | 266 | 1 |
279534 | 279534 | 2020-06-27 | Madison | North Carolina | 37115 | 11 | 0 |
279535 | 279535 | 2020-06-27 | Martin | North Carolina | 37117 | 120 | 4 |
279536 | 279536 | 2020-06-27 | McDowell | North Carolina | 37111 | 220 | 1 |
279537 | 279537 | 2020-06-27 | Mecklenburg | North Carolina | 37119 | 10287 | 149 |
279538 | 279538 | 2020-06-27 | Mitchell | North Carolina | 37121 | 27 | 0 |
279539 | 279539 | 2020-06-27 | Montgomery | North Carolina | 37123 | 284 | 7 |
279540 | 279540 | 2020-06-27 | Moore | North Carolina | 37125 | 421 | 13 |
279541 | 279541 | 2020-06-27 | Nash | North Carolina | 37127 | 403 | 4 |
279542 | 279542 | 2020-06-27 | New Hanover | North Carolina | 37129 | 750 | 5 |
279543 | 279543 | 2020-06-27 | Northampton | North Carolina | 37131 | 179 | 15 |
279544 | 279544 | 2020-06-27 | Onslow | North Carolina | 37133 | 249 | 3 |
279545 | 279545 | 2020-06-27 | Orange | North Carolina | 37135 | 616 | 41 |
279546 | 279546 | 2020-06-27 | Pamlico | North Carolina | 37137 | 18 | 0 |
279547 | 279547 | 2020-06-27 | Pasquotank | North Carolina | 37139 | 198 | 15 |
279548 | 279548 | 2020-06-27 | Pender | North Carolina | 37141 | 222 | 1 |
279549 | 279549 | 2020-06-27 | Perquimans | North Carolina | 37143 | 36 | 2 |
279550 | 279550 | 2020-06-27 | Person | North Carolina | 37145 | 103 | 1 |
279551 | 279551 | 2020-06-27 | Pitt | North Carolina | 37147 | 650 | 5 |
279552 | 279552 | 2020-06-27 | Polk | North Carolina | 37149 | 68 | 4 |
279553 | 279553 | 2020-06-27 | Randolph | North Carolina | 37151 | 1137 | 29 |
279554 | 279554 | 2020-06-27 | Richmond | North Carolina | 37153 | 256 | 5 |
279555 | 279555 | 2020-06-27 | Robeson | North Carolina | 37155 | 1185 | 38 |
279556 | 279556 | 2020-06-27 | Rockingham | North Carolina | 37157 | 210 | 2 |
279557 | 279557 | 2020-06-27 | Rowan | North Carolina | 37159 | 1139 | 42 |
279558 | 279558 | 2020-06-27 | Rutherford | North Carolina | 37161 | 281 | 9 |
279559 | 279559 | 2020-06-27 | Sampson | North Carolina | 37163 | 986 | 6 |
279560 | 279560 | 2020-06-27 | Scotland | North Carolina | 37165 | 133 | 0 |
279561 | 279561 | 2020-06-27 | Stanly | North Carolina | 37167 | 340 | 5 |
279562 | 279562 | 2020-06-27 | Stokes | North Carolina | 37169 | 124 | 1 |
279563 | 279563 | 2020-06-27 | Surry | North Carolina | 37171 | 444 | 2 |
279564 | 279564 | 2020-06-27 | Swain | North Carolina | 37173 | 51 | 0 |
279565 | 279565 | 2020-06-27 | Transylvania | North Carolina | 37175 | 20 | 1 |
279566 | 279566 | 2020-06-27 | Tyrrell | North Carolina | 37177 | 8 | 0 |
279567 | 279567 | 2020-06-27 | Union | North Carolina | 37179 | 1123 | 24 |
279568 | 279568 | 2020-06-27 | Vance | North Carolina | 37181 | 492 | 36 |
279569 | 279569 | 2020-06-27 | Wake | North Carolina | 37183 | 4797 | 46 |
279570 | 279570 | 2020-06-27 | Warren | North Carolina | 37185 | 157 | 5 |
279571 | 279571 | 2020-06-27 | Washington | North Carolina | 37187 | 38 | 3 |
279572 | 279572 | 2020-06-27 | Watauga | North Carolina | 37189 | 58 | 0 |
279573 | 279573 | 2020-06-27 | Wayne | North Carolina | 37191 | 1740 | 25 |
279574 | 279574 | 2020-06-27 | Wilkes | North Carolina | 37193 | 567 | 6 |
279575 | 279575 | 2020-06-27 | Wilson | North Carolina | 37195 | 674 | 18 |
279576 | 279576 | 2020-06-27 | Yadkin | North Carolina | 37197 | 306 | 4 |
279577 | 279577 | 2020-06-27 | Yancey | North Carolina | 37199 | 43 | 0 |
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);