ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,248 rows where date = "2021-04-08" 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 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
- …
fips >30
county >30
- Washington 31
- Unknown 27
- Jefferson 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 |
---|---|---|---|---|---|---|---|
1199606 | 1199606 | 2021-04-08 | Autauga | Alabama | 1001 | 6702 | 103 |
1199607 | 1199607 | 2021-04-08 | Baldwin | Alabama | 1003 | 20588 | 300 |
1199608 | 1199608 | 2021-04-08 | Barbour | Alabama | 1005 | 2244 | 55 |
1199609 | 1199609 | 2021-04-08 | Bibb | Alabama | 1007 | 2560 | 58 |
1199610 | 1199610 | 2021-04-08 | Blount | Alabama | 1009 | 6472 | 134 |
1199611 | 1199611 | 2021-04-08 | Bullock | Alabama | 1011 | 1213 | 40 |
1199612 | 1199612 | 2021-04-08 | Butler | Alabama | 1013 | 2119 | 66 |
1199613 | 1199613 | 2021-04-08 | Calhoun | Alabama | 1015 | 14263 | 310 |
1199614 | 1199614 | 2021-04-08 | Chambers | Alabama | 1017 | 3494 | 122 |
1199615 | 1199615 | 2021-04-08 | Cherokee | Alabama | 1019 | 1818 | 43 |
1199616 | 1199616 | 2021-04-08 | Chilton | Alabama | 1021 | 4073 | 109 |
1199617 | 1199617 | 2021-04-08 | Choctaw | Alabama | 1023 | 585 | 24 |
1199618 | 1199618 | 2021-04-08 | Clarke | Alabama | 1025 | 3457 | 60 |
1199619 | 1199619 | 2021-04-08 | Clay | Alabama | 1027 | 1490 | 54 |
1199620 | 1199620 | 2021-04-08 | Cleburne | Alabama | 1029 | 1458 | 41 |
1199621 | 1199621 | 2021-04-08 | Coffee | Alabama | 1031 | 5393 | 112 |
1199622 | 1199622 | 2021-04-08 | Colbert | Alabama | 1033 | 6196 | 129 |
1199623 | 1199623 | 2021-04-08 | Conecuh | Alabama | 1035 | 1090 | 28 |
1199624 | 1199624 | 2021-04-08 | Coosa | Alabama | 1037 | 989 | 27 |
1199625 | 1199625 | 2021-04-08 | Covington | Alabama | 1039 | 4053 | 112 |
1199626 | 1199626 | 2021-04-08 | Crenshaw | Alabama | 1041 | 1491 | 57 |
1199627 | 1199627 | 2021-04-08 | Cullman | Alabama | 1043 | 9450 | 188 |
1199628 | 1199628 | 2021-04-08 | Dale | Alabama | 1045 | 4764 | 109 |
1199629 | 1199629 | 2021-04-08 | Dallas | Alabama | 1047 | 3519 | 149 |
1199630 | 1199630 | 2021-04-08 | DeKalb | Alabama | 1049 | 8727 | 181 |
1199631 | 1199631 | 2021-04-08 | Elmore | Alabama | 1051 | 9977 | 199 |
1199632 | 1199632 | 2021-04-08 | Escambia | Alabama | 1053 | 3872 | 74 |
1199633 | 1199633 | 2021-04-08 | Etowah | Alabama | 1055 | 13654 | 345 |
1199634 | 1199634 | 2021-04-08 | Fayette | Alabama | 1057 | 2086 | 60 |
1199635 | 1199635 | 2021-04-08 | Franklin | Alabama | 1059 | 4195 | 82 |
1199636 | 1199636 | 2021-04-08 | Geneva | Alabama | 1061 | 2457 | 75 |
1199637 | 1199637 | 2021-04-08 | Greene | Alabama | 1063 | 906 | 34 |
1199638 | 1199638 | 2021-04-08 | Hale | Alabama | 1065 | 2186 | 75 |
1199639 | 1199639 | 2021-04-08 | Henry | Alabama | 1067 | 1876 | 44 |
1199640 | 1199640 | 2021-04-08 | Houston | Alabama | 1069 | 10370 | 277 |
1199641 | 1199641 | 2021-04-08 | Jackson | Alabama | 1071 | 6749 | 108 |
1199642 | 1199642 | 2021-04-08 | Jefferson | Alabama | 1073 | 75199 | 1485 |
1199643 | 1199643 | 2021-04-08 | Lamar | Alabama | 1075 | 1392 | 34 |
1199644 | 1199644 | 2021-04-08 | Lauderdale | Alabama | 1077 | 9188 | 227 |
1199645 | 1199645 | 2021-04-08 | Lawrence | Alabama | 1079 | 2950 | 95 |
1199646 | 1199646 | 2021-04-08 | Lee | Alabama | 1081 | 15480 | 165 |
1199647 | 1199647 | 2021-04-08 | Limestone | Alabama | 1083 | 9791 | 146 |
1199648 | 1199648 | 2021-04-08 | Lowndes | Alabama | 1085 | 1363 | 53 |
1199649 | 1199649 | 2021-04-08 | Macon | Alabama | 1087 | 1545 | 48 |
1199650 | 1199650 | 2021-04-08 | Madison | Alabama | 1089 | 33754 | 490 |
1199651 | 1199651 | 2021-04-08 | Marengo | Alabama | 1091 | 2485 | 60 |
1199652 | 1199652 | 2021-04-08 | Marion | Alabama | 1093 | 3064 | 100 |
1199653 | 1199653 | 2021-04-08 | Marshall | Alabama | 1095 | 11935 | 218 |
1199654 | 1199654 | 2021-04-08 | Mobile | Alabama | 1097 | 37661 | 796 |
1199655 | 1199655 | 2021-04-08 | Monroe | Alabama | 1099 | 1712 | 40 |
1199656 | 1199656 | 2021-04-08 | Montgomery | Alabama | 1101 | 23905 | 561 |
1199657 | 1199657 | 2021-04-08 | Morgan | Alabama | 1103 | 14131 | 268 |
1199658 | 1199658 | 2021-04-08 | Perry | Alabama | 1105 | 1079 | 26 |
1199659 | 1199659 | 2021-04-08 | Pickens | Alabama | 1107 | 2329 | 58 |
1199660 | 1199660 | 2021-04-08 | Pike | Alabama | 1109 | 3052 | 75 |
1199661 | 1199661 | 2021-04-08 | Randolph | Alabama | 1111 | 1763 | 41 |
1199662 | 1199662 | 2021-04-08 | Russell | Alabama | 1113 | 4261 | 37 |
1199663 | 1199663 | 2021-04-08 | Shelby | Alabama | 1117 | 23085 | 237 |
1199664 | 1199664 | 2021-04-08 | St. Clair | Alabama | 1115 | 9409 | 234 |
1199665 | 1199665 | 2021-04-08 | Sumter | Alabama | 1119 | 1031 | 32 |
1199666 | 1199666 | 2021-04-08 | Talladega | Alabama | 1121 | 8023 | 168 |
1199667 | 1199667 | 2021-04-08 | Tallapoosa | Alabama | 1123 | 3889 | 147 |
1199668 | 1199668 | 2021-04-08 | Tuscaloosa | Alabama | 1125 | 25221 | 441 |
1199669 | 1199669 | 2021-04-08 | Walker | Alabama | 1127 | 7080 | 274 |
1199670 | 1199670 | 2021-04-08 | Washington | Alabama | 1129 | 1638 | 38 |
1199671 | 1199671 | 2021-04-08 | Wilcox | Alabama | 1131 | 1243 | 26 |
1199672 | 1199672 | 2021-04-08 | Winston | Alabama | 1133 | 2722 | 71 |
1199673 | 1199673 | 2021-04-08 | Aleutians East Borough | Alaska | 2013 | 363 | 2 |
1199674 | 1199674 | 2021-04-08 | Aleutians West Census Area | Alaska | 2016 | 654 | 0 |
1199675 | 1199675 | 2021-04-08 | Anchorage | Alaska | 2020 | 28862 | 161 |
1199676 | 1199676 | 2021-04-08 | Bethel Census Area | Alaska | 2050 | 3820 | 20 |
1199677 | 1199677 | 2021-04-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 187 | 0 |
1199678 | 1199678 | 2021-04-08 | Denali Borough | Alaska | 2068 | 91 | 0 |
1199679 | 1199679 | 2021-04-08 | Dillingham Census Area | Alaska | 2070 | 208 | 1 |
1199680 | 1199680 | 2021-04-08 | Fairbanks North Star Borough | Alaska | 2090 | 6727 | 32 |
1199681 | 1199681 | 2021-04-08 | Haines Borough | Alaska | 2100 | 26 | 0 |
1199682 | 1199682 | 2021-04-08 | Juneau City and Borough | Alaska | 2110 | 1295 | 3 |
1199683 | 1199683 | 2021-04-08 | Kenai Peninsula Borough | Alaska | 2122 | 4183 | 19 |
1199684 | 1199684 | 2021-04-08 | Ketchikan Gateway Borough | Alaska | 2130 | 383 | 1 |
1199685 | 1199685 | 2021-04-08 | Kodiak Island Borough | Alaska | 2150 | 1084 | 5 |
1199686 | 1199686 | 2021-04-08 | Kusilvak Census Area | Alaska | 2158 | 1229 | 3 |
1199687 | 1199687 | 2021-04-08 | Matanuska-Susitna Borough | Alaska | 2170 | 10383 | 35 |
1199688 | 1199688 | 2021-04-08 | Nome Census Area | Alaska | 2180 | 341 | 0 |
1199689 | 1199689 | 2021-04-08 | North Slope Borough | Alaska | 2185 | 1043 | 4 |
1199690 | 1199690 | 2021-04-08 | Northwest Arctic Borough | Alaska | 2188 | 598 | 2 |
1199691 | 1199691 | 2021-04-08 | Petersburg Borough | Alaska | 2195 | 153 | 0 |
1199692 | 1199692 | 2021-04-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1199693 | 1199693 | 2021-04-08 | Sitka City and Borough | Alaska | 2220 | 328 | 0 |
1199694 | 1199694 | 2021-04-08 | Skagway Municipality | Alaska | 2230 | 19 | 0 |
1199695 | 1199695 | 2021-04-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 623 | 3 |
1199696 | 1199696 | 2021-04-08 | Unknown | Alaska | 288 | 0 | |
1199697 | 1199697 | 2021-04-08 | Valdez-Cordova Census Area | Alaska | 2261 | 593 | 2 |
1199698 | 1199698 | 2021-04-08 | Wrangell City and Borough | Alaska | 2275 | 34 | 0 |
1199699 | 1199699 | 2021-04-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 70 | 1 |
1199700 | 1199700 | 2021-04-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 349 | 4 |
1199701 | 1199701 | 2021-04-08 | Apache | Arizona | 4001 | 11208 | 421 |
1199702 | 1199702 | 2021-04-08 | Cochise | Arizona | 4003 | 11686 | 281 |
1199703 | 1199703 | 2021-04-08 | Coconino | Arizona | 4005 | 17238 | 329 |
1199704 | 1199704 | 2021-04-08 | Gila | Arizona | 4007 | 6575 | 223 |
1199705 | 1199705 | 2021-04-08 | Graham | Arizona | 4009 | 5372 | 77 |
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);