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-02-01 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 |
---|---|---|---|---|---|---|---|
2172849 | 2172849 | 2022-02-01 | Alamance | North Carolina | 37001 | 43617 | 415 |
2172850 | 2172850 | 2022-02-01 | Alexander | North Carolina | 37003 | 9886 | 122 |
2172851 | 2172851 | 2022-02-01 | Alleghany | North Carolina | 37005 | 2668 | 11 |
2172852 | 2172852 | 2022-02-01 | Anson | North Carolina | 37007 | 6115 | 87 |
2172853 | 2172853 | 2022-02-01 | Ashe | North Carolina | 37009 | 5532 | 67 |
2172854 | 2172854 | 2022-02-01 | Avery | North Carolina | 37011 | 3969 | 39 |
2172855 | 2172855 | 2022-02-01 | Beaufort | North Carolina | 37013 | 11278 | 143 |
2172856 | 2172856 | 2022-02-01 | Bertie | North Carolina | 37015 | 4011 | 60 |
2172857 | 2172857 | 2022-02-01 | Bladen | North Carolina | 37017 | 8745 | 107 |
2172858 | 2172858 | 2022-02-01 | Brunswick | North Carolina | 37019 | 26827 | 271 |
2172859 | 2172859 | 2022-02-01 | Buncombe | North Carolina | 37021 | 46005 | 500 |
2172860 | 2172860 | 2022-02-01 | Burke | North Carolina | 37023 | 22358 | 267 |
2172861 | 2172861 | 2022-02-01 | Cabarrus | North Carolina | 37025 | 52499 | 421 |
2172862 | 2172862 | 2022-02-01 | Caldwell | North Carolina | 37027 | 20303 | 244 |
2172863 | 2172863 | 2022-02-01 | Camden | North Carolina | 37029 | 1673 | 9 |
2172864 | 2172864 | 2022-02-01 | Carteret | North Carolina | 37031 | 12363 | 83 |
2172865 | 2172865 | 2022-02-01 | Caswell | North Carolina | 37033 | 4883 | 39 |
2172866 | 2172866 | 2022-02-01 | Catawba | North Carolina | 37035 | 44273 | 501 |
2172867 | 2172867 | 2022-02-01 | Chatham | North Carolina | 37037 | 11614 | 103 |
2172868 | 2172868 | 2022-02-01 | Cherokee | North Carolina | 37039 | 6561 | 91 |
2172869 | 2172869 | 2022-02-01 | Chowan | North Carolina | 37041 | 3953 | 48 |
2172870 | 2172870 | 2022-02-01 | Clay | North Carolina | 37043 | 2362 | 38 |
2172871 | 2172871 | 2022-02-01 | Cleveland | North Carolina | 37045 | 27731 | 338 |
2172872 | 2172872 | 2022-02-01 | Columbus | North Carolina | 37047 | 14929 | 240 |
2172873 | 2172873 | 2022-02-01 | Craven | North Carolina | 37049 | 21393 | 176 |
2172874 | 2172874 | 2022-02-01 | Cumberland | North Carolina | 37051 | 75525 | 517 |
2172875 | 2172875 | 2022-02-01 | Currituck | North Carolina | 37053 | 4494 | 32 |
2172876 | 2172876 | 2022-02-01 | Dare | North Carolina | 37055 | 6846 | 18 |
2172877 | 2172877 | 2022-02-01 | Davidson | North Carolina | 37057 | 40485 | 369 |
2172878 | 2172878 | 2022-02-01 | Davie | North Carolina | 37059 | 10252 | 82 |
2172879 | 2172879 | 2022-02-01 | Duplin | North Carolina | 37061 | 14737 | 207 |
2172880 | 2172880 | 2022-02-01 | Durham | North Carolina | 37063 | 66127 | 285 |
2172881 | 2172881 | 2022-02-01 | Edgecombe | North Carolina | 37065 | 12815 | 133 |
2172882 | 2172882 | 2022-02-01 | Forsyth | North Carolina | 37067 | 86463 | 692 |
2172883 | 2172883 | 2022-02-01 | Franklin | North Carolina | 37069 | 18588 | 65 |
2172884 | 2172884 | 2022-02-01 | Gaston | North Carolina | 37071 | 61140 | 705 |
2172885 | 2172885 | 2022-02-01 | Gates | North Carolina | 37073 | 1720 | 19 |
2172886 | 2172886 | 2022-02-01 | Graham | North Carolina | 37075 | 2061 | 30 |
2172887 | 2172887 | 2022-02-01 | Granville | North Carolina | 37077 | 13267 | 110 |
2172888 | 2172888 | 2022-02-01 | Greene | North Carolina | 37079 | 5415 | 56 |
2172889 | 2172889 | 2022-02-01 | Guilford | North Carolina | 37081 | 108255 | 994 |
2172890 | 2172890 | 2022-02-01 | Halifax | North Carolina | 37083 | 13188 | 159 |
2172891 | 2172891 | 2022-02-01 | Harnett | North Carolina | 37085 | 29790 | 291 |
2172892 | 2172892 | 2022-02-01 | Haywood | North Carolina | 37087 | 11670 | 172 |
2172893 | 2172893 | 2022-02-01 | Henderson | North Carolina | 37089 | 22941 | 261 |
2172894 | 2172894 | 2022-02-01 | Hertford | North Carolina | 37091 | 4534 | 80 |
2172895 | 2172895 | 2022-02-01 | Hoke | North Carolina | 37093 | 13511 | 95 |
2172896 | 2172896 | 2022-02-01 | Hyde | North Carolina | 37095 | 1206 | 13 |
2172897 | 2172897 | 2022-02-01 | Iredell | North Carolina | 37097 | 45096 | 391 |
2172898 | 2172898 | 2022-02-01 | Jackson | North Carolina | 37099 | 8438 | 81 |
2172899 | 2172899 | 2022-02-01 | Johnston | North Carolina | 37101 | 54171 | 368 |
2172900 | 2172900 | 2022-02-01 | Jones | North Carolina | 37103 | 2028 | 38 |
2172901 | 2172901 | 2022-02-01 | Lee | North Carolina | 37105 | 15103 | 129 |
2172902 | 2172902 | 2022-02-01 | Lenoir | North Carolina | 37107 | 14650 | 184 |
2172903 | 2172903 | 2022-02-01 | Lincoln | North Carolina | 37109 | 22599 | 122 |
2172904 | 2172904 | 2022-02-01 | Macon | North Carolina | 37113 | 6809 | 91 |
2172905 | 2172905 | 2022-02-01 | Madison | North Carolina | 37115 | 4342 | 74 |
2172906 | 2172906 | 2022-02-01 | Martin | North Carolina | 37117 | 5728 | 79 |
2172907 | 2172907 | 2022-02-01 | McDowell | North Carolina | 37111 | 12102 | 142 |
2172908 | 2172908 | 2022-02-01 | Mecklenburg | North Carolina | 37119 | 261994 | 1439 |
2172909 | 2172909 | 2022-02-01 | Mitchell | North Carolina | 37121 | 2985 | 28 |
2172910 | 2172910 | 2022-02-01 | Montgomery | North Carolina | 37123 | 6897 | 115 |
2172911 | 2172911 | 2022-02-01 | Moore | North Carolina | 37125 | 22621 | 283 |
2172912 | 2172912 | 2022-02-01 | Nash | North Carolina | 37127 | 25715 | 271 |
2172913 | 2172913 | 2022-02-01 | New Hanover | North Carolina | 37129 | 45029 | 326 |
2172914 | 2172914 | 2022-02-01 | Northampton | North Carolina | 37131 | 4075 | 69 |
2172915 | 2172915 | 2022-02-01 | Onslow | North Carolina | 37133 | 46530 | 318 |
2172916 | 2172916 | 2022-02-01 | Orange | North Carolina | 37135 | 23200 | 120 |
2172917 | 2172917 | 2022-02-01 | Pamlico | North Carolina | 37137 | 2419 | 27 |
2172918 | 2172918 | 2022-02-01 | Pasquotank | North Carolina | 37139 | 7472 | 111 |
2172919 | 2172919 | 2022-02-01 | Pender | North Carolina | 37141 | 14016 | 108 |
2172920 | 2172920 | 2022-02-01 | Perquimans | North Carolina | 37143 | 2519 | 17 |
2172921 | 2172921 | 2022-02-01 | Person | North Carolina | 37145 | 8538 | 98 |
2172922 | 2172922 | 2022-02-01 | Pitt | North Carolina | 37147 | 49056 | 146 |
2172923 | 2172923 | 2022-02-01 | Polk | North Carolina | 37149 | 3517 | 49 |
2172924 | 2172924 | 2022-02-01 | Randolph | North Carolina | 37151 | 33243 | 369 |
2172925 | 2172925 | 2022-02-01 | Richmond | North Carolina | 37153 | 11701 | 170 |
2172926 | 2172926 | 2022-02-01 | Robeson | North Carolina | 37155 | 37739 | 486 |
2172927 | 2172927 | 2022-02-01 | Rockingham | North Carolina | 37157 | 20395 | 246 |
2172928 | 2172928 | 2022-02-01 | Rowan | North Carolina | 37159 | 38666 | 533 |
2172929 | 2172929 | 2022-02-01 | Rutherford | North Carolina | 37161 | 16118 | 364 |
2172930 | 2172930 | 2022-02-01 | Sampson | North Carolina | 37163 | 17148 | 147 |
2172931 | 2172931 | 2022-02-01 | Scotland | North Carolina | 37165 | 9483 | 117 |
2172932 | 2172932 | 2022-02-01 | Stanly | North Carolina | 37167 | 18405 | 222 |
2172933 | 2172933 | 2022-02-01 | Stokes | North Carolina | 37169 | 10309 | 142 |
2172934 | 2172934 | 2022-02-01 | Surry | North Carolina | 37171 | 19381 | 286 |
2172935 | 2172935 | 2022-02-01 | Swain | North Carolina | 37173 | 3047 | 33 |
2172936 | 2172936 | 2022-02-01 | Transylvania | North Carolina | 37175 | 5691 | 59 |
2172937 | 2172937 | 2022-02-01 | Tyrrell | North Carolina | 37177 | 911 | 7 |
2172938 | 2172938 | 2022-02-01 | Union | North Carolina | 37179 | 57841 | 425 |
2172939 | 2172939 | 2022-02-01 | Vance | North Carolina | 37181 | 11168 | 110 |
2172940 | 2172940 | 2022-02-01 | Wake | North Carolina | 37183 | 267128 | 967 |
2172941 | 2172941 | 2022-02-01 | Warren | North Carolina | 37185 | 3927 | 37 |
2172942 | 2172942 | 2022-02-01 | Washington | North Carolina | 37187 | 2798 | 42 |
2172943 | 2172943 | 2022-02-01 | Watauga | North Carolina | 37189 | 10724 | 49 |
2172944 | 2172944 | 2022-02-01 | Wayne | North Carolina | 37191 | 26120 | 354 |
2172945 | 2172945 | 2022-02-01 | Wilkes | North Carolina | 37193 | 16126 | 230 |
2172946 | 2172946 | 2022-02-01 | Wilson | North Carolina | 37195 | 19906 | 260 |
2172947 | 2172947 | 2022-02-01 | Yadkin | North Carolina | 37197 | 10014 | 98 |
2172948 | 2172948 | 2022-02-01 | Yancey | North Carolina | 37199 | 4403 | 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);