ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clayton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716313 | 1716313 | 2021-09-14 | Clayton | Georgia | 13063 | 35653 | 593 |
1713067 | 1713067 | 2021-09-13 | Clayton | Georgia | 13063 | 35481 | 591 |
1709820 | 1709820 | 2021-09-12 | Clayton | Georgia | 13063 | 35133 | 589 |
1706573 | 1706573 | 2021-09-11 | Clayton | Georgia | 13063 | 35133 | 589 |
1703325 | 1703325 | 2021-09-10 | Clayton | Georgia | 13063 | 35133 | 589 |
1700075 | 1700075 | 2021-09-09 | Clayton | Georgia | 13063 | 34960 | 584 |
1696826 | 1696826 | 2021-09-08 | Clayton | Georgia | 13063 | 34818 | 582 |
1693578 | 1693578 | 2021-09-07 | Clayton | Georgia | 13063 | 34634 | 582 |
1690329 | 1690329 | 2021-09-06 | Clayton | Georgia | 13063 | 34108 | 573 |
1687079 | 1687079 | 2021-09-05 | Clayton | Georgia | 13063 | 34108 | 573 |
1683829 | 1683829 | 2021-09-04 | Clayton | Georgia | 13063 | 34108 | 573 |
1680578 | 1680578 | 2021-09-03 | Clayton | Georgia | 13063 | 34108 | 573 |
1677330 | 1677330 | 2021-09-02 | Clayton | Georgia | 13063 | 33906 | 570 |
1674083 | 1674083 | 2021-09-01 | Clayton | Georgia | 13063 | 33789 | 563 |
1670835 | 1670835 | 2021-08-31 | Clayton | Georgia | 13063 | 33567 | 561 |
1667588 | 1667588 | 2021-08-30 | Clayton | Georgia | 13063 | 33417 | 560 |
1664341 | 1664341 | 2021-08-29 | Clayton | Georgia | 13063 | 32909 | 556 |
1661093 | 1661093 | 2021-08-28 | Clayton | Georgia | 13063 | 32909 | 556 |
1657845 | 1657845 | 2021-08-27 | Clayton | Georgia | 13063 | 32909 | 556 |
1654597 | 1654597 | 2021-08-26 | Clayton | Georgia | 13063 | 32754 | 556 |
1651350 | 1651350 | 2021-08-25 | Clayton | Georgia | 13063 | 32593 | 554 |
1648101 | 1648101 | 2021-08-24 | Clayton | Georgia | 13063 | 32367 | 554 |
1644853 | 1644853 | 2021-08-23 | Clayton | Georgia | 13063 | 32219 | 553 |
1641603 | 1641603 | 2021-08-22 | Clayton | Georgia | 13063 | 31652 | 549 |
1638353 | 1638353 | 2021-08-21 | Clayton | Georgia | 13063 | 31652 | 549 |
1635103 | 1635103 | 2021-08-20 | Clayton | Georgia | 13063 | 31652 | 549 |
1631854 | 1631854 | 2021-08-19 | Clayton | Georgia | 13063 | 31456 | 544 |
1628607 | 1628607 | 2021-08-18 | Clayton | Georgia | 13063 | 31230 | 542 |
1625360 | 1625360 | 2021-08-17 | Clayton | Georgia | 13063 | 31057 | 540 |
1622113 | 1622113 | 2021-08-16 | Clayton | Georgia | 13063 | 30969 | 537 |
1618866 | 1618866 | 2021-08-15 | Clayton | Georgia | 13063 | 30455 | 536 |
1615618 | 1615618 | 2021-08-14 | Clayton | Georgia | 13063 | 30455 | 536 |
1612369 | 1612369 | 2021-08-13 | Clayton | Georgia | 13063 | 30455 | 536 |
1609121 | 1609121 | 2021-08-12 | Clayton | Georgia | 13063 | 30238 | 533 |
1605872 | 1605872 | 2021-08-11 | Clayton | Georgia | 13063 | 30085 | 532 |
1602623 | 1602623 | 2021-08-10 | Clayton | Georgia | 13063 | 29879 | 531 |
1599374 | 1599374 | 2021-08-09 | Clayton | Georgia | 13063 | 29771 | 531 |
1596125 | 1596125 | 2021-08-08 | Clayton | Georgia | 13063 | 29482 | 530 |
1592876 | 1592876 | 2021-08-07 | Clayton | Georgia | 13063 | 29482 | 530 |
1589627 | 1589627 | 2021-08-06 | Clayton | Georgia | 13063 | 29482 | 530 |
1586378 | 1586378 | 2021-08-05 | Clayton | Georgia | 13063 | 29364 | 530 |
1583128 | 1583128 | 2021-08-04 | Clayton | Georgia | 13063 | 29245 | 528 |
1579878 | 1579878 | 2021-08-03 | Clayton | Georgia | 13063 | 29139 | 528 |
1576630 | 1576630 | 2021-08-02 | Clayton | Georgia | 13063 | 28879 | 528 |
1573382 | 1573382 | 2021-08-01 | Clayton | Georgia | 13063 | 28750 | 528 |
1570134 | 1570134 | 2021-07-31 | Clayton | Georgia | 13063 | 28750 | 528 |
1566886 | 1566886 | 2021-07-30 | Clayton | Georgia | 13063 | 28750 | 528 |
1563638 | 1563638 | 2021-07-29 | Clayton | Georgia | 13063 | 28661 | 529 |
1560390 | 1560390 | 2021-07-28 | Clayton | Georgia | 13063 | 28521 | 528 |
1557143 | 1557143 | 2021-07-27 | Clayton | Georgia | 13063 | 28449 | 527 |
1553896 | 1553896 | 2021-07-26 | Clayton | Georgia | 13063 | 28388 | 527 |
1550649 | 1550649 | 2021-07-25 | Clayton | Georgia | 13063 | 28165 | 527 |
1547402 | 1547402 | 2021-07-24 | Clayton | Georgia | 13063 | 28165 | 527 |
1544155 | 1544155 | 2021-07-23 | Clayton | Georgia | 13063 | 28165 | 527 |
1540907 | 1540907 | 2021-07-22 | Clayton | Georgia | 13063 | 28091 | 527 |
1537660 | 1537660 | 2021-07-21 | Clayton | Georgia | 13063 | 28024 | 527 |
1534412 | 1534412 | 2021-07-20 | Clayton | Georgia | 13063 | 27957 | 527 |
1531165 | 1531165 | 2021-07-19 | Clayton | Georgia | 13063 | 27926 | 527 |
1527918 | 1527918 | 2021-07-18 | Clayton | Georgia | 13063 | 27837 | 527 |
1524671 | 1524671 | 2021-07-17 | Clayton | Georgia | 13063 | 27837 | 527 |
1521423 | 1521423 | 2021-07-16 | Clayton | Georgia | 13063 | 27837 | 527 |
1518175 | 1518175 | 2021-07-15 | Clayton | Georgia | 13063 | 27821 | 527 |
1514928 | 1514928 | 2021-07-14 | Clayton | Georgia | 13063 | 27791 | 527 |
1511682 | 1511682 | 2021-07-13 | Clayton | Georgia | 13063 | 27763 | 527 |
1508435 | 1508435 | 2021-07-12 | Clayton | Georgia | 13063 | 27737 | 525 |
1505189 | 1505189 | 2021-07-11 | Clayton | Georgia | 13063 | 27685 | 525 |
1501943 | 1501943 | 2021-07-10 | Clayton | Georgia | 13063 | 27685 | 525 |
1498697 | 1498697 | 2021-07-09 | Clayton | Georgia | 13063 | 27685 | 525 |
1495450 | 1495450 | 2021-07-08 | Clayton | Georgia | 13063 | 27670 | 527 |
1492204 | 1492204 | 2021-07-07 | Clayton | Georgia | 13063 | 27648 | 526 |
1488957 | 1488957 | 2021-07-06 | Clayton | Georgia | 13063 | 27634 | 526 |
1485710 | 1485710 | 2021-07-05 | Clayton | Georgia | 13063 | 27589 | 525 |
1482464 | 1482464 | 2021-07-04 | Clayton | Georgia | 13063 | 27589 | 525 |
1479217 | 1479217 | 2021-07-03 | Clayton | Georgia | 13063 | 27589 | 525 |
1475971 | 1475971 | 2021-07-02 | Clayton | Georgia | 13063 | 27589 | 525 |
1472725 | 1472725 | 2021-07-01 | Clayton | Georgia | 13063 | 27581 | 525 |
1469479 | 1469479 | 2021-06-30 | Clayton | Georgia | 13063 | 27571 | 525 |
1466234 | 1466234 | 2021-06-29 | Clayton | Georgia | 13063 | 27537 | 523 |
1462989 | 1462989 | 2021-06-28 | Clayton | Georgia | 13063 | 27537 | 523 |
1459744 | 1459744 | 2021-06-27 | Clayton | Georgia | 13063 | 27529 | 523 |
1456499 | 1456499 | 2021-06-26 | Clayton | Georgia | 13063 | 27520 | 523 |
1453254 | 1453254 | 2021-06-25 | Clayton | Georgia | 13063 | 27509 | 522 |
1450008 | 1450008 | 2021-06-24 | Clayton | Georgia | 13063 | 27500 | 522 |
1446763 | 1446763 | 2021-06-23 | Clayton | Georgia | 13063 | 27490 | 522 |
1443518 | 1443518 | 2021-06-22 | Clayton | Georgia | 13063 | 27471 | 520 |
1440273 | 1440273 | 2021-06-21 | Clayton | Georgia | 13063 | 27446 | 520 |
1437026 | 1437026 | 2021-06-20 | Clayton | Georgia | 13063 | 27440 | 520 |
1433779 | 1433779 | 2021-06-19 | Clayton | Georgia | 13063 | 27438 | 520 |
1430533 | 1430533 | 2021-06-18 | Clayton | Georgia | 13063 | 27431 | 519 |
1427288 | 1427288 | 2021-06-17 | Clayton | Georgia | 13063 | 27413 | 518 |
1424043 | 1424043 | 2021-06-16 | Clayton | Georgia | 13063 | 27396 | 514 |
1420795 | 1420795 | 2021-06-15 | Clayton | Georgia | 13063 | 27382 | 514 |
1417550 | 1417550 | 2021-06-14 | Clayton | Georgia | 13063 | 27375 | 514 |
1414304 | 1414304 | 2021-06-13 | Clayton | Georgia | 13063 | 27369 | 514 |
1411059 | 1411059 | 2021-06-12 | Clayton | Georgia | 13063 | 27362 | 514 |
1407814 | 1407814 | 2021-06-11 | Clayton | Georgia | 13063 | 27351 | 511 |
1404568 | 1404568 | 2021-06-10 | Clayton | Georgia | 13063 | 27335 | 511 |
1401323 | 1401323 | 2021-06-09 | Clayton | Georgia | 13063 | 27315 | 509 |
1398078 | 1398078 | 2021-06-08 | Clayton | Georgia | 13063 | 27295 | 508 |
1394831 | 1394831 | 2021-06-07 | Clayton | Georgia | 13063 | 27282 | 507 |
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);