ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
622 rows where cases = 662 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 100
- Kansas 58
- Texas 48
- Georgia 32
- Mississippi 32
- Idaho 25
- Iowa 24
- North Dakota 21
- Missouri 18
- Puerto Rico 18
- Oklahoma 15
- South Dakota 15
- Arkansas 14
- Indiana 14
- Kentucky 14
- Virginia 14
- Alabama 13
- Minnesota 13
- West Virginia 11
- Washington 9
- Louisiana 8
- North Carolina 8
- Tennessee 8
- Colorado 7
- Michigan 7
- Montana 7
- California 6
- Florida 6
- Illinois 6
- Ohio 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2288270 | 2288270 | 2022-03-09 | Costilla | Colorado | 8023 | 662 | 15 |
2285019 | 2285019 | 2022-03-08 | Costilla | Colorado | 8023 | 662 | 15 |
2223928 | 2223928 | 2022-02-17 | Kiowa | Kansas | 20097 | 662 | 7 |
2225653 | 2225653 | 2022-02-17 | Collingsworth | Texas | 48087 | 662 | 15 |
2220677 | 2220677 | 2022-02-16 | Kiowa | Kansas | 20097 | 662 | 7 |
2163590 | 2163590 | 2022-01-29 | Vieques | Puerto Rico | 72147 | 662 | |
2160335 | 2160335 | 2022-01-28 | Vieques | Puerto Rico | 72147 | 662 | |
2146933 | 2146933 | 2022-01-24 | Emmons | North Dakota | 38029 | 662 | 16 |
2143679 | 2143679 | 2022-01-23 | Emmons | North Dakota | 38029 | 662 | 16 |
2126793 | 2126793 | 2022-01-18 | Traverse | Minnesota | 27155 | 662 | 8 |
2128171 | 2128171 | 2022-01-18 | Mason | Texas | 48319 | 662 | 9 |
2121703 | 2121703 | 2022-01-16 | Real | Texas | 48385 | 662 | 21 |
2110862 | 2110862 | 2022-01-13 | Nance | Nebraska | 31125 | 662 | 10 |
2108966 | 2108966 | 2022-01-12 | San Juan | Washington | 53055 | 662 | 0 |
2097031 | 2097031 | 2022-01-09 | Chautauqua | Kansas | 20019 | 662 | 16 |
2098865 | 2098865 | 2022-01-09 | Hudspeth | Texas | 48229 | 662 | 14 |
2093779 | 2093779 | 2022-01-08 | Chautauqua | Kansas | 20019 | 662 | 16 |
2090527 | 2090527 | 2022-01-07 | Chautauqua | Kansas | 20019 | 662 | 16 |
2089186 | 2089186 | 2022-01-06 | Reagan | Texas | 48383 | 662 | 11 |
2082709 | 2082709 | 2022-01-04 | Sutton | Texas | 48435 | 662 | 11 |
2056717 | 2056717 | 2021-12-27 | Upton | Texas | 48461 | 662 | 15 |
2020480 | 2020480 | 2021-12-16 | Jayuya | Puerto Rico | 72073 | 662 | |
2014640 | 2014640 | 2021-12-14 | Rappahannock | Virginia | 51157 | 662 | 6 |
1998041 | 1998041 | 2021-12-09 | Delta | Texas | 48119 | 662 | 22 |
1994833 | 1994833 | 2021-12-08 | Haskell | Texas | 48207 | 662 | 34 |
1991582 | 1991582 | 2021-12-07 | Haskell | Texas | 48207 | 662 | 34 |
1943089 | 1943089 | 2021-11-22 | King and Queen | Virginia | 51097 | 662 | 8 |
1919402 | 1919402 | 2021-11-15 | Wells | North Dakota | 38103 | 662 | 9 |
1916152 | 1916152 | 2021-11-14 | Wells | North Dakota | 38103 | 662 | 9 |
1912902 | 1912902 | 2021-11-13 | Wells | North Dakota | 38103 | 662 | 9 |
1905735 | 1905735 | 2021-11-11 | Red Lake | Minnesota | 27125 | 662 | 10 |
1867055 | 1867055 | 2021-10-30 | Furnas | Nebraska | 31065 | 662 | 5 |
1863806 | 1863806 | 2021-10-29 | Furnas | Nebraska | 31065 | 662 | 5 |
1860260 | 1860260 | 2021-10-28 | Unknown | Minnesota | 662 | 124 | |
1858086 | 1858086 | 2021-10-27 | Deuel | South Dakota | 46039 | 662 | 11 |
1855243 | 1855243 | 2021-10-26 | Garfield | Utah | 49017 | 662 | 12 |
1847263 | 1847263 | 2021-10-24 | Unknown | Minnesota | 662 | 124 | |
1844013 | 1844013 | 2021-10-23 | Unknown | Minnesota | 662 | 124 | |
1840763 | 1840763 | 2021-10-22 | Unknown | Minnesota | 662 | 124 | |
1838136 | 1838136 | 2021-10-21 | LaMoure | North Dakota | 38045 | 662 | 17 |
1831232 | 1831232 | 2021-10-19 | Chouteau | Montana | 30015 | 662 | 8 |
1827366 | 1827366 | 2021-10-18 | Ballard | Kentucky | 21007 | 662 | 19 |
1813065 | 1813065 | 2021-10-13 | Charles City | Virginia | 51036 | 662 | 19 |
1805267 | 1805267 | 2021-10-11 | Phillips | Montana | 30071 | 662 | 21 |
1802018 | 1802018 | 2021-10-10 | Phillips | Montana | 30071 | 662 | 21 |
1802718 | 1802718 | 2021-10-10 | Ceiba | Puerto Rico | 72037 | 662 | |
1798769 | 1798769 | 2021-10-09 | Phillips | Montana | 30071 | 662 | 21 |
1799469 | 1799469 | 2021-10-09 | Ceiba | Puerto Rico | 72037 | 662 | |
1795520 | 1795520 | 2021-10-08 | Phillips | Montana | 30071 | 662 | 21 |
1796220 | 1796220 | 2021-10-08 | Ceiba | Puerto Rico | 72037 | 662 | |
1786789 | 1786789 | 2021-10-05 | Coke | Texas | 48081 | 662 | 16 |
1781483 | 1781483 | 2021-10-04 | Calhoun | Illinois | 17013 | 662 | 5 |
1759829 | 1759829 | 2021-09-27 | Fillmore | Nebraska | 31059 | 662 | 13 |
1756598 | 1756598 | 2021-09-26 | Howard | Nebraska | 31093 | 662 | 10 |
1753350 | 1753350 | 2021-09-25 | Howard | Nebraska | 31093 | 662 | 10 |
1750102 | 1750102 | 2021-09-24 | Howard | Nebraska | 31093 | 662 | 10 |
1750747 | 1750747 | 2021-09-24 | Guayanilla | Puerto Rico | 72059 | 662 | |
1743254 | 1743254 | 2021-09-22 | Lincoln | Minnesota | 27081 | 662 | 4 |
1733856 | 1733856 | 2021-09-19 | Jefferson | Nebraska | 31095 | 662 | 3 |
1730606 | 1730606 | 2021-09-18 | Jefferson | Nebraska | 31095 | 662 | 3 |
1727356 | 1727356 | 2021-09-17 | Jefferson | Nebraska | 31095 | 662 | 3 |
1724107 | 1724107 | 2021-09-16 | Jefferson | Nebraska | 31095 | 662 | 3 |
1720493 | 1720493 | 2021-09-15 | Grant | Minnesota | 27051 | 662 | 8 |
1720510 | 1720510 | 2021-09-15 | Mahnomen | Minnesota | 27087 | 662 | 9 |
1720858 | 1720858 | 2021-09-15 | Jefferson | Nebraska | 31095 | 662 | 3 |
1717610 | 1717610 | 2021-09-14 | Jefferson | Nebraska | 31095 | 662 | 3 |
1714362 | 1714362 | 2021-09-13 | Jefferson | Nebraska | 31095 | 662 | 3 |
1711116 | 1711116 | 2021-09-12 | Jefferson | Nebraska | 31095 | 662 | 3 |
1707869 | 1707869 | 2021-09-11 | Jefferson | Nebraska | 31095 | 662 | 3 |
1704622 | 1704622 | 2021-09-10 | Jefferson | Nebraska | 31095 | 662 | 3 |
1701372 | 1701372 | 2021-09-09 | Jefferson | Nebraska | 31095 | 662 | 3 |
1698123 | 1698123 | 2021-09-08 | Jefferson | Nebraska | 31095 | 662 | 3 |
1694875 | 1694875 | 2021-09-07 | Jefferson | Nebraska | 31095 | 662 | 3 |
1695398 | 1695398 | 2021-09-07 | Harney | Oregon | 41025 | 662 | 13 |
1690348 | 1690348 | 2021-09-06 | Echols | Georgia | 13101 | 662 | 9 |
1691626 | 1691626 | 2021-09-06 | Jefferson | Nebraska | 31095 | 662 | 3 |
1687098 | 1687098 | 2021-09-05 | Echols | Georgia | 13101 | 662 | 9 |
1688376 | 1688376 | 2021-09-05 | Jefferson | Nebraska | 31095 | 662 | 3 |
1683848 | 1683848 | 2021-09-04 | Echols | Georgia | 13101 | 662 | 9 |
1685126 | 1685126 | 2021-09-04 | Jefferson | Nebraska | 31095 | 662 | 3 |
1680597 | 1680597 | 2021-09-03 | Echols | Georgia | 13101 | 662 | 9 |
1681875 | 1681875 | 2021-09-03 | Jefferson | Nebraska | 31095 | 662 | 3 |
1678627 | 1678627 | 2021-09-02 | Jefferson | Nebraska | 31095 | 662 | 3 |
1675379 | 1675379 | 2021-09-01 | Jefferson | Nebraska | 31095 | 662 | 3 |
1672131 | 1672131 | 2021-08-31 | Jefferson | Nebraska | 31095 | 662 | 3 |
1668884 | 1668884 | 2021-08-30 | Jefferson | Nebraska | 31095 | 662 | 3 |
1665637 | 1665637 | 2021-08-29 | Jefferson | Nebraska | 31095 | 662 | 3 |
1662389 | 1662389 | 2021-08-28 | Jefferson | Nebraska | 31095 | 662 | 3 |
1659141 | 1659141 | 2021-08-27 | Jefferson | Nebraska | 31095 | 662 | 3 |
1655892 | 1655892 | 2021-08-26 | Jefferson | Nebraska | 31095 | 662 | 3 |
1652645 | 1652645 | 2021-08-25 | Jefferson | Nebraska | 31095 | 662 | 3 |
1649397 | 1649397 | 2021-08-24 | Jefferson | Nebraska | 31095 | 662 | 3 |
1646148 | 1646148 | 2021-08-23 | Jefferson | Nebraska | 31095 | 662 | 3 |
1642899 | 1642899 | 2021-08-22 | Jefferson | Nebraska | 31095 | 662 | 3 |
1639649 | 1639649 | 2021-08-21 | Jefferson | Nebraska | 31095 | 662 | 3 |
1636399 | 1636399 | 2021-08-20 | Jefferson | Nebraska | 31095 | 662 | 3 |
1637425 | 1637425 | 2021-08-20 | Jack | Texas | 48237 | 662 | 18 |
1631445 | 1631445 | 2021-08-19 | Choctaw | Alabama | 1023 | 662 | 25 |
1631534 | 1631534 | 2021-08-19 | Greenlee | Arizona | 4011 | 662 | 11 |
1632717 | 1632717 | 2021-08-19 | Lake | Michigan | 26085 | 662 | 17 |
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);