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-13 sorted by confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases ▲ | note | population |
---|---|---|---|---|---|---|---|---|---|
906600 | 906600 | San Jose | San Jose | 2021-01-13 | Santa Clara | 85 | 57444 | 1026658 | |
906324 | 906324 | Sacramento | Sacramento | 2021-01-13 | Sacramento | 67 | 40900 | 495011 | |
906305 | 906305 | Riverside | Riverside | 2021-01-13 | Riverside | 65 | 38249 | 323935 | |
906213 | 906213 | Santa Ana | Santa Ana | 2021-01-13 | Orange | 59 | 36612 | 337716 | |
906182 | 906182 | Anaheim | Anaheim | 2021-01-13 | Orange | 59 | 33723 | 359339 | |
906379 | 906379 | San Bernardino | San Bernardino | 2021-01-13 | San Bernardino | 71 | 33557 | 218515 | |
906345 | 906345 | Fontana | Fontana | 2021-01-13 | San Bernardino | 71 | 32233 | 215334 | |
905580 | 905580 | Fresno | Fresno | 2021-01-13 | Fresno | 19 | 26967 | 608579 | |
906295 | 906295 | Moreno Valley | Moreno Valley | 2021-01-13 | Riverside | 65 | 25962 | 205034 | |
906369 | 906369 | Ontario | Ontario | 2021-01-13 | San Bernardino | 71 | 21285 | 182380 | |
905958 | 905958 | Unincorporated - East Los Angeles | East Los Angeles | 2021-01-13 | Los Angeles | 37 | 20558 | 125269 | |
905766 | 905766 | City of Pomona | Pomona | 2021-01-13 | Los Angeles | 37 | 19789 | 155931 | |
905762 | 905762 | City of Palmdale | Palmdale | 2021-01-13 | Los Angeles | 37 | 18838 | 158968 | |
906385 | 906385 | Victorville | Victorville | 2021-01-13 | San Bernardino | 71 | 17290 | 128353 | |
905751 | 905751 | City of Lancaster | Lancaster | 2021-01-13 | Los Angeles | 37 | 16660 | 161570 | |
905868 | 905868 | Los Angeles - North Hollywood | North Hollywood | 2021-01-13 | Los Angeles | 37 | 15629 | 151421 | |
906376 | 906376 | Rialto | Rialto | 2021-01-13 | San Bernardino | 71 | 15311 | 103884 | |
905782 | 905782 | City of South Gate | South Gate | 2021-01-13 | Los Angeles | 37 | 15007 | 98155 | |
905776 | 905776 | City of Santa Clarita | Santa Clarita | 2021-01-13 | Los Angeles | 37 | 14793 | 220424 | |
906650 | 906650 | Modesto | Modesto | 2021-01-13 | Stanislaus | 99 | 14410 | 211336 | |
906374 | 906374 | Rancho Cucamonga | Rancho Cucamonga | 2021-01-13 | San Bernardino | 71 | 14346 | 177037 | |
905801 | 905801 | Los Angeles - Boyle Heights | Boyle Heights | 2021-01-13 | Los Angeles | 37 | 14291 | 86884 | |
905730 | 905730 | City of Downey | Downey | 2021-01-13 | Los Angeles | 37 | 14215 | 114263 | |
905735 | 905735 | City of Glendale | Glendale | 2021-01-13 | Los Angeles | 37 | 14029 | 206493 | |
905732 | 905732 | City of El Monte | El Monte | 2021-01-13 | Los Angeles | 37 | 13751 | 117269 | |
905871 | 905871 | Los Angeles - Pacoima | Pacoima | 2021-01-13 | Los Angeles | 37 | 13505 | 76979 | |
906265 | 906265 | Corona | Corona | 2021-01-13 | Riverside | 65 | 13441 | 165355 | |
905725 | 905725 | City of Compton | Compton | 2021-01-13 | Los Angeles | 37 | 13266 | 99904 | |
906285 | 906285 | Jurupa Valley | Jurupa Valley | 2021-01-13 | Riverside | 65 | 13236 | 103784 | |
906325 | 906325 | Unincorporated Areas | Other | 2021-01-13 | Sacramento | 67 | 12967 | ||
906191 | 906191 | Garden Grove | Garden Grove | 2021-01-13 | Orange | 59 | 12679 | 175155 | |
905761 | 905761 | City of Norwalk | Norwalk | 2021-01-13 | Los Angeles | 37 | 12555 | 107622 | |
905896 | 905896 | Los Angeles - Sylmar | Sylmar | 2021-01-13 | Los Angeles | 37 | 12438 | 82398 | |
906351 | 906351 | Hesperia | Hesperia | 2021-01-13 | San Bernardino | 71 | 11430 | 97312 | |
905908 | 905908 | Los Angeles - Van Nuys | Van Nuys | 2021-01-13 | Los Angeles | 37 | 11381 | 93194 | |
905964 | 905964 | Unincorporated - Florence-Firestone | Unincorporated - Florence-Firestone | 2021-01-13 | Los Angeles | 37 | 10998 | 64705 | |
906338 | 906338 | Chino | Chino | 2021-01-13 | San Bernardino | 71 | 10788 | 93099 | |
905754 | 905754 | City of Lynwood | Lynwood | 2021-01-13 | Los Angeles | 37 | 10674 | 72047 | |
906303 | 906303 | Perris | Perris | 2021-01-13 | Riverside | 65 | 10649 | 76276 | |
906489 | 906489 | 92154 | 92154: San Diego | 2021-01-13 | San Diego | 73 | 10606 | 79997 | |
905874 | 905874 | Los Angeles - Panorama City | Panorama City | 2021-01-13 | Los Angeles | 37 | 10547 | 75250 | |
905713 | 905713 | City of Baldwin Park | Baldwin Park | 2021-01-13 | Los Angeles | 37 | 10497 | 76769 | |
905693 | 905693 | 90805 | 90805: Long Beach | 2021-01-13 | Los Angeles | 37 | 10433 | 96708 | |
905743 | 905743 | City of Inglewood | Inglewood | 2021-01-13 | Los Angeles | 37 | 10190 | 113582 | |
905788 | 905788 | City of West Covina | West Covina | 2021-01-13 | Los Angeles | 37 | 10060 | 108235 | |
906284 | 906284 | Indio | Indio | 2021-01-13 | Riverside | 65 | 9796 | 88291 | |
906206 | 906206 | Orange | Orange | 2021-01-13 | Orange | 59 | 9444 | 141691 | |
905637 | 905637 | 93307 | 93307: Bakersfield | 2021-01-13 | Kern | 29 | 9398 | 84948 | |
906709 | 906709 | 93033 | 93033: Oxnard | 2021-01-13 | Ventura | 111 | 9233 | 83319 | |
905741 | 905741 | City of Huntington Park | Huntington Park | 2021-01-13 | Los Angeles | 37 | 9157 | 59484 | |
905913 | 905913 | Los Angeles - Vernon Central | Vernon Central | 2021-01-13 | Los Angeles | 37 | 9055 | 51998 | |
905765 | 905765 | City of Pico Rivera | Pico Rivera | 2021-01-13 | Los Angeles | 37 | 8983 | 64284 | |
906190 | 906190 | Fullerton | Fullerton | 2021-01-13 | Orange | 59 | 8851 | 142824 | |
905791 | 905791 | City of Whittier | Whittier | 2021-01-13 | Los Angeles | 37 | 8806 | 87432 | |
905882 | 905882 | Los Angeles - Reseda | Reseda | 2021-01-13 | Los Angeles | 37 | 8788 | 76617 | |
906340 | 906340 | Colton | Colton | 2021-01-13 | San Bernardino | 71 | 8550 | 54636 | |
906390 | 906390 | 91911 | 91911: Chula Vista | 2021-01-13 | San Diego | 73 | 8467 | 84819 | |
905716 | 905716 | City of Bellflower | Bellflower | 2021-01-13 | Los Angeles | 37 | 8427 | 77735 | |
906319 | 906319 | Elk Grove | Elk Grove | 2021-01-13 | Sacramento | 67 | 8395 | 168503 | |
906114 | 906114 | Merced | Merced | 2021-01-13 | Merced | 47 | 8290 | 89459 | |
905759 | 905759 | City of Montebello | Montebello | 2021-01-13 | Los Angeles | 37 | 8217 | 64375 | |
906586 | 906586 | Santa Maria | Santa Maria | 2021-01-13 | Santa Barbara | 83 | 8133 | 99553 | |
906192 | 906192 | Huntington Beach | Huntington Beach | 2021-01-13 | Orange | 59 | 8098 | 203761 | |
905921 | 905921 | Los Angeles - West Vernon | West Vernon | 2021-01-13 | Los Angeles | 37 | 8058 | 53644 | |
905764 | 905764 | City of Paramount | Paramount | 2021-01-13 | Los Angeles | 37 | 8005 | 56023 | |
905554 | 905554 | Richmond | Richmond | 2021-01-13 | Contra Costa | 13 | 7796 | 111217 | |
906675 | 906675 | 93257 | Porterville: 93257 | 2021-01-13 | Tulare | 107 | 7705 | 76923 | |
906328 | 906328 | Apple Valley | Apple Valley | 2021-01-13 | San Bernardino | 71 | 7688 | 73694 | |
905738 | 905738 | City of Hawthorne | Hawthorne | 2021-01-13 | Los Angeles | 37 | 7637 | 88787 | |
906193 | 906193 | Irvine | Irvine | 2021-01-13 | Orange | 59 | 7617 | 280202 | |
905830 | 905830 | Los Angeles - Florence-Firestone | Florence-Firestone | 2021-01-13 | Los Angeles | 37 | 7570 | 47445 | |
905867 | 905867 | Los Angeles - North Hills | North Hills | 2021-01-13 | Los Angeles | 37 | 7220 | 61575 | |
906121 | 906121 | 93905 | 93905: Salinas | 2021-01-13 | Monterey | 53 | 7214 | 60408 | |
905893 | 905893 | Los Angeles - Sun Valley | Sun Valley | 2021-01-13 | Los Angeles | 37 | 7169 | 52483 | |
906294 | 906294 | Menifee | Menifee | 2021-01-13 | Riverside | 65 | 7074 | 88515 | |
905636 | 905636 | 93306 | 93306: Bakersfield | 2021-01-13 | Kern | 29 | 7054 | 70208 | |
905805 | 905805 | Los Angeles - Canoga Park | Canoga Park | 2021-01-13 | Los Angeles | 37 | 7044 | 65289 | |
906375 | 906375 | Redlands | Redlands | 2021-01-13 | San Bernardino | 71 | 7042 | 72099 | |
906682 | 906682 | 93274 | Tulare: 93274 | 2021-01-13 | Tulare | 107 | 6995 | 73778 | |
906615 | 906615 | Vallejo | Vallejo | 2021-01-13 | Solano | 95 | 6948 | 119544 | |
905669 | 905669 | Correctional facilities | Prisons | 2021-01-13 | Kings | 31 | 6898 | ||
905654 | 905654 | 93215 | 93215: Delano | 2021-01-13 | Kern | 29 | 6873 | 55845 | |
906656 | 906656 | Unincorporated districts | Other | 2021-01-13 | Stanislaus | 99 | 6829 | ||
905721 | 905721 | City of Carson | Carson | 2021-01-13 | Los Angeles | 37 | 6821 | 93846 | |
906384 | 906384 | Upland | Upland | 2021-01-13 | San Bernardino | 71 | 6780 | 78249 | |
906499 | 906499 | 91910 | 91910: Chula Vista | 2021-01-13 | San Diego | 73 | 6780 | 83834 | |
906185 | 906185 | Costa Mesa | Costa Mesa | 2021-01-13 | Orange | 59 | 6751 | 115830 | |
905601 | 905601 | 92231 | 92231: Calexico | 2021-01-13 | Imperial | 25 | 6749 | 40019 | |
906708 | 906708 | 93030 | 93030: Oxnard | 2021-01-13 | Ventura | 111 | 6744 | 62016 | |
905715 | 905715 | City of Bell Gardens | Bell Gardens | 2021-01-13 | Los Angeles | 37 | 6741 | 43071 | |
906610 | 906610 | Fairfield | Fairfield | 2021-01-13 | Solano | 95 | 6681 | 117149 | |
906278 | 906278 | Hemet | Hemet | 2021-01-13 | Riverside | 65 | 6644 | 84069 | |
906352 | 906352 | Highland | Highland | 2021-01-13 | San Bernardino | 71 | 6622 | 55484 | |
906018 | 906018 | Unincorporated - South Whittier | South Whittier | 2021-01-13 | Los Angeles | 37 | 6609 | 59222 | |
906264 | 906264 | Coachella | Coachella | 2021-01-13 | Riverside | 65 | 6531 | 44849 | |
905530 | 905530 | Antioch | Antioch | 2021-01-13 | Contra Costa | 13 | 6516 | 112520 | |
905719 | 905719 | City of Burbank | Burbank | 2021-01-13 | Los Angeles | 37 | 6404 | 107180 | |
905698 | 905698 | 90813 | 90813: Long Beach | 2021-01-13 | Los Angeles | 37 | 6291 | 59000 | |
905603 | 905603 | 92243 | 92243: El Centro | 2021-01-13 | Imperial | 25 | 6259 | 50484 | |
905862 | 905862 | Los Angeles - Melrose | Melrose | 2021-01-13 | Los Angeles | 37 | 6179 | 77696 |
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 );