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-01-25 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
890262 | 890262 | Dinuba | Dinuba | 2021-01-25 | Fresno | 19 | 0 | 0 | |
890266 | 890266 | Five Points | Five Points | 2021-01-25 | Fresno | 19 | 23 | 0 | |
890277 | 890277 | Prather | Prather | 2021-01-25 | Fresno | 19 | 16 | 0 | |
890287 | 890287 | 92222 | 92222: Bard | 2021-01-25 | Imperial | 25 | 5 | 0 | |
890292 | 890292 | 92244 | 92244: El Centro | 2021-01-25 | Imperial | 25 | 87 | 0 | |
890365 | 890365 | 95424 | 95424 | 2021-01-25 | Lake | 33 | 9 | 0 | |
890681 | 890681 | Unincorporated - Padua Hills | Padua Hills | 2021-01-25 | Los Angeles | 37 | 7 | 0 | |
890719 | 890719 | Unincorporated - West Chatsworth | West Chatsworth | 2021-01-25 | Los Angeles | 37 | 1 | 0 | |
890813 | 890813 | 93912 | 93912: Boronda | 2021-01-25 | Monterey | 53 | 103 | 0 | |
890816 | 890816 | 93922 | 93922: Carmel | 2021-01-25 | Monterey | 53 | 0 | 0 | |
890825 | 890825 | 93942 | 93942: Monterey | 2021-01-25 | Monterey | 53 | 26 | 0 | |
890852 | 890852 | 95602 | 95602: Auburn | 2021-01-25 | Nevada | 57 | 170 | 0 | |
890853 | 890853 | 95712 | 95712: Chicago Park | 2021-01-25 | Nevada | 57 | 11 | 0 | |
890856 | 890856 | 95924 | 95924: Cedar Ridge | 2021-01-25 | Nevada | 57 | 33 | 0 | |
890863 | 890863 | 95977 | 95977: Smartville | 2021-01-25 | Nevada | 57 | 18 | 0 | |
890866 | 890866 | 96160 | 96160: Truckee | 2021-01-25 | Nevada | 57 | 77 | 0 | |
890868 | 890868 | 96162 | 96162: Truckee | 2021-01-25 | Nevada | 57 | 59 | 0 | |
890896 | 890896 | Rancho Mission Viejo | Rancho Mission Viejo | 2021-01-25 | Orange | 59 | 272 | 0 | |
890903 | 890903 | Silverado | Silverado | 2021-01-25 | Orange | 59 | 81 | 0 | |
890905 | 890905 | Trabuco Canyon | Trabuco Canyon | 2021-01-25 | Orange | 59 | 793 | 0 | |
890926 | 890926 | 95715 | 95715: Emigrant Gap | 2021-01-25 | Placer | 61 | 5 | 5 or fewer | 0 |
890927 | 890927 | 95717 | 95717: Gold Run | 2021-01-25 | Placer | 61 | 5 | 5 or fewer | 0 |
890929 | 890929 | 95724 | 95724: Norden | 2021-01-25 | Placer | 61 | 5 | 5 or fewer | 0 |
890935 | 890935 | 96142 | 96142: Tahoma | 2021-01-25 | Placer | 61 | 5 | 5 or fewer | 0 |
890941 | 890941 | 96162 | 96162: Truckee | 2021-01-25 | Placer | 61 | 5 | 5 or fewer | 0 |
891037 | 891037 | Havasu Lake | Havasu Lake | 2021-01-25 | San Bernardino | 71 | 0 | 0 | |
891082 | 891082 | 91916 | 91916: Descanso | 2021-01-25 | San Diego | 73 | 72 | 0 | |
891083 | 891083 | 91917 | 91917: Dulzura | 2021-01-25 | San Diego | 73 | 163 | 0 | |
891084 | 891084 | 91931 | 91931: Guatay | 2021-01-25 | San Diego | 73 | 10 | 0 | |
891086 | 891086 | 91934 | 91934: Jacumba | 2021-01-25 | San Diego | 73 | 32 | 0 | |
891087 | 891087 | 91935 | 91935: Jamul | 2021-01-25 | San Diego | 73 | 531 | 0 | |
891092 | 891092 | 91962 | 91962: Pine Valley | 2021-01-25 | San Diego | 73 | 78 | 0 | |
891093 | 891093 | 91963 | 91963: Potrero | 2021-01-25 | San Diego | 73 | 169 | 0 | |
891095 | 891095 | 91978 | 91978: Spring Valley | 2021-01-25 | San Diego | 73 | 677 | 0 | |
891096 | 891096 | 91980 | 91980: Tecate | 2021-01-25 | San Diego | 73 | 166 | 0 | |
891097 | 891097 | 92003 | 92003: Bonsall | 2021-01-25 | San Diego | 73 | 227 | 0 | |
891098 | 891098 | 92004 | 92004: Borrego Springs | 2021-01-25 | San Diego | 73 | 119 | 0 | |
891114 | 891114 | 92036 | 92036: Julian | 2021-01-25 | San Diego | 73 | 81 | 0 | |
891122 | 891122 | 92059 | 92059: Pala | 2021-01-25 | San Diego | 73 | 230 | 0 | |
891123 | 891123 | 92060 | 92060: Palomar Mountain | 2021-01-25 | San Diego | 73 | 17 | 0 | |
891124 | 891124 | 92061 | 92061: Pauma Valley | 2021-01-25 | San Diego | 73 | 187 | 0 | |
891127 | 891127 | 92066 | 92066: Ranchita | 2021-01-25 | San Diego | 73 | 12 | 0 | |
891128 | 891128 | 92067 | 92067: Rancho Santa Fe | 2021-01-25 | San Diego | 73 | 303 | 0 | |
891130 | 891130 | 92070 | 92070: Santa Ysabel | 2021-01-25 | San Diego | 73 | 55 | 0 | |
891138 | 891138 | 92086 | 92086: Warner Springs | 2021-01-25 | San Diego | 73 | 52 | 0 | |
891139 | 891139 | 92091 | 92091: Rancho Santa Fe | 2021-01-25 | San Diego | 73 | 30 | 0 | |
891141 | 891141 | 92096 | 92096: San Marcos | 2021-01-25 | San Diego | 73 | 5 | 0 | |
891161 | 891161 | 92121 | 92121: San Diego | 2021-01-25 | San Diego | 73 | 145 | 0 | |
891171 | 891171 | 92134 | 92134: San Diego | 2021-01-25 | San Diego | 73 | 34 | 0 | |
891172 | 891172 | 92135 | 92135: Coronado | 2021-01-25 | San Diego | 73 | 74 | 0 | |
891175 | 891175 | 92140 | 92140: San Diego | 2021-01-25 | San Diego | 73 | 106 | 0 | |
891176 | 891176 | 92145 | 92145: San Diego | 2021-01-25 | San Diego | 73 | 12 | 0 | |
891178 | 891178 | 92155 | 92155: Coronado | 2021-01-25 | San Diego | 73 | 15 | 0 | |
891180 | 891180 | 92182 | 92182: San Diego | 2021-01-25 | San Diego | 73 | 21 | 0 | |
891181 | 891181 | 92536 | 92536: Aguanga | 2021-01-25 | San Diego | 73 | 5 | 0 | |
891182 | 891182 | 92672 | 92672: San Clemente | 2021-01-25 | San Diego | 73 | 43 | 0 | |
891185 | 891185 | 91905 | 91905: Boulevard | 2021-01-25 | San Diego | 73 | 58 | 0 | |
891186 | 891186 | 91906 | 91906: Campo | 2021-01-25 | San Diego | 73 | 242 | 0 | |
891214 | 891214 | ASH (patients) | ASH (patients) | 2021-01-25 | San Luis Obispo | 79 | 202 | 0 | |
891218 | 891218 | CMC (Inmates) | CMC (Inmates) | 2021-01-25 | San Luis Obispo | 79 | 2290 | 0 | |
891219 | 891219 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2021-01-25 | San Luis Obispo | 79 | 325 | 0 | |
891270 | 891270 | Lompoc Federal Prison | Lompoc Federal Prison | 2021-01-25 | Santa Barbara | 83 | 1078 | 0 | |
891354 | 891354 | 93212 | Corcoran, Angiola: 93212 | 2021-01-25 | Tulare | 107 | 10 | 0 | |
891378 | 891378 | 93646 | Traver: 93646 | 2021-01-25 | Tulare | 107 | 17 | 0 | |
891380 | 891380 | 93654 | Orosi: 93654 | 2021-01-25 | Tulare | 107 | 50 | 0 | |
890656 | 890656 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-01-25 | Los Angeles | 37 | 1 | 1 | |
890668 | 890668 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-01-25 | Los Angeles | 37 | 0 | 1 | |
890653 | 890653 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-01-25 | Los Angeles | 37 | 1 | 12 | |
890728 | 890728 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-01-25 | Los Angeles | 37 | 8 | 12 | |
890367 | 890367 | 95435 | 95435 | 2021-01-25 | Lake | 33 | 33 | 14 | |
890854 | 890854 | 95724 | 95724: Norden | 2021-01-25 | Nevada | 57 | 9 | 9 or fewer | 20 |
890336 | 890336 | 93519 | 93519: Cantil | 2021-01-25 | Kern | 29 | 0 | 28 | |
891222 | 891222 | Creston | Creston | 2021-01-25 | San Luis Obispo | 79 | 69 | 30 | |
890199 | 890199 | Volcano | Volcano | 2021-01-25 | Amador | 5 | 23 | 44 | |
890864 | 890864 | 95986 | 95986: Washington | 2021-01-25 | Nevada | 57 | 9 | 9 or fewer | 53 |
890320 | 890320 | 93287 | 93287: Woody | 2021-01-25 | Kern | 29 | 9 | 74 | |
890297 | 890297 | 92259 | 92259: Ocotillo | 2021-01-25 | Imperial | 25 | 7 | 94 | |
890865 | 890865 | 96111 | 96111: Floriston | 2021-01-25 | Nevada | 57 | 9 | 9 or fewer | 94 |
890298 | 890298 | 92266 | 92266: Palo Verde | 2021-01-25 | Imperial | 25 | 8 | 108 | |
890630 | 890630 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2021-01-25 | Los Angeles | 37 | 48 | 108 | |
890645 | 890645 | Unincorporated - East Lancaster | East Lancaster | 2021-01-25 | Los Angeles | 37 | 15 | 114 | |
890348 | 890348 | 93528 | 93528: Johannesburg | 2021-01-25 | Kern | 29 | 2 | 124 | |
890350 | 890350 | 93554 | 93554: Randsburg | 2021-01-25 | Kern | 29 | 8 | 143 | |
890701 | 890701 | Unincorporated - Saugus | Saugus | 2021-01-25 | Los Angeles | 37 | 112 | 155 | |
890316 | 890316 | 93276 | 93276: Tupman | 2021-01-25 | Kern | 29 | 12 | 159 | |
890210 | 890210 | 95232, 95245 | 95232, 95245 | 2021-01-25 | Calaveras | 9 | 42 | 161 | |
890338 | 890338 | 93524 | 93524: Edwards | 2021-01-25 | Kern | 29 | 3 | 168 | |
891250 | 891250 | Loma Mar | Loma Mar | 2021-01-25 | San Mateo | 81 | 9 | 9 or fewer | 172 |
890304 | 890304 | 93226 | 93226: Glennville | 2021-01-25 | Kern | 29 | 14 | 195 | |
890474 | 890474 | City of Vernon | Vernon | 2021-01-25 | Los Angeles | 37 | 115 | 209 | |
890177 | 890177 | 94613 | 94613: Oakland | 2021-01-25 | Alameda | 1 | 2 | 212 | |
890845 | 890845 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-01-25 | Napa | 55 | 11 | 212 | |
891256 | 891256 | Pescadero | Pescadero | 2021-01-25 | San Mateo | 81 | 47 | 219 | |
890677 | 890677 | Unincorporated - Newhall | Newhall | 2021-01-25 | Los Angeles | 37 | 61 | 220 | |
890855 | 890855 | 95728 | 95728: Soda Springs | 2021-01-25 | Nevada | 57 | 16 | 229 | |
890377 | 890377 | 95493 | 95493 | 2021-01-25 | Lake | 33 | 3 | 241 | |
890311 | 890311 | 93251 | 93251: Mc Kittrick | 2021-01-25 | Kern | 29 | 18 | 243 | |
890699 | 890699 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2021-01-25 | Los Angeles | 37 | 137 | 267 | |
890368 | 890368 | 95443 | 95443 | 2021-01-25 | Lake | 33 | 2 | 270 | |
891328 | 891328 | 95450 | 95450: Jenner | 2021-01-25 | Sonoma | 97 | 10 | 10 or fewer | 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 );