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-07-05 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 |
---|---|---|---|---|---|---|---|
304712 | 304712 | 2020-07-05 | Alamance | North Carolina | 37001 | 1274 | 37 |
304713 | 304713 | 2020-07-05 | Alexander | North Carolina | 37003 | 118 | 1 |
304714 | 304714 | 2020-07-05 | Alleghany | North Carolina | 37005 | 37 | 0 |
304715 | 304715 | 2020-07-05 | Anson | North Carolina | 37007 | 149 | 1 |
304716 | 304716 | 2020-07-05 | Ashe | North Carolina | 37009 | 57 | 1 |
304717 | 304717 | 2020-07-05 | Avery | North Carolina | 37011 | 15 | 0 |
304718 | 304718 | 2020-07-05 | Beaufort | North Carolina | 37013 | 104 | 0 |
304719 | 304719 | 2020-07-05 | Bertie | North Carolina | 37015 | 151 | 4 |
304720 | 304720 | 2020-07-05 | Bladen | North Carolina | 37017 | 399 | 3 |
304721 | 304721 | 2020-07-05 | Brunswick | North Carolina | 37019 | 667 | 8 |
304722 | 304722 | 2020-07-05 | Buncombe | North Carolina | 37021 | 675 | 39 |
304723 | 304723 | 2020-07-05 | Burke | North Carolina | 37023 | 1105 | 20 |
304724 | 304724 | 2020-07-05 | Cabarrus | North Carolina | 37025 | 1343 | 33 |
304725 | 304725 | 2020-07-05 | Caldwell | North Carolina | 37027 | 504 | 4 |
304726 | 304726 | 2020-07-05 | Camden | North Carolina | 37029 | 31 | 0 |
304727 | 304727 | 2020-07-05 | Carteret | North Carolina | 37031 | 105 | 3 |
304728 | 304728 | 2020-07-05 | Caswell | North Carolina | 37033 | 147 | 2 |
304729 | 304729 | 2020-07-05 | Catawba | North Carolina | 37035 | 942 | 12 |
304730 | 304730 | 2020-07-05 | Chatham | North Carolina | 37037 | 990 | 43 |
304731 | 304731 | 2020-07-05 | Cherokee | North Carolina | 37039 | 44 | 2 |
304732 | 304732 | 2020-07-05 | Chowan | North Carolina | 37041 | 27 | 0 |
304733 | 304733 | 2020-07-05 | Clay | North Carolina | 37043 | 12 | 0 |
304734 | 304734 | 2020-07-05 | Cleveland | North Carolina | 37045 | 375 | 4 |
304735 | 304735 | 2020-07-05 | Columbus | North Carolina | 37047 | 556 | 39 |
304736 | 304736 | 2020-07-05 | Craven | North Carolina | 37049 | 396 | 6 |
304737 | 304737 | 2020-07-05 | Cumberland | North Carolina | 37051 | 1355 | 41 |
304738 | 304738 | 2020-07-05 | Currituck | North Carolina | 37053 | 20 | 0 |
304739 | 304739 | 2020-07-05 | Dare | North Carolina | 37055 | 74 | 1 |
304740 | 304740 | 2020-07-05 | Davidson | North Carolina | 37057 | 1072 | 15 |
304741 | 304741 | 2020-07-05 | Davie | North Carolina | 37059 | 215 | 3 |
304742 | 304742 | 2020-07-05 | Duplin | North Carolina | 37061 | 1561 | 28 |
304743 | 304743 | 2020-07-05 | Durham | North Carolina | 37063 | 4113 | 67 |
304744 | 304744 | 2020-07-05 | Edgecombe | North Carolina | 37065 | 334 | 9 |
304745 | 304745 | 2020-07-05 | Forsyth | North Carolina | 37067 | 3290 | 37 |
304746 | 304746 | 2020-07-05 | Franklin | North Carolina | 37069 | 381 | 21 |
304747 | 304747 | 2020-07-05 | Gaston | North Carolina | 37071 | 1325 | 11 |
304748 | 304748 | 2020-07-05 | Gates | North Carolina | 37073 | 27 | 2 |
304749 | 304749 | 2020-07-05 | Graham | North Carolina | 37075 | 10 | 0 |
304750 | 304750 | 2020-07-05 | Granville | North Carolina | 37077 | 844 | 21 |
304751 | 304751 | 2020-07-05 | Greene | North Carolina | 37079 | 184 | 3 |
304752 | 304752 | 2020-07-05 | Guilford | North Carolina | 37081 | 3094 | 117 |
304753 | 304753 | 2020-07-05 | Halifax | North Carolina | 37083 | 323 | 4 |
304754 | 304754 | 2020-07-05 | Harnett | North Carolina | 37085 | 698 | 30 |
304755 | 304755 | 2020-07-05 | Haywood | North Carolina | 37087 | 98 | 0 |
304756 | 304756 | 2020-07-05 | Henderson | North Carolina | 37089 | 703 | 50 |
304757 | 304757 | 2020-07-05 | Hertford | North Carolina | 37091 | 170 | 10 |
304758 | 304758 | 2020-07-05 | Hoke | North Carolina | 37093 | 403 | 3 |
304759 | 304759 | 2020-07-05 | Hyde | North Carolina | 37095 | 17 | 0 |
304760 | 304760 | 2020-07-05 | Iredell | North Carolina | 37097 | 890 | 7 |
304761 | 304761 | 2020-07-05 | Jackson | North Carolina | 37099 | 138 | 1 |
304762 | 304762 | 2020-07-05 | Johnston | North Carolina | 37101 | 1715 | 33 |
304763 | 304763 | 2020-07-05 | Jones | North Carolina | 37103 | 36 | 3 |
304764 | 304764 | 2020-07-05 | Lee | North Carolina | 37105 | 869 | 8 |
304765 | 304765 | 2020-07-05 | Lenoir | North Carolina | 37107 | 380 | 11 |
304766 | 304766 | 2020-07-05 | Lincoln | North Carolina | 37109 | 300 | 1 |
304767 | 304767 | 2020-07-05 | Macon | North Carolina | 37113 | 289 | 1 |
304768 | 304768 | 2020-07-05 | Madison | North Carolina | 37115 | 16 | 0 |
304769 | 304769 | 2020-07-05 | Martin | North Carolina | 37117 | 143 | 4 |
304770 | 304770 | 2020-07-05 | McDowell | North Carolina | 37111 | 267 | 2 |
304771 | 304771 | 2020-07-05 | Mecklenburg | North Carolina | 37119 | 12806 | 155 |
304772 | 304772 | 2020-07-05 | Mitchell | North Carolina | 37121 | 44 | 0 |
304773 | 304773 | 2020-07-05 | Montgomery | North Carolina | 37123 | 343 | 7 |
304774 | 304774 | 2020-07-05 | Moore | North Carolina | 37125 | 530 | 13 |
304775 | 304775 | 2020-07-05 | Nash | North Carolina | 37127 | 525 | 6 |
304776 | 304776 | 2020-07-05 | New Hanover | North Carolina | 37129 | 1118 | 7 |
304777 | 304777 | 2020-07-05 | Northampton | North Carolina | 37131 | 190 | 15 |
304778 | 304778 | 2020-07-05 | Onslow | North Carolina | 37133 | 345 | 3 |
304779 | 304779 | 2020-07-05 | Orange | North Carolina | 37135 | 813 | 42 |
304780 | 304780 | 2020-07-05 | Pamlico | North Carolina | 37137 | 25 | 0 |
304781 | 304781 | 2020-07-05 | Pasquotank | North Carolina | 37139 | 220 | 17 |
304782 | 304782 | 2020-07-05 | Pender | North Carolina | 37141 | 298 | 2 |
304783 | 304783 | 2020-07-05 | Perquimans | North Carolina | 37143 | 37 | 2 |
304784 | 304784 | 2020-07-05 | Person | North Carolina | 37145 | 117 | 1 |
304785 | 304785 | 2020-07-05 | Pitt | North Carolina | 37147 | 804 | 6 |
304786 | 304786 | 2020-07-05 | Polk | North Carolina | 37149 | 79 | 4 |
304787 | 304787 | 2020-07-05 | Randolph | North Carolina | 37151 | 1295 | 31 |
304788 | 304788 | 2020-07-05 | Richmond | North Carolina | 37153 | 320 | 7 |
304789 | 304789 | 2020-07-05 | Robeson | North Carolina | 37155 | 1332 | 39 |
304790 | 304790 | 2020-07-05 | Rockingham | North Carolina | 37157 | 261 | 2 |
304791 | 304791 | 2020-07-05 | Rowan | North Carolina | 37159 | 1325 | 43 |
304792 | 304792 | 2020-07-05 | Rutherford | North Carolina | 37161 | 328 | 10 |
304793 | 304793 | 2020-07-05 | Sampson | North Carolina | 37163 | 1100 | 6 |
304794 | 304794 | 2020-07-05 | Scotland | North Carolina | 37165 | 149 | 2 |
304795 | 304795 | 2020-07-05 | Stanly | North Carolina | 37167 | 468 | 5 |
304796 | 304796 | 2020-07-05 | Stokes | North Carolina | 37169 | 139 | 1 |
304797 | 304797 | 2020-07-05 | Surry | North Carolina | 37171 | 503 | 2 |
304798 | 304798 | 2020-07-05 | Swain | North Carolina | 37173 | 59 | 1 |
304799 | 304799 | 2020-07-05 | Transylvania | North Carolina | 37175 | 30 | 1 |
304800 | 304800 | 2020-07-05 | Tyrrell | North Carolina | 37177 | 13 | 0 |
304801 | 304801 | 2020-07-05 | Union | North Carolina | 37179 | 1452 | 25 |
304802 | 304802 | 2020-07-05 | Vance | North Carolina | 37181 | 526 | 38 |
304803 | 304803 | 2020-07-05 | Wake | North Carolina | 37183 | 5980 | 49 |
304804 | 304804 | 2020-07-05 | Warren | North Carolina | 37185 | 171 | 5 |
304805 | 304805 | 2020-07-05 | Washington | North Carolina | 37187 | 41 | 3 |
304806 | 304806 | 2020-07-05 | Watauga | North Carolina | 37189 | 93 | 0 |
304807 | 304807 | 2020-07-05 | Wayne | North Carolina | 37191 | 1897 | 28 |
304808 | 304808 | 2020-07-05 | Wilkes | North Carolina | 37193 | 589 | 6 |
304809 | 304809 | 2020-07-05 | Wilson | North Carolina | 37195 | 764 | 19 |
304810 | 304810 | 2020-07-05 | Yadkin | North Carolina | 37197 | 341 | 5 |
304811 | 304811 | 2020-07-05 | Yancey | North Carolina | 37199 | 49 | 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);