ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6065 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1621911 | 1621911 | 2021-08-16 | Riverside | California | 6065 | 329701 | 4686 |
1618664 | 1618664 | 2021-08-15 | Riverside | California | 6065 | 328832 | 4685 |
1615416 | 1615416 | 2021-08-14 | Riverside | California | 6065 | 327976 | 4685 |
1612167 | 1612167 | 2021-08-13 | Riverside | California | 6065 | 326872 | 4685 |
1608919 | 1608919 | 2021-08-12 | Riverside | California | 6065 | 325833 | 4679 |
1605670 | 1605670 | 2021-08-11 | Riverside | California | 6065 | 325097 | 4674 |
1602421 | 1602421 | 2021-08-10 | Riverside | California | 6065 | 324246 | 4669 |
1599172 | 1599172 | 2021-08-09 | Riverside | California | 6065 | 323610 | 4667 |
1595923 | 1595923 | 2021-08-08 | Riverside | California | 6065 | 322894 | 4667 |
1592674 | 1592674 | 2021-08-07 | Riverside | California | 6065 | 320983 | 4667 |
1589425 | 1589425 | 2021-08-06 | Riverside | California | 6065 | 320983 | 4667 |
1586176 | 1586176 | 2021-08-05 | Riverside | California | 6065 | 319840 | 4667 |
1582926 | 1582926 | 2021-08-04 | Riverside | California | 6065 | 318968 | 4667 |
1579676 | 1579676 | 2021-08-03 | Riverside | California | 6065 | 318225 | 4667 |
1576428 | 1576428 | 2021-08-02 | Riverside | California | 6065 | 317725 | 4667 |
1573180 | 1573180 | 2021-08-01 | Riverside | California | 6065 | 315784 | 4662 |
1569932 | 1569932 | 2021-07-31 | Riverside | California | 6065 | 315784 | 4662 |
1566684 | 1566684 | 2021-07-30 | Riverside | California | 6065 | 315784 | 4662 |
1563436 | 1563436 | 2021-07-29 | Riverside | California | 6065 | 315080 | 4659 |
1560188 | 1560188 | 2021-07-28 | Riverside | California | 6065 | 314486 | 4659 |
1556941 | 1556941 | 2021-07-27 | Riverside | California | 6065 | 313952 | 4659 |
1553694 | 1553694 | 2021-07-26 | Riverside | California | 6065 | 313507 | 4658 |
1550447 | 1550447 | 2021-07-25 | Riverside | California | 6065 | 312238 | 4658 |
1547200 | 1547200 | 2021-07-24 | Riverside | California | 6065 | 312238 | 4658 |
1543953 | 1543953 | 2021-07-23 | Riverside | California | 6065 | 312238 | 4658 |
1540705 | 1540705 | 2021-07-22 | Riverside | California | 6065 | 311745 | 4657 |
1537458 | 1537458 | 2021-07-21 | Riverside | California | 6065 | 311190 | 4657 |
1534210 | 1534210 | 2021-07-20 | Riverside | California | 6065 | 310808 | 4647 |
1530963 | 1530963 | 2021-07-19 | Riverside | California | 6065 | 310594 | 4647 |
1527716 | 1527716 | 2021-07-18 | Riverside | California | 6065 | 309823 | 4647 |
1524469 | 1524469 | 2021-07-17 | Riverside | California | 6065 | 309823 | 4647 |
1521221 | 1521221 | 2021-07-16 | Riverside | California | 6065 | 309823 | 4647 |
1517973 | 1517973 | 2021-07-15 | Riverside | California | 6065 | 309583 | 4647 |
1514726 | 1514726 | 2021-07-14 | Riverside | California | 6065 | 309374 | 4647 |
1511480 | 1511480 | 2021-07-13 | Riverside | California | 6065 | 309180 | 4648 |
1508233 | 1508233 | 2021-07-12 | Riverside | California | 6065 | 309041 | 4648 |
1504987 | 1504987 | 2021-07-11 | Riverside | California | 6065 | 308546 | 4648 |
1501741 | 1501741 | 2021-07-10 | Riverside | California | 6065 | 308546 | 4648 |
1498495 | 1498495 | 2021-07-09 | Riverside | California | 6065 | 308546 | 4648 |
1495248 | 1495248 | 2021-07-08 | Riverside | California | 6065 | 308403 | 4648 |
1492001 | 1492001 | 2021-07-07 | Riverside | California | 6065 | 303062 | 4648 |
1488754 | 1488754 | 2021-07-06 | Riverside | California | 6065 | 301820 | 4640 |
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);