ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
497 rows where cases = 871 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 47
- Georgia 29
- Kentucky 29
- Virginia 29
- Arkansas 22
- Minnesota 20
- Missouri 20
- Puerto Rico 20
- Nebraska 17
- Iowa 15
- Illinois 14
- Indiana 14
- Idaho 13
- Kansas 13
- Montana 12
- Ohio 12
- Michigan 11
- North Carolina 11
- Oklahoma 11
- Tennessee 11
- West Virginia 11
- Wisconsin 10
- Louisiana 9
- Mississippi 9
- Wyoming 9
- Florida 8
- South Dakota 8
- New York 7
- North Dakota 6
- Washington 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500982 | 2500982 | 2022-05-13 | Traverse | Minnesota | 27155 | 871 | 10 |
2464065 | 2464065 | 2022-05-02 | Unknown | Delaware | 871 | 0 | |
2415960 | 2415960 | 2022-04-17 | Hickman | Kentucky | 21105 | 871 | 26 |
2412704 | 2412704 | 2022-04-16 | Hickman | Kentucky | 21105 | 871 | 26 |
2409448 | 2409448 | 2022-04-15 | Hickman | Kentucky | 21105 | 871 | 26 |
2406192 | 2406192 | 2022-04-14 | Hickman | Kentucky | 21105 | 871 | 26 |
2402936 | 2402936 | 2022-04-13 | Hickman | Kentucky | 21105 | 871 | 26 |
2404102 | 2404102 | 2022-04-13 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2399682 | 2399682 | 2022-04-12 | Hickman | Kentucky | 21105 | 871 | 26 |
2400847 | 2400847 | 2022-04-12 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2396426 | 2396426 | 2022-04-11 | Hickman | Kentucky | 21105 | 871 | 26 |
2397592 | 2397592 | 2022-04-11 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2394337 | 2394337 | 2022-04-10 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2391081 | 2391081 | 2022-04-09 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2387825 | 2387825 | 2022-04-08 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2384570 | 2384570 | 2022-04-07 | Roger Mills | Oklahoma | 40129 | 871 | 16 |
2371205 | 2371205 | 2022-04-03 | Hamilton | New York | 36041 | 871 | 5 |
2367952 | 2367952 | 2022-04-02 | Hamilton | New York | 36041 | 871 | 5 |
2364699 | 2364699 | 2022-04-01 | Hamilton | New York | 36041 | 871 | 5 |
2361445 | 2361445 | 2022-03-31 | Hamilton | New York | 36041 | 871 | 5 |
2358191 | 2358191 | 2022-03-30 | Hamilton | New York | 36041 | 871 | 5 |
2248678 | 2248678 | 2022-02-24 | Bath | Virginia | 51017 | 871 | 18 |
2245427 | 2245427 | 2022-02-23 | Bath | Virginia | 51017 | 871 | 18 |
2195430 | 2195430 | 2022-02-08 | Johnson | Nebraska | 31097 | 871 | 10 |
2170420 | 2170420 | 2022-01-31 | Haskell | Texas | 48207 | 871 | 37 |
2167326 | 2167326 | 2022-01-30 | Garfield | Utah | 49017 | 871 | 12 |
2164071 | 2164071 | 2022-01-29 | Garfield | Utah | 49017 | 871 | 12 |
2160816 | 2160816 | 2022-01-28 | Garfield | Utah | 49017 | 871 | 12 |
2153411 | 2153411 | 2022-01-26 | Tyrrell | North Carolina | 37177 | 871 | 7 |
2149787 | 2149787 | 2022-01-25 | Chouteau | Montana | 30015 | 871 | 12 |
2128347 | 2128347 | 2022-01-18 | Covington city | Virginia | 51580 | 871 | 20 |
2118323 | 2118323 | 2022-01-15 | Donley | Texas | 48129 | 871 | 20 |
2115210 | 2115210 | 2022-01-14 | San Augustine | Texas | 48405 | 871 | 38 |
2104382 | 2104382 | 2022-01-11 | Thayer | Nebraska | 31169 | 871 | 8 |
2101076 | 2101076 | 2022-01-10 | Fillmore | Nebraska | 31059 | 871 | 13 |
2096425 | 2096425 | 2022-01-09 | Saguache | Colorado | 8109 | 871 | 10 |
2096713 | 2096713 | 2022-01-09 | Lewis | Idaho | 16061 | 871 | 23 |
2093173 | 2093173 | 2022-01-08 | Saguache | Colorado | 8109 | 871 | 10 |
2093461 | 2093461 | 2022-01-08 | Lewis | Idaho | 16061 | 871 | 23 |
2094462 | 2094462 | 2022-01-08 | Reynolds | Missouri | 29179 | 871 | 17 |
2089921 | 2089921 | 2022-01-07 | Saguache | Colorado | 8109 | 871 | 10 |
2090209 | 2090209 | 2022-01-07 | Lewis | Idaho | 16061 | 871 | 23 |
2084123 | 2084123 | 2022-01-05 | Ballard | Kentucky | 21007 | 871 | 26 |
2081228 | 2081228 | 2022-01-04 | Kittson | Minnesota | 27069 | 871 | 25 |
2051249 | 2051249 | 2021-12-26 | Henderson | Illinois | 17071 | 871 | 24 |
2047999 | 2047999 | 2021-12-25 | Henderson | Illinois | 17071 | 871 | 24 |
2044749 | 2044749 | 2021-12-24 | Henderson | Illinois | 17071 | 871 | 24 |
2041500 | 2041500 | 2021-12-23 | Henderson | Illinois | 17071 | 871 | 24 |
2029558 | 2029558 | 2021-12-19 | Dixon | Nebraska | 31051 | 871 | 11 |
2026307 | 2026307 | 2021-12-18 | Dixon | Nebraska | 31051 | 871 | 11 |
2023056 | 2023056 | 2021-12-17 | Dixon | Nebraska | 31051 | 871 | 11 |
2019851 | 2019851 | 2021-12-16 | Polk | Nebraska | 31143 | 871 | 18 |
1983312 | 1983312 | 2021-12-05 | Morris | Kansas | 20127 | 871 | 22 |
1985422 | 1985422 | 2021-12-05 | Ferry | Washington | 53019 | 871 | 17 |
1980062 | 1980062 | 2021-12-04 | Morris | Kansas | 20127 | 871 | 22 |
1982172 | 1982172 | 2021-12-04 | Ferry | Washington | 53019 | 871 | 17 |
1976812 | 1976812 | 2021-12-03 | Morris | Kansas | 20127 | 871 | 22 |
1978644 | 1978644 | 2021-12-03 | Mills | Texas | 48333 | 871 | 28 |
1978922 | 1978922 | 2021-12-03 | Ferry | Washington | 53019 | 871 | 17 |
1975394 | 1975394 | 2021-12-02 | Mills | Texas | 48333 | 871 | 28 |
1975672 | 1975672 | 2021-12-02 | Ferry | Washington | 53019 | 871 | 17 |
1944327 | 1944327 | 2021-11-23 | Scott | Kansas | 20171 | 871 | 30 |
1941077 | 1941077 | 2021-11-22 | Scott | Kansas | 20171 | 871 | 30 |
1925524 | 1925524 | 2021-11-17 | Burt | Nebraska | 31021 | 871 | 13 |
1922993 | 1922993 | 2021-11-16 | Santa Isabel | Puerto Rico | 72133 | 871 | |
1919744 | 1919744 | 2021-11-15 | Santa Isabel | Puerto Rico | 72133 | 871 | |
1913244 | 1913244 | 2021-11-13 | Santa Isabel | Puerto Rico | 72133 | 871 | |
1913996 | 1913996 | 2021-11-13 | Wirt | West Virginia | 54105 | 871 | 13 |
1909994 | 1909994 | 2021-11-12 | Santa Isabel | Puerto Rico | 72133 | 871 | |
1906065 | 1906065 | 2021-11-11 | Kearney | Nebraska | 31099 | 871 | 6 |
1896260 | 1896260 | 2021-11-08 | Teton | Montana | 30099 | 871 | 13 |
1892964 | 1892964 | 2021-11-07 | Broadwater | Montana | 30007 | 871 | 17 |
1889714 | 1889714 | 2021-11-06 | Broadwater | Montana | 30007 | 871 | 17 |
1886464 | 1886464 | 2021-11-05 | Broadwater | Montana | 30007 | 871 | 17 |
1887638 | 1887638 | 2021-11-05 | Mills | Texas | 48333 | 871 | 28 |
1884388 | 1884388 | 2021-11-04 | Mills | Texas | 48333 | 871 | 28 |
1877775 | 1877775 | 2021-11-02 | Crane | Texas | 48103 | 871 | 18 |
1873376 | 1873376 | 2021-11-01 | Dade | Missouri | 29057 | 871 | 17 |
1874526 | 1874526 | 2021-11-01 | Crane | Texas | 48103 | 871 | 18 |
1871277 | 1871277 | 2021-10-31 | Crane | Texas | 48103 | 871 | 18 |
1862088 | 1862088 | 2021-10-28 | Hot Springs | Wyoming | 56017 | 871 | 9 |
1841387 | 1841387 | 2021-10-22 | McHenry | North Dakota | 38049 | 871 | 23 |
1836038 | 1836038 | 2021-10-20 | Iron | Wisconsin | 55051 | 871 | 42 |
1813122 | 1813122 | 2021-10-13 | Mathews | Virginia | 51115 | 871 | 20 |
1783667 | 1783667 | 2021-10-04 | Mitchell | Texas | 48335 | 871 | 36 |
1780111 | 1780111 | 2021-10-03 | Fall River | South Dakota | 46047 | 871 | 20 |
1780418 | 1780418 | 2021-10-03 | Mitchell | Texas | 48335 | 871 | 36 |
1776861 | 1776861 | 2021-10-02 | Fall River | South Dakota | 46047 | 871 | 20 |
1777168 | 1777168 | 2021-10-02 | Mitchell | Texas | 48335 | 871 | 36 |
1773611 | 1773611 | 2021-10-01 | Fall River | South Dakota | 46047 | 871 | 20 |
1773918 | 1773918 | 2021-10-01 | Mitchell | Texas | 48335 | 871 | 36 |
1767634 | 1767634 | 2021-09-29 | Middlesex | Virginia | 51119 | 871 | 24 |
1762974 | 1762974 | 2021-09-28 | Shelby | Missouri | 29205 | 871 | 9 |
1759226 | 1759226 | 2021-09-27 | Owsley | Kentucky | 21189 | 871 | 16 |
1760139 | 1760139 | 2021-09-27 | Bottineau | North Dakota | 38009 | 871 | 20 |
1755877 | 1755877 | 2021-09-26 | Wabaunsee | Kansas | 20197 | 871 | 18 |
1756891 | 1756891 | 2021-09-26 | Bottineau | North Dakota | 38009 | 871 | 20 |
1752629 | 1752629 | 2021-09-25 | Wabaunsee | Kansas | 20197 | 871 | 18 |
1749380 | 1749380 | 2021-09-24 | Wabaunsee | Kansas | 20197 | 871 | 18 |
1746458 | 1746458 | 2021-09-23 | Unknown | Michigan | 871 | 18 |
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);