ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174415 | 2174415 | 2022-02-02 | Sacramento | California | 6067 | 279302 | 2710 |
2171162 | 2171162 | 2022-02-01 | Sacramento | California | 6067 | 278392 | 2696 |
2167909 | 2167909 | 2022-01-31 | Sacramento | California | 6067 | 277513 | 2677 |
2164654 | 2164654 | 2022-01-30 | Sacramento | California | 6067 | 270928 | 2662 |
2161399 | 2161399 | 2022-01-29 | Sacramento | California | 6067 | 270928 | 2662 |
2158143 | 2158143 | 2022-01-28 | Sacramento | California | 6067 | 270928 | 2662 |
2154890 | 2154890 | 2022-01-27 | Sacramento | California | 6067 | 268214 | 2657 |
2151637 | 2151637 | 2022-01-26 | Sacramento | California | 6067 | 262039 | 2646 |
2148385 | 2148385 | 2022-01-25 | Sacramento | California | 6067 | 259093 | 2639 |
2145133 | 2145133 | 2022-01-24 | Sacramento | California | 6067 | 257160 | 2624 |
2141878 | 2141878 | 2022-01-23 | Sacramento | California | 6067 | 247777 | 2623 |
2138623 | 2138623 | 2022-01-22 | Sacramento | California | 6067 | 247777 | 2623 |
2135367 | 2135367 | 2022-01-21 | Sacramento | California | 6067 | 247777 | 2623 |
2132115 | 2132115 | 2022-01-20 | Sacramento | California | 6067 | 243606 | 2607 |
2128862 | 2128862 | 2022-01-19 | Sacramento | California | 6067 | 235049 | 2598 |
2125608 | 2125608 | 2022-01-18 | Sacramento | California | 6067 | 232447 | 2594 |
2122356 | 2122356 | 2022-01-17 | Sacramento | California | 6067 | 230123 | 2586 |
2119104 | 2119104 | 2022-01-16 | Sacramento | California | 6067 | 219460 | 2586 |
2115852 | 2115852 | 2022-01-15 | Sacramento | California | 6067 | 219460 | 2586 |
2112601 | 2112601 | 2022-01-14 | Sacramento | California | 6067 | 219460 | 2586 |
2109349 | 2109349 | 2022-01-13 | Sacramento | California | 6067 | 216000 | 2582 |
2106098 | 2106098 | 2022-01-12 | Sacramento | California | 6067 | 208287 | 2576 |
2102847 | 2102847 | 2022-01-11 | Sacramento | California | 6067 | 205252 | 2574 |
2099596 | 2099596 | 2022-01-10 | Sacramento | California | 6067 | 202673 | 2571 |
2096345 | 2096345 | 2022-01-09 | Sacramento | California | 6067 | 192347 | 2565 |
2093093 | 2093093 | 2022-01-08 | Sacramento | California | 6067 | 192347 | 2565 |
2089841 | 2089841 | 2022-01-07 | Sacramento | California | 6067 | 192347 | 2565 |
2086590 | 2086590 | 2022-01-06 | Sacramento | California | 6067 | 188717 | 2564 |
2083338 | 2083338 | 2022-01-05 | Sacramento | California | 6067 | 187297 | 2559 |
2080086 | 2080086 | 2022-01-04 | Sacramento | California | 6067 | 186018 | 2552 |
2076834 | 2076834 | 2022-01-03 | Sacramento | California | 6067 | 179927 | 2547 |
2073583 | 2073583 | 2022-01-02 | Sacramento | California | 6067 | 179588 | 2547 |
2070332 | 2070332 | 2022-01-01 | Sacramento | California | 6067 | 179588 | 2547 |
2067081 | 2067081 | 2021-12-31 | Sacramento | California | 6067 | 179588 | 2547 |
2063830 | 2063830 | 2021-12-30 | Sacramento | California | 6067 | 178171 | 2547 |
2060580 | 2060580 | 2021-12-29 | Sacramento | California | 6067 | 176798 | 2533 |
2057331 | 2057331 | 2021-12-28 | Sacramento | California | 6067 | 176366 | 2527 |
2054082 | 2054082 | 2021-12-27 | Sacramento | California | 6067 | 174652 | 2516 |
2050832 | 2050832 | 2021-12-26 | Sacramento | California | 6067 | 174652 | 2512 |
2047582 | 2047582 | 2021-12-25 | Sacramento | California | 6067 | 174652 | 2512 |
2044332 | 2044332 | 2021-12-24 | Sacramento | California | 6067 | 174652 | 2512 |
2041083 | 2041083 | 2021-12-23 | Sacramento | California | 6067 | 174203 | 2512 |
2037833 | 2037833 | 2021-12-22 | Sacramento | California | 6067 | 173836 | 2512 |
2034583 | 2034583 | 2021-12-21 | Sacramento | California | 6067 | 173567 | 2511 |
2031333 | 2031333 | 2021-12-20 | Sacramento | California | 6067 | 173347 | 2509 |
2028082 | 2028082 | 2021-12-19 | Sacramento | California | 6067 | 172460 | 2505 |
2024831 | 2024831 | 2021-12-18 | Sacramento | California | 6067 | 172460 | 2505 |
2021580 | 2021580 | 2021-12-17 | Sacramento | California | 6067 | 172460 | 2505 |
2018329 | 2018329 | 2021-12-16 | Sacramento | California | 6067 | 172207 | 2500 |
2015079 | 2015079 | 2021-12-15 | Sacramento | California | 6067 | 171911 | 2493 |
2011828 | 2011828 | 2021-12-14 | Sacramento | California | 6067 | 171745 | 2490 |
2008577 | 2008577 | 2021-12-13 | Sacramento | California | 6067 | 171597 | 2483 |
2005326 | 2005326 | 2021-12-12 | Sacramento | California | 6067 | 170836 | 2479 |
2002075 | 2002075 | 2021-12-11 | Sacramento | California | 6067 | 170836 | 2479 |
1998825 | 1998825 | 2021-12-10 | Sacramento | California | 6067 | 170836 | 2479 |
1995574 | 1995574 | 2021-12-09 | Sacramento | California | 6067 | 170584 | 2479 |
1992323 | 1992323 | 2021-12-08 | Sacramento | California | 6067 | 170342 | 2467 |
1989072 | 1989072 | 2021-12-07 | Sacramento | California | 6067 | 170120 | 2462 |
1985822 | 1985822 | 2021-12-06 | Sacramento | California | 6067 | 169915 | 2460 |
1982572 | 1982572 | 2021-12-05 | Sacramento | California | 6067 | 169094 | 2452 |
1979322 | 1979322 | 2021-12-04 | Sacramento | California | 6067 | 169094 | 2452 |
1976072 | 1976072 | 2021-12-03 | Sacramento | California | 6067 | 169094 | 2452 |
1972823 | 1972823 | 2021-12-02 | Sacramento | California | 6067 | 168810 | 2452 |
1969573 | 1969573 | 2021-12-01 | Sacramento | California | 6067 | 168491 | 2447 |
1966323 | 1966323 | 2021-11-30 | Sacramento | California | 6067 | 168353 | 2443 |
1963071 | 1963071 | 2021-11-29 | Sacramento | California | 6067 | 168241 | 2428 |
1959820 | 1959820 | 2021-11-28 | Sacramento | California | 6067 | 167399 | 2423 |
1956569 | 1956569 | 2021-11-27 | Sacramento | California | 6067 | 167399 | 2423 |
1953318 | 1953318 | 2021-11-26 | Sacramento | California | 6067 | 167399 | 2423 |
1950067 | 1950067 | 2021-11-25 | Sacramento | California | 6067 | 167399 | 2423 |
1946816 | 1946816 | 2021-11-24 | Sacramento | California | 6067 | 167399 | 2423 |
1943565 | 1943565 | 2021-11-23 | Sacramento | California | 6067 | 167293 | 2422 |
1940315 | 1940315 | 2021-11-22 | Sacramento | California | 6067 | 167158 | 2415 |
1937065 | 1937065 | 2021-11-21 | Sacramento | California | 6067 | 166604 | 2409 |
1933815 | 1933815 | 2021-11-20 | Sacramento | California | 6067 | 166604 | 2409 |
1930563 | 1930563 | 2021-11-19 | Sacramento | California | 6067 | 166604 | 2409 |
1927313 | 1927313 | 2021-11-18 | Sacramento | California | 6067 | 166340 | 2405 |
1924063 | 1924063 | 2021-11-17 | Sacramento | California | 6067 | 166100 | 2394 |
1920814 | 1920814 | 2021-11-16 | Sacramento | California | 6067 | 165935 | 2388 |
1917564 | 1917564 | 2021-11-15 | Sacramento | California | 6067 | 165759 | 2382 |
1914314 | 1914314 | 2021-11-14 | Sacramento | California | 6067 | 165395 | 2379 |
1911064 | 1911064 | 2021-11-13 | Sacramento | California | 6067 | 165395 | 2379 |
1907815 | 1907815 | 2021-11-12 | Sacramento | California | 6067 | 164960 | 2379 |
1904566 | 1904566 | 2021-11-11 | Sacramento | California | 6067 | 164960 | 2376 |
1901316 | 1901316 | 2021-11-10 | Sacramento | California | 6067 | 164734 | 2376 |
1898066 | 1898066 | 2021-11-09 | Sacramento | California | 6067 | 164613 | 2373 |
1894816 | 1894816 | 2021-11-08 | Sacramento | California | 6067 | 164427 | 2364 |
1891566 | 1891566 | 2021-11-07 | Sacramento | California | 6067 | 163644 | 2359 |
1888316 | 1888316 | 2021-11-06 | Sacramento | California | 6067 | 163644 | 2359 |
1885066 | 1885066 | 2021-11-05 | Sacramento | California | 6067 | 163644 | 2359 |
1881817 | 1881817 | 2021-11-04 | Sacramento | California | 6067 | 163189 | 2357 |
1878568 | 1878568 | 2021-11-03 | Sacramento | California | 6067 | 162808 | 2348 |
1875319 | 1875319 | 2021-11-02 | Sacramento | California | 6067 | 162589 | 2343 |
1872070 | 1872070 | 2021-11-01 | Sacramento | California | 6067 | 162363 | 2333 |
1868821 | 1868821 | 2021-10-31 | Sacramento | California | 6067 | 161821 | 2326 |
1865572 | 1865572 | 2021-10-30 | Sacramento | California | 6067 | 161821 | 2326 |
1862323 | 1862323 | 2021-10-29 | Sacramento | California | 6067 | 161821 | 2326 |
1859074 | 1859074 | 2021-10-28 | Sacramento | California | 6067 | 161526 | 2326 |
1855825 | 1855825 | 2021-10-27 | Sacramento | California | 6067 | 161153 | 2323 |
1852576 | 1852576 | 2021-10-26 | Sacramento | California | 6067 | 161026 | 2322 |
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);