latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "Alameda" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
32962 | 32962 | Alameda | Alameda | 1 | 2020-01-31 | 0 | 0 | |
32998 | 32998 | Alameda | Alameda | 1 | 2020-01-26 | 0 | 0 | |
32770 | 32770 | Alameda | Alameda | 1 | 2020-02-26 | 1 | 0 | |
32819 | 32819 | Alameda | Alameda | 1 | 2020-02-21 | 1 | 0 | |
32843 | 32843 | Alameda | Alameda | 1 | 2020-02-20 | 1 | 0 | |
32935 | 32935 | Alameda | Alameda | 1 | 2020-02-02 | 1 | 0 | |
32556 | 32556 | Alameda | Alameda | 1 | 2020-03-06 | 2 | 0 | |
32582 | 32582 | Alameda | Alameda | 1 | 2020-03-05 | 2 | 0 | |
32608 | 32608 | Alameda | Alameda | 1 | 2020-03-04 | 2 | 0 | |
32634 | 32634 | Alameda | Alameda | 1 | 2020-03-03 | 2 | 0 | |
32660 | 32660 | Alameda | Alameda | 1 | 2020-03-02 | 2 | 0 | |
32686 | 32686 | Alameda | Alameda | 1 | 2020-03-01 | 2 | 0 | |
32712 | 32712 | Alameda | Alameda | 1 | 2020-02-29 | 2 | 0 | |
32737 | 32737 | Alameda | Alameda | 1 | 2020-02-28 | 2 | 0 | |
32502 | 32502 | Alameda | Alameda | 1 | 2020-03-08 | 3 | 0 | |
32529 | 32529 | Alameda | Alameda | 1 | 2020-03-07 | 3 | 0 | |
32448 | 32448 | Alameda | Alameda | 1 | 2020-03-10 | 4 | 0 | |
32475 | 32475 | Alameda | Alameda | 1 | 2020-03-09 | 4 | 0 | |
32418 | 32418 | Alameda | Alameda | 1 | 2020-03-11 | 11 | 0 | |
32388 | 32388 | Alameda | Alameda | 1 | 2020-03-12 | 12 | 0 | |
32357 | 32357 | Alameda | Alameda | 1 | 2020-03-13 | 15 | 0 | |
32325 | 32325 | Alameda | Alameda | 1 | 2020-03-14 | 23 | 0 | |
32256 | 32256 | Alameda | Alameda | 1 | 2020-03-16 | 33 | 0 | |
32291 | 32291 | Alameda | Alameda | 1 | 2020-03-15 | 33 | 0 | |
32219 | 32219 | Alameda | Alameda | 1 | 2020-03-17 | 45 | 0 | |
32181 | 32181 | Alameda | Alameda | 1 | 2020-03-18 | 53 | 0 | |
32143 | 32143 | Alameda | Alameda | 1 | 2020-03-19 | 64 | 3 | |
32104 | 32104 | Alameda | Alameda | 1 | 2020-03-20 | 72 | 4 | |
32061 | 32061 | Alameda | Alameda | 1 | 2020-03-21 | 92 | 6 | |
32016 | 32016 | Alameda | Alameda | 1 | 2020-03-22 | 108 | 7 | |
31971 | 31971 | Alameda | Alameda | 1 | 2020-03-23 | 134 | 8 | |
31926 | 31926 | Alameda | Alameda | 1 | 2020-03-24 | 153 | 10 | |
31879 | 31879 | Alameda | Alameda | 1 | 2020-03-25 | 175 | 15 | |
31832 | 31832 | Alameda | Alameda | 1 | 2020-03-26 | 210 | 16 | |
31782 | 31782 | Alameda | Alameda | 1 | 2020-03-27 | 246 | 19 | |
31732 | 31732 | Alameda | Alameda | 1 | 2020-03-28 | 279 | 19 | |
31682 | 31682 | Alameda | Alameda | 1 | 2020-03-29 | 296 | 21 | |
31630 | 31630 | Alameda | Alameda | 1 | 2020-03-30 | 305 | 25 | |
31577 | 31577 | Alameda | Alameda | 1 | 2020-03-31 | 354 | 28 | |
31523 | 31523 | Alameda | Alameda | 1 | 2020-04-01 | 395 | 30 | |
31468 | 31468 | Alameda | Alameda | 1 | 2020-04-02 | 434 | 38 | |
31413 | 31413 | Alameda | Alameda | 1 | 2020-04-03 | 484 | 46 | |
31358 | 31358 | Alameda | Alameda | 1 | 2020-04-04 | 552 | 47 | |
31302 | 31302 | Alameda | Alameda | 1 | 2020-04-05 | 581 | 49 | |
31246 | 31246 | Alameda | Alameda | 1 | 2020-04-06 | 610 | 50 | |
31190 | 31190 | Alameda | Alameda | 1 | 2020-04-07 | 652 | 50 | |
31134 | 31134 | Alameda | Alameda | 1 | 2020-04-08 | 679 | 54 | |
31078 | 31078 | Alameda | Alameda | 1 | 2020-04-09 | 718 | 58 | |
31022 | 31022 | Alameda | Alameda | 1 | 2020-04-10 | 773 | 59 | |
30966 | 30966 | Alameda | Alameda | 1 | 2020-04-11 | 803 | 62 | |
30910 | 30910 | Alameda | Alameda | 1 | 2020-04-12 | 850 | 67 | |
30854 | 30854 | Alameda | Alameda | 1 | 2020-04-13 | 902 | 70 | |
30798 | 30798 | Alameda | Alameda | 1 | 2020-04-14 | 933 | 72 | TRUE |
30742 | 30742 | Alameda | Alameda | 1 | 2020-04-15 | 960 | 73 | |
30686 | 30686 | Alameda | Alameda | 1 | 2020-04-16 | 1037 | 75 | |
30630 | 30630 | Alameda | Alameda | 1 | 2020-04-17 | 1075 | 78 | |
30574 | 30574 | Alameda | Alameda | 1 | 2020-04-18 | 1127 | 80 | |
30518 | 30518 | Alameda | Alameda | 1 | 2020-04-19 | 1181 | 82 | |
30462 | 30462 | Alameda | Alameda | 1 | 2020-04-20 | 1214 | 83 | |
30406 | 30406 | Alameda | Alameda | 1 | 2020-04-21 | 1255 | 83 | |
30350 | 30350 | Alameda | Alameda | 1 | 2020-04-22 | 1293 | 83 | |
30294 | 30294 | Alameda | Alameda | 1 | 2020-04-23 | 1334 | 87 | |
30238 | 30238 | Alameda | Alameda | 1 | 2020-04-24 | 1385 | 90 | |
30182 | 30182 | Alameda | Alameda | 1 | 2020-04-25 | 1410 | 90 | |
30126 | 30126 | Alameda | Alameda | 1 | 2020-04-26 | 1440 | 91 | |
30070 | 30070 | Alameda | Alameda | 1 | 2020-04-27 | 1476 | 93 | |
30013 | 30013 | Alameda | Alameda | 1 | 2020-04-28 | 1500 | 93 | |
29952 | 29952 | Alameda | Alameda | 1 | 2020-04-29 | 1530 | 93 | |
29891 | 29891 | Alameda | Alameda | 1 | 2020-04-30 | 1564 | 95 | |
29830 | 29830 | Alameda | Alameda | 1 | 2020-05-01 | 1604 | 97 | |
29769 | 29769 | Alameda | Alameda | 1 | 2020-05-02 | 1668 | 97 | |
29708 | 29708 | Alameda | Alameda | 1 | 2020-05-03 | 1713 | 98 | |
29647 | 29647 | Alameda | Alameda | 1 | 2020-05-04 | 1736 | 100 | |
29586 | 29586 | Alameda | Alameda | 1 | 2020-05-05 | 1771 | 102 | |
29525 | 29525 | Alameda | Alameda | 1 | 2020-05-06 | 1813 | 102 | |
29464 | 29464 | Alameda | Alameda | 1 | 2020-05-07 | 1866 | 103 | |
29403 | 29403 | Alameda | Alameda | 1 | 2020-05-08 | 1909 | 103 | |
29342 | 29342 | Alameda | Alameda | 1 | 2020-05-09 | 1972 | 104 | |
29281 | 29281 | Alameda | Alameda | 1 | 2020-05-10 | 2005 | 105 | |
29220 | 29220 | Alameda | Alameda | 1 | 2020-05-11 | 2039 | 108 | |
29159 | 29159 | Alameda | Alameda | 1 | 2020-05-12 | 2070 | 109 | |
29098 | 29098 | Alameda | Alameda | 1 | 2020-05-13 | 2110 | 110 | |
29037 | 29037 | Alameda | Alameda | 1 | 2020-05-14 | 2175 | 111 | |
28976 | 28976 | Alameda | Alameda | 1 | 2020-05-15 | 2231 | 111 | |
28915 | 28915 | Alameda | Alameda | 1 | 2020-05-16 | 2292 | 113 | |
28854 | 28854 | Alameda | Alameda | 1 | 2020-05-17 | 2346 | 113 | |
28793 | 28793 | Alameda | Alameda | 1 | 2020-05-18 | 2382 | 115 | |
28732 | 28732 | Alameda | Alameda | 1 | 2020-05-19 | 2442 | 117 | |
28671 | 28671 | Alameda | Alameda | 1 | 2020-05-20 | 2491 | 118 | |
28610 | 28610 | Alameda | Alameda | 1 | 2020-05-21 | 2565 | 118 | |
28549 | 28549 | Alameda | Alameda | 1 | 2020-05-22 | 2640 | 118 | |
28488 | 28488 | Alameda | Alameda | 1 | 2020-05-23 | 2708 | 119 | |
28427 | 28427 | Alameda | Alameda | 1 | 2020-05-24 | 2772 | 120 | |
28366 | 28366 | Alameda | Alameda | 1 | 2020-05-25 | 2843 | 120 | |
28305 | 28305 | Alameda | Alameda | 1 | 2020-05-26 | 2904 | 121 | |
28244 | 28244 | Alameda | Alameda | 1 | 2020-05-27 | 2959 | 121 | |
28183 | 28183 | Alameda | Alameda | 1 | 2020-05-28 | 3013 | 123 | |
28122 | 28122 | Alameda | Alameda | 1 | 2020-05-29 | 3121 | 125 | |
28061 | 28061 | Alameda | Alameda | 1 | 2020-05-30 | 3227 | 127 | |
28000 | 28000 | Alameda | Alameda | 1 | 2020-05-31 | 3333 | 127 |
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 );