latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
239,504 rows sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
place
- Other 1,888
- North County 848
- South County 806
- Brentwood 500
- El Sobrante 425
- El Cerrito 424
- Del Rey 362
- 94545: Hayward 272
- 94608: Emeryville 272
- 94703: Berkeley 272
- Westlake 272
- 94566: Pleasanton 271
- 94502: Alameda 269
- 94544: Hayward 269
- 94546: Castro Valley 269
- 94550: Livermore 269
- 94588: Pleasanton 269
- 94501: Alameda 267
- 94555: Fremont 265
- 94568: Dublin 265
- 94578: San Leandro 265
- 94605: Oakland 265
- 94606: Oakland 265
- 94611: Oakland 265
- 94536: Fremont 264
- 94539: Fremont 264
- 94560: Newark 264
- 94579: San Leandro 264
- 94587: Union City 264
- 94610: Oakland 264
- ...
fips
county
- Los Angeles 80,631
- San Diego 25,587
- Alameda 12,407
- San Bernardino 12,196
- Riverside 11,812
- Orange 9,956
- Kern 8,311
- San Joaquin 7,778
- Contra Costa 6,731
- San Francisco 6,397
- Sonoma 6,166
- Marin 4,423
- Ventura 4,342
- Tulare 3,351
- Santa Clara 3,321
- San Luis Obispo 3,210
- Fresno 2,998
- Imperial 2,609
- Napa 2,441
- Santa Barbara 2,027
- Long Beach 1,923
- Stanislaus 1,789
- Nevada 1,649
- Sacramento 1,631
- Kings 1,502
- Merced 1,447
- Santa Cruz 1,363
- Solano 1,288
- El Dorado 1,267
- San Mateo 1,213
- ...
| Link | rowid | date ▲ | county | fips | place | confirmed_cases | note | x | y | population |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 2020-12-04 | Alameda | 1 | 94501: Alameda | 597 | -122.274583 | 37.774606 | 62826 | |
| 2 | 2 | 2020-12-04 | Alameda | 1 | 94502: Alameda | 89 | -122.241149 | 37.736988 | 14117 | |
| 3 | 3 | 2020-12-04 | Alameda | 1 | 94536: Fremont | 887 | -121.987951 | 37.570977 | 72976 | |
| 4 | 4 | 2020-12-04 | Alameda | 1 | 94538: Fremont | 907 | -121.977924 | 37.499148 | 63911 | |
| 5 | 5 | 2020-12-04 | Alameda | 1 | 94539: Fremont | 322 | -121.912764 | 37.526588 | 52960 | |
| 6 | 6 | 2020-12-04 | Alameda | 1 | 94541: Hayward | 2182 | -122.084564 | 37.674639 | 65132 | |
| 7 | 7 | 2020-12-04 | Alameda | 1 | 94542: Hayward | 238 | -122.028059 | 37.65567 | 13973 | |
| 8 | 8 | 2020-12-04 | Alameda | 1 | 94544: Hayward | 2737 | -122.05668 | 37.633236 | 77121 | |
| 9 | 9 | 2020-12-04 | Alameda | 1 | 94545: Hayward | 759 | -122.118372 | 37.632165 | 31657 | |
| 10 | 10 | 2020-12-04 | Alameda | 1 | 94546: Castro Valley | 649 | -122.096829 | 37.753258 | 45536 | |
| 11 | 11 | 2020-12-04 | Alameda | 1 | 94550: Livermore | 730 | -121.62493 | 37.51205 | 50138 | |
| 12 | 12 | 2020-12-04 | Alameda | 1 | 94551: Livermore | 731 | -121.76451 | 37.748866 | 38986 | |
| 13 | 13 | 2020-12-04 | Alameda | 1 | 94552: Castro Valley | 143 | -122.008969 | 37.706498 | 15204 | |
| 14 | 14 | 2020-12-04 | Alameda | 1 | 94555: Fremont | 285 | -122.081325 | 37.547587 | 36037 | |
| 15 | 15 | 2020-12-04 | Alameda | 1 | 94560: Newark | 860 | -122.037397 | 37.518474 | 44245 | |
| 16 | 16 | 2020-12-04 | Alameda | 1 | 94566: Pleasanton | 471 | -121.855191 | 37.651123 | 45046 | |
| 17 | 17 | 2020-12-04 | Alameda | 1 | 94568: Dublin | 736 | -121.915511 | 37.71354 | 58399 | |
| 18 | 18 | 2020-12-04 | Alameda | 1 | 94577: San Leandro | 1010 | -122.164576 | 37.716583 | 48666 | |
| 19 | 19 | 2020-12-04 | Alameda | 1 | 94578: San Leandro | 1021 | -122.125289 | 37.706453 | 40150 | |
| 20 | 20 | 2020-12-04 | Alameda | 1 | 94579: San Leandro | 302 | -122.157702 | 37.68652 | 20237 | |
| 21 | 21 | 2020-12-04 | Alameda | 1 | 94580: San Lorenzo | 646 | -122.135476 | 37.67589 | 28970 | |
| 22 | 22 | 2020-12-04 | Alameda | 1 | 94586: Sunol | 13 | -121.869826 | 37.569565 | 797 | |
| 23 | 23 | 2020-12-04 | Alameda | 1 | 94587: Union City | 1278 | -122.045491 | 37.599605 | 72446 | |
| 24 | 24 | 2020-12-04 | Alameda | 1 | 94588: Pleasanton | 325 | -121.88085 | 37.718878 | 31895 | |
| 25 | 25 | 2020-12-04 | Alameda | 1 | 94601: Oakland | 2688 | -122.217961 | 37.776931 | 53261 | |
| 26 | 26 | 2020-12-04 | Alameda | 1 | 94602: Oakland | 485 | -122.207066 | 37.804071 | 29770 | |
| 27 | 27 | 2020-12-04 | Alameda | 1 | 94603: Oakland | 1810 | -122.176302 | 37.738989 | 33241 | |
| 28 | 28 | 2020-12-04 | Alameda | 1 | 94605: Oakland | 1035 | -122.148748 | 37.760229 | 42375 | |
| 29 | 29 | 2020-12-04 | Alameda | 1 | 94606: Oakland | 886 | -122.244658 | 37.792494 | 37076 | |
| 30 | 30 | 2020-12-04 | Alameda | 1 | 94607: Oakland | 495 | -122.298298 | 37.808141 | 26646 | |
| 31 | 31 | 2020-12-04 | Alameda | 1 | 94608: Emeryville | 433 | -122.284671 | 37.835737 | 31000 | |
| 32 | 32 | 2020-12-04 | Alameda | 1 | 94609: Oakland | 334 | -122.264066 | 37.834706 | 22293 | |
| 33 | 33 | 2020-12-04 | Alameda | 1 | 94610: Oakland | 268 | -122.240634 | 37.812036 | 30862 | |
| 34 | 34 | 2020-12-04 | Alameda | 1 | 94611: Oakland | 319 | -122.216308 | 37.831401 | 37826 | |
| 35 | 35 | 2020-12-04 | Alameda | 1 | 94612: Oakland | 191 | -122.267177 | 37.808639 | 17279 | |
| 36 | 36 | 2020-12-04 | Alameda | 1 | 94618: Oakland | 75 | -122.238063 | 37.844508 | 15545 | |
| 37 | 37 | 2020-12-04 | Alameda | 1 | 94619: Oakland | 503 | -122.173998 | 37.7918 | 24080 | |
| 38 | 38 | 2020-12-04 | Alameda | 1 | 94621: Oakland | 1799 | -122.207204 | 37.736444 | 32915 | |
| 39 | 39 | 2020-12-04 | Alameda | 1 | 94702: Berkeley | 162 | -122.28609 | 37.866037 | 16520 | |
| 40 | 40 | 2020-12-04 | Alameda | 1 | 94703: Berkeley | 231 | -122.275565 | 37.864148 | 19805 | |
| 41 | 41 | 2020-12-04 | Alameda | 1 | 94704: Berkeley | 264 | -122.253359 | 37.866491 | 29129 | |
| 42 | 42 | 2020-12-04 | Alameda | 1 | 94705: Berkeley | 94 | -122.240914 | 37.859326 | 13152 | |
| 43 | 43 | 2020-12-04 | Alameda | 1 | 94706: Albany | 102 | -122.295165 | 37.889943 | 19921 | |
| 44 | 44 | 2020-12-04 | Alameda | 1 | 94707: Berkeley | 52 | -122.279237 | 37.898243 | 12862 | |
| 45 | 45 | 2020-12-04 | Alameda | 1 | 94708: Berkeley | 37 | -122.259682 | 37.900305 | 11725 | |
| 46 | 46 | 2020-12-04 | Alameda | 1 | 94709: Berkeley | 53 | -122.266717 | 37.879134 | 11796 | |
| 47 | 47 | 2020-12-04 | Alameda | 1 | 94710: Berkeley | 287 | -122.303487 | 37.870693 | 8059 | |
| 48 | 48 | 2020-12-04 | Alameda | 1 | 94720: Berkeley | 25 | -122.243147 | 37.87522 | 1336 | |
| 49 | 49 | 2020-12-04 | Amador | 5 | Ione & surrounding unincorporated areas | 143 | -120.932778 | 38.352778 | ||
| 50 | 50 | 2020-12-04 | Amador | 5 | Jackson | 178 | -120.774167 | 38.348889 | ||
| 51 | 51 | 2020-12-04 | Amador | 5 | Pine Grove | 41 | -120.658889 | 38.413056 | ||
| 52 | 52 | 2020-12-04 | Amador | 5 | Pioneer | 47 | -120.571944 | 38.431944 | ||
| 53 | 53 | 2020-12-04 | Amador | 5 | Plymouth & surrounding unincorporated areas | 38 | -120.844722 | 38.481944 | ||
| 54 | 54 | 2020-12-04 | Amador | 5 | Sutter Creek & Amador City | 85 | -120.8025 | 38.393056 | ||
| 55 | 55 | 2020-12-04 | Amador | 5 | Volcano | 13 | -120.562377 | 38.409966 | ||
| 56 | 56 | 2020-12-04 | Butte | 7 | Biggs/Gridley | 428 | -121.705559 | 39.385866 | 8908 | |
| 57 | 57 | 2020-12-04 | Butte | 7 | Chico | 2733 | -121.837651 | 39.728494 | 91998 | |
| 58 | 58 | 2020-12-04 | Butte | 7 | Durham | 44 | -121.795876 | 39.664949 | 5863 | |
| 59 | 59 | 2020-12-04 | Butte | 7 | Oroville | 1006 | -121.556649 | 39.51384 | 19040 | |
| 60 | 60 | 2020-12-04 | Butte | 7 | Other | 86 | 33084 | |||
| 61 | 61 | 2020-12-04 | Butte | 7 | Ridge Communities | 120 | -121.580872 | 39.799577 | 39707 | |
| 62 | 62 | 2020-12-04 | Calaveras | 9 | District 1 | 223 | -120.829167 | 38.191667 | 9394 | |
| 63 | 63 | 2020-12-04 | Calaveras | 9 | District 2 | 45 | -120.540833 | 38.228333 | 8245 | |
| 64 | 64 | 2020-12-04 | Calaveras | 9 | District 3 | 67 | -120.076111 | 38.438889 | 9729 | |
| 65 | 65 | 2020-12-04 | Calaveras | 9 | District 4 | 105 | -120.641944 | 37.981111 | 9605 | |
| 66 | 66 | 2020-12-04 | Calaveras | 9 | District 5 | 115 | -120.866667 | 38.1 | 8605 | |
| 67 | 67 | 2020-12-04 | Contra Costa | 13 | Alamo | 210 | -122.032222 | 37.850278 | 14750 | |
| 68 | 68 | 2020-12-04 | Contra Costa | 13 | Antioch | 3293 | -121.805833 | 38.005 | 112520 | |
| 69 | 69 | 2020-12-04 | Contra Costa | 13 | Bay Point | 1162 | -121.961667 | 38.029167 | 22639 | |
| 70 | 70 | 2020-12-04 | Contra Costa | 13 | Bethel Island | 18 | -121.640556 | 38.015 | 2137 | |
| 71 | 71 | 2020-12-04 | Contra Costa | 13 | Brentwood | 1135 | -121.695833 | 37.931944 | 65118 | |
| 72 | 72 | 2020-12-04 | Contra Costa | 13 | Byron | 36 | -121.638056 | 37.867222 | 1325 | |
| 73 | 73 | 2020-12-04 | Contra Costa | 13 | Clayton | 122 | -121.935833 | 37.941111 | 11337 | |
| 74 | 74 | 2020-12-04 | Contra Costa | 13 | Concord | 3212 | -122.031111 | 37.978056 | 130143 | |
| 75 | 75 | 2020-12-04 | Contra Costa | 13 | Crockett | 34 | -122.213056 | 38.0525 | 3044 | |
| 76 | 76 | 2020-12-04 | Contra Costa | 13 | Danville | 634 | -122.0 | 37.821667 | 43876 | |
| 77 | 77 | 2020-12-04 | Contra Costa | 13 | Discovery Bay | 246 | -121.600278 | 37.908611 | 13352 | |
| 78 | 78 | 2020-12-04 | Contra Costa | 13 | El Cerrito | 220 | -122.311667 | 37.915833 | 24953 | |
| 79 | 79 | 2020-12-04 | Contra Costa | 13 | El Sobrante | 445 | -122.295278 | 37.977222 | 12669 | |
| 80 | 80 | 2020-12-04 | Contra Costa | 13 | Hercules | 416 | -122.288611 | 38.017222 | 25530 | |
| 81 | 81 | 2020-12-04 | Contra Costa | 13 | Kensington | 19 | -122.280278 | 37.910556 | ||
| 82 | 82 | 2020-12-04 | Contra Costa | 13 | Lafayette | 265 | -122.118056 | 37.885833 | 25604 | |
| 83 | 83 | 2020-12-04 | Contra Costa | 13 | Martinez | 604 | -122.134167 | 38.019444 | 37106 | |
| 84 | 84 | 2020-12-04 | Contra Costa | 13 | Moraga | 118 | -122.129722 | 37.835 | 16946 | |
| 85 | 85 | 2020-12-04 | Contra Costa | 13 | Oakley | 874 | -121.7125 | 37.9975 | 42461 | |
| 86 | 86 | 2020-12-04 | Contra Costa | 13 | Orinda | 203 | -122.179722 | 37.882778 | 19009 | |
| 87 | 87 | 2020-12-04 | Contra Costa | 13 | Other | 246 | ||||
| 88 | 88 | 2020-12-04 | Contra Costa | 13 | Pacheco | 85 | -122.075278 | 37.983611 | 3685 | |
| 89 | 89 | 2020-12-04 | Contra Costa | 13 | Pinole | 381 | -122.291111 | 38.004444 | 19505 | |
| 90 | 90 | 2020-12-04 | Contra Costa | 13 | Pittsburg | 2683 | -121.884722 | 38.028056 | 74321 | |
| 91 | 91 | 2020-12-04 | Contra Costa | 13 | Pleasant Hill | 448 | -122.0525 | 37.948056 | 34267 | |
| 92 | 92 | 2020-12-04 | Contra Costa | 13 | Richmond | 4589 | -122.347778 | 37.935833 | 111217 | |
| 93 | 93 | 2020-12-04 | Contra Costa | 13 | Rodeo | 194 | -122.266944 | 38.033056 | 8679 | |
| 94 | 94 | 2020-12-04 | Contra Costa | 13 | San Pablo | 2163 | -122.345556 | 37.962222 | 31413 | |
| 95 | 95 | 2020-12-04 | Contra Costa | 13 | San Ramon | 731 | -121.978056 | 37.78 | 83118 | |
| 96 | 96 | 2020-12-04 | Contra Costa | 13 | Walnut Creek | 982 | -122.065 | 37.906389 | 70860 | |
| 97 | 97 | 2020-12-04 | Del Norte | 15 | Crescent City | 210 | -124.2 | 41.75 | 8723 | |
| 98 | 98 | 2020-12-04 | Del Norte | 15 | Fort Dick-Smith River | 82 | -124.148889 | 41.867778 | 1462 | |
| 99 | 99 | 2020-12-04 | Del Norte | 15 | Hiouchi-Gasquet-Big Flat | 18 | -124.071944 | 41.7925 | 1053 | |
| 100 | 100 | 2020-12-04 | Del Norte | 15 | Klamath | 3 | -124.038333 | 41.526389 | 617 |
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 );