latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,029 rows where "date" is on date 2020-04-24 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 27
county 27
- Los Angeles 353
- San Diego 110
- Riverside 64
- San Bernardino 64
- Alameda 53
- Orange 41
- Fresno 32
- Placer 32
- Sonoma 32
- Contra Costa 30
- Tulare 28
- San Francisco 26
- Ventura 25
- San Luis Obispo 22
- Napa 18
- Santa Clara 15
- Santa Barbara 11
- Merced 10
- Stanislaus 10
- Kings 9
- El Dorado 8
- Sacramento 8
- Solano 8
- Amador 7
- Butte 5
- Yolo 5
- Mono 3
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
1218189 | 1218189 | Dos Palos | Dos Palos | 2020-04-24 | Fresno | 19 | 0 | ||
1218190 | 1218190 | Dunlap | Dunlap | 2020-04-24 | Fresno | 19 | 0 | ||
1218216 | 1218216 | Correctional facilities | Prisons | 2020-04-24 | Kings | 31 | 0 | ||
1218221 | 1218221 | Unincorporated | Other | 2020-04-24 | Kings | 31 | 4 | 4 or fewer | |
1218748 | 1218748 | Outside of Cities | Other | 2020-04-24 | Sacramento | 67 | 175 | ||
1219048 | 1219048 | unincorporated | Other | 2020-04-24 | Stanislaus | 99 | 48 | ||
1219103 | 1219103 | Unincorporated | Other | 2020-04-24 | Yolo | 113 | 0 | ||
1218188 | 1218188 | Dinuba | Dinuba | 2020-04-24 | Fresno | 19 | 0 | 0 | |
1218192 | 1218192 | Five Points | Five Points | 2020-04-24 | Fresno | 19 | 0 | 0 | |
1218203 | 1218203 | Prather | Prather | 2020-04-24 | Fresno | 19 | 0 | 0 | |
1218525 | 1218525 | Unincorporated - Padua Hills | Padua Hills | 2020-04-24 | Los Angeles | 37 | 0 | 0 | |
1218563 | 1218563 | Unincorporated - West Chatsworth | West Chatsworth | 2020-04-24 | Los Angeles | 37 | 0 | 0 | |
1218633 | 1218633 | Rancho Mission Viejo | Rancho Mission Viejo | 2020-04-24 | Orange | 59 | 6 | 0 | |
1218640 | 1218640 | Silverado | Silverado | 2020-04-24 | Orange | 59 | 0 | 0 | |
1218642 | 1218642 | Trabuco Canyon | Trabuco Canyon | 2020-04-24 | Orange | 59 | 10 | 0 | |
1218663 | 1218663 | 95715 | 95715: Emigrant Gap | 2020-04-24 | Placer | 61 | 0 | 0 | |
1218664 | 1218664 | 95717 | 95717: Gold Run | 2020-04-24 | Placer | 61 | 0 | 0 | |
1218666 | 1218666 | 95724 | 95724: Norden | 2020-04-24 | Placer | 61 | 0 | 0 | |
1218672 | 1218672 | 96142 | 96142: Tahoma | 2020-04-24 | Placer | 61 | 0 | 0 | |
1218678 | 1218678 | 96162 | 96162: Truckee | 2020-04-24 | Placer | 61 | 0 | 0 | |
1218774 | 1218774 | Havasu Lake | Havasu Lake | 2020-04-24 | San Bernardino | 71 | 0 | 0 | |
1218819 | 1218819 | 91916 | 91916: Descanso | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218820 | 1218820 | 91917 | 91917: Dulzura | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218821 | 1218821 | 91931 | 91931: Guatay | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218823 | 1218823 | 91934 | 91934: Jacumba | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218824 | 1218824 | 91935 | 91935: Jamul | 2020-04-24 | San Diego | 73 | 6 | 0 | |
1218829 | 1218829 | 91962 | 91962: Pine Valley | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218830 | 1218830 | 91963 | 91963: Potrero | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218832 | 1218832 | 91978 | 91978: Spring Valley | 2020-04-24 | San Diego | 73 | 8 | 0 | |
1218833 | 1218833 | 91980 | 91980: Tecate | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218834 | 1218834 | 92003 | 92003: Bonsall | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218835 | 1218835 | 92004 | 92004: Borrego Springs | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218851 | 1218851 | 92036 | 92036: Julian | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218859 | 1218859 | 92059 | 92059: Pala | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218860 | 1218860 | 92060 | 92060: Palomar Mountain | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218861 | 1218861 | 92061 | 92061: Pauma Valley | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218864 | 1218864 | 92066 | 92066: Ranchita | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218865 | 1218865 | 92067 | 92067: Rancho Santa Fe | 2020-04-24 | San Diego | 73 | 12 | 0 | |
1218867 | 1218867 | 92070 | 92070: Santa Ysabel | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218875 | 1218875 | 92086 | 92086: Warner Springs | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218876 | 1218876 | 92091 | 92091: Rancho Santa Fe | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218878 | 1218878 | 92096 | 92096: San Marcos | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218898 | 1218898 | 92121 | 92121: San Diego | 2020-04-24 | San Diego | 73 | 3 | 0 | |
1218908 | 1218908 | 92134 | 92134: San Diego | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218909 | 1218909 | 92135 | 92135: Coronado | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218912 | 1218912 | 92140 | 92140: San Diego | 2020-04-24 | San Diego | 73 | 14 | 0 | |
1218913 | 1218913 | 92145 | 92145: San Diego | 2020-04-24 | San Diego | 73 | 3 | 0 | |
1218915 | 1218915 | 92155 | 92155: Coronado | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218917 | 1218917 | 92182 | 92182: San Diego | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218918 | 1218918 | 92536 | 92536: Aguanga | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218919 | 1218919 | 92672 | 92672: San Clemente | 2020-04-24 | San Diego | 73 | 0 | 0 | |
1218922 | 1218922 | 91905 | 91905: Boulevard | 2020-04-24 | San Diego | 73 | 2 | 0 | |
1218923 | 1218923 | 91906 | 91906: Campo | 2020-04-24 | San Diego | 73 | 1 | 0 | |
1218951 | 1218951 | ASH (patients) | ASH (patients) | 2020-04-24 | San Luis Obispo | 79 | 0 | 0 | |
1218955 | 1218955 | CMC (Inmates) | CMC (Inmates) | 2020-04-24 | San Luis Obispo | 79 | 0 | 0 | |
1218956 | 1218956 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2020-04-24 | San Luis Obispo | 79 | 0 | 0 | |
1218977 | 1218977 | Lompoc Federal Prison | Lompoc Federal Prison | 2020-04-24 | Santa Barbara | 83 | 101 | 0 | |
1219050 | 1219050 | 93212 | Corcoran, Angiola: 93212 | 2020-04-24 | Tulare | 107 | 10 | 10 or fewer | 0 |
1219074 | 1219074 | 93646 | Traver: 93646 | 2020-04-24 | Tulare | 107 | 10 | 10 or fewer | 0 |
1219076 | 1219076 | 93654 | Orosi: 93654 | 2020-04-24 | Tulare | 107 | 10 | 10 or fewer | 0 |
1218500 | 1218500 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2020-04-24 | Los Angeles | 37 | 0 | 1 | |
1218512 | 1218512 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2020-04-24 | Los Angeles | 37 | 0 | 1 | |
1218757 | 1218757 | Big Bear City | Big Bear City | 2020-04-24 | San Bernardino | 71 | 2 | 10045 | |
1218978 | 1218978 | North County | North County | 2020-04-24 | Santa Barbara | 83 | 24 | 10096 | |
1219052 | 1219052 | 93219 | Earlimart: 93219 | 2020-04-24 | Tulare | 107 | 10 | 10 or fewer | 10167 |
1218356 | 1218356 | Los Angeles - Elysian Valley | Elysian Valley | 2020-04-24 | Los Angeles | 37 | 18 | 10171 | |
1218595 | 1218595 | East Napa Area | East Napa Area | 2020-04-24 | Napa | 55 | 1 | 10237 | |
1218995 | 1218995 | San Jose | San Jose | 2020-04-24 | Santa Clara | 85 | 1344 | 1026658 | |
1218179 | 1218179 | South County | South County | 2020-04-24 | El Dorado | 17 | 0 | 10345 | |
1218710 | 1218710 | Jurupa Valley | Jurupa Valley | 2020-04-24 | Riverside | 65 | 100 | 103784 | |
1218801 | 1218801 | Rialto | Rialto | 2020-04-24 | San Bernardino | 71 | 72 | 103884 | |
1219023 | 1219023 | 95425 | 95425: Cloverdale | 2020-04-24 | Sonoma | 97 | 10 | 10 or fewer | 10586 |
1218962 | 1218962 | Morro Bay | Morro Bay | 2020-04-24 | San Luis Obispo | 79 | 6 | 10592 | |
1218421 | 1218421 | Los Angeles - South Carthay | South Carthay | 2020-04-24 | Los Angeles | 37 | 22 | 10595 | |
1218584 | 1218584 | Winton | Winton | 2020-04-24 | Merced | 47 | 5 | 10613 | |
1218250 | 1218250 | City of Bradbury | Bradbury | 2020-04-24 | Los Angeles | 37 | 4 | 1 to 4 | 1069 |
1218251 | 1218251 | City of Burbank | Burbank | 2020-04-24 | Los Angeles | 37 | 203 | 107180 | |
1218473 | 1218473 | Unincorporated - Bouquet Canyon | Bouquet Canyon | 2020-04-24 | Los Angeles | 37 | 4 | 1 to 4 | 1073 |
1219054 | 1219054 | 93223 | Farmersville: 93223 | 2020-04-24 | Tulare | 107 | 15 | 10742 | |
1218576 | 1218576 | Delhi | Delhi | 2020-04-24 | Merced | 47 | 11 | 10755 | |
1218293 | 1218293 | City of Norwalk | Norwalk | 2020-04-24 | Los Angeles | 37 | 155 | 107622 | |
1218364 | 1218364 | Los Angeles - Gramercy Place | Gramercy Place | 2020-04-24 | Los Angeles | 37 | 24 | 10764 | |
1218474 | 1218474 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2020-04-24 | Los Angeles | 37 | 0 | 108 | |
1218320 | 1218320 | City of West Covina | West Covina | 2020-04-24 | Los Angeles | 37 | 98 | 108235 | |
1219075 | 1219075 | 93647 | Orosi: 93647 | 2020-04-24 | Tulare | 107 | 10 | 10 or fewer | 10896 |
1218410 | 1218410 | Los Angeles - Playa Vista | Playa Vista | 2020-04-24 | Los Angeles | 37 | 16 | 10947 | |
1218502 | 1218502 | Unincorporated - Hi Vista | Hi Vista | 2020-04-24 | Los Angeles | 37 | 0 | 1098 | |
1218311 | 1218311 | City of Sierra Madre | Sierra Madre | 2020-04-24 | Los Angeles | 37 | 5 | 10989 | |
1218686 | 1218686 | Canyon Lake | Canyon Lake | 2020-04-24 | Riverside | 65 | 9 | 11106 | |
1219042 | 1219042 | Newman | Newman | 2020-04-24 | Stanislaus | 99 | 9 | 11119 | |
1218168 | 1218168 | Richmond | Richmond | 2020-04-24 | Contra Costa | 13 | 88 | 111217 | |
1218721 | 1218721 | Murrieta | Murrieta | 2020-04-24 | Riverside | 65 | 89 | 111427 | |
1218635 | 1218635 | Rossmoor | Rossmoor | 2020-04-24 | Orange | 59 | 0 | 11160 | |
1218734 | 1218734 | Temecula | Temecula | 2020-04-24 | Riverside | 65 | 88 | 112230 | |
1218183 | 1218183 | Cantua Creek | Cantua Creek | 2020-04-24 | Fresno | 19 | 0 | 1125 | |
1218144 | 1218144 | Antioch | Antioch | 2020-04-24 | Contra Costa | 13 | 60 | 112520 | |
1218877 | 1218877 | 92093 | 92093: La Jolla | 2020-04-24 | San Diego | 73 | 4 | 11299 | |
1218212 | 1218212 | Tranquillity | Tranquillity | 2020-04-24 | Fresno | 19 | 0 | 1132 | |
1218201 | 1218201 | Orange Cove | Orange Cove | 2020-04-24 | Fresno | 19 | 7 | 11320 | |
1218149 | 1218149 | Clayton | Clayton | 2020-04-24 | Contra Costa | 13 | 5 | 11337 |
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 );