ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,528 rows where cases = 28 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
- Nebraska 312
- Texas 237
- Puerto Rico 180
- Kentucky 169
- Alaska 141
- Georgia 138
- Missouri 133
- Virginia 128
- Tennessee 125
- Kansas 120
- North Dakota 113
- Iowa 110
- Ohio 107
- Arkansas 102
- Minnesota 96
- Indiana 93
- Michigan 88
- Montana 83
- Illinois 79
- Oklahoma 73
- Washington 69
- Wisconsin 61
- Colorado 56
- West Virginia 56
- Idaho 50
- North Carolina 49
- Pennsylvania 48
- Florida 46
- Oregon 44
- California 43
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2133544 | 2133544 | 2022-01-20 | Petroleum | Montana | 30069 | 28 | 1 |
2130291 | 2130291 | 2022-01-19 | Petroleum | Montana | 30069 | 28 | 1 |
2127037 | 2127037 | 2022-01-18 | Petroleum | Montana | 30069 | 28 | 1 |
2123785 | 2123785 | 2022-01-17 | Petroleum | Montana | 30069 | 28 | 1 |
2120533 | 2120533 | 2022-01-16 | Petroleum | Montana | 30069 | 28 | 1 |
2117281 | 2117281 | 2022-01-15 | Petroleum | Montana | 30069 | 28 | 1 |
2114030 | 2114030 | 2022-01-14 | Petroleum | Montana | 30069 | 28 | 1 |
2110778 | 2110778 | 2022-01-13 | Petroleum | Montana | 30069 | 28 | 1 |
2107527 | 2107527 | 2022-01-12 | Petroleum | Montana | 30069 | 28 | 1 |
2104276 | 2104276 | 2022-01-11 | Petroleum | Montana | 30069 | 28 | 1 |
2101025 | 2101025 | 2022-01-10 | Petroleum | Montana | 30069 | 28 | 1 |
2097774 | 2097774 | 2022-01-09 | Petroleum | Montana | 30069 | 28 | 1 |
2094522 | 2094522 | 2022-01-08 | Petroleum | Montana | 30069 | 28 | 1 |
2091270 | 2091270 | 2022-01-07 | Petroleum | Montana | 30069 | 28 | 1 |
2092381 | 2092381 | 2022-01-07 | King | Texas | 48269 | 28 | 0 |
2088019 | 2088019 | 2022-01-06 | Petroleum | Montana | 30069 | 28 | 1 |
2089129 | 2089129 | 2022-01-06 | King | Texas | 48269 | 28 | 0 |
2085878 | 2085878 | 2022-01-05 | King | Texas | 48269 | 28 | 0 |
2082626 | 2082626 | 2022-01-04 | King | Texas | 48269 | 28 | 0 |
2079374 | 2079374 | 2022-01-03 | King | Texas | 48269 | 28 | 0 |
2029535 | 2029535 | 2021-12-19 | Arthur | Nebraska | 31005 | 28 | 1 |
2026284 | 2026284 | 2021-12-18 | Arthur | Nebraska | 31005 | 28 | 1 |
2023033 | 2023033 | 2021-12-17 | Arthur | Nebraska | 31005 | 28 | 1 |
2019782 | 2019782 | 2021-12-16 | Arthur | Nebraska | 31005 | 28 | 1 |
1852027 | 1852027 | 2021-10-25 | Unknown | Vermont | 28 | 0 | |
1835779 | 1835779 | 2021-10-20 | Unknown | Vermont | 28 | 0 | |
1733868 | 1733868 | 2021-09-19 | McPherson | Nebraska | 31117 | 28 | 1 |
1730618 | 1730618 | 2021-09-18 | McPherson | Nebraska | 31117 | 28 | 1 |
1727368 | 1727368 | 2021-09-17 | McPherson | Nebraska | 31117 | 28 | 1 |
1724119 | 1724119 | 2021-09-16 | McPherson | Nebraska | 31117 | 28 | 1 |
1720870 | 1720870 | 2021-09-15 | McPherson | Nebraska | 31117 | 28 | 1 |
1717622 | 1717622 | 2021-09-14 | McPherson | Nebraska | 31117 | 28 | 1 |
1714374 | 1714374 | 2021-09-13 | McPherson | Nebraska | 31117 | 28 | 1 |
1711128 | 1711128 | 2021-09-12 | McPherson | Nebraska | 31117 | 28 | 1 |
1707881 | 1707881 | 2021-09-11 | McPherson | Nebraska | 31117 | 28 | 1 |
1704634 | 1704634 | 2021-09-10 | McPherson | Nebraska | 31117 | 28 | 1 |
1701384 | 1701384 | 2021-09-09 | McPherson | Nebraska | 31117 | 28 | 1 |
1698135 | 1698135 | 2021-09-08 | McPherson | Nebraska | 31117 | 28 | 1 |
1694887 | 1694887 | 2021-09-07 | McPherson | Nebraska | 31117 | 28 | 1 |
1691638 | 1691638 | 2021-09-06 | McPherson | Nebraska | 31117 | 28 | 1 |
1688388 | 1688388 | 2021-09-05 | McPherson | Nebraska | 31117 | 28 | 1 |
1685138 | 1685138 | 2021-09-04 | McPherson | Nebraska | 31117 | 28 | 1 |
1681887 | 1681887 | 2021-09-03 | McPherson | Nebraska | 31117 | 28 | 1 |
1678639 | 1678639 | 2021-09-02 | McPherson | Nebraska | 31117 | 28 | 1 |
1675391 | 1675391 | 2021-09-01 | McPherson | Nebraska | 31117 | 28 | 1 |
1672143 | 1672143 | 2021-08-31 | McPherson | Nebraska | 31117 | 28 | 1 |
1668896 | 1668896 | 2021-08-30 | McPherson | Nebraska | 31117 | 28 | 1 |
1665649 | 1665649 | 2021-08-29 | McPherson | Nebraska | 31117 | 28 | 1 |
1662401 | 1662401 | 2021-08-28 | McPherson | Nebraska | 31117 | 28 | 1 |
1659153 | 1659153 | 2021-08-27 | McPherson | Nebraska | 31117 | 28 | 1 |
1655904 | 1655904 | 2021-08-26 | McPherson | Nebraska | 31117 | 28 | 1 |
1652657 | 1652657 | 2021-08-25 | McPherson | Nebraska | 31117 | 28 | 1 |
1649409 | 1649409 | 2021-08-24 | McPherson | Nebraska | 31117 | 28 | 1 |
1646160 | 1646160 | 2021-08-23 | McPherson | Nebraska | 31117 | 28 | 1 |
1642911 | 1642911 | 2021-08-22 | McPherson | Nebraska | 31117 | 28 | 1 |
1639661 | 1639661 | 2021-08-21 | McPherson | Nebraska | 31117 | 28 | 1 |
1636411 | 1636411 | 2021-08-20 | McPherson | Nebraska | 31117 | 28 | 1 |
1633161 | 1633161 | 2021-08-19 | McPherson | Nebraska | 31117 | 28 | 1 |
1629914 | 1629914 | 2021-08-18 | McPherson | Nebraska | 31117 | 28 | 1 |
1626667 | 1626667 | 2021-08-17 | McPherson | Nebraska | 31117 | 28 | 1 |
1623420 | 1623420 | 2021-08-16 | McPherson | Nebraska | 31117 | 28 | 1 |
1620173 | 1620173 | 2021-08-15 | McPherson | Nebraska | 31117 | 28 | 1 |
1616925 | 1616925 | 2021-08-14 | McPherson | Nebraska | 31117 | 28 | 1 |
1613677 | 1613677 | 2021-08-13 | McPherson | Nebraska | 31117 | 28 | 1 |
1610428 | 1610428 | 2021-08-12 | McPherson | Nebraska | 31117 | 28 | 1 |
1610760 | 1610760 | 2021-08-12 | Unknown | Northern Mariana Islands | 28 | 0 | |
1607180 | 1607180 | 2021-08-11 | McPherson | Nebraska | 31117 | 28 | 1 |
1607512 | 1607512 | 2021-08-11 | Unknown | Northern Mariana Islands | 28 | 0 | |
1603931 | 1603931 | 2021-08-10 | McPherson | Nebraska | 31117 | 28 | 1 |
1599029 | 1599029 | 2021-08-09 | Haines Borough | Alaska | 2100 | 28 | 0 |
1600682 | 1600682 | 2021-08-09 | McPherson | Nebraska | 31117 | 28 | 1 |
1595780 | 1595780 | 2021-08-08 | Haines Borough | Alaska | 2100 | 28 | 0 |
1597434 | 1597434 | 2021-08-08 | McPherson | Nebraska | 31117 | 28 | 1 |
1592531 | 1592531 | 2021-08-07 | Haines Borough | Alaska | 2100 | 28 | 0 |
1594185 | 1594185 | 2021-08-07 | McPherson | Nebraska | 31117 | 28 | 1 |
1589282 | 1589282 | 2021-08-06 | Haines Borough | Alaska | 2100 | 28 | 0 |
1590936 | 1590936 | 2021-08-06 | McPherson | Nebraska | 31117 | 28 | 1 |
1586033 | 1586033 | 2021-08-05 | Haines Borough | Alaska | 2100 | 28 | 0 |
1587687 | 1587687 | 2021-08-05 | McPherson | Nebraska | 31117 | 28 | 1 |
1582783 | 1582783 | 2021-08-04 | Haines Borough | Alaska | 2100 | 28 | 0 |
1584436 | 1584436 | 2021-08-04 | McPherson | Nebraska | 31117 | 28 | 1 |
1579533 | 1579533 | 2021-08-03 | Haines Borough | Alaska | 2100 | 28 | 0 |
1579546 | 1579546 | 2021-08-03 | Skagway Municipality | Alaska | 2230 | 28 | 0 |
1581187 | 1581187 | 2021-08-03 | McPherson | Nebraska | 31117 | 28 | 1 |
1576285 | 1576285 | 2021-08-02 | Haines Borough | Alaska | 2100 | 28 | 0 |
1576298 | 1576298 | 2021-08-02 | Skagway Municipality | Alaska | 2230 | 28 | 0 |
1577938 | 1577938 | 2021-08-02 | McPherson | Nebraska | 31117 | 28 | 1 |
1573037 | 1573037 | 2021-08-01 | Haines Borough | Alaska | 2100 | 28 | 0 |
1574690 | 1574690 | 2021-08-01 | McPherson | Nebraska | 31117 | 28 | 1 |
1569789 | 1569789 | 2021-07-31 | Haines Borough | Alaska | 2100 | 28 | 0 |
1571442 | 1571442 | 2021-07-31 | McPherson | Nebraska | 31117 | 28 | 1 |
1566541 | 1566541 | 2021-07-30 | Haines Borough | Alaska | 2100 | 28 | 0 |
1568194 | 1568194 | 2021-07-30 | McPherson | Nebraska | 31117 | 28 | 1 |
1563293 | 1563293 | 2021-07-29 | Haines Borough | Alaska | 2100 | 28 | 0 |
1564946 | 1564946 | 2021-07-29 | McPherson | Nebraska | 31117 | 28 | 1 |
1560045 | 1560045 | 2021-07-28 | Haines Borough | Alaska | 2100 | 28 | 0 |
1561698 | 1561698 | 2021-07-28 | McPherson | Nebraska | 31117 | 28 | 1 |
1556798 | 1556798 | 2021-07-27 | Haines Borough | Alaska | 2100 | 28 | 0 |
1558450 | 1558450 | 2021-07-27 | McPherson | Nebraska | 31117 | 28 | 1 |
1553551 | 1553551 | 2021-07-26 | Haines Borough | Alaska | 2100 | 28 | 0 |
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);