ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,247 rows where "date" is on date 2021-07-19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 94
- 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
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1530745 | 1530745 | 2021-07-19 | Autauga | Alabama | 1001 | 7350 | 113 |
1530746 | 1530746 | 2021-07-19 | Baldwin | Alabama | 1003 | 22876 | 323 |
1530747 | 1530747 | 2021-07-19 | Barbour | Alabama | 1005 | 2396 | 60 |
1530748 | 1530748 | 2021-07-19 | Bibb | Alabama | 1007 | 2733 | 65 |
1530749 | 1530749 | 2021-07-19 | Blount | Alabama | 1009 | 7103 | 139 |
1530750 | 1530750 | 2021-07-19 | Bullock | Alabama | 1011 | 1252 | 42 |
1530751 | 1530751 | 2021-07-19 | Butler | Alabama | 1013 | 2303 | 71 |
1530752 | 1530752 | 2021-07-19 | Calhoun | Alabama | 1015 | 14928 | 331 |
1530753 | 1530753 | 2021-07-19 | Chambers | Alabama | 1017 | 3789 | 124 |
1530754 | 1530754 | 2021-07-19 | Cherokee | Alabama | 1019 | 1909 | 47 |
1530755 | 1530755 | 2021-07-19 | Chilton | Alabama | 1021 | 4569 | 116 |
1530756 | 1530756 | 2021-07-19 | Choctaw | Alabama | 1023 | 629 | 25 |
1530757 | 1530757 | 2021-07-19 | Clarke | Alabama | 1025 | 3591 | 62 |
1530758 | 1530758 | 2021-07-19 | Clay | Alabama | 1027 | 1612 | 59 |
1530759 | 1530759 | 2021-07-19 | Cleburne | Alabama | 1029 | 1556 | 44 |
1530760 | 1530760 | 2021-07-19 | Coffee | Alabama | 1031 | 5883 | 130 |
1530761 | 1530761 | 2021-07-19 | Colbert | Alabama | 1033 | 6498 | 141 |
1530762 | 1530762 | 2021-07-19 | Conecuh | Alabama | 1035 | 1171 | 30 |
1530763 | 1530763 | 2021-07-19 | Coosa | Alabama | 1037 | 1134 | 29 |
1530764 | 1530764 | 2021-07-19 | Covington | Alabama | 1039 | 4447 | 125 |
1530765 | 1530765 | 2021-07-19 | Crenshaw | Alabama | 1041 | 1619 | 57 |
1530766 | 1530766 | 2021-07-19 | Cullman | Alabama | 1043 | 10127 | 203 |
1530767 | 1530767 | 2021-07-19 | Dale | Alabama | 1045 | 5137 | 117 |
1530768 | 1530768 | 2021-07-19 | Dallas | Alabama | 1047 | 3658 | 161 |
1530769 | 1530769 | 2021-07-19 | DeKalb | Alabama | 1049 | 9143 | 191 |
1530770 | 1530770 | 2021-07-19 | Elmore | Alabama | 1051 | 10518 | 216 |
1530771 | 1530771 | 2021-07-19 | Escambia | Alabama | 1053 | 4109 | 82 |
1530772 | 1530772 | 2021-07-19 | Etowah | Alabama | 1055 | 14442 | 368 |
1530773 | 1530773 | 2021-07-19 | Fayette | Alabama | 1057 | 2226 | 63 |
1530774 | 1530774 | 2021-07-19 | Franklin | Alabama | 1059 | 4367 | 81 |
1530775 | 1530775 | 2021-07-19 | Geneva | Alabama | 1061 | 2647 | 83 |
1530776 | 1530776 | 2021-07-19 | Greene | Alabama | 1063 | 950 | 35 |
1530777 | 1530777 | 2021-07-19 | Hale | Alabama | 1065 | 2298 | 78 |
1530778 | 1530778 | 2021-07-19 | Henry | Alabama | 1067 | 2013 | 44 |
1530779 | 1530779 | 2021-07-19 | Houston | Alabama | 1069 | 11196 | 291 |
1530780 | 1530780 | 2021-07-19 | Jackson | Alabama | 1071 | 7169 | 117 |
1530781 | 1530781 | 2021-07-19 | Jefferson | Alabama | 1073 | 82320 | 1581 |
1530782 | 1530782 | 2021-07-19 | Lamar | Alabama | 1075 | 1485 | 38 |
1530783 | 1530783 | 2021-07-19 | Lauderdale | Alabama | 1077 | 9813 | 253 |
1530784 | 1530784 | 2021-07-19 | Lawrence | Alabama | 1079 | 3164 | 101 |
1530785 | 1530785 | 2021-07-19 | Lee | Alabama | 1081 | 16587 | 179 |
1530786 | 1530786 | 2021-07-19 | Limestone | Alabama | 1083 | 10359 | 158 |
1530787 | 1530787 | 2021-07-19 | Lowndes | Alabama | 1085 | 1436 | 54 |
1530788 | 1530788 | 2021-07-19 | Macon | Alabama | 1087 | 1658 | 52 |
1530789 | 1530789 | 2021-07-19 | Madison | Alabama | 1089 | 36330 | 529 |
1530790 | 1530790 | 2021-07-19 | Marengo | Alabama | 1091 | 2560 | 67 |
1530791 | 1530791 | 2021-07-19 | Marion | Alabama | 1093 | 3341 | 106 |
1530792 | 1530792 | 2021-07-19 | Marshall | Alabama | 1095 | 12656 | 235 |
1530793 | 1530793 | 2021-07-19 | Mobile | Alabama | 1097 | 44111 | 849 |
1530794 | 1530794 | 2021-07-19 | Monroe | Alabama | 1099 | 1876 | 41 |
1530795 | 1530795 | 2021-07-19 | Montgomery | Alabama | 1101 | 25470 | 622 |
1530796 | 1530796 | 2021-07-19 | Morgan | Alabama | 1103 | 14814 | 288 |
1530797 | 1530797 | 2021-07-19 | Perry | Alabama | 1105 | 1095 | 28 |
1530798 | 1530798 | 2021-07-19 | Pickens | Alabama | 1107 | 2379 | 62 |
1530799 | 1530799 | 2021-07-19 | Pike | Alabama | 1109 | 3210 | 78 |
1530800 | 1530800 | 2021-07-19 | Randolph | Alabama | 1111 | 1907 | 44 |
1530801 | 1530801 | 2021-07-19 | Russell | Alabama | 1113 | 4627 | 42 |
1530802 | 1530802 | 2021-07-19 | Shelby | Alabama | 1117 | 26225 | 255 |
1530803 | 1530803 | 2021-07-19 | St. Clair | Alabama | 1115 | 10345 | 251 |
1530804 | 1530804 | 2021-07-19 | Sumter | Alabama | 1119 | 1071 | 32 |
1530805 | 1530805 | 2021-07-19 | Talladega | Alabama | 1121 | 8599 | 186 |
1530806 | 1530806 | 2021-07-19 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1530807 | 1530807 | 2021-07-19 | Tuscaloosa | Alabama | 1125 | 26463 | 465 |
1530808 | 1530808 | 2021-07-19 | Walker | Alabama | 1127 | 7498 | 286 |
1530809 | 1530809 | 2021-07-19 | Washington | Alabama | 1129 | 1734 | 39 |
1530810 | 1530810 | 2021-07-19 | Wilcox | Alabama | 1131 | 1281 | 31 |
1530811 | 1530811 | 2021-07-19 | Winston | Alabama | 1133 | 2867 | 72 |
1530812 | 1530812 | 2021-07-19 | Aleutians East Borough | Alaska | 2013 | 368 | 3 |
1530813 | 1530813 | 2021-07-19 | Aleutians West Census Area | Alaska | 2016 | 733 | 0 |
1530814 | 1530814 | 2021-07-19 | Anchorage | Alaska | 2020 | 31844 | 179 |
1530815 | 1530815 | 2021-07-19 | Bethel Census Area | Alaska | 2050 | 3936 | 22 |
1530816 | 1530816 | 2021-07-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 201 | 0 |
1530817 | 1530817 | 2021-07-19 | Denali Borough | Alaska | 2068 | 113 | 0 |
1530818 | 1530818 | 2021-07-19 | Dillingham Census Area | Alaska | 2070 | 238 | 2 |
1530819 | 1530819 | 2021-07-19 | Fairbanks North Star Borough | Alaska | 2090 | 8046 | 44 |
1530820 | 1530820 | 2021-07-19 | Haines Borough | Alaska | 2100 | 28 | 0 |
1530821 | 1530821 | 2021-07-19 | Juneau City and Borough | Alaska | 2110 | 1516 | 3 |
1530822 | 1530822 | 2021-07-19 | Kenai Peninsula Borough | Alaska | 2122 | 4730 | 19 |
1530823 | 1530823 | 2021-07-19 | Ketchikan Gateway Borough | Alaska | 2130 | 668 | 1 |
1530824 | 1530824 | 2021-07-19 | Kodiak Island Borough | Alaska | 2150 | 1140 | 6 |
1530825 | 1530825 | 2021-07-19 | Kusilvak Census Area | Alaska | 2158 | 1451 | 4 |
1530826 | 1530826 | 2021-07-19 | Matanuska-Susitna Borough | Alaska | 2170 | 11894 | 58 |
1530827 | 1530827 | 2021-07-19 | Nome Census Area | Alaska | 2180 | 414 | 0 |
1530828 | 1530828 | 2021-07-19 | North Slope Borough | Alaska | 2185 | 1086 | 4 |
1530829 | 1530829 | 2021-07-19 | Northwest Arctic Borough | Alaska | 2188 | 630 | 2 |
1530830 | 1530830 | 2021-07-19 | Petersburg Borough | Alaska | 2195 | 181 | 0 |
1530831 | 1530831 | 2021-07-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 180 | 3 |
1530832 | 1530832 | 2021-07-19 | Sitka City and Borough | Alaska | 2220 | 506 | 1 |
1530833 | 1530833 | 2021-07-19 | Skagway Municipality | Alaska | 2230 | 24 | 0 |
1530834 | 1530834 | 2021-07-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 772 | 5 |
1530835 | 1530835 | 2021-07-19 | Unknown | Alaska | 315 | 0 | |
1530836 | 1530836 | 2021-07-19 | Valdez-Cordova Census Area | Alaska | 2261 | 749 | 2 |
1530837 | 1530837 | 2021-07-19 | Wrangell City and Borough | Alaska | 2275 | 66 | 0 |
1530838 | 1530838 | 2021-07-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 81 | 2 |
1530839 | 1530839 | 2021-07-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 371 | 4 |
1530840 | 1530840 | 2021-07-19 | Apache | Arizona | 4001 | 11612 | 437 |
1530841 | 1530841 | 2021-07-19 | Cochise | Arizona | 4003 | 12285 | 294 |
1530842 | 1530842 | 2021-07-19 | Coconino | Arizona | 4005 | 18270 | 331 |
1530843 | 1530843 | 2021-07-19 | Gila | Arizona | 4007 | 7211 | 232 |
1530844 | 1530844 | 2021-07-19 | Graham | Arizona | 4009 | 5621 | 85 |
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);