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,277 rows where "date" is on date 2022-02-28 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
381779 | 381779 | Dinuba | Dinuba | 2022-02-28 | Fresno | 19 | 77 | 0 | |
381783 | 381783 | Five Points | Five Points | 2022-02-28 | Fresno | 19 | 82 | 0 | |
381794 | 381794 | Prather | Prather | 2022-02-28 | Fresno | 19 | 128 | 0 | |
381804 | 381804 | 92222 | 92222: Bard | 2022-02-28 | Imperial | 25 | 12 | 0 | |
381809 | 381809 | 92244 | 92244: El Centro | 2022-02-28 | Imperial | 25 | 214 | 0 | |
381882 | 381882 | 95424 | 95424 | 2022-02-28 | Lake | 33 | 47 | 0 | |
382198 | 382198 | Unincorporated - Padua Hills | Padua Hills | 2022-02-28 | Los Angeles | 37 | 25 | 0 | |
382236 | 382236 | Unincorporated - West Chatsworth | West Chatsworth | 2022-02-28 | Los Angeles | 37 | 4 | 0 | |
382330 | 382330 | 93912 | 93912: Boronda | 2022-02-28 | Monterey | 53 | 235 | 0 | |
382333 | 382333 | 93922 | 93922: Carmel | 2022-02-28 | Monterey | 53 | 53 | 0 | |
382342 | 382342 | 93942 | 93942: Monterey | 2022-02-28 | Monterey | 53 | 56 | 0 | |
382369 | 382369 | 95602 | 95602: Auburn | 2022-02-28 | Nevada | 57 | 682 | 0 | |
382370 | 382370 | 95712 | 95712: Chicago Park | 2022-02-28 | Nevada | 57 | 51 | 0 | |
382373 | 382373 | 95924 | 95924: Cedar Ridge | 2022-02-28 | Nevada | 57 | 104 | 0 | |
382380 | 382380 | 95977 | 95977: Smartville | 2022-02-28 | Nevada | 57 | 117 | 0 | |
382383 | 382383 | 96160 | 96160: Truckee | 2022-02-28 | Nevada | 57 | 323 | 0 | |
382385 | 382385 | 96162 | 96162: Truckee | 2022-02-28 | Nevada | 57 | 218 | 0 | |
382413 | 382413 | Rancho Mission Viejo | Rancho Mission Viejo | 2022-02-28 | Orange | 59 | 1106 | 0 | |
382420 | 382420 | Silverado | Silverado | 2022-02-28 | Orange | 59 | 230 | 0 | |
382422 | 382422 | Trabuco Canyon | Trabuco Canyon | 2022-02-28 | Orange | 59 | 2675 | 0 | |
382443 | 382443 | 95715 | 95715: Emigrant Gap | 2022-02-28 | Placer | 61 | 16 | 0 | |
382444 | 382444 | 95717 | 95717: Gold Run | 2022-02-28 | Placer | 61 | 12 | 0 | |
382446 | 382446 | 95724 | 95724: Norden | 2022-02-28 | Placer | 61 | 6 | 0 | |
382452 | 382452 | 96142 | 96142: Tahoma | 2022-02-28 | Placer | 61 | 5 | 5 or fewer | 0 |
382458 | 382458 | 96162 | 96162: Truckee | 2022-02-28 | Placer | 61 | 5 | 5 or fewer | 0 |
382554 | 382554 | Havasu Lake | Havasu Lake | 2022-02-28 | San Bernardino | 71 | 0 | 0 | |
382599 | 382599 | 91916 | 91916: Descanso | 2022-02-28 | San Diego | 73 | 296 | 0 | |
382600 | 382600 | 91917 | 91917: Dulzura | 2022-02-28 | San Diego | 73 | 269 | 0 | |
382601 | 382601 | 91931 | 91931: Guatay | 2022-02-28 | San Diego | 73 | 40 | 0 | |
382603 | 382603 | 91934 | 91934: Jacumba | 2022-02-28 | San Diego | 73 | 97 | 0 | |
382604 | 382604 | 91935 | 91935: Jamul | 2022-02-28 | San Diego | 73 | 1713 | 0 | |
382609 | 382609 | 91962 | 91962: Pine Valley | 2022-02-28 | San Diego | 73 | 296 | 0 | |
382610 | 382610 | 91963 | 91963: Potrero | 2022-02-28 | San Diego | 73 | 339 | 0 | |
382612 | 382612 | 91978 | 91978: Spring Valley | 2022-02-28 | San Diego | 73 | 2184 | 0 | |
382613 | 382613 | 91980 | 91980: Tecate | 2022-02-28 | San Diego | 73 | 260 | 0 | |
382614 | 382614 | 92003 | 92003: Bonsall | 2022-02-28 | San Diego | 73 | 811 | 0 | |
382615 | 382615 | 92004 | 92004: Borrego Springs | 2022-02-28 | San Diego | 73 | 327 | 0 | |
382631 | 382631 | 92036 | 92036: Julian | 2022-02-28 | San Diego | 73 | 389 | 0 | |
382639 | 382639 | 92059 | 92059: Pala | 2022-02-28 | San Diego | 73 | 501 | 0 | |
382640 | 382640 | 92060 | 92060: Palomar Mountain | 2022-02-28 | San Diego | 73 | 79 | 0 | |
382641 | 382641 | 92061 | 92061: Pauma Valley | 2022-02-28 | San Diego | 73 | 557 | 0 | |
382644 | 382644 | 92066 | 92066: Ranchita | 2022-02-28 | San Diego | 73 | 35 | 0 | |
382645 | 382645 | 92067 | 92067: Rancho Santa Fe | 2022-02-28 | San Diego | 73 | 1317 | 0 | |
382647 | 382647 | 92070 | 92070: Santa Ysabel | 2022-02-28 | San Diego | 73 | 293 | 0 | |
382655 | 382655 | 92086 | 92086: Warner Springs | 2022-02-28 | San Diego | 73 | 136 | 0 | |
382656 | 382656 | 92091 | 92091: Rancho Santa Fe | 2022-02-28 | San Diego | 73 | 108 | 0 | |
382658 | 382658 | 92096 | 92096: San Marcos | 2022-02-28 | San Diego | 73 | 20 | 0 | |
382678 | 382678 | 92121 | 92121: San Diego | 2022-02-28 | San Diego | 73 | 722 | 0 | |
382688 | 382688 | 92134 | 92134: San Diego | 2022-02-28 | San Diego | 73 | 90 | 0 | |
382689 | 382689 | 92135 | 92135: Coronado | 2022-02-28 | San Diego | 73 | 110 | 0 | |
382692 | 382692 | 92140 | 92140: San Diego | 2022-02-28 | San Diego | 73 | 178 | 0 | |
382693 | 382693 | 92145 | 92145: San Diego | 2022-02-28 | San Diego | 73 | 19 | 0 | |
382695 | 382695 | 92155 | 92155: Coronado | 2022-02-28 | San Diego | 73 | 58 | 0 | |
382697 | 382697 | 92182 | 92182: San Diego | 2022-02-28 | San Diego | 73 | 123 | 0 | |
382698 | 382698 | 92536 | 92536: Aguanga | 2022-02-28 | San Diego | 73 | 14 | 0 | |
382699 | 382699 | 92672 | 92672: San Clemente | 2022-02-28 | San Diego | 73 | 81 | 0 | |
382702 | 382702 | 91905 | 91905: Boulevard | 2022-02-28 | San Diego | 73 | 243 | 0 | |
382703 | 382703 | 91906 | 91906: Campo | 2022-02-28 | San Diego | 73 | 818 | 0 | |
382731 | 382731 | ASH (patients) | ASH (patients) | 2022-02-28 | San Luis Obispo | 79 | 380 | 0 | |
382735 | 382735 | CMC (Inmates) | CMC (Inmates) | 2022-02-28 | San Luis Obispo | 79 | 2853 | 0 | |
382736 | 382736 | Cal Poly (campus residents) | Cal Poly (campus residents) | 2022-02-28 | San Luis Obispo | 79 | 938 | 0 | |
382787 | 382787 | Lompoc Federal Prison | Lompoc Federal Prison | 2022-02-28 | Santa Barbara | 83 | 1162 | 0 | |
382887 | 382887 | 93212 | Corcoran, Angiola: 93212 | 2022-02-28 | Tulare | 107 | 25 | 0 | |
382911 | 382911 | 93646 | Traver: 93646 | 2022-02-28 | Tulare | 107 | 57 | 0 | |
382913 | 382913 | 93654 | Orosi: 93654 | 2022-02-28 | Tulare | 107 | 206 | 0 | |
382173 | 382173 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2022-02-28 | Los Angeles | 37 | 4 | 1 | |
382185 | 382185 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2022-02-28 | Los Angeles | 37 | 1 | 1 | |
382170 | 382170 | Unincorporated - Franklin Canyon | Franklin Canyon | 2022-02-28 | Los Angeles | 37 | 1 | 12 | |
382245 | 382245 | Unincorporated - Whittier Narrows | Whittier Narrows | 2022-02-28 | Los Angeles | 37 | 64 | 12 | |
381884 | 381884 | 95435 | 95435 | 2022-02-28 | Lake | 33 | 64 | 14 | |
382371 | 382371 | 95724 | 95724: Norden | 2022-02-28 | Nevada | 57 | 10 | 20 | |
381853 | 381853 | 93519 | 93519: Cantil | 2022-02-28 | Kern | 29 | 3 | 28 | |
382739 | 382739 | Creston | Creston | 2022-02-28 | San Luis Obispo | 79 | 210 | 30 | |
382381 | 382381 | 95986 | 95986: Washington | 2022-02-28 | Nevada | 57 | 10 | 53 | |
381837 | 381837 | 93287 | 93287: Woody | 2022-02-28 | Kern | 29 | 24 | 74 | |
381814 | 381814 | 92259 | 92259: Ocotillo | 2022-02-28 | Imperial | 25 | 27 | 94 | |
382382 | 382382 | 96111 | 96111: Floriston | 2022-02-28 | Nevada | 57 | 14 | 94 | |
381815 | 381815 | 92266 | 92266: Palo Verde | 2022-02-28 | Imperial | 25 | 15 | 108 | |
382147 | 382147 | Unincorporated - Bradbury | Unincorporated - Bradbury | 2022-02-28 | Los Angeles | 37 | 66 | 108 | |
382162 | 382162 | Unincorporated - East Lancaster | East Lancaster | 2022-02-28 | Los Angeles | 37 | 36 | 114 | |
381865 | 381865 | 93528 | 93528: Johannesburg | 2022-02-28 | Kern | 29 | 13 | 124 | |
381867 | 381867 | 93554 | 93554: Randsburg | 2022-02-28 | Kern | 29 | 10 | 143 | |
382218 | 382218 | Unincorporated - Saugus | Saugus | 2022-02-28 | Los Angeles | 37 | 309 | 155 | |
381833 | 381833 | 93276 | 93276: Tupman | 2022-02-28 | Kern | 29 | 56 | 159 | |
381735 | 381735 | 95232, 95245 | 95232, 95245 | 2022-02-28 | Calaveras | 9 | 284 | 161 | |
381855 | 381855 | 93524 | 93524: Edwards | 2022-02-28 | Kern | 29 | 49 | 168 | |
382767 | 382767 | Loma Mar | Loma Mar | 2022-02-28 | San Mateo | 81 | 12 | 172 | |
381821 | 381821 | 93226 | 93226: Glennville | 2022-02-28 | Kern | 29 | 35 | 195 | |
381991 | 381991 | City of Vernon | Vernon | 2022-02-28 | Los Angeles | 37 | 304 | 209 | |
381709 | 381709 | 94613 | 94613: Oakland | 2022-02-28 | Alameda | 1 | 14 | 212 | |
382362 | 382362 | Northeast American Canyon Area | Northeast American Canyon Area | 2022-02-28 | Napa | 55 | 28 | 212 | |
382773 | 382773 | Pescadero | Pescadero | 2022-02-28 | San Mateo | 81 | 127 | 219 | |
382194 | 382194 | Unincorporated - Newhall | Newhall | 2022-02-28 | Los Angeles | 37 | 87 | 220 | |
382372 | 382372 | 95728 | 95728: Soda Springs | 2022-02-28 | Nevada | 57 | 69 | 229 | |
381894 | 381894 | 95493 | 95493 | 2022-02-28 | Lake | 33 | 18 | 241 | |
381828 | 381828 | 93251 | 93251: Mc Kittrick | 2022-02-28 | Kern | 29 | 52 | 243 | |
382216 | 382216 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2022-02-28 | Los Angeles | 37 | 609 | 267 | |
381885 | 381885 | 95443 | 95443 | 2022-02-28 | Lake | 33 | 20 | 270 | |
382861 | 382861 | 95450 | 95450: Jenner | 2022-02-28 | Sonoma | 97 | 15 | 298 | |
382215 | 382215 | Unincorporated - Sand Canyon | Sand Canyon | 2022-02-28 | Los Angeles | 37 | 48 | 308 |
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 );