ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 3596 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 9
- Virginia 8
- Wisconsin 8
- Missouri 7
- West Virginia 7
- Alabama 6
- Colorado 6
- Kentucky 6
- Ohio 6
- Tennessee 6
- Texas 6
- Indiana 5
- Louisiana 5
- Minnesota 5
- Mississippi 5
- Oregon 4
- Illinois 3
- New York 3
- Oklahoma 3
- Pennsylvania 3
- Kansas 2
- New Mexico 2
- Puerto Rico 2
- Arizona 1
- Arkansas 1
- California 1
- Florida 1
- Nebraska 1
- South Carolina 1
- South Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500975 | 2500975 | 2022-05-13 | Sibley | Minnesota | 27143 | 3596 | 24 |
2493329 | 2493329 | 2022-05-11 | Grand | Colorado | 8049 | 3596 | 28 |
2425806 | 2425806 | 2022-04-20 | Caldwell | Louisiana | 22021 | 3596 | 55 |
2422550 | 2422550 | 2022-04-19 | Caldwell | Louisiana | 22021 | 3596 | 55 |
2419294 | 2419294 | 2022-04-18 | Caldwell | Louisiana | 22021 | 3596 | 55 |
2415185 | 2415185 | 2022-04-17 | Las Animas | Colorado | 8071 | 3596 | 40 |
2411929 | 2411929 | 2022-04-16 | Las Animas | Colorado | 8071 | 3596 | 40 |
2408673 | 2408673 | 2022-04-15 | Las Animas | Colorado | 8071 | 3596 | 40 |
2336573 | 2336573 | 2022-03-23 | Patrick | Virginia | 51141 | 3596 | 91 |
2280517 | 2280517 | 2022-03-06 | Tillamook | Oregon | 41057 | 3596 | 57 |
2277264 | 2277264 | 2022-03-05 | Tillamook | Oregon | 41057 | 3596 | 57 |
2274011 | 2274011 | 2022-03-04 | Tillamook | Oregon | 41057 | 3596 | 57 |
2274144 | 2274144 | 2022-03-04 | Quebradillas | Puerto Rico | 72115 | 3596 | |
2258681 | 2258681 | 2022-02-27 | Lafayette | Wisconsin | 55065 | 3596 | 22 |
2255430 | 2255430 | 2022-02-26 | Lafayette | Wisconsin | 55065 | 3596 | 22 |
2252179 | 2252179 | 2022-02-25 | Lafayette | Wisconsin | 55065 | 3596 | 22 |
2246505 | 2246505 | 2022-02-24 | Parke | Indiana | 18121 | 3596 | 48 |
2222836 | 2222836 | 2022-02-16 | Braxton | West Virginia | 54007 | 3596 | 39 |
2216990 | 2216990 | 2022-02-15 | Rabun | Georgia | 13241 | 3596 | 89 |
2214832 | 2214832 | 2022-02-14 | Ste. Genevieve | Missouri | 29186 | 3596 | 37 |
2216225 | 2216225 | 2022-02-14 | King William | Virginia | 51101 | 3596 | 30 |
2193403 | 2193403 | 2022-02-07 | Buckingham | Virginia | 51029 | 3596 | 45 |
2190317 | 2190317 | 2022-02-06 | Grant | West Virginia | 54023 | 3596 | 51 |
2178143 | 2178143 | 2022-02-03 | Wabash | Illinois | 17185 | 3596 | 23 |
2174890 | 2174890 | 2022-02-02 | Wabash | Illinois | 17185 | 3596 | 23 |
2175213 | 2175213 | 2022-02-02 | Caldwell | Kentucky | 21033 | 3596 | 57 |
2176895 | 2176895 | 2022-02-02 | Falls | Texas | 48145 | 3596 | 56 |
2142727 | 2142727 | 2022-01-23 | Lewis | Kentucky | 21135 | 3596 | 71 |
2139472 | 2139472 | 2022-01-22 | Lewis | Kentucky | 21135 | 3596 | 71 |
2136216 | 2136216 | 2022-01-21 | Lewis | Kentucky | 21135 | 3596 | 71 |
2129742 | 2129742 | 2022-01-19 | Powell | Kentucky | 21197 | 3596 | 30 |
2095524 | 2095524 | 2022-01-08 | Burleson | Texas | 48051 | 3596 | 61 |
2017392 | 2017392 | 2021-12-15 | Bledsoe | Tennessee | 47007 | 3596 | 26 |
2013908 | 2013908 | 2021-12-14 | Juniata | Pennsylvania | 42067 | 3596 | 137 |
1986958 | 1986958 | 2021-12-06 | Hubbard | Minnesota | 27057 | 3596 | 49 |
1965872 | 1965872 | 2021-11-29 | Page | Virginia | 51139 | 3596 | 88 |
1960063 | 1960063 | 2021-11-28 | Hart | Georgia | 13147 | 3596 | 73 |
1962714 | 1962714 | 2021-11-28 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1956812 | 1956812 | 2021-11-27 | Hart | Georgia | 13147 | 3596 | 73 |
1959463 | 1959463 | 2021-11-27 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1953561 | 1953561 | 2021-11-26 | Hart | Georgia | 13147 | 3596 | 73 |
1956212 | 1956212 | 2021-11-26 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1950310 | 1950310 | 2021-11-25 | Hart | Georgia | 13147 | 3596 | 73 |
1952961 | 1952961 | 2021-11-25 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1947059 | 1947059 | 2021-11-24 | Hart | Georgia | 13147 | 3596 | 73 |
1949710 | 1949710 | 2021-11-24 | Hampshire | West Virginia | 54027 | 3596 | 50 |
1906978 | 1906978 | 2021-11-11 | Austin | Texas | 48015 | 3596 | 56 |
1862105 | 1862105 | 2021-10-29 | Barbour | Alabama | 1005 | 3596 | 76 |
1858856 | 1858856 | 2021-10-28 | Barbour | Alabama | 1005 | 3596 | 76 |
1840882 | 1840882 | 2021-10-22 | Crawford | Missouri | 29055 | 3596 | 57 |
1837594 | 1837594 | 2021-10-21 | Tishomingo | Mississippi | 28141 | 3596 | 92 |
1830045 | 1830045 | 2021-10-19 | Dodge | Georgia | 13091 | 3596 | 123 |
1815609 | 1815609 | 2021-10-14 | Jefferson | Oregon | 41031 | 3596 | 50 |
1767603 | 1767603 | 2021-09-29 | Gloucester | Virginia | 51073 | 3596 | 60 |
1689842 | 1689842 | 2021-09-05 | Juneau | Wisconsin | 55057 | 3596 | 31 |
1686592 | 1686592 | 2021-09-04 | Juneau | Wisconsin | 55057 | 3596 | 31 |
1683342 | 1683342 | 2021-09-03 | Juneau | Wisconsin | 55057 | 3596 | 31 |
1665374 | 1665374 | 2021-08-29 | Leake | Mississippi | 28079 | 3596 | 80 |
1662126 | 1662126 | 2021-08-28 | Leake | Mississippi | 28079 | 3596 | 80 |
1658878 | 1658878 | 2021-08-27 | Leake | Mississippi | 28079 | 3596 | 80 |
1631242 | 1631242 | 2021-08-18 | Wise | Virginia | 51195 | 3596 | 107 |
1600303 | 1600303 | 2021-08-09 | Freeborn | Minnesota | 27047 | 3596 | 36 |
1594304 | 1594304 | 2021-08-07 | Allegany | New York | 36003 | 3596 | 87 |
1578026 | 1578026 | 2021-08-02 | Cibola | New Mexico | 35006 | 3596 | 128 |
1571861 | 1571861 | 2021-07-31 | Williams | Ohio | 39171 | 3596 | 78 |
1559284 | 1559284 | 2021-07-27 | Hardeman | Tennessee | 47069 | 3596 | 64 |
1533081 | 1533081 | 2021-07-19 | Arecibo | Puerto Rico | 72013 | 3596 | |
1496047 | 1496047 | 2021-07-08 | Calloway | Kentucky | 21035 | 3596 | 50 |
1487190 | 1487190 | 2021-07-05 | Wyoming | New York | 36121 | 3596 | 53 |
1450513 | 1450513 | 2021-06-24 | Geary | Kansas | 20061 | 3596 | 42 |
1447268 | 1447268 | 2021-06-23 | Geary | Kansas | 20061 | 3596 | 42 |
1435454 | 1435454 | 2021-06-19 | Highland | Ohio | 39071 | 3596 | 65 |
1432207 | 1432207 | 2021-06-18 | Highland | Ohio | 39071 | 3596 | 65 |
1428961 | 1428961 | 2021-06-17 | Highland | Ohio | 39071 | 3596 | 65 |
1425716 | 1425716 | 2021-06-16 | Highland | Ohio | 39071 | 3596 | 65 |
1378472 | 1378472 | 2021-06-02 | Montrose | Colorado | 8085 | 3596 | 60 |
1378972 | 1378972 | 2021-06-02 | Wabash | Indiana | 18169 | 3596 | 82 |
1358733 | 1358733 | 2021-05-27 | Dallas | Alabama | 1047 | 3596 | 154 |
1361733 | 1361733 | 2021-05-27 | Prince George | Virginia | 51149 | 3596 | 30 |
1323003 | 1323003 | 2021-05-16 | Chambers | Alabama | 1017 | 3596 | 123 |
1316679 | 1316679 | 2021-05-14 | St. Francis | Arkansas | 5123 | 3596 | 43 |
1314864 | 1314864 | 2021-05-13 | Webster | Missouri | 29225 | 3596 | 54 |
1302549 | 1302549 | 2021-05-09 | Clinton | Pennsylvania | 42035 | 3596 | 62 |
1285871 | 1285871 | 2021-05-04 | Rio Arriba | New Mexico | 35039 | 3596 | 76 |
1283220 | 1283220 | 2021-05-03 | Colleton | South Carolina | 45029 | 3596 | 126 |
1271660 | 1271660 | 2021-04-30 | Christian | Illinois | 17021 | 3596 | 91 |
1267091 | 1267091 | 2021-04-28 | Carroll | Tennessee | 47017 | 3596 | 83 |
1267176 | 1267176 | 2021-04-28 | White | Tennessee | 47185 | 3596 | 68 |
1262869 | 1262869 | 2021-04-27 | Marion | Missouri | 29127 | 3596 | 45 |
1260597 | 1260597 | 2021-04-26 | Carroll | Tennessee | 47017 | 3596 | 83 |
1224415 | 1224415 | 2021-04-15 | Clinton | Ohio | 39027 | 3596 | 59 |
1196742 | 1196742 | 2021-04-07 | Unknown | Florida | 3596 | 0 | |
1168690 | 1168690 | 2021-03-29 | Marion | Missouri | 29127 | 3596 | 42 |
1165442 | 1165442 | 2021-03-28 | Marion | Missouri | 29127 | 3596 | 42 |
1158129 | 1158129 | 2021-03-26 | Knox | Indiana | 18083 | 3596 | 87 |
1148438 | 1148438 | 2021-03-23 | Whitley | Indiana | 18183 | 3596 | 40 |
1136519 | 1136519 | 2021-03-19 | Fulton | New York | 36035 | 3596 | 85 |
1132148 | 1132148 | 2021-03-18 | Huntington | Indiana | 18069 | 3596 | 80 |
1129307 | 1129307 | 2021-03-17 | Iberville | Louisiana | 22047 | 3596 | 94 |
1127812 | 1127812 | 2021-03-16 | Sanpete | Utah | 49039 | 3596 | 19 |
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);