ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46,717
- Georgia 32,249
- Virginia 26,246
- Kentucky 23,212
- Missouri 21,973
- North Carolina 20,008
- Illinois 19,949
- Tennessee 19,244
- Iowa 19,170
- Indiana 18,618
- Kansas 18,333
- Ohio 17,802
- Minnesota 17,019
- Mississippi 16,693
- Michigan 16,650
- Nebraska 15,122
- Arkansas 15,028
- Oklahoma 14,840
- Wisconsin 14,367
- Florida 13,990
- Pennsylvania 13,715
- Alabama 13,519
- Louisiana 13,333
- Puerto Rico 12,735
- Colorado 12,471
- New York 12,168
- California 12,103
- South Dakota 11,404
- West Virginia 10,446
- South Carolina 9,503
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
622857 | 622857 | 2020-10-12 | Linn | Kansas | 20107 | 98 | 0 |
622858 | 622858 | 2020-10-12 | Logan | Kansas | 20109 | 57 | 0 |
622859 | 622859 | 2020-10-12 | Lyon | Kansas | 20111 | 1151 | 37 |
622860 | 622860 | 2020-10-12 | Marion | Kansas | 20115 | 126 | 1 |
622861 | 622861 | 2020-10-12 | Marshall | Kansas | 20117 | 61 | 0 |
622862 | 622862 | 2020-10-12 | McPherson | Kansas | 20113 | 303 | 3 |
622863 | 622863 | 2020-10-12 | Meade | Kansas | 20119 | 156 | 1 |
622864 | 622864 | 2020-10-12 | Miami | Kansas | 20121 | 469 | 1 |
622865 | 622865 | 2020-10-12 | Mitchell | Kansas | 20123 | 55 | 0 |
622866 | 622866 | 2020-10-12 | Montgomery | Kansas | 20125 | 562 | 6 |
622867 | 622867 | 2020-10-12 | Morris | Kansas | 20127 | 48 | 0 |
622868 | 622868 | 2020-10-12 | Morton | Kansas | 20129 | 31 | 2 |
622869 | 622869 | 2020-10-12 | Nemaha | Kansas | 20131 | 201 | 1 |
622870 | 622870 | 2020-10-12 | Neosho | Kansas | 20133 | 193 | 0 |
622871 | 622871 | 2020-10-12 | Ness | Kansas | 20135 | 107 | 7 |
622872 | 622872 | 2020-10-12 | Norton | Kansas | 20137 | 171 | 0 |
622873 | 622873 | 2020-10-12 | Osage | Kansas | 20139 | 132 | 0 |
622874 | 622874 | 2020-10-12 | Osborne | Kansas | 20141 | 19 | 0 |
622875 | 622875 | 2020-10-12 | Ottawa | Kansas | 20143 | 94 | 0 |
622876 | 622876 | 2020-10-12 | Pawnee | Kansas | 20145 | 406 | 1 |
622877 | 622877 | 2020-10-12 | Phillips | Kansas | 20147 | 147 | 9 |
622878 | 622878 | 2020-10-12 | Pottawatomie | Kansas | 20149 | 327 | 0 |
622879 | 622879 | 2020-10-12 | Pratt | Kansas | 20151 | 92 | 0 |
622880 | 622880 | 2020-10-12 | Rawlins | Kansas | 20153 | 104 | 0 |
622881 | 622881 | 2020-10-12 | Reno | Kansas | 20155 | 1521 | 7 |
622882 | 622882 | 2020-10-12 | Republic | Kansas | 20157 | 61 | 1 |
622883 | 622883 | 2020-10-12 | Rice | Kansas | 20159 | 103 | 1 |
622884 | 622884 | 2020-10-12 | Riley | Kansas | 20161 | 1968 | 9 |
622885 | 622885 | 2020-10-12 | Rooks | Kansas | 20163 | 128 | 7 |
622886 | 622886 | 2020-10-12 | Rush | Kansas | 20165 | 88 | 0 |
622887 | 622887 | 2020-10-12 | Russell | Kansas | 20167 | 141 | 3 |
622888 | 622888 | 2020-10-12 | Saline | Kansas | 20169 | 905 | 12 |
622889 | 622889 | 2020-10-12 | Scott | Kansas | 20171 | 166 | 1 |
622890 | 622890 | 2020-10-12 | Sedgwick | Kansas | 20173 | 10149 | 106 |
622891 | 622891 | 2020-10-12 | Seward | Kansas | 20175 | 1805 | 7 |
622892 | 622892 | 2020-10-12 | Shawnee | Kansas | 20177 | 3116 | 62 |
622893 | 622893 | 2020-10-12 | Sheridan | Kansas | 20179 | 76 | 0 |
622894 | 622894 | 2020-10-12 | Sherman | Kansas | 20181 | 123 | 0 |
622895 | 622895 | 2020-10-12 | Smith | Kansas | 20183 | 17 | 0 |
622896 | 622896 | 2020-10-12 | Stafford | Kansas | 20185 | 68 | 1 |
622897 | 622897 | 2020-10-12 | Stanton | Kansas | 20187 | 79 | 2 |
622898 | 622898 | 2020-10-12 | Stevens | Kansas | 20189 | 188 | 1 |
622899 | 622899 | 2020-10-12 | Sumner | Kansas | 20191 | 233 | 3 |
622900 | 622900 | 2020-10-12 | Thomas | Kansas | 20193 | 223 | 0 |
622901 | 622901 | 2020-10-12 | Trego | Kansas | 20195 | 69 | 3 |
622902 | 622902 | 2020-10-12 | Wabaunsee | Kansas | 20197 | 76 | 1 |
622903 | 622903 | 2020-10-12 | Wallace | Kansas | 20199 | 23 | 0 |
622904 | 622904 | 2020-10-12 | Washington | Kansas | 20201 | 27 | 0 |
622905 | 622905 | 2020-10-12 | Wichita | Kansas | 20203 | 11 | 0 |
622906 | 622906 | 2020-10-12 | Wilson | Kansas | 20205 | 85 | 2 |
622907 | 622907 | 2020-10-12 | Woodson | Kansas | 20207 | 25 | 0 |
622908 | 622908 | 2020-10-12 | Wyandotte | Kansas | 20209 | 7721 | 134 |
622909 | 622909 | 2020-10-12 | Adair | Kentucky | 21001 | 418 | 20 |
622910 | 622910 | 2020-10-12 | Allen | Kentucky | 21003 | 445 | 10 |
622911 | 622911 | 2020-10-12 | Anderson | Kentucky | 21005 | 196 | 1 |
622912 | 622912 | 2020-10-12 | Ballard | Kentucky | 21007 | 60 | 1 |
622913 | 622913 | 2020-10-12 | Barren | Kentucky | 21009 | 866 | 13 |
622914 | 622914 | 2020-10-12 | Bath | Kentucky | 21011 | 94 | 1 |
622915 | 622915 | 2020-10-12 | Bell | Kentucky | 21013 | 565 | 16 |
622916 | 622916 | 2020-10-12 | Boone | Kentucky | 21015 | 1800 | 25 |
622917 | 622917 | 2020-10-12 | Bourbon | Kentucky | 21017 | 247 | 1 |
622918 | 622918 | 2020-10-12 | Boyd | Kentucky | 21019 | 552 | 14 |
622919 | 622919 | 2020-10-12 | Boyle | Kentucky | 21021 | 356 | 0 |
622920 | 622920 | 2020-10-12 | Bracken | Kentucky | 21023 | 43 | 0 |
622921 | 622921 | 2020-10-12 | Breathitt | Kentucky | 21025 | 100 | 0 |
622922 | 622922 | 2020-10-12 | Breckinridge | Kentucky | 21027 | 155 | 2 |
622923 | 622923 | 2020-10-12 | Bullitt | Kentucky | 21029 | 1069 | 12 |
622924 | 622924 | 2020-10-12 | Butler | Kentucky | 21031 | 384 | 16 |
622925 | 622925 | 2020-10-12 | Caldwell | Kentucky | 21033 | 193 | 0 |
622926 | 622926 | 2020-10-12 | Calloway | Kentucky | 21035 | 788 | 9 |
622927 | 622927 | 2020-10-12 | Campbell | Kentucky | 21037 | 992 | 19 |
622928 | 622928 | 2020-10-12 | Carlisle | Kentucky | 21039 | 88 | 1 |
622929 | 622929 | 2020-10-12 | Carroll | Kentucky | 21041 | 209 | 5 |
622930 | 622930 | 2020-10-12 | Carter | Kentucky | 21043 | 262 | 4 |
622931 | 622931 | 2020-10-12 | Casey | Kentucky | 21045 | 285 | 16 |
622932 | 622932 | 2020-10-12 | Christian | Kentucky | 21047 | 1579 | 26 |
622933 | 622933 | 2020-10-12 | Clark | Kentucky | 21049 | 400 | 10 |
622934 | 622934 | 2020-10-12 | Clay | Kentucky | 21051 | 371 | 6 |
622935 | 622935 | 2020-10-12 | Clinton | Kentucky | 21053 | 170 | 3 |
622936 | 622936 | 2020-10-12 | Crittenden | Kentucky | 21055 | 132 | 1 |
622937 | 622937 | 2020-10-12 | Cumberland | Kentucky | 21057 | 115 | 0 |
622938 | 622938 | 2020-10-12 | Daviess | Kentucky | 21059 | 1707 | 23 |
622939 | 622939 | 2020-10-12 | Edmonson | Kentucky | 21061 | 169 | 12 |
622940 | 622940 | 2020-10-12 | Elliott | Kentucky | 21063 | 59 | 0 |
622941 | 622941 | 2020-10-12 | Estill | Kentucky | 21065 | 226 | 0 |
622942 | 622942 | 2020-10-12 | Fayette | Kentucky | 21067 | 9385 | 82 |
622943 | 622943 | 2020-10-12 | Fleming | Kentucky | 21069 | 97 | 0 |
622944 | 622944 | 2020-10-12 | Floyd | Kentucky | 21071 | 237 | 4 |
622945 | 622945 | 2020-10-12 | Franklin | Kentucky | 21073 | 763 | 12 |
622946 | 622946 | 2020-10-12 | Fulton | Kentucky | 21075 | 202 | 3 |
622947 | 622947 | 2020-10-12 | Gallatin | Kentucky | 21077 | 107 | 8 |
622948 | 622948 | 2020-10-12 | Garrard | Kentucky | 21079 | 209 | 3 |
622949 | 622949 | 2020-10-12 | Grant | Kentucky | 21081 | 204 | 6 |
622950 | 622950 | 2020-10-12 | Graves | Kentucky | 21083 | 829 | 29 |
622951 | 622951 | 2020-10-12 | Grayson | Kentucky | 21085 | 430 | 15 |
622952 | 622952 | 2020-10-12 | Green | Kentucky | 21087 | 302 | 9 |
622953 | 622953 | 2020-10-12 | Greenup | Kentucky | 21089 | 509 | 5 |
622954 | 622954 | 2020-10-12 | Hancock | Kentucky | 21091 | 105 | 1 |
622955 | 622955 | 2020-10-12 | Hardin | Kentucky | 21093 | 1551 | 14 |
622956 | 622956 | 2020-10-12 | Harlan | Kentucky | 21095 | 526 | 13 |
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);