ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
477 rows where cases = 1102 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 44
- Texas 35
- Missouri 28
- Georgia 25
- Iowa 25
- Tennessee 25
- Virginia 25
- Ohio 22
- Kentucky 20
- Mississippi 17
- Oklahoma 17
- Nebraska 16
- Puerto Rico 15
- Arkansas 13
- Alabama 11
- Minnesota 10
- Indiana 9
- Louisiana 9
- Michigan 9
- North Carolina 9
- New Mexico 8
- West Virginia 8
- Illinois 7
- North Dakota 7
- Wisconsin 7
- Kansas 6
- South Dakota 6
- Florida 5
- Vermont 5
- Alaska 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502302 | 2502302 | 2022-05-13 | Hall | Texas | 48191 | 1102 | 24 |
2499044 | 2499044 | 2022-05-12 | Hall | Texas | 48191 | 1102 | 24 |
2475343 | 2475343 | 2022-05-05 | Hidalgo | New Mexico | 35023 | 1102 | 15 |
2472086 | 2472086 | 2022-05-04 | Hidalgo | New Mexico | 35023 | 1102 | 15 |
2468830 | 2468830 | 2022-05-03 | Hidalgo | New Mexico | 35023 | 1102 | 15 |
2465574 | 2465574 | 2022-05-02 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2462319 | 2462319 | 2022-05-01 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2459063 | 2459063 | 2022-04-30 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2455807 | 2455807 | 2022-04-29 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2452551 | 2452551 | 2022-04-28 | Hidalgo | New Mexico | 35023 | 1102 | 14 |
2422218 | 2422218 | 2022-04-19 | Audubon | Iowa | 19009 | 1102 | 19 |
2418962 | 2418962 | 2022-04-18 | Audubon | Iowa | 19009 | 1102 | 19 |
2415706 | 2415706 | 2022-04-17 | Audubon | Iowa | 19009 | 1102 | 19 |
2417285 | 2417285 | 2022-04-17 | Las Marias | Puerto Rico | 72083 | 1102 | |
2412450 | 2412450 | 2022-04-16 | Audubon | Iowa | 19009 | 1102 | 19 |
2409194 | 2409194 | 2022-04-15 | Audubon | Iowa | 19009 | 1102 | 19 |
2405938 | 2405938 | 2022-04-14 | Audubon | Iowa | 19009 | 1102 | 19 |
2402682 | 2402682 | 2022-04-13 | Audubon | Iowa | 19009 | 1102 | 19 |
2258451 | 2258451 | 2022-02-27 | Craig | Virginia | 51045 | 1102 | 15 |
2255200 | 2255200 | 2022-02-26 | Craig | Virginia | 51045 | 1102 | 15 |
2251949 | 2251949 | 2022-02-25 | Craig | Virginia | 51045 | 1102 | 15 |
2225978 | 2225978 | 2022-02-17 | King and Queen | Virginia | 51097 | 1102 | 10 |
2188193 | 2188193 | 2022-02-06 | Stafford | Kansas | 20185 | 1102 | 26 |
2184940 | 2184940 | 2022-02-05 | Stafford | Kansas | 20185 | 1102 | 26 |
2181688 | 2181688 | 2022-02-04 | Stafford | Kansas | 20185 | 1102 | 26 |
2167305 | 2167305 | 2022-01-30 | Wheeler | Texas | 48483 | 1102 | 15 |
2149533 | 2149533 | 2022-01-25 | Lincoln | Minnesota | 27081 | 1102 | 5 |
2147591 | 2147591 | 2022-01-24 | Crane | Texas | 48103 | 1102 | 19 |
2104849 | 2104849 | 2022-01-11 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2101598 | 2101598 | 2022-01-10 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2098347 | 2098347 | 2022-01-09 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2095095 | 2095095 | 2022-01-08 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2091843 | 2091843 | 2022-01-07 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2088591 | 2088591 | 2022-01-06 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2085340 | 2085340 | 2022-01-05 | Tillman | Oklahoma | 40141 | 1102 | 29 |
2080438 | 2080438 | 2022-01-04 | Caribou | Idaho | 16029 | 1102 | 24 |
2056221 | 2056221 | 2021-12-27 | Florida | Puerto Rico | 72054 | 1102 | |
2038966 | 2038966 | 2021-12-22 | Grant | Minnesota | 27051 | 1102 | 12 |
2035716 | 2035716 | 2021-12-21 | Grant | Minnesota | 27051 | 1102 | 12 |
2014129 | 2014129 | 2021-12-14 | Spink | South Dakota | 46115 | 1102 | 29 |
2008102 | 2008102 | 2021-12-12 | Lancaster | Virginia | 51103 | 1102 | 24 |
2004851 | 2004851 | 2021-12-11 | Lancaster | Virginia | 51103 | 1102 | 24 |
2001600 | 2001600 | 2021-12-10 | Lancaster | Virginia | 51103 | 1102 | 24 |
1994456 | 1994456 | 2021-12-08 | Ciales | Puerto Rico | 72039 | 1102 | |
1975568 | 1975568 | 2021-12-02 | Fairfax city | Virginia | 51600 | 1102 | 35 |
1972319 | 1972319 | 2021-12-01 | Fairfax city | Virginia | 51600 | 1102 | 35 |
1932991 | 1932991 | 2021-11-19 | Brewster | Texas | 48043 | 1102 | 22 |
1928611 | 1928611 | 2021-11-18 | Chariton | Missouri | 29041 | 1102 | 30 |
1929740 | 1929740 | 2021-11-18 | Brewster | Texas | 48043 | 1102 | 22 |
1924376 | 1924376 | 2021-11-17 | Twiggs | Georgia | 13289 | 1102 | 62 |
1926490 | 1926490 | 2021-11-17 | Brewster | Texas | 48043 | 1102 | 22 |
1921127 | 1921127 | 2021-11-16 | Twiggs | Georgia | 13289 | 1102 | 62 |
1922287 | 1922287 | 2021-11-16 | Dawes | Nebraska | 31045 | 1102 | 21 |
1923191 | 1923191 | 2021-11-16 | Pickett | Tennessee | 47137 | 1102 | 24 |
1923240 | 1923240 | 2021-11-16 | Brewster | Texas | 48043 | 1102 | 22 |
1919991 | 1919991 | 2021-11-15 | Brewster | Texas | 48043 | 1102 | 22 |
1916741 | 1916741 | 2021-11-14 | Brewster | Texas | 48043 | 1102 | 22 |
1913491 | 1913491 | 2021-11-13 | Brewster | Texas | 48043 | 1102 | 22 |
1906992 | 1906992 | 2021-11-11 | Brewster | Texas | 48043 | 1102 | 22 |
1899386 | 1899386 | 2021-11-09 | Hickory | Missouri | 29085 | 1102 | 21 |
1896136 | 1896136 | 2021-11-08 | Hickory | Missouri | 29085 | 1102 | 21 |
1892886 | 1892886 | 2021-11-07 | Hickory | Missouri | 29085 | 1102 | 21 |
1893077 | 1893077 | 2021-11-07 | Merrick | Nebraska | 31121 | 1102 | 15 |
1889636 | 1889636 | 2021-11-06 | Hickory | Missouri | 29085 | 1102 | 21 |
1889827 | 1889827 | 2021-11-06 | Merrick | Nebraska | 31121 | 1102 | 15 |
1886386 | 1886386 | 2021-11-05 | Hickory | Missouri | 29085 | 1102 | 21 |
1886577 | 1886577 | 2021-11-05 | Merrick | Nebraska | 31121 | 1102 | 15 |
1883328 | 1883328 | 2021-11-04 | Merrick | Nebraska | 31121 | 1102 | 15 |
1880079 | 1880079 | 2021-11-03 | Merrick | Nebraska | 31121 | 1102 | 15 |
1856390 | 1856390 | 2021-10-27 | Union | Indiana | 18161 | 1102 | 17 |
1853041 | 1853041 | 2021-10-26 | Schuyler | Illinois | 17169 | 1102 | 22 |
1853141 | 1853141 | 2021-10-26 | Union | Indiana | 18161 | 1102 | 17 |
1840933 | 1840933 | 2021-10-22 | Ozark | Missouri | 29153 | 1102 | 30 |
1827899 | 1827899 | 2021-10-18 | Harrison | Missouri | 29081 | 1102 | 17 |
1828602 | 1828602 | 2021-10-18 | Harney | Oregon | 41025 | 1102 | 25 |
1824650 | 1824650 | 2021-10-17 | Harrison | Missouri | 29081 | 1102 | 17 |
1821401 | 1821401 | 2021-10-16 | Harrison | Missouri | 29081 | 1102 | 17 |
1819750 | 1819750 | 2021-10-15 | Pocahontas | West Virginia | 54075 | 1102 | 18 |
1780957 | 1780957 | 2021-10-04 | Nome Census Area | Alaska | 2180 | 1102 | 0 |
1777712 | 1777712 | 2021-10-03 | Sitka City and Borough | Alaska | 2220 | 1102 | 4 |
1779312 | 1779312 | 2021-10-03 | Cheyenne | Nebraska | 31033 | 1102 | 19 |
1779340 | 1779340 | 2021-10-03 | Holt | Nebraska | 31089 | 1102 | 16 |
1774462 | 1774462 | 2021-10-02 | Sitka City and Borough | Alaska | 2220 | 1102 | 4 |
1776062 | 1776062 | 2021-10-02 | Cheyenne | Nebraska | 31033 | 1102 | 19 |
1776090 | 1776090 | 2021-10-02 | Holt | Nebraska | 31089 | 1102 | 16 |
1776415 | 1776415 | 2021-10-02 | Pembina | North Dakota | 38067 | 1102 | 11 |
1771212 | 1771212 | 2021-10-01 | Sitka City and Borough | Alaska | 2220 | 1102 | 4 |
1772812 | 1772812 | 2021-10-01 | Cheyenne | Nebraska | 31033 | 1102 | 19 |
1772840 | 1772840 | 2021-10-01 | Holt | Nebraska | 31089 | 1102 | 16 |
1768989 | 1768989 | 2021-09-30 | Trimble | Kentucky | 21223 | 1102 | 9 |
1764786 | 1764786 | 2021-09-29 | Montgomery | Arkansas | 5097 | 1102 | 39 |
1765740 | 1765740 | 2021-09-29 | Trimble | Kentucky | 21223 | 1102 | 9 |
1765998 | 1765998 | 2021-09-29 | Marshall | Minnesota | 27089 | 1102 | 19 |
1763037 | 1763037 | 2021-09-28 | Sanders | Montana | 30089 | 1102 | 16 |
1757797 | 1757797 | 2021-09-26 | Lamoille | Vermont | 50015 | 1102 | 4 |
1757895 | 1757895 | 2021-09-26 | Northumberland | Virginia | 51133 | 1102 | 25 |
1754647 | 1754647 | 2021-09-25 | Northumberland | Virginia | 51133 | 1102 | 25 |
1751399 | 1751399 | 2021-09-24 | Northumberland | Virginia | 51133 | 1102 | 25 |
1742188 | 1742188 | 2021-09-22 | San Miguel | Colorado | 8113 | 1102 | 3 |
1732598 | 1732598 | 2021-09-19 | Hancock | Georgia | 13141 | 1102 | 72 |
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);