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 2020-07-29 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
381386 | 381386 | 2020-07-29 | Alamance | North Carolina | 37001 | 2066 | 41 |
381387 | 381387 | 2020-07-29 | Alexander | North Carolina | 37003 | 258 | 3 |
381388 | 381388 | 2020-07-29 | Alleghany | North Carolina | 37005 | 64 | 0 |
381389 | 381389 | 2020-07-29 | Anson | North Carolina | 37007 | 295 | 2 |
381390 | 381390 | 2020-07-29 | Ashe | North Carolina | 37009 | 97 | 1 |
381391 | 381391 | 2020-07-29 | Avery | North Carolina | 37011 | 72 | 0 |
381392 | 381392 | 2020-07-29 | Beaufort | North Carolina | 37013 | 306 | 1 |
381393 | 381393 | 2020-07-29 | Bertie | North Carolina | 37015 | 222 | 4 |
381394 | 381394 | 2020-07-29 | Bladen | North Carolina | 37017 | 549 | 6 |
381395 | 381395 | 2020-07-29 | Brunswick | North Carolina | 37019 | 1137 | 15 |
381396 | 381396 | 2020-07-29 | Buncombe | North Carolina | 37021 | 1538 | 55 |
381397 | 381397 | 2020-07-29 | Burke | North Carolina | 37023 | 1488 | 25 |
381398 | 381398 | 2020-07-29 | Cabarrus | North Carolina | 37025 | 2248 | 41 |
381399 | 381399 | 2020-07-29 | Caldwell | North Carolina | 37027 | 1022 | 9 |
381400 | 381400 | 2020-07-29 | Camden | North Carolina | 37029 | 53 | 2 |
381401 | 381401 | 2020-07-29 | Carteret | North Carolina | 37031 | 272 | 4 |
381402 | 381402 | 2020-07-29 | Caswell | North Carolina | 37033 | 173 | 2 |
381403 | 381403 | 2020-07-29 | Catawba | North Carolina | 37035 | 1801 | 22 |
381404 | 381404 | 2020-07-29 | Chatham | North Carolina | 37037 | 1193 | 49 |
381405 | 381405 | 2020-07-29 | Cherokee | North Carolina | 37039 | 214 | 3 |
381406 | 381406 | 2020-07-29 | Chowan | North Carolina | 37041 | 109 | 0 |
381407 | 381407 | 2020-07-29 | Clay | North Carolina | 37043 | 53 | 0 |
381408 | 381408 | 2020-07-29 | Cleveland | North Carolina | 37045 | 910 | 13 |
381409 | 381409 | 2020-07-29 | Columbus | North Carolina | 37047 | 775 | 44 |
381410 | 381410 | 2020-07-29 | Craven | North Carolina | 37049 | 600 | 9 |
381411 | 381411 | 2020-07-29 | Cumberland | North Carolina | 37051 | 2494 | 49 |
381412 | 381412 | 2020-07-29 | Currituck | North Carolina | 37053 | 69 | 0 |
381413 | 381413 | 2020-07-29 | Dare | North Carolina | 37055 | 187 | 1 |
381414 | 381414 | 2020-07-29 | Davidson | North Carolina | 37057 | 1578 | 16 |
381415 | 381415 | 2020-07-29 | Davie | North Carolina | 37059 | 326 | 3 |
381416 | 381416 | 2020-07-29 | Duplin | North Carolina | 37061 | 1890 | 42 |
381417 | 381417 | 2020-07-29 | Durham | North Carolina | 37063 | 5659 | 77 |
381418 | 381418 | 2020-07-29 | Edgecombe | North Carolina | 37065 | 549 | 10 |
381419 | 381419 | 2020-07-29 | Forsyth | North Carolina | 37067 | 4703 | 49 |
381420 | 381420 | 2020-07-29 | Franklin | North Carolina | 37069 | 731 | 25 |
381421 | 381421 | 2020-07-29 | Gaston | North Carolina | 37071 | 2805 | 32 |
381422 | 381422 | 2020-07-29 | Gates | North Carolina | 37073 | 37 | 2 |
381423 | 381423 | 2020-07-29 | Graham | North Carolina | 37075 | 22 | 0 |
381424 | 381424 | 2020-07-29 | Granville | North Carolina | 37077 | 1125 | 25 |
381425 | 381425 | 2020-07-29 | Greene | North Carolina | 37079 | 284 | 3 |
381426 | 381426 | 2020-07-29 | Guilford | North Carolina | 37081 | 4932 | 140 |
381427 | 381427 | 2020-07-29 | Halifax | North Carolina | 37083 | 585 | 5 |
381428 | 381428 | 2020-07-29 | Harnett | North Carolina | 37085 | 1058 | 36 |
381429 | 381429 | 2020-07-29 | Haywood | North Carolina | 37087 | 255 | 2 |
381430 | 381430 | 2020-07-29 | Henderson | North Carolina | 37089 | 1321 | 54 |
381431 | 381431 | 2020-07-29 | Hertford | North Carolina | 37091 | 248 | 11 |
381432 | 381432 | 2020-07-29 | Hoke | North Carolina | 37093 | 645 | 7 |
381433 | 381433 | 2020-07-29 | Hyde | North Carolina | 37095 | 37 | 0 |
381434 | 381434 | 2020-07-29 | Iredell | North Carolina | 37097 | 1565 | 16 |
381435 | 381435 | 2020-07-29 | Jackson | North Carolina | 37099 | 374 | 3 |
381436 | 381436 | 2020-07-29 | Johnston | North Carolina | 37101 | 2844 | 44 |
381437 | 381437 | 2020-07-29 | Jones | North Carolina | 37103 | 54 | 3 |
381438 | 381438 | 2020-07-29 | Lee | North Carolina | 37105 | 1115 | 9 |
381439 | 381439 | 2020-07-29 | Lenoir | North Carolina | 37107 | 507 | 11 |
381440 | 381440 | 2020-07-29 | Lincoln | North Carolina | 37109 | 692 | 2 |
381441 | 381441 | 2020-07-29 | Macon | North Carolina | 37113 | 435 | 1 |
381442 | 381442 | 2020-07-29 | Madison | North Carolina | 37115 | 34 | 0 |
381443 | 381443 | 2020-07-29 | Martin | North Carolina | 37117 | 215 | 6 |
381444 | 381444 | 2020-07-29 | McDowell | North Carolina | 37111 | 493 | 5 |
381445 | 381445 | 2020-07-29 | Mecklenburg | North Carolina | 37119 | 19924 | 198 |
381446 | 381446 | 2020-07-29 | Mitchell | North Carolina | 37121 | 73 | 2 |
381447 | 381447 | 2020-07-29 | Montgomery | North Carolina | 37123 | 561 | 13 |
381448 | 381448 | 2020-07-29 | Moore | North Carolina | 37125 | 851 | 20 |
381449 | 381449 | 2020-07-29 | Nash | North Carolina | 37127 | 937 | 10 |
381450 | 381450 | 2020-07-29 | New Hanover | North Carolina | 37129 | 2198 | 18 |
381451 | 381451 | 2020-07-29 | Northampton | North Carolina | 37131 | 267 | 16 |
381452 | 381452 | 2020-07-29 | Onslow | North Carolina | 37133 | 773 | 9 |
381453 | 381453 | 2020-07-29 | Orange | North Carolina | 37135 | 1241 | 45 |
381454 | 381454 | 2020-07-29 | Pamlico | North Carolina | 37137 | 51 | 1 |
381455 | 381455 | 2020-07-29 | Pasquotank | North Carolina | 37139 | 314 | 17 |
381456 | 381456 | 2020-07-29 | Pender | North Carolina | 37141 | 582 | 3 |
381457 | 381457 | 2020-07-29 | Perquimans | North Carolina | 37143 | 58 | 2 |
381458 | 381458 | 2020-07-29 | Person | North Carolina | 37145 | 186 | 1 |
381459 | 381459 | 2020-07-29 | Pitt | North Carolina | 37147 | 1579 | 11 |
381460 | 381460 | 2020-07-29 | Polk | North Carolina | 37149 | 127 | 5 |
381461 | 381461 | 2020-07-29 | Randolph | North Carolina | 37151 | 1961 | 35 |
381462 | 381462 | 2020-07-29 | Richmond | North Carolina | 37153 | 467 | 8 |
381463 | 381463 | 2020-07-29 | Robeson | North Carolina | 37155 | 2459 | 51 |
381464 | 381464 | 2020-07-29 | Rockingham | North Carolina | 37157 | 428 | 3 |
381465 | 381465 | 2020-07-29 | Rowan | North Carolina | 37159 | 1913 | 46 |
381466 | 381466 | 2020-07-29 | Rutherford | North Carolina | 37161 | 626 | 14 |
381467 | 381467 | 2020-07-29 | Sampson | North Carolina | 37163 | 1394 | 10 |
381468 | 381468 | 2020-07-29 | Scotland | North Carolina | 37165 | 242 | 2 |
381469 | 381469 | 2020-07-29 | Stanly | North Carolina | 37167 | 827 | 8 |
381470 | 381470 | 2020-07-29 | Stokes | North Carolina | 37169 | 229 | 3 |
381471 | 381471 | 2020-07-29 | Surry | North Carolina | 37171 | 802 | 7 |
381472 | 381472 | 2020-07-29 | Swain | North Carolina | 37173 | 99 | 2 |
381473 | 381473 | 2020-07-29 | Transylvania | North Carolina | 37175 | 111 | 1 |
381474 | 381474 | 2020-07-29 | Tyrrell | North Carolina | 37177 | 89 | 1 |
381475 | 381475 | 2020-07-29 | Union | North Carolina | 37179 | 2624 | 39 |
381476 | 381476 | 2020-07-29 | Vance | North Carolina | 37181 | 703 | 40 |
381477 | 381477 | 2020-07-29 | Wake | North Carolina | 37183 | 10558 | 116 |
381478 | 381478 | 2020-07-29 | Warren | North Carolina | 37185 | 231 | 6 |
381479 | 381479 | 2020-07-29 | Washington | North Carolina | 37187 | 110 | 3 |
381480 | 381480 | 2020-07-29 | Watauga | North Carolina | 37189 | 218 | 0 |
381481 | 381481 | 2020-07-29 | Wayne | North Carolina | 37191 | 2249 | 36 |
381482 | 381482 | 2020-07-29 | Wilkes | North Carolina | 37193 | 713 | 9 |
381483 | 381483 | 2020-07-29 | Wilson | North Carolina | 37195 | 1338 | 32 |
381484 | 381484 | 2020-07-29 | Yadkin | North Carolina | 37197 | 461 | 6 |
381485 | 381485 | 2020-07-29 | Yancey | North Carolina | 37199 | 70 | 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);