ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 6093 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174428 | 2174428 | 2022-02-02 | Siskiyou | California | 6093 | 6742 | 88 |
2171175 | 2171175 | 2022-02-01 | Siskiyou | California | 6093 | 6679 | 87 |
2167922 | 2167922 | 2022-01-31 | Siskiyou | California | 6093 | 6604 | 86 |
2164667 | 2164667 | 2022-01-30 | Siskiyou | California | 6093 | 6604 | 86 |
2161412 | 2161412 | 2022-01-29 | Siskiyou | California | 6093 | 6604 | 86 |
2158156 | 2158156 | 2022-01-28 | Siskiyou | California | 6093 | 6521 | 86 |
2154903 | 2154903 | 2022-01-27 | Siskiyou | California | 6093 | 6450 | 86 |
2151650 | 2151650 | 2022-01-26 | Siskiyou | California | 6093 | 6375 | 85 |
2148398 | 2148398 | 2022-01-25 | Siskiyou | California | 6093 | 6375 | 85 |
2145146 | 2145146 | 2022-01-24 | Siskiyou | California | 6093 | 6259 | 84 |
2141891 | 2141891 | 2022-01-23 | Siskiyou | California | 6093 | 5801 | 81 |
2138636 | 2138636 | 2022-01-22 | Siskiyou | California | 6093 | 5801 | 81 |
2135380 | 2135380 | 2022-01-21 | Siskiyou | California | 6093 | 5801 | 81 |
2132128 | 2132128 | 2022-01-20 | Siskiyou | California | 6093 | 5777 | 81 |
2128875 | 2128875 | 2022-01-19 | Siskiyou | California | 6093 | 5497 | 81 |
2125621 | 2125621 | 2022-01-18 | Siskiyou | California | 6093 | 5462 | 81 |
2122369 | 2122369 | 2022-01-17 | Siskiyou | California | 6093 | 5446 | 81 |
2119117 | 2119117 | 2022-01-16 | Siskiyou | California | 6093 | 5359 | 81 |
2115865 | 2115865 | 2022-01-15 | Siskiyou | California | 6093 | 5359 | 81 |
2112614 | 2112614 | 2022-01-14 | Siskiyou | California | 6093 | 5359 | 81 |
2109362 | 2109362 | 2022-01-13 | Siskiyou | California | 6093 | 5337 | 81 |
2106111 | 2106111 | 2022-01-12 | Siskiyou | California | 6093 | 5316 | 81 |
2102860 | 2102860 | 2022-01-11 | Siskiyou | California | 6093 | 5316 | 81 |
2099609 | 2099609 | 2022-01-10 | Siskiyou | California | 6093 | 5316 | 81 |
2096358 | 2096358 | 2022-01-09 | Siskiyou | California | 6093 | 5316 | 81 |
2093106 | 2093106 | 2022-01-08 | Siskiyou | California | 6093 | 5260 | 81 |
2089854 | 2089854 | 2022-01-07 | Siskiyou | California | 6093 | 5260 | 81 |
2086603 | 2086603 | 2022-01-06 | Siskiyou | California | 6093 | 5260 | 81 |
2083351 | 2083351 | 2022-01-05 | Siskiyou | California | 6093 | 5201 | 81 |
2080099 | 2080099 | 2022-01-04 | Siskiyou | California | 6093 | 5182 | 80 |
2076847 | 2076847 | 2022-01-03 | Siskiyou | California | 6093 | 5131 | 80 |
2073596 | 2073596 | 2022-01-02 | Siskiyou | California | 6093 | 5103 | 80 |
2070345 | 2070345 | 2022-01-01 | Siskiyou | California | 6093 | 5103 | 80 |
2067094 | 2067094 | 2021-12-31 | Siskiyou | California | 6093 | 5103 | 80 |
2063843 | 2063843 | 2021-12-30 | Siskiyou | California | 6093 | 5103 | 80 |
2060593 | 2060593 | 2021-12-29 | Siskiyou | California | 6093 | 5080 | 79 |
2057344 | 2057344 | 2021-12-28 | Siskiyou | California | 6093 | 5072 | 79 |
2054095 | 2054095 | 2021-12-27 | Siskiyou | California | 6093 | 5058 | 77 |
2050845 | 2050845 | 2021-12-26 | Siskiyou | California | 6093 | 5041 | 77 |
2047595 | 2047595 | 2021-12-25 | Siskiyou | California | 6093 | 5041 | 77 |
2044345 | 2044345 | 2021-12-24 | Siskiyou | California | 6093 | 5041 | 77 |
2041096 | 2041096 | 2021-12-23 | Siskiyou | California | 6093 | 5041 | 77 |
2037846 | 2037846 | 2021-12-22 | Siskiyou | California | 6093 | 5041 | 77 |
2034596 | 2034596 | 2021-12-21 | Siskiyou | California | 6093 | 5038 | 77 |
2031346 | 2031346 | 2021-12-20 | Siskiyou | California | 6093 | 5031 | 76 |
2028095 | 2028095 | 2021-12-19 | Siskiyou | California | 6093 | 5021 | 76 |
2024844 | 2024844 | 2021-12-18 | Siskiyou | California | 6093 | 5021 | 76 |
2021593 | 2021593 | 2021-12-17 | Siskiyou | California | 6093 | 5021 | 76 |
2018342 | 2018342 | 2021-12-16 | Siskiyou | California | 6093 | 5015 | 75 |
2015092 | 2015092 | 2021-12-15 | Siskiyou | California | 6093 | 5009 | 75 |
2011841 | 2011841 | 2021-12-14 | Siskiyou | California | 6093 | 4999 | 75 |
2008590 | 2008590 | 2021-12-13 | Siskiyou | California | 6093 | 4992 | 75 |
2005339 | 2005339 | 2021-12-12 | Siskiyou | California | 6093 | 4984 | 74 |
2002088 | 2002088 | 2021-12-11 | Siskiyou | California | 6093 | 4982 | 74 |
1998838 | 1998838 | 2021-12-10 | Siskiyou | California | 6093 | 4982 | 74 |
1995587 | 1995587 | 2021-12-09 | Siskiyou | California | 6093 | 4982 | 74 |
1992336 | 1992336 | 2021-12-08 | Siskiyou | California | 6093 | 4977 | 74 |
1989085 | 1989085 | 2021-12-07 | Siskiyou | California | 6093 | 4970 | 74 |
1985835 | 1985835 | 2021-12-06 | Siskiyou | California | 6093 | 4961 | 74 |
1982585 | 1982585 | 2021-12-05 | Siskiyou | California | 6093 | 4947 | 74 |
1979335 | 1979335 | 2021-12-04 | Siskiyou | California | 6093 | 4942 | 74 |
1976085 | 1976085 | 2021-12-03 | Siskiyou | California | 6093 | 4942 | 74 |
1972836 | 1972836 | 2021-12-02 | Siskiyou | California | 6093 | 4942 | 74 |
1969586 | 1969586 | 2021-12-01 | Siskiyou | California | 6093 | 4933 | 73 |
1966336 | 1966336 | 2021-11-30 | Siskiyou | California | 6093 | 4920 | 70 |
1963084 | 1963084 | 2021-11-29 | Siskiyou | California | 6093 | 4907 | 70 |
1959833 | 1959833 | 2021-11-28 | Siskiyou | California | 6093 | 4864 | 70 |
1956582 | 1956582 | 2021-11-27 | Siskiyou | California | 6093 | 4864 | 70 |
1953331 | 1953331 | 2021-11-26 | Siskiyou | California | 6093 | 4864 | 70 |
1950080 | 1950080 | 2021-11-25 | Siskiyou | California | 6093 | 4864 | 70 |
1946829 | 1946829 | 2021-11-24 | Siskiyou | California | 6093 | 4864 | 70 |
1943578 | 1943578 | 2021-11-23 | Siskiyou | California | 6093 | 4857 | 70 |
1940328 | 1940328 | 2021-11-22 | Siskiyou | California | 6093 | 4850 | 69 |
1937078 | 1937078 | 2021-11-21 | Siskiyou | California | 6093 | 4837 | 69 |
1933828 | 1933828 | 2021-11-20 | Siskiyou | California | 6093 | 4837 | 69 |
1930576 | 1930576 | 2021-11-19 | Siskiyou | California | 6093 | 4826 | 69 |
1927326 | 1927326 | 2021-11-18 | Siskiyou | California | 6093 | 4826 | 69 |
1924076 | 1924076 | 2021-11-17 | Siskiyou | California | 6093 | 4809 | 69 |
1920827 | 1920827 | 2021-11-16 | Siskiyou | California | 6093 | 4809 | 69 |
1917577 | 1917577 | 2021-11-15 | Siskiyou | California | 6093 | 4797 | 69 |
1914327 | 1914327 | 2021-11-14 | Siskiyou | California | 6093 | 4797 | 69 |
1911077 | 1911077 | 2021-11-13 | Siskiyou | California | 6093 | 4796 | 69 |
1907828 | 1907828 | 2021-11-12 | Siskiyou | California | 6093 | 4796 | 69 |
1904579 | 1904579 | 2021-11-11 | Siskiyou | California | 6093 | 4796 | 69 |
1901329 | 1901329 | 2021-11-10 | Siskiyou | California | 6093 | 4796 | 69 |
1898079 | 1898079 | 2021-11-09 | Siskiyou | California | 6093 | 4789 | 69 |
1894829 | 1894829 | 2021-11-08 | Siskiyou | California | 6093 | 4777 | 68 |
1891579 | 1891579 | 2021-11-07 | Siskiyou | California | 6093 | 4765 | 66 |
1888329 | 1888329 | 2021-11-06 | Siskiyou | California | 6093 | 4765 | 66 |
1885079 | 1885079 | 2021-11-05 | Siskiyou | California | 6093 | 4765 | 66 |
1881830 | 1881830 | 2021-11-04 | Siskiyou | California | 6093 | 4755 | 66 |
1878581 | 1878581 | 2021-11-03 | Siskiyou | California | 6093 | 4741 | 65 |
1875332 | 1875332 | 2021-11-02 | Siskiyou | California | 6093 | 4737 | 65 |
1872083 | 1872083 | 2021-11-01 | Siskiyou | California | 6093 | 4728 | 65 |
1868834 | 1868834 | 2021-10-31 | Siskiyou | California | 6093 | 4718 | 65 |
1865585 | 1865585 | 2021-10-30 | Siskiyou | California | 6093 | 4718 | 65 |
1862336 | 1862336 | 2021-10-29 | Siskiyou | California | 6093 | 4718 | 65 |
1859087 | 1859087 | 2021-10-28 | Siskiyou | California | 6093 | 4705 | 65 |
1855838 | 1855838 | 2021-10-27 | Siskiyou | California | 6093 | 4695 | 65 |
1852589 | 1852589 | 2021-10-26 | Siskiyou | California | 6093 | 4687 | 64 |
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);