ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,247 rows where date = "2021-03-23" 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 106
- 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
- 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 |
---|---|---|---|---|---|---|---|
1147644 | 1147644 | 2021-03-23 | Autauga | Alabama | 1001 | 6525 | 99 |
1147645 | 1147645 | 2021-03-23 | Baldwin | Alabama | 1003 | 20354 | 297 |
1147646 | 1147646 | 2021-03-23 | Barbour | Alabama | 1005 | 2213 | 54 |
1147647 | 1147647 | 2021-03-23 | Bibb | Alabama | 1007 | 2530 | 58 |
1147648 | 1147648 | 2021-03-23 | Blount | Alabama | 1009 | 6388 | 130 |
1147649 | 1147649 | 2021-03-23 | Bullock | Alabama | 1011 | 1195 | 39 |
1147650 | 1147650 | 2021-03-23 | Butler | Alabama | 1013 | 2073 | 66 |
1147651 | 1147651 | 2021-03-23 | Calhoun | Alabama | 1015 | 14162 | 304 |
1147652 | 1147652 | 2021-03-23 | Chambers | Alabama | 1017 | 3470 | 114 |
1147653 | 1147653 | 2021-03-23 | Cherokee | Alabama | 1019 | 1794 | 42 |
1147654 | 1147654 | 2021-03-23 | Chilton | Alabama | 1021 | 4006 | 108 |
1147655 | 1147655 | 2021-03-23 | Choctaw | Alabama | 1023 | 582 | 24 |
1147656 | 1147656 | 2021-03-23 | Clarke | Alabama | 1025 | 3478 | 57 |
1147657 | 1147657 | 2021-03-23 | Clay | Alabama | 1027 | 1479 | 54 |
1147658 | 1147658 | 2021-03-23 | Cleburne | Alabama | 1029 | 1445 | 41 |
1147659 | 1147659 | 2021-03-23 | Coffee | Alabama | 1031 | 5346 | 107 |
1147660 | 1147660 | 2021-03-23 | Colbert | Alabama | 1033 | 6127 | 125 |
1147661 | 1147661 | 2021-03-23 | Conecuh | Alabama | 1035 | 1085 | 25 |
1147662 | 1147662 | 2021-03-23 | Coosa | Alabama | 1037 | 943 | 24 |
1147663 | 1147663 | 2021-03-23 | Covington | Alabama | 1039 | 4030 | 110 |
1147664 | 1147664 | 2021-03-23 | Crenshaw | Alabama | 1041 | 1490 | 57 |
1147665 | 1147665 | 2021-03-23 | Cullman | Alabama | 1043 | 9294 | 186 |
1147666 | 1147666 | 2021-03-23 | Dale | Alabama | 1045 | 4727 | 109 |
1147667 | 1147667 | 2021-03-23 | Dallas | Alabama | 1047 | 3505 | 146 |
1147668 | 1147668 | 2021-03-23 | DeKalb | Alabama | 1049 | 8670 | 179 |
1147669 | 1147669 | 2021-03-23 | Elmore | Alabama | 1051 | 9851 | 199 |
1147670 | 1147670 | 2021-03-23 | Escambia | Alabama | 1053 | 3845 | 74 |
1147671 | 1147671 | 2021-03-23 | Etowah | Alabama | 1055 | 13608 | 339 |
1147672 | 1147672 | 2021-03-23 | Fayette | Alabama | 1057 | 2051 | 58 |
1147673 | 1147673 | 2021-03-23 | Franklin | Alabama | 1059 | 4180 | 82 |
1147674 | 1147674 | 2021-03-23 | Geneva | Alabama | 1061 | 2432 | 71 |
1147675 | 1147675 | 2021-03-23 | Greene | Alabama | 1063 | 899 | 33 |
1147676 | 1147676 | 2021-03-23 | Hale | Alabama | 1065 | 2149 | 72 |
1147677 | 1147677 | 2021-03-23 | Henry | Alabama | 1067 | 1859 | 42 |
1147678 | 1147678 | 2021-03-23 | Houston | Alabama | 1069 | 10257 | 269 |
1147679 | 1147679 | 2021-03-23 | Jackson | Alabama | 1071 | 6702 | 105 |
1147680 | 1147680 | 2021-03-23 | Jefferson | Alabama | 1073 | 74093 | 1447 |
1147681 | 1147681 | 2021-03-23 | Lamar | Alabama | 1075 | 1372 | 33 |
1147682 | 1147682 | 2021-03-23 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1147683 | 1147683 | 2021-03-23 | Lawrence | Alabama | 1079 | 2910 | 92 |
1147684 | 1147684 | 2021-03-23 | Lee | Alabama | 1081 | 15292 | 166 |
1147685 | 1147685 | 2021-03-23 | Limestone | Alabama | 1083 | 9676 | 142 |
1147686 | 1147686 | 2021-03-23 | Lowndes | Alabama | 1085 | 1357 | 52 |
1147687 | 1147687 | 2021-03-23 | Macon | Alabama | 1087 | 1521 | 47 |
1147688 | 1147688 | 2021-03-23 | Madison | Alabama | 1089 | 33285 | 485 |
1147689 | 1147689 | 2021-03-23 | Marengo | Alabama | 1091 | 2489 | 58 |
1147690 | 1147690 | 2021-03-23 | Marion | Alabama | 1093 | 3040 | 99 |
1147691 | 1147691 | 2021-03-23 | Marshall | Alabama | 1095 | 11806 | 218 |
1147692 | 1147692 | 2021-03-23 | Mobile | Alabama | 1097 | 37320 | 777 |
1147693 | 1147693 | 2021-03-23 | Monroe | Alabama | 1099 | 1695 | 39 |
1147694 | 1147694 | 2021-03-23 | Montgomery | Alabama | 1101 | 23451 | 543 |
1147695 | 1147695 | 2021-03-23 | Morgan | Alabama | 1103 | 14072 | 260 |
1147696 | 1147696 | 2021-03-23 | Perry | Alabama | 1105 | 1077 | 27 |
1147697 | 1147697 | 2021-03-23 | Pickens | Alabama | 1107 | 2321 | 57 |
1147698 | 1147698 | 2021-03-23 | Pike | Alabama | 1109 | 2995 | 74 |
1147699 | 1147699 | 2021-03-23 | Randolph | Alabama | 1111 | 1734 | 41 |
1147700 | 1147700 | 2021-03-23 | Russell | Alabama | 1113 | 4194 | 36 |
1147701 | 1147701 | 2021-03-23 | Shelby | Alabama | 1117 | 22824 | 230 |
1147702 | 1147702 | 2021-03-23 | St. Clair | Alabama | 1115 | 9277 | 231 |
1147703 | 1147703 | 2021-03-23 | Sumter | Alabama | 1119 | 1024 | 31 |
1147704 | 1147704 | 2021-03-23 | Talladega | Alabama | 1121 | 7882 | 167 |
1147705 | 1147705 | 2021-03-23 | Tallapoosa | Alabama | 1123 | 3834 | 144 |
1147706 | 1147706 | 2021-03-23 | Tuscaloosa | Alabama | 1125 | 24871 | 434 |
1147707 | 1147707 | 2021-03-23 | Walker | Alabama | 1127 | 7017 | 269 |
1147708 | 1147708 | 2021-03-23 | Washington | Alabama | 1129 | 1634 | 38 |
1147709 | 1147709 | 2021-03-23 | Wilcox | Alabama | 1131 | 1246 | 26 |
1147710 | 1147710 | 2021-03-23 | Winston | Alabama | 1133 | 2702 | 71 |
1147711 | 1147711 | 2021-03-23 | Aleutians East Borough | Alaska | 2013 | 363 | 2 |
1147712 | 1147712 | 2021-03-23 | Aleutians West Census Area | Alaska | 2016 | 646 | 0 |
1147713 | 1147713 | 2021-03-23 | Anchorage | Alaska | 2020 | 27675 | 161 |
1147714 | 1147714 | 2021-03-23 | Bethel Census Area | Alaska | 2050 | 3724 | 20 |
1147715 | 1147715 | 2021-03-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 184 | 0 |
1147716 | 1147716 | 2021-03-23 | Denali Borough | Alaska | 2068 | 79 | 0 |
1147717 | 1147717 | 2021-03-23 | Dillingham Census Area | Alaska | 2070 | 207 | 1 |
1147718 | 1147718 | 2021-03-23 | Fairbanks North Star Borough | Alaska | 2090 | 6467 | 32 |
1147719 | 1147719 | 2021-03-23 | Haines Borough | Alaska | 2100 | 26 | 0 |
1147720 | 1147720 | 2021-03-23 | Juneau City and Borough | Alaska | 2110 | 1255 | 3 |
1147721 | 1147721 | 2021-03-23 | Kenai Peninsula Borough | Alaska | 2122 | 4057 | 19 |
1147722 | 1147722 | 2021-03-23 | Ketchikan Gateway Borough | Alaska | 2130 | 372 | 1 |
1147723 | 1147723 | 2021-03-23 | Kodiak Island Borough | Alaska | 2150 | 1062 | 5 |
1147724 | 1147724 | 2021-03-23 | Kusilvak Census Area | Alaska | 2158 | 1218 | 3 |
1147725 | 1147725 | 2021-03-23 | Matanuska-Susitna Borough | Alaska | 2170 | 9541 | 34 |
1147726 | 1147726 | 2021-03-23 | Nome Census Area | Alaska | 2180 | 334 | 0 |
1147727 | 1147727 | 2021-03-23 | North Slope Borough | Alaska | 2185 | 1030 | 4 |
1147728 | 1147728 | 2021-03-23 | Northwest Arctic Borough | Alaska | 2188 | 596 | 2 |
1147729 | 1147729 | 2021-03-23 | Petersburg Borough | Alaska | 2195 | 146 | 0 |
1147730 | 1147730 | 2021-03-23 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 77 | 1 |
1147731 | 1147731 | 2021-03-23 | Sitka City and Borough | Alaska | 2220 | 316 | 0 |
1147732 | 1147732 | 2021-03-23 | Skagway Municipality | Alaska | 2230 | 19 | 0 |
1147733 | 1147733 | 2021-03-23 | Southeast Fairbanks Census Area | Alaska | 2240 | 581 | 3 |
1147734 | 1147734 | 2021-03-23 | Unknown | Alaska | 263 | 0 | |
1147735 | 1147735 | 2021-03-23 | Valdez-Cordova Census Area | Alaska | 2261 | 531 | 2 |
1147736 | 1147736 | 2021-03-23 | Wrangell City and Borough | Alaska | 2275 | 29 | 0 |
1147737 | 1147737 | 2021-03-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 69 | 1 |
1147738 | 1147738 | 2021-03-23 | Yukon-Koyukuk Census Area | Alaska | 2290 | 345 | 4 |
1147739 | 1147739 | 2021-03-23 | Apache | Arizona | 4001 | 10772 | 405 |
1147740 | 1147740 | 2021-03-23 | Cochise | Arizona | 4003 | 11547 | 277 |
1147741 | 1147741 | 2021-03-23 | Coconino | Arizona | 4005 | 16963 | 323 |
1147742 | 1147742 | 2021-03-23 | Gila | Arizona | 4007 | 6499 | 218 |
1147743 | 1147743 | 2021-03-23 | Graham | Arizona | 4009 | 5350 | 76 |
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);