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 23,149
- Georgia 17,369
- Virginia 13,744
- Kentucky 11,932
- Missouri 10,975
- North Carolina 10,608
- Illinois 10,370
- Tennessee 10,233
- Indiana 10,062
- Iowa 9,873
- Ohio 9,529
- Mississippi 8,981
- Minnesota 8,761
- Michigan 8,754
- Kansas 8,601
- Arkansas 7,960
- Florida 7,666
- Oklahoma 7,545
- Wisconsin 7,505
- Pennsylvania 7,417
- Alabama 7,288
- Louisiana 7,223
- Nebraska 6,763
- California 6,727
- New York 6,716
- Colorado 6,603
- Puerto Rico 5,309
- West Virginia 5,290
- South Dakota 5,243
- South Carolina 5,176
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
318714 | 318714 | 2020-07-10 | Autauga | Alabama | 1001 | 670 | 15 |
318715 | 318715 | 2020-07-10 | Baldwin | Alabama | 1003 | 1187 | 12 |
318716 | 318716 | 2020-07-10 | Barbour | Alabama | 1005 | 381 | 2 |
318717 | 318717 | 2020-07-10 | Bibb | Alabama | 1007 | 218 | 1 |
318718 | 318718 | 2020-07-10 | Blount | Alabama | 1009 | 292 | 1 |
318719 | 318719 | 2020-07-10 | Bullock | Alabama | 1011 | 381 | 11 |
318720 | 318720 | 2020-07-10 | Butler | Alabama | 1013 | 648 | 29 |
318721 | 318721 | 2020-07-10 | Calhoun | Alabama | 1015 | 465 | 5 |
318722 | 318722 | 2020-07-10 | Chambers | Alabama | 1017 | 679 | 27 |
318723 | 318723 | 2020-07-10 | Cherokee | Alabama | 1019 | 118 | 7 |
318724 | 318724 | 2020-07-10 | Chilton | Alabama | 1021 | 303 | 3 |
318725 | 318725 | 2020-07-10 | Choctaw | Alabama | 1023 | 210 | 12 |
318726 | 318726 | 2020-07-10 | Clarke | Alabama | 1025 | 304 | 6 |
318727 | 318727 | 2020-07-10 | Clay | Alabama | 1027 | 82 | 2 |
318728 | 318728 | 2020-07-10 | Cleburne | Alabama | 1029 | 42 | 1 |
318729 | 318729 | 2020-07-10 | Coffee | Alabama | 1031 | 421 | 4 |
318730 | 318730 | 2020-07-10 | Colbert | Alabama | 1033 | 491 | 6 |
318731 | 318731 | 2020-07-10 | Conecuh | Alabama | 1035 | 229 | 8 |
318732 | 318732 | 2020-07-10 | Coosa | Alabama | 1037 | 63 | 1 |
318733 | 318733 | 2020-07-10 | Covington | Alabama | 1039 | 421 | 13 |
318734 | 318734 | 2020-07-10 | Crenshaw | Alabama | 1041 | 130 | 3 |
318735 | 318735 | 2020-07-10 | Cullman | Alabama | 1043 | 564 | 6 |
318736 | 318736 | 2020-07-10 | Dale | Alabama | 1045 | 375 | 1 |
318737 | 318737 | 2020-07-10 | Dallas | Alabama | 1047 | 990 | 9 |
318738 | 318738 | 2020-07-10 | DeKalb | Alabama | 1049 | 874 | 7 |
318739 | 318739 | 2020-07-10 | Elmore | Alabama | 1051 | 1025 | 21 |
318740 | 318740 | 2020-07-10 | Escambia | Alabama | 1053 | 468 | 8 |
318741 | 318741 | 2020-07-10 | Etowah | Alabama | 1055 | 931 | 14 |
318742 | 318742 | 2020-07-10 | Fayette | Alabama | 1057 | 84 | 1 |
318743 | 318743 | 2020-07-10 | Franklin | Alabama | 1059 | 933 | 16 |
318744 | 318744 | 2020-07-10 | Geneva | Alabama | 1061 | 95 | 0 |
318745 | 318745 | 2020-07-10 | Greene | Alabama | 1063 | 192 | 9 |
318746 | 318746 | 2020-07-10 | Hale | Alabama | 1065 | 348 | 23 |
318747 | 318747 | 2020-07-10 | Henry | Alabama | 1067 | 147 | 4 |
318748 | 318748 | 2020-07-10 | Houston | Alabama | 1069 | 576 | 8 |
318749 | 318749 | 2020-07-10 | Jackson | Alabama | 1071 | 406 | 3 |
318750 | 318750 | 2020-07-10 | Jefferson | Alabama | 1073 | 6283 | 169 |
318751 | 318751 | 2020-07-10 | Lamar | Alabama | 1075 | 88 | 1 |
318752 | 318752 | 2020-07-10 | Lauderdale | Alabama | 1077 | 558 | 6 |
318753 | 318753 | 2020-07-10 | Lawrence | Alabama | 1079 | 124 | 0 |
318754 | 318754 | 2020-07-10 | Lee | Alabama | 1081 | 1571 | 38 |
318755 | 318755 | 2020-07-10 | Limestone | Alabama | 1083 | 602 | 4 |
318756 | 318756 | 2020-07-10 | Lowndes | Alabama | 1085 | 484 | 24 |
318757 | 318757 | 2020-07-10 | Macon | Alabama | 1087 | 218 | 9 |
318758 | 318758 | 2020-07-10 | Madison | Alabama | 1089 | 2012 | 10 |
318759 | 318759 | 2020-07-10 | Marengo | Alabama | 1091 | 344 | 11 |
318760 | 318760 | 2020-07-10 | Marion | Alabama | 1093 | 271 | 14 |
318761 | 318761 | 2020-07-10 | Marshall | Alabama | 1095 | 1918 | 11 |
318762 | 318762 | 2020-07-10 | Mobile | Alabama | 1097 | 4649 | 142 |
318763 | 318763 | 2020-07-10 | Monroe | Alabama | 1099 | 257 | 4 |
318764 | 318764 | 2020-07-10 | Montgomery | Alabama | 1101 | 4445 | 113 |
318765 | 318765 | 2020-07-10 | Morgan | Alabama | 1103 | 1255 | 5 |
318766 | 318766 | 2020-07-10 | Perry | Alabama | 1105 | 224 | 2 |
318767 | 318767 | 2020-07-10 | Pickens | Alabama | 1107 | 265 | 6 |
318768 | 318768 | 2020-07-10 | Pike | Alabama | 1109 | 473 | 5 |
318769 | 318769 | 2020-07-10 | Randolph | Alabama | 1111 | 250 | 9 |
318770 | 318770 | 2020-07-10 | Russell | Alabama | 1113 | 672 | 0 |
318771 | 318771 | 2020-07-10 | Shelby | Alabama | 1117 | 1587 | 24 |
318772 | 318772 | 2020-07-10 | St. Clair | Alabama | 1115 | 499 | 2 |
318773 | 318773 | 2020-07-10 | Sumter | Alabama | 1119 | 288 | 13 |
318774 | 318774 | 2020-07-10 | Talladega | Alabama | 1121 | 379 | 8 |
318775 | 318775 | 2020-07-10 | Tallapoosa | Alabama | 1123 | 634 | 70 |
318776 | 318776 | 2020-07-10 | Tuscaloosa | Alabama | 1125 | 2608 | 54 |
318777 | 318777 | 2020-07-10 | Walker | Alabama | 1127 | 1070 | 31 |
318778 | 318778 | 2020-07-10 | Washington | Alabama | 1129 | 139 | 7 |
318779 | 318779 | 2020-07-10 | Wilcox | Alabama | 1131 | 302 | 8 |
318780 | 318780 | 2020-07-10 | Winston | Alabama | 1133 | 296 | 5 |
318781 | 318781 | 2020-07-10 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
318782 | 318782 | 2020-07-10 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
318783 | 318783 | 2020-07-10 | Anchorage | Alaska | 2020 | 698 | 8 |
318784 | 318784 | 2020-07-10 | Bethel Census Area | Alaska | 2050 | 14 | 0 |
318785 | 318785 | 2020-07-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 56 | 0 |
318786 | 318786 | 2020-07-10 | Denali Borough | Alaska | 2068 | 1 | 0 |
318787 | 318787 | 2020-07-10 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
318788 | 318788 | 2020-07-10 | Fairbanks North Star Borough | Alaska | 2090 | 220 | 2 |
318789 | 318789 | 2020-07-10 | Haines Borough | Alaska | 2100 | 6 | 0 |
318790 | 318790 | 2020-07-10 | Juneau City and Borough | Alaska | 2110 | 53 | 2 |
318791 | 318791 | 2020-07-10 | Kenai Peninsula Borough | Alaska | 2122 | 209 | 1 |
318792 | 318792 | 2020-07-10 | Ketchikan Gateway Borough | Alaska | 2130 | 32 | 0 |
318793 | 318793 | 2020-07-10 | Kodiak Island Borough | Alaska | 2150 | 10 | 0 |
318794 | 318794 | 2020-07-10 | Kusilvak Census Area | Alaska | 2158 | 2 | 0 |
318795 | 318795 | 2020-07-10 | Matanuska-Susitna Borough | Alaska | 2170 | 135 | 2 |
318796 | 318796 | 2020-07-10 | Nome Census Area | Alaska | 2180 | 14 | 0 |
318797 | 318797 | 2020-07-10 | North Slope Borough | Alaska | 2185 | 4 | 0 |
318798 | 318798 | 2020-07-10 | Northwest Arctic Borough | Alaska | 2188 | 6 | 0 |
318799 | 318799 | 2020-07-10 | Petersburg Borough | Alaska | 2195 | 8 | 0 |
318800 | 318800 | 2020-07-10 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
318801 | 318801 | 2020-07-10 | Sitka City and Borough | Alaska | 2220 | 18 | 0 |
318802 | 318802 | 2020-07-10 | Southeast Fairbanks Census Area | Alaska | 2240 | 16 | 0 |
318803 | 318803 | 2020-07-10 | Unknown | Alaska | 5 | 0 | |
318804 | 318804 | 2020-07-10 | Valdez-Cordova Census Area | Alaska | 2261 | 27 | 0 |
318805 | 318805 | 2020-07-10 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
318806 | 318806 | 2020-07-10 | Yukon-Koyukuk Census Area | Alaska | 2290 | 5 | 0 |
318807 | 318807 | 2020-07-10 | Apache | Arizona | 4001 | 2534 | 101 |
318808 | 318808 | 2020-07-10 | Cochise | Arizona | 4003 | 984 | 21 |
318809 | 318809 | 2020-07-10 | Coconino | Arizona | 4005 | 2379 | 97 |
318810 | 318810 | 2020-07-10 | Gila | Arizona | 4007 | 424 | 12 |
318811 | 318811 | 2020-07-10 | Graham | Arizona | 4009 | 184 | 3 |
318812 | 318812 | 2020-07-10 | Greenlee | Arizona | 4011 | 29 | 1 |
318813 | 318813 | 2020-07-10 | La Paz | Arizona | 4012 | 394 | 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);