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-07-06 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 |
---|---|---|---|---|---|---|---|
307879 | 307879 | 2020-07-06 | Alamance | North Carolina | 37001 | 1292 | 37 |
307880 | 307880 | 2020-07-06 | Alexander | North Carolina | 37003 | 124 | 1 |
307881 | 307881 | 2020-07-06 | Alleghany | North Carolina | 37005 | 37 | 0 |
307882 | 307882 | 2020-07-06 | Anson | North Carolina | 37007 | 155 | 1 |
307883 | 307883 | 2020-07-06 | Ashe | North Carolina | 37009 | 60 | 1 |
307884 | 307884 | 2020-07-06 | Avery | North Carolina | 37011 | 18 | 0 |
307885 | 307885 | 2020-07-06 | Beaufort | North Carolina | 37013 | 108 | 0 |
307886 | 307886 | 2020-07-06 | Bertie | North Carolina | 37015 | 151 | 4 |
307887 | 307887 | 2020-07-06 | Bladen | North Carolina | 37017 | 399 | 3 |
307888 | 307888 | 2020-07-06 | Brunswick | North Carolina | 37019 | 674 | 8 |
307889 | 307889 | 2020-07-06 | Buncombe | North Carolina | 37021 | 693 | 39 |
307890 | 307890 | 2020-07-06 | Burke | North Carolina | 37023 | 1110 | 20 |
307891 | 307891 | 2020-07-06 | Cabarrus | North Carolina | 37025 | 1368 | 33 |
307892 | 307892 | 2020-07-06 | Caldwell | North Carolina | 37027 | 522 | 4 |
307893 | 307893 | 2020-07-06 | Camden | North Carolina | 37029 | 31 | 0 |
307894 | 307894 | 2020-07-06 | Carteret | North Carolina | 37031 | 109 | 3 |
307895 | 307895 | 2020-07-06 | Caswell | North Carolina | 37033 | 147 | 2 |
307896 | 307896 | 2020-07-06 | Catawba | North Carolina | 37035 | 980 | 12 |
307897 | 307897 | 2020-07-06 | Chatham | North Carolina | 37037 | 994 | 43 |
307898 | 307898 | 2020-07-06 | Cherokee | North Carolina | 37039 | 45 | 2 |
307899 | 307899 | 2020-07-06 | Chowan | North Carolina | 37041 | 29 | 0 |
307900 | 307900 | 2020-07-06 | Clay | North Carolina | 37043 | 12 | 0 |
307901 | 307901 | 2020-07-06 | Cleveland | North Carolina | 37045 | 398 | 5 |
307902 | 307902 | 2020-07-06 | Columbus | North Carolina | 37047 | 565 | 39 |
307903 | 307903 | 2020-07-06 | Craven | North Carolina | 37049 | 402 | 6 |
307904 | 307904 | 2020-07-06 | Cumberland | North Carolina | 37051 | 1374 | 41 |
307905 | 307905 | 2020-07-06 | Currituck | North Carolina | 37053 | 20 | 0 |
307906 | 307906 | 2020-07-06 | Dare | North Carolina | 37055 | 76 | 1 |
307907 | 307907 | 2020-07-06 | Davidson | North Carolina | 37057 | 1102 | 15 |
307908 | 307908 | 2020-07-06 | Davie | North Carolina | 37059 | 223 | 3 |
307909 | 307909 | 2020-07-06 | Duplin | North Carolina | 37061 | 1579 | 28 |
307910 | 307910 | 2020-07-06 | Durham | North Carolina | 37063 | 4176 | 67 |
307911 | 307911 | 2020-07-06 | Edgecombe | North Carolina | 37065 | 347 | 9 |
307912 | 307912 | 2020-07-06 | Forsyth | North Carolina | 37067 | 3353 | 37 |
307913 | 307913 | 2020-07-06 | Franklin | North Carolina | 37069 | 388 | 21 |
307914 | 307914 | 2020-07-06 | Gaston | North Carolina | 37071 | 1385 | 12 |
307915 | 307915 | 2020-07-06 | Gates | North Carolina | 37073 | 27 | 2 |
307916 | 307916 | 2020-07-06 | Graham | North Carolina | 37075 | 10 | 0 |
307917 | 307917 | 2020-07-06 | Granville | North Carolina | 37077 | 854 | 21 |
307918 | 307918 | 2020-07-06 | Greene | North Carolina | 37079 | 190 | 3 |
307919 | 307919 | 2020-07-06 | Guilford | North Carolina | 37081 | 3149 | 118 |
307920 | 307920 | 2020-07-06 | Halifax | North Carolina | 37083 | 325 | 4 |
307921 | 307921 | 2020-07-06 | Harnett | North Carolina | 37085 | 705 | 30 |
307922 | 307922 | 2020-07-06 | Haywood | North Carolina | 37087 | 106 | 0 |
307923 | 307923 | 2020-07-06 | Henderson | North Carolina | 37089 | 720 | 51 |
307924 | 307924 | 2020-07-06 | Hertford | North Carolina | 37091 | 171 | 10 |
307925 | 307925 | 2020-07-06 | Hoke | North Carolina | 37093 | 407 | 3 |
307926 | 307926 | 2020-07-06 | Hyde | North Carolina | 37095 | 20 | 0 |
307927 | 307927 | 2020-07-06 | Iredell | North Carolina | 37097 | 918 | 7 |
307928 | 307928 | 2020-07-06 | Jackson | North Carolina | 37099 | 141 | 1 |
307929 | 307929 | 2020-07-06 | Johnston | North Carolina | 37101 | 1786 | 33 |
307930 | 307930 | 2020-07-06 | Jones | North Carolina | 37103 | 38 | 3 |
307931 | 307931 | 2020-07-06 | Lee | North Carolina | 37105 | 871 | 8 |
307932 | 307932 | 2020-07-06 | Lenoir | North Carolina | 37107 | 382 | 11 |
307933 | 307933 | 2020-07-06 | Lincoln | North Carolina | 37109 | 323 | 1 |
307934 | 307934 | 2020-07-06 | Macon | North Carolina | 37113 | 291 | 1 |
307935 | 307935 | 2020-07-06 | Madison | North Carolina | 37115 | 17 | 0 |
307936 | 307936 | 2020-07-06 | Martin | North Carolina | 37117 | 145 | 4 |
307937 | 307937 | 2020-07-06 | McDowell | North Carolina | 37111 | 271 | 2 |
307938 | 307938 | 2020-07-06 | Mecklenburg | North Carolina | 37119 | 13111 | 156 |
307939 | 307939 | 2020-07-06 | Mitchell | North Carolina | 37121 | 49 | 0 |
307940 | 307940 | 2020-07-06 | Montgomery | North Carolina | 37123 | 347 | 7 |
307941 | 307941 | 2020-07-06 | Moore | North Carolina | 37125 | 533 | 13 |
307942 | 307942 | 2020-07-06 | Nash | North Carolina | 37127 | 541 | 6 |
307943 | 307943 | 2020-07-06 | New Hanover | North Carolina | 37129 | 1138 | 7 |
307944 | 307944 | 2020-07-06 | Northampton | North Carolina | 37131 | 191 | 15 |
307945 | 307945 | 2020-07-06 | Onslow | North Carolina | 37133 | 353 | 3 |
307946 | 307946 | 2020-07-06 | Orange | North Carolina | 37135 | 839 | 42 |
307947 | 307947 | 2020-07-06 | Pamlico | North Carolina | 37137 | 26 | 0 |
307948 | 307948 | 2020-07-06 | Pasquotank | North Carolina | 37139 | 221 | 17 |
307949 | 307949 | 2020-07-06 | Pender | North Carolina | 37141 | 303 | 2 |
307950 | 307950 | 2020-07-06 | Perquimans | North Carolina | 37143 | 37 | 2 |
307951 | 307951 | 2020-07-06 | Person | North Carolina | 37145 | 120 | 1 |
307952 | 307952 | 2020-07-06 | Pitt | North Carolina | 37147 | 822 | 6 |
307953 | 307953 | 2020-07-06 | Polk | North Carolina | 37149 | 85 | 4 |
307954 | 307954 | 2020-07-06 | Randolph | North Carolina | 37151 | 1316 | 31 |
307955 | 307955 | 2020-07-06 | Richmond | North Carolina | 37153 | 325 | 7 |
307956 | 307956 | 2020-07-06 | Robeson | North Carolina | 37155 | 1429 | 44 |
307957 | 307957 | 2020-07-06 | Rockingham | North Carolina | 37157 | 267 | 2 |
307958 | 307958 | 2020-07-06 | Rowan | North Carolina | 37159 | 1368 | 43 |
307959 | 307959 | 2020-07-06 | Rutherford | North Carolina | 37161 | 360 | 10 |
307960 | 307960 | 2020-07-06 | Sampson | North Carolina | 37163 | 1112 | 6 |
307961 | 307961 | 2020-07-06 | Scotland | North Carolina | 37165 | 151 | 2 |
307962 | 307962 | 2020-07-06 | Stanly | North Carolina | 37167 | 479 | 5 |
307963 | 307963 | 2020-07-06 | Stokes | North Carolina | 37169 | 143 | 1 |
307964 | 307964 | 2020-07-06 | Surry | North Carolina | 37171 | 516 | 2 |
307965 | 307965 | 2020-07-06 | Swain | North Carolina | 37173 | 59 | 1 |
307966 | 307966 | 2020-07-06 | Transylvania | North Carolina | 37175 | 36 | 1 |
307967 | 307967 | 2020-07-06 | Tyrrell | North Carolina | 37177 | 16 | 0 |
307968 | 307968 | 2020-07-06 | Union | North Carolina | 37179 | 1528 | 25 |
307969 | 307969 | 2020-07-06 | Vance | North Carolina | 37181 | 527 | 38 |
307970 | 307970 | 2020-07-06 | Wake | North Carolina | 37183 | 6265 | 49 |
307971 | 307971 | 2020-07-06 | Warren | North Carolina | 37185 | 174 | 5 |
307972 | 307972 | 2020-07-06 | Washington | North Carolina | 37187 | 40 | 3 |
307973 | 307973 | 2020-07-06 | Watauga | North Carolina | 37189 | 99 | 0 |
307974 | 307974 | 2020-07-06 | Wayne | North Carolina | 37191 | 1913 | 28 |
307975 | 307975 | 2020-07-06 | Wilkes | North Carolina | 37193 | 593 | 6 |
307976 | 307976 | 2020-07-06 | Wilson | North Carolina | 37195 | 786 | 19 |
307977 | 307977 | 2020-07-06 | Yadkin | North Carolina | 37197 | 351 | 5 |
307978 | 307978 | 2020-07-06 | Yancey | North Carolina | 37199 | 51 | 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);