latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,251,796 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 93,192
- San Diego 27,500
- Riverside 16,192
- San Bernardino 16,000
- Alameda 14,893
- Kern 10,600
- Orange 10,373
- Placer 8,992
- Sonoma 8,928
- Fresno 7,520
- Contra Costa 7,290
- Tulare 6,972
- San Francisco 6,864
- San Mateo 6,330
- San Luis Obispo 5,742
- Ventura 5,675
- Monterey 4,995
- Napa 4,122
- Imperial 3,808
- Santa Clara 3,600
- Nevada 2,805
- Santa Barbara 2,794
- Merced 2,580
- Stanislaus 2,430
- Kings 2,025
- El Dorado 1,968
- Sacramento 1,968
- Solano 1,888
- Amador 1,575
- Yolo 1,230
- …
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
954866 | 954866 | 94501 | 94501: Alameda | 2020-12-04 | Alameda | 1 | 597 | 62826 | |
954867 | 954867 | 94502 | 94502: Alameda | 2020-12-04 | Alameda | 1 | 89 | 14117 | |
954868 | 954868 | 94505 | 94505: Discovery Bay | 2020-12-04 | Alameda | 1 | 0 | 16382 | |
954869 | 954869 | 94514 | 94514: Byron | 2020-12-04 | Alameda | 1 | 0 | 1461 | |
954870 | 954870 | 94536 | 94536: Fremont | 2020-12-04 | Alameda | 1 | 887 | 72976 | |
954871 | 954871 | 94538 | 94538: Fremont | 2020-12-04 | Alameda | 1 | 907 | 63911 | |
954872 | 954872 | 94539 | 94539: Fremont | 2020-12-04 | Alameda | 1 | 322 | 52960 | |
954873 | 954873 | 94541 | 94541: Hayward | 2020-12-04 | Alameda | 1 | 2182 | 65132 | |
954874 | 954874 | 94542 | 94542: Hayward | 2020-12-04 | Alameda | 1 | 238 | 13973 | |
954875 | 954875 | 94544 | 94544: Hayward | 2020-12-04 | Alameda | 1 | 2737 | 77121 | |
954876 | 954876 | 94545 | 94545: Hayward | 2020-12-04 | Alameda | 1 | 759 | 31657 | |
954877 | 954877 | 94546 | 94546: Castro Valley | 2020-12-04 | Alameda | 1 | 649 | 45536 | |
954878 | 954878 | 94550 | 94550: Livermore | 2020-12-04 | Alameda | 1 | 730 | 50138 | |
954879 | 954879 | 94551 | 94551: Livermore | 2020-12-04 | Alameda | 1 | 731 | 38986 | |
954880 | 954880 | 94552 | 94552: Castro Valley | 2020-12-04 | Alameda | 1 | 143 | 15204 | |
954881 | 954881 | 94555 | 94555: Fremont | 2020-12-04 | Alameda | 1 | 285 | 36037 | |
954882 | 954882 | 94560 | 94560: Newark | 2020-12-04 | Alameda | 1 | 860 | 44245 | |
954883 | 954883 | 94566 | 94566: Pleasanton | 2020-12-04 | Alameda | 1 | 471 | 45046 | |
954884 | 954884 | 94568 | 94568: Dublin | 2020-12-04 | Alameda | 1 | 736 | 58399 | |
954885 | 954885 | 94577 | 94577: San Leandro | 2020-12-04 | Alameda | 1 | 1010 | 48666 | |
954886 | 954886 | 94578 | 94578: San Leandro | 2020-12-04 | Alameda | 1 | 1021 | 40150 | |
954887 | 954887 | 94579 | 94579: San Leandro | 2020-12-04 | Alameda | 1 | 302 | 20237 | |
954888 | 954888 | 94580 | 94580: San Lorenzo | 2020-12-04 | Alameda | 1 | 646 | 28970 | |
954889 | 954889 | 94586 | 94586: Sunol | 2020-12-04 | Alameda | 1 | 13 | 797 | |
954890 | 954890 | 94587 | 94587: Union City | 2020-12-04 | Alameda | 1 | 1278 | 72446 | |
954891 | 954891 | 94588 | 94588: Pleasanton | 2020-12-04 | Alameda | 1 | 325 | 31895 | |
954892 | 954892 | 94601 | 94601: Oakland | 2020-12-04 | Alameda | 1 | 2688 | 53261 | |
954893 | 954893 | 94602 | 94602: Oakland | 2020-12-04 | Alameda | 1 | 485 | 29770 | |
954894 | 954894 | 94603 | 94603: Oakland | 2020-12-04 | Alameda | 1 | 1810 | 33241 | |
954895 | 954895 | 94605 | 94605: Oakland | 2020-12-04 | Alameda | 1 | 1035 | 42375 | |
954896 | 954896 | 94606 | 94606: Oakland | 2020-12-04 | Alameda | 1 | 886 | 37076 | |
954897 | 954897 | 94607 | 94607: Oakland | 2020-12-04 | Alameda | 1 | 495 | 26646 | |
954898 | 954898 | 94608 | 94608: Emeryville | 2020-12-04 | Alameda | 1 | 433 | 31000 | |
954899 | 954899 | 94609 | 94609: Oakland | 2020-12-04 | Alameda | 1 | 334 | 22293 | |
954900 | 954900 | 94610 | 94610: Oakland | 2020-12-04 | Alameda | 1 | 268 | 30862 | |
954901 | 954901 | 94611 | 94611: Oakland | 2020-12-04 | Alameda | 1 | 319 | 37826 | |
954902 | 954902 | 94612 | 94612: Oakland | 2020-12-04 | Alameda | 1 | 191 | 17279 | |
954903 | 954903 | 94613 | 94613: Oakland | 2020-12-04 | Alameda | 1 | 0 | 212 | |
954904 | 954904 | 94618 | 94618: Oakland | 2020-12-04 | Alameda | 1 | 75 | 15545 | |
954905 | 954905 | 94619 | 94619: Oakland | 2020-12-04 | Alameda | 1 | 503 | 24080 | |
954906 | 954906 | 94621 | 94621: Oakland | 2020-12-04 | Alameda | 1 | 1799 | 32915 | |
954907 | 954907 | 94702 | 94702: Berkeley | 2020-12-04 | Alameda | 1 | 162 | 16520 | |
954908 | 954908 | 94703 | 94703: Berkeley | 2020-12-04 | Alameda | 1 | 231 | 19805 | |
954909 | 954909 | 94704 | 94704: Berkeley | 2020-12-04 | Alameda | 1 | 264 | 29129 | |
954910 | 954910 | 94705 | 94705: Berkeley | 2020-12-04 | Alameda | 1 | 94 | 13152 | |
954911 | 954911 | 94706 | 94706: Albany | 2020-12-04 | Alameda | 1 | 102 | 19921 | |
954912 | 954912 | 94707 | 94707: Berkeley | 2020-12-04 | Alameda | 1 | 52 | 12862 | |
954913 | 954913 | 94708 | 94708: Berkeley | 2020-12-04 | Alameda | 1 | 37 | 11725 | |
954914 | 954914 | 94709 | 94709: Berkeley | 2020-12-04 | Alameda | 1 | 53 | 11796 | |
954915 | 954915 | 94710 | 94710: Berkeley | 2020-12-04 | Alameda | 1 | 287 | 8059 | |
954916 | 954916 | 94720 | 94720: Berkeley | 2020-12-04 | Alameda | 1 | 25 | 1336 | |
954917 | 954917 | 95377 | 95377: Tracy | 2020-12-04 | Alameda | 1 | 0 | 32091 | |
954918 | 954918 | 95391 | 95391: Mountain House | 2020-12-04 | Alameda | 1 | 0 | 20131 | |
954919 | 954919 | Ione & surrounding unincorporated areas | Ione & surrounding unincorporated areas | 2020-12-04 | Amador | 5 | 143 | 7439 | |
954920 | 954920 | Jackson | Jackson | 2020-12-04 | Amador | 5 | 178 | 4694 | |
954921 | 954921 | Pine Grove | Pine Grove | 2020-12-04 | Amador | 5 | 41 | 1730 | |
954922 | 954922 | Pioneer | Pioneer | 2020-12-04 | Amador | 5 | 47 | 1443 | |
954923 | 954923 | Plymouth & surrounding unincorporated areas | Plymouth & surrounding unincorporated areas | 2020-12-04 | Amador | 5 | 38 | 894 | |
954924 | 954924 | Sutter Creek & Amador City | Sutter Creek & Amador City | 2020-12-04 | Amador | 5 | 85 | 2705 | |
954925 | 954925 | Volcano | Volcano | 2020-12-04 | Amador | 5 | 13 | 44 | |
954926 | 954926 | Biggs/Gridley | Biggs/Gridley | 2020-12-04 | Butte | 7 | 428 | 8908 | |
954927 | 954927 | Chico | Chico | 2020-12-04 | Butte | 7 | 2733 | 91998 | |
954928 | 954928 | Durham | Durham | 2020-12-04 | Butte | 7 | 44 | 5863 | |
954929 | 954929 | Oroville | Oroville | 2020-12-04 | Butte | 7 | 1006 | 19040 | |
954930 | 954930 | Ridge Communities | Ridge Communities | 2020-12-04 | Butte | 7 | 120 | 39707 | |
954931 | 954931 | Alamo | Alamo | 2020-12-04 | Contra Costa | 13 | 210 | 14750 | |
954932 | 954932 | Antioch | Antioch | 2020-12-04 | Contra Costa | 13 | 3293 | 112520 | |
954933 | 954933 | Bay Point | Bay Point | 2020-12-04 | Contra Costa | 13 | 1162 | 22639 | |
954934 | 954934 | Bethel Island | Bethel Island | 2020-12-04 | Contra Costa | 13 | 18 | 2137 | |
954935 | 954935 | Brentwood | Brentwood | 2020-12-04 | Contra Costa | 13 | 1135 | 65118 | |
954936 | 954936 | Byron | Byron | 2020-12-04 | Contra Costa | 13 | 36 | 1325 | |
954937 | 954937 | Clayton | Clayton | 2020-12-04 | Contra Costa | 13 | 122 | 11337 | |
954938 | 954938 | Concord | Concord | 2020-12-04 | Contra Costa | 13 | 3212 | 130143 | |
954939 | 954939 | Crockett | Crockett | 2020-12-04 | Contra Costa | 13 | 34 | 3044 | |
954940 | 954940 | Danville | Danville | 2020-12-04 | Contra Costa | 13 | 634 | 43876 | |
954941 | 954941 | Diablo | Diablo | 2020-12-04 | Contra Costa | 13 | 0 | 818 | |
954942 | 954942 | Discovery Bay | Discovery Bay | 2020-12-04 | Contra Costa | 13 | 246 | 13352 | |
954943 | 954943 | El Cerrito | El Cerrito | 2020-12-04 | Contra Costa | 13 | 220 | 24953 | |
954944 | 954944 | Hercules | Hercules | 2020-12-04 | Contra Costa | 13 | 416 | 25530 | |
954945 | 954945 | Kensington | Kensington | 2020-12-04 | Contra Costa | 13 | 19 | 5077 | |
954946 | 954946 | Knightsen | Knightsen | 2020-12-04 | Contra Costa | 13 | 0 | 1500 | |
954947 | 954947 | Lafayette | Lafayette | 2020-12-04 | Contra Costa | 13 | 265 | 25604 | |
954948 | 954948 | Martinez | Martinez | 2020-12-04 | Contra Costa | 13 | 604 | 37106 | |
954949 | 954949 | Moraga | Moraga | 2020-12-04 | Contra Costa | 13 | 118 | 16946 | |
954950 | 954950 | Oakley | Oakley | 2020-12-04 | Contra Costa | 13 | 874 | 42461 | |
954951 | 954951 | Orinda | Orinda | 2020-12-04 | Contra Costa | 13 | 203 | 19009 | |
954952 | 954952 | Pacheco | Pacheco | 2020-12-04 | Contra Costa | 13 | 85 | 3685 | |
954953 | 954953 | Pinole | Pinole | 2020-12-04 | Contra Costa | 13 | 381 | 19505 | |
954954 | 954954 | Pittsburg | Pittsburg | 2020-12-04 | Contra Costa | 13 | 2683 | 74321 | |
954955 | 954955 | Pleasant Hill | Pleasant Hill | 2020-12-04 | Contra Costa | 13 | 448 | 34267 | |
954956 | 954956 | Richmond | Richmond | 2020-12-04 | Contra Costa | 13 | 4589 | 111217 | |
954957 | 954957 | Rodeo | Rodeo | 2020-12-04 | Contra Costa | 13 | 194 | 8679 | |
954958 | 954958 | San Pablo | San Pablo | 2020-12-04 | Contra Costa | 13 | 2163 | 31413 | |
954959 | 954959 | San Ramon | San Ramon | 2020-12-04 | Contra Costa | 13 | 731 | 83118 | |
954960 | 954960 | Walnut Creek | Walnut Creek | 2020-12-04 | Contra Costa | 13 | 982 | 70860 | |
954961 | 954961 | Camino, Pollock Pines, Kyburz | Camino, Pollock Pines, Kyburz | 2020-12-04 | El Dorado | 17 | 123 | 13548 | |
954962 | 954962 | El Dorado Hills | El Dorado Hills | 2020-12-04 | El Dorado | 17 | 740 | 42439 | |
954963 | 954963 | El Dorado, Diamond Springs | El Dorado, Diamond Springs | 2020-12-04 | El Dorado | 17 | 89 | 9396 | |
954964 | 954964 | Greater Placerville Area | Greater Placerville Area | 2020-12-04 | El Dorado | 17 | 313 | 36508 | |
954965 | 954965 | North County | North County | 2020-12-04 | El Dorado | 17 | 102 | 14433 |
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] TEXT );