ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,718 rows where cases = 75 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 193
- Nebraska 101
- Georgia 79
- Iowa 71
- Virginia 71
- Kentucky 68
- Missouri 56
- Minnesota 48
- Tennessee 48
- Puerto Rico 47
- Illinois 46
- Oklahoma 44
- Indiana 43
- Kansas 42
- South Dakota 42
- New Mexico 39
- Michigan 38
- Montana 38
- North Carolina 37
- Wisconsin 37
- Mississippi 36
- West Virginia 36
- Arkansas 33
- Ohio 32
- California 31
- Colorado 29
- Pennsylvania 29
- Vermont 27
- Alabama 26
- New York 26
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491534 | 2491534 | 2022-05-10 | McPherson | Nebraska | 31117 | 75 | 1 |
2488276 | 2488276 | 2022-05-09 | McPherson | Nebraska | 31117 | 75 | 1 |
2260570 | 2260570 | 2022-02-28 | Harding | New Mexico | 35021 | 75 | 4 |
2257319 | 2257319 | 2022-02-27 | Harding | New Mexico | 35021 | 75 | 4 |
2254068 | 2254068 | 2022-02-26 | Harding | New Mexico | 35021 | 75 | 4 |
2250817 | 2250817 | 2022-02-25 | Harding | New Mexico | 35021 | 75 | 4 |
2247566 | 2247566 | 2022-02-24 | Harding | New Mexico | 35021 | 75 | 4 |
2209483 | 2209483 | 2022-02-12 | Kenedy | Texas | 48261 | 75 | 2 |
2206230 | 2206230 | 2022-02-11 | Kenedy | Texas | 48261 | 75 | 2 |
2202977 | 2202977 | 2022-02-10 | Kenedy | Texas | 48261 | 75 | 2 |
2199723 | 2199723 | 2022-02-09 | Kenedy | Texas | 48261 | 75 | 2 |
2196469 | 2196469 | 2022-02-08 | Kenedy | Texas | 48261 | 75 | 2 |
2188957 | 2188957 | 2022-02-06 | Sioux | Nebraska | 31165 | 75 | 1 |
2185704 | 2185704 | 2022-02-05 | Sioux | Nebraska | 31165 | 75 | 1 |
2182452 | 2182452 | 2022-02-04 | Sioux | Nebraska | 31165 | 75 | 1 |
2179200 | 2179200 | 2022-02-03 | Sioux | Nebraska | 31165 | 75 | 1 |
2175948 | 2175948 | 2022-02-02 | Sioux | Nebraska | 31165 | 75 | 1 |
2172695 | 2172695 | 2022-02-01 | Sioux | Nebraska | 31165 | 75 | 1 |
2169442 | 2169442 | 2022-01-31 | Sioux | Nebraska | 31165 | 75 | 1 |
2128165 | 2128165 | 2022-01-18 | Loving | Texas | 48301 | 75 | 0 |
2104301 | 2104301 | 2022-01-11 | Banner | Nebraska | 31007 | 75 | 2 |
1987358 | 1987358 | 2021-12-06 | Thomas | Nebraska | 31171 | 75 | 1 |
1984108 | 1984108 | 2021-12-05 | Thomas | Nebraska | 31171 | 75 | 1 |
1980858 | 1980858 | 2021-12-04 | Thomas | Nebraska | 31171 | 75 | 1 |
1977608 | 1977608 | 2021-12-03 | Thomas | Nebraska | 31171 | 75 | 1 |
1913765 | 1913765 | 2021-11-13 | Unknown | Vermont | 75 | 0 | |
1896309 | 1896309 | 2021-11-08 | Hayes | Nebraska | 31085 | 75 | 0 |
1893059 | 1893059 | 2021-11-07 | Hayes | Nebraska | 31085 | 75 | 0 |
1893109 | 1893109 | 2021-11-07 | Wheeler | Nebraska | 31183 | 75 | 0 |
1889809 | 1889809 | 2021-11-06 | Hayes | Nebraska | 31085 | 75 | 0 |
1889859 | 1889859 | 2021-11-06 | Wheeler | Nebraska | 31183 | 75 | 0 |
1886559 | 1886559 | 2021-11-05 | Hayes | Nebraska | 31085 | 75 | 0 |
1886609 | 1886609 | 2021-11-05 | Wheeler | Nebraska | 31183 | 75 | 0 |
1883310 | 1883310 | 2021-11-04 | Hayes | Nebraska | 31085 | 75 | 0 |
1883360 | 1883360 | 2021-11-04 | Wheeler | Nebraska | 31183 | 75 | 0 |
1880061 | 1880061 | 2021-11-03 | Hayes | Nebraska | 31085 | 75 | 0 |
1880111 | 1880111 | 2021-11-03 | Wheeler | Nebraska | 31183 | 75 | 0 |
1876812 | 1876812 | 2021-11-02 | Hayes | Nebraska | 31085 | 75 | 0 |
1873563 | 1873563 | 2021-11-01 | Hayes | Nebraska | 31085 | 75 | 0 |
1870314 | 1870314 | 2021-10-31 | Hayes | Nebraska | 31085 | 75 | 0 |
1867060 | 1867060 | 2021-10-30 | Grant | Nebraska | 31075 | 75 | 4 |
1867065 | 1867065 | 2021-10-30 | Hayes | Nebraska | 31085 | 75 | 0 |
1862988 | 1862988 | 2021-10-29 | Unknown | Iowa | 75 | 0 | |
1863811 | 1863811 | 2021-10-29 | Grant | Nebraska | 31075 | 75 | 4 |
1863816 | 1863816 | 2021-10-29 | Hayes | Nebraska | 31085 | 75 | 0 |
1859739 | 1859739 | 2021-10-28 | Unknown | Iowa | 75 | 0 | |
1860562 | 1860562 | 2021-10-28 | Grant | Nebraska | 31075 | 75 | 4 |
1860567 | 1860567 | 2021-10-28 | Hayes | Nebraska | 31085 | 75 | 0 |
1856490 | 1856490 | 2021-10-27 | Unknown | Iowa | 75 | 0 | |
1857313 | 1857313 | 2021-10-27 | Grant | Nebraska | 31075 | 75 | 4 |
1857318 | 1857318 | 2021-10-27 | Hayes | Nebraska | 31085 | 75 | 0 |
1849194 | 1849194 | 2021-10-25 | Skagway Municipality | Alaska | 2230 | 75 | 0 |
1792337 | 1792337 | 2021-10-07 | Hooker | Nebraska | 31091 | 75 | 3 |
1789088 | 1789088 | 2021-10-06 | Hooker | Nebraska | 31091 | 75 | 3 |
1785840 | 1785840 | 2021-10-05 | Hooker | Nebraska | 31091 | 75 | 3 |
1722663 | 1722663 | 2021-09-16 | Jackson | Colorado | 8057 | 75 | 0 |
1696040 | 1696040 | 2021-09-07 | Daggett | Utah | 49009 | 75 | 0 |
1692792 | 1692792 | 2021-09-06 | Daggett | Utah | 49009 | 75 | 0 |
1689543 | 1689543 | 2021-09-05 | Daggett | Utah | 49009 | 75 | 0 |
1686293 | 1686293 | 2021-09-04 | Daggett | Utah | 49009 | 75 | 0 |
1683042 | 1683042 | 2021-09-03 | Daggett | Utah | 49009 | 75 | 0 |
1679730 | 1679730 | 2021-09-02 | Roberts | Texas | 48393 | 75 | 1 |
1679792 | 1679792 | 2021-09-02 | Daggett | Utah | 49009 | 75 | 0 |
1602294 | 1602294 | 2021-08-10 | Wrangell City and Borough | Alaska | 2275 | 75 | 0 |
1599046 | 1599046 | 2021-08-09 | Wrangell City and Borough | Alaska | 2275 | 75 | 0 |
1532999 | 1532999 | 2021-07-19 | Sherman | Oregon | 41055 | 75 | 2 |
1505000 | 1505000 | 2021-07-11 | Sierra | California | 6091 | 75 | 0 |
1501754 | 1501754 | 2021-07-10 | Sierra | California | 6091 | 75 | 0 |
1498508 | 1498508 | 2021-07-09 | Sierra | California | 6091 | 75 | 0 |
1422611 | 1422611 | 2021-06-15 | Gilliam | Oregon | 41021 | 75 | 1 |
1419365 | 1419365 | 2021-06-14 | Gilliam | Oregon | 41021 | 75 | 1 |
1416120 | 1416120 | 2021-06-13 | Gilliam | Oregon | 41021 | 75 | 1 |
1412874 | 1412874 | 2021-06-12 | Gilliam | Oregon | 41021 | 75 | 1 |
1332331 | 1332331 | 2021-05-18 | Terrell | Texas | 48443 | 75 | 2 |
1329084 | 1329084 | 2021-05-17 | Terrell | Texas | 48443 | 75 | 2 |
1325838 | 1325838 | 2021-05-16 | Terrell | Texas | 48443 | 75 | 2 |
1322592 | 1322592 | 2021-05-15 | Terrell | Texas | 48443 | 75 | 2 |
1319346 | 1319346 | 2021-05-14 | Terrell | Texas | 48443 | 75 | 2 |
1316098 | 1316098 | 2021-05-13 | Terrell | Texas | 48443 | 75 | 2 |
1312852 | 1312852 | 2021-05-12 | Terrell | Texas | 48443 | 75 | 2 |
1309605 | 1309605 | 2021-05-11 | Terrell | Texas | 48443 | 75 | 2 |
1306359 | 1306359 | 2021-05-10 | Terrell | Texas | 48443 | 75 | 2 |
1303113 | 1303113 | 2021-05-09 | Terrell | Texas | 48443 | 75 | 2 |
1299866 | 1299866 | 2021-05-08 | Terrell | Texas | 48443 | 75 | 2 |
1296619 | 1296619 | 2021-05-07 | Terrell | Texas | 48443 | 75 | 2 |
1293373 | 1293373 | 2021-05-06 | Terrell | Texas | 48443 | 75 | 2 |
1290127 | 1290127 | 2021-05-05 | Terrell | Texas | 48443 | 75 | 2 |
1286881 | 1286881 | 2021-05-04 | Terrell | Texas | 48443 | 75 | 2 |
1283635 | 1283635 | 2021-05-03 | Terrell | Texas | 48443 | 75 | 2 |
1280388 | 1280388 | 2021-05-02 | Terrell | Texas | 48443 | 75 | 2 |
1277141 | 1277141 | 2021-05-01 | Terrell | Texas | 48443 | 75 | 2 |
1273894 | 1273894 | 2021-04-30 | Terrell | Texas | 48443 | 75 | 2 |
1270647 | 1270647 | 2021-04-29 | Terrell | Texas | 48443 | 75 | 2 |
1238841 | 1238841 | 2021-04-20 | Dolores | Colorado | 8033 | 75 | 0 |
1235594 | 1235594 | 2021-04-19 | Dolores | Colorado | 8033 | 75 | 0 |
1238177 | 1238177 | 2021-04-19 | Terrell | Texas | 48443 | 75 | 2 |
1234930 | 1234930 | 2021-04-18 | Terrell | Texas | 48443 | 75 | 2 |
1231682 | 1231682 | 2021-04-17 | Terrell | Texas | 48443 | 75 | 2 |
1228434 | 1228434 | 2021-04-16 | Terrell | Texas | 48443 | 75 | 2 |
1225186 | 1225186 | 2021-04-15 | Terrell | Texas | 48443 | 75 | 2 |
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);