ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 13285 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716423 | 1716423 | 2021-09-14 | Troup | Georgia | 13285 | 10339 | 267 |
1713177 | 1713177 | 2021-09-13 | Troup | Georgia | 13285 | 10301 | 267 |
1709930 | 1709930 | 2021-09-12 | Troup | Georgia | 13285 | 10204 | 265 |
1706683 | 1706683 | 2021-09-11 | Troup | Georgia | 13285 | 10204 | 265 |
1703435 | 1703435 | 2021-09-10 | Troup | Georgia | 13285 | 10204 | 265 |
1700185 | 1700185 | 2021-09-09 | Troup | Georgia | 13285 | 10179 | 264 |
1696936 | 1696936 | 2021-09-08 | Troup | Georgia | 13285 | 10144 | 261 |
1693688 | 1693688 | 2021-09-07 | Troup | Georgia | 13285 | 10103 | 260 |
1690439 | 1690439 | 2021-09-06 | Troup | Georgia | 13285 | 9952 | 256 |
1687189 | 1687189 | 2021-09-05 | Troup | Georgia | 13285 | 9952 | 256 |
1683939 | 1683939 | 2021-09-04 | Troup | Georgia | 13285 | 9952 | 256 |
1680688 | 1680688 | 2021-09-03 | Troup | Georgia | 13285 | 9952 | 256 |
1677440 | 1677440 | 2021-09-02 | Troup | Georgia | 13285 | 9846 | 256 |
1674193 | 1674193 | 2021-09-01 | Troup | Georgia | 13285 | 9812 | 256 |
1670945 | 1670945 | 2021-08-31 | Troup | Georgia | 13285 | 9765 | 255 |
1667698 | 1667698 | 2021-08-30 | Troup | Georgia | 13285 | 9697 | 254 |
1664451 | 1664451 | 2021-08-29 | Troup | Georgia | 13285 | 9522 | 252 |
1661203 | 1661203 | 2021-08-28 | Troup | Georgia | 13285 | 9522 | 252 |
1657955 | 1657955 | 2021-08-27 | Troup | Georgia | 13285 | 9522 | 252 |
1654707 | 1654707 | 2021-08-26 | Troup | Georgia | 13285 | 9419 | 250 |
1651460 | 1651460 | 2021-08-25 | Troup | Georgia | 13285 | 9360 | 250 |
1648211 | 1648211 | 2021-08-24 | Troup | Georgia | 13285 | 9275 | 249 |
1644963 | 1644963 | 2021-08-23 | Troup | Georgia | 13285 | 9208 | 248 |
1641713 | 1641713 | 2021-08-22 | Troup | Georgia | 13285 | 9065 | 247 |
1638463 | 1638463 | 2021-08-21 | Troup | Georgia | 13285 | 9065 | 247 |
1635213 | 1635213 | 2021-08-20 | Troup | Georgia | 13285 | 9065 | 247 |
1631964 | 1631964 | 2021-08-19 | Troup | Georgia | 13285 | 9018 | 247 |
1628717 | 1628717 | 2021-08-18 | Troup | Georgia | 13285 | 8942 | 247 |
1625470 | 1625470 | 2021-08-17 | Troup | Georgia | 13285 | 8881 | 247 |
1622223 | 1622223 | 2021-08-16 | Troup | Georgia | 13285 | 8830 | 247 |
1618976 | 1618976 | 2021-08-15 | Troup | Georgia | 13285 | 8706 | 248 |
1615728 | 1615728 | 2021-08-14 | Troup | Georgia | 13285 | 8706 | 248 |
1612479 | 1612479 | 2021-08-13 | Troup | Georgia | 13285 | 8706 | 248 |
1609231 | 1609231 | 2021-08-12 | Troup | Georgia | 13285 | 8659 | 247 |
1605982 | 1605982 | 2021-08-11 | Troup | Georgia | 13285 | 8622 | 244 |
1602733 | 1602733 | 2021-08-10 | Troup | Georgia | 13285 | 8555 | 244 |
1599484 | 1599484 | 2021-08-09 | Troup | Georgia | 13285 | 8524 | 243 |
1596235 | 1596235 | 2021-08-08 | Troup | Georgia | 13285 | 8387 | 243 |
1592986 | 1592986 | 2021-08-07 | Troup | Georgia | 13285 | 8387 | 243 |
1589737 | 1589737 | 2021-08-06 | Troup | Georgia | 13285 | 8387 | 243 |
1586488 | 1586488 | 2021-08-05 | Troup | Georgia | 13285 | 8330 | 243 |
1583238 | 1583238 | 2021-08-04 | Troup | Georgia | 13285 | 8290 | 243 |
1579988 | 1579988 | 2021-08-03 | Troup | Georgia | 13285 | 8257 | 242 |
1576740 | 1576740 | 2021-08-02 | Troup | Georgia | 13285 | 8155 | 242 |
1573492 | 1573492 | 2021-08-01 | Troup | Georgia | 13285 | 8108 | 242 |
1570244 | 1570244 | 2021-07-31 | Troup | Georgia | 13285 | 8108 | 242 |
1566996 | 1566996 | 2021-07-30 | Troup | Georgia | 13285 | 8108 | 242 |
1563748 | 1563748 | 2021-07-29 | Troup | Georgia | 13285 | 8075 | 241 |
1560500 | 1560500 | 2021-07-28 | Troup | Georgia | 13285 | 8046 | 241 |
1557253 | 1557253 | 2021-07-27 | Troup | Georgia | 13285 | 8025 | 241 |
1554006 | 1554006 | 2021-07-26 | Troup | Georgia | 13285 | 7980 | 241 |
1550759 | 1550759 | 2021-07-25 | Troup | Georgia | 13285 | 7930 | 241 |
1547512 | 1547512 | 2021-07-24 | Troup | Georgia | 13285 | 7930 | 241 |
1544265 | 1544265 | 2021-07-23 | Troup | Georgia | 13285 | 7930 | 241 |
1541017 | 1541017 | 2021-07-22 | Troup | Georgia | 13285 | 7905 | 241 |
1537770 | 1537770 | 2021-07-21 | Troup | Georgia | 13285 | 7878 | 240 |
1534522 | 1534522 | 2021-07-20 | Troup | Georgia | 13285 | 7848 | 240 |
1531275 | 1531275 | 2021-07-19 | Troup | Georgia | 13285 | 7829 | 240 |
1528028 | 1528028 | 2021-07-18 | Troup | Georgia | 13285 | 7803 | 240 |
1524781 | 1524781 | 2021-07-17 | Troup | Georgia | 13285 | 7803 | 240 |
1521533 | 1521533 | 2021-07-16 | Troup | Georgia | 13285 | 7803 | 240 |
1518285 | 1518285 | 2021-07-15 | Troup | Georgia | 13285 | 7794 | 240 |
1515038 | 1515038 | 2021-07-14 | Troup | Georgia | 13285 | 7778 | 239 |
1511792 | 1511792 | 2021-07-13 | Troup | Georgia | 13285 | 7751 | 239 |
1508545 | 1508545 | 2021-07-12 | Troup | Georgia | 13285 | 7742 | 239 |
1505299 | 1505299 | 2021-07-11 | Troup | Georgia | 13285 | 7711 | 239 |
1502053 | 1502053 | 2021-07-10 | Troup | Georgia | 13285 | 7711 | 239 |
1498807 | 1498807 | 2021-07-09 | Troup | Georgia | 13285 | 7711 | 239 |
1495560 | 1495560 | 2021-07-08 | Troup | Georgia | 13285 | 7705 | 239 |
1492314 | 1492314 | 2021-07-07 | Troup | Georgia | 13285 | 7696 | 239 |
1489067 | 1489067 | 2021-07-06 | Troup | Georgia | 13285 | 7688 | 239 |
1485820 | 1485820 | 2021-07-05 | Troup | Georgia | 13285 | 7666 | 239 |
1482574 | 1482574 | 2021-07-04 | Troup | Georgia | 13285 | 7666 | 239 |
1479327 | 1479327 | 2021-07-03 | Troup | Georgia | 13285 | 7666 | 239 |
1476081 | 1476081 | 2021-07-02 | Troup | Georgia | 13285 | 7666 | 239 |
1472835 | 1472835 | 2021-07-01 | Troup | Georgia | 13285 | 7665 | 238 |
1469589 | 1469589 | 2021-06-30 | Troup | Georgia | 13285 | 7651 | 238 |
1466344 | 1466344 | 2021-06-29 | Troup | Georgia | 13285 | 7645 | 237 |
1463099 | 1463099 | 2021-06-28 | Troup | Georgia | 13285 | 7645 | 237 |
1459854 | 1459854 | 2021-06-27 | Troup | Georgia | 13285 | 7640 | 237 |
1456609 | 1456609 | 2021-06-26 | Troup | Georgia | 13285 | 7639 | 237 |
1453364 | 1453364 | 2021-06-25 | Troup | Georgia | 13285 | 7636 | 235 |
1450118 | 1450118 | 2021-06-24 | Troup | Georgia | 13285 | 7634 | 235 |
1446873 | 1446873 | 2021-06-23 | Troup | Georgia | 13285 | 7632 | 235 |
1443628 | 1443628 | 2021-06-22 | Troup | Georgia | 13285 | 7631 | 235 |
1440383 | 1440383 | 2021-06-21 | Troup | Georgia | 13285 | 7630 | 235 |
1437136 | 1437136 | 2021-06-20 | Troup | Georgia | 13285 | 7629 | 235 |
1433889 | 1433889 | 2021-06-19 | Troup | Georgia | 13285 | 7627 | 235 |
1430643 | 1430643 | 2021-06-18 | Troup | Georgia | 13285 | 7627 | 234 |
1427398 | 1427398 | 2021-06-17 | Troup | Georgia | 13285 | 7624 | 234 |
1424153 | 1424153 | 2021-06-16 | Troup | Georgia | 13285 | 7618 | 234 |
1420905 | 1420905 | 2021-06-15 | Troup | Georgia | 13285 | 7618 | 234 |
1417660 | 1417660 | 2021-06-14 | Troup | Georgia | 13285 | 7618 | 234 |
1414414 | 1414414 | 2021-06-13 | Troup | Georgia | 13285 | 7616 | 234 |
1411169 | 1411169 | 2021-06-12 | Troup | Georgia | 13285 | 7616 | 234 |
1407924 | 1407924 | 2021-06-11 | Troup | Georgia | 13285 | 7615 | 234 |
1404678 | 1404678 | 2021-06-10 | Troup | Georgia | 13285 | 7613 | 235 |
1401433 | 1401433 | 2021-06-09 | Troup | Georgia | 13285 | 7611 | 235 |
1398188 | 1398188 | 2021-06-08 | Troup | Georgia | 13285 | 7607 | 235 |
1394941 | 1394941 | 2021-06-07 | Troup | Georgia | 13285 | 7606 | 234 |
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);