ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2021-06-25" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Ohio 89
- Minnesota 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 64
- California 58
- New York 58
- Montana 56
- West Virginia 55
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Unknown 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 15
- Greene 14
- Warren 14
- Carroll 13
- Adams 12
- Clark 12
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Calhoun 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1452834 | 1452834 | 2021-06-25 | Autauga | Alabama | 1001 | 7244 | 113 |
1452835 | 1452835 | 2021-06-25 | Baldwin | Alabama | 1003 | 21945 | 314 |
1452836 | 1452836 | 2021-06-25 | Barbour | Alabama | 1005 | 2344 | 60 |
1452837 | 1452837 | 2021-06-25 | Bibb | Alabama | 1007 | 2686 | 64 |
1452838 | 1452838 | 2021-06-25 | Blount | Alabama | 1009 | 6967 | 139 |
1452839 | 1452839 | 2021-06-25 | Bullock | Alabama | 1011 | 1247 | 42 |
1452840 | 1452840 | 2021-06-25 | Butler | Alabama | 1013 | 2255 | 71 |
1452841 | 1452841 | 2021-06-25 | Calhoun | Alabama | 1015 | 14761 | 330 |
1452842 | 1452842 | 2021-06-25 | Chambers | Alabama | 1017 | 3733 | 124 |
1452843 | 1452843 | 2021-06-25 | Cherokee | Alabama | 1019 | 1874 | 45 |
1452844 | 1452844 | 2021-06-25 | Chilton | Alabama | 1021 | 4478 | 116 |
1452845 | 1452845 | 2021-06-25 | Choctaw | Alabama | 1023 | 620 | 25 |
1452846 | 1452846 | 2021-06-25 | Clarke | Alabama | 1025 | 3532 | 61 |
1452847 | 1452847 | 2021-06-25 | Clay | Alabama | 1027 | 1602 | 59 |
1452848 | 1452848 | 2021-06-25 | Cleburne | Alabama | 1029 | 1540 | 44 |
1452849 | 1452849 | 2021-06-25 | Coffee | Alabama | 1031 | 5651 | 128 |
1452850 | 1452850 | 2021-06-25 | Colbert | Alabama | 1033 | 6419 | 140 |
1452851 | 1452851 | 2021-06-25 | Conecuh | Alabama | 1035 | 1138 | 30 |
1452852 | 1452852 | 2021-06-25 | Coosa | Alabama | 1037 | 1122 | 29 |
1452853 | 1452853 | 2021-06-25 | Covington | Alabama | 1039 | 4286 | 123 |
1452854 | 1452854 | 2021-06-25 | Crenshaw | Alabama | 1041 | 1573 | 57 |
1452855 | 1452855 | 2021-06-25 | Cullman | Alabama | 1043 | 9986 | 201 |
1452856 | 1452856 | 2021-06-25 | Dale | Alabama | 1045 | 4933 | 117 |
1452857 | 1452857 | 2021-06-25 | Dallas | Alabama | 1047 | 3611 | 158 |
1452858 | 1452858 | 2021-06-25 | DeKalb | Alabama | 1049 | 9001 | 190 |
1452859 | 1452859 | 2021-06-25 | Elmore | Alabama | 1051 | 10305 | 214 |
1452860 | 1452860 | 2021-06-25 | Escambia | Alabama | 1053 | 4027 | 80 |
1452861 | 1452861 | 2021-06-25 | Etowah | Alabama | 1055 | 14218 | 365 |
1452862 | 1452862 | 2021-06-25 | Fayette | Alabama | 1057 | 2198 | 63 |
1452863 | 1452863 | 2021-06-25 | Franklin | Alabama | 1059 | 4322 | 81 |
1452864 | 1452864 | 2021-06-25 | Geneva | Alabama | 1061 | 2590 | 82 |
1452865 | 1452865 | 2021-06-25 | Greene | Alabama | 1063 | 937 | 34 |
1452866 | 1452866 | 2021-06-25 | Hale | Alabama | 1065 | 2272 | 78 |
1452867 | 1452867 | 2021-06-25 | Henry | Alabama | 1067 | 1951 | 44 |
1452868 | 1452868 | 2021-06-25 | Houston | Alabama | 1069 | 10810 | 289 |
1452869 | 1452869 | 2021-06-25 | Jackson | Alabama | 1071 | 7007 | 113 |
1452870 | 1452870 | 2021-06-25 | Jefferson | Alabama | 1073 | 81151 | 1571 |
1452871 | 1452871 | 2021-06-25 | Lamar | Alabama | 1075 | 1472 | 37 |
1452872 | 1452872 | 2021-06-25 | Lauderdale | Alabama | 1077 | 9632 | 250 |
1452873 | 1452873 | 2021-06-25 | Lawrence | Alabama | 1079 | 3135 | 100 |
1452874 | 1452874 | 2021-06-25 | Lee | Alabama | 1081 | 16317 | 176 |
1452875 | 1452875 | 2021-06-25 | Limestone | Alabama | 1083 | 10197 | 157 |
1452876 | 1452876 | 2021-06-25 | Lowndes | Alabama | 1085 | 1421 | 54 |
1452877 | 1452877 | 2021-06-25 | Macon | Alabama | 1087 | 1632 | 51 |
1452878 | 1452878 | 2021-06-25 | Madison | Alabama | 1089 | 35779 | 526 |
1452879 | 1452879 | 2021-06-25 | Marengo | Alabama | 1091 | 2504 | 66 |
1452880 | 1452880 | 2021-06-25 | Marion | Alabama | 1093 | 3269 | 106 |
1452881 | 1452881 | 2021-06-25 | Marshall | Alabama | 1095 | 12476 | 230 |
1452882 | 1452882 | 2021-06-25 | Mobile | Alabama | 1097 | 42241 | 835 |
1452883 | 1452883 | 2021-06-25 | Monroe | Alabama | 1099 | 1815 | 41 |
1452884 | 1452884 | 2021-06-25 | Montgomery | Alabama | 1101 | 25101 | 615 |
1452885 | 1452885 | 2021-06-25 | Morgan | Alabama | 1103 | 14656 | 287 |
1452886 | 1452886 | 2021-06-25 | Perry | Alabama | 1105 | 1086 | 26 |
1452887 | 1452887 | 2021-06-25 | Pickens | Alabama | 1107 | 2370 | 62 |
1452888 | 1452888 | 2021-06-25 | Pike | Alabama | 1109 | 3148 | 78 |
1452889 | 1452889 | 2021-06-25 | Randolph | Alabama | 1111 | 1876 | 44 |
1452890 | 1452890 | 2021-06-25 | Russell | Alabama | 1113 | 4552 | 41 |
1452891 | 1452891 | 2021-06-25 | Shelby | Alabama | 1117 | 25674 | 255 |
1452892 | 1452892 | 2021-06-25 | St. Clair | Alabama | 1115 | 10186 | 251 |
1452893 | 1452893 | 2021-06-25 | Sumter | Alabama | 1119 | 1061 | 32 |
1452894 | 1452894 | 2021-06-25 | Talladega | Alabama | 1121 | 8474 | 184 |
1452895 | 1452895 | 2021-06-25 | Tallapoosa | Alabama | 1123 | 4145 | 155 |
1452896 | 1452896 | 2021-06-25 | Tuscaloosa | Alabama | 1125 | 26216 | 461 |
1452897 | 1452897 | 2021-06-25 | Walker | Alabama | 1127 | 7353 | 281 |
1452898 | 1452898 | 2021-06-25 | Washington | Alabama | 1129 | 1705 | 39 |
1452899 | 1452899 | 2021-06-25 | Wilcox | Alabama | 1131 | 1268 | 30 |
1452900 | 1452900 | 2021-06-25 | Winston | Alabama | 1133 | 2837 | 72 |
1452901 | 1452901 | 2021-06-25 | Aleutians East Borough | Alaska | 2013 | 367 | 3 |
1452902 | 1452902 | 2021-06-25 | Aleutians West Census Area | Alaska | 2016 | 725 | 0 |
1452903 | 1452903 | 2021-06-25 | Anchorage | Alaska | 2020 | 30885 | 175 |
1452904 | 1452904 | 2021-06-25 | Bethel Census Area | Alaska | 2050 | 3911 | 22 |
1452905 | 1452905 | 2021-06-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 201 | 0 |
1452906 | 1452906 | 2021-06-25 | Denali Borough | Alaska | 2068 | 110 | 0 |
1452907 | 1452907 | 2021-06-25 | Dillingham Census Area | Alaska | 2070 | 233 | 2 |
1452908 | 1452908 | 2021-06-25 | Fairbanks North Star Borough | Alaska | 2090 | 7994 | 44 |
1452909 | 1452909 | 2021-06-25 | Haines Borough | Alaska | 2100 | 28 | 0 |
1452910 | 1452910 | 2021-06-25 | Juneau City and Borough | Alaska | 2110 | 1465 | 3 |
1452911 | 1452911 | 2021-06-25 | Kenai Peninsula Borough | Alaska | 2122 | 4547 | 19 |
1452912 | 1452912 | 2021-06-25 | Ketchikan Gateway Borough | Alaska | 2130 | 655 | 1 |
1452913 | 1452913 | 2021-06-25 | Kodiak Island Borough | Alaska | 2150 | 1122 | 6 |
1452914 | 1452914 | 2021-06-25 | Kusilvak Census Area | Alaska | 2158 | 1381 | 4 |
1452915 | 1452915 | 2021-06-25 | Matanuska-Susitna Borough | Alaska | 2170 | 11777 | 57 |
1452916 | 1452916 | 2021-06-25 | Nome Census Area | Alaska | 2180 | 401 | 0 |
1452917 | 1452917 | 2021-06-25 | North Slope Borough | Alaska | 2185 | 1080 | 4 |
1452918 | 1452918 | 2021-06-25 | Northwest Arctic Borough | Alaska | 2188 | 624 | 2 |
1452919 | 1452919 | 2021-06-25 | Petersburg Borough | Alaska | 2195 | 166 | 0 |
1452920 | 1452920 | 2021-06-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 175 | 1 |
1452921 | 1452921 | 2021-06-25 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1452922 | 1452922 | 2021-06-25 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1452923 | 1452923 | 2021-06-25 | Southeast Fairbanks Census Area | Alaska | 2240 | 766 | 5 |
1452924 | 1452924 | 2021-06-25 | Unknown | Alaska | 292 | 0 | |
1452925 | 1452925 | 2021-06-25 | Valdez-Cordova Census Area | Alaska | 2261 | 684 | 2 |
1452926 | 1452926 | 2021-06-25 | Wrangell City and Borough | Alaska | 2275 | 63 | 0 |
1452927 | 1452927 | 2021-06-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 81 | 2 |
1452928 | 1452928 | 2021-06-25 | Yukon-Koyukuk Census Area | Alaska | 2290 | 368 | 4 |
1452929 | 1452929 | 2021-06-25 | Apache | Arizona | 4001 | 11472 | 433 |
1452930 | 1452930 | 2021-06-25 | Cochise | Arizona | 4003 | 12191 | 293 |
1452931 | 1452931 | 2021-06-25 | Coconino | Arizona | 4005 | 17951 | 330 |
1452932 | 1452932 | 2021-06-25 | Gila | Arizona | 4007 | 7064 | 229 |
1452933 | 1452933 | 2021-06-25 | Graham | Arizona | 4009 | 5593 | 84 |
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);