ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Santa Barbara" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1621920 | 1621920 | 2021-08-16 | Santa Barbara | California | 6083 | 38702 | 475 |
1618673 | 1618673 | 2021-08-15 | Santa Barbara | California | 6083 | 38544 | 475 |
1615425 | 1615425 | 2021-08-14 | Santa Barbara | California | 6083 | 38449 | 474 |
1612176 | 1612176 | 2021-08-13 | Santa Barbara | California | 6083 | 38307 | 473 |
1608928 | 1608928 | 2021-08-12 | Santa Barbara | California | 6083 | 38125 | 472 |
1605679 | 1605679 | 2021-08-11 | Santa Barbara | California | 6083 | 38000 | 472 |
1602430 | 1602430 | 2021-08-10 | Santa Barbara | California | 6083 | 37900 | 470 |
1599181 | 1599181 | 2021-08-09 | Santa Barbara | California | 6083 | 37843 | 470 |
1595932 | 1595932 | 2021-08-08 | Santa Barbara | California | 6083 | 37729 | 470 |
1592683 | 1592683 | 2021-08-07 | Santa Barbara | California | 6083 | 37538 | 470 |
1589434 | 1589434 | 2021-08-06 | Santa Barbara | California | 6083 | 37538 | 470 |
1586185 | 1586185 | 2021-08-05 | Santa Barbara | California | 6083 | 37439 | 470 |
1582935 | 1582935 | 2021-08-04 | Santa Barbara | California | 6083 | 37328 | 469 |
1579685 | 1579685 | 2021-08-03 | Santa Barbara | California | 6083 | 37267 | 469 |
1576437 | 1576437 | 2021-08-02 | Santa Barbara | California | 6083 | 37225 | 469 |
1573189 | 1573189 | 2021-08-01 | Santa Barbara | California | 6083 | 36947 | 467 |
1569941 | 1569941 | 2021-07-31 | Santa Barbara | California | 6083 | 36947 | 467 |
1566693 | 1566693 | 2021-07-30 | Santa Barbara | California | 6083 | 36947 | 467 |
1563445 | 1563445 | 2021-07-29 | Santa Barbara | California | 6083 | 36847 | 467 |
1560197 | 1560197 | 2021-07-28 | Santa Barbara | California | 6083 | 36747 | 467 |
1556950 | 1556950 | 2021-07-27 | Santa Barbara | California | 6083 | 36703 | 467 |
1553703 | 1553703 | 2021-07-26 | Santa Barbara | California | 6083 | 36653 | 467 |
1550456 | 1550456 | 2021-07-25 | Santa Barbara | California | 6083 | 36463 | 465 |
1547209 | 1547209 | 2021-07-24 | Santa Barbara | California | 6083 | 36463 | 465 |
1543962 | 1543962 | 2021-07-23 | Santa Barbara | California | 6083 | 36463 | 465 |
1540714 | 1540714 | 2021-07-22 | Santa Barbara | California | 6083 | 36390 | 465 |
1537467 | 1537467 | 2021-07-21 | Santa Barbara | California | 6083 | 36307 | 462 |
1534219 | 1534219 | 2021-07-20 | Santa Barbara | California | 6083 | 36276 | 461 |
1530972 | 1530972 | 2021-07-19 | Santa Barbara | California | 6083 | 36252 | 461 |
1527725 | 1527725 | 2021-07-18 | Santa Barbara | California | 6083 | 36141 | 461 |
1524478 | 1524478 | 2021-07-17 | Santa Barbara | California | 6083 | 36141 | 461 |
1521230 | 1521230 | 2021-07-16 | Santa Barbara | California | 6083 | 36141 | 461 |
1517982 | 1517982 | 2021-07-15 | Santa Barbara | California | 6083 | 36091 | 461 |
1514735 | 1514735 | 2021-07-14 | Santa Barbara | California | 6083 | 36051 | 461 |
1511489 | 1511489 | 2021-07-13 | Santa Barbara | California | 6083 | 36036 | 461 |
1508242 | 1508242 | 2021-07-12 | Santa Barbara | California | 6083 | 36018 | 461 |
1504996 | 1504996 | 2021-07-11 | Santa Barbara | California | 6083 | 35967 | 460 |
1501750 | 1501750 | 2021-07-10 | Santa Barbara | California | 6083 | 35967 | 460 |
1498504 | 1498504 | 2021-07-09 | Santa Barbara | California | 6083 | 35967 | 460 |
1495257 | 1495257 | 2021-07-08 | Santa Barbara | California | 6083 | 35954 | 460 |
1492010 | 1492010 | 2021-07-07 | Santa Barbara | California | 6083 | 34703 | 460 |
1488763 | 1488763 | 2021-07-06 | Santa Barbara | California | 6083 | 34692 | 460 |
1485516 | 1485516 | 2021-07-05 | Santa Barbara | California | 6083 | 34660 | 457 |
1482270 | 1482270 | 2021-07-04 | Santa Barbara | California | 6083 | 34660 | 457 |
1479023 | 1479023 | 2021-07-03 | Santa Barbara | California | 6083 | 34660 | 457 |
1475777 | 1475777 | 2021-07-02 | Santa Barbara | California | 6083 | 34660 | 457 |
1472531 | 1472531 | 2021-07-01 | Santa Barbara | California | 6083 | 34652 | 457 |
1469286 | 1469286 | 2021-06-30 | Santa Barbara | California | 6083 | 34643 | 457 |
1466041 | 1466041 | 2021-06-29 | Santa Barbara | California | 6083 | 34626 | 457 |
1462796 | 1462796 | 2021-06-28 | Santa Barbara | California | 6083 | 34659 | 456 |
1459551 | 1459551 | 2021-06-27 | Santa Barbara | California | 6083 | 34642 | 455 |
1456306 | 1456306 | 2021-06-26 | Santa Barbara | California | 6083 | 34642 | 455 |
1453061 | 1453061 | 2021-06-25 | Santa Barbara | California | 6083 | 34642 | 455 |
1449815 | 1449815 | 2021-06-24 | Santa Barbara | California | 6083 | 34631 | 455 |
1446570 | 1446570 | 2021-06-23 | Santa Barbara | California | 6083 | 34624 | 455 |
1443325 | 1443325 | 2021-06-22 | Santa Barbara | California | 6083 | 34613 | 455 |
1440080 | 1440080 | 2021-06-21 | Santa Barbara | California | 6083 | 34613 | 455 |
1436833 | 1436833 | 2021-06-20 | Santa Barbara | California | 6083 | 34596 | 455 |
1433586 | 1433586 | 2021-06-19 | Santa Barbara | California | 6083 | 34596 | 455 |
1430340 | 1430340 | 2021-06-18 | Santa Barbara | California | 6083 | 34596 | 455 |
1427095 | 1427095 | 2021-06-17 | Santa Barbara | California | 6083 | 34593 | 460 |
1423850 | 1423850 | 2021-06-16 | Santa Barbara | California | 6083 | 34587 | 460 |
1420602 | 1420602 | 2021-06-15 | Santa Barbara | California | 6083 | 34580 | 460 |
1417357 | 1417357 | 2021-06-14 | Santa Barbara | California | 6083 | 34577 | 460 |
1414111 | 1414111 | 2021-06-13 | Santa Barbara | California | 6083 | 34577 | 460 |
1410866 | 1410866 | 2021-06-12 | Santa Barbara | California | 6083 | 34572 | 460 |
1407621 | 1407621 | 2021-06-11 | Santa Barbara | California | 6083 | 34561 | 460 |
1404375 | 1404375 | 2021-06-10 | Santa Barbara | California | 6083 | 34557 | 460 |
1401130 | 1401130 | 2021-06-09 | Santa Barbara | California | 6083 | 34549 | 459 |
1397885 | 1397885 | 2021-06-08 | Santa Barbara | California | 6083 | 34547 | 459 |
1394638 | 1394638 | 2021-06-07 | Santa Barbara | California | 6083 | 34541 | 459 |
1391393 | 1391393 | 2021-06-06 | Santa Barbara | California | 6083 | 34531 | 459 |
1388148 | 1388148 | 2021-06-05 | Santa Barbara | California | 6083 | 34531 | 459 |
1384903 | 1384903 | 2021-06-04 | Santa Barbara | California | 6083 | 34526 | 459 |
1381657 | 1381657 | 2021-06-03 | Santa Barbara | California | 6083 | 34513 | 456 |
1378412 | 1378412 | 2021-06-02 | Santa Barbara | California | 6083 | 34507 | 456 |
1375166 | 1375166 | 2021-06-01 | Santa Barbara | California | 6083 | 34498 | 456 |
1371921 | 1371921 | 2021-05-31 | Santa Barbara | California | 6083 | 34488 | 456 |
1368676 | 1368676 | 2021-05-30 | Santa Barbara | California | 6083 | 34488 | 456 |
1365430 | 1365430 | 2021-05-29 | Santa Barbara | California | 6083 | 34488 | 455 |
1362184 | 1362184 | 2021-05-28 | Santa Barbara | California | 6083 | 34488 | 456 |
1358937 | 1358937 | 2021-05-27 | Santa Barbara | California | 6083 | 34477 | 459 |
1355691 | 1355691 | 2021-05-26 | Santa Barbara | California | 6083 | 34470 | 459 |
1352445 | 1352445 | 2021-05-25 | Santa Barbara | California | 6083 | 34462 | 459 |
1349199 | 1349199 | 2021-05-24 | Santa Barbara | California | 6083 | 34446 | 459 |
1345952 | 1345952 | 2021-05-23 | Santa Barbara | California | 6083 | 34431 | 459 |
1342704 | 1342704 | 2021-05-22 | Santa Barbara | California | 6083 | 34431 | 459 |
1339456 | 1339456 | 2021-05-21 | Santa Barbara | California | 6083 | 34431 | 459 |
1336209 | 1336209 | 2021-05-20 | Santa Barbara | California | 6083 | 34419 | 459 |
1332962 | 1332962 | 2021-05-19 | Santa Barbara | California | 6083 | 34412 | 459 |
1329715 | 1329715 | 2021-05-18 | Santa Barbara | California | 6083 | 34404 | 459 |
1326468 | 1326468 | 2021-05-17 | Santa Barbara | California | 6083 | 34398 | 459 |
1323222 | 1323222 | 2021-05-16 | Santa Barbara | California | 6083 | 34365 | 459 |
1319976 | 1319976 | 2021-05-15 | Santa Barbara | California | 6083 | 34365 | 456 |
1316729 | 1316729 | 2021-05-14 | Santa Barbara | California | 6083 | 34365 | 456 |
1313482 | 1313482 | 2021-05-13 | Santa Barbara | California | 6083 | 34361 | 456 |
1310235 | 1310235 | 2021-05-12 | Santa Barbara | California | 6083 | 34337 | 456 |
1306989 | 1306989 | 2021-05-11 | Santa Barbara | California | 6083 | 34328 | 456 |
1303743 | 1303743 | 2021-05-10 | Santa Barbara | California | 6083 | 34323 | 456 |
1300496 | 1300496 | 2021-05-09 | Santa Barbara | California | 6083 | 34291 | 456 |
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);