ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 4174 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Oklahoma 14
- Illinois 12
- West Virginia 12
- Tennessee 10
- Ohio 7
- Louisiana 5
- Wisconsin 5
- Alabama 4
- Kentucky 4
- Mississippi 4
- Missouri 4
- Nebraska 4
- Georgia 3
- Indiana 3
- Michigan 3
- Virginia 3
- Alaska 2
- California 2
- Florida 2
- Iowa 2
- Kansas 2
- Minnesota 2
- New York 2
- North Carolina 2
- South Carolina 2
- South Dakota 2
- Maine 1
- Montana 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472449 | 2472449 | 2022-05-04 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2469193 | 2469193 | 2022-05-03 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2465937 | 2465937 | 2022-05-02 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2462682 | 2462682 | 2022-05-01 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2459426 | 2459426 | 2022-04-30 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2456170 | 2456170 | 2022-04-29 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2452914 | 2452914 | 2022-04-28 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2418041 | 2418041 | 2022-04-17 | Monroe | West Virginia | 54063 | 4174 | 46 |
2414785 | 2414785 | 2022-04-16 | Monroe | West Virginia | 54063 | 4174 | 46 |
2411529 | 2411529 | 2022-04-15 | Monroe | West Virginia | 54063 | 4174 | 46 |
2356186 | 2356186 | 2022-03-29 | Hardy | West Virginia | 54031 | 4174 | 49 |
2352933 | 2352933 | 2022-03-28 | Hardy | West Virginia | 54031 | 4174 | 49 |
2352949 | 2352949 | 2022-03-28 | Monroe | West Virginia | 54063 | 4174 | 44 |
2349697 | 2349697 | 2022-03-27 | Monroe | West Virginia | 54063 | 4174 | 44 |
2346444 | 2346444 | 2022-03-26 | Monroe | West Virginia | 54063 | 4174 | 44 |
2343191 | 2343191 | 2022-03-25 | Monroe | West Virginia | 54063 | 4174 | 44 |
2339938 | 2339938 | 2022-03-24 | Monroe | West Virginia | 54063 | 4174 | 43 |
2313548 | 2313548 | 2022-03-16 | Lavaca | Texas | 48285 | 4174 | 116 |
2310295 | 2310295 | 2022-03-15 | Lavaca | Texas | 48285 | 4174 | 115 |
2307042 | 2307042 | 2022-03-14 | Lavaca | Texas | 48285 | 4174 | 115 |
2303791 | 2303791 | 2022-03-13 | Lavaca | Texas | 48285 | 4174 | 115 |
2300539 | 2300539 | 2022-03-12 | Lavaca | Texas | 48285 | 4174 | 115 |
2297287 | 2297287 | 2022-03-11 | Lavaca | Texas | 48285 | 4174 | 115 |
2245622 | 2245622 | 2022-02-23 | Morgan | West Virginia | 54065 | 4174 | 66 |
2239847 | 2239847 | 2022-02-22 | Carroll | Illinois | 17015 | 4174 | 47 |
2222502 | 2222502 | 2022-02-16 | Lee | Texas | 48287 | 4174 | 56 |
2211226 | 2211226 | 2022-02-13 | Antrim | Michigan | 26009 | 4174 | 56 |
2207973 | 2207973 | 2022-02-12 | Antrim | Michigan | 26009 | 4174 | 56 |
2204720 | 2204720 | 2022-02-11 | Antrim | Michigan | 26009 | 4174 | 56 |
2188350 | 2188350 | 2022-02-06 | Jackson | Louisiana | 22049 | 4174 | 68 |
2185097 | 2185097 | 2022-02-05 | Jackson | Louisiana | 22049 | 4174 | 68 |
2181845 | 2181845 | 2022-02-04 | Jackson | Louisiana | 22049 | 4174 | 68 |
2132669 | 2132669 | 2022-01-20 | Rush | Indiana | 18139 | 4174 | 37 |
2130479 | 2130479 | 2022-01-19 | Roosevelt | New Mexico | 35041 | 4174 | 85 |
2131108 | 2131108 | 2022-01-19 | Beadle | South Dakota | 46005 | 4174 | 50 |
2109858 | 2109858 | 2022-01-13 | Fulton | Indiana | 18049 | 4174 | 92 |
2102821 | 2102821 | 2022-01-11 | Del Norte | California | 6015 | 4174 | 43 |
2105815 | 2105815 | 2022-01-11 | Langlade | Wisconsin | 55067 | 4174 | 66 |
2033859 | 2033859 | 2021-12-20 | Jasper | Texas | 48241 | 4174 | 165 |
1988928 | 1988928 | 2021-12-07 | Juneau City and Borough | Alaska | 2110 | 4174 | 12 |
1985678 | 1985678 | 2021-12-06 | Juneau City and Borough | Alaska | 2110 | 4174 | 12 |
1984973 | 1984973 | 2021-12-05 | Wayne | Tennessee | 47181 | 4174 | 41 |
1980603 | 1980603 | 2021-12-04 | Audrain | Missouri | 29007 | 4174 | 77 |
1981723 | 1981723 | 2021-12-04 | Wayne | Tennessee | 47181 | 4174 | 41 |
1978473 | 1978473 | 2021-12-03 | Wayne | Tennessee | 47181 | 4174 | 41 |
1919488 | 1919488 | 2021-11-15 | Van Wert | Ohio | 39161 | 4174 | 85 |
1861462 | 1861462 | 2021-10-28 | Smith | Tennessee | 47159 | 4174 | 52 |
1849039 | 1849039 | 2021-10-24 | Juneau | Wisconsin | 55057 | 4174 | 35 |
1845789 | 1845789 | 2021-10-23 | Juneau | Wisconsin | 55057 | 4174 | 35 |
1842539 | 1842539 | 2021-10-22 | Juneau | Wisconsin | 55057 | 4174 | 35 |
1837307 | 1837307 | 2021-10-21 | Somerset | Maine | 23025 | 4174 | 45 |
1788833 | 1788833 | 2021-10-06 | Marion | Mississippi | 28091 | 4174 | 106 |
1789499 | 1789499 | 2021-10-06 | Pike | Ohio | 39131 | 4174 | 51 |
1766159 | 1766159 | 2021-09-29 | Dunklin | Missouri | 29069 | 4174 | 58 |
1754394 | 1754394 | 2021-09-25 | Kleberg | Texas | 48273 | 4174 | 121 |
1743541 | 1743541 | 2021-09-22 | Ravalli | Montana | 30081 | 4174 | 56 |
1743770 | 1743770 | 2021-09-22 | Otsego | New York | 36077 | 4174 | 51 |
1720556 | 1720556 | 2021-09-15 | Adams | Mississippi | 28001 | 4174 | 109 |
1720908 | 1720908 | 2021-09-15 | Douglas | Nevada | 32005 | 4174 | 44 |
1716343 | 1716343 | 2021-09-14 | Gilmer | Georgia | 13123 | 4174 | 106 |
1710006 | 1710006 | 2021-09-12 | Bureau | Illinois | 17011 | 4174 | 99 |
1706759 | 1706759 | 2021-09-11 | Bureau | Illinois | 17011 | 4174 | 99 |
1709299 | 1709299 | 2021-09-11 | Wayne | West Virginia | 54099 | 4174 | 49 |
1703511 | 1703511 | 2021-09-10 | Bureau | Illinois | 17011 | 4174 | 99 |
1697560 | 1697560 | 2021-09-08 | Morehouse | Louisiana | 22067 | 4174 | 97 |
1698553 | 1698553 | 2021-09-08 | Williams | Ohio | 39171 | 4174 | 81 |
1677986 | 1677986 | 2021-09-02 | Marshall | Kentucky | 21157 | 4174 | 69 |
1676687 | 1676687 | 2021-09-01 | Prince George | Virginia | 51149 | 4174 | 33 |
1604058 | 1604058 | 2021-08-10 | Columbia | New York | 36021 | 4174 | 104 |
1596334 | 1596334 | 2021-08-08 | Fulton | Illinois | 17057 | 4174 | 67 |
1593085 | 1593085 | 2021-08-07 | Fulton | Illinois | 17057 | 4174 | 67 |
1589836 | 1589836 | 2021-08-06 | Fulton | Illinois | 17057 | 4174 | 67 |
1564800 | 1564800 | 2021-07-29 | Pulaski | Missouri | 29169 | 4174 | 56 |
1539241 | 1539241 | 2021-07-21 | Yadkin | North Carolina | 37197 | 4174 | 55 |
1535109 | 1535109 | 2021-07-20 | Whitley | Kentucky | 21235 | 4174 | 62 |
1424101 | 1424101 | 2021-06-16 | Liberty | Georgia | 13179 | 4174 | 66 |
1414920 | 1414920 | 2021-06-13 | Franklin | Kentucky | 21073 | 4174 | 56 |
1397272 | 1397272 | 2021-06-07 | Washington | Texas | 48477 | 4174 | 94 |
1380171 | 1380171 | 2021-06-02 | Stokes | North Carolina | 37169 | 4174 | 80 |
1339247 | 1339247 | 2021-05-21 | Covington | Alabama | 1039 | 4174 | 119 |
1326892 | 1326892 | 2021-05-17 | Lee | Illinois | 17103 | 4174 | 92 |
1323646 | 1323646 | 2021-05-16 | Lee | Illinois | 17103 | 4174 | 92 |
1324574 | 1324574 | 2021-05-16 | Platte | Missouri | 29165 | 4174 | 47 |
1325527 | 1325527 | 2021-05-16 | Campbell | Tennessee | 47013 | 4174 | 63 |
1325853 | 1325853 | 2021-05-16 | Waller | Texas | 48473 | 4174 | 46 |
1322281 | 1322281 | 2021-05-15 | Campbell | Tennessee | 47013 | 4174 | 63 |
1319035 | 1319035 | 2021-05-14 | Campbell | Tennessee | 47013 | 4174 | 63 |
1297866 | 1297866 | 2021-05-08 | Jasper | Iowa | 19099 | 4174 | 71 |
1296201 | 1296201 | 2021-05-07 | Chester | South Carolina | 45023 | 4174 | 75 |
1276382 | 1276382 | 2021-05-01 | Fulton | Ohio | 39051 | 4174 | 69 |
1273744 | 1273744 | 2021-04-30 | Erath | Texas | 48143 | 4174 | 68 |
1263371 | 1263371 | 2021-04-27 | Ashland | Ohio | 39005 | 4174 | 89 |
1245714 | 1245714 | 2021-04-22 | Jefferson | Illinois | 17081 | 4174 | 120 |
1240770 | 1240770 | 2021-04-20 | Logan | Oklahoma | 40083 | 4174 | 56 |
1237523 | 1237523 | 2021-04-19 | Logan | Oklahoma | 40083 | 4174 | 56 |
1234276 | 1234276 | 2021-04-18 | Logan | Oklahoma | 40083 | 4174 | 56 |
1231028 | 1231028 | 2021-04-17 | Logan | Oklahoma | 40083 | 4174 | 56 |
1226345 | 1226345 | 2021-04-16 | Montgomery | Indiana | 18107 | 4174 | 87 |
1227780 | 1227780 | 2021-04-16 | Logan | Oklahoma | 40083 | 4174 | 56 |
1224532 | 1224532 | 2021-04-15 | Logan | Oklahoma | 40083 | 4174 | 56 |
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);