ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,560 rows where cases = 86 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 154
- Colorado 82
- Kentucky 69
- Georgia 68
- Virginia 68
- Missouri 57
- Puerto Rico 56
- Alaska 54
- Minnesota 52
- Nebraska 52
- Iowa 48
- Illinois 44
- Wisconsin 43
- Kansas 41
- South Dakota 40
- Montana 39
- Pennsylvania 38
- Mississippi 37
- Oklahoma 34
- Michigan 32
- New York 30
- Ohio 30
- Tennessee 28
- Idaho 27
- North Carolina 26
- Alabama 25
- Arkansas 25
- Indiana 23
- Louisiana 23
- West Virginia 21
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502337 | 2502337 | 2022-05-13 | Kenedy | Texas | 48261 | 86 | 2 |
2499079 | 2499079 | 2022-05-12 | Kenedy | Texas | 48261 | 86 | 2 |
2495821 | 2495821 | 2022-05-11 | Kenedy | Texas | 48261 | 86 | 2 |
2492563 | 2492563 | 2022-05-10 | Kenedy | Texas | 48261 | 86 | 2 |
2489305 | 2489305 | 2022-05-09 | Kenedy | Texas | 48261 | 86 | 2 |
2486048 | 2486048 | 2022-05-08 | Kenedy | Texas | 48261 | 86 | 2 |
2482790 | 2482790 | 2022-05-07 | Kenedy | Texas | 48261 | 86 | 2 |
2479532 | 2479532 | 2022-05-06 | Kenedy | Texas | 48261 | 86 | 2 |
2476274 | 2476274 | 2022-05-05 | Kenedy | Texas | 48261 | 86 | 2 |
2172670 | 2172670 | 2022-02-01 | Loup | Nebraska | 31115 | 86 | 0 |
2169417 | 2169417 | 2022-01-31 | Loup | Nebraska | 31115 | 86 | 0 |
2131285 | 2131285 | 2022-01-19 | Borden | Texas | 48033 | 86 | 2 |
2097881 | 2097881 | 2022-01-09 | Thomas | Nebraska | 31171 | 86 | 1 |
2094629 | 2094629 | 2022-01-08 | Thomas | Nebraska | 31171 | 86 | 1 |
2091377 | 2091377 | 2022-01-07 | Thomas | Nebraska | 31171 | 86 | 1 |
2088126 | 2088126 | 2022-01-06 | Thomas | Nebraska | 31171 | 86 | 1 |
2020172 | 2020172 | 2021-12-16 | Unknown | Northern Mariana Islands | 86 | 0 | |
1993811 | 1993811 | 2021-12-08 | Grant | Nebraska | 31075 | 86 | 5 |
1990560 | 1990560 | 2021-12-07 | Grant | Nebraska | 31075 | 86 | 5 |
1982440 | 1982440 | 2021-12-05 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1979190 | 1979190 | 2021-12-04 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1975940 | 1975940 | 2021-12-03 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1972691 | 1972691 | 2021-12-02 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1974315 | 1974315 | 2021-12-02 | Hayes | Nebraska | 31085 | 86 | 0 |
1971066 | 1971066 | 2021-12-01 | Hayes | Nebraska | 31085 | 86 | 0 |
1967816 | 1967816 | 2021-11-30 | Hayes | Nebraska | 31085 | 86 | 0 |
1964564 | 1964564 | 2021-11-29 | Hayes | Nebraska | 31085 | 86 | 0 |
1930917 | 1930917 | 2021-11-19 | Clark | Idaho | 16033 | 86 | 0 |
1927667 | 1927667 | 2021-11-18 | Clark | Idaho | 16033 | 86 | 0 |
1923931 | 1923931 | 2021-11-17 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1924417 | 1924417 | 2021-11-17 | Clark | Idaho | 16033 | 86 | 0 |
1920682 | 1920682 | 2021-11-16 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1921168 | 1921168 | 2021-11-16 | Clark | Idaho | 16033 | 86 | 0 |
1917432 | 1917432 | 2021-11-15 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1917918 | 1917918 | 2021-11-15 | Clark | Idaho | 16033 | 86 | 0 |
1914182 | 1914182 | 2021-11-14 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1910932 | 1910932 | 2021-11-13 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1907683 | 1907683 | 2021-11-12 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1904434 | 1904434 | 2021-11-11 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1901184 | 1901184 | 2021-11-10 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1897934 | 1897934 | 2021-11-09 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1894684 | 1894684 | 2021-11-08 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1891434 | 1891434 | 2021-11-07 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1888184 | 1888184 | 2021-11-06 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1884934 | 1884934 | 2021-11-05 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1878436 | 1878436 | 2021-11-03 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1875187 | 1875187 | 2021-11-02 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1871938 | 1871938 | 2021-11-01 | Skagway Municipality | Alaska | 2230 | 86 | 0 |
1854022 | 1854022 | 2021-10-26 | Treasure | Montana | 30103 | 86 | 1 |
1799128 | 1799128 | 2021-10-09 | Billings | North Dakota | 38007 | 86 | 0 |
1751206 | 1751206 | 2021-09-24 | Roberts | Texas | 48393 | 86 | 1 |
1747957 | 1747957 | 2021-09-23 | Roberts | Texas | 48393 | 86 | 1 |
1744707 | 1744707 | 2021-09-22 | Roberts | Texas | 48393 | 86 | 1 |
1719441 | 1719441 | 2021-09-15 | San Juan | Colorado | 8111 | 86 | 1 |
1716193 | 1716193 | 2021-09-14 | San Juan | Colorado | 8111 | 86 | 1 |
1712947 | 1712947 | 2021-09-13 | San Juan | Colorado | 8111 | 86 | 1 |
1709700 | 1709700 | 2021-09-12 | San Juan | Colorado | 8111 | 86 | 1 |
1706453 | 1706453 | 2021-09-11 | San Juan | Colorado | 8111 | 86 | 1 |
1703205 | 1703205 | 2021-09-10 | San Juan | Colorado | 8111 | 86 | 1 |
1677210 | 1677210 | 2021-09-02 | San Juan | Colorado | 8111 | 86 | 0 |
1673963 | 1673963 | 2021-09-01 | San Juan | Colorado | 8111 | 86 | 0 |
1670715 | 1670715 | 2021-08-31 | San Juan | Colorado | 8111 | 86 | 0 |
1667468 | 1667468 | 2021-08-30 | San Juan | Colorado | 8111 | 86 | 0 |
1664221 | 1664221 | 2021-08-29 | San Juan | Colorado | 8111 | 86 | 0 |
1660973 | 1660973 | 2021-08-28 | San Juan | Colorado | 8111 | 86 | 0 |
1657725 | 1657725 | 2021-08-27 | San Juan | Colorado | 8111 | 86 | 0 |
1618538 | 1618538 | 2021-08-15 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1615290 | 1615290 | 2021-08-14 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1612041 | 1612041 | 2021-08-13 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1608794 | 1608794 | 2021-08-12 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1605545 | 1605545 | 2021-08-11 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1602295 | 1602295 | 2021-08-10 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1599047 | 1599047 | 2021-08-09 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1595798 | 1595798 | 2021-08-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1592549 | 1592549 | 2021-08-07 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1589300 | 1589300 | 2021-08-06 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1586051 | 1586051 | 2021-08-05 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1582801 | 1582801 | 2021-08-04 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1582939 | 1582939 | 2021-08-04 | Sierra | California | 6091 | 86 | 0 |
1579551 | 1579551 | 2021-08-03 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1563311 | 1563311 | 2021-07-29 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1565473 | 1565473 | 2021-07-29 | Sherman | Oregon | 41055 | 86 | 2 |
1566003 | 1566003 | 2021-07-29 | McMullen | Texas | 48311 | 86 | 5 |
1560063 | 1560063 | 2021-07-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1562755 | 1562755 | 2021-07-28 | McMullen | Texas | 48311 | 86 | 5 |
1559507 | 1559507 | 2021-07-27 | McMullen | Texas | 48311 | 86 | 5 |
1556260 | 1556260 | 2021-07-26 | McMullen | Texas | 48311 | 86 | 5 |
1553013 | 1553013 | 2021-07-25 | McMullen | Texas | 48311 | 86 | 5 |
1549766 | 1549766 | 2021-07-24 | McMullen | Texas | 48311 | 86 | 5 |
1546519 | 1546519 | 2021-07-23 | McMullen | Texas | 48311 | 86 | 5 |
1426961 | 1426961 | 2021-06-17 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1423715 | 1423715 | 2021-06-16 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1420468 | 1420468 | 2021-06-15 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1417223 | 1417223 | 2021-06-14 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1268087 | 1268087 | 2021-04-29 | Mineral | Colorado | 8079 | 86 | 1 |
1264840 | 1264840 | 2021-04-28 | Mineral | Colorado | 8079 | 86 | 1 |
1261593 | 1261593 | 2021-04-27 | Mineral | Colorado | 8079 | 86 | 1 |
1258346 | 1258346 | 2021-04-26 | Mineral | Colorado | 8079 | 86 | 1 |
1255099 | 1255099 | 2021-04-25 | Mineral | Colorado | 8079 | 86 | 1 |
1251852 | 1251852 | 2021-04-24 | Mineral | Colorado | 8079 | 86 | 1 |
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);