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-12-18 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 |
---|---|---|---|---|---|---|---|
841210 | 841210 | 2020-12-18 | Alamance | North Carolina | 37001 | 9082 | 114 |
841211 | 841211 | 2020-12-18 | Alexander | North Carolina | 37003 | 2174 | 22 |
841212 | 841212 | 2020-12-18 | Alleghany | North Carolina | 37005 | 529 | 2 |
841213 | 841213 | 2020-12-18 | Anson | North Carolina | 37007 | 1226 | 19 |
841214 | 841214 | 2020-12-18 | Ashe | North Carolina | 37009 | 1060 | 17 |
841215 | 841215 | 2020-12-18 | Avery | North Carolina | 37011 | 1236 | 15 |
841216 | 841216 | 2020-12-18 | Beaufort | North Carolina | 37013 | 2138 | 58 |
841217 | 841217 | 2020-12-18 | Bertie | North Carolina | 37015 | 1096 | 27 |
841218 | 841218 | 2020-12-18 | Bladen | North Carolina | 37017 | 1630 | 23 |
841219 | 841219 | 2020-12-18 | Brunswick | North Carolina | 37019 | 3802 | 70 |
841220 | 841220 | 2020-12-18 | Buncombe | North Carolina | 37021 | 7520 | 149 |
841221 | 841221 | 2020-12-18 | Burke | North Carolina | 37023 | 5356 | 73 |
841222 | 841222 | 2020-12-18 | Cabarrus | North Carolina | 37025 | 9371 | 120 |
841223 | 841223 | 2020-12-18 | Caldwell | North Carolina | 37027 | 4815 | 27 |
841224 | 841224 | 2020-12-18 | Camden | North Carolina | 37029 | 245 | 4 |
841225 | 841225 | 2020-12-18 | Carteret | North Carolina | 37031 | 2354 | 16 |
841226 | 841226 | 2020-12-18 | Caswell | North Carolina | 37033 | 1005 | 8 |
841227 | 841227 | 2020-12-18 | Catawba | North Carolina | 37035 | 9466 | 126 |
841228 | 841228 | 2020-12-18 | Chatham | North Carolina | 37037 | 2671 | 65 |
841229 | 841229 | 2020-12-18 | Cherokee | North Carolina | 37039 | 1123 | 15 |
841230 | 841230 | 2020-12-18 | Chowan | North Carolina | 37041 | 748 | 19 |
841231 | 841231 | 2020-12-18 | Clay | North Carolina | 37043 | 320 | 5 |
841232 | 841232 | 2020-12-18 | Cleveland | North Carolina | 37045 | 5642 | 131 |
841233 | 841233 | 2020-12-18 | Columbus | North Carolina | 37047 | 3162 | 78 |
841234 | 841234 | 2020-12-18 | Craven | North Carolina | 37049 | 4361 | 79 |
841235 | 841235 | 2020-12-18 | Cumberland | North Carolina | 37051 | 12050 | 131 |
841236 | 841236 | 2020-12-18 | Currituck | North Carolina | 37053 | 540 | 9 |
841237 | 841237 | 2020-12-18 | Dare | North Carolina | 37055 | 831 | 4 |
841238 | 841238 | 2020-12-18 | Davidson | North Carolina | 37057 | 7182 | 67 |
841239 | 841239 | 2020-12-18 | Davie | North Carolina | 37059 | 1750 | 13 |
841240 | 841240 | 2020-12-18 | Duplin | North Carolina | 37061 | 3868 | 65 |
841241 | 841241 | 2020-12-18 | Durham | North Carolina | 37063 | 13692 | 133 |
841242 | 841242 | 2020-12-18 | Edgecombe | North Carolina | 37065 | 2985 | 78 |
841243 | 841243 | 2020-12-18 | Forsyth | North Carolina | 37067 | 17734 | 197 |
841244 | 841244 | 2020-12-18 | Franklin | North Carolina | 37069 | 2642 | 37 |
841245 | 841245 | 2020-12-18 | Gaston | North Carolina | 37071 | 13237 | 204 |
841246 | 841246 | 2020-12-18 | Gates | North Carolina | 37073 | 308 | 11 |
841247 | 841247 | 2020-12-18 | Graham | North Carolina | 37075 | 326 | 11 |
841248 | 841248 | 2020-12-18 | Granville | North Carolina | 37077 | 3224 | 60 |
841249 | 841249 | 2020-12-18 | Greene | North Carolina | 37079 | 1417 | 28 |
841250 | 841250 | 2020-12-18 | Guilford | North Carolina | 37081 | 21420 | 291 |
841251 | 841251 | 2020-12-18 | Halifax | North Carolina | 37083 | 2474 | 44 |
841252 | 841252 | 2020-12-18 | Harnett | North Carolina | 37085 | 5213 | 89 |
841253 | 841253 | 2020-12-18 | Haywood | North Carolina | 37087 | 1741 | 55 |
841254 | 841254 | 2020-12-18 | Henderson | North Carolina | 37089 | 4287 | 91 |
841255 | 841255 | 2020-12-18 | Hertford | North Carolina | 37091 | 1204 | 44 |
841256 | 841256 | 2020-12-18 | Hoke | North Carolina | 37093 | 2447 | 34 |
841257 | 841257 | 2020-12-18 | Hyde | North Carolina | 37095 | 228 | 5 |
841258 | 841258 | 2020-12-18 | Iredell | North Carolina | 37097 | 7845 | 61 |
841259 | 841259 | 2020-12-18 | Jackson | North Carolina | 37099 | 1923 | 13 |
841260 | 841260 | 2020-12-18 | Johnston | North Carolina | 37101 | 10237 | 95 |
841261 | 841261 | 2020-12-18 | Jones | North Carolina | 37103 | 348 | 15 |
841262 | 841262 | 2020-12-18 | Lee | North Carolina | 37105 | 3035 | 38 |
841263 | 841263 | 2020-12-18 | Lenoir | North Carolina | 37107 | 2844 | 62 |
841264 | 841264 | 2020-12-18 | Lincoln | North Carolina | 37109 | 4571 | 20 |
841265 | 841265 | 2020-12-18 | Macon | North Carolina | 37113 | 1151 | 9 |
841266 | 841266 | 2020-12-18 | Madison | North Carolina | 37115 | 707 | 18 |
841267 | 841267 | 2020-12-18 | Martin | North Carolina | 37117 | 1139 | 23 |
841268 | 841268 | 2020-12-18 | McDowell | North Carolina | 37111 | 2624 | 38 |
841269 | 841269 | 2020-12-18 | Mecklenburg | North Carolina | 37119 | 54667 | 513 |
841270 | 841270 | 2020-12-18 | Mitchell | North Carolina | 37121 | 786 | 7 |
841271 | 841271 | 2020-12-18 | Montgomery | North Carolina | 37123 | 1708 | 44 |
841272 | 841272 | 2020-12-18 | Moore | North Carolina | 37125 | 4116 | 73 |
841273 | 841273 | 2020-12-18 | Nash | North Carolina | 37127 | 5415 | 116 |
841274 | 841274 | 2020-12-18 | New Hanover | North Carolina | 37129 | 8570 | 69 |
841275 | 841275 | 2020-12-18 | Northampton | North Carolina | 37131 | 950 | 27 |
841276 | 841276 | 2020-12-18 | Onslow | North Carolina | 37133 | 7518 | 55 |
841277 | 841277 | 2020-12-18 | Orange | North Carolina | 37135 | 4593 | 62 |
841278 | 841278 | 2020-12-18 | Pamlico | North Carolina | 37137 | 488 | 5 |
841279 | 841279 | 2020-12-18 | Pasquotank | North Carolina | 37139 | 1457 | 38 |
841280 | 841280 | 2020-12-18 | Pender | North Carolina | 37141 | 2402 | 21 |
841281 | 841281 | 2020-12-18 | Perquimans | North Carolina | 37143 | 435 | 4 |
841282 | 841282 | 2020-12-18 | Person | North Carolina | 37145 | 1356 | 20 |
841283 | 841283 | 2020-12-18 | Pitt | North Carolina | 37147 | 10001 | 64 |
841284 | 841284 | 2020-12-18 | Polk | North Carolina | 37149 | 589 | 13 |
841285 | 841285 | 2020-12-18 | Randolph | North Carolina | 37151 | 6995 | 107 |
841286 | 841286 | 2020-12-18 | Richmond | North Carolina | 37153 | 2373 | 44 |
841287 | 841287 | 2020-12-18 | Robeson | North Carolina | 37155 | 8645 | 115 |
841288 | 841288 | 2020-12-18 | Rockingham | North Carolina | 37157 | 3923 | 23 |
841289 | 841289 | 2020-12-18 | Rowan | North Carolina | 37159 | 7593 | 155 |
841290 | 841290 | 2020-12-18 | Rutherford | North Carolina | 37161 | 3534 | 101 |
841291 | 841291 | 2020-12-18 | Sampson | North Carolina | 37163 | 4396 | 57 |
841292 | 841292 | 2020-12-18 | Scotland | North Carolina | 37165 | 2331 | 50 |
841293 | 841293 | 2020-12-18 | Stanly | North Carolina | 37167 | 3738 | 78 |
841294 | 841294 | 2020-12-18 | Stokes | North Carolina | 37169 | 1643 | 23 |
841295 | 841295 | 2020-12-18 | Surry | North Carolina | 37171 | 3723 | 53 |
841296 | 841296 | 2020-12-18 | Swain | North Carolina | 37173 | 538 | 6 |
841297 | 841297 | 2020-12-18 | Transylvania | North Carolina | 37175 | 745 | 10 |
841298 | 841298 | 2020-12-18 | Tyrrell | North Carolina | 37177 | 161 | 3 |
841299 | 841299 | 2020-12-18 | Union | North Carolina | 37179 | 10401 | 88 |
841300 | 841300 | 2020-12-18 | Vance | North Carolina | 37181 | 2338 | 64 |
841301 | 841301 | 2020-12-18 | Wake | North Carolina | 37183 | 38860 | 333 |
841302 | 841302 | 2020-12-18 | Warren | North Carolina | 37185 | 994 | 9 |
841303 | 841303 | 2020-12-18 | Washington | North Carolina | 37187 | 379 | 10 |
841304 | 841304 | 2020-12-18 | Watauga | North Carolina | 37189 | 2377 | 14 |
841305 | 841305 | 2020-12-18 | Wayne | North Carolina | 37191 | 6814 | 131 |
841306 | 841306 | 2020-12-18 | Wilkes | North Carolina | 37193 | 3368 | 66 |
841307 | 841307 | 2020-12-18 | Wilson | North Carolina | 37195 | 4938 | 94 |
841308 | 841308 | 2020-12-18 | Yadkin | North Carolina | 37197 | 2087 | 24 |
841309 | 841309 | 2020-12-18 | Yancey | North Carolina | 37199 | 894 | 8 |
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);