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 |
---|---|---|---|---|---|---|---|
2174414 | 2174414 | 2022-02-02 | Riverside | California | 6065 | 583105 | 5918 |
2171161 | 2171161 | 2022-02-01 | Riverside | California | 6065 | 581261 | 5910 |
2167908 | 2167908 | 2022-01-31 | Riverside | California | 6065 | 580183 | 5868 |
2164653 | 2164653 | 2022-01-30 | Riverside | California | 6065 | 571216 | 5835 |
2161398 | 2161398 | 2022-01-29 | Riverside | California | 6065 | 571216 | 5835 |
2158142 | 2158142 | 2022-01-28 | Riverside | California | 6065 | 571216 | 5835 |
2154889 | 2154889 | 2022-01-27 | Riverside | California | 6065 | 566883 | 5812 |
2151636 | 2151636 | 2022-01-26 | Riverside | California | 6065 | 562282 | 5787 |
2148384 | 2148384 | 2022-01-25 | Riverside | California | 6065 | 557521 | 5769 |
2145132 | 2145132 | 2022-01-24 | Riverside | California | 6065 | 553832 | 5746 |
2141877 | 2141877 | 2022-01-23 | Riverside | California | 6065 | 535126 | 5730 |
2138622 | 2138622 | 2022-01-22 | Riverside | California | 6065 | 535126 | 5730 |
2135366 | 2135366 | 2022-01-21 | Riverside | California | 6065 | 535126 | 5730 |
2132114 | 2132114 | 2022-01-20 | Riverside | California | 6065 | 525134 | 5706 |
2128861 | 2128861 | 2022-01-19 | Riverside | California | 6065 | 516723 | 5687 |
2125607 | 2125607 | 2022-01-18 | Riverside | California | 6065 | 510767 | 5681 |
2122355 | 2122355 | 2022-01-17 | Riverside | California | 6065 | 504636 | 5671 |
2119103 | 2119103 | 2022-01-16 | Riverside | California | 6065 | 485826 | 5671 |
2115851 | 2115851 | 2022-01-15 | Riverside | California | 6065 | 485826 | 5671 |
2112600 | 2112600 | 2022-01-14 | Riverside | California | 6065 | 485826 | 5671 |
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 |
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);