ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 6079 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174421 | 2174421 | 2022-02-02 | San Luis Obispo | California | 6079 | 51106 | 403 |
2171168 | 2171168 | 2022-02-01 | San Luis Obispo | California | 6079 | 50920 | 395 |
2167915 | 2167915 | 2022-01-31 | San Luis Obispo | California | 6079 | 50863 | 394 |
2164660 | 2164660 | 2022-01-30 | San Luis Obispo | California | 6079 | 49638 | 391 |
2161405 | 2161405 | 2022-01-29 | San Luis Obispo | California | 6079 | 49638 | 391 |
2158149 | 2158149 | 2022-01-28 | San Luis Obispo | California | 6079 | 49638 | 391 |
2154896 | 2154896 | 2022-01-27 | San Luis Obispo | California | 6079 | 48980 | 391 |
2151643 | 2151643 | 2022-01-26 | San Luis Obispo | California | 6079 | 48033 | 391 |
2148391 | 2148391 | 2022-01-25 | San Luis Obispo | California | 6079 | 47519 | 387 |
2145139 | 2145139 | 2022-01-24 | San Luis Obispo | California | 6079 | 47086 | 386 |
2141884 | 2141884 | 2022-01-23 | San Luis Obispo | California | 6079 | 45057 | 385 |
2138629 | 2138629 | 2022-01-22 | San Luis Obispo | California | 6079 | 45057 | 385 |
2135373 | 2135373 | 2022-01-21 | San Luis Obispo | California | 6079 | 45057 | 385 |
2132121 | 2132121 | 2022-01-20 | San Luis Obispo | California | 6079 | 44277 | 382 |
2128868 | 2128868 | 2022-01-19 | San Luis Obispo | California | 6079 | 43050 | 381 |
2125614 | 2125614 | 2022-01-18 | San Luis Obispo | California | 6079 | 42627 | 379 |
2122362 | 2122362 | 2022-01-17 | San Luis Obispo | California | 6079 | 42315 | 379 |
2119110 | 2119110 | 2022-01-16 | San Luis Obispo | California | 6079 | 40433 | 374 |
2115858 | 2115858 | 2022-01-15 | San Luis Obispo | California | 6079 | 40433 | 374 |
2112607 | 2112607 | 2022-01-14 | San Luis Obispo | California | 6079 | 40433 | 374 |
2109355 | 2109355 | 2022-01-13 | San Luis Obispo | California | 6079 | 39929 | 373 |
2106104 | 2106104 | 2022-01-12 | San Luis Obispo | California | 6079 | 38881 | 372 |
2102853 | 2102853 | 2022-01-11 | San Luis Obispo | California | 6079 | 38316 | 371 |
2099602 | 2099602 | 2022-01-10 | San Luis Obispo | California | 6079 | 37989 | 371 |
2096351 | 2096351 | 2022-01-09 | San Luis Obispo | California | 6079 | 36187 | 369 |
2093099 | 2093099 | 2022-01-08 | San Luis Obispo | California | 6079 | 36187 | 369 |
2089847 | 2089847 | 2022-01-07 | San Luis Obispo | California | 6079 | 36187 | 369 |
2086596 | 2086596 | 2022-01-06 | San Luis Obispo | California | 6079 | 35764 | 369 |
2083344 | 2083344 | 2022-01-05 | San Luis Obispo | California | 6079 | 35303 | 371 |
2080092 | 2080092 | 2022-01-04 | San Luis Obispo | California | 6079 | 35182 | 367 |
2076840 | 2076840 | 2022-01-03 | San Luis Obispo | California | 6079 | 33857 | 367 |
2073589 | 2073589 | 2022-01-02 | San Luis Obispo | California | 6079 | 33857 | 367 |
2070338 | 2070338 | 2022-01-01 | San Luis Obispo | California | 6079 | 33857 | 367 |
2067087 | 2067087 | 2021-12-31 | San Luis Obispo | California | 6079 | 33857 | 367 |
2063836 | 2063836 | 2021-12-30 | San Luis Obispo | California | 6079 | 33451 | 367 |
2060586 | 2060586 | 2021-12-29 | San Luis Obispo | California | 6079 | 33201 | 367 |
2057337 | 2057337 | 2021-12-28 | San Luis Obispo | California | 6079 | 33113 | 367 |
2054088 | 2054088 | 2021-12-27 | San Luis Obispo | California | 6079 | 32732 | 367 |
2050838 | 2050838 | 2021-12-26 | San Luis Obispo | California | 6079 | 32732 | 367 |
2047588 | 2047588 | 2021-12-25 | San Luis Obispo | California | 6079 | 32732 | 367 |
2044338 | 2044338 | 2021-12-24 | San Luis Obispo | California | 6079 | 32732 | 367 |
2041089 | 2041089 | 2021-12-23 | San Luis Obispo | California | 6079 | 32617 | 367 |
2037839 | 2037839 | 2021-12-22 | San Luis Obispo | California | 6079 | 32497 | 367 |
2034589 | 2034589 | 2021-12-21 | San Luis Obispo | California | 6079 | 32469 | 367 |
2031339 | 2031339 | 2021-12-20 | San Luis Obispo | California | 6079 | 32429 | 367 |
2028088 | 2028088 | 2021-12-19 | San Luis Obispo | California | 6079 | 32267 | 367 |
2024837 | 2024837 | 2021-12-18 | San Luis Obispo | California | 6079 | 32267 | 367 |
2021586 | 2021586 | 2021-12-17 | San Luis Obispo | California | 6079 | 32267 | 367 |
2018335 | 2018335 | 2021-12-16 | San Luis Obispo | California | 6079 | 32178 | 367 |
2015085 | 2015085 | 2021-12-15 | San Luis Obispo | California | 6079 | 32126 | 367 |
2011834 | 2011834 | 2021-12-14 | San Luis Obispo | California | 6079 | 32119 | 367 |
2008583 | 2008583 | 2021-12-13 | San Luis Obispo | California | 6079 | 32092 | 366 |
2005332 | 2005332 | 2021-12-12 | San Luis Obispo | California | 6079 | 31940 | 366 |
2002081 | 2002081 | 2021-12-11 | San Luis Obispo | California | 6079 | 31940 | 366 |
1998831 | 1998831 | 2021-12-10 | San Luis Obispo | California | 6079 | 31940 | 366 |
1995580 | 1995580 | 2021-12-09 | San Luis Obispo | California | 6079 | 31892 | 365 |
1992329 | 1992329 | 2021-12-08 | San Luis Obispo | California | 6079 | 31844 | 365 |
1989078 | 1989078 | 2021-12-07 | San Luis Obispo | California | 6079 | 31813 | 365 |
1985828 | 1985828 | 2021-12-06 | San Luis Obispo | California | 6079 | 31803 | 365 |
1982578 | 1982578 | 2021-12-05 | San Luis Obispo | California | 6079 | 31667 | 365 |
1979328 | 1979328 | 2021-12-04 | San Luis Obispo | California | 6079 | 31667 | 365 |
1976078 | 1976078 | 2021-12-03 | San Luis Obispo | California | 6079 | 31667 | 365 |
1972829 | 1972829 | 2021-12-02 | San Luis Obispo | California | 6079 | 31587 | 365 |
1969579 | 1969579 | 2021-12-01 | San Luis Obispo | California | 6079 | 31511 | 365 |
1966329 | 1966329 | 2021-11-30 | San Luis Obispo | California | 6079 | 31476 | 365 |
1963077 | 1963077 | 2021-11-29 | San Luis Obispo | California | 6079 | 31463 | 358 |
1959826 | 1959826 | 2021-11-28 | San Luis Obispo | California | 6079 | 31294 | 358 |
1956575 | 1956575 | 2021-11-27 | San Luis Obispo | California | 6079 | 31294 | 358 |
1953324 | 1953324 | 2021-11-26 | San Luis Obispo | California | 6079 | 31294 | 358 |
1950073 | 1950073 | 2021-11-25 | San Luis Obispo | California | 6079 | 31294 | 358 |
1946822 | 1946822 | 2021-11-24 | San Luis Obispo | California | 6079 | 31294 | 358 |
1943571 | 1943571 | 2021-11-23 | San Luis Obispo | California | 6079 | 31274 | 358 |
1940321 | 1940321 | 2021-11-22 | San Luis Obispo | California | 6079 | 31259 | 358 |
1937071 | 1937071 | 2021-11-21 | San Luis Obispo | California | 6079 | 31126 | 358 |
1933821 | 1933821 | 2021-11-20 | San Luis Obispo | California | 6079 | 31126 | 358 |
1930569 | 1930569 | 2021-11-19 | San Luis Obispo | California | 6079 | 31126 | 358 |
1927319 | 1927319 | 2021-11-18 | San Luis Obispo | California | 6079 | 31042 | 358 |
1924069 | 1924069 | 2021-11-17 | San Luis Obispo | California | 6079 | 30992 | 358 |
1920820 | 1920820 | 2021-11-16 | San Luis Obispo | California | 6079 | 30958 | 358 |
1917570 | 1917570 | 2021-11-15 | San Luis Obispo | California | 6079 | 30934 | 352 |
1914320 | 1914320 | 2021-11-14 | San Luis Obispo | California | 6079 | 30878 | 352 |
1911070 | 1911070 | 2021-11-13 | San Luis Obispo | California | 6079 | 30878 | 352 |
1907821 | 1907821 | 2021-11-12 | San Luis Obispo | California | 6079 | 30821 | 352 |
1904572 | 1904572 | 2021-11-11 | San Luis Obispo | California | 6079 | 30821 | 352 |
1901322 | 1901322 | 2021-11-10 | San Luis Obispo | California | 6079 | 30752 | 352 |
1898072 | 1898072 | 2021-11-09 | San Luis Obispo | California | 6079 | 30728 | 352 |
1894822 | 1894822 | 2021-11-08 | San Luis Obispo | California | 6079 | 30718 | 350 |
1891572 | 1891572 | 2021-11-07 | San Luis Obispo | California | 6079 | 30599 | 350 |
1888322 | 1888322 | 2021-11-06 | San Luis Obispo | California | 6079 | 30599 | 350 |
1885072 | 1885072 | 2021-11-05 | San Luis Obispo | California | 6079 | 30599 | 350 |
1881823 | 1881823 | 2021-11-04 | San Luis Obispo | California | 6079 | 30540 | 349 |
1878574 | 1878574 | 2021-11-03 | San Luis Obispo | California | 6079 | 30462 | 349 |
1875325 | 1875325 | 2021-11-02 | San Luis Obispo | California | 6079 | 30437 | 349 |
1872076 | 1872076 | 2021-11-01 | San Luis Obispo | California | 6079 | 30414 | 343 |
1868827 | 1868827 | 2021-10-31 | San Luis Obispo | California | 6079 | 30291 | 343 |
1865578 | 1865578 | 2021-10-30 | San Luis Obispo | California | 6079 | 30291 | 343 |
1862329 | 1862329 | 2021-10-29 | San Luis Obispo | California | 6079 | 30291 | 343 |
1859080 | 1859080 | 2021-10-28 | San Luis Obispo | California | 6079 | 30240 | 341 |
1855831 | 1855831 | 2021-10-27 | San Luis Obispo | California | 6079 | 30146 | 339 |
1852582 | 1852582 | 2021-10-26 | San Luis Obispo | California | 6079 | 30125 | 339 |
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);