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-07 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 |
---|---|---|---|---|---|---|---|
607601 | 607601 | 2020-10-07 | Alamance | North Carolina | 37001 | 4204 | 59 |
607602 | 607602 | 2020-10-07 | Alexander | North Carolina | 37003 | 571 | 8 |
607603 | 607603 | 2020-10-07 | Alleghany | North Carolina | 37005 | 245 | 0 |
607604 | 607604 | 2020-10-07 | Anson | North Carolina | 37007 | 655 | 6 |
607605 | 607605 | 2020-10-07 | Ashe | North Carolina | 37009 | 294 | 1 |
607606 | 607606 | 2020-10-07 | Avery | North Carolina | 37011 | 435 | 0 |
607607 | 607607 | 2020-10-07 | Beaufort | North Carolina | 37013 | 1036 | 27 |
607608 | 607608 | 2020-10-07 | Bertie | North Carolina | 37015 | 634 | 11 |
607609 | 607609 | 2020-10-07 | Bladen | North Carolina | 37017 | 955 | 18 |
607610 | 607610 | 2020-10-07 | Brunswick | North Carolina | 37019 | 1779 | 27 |
607611 | 607611 | 2020-10-07 | Buncombe | North Carolina | 37021 | 3407 | 98 |
607612 | 607612 | 2020-10-07 | Burke | North Carolina | 37023 | 2266 | 43 |
607613 | 607613 | 2020-10-07 | Cabarrus | North Carolina | 37025 | 4252 | 79 |
607614 | 607614 | 2020-10-07 | Caldwell | North Carolina | 37027 | 1847 | 18 |
607615 | 607615 | 2020-10-07 | Camden | North Carolina | 37029 | 125 | 3 |
607616 | 607616 | 2020-10-07 | Carteret | North Carolina | 37031 | 817 | 5 |
607617 | 607617 | 2020-10-07 | Caswell | North Carolina | 37033 | 468 | 5 |
607618 | 607618 | 2020-10-07 | Catawba | North Carolina | 37035 | 3446 | 55 |
607619 | 607619 | 2020-10-07 | Chatham | North Carolina | 37037 | 1755 | 59 |
607620 | 607620 | 2020-10-07 | Cherokee | North Carolina | 37039 | 679 | 12 |
607621 | 607621 | 2020-10-07 | Chowan | North Carolina | 37041 | 410 | 4 |
607622 | 607622 | 2020-10-07 | Clay | North Carolina | 37043 | 134 | 2 |
607623 | 607623 | 2020-10-07 | Cleveland | North Carolina | 37045 | 2514 | 72 |
607624 | 607624 | 2020-10-07 | Columbus | North Carolina | 37047 | 1460 | 57 |
607625 | 607625 | 2020-10-07 | Craven | North Carolina | 37049 | 1864 | 45 |
607626 | 607626 | 2020-10-07 | Cumberland | North Carolina | 37051 | 5952 | 80 |
607627 | 607627 | 2020-10-07 | Currituck | North Carolina | 37053 | 196 | 4 |
607628 | 607628 | 2020-10-07 | Dare | North Carolina | 37055 | 295 | 3 |
607629 | 607629 | 2020-10-07 | Davidson | North Carolina | 37057 | 3041 | 39 |
607630 | 607630 | 2020-10-07 | Davie | North Carolina | 37059 | 612 | 6 |
607631 | 607631 | 2020-10-07 | Duplin | North Carolina | 37061 | 2523 | 54 |
607632 | 607632 | 2020-10-07 | Durham | North Carolina | 37063 | 8053 | 98 |
607633 | 607633 | 2020-10-07 | Edgecombe | North Carolina | 37065 | 1500 | 52 |
607634 | 607634 | 2020-10-07 | Forsyth | North Carolina | 37067 | 7417 | 104 |
607635 | 607635 | 2020-10-07 | Franklin | North Carolina | 37069 | 1295 | 31 |
607636 | 607636 | 2020-10-07 | Gaston | North Carolina | 37071 | 5760 | 92 |
607637 | 607637 | 2020-10-07 | Gates | North Carolina | 37073 | 150 | 3 |
607638 | 607638 | 2020-10-07 | Graham | North Carolina | 37075 | 205 | 5 |
607639 | 607639 | 2020-10-07 | Granville | North Carolina | 37077 | 1796 | 50 |
607640 | 607640 | 2020-10-07 | Greene | North Carolina | 37079 | 708 | 5 |
607641 | 607641 | 2020-10-07 | Guilford | North Carolina | 37081 | 9301 | 190 |
607642 | 607642 | 2020-10-07 | Halifax | North Carolina | 37083 | 1110 | 22 |
607643 | 607643 | 2020-10-07 | Harnett | North Carolina | 37085 | 2451 | 56 |
607644 | 607644 | 2020-10-07 | Haywood | North Carolina | 37087 | 637 | 31 |
607645 | 607645 | 2020-10-07 | Henderson | North Carolina | 37089 | 2136 | 65 |
607646 | 607646 | 2020-10-07 | Hertford | North Carolina | 37091 | 810 | 33 |
607647 | 607647 | 2020-10-07 | Hoke | North Carolina | 37093 | 1325 | 18 |
607648 | 607648 | 2020-10-07 | Hyde | North Carolina | 37095 | 145 | 5 |
607649 | 607649 | 2020-10-07 | Iredell | North Carolina | 37097 | 3246 | 33 |
607650 | 607650 | 2020-10-07 | Jackson | North Carolina | 37099 | 714 | 7 |
607651 | 607651 | 2020-10-07 | Johnston | North Carolina | 37101 | 4809 | 57 |
607652 | 607652 | 2020-10-07 | Jones | North Carolina | 37103 | 161 | 14 |
607653 | 607653 | 2020-10-07 | Lee | North Carolina | 37105 | 1777 | 15 |
607654 | 607654 | 2020-10-07 | Lenoir | North Carolina | 37107 | 1079 | 33 |
607655 | 607655 | 2020-10-07 | Lincoln | North Carolina | 37109 | 1857 | 15 |
607656 | 607656 | 2020-10-07 | Macon | North Carolina | 37113 | 659 | 2 |
607657 | 607657 | 2020-10-07 | Madison | North Carolina | 37115 | 121 | 1 |
607658 | 607658 | 2020-10-07 | Martin | North Carolina | 37117 | 524 | 13 |
607659 | 607659 | 2020-10-07 | McDowell | North Carolina | 37111 | 1092 | 29 |
607660 | 607660 | 2020-10-07 | Mecklenburg | North Carolina | 37119 | 29829 | 365 |
607661 | 607661 | 2020-10-07 | Mitchell | North Carolina | 37121 | 171 | 3 |
607662 | 607662 | 2020-10-07 | Montgomery | North Carolina | 37123 | 1071 | 35 |
607663 | 607663 | 2020-10-07 | Moore | North Carolina | 37125 | 1866 | 34 |
607664 | 607664 | 2020-10-07 | Nash | North Carolina | 37127 | 2665 | 48 |
607665 | 607665 | 2020-10-07 | New Hanover | North Carolina | 37129 | 4547 | 33 |
607666 | 607666 | 2020-10-07 | Northampton | North Carolina | 37131 | 492 | 17 |
607667 | 607667 | 2020-10-07 | Onslow | North Carolina | 37133 | 2451 | 26 |
607668 | 607668 | 2020-10-07 | Orange | North Carolina | 37135 | 2777 | 57 |
607669 | 607669 | 2020-10-07 | Pamlico | North Carolina | 37137 | 278 | 2 |
607670 | 607670 | 2020-10-07 | Pasquotank | North Carolina | 37139 | 757 | 33 |
607671 | 607671 | 2020-10-07 | Pender | North Carolina | 37141 | 1079 | 8 |
607672 | 607672 | 2020-10-07 | Perquimans | North Carolina | 37143 | 198 | 3 |
607673 | 607673 | 2020-10-07 | Person | North Carolina | 37145 | 473 | 8 |
607674 | 607674 | 2020-10-07 | Pitt | North Carolina | 37147 | 5281 | 33 |
607675 | 607675 | 2020-10-07 | Polk | North Carolina | 37149 | 337 | 11 |
607676 | 607676 | 2020-10-07 | Randolph | North Carolina | 37151 | 3051 | 54 |
607677 | 607677 | 2020-10-07 | Richmond | North Carolina | 37153 | 1121 | 20 |
607678 | 607678 | 2020-10-07 | Robeson | North Carolina | 37155 | 4954 | 84 |
607679 | 607679 | 2020-10-07 | Rockingham | North Carolina | 37157 | 1452 | 17 |
607680 | 607680 | 2020-10-07 | Rowan | North Carolina | 37159 | 3635 | 105 |
607681 | 607681 | 2020-10-07 | Rutherford | North Carolina | 37161 | 1388 | 43 |
607682 | 607682 | 2020-10-07 | Sampson | North Carolina | 37163 | 2348 | 28 |
607683 | 607683 | 2020-10-07 | Scotland | North Carolina | 37165 | 1355 | 17 |
607684 | 607684 | 2020-10-07 | Stanly | North Carolina | 37167 | 2146 | 56 |
607685 | 607685 | 2020-10-07 | Stokes | North Carolina | 37169 | 518 | 4 |
607686 | 607686 | 2020-10-07 | Surry | North Carolina | 37171 | 1431 | 23 |
607687 | 607687 | 2020-10-07 | Swain | North Carolina | 37173 | 168 | 3 |
607688 | 607688 | 2020-10-07 | Transylvania | North Carolina | 37175 | 346 | 9 |
607689 | 607689 | 2020-10-07 | Tyrrell | North Carolina | 37177 | 117 | 3 |
607690 | 607690 | 2020-10-07 | Union | North Carolina | 37179 | 5200 | 59 |
607691 | 607691 | 2020-10-07 | Vance | North Carolina | 37181 | 1095 | 45 |
607692 | 607692 | 2020-10-07 | Wake | North Carolina | 37183 | 18921 | 260 |
607693 | 607693 | 2020-10-07 | Warren | North Carolina | 37185 | 366 | 7 |
607694 | 607694 | 2020-10-07 | Washington | North Carolina | 37187 | 221 | 8 |
607695 | 607695 | 2020-10-07 | Watauga | North Carolina | 37189 | 1095 | 2 |
607696 | 607696 | 2020-10-07 | Wayne | North Carolina | 37191 | 3678 | 73 |
607697 | 607697 | 2020-10-07 | Wilkes | North Carolina | 37193 | 1346 | 35 |
607698 | 607698 | 2020-10-07 | Wilson | North Carolina | 37195 | 2402 | 57 |
607699 | 607699 | 2020-10-07 | Yadkin | North Carolina | 37197 | 790 | 9 |
607700 | 607700 | 2020-10-07 | Yancey | North Carolina | 37199 | 224 | 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);