ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where cases = 4451 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 9
- Maine 7
- Michigan 7
- Mississippi 7
- Oklahoma 7
- Tennessee 7
- Alabama 6
- Georgia 6
- Illinois 6
- Ohio 6
- Kansas 5
- Louisiana 5
- Missouri 5
- Colorado 4
- Arkansas 3
- Indiana 3
- Minnesota 3
- Puerto Rico 3
- Texas 3
- Wisconsin 3
- California 2
- New Jersey 2
- South Carolina 2
- West Virginia 2
- Iowa 1
- Montana 1
- New Hampshire 1
- New York 1
- North Carolina 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442156 | 2442156 | 2022-04-25 | Washington | Maine | 23029 | 4451 | 55 |
2438900 | 2438900 | 2022-04-24 | Washington | Maine | 23029 | 4451 | 55 |
2435644 | 2435644 | 2022-04-23 | Washington | Maine | 23029 | 4451 | 55 |
2356574 | 2356574 | 2022-03-30 | Chaffee | Colorado | 8015 | 4451 | 44 |
2346596 | 2346596 | 2022-03-27 | Henry | Alabama | 1067 | 4451 | 74 |
2347857 | 2347857 | 2022-03-27 | Manistee | Michigan | 26101 | 4451 | 88 |
2343343 | 2343343 | 2022-03-26 | Henry | Alabama | 1067 | 4451 | 74 |
2344604 | 2344604 | 2022-03-26 | Manistee | Michigan | 26101 | 4451 | 88 |
2340090 | 2340090 | 2022-03-25 | Henry | Alabama | 1067 | 4451 | 74 |
2341351 | 2341351 | 2022-03-25 | Manistee | Michigan | 26101 | 4451 | 88 |
2333687 | 2333687 | 2022-03-23 | Grant | Arkansas | 5053 | 4451 | 60 |
2330941 | 2330941 | 2022-03-22 | Johnson | Illinois | 17087 | 4451 | 46 |
2302090 | 2302090 | 2022-03-13 | Lewis | Kentucky | 21135 | 4451 | 79 |
2298838 | 2298838 | 2022-03-12 | Lewis | Kentucky | 21135 | 4451 | 79 |
2295586 | 2295586 | 2022-03-11 | Lewis | Kentucky | 21135 | 4451 | 79 |
2292334 | 2292334 | 2022-03-10 | Lewis | Kentucky | 21135 | 4451 | 79 |
2289082 | 2289082 | 2022-03-09 | Lewis | Kentucky | 21135 | 4451 | 79 |
2285269 | 2285269 | 2022-03-08 | Putnam | Georgia | 13237 | 4451 | 101 |
2285831 | 2285831 | 2022-03-08 | Lewis | Kentucky | 21135 | 4451 | 79 |
2282579 | 2282579 | 2022-03-07 | Lewis | Kentucky | 21135 | 4451 | 79 |
2231845 | 2231845 | 2022-02-19 | Fajardo | Puerto Rico | 72053 | 4451 | |
2191647 | 2191647 | 2022-02-07 | Franklin | Maine | 23007 | 4451 | 49 |
2188394 | 2188394 | 2022-02-06 | Franklin | Maine | 23007 | 4451 | 49 |
2185141 | 2185141 | 2022-02-05 | Franklin | Maine | 23007 | 4451 | 49 |
2171995 | 2171995 | 2022-02-01 | Henry | Kentucky | 21103 | 4451 | 42 |
2126359 | 2126359 | 2022-01-18 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2127201 | 2127201 | 2022-01-18 | Unknown | New Jersey | 4451 | 0 | |
2122260 | 2122260 | 2022-01-17 | Columbia | Arkansas | 5027 | 4451 | 77 |
2123107 | 2123107 | 2022-01-17 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2119855 | 2119855 | 2022-01-16 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2116603 | 2116603 | 2022-01-15 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2113352 | 2113352 | 2022-01-14 | Pottawatomie | Kansas | 20149 | 4451 | 48 |
2110501 | 2110501 | 2022-01-13 | Martin | Minnesota | 27091 | 4451 | 53 |
2089524 | 2089524 | 2022-01-06 | Wyoming | West Virginia | 54109 | 4451 | 77 |
2056410 | 2056410 | 2021-12-27 | DeKalb | Tennessee | 47041 | 4451 | 84 |
2006402 | 2006402 | 2021-12-12 | Mason | Michigan | 26105 | 4451 | 61 |
2003151 | 2003151 | 2021-12-11 | Mason | Michigan | 26105 | 4451 | 61 |
1999901 | 1999901 | 2021-12-10 | Mason | Michigan | 26105 | 4451 | 61 |
1918982 | 1918982 | 2021-11-15 | Lake | Montana | 30047 | 4451 | 69 |
1904973 | 1904973 | 2021-11-11 | Fayette | Illinois | 17051 | 4451 | 70 |
1905680 | 1905680 | 2021-11-11 | Brown | Minnesota | 27015 | 4451 | 55 |
1907528 | 1907528 | 2021-11-11 | Juneau | Wisconsin | 55057 | 4451 | 36 |
1901723 | 1901723 | 2021-11-10 | Fayette | Illinois | 17051 | 4451 | 70 |
1874256 | 1874256 | 2021-11-01 | Vega Baja | Puerto Rico | 72145 | 4451 | |
1847012 | 1847012 | 2021-10-24 | Morehouse | Louisiana | 22067 | 4451 | 115 |
1843762 | 1843762 | 2021-10-23 | Morehouse | Louisiana | 22067 | 4451 | 115 |
1840512 | 1840512 | 2021-10-22 | Morehouse | Louisiana | 22067 | 4451 | 115 |
1824542 | 1824542 | 2021-10-17 | Copiah | Mississippi | 28029 | 4451 | 91 |
1821293 | 1821293 | 2021-10-16 | Copiah | Mississippi | 28029 | 4451 | 91 |
1818044 | 1818044 | 2021-10-15 | Copiah | Mississippi | 28029 | 4451 | 91 |
1812237 | 1812237 | 2021-10-13 | Morrow | Ohio | 39117 | 4451 | 56 |
1779109 | 1779109 | 2021-10-03 | Tate | Mississippi | 28137 | 4451 | 106 |
1775859 | 1775859 | 2021-10-02 | Tate | Mississippi | 28137 | 4451 | 106 |
1772609 | 1772609 | 2021-10-01 | Tate | Mississippi | 28137 | 4451 | 106 |
1763569 | 1763569 | 2021-09-28 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1760320 | 1760320 | 2021-09-27 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1761292 | 1761292 | 2021-09-27 | Clark | Wisconsin | 55019 | 4451 | 71 |
1757072 | 1757072 | 2021-09-26 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1757476 | 1757476 | 2021-09-26 | Overton | Tennessee | 47133 | 4451 | 76 |
1753824 | 1753824 | 2021-09-25 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1754228 | 1754228 | 2021-09-25 | Overton | Tennessee | 47133 | 4451 | 76 |
1750576 | 1750576 | 2021-09-24 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1750980 | 1750980 | 2021-09-24 | Overton | Tennessee | 47133 | 4451 | 76 |
1747326 | 1747326 | 2021-09-23 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1744077 | 1744077 | 2021-09-22 | Lincoln | Oklahoma | 40081 | 4451 | 94 |
1744224 | 1744224 | 2021-09-22 | Arecibo | Puerto Rico | 72013 | 4451 | |
1724480 | 1724480 | 2021-09-16 | Guernsey | Ohio | 39059 | 4451 | 57 |
1715905 | 1715905 | 2021-09-14 | Clarke | Alabama | 1025 | 4451 | 68 |
1717501 | 1717501 | 2021-09-14 | Warren | Missouri | 29219 | 4451 | 39 |
1700764 | 1700764 | 2021-09-09 | Taylor | Kentucky | 21217 | 4451 | 66 |
1646862 | 1646862 | 2021-08-23 | Colleton | South Carolina | 45029 | 4451 | 142 |
1608978 | 1608978 | 2021-08-12 | La Plata | Colorado | 8067 | 4451 | 45 |
1572574 | 1572574 | 2021-07-31 | Waller | Texas | 48473 | 4451 | 52 |
1518879 | 1518879 | 2021-07-15 | Avoyelles | Louisiana | 22009 | 4451 | 125 |
1511995 | 1511995 | 2021-07-13 | Harrison | Indiana | 18061 | 4451 | 77 |
1489293 | 1489293 | 2021-07-06 | Montgomery | Indiana | 18107 | 4451 | 93 |
1490644 | 1490644 | 2021-07-06 | Madison | Ohio | 39097 | 4451 | 66 |
1487397 | 1487397 | 2021-07-05 | Madison | Ohio | 39097 | 4451 | 66 |
1480307 | 1480307 | 2021-07-03 | Camden | Missouri | 29029 | 4451 | 90 |
1423820 | 1423820 | 2021-06-16 | Humboldt | California | 6023 | 4451 | 48 |
1424351 | 1424351 | 2021-06-16 | Gibson | Indiana | 18051 | 4451 | 96 |
1332711 | 1332711 | 2021-05-18 | Albany | Wyoming | 56001 | 4451 | 12 |
1319805 | 1319805 | 2021-05-15 | Russell | Alabama | 1113 | 4451 | 38 |
1287941 | 1287941 | 2021-05-05 | Marion | Illinois | 17121 | 4451 | 121 |
1273805 | 1273805 | 2021-04-30 | Kerr | Texas | 48265 | 4451 | 87 |
1262459 | 1262459 | 2021-04-27 | Lincoln | Louisiana | 22061 | 4451 | 92 |
1246542 | 1246542 | 2021-04-22 | Pearl River | Mississippi | 28109 | 4451 | 142 |
1247615 | 1247615 | 2021-04-22 | Cocke | Tennessee | 47029 | 4451 | 98 |
1236035 | 1236035 | 2021-04-19 | Woodford | Illinois | 17203 | 4451 | 75 |
1222736 | 1222736 | 2021-04-15 | Baldwin | Georgia | 13009 | 4451 | 125 |
1160288 | 1160288 | 2021-03-26 | Wasatch | Utah | 49051 | 4451 | 21 |
1131356 | 1131356 | 2021-03-17 | Monroe | Wisconsin | 55081 | 4451 | 35 |
1079894 | 1079894 | 2021-03-02 | Colquitt | Georgia | 13071 | 4451 | 101 |
1071633 | 1071633 | 2021-02-27 | Wayne | New York | 36117 | 4451 | 64 |
1048522 | 1048522 | 2021-02-20 | Callaway | Missouri | 29027 | 4451 | 43 |
1009875 | 1009875 | 2021-02-08 | Salem | New Jersey | 34033 | 4451 | 150 |
999516 | 999516 | 2021-02-05 | Androscoggin | Maine | 23001 | 4451 | 54 |
995942 | 995942 | 2021-02-04 | Marshall | Iowa | 19127 | 4451 | 68 |
974492 | 974492 | 2021-01-28 | Sandusky | Ohio | 39143 | 4451 | 62 |
957684 | 957684 | 2021-01-23 | Joplin | Missouri | 4451 | 88 |
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);