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-02-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 |
---|---|---|---|---|---|---|---|
1068391 | 1068391 | 2021-02-26 | Alamance | North Carolina | 37001 | 15615 | 223 |
1068392 | 1068392 | 2021-02-26 | Alexander | North Carolina | 37003 | 3895 | 74 |
1068393 | 1068393 | 2021-02-26 | Alleghany | North Carolina | 37005 | 909 | 4 |
1068394 | 1068394 | 2021-02-26 | Anson | North Carolina | 37007 | 2270 | 52 |
1068395 | 1068395 | 2021-02-26 | Ashe | North Carolina | 37009 | 1860 | 40 |
1068396 | 1068396 | 2021-02-26 | Avery | North Carolina | 37011 | 1811 | 20 |
1068397 | 1068397 | 2021-02-26 | Beaufort | North Carolina | 37013 | 4226 | 80 |
1068398 | 1068398 | 2021-02-26 | Bertie | North Carolina | 37015 | 1631 | 41 |
1068399 | 1068399 | 2021-02-26 | Bladen | North Carolina | 37017 | 2922 | 40 |
1068400 | 1068400 | 2021-02-26 | Brunswick | North Carolina | 37019 | 7952 | 133 |
1068401 | 1068401 | 2021-02-26 | Buncombe | North Carolina | 37021 | 15388 | 300 |
1068402 | 1068402 | 2021-02-26 | Burke | North Carolina | 37023 | 9191 | 138 |
1068403 | 1068403 | 2021-02-26 | Cabarrus | North Carolina | 37025 | 18397 | 233 |
1068404 | 1068404 | 2021-02-26 | Caldwell | North Carolina | 37027 | 8594 | 67 |
1068405 | 1068405 | 2021-02-26 | Camden | North Carolina | 37029 | 578 | 5 |
1068406 | 1068406 | 2021-02-26 | Carteret | North Carolina | 37031 | 4434 | 44 |
1068407 | 1068407 | 2021-02-26 | Caswell | North Carolina | 37033 | 1944 | 23 |
1068408 | 1068408 | 2021-02-26 | Catawba | North Carolina | 37035 | 17370 | 277 |
1068409 | 1068409 | 2021-02-26 | Chatham | North Carolina | 37037 | 4123 | 75 |
1068410 | 1068410 | 2021-02-26 | Cherokee | North Carolina | 37039 | 2100 | 19 |
1068411 | 1068411 | 2021-02-26 | Chowan | North Carolina | 37041 | 1359 | 22 |
1068412 | 1068412 | 2021-02-26 | Clay | North Carolina | 37043 | 655 | 18 |
1068413 | 1068413 | 2021-02-26 | Cleveland | North Carolina | 37045 | 10216 | 215 |
1068414 | 1068414 | 2021-02-26 | Columbus | North Carolina | 37047 | 5795 | 142 |
1068415 | 1068415 | 2021-02-26 | Craven | North Carolina | 37049 | 8249 | 114 |
1068416 | 1068416 | 2021-02-26 | Cumberland | North Carolina | 37051 | 23990 | 274 |
1068417 | 1068417 | 2021-02-26 | Currituck | North Carolina | 37053 | 1366 | 15 |
1068418 | 1068418 | 2021-02-26 | Dare | North Carolina | 37055 | 1849 | 8 |
1068419 | 1068419 | 2021-02-26 | Davidson | North Carolina | 37057 | 14556 | 156 |
1068420 | 1068420 | 2021-02-26 | Davie | North Carolina | 37059 | 3525 | 28 |
1068421 | 1068421 | 2021-02-26 | Duplin | North Carolina | 37061 | 5659 | 127 |
1068422 | 1068422 | 2021-02-26 | Durham | North Carolina | 37063 | 22005 | 208 |
1068423 | 1068423 | 2021-02-26 | Edgecombe | North Carolina | 37065 | 4620 | 99 |
1068424 | 1068424 | 2021-02-26 | Forsyth | North Carolina | 37067 | 31647 | 345 |
1068425 | 1068425 | 2021-02-26 | Franklin | North Carolina | 37069 | 5357 | 43 |
1068426 | 1068426 | 2021-02-26 | Gaston | North Carolina | 37071 | 23620 | 375 |
1068427 | 1068427 | 2021-02-26 | Gates | North Carolina | 37073 | 673 | 12 |
1068428 | 1068428 | 2021-02-26 | Graham | North Carolina | 37075 | 557 | 12 |
1068429 | 1068429 | 2021-02-26 | Granville | North Carolina | 37077 | 5173 | 76 |
1068430 | 1068430 | 2021-02-26 | Greene | North Carolina | 37079 | 2129 | 39 |
1068431 | 1068431 | 2021-02-26 | Guilford | North Carolina | 37081 | 39633 | 552 |
1068432 | 1068432 | 2021-02-26 | Halifax | North Carolina | 37083 | 4992 | 97 |
1068433 | 1068433 | 2021-02-26 | Harnett | North Carolina | 37085 | 9568 | 151 |
1068434 | 1068434 | 2021-02-26 | Haywood | North Carolina | 37087 | 3830 | 86 |
1068435 | 1068435 | 2021-02-26 | Henderson | North Carolina | 37089 | 8764 | 140 |
1068436 | 1068436 | 2021-02-26 | Hertford | North Carolina | 37091 | 1943 | 60 |
1068437 | 1068437 | 2021-02-26 | Hoke | North Carolina | 37093 | 4098 | 54 |
1068438 | 1068438 | 2021-02-26 | Hyde | North Carolina | 37095 | 623 | 8 |
1068439 | 1068439 | 2021-02-26 | Iredell | North Carolina | 37097 | 16335 | 190 |
1068440 | 1068440 | 2021-02-26 | Jackson | North Carolina | 37099 | 3310 | 48 |
1068441 | 1068441 | 2021-02-26 | Johnston | North Carolina | 37101 | 17878 | 190 |
1068442 | 1068442 | 2021-02-26 | Jones | North Carolina | 37103 | 711 | 16 |
1068443 | 1068443 | 2021-02-26 | Lee | North Carolina | 37105 | 5444 | 66 |
1068444 | 1068444 | 2021-02-26 | Lenoir | North Carolina | 37107 | 5408 | 105 |
1068445 | 1068445 | 2021-02-26 | Lincoln | North Carolina | 37109 | 8749 | 71 |
1068446 | 1068446 | 2021-02-26 | Macon | North Carolina | 37113 | 2554 | 28 |
1068447 | 1068447 | 2021-02-26 | Madison | North Carolina | 37115 | 1337 | 36 |
1068448 | 1068448 | 2021-02-26 | Martin | North Carolina | 37117 | 2061 | 37 |
1068449 | 1068449 | 2021-02-26 | McDowell | North Carolina | 37111 | 4791 | 61 |
1068450 | 1068450 | 2021-02-26 | Mecklenburg | North Carolina | 37119 | 96252 | 868 |
1068451 | 1068451 | 2021-02-26 | Mitchell | North Carolina | 37121 | 1239 | 16 |
1068452 | 1068452 | 2021-02-26 | Montgomery | North Carolina | 37123 | 3048 | 86 |
1068453 | 1068453 | 2021-02-26 | Moore | North Carolina | 37125 | 7918 | 172 |
1068454 | 1068454 | 2021-02-26 | Nash | North Carolina | 37127 | 9685 | 167 |
1068455 | 1068455 | 2021-02-26 | New Hanover | North Carolina | 37129 | 16024 | 149 |
1068456 | 1068456 | 2021-02-26 | Northampton | North Carolina | 37131 | 1679 | 28 |
1068457 | 1068457 | 2021-02-26 | Onslow | North Carolina | 37133 | 14545 | 133 |
1068458 | 1068458 | 2021-02-26 | Orange | North Carolina | 37135 | 7669 | 93 |
1068459 | 1068459 | 2021-02-26 | Pamlico | North Carolina | 37137 | 946 | 9 |
1068460 | 1068460 | 2021-02-26 | Pasquotank | North Carolina | 37139 | 3047 | 77 |
1068461 | 1068461 | 2021-02-26 | Pender | North Carolina | 37141 | 4633 | 55 |
1068462 | 1068462 | 2021-02-26 | Perquimans | North Carolina | 37143 | 894 | 8 |
1068463 | 1068463 | 2021-02-26 | Person | North Carolina | 37145 | 2967 | 64 |
1068464 | 1068464 | 2021-02-26 | Pitt | North Carolina | 37147 | 17387 | 77 |
1068465 | 1068465 | 2021-02-26 | Polk | North Carolina | 37149 | 1353 | 27 |
1068466 | 1068466 | 2021-02-26 | Randolph | North Carolina | 37151 | 13131 | 200 |
1068467 | 1068467 | 2021-02-26 | Richmond | North Carolina | 37153 | 4171 | 89 |
1068468 | 1068468 | 2021-02-26 | Robeson | North Carolina | 37155 | 15124 | 204 |
1068469 | 1068469 | 2021-02-26 | Rockingham | North Carolina | 37157 | 6806 | 61 |
1068470 | 1068470 | 2021-02-26 | Rowan | North Carolina | 37159 | 14786 | 277 |
1068471 | 1068471 | 2021-02-26 | Rutherford | North Carolina | 37161 | 6724 | 195 |
1068472 | 1068472 | 2021-02-26 | Sampson | North Carolina | 37163 | 6676 | 92 |
1068473 | 1068473 | 2021-02-26 | Scotland | North Carolina | 37165 | 3470 | 75 |
1068474 | 1068474 | 2021-02-26 | Stanly | North Carolina | 37167 | 6782 | 111 |
1068475 | 1068475 | 2021-02-26 | Stokes | North Carolina | 37169 | 3637 | 66 |
1068476 | 1068476 | 2021-02-26 | Surry | North Carolina | 37171 | 7348 | 140 |
1068477 | 1068477 | 2021-02-26 | Swain | North Carolina | 37173 | 1155 | 16 |
1068478 | 1068478 | 2021-02-26 | Transylvania | North Carolina | 37175 | 1897 | 27 |
1068479 | 1068479 | 2021-02-26 | Tyrrell | North Carolina | 37177 | 301 | 6 |
1068480 | 1068480 | 2021-02-26 | Union | North Carolina | 37179 | 20606 | 196 |
1068481 | 1068481 | 2021-02-26 | Vance | North Carolina | 37181 | 4272 | 81 |
1068482 | 1068482 | 2021-02-26 | Wake | North Carolina | 37183 | 74709 | 521 |
1068483 | 1068483 | 2021-02-26 | Warren | North Carolina | 37185 | 1582 | 18 |
1068484 | 1068484 | 2021-02-26 | Washington | North Carolina | 37187 | 981 | 30 |
1068485 | 1068485 | 2021-02-26 | Watauga | North Carolina | 37189 | 3916 | 29 |
1068486 | 1068486 | 2021-02-26 | Wayne | North Carolina | 37191 | 10216 | 221 |
1068487 | 1068487 | 2021-02-26 | Wilkes | North Carolina | 37193 | 5970 | 103 |
1068488 | 1068488 | 2021-02-26 | Wilson | North Carolina | 37195 | 8355 | 147 |
1068489 | 1068489 | 2021-02-26 | Yadkin | North Carolina | 37197 | 3621 | 46 |
1068490 | 1068490 | 2021-02-26 | Yancey | North Carolina | 37199 | 1442 | 24 |
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);