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-10-10 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 |
---|---|---|---|---|---|---|---|
1802274 | 1802274 | 2021-10-10 | Alamance | North Carolina | 37001 | 25524 | 323 |
1802275 | 1802275 | 2021-10-10 | Alexander | North Carolina | 37003 | 6238 | 111 |
1802276 | 1802276 | 2021-10-10 | Alleghany | North Carolina | 37005 | 1573 | 5 |
1802277 | 1802277 | 2021-10-10 | Anson | North Carolina | 37007 | 3720 | 75 |
1802278 | 1802278 | 2021-10-10 | Ashe | North Carolina | 37009 | 3328 | 46 |
1802279 | 1802279 | 2021-10-10 | Avery | North Carolina | 37011 | 2638 | 32 |
1802280 | 1802280 | 2021-10-10 | Beaufort | North Carolina | 37013 | 6786 | 124 |
1802281 | 1802281 | 2021-10-10 | Bertie | North Carolina | 37015 | 2386 | 49 |
1802282 | 1802282 | 2021-10-10 | Bladen | North Carolina | 37017 | 5358 | 93 |
1802283 | 1802283 | 2021-10-10 | Brunswick | North Carolina | 37019 | 15701 | 224 |
1802284 | 1802284 | 2021-10-10 | Buncombe | North Carolina | 37021 | 26856 | 410 |
1802285 | 1802285 | 2021-10-10 | Burke | North Carolina | 37023 | 15238 | 202 |
1802286 | 1802286 | 2021-10-10 | Cabarrus | North Carolina | 37025 | 31851 | 319 |
1802287 | 1802287 | 2021-10-10 | Caldwell | North Carolina | 37027 | 12849 | 198 |
1802288 | 1802288 | 2021-10-10 | Camden | North Carolina | 37029 | 1067 | 8 |
1802289 | 1802289 | 2021-10-10 | Carteret | North Carolina | 37031 | 8017 | 71 |
1802290 | 1802290 | 2021-10-10 | Caswell | North Carolina | 37033 | 3092 | 36 |
1802291 | 1802291 | 2021-10-10 | Catawba | North Carolina | 37035 | 27487 | 405 |
1802292 | 1802292 | 2021-10-10 | Chatham | North Carolina | 37037 | 6554 | 91 |
1802293 | 1802293 | 2021-10-10 | Cherokee | North Carolina | 37039 | 4537 | 74 |
1802294 | 1802294 | 2021-10-10 | Chowan | North Carolina | 37041 | 2209 | 40 |
1802295 | 1802295 | 2021-10-10 | Clay | North Carolina | 37043 | 1595 | 34 |
1802296 | 1802296 | 2021-10-10 | Cleveland | North Carolina | 37045 | 17709 | 295 |
1802297 | 1802297 | 2021-10-10 | Columbus | North Carolina | 37047 | 9816 | 219 |
1802298 | 1802298 | 2021-10-10 | Craven | North Carolina | 37049 | 13856 | 151 |
1802299 | 1802299 | 2021-10-10 | Cumberland | North Carolina | 37051 | 43333 | 447 |
1802300 | 1802300 | 2021-10-10 | Currituck | North Carolina | 37053 | 2596 | 25 |
1802301 | 1802301 | 2021-10-10 | Dare | North Carolina | 37055 | 3604 | 12 |
1802302 | 1802302 | 2021-10-10 | Davidson | North Carolina | 37057 | 25006 | 287 |
1802303 | 1802303 | 2021-10-10 | Davie | North Carolina | 37059 | 6152 | 67 |
1802304 | 1802304 | 2021-10-10 | Duplin | North Carolina | 37061 | 9649 | 172 |
1802305 | 1802305 | 2021-10-10 | Durham | North Carolina | 37063 | 34130 | 255 |
1802306 | 1802306 | 2021-10-10 | Edgecombe | North Carolina | 37065 | 7688 | 123 |
1802307 | 1802307 | 2021-10-10 | Forsyth | North Carolina | 37067 | 50000 | 530 |
1802308 | 1802308 | 2021-10-10 | Franklin | North Carolina | 37069 | 9465 | 60 |
1802309 | 1802309 | 2021-10-10 | Gaston | North Carolina | 37071 | 38627 | 582 |
1802310 | 1802310 | 2021-10-10 | Gates | North Carolina | 37073 | 1025 | 17 |
1802311 | 1802311 | 2021-10-10 | Graham | North Carolina | 37075 | 1288 | 27 |
1802312 | 1802312 | 2021-10-10 | Granville | North Carolina | 37077 | 7690 | 99 |
1802313 | 1802313 | 2021-10-10 | Greene | North Carolina | 37079 | 3217 | 53 |
1802314 | 1802314 | 2021-10-10 | Guilford | North Carolina | 37081 | 65461 | 845 |
1802315 | 1802315 | 2021-10-10 | Halifax | North Carolina | 37083 | 7568 | 132 |
1802316 | 1802316 | 2021-10-10 | Harnett | North Carolina | 37085 | 17735 | 241 |
1802317 | 1802317 | 2021-10-10 | Haywood | North Carolina | 37087 | 7081 | 135 |
1802318 | 1802318 | 2021-10-10 | Henderson | North Carolina | 37089 | 14660 | 190 |
1802319 | 1802319 | 2021-10-10 | Hertford | North Carolina | 37091 | 2716 | 69 |
1802320 | 1802320 | 2021-10-10 | Hoke | North Carolina | 37093 | 6933 | 77 |
1802321 | 1802321 | 2021-10-10 | Hyde | North Carolina | 37095 | 818 | 11 |
1802322 | 1802322 | 2021-10-10 | Iredell | North Carolina | 37097 | 27929 | 310 |
1802323 | 1802323 | 2021-10-10 | Jackson | North Carolina | 37099 | 5414 | 69 |
1802324 | 1802324 | 2021-10-10 | Johnston | North Carolina | 37101 | 31402 | 316 |
1802325 | 1802325 | 2021-10-10 | Jones | North Carolina | 37103 | 1284 | 29 |
1802326 | 1802326 | 2021-10-10 | Lee | North Carolina | 37105 | 9164 | 102 |
1802327 | 1802327 | 2021-10-10 | Lenoir | North Carolina | 37107 | 9254 | 146 |
1802328 | 1802328 | 2021-10-10 | Lincoln | North Carolina | 37109 | 14446 | 92 |
1802329 | 1802329 | 2021-10-10 | Macon | North Carolina | 37113 | 4760 | 54 |
1802330 | 1802330 | 2021-10-10 | Madison | North Carolina | 37115 | 2661 | 55 |
1802331 | 1802331 | 2021-10-10 | Martin | North Carolina | 37117 | 3512 | 63 |
1802332 | 1802332 | 2021-10-10 | McDowell | North Carolina | 37111 | 8323 | 114 |
1802333 | 1802333 | 2021-10-10 | Mecklenburg | North Carolina | 37119 | 153083 | 1188 |
1802334 | 1802334 | 2021-10-10 | Mitchell | North Carolina | 37121 | 1945 | 18 |
1802335 | 1802335 | 2021-10-10 | Montgomery | North Carolina | 37123 | 4382 | 108 |
1802336 | 1802336 | 2021-10-10 | Moore | North Carolina | 37125 | 13226 | 238 |
1802337 | 1802337 | 2021-10-10 | Nash | North Carolina | 37127 | 14947 | 223 |
1802338 | 1802338 | 2021-10-10 | New Hanover | North Carolina | 37129 | 28036 | 275 |
1802339 | 1802339 | 2021-10-10 | Northampton | North Carolina | 37131 | 2517 | 62 |
1802340 | 1802340 | 2021-10-10 | Onslow | North Carolina | 37133 | 27286 | 241 |
1802341 | 1802341 | 2021-10-10 | Orange | North Carolina | 37135 | 11440 | 109 |
1802342 | 1802342 | 2021-10-10 | Pamlico | North Carolina | 37137 | 1647 | 23 |
1802343 | 1802343 | 2021-10-10 | Pasquotank | North Carolina | 37139 | 4846 | 98 |
1802344 | 1802344 | 2021-10-10 | Pender | North Carolina | 37141 | 8585 | 95 |
1802345 | 1802345 | 2021-10-10 | Perquimans | North Carolina | 37143 | 1463 | 15 |
1802346 | 1802346 | 2021-10-10 | Person | North Carolina | 37145 | 4984 | 87 |
1802347 | 1802347 | 2021-10-10 | Pitt | North Carolina | 37147 | 28711 | 138 |
1802348 | 1802348 | 2021-10-10 | Polk | North Carolina | 37149 | 2235 | 43 |
1802349 | 1802349 | 2021-10-10 | Randolph | North Carolina | 37151 | 20926 | 296 |
1802350 | 1802350 | 2021-10-10 | Richmond | North Carolina | 37153 | 6927 | 134 |
1802351 | 1802351 | 2021-10-10 | Robeson | North Carolina | 37155 | 24495 | 415 |
1802352 | 1802352 | 2021-10-10 | Rockingham | North Carolina | 37157 | 11435 | 192 |
1802353 | 1802353 | 2021-10-10 | Rowan | North Carolina | 37159 | 25580 | 426 |
1802354 | 1802354 | 2021-10-10 | Rutherford | North Carolina | 37161 | 10970 | 293 |
1802355 | 1802355 | 2021-10-10 | Sampson | North Carolina | 37163 | 10910 | 128 |
1802356 | 1802356 | 2021-10-10 | Scotland | North Carolina | 37165 | 5569 | 104 |
1802357 | 1802357 | 2021-10-10 | Stanly | North Carolina | 37167 | 11276 | 173 |
1802358 | 1802358 | 2021-10-10 | Stokes | North Carolina | 37169 | 5922 | 101 |
1802359 | 1802359 | 2021-10-10 | Surry | North Carolina | 37171 | 11815 | 220 |
1802360 | 1802360 | 2021-10-10 | Swain | North Carolina | 37173 | 1900 | 22 |
1802361 | 1802361 | 2021-10-10 | Transylvania | North Carolina | 37175 | 3785 | 45 |
1802362 | 1802362 | 2021-10-10 | Tyrrell | North Carolina | 37177 | 530 | 7 |
1802363 | 1802363 | 2021-10-10 | Union | North Carolina | 37179 | 35163 | 311 |
1802364 | 1802364 | 2021-10-10 | Vance | North Carolina | 37181 | 6471 | 97 |
1802365 | 1802365 | 2021-10-10 | Wake | North Carolina | 37183 | 126366 | 869 |
1802366 | 1802366 | 2021-10-10 | Warren | North Carolina | 37185 | 2292 | 27 |
1802367 | 1802367 | 2021-10-10 | Washington | North Carolina | 37187 | 1539 | 35 |
1802368 | 1802368 | 2021-10-10 | Watauga | North Carolina | 37189 | 6386 | 34 |
1802369 | 1802369 | 2021-10-10 | Wayne | North Carolina | 37191 | 15404 | 297 |
1802370 | 1802370 | 2021-10-10 | Wilkes | North Carolina | 37193 | 10280 | 172 |
1802371 | 1802371 | 2021-10-10 | Wilson | North Carolina | 37195 | 12863 | 222 |
1802372 | 1802372 | 2021-10-10 | Yadkin | North Carolina | 37197 | 5795 | 70 |
1802373 | 1802373 | 2021-10-10 | Yancey | North Carolina | 37199 | 2728 | 29 |
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);