ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
486 rows where cases = 750 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 54
- Texas 48
- Georgia 37
- Nebraska 23
- Puerto Rico 19
- Virginia 19
- Kentucky 18
- Minnesota 18
- Iowa 16
- Mississippi 16
- Montana 16
- Arkansas 14
- Colorado 13
- North Carolina 13
- Oklahoma 13
- South Dakota 13
- Missouri 12
- Tennessee 11
- Illinois 10
- Wisconsin 9
- Indiana 8
- Washington 8
- Florida 7
- North Dakota 7
- Louisiana 6
- Ohio 6
- Idaho 5
- West Virginia 5
- Alabama 4
- New Jersey 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2315024 | 2315024 | 2022-03-17 | Trego | Kansas | 20195 | 750 | 9 |
2311771 | 2311771 | 2022-03-16 | Trego | Kansas | 20195 | 750 | 9 |
2308518 | 2308518 | 2022-03-15 | Trego | Kansas | 20195 | 750 | 9 |
2305267 | 2305267 | 2022-03-14 | Trego | Kansas | 20195 | 750 | 9 |
2302015 | 2302015 | 2022-03-13 | Trego | Kansas | 20195 | 750 | 9 |
2298763 | 2298763 | 2022-03-12 | Trego | Kansas | 20195 | 750 | 9 |
2295511 | 2295511 | 2022-03-11 | Trego | Kansas | 20195 | 750 | 9 |
2292259 | 2292259 | 2022-03-10 | Trego | Kansas | 20195 | 750 | 9 |
2289007 | 2289007 | 2022-03-09 | Trego | Kansas | 20195 | 750 | 9 |
2285756 | 2285756 | 2022-03-08 | Trego | Kansas | 20195 | 750 | 9 |
2282504 | 2282504 | 2022-03-07 | Trego | Kansas | 20195 | 750 | 9 |
2279251 | 2279251 | 2022-03-06 | Trego | Kansas | 20195 | 750 | 9 |
2275998 | 2275998 | 2022-03-05 | Trego | Kansas | 20195 | 750 | 9 |
2272745 | 2272745 | 2022-03-04 | Trego | Kansas | 20195 | 750 | 9 |
2267079 | 2267079 | 2022-03-02 | Mora | New Mexico | 35033 | 750 | 16 |
2256859 | 2256859 | 2022-02-27 | Lake of the Woods | Minnesota | 27077 | 750 | 6 |
2253608 | 2253608 | 2022-02-26 | Lake of the Woods | Minnesota | 27077 | 750 | 6 |
2250357 | 2250357 | 2022-02-25 | Lake of the Woods | Minnesota | 27077 | 750 | 6 |
2198628 | 2198628 | 2022-02-09 | Sweet Grass | Montana | 30097 | 750 | 8 |
2180230 | 2180230 | 2022-02-03 | Mason | Texas | 48319 | 750 | 10 |
2176979 | 2176979 | 2022-02-02 | Mason | Texas | 48319 | 750 | 10 |
2177040 | 2177040 | 2022-02-02 | Sutton | Texas | 48435 | 750 | 12 |
2165420 | 2165420 | 2022-01-30 | Sheridan | Kansas | 20179 | 750 | 18 |
2162165 | 2162165 | 2022-01-29 | Sheridan | Kansas | 20179 | 750 | 18 |
2158910 | 2158910 | 2022-01-28 | Sheridan | Kansas | 20179 | 750 | 18 |
2147551 | 2147551 | 2022-01-24 | Baylor | Texas | 48023 | 750 | 26 |
2124803 | 2124803 | 2022-01-17 | Coke | Texas | 48081 | 750 | 18 |
2096565 | 2096565 | 2022-01-09 | Echols | Georgia | 13101 | 750 | 11 |
2093313 | 2093313 | 2022-01-08 | Echols | Georgia | 13101 | 750 | 11 |
2090061 | 2090061 | 2022-01-07 | Echols | Georgia | 13101 | 750 | 11 |
2086810 | 2086810 | 2022-01-06 | Echols | Georgia | 13101 | 750 | 11 |
2083558 | 2083558 | 2022-01-05 | Echols | Georgia | 13101 | 750 | 11 |
2079663 | 2079663 | 2022-01-03 | Surry | Virginia | 51181 | 750 | 13 |
2038174 | 2038174 | 2021-12-22 | Bear Lake | Idaho | 16007 | 750 | 15 |
2039976 | 2039976 | 2021-12-22 | Guayanilla | Puerto Rico | 72059 | 750 | |
2015379 | 2015379 | 2021-12-15 | Talbot | Georgia | 13263 | 750 | 29 |
2012128 | 2012128 | 2021-12-14 | Talbot | Georgia | 13263 | 750 | 29 |
2008877 | 2008877 | 2021-12-13 | Talbot | Georgia | 13263 | 750 | 29 |
2010404 | 2010404 | 2021-12-13 | Sargent | North Dakota | 38081 | 750 | 9 |
2007153 | 2007153 | 2021-12-12 | Sargent | North Dakota | 38081 | 750 | 9 |
2003902 | 2003902 | 2021-12-11 | Sargent | North Dakota | 38081 | 750 | 9 |
1990499 | 1990499 | 2021-12-07 | Musselshell | Montana | 30065 | 750 | 23 |
1984052 | 1984052 | 2021-12-05 | Fillmore | Nebraska | 31059 | 750 | 13 |
1980802 | 1980802 | 2021-12-04 | Fillmore | Nebraska | 31059 | 750 | 13 |
1981130 | 1981130 | 2021-12-04 | LaMoure | North Dakota | 38045 | 750 | 17 |
1976441 | 1976441 | 2021-12-03 | Lincoln | Idaho | 16063 | 750 | 14 |
1977552 | 1977552 | 2021-12-03 | Fillmore | Nebraska | 31059 | 750 | 13 |
1973192 | 1973192 | 2021-12-02 | Lincoln | Idaho | 16063 | 750 | 14 |
1969659 | 1969659 | 2021-12-01 | Washington | Colorado | 8121 | 750 | 24 |
1938547 | 1938547 | 2021-11-21 | Furnas | Nebraska | 31065 | 750 | 5 |
1935297 | 1935297 | 2021-11-20 | Furnas | Nebraska | 31065 | 750 | 5 |
1932047 | 1932047 | 2021-11-19 | Furnas | Nebraska | 31065 | 750 | 5 |
1915716 | 1915716 | 2021-11-14 | Chouteau | Montana | 30015 | 750 | 8 |
1912466 | 1912466 | 2021-11-13 | Chouteau | Montana | 30015 | 750 | 8 |
1909216 | 1909216 | 2021-11-12 | Chouteau | Montana | 30015 | 750 | 8 |
1906017 | 1906017 | 2021-11-11 | Antelope | Nebraska | 31003 | 750 | 10 |
1896272 | 1896272 | 2021-11-08 | Boone | Nebraska | 31011 | 750 | 4 |
1848946 | 1848946 | 2021-10-24 | Skamania | Washington | 53059 | 750 | 6 |
1845696 | 1845696 | 2021-10-23 | Skamania | Washington | 53059 | 750 | 6 |
1842446 | 1842446 | 2021-10-22 | Skamania | Washington | 53059 | 750 | 6 |
1834899 | 1834899 | 2021-10-20 | Pierce | North Dakota | 38069 | 750 | 27 |
1828103 | 1828103 | 2021-10-18 | Polk | Nebraska | 31143 | 750 | 18 |
1805281 | 1805281 | 2021-10-11 | Teton | Montana | 30099 | 750 | 7 |
1802032 | 1802032 | 2021-10-10 | Teton | Montana | 30099 | 750 | 7 |
1798783 | 1798783 | 2021-10-09 | Teton | Montana | 30099 | 750 | 7 |
1795534 | 1795534 | 2021-10-08 | Teton | Montana | 30099 | 750 | 7 |
1791582 | 1791582 | 2021-10-07 | Morris | Kansas | 20127 | 750 | 23 |
1791954 | 1791954 | 2021-10-07 | Big Stone | Minnesota | 27011 | 750 | 4 |
1788333 | 1788333 | 2021-10-06 | Morris | Kansas | 20127 | 750 | 23 |
1785742 | 1785742 | 2021-10-05 | Broadwater | Montana | 30007 | 750 | 12 |
1762356 | 1762356 | 2021-09-28 | Rooks | Kansas | 20163 | 750 | 11 |
1759108 | 1759108 | 2021-09-27 | Rooks | Kansas | 20163 | 750 | 11 |
1728031 | 1728031 | 2021-09-17 | Sabana Grande | Puerto Rico | 72121 | 750 | |
1717705 | 1717705 | 2021-09-14 | Unknown | New Jersey | 750 | 0 | |
1702834 | 1702834 | 2021-09-09 | Iron | Wisconsin | 55051 | 750 | 42 |
1694132 | 1694132 | 2021-09-07 | Republic | Kansas | 20157 | 750 | 15 |
1690883 | 1690883 | 2021-09-06 | Republic | Kansas | 20157 | 750 | 15 |
1687633 | 1687633 | 2021-09-05 | Republic | Kansas | 20157 | 750 | 15 |
1684383 | 1684383 | 2021-09-04 | Republic | Kansas | 20157 | 750 | 15 |
1681132 | 1681132 | 2021-09-03 | Republic | Kansas | 20157 | 750 | 15 |
1677186 | 1677186 | 2021-09-02 | Kit Carson | Colorado | 8063 | 750 | 14 |
1675496 | 1675496 | 2021-09-01 | Quay | New Mexico | 35037 | 750 | 12 |
1657136 | 1657136 | 2021-08-26 | Emporia city | Virginia | 51595 | 750 | 42 |
1648251 | 1648251 | 2021-08-24 | Caribou | Idaho | 16029 | 750 | 12 |
1646089 | 1646089 | 2021-08-23 | Sanders | Montana | 30089 | 750 | 15 |
1644319 | 1644319 | 2021-08-22 | Pocahontas | West Virginia | 54075 | 750 | 12 |
1641069 | 1641069 | 2021-08-21 | Pocahontas | West Virginia | 54075 | 750 | 12 |
1637461 | 1637461 | 2021-08-20 | Marion | Texas | 48315 | 750 | 34 |
1637819 | 1637819 | 2021-08-20 | Pocahontas | West Virginia | 54075 | 750 | 12 |
1625483 | 1625483 | 2021-08-17 | Wheeler | Georgia | 13309 | 750 | 26 |
1627122 | 1627122 | 2021-08-17 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1623875 | 1623875 | 2021-08-16 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1619457 | 1619457 | 2021-08-15 | Bracken | Kentucky | 21023 | 750 | 8 |
1620628 | 1620628 | 2021-08-15 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1616209 | 1616209 | 2021-08-14 | Bracken | Kentucky | 21023 | 750 | 8 |
1617380 | 1617380 | 2021-08-14 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1612960 | 1612960 | 2021-08-13 | Bracken | Kentucky | 21023 | 750 | 8 |
1614132 | 1614132 | 2021-08-13 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1610883 | 1610883 | 2021-08-12 | Jefferson | Oklahoma | 40067 | 750 | 18 |
1607635 | 1607635 | 2021-08-11 | Jefferson | Oklahoma | 40067 | 750 | 18 |
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);