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-27 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 |
---|---|---|---|---|---|---|---|
2348471 | 2348471 | 2022-03-27 | Alamance | North Carolina | 37001 | 46663 | 451 |
2348472 | 2348472 | 2022-03-27 | Alexander | North Carolina | 37003 | 10399 | 133 |
2348473 | 2348473 | 2022-03-27 | Alleghany | North Carolina | 37005 | 2939 | 12 |
2348474 | 2348474 | 2022-03-27 | Anson | North Carolina | 37007 | 6542 | 96 |
2348475 | 2348475 | 2022-03-27 | Ashe | North Carolina | 37009 | 6363 | 73 |
2348476 | 2348476 | 2022-03-27 | Avery | North Carolina | 37011 | 4482 | 42 |
2348477 | 2348477 | 2022-03-27 | Beaufort | North Carolina | 37013 | 12326 | 160 |
2348478 | 2348478 | 2022-03-27 | Bertie | North Carolina | 37015 | 4228 | 67 |
2348479 | 2348479 | 2022-03-27 | Bladen | North Carolina | 37017 | 9308 | 121 |
2348480 | 2348480 | 2022-03-27 | Brunswick | North Carolina | 37019 | 29709 | 310 |
2348481 | 2348481 | 2022-03-27 | Buncombe | North Carolina | 37021 | 52110 | 558 |
2348482 | 2348482 | 2022-03-27 | Burke | North Carolina | 37023 | 24991 | 315 |
2348483 | 2348483 | 2022-03-27 | Cabarrus | North Carolina | 37025 | 55446 | 468 |
2348484 | 2348484 | 2022-03-27 | Caldwell | North Carolina | 37027 | 22074 | 298 |
2348485 | 2348485 | 2022-03-27 | Camden | North Carolina | 37029 | 1746 | 9 |
2348486 | 2348486 | 2022-03-27 | Carteret | North Carolina | 37031 | 14063 | 85 |
2348487 | 2348487 | 2022-03-27 | Caswell | North Carolina | 37033 | 5257 | 44 |
2348488 | 2348488 | 2022-03-27 | Catawba | North Carolina | 37035 | 47393 | 564 |
2348489 | 2348489 | 2022-03-27 | Chatham | North Carolina | 37037 | 12710 | 108 |
2348490 | 2348490 | 2022-03-27 | Cherokee | North Carolina | 37039 | 7093 | 117 |
2348491 | 2348491 | 2022-03-27 | Chowan | North Carolina | 37041 | 4120 | 54 |
2348492 | 2348492 | 2022-03-27 | Clay | North Carolina | 37043 | 2636 | 39 |
2348493 | 2348493 | 2022-03-27 | Cleveland | North Carolina | 37045 | 29522 | 364 |
2348494 | 2348494 | 2022-03-27 | Columbus | North Carolina | 37047 | 15905 | 266 |
2348495 | 2348495 | 2022-03-27 | Craven | North Carolina | 37049 | 24089 | 194 |
2348496 | 2348496 | 2022-03-27 | Cumberland | North Carolina | 37051 | 83724 | 562 |
2348497 | 2348497 | 2022-03-27 | Currituck | North Carolina | 37053 | 4968 | 32 |
2348498 | 2348498 | 2022-03-27 | Dare | North Carolina | 37055 | 7362 | 23 |
2348499 | 2348499 | 2022-03-27 | Davidson | North Carolina | 37057 | 42955 | 393 |
2348500 | 2348500 | 2022-03-27 | Davie | North Carolina | 37059 | 11102 | 93 |
2348501 | 2348501 | 2022-03-27 | Duplin | North Carolina | 37061 | 16798 | 238 |
2348502 | 2348502 | 2022-03-27 | Durham | North Carolina | 37063 | 72184 | 298 |
2348503 | 2348503 | 2022-03-27 | Edgecombe | North Carolina | 37065 | 13464 | 141 |
2348504 | 2348504 | 2022-03-27 | Forsyth | North Carolina | 37067 | 91968 | 790 |
2348505 | 2348505 | 2022-03-27 | Franklin | North Carolina | 37069 | 20214 | 65 |
2348506 | 2348506 | 2022-03-27 | Gaston | North Carolina | 37071 | 65011 | 792 |
2348507 | 2348507 | 2022-03-27 | Gates | North Carolina | 37073 | 1887 | 19 |
2348508 | 2348508 | 2022-03-27 | Graham | North Carolina | 37075 | 2267 | 29 |
2348509 | 2348509 | 2022-03-27 | Granville | North Carolina | 37077 | 14196 | 111 |
2348510 | 2348510 | 2022-03-27 | Greene | North Carolina | 37079 | 5772 | 61 |
2348511 | 2348511 | 2022-03-27 | Guilford | North Carolina | 37081 | 116190 | 1156 |
2348512 | 2348512 | 2022-03-27 | Halifax | North Carolina | 37083 | 13905 | 181 |
2348513 | 2348513 | 2022-03-27 | Harnett | North Carolina | 37085 | 32695 | 327 |
2348514 | 2348514 | 2022-03-27 | Haywood | North Carolina | 37087 | 12896 | 198 |
2348515 | 2348515 | 2022-03-27 | Henderson | North Carolina | 37089 | 24845 | 293 |
2348516 | 2348516 | 2022-03-27 | Hertford | North Carolina | 37091 | 4712 | 81 |
2348517 | 2348517 | 2022-03-27 | Hoke | North Carolina | 37093 | 14607 | 103 |
2348518 | 2348518 | 2022-03-27 | Hyde | North Carolina | 37095 | 1310 | 13 |
2348519 | 2348519 | 2022-03-27 | Iredell | North Carolina | 37097 | 48251 | 443 |
2348520 | 2348520 | 2022-03-27 | Jackson | North Carolina | 37099 | 9302 | 86 |
2348521 | 2348521 | 2022-03-27 | Johnston | North Carolina | 37101 | 58971 | 432 |
2348522 | 2348522 | 2022-03-27 | Jones | North Carolina | 37103 | 2207 | 38 |
2348523 | 2348523 | 2022-03-27 | Lee | North Carolina | 37105 | 15899 | 144 |
2348524 | 2348524 | 2022-03-27 | Lenoir | North Carolina | 37107 | 15710 | 204 |
2348525 | 2348525 | 2022-03-27 | Lincoln | North Carolina | 37109 | 24273 | 158 |
2348526 | 2348526 | 2022-03-27 | Macon | North Carolina | 37113 | 7666 | 112 |
2348527 | 2348527 | 2022-03-27 | Madison | North Carolina | 37115 | 5059 | 79 |
2348528 | 2348528 | 2022-03-27 | Martin | North Carolina | 37117 | 6045 | 89 |
2348529 | 2348529 | 2022-03-27 | McDowell | North Carolina | 37111 | 13647 | 167 |
2348530 | 2348530 | 2022-03-27 | Mecklenburg | North Carolina | 37119 | 277286 | 1556 |
2348531 | 2348531 | 2022-03-27 | Mitchell | North Carolina | 37121 | 3377 | 34 |
2348532 | 2348532 | 2022-03-27 | Montgomery | North Carolina | 37123 | 7254 | 126 |
2348533 | 2348533 | 2022-03-27 | Moore | North Carolina | 37125 | 24107 | 318 |
2348534 | 2348534 | 2022-03-27 | Nash | North Carolina | 37127 | 26758 | 297 |
2348535 | 2348535 | 2022-03-27 | New Hanover | North Carolina | 37129 | 50095 | 384 |
2348536 | 2348536 | 2022-03-27 | Northampton | North Carolina | 37131 | 4312 | 82 |
2348537 | 2348537 | 2022-03-27 | Onslow | North Carolina | 37133 | 51767 | 374 |
2348538 | 2348538 | 2022-03-27 | Orange | North Carolina | 37135 | 25966 | 124 |
2348539 | 2348539 | 2022-03-27 | Pamlico | North Carolina | 37137 | 2592 | 27 |
2348540 | 2348540 | 2022-03-27 | Pasquotank | North Carolina | 37139 | 8463 | 111 |
2348541 | 2348541 | 2022-03-27 | Pender | North Carolina | 37141 | 15215 | 118 |
2348542 | 2348542 | 2022-03-27 | Perquimans | North Carolina | 37143 | 2741 | 18 |
2348543 | 2348543 | 2022-03-27 | Person | North Carolina | 37145 | 9248 | 104 |
2348544 | 2348544 | 2022-03-27 | Pitt | North Carolina | 37147 | 52324 | 168 |
2348545 | 2348545 | 2022-03-27 | Polk | North Carolina | 37149 | 3840 | 54 |
2348546 | 2348546 | 2022-03-27 | Randolph | North Carolina | 37151 | 35410 | 401 |
2348547 | 2348547 | 2022-03-27 | Richmond | North Carolina | 37153 | 12768 | 185 |
2348548 | 2348548 | 2022-03-27 | Robeson | North Carolina | 37155 | 40366 | 523 |
2348549 | 2348549 | 2022-03-27 | Rockingham | North Carolina | 37157 | 21902 | 267 |
2348550 | 2348550 | 2022-03-27 | Rowan | North Carolina | 37159 | 41071 | 566 |
2348551 | 2348551 | 2022-03-27 | Rutherford | North Carolina | 37161 | 17443 | 397 |
2348552 | 2348552 | 2022-03-27 | Sampson | North Carolina | 37163 | 18691 | 169 |
2348553 | 2348553 | 2022-03-27 | Scotland | North Carolina | 37165 | 9960 | 126 |
2348554 | 2348554 | 2022-03-27 | Stanly | North Carolina | 37167 | 19395 | 249 |
2348555 | 2348555 | 2022-03-27 | Stokes | North Carolina | 37169 | 11156 | 171 |
2348556 | 2348556 | 2022-03-27 | Surry | North Carolina | 37171 | 20990 | 331 |
2348557 | 2348557 | 2022-03-27 | Swain | North Carolina | 37173 | 3473 | 38 |
2348558 | 2348558 | 2022-03-27 | Transylvania | North Carolina | 37175 | 6115 | 71 |
2348559 | 2348559 | 2022-03-27 | Tyrrell | North Carolina | 37177 | 974 | 8 |
2348560 | 2348560 | 2022-03-27 | Union | North Carolina | 37179 | 61441 | 478 |
2348561 | 2348561 | 2022-03-27 | Vance | North Carolina | 37181 | 11822 | 112 |
2348562 | 2348562 | 2022-03-27 | Wake | North Carolina | 37183 | 289690 | 1045 |
2348563 | 2348563 | 2022-03-27 | Warren | North Carolina | 37185 | 4303 | 39 |
2348564 | 2348564 | 2022-03-27 | Washington | North Carolina | 37187 | 3010 | 50 |
2348565 | 2348565 | 2022-03-27 | Watauga | North Carolina | 37189 | 12297 | 58 |
2348566 | 2348566 | 2022-03-27 | Wayne | North Carolina | 37191 | 29613 | 384 |
2348567 | 2348567 | 2022-03-27 | Wilkes | North Carolina | 37193 | 17510 | 256 |
2348568 | 2348568 | 2022-03-27 | Wilson | North Carolina | 37195 | 21555 | 304 |
2348569 | 2348569 | 2022-03-27 | Yadkin | North Carolina | 37197 | 10746 | 111 |
2348570 | 2348570 | 2022-03-27 | Yancey | North Carolina | 37199 | 4994 | 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);