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-12-15 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 |
---|---|---|---|---|---|---|---|
2016765 | 2016765 | 2021-12-15 | Alamance | North Carolina | 37001 | 28407 | 371 |
2016766 | 2016766 | 2021-12-15 | Alexander | North Carolina | 37003 | 7007 | 119 |
2016767 | 2016767 | 2021-12-15 | Alleghany | North Carolina | 37005 | 1962 | 6 |
2016768 | 2016768 | 2021-12-15 | Anson | North Carolina | 37007 | 4104 | 84 |
2016769 | 2016769 | 2021-12-15 | Ashe | North Carolina | 37009 | 3868 | 57 |
2016770 | 2016770 | 2021-12-15 | Avery | North Carolina | 37011 | 2958 | 39 |
2016771 | 2016771 | 2021-12-15 | Beaufort | North Carolina | 37013 | 7696 | 137 |
2016772 | 2016772 | 2021-12-15 | Bertie | North Carolina | 37015 | 2609 | 53 |
2016773 | 2016773 | 2021-12-15 | Bladen | North Carolina | 37017 | 5749 | 95 |
2016774 | 2016774 | 2021-12-15 | Brunswick | North Carolina | 37019 | 17509 | 249 |
2016775 | 2016775 | 2021-12-15 | Buncombe | North Carolina | 37021 | 30961 | 452 |
2016776 | 2016776 | 2021-12-15 | Burke | North Carolina | 37023 | 16532 | 248 |
2016777 | 2016777 | 2021-12-15 | Cabarrus | North Carolina | 37025 | 35498 | 357 |
2016778 | 2016778 | 2021-12-15 | Caldwell | North Carolina | 37027 | 14247 | 230 |
2016779 | 2016779 | 2021-12-15 | Camden | North Carolina | 37029 | 1272 | 9 |
2016780 | 2016780 | 2021-12-15 | Carteret | North Carolina | 37031 | 8887 | 83 |
2016781 | 2016781 | 2021-12-15 | Caswell | North Carolina | 37033 | 3416 | 39 |
2016782 | 2016782 | 2021-12-15 | Catawba | North Carolina | 37035 | 30242 | 453 |
2016783 | 2016783 | 2021-12-15 | Chatham | North Carolina | 37037 | 7277 | 99 |
2016784 | 2016784 | 2021-12-15 | Cherokee | North Carolina | 37039 | 4854 | 86 |
2016785 | 2016785 | 2021-12-15 | Chowan | North Carolina | 37041 | 2411 | 44 |
2016786 | 2016786 | 2021-12-15 | Clay | North Carolina | 37043 | 1736 | 38 |
2016787 | 2016787 | 2021-12-15 | Cleveland | North Carolina | 37045 | 19379 | 318 |
2016788 | 2016788 | 2021-12-15 | Columbus | North Carolina | 37047 | 10493 | 232 |
2016789 | 2016789 | 2021-12-15 | Craven | North Carolina | 37049 | 14909 | 162 |
2016790 | 2016790 | 2021-12-15 | Cumberland | North Carolina | 37051 | 49314 | 500 |
2016791 | 2016791 | 2021-12-15 | Currituck | North Carolina | 37053 | 3137 | 27 |
2016792 | 2016792 | 2021-12-15 | Dare | North Carolina | 37055 | 4367 | 15 |
2016793 | 2016793 | 2021-12-15 | Davidson | North Carolina | 37057 | 27892 | 328 |
2016794 | 2016794 | 2021-12-15 | Davie | North Carolina | 37059 | 7087 | 82 |
2016795 | 2016795 | 2021-12-15 | Duplin | North Carolina | 37061 | 10475 | 199 |
2016796 | 2016796 | 2021-12-15 | Durham | North Carolina | 37063 | 37112 | 267 |
2016797 | 2016797 | 2021-12-15 | Edgecombe | North Carolina | 37065 | 8291 | 127 |
2016798 | 2016798 | 2021-12-15 | Forsyth | North Carolina | 37067 | 55970 | 595 |
2016799 | 2016799 | 2021-12-15 | Franklin | North Carolina | 37069 | 10645 | 64 |
2016800 | 2016800 | 2021-12-15 | Gaston | North Carolina | 37071 | 43127 | 640 |
2016801 | 2016801 | 2021-12-15 | Gates | North Carolina | 37073 | 1179 | 18 |
2016802 | 2016802 | 2021-12-15 | Graham | North Carolina | 37075 | 1404 | 28 |
2016803 | 2016803 | 2021-12-15 | Granville | North Carolina | 37077 | 8532 | 106 |
2016804 | 2016804 | 2021-12-15 | Greene | North Carolina | 37079 | 3468 | 56 |
2016805 | 2016805 | 2021-12-15 | Guilford | North Carolina | 37081 | 72787 | 932 |
2016806 | 2016806 | 2021-12-15 | Halifax | North Carolina | 37083 | 8151 | 145 |
2016807 | 2016807 | 2021-12-15 | Harnett | North Carolina | 37085 | 19561 | 274 |
2016808 | 2016808 | 2021-12-15 | Haywood | North Carolina | 37087 | 8202 | 155 |
2016809 | 2016809 | 2021-12-15 | Henderson | North Carolina | 37089 | 16731 | 219 |
2016810 | 2016810 | 2021-12-15 | Hertford | North Carolina | 37091 | 2939 | 73 |
2016811 | 2016811 | 2021-12-15 | Hoke | North Carolina | 37093 | 7676 | 91 |
2016812 | 2016812 | 2021-12-15 | Hyde | North Carolina | 37095 | 868 | 12 |
2016813 | 2016813 | 2021-12-15 | Iredell | North Carolina | 37097 | 31479 | 336 |
2016814 | 2016814 | 2021-12-15 | Jackson | North Carolina | 37099 | 6103 | 73 |
2016815 | 2016815 | 2021-12-15 | Johnston | North Carolina | 37101 | 34687 | 344 |
2016816 | 2016816 | 2021-12-15 | Jones | North Carolina | 37103 | 1402 | 36 |
2016817 | 2016817 | 2021-12-15 | Lee | North Carolina | 37105 | 9847 | 113 |
2016818 | 2016818 | 2021-12-15 | Lenoir | North Carolina | 37107 | 9907 | 179 |
2016819 | 2016819 | 2021-12-15 | Lincoln | North Carolina | 37109 | 16348 | 118 |
2016820 | 2016820 | 2021-12-15 | Macon | North Carolina | 37113 | 5226 | 86 |
2016821 | 2016821 | 2021-12-15 | Madison | North Carolina | 37115 | 3038 | 66 |
2016822 | 2016822 | 2021-12-15 | Martin | North Carolina | 37117 | 3825 | 75 |
2016823 | 2016823 | 2021-12-15 | McDowell | North Carolina | 37111 | 9011 | 138 |
2016824 | 2016824 | 2021-12-15 | Mecklenburg | North Carolina | 37119 | 166875 | 1299 |
2016825 | 2016825 | 2021-12-15 | Mitchell | North Carolina | 37121 | 2276 | 24 |
2016826 | 2016826 | 2021-12-15 | Montgomery | North Carolina | 37123 | 4776 | 110 |
2016827 | 2016827 | 2021-12-15 | Moore | North Carolina | 37125 | 14399 | 255 |
2016828 | 2016828 | 2021-12-15 | Nash | North Carolina | 37127 | 15930 | 240 |
2016829 | 2016829 | 2021-12-15 | New Hanover | North Carolina | 37129 | 29880 | 298 |
2016830 | 2016830 | 2021-12-15 | Northampton | North Carolina | 37131 | 2662 | 66 |
2016831 | 2016831 | 2021-12-15 | Onslow | North Carolina | 37133 | 31080 | 275 |
2016832 | 2016832 | 2021-12-15 | Orange | North Carolina | 37135 | 12618 | 111 |
2016833 | 2016833 | 2021-12-15 | Pamlico | North Carolina | 37137 | 1781 | 26 |
2016834 | 2016834 | 2021-12-15 | Pasquotank | North Carolina | 37139 | 5662 | 110 |
2016835 | 2016835 | 2021-12-15 | Pender | North Carolina | 37141 | 9422 | 102 |
2016836 | 2016836 | 2021-12-15 | Perquimans | North Carolina | 37143 | 1743 | 16 |
2016837 | 2016837 | 2021-12-15 | Person | North Carolina | 37145 | 5609 | 91 |
2016838 | 2016838 | 2021-12-15 | Pitt | North Carolina | 37147 | 31222 | 146 |
2016839 | 2016839 | 2021-12-15 | Polk | North Carolina | 37149 | 2480 | 49 |
2016840 | 2016840 | 2021-12-15 | Randolph | North Carolina | 37151 | 23430 | 334 |
2016841 | 2016841 | 2021-12-15 | Richmond | North Carolina | 37153 | 7557 | 150 |
2016842 | 2016842 | 2021-12-15 | Robeson | North Carolina | 37155 | 26063 | 449 |
2016843 | 2016843 | 2021-12-15 | Rockingham | North Carolina | 37157 | 13612 | 218 |
2016844 | 2016844 | 2021-12-15 | Rowan | North Carolina | 37159 | 27818 | 485 |
2016845 | 2016845 | 2021-12-15 | Rutherford | North Carolina | 37161 | 11966 | 344 |
2016846 | 2016846 | 2021-12-15 | Sampson | North Carolina | 37163 | 11817 | 141 |
2016847 | 2016847 | 2021-12-15 | Scotland | North Carolina | 37165 | 5974 | 109 |
2016848 | 2016848 | 2021-12-15 | Stanly | North Carolina | 37167 | 12574 | 206 |
2016849 | 2016849 | 2021-12-15 | Stokes | North Carolina | 37169 | 7091 | 118 |
2016850 | 2016850 | 2021-12-15 | Surry | North Carolina | 37171 | 13746 | 250 |
2016851 | 2016851 | 2021-12-15 | Swain | North Carolina | 37173 | 2205 | 28 |
2016852 | 2016852 | 2021-12-15 | Transylvania | North Carolina | 37175 | 4147 | 52 |
2016853 | 2016853 | 2021-12-15 | Tyrrell | North Carolina | 37177 | 600 | 7 |
2016854 | 2016854 | 2021-12-15 | Union | North Carolina | 37179 | 39388 | 378 |
2016855 | 2016855 | 2021-12-15 | Vance | North Carolina | 37181 | 7281 | 104 |
2016856 | 2016856 | 2021-12-15 | Wake | North Carolina | 37183 | 138937 | 913 |
2016857 | 2016857 | 2021-12-15 | Warren | North Carolina | 37185 | 2554 | 34 |
2016858 | 2016858 | 2021-12-15 | Washington | North Carolina | 37187 | 1675 | 37 |
2016859 | 2016859 | 2021-12-15 | Watauga | North Carolina | 37189 | 7167 | 42 |
2016860 | 2016860 | 2021-12-15 | Wayne | North Carolina | 37191 | 18151 | 329 |
2016861 | 2016861 | 2021-12-15 | Wilkes | North Carolina | 37193 | 11483 | 196 |
2016862 | 2016862 | 2021-12-15 | Wilson | North Carolina | 37195 | 13791 | 243 |
2016863 | 2016863 | 2021-12-15 | Yadkin | North Carolina | 37197 | 6763 | 82 |
2016864 | 2016864 | 2021-12-15 | Yancey | North Carolina | 37199 | 3217 | 36 |
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);