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 |
---|---|---|---|---|---|---|---|
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 |
1784343 | 1784343 | 2021-10-05 | Riverside | California | 6065 | 365551 | 5036 |
1781094 | 1781094 | 2021-10-04 | Riverside | California | 6065 | 365316 | 5017 |
1777844 | 1777844 | 2021-10-03 | Riverside | California | 6065 | 363950 | 5004 |
1774594 | 1774594 | 2021-10-02 | Riverside | California | 6065 | 363950 | 5004 |
1771344 | 1771344 | 2021-10-01 | Riverside | California | 6065 | 363950 | 5004 |
1768095 | 1768095 | 2021-09-30 | Riverside | California | 6065 | 363281 | 4994 |
1764846 | 1764846 | 2021-09-29 | Riverside | California | 6065 | 362691 | 4985 |
1761597 | 1761597 | 2021-09-28 | Riverside | California | 6065 | 362124 | 4973 |
1758349 | 1758349 | 2021-09-27 | Riverside | California | 6065 | 361852 | 4963 |
1755101 | 1755101 | 2021-09-26 | Riverside | California | 6065 | 360058 | 4951 |
1751853 | 1751853 | 2021-09-25 | Riverside | California | 6065 | 360058 | 4951 |
1748604 | 1748604 | 2021-09-24 | Riverside | California | 6065 | 360058 | 4951 |
1745354 | 1745354 | 2021-09-23 | Riverside | California | 6065 | 359541 | 4933 |
1742105 | 1742105 | 2021-09-22 | Riverside | California | 6065 | 358882 | 4933 |
1738856 | 1738856 | 2021-09-21 | Riverside | California | 6065 | 358383 | 4921 |
1735607 | 1735607 | 2021-09-20 | Riverside | California | 6065 | 357988 | 4906 |
1732357 | 1732357 | 2021-09-19 | Riverside | California | 6065 | 357558 | 4896 |
1729107 | 1729107 | 2021-09-18 | Riverside | California | 6065 | 356867 | 4896 |
1725857 | 1725857 | 2021-09-17 | Riverside | California | 6065 | 356192 | 4896 |
1722608 | 1722608 | 2021-09-16 | Riverside | California | 6065 | 355499 | 4890 |
1719359 | 1719359 | 2021-09-15 | Riverside | California | 6065 | 354813 | 4872 |
1716111 | 1716111 | 2021-09-14 | Riverside | California | 6065 | 354155 | 4851 |
1712865 | 1712865 | 2021-09-13 | Riverside | California | 6065 | 353611 | 4837 |
1709618 | 1709618 | 2021-09-12 | Riverside | California | 6065 | 352864 | 4826 |
1706371 | 1706371 | 2021-09-11 | Riverside | California | 6065 | 352267 | 4826 |
1703123 | 1703123 | 2021-09-10 | Riverside | California | 6065 | 351053 | 4826 |
1699873 | 1699873 | 2021-09-09 | Riverside | California | 6065 | 350316 | 4806 |
1696624 | 1696624 | 2021-09-08 | Riverside | California | 6065 | 349575 | 4788 |
1693376 | 1693376 | 2021-09-07 | Riverside | California | 6065 | 349237 | 4771 |
1690127 | 1690127 | 2021-09-06 | Riverside | California | 6065 | 348789 | 4759 |
1686877 | 1686877 | 2021-09-05 | Riverside | California | 6065 | 348143 | 4759 |
1683627 | 1683627 | 2021-09-04 | Riverside | California | 6065 | 347196 | 4759 |
1680376 | 1680376 | 2021-09-03 | Riverside | California | 6065 | 346375 | 4759 |
1677128 | 1677128 | 2021-09-02 | Riverside | California | 6065 | 345573 | 4749 |
1673881 | 1673881 | 2021-09-01 | Riverside | California | 6065 | 344596 | 4738 |
1670633 | 1670633 | 2021-08-31 | Riverside | California | 6065 | 343633 | 4731 |
1667386 | 1667386 | 2021-08-30 | Riverside | California | 6065 | 343027 | 4727 |
1664139 | 1664139 | 2021-08-29 | Riverside | California | 6065 | 342262 | 4727 |
1660891 | 1660891 | 2021-08-28 | Riverside | California | 6065 | 341419 | 4727 |
1657643 | 1657643 | 2021-08-27 | Riverside | California | 6065 | 340526 | 4727 |
1654395 | 1654395 | 2021-08-26 | Riverside | California | 6065 | 339588 | 4719 |
1651148 | 1651148 | 2021-08-25 | Riverside | California | 6065 | 338463 | 4713 |
1647899 | 1647899 | 2021-08-24 | Riverside | California | 6065 | 337493 | 4707 |
1644651 | 1644651 | 2021-08-23 | Riverside | California | 6065 | 336679 | 4701 |
1641401 | 1641401 | 2021-08-22 | Riverside | California | 6065 | 335929 | 4697 |
1638151 | 1638151 | 2021-08-21 | Riverside | California | 6065 | 334915 | 4697 |
1634901 | 1634901 | 2021-08-20 | Riverside | California | 6065 | 333899 | 4697 |
1631652 | 1631652 | 2021-08-19 | Riverside | California | 6065 | 332950 | 4693 |
1628405 | 1628405 | 2021-08-18 | Riverside | California | 6065 | 331619 | 4689 |
1625158 | 1625158 | 2021-08-17 | Riverside | California | 6065 | 330342 | 4686 |
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);