ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,196 rows where date = "2020-07-16" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 249
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Illinois 103
- Kansas 102
- Iowa 100
- North Carolina 100
- Tennessee 95
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 84
- Mississippi 82
- Nebraska 82
- Puerto Rico 79
- Oklahoma 77
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- South Dakota 64
- Colorado 62
- New York 58
- California 57
- West Virginia 54
- North Dakota 53
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Franklin 25
- Unknown 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 15
- Grant 14
- Greene 14
- Warren 14
- Carroll 13
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Adams 11
- Calhoun 11
- Clark 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
337834 | 337834 | 2020-07-16 | Autauga | Alabama | 1001 | 780 | 20 |
337835 | 337835 | 2020-07-16 | Baldwin | Alabama | 1003 | 1599 | 14 |
337836 | 337836 | 2020-07-16 | Barbour | Alabama | 1005 | 459 | 3 |
337837 | 337837 | 2020-07-16 | Bibb | Alabama | 1007 | 247 | 2 |
337838 | 337838 | 2020-07-16 | Blount | Alabama | 1009 | 424 | 1 |
337839 | 337839 | 2020-07-16 | Bullock | Alabama | 1011 | 389 | 11 |
337840 | 337840 | 2020-07-16 | Butler | Alabama | 1013 | 669 | 32 |
337841 | 337841 | 2020-07-16 | Calhoun | Alabama | 1015 | 675 | 6 |
337842 | 337842 | 2020-07-16 | Chambers | Alabama | 1017 | 731 | 32 |
337843 | 337843 | 2020-07-16 | Cherokee | Alabama | 1019 | 152 | 7 |
337844 | 337844 | 2020-07-16 | Chilton | Alabama | 1021 | 397 | 4 |
337845 | 337845 | 2020-07-16 | Choctaw | Alabama | 1023 | 224 | 12 |
337846 | 337846 | 2020-07-16 | Clarke | Alabama | 1025 | 353 | 6 |
337847 | 337847 | 2020-07-16 | Clay | Alabama | 1027 | 97 | 2 |
337848 | 337848 | 2020-07-16 | Cleburne | Alabama | 1029 | 63 | 1 |
337849 | 337849 | 2020-07-16 | Coffee | Alabama | 1031 | 493 | 4 |
337850 | 337850 | 2020-07-16 | Colbert | Alabama | 1033 | 655 | 8 |
337851 | 337851 | 2020-07-16 | Conecuh | Alabama | 1035 | 271 | 8 |
337852 | 337852 | 2020-07-16 | Coosa | Alabama | 1037 | 68 | 1 |
337853 | 337853 | 2020-07-16 | Covington | Alabama | 1039 | 511 | 15 |
337854 | 337854 | 2020-07-16 | Crenshaw | Alabama | 1041 | 149 | 3 |
337855 | 337855 | 2020-07-16 | Cullman | Alabama | 1043 | 740 | 6 |
337856 | 337856 | 2020-07-16 | Dale | Alabama | 1045 | 457 | 3 |
337857 | 337857 | 2020-07-16 | Dallas | Alabama | 1047 | 1092 | 12 |
337858 | 337858 | 2020-07-16 | DeKalb | Alabama | 1049 | 1195 | 7 |
337859 | 337859 | 2020-07-16 | Elmore | Alabama | 1051 | 1175 | 26 |
337860 | 337860 | 2020-07-16 | Escambia | Alabama | 1053 | 582 | 12 |
337861 | 337861 | 2020-07-16 | Etowah | Alabama | 1055 | 1194 | 14 |
337862 | 337862 | 2020-07-16 | Fayette | Alabama | 1057 | 108 | 3 |
337863 | 337863 | 2020-07-16 | Franklin | Alabama | 1059 | 984 | 16 |
337864 | 337864 | 2020-07-16 | Geneva | Alabama | 1061 | 113 | 0 |
337865 | 337865 | 2020-07-16 | Greene | Alabama | 1063 | 209 | 9 |
337866 | 337866 | 2020-07-16 | Hale | Alabama | 1065 | 388 | 23 |
337867 | 337867 | 2020-07-16 | Henry | Alabama | 1067 | 170 | 4 |
337868 | 337868 | 2020-07-16 | Houston | Alabama | 1069 | 723 | 10 |
337869 | 337869 | 2020-07-16 | Jackson | Alabama | 1071 | 521 | 4 |
337870 | 337870 | 2020-07-16 | Jefferson | Alabama | 1073 | 7900 | 183 |
337871 | 337871 | 2020-07-16 | Lamar | Alabama | 1075 | 102 | 1 |
337872 | 337872 | 2020-07-16 | Lauderdale | Alabama | 1077 | 693 | 7 |
337873 | 337873 | 2020-07-16 | Lawrence | Alabama | 1079 | 165 | 0 |
337874 | 337874 | 2020-07-16 | Lee | Alabama | 1081 | 1915 | 38 |
337875 | 337875 | 2020-07-16 | Limestone | Alabama | 1083 | 757 | 5 |
337876 | 337876 | 2020-07-16 | Lowndes | Alabama | 1085 | 505 | 25 |
337877 | 337877 | 2020-07-16 | Macon | Alabama | 1087 | 246 | 9 |
337878 | 337878 | 2020-07-16 | Madison | Alabama | 1089 | 3014 | 14 |
337879 | 337879 | 2020-07-16 | Marengo | Alabama | 1091 | 390 | 11 |
337880 | 337880 | 2020-07-16 | Marion | Alabama | 1093 | 369 | 14 |
337881 | 337881 | 2020-07-16 | Marshall | Alabama | 1095 | 2229 | 13 |
337882 | 337882 | 2020-07-16 | Mobile | Alabama | 1097 | 5540 | 163 |
337883 | 337883 | 2020-07-16 | Monroe | Alabama | 1099 | 307 | 4 |
337884 | 337884 | 2020-07-16 | Montgomery | Alabama | 1101 | 4864 | 121 |
337885 | 337885 | 2020-07-16 | Morgan | Alabama | 1103 | 1534 | 7 |
337886 | 337886 | 2020-07-16 | Perry | Alabama | 1105 | 281 | 3 |
337887 | 337887 | 2020-07-16 | Pickens | Alabama | 1107 | 289 | 7 |
337888 | 337888 | 2020-07-16 | Pike | Alabama | 1109 | 526 | 6 |
337889 | 337889 | 2020-07-16 | Randolph | Alabama | 1111 | 297 | 10 |
337890 | 337890 | 2020-07-16 | Russell | Alabama | 1113 | 820 | 0 |
337891 | 337891 | 2020-07-16 | Shelby | Alabama | 1117 | 2025 | 27 |
337892 | 337892 | 2020-07-16 | St. Clair | Alabama | 1115 | 732 | 4 |
337893 | 337893 | 2020-07-16 | Sumter | Alabama | 1119 | 310 | 13 |
337894 | 337894 | 2020-07-16 | Talladega | Alabama | 1121 | 547 | 8 |
337895 | 337895 | 2020-07-16 | Tallapoosa | Alabama | 1123 | 687 | 73 |
337896 | 337896 | 2020-07-16 | Tuscaloosa | Alabama | 1125 | 2955 | 56 |
337897 | 337897 | 2020-07-16 | Walker | Alabama | 1127 | 1178 | 43 |
337898 | 337898 | 2020-07-16 | Washington | Alabama | 1129 | 183 | 9 |
337899 | 337899 | 2020-07-16 | Wilcox | Alabama | 1131 | 337 | 8 |
337900 | 337900 | 2020-07-16 | Winston | Alabama | 1133 | 334 | 7 |
337901 | 337901 | 2020-07-16 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
337902 | 337902 | 2020-07-16 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
337903 | 337903 | 2020-07-16 | Anchorage | Alaska | 2020 | 902 | 8 |
337904 | 337904 | 2020-07-16 | Bethel Census Area | Alaska | 2050 | 18 | 0 |
337905 | 337905 | 2020-07-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
337906 | 337906 | 2020-07-16 | Denali Borough | Alaska | 2068 | 1 | 0 |
337907 | 337907 | 2020-07-16 | Dillingham Census Area | Alaska | 2070 | 22 | 0 |
337908 | 337908 | 2020-07-16 | Fairbanks North Star Borough | Alaska | 2090 | 316 | 2 |
337909 | 337909 | 2020-07-16 | Haines Borough | Alaska | 2100 | 7 | 0 |
337910 | 337910 | 2020-07-16 | Juneau City and Borough | Alaska | 2110 | 59 | 2 |
337911 | 337911 | 2020-07-16 | Kenai Peninsula Borough | Alaska | 2122 | 244 | 1 |
337912 | 337912 | 2020-07-16 | Ketchikan Gateway Borough | Alaska | 2130 | 34 | 0 |
337913 | 337913 | 2020-07-16 | Kodiak Island Borough | Alaska | 2150 | 13 | 0 |
337914 | 337914 | 2020-07-16 | Kusilvak Census Area | Alaska | 2158 | 3 | 0 |
337915 | 337915 | 2020-07-16 | Matanuska-Susitna Borough | Alaska | 2170 | 165 | 2 |
337916 | 337916 | 2020-07-16 | Nome Census Area | Alaska | 2180 | 18 | 0 |
337917 | 337917 | 2020-07-16 | North Slope Borough | Alaska | 2185 | 6 | 0 |
337918 | 337918 | 2020-07-16 | Northwest Arctic Borough | Alaska | 2188 | 8 | 0 |
337919 | 337919 | 2020-07-16 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
337920 | 337920 | 2020-07-16 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
337921 | 337921 | 2020-07-16 | Sitka City and Borough | Alaska | 2220 | 20 | 0 |
337922 | 337922 | 2020-07-16 | Southeast Fairbanks Census Area | Alaska | 2240 | 22 | 0 |
337923 | 337923 | 2020-07-16 | Unknown | Alaska | 15 | 0 | |
337924 | 337924 | 2020-07-16 | Valdez-Cordova Census Area | Alaska | 2261 | 49 | 0 |
337925 | 337925 | 2020-07-16 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
337926 | 337926 | 2020-07-16 | Yukon-Koyukuk Census Area | Alaska | 2290 | 18 | 0 |
337927 | 337927 | 2020-07-16 | Apache | Arizona | 4001 | 2658 | 105 |
337928 | 337928 | 2020-07-16 | Cochise | Arizona | 4003 | 1161 | 27 |
337929 | 337929 | 2020-07-16 | Coconino | Arizona | 4005 | 2581 | 105 |
337930 | 337930 | 2020-07-16 | Gila | Arizona | 4007 | 482 | 16 |
337931 | 337931 | 2020-07-16 | Graham | Arizona | 4009 | 236 | 4 |
337932 | 337932 | 2020-07-16 | Greenlee | Arizona | 4011 | 40 | 1 |
337933 | 337933 | 2020-07-16 | La Paz | Arizona | 4012 | 422 | 7 |
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);