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-10-28 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 |
---|---|---|---|---|---|---|---|
1860760 | 1860760 | 2021-10-28 | Alamance | North Carolina | 37001 | 26347 | 338 |
1860761 | 1860761 | 2021-10-28 | Alexander | North Carolina | 37003 | 6455 | 117 |
1860762 | 1860762 | 2021-10-28 | Alleghany | North Carolina | 37005 | 1614 | 6 |
1860763 | 1860763 | 2021-10-28 | Anson | North Carolina | 37007 | 3848 | 80 |
1860764 | 1860764 | 2021-10-28 | Ashe | North Carolina | 37009 | 3441 | 49 |
1860765 | 1860765 | 2021-10-28 | Avery | North Carolina | 37011 | 2746 | 35 |
1860766 | 1860766 | 2021-10-28 | Beaufort | North Carolina | 37013 | 7142 | 126 |
1860767 | 1860767 | 2021-10-28 | Bertie | North Carolina | 37015 | 2474 | 52 |
1860768 | 1860768 | 2021-10-28 | Bladen | North Carolina | 37017 | 5469 | 95 |
1860769 | 1860769 | 2021-10-28 | Brunswick | North Carolina | 37019 | 16265 | 236 |
1860770 | 1860770 | 2021-10-28 | Buncombe | North Carolina | 37021 | 28138 | 431 |
1860771 | 1860771 | 2021-10-28 | Burke | North Carolina | 37023 | 15737 | 238 |
1860772 | 1860772 | 2021-10-28 | Cabarrus | North Carolina | 37025 | 32813 | 337 |
1860773 | 1860773 | 2021-10-28 | Caldwell | North Carolina | 37027 | 13341 | 214 |
1860774 | 1860774 | 2021-10-28 | Camden | North Carolina | 37029 | 1140 | 8 |
1860775 | 1860775 | 2021-10-28 | Carteret | North Carolina | 37031 | 8362 | 83 |
1860776 | 1860776 | 2021-10-28 | Caswell | North Carolina | 37033 | 3194 | 37 |
1860777 | 1860777 | 2021-10-28 | Catawba | North Carolina | 37035 | 28302 | 425 |
1860778 | 1860778 | 2021-10-28 | Chatham | North Carolina | 37037 | 6761 | 91 |
1860779 | 1860779 | 2021-10-28 | Cherokee | North Carolina | 37039 | 4643 | 75 |
1860780 | 1860780 | 2021-10-28 | Chowan | North Carolina | 37041 | 2294 | 41 |
1860781 | 1860781 | 2021-10-28 | Clay | North Carolina | 37043 | 1654 | 36 |
1860782 | 1860782 | 2021-10-28 | Cleveland | North Carolina | 37045 | 18356 | 309 |
1860783 | 1860783 | 2021-10-28 | Columbus | North Carolina | 37047 | 10078 | 226 |
1860784 | 1860784 | 2021-10-28 | Craven | North Carolina | 37049 | 14272 | 157 |
1860785 | 1860785 | 2021-10-28 | Cumberland | North Carolina | 37051 | 45521 | 464 |
1860786 | 1860786 | 2021-10-28 | Currituck | North Carolina | 37053 | 2739 | 27 |
1860787 | 1860787 | 2021-10-28 | Dare | North Carolina | 37055 | 3844 | 13 |
1860788 | 1860788 | 2021-10-28 | Davidson | North Carolina | 37057 | 25746 | 307 |
1860789 | 1860789 | 2021-10-28 | Davie | North Carolina | 37059 | 6421 | 76 |
1860790 | 1860790 | 2021-10-28 | Duplin | North Carolina | 37061 | 9960 | 182 |
1860791 | 1860791 | 2021-10-28 | Durham | North Carolina | 37063 | 35007 | 259 |
1860792 | 1860792 | 2021-10-28 | Edgecombe | North Carolina | 37065 | 7939 | 125 |
1860793 | 1860793 | 2021-10-28 | Forsyth | North Carolina | 37067 | 51712 | 562 |
1860794 | 1860794 | 2021-10-28 | Franklin | North Carolina | 37069 | 9896 | 61 |
1860795 | 1860795 | 2021-10-28 | Gaston | North Carolina | 37071 | 39978 | 621 |
1860796 | 1860796 | 2021-10-28 | Gates | North Carolina | 37073 | 1087 | 19 |
1860797 | 1860797 | 2021-10-28 | Graham | North Carolina | 37075 | 1330 | 28 |
1860798 | 1860798 | 2021-10-28 | Granville | North Carolina | 37077 | 7932 | 99 |
1860799 | 1860799 | 2021-10-28 | Greene | North Carolina | 37079 | 3318 | 56 |
1860800 | 1860800 | 2021-10-28 | Guilford | North Carolina | 37081 | 67832 | 870 |
1860801 | 1860801 | 2021-10-28 | Halifax | North Carolina | 37083 | 7898 | 139 |
1860802 | 1860802 | 2021-10-28 | Harnett | North Carolina | 37085 | 18442 | 253 |
1860803 | 1860803 | 2021-10-28 | Haywood | North Carolina | 37087 | 7452 | 141 |
1860804 | 1860804 | 2021-10-28 | Henderson | North Carolina | 37089 | 15197 | 204 |
1860805 | 1860805 | 2021-10-28 | Hertford | North Carolina | 37091 | 2852 | 71 |
1860806 | 1860806 | 2021-10-28 | Hoke | North Carolina | 37093 | 7133 | 83 |
1860807 | 1860807 | 2021-10-28 | Hyde | North Carolina | 37095 | 825 | 12 |
1860808 | 1860808 | 2021-10-28 | Iredell | North Carolina | 37097 | 28838 | 323 |
1860809 | 1860809 | 2021-10-28 | Jackson | North Carolina | 37099 | 5643 | 71 |
1860810 | 1860810 | 2021-10-28 | Johnston | North Carolina | 37101 | 32391 | 329 |
1860811 | 1860811 | 2021-10-28 | Jones | North Carolina | 37103 | 1343 | 34 |
1860812 | 1860812 | 2021-10-28 | Lee | North Carolina | 37105 | 9419 | 109 |
1860813 | 1860813 | 2021-10-28 | Lenoir | North Carolina | 37107 | 9468 | 156 |
1860814 | 1860814 | 2021-10-28 | Lincoln | North Carolina | 37109 | 14969 | 107 |
1860815 | 1860815 | 2021-10-28 | Macon | North Carolina | 37113 | 4962 | 69 |
1860816 | 1860816 | 2021-10-28 | Madison | North Carolina | 37115 | 2780 | 60 |
1860817 | 1860817 | 2021-10-28 | Martin | North Carolina | 37117 | 3645 | 73 |
1860818 | 1860818 | 2021-10-28 | McDowell | North Carolina | 37111 | 8636 | 126 |
1860819 | 1860819 | 2021-10-28 | Mecklenburg | North Carolina | 37119 | 157039 | 1239 |
1860820 | 1860820 | 2021-10-28 | Mitchell | North Carolina | 37121 | 2053 | 21 |
1860821 | 1860821 | 2021-10-28 | Montgomery | North Carolina | 37123 | 4539 | 108 |
1860822 | 1860822 | 2021-10-28 | Moore | North Carolina | 37125 | 13647 | 246 |
1860823 | 1860823 | 2021-10-28 | Nash | North Carolina | 37127 | 15234 | 233 |
1860824 | 1860824 | 2021-10-28 | New Hanover | North Carolina | 37129 | 28679 | 289 |
1860825 | 1860825 | 2021-10-28 | Northampton | North Carolina | 37131 | 2601 | 65 |
1860826 | 1860826 | 2021-10-28 | Onslow | North Carolina | 37133 | 29459 | 259 |
1860827 | 1860827 | 2021-10-28 | Orange | North Carolina | 37135 | 11829 | 110 |
1860828 | 1860828 | 2021-10-28 | Pamlico | North Carolina | 37137 | 1717 | 26 |
1860829 | 1860829 | 2021-10-28 | Pasquotank | North Carolina | 37139 | 5238 | 102 |
1860830 | 1860830 | 2021-10-28 | Pender | North Carolina | 37141 | 8801 | 100 |
1860831 | 1860831 | 2021-10-28 | Perquimans | North Carolina | 37143 | 1551 | 15 |
1860832 | 1860832 | 2021-10-28 | Person | North Carolina | 37145 | 5097 | 87 |
1860833 | 1860833 | 2021-10-28 | Pitt | North Carolina | 37147 | 29672 | 143 |
1860834 | 1860834 | 2021-10-28 | Polk | North Carolina | 37149 | 2331 | 44 |
1860835 | 1860835 | 2021-10-28 | Randolph | North Carolina | 37151 | 21830 | 313 |
1860836 | 1860836 | 2021-10-28 | Richmond | North Carolina | 37153 | 7115 | 140 |
1860837 | 1860837 | 2021-10-28 | Robeson | North Carolina | 37155 | 24952 | 426 |
1860838 | 1860838 | 2021-10-28 | Rockingham | North Carolina | 37157 | 12160 | 193 |
1860839 | 1860839 | 2021-10-28 | Rowan | North Carolina | 37159 | 26195 | 453 |
1860840 | 1860840 | 2021-10-28 | Rutherford | North Carolina | 37161 | 11427 | 316 |
1860841 | 1860841 | 2021-10-28 | Sampson | North Carolina | 37163 | 11277 | 135 |
1860842 | 1860842 | 2021-10-28 | Scotland | North Carolina | 37165 | 5717 | 107 |
1860843 | 1860843 | 2021-10-28 | Stanly | North Carolina | 37167 | 11623 | 191 |
1860844 | 1860844 | 2021-10-28 | Stokes | North Carolina | 37169 | 6241 | 108 |
1860845 | 1860845 | 2021-10-28 | Surry | North Carolina | 37171 | 12407 | 227 |
1860846 | 1860846 | 2021-10-28 | Swain | North Carolina | 37173 | 1966 | 24 |
1860847 | 1860847 | 2021-10-28 | Transylvania | North Carolina | 37175 | 3886 | 48 |
1860848 | 1860848 | 2021-10-28 | Tyrrell | North Carolina | 37177 | 551 | 7 |
1860849 | 1860849 | 2021-10-28 | Union | North Carolina | 37179 | 36331 | 335 |
1860850 | 1860850 | 2021-10-28 | Vance | North Carolina | 37181 | 6826 | 101 |
1860851 | 1860851 | 2021-10-28 | Wake | North Carolina | 37183 | 130869 | 895 |
1860852 | 1860852 | 2021-10-28 | Warren | North Carolina | 37185 | 2384 | 31 |
1860853 | 1860853 | 2021-10-28 | Washington | North Carolina | 37187 | 1587 | 37 |
1860854 | 1860854 | 2021-10-28 | Watauga | North Carolina | 37189 | 6631 | 38 |
1860855 | 1860855 | 2021-10-28 | Wayne | North Carolina | 37191 | 16358 | 300 |
1860856 | 1860856 | 2021-10-28 | Wilkes | North Carolina | 37193 | 10556 | 181 |
1860857 | 1860857 | 2021-10-28 | Wilson | North Carolina | 37195 | 13221 | 232 |
1860858 | 1860858 | 2021-10-28 | Yadkin | North Carolina | 37197 | 5995 | 73 |
1860859 | 1860859 | 2021-10-28 | Yancey | North Carolina | 37199 | 2800 | 32 |
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);