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-20 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 |
---|---|---|---|---|---|---|---|---|---|
897668 | 897668 | San Jose | San Jose | 2021-01-20 | Santa Clara | 85 | 62668 | 1026658 | |
897392 | 897392 | Sacramento | Sacramento | 2021-01-20 | Sacramento | 67 | 44609 | 495011 | |
897373 | 897373 | Riverside | Riverside | 2021-01-20 | Riverside | 65 | 41252 | 323935 | |
897281 | 897281 | Santa Ana | Santa Ana | 2021-01-20 | Orange | 59 | 39420 | 337716 | |
897250 | 897250 | Anaheim | Anaheim | 2021-01-20 | Orange | 59 | 36335 | 359339 | |
897447 | 897447 | San Bernardino | San Bernardino | 2021-01-20 | San Bernardino | 71 | 35662 | 218515 | |
897413 | 897413 | Fontana | Fontana | 2021-01-20 | San Bernardino | 71 | 34545 | 215334 | |
897363 | 897363 | Moreno Valley | Moreno Valley | 2021-01-20 | Riverside | 65 | 28354 | 205034 | |
896648 | 896648 | Fresno | Fresno | 2021-01-20 | Fresno | 19 | 26967 | 608579 | |
897437 | 897437 | Ontario | Ontario | 2021-01-20 | San Bernardino | 71 | 22763 | 182380 | |
897026 | 897026 | Unincorporated - East Los Angeles | East Los Angeles | 2021-01-20 | Los Angeles | 37 | 21982 | 125269 | |
896834 | 896834 | City of Pomona | Pomona | 2021-01-20 | Los Angeles | 37 | 21206 | 155931 | |
896830 | 896830 | City of Palmdale | Palmdale | 2021-01-20 | Los Angeles | 37 | 20415 | 158968 | |
897453 | 897453 | Victorville | Victorville | 2021-01-20 | San Bernardino | 71 | 18357 | 128353 | |
896819 | 896819 | City of Lancaster | Lancaster | 2021-01-20 | Los Angeles | 37 | 17921 | 161570 | |
896936 | 896936 | Los Angeles - North Hollywood | North Hollywood | 2021-01-20 | Los Angeles | 37 | 17091 | 151421 | |
897444 | 897444 | Rialto | Rialto | 2021-01-20 | San Bernardino | 71 | 16374 | 103884 | |
896844 | 896844 | City of Santa Clarita | Santa Clarita | 2021-01-20 | Los Angeles | 37 | 16096 | 220424 | |
896850 | 896850 | City of South Gate | South Gate | 2021-01-20 | Los Angeles | 37 | 16085 | 98155 | |
897718 | 897718 | Modesto | Modesto | 2021-01-20 | Stanislaus | 99 | 15711 | 211336 | |
897442 | 897442 | Rancho Cucamonga | Rancho Cucamonga | 2021-01-20 | San Bernardino | 71 | 15609 | 177037 | |
896869 | 896869 | Los Angeles - Boyle Heights | Boyle Heights | 2021-01-20 | Los Angeles | 37 | 15399 | 86884 | |
896803 | 896803 | City of Glendale | Glendale | 2021-01-20 | Los Angeles | 37 | 15363 | 206493 | |
896798 | 896798 | City of Downey | Downey | 2021-01-20 | Los Angeles | 37 | 15104 | 114263 | |
896800 | 896800 | City of El Monte | El Monte | 2021-01-20 | Los Angeles | 37 | 14760 | 117269 | |
896939 | 896939 | Los Angeles - Pacoima | Pacoima | 2021-01-20 | Los Angeles | 37 | 14695 | 76979 | |
897333 | 897333 | Corona | Corona | 2021-01-20 | Riverside | 65 | 14568 | 165355 | |
896793 | 896793 | City of Compton | Compton | 2021-01-20 | Los Angeles | 37 | 14313 | 99904 | |
897353 | 897353 | Jurupa Valley | Jurupa Valley | 2021-01-20 | Riverside | 65 | 14236 | 103784 | |
897393 | 897393 | Unincorporated Areas | Other | 2021-01-20 | Sacramento | 67 | 13891 | ||
897259 | 897259 | Garden Grove | Garden Grove | 2021-01-20 | Orange | 59 | 13890 | 175155 | |
896829 | 896829 | City of Norwalk | Norwalk | 2021-01-20 | Los Angeles | 37 | 13643 | 107622 | |
896964 | 896964 | Los Angeles - Sylmar | Sylmar | 2021-01-20 | Los Angeles | 37 | 13566 | 82398 | |
896976 | 896976 | Los Angeles - Van Nuys | Van Nuys | 2021-01-20 | Los Angeles | 37 | 12303 | 93194 | |
897419 | 897419 | Hesperia | Hesperia | 2021-01-20 | San Bernardino | 71 | 12203 | 97312 | |
897032 | 897032 | Unincorporated - Florence-Firestone | Unincorporated - Florence-Firestone | 2021-01-20 | Los Angeles | 37 | 11809 | 64705 | |
897371 | 897371 | Perris | Perris | 2021-01-20 | Riverside | 65 | 11607 | 76276 | |
897406 | 897406 | Chino | Chino | 2021-01-20 | San Bernardino | 71 | 11548 | 93099 | |
897557 | 897557 | 92154 | 92154: San Diego | 2021-01-20 | San Diego | 73 | 11449 | 79997 | |
896822 | 896822 | City of Lynwood | Lynwood | 2021-01-20 | Los Angeles | 37 | 11443 | 72047 | |
896942 | 896942 | Los Angeles - Panorama City | Panorama City | 2021-01-20 | Los Angeles | 37 | 11397 | 75250 | |
896781 | 896781 | City of Baldwin Park | Baldwin Park | 2021-01-20 | Los Angeles | 37 | 11372 | 76769 | |
896761 | 896761 | 90805 | 90805: Long Beach | 2021-01-20 | Los Angeles | 37 | 11336 | 96708 | |
896811 | 896811 | City of Inglewood | Inglewood | 2021-01-20 | Los Angeles | 37 | 11168 | 113582 | |
897777 | 897777 | 93033 | 93033: Oxnard | 2021-01-20 | Ventura | 111 | 10867 | 83319 | |
896856 | 896856 | City of West Covina | West Covina | 2021-01-20 | Los Angeles | 37 | 10854 | 108235 | |
897352 | 897352 | Indio | Indio | 2021-01-20 | Riverside | 65 | 10625 | 88291 | |
897274 | 897274 | Orange | Orange | 2021-01-20 | Orange | 59 | 10189 | 141691 | |
896705 | 896705 | 93307 | 93307: Bakersfield | 2021-01-20 | Kern | 29 | 9968 | 84948 | |
896809 | 896809 | City of Huntington Park | Huntington Park | 2021-01-20 | Los Angeles | 37 | 9836 | 59484 | |
896981 | 896981 | Los Angeles - Vernon Central | Vernon Central | 2021-01-20 | Los Angeles | 37 | 9745 | 51998 | |
896950 | 896950 | Los Angeles - Reseda | Reseda | 2021-01-20 | Los Angeles | 37 | 9678 | 76617 | |
897258 | 897258 | Fullerton | Fullerton | 2021-01-20 | Orange | 59 | 9658 | 142824 | |
896833 | 896833 | City of Pico Rivera | Pico Rivera | 2021-01-20 | Los Angeles | 37 | 9588 | 64284 | |
896859 | 896859 | City of Whittier | Whittier | 2021-01-20 | Los Angeles | 37 | 9417 | 87432 | |
897387 | 897387 | Elk Grove | Elk Grove | 2021-01-20 | Sacramento | 67 | 9163 | 168503 | |
897408 | 897408 | Colton | Colton | 2021-01-20 | San Bernardino | 71 | 9147 | 54636 | |
896784 | 896784 | City of Bellflower | Bellflower | 2021-01-20 | Los Angeles | 37 | 9083 | 77735 | |
897458 | 897458 | 91911 | 91911: Chula Vista | 2021-01-20 | San Diego | 73 | 9081 | 84819 | |
897654 | 897654 | Santa Maria | Santa Maria | 2021-01-20 | Santa Barbara | 83 | 8858 | 99553 | |
897182 | 897182 | Merced | Merced | 2021-01-20 | Merced | 47 | 8810 | 89459 | |
897260 | 897260 | Huntington Beach | Huntington Beach | 2021-01-20 | Orange | 59 | 8803 | 203761 | |
896827 | 896827 | City of Montebello | Montebello | 2021-01-20 | Los Angeles | 37 | 8788 | 64375 | |
896989 | 896989 | Los Angeles - West Vernon | West Vernon | 2021-01-20 | Los Angeles | 37 | 8781 | 53644 | |
896832 | 896832 | City of Paramount | Paramount | 2021-01-20 | Los Angeles | 37 | 8571 | 56023 | |
897261 | 897261 | Irvine | Irvine | 2021-01-20 | Orange | 59 | 8442 | 280202 | |
896806 | 896806 | City of Hawthorne | Hawthorne | 2021-01-20 | Los Angeles | 37 | 8418 | 88787 | |
897743 | 897743 | 93257 | Porterville: 93257 | 2021-01-20 | Tulare | 107 | 8344 | 76923 | |
896622 | 896622 | Richmond | Richmond | 2021-01-20 | Contra Costa | 13 | 8327 | 111217 | |
897396 | 897396 | Apple Valley | Apple Valley | 2021-01-20 | San Bernardino | 71 | 8205 | 73694 | |
896898 | 896898 | Los Angeles - Florence-Firestone | Florence-Firestone | 2021-01-20 | Los Angeles | 37 | 8097 | 47445 | |
896961 | 896961 | Los Angeles - Sun Valley | Sun Valley | 2021-01-20 | Los Angeles | 37 | 7877 | 52483 | |
896935 | 896935 | Los Angeles - North Hills | North Hills | 2021-01-20 | Los Angeles | 37 | 7806 | 61575 | |
897362 | 897362 | Menifee | Menifee | 2021-01-20 | Riverside | 65 | 7797 | 88515 | |
896873 | 896873 | Los Angeles - Canoga Park | Canoga Park | 2021-01-20 | Los Angeles | 37 | 7789 | 65289 | |
897776 | 897776 | 93030 | 93030: Oxnard | 2021-01-20 | Ventura | 111 | 7765 | 62016 | |
897189 | 897189 | 93905 | 93905: Salinas | 2021-01-20 | Monterey | 53 | 7613 | 60408 | |
897683 | 897683 | Vallejo | Vallejo | 2021-01-20 | Solano | 95 | 7585 | 119544 | |
896789 | 896789 | City of Carson | Carson | 2021-01-20 | Los Angeles | 37 | 7555 | 93846 | |
897443 | 897443 | Redlands | Redlands | 2021-01-20 | San Bernardino | 71 | 7530 | 72099 | |
896704 | 896704 | 93306 | 93306: Bakersfield | 2021-01-20 | Kern | 29 | 7502 | 70208 | |
897346 | 897346 | Hemet | Hemet | 2021-01-20 | Riverside | 65 | 7483 | 84069 | |
897253 | 897253 | Costa Mesa | Costa Mesa | 2021-01-20 | Orange | 59 | 7451 | 115830 | |
897750 | 897750 | 93274 | Tulare: 93274 | 2021-01-20 | Tulare | 107 | 7446 | 73778 | |
897724 | 897724 | Unincorporated districts | Other | 2021-01-20 | Stanislaus | 99 | 7386 | ||
897452 | 897452 | Upland | Upland | 2021-01-20 | San Bernardino | 71 | 7332 | 78249 | |
896722 | 896722 | 93215 | 93215: Delano | 2021-01-20 | Kern | 29 | 7320 | 55845 | |
897567 | 897567 | 91910 | 91910: Chula Vista | 2021-01-20 | San Diego | 73 | 7297 | 83834 | |
897678 | 897678 | Fairfield | Fairfield | 2021-01-20 | Solano | 95 | 7257 | 117149 | |
896783 | 896783 | City of Bell Gardens | Bell Gardens | 2021-01-20 | Los Angeles | 37 | 7158 | 43071 | |
896598 | 896598 | Antioch | Antioch | 2021-01-20 | Contra Costa | 13 | 7156 | 112520 | |
897086 | 897086 | Unincorporated - South Whittier | South Whittier | 2021-01-20 | Los Angeles | 37 | 7053 | 59222 | |
897420 | 897420 | Highland | Highland | 2021-01-20 | San Bernardino | 71 | 7021 | 55484 | |
896737 | 896737 | Correctional facilities | Prisons | 2021-01-20 | Kings | 31 | 7020 | ||
896787 | 896787 | City of Burbank | Burbank | 2021-01-20 | Los Angeles | 37 | 6989 | 107180 | |
897332 | 897332 | Coachella | Coachella | 2021-01-20 | Riverside | 65 | 6965 | 44849 | |
896669 | 896669 | 92231 | 92231: Calexico | 2021-01-20 | Imperial | 25 | 6875 | 40019 | |
896994 | 896994 | Los Angeles - Wilmington | Wilmington | 2021-01-20 | Los Angeles | 37 | 6838 | 56487 | |
897364 | 897364 | Murrieta | Murrieta | 2021-01-20 | Riverside | 65 | 6827 | 111427 | |
896766 | 896766 | 90813 | 90813: Long Beach | 2021-01-20 | Los Angeles | 37 | 6823 | 59000 |
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 );