ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,243 rows where date = "2020-11-10" 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 102
- 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
- Franklin 25
- Unknown 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 |
---|---|---|---|---|---|---|---|
715987 | 715987 | 2020-11-10 | Autauga | Alabama | 1001 | 2328 | 30 |
715988 | 715988 | 2020-11-10 | Baldwin | Alabama | 1003 | 7348 | 84 |
715989 | 715989 | 2020-11-10 | Barbour | Alabama | 1005 | 1107 | 9 |
715990 | 715990 | 2020-11-10 | Bibb | Alabama | 1007 | 948 | 17 |
715991 | 715991 | 2020-11-10 | Blount | Alabama | 1009 | 2378 | 26 |
715992 | 715992 | 2020-11-10 | Bullock | Alabama | 1011 | 665 | 18 |
715993 | 715993 | 2020-11-10 | Butler | Alabama | 1013 | 1061 | 41 |
715994 | 715994 | 2020-11-10 | Calhoun | Alabama | 1015 | 5254 | 68 |
715995 | 715995 | 2020-11-10 | Chambers | Alabama | 1017 | 1507 | 48 |
715996 | 715996 | 2020-11-10 | Cherokee | Alabama | 1019 | 857 | 15 |
715997 | 715997 | 2020-11-10 | Chilton | Alabama | 1021 | 2027 | 35 |
715998 | 715998 | 2020-11-10 | Choctaw | Alabama | 1023 | 407 | 12 |
715999 | 715999 | 2020-11-10 | Clarke | Alabama | 1025 | 1451 | 18 |
716000 | 716000 | 2020-11-10 | Clay | Alabama | 1027 | 819 | 13 |
716001 | 716001 | 2020-11-10 | Cleburne | Alabama | 1029 | 630 | 11 |
716002 | 716002 | 2020-11-10 | Coffee | Alabama | 1031 | 2018 | 12 |
716003 | 716003 | 2020-11-10 | Colbert | Alabama | 1033 | 2515 | 33 |
716004 | 716004 | 2020-11-10 | Conecuh | Alabama | 1035 | 616 | 13 |
716005 | 716005 | 2020-11-10 | Coosa | Alabama | 1037 | 240 | 3 |
716006 | 716006 | 2020-11-10 | Covington | Alabama | 1039 | 1967 | 32 |
716007 | 716007 | 2020-11-10 | Crenshaw | Alabama | 1041 | 654 | 30 |
716008 | 716008 | 2020-11-10 | Cullman | Alabama | 1043 | 3328 | 29 |
716009 | 716009 | 2020-11-10 | Dale | Alabama | 1045 | 2070 | 55 |
716010 | 716010 | 2020-11-10 | Dallas | Alabama | 1047 | 2008 | 28 |
716011 | 716011 | 2020-11-10 | DeKalb | Alabama | 1049 | 3942 | 34 |
716012 | 716012 | 2020-11-10 | Elmore | Alabama | 1051 | 3495 | 60 |
716013 | 716013 | 2020-11-10 | Escambia | Alabama | 1053 | 1835 | 31 |
716014 | 716014 | 2020-11-10 | Etowah | Alabama | 1055 | 4967 | 60 |
716015 | 716015 | 2020-11-10 | Fayette | Alabama | 1057 | 684 | 15 |
716016 | 716016 | 2020-11-10 | Franklin | Alabama | 1059 | 2261 | 34 |
716017 | 716017 | 2020-11-10 | Geneva | Alabama | 1061 | 1038 | 8 |
716018 | 716018 | 2020-11-10 | Greene | Alabama | 1063 | 361 | 17 |
716019 | 716019 | 2020-11-10 | Hale | Alabama | 1065 | 833 | 30 |
716020 | 716020 | 2020-11-10 | Henry | Alabama | 1067 | 787 | 6 |
716021 | 716021 | 2020-11-10 | Houston | Alabama | 1069 | 4543 | 36 |
716022 | 716022 | 2020-11-10 | Jackson | Alabama | 1071 | 2509 | 23 |
716023 | 716023 | 2020-11-10 | Jefferson | Alabama | 1073 | 26232 | 409 |
716024 | 716024 | 2020-11-10 | Lamar | Alabama | 1075 | 565 | 7 |
716025 | 716025 | 2020-11-10 | Lauderdale | Alabama | 1077 | 3011 | 49 |
716026 | 716026 | 2020-11-10 | Lawrence | Alabama | 1079 | 1014 | 35 |
716027 | 716027 | 2020-11-10 | Lee | Alabama | 1081 | 6952 | 65 |
716028 | 716028 | 2020-11-10 | Limestone | Alabama | 1083 | 3414 | 37 |
716029 | 716029 | 2020-11-10 | Lowndes | Alabama | 1085 | 749 | 29 |
716030 | 716030 | 2020-11-10 | Macon | Alabama | 1087 | 618 | 20 |
716031 | 716031 | 2020-11-10 | Madison | Alabama | 1089 | 10524 | 108 |
716032 | 716032 | 2020-11-10 | Marengo | Alabama | 1091 | 1103 | 24 |
716033 | 716033 | 2020-11-10 | Marion | Alabama | 1093 | 1222 | 31 |
716034 | 716034 | 2020-11-10 | Marshall | Alabama | 1095 | 4910 | 53 |
716035 | 716035 | 2020-11-10 | Mobile | Alabama | 1097 | 17998 | 334 |
716036 | 716036 | 2020-11-10 | Monroe | Alabama | 1099 | 701 | 10 |
716037 | 716037 | 2020-11-10 | Montgomery | Alabama | 1101 | 11225 | 221 |
716038 | 716038 | 2020-11-10 | Morgan | Alabama | 1103 | 4974 | 40 |
716039 | 716039 | 2020-11-10 | Perry | Alabama | 1105 | 626 | 6 |
716040 | 716040 | 2020-11-10 | Pickens | Alabama | 1107 | 1017 | 18 |
716041 | 716041 | 2020-11-10 | Pike | Alabama | 1109 | 1437 | 14 |
716042 | 716042 | 2020-11-10 | Randolph | Alabama | 1111 | 896 | 19 |
716043 | 716043 | 2020-11-10 | Russell | Alabama | 1113 | 2028 | 3 |
716044 | 716044 | 2020-11-10 | Shelby | Alabama | 1117 | 8423 | 72 |
716045 | 716045 | 2020-11-10 | St. Clair | Alabama | 1115 | 3537 | 52 |
716046 | 716046 | 2020-11-10 | Sumter | Alabama | 1119 | 510 | 21 |
716047 | 716047 | 2020-11-10 | Talladega | Alabama | 1121 | 2992 | 40 |
716048 | 716048 | 2020-11-10 | Tallapoosa | Alabama | 1123 | 1506 | 87 |
716049 | 716049 | 2020-11-10 | Tuscaloosa | Alabama | 1125 | 11298 | 147 |
716050 | 716050 | 2020-11-10 | Walker | Alabama | 1127 | 3155 | 96 |
716051 | 716051 | 2020-11-10 | Washington | Alabama | 1129 | 828 | 12 |
716052 | 716052 | 2020-11-10 | Wilcox | Alabama | 1131 | 594 | 12 |
716053 | 716053 | 2020-11-10 | Winston | Alabama | 1133 | 1050 | 15 |
716054 | 716054 | 2020-11-10 | Aleutians East Borough | Alaska | 2013 | 18 | 0 |
716055 | 716055 | 2020-11-10 | Aleutians West Census Area | Alaska | 2016 | 103 | 0 |
716056 | 716056 | 2020-11-10 | Anchorage | Alaska | 2020 | 10632 | 55 |
716057 | 716057 | 2020-11-10 | Bethel Census Area | Alaska | 2050 | 781 | 1 |
716058 | 716058 | 2020-11-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 122 | 0 |
716059 | 716059 | 2020-11-10 | Denali Borough | Alaska | 2068 | 36 | 0 |
716060 | 716060 | 2020-11-10 | Dillingham Census Area | Alaska | 2070 | 71 | 0 |
716061 | 716061 | 2020-11-10 | Fairbanks North Star Borough | Alaska | 2090 | 2607 | 16 |
716062 | 716062 | 2020-11-10 | Haines Borough | Alaska | 2100 | 15 | 0 |
716063 | 716063 | 2020-11-10 | Juneau City and Borough | Alaska | 2110 | 660 | 2 |
716064 | 716064 | 2020-11-10 | Kenai Peninsula Borough | Alaska | 2122 | 1440 | 3 |
716065 | 716065 | 2020-11-10 | Ketchikan Gateway Borough | Alaska | 2130 | 150 | 0 |
716066 | 716066 | 2020-11-10 | Kodiak Island Borough | Alaska | 2150 | 145 | 0 |
716067 | 716067 | 2020-11-10 | Kusilvak Census Area | Alaska | 2158 | 348 | 0 |
716068 | 716068 | 2020-11-10 | Matanuska-Susitna Borough | Alaska | 2170 | 2046 | 5 |
716069 | 716069 | 2020-11-10 | Nome Census Area | Alaska | 2180 | 155 | 0 |
716070 | 716070 | 2020-11-10 | North Slope Borough | Alaska | 2185 | 336 | 0 |
716071 | 716071 | 2020-11-10 | Northwest Arctic Borough | Alaska | 2188 | 294 | 0 |
716072 | 716072 | 2020-11-10 | Petersburg Borough | Alaska | 2195 | 19 | 0 |
716073 | 716073 | 2020-11-10 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 39 | 1 |
716074 | 716074 | 2020-11-10 | Sitka City and Borough | Alaska | 2220 | 102 | 0 |
716075 | 716075 | 2020-11-10 | Skagway Municipality | Alaska | 2230 | 7 | 0 |
716076 | 716076 | 2020-11-10 | Southeast Fairbanks Census Area | Alaska | 2240 | 111 | 1 |
716077 | 716077 | 2020-11-10 | Unknown | Alaska | 84 | 0 | |
716078 | 716078 | 2020-11-10 | Valdez-Cordova Census Area | Alaska | 2261 | 204 | 1 |
716079 | 716079 | 2020-11-10 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
716080 | 716080 | 2020-11-10 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 39 | 0 |
716081 | 716081 | 2020-11-10 | Yukon-Koyukuk Census Area | Alaska | 2290 | 132 | 2 |
716082 | 716082 | 2020-11-10 | Apache | Arizona | 4001 | 4217 | 186 |
716083 | 716083 | 2020-11-10 | Cochise | Arizona | 4003 | 2483 | 76 |
716084 | 716084 | 2020-11-10 | Coconino | Arizona | 4005 | 5996 | 152 |
716085 | 716085 | 2020-11-10 | Gila | Arizona | 4007 | 2191 | 76 |
716086 | 716086 | 2020-11-10 | Graham | Arizona | 4009 | 1467 | 31 |
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);