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 2020-09-26 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 |
---|---|---|---|---|---|---|---|
571942 | 571942 | 2020-09-26 | Alamance | North Carolina | 37001 | 3916 | 54 |
571943 | 571943 | 2020-09-26 | Alexander | North Carolina | 37003 | 522 | 7 |
571944 | 571944 | 2020-09-26 | Alleghany | North Carolina | 37005 | 229 | 0 |
571945 | 571945 | 2020-09-26 | Anson | North Carolina | 37007 | 597 | 4 |
571946 | 571946 | 2020-09-26 | Ashe | North Carolina | 37009 | 268 | 1 |
571947 | 571947 | 2020-09-26 | Avery | North Carolina | 37011 | 355 | 0 |
571948 | 571948 | 2020-09-26 | Beaufort | North Carolina | 37013 | 944 | 23 |
571949 | 571949 | 2020-09-26 | Bertie | North Carolina | 37015 | 583 | 8 |
571950 | 571950 | 2020-09-26 | Bladen | North Carolina | 37017 | 896 | 15 |
571951 | 571951 | 2020-09-26 | Brunswick | North Carolina | 37019 | 1636 | 27 |
571952 | 571952 | 2020-09-26 | Buncombe | North Carolina | 37021 | 3101 | 92 |
571953 | 571953 | 2020-09-26 | Burke | North Carolina | 37023 | 2110 | 38 |
571954 | 571954 | 2020-09-26 | Cabarrus | North Carolina | 37025 | 3999 | 69 |
571955 | 571955 | 2020-09-26 | Caldwell | North Carolina | 37027 | 1657 | 18 |
571956 | 571956 | 2020-09-26 | Camden | North Carolina | 37029 | 114 | 3 |
571957 | 571957 | 2020-09-26 | Carteret | North Carolina | 37031 | 694 | 5 |
571958 | 571958 | 2020-09-26 | Caswell | North Carolina | 37033 | 352 | 4 |
571959 | 571959 | 2020-09-26 | Catawba | North Carolina | 37035 | 3152 | 52 |
571960 | 571960 | 2020-09-26 | Chatham | North Carolina | 37037 | 1669 | 57 |
571961 | 571961 | 2020-09-26 | Cherokee | North Carolina | 37039 | 619 | 12 |
571962 | 571962 | 2020-09-26 | Chowan | North Carolina | 37041 | 349 | 3 |
571963 | 571963 | 2020-09-26 | Clay | North Carolina | 37043 | 117 | 2 |
571964 | 571964 | 2020-09-26 | Cleveland | North Carolina | 37045 | 2202 | 62 |
571965 | 571965 | 2020-09-26 | Columbus | North Carolina | 37047 | 1368 | 57 |
571966 | 571966 | 2020-09-26 | Craven | North Carolina | 37049 | 1629 | 34 |
571967 | 571967 | 2020-09-26 | Cumberland | North Carolina | 37051 | 5446 | 76 |
571968 | 571968 | 2020-09-26 | Currituck | North Carolina | 37053 | 182 | 3 |
571969 | 571969 | 2020-09-26 | Dare | North Carolina | 37055 | 271 | 3 |
571970 | 571970 | 2020-09-26 | Davidson | North Carolina | 37057 | 2743 | 34 |
571971 | 571971 | 2020-09-26 | Davie | North Carolina | 37059 | 559 | 6 |
571972 | 571972 | 2020-09-26 | Duplin | North Carolina | 37061 | 2377 | 53 |
571973 | 571973 | 2020-09-26 | Durham | North Carolina | 37063 | 7712 | 95 |
571974 | 571974 | 2020-09-26 | Edgecombe | North Carolina | 37065 | 1349 | 47 |
571975 | 571975 | 2020-09-26 | Forsyth | North Carolina | 37067 | 6992 | 101 |
571976 | 571976 | 2020-09-26 | Franklin | North Carolina | 37069 | 1207 | 31 |
571977 | 571977 | 2020-09-26 | Gaston | North Carolina | 37071 | 5125 | 82 |
571978 | 571978 | 2020-09-26 | Gates | North Carolina | 37073 | 139 | 3 |
571979 | 571979 | 2020-09-26 | Graham | North Carolina | 37075 | 154 | 3 |
571980 | 571980 | 2020-09-26 | Granville | North Carolina | 37077 | 1723 | 50 |
571981 | 571981 | 2020-09-26 | Greene | North Carolina | 37079 | 601 | 5 |
571982 | 571982 | 2020-09-26 | Guilford | North Carolina | 37081 | 8541 | 180 |
571983 | 571983 | 2020-09-26 | Halifax | North Carolina | 37083 | 1022 | 19 |
571984 | 571984 | 2020-09-26 | Harnett | North Carolina | 37085 | 2226 | 53 |
571985 | 571985 | 2020-09-26 | Haywood | North Carolina | 37087 | 607 | 31 |
571986 | 571986 | 2020-09-26 | Henderson | North Carolina | 37089 | 2005 | 64 |
571987 | 571987 | 2020-09-26 | Hertford | North Carolina | 37091 | 747 | 30 |
571988 | 571988 | 2020-09-26 | Hoke | North Carolina | 37093 | 1153 | 17 |
571989 | 571989 | 2020-09-26 | Hyde | North Carolina | 37095 | 125 | 5 |
571990 | 571990 | 2020-09-26 | Iredell | North Carolina | 37097 | 3068 | 32 |
571991 | 571991 | 2020-09-26 | Jackson | North Carolina | 37099 | 648 | 7 |
571992 | 571992 | 2020-09-26 | Johnston | North Carolina | 37101 | 4480 | 56 |
571993 | 571993 | 2020-09-26 | Jones | North Carolina | 37103 | 157 | 11 |
571994 | 571994 | 2020-09-26 | Lee | North Carolina | 37105 | 1635 | 14 |
571995 | 571995 | 2020-09-26 | Lenoir | North Carolina | 37107 | 1005 | 32 |
571996 | 571996 | 2020-09-26 | Lincoln | North Carolina | 37109 | 1599 | 14 |
571997 | 571997 | 2020-09-26 | Macon | North Carolina | 37113 | 596 | 2 |
571998 | 571998 | 2020-09-26 | Madison | North Carolina | 37115 | 103 | 1 |
571999 | 571999 | 2020-09-26 | Martin | North Carolina | 37117 | 456 | 10 |
572000 | 572000 | 2020-09-26 | McDowell | North Carolina | 37111 | 979 | 26 |
572001 | 572001 | 2020-09-26 | Mecklenburg | North Carolina | 37119 | 28579 | 355 |
572002 | 572002 | 2020-09-26 | Mitchell | North Carolina | 37121 | 151 | 3 |
572003 | 572003 | 2020-09-26 | Montgomery | North Carolina | 37123 | 1047 | 30 |
572004 | 572004 | 2020-09-26 | Moore | North Carolina | 37125 | 1651 | 29 |
572005 | 572005 | 2020-09-26 | Nash | North Carolina | 37127 | 2332 | 39 |
572006 | 572006 | 2020-09-26 | New Hanover | North Carolina | 37129 | 4268 | 30 |
572007 | 572007 | 2020-09-26 | Northampton | North Carolina | 37131 | 450 | 17 |
572008 | 572008 | 2020-09-26 | Onslow | North Carolina | 37133 | 2180 | 25 |
572009 | 572009 | 2020-09-26 | Orange | North Carolina | 37135 | 2653 | 55 |
572010 | 572010 | 2020-09-26 | Pamlico | North Carolina | 37137 | 269 | 2 |
572011 | 572011 | 2020-09-26 | Pasquotank | North Carolina | 37139 | 700 | 30 |
572012 | 572012 | 2020-09-26 | Pender | North Carolina | 37141 | 956 | 5 |
572013 | 572013 | 2020-09-26 | Perquimans | North Carolina | 37143 | 187 | 3 |
572014 | 572014 | 2020-09-26 | Person | North Carolina | 37145 | 430 | 7 |
572015 | 572015 | 2020-09-26 | Pitt | North Carolina | 37147 | 4895 | 29 |
572016 | 572016 | 2020-09-26 | Polk | North Carolina | 37149 | 311 | 11 |
572017 | 572017 | 2020-09-26 | Randolph | North Carolina | 37151 | 2821 | 52 |
572018 | 572018 | 2020-09-26 | Richmond | North Carolina | 37153 | 1010 | 16 |
572019 | 572019 | 2020-09-26 | Robeson | North Carolina | 37155 | 4484 | 75 |
572020 | 572020 | 2020-09-26 | Rockingham | North Carolina | 37157 | 1242 | 14 |
572021 | 572021 | 2020-09-26 | Rowan | North Carolina | 37159 | 3354 | 100 |
572022 | 572022 | 2020-09-26 | Rutherford | North Carolina | 37161 | 1191 | 33 |
572023 | 572023 | 2020-09-26 | Sampson | North Carolina | 37163 | 2224 | 28 |
572024 | 572024 | 2020-09-26 | Scotland | North Carolina | 37165 | 1154 | 13 |
572025 | 572025 | 2020-09-26 | Stanly | North Carolina | 37167 | 1946 | 56 |
572026 | 572026 | 2020-09-26 | Stokes | North Carolina | 37169 | 431 | 3 |
572027 | 572027 | 2020-09-26 | Surry | North Carolina | 37171 | 1316 | 23 |
572028 | 572028 | 2020-09-26 | Swain | North Carolina | 37173 | 144 | 3 |
572029 | 572029 | 2020-09-26 | Transylvania | North Carolina | 37175 | 330 | 7 |
572030 | 572030 | 2020-09-26 | Tyrrell | North Carolina | 37177 | 116 | 3 |
572031 | 572031 | 2020-09-26 | Union | North Carolina | 37179 | 4778 | 59 |
572032 | 572032 | 2020-09-26 | Vance | North Carolina | 37181 | 1039 | 44 |
572033 | 572033 | 2020-09-26 | Wake | North Carolina | 37183 | 17654 | 243 |
572034 | 572034 | 2020-09-26 | Warren | North Carolina | 37185 | 338 | 7 |
572035 | 572035 | 2020-09-26 | Washington | North Carolina | 37187 | 208 | 8 |
572036 | 572036 | 2020-09-26 | Watauga | North Carolina | 37189 | 830 | 1 |
572037 | 572037 | 2020-09-26 | Wayne | North Carolina | 37191 | 3366 | 67 |
572038 | 572038 | 2020-09-26 | Wilkes | North Carolina | 37193 | 1224 | 33 |
572039 | 572039 | 2020-09-26 | Wilson | North Carolina | 37195 | 2219 | 49 |
572040 | 572040 | 2020-09-26 | Yadkin | North Carolina | 37197 | 741 | 8 |
572041 | 572041 | 2020-09-26 | Yancey | North Carolina | 37199 | 212 | 0 |
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);