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-01-30 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 |
---|---|---|---|---|---|---|---|
2166341 | 2166341 | 2022-01-30 | Alamance | North Carolina | 37001 | 42740 | 388 |
2166342 | 2166342 | 2022-01-30 | Alexander | North Carolina | 37003 | 9563 | 121 |
2166343 | 2166343 | 2022-01-30 | Alleghany | North Carolina | 37005 | 2599 | 11 |
2166344 | 2166344 | 2022-01-30 | Anson | North Carolina | 37007 | 5932 | 87 |
2166345 | 2166345 | 2022-01-30 | Ashe | North Carolina | 37009 | 5371 | 67 |
2166346 | 2166346 | 2022-01-30 | Avery | North Carolina | 37011 | 3916 | 39 |
2166347 | 2166347 | 2022-01-30 | Beaufort | North Carolina | 37013 | 11019 | 142 |
2166348 | 2166348 | 2022-01-30 | Bertie | North Carolina | 37015 | 3953 | 59 |
2166349 | 2166349 | 2022-01-30 | Bladen | North Carolina | 37017 | 8544 | 106 |
2166350 | 2166350 | 2022-01-30 | Brunswick | North Carolina | 37019 | 26127 | 269 |
2166351 | 2166351 | 2022-01-30 | Buncombe | North Carolina | 37021 | 44784 | 492 |
2166352 | 2166352 | 2022-01-30 | Burke | North Carolina | 37023 | 21666 | 267 |
2166353 | 2166353 | 2022-01-30 | Cabarrus | North Carolina | 37025 | 51421 | 411 |
2166354 | 2166354 | 2022-01-30 | Caldwell | North Carolina | 37027 | 19791 | 244 |
2166355 | 2166355 | 2022-01-30 | Camden | North Carolina | 37029 | 1639 | 9 |
2166356 | 2166356 | 2022-01-30 | Carteret | North Carolina | 37031 | 12028 | 83 |
2166357 | 2166357 | 2022-01-30 | Caswell | North Carolina | 37033 | 4773 | 39 |
2166358 | 2166358 | 2022-01-30 | Catawba | North Carolina | 37035 | 43105 | 498 |
2166359 | 2166359 | 2022-01-30 | Chatham | North Carolina | 37037 | 11293 | 99 |
2166360 | 2166360 | 2022-01-30 | Cherokee | North Carolina | 37039 | 6377 | 91 |
2166361 | 2166361 | 2022-01-30 | Chowan | North Carolina | 37041 | 3874 | 47 |
2166362 | 2166362 | 2022-01-30 | Clay | North Carolina | 37043 | 2285 | 38 |
2166363 | 2166363 | 2022-01-30 | Cleveland | North Carolina | 37045 | 27108 | 338 |
2166364 | 2166364 | 2022-01-30 | Columbus | North Carolina | 37047 | 14610 | 239 |
2166365 | 2166365 | 2022-01-30 | Craven | North Carolina | 37049 | 20742 | 174 |
2166366 | 2166366 | 2022-01-30 | Cumberland | North Carolina | 37051 | 72983 | 516 |
2166367 | 2166367 | 2022-01-30 | Currituck | North Carolina | 37053 | 4416 | 32 |
2166368 | 2166368 | 2022-01-30 | Dare | North Carolina | 37055 | 6688 | 18 |
2166369 | 2166369 | 2022-01-30 | Davidson | North Carolina | 37057 | 39524 | 366 |
2166370 | 2166370 | 2022-01-30 | Davie | North Carolina | 37059 | 10024 | 82 |
2166371 | 2166371 | 2022-01-30 | Duplin | North Carolina | 37061 | 14438 | 207 |
2166372 | 2166372 | 2022-01-30 | Durham | North Carolina | 37063 | 64739 | 285 |
2166373 | 2166373 | 2022-01-30 | Edgecombe | North Carolina | 37065 | 12641 | 133 |
2166374 | 2166374 | 2022-01-30 | Forsyth | North Carolina | 37067 | 84472 | 680 |
2166375 | 2166375 | 2022-01-30 | Franklin | North Carolina | 37069 | 18059 | 65 |
2166376 | 2166376 | 2022-01-30 | Gaston | North Carolina | 37071 | 59726 | 700 |
2166377 | 2166377 | 2022-01-30 | Gates | North Carolina | 37073 | 1691 | 19 |
2166378 | 2166378 | 2022-01-30 | Graham | North Carolina | 37075 | 1986 | 30 |
2166379 | 2166379 | 2022-01-30 | Granville | North Carolina | 37077 | 13095 | 110 |
2166380 | 2166380 | 2022-01-30 | Greene | North Carolina | 37079 | 5282 | 56 |
2166381 | 2166381 | 2022-01-30 | Guilford | North Carolina | 37081 | 105961 | 986 |
2166382 | 2166382 | 2022-01-30 | Halifax | North Carolina | 37083 | 12997 | 158 |
2166383 | 2166383 | 2022-01-30 | Harnett | North Carolina | 37085 | 29040 | 290 |
2166384 | 2166384 | 2022-01-30 | Haywood | North Carolina | 37087 | 11303 | 172 |
2166385 | 2166385 | 2022-01-30 | Henderson | North Carolina | 37089 | 22526 | 244 |
2166386 | 2166386 | 2022-01-30 | Hertford | North Carolina | 37091 | 4475 | 80 |
2166387 | 2166387 | 2022-01-30 | Hoke | North Carolina | 37093 | 13182 | 94 |
2166388 | 2166388 | 2022-01-30 | Hyde | North Carolina | 37095 | 1186 | 13 |
2166389 | 2166389 | 2022-01-30 | Iredell | North Carolina | 37097 | 44239 | 383 |
2166390 | 2166390 | 2022-01-30 | Jackson | North Carolina | 37099 | 8283 | 80 |
2166391 | 2166391 | 2022-01-30 | Johnston | North Carolina | 37101 | 52912 | 368 |
2166392 | 2166392 | 2022-01-30 | Jones | North Carolina | 37103 | 1962 | 38 |
2166393 | 2166393 | 2022-01-30 | Lee | North Carolina | 37105 | 14737 | 129 |
2166394 | 2166394 | 2022-01-30 | Lenoir | North Carolina | 37107 | 14194 | 182 |
2166395 | 2166395 | 2022-01-30 | Lincoln | North Carolina | 37109 | 22071 | 122 |
2166396 | 2166396 | 2022-01-30 | Macon | North Carolina | 37113 | 6700 | 89 |
2166397 | 2166397 | 2022-01-30 | Madison | North Carolina | 37115 | 4248 | 74 |
2166398 | 2166398 | 2022-01-30 | Martin | North Carolina | 37117 | 5608 | 79 |
2166399 | 2166399 | 2022-01-30 | McDowell | North Carolina | 37111 | 11759 | 142 |
2166400 | 2166400 | 2022-01-30 | Mecklenburg | North Carolina | 37119 | 256704 | 1433 |
2166401 | 2166401 | 2022-01-30 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2166402 | 2166402 | 2022-01-30 | Montgomery | North Carolina | 37123 | 6740 | 114 |
2166403 | 2166403 | 2022-01-30 | Moore | North Carolina | 37125 | 22138 | 279 |
2166404 | 2166404 | 2022-01-30 | Nash | North Carolina | 37127 | 25201 | 268 |
2166405 | 2166405 | 2022-01-30 | New Hanover | North Carolina | 37129 | 43804 | 325 |
2166406 | 2166406 | 2022-01-30 | Northampton | North Carolina | 37131 | 4003 | 68 |
2166407 | 2166407 | 2022-01-30 | Onslow | North Carolina | 37133 | 44927 | 306 |
2166408 | 2166408 | 2022-01-30 | Orange | North Carolina | 37135 | 22474 | 119 |
2166409 | 2166409 | 2022-01-30 | Pamlico | North Carolina | 37137 | 2379 | 27 |
2166410 | 2166410 | 2022-01-30 | Pasquotank | North Carolina | 37139 | 7360 | 111 |
2166411 | 2166411 | 2022-01-30 | Pender | North Carolina | 37141 | 13617 | 106 |
2166412 | 2166412 | 2022-01-30 | Perquimans | North Carolina | 37143 | 2485 | 17 |
2166413 | 2166413 | 2022-01-30 | Person | North Carolina | 37145 | 8263 | 96 |
2166414 | 2166414 | 2022-01-30 | Pitt | North Carolina | 37147 | 48220 | 146 |
2166415 | 2166415 | 2022-01-30 | Polk | North Carolina | 37149 | 3435 | 49 |
2166416 | 2166416 | 2022-01-30 | Randolph | North Carolina | 37151 | 32443 | 367 |
2166417 | 2166417 | 2022-01-30 | Richmond | North Carolina | 37153 | 11464 | 165 |
2166418 | 2166418 | 2022-01-30 | Robeson | North Carolina | 37155 | 36878 | 481 |
2166419 | 2166419 | 2022-01-30 | Rockingham | North Carolina | 37157 | 19754 | 240 |
2166420 | 2166420 | 2022-01-30 | Rowan | North Carolina | 37159 | 37887 | 530 |
2166421 | 2166421 | 2022-01-30 | Rutherford | North Carolina | 37161 | 15653 | 362 |
2166422 | 2166422 | 2022-01-30 | Sampson | North Carolina | 37163 | 16804 | 147 |
2166423 | 2166423 | 2022-01-30 | Scotland | North Carolina | 37165 | 9299 | 116 |
2166424 | 2166424 | 2022-01-30 | Stanly | North Carolina | 37167 | 17956 | 222 |
2166425 | 2166425 | 2022-01-30 | Stokes | North Carolina | 37169 | 10106 | 140 |
2166426 | 2166426 | 2022-01-30 | Surry | North Carolina | 37171 | 18979 | 286 |
2166427 | 2166427 | 2022-01-30 | Swain | North Carolina | 37173 | 3004 | 33 |
2166428 | 2166428 | 2022-01-30 | Transylvania | North Carolina | 37175 | 5606 | 57 |
2166429 | 2166429 | 2022-01-30 | Tyrrell | North Carolina | 37177 | 901 | 7 |
2166430 | 2166430 | 2022-01-30 | Union | North Carolina | 37179 | 56693 | 420 |
2166431 | 2166431 | 2022-01-30 | Vance | North Carolina | 37181 | 10959 | 110 |
2166432 | 2166432 | 2022-01-30 | Wake | North Carolina | 37183 | 260534 | 967 |
2166433 | 2166433 | 2022-01-30 | Warren | North Carolina | 37185 | 3867 | 37 |
2166434 | 2166434 | 2022-01-30 | Washington | North Carolina | 37187 | 2743 | 41 |
2166435 | 2166435 | 2022-01-30 | Watauga | North Carolina | 37189 | 10272 | 48 |
2166436 | 2166436 | 2022-01-30 | Wayne | North Carolina | 37191 | 25542 | 351 |
2166437 | 2166437 | 2022-01-30 | Wilkes | North Carolina | 37193 | 15610 | 219 |
2166438 | 2166438 | 2022-01-30 | Wilson | North Carolina | 37195 | 19451 | 244 |
2166439 | 2166439 | 2022-01-30 | Yadkin | North Carolina | 37197 | 9699 | 98 |
2166440 | 2166440 | 2022-01-30 | Yancey | North Carolina | 37199 | 4368 | 45 |
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);