latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
564 rows where agency = "Sacramento" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6137 | 6137 | Sacramento | Sacramento | 67 | 2021-05-25 | 105963 | 1700 | |
6198 | 6198 | Sacramento | Sacramento | 67 | 2021-05-24 | 105845 | 1699 | |
6259 | 6259 | Sacramento | Sacramento | 67 | 2021-05-23 | 105604 | 1698 | TRUE |
6320 | 6320 | Sacramento | Sacramento | 67 | 2021-05-22 | 105604 | 1698 | TRUE |
6381 | 6381 | Sacramento | Sacramento | 67 | 2021-05-21 | 105604 | 1698 | |
6442 | 6442 | Sacramento | Sacramento | 67 | 2021-05-20 | 105540 | 1695 | |
6503 | 6503 | Sacramento | Sacramento | 67 | 2021-05-19 | 105374 | 1693 | |
6564 | 6564 | Sacramento | Sacramento | 67 | 2021-05-18 | 105234 | 1693 | |
6625 | 6625 | Sacramento | Sacramento | 67 | 2021-05-17 | 105164 | 1693 | |
6686 | 6686 | Sacramento | Sacramento | 67 | 2021-05-16 | 104958 | 1691 | TRUE |
6747 | 6747 | Sacramento | Sacramento | 67 | 2021-05-15 | 104958 | 1691 | TRUE |
6808 | 6808 | Sacramento | Sacramento | 67 | 2021-05-14 | 104958 | 1691 | |
6869 | 6869 | Sacramento | Sacramento | 67 | 2021-05-13 | 104840 | 1686 | |
6930 | 6930 | Sacramento | Sacramento | 67 | 2021-05-12 | 104720 | 1682 | |
6991 | 6991 | Sacramento | Sacramento | 67 | 2021-05-11 | 104610 | 1678 | |
7052 | 7052 | Sacramento | Sacramento | 67 | 2021-05-10 | 104491 | 1676 | |
7113 | 7113 | Sacramento | Sacramento | 67 | 2021-05-09 | 104176 | 1672 | |
7174 | 7174 | Sacramento | Sacramento | 67 | 2021-05-08 | 104176 | 1672 | TRUE |
7235 | 7235 | Sacramento | Sacramento | 67 | 2021-05-07 | 104176 | 1672 | |
7296 | 7296 | Sacramento | Sacramento | 67 | 2021-05-06 | 104058 | 1670 | |
7357 | 7357 | Sacramento | Sacramento | 67 | 2021-05-05 | 103595 | 1667 | |
7418 | 7418 | Sacramento | Sacramento | 67 | 2021-05-04 | 103498 | 1666 | |
7479 | 7479 | Sacramento | Sacramento | 67 | 2021-05-03 | 103386 | 1665 | |
7540 | 7540 | Sacramento | Sacramento | 67 | 2021-05-02 | 102959 | 1663 | TRUE |
7601 | 7601 | Sacramento | Sacramento | 67 | 2021-05-01 | 102959 | 1663 | TRUE |
7662 | 7662 | Sacramento | Sacramento | 67 | 2021-04-30 | 102959 | 1663 | |
7723 | 7723 | Sacramento | Sacramento | 67 | 2021-04-29 | 102793 | 1663 | |
7784 | 7784 | Sacramento | Sacramento | 67 | 2021-04-28 | 102683 | 1662 | |
7845 | 7845 | Sacramento | Sacramento | 67 | 2021-04-27 | 102614 | 1659 | |
7906 | 7906 | Sacramento | Sacramento | 67 | 2021-04-26 | 102486 | 1657 | |
7967 | 7967 | Sacramento | Sacramento | 67 | 2021-04-25 | 102071 | 1654 | TRUE |
8028 | 8028 | Sacramento | Sacramento | 67 | 2021-04-24 | 102071 | 1654 | TRUE |
8089 | 8089 | Sacramento | Sacramento | 67 | 2021-04-23 | 102071 | 1654 | |
8150 | 8150 | Sacramento | Sacramento | 67 | 2021-04-22 | 101906 | 1653 | |
8211 | 8211 | Sacramento | Sacramento | 67 | 2021-04-21 | 101787 | 1651 | |
8272 | 8272 | Sacramento | Sacramento | 67 | 2021-04-20 | 101665 | 1647 | |
8333 | 8333 | Sacramento | Sacramento | 67 | 2021-04-19 | 101511 | 1646 | |
8394 | 8394 | Sacramento | Sacramento | 67 | 2021-04-18 | 101058 | 1646 | TRUE |
8455 | 8455 | Sacramento | Sacramento | 67 | 2021-04-17 | 101058 | 1646 | TRUE |
8516 | 8516 | Sacramento | Sacramento | 67 | 2021-04-16 | 101058 | 1646 | |
8577 | 8577 | Sacramento | Sacramento | 67 | 2021-04-15 | 100857 | 1645 | |
8638 | 8638 | Sacramento | Sacramento | 67 | 2021-04-14 | 100726 | 1644 | |
8699 | 8699 | Sacramento | Sacramento | 67 | 2021-04-13 | 100587 | 1644 | |
8760 | 8760 | Sacramento | Sacramento | 67 | 2021-04-12 | 100365 | 1640 | |
8821 | 8821 | Sacramento | Sacramento | 67 | 2021-04-11 | 99668 | 1638 | TRUE |
8882 | 8882 | Sacramento | Sacramento | 67 | 2021-04-10 | 99668 | 1638 | TRUE |
8943 | 8943 | Sacramento | Sacramento | 67 | 2021-04-09 | 99668 | 1638 | |
9004 | 9004 | Sacramento | Sacramento | 67 | 2021-04-08 | 99268 | 1638 | |
9065 | 9065 | Sacramento | Sacramento | 67 | 2021-04-07 | 99157 | 1627 | |
9126 | 9126 | Sacramento | Sacramento | 67 | 2021-04-06 | 99042 | 1620 | |
9187 | 9187 | Sacramento | Sacramento | 67 | 2021-04-05 | 98848 | 1617 | |
9248 | 9248 | Sacramento | Sacramento | 67 | 2021-04-04 | 98488 | 1613 | TRUE |
9309 | 9309 | Sacramento | Sacramento | 67 | 2021-04-03 | 98488 | 1613 | TRUE |
9370 | 9370 | Sacramento | Sacramento | 67 | 2021-04-02 | 98488 | 1613 | |
9431 | 9431 | Sacramento | Sacramento | 67 | 2021-04-01 | 97883 | 1610 | |
9492 | 9492 | Sacramento | Sacramento | 67 | 2021-03-31 | 97617 | 1603 | TRUE |
9553 | 9553 | Sacramento | Sacramento | 67 | 2021-03-30 | 97617 | 1603 | |
9614 | 9614 | Sacramento | Sacramento | 67 | 2021-03-29 | 97481 | 1602 | |
9675 | 9675 | Sacramento | Sacramento | 67 | 2021-03-28 | 96990 | 1599 | TRUE |
9736 | 9736 | Sacramento | Sacramento | 67 | 2021-03-27 | 96990 | 1599 | TRUE |
9797 | 9797 | Sacramento | Sacramento | 67 | 2021-03-26 | 96990 | 1599 | |
9858 | 9858 | Sacramento | Sacramento | 67 | 2021-03-25 | 96782 | 1593 | |
9919 | 9919 | Sacramento | Sacramento | 67 | 2021-03-24 | 96616 | 1590 | |
9980 | 9980 | Sacramento | Sacramento | 67 | 2021-03-23 | 96505 | 1586 | |
10041 | 10041 | Sacramento | Sacramento | 67 | 2021-03-22 | 96377 | 1582 | |
10102 | 10102 | Sacramento | Sacramento | 67 | 2021-03-21 | 95964 | 1576 | TRUE |
10163 | 10163 | Sacramento | Sacramento | 67 | 2021-03-20 | 95964 | 1576 | TRUE |
10224 | 10224 | Sacramento | Sacramento | 67 | 2021-03-19 | 95964 | 1576 | |
10285 | 10285 | Sacramento | Sacramento | 67 | 2021-03-18 | 95837 | 1565 | |
10346 | 10346 | Sacramento | Sacramento | 67 | 2021-03-17 | 95667 | 1559 | |
10407 | 10407 | Sacramento | Sacramento | 67 | 2021-03-16 | 95556 | 1551 | |
10468 | 10468 | Sacramento | Sacramento | 67 | 2021-03-15 | 95441 | 1548 | |
10529 | 10529 | Sacramento | Sacramento | 67 | 2021-03-14 | 95088 | 1541 | TRUE |
10590 | 10590 | Sacramento | Sacramento | 67 | 2021-03-13 | 95088 | 1541 | TRUE |
10651 | 10651 | Sacramento | Sacramento | 67 | 2021-03-12 | 95088 | 1541 | |
10712 | 10712 | Sacramento | Sacramento | 67 | 2021-03-11 | 94907 | 1537 | |
10773 | 10773 | Sacramento | Sacramento | 67 | 2021-03-10 | 94770 | 1531 | |
10834 | 10834 | Sacramento | Sacramento | 67 | 2021-03-09 | 94699 | 1525 | |
10895 | 10895 | Sacramento | Sacramento | 67 | 2021-03-08 | 94561 | 1521 | |
10956 | 10956 | Sacramento | Sacramento | 67 | 2021-03-07 | 94129 | 1510 | TRUE |
11017 | 11017 | Sacramento | Sacramento | 67 | 2021-03-06 | 94129 | 1510 | TRUE |
11078 | 11078 | Sacramento | Sacramento | 67 | 2021-03-05 | 94129 | 1510 | |
11139 | 11139 | Sacramento | Sacramento | 67 | 2021-03-04 | 93947 | 1506 | |
11200 | 11200 | Sacramento | Sacramento | 67 | 2021-03-03 | 93790 | 1498 | |
11261 | 11261 | Sacramento | Sacramento | 67 | 2021-03-02 | 93678 | 1488 | |
11322 | 11322 | Sacramento | Sacramento | 67 | 2021-03-01 | 93528 | 1484 | |
11383 | 11383 | Sacramento | Sacramento | 67 | 2021-02-28 | 93160 | 1472 | TRUE |
11444 | 11444 | Sacramento | Sacramento | 67 | 2021-02-27 | 93160 | 1472 | TRUE |
11505 | 11505 | Sacramento | Sacramento | 67 | 2021-02-26 | 93160 | 1472 | |
11566 | 11566 | Sacramento | Sacramento | 67 | 2021-02-25 | 92944 | 1464 | |
11627 | 11627 | Sacramento | Sacramento | 67 | 2021-02-24 | 92772 | 1456 | |
11688 | 11688 | Sacramento | Sacramento | 67 | 2021-02-23 | 92621 | 1446 | |
11749 | 11749 | Sacramento | Sacramento | 67 | 2021-02-22 | 92428 | 1438 | |
11810 | 11810 | Sacramento | Sacramento | 67 | 2021-02-21 | 91797 | 1431 | TRUE |
11871 | 11871 | Sacramento | Sacramento | 67 | 2021-02-20 | 91797 | 1431 | TRUE |
11932 | 11932 | Sacramento | Sacramento | 67 | 2021-02-19 | 91797 | 1431 | |
11993 | 11993 | Sacramento | Sacramento | 67 | 2021-02-18 | 91393 | 1412 | |
12054 | 12054 | Sacramento | Sacramento | 67 | 2021-02-17 | 91144 | 1402 | |
12115 | 12115 | Sacramento | Sacramento | 67 | 2021-02-16 | 90930 | 1382 | |
12176 | 12176 | Sacramento | Sacramento | 67 | 2021-02-15 | 89965 | 1372 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );