ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
961 rows where cases = 192 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 90
- Montana 61
- Nebraska 54
- Georgia 47
- Puerto Rico 44
- Kansas 43
- Kentucky 38
- Missouri 34
- Virginia 32
- North Dakota 29
- Indiana 27
- Michigan 27
- Colorado 26
- Ohio 25
- North Carolina 23
- Minnesota 22
- Alaska 20
- Illinois 20
- Iowa 20
- Mississippi 19
- New York 19
- Washington 19
- Louisiana 18
- South Dakota 18
- Arkansas 16
- Alabama 15
- Idaho 14
- Wisconsin 14
- Oklahoma 13
- Oregon 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482810 | 2482810 | 2022-05-07 | Loving | Texas | 48301 | 192 | 1 |
2288314 | 2288314 | 2022-03-09 | San Juan | Colorado | 8111 | 192 | 0 |
2285063 | 2285063 | 2022-03-08 | San Juan | Colorado | 8111 | 192 | 0 |
2189917 | 2189917 | 2022-02-06 | Glasscock | Texas | 48173 | 192 | 3 |
2186664 | 2186664 | 2022-02-05 | Glasscock | Texas | 48173 | 192 | 3 |
2160684 | 2160684 | 2022-01-28 | Kent | Texas | 48263 | 192 | 3 |
2153086 | 2153086 | 2022-01-26 | Wibaux | Montana | 30109 | 192 | 8 |
2149834 | 2149834 | 2022-01-25 | Wibaux | Montana | 30109 | 192 | 8 |
2150660 | 2150660 | 2022-01-25 | Harding | South Dakota | 46063 | 192 | 3 |
2147408 | 2147408 | 2022-01-24 | Harding | South Dakota | 46063 | 192 | 3 |
2144154 | 2144154 | 2022-01-23 | Harding | South Dakota | 46063 | 192 | 3 |
2140899 | 2140899 | 2022-01-22 | Harding | South Dakota | 46063 | 192 | 3 |
2137643 | 2137643 | 2022-01-21 | Harding | South Dakota | 46063 | 192 | 3 |
2128927 | 2128927 | 2022-01-19 | Mineral | Colorado | 8079 | 192 | 1 |
2098923 | 2098923 | 2022-01-09 | Motley | Texas | 48345 | 192 | 9 |
2079317 | 2079317 | 2022-01-03 | Foard | Texas | 48155 | 192 | 10 |
2039853 | 2039853 | 2021-12-22 | Gilliam | Oregon | 41021 | 192 | 4 |
2036603 | 2036603 | 2021-12-21 | Gilliam | Oregon | 41021 | 192 | 4 |
2032767 | 2032767 | 2021-12-20 | Prairie | Montana | 30079 | 192 | 2 |
1975075 | 1975075 | 2021-12-02 | Campbell | South Dakota | 46021 | 192 | 5 |
1968846 | 1968846 | 2021-11-30 | Irion | Texas | 48235 | 192 | 2 |
1965595 | 1965595 | 2021-11-29 | Irion | Texas | 48235 | 192 | 2 |
1965841 | 1965841 | 2021-11-29 | Highland | Virginia | 51091 | 192 | 4 |
1962343 | 1962343 | 2021-11-28 | Irion | Texas | 48235 | 192 | 2 |
1959092 | 1959092 | 2021-11-27 | Irion | Texas | 48235 | 192 | 2 |
1955841 | 1955841 | 2021-11-26 | Irion | Texas | 48235 | 192 | 2 |
1952590 | 1952590 | 2021-11-25 | Irion | Texas | 48235 | 192 | 2 |
1949339 | 1949339 | 2021-11-24 | Irion | Texas | 48235 | 192 | 2 |
1944292 | 1944292 | 2021-11-23 | Lane | Kansas | 20101 | 192 | 8 |
1946088 | 1946088 | 2021-11-23 | Irion | Texas | 48235 | 192 | 2 |
1941042 | 1941042 | 2021-11-22 | Lane | Kansas | 20101 | 192 | 8 |
1942837 | 1942837 | 2021-11-22 | Irion | Texas | 48235 | 192 | 2 |
1939587 | 1939587 | 2021-11-21 | Irion | Texas | 48235 | 192 | 2 |
1936337 | 1936337 | 2021-11-20 | Irion | Texas | 48235 | 192 | 2 |
1933087 | 1933087 | 2021-11-19 | Irion | Texas | 48235 | 192 | 2 |
1929836 | 1929836 | 2021-11-18 | Irion | Texas | 48235 | 192 | 2 |
1880844 | 1880844 | 2021-11-03 | Hyde | South Dakota | 46069 | 192 | 2 |
1877595 | 1877595 | 2021-11-02 | Hyde | South Dakota | 46069 | 192 | 2 |
1864150 | 1864150 | 2021-10-29 | Sheridan | North Dakota | 38083 | 192 | 3 |
1826637 | 1826637 | 2021-10-18 | Kiowa | Colorado | 8061 | 192 | 4 |
1790714 | 1790714 | 2021-10-07 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 192 | 2 |
1792659 | 1792659 | 2021-10-07 | Oliver | North Dakota | 38065 | 192 | 3 |
1785903 | 1785903 | 2021-10-05 | Storey | Nevada | 32029 | 192 | 4 |
1756324 | 1756324 | 2021-09-26 | Issaquena | Mississippi | 28055 | 192 | 6 |
1753076 | 1753076 | 2021-09-25 | Issaquena | Mississippi | 28055 | 192 | 6 |
1749828 | 1749828 | 2021-09-24 | Issaquena | Mississippi | 28055 | 192 | 6 |
1746578 | 1746578 | 2021-09-23 | Issaquena | Mississippi | 28055 | 192 | 6 |
1743329 | 1743329 | 2021-09-22 | Issaquena | Mississippi | 28055 | 192 | 6 |
1743530 | 1743530 | 2021-09-22 | Meagher | Montana | 30059 | 192 | 7 |
1738459 | 1738459 | 2021-09-20 | Garfield | Washington | 53023 | 192 | 7 |
1717177 | 1717177 | 2021-09-14 | Keweenaw | Michigan | 26083 | 192 | 2 |
1713929 | 1713929 | 2021-09-13 | Keweenaw | Michigan | 26083 | 192 | 2 |
1649322 | 1649322 | 2021-08-24 | McCone | Montana | 30055 | 192 | 2 |
1646073 | 1646073 | 2021-08-23 | McCone | Montana | 30055 | 192 | 2 |
1646098 | 1646098 | 2021-08-23 | Wheatland | Montana | 30107 | 192 | 9 |
1647671 | 1647671 | 2021-08-23 | Niobrara | Wyoming | 56027 | 192 | 3 |
1642095 | 1642095 | 2021-08-22 | Comanche | Kansas | 20033 | 192 | 11 |
1642824 | 1642824 | 2021-08-22 | McCone | Montana | 30055 | 192 | 2 |
1642849 | 1642849 | 2021-08-22 | Wheatland | Montana | 30107 | 192 | 9 |
1644422 | 1644422 | 2021-08-22 | Niobrara | Wyoming | 56027 | 192 | 3 |
1638845 | 1638845 | 2021-08-21 | Comanche | Kansas | 20033 | 192 | 11 |
1639574 | 1639574 | 2021-08-21 | McCone | Montana | 30055 | 192 | 2 |
1639599 | 1639599 | 2021-08-21 | Wheatland | Montana | 30107 | 192 | 9 |
1641172 | 1641172 | 2021-08-21 | Niobrara | Wyoming | 56027 | 192 | 3 |
1635595 | 1635595 | 2021-08-20 | Comanche | Kansas | 20033 | 192 | 11 |
1636324 | 1636324 | 2021-08-20 | McCone | Montana | 30055 | 192 | 2 |
1636349 | 1636349 | 2021-08-20 | Wheatland | Montana | 30107 | 192 | 9 |
1637922 | 1637922 | 2021-08-20 | Niobrara | Wyoming | 56027 | 192 | 3 |
1631519 | 1631519 | 2021-08-19 | Petersburg Borough | Alaska | 2195 | 192 | 1 |
1632345 | 1632345 | 2021-08-19 | Comanche | Kansas | 20033 | 192 | 10 |
1633099 | 1633099 | 2021-08-19 | Wheatland | Montana | 30107 | 192 | 9 |
1634079 | 1634079 | 2021-08-19 | Briscoe | Texas | 48045 | 192 | 7 |
1634527 | 1634527 | 2021-08-19 | Wahkiakum | Washington | 53069 | 192 | 5 |
1628272 | 1628272 | 2021-08-18 | Petersburg Borough | Alaska | 2195 | 192 | 1 |
1629098 | 1629098 | 2021-08-18 | Comanche | Kansas | 20033 | 192 | 10 |
1629852 | 1629852 | 2021-08-18 | Wheatland | Montana | 30107 | 192 | 9 |
1631251 | 1631251 | 2021-08-18 | Columbia | Washington | 53013 | 192 | 6 |
1604022 | 1604022 | 2021-08-10 | De Baca | New Mexico | 35011 | 192 | 2 |
1586953 | 1586953 | 2021-08-05 | Wallace | Kansas | 20199 | 192 | 4 |
1587974 | 1587974 | 2021-08-05 | Divide | North Dakota | 38023 | 192 | 2 |
1583703 | 1583703 | 2021-08-04 | Wallace | Kansas | 20199 | 192 | 4 |
1579296 | 1579296 | 2021-08-02 | San Juan | Washington | 53055 | 192 | 0 |
1512872 | 1512872 | 2021-07-13 | Worth | Missouri | 29227 | 192 | 2 |
1438282 | 1438282 | 2021-06-20 | Boyd | Nebraska | 31015 | 192 | 3 |
1435035 | 1435035 | 2021-06-19 | Boyd | Nebraska | 31015 | 192 | 3 |
1431788 | 1431788 | 2021-06-18 | Boyd | Nebraska | 31015 | 192 | 3 |
1428543 | 1428543 | 2021-06-17 | Boyd | Nebraska | 31015 | 192 | 3 |
1425298 | 1425298 | 2021-06-16 | Boyd | Nebraska | 31015 | 192 | 3 |
1422050 | 1422050 | 2021-06-15 | Boyd | Nebraska | 31015 | 192 | 3 |
1418805 | 1418805 | 2021-06-14 | Boyd | Nebraska | 31015 | 192 | 3 |
1415560 | 1415560 | 2021-06-13 | Boyd | Nebraska | 31015 | 192 | 3 |
1412314 | 1412314 | 2021-06-12 | Boyd | Nebraska | 31015 | 192 | 3 |
1409069 | 1409069 | 2021-06-11 | Boyd | Nebraska | 31015 | 192 | 3 |
1405824 | 1405824 | 2021-06-10 | Boyd | Nebraska | 31015 | 192 | 3 |
1406891 | 1406891 | 2021-06-10 | Jeff Davis | Texas | 48243 | 192 | 5 |
1402578 | 1402578 | 2021-06-09 | Boyd | Nebraska | 31015 | 192 | 3 |
1403645 | 1403645 | 2021-06-09 | Jeff Davis | Texas | 48243 | 192 | 5 |
1399333 | 1399333 | 2021-06-08 | Boyd | Nebraska | 31015 | 192 | 3 |
1399914 | 1399914 | 2021-06-08 | Wallowa | Oregon | 41063 | 192 | 5 |
1400400 | 1400400 | 2021-06-08 | Jeff Davis | Texas | 48243 | 192 | 5 |
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);