latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,276 rows where "date" is on date 2021-12-03 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
492150 | 492150 | Dinuba | Dinuba | 2021-12-03 | Fresno | 19 | 0 | 0 | |
492154 | 492154 | Five Points | Five Points | 2021-12-03 | Fresno | 19 | 23 | 0 | |
492165 | 492165 | Prather | Prather | 2021-12-03 | Fresno | 19 | 107 | 0 | |
492175 | 492175 | 92222 | 92222: Bard | 2021-12-03 | Imperial | 25 | 11 | 0 | |
492180 | 492180 | 92244 | 92244: El Centro | 2021-12-03 | Imperial | 25 | 111 | 0 | |
492253 | 492253 | 95424 | 95424 | 2021-12-03 | Lake | 33 | 25 | 0 | |
492569 | 492569 | Unincorporated - Padua Hills | Padua Hills | 2021-12-03 | Los Angeles | 37 | 14 | 0 | |
492607 | 492607 | Unincorporated - West Chatsworth | West Chatsworth | 2021-12-03 | Los Angeles | 37 | 4 | 0 | |
492701 | 492701 | 93912 | 93912: Boronda | 2021-12-03 | Monterey | 53 | 148 | 0 | |
492704 | 492704 | 93922 | 93922: Carmel | 2021-12-03 | Monterey | 53 | 31 | 0 | |
492713 | 492713 | 93942 | 93942: Monterey | 2021-12-03 | Monterey | 53 | 40 | 0 | |
492740 | 492740 | 95602 | 95602: Auburn | 2021-12-03 | Nevada | 57 | 461 | 0 | |
492741 | 492741 | 95712 | 95712: Chicago Park | 2021-12-03 | Nevada | 57 | 27 | 0 | |
492744 | 492744 | 95924 | 95924: Cedar Ridge | 2021-12-03 | Nevada | 57 | 73 | 0 | |
492751 | 492751 | 95977 | 95977: Smartville | 2021-12-03 | Nevada | 57 | 76 | 0 | |
492754 | 492754 | 96160 | 96160: Truckee | 2021-12-03 | Nevada | 57 | 166 | 0 | |
492756 | 492756 | 96162 | 96162: Truckee | 2021-12-03 | Nevada | 57 | 124 | 0 | |
492784 | 492784 | Rancho Mission Viejo | Rancho Mission Viejo | 2021-12-03 | Orange | 59 | 520 | 0 | |
492791 | 492791 | Silverado | Silverado | 2021-12-03 | Orange | 59 | 136 | 0 | |
492793 | 492793 | Trabuco Canyon | Trabuco Canyon | 2021-12-03 | Orange | 59 | 1436 | 0 | |
492814 | 492814 | 95715 | 95715: Emigrant Gap | 2021-12-03 | Placer | 61 | 13 | 0 | |
492815 | 492815 | 95717 | 95717: Gold Run | 2021-12-03 | Placer | 61 | 6 | 0 | |
492817 | 492817 | 95724 | 95724: Norden | 2021-12-03 | Placer | 61 | 6 | 0 | |
492823 | 492823 | 96142 | 96142: Tahoma | 2021-12-03 | Placer | 61 | 5 | 5 or fewer | 0 |
492829 | 492829 | 96162 | 96162: Truckee | 2021-12-03 | Placer | 61 | 5 | 5 or fewer | 0 |
492925 | 492925 | Havasu Lake | Havasu Lake | 2021-12-03 | San Bernardino | 71 | 0 | 0 | |
492970 | 492970 | 91916 | 91916: Descanso | 2021-12-03 | San Diego | 73 | 159 | 0 | |
492971 | 492971 | 91917 | 91917: Dulzura | 2021-12-03 | San Diego | 73 | 197 | 0 | |
492972 | 492972 | 91931 | 91931: Guatay | 2021-12-03 | San Diego | 73 | 24 | 0 | |
492974 | 492974 | 91934 | 91934: Jacumba | 2021-12-03 | San Diego | 73 | 60 | 0 | |
492975 | 492975 | 91935 | 91935: Jamul | 2021-12-03 | San Diego | 73 | 1039 | 0 | |
492980 | 492980 | 91962 | 91962: Pine Valley | 2021-12-03 | San Diego | 73 | 170 | 0 | |
492981 | 492981 | 91963 | 91963: Potrero | 2021-12-03 | San Diego | 73 | 226 | 0 | |
492983 | 492983 | 91978 | 91978: Spring Valley | 2021-12-03 | San Diego | 73 | 1235 | 0 | |
492984 | 492984 | 91980 | 91980: Tecate | 2021-12-03 | San Diego | 73 | 185 | 0 | |
492985 | 492985 | 92003 | 92003: Bonsall | 2021-12-03 | San Diego | 73 | 423 | 0 | |
492986 | 492986 | 92004 | 92004: Borrego Springs | 2021-12-03 | San Diego | 73 | 171 | 0 | |
493002 | 493002 | 92036 | 92036: Julian | 2021-12-03 | San Diego | 73 | 241 | 0 | |
493010 | 493010 | 92059 | 92059: Pala | 2021-12-03 | San Diego | 73 | 337 | 0 | |
493011 | 493011 | 92060 | 92060: Palomar Mountain | 2021-12-03 | San Diego | 73 | 36 | 0 | |
493012 | 493012 | 92061 | 92061: Pauma Valley | 2021-12-03 | San Diego | 73 | 333 | 0 | |
493015 | 493015 | 92066 | 92066: Ranchita | 2021-12-03 | San Diego | 73 | 19 | 0 | |
493016 | 493016 | 92067 | 92067: Rancho Santa Fe | 2021-12-03 | San Diego | 73 | 642 | 0 | |
493018 | 493018 | 92070 | 92070: Santa Ysabel | 2021-12-03 | San Diego | 73 | 145 | 0 | |
493026 | 493026 | 92086 | 92086: Warner Springs | 2021-12-03 | San Diego | 73 | 74 | 0 | |
493027 | 493027 | 92091 | 92091: Rancho Santa Fe | 2021-12-03 | San Diego | 73 | 58 | 0 | |
493029 | 493029 | 92096 | 92096: San Marcos | 2021-12-03 | San Diego | 73 | 7 | 0 | |
493049 | 493049 | 92121 | 92121: San Diego | 2021-12-03 | San Diego | 73 | 315 | 0 | |
493059 | 493059 | 92134 | 92134: San Diego | 2021-12-03 | San Diego | 73 | 47 | 0 | |
493060 | 493060 | 92135 | 92135: Coronado | 2021-12-03 | San Diego | 73 | 109 | 0 | |
493063 | 493063 | 92140 | 92140: San Diego | 2021-12-03 | San Diego | 73 | 136 | 0 | |
493064 | 493064 | 92145 | 92145: San Diego | 2021-12-03 | San Diego | 73 | 17 | 0 | |
493066 | 493066 | 92155 | 92155: Coronado | 2021-12-03 | San Diego | 73 | 41 | 0 | |
493068 | 493068 | 92182 | 92182: San Diego | 2021-12-03 | San Diego | 73 | 46 | 0 | |
493069 | 493069 | 92536 | 92536: Aguanga | 2021-12-03 | San Diego | 73 | 9 | 0 | |
493070 | 493070 | 92672 | 92672: San Clemente | 2021-12-03 | San Diego | 73 | 4 | 0 | |
493073 | 493073 | 91905 | 91905: Boulevard | 2021-12-03 | San Diego | 73 | 116 | 0 | |
493074 | 493074 | 91906 | 91906: Campo | 2021-12-03 | San Diego | 73 | 492 | 0 | |
493102 | 493102 | ASH (patients) | ASH (patients) | 2021-12-03 | San Luis Obispo | 79 | 212 | 0 | |
493106 | 493106 | CMC (Inmates) | CMC (Inmates) | 2021-12-03 | San Luis Obispo | 79 | 2383 | 0 | |
493107 | 493107 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2021-12-03 | San Luis Obispo | 79 | 714 | 0 | |
493158 | 493158 | Lompoc Federal Prison | Lompoc Federal Prison | 2021-12-03 | Santa Barbara | 83 | 1094 | 0 | |
493242 | 493242 | 93212 | Corcoran, Angiola: 93212 | 2021-12-03 | Tulare | 107 | 21 | 0 | |
493266 | 493266 | 93646 | Traver: 93646 | 2021-12-03 | Tulare | 107 | 40 | 0 | |
493268 | 493268 | 93654 | Orosi: 93654 | 2021-12-03 | Tulare | 107 | 124 | 0 | |
492544 | 492544 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-12-03 | Los Angeles | 37 | 1 | 1 | |
492556 | 492556 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-12-03 | Los Angeles | 37 | 0 | 1 | |
492541 | 492541 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-12-03 | Los Angeles | 37 | 1 | 12 | |
492616 | 492616 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-12-03 | Los Angeles | 37 | 54 | 12 | |
492255 | 492255 | 95435 | 95435 | 2021-12-03 | Lake | 33 | 48 | 14 | |
492742 | 492742 | 95724 | 95724: Norden | 2021-12-03 | Nevada | 57 | 9 | 9 or fewer | 20 |
492224 | 492224 | 93519 | 93519: Cantil | 2021-12-03 | Kern | 29 | 1 | 28 | |
493110 | 493110 | Creston | Creston | 2021-12-03 | San Luis Obispo | 79 | 124 | 30 | |
492087 | 492087 | Volcano | Volcano | 2021-12-03 | Amador | 5 | 65 | 44 | |
492752 | 492752 | 95986 | 95986: Washington | 2021-12-03 | Nevada | 57 | 9 | 9 or fewer | 53 |
492208 | 492208 | 93287 | 93287: Woody | 2021-12-03 | Kern | 29 | 17 | 74 | |
492185 | 492185 | 92259 | 92259: Ocotillo | 2021-12-03 | Imperial | 25 | 20 | 94 | |
492753 | 492753 | 96111 | 96111: Floriston | 2021-12-03 | Nevada | 57 | 9 | 9 or fewer | 94 |
492186 | 492186 | 92266 | 92266: Palo Verde | 2021-12-03 | Imperial | 25 | 9 | 108 | |
492518 | 492518 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2021-12-03 | Los Angeles | 37 | 52 | 108 | |
492533 | 492533 | Unincorporated - East Lancaster | East Lancaster | 2021-12-03 | Los Angeles | 37 | 19 | 114 | |
492236 | 492236 | 93528 | 93528: Johannesburg | 2021-12-03 | Kern | 29 | 7 | 124 | |
492238 | 492238 | 93554 | 93554: Randsburg | 2021-12-03 | Kern | 29 | 10 | 143 | |
492589 | 492589 | Unincorporated - Saugus | Saugus | 2021-12-03 | Los Angeles | 37 | 179 | 155 | |
492204 | 492204 | 93276 | 93276: Tupman | 2021-12-03 | Kern | 29 | 38 | 159 | |
492098 | 492098 | 95232, 95245 | 95232, 95245 | 2021-12-03 | Calaveras | 9 | 167 | 161 | |
492226 | 492226 | 93524 | 93524: Edwards | 2021-12-03 | Kern | 29 | 41 | 168 | |
493138 | 493138 | Loma Mar | Loma Mar | 2021-12-03 | San Mateo | 81 | 9 | 9 or fewer | 172 |
492192 | 492192 | 93226 | 93226: Glennville | 2021-12-03 | Kern | 29 | 25 | 195 | |
492362 | 492362 | City of Vernon | Vernon | 2021-12-03 | Los Angeles | 37 | 143 | 209 | |
492065 | 492065 | 94613 | 94613: Oakland | 2021-12-03 | Alameda | 1 | 4 | 212 | |
492733 | 492733 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-12-03 | Napa | 55 | 20 | 212 | |
493144 | 493144 | Pescadero | Pescadero | 2021-12-03 | San Mateo | 81 | 68 | 219 | |
492565 | 492565 | Unincorporated - Newhall | Newhall | 2021-12-03 | Los Angeles | 37 | 70 | 220 | |
492743 | 492743 | 95728 | 95728: Soda Springs | 2021-12-03 | Nevada | 57 | 38 | 229 | |
492265 | 492265 | 95493 | 95493 | 2021-12-03 | Lake | 33 | 12 | 241 | |
492199 | 492199 | 93251 | 93251: Mc Kittrick | 2021-12-03 | Kern | 29 | 29 | 243 | |
492587 | 492587 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2021-12-03 | Los Angeles | 37 | 257 | 267 | |
492256 | 492256 | 95443 | 95443 | 2021-12-03 | Lake | 33 | 14 | 270 | |
493216 | 493216 | 95450 | 95450: Jenner | 2021-12-03 | Sonoma | 97 | 12 | 298 |
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] INTEGER );