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 |
---|---|---|---|---|---|---|---|
2174652 | 2174652 | 2022-02-02 | Gwinnett | Georgia | 13135 | 199301 | 1669 |
2171399 | 2171399 | 2022-02-01 | Gwinnett | Georgia | 13135 | 198687 | 1667 |
2168146 | 2168146 | 2022-01-31 | Gwinnett | Georgia | 13135 | 197947 | 1664 |
2164891 | 2164891 | 2022-01-30 | Gwinnett | Georgia | 13135 | 196055 | 1655 |
2161636 | 2161636 | 2022-01-29 | Gwinnett | Georgia | 13135 | 196055 | 1655 |
2158380 | 2158380 | 2022-01-28 | Gwinnett | Georgia | 13135 | 196055 | 1655 |
2155127 | 2155127 | 2022-01-27 | Gwinnett | Georgia | 13135 | 194578 | 1638 |
2151874 | 2151874 | 2022-01-26 | Gwinnett | Georgia | 13135 | 193691 | 1630 |
2148622 | 2148622 | 2022-01-25 | Gwinnett | Georgia | 13135 | 191572 | 1628 |
2145370 | 2145370 | 2022-01-24 | Gwinnett | Georgia | 13135 | 189785 | 1624 |
2142115 | 2142115 | 2022-01-23 | Gwinnett | Georgia | 13135 | 186188 | 1619 |
2138860 | 2138860 | 2022-01-22 | Gwinnett | Georgia | 13135 | 186188 | 1619 |
2135604 | 2135604 | 2022-01-21 | Gwinnett | Georgia | 13135 | 186188 | 1619 |
2132352 | 2132352 | 2022-01-20 | Gwinnett | Georgia | 13135 | 184940 | 1614 |
2129099 | 2129099 | 2022-01-19 | Gwinnett | Georgia | 13135 | 183524 | 1603 |
2125845 | 2125845 | 2022-01-18 | Gwinnett | Georgia | 13135 | 182018 | 1603 |
2122593 | 2122593 | 2022-01-17 | Gwinnett | Georgia | 13135 | 180694 | 1602 |
2119341 | 2119341 | 2022-01-16 | Gwinnett | Georgia | 13135 | 177730 | 1600 |
2116089 | 2116089 | 2022-01-15 | Gwinnett | Georgia | 13135 | 177730 | 1600 |
2112838 | 2112838 | 2022-01-14 | Gwinnett | Georgia | 13135 | 177730 | 1600 |
2109586 | 2109586 | 2022-01-13 | Gwinnett | Georgia | 13135 | 175570 | 1599 |
2106335 | 2106335 | 2022-01-12 | Gwinnett | Georgia | 13135 | 173477 | 1598 |
2103084 | 2103084 | 2022-01-11 | Gwinnett | Georgia | 13135 | 172420 | 1593 |
2099833 | 2099833 | 2022-01-10 | Gwinnett | Georgia | 13135 | 170616 | 1591 |
2096582 | 2096582 | 2022-01-09 | Gwinnett | Georgia | 13135 | 161744 | 1583 |
2093330 | 2093330 | 2022-01-08 | Gwinnett | Georgia | 13135 | 161744 | 1583 |
2090078 | 2090078 | 2022-01-07 | Gwinnett | Georgia | 13135 | 161744 | 1583 |
2086827 | 2086827 | 2022-01-06 | Gwinnett | Georgia | 13135 | 161744 | 1583 |
2083575 | 2083575 | 2022-01-05 | Gwinnett | Georgia | 13135 | 161744 | 1583 |
2080323 | 2080323 | 2022-01-04 | Gwinnett | Georgia | 13135 | 159517 | 1581 |
2077071 | 2077071 | 2022-01-03 | Gwinnett | Georgia | 13135 | 152664 | 1580 |
2073820 | 2073820 | 2022-01-02 | Gwinnett | Georgia | 13135 | 152664 | 1580 |
2070569 | 2070569 | 2022-01-01 | Gwinnett | Georgia | 13135 | 152664 | 1580 |
2067318 | 2067318 | 2021-12-31 | Gwinnett | Georgia | 13135 | 152664 | 1580 |
2064067 | 2064067 | 2021-12-30 | Gwinnett | Georgia | 13135 | 150347 | 1579 |
2060817 | 2060817 | 2021-12-29 | Gwinnett | Georgia | 13135 | 148066 | 1579 |
2057568 | 2057568 | 2021-12-28 | Gwinnett | Georgia | 13135 | 146475 | 1578 |
2054319 | 2054319 | 2021-12-27 | Gwinnett | Georgia | 13135 | 145260 | 1572 |
2051069 | 2051069 | 2021-12-26 | Gwinnett | Georgia | 13135 | 142817 | 1567 |
2047819 | 2047819 | 2021-12-25 | Gwinnett | Georgia | 13135 | 142817 | 1567 |
2044569 | 2044569 | 2021-12-24 | Gwinnett | Georgia | 13135 | 142817 | 1567 |
2041320 | 2041320 | 2021-12-23 | Gwinnett | Georgia | 13135 | 142008 | 1566 |
2038070 | 2038070 | 2021-12-22 | Gwinnett | Georgia | 13135 | 141083 | 1566 |
2034820 | 2034820 | 2021-12-21 | Gwinnett | Georgia | 13135 | 140418 | 1559 |
2031570 | 2031570 | 2021-12-20 | Gwinnett | Georgia | 13135 | 139877 | 1557 |
2028319 | 2028319 | 2021-12-19 | Gwinnett | Georgia | 13135 | 139079 | 1553 |
2025068 | 2025068 | 2021-12-18 | Gwinnett | Georgia | 13135 | 139079 | 1553 |
2021817 | 2021817 | 2021-12-17 | Gwinnett | Georgia | 13135 | 139079 | 1553 |
2018566 | 2018566 | 2021-12-16 | Gwinnett | Georgia | 13135 | 138827 | 1546 |
2015316 | 2015316 | 2021-12-15 | Gwinnett | Georgia | 13135 | 138549 | 1547 |
2012065 | 2012065 | 2021-12-14 | Gwinnett | Georgia | 13135 | 138321 | 1544 |
2008814 | 2008814 | 2021-12-13 | Gwinnett | Georgia | 13135 | 138144 | 1542 |
2005563 | 2005563 | 2021-12-12 | Gwinnett | Georgia | 13135 | 137860 | 1539 |
2002312 | 2002312 | 2021-12-11 | Gwinnett | Georgia | 13135 | 137860 | 1539 |
1999062 | 1999062 | 2021-12-10 | Gwinnett | Georgia | 13135 | 137860 | 1539 |
1995811 | 1995811 | 2021-12-09 | Gwinnett | Georgia | 13135 | 137663 | 1539 |
1992560 | 1992560 | 2021-12-08 | Gwinnett | Georgia | 13135 | 137484 | 1536 |
1989309 | 1989309 | 2021-12-07 | Gwinnett | Georgia | 13135 | 137191 | 1533 |
1986059 | 1986059 | 2021-12-06 | Gwinnett | Georgia | 13135 | 137082 | 1531 |
1982809 | 1982809 | 2021-12-05 | Gwinnett | Georgia | 13135 | 136802 | 1529 |
1979559 | 1979559 | 2021-12-04 | Gwinnett | Georgia | 13135 | 136802 | 1529 |
1976309 | 1976309 | 2021-12-03 | Gwinnett | Georgia | 13135 | 136802 | 1529 |
1973060 | 1973060 | 2021-12-02 | Gwinnett | Georgia | 13135 | 136688 | 1528 |
1969810 | 1969810 | 2021-12-01 | Gwinnett | Georgia | 13135 | 136545 | 1524 |
1966560 | 1966560 | 2021-11-30 | Gwinnett | Georgia | 13135 | 136400 | 1522 |
1963308 | 1963308 | 2021-11-29 | Gwinnett | Georgia | 13135 | 136239 | 1522 |
1960057 | 1960057 | 2021-11-28 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1956806 | 1956806 | 2021-11-27 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1953555 | 1953555 | 2021-11-26 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1950304 | 1950304 | 2021-11-25 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1947053 | 1947053 | 2021-11-24 | Gwinnett | Georgia | 13135 | 135857 | 1519 |
1943802 | 1943802 | 2021-11-23 | Gwinnett | Georgia | 13135 | 135766 | 1515 |
1940552 | 1940552 | 2021-11-22 | Gwinnett | Georgia | 13135 | 135598 | 1512 |
1937302 | 1937302 | 2021-11-21 | Gwinnett | Georgia | 13135 | 135361 | 1511 |
1934052 | 1934052 | 2021-11-20 | Gwinnett | Georgia | 13135 | 135361 | 1511 |
1930800 | 1930800 | 2021-11-19 | Gwinnett | Georgia | 13135 | 135361 | 1511 |
1927550 | 1927550 | 2021-11-18 | Gwinnett | Georgia | 13135 | 135196 | 1506 |
1924300 | 1924300 | 2021-11-17 | Gwinnett | Georgia | 13135 | 135016 | 1505 |
1921051 | 1921051 | 2021-11-16 | Gwinnett | Georgia | 13135 | 134900 | 1493 |
1917801 | 1917801 | 2021-11-15 | Gwinnett | Georgia | 13135 | 134698 | 1491 |
1914551 | 1914551 | 2021-11-14 | Gwinnett | Georgia | 13135 | 134435 | 1491 |
1911301 | 1911301 | 2021-11-13 | Gwinnett | Georgia | 13135 | 134435 | 1491 |
1908052 | 1908052 | 2021-11-12 | Gwinnett | Georgia | 13135 | 134435 | 1491 |
1904803 | 1904803 | 2021-11-11 | Gwinnett | Georgia | 13135 | 134227 | 1488 |
1901553 | 1901553 | 2021-11-10 | Gwinnett | Georgia | 13135 | 134227 | 1488 |
1898303 | 1898303 | 2021-11-09 | Gwinnett | Georgia | 13135 | 134126 | 1484 |
1895053 | 1895053 | 2021-11-08 | Gwinnett | Georgia | 13135 | 133810 | 1472 |
1891803 | 1891803 | 2021-11-07 | Gwinnett | Georgia | 13135 | 133805 | 1472 |
1888553 | 1888553 | 2021-11-06 | Gwinnett | Georgia | 13135 | 133805 | 1472 |
1885303 | 1885303 | 2021-11-05 | Gwinnett | Georgia | 13135 | 133805 | 1472 |
1882054 | 1882054 | 2021-11-04 | Gwinnett | Georgia | 13135 | 133730 | 1466 |
1878805 | 1878805 | 2021-11-03 | Gwinnett | Georgia | 13135 | 133591 | 1463 |
1875556 | 1875556 | 2021-11-02 | Gwinnett | Georgia | 13135 | 133509 | 1463 |
1872307 | 1872307 | 2021-11-01 | Gwinnett | Georgia | 13135 | 133407 | 1458 |
1869058 | 1869058 | 2021-10-31 | Gwinnett | Georgia | 13135 | 133181 | 1454 |
1865809 | 1865809 | 2021-10-30 | Gwinnett | Georgia | 13135 | 133181 | 1454 |
1862560 | 1862560 | 2021-10-29 | Gwinnett | Georgia | 13135 | 133181 | 1454 |
1859311 | 1859311 | 2021-10-28 | Gwinnett | Georgia | 13135 | 133085 | 1452 |
1856062 | 1856062 | 2021-10-27 | Gwinnett | Georgia | 13135 | 132940 | 1448 |
1852813 | 1852813 | 2021-10-26 | Gwinnett | Georgia | 13135 | 132798 | 1446 |
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);