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-01-16 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 |
---|---|---|---|---|---|---|---|
935322 | 935322 | 2021-01-16 | Alamance | North Carolina | 37001 | 12490 | 169 |
935323 | 935323 | 2021-01-16 | Alexander | North Carolina | 37003 | 3235 | 42 |
935324 | 935324 | 2021-01-16 | Alleghany | North Carolina | 37005 | 761 | 3 |
935325 | 935325 | 2021-01-16 | Anson | North Carolina | 37007 | 1759 | 38 |
935326 | 935326 | 2021-01-16 | Ashe | North Carolina | 37009 | 1544 | 28 |
935327 | 935327 | 2021-01-16 | Avery | North Carolina | 37011 | 1587 | 16 |
935328 | 935328 | 2021-01-16 | Beaufort | North Carolina | 37013 | 3393 | 61 |
935329 | 935329 | 2021-01-16 | Bertie | North Carolina | 37015 | 1413 | 27 |
935330 | 935330 | 2021-01-16 | Bladen | North Carolina | 37017 | 2285 | 28 |
935331 | 935331 | 2021-01-16 | Brunswick | North Carolina | 37019 | 5624 | 80 |
935332 | 935332 | 2021-01-16 | Buncombe | North Carolina | 37021 | 11722 | 228 |
935333 | 935333 | 2021-01-16 | Burke | North Carolina | 37023 | 7534 | 89 |
935334 | 935334 | 2021-01-16 | Cabarrus | North Carolina | 37025 | 14089 | 171 |
935335 | 935335 | 2021-01-16 | Caldwell | North Carolina | 37027 | 7182 | 31 |
935336 | 935336 | 2021-01-16 | Camden | North Carolina | 37029 | 410 | 5 |
935337 | 935337 | 2021-01-16 | Carteret | North Carolina | 37031 | 3352 | 18 |
935338 | 935338 | 2021-01-16 | Caswell | North Carolina | 37033 | 1495 | 10 |
935339 | 935339 | 2021-01-16 | Catawba | North Carolina | 37035 | 13719 | 205 |
935340 | 935340 | 2021-01-16 | Chatham | North Carolina | 37037 | 3320 | 68 |
935341 | 935341 | 2021-01-16 | Cherokee | North Carolina | 37039 | 1646 | 16 |
935342 | 935342 | 2021-01-16 | Chowan | North Carolina | 37041 | 1022 | 20 |
935343 | 935343 | 2021-01-16 | Clay | North Carolina | 37043 | 531 | 5 |
935344 | 935344 | 2021-01-16 | Cleveland | North Carolina | 37045 | 8386 | 170 |
935345 | 935345 | 2021-01-16 | Columbus | North Carolina | 37047 | 4517 | 102 |
935346 | 935346 | 2021-01-16 | Craven | North Carolina | 37049 | 6338 | 89 |
935347 | 935347 | 2021-01-16 | Cumberland | North Carolina | 37051 | 17376 | 151 |
935348 | 935348 | 2021-01-16 | Currituck | North Carolina | 37053 | 905 | 12 |
935349 | 935349 | 2021-01-16 | Dare | North Carolina | 37055 | 1439 | 6 |
935350 | 935350 | 2021-01-16 | Davidson | North Carolina | 37057 | 11261 | 102 |
935351 | 935351 | 2021-01-16 | Davie | North Carolina | 37059 | 2647 | 15 |
935352 | 935352 | 2021-01-16 | Duplin | North Carolina | 37061 | 4870 | 83 |
935353 | 935353 | 2021-01-16 | Durham | North Carolina | 37063 | 17468 | 160 |
935354 | 935354 | 2021-01-16 | Edgecombe | North Carolina | 37065 | 3689 | 87 |
935355 | 935355 | 2021-01-16 | Forsyth | North Carolina | 37067 | 24699 | 248 |
935356 | 935356 | 2021-01-16 | Franklin | North Carolina | 37069 | 4009 | 39 |
935357 | 935357 | 2021-01-16 | Gaston | North Carolina | 37071 | 19264 | 276 |
935358 | 935358 | 2021-01-16 | Gates | North Carolina | 37073 | 461 | 12 |
935359 | 935359 | 2021-01-16 | Graham | North Carolina | 37075 | 492 | 12 |
935360 | 935360 | 2021-01-16 | Granville | North Carolina | 37077 | 4297 | 70 |
935361 | 935361 | 2021-01-16 | Greene | North Carolina | 37079 | 1752 | 34 |
935362 | 935362 | 2021-01-16 | Guilford | North Carolina | 37081 | 30594 | 357 |
935363 | 935363 | 2021-01-16 | Halifax | North Carolina | 37083 | 3754 | 64 |
935364 | 935364 | 2021-01-16 | Harnett | North Carolina | 37085 | 7306 | 105 |
935365 | 935365 | 2021-01-16 | Haywood | North Carolina | 37087 | 2879 | 75 |
935366 | 935366 | 2021-01-16 | Henderson | North Carolina | 37089 | 6797 | 98 |
935367 | 935367 | 2021-01-16 | Hertford | North Carolina | 37091 | 1618 | 53 |
935368 | 935368 | 2021-01-16 | Hoke | North Carolina | 37093 | 3296 | 37 |
935369 | 935369 | 2021-01-16 | Hyde | North Carolina | 37095 | 553 | 6 |
935370 | 935370 | 2021-01-16 | Iredell | North Carolina | 37097 | 11946 | 131 |
935371 | 935371 | 2021-01-16 | Jackson | North Carolina | 37099 | 2707 | 20 |
935372 | 935372 | 2021-01-16 | Johnston | North Carolina | 37101 | 14059 | 139 |
935373 | 935373 | 2021-01-16 | Jones | North Carolina | 37103 | 506 | 16 |
935374 | 935374 | 2021-01-16 | Lee | North Carolina | 37105 | 4309 | 46 |
935375 | 935375 | 2021-01-16 | Lenoir | North Carolina | 37107 | 4136 | 83 |
935376 | 935376 | 2021-01-16 | Lincoln | North Carolina | 37109 | 6873 | 42 |
935377 | 935377 | 2021-01-16 | Macon | North Carolina | 37113 | 1961 | 12 |
935378 | 935378 | 2021-01-16 | Madison | North Carolina | 37115 | 1051 | 23 |
935379 | 935379 | 2021-01-16 | Martin | North Carolina | 37117 | 1692 | 27 |
935380 | 935380 | 2021-01-16 | McDowell | North Carolina | 37111 | 3888 | 39 |
935381 | 935381 | 2021-01-16 | Mecklenburg | North Carolina | 37119 | 76542 | 683 |
935382 | 935382 | 2021-01-16 | Mitchell | North Carolina | 37121 | 984 | 10 |
935383 | 935383 | 2021-01-16 | Montgomery | North Carolina | 37123 | 2427 | 52 |
935384 | 935384 | 2021-01-16 | Moore | North Carolina | 37125 | 6117 | 80 |
935385 | 935385 | 2021-01-16 | Nash | North Carolina | 37127 | 7074 | 126 |
935386 | 935386 | 2021-01-16 | New Hanover | North Carolina | 37129 | 11298 | 100 |
935387 | 935387 | 2021-01-16 | Northampton | North Carolina | 37131 | 1325 | 27 |
935388 | 935388 | 2021-01-16 | Onslow | North Carolina | 37133 | 11178 | 89 |
935389 | 935389 | 2021-01-16 | Orange | North Carolina | 37135 | 6016 | 69 |
935390 | 935390 | 2021-01-16 | Pamlico | North Carolina | 37137 | 654 | 6 |
935391 | 935391 | 2021-01-16 | Pasquotank | North Carolina | 37139 | 2356 | 59 |
935392 | 935392 | 2021-01-16 | Pender | North Carolina | 37141 | 3488 | 25 |
935393 | 935393 | 2021-01-16 | Perquimans | North Carolina | 37143 | 684 | 5 |
935394 | 935394 | 2021-01-16 | Person | North Carolina | 37145 | 2147 | 35 |
935395 | 935395 | 2021-01-16 | Pitt | North Carolina | 37147 | 13814 | 69 |
935396 | 935396 | 2021-01-16 | Polk | North Carolina | 37149 | 1036 | 14 |
935397 | 935397 | 2021-01-16 | Randolph | North Carolina | 37151 | 9890 | 153 |
935398 | 935398 | 2021-01-16 | Richmond | North Carolina | 37153 | 3233 | 58 |
935399 | 935399 | 2021-01-16 | Robeson | North Carolina | 37155 | 11918 | 153 |
935400 | 935400 | 2021-01-16 | Rockingham | North Carolina | 37157 | 5625 | 32 |
935401 | 935401 | 2021-01-16 | Rowan | North Carolina | 37159 | 11487 | 217 |
935402 | 935402 | 2021-01-16 | Rutherford | North Carolina | 37161 | 5564 | 150 |
935403 | 935403 | 2021-01-16 | Sampson | North Carolina | 37163 | 5695 | 73 |
935404 | 935404 | 2021-01-16 | Scotland | North Carolina | 37165 | 2943 | 60 |
935405 | 935405 | 2021-01-16 | Stanly | North Carolina | 37167 | 5373 | 92 |
935406 | 935406 | 2021-01-16 | Stokes | North Carolina | 37169 | 2643 | 44 |
935407 | 935407 | 2021-01-16 | Surry | North Carolina | 37171 | 5561 | 97 |
935408 | 935408 | 2021-01-16 | Swain | North Carolina | 37173 | 929 | 8 |
935409 | 935409 | 2021-01-16 | Transylvania | North Carolina | 37175 | 1340 | 12 |
935410 | 935410 | 2021-01-16 | Tyrrell | North Carolina | 37177 | 215 | 4 |
935411 | 935411 | 2021-01-16 | Union | North Carolina | 37179 | 16036 | 125 |
935412 | 935412 | 2021-01-16 | Vance | North Carolina | 37181 | 3301 | 73 |
935413 | 935413 | 2021-01-16 | Wake | North Carolina | 37183 | 56241 | 394 |
935414 | 935414 | 2021-01-16 | Warren | North Carolina | 37185 | 1273 | 12 |
935415 | 935415 | 2021-01-16 | Washington | North Carolina | 37187 | 636 | 19 |
935416 | 935416 | 2021-01-16 | Watauga | North Carolina | 37189 | 3088 | 23 |
935417 | 935417 | 2021-01-16 | Wayne | North Carolina | 37191 | 8404 | 164 |
935418 | 935418 | 2021-01-16 | Wilkes | North Carolina | 37193 | 4787 | 83 |
935419 | 935419 | 2021-01-16 | Wilson | North Carolina | 37195 | 6754 | 123 |
935420 | 935420 | 2021-01-16 | Yadkin | North Carolina | 37197 | 2972 | 33 |
935421 | 935421 | 2021-01-16 | Yancey | North Carolina | 37199 | 1209 | 10 |
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);