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 2021-11-30 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 |
---|---|---|---|---|---|---|---|
1968009 | 1968009 | 2021-11-30 | Alamance | North Carolina | 37001 | 27430 | 349 |
1968010 | 1968010 | 2021-11-30 | Alexander | North Carolina | 37003 | 6802 | 118 |
1968011 | 1968011 | 2021-11-30 | Alleghany | North Carolina | 37005 | 1807 | 6 |
1968012 | 1968012 | 2021-11-30 | Anson | North Carolina | 37007 | 4029 | 83 |
1968013 | 1968013 | 2021-11-30 | Ashe | North Carolina | 37009 | 3614 | 54 |
1968014 | 1968014 | 2021-11-30 | Avery | North Carolina | 37011 | 2863 | 39 |
1968015 | 1968015 | 2021-11-30 | Beaufort | North Carolina | 37013 | 7458 | 132 |
1968016 | 1968016 | 2021-11-30 | Bertie | North Carolina | 37015 | 2547 | 53 |
1968017 | 1968017 | 2021-11-30 | Bladen | North Carolina | 37017 | 5610 | 95 |
1968018 | 1968018 | 2021-11-30 | Brunswick | North Carolina | 37019 | 16884 | 245 |
1968019 | 1968019 | 2021-11-30 | Buncombe | North Carolina | 37021 | 29832 | 447 |
1968020 | 1968020 | 2021-11-30 | Burke | North Carolina | 37023 | 16192 | 246 |
1968021 | 1968021 | 2021-11-30 | Cabarrus | North Carolina | 37025 | 34308 | 347 |
1968022 | 1968022 | 2021-11-30 | Caldwell | North Carolina | 37027 | 13949 | 227 |
1968023 | 1968023 | 2021-11-30 | Camden | North Carolina | 37029 | 1226 | 8 |
1968024 | 1968024 | 2021-11-30 | Carteret | North Carolina | 37031 | 8736 | 83 |
1968025 | 1968025 | 2021-11-30 | Caswell | North Carolina | 37033 | 3306 | 38 |
1968026 | 1968026 | 2021-11-30 | Catawba | North Carolina | 37035 | 29343 | 441 |
1968027 | 1968027 | 2021-11-30 | Chatham | North Carolina | 37037 | 7015 | 98 |
1968028 | 1968028 | 2021-11-30 | Cherokee | North Carolina | 37039 | 4750 | 78 |
1968029 | 1968029 | 2021-11-30 | Chowan | North Carolina | 37041 | 2370 | 43 |
1968030 | 1968030 | 2021-11-30 | Clay | North Carolina | 37043 | 1700 | 38 |
1968031 | 1968031 | 2021-11-30 | Cleveland | North Carolina | 37045 | 18943 | 316 |
1968032 | 1968032 | 2021-11-30 | Columbus | North Carolina | 37047 | 10302 | 230 |
1968033 | 1968033 | 2021-11-30 | Craven | North Carolina | 37049 | 14591 | 160 |
1968034 | 1968034 | 2021-11-30 | Cumberland | North Carolina | 37051 | 47642 | 498 |
1968035 | 1968035 | 2021-11-30 | Currituck | North Carolina | 37053 | 3017 | 27 |
1968036 | 1968036 | 2021-11-30 | Dare | North Carolina | 37055 | 4125 | 15 |
1968037 | 1968037 | 2021-11-30 | Davidson | North Carolina | 37057 | 26873 | 316 |
1968038 | 1968038 | 2021-11-30 | Davie | North Carolina | 37059 | 6751 | 81 |
1968039 | 1968039 | 2021-11-30 | Duplin | North Carolina | 37061 | 10170 | 196 |
1968040 | 1968040 | 2021-11-30 | Durham | North Carolina | 37063 | 36166 | 265 |
1968041 | 1968041 | 2021-11-30 | Edgecombe | North Carolina | 37065 | 8150 | 127 |
1968042 | 1968042 | 2021-11-30 | Forsyth | North Carolina | 37067 | 54096 | 582 |
1968043 | 1968043 | 2021-11-30 | Franklin | North Carolina | 37069 | 10317 | 64 |
1968044 | 1968044 | 2021-11-30 | Gaston | North Carolina | 37071 | 41724 | 631 |
1968045 | 1968045 | 2021-11-30 | Gates | North Carolina | 37073 | 1137 | 18 |
1968046 | 1968046 | 2021-11-30 | Graham | North Carolina | 37075 | 1360 | 28 |
1968047 | 1968047 | 2021-11-30 | Granville | North Carolina | 37077 | 8274 | 105 |
1968048 | 1968048 | 2021-11-30 | Greene | North Carolina | 37079 | 3388 | 56 |
1968049 | 1968049 | 2021-11-30 | Guilford | North Carolina | 37081 | 70574 | 923 |
1968050 | 1968050 | 2021-11-30 | Halifax | North Carolina | 37083 | 8057 | 144 |
1968051 | 1968051 | 2021-11-30 | Harnett | North Carolina | 37085 | 19053 | 269 |
1968052 | 1968052 | 2021-11-30 | Haywood | North Carolina | 37087 | 7850 | 153 |
1968053 | 1968053 | 2021-11-30 | Henderson | North Carolina | 37089 | 16019 | 218 |
1968054 | 1968054 | 2021-11-30 | Hertford | North Carolina | 37091 | 2901 | 72 |
1968055 | 1968055 | 2021-11-30 | Hoke | North Carolina | 37093 | 7457 | 86 |
1968056 | 1968056 | 2021-11-30 | Hyde | North Carolina | 37095 | 857 | 12 |
1968057 | 1968057 | 2021-11-30 | Iredell | North Carolina | 37097 | 30291 | 332 |
1968058 | 1968058 | 2021-11-30 | Jackson | North Carolina | 37099 | 5911 | 72 |
1968059 | 1968059 | 2021-11-30 | Johnston | North Carolina | 37101 | 33625 | 339 |
1968060 | 1968060 | 2021-11-30 | Jones | North Carolina | 37103 | 1387 | 35 |
1968061 | 1968061 | 2021-11-30 | Lee | North Carolina | 37105 | 9626 | 110 |
1968062 | 1968062 | 2021-11-30 | Lenoir | North Carolina | 37107 | 9693 | 179 |
1968063 | 1968063 | 2021-11-30 | Lincoln | North Carolina | 37109 | 15796 | 118 |
1968064 | 1968064 | 2021-11-30 | Macon | North Carolina | 37113 | 5121 | 80 |
1968065 | 1968065 | 2021-11-30 | Madison | North Carolina | 37115 | 2926 | 66 |
1968066 | 1968066 | 2021-11-30 | Martin | North Carolina | 37117 | 3759 | 75 |
1968067 | 1968067 | 2021-11-30 | McDowell | North Carolina | 37111 | 8851 | 136 |
1968068 | 1968068 | 2021-11-30 | Mecklenburg | North Carolina | 37119 | 162575 | 1279 |
1968069 | 1968069 | 2021-11-30 | Mitchell | North Carolina | 37121 | 2163 | 22 |
1968070 | 1968070 | 2021-11-30 | Montgomery | North Carolina | 37123 | 4679 | 110 |
1968071 | 1968071 | 2021-11-30 | Moore | North Carolina | 37125 | 14004 | 252 |
1968072 | 1968072 | 2021-11-30 | Nash | North Carolina | 37127 | 15610 | 237 |
1968073 | 1968073 | 2021-11-30 | New Hanover | North Carolina | 37129 | 29359 | 296 |
1968074 | 1968074 | 2021-11-30 | Northampton | North Carolina | 37131 | 2631 | 66 |
1968075 | 1968075 | 2021-11-30 | Onslow | North Carolina | 37133 | 30508 | 273 |
1968076 | 1968076 | 2021-11-30 | Orange | North Carolina | 37135 | 12247 | 110 |
1968077 | 1968077 | 2021-11-30 | Pamlico | North Carolina | 37137 | 1759 | 26 |
1968078 | 1968078 | 2021-11-30 | Pasquotank | North Carolina | 37139 | 5523 | 108 |
1968079 | 1968079 | 2021-11-30 | Pender | North Carolina | 37141 | 9178 | 102 |
1968080 | 1968080 | 2021-11-30 | Perquimans | North Carolina | 37143 | 1689 | 15 |
1968081 | 1968081 | 2021-11-30 | Person | North Carolina | 37145 | 5343 | 89 |
1968082 | 1968082 | 2021-11-30 | Pitt | North Carolina | 37147 | 30407 | 146 |
1968083 | 1968083 | 2021-11-30 | Polk | North Carolina | 37149 | 2432 | 49 |
1968084 | 1968084 | 2021-11-30 | Randolph | North Carolina | 37151 | 22656 | 329 |
1968085 | 1968085 | 2021-11-30 | Richmond | North Carolina | 37153 | 7329 | 148 |
1968086 | 1968086 | 2021-11-30 | Robeson | North Carolina | 37155 | 25460 | 440 |
1968087 | 1968087 | 2021-11-30 | Rockingham | North Carolina | 37157 | 13042 | 217 |
1968088 | 1968088 | 2021-11-30 | Rowan | North Carolina | 37159 | 27069 | 479 |
1968089 | 1968089 | 2021-11-30 | Rutherford | North Carolina | 37161 | 11768 | 338 |
1968090 | 1968090 | 2021-11-30 | Sampson | North Carolina | 37163 | 11566 | 140 |
1968091 | 1968091 | 2021-11-30 | Scotland | North Carolina | 37165 | 5862 | 109 |
1968092 | 1968092 | 2021-11-30 | Stanly | North Carolina | 37167 | 12176 | 198 |
1968093 | 1968093 | 2021-11-30 | Stokes | North Carolina | 37169 | 6681 | 117 |
1968094 | 1968094 | 2021-11-30 | Surry | North Carolina | 37171 | 13136 | 237 |
1968095 | 1968095 | 2021-11-30 | Swain | North Carolina | 37173 | 2071 | 28 |
1968096 | 1968096 | 2021-11-30 | Transylvania | North Carolina | 37175 | 3999 | 51 |
1968097 | 1968097 | 2021-11-30 | Tyrrell | North Carolina | 37177 | 580 | 7 |
1968098 | 1968098 | 2021-11-30 | Union | North Carolina | 37179 | 38106 | 363 |
1968099 | 1968099 | 2021-11-30 | Vance | North Carolina | 37181 | 7079 | 104 |
1968100 | 1968100 | 2021-11-30 | Wake | North Carolina | 37183 | 136515 | 915 |
1968101 | 1968101 | 2021-11-30 | Warren | North Carolina | 37185 | 2464 | 33 |
1968102 | 1968102 | 2021-11-30 | Washington | North Carolina | 37187 | 1642 | 37 |
1968103 | 1968103 | 2021-11-30 | Watauga | North Carolina | 37189 | 6909 | 40 |
1968104 | 1968104 | 2021-11-30 | Wayne | North Carolina | 37191 | 17577 | 309 |
1968105 | 1968105 | 2021-11-30 | Wilkes | North Carolina | 37193 | 11099 | 188 |
1968106 | 1968106 | 2021-11-30 | Wilson | North Carolina | 37195 | 13571 | 240 |
1968107 | 1968107 | 2021-11-30 | Yadkin | North Carolina | 37197 | 6345 | 76 |
1968108 | 1968108 | 2021-11-30 | Yancey | North Carolina | 37199 | 3024 | 35 |
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);