ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,573 rows where date = "2020-04-08" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 167
- Georgia 156
- Virginia 118
- Kentucky 95
- North Carolina 90
- Indiana 89
- Tennessee 88
- Missouri 87
- Ohio 84
- Illinois 80
- Mississippi 80
- Iowa 79
- Michigan 73
- Arkansas 70
- Florida 67
- Pennsylvania 67
- Minnesota 66
- Alabama 65
- Louisiana 64
- Oklahoma 60
- Wisconsin 60
- Kansas 58
- New York 58
- Colorado 55
- California 53
- South Carolina 46
- West Virginia 42
- Washington 38
- Nebraska 35
- South Dakota 33
- …
fips >30
county >30
- Unknown 31
- Washington 30
- Jefferson 24
- Franklin 23
- Jackson 20
- Lincoln 20
- Madison 18
- Montgomery 16
- Union 15
- Clay 14
- Marion 14
- Monroe 14
- Greene 13
- Warren 13
- Carroll 12
- Crawford 11
- Fayette 11
- Johnson 11
- Lee 11
- Adams 10
- Clark 10
- Douglas 10
- Grant 10
- Henry 10
- Lawrence 10
- Marshall 10
- Morgan 10
- Polk 10
- Wayne 10
- Clinton 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
40627 | 40627 | 2020-04-08 | Autauga | Alabama | 1001 | 12 | 1 |
40628 | 40628 | 2020-04-08 | Baldwin | Alabama | 1003 | 49 | 1 |
40629 | 40629 | 2020-04-08 | Barbour | Alabama | 1005 | 3 | 0 |
40630 | 40630 | 2020-04-08 | Bibb | Alabama | 1007 | 9 | 0 |
40631 | 40631 | 2020-04-08 | Blount | Alabama | 1009 | 10 | 0 |
40632 | 40632 | 2020-04-08 | Bullock | Alabama | 1011 | 3 | 0 |
40633 | 40633 | 2020-04-08 | Butler | Alabama | 1013 | 3 | 0 |
40634 | 40634 | 2020-04-08 | Calhoun | Alabama | 1015 | 52 | 0 |
40635 | 40635 | 2020-04-08 | Chambers | Alabama | 1017 | 140 | 8 |
40636 | 40636 | 2020-04-08 | Cherokee | Alabama | 1019 | 7 | 0 |
40637 | 40637 | 2020-04-08 | Chilton | Alabama | 1021 | 22 | 0 |
40638 | 40638 | 2020-04-08 | Choctaw | Alabama | 1023 | 6 | 0 |
40639 | 40639 | 2020-04-08 | Clarke | Alabama | 1025 | 10 | 0 |
40640 | 40640 | 2020-04-08 | Clay | Alabama | 1027 | 11 | 0 |
40641 | 40641 | 2020-04-08 | Cleburne | Alabama | 1029 | 12 | 0 |
40642 | 40642 | 2020-04-08 | Coffee | Alabama | 1031 | 12 | 0 |
40643 | 40643 | 2020-04-08 | Colbert | Alabama | 1033 | 7 | 1 |
40644 | 40644 | 2020-04-08 | Conecuh | Alabama | 1035 | 4 | 0 |
40645 | 40645 | 2020-04-08 | Coosa | Alabama | 1037 | 9 | 0 |
40646 | 40646 | 2020-04-08 | Covington | Alabama | 1039 | 10 | 0 |
40647 | 40647 | 2020-04-08 | Crenshaw | Alabama | 1041 | 2 | 0 |
40648 | 40648 | 2020-04-08 | Cullman | Alabama | 1043 | 22 | 1 |
40649 | 40649 | 2020-04-08 | Dale | Alabama | 1045 | 4 | 0 |
40650 | 40650 | 2020-04-08 | Dallas | Alabama | 1047 | 7 | 0 |
40651 | 40651 | 2020-04-08 | DeKalb | Alabama | 1049 | 14 | 0 |
40652 | 40652 | 2020-04-08 | Elmore | Alabama | 1051 | 24 | 0 |
40653 | 40653 | 2020-04-08 | Escambia | Alabama | 1053 | 5 | 0 |
40654 | 40654 | 2020-04-08 | Etowah | Alabama | 1055 | 47 | 4 |
40655 | 40655 | 2020-04-08 | Fayette | Alabama | 1057 | 1 | 0 |
40656 | 40656 | 2020-04-08 | Franklin | Alabama | 1059 | 7 | 0 |
40657 | 40657 | 2020-04-08 | Greene | Alabama | 1063 | 12 | 0 |
40658 | 40658 | 2020-04-08 | Hale | Alabama | 1065 | 7 | 0 |
40659 | 40659 | 2020-04-08 | Henry | Alabama | 1067 | 5 | 0 |
40660 | 40660 | 2020-04-08 | Houston | Alabama | 1069 | 27 | 1 |
40661 | 40661 | 2020-04-08 | Jackson | Alabama | 1071 | 20 | 1 |
40662 | 40662 | 2020-04-08 | Jefferson | Alabama | 1073 | 492 | 14 |
40663 | 40663 | 2020-04-08 | Lamar | Alabama | 1075 | 6 | 0 |
40664 | 40664 | 2020-04-08 | Lauderdale | Alabama | 1077 | 19 | 2 |
40665 | 40665 | 2020-04-08 | Lawrence | Alabama | 1079 | 8 | 0 |
40666 | 40666 | 2020-04-08 | Lee | Alabama | 1081 | 190 | 5 |
40667 | 40667 | 2020-04-08 | Limestone | Alabama | 1083 | 32 | 0 |
40668 | 40668 | 2020-04-08 | Lowndes | Alabama | 1085 | 11 | 0 |
40669 | 40669 | 2020-04-08 | Macon | Alabama | 1087 | 6 | 1 |
40670 | 40670 | 2020-04-08 | Madison | Alabama | 1089 | 165 | 2 |
40671 | 40671 | 2020-04-08 | Marengo | Alabama | 1091 | 14 | 1 |
40672 | 40672 | 2020-04-08 | Marion | Alabama | 1093 | 23 | 3 |
40673 | 40673 | 2020-04-08 | Marshall | Alabama | 1095 | 45 | 1 |
40674 | 40674 | 2020-04-08 | Mobile | Alabama | 1097 | 249 | 8 |
40675 | 40675 | 2020-04-08 | Monroe | Alabama | 1099 | 6 | 1 |
40676 | 40676 | 2020-04-08 | Montgomery | Alabama | 1101 | 81 | 2 |
40677 | 40677 | 2020-04-08 | Morgan | Alabama | 1103 | 34 | 0 |
40678 | 40678 | 2020-04-08 | Pickens | Alabama | 1107 | 15 | 0 |
40679 | 40679 | 2020-04-08 | Pike | Alabama | 1109 | 16 | 0 |
40680 | 40680 | 2020-04-08 | Randolph | Alabama | 1111 | 15 | 2 |
40681 | 40681 | 2020-04-08 | Russell | Alabama | 1113 | 14 | 0 |
40682 | 40682 | 2020-04-08 | Shelby | Alabama | 1117 | 165 | 5 |
40683 | 40683 | 2020-04-08 | St. Clair | Alabama | 1115 | 35 | 0 |
40684 | 40684 | 2020-04-08 | Sumter | Alabama | 1119 | 17 | 0 |
40685 | 40685 | 2020-04-08 | Talladega | Alabama | 1121 | 26 | 0 |
40686 | 40686 | 2020-04-08 | Tallapoosa | Alabama | 1123 | 43 | 1 |
40687 | 40687 | 2020-04-08 | Tuscaloosa | Alabama | 1125 | 85 | 0 |
40688 | 40688 | 2020-04-08 | Walker | Alabama | 1127 | 68 | 0 |
40689 | 40689 | 2020-04-08 | Washington | Alabama | 1129 | 7 | 1 |
40690 | 40690 | 2020-04-08 | Wilcox | Alabama | 1131 | 13 | 0 |
40691 | 40691 | 2020-04-08 | Winston | Alabama | 1133 | 3 | 0 |
40692 | 40692 | 2020-04-08 | Anchorage | Alaska | 2020 | 103 | 4 |
40693 | 40693 | 2020-04-08 | Bethel Census Area | Alaska | 2050 | 1 | 0 |
40694 | 40694 | 2020-04-08 | Fairbanks North Star Borough | Alaska | 2090 | 71 | 1 |
40695 | 40695 | 2020-04-08 | Juneau City and Borough | Alaska | 2110 | 14 | 0 |
40696 | 40696 | 2020-04-08 | Kenai Peninsula Borough | Alaska | 2122 | 12 | 0 |
40697 | 40697 | 2020-04-08 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
40698 | 40698 | 2020-04-08 | Matanuska-Susitna Borough | Alaska | 2170 | 5 | 0 |
40699 | 40699 | 2020-04-08 | Petersburg Borough | Alaska | 2195 | 1 | 0 |
40700 | 40700 | 2020-04-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
40701 | 40701 | 2020-04-08 | Unknown | Alaska | 1 | 0 | |
40702 | 40702 | 2020-04-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
40703 | 40703 | 2020-04-08 | Apache | Arizona | 4001 | 34 | 3 |
40704 | 40704 | 2020-04-08 | Cochise | Arizona | 4003 | 9 | 0 |
40705 | 40705 | 2020-04-08 | Coconino | Arizona | 4005 | 186 | 14 |
40706 | 40706 | 2020-04-08 | Gila | Arizona | 4007 | 3 | 0 |
40707 | 40707 | 2020-04-08 | Graham | Arizona | 4009 | 2 | 0 |
40708 | 40708 | 2020-04-08 | Greenlee | Arizona | 4011 | 1 | 0 |
40709 | 40709 | 2020-04-08 | La Paz | Arizona | 4012 | 3 | 0 |
40710 | 40710 | 2020-04-08 | Maricopa | Arizona | 4013 | 1559 | 37 |
40711 | 40711 | 2020-04-08 | Mohave | Arizona | 4015 | 23 | 1 |
40712 | 40712 | 2020-04-08 | Navajo | Arizona | 4017 | 240 | 7 |
40713 | 40713 | 2020-04-08 | Pima | Arizona | 4019 | 464 | 16 |
40714 | 40714 | 2020-04-08 | Pinal | Arizona | 4021 | 124 | 0 |
40715 | 40715 | 2020-04-08 | Santa Cruz | Arizona | 4023 | 6 | 0 |
40716 | 40716 | 2020-04-08 | Unknown | Arizona | 0 | 1 | |
40717 | 40717 | 2020-04-08 | Yavapai | Arizona | 4025 | 58 | 1 |
40718 | 40718 | 2020-04-08 | Yuma | Arizona | 4027 | 14 | 0 |
40719 | 40719 | 2020-04-08 | Arkansas | Arkansas | 5001 | 1 | 0 |
40720 | 40720 | 2020-04-08 | Ashley | Arkansas | 5003 | 8 | 0 |
40721 | 40721 | 2020-04-08 | Baxter | Arkansas | 5005 | 4 | 0 |
40722 | 40722 | 2020-04-08 | Benton | Arkansas | 5007 | 46 | 0 |
40723 | 40723 | 2020-04-08 | Boone | Arkansas | 5009 | 3 | 0 |
40724 | 40724 | 2020-04-08 | Bradley | Arkansas | 5011 | 5 | 0 |
40725 | 40725 | 2020-04-08 | Carroll | Arkansas | 5015 | 2 | 0 |
40726 | 40726 | 2020-04-08 | Chicot | Arkansas | 5017 | 4 | 0 |
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);