ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
313 rows where cases = 1724 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 23
- Texas 19
- Mississippi 17
- Kentucky 16
- Georgia 15
- Illinois 14
- Missouri 14
- Virginia 14
- Iowa 13
- Wisconsin 13
- Minnesota 12
- Arkansas 11
- Florida 11
- Michigan 10
- Alabama 9
- Nebraska 8
- North Carolina 8
- Puerto Rico 8
- Idaho 7
- Kansas 7
- Ohio 7
- South Dakota 7
- Colorado 6
- Louisiana 5
- North Dakota 5
- Tennessee 5
- New York 4
- West Virginia 4
- Alaska 3
- California 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441630 | 2441630 | 2022-04-25 | Pulaski | Illinois | 17153 | 1724 | 19 |
2438374 | 2438374 | 2022-04-24 | Pulaski | Illinois | 17153 | 1724 | 19 |
2435118 | 2435118 | 2022-04-23 | Pulaski | Illinois | 17153 | 1724 | 19 |
2431862 | 2431862 | 2022-04-22 | Pulaski | Illinois | 17153 | 1724 | 19 |
2428606 | 2428606 | 2022-04-21 | Pulaski | Illinois | 17153 | 1724 | 19 |
2425350 | 2425350 | 2022-04-20 | Pulaski | Illinois | 17153 | 1724 | 19 |
2422094 | 2422094 | 2022-04-19 | Pulaski | Illinois | 17153 | 1724 | 19 |
2399872 | 2399872 | 2022-04-12 | Alcona | Michigan | 26001 | 1724 | 71 |
2396616 | 2396616 | 2022-04-11 | Alcona | Michigan | 26001 | 1724 | 71 |
2393361 | 2393361 | 2022-04-10 | Alcona | Michigan | 26001 | 1724 | 71 |
2390105 | 2390105 | 2022-04-09 | Alcona | Michigan | 26001 | 1724 | 71 |
2386849 | 2386849 | 2022-04-08 | Alcona | Michigan | 26001 | 1724 | 71 |
2383594 | 2383594 | 2022-04-07 | Alcona | Michigan | 26001 | 1724 | 71 |
2380339 | 2380339 | 2022-04-06 | Alcona | Michigan | 26001 | 1724 | 71 |
2346819 | 2346819 | 2022-03-27 | Conejos | Colorado | 8021 | 1724 | 54 |
2343566 | 2343566 | 2022-03-26 | Conejos | Colorado | 8021 | 1724 | 54 |
2340313 | 2340313 | 2022-03-25 | Conejos | Colorado | 8021 | 1724 | 54 |
2279621 | 2279621 | 2022-03-06 | Lac qui Parle | Minnesota | 27073 | 1724 | 28 |
2280755 | 2280755 | 2022-03-06 | Hutchinson | South Dakota | 46067 | 1724 | 36 |
2276368 | 2276368 | 2022-03-05 | Lac qui Parle | Minnesota | 27073 | 1724 | 28 |
2277502 | 2277502 | 2022-03-05 | Hutchinson | South Dakota | 46067 | 1724 | 36 |
2273115 | 2273115 | 2022-03-04 | Lac qui Parle | Minnesota | 27073 | 1724 | 28 |
2274249 | 2274249 | 2022-03-04 | Hutchinson | South Dakota | 46067 | 1724 | 36 |
2269863 | 2269863 | 2022-03-03 | Lac qui Parle | Minnesota | 27073 | 1724 | 28 |
2245870 | 2245870 | 2022-02-24 | Dallas | Arkansas | 5039 | 1724 | 27 |
2174474 | 2174474 | 2022-02-02 | Lake | Colorado | 8065 | 1724 | 2 |
2166116 | 2166116 | 2022-01-30 | Butler | Nebraska | 31023 | 1724 | 12 |
2167145 | 2167145 | 2022-01-30 | Gaines | Texas | 48165 | 1724 | 75 |
2162861 | 2162861 | 2022-01-29 | Butler | Nebraska | 31023 | 1724 | 12 |
2159606 | 2159606 | 2022-01-28 | Butler | Nebraska | 31023 | 1724 | 12 |
2157640 | 2157640 | 2022-01-27 | Falls Church city | Virginia | 51610 | 1724 | 14 |
2147915 | 2147915 | 2022-01-24 | Lunenburg | Virginia | 51111 | 1724 | 24 |
2133582 | 2133582 | 2022-01-20 | Cheyenne | Nebraska | 31033 | 1724 | 21 |
2101736 | 2101736 | 2022-01-10 | Florida | Puerto Rico | 72054 | 1724 | |
2094415 | 2094415 | 2022-01-08 | Howard | Missouri | 29089 | 1724 | 19 |
2079870 | 2079870 | 2022-01-04 | Bullock | Alabama | 1011 | 1724 | 46 |
2080913 | 2080913 | 2022-01-04 | Hancock | Kentucky | 21091 | 1724 | 19 |
2028350 | 2028350 | 2021-12-19 | McIntosh | Georgia | 13191 | 1724 | 33 |
2025099 | 2025099 | 2021-12-18 | McIntosh | Georgia | 13191 | 1724 | 33 |
2021848 | 2021848 | 2021-12-17 | McIntosh | Georgia | 13191 | 1724 | 33 |
2018597 | 2018597 | 2021-12-16 | McIntosh | Georgia | 13191 | 1724 | 33 |
2015347 | 2015347 | 2021-12-15 | McIntosh | Georgia | 13191 | 1724 | 33 |
2012096 | 2012096 | 2021-12-14 | McIntosh | Georgia | 13191 | 1724 | 33 |
2008845 | 2008845 | 2021-12-13 | McIntosh | Georgia | 13191 | 1724 | 33 |
2005674 | 2005674 | 2021-12-12 | Boundary | Idaho | 16021 | 1724 | 48 |
2002423 | 2002423 | 2021-12-11 | Boundary | Idaho | 16021 | 1724 | 48 |
1999173 | 1999173 | 2021-12-10 | Boundary | Idaho | 16021 | 1724 | 48 |
2001492 | 2001492 | 2021-12-10 | Emery | Utah | 49015 | 1724 | 24 |
1997857 | 1997857 | 2021-12-09 | Lake | South Dakota | 46079 | 1724 | 20 |
1994031 | 1994031 | 2021-12-08 | Clay | North Carolina | 37043 | 1724 | 38 |
1989845 | 1989845 | 2021-12-07 | Thomas | Kansas | 20193 | 1724 | 23 |
1986595 | 1986595 | 2021-12-06 | Thomas | Kansas | 20193 | 1724 | 23 |
1966701 | 1966701 | 2021-11-30 | Teton | Idaho | 16081 | 1724 | 7 |
1945637 | 1945637 | 2021-11-23 | Forest | Pennsylvania | 42053 | 1724 | 28 |
1943004 | 1943004 | 2021-11-22 | Addison | Vermont | 50001 | 1724 | 9 |
1938238 | 1938238 | 2021-11-21 | Rock | Minnesota | 27133 | 1724 | 28 |
1934988 | 1934988 | 2021-11-20 | Rock | Minnesota | 27133 | 1724 | 28 |
1931738 | 1931738 | 2021-11-19 | Rock | Minnesota | 27133 | 1724 | 28 |
1928516 | 1928516 | 2021-11-18 | Carroll | Mississippi | 28015 | 1724 | 41 |
1918667 | 1918667 | 2021-11-15 | Unknown | Michigan | 1724 | 18 | |
1914997 | 1914997 | 2021-11-14 | Brown | Kansas | 20013 | 1724 | 41 |
1911747 | 1911747 | 2021-11-13 | Brown | Kansas | 20013 | 1724 | 41 |
1908498 | 1908498 | 2021-11-12 | Brown | Kansas | 20013 | 1724 | 41 |
1898011 | 1898011 | 2021-11-09 | Pike | Arkansas | 5109 | 1724 | 36 |
1898680 | 1898680 | 2021-11-09 | Grundy | Iowa | 19075 | 1724 | 37 |
1895430 | 1895430 | 2021-11-08 | Grundy | Iowa | 19075 | 1724 | 37 |
1892180 | 1892180 | 2021-11-07 | Grundy | Iowa | 19075 | 1724 | 37 |
1888930 | 1888930 | 2021-11-06 | Grundy | Iowa | 19075 | 1724 | 37 |
1884981 | 1884981 | 2021-11-05 | Fulton | Arkansas | 5049 | 1724 | 64 |
1885680 | 1885680 | 2021-11-05 | Grundy | Iowa | 19075 | 1724 | 37 |
1882431 | 1882431 | 2021-11-04 | Grundy | Iowa | 19075 | 1724 | 37 |
1878413 | 1878413 | 2021-11-03 | Wilcox | Alabama | 1131 | 1724 | 39 |
1879182 | 1879182 | 2021-11-03 | Grundy | Iowa | 19075 | 1724 | 37 |
1871928 | 1871928 | 2021-11-01 | Ketchikan Gateway Borough | Alaska | 2130 | 1724 | 9 |
1871941 | 1871941 | 2021-11-01 | Valdez-Cordova Census Area | Alaska | 2261 | 1724 | 7 |
1871074 | 1871074 | 2021-10-31 | Charles Mix | South Dakota | 46023 | 1724 | 26 |
1867825 | 1867825 | 2021-10-30 | Charles Mix | South Dakota | 46023 | 1724 | 26 |
1864576 | 1864576 | 2021-10-29 | Charles Mix | South Dakota | 46023 | 1724 | 26 |
1855689 | 1855689 | 2021-10-27 | Northwest Arctic Borough | Alaska | 2188 | 1724 | 7 |
1857053 | 1857053 | 2021-10-27 | Jefferson Davis | Mississippi | 28065 | 1724 | 43 |
1835890 | 1835890 | 2021-10-20 | Richmond | Virginia | 51159 | 1724 | 12 |
1803659 | 1803659 | 2021-10-11 | Lowndes | Alabama | 1085 | 1724 | 61 |
1800410 | 1800410 | 2021-10-10 | Lowndes | Alabama | 1085 | 1724 | 61 |
1796246 | 1796246 | 2021-10-08 | Loiza | Puerto Rico | 72087 | 1724 | |
1764645 | 1764645 | 2021-09-29 | Coosa | Alabama | 1037 | 1724 | 35 |
1756345 | 1756345 | 2021-09-26 | Montgomery | Mississippi | 28097 | 1724 | 54 |
1753097 | 1753097 | 2021-09-25 | Montgomery | Mississippi | 28097 | 1724 | 54 |
1749849 | 1749849 | 2021-09-24 | Montgomery | Mississippi | 28097 | 1724 | 54 |
1741796 | 1741796 | 2021-09-21 | Buffalo | Wisconsin | 55011 | 1724 | 7 |
1719759 | 1719759 | 2021-09-15 | Cumberland | Illinois | 17035 | 1724 | 35 |
1715623 | 1715623 | 2021-09-13 | Greene | Virginia | 51079 | 1724 | 24 |
1708268 | 1708268 | 2021-09-11 | Monroe | Ohio | 39111 | 1724 | 48 |
1696987 | 1696987 | 2021-09-08 | Idaho | Idaho | 16049 | 1724 | 20 |
1696376 | 1696376 | 2021-09-07 | Washburn | Wisconsin | 55129 | 1724 | 25 |
1690178 | 1690178 | 2021-09-06 | Grand | Colorado | 8049 | 1724 | 7 |
1690944 | 1690944 | 2021-09-06 | Fleming | Kentucky | 21069 | 1724 | 26 |
1693128 | 1693128 | 2021-09-06 | Washburn | Wisconsin | 55129 | 1724 | 25 |
1687694 | 1687694 | 2021-09-05 | Fleming | Kentucky | 21069 | 1724 | 26 |
1684444 | 1684444 | 2021-09-04 | Fleming | Kentucky | 21069 | 1724 | 26 |
1681193 | 1681193 | 2021-09-03 | Fleming | Kentucky | 21069 | 1724 | 26 |
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);