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 2021-02-03 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 |
---|---|---|---|---|---|---|---|
993742 | 993742 | 2021-02-03 | Alamance | North Carolina | 37001 | 14163 | 173 |
993743 | 993743 | 2021-02-03 | Alexander | North Carolina | 37003 | 3589 | 59 |
993744 | 993744 | 2021-02-03 | Alleghany | North Carolina | 37005 | 844 | 4 |
993745 | 993745 | 2021-02-03 | Anson | North Carolina | 37007 | 2104 | 44 |
993746 | 993746 | 2021-02-03 | Ashe | North Carolina | 37009 | 1706 | 34 |
993747 | 993747 | 2021-02-03 | Avery | North Carolina | 37011 | 1690 | 16 |
993748 | 993748 | 2021-02-03 | Beaufort | North Carolina | 37013 | 3860 | 72 |
993749 | 993749 | 2021-02-03 | Bertie | North Carolina | 37015 | 1545 | 35 |
993750 | 993750 | 2021-02-03 | Bladen | North Carolina | 37017 | 2672 | 34 |
993751 | 993751 | 2021-02-03 | Brunswick | North Carolina | 37019 | 6788 | 102 |
993752 | 993752 | 2021-02-03 | Buncombe | North Carolina | 37021 | 13774 | 266 |
993753 | 993753 | 2021-02-03 | Burke | North Carolina | 37023 | 8590 | 112 |
993754 | 993754 | 2021-02-03 | Cabarrus | North Carolina | 37025 | 16577 | 201 |
993755 | 993755 | 2021-02-03 | Caldwell | North Carolina | 37027 | 8037 | 45 |
993756 | 993756 | 2021-02-03 | Camden | North Carolina | 37029 | 474 | 5 |
993757 | 993757 | 2021-02-03 | Carteret | North Carolina | 37031 | 3906 | 19 |
993758 | 993758 | 2021-02-03 | Caswell | North Carolina | 37033 | 1773 | 15 |
993759 | 993759 | 2021-02-03 | Catawba | North Carolina | 37035 | 15980 | 246 |
993760 | 993760 | 2021-02-03 | Chatham | North Carolina | 37037 | 3823 | 70 |
993761 | 993761 | 2021-02-03 | Cherokee | North Carolina | 37039 | 1895 | 17 |
993762 | 993762 | 2021-02-03 | Chowan | North Carolina | 37041 | 1236 | 21 |
993763 | 993763 | 2021-02-03 | Clay | North Carolina | 37043 | 602 | 5 |
993764 | 993764 | 2021-02-03 | Cleveland | North Carolina | 37045 | 9460 | 192 |
993765 | 993765 | 2021-02-03 | Columbus | North Carolina | 37047 | 5277 | 123 |
993766 | 993766 | 2021-02-03 | Craven | North Carolina | 37049 | 7322 | 108 |
993767 | 993767 | 2021-02-03 | Cumberland | North Carolina | 37051 | 21049 | 218 |
993768 | 993768 | 2021-02-03 | Currituck | North Carolina | 37053 | 1130 | 14 |
993769 | 993769 | 2021-02-03 | Dare | North Carolina | 37055 | 1719 | 6 |
993770 | 993770 | 2021-02-03 | Davidson | North Carolina | 37057 | 13289 | 131 |
993771 | 993771 | 2021-02-03 | Davie | North Carolina | 37059 | 3082 | 20 |
993772 | 993772 | 2021-02-03 | Duplin | North Carolina | 37061 | 5331 | 116 |
993773 | 993773 | 2021-02-03 | Durham | North Carolina | 37063 | 20304 | 189 |
993774 | 993774 | 2021-02-03 | Edgecombe | North Carolina | 37065 | 4124 | 92 |
993775 | 993775 | 2021-02-03 | Forsyth | North Carolina | 37067 | 28501 | 283 |
993776 | 993776 | 2021-02-03 | Franklin | North Carolina | 37069 | 4737 | 41 |
993777 | 993777 | 2021-02-03 | Gaston | North Carolina | 37071 | 21681 | 328 |
993778 | 993778 | 2021-02-03 | Gates | North Carolina | 37073 | 556 | 12 |
993779 | 993779 | 2021-02-03 | Graham | North Carolina | 37075 | 533 | 12 |
993780 | 993780 | 2021-02-03 | Granville | North Carolina | 37077 | 4805 | 74 |
993781 | 993781 | 2021-02-03 | Greene | North Carolina | 37079 | 1995 | 35 |
993782 | 993782 | 2021-02-03 | Guilford | North Carolina | 37081 | 36020 | 425 |
993783 | 993783 | 2021-02-03 | Halifax | North Carolina | 37083 | 4622 | 83 |
993784 | 993784 | 2021-02-03 | Harnett | North Carolina | 37085 | 8547 | 119 |
993785 | 993785 | 2021-02-03 | Haywood | North Carolina | 37087 | 3436 | 79 |
993786 | 993786 | 2021-02-03 | Henderson | North Carolina | 37089 | 7955 | 127 |
993787 | 993787 | 2021-02-03 | Hertford | North Carolina | 37091 | 1819 | 55 |
993788 | 993788 | 2021-02-03 | Hoke | North Carolina | 37093 | 3733 | 48 |
993789 | 993789 | 2021-02-03 | Hyde | North Carolina | 37095 | 594 | 6 |
993790 | 993790 | 2021-02-03 | Iredell | North Carolina | 37097 | 14745 | 163 |
993791 | 993791 | 2021-02-03 | Jackson | North Carolina | 37099 | 3045 | 46 |
993792 | 993792 | 2021-02-03 | Johnston | North Carolina | 37101 | 16242 | 168 |
993793 | 993793 | 2021-02-03 | Jones | North Carolina | 37103 | 607 | 16 |
993794 | 993794 | 2021-02-03 | Lee | North Carolina | 37105 | 4954 | 58 |
993795 | 993795 | 2021-02-03 | Lenoir | North Carolina | 37107 | 4808 | 96 |
993796 | 993796 | 2021-02-03 | Lincoln | North Carolina | 37109 | 8006 | 54 |
993797 | 993797 | 2021-02-03 | Macon | North Carolina | 37113 | 2298 | 12 |
993798 | 993798 | 2021-02-03 | Madison | North Carolina | 37115 | 1234 | 30 |
993799 | 993799 | 2021-02-03 | Martin | North Carolina | 37117 | 1896 | 30 |
993800 | 993800 | 2021-02-03 | McDowell | North Carolina | 37111 | 4380 | 52 |
993801 | 993801 | 2021-02-03 | Mecklenburg | North Carolina | 37119 | 88055 | 794 |
993802 | 993802 | 2021-02-03 | Mitchell | North Carolina | 37121 | 1174 | 14 |
993803 | 993803 | 2021-02-03 | Montgomery | North Carolina | 37123 | 2767 | 70 |
993804 | 993804 | 2021-02-03 | Moore | North Carolina | 37125 | 7201 | 131 |
993805 | 993805 | 2021-02-03 | Nash | North Carolina | 37127 | 8656 | 143 |
993806 | 993806 | 2021-02-03 | New Hanover | North Carolina | 37129 | 14060 | 131 |
993807 | 993807 | 2021-02-03 | Northampton | North Carolina | 37131 | 1589 | 27 |
993808 | 993808 | 2021-02-03 | Onslow | North Carolina | 37133 | 13351 | 115 |
993809 | 993809 | 2021-02-03 | Orange | North Carolina | 37135 | 6949 | 83 |
993810 | 993810 | 2021-02-03 | Pamlico | North Carolina | 37137 | 776 | 8 |
993811 | 993811 | 2021-02-03 | Pasquotank | North Carolina | 37139 | 2742 | 74 |
993812 | 993812 | 2021-02-03 | Pender | North Carolina | 37141 | 4159 | 48 |
993813 | 993813 | 2021-02-03 | Perquimans | North Carolina | 37143 | 778 | 5 |
993814 | 993814 | 2021-02-03 | Person | North Carolina | 37145 | 2578 | 51 |
993815 | 993815 | 2021-02-03 | Pitt | North Carolina | 37147 | 15718 | 72 |
993816 | 993816 | 2021-02-03 | Polk | North Carolina | 37149 | 1216 | 19 |
993817 | 993817 | 2021-02-03 | Randolph | North Carolina | 37151 | 11700 | 186 |
993818 | 993818 | 2021-02-03 | Richmond | North Carolina | 37153 | 3789 | 74 |
993819 | 993819 | 2021-02-03 | Robeson | North Carolina | 37155 | 13585 | 183 |
993820 | 993820 | 2021-02-03 | Rockingham | North Carolina | 37157 | 6313 | 43 |
993821 | 993821 | 2021-02-03 | Rowan | North Carolina | 37159 | 13464 | 252 |
993822 | 993822 | 2021-02-03 | Rutherford | North Carolina | 37161 | 6299 | 176 |
993823 | 993823 | 2021-02-03 | Sampson | North Carolina | 37163 | 6182 | 80 |
993824 | 993824 | 2021-02-03 | Scotland | North Carolina | 37165 | 3216 | 66 |
993825 | 993825 | 2021-02-03 | Stanly | North Carolina | 37167 | 6098 | 96 |
993826 | 993826 | 2021-02-03 | Stokes | North Carolina | 37169 | 3245 | 57 |
993827 | 993827 | 2021-02-03 | Surry | North Carolina | 37171 | 6437 | 112 |
993828 | 993828 | 2021-02-03 | Swain | North Carolina | 37173 | 1078 | 15 |
993829 | 993829 | 2021-02-03 | Transylvania | North Carolina | 37175 | 1659 | 17 |
993830 | 993830 | 2021-02-03 | Tyrrell | North Carolina | 37177 | 268 | 6 |
993831 | 993831 | 2021-02-03 | Union | North Carolina | 37179 | 18714 | 159 |
993832 | 993832 | 2021-02-03 | Vance | North Carolina | 37181 | 3815 | 75 |
993833 | 993833 | 2021-02-03 | Wake | North Carolina | 37183 | 66901 | 444 |
993834 | 993834 | 2021-02-03 | Warren | North Carolina | 37185 | 1464 | 14 |
993835 | 993835 | 2021-02-03 | Washington | North Carolina | 37187 | 810 | 23 |
993836 | 993836 | 2021-02-03 | Watauga | North Carolina | 37189 | 3465 | 24 |
993837 | 993837 | 2021-02-03 | Wayne | North Carolina | 37191 | 9517 | 187 |
993838 | 993838 | 2021-02-03 | Wilkes | North Carolina | 37193 | 5497 | 91 |
993839 | 993839 | 2021-02-03 | Wilson | North Carolina | 37195 | 7628 | 141 |
993840 | 993840 | 2021-02-03 | Yadkin | North Carolina | 37197 | 3348 | 40 |
993841 | 993841 | 2021-02-03 | Yancey | North Carolina | 37199 | 1346 | 23 |
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);