ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,314 rows where cases = 59 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 188
- Nebraska 179
- Idaho 172
- Georgia 102
- Virginia 87
- Kentucky 79
- Pennsylvania 69
- Missouri 67
- Minnesota 66
- Colorado 62
- Kansas 61
- Michigan 60
- North Dakota 60
- Tennessee 56
- Illinois 53
- Ohio 53
- New York 52
- Puerto Rico 52
- West Virginia 52
- Indiana 48
- Oklahoma 47
- Iowa 44
- Wisconsin 44
- South Dakota 41
- Arkansas 40
- Alaska 38
- Vermont 37
- Maine 31
- North Carolina 31
- Montana 30
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2172617 | 2172617 | 2022-02-01 | Blaine | Nebraska | 31009 | 59 | 3 |
2169364 | 2169364 | 2022-01-31 | Blaine | Nebraska | 31009 | 59 | 3 |
2166109 | 2166109 | 2022-01-30 | Blaine | Nebraska | 31009 | 59 | 3 |
2162854 | 2162854 | 2022-01-29 | Blaine | Nebraska | 31009 | 59 | 3 |
2159599 | 2159599 | 2022-01-28 | Blaine | Nebraska | 31009 | 59 | 3 |
2156345 | 2156345 | 2022-01-27 | Blaine | Nebraska | 31009 | 59 | 3 |
2153092 | 2153092 | 2022-01-26 | Blaine | Nebraska | 31009 | 59 | 3 |
2149840 | 2149840 | 2022-01-25 | Blaine | Nebraska | 31009 | 59 | 3 |
2133944 | 2133944 | 2022-01-20 | Slope | North Dakota | 38087 | 59 | 0 |
2130692 | 2130692 | 2022-01-19 | Slope | North Dakota | 38087 | 59 | 0 |
2123866 | 2123866 | 2022-01-17 | McPherson | Nebraska | 31117 | 59 | 1 |
2120614 | 2120614 | 2022-01-16 | McPherson | Nebraska | 31117 | 59 | 1 |
2117362 | 2117362 | 2022-01-15 | McPherson | Nebraska | 31117 | 59 | 1 |
2114111 | 2114111 | 2022-01-14 | McPherson | Nebraska | 31117 | 59 | 1 |
2097951 | 2097951 | 2022-01-09 | Harding | New Mexico | 35021 | 59 | 4 |
2094699 | 2094699 | 2022-01-08 | Harding | New Mexico | 35021 | 59 | 4 |
2091447 | 2091447 | 2022-01-07 | Harding | New Mexico | 35021 | 59 | 4 |
2088196 | 2088196 | 2022-01-06 | Harding | New Mexico | 35021 | 59 | 4 |
2084944 | 2084944 | 2022-01-05 | Harding | New Mexico | 35021 | 59 | 4 |
2004777 | 2004777 | 2021-12-11 | Unknown | Vermont | 59 | 0 | |
1907266 | 1907266 | 2021-11-11 | Unknown | Vermont | 59 | 0 | |
1896349 | 1896349 | 2021-11-08 | Sioux | Nebraska | 31165 | 59 | 1 |
1893099 | 1893099 | 2021-11-07 | Sioux | Nebraska | 31165 | 59 | 1 |
1889849 | 1889849 | 2021-11-06 | Sioux | Nebraska | 31165 | 59 | 1 |
1886599 | 1886599 | 2021-11-05 | Sioux | Nebraska | 31165 | 59 | 1 |
1883350 | 1883350 | 2021-11-04 | Sioux | Nebraska | 31165 | 59 | 1 |
1880101 | 1880101 | 2021-11-03 | Sioux | Nebraska | 31165 | 59 | 1 |
1880118 | 1880118 | 2021-11-03 | Esmeralda | Nevada | 32009 | 59 | 2 |
1876869 | 1876869 | 2021-11-02 | Esmeralda | Nevada | 32009 | 59 | 2 |
1872122 | 1872122 | 2021-11-01 | Hinsdale | Colorado | 8053 | 59 | 0 |
1873620 | 1873620 | 2021-11-01 | Esmeralda | Nevada | 32009 | 59 | 2 |
1868873 | 1868873 | 2021-10-31 | Hinsdale | Colorado | 8053 | 59 | 0 |
1870275 | 1870275 | 2021-10-31 | Banner | Nebraska | 31007 | 59 | 0 |
1865624 | 1865624 | 2021-10-30 | Hinsdale | Colorado | 8053 | 59 | 0 |
1867026 | 1867026 | 2021-10-30 | Banner | Nebraska | 31007 | 59 | 0 |
1862375 | 1862375 | 2021-10-29 | Hinsdale | Colorado | 8053 | 59 | 0 |
1863777 | 1863777 | 2021-10-29 | Banner | Nebraska | 31007 | 59 | 0 |
1859126 | 1859126 | 2021-10-28 | Hinsdale | Colorado | 8053 | 59 | 0 |
1855877 | 1855877 | 2021-10-27 | Hinsdale | Colorado | 8053 | 59 | 0 |
1857375 | 1857375 | 2021-10-27 | Esmeralda | Nevada | 32009 | 59 | 2 |
1789080 | 1789080 | 2021-10-06 | Grant | Nebraska | 31075 | 59 | 4 |
1785832 | 1785832 | 2021-10-05 | Grant | Nebraska | 31075 | 59 | 4 |
1782583 | 1782583 | 2021-10-04 | Grant | Nebraska | 31075 | 59 | 4 |
1763141 | 1763141 | 2021-09-28 | Wheeler | Nebraska | 31183 | 59 | 0 |
1746891 | 1746891 | 2021-09-23 | Thomas | Nebraska | 31171 | 59 | 1 |
1735476 | 1735476 | 2021-09-20 | Skagway Municipality | Alaska | 2230 | 59 | 0 |
1737397 | 1737397 | 2021-09-20 | Billings | North Dakota | 38007 | 59 | 0 |
1733851 | 1733851 | 2021-09-19 | Hayes | Nebraska | 31085 | 59 | 0 |
1730601 | 1730601 | 2021-09-18 | Hayes | Nebraska | 31085 | 59 | 0 |
1730897 | 1730897 | 2021-09-18 | Billings | North Dakota | 38007 | 59 | 0 |
1727351 | 1727351 | 2021-09-17 | Hayes | Nebraska | 31085 | 59 | 0 |
1727647 | 1727647 | 2021-09-17 | Billings | North Dakota | 38007 | 59 | 0 |
1724055 | 1724055 | 2021-09-16 | Treasure | Montana | 30103 | 59 | 1 |
1724102 | 1724102 | 2021-09-16 | Hayes | Nebraska | 31085 | 59 | 0 |
1724398 | 1724398 | 2021-09-16 | Billings | North Dakota | 38007 | 59 | 0 |
1720806 | 1720806 | 2021-09-15 | Treasure | Montana | 30103 | 59 | 1 |
1720853 | 1720853 | 2021-09-15 | Hayes | Nebraska | 31085 | 59 | 0 |
1721149 | 1721149 | 2021-09-15 | Billings | North Dakota | 38007 | 59 | 0 |
1717558 | 1717558 | 2021-09-14 | Treasure | Montana | 30103 | 59 | 1 |
1717605 | 1717605 | 2021-09-14 | Hayes | Nebraska | 31085 | 59 | 0 |
1717901 | 1717901 | 2021-09-14 | Billings | North Dakota | 38007 | 59 | 0 |
1714310 | 1714310 | 2021-09-13 | Treasure | Montana | 30103 | 59 | 1 |
1714357 | 1714357 | 2021-09-13 | Hayes | Nebraska | 31085 | 59 | 0 |
1714653 | 1714653 | 2021-09-13 | Billings | North Dakota | 38007 | 59 | 0 |
1711111 | 1711111 | 2021-09-12 | Hayes | Nebraska | 31085 | 59 | 0 |
1711407 | 1711407 | 2021-09-12 | Billings | North Dakota | 38007 | 59 | 0 |
1707864 | 1707864 | 2021-09-11 | Hayes | Nebraska | 31085 | 59 | 0 |
1708160 | 1708160 | 2021-09-11 | Billings | North Dakota | 38007 | 59 | 0 |
1704617 | 1704617 | 2021-09-10 | Hayes | Nebraska | 31085 | 59 | 0 |
1704913 | 1704913 | 2021-09-10 | Billings | North Dakota | 38007 | 59 | 0 |
1701367 | 1701367 | 2021-09-09 | Hayes | Nebraska | 31085 | 59 | 0 |
1701663 | 1701663 | 2021-09-09 | Billings | North Dakota | 38007 | 59 | 0 |
1698118 | 1698118 | 2021-09-08 | Hayes | Nebraska | 31085 | 59 | 0 |
1698414 | 1698414 | 2021-09-08 | Billings | North Dakota | 38007 | 59 | 0 |
1694870 | 1694870 | 2021-09-07 | Hayes | Nebraska | 31085 | 59 | 0 |
1695166 | 1695166 | 2021-09-07 | Billings | North Dakota | 38007 | 59 | 0 |
1691621 | 1691621 | 2021-09-06 | Hayes | Nebraska | 31085 | 59 | 0 |
1691918 | 1691918 | 2021-09-06 | Billings | North Dakota | 38007 | 59 | 0 |
1688371 | 1688371 | 2021-09-05 | Hayes | Nebraska | 31085 | 59 | 0 |
1688668 | 1688668 | 2021-09-05 | Billings | North Dakota | 38007 | 59 | 0 |
1685121 | 1685121 | 2021-09-04 | Hayes | Nebraska | 31085 | 59 | 0 |
1685418 | 1685418 | 2021-09-04 | Billings | North Dakota | 38007 | 59 | 0 |
1681870 | 1681870 | 2021-09-03 | Hayes | Nebraska | 31085 | 59 | 0 |
1682167 | 1682167 | 2021-09-03 | Billings | North Dakota | 38007 | 59 | 0 |
1678622 | 1678622 | 2021-09-02 | Hayes | Nebraska | 31085 | 59 | 0 |
1678918 | 1678918 | 2021-09-02 | Billings | North Dakota | 38007 | 59 | 0 |
1675374 | 1675374 | 2021-09-01 | Hayes | Nebraska | 31085 | 59 | 0 |
1675670 | 1675670 | 2021-09-01 | Billings | North Dakota | 38007 | 59 | 0 |
1672126 | 1672126 | 2021-08-31 | Hayes | Nebraska | 31085 | 59 | 0 |
1672423 | 1672423 | 2021-08-31 | Billings | North Dakota | 38007 | 59 | 0 |
1668879 | 1668879 | 2021-08-30 | Hayes | Nebraska | 31085 | 59 | 0 |
1665632 | 1665632 | 2021-08-29 | Hayes | Nebraska | 31085 | 59 | 0 |
1665928 | 1665928 | 2021-08-29 | Billings | North Dakota | 38007 | 59 | 0 |
1662384 | 1662384 | 2021-08-28 | Hayes | Nebraska | 31085 | 59 | 0 |
1659136 | 1659136 | 2021-08-27 | Hayes | Nebraska | 31085 | 59 | 0 |
1655887 | 1655887 | 2021-08-26 | Hayes | Nebraska | 31085 | 59 | 0 |
1652640 | 1652640 | 2021-08-25 | Hayes | Nebraska | 31085 | 59 | 0 |
1649392 | 1649392 | 2021-08-24 | Hayes | Nebraska | 31085 | 59 | 0 |
1646143 | 1646143 | 2021-08-23 | Hayes | Nebraska | 31085 | 59 | 0 |
1642894 | 1642894 | 2021-08-22 | Hayes | Nebraska | 31085 | 59 | 0 |
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);