ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2021-09-10" 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 |
---|---|---|---|---|---|---|---|
1704810 | 1704810 | 2021-09-10 | Alamance | North Carolina | 37001 | 22767 | 306 |
1704811 | 1704811 | 2021-09-10 | Alexander | North Carolina | 37003 | 5622 | 98 |
1704812 | 1704812 | 2021-09-10 | Alleghany | North Carolina | 37005 | 1336 | 5 |
1704813 | 1704813 | 2021-09-10 | Anson | North Carolina | 37007 | 3277 | 63 |
1704814 | 1704814 | 2021-09-10 | Ashe | North Carolina | 37009 | 2891 | 45 |
1704815 | 1704815 | 2021-09-10 | Avery | North Carolina | 37011 | 2406 | 26 |
1704816 | 1704816 | 2021-09-10 | Beaufort | North Carolina | 37013 | 5870 | 108 |
1704817 | 1704817 | 2021-09-10 | Bertie | North Carolina | 37015 | 2169 | 46 |
1704818 | 1704818 | 2021-09-10 | Bladen | North Carolina | 37017 | 4970 | 88 |
1704819 | 1704819 | 2021-09-10 | Brunswick | North Carolina | 37019 | 13666 | 187 |
1704820 | 1704820 | 2021-09-10 | Buncombe | North Carolina | 37021 | 23387 | 369 |
1704821 | 1704821 | 2021-09-10 | Burke | North Carolina | 37023 | 13175 | 164 |
1704822 | 1704822 | 2021-09-10 | Cabarrus | North Carolina | 37025 | 28902 | 288 |
1704823 | 1704823 | 2021-09-10 | Caldwell | North Carolina | 37027 | 11483 | 111 |
1704824 | 1704824 | 2021-09-10 | Camden | North Carolina | 37029 | 859 | 8 |
1704825 | 1704825 | 2021-09-10 | Carteret | North Carolina | 37031 | 6900 | 58 |
1704826 | 1704826 | 2021-09-10 | Caswell | North Carolina | 37033 | 2660 | 31 |
1704827 | 1704827 | 2021-09-10 | Catawba | North Carolina | 37035 | 24669 | 349 |
1704828 | 1704828 | 2021-09-10 | Chatham | North Carolina | 37037 | 6055 | 91 |
1704829 | 1704829 | 2021-09-10 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1704830 | 1704830 | 2021-09-10 | Chowan | North Carolina | 37041 | 1893 | 38 |
1704831 | 1704831 | 2021-09-10 | Clay | North Carolina | 37043 | 1285 | 21 |
1704832 | 1704832 | 2021-09-10 | Cleveland | North Carolina | 37045 | 15311 | 256 |
1704833 | 1704833 | 2021-09-10 | Columbus | North Carolina | 37047 | 9180 | 192 |
1704834 | 1704834 | 2021-09-10 | Craven | North Carolina | 37049 | 12045 | 134 |
1704835 | 1704835 | 2021-09-10 | Cumberland | North Carolina | 37051 | 39208 | 402 |
1704836 | 1704836 | 2021-09-10 | Currituck | North Carolina | 37053 | 2158 | 19 |
1704837 | 1704837 | 2021-09-10 | Dare | North Carolina | 37055 | 3209 | 11 |
1704838 | 1704838 | 2021-09-10 | Davidson | North Carolina | 37057 | 22146 | 235 |
1704839 | 1704839 | 2021-09-10 | Davie | North Carolina | 37059 | 5325 | 54 |
1704840 | 1704840 | 2021-09-10 | Duplin | North Carolina | 37061 | 8613 | 154 |
1704841 | 1704841 | 2021-09-10 | Durham | North Carolina | 37063 | 31811 | 245 |
1704842 | 1704842 | 2021-09-10 | Edgecombe | North Carolina | 37065 | 6764 | 116 |
1704843 | 1704843 | 2021-09-10 | Forsyth | North Carolina | 37067 | 45059 | 474 |
1704844 | 1704844 | 2021-09-10 | Franklin | North Carolina | 37069 | 8520 | 56 |
1704845 | 1704845 | 2021-09-10 | Gaston | North Carolina | 37071 | 33993 | 489 |
1704846 | 1704846 | 2021-09-10 | Gates | North Carolina | 37073 | 893 | 14 |
1704847 | 1704847 | 2021-09-10 | Graham | North Carolina | 37075 | 1092 | 19 |
1704848 | 1704848 | 2021-09-10 | Granville | North Carolina | 37077 | 7017 | 93 |
1704849 | 1704849 | 2021-09-10 | Greene | North Carolina | 37079 | 2967 | 50 |
1704850 | 1704850 | 2021-09-10 | Guilford | North Carolina | 37081 | 58331 | 778 |
1704851 | 1704851 | 2021-09-10 | Halifax | North Carolina | 37083 | 6859 | 122 |
1704852 | 1704852 | 2021-09-10 | Harnett | North Carolina | 37085 | 15813 | 204 |
1704853 | 1704853 | 2021-09-10 | Haywood | North Carolina | 37087 | 6020 | 113 |
1704854 | 1704854 | 2021-09-10 | Henderson | North Carolina | 37089 | 13136 | 168 |
1704855 | 1704855 | 2021-09-10 | Hertford | North Carolina | 37091 | 2462 | 65 |
1704856 | 1704856 | 2021-09-10 | Hoke | North Carolina | 37093 | 6349 | 69 |
1704857 | 1704857 | 2021-09-10 | Hyde | North Carolina | 37095 | 754 | 9 |
1704858 | 1704858 | 2021-09-10 | Iredell | North Carolina | 37097 | 24780 | 265 |
1704859 | 1704859 | 2021-09-10 | Jackson | North Carolina | 37099 | 4709 | 62 |
1704860 | 1704860 | 2021-09-10 | Johnston | North Carolina | 37101 | 28690 | 265 |
1704861 | 1704861 | 2021-09-10 | Jones | North Carolina | 37103 | 1103 | 29 |
1704862 | 1704862 | 2021-09-10 | Lee | North Carolina | 37105 | 8164 | 91 |
1704863 | 1704863 | 2021-09-10 | Lenoir | North Carolina | 37107 | 8032 | 134 |
1704864 | 1704864 | 2021-09-10 | Lincoln | North Carolina | 37109 | 12772 | 91 |
1704865 | 1704865 | 2021-09-10 | Macon | North Carolina | 37113 | 4019 | 45 |
1704866 | 1704866 | 2021-09-10 | Madison | North Carolina | 37115 | 2245 | 49 |
1704867 | 1704867 | 2021-09-10 | Martin | North Carolina | 37117 | 3079 | 53 |
1704868 | 1704868 | 2021-09-10 | McDowell | North Carolina | 37111 | 7102 | 66 |
1704869 | 1704869 | 2021-09-10 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1704870 | 1704870 | 2021-09-10 | Mitchell | North Carolina | 37121 | 1764 | 17 |
1704871 | 1704871 | 2021-09-10 | Montgomery | North Carolina | 37123 | 4008 | 104 |
1704872 | 1704872 | 2021-09-10 | Moore | North Carolina | 37125 | 11824 | 221 |
1704873 | 1704873 | 2021-09-10 | Nash | North Carolina | 37127 | 13489 | 206 |
1704874 | 1704874 | 2021-09-10 | New Hanover | North Carolina | 37129 | 25581 | 214 |
1704875 | 1704875 | 2021-09-10 | Northampton | North Carolina | 37131 | 2222 | 62 |
1704876 | 1704876 | 2021-09-10 | Onslow | North Carolina | 37133 | 23624 | 192 |
1704877 | 1704877 | 2021-09-10 | Orange | North Carolina | 37135 | 10394 | 102 |
1704878 | 1704878 | 2021-09-10 | Pamlico | North Carolina | 37137 | 1381 | 14 |
1704879 | 1704879 | 2021-09-10 | Pasquotank | North Carolina | 37139 | 4123 | 92 |
1704880 | 1704880 | 2021-09-10 | Pender | North Carolina | 37141 | 7591 | 81 |
1704881 | 1704881 | 2021-09-10 | Perquimans | North Carolina | 37143 | 1281 | 11 |
1704882 | 1704882 | 2021-09-10 | Person | North Carolina | 37145 | 4322 | 77 |
1704883 | 1704883 | 2021-09-10 | Pitt | North Carolina | 37147 | 25706 | 122 |
1704884 | 1704884 | 2021-09-10 | Polk | North Carolina | 37149 | 1959 | 36 |
1704885 | 1704885 | 2021-09-10 | Randolph | North Carolina | 37151 | 18387 | 267 |
1704886 | 1704886 | 2021-09-10 | Richmond | North Carolina | 37153 | 6308 | 127 |
1704887 | 1704887 | 2021-09-10 | Robeson | North Carolina | 37155 | 22710 | 332 |
1704888 | 1704888 | 2021-09-10 | Rockingham | North Carolina | 37157 | 9945 | 192 |
1704889 | 1704889 | 2021-09-10 | Rowan | North Carolina | 37159 | 23271 | 358 |
1704890 | 1704890 | 2021-09-10 | Rutherford | North Carolina | 37161 | 9452 | 263 |
1704891 | 1704891 | 2021-09-10 | Sampson | North Carolina | 37163 | 10071 | 124 |
1704892 | 1704892 | 2021-09-10 | Scotland | North Carolina | 37165 | 5008 | 97 |
1704893 | 1704893 | 2021-09-10 | Stanly | North Carolina | 37167 | 9953 | 152 |
1704894 | 1704894 | 2021-09-10 | Stokes | North Carolina | 37169 | 5206 | 84 |
1704895 | 1704895 | 2021-09-10 | Surry | North Carolina | 37171 | 10399 | 192 |
1704896 | 1704896 | 2021-09-10 | Swain | North Carolina | 37173 | 1609 | 22 |
1704897 | 1704897 | 2021-09-10 | Transylvania | North Carolina | 37175 | 3302 | 36 |
1704898 | 1704898 | 2021-09-10 | Tyrrell | North Carolina | 37177 | 465 | 6 |
1704899 | 1704899 | 2021-09-10 | Union | North Carolina | 37179 | 31458 | 266 |
1704900 | 1704900 | 2021-09-10 | Vance | North Carolina | 37181 | 5735 | 92 |
1704901 | 1704901 | 2021-09-10 | Wake | North Carolina | 37183 | 116764 | 808 |
1704902 | 1704902 | 2021-09-10 | Warren | North Carolina | 37185 | 2042 | 20 |
1704903 | 1704903 | 2021-09-10 | Washington | North Carolina | 37187 | 1361 | 34 |
1704904 | 1704904 | 2021-09-10 | Watauga | North Carolina | 37189 | 5817 | 34 |
1704905 | 1704905 | 2021-09-10 | Wayne | North Carolina | 37191 | 13918 | 276 |
1704906 | 1704906 | 2021-09-10 | Wilkes | North Carolina | 37193 | 9165 | 144 |
1704907 | 1704907 | 2021-09-10 | Wilson | North Carolina | 37195 | 11633 | 201 |
1704908 | 1704908 | 2021-09-10 | Yadkin | North Carolina | 37197 | 5188 | 58 |
1704909 | 1704909 | 2021-09-10 | Yancey | North Carolina | 37199 | 2386 | 28 |
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);