ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 6089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174426 | 2174426 | 2022-02-02 | Shasta | California | 6089 | 33657 | 529 |
2171173 | 2171173 | 2022-02-01 | Shasta | California | 6089 | 33465 | 529 |
2167920 | 2167920 | 2022-01-31 | Shasta | California | 6089 | 33380 | 526 |
2164665 | 2164665 | 2022-01-30 | Shasta | California | 6089 | 32779 | 526 |
2161410 | 2161410 | 2022-01-29 | Shasta | California | 6089 | 32779 | 526 |
2158154 | 2158154 | 2022-01-28 | Shasta | California | 6089 | 32779 | 526 |
2154901 | 2154901 | 2022-01-27 | Shasta | California | 6089 | 32530 | 515 |
2151648 | 2151648 | 2022-01-26 | Shasta | California | 6089 | 31761 | 515 |
2148396 | 2148396 | 2022-01-25 | Shasta | California | 6089 | 31542 | 515 |
2145144 | 2145144 | 2022-01-24 | Shasta | California | 6089 | 31403 | 515 |
2141889 | 2141889 | 2022-01-23 | Shasta | California | 6089 | 30590 | 512 |
2138634 | 2138634 | 2022-01-22 | Shasta | California | 6089 | 30590 | 512 |
2135378 | 2135378 | 2022-01-21 | Shasta | California | 6089 | 30590 | 512 |
2132126 | 2132126 | 2022-01-20 | Shasta | California | 6089 | 30026 | 510 |
2128873 | 2128873 | 2022-01-19 | Shasta | California | 6089 | 29382 | 508 |
2125619 | 2125619 | 2022-01-18 | Shasta | California | 6089 | 29245 | 508 |
2122367 | 2122367 | 2022-01-17 | Shasta | California | 6089 | 29200 | 506 |
2119115 | 2119115 | 2022-01-16 | Shasta | California | 6089 | 28702 | 506 |
2115863 | 2115863 | 2022-01-15 | Shasta | California | 6089 | 28702 | 506 |
2112612 | 2112612 | 2022-01-14 | Shasta | California | 6089 | 28702 | 506 |
2109360 | 2109360 | 2022-01-13 | Shasta | California | 6089 | 28544 | 502 |
2106109 | 2106109 | 2022-01-12 | Shasta | California | 6089 | 28082 | 500 |
2102858 | 2102858 | 2022-01-11 | Shasta | California | 6089 | 27933 | 500 |
2099607 | 2099607 | 2022-01-10 | Shasta | California | 6089 | 27876 | 498 |
2096356 | 2096356 | 2022-01-09 | Shasta | California | 6089 | 27535 | 498 |
2093104 | 2093104 | 2022-01-08 | Shasta | California | 6089 | 27535 | 498 |
2089852 | 2089852 | 2022-01-07 | Shasta | California | 6089 | 27535 | 498 |
2086601 | 2086601 | 2022-01-06 | Shasta | California | 6089 | 27311 | 498 |
2083349 | 2083349 | 2022-01-05 | Shasta | California | 6089 | 27237 | 498 |
2080097 | 2080097 | 2022-01-04 | Shasta | California | 6089 | 27172 | 494 |
2076845 | 2076845 | 2022-01-03 | Shasta | California | 6089 | 27032 | 491 |
2073594 | 2073594 | 2022-01-02 | Shasta | California | 6089 | 27032 | 491 |
2070343 | 2070343 | 2022-01-01 | Shasta | California | 6089 | 27032 | 491 |
2067092 | 2067092 | 2021-12-31 | Shasta | California | 6089 | 27032 | 491 |
2063841 | 2063841 | 2021-12-30 | Shasta | California | 6089 | 26954 | 491 |
2060591 | 2060591 | 2021-12-29 | Shasta | California | 6089 | 26881 | 491 |
2057342 | 2057342 | 2021-12-28 | Shasta | California | 6089 | 26861 | 491 |
2054093 | 2054093 | 2021-12-27 | Shasta | California | 6089 | 26805 | 481 |
2050843 | 2050843 | 2021-12-26 | Shasta | California | 6089 | 26805 | 481 |
2047593 | 2047593 | 2021-12-25 | Shasta | California | 6089 | 26805 | 481 |
2044343 | 2044343 | 2021-12-24 | Shasta | California | 6089 | 26805 | 481 |
2041094 | 2041094 | 2021-12-23 | Shasta | California | 6089 | 26783 | 481 |
2037844 | 2037844 | 2021-12-22 | Shasta | California | 6089 | 26757 | 481 |
2034594 | 2034594 | 2021-12-21 | Shasta | California | 6089 | 26725 | 481 |
2031344 | 2031344 | 2021-12-20 | Shasta | California | 6089 | 26712 | 481 |
2028093 | 2028093 | 2021-12-19 | Shasta | California | 6089 | 26648 | 476 |
2024842 | 2024842 | 2021-12-18 | Shasta | California | 6089 | 26648 | 476 |
2021591 | 2021591 | 2021-12-17 | Shasta | California | 6089 | 26648 | 476 |
2018340 | 2018340 | 2021-12-16 | Shasta | California | 6089 | 26615 | 476 |
2015090 | 2015090 | 2021-12-15 | Shasta | California | 6089 | 26568 | 476 |
2011839 | 2011839 | 2021-12-14 | Shasta | California | 6089 | 26543 | 476 |
2008588 | 2008588 | 2021-12-13 | Shasta | California | 6089 | 26544 | 472 |
2005337 | 2005337 | 2021-12-12 | Shasta | California | 6089 | 26472 | 470 |
2002086 | 2002086 | 2021-12-11 | Shasta | California | 6089 | 26472 | 470 |
1998836 | 1998836 | 2021-12-10 | Shasta | California | 6089 | 26472 | 470 |
1995585 | 1995585 | 2021-12-09 | Shasta | California | 6089 | 26428 | 470 |
1992334 | 1992334 | 2021-12-08 | Shasta | California | 6089 | 26397 | 465 |
1989083 | 1989083 | 2021-12-07 | Shasta | California | 6089 | 26359 | 465 |
1985833 | 1985833 | 2021-12-06 | Shasta | California | 6089 | 26353 | 462 |
1982583 | 1982583 | 2021-12-05 | Shasta | California | 6089 | 26221 | 461 |
1979333 | 1979333 | 2021-12-04 | Shasta | California | 6089 | 26221 | 461 |
1976083 | 1976083 | 2021-12-03 | Shasta | California | 6089 | 26221 | 461 |
1972834 | 1972834 | 2021-12-02 | Shasta | California | 6089 | 26178 | 460 |
1969584 | 1969584 | 2021-12-01 | Shasta | California | 6089 | 26113 | 458 |
1966334 | 1966334 | 2021-11-30 | Shasta | California | 6089 | 26081 | 451 |
1963082 | 1963082 | 2021-11-29 | Shasta | California | 6089 | 26082 | 444 |
1959831 | 1959831 | 2021-11-28 | Shasta | California | 6089 | 25917 | 440 |
1956580 | 1956580 | 2021-11-27 | Shasta | California | 6089 | 25917 | 440 |
1953329 | 1953329 | 2021-11-26 | Shasta | California | 6089 | 25917 | 440 |
1950078 | 1950078 | 2021-11-25 | Shasta | California | 6089 | 25917 | 440 |
1946827 | 1946827 | 2021-11-24 | Shasta | California | 6089 | 25917 | 440 |
1943576 | 1943576 | 2021-11-23 | Shasta | California | 6089 | 25882 | 440 |
1940326 | 1940326 | 2021-11-22 | Shasta | California | 6089 | 25878 | 439 |
1937076 | 1937076 | 2021-11-21 | Shasta | California | 6089 | 25734 | 433 |
1933826 | 1933826 | 2021-11-20 | Shasta | California | 6089 | 25734 | 433 |
1930574 | 1930574 | 2021-11-19 | Shasta | California | 6089 | 25734 | 433 |
1927324 | 1927324 | 2021-11-18 | Shasta | California | 6089 | 25649 | 426 |
1924074 | 1924074 | 2021-11-17 | Shasta | California | 6089 | 25583 | 416 |
1920825 | 1920825 | 2021-11-16 | Shasta | California | 6089 | 25509 | 413 |
1917575 | 1917575 | 2021-11-15 | Shasta | California | 6089 | 25501 | 413 |
1914325 | 1914325 | 2021-11-14 | Shasta | California | 6089 | 25443 | 406 |
1911075 | 1911075 | 2021-11-13 | Shasta | California | 6089 | 25443 | 406 |
1907826 | 1907826 | 2021-11-12 | Shasta | California | 6089 | 25330 | 406 |
1904577 | 1904577 | 2021-11-11 | Shasta | California | 6089 | 25330 | 402 |
1901327 | 1901327 | 2021-11-10 | Shasta | California | 6089 | 25283 | 402 |
1898077 | 1898077 | 2021-11-09 | Shasta | California | 6089 | 25229 | 395 |
1894827 | 1894827 | 2021-11-08 | Shasta | California | 6089 | 25204 | 391 |
1891577 | 1891577 | 2021-11-07 | Shasta | California | 6089 | 25006 | 384 |
1888327 | 1888327 | 2021-11-06 | Shasta | California | 6089 | 25006 | 384 |
1885077 | 1885077 | 2021-11-05 | Shasta | California | 6089 | 25006 | 384 |
1881828 | 1881828 | 2021-11-04 | Shasta | California | 6089 | 24940 | 377 |
1878579 | 1878579 | 2021-11-03 | Shasta | California | 6089 | 24772 | 374 |
1875330 | 1875330 | 2021-11-02 | Shasta | California | 6089 | 24749 | 370 |
1872081 | 1872081 | 2021-11-01 | Shasta | California | 6089 | 24731 | 364 |
1868832 | 1868832 | 2021-10-31 | Shasta | California | 6089 | 24523 | 364 |
1865583 | 1865583 | 2021-10-30 | Shasta | California | 6089 | 24523 | 364 |
1862334 | 1862334 | 2021-10-29 | Shasta | California | 6089 | 24523 | 364 |
1859085 | 1859085 | 2021-10-28 | Shasta | California | 6089 | 24458 | 364 |
1855836 | 1855836 | 2021-10-27 | Shasta | California | 6089 | 24263 | 364 |
1852587 | 1852587 | 2021-10-26 | Shasta | California | 6089 | 24204 | 354 |
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);