ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where deaths = 6, fips = 6063 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1829828 | 1829828 | 2021-10-19 | Plumas | California | 6063 | 1612 | 6 |
1826579 | 1826579 | 2021-10-18 | Plumas | California | 6063 | 1604 | 6 |
1823330 | 1823330 | 2021-10-17 | Plumas | California | 6063 | 1575 | 6 |
1820081 | 1820081 | 2021-10-16 | Plumas | California | 6063 | 1575 | 6 |
1816832 | 1816832 | 2021-10-15 | Plumas | California | 6063 | 1575 | 6 |
1813584 | 1813584 | 2021-10-14 | Plumas | California | 6063 | 1547 | 6 |
1810335 | 1810335 | 2021-10-13 | Plumas | California | 6063 | 1518 | 6 |
1807086 | 1807086 | 2021-10-12 | Plumas | California | 6063 | 1499 | 6 |
1803835 | 1803835 | 2021-10-11 | Plumas | California | 6063 | 1498 | 6 |
1800586 | 1800586 | 2021-10-10 | Plumas | California | 6063 | 1448 | 6 |
1797337 | 1797337 | 2021-10-09 | Plumas | California | 6063 | 1448 | 6 |
1794088 | 1794088 | 2021-10-08 | Plumas | California | 6063 | 1448 | 6 |
1790840 | 1790840 | 2021-10-07 | Plumas | California | 6063 | 1413 | 6 |
1787591 | 1787591 | 2021-10-06 | Plumas | California | 6063 | 1386 | 6 |
1784342 | 1784342 | 2021-10-05 | Plumas | California | 6063 | 1358 | 6 |
1781093 | 1781093 | 2021-10-04 | Plumas | California | 6063 | 1357 | 6 |
1777843 | 1777843 | 2021-10-03 | Plumas | California | 6063 | 1327 | 6 |
1774593 | 1774593 | 2021-10-02 | Plumas | California | 6063 | 1327 | 6 |
1771343 | 1771343 | 2021-10-01 | Plumas | California | 6063 | 1327 | 6 |
1768094 | 1768094 | 2021-09-30 | Plumas | California | 6063 | 1318 | 6 |
1764845 | 1764845 | 2021-09-29 | Plumas | California | 6063 | 1305 | 6 |
1761596 | 1761596 | 2021-09-28 | Plumas | California | 6063 | 1298 | 6 |
1758348 | 1758348 | 2021-09-27 | Plumas | California | 6063 | 1297 | 6 |
1755100 | 1755100 | 2021-09-26 | Plumas | California | 6063 | 1267 | 6 |
1751852 | 1751852 | 2021-09-25 | Plumas | California | 6063 | 1267 | 6 |
1748603 | 1748603 | 2021-09-24 | Plumas | California | 6063 | 1267 | 6 |
1745353 | 1745353 | 2021-09-23 | Plumas | California | 6063 | 1259 | 6 |
1742104 | 1742104 | 2021-09-22 | Plumas | California | 6063 | 1254 | 6 |
1738855 | 1738855 | 2021-09-21 | Plumas | California | 6063 | 1240 | 6 |
1735606 | 1735606 | 2021-09-20 | Plumas | California | 6063 | 1240 | 6 |
1732356 | 1732356 | 2021-09-19 | Plumas | California | 6063 | 1233 | 6 |
1729106 | 1729106 | 2021-09-18 | Plumas | California | 6063 | 1221 | 6 |
1725856 | 1725856 | 2021-09-17 | Plumas | California | 6063 | 1207 | 6 |
1722607 | 1722607 | 2021-09-16 | Plumas | California | 6063 | 1193 | 6 |
1719358 | 1719358 | 2021-09-15 | Plumas | California | 6063 | 1173 | 6 |
1716110 | 1716110 | 2021-09-14 | Plumas | California | 6063 | 1167 | 6 |
1712864 | 1712864 | 2021-09-13 | Plumas | California | 6063 | 1163 | 6 |
1709617 | 1709617 | 2021-09-12 | Plumas | California | 6063 | 1137 | 6 |
1706370 | 1706370 | 2021-09-11 | Plumas | California | 6063 | 1136 | 6 |
1703122 | 1703122 | 2021-09-10 | Plumas | California | 6063 | 1123 | 6 |
1699872 | 1699872 | 2021-09-09 | Plumas | California | 6063 | 1097 | 6 |
1696623 | 1696623 | 2021-09-08 | Plumas | California | 6063 | 1091 | 6 |
1693375 | 1693375 | 2021-09-07 | Plumas | California | 6063 | 1088 | 6 |
1690126 | 1690126 | 2021-09-06 | Plumas | California | 6063 | 1087 | 6 |
1686876 | 1686876 | 2021-09-05 | Plumas | California | 6063 | 1087 | 6 |
1683626 | 1683626 | 2021-09-04 | Plumas | California | 6063 | 1077 | 6 |
1680375 | 1680375 | 2021-09-03 | Plumas | California | 6063 | 1065 | 6 |
1677127 | 1677127 | 2021-09-02 | Plumas | California | 6063 | 1053 | 6 |
1673880 | 1673880 | 2021-09-01 | Plumas | California | 6063 | 1036 | 6 |
1670632 | 1670632 | 2021-08-31 | Plumas | California | 6063 | 1016 | 6 |
1667385 | 1667385 | 2021-08-30 | Plumas | California | 6063 | 1014 | 6 |
1664138 | 1664138 | 2021-08-29 | Plumas | California | 6063 | 1009 | 6 |
1660890 | 1660890 | 2021-08-28 | Plumas | California | 6063 | 1002 | 6 |
1657642 | 1657642 | 2021-08-27 | Plumas | California | 6063 | 989 | 6 |
1654394 | 1654394 | 2021-08-26 | Plumas | California | 6063 | 980 | 6 |
1651147 | 1651147 | 2021-08-25 | Plumas | California | 6063 | 969 | 6 |
1647898 | 1647898 | 2021-08-24 | Plumas | California | 6063 | 950 | 6 |
1644650 | 1644650 | 2021-08-23 | Plumas | California | 6063 | 939 | 6 |
1641400 | 1641400 | 2021-08-22 | Plumas | California | 6063 | 932 | 6 |
1638150 | 1638150 | 2021-08-21 | Plumas | California | 6063 | 924 | 6 |
1634900 | 1634900 | 2021-08-20 | Plumas | California | 6063 | 912 | 6 |
1631651 | 1631651 | 2021-08-19 | Plumas | California | 6063 | 890 | 6 |
1628404 | 1628404 | 2021-08-18 | Plumas | California | 6063 | 875 | 6 |
1625157 | 1625157 | 2021-08-17 | Plumas | California | 6063 | 866 | 6 |
1621910 | 1621910 | 2021-08-16 | Plumas | California | 6063 | 865 | 6 |
1618663 | 1618663 | 2021-08-15 | Plumas | California | 6063 | 864 | 6 |
1615415 | 1615415 | 2021-08-14 | Plumas | California | 6063 | 857 | 6 |
1612166 | 1612166 | 2021-08-13 | Plumas | California | 6063 | 844 | 6 |
1608918 | 1608918 | 2021-08-12 | Plumas | California | 6063 | 839 | 6 |
1605669 | 1605669 | 2021-08-11 | Plumas | California | 6063 | 831 | 6 |
1602420 | 1602420 | 2021-08-10 | Plumas | California | 6063 | 818 | 6 |
1599171 | 1599171 | 2021-08-09 | Plumas | California | 6063 | 818 | 6 |
1595922 | 1595922 | 2021-08-08 | Plumas | California | 6063 | 816 | 6 |
1592673 | 1592673 | 2021-08-07 | Plumas | California | 6063 | 802 | 6 |
1589424 | 1589424 | 2021-08-06 | Plumas | California | 6063 | 802 | 6 |
1586175 | 1586175 | 2021-08-05 | Plumas | California | 6063 | 799 | 6 |
1582925 | 1582925 | 2021-08-04 | Plumas | California | 6063 | 795 | 6 |
1576427 | 1576427 | 2021-08-02 | Plumas | California | 6063 | 777 | 6 |
1573179 | 1573179 | 2021-08-01 | Plumas | California | 6063 | 765 | 6 |
1569931 | 1569931 | 2021-07-31 | Plumas | California | 6063 | 765 | 6 |
1566683 | 1566683 | 2021-07-30 | Plumas | California | 6063 | 765 | 6 |
1563435 | 1563435 | 2021-07-29 | Plumas | California | 6063 | 770 | 6 |
1560187 | 1560187 | 2021-07-28 | Plumas | California | 6063 | 768 | 6 |
1556940 | 1556940 | 2021-07-27 | Plumas | California | 6063 | 766 | 6 |
1553693 | 1553693 | 2021-07-26 | Plumas | California | 6063 | 766 | 6 |
1550446 | 1550446 | 2021-07-25 | Plumas | California | 6063 | 761 | 6 |
1547199 | 1547199 | 2021-07-24 | Plumas | California | 6063 | 761 | 6 |
1543952 | 1543952 | 2021-07-23 | Plumas | California | 6063 | 761 | 6 |
1540704 | 1540704 | 2021-07-22 | Plumas | California | 6063 | 752 | 6 |
1537457 | 1537457 | 2021-07-21 | Plumas | California | 6063 | 752 | 6 |
1534209 | 1534209 | 2021-07-20 | Plumas | California | 6063 | 746 | 6 |
1530962 | 1530962 | 2021-07-19 | Plumas | California | 6063 | 746 | 6 |
1527715 | 1527715 | 2021-07-18 | Plumas | California | 6063 | 742 | 6 |
1524468 | 1524468 | 2021-07-17 | Plumas | California | 6063 | 742 | 6 |
1521220 | 1521220 | 2021-07-16 | Plumas | California | 6063 | 742 | 6 |
1517972 | 1517972 | 2021-07-15 | Plumas | California | 6063 | 742 | 6 |
1514725 | 1514725 | 2021-07-14 | Plumas | California | 6063 | 742 | 6 |
1511479 | 1511479 | 2021-07-13 | Plumas | California | 6063 | 742 | 6 |
1508232 | 1508232 | 2021-07-12 | Plumas | California | 6063 | 742 | 6 |
1504986 | 1504986 | 2021-07-11 | Plumas | California | 6063 | 742 | 6 |
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);