ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Gwinnett" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1849564 | 1849564 | 2021-10-25 | Gwinnett | Georgia | 13135 | 132659 | 1438 |
1846314 | 1846314 | 2021-10-24 | Gwinnett | Georgia | 13135 | 132471 | 1436 |
1843064 | 1843064 | 2021-10-23 | Gwinnett | Georgia | 13135 | 132471 | 1436 |
1839814 | 1839814 | 2021-10-22 | Gwinnett | Georgia | 13135 | 132471 | 1436 |
1836565 | 1836565 | 2021-10-21 | Gwinnett | Georgia | 13135 | 132327 | 1429 |
1833316 | 1833316 | 2021-10-20 | Gwinnett | Georgia | 13135 | 132219 | 1425 |
1830067 | 1830067 | 2021-10-19 | Gwinnett | Georgia | 13135 | 132078 | 1422 |
1826818 | 1826818 | 2021-10-18 | Gwinnett | Georgia | 13135 | 131923 | 1414 |
1823569 | 1823569 | 2021-10-17 | Gwinnett | Georgia | 13135 | 131712 | 1408 |
1820320 | 1820320 | 2021-10-16 | Gwinnett | Georgia | 13135 | 131712 | 1408 |
1817071 | 1817071 | 2021-10-15 | Gwinnett | Georgia | 13135 | 131712 | 1408 |
1813823 | 1813823 | 2021-10-14 | Gwinnett | Georgia | 13135 | 131541 | 1400 |
1810574 | 1810574 | 2021-10-13 | Gwinnett | Georgia | 13135 | 131313 | 1394 |
1807325 | 1807325 | 2021-10-12 | Gwinnett | Georgia | 13135 | 131112 | 1386 |
1804074 | 1804074 | 2021-10-11 | Gwinnett | Georgia | 13135 | 130311 | 1374 |
1800825 | 1800825 | 2021-10-10 | Gwinnett | Georgia | 13135 | 130311 | 1374 |
1797576 | 1797576 | 2021-10-09 | Gwinnett | Georgia | 13135 | 130311 | 1374 |
1794327 | 1794327 | 2021-10-08 | Gwinnett | Georgia | 13135 | 130311 | 1374 |
1791079 | 1791079 | 2021-10-07 | Gwinnett | Georgia | 13135 | 130046 | 1369 |
1787830 | 1787830 | 2021-10-06 | Gwinnett | Georgia | 13135 | 129345 | 1367 |
1784581 | 1784581 | 2021-10-05 | Gwinnett | Georgia | 13135 | 129318 | 1356 |
1781332 | 1781332 | 2021-10-04 | Gwinnett | Georgia | 13135 | 128988 | 1355 |
1778082 | 1778082 | 2021-10-03 | Gwinnett | Georgia | 13135 | 127892 | 1350 |
1774832 | 1774832 | 2021-10-02 | Gwinnett | Georgia | 13135 | 127892 | 1350 |
1771582 | 1771582 | 2021-10-01 | Gwinnett | Georgia | 13135 | 127892 | 1350 |
1768333 | 1768333 | 2021-09-30 | Gwinnett | Georgia | 13135 | 127624 | 1348 |
1765084 | 1765084 | 2021-09-29 | Gwinnett | Georgia | 13135 | 127000 | 1342 |
1761835 | 1761835 | 2021-09-28 | Gwinnett | Georgia | 13135 | 126366 | 1338 |
1758587 | 1758587 | 2021-09-27 | Gwinnett | Georgia | 13135 | 126078 | 1333 |
1755339 | 1755339 | 2021-09-26 | Gwinnett | Georgia | 13135 | 125424 | 1331 |
1752091 | 1752091 | 2021-09-25 | Gwinnett | Georgia | 13135 | 125424 | 1331 |
1748842 | 1748842 | 2021-09-24 | Gwinnett | Georgia | 13135 | 125424 | 1331 |
1745592 | 1745592 | 2021-09-23 | Gwinnett | Georgia | 13135 | 125104 | 1322 |
1742343 | 1742343 | 2021-09-22 | Gwinnett | Georgia | 13135 | 124818 | 1316 |
1739094 | 1739094 | 2021-09-21 | Gwinnett | Georgia | 13135 | 124451 | 1308 |
1735845 | 1735845 | 2021-09-20 | Gwinnett | Georgia | 13135 | 123232 | 1305 |
1732595 | 1732595 | 2021-09-19 | Gwinnett | Georgia | 13135 | 122458 | 1301 |
1729345 | 1729345 | 2021-09-18 | Gwinnett | Georgia | 13135 | 122458 | 1301 |
1726095 | 1726095 | 2021-09-17 | Gwinnett | Georgia | 13135 | 122458 | 1301 |
1722846 | 1722846 | 2021-09-16 | Gwinnett | Georgia | 13135 | 122142 | 1296 |
1719597 | 1719597 | 2021-09-15 | Gwinnett | Georgia | 13135 | 121780 | 1290 |
1716349 | 1716349 | 2021-09-14 | Gwinnett | Georgia | 13135 | 121377 | 1287 |
1713103 | 1713103 | 2021-09-13 | Gwinnett | Georgia | 13135 | 120960 | 1286 |
1709856 | 1709856 | 2021-09-12 | Gwinnett | Georgia | 13135 | 119950 | 1281 |
1706609 | 1706609 | 2021-09-11 | Gwinnett | Georgia | 13135 | 119950 | 1281 |
1703361 | 1703361 | 2021-09-10 | Gwinnett | Georgia | 13135 | 119950 | 1281 |
1700111 | 1700111 | 2021-09-09 | Gwinnett | Georgia | 13135 | 119533 | 1280 |
1696862 | 1696862 | 2021-09-08 | Gwinnett | Georgia | 13135 | 119098 | 1275 |
1693614 | 1693614 | 2021-09-07 | Gwinnett | Georgia | 13135 | 118633 | 1275 |
1690365 | 1690365 | 2021-09-06 | Gwinnett | Georgia | 13135 | 117181 | 1264 |
1687115 | 1687115 | 2021-09-05 | Gwinnett | Georgia | 13135 | 117181 | 1264 |
1683865 | 1683865 | 2021-09-04 | Gwinnett | Georgia | 13135 | 117181 | 1264 |
1680614 | 1680614 | 2021-09-03 | Gwinnett | Georgia | 13135 | 117181 | 1264 |
1677366 | 1677366 | 2021-09-02 | Gwinnett | Georgia | 13135 | 116664 | 1262 |
1674119 | 1674119 | 2021-09-01 | Gwinnett | Georgia | 13135 | 116250 | 1257 |
1670871 | 1670871 | 2021-08-31 | Gwinnett | Georgia | 13135 | 115842 | 1254 |
1667624 | 1667624 | 2021-08-30 | Gwinnett | Georgia | 13135 | 115344 | 1247 |
1664377 | 1664377 | 2021-08-29 | Gwinnett | Georgia | 13135 | 114427 | 1246 |
1661129 | 1661129 | 2021-08-28 | Gwinnett | Georgia | 13135 | 114427 | 1246 |
1657881 | 1657881 | 2021-08-27 | Gwinnett | Georgia | 13135 | 114427 | 1246 |
1654633 | 1654633 | 2021-08-26 | Gwinnett | Georgia | 13135 | 113904 | 1244 |
1651386 | 1651386 | 2021-08-25 | Gwinnett | Georgia | 13135 | 113477 | 1242 |
1648137 | 1648137 | 2021-08-24 | Gwinnett | Georgia | 13135 | 112963 | 1239 |
1644889 | 1644889 | 2021-08-23 | Gwinnett | Georgia | 13135 | 112639 | 1236 |
1641639 | 1641639 | 2021-08-22 | Gwinnett | Georgia | 13135 | 111868 | 1236 |
1638389 | 1638389 | 2021-08-21 | Gwinnett | Georgia | 13135 | 111868 | 1236 |
1635139 | 1635139 | 2021-08-20 | Gwinnett | Georgia | 13135 | 111868 | 1236 |
1631890 | 1631890 | 2021-08-19 | Gwinnett | Georgia | 13135 | 111468 | 1236 |
1628643 | 1628643 | 2021-08-18 | Gwinnett | Georgia | 13135 | 111007 | 1231 |
1625396 | 1625396 | 2021-08-17 | Gwinnett | Georgia | 13135 | 110739 | 1229 |
1622149 | 1622149 | 2021-08-16 | Gwinnett | Georgia | 13135 | 110400 | 1229 |
1618902 | 1618902 | 2021-08-15 | Gwinnett | Georgia | 13135 | 109423 | 1229 |
1615654 | 1615654 | 2021-08-14 | Gwinnett | Georgia | 13135 | 109423 | 1229 |
1612405 | 1612405 | 2021-08-13 | Gwinnett | Georgia | 13135 | 109423 | 1229 |
1609157 | 1609157 | 2021-08-12 | Gwinnett | Georgia | 13135 | 109159 | 1227 |
1605908 | 1605908 | 2021-08-11 | Gwinnett | Georgia | 13135 | 108928 | 1223 |
1602659 | 1602659 | 2021-08-10 | Gwinnett | Georgia | 13135 | 108651 | 1221 |
1599410 | 1599410 | 2021-08-09 | Gwinnett | Georgia | 13135 | 108304 | 1221 |
1596161 | 1596161 | 2021-08-08 | Gwinnett | Georgia | 13135 | 107632 | 1221 |
1592912 | 1592912 | 2021-08-07 | Gwinnett | Georgia | 13135 | 107632 | 1221 |
1589663 | 1589663 | 2021-08-06 | Gwinnett | Georgia | 13135 | 107632 | 1221 |
1586414 | 1586414 | 2021-08-05 | Gwinnett | Georgia | 13135 | 107279 | 1220 |
1583164 | 1583164 | 2021-08-04 | Gwinnett | Georgia | 13135 | 107026 | 1219 |
1579914 | 1579914 | 2021-08-03 | Gwinnett | Georgia | 13135 | 106804 | 1218 |
1576666 | 1576666 | 2021-08-02 | Gwinnett | Georgia | 13135 | 106325 | 1217 |
1573418 | 1573418 | 2021-08-01 | Gwinnett | Georgia | 13135 | 106048 | 1216 |
1570170 | 1570170 | 2021-07-31 | Gwinnett | Georgia | 13135 | 106048 | 1216 |
1566922 | 1566922 | 2021-07-30 | Gwinnett | Georgia | 13135 | 106048 | 1216 |
1563674 | 1563674 | 2021-07-29 | Gwinnett | Georgia | 13135 | 105888 | 1215 |
1560426 | 1560426 | 2021-07-28 | Gwinnett | Georgia | 13135 | 105692 | 1215 |
1557179 | 1557179 | 2021-07-27 | Gwinnett | Georgia | 13135 | 105481 | 1215 |
1553932 | 1553932 | 2021-07-26 | Gwinnett | Georgia | 13135 | 105261 | 1215 |
1550685 | 1550685 | 2021-07-25 | Gwinnett | Georgia | 13135 | 104915 | 1215 |
1547438 | 1547438 | 2021-07-24 | Gwinnett | Georgia | 13135 | 104915 | 1215 |
1544191 | 1544191 | 2021-07-23 | Gwinnett | Georgia | 13135 | 104915 | 1215 |
1540943 | 1540943 | 2021-07-22 | Gwinnett | Georgia | 13135 | 104762 | 1215 |
1537696 | 1537696 | 2021-07-21 | Gwinnett | Georgia | 13135 | 104658 | 1215 |
1534448 | 1534448 | 2021-07-20 | Gwinnett | Georgia | 13135 | 104520 | 1215 |
1531201 | 1531201 | 2021-07-19 | Gwinnett | Georgia | 13135 | 104432 | 1215 |
1527954 | 1527954 | 2021-07-18 | Gwinnett | Georgia | 13135 | 104217 | 1215 |
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);