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-27 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 |
---|---|---|---|---|---|---|---|
1857511 | 1857511 | 2021-10-27 | Alamance | North Carolina | 37001 | 26304 | 337 |
1857512 | 1857512 | 2021-10-27 | Alexander | North Carolina | 37003 | 6446 | 117 |
1857513 | 1857513 | 2021-10-27 | Alleghany | North Carolina | 37005 | 1608 | 6 |
1857514 | 1857514 | 2021-10-27 | Anson | North Carolina | 37007 | 3825 | 79 |
1857515 | 1857515 | 2021-10-27 | Ashe | North Carolina | 37009 | 3434 | 48 |
1857516 | 1857516 | 2021-10-27 | Avery | North Carolina | 37011 | 2736 | 35 |
1857517 | 1857517 | 2021-10-27 | Beaufort | North Carolina | 37013 | 7133 | 126 |
1857518 | 1857518 | 2021-10-27 | Bertie | North Carolina | 37015 | 2468 | 52 |
1857519 | 1857519 | 2021-10-27 | Bladen | North Carolina | 37017 | 5463 | 95 |
1857520 | 1857520 | 2021-10-27 | Brunswick | North Carolina | 37019 | 16239 | 236 |
1857521 | 1857521 | 2021-10-27 | Buncombe | North Carolina | 37021 | 28095 | 431 |
1857522 | 1857522 | 2021-10-27 | Burke | North Carolina | 37023 | 15715 | 237 |
1857523 | 1857523 | 2021-10-27 | Cabarrus | North Carolina | 37025 | 32758 | 334 |
1857524 | 1857524 | 2021-10-27 | Caldwell | North Carolina | 37027 | 13308 | 213 |
1857525 | 1857525 | 2021-10-27 | Camden | North Carolina | 37029 | 1135 | 8 |
1857526 | 1857526 | 2021-10-27 | Carteret | North Carolina | 37031 | 8355 | 83 |
1857527 | 1857527 | 2021-10-27 | Caswell | North Carolina | 37033 | 3192 | 37 |
1857528 | 1857528 | 2021-10-27 | Catawba | North Carolina | 37035 | 28258 | 425 |
1857529 | 1857529 | 2021-10-27 | Chatham | North Carolina | 37037 | 6749 | 91 |
1857530 | 1857530 | 2021-10-27 | Cherokee | North Carolina | 37039 | 4637 | 75 |
1857531 | 1857531 | 2021-10-27 | Chowan | North Carolina | 37041 | 2293 | 41 |
1857532 | 1857532 | 2021-10-27 | Clay | North Carolina | 37043 | 1653 | 36 |
1857533 | 1857533 | 2021-10-27 | Cleveland | North Carolina | 37045 | 18340 | 308 |
1857534 | 1857534 | 2021-10-27 | Columbus | North Carolina | 37047 | 10067 | 225 |
1857535 | 1857535 | 2021-10-27 | Craven | North Carolina | 37049 | 14260 | 157 |
1857536 | 1857536 | 2021-10-27 | Cumberland | North Carolina | 37051 | 45421 | 464 |
1857537 | 1857537 | 2021-10-27 | Currituck | North Carolina | 37053 | 2733 | 26 |
1857538 | 1857538 | 2021-10-27 | Dare | North Carolina | 37055 | 3826 | 12 |
1857539 | 1857539 | 2021-10-27 | Davidson | North Carolina | 37057 | 25710 | 307 |
1857540 | 1857540 | 2021-10-27 | Davie | North Carolina | 37059 | 6408 | 76 |
1857541 | 1857541 | 2021-10-27 | Duplin | North Carolina | 37061 | 9939 | 182 |
1857542 | 1857542 | 2021-10-27 | Durham | North Carolina | 37063 | 34959 | 259 |
1857543 | 1857543 | 2021-10-27 | Edgecombe | North Carolina | 37065 | 7926 | 125 |
1857544 | 1857544 | 2021-10-27 | Forsyth | North Carolina | 37067 | 51630 | 562 |
1857545 | 1857545 | 2021-10-27 | Franklin | North Carolina | 37069 | 9883 | 61 |
1857546 | 1857546 | 2021-10-27 | Gaston | North Carolina | 37071 | 39910 | 615 |
1857547 | 1857547 | 2021-10-27 | Gates | North Carolina | 37073 | 1086 | 19 |
1857548 | 1857548 | 2021-10-27 | Graham | North Carolina | 37075 | 1329 | 28 |
1857549 | 1857549 | 2021-10-27 | Granville | North Carolina | 37077 | 7920 | 99 |
1857550 | 1857550 | 2021-10-27 | Greene | North Carolina | 37079 | 3314 | 56 |
1857551 | 1857551 | 2021-10-27 | Guilford | North Carolina | 37081 | 67719 | 870 |
1857552 | 1857552 | 2021-10-27 | Halifax | North Carolina | 37083 | 7876 | 139 |
1857553 | 1857553 | 2021-10-27 | Harnett | North Carolina | 37085 | 18413 | 253 |
1857554 | 1857554 | 2021-10-27 | Haywood | North Carolina | 37087 | 7442 | 138 |
1857555 | 1857555 | 2021-10-27 | Henderson | North Carolina | 37089 | 15176 | 204 |
1857556 | 1857556 | 2021-10-27 | Hertford | North Carolina | 37091 | 2844 | 71 |
1857557 | 1857557 | 2021-10-27 | Hoke | North Carolina | 37093 | 7122 | 82 |
1857558 | 1857558 | 2021-10-27 | Hyde | North Carolina | 37095 | 825 | 12 |
1857559 | 1857559 | 2021-10-27 | Iredell | North Carolina | 37097 | 28786 | 322 |
1857560 | 1857560 | 2021-10-27 | Jackson | North Carolina | 37099 | 5637 | 71 |
1857561 | 1857561 | 2021-10-27 | Johnston | North Carolina | 37101 | 32337 | 328 |
1857562 | 1857562 | 2021-10-27 | Jones | North Carolina | 37103 | 1334 | 31 |
1857563 | 1857563 | 2021-10-27 | Lee | North Carolina | 37105 | 9404 | 108 |
1857564 | 1857564 | 2021-10-27 | Lenoir | North Carolina | 37107 | 9456 | 155 |
1857565 | 1857565 | 2021-10-27 | Lincoln | North Carolina | 37109 | 14958 | 107 |
1857566 | 1857566 | 2021-10-27 | Macon | North Carolina | 37113 | 4951 | 69 |
1857567 | 1857567 | 2021-10-27 | Madison | North Carolina | 37115 | 2767 | 61 |
1857568 | 1857568 | 2021-10-27 | Martin | North Carolina | 37117 | 3643 | 72 |
1857569 | 1857569 | 2021-10-27 | McDowell | North Carolina | 37111 | 8624 | 125 |
1857570 | 1857570 | 2021-10-27 | Mecklenburg | North Carolina | 37119 | 156828 | 1237 |
1857571 | 1857571 | 2021-10-27 | Mitchell | North Carolina | 37121 | 2034 | 21 |
1857572 | 1857572 | 2021-10-27 | Montgomery | North Carolina | 37123 | 4536 | 108 |
1857573 | 1857573 | 2021-10-27 | Moore | North Carolina | 37125 | 13626 | 247 |
1857574 | 1857574 | 2021-10-27 | Nash | North Carolina | 37127 | 15230 | 233 |
1857575 | 1857575 | 2021-10-27 | New Hanover | North Carolina | 37129 | 28654 | 287 |
1857576 | 1857576 | 2021-10-27 | Northampton | North Carolina | 37131 | 2599 | 65 |
1857577 | 1857577 | 2021-10-27 | Onslow | North Carolina | 37133 | 29367 | 258 |
1857578 | 1857578 | 2021-10-27 | Orange | North Carolina | 37135 | 11807 | 110 |
1857579 | 1857579 | 2021-10-27 | Pamlico | North Carolina | 37137 | 1715 | 25 |
1857580 | 1857580 | 2021-10-27 | Pasquotank | North Carolina | 37139 | 5227 | 101 |
1857581 | 1857581 | 2021-10-27 | Pender | North Carolina | 37141 | 8800 | 101 |
1857582 | 1857582 | 2021-10-27 | Perquimans | North Carolina | 37143 | 1546 | 15 |
1857583 | 1857583 | 2021-10-27 | Person | North Carolina | 37145 | 5092 | 87 |
1857584 | 1857584 | 2021-10-27 | Pitt | North Carolina | 37147 | 29609 | 143 |
1857585 | 1857585 | 2021-10-27 | Polk | North Carolina | 37149 | 2329 | 44 |
1857586 | 1857586 | 2021-10-27 | Randolph | North Carolina | 37151 | 21786 | 311 |
1857587 | 1857587 | 2021-10-27 | Richmond | North Carolina | 37153 | 7105 | 140 |
1857588 | 1857588 | 2021-10-27 | Robeson | North Carolina | 37155 | 24937 | 425 |
1857589 | 1857589 | 2021-10-27 | Rockingham | North Carolina | 37157 | 12112 | 193 |
1857590 | 1857590 | 2021-10-27 | Rowan | North Carolina | 37159 | 26162 | 453 |
1857591 | 1857591 | 2021-10-27 | Rutherford | North Carolina | 37161 | 11410 | 316 |
1857592 | 1857592 | 2021-10-27 | Sampson | North Carolina | 37163 | 11259 | 135 |
1857593 | 1857593 | 2021-10-27 | Scotland | North Carolina | 37165 | 5712 | 107 |
1857594 | 1857594 | 2021-10-27 | Stanly | North Carolina | 37167 | 11601 | 191 |
1857595 | 1857595 | 2021-10-27 | Stokes | North Carolina | 37169 | 6221 | 108 |
1857596 | 1857596 | 2021-10-27 | Surry | North Carolina | 37171 | 12379 | 227 |
1857597 | 1857597 | 2021-10-27 | Swain | North Carolina | 37173 | 1958 | 23 |
1857598 | 1857598 | 2021-10-27 | Transylvania | North Carolina | 37175 | 3880 | 48 |
1857599 | 1857599 | 2021-10-27 | Tyrrell | North Carolina | 37177 | 550 | 7 |
1857600 | 1857600 | 2021-10-27 | Union | North Carolina | 37179 | 36270 | 335 |
1857601 | 1857601 | 2021-10-27 | Vance | North Carolina | 37181 | 6809 | 101 |
1857602 | 1857602 | 2021-10-27 | Wake | North Carolina | 37183 | 130570 | 889 |
1857603 | 1857603 | 2021-10-27 | Warren | North Carolina | 37185 | 2380 | 31 |
1857604 | 1857604 | 2021-10-27 | Washington | North Carolina | 37187 | 1580 | 37 |
1857605 | 1857605 | 2021-10-27 | Watauga | North Carolina | 37189 | 6599 | 37 |
1857606 | 1857606 | 2021-10-27 | Wayne | North Carolina | 37191 | 16286 | 300 |
1857607 | 1857607 | 2021-10-27 | Wilkes | North Carolina | 37193 | 10535 | 179 |
1857608 | 1857608 | 2021-10-27 | Wilson | North Carolina | 37195 | 13194 | 232 |
1857609 | 1857609 | 2021-10-27 | Yadkin | North Carolina | 37197 | 5984 | 73 |
1857610 | 1857610 | 2021-10-27 | Yancey | North Carolina | 37199 | 2799 | 32 |
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);