latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
1,118 rows where county = "Alameda" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
32771 | 32771 | Berkeley | Alameda | 1 | 2020-02-26 | 0 | 0 | |
32820 | 32820 | Berkeley | Alameda | 1 | 2020-02-21 | 0 | 0 | |
32844 | 32844 | Berkeley | Alameda | 1 | 2020-02-20 | 0 | 0 | |
32936 | 32936 | Berkeley | Alameda | 1 | 2020-02-02 | 0 | 0 | |
32962 | 32962 | Alameda | Alameda | 1 | 2020-01-31 | 0 | 0 | |
32963 | 32963 | Berkeley | Alameda | 1 | 2020-01-31 | 0 | 0 | |
32998 | 32998 | Alameda | Alameda | 1 | 2020-01-26 | 0 | 0 | |
32999 | 32999 | Berkeley | Alameda | 1 | 2020-01-26 | 0 | 0 | |
32220 | 32220 | Berkeley | Alameda | 1 | 2020-03-17 | 1 | 0 | |
32257 | 32257 | Berkeley | Alameda | 1 | 2020-03-16 | 1 | 0 | |
32292 | 32292 | Berkeley | Alameda | 1 | 2020-03-15 | 1 | 0 | |
32326 | 32326 | Berkeley | Alameda | 1 | 2020-03-14 | 1 | 0 | |
32358 | 32358 | Berkeley | Alameda | 1 | 2020-03-13 | 1 | 0 | |
32389 | 32389 | Berkeley | Alameda | 1 | 2020-03-12 | 1 | 0 | |
32419 | 32419 | Berkeley | Alameda | 1 | 2020-03-11 | 1 | 0 | |
32449 | 32449 | Berkeley | Alameda | 1 | 2020-03-10 | 1 | 0 | |
32476 | 32476 | Berkeley | Alameda | 1 | 2020-03-09 | 1 | 0 | |
32503 | 32503 | Berkeley | Alameda | 1 | 2020-03-08 | 1 | 0 | |
32530 | 32530 | Berkeley | Alameda | 1 | 2020-03-07 | 1 | 0 | |
32557 | 32557 | Berkeley | Alameda | 1 | 2020-03-06 | 1 | 0 | |
32583 | 32583 | Berkeley | Alameda | 1 | 2020-03-05 | 1 | 0 | |
32609 | 32609 | Berkeley | Alameda | 1 | 2020-03-04 | 1 | 0 | |
32635 | 32635 | Berkeley | Alameda | 1 | 2020-03-03 | 1 | 0 | |
32661 | 32661 | Berkeley | Alameda | 1 | 2020-03-02 | 1 | 0 | |
32687 | 32687 | Berkeley | Alameda | 1 | 2020-03-01 | 1 | 0 | |
32713 | 32713 | Berkeley | Alameda | 1 | 2020-02-29 | 1 | 0 | |
32738 | 32738 | Berkeley | Alameda | 1 | 2020-02-28 | 1 | 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 | |
32182 | 32182 | Berkeley | Alameda | 1 | 2020-03-18 | 2 | 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 | |
32144 | 32144 | Berkeley | Alameda | 1 | 2020-03-19 | 3 | 0 | |
32502 | 32502 | Alameda | Alameda | 1 | 2020-03-08 | 3 | 0 | |
32529 | 32529 | Alameda | Alameda | 1 | 2020-03-07 | 3 | 0 | |
32105 | 32105 | Berkeley | Alameda | 1 | 2020-03-20 | 4 | 0 | |
32448 | 32448 | Alameda | Alameda | 1 | 2020-03-10 | 4 | 0 | |
32475 | 32475 | Alameda | Alameda | 1 | 2020-03-09 | 4 | 0 | |
32017 | 32017 | Berkeley | Alameda | 1 | 2020-03-22 | 5 | 0 | TRUE |
32062 | 32062 | Berkeley | Alameda | 1 | 2020-03-21 | 5 | 0 | |
31972 | 31972 | Berkeley | Alameda | 1 | 2020-03-23 | 6 | 0 | |
31880 | 31880 | Berkeley | Alameda | 1 | 2020-03-25 | 11 | 0 | |
31927 | 31927 | Berkeley | Alameda | 1 | 2020-03-24 | 11 | 0 | |
32418 | 32418 | Alameda | Alameda | 1 | 2020-03-11 | 11 | 0 | |
32388 | 32388 | Alameda | Alameda | 1 | 2020-03-12 | 12 | 0 | |
31833 | 31833 | Berkeley | Alameda | 1 | 2020-03-26 | 14 | 0 | |
32357 | 32357 | Alameda | Alameda | 1 | 2020-03-13 | 15 | 0 | |
31783 | 31783 | Berkeley | Alameda | 1 | 2020-03-27 | 16 | 0 | |
31578 | 31578 | Berkeley | Alameda | 1 | 2020-03-31 | 19 | 0 | |
31631 | 31631 | Berkeley | Alameda | 1 | 2020-03-30 | 19 | 0 | |
31683 | 31683 | Berkeley | Alameda | 1 | 2020-03-29 | 19 | 0 | TRUE |
31733 | 31733 | Berkeley | Alameda | 1 | 2020-03-28 | 19 | 0 | TRUE |
31524 | 31524 | Berkeley | Alameda | 1 | 2020-04-01 | 20 | 1 | |
32325 | 32325 | Alameda | Alameda | 1 | 2020-03-14 | 23 | 0 | |
31469 | 31469 | Berkeley | Alameda | 1 | 2020-04-02 | 24 | 1 | |
31414 | 31414 | Berkeley | Alameda | 1 | 2020-04-03 | 25 | 1 | |
31359 | 31359 | Berkeley | Alameda | 1 | 2020-04-04 | 29 | 1 | TRUE |
31247 | 31247 | Berkeley | Alameda | 1 | 2020-04-06 | 30 | 1 | |
31303 | 31303 | Berkeley | Alameda | 1 | 2020-04-05 | 30 | 1 | TRUE |
31191 | 31191 | Berkeley | Alameda | 1 | 2020-04-07 | 31 | 1 | |
31135 | 31135 | Berkeley | Alameda | 1 | 2020-04-08 | 33 | 1 | |
32256 | 32256 | Alameda | Alameda | 1 | 2020-03-16 | 33 | 0 | |
32291 | 32291 | Alameda | Alameda | 1 | 2020-03-15 | 33 | 0 | |
31079 | 31079 | Berkeley | Alameda | 1 | 2020-04-09 | 34 | 1 | |
30799 | 30799 | Berkeley | Alameda | 1 | 2020-04-14 | 37 | 1 | |
30855 | 30855 | Berkeley | Alameda | 1 | 2020-04-13 | 37 | 1 | |
30911 | 30911 | Berkeley | Alameda | 1 | 2020-04-12 | 37 | 1 | TRUE |
30967 | 30967 | Berkeley | Alameda | 1 | 2020-04-11 | 37 | 1 | TRUE |
31023 | 31023 | Berkeley | Alameda | 1 | 2020-04-10 | 37 | 1 | |
30743 | 30743 | Berkeley | Alameda | 1 | 2020-04-15 | 39 | 1 | |
30687 | 30687 | Berkeley | Alameda | 1 | 2020-04-16 | 41 | 1 | |
30631 | 30631 | Berkeley | Alameda | 1 | 2020-04-17 | 42 | 1 | |
30575 | 30575 | Berkeley | Alameda | 1 | 2020-04-18 | 44 | 1 | TRUE |
30463 | 30463 | Berkeley | Alameda | 1 | 2020-04-20 | 45 | 1 | |
30519 | 30519 | Berkeley | Alameda | 1 | 2020-04-19 | 45 | 1 | TRUE |
32219 | 32219 | Alameda | Alameda | 1 | 2020-03-17 | 45 | 0 | |
30407 | 30407 | Berkeley | Alameda | 1 | 2020-04-21 | 46 | 1 | |
30295 | 30295 | Berkeley | Alameda | 1 | 2020-04-23 | 47 | 1 | |
30351 | 30351 | Berkeley | Alameda | 1 | 2020-04-22 | 47 | 1 | |
30127 | 30127 | Berkeley | Alameda | 1 | 2020-04-26 | 48 | 1 | TRUE |
30183 | 30183 | Berkeley | Alameda | 1 | 2020-04-25 | 48 | 1 | TRUE |
30239 | 30239 | Berkeley | Alameda | 1 | 2020-04-24 | 48 | 1 | |
30071 | 30071 | Berkeley | Alameda | 1 | 2020-04-27 | 49 | 1 | |
29953 | 29953 | Berkeley | Alameda | 1 | 2020-04-29 | 52 | 1 | |
30014 | 30014 | Berkeley | Alameda | 1 | 2020-04-28 | 52 | 1 | |
29892 | 29892 | Berkeley | Alameda | 1 | 2020-04-30 | 53 | 1 | |
32181 | 32181 | Alameda | Alameda | 1 | 2020-03-18 | 53 | 0 | |
29770 | 29770 | Berkeley | Alameda | 1 | 2020-05-02 | 54 | 1 | TRUE |
29831 | 29831 | Berkeley | Alameda | 1 | 2020-05-01 | 54 | 1 | |
29709 | 29709 | Berkeley | Alameda | 1 | 2020-05-03 | 55 | 1 | |
29648 | 29648 | Berkeley | Alameda | 1 | 2020-05-04 | 56 | 1 | |
29587 | 29587 | Berkeley | Alameda | 1 | 2020-05-05 | 57 | 1 |
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 );