ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 13171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174670 | 2174670 | 2022-02-02 | Lamar | Georgia | 13171 | 4686 | 105 |
2171417 | 2171417 | 2022-02-01 | Lamar | Georgia | 13171 | 4678 | 105 |
2168164 | 2168164 | 2022-01-31 | Lamar | Georgia | 13171 | 4670 | 105 |
2164909 | 2164909 | 2022-01-30 | Lamar | Georgia | 13171 | 4624 | 105 |
2161654 | 2161654 | 2022-01-29 | Lamar | Georgia | 13171 | 4624 | 105 |
2158398 | 2158398 | 2022-01-28 | Lamar | Georgia | 13171 | 4624 | 105 |
2155145 | 2155145 | 2022-01-27 | Lamar | Georgia | 13171 | 4605 | 105 |
2151892 | 2151892 | 2022-01-26 | Lamar | Georgia | 13171 | 4588 | 105 |
2148640 | 2148640 | 2022-01-25 | Lamar | Georgia | 13171 | 4548 | 105 |
2145388 | 2145388 | 2022-01-24 | Lamar | Georgia | 13171 | 4532 | 105 |
2142133 | 2142133 | 2022-01-23 | Lamar | Georgia | 13171 | 4471 | 104 |
2138878 | 2138878 | 2022-01-22 | Lamar | Georgia | 13171 | 4471 | 104 |
2135622 | 2135622 | 2022-01-21 | Lamar | Georgia | 13171 | 4471 | 104 |
2132370 | 2132370 | 2022-01-20 | Lamar | Georgia | 13171 | 4439 | 103 |
2129117 | 2129117 | 2022-01-19 | Lamar | Georgia | 13171 | 4415 | 102 |
2125863 | 2125863 | 2022-01-18 | Lamar | Georgia | 13171 | 4358 | 102 |
2122611 | 2122611 | 2022-01-17 | Lamar | Georgia | 13171 | 4347 | 102 |
2119359 | 2119359 | 2022-01-16 | Lamar | Georgia | 13171 | 4308 | 102 |
2116107 | 2116107 | 2022-01-15 | Lamar | Georgia | 13171 | 4308 | 102 |
2112856 | 2112856 | 2022-01-14 | Lamar | Georgia | 13171 | 4308 | 102 |
2109604 | 2109604 | 2022-01-13 | Lamar | Georgia | 13171 | 4262 | 102 |
2106353 | 2106353 | 2022-01-12 | Lamar | Georgia | 13171 | 4228 | 102 |
2103102 | 2103102 | 2022-01-11 | Lamar | Georgia | 13171 | 4185 | 102 |
2099851 | 2099851 | 2022-01-10 | Lamar | Georgia | 13171 | 4138 | 102 |
2096600 | 2096600 | 2022-01-09 | Lamar | Georgia | 13171 | 3950 | 101 |
2093348 | 2093348 | 2022-01-08 | Lamar | Georgia | 13171 | 3950 | 101 |
2090096 | 2090096 | 2022-01-07 | Lamar | Georgia | 13171 | 3950 | 101 |
2086845 | 2086845 | 2022-01-06 | Lamar | Georgia | 13171 | 3950 | 101 |
2083593 | 2083593 | 2022-01-05 | Lamar | Georgia | 13171 | 3950 | 101 |
2080341 | 2080341 | 2022-01-04 | Lamar | Georgia | 13171 | 3913 | 101 |
2077089 | 2077089 | 2022-01-03 | Lamar | Georgia | 13171 | 3764 | 101 |
2073838 | 2073838 | 2022-01-02 | Lamar | Georgia | 13171 | 3764 | 101 |
2070587 | 2070587 | 2022-01-01 | Lamar | Georgia | 13171 | 3764 | 101 |
2067336 | 2067336 | 2021-12-31 | Lamar | Georgia | 13171 | 3764 | 101 |
2064085 | 2064085 | 2021-12-30 | Lamar | Georgia | 13171 | 3710 | 101 |
2060835 | 2060835 | 2021-12-29 | Lamar | Georgia | 13171 | 3656 | 101 |
2057586 | 2057586 | 2021-12-28 | Lamar | Georgia | 13171 | 3610 | 101 |
2054337 | 2054337 | 2021-12-27 | Lamar | Georgia | 13171 | 3594 | 101 |
2051087 | 2051087 | 2021-12-26 | Lamar | Georgia | 13171 | 3568 | 100 |
2047837 | 2047837 | 2021-12-25 | Lamar | Georgia | 13171 | 3568 | 100 |
2044587 | 2044587 | 2021-12-24 | Lamar | Georgia | 13171 | 3568 | 100 |
2041338 | 2041338 | 2021-12-23 | Lamar | Georgia | 13171 | 3553 | 100 |
2038088 | 2038088 | 2021-12-22 | Lamar | Georgia | 13171 | 3539 | 100 |
2034838 | 2034838 | 2021-12-21 | Lamar | Georgia | 13171 | 3530 | 100 |
2031588 | 2031588 | 2021-12-20 | Lamar | Georgia | 13171 | 3522 | 100 |
2028337 | 2028337 | 2021-12-19 | Lamar | Georgia | 13171 | 3517 | 100 |
2025086 | 2025086 | 2021-12-18 | Lamar | Georgia | 13171 | 3517 | 100 |
2021835 | 2021835 | 2021-12-17 | Lamar | Georgia | 13171 | 3517 | 100 |
2018584 | 2018584 | 2021-12-16 | Lamar | Georgia | 13171 | 3513 | 99 |
2015334 | 2015334 | 2021-12-15 | Lamar | Georgia | 13171 | 3512 | 99 |
2012083 | 2012083 | 2021-12-14 | Lamar | Georgia | 13171 | 3505 | 99 |
2008832 | 2008832 | 2021-12-13 | Lamar | Georgia | 13171 | 3503 | 99 |
2005581 | 2005581 | 2021-12-12 | Lamar | Georgia | 13171 | 3496 | 99 |
2002330 | 2002330 | 2021-12-11 | Lamar | Georgia | 13171 | 3496 | 99 |
1999080 | 1999080 | 2021-12-10 | Lamar | Georgia | 13171 | 3496 | 99 |
1995829 | 1995829 | 2021-12-09 | Lamar | Georgia | 13171 | 3496 | 99 |
1992578 | 1992578 | 2021-12-08 | Lamar | Georgia | 13171 | 3496 | 99 |
1989327 | 1989327 | 2021-12-07 | Lamar | Georgia | 13171 | 3491 | 99 |
1986077 | 1986077 | 2021-12-06 | Lamar | Georgia | 13171 | 3491 | 99 |
1982827 | 1982827 | 2021-12-05 | Lamar | Georgia | 13171 | 3491 | 99 |
1979577 | 1979577 | 2021-12-04 | Lamar | Georgia | 13171 | 3491 | 99 |
1976327 | 1976327 | 2021-12-03 | Lamar | Georgia | 13171 | 3491 | 99 |
1973078 | 1973078 | 2021-12-02 | Lamar | Georgia | 13171 | 3491 | 99 |
1969828 | 1969828 | 2021-12-01 | Lamar | Georgia | 13171 | 3488 | 98 |
1966578 | 1966578 | 2021-11-30 | Lamar | Georgia | 13171 | 3485 | 98 |
1963326 | 1963326 | 2021-11-29 | Lamar | Georgia | 13171 | 3481 | 98 |
1960075 | 1960075 | 2021-11-28 | Lamar | Georgia | 13171 | 3477 | 98 |
1956824 | 1956824 | 2021-11-27 | Lamar | Georgia | 13171 | 3477 | 98 |
1953573 | 1953573 | 2021-11-26 | Lamar | Georgia | 13171 | 3477 | 98 |
1950322 | 1950322 | 2021-11-25 | Lamar | Georgia | 13171 | 3477 | 98 |
1947071 | 1947071 | 2021-11-24 | Lamar | Georgia | 13171 | 3477 | 98 |
1943820 | 1943820 | 2021-11-23 | Lamar | Georgia | 13171 | 3475 | 97 |
1940570 | 1940570 | 2021-11-22 | Lamar | Georgia | 13171 | 3470 | 97 |
1937320 | 1937320 | 2021-11-21 | Lamar | Georgia | 13171 | 3464 | 97 |
1934070 | 1934070 | 2021-11-20 | Lamar | Georgia | 13171 | 3464 | 97 |
1930818 | 1930818 | 2021-11-19 | Lamar | Georgia | 13171 | 3464 | 97 |
1927568 | 1927568 | 2021-11-18 | Lamar | Georgia | 13171 | 3463 | 97 |
1924318 | 1924318 | 2021-11-17 | Lamar | Georgia | 13171 | 3461 | 97 |
1921069 | 1921069 | 2021-11-16 | Lamar | Georgia | 13171 | 3461 | 96 |
1917819 | 1917819 | 2021-11-15 | Lamar | Georgia | 13171 | 3460 | 96 |
1914569 | 1914569 | 2021-11-14 | Lamar | Georgia | 13171 | 3456 | 96 |
1911319 | 1911319 | 2021-11-13 | Lamar | Georgia | 13171 | 3456 | 96 |
1908070 | 1908070 | 2021-11-12 | Lamar | Georgia | 13171 | 3456 | 96 |
1904821 | 1904821 | 2021-11-11 | Lamar | Georgia | 13171 | 3446 | 95 |
1901571 | 1901571 | 2021-11-10 | Lamar | Georgia | 13171 | 3446 | 95 |
1898321 | 1898321 | 2021-11-09 | Lamar | Georgia | 13171 | 3441 | 93 |
1895071 | 1895071 | 2021-11-08 | Lamar | Georgia | 13171 | 3436 | 92 |
1891821 | 1891821 | 2021-11-07 | Lamar | Georgia | 13171 | 3436 | 92 |
1888571 | 1888571 | 2021-11-06 | Lamar | Georgia | 13171 | 3436 | 92 |
1885321 | 1885321 | 2021-11-05 | Lamar | Georgia | 13171 | 3436 | 92 |
1882072 | 1882072 | 2021-11-04 | Lamar | Georgia | 13171 | 3432 | 92 |
1878823 | 1878823 | 2021-11-03 | Lamar | Georgia | 13171 | 3429 | 90 |
1875574 | 1875574 | 2021-11-02 | Lamar | Georgia | 13171 | 3424 | 90 |
1872325 | 1872325 | 2021-11-01 | Lamar | Georgia | 13171 | 3422 | 90 |
1869076 | 1869076 | 2021-10-31 | Lamar | Georgia | 13171 | 3414 | 90 |
1865827 | 1865827 | 2021-10-30 | Lamar | Georgia | 13171 | 3414 | 90 |
1862578 | 1862578 | 2021-10-29 | Lamar | Georgia | 13171 | 3414 | 90 |
1859329 | 1859329 | 2021-10-28 | Lamar | Georgia | 13171 | 3413 | 89 |
1856080 | 1856080 | 2021-10-27 | Lamar | Georgia | 13171 | 3404 | 89 |
1852831 | 1852831 | 2021-10-26 | Lamar | Georgia | 13171 | 3403 | 89 |
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);