ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where cases = 4639 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 21
- Mississippi 13
- Minnesota 7
- Nebraska 7
- Georgia 6
- Texas 6
- Alabama 5
- Idaho 5
- North Carolina 5
- Tennessee 5
- Arkansas 3
- Louisiana 3
- New York 3
- Ohio 3
- South Dakota 3
- Virginia 3
- Oregon 2
- Pennsylvania 2
- Utah 2
- Colorado 1
- Illinois 1
- Indiana 1
- Iowa 1
- Maine 1
- Massachusetts 1
- Michigan 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501706 | 2501706 | 2022-05-13 | Paulding | Ohio | 39125 | 4639 | 74 |
2498448 | 2498448 | 2022-05-12 | Paulding | Ohio | 39125 | 4639 | 74 |
2484710 | 2484710 | 2022-05-08 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2481452 | 2481452 | 2022-05-07 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2478194 | 2478194 | 2022-05-06 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2473689 | 2473689 | 2022-05-05 | Sharp | Arkansas | 5135 | 4639 | 105 |
2474936 | 2474936 | 2022-05-05 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2471679 | 2471679 | 2022-05-04 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2468423 | 2468423 | 2022-05-03 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2465168 | 2465168 | 2022-05-02 | Calhoun | Mississippi | 28013 | 4639 | 71 |
2430167 | 2430167 | 2022-04-21 | Clatsop | Oregon | 41007 | 4639 | 49 |
2430945 | 2430945 | 2022-04-21 | New Kent | Virginia | 51127 | 4639 | 32 |
2365216 | 2365216 | 2022-04-01 | Morovis | Puerto Rico | 72101 | 4639 | |
2242755 | 2242755 | 2022-02-23 | Elbert | Colorado | 8039 | 4639 | 37 |
2242919 | 2242919 | 2022-02-23 | Crisp | Georgia | 13081 | 4639 | 131 |
2227428 | 2227428 | 2022-02-18 | Lincoln | Maine | 23015 | 4639 | 25 |
2215945 | 2215945 | 2022-02-14 | Gonzales | Texas | 48177 | 4639 | 93 |
2212694 | 2212694 | 2022-02-13 | Gonzales | Texas | 48177 | 4639 | 93 |
2209441 | 2209441 | 2022-02-12 | Gonzales | Texas | 48177 | 4639 | 93 |
2150497 | 2150497 | 2022-01-25 | Wyoming | Pennsylvania | 42131 | 4639 | 95 |
2138451 | 2138451 | 2022-01-22 | Monroe | Alabama | 1099 | 4639 | 67 |
2129226 | 2129226 | 2022-01-19 | Jerome | Idaho | 16053 | 4639 | 58 |
2127251 | 2127251 | 2022-01-18 | Essex | New York | 36031 | 4639 | 52 |
2021243 | 2021243 | 2021-12-16 | Nicholas | West Virginia | 54067 | 4639 | 71 |
1970074 | 1970074 | 2021-12-01 | Decatur | Indiana | 18031 | 4639 | 116 |
1943375 | 1943375 | 2021-11-23 | Geneva | Alabama | 1061 | 4639 | 136 |
1909460 | 1909460 | 2021-11-12 | Greene | New York | 36039 | 4639 | 87 |
1905730 | 1905730 | 2021-11-11 | Pine | Minnesota | 27115 | 4639 | 39 |
1881743 | 1881743 | 2021-11-04 | Johnson | Arkansas | 5071 | 4639 | 58 |
1860338 | 1860338 | 2021-10-28 | Tate | Mississippi | 28137 | 4639 | 111 |
1788521 | 1788521 | 2021-10-06 | Jefferson Davis | Louisiana | 22053 | 4639 | 121 |
1786719 | 1786719 | 2021-10-05 | Overton | Tennessee | 47133 | 4639 | 78 |
1779012 | 1779012 | 2021-10-03 | Polk | Minnesota | 27119 | 4639 | 75 |
1775762 | 1775762 | 2021-10-02 | Polk | Minnesota | 27119 | 4639 | 75 |
1772512 | 1772512 | 2021-10-01 | Polk | Minnesota | 27119 | 4639 | 75 |
1768442 | 1768442 | 2021-09-30 | Bonner | Idaho | 16017 | 4639 | 69 |
1770574 | 1770574 | 2021-09-30 | Fannin | Texas | 48147 | 4639 | 133 |
1761432 | 1761432 | 2021-09-28 | Pike | Alabama | 1109 | 4639 | 98 |
1740807 | 1740807 | 2021-09-21 | Custer | Oklahoma | 40039 | 4639 | 107 |
1737558 | 1737558 | 2021-09-20 | Custer | Oklahoma | 40039 | 4639 | 107 |
1734308 | 1734308 | 2021-09-19 | Custer | Oklahoma | 40039 | 4639 | 107 |
1731058 | 1731058 | 2021-09-18 | Custer | Oklahoma | 40039 | 4639 | 107 |
1727808 | 1727808 | 2021-09-17 | Custer | Oklahoma | 40039 | 4639 | 107 |
1727954 | 1727954 | 2021-09-17 | Pike | Pennsylvania | 42103 | 4639 | 56 |
1724559 | 1724559 | 2021-09-16 | Custer | Oklahoma | 40039 | 4639 | 107 |
1721310 | 1721310 | 2021-09-15 | Custer | Oklahoma | 40039 | 4639 | 107 |
1718050 | 1718050 | 2021-09-14 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1714802 | 1714802 | 2021-09-13 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1715647 | 1715647 | 2021-09-13 | Manassas city | Virginia | 51683 | 4639 | 49 |
1711556 | 1711556 | 2021-09-12 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1708309 | 1708309 | 2021-09-11 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1705062 | 1705062 | 2021-09-10 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1701812 | 1701812 | 2021-09-09 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1698563 | 1698563 | 2021-09-08 | Caddo | Oklahoma | 40015 | 4639 | 101 |
1665907 | 1665907 | 2021-08-29 | Scotland | North Carolina | 37165 | 4639 | 96 |
1662659 | 1662659 | 2021-08-28 | Scotland | North Carolina | 37165 | 4639 | 96 |
1659411 | 1659411 | 2021-08-27 | Scotland | North Carolina | 37165 | 4639 | 96 |
1643803 | 1643803 | 2021-08-22 | Weakley | Tennessee | 47183 | 4639 | 70 |
1640553 | 1640553 | 2021-08-21 | Weakley | Tennessee | 47183 | 4639 | 70 |
1637303 | 1637303 | 2021-08-20 | Weakley | Tennessee | 47183 | 4639 | 70 |
1600425 | 1600425 | 2021-08-09 | Pontotoc | Mississippi | 28115 | 4639 | 74 |
1601912 | 1601912 | 2021-08-09 | Danville city | Virginia | 51590 | 4639 | 145 |
1586099 | 1586099 | 2021-08-05 | Independence | Arkansas | 5063 | 4639 | 131 |
1577377 | 1577377 | 2021-08-02 | St. John the Baptist | Louisiana | 22095 | 4639 | 142 |
1574318 | 1574318 | 2021-08-01 | Itasca | Minnesota | 27061 | 4639 | 68 |
1571070 | 1571070 | 2021-07-31 | Itasca | Minnesota | 27061 | 4639 | 68 |
1567822 | 1567822 | 2021-07-30 | Itasca | Minnesota | 27061 | 4639 | 68 |
1561917 | 1561917 | 2021-07-28 | Haywood | North Carolina | 37087 | 4639 | 99 |
1540543 | 1540543 | 2021-07-22 | Russell | Alabama | 1113 | 4639 | 42 |
1537634 | 1537634 | 2021-07-21 | Baldwin | Georgia | 13009 | 4639 | 136 |
1421525 | 1421525 | 2021-06-15 | Lincoln | Louisiana | 22061 | 4639 | 93 |
1367463 | 1367463 | 2021-05-29 | Yamhill | Oregon | 41071 | 4639 | 78 |
1347191 | 1347191 | 2021-05-23 | Oktibbeha | Mississippi | 28105 | 4639 | 98 |
1343943 | 1343943 | 2021-05-22 | Oktibbeha | Mississippi | 28105 | 4639 | 98 |
1340694 | 1340694 | 2021-05-21 | Oktibbeha | Mississippi | 28105 | 4639 | 98 |
1325468 | 1325468 | 2021-05-16 | Codington | South Dakota | 46029 | 4639 | 81 |
1322222 | 1322222 | 2021-05-15 | Codington | South Dakota | 46029 | 4639 | 81 |
1318976 | 1318976 | 2021-05-14 | Codington | South Dakota | 46029 | 4639 | 81 |
1308970 | 1308970 | 2021-05-11 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1305724 | 1305724 | 2021-05-10 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1302478 | 1302478 | 2021-05-09 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1303172 | 1303172 | 2021-05-09 | Wasatch | Utah | 49051 | 4639 | 21 |
1299230 | 1299230 | 2021-05-08 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1295984 | 1295984 | 2021-05-07 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1292738 | 1292738 | 2021-05-06 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1289492 | 1289492 | 2021-05-05 | Pittsburg | Oklahoma | 40121 | 4639 | 69 |
1279291 | 1279291 | 2021-05-02 | Scotts Bluff | Nebraska | 31157 | 4639 | 95 |
1276044 | 1276044 | 2021-05-01 | Scotts Bluff | Nebraska | 31157 | 4639 | 95 |
1272797 | 1272797 | 2021-04-30 | Scotts Bluff | Nebraska | 31157 | 4639 | 95 |
1269550 | 1269550 | 2021-04-29 | Scotts Bluff | Nebraska | 31157 | 4639 | 95 |
1266303 | 1266303 | 2021-04-28 | Scotts Bluff | Nebraska | 31157 | 4639 | 95 |
1263056 | 1263056 | 2021-04-27 | Scotts Bluff | Nebraska | 31157 | 4639 | 95 |
1219518 | 1219518 | 2021-04-14 | Colquitt | Georgia | 13071 | 4639 | 114 |
1213849 | 1213849 | 2021-04-12 | Barry | Michigan | 26015 | 4639 | 53 |
1164442 | 1164442 | 2021-03-28 | Bingham | Idaho | 16011 | 4639 | 69 |
1161194 | 1161194 | 2021-03-27 | Bingham | Idaho | 16011 | 4639 | 69 |
1157946 | 1157946 | 2021-03-26 | Bingham | Idaho | 16011 | 4639 | 69 |
1159835 | 1159835 | 2021-03-26 | Newberry | South Carolina | 45071 | 4639 | 94 |
1139752 | 1139752 | 2021-03-20 | Cattaraugus | New York | 36009 | 4639 | 79 |
1109323 | 1109323 | 2021-03-11 | Jackson | Illinois | 17077 | 4639 | 72 |
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);