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-06-10 and state = "North Carolina" sorted by cases
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 |
---|---|---|---|---|---|---|---|
226466 | 226466 | 2020-06-10 | Hyde | North Carolina | 37095 | 2 | 0 |
226433 | 226433 | 2020-06-10 | Camden | North Carolina | 37029 | 3 | 0 |
226475 | 226475 | 2020-06-10 | Madison | North Carolina | 37115 | 3 | 0 |
226507 | 226507 | 2020-06-10 | Tyrrell | North Carolina | 37177 | 4 | 0 |
226424 | 226424 | 2020-06-10 | Avery | North Carolina | 37011 | 6 | 0 |
226456 | 226456 | 2020-06-10 | Graham | North Carolina | 37075 | 6 | 0 |
226440 | 226440 | 2020-06-10 | Clay | North Carolina | 37043 | 8 | 0 |
226479 | 226479 | 2020-06-10 | Mitchell | North Carolina | 37121 | 13 | 0 |
226487 | 226487 | 2020-06-10 | Pamlico | North Carolina | 37137 | 13 | 0 |
226445 | 226445 | 2020-06-10 | Currituck | North Carolina | 37053 | 15 | 0 |
226506 | 226506 | 2020-06-10 | Transylvania | North Carolina | 37175 | 16 | 1 |
226439 | 226439 | 2020-06-10 | Chowan | North Carolina | 37041 | 18 | 0 |
226438 | 226438 | 2020-06-10 | Cherokee | North Carolina | 37039 | 21 | 1 |
226446 | 226446 | 2020-06-10 | Dare | North Carolina | 37055 | 22 | 1 |
226518 | 226518 | 2020-06-10 | Yancey | North Carolina | 37199 | 23 | 0 |
226455 | 226455 | 2020-06-10 | Gates | North Carolina | 37073 | 24 | 1 |
226470 | 226470 | 2020-06-10 | Jones | North Carolina | 37103 | 26 | 3 |
226490 | 226490 | 2020-06-10 | Perquimans | North Carolina | 37143 | 26 | 2 |
226421 | 226421 | 2020-06-10 | Alleghany | North Carolina | 37005 | 30 | 0 |
226505 | 226505 | 2020-06-10 | Swain | North Carolina | 37173 | 32 | 0 |
226512 | 226512 | 2020-06-10 | Washington | North Carolina | 37187 | 32 | 3 |
226513 | 226513 | 2020-06-10 | Watauga | North Carolina | 37189 | 39 | 0 |
226423 | 226423 | 2020-06-10 | Ashe | North Carolina | 37009 | 42 | 1 |
226434 | 226434 | 2020-06-10 | Carteret | North Carolina | 37031 | 42 | 3 |
226420 | 226420 | 2020-06-10 | Alexander | North Carolina | 37003 | 43 | 0 |
226425 | 226425 | 2020-06-10 | Beaufort | North Carolina | 37013 | 43 | 0 |
226493 | 226493 | 2020-06-10 | Polk | North Carolina | 37149 | 51 | 4 |
226468 | 226468 | 2020-06-10 | Jackson | North Carolina | 37099 | 55 | 1 |
226462 | 226462 | 2020-06-10 | Haywood | North Carolina | 37087 | 63 | 0 |
226491 | 226491 | 2020-06-10 | Person | North Carolina | 37145 | 65 | 1 |
226422 | 226422 | 2020-06-10 | Anson | North Carolina | 37007 | 78 | 1 |
226476 | 226476 | 2020-06-10 | Martin | North Carolina | 37117 | 78 | 4 |
226503 | 226503 | 2020-06-10 | Stokes | North Carolina | 37169 | 89 | 0 |
226435 | 226435 | 2020-06-10 | Caswell | North Carolina | 37033 | 98 | 1 |
226501 | 226501 | 2020-06-10 | Scotland | North Carolina | 37165 | 99 | 1 |
226458 | 226458 | 2020-06-10 | Greene | North Carolina | 37079 | 106 | 2 |
226477 | 226477 | 2020-06-10 | McDowell | North Carolina | 37111 | 106 | 1 |
226473 | 226473 | 2020-06-10 | Lincoln | North Carolina | 37109 | 108 | 0 |
226511 | 226511 | 2020-06-10 | Warren | North Carolina | 37185 | 113 | 2 |
226489 | 226489 | 2020-06-10 | Pender | North Carolina | 37141 | 117 | 1 |
226497 | 226497 | 2020-06-10 | Rockingham | North Carolina | 37157 | 118 | 2 |
226488 | 226488 | 2020-06-10 | Pasquotank | North Carolina | 37139 | 120 | 14 |
226502 | 226502 | 2020-06-10 | Stanly | North Carolina | 37167 | 124 | 4 |
226448 | 226448 | 2020-06-10 | Davie | North Carolina | 37059 | 126 | 2 |
226441 | 226441 | 2020-06-10 | Cleveland | North Carolina | 37045 | 127 | 2 |
226426 | 226426 | 2020-06-10 | Bertie | North Carolina | 37015 | 134 | 4 |
226485 | 226485 | 2020-06-10 | Onslow | North Carolina | 37133 | 136 | 2 |
226464 | 226464 | 2020-06-10 | Hertford | North Carolina | 37091 | 140 | 7 |
226474 | 226474 | 2020-06-10 | Macon | North Carolina | 37113 | 158 | 1 |
226484 | 226484 | 2020-06-10 | Northampton | North Carolina | 37131 | 160 | 14 |
226427 | 226427 | 2020-06-10 | Bladen | North Carolina | 37017 | 164 | 2 |
226480 | 226480 | 2020-06-10 | Montgomery | North Carolina | 37123 | 170 | 5 |
226495 | 226495 | 2020-06-10 | Richmond | North Carolina | 37153 | 188 | 4 |
226428 | 226428 | 2020-06-10 | Brunswick | North Carolina | 37019 | 196 | 5 |
226453 | 226453 | 2020-06-10 | Franklin | North Carolina | 37069 | 197 | 21 |
226499 | 226499 | 2020-06-10 | Rutherford | North Carolina | 37161 | 202 | 7 |
226460 | 226460 | 2020-06-10 | Halifax | North Carolina | 37083 | 217 | 1 |
226432 | 226432 | 2020-06-10 | Caldwell | North Carolina | 37027 | 219 | 3 |
226517 | 226517 | 2020-06-10 | Yadkin | North Carolina | 37197 | 225 | 4 |
226451 | 226451 | 2020-06-10 | Edgecombe | North Carolina | 37065 | 231 | 9 |
226443 | 226443 | 2020-06-10 | Craven | North Carolina | 37049 | 241 | 5 |
226482 | 226482 | 2020-06-10 | Nash | North Carolina | 37127 | 248 | 4 |
226472 | 226472 | 2020-06-10 | Lenoir | North Carolina | 37107 | 261 | 8 |
226481 | 226481 | 2020-06-10 | Moore | North Carolina | 37125 | 266 | 11 |
226483 | 226483 | 2020-06-10 | New Hanover | North Carolina | 37129 | 281 | 5 |
226465 | 226465 | 2020-06-10 | Hoke | North Carolina | 37093 | 288 | 1 |
226504 | 226504 | 2020-06-10 | Surry | North Carolina | 37171 | 294 | 2 |
226436 | 226436 | 2020-06-10 | Catawba | North Carolina | 37035 | 326 | 11 |
226461 | 226461 | 2020-06-10 | Harnett | North Carolina | 37085 | 352 | 30 |
226467 | 226467 | 2020-06-10 | Iredell | North Carolina | 37097 | 363 | 5 |
226509 | 226509 | 2020-06-10 | Vance | North Carolina | 37181 | 377 | 28 |
226442 | 226442 | 2020-06-10 | Columbus | North Carolina | 37047 | 379 | 28 |
226454 | 226454 | 2020-06-10 | Gaston | North Carolina | 37071 | 392 | 8 |
226463 | 226463 | 2020-06-10 | Henderson | North Carolina | 37089 | 403 | 49 |
226429 | 226429 | 2020-06-10 | Buncombe | North Carolina | 37021 | 408 | 34 |
226486 | 226486 | 2020-06-10 | Orange | North Carolina | 37135 | 415 | 40 |
226492 | 226492 | 2020-06-10 | Pitt | North Carolina | 37147 | 416 | 2 |
226516 | 226516 | 2020-06-10 | Wilson | North Carolina | 37195 | 456 | 13 |
226515 | 226515 | 2020-06-10 | Wilkes | North Carolina | 37193 | 513 | 6 |
226419 | 226419 | 2020-06-10 | Alamance | North Carolina | 37001 | 544 | 23 |
226447 | 226447 | 2020-06-10 | Davidson | North Carolina | 37057 | 544 | 12 |
226471 | 226471 | 2020-06-10 | Lee | North Carolina | 37105 | 554 | 4 |
226430 | 226430 | 2020-06-10 | Burke | North Carolina | 37023 | 595 | 16 |
226457 | 226457 | 2020-06-10 | Granville | North Carolina | 37077 | 610 | 14 |
226431 | 226431 | 2020-06-10 | Cabarrus | North Carolina | 37025 | 614 | 23 |
226508 | 226508 | 2020-06-10 | Union | North Carolina | 37179 | 616 | 22 |
226500 | 226500 | 2020-06-10 | Sampson | North Carolina | 37163 | 627 | 4 |
226469 | 226469 | 2020-06-10 | Johnston | North Carolina | 37101 | 677 | 23 |
226437 | 226437 | 2020-06-10 | Chatham | North Carolina | 37037 | 749 | 37 |
226498 | 226498 | 2020-06-10 | Rowan | North Carolina | 37159 | 801 | 39 |
226444 | 226444 | 2020-06-10 | Cumberland | North Carolina | 37051 | 811 | 30 |
226494 | 226494 | 2020-06-10 | Randolph | North Carolina | 37151 | 842 | 17 |
226496 | 226496 | 2020-06-10 | Robeson | North Carolina | 37155 | 1001 | 31 |
226449 | 226449 | 2020-06-10 | Duplin | North Carolina | 37061 | 1072 | 20 |
226514 | 226514 | 2020-06-10 | Wayne | North Carolina | 37191 | 1367 | 20 |
226459 | 226459 | 2020-06-10 | Guilford | North Carolina | 37081 | 1853 | 91 |
226452 | 226452 | 2020-06-10 | Forsyth | North Carolina | 37067 | 1910 | 18 |
226450 | 226450 | 2020-06-10 | Durham | North Carolina | 37063 | 2307 | 53 |
226510 | 226510 | 2020-06-10 | Wake | North Carolina | 37183 | 2541 | 42 |
226478 | 226478 | 2020-06-10 | Mecklenburg | North Carolina | 37119 | 5861 | 119 |
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);