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 2022-02-16 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 |
---|---|---|---|---|---|---|---|
2221638 | 2221638 | 2022-02-16 | Alamance | North Carolina | 37001 | 45488 | 428 |
2221639 | 2221639 | 2022-02-16 | Alexander | North Carolina | 37003 | 10270 | 127 |
2221640 | 2221640 | 2022-02-16 | Alleghany | North Carolina | 37005 | 2844 | 11 |
2221641 | 2221641 | 2022-02-16 | Anson | North Carolina | 37007 | 6380 | 93 |
2221642 | 2221642 | 2022-02-16 | Ashe | North Carolina | 37009 | 5978 | 68 |
2221643 | 2221643 | 2022-02-16 | Avery | North Carolina | 37011 | 4238 | 41 |
2221644 | 2221644 | 2022-02-16 | Beaufort | North Carolina | 37013 | 11798 | 149 |
2221645 | 2221645 | 2022-02-16 | Bertie | North Carolina | 37015 | 4167 | 64 |
2221646 | 2221646 | 2022-02-16 | Bladen | North Carolina | 37017 | 9123 | 117 |
2221647 | 2221647 | 2022-02-16 | Brunswick | North Carolina | 37019 | 28334 | 292 |
2221648 | 2221648 | 2022-02-16 | Buncombe | North Carolina | 37021 | 48924 | 529 |
2221649 | 2221649 | 2022-02-16 | Burke | North Carolina | 37023 | 24028 | 288 |
2221650 | 2221650 | 2022-02-16 | Cabarrus | North Carolina | 37025 | 54459 | 440 |
2221651 | 2221651 | 2022-02-16 | Caldwell | North Carolina | 37027 | 21476 | 267 |
2221652 | 2221652 | 2022-02-16 | Camden | North Carolina | 37029 | 1618 | 9 |
2221653 | 2221653 | 2022-02-16 | Carteret | North Carolina | 37031 | 12994 | 84 |
2221654 | 2221654 | 2022-02-16 | Caswell | North Carolina | 37033 | 5086 | 40 |
2221655 | 2221655 | 2022-02-16 | Catawba | North Carolina | 37035 | 46521 | 534 |
2221656 | 2221656 | 2022-02-16 | Chatham | North Carolina | 37037 | 12237 | 104 |
2221657 | 2221657 | 2022-02-16 | Cherokee | North Carolina | 37039 | 6916 | 92 |
2221658 | 2221658 | 2022-02-16 | Chowan | North Carolina | 37041 | 4068 | 50 |
2221659 | 2221659 | 2022-02-16 | Clay | North Carolina | 37043 | 2582 | 38 |
2221660 | 2221660 | 2022-02-16 | Cleveland | North Carolina | 37045 | 29033 | 357 |
2221661 | 2221661 | 2022-02-16 | Columbus | North Carolina | 37047 | 15561 | 262 |
2221662 | 2221662 | 2022-02-16 | Craven | North Carolina | 37049 | 23175 | 189 |
2221663 | 2221663 | 2022-02-16 | Cumberland | North Carolina | 37051 | 80416 | 528 |
2221664 | 2221664 | 2022-02-16 | Currituck | North Carolina | 37053 | 4676 | 32 |
2221665 | 2221665 | 2022-02-16 | Dare | North Carolina | 37055 | 7182 | 21 |
2221666 | 2221666 | 2022-02-16 | Davidson | North Carolina | 37057 | 42155 | 378 |
2221667 | 2221667 | 2022-02-16 | Davie | North Carolina | 37059 | 10810 | 85 |
2221668 | 2221668 | 2022-02-16 | Duplin | North Carolina | 37061 | 16143 | 225 |
2221669 | 2221669 | 2022-02-16 | Durham | North Carolina | 37063 | 69483 | 295 |
2221670 | 2221670 | 2022-02-16 | Edgecombe | North Carolina | 37065 | 13184 | 137 |
2221671 | 2221671 | 2022-02-16 | Forsyth | North Carolina | 37067 | 90139 | 742 |
2221672 | 2221672 | 2022-02-16 | Franklin | North Carolina | 37069 | 19660 | 65 |
2221673 | 2221673 | 2022-02-16 | Gaston | North Carolina | 37071 | 63811 | 741 |
2221674 | 2221674 | 2022-02-16 | Gates | North Carolina | 37073 | 1772 | 19 |
2221675 | 2221675 | 2022-02-16 | Graham | North Carolina | 37075 | 2214 | 30 |
2221676 | 2221676 | 2022-02-16 | Granville | North Carolina | 37077 | 13830 | 111 |
2221677 | 2221677 | 2022-02-16 | Greene | North Carolina | 37079 | 5646 | 55 |
2221678 | 2221678 | 2022-02-16 | Guilford | North Carolina | 37081 | 112510 | 1054 |
2221679 | 2221679 | 2022-02-16 | Halifax | North Carolina | 37083 | 13680 | 173 |
2221680 | 2221680 | 2022-02-16 | Harnett | North Carolina | 37085 | 31186 | 301 |
2221681 | 2221681 | 2022-02-16 | Haywood | North Carolina | 37087 | 12459 | 187 |
2221682 | 2221682 | 2022-02-16 | Henderson | North Carolina | 37089 | 24182 | 276 |
2221683 | 2221683 | 2022-02-16 | Hertford | North Carolina | 37091 | 4621 | 80 |
2221684 | 2221684 | 2022-02-16 | Hoke | North Carolina | 37093 | 14234 | 100 |
2221685 | 2221685 | 2022-02-16 | Hyde | North Carolina | 37095 | 1279 | 13 |
2221686 | 2221686 | 2022-02-16 | Iredell | North Carolina | 37097 | 47176 | 414 |
2221687 | 2221687 | 2022-02-16 | Jackson | North Carolina | 37099 | 8956 | 83 |
2221688 | 2221688 | 2022-02-16 | Johnston | North Carolina | 37101 | 56881 | 403 |
2221689 | 2221689 | 2022-02-16 | Jones | North Carolina | 37103 | 2156 | 38 |
2221690 | 2221690 | 2022-02-16 | Lee | North Carolina | 37105 | 15620 | 132 |
2221691 | 2221691 | 2022-02-16 | Lenoir | North Carolina | 37107 | 15346 | 197 |
2221692 | 2221692 | 2022-02-16 | Lincoln | North Carolina | 37109 | 23724 | 146 |
2221693 | 2221693 | 2022-02-16 | Macon | North Carolina | 37113 | 7089 | 103 |
2221694 | 2221694 | 2022-02-16 | Madison | North Carolina | 37115 | 4820 | 78 |
2221695 | 2221695 | 2022-02-16 | Martin | North Carolina | 37117 | 5963 | 85 |
2221696 | 2221696 | 2022-02-16 | McDowell | North Carolina | 37111 | 13028 | 159 |
2221697 | 2221697 | 2022-02-16 | Mecklenburg | North Carolina | 37119 | 271580 | 1520 |
2221698 | 2221698 | 2022-02-16 | Mitchell | North Carolina | 37121 | 3191 | 33 |
2221699 | 2221699 | 2022-02-16 | Montgomery | North Carolina | 37123 | 7133 | 122 |
2221700 | 2221700 | 2022-02-16 | Moore | North Carolina | 37125 | 23603 | 305 |
2221701 | 2221701 | 2022-02-16 | Nash | North Carolina | 37127 | 26683 | 282 |
2221702 | 2221702 | 2022-02-16 | New Hanover | North Carolina | 37129 | 47491 | 351 |
2221703 | 2221703 | 2022-02-16 | Northampton | North Carolina | 37131 | 4219 | 77 |
2221704 | 2221704 | 2022-02-16 | Onslow | North Carolina | 37133 | 49772 | 346 |
2221705 | 2221705 | 2022-02-16 | Orange | North Carolina | 37135 | 24944 | 120 |
2221706 | 2221706 | 2022-02-16 | Pamlico | North Carolina | 37137 | 2548 | 27 |
2221707 | 2221707 | 2022-02-16 | Pasquotank | North Carolina | 37139 | 7902 | 111 |
2221708 | 2221708 | 2022-02-16 | Pender | North Carolina | 37141 | 14686 | 111 |
2221709 | 2221709 | 2022-02-16 | Perquimans | North Carolina | 37143 | 2624 | 17 |
2221710 | 2221710 | 2022-02-16 | Person | North Carolina | 37145 | 8980 | 104 |
2221711 | 2221711 | 2022-02-16 | Pitt | North Carolina | 37147 | 51471 | 146 |
2221712 | 2221712 | 2022-02-16 | Polk | North Carolina | 37149 | 3712 | 49 |
2221713 | 2221713 | 2022-02-16 | Randolph | North Carolina | 37151 | 34671 | 387 |
2221714 | 2221714 | 2022-02-16 | Richmond | North Carolina | 37153 | 12347 | 182 |
2221715 | 2221715 | 2022-02-16 | Robeson | North Carolina | 37155 | 39587 | 504 |
2221716 | 2221716 | 2022-02-16 | Rockingham | North Carolina | 37157 | 21333 | 252 |
2221717 | 2221717 | 2022-02-16 | Rowan | North Carolina | 37159 | 40265 | 548 |
2221718 | 2221718 | 2022-02-16 | Rutherford | North Carolina | 37161 | 17009 | 380 |
2221719 | 2221719 | 2022-02-16 | Sampson | North Carolina | 37163 | 18037 | 157 |
2221720 | 2221720 | 2022-02-16 | Scotland | North Carolina | 37165 | 9777 | 126 |
2221721 | 2221721 | 2022-02-16 | Stanly | North Carolina | 37167 | 19101 | 241 |
2221722 | 2221722 | 2022-02-16 | Stokes | North Carolina | 37169 | 10829 | 153 |
2221723 | 2221723 | 2022-02-16 | Surry | North Carolina | 37171 | 20433 | 303 |
2221724 | 2221724 | 2022-02-16 | Swain | North Carolina | 37173 | 3291 | 34 |
2221725 | 2221725 | 2022-02-16 | Transylvania | North Carolina | 37175 | 5976 | 65 |
2221726 | 2221726 | 2022-02-16 | Tyrrell | North Carolina | 37177 | 958 | 8 |
2221727 | 2221727 | 2022-02-16 | Union | North Carolina | 37179 | 60227 | 449 |
2221728 | 2221728 | 2022-02-16 | Vance | North Carolina | 37181 | 11620 | 111 |
2221729 | 2221729 | 2022-02-16 | Wake | North Carolina | 37183 | 281534 | 999 |
2221730 | 2221730 | 2022-02-16 | Warren | North Carolina | 37185 | 4151 | 38 |
2221731 | 2221731 | 2022-02-16 | Washington | North Carolina | 37187 | 2932 | 46 |
2221732 | 2221732 | 2022-02-16 | Watauga | North Carolina | 37189 | 11782 | 53 |
2221733 | 2221733 | 2022-02-16 | Wayne | North Carolina | 37191 | 27247 | 372 |
2221734 | 2221734 | 2022-02-16 | Wilkes | North Carolina | 37193 | 17194 | 249 |
2221735 | 2221735 | 2022-02-16 | Wilson | North Carolina | 37195 | 20913 | 290 |
2221736 | 2221736 | 2022-02-16 | Yadkin | North Carolina | 37197 | 10467 | 101 |
2221737 | 2221737 | 2022-02-16 | Yancey | North Carolina | 37199 | 4679 | 50 |
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);