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-11-04 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 |
---|---|---|---|---|---|---|---|
698427 | 698427 | 2020-11-04 | Alamance | North Carolina | 37001 | 5493 | 89 |
698428 | 698428 | 2020-11-04 | Alexander | North Carolina | 37003 | 1024 | 10 |
698429 | 698429 | 2020-11-04 | Alleghany | North Carolina | 37005 | 326 | 1 |
698430 | 698430 | 2020-11-04 | Anson | North Carolina | 37007 | 747 | 12 |
698431 | 698431 | 2020-11-04 | Ashe | North Carolina | 37009 | 513 | 3 |
698432 | 698432 | 2020-11-04 | Avery | North Carolina | 37011 | 668 | 2 |
698433 | 698433 | 2020-11-04 | Beaufort | North Carolina | 37013 | 1453 | 46 |
698434 | 698434 | 2020-11-04 | Bertie | North Carolina | 37015 | 743 | 21 |
698435 | 698435 | 2020-11-04 | Bladen | North Carolina | 37017 | 1121 | 19 |
698436 | 698436 | 2020-11-04 | Brunswick | North Carolina | 37019 | 2296 | 52 |
698437 | 698437 | 2020-11-04 | Buncombe | North Carolina | 37021 | 4385 | 119 |
698438 | 698438 | 2020-11-04 | Burke | North Carolina | 37023 | 2869 | 53 |
698439 | 698439 | 2020-11-04 | Cabarrus | North Carolina | 37025 | 5189 | 95 |
698440 | 698440 | 2020-11-04 | Caldwell | North Carolina | 37027 | 2758 | 19 |
698441 | 698441 | 2020-11-04 | Camden | North Carolina | 37029 | 144 | 3 |
698442 | 698442 | 2020-11-04 | Carteret | North Carolina | 37031 | 1248 | 5 |
698443 | 698443 | 2020-11-04 | Caswell | North Carolina | 37033 | 655 | 5 |
698444 | 698444 | 2020-11-04 | Catawba | North Carolina | 37035 | 4880 | 62 |
698445 | 698445 | 2020-11-04 | Chatham | North Carolina | 37037 | 2002 | 62 |
698446 | 698446 | 2020-11-04 | Cherokee | North Carolina | 37039 | 798 | 15 |
698447 | 698447 | 2020-11-04 | Chowan | North Carolina | 37041 | 546 | 15 |
698448 | 698448 | 2020-11-04 | Clay | North Carolina | 37043 | 249 | 3 |
698449 | 698449 | 2020-11-04 | Cleveland | North Carolina | 37045 | 3427 | 88 |
698450 | 698450 | 2020-11-04 | Columbus | North Carolina | 37047 | 1815 | 64 |
698451 | 698451 | 2020-11-04 | Craven | North Carolina | 37049 | 2485 | 63 |
698452 | 698452 | 2020-11-04 | Cumberland | North Carolina | 37051 | 7484 | 102 |
698453 | 698453 | 2020-11-04 | Currituck | North Carolina | 37053 | 232 | 4 |
698454 | 698454 | 2020-11-04 | Dare | North Carolina | 37055 | 400 | 3 |
698455 | 698455 | 2020-11-04 | Davidson | North Carolina | 37057 | 3935 | 46 |
698456 | 698456 | 2020-11-04 | Davie | North Carolina | 37059 | 812 | 8 |
698457 | 698457 | 2020-11-04 | Duplin | North Carolina | 37061 | 2905 | 54 |
698458 | 698458 | 2020-11-04 | Durham | North Carolina | 37063 | 9511 | 104 |
698459 | 698459 | 2020-11-04 | Edgecombe | North Carolina | 37065 | 2114 | 61 |
698460 | 698460 | 2020-11-04 | Forsyth | North Carolina | 37067 | 9436 | 125 |
698461 | 698461 | 2020-11-04 | Franklin | North Carolina | 37069 | 1528 | 32 |
698462 | 698462 | 2020-11-04 | Gaston | North Carolina | 37071 | 8034 | 143 |
698463 | 698463 | 2020-11-04 | Gates | North Carolina | 37073 | 172 | 3 |
698464 | 698464 | 2020-11-04 | Graham | North Carolina | 37075 | 253 | 9 |
698465 | 698465 | 2020-11-04 | Granville | North Carolina | 37077 | 2100 | 51 |
698466 | 698466 | 2020-11-04 | Greene | North Carolina | 37079 | 985 | 15 |
698467 | 698467 | 2020-11-04 | Guilford | North Carolina | 37081 | 12272 | 213 |
698468 | 698468 | 2020-11-04 | Halifax | North Carolina | 37083 | 1526 | 29 |
698469 | 698469 | 2020-11-04 | Harnett | North Carolina | 37085 | 3122 | 72 |
698470 | 698470 | 2020-11-04 | Haywood | North Carolina | 37087 | 772 | 36 |
698471 | 698471 | 2020-11-04 | Henderson | North Carolina | 37089 | 2612 | 68 |
698472 | 698472 | 2020-11-04 | Hertford | North Carolina | 37091 | 873 | 35 |
698473 | 698473 | 2020-11-04 | Hoke | North Carolina | 37093 | 1620 | 25 |
698474 | 698474 | 2020-11-04 | Hyde | North Carolina | 37095 | 177 | 5 |
698475 | 698475 | 2020-11-04 | Iredell | North Carolina | 37097 | 4084 | 34 |
698476 | 698476 | 2020-11-04 | Jackson | North Carolina | 37099 | 1149 | 7 |
698477 | 698477 | 2020-11-04 | Johnston | North Carolina | 37101 | 6062 | 68 |
698478 | 698478 | 2020-11-04 | Jones | North Carolina | 37103 | 206 | 15 |
698479 | 698479 | 2020-11-04 | Lee | North Carolina | 37105 | 2189 | 22 |
698480 | 698480 | 2020-11-04 | Lenoir | North Carolina | 37107 | 1563 | 42 |
698481 | 698481 | 2020-11-04 | Lincoln | North Carolina | 37109 | 2610 | 16 |
698482 | 698482 | 2020-11-04 | Macon | North Carolina | 37113 | 783 | 7 |
698483 | 698483 | 2020-11-04 | Madison | North Carolina | 37115 | 311 | 5 |
698484 | 698484 | 2020-11-04 | Martin | North Carolina | 37117 | 688 | 20 |
698485 | 698485 | 2020-11-04 | McDowell | North Carolina | 37111 | 1407 | 34 |
698486 | 698486 | 2020-11-04 | Mecklenburg | North Carolina | 37119 | 35390 | 403 |
698487 | 698487 | 2020-11-04 | Mitchell | North Carolina | 37121 | 282 | 4 |
698488 | 698488 | 2020-11-04 | Montgomery | North Carolina | 37123 | 1228 | 38 |
698489 | 698489 | 2020-11-04 | Moore | North Carolina | 37125 | 2354 | 50 |
698490 | 698490 | 2020-11-04 | Nash | North Carolina | 37127 | 3642 | 83 |
698491 | 698491 | 2020-11-04 | New Hanover | North Carolina | 37129 | 5551 | 40 |
698492 | 698492 | 2020-11-04 | Northampton | North Carolina | 37131 | 602 | 22 |
698493 | 698493 | 2020-11-04 | Onslow | North Carolina | 37133 | 3695 | 32 |
698494 | 698494 | 2020-11-04 | Orange | North Carolina | 37135 | 3213 | 59 |
698495 | 698495 | 2020-11-04 | Pamlico | North Carolina | 37137 | 334 | 3 |
698496 | 698496 | 2020-11-04 | Pasquotank | North Carolina | 37139 | 909 | 35 |
698497 | 698497 | 2020-11-04 | Pender | North Carolina | 37141 | 1486 | 17 |
698498 | 698498 | 2020-11-04 | Perquimans | North Carolina | 37143 | 266 | 4 |
698499 | 698499 | 2020-11-04 | Person | North Carolina | 37145 | 734 | 10 |
698500 | 698500 | 2020-11-04 | Pitt | North Carolina | 37147 | 6445 | 41 |
698501 | 698501 | 2020-11-04 | Polk | North Carolina | 37149 | 410 | 13 |
698502 | 698502 | 2020-11-04 | Randolph | North Carolina | 37151 | 4081 | 68 |
698503 | 698503 | 2020-11-04 | Richmond | North Carolina | 37153 | 1500 | 34 |
698504 | 698504 | 2020-11-04 | Robeson | North Carolina | 37155 | 6309 | 101 |
698505 | 698505 | 2020-11-04 | Rockingham | North Carolina | 37157 | 2211 | 19 |
698506 | 698506 | 2020-11-04 | Rowan | North Carolina | 37159 | 4354 | 121 |
698507 | 698507 | 2020-11-04 | Rutherford | North Carolina | 37161 | 1829 | 74 |
698508 | 698508 | 2020-11-04 | Sampson | North Carolina | 37163 | 2940 | 31 |
698509 | 698509 | 2020-11-04 | Scotland | North Carolina | 37165 | 1701 | 29 |
698510 | 698510 | 2020-11-04 | Stanly | North Carolina | 37167 | 2499 | 74 |
698511 | 698511 | 2020-11-04 | Stokes | North Carolina | 37169 | 747 | 13 |
698512 | 698512 | 2020-11-04 | Surry | North Carolina | 37171 | 2050 | 36 |
698513 | 698513 | 2020-11-04 | Swain | North Carolina | 37173 | 308 | 5 |
698514 | 698514 | 2020-11-04 | Transylvania | North Carolina | 37175 | 445 | 9 |
698515 | 698515 | 2020-11-04 | Tyrrell | North Carolina | 37177 | 132 | 3 |
698516 | 698516 | 2020-11-04 | Union | North Carolina | 37179 | 6244 | 66 |
698517 | 698517 | 2020-11-04 | Vance | North Carolina | 37181 | 1265 | 47 |
698518 | 698518 | 2020-11-04 | Wake | North Carolina | 37183 | 22617 | 277 |
698519 | 698519 | 2020-11-04 | Warren | North Carolina | 37185 | 503 | 7 |
698520 | 698520 | 2020-11-04 | Washington | North Carolina | 37187 | 273 | 8 |
698521 | 698521 | 2020-11-04 | Watauga | North Carolina | 37189 | 1462 | 6 |
698522 | 698522 | 2020-11-04 | Wayne | North Carolina | 37191 | 4851 | 91 |
698523 | 698523 | 2020-11-04 | Wilkes | North Carolina | 37193 | 1937 | 41 |
698524 | 698524 | 2020-11-04 | Wilson | North Carolina | 37195 | 3248 | 69 |
698525 | 698525 | 2020-11-04 | Yadkin | North Carolina | 37197 | 1123 | 11 |
698526 | 698526 | 2020-11-04 | Yancey | North Carolina | 37199 | 349 | 2 |
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);