ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 2662 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 18
- Mississippi 13
- Virginia 12
- Indiana 10
- Colorado 9
- Illinois 8
- Georgia 7
- Louisiana 7
- Missouri 7
- Alabama 6
- North Carolina 6
- Tennessee 6
- Michigan 5
- Texas 5
- Wisconsin 5
- Arkansas 4
- Kansas 4
- Kentucky 4
- Minnesota 4
- Ohio 4
- Idaho 3
- Pennsylvania 3
- Washington 3
- West Virginia 3
- Montana 2
- New York 2
- South Dakota 2
- Utah 2
- Alaska 1
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476451 | 2476451 | 2022-05-05 | Amelia | Virginia | 51007 | 2662 | 60 |
2404101 | 2404101 | 2022-04-13 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2400846 | 2400846 | 2022-04-12 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2397591 | 2397591 | 2022-04-11 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2394336 | 2394336 | 2022-04-10 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2391080 | 2391080 | 2022-04-09 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2387824 | 2387824 | 2022-04-08 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2384569 | 2384569 | 2022-04-07 | Pushmataha | Oklahoma | 40127 | 2662 | 45 |
2378692 | 2378692 | 2022-04-05 | Terry | Texas | 48445 | 2662 | 84 |
2301156 | 2301156 | 2022-03-13 | Fulton | Arkansas | 5049 | 2662 | 86 |
2297904 | 2297904 | 2022-03-12 | Fulton | Arkansas | 5049 | 2662 | 86 |
2248916 | 2248916 | 2022-02-24 | Forest | Wisconsin | 55041 | 2662 | 50 |
2224049 | 2224049 | 2022-02-17 | Lee | Kentucky | 21129 | 2662 | 46 |
2224117 | 2224117 | 2022-02-17 | Catahoula | Louisiana | 22025 | 2662 | 55 |
2217488 | 2217488 | 2022-02-15 | Bath | Kentucky | 21011 | 2662 | 36 |
2196790 | 2196790 | 2022-02-08 | Jefferson | Washington | 53031 | 2662 | 24 |
2191038 | 2191038 | 2022-02-07 | Gooding | Idaho | 16047 | 2662 | 48 |
2191960 | 2191960 | 2022-02-07 | Barton | Missouri | 29011 | 2662 | 46 |
2193535 | 2193535 | 2022-02-07 | Jefferson | Washington | 53031 | 2662 | 24 |
2180311 | 2180311 | 2022-02-03 | Ward | Texas | 48475 | 2662 | 39 |
2172390 | 2172390 | 2022-02-01 | Jefferson Davis | Mississippi | 28065 | 2662 | 44 |
2165734 | 2165734 | 2022-01-30 | Missaukee | Michigan | 26113 | 2662 | 56 |
2162479 | 2162479 | 2022-01-29 | Missaukee | Michigan | 26113 | 2662 | 56 |
2159224 | 2159224 | 2022-01-28 | Missaukee | Michigan | 26113 | 2662 | 56 |
2112034 | 2112034 | 2022-01-13 | Unknown | Utah | 2662 | 57 | |
2058638 | 2058638 | 2021-12-28 | Dallas | Missouri | 29059 | 2662 | 59 |
2051396 | 2051396 | 2021-12-26 | Tipton | Indiana | 18159 | 2662 | 70 |
2048146 | 2048146 | 2021-12-25 | Tipton | Indiana | 18159 | 2662 | 70 |
2044896 | 2044896 | 2021-12-24 | Tipton | Indiana | 18159 | 2662 | 70 |
2041647 | 2041647 | 2021-12-23 | Tipton | Indiana | 18159 | 2662 | 70 |
2038397 | 2038397 | 2021-12-22 | Tipton | Indiana | 18159 | 2662 | 70 |
2030492 | 2030492 | 2021-12-19 | Aransas | Texas | 48007 | 2662 | 67 |
2016830 | 2016830 | 2021-12-15 | Northampton | North Carolina | 37131 | 2662 | 66 |
1995747 | 1995747 | 2021-12-09 | Bacon | Georgia | 13005 | 2662 | 64 |
1969269 | 1969269 | 2021-11-30 | Crawford | Wisconsin | 55023 | 2662 | 23 |
1964499 | 1964499 | 2021-11-29 | Park | Montana | 30067 | 2662 | 30 |
1965870 | 1965870 | 2021-11-29 | Nottoway | Virginia | 51135 | 2662 | 70 |
1915599 | 1915599 | 2021-11-14 | Benton | Missouri | 29015 | 2662 | 47 |
1912349 | 1912349 | 2021-11-13 | Benton | Missouri | 29015 | 2662 | 47 |
1913995 | 1913995 | 2021-11-13 | Wetzel | West Virginia | 54103 | 2662 | 56 |
1905286 | 1905286 | 2021-11-11 | Jefferson | Kansas | 20087 | 2662 | 50 |
1902036 | 1902036 | 2021-11-10 | Jefferson | Kansas | 20087 | 2662 | 50 |
1891960 | 1891960 | 2021-11-07 | Clay | Illinois | 17025 | 2662 | 59 |
1888710 | 1888710 | 2021-11-06 | Clay | Illinois | 17025 | 2662 | 59 |
1885460 | 1885460 | 2021-11-05 | Clay | Illinois | 17025 | 2662 | 59 |
1882211 | 1882211 | 2021-11-04 | Clay | Illinois | 17025 | 2662 | 59 |
1861797 | 1861797 | 2021-10-28 | Buckingham | Virginia | 51029 | 2662 | 38 |
1858130 | 1858130 | 2021-10-27 | Union | South Dakota | 46127 | 2662 | 45 |
1836374 | 1836374 | 2021-10-21 | Elbert | Colorado | 8039 | 2662 | 23 |
1838331 | 1838331 | 2021-10-21 | Unknown | Oklahoma | 2662 | 7 | |
1833469 | 1833469 | 2021-10-20 | Cass | Illinois | 17017 | 2662 | 39 |
1810422 | 1810422 | 2021-10-13 | Teller | Colorado | 8119 | 2662 | 25 |
1811558 | 1811558 | 2021-10-13 | Holmes | Mississippi | 28051 | 2662 | 87 |
1813295 | 1813295 | 2021-10-13 | Iowa | Wisconsin | 55049 | 2662 | 16 |
1808309 | 1808309 | 2021-10-12 | Holmes | Mississippi | 28051 | 2662 | 87 |
1809063 | 1809063 | 2021-10-12 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1805058 | 1805058 | 2021-10-11 | Holmes | Mississippi | 28051 | 2662 | 87 |
1805813 | 1805813 | 2021-10-11 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1802563 | 1802563 | 2021-10-10 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1799314 | 1799314 | 2021-10-09 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1796065 | 1796065 | 2021-10-08 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1792816 | 1792816 | 2021-10-07 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1789567 | 1789567 | 2021-10-06 | Marshall | Oklahoma | 40095 | 2662 | 26 |
1786655 | 1786655 | 2021-10-05 | Benton | Tennessee | 47005 | 2662 | 49 |
1777912 | 1777912 | 2021-10-03 | Montezuma | Colorado | 8083 | 2662 | 33 |
1774662 | 1774662 | 2021-10-02 | Montezuma | Colorado | 8083 | 2662 | 33 |
1771412 | 1771412 | 2021-10-01 | Montezuma | Colorado | 8083 | 2662 | 33 |
1770752 | 1770752 | 2021-09-30 | Young | Texas | 48503 | 2662 | 59 |
1755059 | 1755059 | 2021-09-26 | Sharp | Arkansas | 5135 | 2662 | 62 |
1743032 | 1743032 | 2021-09-22 | Jackson | Louisiana | 22049 | 2662 | 59 |
1712675 | 1712675 | 2021-09-13 | Fayette | Alabama | 1057 | 2662 | 67 |
1715249 | 1715249 | 2021-09-13 | Sequatchie | Tennessee | 47153 | 2662 | 30 |
1709963 | 1709963 | 2021-09-12 | Blaine | Idaho | 16013 | 2662 | 20 |
1699664 | 1699664 | 2021-09-09 | Cherokee | Alabama | 1019 | 2662 | 49 |
1702148 | 1702148 | 2021-09-09 | Hughes | South Dakota | 46065 | 2662 | 43 |
1679946 | 1679946 | 2021-09-02 | Russell | Virginia | 51167 | 2662 | 42 |
1670065 | 1670065 | 2021-08-30 | Sevier | Utah | 49041 | 2662 | 15 |
1644831 | 1644831 | 2021-08-23 | Ben Hill | Georgia | 13017 | 2662 | 85 |
1632176 | 1632176 | 2021-08-19 | Jennings | Indiana | 18079 | 2662 | 54 |
1633394 | 1633394 | 2021-08-19 | Martin | North Carolina | 37117 | 2662 | 49 |
1627182 | 1627182 | 2021-08-17 | Jefferson | Oregon | 41031 | 2662 | 43 |
1624304 | 1624304 | 2021-08-16 | Trousdale | Tennessee | 47169 | 2662 | 22 |
1611791 | 1611791 | 2021-08-12 | Stevens | Washington | 53065 | 2662 | 32 |
1599398 | 1599398 | 2021-08-09 | Fannin | Georgia | 13111 | 2662 | 75 |
1560131 | 1560131 | 2021-07-28 | Ouachita | Arkansas | 5103 | 2662 | 65 |
1557016 | 1557016 | 2021-07-27 | Pitkin | Colorado | 8097 | 2662 | 4 |
1558094 | 1558094 | 2021-07-27 | Meeker | Minnesota | 27093 | 2662 | 44 |
1558155 | 1558155 | 2021-07-27 | George | Mississippi | 28039 | 2662 | 51 |
1553769 | 1553769 | 2021-07-26 | Pitkin | Colorado | 8097 | 2662 | 4 |
1537270 | 1537270 | 2021-07-21 | Geneva | Alabama | 1061 | 2662 | 83 |
1531902 | 1531902 | 2021-07-19 | Plaquemines | Louisiana | 22075 | 2662 | 27 |
1532345 | 1532345 | 2021-07-19 | Stoddard | Missouri | 29207 | 2662 | 44 |
1507088 | 1507088 | 2021-07-11 | Susquehanna | Pennsylvania | 42115 | 2662 | 62 |
1495612 | 1495612 | 2021-07-08 | Jerome | Idaho | 16053 | 2662 | 23 |
1424336 | 1424336 | 2021-06-16 | Clay | Indiana | 18021 | 2662 | 48 |
1390274 | 1390274 | 2021-06-05 | Dorado | Puerto Rico | 72051 | 2662 | |
1387618 | 1387618 | 2021-06-04 | Caroline | Virginia | 51033 | 2662 | 38 |
1361835 | 1361835 | 2021-05-27 | Mingo | West Virginia | 54059 | 2662 | 41 |
1355467 | 1355467 | 2021-05-26 | Bibb | Alabama | 1007 | 2662 | 64 |
1345503 | 1345503 | 2021-05-22 | Pulaski | Virginia | 51155 | 2662 | 61 |
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);