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-07-26 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 |
---|---|---|---|---|---|---|---|
1555379 | 1555379 | 2021-07-26 | Alamance | North Carolina | 37001 | 19300 | 288 |
1555380 | 1555380 | 2021-07-26 | Alexander | North Carolina | 37003 | 4526 | 85 |
1555381 | 1555381 | 2021-07-26 | Alleghany | North Carolina | 37005 | 1105 | 5 |
1555382 | 1555382 | 2021-07-26 | Anson | North Carolina | 37007 | 2678 | 57 |
1555383 | 1555383 | 2021-07-26 | Ashe | North Carolina | 37009 | 2293 | 45 |
1555384 | 1555384 | 2021-07-26 | Avery | North Carolina | 37011 | 2181 | 21 |
1555385 | 1555385 | 2021-07-26 | Beaufort | North Carolina | 37013 | 4855 | 103 |
1555386 | 1555386 | 2021-07-26 | Bertie | North Carolina | 37015 | 1808 | 45 |
1555387 | 1555387 | 2021-07-26 | Bladen | North Carolina | 37017 | 3692 | 53 |
1555388 | 1555388 | 2021-07-26 | Brunswick | North Carolina | 37019 | 9681 | 158 |
1555389 | 1555389 | 2021-07-26 | Buncombe | North Carolina | 37021 | 18538 | 337 |
1555390 | 1555390 | 2021-07-26 | Burke | North Carolina | 37023 | 10313 | 164 |
1555391 | 1555391 | 2021-07-26 | Cabarrus | North Carolina | 37025 | 23040 | 264 |
1555392 | 1555392 | 2021-07-26 | Caldwell | North Carolina | 37027 | 9636 | 111 |
1555393 | 1555393 | 2021-07-26 | Camden | North Carolina | 37029 | 701 | 6 |
1555394 | 1555394 | 2021-07-26 | Carteret | North Carolina | 37031 | 5341 | 57 |
1555395 | 1555395 | 2021-07-26 | Caswell | North Carolina | 37033 | 2237 | 30 |
1555396 | 1555396 | 2021-07-26 | Catawba | North Carolina | 37035 | 20169 | 311 |
1555397 | 1555397 | 2021-07-26 | Chatham | North Carolina | 37037 | 4874 | 89 |
1555398 | 1555398 | 2021-07-26 | Cherokee | North Carolina | 37039 | 2714 | 39 |
1555399 | 1555399 | 2021-07-26 | Chowan | North Carolina | 37041 | 1534 | 35 |
1555400 | 1555400 | 2021-07-26 | Clay | North Carolina | 37043 | 928 | 18 |
1555401 | 1555401 | 2021-07-26 | Cleveland | North Carolina | 37045 | 12029 | 228 |
1555402 | 1555402 | 2021-07-26 | Columbus | North Carolina | 37047 | 6753 | 155 |
1555403 | 1555403 | 2021-07-26 | Craven | North Carolina | 37049 | 9605 | 129 |
1555404 | 1555404 | 2021-07-26 | Cumberland | North Carolina | 37051 | 31855 | 330 |
1555405 | 1555405 | 2021-07-26 | Currituck | North Carolina | 37053 | 1618 | 16 |
1555406 | 1555406 | 2021-07-26 | Dare | North Carolina | 37055 | 2309 | 10 |
1555407 | 1555407 | 2021-07-26 | Davidson | North Carolina | 37057 | 17268 | 202 |
1555408 | 1555408 | 2021-07-26 | Davie | North Carolina | 37059 | 4272 | 42 |
1555409 | 1555409 | 2021-07-26 | Duplin | North Carolina | 37061 | 6582 | 142 |
1555410 | 1555410 | 2021-07-26 | Durham | North Carolina | 37063 | 26464 | 239 |
1555411 | 1555411 | 2021-07-26 | Edgecombe | North Carolina | 37065 | 5818 | 114 |
1555412 | 1555412 | 2021-07-26 | Forsyth | North Carolina | 37067 | 37584 | 430 |
1555413 | 1555413 | 2021-07-26 | Franklin | North Carolina | 37069 | 7143 | 55 |
1555414 | 1555414 | 2021-07-26 | Gaston | North Carolina | 37071 | 27619 | 445 |
1555415 | 1555415 | 2021-07-26 | Gates | North Carolina | 37073 | 756 | 13 |
1555416 | 1555416 | 2021-07-26 | Graham | North Carolina | 37075 | 698 | 13 |
1555417 | 1555417 | 2021-07-26 | Granville | North Carolina | 37077 | 6063 | 83 |
1555418 | 1555418 | 2021-07-26 | Greene | North Carolina | 37079 | 2478 | 48 |
1555419 | 1555419 | 2021-07-26 | Guilford | North Carolina | 37081 | 49432 | 726 |
1555420 | 1555420 | 2021-07-26 | Halifax | North Carolina | 37083 | 5772 | 116 |
1555421 | 1555421 | 2021-07-26 | Harnett | North Carolina | 37085 | 12474 | 183 |
1555422 | 1555422 | 2021-07-26 | Haywood | North Carolina | 37087 | 4619 | 99 |
1555423 | 1555423 | 2021-07-26 | Henderson | North Carolina | 37089 | 10566 | 165 |
1555424 | 1555424 | 2021-07-26 | Hertford | North Carolina | 37091 | 2129 | 64 |
1555425 | 1555425 | 2021-07-26 | Hoke | North Carolina | 37093 | 5118 | 56 |
1555426 | 1555426 | 2021-07-26 | Hyde | North Carolina | 37095 | 673 | 9 |
1555427 | 1555427 | 2021-07-26 | Iredell | North Carolina | 37097 | 19651 | 236 |
1555428 | 1555428 | 2021-07-26 | Jackson | North Carolina | 37099 | 3705 | 56 |
1555429 | 1555429 | 2021-07-26 | Johnston | North Carolina | 37101 | 22996 | 240 |
1555430 | 1555430 | 2021-07-26 | Jones | North Carolina | 37103 | 911 | 28 |
1555431 | 1555431 | 2021-07-26 | Lee | North Carolina | 37105 | 6322 | 83 |
1555432 | 1555432 | 2021-07-26 | Lenoir | North Carolina | 37107 | 6338 | 128 |
1555433 | 1555433 | 2021-07-26 | Lincoln | North Carolina | 37109 | 10535 | 86 |
1555434 | 1555434 | 2021-07-26 | Macon | North Carolina | 37113 | 3193 | 41 |
1555435 | 1555435 | 2021-07-26 | Madison | North Carolina | 37115 | 1641 | 43 |
1555436 | 1555436 | 2021-07-26 | Martin | North Carolina | 37117 | 2396 | 46 |
1555437 | 1555437 | 2021-07-26 | McDowell | North Carolina | 37111 | 5375 | 63 |
1555438 | 1555438 | 2021-07-26 | Mecklenburg | North Carolina | 37119 | 117724 | 988 |
1555439 | 1555439 | 2021-07-26 | Mitchell | North Carolina | 37121 | 1479 | 16 |
1555440 | 1555440 | 2021-07-26 | Montgomery | North Carolina | 37123 | 3432 | 97 |
1555441 | 1555441 | 2021-07-26 | Moore | North Carolina | 37125 | 9304 | 195 |
1555442 | 1555442 | 2021-07-26 | Nash | North Carolina | 37127 | 11807 | 200 |
1555443 | 1555443 | 2021-07-26 | New Hanover | North Carolina | 37129 | 19888 | 176 |
1555444 | 1555444 | 2021-07-26 | Northampton | North Carolina | 37131 | 1922 | 61 |
1555445 | 1555445 | 2021-07-26 | Onslow | North Carolina | 37133 | 18545 | 156 |
1555446 | 1555446 | 2021-07-26 | Orange | North Carolina | 37135 | 8736 | 101 |
1555447 | 1555447 | 2021-07-26 | Pamlico | North Carolina | 37137 | 1138 | 13 |
1555448 | 1555448 | 2021-07-26 | Pasquotank | North Carolina | 37139 | 3480 | 87 |
1555449 | 1555449 | 2021-07-26 | Pender | North Carolina | 37141 | 5752 | 69 |
1555450 | 1555450 | 2021-07-26 | Perquimans | North Carolina | 37143 | 1052 | 11 |
1555451 | 1555451 | 2021-07-26 | Person | North Carolina | 37145 | 3604 | 71 |
1555452 | 1555452 | 2021-07-26 | Pitt | North Carolina | 37147 | 21050 | 96 |
1555453 | 1555453 | 2021-07-26 | Polk | North Carolina | 37149 | 1533 | 31 |
1555454 | 1555454 | 2021-07-26 | Randolph | North Carolina | 37151 | 15569 | 234 |
1555455 | 1555455 | 2021-07-26 | Richmond | North Carolina | 37153 | 5075 | 99 |
1555456 | 1555456 | 2021-07-26 | Robeson | North Carolina | 37155 | 17598 | 279 |
1555457 | 1555457 | 2021-07-26 | Rockingham | North Carolina | 37157 | 8256 | 169 |
1555458 | 1555458 | 2021-07-26 | Rowan | North Carolina | 37159 | 17648 | 314 |
1555459 | 1555459 | 2021-07-26 | Rutherford | North Carolina | 37161 | 7633 | 220 |
1555460 | 1555460 | 2021-07-26 | Sampson | North Carolina | 37163 | 8329 | 114 |
1555461 | 1555461 | 2021-07-26 | Scotland | North Carolina | 37165 | 4044 | 89 |
1555462 | 1555462 | 2021-07-26 | Stanly | North Carolina | 37167 | 8072 | 138 |
1555463 | 1555463 | 2021-07-26 | Stokes | North Carolina | 37169 | 4316 | 81 |
1555464 | 1555464 | 2021-07-26 | Surry | North Carolina | 37171 | 8611 | 173 |
1555465 | 1555465 | 2021-07-26 | Swain | North Carolina | 37173 | 1226 | 18 |
1555466 | 1555466 | 2021-07-26 | Transylvania | North Carolina | 37175 | 2476 | 33 |
1555467 | 1555467 | 2021-07-26 | Tyrrell | North Carolina | 37177 | 330 | 6 |
1555468 | 1555468 | 2021-07-26 | Union | North Carolina | 37179 | 25570 | 228 |
1555469 | 1555469 | 2021-07-26 | Vance | North Carolina | 37181 | 5026 | 90 |
1555470 | 1555470 | 2021-07-26 | Wake | North Carolina | 37183 | 92186 | 743 |
1555471 | 1555471 | 2021-07-26 | Warren | North Carolina | 37185 | 1829 | 20 |
1555472 | 1555472 | 2021-07-26 | Washington | North Carolina | 37187 | 1146 | 32 |
1555473 | 1555473 | 2021-07-26 | Watauga | North Carolina | 37189 | 5060 | 33 |
1555474 | 1555474 | 2021-07-26 | Wayne | North Carolina | 37191 | 11795 | 245 |
1555475 | 1555475 | 2021-07-26 | Wilkes | North Carolina | 37193 | 7089 | 117 |
1555476 | 1555476 | 2021-07-26 | Wilson | North Carolina | 37195 | 10069 | 181 |
1555477 | 1555477 | 2021-07-26 | Yadkin | North Carolina | 37197 | 4207 | 55 |
1555478 | 1555478 | 2021-07-26 | Yancey | North Carolina | 37199 | 1662 | 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);