ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,594 rows where cases = 91 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 127
- South Dakota 82
- Colorado 77
- Montana 70
- Virginia 67
- Kentucky 64
- Missouri 63
- Georgia 55
- Nebraska 54
- New York 46
- Iowa 45
- Michigan 45
- Oklahoma 41
- Indiana 40
- Minnesota 40
- California 39
- Kansas 38
- Tennessee 35
- Puerto Rico 33
- West Virginia 32
- Ohio 31
- Illinois 30
- Pennsylvania 30
- Delaware 28
- Idaho 28
- Mississippi 28
- North Carolina 28
- Alabama 27
- Alaska 26
- Wisconsin 26
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2156344 | 2156344 | 2022-01-27 | Banner | Nebraska | 31007 | 91 | 2 |
2147556 | 2147556 | 2022-01-24 | Borden | Texas | 48033 | 91 | 2 |
2130398 | 2130398 | 2022-01-19 | Thomas | Nebraska | 31171 | 91 | 1 |
2127144 | 2127144 | 2022-01-18 | Thomas | Nebraska | 31171 | 91 | 1 |
2123892 | 2123892 | 2022-01-17 | Thomas | Nebraska | 31171 | 91 | 1 |
2102714 | 2102714 | 2022-01-11 | Skagway Municipality | Alaska | 2230 | 91 | 0 |
2099463 | 2099463 | 2022-01-10 | Skagway Municipality | Alaska | 2230 | 91 | 0 |
2101084 | 2101084 | 2022-01-10 | Grant | Nebraska | 31075 | 91 | 5 |
2096212 | 2096212 | 2022-01-09 | Skagway Municipality | Alaska | 2230 | 91 | 0 |
2097833 | 2097833 | 2022-01-09 | Grant | Nebraska | 31075 | 91 | 5 |
2092960 | 2092960 | 2022-01-08 | Skagway Municipality | Alaska | 2230 | 91 | 0 |
2094581 | 2094581 | 2022-01-08 | Grant | Nebraska | 31075 | 91 | 5 |
2089708 | 2089708 | 2022-01-07 | Skagway Municipality | Alaska | 2230 | 91 | 0 |
2091329 | 2091329 | 2022-01-07 | Grant | Nebraska | 31075 | 91 | 5 |
2088078 | 2088078 | 2022-01-06 | Grant | Nebraska | 31075 | 91 | 5 |
2084826 | 2084826 | 2022-01-05 | Grant | Nebraska | 31075 | 91 | 5 |
2081574 | 2081574 | 2022-01-04 | Grant | Nebraska | 31075 | 91 | 5 |
2078322 | 2078322 | 2022-01-03 | Grant | Nebraska | 31075 | 91 | 5 |
2038187 | 2038187 | 2021-12-22 | Clark | Idaho | 16033 | 91 | 0 |
2034937 | 2034937 | 2021-12-21 | Clark | Idaho | 16033 | 91 | 0 |
2031687 | 2031687 | 2021-12-20 | Clark | Idaho | 16033 | 91 | 0 |
1926067 | 1926067 | 2021-11-17 | Unknown | Oklahoma | 91 | 0 | |
1850740 | 1850740 | 2021-10-25 | Golden Valley | Montana | 30037 | 91 | 3 |
1841366 | 1841366 | 2021-10-22 | Billings | North Dakota | 38007 | 91 | 0 |
1838117 | 1838117 | 2021-10-21 | Billings | North Dakota | 38007 | 91 | 0 |
1834868 | 1834868 | 2021-10-20 | Billings | North Dakota | 38007 | 91 | 0 |
1831619 | 1831619 | 2021-10-19 | Billings | North Dakota | 38007 | 91 | 0 |
1809689 | 1809689 | 2021-10-12 | Roberts | Texas | 48393 | 91 | 1 |
1806439 | 1806439 | 2021-10-11 | Roberts | Texas | 48393 | 91 | 1 |
1803189 | 1803189 | 2021-10-10 | Roberts | Texas | 48393 | 91 | 1 |
1799940 | 1799940 | 2021-10-09 | Roberts | Texas | 48393 | 91 | 1 |
1796691 | 1796691 | 2021-10-08 | Roberts | Texas | 48393 | 91 | 1 |
1782602 | 1782602 | 2021-10-04 | Logan | Nebraska | 31113 | 91 | 0 |
1779352 | 1779352 | 2021-10-03 | Logan | Nebraska | 31113 | 91 | 0 |
1776102 | 1776102 | 2021-10-02 | Logan | Nebraska | 31113 | 91 | 0 |
1772852 | 1772852 | 2021-10-01 | Logan | Nebraska | 31113 | 91 | 0 |
1769603 | 1769603 | 2021-09-30 | Logan | Nebraska | 31113 | 91 | 0 |
1767510 | 1767510 | 2021-09-29 | Daggett | Utah | 49009 | 91 | 0 |
1758700 | 1758700 | 2021-09-27 | Camas | Idaho | 16025 | 91 | 0 |
1755452 | 1755452 | 2021-09-26 | Camas | Idaho | 16025 | 91 | 0 |
1752204 | 1752204 | 2021-09-25 | Camas | Idaho | 16025 | 91 | 0 |
1748955 | 1748955 | 2021-09-24 | Camas | Idaho | 16025 | 91 | 0 |
1745705 | 1745705 | 2021-09-23 | Camas | Idaho | 16025 | 91 | 0 |
1647868 | 1647868 | 2021-08-24 | Alpine | California | 6003 | 91 | 0 |
1649310 | 1649310 | 2021-08-24 | Garfield | Montana | 30033 | 91 | 3 |
1644620 | 1644620 | 2021-08-23 | Alpine | California | 6003 | 91 | 0 |
1646061 | 1646061 | 2021-08-23 | Garfield | Montana | 30033 | 91 | 3 |
1641370 | 1641370 | 2021-08-22 | Alpine | California | 6003 | 91 | 0 |
1642812 | 1642812 | 2021-08-22 | Garfield | Montana | 30033 | 91 | 3 |
1638120 | 1638120 | 2021-08-21 | Alpine | California | 6003 | 91 | 0 |
1639562 | 1639562 | 2021-08-21 | Garfield | Montana | 30033 | 91 | 3 |
1634870 | 1634870 | 2021-08-20 | Alpine | California | 6003 | 91 | 0 |
1636312 | 1636312 | 2021-08-20 | Garfield | Montana | 30033 | 91 | 3 |
1631621 | 1631621 | 2021-08-19 | Alpine | California | 6003 | 91 | 0 |
1633062 | 1633062 | 2021-08-19 | Garfield | Montana | 30033 | 91 | 2 |
1628374 | 1628374 | 2021-08-18 | Alpine | California | 6003 | 91 | 0 |
1629815 | 1629815 | 2021-08-18 | Garfield | Montana | 30033 | 91 | 2 |
1625127 | 1625127 | 2021-08-17 | Alpine | California | 6003 | 91 | 0 |
1621880 | 1621880 | 2021-08-16 | Alpine | California | 6003 | 91 | 0 |
1618633 | 1618633 | 2021-08-15 | Alpine | California | 6003 | 91 | 0 |
1615385 | 1615385 | 2021-08-14 | Alpine | California | 6003 | 91 | 0 |
1612136 | 1612136 | 2021-08-13 | Alpine | California | 6003 | 91 | 0 |
1608888 | 1608888 | 2021-08-12 | Alpine | California | 6003 | 91 | 0 |
1605639 | 1605639 | 2021-08-11 | Alpine | California | 6003 | 91 | 0 |
1608237 | 1608237 | 2021-08-11 | McMullen | Texas | 48311 | 91 | 5 |
1602390 | 1602390 | 2021-08-10 | Alpine | California | 6003 | 91 | 0 |
1599141 | 1599141 | 2021-08-09 | Alpine | California | 6003 | 91 | 0 |
1595892 | 1595892 | 2021-08-08 | Alpine | California | 6003 | 91 | 0 |
1592643 | 1592643 | 2021-08-07 | Alpine | California | 6003 | 91 | 0 |
1589394 | 1589394 | 2021-08-06 | Alpine | California | 6003 | 91 | 0 |
1586145 | 1586145 | 2021-08-05 | Alpine | California | 6003 | 91 | 0 |
1582895 | 1582895 | 2021-08-04 | Alpine | California | 6003 | 91 | 0 |
1579645 | 1579645 | 2021-08-03 | Alpine | California | 6003 | 91 | 0 |
1576397 | 1576397 | 2021-08-02 | Alpine | California | 6003 | 91 | 0 |
1425257 | 1425257 | 2021-06-16 | Judith Basin | Montana | 30045 | 91 | 1 |
1422009 | 1422009 | 2021-06-15 | Judith Basin | Montana | 30045 | 91 | 1 |
1418764 | 1418764 | 2021-06-14 | Judith Basin | Montana | 30045 | 91 | 1 |
1415519 | 1415519 | 2021-06-13 | Judith Basin | Montana | 30045 | 91 | 1 |
1412273 | 1412273 | 2021-06-12 | Judith Basin | Montana | 30045 | 91 | 1 |
1409028 | 1409028 | 2021-06-11 | Judith Basin | Montana | 30045 | 91 | 1 |
1405783 | 1405783 | 2021-06-10 | Judith Basin | Montana | 30045 | 91 | 1 |
1402537 | 1402537 | 2021-06-09 | Judith Basin | Montana | 30045 | 91 | 1 |
1399292 | 1399292 | 2021-06-08 | Judith Basin | Montana | 30045 | 91 | 1 |
1396046 | 1396046 | 2021-06-07 | Judith Basin | Montana | 30045 | 91 | 1 |
1392800 | 1392800 | 2021-06-06 | Judith Basin | Montana | 30045 | 91 | 1 |
1389555 | 1389555 | 2021-06-05 | Judith Basin | Montana | 30045 | 91 | 1 |
1386310 | 1386310 | 2021-06-04 | Judith Basin | Montana | 30045 | 91 | 1 |
1383065 | 1383065 | 2021-06-03 | Judith Basin | Montana | 30045 | 91 | 1 |
1379819 | 1379819 | 2021-06-02 | Judith Basin | Montana | 30045 | 91 | 1 |
1376574 | 1376574 | 2021-06-01 | Judith Basin | Montana | 30045 | 91 | 1 |
1373328 | 1373328 | 2021-05-31 | Judith Basin | Montana | 30045 | 91 | 1 |
1370083 | 1370083 | 2021-05-30 | Judith Basin | Montana | 30045 | 91 | 1 |
1366837 | 1366837 | 2021-05-29 | Judith Basin | Montana | 30045 | 91 | 1 |
1363591 | 1363591 | 2021-05-28 | Judith Basin | Montana | 30045 | 91 | 1 |
1360344 | 1360344 | 2021-05-27 | Judith Basin | Montana | 30045 | 91 | 1 |
1357098 | 1357098 | 2021-05-26 | Judith Basin | Montana | 30045 | 91 | 1 |
1353852 | 1353852 | 2021-05-25 | Judith Basin | Montana | 30045 | 91 | 1 |
1350606 | 1350606 | 2021-05-24 | Judith Basin | Montana | 30045 | 91 | 1 |
1347360 | 1347360 | 2021-05-23 | Judith Basin | Montana | 30045 | 91 | 1 |
1344112 | 1344112 | 2021-05-22 | Judith Basin | Montana | 30045 | 91 | 1 |
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);