ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
255 rows where cases = 2587 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Virginia 14
- Alabama 12
- Georgia 12
- Iowa 12
- Missouri 12
- North Carolina 12
- Colorado 11
- Indiana 11
- Wisconsin 11
- Montana 10
- Kansas 9
- Kentucky 9
- Puerto Rico 9
- Illinois 8
- Washington 8
- Massachusetts 7
- South Carolina 7
- Michigan 6
- Pennsylvania 6
- Tennessee 6
- Idaho 5
- South Dakota 5
- West Virginia 5
- Louisiana 4
- Maine 4
- Minnesota 4
- Nebraska 4
- New Mexico 3
- Ohio 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502551 | 2502551 | 2022-05-13 | Floyd | Virginia | 51063 | 2587 | 49 |
2490561 | 2490561 | 2022-05-10 | Newton | Indiana | 18111 | 2587 | 68 |
2487304 | 2487304 | 2022-05-09 | Newton | Indiana | 18111 | 2587 | 68 |
2489582 | 2489582 | 2022-05-09 | Richmond | Virginia | 51159 | 2587 | 25 |
2473571 | 2473571 | 2022-05-05 | Sumter | Alabama | 1119 | 2587 | 51 |
2470314 | 2470314 | 2022-05-04 | Sumter | Alabama | 1119 | 2587 | 51 |
2467058 | 2467058 | 2022-05-03 | Sumter | Alabama | 1119 | 2587 | 51 |
2440062 | 2440062 | 2022-04-24 | Florida | Puerto Rico | 72054 | 2587 | |
2374224 | 2374224 | 2022-04-04 | Jefferson | Montana | 30043 | 2587 | 23 |
2370972 | 2370972 | 2022-04-03 | Jefferson | Montana | 30043 | 2587 | 23 |
2367719 | 2367719 | 2022-04-02 | Jefferson | Montana | 30043 | 2587 | 23 |
2364466 | 2364466 | 2022-04-01 | Jefferson | Montana | 30043 | 2587 | 23 |
2312753 | 2312753 | 2022-03-16 | Pamlico | North Carolina | 37137 | 2587 | 27 |
2308333 | 2308333 | 2022-03-15 | Calhoun | Iowa | 19025 | 2587 | 23 |
2309500 | 2309500 | 2022-03-15 | Pamlico | North Carolina | 37137 | 2587 | 27 |
2304568 | 2304568 | 2022-03-14 | Prowers | Colorado | 8099 | 2587 | 48 |
2305082 | 2305082 | 2022-03-14 | Calhoun | Iowa | 19025 | 2587 | 23 |
2301316 | 2301316 | 2022-03-13 | Prowers | Colorado | 8099 | 2587 | 48 |
2301830 | 2301830 | 2022-03-13 | Calhoun | Iowa | 19025 | 2587 | 23 |
2302996 | 2302996 | 2022-03-13 | Pamlico | North Carolina | 37137 | 2587 | 27 |
2303955 | 2303955 | 2022-03-13 | Amelia | Virginia | 51007 | 2587 | 59 |
2298064 | 2298064 | 2022-03-12 | Prowers | Colorado | 8099 | 2587 | 48 |
2298578 | 2298578 | 2022-03-12 | Calhoun | Iowa | 19025 | 2587 | 23 |
2299744 | 2299744 | 2022-03-12 | Pamlico | North Carolina | 37137 | 2587 | 27 |
2300703 | 2300703 | 2022-03-12 | Amelia | Virginia | 51007 | 2587 | 59 |
2294812 | 2294812 | 2022-03-11 | Prowers | Colorado | 8099 | 2587 | 48 |
2295326 | 2295326 | 2022-03-11 | Calhoun | Iowa | 19025 | 2587 | 23 |
2296492 | 2296492 | 2022-03-11 | Pamlico | North Carolina | 37137 | 2587 | 27 |
2297451 | 2297451 | 2022-03-11 | Amelia | Virginia | 51007 | 2587 | 59 |
2291560 | 2291560 | 2022-03-10 | Prowers | Colorado | 8099 | 2587 | 48 |
2292074 | 2292074 | 2022-03-10 | Calhoun | Iowa | 19025 | 2587 | 23 |
2288308 | 2288308 | 2022-03-09 | Prowers | Colorado | 8099 | 2587 | 48 |
2288822 | 2288822 | 2022-03-09 | Calhoun | Iowa | 19025 | 2587 | 23 |
2265843 | 2265843 | 2022-03-02 | Shoshone | Idaho | 16079 | 2587 | 75 |
2262971 | 2262971 | 2022-03-01 | Rice | Kansas | 20159 | 2587 | 22 |
2259720 | 2259720 | 2022-02-28 | Rice | Kansas | 20159 | 2587 | 22 |
2213273 | 2213273 | 2022-02-14 | Lowndes | Alabama | 1085 | 2587 | 69 |
2210020 | 2210020 | 2022-02-13 | Lowndes | Alabama | 1085 | 2587 | 69 |
2206767 | 2206767 | 2022-02-12 | Lowndes | Alabama | 1085 | 2587 | 69 |
2200733 | 2200733 | 2022-02-10 | Screven | Georgia | 13251 | 2587 | 62 |
2192012 | 2192012 | 2022-02-07 | Lewis | Missouri | 29111 | 2587 | 31 |
2180524 | 2180524 | 2022-02-03 | Jefferson | Washington | 53031 | 2587 | 23 |
2177273 | 2177273 | 2022-02-02 | Jefferson | Washington | 53031 | 2587 | 23 |
2166863 | 2166863 | 2022-01-30 | Calhoun | South Carolina | 45017 | 2587 | 54 |
2163608 | 2163608 | 2022-01-29 | Calhoun | South Carolina | 45017 | 2587 | 54 |
2160353 | 2160353 | 2022-01-28 | Calhoun | South Carolina | 45017 | 2587 | 54 |
2157058 | 2157058 | 2022-01-27 | Orocovis | Puerto Rico | 72107 | 2587 | |
2157328 | 2157328 | 2022-01-27 | Camp | Texas | 48063 | 2587 | 70 |
2130106 | 2130106 | 2022-01-19 | Montgomery | Mississippi | 28097 | 2587 | 61 |
2103971 | 2103971 | 2022-01-11 | Cottonwood | Minnesota | 27033 | 2587 | 34 |
2050676 | 2050676 | 2021-12-26 | Washington | Alabama | 1129 | 2587 | 51 |
2051509 | 2051509 | 2021-12-26 | Allen | Kansas | 20001 | 2587 | 26 |
2047376 | 2047376 | 2021-12-25 | Cleburne | Alabama | 1029 | 2587 | 60 |
2048259 | 2048259 | 2021-12-25 | Allen | Kansas | 20001 | 2587 | 26 |
2045009 | 2045009 | 2021-12-24 | Allen | Kansas | 20001 | 2587 | 26 |
2041760 | 2041760 | 2021-12-23 | Allen | Kansas | 20001 | 2587 | 26 |
2038510 | 2038510 | 2021-12-22 | Allen | Kansas | 20001 | 2587 | 26 |
2037242 | 2037242 | 2021-12-21 | Zavala | Texas | 48507 | 2587 | 56 |
2029422 | 2029422 | 2021-12-19 | Madison | Missouri | 29123 | 2587 | 40 |
2031072 | 2031072 | 2021-12-19 | Rusk | Wisconsin | 55107 | 2587 | 39 |
2027821 | 2027821 | 2021-12-18 | Rusk | Wisconsin | 55107 | 2587 | 39 |
2024570 | 2024570 | 2021-12-17 | Rusk | Wisconsin | 55107 | 2587 | 39 |
2015920 | 2015920 | 2021-12-15 | Knott | Kentucky | 21119 | 2587 | 43 |
2005873 | 2005873 | 2021-12-12 | Pike | Indiana | 18125 | 2587 | 46 |
2002622 | 2002622 | 2021-12-11 | Pike | Indiana | 18125 | 2587 | 46 |
1999372 | 1999372 | 2021-12-10 | Pike | Indiana | 18125 | 2587 | 46 |
1993148 | 1993148 | 2021-12-08 | Green | Kentucky | 21087 | 2587 | 37 |
1989897 | 1989897 | 2021-12-07 | Green | Kentucky | 21087 | 2587 | 37 |
1984721 | 1984721 | 2021-12-05 | Isabela | Puerto Rico | 72071 | 2587 | |
1981471 | 1981471 | 2021-12-04 | Isabela | Puerto Rico | 72071 | 2587 | |
1978221 | 1978221 | 2021-12-03 | Isabela | Puerto Rico | 72071 | 2587 | |
1965998 | 1965998 | 2021-11-29 | Taylor | West Virginia | 54091 | 2587 | 44 |
1942552 | 1942552 | 2021-11-22 | Saluda | South Carolina | 45081 | 2587 | 55 |
1943261 | 1943261 | 2021-11-22 | Crawford | Wisconsin | 55023 | 2587 | 23 |
1924471 | 1924471 | 2021-11-17 | Ford | Illinois | 17053 | 2587 | 67 |
1909175 | 1909175 | 2021-11-12 | Pike | Missouri | 29163 | 2587 | 38 |
1903766 | 1903766 | 2021-11-10 | Colorado | Texas | 48089 | 2587 | 53 |
1899237 | 1899237 | 2021-11-09 | Redwood | Minnesota | 27127 | 2587 | 44 |
1900516 | 1900516 | 2021-11-09 | Colorado | Texas | 48089 | 2587 | 53 |
1896908 | 1896908 | 2021-11-08 | Montour | Pennsylvania | 42093 | 2587 | 73 |
1893658 | 1893658 | 2021-11-07 | Montour | Pennsylvania | 42093 | 2587 | 73 |
1883211 | 1883211 | 2021-11-04 | Wright | Missouri | 29229 | 2587 | 54 |
1869859 | 1869859 | 2021-10-31 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1866610 | 1866610 | 2021-10-30 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1863361 | 1863361 | 2021-10-29 | Charlevoix | Michigan | 26029 | 2587 | 34 |
1846644 | 1846644 | 2021-10-24 | Vermillion | Indiana | 18165 | 2587 | 54 |
1848848 | 1848848 | 2021-10-24 | King George | Virginia | 51099 | 2587 | 22 |
1843394 | 1843394 | 2021-10-23 | Vermillion | Indiana | 18165 | 2587 | 54 |
1845598 | 1845598 | 2021-10-23 | King George | Virginia | 51099 | 2587 | 22 |
1840144 | 1840144 | 2021-10-22 | Vermillion | Indiana | 18165 | 2587 | 54 |
1842348 | 1842348 | 2021-10-22 | King George | Virginia | 51099 | 2587 | 22 |
1833473 | 1833473 | 2021-10-20 | Clay | Illinois | 17025 | 2587 | 59 |
1829900 | 1829900 | 2021-10-19 | Otero | Colorado | 8089 | 2587 | 79 |
1818119 | 1818119 | 2021-10-15 | Benton | Missouri | 29015 | 2587 | 44 |
1791808 | 1791808 | 2021-10-07 | Winn | Louisiana | 22127 | 2587 | 58 |
1782999 | 1782999 | 2021-10-04 | Paulding | Ohio | 39125 | 2587 | 43 |
1771001 | 1771001 | 2021-09-30 | McDowell | West Virginia | 54047 | 2587 | 39 |
1765393 | 1765393 | 2021-09-29 | Perry | Indiana | 18123 | 2587 | 55 |
1762054 | 1762054 | 2021-09-28 | Pike | Illinois | 17149 | 2587 | 59 |
1738602 | 1738602 | 2021-09-20 | Taylor | Wisconsin | 55119 | 2587 | 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);