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-10-27 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 |
---|---|---|---|---|---|---|---|
672481 | 672481 | 2020-10-27 | Alamance | North Carolina | 37001 | 5147 | 79 |
672482 | 672482 | 2020-10-27 | Alexander | North Carolina | 37003 | 851 | 9 |
672483 | 672483 | 2020-10-27 | Alleghany | North Carolina | 37005 | 296 | 2 |
672484 | 672484 | 2020-10-27 | Anson | North Carolina | 37007 | 723 | 9 |
672485 | 672485 | 2020-10-27 | Ashe | North Carolina | 37009 | 432 | 3 |
672486 | 672486 | 2020-10-27 | Avery | North Carolina | 37011 | 619 | 0 |
672487 | 672487 | 2020-10-27 | Beaufort | North Carolina | 37013 | 1362 | 42 |
672488 | 672488 | 2020-10-27 | Bertie | North Carolina | 37015 | 727 | 19 |
672489 | 672489 | 2020-10-27 | Bladen | North Carolina | 37017 | 1080 | 19 |
672490 | 672490 | 2020-10-27 | Brunswick | North Carolina | 37019 | 2168 | 45 |
672491 | 672491 | 2020-10-27 | Buncombe | North Carolina | 37021 | 4088 | 112 |
672492 | 672492 | 2020-10-27 | Burke | North Carolina | 37023 | 2654 | 48 |
672493 | 672493 | 2020-10-27 | Cabarrus | North Carolina | 37025 | 4850 | 91 |
672494 | 672494 | 2020-10-27 | Caldwell | North Carolina | 37027 | 2476 | 19 |
672495 | 672495 | 2020-10-27 | Camden | North Carolina | 37029 | 135 | 3 |
672496 | 672496 | 2020-10-27 | Carteret | North Carolina | 37031 | 1125 | 5 |
672497 | 672497 | 2020-10-27 | Caswell | North Carolina | 37033 | 620 | 5 |
672498 | 672498 | 2020-10-27 | Catawba | North Carolina | 37035 | 4375 | 61 |
672499 | 672499 | 2020-10-27 | Chatham | North Carolina | 37037 | 1925 | 61 |
672500 | 672500 | 2020-10-27 | Cherokee | North Carolina | 37039 | 773 | 14 |
672501 | 672501 | 2020-10-27 | Chowan | North Carolina | 37041 | 526 | 10 |
672502 | 672502 | 2020-10-27 | Clay | North Carolina | 37043 | 222 | 3 |
672503 | 672503 | 2020-10-27 | Cleveland | North Carolina | 37045 | 3132 | 85 |
672504 | 672504 | 2020-10-27 | Columbus | North Carolina | 37047 | 1673 | 62 |
672505 | 672505 | 2020-10-27 | Craven | North Carolina | 37049 | 2314 | 60 |
672506 | 672506 | 2020-10-27 | Cumberland | North Carolina | 37051 | 6974 | 98 |
672507 | 672507 | 2020-10-27 | Currituck | North Carolina | 37053 | 222 | 4 |
672508 | 672508 | 2020-10-27 | Dare | North Carolina | 37055 | 368 | 3 |
672509 | 672509 | 2020-10-27 | Davidson | North Carolina | 37057 | 3677 | 43 |
672510 | 672510 | 2020-10-27 | Davie | North Carolina | 37059 | 753 | 8 |
672511 | 672511 | 2020-10-27 | Duplin | North Carolina | 37061 | 2774 | 54 |
672512 | 672512 | 2020-10-27 | Durham | North Carolina | 37063 | 9002 | 102 |
672513 | 672513 | 2020-10-27 | Edgecombe | North Carolina | 37065 | 1973 | 56 |
672514 | 672514 | 2020-10-27 | Forsyth | North Carolina | 37067 | 8756 | 119 |
672515 | 672515 | 2020-10-27 | Franklin | North Carolina | 37069 | 1449 | 32 |
672516 | 672516 | 2020-10-27 | Gaston | North Carolina | 37071 | 7302 | 115 |
672517 | 672517 | 2020-10-27 | Gates | North Carolina | 37073 | 167 | 3 |
672518 | 672518 | 2020-10-27 | Graham | North Carolina | 37075 | 246 | 8 |
672519 | 672519 | 2020-10-27 | Granville | North Carolina | 37077 | 2031 | 50 |
672520 | 672520 | 2020-10-27 | Greene | North Carolina | 37079 | 951 | 13 |
672521 | 672521 | 2020-10-27 | Guilford | North Carolina | 37081 | 11278 | 205 |
672522 | 672522 | 2020-10-27 | Halifax | North Carolina | 37083 | 1394 | 27 |
672523 | 672523 | 2020-10-27 | Harnett | North Carolina | 37085 | 2901 | 68 |
672524 | 672524 | 2020-10-27 | Haywood | North Carolina | 37087 | 710 | 36 |
672525 | 672525 | 2020-10-27 | Henderson | North Carolina | 37089 | 2504 | 67 |
672526 | 672526 | 2020-10-27 | Hertford | North Carolina | 37091 | 853 | 34 |
672527 | 672527 | 2020-10-27 | Hoke | North Carolina | 37093 | 1539 | 25 |
672528 | 672528 | 2020-10-27 | Hyde | North Carolina | 37095 | 175 | 5 |
672529 | 672529 | 2020-10-27 | Iredell | North Carolina | 37097 | 3785 | 34 |
672530 | 672530 | 2020-10-27 | Jackson | North Carolina | 37099 | 1036 | 7 |
672531 | 672531 | 2020-10-27 | Johnston | North Carolina | 37101 | 5687 | 66 |
672532 | 672532 | 2020-10-27 | Jones | North Carolina | 37103 | 199 | 15 |
672533 | 672533 | 2020-10-27 | Lee | North Carolina | 37105 | 2079 | 20 |
672534 | 672534 | 2020-10-27 | Lenoir | North Carolina | 37107 | 1437 | 40 |
672535 | 672535 | 2020-10-27 | Lincoln | North Carolina | 37109 | 2361 | 16 |
672536 | 672536 | 2020-10-27 | Macon | North Carolina | 37113 | 752 | 7 |
672537 | 672537 | 2020-10-27 | Madison | North Carolina | 37115 | 244 | 1 |
672538 | 672538 | 2020-10-27 | Martin | North Carolina | 37117 | 636 | 17 |
672539 | 672539 | 2020-10-27 | McDowell | North Carolina | 37111 | 1313 | 32 |
672540 | 672540 | 2020-10-27 | Mecklenburg | North Carolina | 37119 | 33552 | 386 |
672541 | 672541 | 2020-10-27 | Mitchell | North Carolina | 37121 | 219 | 4 |
672542 | 672542 | 2020-10-27 | Montgomery | North Carolina | 37123 | 1184 | 38 |
672543 | 672543 | 2020-10-27 | Moore | North Carolina | 37125 | 2251 | 40 |
672544 | 672544 | 2020-10-27 | Nash | North Carolina | 37127 | 3334 | 73 |
672545 | 672545 | 2020-10-27 | New Hanover | North Carolina | 37129 | 5229 | 37 |
672546 | 672546 | 2020-10-27 | Northampton | North Carolina | 37131 | 559 | 19 |
672547 | 672547 | 2020-10-27 | Onslow | North Carolina | 37133 | 3268 | 28 |
672548 | 672548 | 2020-10-27 | Orange | North Carolina | 37135 | 3079 | 58 |
672549 | 672549 | 2020-10-27 | Pamlico | North Carolina | 37137 | 315 | 2 |
672550 | 672550 | 2020-10-27 | Pasquotank | North Carolina | 37139 | 863 | 35 |
672551 | 672551 | 2020-10-27 | Pender | North Carolina | 37141 | 1383 | 12 |
672552 | 672552 | 2020-10-27 | Perquimans | North Carolina | 37143 | 246 | 4 |
672553 | 672553 | 2020-10-27 | Person | North Carolina | 37145 | 661 | 10 |
672554 | 672554 | 2020-10-27 | Pitt | North Carolina | 37147 | 6113 | 38 |
672555 | 672555 | 2020-10-27 | Polk | North Carolina | 37149 | 396 | 11 |
672556 | 672556 | 2020-10-27 | Randolph | North Carolina | 37151 | 3730 | 62 |
672557 | 672557 | 2020-10-27 | Richmond | North Carolina | 37153 | 1410 | 29 |
672558 | 672558 | 2020-10-27 | Robeson | North Carolina | 37155 | 5977 | 95 |
672559 | 672559 | 2020-10-27 | Rockingham | North Carolina | 37157 | 1956 | 19 |
672560 | 672560 | 2020-10-27 | Rowan | North Carolina | 37159 | 4102 | 117 |
672561 | 672561 | 2020-10-27 | Rutherford | North Carolina | 37161 | 1742 | 59 |
672562 | 672562 | 2020-10-27 | Sampson | North Carolina | 37163 | 2724 | 32 |
672563 | 672563 | 2020-10-27 | Scotland | North Carolina | 37165 | 1621 | 24 |
672564 | 672564 | 2020-10-27 | Stanly | North Carolina | 37167 | 2431 | 60 |
672565 | 672565 | 2020-10-27 | Stokes | North Carolina | 37169 | 673 | 10 |
672566 | 672566 | 2020-10-27 | Surry | North Carolina | 37171 | 1810 | 30 |
672567 | 672567 | 2020-10-27 | Swain | North Carolina | 37173 | 276 | 4 |
672568 | 672568 | 2020-10-27 | Transylvania | North Carolina | 37175 | 409 | 9 |
672569 | 672569 | 2020-10-27 | Tyrrell | North Carolina | 37177 | 131 | 3 |
672570 | 672570 | 2020-10-27 | Union | North Carolina | 37179 | 5883 | 64 |
672571 | 672571 | 2020-10-27 | Vance | North Carolina | 37181 | 1196 | 47 |
672572 | 672572 | 2020-10-27 | Wake | North Carolina | 37183 | 21214 | 270 |
672573 | 672573 | 2020-10-27 | Warren | North Carolina | 37185 | 423 | 7 |
672574 | 672574 | 2020-10-27 | Washington | North Carolina | 37187 | 250 | 8 |
672575 | 672575 | 2020-10-27 | Watauga | North Carolina | 37189 | 1392 | 6 |
672576 | 672576 | 2020-10-27 | Wayne | North Carolina | 37191 | 4525 | 80 |
672577 | 672577 | 2020-10-27 | Wilkes | North Carolina | 37193 | 1705 | 38 |
672578 | 672578 | 2020-10-27 | Wilson | North Carolina | 37195 | 2964 | 63 |
672579 | 672579 | 2020-10-27 | Yadkin | North Carolina | 37197 | 1003 | 9 |
672580 | 672580 | 2020-10-27 | Yancey | North Carolina | 37199 | 314 | 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);