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-08-31 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 |
---|---|---|---|---|---|---|---|
1672320 | 1672320 | 2021-08-31 | Alamance | North Carolina | 37001 | 21733 | 294 |
1672321 | 1672321 | 2021-08-31 | Alexander | North Carolina | 37003 | 5272 | 96 |
1672322 | 1672322 | 2021-08-31 | Alleghany | North Carolina | 37005 | 1210 | 5 |
1672323 | 1672323 | 2021-08-31 | Anson | North Carolina | 37007 | 3071 | 60 |
1672324 | 1672324 | 2021-08-31 | Ashe | North Carolina | 37009 | 2697 | 45 |
1672325 | 1672325 | 2021-08-31 | Avery | North Carolina | 37011 | 2321 | 22 |
1672326 | 1672326 | 2021-08-31 | Beaufort | North Carolina | 37013 | 5450 | 106 |
1672327 | 1672327 | 2021-08-31 | Bertie | North Carolina | 37015 | 2056 | 46 |
1672328 | 1672328 | 2021-08-31 | Bladen | North Carolina | 37017 | 4733 | 73 |
1672329 | 1672329 | 2021-08-31 | Brunswick | North Carolina | 37019 | 12780 | 181 |
1672330 | 1672330 | 2021-08-31 | Buncombe | North Carolina | 37021 | 22046 | 353 |
1672331 | 1672331 | 2021-08-31 | Burke | North Carolina | 37023 | 12303 | 164 |
1672332 | 1672332 | 2021-08-31 | Cabarrus | North Carolina | 37025 | 27445 | 279 |
1672333 | 1672333 | 2021-08-31 | Caldwell | North Carolina | 37027 | 10909 | 111 |
1672334 | 1672334 | 2021-08-31 | Camden | North Carolina | 37029 | 801 | 7 |
1672335 | 1672335 | 2021-08-31 | Carteret | North Carolina | 37031 | 6508 | 58 |
1672336 | 1672336 | 2021-08-31 | Caswell | North Carolina | 37033 | 2504 | 31 |
1672337 | 1672337 | 2021-08-31 | Catawba | North Carolina | 37035 | 23306 | 330 |
1672338 | 1672338 | 2021-08-31 | Chatham | North Carolina | 37037 | 5807 | 91 |
1672339 | 1672339 | 2021-08-31 | Cherokee | North Carolina | 37039 | 3602 | 45 |
1672340 | 1672340 | 2021-08-31 | Chowan | North Carolina | 37041 | 1775 | 37 |
1672341 | 1672341 | 2021-08-31 | Clay | North Carolina | 37043 | 1179 | 20 |
1672342 | 1672342 | 2021-08-31 | Cleveland | North Carolina | 37045 | 14390 | 246 |
1672343 | 1672343 | 2021-08-31 | Columbus | North Carolina | 37047 | 8606 | 174 |
1672344 | 1672344 | 2021-08-31 | Craven | North Carolina | 37049 | 11157 | 134 |
1672345 | 1672345 | 2021-08-31 | Cumberland | North Carolina | 37051 | 37473 | 378 |
1672346 | 1672346 | 2021-08-31 | Currituck | North Carolina | 37053 | 1970 | 17 |
1672347 | 1672347 | 2021-08-31 | Dare | North Carolina | 37055 | 3012 | 10 |
1672348 | 1672348 | 2021-08-31 | Davidson | North Carolina | 37057 | 20399 | 213 |
1672349 | 1672349 | 2021-08-31 | Davie | North Carolina | 37059 | 5043 | 49 |
1672350 | 1672350 | 2021-08-31 | Duplin | North Carolina | 37061 | 8182 | 152 |
1672351 | 1672351 | 2021-08-31 | Durham | North Carolina | 37063 | 29919 | 243 |
1672352 | 1672352 | 2021-08-31 | Edgecombe | North Carolina | 37065 | 6488 | 115 |
1672353 | 1672353 | 2021-08-31 | Forsyth | North Carolina | 37067 | 43059 | 457 |
1672354 | 1672354 | 2021-08-31 | Franklin | North Carolina | 37069 | 8113 | 55 |
1672355 | 1672355 | 2021-08-31 | Gaston | North Carolina | 37071 | 32288 | 474 |
1672356 | 1672356 | 2021-08-31 | Gates | North Carolina | 37073 | 852 | 13 |
1672357 | 1672357 | 2021-08-31 | Graham | North Carolina | 37075 | 935 | 17 |
1672358 | 1672358 | 2021-08-31 | Granville | North Carolina | 37077 | 6781 | 91 |
1672359 | 1672359 | 2021-08-31 | Greene | North Carolina | 37079 | 2874 | 50 |
1672360 | 1672360 | 2021-08-31 | Guilford | North Carolina | 37081 | 56018 | 772 |
1672361 | 1672361 | 2021-08-31 | Halifax | North Carolina | 37083 | 6536 | 118 |
1672362 | 1672362 | 2021-08-31 | Harnett | North Carolina | 37085 | 14975 | 199 |
1672363 | 1672363 | 2021-08-31 | Haywood | North Carolina | 37087 | 5643 | 108 |
1672364 | 1672364 | 2021-08-31 | Henderson | North Carolina | 37089 | 12497 | 166 |
1672365 | 1672365 | 2021-08-31 | Hertford | North Carolina | 37091 | 2347 | 65 |
1672366 | 1672366 | 2021-08-31 | Hoke | North Carolina | 37093 | 6035 | 59 |
1672367 | 1672367 | 2021-08-31 | Hyde | North Carolina | 37095 | 728 | 9 |
1672368 | 1672368 | 2021-08-31 | Iredell | North Carolina | 37097 | 23261 | 248 |
1672369 | 1672369 | 2021-08-31 | Jackson | North Carolina | 37099 | 4421 | 58 |
1672370 | 1672370 | 2021-08-31 | Johnston | North Carolina | 37101 | 27241 | 255 |
1672371 | 1672371 | 2021-08-31 | Jones | North Carolina | 37103 | 1025 | 29 |
1672372 | 1672372 | 2021-08-31 | Lee | North Carolina | 37105 | 7692 | 89 |
1672373 | 1672373 | 2021-08-31 | Lenoir | North Carolina | 37107 | 7449 | 131 |
1672374 | 1672374 | 2021-08-31 | Lincoln | North Carolina | 37109 | 12223 | 89 |
1672375 | 1672375 | 2021-08-31 | Macon | North Carolina | 37113 | 3782 | 43 |
1672376 | 1672376 | 2021-08-31 | Madison | North Carolina | 37115 | 2005 | 43 |
1672377 | 1672377 | 2021-08-31 | Martin | North Carolina | 37117 | 2862 | 50 |
1672378 | 1672378 | 2021-08-31 | McDowell | North Carolina | 37111 | 6540 | 66 |
1672379 | 1672379 | 2021-08-31 | Mecklenburg | North Carolina | 37119 | 135931 | 1050 |
1672380 | 1672380 | 2021-08-31 | Mitchell | North Carolina | 37121 | 1667 | 16 |
1672381 | 1672381 | 2021-08-31 | Montgomery | North Carolina | 37123 | 3811 | 99 |
1672382 | 1672382 | 2021-08-31 | Moore | North Carolina | 37125 | 11176 | 209 |
1672383 | 1672383 | 2021-08-31 | Nash | North Carolina | 37127 | 12953 | 201 |
1672384 | 1672384 | 2021-08-31 | New Hanover | North Carolina | 37129 | 24041 | 199 |
1672385 | 1672385 | 2021-08-31 | Northampton | North Carolina | 37131 | 2107 | 62 |
1672386 | 1672386 | 2021-08-31 | Onslow | North Carolina | 37133 | 22143 | 176 |
1672387 | 1672387 | 2021-08-31 | Orange | North Carolina | 37135 | 9964 | 102 |
1672388 | 1672388 | 2021-08-31 | Pamlico | North Carolina | 37137 | 1297 | 14 |
1672389 | 1672389 | 2021-08-31 | Pasquotank | North Carolina | 37139 | 3920 | 89 |
1672390 | 1672390 | 2021-08-31 | Pender | North Carolina | 37141 | 7157 | 78 |
1672391 | 1672391 | 2021-08-31 | Perquimans | North Carolina | 37143 | 1201 | 11 |
1672392 | 1672392 | 2021-08-31 | Person | North Carolina | 37145 | 4134 | 77 |
1672393 | 1672393 | 2021-08-31 | Pitt | North Carolina | 37147 | 24419 | 114 |
1672394 | 1672394 | 2021-08-31 | Polk | North Carolina | 37149 | 1788 | 33 |
1672395 | 1672395 | 2021-08-31 | Randolph | North Carolina | 37151 | 17532 | 256 |
1672396 | 1672396 | 2021-08-31 | Richmond | North Carolina | 37153 | 5949 | 116 |
1672397 | 1672397 | 2021-08-31 | Robeson | North Carolina | 37155 | 21563 | 315 |
1672398 | 1672398 | 2021-08-31 | Rockingham | North Carolina | 37157 | 9478 | 190 |
1672399 | 1672399 | 2021-08-31 | Rowan | North Carolina | 37159 | 21730 | 341 |
1672400 | 1672400 | 2021-08-31 | Rutherford | North Carolina | 37161 | 8925 | 243 |
1672401 | 1672401 | 2021-08-31 | Sampson | North Carolina | 37163 | 9649 | 117 |
1672402 | 1672402 | 2021-08-31 | Scotland | North Carolina | 37165 | 4710 | 96 |
1672403 | 1672403 | 2021-08-31 | Stanly | North Carolina | 37167 | 9450 | 150 |
1672404 | 1672404 | 2021-08-31 | Stokes | North Carolina | 37169 | 4936 | 83 |
1672405 | 1672405 | 2021-08-31 | Surry | North Carolina | 37171 | 9795 | 183 |
1672406 | 1672406 | 2021-08-31 | Swain | North Carolina | 37173 | 1493 | 21 |
1672407 | 1672407 | 2021-08-31 | Transylvania | North Carolina | 37175 | 3052 | 36 |
1672408 | 1672408 | 2021-08-31 | Tyrrell | North Carolina | 37177 | 439 | 6 |
1672409 | 1672409 | 2021-08-31 | Union | North Carolina | 37179 | 29700 | 251 |
1672410 | 1672410 | 2021-08-31 | Vance | North Carolina | 37181 | 5486 | 92 |
1672411 | 1672411 | 2021-08-31 | Wake | North Carolina | 37183 | 110694 | 780 |
1672412 | 1672412 | 2021-08-31 | Warren | North Carolina | 37185 | 1975 | 20 |
1672413 | 1672413 | 2021-08-31 | Washington | North Carolina | 37187 | 1302 | 32 |
1672414 | 1672414 | 2021-08-31 | Watauga | North Carolina | 37189 | 5532 | 33 |
1672415 | 1672415 | 2021-08-31 | Wayne | North Carolina | 37191 | 13337 | 247 |
1672416 | 1672416 | 2021-08-31 | Wilkes | North Carolina | 37193 | 8534 | 130 |
1672417 | 1672417 | 2021-08-31 | Wilson | North Carolina | 37195 | 11073 | 193 |
1672418 | 1672418 | 2021-08-31 | Yadkin | North Carolina | 37197 | 4886 | 57 |
1672419 | 1672419 | 2021-08-31 | Yancey | North Carolina | 37199 | 2197 | 28 |
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);