latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
564 rows where county = "Sacramento" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips ▼ | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5834 | 5834 | 2021-05-25 | Sacramento | 67 | 105963 | 1700 | 118 | 1 |
5892 | 5892 | 2021-05-24 | Sacramento | 67 | 105845 | 1699 | 241 | 1 |
5950 | 5950 | 2021-05-23 | Sacramento | 67 | 105604 | 1698 | 0 | 0 |
6008 | 6008 | 2021-05-22 | Sacramento | 67 | 105604 | 1698 | 0 | 0 |
6066 | 6066 | 2021-05-21 | Sacramento | 67 | 105604 | 1698 | 64 | 3 |
6124 | 6124 | 2021-05-20 | Sacramento | 67 | 105540 | 1695 | 166 | 2 |
6182 | 6182 | 2021-05-19 | Sacramento | 67 | 105374 | 1693 | 140 | 0 |
6240 | 6240 | 2021-05-18 | Sacramento | 67 | 105234 | 1693 | 70 | 0 |
6298 | 6298 | 2021-05-17 | Sacramento | 67 | 105164 | 1693 | 206 | 2 |
6356 | 6356 | 2021-05-16 | Sacramento | 67 | 104958 | 1691 | 0 | 0 |
6414 | 6414 | 2021-05-15 | Sacramento | 67 | 104958 | 1691 | 0 | 0 |
6472 | 6472 | 2021-05-14 | Sacramento | 67 | 104958 | 1691 | 118 | 5 |
6530 | 6530 | 2021-05-13 | Sacramento | 67 | 104840 | 1686 | 120 | 4 |
6588 | 6588 | 2021-05-12 | Sacramento | 67 | 104720 | 1682 | 110 | 4 |
6646 | 6646 | 2021-05-11 | Sacramento | 67 | 104610 | 1678 | 119 | 2 |
6704 | 6704 | 2021-05-10 | Sacramento | 67 | 104491 | 1676 | 315 | 4 |
6762 | 6762 | 2021-05-09 | Sacramento | 67 | 104176 | 1672 | 0 | 0 |
6820 | 6820 | 2021-05-08 | Sacramento | 67 | 104176 | 1672 | 0 | 0 |
6878 | 6878 | 2021-05-07 | Sacramento | 67 | 104176 | 1672 | 118 | 2 |
6936 | 6936 | 2021-05-06 | Sacramento | 67 | 104058 | 1670 | 463 | 3 |
6994 | 6994 | 2021-05-05 | Sacramento | 67 | 103595 | 1667 | 97 | 1 |
7052 | 7052 | 2021-05-04 | Sacramento | 67 | 103498 | 1666 | 112 | 1 |
7110 | 7110 | 2021-05-03 | Sacramento | 67 | 103386 | 1665 | 427 | 2 |
7168 | 7168 | 2021-05-02 | Sacramento | 67 | 102959 | 1663 | 0 | 0 |
7226 | 7226 | 2021-05-01 | Sacramento | 67 | 102959 | 1663 | 0 | 0 |
7284 | 7284 | 2021-04-30 | Sacramento | 67 | 102959 | 1663 | 166 | 0 |
7342 | 7342 | 2021-04-29 | Sacramento | 67 | 102793 | 1663 | 110 | 1 |
7400 | 7400 | 2021-04-28 | Sacramento | 67 | 102683 | 1662 | 69 | 3 |
7458 | 7458 | 2021-04-27 | Sacramento | 67 | 102614 | 1659 | 128 | 2 |
7516 | 7516 | 2021-04-26 | Sacramento | 67 | 102486 | 1657 | 415 | 3 |
7574 | 7574 | 2021-04-25 | Sacramento | 67 | 102071 | 1654 | 0 | 0 |
7632 | 7632 | 2021-04-24 | Sacramento | 67 | 102071 | 1654 | 0 | 0 |
7690 | 7690 | 2021-04-23 | Sacramento | 67 | 102071 | 1654 | 165 | 1 |
7748 | 7748 | 2021-04-22 | Sacramento | 67 | 101906 | 1653 | 119 | 2 |
7806 | 7806 | 2021-04-21 | Sacramento | 67 | 101787 | 1651 | 122 | 4 |
7864 | 7864 | 2021-04-20 | Sacramento | 67 | 101665 | 1647 | 154 | 1 |
7922 | 7922 | 2021-04-19 | Sacramento | 67 | 101511 | 1646 | 453 | 0 |
7980 | 7980 | 2021-04-18 | Sacramento | 67 | 101058 | 1646 | 0 | 0 |
8038 | 8038 | 2021-04-17 | Sacramento | 67 | 101058 | 1646 | 0 | 0 |
8096 | 8096 | 2021-04-16 | Sacramento | 67 | 101058 | 1646 | 201 | 1 |
8154 | 8154 | 2021-04-15 | Sacramento | 67 | 100857 | 1645 | 131 | 1 |
8212 | 8212 | 2021-04-14 | Sacramento | 67 | 100726 | 1644 | 139 | 0 |
8270 | 8270 | 2021-04-13 | Sacramento | 67 | 100587 | 1644 | 222 | 4 |
8328 | 8328 | 2021-04-12 | Sacramento | 67 | 100365 | 1640 | 697 | 2 |
8386 | 8386 | 2021-04-11 | Sacramento | 67 | 99668 | 1638 | 0 | 0 |
8444 | 8444 | 2021-04-10 | Sacramento | 67 | 99668 | 1638 | 0 | 0 |
8502 | 8502 | 2021-04-09 | Sacramento | 67 | 99668 | 1638 | 400 | 0 |
8560 | 8560 | 2021-04-08 | Sacramento | 67 | 99268 | 1638 | 111 | 11 |
8618 | 8618 | 2021-04-07 | Sacramento | 67 | 99157 | 1627 | 115 | 7 |
8676 | 8676 | 2021-04-06 | Sacramento | 67 | 99042 | 1620 | 194 | 3 |
8734 | 8734 | 2021-04-05 | Sacramento | 67 | 98848 | 1617 | 360 | 4 |
8792 | 8792 | 2021-04-04 | Sacramento | 67 | 98488 | 1613 | 0 | 0 |
8850 | 8850 | 2021-04-03 | Sacramento | 67 | 98488 | 1613 | 0 | 0 |
8908 | 8908 | 2021-04-02 | Sacramento | 67 | 98488 | 1613 | 605 | 3 |
8966 | 8966 | 2021-04-01 | Sacramento | 67 | 97883 | 1610 | 266 | 7 |
9024 | 9024 | 2021-03-31 | Sacramento | 67 | 97617 | 1603 | 0 | 0 |
9082 | 9082 | 2021-03-30 | Sacramento | 67 | 97617 | 1603 | 136 | 1 |
9140 | 9140 | 2021-03-29 | Sacramento | 67 | 97481 | 1602 | 491 | 3 |
9198 | 9198 | 2021-03-28 | Sacramento | 67 | 96990 | 1599 | 0 | 0 |
9256 | 9256 | 2021-03-27 | Sacramento | 67 | 96990 | 1599 | 0 | 0 |
9314 | 9314 | 2021-03-26 | Sacramento | 67 | 96990 | 1599 | 208 | 6 |
9372 | 9372 | 2021-03-25 | Sacramento | 67 | 96782 | 1593 | 166 | 3 |
9430 | 9430 | 2021-03-24 | Sacramento | 67 | 96616 | 1590 | 111 | 4 |
9488 | 9488 | 2021-03-23 | Sacramento | 67 | 96505 | 1586 | 128 | 4 |
9546 | 9546 | 2021-03-22 | Sacramento | 67 | 96377 | 1582 | 413 | 6 |
9604 | 9604 | 2021-03-21 | Sacramento | 67 | 95964 | 1576 | 0 | 0 |
9662 | 9662 | 2021-03-20 | Sacramento | 67 | 95964 | 1576 | 0 | 0 |
9720 | 9720 | 2021-03-19 | Sacramento | 67 | 95964 | 1576 | 127 | 11 |
9778 | 9778 | 2021-03-18 | Sacramento | 67 | 95837 | 1565 | 170 | 6 |
9836 | 9836 | 2021-03-17 | Sacramento | 67 | 95667 | 1559 | 111 | 8 |
9894 | 9894 | 2021-03-16 | Sacramento | 67 | 95556 | 1551 | 115 | 3 |
9952 | 9952 | 2021-03-15 | Sacramento | 67 | 95441 | 1548 | 353 | 7 |
10010 | 10010 | 2021-03-14 | Sacramento | 67 | 95088 | 1541 | 0 | 0 |
10068 | 10068 | 2021-03-13 | Sacramento | 67 | 95088 | 1541 | 0 | 0 |
10126 | 10126 | 2021-03-12 | Sacramento | 67 | 95088 | 1541 | 181 | 4 |
10184 | 10184 | 2021-03-11 | Sacramento | 67 | 94907 | 1537 | 137 | 6 |
10242 | 10242 | 2021-03-10 | Sacramento | 67 | 94770 | 1531 | 71 | 6 |
10300 | 10300 | 2021-03-09 | Sacramento | 67 | 94699 | 1525 | 138 | 4 |
10358 | 10358 | 2021-03-08 | Sacramento | 67 | 94561 | 1521 | 432 | 11 |
10416 | 10416 | 2021-03-07 | Sacramento | 67 | 94129 | 1510 | 0 | 0 |
10474 | 10474 | 2021-03-06 | Sacramento | 67 | 94129 | 1510 | 0 | 0 |
10532 | 10532 | 2021-03-05 | Sacramento | 67 | 94129 | 1510 | 182 | 4 |
10590 | 10590 | 2021-03-04 | Sacramento | 67 | 93947 | 1506 | 157 | 8 |
10648 | 10648 | 2021-03-03 | Sacramento | 67 | 93790 | 1498 | 112 | 10 |
10706 | 10706 | 2021-03-02 | Sacramento | 67 | 93678 | 1488 | 150 | 4 |
10764 | 10764 | 2021-03-01 | Sacramento | 67 | 93528 | 1484 | 368 | 12 |
10822 | 10822 | 2021-02-28 | Sacramento | 67 | 93160 | 1472 | 0 | 0 |
10880 | 10880 | 2021-02-27 | Sacramento | 67 | 93160 | 1472 | 0 | 0 |
10938 | 10938 | 2021-02-26 | Sacramento | 67 | 93160 | 1472 | 216 | 8 |
10996 | 10996 | 2021-02-25 | Sacramento | 67 | 92944 | 1464 | 172 | 8 |
11054 | 11054 | 2021-02-24 | Sacramento | 67 | 92772 | 1456 | 151 | 10 |
11112 | 11112 | 2021-02-23 | Sacramento | 67 | 92621 | 1446 | 193 | 8 |
11170 | 11170 | 2021-02-22 | Sacramento | 67 | 92428 | 1438 | 631 | 7 |
11228 | 11228 | 2021-02-21 | Sacramento | 67 | 91797 | 1431 | 0 | 0 |
11286 | 11286 | 2021-02-20 | Sacramento | 67 | 91797 | 1431 | 0 | 0 |
11344 | 11344 | 2021-02-19 | Sacramento | 67 | 91797 | 1431 | 404 | 19 |
11402 | 11402 | 2021-02-18 | Sacramento | 67 | 91393 | 1412 | 249 | 10 |
11460 | 11460 | 2021-02-17 | Sacramento | 67 | 91144 | 1402 | 214 | 20 |
11518 | 11518 | 2021-02-16 | Sacramento | 67 | 90930 | 1382 | 965 | 10 |
11576 | 11576 | 2021-02-15 | Sacramento | 67 | 89965 | 1372 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );