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-22 sorted by name descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name ▲ | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
390256 | 390256 | Yucca Valley | Yucca Valley | 2022-02-22 | San Bernardino | 71 | 4179 | 22146 | |
390255 | 390255 | Yucaipa | Yucaipa | 2022-02-22 | San Bernardino | 71 | 12191 | 54490 | |
390543 | 390543 | Yuba City | Yuba City | 2022-02-22 | Sutter | 101 | 18137 | 66388 | |
390030 | 390030 | Yountville | Yountville | 2022-02-22 | Napa | 55 | 342 | 3032 | |
390088 | 390088 | Yorba Linda | Yorba Linda | 2022-02-22 | Orange | 59 | 11250 | 68706 | |
390254 | 390254 | Yermo | Yermo | 2022-02-22 | San Bernardino | 71 | 170 | 1672 | |
390253 | 390253 | Wrightwood | Wrightwood | 2022-02-22 | San Bernardino | 71 | 741 | 5177 | |
390444 | 390444 | Woodside | Woodside | 2022-02-22 | San Mateo | 81 | 525 | 5542 | |
389796 | 389796 | Los Angeles - Woodland Hills | Woodland Hills | 2022-02-22 | Los Angeles | 37 | 14115 | 68055 | |
390605 | 390605 | Woodland | Woodland | 2022-02-22 | Yolo | 113 | 11538 | 59044 | |
390567 | 390567 | 93286 | Woodlake: 93286 | 2022-02-22 | Tulare | 107 | 1867 | 9755 | |
390184 | 390184 | Woodcrest | Woodcrest | 2022-02-22 | Riverside | 65 | 3436 | 17310 | |
389909 | 389909 | Unincorporated - Wiseburn | Wiseburn | 2022-02-22 | Los Angeles | 37 | 1386 | 6027 | |
389982 | 389982 | Winton | Winton | 2022-02-22 | Merced | 47 | 3963 | 10613 | |
390604 | 390604 | Winters | Winters | 2022-02-22 | Yolo | 113 | 1172 | 7132 | |
389795 | 389795 | Los Angeles - Winnetka | Winnetka | 2022-02-22 | Los Angeles | 37 | 15040 | 51786 | |
390183 | 390183 | Winchester | Winchester | 2022-02-22 | Riverside | 65 | 366 | 2931 | |
389794 | 389794 | Los Angeles - Wilshire Center | Wilshire Center | 2022-02-22 | Los Angeles | 37 | 12567 | 50170 | |
389793 | 389793 | Los Angeles - Wilmington | Wilmington | 2022-02-22 | Los Angeles | 37 | 19112 | 56487 | |
389908 | 389908 | Unincorporated - Willowbrook | Willowbrook | 2022-02-22 | Los Angeles | 37 | 13534 | 34913 | |
390182 | 390182 | Wildomar | Wildomar | 2022-02-22 | Riverside | 65 | 7718 | 36162 | |
389792 | 389792 | Los Angeles - Wholesale District | Wholesale District | 2022-02-22 | Los Angeles | 37 | 16048 | 36129 | |
389907 | 389907 | Unincorporated - Whittier Narrows | Whittier Narrows | 2022-02-22 | Los Angeles | 37 | 64 | 12 | |
389658 | 389658 | City of Whittier | Whittier | 2022-02-22 | Los Angeles | 37 | 22931 | 87432 | |
389905 | 389905 | Unincorporated - White Fence Farms | White Fence Farms | 2022-02-22 | Los Angeles | 37 | 716 | 3683 | |
390610 | 390610 | Wheatland | Wheatland | 2022-02-22 | Yuba | 115 | 960 | 3747 | |
389791 | 389791 | Los Angeles - Westwood | Westwood | 2022-02-22 | Los Angeles | 37 | 9241 | 54109 | |
390087 | 390087 | Westminster | Westminster | 2022-02-22 | Orange | 59 | 15201 | 92610 | |
389657 | 389657 | City of Westlake Village | Westlake Village | 2022-02-22 | Los Angeles | 37 | 266 | 8360 | |
389790 | 389790 | Los Angeles - Westlake | Westlake | 2022-02-22 | Los Angeles | 37 | 16722 | 59355 | |
389904 | 389904 | Unincorporated - Westhills | Westhills | 2022-02-22 | Los Angeles | 37 | 127 | 839 | |
389903 | 389903 | Unincorporated - Westfield/Academy Hills | Westfield/Academy Hills | 2022-02-22 | Los Angeles | 37 | 159 | 1300 | |
389789 | 389789 | Los Angeles - Westchester | Westchester | 2022-02-22 | Los Angeles | 37 | 8450 | 51603 | |
389902 | 389902 | Unincorporated - West Whittier/Los Nietos | West Whittier/Los Nietos | 2022-02-22 | Los Angeles | 37 | 8060 | 26925 | |
389788 | 389788 | Los Angeles - West Vernon | West Vernon | 2022-02-22 | Los Angeles | 37 | 19977 | 53644 | |
390603 | 390603 | West Sacramento | West Sacramento | 2022-02-22 | Yolo | 113 | 10089 | 52826 | |
389901 | 389901 | Unincorporated - West Rancho Dominguez | West Rancho Dominguez | 2022-02-22 | Los Angeles | 37 | 383 | 1359 | |
389900 | 389900 | Unincorporated - West Puente Valley | West Puente Valley | 2022-02-22 | Los Angeles | 37 | 3194 | 9835 | |
390029 | 390029 | West Napa and Yountville Area | West Napa and Yountville Area | 2022-02-22 | Napa | 55 | 129 | 1699 | |
390028 | 390028 | West Napa Area | West Napa Area | 2022-02-22 | Napa | 55 | 87 | 951 | |
390443 | 390443 | West Menlo Park | West Menlo Park | 2022-02-22 | San Mateo | 81 | 341 | 4160 | |
389787 | 389787 | Los Angeles - West Los Angeles | West Los Angeles | 2022-02-22 | Los Angeles | 37 | 7211 | 37636 | |
389656 | 389656 | City of West Hollywood | West Hollywood | 2022-02-22 | Los Angeles | 37 | 7678 | 36951 | |
389786 | 389786 | Los Angeles - West Hills | West Hills | 2022-02-22 | Los Angeles | 37 | 8522 | 40545 | |
389655 | 389655 | City of West Covina | West Covina | 2022-02-22 | Los Angeles | 37 | 28775 | 108235 | |
390547 | 390547 | West County | West County | 2022-02-22 | Trinity | 105 | 108 | 2254 | |
389898 | 389898 | Unincorporated - West Chatsworth | West Chatsworth | 2022-02-22 | Los Angeles | 37 | 4 | 0 | |
389897 | 389897 | Unincorporated - West Carson | West Carson | 2022-02-22 | Los Angeles | 37 | 5385 | 22086 | |
389896 | 389896 | Unincorporated - West Antelope Valley | West Antelope Valley | 2022-02-22 | Los Angeles | 37 | 130 | 1511 | |
389785 | 389785 | Los Angeles - West Adams | West Adams | 2022-02-22 | Los Angeles | 37 | 8448 | 27630 | |
390490 | 390490 | West | West | 2022-02-22 | Siskiyou | 93 | 736 | 7514 | |
389784 | 389784 | Los Angeles - Wellington Square | Wellington Square | 2022-02-22 | Los Angeles | 37 | 1379 | 4915 | |
389783 | 389783 | Los Angeles - Watts | Watts | 2022-02-22 | Los Angeles | 37 | 16055 | 42674 | |
390540 | 390540 | Waterford | Waterford | 2022-02-22 | Stanislaus | 99 | 1604 | 8823 | |
389895 | 389895 | Unincorporated - Walnut Park | Walnut Park | 2022-02-22 | Los Angeles | 37 | 6011 | 16143 | |
389433 | 389433 | Walnut Creek | Walnut Creek | 2022-02-22 | Contra Costa | 13 | 9178 | 70860 | |
389654 | 389654 | City of Walnut | Walnut | 2022-02-22 | Los Angeles | 37 | 4698 | 30532 | |
390181 | 390181 | Vista Santa Rosa | Vista Santa Rosa | 2022-02-22 | Riverside | 65 | 560 | 2967 | |
390569 | 390569 | 93292 | Visalia: 93292 | 2022-02-22 | Tulare | 107 | 7268 | 41031 | |
390568 | 390568 | 93291 | Visalia: 93291 | 2022-02-22 | Tulare | 107 | 11406 | 57968 | |
390566 | 390566 | 93277 | Visalia: 93277 | 2022-02-22 | Tulare | 107 | 9014 | 53015 | |
390086 | 390086 | Villa Park | Villa Park | 2022-02-22 | Orange | 59 | 688 | 5933 | |
389894 | 389894 | Unincorporated - View Park/Windsor Hills | View Park/Windsor Hills | 2022-02-22 | Los Angeles | 37 | 2374 | 11635 | |
389782 | 389782 | Los Angeles - View Heights | View Heights | 2022-02-22 | Los Angeles | 37 | 729 | 3694 | |
390252 | 390252 | Victorville | Victorville | 2022-02-22 | San Bernardino | 71 | 40012 | 128353 | |
389781 | 389781 | Los Angeles - Victoria Park | Victoria Park | 2022-02-22 | Los Angeles | 37 | 2238 | 8399 | |
389780 | 389780 | Los Angeles - Vernon Central | Vernon Central | 2022-02-22 | Los Angeles | 37 | 21433 | 51998 | |
389653 | 389653 | City of Vernon | Vernon | 2022-02-22 | Los Angeles | 37 | 304 | 209 | |
389779 | 389779 | Los Angeles - Vermont Vista | Vermont Vista | 2022-02-22 | Los Angeles | 37 | 15298 | 41186 | |
389778 | 389778 | Los Angeles - Vermont Square | Vermont Square | 2022-02-22 | Los Angeles | 37 | 3051 | 7657 | |
389777 | 389777 | Los Angeles - Vermont Knolls | Vermont Knolls | 2022-02-22 | Los Angeles | 37 | 6070 | 17200 | |
389776 | 389776 | Los Angeles - Venice | Venice | 2022-02-22 | Los Angeles | 37 | 6289 | 33885 | |
389775 | 389775 | Los Angeles - Van Nuys | Van Nuys | 2022-02-22 | Los Angeles | 37 | 29995 | 93194 | |
389774 | 389774 | Los Angeles - Valley Village | Valley Village | 2022-02-22 | Los Angeles | 37 | 5787 | 24720 | |
389773 | 389773 | Los Angeles - Valley Glen | Valley Glen | 2022-02-22 | Los Angeles | 37 | 8597 | 30016 | |
390498 | 390498 | Vallejo | Vallejo | 2022-02-22 | Solano | 95 | 24515 | 119544 | |
390180 | 390180 | Valle Vista | Valle Vista | 2022-02-22 | Riverside | 65 | 3278 | 16879 | |
389893 | 389893 | Unincorporated - Valinda | Valinda | 2022-02-22 | Los Angeles | 37 | 7344 | 23371 | |
389892 | 389892 | Unincorporated - Valencia | Valencia | 2022-02-22 | Los Angeles | 37 | 661 | 3072 | |
389891 | 389891 | Unincorporated - Val Verde | Val Verde | 2022-02-22 | Los Angeles | 37 | 822 | 3309 | |
390497 | 390497 | Vacaville | Vacaville | 2022-02-22 | Solano | 95 | 19096 | 98807 | |
390251 | 390251 | Upland | Upland | 2022-02-22 | San Bernardino | 71 | 17688 | 78249 | |
389772 | 389772 | Los Angeles - University Park | University Park | 2022-02-22 | Los Angeles | 37 | 8695 | 27456 | |
389771 | 389771 | Los Angeles - University Hills | University Hills | 2022-02-22 | Los Angeles | 37 | 693 | 3429 | |
389906 | 389906 | Unincorporated - Whittier | Unincorporated - Whittier | 2022-02-22 | Los Angeles | 37 | 720 | 3784 | |
389899 | 389899 | Unincorporated - West LA | Unincorporated - West LA | 2022-02-22 | Los Angeles | 37 | 527 | 952 | |
389883 | 389883 | Unincorporated - South El Monte | Unincorporated - South El Monte | 2022-02-22 | Los Angeles | 37 | 621 | 1795 | |
389866 | 389866 | Unincorporated - Pomona | Unincorporated - Pomona | 2022-02-22 | Los Angeles | 37 | 134 | 1938 | |
389861 | 389861 | Unincorporated - Palmdale | Unincorporated - Palmdale | 2022-02-22 | Los Angeles | 37 | 213 | 842 | |
389855 | 389855 | Unincorporated - Monrovia | Unincorporated - Monrovia | 2022-02-22 | Los Angeles | 37 | 839 | 3881 | |
389847 | 389847 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2022-02-22 | Los Angeles | 37 | 1 | 1 | |
389842 | 389842 | Unincorporated - La Verne | Unincorporated - La Verne | 2022-02-22 | Los Angeles | 37 | 482 | 2040 | |
389840 | 389840 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2022-02-22 | Los Angeles | 37 | 17 | 676 | |
389836 | 389836 | Unincorporated - Hawthorne | Unincorporated - Hawthorne | 2022-02-22 | Los Angeles | 37 | 591 | 2514 | |
389835 | 389835 | Unincorporated - Harbor Gateway | Unincorporated - Harbor Gateway | 2022-02-22 | Los Angeles | 37 | 4 | 1 | |
389833 | 389833 | Unincorporated - Glendora | Unincorporated - Glendora | 2022-02-22 | Los Angeles | 37 | 165 | 660 | |
389831 | 389831 | Unincorporated - Florence-Firestone | Unincorporated - Florence-Firestone | 2022-02-22 | Los Angeles | 37 | 25920 | 64705 | |
389821 | 389821 | Unincorporated - Duarte | Unincorporated - Duarte | 2022-02-22 | Los Angeles | 37 | 1496 | 4428 | |
389818 | 389818 | Unincorporated - Del Rey | Unincorporated - Del Rey | 2022-02-22 | Los Angeles | 37 | 86 | 318 | |
389815 | 389815 | Unincorporated - Covina | Unincorporated - Covina | 2022-02-22 | Los Angeles | 37 | 4723 | 16819 |
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 );