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 2022-02-21 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 |
---|---|---|---|---|---|---|---|
2237893 | 2237893 | 2022-02-21 | Alamance | North Carolina | 37001 | 45799 | 441 |
2237894 | 2237894 | 2022-02-21 | Alexander | North Carolina | 37003 | 10354 | 127 |
2237895 | 2237895 | 2022-02-21 | Alleghany | North Carolina | 37005 | 2876 | 11 |
2237896 | 2237896 | 2022-02-21 | Anson | North Carolina | 37007 | 6441 | 93 |
2237897 | 2237897 | 2022-02-21 | Ashe | North Carolina | 37009 | 6088 | 68 |
2237898 | 2237898 | 2022-02-21 | Avery | North Carolina | 37011 | 4315 | 41 |
2237899 | 2237899 | 2022-02-21 | Beaufort | North Carolina | 37013 | 11902 | 149 |
2237900 | 2237900 | 2022-02-21 | Bertie | North Carolina | 37015 | 4181 | 65 |
2237901 | 2237901 | 2022-02-21 | Bladen | North Carolina | 37017 | 9179 | 118 |
2237902 | 2237902 | 2022-02-21 | Brunswick | North Carolina | 37019 | 28538 | 294 |
2237903 | 2237903 | 2022-02-21 | Buncombe | North Carolina | 37021 | 49595 | 540 |
2237904 | 2237904 | 2022-02-21 | Burke | North Carolina | 37023 | 24316 | 289 |
2237905 | 2237905 | 2022-02-21 | Cabarrus | North Carolina | 37025 | 54705 | 451 |
2237906 | 2237906 | 2022-02-21 | Caldwell | North Carolina | 37027 | 21654 | 280 |
2237907 | 2237907 | 2022-02-21 | Camden | North Carolina | 37029 | 1656 | 9 |
2237908 | 2237908 | 2022-02-21 | Carteret | North Carolina | 37031 | 13309 | 84 |
2237909 | 2237909 | 2022-02-21 | Caswell | North Carolina | 37033 | 5129 | 43 |
2237910 | 2237910 | 2022-02-21 | Catawba | North Carolina | 37035 | 46907 | 539 |
2237911 | 2237911 | 2022-02-21 | Chatham | North Carolina | 37037 | 12368 | 106 |
2237912 | 2237912 | 2022-02-21 | Cherokee | North Carolina | 37039 | 6980 | 97 |
2237913 | 2237913 | 2022-02-21 | Chowan | North Carolina | 37041 | 4087 | 52 |
2237914 | 2237914 | 2022-02-21 | Clay | North Carolina | 37043 | 2594 | 38 |
2237915 | 2237915 | 2022-02-21 | Cleveland | North Carolina | 37045 | 29248 | 357 |
2237916 | 2237916 | 2022-02-21 | Columbus | North Carolina | 37047 | 15654 | 262 |
2237917 | 2237917 | 2022-02-21 | Craven | North Carolina | 37049 | 23376 | 191 |
2237918 | 2237918 | 2022-02-21 | Cumberland | North Carolina | 37051 | 81094 | 548 |
2237919 | 2237919 | 2022-02-21 | Currituck | North Carolina | 37053 | 4713 | 32 |
2237920 | 2237920 | 2022-02-21 | Dare | North Carolina | 37055 | 7237 | 22 |
2237921 | 2237921 | 2022-02-21 | Davidson | North Carolina | 37057 | 42421 | 384 |
2237922 | 2237922 | 2022-02-21 | Davie | North Carolina | 37059 | 10938 | 89 |
2237923 | 2237923 | 2022-02-21 | Duplin | North Carolina | 37061 | 16450 | 226 |
2237924 | 2237924 | 2022-02-21 | Durham | North Carolina | 37063 | 69850 | 298 |
2237925 | 2237925 | 2022-02-21 | Edgecombe | North Carolina | 37065 | 13249 | 137 |
2237926 | 2237926 | 2022-02-21 | Forsyth | North Carolina | 37067 | 90735 | 746 |
2237927 | 2237927 | 2022-02-21 | Franklin | North Carolina | 37069 | 19793 | 65 |
2237928 | 2237928 | 2022-02-21 | Gaston | North Carolina | 37071 | 64314 | 757 |
2237929 | 2237929 | 2022-02-21 | Gates | North Carolina | 37073 | 1782 | 19 |
2237930 | 2237930 | 2022-02-21 | Graham | North Carolina | 37075 | 2237 | 30 |
2237931 | 2237931 | 2022-02-21 | Granville | North Carolina | 37077 | 13940 | 111 |
2237932 | 2237932 | 2022-02-21 | Greene | North Carolina | 37079 | 5688 | 55 |
2237933 | 2237933 | 2022-02-21 | Guilford | North Carolina | 37081 | 113421 | 1071 |
2237934 | 2237934 | 2022-02-21 | Halifax | North Carolina | 37083 | 13761 | 173 |
2237935 | 2237935 | 2022-02-21 | Harnett | North Carolina | 37085 | 31690 | 303 |
2237936 | 2237936 | 2022-02-21 | Haywood | North Carolina | 37087 | 12587 | 188 |
2237937 | 2237937 | 2022-02-21 | Henderson | North Carolina | 37089 | 24405 | 280 |
2237938 | 2237938 | 2022-02-21 | Hertford | North Carolina | 37091 | 4632 | 81 |
2237939 | 2237939 | 2022-02-21 | Hoke | North Carolina | 37093 | 14326 | 100 |
2237940 | 2237940 | 2022-02-21 | Hyde | North Carolina | 37095 | 1287 | 13 |
2237941 | 2237941 | 2022-02-21 | Iredell | North Carolina | 37097 | 47457 | 420 |
2237942 | 2237942 | 2022-02-21 | Jackson | North Carolina | 37099 | 9066 | 83 |
2237943 | 2237943 | 2022-02-21 | Johnston | North Carolina | 37101 | 57553 | 415 |
2237944 | 2237944 | 2022-02-21 | Jones | North Carolina | 37103 | 2168 | 38 |
2237945 | 2237945 | 2022-02-21 | Lee | North Carolina | 37105 | 15714 | 132 |
2237946 | 2237946 | 2022-02-21 | Lenoir | North Carolina | 37107 | 15435 | 199 |
2237947 | 2237947 | 2022-02-21 | Lincoln | North Carolina | 37109 | 23925 | 146 |
2237948 | 2237948 | 2022-02-21 | Macon | North Carolina | 37113 | 7174 | 104 |
2237949 | 2237949 | 2022-02-21 | Madison | North Carolina | 37115 | 4927 | 78 |
2237950 | 2237950 | 2022-02-21 | Martin | North Carolina | 37117 | 5978 | 85 |
2237951 | 2237951 | 2022-02-21 | McDowell | North Carolina | 37111 | 13245 | 159 |
2237952 | 2237952 | 2022-02-21 | Mecklenburg | North Carolina | 37119 | 273308 | 1533 |
2237953 | 2237953 | 2022-02-21 | Mitchell | North Carolina | 37121 | 3218 | 33 |
2237954 | 2237954 | 2022-02-21 | Montgomery | North Carolina | 37123 | 7180 | 124 |
2237955 | 2237955 | 2022-02-21 | Moore | North Carolina | 37125 | 23747 | 307 |
2237956 | 2237956 | 2022-02-21 | Nash | North Carolina | 37127 | 26774 | 284 |
2237957 | 2237957 | 2022-02-21 | New Hanover | North Carolina | 37129 | 47828 | 351 |
2237958 | 2237958 | 2022-02-21 | Northampton | North Carolina | 37131 | 4264 | 78 |
2237959 | 2237959 | 2022-02-21 | Onslow | North Carolina | 37133 | 50271 | 354 |
2237960 | 2237960 | 2022-02-21 | Orange | North Carolina | 37135 | 25202 | 120 |
2237961 | 2237961 | 2022-02-21 | Pamlico | North Carolina | 37137 | 2564 | 27 |
2237962 | 2237962 | 2022-02-21 | Pasquotank | North Carolina | 37139 | 7996 | 111 |
2237963 | 2237963 | 2022-02-21 | Pender | North Carolina | 37141 | 14830 | 115 |
2237964 | 2237964 | 2022-02-21 | Perquimans | North Carolina | 37143 | 2642 | 17 |
2237965 | 2237965 | 2022-02-21 | Person | North Carolina | 37145 | 9041 | 104 |
2237966 | 2237966 | 2022-02-21 | Pitt | North Carolina | 37147 | 51818 | 146 |
2237967 | 2237967 | 2022-02-21 | Polk | North Carolina | 37149 | 3751 | 50 |
2237968 | 2237968 | 2022-02-21 | Randolph | North Carolina | 37151 | 34890 | 394 |
2237969 | 2237969 | 2022-02-21 | Richmond | North Carolina | 37153 | 12425 | 183 |
2237970 | 2237970 | 2022-02-21 | Robeson | North Carolina | 37155 | 39767 | 506 |
2237971 | 2237971 | 2022-02-21 | Rockingham | North Carolina | 37157 | 21503 | 254 |
2237972 | 2237972 | 2022-02-21 | Rowan | North Carolina | 37159 | 40554 | 551 |
2237973 | 2237973 | 2022-02-21 | Rutherford | North Carolina | 37161 | 17145 | 386 |
2237974 | 2237974 | 2022-02-21 | Sampson | North Carolina | 37163 | 18177 | 161 |
2237975 | 2237975 | 2022-02-21 | Scotland | North Carolina | 37165 | 9825 | 126 |
2237976 | 2237976 | 2022-02-21 | Stanly | North Carolina | 37167 | 19212 | 248 |
2237977 | 2237977 | 2022-02-21 | Stokes | North Carolina | 37169 | 10928 | 155 |
2237978 | 2237978 | 2022-02-21 | Surry | North Carolina | 37171 | 20661 | 305 |
2237979 | 2237979 | 2022-02-21 | Swain | North Carolina | 37173 | 3362 | 34 |
2237980 | 2237980 | 2022-02-21 | Transylvania | North Carolina | 37175 | 6015 | 66 |
2237981 | 2237981 | 2022-02-21 | Tyrrell | North Carolina | 37177 | 964 | 8 |
2237982 | 2237982 | 2022-02-21 | Union | North Carolina | 37179 | 60630 | 455 |
2237983 | 2237983 | 2022-02-21 | Vance | North Carolina | 37181 | 11697 | 111 |
2237984 | 2237984 | 2022-02-21 | Wake | North Carolina | 37183 | 283484 | 1009 |
2237985 | 2237985 | 2022-02-21 | Warren | North Carolina | 37185 | 4189 | 39 |
2237986 | 2237986 | 2022-02-21 | Washington | North Carolina | 37187 | 2953 | 46 |
2237987 | 2237987 | 2022-02-21 | Watauga | North Carolina | 37189 | 11958 | 53 |
2237988 | 2237988 | 2022-02-21 | Wayne | North Carolina | 37191 | 27461 | 376 |
2237989 | 2237989 | 2022-02-21 | Wilkes | North Carolina | 37193 | 17370 | 251 |
2237990 | 2237990 | 2022-02-21 | Wilson | North Carolina | 37195 | 21209 | 292 |
2237991 | 2237991 | 2022-02-21 | Yadkin | North Carolina | 37197 | 10562 | 102 |
2237992 | 2237992 | 2022-02-21 | Yancey | North Carolina | 37199 | 4735 | 50 |
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);