ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
345 rows where cases = 1426 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 33
- Iowa 24
- Texas 23
- Kentucky 19
- Virginia 18
- Georgia 15
- Mississippi 13
- Minnesota 12
- Puerto Rico 12
- Michigan 11
- Arkansas 9
- Indiana 9
- Missouri 9
- Wisconsin 9
- Tennessee 8
- Illinois 7
- Louisiana 7
- Washington 7
- West Virginia 7
- North Carolina 6
- Wyoming 6
- Alabama 5
- California 5
- Colorado 5
- Montana 5
- Ohio 5
- Oregon 5
- Alaska 4
- Connecticut 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497276 | 2497276 | 2022-05-12 | Mitchell | Kansas | 20123 | 1426 | 22 |
2494018 | 2494018 | 2022-05-11 | Mitchell | Kansas | 20123 | 1426 | 22 |
2495313 | 2495313 | 2022-05-11 | Lake | Oregon | 41037 | 1426 | 29 |
2490760 | 2490760 | 2022-05-10 | Mitchell | Kansas | 20123 | 1426 | 22 |
2487503 | 2487503 | 2022-05-09 | Mitchell | Kansas | 20123 | 1426 | 22 |
2484245 | 2484245 | 2022-05-08 | Mitchell | Kansas | 20123 | 1426 | 22 |
2480987 | 2480987 | 2022-05-07 | Mitchell | Kansas | 20123 | 1426 | 22 |
2477729 | 2477729 | 2022-05-06 | Mitchell | Kansas | 20123 | 1426 | 22 |
2474471 | 2474471 | 2022-05-05 | Mitchell | Kansas | 20123 | 1426 | 22 |
2471214 | 2471214 | 2022-05-04 | Mitchell | Kansas | 20123 | 1426 | 22 |
2467958 | 2467958 | 2022-05-03 | Mitchell | Kansas | 20123 | 1426 | 22 |
2464703 | 2464703 | 2022-05-02 | Mitchell | Kansas | 20123 | 1426 | 22 |
2461447 | 2461447 | 2022-05-01 | Mitchell | Kansas | 20123 | 1426 | 22 |
2458191 | 2458191 | 2022-04-30 | Mitchell | Kansas | 20123 | 1426 | 22 |
2454935 | 2454935 | 2022-04-29 | Mitchell | Kansas | 20123 | 1426 | 22 |
2356077 | 2356077 | 2022-03-29 | Mathews | Virginia | 51115 | 1426 | 28 |
2352824 | 2352824 | 2022-03-28 | Mathews | Virginia | 51115 | 1426 | 28 |
2328570 | 2328570 | 2022-03-21 | Dade | Missouri | 29057 | 1426 | 41 |
2310533 | 2310533 | 2022-03-15 | Mathews | Virginia | 51115 | 1426 | 28 |
2307280 | 2307280 | 2022-03-14 | Mathews | Virginia | 51115 | 1426 | 28 |
2292576 | 2292576 | 2022-03-10 | Oscoda | Michigan | 26135 | 1426 | 54 |
2289324 | 2289324 | 2022-03-09 | Oscoda | Michigan | 26135 | 1426 | 54 |
2281783 | 2281783 | 2022-03-07 | Huerfano | Colorado | 8055 | 1426 | 31 |
2271652 | 2271652 | 2022-03-03 | Wirt | West Virginia | 54105 | 1426 | 23 |
2262953 | 2262953 | 2022-03-01 | Mitchell | Kansas | 20123 | 1426 | 19 |
2259702 | 2259702 | 2022-02-28 | Mitchell | Kansas | 20123 | 1426 | 19 |
2256451 | 2256451 | 2022-02-27 | Mitchell | Kansas | 20123 | 1426 | 19 |
2253200 | 2253200 | 2022-02-26 | Mitchell | Kansas | 20123 | 1426 | 19 |
2249949 | 2249949 | 2022-02-25 | Mitchell | Kansas | 20123 | 1426 | 19 |
2242728 | 2242728 | 2022-02-23 | Trinity | California | 6105 | 1426 | 20 |
2239477 | 2239477 | 2022-02-22 | Trinity | California | 6105 | 1426 | 20 |
2224336 | 2224336 | 2022-02-17 | Grant | Minnesota | 27051 | 1426 | 12 |
2221085 | 2221085 | 2022-02-16 | Grant | Minnesota | 27051 | 1426 | 12 |
2179168 | 2179168 | 2022-02-03 | Keith | Nebraska | 31101 | 1426 | 14 |
2167848 | 2167848 | 2022-01-31 | Montgomery | Arkansas | 5097 | 1426 | 53 |
2157922 | 2157922 | 2022-01-27 | Weston | Wyoming | 56045 | 1426 | 16 |
2126210 | 2126210 | 2022-01-18 | Davis | Iowa | 19051 | 1426 | 27 |
2126916 | 2126916 | 2022-01-18 | Daviess | Missouri | 29061 | 1426 | 21 |
2122958 | 2122958 | 2022-01-17 | Davis | Iowa | 19051 | 1426 | 27 |
2119706 | 2119706 | 2022-01-16 | Davis | Iowa | 19051 | 1426 | 27 |
2116454 | 2116454 | 2022-01-15 | Davis | Iowa | 19051 | 1426 | 27 |
2113203 | 2113203 | 2022-01-14 | Davis | Iowa | 19051 | 1426 | 27 |
2109951 | 2109951 | 2022-01-13 | Davis | Iowa | 19051 | 1426 | 27 |
2106700 | 2106700 | 2022-01-12 | Davis | Iowa | 19051 | 1426 | 27 |
2105467 | 2105467 | 2022-01-11 | Stephens | Texas | 48429 | 1426 | 39 |
2105773 | 2105773 | 2022-01-11 | Tucker | West Virginia | 54093 | 1426 | 32 |
2100810 | 2100810 | 2022-01-10 | Franklin | Mississippi | 28037 | 1426 | 33 |
2089790 | 2089790 | 2022-01-07 | Prairie | Arkansas | 5117 | 1426 | 32 |
2061145 | 2061145 | 2021-12-29 | Union | Indiana | 18161 | 1426 | 19 |
2062317 | 2062317 | 2021-12-29 | Jones | North Carolina | 37103 | 1426 | 37 |
2059506 | 2059506 | 2021-12-28 | San German | Puerto Rico | 72125 | 1426 | |
2040915 | 2040915 | 2021-12-23 | Perry | Alabama | 1105 | 1426 | 41 |
2035376 | 2035376 | 2021-12-21 | Bracken | Kentucky | 21023 | 1426 | 20 |
2035483 | 2035483 | 2021-12-21 | Wolfe | Kentucky | 21237 | 1426 | 13 |
2009390 | 2009390 | 2021-12-13 | Elliott | Kentucky | 21063 | 1426 | 13 |
2005266 | 2005266 | 2021-12-12 | Nevada | Arkansas | 5099 | 1426 | 41 |
2006139 | 2006139 | 2021-12-12 | Elliott | Kentucky | 21063 | 1426 | 13 |
2002015 | 2002015 | 2021-12-11 | Nevada | Arkansas | 5099 | 1426 | 41 |
2002888 | 2002888 | 2021-12-11 | Elliott | Kentucky | 21063 | 1426 | 13 |
1999638 | 1999638 | 2021-12-10 | Elliott | Kentucky | 21063 | 1426 | 13 |
1995211 | 1995211 | 2021-12-08 | Clay | West Virginia | 54015 | 1426 | 24 |
1990892 | 1990892 | 2021-12-07 | Pembina | North Dakota | 38067 | 1426 | 14 |
1971040 | 1971040 | 2021-12-01 | Cheyenne | Nebraska | 31033 | 1426 | 19 |
1938136 | 1938136 | 2021-11-21 | Mackinac | Michigan | 26097 | 1426 | 14 |
1934886 | 1934886 | 2021-11-20 | Mackinac | Michigan | 26097 | 1426 | 14 |
1931636 | 1931636 | 2021-11-19 | Mackinac | Michigan | 26097 | 1426 | 14 |
1928746 | 1928746 | 2021-11-18 | Powell | Montana | 30077 | 1426 | 21 |
1925496 | 1925496 | 2021-11-17 | Powell | Montana | 30077 | 1426 | 21 |
1905731 | 1905731 | 2021-11-11 | Pipestone | Minnesota | 27117 | 1426 | 29 |
1899217 | 1899217 | 2021-11-09 | Marshall | Minnesota | 27089 | 1426 | 21 |
1896046 | 1896046 | 2021-11-08 | Kemper | Mississippi | 28069 | 1426 | 41 |
1892796 | 1892796 | 2021-11-07 | Kemper | Mississippi | 28069 | 1426 | 41 |
1889546 | 1889546 | 2021-11-06 | Kemper | Mississippi | 28069 | 1426 | 41 |
1890434 | 1890434 | 2021-11-06 | Anasco | Puerto Rico | 72011 | 1426 | |
1886296 | 1886296 | 2021-11-05 | Kemper | Mississippi | 28069 | 1426 | 41 |
1883047 | 1883047 | 2021-11-04 | Kemper | Mississippi | 28069 | 1426 | 41 |
1879798 | 1879798 | 2021-11-03 | Kemper | Mississippi | 28069 | 1426 | 41 |
1872921 | 1872921 | 2021-11-01 | Livingston | Kentucky | 21139 | 1426 | 43 |
1873213 | 1873213 | 2021-11-01 | Koochiching | Minnesota | 27071 | 1426 | 19 |
1871532 | 1871532 | 2021-10-31 | Amelia | Virginia | 51007 | 1426 | 40 |
1868283 | 1868283 | 2021-10-30 | Amelia | Virginia | 51007 | 1426 | 40 |
1865034 | 1865034 | 2021-10-29 | Amelia | Virginia | 51007 | 1426 | 40 |
1855728 | 1855728 | 2021-10-27 | Cleveland | Arkansas | 5025 | 1426 | 32 |
1829270 | 1829270 | 2021-10-18 | Addison | Vermont | 50001 | 1426 | 8 |
1788760 | 1788760 | 2021-10-06 | Pope | Minnesota | 27121 | 1426 | 8 |
1782404 | 1782404 | 2021-10-04 | DeKalb | Missouri | 29063 | 1426 | 33 |
1766253 | 1766253 | 2021-09-29 | Deer Lodge | Montana | 30023 | 1426 | 24 |
1767601 | 1767601 | 2021-09-29 | Galax city | Virginia | 51640 | 1426 | 58 |
1754544 | 1754544 | 2021-09-25 | Caledonia | Vermont | 50005 | 1426 | 9 |
1742049 | 1742049 | 2021-09-22 | Perry | Arkansas | 5105 | 1426 | 19 |
1743544 | 1743544 | 2021-09-22 | Rosebud | Montana | 30087 | 1426 | 52 |
1722684 | 1722684 | 2021-09-16 | Prowers | Colorado | 8099 | 1426 | 25 |
1724773 | 1724773 | 2021-09-16 | Naguabo | Puerto Rico | 72103 | 1426 | |
1716398 | 1716398 | 2021-09-14 | Pulaski | Georgia | 13235 | 1426 | 51 |
1717478 | 1717478 | 2021-09-14 | Ralls | Missouri | 29173 | 1426 | 14 |
1718971 | 1718971 | 2021-09-14 | Klickitat | Washington | 53039 | 1426 | 14 |
1705700 | 1705700 | 2021-09-10 | Morris | Texas | 48343 | 1426 | 42 |
1705807 | 1705807 | 2021-09-10 | Unknown | Utah | 1426 | 30 | |
1697483 | 1697483 | 2021-09-08 | Martin | Kentucky | 21159 | 1426 | 22 |
1693985 | 1693985 | 2021-09-07 | Emmet | Iowa | 19063 | 1426 | 41 |
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);