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-01-17 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 |
---|---|---|---|---|---|---|---|
938567 | 938567 | 2021-01-17 | Alamance | North Carolina | 37001 | 12619 | 169 |
938568 | 938568 | 2021-01-17 | Alexander | North Carolina | 37003 | 3273 | 42 |
938569 | 938569 | 2021-01-17 | Alleghany | North Carolina | 37005 | 768 | 3 |
938570 | 938570 | 2021-01-17 | Anson | North Carolina | 37007 | 1789 | 38 |
938571 | 938571 | 2021-01-17 | Ashe | North Carolina | 37009 | 1562 | 28 |
938572 | 938572 | 2021-01-17 | Avery | North Carolina | 37011 | 1598 | 16 |
938573 | 938573 | 2021-01-17 | Beaufort | North Carolina | 37013 | 3422 | 61 |
938574 | 938574 | 2021-01-17 | Bertie | North Carolina | 37015 | 1419 | 27 |
938575 | 938575 | 2021-01-17 | Bladen | North Carolina | 37017 | 2307 | 28 |
938576 | 938576 | 2021-01-17 | Brunswick | North Carolina | 37019 | 5689 | 81 |
938577 | 938577 | 2021-01-17 | Buncombe | North Carolina | 37021 | 11912 | 230 |
938578 | 938578 | 2021-01-17 | Burke | North Carolina | 37023 | 7590 | 90 |
938579 | 938579 | 2021-01-17 | Cabarrus | North Carolina | 37025 | 14252 | 171 |
938580 | 938580 | 2021-01-17 | Caldwell | North Carolina | 37027 | 7255 | 31 |
938581 | 938581 | 2021-01-17 | Camden | North Carolina | 37029 | 414 | 5 |
938582 | 938582 | 2021-01-17 | Carteret | North Carolina | 37031 | 3403 | 18 |
938583 | 938583 | 2021-01-17 | Caswell | North Carolina | 37033 | 1521 | 10 |
938584 | 938584 | 2021-01-17 | Catawba | North Carolina | 37035 | 13868 | 205 |
938585 | 938585 | 2021-01-17 | Chatham | North Carolina | 37037 | 3345 | 68 |
938586 | 938586 | 2021-01-17 | Cherokee | North Carolina | 37039 | 1669 | 16 |
938587 | 938587 | 2021-01-17 | Chowan | North Carolina | 37041 | 1039 | 20 |
938588 | 938588 | 2021-01-17 | Clay | North Carolina | 37043 | 533 | 5 |
938589 | 938589 | 2021-01-17 | Cleveland | North Carolina | 37045 | 8485 | 172 |
938590 | 938590 | 2021-01-17 | Columbus | North Carolina | 37047 | 4548 | 102 |
938591 | 938591 | 2021-01-17 | Craven | North Carolina | 37049 | 6405 | 89 |
938592 | 938592 | 2021-01-17 | Cumberland | North Carolina | 37051 | 17567 | 154 |
938593 | 938593 | 2021-01-17 | Currituck | North Carolina | 37053 | 932 | 12 |
938594 | 938594 | 2021-01-17 | Dare | North Carolina | 37055 | 1456 | 6 |
938595 | 938595 | 2021-01-17 | Davidson | North Carolina | 37057 | 11401 | 106 |
938596 | 938596 | 2021-01-17 | Davie | North Carolina | 37059 | 2675 | 15 |
938597 | 938597 | 2021-01-17 | Duplin | North Carolina | 37061 | 4894 | 83 |
938598 | 938598 | 2021-01-17 | Durham | North Carolina | 37063 | 17626 | 160 |
938599 | 938599 | 2021-01-17 | Edgecombe | North Carolina | 37065 | 3727 | 87 |
938600 | 938600 | 2021-01-17 | Forsyth | North Carolina | 37067 | 24973 | 248 |
938601 | 938601 | 2021-01-17 | Franklin | North Carolina | 37069 | 4059 | 39 |
938602 | 938602 | 2021-01-17 | Gaston | North Carolina | 37071 | 19448 | 280 |
938603 | 938603 | 2021-01-17 | Gates | North Carolina | 37073 | 463 | 12 |
938604 | 938604 | 2021-01-17 | Graham | North Carolina | 37075 | 495 | 12 |
938605 | 938605 | 2021-01-17 | Granville | North Carolina | 37077 | 4335 | 70 |
938606 | 938606 | 2021-01-17 | Greene | North Carolina | 37079 | 1771 | 34 |
938607 | 938607 | 2021-01-17 | Guilford | North Carolina | 37081 | 30942 | 359 |
938608 | 938608 | 2021-01-17 | Halifax | North Carolina | 37083 | 3772 | 65 |
938609 | 938609 | 2021-01-17 | Harnett | North Carolina | 37085 | 7365 | 105 |
938610 | 938610 | 2021-01-17 | Haywood | North Carolina | 37087 | 2906 | 75 |
938611 | 938611 | 2021-01-17 | Henderson | North Carolina | 37089 | 6901 | 100 |
938612 | 938612 | 2021-01-17 | Hertford | North Carolina | 37091 | 1643 | 53 |
938613 | 938613 | 2021-01-17 | Hoke | North Carolina | 37093 | 3321 | 37 |
938614 | 938614 | 2021-01-17 | Hyde | North Carolina | 37095 | 555 | 6 |
938615 | 938615 | 2021-01-17 | Iredell | North Carolina | 37097 | 12098 | 132 |
938616 | 938616 | 2021-01-17 | Jackson | North Carolina | 37099 | 2745 | 20 |
938617 | 938617 | 2021-01-17 | Johnston | North Carolina | 37101 | 14067 | 139 |
938618 | 938618 | 2021-01-17 | Jones | North Carolina | 37103 | 512 | 16 |
938619 | 938619 | 2021-01-17 | Lee | North Carolina | 37105 | 4361 | 46 |
938620 | 938620 | 2021-01-17 | Lenoir | North Carolina | 37107 | 4164 | 83 |
938621 | 938621 | 2021-01-17 | Lincoln | North Carolina | 37109 | 6980 | 42 |
938622 | 938622 | 2021-01-17 | Macon | North Carolina | 37113 | 1988 | 12 |
938623 | 938623 | 2021-01-17 | Madison | North Carolina | 37115 | 1071 | 24 |
938624 | 938624 | 2021-01-17 | Martin | North Carolina | 37117 | 1704 | 27 |
938625 | 938625 | 2021-01-17 | McDowell | North Carolina | 37111 | 3933 | 39 |
938626 | 938626 | 2021-01-17 | Mecklenburg | North Carolina | 37119 | 77030 | 691 |
938627 | 938627 | 2021-01-17 | Mitchell | North Carolina | 37121 | 986 | 10 |
938628 | 938628 | 2021-01-17 | Montgomery | North Carolina | 37123 | 2446 | 52 |
938629 | 938629 | 2021-01-17 | Moore | North Carolina | 37125 | 6181 | 80 |
938630 | 938630 | 2021-01-17 | Nash | North Carolina | 37127 | 7150 | 126 |
938631 | 938631 | 2021-01-17 | New Hanover | North Carolina | 37129 | 11415 | 100 |
938632 | 938632 | 2021-01-17 | Northampton | North Carolina | 37131 | 1325 | 27 |
938633 | 938633 | 2021-01-17 | Onslow | North Carolina | 37133 | 11318 | 90 |
938634 | 938634 | 2021-01-17 | Orange | North Carolina | 37135 | 6079 | 69 |
938635 | 938635 | 2021-01-17 | Pamlico | North Carolina | 37137 | 663 | 6 |
938636 | 938636 | 2021-01-17 | Pasquotank | North Carolina | 37139 | 2378 | 62 |
938637 | 938637 | 2021-01-17 | Pender | North Carolina | 37141 | 3538 | 37 |
938638 | 938638 | 2021-01-17 | Perquimans | North Carolina | 37143 | 689 | 5 |
938639 | 938639 | 2021-01-17 | Person | North Carolina | 37145 | 2190 | 35 |
938640 | 938640 | 2021-01-17 | Pitt | North Carolina | 37147 | 13913 | 69 |
938641 | 938641 | 2021-01-17 | Polk | North Carolina | 37149 | 1050 | 14 |
938642 | 938642 | 2021-01-17 | Randolph | North Carolina | 37151 | 10002 | 155 |
938643 | 938643 | 2021-01-17 | Richmond | North Carolina | 37153 | 3268 | 58 |
938644 | 938644 | 2021-01-17 | Robeson | North Carolina | 37155 | 12015 | 153 |
938645 | 938645 | 2021-01-17 | Rockingham | North Carolina | 37157 | 5682 | 32 |
938646 | 938646 | 2021-01-17 | Rowan | North Carolina | 37159 | 11619 | 217 |
938647 | 938647 | 2021-01-17 | Rutherford | North Carolina | 37161 | 5652 | 154 |
938648 | 938648 | 2021-01-17 | Sampson | North Carolina | 37163 | 5732 | 73 |
938649 | 938649 | 2021-01-17 | Scotland | North Carolina | 37165 | 2962 | 61 |
938650 | 938650 | 2021-01-17 | Stanly | North Carolina | 37167 | 5406 | 92 |
938651 | 938651 | 2021-01-17 | Stokes | North Carolina | 37169 | 2679 | 44 |
938652 | 938652 | 2021-01-17 | Surry | North Carolina | 37171 | 5643 | 97 |
938653 | 938653 | 2021-01-17 | Swain | North Carolina | 37173 | 941 | 8 |
938654 | 938654 | 2021-01-17 | Transylvania | North Carolina | 37175 | 1359 | 13 |
938655 | 938655 | 2021-01-17 | Tyrrell | North Carolina | 37177 | 216 | 4 |
938656 | 938656 | 2021-01-17 | Union | North Carolina | 37179 | 16184 | 128 |
938657 | 938657 | 2021-01-17 | Vance | North Carolina | 37181 | 3321 | 73 |
938658 | 938658 | 2021-01-17 | Wake | North Carolina | 37183 | 56859 | 396 |
938659 | 938659 | 2021-01-17 | Warren | North Carolina | 37185 | 1279 | 12 |
938660 | 938660 | 2021-01-17 | Washington | North Carolina | 37187 | 655 | 19 |
938661 | 938661 | 2021-01-17 | Watauga | North Carolina | 37189 | 3118 | 23 |
938662 | 938662 | 2021-01-17 | Wayne | North Carolina | 37191 | 8461 | 168 |
938663 | 938663 | 2021-01-17 | Wilkes | North Carolina | 37193 | 4833 | 83 |
938664 | 938664 | 2021-01-17 | Wilson | North Carolina | 37195 | 6799 | 123 |
938665 | 938665 | 2021-01-17 | Yadkin | North Carolina | 37197 | 2989 | 33 |
938666 | 938666 | 2021-01-17 | Yancey | North Carolina | 37199 | 1211 | 10 |
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);