ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,228 rows where date = "2020-08-13" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 251
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Illinois 103
- Kansas 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Minnesota 88
- Nebraska 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 77
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 63
- California 58
- New York 58
- West Virginia 55
- Montana 54
- …
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 14
- 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 |
---|---|---|---|---|---|---|---|
427786 | 427786 | 2020-08-13 | Autauga | Alabama | 1001 | 1250 | 23 |
427787 | 427787 | 2020-08-13 | Baldwin | Alabama | 1003 | 3813 | 32 |
427788 | 427788 | 2020-08-13 | Barbour | Alabama | 1005 | 651 | 6 |
427789 | 427789 | 2020-08-13 | Bibb | Alabama | 1007 | 469 | 6 |
427790 | 427790 | 2020-08-13 | Blount | Alabama | 1009 | 977 | 5 |
427791 | 427791 | 2020-08-13 | Bullock | Alabama | 1011 | 501 | 12 |
427792 | 427792 | 2020-08-13 | Butler | Alabama | 1013 | 790 | 37 |
427793 | 427793 | 2020-08-13 | Calhoun | Alabama | 1015 | 1959 | 20 |
427794 | 427794 | 2020-08-13 | Chambers | Alabama | 1017 | 919 | 38 |
427795 | 427795 | 2020-08-13 | Cherokee | Alabama | 1019 | 320 | 9 |
427796 | 427796 | 2020-08-13 | Chilton | Alabama | 1021 | 883 | 12 |
427797 | 427797 | 2020-08-13 | Choctaw | Alabama | 1023 | 297 | 12 |
427798 | 427798 | 2020-08-13 | Clarke | Alabama | 1025 | 863 | 10 |
427799 | 427799 | 2020-08-13 | Clay | Alabama | 1027 | 287 | 5 |
427800 | 427800 | 2020-08-13 | Cleburne | Alabama | 1029 | 134 | 1 |
427801 | 427801 | 2020-08-13 | Coffee | Alabama | 1031 | 832 | 6 |
427802 | 427802 | 2020-08-13 | Colbert | Alabama | 1033 | 1259 | 18 |
427803 | 427803 | 2020-08-13 | Conecuh | Alabama | 1035 | 424 | 10 |
427804 | 427804 | 2020-08-13 | Coosa | Alabama | 1037 | 122 | 3 |
427805 | 427805 | 2020-08-13 | Covington | Alabama | 1039 | 908 | 23 |
427806 | 427806 | 2020-08-13 | Crenshaw | Alabama | 1041 | 365 | 9 |
427807 | 427807 | 2020-08-13 | Cullman | Alabama | 1043 | 1340 | 12 |
427808 | 427808 | 2020-08-13 | Dale | Alabama | 1045 | 882 | 29 |
427809 | 427809 | 2020-08-13 | Dallas | Alabama | 1047 | 1456 | 25 |
427810 | 427810 | 2020-08-13 | DeKalb | Alabama | 1049 | 1926 | 17 |
427811 | 427811 | 2020-08-13 | Elmore | Alabama | 1051 | 1865 | 41 |
427812 | 427812 | 2020-08-13 | Escambia | Alabama | 1053 | 1226 | 17 |
427813 | 427813 | 2020-08-13 | Etowah | Alabama | 1055 | 2296 | 35 |
427814 | 427814 | 2020-08-13 | Fayette | Alabama | 1057 | 244 | 5 |
427815 | 427815 | 2020-08-13 | Franklin | Alabama | 1059 | 1327 | 22 |
427816 | 427816 | 2020-08-13 | Geneva | Alabama | 1061 | 289 | 3 |
427817 | 427817 | 2020-08-13 | Greene | Alabama | 1063 | 260 | 11 |
427818 | 427818 | 2020-08-13 | Hale | Alabama | 1065 | 508 | 26 |
427819 | 427819 | 2020-08-13 | Henry | Alabama | 1067 | 284 | 4 |
427820 | 427820 | 2020-08-13 | Houston | Alabama | 1069 | 1517 | 15 |
427821 | 427821 | 2020-08-13 | Jackson | Alabama | 1071 | 1111 | 6 |
427822 | 427822 | 2020-08-13 | Jefferson | Alabama | 1073 | 13872 | 264 |
427823 | 427823 | 2020-08-13 | Lamar | Alabama | 1075 | 245 | 2 |
427824 | 427824 | 2020-08-13 | Lauderdale | Alabama | 1077 | 1227 | 20 |
427825 | 427825 | 2020-08-13 | Lawrence | Alabama | 1079 | 370 | 3 |
427826 | 427826 | 2020-08-13 | Lee | Alabama | 1081 | 2955 | 51 |
427827 | 427827 | 2020-08-13 | Limestone | Alabama | 1083 | 1421 | 14 |
427828 | 427828 | 2020-08-13 | Lowndes | Alabama | 1085 | 588 | 26 |
427829 | 427829 | 2020-08-13 | Macon | Alabama | 1087 | 360 | 14 |
427830 | 427830 | 2020-08-13 | Madison | Alabama | 1089 | 5679 | 40 |
427831 | 427831 | 2020-08-13 | Marengo | Alabama | 1091 | 583 | 18 |
427832 | 427832 | 2020-08-13 | Marion | Alabama | 1093 | 631 | 26 |
427833 | 427833 | 2020-08-13 | Marshall | Alabama | 1095 | 3299 | 39 |
427834 | 427834 | 2020-08-13 | Mobile | Alabama | 1097 | 10841 | 226 |
427835 | 427835 | 2020-08-13 | Monroe | Alabama | 1099 | 489 | 7 |
427836 | 427836 | 2020-08-13 | Montgomery | Alabama | 1101 | 7145 | 156 |
427837 | 427837 | 2020-08-13 | Morgan | Alabama | 1103 | 2486 | 22 |
427838 | 427838 | 2020-08-13 | Perry | Alabama | 1105 | 479 | 4 |
427839 | 427839 | 2020-08-13 | Pickens | Alabama | 1107 | 427 | 11 |
427840 | 427840 | 2020-08-13 | Pike | Alabama | 1109 | 773 | 8 |
427841 | 427841 | 2020-08-13 | Randolph | Alabama | 1111 | 418 | 12 |
427842 | 427842 | 2020-08-13 | Russell | Alabama | 1113 | 1424 | 2 |
427843 | 427843 | 2020-08-13 | Shelby | Alabama | 1117 | 3613 | 39 |
427844 | 427844 | 2020-08-13 | St. Clair | Alabama | 1115 | 1493 | 22 |
427845 | 427845 | 2020-08-13 | Sumter | Alabama | 1119 | 377 | 19 |
427846 | 427846 | 2020-08-13 | Talladega | Alabama | 1121 | 1359 | 15 |
427847 | 427847 | 2020-08-13 | Tallapoosa | Alabama | 1123 | 958 | 80 |
427848 | 427848 | 2020-08-13 | Tuscaloosa | Alabama | 1125 | 4487 | 82 |
427849 | 427849 | 2020-08-13 | Walker | Alabama | 1127 | 1603 | 68 |
427850 | 427850 | 2020-08-13 | Washington | Alabama | 1129 | 464 | 14 |
427851 | 427851 | 2020-08-13 | Wilcox | Alabama | 1131 | 464 | 10 |
427852 | 427852 | 2020-08-13 | Winston | Alabama | 1133 | 473 | 11 |
427853 | 427853 | 2020-08-13 | Aleutians East Borough | Alaska | 2013 | 4 | 0 |
427854 | 427854 | 2020-08-13 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
427855 | 427855 | 2020-08-13 | Anchorage | Alaska | 2020 | 2425 | 14 |
427856 | 427856 | 2020-08-13 | Bethel Census Area | Alaska | 2050 | 25 | 0 |
427857 | 427857 | 2020-08-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
427858 | 427858 | 2020-08-13 | Denali Borough | Alaska | 2068 | 4 | 0 |
427859 | 427859 | 2020-08-13 | Dillingham Census Area | Alaska | 2070 | 24 | 0 |
427860 | 427860 | 2020-08-13 | Fairbanks North Star Borough | Alaska | 2090 | 503 | 6 |
427861 | 427861 | 2020-08-13 | Haines Borough | Alaska | 2100 | 9 | 0 |
427862 | 427862 | 2020-08-13 | Juneau City and Borough | Alaska | 2110 | 195 | 1 |
427863 | 427863 | 2020-08-13 | Kenai Peninsula Borough | Alaska | 2122 | 502 | 1 |
427864 | 427864 | 2020-08-13 | Ketchikan Gateway Borough | Alaska | 2130 | 54 | 0 |
427865 | 427865 | 2020-08-13 | Kodiak Island Borough | Alaska | 2150 | 49 | 0 |
427866 | 427866 | 2020-08-13 | Kusilvak Census Area | Alaska | 2158 | 7 | 0 |
427867 | 427867 | 2020-08-13 | Matanuska-Susitna Borough | Alaska | 2170 | 376 | 2 |
427868 | 427868 | 2020-08-13 | Nome Census Area | Alaska | 2180 | 27 | 0 |
427869 | 427869 | 2020-08-13 | North Slope Borough | Alaska | 2185 | 23 | 0 |
427870 | 427870 | 2020-08-13 | Northwest Arctic Borough | Alaska | 2188 | 43 | 0 |
427871 | 427871 | 2020-08-13 | Petersburg Borough | Alaska | 2195 | 10 | 0 |
427872 | 427872 | 2020-08-13 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 12 | 0 |
427873 | 427873 | 2020-08-13 | Sitka City and Borough | Alaska | 2220 | 38 | 0 |
427874 | 427874 | 2020-08-13 | Southeast Fairbanks Census Area | Alaska | 2240 | 29 | 0 |
427875 | 427875 | 2020-08-13 | Unknown | Alaska | 37 | 0 | |
427876 | 427876 | 2020-08-13 | Valdez-Cordova Census Area | Alaska | 2261 | 107 | 0 |
427877 | 427877 | 2020-08-13 | Wrangell City and Borough | Alaska | 2275 | 14 | 0 |
427878 | 427878 | 2020-08-13 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 11 | 0 |
427879 | 427879 | 2020-08-13 | Yukon-Koyukuk Census Area | Alaska | 2290 | 56 | 1 |
427880 | 427880 | 2020-08-13 | Apache | Arizona | 4001 | 3218 | 140 |
427881 | 427881 | 2020-08-13 | Cochise | Arizona | 4003 | 1747 | 57 |
427882 | 427882 | 2020-08-13 | Coconino | Arizona | 4005 | 3146 | 119 |
427883 | 427883 | 2020-08-13 | Gila | Arizona | 4007 | 978 | 41 |
427884 | 427884 | 2020-08-13 | Graham | Arizona | 4009 | 574 | 19 |
427885 | 427885 | 2020-08-13 | Greenlee | Arizona | 4011 | 57 | 2 |
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);