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-10-19 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 |
---|---|---|---|---|---|---|---|
646528 | 646528 | 2020-10-19 | Alamance | North Carolina | 37001 | 4815 | 68 |
646529 | 646529 | 2020-10-19 | Alexander | North Carolina | 37003 | 706 | 9 |
646530 | 646530 | 2020-10-19 | Alleghany | North Carolina | 37005 | 269 | 1 |
646531 | 646531 | 2020-10-19 | Anson | North Carolina | 37007 | 696 | 8 |
646532 | 646532 | 2020-10-19 | Ashe | North Carolina | 37009 | 367 | 1 |
646533 | 646533 | 2020-10-19 | Avery | North Carolina | 37011 | 574 | 0 |
646534 | 646534 | 2020-10-19 | Beaufort | North Carolina | 37013 | 1254 | 35 |
646535 | 646535 | 2020-10-19 | Bertie | North Carolina | 37015 | 692 | 13 |
646536 | 646536 | 2020-10-19 | Bladen | North Carolina | 37017 | 1042 | 19 |
646537 | 646537 | 2020-10-19 | Brunswick | North Carolina | 37019 | 2033 | 34 |
646538 | 646538 | 2020-10-19 | Buncombe | North Carolina | 37021 | 3784 | 104 |
646539 | 646539 | 2020-10-19 | Burke | North Carolina | 37023 | 2503 | 46 |
646540 | 646540 | 2020-10-19 | Cabarrus | North Carolina | 37025 | 4607 | 82 |
646541 | 646541 | 2020-10-19 | Caldwell | North Carolina | 37027 | 2191 | 19 |
646542 | 646542 | 2020-10-19 | Camden | North Carolina | 37029 | 133 | 3 |
646543 | 646543 | 2020-10-19 | Carteret | North Carolina | 37031 | 997 | 5 |
646544 | 646544 | 2020-10-19 | Caswell | North Carolina | 37033 | 569 | 5 |
646545 | 646545 | 2020-10-19 | Catawba | North Carolina | 37035 | 3952 | 57 |
646546 | 646546 | 2020-10-19 | Chatham | North Carolina | 37037 | 1865 | 60 |
646547 | 646547 | 2020-10-19 | Cherokee | North Carolina | 37039 | 733 | 12 |
646548 | 646548 | 2020-10-19 | Chowan | North Carolina | 37041 | 491 | 10 |
646549 | 646549 | 2020-10-19 | Clay | North Carolina | 37043 | 181 | 3 |
646550 | 646550 | 2020-10-19 | Cleveland | North Carolina | 37045 | 2864 | 76 |
646551 | 646551 | 2020-10-19 | Columbus | North Carolina | 37047 | 1583 | 59 |
646552 | 646552 | 2020-10-19 | Craven | North Carolina | 37049 | 2122 | 50 |
646553 | 646553 | 2020-10-19 | Cumberland | North Carolina | 37051 | 6548 | 91 |
646554 | 646554 | 2020-10-19 | Currituck | North Carolina | 37053 | 216 | 4 |
646555 | 646555 | 2020-10-19 | Dare | North Carolina | 37055 | 337 | 3 |
646556 | 646556 | 2020-10-19 | Davidson | North Carolina | 37057 | 3464 | 42 |
646557 | 646557 | 2020-10-19 | Davie | North Carolina | 37059 | 708 | 6 |
646558 | 646558 | 2020-10-19 | Duplin | North Carolina | 37061 | 2664 | 54 |
646559 | 646559 | 2020-10-19 | Durham | North Carolina | 37063 | 8621 | 99 |
646560 | 646560 | 2020-10-19 | Edgecombe | North Carolina | 37065 | 1803 | 52 |
646561 | 646561 | 2020-10-19 | Forsyth | North Carolina | 37067 | 8155 | 112 |
646562 | 646562 | 2020-10-19 | Franklin | North Carolina | 37069 | 1374 | 31 |
646563 | 646563 | 2020-10-19 | Gaston | North Carolina | 37071 | 6721 | 104 |
646564 | 646564 | 2020-10-19 | Gates | North Carolina | 37073 | 162 | 3 |
646565 | 646565 | 2020-10-19 | Graham | North Carolina | 37075 | 232 | 7 |
646566 | 646566 | 2020-10-19 | Granville | North Carolina | 37077 | 1915 | 50 |
646567 | 646567 | 2020-10-19 | Greene | North Carolina | 37079 | 854 | 12 |
646568 | 646568 | 2020-10-19 | Guilford | North Carolina | 37081 | 10514 | 193 |
646569 | 646569 | 2020-10-19 | Halifax | North Carolina | 37083 | 1278 | 25 |
646570 | 646570 | 2020-10-19 | Harnett | North Carolina | 37085 | 2717 | 66 |
646571 | 646571 | 2020-10-19 | Haywood | North Carolina | 37087 | 690 | 36 |
646572 | 646572 | 2020-10-19 | Henderson | North Carolina | 37089 | 2346 | 66 |
646573 | 646573 | 2020-10-19 | Hertford | North Carolina | 37091 | 845 | 34 |
646574 | 646574 | 2020-10-19 | Hoke | North Carolina | 37093 | 1460 | 22 |
646575 | 646575 | 2020-10-19 | Hyde | North Carolina | 37095 | 174 | 5 |
646576 | 646576 | 2020-10-19 | Iredell | North Carolina | 37097 | 3559 | 34 |
646577 | 646577 | 2020-10-19 | Jackson | North Carolina | 37099 | 853 | 7 |
646578 | 646578 | 2020-10-19 | Johnston | North Carolina | 37101 | 5270 | 62 |
646579 | 646579 | 2020-10-19 | Jones | North Carolina | 37103 | 174 | 15 |
646580 | 646580 | 2020-10-19 | Lee | North Carolina | 37105 | 1959 | 16 |
646581 | 646581 | 2020-10-19 | Lenoir | North Carolina | 37107 | 1291 | 35 |
646582 | 646582 | 2020-10-19 | Lincoln | North Carolina | 37109 | 2164 | 16 |
646583 | 646583 | 2020-10-19 | Macon | North Carolina | 37113 | 704 | 7 |
646584 | 646584 | 2020-10-19 | Madison | North Carolina | 37115 | 154 | 1 |
646585 | 646585 | 2020-10-19 | Martin | North Carolina | 37117 | 596 | 16 |
646586 | 646586 | 2020-10-19 | McDowell | North Carolina | 37111 | 1215 | 31 |
646587 | 646587 | 2020-10-19 | Mecklenburg | North Carolina | 37119 | 31820 | 377 |
646588 | 646588 | 2020-10-19 | Mitchell | North Carolina | 37121 | 189 | 4 |
646589 | 646589 | 2020-10-19 | Montgomery | North Carolina | 37123 | 1146 | 38 |
646590 | 646590 | 2020-10-19 | Moore | North Carolina | 37125 | 2129 | 38 |
646591 | 646591 | 2020-10-19 | Nash | North Carolina | 37127 | 3123 | 60 |
646592 | 646592 | 2020-10-19 | New Hanover | North Carolina | 37129 | 4917 | 37 |
646593 | 646593 | 2020-10-19 | Northampton | North Carolina | 37131 | 526 | 18 |
646594 | 646594 | 2020-10-19 | Onslow | North Carolina | 37133 | 2951 | 26 |
646595 | 646595 | 2020-10-19 | Orange | North Carolina | 37135 | 2953 | 58 |
646596 | 646596 | 2020-10-19 | Pamlico | North Carolina | 37137 | 300 | 2 |
646597 | 646597 | 2020-10-19 | Pasquotank | North Carolina | 37139 | 823 | 33 |
646598 | 646598 | 2020-10-19 | Pender | North Carolina | 37141 | 1193 | 8 |
646599 | 646599 | 2020-10-19 | Perquimans | North Carolina | 37143 | 230 | 3 |
646600 | 646600 | 2020-10-19 | Person | North Carolina | 37145 | 577 | 9 |
646601 | 646601 | 2020-10-19 | Pitt | North Carolina | 37147 | 5837 | 35 |
646602 | 646602 | 2020-10-19 | Polk | North Carolina | 37149 | 376 | 11 |
646603 | 646603 | 2020-10-19 | Randolph | North Carolina | 37151 | 3493 | 57 |
646604 | 646604 | 2020-10-19 | Richmond | North Carolina | 37153 | 1330 | 24 |
646605 | 646605 | 2020-10-19 | Robeson | North Carolina | 37155 | 5637 | 86 |
646606 | 646606 | 2020-10-19 | Rockingham | North Carolina | 37157 | 1749 | 17 |
646607 | 646607 | 2020-10-19 | Rowan | North Carolina | 37159 | 3927 | 111 |
646608 | 646608 | 2020-10-19 | Rutherford | North Carolina | 37161 | 1601 | 54 |
646609 | 646609 | 2020-10-19 | Sampson | North Carolina | 37163 | 2548 | 28 |
646610 | 646610 | 2020-10-19 | Scotland | North Carolina | 37165 | 1541 | 22 |
646611 | 646611 | 2020-10-19 | Stanly | North Carolina | 37167 | 2370 | 57 |
646612 | 646612 | 2020-10-19 | Stokes | North Carolina | 37169 | 626 | 5 |
646613 | 646613 | 2020-10-19 | Surry | North Carolina | 37171 | 1636 | 26 |
646614 | 646614 | 2020-10-19 | Swain | North Carolina | 37173 | 223 | 3 |
646615 | 646615 | 2020-10-19 | Transylvania | North Carolina | 37175 | 389 | 9 |
646616 | 646616 | 2020-10-19 | Tyrrell | North Carolina | 37177 | 123 | 3 |
646617 | 646617 | 2020-10-19 | Union | North Carolina | 37179 | 5616 | 62 |
646618 | 646618 | 2020-10-19 | Vance | North Carolina | 37181 | 1147 | 46 |
646619 | 646619 | 2020-10-19 | Wake | North Carolina | 37183 | 20149 | 265 |
646620 | 646620 | 2020-10-19 | Warren | North Carolina | 37185 | 402 | 7 |
646621 | 646621 | 2020-10-19 | Washington | North Carolina | 37187 | 236 | 8 |
646622 | 646622 | 2020-10-19 | Watauga | North Carolina | 37189 | 1306 | 2 |
646623 | 646623 | 2020-10-19 | Wayne | North Carolina | 37191 | 4190 | 77 |
646624 | 646624 | 2020-10-19 | Wilkes | North Carolina | 37193 | 1566 | 36 |
646625 | 646625 | 2020-10-19 | Wilson | North Carolina | 37195 | 2719 | 62 |
646626 | 646626 | 2020-10-19 | Yadkin | North Carolina | 37197 | 906 | 9 |
646627 | 646627 | 2020-10-19 | Yancey | North Carolina | 37199 | 271 | 0 |
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);