ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "Alameda" and fips = 6001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1491969 | 1491969 | 2021-07-07 | Alameda | California | 6001 | 90697 | 1268 |
1488722 | 1488722 | 2021-07-06 | Alameda | California | 6001 | 90504 | 1267 |
1485475 | 1485475 | 2021-07-05 | Alameda | California | 6001 | 90396 | 1269 |
1482229 | 1482229 | 2021-07-04 | Alameda | California | 6001 | 90396 | 1269 |
1478982 | 1478982 | 2021-07-03 | Alameda | California | 6001 | 90396 | 1269 |
1475736 | 1475736 | 2021-07-02 | Alameda | California | 6001 | 90481 | 1270 |
1472490 | 1472490 | 2021-07-01 | Alameda | California | 6001 | 90300 | 1271 |
1469245 | 1469245 | 2021-06-30 | Alameda | California | 6001 | 90297 | 1271 |
1466000 | 1466000 | 2021-06-29 | Alameda | California | 6001 | 90232 | 1274 |
1462755 | 1462755 | 2021-06-28 | Alameda | California | 6001 | 90182 | 1278 |
1459510 | 1459510 | 2021-06-27 | Alameda | California | 6001 | 90124 | 1277 |
1456265 | 1456265 | 2021-06-26 | Alameda | California | 6001 | 90111 | 1276 |
1453020 | 1453020 | 2021-06-25 | Alameda | California | 6001 | 89958 | 1287 |
1449774 | 1449774 | 2021-06-24 | Alameda | California | 6001 | 89912 | 1286 |
1446529 | 1446529 | 2021-06-23 | Alameda | California | 6001 | 89840 | 1280 |
1443284 | 1443284 | 2021-06-22 | Alameda | California | 6001 | 89777 | 1277 |
1440039 | 1440039 | 2021-06-21 | Alameda | California | 6001 | 89670 | 1277 |
1436792 | 1436792 | 2021-06-20 | Alameda | California | 6001 | 89613 | 1273 |
1433545 | 1433545 | 2021-06-19 | Alameda | California | 6001 | 89613 | 1273 |
1430299 | 1430299 | 2021-06-18 | Alameda | California | 6001 | 89613 | 1273 |
1427054 | 1427054 | 2021-06-17 | Alameda | California | 6001 | 89583 | 1272 |
1423809 | 1423809 | 2021-06-16 | Alameda | California | 6001 | 89557 | 1275 |
1420561 | 1420561 | 2021-06-15 | Alameda | California | 6001 | 89520 | 1271 |
1417316 | 1417316 | 2021-06-14 | Alameda | California | 6001 | 89467 | 1272 |
1414070 | 1414070 | 2021-06-13 | Alameda | California | 6001 | 89408 | 1279 |
1410825 | 1410825 | 2021-06-12 | Alameda | California | 6001 | 89361 | 1285 |
1407580 | 1407580 | 2021-06-11 | Alameda | California | 6001 | 89360 | 1285 |
1404334 | 1404334 | 2021-06-10 | Alameda | California | 6001 | 89325 | 1277 |
1401089 | 1401089 | 2021-06-09 | Alameda | California | 6001 | 89222 | 1270 |
1397844 | 1397844 | 2021-06-08 | Alameda | California | 6001 | 89222 | 1270 |
1394597 | 1394597 | 2021-06-07 | Alameda | California | 6001 | 89168 | 1268 |
1391352 | 1391352 | 2021-06-06 | Alameda | California | 6001 | 89162 | 1268 |
1388107 | 1388107 | 2021-06-05 | Alameda | California | 6001 | 89150 | 1269 |
1384862 | 1384862 | 2021-06-04 | Alameda | California | 6001 | 89112 | 1264 |
1381616 | 1381616 | 2021-06-03 | Alameda | California | 6001 | 89046 | 1687 |
1378371 | 1378371 | 2021-06-02 | Alameda | California | 6001 | 88991 | 1689 |
1375125 | 1375125 | 2021-06-01 | Alameda | California | 6001 | 88976 | 1693 |
1371880 | 1371880 | 2021-05-31 | Alameda | California | 6001 | 88950 | 1693 |
1368635 | 1368635 | 2021-05-30 | Alameda | California | 6001 | 88943 | 1693 |
1365389 | 1365389 | 2021-05-29 | Alameda | California | 6001 | 88914 | 1693 |
1362143 | 1362143 | 2021-05-28 | Alameda | California | 6001 | 88858 | 1684 |
1358896 | 1358896 | 2021-05-27 | Alameda | California | 6001 | 88794 | 1681 |
1355650 | 1355650 | 2021-05-26 | Alameda | California | 6001 | 88728 | 1679 |
1352404 | 1352404 | 2021-05-25 | Alameda | California | 6001 | 88686 | 1679 |
1349158 | 1349158 | 2021-05-24 | Alameda | California | 6001 | 88566 | 1679 |
1345911 | 1345911 | 2021-05-23 | Alameda | California | 6001 | 88566 | 1679 |
1342663 | 1342663 | 2021-05-22 | Alameda | California | 6001 | 88523 | 1679 |
1339415 | 1339415 | 2021-05-21 | Alameda | California | 6001 | 88504 | 1676 |
1336168 | 1336168 | 2021-05-20 | Alameda | California | 6001 | 88429 | 1677 |
1332921 | 1332921 | 2021-05-19 | Alameda | California | 6001 | 88327 | 1674 |
1329674 | 1329674 | 2021-05-18 | Alameda | California | 6001 | 88228 | 1671 |
1326427 | 1326427 | 2021-05-17 | Alameda | California | 6001 | 88178 | 1668 |
1323181 | 1323181 | 2021-05-16 | Alameda | California | 6001 | 88169 | 1668 |
1319935 | 1319935 | 2021-05-15 | Alameda | California | 6001 | 88048 | 1667 |
1316688 | 1316688 | 2021-05-14 | Alameda | California | 6001 | 88048 | 1667 |
1313441 | 1313441 | 2021-05-13 | Alameda | California | 6001 | 87961 | 1657 |
1310194 | 1310194 | 2021-05-12 | Alameda | California | 6001 | 87898 | 1614 |
1306948 | 1306948 | 2021-05-11 | Alameda | California | 6001 | 87754 | 1551 |
1303702 | 1303702 | 2021-05-10 | Alameda | California | 6001 | 87658 | 1546 |
1300455 | 1300455 | 2021-05-09 | Alameda | California | 6001 | 87654 | 1545 |
1297208 | 1297208 | 2021-05-08 | Alameda | California | 6001 | 87606 | 1545 |
1293962 | 1293962 | 2021-05-07 | Alameda | California | 6001 | 87506 | 1543 |
1290716 | 1290716 | 2021-05-06 | Alameda | California | 6001 | 87428 | 1541 |
1287470 | 1287470 | 2021-05-05 | Alameda | California | 6001 | 87393 | 1539 |
1284224 | 1284224 | 2021-05-04 | Alameda | California | 6001 | 87347 | 1538 |
1280977 | 1280977 | 2021-05-03 | Alameda | California | 6001 | 86805 | 1519 |
1277730 | 1277730 | 2021-05-02 | Alameda | California | 6001 | 86725 | 1519 |
1274483 | 1274483 | 2021-05-01 | Alameda | California | 6001 | 86623 | 1508 |
1271236 | 1271236 | 2021-04-30 | Alameda | California | 6001 | 86511 | 1495 |
1267989 | 1267989 | 2021-04-29 | Alameda | California | 6001 | 86411 | 1493 |
1264742 | 1264742 | 2021-04-28 | Alameda | California | 6001 | 86322 | 1491 |
1261495 | 1261495 | 2021-04-27 | Alameda | California | 6001 | 86251 | 1486 |
1258248 | 1258248 | 2021-04-26 | Alameda | California | 6001 | 86183 | 1486 |
1255001 | 1255001 | 2021-04-25 | Alameda | California | 6001 | 86037 | 1485 |
1251754 | 1251754 | 2021-04-24 | Alameda | California | 6001 | 85956 | 1486 |
1248507 | 1248507 | 2021-04-23 | Alameda | California | 6001 | 85850 | 1484 |
1245260 | 1245260 | 2021-04-22 | Alameda | California | 6001 | 85783 | 1481 |
1242013 | 1242013 | 2021-04-21 | Alameda | California | 6001 | 85673 | 1477 |
1238766 | 1238766 | 2021-04-20 | Alameda | California | 6001 | 85604 | 1477 |
1235519 | 1235519 | 2021-04-19 | Alameda | California | 6001 | 85502 | 1477 |
1232272 | 1232272 | 2021-04-18 | Alameda | California | 6001 | 85388 | 1477 |
1229023 | 1229023 | 2021-04-17 | Alameda | California | 6001 | 85277 | 1477 |
1225775 | 1225775 | 2021-04-16 | Alameda | California | 6001 | 85110 | 1475 |
1222528 | 1222528 | 2021-04-15 | Alameda | California | 6001 | 85030 | 1475 |
1219280 | 1219280 | 2021-04-14 | Alameda | California | 6001 | 84942 | 1475 |
1216032 | 1216032 | 2021-04-13 | Alameda | California | 6001 | 84838 | 1447 |
1212785 | 1212785 | 2021-04-12 | Alameda | California | 6001 | 84777 | 1446 |
1209537 | 1209537 | 2021-04-11 | Alameda | California | 6001 | 84647 | 1446 |
1206288 | 1206288 | 2021-04-10 | Alameda | California | 6001 | 84469 | 1446 |
1203040 | 1203040 | 2021-04-09 | Alameda | California | 6001 | 84234 | 1438 |
1199792 | 1199792 | 2021-04-08 | Alameda | California | 6001 | 84151 | 1438 |
1196543 | 1196543 | 2021-04-07 | Alameda | California | 6001 | 84112 | 1432 |
1193295 | 1193295 | 2021-04-06 | Alameda | California | 6001 | 84028 | 1432 |
1190045 | 1190045 | 2021-04-05 | Alameda | California | 6001 | 83972 | 1426 |
1186798 | 1186798 | 2021-04-04 | Alameda | California | 6001 | 83882 | 1426 |
1183551 | 1183551 | 2021-04-03 | Alameda | California | 6001 | 83797 | 1425 |
1180304 | 1180304 | 2021-04-02 | Alameda | California | 6001 | 83595 | 1425 |
1177057 | 1177057 | 2021-04-01 | Alameda | California | 6001 | 83496 | 1423 |
1173810 | 1173810 | 2021-03-31 | Alameda | California | 6001 | 83416 | 1423 |
1170563 | 1170563 | 2021-03-30 | Alameda | California | 6001 | 83359 | 1401 |
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);