ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
254 rows where cases = 1896 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 21
- Georgia 18
- Arkansas 16
- Kentucky 14
- Indiana 13
- Texas 13
- Oklahoma 12
- Alabama 11
- Illinois 11
- Iowa 10
- North Carolina 10
- Puerto Rico 8
- Virginia 8
- Wisconsin 7
- Louisiana 6
- Massachusetts 6
- Nebraska 6
- Idaho 5
- Kansas 5
- Missouri 5
- Michigan 4
- New York 4
- Ohio 4
- Tennessee 4
- California 3
- North Dakota 3
- Oregon 3
- Vermont 3
- West Virginia 3
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284753 | 2284753 | 2022-03-07 | Platte | Wyoming | 56031 | 1896 | 39 |
2267971 | 2267971 | 2022-03-02 | Hansford | Texas | 48195 | 1896 | 29 |
2264718 | 2264718 | 2022-03-01 | Hansford | Texas | 48195 | 1896 | 28 |
2246907 | 2246907 | 2022-02-24 | St. Helena | Louisiana | 22091 | 1896 | 23 |
2221490 | 2221490 | 2022-02-16 | Unknown | Nebraska | 1896 | 398 | |
2211665 | 2211665 | 2022-02-13 | Cheyenne | Nebraska | 31033 | 1896 | 23 |
2208412 | 2208412 | 2022-02-12 | Cheyenne | Nebraska | 31033 | 1896 | 23 |
2205159 | 2205159 | 2022-02-11 | Cheyenne | Nebraska | 31033 | 1896 | 23 |
2171465 | 2171465 | 2022-02-01 | Taylor | Georgia | 13269 | 1896 | 48 |
2172561 | 2172561 | 2022-02-01 | Carbon | Montana | 30009 | 1896 | 27 |
2154844 | 2154844 | 2022-01-27 | Searcy | Arkansas | 5129 | 1896 | 37 |
2155081 | 2155081 | 2022-01-27 | Candler | Georgia | 13043 | 1896 | 91 |
2149709 | 2149709 | 2022-01-25 | Iron | Missouri | 29093 | 1896 | 33 |
2132650 | 2132650 | 2022-01-20 | Martin | Indiana | 18101 | 1896 | 23 |
2134669 | 2134669 | 2022-01-20 | Live Oak | Texas | 48297 | 1896 | 39 |
2125937 | 2125937 | 2022-01-18 | Wilkinson | Georgia | 13319 | 1896 | 48 |
2122600 | 2122600 | 2022-01-17 | Heard | Georgia | 13149 | 1896 | 43 |
2085620 | 2085620 | 2022-01-05 | Lake | South Dakota | 46079 | 1896 | 22 |
2078151 | 2078151 | 2022-01-03 | Grundy | Missouri | 29079 | 1896 | 58 |
2032644 | 2032644 | 2021-12-20 | Douglas | Missouri | 29067 | 1896 | 63 |
2016326 | 2016326 | 2021-12-15 | Noxubee | Mississippi | 28103 | 1896 | 44 |
2010100 | 2010100 | 2021-12-13 | Red Willow | Nebraska | 31145 | 1896 | 16 |
2001523 | 2001523 | 2021-12-10 | Orange | Vermont | 50017 | 1896 | 8 |
1996257 | 1996257 | 2021-12-09 | Brown | Kansas | 20013 | 1896 | 40 |
1993006 | 1993006 | 2021-12-08 | Brown | Kansas | 20013 | 1896 | 40 |
1972815 | 1972815 | 2021-12-02 | Mono | California | 6051 | 1896 | 4 |
1927171 | 1927171 | 2021-11-18 | Ketchikan Gateway Borough | Alaska | 2130 | 1896 | 11 |
1908196 | 1908196 | 2021-11-12 | Washington | Idaho | 16087 | 1896 | 47 |
1904947 | 1904947 | 2021-11-11 | Washington | Idaho | 16087 | 1896 | 47 |
1901697 | 1901697 | 2021-11-10 | Washington | Idaho | 16087 | 1896 | 47 |
1898447 | 1898447 | 2021-11-09 | Washington | Idaho | 16087 | 1896 | 47 |
1884863 | 1884863 | 2021-11-05 | Conecuh | Alabama | 1035 | 1896 | 60 |
1883850 | 1883850 | 2021-11-04 | Morrow | Oregon | 41049 | 1896 | 23 |
1880355 | 1880355 | 2021-11-03 | Barnes | North Dakota | 38003 | 1896 | 34 |
1861219 | 1861219 | 2021-10-28 | Hatillo | Puerto Rico | 72065 | 1896 | |
1851969 | 1851969 | 2021-10-25 | Ward | Texas | 48475 | 1896 | 28 |
1845988 | 1845988 | 2021-10-24 | Desha | Arkansas | 5041 | 1896 | 32 |
1848719 | 1848719 | 2021-10-24 | Ward | Texas | 48475 | 1896 | 28 |
1848849 | 1848849 | 2021-10-24 | King William | Virginia | 51101 | 1896 | 24 |
1842738 | 1842738 | 2021-10-23 | Desha | Arkansas | 5041 | 1896 | 32 |
1845599 | 1845599 | 2021-10-23 | King William | Virginia | 51101 | 1896 | 24 |
1842349 | 1842349 | 2021-10-22 | King William | Virginia | 51101 | 1896 | 24 |
1830229 | 1830229 | 2021-10-19 | Cumberland | Illinois | 17035 | 1896 | 38 |
1822215 | 1822215 | 2021-10-16 | Cidra | Puerto Rico | 72041 | 1896 | |
1818966 | 1818966 | 2021-10-15 | Cidra | Puerto Rico | 72041 | 1896 | |
1807682 | 1807682 | 2021-10-12 | Cherokee | Iowa | 19035 | 1896 | 41 |
1804431 | 1804431 | 2021-10-11 | Cherokee | Iowa | 19035 | 1896 | 41 |
1801182 | 1801182 | 2021-10-10 | Cherokee | Iowa | 19035 | 1896 | 41 |
1797933 | 1797933 | 2021-10-09 | Cherokee | Iowa | 19035 | 1896 | 41 |
1794684 | 1794684 | 2021-10-08 | Cherokee | Iowa | 19035 | 1896 | 41 |
1791436 | 1791436 | 2021-10-07 | Cherokee | Iowa | 19035 | 1896 | 41 |
1792964 | 1792964 | 2021-10-07 | Cabo Rojo | Puerto Rico | 72023 | 1896 | |
1788187 | 1788187 | 2021-10-06 | Cherokee | Iowa | 19035 | 1896 | 41 |
1789629 | 1789629 | 2021-10-06 | Tillamook | Oregon | 41057 | 1896 | 24 |
1778863 | 1778863 | 2021-10-03 | Nantucket | Massachusetts | 25019 | 1896 | 0 |
1775613 | 1775613 | 2021-10-02 | Nantucket | Massachusetts | 25019 | 1896 | 0 |
1772363 | 1772363 | 2021-10-01 | Nantucket | Massachusetts | 25019 | 1896 | 0 |
1769114 | 1769114 | 2021-09-30 | Nantucket | Massachusetts | 25019 | 1896 | 0 |
1764538 | 1764538 | 2021-09-28 | Burnett | Wisconsin | 55013 | 1896 | 29 |
1751307 | 1751307 | 2021-09-24 | Windham | Vermont | 50025 | 1896 | 22 |
1721172 | 1721172 | 2021-09-15 | McKenzie | North Dakota | 38053 | 1896 | 15 |
1721489 | 1721489 | 2021-09-15 | Cayey | Puerto Rico | 72035 | 1896 | |
1716920 | 1716920 | 2021-09-14 | Clinton | Kentucky | 21053 | 1896 | 33 |
1713778 | 1713778 | 2021-09-13 | Caldwell | Louisiana | 22021 | 1896 | 35 |
1680029 | 1680029 | 2021-09-02 | Lincoln | West Virginia | 54043 | 1896 | 27 |
1676826 | 1676826 | 2021-09-01 | Crawford | Wisconsin | 55023 | 1896 | 21 |
1667931 | 1667931 | 2021-08-30 | Parke | Indiana | 18121 | 1896 | 18 |
1664960 | 1664960 | 2021-08-29 | Garrard | Kentucky | 21079 | 1896 | 37 |
1665227 | 1665227 | 2021-08-29 | Ogemaw | Michigan | 26129 | 1896 | 44 |
1661712 | 1661712 | 2021-08-28 | Garrard | Kentucky | 21079 | 1896 | 37 |
1661979 | 1661979 | 2021-08-28 | Ogemaw | Michigan | 26129 | 1896 | 44 |
1658464 | 1658464 | 2021-08-27 | Garrard | Kentucky | 21079 | 1896 | 37 |
1658731 | 1658731 | 2021-08-27 | Ogemaw | Michigan | 26129 | 1896 | 44 |
1649842 | 1649842 | 2021-08-24 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1646593 | 1646593 | 2021-08-23 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1642740 | 1642740 | 2021-08-22 | Macon | Missouri | 29121 | 1896 | 19 |
1643344 | 1643344 | 2021-08-22 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1640094 | 1640094 | 2021-08-21 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1636844 | 1636844 | 2021-08-20 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1633594 | 1633594 | 2021-08-19 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1630347 | 1630347 | 2021-08-18 | Choctaw | Oklahoma | 40023 | 1896 | 28 |
1626850 | 1626850 | 2021-08-17 | Bertie | North Carolina | 37015 | 1896 | 46 |
1622106 | 1622106 | 2021-08-16 | Charlton | Georgia | 13049 | 1896 | 38 |
1606224 | 1606224 | 2021-08-11 | Rush | Indiana | 18139 | 1896 | 27 |
1602897 | 1602897 | 2021-08-10 | Warren | Illinois | 17187 | 1896 | 53 |
1603141 | 1603141 | 2021-08-10 | Jefferson | Kansas | 20087 | 1896 | 40 |
1599633 | 1599633 | 2021-08-09 | Richland | Illinois | 17159 | 1896 | 52 |
1599892 | 1599892 | 2021-08-09 | Jefferson | Kansas | 20087 | 1896 | 40 |
1582841 | 1582841 | 2021-08-04 | Franklin | Arkansas | 5047 | 1896 | 40 |
1557419 | 1557419 | 2021-07-27 | Wayne | Illinois | 17191 | 1896 | 54 |
1543525 | 1543525 | 2021-07-22 | Scott | Virginia | 51169 | 1896 | 60 |
1531509 | 1531509 | 2021-07-19 | Perry | Indiana | 18123 | 1896 | 40 |
1532533 | 1532533 | 2021-07-19 | Sullivan | New Hampshire | 33019 | 1896 | 27 |
1527634 | 1527634 | 2021-07-18 | Grant | Arkansas | 5053 | 1896 | 38 |
1527893 | 1527893 | 2021-07-18 | Banks | Georgia | 13011 | 1896 | 39 |
1528262 | 1528262 | 2021-07-18 | Perry | Indiana | 18123 | 1896 | 40 |
1524387 | 1524387 | 2021-07-17 | Grant | Arkansas | 5053 | 1896 | 38 |
1524646 | 1524646 | 2021-07-17 | Banks | Georgia | 13011 | 1896 | 39 |
1525015 | 1525015 | 2021-07-17 | Perry | Indiana | 18123 | 1896 | 40 |
1521139 | 1521139 | 2021-07-16 | Grant | Arkansas | 5053 | 1896 | 38 |
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);