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 population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
909838 | 909838 | Unincorporated - Sand Canyon | Sand Canyon | 2021-01-10 | Los Angeles | 37 | 10 | 308 | |
909483 | 909483 | 93220 | 93220: Edison | 2021-01-10 | Kern | 29 | 17 | 313 | |
909779 | 909779 | Unincorporated - Del Rey | Unincorporated - Del Rey | 2021-01-10 | Los Angeles | 37 | 18 | 318 | |
909534 | 909534 | 91107 | 91107: Pasadena | 2021-01-10 | Los Angeles | 37 | 935 | 321 | |
909783 | 909783 | Unincorporated - East Covina | East Covina | 2021-01-10 | Los Angeles | 37 | 29 | 329 | |
909842 | 909842 | Unincorporated - Saugus/Canyon Country | Saugus/Canyon Country | 2021-01-10 | Los Angeles | 37 | 28 | 356 | |
910201 | 910201 | Pioneertown | Pioneertown | 2021-01-10 | San Bernardino | 71 | 8 | 365 | |
909347 | 909347 | 95225 | 95225 | 2021-01-10 | Calaveras | 9 | 24 | 378 | |
909418 | 909418 | Raisin | Raisin | 2021-01-10 | Fresno | 19 | 0 | 380 | |
910398 | 910398 | Princeton | Princeton | 2021-01-10 | San Mateo | 81 | 9 | 9 or fewer | 382 |
910155 | 910155 | Angelus Oaks | Angelus Oaks | 2021-01-10 | San Bernardino | 71 | 31 | 385 | |
909485 | 909485 | 93224 | 93224: Fellows | 2021-01-10 | Kern | 29 | 18 | 402 | |
910458 | 910458 | 95412 | 95412: Annapolis | 2021-01-10 | Sonoma | 97 | 0 | 402 | |
910176 | 910176 | Green Valley Lake | Green Valley Lake | 2021-01-10 | San Bernardino | 71 | 8 | 412 | |
909489 | 909489 | 93531 | 93531: Keene | 2021-01-10 | Kern | 29 | 19 | 422 | |
909570 | 909570 | City of Industry | Industry | 2021-01-10 | Los Angeles | 37 | 119 | 437 | |
909843 | 909843 | Unincorporated - South Antelope Valley | South Antelope Valley | 2021-01-10 | Los Angeles | 37 | 19 | 455 | |
909826 | 909826 | Unincorporated - Placerita Canyon | Placerita Canyon | 2021-01-10 | Los Angeles | 37 | 0 | 460 | |
910172 | 910172 | Fawnskin | Fawnskin | 2021-01-10 | San Bernardino | 71 | 10 | 528 | |
910191 | 910191 | Mt Baldy | Mt Baldy | 2021-01-10 | San Bernardino | 71 | 1 | 537 | |
910170 | 910170 | Daggett | Daggett | 2021-01-10 | San Bernardino | 71 | 13 | 549 | |
909631 | 909631 | Los Angeles - Brookside | Brookside | 2021-01-10 | Los Angeles | 37 | 21 | 581 | |
910150 | 910150 | Isleton | Isleton | 2021-01-10 | Sacramento | 67 | 58 | 583 | |
910372 | 910372 | San Simeon | San Simeon | 2021-01-10 | San Luis Obispo | 79 | 11 | 583 | |
909773 | 909773 | Unincorporated - Cerritos | Unincorporated - Cerritos | 2021-01-10 | Los Angeles | 37 | 56 | 587 | |
910445 | 910445 | 94922 | 94922: Bodega | 2021-01-10 | Sonoma | 97 | 10 | 10 or fewer | 603 |
909825 | 909825 | Unincorporated - Pellissier Village | Pellissier Village | 2021-01-10 | Los Angeles | 37 | 126 | 619 | |
909823 | 909823 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2021-01-10 | Los Angeles | 37 | 18 | 621 | |
910195 | 910195 | Oak Glen | Oak Glen | 2021-01-10 | San Bernardino | 71 | 9 | 625 | |
909723 | 909723 | Los Angeles - Sycamore Square | Sycamore Square | 2021-01-10 | Los Angeles | 37 | 23 | 647 | |
909794 | 909794 | Unincorporated - Glendora | Unincorporated - Glendora | 2021-01-10 | Los Angeles | 37 | 53 | 660 | |
909805 | 909805 | Unincorporated - Lake Hughes | Lake Hughes | 2021-01-10 | Los Angeles | 37 | 30 | 668 | |
909801 | 909801 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2021-01-10 | Los Angeles | 37 | 12 | 676 | |
910490 | 910490 | North County | North County | 2021-01-10 | Trinity | 105 | 5 | 699 | |
910065 | 910065 | 95714 | 95714: Dutch Flat | 2021-01-10 | Placer | 61 | 5 | 5 or fewer | 701 |
909775 | 909775 | Unincorporated - Claremont | Unincorporated - Claremont | 2021-01-10 | Los Angeles | 37 | 36 | 702 | |
909453 | 909453 | 93255 | 93255: Onyx | 2021-01-10 | Kern | 29 | 7 | 707 | |
910465 | 910465 | 95444 | 95444: Graton | 2021-01-10 | Sonoma | 97 | 20 | 715 | |
910157 | 910157 | Arrowbear | Arrowbear | 2021-01-10 | San Bernardino | 71 | 2 | 723 | |
910165 | 910165 | Cedar Glen | Cedar Glen | 2021-01-10 | San Bernardino | 71 | 7 | 739 | |
910205 | 910205 | Rimforest | Rimforest | 2021-01-10 | San Bernardino | 71 | 27 | 756 | |
910462 | 910462 | 95439 | 95439: Fulton | 2021-01-10 | Sonoma | 97 | 35 | 774 | |
909979 | 909979 | Chiles Valley Area | Chiles Valley Area | 2021-01-10 | Napa | 55 | 6 | 776 | |
909847 | 909847 | Unincorporated - Southeast Antelope Valley | Southeast Antelope Valley | 2021-01-10 | Los Angeles | 37 | 60 | 781 | |
909303 | 909303 | 94586 | 94586: Sunol | 2021-01-10 | Alameda | 1 | 28 | 797 | |
910158 | 910158 | Baker | Baker | 2021-01-10 | San Bernardino | 71 | 33 | 799 | |
909367 | 909367 | Diablo | Diablo | 2021-01-10 | Contra Costa | 13 | 29 | 818 | |
910001 | 910001 | 95960 | 95960: North San Juan | 2021-01-10 | Nevada | 57 | 11 | 825 | |
910187 | 910187 | Lytle Creek | Lytle Creek | 2021-01-10 | San Bernardino | 71 | 51 | 837 | |
909865 | 909865 | Unincorporated - Westhills | Westhills | 2021-01-10 | Los Angeles | 37 | 31 | 839 | |
909822 | 909822 | Unincorporated - Palmdale | Unincorporated - Palmdale | 2021-01-10 | Los Angeles | 37 | 78 | 842 | |
910062 | 910062 | 95701 | 95701: Alta | 2021-01-10 | Placer | 61 | 16 | 842 | |
910446 | 910446 | 94923 | 94923: Bodega Bay | 2021-01-10 | Sonoma | 97 | 27 | 846 | |
909835 | 909835 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2021-01-10 | Los Angeles | 37 | 11 | 858 | |
909814 | 909814 | Unincorporated - Llano | Llano | 2021-01-10 | Los Angeles | 37 | 26 | 877 | |
909502 | 909502 | Stratford | Stratford | 2021-01-10 | Kings | 31 | 94 | 878 | |
909337 | 909337 | Plymouth & surrounding unincorporated areas | Plymouth & surrounding unincorporated areas | 2021-01-10 | Amador | 5 | 99 | 894 | |
910164 | 910164 | Blue Jay | Blue Jay | 2021-01-10 | San Bernardino | 71 | 91 | 900 | |
910174 | 910174 | Forest Falls | Forest Falls | 2021-01-10 | San Bernardino | 71 | 33 | 920 | |
909830 | 909830 | Unincorporated - Roosevelt | Roosevelt | 2021-01-10 | Los Angeles | 37 | 61 | 931 | |
910074 | 910074 | 96141 | 96141: Homewood | 2021-01-10 | Placer | 61 | 6 | 933 | |
909396 | 909396 | Biola | Biola | 2021-01-10 | Fresno | 19 | 88 | 949 | |
909989 | 909989 | West Napa Area | West Napa Area | 2021-01-10 | Napa | 55 | 18 | 951 | |
909860 | 909860 | Unincorporated - West LA | Unincorporated - West LA | 2021-01-10 | Los Angeles | 37 | 161 | 952 | |
910388 | 910388 | La Honda | La Honda | 2021-01-10 | San Mateo | 81 | 9 | 9 or fewer | 960 |
910469 | 910469 | 95452 | 95452: Kenwood | 2021-01-10 | Sonoma | 97 | 15 | 970 | |
909984 | 909984 | North Calistoga | North Calistoga | 2021-01-10 | Napa | 55 | 11 | 980 | |
909475 | 909475 | 93518 | 93518: Caliente | 2021-01-10 | Kern | 29 | 16 | 995 | |
909354 | 909354 | 95254 | 95254 | 2021-01-10 | Calaveras | 9 | 18 | 1035 | |
909546 | 909546 | City of Bradbury | Bradbury | 2021-01-10 | Los Angeles | 37 | 32 | 1069 | |
909769 | 909769 | Unincorporated - Bouquet Canyon | Bouquet Canyon | 2021-01-10 | Los Angeles | 37 | 31 | 1073 | |
909798 | 909798 | Unincorporated - Hi Vista | Hi Vista | 2021-01-10 | Los Angeles | 37 | 28 | 1098 | |
909397 | 909397 | Cantua Creek | Cantua Creek | 2021-01-10 | Fresno | 19 | 55 | 1125 | |
909426 | 909426 | Tranquillity | Tranquillity | 2021-01-10 | Fresno | 19 | 50 | 1132 | |
910198 | 910198 | Oro Grande | Oro Grande | 2021-01-10 | San Bernardino | 71 | 101 | 1137 | |
910374 | 910374 | Shandon | Shandon | 2021-01-10 | San Luis Obispo | 79 | 109 | 1141 | |
909352 | 909352 | 95246, 95250 | 95246, 95250 | 2021-01-10 | Calaveras | 9 | 26 | 1159 | |
910475 | 910475 | 95497 | 95497: The Sea Ranch | 2021-01-10 | Sonoma | 97 | 10 | 10 or fewer | 1161 |
910209 | 910209 | Trona | Trona | 2021-01-10 | San Bernardino | 71 | 27 | 1191 | |
909832 | 909832 | Unincorporated - Rosewood/East Gardena | Rosewood/East Gardena | 2021-01-10 | Los Angeles | 37 | 118 | 1193 | |
909972 | 909972 | 95039 | 95039: Moss Landing | 2021-01-10 | Monterey | 53 | 80 | 1195 | |
909818 | 909818 | Unincorporated - North Lancaster | North Lancaster | 2021-01-10 | Los Angeles | 37 | 100 | 1198 | |
910061 | 910061 | 95681 | 95681: Sheridan | 2021-01-10 | Placer | 61 | 54 | 1241 | |
909762 | 909762 | Unincorporated - Angeles National Forest | Unincorporated - Angeles National Forest | 2021-01-10 | Los Angeles | 37 | 20 | 1245 | |
910373 | 910373 | Santa Margarita | Santa Margarita | 2021-01-10 | San Luis Obispo | 79 | 96 | 1252 | |
910181 | 910181 | Hinkley | Hinkley | 2021-01-10 | San Bernardino | 71 | 45 | 1259 | |
910162 | 910162 | Big River | Big River | 2021-01-10 | San Bernardino | 71 | 8 | 1264 | |
910470 | 910470 | 95462 | 95462: Monte Rio | 2021-01-10 | Sonoma | 97 | 17 | 1265 | |
910357 | 910357 | Avila | Avila | 2021-01-10 | San Luis Obispo | 79 | 22 | 1273 | |
909986 | 909986 | Pope Valley Area | Pope Valley Area | 2021-01-10 | Napa | 55 | 18 | 1275 | |
909831 | 909831 | Unincorporated - Rosewood | Rosewood | 2021-01-10 | Los Angeles | 37 | 114 | 1286 | |
909850 | 909850 | Unincorporated - Sunrise Village | Sunrise Village | 2021-01-10 | Los Angeles | 37 | 157 | 1296 | |
909812 | 909812 | Unincorporated - Littlerock/Juniper Hills | Littlerock/Juniper Hills | 2021-01-10 | Los Angeles | 37 | 80 | 1297 | |
909864 | 909864 | Unincorporated - Westfield/Academy Hills | Westfield/Academy Hills | 2021-01-10 | Los Angeles | 37 | 22 | 1300 | |
910381 | 910381 | Colma | Colma | 2021-01-10 | San Mateo | 81 | 153 | 1302 | |
909729 | 909729 | Los Angeles - Toluca Terrace | Toluca Terrace | 2021-01-10 | Los Angeles | 37 | 93 | 1306 | |
909362 | 909362 | Byron | Byron | 2021-01-10 | Contra Costa | 13 | 76 | 1325 | |
910078 | 910078 | 96146 | 96146: Olympic Valley | 2021-01-10 | Placer | 61 | 42 | 1326 | |
909436 | 909436 | 92257 | 92257: Niland | 2021-01-10 | Imperial | 25 | 84 | 1332 | |
909330 | 909330 | 94720 | 94720: Berkeley | 2021-01-10 | Alameda | 1 | 41 | 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 );