ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2022-03-23 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Avery 1
- Beaufort 1
- Bertie 1
- Bladen 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Camden 1
- Carteret 1
- Caswell 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Chowan 1
- Clay 1
- Cleveland 1
- Columbus 1
- Craven 1
- Cumberland 1
- Currituck 1
- Dare 1
- Davidson 1
- Davie 1
- …
state 1
- North Carolina · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335458 | 2335458 | 2022-03-23 | Alamance | North Carolina | 37001 | 46607 | 450 |
2335459 | 2335459 | 2022-03-23 | Alexander | North Carolina | 37003 | 10394 | 133 |
2335460 | 2335460 | 2022-03-23 | Alleghany | North Carolina | 37005 | 2938 | 12 |
2335461 | 2335461 | 2022-03-23 | Anson | North Carolina | 37007 | 6539 | 96 |
2335462 | 2335462 | 2022-03-23 | Ashe | North Carolina | 37009 | 6372 | 73 |
2335463 | 2335463 | 2022-03-23 | Avery | North Carolina | 37011 | 4463 | 42 |
2335464 | 2335464 | 2022-03-23 | Beaufort | North Carolina | 37013 | 12279 | 160 |
2335465 | 2335465 | 2022-03-23 | Bertie | North Carolina | 37015 | 4228 | 67 |
2335466 | 2335466 | 2022-03-23 | Bladen | North Carolina | 37017 | 9308 | 121 |
2335467 | 2335467 | 2022-03-23 | Brunswick | North Carolina | 37019 | 29695 | 310 |
2335468 | 2335468 | 2022-03-23 | Buncombe | North Carolina | 37021 | 52069 | 557 |
2335469 | 2335469 | 2022-03-23 | Burke | North Carolina | 37023 | 24993 | 314 |
2335470 | 2335470 | 2022-03-23 | Cabarrus | North Carolina | 37025 | 55392 | 467 |
2335471 | 2335471 | 2022-03-23 | Caldwell | North Carolina | 37027 | 22028 | 298 |
2335472 | 2335472 | 2022-03-23 | Camden | North Carolina | 37029 | 1747 | 9 |
2335473 | 2335473 | 2022-03-23 | Carteret | North Carolina | 37031 | 14055 | 85 |
2335474 | 2335474 | 2022-03-23 | Caswell | North Carolina | 37033 | 5254 | 44 |
2335475 | 2335475 | 2022-03-23 | Catawba | North Carolina | 37035 | 47395 | 563 |
2335476 | 2335476 | 2022-03-23 | Chatham | North Carolina | 37037 | 12701 | 108 |
2335477 | 2335477 | 2022-03-23 | Cherokee | North Carolina | 37039 | 7096 | 117 |
2335478 | 2335478 | 2022-03-23 | Chowan | North Carolina | 37041 | 4119 | 54 |
2335479 | 2335479 | 2022-03-23 | Clay | North Carolina | 37043 | 2633 | 39 |
2335480 | 2335480 | 2022-03-23 | Cleveland | North Carolina | 37045 | 29525 | 363 |
2335481 | 2335481 | 2022-03-23 | Columbus | North Carolina | 37047 | 15904 | 266 |
2335482 | 2335482 | 2022-03-23 | Craven | North Carolina | 37049 | 24052 | 194 |
2335483 | 2335483 | 2022-03-23 | Cumberland | North Carolina | 37051 | 83341 | 562 |
2335484 | 2335484 | 2022-03-23 | Currituck | North Carolina | 37053 | 4967 | 32 |
2335485 | 2335485 | 2022-03-23 | Dare | North Carolina | 37055 | 7359 | 23 |
2335486 | 2335486 | 2022-03-23 | Davidson | North Carolina | 37057 | 42932 | 393 |
2335487 | 2335487 | 2022-03-23 | Davie | North Carolina | 37059 | 11100 | 93 |
2335488 | 2335488 | 2022-03-23 | Duplin | North Carolina | 37061 | 16788 | 238 |
2335489 | 2335489 | 2022-03-23 | Durham | North Carolina | 37063 | 71873 | 298 |
2335490 | 2335490 | 2022-03-23 | Edgecombe | North Carolina | 37065 | 13462 | 141 |
2335491 | 2335491 | 2022-03-23 | Forsyth | North Carolina | 37067 | 91925 | 788 |
2335492 | 2335492 | 2022-03-23 | Franklin | North Carolina | 37069 | 20191 | 65 |
2335493 | 2335493 | 2022-03-23 | Gaston | North Carolina | 37071 | 64997 | 792 |
2335494 | 2335494 | 2022-03-23 | Gates | North Carolina | 37073 | 1885 | 19 |
2335495 | 2335495 | 2022-03-23 | Graham | North Carolina | 37075 | 2269 | 30 |
2335496 | 2335496 | 2022-03-23 | Granville | North Carolina | 37077 | 14192 | 111 |
2335497 | 2335497 | 2022-03-23 | Greene | North Carolina | 37079 | 5772 | 61 |
2335498 | 2335498 | 2022-03-23 | Guilford | North Carolina | 37081 | 116035 | 1153 |
2335499 | 2335499 | 2022-03-23 | Halifax | North Carolina | 37083 | 13903 | 181 |
2335500 | 2335500 | 2022-03-23 | Harnett | North Carolina | 37085 | 32620 | 325 |
2335501 | 2335501 | 2022-03-23 | Haywood | North Carolina | 37087 | 12883 | 198 |
2335502 | 2335502 | 2022-03-23 | Henderson | North Carolina | 37089 | 24830 | 288 |
2335503 | 2335503 | 2022-03-23 | Hertford | North Carolina | 37091 | 4709 | 81 |
2335504 | 2335504 | 2022-03-23 | Hoke | North Carolina | 37093 | 14586 | 103 |
2335505 | 2335505 | 2022-03-23 | Hyde | North Carolina | 37095 | 1308 | 13 |
2335506 | 2335506 | 2022-03-23 | Iredell | North Carolina | 37097 | 48234 | 442 |
2335507 | 2335507 | 2022-03-23 | Jackson | North Carolina | 37099 | 9282 | 86 |
2335508 | 2335508 | 2022-03-23 | Johnston | North Carolina | 37101 | 58920 | 432 |
2335509 | 2335509 | 2022-03-23 | Jones | North Carolina | 37103 | 2206 | 38 |
2335510 | 2335510 | 2022-03-23 | Lee | North Carolina | 37105 | 15891 | 141 |
2335511 | 2335511 | 2022-03-23 | Lenoir | North Carolina | 37107 | 15690 | 204 |
2335512 | 2335512 | 2022-03-23 | Lincoln | North Carolina | 37109 | 24264 | 158 |
2335513 | 2335513 | 2022-03-23 | Macon | North Carolina | 37113 | 7614 | 112 |
2335514 | 2335514 | 2022-03-23 | Madison | North Carolina | 37115 | 5058 | 79 |
2335515 | 2335515 | 2022-03-23 | Martin | North Carolina | 37117 | 6047 | 89 |
2335516 | 2335516 | 2022-03-23 | McDowell | North Carolina | 37111 | 13643 | 167 |
2335517 | 2335517 | 2022-03-23 | Mecklenburg | North Carolina | 37119 | 277142 | 1555 |
2335518 | 2335518 | 2022-03-23 | Mitchell | North Carolina | 37121 | 3362 | 34 |
2335519 | 2335519 | 2022-03-23 | Montgomery | North Carolina | 37123 | 7254 | 126 |
2335520 | 2335520 | 2022-03-23 | Moore | North Carolina | 37125 | 24095 | 318 |
2335521 | 2335521 | 2022-03-23 | Nash | North Carolina | 37127 | 26795 | 297 |
2335522 | 2335522 | 2022-03-23 | New Hanover | North Carolina | 37129 | 49989 | 385 |
2335523 | 2335523 | 2022-03-23 | Northampton | North Carolina | 37131 | 4312 | 82 |
2335524 | 2335524 | 2022-03-23 | Onslow | North Carolina | 37133 | 51760 | 374 |
2335525 | 2335525 | 2022-03-23 | Orange | North Carolina | 37135 | 25945 | 124 |
2335526 | 2335526 | 2022-03-23 | Pamlico | North Carolina | 37137 | 2592 | 27 |
2335527 | 2335527 | 2022-03-23 | Pasquotank | North Carolina | 37139 | 8460 | 111 |
2335528 | 2335528 | 2022-03-23 | Pender | North Carolina | 37141 | 15214 | 118 |
2335529 | 2335529 | 2022-03-23 | Perquimans | North Carolina | 37143 | 2741 | 18 |
2335530 | 2335530 | 2022-03-23 | Person | North Carolina | 37145 | 9241 | 104 |
2335531 | 2335531 | 2022-03-23 | Pitt | North Carolina | 37147 | 52310 | 157 |
2335532 | 2335532 | 2022-03-23 | Polk | North Carolina | 37149 | 3835 | 54 |
2335533 | 2335533 | 2022-03-23 | Randolph | North Carolina | 37151 | 35402 | 401 |
2335534 | 2335534 | 2022-03-23 | Richmond | North Carolina | 37153 | 12766 | 185 |
2335535 | 2335535 | 2022-03-23 | Robeson | North Carolina | 37155 | 40360 | 523 |
2335536 | 2335536 | 2022-03-23 | Rockingham | North Carolina | 37157 | 21902 | 267 |
2335537 | 2335537 | 2022-03-23 | Rowan | North Carolina | 37159 | 41046 | 566 |
2335538 | 2335538 | 2022-03-23 | Rutherford | North Carolina | 37161 | 17433 | 397 |
2335539 | 2335539 | 2022-03-23 | Sampson | North Carolina | 37163 | 18684 | 169 |
2335540 | 2335540 | 2022-03-23 | Scotland | North Carolina | 37165 | 9954 | 126 |
2335541 | 2335541 | 2022-03-23 | Stanly | North Carolina | 37167 | 19391 | 249 |
2335542 | 2335542 | 2022-03-23 | Stokes | North Carolina | 37169 | 11153 | 171 |
2335543 | 2335543 | 2022-03-23 | Surry | North Carolina | 37171 | 20981 | 330 |
2335544 | 2335544 | 2022-03-23 | Swain | North Carolina | 37173 | 3465 | 38 |
2335545 | 2335545 | 2022-03-23 | Transylvania | North Carolina | 37175 | 6109 | 69 |
2335546 | 2335546 | 2022-03-23 | Tyrrell | North Carolina | 37177 | 973 | 8 |
2335547 | 2335547 | 2022-03-23 | Union | North Carolina | 37179 | 61405 | 478 |
2335548 | 2335548 | 2022-03-23 | Vance | North Carolina | 37181 | 11817 | 112 |
2335549 | 2335549 | 2022-03-23 | Wake | North Carolina | 37183 | 289373 | 1040 |
2335550 | 2335550 | 2022-03-23 | Warren | North Carolina | 37185 | 4300 | 39 |
2335551 | 2335551 | 2022-03-23 | Washington | North Carolina | 37187 | 3009 | 50 |
2335552 | 2335552 | 2022-03-23 | Watauga | North Carolina | 37189 | 12281 | 58 |
2335553 | 2335553 | 2022-03-23 | Wayne | North Carolina | 37191 | 29309 | 382 |
2335554 | 2335554 | 2022-03-23 | Wilkes | North Carolina | 37193 | 17510 | 255 |
2335555 | 2335555 | 2022-03-23 | Wilson | North Carolina | 37195 | 21540 | 303 |
2335556 | 2335556 | 2022-03-23 | Yadkin | North Carolina | 37197 | 10742 | 111 |
2335557 | 2335557 | 2022-03-23 | Yancey | North Carolina | 37199 | 4992 | 51 |
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);