ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
253 rows where cases = 1869 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 32
- Missouri 21
- Virginia 20
- Alabama 14
- Indiana 12
- Georgia 11
- Kansas 10
- Kentucky 10
- Minnesota 10
- Mississippi 8
- Arkansas 7
- Michigan 7
- Montana 7
- Nebraska 7
- North Carolina 7
- Illinois 6
- Louisiana 6
- Puerto Rico 6
- Ohio 5
- Florida 4
- South Carolina 4
- West Virginia 4
- Colorado 3
- Idaho 3
- Iowa 3
- South Dakota 3
- Tennessee 3
- Utah 3
- Alaska 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501231 | 2501231 | 2022-05-13 | Powell | Montana | 30077 | 1869 | 29 |
2497858 | 2497858 | 2022-05-12 | Harrison | Missouri | 29081 | 1869 | 33 |
2494600 | 2494600 | 2022-05-11 | Harrison | Missouri | 29081 | 1869 | 33 |
2491342 | 2491342 | 2022-05-10 | Harrison | Missouri | 29081 | 1869 | 33 |
2488084 | 2488084 | 2022-05-09 | Harrison | Missouri | 29081 | 1869 | 33 |
2484827 | 2484827 | 2022-05-08 | Harrison | Missouri | 29081 | 1869 | 33 |
2481569 | 2481569 | 2022-05-07 | Harrison | Missouri | 29081 | 1869 | 33 |
2478311 | 2478311 | 2022-05-06 | Harrison | Missouri | 29081 | 1869 | 33 |
2395402 | 2395402 | 2022-04-11 | Greene | Alabama | 1063 | 1869 | 48 |
2392146 | 2392146 | 2022-04-10 | Greene | Alabama | 1063 | 1869 | 48 |
2388890 | 2388890 | 2022-04-09 | Greene | Alabama | 1063 | 1869 | 48 |
2385635 | 2385635 | 2022-04-08 | Greene | Alabama | 1063 | 1869 | 48 |
2336232 | 2336232 | 2022-03-23 | Crosby | Texas | 48107 | 1869 | 45 |
2332978 | 2332978 | 2022-03-22 | Crosby | Texas | 48107 | 1869 | 45 |
2329725 | 2329725 | 2022-03-21 | Crosby | Texas | 48107 | 1869 | 45 |
2326473 | 2326473 | 2022-03-20 | Crosby | Texas | 48107 | 1869 | 45 |
2323220 | 2323220 | 2022-03-19 | Crosby | Texas | 48107 | 1869 | 45 |
2267956 | 2267956 | 2022-03-02 | Gaines | Texas | 48165 | 1869 | 82 |
2264703 | 2264703 | 2022-03-01 | Gaines | Texas | 48165 | 1869 | 82 |
2261453 | 2261453 | 2022-02-28 | Gaines | Texas | 48165 | 1869 | 82 |
2256473 | 2256473 | 2022-02-27 | Russell | Kansas | 20167 | 1869 | 36 |
2258202 | 2258202 | 2022-02-27 | Gaines | Texas | 48165 | 1869 | 82 |
2253222 | 2253222 | 2022-02-26 | Russell | Kansas | 20167 | 1869 | 36 |
2254951 | 2254951 | 2022-02-26 | Gaines | Texas | 48165 | 1869 | 82 |
2249971 | 2249971 | 2022-02-25 | Russell | Kansas | 20167 | 1869 | 36 |
2251700 | 2251700 | 2022-02-25 | Gaines | Texas | 48165 | 1869 | 82 |
2228958 | 2228958 | 2022-02-18 | Hansford | Texas | 48195 | 1869 | 28 |
2171852 | 2171852 | 2022-02-01 | Clay | Kansas | 20027 | 1869 | 32 |
2167971 | 2167971 | 2022-01-31 | Lincoln | Colorado | 8073 | 1869 | 9 |
2168599 | 2168599 | 2022-01-31 | Clay | Kansas | 20027 | 1869 | 32 |
2144799 | 2144799 | 2022-01-23 | Pleasants | West Virginia | 54073 | 1869 | 32 |
2129148 | 2129148 | 2022-01-19 | Pulaski | Georgia | 13235 | 1869 | 68 |
2129397 | 2129397 | 2022-01-19 | Martin | Indiana | 18101 | 1869 | 23 |
2120623 | 2120623 | 2022-01-16 | Phelps | Nebraska | 31137 | 1869 | 11 |
2117371 | 2117371 | 2022-01-15 | Phelps | Nebraska | 31137 | 1869 | 11 |
2114120 | 2114120 | 2022-01-14 | Phelps | Nebraska | 31137 | 1869 | 11 |
2105452 | 2105452 | 2022-01-11 | Runnels | Texas | 48399 | 1869 | 56 |
2099094 | 2099094 | 2022-01-09 | Floyd | Virginia | 51063 | 1869 | 33 |
2095843 | 2095843 | 2022-01-08 | Floyd | Virginia | 51063 | 1869 | 33 |
2092591 | 2092591 | 2022-01-07 | Floyd | Virginia | 51063 | 1869 | 33 |
2088887 | 2088887 | 2022-01-06 | Roberts | South Dakota | 46109 | 1869 | 45 |
2084729 | 2084729 | 2022-01-05 | Wayne | Missouri | 29223 | 1869 | 37 |
2079647 | 2079647 | 2022-01-03 | Richmond | Virginia | 51159 | 1869 | 17 |
2076026 | 2076026 | 2022-01-02 | Childress | Texas | 48075 | 1869 | 23 |
2072775 | 2072775 | 2022-01-01 | Childress | Texas | 48075 | 1869 | 23 |
2069524 | 2069524 | 2021-12-31 | Childress | Texas | 48075 | 1869 | 23 |
2066273 | 2066273 | 2021-12-30 | Childress | Texas | 48075 | 1869 | 23 |
2059520 | 2059520 | 2021-12-28 | Yabucoa | Puerto Rico | 72151 | 1869 | |
2035004 | 2035004 | 2021-12-21 | Jasper | Illinois | 17079 | 1869 | 23 |
2037538 | 2037538 | 2021-12-21 | Forest | Wisconsin | 55041 | 1869 | 40 |
2006734 | 2006734 | 2021-12-12 | Fergus | Montana | 30027 | 1869 | 48 |
2003483 | 2003483 | 2021-12-11 | Fergus | Montana | 30027 | 1869 | 48 |
2000233 | 2000233 | 2021-12-10 | Fergus | Montana | 30027 | 1869 | 48 |
1995372 | 1995372 | 2021-12-09 | Coosa | Alabama | 1037 | 1869 | 48 |
1996909 | 1996909 | 2021-12-09 | Lewis | Missouri | 29111 | 1869 | 30 |
1983255 | 1983255 | 2021-12-05 | Brown | Kansas | 20013 | 1869 | 40 |
1980005 | 1980005 | 2021-12-04 | Brown | Kansas | 20013 | 1869 | 40 |
1976755 | 1976755 | 2021-12-03 | Brown | Kansas | 20013 | 1869 | 40 |
1974421 | 1974421 | 2021-12-02 | Colfax | New Mexico | 35007 | 1869 | 53 |
1974747 | 1974747 | 2021-12-02 | Vinton | Ohio | 39163 | 1869 | 37 |
1970870 | 1970870 | 2021-12-01 | Cedar | Missouri | 29039 | 1869 | 42 |
1960711 | 1960711 | 2021-11-28 | Todd | Kentucky | 21219 | 1869 | 33 |
1957460 | 1957460 | 2021-11-27 | Todd | Kentucky | 21219 | 1869 | 33 |
1953233 | 1953233 | 2021-11-26 | Fulton | Arkansas | 5049 | 1869 | 67 |
1954209 | 1954209 | 2021-11-26 | Todd | Kentucky | 21219 | 1869 | 33 |
1950958 | 1950958 | 2021-11-25 | Todd | Kentucky | 21219 | 1869 | 33 |
1946846 | 1946846 | 2021-11-24 | Bent | Colorado | 8011 | 1869 | 31 |
1947707 | 1947707 | 2021-11-24 | Todd | Kentucky | 21219 | 1869 | 33 |
1925532 | 1925532 | 2021-11-17 | Colfax | Nebraska | 31037 | 1869 | 22 |
1919999 | 1919999 | 2021-11-15 | Callahan | Texas | 48059 | 1869 | 57 |
1916749 | 1916749 | 2021-11-14 | Callahan | Texas | 48059 | 1869 | 57 |
1913499 | 1913499 | 2021-11-13 | Callahan | Texas | 48059 | 1869 | 57 |
1904428 | 1904428 | 2021-11-11 | Nome Census Area | Alaska | 2180 | 1869 | 2 |
1901178 | 1901178 | 2021-11-10 | Nome Census Area | Alaska | 2180 | 1869 | 2 |
1871655 | 1871655 | 2021-10-31 | Westmoreland | Virginia | 51193 | 1869 | 33 |
1868406 | 1868406 | 2021-10-30 | Westmoreland | Virginia | 51193 | 1869 | 33 |
1865157 | 1865157 | 2021-10-29 | Westmoreland | Virginia | 51193 | 1869 | 33 |
1853823 | 1853823 | 2021-10-26 | Noxubee | Mississippi | 28103 | 1869 | 40 |
1841698 | 1841698 | 2021-10-22 | Barranquitas | Puerto Rico | 72019 | 1869 | |
1838449 | 1838449 | 2021-10-21 | Barranquitas | Puerto Rico | 72019 | 1869 | |
1827700 | 1827700 | 2021-10-18 | Chippewa | Minnesota | 27023 | 1869 | 40 |
1828097 | 1828097 | 2021-10-18 | Otoe | Nebraska | 31131 | 1869 | 13 |
1814328 | 1814328 | 2021-10-14 | Nemaha | Kansas | 20131 | 1869 | 56 |
1816227 | 1816227 | 2021-10-14 | Ward | Texas | 48475 | 1869 | 27 |
1811079 | 1811079 | 2021-10-13 | Nemaha | Kansas | 20131 | 1869 | 56 |
1812482 | 1812482 | 2021-10-13 | Hatillo | Puerto Rico | 72065 | 1869 | |
1777507 | 1777507 | 2021-10-02 | Morgan | West Virginia | 54065 | 1869 | 36 |
1768890 | 1768890 | 2021-09-30 | Breathitt | Kentucky | 21025 | 1869 | 21 |
1729039 | 1729039 | 2021-09-18 | Little River | Arkansas | 5081 | 1869 | 44 |
1731231 | 1731231 | 2021-09-18 | Cabo Rojo | Puerto Rico | 72023 | 1869 | |
1726219 | 1726219 | 2021-09-17 | Gooding | Idaho | 16047 | 1869 | 28 |
1688235 | 1688235 | 2021-09-05 | Pemiscot | Missouri | 29155 | 1869 | 39 |
1684985 | 1684985 | 2021-09-04 | Pemiscot | Missouri | 29155 | 1869 | 39 |
1652082 | 1652082 | 2021-08-25 | Madison | Louisiana | 22065 | 1869 | 47 |
1647423 | 1647423 | 2021-08-23 | King George | Virginia | 51099 | 1869 | 20 |
1647493 | 1647493 | 2021-08-23 | Asotin | Washington | 53003 | 1869 | 32 |
1609114 | 1609114 | 2021-08-12 | Charlton | Georgia | 13049 | 1869 | 37 |
1610696 | 1610696 | 2021-08-12 | Warren | North Carolina | 37185 | 1869 | 20 |
1529076 | 1529076 | 2021-07-18 | Pike | Missouri | 29163 | 1869 | 27 |
1525829 | 1525829 | 2021-07-17 | Pike | Missouri | 29163 | 1869 | 27 |
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);