ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
272 rows where cases = 2376 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 20
- Texas 20
- Michigan 16
- Kansas 14
- Minnesota 14
- Alabama 12
- Puerto Rico 12
- Missouri 11
- Virginia 10
- Florida 8
- Kentucky 8
- Alaska 7
- Idaho 7
- Indiana 7
- Louisiana 7
- North Carolina 7
- South Dakota 7
- Tennessee 7
- Arkansas 6
- Mississippi 6
- Ohio 6
- Wisconsin 6
- Pennsylvania 5
- South Carolina 5
- West Virginia 5
- California 4
- New York 4
- Oregon 4
- Illinois 3
- Maryland 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466112 | 2466112 | 2022-05-02 | Guayanilla | Puerto Rico | 72059 | 2376 | |
2462886 | 2462886 | 2022-05-01 | Rincon | Puerto Rico | 72117 | 2376 | |
2428922 | 2428922 | 2022-04-21 | Thomas | Kansas | 20193 | 2376 | 28 |
2425666 | 2425666 | 2022-04-20 | Thomas | Kansas | 20193 | 2376 | 28 |
2422410 | 2422410 | 2022-04-19 | Thomas | Kansas | 20193 | 2376 | 28 |
2419154 | 2419154 | 2022-04-18 | Thomas | Kansas | 20193 | 2376 | 28 |
2415898 | 2415898 | 2022-04-17 | Thomas | Kansas | 20193 | 2376 | 28 |
2412642 | 2412642 | 2022-04-16 | Thomas | Kansas | 20193 | 2376 | 28 |
2409386 | 2409386 | 2022-04-15 | Thomas | Kansas | 20193 | 2376 | 28 |
2405572 | 2405572 | 2022-04-14 | Dooly | Georgia | 13093 | 2376 | 68 |
2402317 | 2402317 | 2022-04-13 | Dooly | Georgia | 13093 | 2376 | 68 |
2301550 | 2301550 | 2022-03-13 | Towns | Georgia | 13281 | 2376 | 105 |
2298298 | 2298298 | 2022-03-12 | Towns | Georgia | 13281 | 2376 | 105 |
2295046 | 2295046 | 2022-03-11 | Towns | Georgia | 13281 | 2376 | 105 |
2291794 | 2291794 | 2022-03-10 | Towns | Georgia | 13281 | 2376 | 104 |
2288542 | 2288542 | 2022-03-09 | Towns | Georgia | 13281 | 2376 | 104 |
2257030 | 2257030 | 2022-02-27 | Grundy | Missouri | 29079 | 2376 | 64 |
2253779 | 2253779 | 2022-02-26 | Grundy | Missouri | 29079 | 2376 | 64 |
2250528 | 2250528 | 2022-02-25 | Grundy | Missouri | 29079 | 2376 | 64 |
2226033 | 2226033 | 2022-02-17 | Sussex | Virginia | 51183 | 2376 | 37 |
2175851 | 2175851 | 2022-02-02 | Richland | Montana | 30083 | 2376 | 30 |
2172473 | 2172473 | 2022-02-01 | Douglas | Missouri | 29067 | 2376 | 69 |
2133306 | 2133306 | 2022-01-20 | Watonwan | Minnesota | 27165 | 2376 | 22 |
2131166 | 2131166 | 2022-01-19 | Todd | South Dakota | 46121 | 2376 | 41 |
2126688 | 2126688 | 2022-01-18 | Missaukee | Michigan | 26113 | 2376 | 54 |
2123436 | 2123436 | 2022-01-17 | Missaukee | Michigan | 26113 | 2376 | 54 |
2120184 | 2120184 | 2022-01-16 | Missaukee | Michigan | 26113 | 2376 | 54 |
2116932 | 2116932 | 2022-01-15 | Missaukee | Michigan | 26113 | 2376 | 54 |
2113681 | 2113681 | 2022-01-14 | Missaukee | Michigan | 26113 | 2376 | 54 |
2096276 | 2096276 | 2022-01-09 | Little River | Arkansas | 5081 | 2376 | 85 |
2098368 | 2098368 | 2022-01-09 | Hood River | Oregon | 41027 | 2376 | 38 |
2093024 | 2093024 | 2022-01-08 | Little River | Arkansas | 5081 | 2376 | 85 |
2095116 | 2095116 | 2022-01-08 | Hood River | Oregon | 41027 | 2376 | 38 |
2091864 | 2091864 | 2022-01-07 | Hood River | Oregon | 41027 | 2376 | 38 |
2083195 | 2083195 | 2022-01-05 | Ketchikan Gateway Borough | Alaska | 2130 | 2376 | 13 |
2079943 | 2079943 | 2022-01-04 | Ketchikan Gateway Borough | Alaska | 2130 | 2376 | 13 |
2081104 | 2081104 | 2022-01-04 | Nantucket | Massachusetts | 25019 | 2376 | 0 |
2076691 | 2076691 | 2022-01-03 | Ketchikan Gateway Borough | Alaska | 2130 | 2376 | 13 |
2077083 | 2077083 | 2022-01-03 | Jasper | Georgia | 13159 | 2376 | 60 |
2073832 | 2073832 | 2022-01-02 | Jasper | Georgia | 13159 | 2376 | 60 |
2070581 | 2070581 | 2022-01-01 | Jasper | Georgia | 13159 | 2376 | 60 |
2067330 | 2067330 | 2021-12-31 | Jasper | Georgia | 13159 | 2376 | 60 |
2031695 | 2031695 | 2021-12-20 | Idaho | Idaho | 16049 | 2376 | 39 |
2007583 | 2007583 | 2021-12-12 | Clay | South Dakota | 46027 | 2376 | 17 |
2008086 | 2008086 | 2021-12-12 | Grayson | Virginia | 51077 | 2376 | 54 |
2004332 | 2004332 | 2021-12-11 | Clay | South Dakota | 46027 | 2376 | 17 |
2004835 | 2004835 | 2021-12-11 | Grayson | Virginia | 51077 | 2376 | 54 |
2001081 | 2001081 | 2021-12-10 | Clay | South Dakota | 46027 | 2376 | 17 |
2001584 | 2001584 | 2021-12-10 | Grayson | Virginia | 51077 | 2376 | 54 |
1992684 | 1992684 | 2021-12-08 | Gooding | Idaho | 16047 | 2376 | 43 |
1991746 | 1991746 | 2021-12-07 | Millard | Utah | 49027 | 2376 | 30 |
1988413 | 1988413 | 2021-12-06 | Pecos | Texas | 48371 | 2376 | 57 |
1975274 | 1975274 | 2021-12-02 | Comanche | Texas | 48093 | 2376 | 66 |
1967726 | 1967726 | 2021-11-30 | Custer | Montana | 30017 | 2376 | 39 |
1949806 | 1949806 | 2021-11-24 | Rusk | Wisconsin | 55107 | 2376 | 36 |
1943206 | 1943206 | 2021-11-22 | Grant | West Virginia | 54023 | 2376 | 36 |
1928477 | 1928477 | 2021-11-18 | Pennington | Minnesota | 27113 | 2376 | 29 |
1905905 | 1905905 | 2021-11-11 | Madison | Missouri | 29123 | 2376 | 27 |
1906325 | 1906325 | 2021-11-11 | Polk | North Carolina | 37149 | 2376 | 48 |
1902656 | 1902656 | 2021-11-10 | Madison | Missouri | 29123 | 2376 | 27 |
1903076 | 1903076 | 2021-11-10 | Polk | North Carolina | 37149 | 2376 | 48 |
1892409 | 1892409 | 2021-11-07 | Larue | Kentucky | 21123 | 2376 | 51 |
1889159 | 1889159 | 2021-11-06 | Larue | Kentucky | 21123 | 2376 | 51 |
1885909 | 1885909 | 2021-11-05 | Larue | Kentucky | 21123 | 2376 | 51 |
1878264 | 1878264 | 2021-11-02 | Crawford | Wisconsin | 55023 | 2376 | 22 |
1852965 | 1852965 | 2021-10-26 | Carroll | Illinois | 17015 | 2376 | 39 |
1848867 | 1848867 | 2021-10-24 | New Kent | Virginia | 51127 | 2376 | 22 |
1845617 | 1845617 | 2021-10-23 | New Kent | Virginia | 51127 | 2376 | 22 |
1842367 | 1842367 | 2021-10-22 | New Kent | Virginia | 51127 | 2376 | 22 |
1831995 | 1831995 | 2021-10-19 | Naranjito | Puerto Rico | 72105 | 2376 | |
1828746 | 1828746 | 2021-10-18 | Naranjito | Puerto Rico | 72105 | 2376 | |
1825497 | 1825497 | 2021-10-17 | Naranjito | Puerto Rico | 72105 | 2376 | |
1822248 | 1822248 | 2021-10-16 | Naranjito | Puerto Rico | 72105 | 2376 | |
1803630 | 1803630 | 2021-10-11 | Clay | Alabama | 1027 | 2376 | 67 |
1787663 | 1787663 | 2021-10-06 | Otero | Colorado | 8089 | 2376 | 76 |
1786037 | 1786037 | 2021-10-05 | Bertie | North Carolina | 37015 | 2376 | 49 |
1770645 | 1770645 | 2021-09-30 | Leon | Texas | 48289 | 2376 | 60 |
1723352 | 1723352 | 2021-09-16 | Neosho | Kansas | 20133 | 2376 | 43 |
1724771 | 1724771 | 2021-09-16 | Moca | Puerto Rico | 72099 | 2376 | |
1720103 | 1720103 | 2021-09-15 | Neosho | Kansas | 20133 | 2376 | 43 |
1711753 | 1711753 | 2021-09-12 | Corozal | Puerto Rico | 72047 | 2376 | |
1695525 | 1695525 | 2021-09-07 | Isabela | Puerto Rico | 72071 | 2376 | |
1689985 | 1689985 | 2021-09-06 | Juneau City and Borough | Alaska | 2110 | 2376 | 3 |
1691094 | 1691094 | 2021-09-06 | Winn | Louisiana | 22127 | 2376 | 52 |
1686735 | 1686735 | 2021-09-05 | Juneau City and Borough | Alaska | 2110 | 2376 | 3 |
1687844 | 1687844 | 2021-09-05 | Winn | Louisiana | 22127 | 2376 | 52 |
1683485 | 1683485 | 2021-09-04 | Juneau City and Borough | Alaska | 2110 | 2376 | 3 |
1684594 | 1684594 | 2021-09-04 | Winn | Louisiana | 22127 | 2376 | 52 |
1680234 | 1680234 | 2021-09-03 | Juneau City and Borough | Alaska | 2110 | 2376 | 3 |
1681343 | 1681343 | 2021-09-03 | Winn | Louisiana | 22127 | 2376 | 52 |
1677245 | 1677245 | 2021-09-02 | Dixie | Florida | 12029 | 2376 | 24 |
1673998 | 1673998 | 2021-09-01 | Dixie | Florida | 12029 | 2376 | 24 |
1676059 | 1676059 | 2021-09-01 | San Sebastian | Puerto Rico | 72131 | 2376 | |
1670750 | 1670750 | 2021-08-31 | Dixie | Florida | 12029 | 2376 | 24 |
1671711 | 1671711 | 2021-08-31 | Menominee | Michigan | 26109 | 2376 | 44 |
1667454 | 1667454 | 2021-08-30 | Montezuma | Colorado | 8083 | 2376 | 29 |
1667503 | 1667503 | 2021-08-30 | Dixie | Florida | 12029 | 2376 | 24 |
1668464 | 1668464 | 2021-08-30 | Menominee | Michigan | 26109 | 2376 | 44 |
1664256 | 1664256 | 2021-08-29 | Dixie | Florida | 12029 | 2376 | 24 |
1661008 | 1661008 | 2021-08-28 | Dixie | Florida | 12029 | 2376 | 24 |
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);