latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 87 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 87 · 459 ✖
county 1
- Santa Cruz 459
Link | rowid | date | county | fips | confirmed_cases | deaths ▼ | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28058 | 28058 | 2020-05-07 | Santa Cruz | 87 | 139 | 2 | 1 | 0 |
28116 | 28116 | 2020-05-06 | Santa Cruz | 87 | 138 | 2 | 0 | 0 |
28174 | 28174 | 2020-05-05 | Santa Cruz | 87 | 138 | 2 | 1 | 0 |
28232 | 28232 | 2020-05-04 | Santa Cruz | 87 | 137 | 2 | 0 | 0 |
28290 | 28290 | 2020-05-03 | Santa Cruz | 87 | 137 | 2 | 3 | 0 |
28348 | 28348 | 2020-05-02 | Santa Cruz | 87 | 134 | 2 | 2 | 0 |
28406 | 28406 | 2020-05-01 | Santa Cruz | 87 | 132 | 2 | 1 | 0 |
28464 | 28464 | 2020-04-30 | Santa Cruz | 87 | 131 | 2 | 4 | 0 |
28522 | 28522 | 2020-04-29 | Santa Cruz | 87 | 127 | 2 | 2 | 0 |
28578 | 28578 | 2020-04-28 | Santa Cruz | 87 | 125 | 2 | 1 | 0 |
28631 | 28631 | 2020-04-27 | Santa Cruz | 87 | 124 | 2 | 4 | 0 |
28684 | 28684 | 2020-04-26 | Santa Cruz | 87 | 120 | 2 | 5 | 0 |
28737 | 28737 | 2020-04-25 | Santa Cruz | 87 | 115 | 2 | 0 | 0 |
28790 | 28790 | 2020-04-24 | Santa Cruz | 87 | 115 | 2 | 1 | 0 |
28843 | 28843 | 2020-04-23 | Santa Cruz | 87 | 114 | 2 | 3 | 0 |
28896 | 28896 | 2020-04-22 | Santa Cruz | 87 | 111 | 2 | 3 | 0 |
28949 | 28949 | 2020-04-21 | Santa Cruz | 87 | 108 | 2 | 2 | 0 |
29002 | 29002 | 2020-04-20 | Santa Cruz | 87 | 106 | 2 | 2 | 0 |
29055 | 29055 | 2020-04-19 | Santa Cruz | 87 | 104 | 2 | 3 | 0 |
29108 | 29108 | 2020-04-18 | Santa Cruz | 87 | 101 | 2 | 3 | 0 |
29161 | 29161 | 2020-04-17 | Santa Cruz | 87 | 98 | 2 | 2 | 0 |
29214 | 29214 | 2020-04-16 | Santa Cruz | 87 | 96 | 2 | 0 | 0 |
29267 | 29267 | 2020-04-15 | Santa Cruz | 87 | 96 | 2 | 5 | 0 |
29320 | 29320 | 2020-04-14 | Santa Cruz | 87 | 91 | 2 | 0 | 1 |
23650 | 23650 | 2020-07-22 | Santa Cruz | 87 | 848 | 3 | 18 | 0 |
23708 | 23708 | 2020-07-21 | Santa Cruz | 87 | 830 | 3 | 58 | 0 |
23766 | 23766 | 2020-07-20 | Santa Cruz | 87 | 772 | 3 | 0 | 0 |
23824 | 23824 | 2020-07-19 | Santa Cruz | 87 | 772 | 3 | 0 | 0 |
23882 | 23882 | 2020-07-18 | Santa Cruz | 87 | 772 | 3 | 36 | 0 |
23940 | 23940 | 2020-07-17 | Santa Cruz | 87 | 736 | 3 | 30 | 0 |
23998 | 23998 | 2020-07-16 | Santa Cruz | 87 | 706 | 3 | 104 | 0 |
24056 | 24056 | 2020-07-15 | Santa Cruz | 87 | 602 | 3 | 2 | 0 |
24114 | 24114 | 2020-07-14 | Santa Cruz | 87 | 600 | 3 | 31 | 0 |
24172 | 24172 | 2020-07-13 | Santa Cruz | 87 | 569 | 3 | 0 | 0 |
24230 | 24230 | 2020-07-12 | Santa Cruz | 87 | 569 | 3 | 1 | 0 |
24288 | 24288 | 2020-07-11 | Santa Cruz | 87 | 568 | 3 | 31 | 0 |
24346 | 24346 | 2020-07-10 | Santa Cruz | 87 | 537 | 3 | 31 | 0 |
24404 | 24404 | 2020-07-09 | Santa Cruz | 87 | 506 | 3 | 3 | 0 |
24462 | 24462 | 2020-07-08 | Santa Cruz | 87 | 503 | 3 | 2 | 0 |
24520 | 24520 | 2020-07-07 | Santa Cruz | 87 | 501 | 3 | 42 | 0 |
24578 | 24578 | 2020-07-06 | Santa Cruz | 87 | 459 | 3 | 2 | 0 |
24636 | 24636 | 2020-07-05 | Santa Cruz | 87 | 457 | 3 | 2 | 0 |
24694 | 24694 | 2020-07-04 | Santa Cruz | 87 | 455 | 3 | 38 | 0 |
24752 | 24752 | 2020-07-03 | Santa Cruz | 87 | 417 | 3 | 7 | 0 |
24810 | 24810 | 2020-07-02 | Santa Cruz | 87 | 410 | 3 | 11 | 0 |
24868 | 24868 | 2020-07-01 | Santa Cruz | 87 | 399 | 3 | 20 | 0 |
24926 | 24926 | 2020-06-30 | Santa Cruz | 87 | 379 | 3 | 30 | 0 |
24984 | 24984 | 2020-06-29 | Santa Cruz | 87 | 349 | 3 | 0 | 0 |
25042 | 25042 | 2020-06-28 | Santa Cruz | 87 | 349 | 3 | 0 | 0 |
25100 | 25100 | 2020-06-27 | Santa Cruz | 87 | 349 | 3 | 5 | 0 |
25158 | 25158 | 2020-06-26 | Santa Cruz | 87 | 344 | 3 | 7 | 0 |
25216 | 25216 | 2020-06-25 | Santa Cruz | 87 | 337 | 3 | 7 | 1 |
22722 | 22722 | 2020-08-07 | Santa Cruz | 87 | 1229 | 4 | 16 | 0 |
22780 | 22780 | 2020-08-06 | Santa Cruz | 87 | 1213 | 4 | 17 | 0 |
22838 | 22838 | 2020-08-05 | Santa Cruz | 87 | 1196 | 4 | 0 | 0 |
22896 | 22896 | 2020-08-04 | Santa Cruz | 87 | 1196 | 4 | 44 | 0 |
22954 | 22954 | 2020-08-03 | Santa Cruz | 87 | 1152 | 4 | 0 | 0 |
23012 | 23012 | 2020-08-02 | Santa Cruz | 87 | 1152 | 4 | 0 | 0 |
23070 | 23070 | 2020-08-01 | Santa Cruz | 87 | 1152 | 4 | 43 | 0 |
23128 | 23128 | 2020-07-31 | Santa Cruz | 87 | 1109 | 4 | 33 | 0 |
23186 | 23186 | 2020-07-30 | Santa Cruz | 87 | 1076 | 4 | 46 | 0 |
23244 | 23244 | 2020-07-29 | Santa Cruz | 87 | 1030 | 4 | 50 | 0 |
23302 | 23302 | 2020-07-28 | Santa Cruz | 87 | 980 | 4 | 60 | 0 |
23360 | 23360 | 2020-07-27 | Santa Cruz | 87 | 920 | 4 | 13 | 0 |
23418 | 23418 | 2020-07-26 | Santa Cruz | 87 | 907 | 4 | 9 | 0 |
23476 | 23476 | 2020-07-25 | Santa Cruz | 87 | 898 | 4 | 7 | 0 |
23534 | 23534 | 2020-07-24 | Santa Cruz | 87 | 891 | 4 | 13 | 0 |
23592 | 23592 | 2020-07-23 | Santa Cruz | 87 | 878 | 4 | 30 | 1 |
22316 | 22316 | 2020-08-14 | Santa Cruz | 87 | 1371 | 6 | 14 | 0 |
22374 | 22374 | 2020-08-13 | Santa Cruz | 87 | 1357 | 6 | 41 | 0 |
22432 | 22432 | 2020-08-12 | Santa Cruz | 87 | 1316 | 6 | 29 | 0 |
22490 | 22490 | 2020-08-11 | Santa Cruz | 87 | 1287 | 6 | 44 | 0 |
22548 | 22548 | 2020-08-10 | Santa Cruz | 87 | 1243 | 6 | 5 | 0 |
22606 | 22606 | 2020-08-09 | Santa Cruz | 87 | 1238 | 6 | 0 | 0 |
22664 | 22664 | 2020-08-08 | Santa Cruz | 87 | 1238 | 6 | 9 | 2 |
20460 | 20460 | 2020-09-15 | Santa Cruz | 87 | 2096 | 7 | 31 | 0 |
20518 | 20518 | 2020-09-14 | Santa Cruz | 87 | 2065 | 7 | 22 | 0 |
20576 | 20576 | 2020-09-13 | Santa Cruz | 87 | 2043 | 7 | 0 | 0 |
20634 | 20634 | 2020-09-12 | Santa Cruz | 87 | 2043 | 7 | 22 | 0 |
20692 | 20692 | 2020-09-11 | Santa Cruz | 87 | 2021 | 7 | 8 | 0 |
20750 | 20750 | 2020-09-10 | Santa Cruz | 87 | 2013 | 7 | 20 | 0 |
20808 | 20808 | 2020-09-09 | Santa Cruz | 87 | 1993 | 7 | 62 | 0 |
20866 | 20866 | 2020-09-08 | Santa Cruz | 87 | 1931 | 7 | 0 | 0 |
20924 | 20924 | 2020-09-07 | Santa Cruz | 87 | 1931 | 7 | 0 | 0 |
20982 | 20982 | 2020-09-06 | Santa Cruz | 87 | 1931 | 7 | 0 | 0 |
21040 | 21040 | 2020-09-05 | Santa Cruz | 87 | 1931 | 7 | 8 | 0 |
21098 | 21098 | 2020-09-04 | Santa Cruz | 87 | 1923 | 7 | 27 | 0 |
21156 | 21156 | 2020-09-03 | Santa Cruz | 87 | 1896 | 7 | 18 | 0 |
21214 | 21214 | 2020-09-02 | Santa Cruz | 87 | 1878 | 7 | 123 | 0 |
21272 | 21272 | 2020-09-01 | Santa Cruz | 87 | 1755 | 7 | 11 | 0 |
21330 | 21330 | 2020-08-31 | Santa Cruz | 87 | 1744 | 7 | 8 | 0 |
21388 | 21388 | 2020-08-30 | Santa Cruz | 87 | 1736 | 7 | 0 | 0 |
21446 | 21446 | 2020-08-29 | Santa Cruz | 87 | 1736 | 7 | 1 | 0 |
21504 | 21504 | 2020-08-28 | Santa Cruz | 87 | 1735 | 7 | 14 | 0 |
21562 | 21562 | 2020-08-27 | Santa Cruz | 87 | 1721 | 7 | 7 | 0 |
21620 | 21620 | 2020-08-26 | Santa Cruz | 87 | 1714 | 7 | 16 | 0 |
21678 | 21678 | 2020-08-25 | Santa Cruz | 87 | 1698 | 7 | 62 | 0 |
21736 | 21736 | 2020-08-24 | Santa Cruz | 87 | 1636 | 7 | 19 | 0 |
21794 | 21794 | 2020-08-23 | Santa Cruz | 87 | 1617 | 7 | 0 | 0 |
21852 | 21852 | 2020-08-22 | Santa Cruz | 87 | 1617 | 7 | 12 | 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 );