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-09 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 |
---|---|---|---|---|---|---|---|
516903 | 516903 | 2020-09-09 | Alamance | North Carolina | 37001 | 3431 | 47 |
516904 | 516904 | 2020-09-09 | Alexander | North Carolina | 37003 | 457 | 3 |
516905 | 516905 | 2020-09-09 | Alleghany | North Carolina | 37005 | 211 | 0 |
516906 | 516906 | 2020-09-09 | Anson | North Carolina | 37007 | 487 | 3 |
516907 | 516907 | 2020-09-09 | Ashe | North Carolina | 37009 | 231 | 1 |
516908 | 516908 | 2020-09-09 | Avery | North Carolina | 37011 | 226 | 0 |
516909 | 516909 | 2020-09-09 | Beaufort | North Carolina | 37013 | 689 | 10 |
516910 | 516910 | 2020-09-09 | Bertie | North Carolina | 37015 | 498 | 7 |
516911 | 516911 | 2020-09-09 | Bladen | North Carolina | 37017 | 770 | 10 |
516912 | 516912 | 2020-09-09 | Brunswick | North Carolina | 37019 | 1445 | 26 |
516913 | 516913 | 2020-09-09 | Buncombe | North Carolina | 37021 | 2667 | 82 |
516914 | 516914 | 2020-09-09 | Burke | North Carolina | 37023 | 1931 | 32 |
516915 | 516915 | 2020-09-09 | Cabarrus | North Carolina | 37025 | 3467 | 56 |
516916 | 516916 | 2020-09-09 | Caldwell | North Carolina | 37027 | 1487 | 17 |
516917 | 516917 | 2020-09-09 | Camden | North Carolina | 37029 | 101 | 3 |
516918 | 516918 | 2020-09-09 | Carteret | North Carolina | 37031 | 559 | 5 |
516919 | 516919 | 2020-09-09 | Caswell | North Carolina | 37033 | 259 | 3 |
516920 | 516920 | 2020-09-09 | Catawba | North Carolina | 37035 | 2750 | 47 |
516921 | 516921 | 2020-09-09 | Chatham | North Carolina | 37037 | 1549 | 56 |
516922 | 516922 | 2020-09-09 | Cherokee | North Carolina | 37039 | 496 | 6 |
516923 | 516923 | 2020-09-09 | Chowan | North Carolina | 37041 | 257 | 3 |
516924 | 516924 | 2020-09-09 | Clay | North Carolina | 37043 | 99 | 1 |
516925 | 516925 | 2020-09-09 | Cleveland | North Carolina | 37045 | 1743 | 50 |
516926 | 516926 | 2020-09-09 | Columbus | North Carolina | 37047 | 1207 | 52 |
516927 | 516927 | 2020-09-09 | Craven | North Carolina | 37049 | 1081 | 27 |
516928 | 516928 | 2020-09-09 | Cumberland | North Carolina | 37051 | 4532 | 71 |
516929 | 516929 | 2020-09-09 | Currituck | North Carolina | 37053 | 123 | 0 |
516930 | 516930 | 2020-09-09 | Dare | North Carolina | 37055 | 255 | 2 |
516931 | 516931 | 2020-09-09 | Davidson | North Carolina | 37057 | 2341 | 32 |
516932 | 516932 | 2020-09-09 | Davie | North Carolina | 37059 | 501 | 6 |
516933 | 516933 | 2020-09-09 | Duplin | North Carolina | 37061 | 2099 | 52 |
516934 | 516934 | 2020-09-09 | Durham | North Carolina | 37063 | 7194 | 86 |
516935 | 516935 | 2020-09-09 | Edgecombe | North Carolina | 37065 | 1097 | 23 |
516936 | 516936 | 2020-09-09 | Forsyth | North Carolina | 37067 | 6481 | 84 |
516937 | 516937 | 2020-09-09 | Franklin | North Carolina | 37069 | 1123 | 30 |
516938 | 516938 | 2020-09-09 | Gaston | North Carolina | 37071 | 4388 | 67 |
516939 | 516939 | 2020-09-09 | Gates | North Carolina | 37073 | 101 | 3 |
516940 | 516940 | 2020-09-09 | Graham | North Carolina | 37075 | 84 | 0 |
516941 | 516941 | 2020-09-09 | Granville | North Carolina | 37077 | 1605 | 47 |
516942 | 516942 | 2020-09-09 | Greene | North Carolina | 37079 | 458 | 5 |
516943 | 516943 | 2020-09-09 | Guilford | North Carolina | 37081 | 7409 | 174 |
516944 | 516944 | 2020-09-09 | Halifax | North Carolina | 37083 | 916 | 17 |
516945 | 516945 | 2020-09-09 | Harnett | North Carolina | 37085 | 1792 | 46 |
516946 | 516946 | 2020-09-09 | Haywood | North Carolina | 37087 | 534 | 31 |
516947 | 516947 | 2020-09-09 | Henderson | North Carolina | 37089 | 1770 | 60 |
516948 | 516948 | 2020-09-09 | Hertford | North Carolina | 37091 | 612 | 23 |
516949 | 516949 | 2020-09-09 | Hoke | North Carolina | 37093 | 926 | 13 |
516950 | 516950 | 2020-09-09 | Hyde | North Carolina | 37095 | 113 | 3 |
516951 | 516951 | 2020-09-09 | Iredell | North Carolina | 37097 | 2510 | 24 |
516952 | 516952 | 2020-09-09 | Jackson | North Carolina | 37099 | 514 | 7 |
516953 | 516953 | 2020-09-09 | Johnston | North Carolina | 37101 | 4120 | 54 |
516954 | 516954 | 2020-09-09 | Jones | North Carolina | 37103 | 138 | 7 |
516955 | 516955 | 2020-09-09 | Lee | North Carolina | 37105 | 1493 | 13 |
516956 | 516956 | 2020-09-09 | Lenoir | North Carolina | 37107 | 863 | 21 |
516957 | 516957 | 2020-09-09 | Lincoln | North Carolina | 37109 | 1261 | 13 |
516958 | 516958 | 2020-09-09 | Macon | North Carolina | 37113 | 553 | 2 |
516959 | 516959 | 2020-09-09 | Madison | North Carolina | 37115 | 77 | 1 |
516960 | 516960 | 2020-09-09 | Martin | North Carolina | 37117 | 380 | 7 |
516961 | 516961 | 2020-09-09 | McDowell | North Carolina | 37111 | 840 | 24 |
516962 | 516962 | 2020-09-09 | Mecklenburg | North Carolina | 37119 | 26666 | 332 |
516963 | 516963 | 2020-09-09 | Mitchell | North Carolina | 37121 | 94 | 3 |
516964 | 516964 | 2020-09-09 | Montgomery | North Carolina | 37123 | 961 | 19 |
516965 | 516965 | 2020-09-09 | Moore | North Carolina | 37125 | 1407 | 22 |
516966 | 516966 | 2020-09-09 | Nash | North Carolina | 37127 | 1862 | 28 |
516967 | 516967 | 2020-09-09 | New Hanover | North Carolina | 37129 | 3488 | 24 |
516968 | 516968 | 2020-09-09 | Northampton | North Carolina | 37131 | 357 | 17 |
516969 | 516969 | 2020-09-09 | Onslow | North Carolina | 37133 | 1654 | 17 |
516970 | 516970 | 2020-09-09 | Orange | North Carolina | 37135 | 2443 | 51 |
516971 | 516971 | 2020-09-09 | Pamlico | North Carolina | 37137 | 210 | 2 |
516972 | 516972 | 2020-09-09 | Pasquotank | North Carolina | 37139 | 606 | 26 |
516973 | 516973 | 2020-09-09 | Pender | North Carolina | 37141 | 801 | 5 |
516974 | 516974 | 2020-09-09 | Perquimans | North Carolina | 37143 | 152 | 2 |
516975 | 516975 | 2020-09-09 | Person | North Carolina | 37145 | 360 | 6 |
516976 | 516976 | 2020-09-09 | Pitt | North Carolina | 37147 | 4103 | 24 |
516977 | 516977 | 2020-09-09 | Polk | North Carolina | 37149 | 248 | 7 |
516978 | 516978 | 2020-09-09 | Randolph | North Carolina | 37151 | 2523 | 46 |
516979 | 516979 | 2020-09-09 | Richmond | North Carolina | 37153 | 749 | 11 |
516980 | 516980 | 2020-09-09 | Robeson | North Carolina | 37155 | 3887 | 63 |
516981 | 516981 | 2020-09-09 | Rockingham | North Carolina | 37157 | 1002 | 10 |
516982 | 516982 | 2020-09-09 | Rowan | North Carolina | 37159 | 2982 | 81 |
516983 | 516983 | 2020-09-09 | Rutherford | North Carolina | 37161 | 1026 | 24 |
516984 | 516984 | 2020-09-09 | Sampson | North Carolina | 37163 | 1681 | 22 |
516985 | 516985 | 2020-09-09 | Scotland | North Carolina | 37165 | 751 | 10 |
516986 | 516986 | 2020-09-09 | Stanly | North Carolina | 37167 | 1637 | 52 |
516987 | 516987 | 2020-09-09 | Stokes | North Carolina | 37169 | 369 | 3 |
516988 | 516988 | 2020-09-09 | Surry | North Carolina | 37171 | 1217 | 19 |
516989 | 516989 | 2020-09-09 | Swain | North Carolina | 37173 | 136 | 3 |
516990 | 516990 | 2020-09-09 | Transylvania | North Carolina | 37175 | 282 | 7 |
516991 | 516991 | 2020-09-09 | Tyrrell | North Carolina | 37177 | 108 | 2 |
516992 | 516992 | 2020-09-09 | Union | North Carolina | 37179 | 4298 | 55 |
516993 | 516993 | 2020-09-09 | Vance | North Carolina | 37181 | 957 | 42 |
516994 | 516994 | 2020-09-09 | Wake | North Carolina | 37183 | 16075 | 213 |
516995 | 516995 | 2020-09-09 | Warren | North Carolina | 37185 | 298 | 7 |
516996 | 516996 | 2020-09-09 | Washington | North Carolina | 37187 | 190 | 6 |
516997 | 516997 | 2020-09-09 | Watauga | North Carolina | 37189 | 505 | 0 |
516998 | 516998 | 2020-09-09 | Wayne | North Carolina | 37191 | 2946 | 60 |
516999 | 516999 | 2020-09-09 | Wilkes | North Carolina | 37193 | 1085 | 27 |
517000 | 517000 | 2020-09-09 | Wilson | North Carolina | 37195 | 1870 | 40 |
517001 | 517001 | 2020-09-09 | Yadkin | North Carolina | 37197 | 666 | 7 |
517002 | 517002 | 2020-09-09 | Yancey | North Carolina | 37199 | 108 | 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);