ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,244 rows where date = "2020-10-23" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 253
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Minnesota 88
- Ohio 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
- Unknown 26
- Franklin 25
- Jackson 24
- Lincoln 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 |
---|---|---|---|---|---|---|---|
657604 | 657604 | 2020-10-23 | Autauga | Alabama | 1001 | 2030 | 30 |
657605 | 657605 | 2020-10-23 | Baldwin | Alabama | 1003 | 6615 | 69 |
657606 | 657606 | 2020-10-23 | Barbour | Alabama | 1005 | 1012 | 9 |
657607 | 657607 | 2020-10-23 | Bibb | Alabama | 1007 | 825 | 14 |
657608 | 657608 | 2020-10-23 | Blount | Alabama | 1009 | 1911 | 25 |
657609 | 657609 | 2020-10-23 | Bullock | Alabama | 1011 | 639 | 17 |
657610 | 657610 | 2020-10-23 | Butler | Alabama | 1013 | 1002 | 40 |
657611 | 657611 | 2020-10-23 | Calhoun | Alabama | 1015 | 4224 | 61 |
657612 | 657612 | 2020-10-23 | Chambers | Alabama | 1017 | 1343 | 43 |
657613 | 657613 | 2020-10-23 | Cherokee | Alabama | 1019 | 731 | 14 |
657614 | 657614 | 2020-10-23 | Chilton | Alabama | 1021 | 1858 | 32 |
657615 | 657615 | 2020-10-23 | Choctaw | Alabama | 1023 | 390 | 12 |
657616 | 657616 | 2020-10-23 | Clarke | Alabama | 1025 | 1336 | 17 |
657617 | 657617 | 2020-10-23 | Clay | Alabama | 1027 | 736 | 12 |
657618 | 657618 | 2020-10-23 | Cleburne | Alabama | 1029 | 551 | 8 |
657619 | 657619 | 2020-10-23 | Coffee | Alabama | 1031 | 1732 | 11 |
657620 | 657620 | 2020-10-23 | Colbert | Alabama | 1033 | 1987 | 31 |
657621 | 657621 | 2020-10-23 | Conecuh | Alabama | 1035 | 560 | 13 |
657622 | 657622 | 2020-10-23 | Coosa | Alabama | 1037 | 203 | 3 |
657623 | 657623 | 2020-10-23 | Covington | Alabama | 1039 | 1714 | 29 |
657624 | 657624 | 2020-10-23 | Crenshaw | Alabama | 1041 | 603 | 30 |
657625 | 657625 | 2020-10-23 | Cullman | Alabama | 1043 | 2399 | 25 |
657626 | 657626 | 2020-10-23 | Dale | Alabama | 1045 | 1665 | 51 |
657627 | 657627 | 2020-10-23 | Dallas | Alabama | 1047 | 1863 | 27 |
657628 | 657628 | 2020-10-23 | DeKalb | Alabama | 1049 | 3360 | 29 |
657629 | 657629 | 2020-10-23 | Elmore | Alabama | 1051 | 3173 | 53 |
657630 | 657630 | 2020-10-23 | Escambia | Alabama | 1053 | 1722 | 30 |
657631 | 657631 | 2020-10-23 | Etowah | Alabama | 1055 | 4214 | 50 |
657632 | 657632 | 2020-10-23 | Fayette | Alabama | 1057 | 569 | 13 |
657633 | 657633 | 2020-10-23 | Franklin | Alabama | 1059 | 2032 | 31 |
657634 | 657634 | 2020-10-23 | Geneva | Alabama | 1061 | 861 | 7 |
657635 | 657635 | 2020-10-23 | Greene | Alabama | 1063 | 342 | 16 |
657636 | 657636 | 2020-10-23 | Hale | Alabama | 1065 | 758 | 30 |
657637 | 657637 | 2020-10-23 | Henry | Alabama | 1067 | 643 | 6 |
657638 | 657638 | 2020-10-23 | Houston | Alabama | 1069 | 3717 | 34 |
657639 | 657639 | 2020-10-23 | Jackson | Alabama | 1071 | 2125 | 15 |
657640 | 657640 | 2020-10-23 | Jefferson | Alabama | 1073 | 22988 | 375 |
657641 | 657641 | 2020-10-23 | Lamar | Alabama | 1075 | 474 | 5 |
657642 | 657642 | 2020-10-23 | Lauderdale | Alabama | 1077 | 2180 | 42 |
657643 | 657643 | 2020-10-23 | Lawrence | Alabama | 1079 | 837 | 32 |
657644 | 657644 | 2020-10-23 | Lee | Alabama | 1081 | 6517 | 65 |
657645 | 657645 | 2020-10-23 | Limestone | Alabama | 1083 | 2797 | 30 |
657646 | 657646 | 2020-10-23 | Lowndes | Alabama | 1085 | 704 | 28 |
657647 | 657647 | 2020-10-23 | Macon | Alabama | 1087 | 530 | 20 |
657648 | 657648 | 2020-10-23 | Madison | Alabama | 1089 | 9228 | 94 |
657649 | 657649 | 2020-10-23 | Marengo | Alabama | 1091 | 1002 | 22 |
657650 | 657650 | 2020-10-23 | Marion | Alabama | 1093 | 1071 | 29 |
657651 | 657651 | 2020-10-23 | Marshall | Alabama | 1095 | 4372 | 49 |
657652 | 657652 | 2020-10-23 | Mobile | Alabama | 1097 | 16788 | 315 |
657653 | 657653 | 2020-10-23 | Monroe | Alabama | 1099 | 645 | 10 |
657654 | 657654 | 2020-10-23 | Montgomery | Alabama | 1101 | 9978 | 197 |
657655 | 657655 | 2020-10-23 | Morgan | Alabama | 1103 | 4071 | 35 |
657656 | 657656 | 2020-10-23 | Perry | Alabama | 1105 | 585 | 6 |
657657 | 657657 | 2020-10-23 | Pickens | Alabama | 1107 | 836 | 18 |
657658 | 657658 | 2020-10-23 | Pike | Alabama | 1109 | 1327 | 13 |
657659 | 657659 | 2020-10-23 | Randolph | Alabama | 1111 | 820 | 16 |
657660 | 657660 | 2020-10-23 | Russell | Alabama | 1113 | 1928 | 3 |
657661 | 657661 | 2020-10-23 | Shelby | Alabama | 1117 | 7274 | 63 |
657662 | 657662 | 2020-10-23 | St. Clair | Alabama | 1115 | 2891 | 42 |
657663 | 657663 | 2020-10-23 | Sumter | Alabama | 1119 | 472 | 21 |
657664 | 657664 | 2020-10-23 | Talladega | Alabama | 1121 | 2636 | 35 |
657665 | 657665 | 2020-10-23 | Tallapoosa | Alabama | 1123 | 1313 | 87 |
657666 | 657666 | 2020-10-23 | Tuscaloosa | Alabama | 1125 | 10235 | 140 |
657667 | 657667 | 2020-10-23 | Walker | Alabama | 1127 | 2755 | 93 |
657668 | 657668 | 2020-10-23 | Washington | Alabama | 1129 | 734 | 12 |
657669 | 657669 | 2020-10-23 | Wilcox | Alabama | 1131 | 564 | 12 |
657670 | 657670 | 2020-10-23 | Winston | Alabama | 1133 | 919 | 13 |
657671 | 657671 | 2020-10-23 | Aleutians East Borough | Alaska | 2013 | 15 | 0 |
657672 | 657672 | 2020-10-23 | Aleutians West Census Area | Alaska | 2016 | 98 | 0 |
657673 | 657673 | 2020-10-23 | Anchorage | Alaska | 2020 | 6860 | 42 |
657674 | 657674 | 2020-10-23 | Bethel Census Area | Alaska | 2050 | 333 | 1 |
657675 | 657675 | 2020-10-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 103 | 0 |
657676 | 657676 | 2020-10-23 | Denali Borough | Alaska | 2068 | 24 | 0 |
657677 | 657677 | 2020-10-23 | Dillingham Census Area | Alaska | 2070 | 45 | 0 |
657678 | 657678 | 2020-10-23 | Fairbanks North Star Borough | Alaska | 2090 | 1914 | 13 |
657679 | 657679 | 2020-10-23 | Haines Borough | Alaska | 2100 | 11 | 0 |
657680 | 657680 | 2020-10-23 | Juneau City and Borough | Alaska | 2110 | 466 | 2 |
657681 | 657681 | 2020-10-23 | Kenai Peninsula Borough | Alaska | 2122 | 811 | 1 |
657682 | 657682 | 2020-10-23 | Ketchikan Gateway Borough | Alaska | 2130 | 78 | 0 |
657683 | 657683 | 2020-10-23 | Kodiak Island Borough | Alaska | 2150 | 94 | 0 |
657684 | 657684 | 2020-10-23 | Kusilvak Census Area | Alaska | 2158 | 108 | 0 |
657685 | 657685 | 2020-10-23 | Matanuska-Susitna Borough | Alaska | 2170 | 966 | 2 |
657686 | 657686 | 2020-10-23 | Nome Census Area | Alaska | 2180 | 125 | 0 |
657687 | 657687 | 2020-10-23 | North Slope Borough | Alaska | 2185 | 234 | 0 |
657688 | 657688 | 2020-10-23 | Northwest Arctic Borough | Alaska | 2188 | 221 | 0 |
657689 | 657689 | 2020-10-23 | Petersburg Borough | Alaska | 2195 | 14 | 0 |
657690 | 657690 | 2020-10-23 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 33 | 0 |
657691 | 657691 | 2020-10-23 | Sitka City and Borough | Alaska | 2220 | 71 | 0 |
657692 | 657692 | 2020-10-23 | Skagway Municipality | Alaska | 2230 | 5 | 0 |
657693 | 657693 | 2020-10-23 | Southeast Fairbanks Census Area | Alaska | 2240 | 64 | 0 |
657694 | 657694 | 2020-10-23 | Unknown | Alaska | 59 | 0 | |
657695 | 657695 | 2020-10-23 | Valdez-Cordova Census Area | Alaska | 2261 | 155 | 1 |
657696 | 657696 | 2020-10-23 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
657697 | 657697 | 2020-10-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 35 | 0 |
657698 | 657698 | 2020-10-23 | Yukon-Koyukuk Census Area | Alaska | 2290 | 106 | 2 |
657699 | 657699 | 2020-10-23 | Apache | Arizona | 4001 | 3826 | 168 |
657700 | 657700 | 2020-10-23 | Cochise | Arizona | 4003 | 2127 | 73 |
657701 | 657701 | 2020-10-23 | Coconino | Arizona | 4005 | 4925 | 147 |
657702 | 657702 | 2020-10-23 | Gila | Arizona | 4007 | 1830 | 70 |
657703 | 657703 | 2020-10-23 | Graham | Arizona | 4009 | 1105 | 27 |
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);