ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
331 rows where cases = 1792 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 26
- Texas 25
- Georgia 18
- Arkansas 16
- Iowa 16
- Alabama 15
- Michigan 15
- North Carolina 15
- Oklahoma 15
- Missouri 13
- Colorado 11
- Puerto Rico 10
- Tennessee 10
- Virginia 10
- West Virginia 10
- Kansas 9
- Ohio 9
- Wisconsin 9
- Indiana 8
- Minnesota 8
- Illinois 7
- Louisiana 7
- Florida 6
- Kentucky 5
- Montana 5
- Idaho 4
- Utah 4
- New Mexico 3
- New York 3
- Oregon 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473200 | 2473200 | 2022-05-04 | Bland | Virginia | 51021 | 1792 | 24 |
2451654 | 2451654 | 2022-04-28 | Greenwood | Kansas | 20073 | 1792 | 23 |
2448398 | 2448398 | 2022-04-27 | Greenwood | Kansas | 20073 | 1792 | 23 |
2445142 | 2445142 | 2022-04-26 | Greenwood | Kansas | 20073 | 1792 | 23 |
2441886 | 2441886 | 2022-04-25 | Greenwood | Kansas | 20073 | 1792 | 23 |
2438630 | 2438630 | 2022-04-24 | Greenwood | Kansas | 20073 | 1792 | 23 |
2435374 | 2435374 | 2022-04-23 | Greenwood | Kansas | 20073 | 1792 | 23 |
2432118 | 2432118 | 2022-04-22 | Greenwood | Kansas | 20073 | 1792 | 23 |
2392394 | 2392394 | 2022-04-10 | Lake | Colorado | 8065 | 1792 | 2 |
2389138 | 2389138 | 2022-04-09 | Lake | Colorado | 8065 | 1792 | 2 |
2385883 | 2385883 | 2022-04-08 | Lake | Colorado | 8065 | 1792 | 2 |
2359320 | 2359320 | 2022-03-30 | Lancaster | Virginia | 51103 | 1792 | 31 |
2302516 | 2302516 | 2022-03-13 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2299264 | 2299264 | 2022-03-12 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2296012 | 2296012 | 2022-03-11 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2292760 | 2292760 | 2022-03-10 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2289508 | 2289508 | 2022-03-09 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2286256 | 2286256 | 2022-03-08 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2283004 | 2283004 | 2022-03-07 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2279751 | 2279751 | 2022-03-06 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2276498 | 2276498 | 2022-03-05 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2273245 | 2273245 | 2022-03-04 | Wilkinson | Mississippi | 28157 | 1792 | 46 |
2262838 | 2262838 | 2022-03-01 | Ida | Iowa | 19093 | 1792 | 47 |
2264681 | 2264681 | 2022-03-01 | Delta | Texas | 48119 | 1792 | 24 |
2259587 | 2259587 | 2022-02-28 | Ida | Iowa | 19093 | 1792 | 47 |
2256336 | 2256336 | 2022-02-27 | Ida | Iowa | 19093 | 1792 | 47 |
2253085 | 2253085 | 2022-02-26 | Ida | Iowa | 19093 | 1792 | 47 |
2249834 | 2249834 | 2022-02-25 | Ida | Iowa | 19093 | 1792 | 47 |
2246583 | 2246583 | 2022-02-24 | Ida | Iowa | 19093 | 1792 | 47 |
2243332 | 2243332 | 2022-02-23 | Ida | Iowa | 19093 | 1792 | 47 |
2225324 | 2225324 | 2022-02-17 | Arroyo | Puerto Rico | 72015 | 1792 | |
2222073 | 2222073 | 2022-02-16 | Arroyo | Puerto Rico | 72015 | 1792 | |
2195364 | 2195364 | 2022-02-08 | Powell | Montana | 30077 | 1792 | 27 |
2177164 | 2177164 | 2022-02-02 | Falls Church city | Virginia | 51610 | 1792 | 15 |
2150007 | 2150007 | 2022-01-25 | Sierra | New Mexico | 35051 | 1792 | 68 |
2147917 | 2147917 | 2022-01-24 | Madison | Virginia | 51113 | 1792 | 26 |
2133237 | 2133237 | 2022-01-20 | Clearwater | Minnesota | 27029 | 1792 | 27 |
2134979 | 2134979 | 2022-01-20 | Lincoln | Washington | 53043 | 1792 | 26 |
2103221 | 2103221 | 2022-01-11 | Owyhee | Idaho | 16073 | 1792 | 43 |
2105650 | 2105650 | 2022-01-11 | Poquoson city | Virginia | 51735 | 1792 | 24 |
2088028 | 2088028 | 2022-01-06 | Rosebud | Montana | 30087 | 1792 | 58 |
2089258 | 2089258 | 2022-01-06 | Grand | Utah | 49019 | 1792 | 6 |
2089419 | 2089419 | 2022-01-06 | Sussex | Virginia | 51183 | 1792 | 31 |
2084776 | 2084776 | 2022-01-05 | Rosebud | Montana | 30087 | 1792 | 58 |
2075750 | 2075750 | 2022-01-02 | Orocovis | Puerto Rico | 72107 | 1792 | |
2032536 | 2032536 | 2021-12-20 | Carroll | Mississippi | 28015 | 1792 | 41 |
2033087 | 2033087 | 2021-12-20 | Pamlico | North Carolina | 37137 | 1792 | 26 |
2018174 | 2018174 | 2021-12-16 | Wilcox | Alabama | 1131 | 1792 | 38 |
2008649 | 2008649 | 2021-12-13 | Park | Colorado | 8093 | 1792 | 13 |
2006385 | 2006385 | 2021-12-12 | Iron | Michigan | 26071 | 1792 | 70 |
2003134 | 2003134 | 2021-12-11 | Iron | Michigan | 26071 | 1792 | 70 |
1999884 | 1999884 | 2021-12-10 | Iron | Michigan | 26071 | 1792 | 70 |
1987133 | 1987133 | 2021-12-06 | Douglas | Missouri | 29067 | 1792 | 63 |
1983715 | 1983715 | 2021-12-05 | Koochiching | Minnesota | 27071 | 1792 | 25 |
1980465 | 1980465 | 2021-12-04 | Koochiching | Minnesota | 27071 | 1792 | 25 |
1977215 | 1977215 | 2021-12-03 | Koochiching | Minnesota | 27071 | 1792 | 25 |
1970487 | 1970487 | 2021-12-01 | Catahoula | Louisiana | 22025 | 1792 | 48 |
1967237 | 1967237 | 2021-11-30 | Catahoula | Louisiana | 22025 | 1792 | 48 |
1963611 | 1963611 | 2021-11-29 | Newton | Indiana | 18111 | 1792 | 54 |
1959898 | 1959898 | 2021-11-28 | Rio Grande | Colorado | 8105 | 1792 | 29 |
1956647 | 1956647 | 2021-11-27 | Rio Grande | Colorado | 8105 | 1792 | 29 |
1953396 | 1953396 | 2021-11-26 | Rio Grande | Colorado | 8105 | 1792 | 29 |
1950145 | 1950145 | 2021-11-25 | Rio Grande | Colorado | 8105 | 1792 | 29 |
1928508 | 1928508 | 2021-11-18 | Yellow Medicine | Minnesota | 27173 | 1792 | 21 |
1928610 | 1928610 | 2021-11-18 | Cedar | Missouri | 29039 | 1792 | 42 |
1922797 | 1922797 | 2021-11-16 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1919548 | 1919548 | 2021-11-15 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1916298 | 1916298 | 2021-11-14 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1913048 | 1913048 | 2021-11-13 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1909798 | 1909798 | 2021-11-12 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1905633 | 1905633 | 2021-11-11 | Leelanau | Michigan | 26089 | 1792 | 26 |
1906549 | 1906549 | 2021-11-11 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1901275 | 1901275 | 2021-11-10 | Stone | Arkansas | 5137 | 1792 | 44 |
1902384 | 1902384 | 2021-11-10 | Leelanau | Michigan | 26089 | 1792 | 26 |
1903300 | 1903300 | 2021-11-10 | Nowata | Oklahoma | 40105 | 1792 | 29 |
1899352 | 1899352 | 2021-11-09 | Bollinger | Missouri | 29017 | 1792 | 20 |
1894250 | 1894250 | 2021-11-07 | Unknown | Utah | 1792 | 38 | |
1891000 | 1891000 | 2021-11-06 | Unknown | Utah | 1792 | 38 | |
1867697 | 1867697 | 2021-10-30 | Camuy | Puerto Rico | 72027 | 1792 | |
1829628 | 1829628 | 2021-10-19 | Coosa | Alabama | 1037 | 1792 | 38 |
1827689 | 1827689 | 2021-10-18 | Aitkin | Minnesota | 27001 | 1792 | 42 |
1823626 | 1823626 | 2021-10-17 | Screven | Georgia | 13251 | 1792 | 57 |
1824412 | 1824412 | 2021-10-17 | Missaukee | Michigan | 26113 | 1792 | 34 |
1820377 | 1820377 | 2021-10-16 | Screven | Georgia | 13251 | 1792 | 57 |
1821163 | 1821163 | 2021-10-16 | Missaukee | Michigan | 26113 | 1792 | 34 |
1817128 | 1817128 | 2021-10-15 | Screven | Georgia | 13251 | 1792 | 57 |
1817914 | 1817914 | 2021-10-15 | Missaukee | Michigan | 26113 | 1792 | 34 |
1805871 | 1805871 | 2021-10-11 | Morrow | Oregon | 41049 | 1792 | 23 |
1787116 | 1787116 | 2021-10-05 | King William | Virginia | 51101 | 1792 | 22 |
1782107 | 1782107 | 2021-10-04 | Dukes | Massachusetts | 25007 | 1792 | 0 |
1768962 | 1768962 | 2021-09-30 | Metcalfe | Kentucky | 21169 | 1792 | 37 |
1762935 | 1762935 | 2021-09-28 | Linn | Missouri | 29115 | 1792 | 25 |
1764537 | 1764537 | 2021-09-28 | Buffalo | Wisconsin | 55011 | 1792 | 7 |
1742017 | 1742017 | 2021-09-22 | Desha | Arkansas | 5041 | 1792 | 27 |
1728003 | 1728003 | 2021-09-17 | Hatillo | Puerto Rico | 72065 | 1792 | |
1723462 | 1723462 | 2021-09-16 | Lyon | Kentucky | 21143 | 1792 | 24 |
1725519 | 1725519 | 2021-09-16 | Monroe | West Virginia | 54063 | 1792 | 20 |
1713682 | 1713682 | 2021-09-13 | Fleming | Kentucky | 21069 | 1792 | 26 |
1715836 | 1715836 | 2021-09-13 | Marquette | Wisconsin | 55077 | 1792 | 29 |
1704095 | 1704095 | 2021-09-10 | Hancock | Maine | 23009 | 1792 | 43 |
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);