ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23,396
- Georgia 17,529
- Virginia 13,877
- Kentucky 12,052
- Missouri 11,092
- North Carolina 10,708
- Illinois 10,473
- Tennessee 10,329
- Indiana 10,154
- Iowa 9,973
- Ohio 9,617
- Mississippi 9,063
- Minnesota 8,848
- Michigan 8,838
- Kansas 8,701
- Arkansas 8,036
- Florida 7,734
- Oklahoma 7,622
- Wisconsin 7,578
- Pennsylvania 7,484
- Alabama 7,355
- Louisiana 7,288
- Nebraska 6,844
- California 6,784
- New York 6,774
- Colorado 6,664
- Puerto Rico 5,388
- West Virginia 5,344
- South Dakota 5,307
- South Carolina 5,222
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
321893 | 321893 | 2020-07-11 | Autauga | Alabama | 1001 | 684 | 15 |
321894 | 321894 | 2020-07-11 | Baldwin | Alabama | 1003 | 1224 | 12 |
321895 | 321895 | 2020-07-11 | Barbour | Alabama | 1005 | 398 | 2 |
321896 | 321896 | 2020-07-11 | Bibb | Alabama | 1007 | 224 | 1 |
321897 | 321897 | 2020-07-11 | Blount | Alabama | 1009 | 307 | 1 |
321898 | 321898 | 2020-07-11 | Bullock | Alabama | 1011 | 382 | 11 |
321899 | 321899 | 2020-07-11 | Butler | Alabama | 1013 | 654 | 29 |
321900 | 321900 | 2020-07-11 | Calhoun | Alabama | 1015 | 500 | 5 |
321901 | 321901 | 2020-07-11 | Chambers | Alabama | 1017 | 690 | 27 |
321902 | 321902 | 2020-07-11 | Cherokee | Alabama | 1019 | 128 | 7 |
321903 | 321903 | 2020-07-11 | Chilton | Alabama | 1021 | 331 | 3 |
321904 | 321904 | 2020-07-11 | Choctaw | Alabama | 1023 | 213 | 12 |
321905 | 321905 | 2020-07-11 | Clarke | Alabama | 1025 | 313 | 6 |
321906 | 321906 | 2020-07-11 | Clay | Alabama | 1027 | 85 | 2 |
321907 | 321907 | 2020-07-11 | Cleburne | Alabama | 1029 | 42 | 1 |
321908 | 321908 | 2020-07-11 | Coffee | Alabama | 1031 | 429 | 4 |
321909 | 321909 | 2020-07-11 | Colbert | Alabama | 1033 | 505 | 6 |
321910 | 321910 | 2020-07-11 | Conecuh | Alabama | 1035 | 232 | 8 |
321911 | 321911 | 2020-07-11 | Coosa | Alabama | 1037 | 65 | 1 |
321912 | 321912 | 2020-07-11 | Covington | Alabama | 1039 | 437 | 13 |
321913 | 321913 | 2020-07-11 | Crenshaw | Alabama | 1041 | 131 | 3 |
321914 | 321914 | 2020-07-11 | Cullman | Alabama | 1043 | 581 | 6 |
321915 | 321915 | 2020-07-11 | Dale | Alabama | 1045 | 394 | 1 |
321916 | 321916 | 2020-07-11 | Dallas | Alabama | 1047 | 1009 | 9 |
321917 | 321917 | 2020-07-11 | DeKalb | Alabama | 1049 | 951 | 7 |
321918 | 321918 | 2020-07-11 | Elmore | Alabama | 1051 | 1047 | 20 |
321919 | 321919 | 2020-07-11 | Escambia | Alabama | 1053 | 480 | 8 |
321920 | 321920 | 2020-07-11 | Etowah | Alabama | 1055 | 964 | 14 |
321921 | 321921 | 2020-07-11 | Fayette | Alabama | 1057 | 85 | 1 |
321922 | 321922 | 2020-07-11 | Franklin | Alabama | 1059 | 937 | 16 |
321923 | 321923 | 2020-07-11 | Geneva | Alabama | 1061 | 96 | 0 |
321924 | 321924 | 2020-07-11 | Greene | Alabama | 1063 | 195 | 9 |
321925 | 321925 | 2020-07-11 | Hale | Alabama | 1065 | 353 | 23 |
321926 | 321926 | 2020-07-11 | Henry | Alabama | 1067 | 154 | 4 |
321927 | 321927 | 2020-07-11 | Houston | Alabama | 1069 | 600 | 9 |
321928 | 321928 | 2020-07-11 | Jackson | Alabama | 1071 | 422 | 3 |
321929 | 321929 | 2020-07-11 | Jefferson | Alabama | 1073 | 6504 | 172 |
321930 | 321930 | 2020-07-11 | Lamar | Alabama | 1075 | 88 | 1 |
321931 | 321931 | 2020-07-11 | Lauderdale | Alabama | 1077 | 571 | 6 |
321932 | 321932 | 2020-07-11 | Lawrence | Alabama | 1079 | 128 | 0 |
321933 | 321933 | 2020-07-11 | Lee | Alabama | 1081 | 1611 | 38 |
321934 | 321934 | 2020-07-11 | Limestone | Alabama | 1083 | 628 | 4 |
321935 | 321935 | 2020-07-11 | Lowndes | Alabama | 1085 | 485 | 24 |
321936 | 321936 | 2020-07-11 | Macon | Alabama | 1087 | 221 | 9 |
321937 | 321937 | 2020-07-11 | Madison | Alabama | 1089 | 2150 | 10 |
321938 | 321938 | 2020-07-11 | Marengo | Alabama | 1091 | 354 | 11 |
321939 | 321939 | 2020-07-11 | Marion | Alabama | 1093 | 279 | 14 |
321940 | 321940 | 2020-07-11 | Marshall | Alabama | 1095 | 1942 | 11 |
321941 | 321941 | 2020-07-11 | Mobile | Alabama | 1097 | 4778 | 144 |
321942 | 321942 | 2020-07-11 | Monroe | Alabama | 1099 | 258 | 4 |
321943 | 321943 | 2020-07-11 | Montgomery | Alabama | 1101 | 4478 | 114 |
321944 | 321944 | 2020-07-11 | Morgan | Alabama | 1103 | 1283 | 5 |
321945 | 321945 | 2020-07-11 | Perry | Alabama | 1105 | 236 | 2 |
321946 | 321946 | 2020-07-11 | Pickens | Alabama | 1107 | 272 | 6 |
321947 | 321947 | 2020-07-11 | Pike | Alabama | 1109 | 478 | 5 |
321948 | 321948 | 2020-07-11 | Randolph | Alabama | 1111 | 260 | 9 |
321949 | 321949 | 2020-07-11 | Russell | Alabama | 1113 | 683 | 0 |
321950 | 321950 | 2020-07-11 | Shelby | Alabama | 1117 | 1674 | 25 |
321951 | 321951 | 2020-07-11 | St. Clair | Alabama | 1115 | 528 | 3 |
321952 | 321952 | 2020-07-11 | Sumter | Alabama | 1119 | 292 | 13 |
321953 | 321953 | 2020-07-11 | Talladega | Alabama | 1121 | 406 | 8 |
321954 | 321954 | 2020-07-11 | Tallapoosa | Alabama | 1123 | 637 | 70 |
321955 | 321955 | 2020-07-11 | Tuscaloosa | Alabama | 1125 | 2654 | 55 |
321956 | 321956 | 2020-07-11 | Walker | Alabama | 1127 | 1077 | 31 |
321957 | 321957 | 2020-07-11 | Washington | Alabama | 1129 | 144 | 8 |
321958 | 321958 | 2020-07-11 | Wilcox | Alabama | 1131 | 306 | 8 |
321959 | 321959 | 2020-07-11 | Winston | Alabama | 1133 | 300 | 5 |
321960 | 321960 | 2020-07-11 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
321961 | 321961 | 2020-07-11 | Aleutians West Census Area | Alaska | 2016 | 6 | 0 |
321962 | 321962 | 2020-07-11 | Anchorage | Alaska | 2020 | 733 | 8 |
321963 | 321963 | 2020-07-11 | Bethel Census Area | Alaska | 2050 | 15 | 0 |
321964 | 321964 | 2020-07-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 56 | 0 |
321965 | 321965 | 2020-07-11 | Denali Borough | Alaska | 2068 | 1 | 0 |
321966 | 321966 | 2020-07-11 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
321967 | 321967 | 2020-07-11 | Fairbanks North Star Borough | Alaska | 2090 | 243 | 2 |
321968 | 321968 | 2020-07-11 | Haines Borough | Alaska | 2100 | 6 | 0 |
321969 | 321969 | 2020-07-11 | Juneau City and Borough | Alaska | 2110 | 54 | 2 |
321970 | 321970 | 2020-07-11 | Kenai Peninsula Borough | Alaska | 2122 | 211 | 1 |
321971 | 321971 | 2020-07-11 | Ketchikan Gateway Borough | Alaska | 2130 | 32 | 0 |
321972 | 321972 | 2020-07-11 | Kodiak Island Borough | Alaska | 2150 | 10 | 0 |
321973 | 321973 | 2020-07-11 | Kusilvak Census Area | Alaska | 2158 | 2 | 0 |
321974 | 321974 | 2020-07-11 | Matanuska-Susitna Borough | Alaska | 2170 | 137 | 2 |
321975 | 321975 | 2020-07-11 | Nome Census Area | Alaska | 2180 | 15 | 0 |
321976 | 321976 | 2020-07-11 | North Slope Borough | Alaska | 2185 | 4 | 0 |
321977 | 321977 | 2020-07-11 | Northwest Arctic Borough | Alaska | 2188 | 6 | 0 |
321978 | 321978 | 2020-07-11 | Petersburg Borough | Alaska | 2195 | 8 | 0 |
321979 | 321979 | 2020-07-11 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
321980 | 321980 | 2020-07-11 | Sitka City and Borough | Alaska | 2220 | 18 | 0 |
321981 | 321981 | 2020-07-11 | Southeast Fairbanks Census Area | Alaska | 2240 | 23 | 0 |
321982 | 321982 | 2020-07-11 | Unknown | Alaska | 8 | 0 | |
321983 | 321983 | 2020-07-11 | Valdez-Cordova Census Area | Alaska | 2261 | 27 | 0 |
321984 | 321984 | 2020-07-11 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
321985 | 321985 | 2020-07-11 | Yukon-Koyukuk Census Area | Alaska | 2290 | 7 | 0 |
321986 | 321986 | 2020-07-11 | Apache | Arizona | 4001 | 2551 | 101 |
321987 | 321987 | 2020-07-11 | Cochise | Arizona | 4003 | 1020 | 22 |
321988 | 321988 | 2020-07-11 | Coconino | Arizona | 4005 | 2427 | 98 |
321989 | 321989 | 2020-07-11 | Gila | Arizona | 4007 | 439 | 12 |
321990 | 321990 | 2020-07-11 | Graham | Arizona | 4009 | 201 | 3 |
321991 | 321991 | 2020-07-11 | Greenlee | Arizona | 4011 | 32 | 1 |
321992 | 321992 | 2020-07-11 | La Paz | Arizona | 4012 | 398 | 7 |
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);