ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 13073 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716318 | 1716318 | 2021-09-14 | Columbia | Georgia | 13073 | 23109 | 234 |
1713072 | 1713072 | 2021-09-13 | Columbia | Georgia | 13073 | 23010 | 233 |
1709825 | 1709825 | 2021-09-12 | Columbia | Georgia | 13073 | 22786 | 233 |
1706578 | 1706578 | 2021-09-11 | Columbia | Georgia | 13073 | 22786 | 233 |
1703330 | 1703330 | 2021-09-10 | Columbia | Georgia | 13073 | 22786 | 233 |
1700080 | 1700080 | 2021-09-09 | Columbia | Georgia | 13073 | 22609 | 232 |
1696831 | 1696831 | 2021-09-08 | Columbia | Georgia | 13073 | 22438 | 228 |
1693583 | 1693583 | 2021-09-07 | Columbia | Georgia | 13073 | 22202 | 228 |
1690334 | 1690334 | 2021-09-06 | Columbia | Georgia | 13073 | 21829 | 224 |
1687084 | 1687084 | 2021-09-05 | Columbia | Georgia | 13073 | 21829 | 224 |
1683834 | 1683834 | 2021-09-04 | Columbia | Georgia | 13073 | 21829 | 224 |
1680583 | 1680583 | 2021-09-03 | Columbia | Georgia | 13073 | 21829 | 224 |
1677335 | 1677335 | 2021-09-02 | Columbia | Georgia | 13073 | 21565 | 221 |
1674088 | 1674088 | 2021-09-01 | Columbia | Georgia | 13073 | 21415 | 222 |
1670840 | 1670840 | 2021-08-31 | Columbia | Georgia | 13073 | 21260 | 222 |
1667593 | 1667593 | 2021-08-30 | Columbia | Georgia | 13073 | 21087 | 222 |
1664346 | 1664346 | 2021-08-29 | Columbia | Georgia | 13073 | 20651 | 221 |
1661098 | 1661098 | 2021-08-28 | Columbia | Georgia | 13073 | 20651 | 221 |
1657850 | 1657850 | 2021-08-27 | Columbia | Georgia | 13073 | 20651 | 221 |
1654602 | 1654602 | 2021-08-26 | Columbia | Georgia | 13073 | 20504 | 220 |
1651355 | 1651355 | 2021-08-25 | Columbia | Georgia | 13073 | 20266 | 219 |
1648106 | 1648106 | 2021-08-24 | Columbia | Georgia | 13073 | 20085 | 218 |
1644858 | 1644858 | 2021-08-23 | Columbia | Georgia | 13073 | 19891 | 218 |
1641608 | 1641608 | 2021-08-22 | Columbia | Georgia | 13073 | 19558 | 218 |
1638358 | 1638358 | 2021-08-21 | Columbia | Georgia | 13073 | 19558 | 218 |
1635108 | 1635108 | 2021-08-20 | Columbia | Georgia | 13073 | 19558 | 218 |
1631859 | 1631859 | 2021-08-19 | Columbia | Georgia | 13073 | 19430 | 218 |
1628612 | 1628612 | 2021-08-18 | Columbia | Georgia | 13073 | 19292 | 217 |
1625365 | 1625365 | 2021-08-17 | Columbia | Georgia | 13073 | 19157 | 216 |
1622118 | 1622118 | 2021-08-16 | Columbia | Georgia | 13073 | 19047 | 216 |
1618871 | 1618871 | 2021-08-15 | Columbia | Georgia | 13073 | 18886 | 215 |
1615623 | 1615623 | 2021-08-14 | Columbia | Georgia | 13073 | 18886 | 215 |
1612374 | 1612374 | 2021-08-13 | Columbia | Georgia | 13073 | 18886 | 215 |
1609126 | 1609126 | 2021-08-12 | Columbia | Georgia | 13073 | 18783 | 215 |
1605877 | 1605877 | 2021-08-11 | Columbia | Georgia | 13073 | 18677 | 213 |
1602628 | 1602628 | 2021-08-10 | Columbia | Georgia | 13073 | 18563 | 213 |
1599379 | 1599379 | 2021-08-09 | Columbia | Georgia | 13073 | 18454 | 213 |
1596130 | 1596130 | 2021-08-08 | Columbia | Georgia | 13073 | 18319 | 213 |
1592881 | 1592881 | 2021-08-07 | Columbia | Georgia | 13073 | 18319 | 213 |
1589632 | 1589632 | 2021-08-06 | Columbia | Georgia | 13073 | 18319 | 213 |
1586383 | 1586383 | 2021-08-05 | Columbia | Georgia | 13073 | 18217 | 213 |
1583133 | 1583133 | 2021-08-04 | Columbia | Georgia | 13073 | 18137 | 212 |
1579883 | 1579883 | 2021-08-03 | Columbia | Georgia | 13073 | 18043 | 212 |
1576635 | 1576635 | 2021-08-02 | Columbia | Georgia | 13073 | 17918 | 212 |
1573387 | 1573387 | 2021-08-01 | Columbia | Georgia | 13073 | 17791 | 212 |
1570139 | 1570139 | 2021-07-31 | Columbia | Georgia | 13073 | 17791 | 212 |
1566891 | 1566891 | 2021-07-30 | Columbia | Georgia | 13073 | 17791 | 212 |
1563643 | 1563643 | 2021-07-29 | Columbia | Georgia | 13073 | 17729 | 212 |
1560395 | 1560395 | 2021-07-28 | Columbia | Georgia | 13073 | 17644 | 212 |
1557148 | 1557148 | 2021-07-27 | Columbia | Georgia | 13073 | 17564 | 212 |
1553901 | 1553901 | 2021-07-26 | Columbia | Georgia | 13073 | 17508 | 211 |
1550654 | 1550654 | 2021-07-25 | Columbia | Georgia | 13073 | 17428 | 211 |
1547407 | 1547407 | 2021-07-24 | Columbia | Georgia | 13073 | 17428 | 211 |
1544160 | 1544160 | 2021-07-23 | Columbia | Georgia | 13073 | 17428 | 211 |
1540912 | 1540912 | 2021-07-22 | Columbia | Georgia | 13073 | 17386 | 211 |
1537665 | 1537665 | 2021-07-21 | Columbia | Georgia | 13073 | 17369 | 211 |
1534417 | 1534417 | 2021-07-20 | Columbia | Georgia | 13073 | 17345 | 211 |
1531170 | 1531170 | 2021-07-19 | Columbia | Georgia | 13073 | 17313 | 211 |
1527923 | 1527923 | 2021-07-18 | Columbia | Georgia | 13073 | 17271 | 211 |
1524676 | 1524676 | 2021-07-17 | Columbia | Georgia | 13073 | 17271 | 211 |
1521428 | 1521428 | 2021-07-16 | Columbia | Georgia | 13073 | 17271 | 211 |
1518180 | 1518180 | 2021-07-15 | Columbia | Georgia | 13073 | 17263 | 211 |
1514933 | 1514933 | 2021-07-14 | Columbia | Georgia | 13073 | 17251 | 211 |
1511687 | 1511687 | 2021-07-13 | Columbia | Georgia | 13073 | 17242 | 211 |
1508440 | 1508440 | 2021-07-12 | Columbia | Georgia | 13073 | 17226 | 211 |
1505194 | 1505194 | 2021-07-11 | Columbia | Georgia | 13073 | 17213 | 211 |
1501948 | 1501948 | 2021-07-10 | Columbia | Georgia | 13073 | 17213 | 211 |
1498702 | 1498702 | 2021-07-09 | Columbia | Georgia | 13073 | 17213 | 211 |
1495455 | 1495455 | 2021-07-08 | Columbia | Georgia | 13073 | 17205 | 211 |
1492209 | 1492209 | 2021-07-07 | Columbia | Georgia | 13073 | 17195 | 211 |
1488962 | 1488962 | 2021-07-06 | Columbia | Georgia | 13073 | 17185 | 213 |
1485715 | 1485715 | 2021-07-05 | Columbia | Georgia | 13073 | 17178 | 213 |
1482469 | 1482469 | 2021-07-04 | Columbia | Georgia | 13073 | 17178 | 213 |
1479222 | 1479222 | 2021-07-03 | Columbia | Georgia | 13073 | 17178 | 213 |
1475976 | 1475976 | 2021-07-02 | Columbia | Georgia | 13073 | 17178 | 213 |
1472730 | 1472730 | 2021-07-01 | Columbia | Georgia | 13073 | 17177 | 213 |
1469484 | 1469484 | 2021-06-30 | Columbia | Georgia | 13073 | 17171 | 213 |
1466239 | 1466239 | 2021-06-29 | Columbia | Georgia | 13073 | 17159 | 213 |
1462994 | 1462994 | 2021-06-28 | Columbia | Georgia | 13073 | 17159 | 213 |
1459749 | 1459749 | 2021-06-27 | Columbia | Georgia | 13073 | 17158 | 213 |
1456504 | 1456504 | 2021-06-26 | Columbia | Georgia | 13073 | 17157 | 213 |
1453259 | 1453259 | 2021-06-25 | Columbia | Georgia | 13073 | 17154 | 213 |
1450013 | 1450013 | 2021-06-24 | Columbia | Georgia | 13073 | 17145 | 213 |
1446768 | 1446768 | 2021-06-23 | Columbia | Georgia | 13073 | 17143 | 213 |
1443523 | 1443523 | 2021-06-22 | Columbia | Georgia | 13073 | 17138 | 213 |
1440278 | 1440278 | 2021-06-21 | Columbia | Georgia | 13073 | 17132 | 213 |
1437031 | 1437031 | 2021-06-20 | Columbia | Georgia | 13073 | 17131 | 213 |
1433784 | 1433784 | 2021-06-19 | Columbia | Georgia | 13073 | 17126 | 212 |
1430538 | 1430538 | 2021-06-18 | Columbia | Georgia | 13073 | 17122 | 212 |
1427293 | 1427293 | 2021-06-17 | Columbia | Georgia | 13073 | 17108 | 211 |
1424048 | 1424048 | 2021-06-16 | Columbia | Georgia | 13073 | 17105 | 211 |
1420800 | 1420800 | 2021-06-15 | Columbia | Georgia | 13073 | 17103 | 211 |
1417555 | 1417555 | 2021-06-14 | Columbia | Georgia | 13073 | 17096 | 211 |
1414309 | 1414309 | 2021-06-13 | Columbia | Georgia | 13073 | 17094 | 211 |
1411064 | 1411064 | 2021-06-12 | Columbia | Georgia | 13073 | 17091 | 211 |
1407819 | 1407819 | 2021-06-11 | Columbia | Georgia | 13073 | 17086 | 211 |
1404573 | 1404573 | 2021-06-10 | Columbia | Georgia | 13073 | 17083 | 211 |
1401328 | 1401328 | 2021-06-09 | Columbia | Georgia | 13073 | 17080 | 210 |
1398083 | 1398083 | 2021-06-08 | Columbia | Georgia | 13073 | 17074 | 210 |
1394836 | 1394836 | 2021-06-07 | Columbia | Georgia | 13073 | 17071 | 210 |
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);