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 2022-01-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 |
---|---|---|---|---|---|---|---|
2159831 | 2159831 | 2022-01-28 | Alamance | North Carolina | 37001 | 42740 | 388 |
2159832 | 2159832 | 2022-01-28 | Alexander | North Carolina | 37003 | 9563 | 121 |
2159833 | 2159833 | 2022-01-28 | Alleghany | North Carolina | 37005 | 2599 | 11 |
2159834 | 2159834 | 2022-01-28 | Anson | North Carolina | 37007 | 5932 | 87 |
2159835 | 2159835 | 2022-01-28 | Ashe | North Carolina | 37009 | 5371 | 67 |
2159836 | 2159836 | 2022-01-28 | Avery | North Carolina | 37011 | 3916 | 39 |
2159837 | 2159837 | 2022-01-28 | Beaufort | North Carolina | 37013 | 11019 | 142 |
2159838 | 2159838 | 2022-01-28 | Bertie | North Carolina | 37015 | 3953 | 59 |
2159839 | 2159839 | 2022-01-28 | Bladen | North Carolina | 37017 | 8544 | 106 |
2159840 | 2159840 | 2022-01-28 | Brunswick | North Carolina | 37019 | 26127 | 269 |
2159841 | 2159841 | 2022-01-28 | Buncombe | North Carolina | 37021 | 44784 | 492 |
2159842 | 2159842 | 2022-01-28 | Burke | North Carolina | 37023 | 21666 | 267 |
2159843 | 2159843 | 2022-01-28 | Cabarrus | North Carolina | 37025 | 51421 | 411 |
2159844 | 2159844 | 2022-01-28 | Caldwell | North Carolina | 37027 | 19791 | 244 |
2159845 | 2159845 | 2022-01-28 | Camden | North Carolina | 37029 | 1639 | 9 |
2159846 | 2159846 | 2022-01-28 | Carteret | North Carolina | 37031 | 12028 | 83 |
2159847 | 2159847 | 2022-01-28 | Caswell | North Carolina | 37033 | 4773 | 39 |
2159848 | 2159848 | 2022-01-28 | Catawba | North Carolina | 37035 | 43105 | 498 |
2159849 | 2159849 | 2022-01-28 | Chatham | North Carolina | 37037 | 11293 | 99 |
2159850 | 2159850 | 2022-01-28 | Cherokee | North Carolina | 37039 | 6377 | 91 |
2159851 | 2159851 | 2022-01-28 | Chowan | North Carolina | 37041 | 3874 | 47 |
2159852 | 2159852 | 2022-01-28 | Clay | North Carolina | 37043 | 2285 | 38 |
2159853 | 2159853 | 2022-01-28 | Cleveland | North Carolina | 37045 | 27108 | 338 |
2159854 | 2159854 | 2022-01-28 | Columbus | North Carolina | 37047 | 14610 | 239 |
2159855 | 2159855 | 2022-01-28 | Craven | North Carolina | 37049 | 20742 | 174 |
2159856 | 2159856 | 2022-01-28 | Cumberland | North Carolina | 37051 | 72983 | 516 |
2159857 | 2159857 | 2022-01-28 | Currituck | North Carolina | 37053 | 4416 | 32 |
2159858 | 2159858 | 2022-01-28 | Dare | North Carolina | 37055 | 6688 | 18 |
2159859 | 2159859 | 2022-01-28 | Davidson | North Carolina | 37057 | 39524 | 366 |
2159860 | 2159860 | 2022-01-28 | Davie | North Carolina | 37059 | 10024 | 82 |
2159861 | 2159861 | 2022-01-28 | Duplin | North Carolina | 37061 | 14438 | 207 |
2159862 | 2159862 | 2022-01-28 | Durham | North Carolina | 37063 | 64739 | 285 |
2159863 | 2159863 | 2022-01-28 | Edgecombe | North Carolina | 37065 | 12641 | 133 |
2159864 | 2159864 | 2022-01-28 | Forsyth | North Carolina | 37067 | 84472 | 680 |
2159865 | 2159865 | 2022-01-28 | Franklin | North Carolina | 37069 | 18059 | 65 |
2159866 | 2159866 | 2022-01-28 | Gaston | North Carolina | 37071 | 59726 | 700 |
2159867 | 2159867 | 2022-01-28 | Gates | North Carolina | 37073 | 1691 | 19 |
2159868 | 2159868 | 2022-01-28 | Graham | North Carolina | 37075 | 1986 | 30 |
2159869 | 2159869 | 2022-01-28 | Granville | North Carolina | 37077 | 13095 | 110 |
2159870 | 2159870 | 2022-01-28 | Greene | North Carolina | 37079 | 5282 | 56 |
2159871 | 2159871 | 2022-01-28 | Guilford | North Carolina | 37081 | 105961 | 986 |
2159872 | 2159872 | 2022-01-28 | Halifax | North Carolina | 37083 | 12997 | 158 |
2159873 | 2159873 | 2022-01-28 | Harnett | North Carolina | 37085 | 29040 | 290 |
2159874 | 2159874 | 2022-01-28 | Haywood | North Carolina | 37087 | 11303 | 172 |
2159875 | 2159875 | 2022-01-28 | Henderson | North Carolina | 37089 | 22526 | 244 |
2159876 | 2159876 | 2022-01-28 | Hertford | North Carolina | 37091 | 4475 | 80 |
2159877 | 2159877 | 2022-01-28 | Hoke | North Carolina | 37093 | 13182 | 94 |
2159878 | 2159878 | 2022-01-28 | Hyde | North Carolina | 37095 | 1186 | 13 |
2159879 | 2159879 | 2022-01-28 | Iredell | North Carolina | 37097 | 44239 | 383 |
2159880 | 2159880 | 2022-01-28 | Jackson | North Carolina | 37099 | 8283 | 80 |
2159881 | 2159881 | 2022-01-28 | Johnston | North Carolina | 37101 | 52912 | 368 |
2159882 | 2159882 | 2022-01-28 | Jones | North Carolina | 37103 | 1962 | 38 |
2159883 | 2159883 | 2022-01-28 | Lee | North Carolina | 37105 | 14737 | 129 |
2159884 | 2159884 | 2022-01-28 | Lenoir | North Carolina | 37107 | 14194 | 182 |
2159885 | 2159885 | 2022-01-28 | Lincoln | North Carolina | 37109 | 22071 | 122 |
2159886 | 2159886 | 2022-01-28 | Macon | North Carolina | 37113 | 6700 | 89 |
2159887 | 2159887 | 2022-01-28 | Madison | North Carolina | 37115 | 4248 | 74 |
2159888 | 2159888 | 2022-01-28 | Martin | North Carolina | 37117 | 5608 | 79 |
2159889 | 2159889 | 2022-01-28 | McDowell | North Carolina | 37111 | 11759 | 142 |
2159890 | 2159890 | 2022-01-28 | Mecklenburg | North Carolina | 37119 | 256704 | 1433 |
2159891 | 2159891 | 2022-01-28 | Mitchell | North Carolina | 37121 | 2958 | 28 |
2159892 | 2159892 | 2022-01-28 | Montgomery | North Carolina | 37123 | 6740 | 114 |
2159893 | 2159893 | 2022-01-28 | Moore | North Carolina | 37125 | 22138 | 279 |
2159894 | 2159894 | 2022-01-28 | Nash | North Carolina | 37127 | 25201 | 268 |
2159895 | 2159895 | 2022-01-28 | New Hanover | North Carolina | 37129 | 43804 | 325 |
2159896 | 2159896 | 2022-01-28 | Northampton | North Carolina | 37131 | 4003 | 68 |
2159897 | 2159897 | 2022-01-28 | Onslow | North Carolina | 37133 | 44927 | 306 |
2159898 | 2159898 | 2022-01-28 | Orange | North Carolina | 37135 | 22474 | 119 |
2159899 | 2159899 | 2022-01-28 | Pamlico | North Carolina | 37137 | 2379 | 27 |
2159900 | 2159900 | 2022-01-28 | Pasquotank | North Carolina | 37139 | 7360 | 111 |
2159901 | 2159901 | 2022-01-28 | Pender | North Carolina | 37141 | 13617 | 106 |
2159902 | 2159902 | 2022-01-28 | Perquimans | North Carolina | 37143 | 2485 | 17 |
2159903 | 2159903 | 2022-01-28 | Person | North Carolina | 37145 | 8263 | 96 |
2159904 | 2159904 | 2022-01-28 | Pitt | North Carolina | 37147 | 48220 | 146 |
2159905 | 2159905 | 2022-01-28 | Polk | North Carolina | 37149 | 3435 | 49 |
2159906 | 2159906 | 2022-01-28 | Randolph | North Carolina | 37151 | 32443 | 367 |
2159907 | 2159907 | 2022-01-28 | Richmond | North Carolina | 37153 | 11464 | 165 |
2159908 | 2159908 | 2022-01-28 | Robeson | North Carolina | 37155 | 36878 | 481 |
2159909 | 2159909 | 2022-01-28 | Rockingham | North Carolina | 37157 | 19754 | 240 |
2159910 | 2159910 | 2022-01-28 | Rowan | North Carolina | 37159 | 37887 | 530 |
2159911 | 2159911 | 2022-01-28 | Rutherford | North Carolina | 37161 | 15653 | 362 |
2159912 | 2159912 | 2022-01-28 | Sampson | North Carolina | 37163 | 16804 | 147 |
2159913 | 2159913 | 2022-01-28 | Scotland | North Carolina | 37165 | 9299 | 116 |
2159914 | 2159914 | 2022-01-28 | Stanly | North Carolina | 37167 | 17956 | 222 |
2159915 | 2159915 | 2022-01-28 | Stokes | North Carolina | 37169 | 10106 | 140 |
2159916 | 2159916 | 2022-01-28 | Surry | North Carolina | 37171 | 18979 | 286 |
2159917 | 2159917 | 2022-01-28 | Swain | North Carolina | 37173 | 3004 | 33 |
2159918 | 2159918 | 2022-01-28 | Transylvania | North Carolina | 37175 | 5606 | 57 |
2159919 | 2159919 | 2022-01-28 | Tyrrell | North Carolina | 37177 | 901 | 7 |
2159920 | 2159920 | 2022-01-28 | Union | North Carolina | 37179 | 56693 | 420 |
2159921 | 2159921 | 2022-01-28 | Vance | North Carolina | 37181 | 10959 | 110 |
2159922 | 2159922 | 2022-01-28 | Wake | North Carolina | 37183 | 260534 | 967 |
2159923 | 2159923 | 2022-01-28 | Warren | North Carolina | 37185 | 3867 | 37 |
2159924 | 2159924 | 2022-01-28 | Washington | North Carolina | 37187 | 2743 | 41 |
2159925 | 2159925 | 2022-01-28 | Watauga | North Carolina | 37189 | 10272 | 48 |
2159926 | 2159926 | 2022-01-28 | Wayne | North Carolina | 37191 | 25542 | 351 |
2159927 | 2159927 | 2022-01-28 | Wilkes | North Carolina | 37193 | 15610 | 219 |
2159928 | 2159928 | 2022-01-28 | Wilson | North Carolina | 37195 | 19451 | 244 |
2159929 | 2159929 | 2022-01-28 | Yadkin | North Carolina | 37197 | 9699 | 98 |
2159930 | 2159930 | 2022-01-28 | Yancey | North Carolina | 37199 | 4368 | 45 |
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);