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 |
---|---|---|---|---|---|---|---|
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 |
1167348 | 1167348 | 2021-03-29 | Sacramento | California | 6067 | 97480 | 1602 |
1164100 | 1164100 | 2021-03-28 | Sacramento | California | 6067 | 97246 | 1599 |
1160852 | 1160852 | 2021-03-27 | Sacramento | California | 6067 | 97039 | 1599 |
1157604 | 1157604 | 2021-03-26 | Sacramento | California | 6067 | 96989 | 1599 |
1154357 | 1154357 | 2021-03-25 | Sacramento | California | 6067 | 96781 | 1593 |
1151110 | 1151110 | 2021-03-24 | Sacramento | California | 6067 | 96615 | 1590 |
1147863 | 1147863 | 2021-03-23 | Sacramento | California | 6067 | 96504 | 1586 |
1144616 | 1144616 | 2021-03-22 | Sacramento | California | 6067 | 96376 | 1582 |
1141369 | 1141369 | 2021-03-21 | Sacramento | California | 6067 | 96125 | 1576 |
1138123 | 1138123 | 2021-03-20 | Sacramento | California | 6067 | 95963 | 1576 |
1134877 | 1134877 | 2021-03-19 | Sacramento | California | 6067 | 95963 | 1576 |
1131630 | 1131630 | 2021-03-18 | Sacramento | California | 6067 | 95836 | 1565 |
1128382 | 1128382 | 2021-03-17 | Sacramento | California | 6067 | 95666 | 1559 |
1125136 | 1125136 | 2021-03-16 | Sacramento | California | 6067 | 95555 | 1551 |
1121890 | 1121890 | 2021-03-15 | Sacramento | California | 6067 | 95440 | 1548 |
1118643 | 1118643 | 2021-03-14 | Sacramento | California | 6067 | 95191 | 1541 |
1115396 | 1115396 | 2021-03-13 | Sacramento | California | 6067 | 95087 | 1541 |
1112150 | 1112150 | 2021-03-12 | Sacramento | California | 6067 | 95087 | 1541 |
1108904 | 1108904 | 2021-03-11 | Sacramento | California | 6067 | 94906 | 1537 |
1105658 | 1105658 | 2021-03-10 | Sacramento | California | 6067 | 94769 | 1531 |
1102412 | 1102412 | 2021-03-09 | Sacramento | California | 6067 | 94698 | 1525 |
1099166 | 1099166 | 2021-03-08 | Sacramento | California | 6067 | 94560 | 1521 |
1095918 | 1095918 | 2021-03-07 | Sacramento | California | 6067 | 94331 | 1510 |
1092672 | 1092672 | 2021-03-06 | Sacramento | California | 6067 | 94181 | 1510 |
1089426 | 1089426 | 2021-03-05 | Sacramento | California | 6067 | 94128 | 1510 |
1086181 | 1086181 | 2021-03-04 | Sacramento | California | 6067 | 93946 | 1506 |
1082935 | 1082935 | 2021-03-03 | Sacramento | California | 6067 | 93789 | 1498 |
1079689 | 1079689 | 2021-03-02 | Sacramento | California | 6067 | 93677 | 1488 |
1076444 | 1076444 | 2021-03-01 | Sacramento | California | 6067 | 93527 | 1484 |
1073198 | 1073198 | 2021-02-28 | Sacramento | California | 6067 | 93280 | 1472 |
1069952 | 1069952 | 2021-02-27 | Sacramento | California | 6067 | 93179 | 1472 |
1066707 | 1066707 | 2021-02-26 | Sacramento | California | 6067 | 93159 | 1472 |
1063462 | 1063462 | 2021-02-25 | Sacramento | California | 6067 | 92943 | 1464 |
1060217 | 1060217 | 2021-02-24 | Sacramento | California | 6067 | 92771 | 1456 |
1056971 | 1056971 | 2021-02-23 | Sacramento | California | 6067 | 92620 | 1446 |
1053725 | 1053725 | 2021-02-22 | Sacramento | California | 6067 | 92427 | 1438 |
1050478 | 1050478 | 2021-02-21 | Sacramento | California | 6067 | 92056 | 1431 |
1047231 | 1047231 | 2021-02-20 | Sacramento | California | 6067 | 91814 | 1431 |
1043986 | 1043986 | 2021-02-19 | Sacramento | California | 6067 | 91796 | 1431 |
1040741 | 1040741 | 2021-02-18 | Sacramento | California | 6067 | 91392 | 1412 |
1037496 | 1037496 | 2021-02-17 | Sacramento | California | 6067 | 91245 | 1402 |
1034251 | 1034251 | 2021-02-16 | Sacramento | California | 6067 | 91090 | 1382 |
1031005 | 1031005 | 2021-02-15 | Sacramento | California | 6067 | 90855 | 1372 |
1027758 | 1027758 | 2021-02-14 | Sacramento | California | 6067 | 90400 | 1372 |
1024513 | 1024513 | 2021-02-13 | Sacramento | California | 6067 | 90251 | 1372 |
1021268 | 1021268 | 2021-02-12 | Sacramento | California | 6067 | 89987 | 1372 |
1018023 | 1018023 | 2021-02-11 | Sacramento | California | 6067 | 89652 | 1360 |
1014778 | 1014778 | 2021-02-10 | Sacramento | California | 6067 | 89377 | 1352 |
1011533 | 1011533 | 2021-02-09 | Sacramento | California | 6067 | 89266 | 1335 |
1008287 | 1008287 | 2021-02-08 | Sacramento | California | 6067 | 88918 | 1318 |
1005041 | 1005041 | 2021-02-07 | Sacramento | California | 6067 | 88531 | 1302 |
1001795 | 1001795 | 2021-02-06 | Sacramento | California | 6067 | 87991 | 1302 |
998549 | 998549 | 2021-02-05 | Sacramento | California | 6067 | 87703 | 1302 |
995303 | 995303 | 2021-02-04 | Sacramento | California | 6067 | 87414 | 1288 |
992057 | 992057 | 2021-02-03 | Sacramento | California | 6067 | 87106 | 1281 |
988811 | 988811 | 2021-02-02 | Sacramento | California | 6067 | 86855 | 1271 |
985564 | 985564 | 2021-02-01 | Sacramento | California | 6067 | 86559 | 1262 |
982317 | 982317 | 2021-01-31 | Sacramento | California | 6067 | 86387 | 1239 |
979071 | 979071 | 2021-01-30 | Sacramento | California | 6067 | 86319 | 1239 |
975826 | 975826 | 2021-01-29 | Sacramento | California | 6067 | 85697 | 1239 |
972581 | 972581 | 2021-01-28 | Sacramento | California | 6067 | 85427 | 1216 |
969336 | 969336 | 2021-01-27 | Sacramento | California | 6067 | 85061 | 1208 |
966092 | 966092 | 2021-01-26 | Sacramento | California | 6067 | 84652 | 1194 |
962847 | 962847 | 2021-01-25 | Sacramento | California | 6067 | 84109 | 1185 |
959602 | 959602 | 2021-01-24 | Sacramento | California | 6067 | 83407 | 1157 |
956356 | 956356 | 2021-01-23 | Sacramento | California | 6067 | 82860 | 1157 |
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);