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-07-15 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 |
---|---|---|---|---|---|---|---|
1519659 | 1519659 | 2021-07-15 | Alamance | North Carolina | 37001 | 19132 | 288 |
1519660 | 1519660 | 2021-07-15 | Alexander | North Carolina | 37003 | 4476 | 84 |
1519661 | 1519661 | 2021-07-15 | Alleghany | North Carolina | 37005 | 1103 | 5 |
1519662 | 1519662 | 2021-07-15 | Anson | North Carolina | 37007 | 2654 | 56 |
1519663 | 1519663 | 2021-07-15 | Ashe | North Carolina | 37009 | 2261 | 45 |
1519664 | 1519664 | 2021-07-15 | Avery | North Carolina | 37011 | 2167 | 21 |
1519665 | 1519665 | 2021-07-15 | Beaufort | North Carolina | 37013 | 4814 | 103 |
1519666 | 1519666 | 2021-07-15 | Bertie | North Carolina | 37015 | 1800 | 45 |
1519667 | 1519667 | 2021-07-15 | Bladen | North Carolina | 37017 | 3565 | 52 |
1519668 | 1519668 | 2021-07-15 | Brunswick | North Carolina | 37019 | 9469 | 156 |
1519669 | 1519669 | 2021-07-15 | Buncombe | North Carolina | 37021 | 18228 | 336 |
1519670 | 1519670 | 2021-07-15 | Burke | North Carolina | 37023 | 10183 | 164 |
1519671 | 1519671 | 2021-07-15 | Cabarrus | North Carolina | 37025 | 22608 | 264 |
1519672 | 1519672 | 2021-07-15 | Caldwell | North Carolina | 37027 | 9545 | 111 |
1519673 | 1519673 | 2021-07-15 | Camden | North Carolina | 37029 | 696 | 6 |
1519674 | 1519674 | 2021-07-15 | Carteret | North Carolina | 37031 | 5302 | 57 |
1519675 | 1519675 | 2021-07-15 | Caswell | North Carolina | 37033 | 2209 | 30 |
1519676 | 1519676 | 2021-07-15 | Catawba | North Carolina | 37035 | 19950 | 311 |
1519677 | 1519677 | 2021-07-15 | Chatham | North Carolina | 37037 | 4799 | 89 |
1519678 | 1519678 | 2021-07-15 | Cherokee | North Carolina | 37039 | 2669 | 39 |
1519679 | 1519679 | 2021-07-15 | Chowan | North Carolina | 37041 | 1512 | 35 |
1519680 | 1519680 | 2021-07-15 | Clay | North Carolina | 37043 | 916 | 18 |
1519681 | 1519681 | 2021-07-15 | Cleveland | North Carolina | 37045 | 11826 | 228 |
1519682 | 1519682 | 2021-07-15 | Columbus | North Carolina | 37047 | 6507 | 153 |
1519683 | 1519683 | 2021-07-15 | Craven | North Carolina | 37049 | 9512 | 128 |
1519684 | 1519684 | 2021-07-15 | Cumberland | North Carolina | 37051 | 30903 | 325 |
1519685 | 1519685 | 2021-07-15 | Currituck | North Carolina | 37053 | 1595 | 16 |
1519686 | 1519686 | 2021-07-15 | Dare | North Carolina | 37055 | 2246 | 10 |
1519687 | 1519687 | 2021-07-15 | Davidson | North Carolina | 37057 | 17083 | 201 |
1519688 | 1519688 | 2021-07-15 | Davie | North Carolina | 37059 | 4218 | 40 |
1519689 | 1519689 | 2021-07-15 | Duplin | North Carolina | 37061 | 6451 | 142 |
1519690 | 1519690 | 2021-07-15 | Durham | North Carolina | 37063 | 26212 | 237 |
1519691 | 1519691 | 2021-07-15 | Edgecombe | North Carolina | 37065 | 5738 | 113 |
1519692 | 1519692 | 2021-07-15 | Forsyth | North Carolina | 37067 | 37168 | 427 |
1519693 | 1519693 | 2021-07-15 | Franklin | North Carolina | 37069 | 7051 | 54 |
1519694 | 1519694 | 2021-07-15 | Gaston | North Carolina | 37071 | 27318 | 444 |
1519695 | 1519695 | 2021-07-15 | Gates | North Carolina | 37073 | 751 | 13 |
1519696 | 1519696 | 2021-07-15 | Graham | North Carolina | 37075 | 685 | 13 |
1519697 | 1519697 | 2021-07-15 | Granville | North Carolina | 37077 | 6016 | 83 |
1519698 | 1519698 | 2021-07-15 | Greene | North Carolina | 37079 | 2434 | 47 |
1519699 | 1519699 | 2021-07-15 | Guilford | North Carolina | 37081 | 48944 | 726 |
1519700 | 1519700 | 2021-07-15 | Halifax | North Carolina | 37083 | 5710 | 114 |
1519701 | 1519701 | 2021-07-15 | Harnett | North Carolina | 37085 | 12216 | 182 |
1519702 | 1519702 | 2021-07-15 | Haywood | North Carolina | 37087 | 4528 | 99 |
1519703 | 1519703 | 2021-07-15 | Henderson | North Carolina | 37089 | 10373 | 165 |
1519704 | 1519704 | 2021-07-15 | Hertford | North Carolina | 37091 | 2119 | 64 |
1519705 | 1519705 | 2021-07-15 | Hoke | North Carolina | 37093 | 4969 | 56 |
1519706 | 1519706 | 2021-07-15 | Hyde | North Carolina | 37095 | 670 | 9 |
1519707 | 1519707 | 2021-07-15 | Iredell | North Carolina | 37097 | 19427 | 236 |
1519708 | 1519708 | 2021-07-15 | Jackson | North Carolina | 37099 | 3671 | 56 |
1519709 | 1519709 | 2021-07-15 | Johnston | North Carolina | 37101 | 22594 | 239 |
1519710 | 1519710 | 2021-07-15 | Jones | North Carolina | 37103 | 908 | 28 |
1519711 | 1519711 | 2021-07-15 | Lee | North Carolina | 37105 | 6205 | 83 |
1519712 | 1519712 | 2021-07-15 | Lenoir | North Carolina | 37107 | 6299 | 127 |
1519713 | 1519713 | 2021-07-15 | Lincoln | North Carolina | 37109 | 10372 | 86 |
1519714 | 1519714 | 2021-07-15 | Macon | North Carolina | 37113 | 3186 | 41 |
1519715 | 1519715 | 2021-07-15 | Madison | North Carolina | 37115 | 1615 | 43 |
1519716 | 1519716 | 2021-07-15 | Martin | North Carolina | 37117 | 2340 | 46 |
1519717 | 1519717 | 2021-07-15 | McDowell | North Carolina | 37111 | 5313 | 63 |
1519718 | 1519718 | 2021-07-15 | Mecklenburg | North Carolina | 37119 | 115621 | 982 |
1519719 | 1519719 | 2021-07-15 | Mitchell | North Carolina | 37121 | 1477 | 16 |
1519720 | 1519720 | 2021-07-15 | Montgomery | North Carolina | 37123 | 3400 | 97 |
1519721 | 1519721 | 2021-07-15 | Moore | North Carolina | 37125 | 9124 | 195 |
1519722 | 1519722 | 2021-07-15 | Nash | North Carolina | 37127 | 11758 | 200 |
1519723 | 1519723 | 2021-07-15 | New Hanover | North Carolina | 37129 | 19668 | 176 |
1519724 | 1519724 | 2021-07-15 | Northampton | North Carolina | 37131 | 1899 | 61 |
1519725 | 1519725 | 2021-07-15 | Onslow | North Carolina | 37133 | 18132 | 154 |
1519726 | 1519726 | 2021-07-15 | Orange | North Carolina | 37135 | 8657 | 101 |
1519727 | 1519727 | 2021-07-15 | Pamlico | North Carolina | 37137 | 1120 | 13 |
1519728 | 1519728 | 2021-07-15 | Pasquotank | North Carolina | 37139 | 3468 | 86 |
1519729 | 1519729 | 2021-07-15 | Pender | North Carolina | 37141 | 5608 | 69 |
1519730 | 1519730 | 2021-07-15 | Perquimans | North Carolina | 37143 | 1034 | 11 |
1519731 | 1519731 | 2021-07-15 | Person | North Carolina | 37145 | 3553 | 71 |
1519732 | 1519732 | 2021-07-15 | Pitt | North Carolina | 37147 | 20713 | 96 |
1519733 | 1519733 | 2021-07-15 | Polk | North Carolina | 37149 | 1513 | 31 |
1519734 | 1519734 | 2021-07-15 | Randolph | North Carolina | 37151 | 15425 | 233 |
1519735 | 1519735 | 2021-07-15 | Richmond | North Carolina | 37153 | 4923 | 98 |
1519736 | 1519736 | 2021-07-15 | Robeson | North Carolina | 37155 | 17143 | 273 |
1519737 | 1519737 | 2021-07-15 | Rockingham | North Carolina | 37157 | 8166 | 166 |
1519738 | 1519738 | 2021-07-15 | Rowan | North Carolina | 37159 | 17400 | 313 |
1519739 | 1519739 | 2021-07-15 | Rutherford | North Carolina | 37161 | 7492 | 220 |
1519740 | 1519740 | 2021-07-15 | Sampson | North Carolina | 37163 | 8216 | 115 |
1519741 | 1519741 | 2021-07-15 | Scotland | North Carolina | 37165 | 3947 | 88 |
1519742 | 1519742 | 2021-07-15 | Stanly | North Carolina | 37167 | 7972 | 138 |
1519743 | 1519743 | 2021-07-15 | Stokes | North Carolina | 37169 | 4259 | 81 |
1519744 | 1519744 | 2021-07-15 | Surry | North Carolina | 37171 | 8478 | 171 |
1519745 | 1519745 | 2021-07-15 | Swain | North Carolina | 37173 | 1213 | 18 |
1519746 | 1519746 | 2021-07-15 | Transylvania | North Carolina | 37175 | 2398 | 33 |
1519747 | 1519747 | 2021-07-15 | Tyrrell | North Carolina | 37177 | 327 | 6 |
1519748 | 1519748 | 2021-07-15 | Union | North Carolina | 37179 | 25165 | 226 |
1519749 | 1519749 | 2021-07-15 | Vance | North Carolina | 37181 | 5004 | 90 |
1519750 | 1519750 | 2021-07-15 | Wake | North Carolina | 37183 | 91031 | 740 |
1519751 | 1519751 | 2021-07-15 | Warren | North Carolina | 37185 | 1819 | 20 |
1519752 | 1519752 | 2021-07-15 | Washington | North Carolina | 37187 | 1143 | 32 |
1519753 | 1519753 | 2021-07-15 | Watauga | North Carolina | 37189 | 5031 | 33 |
1519754 | 1519754 | 2021-07-15 | Wayne | North Carolina | 37191 | 11636 | 243 |
1519755 | 1519755 | 2021-07-15 | Wilkes | North Carolina | 37193 | 6986 | 117 |
1519756 | 1519756 | 2021-07-15 | Wilson | North Carolina | 37195 | 9991 | 181 |
1519757 | 1519757 | 2021-07-15 | Yadkin | North Carolina | 37197 | 4156 | 55 |
1519758 | 1519758 | 2021-07-15 | Yancey | North Carolina | 37199 | 1641 | 28 |
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);