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-04 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 |
---|---|---|---|---|---|---|---|---|---|
918084 | 918084 | San Jose | San Jose | 2021-01-04 | Santa Clara | 85 | 49015 | 1026658 | |
917808 | 917808 | Sacramento | Sacramento | 2021-01-04 | Sacramento | 67 | 38167 | 495011 | |
917789 | 917789 | Riverside | Riverside | 2021-01-04 | Riverside | 65 | 33061 | 323935 | |
917697 | 917697 | Santa Ana | Santa Ana | 2021-01-04 | Orange | 59 | 32077 | 337716 | |
917666 | 917666 | Anaheim | Anaheim | 2021-01-04 | Orange | 59 | 28994 | 359339 | |
917863 | 917863 | San Bernardino | San Bernardino | 2021-01-04 | San Bernardino | 71 | 28850 | 218515 | |
917829 | 917829 | Fontana | Fontana | 2021-01-04 | San Bernardino | 71 | 26989 | 215334 | |
917064 | 917064 | Fresno | Fresno | 2021-01-04 | Fresno | 19 | 26967 | 608579 | |
917779 | 917779 | Moreno Valley | Moreno Valley | 2021-01-04 | Riverside | 65 | 22290 | 205034 | |
917442 | 917442 | Unincorporated - East Los Angeles | East Los Angeles | 2021-01-04 | Los Angeles | 37 | 18153 | 125269 | |
917853 | 917853 | Ontario | Ontario | 2021-01-04 | San Bernardino | 71 | 17988 | 182380 | |
917250 | 917250 | City of Pomona | Pomona | 2021-01-04 | Los Angeles | 37 | 17462 | 155931 | |
917246 | 917246 | City of Palmdale | Palmdale | 2021-01-04 | Los Angeles | 37 | 16311 | 158968 | |
917869 | 917869 | Victorville | Victorville | 2021-01-04 | San Bernardino | 71 | 14797 | 128353 | |
917235 | 917235 | City of Lancaster | Lancaster | 2021-01-04 | Los Angeles | 37 | 14570 | 161570 | |
917352 | 917352 | Los Angeles - North Hollywood | North Hollywood | 2021-01-04 | Los Angeles | 37 | 13552 | 151421 | |
917860 | 917860 | Rialto | Rialto | 2021-01-04 | San Bernardino | 71 | 13059 | 103884 | |
917266 | 917266 | City of South Gate | South Gate | 2021-01-04 | Los Angeles | 37 | 12926 | 98155 | |
918134 | 918134 | Modesto | Modesto | 2021-01-04 | Stanislaus | 99 | 12885 | 211336 | |
917260 | 917260 | City of Santa Clarita | Santa Clarita | 2021-01-04 | Los Angeles | 37 | 12725 | 220424 | |
917285 | 917285 | Los Angeles - Boyle Heights | Boyle Heights | 2021-01-04 | Los Angeles | 37 | 12518 | 86884 | |
917214 | 917214 | City of Downey | Downey | 2021-01-04 | Los Angeles | 37 | 12424 | 114263 | |
917809 | 917809 | Unincorporated Areas | Other | 2021-01-04 | Sacramento | 67 | 12198 | ||
917216 | 917216 | City of El Monte | El Monte | 2021-01-04 | Los Angeles | 37 | 12032 | 117269 | |
917219 | 917219 | City of Glendale | Glendale | 2021-01-04 | Los Angeles | 37 | 12004 | 206493 | |
917858 | 917858 | Rancho Cucamonga | Rancho Cucamonga | 2021-01-04 | San Bernardino | 71 | 11835 | 177037 | |
917355 | 917355 | Los Angeles - Pacoima | Pacoima | 2021-01-04 | Los Angeles | 37 | 11795 | 76979 | |
917749 | 917749 | Corona | Corona | 2021-01-04 | Riverside | 65 | 11582 | 165355 | |
917769 | 917769 | Jurupa Valley | Jurupa Valley | 2021-01-04 | Riverside | 65 | 11547 | 103784 | |
917209 | 917209 | City of Compton | Compton | 2021-01-04 | Los Angeles | 37 | 11506 | 99904 | |
917245 | 917245 | City of Norwalk | Norwalk | 2021-01-04 | Los Angeles | 37 | 10728 | 107622 | |
917380 | 917380 | Los Angeles - Sylmar | Sylmar | 2021-01-04 | Los Angeles | 37 | 10711 | 82398 | |
917675 | 917675 | Garden Grove | Garden Grove | 2021-01-04 | Orange | 59 | 10687 | 175155 | |
917392 | 917392 | Los Angeles - Van Nuys | Van Nuys | 2021-01-04 | Los Angeles | 37 | 9983 | 93194 | |
917835 | 917835 | Hesperia | Hesperia | 2021-01-04 | San Bernardino | 71 | 9789 | 97312 | |
917448 | 917448 | Unincorporated - Florence-Firestone | Unincorporated - Florence-Firestone | 2021-01-04 | Los Angeles | 37 | 9612 | 64705 | |
917973 | 917973 | 92154 | 92154: San Diego | 2021-01-04 | San Diego | 73 | 9504 | 79997 | |
917238 | 917238 | City of Lynwood | Lynwood | 2021-01-04 | Los Angeles | 37 | 9334 | 72047 | |
917822 | 917822 | Chino | Chino | 2021-01-04 | San Bernardino | 71 | 9230 | 93099 | |
917787 | 917787 | Perris | Perris | 2021-01-04 | Riverside | 65 | 9170 | 76276 | |
917358 | 917358 | Los Angeles - Panorama City | Panorama City | 2021-01-04 | Los Angeles | 37 | 9136 | 75250 | |
917197 | 917197 | City of Baldwin Park | Baldwin Park | 2021-01-04 | Los Angeles | 37 | 9055 | 76769 | |
917177 | 917177 | 90805 | 90805: Long Beach | 2021-01-04 | Los Angeles | 37 | 8842 | 96708 | |
917272 | 917272 | City of West Covina | West Covina | 2021-01-04 | Los Angeles | 37 | 8825 | 108235 | |
917227 | 917227 | City of Inglewood | Inglewood | 2021-01-04 | Los Angeles | 37 | 8759 | 113582 | |
917768 | 917768 | Indio | Indio | 2021-01-04 | Riverside | 65 | 8506 | 88291 | |
917121 | 917121 | 93307 | 93307: Bakersfield | 2021-01-04 | Kern | 29 | 8391 | 84948 | |
917690 | 917690 | Orange | Orange | 2021-01-04 | Orange | 59 | 8216 | 141691 | |
917225 | 917225 | City of Huntington Park | Huntington Park | 2021-01-04 | Los Angeles | 37 | 7958 | 59484 | |
917397 | 917397 | Los Angeles - Vernon Central | Vernon Central | 2021-01-04 | Los Angeles | 37 | 7877 | 51998 | |
917249 | 917249 | City of Pico Rivera | Pico Rivera | 2021-01-04 | Los Angeles | 37 | 7852 | 64284 | |
917803 | 917803 | Elk Grove | Elk Grove | 2021-01-04 | Sacramento | 67 | 7741 | 168503 | |
917275 | 917275 | City of Whittier | Whittier | 2021-01-04 | Los Angeles | 37 | 7716 | 87432 | |
917674 | 917674 | Fullerton | Fullerton | 2021-01-04 | Orange | 59 | 7604 | 142824 | |
917366 | 917366 | Los Angeles - Reseda | Reseda | 2021-01-04 | Los Angeles | 37 | 7585 | 76617 | |
917598 | 917598 | Merced | Merced | 2021-01-04 | Merced | 47 | 7515 | 89459 | |
917874 | 917874 | 91911 | 91911: Chula Vista | 2021-01-04 | San Diego | 73 | 7484 | 84819 | |
917824 | 917824 | Colton | Colton | 2021-01-04 | San Bernardino | 71 | 7393 | 54636 | |
917200 | 917200 | City of Bellflower | Bellflower | 2021-01-04 | Los Angeles | 37 | 7283 | 77735 | |
917243 | 917243 | City of Montebello | Montebello | 2021-01-04 | Los Angeles | 37 | 7255 | 64375 | |
918193 | 918193 | 93033 | 93033: Oxnard | 2021-01-04 | Ventura | 111 | 7160 | 83319 | |
917038 | 917038 | Richmond | Richmond | 2021-01-04 | Contra Costa | 13 | 6984 | 111217 | |
917248 | 917248 | City of Paramount | Paramount | 2021-01-04 | Los Angeles | 37 | 6968 | 56023 | |
917405 | 917405 | Los Angeles - West Vernon | West Vernon | 2021-01-04 | Los Angeles | 37 | 6953 | 53644 | |
918070 | 918070 | Santa Maria | Santa Maria | 2021-01-04 | Santa Barbara | 83 | 6882 | 99553 | |
917676 | 917676 | Huntington Beach | Huntington Beach | 2021-01-04 | Orange | 59 | 6826 | 203761 | |
917153 | 917153 | Correctional facilities | Prisons | 2021-01-04 | Kings | 31 | 6787 | ||
918159 | 918159 | 93257 | Porterville: 93257 | 2021-01-04 | Tulare | 107 | 6744 | 76923 | |
917314 | 917314 | Los Angeles - Florence-Firestone | Florence-Firestone | 2021-01-04 | Los Angeles | 37 | 6688 | 47445 | |
917812 | 917812 | Apple Valley | Apple Valley | 2021-01-04 | San Bernardino | 71 | 6661 | 73694 | |
917222 | 917222 | City of Hawthorne | Hawthorne | 2021-01-04 | Los Angeles | 37 | 6478 | 88787 | |
917085 | 917085 | 92231 | 92231: Calexico | 2021-01-04 | Imperial | 25 | 6454 | 40019 | |
917120 | 917120 | 93306 | 93306: Bakersfield | 2021-01-04 | Kern | 29 | 6289 | 70208 | |
917677 | 917677 | Irvine | Irvine | 2021-01-04 | Orange | 59 | 6282 | 280202 | |
917138 | 917138 | 93215 | 93215: Delano | 2021-01-04 | Kern | 29 | 6246 | 55845 | |
917351 | 917351 | Los Angeles - North Hills | North Hills | 2021-01-04 | Los Angeles | 37 | 6218 | 61575 | |
917377 | 917377 | Los Angeles - Sun Valley | Sun Valley | 2021-01-04 | Los Angeles | 37 | 6154 | 52483 | |
918140 | 918140 | Unincorporated districts | Other | 2021-01-04 | Stanislaus | 99 | 6131 | ||
918099 | 918099 | Vallejo | Vallejo | 2021-01-04 | Solano | 95 | 6092 | 119544 | |
917605 | 917605 | 93905 | 93905: Salinas | 2021-01-04 | Monterey | 53 | 6076 | 60408 | |
917289 | 917289 | Los Angeles - Canoga Park | Canoga Park | 2021-01-04 | Los Angeles | 37 | 6068 | 65289 | |
918166 | 918166 | 93274 | Tulare: 93274 | 2021-01-04 | Tulare | 107 | 6047 | 73778 | |
917983 | 917983 | 91910 | 91910: Chula Vista | 2021-01-04 | San Diego | 73 | 5956 | 83834 | |
917859 | 917859 | Redlands | Redlands | 2021-01-04 | San Bernardino | 71 | 5949 | 72099 | |
918094 | 918094 | Fairfield | Fairfield | 2021-01-04 | Solano | 95 | 5903 | 117149 | |
917778 | 917778 | Menifee | Menifee | 2021-01-04 | Riverside | 65 | 5900 | 88515 | |
917199 | 917199 | City of Bell Gardens | Bell Gardens | 2021-01-04 | Los Angeles | 37 | 5876 | 43071 | |
917502 | 917502 | Unincorporated - South Whittier | South Whittier | 2021-01-04 | Los Angeles | 37 | 5846 | 59222 | |
917205 | 917205 | City of Carson | Carson | 2021-01-04 | Los Angeles | 37 | 5839 | 93846 | |
917748 | 917748 | Coachella | Coachella | 2021-01-04 | Riverside | 65 | 5769 | 44849 | |
917762 | 917762 | Hemet | Hemet | 2021-01-04 | Riverside | 65 | 5681 | 84069 | |
917836 | 917836 | Highland | Highland | 2021-01-04 | San Bernardino | 71 | 5630 | 55484 | |
917669 | 917669 | Costa Mesa | Costa Mesa | 2021-01-04 | Orange | 59 | 5612 | 115830 | |
917014 | 917014 | Antioch | Antioch | 2021-01-04 | Contra Costa | 13 | 5586 | 112520 | |
917203 | 917203 | City of Burbank | Burbank | 2021-01-04 | Los Angeles | 37 | 5579 | 107180 | |
917868 | 917868 | Upland | Upland | 2021-01-04 | San Bernardino | 71 | 5525 | 78249 | |
917291 | 917291 | Los Angeles - Central | Central | 2021-01-04 | Los Angeles | 37 | 5440 | 38992 | |
918192 | 918192 | 93030 | 93030: Oxnard | 2021-01-04 | Ventura | 111 | 5436 | 62016 | |
918144 | 918144 | Yuba City | Yuba City | 2021-01-04 | Sutter | 101 | 5414 | 66388 | |
917410 | 917410 | Los Angeles - Wilmington | Wilmington | 2021-01-04 | Los Angeles | 37 | 5402 | 56487 |
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 );