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-07 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
913666 | 913666 | Unincorporated - Sand Canyon | Sand Canyon | 2021-01-07 | Los Angeles | 37 | 10 | 308 | |
913311 | 913311 | 93220 | 93220: Edison | 2021-01-07 | Kern | 29 | 17 | 313 | |
913607 | 913607 | Unincorporated - Del Rey | Unincorporated - Del Rey | 2021-01-07 | Los Angeles | 37 | 17 | 318 | |
913362 | 913362 | 91107 | 91107: Pasadena | 2021-01-07 | Los Angeles | 37 | 874 | 321 | |
913611 | 913611 | Unincorporated - East Covina | East Covina | 2021-01-07 | Los Angeles | 37 | 26 | 329 | |
913670 | 913670 | Unincorporated - Saugus/Canyon Country | Saugus/Canyon Country | 2021-01-07 | Los Angeles | 37 | 28 | 356 | |
914029 | 914029 | Pioneertown | Pioneertown | 2021-01-07 | San Bernardino | 71 | 6 | 365 | |
913175 | 913175 | 95225 | 95225 | 2021-01-07 | Calaveras | 9 | 14 | 378 | |
913246 | 913246 | Raisin | Raisin | 2021-01-07 | Fresno | 19 | 0 | 380 | |
914226 | 914226 | Princeton | Princeton | 2021-01-07 | San Mateo | 81 | 9 | 9 or fewer | 382 |
913983 | 913983 | Angelus Oaks | Angelus Oaks | 2021-01-07 | San Bernardino | 71 | 30 | 385 | |
913313 | 913313 | 93224 | 93224: Fellows | 2021-01-07 | Kern | 29 | 14 | 402 | |
914286 | 914286 | 95412 | 95412: Annapolis | 2021-01-07 | Sonoma | 97 | 0 | 402 | |
914004 | 914004 | Green Valley Lake | Green Valley Lake | 2021-01-07 | San Bernardino | 71 | 7 | 412 | |
913317 | 913317 | 93531 | 93531: Keene | 2021-01-07 | Kern | 29 | 19 | 422 | |
913398 | 913398 | City of Industry | Industry | 2021-01-07 | Los Angeles | 37 | 114 | 437 | |
913671 | 913671 | Unincorporated - South Antelope Valley | South Antelope Valley | 2021-01-07 | Los Angeles | 37 | 16 | 455 | |
913654 | 913654 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-01-07 | Los Angeles | 37 | 0 | 460 | |
914000 | 914000 | Fawnskin | Fawnskin | 2021-01-07 | San Bernardino | 71 | 9 | 528 | |
914019 | 914019 | Mt Baldy | Mt Baldy | 2021-01-07 | San Bernardino | 71 | 1 | 537 | |
913998 | 913998 | Daggett | Daggett | 2021-01-07 | San Bernardino | 71 | 12 | 549 | |
913459 | 913459 | Los Angeles - Brookside | Brookside | 2021-01-07 | Los Angeles | 37 | 20 | 581 | |
913978 | 913978 | Isleton | Isleton | 2021-01-07 | Sacramento | 67 | 58 | 583 | |
914200 | 914200 | San Simeon | San Simeon | 2021-01-07 | San Luis Obispo | 79 | 9 | 583 | |
913601 | 913601 | Unincorporated - Cerritos | Unincorporated - Cerritos | 2021-01-07 | Los Angeles | 37 | 50 | 587 | |
914273 | 914273 | 94922 | 94922: Bodega | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 603 |
913653 | 913653 | Unincorporated - Pellissier Village | Pellissier Village | 2021-01-07 | Los Angeles | 37 | 114 | 619 | |
913651 | 913651 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2021-01-07 | Los Angeles | 37 | 18 | 621 | |
914023 | 914023 | Oak Glen | Oak Glen | 2021-01-07 | San Bernardino | 71 | 8 | 625 | |
913551 | 913551 | Los Angeles - Sycamore Square | Sycamore Square | 2021-01-07 | Los Angeles | 37 | 23 | 647 | |
913622 | 913622 | Unincorporated - Glendora | Unincorporated - Glendora | 2021-01-07 | Los Angeles | 37 | 52 | 660 | |
913633 | 913633 | Unincorporated - Lake Hughes | Lake Hughes | 2021-01-07 | Los Angeles | 37 | 26 | 668 | |
913629 | 913629 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2021-01-07 | Los Angeles | 37 | 11 | 676 | |
914318 | 914318 | North County | North County | 2021-01-07 | Trinity | 105 | 4 | 699 | |
913893 | 913893 | 95714 | 95714: Dutch Flat | 2021-01-07 | Placer | 61 | 5 | 5 or fewer | 701 |
913603 | 913603 | Unincorporated - Claremont | Unincorporated - Claremont | 2021-01-07 | Los Angeles | 37 | 36 | 702 | |
913281 | 913281 | 93255 | 93255: Onyx | 2021-01-07 | Kern | 29 | 7 | 707 | |
914293 | 914293 | 95444 | 95444: Graton | 2021-01-07 | Sonoma | 97 | 20 | 715 | |
913985 | 913985 | Arrowbear | Arrowbear | 2021-01-07 | San Bernardino | 71 | 2 | 723 | |
913993 | 913993 | Cedar Glen | Cedar Glen | 2021-01-07 | San Bernardino | 71 | 7 | 739 | |
914033 | 914033 | Rimforest | Rimforest | 2021-01-07 | San Bernardino | 71 | 26 | 756 | |
914290 | 914290 | 95439 | 95439: Fulton | 2021-01-07 | Sonoma | 97 | 35 | 774 | |
913807 | 913807 | Chiles Valley Area | Chiles Valley Area | 2021-01-07 | Napa | 55 | 6 | 776 | |
913675 | 913675 | Unincorporated - Southeast Antelope Valley | Southeast Antelope Valley | 2021-01-07 | Los Angeles | 37 | 59 | 781 | |
913131 | 913131 | 94586 | 94586: Sunol | 2021-01-07 | Alameda | 1 | 25 | 797 | |
913986 | 913986 | Baker | Baker | 2021-01-07 | San Bernardino | 71 | 32 | 799 | |
913195 | 913195 | Diablo | Diablo | 2021-01-07 | Contra Costa | 13 | 26 | 818 | |
913829 | 913829 | 95960 | 95960: North San Juan | 2021-01-07 | Nevada | 57 | 11 | 825 | |
914015 | 914015 | Lytle Creek | Lytle Creek | 2021-01-07 | San Bernardino | 71 | 47 | 837 | |
913693 | 913693 | Unincorporated - Westhills | Westhills | 2021-01-07 | Los Angeles | 37 | 31 | 839 | |
913650 | 913650 | Unincorporated - Palmdale | Unincorporated - Palmdale | 2021-01-07 | Los Angeles | 37 | 71 | 842 | |
913890 | 913890 | 95701 | 95701: Alta | 2021-01-07 | Placer | 61 | 16 | 842 | |
914274 | 914274 | 94923 | 94923: Bodega Bay | 2021-01-07 | Sonoma | 97 | 27 | 846 | |
913663 | 913663 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-01-07 | Los Angeles | 37 | 9 | 858 | |
913642 | 913642 | Unincorporated - Llano | Llano | 2021-01-07 | Los Angeles | 37 | 24 | 877 | |
913330 | 913330 | Stratford | Stratford | 2021-01-07 | Kings | 31 | 93 | 878 | |
913165 | 913165 | Plymouth & surrounding unincorporated areas | Plymouth & surrounding unincorporated areas | 2021-01-07 | Amador | 5 | 98 | 894 | |
913992 | 913992 | Blue Jay | Blue Jay | 2021-01-07 | San Bernardino | 71 | 87 | 900 | |
914002 | 914002 | Forest Falls | Forest Falls | 2021-01-07 | San Bernardino | 71 | 33 | 920 | |
913658 | 913658 | Unincorporated - Roosevelt | Roosevelt | 2021-01-07 | Los Angeles | 37 | 55 | 931 | |
913902 | 913902 | 96141 | 96141: Homewood | 2021-01-07 | Placer | 61 | 6 | 933 | |
913224 | 913224 | Biola | Biola | 2021-01-07 | Fresno | 19 | 88 | 949 | |
913817 | 913817 | West Napa Area | West Napa Area | 2021-01-07 | Napa | 55 | 18 | 951 | |
913688 | 913688 | Unincorporated - West LA | Unincorporated - West LA | 2021-01-07 | Los Angeles | 37 | 140 | 952 | |
914216 | 914216 | La Honda | La Honda | 2021-01-07 | San Mateo | 81 | 9 | 9 or fewer | 960 |
914297 | 914297 | 95452 | 95452: Kenwood | 2021-01-07 | Sonoma | 97 | 15 | 970 | |
913812 | 913812 | North Calistoga | North Calistoga | 2021-01-07 | Napa | 55 | 11 | 980 | |
913303 | 913303 | 93518 | 93518: Caliente | 2021-01-07 | Kern | 29 | 15 | 995 | |
913182 | 913182 | 95254 | 95254 | 2021-01-07 | Calaveras | 9 | 18 | 1035 | |
913374 | 913374 | City of Bradbury | Bradbury | 2021-01-07 | Los Angeles | 37 | 32 | 1069 | |
913597 | 913597 | Unincorporated - Bouquet Canyon | Bouquet Canyon | 2021-01-07 | Los Angeles | 37 | 30 | 1073 | |
913626 | 913626 | Unincorporated - Hi Vista | Hi Vista | 2021-01-07 | Los Angeles | 37 | 28 | 1098 | |
913225 | 913225 | Cantua Creek | Cantua Creek | 2021-01-07 | Fresno | 19 | 55 | 1125 | |
913254 | 913254 | Tranquillity | Tranquillity | 2021-01-07 | Fresno | 19 | 50 | 1132 | |
914026 | 914026 | Oro Grande | Oro Grande | 2021-01-07 | San Bernardino | 71 | 99 | 1137 | |
914202 | 914202 | Shandon | Shandon | 2021-01-07 | San Luis Obispo | 79 | 105 | 1141 | |
913180 | 913180 | 95246, 95250 | 95246, 95250 | 2021-01-07 | Calaveras | 9 | 24 | 1159 | |
914303 | 914303 | 95497 | 95497: The Sea Ranch | 2021-01-07 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
914037 | 914037 | Trona | Trona | 2021-01-07 | San Bernardino | 71 | 27 | 1191 | |
913660 | 913660 | Unincorporated - Rosewood/East Gardena | Rosewood/East Gardena | 2021-01-07 | Los Angeles | 37 | 110 | 1193 | |
913800 | 913800 | 95039 | 95039: Moss Landing | 2021-01-07 | Monterey | 53 | 72 | 1195 | |
913646 | 913646 | Unincorporated - North Lancaster | North Lancaster | 2021-01-07 | Los Angeles | 37 | 93 | 1198 | |
913889 | 913889 | 95681 | 95681: Sheridan | 2021-01-07 | Placer | 61 | 53 | 1241 | |
913590 | 913590 | Unincorporated - Angeles National Forest | Unincorporated - Angeles National Forest | 2021-01-07 | Los Angeles | 37 | 19 | 1245 | |
914201 | 914201 | Santa Margarita | Santa Margarita | 2021-01-07 | San Luis Obispo | 79 | 93 | 1252 | |
914009 | 914009 | Hinkley | Hinkley | 2021-01-07 | San Bernardino | 71 | 44 | 1259 | |
913990 | 913990 | Big River | Big River | 2021-01-07 | San Bernardino | 71 | 5 | 1264 | |
914298 | 914298 | 95462 | 95462: Monte Rio | 2021-01-07 | Sonoma | 97 | 17 | 1265 | |
914185 | 914185 | Avila | Avila | 2021-01-07 | San Luis Obispo | 79 | 21 | 1273 | |
913814 | 913814 | Pope Valley Area | Pope Valley Area | 2021-01-07 | Napa | 55 | 18 | 1275 | |
913659 | 913659 | Unincorporated - Rosewood | Rosewood | 2021-01-07 | Los Angeles | 37 | 105 | 1286 | |
913678 | 913678 | Unincorporated - Sunrise Village | Sunrise Village | 2021-01-07 | Los Angeles | 37 | 153 | 1296 | |
913640 | 913640 | Unincorporated - Littlerock/Juniper Hills | Littlerock/Juniper Hills | 2021-01-07 | Los Angeles | 37 | 76 | 1297 | |
913692 | 913692 | Unincorporated - Westfield/Academy Hills | Westfield/Academy Hills | 2021-01-07 | Los Angeles | 37 | 22 | 1300 | |
914209 | 914209 | Colma | Colma | 2021-01-07 | San Mateo | 81 | 137 | 1302 | |
913557 | 913557 | Los Angeles - Toluca Terrace | Toluca Terrace | 2021-01-07 | Los Angeles | 37 | 86 | 1306 | |
913190 | 913190 | Byron | Byron | 2021-01-07 | Contra Costa | 13 | 70 | 1325 | |
913906 | 913906 | 96146 | 96146: Olympic Valley | 2021-01-07 | Placer | 61 | 42 | 1326 | |
913264 | 913264 | 92257 | 92257: Niland | 2021-01-07 | Imperial | 25 | 83 | 1332 | |
913158 | 913158 | 94720 | 94720: Berkeley | 2021-01-07 | Alameda | 1 | 38 | 1336 |
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 );