ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-12-11" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
818487 | 818487 | 2020-12-11 | Alamance | North Carolina | 37001 | 8320 | 112 |
818488 | 818488 | 2020-12-11 | Alexander | North Carolina | 37003 | 1974 | 19 |
818489 | 818489 | 2020-12-11 | Alleghany | North Carolina | 37005 | 458 | 1 |
818490 | 818490 | 2020-12-11 | Anson | North Carolina | 37007 | 1073 | 18 |
818491 | 818491 | 2020-12-11 | Ashe | North Carolina | 37009 | 956 | 3 |
818492 | 818492 | 2020-12-11 | Avery | North Carolina | 37011 | 1137 | 11 |
818493 | 818493 | 2020-12-11 | Beaufort | North Carolina | 37013 | 1967 | 56 |
818494 | 818494 | 2020-12-11 | Bertie | North Carolina | 37015 | 1015 | 26 |
818495 | 818495 | 2020-12-11 | Bladen | North Carolina | 37017 | 1522 | 21 |
818496 | 818496 | 2020-12-11 | Brunswick | North Carolina | 37019 | 3525 | 66 |
818497 | 818497 | 2020-12-11 | Buncombe | North Carolina | 37021 | 6622 | 143 |
818498 | 818498 | 2020-12-11 | Burke | North Carolina | 37023 | 4899 | 70 |
818499 | 818499 | 2020-12-11 | Cabarrus | North Carolina | 37025 | 8399 | 111 |
818500 | 818500 | 2020-12-11 | Caldwell | North Carolina | 37027 | 4252 | 25 |
818501 | 818501 | 2020-12-11 | Camden | North Carolina | 37029 | 222 | 4 |
818502 | 818502 | 2020-12-11 | Carteret | North Carolina | 37031 | 2109 | 16 |
818503 | 818503 | 2020-12-11 | Caswell | North Carolina | 37033 | 937 | 8 |
818504 | 818504 | 2020-12-11 | Catawba | North Carolina | 37035 | 8431 | 105 |
818505 | 818505 | 2020-12-11 | Chatham | North Carolina | 37037 | 2531 | 65 |
818506 | 818506 | 2020-12-11 | Cherokee | North Carolina | 37039 | 1036 | 15 |
818507 | 818507 | 2020-12-11 | Chowan | North Carolina | 37041 | 699 | 19 |
818508 | 818508 | 2020-12-11 | Clay | North Carolina | 37043 | 304 | 5 |
818509 | 818509 | 2020-12-11 | Cleveland | North Carolina | 37045 | 5093 | 116 |
818510 | 818510 | 2020-12-11 | Columbus | North Carolina | 37047 | 2982 | 74 |
818511 | 818511 | 2020-12-11 | Craven | North Carolina | 37049 | 3828 | 76 |
818512 | 818512 | 2020-12-11 | Cumberland | North Carolina | 37051 | 10882 | 125 |
818513 | 818513 | 2020-12-11 | Currituck | North Carolina | 37053 | 456 | 6 |
818514 | 818514 | 2020-12-11 | Dare | North Carolina | 37055 | 764 | 4 |
818515 | 818515 | 2020-12-11 | Davidson | North Carolina | 37057 | 6395 | 58 |
818516 | 818516 | 2020-12-11 | Davie | North Carolina | 37059 | 1545 | 13 |
818517 | 818517 | 2020-12-11 | Duplin | North Carolina | 37061 | 3688 | 63 |
818518 | 818518 | 2020-12-11 | Durham | North Carolina | 37063 | 12431 | 128 |
818519 | 818519 | 2020-12-11 | Edgecombe | North Carolina | 37065 | 2820 | 76 |
818520 | 818520 | 2020-12-11 | Forsyth | North Carolina | 37067 | 16015 | 178 |
818521 | 818521 | 2020-12-11 | Franklin | North Carolina | 37069 | 2367 | 36 |
818522 | 818522 | 2020-12-11 | Gaston | North Carolina | 37071 | 12030 | 193 |
818523 | 818523 | 2020-12-11 | Gates | North Carolina | 37073 | 278 | 10 |
818524 | 818524 | 2020-12-11 | Graham | North Carolina | 37075 | 304 | 11 |
818525 | 818525 | 2020-12-11 | Granville | North Carolina | 37077 | 2923 | 60 |
818526 | 818526 | 2020-12-11 | Greene | North Carolina | 37079 | 1322 | 28 |
818527 | 818527 | 2020-12-11 | Guilford | North Carolina | 37081 | 19595 | 276 |
818528 | 818528 | 2020-12-11 | Halifax | North Carolina | 37083 | 2263 | 40 |
818529 | 818529 | 2020-12-11 | Harnett | North Carolina | 37085 | 4710 | 83 |
818530 | 818530 | 2020-12-11 | Haywood | North Carolina | 37087 | 1522 | 45 |
818531 | 818531 | 2020-12-11 | Henderson | North Carolina | 37089 | 3650 | 88 |
818532 | 818532 | 2020-12-11 | Hertford | North Carolina | 37091 | 1116 | 42 |
818533 | 818533 | 2020-12-11 | Hoke | North Carolina | 37093 | 2260 | 34 |
818534 | 818534 | 2020-12-11 | Hyde | North Carolina | 37095 | 197 | 5 |
818535 | 818535 | 2020-12-11 | Iredell | North Carolina | 37097 | 6982 | 61 |
818536 | 818536 | 2020-12-11 | Jackson | North Carolina | 37099 | 1680 | 10 |
818537 | 818537 | 2020-12-11 | Johnston | North Carolina | 37101 | 9291 | 86 |
818538 | 818538 | 2020-12-11 | Jones | North Carolina | 37103 | 317 | 15 |
818539 | 818539 | 2020-12-11 | Lee | North Carolina | 37105 | 2800 | 35 |
818540 | 818540 | 2020-12-11 | Lenoir | North Carolina | 37107 | 2601 | 58 |
818541 | 818541 | 2020-12-11 | Lincoln | North Carolina | 37109 | 4138 | 20 |
818542 | 818542 | 2020-12-11 | Macon | North Carolina | 37113 | 1032 | 9 |
818543 | 818543 | 2020-12-11 | Madison | North Carolina | 37115 | 638 | 17 |
818544 | 818544 | 2020-12-11 | Martin | North Carolina | 37117 | 966 | 21 |
818545 | 818545 | 2020-12-11 | McDowell | North Carolina | 37111 | 2324 | 36 |
818546 | 818546 | 2020-12-11 | Mecklenburg | North Carolina | 37119 | 49955 | 485 |
818547 | 818547 | 2020-12-11 | Mitchell | North Carolina | 37121 | 661 | 6 |
818548 | 818548 | 2020-12-11 | Montgomery | North Carolina | 37123 | 1570 | 43 |
818549 | 818549 | 2020-12-11 | Moore | North Carolina | 37125 | 3635 | 69 |
818550 | 818550 | 2020-12-11 | Nash | North Carolina | 37127 | 4976 | 113 |
818551 | 818551 | 2020-12-11 | New Hanover | North Carolina | 37129 | 7987 | 66 |
818552 | 818552 | 2020-12-11 | Northampton | North Carolina | 37131 | 906 | 27 |
818553 | 818553 | 2020-12-11 | Onslow | North Carolina | 37133 | 6708 | 47 |
818554 | 818554 | 2020-12-11 | Orange | North Carolina | 37135 | 4316 | 62 |
818555 | 818555 | 2020-12-11 | Pamlico | North Carolina | 37137 | 458 | 4 |
818556 | 818556 | 2020-12-11 | Pasquotank | North Carolina | 37139 | 1266 | 35 |
818557 | 818557 | 2020-12-11 | Pender | North Carolina | 37141 | 2162 | 18 |
818558 | 818558 | 2020-12-11 | Perquimans | North Carolina | 37143 | 397 | 4 |
818559 | 818559 | 2020-12-11 | Person | North Carolina | 37145 | 1208 | 14 |
818560 | 818560 | 2020-12-11 | Pitt | North Carolina | 37147 | 9208 | 59 |
818561 | 818561 | 2020-12-11 | Polk | North Carolina | 37149 | 546 | 13 |
818562 | 818562 | 2020-12-11 | Randolph | North Carolina | 37151 | 6377 | 101 |
818563 | 818563 | 2020-12-11 | Richmond | North Carolina | 37153 | 2204 | 40 |
818564 | 818564 | 2020-12-11 | Robeson | North Carolina | 37155 | 8144 | 114 |
818565 | 818565 | 2020-12-11 | Rockingham | North Carolina | 37157 | 3566 | 23 |
818566 | 818566 | 2020-12-11 | Rowan | North Carolina | 37159 | 6798 | 149 |
818567 | 818567 | 2020-12-11 | Rutherford | North Carolina | 37161 | 3099 | 94 |
818568 | 818568 | 2020-12-11 | Sampson | North Carolina | 37163 | 4129 | 53 |
818569 | 818569 | 2020-12-11 | Scotland | North Carolina | 37165 | 2186 | 45 |
818570 | 818570 | 2020-12-11 | Stanly | North Carolina | 37167 | 3436 | 78 |
818571 | 818571 | 2020-12-11 | Stokes | North Carolina | 37169 | 1432 | 22 |
818572 | 818572 | 2020-12-11 | Surry | North Carolina | 37171 | 3322 | 50 |
818573 | 818573 | 2020-12-11 | Swain | North Carolina | 37173 | 471 | 5 |
818574 | 818574 | 2020-12-11 | Transylvania | North Carolina | 37175 | 656 | 9 |
818575 | 818575 | 2020-12-11 | Tyrrell | North Carolina | 37177 | 157 | 3 |
818576 | 818576 | 2020-12-11 | Union | North Carolina | 37179 | 9348 | 84 |
818577 | 818577 | 2020-12-11 | Vance | North Carolina | 37181 | 2096 | 61 |
818578 | 818578 | 2020-12-11 | Wake | North Carolina | 37183 | 34768 | 322 |
818579 | 818579 | 2020-12-11 | Warren | North Carolina | 37185 | 901 | 8 |
818580 | 818580 | 2020-12-11 | Washington | North Carolina | 37187 | 360 | 8 |
818581 | 818581 | 2020-12-11 | Watauga | North Carolina | 37189 | 2241 | 8 |
818582 | 818582 | 2020-12-11 | Wayne | North Carolina | 37191 | 6438 | 124 |
818583 | 818583 | 2020-12-11 | Wilkes | North Carolina | 37193 | 3105 | 58 |
818584 | 818584 | 2020-12-11 | Wilson | North Carolina | 37195 | 4576 | 89 |
818585 | 818585 | 2020-12-11 | Yadkin | North Carolina | 37197 | 1866 | 20 |
818586 | 818586 | 2020-12-11 | Yancey | North Carolina | 37199 | 763 | 3 |
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);