latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,276 rows where "date" is on date 2021-05-01
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
767644 | 767644 | 94501 | 94501: Alameda | 2021-05-01 | Alameda | 1 | 2109 | 62826 | |
767645 | 767645 | 94502 | 94502: Alameda | 2021-05-01 | Alameda | 1 | 240 | 14117 | |
767646 | 767646 | 94505 | 94505: Discovery Bay | 2021-05-01 | Alameda | 1 | 1 | 16382 | |
767647 | 767647 | 94514 | 94514: Byron | 2021-05-01 | Alameda | 1 | 0 | 1461 | |
767648 | 767648 | 94536 | 94536: Fremont | 2021-05-01 | Alameda | 1 | 2780 | 72976 | |
767649 | 767649 | 94538 | 94538: Fremont | 2021-05-01 | Alameda | 1 | 2888 | 63911 | |
767650 | 767650 | 94539 | 94539: Fremont | 2021-05-01 | Alameda | 1 | 1113 | 52960 | |
767651 | 767651 | 94541 | 94541: Hayward | 2021-05-01 | Alameda | 1 | 6021 | 65132 | |
767652 | 767652 | 94542 | 94542: Hayward | 2021-05-01 | Alameda | 1 | 704 | 13973 | |
767653 | 767653 | 94544 | 94544: Hayward | 2021-05-01 | Alameda | 1 | 7377 | 77121 | |
767654 | 767654 | 94545 | 94545: Hayward | 2021-05-01 | Alameda | 1 | 2333 | 31657 | |
767655 | 767655 | 94546 | 94546: Castro Valley | 2021-05-01 | Alameda | 1 | 1819 | 45536 | |
767656 | 767656 | 94550 | 94550: Livermore | 2021-05-01 | Alameda | 1 | 2111 | 50138 | |
767657 | 767657 | 94551 | 94551: Livermore | 2021-05-01 | Alameda | 1 | 2169 | 38986 | |
767658 | 767658 | 94552 | 94552: Castro Valley | 2021-05-01 | Alameda | 1 | 397 | 15204 | |
767659 | 767659 | 94555 | 94555: Fremont | 2021-05-01 | Alameda | 1 | 970 | 36037 | |
767660 | 767660 | 94560 | 94560: Newark | 2021-05-01 | Alameda | 1 | 2718 | 44245 | |
767661 | 767661 | 94566 | 94566: Pleasanton | 2021-05-01 | Alameda | 1 | 1363 | 45046 | |
767662 | 767662 | 94568 | 94568: Dublin | 2021-05-01 | Alameda | 1 | 2421 | 58399 | |
767663 | 767663 | 94577 | 94577: San Leandro | 2021-05-01 | Alameda | 1 | 2913 | 48666 | |
767664 | 767664 | 94578 | 94578: San Leandro | 2021-05-01 | Alameda | 1 | 3007 | 40150 | |
767665 | 767665 | 94579 | 94579: San Leandro | 2021-05-01 | Alameda | 1 | 1109 | 20237 | |
767666 | 767666 | 94580 | 94580: San Lorenzo | 2021-05-01 | Alameda | 1 | 2004 | 28970 | |
767667 | 767667 | 94586 | 94586: Sunol | 2021-05-01 | Alameda | 1 | 33 | 797 | |
767668 | 767668 | 94587 | 94587: Union City | 2021-05-01 | Alameda | 1 | 3917 | 72446 | |
767669 | 767669 | 94588 | 94588: Pleasanton | 2021-05-01 | Alameda | 1 | 909 | 31895 | |
767670 | 767670 | 94601 | 94601: Oakland | 2021-05-01 | Alameda | 1 | 5762 | 53261 | |
767671 | 767671 | 94602 | 94602: Oakland | 2021-05-01 | Alameda | 1 | 1235 | 29770 | |
767672 | 767672 | 94603 | 94603: Oakland | 2021-05-01 | Alameda | 1 | 4335 | 33241 | |
767673 | 767673 | 94605 | 94605: Oakland | 2021-05-01 | Alameda | 1 | 2669 | 42375 | |
767674 | 767674 | 94606 | 94606: Oakland | 2021-05-01 | Alameda | 1 | 2179 | 37076 | |
767675 | 767675 | 94607 | 94607: Oakland | 2021-05-01 | Alameda | 1 | 1346 | 26646 | |
767676 | 767676 | 94608 | 94608: Emeryville | 2021-05-01 | Alameda | 1 | 1103 | 31000 | |
767677 | 767677 | 94609 | 94609: Oakland | 2021-05-01 | Alameda | 1 | 971 | 22293 | |
767678 | 767678 | 94610 | 94610: Oakland | 2021-05-01 | Alameda | 1 | 740 | 30862 | |
767679 | 767679 | 94611 | 94611: Oakland | 2021-05-01 | Alameda | 1 | 891 | 37826 | |
767680 | 767680 | 94612 | 94612: Oakland | 2021-05-01 | Alameda | 1 | 629 | 17279 | |
767681 | 767681 | 94613 | 94613: Oakland | 2021-05-01 | Alameda | 1 | 2 | 212 | |
767682 | 767682 | 94618 | 94618: Oakland | 2021-05-01 | Alameda | 1 | 255 | 15545 | |
767683 | 767683 | 94619 | 94619: Oakland | 2021-05-01 | Alameda | 1 | 1141 | 24080 | |
767684 | 767684 | 94621 | 94621: Oakland | 2021-05-01 | Alameda | 1 | 4098 | 32915 | |
767685 | 767685 | 94702 | 94702: Berkeley | 2021-05-01 | Alameda | 1 | 539 | 16520 | |
767686 | 767686 | 94703 | 94703: Berkeley | 2021-05-01 | Alameda | 1 | 582 | 19805 | |
767687 | 767687 | 94704 | 94704: Berkeley | 2021-05-01 | Alameda | 1 | 955 | 29129 | |
767688 | 767688 | 94705 | 94705: Berkeley | 2021-05-01 | Alameda | 1 | 315 | 13152 | |
767689 | 767689 | 94706 | 94706: Albany | 2021-05-01 | Alameda | 1 | 352 | 19921 | |
767690 | 767690 | 94707 | 94707: Berkeley | 2021-05-01 | Alameda | 1 | 137 | 12862 | |
767691 | 767691 | 94708 | 94708: Berkeley | 2021-05-01 | Alameda | 1 | 97 | 11725 | |
767692 | 767692 | 94709 | 94709: Berkeley | 2021-05-01 | Alameda | 1 | 156 | 11796 | |
767693 | 767693 | 94710 | 94710: Berkeley | 2021-05-01 | Alameda | 1 | 561 | 8059 | |
767694 | 767694 | 94720 | 94720: Berkeley | 2021-05-01 | Alameda | 1 | 196 | 1336 | |
767695 | 767695 | 95377 | 95377: Tracy | 2021-05-01 | Alameda | 1 | 1 | 32091 | |
767696 | 767696 | 95391 | 95391: Mountain House | 2021-05-01 | Alameda | 1 | 1 | 20131 | |
767697 | 767697 | Ione & surrounding unincorporated areas | Ione & surrounding unincorporated areas | 2021-05-01 | Amador | 5 | 504 | 7439 | |
767698 | 767698 | Jackson | Jackson | 2021-05-01 | Amador | 5 | 514 | 4694 | |
767699 | 767699 | Pine Grove | Pine Grove | 2021-05-01 | Amador | 5 | 166 | 1730 | |
767700 | 767700 | Pioneer | Pioneer | 2021-05-01 | Amador | 5 | 170 | 1443 | |
767701 | 767701 | Plymouth & surrounding unincorporated areas | Plymouth & surrounding unincorporated areas | 2021-05-01 | Amador | 5 | 154 | 894 | |
767702 | 767702 | Sutter Creek & Amador City | Sutter Creek & Amador City | 2021-05-01 | Amador | 5 | 231 | 2705 | |
767703 | 767703 | Volcano | Volcano | 2021-05-01 | Amador | 5 | 28 | 44 | |
767704 | 767704 | Biggs/Gridley | Biggs/Gridley | 2021-05-01 | Butte | 7 | 1420 | 8908 | |
767705 | 767705 | Chico | Chico | 2021-05-01 | Butte | 7 | 6350 | 91998 | |
767706 | 767706 | Durham | Durham | 2021-05-01 | Butte | 7 | 146 | 5863 | |
767707 | 767707 | Oroville | Oroville | 2021-05-01 | Butte | 7 | 2988 | 19040 | |
767708 | 767708 | Ridge Communities | Ridge Communities | 2021-05-01 | Butte | 7 | 396 | 39707 | |
767709 | 767709 | 95221, 95222 | 95221, 95222 | 2021-05-01 | Calaveras | 9 | 268 | 5029 | |
767710 | 767710 | 95223 | 95223 | 2021-05-01 | Calaveras | 9 | 87 | 2666 | |
767711 | 767711 | 95225 | 95225 | 2021-05-01 | Calaveras | 9 | 29 | 378 | |
767712 | 767712 | 95226, 95252 | 95226, 95252 | 2021-05-01 | Calaveras | 9 | 776 | 16262 | |
767713 | 767713 | 95228 | 95228 | 2021-05-01 | Calaveras | 9 | 225 | 4541 | |
767714 | 767714 | 95232, 95245 | 95232, 95245 | 2021-05-01 | Calaveras | 9 | 58 | 161 | |
767715 | 767715 | 95233, 95224, 95247, 95251, 95229 | 95233, 95224, 95247, 95251, 95229 | 2021-05-01 | Calaveras | 9 | 229 | 5364 | |
767716 | 767716 | 95246, 95250 | 95246, 95250 | 2021-05-01 | Calaveras | 9 | 43 | 1159 | |
767717 | 767717 | 95249 | 95249 | 2021-05-01 | Calaveras | 9 | 243 | 5444 | |
767718 | 767718 | 95254 | 95254 | 2021-05-01 | Calaveras | 9 | 33 | 1035 | |
767719 | 767719 | 95255, 95257, 95248 | 95255, 95257, 95248 | 2021-05-01 | Calaveras | 9 | 53 | 1802 | |
767720 | 767720 | Other | Other | 2021-05-01 | Calaveras | 9 | 48 | ||
767721 | 767721 | Alamo | Alamo | 2021-05-01 | Contra Costa | 13 | 479 | 14750 | |
767722 | 767722 | Antioch | Antioch | 2021-05-01 | Contra Costa | 13 | 9434 | 112520 | |
767723 | 767723 | Bay Point | Bay Point | 2021-05-01 | Contra Costa | 13 | 2743 | 22639 | |
767724 | 767724 | Bethel Island | Bethel Island | 2021-05-01 | Contra Costa | 13 | 71 | 2137 | |
767725 | 767725 | Brentwood | Brentwood | 2021-05-01 | Contra Costa | 13 | 3753 | 65118 | |
767726 | 767726 | Byron | Byron | 2021-05-01 | Contra Costa | 13 | 102 | 1325 | |
767727 | 767727 | Clayton | Clayton | 2021-05-01 | Contra Costa | 13 | 412 | 11337 | |
767728 | 767728 | Concord | Concord | 2021-05-01 | Contra Costa | 13 | 7956 | 130143 | |
767729 | 767729 | Crockett | Crockett | 2021-05-01 | Contra Costa | 13 | 124 | 3044 | |
767730 | 767730 | Danville | Danville | 2021-05-01 | Contra Costa | 13 | 1628 | 43876 | |
767731 | 767731 | Diablo | Diablo | 2021-05-01 | Contra Costa | 13 | 37 | 818 | |
767732 | 767732 | Discovery Bay | Discovery Bay | 2021-05-01 | Contra Costa | 13 | 837 | 13352 | |
767733 | 767733 | El Cerrito | El Cerrito | 2021-05-01 | Contra Costa | 13 | 699 | 24953 | |
767734 | 767734 | Hercules | Hercules | 2021-05-01 | Contra Costa | 13 | 1257 | 25530 | |
767735 | 767735 | Kensington | Kensington | 2021-05-01 | Contra Costa | 13 | 47 | 5077 | |
767736 | 767736 | Knightsen | Knightsen | 2021-05-01 | Contra Costa | 13 | 24 | 1500 | |
767737 | 767737 | Lafayette | Lafayette | 2021-05-01 | Contra Costa | 13 | 618 | 25604 | |
767738 | 767738 | Martinez | Martinez | 2021-05-01 | Contra Costa | 13 | 1935 | 37106 | |
767739 | 767739 | Moraga | Moraga | 2021-05-01 | Contra Costa | 13 | 331 | 16946 | |
767740 | 767740 | Oakley | Oakley | 2021-05-01 | Contra Costa | 13 | 3150 | 42461 | |
767741 | 767741 | Orinda | Orinda | 2021-05-01 | Contra Costa | 13 | 408 | 19009 | |
767742 | 767742 | Pacheco | Pacheco | 2021-05-01 | Contra Costa | 13 | 240 | 3685 | |
767743 | 767743 | Pinole | Pinole | 2021-05-01 | Contra Costa | 13 | 1125 | 19505 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-place-totals" ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] INTEGER );