ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,127 rows where date = "2020-06-21" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 240
- Georgia 160
- Virginia 132
- Kentucky 119
- Missouri 115
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 95
- Indiana 92
- Kansas 91
- Ohio 88
- Minnesota 87
- Michigan 83
- Mississippi 82
- Puerto Rico 79
- Nebraska 76
- Arkansas 75
- Oklahoma 75
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- Colorado 60
- South Dakota 59
- New York 58
- California 57
- West Virginia 53
- North Dakota 49
- …
fips >30
county >30
- Washington 31
- Unknown 28
- Jefferson 26
- Franklin 25
- Jackson 23
- Lincoln 23
- 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
- Polk 12
- Adams 11
- Clark 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Marshall 11
- Morgan 11
- Calhoun 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
258833 | 258833 | 2020-06-21 | Autauga | Alabama | 1001 | 434 | 9 |
258834 | 258834 | 2020-06-21 | Baldwin | Alabama | 1003 | 430 | 9 |
258835 | 258835 | 2020-06-21 | Barbour | Alabama | 1005 | 272 | 1 |
258836 | 258836 | 2020-06-21 | Bibb | Alabama | 1007 | 127 | 1 |
258837 | 258837 | 2020-06-21 | Blount | Alabama | 1009 | 149 | 1 |
258838 | 258838 | 2020-06-21 | Bullock | Alabama | 1011 | 327 | 10 |
258839 | 258839 | 2020-06-21 | Butler | Alabama | 1013 | 576 | 26 |
258840 | 258840 | 2020-06-21 | Calhoun | Alabama | 1015 | 213 | 4 |
258841 | 258841 | 2020-06-21 | Chambers | Alabama | 1017 | 521 | 27 |
258842 | 258842 | 2020-06-21 | Cherokee | Alabama | 1019 | 58 | 6 |
258843 | 258843 | 2020-06-21 | Chilton | Alabama | 1021 | 166 | 3 |
258844 | 258844 | 2020-06-21 | Choctaw | Alabama | 1023 | 186 | 12 |
258845 | 258845 | 2020-06-21 | Clarke | Alabama | 1025 | 216 | 4 |
258846 | 258846 | 2020-06-21 | Clay | Alabama | 1027 | 32 | 2 |
258847 | 258847 | 2020-06-21 | Cleburne | Alabama | 1029 | 22 | 1 |
258848 | 258848 | 2020-06-21 | Coffee | Alabama | 1031 | 317 | 1 |
258849 | 258849 | 2020-06-21 | Colbert | Alabama | 1033 | 304 | 5 |
258850 | 258850 | 2020-06-21 | Conecuh | Alabama | 1035 | 140 | 1 |
258851 | 258851 | 2020-06-21 | Coosa | Alabama | 1037 | 50 | 1 |
258852 | 258852 | 2020-06-21 | Covington | Alabama | 1039 | 228 | 1 |
258853 | 258853 | 2020-06-21 | Crenshaw | Alabama | 1041 | 118 | 3 |
258854 | 258854 | 2020-06-21 | Cullman | Alabama | 1043 | 310 | 1 |
258855 | 258855 | 2020-06-21 | Dale | Alabama | 1045 | 205 | 0 |
258856 | 258856 | 2020-06-21 | Dallas | Alabama | 1047 | 634 | 6 |
258857 | 258857 | 2020-06-21 | DeKalb | Alabama | 1049 | 415 | 5 |
258858 | 258858 | 2020-06-21 | Elmore | Alabama | 1051 | 673 | 11 |
258859 | 258859 | 2020-06-21 | Escambia | Alabama | 1053 | 148 | 6 |
258860 | 258860 | 2020-06-21 | Etowah | Alabama | 1055 | 405 | 12 |
258861 | 258861 | 2020-06-21 | Fayette | Alabama | 1057 | 61 | 1 |
258862 | 258862 | 2020-06-21 | Franklin | Alabama | 1059 | 782 | 10 |
258863 | 258863 | 2020-06-21 | Geneva | Alabama | 1061 | 51 | 0 |
258864 | 258864 | 2020-06-21 | Greene | Alabama | 1063 | 154 | 5 |
258865 | 258865 | 2020-06-21 | Hale | Alabama | 1065 | 263 | 18 |
258866 | 258866 | 2020-06-21 | Henry | Alabama | 1067 | 115 | 3 |
258867 | 258867 | 2020-06-21 | Houston | Alabama | 1069 | 357 | 5 |
258868 | 258868 | 2020-06-21 | Jackson | Alabama | 1071 | 152 | 3 |
258869 | 258869 | 2020-06-21 | Jefferson | Alabama | 1073 | 2987 | 126 |
258870 | 258870 | 2020-06-21 | Lamar | Alabama | 1075 | 55 | 0 |
258871 | 258871 | 2020-06-21 | Lauderdale | Alabama | 1077 | 298 | 4 |
258872 | 258872 | 2020-06-21 | Lawrence | Alabama | 1079 | 78 | 0 |
258873 | 258873 | 2020-06-21 | Lee | Alabama | 1081 | 852 | 35 |
258874 | 258874 | 2020-06-21 | Limestone | Alabama | 1083 | 271 | 0 |
258875 | 258875 | 2020-06-21 | Lowndes | Alabama | 1085 | 420 | 15 |
258876 | 258876 | 2020-06-21 | Macon | Alabama | 1087 | 149 | 6 |
258877 | 258877 | 2020-06-21 | Madison | Alabama | 1089 | 723 | 6 |
258878 | 258878 | 2020-06-21 | Marengo | Alabama | 1091 | 238 | 11 |
258879 | 258879 | 2020-06-21 | Marion | Alabama | 1093 | 173 | 12 |
258880 | 258880 | 2020-06-21 | Marshall | Alabama | 1095 | 1082 | 9 |
258881 | 258881 | 2020-06-21 | Mobile | Alabama | 1097 | 3016 | 133 |
258882 | 258882 | 2020-06-21 | Monroe | Alabama | 1099 | 163 | 2 |
258883 | 258883 | 2020-06-21 | Montgomery | Alabama | 1101 | 3258 | 81 |
258884 | 258884 | 2020-06-21 | Morgan | Alabama | 1103 | 754 | 2 |
258885 | 258885 | 2020-06-21 | Perry | Alabama | 1105 | 87 | 0 |
258886 | 258886 | 2020-06-21 | Pickens | Alabama | 1107 | 166 | 6 |
258887 | 258887 | 2020-06-21 | Pike | Alabama | 1109 | 360 | 3 |
258888 | 258888 | 2020-06-21 | Randolph | Alabama | 1111 | 144 | 8 |
258889 | 258889 | 2020-06-21 | Russell | Alabama | 1113 | 362 | 0 |
258890 | 258890 | 2020-06-21 | Shelby | Alabama | 1117 | 784 | 22 |
258891 | 258891 | 2020-06-21 | St. Clair | Alabama | 1115 | 209 | 2 |
258892 | 258892 | 2020-06-21 | Sumter | Alabama | 1119 | 269 | 12 |
258893 | 258893 | 2020-06-21 | Talladega | Alabama | 1121 | 189 | 6 |
258894 | 258894 | 2020-06-21 | Tallapoosa | Alabama | 1123 | 517 | 70 |
258895 | 258895 | 2020-06-21 | Tuscaloosa | Alabama | 1125 | 1596 | 31 |
258896 | 258896 | 2020-06-21 | Walker | Alabama | 1127 | 693 | 8 |
258897 | 258897 | 2020-06-21 | Washington | Alabama | 1129 | 95 | 6 |
258898 | 258898 | 2020-06-21 | Wilcox | Alabama | 1131 | 246 | 8 |
258899 | 258899 | 2020-06-21 | Winston | Alabama | 1133 | 176 | 1 |
258900 | 258900 | 2020-06-21 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
258901 | 258901 | 2020-06-21 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
258902 | 258902 | 2020-06-21 | Anchorage | Alaska | 2020 | 386 | 6 |
258903 | 258903 | 2020-06-21 | Bethel Census Area | Alaska | 2050 | 7 | 0 |
258904 | 258904 | 2020-06-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 16 | 0 |
258905 | 258905 | 2020-06-21 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
258906 | 258906 | 2020-06-21 | Fairbanks North Star Borough | Alaska | 2090 | 122 | 2 |
258907 | 258907 | 2020-06-21 | Haines Borough | Alaska | 2100 | 2 | 0 |
258908 | 258908 | 2020-06-21 | Juneau City and Borough | Alaska | 2110 | 42 | 0 |
258909 | 258909 | 2020-06-21 | Kenai Peninsula Borough | Alaska | 2122 | 127 | 1 |
258910 | 258910 | 2020-06-21 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
258911 | 258911 | 2020-06-21 | Kodiak Island Borough | Alaska | 2150 | 5 | 0 |
258912 | 258912 | 2020-06-21 | Matanuska-Susitna Borough | Alaska | 2170 | 56 | 1 |
258913 | 258913 | 2020-06-21 | Nome Census Area | Alaska | 2180 | 6 | 0 |
258914 | 258914 | 2020-06-21 | North Slope Borough | Alaska | 2185 | 3 | 0 |
258915 | 258915 | 2020-06-21 | Northwest Arctic Borough | Alaska | 2188 | 4 | 0 |
258916 | 258916 | 2020-06-21 | Petersburg Borough | Alaska | 2195 | 3 | 0 |
258917 | 258917 | 2020-06-21 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
258918 | 258918 | 2020-06-21 | Sitka City and Borough | Alaska | 2220 | 14 | 0 |
258919 | 258919 | 2020-06-21 | Southeast Fairbanks Census Area | Alaska | 2240 | 7 | 0 |
258920 | 258920 | 2020-06-21 | Unknown | Alaska | 5 | 0 | |
258921 | 258921 | 2020-06-21 | Valdez-Cordova Census Area | Alaska | 2261 | 14 | 0 |
258922 | 258922 | 2020-06-21 | Wrangell City and Borough | Alaska | 2275 | 3 | 0 |
258923 | 258923 | 2020-06-21 | Yukon-Koyukuk Census Area | Alaska | 2290 | 2 | 0 |
258924 | 258924 | 2020-06-21 | Apache | Arizona | 4001 | 2117 | 66 |
258925 | 258925 | 2020-06-21 | Cochise | Arizona | 4003 | 363 | 6 |
258926 | 258926 | 2020-06-21 | Coconino | Arizona | 4005 | 1536 | 90 |
258927 | 258927 | 2020-06-21 | Gila | Arizona | 4007 | 160 | 4 |
258928 | 258928 | 2020-06-21 | Graham | Arizona | 4009 | 63 | 2 |
258929 | 258929 | 2020-06-21 | Greenlee | Arizona | 4011 | 13 | 1 |
258930 | 258930 | 2020-06-21 | La Paz | Arizona | 4012 | 273 | 4 |
258931 | 258931 | 2020-06-21 | Maricopa | Arizona | 4013 | 30136 | 632 |
258932 | 258932 | 2020-06-21 | Mohave | Arizona | 4015 | 721 | 73 |
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);