ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
813 rows where fips = 6067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1492002 | 1492002 | 2021-07-07 | Sacramento | California | 6067 | 109392 | 1748 |
1488755 | 1488755 | 2021-07-06 | Sacramento | California | 6067 | 109267 | 1746 |
1485508 | 1485508 | 2021-07-05 | Sacramento | California | 6067 | 108827 | 1745 |
1482262 | 1482262 | 2021-07-04 | Sacramento | California | 6067 | 108827 | 1745 |
1479015 | 1479015 | 2021-07-03 | Sacramento | California | 6067 | 108827 | 1745 |
1475769 | 1475769 | 2021-07-02 | Sacramento | California | 6067 | 108827 | 1745 |
1472523 | 1472523 | 2021-07-01 | Sacramento | California | 6067 | 108687 | 1743 |
1469278 | 1469278 | 2021-06-30 | Sacramento | California | 6067 | 108570 | 1743 |
1466033 | 1466033 | 2021-06-29 | Sacramento | California | 6067 | 108504 | 1742 |
1462788 | 1462788 | 2021-06-28 | Sacramento | California | 6067 | 108410 | 1740 |
1459543 | 1459543 | 2021-06-27 | Sacramento | California | 6067 | 108178 | 1738 |
1456298 | 1456298 | 2021-06-26 | Sacramento | California | 6067 | 108084 | 1738 |
1453053 | 1453053 | 2021-06-25 | Sacramento | California | 6067 | 108084 | 1738 |
1449807 | 1449807 | 2021-06-24 | Sacramento | California | 6067 | 108012 | 1738 |
1446562 | 1446562 | 2021-06-23 | Sacramento | California | 6067 | 107912 | 1737 |
1443317 | 1443317 | 2021-06-22 | Sacramento | California | 6067 | 107871 | 1737 |
1440072 | 1440072 | 2021-06-21 | Sacramento | California | 6067 | 107820 | 1736 |
1436825 | 1436825 | 2021-06-20 | Sacramento | California | 6067 | 107637 | 1731 |
1433578 | 1433578 | 2021-06-19 | Sacramento | California | 6067 | 107637 | 1731 |
1430332 | 1430332 | 2021-06-18 | Sacramento | California | 6067 | 107637 | 1731 |
1427087 | 1427087 | 2021-06-17 | Sacramento | California | 6067 | 107559 | 1730 |
1423842 | 1423842 | 2021-06-16 | Sacramento | California | 6067 | 107493 | 1726 |
1420594 | 1420594 | 2021-06-15 | Sacramento | California | 6067 | 107440 | 1725 |
1417349 | 1417349 | 2021-06-14 | Sacramento | California | 6067 | 107394 | 1723 |
1414103 | 1414103 | 2021-06-13 | Sacramento | California | 6067 | 107198 | 1718 |
1410858 | 1410858 | 2021-06-12 | Sacramento | California | 6067 | 107185 | 1718 |
1407613 | 1407613 | 2021-06-11 | Sacramento | California | 6067 | 107185 | 1718 |
1404367 | 1404367 | 2021-06-10 | Sacramento | California | 6067 | 107116 | 1716 |
1401122 | 1401122 | 2021-06-09 | Sacramento | California | 6067 | 107102 | 1716 |
1397877 | 1397877 | 2021-06-08 | Sacramento | California | 6067 | 107029 | 1716 |
1394630 | 1394630 | 2021-06-07 | Sacramento | California | 6067 | 106960 | 1716 |
1391385 | 1391385 | 2021-06-06 | Sacramento | California | 6067 | 106713 | 1716 |
1388140 | 1388140 | 2021-06-05 | Sacramento | California | 6067 | 106713 | 1716 |
1384895 | 1384895 | 2021-06-04 | Sacramento | California | 6067 | 106713 | 1716 |
1381649 | 1381649 | 2021-06-03 | Sacramento | California | 6067 | 106634 | 1715 |
1378404 | 1378404 | 2021-06-02 | Sacramento | California | 6067 | 106569 | 1715 |
1375158 | 1375158 | 2021-06-01 | Sacramento | California | 6067 | 106472 | 1709 |
1371913 | 1371913 | 2021-05-31 | Sacramento | California | 6067 | 106264 | 1707 |
1368668 | 1368668 | 2021-05-30 | Sacramento | California | 6067 | 106264 | 1707 |
1365422 | 1365422 | 2021-05-29 | Sacramento | California | 6067 | 106264 | 1707 |
1362176 | 1362176 | 2021-05-28 | Sacramento | California | 6067 | 106264 | 1707 |
1358929 | 1358929 | 2021-05-27 | Sacramento | California | 6067 | 106152 | 1707 |
1355683 | 1355683 | 2021-05-26 | Sacramento | California | 6067 | 106042 | 1702 |
1352437 | 1352437 | 2021-05-25 | Sacramento | California | 6067 | 105962 | 1700 |
1349191 | 1349191 | 2021-05-24 | Sacramento | California | 6067 | 105844 | 1699 |
1345944 | 1345944 | 2021-05-23 | Sacramento | California | 6067 | 105603 | 1698 |
1342696 | 1342696 | 2021-05-22 | Sacramento | California | 6067 | 105603 | 1698 |
1339448 | 1339448 | 2021-05-21 | Sacramento | California | 6067 | 105603 | 1698 |
1336201 | 1336201 | 2021-05-20 | Sacramento | California | 6067 | 105539 | 1695 |
1332954 | 1332954 | 2021-05-19 | Sacramento | California | 6067 | 105373 | 1693 |
1329707 | 1329707 | 2021-05-18 | Sacramento | California | 6067 | 105233 | 1693 |
1326460 | 1326460 | 2021-05-17 | Sacramento | California | 6067 | 105163 | 1693 |
1323214 | 1323214 | 2021-05-16 | Sacramento | California | 6067 | 104957 | 1691 |
1319968 | 1319968 | 2021-05-15 | Sacramento | California | 6067 | 104957 | 1691 |
1316721 | 1316721 | 2021-05-14 | Sacramento | California | 6067 | 104957 | 1691 |
1313474 | 1313474 | 2021-05-13 | Sacramento | California | 6067 | 104839 | 1686 |
1310227 | 1310227 | 2021-05-12 | Sacramento | California | 6067 | 104719 | 1682 |
1306981 | 1306981 | 2021-05-11 | Sacramento | California | 6067 | 104609 | 1678 |
1303735 | 1303735 | 2021-05-10 | Sacramento | California | 6067 | 104490 | 1676 |
1300488 | 1300488 | 2021-05-09 | Sacramento | California | 6067 | 104207 | 1672 |
1297241 | 1297241 | 2021-05-08 | Sacramento | California | 6067 | 104175 | 1672 |
1293995 | 1293995 | 2021-05-07 | Sacramento | California | 6067 | 104175 | 1672 |
1290749 | 1290749 | 2021-05-06 | Sacramento | California | 6067 | 104057 | 1670 |
1287503 | 1287503 | 2021-05-05 | Sacramento | California | 6067 | 103594 | 1667 |
1284257 | 1284257 | 2021-05-04 | Sacramento | California | 6067 | 103497 | 1666 |
1281010 | 1281010 | 2021-05-03 | Sacramento | California | 6067 | 103385 | 1665 |
1277763 | 1277763 | 2021-05-02 | Sacramento | California | 6067 | 103042 | 1663 |
1274516 | 1274516 | 2021-05-01 | Sacramento | California | 6067 | 102958 | 1663 |
1271269 | 1271269 | 2021-04-30 | Sacramento | California | 6067 | 102958 | 1663 |
1268022 | 1268022 | 2021-04-29 | Sacramento | California | 6067 | 102792 | 1663 |
1264775 | 1264775 | 2021-04-28 | Sacramento | California | 6067 | 102682 | 1662 |
1261528 | 1261528 | 2021-04-27 | Sacramento | California | 6067 | 102613 | 1659 |
1258281 | 1258281 | 2021-04-26 | Sacramento | California | 6067 | 102485 | 1657 |
1255034 | 1255034 | 2021-04-25 | Sacramento | California | 6067 | 102178 | 1654 |
1251787 | 1251787 | 2021-04-24 | Sacramento | California | 6067 | 102070 | 1654 |
1248540 | 1248540 | 2021-04-23 | Sacramento | California | 6067 | 102070 | 1654 |
1245293 | 1245293 | 2021-04-22 | Sacramento | California | 6067 | 101905 | 1653 |
1242046 | 1242046 | 2021-04-21 | Sacramento | California | 6067 | 101786 | 1651 |
1238799 | 1238799 | 2021-04-20 | Sacramento | California | 6067 | 101664 | 1647 |
1235552 | 1235552 | 2021-04-19 | Sacramento | California | 6067 | 101510 | 1646 |
1232305 | 1232305 | 2021-04-18 | Sacramento | California | 6067 | 101171 | 1646 |
1229056 | 1229056 | 2021-04-17 | Sacramento | California | 6067 | 101057 | 1646 |
1225808 | 1225808 | 2021-04-16 | Sacramento | California | 6067 | 101057 | 1646 |
1222561 | 1222561 | 2021-04-15 | Sacramento | California | 6067 | 100856 | 1645 |
1219313 | 1219313 | 2021-04-14 | Sacramento | California | 6067 | 100725 | 1644 |
1216065 | 1216065 | 2021-04-13 | Sacramento | California | 6067 | 100586 | 1644 |
1212818 | 1212818 | 2021-04-12 | Sacramento | California | 6067 | 100364 | 1640 |
1209570 | 1209570 | 2021-04-11 | Sacramento | California | 6067 | 100047 | 1638 |
1206321 | 1206321 | 2021-04-10 | Sacramento | California | 6067 | 99721 | 1638 |
1203073 | 1203073 | 2021-04-09 | Sacramento | California | 6067 | 99667 | 1638 |
1199825 | 1199825 | 2021-04-08 | Sacramento | California | 6067 | 99267 | 1638 |
1196576 | 1196576 | 2021-04-07 | Sacramento | California | 6067 | 99156 | 1627 |
1193328 | 1193328 | 2021-04-06 | Sacramento | California | 6067 | 99041 | 1620 |
1190078 | 1190078 | 2021-04-05 | Sacramento | California | 6067 | 98847 | 1617 |
1186831 | 1186831 | 2021-04-04 | Sacramento | California | 6067 | 98659 | 1613 |
1183584 | 1183584 | 2021-04-03 | Sacramento | California | 6067 | 98647 | 1613 |
1180337 | 1180337 | 2021-04-02 | Sacramento | California | 6067 | 98487 | 1613 |
1177090 | 1177090 | 2021-04-01 | Sacramento | California | 6067 | 97882 | 1610 |
1173843 | 1173843 | 2021-03-31 | Sacramento | California | 6067 | 97717 | 1603 |
1170596 | 1170596 | 2021-03-30 | Sacramento | California | 6067 | 97616 | 1603 |
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);