ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 13103 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716333 | 1716333 | 2021-09-14 | Effingham | Georgia | 13103 | 8364 | 107 |
1713087 | 1713087 | 2021-09-13 | Effingham | Georgia | 13103 | 8328 | 105 |
1709840 | 1709840 | 2021-09-12 | Effingham | Georgia | 13103 | 8196 | 102 |
1706593 | 1706593 | 2021-09-11 | Effingham | Georgia | 13103 | 8196 | 102 |
1703345 | 1703345 | 2021-09-10 | Effingham | Georgia | 13103 | 8196 | 102 |
1700095 | 1700095 | 2021-09-09 | Effingham | Georgia | 13103 | 8136 | 99 |
1696846 | 1696846 | 2021-09-08 | Effingham | Georgia | 13103 | 8082 | 94 |
1693598 | 1693598 | 2021-09-07 | Effingham | Georgia | 13103 | 8024 | 94 |
1690349 | 1690349 | 2021-09-06 | Effingham | Georgia | 13103 | 7681 | 93 |
1687099 | 1687099 | 2021-09-05 | Effingham | Georgia | 13103 | 7681 | 93 |
1683849 | 1683849 | 2021-09-04 | Effingham | Georgia | 13103 | 7681 | 93 |
1680598 | 1680598 | 2021-09-03 | Effingham | Georgia | 13103 | 7681 | 93 |
1677350 | 1677350 | 2021-09-02 | Effingham | Georgia | 13103 | 7546 | 92 |
1674103 | 1674103 | 2021-09-01 | Effingham | Georgia | 13103 | 7439 | 89 |
1670855 | 1670855 | 2021-08-31 | Effingham | Georgia | 13103 | 7352 | 87 |
1667608 | 1667608 | 2021-08-30 | Effingham | Georgia | 13103 | 7200 | 85 |
1664361 | 1664361 | 2021-08-29 | Effingham | Georgia | 13103 | 6888 | 84 |
1661113 | 1661113 | 2021-08-28 | Effingham | Georgia | 13103 | 6888 | 84 |
1657865 | 1657865 | 2021-08-27 | Effingham | Georgia | 13103 | 6888 | 84 |
1654617 | 1654617 | 2021-08-26 | Effingham | Georgia | 13103 | 6775 | 84 |
1651370 | 1651370 | 2021-08-25 | Effingham | Georgia | 13103 | 6625 | 84 |
1648121 | 1648121 | 2021-08-24 | Effingham | Georgia | 13103 | 6541 | 82 |
1644873 | 1644873 | 2021-08-23 | Effingham | Georgia | 13103 | 6438 | 82 |
1641623 | 1641623 | 2021-08-22 | Effingham | Georgia | 13103 | 6181 | 82 |
1638373 | 1638373 | 2021-08-21 | Effingham | Georgia | 13103 | 6181 | 82 |
1635123 | 1635123 | 2021-08-20 | Effingham | Georgia | 13103 | 6181 | 82 |
1631874 | 1631874 | 2021-08-19 | Effingham | Georgia | 13103 | 6078 | 79 |
1628627 | 1628627 | 2021-08-18 | Effingham | Georgia | 13103 | 5959 | 79 |
1625380 | 1625380 | 2021-08-17 | Effingham | Georgia | 13103 | 5917 | 78 |
1622133 | 1622133 | 2021-08-16 | Effingham | Georgia | 13103 | 5854 | 78 |
1618886 | 1618886 | 2021-08-15 | Effingham | Georgia | 13103 | 5633 | 78 |
1615638 | 1615638 | 2021-08-14 | Effingham | Georgia | 13103 | 5633 | 78 |
1612389 | 1612389 | 2021-08-13 | Effingham | Georgia | 13103 | 5633 | 78 |
1609141 | 1609141 | 2021-08-12 | Effingham | Georgia | 13103 | 5591 | 78 |
1605892 | 1605892 | 2021-08-11 | Effingham | Georgia | 13103 | 5512 | 77 |
1602643 | 1602643 | 2021-08-10 | Effingham | Georgia | 13103 | 5479 | 77 |
1599394 | 1599394 | 2021-08-09 | Effingham | Georgia | 13103 | 5407 | 77 |
1596145 | 1596145 | 2021-08-08 | Effingham | Georgia | 13103 | 5310 | 77 |
1592896 | 1592896 | 2021-08-07 | Effingham | Georgia | 13103 | 5310 | 77 |
1589647 | 1589647 | 2021-08-06 | Effingham | Georgia | 13103 | 5310 | 77 |
1586398 | 1586398 | 2021-08-05 | Effingham | Georgia | 13103 | 5254 | 76 |
1583148 | 1583148 | 2021-08-04 | Effingham | Georgia | 13103 | 5209 | 76 |
1579898 | 1579898 | 2021-08-03 | Effingham | Georgia | 13103 | 5159 | 76 |
1576650 | 1576650 | 2021-08-02 | Effingham | Georgia | 13103 | 5095 | 76 |
1573402 | 1573402 | 2021-08-01 | Effingham | Georgia | 13103 | 5056 | 76 |
1570154 | 1570154 | 2021-07-31 | Effingham | Georgia | 13103 | 5056 | 76 |
1566906 | 1566906 | 2021-07-30 | Effingham | Georgia | 13103 | 5056 | 76 |
1563658 | 1563658 | 2021-07-29 | Effingham | Georgia | 13103 | 5022 | 76 |
1560410 | 1560410 | 2021-07-28 | Effingham | Georgia | 13103 | 5000 | 75 |
1557163 | 1557163 | 2021-07-27 | Effingham | Georgia | 13103 | 4963 | 75 |
1553916 | 1553916 | 2021-07-26 | Effingham | Georgia | 13103 | 4944 | 75 |
1550669 | 1550669 | 2021-07-25 | Effingham | Georgia | 13103 | 4895 | 74 |
1547422 | 1547422 | 2021-07-24 | Effingham | Georgia | 13103 | 4895 | 74 |
1544175 | 1544175 | 2021-07-23 | Effingham | Georgia | 13103 | 4895 | 74 |
1540927 | 1540927 | 2021-07-22 | Effingham | Georgia | 13103 | 4879 | 74 |
1537680 | 1537680 | 2021-07-21 | Effingham | Georgia | 13103 | 4865 | 74 |
1534432 | 1534432 | 2021-07-20 | Effingham | Georgia | 13103 | 4842 | 74 |
1531185 | 1531185 | 2021-07-19 | Effingham | Georgia | 13103 | 4825 | 74 |
1527938 | 1527938 | 2021-07-18 | Effingham | Georgia | 13103 | 4805 | 74 |
1524691 | 1524691 | 2021-07-17 | Effingham | Georgia | 13103 | 4805 | 74 |
1521443 | 1521443 | 2021-07-16 | Effingham | Georgia | 13103 | 4805 | 74 |
1518195 | 1518195 | 2021-07-15 | Effingham | Georgia | 13103 | 4791 | 74 |
1514948 | 1514948 | 2021-07-14 | Effingham | Georgia | 13103 | 4784 | 74 |
1511702 | 1511702 | 2021-07-13 | Effingham | Georgia | 13103 | 4777 | 74 |
1508455 | 1508455 | 2021-07-12 | Effingham | Georgia | 13103 | 4769 | 74 |
1505209 | 1505209 | 2021-07-11 | Effingham | Georgia | 13103 | 4761 | 74 |
1501963 | 1501963 | 2021-07-10 | Effingham | Georgia | 13103 | 4761 | 74 |
1498717 | 1498717 | 2021-07-09 | Effingham | Georgia | 13103 | 4761 | 74 |
1495470 | 1495470 | 2021-07-08 | Effingham | Georgia | 13103 | 4758 | 74 |
1492224 | 1492224 | 2021-07-07 | Effingham | Georgia | 13103 | 4748 | 74 |
1488977 | 1488977 | 2021-07-06 | Effingham | Georgia | 13103 | 4745 | 74 |
1485730 | 1485730 | 2021-07-05 | Effingham | Georgia | 13103 | 4741 | 74 |
1482484 | 1482484 | 2021-07-04 | Effingham | Georgia | 13103 | 4741 | 74 |
1479237 | 1479237 | 2021-07-03 | Effingham | Georgia | 13103 | 4741 | 74 |
1475991 | 1475991 | 2021-07-02 | Effingham | Georgia | 13103 | 4741 | 74 |
1472745 | 1472745 | 2021-07-01 | Effingham | Georgia | 13103 | 4738 | 73 |
1469499 | 1469499 | 2021-06-30 | Effingham | Georgia | 13103 | 4737 | 73 |
1466254 | 1466254 | 2021-06-29 | Effingham | Georgia | 13103 | 4731 | 73 |
1463009 | 1463009 | 2021-06-28 | Effingham | Georgia | 13103 | 4731 | 73 |
1459764 | 1459764 | 2021-06-27 | Effingham | Georgia | 13103 | 4730 | 73 |
1456519 | 1456519 | 2021-06-26 | Effingham | Georgia | 13103 | 4729 | 73 |
1453274 | 1453274 | 2021-06-25 | Effingham | Georgia | 13103 | 4729 | 72 |
1450028 | 1450028 | 2021-06-24 | Effingham | Georgia | 13103 | 4727 | 72 |
1446783 | 1446783 | 2021-06-23 | Effingham | Georgia | 13103 | 4724 | 72 |
1443538 | 1443538 | 2021-06-22 | Effingham | Georgia | 13103 | 4719 | 72 |
1440293 | 1440293 | 2021-06-21 | Effingham | Georgia | 13103 | 4719 | 72 |
1437046 | 1437046 | 2021-06-20 | Effingham | Georgia | 13103 | 4718 | 72 |
1433799 | 1433799 | 2021-06-19 | Effingham | Georgia | 13103 | 4716 | 72 |
1430553 | 1430553 | 2021-06-18 | Effingham | Georgia | 13103 | 4716 | 72 |
1427308 | 1427308 | 2021-06-17 | Effingham | Georgia | 13103 | 4716 | 72 |
1424063 | 1424063 | 2021-06-16 | Effingham | Georgia | 13103 | 4715 | 72 |
1420815 | 1420815 | 2021-06-15 | Effingham | Georgia | 13103 | 4710 | 72 |
1417570 | 1417570 | 2021-06-14 | Effingham | Georgia | 13103 | 4706 | 72 |
1414324 | 1414324 | 2021-06-13 | Effingham | Georgia | 13103 | 4706 | 72 |
1411079 | 1411079 | 2021-06-12 | Effingham | Georgia | 13103 | 4703 | 72 |
1407834 | 1407834 | 2021-06-11 | Effingham | Georgia | 13103 | 4701 | 72 |
1404588 | 1404588 | 2021-06-10 | Effingham | Georgia | 13103 | 4695 | 69 |
1401343 | 1401343 | 2021-06-09 | Effingham | Georgia | 13103 | 4695 | 69 |
1398098 | 1398098 | 2021-06-08 | Effingham | Georgia | 13103 | 4690 | 69 |
1394851 | 1394851 | 2021-06-07 | Effingham | Georgia | 13103 | 4687 | 69 |
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);