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-12-26 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 |
---|---|---|---|---|---|---|---|
2052518 | 2052518 | 2021-12-26 | Alamance | North Carolina | 37001 | 28902 | 375 |
2052519 | 2052519 | 2021-12-26 | Alexander | North Carolina | 37003 | 7112 | 119 |
2052520 | 2052520 | 2021-12-26 | Alleghany | North Carolina | 37005 | 2028 | 6 |
2052521 | 2052521 | 2021-12-26 | Anson | North Carolina | 37007 | 4144 | 85 |
2052522 | 2052522 | 2021-12-26 | Ashe | North Carolina | 37009 | 3971 | 58 |
2052523 | 2052523 | 2021-12-26 | Avery | North Carolina | 37011 | 3011 | 39 |
2052524 | 2052524 | 2021-12-26 | Beaufort | North Carolina | 37013 | 7796 | 137 |
2052525 | 2052525 | 2021-12-26 | Bertie | North Carolina | 37015 | 2629 | 54 |
2052526 | 2052526 | 2021-12-26 | Bladen | North Carolina | 37017 | 5803 | 96 |
2052527 | 2052527 | 2021-12-26 | Brunswick | North Carolina | 37019 | 17869 | 252 |
2052528 | 2052528 | 2021-12-26 | Buncombe | North Carolina | 37021 | 31613 | 452 |
2052529 | 2052529 | 2021-12-26 | Burke | North Carolina | 37023 | 16704 | 250 |
2052530 | 2052530 | 2021-12-26 | Cabarrus | North Carolina | 37025 | 36144 | 370 |
2052531 | 2052531 | 2021-12-26 | Caldwell | North Carolina | 37027 | 14514 | 231 |
2052532 | 2052532 | 2021-12-26 | Camden | North Carolina | 37029 | 1294 | 9 |
2052533 | 2052533 | 2021-12-26 | Carteret | North Carolina | 37031 | 8988 | 83 |
2052534 | 2052534 | 2021-12-26 | Caswell | North Carolina | 37033 | 3455 | 39 |
2052535 | 2052535 | 2021-12-26 | Catawba | North Carolina | 37035 | 30730 | 458 |
2052536 | 2052536 | 2021-12-26 | Chatham | North Carolina | 37037 | 7434 | 99 |
2052537 | 2052537 | 2021-12-26 | Cherokee | North Carolina | 37039 | 4877 | 87 |
2052538 | 2052538 | 2021-12-26 | Chowan | North Carolina | 37041 | 2452 | 44 |
2052539 | 2052539 | 2021-12-26 | Clay | North Carolina | 37043 | 1744 | 38 |
2052540 | 2052540 | 2021-12-26 | Cleveland | North Carolina | 37045 | 19652 | 322 |
2052541 | 2052541 | 2021-12-26 | Columbus | North Carolina | 37047 | 10576 | 233 |
2052542 | 2052542 | 2021-12-26 | Craven | North Carolina | 37049 | 15090 | 164 |
2052543 | 2052543 | 2021-12-26 | Cumberland | North Carolina | 37051 | 50189 | 502 |
2052544 | 2052544 | 2021-12-26 | Currituck | North Carolina | 37053 | 3194 | 27 |
2052545 | 2052545 | 2021-12-26 | Dare | North Carolina | 37055 | 4495 | 15 |
2052546 | 2052546 | 2021-12-26 | Davidson | North Carolina | 37057 | 28387 | 332 |
2052547 | 2052547 | 2021-12-26 | Davie | North Carolina | 37059 | 7289 | 82 |
2052548 | 2052548 | 2021-12-26 | Duplin | North Carolina | 37061 | 10593 | 199 |
2052549 | 2052549 | 2021-12-26 | Durham | North Carolina | 37063 | 37787 | 269 |
2052550 | 2052550 | 2021-12-26 | Edgecombe | North Carolina | 37065 | 8376 | 127 |
2052551 | 2052551 | 2021-12-26 | Forsyth | North Carolina | 37067 | 56881 | 607 |
2052552 | 2052552 | 2021-12-26 | Franklin | North Carolina | 37069 | 10797 | 64 |
2052553 | 2052553 | 2021-12-26 | Gaston | North Carolina | 37071 | 43817 | 649 |
2052554 | 2052554 | 2021-12-26 | Gates | North Carolina | 37073 | 1192 | 18 |
2052555 | 2052555 | 2021-12-26 | Graham | North Carolina | 37075 | 1436 | 28 |
2052556 | 2052556 | 2021-12-26 | Granville | North Carolina | 37077 | 8685 | 106 |
2052557 | 2052557 | 2021-12-26 | Greene | North Carolina | 37079 | 3546 | 56 |
2052558 | 2052558 | 2021-12-26 | Guilford | North Carolina | 37081 | 74053 | 936 |
2052559 | 2052559 | 2021-12-26 | Halifax | North Carolina | 37083 | 8227 | 146 |
2052560 | 2052560 | 2021-12-26 | Harnett | North Carolina | 37085 | 19868 | 277 |
2052561 | 2052561 | 2021-12-26 | Haywood | North Carolina | 37087 | 8319 | 157 |
2052562 | 2052562 | 2021-12-26 | Henderson | North Carolina | 37089 | 17061 | 220 |
2052563 | 2052563 | 2021-12-26 | Hertford | North Carolina | 37091 | 2969 | 72 |
2052564 | 2052564 | 2021-12-26 | Hoke | North Carolina | 37093 | 7784 | 91 |
2052565 | 2052565 | 2021-12-26 | Hyde | North Carolina | 37095 | 880 | 12 |
2052566 | 2052566 | 2021-12-26 | Iredell | North Carolina | 37097 | 32137 | 342 |
2052567 | 2052567 | 2021-12-26 | Jackson | North Carolina | 37099 | 6175 | 76 |
2052568 | 2052568 | 2021-12-26 | Johnston | North Carolina | 37101 | 35370 | 347 |
2052569 | 2052569 | 2021-12-26 | Jones | North Carolina | 37103 | 1414 | 36 |
2052570 | 2052570 | 2021-12-26 | Lee | North Carolina | 37105 | 9987 | 116 |
2052571 | 2052571 | 2021-12-26 | Lenoir | North Carolina | 37107 | 10004 | 179 |
2052572 | 2052572 | 2021-12-26 | Lincoln | North Carolina | 37109 | 16630 | 119 |
2052573 | 2052573 | 2021-12-26 | Macon | North Carolina | 37113 | 5261 | 87 |
2052574 | 2052574 | 2021-12-26 | Madison | North Carolina | 37115 | 3101 | 66 |
2052575 | 2052575 | 2021-12-26 | Martin | North Carolina | 37117 | 3849 | 75 |
2052576 | 2052576 | 2021-12-26 | McDowell | North Carolina | 37111 | 9140 | 138 |
2052577 | 2052577 | 2021-12-26 | Mecklenburg | North Carolina | 37119 | 169887 | 1311 |
2052578 | 2052578 | 2021-12-26 | Mitchell | North Carolina | 37121 | 2315 | 24 |
2052579 | 2052579 | 2021-12-26 | Montgomery | North Carolina | 37123 | 4827 | 110 |
2052580 | 2052580 | 2021-12-26 | Moore | North Carolina | 37125 | 14618 | 258 |
2052581 | 2052581 | 2021-12-26 | Nash | North Carolina | 37127 | 16191 | 242 |
2052582 | 2052582 | 2021-12-26 | New Hanover | North Carolina | 37129 | 30247 | 300 |
2052583 | 2052583 | 2021-12-26 | Northampton | North Carolina | 37131 | 2687 | 66 |
2052584 | 2052584 | 2021-12-26 | Onslow | North Carolina | 37133 | 31403 | 278 |
2052585 | 2052585 | 2021-12-26 | Orange | North Carolina | 37135 | 12893 | 112 |
2052586 | 2052586 | 2021-12-26 | Pamlico | North Carolina | 37137 | 1797 | 26 |
2052587 | 2052587 | 2021-12-26 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2052588 | 2052588 | 2021-12-26 | Pender | North Carolina | 37141 | 9549 | 103 |
2052589 | 2052589 | 2021-12-26 | Perquimans | North Carolina | 37143 | 1774 | 16 |
2052590 | 2052590 | 2021-12-26 | Person | North Carolina | 37145 | 5739 | 91 |
2052591 | 2052591 | 2021-12-26 | Pitt | North Carolina | 37147 | 31585 | 146 |
2052592 | 2052592 | 2021-12-26 | Polk | North Carolina | 37149 | 2510 | 49 |
2052593 | 2052593 | 2021-12-26 | Randolph | North Carolina | 37151 | 23888 | 338 |
2052594 | 2052594 | 2021-12-26 | Richmond | North Carolina | 37153 | 7649 | 151 |
2052595 | 2052595 | 2021-12-26 | Robeson | North Carolina | 37155 | 26322 | 449 |
2052596 | 2052596 | 2021-12-26 | Rockingham | North Carolina | 37157 | 13859 | 220 |
2052597 | 2052597 | 2021-12-26 | Rowan | North Carolina | 37159 | 28194 | 488 |
2052598 | 2052598 | 2021-12-26 | Rutherford | North Carolina | 37161 | 12062 | 347 |
2052599 | 2052599 | 2021-12-26 | Sampson | North Carolina | 37163 | 11958 | 143 |
2052600 | 2052600 | 2021-12-26 | Scotland | North Carolina | 37165 | 6047 | 110 |
2052601 | 2052601 | 2021-12-26 | Stanly | North Carolina | 37167 | 12775 | 211 |
2052602 | 2052602 | 2021-12-26 | Stokes | North Carolina | 37169 | 7312 | 119 |
2052603 | 2052603 | 2021-12-26 | Surry | North Carolina | 37171 | 14067 | 254 |
2052604 | 2052604 | 2021-12-26 | Swain | North Carolina | 37173 | 2240 | 28 |
2052605 | 2052605 | 2021-12-26 | Transylvania | North Carolina | 37175 | 4300 | 53 |
2052606 | 2052606 | 2021-12-26 | Tyrrell | North Carolina | 37177 | 606 | 7 |
2052607 | 2052607 | 2021-12-26 | Union | North Carolina | 37179 | 40023 | 383 |
2052608 | 2052608 | 2021-12-26 | Vance | North Carolina | 37181 | 7454 | 104 |
2052609 | 2052609 | 2021-12-26 | Wake | North Carolina | 37183 | 141967 | 916 |
2052610 | 2052610 | 2021-12-26 | Warren | North Carolina | 37185 | 2611 | 36 |
2052611 | 2052611 | 2021-12-26 | Washington | North Carolina | 37187 | 1684 | 38 |
2052612 | 2052612 | 2021-12-26 | Watauga | North Carolina | 37189 | 7308 | 42 |
2052613 | 2052613 | 2021-12-26 | Wayne | North Carolina | 37191 | 18349 | 332 |
2052614 | 2052614 | 2021-12-26 | Wilkes | North Carolina | 37193 | 11682 | 198 |
2052615 | 2052615 | 2021-12-26 | Wilson | North Carolina | 37195 | 13927 | 243 |
2052616 | 2052616 | 2021-12-26 | Yadkin | North Carolina | 37197 | 6957 | 82 |
2052617 | 2052617 | 2021-12-26 | Yancey | North Carolina | 37199 | 3356 | 36 |
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);