ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Riverside" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109348 | 2109348 | 2022-01-13 | Riverside | California | 6065 | 478326 | 5661 |
2106097 | 2106097 | 2022-01-12 | Riverside | California | 6065 | 472262 | 5648 |
2102846 | 2102846 | 2022-01-11 | Riverside | California | 6065 | 464032 | 5635 |
2099595 | 2099595 | 2022-01-10 | Riverside | California | 6065 | 458909 | 5631 |
2096344 | 2096344 | 2022-01-09 | Riverside | California | 6065 | 441087 | 5631 |
2093092 | 2093092 | 2022-01-08 | Riverside | California | 6065 | 441087 | 5631 |
2089840 | 2089840 | 2022-01-07 | Riverside | California | 6065 | 441087 | 5631 |
2086589 | 2086589 | 2022-01-06 | Riverside | California | 6065 | 433749 | 5620 |
2083337 | 2083337 | 2022-01-05 | Riverside | California | 6065 | 431266 | 5608 |
2080085 | 2080085 | 2022-01-04 | Riverside | California | 6065 | 428055 | 5589 |
2076833 | 2076833 | 2022-01-03 | Riverside | California | 6065 | 415024 | 5589 |
2073582 | 2073582 | 2022-01-02 | Riverside | California | 6065 | 415024 | 5585 |
2070331 | 2070331 | 2022-01-01 | Riverside | California | 6065 | 415024 | 5585 |
2067080 | 2067080 | 2021-12-31 | Riverside | California | 6065 | 415024 | 5585 |
2063829 | 2063829 | 2021-12-30 | Riverside | California | 6065 | 410889 | 5585 |
2060579 | 2060579 | 2021-12-29 | Riverside | California | 6065 | 408062 | 5572 |
2057330 | 2057330 | 2021-12-28 | Riverside | California | 6065 | 406815 | 5555 |
2054081 | 2054081 | 2021-12-27 | Riverside | California | 6065 | 402286 | 5554 |
2050831 | 2050831 | 2021-12-26 | Riverside | California | 6065 | 402286 | 5554 |
2047581 | 2047581 | 2021-12-25 | Riverside | California | 6065 | 402286 | 5554 |
2044331 | 2044331 | 2021-12-24 | Riverside | California | 6065 | 402286 | 5554 |
2041082 | 2041082 | 2021-12-23 | Riverside | California | 6065 | 401038 | 5554 |
2037832 | 2037832 | 2021-12-22 | Riverside | California | 6065 | 400070 | 5554 |
2034582 | 2034582 | 2021-12-21 | Riverside | California | 6065 | 399496 | 5549 |
2031332 | 2031332 | 2021-12-20 | Riverside | California | 6065 | 398960 | 5536 |
2028081 | 2028081 | 2021-12-19 | Riverside | California | 6065 | 397009 | 5529 |
2024830 | 2024830 | 2021-12-18 | Riverside | California | 6065 | 397009 | 5529 |
2021579 | 2021579 | 2021-12-17 | Riverside | California | 6065 | 397009 | 5529 |
2018328 | 2018328 | 2021-12-16 | Riverside | California | 6065 | 396424 | 5523 |
2015078 | 2015078 | 2021-12-15 | Riverside | California | 6065 | 395773 | 5523 |
2011827 | 2011827 | 2021-12-14 | Riverside | California | 6065 | 395274 | 5514 |
2008576 | 2008576 | 2021-12-13 | Riverside | California | 6065 | 395013 | 5502 |
2005325 | 2005325 | 2021-12-12 | Riverside | California | 6065 | 393195 | 5502 |
2002074 | 2002074 | 2021-12-11 | Riverside | California | 6065 | 393195 | 5502 |
1998824 | 1998824 | 2021-12-10 | Riverside | California | 6065 | 393195 | 5502 |
1995573 | 1995573 | 2021-12-09 | Riverside | California | 6065 | 392645 | 5496 |
1992322 | 1992322 | 2021-12-08 | Riverside | California | 6065 | 392020 | 5492 |
1989071 | 1989071 | 2021-12-07 | Riverside | California | 6065 | 391584 | 5484 |
1985821 | 1985821 | 2021-12-06 | Riverside | California | 6065 | 391295 | 5475 |
1982571 | 1982571 | 2021-12-05 | Riverside | California | 6065 | 389236 | 5476 |
1979321 | 1979321 | 2021-12-04 | Riverside | California | 6065 | 389236 | 5476 |
1976071 | 1976071 | 2021-12-03 | Riverside | California | 6065 | 389236 | 5476 |
1972822 | 1972822 | 2021-12-02 | Riverside | California | 6065 | 388657 | 5470 |
1969572 | 1969572 | 2021-12-01 | Riverside | California | 6065 | 388083 | 5458 |
1966322 | 1966322 | 2021-11-30 | Riverside | California | 6065 | 387678 | 5447 |
1963070 | 1963070 | 2021-11-29 | Riverside | California | 6065 | 387395 | 5447 |
1959819 | 1959819 | 2021-11-28 | Riverside | California | 6065 | 384945 | 5423 |
1956568 | 1956568 | 2021-11-27 | Riverside | California | 6065 | 384945 | 5423 |
1953317 | 1953317 | 2021-11-26 | Riverside | California | 6065 | 384945 | 5423 |
1950066 | 1950066 | 2021-11-25 | Riverside | California | 6065 | 384945 | 5423 |
1946815 | 1946815 | 2021-11-24 | Riverside | California | 6065 | 384945 | 5423 |
1943564 | 1943564 | 2021-11-23 | Riverside | California | 6065 | 384645 | 5395 |
1940314 | 1940314 | 2021-11-22 | Riverside | California | 6065 | 384437 | 5372 |
1937064 | 1937064 | 2021-11-21 | Riverside | California | 6065 | 383153 | 5372 |
1933814 | 1933814 | 2021-11-20 | Riverside | California | 6065 | 383153 | 5372 |
1930562 | 1930562 | 2021-11-19 | Riverside | California | 6065 | 383153 | 5372 |
1927312 | 1927312 | 2021-11-18 | Riverside | California | 6065 | 382750 | 5353 |
1924062 | 1924062 | 2021-11-17 | Riverside | California | 6065 | 382329 | 5315 |
1920813 | 1920813 | 2021-11-16 | Riverside | California | 6065 | 382001 | 5295 |
1917563 | 1917563 | 2021-11-15 | Riverside | California | 6065 | 381741 | 5286 |
1914313 | 1914313 | 2021-11-14 | Riverside | California | 6065 | 381052 | 5274 |
1911063 | 1911063 | 2021-11-13 | Riverside | California | 6065 | 381052 | 5274 |
1907814 | 1907814 | 2021-11-12 | Riverside | California | 6065 | 380181 | 5274 |
1904565 | 1904565 | 2021-11-11 | Riverside | California | 6065 | 380181 | 5262 |
1901315 | 1901315 | 2021-11-10 | Riverside | California | 6065 | 379716 | 5262 |
1898065 | 1898065 | 2021-11-09 | Riverside | California | 6065 | 379360 | 5247 |
1894815 | 1894815 | 2021-11-08 | Riverside | California | 6065 | 379119 | 5240 |
1891565 | 1891565 | 2021-11-07 | Riverside | California | 6065 | 377743 | 5240 |
1888315 | 1888315 | 2021-11-06 | Riverside | California | 6065 | 377743 | 5240 |
1885065 | 1885065 | 2021-11-05 | Riverside | California | 6065 | 377743 | 5240 |
1881816 | 1881816 | 2021-11-04 | Riverside | California | 6065 | 377219 | 5226 |
1878567 | 1878567 | 2021-11-03 | Riverside | California | 6065 | 376653 | 5219 |
1875318 | 1875318 | 2021-11-02 | Riverside | California | 6065 | 376330 | 5204 |
1872069 | 1872069 | 2021-11-01 | Riverside | California | 6065 | 376072 | 5204 |
1868820 | 1868820 | 2021-10-31 | Riverside | California | 6065 | 374712 | 5194 |
1865571 | 1865571 | 2021-10-30 | Riverside | California | 6065 | 374712 | 5194 |
1862322 | 1862322 | 2021-10-29 | Riverside | California | 6065 | 374712 | 5194 |
1859073 | 1859073 | 2021-10-28 | Riverside | California | 6065 | 374219 | 5177 |
1855824 | 1855824 | 2021-10-27 | Riverside | California | 6065 | 373757 | 5168 |
1852575 | 1852575 | 2021-10-26 | Riverside | California | 6065 | 373363 | 5156 |
1849326 | 1849326 | 2021-10-25 | Riverside | California | 6065 | 371670 | 5144 |
1846076 | 1846076 | 2021-10-24 | Riverside | California | 6065 | 371670 | 5134 |
1842826 | 1842826 | 2021-10-23 | Riverside | California | 6065 | 371670 | 5134 |
1839576 | 1839576 | 2021-10-22 | Riverside | California | 6065 | 371670 | 5134 |
1836327 | 1836327 | 2021-10-21 | Riverside | California | 6065 | 371293 | 5129 |
1833078 | 1833078 | 2021-10-20 | Riverside | California | 6065 | 370800 | 5118 |
1829829 | 1829829 | 2021-10-19 | Riverside | California | 6065 | 370608 | 5108 |
1826580 | 1826580 | 2021-10-18 | Riverside | California | 6065 | 370409 | 5096 |
1823331 | 1823331 | 2021-10-17 | Riverside | California | 6065 | 369344 | 5092 |
1820082 | 1820082 | 2021-10-16 | Riverside | California | 6065 | 369344 | 5092 |
1816833 | 1816833 | 2021-10-15 | Riverside | California | 6065 | 369344 | 5092 |
1813585 | 1813585 | 2021-10-14 | Riverside | California | 6065 | 368953 | 5080 |
1810336 | 1810336 | 2021-10-13 | Riverside | California | 6065 | 368590 | 5068 |
1807087 | 1807087 | 2021-10-12 | Riverside | California | 6065 | 368263 | 5063 |
1803836 | 1803836 | 2021-10-11 | Riverside | California | 6065 | 368067 | 5063 |
1800587 | 1800587 | 2021-10-10 | Riverside | California | 6065 | 366901 | 5063 |
1797338 | 1797338 | 2021-10-09 | Riverside | California | 6065 | 366901 | 5063 |
1794089 | 1794089 | 2021-10-08 | Riverside | California | 6065 | 366901 | 5063 |
1790841 | 1790841 | 2021-10-07 | Riverside | California | 6065 | 366464 | 5055 |
1787592 | 1787592 | 2021-10-06 | Riverside | California | 6065 | 366088 | 5047 |
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);