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-10 sorted by id descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id ▲ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
910217 | 910217 | Yucca Valley | Yucca Valley | 2021-01-10 | San Bernardino | 71 | 899 | 22146 | |
910216 | 910216 | Yucaipa | Yucaipa | 2021-01-10 | San Bernardino | 71 | 4236 | 54490 | |
910488 | 910488 | Yuba City | Yuba City | 2021-01-10 | Sutter | 101 | 5817 | 66388 | |
909991 | 909991 | Yountville | Yountville | 2021-01-10 | Napa | 55 | 93 | 3032 | |
910049 | 910049 | Yorba Linda | Yorba Linda | 2021-01-10 | Orange | 59 | 2998 | 68706 | |
910215 | 910215 | Yermo | Yermo | 2021-01-10 | San Bernardino | 71 | 68 | 1672 | |
910214 | 910214 | Wrightwood | Wrightwood | 2021-01-10 | San Bernardino | 71 | 258 | 5177 | |
910405 | 910405 | Woodside | Woodside | 2021-01-10 | San Mateo | 81 | 96 | 5542 | |
910550 | 910550 | Woodland | Woodland | 2021-01-10 | Yolo | 113 | 3860 | 59044 | |
910145 | 910145 | Woodcrest | Woodcrest | 2021-01-10 | Riverside | 65 | 1184 | 17310 | |
909943 | 909943 | Winton | Winton | 2021-01-10 | Merced | 47 | 1215 | 10613 | |
910549 | 910549 | Winters | Winters | 2021-01-10 | Yolo | 113 | 424 | 7132 | |
910144 | 910144 | Winchester | Winchester | 2021-01-10 | Riverside | 65 | 121 | 2931 | |
910143 | 910143 | Wildomar | Wildomar | 2021-01-10 | Riverside | 65 | 2238 | 36162 | |
910555 | 910555 | Wheatland | Wheatland | 2021-01-10 | Yuba | 115 | 262 | 3747 | |
910048 | 910048 | Westminster | Westminster | 2021-01-10 | Orange | 59 | 5183 | 92610 | |
910548 | 910548 | West Sacramento | West Sacramento | 2021-01-10 | Yolo | 113 | 2704 | 52826 | |
909990 | 909990 | West Napa and Yountville Area | West Napa and Yountville Area | 2021-01-10 | Napa | 55 | 30 | 1699 | |
909989 | 909989 | West Napa Area | West Napa Area | 2021-01-10 | Napa | 55 | 18 | 951 | |
910404 | 910404 | West Menlo Park | West Menlo Park | 2021-01-10 | San Mateo | 81 | 41 | 4160 | |
910492 | 910492 | West County | West County | 2021-01-10 | Trinity | 105 | 24 | 2254 | |
910435 | 910435 | West | West | 2021-01-10 | Siskiyou | 93 | 146 | 7514 | |
910485 | 910485 | Waterford | Waterford | 2021-01-10 | Stanislaus | 99 | 451 | 8823 | |
909386 | 909386 | Walnut Creek | Walnut Creek | 2021-01-10 | Contra Costa | 13 | 1932 | 70860 | |
909339 | 909339 | Volcano | Volcano | 2021-01-10 | Amador | 5 | 22 | 44 | |
910142 | 910142 | Vista Santa Rosa | Vista Santa Rosa | 2021-01-10 | Riverside | 65 | 229 | 2967 | |
910047 | 910047 | Villa Park | Villa Park | 2021-01-10 | Orange | 59 | 225 | 5933 | |
910213 | 910213 | Victorville | Victorville | 2021-01-10 | San Bernardino | 71 | 16200 | 128353 | |
910443 | 910443 | Vallejo | Vallejo | 2021-01-10 | Solano | 95 | 6443 | 119544 | |
910141 | 910141 | Valle Vista | Valle Vista | 2021-01-10 | Riverside | 65 | 974 | 16879 | |
910442 | 910442 | Vacaville | Vacaville | 2021-01-10 | Solano | 95 | 5760 | 98807 | |
910212 | 910212 | Upland | Upland | 2021-01-10 | San Bernardino | 71 | 6216 | 78249 | |
910484 | 910484 | Unincorporated districts | Other | 2021-01-10 | Stanislaus | 99 | 6561 | ||
910153 | 910153 | Unincorporated Areas | Other | 2021-01-10 | Sacramento | 67 | 12198 | ||
909870 | 909870 | Unincorporated - Wiseburn | Wiseburn | 2021-01-10 | Los Angeles | 37 | 364 | 6027 | |
909869 | 909869 | Unincorporated - Willowbrook | Willowbrook | 2021-01-10 | Los Angeles | 37 | 4614 | 34913 | |
909868 | 909868 | Unincorporated - Whittier Narrows | Whittier Narrows | 2021-01-10 | Los Angeles | 37 | 8 | 12 | |
909867 | 909867 | Unincorporated - Whittier | Unincorporated - Whittier | 2021-01-10 | Los Angeles | 37 | 235 | 3784 | |
909866 | 909866 | Unincorporated - White Fence Farms | White Fence Farms | 2021-01-10 | Los Angeles | 37 | 188 | 3683 | |
909865 | 909865 | Unincorporated - Westhills | Westhills | 2021-01-10 | Los Angeles | 37 | 31 | 839 | |
909864 | 909864 | Unincorporated - Westfield/Academy Hills | Westfield/Academy Hills | 2021-01-10 | Los Angeles | 37 | 22 | 1300 | |
909863 | 909863 | Unincorporated - West Whittier/Los Nietos | West Whittier/Los Nietos | 2021-01-10 | Los Angeles | 37 | 3345 | 26925 | |
909862 | 909862 | Unincorporated - West Rancho Dominguez | West Rancho Dominguez | 2021-01-10 | Los Angeles | 37 | 125 | 1359 | |
909861 | 909861 | Unincorporated - West Puente Valley | West Puente Valley | 2021-01-10 | Los Angeles | 37 | 1356 | 9835 | |
909860 | 909860 | Unincorporated - West LA | Unincorporated - West LA | 2021-01-10 | Los Angeles | 37 | 161 | 952 | |
909859 | 909859 | Unincorporated - West Chatsworth | West Chatsworth | 2021-01-10 | Los Angeles | 37 | 1 | 0 | |
909858 | 909858 | Unincorporated - West Carson | West Carson | 2021-01-10 | Los Angeles | 37 | 1518 | 22086 | |
909857 | 909857 | Unincorporated - West Antelope Valley | West Antelope Valley | 2021-01-10 | Los Angeles | 37 | 30 | 1511 | |
909856 | 909856 | Unincorporated - Walnut Park | Walnut Park | 2021-01-10 | Los Angeles | 37 | 2310 | 16143 | |
909855 | 909855 | Unincorporated - View Park/Windsor Hills | View Park/Windsor Hills | 2021-01-10 | Los Angeles | 37 | 511 | 11635 | |
909854 | 909854 | Unincorporated - Valinda | Valinda | 2021-01-10 | Los Angeles | 37 | 2822 | 23371 | |
909853 | 909853 | Unincorporated - Valencia | Valencia | 2021-01-10 | Los Angeles | 37 | 121 | 3072 | |
909852 | 909852 | Unincorporated - Val Verde | Val Verde | 2021-01-10 | Los Angeles | 37 | 220 | 3309 | |
909851 | 909851 | Unincorporated - Twin Lakes/Oat Mountain | Twin Lakes/Oat Mountain | 2021-01-10 | Los Angeles | 37 | 65 | 1658 | |
909850 | 909850 | Unincorporated - Sunrise Village | Sunrise Village | 2021-01-10 | Los Angeles | 37 | 157 | 1296 | |
909849 | 909849 | Unincorporated - Sun Village | Sun Village | 2021-01-10 | Los Angeles | 37 | 646 | 6036 | |
909848 | 909848 | Unincorporated - Stevenson Ranch | Stevenson Ranch | 2021-01-10 | Los Angeles | 37 | 750 | 20966 | |
909847 | 909847 | Unincorporated - Southeast Antelope Valley | Southeast Antelope Valley | 2021-01-10 | Los Angeles | 37 | 60 | 781 | |
909846 | 909846 | Unincorporated - South Whittier | South Whittier | 2021-01-10 | Los Angeles | 37 | 6380 | 59222 | |
909845 | 909845 | Unincorporated - South San Gabriel | South San Gabriel | 2021-01-10 | Los Angeles | 37 | 669 | 8848 | |
909844 | 909844 | Unincorporated - South El Monte | Unincorporated - South El Monte | 2021-01-10 | Los Angeles | 37 | 271 | 1795 | |
909843 | 909843 | Unincorporated - South Antelope Valley | South Antelope Valley | 2021-01-10 | Los Angeles | 37 | 19 | 455 | |
909842 | 909842 | Unincorporated - Saugus/Canyon Country | Saugus/Canyon Country | 2021-01-10 | Los Angeles | 37 | 28 | 356 | |
909841 | 909841 | Unincorporated - Saugus | Saugus | 2021-01-10 | Los Angeles | 37 | 100 | 155 | |
909840 | 909840 | Unincorporated - Santa Monica Mountains | Santa Monica Mountains | 2021-01-10 | Los Angeles | 37 | 363 | 18621 | |
909839 | 909839 | Unincorporated - Santa Catalina Island | Santa Catalina Island | 2021-01-10 | Los Angeles | 37 | 99 | 267 | |
909838 | 909838 | Unincorporated - Sand Canyon | Sand Canyon | 2021-01-10 | Los Angeles | 37 | 10 | 308 | |
909837 | 909837 | Unincorporated - San Pasqual | San Pasqual | 2021-01-10 | Los Angeles | 37 | 26 | 2035 | |
909836 | 909836 | Unincorporated - San Jose Hills | San Jose Hills | 2021-01-10 | Los Angeles | 37 | 2721 | 20221 | |
909835 | 909835 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-01-10 | Los Angeles | 37 | 11 | 858 | |
909834 | 909834 | Unincorporated - Rowland Heights | Rowland Heights | 2021-01-10 | Los Angeles | 37 | 2677 | 51022 | |
909833 | 909833 | Unincorporated - Rosewood/West Rancho Dominguez | Rosewood/West Rancho Dominguez | 2021-01-10 | Los Angeles | 37 | 369 | 3361 | |
909832 | 909832 | Unincorporated - Rosewood/East Gardena | Rosewood/East Gardena | 2021-01-10 | Los Angeles | 37 | 118 | 1193 | |
909831 | 909831 | Unincorporated - Rosewood | Rosewood | 2021-01-10 | Los Angeles | 37 | 114 | 1286 | |
909830 | 909830 | Unincorporated - Roosevelt | Roosevelt | 2021-01-10 | Los Angeles | 37 | 61 | 931 | |
909829 | 909829 | Unincorporated - Rancho Dominguez | Rancho Dominguez | 2021-01-10 | Los Angeles | 37 | 285 | 2661 | |
909828 | 909828 | Unincorporated - Quartz Hill | Quartz Hill | 2021-01-10 | Los Angeles | 37 | 850 | 12906 | |
909827 | 909827 | Unincorporated - Pomona | Unincorporated - Pomona | 2021-01-10 | Los Angeles | 37 | 46 | 1938 | |
909826 | 909826 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-01-10 | Los Angeles | 37 | 0 | 460 | |
909825 | 909825 | Unincorporated - Pellissier Village | Pellissier Village | 2021-01-10 | Los Angeles | 37 | 126 | 619 | |
909824 | 909824 | Unincorporated - Pearblossom/Llano | Pearblossom/Llano | 2021-01-10 | Los Angeles | 37 | 85 | 1956 | |
909823 | 909823 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2021-01-10 | Los Angeles | 37 | 18 | 621 | |
909822 | 909822 | Unincorporated - Palmdale | Unincorporated - Palmdale | 2021-01-10 | Los Angeles | 37 | 78 | 842 | |
909821 | 909821 | Unincorporated - Padua Hills | Padua Hills | 2021-01-10 | Los Angeles | 37 | 6 | 0 | |
909820 | 909820 | Unincorporated - Northeast San Gabriel | Northeast San Gabriel | 2021-01-10 | Los Angeles | 37 | 1204 | 24036 | |
909819 | 909819 | Unincorporated - North Whittier | North Whittier | 2021-01-10 | Los Angeles | 37 | 868 | 8360 | |
909818 | 909818 | Unincorporated - North Lancaster | North Lancaster | 2021-01-10 | Los Angeles | 37 | 100 | 1198 | |
909817 | 909817 | Unincorporated - Newhall | Newhall | 2021-01-10 | Los Angeles | 37 | 57 | 220 | |
909816 | 909816 | Unincorporated - Monrovia | Unincorporated - Monrovia | 2021-01-10 | Los Angeles | 37 | 272 | 3881 | |
909815 | 909815 | Unincorporated - Marina del Rey | Marina del Rey | 2021-01-10 | Los Angeles | 37 | 243 | 9411 | |
909814 | 909814 | Unincorporated - Llano | Llano | 2021-01-10 | Los Angeles | 37 | 26 | 877 | |
909813 | 909813 | Unincorporated - Littlerock/Pearblossom | Littlerock/Pearblossom | 2021-01-10 | Los Angeles | 37 | 367 | 3569 | |
909812 | 909812 | Unincorporated - Littlerock/Juniper Hills | Littlerock/Juniper Hills | 2021-01-10 | Los Angeles | 37 | 80 | 1297 | |
909811 | 909811 | Unincorporated - Littlerock | Littlerock | 2021-01-10 | Los Angeles | 37 | 373 | 4021 | |
909810 | 909810 | Unincorporated - Leona Valley | Leona Valley | 2021-01-10 | Los Angeles | 37 | 86 | 1751 | |
909809 | 909809 | Unincorporated - Lennox | Lennox | 2021-01-10 | Los Angeles | 37 | 2578 | 22542 | |
909808 | 909808 | Unincorporated - Lakewood | Unincorporated - Lakewood | 2021-01-10 | Los Angeles | 37 | 0 | 1 | |
909807 | 909807 | Unincorporated - Lake Manor | Lake Manor | 2021-01-10 | Los Angeles | 37 | 90 | 1643 | |
909806 | 909806 | Unincorporated - Lake Los Angeles | Lake Los Angeles | 2021-01-10 | Los Angeles | 37 | 1152 | 12994 | |
909805 | 909805 | Unincorporated - Lake Hughes | Lake Hughes | 2021-01-10 | Los Angeles | 37 | 30 | 668 |
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 );