ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 4328 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Virginia 12
- Tennessee 10
- Kentucky 9
- Alabama 7
- Indiana 7
- Mississippi 7
- Illinois 6
- Minnesota 6
- North Carolina 6
- Arkansas 5
- Iowa 5
- West Virginia 5
- Colorado 4
- Georgia 4
- New York 4
- Ohio 4
- Louisiana 3
- Nebraska 3
- Nevada 3
- Wisconsin 3
- Alaska 2
- Maryland 2
- Michigan 2
- Missouri 2
- New Hampshire 2
- North Dakota 2
- Utah 2
- Idaho 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399230 | 2399230 | 2022-04-12 | Bond | Illinois | 17005 | 4328 | 37 |
2395770 | 2395770 | 2022-04-11 | Ben Hill | Georgia | 13017 | 4328 | 122 |
2395272 | 2395272 | 2022-04-10 | Wetzel | West Virginia | 54103 | 4328 | 83 |
2392016 | 2392016 | 2022-04-09 | Wetzel | West Virginia | 54103 | 4328 | 83 |
2388760 | 2388760 | 2022-04-08 | Wetzel | West Virginia | 54103 | 4328 | 83 |
2370449 | 2370449 | 2022-04-03 | Union | Kentucky | 21225 | 4328 | 56 |
2367196 | 2367196 | 2022-04-02 | Union | Kentucky | 21225 | 4328 | 56 |
2363943 | 2363943 | 2022-04-01 | Union | Kentucky | 21225 | 4328 | 56 |
2360689 | 2360689 | 2022-03-31 | Union | Kentucky | 21225 | 4328 | 56 |
2357435 | 2357435 | 2022-03-30 | Union | Kentucky | 21225 | 4328 | 56 |
2354182 | 2354182 | 2022-03-29 | Union | Kentucky | 21225 | 4328 | 56 |
2350930 | 2350930 | 2022-03-28 | Union | Kentucky | 21225 | 4328 | 56 |
2310413 | 2310413 | 2022-03-15 | Duchesne | Utah | 49013 | 4328 | 25 |
2258435 | 2258435 | 2022-02-27 | Bristol city | Virginia | 51520 | 4328 | 68 |
2255184 | 2255184 | 2022-02-26 | Bristol city | Virginia | 51520 | 4328 | 68 |
2251933 | 2251933 | 2022-02-25 | Bristol city | Virginia | 51520 | 4328 | 68 |
2244400 | 2244400 | 2022-02-23 | Avery | North Carolina | 37011 | 4328 | 41 |
2239873 | 2239873 | 2022-02-22 | Hancock | Illinois | 17067 | 4328 | 55 |
2224378 | 2224378 | 2022-02-17 | Roseau | Minnesota | 27135 | 4328 | 43 |
2171021 | 2171021 | 2022-02-01 | Kodiak Island Borough | Alaska | 2150 | 4328 | 10 |
2167768 | 2167768 | 2022-01-31 | Kodiak Island Borough | Alaska | 2150 | 4328 | 10 |
2169652 | 2169652 | 2022-01-31 | Madison | North Carolina | 37115 | 4328 | 74 |
2164566 | 2164566 | 2022-01-30 | Drew | Arkansas | 5043 | 4328 | 58 |
2161311 | 2161311 | 2022-01-29 | Drew | Arkansas | 5043 | 4328 | 58 |
2158055 | 2158055 | 2022-01-28 | Drew | Arkansas | 5043 | 4328 | 58 |
2133785 | 2133785 | 2022-01-20 | Schoharie | New York | 36095 | 4328 | 32 |
2129900 | 2129900 | 2022-01-19 | Charlevoix | Michigan | 26029 | 4328 | 54 |
2125437 | 2125437 | 2022-01-18 | Monroe | Alabama | 1099 | 4328 | 66 |
2122917 | 2122917 | 2022-01-17 | Sullivan | Indiana | 18153 | 4328 | 66 |
2106285 | 2106285 | 2022-01-12 | Burke | Georgia | 13033 | 4328 | 88 |
2087742 | 2087742 | 2022-01-06 | Martin | Minnesota | 27091 | 4328 | 52 |
2089483 | 2089483 | 2022-01-06 | Hampshire | West Virginia | 54027 | 4328 | 59 |
2035132 | 2035132 | 2021-12-21 | Posey | Indiana | 18129 | 4328 | 45 |
2009020 | 2009020 | 2021-12-13 | McDonough | Illinois | 17109 | 4328 | 81 |
2010291 | 2010291 | 2021-12-13 | Dare | North Carolina | 37055 | 4328 | 15 |
1997139 | 1997139 | 2021-12-09 | Coos | New Hampshire | 33007 | 4328 | 75 |
1990086 | 1990086 | 2021-12-07 | Franklin | Massachusetts | 25011 | 4328 | 126 |
1986350 | 1986350 | 2021-12-06 | LaGrange | Indiana | 18087 | 4328 | 93 |
1984901 | 1984901 | 2021-12-05 | DeKalb | Tennessee | 47041 | 4328 | 77 |
1981651 | 1981651 | 2021-12-04 | DeKalb | Tennessee | 47041 | 4328 | 77 |
1978401 | 1978401 | 2021-12-03 | DeKalb | Tennessee | 47041 | 4328 | 77 |
1961031 | 1961031 | 2021-11-28 | Covington | Mississippi | 28031 | 4328 | 95 |
1957780 | 1957780 | 2021-11-27 | Covington | Mississippi | 28031 | 4328 | 95 |
1954529 | 1954529 | 2021-11-26 | Covington | Mississippi | 28031 | 4328 | 95 |
1951278 | 1951278 | 2021-11-25 | Covington | Mississippi | 28031 | 4328 | 95 |
1948027 | 1948027 | 2021-11-24 | Covington | Mississippi | 28031 | 4328 | 95 |
1934807 | 1934807 | 2021-11-20 | Dorchester | Maryland | 24019 | 4328 | 85 |
1927096 | 1927096 | 2021-11-18 | Bibb | Alabama | 1007 | 4328 | 93 |
1905509 | 1905509 | 2021-11-11 | Richland | Louisiana | 22083 | 4328 | 79 |
1902259 | 1902259 | 2021-11-10 | Richland | Louisiana | 22083 | 4328 | 79 |
1890858 | 1890858 | 2021-11-06 | Kleberg | Texas | 48273 | 4328 | 130 |
1844470 | 1844470 | 2021-10-23 | Franklin | New York | 36033 | 4328 | 22 |
1810892 | 1810892 | 2021-10-13 | Scott | Indiana | 18143 | 4328 | 70 |
1765345 | 1765345 | 2021-09-29 | Daviess | Indiana | 18027 | 4328 | 111 |
1756573 | 1756573 | 2021-09-26 | Dakota | Nebraska | 31043 | 4328 | 82 |
1756649 | 1756649 | 2021-09-26 | Douglas | Nevada | 32005 | 4328 | 47 |
1753325 | 1753325 | 2021-09-25 | Dakota | Nebraska | 31043 | 4328 | 82 |
1753401 | 1753401 | 2021-09-25 | Douglas | Nevada | 32005 | 4328 | 47 |
1750077 | 1750077 | 2021-09-24 | Dakota | Nebraska | 31043 | 4328 | 82 |
1750153 | 1750153 | 2021-09-24 | Douglas | Nevada | 32005 | 4328 | 47 |
1732421 | 1732421 | 2021-09-19 | Logan | Colorado | 8075 | 4328 | 72 |
1729171 | 1729171 | 2021-09-18 | Logan | Colorado | 8075 | 4328 | 72 |
1725921 | 1725921 | 2021-09-17 | Logan | Colorado | 8075 | 4328 | 72 |
1713078 | 1713078 | 2021-09-13 | Dawson | Georgia | 13085 | 4328 | 54 |
1712424 | 1712424 | 2021-09-12 | Prince George | Virginia | 51149 | 4328 | 33 |
1709177 | 1709177 | 2021-09-11 | Prince George | Virginia | 51149 | 4328 | 33 |
1705930 | 1705930 | 2021-09-10 | Prince George | Virginia | 51149 | 4328 | 33 |
1697545 | 1697545 | 2021-09-08 | East Feliciana | Louisiana | 22037 | 4328 | 133 |
1633345 | 1633345 | 2021-08-19 | Bladen | North Carolina | 37017 | 4328 | 63 |
1600328 | 1600328 | 2021-08-09 | Morrison | Minnesota | 27097 | 4328 | 62 |
1600734 | 1600734 | 2021-08-09 | Belknap | New Hampshire | 33001 | 4328 | 101 |
1591080 | 1591080 | 2021-08-06 | Montgomery | New York | 36057 | 4328 | 128 |
1574168 | 1574168 | 2021-08-01 | Calvert | Maryland | 24009 | 4328 | 86 |
1564335 | 1564335 | 2021-07-29 | Whitley | Kentucky | 21235 | 4328 | 62 |
1553230 | 1553230 | 2021-07-25 | Manassas city | Virginia | 51683 | 4328 | 48 |
1549841 | 1549841 | 2021-07-24 | Waller | Texas | 48473 | 4328 | 52 |
1549983 | 1549983 | 2021-07-24 | Manassas city | Virginia | 51683 | 4328 | 48 |
1546736 | 1546736 | 2021-07-23 | Manassas city | Virginia | 51683 | 4328 | 48 |
1543489 | 1543489 | 2021-07-22 | Manassas city | Virginia | 51683 | 4328 | 48 |
1533876 | 1533876 | 2021-07-19 | Ohio | West Virginia | 54069 | 4328 | 87 |
1506378 | 1506378 | 2021-07-11 | Webster | Missouri | 29225 | 4328 | 59 |
1488565 | 1488565 | 2021-07-06 | Franklin | Alabama | 1059 | 4328 | 81 |
1485318 | 1485318 | 2021-07-05 | Franklin | Alabama | 1059 | 4328 | 81 |
1487374 | 1487374 | 2021-07-05 | Fulton | Ohio | 39051 | 4328 | 75 |
1482072 | 1482072 | 2021-07-04 | Franklin | Alabama | 1059 | 4328 | 81 |
1478825 | 1478825 | 2021-07-03 | Franklin | Alabama | 1059 | 4328 | 81 |
1475579 | 1475579 | 2021-07-02 | Franklin | Alabama | 1059 | 4328 | 81 |
1429513 | 1429513 | 2021-06-17 | Brown | Texas | 48049 | 4328 | 138 |
1426268 | 1426268 | 2021-06-16 | Brown | Texas | 48049 | 4328 | 138 |
1421416 | 1421416 | 2021-06-15 | Graves | Kentucky | 21083 | 4328 | 96 |
1423021 | 1423021 | 2021-06-15 | Brown | Texas | 48049 | 4328 | 138 |
1419775 | 1419775 | 2021-06-14 | Brown | Texas | 48049 | 4328 | 138 |
1416530 | 1416530 | 2021-06-13 | Brown | Texas | 48049 | 4328 | 138 |
1413284 | 1413284 | 2021-06-12 | Brown | Texas | 48049 | 4328 | 138 |
1410039 | 1410039 | 2021-06-11 | Brown | Texas | 48049 | 4328 | 138 |
1404904 | 1404904 | 2021-06-10 | Montgomery | Indiana | 18107 | 4328 | 92 |
1407185 | 1407185 | 2021-06-10 | Shenandoah | Virginia | 51171 | 4328 | 134 |
1392051 | 1392051 | 2021-06-06 | Wapello | Iowa | 19179 | 4328 | 122 |
1388806 | 1388806 | 2021-06-05 | Wapello | Iowa | 19179 | 4328 | 122 |
1385561 | 1385561 | 2021-06-04 | Wapello | Iowa | 19179 | 4328 | 122 |
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);