ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 13073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174621 | 2174621 | 2022-02-02 | Columbia | Georgia | 13073 | 34036 | 340 |
2171368 | 2171368 | 2022-02-01 | Columbia | Georgia | 13073 | 33921 | 340 |
2168115 | 2168115 | 2022-01-31 | Columbia | Georgia | 13073 | 33727 | 338 |
2164860 | 2164860 | 2022-01-30 | Columbia | Georgia | 13073 | 33458 | 338 |
2161605 | 2161605 | 2022-01-29 | Columbia | Georgia | 13073 | 33458 | 338 |
2158349 | 2158349 | 2022-01-28 | Columbia | Georgia | 13073 | 33458 | 338 |
2155096 | 2155096 | 2022-01-27 | Columbia | Georgia | 13073 | 33165 | 337 |
2151843 | 2151843 | 2022-01-26 | Columbia | Georgia | 13073 | 32974 | 336 |
2148591 | 2148591 | 2022-01-25 | Columbia | Georgia | 13073 | 32620 | 336 |
2145339 | 2145339 | 2022-01-24 | Columbia | Georgia | 13073 | 32308 | 334 |
2142084 | 2142084 | 2022-01-23 | Columbia | Georgia | 13073 | 31625 | 333 |
2138829 | 2138829 | 2022-01-22 | Columbia | Georgia | 13073 | 31625 | 333 |
2135573 | 2135573 | 2022-01-21 | Columbia | Georgia | 13073 | 31625 | 333 |
2132321 | 2132321 | 2022-01-20 | Columbia | Georgia | 13073 | 31183 | 330 |
2129068 | 2129068 | 2022-01-19 | Columbia | Georgia | 13073 | 30890 | 328 |
2125814 | 2125814 | 2022-01-18 | Columbia | Georgia | 13073 | 30212 | 327 |
2122562 | 2122562 | 2022-01-17 | Columbia | Georgia | 13073 | 30072 | 327 |
2119310 | 2119310 | 2022-01-16 | Columbia | Georgia | 13073 | 29742 | 327 |
2116058 | 2116058 | 2022-01-15 | Columbia | Georgia | 13073 | 29742 | 327 |
2112807 | 2112807 | 2022-01-14 | Columbia | Georgia | 13073 | 29742 | 327 |
2109555 | 2109555 | 2022-01-13 | Columbia | Georgia | 13073 | 29174 | 327 |
2106304 | 2106304 | 2022-01-12 | Columbia | Georgia | 13073 | 28949 | 327 |
2103053 | 2103053 | 2022-01-11 | Columbia | Georgia | 13073 | 28777 | 327 |
2099802 | 2099802 | 2022-01-10 | Columbia | Georgia | 13073 | 28511 | 325 |
2096551 | 2096551 | 2022-01-09 | Columbia | Georgia | 13073 | 27474 | 324 |
2093299 | 2093299 | 2022-01-08 | Columbia | Georgia | 13073 | 27474 | 324 |
2090047 | 2090047 | 2022-01-07 | Columbia | Georgia | 13073 | 27474 | 324 |
2086796 | 2086796 | 2022-01-06 | Columbia | Georgia | 13073 | 27474 | 324 |
2083544 | 2083544 | 2022-01-05 | Columbia | Georgia | 13073 | 27474 | 324 |
2080292 | 2080292 | 2022-01-04 | Columbia | Georgia | 13073 | 27222 | 323 |
2077040 | 2077040 | 2022-01-03 | Columbia | Georgia | 13073 | 26765 | 323 |
2073789 | 2073789 | 2022-01-02 | Columbia | Georgia | 13073 | 26765 | 323 |
2070538 | 2070538 | 2022-01-01 | Columbia | Georgia | 13073 | 26765 | 323 |
2067287 | 2067287 | 2021-12-31 | Columbia | Georgia | 13073 | 26765 | 323 |
2064036 | 2064036 | 2021-12-30 | Columbia | Georgia | 13073 | 26576 | 322 |
2060786 | 2060786 | 2021-12-29 | Columbia | Georgia | 13073 | 26392 | 322 |
2057537 | 2057537 | 2021-12-28 | Columbia | Georgia | 13073 | 26227 | 322 |
2054288 | 2054288 | 2021-12-27 | Columbia | Georgia | 13073 | 26070 | 322 |
2051038 | 2051038 | 2021-12-26 | Columbia | Georgia | 13073 | 25933 | 322 |
2047788 | 2047788 | 2021-12-25 | Columbia | Georgia | 13073 | 25933 | 322 |
2044538 | 2044538 | 2021-12-24 | Columbia | Georgia | 13073 | 25933 | 322 |
2041289 | 2041289 | 2021-12-23 | Columbia | Georgia | 13073 | 25854 | 322 |
2038039 | 2038039 | 2021-12-22 | Columbia | Georgia | 13073 | 25795 | 322 |
2034789 | 2034789 | 2021-12-21 | Columbia | Georgia | 13073 | 25754 | 320 |
2031539 | 2031539 | 2021-12-20 | Columbia | Georgia | 13073 | 25706 | 320 |
2028288 | 2028288 | 2021-12-19 | Columbia | Georgia | 13073 | 25647 | 319 |
2025037 | 2025037 | 2021-12-18 | Columbia | Georgia | 13073 | 25647 | 319 |
2021786 | 2021786 | 2021-12-17 | Columbia | Georgia | 13073 | 25647 | 319 |
2018535 | 2018535 | 2021-12-16 | Columbia | Georgia | 13073 | 25622 | 319 |
2015285 | 2015285 | 2021-12-15 | Columbia | Georgia | 13073 | 25600 | 319 |
2012034 | 2012034 | 2021-12-14 | Columbia | Georgia | 13073 | 25571 | 319 |
2008783 | 2008783 | 2021-12-13 | Columbia | Georgia | 13073 | 25546 | 319 |
2005532 | 2005532 | 2021-12-12 | Columbia | Georgia | 13073 | 25510 | 319 |
2002281 | 2002281 | 2021-12-11 | Columbia | Georgia | 13073 | 25510 | 319 |
1999031 | 1999031 | 2021-12-10 | Columbia | Georgia | 13073 | 25510 | 319 |
1995780 | 1995780 | 2021-12-09 | Columbia | Georgia | 13073 | 25479 | 318 |
1992529 | 1992529 | 2021-12-08 | Columbia | Georgia | 13073 | 25469 | 318 |
1989278 | 1989278 | 2021-12-07 | Columbia | Georgia | 13073 | 25436 | 318 |
1986028 | 1986028 | 2021-12-06 | Columbia | Georgia | 13073 | 25414 | 318 |
1982778 | 1982778 | 2021-12-05 | Columbia | Georgia | 13073 | 25366 | 317 |
1979528 | 1979528 | 2021-12-04 | Columbia | Georgia | 13073 | 25366 | 317 |
1976278 | 1976278 | 2021-12-03 | Columbia | Georgia | 13073 | 25366 | 317 |
1973029 | 1973029 | 2021-12-02 | Columbia | Georgia | 13073 | 25347 | 315 |
1969779 | 1969779 | 2021-12-01 | Columbia | Georgia | 13073 | 25318 | 314 |
1966529 | 1966529 | 2021-11-30 | Columbia | Georgia | 13073 | 25293 | 313 |
1963277 | 1963277 | 2021-11-29 | Columbia | Georgia | 13073 | 25259 | 313 |
1960026 | 1960026 | 2021-11-28 | Columbia | Georgia | 13073 | 25214 | 312 |
1956775 | 1956775 | 2021-11-27 | Columbia | Georgia | 13073 | 25214 | 312 |
1953524 | 1953524 | 2021-11-26 | Columbia | Georgia | 13073 | 25214 | 312 |
1950273 | 1950273 | 2021-11-25 | Columbia | Georgia | 13073 | 25214 | 312 |
1947022 | 1947022 | 2021-11-24 | Columbia | Georgia | 13073 | 25214 | 312 |
1943771 | 1943771 | 2021-11-23 | Columbia | Georgia | 13073 | 25197 | 311 |
1940521 | 1940521 | 2021-11-22 | Columbia | Georgia | 13073 | 25175 | 311 |
1937271 | 1937271 | 2021-11-21 | Columbia | Georgia | 13073 | 25142 | 311 |
1934021 | 1934021 | 2021-11-20 | Columbia | Georgia | 13073 | 25142 | 311 |
1930769 | 1930769 | 2021-11-19 | Columbia | Georgia | 13073 | 25142 | 311 |
1927519 | 1927519 | 2021-11-18 | Columbia | Georgia | 13073 | 25119 | 311 |
1924269 | 1924269 | 2021-11-17 | Columbia | Georgia | 13073 | 25113 | 308 |
1921020 | 1921020 | 2021-11-16 | Columbia | Georgia | 13073 | 25094 | 306 |
1917770 | 1917770 | 2021-11-15 | Columbia | Georgia | 13073 | 25079 | 306 |
1914520 | 1914520 | 2021-11-14 | Columbia | Georgia | 13073 | 25055 | 306 |
1911270 | 1911270 | 2021-11-13 | Columbia | Georgia | 13073 | 25055 | 306 |
1908021 | 1908021 | 2021-11-12 | Columbia | Georgia | 13073 | 25055 | 306 |
1904772 | 1904772 | 2021-11-11 | Columbia | Georgia | 13073 | 25036 | 305 |
1901522 | 1901522 | 2021-11-10 | Columbia | Georgia | 13073 | 25036 | 305 |
1898272 | 1898272 | 2021-11-09 | Columbia | Georgia | 13073 | 25024 | 301 |
1895022 | 1895022 | 2021-11-08 | Columbia | Georgia | 13073 | 24985 | 300 |
1891772 | 1891772 | 2021-11-07 | Columbia | Georgia | 13073 | 24986 | 300 |
1888522 | 1888522 | 2021-11-06 | Columbia | Georgia | 13073 | 24986 | 300 |
1885272 | 1885272 | 2021-11-05 | Columbia | Georgia | 13073 | 24986 | 300 |
1882023 | 1882023 | 2021-11-04 | Columbia | Georgia | 13073 | 24976 | 300 |
1878774 | 1878774 | 2021-11-03 | Columbia | Georgia | 13073 | 24955 | 297 |
1875525 | 1875525 | 2021-11-02 | Columbia | Georgia | 13073 | 24940 | 296 |
1872276 | 1872276 | 2021-11-01 | Columbia | Georgia | 13073 | 24921 | 296 |
1869027 | 1869027 | 2021-10-31 | Columbia | Georgia | 13073 | 24890 | 295 |
1865778 | 1865778 | 2021-10-30 | Columbia | Georgia | 13073 | 24890 | 295 |
1862529 | 1862529 | 2021-10-29 | Columbia | Georgia | 13073 | 24890 | 295 |
1859280 | 1859280 | 2021-10-28 | Columbia | Georgia | 13073 | 24868 | 295 |
1856031 | 1856031 | 2021-10-27 | Columbia | Georgia | 13073 | 24845 | 293 |
1852782 | 1852782 | 2021-10-26 | Columbia | Georgia | 13073 | 24809 | 293 |
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);