ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,251 rows where "date" is on date 2021-12-18 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 |
---|---|---|---|---|---|---|---|
2024611 | 2024611 | 2021-12-18 | Autauga | Alabama | 1001 | 10663 | 159 |
2024612 | 2024612 | 2021-12-18 | Baldwin | Alabama | 1003 | 38484 | 592 |
2024613 | 2024613 | 2021-12-18 | Barbour | Alabama | 1005 | 3722 | 81 |
2024614 | 2024614 | 2021-12-18 | Bibb | Alabama | 1007 | 4396 | 95 |
2024615 | 2024615 | 2021-12-18 | Blount | Alabama | 1009 | 10954 | 195 |
2024616 | 2024616 | 2021-12-18 | Bullock | Alabama | 1011 | 1541 | 46 |
2024617 | 2024617 | 2021-12-18 | Butler | Alabama | 1013 | 3490 | 102 |
2024618 | 2024618 | 2021-12-18 | Calhoun | Alabama | 1015 | 22794 | 525 |
2024619 | 2024619 | 2021-12-18 | Chambers | Alabama | 1017 | 5861 | 145 |
2024620 | 2024620 | 2021-12-18 | Cherokee | Alabama | 1019 | 3261 | 64 |
2024621 | 2024621 | 2021-12-18 | Chilton | Alabama | 1021 | 7211 | 172 |
2024622 | 2024622 | 2021-12-18 | Choctaw | Alabama | 1023 | 959 | 30 |
2024623 | 2024623 | 2021-12-18 | Clarke | Alabama | 1025 | 4877 | 87 |
2024624 | 2024624 | 2021-12-18 | Clay | Alabama | 1027 | 2555 | 69 |
2024625 | 2024625 | 2021-12-18 | Cleburne | Alabama | 1029 | 2574 | 60 |
2024626 | 2024626 | 2021-12-18 | Coffee | Alabama | 1031 | 9511 | 194 |
2024627 | 2024627 | 2021-12-18 | Colbert | Alabama | 1033 | 9457 | 213 |
2024628 | 2024628 | 2021-12-18 | Conecuh | Alabama | 1035 | 1948 | 62 |
2024629 | 2024629 | 2021-12-18 | Coosa | Alabama | 1037 | 1889 | 48 |
2024630 | 2024630 | 2021-12-18 | Covington | Alabama | 1039 | 7052 | 199 |
2024631 | 2024631 | 2021-12-18 | Crenshaw | Alabama | 1041 | 2643 | 79 |
2024632 | 2024632 | 2021-12-18 | Cullman | Alabama | 1043 | 16440 | 307 |
2024633 | 2024633 | 2021-12-18 | Dale | Alabama | 1045 | 9129 | 193 |
2024634 | 2024634 | 2021-12-18 | Dallas | Alabama | 1047 | 5351 | 212 |
2024635 | 2024635 | 2021-12-18 | DeKalb | Alabama | 1049 | 13235 | 275 |
2024636 | 2024636 | 2021-12-18 | Elmore | Alabama | 1051 | 16169 | 296 |
2024637 | 2024637 | 2021-12-18 | Escambia | Alabama | 1053 | 6996 | 148 |
2024638 | 2024638 | 2021-12-18 | Etowah | Alabama | 1055 | 20218 | 526 |
2024639 | 2024639 | 2021-12-18 | Fayette | Alabama | 1057 | 3362 | 86 |
2024640 | 2024640 | 2021-12-18 | Franklin | Alabama | 1059 | 6440 | 109 |
2024641 | 2024641 | 2021-12-18 | Geneva | Alabama | 1061 | 4706 | 137 |
2024642 | 2024642 | 2021-12-18 | Greene | Alabama | 1063 | 1313 | 45 |
2024643 | 2024643 | 2021-12-18 | Hale | Alabama | 1065 | 3230 | 89 |
2024644 | 2024644 | 2021-12-18 | Henry | Alabama | 1067 | 3252 | 66 |
2024645 | 2024645 | 2021-12-18 | Houston | Alabama | 1069 | 18004 | 429 |
2024646 | 2024646 | 2021-12-18 | Jackson | Alabama | 1071 | 10360 | 200 |
2024647 | 2024647 | 2021-12-18 | Jefferson | Alabama | 1073 | 117421 | 2021 |
2024648 | 2024648 | 2021-12-18 | Lamar | Alabama | 1075 | 2558 | 55 |
2024649 | 2024649 | 2021-12-18 | Lauderdale | Alabama | 1077 | 15274 | 312 |
2024650 | 2024650 | 2021-12-18 | Lawrence | Alabama | 1079 | 4910 | 133 |
2024651 | 2024651 | 2021-12-18 | Lee | Alabama | 1081 | 25912 | 266 |
2024652 | 2024652 | 2021-12-18 | Limestone | Alabama | 1083 | 16403 | 226 |
2024653 | 2024653 | 2021-12-18 | Lowndes | Alabama | 1085 | 1789 | 68 |
2024654 | 2024654 | 2021-12-18 | Macon | Alabama | 1087 | 2495 | 68 |
2024655 | 2024655 | 2021-12-18 | Madison | Alabama | 1089 | 54377 | 755 |
2024656 | 2024656 | 2021-12-18 | Marengo | Alabama | 1091 | 3435 | 93 |
2024657 | 2024657 | 2021-12-18 | Marion | Alabama | 1093 | 5478 | 132 |
2024658 | 2024658 | 2021-12-18 | Marshall | Alabama | 1095 | 19062 | 321 |
2024659 | 2024659 | 2021-12-18 | Mobile | Alabama | 1097 | 74869 | 1390 |
2024660 | 2024660 | 2021-12-18 | Monroe | Alabama | 1099 | 3395 | 66 |
2024661 | 2024661 | 2021-12-18 | Montgomery | Alabama | 1101 | 34946 | 789 |
2024662 | 2024662 | 2021-12-18 | Morgan | Alabama | 1103 | 22874 | 419 |
2024663 | 2024663 | 2021-12-18 | Perry | Alabama | 1105 | 1424 | 41 |
2024664 | 2024664 | 2021-12-18 | Pickens | Alabama | 1107 | 3378 | 91 |
2024665 | 2024665 | 2021-12-18 | Pike | Alabama | 1109 | 5188 | 111 |
2024666 | 2024666 | 2021-12-18 | Randolph | Alabama | 1111 | 3416 | 67 |
2024667 | 2024667 | 2021-12-18 | Russell | Alabama | 1113 | 7183 | 66 |
2024668 | 2024668 | 2021-12-18 | Shelby | Alabama | 1117 | 38889 | 378 |
2024669 | 2024669 | 2021-12-18 | St. Clair | Alabama | 1115 | 17193 | 364 |
2024670 | 2024670 | 2021-12-18 | Sumter | Alabama | 1119 | 1412 | 42 |
2024671 | 2024671 | 2021-12-18 | Talladega | Alabama | 1121 | 14423 | 304 |
2024672 | 2024672 | 2021-12-18 | Tallapoosa | Alabama | 1123 | 7419 | 204 |
2024673 | 2024673 | 2021-12-18 | Tuscaloosa | Alabama | 1125 | 36535 | 649 |
2024674 | 2024674 | 2021-12-18 | Walker | Alabama | 1127 | 12363 | 387 |
2024675 | 2024675 | 2021-12-18 | Washington | Alabama | 1129 | 2576 | 51 |
2024676 | 2024676 | 2021-12-18 | Wilcox | Alabama | 1131 | 1797 | 38 |
2024677 | 2024677 | 2021-12-18 | Winston | Alabama | 1133 | 4851 | 111 |
2024678 | 2024678 | 2021-12-18 | Aleutians East Borough | Alaska | 2013 | 450 | 3 |
2024679 | 2024679 | 2021-12-18 | Aleutians West Census Area | Alaska | 2016 | 945 | 1 |
2024680 | 2024680 | 2021-12-18 | Anchorage | Alaska | 2020 | 62208 | 412 |
2024681 | 2024681 | 2021-12-18 | Bethel Census Area | Alaska | 2050 | 6900 | 28 |
2024682 | 2024682 | 2021-12-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 554 | 1 |
2024683 | 2024683 | 2021-12-18 | Denali Borough | Alaska | 2068 | 292 | 1 |
2024684 | 2024684 | 2021-12-18 | Dillingham Census Area | Alaska | 2070 | 987 | 10 |
2024685 | 2024685 | 2021-12-18 | Fairbanks North Star Borough | Alaska | 2090 | 17308 | 114 |
2024686 | 2024686 | 2021-12-18 | Haines Borough | Alaska | 2100 | 239 | 1 |
2024687 | 2024687 | 2021-12-18 | Juneau City and Borough | Alaska | 2110 | 4272 | 13 |
2024688 | 2024688 | 2021-12-18 | Kenai Peninsula Borough | Alaska | 2122 | 12039 | 77 |
2024689 | 2024689 | 2021-12-18 | Ketchikan Gateway Borough | Alaska | 2130 | 2268 | 12 |
2024690 | 2024690 | 2021-12-18 | Kodiak Island Borough | Alaska | 2150 | 2712 | 10 |
2024691 | 2024691 | 2021-12-18 | Kusilvak Census Area | Alaska | 2158 | 2385 | 9 |
2024692 | 2024692 | 2021-12-18 | Matanuska-Susitna Borough | Alaska | 2170 | 24792 | 159 |
2024693 | 2024693 | 2021-12-18 | Nome Census Area | Alaska | 2180 | 2334 | 3 |
2024694 | 2024694 | 2021-12-18 | North Slope Borough | Alaska | 2185 | 2905 | 9 |
2024695 | 2024695 | 2021-12-18 | Northwest Arctic Borough | Alaska | 2188 | 2372 | 9 |
2024696 | 2024696 | 2021-12-18 | Petersburg Borough | Alaska | 2195 | 524 | 2 |
2024697 | 2024697 | 2021-12-18 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 620 | 6 |
2024698 | 2024698 | 2021-12-18 | Sitka City and Borough | Alaska | 2220 | 1269 | 5 |
2024699 | 2024699 | 2021-12-18 | Skagway Municipality | Alaska | 2230 | 89 | 0 |
2024700 | 2024700 | 2021-12-18 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 13 |
2024701 | 2024701 | 2021-12-18 | Unknown | Alaska | 538 | 1 | |
2024702 | 2024702 | 2021-12-18 | Valdez-Cordova Census Area | Alaska | 2261 | 1925 | 11 |
2024703 | 2024703 | 2021-12-18 | Wrangell City and Borough | Alaska | 2275 | 220 | 1 |
2024704 | 2024704 | 2021-12-18 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 278 | 3 |
2024705 | 2024705 | 2021-12-18 | Yukon-Koyukuk Census Area | Alaska | 2290 | 816 | 8 |
2024706 | 2024706 | 2021-12-18 | Unknown | American Samoa | 10 | 0 | |
2024707 | 2024707 | 2021-12-18 | Apache | Arizona | 4001 | 15889 | 534 |
2024708 | 2024708 | 2021-12-18 | Cochise | Arizona | 4003 | 19469 | 440 |
2024709 | 2024709 | 2021-12-18 | Coconino | Arizona | 4005 | 26596 | 404 |
2024710 | 2024710 | 2021-12-18 | Gila | Arizona | 4007 | 11825 | 294 |
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);