Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
This data as json, yaml, copyable, CSV (advanced)
place
fips
county
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y | population |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2020-12-01 | Alameda | 1 | 94501: Alameda | 568 | -122.274583 | 37.774606 | 62826 | |
| 2 | 2 | 2020-12-01 | Alameda | 1 | 94502: Alameda | 84 | -122.241149 | 37.736988 | 14117 | |
| 3 | 3 | 2020-12-01 | Alameda | 1 | 94536: Fremont | 839 | -121.987951 | 37.570977 | 72976 | |
| 4 | 4 | 2020-12-01 | Alameda | 1 | 94538: Fremont | 841 | -121.977924 | 37.499148 | 63911 | |
| 5 | 5 | 2020-12-01 | Alameda | 1 | 94539: Fremont | 286 | -121.912764 | 37.526588 | 52960 | |
| 6 | 6 | 2020-12-01 | Alameda | 1 | 94541: Hayward | 2062 | -122.084564 | 37.674639 | 65132 | |
| 7 | 7 | 2020-12-01 | Alameda | 1 | 94542: Hayward | 219 | -122.028059 | 37.65567 | 13973 | |
| 8 | 8 | 2020-12-01 | Alameda | 1 | 94544: Hayward | 2590 | -122.05668 | 37.633236 | 77121 | |
| 9 | 9 | 2020-12-01 | Alameda | 1 | 94545: Hayward | 724 | -122.118372 | 37.632165 | 31657 | |
| 10 | 10 | 2020-12-01 | Alameda | 1 | 94546: Castro Valley | 600 | -122.096829 | 37.753258 | 45536 | |
| 11 | 11 | 2020-12-01 | Alameda | 1 | 94550: Livermore | 671 | -121.62493 | 37.51205 | 50138 | |
| 12 | 12 | 2020-12-01 | Alameda | 1 | 94551: Livermore | 705 | -121.76451 | 37.748866 | 38986 | |
| 13 | 13 | 2020-12-01 | Alameda | 1 | 94552: Castro Valley | 121 | -122.008969 | 37.706498 | 15204 | |
| 14 | 14 | 2020-12-01 | Alameda | 1 | 94555: Fremont | 259 | -122.081325 | 37.547587 | 36037 | |
| 15 | 15 | 2020-12-01 | Alameda | 1 | 94560: Newark | 814 | -122.037397 | 37.518474 | 44245 | |
| 16 | 16 | 2020-12-01 | Alameda | 1 | 94566: Pleasanton | 427 | -121.855191 | 37.651123 | 45046 | |
| 17 | 17 | 2020-12-01 | Alameda | 1 | 94568: Dublin | 686 | -121.915511 | 37.71354 | 58399 | |
| 18 | 18 | 2020-12-01 | Alameda | 1 | 94577: San Leandro | 970 | -122.164576 | 37.716583 | 48666 | |
| 19 | 19 | 2020-12-01 | Alameda | 1 | 94578: San Leandro | 968 | -122.125289 | 37.706453 | 40150 | |
| 20 | 20 | 2020-12-01 | Alameda | 1 | 94579: San Leandro | 290 | -122.157702 | 37.68652 | 20237 | |
| 21 | 21 | 2020-12-01 | Alameda | 1 | 94580: San Lorenzo | 614 | -122.135476 | 37.67589 | 28970 | |
| 22 | 22 | 2020-12-01 | Alameda | 1 | 94586: Sunol | 13 | -121.869826 | 37.569565 | 797 | |
| 23 | 23 | 2020-12-01 | Alameda | 1 | 94587: Union City | 1206 | -122.045491 | 37.599605 | 72446 | |
| 24 | 24 | 2020-12-01 | Alameda | 1 | 94588: Pleasanton | 305 | -121.88085 | 37.718878 | 31895 | |
| 25 | 25 | 2020-12-01 | Alameda | 1 | 94601: Oakland | 2605 | -122.217961 | 37.776931 | 53261 | |
| 26 | 26 | 2020-12-01 | Alameda | 1 | 94602: Oakland | 469 | -122.207066 | 37.804071 | 29770 | |
| 27 | 27 | 2020-12-01 | Alameda | 1 | 94603: Oakland | 1751 | -122.176302 | 37.738989 | 33241 | |
| 28 | 28 | 2020-12-01 | Alameda | 1 | 94605: Oakland | 998 | -122.148748 | 37.760229 | 42375 | |
| 29 | 29 | 2020-12-01 | Alameda | 1 | 94606: Oakland | 849 | -122.244658 | 37.792494 | 37076 | |
| 30 | 30 | 2020-12-01 | Alameda | 1 | 94607: Oakland | 473 | -122.298298 | 37.808141 | 26646 | |
| 31 | 31 | 2020-12-01 | Alameda | 1 | 94608: Emeryville | 418 | -122.284671 | 37.835737 | 31000 | |
| 32 | 32 | 2020-12-01 | Alameda | 1 | 94609: Oakland | 323 | -122.264066 | 37.834706 | 22293 | |
| 33 | 33 | 2020-12-01 | Alameda | 1 | 94610: Oakland | 252 | -122.240634 | 37.812036 | 30862 | |
| 34 | 34 | 2020-12-01 | Alameda | 1 | 94611: Oakland | 307 | -122.216308 | 37.831401 | 37826 | |
| 35 | 35 | 2020-12-01 | Alameda | 1 | 94612: Oakland | 179 | -122.267177 | 37.808639 | 17279 | |
| 36 | 36 | 2020-12-01 | Alameda | 1 | 94618: Oakland | 68 | -122.238063 | 37.844508 | 15545 | |
| 37 | 37 | 2020-12-01 | Alameda | 1 | 94619: Oakland | 488 | -122.173998 | 37.7918 | 24080 | |
| 38 | 38 | 2020-12-01 | Alameda | 1 | 94621: Oakland | 1764 | -122.207204 | 37.736444 | 32915 | |
| 39 | 39 | 2020-12-01 | Alameda | 1 | 94702: Berkeley | 156 | -122.28609 | 37.866037 | 16520 | |
| 40 | 40 | 2020-12-01 | Alameda | 1 | 94703: Berkeley | 220 | -122.275565 | 37.864148 | 19805 | |
| 41 | 41 | 2020-12-01 | Alameda | 1 | 94704: Berkeley | 262 | -122.253359 | 37.866491 | 29129 | |
| 42 | 42 | 2020-12-01 | Alameda | 1 | 94705: Berkeley | 91 | -122.240914 | 37.859326 | 13152 | |
| 43 | 43 | 2020-12-01 | Alameda | 1 | 94706: Albany | 90 | -122.295165 | 37.889943 | 19921 | |
| 44 | 44 | 2020-12-01 | Alameda | 1 | 94707: Berkeley | 40 | -122.279237 | 37.898243 | 12862 | |
| 45 | 45 | 2020-12-01 | Alameda | 1 | 94708: Berkeley | 35 | -122.259682 | 37.900305 | 11725 | |
| 46 | 46 | 2020-12-01 | Alameda | 1 | 94709: Berkeley | 51 | -122.266717 | 37.879134 | 11796 | |
| 47 | 47 | 2020-12-01 | Alameda | 1 | 94710: Berkeley | 269 | -122.303487 | 37.870693 | 8059 | |
| 48 | 48 | 2020-12-01 | Alameda | 1 | 94720: Berkeley | 25 | -122.243147 | 37.87522 | 1336 | |
| 49 | 49 | 2020-12-01 | Amador | 5 | Ione & surrounding unincorporated areas | 126 | -120.932778 | 38.352778 | ||
| 50 | 50 | 2020-12-01 | Amador | 5 | Jackson | 164 | -120.774167 | 38.348889 | ||
| 51 | 51 | 2020-12-01 | Amador | 5 | Pine Grove | 39 | -120.658889 | 38.413056 | ||
| 52 | 52 | 2020-12-01 | Amador | 5 | Pioneer | 44 | -120.571944 | 38.431944 | ||
| 53 | 53 | 2020-12-01 | Amador | 5 | Plymouth & surrounding unincorporated areas | 36 | -120.844722 | 38.481944 | ||
| 54 | 54 | 2020-12-01 | Amador | 5 | Sutter Creek & Amador City | 74 | -120.8025 | 38.393056 | ||
| 55 | 55 | 2020-12-01 | Amador | 5 | Volcano | 11 | -120.562377 | 38.409966 | ||
| 56 | 56 | 2020-12-01 | Butte | 7 | Biggs/Gridley | 396 | -121.705559 | 39.385866 | 8908 | |
| 57 | 57 | 2020-12-01 | Butte | 7 | Chico | 2651 | -121.837651 | 39.728494 | 91998 | |
| 58 | 58 | 2020-12-01 | Butte | 7 | Durham | 42 | -121.795876 | 39.664949 | 5863 | |
| 59 | 59 | 2020-12-01 | Butte | 7 | Oroville | 925 | -121.556649 | 39.51384 | 19040 | |
| 60 | 60 | 2020-12-01 | Butte | 7 | Other | 68 | 33084 | |||
| 61 | 61 | 2020-12-01 | Butte | 7 | Ridge Communities | 113 | -121.580872 | 39.799577 | 39707 | |
| 62 | 62 | 2020-12-01 | Calaveras | 9 | District 1 | 212 | -120.829167 | 38.191667 | 9394 | |
| 63 | 63 | 2020-12-01 | Calaveras | 9 | District 2 | 40 | -120.540833 | 38.228333 | 8245 | |
| 64 | 64 | 2020-12-01 | Calaveras | 9 | District 3 | 57 | -120.076111 | 38.438889 | 9729 | |
| 65 | 65 | 2020-12-01 | Calaveras | 9 | District 4 | 82 | -120.641944 | 37.981111 | 9605 | |
| 66 | 66 | 2020-12-01 | Calaveras | 9 | District 5 | 107 | -120.866667 | 38.1 | 8605 | |
| 67 | 67 | 2020-12-01 | Contra Costa | 13 | Alamo | 201 | -122.032222 | 37.850278 | 14750 | |
| 68 | 68 | 2020-12-01 | Contra Costa | 13 | Antioch | 3227 | -121.805833 | 38.005 | 112520 | |
| 69 | 69 | 2020-12-01 | Contra Costa | 13 | Bay Point | 1143 | -121.961667 | 38.029167 | 22639 | |
| 70 | 70 | 2020-12-01 | Contra Costa | 13 | Bethel Island | 17 | -121.640556 | 38.015 | 2137 | |
| 71 | 71 | 2020-12-01 | Contra Costa | 13 | Brentwood | 1087 | -121.695833 | 37.931944 | 65118 | |
| 72 | 72 | 2020-12-01 | Contra Costa | 13 | Byron | 35 | -121.638056 | 37.867222 | 1325 | |
| 73 | 73 | 2020-12-01 | Contra Costa | 13 | Clayton | 118 | -121.935833 | 37.941111 | 11337 | |
| 74 | 74 | 2020-12-01 | Contra Costa | 13 | Concord | 3131 | -122.031111 | 37.978056 | 130143 | |
| 75 | 75 | 2020-12-01 | Contra Costa | 13 | Crockett | 33 | -122.213056 | 38.0525 | 3044 | |
| 76 | 76 | 2020-12-01 | Contra Costa | 13 | Danville | 616 | -122.0 | 37.821667 | 43876 | |
| 77 | 77 | 2020-12-01 | Contra Costa | 13 | Discovery Bay | 232 | -121.600278 | 37.908611 | 13352 | |
| 78 | 78 | 2020-12-01 | Contra Costa | 13 | El Cerrito | 207 | -122.311667 | 37.915833 | 24953 | |
| 79 | 79 | 2020-12-01 | Contra Costa | 13 | El Sobrante | 424 | -122.295278 | 37.977222 | 12669 | |
| 80 | 80 | 2020-12-01 | Contra Costa | 13 | Hercules | 392 | -122.288611 | 38.017222 | 25530 | |
| 81 | 81 | 2020-12-01 | Contra Costa | 13 | Kensington | 18 | -122.280278 | 37.910556 | ||
| 82 | 82 | 2020-12-01 | Contra Costa | 13 | Lafayette | 256 | -122.118056 | 37.885833 | 25604 | |
| 83 | 83 | 2020-12-01 | Contra Costa | 13 | Martinez | 567 | -122.134167 | 38.019444 | 37106 | |
| 84 | 84 | 2020-12-01 | Contra Costa | 13 | Moraga | 115 | -122.129722 | 37.835 | 16946 | |
| 85 | 85 | 2020-12-01 | Contra Costa | 13 | Oakley | 823 | -121.7125 | 37.9975 | 42461 | |
| 86 | 86 | 2020-12-01 | Contra Costa | 13 | Orinda | 199 | -122.179722 | 37.882778 | 19009 | |
| 87 | 87 | 2020-12-01 | Contra Costa | 13 | Other | 234 | ||||
| 88 | 88 | 2020-12-01 | Contra Costa | 13 | Pacheco | 83 | -122.075278 | 37.983611 | 3685 | |
| 89 | 89 | 2020-12-01 | Contra Costa | 13 | Pinole | 363 | -122.291111 | 38.004444 | 19505 | |
| 90 | 90 | 2020-12-01 | Contra Costa | 13 | Pittsburg | 2607 | -121.884722 | 38.028056 | 74321 | |
| 91 | 91 | 2020-12-01 | Contra Costa | 13 | Pleasant Hill | 439 | -122.0525 | 37.948056 | 34267 | |
| 92 | 92 | 2020-12-01 | Contra Costa | 13 | Richmond | 4445 | -122.347778 | 37.935833 | 111217 | |
| 93 | 93 | 2020-12-01 | Contra Costa | 13 | Rodeo | 186 | -122.266944 | 38.033056 | 8679 | |
| 94 | 94 | 2020-12-01 | Contra Costa | 13 | San Pablo | 2078 | -122.345556 | 37.962222 | 31413 | |
| 95 | 95 | 2020-12-01 | Contra Costa | 13 | San Ramon | 688 | -121.978056 | 37.78 | 83118 | |
| 96 | 96 | 2020-12-01 | Contra Costa | 13 | Walnut Creek | 950 | -122.065 | 37.906389 | 70860 | |
| 97 | 97 | 2020-12-01 | El Dorado | 17 | Camino, Pollock Pines, Kyburz | 107 | -120.586594 | 38.761292 | ||
| 98 | 98 | 2020-12-01 | El Dorado | 17 | El Dorado Hills | 685 | -121.082222 | 38.685833 | ||
| 99 | 99 | 2020-12-01 | El Dorado | 17 | El Dorado, Diamond Springs | 79 | -120.815 | 38.694722 | ||
| 100 | 100 | 2020-12-01 | El Dorado | 17 | Greater Placerville Area | 271 | -120.798611 | 38.729722 |
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [place] TEXT, [confirmed_cases] INTEGER, [note] TEXT, [x] TEXT, [y] TEXT, [population] TEXT );