ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
653 rows where county = "Clay" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 17
- Georgia 369
- West Virginia 64
- North Carolina 37
- Arkansas 29
- Iowa 25
- Kentucky 23
- Mississippi 22
- Indiana 19
- Missouri 17
- Texas 17
- Kansas 14
- South Dakota 5
- Alabama 3
- Minnesota 3
- Tennessee 3
- Nebraska 2
- Illinois 1
fips 17
county 1
- Clay · 653 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1719560 | 1719560 | 2021-09-15 | Clay | Georgia | 13061 | 305 | 3 |
1716312 | 1716312 | 2021-09-14 | Clay | Georgia | 13061 | 304 | 3 |
1713066 | 1713066 | 2021-09-13 | Clay | Georgia | 13061 | 305 | 3 |
1709819 | 1709819 | 2021-09-12 | Clay | Georgia | 13061 | 303 | 3 |
1706572 | 1706572 | 2021-09-11 | Clay | Georgia | 13061 | 303 | 3 |
1703324 | 1703324 | 2021-09-10 | Clay | Georgia | 13061 | 303 | 3 |
1700074 | 1700074 | 2021-09-09 | Clay | Georgia | 13061 | 303 | 3 |
1696825 | 1696825 | 2021-09-08 | Clay | Georgia | 13061 | 302 | 3 |
1693577 | 1693577 | 2021-09-07 | Clay | Georgia | 13061 | 302 | 3 |
1690328 | 1690328 | 2021-09-06 | Clay | Georgia | 13061 | 295 | 3 |
1687078 | 1687078 | 2021-09-05 | Clay | Georgia | 13061 | 295 | 3 |
1683828 | 1683828 | 2021-09-04 | Clay | Georgia | 13061 | 295 | 3 |
1680577 | 1680577 | 2021-09-03 | Clay | Georgia | 13061 | 295 | 3 |
1677329 | 1677329 | 2021-09-02 | Clay | Georgia | 13061 | 293 | 3 |
1674082 | 1674082 | 2021-09-01 | Clay | Georgia | 13061 | 292 | 3 |
1670834 | 1670834 | 2021-08-31 | Clay | Georgia | 13061 | 291 | 3 |
1667587 | 1667587 | 2021-08-30 | Clay | Georgia | 13061 | 287 | 3 |
1664340 | 1664340 | 2021-08-29 | Clay | Georgia | 13061 | 283 | 3 |
1661092 | 1661092 | 2021-08-28 | Clay | Georgia | 13061 | 283 | 3 |
1657844 | 1657844 | 2021-08-27 | Clay | Georgia | 13061 | 283 | 3 |
1654596 | 1654596 | 2021-08-26 | Clay | Georgia | 13061 | 282 | 3 |
1651349 | 1651349 | 2021-08-25 | Clay | Georgia | 13061 | 281 | 3 |
1648100 | 1648100 | 2021-08-24 | Clay | Georgia | 13061 | 281 | 3 |
1644852 | 1644852 | 2021-08-23 | Clay | Georgia | 13061 | 279 | 3 |
1641602 | 1641602 | 2021-08-22 | Clay | Georgia | 13061 | 275 | 3 |
1638352 | 1638352 | 2021-08-21 | Clay | Georgia | 13061 | 275 | 3 |
1635102 | 1635102 | 2021-08-20 | Clay | Georgia | 13061 | 275 | 3 |
1631853 | 1631853 | 2021-08-19 | Clay | Georgia | 13061 | 275 | 3 |
1628606 | 1628606 | 2021-08-18 | Clay | Georgia | 13061 | 274 | 3 |
1625359 | 1625359 | 2021-08-17 | Clay | Georgia | 13061 | 272 | 3 |
1622112 | 1622112 | 2021-08-16 | Clay | Georgia | 13061 | 269 | 3 |
1618865 | 1618865 | 2021-08-15 | Clay | Georgia | 13061 | 267 | 3 |
1615617 | 1615617 | 2021-08-14 | Clay | Georgia | 13061 | 267 | 3 |
1612368 | 1612368 | 2021-08-13 | Clay | Georgia | 13061 | 267 | 3 |
1609120 | 1609120 | 2021-08-12 | Clay | Georgia | 13061 | 267 | 3 |
1605871 | 1605871 | 2021-08-11 | Clay | Georgia | 13061 | 262 | 3 |
1602622 | 1602622 | 2021-08-10 | Clay | Georgia | 13061 | 260 | 3 |
1599373 | 1599373 | 2021-08-09 | Clay | Georgia | 13061 | 258 | 3 |
1596124 | 1596124 | 2021-08-08 | Clay | Georgia | 13061 | 253 | 3 |
1592875 | 1592875 | 2021-08-07 | Clay | Georgia | 13061 | 253 | 3 |
1589626 | 1589626 | 2021-08-06 | Clay | Georgia | 13061 | 253 | 3 |
1586377 | 1586377 | 2021-08-05 | Clay | Georgia | 13061 | 253 | 3 |
1583127 | 1583127 | 2021-08-04 | Clay | Georgia | 13061 | 251 | 3 |
1579877 | 1579877 | 2021-08-03 | Clay | Georgia | 13061 | 249 | 3 |
1576629 | 1576629 | 2021-08-02 | Clay | Georgia | 13061 | 246 | 3 |
1573381 | 1573381 | 2021-08-01 | Clay | Georgia | 13061 | 245 | 3 |
1570133 | 1570133 | 2021-07-31 | Clay | Georgia | 13061 | 245 | 3 |
1566885 | 1566885 | 2021-07-30 | Clay | Georgia | 13061 | 245 | 3 |
1563637 | 1563637 | 2021-07-29 | Clay | Georgia | 13061 | 244 | 3 |
1560389 | 1560389 | 2021-07-28 | Clay | Georgia | 13061 | 243 | 3 |
1557142 | 1557142 | 2021-07-27 | Clay | Georgia | 13061 | 243 | 3 |
1553895 | 1553895 | 2021-07-26 | Clay | Georgia | 13061 | 243 | 3 |
1550648 | 1550648 | 2021-07-25 | Clay | Georgia | 13061 | 242 | 3 |
1547401 | 1547401 | 2021-07-24 | Clay | Georgia | 13061 | 242 | 3 |
1544154 | 1544154 | 2021-07-23 | Clay | Georgia | 13061 | 242 | 3 |
1540906 | 1540906 | 2021-07-22 | Clay | Georgia | 13061 | 241 | 3 |
1537659 | 1537659 | 2021-07-21 | Clay | Georgia | 13061 | 241 | 3 |
1534411 | 1534411 | 2021-07-20 | Clay | Georgia | 13061 | 241 | 3 |
1531164 | 1531164 | 2021-07-19 | Clay | Georgia | 13061 | 241 | 3 |
1527917 | 1527917 | 2021-07-18 | Clay | Georgia | 13061 | 241 | 3 |
1524670 | 1524670 | 2021-07-17 | Clay | Georgia | 13061 | 241 | 3 |
1521422 | 1521422 | 2021-07-16 | Clay | Georgia | 13061 | 241 | 3 |
1518174 | 1518174 | 2021-07-15 | Clay | Georgia | 13061 | 241 | 3 |
1514927 | 1514927 | 2021-07-14 | Clay | Georgia | 13061 | 241 | 3 |
1511681 | 1511681 | 2021-07-13 | Clay | Georgia | 13061 | 241 | 3 |
1508434 | 1508434 | 2021-07-12 | Clay | Georgia | 13061 | 239 | 3 |
1505188 | 1505188 | 2021-07-11 | Clay | Georgia | 13061 | 239 | 3 |
1501942 | 1501942 | 2021-07-10 | Clay | Georgia | 13061 | 239 | 3 |
1498696 | 1498696 | 2021-07-09 | Clay | Georgia | 13061 | 239 | 3 |
1495449 | 1495449 | 2021-07-08 | Clay | Georgia | 13061 | 237 | 3 |
1492203 | 1492203 | 2021-07-07 | Clay | Georgia | 13061 | 237 | 3 |
1488956 | 1488956 | 2021-07-06 | Clay | Georgia | 13061 | 237 | 3 |
1485709 | 1485709 | 2021-07-05 | Clay | Georgia | 13061 | 237 | 3 |
1482463 | 1482463 | 2021-07-04 | Clay | Georgia | 13061 | 237 | 3 |
1479216 | 1479216 | 2021-07-03 | Clay | Georgia | 13061 | 237 | 3 |
1475970 | 1475970 | 2021-07-02 | Clay | Georgia | 13061 | 237 | 3 |
1472724 | 1472724 | 2021-07-01 | Clay | Georgia | 13061 | 237 | 3 |
1469478 | 1469478 | 2021-06-30 | Clay | Georgia | 13061 | 237 | 3 |
1466233 | 1466233 | 2021-06-29 | Clay | Georgia | 13061 | 237 | 3 |
1462988 | 1462988 | 2021-06-28 | Clay | Georgia | 13061 | 237 | 3 |
1459743 | 1459743 | 2021-06-27 | Clay | Georgia | 13061 | 237 | 3 |
1456498 | 1456498 | 2021-06-26 | Clay | Georgia | 13061 | 237 | 3 |
1453253 | 1453253 | 2021-06-25 | Clay | Georgia | 13061 | 237 | 3 |
1450007 | 1450007 | 2021-06-24 | Clay | Georgia | 13061 | 237 | 3 |
1446762 | 1446762 | 2021-06-23 | Clay | Georgia | 13061 | 237 | 3 |
1443517 | 1443517 | 2021-06-22 | Clay | Georgia | 13061 | 237 | 3 |
1440272 | 1440272 | 2021-06-21 | Clay | Georgia | 13061 | 237 | 3 |
1437025 | 1437025 | 2021-06-20 | Clay | Georgia | 13061 | 237 | 3 |
1433778 | 1433778 | 2021-06-19 | Clay | Georgia | 13061 | 237 | 3 |
1430532 | 1430532 | 2021-06-18 | Clay | Georgia | 13061 | 237 | 3 |
1427287 | 1427287 | 2021-06-17 | Clay | Georgia | 13061 | 237 | 3 |
1424042 | 1424042 | 2021-06-16 | Clay | Georgia | 13061 | 237 | 3 |
1420794 | 1420794 | 2021-06-15 | Clay | Georgia | 13061 | 237 | 3 |
1417549 | 1417549 | 2021-06-14 | Clay | Georgia | 13061 | 237 | 3 |
1414303 | 1414303 | 2021-06-13 | Clay | Georgia | 13061 | 237 | 3 |
1411058 | 1411058 | 2021-06-12 | Clay | Georgia | 13061 | 237 | 3 |
1407813 | 1407813 | 2021-06-11 | Clay | Georgia | 13061 | 237 | 3 |
1404567 | 1404567 | 2021-06-10 | Clay | Georgia | 13061 | 237 | 3 |
1401322 | 1401322 | 2021-06-09 | Clay | Georgia | 13061 | 237 | 3 |
1398077 | 1398077 | 2021-06-08 | Clay | Georgia | 13061 | 237 | 3 |
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);