ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,266 rows where cases = 21 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 375
- Michigan 228
- Nebraska 220
- Kentucky 183
- Virginia 153
- Missouri 148
- Indiana 142
- South Dakota 142
- Illinois 136
- Iowa 135
- Kansas 135
- Oklahoma 129
- Colorado 128
- Georgia 124
- Minnesota 123
- Alaska 120
- Wisconsin 115
- Tennessee 104
- Ohio 102
- West Virginia 90
- North Dakota 87
- North Carolina 84
- Puerto Rico 74
- Idaho 73
- Vermont 71
- Arkansas 67
- Pennsylvania 64
- Mississippi 61
- Hawaii 54
- South Carolina 53
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416755 | 2416755 | 2022-04-17 | Unknown | New Mexico | 21 | 0 | |
2413499 | 2413499 | 2022-04-16 | Unknown | New Mexico | 21 | 0 | |
2409594 | 2409594 | 2022-04-15 | Unknown | Maine | 21 | 0 | |
2410243 | 2410243 | 2022-04-15 | Unknown | New Mexico | 21 | 0 | |
2169752 | 2169752 | 2022-01-31 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2166497 | 2166497 | 2022-01-30 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2163242 | 2163242 | 2022-01-29 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2159987 | 2159987 | 2022-01-28 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2156732 | 2156732 | 2022-01-27 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2153479 | 2153479 | 2022-01-26 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2150227 | 2150227 | 2022-01-25 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2146975 | 2146975 | 2022-01-24 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2143721 | 2143721 | 2022-01-23 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2140466 | 2140466 | 2022-01-22 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2137210 | 2137210 | 2022-01-21 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2133957 | 2133957 | 2022-01-20 | Tinian | Northern Mariana Islands | 69120 | 21 | 0 |
2055062 | 2055062 | 2021-12-27 | Unknown | Maine | 21 | 1 | |
2051812 | 2051812 | 2021-12-26 | Unknown | Maine | 21 | 1 | |
2048562 | 2048562 | 2021-12-25 | Unknown | Maine | 21 | 1 | |
2045312 | 2045312 | 2021-12-24 | Unknown | Maine | 21 | 1 | |
1962360 | 1962360 | 2021-11-28 | King | Texas | 48269 | 21 | 0 |
1959109 | 1959109 | 2021-11-27 | King | Texas | 48269 | 21 | 0 |
1955858 | 1955858 | 2021-11-26 | King | Texas | 48269 | 21 | 0 |
1952607 | 1952607 | 2021-11-25 | King | Texas | 48269 | 21 | 0 |
1949356 | 1949356 | 2021-11-24 | King | Texas | 48269 | 21 | 0 |
1946105 | 1946105 | 2021-11-23 | King | Texas | 48269 | 21 | 0 |
1942854 | 1942854 | 2021-11-22 | King | Texas | 48269 | 21 | 0 |
1938493 | 1938493 | 2021-11-21 | Petroleum | Montana | 30069 | 21 | 1 |
1939604 | 1939604 | 2021-11-21 | King | Texas | 48269 | 21 | 0 |
1935243 | 1935243 | 2021-11-20 | Petroleum | Montana | 30069 | 21 | 1 |
1936354 | 1936354 | 2021-11-20 | King | Texas | 48269 | 21 | 0 |
1931993 | 1931993 | 2021-11-19 | Petroleum | Montana | 30069 | 21 | 1 |
1928742 | 1928742 | 2021-11-18 | Petroleum | Montana | 30069 | 21 | 1 |
1925492 | 1925492 | 2021-11-17 | Petroleum | Montana | 30069 | 21 | 1 |
1922243 | 1922243 | 2021-11-16 | Petroleum | Montana | 30069 | 21 | 1 |
1782701 | 1782701 | 2021-10-04 | Harding | New Mexico | 35021 | 21 | 2 |
1754553 | 1754553 | 2021-09-25 | Unknown | Vermont | 21 | 0 | |
1751305 | 1751305 | 2021-09-24 | Unknown | Vermont | 21 | 0 | |
1748056 | 1748056 | 2021-09-23 | Unknown | Vermont | 21 | 0 | |
1744806 | 1744806 | 2021-09-22 | Unknown | Vermont | 21 | 0 | |
1741557 | 1741557 | 2021-09-21 | Unknown | Vermont | 21 | 0 | |
1738308 | 1738308 | 2021-09-20 | Unknown | Vermont | 21 | 0 | |
1735058 | 1735058 | 2021-09-19 | Unknown | Vermont | 21 | 0 | |
1731808 | 1731808 | 2021-09-18 | Unknown | Vermont | 21 | 0 | |
1725309 | 1725309 | 2021-09-16 | Unknown | Vermont | 21 | 0 | |
1696077 | 1696077 | 2021-09-07 | Unknown | Vermont | 21 | 0 | |
1692829 | 1692829 | 2021-09-06 | Unknown | Vermont | 21 | 0 | |
1673334 | 1673334 | 2021-08-31 | Unknown | Vermont | 21 | 0 | |
1670086 | 1670086 | 2021-08-30 | Unknown | Vermont | 21 | 0 | |
1666839 | 1666839 | 2021-08-29 | Unknown | Vermont | 21 | 0 | |
1663591 | 1663591 | 2021-08-28 | Unknown | Vermont | 21 | 0 | |
1660343 | 1660343 | 2021-08-27 | Unknown | Vermont | 21 | 0 | |
1601873 | 1601873 | 2021-08-09 | Unknown | Vermont | 21 | 0 | |
1517843 | 1517843 | 2021-07-15 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1514596 | 1514596 | 2021-07-14 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1511350 | 1511350 | 2021-07-13 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1508103 | 1508103 | 2021-07-12 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1504857 | 1504857 | 2021-07-11 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1501611 | 1501611 | 2021-07-10 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1498365 | 1498365 | 2021-07-09 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1495118 | 1495118 | 2021-07-08 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1491871 | 1491871 | 2021-07-07 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1488624 | 1488624 | 2021-07-06 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1485377 | 1485377 | 2021-07-05 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1482131 | 1482131 | 2021-07-04 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1478884 | 1478884 | 2021-07-03 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1475638 | 1475638 | 2021-07-02 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1472392 | 1472392 | 2021-07-01 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1469147 | 1469147 | 2021-06-30 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1465902 | 1465902 | 2021-06-29 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1462657 | 1462657 | 2021-06-28 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1459412 | 1459412 | 2021-06-27 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1456167 | 1456167 | 2021-06-26 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1452922 | 1452922 | 2021-06-25 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1449676 | 1449676 | 2021-06-24 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1452505 | 1452505 | 2021-06-24 | Unknown | Vermont | 21 | 0 | |
1446431 | 1446431 | 2021-06-23 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1443186 | 1443186 | 2021-06-22 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1439941 | 1439941 | 2021-06-21 | Skagway Municipality | Alaska | 2230 | 21 | 0 |
1416801 | 1416801 | 2021-06-13 | Unknown | Vermont | 21 | 0 | |
1413555 | 1413555 | 2021-06-12 | Unknown | Vermont | 21 | 0 | |
1410310 | 1410310 | 2021-06-11 | Unknown | Vermont | 21 | 0 | |
1360382 | 1360382 | 2021-05-27 | Blaine | Nebraska | 31009 | 21 | 0 |
1357136 | 1357136 | 2021-05-26 | Blaine | Nebraska | 31009 | 21 | 0 |
1353890 | 1353890 | 2021-05-25 | Blaine | Nebraska | 31009 | 21 | 0 |
1350644 | 1350644 | 2021-05-24 | Blaine | Nebraska | 31009 | 21 | 0 |
1347398 | 1347398 | 2021-05-23 | Blaine | Nebraska | 31009 | 21 | 0 |
1344150 | 1344150 | 2021-05-22 | Blaine | Nebraska | 31009 | 21 | 0 |
1340902 | 1340902 | 2021-05-21 | Blaine | Nebraska | 31009 | 21 | 0 |
1337654 | 1337654 | 2021-05-20 | Blaine | Nebraska | 31009 | 21 | 0 |
1334407 | 1334407 | 2021-05-19 | Blaine | Nebraska | 31009 | 21 | 0 |
1331160 | 1331160 | 2021-05-18 | Blaine | Nebraska | 31009 | 21 | 0 |
1327913 | 1327913 | 2021-05-17 | Blaine | Nebraska | 31009 | 21 | 0 |
1324667 | 1324667 | 2021-05-16 | Blaine | Nebraska | 31009 | 21 | 0 |
1321421 | 1321421 | 2021-05-15 | Blaine | Nebraska | 31009 | 21 | 0 |
1318175 | 1318175 | 2021-05-14 | Blaine | Nebraska | 31009 | 21 | 0 |
1314927 | 1314927 | 2021-05-13 | Blaine | Nebraska | 31009 | 21 | 0 |
1311681 | 1311681 | 2021-05-12 | Blaine | Nebraska | 31009 | 21 | 0 |
1308434 | 1308434 | 2021-05-11 | Blaine | Nebraska | 31009 | 21 | 0 |
1305188 | 1305188 | 2021-05-10 | Blaine | Nebraska | 31009 | 21 | 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);