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-05-31 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
729486 | 729486 | Dinuba | Dinuba | 2021-05-31 | Fresno | 19 | 0 | 0 | |
729490 | 729490 | Five Points | Five Points | 2021-05-31 | Fresno | 19 | 23 | 0 | |
729501 | 729501 | Prather | Prather | 2021-05-31 | Fresno | 19 | 16 | 0 | |
729511 | 729511 | 92222 | 92222: Bard | 2021-05-31 | Imperial | 25 | 9 | 0 | |
729516 | 729516 | 92244 | 92244: El Centro | 2021-05-31 | Imperial | 25 | 95 | 0 | |
729589 | 729589 | 95424 | 95424 | 2021-05-31 | Lake | 33 | 14 | 0 | |
729905 | 729905 | Unincorporated - Padua Hills | Padua Hills | 2021-05-31 | Los Angeles | 37 | 9 | 0 | |
729943 | 729943 | Unincorporated - West Chatsworth | West Chatsworth | 2021-05-31 | Los Angeles | 37 | 2 | 0 | |
730037 | 730037 | 93912 | 93912: Boronda | 2021-05-31 | Monterey | 53 | 124 | 0 | |
730040 | 730040 | 93922 | 93922: Carmel | 2021-05-31 | Monterey | 53 | 21 | 0 | |
730049 | 730049 | 93942 | 93942: Monterey | 2021-05-31 | Monterey | 53 | 29 | 0 | |
730076 | 730076 | 95602 | 95602: Auburn | 2021-05-31 | Nevada | 57 | 231 | 0 | |
730077 | 730077 | 95712 | 95712: Chicago Park | 2021-05-31 | Nevada | 57 | 11 | 0 | |
730080 | 730080 | 95924 | 95924: Cedar Ridge | 2021-05-31 | Nevada | 57 | 39 | 0 | |
730087 | 730087 | 95977 | 95977: Smartville | 2021-05-31 | Nevada | 57 | 26 | 0 | |
730090 | 730090 | 96160 | 96160: Truckee | 2021-05-31 | Nevada | 57 | 101 | 0 | |
730092 | 730092 | 96162 | 96162: Truckee | 2021-05-31 | Nevada | 57 | 74 | 0 | |
730120 | 730120 | Rancho Mission Viejo | Rancho Mission Viejo | 2021-05-31 | Orange | 59 | 341 | 0 | |
730127 | 730127 | Silverado | Silverado | 2021-05-31 | Orange | 59 | 95 | 0 | |
730129 | 730129 | Trabuco Canyon | Trabuco Canyon | 2021-05-31 | Orange | 59 | 978 | 0 | |
730150 | 730150 | 95715 | 95715: Emigrant Gap | 2021-05-31 | Placer | 61 | 9 | 0 | |
730151 | 730151 | 95717 | 95717: Gold Run | 2021-05-31 | Placer | 61 | 5 | 5 or fewer | 0 |
730153 | 730153 | 95724 | 95724: Norden | 2021-05-31 | Placer | 61 | 5 | 5 or fewer | 0 |
730159 | 730159 | 96142 | 96142: Tahoma | 2021-05-31 | Placer | 61 | 5 | 5 or fewer | 0 |
730165 | 730165 | 96162 | 96162: Truckee | 2021-05-31 | Placer | 61 | 5 | 5 or fewer | 0 |
730261 | 730261 | Havasu Lake | Havasu Lake | 2021-05-31 | San Bernardino | 71 | 0 | 0 | |
730306 | 730306 | 91916 | 91916: Descanso | 2021-05-31 | San Diego | 73 | 94 | 0 | |
730307 | 730307 | 91917 | 91917: Dulzura | 2021-05-31 | San Diego | 73 | 184 | 0 | |
730308 | 730308 | 91931 | 91931: Guatay | 2021-05-31 | San Diego | 73 | 12 | 0 | |
730310 | 730310 | 91934 | 91934: Jacumba | 2021-05-31 | San Diego | 73 | 36 | 0 | |
730311 | 730311 | 91935 | 91935: Jamul | 2021-05-31 | San Diego | 73 | 708 | 0 | |
730316 | 730316 | 91962 | 91962: Pine Valley | 2021-05-31 | San Diego | 73 | 105 | 0 | |
730317 | 730317 | 91963 | 91963: Potrero | 2021-05-31 | San Diego | 73 | 199 | 0 | |
730319 | 730319 | 91978 | 91978: Spring Valley | 2021-05-31 | San Diego | 73 | 858 | 0 | |
730320 | 730320 | 91980 | 91980: Tecate | 2021-05-31 | San Diego | 73 | 171 | 0 | |
730321 | 730321 | 92003 | 92003: Bonsall | 2021-05-31 | San Diego | 73 | 285 | 0 | |
730322 | 730322 | 92004 | 92004: Borrego Springs | 2021-05-31 | San Diego | 73 | 136 | 0 | |
730338 | 730338 | 92036 | 92036: Julian | 2021-05-31 | San Diego | 73 | 109 | 0 | |
730346 | 730346 | 92059 | 92059: Pala | 2021-05-31 | San Diego | 73 | 254 | 0 | |
730347 | 730347 | 92060 | 92060: Palomar Mountain | 2021-05-31 | San Diego | 73 | 20 | 0 | |
730348 | 730348 | 92061 | 92061: Pauma Valley | 2021-05-31 | San Diego | 73 | 225 | 0 | |
730351 | 730351 | 92066 | 92066: Ranchita | 2021-05-31 | San Diego | 73 | 13 | 0 | |
730352 | 730352 | 92067 | 92067: Rancho Santa Fe | 2021-05-31 | San Diego | 73 | 404 | 0 | |
730354 | 730354 | 92070 | 92070: Santa Ysabel | 2021-05-31 | San Diego | 73 | 68 | 0 | |
730362 | 730362 | 92086 | 92086: Warner Springs | 2021-05-31 | San Diego | 73 | 56 | 0 | |
730363 | 730363 | 92091 | 92091: Rancho Santa Fe | 2021-05-31 | San Diego | 73 | 37 | 0 | |
730365 | 730365 | 92096 | 92096: San Marcos | 2021-05-31 | San Diego | 73 | 5 | 0 | |
730385 | 730385 | 92121 | 92121: San Diego | 2021-05-31 | San Diego | 73 | 196 | 0 | |
730395 | 730395 | 92134 | 92134: San Diego | 2021-05-31 | San Diego | 73 | 45 | 0 | |
730396 | 730396 | 92135 | 92135: Coronado | 2021-05-31 | San Diego | 73 | 86 | 0 | |
730399 | 730399 | 92140 | 92140: San Diego | 2021-05-31 | San Diego | 73 | 120 | 0 | |
730400 | 730400 | 92145 | 92145: San Diego | 2021-05-31 | San Diego | 73 | 13 | 0 | |
730402 | 730402 | 92155 | 92155: Coronado | 2021-05-31 | San Diego | 73 | 21 | 0 | |
730404 | 730404 | 92182 | 92182: San Diego | 2021-05-31 | San Diego | 73 | 32 | 0 | |
730405 | 730405 | 92536 | 92536: Aguanga | 2021-05-31 | San Diego | 73 | 7 | 0 | |
730406 | 730406 | 92672 | 92672: San Clemente | 2021-05-31 | San Diego | 73 | 14 | 0 | |
730409 | 730409 | 91905 | 91905: Boulevard | 2021-05-31 | San Diego | 73 | 71 | 0 | |
730410 | 730410 | 91906 | 91906: Campo | 2021-05-31 | San Diego | 73 | 301 | 0 | |
730438 | 730438 | ASH (patients) | ASH (patients) | 2021-05-31 | San Luis Obispo | 79 | 188 | 0 | |
730442 | 730442 | CMC (Inmates) | CMC (Inmates) | 2021-05-31 | San Luis Obispo | 79 | 2380 | 0 | |
730443 | 730443 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2021-05-31 | San Luis Obispo | 79 | 654 | 0 | |
730494 | 730494 | Lompoc Federal Prison | Lompoc Federal Prison | 2021-05-31 | Santa Barbara | 83 | 1094 | 0 | |
730578 | 730578 | 93212 | Corcoran, Angiola: 93212 | 2021-05-31 | Tulare | 107 | 10 | 0 | |
730602 | 730602 | 93646 | Traver: 93646 | 2021-05-31 | Tulare | 107 | 23 | 0 | |
730604 | 730604 | 93654 | Orosi: 93654 | 2021-05-31 | Tulare | 107 | 60 | 0 | |
729880 | 729880 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2021-05-31 | Los Angeles | 37 | 1 | 1 | |
729892 | 729892 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-05-31 | Los Angeles | 37 | 0 | 1 | |
729877 | 729877 | Unincorporated - Franklin Canyon | Franklin Canyon | 2021-05-31 | Los Angeles | 37 | 1 | 12 | |
729952 | 729952 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-05-31 | Los Angeles | 37 | 13 | 12 | |
729591 | 729591 | 95435 | 95435 | 2021-05-31 | Lake | 33 | 37 | 14 | |
730078 | 730078 | 95724 | 95724: Norden | 2021-05-31 | Nevada | 57 | 34 | 20 | |
729560 | 729560 | 93519 | 93519: Cantil | 2021-05-31 | Kern | 29 | 1 | 28 | |
730446 | 730446 | Creston | Creston | 2021-05-31 | San Luis Obispo | 79 | 89 | 30 | |
729423 | 729423 | Volcano | Volcano | 2021-05-31 | Amador | 5 | 28 | 44 | |
730088 | 730088 | 95986 | 95986: Washington | 2021-05-31 | Nevada | 57 | 9 | 9 or fewer | 53 |
729544 | 729544 | 93287 | 93287: Woody | 2021-05-31 | Kern | 29 | 15 | 74 | |
729521 | 729521 | 92259 | 92259: Ocotillo | 2021-05-31 | Imperial | 25 | 15 | 94 | |
730089 | 730089 | 96111 | 96111: Floriston | 2021-05-31 | Nevada | 57 | 9 | 9 or fewer | 94 |
729522 | 729522 | 92266 | 92266: Palo Verde | 2021-05-31 | Imperial | 25 | 8 | 108 | |
729854 | 729854 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2021-05-31 | Los Angeles | 37 | 52 | 108 | |
729869 | 729869 | Unincorporated - East Lancaster | East Lancaster | 2021-05-31 | Los Angeles | 37 | 16 | 114 | |
729572 | 729572 | 93528 | 93528: Johannesburg | 2021-05-31 | Kern | 29 | 4 | 124 | |
729574 | 729574 | 93554 | 93554: Randsburg | 2021-05-31 | Kern | 29 | 9 | 143 | |
729925 | 729925 | Unincorporated - Saugus | Saugus | 2021-05-31 | Los Angeles | 37 | 132 | 155 | |
729540 | 729540 | 93276 | 93276: Tupman | 2021-05-31 | Kern | 29 | 12 | 159 | |
729434 | 729434 | 95232, 95245 | 95232, 95245 | 2021-05-31 | Calaveras | 9 | 59 | 161 | |
729562 | 729562 | 93524 | 93524: Edwards | 2021-05-31 | Kern | 29 | 3 | 168 | |
730474 | 730474 | Loma Mar | Loma Mar | 2021-05-31 | San Mateo | 81 | 9 | 9 or fewer | 172 |
729528 | 729528 | 93226 | 93226: Glennville | 2021-05-31 | Kern | 29 | 18 | 195 | |
729698 | 729698 | City of Vernon | Vernon | 2021-05-31 | Los Angeles | 37 | 124 | 209 | |
729401 | 729401 | 94613 | 94613: Oakland | 2021-05-31 | Alameda | 1 | 2 | 212 | |
730069 | 730069 | Northeast American Canyon Area | Northeast American Canyon Area | 2021-05-31 | Napa | 55 | 11 | 212 | |
730480 | 730480 | Pescadero | Pescadero | 2021-05-31 | San Mateo | 81 | 61 | 219 | |
729901 | 729901 | Unincorporated - Newhall | Newhall | 2021-05-31 | Los Angeles | 37 | 69 | 220 | |
730079 | 730079 | 95728 | 95728: Soda Springs | 2021-05-31 | Nevada | 57 | 26 | 229 | |
729601 | 729601 | 95493 | 95493 | 2021-05-31 | Lake | 33 | 7 | 241 | |
729535 | 729535 | 93251 | 93251: Mc Kittrick | 2021-05-31 | Kern | 29 | 24 | 243 | |
729923 | 729923 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2021-05-31 | Los Angeles | 37 | 164 | 267 | |
729592 | 729592 | 95443 | 95443 | 2021-05-31 | Lake | 33 | 2 | 270 | |
730552 | 730552 | 95450 | 95450: Jenner | 2021-05-31 | 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 );