latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
310,823 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
place
- Other 2,326
- North County 854
- South County 813
- Brentwood 604
- El Sobrante 519
- El Cerrito 518
- 95391: Mountain House 342
- 95377: Tracy 333
- Prisons 330
- 94545: Hayward 325
- 94608: Emeryville 325
- 94703: Berkeley 325
- 94566: Pleasanton 324
- Westlake 324
- 94502: Alameda 322
- 94544: Hayward 322
- 94546: Castro Valley 322
- 94550: Livermore 322
- 94588: Pleasanton 322
- 94501: Alameda 320
- 94555: Fremont 318
- 94568: Dublin 318
- 94578: San Leandro 318
- 94605: Oakland 318
- 94606: Oakland 318
- 94611: Oakland 318
- 94536: Fremont 317
- 94539: Fremont 317
- 94560: Newark 317
- 94579: San Leandro 317
- ...
fips
county
- Los Angeles 98,057
- San Diego 31,417
- San Bernardino 15,516
- Alameda 15,084
- Riverside 14,528
- Orange 12,129
- Kern 10,883
- San Joaquin 9,481
- Contra Costa 8,340
- San Francisco 7,800
- Sonoma 7,792
- Tulare 7,349
- Marin 6,625
- Ventura 5,615
- Monterey 4,721
- San Luis Obispo 4,444
- Santa Clara 4,100
- Imperial 3,475
- Napa 3,395
- Placer 3,288
- San Mateo 2,909
- Santa Barbara 2,599
- Nevada 2,550
- Long Beach 2,496
- Merced 2,471
- Stanislaus 2,289
- Humboldt 2,205
- Kings 1,970
- Santa Cruz 1,946
- Sacramento 1,927
- ...
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y | population |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2021-01-26 | Alameda | 1 | 94501: Alameda | 1728 | -122.274583 | 37.774606 | 62826 | |
| 2 | 2 | 2021-01-26 | Alameda | 1 | 94502: Alameda | 198 | -122.241149 | 37.736988 | 14117 | |
| 3 | 3 | 2021-01-26 | Alameda | 1 | 94505: Discovery Bay | 1 | -121.593154 | 37.882787 | ||
| 4 | 4 | 2021-01-26 | Alameda | 1 | 94536: Fremont | 2257 | -121.987951 | 37.570977 | 72976 | |
| 5 | 5 | 2021-01-26 | Alameda | 1 | 94538: Fremont | 2312 | -121.977924 | 37.499148 | 63911 | |
| 6 | 6 | 2021-01-26 | Alameda | 1 | 94539: Fremont | 807 | -121.912764 | 37.526588 | 52960 | |
| 7 | 7 | 2021-01-26 | Alameda | 1 | 94541: Hayward | 5019 | -122.084564 | 37.674639 | 65132 | |
| 8 | 8 | 2021-01-26 | Alameda | 1 | 94542: Hayward | 566 | -122.028059 | 37.65567 | 13973 | |
| 9 | 9 | 2021-01-26 | Alameda | 1 | 94544: Hayward | 6222 | -122.05668 | 37.633236 | 77121 | |
| 10 | 10 | 2021-01-26 | Alameda | 1 | 94545: Hayward | 1928 | -122.118372 | 37.632165 | 31657 | |
| 11 | 11 | 2021-01-26 | Alameda | 1 | 94546: Castro Valley | 1472 | -122.096829 | 37.753258 | 45536 | |
| 12 | 12 | 2021-01-26 | Alameda | 1 | 94550: Livermore | 1833 | -121.62493 | 37.51205 | 50138 | |
| 13 | 13 | 2021-01-26 | Alameda | 1 | 94551: Livermore | 1855 | -121.76451 | 37.748866 | 38986 | |
| 14 | 14 | 2021-01-26 | Alameda | 1 | 94552: Castro Valley | 311 | -122.008969 | 37.706498 | 15204 | |
| 15 | 15 | 2021-01-26 | Alameda | 1 | 94555: Fremont | 796 | -122.081325 | 37.547587 | 36037 | |
| 16 | 16 | 2021-01-26 | Alameda | 1 | 94560: Newark | 2305 | -122.037397 | 37.518474 | 44245 | |
| 17 | 17 | 2021-01-26 | Alameda | 1 | 94566: Pleasanton | 1167 | -121.855191 | 37.651123 | 45046 | |
| 18 | 18 | 2021-01-26 | Alameda | 1 | 94568: Dublin | 1971 | -121.915511 | 37.71354 | 58399 | |
| 19 | 19 | 2021-01-26 | Alameda | 1 | 94577: San Leandro | 2291 | -122.164576 | 37.716583 | 48666 | |
| 20 | 20 | 2021-01-26 | Alameda | 1 | 94578: San Leandro | 2473 | -122.125289 | 37.706453 | 40150 | |
| 21 | 21 | 2021-01-26 | Alameda | 1 | 94579: San Leandro | 927 | -122.157702 | 37.68652 | 20237 | |
| 22 | 22 | 2021-01-26 | Alameda | 1 | 94580: San Lorenzo | 1713 | -122.135476 | 37.67589 | 28970 | |
| 23 | 23 | 2021-01-26 | Alameda | 1 | 94586: Sunol | 30 | -121.869826 | 37.569565 | 797 | |
| 24 | 24 | 2021-01-26 | Alameda | 1 | 94587: Union City | 3263 | -122.045491 | 37.599605 | 72446 | |
| 25 | 25 | 2021-01-26 | Alameda | 1 | 94588: Pleasanton | 715 | -121.88085 | 37.718878 | 31895 | |
| 26 | 26 | 2021-01-26 | Alameda | 1 | 94601: Oakland | 4843 | -122.217961 | 37.776931 | 53261 | |
| 27 | 27 | 2021-01-26 | Alameda | 1 | 94602: Oakland | 1006 | -122.207066 | 37.804071 | 29770 | |
| 28 | 28 | 2021-01-26 | Alameda | 1 | 94603: Oakland | 3656 | -122.176302 | 37.738989 | 33241 | |
| 29 | 29 | 2021-01-26 | Alameda | 1 | 94605: Oakland | 2150 | -122.148748 | 37.760229 | 42375 | |
| 30 | 30 | 2021-01-26 | Alameda | 1 | 94606: Oakland | 1754 | -122.244658 | 37.792494 | 37076 | |
| 31 | 31 | 2021-01-26 | Alameda | 1 | 94607: Oakland | 1027 | -122.298298 | 37.808141 | 26646 | |
| 32 | 32 | 2021-01-26 | Alameda | 1 | 94608: Emeryville | 879 | -122.284671 | 37.835737 | 31000 | |
| 33 | 33 | 2021-01-26 | Alameda | 1 | 94609: Oakland | 805 | -122.264066 | 37.834706 | 22293 | |
| 34 | 34 | 2021-01-26 | Alameda | 1 | 94610: Oakland | 582 | -122.240634 | 37.812036 | 30862 | |
| 35 | 35 | 2021-01-26 | Alameda | 1 | 94611: Oakland | 691 | -122.216308 | 37.831401 | 37826 | |
| 36 | 36 | 2021-01-26 | Alameda | 1 | 94612: Oakland | 422 | -122.267177 | 37.808639 | 17279 | |
| 37 | 37 | 2021-01-26 | Alameda | 1 | 94613: Oakland | 2 | -122.182997 | 37.780731 | 212 | |
| 38 | 38 | 2021-01-26 | Alameda | 1 | 94618: Oakland | 195 | -122.238063 | 37.844508 | 15545 | |
| 39 | 39 | 2021-01-26 | Alameda | 1 | 94619: Oakland | 924 | -122.173998 | 37.7918 | 24080 | |
| 40 | 40 | 2021-01-26 | Alameda | 1 | 94621: Oakland | 3447 | -122.207204 | 37.736444 | 32915 | |
| 41 | 41 | 2021-01-26 | Alameda | 1 | 94702: Berkeley | 432 | -122.28609 | 37.866037 | 16520 | |
| 42 | 42 | 2021-01-26 | Alameda | 1 | 94703: Berkeley | 451 | -122.275565 | 37.864148 | 19805 | |
| 43 | 43 | 2021-01-26 | Alameda | 1 | 94704: Berkeley | 528 | -122.253359 | 37.866491 | 29129 | |
| 44 | 44 | 2021-01-26 | Alameda | 1 | 94705: Berkeley | 253 | -122.240914 | 37.859326 | 13152 | |
| 45 | 45 | 2021-01-26 | Alameda | 1 | 94706: Albany | 273 | -122.295165 | 37.889943 | 19921 | |
| 46 | 46 | 2021-01-26 | Alameda | 1 | 94707: Berkeley | 119 | -122.279237 | 37.898243 | 12862 | |
| 47 | 47 | 2021-01-26 | Alameda | 1 | 94708: Berkeley | 74 | -122.259682 | 37.900305 | 11725 | |
| 48 | 48 | 2021-01-26 | Alameda | 1 | 94709: Berkeley | 116 | -122.266717 | 37.879134 | 11796 | |
| 49 | 49 | 2021-01-26 | Alameda | 1 | 94710: Berkeley | 481 | -122.303487 | 37.870693 | 8059 | |
| 50 | 50 | 2021-01-26 | Alameda | 1 | 94720: Berkeley | 58 | -122.243147 | 37.87522 | 1336 | |
| 51 | 51 | 2021-01-26 | Alameda | 1 | 95377: Tracy | 1 | -121.4537 | 37.7212 | ||
| 52 | 52 | 2021-01-26 | Alameda | 1 | 95391: Mountain House | 1 | -121.59902 | 37.75941 | ||
| 53 | 53 | 2021-01-26 | Amador | 5 | Ione & surrounding unincorporated areas | 408 | -120.932778 | 38.352778 | 7439 | |
| 54 | 54 | 2021-01-26 | Amador | 5 | Jackson | 441 | -120.774167 | 38.348889 | 4694 | |
| 55 | 55 | 2021-01-26 | Amador | 5 | Pine Grove | 120 | -120.658889 | 38.413056 | 1730 | |
| 56 | 56 | 2021-01-26 | Amador | 5 | Pioneer | 124 | -120.571944 | 38.431944 | 1443 | |
| 57 | 57 | 2021-01-26 | Amador | 5 | Plymouth & surrounding unincorporated areas | 111 | -120.844722 | 38.481944 | 894 | |
| 58 | 58 | 2021-01-26 | Amador | 5 | Sutter Creek & Amador City | 190 | -120.8025 | 38.393056 | 2705 | |
| 59 | 59 | 2021-01-26 | Amador | 5 | Volcano | 23 | -120.562377 | 38.409966 | 44 | |
| 60 | 60 | 2021-01-26 | Butte | 7 | Biggs/Gridley | 1196 | -121.705559 | 39.385866 | 8908 | |
| 61 | 61 | 2021-01-26 | Butte | 7 | Chico | 5220 | -121.837651 | 39.728494 | 91998 | |
| 62 | 62 | 2021-01-26 | Butte | 7 | Durham | 115 | -121.795876 | 39.664949 | 5863 | |
| 63 | 63 | 2021-01-26 | Butte | 7 | Oroville | 2441 | -121.556649 | 39.51384 | 19040 | |
| 64 | 64 | 2021-01-26 | Butte | 7 | Other | 374 | 33084 | |||
| 65 | 65 | 2021-01-26 | Butte | 7 | Ridge Communities | 310 | -121.580872 | 39.799577 | 39707 | |
| 66 | 66 | 2021-01-26 | Contra Costa | 13 | Alamo | 387 | -122.032222 | 37.850278 | 14750 | |
| 67 | 67 | 2021-01-26 | Contra Costa | 13 | Antioch | 7469 | -121.805833 | 38.005 | 112520 | |
| 68 | 68 | 2021-01-26 | Contra Costa | 13 | Bay Point | 2270 | -121.961667 | 38.029167 | 22639 | |
| 69 | 69 | 2021-01-26 | Contra Costa | 13 | Bethel Island | 60 | -121.640556 | 38.015 | 2137 | |
| 70 | 70 | 2021-01-26 | Contra Costa | 13 | Brentwood | 2881 | -121.695833 | 37.931944 | 65118 | |
| 71 | 71 | 2021-01-26 | Contra Costa | 13 | Byron | 90 | -121.638056 | 37.867222 | 1325 | |
| 72 | 72 | 2021-01-26 | Contra Costa | 13 | Clayton | 331 | -121.935833 | 37.941111 | 11337 | |
| 73 | 73 | 2021-01-26 | Contra Costa | 13 | Concord | 6651 | -122.031111 | 37.978056 | 130143 | |
| 74 | 74 | 2021-01-26 | Contra Costa | 13 | Crockett | 89 | -122.213056 | 38.0525 | 3044 | |
| 75 | 75 | 2021-01-26 | Contra Costa | 13 | Danville | 1326 | -122.0 | 37.821667 | 43876 | |
| 76 | 76 | 2021-01-26 | Contra Costa | 13 | Diablo | 31 | -121.958056 | 37.835 | 818 | |
| 77 | 77 | 2021-01-26 | Contra Costa | 13 | Discovery Bay | 675 | -121.600278 | 37.908611 | 13352 | |
| 78 | 78 | 2021-01-26 | Contra Costa | 13 | El Cerrito | 528 | -122.311667 | 37.915833 | 24953 | |
| 79 | 79 | 2021-01-26 | Contra Costa | 13 | El Sobrante | 956 | -122.295278 | 37.977222 | 12669 | |
| 80 | 80 | 2021-01-26 | Contra Costa | 13 | Hercules | 1020 | -122.288611 | 38.017222 | 25530 | |
| 81 | 81 | 2021-01-26 | Contra Costa | 13 | Kensington | 36 | -122.280278 | 37.910556 | ||
| 82 | 82 | 2021-01-26 | Contra Costa | 13 | Lafayette | 501 | -122.118056 | 37.885833 | 25604 | |
| 83 | 83 | 2021-01-26 | Contra Costa | 13 | Martinez | 1573 | -122.134167 | 38.019444 | 37106 | |
| 84 | 84 | 2021-01-26 | Contra Costa | 13 | Moraga | 254 | -122.129722 | 37.835 | 16946 | |
| 85 | 85 | 2021-01-26 | Contra Costa | 13 | Oakley | 2412 | -121.7125 | 37.9975 | 42461 | |
| 86 | 86 | 2021-01-26 | Contra Costa | 13 | Orinda | 343 | -122.179722 | 37.882778 | 19009 | |
| 87 | 87 | 2021-01-26 | Contra Costa | 13 | Other | 484 | ||||
| 88 | 88 | 2021-01-26 | Contra Costa | 13 | Pacheco | 177 | -122.075278 | 37.983611 | 3685 | |
| 89 | 89 | 2021-01-26 | Contra Costa | 13 | Pinole | 880 | -122.291111 | 38.004444 | 19505 | |
| 90 | 90 | 2021-01-26 | Contra Costa | 13 | Pittsburg | 5484 | -121.884722 | 38.028056 | 74321 | |
| 91 | 91 | 2021-01-26 | Contra Costa | 13 | Pleasant Hill | 955 | -122.0525 | 37.948056 | 34267 | |
| 92 | 92 | 2021-01-26 | Contra Costa | 13 | Richmond | 8579 | -122.347778 | 37.935833 | 111217 | |
| 93 | 93 | 2021-01-26 | Contra Costa | 13 | Rodeo | 446 | -122.266944 | 38.033056 | 8679 | |
| 94 | 94 | 2021-01-26 | Contra Costa | 13 | San Pablo | 4389 | -122.345556 | 37.962222 | 31413 | |
| 95 | 95 | 2021-01-26 | Contra Costa | 13 | San Ramon | 1676 | -121.978056 | 37.78 | 83118 | |
| 96 | 96 | 2021-01-26 | Contra Costa | 13 | Walnut Creek | 2292 | -122.065 | 37.906389 | 70860 | |
| 97 | 97 | 2021-01-26 | El Dorado | 17 | Camino, Pollock Pines, Kyburz | 447 | -120.586594 | 38.761292 | 13548 | |
| 98 | 98 | 2021-01-26 | El Dorado | 17 | El Dorado Hills | 1728 | -121.082222 | 38.685833 | 42439 | |
| 99 | 99 | 2021-01-26 | El Dorado | 17 | El Dorado, Diamond Springs | 386 | -120.815 | 38.694722 | 9396 | |
| 100 | 100 | 2021-01-26 | El Dorado | 17 | Greater Placerville Area | 1481 | -120.798611 | 38.729722 | 36508 |
Advanced export
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 );