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-08-29 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 |
---|---|---|---|---|---|---|---|
481334 | 481334 | 2020-08-29 | Alamance | North Carolina | 37001 | 3076 | 46 |
481335 | 481335 | 2020-08-29 | Alexander | North Carolina | 37003 | 396 | 2 |
481336 | 481336 | 2020-08-29 | Alleghany | North Carolina | 37005 | 203 | 0 |
481337 | 481337 | 2020-08-29 | Anson | North Carolina | 37007 | 437 | 3 |
481338 | 481338 | 2020-08-29 | Ashe | North Carolina | 37009 | 194 | 1 |
481339 | 481339 | 2020-08-29 | Avery | North Carolina | 37011 | 133 | 0 |
481340 | 481340 | 2020-08-29 | Beaufort | North Carolina | 37013 | 558 | 9 |
481341 | 481341 | 2020-08-29 | Bertie | North Carolina | 37015 | 413 | 6 |
481342 | 481342 | 2020-08-29 | Bladen | North Carolina | 37017 | 702 | 10 |
481343 | 481343 | 2020-08-29 | Brunswick | North Carolina | 37019 | 1379 | 24 |
481344 | 481344 | 2020-08-29 | Buncombe | North Carolina | 37021 | 2424 | 80 |
481345 | 481345 | 2020-08-29 | Burke | North Carolina | 37023 | 1840 | 30 |
481346 | 481346 | 2020-08-29 | Cabarrus | North Carolina | 37025 | 3136 | 53 |
481347 | 481347 | 2020-08-29 | Caldwell | North Carolina | 37027 | 1417 | 17 |
481348 | 481348 | 2020-08-29 | Camden | North Carolina | 37029 | 96 | 3 |
481349 | 481349 | 2020-08-29 | Carteret | North Carolina | 37031 | 482 | 5 |
481350 | 481350 | 2020-08-29 | Caswell | North Carolina | 37033 | 243 | 2 |
481351 | 481351 | 2020-08-29 | Catawba | North Carolina | 37035 | 2591 | 44 |
481352 | 481352 | 2020-08-29 | Chatham | North Carolina | 37037 | 1468 | 56 |
481353 | 481353 | 2020-08-29 | Cherokee | North Carolina | 37039 | 409 | 5 |
481354 | 481354 | 2020-08-29 | Chowan | North Carolina | 37041 | 211 | 2 |
481355 | 481355 | 2020-08-29 | Clay | North Carolina | 37043 | 88 | 1 |
481356 | 481356 | 2020-08-29 | Cleveland | North Carolina | 37045 | 1586 | 35 |
481357 | 481357 | 2020-08-29 | Columbus | North Carolina | 37047 | 1095 | 51 |
481358 | 481358 | 2020-08-29 | Craven | North Carolina | 37049 | 958 | 26 |
481359 | 481359 | 2020-08-29 | Cumberland | North Carolina | 37051 | 3994 | 66 |
481360 | 481360 | 2020-08-29 | Currituck | North Carolina | 37053 | 96 | 0 |
481361 | 481361 | 2020-08-29 | Dare | North Carolina | 37055 | 241 | 2 |
481362 | 481362 | 2020-08-29 | Davidson | North Carolina | 37057 | 2145 | 32 |
481363 | 481363 | 2020-08-29 | Davie | North Carolina | 37059 | 473 | 6 |
481364 | 481364 | 2020-08-29 | Duplin | North Carolina | 37061 | 2076 | 50 |
481365 | 481365 | 2020-08-29 | Durham | North Carolina | 37063 | 6889 | 84 |
481366 | 481366 | 2020-08-29 | Edgecombe | North Carolina | 37065 | 938 | 19 |
481367 | 481367 | 2020-08-29 | Forsyth | North Carolina | 37067 | 6119 | 74 |
481368 | 481368 | 2020-08-29 | Franklin | North Carolina | 37069 | 1041 | 29 |
481369 | 481369 | 2020-08-29 | Gaston | North Carolina | 37071 | 4052 | 63 |
481370 | 481370 | 2020-08-29 | Gates | North Carolina | 37073 | 83 | 3 |
481371 | 481371 | 2020-08-29 | Graham | North Carolina | 37075 | 55 | 0 |
481372 | 481372 | 2020-08-29 | Granville | North Carolina | 37077 | 1508 | 43 |
481373 | 481373 | 2020-08-29 | Greene | North Carolina | 37079 | 403 | 4 |
481374 | 481374 | 2020-08-29 | Guilford | North Carolina | 37081 | 6771 | 170 |
481375 | 481375 | 2020-08-29 | Halifax | North Carolina | 37083 | 861 | 11 |
481376 | 481376 | 2020-08-29 | Harnett | North Carolina | 37085 | 1595 | 46 |
481377 | 481377 | 2020-08-29 | Haywood | North Carolina | 37087 | 503 | 25 |
481378 | 481378 | 2020-08-29 | Henderson | North Carolina | 37089 | 1687 | 60 |
481379 | 481379 | 2020-08-29 | Hertford | North Carolina | 37091 | 531 | 14 |
481380 | 481380 | 2020-08-29 | Hoke | North Carolina | 37093 | 865 | 12 |
481381 | 481381 | 2020-08-29 | Hyde | North Carolina | 37095 | 92 | 0 |
481382 | 481382 | 2020-08-29 | Iredell | North Carolina | 37097 | 2314 | 24 |
481383 | 481383 | 2020-08-29 | Jackson | North Carolina | 37099 | 488 | 7 |
481384 | 481384 | 2020-08-29 | Johnston | North Carolina | 37101 | 3806 | 50 |
481385 | 481385 | 2020-08-29 | Jones | North Carolina | 37103 | 133 | 7 |
481386 | 481386 | 2020-08-29 | Lee | North Carolina | 37105 | 1423 | 12 |
481387 | 481387 | 2020-08-29 | Lenoir | North Carolina | 37107 | 776 | 16 |
481388 | 481388 | 2020-08-29 | Lincoln | North Carolina | 37109 | 1093 | 12 |
481389 | 481389 | 2020-08-29 | Macon | North Carolina | 37113 | 538 | 2 |
481390 | 481390 | 2020-08-29 | Madison | North Carolina | 37115 | 67 | 1 |
481391 | 481391 | 2020-08-29 | Martin | North Carolina | 37117 | 337 | 7 |
481392 | 481392 | 2020-08-29 | McDowell | North Carolina | 37111 | 786 | 24 |
481393 | 481393 | 2020-08-29 | Mecklenburg | North Carolina | 37119 | 25262 | 290 |
481394 | 481394 | 2020-08-29 | Mitchell | North Carolina | 37121 | 92 | 3 |
481395 | 481395 | 2020-08-29 | Montgomery | North Carolina | 37123 | 869 | 18 |
481396 | 481396 | 2020-08-29 | Moore | North Carolina | 37125 | 1281 | 21 |
481397 | 481397 | 2020-08-29 | Nash | North Carolina | 37127 | 1629 | 22 |
481398 | 481398 | 2020-08-29 | New Hanover | North Carolina | 37129 | 2976 | 21 |
481399 | 481399 | 2020-08-29 | Northampton | North Carolina | 37131 | 336 | 17 |
481400 | 481400 | 2020-08-29 | Onslow | North Carolina | 37133 | 1460 | 12 |
481401 | 481401 | 2020-08-29 | Orange | North Carolina | 37135 | 2239 | 50 |
481402 | 481402 | 2020-08-29 | Pamlico | North Carolina | 37137 | 115 | 2 |
481403 | 481403 | 2020-08-29 | Pasquotank | North Carolina | 37139 | 544 | 23 |
481404 | 481404 | 2020-08-29 | Pender | North Carolina | 37141 | 762 | 4 |
481405 | 481405 | 2020-08-29 | Perquimans | North Carolina | 37143 | 133 | 2 |
481406 | 481406 | 2020-08-29 | Person | North Carolina | 37145 | 316 | 5 |
481407 | 481407 | 2020-08-29 | Pitt | North Carolina | 37147 | 3376 | 17 |
481408 | 481408 | 2020-08-29 | Polk | North Carolina | 37149 | 225 | 7 |
481409 | 481409 | 2020-08-29 | Randolph | North Carolina | 37151 | 2400 | 43 |
481410 | 481410 | 2020-08-29 | Richmond | North Carolina | 37153 | 658 | 11 |
481411 | 481411 | 2020-08-29 | Robeson | North Carolina | 37155 | 3482 | 60 |
481412 | 481412 | 2020-08-29 | Rockingham | North Carolina | 37157 | 795 | 8 |
481413 | 481413 | 2020-08-29 | Rowan | North Carolina | 37159 | 2770 | 63 |
481414 | 481414 | 2020-08-29 | Rutherford | North Carolina | 37161 | 986 | 24 |
481415 | 481415 | 2020-08-29 | Sampson | North Carolina | 37163 | 1603 | 21 |
481416 | 481416 | 2020-08-29 | Scotland | North Carolina | 37165 | 643 | 8 |
481417 | 481417 | 2020-08-29 | Stanly | North Carolina | 37167 | 1467 | 31 |
481418 | 481418 | 2020-08-29 | Stokes | North Carolina | 37169 | 328 | 3 |
481419 | 481419 | 2020-08-29 | Surry | North Carolina | 37171 | 1148 | 16 |
481420 | 481420 | 2020-08-29 | Swain | North Carolina | 37173 | 130 | 3 |
481421 | 481421 | 2020-08-29 | Transylvania | North Carolina | 37175 | 243 | 2 |
481422 | 481422 | 2020-08-29 | Tyrrell | North Carolina | 37177 | 107 | 2 |
481423 | 481423 | 2020-08-29 | Union | North Carolina | 37179 | 3912 | 48 |
481424 | 481424 | 2020-08-29 | Vance | North Carolina | 37181 | 897 | 42 |
481425 | 481425 | 2020-08-29 | Wake | North Carolina | 37183 | 14902 | 199 |
481426 | 481426 | 2020-08-29 | Warren | North Carolina | 37185 | 287 | 6 |
481427 | 481427 | 2020-08-29 | Washington | North Carolina | 37187 | 173 | 4 |
481428 | 481428 | 2020-08-29 | Watauga | North Carolina | 37189 | 424 | 0 |
481429 | 481429 | 2020-08-29 | Wayne | North Carolina | 37191 | 2799 | 51 |
481430 | 481430 | 2020-08-29 | Wilkes | North Carolina | 37193 | 1017 | 20 |
481431 | 481431 | 2020-08-29 | Wilson | North Carolina | 37195 | 1715 | 36 |
481432 | 481432 | 2020-08-29 | Yadkin | North Carolina | 37197 | 630 | 7 |
481433 | 481433 | 2020-08-29 | Yancey | North Carolina | 37199 | 88 | 0 |
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);