ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
573 rows where cases = 668 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 48
- Texas 44
- Kansas 40
- North Carolina 28
- Puerto Rico 28
- Kentucky 26
- Missouri 23
- Nebraska 22
- Alabama 18
- Arkansas 18
- Virginia 18
- Georgia 17
- Illinois 17
- Michigan 17
- South Dakota 17
- Indiana 15
- Idaho 12
- North Dakota 12
- Alaska 11
- California 11
- Oklahoma 11
- Colorado 10
- West Virginia 10
- Mississippi 9
- Tennessee 9
- Louisiana 8
- Wisconsin 8
- Minnesota 6
- New Mexico 6
- Pennsylvania 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337749 | 2337749 | 2022-03-24 | Kiowa | Kansas | 20097 | 668 | 7 |
2334495 | 2334495 | 2022-03-23 | Kiowa | Kansas | 20097 | 668 | 7 |
2331241 | 2331241 | 2022-03-22 | Kiowa | Kansas | 20097 | 668 | 7 |
2327989 | 2327989 | 2022-03-21 | Kiowa | Kansas | 20097 | 668 | 7 |
2324736 | 2324736 | 2022-03-20 | Kiowa | Kansas | 20097 | 668 | 7 |
2321482 | 2321482 | 2022-03-19 | Kiowa | Kansas | 20097 | 668 | 7 |
2318228 | 2318228 | 2022-03-18 | Kiowa | Kansas | 20097 | 668 | 7 |
2314975 | 2314975 | 2022-03-17 | Kiowa | Kansas | 20097 | 668 | 7 |
2311722 | 2311722 | 2022-03-16 | Kiowa | Kansas | 20097 | 668 | 7 |
2308469 | 2308469 | 2022-03-15 | Kiowa | Kansas | 20097 | 668 | 7 |
2305218 | 2305218 | 2022-03-14 | Kiowa | Kansas | 20097 | 668 | 7 |
2301966 | 2301966 | 2022-03-13 | Kiowa | Kansas | 20097 | 668 | 7 |
2298714 | 2298714 | 2022-03-12 | Kiowa | Kansas | 20097 | 668 | 7 |
2295462 | 2295462 | 2022-03-11 | Kiowa | Kansas | 20097 | 668 | 7 |
2292210 | 2292210 | 2022-03-10 | Kiowa | Kansas | 20097 | 668 | 7 |
2288958 | 2288958 | 2022-03-09 | Kiowa | Kansas | 20097 | 668 | 7 |
2284345 | 2284345 | 2022-03-07 | Shackelford | Texas | 48417 | 668 | 12 |
2281093 | 2281093 | 2022-03-06 | Shackelford | Texas | 48417 | 668 | 12 |
2277840 | 2277840 | 2022-03-05 | Shackelford | Texas | 48417 | 668 | 12 |
2241998 | 2241998 | 2022-02-22 | Kimble | Texas | 48267 | 668 | 14 |
2214890 | 2214890 | 2022-02-14 | Sheridan | Montana | 30091 | 668 | 11 |
2188177 | 2188177 | 2022-02-06 | Rawlins | Kansas | 20153 | 668 | 10 |
2184924 | 2184924 | 2022-02-05 | Rawlins | Kansas | 20153 | 668 | 10 |
2181672 | 2181672 | 2022-02-04 | Rawlins | Kansas | 20153 | 668 | 10 |
2166188 | 2166188 | 2022-01-30 | Stanton | Nebraska | 31167 | 668 | 11 |
2162933 | 2162933 | 2022-01-29 | Stanton | Nebraska | 31167 | 668 | 11 |
2159678 | 2159678 | 2022-01-28 | Stanton | Nebraska | 31167 | 668 | 11 |
2134361 | 2134361 | 2022-01-20 | Bennett | South Dakota | 46007 | 668 | 9 |
2125981 | 2125981 | 2022-01-18 | Oneida | Idaho | 16071 | 668 | 10 |
2124601 | 2124601 | 2022-01-17 | Aurora | South Dakota | 46003 | 668 | 17 |
2121349 | 2121349 | 2022-01-16 | Aurora | South Dakota | 46003 | 668 | 17 |
2121522 | 2121522 | 2022-01-16 | Baylor | Texas | 48023 | 668 | 26 |
2118097 | 2118097 | 2022-01-15 | Aurora | South Dakota | 46003 | 668 | 17 |
2118270 | 2118270 | 2022-01-15 | Baylor | Texas | 48023 | 668 | 25 |
2118476 | 2118476 | 2022-01-15 | Sutton | Texas | 48435 | 668 | 11 |
2114846 | 2114846 | 2022-01-14 | Aurora | South Dakota | 46003 | 668 | 17 |
2101061 | 2101061 | 2022-01-10 | Chase | Nebraska | 31029 | 668 | 6 |
2101370 | 2101370 | 2022-01-10 | Tyrrell | North Carolina | 37177 | 668 | 7 |
2097300 | 2097300 | 2022-01-09 | Tensas | Louisiana | 22107 | 668 | 10 |
2094048 | 2094048 | 2022-01-08 | Tensas | Louisiana | 22107 | 668 | 10 |
2089738 | 2089738 | 2022-01-07 | Calhoun | Arkansas | 5013 | 668 | 9 |
2090796 | 2090796 | 2022-01-07 | Tensas | Louisiana | 22107 | 668 | 10 |
2092438 | 2092438 | 2022-01-07 | Reagan | Texas | 48383 | 668 | 11 |
2017549 | 2017549 | 2021-12-15 | Donley | Texas | 48129 | 668 | 18 |
2001291 | 2001291 | 2021-12-10 | Delta | Texas | 48119 | 668 | 22 |
2001334 | 2001334 | 2021-12-10 | Haskell | Texas | 48207 | 668 | 35 |
1990864 | 1990864 | 2021-12-07 | Bowman | North Dakota | 38011 | 668 | 8 |
1987613 | 1987613 | 2021-12-06 | Bowman | North Dakota | 38011 | 668 | 8 |
1984363 | 1984363 | 2021-12-05 | Bowman | North Dakota | 38011 | 668 | 8 |
1984837 | 1984837 | 2021-12-05 | Edmunds | South Dakota | 46045 | 668 | 14 |
1981113 | 1981113 | 2021-12-04 | Bowman | North Dakota | 38011 | 668 | 8 |
1981587 | 1981587 | 2021-12-04 | Edmunds | South Dakota | 46045 | 668 | 14 |
1978337 | 1978337 | 2021-12-03 | Edmunds | South Dakota | 46045 | 668 | 14 |
1975087 | 1975087 | 2021-12-02 | Edmunds | South Dakota | 46045 | 668 | 14 |
1965847 | 1965847 | 2021-11-29 | King and Queen | Virginia | 51097 | 668 | 9 |
1937866 | 1937866 | 2021-11-21 | Carlisle | Kentucky | 21039 | 668 | 12 |
1934616 | 1934616 | 2021-11-20 | Carlisle | Kentucky | 21039 | 668 | 12 |
1931365 | 1931365 | 2021-11-19 | Carlisle | Kentucky | 21039 | 668 | 12 |
1928828 | 1928828 | 2021-11-18 | Nuckolls | Nebraska | 31129 | 668 | 12 |
1925889 | 1925889 | 2021-11-17 | Sargent | North Dakota | 38081 | 668 | 8 |
1921583 | 1921583 | 2021-11-16 | Stafford | Kansas | 20185 | 668 | 17 |
1918333 | 1918333 | 2021-11-15 | Stafford | Kansas | 20185 | 668 | 17 |
1918706 | 1918706 | 2021-11-15 | Kittson | Minnesota | 27069 | 668 | 22 |
1899620 | 1899620 | 2021-11-09 | Lincoln | Nevada | 32017 | 668 | 5 |
1887197 | 1887197 | 2021-11-05 | Ceiba | Puerto Rico | 72037 | 668 | |
1882110 | 1882110 | 2021-11-04 | Schley | Georgia | 13249 | 668 | 7 |
1883947 | 1883947 | 2021-11-04 | Ceiba | Puerto Rico | 72037 | 668 | |
1880698 | 1880698 | 2021-11-03 | Ceiba | Puerto Rico | 72037 | 668 | |
1860882 | 1860882 | 2021-10-28 | LaMoure | North Dakota | 38045 | 668 | 17 |
1861331 | 1861331 | 2021-10-28 | Corson | South Dakota | 46031 | 668 | 13 |
1853157 | 1853157 | 2021-10-26 | Audubon | Iowa | 19009 | 668 | 14 |
1849908 | 1849908 | 2021-10-25 | Audubon | Iowa | 19009 | 668 | 14 |
1846658 | 1846658 | 2021-10-24 | Audubon | Iowa | 19009 | 668 | 14 |
1843408 | 1843408 | 2021-10-23 | Audubon | Iowa | 19009 | 668 | 14 |
1840158 | 1840158 | 2021-10-22 | Audubon | Iowa | 19009 | 668 | 14 |
1836909 | 1836909 | 2021-10-21 | Audubon | Iowa | 19009 | 668 | 14 |
1833660 | 1833660 | 2021-10-20 | Audubon | Iowa | 19009 | 668 | 14 |
1830486 | 1830486 | 2021-10-19 | Ringgold | Iowa | 19159 | 668 | 27 |
1830566 | 1830566 | 2021-10-19 | Meade | Kansas | 20119 | 668 | 14 |
1830615 | 1830615 | 2021-10-19 | Ballard | Kentucky | 21007 | 668 | 19 |
1827237 | 1827237 | 2021-10-18 | Ringgold | Iowa | 19159 | 668 | 27 |
1827317 | 1827317 | 2021-10-18 | Meade | Kansas | 20119 | 668 | 14 |
1823988 | 1823988 | 2021-10-17 | Ringgold | Iowa | 19159 | 668 | 27 |
1820739 | 1820739 | 2021-10-16 | Ringgold | Iowa | 19159 | 668 | 27 |
1817490 | 1817490 | 2021-10-15 | Ringgold | Iowa | 19159 | 668 | 27 |
1814242 | 1814242 | 2021-10-14 | Ringgold | Iowa | 19159 | 668 | 27 |
1815625 | 1815625 | 2021-10-14 | Wallowa | Oregon | 41063 | 668 | 12 |
1810993 | 1810993 | 2021-10-13 | Ringgold | Iowa | 19159 | 668 | 27 |
1812449 | 1812449 | 2021-10-13 | Adjuntas | Puerto Rico | 72001 | 668 | |
1809200 | 1809200 | 2021-10-12 | Adjuntas | Puerto Rico | 72001 | 668 | |
1805950 | 1805950 | 2021-10-11 | Adjuntas | Puerto Rico | 72001 | 668 | |
1785442 | 1785442 | 2021-10-05 | Schoolcraft | Michigan | 26153 | 668 | 5 |
1785875 | 1785875 | 2021-10-05 | Sheridan | Nebraska | 31161 | 668 | 23 |
1782193 | 1782193 | 2021-10-04 | Schoolcraft | Michigan | 26153 | 668 | 5 |
1779455 | 1779455 | 2021-10-03 | Los Alamos | New Mexico | 35028 | 668 | 9 |
1776205 | 1776205 | 2021-10-02 | Los Alamos | New Mexico | 35028 | 668 | 9 |
1772955 | 1772955 | 2021-10-01 | Los Alamos | New Mexico | 35028 | 668 | 9 |
1758767 | 1758767 | 2021-09-27 | Henderson | Illinois | 17071 | 668 | 23 |
1742474 | 1742474 | 2021-09-22 | Lewis | Idaho | 16061 | 668 | 15 |
1738848 | 1738848 | 2021-09-21 | Modoc | California | 6049 | 668 | 8 |
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);