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-02-20 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
1048917 | 1048917 | 2021-02-20 | Alamance | North Carolina | 37001 | 15331 | 217 |
1048918 | 1048918 | 2021-02-20 | Alexander | North Carolina | 37003 | 3832 | 72 |
1048919 | 1048919 | 2021-02-20 | Alleghany | North Carolina | 37005 | 901 | 4 |
1048920 | 1048920 | 2021-02-20 | Anson | North Carolina | 37007 | 2239 | 51 |
1048921 | 1048921 | 2021-02-20 | Ashe | North Carolina | 37009 | 1827 | 40 |
1048922 | 1048922 | 2021-02-20 | Avery | North Carolina | 37011 | 1792 | 20 |
1048923 | 1048923 | 2021-02-20 | Beaufort | North Carolina | 37013 | 4154 | 79 |
1048924 | 1048924 | 2021-02-20 | Bertie | North Carolina | 37015 | 1610 | 40 |
1048925 | 1048925 | 2021-02-20 | Bladen | North Carolina | 37017 | 2895 | 38 |
1048926 | 1048926 | 2021-02-20 | Brunswick | North Carolina | 37019 | 7752 | 130 |
1048927 | 1048927 | 2021-02-20 | Buncombe | North Carolina | 37021 | 14992 | 297 |
1048928 | 1048928 | 2021-02-20 | Burke | North Carolina | 37023 | 9068 | 135 |
1048929 | 1048929 | 2021-02-20 | Cabarrus | North Carolina | 37025 | 17971 | 225 |
1048930 | 1048930 | 2021-02-20 | Caldwell | North Carolina | 37027 | 8461 | 66 |
1048931 | 1048931 | 2021-02-20 | Camden | North Carolina | 37029 | 562 | 5 |
1048932 | 1048932 | 2021-02-20 | Carteret | North Carolina | 37031 | 4314 | 43 |
1048933 | 1048933 | 2021-02-20 | Caswell | North Carolina | 37033 | 1910 | 19 |
1048934 | 1048934 | 2021-02-20 | Catawba | North Carolina | 37035 | 17114 | 272 |
1048935 | 1048935 | 2021-02-20 | Chatham | North Carolina | 37037 | 4063 | 74 |
1048936 | 1048936 | 2021-02-20 | Cherokee | North Carolina | 37039 | 2056 | 17 |
1048937 | 1048937 | 2021-02-20 | Chowan | North Carolina | 37041 | 1339 | 22 |
1048938 | 1048938 | 2021-02-20 | Clay | North Carolina | 37043 | 645 | 18 |
1048939 | 1048939 | 2021-02-20 | Cleveland | North Carolina | 37045 | 10025 | 211 |
1048940 | 1048940 | 2021-02-20 | Columbus | North Carolina | 37047 | 5696 | 140 |
1048941 | 1048941 | 2021-02-20 | Craven | North Carolina | 37049 | 8074 | 113 |
1048942 | 1048942 | 2021-02-20 | Cumberland | North Carolina | 37051 | 23411 | 260 |
1048943 | 1048943 | 2021-02-20 | Currituck | North Carolina | 37053 | 1340 | 15 |
1048944 | 1048944 | 2021-02-20 | Dare | North Carolina | 37055 | 1835 | 8 |
1048945 | 1048945 | 2021-02-20 | Davidson | North Carolina | 37057 | 14359 | 149 |
1048946 | 1048946 | 2021-02-20 | Davie | North Carolina | 37059 | 3448 | 28 |
1048947 | 1048947 | 2021-02-20 | Duplin | North Carolina | 37061 | 5600 | 124 |
1048948 | 1048948 | 2021-02-20 | Durham | North Carolina | 37063 | 21630 | 206 |
1048949 | 1048949 | 2021-02-20 | Edgecombe | North Carolina | 37065 | 4532 | 99 |
1048950 | 1048950 | 2021-02-20 | Forsyth | North Carolina | 37067 | 31064 | 337 |
1048951 | 1048951 | 2021-02-20 | Franklin | North Carolina | 37069 | 5143 | 43 |
1048952 | 1048952 | 2021-02-20 | Gaston | North Carolina | 37071 | 23236 | 372 |
1048953 | 1048953 | 2021-02-20 | Gates | North Carolina | 37073 | 663 | 12 |
1048954 | 1048954 | 2021-02-20 | Graham | North Carolina | 37075 | 551 | 12 |
1048955 | 1048955 | 2021-02-20 | Granville | North Carolina | 37077 | 5093 | 76 |
1048956 | 1048956 | 2021-02-20 | Greene | North Carolina | 37079 | 2120 | 38 |
1048957 | 1048957 | 2021-02-20 | Guilford | North Carolina | 37081 | 38935 | 537 |
1048958 | 1048958 | 2021-02-20 | Halifax | North Carolina | 37083 | 4922 | 95 |
1048959 | 1048959 | 2021-02-20 | Harnett | North Carolina | 37085 | 9336 | 147 |
1048960 | 1048960 | 2021-02-20 | Haywood | North Carolina | 37087 | 3767 | 83 |
1048961 | 1048961 | 2021-02-20 | Henderson | North Carolina | 37089 | 8534 | 127 |
1048962 | 1048962 | 2021-02-20 | Hertford | North Carolina | 37091 | 1919 | 56 |
1048963 | 1048963 | 2021-02-20 | Hoke | North Carolina | 37093 | 4029 | 53 |
1048964 | 1048964 | 2021-02-20 | Hyde | North Carolina | 37095 | 618 | 8 |
1048965 | 1048965 | 2021-02-20 | Iredell | North Carolina | 37097 | 16001 | 183 |
1048966 | 1048966 | 2021-02-20 | Jackson | North Carolina | 37099 | 3239 | 48 |
1048967 | 1048967 | 2021-02-20 | Johnston | North Carolina | 37101 | 17460 | 182 |
1048968 | 1048968 | 2021-02-20 | Jones | North Carolina | 37103 | 692 | 16 |
1048969 | 1048969 | 2021-02-20 | Lee | North Carolina | 37105 | 5324 | 66 |
1048970 | 1048970 | 2021-02-20 | Lenoir | North Carolina | 37107 | 5334 | 104 |
1048971 | 1048971 | 2021-02-20 | Lincoln | North Carolina | 37109 | 8607 | 66 |
1048972 | 1048972 | 2021-02-20 | Macon | North Carolina | 37113 | 2522 | 26 |
1048973 | 1048973 | 2021-02-20 | Madison | North Carolina | 37115 | 1324 | 32 |
1048974 | 1048974 | 2021-02-20 | Martin | North Carolina | 37117 | 2033 | 37 |
1048975 | 1048975 | 2021-02-20 | McDowell | North Carolina | 37111 | 4713 | 55 |
1048976 | 1048976 | 2021-02-20 | Mecklenburg | North Carolina | 37119 | 94622 | 844 |
1048977 | 1048977 | 2021-02-20 | Mitchell | North Carolina | 37121 | 1229 | 15 |
1048978 | 1048978 | 2021-02-20 | Montgomery | North Carolina | 37123 | 2978 | 84 |
1048979 | 1048979 | 2021-02-20 | Moore | North Carolina | 37125 | 7735 | 170 |
1048980 | 1048980 | 2021-02-20 | Nash | North Carolina | 37127 | 9466 | 167 |
1048981 | 1048981 | 2021-02-20 | New Hanover | North Carolina | 37129 | 15711 | 139 |
1048982 | 1048982 | 2021-02-20 | Northampton | North Carolina | 37131 | 1659 | 28 |
1048983 | 1048983 | 2021-02-20 | Onslow | North Carolina | 37133 | 14346 | 133 |
1048984 | 1048984 | 2021-02-20 | Orange | North Carolina | 37135 | 7555 | 93 |
1048985 | 1048985 | 2021-02-20 | Pamlico | North Carolina | 37137 | 917 | 9 |
1048986 | 1048986 | 2021-02-20 | Pasquotank | North Carolina | 37139 | 3007 | 74 |
1048987 | 1048987 | 2021-02-20 | Pender | North Carolina | 37141 | 4524 | 53 |
1048988 | 1048988 | 2021-02-20 | Perquimans | North Carolina | 37143 | 876 | 7 |
1048989 | 1048989 | 2021-02-20 | Person | North Carolina | 37145 | 2880 | 61 |
1048990 | 1048990 | 2021-02-20 | Pitt | North Carolina | 37147 | 17087 | 76 |
1048991 | 1048991 | 2021-02-20 | Polk | North Carolina | 37149 | 1325 | 25 |
1048992 | 1048992 | 2021-02-20 | Randolph | North Carolina | 37151 | 12821 | 196 |
1048993 | 1048993 | 2021-02-20 | Richmond | North Carolina | 37153 | 4093 | 87 |
1048994 | 1048994 | 2021-02-20 | Robeson | North Carolina | 37155 | 14829 | 199 |
1048995 | 1048995 | 2021-02-20 | Rockingham | North Carolina | 37157 | 6689 | 59 |
1048996 | 1048996 | 2021-02-20 | Rowan | North Carolina | 37159 | 14542 | 269 |
1048997 | 1048997 | 2021-02-20 | Rutherford | North Carolina | 37161 | 6655 | 193 |
1048998 | 1048998 | 2021-02-20 | Sampson | North Carolina | 37163 | 6558 | 89 |
1048999 | 1048999 | 2021-02-20 | Scotland | North Carolina | 37165 | 3423 | 72 |
1049000 | 1049000 | 2021-02-20 | Stanly | North Carolina | 37167 | 6613 | 111 |
1049001 | 1049001 | 2021-02-20 | Stokes | North Carolina | 37169 | 3585 | 64 |
1049002 | 1049002 | 2021-02-20 | Surry | North Carolina | 37171 | 7215 | 129 |
1049003 | 1049003 | 2021-02-20 | Swain | North Carolina | 37173 | 1141 | 16 |
1049004 | 1049004 | 2021-02-20 | Transylvania | North Carolina | 37175 | 1855 | 26 |
1049005 | 1049005 | 2021-02-20 | Tyrrell | North Carolina | 37177 | 299 | 6 |
1049006 | 1049006 | 2021-02-20 | Union | North Carolina | 37179 | 20200 | 189 |
1049007 | 1049007 | 2021-02-20 | Vance | North Carolina | 37181 | 4160 | 78 |
1049008 | 1049008 | 2021-02-20 | Wake | North Carolina | 37183 | 73227 | 523 |
1049009 | 1049009 | 2021-02-20 | Warren | North Carolina | 37185 | 1559 | 18 |
1049010 | 1049010 | 2021-02-20 | Washington | North Carolina | 37187 | 951 | 28 |
1049011 | 1049011 | 2021-02-20 | Watauga | North Carolina | 37189 | 3815 | 29 |
1049012 | 1049012 | 2021-02-20 | Wayne | North Carolina | 37191 | 10126 | 210 |
1049013 | 1049013 | 2021-02-20 | Wilkes | North Carolina | 37193 | 5889 | 100 |
1049014 | 1049014 | 2021-02-20 | Wilson | North Carolina | 37195 | 8198 | 145 |
1049015 | 1049015 | 2021-02-20 | Yadkin | North Carolina | 37197 | 3573 | 45 |
1049016 | 1049016 | 2021-02-20 | Yancey | North Carolina | 37199 | 1425 | 23 |
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);