ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 6113 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174438 | 2174438 | 2022-02-02 | Yolo | California | 6113 | 35910 | 275 |
2171185 | 2171185 | 2022-02-01 | Yolo | California | 6113 | 35828 | 275 |
2167932 | 2167932 | 2022-01-31 | Yolo | California | 6113 | 35696 | 275 |
2164677 | 2164677 | 2022-01-30 | Yolo | California | 6113 | 34776 | 275 |
2161422 | 2161422 | 2022-01-29 | Yolo | California | 6113 | 34776 | 275 |
2158166 | 2158166 | 2022-01-28 | Yolo | California | 6113 | 34776 | 275 |
2154913 | 2154913 | 2022-01-27 | Yolo | California | 6113 | 34566 | 275 |
2151660 | 2151660 | 2022-01-26 | Yolo | California | 6113 | 33998 | 274 |
2148408 | 2148408 | 2022-01-25 | Yolo | California | 6113 | 33801 | 273 |
2145156 | 2145156 | 2022-01-24 | Yolo | California | 6113 | 33229 | 273 |
2141901 | 2141901 | 2022-01-23 | Yolo | California | 6113 | 32382 | 273 |
2138646 | 2138646 | 2022-01-22 | Yolo | California | 6113 | 32382 | 273 |
2135390 | 2135390 | 2022-01-21 | Yolo | California | 6113 | 32382 | 273 |
2132138 | 2132138 | 2022-01-20 | Yolo | California | 6113 | 31713 | 273 |
2128885 | 2128885 | 2022-01-19 | Yolo | California | 6113 | 30735 | 270 |
2125631 | 2125631 | 2022-01-18 | Yolo | California | 6113 | 30587 | 270 |
2122379 | 2122379 | 2022-01-17 | Yolo | California | 6113 | 30430 | 270 |
2119127 | 2119127 | 2022-01-16 | Yolo | California | 6113 | 29260 | 270 |
2115875 | 2115875 | 2022-01-15 | Yolo | California | 6113 | 29260 | 270 |
2112624 | 2112624 | 2022-01-14 | Yolo | California | 6113 | 29260 | 270 |
2109372 | 2109372 | 2022-01-13 | Yolo | California | 6113 | 28837 | 270 |
2106121 | 2106121 | 2022-01-12 | Yolo | California | 6113 | 28128 | 270 |
2102870 | 2102870 | 2022-01-11 | Yolo | California | 6113 | 27711 | 270 |
2099619 | 2099619 | 2022-01-10 | Yolo | California | 6113 | 27278 | 270 |
2096368 | 2096368 | 2022-01-09 | Yolo | California | 6113 | 25652 | 270 |
2093116 | 2093116 | 2022-01-08 | Yolo | California | 6113 | 25652 | 270 |
2089864 | 2089864 | 2022-01-07 | Yolo | California | 6113 | 25652 | 270 |
2086613 | 2086613 | 2022-01-06 | Yolo | California | 6113 | 25047 | 270 |
2083361 | 2083361 | 2022-01-05 | Yolo | California | 6113 | 24391 | 270 |
2080109 | 2080109 | 2022-01-04 | Yolo | California | 6113 | 24016 | 270 |
2076857 | 2076857 | 2022-01-03 | Yolo | California | 6113 | 23200 | 270 |
2073606 | 2073606 | 2022-01-02 | Yolo | California | 6113 | 23200 | 270 |
2070355 | 2070355 | 2022-01-01 | Yolo | California | 6113 | 23200 | 270 |
2067104 | 2067104 | 2021-12-31 | Yolo | California | 6113 | 23200 | 270 |
2063853 | 2063853 | 2021-12-30 | Yolo | California | 6113 | 23017 | 270 |
2060603 | 2060603 | 2021-12-29 | Yolo | California | 6113 | 22696 | 270 |
2057354 | 2057354 | 2021-12-28 | Yolo | California | 6113 | 22676 | 270 |
2054105 | 2054105 | 2021-12-27 | Yolo | California | 6113 | 22460 | 270 |
2050855 | 2050855 | 2021-12-26 | Yolo | California | 6113 | 22460 | 270 |
2047605 | 2047605 | 2021-12-25 | Yolo | California | 6113 | 22460 | 270 |
2044355 | 2044355 | 2021-12-24 | Yolo | California | 6113 | 22460 | 270 |
2041106 | 2041106 | 2021-12-23 | Yolo | California | 6113 | 22388 | 270 |
2037856 | 2037856 | 2021-12-22 | Yolo | California | 6113 | 22270 | 267 |
2034606 | 2034606 | 2021-12-21 | Yolo | California | 6113 | 22229 | 267 |
2031356 | 2031356 | 2021-12-20 | Yolo | California | 6113 | 22213 | 267 |
2028105 | 2028105 | 2021-12-19 | Yolo | California | 6113 | 22119 | 267 |
2024854 | 2024854 | 2021-12-18 | Yolo | California | 6113 | 22119 | 267 |
2021603 | 2021603 | 2021-12-17 | Yolo | California | 6113 | 22119 | 267 |
2018352 | 2018352 | 2021-12-16 | Yolo | California | 6113 | 22075 | 267 |
2015102 | 2015102 | 2021-12-15 | Yolo | California | 6113 | 22040 | 267 |
2011851 | 2011851 | 2021-12-14 | Yolo | California | 6113 | 22012 | 267 |
2008600 | 2008600 | 2021-12-13 | Yolo | California | 6113 | 21991 | 267 |
2005349 | 2005349 | 2021-12-12 | Yolo | California | 6113 | 21914 | 267 |
2002098 | 2002098 | 2021-12-11 | Yolo | California | 6113 | 21914 | 267 |
1998848 | 1998848 | 2021-12-10 | Yolo | California | 6113 | 21914 | 267 |
1995597 | 1995597 | 2021-12-09 | Yolo | California | 6113 | 21881 | 267 |
1992346 | 1992346 | 2021-12-08 | Yolo | California | 6113 | 21840 | 263 |
1989095 | 1989095 | 2021-12-07 | Yolo | California | 6113 | 21828 | 263 |
1985845 | 1985845 | 2021-12-06 | Yolo | California | 6113 | 21792 | 263 |
1982595 | 1982595 | 2021-12-05 | Yolo | California | 6113 | 21722 | 261 |
1979345 | 1979345 | 2021-12-04 | Yolo | California | 6113 | 21722 | 261 |
1976095 | 1976095 | 2021-12-03 | Yolo | California | 6113 | 21722 | 261 |
1972846 | 1972846 | 2021-12-02 | Yolo | California | 6113 | 21673 | 260 |
1969596 | 1969596 | 2021-12-01 | Yolo | California | 6113 | 21590 | 260 |
1966346 | 1966346 | 2021-11-30 | Yolo | California | 6113 | 21558 | 257 |
1963094 | 1963094 | 2021-11-29 | Yolo | California | 6113 | 21547 | 257 |
1959843 | 1959843 | 2021-11-28 | Yolo | California | 6113 | 21451 | 257 |
1956592 | 1956592 | 2021-11-27 | Yolo | California | 6113 | 21451 | 257 |
1953341 | 1953341 | 2021-11-26 | Yolo | California | 6113 | 21451 | 257 |
1950090 | 1950090 | 2021-11-25 | Yolo | California | 6113 | 21451 | 257 |
1946839 | 1946839 | 2021-11-24 | Yolo | California | 6113 | 21451 | 257 |
1943588 | 1943588 | 2021-11-23 | Yolo | California | 6113 | 21441 | 257 |
1940338 | 1940338 | 2021-11-22 | Yolo | California | 6113 | 21423 | 257 |
1937088 | 1937088 | 2021-11-21 | Yolo | California | 6113 | 21353 | 257 |
1933838 | 1933838 | 2021-11-20 | Yolo | California | 6113 | 21353 | 257 |
1930586 | 1930586 | 2021-11-19 | Yolo | California | 6113 | 21353 | 257 |
1927336 | 1927336 | 2021-11-18 | Yolo | California | 6113 | 21314 | 257 |
1924086 | 1924086 | 2021-11-17 | Yolo | California | 6113 | 21276 | 257 |
1920837 | 1920837 | 2021-11-16 | Yolo | California | 6113 | 21264 | 255 |
1917587 | 1917587 | 2021-11-15 | Yolo | California | 6113 | 21239 | 255 |
1914337 | 1914337 | 2021-11-14 | Yolo | California | 6113 | 21208 | 255 |
1911087 | 1911087 | 2021-11-13 | Yolo | California | 6113 | 21208 | 255 |
1907838 | 1907838 | 2021-11-12 | Yolo | California | 6113 | 21145 | 255 |
1904589 | 1904589 | 2021-11-11 | Yolo | California | 6113 | 21145 | 255 |
1901339 | 1901339 | 2021-11-10 | Yolo | California | 6113 | 21093 | 255 |
1898089 | 1898089 | 2021-11-09 | Yolo | California | 6113 | 21078 | 255 |
1894839 | 1894839 | 2021-11-08 | Yolo | California | 6113 | 21061 | 255 |
1891589 | 1891589 | 2021-11-07 | Yolo | California | 6113 | 20989 | 255 |
1888339 | 1888339 | 2021-11-06 | Yolo | California | 6113 | 20989 | 255 |
1885089 | 1885089 | 2021-11-05 | Yolo | California | 6113 | 20989 | 255 |
1881840 | 1881840 | 2021-11-04 | Yolo | California | 6113 | 20920 | 250 |
1878591 | 1878591 | 2021-11-03 | Yolo | California | 6113 | 20877 | 250 |
1875342 | 1875342 | 2021-11-02 | Yolo | California | 6113 | 20849 | 250 |
1872093 | 1872093 | 2021-11-01 | Yolo | California | 6113 | 20803 | 250 |
1868844 | 1868844 | 2021-10-31 | Yolo | California | 6113 | 20709 | 250 |
1865595 | 1865595 | 2021-10-30 | Yolo | California | 6113 | 20709 | 250 |
1862346 | 1862346 | 2021-10-29 | Yolo | California | 6113 | 20709 | 250 |
1859097 | 1859097 | 2021-10-28 | Yolo | California | 6113 | 20658 | 250 |
1855848 | 1855848 | 2021-10-27 | Yolo | California | 6113 | 20607 | 248 |
1852599 | 1852599 | 2021-10-26 | Yolo | California | 6113 | 20574 | 248 |
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);