ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
423 rows where cases = 922 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 43
- Georgia 32
- Kentucky 24
- Iowa 22
- Missouri 20
- Nebraska 19
- Indiana 18
- Minnesota 17
- Puerto Rico 15
- Alabama 14
- Louisiana 14
- Mississippi 13
- South Dakota 13
- Virginia 13
- Kansas 12
- Wisconsin 10
- Washington 9
- Arkansas 8
- Michigan 8
- Florida 7
- Idaho 7
- New Mexico 7
- Montana 6
- North Carolina 6
- Ohio 6
- Pennsylvania 6
- Tennessee 6
- Alaska 5
- Utah 5
- West Virginia 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2247130 | 2247130 | 2022-02-24 | Red Lake | Minnesota | 27125 | 922 | 12 |
2223572 | 2223572 | 2022-02-17 | Lincoln | Idaho | 16063 | 922 | 15 |
2222218 | 2222218 | 2022-02-16 | Edmunds | South Dakota | 46045 | 922 | 16 |
2218967 | 2218967 | 2022-02-15 | Edmunds | South Dakota | 46045 | 922 | 16 |
2213670 | 2213670 | 2022-02-14 | Echols | Georgia | 13101 | 922 | 11 |
2215716 | 2215716 | 2022-02-14 | Edmunds | South Dakota | 46045 | 922 | 16 |
2212465 | 2212465 | 2022-02-13 | Edmunds | South Dakota | 46045 | 922 | 16 |
2209212 | 2209212 | 2022-02-12 | Edmunds | South Dakota | 46045 | 922 | 16 |
2205959 | 2205959 | 2022-02-11 | Edmunds | South Dakota | 46045 | 922 | 16 |
2198516 | 2198516 | 2022-02-09 | Knox | Missouri | 29103 | 922 | 12 |
2175216 | 2175216 | 2022-02-02 | Carlisle | Kentucky | 21039 | 922 | 16 |
2171963 | 2171963 | 2022-02-01 | Carlisle | Kentucky | 21039 | 922 | 16 |
2160617 | 2160617 | 2022-01-28 | Donley | Texas | 48129 | 922 | 20 |
2150980 | 2150980 | 2022-01-25 | Presidio | Texas | 48377 | 922 | 32 |
2142223 | 2142223 | 2022-01-23 | Boise | Idaho | 16015 | 922 | 11 |
2138968 | 2138968 | 2022-01-22 | Boise | Idaho | 16015 | 922 | 11 |
2123836 | 2123836 | 2022-01-17 | Fillmore | Nebraska | 31059 | 922 | 13 |
2124459 | 2124459 | 2022-01-17 | Sullivan | Pennsylvania | 42113 | 922 | 32 |
2124965 | 2124965 | 2022-01-17 | San Augustine | Texas | 48405 | 922 | 38 |
2076453 | 2076453 | 2022-01-02 | Skamania | Washington | 53059 | 922 | 9 |
2073202 | 2073202 | 2022-01-01 | Skamania | Washington | 53059 | 922 | 9 |
2069951 | 2069951 | 2021-12-31 | Skamania | Washington | 53059 | 922 | 9 |
2066700 | 2066700 | 2021-12-30 | Skamania | Washington | 53059 | 922 | 9 |
2030263 | 2030263 | 2021-12-19 | Santa Isabel | Puerto Rico | 72133 | 922 | |
2019091 | 2019091 | 2021-12-16 | Scott | Kansas | 20171 | 922 | 32 |
2015841 | 2015841 | 2021-12-15 | Scott | Kansas | 20171 | 922 | 32 |
2001419 | 2001419 | 2021-12-10 | Presidio | Texas | 48377 | 922 | 28 |
1986686 | 1986686 | 2021-12-06 | Menifee | Kentucky | 21165 | 922 | 25 |
1971877 | 1971877 | 2021-12-01 | Tripp | South Dakota | 46123 | 922 | 21 |
1966005 | 1966005 | 2021-11-29 | Wirt | West Virginia | 54105 | 922 | 16 |
1921569 | 1921569 | 2021-11-16 | Republic | Kansas | 20157 | 922 | 14 |
1921947 | 1921947 | 2021-11-16 | Grant | Minnesota | 27051 | 922 | 9 |
1918319 | 1918319 | 2021-11-15 | Republic | Kansas | 20157 | 922 | 14 |
1920072 | 1920072 | 2021-11-15 | Hartley | Texas | 48205 | 922 | 2 |
1916822 | 1916822 | 2021-11-14 | Hartley | Texas | 48205 | 922 | 2 |
1913572 | 1913572 | 2021-11-13 | Hartley | Texas | 48205 | 922 | 2 |
1901026 | 1901026 | 2021-11-09 | Iron | Wisconsin | 55051 | 922 | 42 |
1884103 | 1884103 | 2021-11-04 | McCook | South Dakota | 46087 | 922 | 25 |
1878559 | 1878559 | 2021-11-03 | Modoc | California | 6049 | 922 | 9 |
1856975 | 1856975 | 2021-10-27 | Mahnomen | Minnesota | 27087 | 922 | 12 |
1855148 | 1855148 | 2021-10-26 | Mitchell | Texas | 48335 | 922 | 39 |
1855461 | 1855461 | 2021-10-26 | Calhoun | West Virginia | 54013 | 922 | 4 |
1837704 | 1837704 | 2021-10-21 | Shelby | Missouri | 29205 | 922 | 9 |
1838892 | 1838892 | 2021-10-21 | McCulloch | Texas | 48307 | 922 | 36 |
1832501 | 1832501 | 2021-10-19 | Kane | Utah | 49025 | 922 | 11 |
1809875 | 1809875 | 2021-10-12 | Middlesex | Virginia | 51119 | 922 | 27 |
1803561 | 1803561 | 2021-10-10 | Menominee | Wisconsin | 55078 | 922 | 11 |
1800312 | 1800312 | 2021-10-09 | Menominee | Wisconsin | 55078 | 922 | 11 |
1797063 | 1797063 | 2021-10-08 | Menominee | Wisconsin | 55078 | 922 | 11 |
1769607 | 1769607 | 2021-09-30 | Merrick | Nebraska | 31121 | 922 | 15 |
1766039 | 1766039 | 2021-09-29 | Wilkin | Minnesota | 27167 | 922 | 14 |
1741127 | 1741127 | 2021-09-21 | Hamlin | South Dakota | 46057 | 922 | 40 |
1735932 | 1735932 | 2021-09-20 | Wheeler | Georgia | 13309 | 922 | 31 |
1723984 | 1723984 | 2021-09-16 | Shannon | Missouri | 29203 | 922 | 16 |
1720153 | 1720153 | 2021-09-15 | Bracken | Kentucky | 21023 | 922 | 8 |
1721082 | 1721082 | 2021-09-15 | Gates | North Carolina | 37073 | 922 | 14 |
1716755 | 1716755 | 2021-09-14 | Monona | Iowa | 19133 | 922 | 33 |
1713509 | 1713509 | 2021-09-13 | Monona | Iowa | 19133 | 922 | 33 |
1715163 | 1715163 | 2021-09-13 | Spink | South Dakota | 46115 | 922 | 26 |
1715277 | 1715277 | 2021-09-13 | Bailey | Texas | 48017 | 922 | 21 |
1709909 | 1709909 | 2021-09-12 | Randolph | Georgia | 13243 | 922 | 36 |
1710262 | 1710262 | 2021-09-12 | Monona | Iowa | 19133 | 922 | 33 |
1710519 | 1710519 | 2021-09-12 | Wolfe | Kentucky | 21237 | 922 | 8 |
1712031 | 1712031 | 2021-09-12 | Bailey | Texas | 48017 | 922 | 21 |
1706662 | 1706662 | 2021-09-11 | Randolph | Georgia | 13243 | 922 | 36 |
1707015 | 1707015 | 2021-09-11 | Monona | Iowa | 19133 | 922 | 33 |
1707272 | 1707272 | 2021-09-11 | Wolfe | Kentucky | 21237 | 922 | 8 |
1708784 | 1708784 | 2021-09-11 | Bailey | Texas | 48017 | 922 | 21 |
1703414 | 1703414 | 2021-09-10 | Randolph | Georgia | 13243 | 922 | 36 |
1703767 | 1703767 | 2021-09-10 | Monona | Iowa | 19133 | 922 | 33 |
1704024 | 1704024 | 2021-09-10 | Wolfe | Kentucky | 21237 | 922 | 8 |
1700216 | 1700216 | 2021-09-09 | Benewah | Idaho | 16009 | 922 | 11 |
1700517 | 1700517 | 2021-09-09 | Monona | Iowa | 19133 | 922 | 33 |
1701693 | 1701693 | 2021-09-09 | Pembina | North Dakota | 38067 | 922 | 11 |
1702320 | 1702320 | 2021-09-09 | Coleman | Texas | 48083 | 922 | 43 |
1697268 | 1697268 | 2021-09-08 | Monona | Iowa | 19133 | 922 | 33 |
1699071 | 1699071 | 2021-09-08 | Coleman | Texas | 48083 | 922 | 41 |
1699184 | 1699184 | 2021-09-08 | Marion | Texas | 48315 | 922 | 35 |
1681685 | 1681685 | 2021-09-03 | Daviess | Missouri | 29061 | 922 | 12 |
1682998 | 1682998 | 2021-09-03 | Stephens | Texas | 48429 | 922 | 29 |
1676675 | 1676675 | 2021-09-01 | Northumberland | Virginia | 51133 | 922 | 21 |
1669795 | 1669795 | 2021-08-30 | Archer | Texas | 48009 | 922 | 13 |
1666255 | 1666255 | 2021-08-29 | Aibonito | Puerto Rico | 72009 | 922 | |
1666548 | 1666548 | 2021-08-29 | Archer | Texas | 48009 | 922 | 13 |
1663300 | 1663300 | 2021-08-28 | Archer | Texas | 48009 | 922 | 13 |
1658941 | 1658941 | 2021-08-27 | Chariton | Missouri | 29041 | 922 | 8 |
1660052 | 1660052 | 2021-08-27 | Archer | Texas | 48009 | 922 | 12 |
1634841 | 1634841 | 2021-08-20 | Montgomery | Arkansas | 5097 | 922 | 33 |
1637041 | 1637041 | 2021-08-20 | Florida | Puerto Rico | 72054 | 922 | |
1625836 | 1625836 | 2021-08-17 | Anderson | Kansas | 20003 | 922 | 19 |
1626279 | 1626279 | 2021-08-17 | Clearwater | Minnesota | 27029 | 922 | 17 |
1627642 | 1627642 | 2021-08-17 | Franklin | Texas | 48159 | 922 | 26 |
1622589 | 1622589 | 2021-08-16 | Anderson | Kansas | 20003 | 922 | 19 |
1624640 | 1624640 | 2021-08-16 | Charlotte | Virginia | 51037 | 922 | 21 |
1619234 | 1619234 | 2021-08-15 | Warren | Indiana | 18171 | 922 | 16 |
1621165 | 1621165 | 2021-08-15 | Hamilton | Texas | 48193 | 922 | 29 |
1615986 | 1615986 | 2021-08-14 | Warren | Indiana | 18171 | 922 | 16 |
1617917 | 1617917 | 2021-08-14 | Hamilton | Texas | 48193 | 922 | 29 |
1618014 | 1618014 | 2021-08-14 | Red River | Texas | 48387 | 922 | 39 |
1612737 | 1612737 | 2021-08-13 | Warren | Indiana | 18171 | 922 | 16 |
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);