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-09-25 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 |
---|---|---|---|---|---|---|---|
568700 | 568700 | 2020-09-25 | Alamance | North Carolina | 37001 | 3881 | 54 |
568701 | 568701 | 2020-09-25 | Alexander | North Carolina | 37003 | 516 | 7 |
568702 | 568702 | 2020-09-25 | Alleghany | North Carolina | 37005 | 226 | 0 |
568703 | 568703 | 2020-09-25 | Anson | North Carolina | 37007 | 577 | 4 |
568704 | 568704 | 2020-09-25 | Ashe | North Carolina | 37009 | 266 | 1 |
568705 | 568705 | 2020-09-25 | Avery | North Carolina | 37011 | 348 | 0 |
568706 | 568706 | 2020-09-25 | Beaufort | North Carolina | 37013 | 918 | 23 |
568707 | 568707 | 2020-09-25 | Bertie | North Carolina | 37015 | 577 | 8 |
568708 | 568708 | 2020-09-25 | Bladen | North Carolina | 37017 | 893 | 15 |
568709 | 568709 | 2020-09-25 | Brunswick | North Carolina | 37019 | 1622 | 26 |
568710 | 568710 | 2020-09-25 | Buncombe | North Carolina | 37021 | 3081 | 82 |
568711 | 568711 | 2020-09-25 | Burke | North Carolina | 37023 | 2104 | 38 |
568712 | 568712 | 2020-09-25 | Cabarrus | North Carolina | 37025 | 3966 | 68 |
568713 | 568713 | 2020-09-25 | Caldwell | North Carolina | 37027 | 1653 | 18 |
568714 | 568714 | 2020-09-25 | Camden | North Carolina | 37029 | 113 | 3 |
568715 | 568715 | 2020-09-25 | Carteret | North Carolina | 37031 | 677 | 5 |
568716 | 568716 | 2020-09-25 | Caswell | North Carolina | 37033 | 349 | 4 |
568717 | 568717 | 2020-09-25 | Catawba | North Carolina | 37035 | 3129 | 52 |
568718 | 568718 | 2020-09-25 | Chatham | North Carolina | 37037 | 1654 | 57 |
568719 | 568719 | 2020-09-25 | Cherokee | North Carolina | 37039 | 614 | 12 |
568720 | 568720 | 2020-09-25 | Chowan | North Carolina | 37041 | 346 | 3 |
568721 | 568721 | 2020-09-25 | Clay | North Carolina | 37043 | 116 | 2 |
568722 | 568722 | 2020-09-25 | Cleveland | North Carolina | 37045 | 2176 | 61 |
568723 | 568723 | 2020-09-25 | Columbus | North Carolina | 37047 | 1357 | 56 |
568724 | 568724 | 2020-09-25 | Craven | North Carolina | 37049 | 1591 | 34 |
568725 | 568725 | 2020-09-25 | Cumberland | North Carolina | 37051 | 5389 | 76 |
568726 | 568726 | 2020-09-25 | Currituck | North Carolina | 37053 | 182 | 3 |
568727 | 568727 | 2020-09-25 | Dare | North Carolina | 37055 | 271 | 3 |
568728 | 568728 | 2020-09-25 | Davidson | North Carolina | 37057 | 2714 | 34 |
568729 | 568729 | 2020-09-25 | Davie | North Carolina | 37059 | 553 | 6 |
568730 | 568730 | 2020-09-25 | Duplin | North Carolina | 37061 | 2372 | 53 |
568731 | 568731 | 2020-09-25 | Durham | North Carolina | 37063 | 7682 | 95 |
568732 | 568732 | 2020-09-25 | Edgecombe | North Carolina | 37065 | 1342 | 47 |
568733 | 568733 | 2020-09-25 | Forsyth | North Carolina | 37067 | 6956 | 98 |
568734 | 568734 | 2020-09-25 | Franklin | North Carolina | 37069 | 1207 | 31 |
568735 | 568735 | 2020-09-25 | Gaston | North Carolina | 37071 | 5087 | 81 |
568736 | 568736 | 2020-09-25 | Gates | North Carolina | 37073 | 138 | 3 |
568737 | 568737 | 2020-09-25 | Graham | North Carolina | 37075 | 143 | 3 |
568738 | 568738 | 2020-09-25 | Granville | North Carolina | 37077 | 1715 | 49 |
568739 | 568739 | 2020-09-25 | Greene | North Carolina | 37079 | 593 | 5 |
568740 | 568740 | 2020-09-25 | Guilford | North Carolina | 37081 | 8463 | 180 |
568741 | 568741 | 2020-09-25 | Halifax | North Carolina | 37083 | 1006 | 19 |
568742 | 568742 | 2020-09-25 | Harnett | North Carolina | 37085 | 2210 | 52 |
568743 | 568743 | 2020-09-25 | Haywood | North Carolina | 37087 | 603 | 31 |
568744 | 568744 | 2020-09-25 | Henderson | North Carolina | 37089 | 1994 | 64 |
568745 | 568745 | 2020-09-25 | Hertford | North Carolina | 37091 | 744 | 29 |
568746 | 568746 | 2020-09-25 | Hoke | North Carolina | 37093 | 1138 | 17 |
568747 | 568747 | 2020-09-25 | Hyde | North Carolina | 37095 | 126 | 5 |
568748 | 568748 | 2020-09-25 | Iredell | North Carolina | 37097 | 3045 | 30 |
568749 | 568749 | 2020-09-25 | Jackson | North Carolina | 37099 | 638 | 7 |
568750 | 568750 | 2020-09-25 | Johnston | North Carolina | 37101 | 4477 | 56 |
568751 | 568751 | 2020-09-25 | Jones | North Carolina | 37103 | 157 | 11 |
568752 | 568752 | 2020-09-25 | Lee | North Carolina | 37105 | 1631 | 14 |
568753 | 568753 | 2020-09-25 | Lenoir | North Carolina | 37107 | 996 | 31 |
568754 | 568754 | 2020-09-25 | Lincoln | North Carolina | 37109 | 1575 | 14 |
568755 | 568755 | 2020-09-25 | Macon | North Carolina | 37113 | 593 | 2 |
568756 | 568756 | 2020-09-25 | Madison | North Carolina | 37115 | 99 | 1 |
568757 | 568757 | 2020-09-25 | Martin | North Carolina | 37117 | 453 | 10 |
568758 | 568758 | 2020-09-25 | McDowell | North Carolina | 37111 | 972 | 26 |
568759 | 568759 | 2020-09-25 | Mecklenburg | North Carolina | 37119 | 28416 | 355 |
568760 | 568760 | 2020-09-25 | Mitchell | North Carolina | 37121 | 150 | 3 |
568761 | 568761 | 2020-09-25 | Montgomery | North Carolina | 37123 | 1042 | 30 |
568762 | 568762 | 2020-09-25 | Moore | North Carolina | 37125 | 1630 | 27 |
568763 | 568763 | 2020-09-25 | Nash | North Carolina | 37127 | 2295 | 39 |
568764 | 568764 | 2020-09-25 | New Hanover | North Carolina | 37129 | 4231 | 30 |
568765 | 568765 | 2020-09-25 | Northampton | North Carolina | 37131 | 449 | 17 |
568766 | 568766 | 2020-09-25 | Onslow | North Carolina | 37133 | 2151 | 25 |
568767 | 568767 | 2020-09-25 | Orange | North Carolina | 37135 | 2636 | 55 |
568768 | 568768 | 2020-09-25 | Pamlico | North Carolina | 37137 | 267 | 2 |
568769 | 568769 | 2020-09-25 | Pasquotank | North Carolina | 37139 | 695 | 30 |
568770 | 568770 | 2020-09-25 | Pender | North Carolina | 37141 | 940 | 5 |
568771 | 568771 | 2020-09-25 | Perquimans | North Carolina | 37143 | 186 | 3 |
568772 | 568772 | 2020-09-25 | Person | North Carolina | 37145 | 427 | 7 |
568773 | 568773 | 2020-09-25 | Pitt | North Carolina | 37147 | 4852 | 29 |
568774 | 568774 | 2020-09-25 | Polk | North Carolina | 37149 | 308 | 10 |
568775 | 568775 | 2020-09-25 | Randolph | North Carolina | 37151 | 2809 | 52 |
568776 | 568776 | 2020-09-25 | Richmond | North Carolina | 37153 | 995 | 16 |
568777 | 568777 | 2020-09-25 | Robeson | North Carolina | 37155 | 4455 | 75 |
568778 | 568778 | 2020-09-25 | Rockingham | North Carolina | 37157 | 1207 | 14 |
568779 | 568779 | 2020-09-25 | Rowan | North Carolina | 37159 | 3325 | 97 |
568780 | 568780 | 2020-09-25 | Rutherford | North Carolina | 37161 | 1191 | 33 |
568781 | 568781 | 2020-09-25 | Sampson | North Carolina | 37163 | 2200 | 28 |
568782 | 568782 | 2020-09-25 | Scotland | North Carolina | 37165 | 1095 | 13 |
568783 | 568783 | 2020-09-25 | Stanly | North Carolina | 37167 | 1891 | 56 |
568784 | 568784 | 2020-09-25 | Stokes | North Carolina | 37169 | 424 | 3 |
568785 | 568785 | 2020-09-25 | Surry | North Carolina | 37171 | 1313 | 23 |
568786 | 568786 | 2020-09-25 | Swain | North Carolina | 37173 | 142 | 3 |
568787 | 568787 | 2020-09-25 | Transylvania | North Carolina | 37175 | 329 | 7 |
568788 | 568788 | 2020-09-25 | Tyrrell | North Carolina | 37177 | 116 | 3 |
568789 | 568789 | 2020-09-25 | Union | North Carolina | 37179 | 4750 | 59 |
568790 | 568790 | 2020-09-25 | Vance | North Carolina | 37181 | 1032 | 44 |
568791 | 568791 | 2020-09-25 | Wake | North Carolina | 37183 | 17654 | 243 |
568792 | 568792 | 2020-09-25 | Warren | North Carolina | 37185 | 338 | 7 |
568793 | 568793 | 2020-09-25 | Washington | North Carolina | 37187 | 209 | 8 |
568794 | 568794 | 2020-09-25 | Watauga | North Carolina | 37189 | 816 | 1 |
568795 | 568795 | 2020-09-25 | Wayne | North Carolina | 37191 | 3336 | 67 |
568796 | 568796 | 2020-09-25 | Wilkes | North Carolina | 37193 | 1201 | 33 |
568797 | 568797 | 2020-09-25 | Wilson | North Carolina | 37195 | 2196 | 49 |
568798 | 568798 | 2020-09-25 | Yadkin | North Carolina | 37197 | 736 | 7 |
568799 | 568799 | 2020-09-25 | Yancey | North Carolina | 37199 | 209 | 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);