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 2021-10-07 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 |
---|---|---|---|---|---|---|---|
1792527 | 1792527 | 2021-10-07 | Alamance | North Carolina | 37001 | 25442 | 321 |
1792528 | 1792528 | 2021-10-07 | Alexander | North Carolina | 37003 | 6205 | 111 |
1792529 | 1792529 | 2021-10-07 | Alleghany | North Carolina | 37005 | 1568 | 5 |
1792530 | 1792530 | 2021-10-07 | Anson | North Carolina | 37007 | 3711 | 75 |
1792531 | 1792531 | 2021-10-07 | Ashe | North Carolina | 37009 | 3317 | 46 |
1792532 | 1792532 | 2021-10-07 | Avery | North Carolina | 37011 | 2617 | 32 |
1792533 | 1792533 | 2021-10-07 | Beaufort | North Carolina | 37013 | 6769 | 122 |
1792534 | 1792534 | 2021-10-07 | Bertie | North Carolina | 37015 | 2381 | 49 |
1792535 | 1792535 | 2021-10-07 | Bladen | North Carolina | 37017 | 5348 | 93 |
1792536 | 1792536 | 2021-10-07 | Brunswick | North Carolina | 37019 | 15651 | 224 |
1792537 | 1792537 | 2021-10-07 | Buncombe | North Carolina | 37021 | 26719 | 409 |
1792538 | 1792538 | 2021-10-07 | Burke | North Carolina | 37023 | 15172 | 201 |
1792539 | 1792539 | 2021-10-07 | Cabarrus | North Carolina | 37025 | 31747 | 317 |
1792540 | 1792540 | 2021-10-07 | Caldwell | North Carolina | 37027 | 12808 | 197 |
1792541 | 1792541 | 2021-10-07 | Camden | North Carolina | 37029 | 1064 | 8 |
1792542 | 1792542 | 2021-10-07 | Carteret | North Carolina | 37031 | 7984 | 58 |
1792543 | 1792543 | 2021-10-07 | Caswell | North Carolina | 37033 | 3083 | 36 |
1792544 | 1792544 | 2021-10-07 | Catawba | North Carolina | 37035 | 27391 | 405 |
1792545 | 1792545 | 2021-10-07 | Chatham | North Carolina | 37037 | 6541 | 91 |
1792546 | 1792546 | 2021-10-07 | Cherokee | North Carolina | 37039 | 4532 | 74 |
1792547 | 1792547 | 2021-10-07 | Chowan | North Carolina | 37041 | 2205 | 40 |
1792548 | 1792548 | 2021-10-07 | Clay | North Carolina | 37043 | 1588 | 34 |
1792549 | 1792549 | 2021-10-07 | Cleveland | North Carolina | 37045 | 17619 | 293 |
1792550 | 1792550 | 2021-10-07 | Columbus | North Carolina | 37047 | 9803 | 217 |
1792551 | 1792551 | 2021-10-07 | Craven | North Carolina | 37049 | 13816 | 151 |
1792552 | 1792552 | 2021-10-07 | Cumberland | North Carolina | 37051 | 43172 | 446 |
1792553 | 1792553 | 2021-10-07 | Currituck | North Carolina | 37053 | 2585 | 25 |
1792554 | 1792554 | 2021-10-07 | Dare | North Carolina | 37055 | 3601 | 12 |
1792555 | 1792555 | 2021-10-07 | Davidson | North Carolina | 37057 | 24930 | 287 |
1792556 | 1792556 | 2021-10-07 | Davie | North Carolina | 37059 | 6112 | 67 |
1792557 | 1792557 | 2021-10-07 | Duplin | North Carolina | 37061 | 9621 | 172 |
1792558 | 1792558 | 2021-10-07 | Durham | North Carolina | 37063 | 34078 | 254 |
1792559 | 1792559 | 2021-10-07 | Edgecombe | North Carolina | 37065 | 7676 | 122 |
1792560 | 1792560 | 2021-10-07 | Forsyth | North Carolina | 37067 | 49851 | 526 |
1792561 | 1792561 | 2021-10-07 | Franklin | North Carolina | 37069 | 9449 | 60 |
1792562 | 1792562 | 2021-10-07 | Gaston | North Carolina | 37071 | 38491 | 579 |
1792563 | 1792563 | 2021-10-07 | Gates | North Carolina | 37073 | 1021 | 17 |
1792564 | 1792564 | 2021-10-07 | Graham | North Carolina | 37075 | 1284 | 27 |
1792565 | 1792565 | 2021-10-07 | Granville | North Carolina | 37077 | 7666 | 96 |
1792566 | 1792566 | 2021-10-07 | Greene | North Carolina | 37079 | 3208 | 53 |
1792567 | 1792567 | 2021-10-07 | Guilford | North Carolina | 37081 | 65233 | 842 |
1792568 | 1792568 | 2021-10-07 | Halifax | North Carolina | 37083 | 7542 | 132 |
1792569 | 1792569 | 2021-10-07 | Harnett | North Carolina | 37085 | 17661 | 241 |
1792570 | 1792570 | 2021-10-07 | Haywood | North Carolina | 37087 | 7059 | 135 |
1792571 | 1792571 | 2021-10-07 | Henderson | North Carolina | 37089 | 14598 | 190 |
1792572 | 1792572 | 2021-10-07 | Hertford | North Carolina | 37091 | 2705 | 69 |
1792573 | 1792573 | 2021-10-07 | Hoke | North Carolina | 37093 | 6916 | 76 |
1792574 | 1792574 | 2021-10-07 | Hyde | North Carolina | 37095 | 816 | 11 |
1792575 | 1792575 | 2021-10-07 | Iredell | North Carolina | 37097 | 27854 | 308 |
1792576 | 1792576 | 2021-10-07 | Jackson | North Carolina | 37099 | 5396 | 69 |
1792577 | 1792577 | 2021-10-07 | Johnston | North Carolina | 37101 | 31352 | 311 |
1792578 | 1792578 | 2021-10-07 | Jones | North Carolina | 37103 | 1280 | 29 |
1792579 | 1792579 | 2021-10-07 | Lee | North Carolina | 37105 | 9139 | 102 |
1792580 | 1792580 | 2021-10-07 | Lenoir | North Carolina | 37107 | 9233 | 146 |
1792581 | 1792581 | 2021-10-07 | Lincoln | North Carolina | 37109 | 14398 | 92 |
1792582 | 1792582 | 2021-10-07 | Macon | North Carolina | 37113 | 4741 | 54 |
1792583 | 1792583 | 2021-10-07 | Madison | North Carolina | 37115 | 2644 | 55 |
1792584 | 1792584 | 2021-10-07 | Martin | North Carolina | 37117 | 3497 | 63 |
1792585 | 1792585 | 2021-10-07 | McDowell | North Carolina | 37111 | 8276 | 114 |
1792586 | 1792586 | 2021-10-07 | Mecklenburg | North Carolina | 37119 | 152696 | 1182 |
1792587 | 1792587 | 2021-10-07 | Mitchell | North Carolina | 37121 | 1935 | 18 |
1792588 | 1792588 | 2021-10-07 | Montgomery | North Carolina | 37123 | 4375 | 108 |
1792589 | 1792589 | 2021-10-07 | Moore | North Carolina | 37125 | 13190 | 238 |
1792590 | 1792590 | 2021-10-07 | Nash | North Carolina | 37127 | 14921 | 223 |
1792591 | 1792591 | 2021-10-07 | New Hanover | North Carolina | 37129 | 27995 | 274 |
1792592 | 1792592 | 2021-10-07 | Northampton | North Carolina | 37131 | 2512 | 62 |
1792593 | 1792593 | 2021-10-07 | Onslow | North Carolina | 37133 | 27207 | 238 |
1792594 | 1792594 | 2021-10-07 | Orange | North Carolina | 37135 | 11393 | 109 |
1792595 | 1792595 | 2021-10-07 | Pamlico | North Carolina | 37137 | 1642 | 23 |
1792596 | 1792596 | 2021-10-07 | Pasquotank | North Carolina | 37139 | 4791 | 98 |
1792597 | 1792597 | 2021-10-07 | Pender | North Carolina | 37141 | 8576 | 95 |
1792598 | 1792598 | 2021-10-07 | Perquimans | North Carolina | 37143 | 1459 | 15 |
1792599 | 1792599 | 2021-10-07 | Person | North Carolina | 37145 | 4962 | 87 |
1792600 | 1792600 | 2021-10-07 | Pitt | North Carolina | 37147 | 28694 | 138 |
1792601 | 1792601 | 2021-10-07 | Polk | North Carolina | 37149 | 2235 | 42 |
1792602 | 1792602 | 2021-10-07 | Randolph | North Carolina | 37151 | 20846 | 295 |
1792603 | 1792603 | 2021-10-07 | Richmond | North Carolina | 37153 | 6918 | 134 |
1792604 | 1792604 | 2021-10-07 | Robeson | North Carolina | 37155 | 24467 | 414 |
1792605 | 1792605 | 2021-10-07 | Rockingham | North Carolina | 37157 | 11368 | 192 |
1792606 | 1792606 | 2021-10-07 | Rowan | North Carolina | 37159 | 25516 | 423 |
1792607 | 1792607 | 2021-10-07 | Rutherford | North Carolina | 37161 | 10921 | 293 |
1792608 | 1792608 | 2021-10-07 | Sampson | North Carolina | 37163 | 10887 | 127 |
1792609 | 1792609 | 2021-10-07 | Scotland | North Carolina | 37165 | 5547 | 104 |
1792610 | 1792610 | 2021-10-07 | Stanly | North Carolina | 37167 | 11229 | 173 |
1792611 | 1792611 | 2021-10-07 | Stokes | North Carolina | 37169 | 5903 | 100 |
1792612 | 1792612 | 2021-10-07 | Surry | North Carolina | 37171 | 11776 | 219 |
1792613 | 1792613 | 2021-10-07 | Swain | North Carolina | 37173 | 1885 | 22 |
1792614 | 1792614 | 2021-10-07 | Transylvania | North Carolina | 37175 | 3768 | 44 |
1792615 | 1792615 | 2021-10-07 | Tyrrell | North Carolina | 37177 | 529 | 7 |
1792616 | 1792616 | 2021-10-07 | Union | North Carolina | 37179 | 35059 | 304 |
1792617 | 1792617 | 2021-10-07 | Vance | North Carolina | 37181 | 6452 | 96 |
1792618 | 1792618 | 2021-10-07 | Wake | North Carolina | 37183 | 126359 | 869 |
1792619 | 1792619 | 2021-10-07 | Warren | North Carolina | 37185 | 2285 | 27 |
1792620 | 1792620 | 2021-10-07 | Washington | North Carolina | 37187 | 1532 | 35 |
1792621 | 1792621 | 2021-10-07 | Watauga | North Carolina | 37189 | 6374 | 34 |
1792622 | 1792622 | 2021-10-07 | Wayne | North Carolina | 37191 | 15367 | 296 |
1792623 | 1792623 | 2021-10-07 | Wilkes | North Carolina | 37193 | 10267 | 172 |
1792624 | 1792624 | 2021-10-07 | Wilson | North Carolina | 37195 | 12826 | 220 |
1792625 | 1792625 | 2021-10-07 | Yadkin | North Carolina | 37197 | 5782 | 70 |
1792626 | 1792626 | 2021-10-07 | Yancey | North Carolina | 37199 | 2713 | 29 |
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);