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-14 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 |
---|---|---|---|---|---|---|---|---|---|
905324 | 905324 | San Jose | San Jose | 2021-01-14 | Santa Clara | 85 | 58271 | 1026658 | |
905048 | 905048 | Sacramento | Sacramento | 2021-01-14 | Sacramento | 67 | 40900 | 495011 | |
905029 | 905029 | Riverside | Riverside | 2021-01-14 | Riverside | 65 | 38542 | 323935 | |
904937 | 904937 | Santa Ana | Santa Ana | 2021-01-14 | Orange | 59 | 37138 | 337716 | |
904906 | 904906 | Anaheim | Anaheim | 2021-01-14 | Orange | 59 | 34261 | 359339 | |
905103 | 905103 | San Bernardino | San Bernardino | 2021-01-14 | San Bernardino | 71 | 33734 | 218515 | |
905069 | 905069 | Fontana | Fontana | 2021-01-14 | San Bernardino | 71 | 32451 | 215334 | |
904304 | 904304 | Fresno | Fresno | 2021-01-14 | Fresno | 19 | 26967 | 608579 | |
905019 | 905019 | Moreno Valley | Moreno Valley | 2021-01-14 | Riverside | 65 | 26303 | 205034 | |
905093 | 905093 | Ontario | Ontario | 2021-01-14 | San Bernardino | 71 | 21418 | 182380 | |
904682 | 904682 | Unincorporated - East Los Angeles | East Los Angeles | 2021-01-14 | Los Angeles | 37 | 20886 | 125269 | |
904490 | 904490 | City of Pomona | Pomona | 2021-01-14 | Los Angeles | 37 | 19970 | 155931 | |
904486 | 904486 | City of Palmdale | Palmdale | 2021-01-14 | Los Angeles | 37 | 19138 | 158968 | |
905109 | 905109 | Victorville | Victorville | 2021-01-14 | San Bernardino | 71 | 17425 | 128353 | |
904475 | 904475 | City of Lancaster | Lancaster | 2021-01-14 | Los Angeles | 37 | 16878 | 161570 | |
904592 | 904592 | Los Angeles - North Hollywood | North Hollywood | 2021-01-14 | Los Angeles | 37 | 15994 | 151421 | |
905100 | 905100 | Rialto | Rialto | 2021-01-14 | San Bernardino | 71 | 15419 | 103884 | |
904506 | 904506 | City of South Gate | South Gate | 2021-01-14 | Los Angeles | 37 | 15229 | 98155 | |
904500 | 904500 | City of Santa Clarita | Santa Clarita | 2021-01-14 | Los Angeles | 37 | 15072 | 220424 | |
905374 | 905374 | Modesto | Modesto | 2021-01-14 | Stanislaus | 99 | 14703 | 211336 | |
904525 | 904525 | Los Angeles - Boyle Heights | Boyle Heights | 2021-01-14 | Los Angeles | 37 | 14584 | 86884 | |
905098 | 905098 | Rancho Cucamonga | Rancho Cucamonga | 2021-01-14 | San Bernardino | 71 | 14474 | 177037 | |
904454 | 904454 | City of Downey | Downey | 2021-01-14 | Los Angeles | 37 | 14383 | 114263 | |
904459 | 904459 | City of Glendale | Glendale | 2021-01-14 | Los Angeles | 37 | 14354 | 206493 | |
904456 | 904456 | City of El Monte | El Monte | 2021-01-14 | Los Angeles | 37 | 13937 | 117269 | |
904595 | 904595 | Los Angeles - Pacoima | Pacoima | 2021-01-14 | Los Angeles | 37 | 13757 | 76979 | |
904989 | 904989 | Corona | Corona | 2021-01-14 | Riverside | 65 | 13600 | 165355 | |
904449 | 904449 | City of Compton | Compton | 2021-01-14 | Los Angeles | 37 | 13450 | 99904 | |
905009 | 905009 | Jurupa Valley | Jurupa Valley | 2021-01-14 | Riverside | 65 | 13352 | 103784 | |
905049 | 905049 | Unincorporated Areas | Other | 2021-01-14 | Sacramento | 67 | 12967 | ||
904915 | 904915 | Garden Grove | Garden Grove | 2021-01-14 | Orange | 59 | 12956 | 175155 | |
904485 | 904485 | City of Norwalk | Norwalk | 2021-01-14 | Los Angeles | 37 | 12844 | 107622 | |
904620 | 904620 | Los Angeles - Sylmar | Sylmar | 2021-01-14 | Los Angeles | 37 | 12679 | 82398 | |
904632 | 904632 | Los Angeles - Van Nuys | Van Nuys | 2021-01-14 | Los Angeles | 37 | 11631 | 93194 | |
905075 | 905075 | Hesperia | Hesperia | 2021-01-14 | San Bernardino | 71 | 11484 | 97312 | |
904688 | 904688 | Unincorporated - Florence-Firestone | Unincorporated - Florence-Firestone | 2021-01-14 | Los Angeles | 37 | 11161 | 64705 | |
905213 | 905213 | 92154 | 92154: San Diego | 2021-01-14 | San Diego | 73 | 10940 | 79997 | |
905062 | 905062 | Chino | Chino | 2021-01-14 | San Bernardino | 71 | 10848 | 93099 | |
904478 | 904478 | City of Lynwood | Lynwood | 2021-01-14 | Los Angeles | 37 | 10820 | 72047 | |
904598 | 904598 | Los Angeles - Panorama City | Panorama City | 2021-01-14 | Los Angeles | 37 | 10785 | 75250 | |
905027 | 905027 | Perris | Perris | 2021-01-14 | Riverside | 65 | 10780 | 76276 | |
904437 | 904437 | City of Baldwin Park | Baldwin Park | 2021-01-14 | Los Angeles | 37 | 10633 | 76769 | |
904417 | 904417 | 90805 | 90805: Long Beach | 2021-01-14 | Los Angeles | 37 | 10433 | 96708 | |
904467 | 904467 | City of Inglewood | Inglewood | 2021-01-14 | Los Angeles | 37 | 10402 | 113582 | |
904512 | 904512 | City of West Covina | West Covina | 2021-01-14 | Los Angeles | 37 | 10205 | 108235 | |
905008 | 905008 | Indio | Indio | 2021-01-14 | Riverside | 65 | 9921 | 88291 | |
904930 | 904930 | Orange | Orange | 2021-01-14 | Orange | 59 | 9570 | 141691 | |
905433 | 905433 | 93033 | 93033: Oxnard | 2021-01-14 | Ventura | 111 | 9509 | 83319 | |
904361 | 904361 | 93307 | 93307: Bakersfield | 2021-01-14 | Kern | 29 | 9490 | 84948 | |
904465 | 904465 | City of Huntington Park | Huntington Park | 2021-01-14 | Los Angeles | 37 | 9288 | 59484 | |
904637 | 904637 | Los Angeles - Vernon Central | Vernon Central | 2021-01-14 | Los Angeles | 37 | 9218 | 51998 | |
904489 | 904489 | City of Pico Rivera | Pico Rivera | 2021-01-14 | Los Angeles | 37 | 9114 | 64284 | |
904914 | 904914 | Fullerton | Fullerton | 2021-01-14 | Orange | 59 | 9005 | 142824 | |
904606 | 904606 | Los Angeles - Reseda | Reseda | 2021-01-14 | Los Angeles | 37 | 8999 | 76617 | |
904515 | 904515 | City of Whittier | Whittier | 2021-01-14 | Los Angeles | 37 | 8925 | 87432 | |
905064 | 905064 | Colton | Colton | 2021-01-14 | San Bernardino | 71 | 8596 | 54636 | |
904440 | 904440 | City of Bellflower | Bellflower | 2021-01-14 | Los Angeles | 37 | 8562 | 77735 | |
905114 | 905114 | 91911 | 91911: Chula Vista | 2021-01-14 | San Diego | 73 | 8559 | 84819 | |
905043 | 905043 | Elk Grove | Elk Grove | 2021-01-14 | Sacramento | 67 | 8395 | 168503 | |
904838 | 904838 | Merced | Merced | 2021-01-14 | Merced | 47 | 8368 | 89459 | |
904483 | 904483 | City of Montebello | Montebello | 2021-01-14 | Los Angeles | 37 | 8350 | 64375 | |
905310 | 905310 | Santa Maria | Santa Maria | 2021-01-14 | Santa Barbara | 83 | 8272 | 99553 | |
904645 | 904645 | Los Angeles - West Vernon | West Vernon | 2021-01-14 | Los Angeles | 37 | 8236 | 53644 | |
904916 | 904916 | Huntington Beach | Huntington Beach | 2021-01-14 | Orange | 59 | 8197 | 203761 | |
904488 | 904488 | City of Paramount | Paramount | 2021-01-14 | Los Angeles | 37 | 8106 | 56023 | |
904278 | 904278 | Richmond | Richmond | 2021-01-14 | Contra Costa | 13 | 7870 | 111217 | |
904917 | 904917 | Irvine | Irvine | 2021-01-14 | Orange | 59 | 7795 | 280202 | |
904462 | 904462 | City of Hawthorne | Hawthorne | 2021-01-14 | Los Angeles | 37 | 7792 | 88787 | |
905399 | 905399 | 93257 | Porterville: 93257 | 2021-01-14 | Tulare | 107 | 7785 | 76923 | |
905052 | 905052 | Apple Valley | Apple Valley | 2021-01-14 | San Bernardino | 71 | 7755 | 73694 | |
904554 | 904554 | Los Angeles - Florence-Firestone | Florence-Firestone | 2021-01-14 | Los Angeles | 37 | 7701 | 47445 | |
904591 | 904591 | Los Angeles - North Hills | North Hills | 2021-01-14 | Los Angeles | 37 | 7355 | 61575 | |
904617 | 904617 | Los Angeles - Sun Valley | Sun Valley | 2021-01-14 | Los Angeles | 37 | 7332 | 52483 | |
904845 | 904845 | 93905 | 93905: Salinas | 2021-01-14 | Monterey | 53 | 7306 | 60408 | |
904529 | 904529 | Los Angeles - Canoga Park | Canoga Park | 2021-01-14 | Los Angeles | 37 | 7206 | 65289 | |
905018 | 905018 | Menifee | Menifee | 2021-01-14 | Riverside | 65 | 7189 | 88515 | |
904360 | 904360 | 93306 | 93306: Bakersfield | 2021-01-14 | Kern | 29 | 7138 | 70208 | |
905099 | 905099 | Redlands | Redlands | 2021-01-14 | San Bernardino | 71 | 7115 | 72099 | |
905339 | 905339 | Vallejo | Vallejo | 2021-01-14 | Solano | 95 | 7049 | 119544 | |
905406 | 905406 | 93274 | Tulare: 93274 | 2021-01-14 | Tulare | 107 | 7049 | 73778 | |
904445 | 904445 | City of Carson | Carson | 2021-01-14 | Los Angeles | 37 | 6985 | 93846 | |
904378 | 904378 | 93215 | 93215: Delano | 2021-01-14 | Kern | 29 | 6941 | 55845 | |
905380 | 905380 | Unincorporated districts | Other | 2021-01-14 | Stanislaus | 99 | 6927 | ||
905432 | 905432 | 93030 | 93030: Oxnard | 2021-01-14 | Ventura | 111 | 6908 | 62016 | |
904393 | 904393 | Correctional facilities | Prisons | 2021-01-14 | Kings | 31 | 6901 | ||
905223 | 905223 | 91910 | 91910: Chula Vista | 2021-01-14 | San Diego | 73 | 6862 | 83834 | |
904909 | 904909 | Costa Mesa | Costa Mesa | 2021-01-14 | Orange | 59 | 6861 | 115830 | |
905108 | 905108 | Upland | Upland | 2021-01-14 | San Bernardino | 71 | 6837 | 78249 | |
904439 | 904439 | City of Bell Gardens | Bell Gardens | 2021-01-14 | Los Angeles | 37 | 6822 | 43071 | |
905334 | 905334 | Fairfield | Fairfield | 2021-01-14 | Solano | 95 | 6798 | 117149 | |
904325 | 904325 | 92231 | 92231: Calexico | 2021-01-14 | Imperial | 25 | 6762 | 40019 | |
905002 | 905002 | Hemet | Hemet | 2021-01-14 | Riverside | 65 | 6750 | 84069 | |
904742 | 904742 | Unincorporated - South Whittier | South Whittier | 2021-01-14 | Los Angeles | 37 | 6694 | 59222 | |
905076 | 905076 | Highland | Highland | 2021-01-14 | San Bernardino | 71 | 6650 | 55484 | |
904988 | 904988 | Coachella | Coachella | 2021-01-14 | Riverside | 65 | 6598 | 44849 | |
904254 | 904254 | Antioch | Antioch | 2021-01-14 | Contra Costa | 13 | 6595 | 112520 | |
904443 | 904443 | City of Burbank | Burbank | 2021-01-14 | Los Angeles | 37 | 6552 | 107180 | |
904531 | 904531 | Los Angeles - Central | Central | 2021-01-14 | Los Angeles | 37 | 6296 | 38992 | |
904650 | 904650 | Los Angeles - Wilmington | Wilmington | 2021-01-14 | Los Angeles | 37 | 6296 | 56487 | |
905338 | 905338 | Vacaville | Vacaville | 2021-01-14 | Solano | 95 | 6295 | 98807 |
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 );