ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where cases = 4007 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Georgia 12
- Texas 12
- Virginia 11
- Oklahoma 10
- Alaska 9
- Missouri 9
- Indiana 8
- Illinois 7
- Tennessee 6
- Alabama 5
- Kentucky 5
- Minnesota 5
- Mississippi 5
- Connecticut 3
- Ohio 3
- Puerto Rico 3
- Louisiana 2
- Michigan 2
- Oregon 2
- West Virginia 2
- Wisconsin 2
- Arkansas 1
- Colorado 1
- Florida 1
- Maine 1
- New Mexico 1
- North Carolina 1
- Pennsylvania 1
- South Dakota 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422112 | 2422112 | 2022-04-19 | Warren | Illinois | 17187 | 4007 | 87 |
2398706 | 2398706 | 2022-04-12 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2399293 | 2399293 | 2022-04-12 | Mercer | Illinois | 17131 | 4007 | 47 |
2395451 | 2395451 | 2022-04-11 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2392195 | 2392195 | 2022-04-10 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2388939 | 2388939 | 2022-04-09 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2385684 | 2385684 | 2022-04-08 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2382429 | 2382429 | 2022-04-07 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2379174 | 2379174 | 2022-04-06 | Kusilvak Census Area | Alaska | 2158 | 4007 | 12 |
2317050 | 2317050 | 2022-03-17 | Nottoway | Virginia | 51135 | 4007 | 87 |
2269517 | 2269517 | 2022-03-03 | Caldwell | Kentucky | 21033 | 4007 | 58 |
2231835 | 2231835 | 2022-02-19 | Catano | Puerto Rico | 72033 | 4007 | |
2222864 | 2222864 | 2022-02-16 | Monroe | West Virginia | 54063 | 4007 | 37 |
2217268 | 2217268 | 2022-02-15 | Vermillion | Indiana | 18165 | 4007 | 70 |
2129131 | 2129131 | 2022-01-19 | Meriwether | Georgia | 13199 | 4007 | 123 |
2121599 | 2121599 | 2022-01-16 | Gonzales | Texas | 48177 | 4007 | 91 |
2106412 | 2106412 | 2022-01-12 | Union | Georgia | 13291 | 4007 | 133 |
2103054 | 2103054 | 2022-01-11 | Cook | Georgia | 13075 | 4007 | 65 |
2098836 | 2098836 | 2022-01-09 | Gillespie | Texas | 48171 | 4007 | 84 |
2092540 | 2092540 | 2022-01-07 | Orleans | Vermont | 50019 | 4007 | 31 |
2053631 | 2053631 | 2021-12-26 | Page | Virginia | 51139 | 4007 | 91 |
2050381 | 2050381 | 2021-12-25 | Page | Virginia | 51139 | 4007 | 91 |
2047131 | 2047131 | 2021-12-24 | Page | Virginia | 51139 | 4007 | 91 |
1996435 | 1996435 | 2021-12-09 | McCreary | Kentucky | 21147 | 4007 | 64 |
1996514 | 1996514 | 2021-12-09 | Pointe Coupee | Louisiana | 22077 | 4007 | 85 |
1988317 | 1988317 | 2021-12-06 | Gray | Texas | 48179 | 4007 | 85 |
1968321 | 1968321 | 2021-11-30 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1965070 | 1965070 | 2021-11-29 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1961818 | 1961818 | 2021-11-28 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1961982 | 1961982 | 2021-11-28 | Mayaguez | Puerto Rico | 72097 | 4007 | |
1958567 | 1958567 | 2021-11-27 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1958731 | 1958731 | 2021-11-27 | Mayaguez | Puerto Rico | 72097 | 4007 | |
1955316 | 1955316 | 2021-11-26 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1952065 | 1952065 | 2021-11-25 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1948814 | 1948814 | 2021-11-24 | Seminole | Oklahoma | 40133 | 4007 | 105 |
1917420 | 1917420 | 2021-11-15 | Juneau City and Borough | Alaska | 2110 | 4007 | 11 |
1918420 | 1918420 | 2021-11-15 | Marion | Kentucky | 21155 | 4007 | 49 |
1915704 | 1915704 | 2021-11-14 | Washington | Missouri | 29221 | 4007 | 70 |
1892950 | 1892950 | 2021-11-07 | Stone | Missouri | 29209 | 4007 | 86 |
1781917 | 1781917 | 2021-10-04 | Grant | Kentucky | 21081 | 4007 | 33 |
1765119 | 1765119 | 2021-09-29 | Monroe | Georgia | 13207 | 4007 | 137 |
1765359 | 1765359 | 2021-09-29 | Greene | Indiana | 18055 | 4007 | 97 |
1766056 | 1766056 | 2021-09-29 | Coahoma | Mississippi | 28027 | 4007 | 101 |
1761870 | 1761870 | 2021-09-28 | Monroe | Georgia | 13207 | 4007 | 135 |
1763986 | 1763986 | 2021-09-28 | Smith | Tennessee | 47159 | 4007 | 44 |
1757008 | 1757008 | 2021-09-26 | Pike | Ohio | 39131 | 4007 | 45 |
1710073 | 1710073 | 2021-09-12 | Perry | Illinois | 17145 | 4007 | 78 |
1706826 | 1706826 | 2021-09-11 | Perry | Illinois | 17145 | 4007 | 78 |
1703578 | 1703578 | 2021-09-10 | Perry | Illinois | 17145 | 4007 | 78 |
1704099 | 1704099 | 2021-09-10 | Oxford | Maine | 23017 | 4007 | 71 |
1685716 | 1685716 | 2021-09-04 | McKean | Pennsylvania | 42083 | 4007 | 76 |
1676876 | 1676876 | 2021-09-01 | Trempealeau | Wisconsin | 55121 | 4007 | 49 |
1633995 | 1633995 | 2021-08-19 | Hardeman | Tennessee | 47069 | 4007 | 66 |
1634000 | 1634000 | 2021-08-19 | Henry | Tennessee | 47079 | 4007 | 76 |
1622194 | 1622194 | 2021-08-16 | Pickens | Georgia | 13227 | 4007 | 81 |
1623526 | 1623526 | 2021-08-16 | Rio Arriba | New Mexico | 35039 | 4007 | 82 |
1586703 | 1586703 | 2021-08-05 | Knox | Indiana | 18083 | 4007 | 91 |
1589017 | 1589017 | 2021-08-05 | York | Virginia | 51199 | 4007 | 59 |
1582716 | 1582716 | 2021-08-04 | Chambers | Alabama | 1017 | 4007 | 125 |
1563622 | 1563622 | 2021-07-29 | Bryan | Georgia | 13029 | 4007 | 42 |
1551627 | 1551627 | 2021-07-25 | Steele | Minnesota | 27147 | 4007 | 19 |
1548380 | 1548380 | 2021-07-24 | Steele | Minnesota | 27147 | 4007 | 19 |
1545133 | 1545133 | 2021-07-23 | Steele | Minnesota | 27147 | 4007 | 19 |
1437384 | 1437384 | 2021-06-20 | Steuben | Indiana | 18151 | 4007 | 61 |
1434137 | 1434137 | 2021-06-19 | Steuben | Indiana | 18151 | 4007 | 61 |
1418585 | 1418585 | 2021-06-14 | Lincoln | Mississippi | 28085 | 4007 | 111 |
1415340 | 1415340 | 2021-06-13 | Lincoln | Mississippi | 28085 | 4007 | 111 |
1412094 | 1412094 | 2021-06-12 | Lincoln | Mississippi | 28085 | 4007 | 111 |
1408849 | 1408849 | 2021-06-11 | Lincoln | Mississippi | 28085 | 4007 | 111 |
1389986 | 1389986 | 2021-06-05 | Brown | Ohio | 39015 | 4007 | 61 |
1365612 | 1365612 | 2021-05-29 | Camden | Georgia | 13039 | 4007 | 37 |
1362239 | 1362239 | 2021-05-28 | Logan | Colorado | 8075 | 4007 | 68 |
1347801 | 1347801 | 2021-05-23 | Crawford | Ohio | 39033 | 4007 | 110 |
1287005 | 1287005 | 2021-05-04 | Franklin | Virginia | 51067 | 4007 | 76 |
1273294 | 1273294 | 2021-04-30 | Klamath | Oregon | 41035 | 4007 | 59 |
1273998 | 1273998 | 2021-04-30 | Charlottesville city | Virginia | 51540 | 4007 | 55 |
1234949 | 1234949 | 2021-04-18 | Wharton | Texas | 48481 | 4007 | 113 |
1201869 | 1201869 | 2021-04-08 | Yamhill | Oregon | 41071 | 4007 | 74 |
1202727 | 1202727 | 2021-04-08 | Marion | West Virginia | 54049 | 4007 | 48 |
1151225 | 1151225 | 2021-03-24 | DeSoto | Florida | 12027 | 4007 | 80 |
1153474 | 1153474 | 2021-03-24 | Marshall | Tennessee | 47117 | 4007 | 57 |
1141160 | 1141160 | 2021-03-21 | Chilton | Alabama | 1021 | 4007 | 107 |
1142731 | 1142731 | 2021-03-21 | Platte | Missouri | 29165 | 4007 | 44 |
1138582 | 1138582 | 2021-03-20 | Randolph | Illinois | 17157 | 4007 | 87 |
1119138 | 1119138 | 2021-03-14 | Clinton | Indiana | 18023 | 4007 | 58 |
1111950 | 1111950 | 2021-03-12 | Covington | Alabama | 1039 | 4007 | 108 |
1114146 | 1114146 | 2021-03-12 | Sequoyah | Oklahoma | 40135 | 4007 | 32 |
1102270 | 1102270 | 2021-03-09 | Kenai Peninsula Borough | Alaska | 2122 | 4007 | 19 |
1104939 | 1104939 | 2021-03-09 | Jim Wells | Texas | 48249 | 4007 | 90 |
1092482 | 1092482 | 2021-03-06 | Franklin | Alabama | 1059 | 4007 | 79 |
1095417 | 1095417 | 2021-03-06 | Fauquier | Virginia | 51061 | 4007 | 56 |
1085189 | 1085189 | 2021-03-03 | Codington | South Dakota | 46029 | 4007 | 77 |
1080203 | 1080203 | 2021-03-02 | Harrison | Indiana | 18061 | 4007 | 66 |
1081637 | 1081637 | 2021-03-02 | Custer | Oklahoma | 40039 | 4007 | 72 |
1064618 | 1064618 | 2021-02-25 | Mower | Minnesota | 27099 | 4007 | 31 |
1049967 | 1049967 | 2021-02-20 | Culpeper | Virginia | 51047 | 4007 | 42 |
1041702 | 1041702 | 2021-02-18 | Washington | Louisiana | 22117 | 4007 | 117 |
989117 | 989117 | 2021-02-02 | Thomas | Georgia | 13275 | 4007 | 100 |
983510 | 983510 | 2021-01-31 | Winona | Minnesota | 27169 | 4007 | 48 |
974569 | 974569 | 2021-01-28 | Pittsburg | Oklahoma | 40121 | 4007 | 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);