ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
465 rows where cases = 889 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 44
- Virginia 31
- Georgia 29
- Louisiana 25
- Kentucky 21
- Kansas 18
- Vermont 17
- Arkansas 15
- North Carolina 15
- Puerto Rico 15
- Wyoming 15
- Alabama 14
- Wisconsin 14
- Iowa 13
- Montana 13
- Nebraska 13
- Colorado 12
- Missouri 12
- Idaho 9
- Mississippi 9
- Oklahoma 9
- West Virginia 9
- Washington 8
- New York 7
- South Carolina 7
- Illinois 6
- Michigan 6
- Minnesota 6
- Alaska 5
- South Dakota 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466414 | 2466414 | 2022-05-02 | Cochran | Texas | 48079 | 889 | 23 |
2463159 | 2463159 | 2022-05-01 | Cochran | Texas | 48079 | 889 | 23 |
2459903 | 2459903 | 2022-04-30 | Cochran | Texas | 48079 | 889 | 23 |
2456647 | 2456647 | 2022-04-29 | Cochran | Texas | 48079 | 889 | 23 |
2453391 | 2453391 | 2022-04-28 | Cochran | Texas | 48079 | 889 | 23 |
2441245 | 2441245 | 2022-04-25 | Phillips | Colorado | 8095 | 889 | 18 |
2437989 | 2437989 | 2022-04-24 | Phillips | Colorado | 8095 | 889 | 18 |
2434733 | 2434733 | 2022-04-23 | Phillips | Colorado | 8095 | 889 | 18 |
2431477 | 2431477 | 2022-04-22 | Phillips | Colorado | 8095 | 889 | 18 |
2428221 | 2428221 | 2022-04-21 | Phillips | Colorado | 8095 | 889 | 18 |
2429800 | 2429800 | 2022-04-21 | Hamilton | New York | 36041 | 889 | 5 |
2424965 | 2424965 | 2022-04-20 | Phillips | Colorado | 8095 | 889 | 18 |
2421709 | 2421709 | 2022-04-19 | Phillips | Colorado | 8095 | 889 | 18 |
2333236 | 2333236 | 2022-03-22 | Bath | Virginia | 51017 | 889 | 20 |
2329983 | 2329983 | 2022-03-21 | Bath | Virginia | 51017 | 889 | 20 |
2267977 | 2267977 | 2022-03-02 | Haskell | Texas | 48207 | 889 | 39 |
2262085 | 2262085 | 2022-03-01 | Unknown | Alaska | 889 | 1 | |
2258834 | 2258834 | 2022-02-28 | Unknown | Alaska | 889 | 1 | |
2197554 | 2197554 | 2022-02-09 | Lincoln | Idaho | 16063 | 889 | 14 |
2160667 | 2160667 | 2022-01-28 | Hudspeth | Texas | 48229 | 889 | 16 |
2157392 | 2157392 | 2022-01-27 | Hall | Texas | 48191 | 889 | 19 |
2152438 | 2152438 | 2022-01-26 | Carlisle | Kentucky | 21039 | 889 | 16 |
2154139 | 2154139 | 2022-01-26 | Hall | Texas | 48191 | 889 | 19 |
2150887 | 2150887 | 2022-01-25 | Hall | Texas | 48191 | 889 | 19 |
2122701 | 2122701 | 2022-01-17 | Boise | Idaho | 16015 | 889 | 11 |
2125095 | 2125095 | 2022-01-17 | Craig | Virginia | 51045 | 889 | 11 |
2119449 | 2119449 | 2022-01-16 | Boise | Idaho | 16015 | 889 | 11 |
2120639 | 2120639 | 2022-01-16 | Thayer | Nebraska | 31169 | 889 | 8 |
2116197 | 2116197 | 2022-01-15 | Boise | Idaho | 16015 | 889 | 11 |
2117387 | 2117387 | 2022-01-15 | Thayer | Nebraska | 31169 | 889 | 8 |
2114136 | 2114136 | 2022-01-14 | Thayer | Nebraska | 31169 | 889 | 8 |
2106466 | 2106466 | 2022-01-12 | Lewis | Idaho | 16061 | 889 | 23 |
2107240 | 2107240 | 2022-01-12 | Kittson | Minnesota | 27069 | 889 | 25 |
2084891 | 2084891 | 2022-01-05 | Lander | Nevada | 32015 | 889 | 16 |
2078310 | 2078310 | 2022-01-03 | Dixon | Nebraska | 31051 | 889 | 11 |
2051580 | 2051580 | 2021-12-26 | Ottawa | Kansas | 20143 | 889 | 15 |
2048330 | 2048330 | 2021-12-25 | Ottawa | Kansas | 20143 | 889 | 15 |
2045080 | 2045080 | 2021-12-24 | Ottawa | Kansas | 20143 | 889 | 15 |
2041831 | 2041831 | 2021-12-23 | Ottawa | Kansas | 20143 | 889 | 15 |
2038581 | 2038581 | 2021-12-22 | Ottawa | Kansas | 20143 | 889 | 15 |
2024019 | 2024019 | 2021-12-17 | Carson | Texas | 48065 | 889 | 28 |
1975837 | 1975837 | 2021-12-02 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1972588 | 1972588 | 2021-12-01 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1969338 | 1969338 | 2021-11-30 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1966088 | 1966088 | 2021-11-29 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1962836 | 1962836 | 2021-11-28 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1959585 | 1959585 | 2021-11-27 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1956334 | 1956334 | 2021-11-26 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1953083 | 1953083 | 2021-11-25 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1949832 | 1949832 | 2021-11-24 | Hot Springs | Wyoming | 56017 | 889 | 10 |
1941814 | 1941814 | 2021-11-22 | Kearney | Nebraska | 31099 | 889 | 6 |
1928811 | 1928811 | 2021-11-18 | Jefferson | Nebraska | 31095 | 889 | 3 |
1923270 | 1923270 | 2021-11-16 | Crane | Texas | 48103 | 889 | 19 |
1919169 | 1919169 | 2021-11-15 | Guadalupe | New Mexico | 35019 | 889 | 15 |
1920021 | 1920021 | 2021-11-15 | Crane | Texas | 48103 | 889 | 19 |
1916771 | 1916771 | 2021-11-14 | Crane | Texas | 48103 | 889 | 19 |
1858927 | 1858927 | 2021-10-28 | Dillingham Census Area | Alaska | 2070 | 889 | 6 |
1858610 | 1858610 | 2021-10-27 | Mathews | Virginia | 51115 | 889 | 21 |
1851137 | 1851137 | 2021-10-25 | McHenry | North Dakota | 38049 | 889 | 23 |
1834651 | 1834651 | 2021-10-20 | Unknown | New Hampshire | 889 | 1 | |
1824904 | 1824904 | 2021-10-17 | Unknown | New Hampshire | 889 | 1 | |
1821655 | 1821655 | 2021-10-16 | Unknown | New Hampshire | 889 | 1 | |
1818406 | 1818406 | 2021-10-15 | Unknown | New Hampshire | 889 | 1 | |
1814676 | 1814676 | 2021-10-14 | Oscoda | Michigan | 26135 | 889 | 33 |
1811428 | 1811428 | 2021-10-13 | Oscoda | Michigan | 26135 | 889 | 33 |
1807803 | 1807803 | 2021-10-12 | Harper | Kansas | 20077 | 889 | 19 |
1804552 | 1804552 | 2021-10-11 | Harper | Kansas | 20077 | 889 | 19 |
1792342 | 1792342 | 2021-10-07 | Keith | Nebraska | 31101 | 889 | 10 |
1786609 | 1786609 | 2021-10-05 | Fall River | South Dakota | 46047 | 889 | 22 |
1786872 | 1786872 | 2021-10-05 | Jim Hogg | Texas | 48247 | 889 | 20 |
1783623 | 1783623 | 2021-10-04 | Jim Hogg | Texas | 48247 | 889 | 20 |
1780374 | 1780374 | 2021-10-03 | Jim Hogg | Texas | 48247 | 889 | 20 |
1777124 | 1777124 | 2021-10-02 | Jim Hogg | Texas | 48247 | 889 | 20 |
1773874 | 1773874 | 2021-10-01 | Jim Hogg | Texas | 48247 | 889 | 20 |
1769886 | 1769886 | 2021-09-30 | Bottineau | North Dakota | 38009 | 889 | 20 |
1770624 | 1770624 | 2021-09-30 | Jim Hogg | Texas | 48247 | 889 | 20 |
1767375 | 1767375 | 2021-09-29 | Jim Hogg | Texas | 48247 | 889 | 20 |
1763545 | 1763545 | 2021-09-28 | Cotton | Oklahoma | 40033 | 889 | 18 |
1758198 | 1758198 | 2021-09-27 | Aleutians West Census Area | Alaska | 2016 | 889 | 0 |
1760296 | 1760296 | 2021-09-27 | Cotton | Oklahoma | 40033 | 889 | 18 |
1760369 | 1760369 | 2021-09-27 | Grant | Oregon | 41023 | 889 | 9 |
1757048 | 1757048 | 2021-09-26 | Cotton | Oklahoma | 40033 | 889 | 18 |
1753800 | 1753800 | 2021-09-25 | Cotton | Oklahoma | 40033 | 889 | 18 |
1750552 | 1750552 | 2021-09-24 | Cotton | Oklahoma | 40033 | 889 | 18 |
1746379 | 1746379 | 2021-09-23 | Alcona | Michigan | 26001 | 889 | 39 |
1747302 | 1747302 | 2021-09-23 | Cotton | Oklahoma | 40033 | 889 | 18 |
1743130 | 1743130 | 2021-09-22 | Alcona | Michigan | 26001 | 889 | 39 |
1743579 | 1743579 | 2021-09-22 | Dawes | Nebraska | 31045 | 889 | 20 |
1744053 | 1744053 | 2021-09-22 | Cotton | Oklahoma | 40033 | 889 | 18 |
1744716 | 1744716 | 2021-09-22 | San Saba | Texas | 48411 | 889 | 25 |
1738463 | 1738463 | 2021-09-20 | Jefferson | Washington | 53031 | 889 | 12 |
1717304 | 1717304 | 2021-09-14 | Wilkin | Minnesota | 27167 | 889 | 14 |
1709607 | 1709607 | 2021-09-12 | Mariposa | California | 6043 | 889 | 10 |
1710428 | 1710428 | 2021-09-12 | Crittenden | Kentucky | 21055 | 889 | 28 |
1706360 | 1706360 | 2021-09-11 | Mariposa | California | 6043 | 889 | 10 |
1707181 | 1707181 | 2021-09-11 | Crittenden | Kentucky | 21055 | 889 | 28 |
1703112 | 1703112 | 2021-09-10 | Mariposa | California | 6043 | 889 | 10 |
1703933 | 1703933 | 2021-09-10 | Crittenden | Kentucky | 21055 | 889 | 28 |
1693782 | 1693782 | 2021-09-07 | Edwards | Illinois | 17047 | 889 | 14 |
1685801 | 1685801 | 2021-09-04 | Rincon | Puerto Rico | 72117 | 889 |
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);