ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Floyd" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716339 | 1716339 | 2021-09-14 | Floyd | Georgia | 13115 | 16734 | 279 |
1713093 | 1713093 | 2021-09-13 | Floyd | Georgia | 13115 | 16665 | 274 |
1709846 | 1709846 | 2021-09-12 | Floyd | Georgia | 13115 | 16363 | 272 |
1706599 | 1706599 | 2021-09-11 | Floyd | Georgia | 13115 | 16363 | 272 |
1703351 | 1703351 | 2021-09-10 | Floyd | Georgia | 13115 | 16363 | 272 |
1700101 | 1700101 | 2021-09-09 | Floyd | Georgia | 13115 | 16199 | 265 |
1696852 | 1696852 | 2021-09-08 | Floyd | Georgia | 13115 | 16079 | 263 |
1693604 | 1693604 | 2021-09-07 | Floyd | Georgia | 13115 | 15972 | 258 |
1690355 | 1690355 | 2021-09-06 | Floyd | Georgia | 13115 | 15573 | 254 |
1687105 | 1687105 | 2021-09-05 | Floyd | Georgia | 13115 | 15573 | 254 |
1683855 | 1683855 | 2021-09-04 | Floyd | Georgia | 13115 | 15573 | 254 |
1680604 | 1680604 | 2021-09-03 | Floyd | Georgia | 13115 | 15573 | 254 |
1677356 | 1677356 | 2021-09-02 | Floyd | Georgia | 13115 | 15389 | 253 |
1674109 | 1674109 | 2021-09-01 | Floyd | Georgia | 13115 | 15223 | 250 |
1670861 | 1670861 | 2021-08-31 | Floyd | Georgia | 13115 | 14840 | 249 |
1667614 | 1667614 | 2021-08-30 | Floyd | Georgia | 13115 | 14725 | 249 |
1664367 | 1664367 | 2021-08-29 | Floyd | Georgia | 13115 | 14406 | 249 |
1661119 | 1661119 | 2021-08-28 | Floyd | Georgia | 13115 | 14406 | 249 |
1657871 | 1657871 | 2021-08-27 | Floyd | Georgia | 13115 | 14406 | 249 |
1654623 | 1654623 | 2021-08-26 | Floyd | Georgia | 13115 | 14225 | 249 |
1651376 | 1651376 | 2021-08-25 | Floyd | Georgia | 13115 | 14141 | 249 |
1648127 | 1648127 | 2021-08-24 | Floyd | Georgia | 13115 | 14029 | 248 |
1644879 | 1644879 | 2021-08-23 | Floyd | Georgia | 13115 | 13833 | 248 |
1641629 | 1641629 | 2021-08-22 | Floyd | Georgia | 13115 | 13609 | 248 |
1638379 | 1638379 | 2021-08-21 | Floyd | Georgia | 13115 | 13609 | 248 |
1635129 | 1635129 | 2021-08-20 | Floyd | Georgia | 13115 | 13609 | 248 |
1631880 | 1631880 | 2021-08-19 | Floyd | Georgia | 13115 | 13554 | 248 |
1628633 | 1628633 | 2021-08-18 | Floyd | Georgia | 13115 | 13468 | 248 |
1625386 | 1625386 | 2021-08-17 | Floyd | Georgia | 13115 | 13270 | 247 |
1622139 | 1622139 | 2021-08-16 | Floyd | Georgia | 13115 | 13216 | 247 |
1618892 | 1618892 | 2021-08-15 | Floyd | Georgia | 13115 | 13064 | 247 |
1615644 | 1615644 | 2021-08-14 | Floyd | Georgia | 13115 | 13064 | 247 |
1612395 | 1612395 | 2021-08-13 | Floyd | Georgia | 13115 | 13064 | 247 |
1609147 | 1609147 | 2021-08-12 | Floyd | Georgia | 13115 | 12999 | 247 |
1605898 | 1605898 | 2021-08-11 | Floyd | Georgia | 13115 | 12958 | 247 |
1602649 | 1602649 | 2021-08-10 | Floyd | Georgia | 13115 | 12833 | 247 |
1599400 | 1599400 | 2021-08-09 | Floyd | Georgia | 13115 | 12794 | 247 |
1596151 | 1596151 | 2021-08-08 | Floyd | Georgia | 13115 | 12667 | 244 |
1592902 | 1592902 | 2021-08-07 | Floyd | Georgia | 13115 | 12667 | 244 |
1589653 | 1589653 | 2021-08-06 | Floyd | Georgia | 13115 | 12667 | 244 |
1586404 | 1586404 | 2021-08-05 | Floyd | Georgia | 13115 | 12635 | 241 |
1583154 | 1583154 | 2021-08-04 | Floyd | Georgia | 13115 | 12604 | 242 |
1579904 | 1579904 | 2021-08-03 | Floyd | Georgia | 13115 | 12572 | 242 |
1576656 | 1576656 | 2021-08-02 | Floyd | Georgia | 13115 | 12544 | 242 |
1573408 | 1573408 | 2021-08-01 | Floyd | Georgia | 13115 | 12523 | 242 |
1570160 | 1570160 | 2021-07-31 | Floyd | Georgia | 13115 | 12523 | 242 |
1566912 | 1566912 | 2021-07-30 | Floyd | Georgia | 13115 | 12523 | 242 |
1563664 | 1563664 | 2021-07-29 | Floyd | Georgia | 13115 | 12504 | 242 |
1560416 | 1560416 | 2021-07-28 | Floyd | Georgia | 13115 | 12490 | 241 |
1557169 | 1557169 | 2021-07-27 | Floyd | Georgia | 13115 | 12473 | 241 |
1553922 | 1553922 | 2021-07-26 | Floyd | Georgia | 13115 | 12461 | 241 |
1550675 | 1550675 | 2021-07-25 | Floyd | Georgia | 13115 | 12446 | 241 |
1547428 | 1547428 | 2021-07-24 | Floyd | Georgia | 13115 | 12446 | 241 |
1544181 | 1544181 | 2021-07-23 | Floyd | Georgia | 13115 | 12446 | 241 |
1540933 | 1540933 | 2021-07-22 | Floyd | Georgia | 13115 | 12439 | 241 |
1537686 | 1537686 | 2021-07-21 | Floyd | Georgia | 13115 | 12400 | 241 |
1534438 | 1534438 | 2021-07-20 | Floyd | Georgia | 13115 | 12362 | 240 |
1531191 | 1531191 | 2021-07-19 | Floyd | Georgia | 13115 | 12341 | 239 |
1527944 | 1527944 | 2021-07-18 | Floyd | Georgia | 13115 | 12245 | 239 |
1524697 | 1524697 | 2021-07-17 | Floyd | Georgia | 13115 | 12245 | 239 |
1521449 | 1521449 | 2021-07-16 | Floyd | Georgia | 13115 | 12245 | 239 |
1518201 | 1518201 | 2021-07-15 | Floyd | Georgia | 13115 | 12217 | 239 |
1514954 | 1514954 | 2021-07-14 | Floyd | Georgia | 13115 | 12188 | 239 |
1511708 | 1511708 | 2021-07-13 | Floyd | Georgia | 13115 | 12183 | 239 |
1508461 | 1508461 | 2021-07-12 | Floyd | Georgia | 13115 | 12181 | 239 |
1505215 | 1505215 | 2021-07-11 | Floyd | Georgia | 13115 | 12174 | 239 |
1501969 | 1501969 | 2021-07-10 | Floyd | Georgia | 13115 | 12174 | 239 |
1498723 | 1498723 | 2021-07-09 | Floyd | Georgia | 13115 | 12174 | 239 |
1495476 | 1495476 | 2021-07-08 | Floyd | Georgia | 13115 | 12171 | 239 |
1492230 | 1492230 | 2021-07-07 | Floyd | Georgia | 13115 | 12170 | 239 |
1488983 | 1488983 | 2021-07-06 | Floyd | Georgia | 13115 | 12169 | 239 |
1485736 | 1485736 | 2021-07-05 | Floyd | Georgia | 13115 | 12166 | 239 |
1482490 | 1482490 | 2021-07-04 | Floyd | Georgia | 13115 | 12166 | 239 |
1479243 | 1479243 | 2021-07-03 | Floyd | Georgia | 13115 | 12166 | 239 |
1475997 | 1475997 | 2021-07-02 | Floyd | Georgia | 13115 | 12166 | 239 |
1472751 | 1472751 | 2021-07-01 | Floyd | Georgia | 13115 | 12165 | 239 |
1469505 | 1469505 | 2021-06-30 | Floyd | Georgia | 13115 | 12164 | 239 |
1466260 | 1466260 | 2021-06-29 | Floyd | Georgia | 13115 | 12160 | 239 |
1463015 | 1463015 | 2021-06-28 | Floyd | Georgia | 13115 | 12160 | 239 |
1459770 | 1459770 | 2021-06-27 | Floyd | Georgia | 13115 | 12159 | 239 |
1456525 | 1456525 | 2021-06-26 | Floyd | Georgia | 13115 | 12156 | 239 |
1453280 | 1453280 | 2021-06-25 | Floyd | Georgia | 13115 | 12154 | 239 |
1450034 | 1450034 | 2021-06-24 | Floyd | Georgia | 13115 | 12147 | 239 |
1446789 | 1446789 | 2021-06-23 | Floyd | Georgia | 13115 | 12144 | 239 |
1443544 | 1443544 | 2021-06-22 | Floyd | Georgia | 13115 | 12144 | 239 |
1440299 | 1440299 | 2021-06-21 | Floyd | Georgia | 13115 | 12145 | 239 |
1437052 | 1437052 | 2021-06-20 | Floyd | Georgia | 13115 | 12145 | 239 |
1433805 | 1433805 | 2021-06-19 | Floyd | Georgia | 13115 | 12145 | 239 |
1430559 | 1430559 | 2021-06-18 | Floyd | Georgia | 13115 | 12145 | 239 |
1427314 | 1427314 | 2021-06-17 | Floyd | Georgia | 13115 | 12143 | 239 |
1424069 | 1424069 | 2021-06-16 | Floyd | Georgia | 13115 | 12141 | 239 |
1420821 | 1420821 | 2021-06-15 | Floyd | Georgia | 13115 | 12140 | 238 |
1417576 | 1417576 | 2021-06-14 | Floyd | Georgia | 13115 | 12141 | 238 |
1414330 | 1414330 | 2021-06-13 | Floyd | Georgia | 13115 | 12141 | 238 |
1411085 | 1411085 | 2021-06-12 | Floyd | Georgia | 13115 | 12140 | 238 |
1407840 | 1407840 | 2021-06-11 | Floyd | Georgia | 13115 | 12138 | 238 |
1404594 | 1404594 | 2021-06-10 | Floyd | Georgia | 13115 | 12138 | 237 |
1401349 | 1401349 | 2021-06-09 | Floyd | Georgia | 13115 | 12134 | 236 |
1398104 | 1398104 | 2021-06-08 | Floyd | Georgia | 13115 | 12134 | 236 |
1394857 | 1394857 | 2021-06-07 | Floyd | Georgia | 13115 | 12132 | 235 |
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);