ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Troup" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174726 | 2174726 | 2022-02-02 | Troup | Georgia | 13285 | 15075 | 347 |
2171473 | 2171473 | 2022-02-01 | Troup | Georgia | 13285 | 15041 | 346 |
2168220 | 2168220 | 2022-01-31 | Troup | Georgia | 13285 | 14993 | 345 |
2164965 | 2164965 | 2022-01-30 | Troup | Georgia | 13285 | 14897 | 344 |
2161710 | 2161710 | 2022-01-29 | Troup | Georgia | 13285 | 14897 | 344 |
2158454 | 2158454 | 2022-01-28 | Troup | Georgia | 13285 | 14897 | 344 |
2155201 | 2155201 | 2022-01-27 | Troup | Georgia | 13285 | 14819 | 341 |
2151948 | 2151948 | 2022-01-26 | Troup | Georgia | 13285 | 14718 | 339 |
2148696 | 2148696 | 2022-01-25 | Troup | Georgia | 13285 | 14648 | 336 |
2145444 | 2145444 | 2022-01-24 | Troup | Georgia | 13285 | 14576 | 335 |
2142189 | 2142189 | 2022-01-23 | Troup | Georgia | 13285 | 14433 | 335 |
2138934 | 2138934 | 2022-01-22 | Troup | Georgia | 13285 | 14433 | 335 |
2135678 | 2135678 | 2022-01-21 | Troup | Georgia | 13285 | 14433 | 335 |
2132426 | 2132426 | 2022-01-20 | Troup | Georgia | 13285 | 14346 | 335 |
2129173 | 2129173 | 2022-01-19 | Troup | Georgia | 13285 | 14260 | 334 |
2125919 | 2125919 | 2022-01-18 | Troup | Georgia | 13285 | 14140 | 334 |
2122667 | 2122667 | 2022-01-17 | Troup | Georgia | 13285 | 14097 | 334 |
2119415 | 2119415 | 2022-01-16 | Troup | Georgia | 13285 | 13929 | 334 |
2116163 | 2116163 | 2022-01-15 | Troup | Georgia | 13285 | 13929 | 334 |
2112912 | 2112912 | 2022-01-14 | Troup | Georgia | 13285 | 13929 | 334 |
2109660 | 2109660 | 2022-01-13 | Troup | Georgia | 13285 | 13843 | 332 |
2106409 | 2106409 | 2022-01-12 | Troup | Georgia | 13285 | 13725 | 332 |
2103158 | 2103158 | 2022-01-11 | Troup | Georgia | 13285 | 13610 | 331 |
2099907 | 2099907 | 2022-01-10 | Troup | Georgia | 13285 | 13406 | 330 |
2096656 | 2096656 | 2022-01-09 | Troup | Georgia | 13285 | 12877 | 327 |
2093404 | 2093404 | 2022-01-08 | Troup | Georgia | 13285 | 12877 | 327 |
2090152 | 2090152 | 2022-01-07 | Troup | Georgia | 13285 | 12877 | 327 |
2086901 | 2086901 | 2022-01-06 | Troup | Georgia | 13285 | 12877 | 327 |
2083649 | 2083649 | 2022-01-05 | Troup | Georgia | 13285 | 12877 | 327 |
2080397 | 2080397 | 2022-01-04 | Troup | Georgia | 13285 | 12687 | 327 |
2077145 | 2077145 | 2022-01-03 | Troup | Georgia | 13285 | 12201 | 327 |
2073894 | 2073894 | 2022-01-02 | Troup | Georgia | 13285 | 12201 | 327 |
2070643 | 2070643 | 2022-01-01 | Troup | Georgia | 13285 | 12201 | 327 |
2067392 | 2067392 | 2021-12-31 | Troup | Georgia | 13285 | 12201 | 327 |
2064141 | 2064141 | 2021-12-30 | Troup | Georgia | 13285 | 12035 | 327 |
2060891 | 2060891 | 2021-12-29 | Troup | Georgia | 13285 | 11883 | 327 |
2057642 | 2057642 | 2021-12-28 | Troup | Georgia | 13285 | 11738 | 327 |
2054393 | 2054393 | 2021-12-27 | Troup | Georgia | 13285 | 11598 | 327 |
2051143 | 2051143 | 2021-12-26 | Troup | Georgia | 13285 | 11402 | 327 |
2047893 | 2047893 | 2021-12-25 | Troup | Georgia | 13285 | 11402 | 327 |
2044643 | 2044643 | 2021-12-24 | Troup | Georgia | 13285 | 11402 | 327 |
2041394 | 2041394 | 2021-12-23 | Troup | Georgia | 13285 | 11342 | 327 |
2038144 | 2038144 | 2021-12-22 | Troup | Georgia | 13285 | 11287 | 327 |
2034894 | 2034894 | 2021-12-21 | Troup | Georgia | 13285 | 11243 | 327 |
2031644 | 2031644 | 2021-12-20 | Troup | Georgia | 13285 | 11200 | 327 |
2028393 | 2028393 | 2021-12-19 | Troup | Georgia | 13285 | 11127 | 327 |
2025142 | 2025142 | 2021-12-18 | Troup | Georgia | 13285 | 11127 | 327 |
2021891 | 2021891 | 2021-12-17 | Troup | Georgia | 13285 | 11127 | 327 |
2018640 | 2018640 | 2021-12-16 | Troup | Georgia | 13285 | 11110 | 326 |
2015390 | 2015390 | 2021-12-15 | Troup | Georgia | 13285 | 11093 | 326 |
2012139 | 2012139 | 2021-12-14 | Troup | Georgia | 13285 | 11082 | 326 |
2008888 | 2008888 | 2021-12-13 | Troup | Georgia | 13285 | 11057 | 326 |
2005637 | 2005637 | 2021-12-12 | Troup | Georgia | 13285 | 11040 | 326 |
2002386 | 2002386 | 2021-12-11 | Troup | Georgia | 13285 | 11040 | 326 |
1999136 | 1999136 | 2021-12-10 | Troup | Georgia | 13285 | 11040 | 326 |
1995885 | 1995885 | 2021-12-09 | Troup | Georgia | 13285 | 11022 | 326 |
1992634 | 1992634 | 2021-12-08 | Troup | Georgia | 13285 | 11020 | 326 |
1989383 | 1989383 | 2021-12-07 | Troup | Georgia | 13285 | 11010 | 326 |
1986133 | 1986133 | 2021-12-06 | Troup | Georgia | 13285 | 11006 | 324 |
1982883 | 1982883 | 2021-12-05 | Troup | Georgia | 13285 | 10989 | 324 |
1979633 | 1979633 | 2021-12-04 | Troup | Georgia | 13285 | 10989 | 324 |
1976383 | 1976383 | 2021-12-03 | Troup | Georgia | 13285 | 10989 | 324 |
1973134 | 1973134 | 2021-12-02 | Troup | Georgia | 13285 | 10980 | 324 |
1969884 | 1969884 | 2021-12-01 | Troup | Georgia | 13285 | 10975 | 324 |
1966634 | 1966634 | 2021-11-30 | Troup | Georgia | 13285 | 10970 | 324 |
1963382 | 1963382 | 2021-11-29 | Troup | Georgia | 13285 | 10962 | 324 |
1960131 | 1960131 | 2021-11-28 | Troup | Georgia | 13285 | 10947 | 323 |
1956880 | 1956880 | 2021-11-27 | Troup | Georgia | 13285 | 10947 | 323 |
1953629 | 1953629 | 2021-11-26 | Troup | Georgia | 13285 | 10947 | 323 |
1950378 | 1950378 | 2021-11-25 | Troup | Georgia | 13285 | 10947 | 323 |
1947127 | 1947127 | 2021-11-24 | Troup | Georgia | 13285 | 10947 | 323 |
1943876 | 1943876 | 2021-11-23 | Troup | Georgia | 13285 | 10943 | 322 |
1940626 | 1940626 | 2021-11-22 | Troup | Georgia | 13285 | 10940 | 322 |
1937376 | 1937376 | 2021-11-21 | Troup | Georgia | 13285 | 10924 | 321 |
1934126 | 1934126 | 2021-11-20 | Troup | Georgia | 13285 | 10924 | 321 |
1930874 | 1930874 | 2021-11-19 | Troup | Georgia | 13285 | 10924 | 321 |
1927624 | 1927624 | 2021-11-18 | Troup | Georgia | 13285 | 10921 | 320 |
1924374 | 1924374 | 2021-11-17 | Troup | Georgia | 13285 | 10917 | 319 |
1921125 | 1921125 | 2021-11-16 | Troup | Georgia | 13285 | 10911 | 316 |
1917875 | 1917875 | 2021-11-15 | Troup | Georgia | 13285 | 10908 | 316 |
1914625 | 1914625 | 2021-11-14 | Troup | Georgia | 13285 | 10902 | 316 |
1911375 | 1911375 | 2021-11-13 | Troup | Georgia | 13285 | 10902 | 316 |
1908126 | 1908126 | 2021-11-12 | Troup | Georgia | 13285 | 10902 | 316 |
1904877 | 1904877 | 2021-11-11 | Troup | Georgia | 13285 | 10893 | 315 |
1901627 | 1901627 | 2021-11-10 | Troup | Georgia | 13285 | 10893 | 315 |
1898377 | 1898377 | 2021-11-09 | Troup | Georgia | 13285 | 10890 | 315 |
1895127 | 1895127 | 2021-11-08 | Troup | Georgia | 13285 | 10884 | 314 |
1891877 | 1891877 | 2021-11-07 | Troup | Georgia | 13285 | 10881 | 314 |
1888627 | 1888627 | 2021-11-06 | Troup | Georgia | 13285 | 10881 | 314 |
1885377 | 1885377 | 2021-11-05 | Troup | Georgia | 13285 | 10881 | 314 |
1882128 | 1882128 | 2021-11-04 | Troup | Georgia | 13285 | 10877 | 314 |
1878879 | 1878879 | 2021-11-03 | Troup | Georgia | 13285 | 10867 | 312 |
1875630 | 1875630 | 2021-11-02 | Troup | Georgia | 13285 | 10859 | 311 |
1872381 | 1872381 | 2021-11-01 | Troup | Georgia | 13285 | 10856 | 308 |
1869132 | 1869132 | 2021-10-31 | Troup | Georgia | 13285 | 10840 | 308 |
1865883 | 1865883 | 2021-10-30 | Troup | Georgia | 13285 | 10840 | 308 |
1862634 | 1862634 | 2021-10-29 | Troup | Georgia | 13285 | 10840 | 308 |
1859385 | 1859385 | 2021-10-28 | Troup | Georgia | 13285 | 10836 | 307 |
1856136 | 1856136 | 2021-10-27 | Troup | Georgia | 13285 | 10832 | 307 |
1852887 | 1852887 | 2021-10-26 | Troup | Georgia | 13285 | 10824 | 307 |
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);