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-11-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 |
---|---|---|---|---|---|---|---|
737352 | 737352 | 2020-11-16 | Alamance | North Carolina | 37001 | 6110 | 96 |
737353 | 737353 | 2020-11-16 | Alexander | North Carolina | 37003 | 1315 | 13 |
737354 | 737354 | 2020-11-16 | Alleghany | North Carolina | 37005 | 360 | 1 |
737355 | 737355 | 2020-11-16 | Anson | North Carolina | 37007 | 816 | 13 |
737356 | 737356 | 2020-11-16 | Ashe | North Carolina | 37009 | 633 | 3 |
737357 | 737357 | 2020-11-16 | Avery | North Carolina | 37011 | 733 | 2 |
737358 | 737358 | 2020-11-16 | Beaufort | North Carolina | 37013 | 1549 | 52 |
737359 | 737359 | 2020-11-16 | Bertie | North Carolina | 37015 | 799 | 21 |
737360 | 737360 | 2020-11-16 | Bladen | North Carolina | 37017 | 1196 | 19 |
737361 | 737361 | 2020-11-16 | Brunswick | North Carolina | 37019 | 2567 | 55 |
737362 | 737362 | 2020-11-16 | Buncombe | North Carolina | 37021 | 4860 | 120 |
737363 | 737363 | 2020-11-16 | Burke | North Carolina | 37023 | 3245 | 60 |
737364 | 737364 | 2020-11-16 | Cabarrus | North Carolina | 37025 | 5900 | 101 |
737365 | 737365 | 2020-11-16 | Caldwell | North Carolina | 37027 | 3052 | 21 |
737366 | 737366 | 2020-11-16 | Camden | North Carolina | 37029 | 160 | 3 |
737367 | 737367 | 2020-11-16 | Carteret | North Carolina | 37031 | 1442 | 14 |
737368 | 737368 | 2020-11-16 | Caswell | North Carolina | 37033 | 728 | 6 |
737369 | 737369 | 2020-11-16 | Catawba | North Carolina | 37035 | 5690 | 71 |
737370 | 737370 | 2020-11-16 | Chatham | North Carolina | 37037 | 2185 | 65 |
737371 | 737371 | 2020-11-16 | Cherokee | North Carolina | 37039 | 858 | 15 |
737372 | 737372 | 2020-11-16 | Chowan | North Carolina | 37041 | 573 | 18 |
737373 | 737373 | 2020-11-16 | Clay | North Carolina | 37043 | 265 | 6 |
737374 | 737374 | 2020-11-16 | Cleveland | North Carolina | 37045 | 3786 | 95 |
737375 | 737375 | 2020-11-16 | Columbus | North Carolina | 37047 | 2195 | 67 |
737376 | 737376 | 2020-11-16 | Craven | North Carolina | 37049 | 2701 | 66 |
737377 | 737377 | 2020-11-16 | Cumberland | North Carolina | 37051 | 8261 | 109 |
737378 | 737378 | 2020-11-16 | Currituck | North Carolina | 37053 | 280 | 4 |
737379 | 737379 | 2020-11-16 | Dare | North Carolina | 37055 | 538 | 3 |
737380 | 737380 | 2020-11-16 | Davidson | North Carolina | 37057 | 4467 | 48 |
737381 | 737381 | 2020-11-16 | Davie | North Carolina | 37059 | 980 | 11 |
737382 | 737382 | 2020-11-16 | Duplin | North Carolina | 37061 | 3069 | 56 |
737383 | 737383 | 2020-11-16 | Durham | North Carolina | 37063 | 10422 | 108 |
737384 | 737384 | 2020-11-16 | Edgecombe | North Carolina | 37065 | 2308 | 66 |
737385 | 737385 | 2020-11-16 | Forsyth | North Carolina | 37067 | 11014 | 146 |
737386 | 737386 | 2020-11-16 | Franklin | North Carolina | 37069 | 1716 | 32 |
737387 | 737387 | 2020-11-16 | Gaston | North Carolina | 37071 | 8959 | 164 |
737388 | 737388 | 2020-11-16 | Gates | North Carolina | 37073 | 186 | 5 |
737389 | 737389 | 2020-11-16 | Graham | North Carolina | 37075 | 265 | 10 |
737390 | 737390 | 2020-11-16 | Granville | North Carolina | 37077 | 2290 | 54 |
737391 | 737391 | 2020-11-16 | Greene | North Carolina | 37079 | 1100 | 21 |
737392 | 737392 | 2020-11-16 | Guilford | North Carolina | 37081 | 14115 | 218 |
737393 | 737393 | 2020-11-16 | Halifax | North Carolina | 37083 | 1723 | 32 |
737394 | 737394 | 2020-11-16 | Harnett | North Carolina | 37085 | 3436 | 77 |
737395 | 737395 | 2020-11-16 | Haywood | North Carolina | 37087 | 874 | 37 |
737396 | 737396 | 2020-11-16 | Henderson | North Carolina | 37089 | 2811 | 70 |
737397 | 737397 | 2020-11-16 | Hertford | North Carolina | 37091 | 917 | 38 |
737398 | 737398 | 2020-11-16 | Hoke | North Carolina | 37093 | 1764 | 28 |
737399 | 737399 | 2020-11-16 | Hyde | North Carolina | 37095 | 179 | 5 |
737400 | 737400 | 2020-11-16 | Iredell | North Carolina | 37097 | 4573 | 39 |
737401 | 737401 | 2020-11-16 | Jackson | North Carolina | 37099 | 1278 | 8 |
737402 | 737402 | 2020-11-16 | Johnston | North Carolina | 37101 | 6822 | 70 |
737403 | 737403 | 2020-11-16 | Jones | North Carolina | 37103 | 220 | 15 |
737404 | 737404 | 2020-11-16 | Lee | North Carolina | 37105 | 2287 | 29 |
737405 | 737405 | 2020-11-16 | Lenoir | North Carolina | 37107 | 1784 | 46 |
737406 | 737406 | 2020-11-16 | Lincoln | North Carolina | 37109 | 2935 | 16 |
737407 | 737407 | 2020-11-16 | Macon | North Carolina | 37113 | 848 | 8 |
737408 | 737408 | 2020-11-16 | Madison | North Carolina | 37115 | 395 | 7 |
737409 | 737409 | 2020-11-16 | Martin | North Carolina | 37117 | 739 | 20 |
737410 | 737410 | 2020-11-16 | McDowell | North Carolina | 37111 | 1577 | 34 |
737411 | 737411 | 2020-11-16 | Mecklenburg | North Carolina | 37119 | 38677 | 421 |
737412 | 737412 | 2020-11-16 | Mitchell | North Carolina | 37121 | 406 | 4 |
737413 | 737413 | 2020-11-16 | Montgomery | North Carolina | 37123 | 1285 | 40 |
737414 | 737414 | 2020-11-16 | Moore | North Carolina | 37125 | 2568 | 58 |
737415 | 737415 | 2020-11-16 | Nash | North Carolina | 37127 | 3972 | 88 |
737416 | 737416 | 2020-11-16 | New Hanover | North Carolina | 37129 | 6180 | 47 |
737417 | 737417 | 2020-11-16 | Northampton | North Carolina | 37131 | 680 | 22 |
737418 | 737418 | 2020-11-16 | Onslow | North Carolina | 37133 | 4215 | 36 |
737419 | 737419 | 2020-11-16 | Orange | North Carolina | 37135 | 3520 | 61 |
737420 | 737420 | 2020-11-16 | Pamlico | North Carolina | 37137 | 357 | 3 |
737421 | 737421 | 2020-11-16 | Pasquotank | North Carolina | 37139 | 997 | 35 |
737422 | 737422 | 2020-11-16 | Pender | North Carolina | 37141 | 1632 | 17 |
737423 | 737423 | 2020-11-16 | Perquimans | North Carolina | 37143 | 292 | 4 |
737424 | 737424 | 2020-11-16 | Person | North Carolina | 37145 | 835 | 10 |
737425 | 737425 | 2020-11-16 | Pitt | North Carolina | 37147 | 7041 | 44 |
737426 | 737426 | 2020-11-16 | Polk | North Carolina | 37149 | 432 | 13 |
737427 | 737427 | 2020-11-16 | Randolph | North Carolina | 37151 | 4661 | 73 |
737428 | 737428 | 2020-11-16 | Richmond | North Carolina | 37153 | 1652 | 36 |
737429 | 737429 | 2020-11-16 | Robeson | North Carolina | 37155 | 6727 | 103 |
737430 | 737430 | 2020-11-16 | Rockingham | North Carolina | 37157 | 2567 | 19 |
737431 | 737431 | 2020-11-16 | Rowan | North Carolina | 37159 | 4909 | 124 |
737432 | 737432 | 2020-11-16 | Rutherford | North Carolina | 37161 | 2008 | 82 |
737433 | 737433 | 2020-11-16 | Sampson | North Carolina | 37163 | 3215 | 32 |
737434 | 737434 | 2020-11-16 | Scotland | North Carolina | 37165 | 1765 | 35 |
737435 | 737435 | 2020-11-16 | Stanly | North Carolina | 37167 | 2687 | 78 |
737436 | 737436 | 2020-11-16 | Stokes | North Carolina | 37169 | 912 | 14 |
737437 | 737437 | 2020-11-16 | Surry | North Carolina | 37171 | 2362 | 40 |
737438 | 737438 | 2020-11-16 | Swain | North Carolina | 37173 | 335 | 5 |
737439 | 737439 | 2020-11-16 | Transylvania | North Carolina | 37175 | 486 | 9 |
737440 | 737440 | 2020-11-16 | Tyrrell | North Carolina | 37177 | 135 | 3 |
737441 | 737441 | 2020-11-16 | Union | North Carolina | 37179 | 6888 | 68 |
737442 | 737442 | 2020-11-16 | Vance | North Carolina | 37181 | 1453 | 47 |
737443 | 737443 | 2020-11-16 | Wake | North Carolina | 37183 | 25460 | 280 |
737444 | 737444 | 2020-11-16 | Warren | North Carolina | 37185 | 551 | 7 |
737445 | 737445 | 2020-11-16 | Washington | North Carolina | 37187 | 286 | 8 |
737446 | 737446 | 2020-11-16 | Watauga | North Carolina | 37189 | 1586 | 6 |
737447 | 737447 | 2020-11-16 | Wayne | North Carolina | 37191 | 5196 | 105 |
737448 | 737448 | 2020-11-16 | Wilkes | North Carolina | 37193 | 2281 | 43 |
737449 | 737449 | 2020-11-16 | Wilson | North Carolina | 37195 | 3576 | 72 |
737450 | 737450 | 2020-11-16 | Yadkin | North Carolina | 37197 | 1256 | 12 |
737451 | 737451 | 2020-11-16 | Yancey | North Carolina | 37199 | 421 | 2 |
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);