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-17 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 |
---|---|---|---|---|---|---|---|
342898 | 342898 | 2020-07-17 | Alamance | North Carolina | 37001 | 1607 | 38 |
342899 | 342899 | 2020-07-17 | Alexander | North Carolina | 37003 | 197 | 1 |
342900 | 342900 | 2020-07-17 | Alleghany | North Carolina | 37005 | 50 | 0 |
342901 | 342901 | 2020-07-17 | Anson | North Carolina | 37007 | 240 | 1 |
342902 | 342902 | 2020-07-17 | Ashe | North Carolina | 37009 | 67 | 1 |
342903 | 342903 | 2020-07-17 | Avery | North Carolina | 37011 | 39 | 0 |
342904 | 342904 | 2020-07-17 | Beaufort | North Carolina | 37013 | 185 | 0 |
342905 | 342905 | 2020-07-17 | Bertie | North Carolina | 37015 | 168 | 4 |
342906 | 342906 | 2020-07-17 | Bladen | North Carolina | 37017 | 474 | 5 |
342907 | 342907 | 2020-07-17 | Brunswick | North Carolina | 37019 | 916 | 13 |
342908 | 342908 | 2020-07-17 | Buncombe | North Carolina | 37021 | 1044 | 50 |
342909 | 342909 | 2020-07-17 | Burke | North Carolina | 37023 | 1292 | 21 |
342910 | 342910 | 2020-07-17 | Cabarrus | North Carolina | 37025 | 1828 | 33 |
342911 | 342911 | 2020-07-17 | Caldwell | North Carolina | 37027 | 732 | 6 |
342912 | 342912 | 2020-07-17 | Camden | North Carolina | 37029 | 44 | 1 |
342913 | 342913 | 2020-07-17 | Carteret | North Carolina | 37031 | 168 | 4 |
342914 | 342914 | 2020-07-17 | Caswell | North Carolina | 37033 | 160 | 2 |
342915 | 342915 | 2020-07-17 | Catawba | North Carolina | 37035 | 1404 | 14 |
342916 | 342916 | 2020-07-17 | Chatham | North Carolina | 37037 | 1088 | 47 |
342917 | 342917 | 2020-07-17 | Cherokee | North Carolina | 37039 | 108 | 2 |
342918 | 342918 | 2020-07-17 | Chowan | North Carolina | 37041 | 44 | 0 |
342919 | 342919 | 2020-07-17 | Clay | North Carolina | 37043 | 27 | 0 |
342920 | 342920 | 2020-07-17 | Cleveland | North Carolina | 37045 | 621 | 10 |
342921 | 342921 | 2020-07-17 | Columbus | North Carolina | 37047 | 672 | 39 |
342922 | 342922 | 2020-07-17 | Craven | North Carolina | 37049 | 488 | 8 |
342923 | 342923 | 2020-07-17 | Cumberland | North Carolina | 37051 | 1829 | 46 |
342924 | 342924 | 2020-07-17 | Currituck | North Carolina | 37053 | 39 | 0 |
342925 | 342925 | 2020-07-17 | Dare | North Carolina | 37055 | 134 | 1 |
342926 | 342926 | 2020-07-17 | Davidson | North Carolina | 37057 | 1351 | 16 |
342927 | 342927 | 2020-07-17 | Davie | North Carolina | 37059 | 269 | 3 |
342928 | 342928 | 2020-07-17 | Duplin | North Carolina | 37061 | 1732 | 33 |
342929 | 342929 | 2020-07-17 | Durham | North Carolina | 37063 | 4944 | 72 |
342930 | 342930 | 2020-07-17 | Edgecombe | North Carolina | 37065 | 420 | 9 |
342931 | 342931 | 2020-07-17 | Forsyth | North Carolina | 37067 | 4008 | 40 |
342932 | 342932 | 2020-07-17 | Franklin | North Carolina | 37069 | 560 | 23 |
342933 | 342933 | 2020-07-17 | Gaston | North Carolina | 37071 | 2120 | 17 |
342934 | 342934 | 2020-07-17 | Gates | North Carolina | 37073 | 30 | 2 |
342935 | 342935 | 2020-07-17 | Graham | North Carolina | 37075 | 10 | 0 |
342936 | 342936 | 2020-07-17 | Granville | North Carolina | 37077 | 994 | 25 |
342937 | 342937 | 2020-07-17 | Greene | North Carolina | 37079 | 250 | 3 |
342938 | 342938 | 2020-07-17 | Guilford | North Carolina | 37081 | 3949 | 133 |
342939 | 342939 | 2020-07-17 | Halifax | North Carolina | 37083 | 457 | 4 |
342940 | 342940 | 2020-07-17 | Harnett | North Carolina | 37085 | 844 | 32 |
342941 | 342941 | 2020-07-17 | Haywood | North Carolina | 37087 | 154 | 0 |
342942 | 342942 | 2020-07-17 | Henderson | North Carolina | 37089 | 1034 | 51 |
342943 | 342943 | 2020-07-17 | Hertford | North Carolina | 37091 | 184 | 11 |
342944 | 342944 | 2020-07-17 | Hoke | North Carolina | 37093 | 509 | 5 |
342945 | 342945 | 2020-07-17 | Hyde | North Carolina | 37095 | 33 | 0 |
342946 | 342946 | 2020-07-17 | Iredell | North Carolina | 37097 | 1265 | 10 |
342947 | 342947 | 2020-07-17 | Jackson | North Carolina | 37099 | 252 | 3 |
342948 | 342948 | 2020-07-17 | Johnston | North Carolina | 37101 | 2295 | 39 |
342949 | 342949 | 2020-07-17 | Jones | North Carolina | 37103 | 42 | 3 |
342950 | 342950 | 2020-07-17 | Lee | North Carolina | 37105 | 968 | 8 |
342951 | 342951 | 2020-07-17 | Lenoir | North Carolina | 37107 | 444 | 11 |
342952 | 342952 | 2020-07-17 | Lincoln | North Carolina | 37109 | 521 | 2 |
342953 | 342953 | 2020-07-17 | Macon | North Carolina | 37113 | 368 | 1 |
342954 | 342954 | 2020-07-17 | Madison | North Carolina | 37115 | 20 | 0 |
342955 | 342955 | 2020-07-17 | Martin | North Carolina | 37117 | 177 | 6 |
342956 | 342956 | 2020-07-17 | McDowell | North Carolina | 37111 | 355 | 3 |
342957 | 342957 | 2020-07-17 | Mecklenburg | North Carolina | 37119 | 16657 | 177 |
342958 | 342958 | 2020-07-17 | Mitchell | North Carolina | 37121 | 58 | 1 |
342959 | 342959 | 2020-07-17 | Montgomery | North Carolina | 37123 | 430 | 10 |
342960 | 342960 | 2020-07-17 | Moore | North Carolina | 37125 | 684 | 14 |
342961 | 342961 | 2020-07-17 | Nash | North Carolina | 37127 | 719 | 6 |
342962 | 342962 | 2020-07-17 | New Hanover | North Carolina | 37129 | 1712 | 9 |
342963 | 342963 | 2020-07-17 | Northampton | North Carolina | 37131 | 210 | 16 |
342964 | 342964 | 2020-07-17 | Onslow | North Carolina | 37133 | 507 | 5 |
342965 | 342965 | 2020-07-17 | Orange | North Carolina | 37135 | 1050 | 45 |
342966 | 342966 | 2020-07-17 | Pamlico | North Carolina | 37137 | 40 | 1 |
342967 | 342967 | 2020-07-17 | Pasquotank | North Carolina | 37139 | 262 | 17 |
342968 | 342968 | 2020-07-17 | Pender | North Carolina | 37141 | 446 | 2 |
342969 | 342969 | 2020-07-17 | Perquimans | North Carolina | 37143 | 43 | 2 |
342970 | 342970 | 2020-07-17 | Person | North Carolina | 37145 | 139 | 1 |
342971 | 342971 | 2020-07-17 | Pitt | North Carolina | 37147 | 1079 | 6 |
342972 | 342972 | 2020-07-17 | Polk | North Carolina | 37149 | 105 | 5 |
342973 | 342973 | 2020-07-17 | Randolph | North Carolina | 37151 | 1636 | 33 |
342974 | 342974 | 2020-07-17 | Richmond | North Carolina | 37153 | 391 | 7 |
342975 | 342975 | 2020-07-17 | Robeson | North Carolina | 37155 | 1863 | 46 |
342976 | 342976 | 2020-07-17 | Rockingham | North Carolina | 37157 | 336 | 2 |
342977 | 342977 | 2020-07-17 | Rowan | North Carolina | 37159 | 1663 | 45 |
342978 | 342978 | 2020-07-17 | Rutherford | North Carolina | 37161 | 455 | 12 |
342979 | 342979 | 2020-07-17 | Sampson | North Carolina | 37163 | 1283 | 8 |
342980 | 342980 | 2020-07-17 | Scotland | North Carolina | 37165 | 183 | 2 |
342981 | 342981 | 2020-07-17 | Stanly | North Carolina | 37167 | 621 | 5 |
342982 | 342982 | 2020-07-17 | Stokes | North Carolina | 37169 | 184 | 1 |
342983 | 342983 | 2020-07-17 | Surry | North Carolina | 37171 | 642 | 3 |
342984 | 342984 | 2020-07-17 | Swain | North Carolina | 37173 | 77 | 1 |
342985 | 342985 | 2020-07-17 | Transylvania | North Carolina | 37175 | 68 | 1 |
342986 | 342986 | 2020-07-17 | Tyrrell | North Carolina | 37177 | 63 | 1 |
342987 | 342987 | 2020-07-17 | Union | North Carolina | 37179 | 2091 | 30 |
342988 | 342988 | 2020-07-17 | Vance | North Carolina | 37181 | 604 | 40 |
342989 | 342989 | 2020-07-17 | Wake | North Carolina | 37183 | 8421 | 89 |
342990 | 342990 | 2020-07-17 | Warren | North Carolina | 37185 | 204 | 6 |
342991 | 342991 | 2020-07-17 | Washington | North Carolina | 37187 | 60 | 3 |
342992 | 342992 | 2020-07-17 | Watauga | North Carolina | 37189 | 163 | 0 |
342993 | 342993 | 2020-07-17 | Wayne | North Carolina | 37191 | 2071 | 34 |
342994 | 342994 | 2020-07-17 | Wilkes | North Carolina | 37193 | 651 | 7 |
342995 | 342995 | 2020-07-17 | Wilson | North Carolina | 37195 | 1075 | 28 |
342996 | 342996 | 2020-07-17 | Yadkin | North Carolina | 37197 | 398 | 5 |
342997 | 342997 | 2020-07-17 | Yancey | North Carolina | 37199 | 65 | 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);