ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
154 rows where cases = 2699 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Georgia 13
- Alabama 10
- Ohio 9
- Missouri 8
- Tennessee 8
- Arkansas 6
- Indiana 5
- Michigan 5
- Kansas 4
- Minnesota 4
- Mississippi 4
- New Mexico 4
- New York 4
- Puerto Rico 4
- Virginia 4
- West Virginia 4
- Wisconsin 4
- Florida 3
- Idaho 3
- Kentucky 3
- Louisiana 3
- North Carolina 3
- Oregon 3
- Colorado 2
- Illinois 2
- Montana 2
- Pennsylvania 2
- Vermont 2
- Delaware 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338167 | 2338167 | 2022-03-24 | Koochiching | Minnesota | 27071 | 2699 | 37 |
2327642 | 2327642 | 2022-03-21 | Teton | Idaho | 16081 | 2699 | 8 |
2311375 | 2311375 | 2022-03-16 | Teton | Idaho | 16081 | 2699 | 8 |
2225456 | 2225456 | 2022-02-17 | Butte | South Dakota | 46019 | 2699 | 44 |
2221765 | 2221765 | 2022-02-16 | McLean | North Dakota | 38055 | 2699 | 49 |
2217948 | 2217948 | 2022-02-15 | Noxubee | Mississippi | 28103 | 2699 | 48 |
2209384 | 2209384 | 2022-02-12 | Camp | Texas | 48063 | 2699 | 71 |
2172242 | 2172242 | 2022-02-01 | Missaukee | Michigan | 26113 | 2699 | 57 |
2168989 | 2168989 | 2022-01-31 | Missaukee | Michigan | 26113 | 2699 | 57 |
2161427 | 2161427 | 2022-01-29 | Archuleta | Colorado | 8007 | 2699 | 9 |
2154918 | 2154918 | 2022-01-27 | Archuleta | Colorado | 8007 | 2699 | 9 |
2149788 | 2149788 | 2022-01-25 | Custer | Montana | 30017 | 2699 | 43 |
2143503 | 2143503 | 2022-01-23 | Torrance | New Mexico | 35057 | 2699 | 44 |
2140248 | 2140248 | 2022-01-22 | Torrance | New Mexico | 35057 | 2699 | 44 |
2136992 | 2136992 | 2022-01-21 | Torrance | New Mexico | 35057 | 2699 | 44 |
2135055 | 2135055 | 2022-01-20 | Bayfield | Wisconsin | 55007 | 2699 | 35 |
2125294 | 2125294 | 2022-01-17 | Ashland | Wisconsin | 55003 | 2699 | 28 |
2063471 | 2063471 | 2021-12-29 | Grant | West Virginia | 54023 | 2699 | 46 |
2038815 | 2038815 | 2021-12-22 | Washington | Maine | 23029 | 2699 | 38 |
2039982 | 2039982 | 2021-12-22 | Isabela | Puerto Rico | 72071 | 2699 | |
2017876 | 2017876 | 2021-12-15 | Nottoway | Virginia | 51135 | 2699 | 70 |
2012117 | 2012117 | 2021-12-14 | Rabun | Georgia | 13241 | 2699 | 76 |
1981877 | 1981877 | 2021-12-04 | Llano | Texas | 48299 | 2699 | 78 |
1974082 | 1974082 | 2021-12-02 | Smith | Mississippi | 28129 | 2699 | 52 |
1972468 | 1972468 | 2021-12-01 | Hardy | West Virginia | 54031 | 2699 | 33 |
1925413 | 1925413 | 2021-11-17 | Morgan | Missouri | 29141 | 2699 | 59 |
1878819 | 1878819 | 2021-11-03 | Jefferson | Georgia | 13163 | 2699 | 86 |
1828272 | 1828272 | 2021-10-18 | Avery | North Carolina | 37011 | 2699 | 33 |
1801867 | 1801867 | 2021-10-10 | Andrew | Missouri | 29003 | 2699 | 24 |
1763449 | 1763449 | 2021-09-28 | Carroll | Ohio | 39019 | 2699 | 52 |
1760957 | 1760957 | 2021-09-27 | San Jacinto | Texas | 48407 | 2699 | 63 |
1757709 | 1757709 | 2021-09-26 | San Jacinto | Texas | 48407 | 2699 | 63 |
1754461 | 1754461 | 2021-09-25 | San Jacinto | Texas | 48407 | 2699 | 63 |
1747873 | 1747873 | 2021-09-23 | Houston | Texas | 48225 | 2699 | 74 |
1725310 | 1725310 | 2021-09-16 | Washington | Vermont | 50023 | 2699 | 18 |
1720778 | 1720778 | 2021-09-15 | Lake | Montana | 30047 | 2699 | 46 |
1699324 | 1699324 | 2021-09-08 | Rutland | Vermont | 50021 | 2699 | 22 |
1680191 | 1680191 | 2021-09-03 | Henry | Alabama | 1067 | 2699 | 48 |
1677690 | 1677690 | 2021-09-02 | Sullivan | Indiana | 18153 | 2699 | 47 |
1673695 | 1673695 | 2021-09-01 | Hale | Alabama | 1065 | 2699 | 81 |
1670562 | 1670562 | 2021-08-31 | Lawrence | Arkansas | 5075 | 2699 | 45 |
1666152 | 1666152 | 2021-08-29 | Columbia | Oregon | 41009 | 2699 | 34 |
1662904 | 1662904 | 2021-08-28 | Columbia | Oregon | 41009 | 2699 | 34 |
1659656 | 1659656 | 2021-08-27 | Columbia | Oregon | 41009 | 2699 | 34 |
1653467 | 1653467 | 2021-08-25 | Chester | Tennessee | 47023 | 2699 | 54 |
1648456 | 1648456 | 2021-08-24 | Spencer | Indiana | 18147 | 2699 | 31 |
1649462 | 1649462 | 2021-08-24 | Carroll | New Hampshire | 33003 | 2699 | 13 |
1650220 | 1650220 | 2021-08-24 | Chester | Tennessee | 47023 | 2699 | 54 |
1644557 | 1644557 | 2021-08-23 | Conway | Arkansas | 5029 | 2699 | 37 |
1639994 | 1639994 | 2021-08-21 | Adams | Ohio | 39001 | 2699 | 59 |
1608703 | 1608703 | 2021-08-12 | Barbour | Alabama | 1005 | 2699 | 64 |
1609867 | 1609867 | 2021-08-12 | St. James | Louisiana | 22093 | 2699 | 55 |
1604855 | 1604855 | 2021-08-10 | Calhoun | Texas | 48057 | 2699 | 26 |
1597078 | 1597078 | 2021-08-08 | Meeker | Minnesota | 27093 | 2699 | 44 |
1598298 | 1598298 | 2021-08-08 | Morgan | Tennessee | 47129 | 2699 | 39 |
1593829 | 1593829 | 2021-08-07 | Meeker | Minnesota | 27093 | 2699 | 44 |
1595049 | 1595049 | 2021-08-07 | Morgan | Tennessee | 47129 | 2699 | 39 |
1590580 | 1590580 | 2021-08-06 | Meeker | Minnesota | 27093 | 2699 | 44 |
1591800 | 1591800 | 2021-08-06 | Morgan | Tennessee | 47129 | 2699 | 39 |
1583800 | 1583800 | 2021-08-04 | Ohio | Kentucky | 21183 | 2699 | 55 |
1573123 | 1573123 | 2021-08-01 | Ouachita | Arkansas | 5103 | 2699 | 65 |
1557241 | 1557241 | 2021-07-27 | Sumter | Georgia | 13261 | 2699 | 106 |
1559431 | 1559431 | 2021-07-27 | Gillespie | Texas | 48171 | 2699 | 53 |
1541976 | 1541976 | 2021-07-22 | Wayne | Mississippi | 28153 | 2699 | 42 |
1537646 | 1537646 | 2021-07-21 | Burke | Georgia | 13033 | 2699 | 65 |
1520111 | 1520111 | 2021-07-15 | Dorado | Puerto Rico | 72051 | 2699 | |
1516863 | 1516863 | 2021-07-14 | Dorado | Puerto Rico | 72051 | 2699 | |
1498280 | 1498280 | 2021-07-09 | Bibb | Alabama | 1007 | 2699 | 65 |
1495033 | 1495033 | 2021-07-08 | Bibb | Alabama | 1007 | 2699 | 65 |
1495935 | 1495935 | 2021-07-08 | Cherokee | Kansas | 20021 | 2699 | 53 |
1491786 | 1491786 | 2021-07-07 | Bibb | Alabama | 1007 | 2699 | 65 |
1492689 | 1492689 | 2021-07-07 | Cherokee | Kansas | 20021 | 2699 | 53 |
1471132 | 1471132 | 2021-06-30 | Coshocton | Ohio | 39031 | 2699 | 60 |
1466274 | 1466274 | 2021-06-29 | Haralson | Georgia | 13143 | 2699 | 90 |
1467376 | 1467376 | 2021-06-29 | Miller | Missouri | 29131 | 2699 | 57 |
1463029 | 1463029 | 2021-06-28 | Haralson | Georgia | 13143 | 2699 | 90 |
1459784 | 1459784 | 2021-06-27 | Haralson | Georgia | 13143 | 2699 | 90 |
1456539 | 1456539 | 2021-06-26 | Haralson | Georgia | 13143 | 2699 | 90 |
1459063 | 1459063 | 2021-06-26 | Hopewell city | Virginia | 51670 | 2699 | 79 |
1428963 | 1428963 | 2021-06-17 | Holmes | Ohio | 39075 | 2699 | 101 |
1425718 | 1425718 | 2021-06-16 | Holmes | Ohio | 39075 | 2699 | 101 |
1422471 | 1422471 | 2021-06-15 | Holmes | Ohio | 39075 | 2699 | 101 |
1419225 | 1419225 | 2021-06-14 | Holmes | Ohio | 39075 | 2699 | 101 |
1395184 | 1395184 | 2021-06-07 | Scott | Indiana | 18143 | 2699 | 57 |
1391939 | 1391939 | 2021-06-06 | Scott | Indiana | 18143 | 2699 | 57 |
1388694 | 1388694 | 2021-06-05 | Scott | Indiana | 18143 | 2699 | 57 |
1387619 | 1387619 | 2021-06-04 | Carroll | Virginia | 51035 | 2699 | 77 |
1379281 | 1379281 | 2021-06-02 | Perry | Kentucky | 21193 | 2699 | 66 |
1339870 | 1339870 | 2021-05-21 | Jersey | Illinois | 17083 | 2699 | 69 |
1337552 | 1337552 | 2021-05-20 | Nodaway | Missouri | 29147 | 2699 | 25 |
1334305 | 1334305 | 2021-05-19 | Nodaway | Missouri | 29147 | 2699 | 25 |
1331058 | 1331058 | 2021-05-18 | Nodaway | Missouri | 29147 | 2699 | 25 |
1327811 | 1327811 | 2021-05-17 | Nodaway | Missouri | 29147 | 2699 | 25 |
1314559 | 1314559 | 2021-05-13 | Oceana | Michigan | 26127 | 2699 | 59 |
1228701 | 1228701 | 2021-04-16 | Hancock | West Virginia | 54029 | 2699 | 97 |
1222731 | 1222731 | 2021-04-15 | Washington | Florida | 12133 | 2699 | 51 |
1222819 | 1222819 | 2021-04-15 | Lee | Georgia | 13177 | 2699 | 57 |
1219483 | 1219483 | 2021-04-14 | Washington | Florida | 12133 | 2699 | 51 |
1218133 | 1218133 | 2021-04-13 | Elk | Pennsylvania | 42047 | 2699 | 38 |
1202376 | 1202376 | 2021-04-08 | Limestone | Texas | 48293 | 2699 | 73 |
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);