ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where cases = 3688 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Virginia 12
- Oklahoma 9
- Georgia 8
- Iowa 7
- Kansas 7
- Wisconsin 7
- Indiana 6
- Kentucky 6
- Louisiana 6
- Ohio 6
- Pennsylvania 6
- New York 5
- Missouri 4
- South Dakota 4
- Washington 4
- North Carolina 3
- South Carolina 3
- West Virginia 3
- Alabama 2
- Illinois 2
- New Mexico 2
- Tennessee 2
- Wyoming 2
- Alaska 1
- Colorado 1
- Florida 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475408 | 2475408 | 2022-05-05 | Schuyler | New York | 36097 | 3688 | 25 |
2469677 | 2469677 | 2022-05-03 | Comanche | Texas | 48093 | 3688 | 78 |
2466421 | 2466421 | 2022-05-02 | Comanche | Texas | 48093 | 3688 | 78 |
2463166 | 2463166 | 2022-05-01 | Comanche | Texas | 48093 | 3688 | 78 |
2463681 | 2463681 | 2022-05-01 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2459910 | 2459910 | 2022-04-30 | Comanche | Texas | 48093 | 3688 | 78 |
2460425 | 2460425 | 2022-04-30 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2457169 | 2457169 | 2022-04-29 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2401624 | 2401624 | 2022-04-12 | King William | Virginia | 51101 | 3688 | 39 |
2398369 | 2398369 | 2022-04-11 | King William | Virginia | 51101 | 3688 | 39 |
2290794 | 2290794 | 2022-03-09 | Madison | Texas | 48313 | 3688 | 53 |
2226095 | 2226095 | 2022-02-17 | Grant | West Virginia | 54023 | 3688 | 54 |
2214734 | 2214734 | 2022-02-14 | Bates | Missouri | 29013 | 3688 | 77 |
2212925 | 2212925 | 2022-02-13 | Buckingham | Virginia | 51029 | 3688 | 46 |
2209672 | 2209672 | 2022-02-12 | Buckingham | Virginia | 51029 | 3688 | 46 |
2206419 | 2206419 | 2022-02-11 | Buckingham | Virginia | 51029 | 3688 | 46 |
2198808 | 2198808 | 2022-02-09 | Socorro | New Mexico | 35053 | 3688 | 80 |
2188818 | 2188818 | 2022-02-06 | Wright | Missouri | 29229 | 3688 | 72 |
2148989 | 2148989 | 2022-01-25 | Delaware | Iowa | 19055 | 3688 | 65 |
2145737 | 2145737 | 2022-01-24 | Delaware | Iowa | 19055 | 3688 | 65 |
2142482 | 2142482 | 2022-01-23 | Delaware | Iowa | 19055 | 3688 | 65 |
2139227 | 2139227 | 2022-01-22 | Delaware | Iowa | 19055 | 3688 | 65 |
2135971 | 2135971 | 2022-01-21 | Delaware | Iowa | 19055 | 3688 | 65 |
2132719 | 2132719 | 2022-01-20 | Delaware | Iowa | 19055 | 3688 | 65 |
2129466 | 2129466 | 2022-01-19 | Delaware | Iowa | 19055 | 3688 | 65 |
2125149 | 2125149 | 2022-01-17 | New Kent | Virginia | 51127 | 3688 | 28 |
2099251 | 2099251 | 2022-01-09 | McDowell | West Virginia | 54047 | 3688 | 56 |
2076196 | 2076196 | 2022-01-02 | Scurry | Texas | 48415 | 3688 | 92 |
2072945 | 2072945 | 2022-01-01 | Scurry | Texas | 48415 | 3688 | 92 |
2069694 | 2069694 | 2021-12-31 | Scurry | Texas | 48415 | 3688 | 92 |
2066443 | 2066443 | 2021-12-30 | Scurry | Texas | 48415 | 3688 | 92 |
2063193 | 2063193 | 2021-12-29 | Scurry | Texas | 48415 | 3688 | 90 |
2053077 | 2053077 | 2021-12-26 | Beadle | South Dakota | 46005 | 3688 | 49 |
2049827 | 2049827 | 2021-12-25 | Beadle | South Dakota | 46005 | 3688 | 49 |
2046577 | 2046577 | 2021-12-24 | Beadle | South Dakota | 46005 | 3688 | 49 |
2043327 | 2043327 | 2021-12-23 | Beadle | South Dakota | 46005 | 3688 | 49 |
2032594 | 2032594 | 2021-12-20 | Stone | Mississippi | 28131 | 3688 | 66 |
2014492 | 2014492 | 2021-12-14 | Carbon | Utah | 49007 | 3688 | 40 |
2011546 | 2011546 | 2021-12-13 | Langlade | Wisconsin | 55067 | 3688 | 61 |
2001401 | 2001401 | 2021-12-10 | Moore | Texas | 48341 | 3688 | 91 |
1998066 | 1998066 | 2021-12-09 | Gillespie | Texas | 48171 | 3688 | 82 |
1992880 | 1992880 | 2021-12-08 | Spencer | Indiana | 18147 | 3688 | 49 |
1991625 | 1991625 | 2021-12-07 | Limestone | Texas | 48293 | 3688 | 111 |
1975529 | 1975529 | 2021-12-02 | St. Thomas | Virgin Islands | 78030 | 3688 | 46 |
1967224 | 1967224 | 2021-11-30 | Woodford | Kentucky | 21239 | 3688 | 31 |
1960651 | 1960651 | 2021-11-28 | Hart | Kentucky | 21099 | 3688 | 72 |
1957400 | 1957400 | 2021-11-27 | Hart | Kentucky | 21099 | 3688 | 72 |
1954149 | 1954149 | 2021-11-26 | Hart | Kentucky | 21099 | 3688 | 72 |
1950898 | 1950898 | 2021-11-25 | Hart | Kentucky | 21099 | 3688 | 72 |
1947647 | 1947647 | 2021-11-24 | Hart | Kentucky | 21099 | 3688 | 72 |
1949636 | 1949636 | 2021-11-24 | Salem city | Virginia | 51775 | 3688 | 67 |
1946385 | 1946385 | 2021-11-23 | Salem city | Virginia | 51775 | 3688 | 67 |
1940097 | 1940097 | 2021-11-22 | Barbour | Alabama | 1005 | 3688 | 80 |
1897650 | 1897650 | 2021-11-08 | Waynesboro city | Virginia | 51820 | 3688 | 48 |
1892253 | 1892253 | 2021-11-07 | Cherokee | Kansas | 20021 | 3688 | 79 |
1889003 | 1889003 | 2021-11-06 | Cherokee | Kansas | 20021 | 3688 | 79 |
1890195 | 1890195 | 2021-11-06 | Hocking | Ohio | 39073 | 3688 | 87 |
1885753 | 1885753 | 2021-11-05 | Cherokee | Kansas | 20021 | 3688 | 79 |
1861871 | 1861871 | 2021-10-28 | Orange | Virginia | 51137 | 3688 | 58 |
1815691 | 1815691 | 2021-10-14 | Warren | Pennsylvania | 42123 | 3688 | 117 |
1782784 | 1782784 | 2021-10-04 | Anson | North Carolina | 37007 | 3688 | 74 |
1766002 | 1766002 | 2021-09-29 | Mille Lacs | Minnesota | 27095 | 3688 | 61 |
1734223 | 1734223 | 2021-09-19 | Fayette | Ohio | 39047 | 3688 | 52 |
1717069 | 1717069 | 2021-09-14 | Union | Louisiana | 22111 | 3688 | 93 |
1719074 | 1719074 | 2021-09-14 | Juneau | Wisconsin | 55057 | 3688 | 31 |
1710193 | 1710193 | 2021-09-12 | Wells | Indiana | 18179 | 3688 | 85 |
1706946 | 1706946 | 2021-09-11 | Wells | Indiana | 18179 | 3688 | 85 |
1703698 | 1703698 | 2021-09-10 | Wells | Indiana | 18179 | 3688 | 85 |
1702312 | 1702312 | 2021-09-09 | Cass | Texas | 48067 | 3688 | 110 |
1702896 | 1702896 | 2021-09-09 | Park | Wyoming | 56029 | 3688 | 41 |
1672280 | 1672280 | 2021-08-31 | Greene | New York | 36039 | 3688 | 82 |
1659272 | 1659272 | 2021-08-27 | Allegany | New York | 36003 | 3688 | 88 |
1659514 | 1659514 | 2021-08-27 | Guernsey | Ohio | 39059 | 3688 | 54 |
1631978 | 1631978 | 2021-08-19 | White | Georgia | 13311 | 3688 | 87 |
1580416 | 1580416 | 2021-08-03 | Montgomery | Kansas | 20125 | 3688 | 85 |
1577167 | 1577167 | 2021-08-02 | Montgomery | Kansas | 20125 | 3688 | 85 |
1578846 | 1578846 | 2021-08-02 | Bee | Texas | 48025 | 3688 | 75 |
1579317 | 1579317 | 2021-08-02 | Fayette | West Virginia | 54019 | 3688 | 84 |
1575598 | 1575598 | 2021-08-01 | Bee | Texas | 48025 | 3688 | 75 |
1550252 | 1550252 | 2021-07-25 | Dallas | Alabama | 1047 | 3688 | 163 |
1550770 | 1550770 | 2021-07-25 | Wayne | Georgia | 13305 | 3688 | 91 |
1547523 | 1547523 | 2021-07-24 | Wayne | Georgia | 13305 | 3688 | 91 |
1544276 | 1544276 | 2021-07-23 | Wayne | Georgia | 13305 | 3688 | 91 |
1506665 | 1506665 | 2021-07-11 | Warren | New York | 36113 | 3688 | 58 |
1500593 | 1500593 | 2021-07-09 | Snyder | Pennsylvania | 42109 | 3688 | 86 |
1497347 | 1497347 | 2021-07-08 | Snyder | Pennsylvania | 42109 | 3688 | 86 |
1494100 | 1494100 | 2021-07-07 | Snyder | Pennsylvania | 42109 | 3688 | 86 |
1447482 | 1447482 | 2021-06-23 | Evangeline | Louisiana | 22039 | 3688 | 97 |
1429295 | 1429295 | 2021-06-17 | Colleton | South Carolina | 45029 | 3688 | 130 |
1422803 | 1422803 | 2021-06-15 | Colleton | South Carolina | 45029 | 3688 | 129 |
1405082 | 1405082 | 2021-06-10 | Harvey | Kansas | 20079 | 3688 | 72 |
1401837 | 1401837 | 2021-06-09 | Harvey | Kansas | 20079 | 3688 | 72 |
1371513 | 1371513 | 2021-05-30 | Douglas | Washington | 53017 | 3688 | 23 |
1368267 | 1368267 | 2021-05-29 | Douglas | Washington | 53017 | 3688 | 23 |
1365021 | 1365021 | 2021-05-28 | Douglas | Washington | 53017 | 3688 | 23 |
1361775 | 1361775 | 2021-05-27 | Douglas | Washington | 53017 | 3688 | 22 |
1355378 | 1355378 | 2021-05-25 | Clark | Wisconsin | 55019 | 3688 | 63 |
1349376 | 1349376 | 2021-05-24 | Bryan | Georgia | 13029 | 3688 | 40 |
1292841 | 1292841 | 2021-05-06 | Perry | Pennsylvania | 42099 | 3688 | 100 |
1286752 | 1286752 | 2021-05-04 | Grimes | Texas | 48185 | 3688 | 69 |
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);