ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
840 rows where fips = 6059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174411 | 2174411 | 2022-02-02 | Orange | California | 6059 | 555437 | 6126 |
2171158 | 2171158 | 2022-02-01 | Orange | California | 6059 | 554054 | 6110 |
2167905 | 2167905 | 2022-01-31 | Orange | California | 6059 | 553030 | 6100 |
2164650 | 2164650 | 2022-01-30 | Orange | California | 6059 | 542951 | 6066 |
2161395 | 2161395 | 2022-01-29 | Orange | California | 6059 | 542951 | 6066 |
2158139 | 2158139 | 2022-01-28 | Orange | California | 6059 | 542951 | 6066 |
2154886 | 2154886 | 2022-01-27 | Orange | California | 6059 | 538115 | 6037 |
2151633 | 2151633 | 2022-01-26 | Orange | California | 6059 | 533836 | 6006 |
2148381 | 2148381 | 2022-01-25 | Orange | California | 6059 | 531196 | 5978 |
2145129 | 2145129 | 2022-01-24 | Orange | California | 6059 | 528530 | 5970 |
2141874 | 2141874 | 2022-01-23 | Orange | California | 6059 | 509891 | 5953 |
2138619 | 2138619 | 2022-01-22 | Orange | California | 6059 | 509891 | 5953 |
2135363 | 2135363 | 2022-01-21 | Orange | California | 6059 | 509891 | 5953 |
2132111 | 2132111 | 2022-01-20 | Orange | California | 6059 | 498022 | 5946 |
2128858 | 2128858 | 2022-01-19 | Orange | California | 6059 | 487199 | 5941 |
2125604 | 2125604 | 2022-01-18 | Orange | California | 6059 | 483293 | 5938 |
2122352 | 2122352 | 2022-01-17 | Orange | California | 6059 | 477837 | 5932 |
2119100 | 2119100 | 2022-01-16 | Orange | California | 6059 | 459016 | 5921 |
2115848 | 2115848 | 2022-01-15 | Orange | California | 6059 | 459016 | 5921 |
2112597 | 2112597 | 2022-01-14 | Orange | California | 6059 | 459016 | 5921 |
2109345 | 2109345 | 2022-01-13 | Orange | California | 6059 | 451612 | 5916 |
2106094 | 2106094 | 2022-01-12 | Orange | California | 6059 | 439765 | 5914 |
2102843 | 2102843 | 2022-01-11 | Orange | California | 6059 | 428232 | 5911 |
2099592 | 2099592 | 2022-01-10 | Orange | California | 6059 | 422625 | 5908 |
2096341 | 2096341 | 2022-01-09 | Orange | California | 6059 | 397186 | 5906 |
2093089 | 2093089 | 2022-01-08 | Orange | California | 6059 | 397186 | 5906 |
2089837 | 2089837 | 2022-01-07 | Orange | California | 6059 | 397186 | 5906 |
2086586 | 2086586 | 2022-01-06 | Orange | California | 6059 | 389985 | 5903 |
2083334 | 2083334 | 2022-01-05 | Orange | California | 6059 | 383719 | 5901 |
2080082 | 2080082 | 2022-01-04 | Orange | California | 6059 | 379073 | 5897 |
2076830 | 2076830 | 2022-01-03 | Orange | California | 6059 | 373143 | 5895 |
2073579 | 2073579 | 2022-01-02 | Orange | California | 6059 | 358569 | 5890 |
2070328 | 2070328 | 2022-01-01 | Orange | California | 6059 | 358569 | 5890 |
2067077 | 2067077 | 2021-12-31 | Orange | California | 6059 | 358569 | 5890 |
2063826 | 2063826 | 2021-12-30 | Orange | California | 6059 | 357716 | 5890 |
2060576 | 2060576 | 2021-12-29 | Orange | California | 6059 | 354314 | 5888 |
2057327 | 2057327 | 2021-12-28 | Orange | California | 6059 | 351565 | 5883 |
2054078 | 2054078 | 2021-12-27 | Orange | California | 6059 | 350578 | 5877 |
2050828 | 2050828 | 2021-12-26 | Orange | California | 6059 | 344103 | 5864 |
2047578 | 2047578 | 2021-12-25 | Orange | California | 6059 | 344103 | 5864 |
2044328 | 2044328 | 2021-12-24 | Orange | California | 6059 | 344103 | 5864 |
2041079 | 2041079 | 2021-12-23 | Orange | California | 6059 | 344103 | 5864 |
2037829 | 2037829 | 2021-12-22 | Orange | California | 6059 | 343448 | 5859 |
2034579 | 2034579 | 2021-12-21 | Orange | California | 6059 | 342391 | 5857 |
2031329 | 2031329 | 2021-12-20 | Orange | California | 6059 | 341739 | 5853 |
2028078 | 2028078 | 2021-12-19 | Orange | California | 6059 | 340384 | 5851 |
2024827 | 2024827 | 2021-12-18 | Orange | California | 6059 | 340384 | 5851 |
2021576 | 2021576 | 2021-12-17 | Orange | California | 6059 | 340384 | 5851 |
2018325 | 2018325 | 2021-12-16 | Orange | California | 6059 | 339935 | 5846 |
2015075 | 2015075 | 2021-12-15 | Orange | California | 6059 | 339619 | 5839 |
2011824 | 2011824 | 2021-12-14 | Orange | California | 6059 | 339305 | 5829 |
2008573 | 2008573 | 2021-12-13 | Orange | California | 6059 | 339106 | 5825 |
2005322 | 2005322 | 2021-12-12 | Orange | California | 6059 | 337937 | 5814 |
2002071 | 2002071 | 2021-12-11 | Orange | California | 6059 | 337937 | 5814 |
1998821 | 1998821 | 2021-12-10 | Orange | California | 6059 | 337937 | 5814 |
1995570 | 1995570 | 2021-12-09 | Orange | California | 6059 | 337623 | 5806 |
1992319 | 1992319 | 2021-12-08 | Orange | California | 6059 | 337328 | 5796 |
1989068 | 1989068 | 2021-12-07 | Orange | California | 6059 | 337045 | 5783 |
1985818 | 1985818 | 2021-12-06 | Orange | California | 6059 | 336739 | 5771 |
1982568 | 1982568 | 2021-12-05 | Orange | California | 6059 | 335296 | 5756 |
1979318 | 1979318 | 2021-12-04 | Orange | California | 6059 | 335296 | 5756 |
1976068 | 1976068 | 2021-12-03 | Orange | California | 6059 | 335296 | 5756 |
1972819 | 1972819 | 2021-12-02 | Orange | California | 6059 | 334940 | 5749 |
1969569 | 1969569 | 2021-12-01 | Orange | California | 6059 | 334626 | 5736 |
1966319 | 1966319 | 2021-11-30 | Orange | California | 6059 | 334398 | 5725 |
1963067 | 1963067 | 2021-11-29 | Orange | California | 6059 | 334176 | 5710 |
1959816 | 1959816 | 2021-11-28 | Orange | California | 6059 | 332950 | 5675 |
1956565 | 1956565 | 2021-11-27 | Orange | California | 6059 | 332950 | 5675 |
1953314 | 1953314 | 2021-11-26 | Orange | California | 6059 | 332950 | 5675 |
1950063 | 1950063 | 2021-11-25 | Orange | California | 6059 | 332950 | 5675 |
1946812 | 1946812 | 2021-11-24 | Orange | California | 6059 | 332950 | 5675 |
1943561 | 1943561 | 2021-11-23 | Orange | California | 6059 | 332770 | 5666 |
1940311 | 1940311 | 2021-11-22 | Orange | California | 6059 | 332619 | 5664 |
1937061 | 1937061 | 2021-11-21 | Orange | California | 6059 | 331850 | 5661 |
1933811 | 1933811 | 2021-11-20 | Orange | California | 6059 | 331850 | 5661 |
1930559 | 1930559 | 2021-11-19 | Orange | California | 6059 | 331850 | 5661 |
1927309 | 1927309 | 2021-11-18 | Orange | California | 6059 | 331522 | 5659 |
1924059 | 1924059 | 2021-11-17 | Orange | California | 6059 | 331322 | 5653 |
1920810 | 1920810 | 2021-11-16 | Orange | California | 6059 | 330981 | 5652 |
1917560 | 1917560 | 2021-11-15 | Orange | California | 6059 | 330798 | 5648 |
1914310 | 1914310 | 2021-11-14 | Orange | California | 6059 | 330093 | 5643 |
1911060 | 1911060 | 2021-11-13 | Orange | California | 6059 | 330093 | 5643 |
1907811 | 1907811 | 2021-11-12 | Orange | California | 6059 | 330093 | 5643 |
1904562 | 1904562 | 2021-11-11 | Orange | California | 6059 | 329541 | 5634 |
1901312 | 1901312 | 2021-11-10 | Orange | California | 6059 | 329541 | 5634 |
1898062 | 1898062 | 2021-11-09 | Orange | California | 6059 | 329323 | 5623 |
1894812 | 1894812 | 2021-11-08 | Orange | California | 6059 | 329084 | 5618 |
1891562 | 1891562 | 2021-11-07 | Orange | California | 6059 | 328210 | 5615 |
1888312 | 1888312 | 2021-11-06 | Orange | California | 6059 | 328210 | 5615 |
1885062 | 1885062 | 2021-11-05 | Orange | California | 6059 | 328210 | 5615 |
1881813 | 1881813 | 2021-11-04 | Orange | California | 6059 | 327827 | 5612 |
1878564 | 1878564 | 2021-11-03 | Orange | California | 6059 | 327535 | 5609 |
1875315 | 1875315 | 2021-11-02 | Orange | California | 6059 | 327321 | 5602 |
1872066 | 1872066 | 2021-11-01 | Orange | California | 6059 | 327152 | 5596 |
1868817 | 1868817 | 2021-10-31 | Orange | California | 6059 | 326246 | 5595 |
1865568 | 1865568 | 2021-10-30 | Orange | California | 6059 | 326246 | 5595 |
1862319 | 1862319 | 2021-10-29 | Orange | California | 6059 | 326246 | 5595 |
1859070 | 1859070 | 2021-10-28 | Orange | California | 6059 | 325921 | 5592 |
1855821 | 1855821 | 2021-10-27 | Orange | California | 6059 | 325607 | 5588 |
1852572 | 1852572 | 2021-10-26 | Orange | California | 6059 | 325252 | 5584 |
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);