ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Stanislaus" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810353 | 1810353 | 2021-10-13 | Stanislaus | California | 6099 | 84709 | 1302 |
1807104 | 1807104 | 2021-10-12 | Stanislaus | California | 6099 | 84566 | 1302 |
1803853 | 1803853 | 2021-10-11 | Stanislaus | California | 6099 | 84433 | 1302 |
1800604 | 1800604 | 2021-10-10 | Stanislaus | California | 6099 | 84010 | 1301 |
1797355 | 1797355 | 2021-10-09 | Stanislaus | California | 6099 | 84010 | 1301 |
1794106 | 1794106 | 2021-10-08 | Stanislaus | California | 6099 | 84010 | 1301 |
1790858 | 1790858 | 2021-10-07 | Stanislaus | California | 6099 | 83774 | 1297 |
1787609 | 1787609 | 2021-10-06 | Stanislaus | California | 6099 | 83513 | 1296 |
1784360 | 1784360 | 2021-10-05 | Stanislaus | California | 6099 | 83400 | 1289 |
1781111 | 1781111 | 2021-10-04 | Stanislaus | California | 6099 | 82812 | 1284 |
1777861 | 1777861 | 2021-10-03 | Stanislaus | California | 6099 | 82812 | 1284 |
1774611 | 1774611 | 2021-10-02 | Stanislaus | California | 6099 | 82812 | 1284 |
1771361 | 1771361 | 2021-10-01 | Stanislaus | California | 6099 | 82812 | 1284 |
1768112 | 1768112 | 2021-09-30 | Stanislaus | California | 6099 | 82575 | 1283 |
1764863 | 1764863 | 2021-09-29 | Stanislaus | California | 6099 | 82346 | 1272 |
1761614 | 1761614 | 2021-09-28 | Stanislaus | California | 6099 | 82221 | 1264 |
1758366 | 1758366 | 2021-09-27 | Stanislaus | California | 6099 | 82039 | 1262 |
1755118 | 1755118 | 2021-09-26 | Stanislaus | California | 6099 | 81477 | 1256 |
1751870 | 1751870 | 2021-09-25 | Stanislaus | California | 6099 | 81477 | 1256 |
1748621 | 1748621 | 2021-09-24 | Stanislaus | California | 6099 | 81477 | 1256 |
1745371 | 1745371 | 2021-09-23 | Stanislaus | California | 6099 | 81209 | 1250 |
1742122 | 1742122 | 2021-09-22 | Stanislaus | California | 6099 | 81056 | 1243 |
1738873 | 1738873 | 2021-09-21 | Stanislaus | California | 6099 | 80892 | 1235 |
1735624 | 1735624 | 2021-09-20 | Stanislaus | California | 6099 | 80699 | 1234 |
1732374 | 1732374 | 2021-09-19 | Stanislaus | California | 6099 | 80034 | 1229 |
1729124 | 1729124 | 2021-09-18 | Stanislaus | California | 6099 | 80034 | 1229 |
1725874 | 1725874 | 2021-09-17 | Stanislaus | California | 6099 | 80034 | 1229 |
1722625 | 1722625 | 2021-09-16 | Stanislaus | California | 6099 | 79718 | 1222 |
1719376 | 1719376 | 2021-09-15 | Stanislaus | California | 6099 | 79420 | 1210 |
1716128 | 1716128 | 2021-09-14 | Stanislaus | California | 6099 | 79230 | 1197 |
1712882 | 1712882 | 2021-09-13 | Stanislaus | California | 6099 | 78924 | 1196 |
1709635 | 1709635 | 2021-09-12 | Stanislaus | California | 6099 | 78021 | 1194 |
1706388 | 1706388 | 2021-09-11 | Stanislaus | California | 6099 | 78021 | 1194 |
1703140 | 1703140 | 2021-09-10 | Stanislaus | California | 6099 | 78021 | 1194 |
1699890 | 1699890 | 2021-09-09 | Stanislaus | California | 6099 | 77553 | 1192 |
1696641 | 1696641 | 2021-09-08 | Stanislaus | California | 6099 | 77295 | 1185 |
1693393 | 1693393 | 2021-09-07 | Stanislaus | California | 6099 | 77144 | 1173 |
1690144 | 1690144 | 2021-09-06 | Stanislaus | California | 6099 | 76095 | 1168 |
1686894 | 1686894 | 2021-09-05 | Stanislaus | California | 6099 | 76095 | 1168 |
1683644 | 1683644 | 2021-09-04 | Stanislaus | California | 6099 | 76095 | 1168 |
1680393 | 1680393 | 2021-09-03 | Stanislaus | California | 6099 | 76095 | 1168 |
1677145 | 1677145 | 2021-09-02 | Stanislaus | California | 6099 | 75735 | 1159 |
1673898 | 1673898 | 2021-09-01 | Stanislaus | California | 6099 | 75389 | 1150 |
1670650 | 1670650 | 2021-08-31 | Stanislaus | California | 6099 | 75063 | 1142 |
1667403 | 1667403 | 2021-08-30 | Stanislaus | California | 6099 | 74163 | 1139 |
1664156 | 1664156 | 2021-08-29 | Stanislaus | California | 6099 | 73056 | 1133 |
1660908 | 1660908 | 2021-08-28 | Stanislaus | California | 6099 | 73056 | 1133 |
1657660 | 1657660 | 2021-08-27 | Stanislaus | California | 6099 | 73056 | 1133 |
1654412 | 1654412 | 2021-08-26 | Stanislaus | California | 6099 | 72577 | 1129 |
1651165 | 1651165 | 2021-08-25 | Stanislaus | California | 6099 | 72186 | 1125 |
1647916 | 1647916 | 2021-08-24 | Stanislaus | California | 6099 | 71893 | 1120 |
1644668 | 1644668 | 2021-08-23 | Stanislaus | California | 6099 | 71574 | 1118 |
1641418 | 1641418 | 2021-08-22 | Stanislaus | California | 6099 | 70854 | 1117 |
1638168 | 1638168 | 2021-08-21 | Stanislaus | California | 6099 | 70854 | 1117 |
1634918 | 1634918 | 2021-08-20 | Stanislaus | California | 6099 | 70854 | 1117 |
1631669 | 1631669 | 2021-08-19 | Stanislaus | California | 6099 | 70547 | 1116 |
1628422 | 1628422 | 2021-08-18 | Stanislaus | California | 6099 | 70193 | 1112 |
1625175 | 1625175 | 2021-08-17 | Stanislaus | California | 6099 | 69910 | 1109 |
1621928 | 1621928 | 2021-08-16 | Stanislaus | California | 6099 | 69545 | 1108 |
1618681 | 1618681 | 2021-08-15 | Stanislaus | California | 6099 | 68731 | 1106 |
1615433 | 1615433 | 2021-08-14 | Stanislaus | California | 6099 | 68731 | 1106 |
1612184 | 1612184 | 2021-08-13 | Stanislaus | California | 6099 | 68731 | 1106 |
1608936 | 1608936 | 2021-08-12 | Stanislaus | California | 6099 | 68390 | 1105 |
1605687 | 1605687 | 2021-08-11 | Stanislaus | California | 6099 | 68119 | 1102 |
1602438 | 1602438 | 2021-08-10 | Stanislaus | California | 6099 | 67889 | 1100 |
1599189 | 1599189 | 2021-08-09 | Stanislaus | California | 6099 | 67693 | 1100 |
1595940 | 1595940 | 2021-08-08 | Stanislaus | California | 6099 | 67115 | 1099 |
1592691 | 1592691 | 2021-08-07 | Stanislaus | California | 6099 | 67115 | 1099 |
1589442 | 1589442 | 2021-08-06 | Stanislaus | California | 6099 | 67115 | 1099 |
1586193 | 1586193 | 2021-08-05 | Stanislaus | California | 6099 | 66922 | 1098 |
1582943 | 1582943 | 2021-08-04 | Stanislaus | California | 6099 | 66619 | 1097 |
1579693 | 1579693 | 2021-08-03 | Stanislaus | California | 6099 | 66476 | 1097 |
1576445 | 1576445 | 2021-08-02 | Stanislaus | California | 6099 | 66321 | 1097 |
1573197 | 1573197 | 2021-08-01 | Stanislaus | California | 6099 | 65893 | 1095 |
1569949 | 1569949 | 2021-07-31 | Stanislaus | California | 6099 | 65893 | 1095 |
1566701 | 1566701 | 2021-07-30 | Stanislaus | California | 6099 | 65893 | 1095 |
1563453 | 1563453 | 2021-07-29 | Stanislaus | California | 6099 | 65537 | 1088 |
1560205 | 1560205 | 2021-07-28 | Stanislaus | California | 6099 | 65537 | 1088 |
1556958 | 1556958 | 2021-07-27 | Stanislaus | California | 6099 | 65440 | 1085 |
1553711 | 1553711 | 2021-07-26 | Stanislaus | California | 6099 | 65304 | 1085 |
1550464 | 1550464 | 2021-07-25 | Stanislaus | California | 6099 | 65019 | 1085 |
1547217 | 1547217 | 2021-07-24 | Stanislaus | California | 6099 | 65019 | 1085 |
1543970 | 1543970 | 2021-07-23 | Stanislaus | California | 6099 | 65019 | 1085 |
1540722 | 1540722 | 2021-07-22 | Stanislaus | California | 6099 | 64912 | 1084 |
1537475 | 1537475 | 2021-07-21 | Stanislaus | California | 6099 | 64792 | 1083 |
1534227 | 1534227 | 2021-07-20 | Stanislaus | California | 6099 | 64712 | 1082 |
1530980 | 1530980 | 2021-07-19 | Stanislaus | California | 6099 | 64634 | 1082 |
1527733 | 1527733 | 2021-07-18 | Stanislaus | California | 6099 | 64381 | 1082 |
1524486 | 1524486 | 2021-07-17 | Stanislaus | California | 6099 | 64381 | 1082 |
1521238 | 1521238 | 2021-07-16 | Stanislaus | California | 6099 | 64381 | 1082 |
1517990 | 1517990 | 2021-07-15 | Stanislaus | California | 6099 | 64283 | 1080 |
1514743 | 1514743 | 2021-07-14 | Stanislaus | California | 6099 | 64204 | 1080 |
1511497 | 1511497 | 2021-07-13 | Stanislaus | California | 6099 | 64139 | 1079 |
1508250 | 1508250 | 2021-07-12 | Stanislaus | California | 6099 | 64091 | 1078 |
1505004 | 1505004 | 2021-07-11 | Stanislaus | California | 6099 | 63973 | 1078 |
1501758 | 1501758 | 2021-07-10 | Stanislaus | California | 6099 | 63973 | 1078 |
1498512 | 1498512 | 2021-07-09 | Stanislaus | California | 6099 | 63973 | 1078 |
1495265 | 1495265 | 2021-07-08 | Stanislaus | California | 6099 | 63940 | 1077 |
1492018 | 1492018 | 2021-07-07 | Stanislaus | California | 6099 | 63894 | 1077 |
1488771 | 1488771 | 2021-07-06 | Stanislaus | California | 6099 | 63864 | 1077 |
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);