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-28 sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
381860 | 381860 | 93220 | 93220: Edison | 2022-02-28 | Kern | 29 | 31 | 313 | |
382156 | 382156 | Unincorporated - Del Rey | Unincorporated - Del Rey | 2022-02-28 | Los Angeles | 37 | 87 | 318 | |
381911 | 381911 | 91107 | 91107: Pasadena | 2022-02-28 | Los Angeles | 37 | 3901 | 321 | |
382160 | 382160 | Unincorporated - East Covina | East Covina | 2022-02-28 | Los Angeles | 37 | 76 | 329 | |
382219 | 382219 | Unincorporated - Saugus/Canyon Country | Saugus/Canyon Country | 2022-02-28 | Los Angeles | 37 | 89 | 356 | |
382578 | 382578 | Pioneertown | Pioneertown | 2022-02-28 | San Bernardino | 71 | 39 | 365 | |
381732 | 381732 | 95225 | 95225 | 2022-02-28 | Calaveras | 9 | 100 | 378 | |
381795 | 381795 | Raisin | Raisin | 2022-02-28 | Fresno | 19 | 95 | 380 | |
382775 | 382775 | Princeton | Princeton | 2022-02-28 | San Mateo | 81 | 11 | 382 | |
382532 | 382532 | Angelus Oaks | Angelus Oaks | 2022-02-28 | San Bernardino | 71 | 84 | 385 | |
381862 | 381862 | 93224 | 93224: Fellows | 2022-02-28 | Kern | 29 | 95 | 402 | |
382851 | 382851 | 95412 | 95412: Annapolis | 2022-02-28 | Sonoma | 97 | 18 | 402 | |
382553 | 382553 | Green Valley Lake | Green Valley Lake | 2022-02-28 | San Bernardino | 71 | 38 | 412 | |
381866 | 381866 | 93531 | 93531: Keene | 2022-02-28 | Kern | 29 | 70 | 422 | |
381947 | 381947 | City of Industry | Industry | 2022-02-28 | Los Angeles | 37 | 370 | 437 | |
382220 | 382220 | Unincorporated - South Antelope Valley | South Antelope Valley | 2022-02-28 | Los Angeles | 37 | 88 | 455 | |
382203 | 382203 | Unincorporated - Placerita Canyon | Placerita Canyon | 2022-02-28 | Los Angeles | 37 | 15 | 460 | |
382549 | 382549 | Fawnskin | Fawnskin | 2022-02-28 | San Bernardino | 71 | 55 | 528 | |
382568 | 382568 | Mt Baldy | Mt Baldy | 2022-02-28 | San Bernardino | 71 | 4 | 537 | |
382547 | 382547 | Daggett | Daggett | 2022-02-28 | San Bernardino | 71 | 53 | 549 | |
382008 | 382008 | Los Angeles - Brookside | Brookside | 2022-02-28 | Los Angeles | 37 | 93 | 581 | |
382527 | 382527 | Isleton | Isleton | 2022-02-28 | Sacramento | 67 | 273 | 583 | |
382749 | 382749 | San Simeon | San Simeon | 2022-02-28 | San Luis Obispo | 79 | 74 | 583 | |
382150 | 382150 | Unincorporated - Cerritos | Unincorporated - Cerritos | 2022-02-28 | Los Angeles | 37 | 133 | 587 | |
382814 | 382814 | 95017 | 95017 | 2022-02-28 | Santa Cruz | 87 | 77 | 603 | |
382838 | 382838 | 94922 | 94922: Bodega | 2022-02-28 | Sonoma | 97 | 57 | 603 | |
382202 | 382202 | Unincorporated - Pellissier Village | Pellissier Village | 2022-02-28 | Los Angeles | 37 | 296 | 619 | |
382200 | 382200 | Unincorporated - Palos Verdes Peninsula | Palos Verdes Peninsula | 2022-02-28 | Los Angeles | 37 | 66 | 621 | |
382572 | 382572 | Oak Glen | Oak Glen | 2022-02-28 | San Bernardino | 71 | 32 | 625 | |
382100 | 382100 | Los Angeles - Sycamore Square | Sycamore Square | 2022-02-28 | Los Angeles | 37 | 108 | 647 | |
382171 | 382171 | Unincorporated - Glendora | Unincorporated - Glendora | 2022-02-28 | Los Angeles | 37 | 165 | 660 | |
382182 | 382182 | Unincorporated - Lake Hughes | Lake Hughes | 2022-02-28 | Los Angeles | 37 | 145 | 668 | |
382178 | 382178 | Unincorporated - La Habra Heights | Unincorporated - La Habra Heights | 2022-02-28 | Los Angeles | 37 | 17 | 676 | |
382812 | 382812 | 95007 | 95007 | 2022-02-28 | Santa Cruz | 87 | 100 | 681 | |
382883 | 382883 | North County | North County | 2022-02-28 | Trinity | 105 | 42 | 699 | |
382442 | 382442 | 95714 | 95714: Dutch Flat | 2022-02-28 | Placer | 61 | 41 | 701 | |
382152 | 382152 | Unincorporated - Claremont | Unincorporated - Claremont | 2022-02-28 | Los Angeles | 37 | 93 | 702 | |
381830 | 381830 | 93255 | 93255: Onyx | 2022-02-28 | Kern | 29 | 45 | 707 | |
382858 | 382858 | 95444 | 95444: Graton | 2022-02-28 | Sonoma | 97 | 115 | 715 | |
382534 | 382534 | Arrowbear | Arrowbear | 2022-02-28 | San Bernardino | 71 | 9 | 723 | |
382542 | 382542 | Cedar Glen | Cedar Glen | 2022-02-28 | San Bernardino | 71 | 7 | 739 | |
382582 | 382582 | Rimforest | Rimforest | 2022-02-28 | San Bernardino | 71 | 99 | 756 | |
382855 | 382855 | 95439 | 95439: Fulton | 2022-02-28 | Sonoma | 97 | 148 | 774 | |
382356 | 382356 | Chiles Valley Area | Chiles Valley Area | 2022-02-28 | Napa | 55 | 36 | 776 | |
382224 | 382224 | Unincorporated - Southeast Antelope Valley | Southeast Antelope Valley | 2022-02-28 | Los Angeles | 37 | 185 | 781 | |
381695 | 381695 | 94586 | 94586: Sunol | 2022-02-28 | Alameda | 1 | 91 | 797 | |
382535 | 382535 | Baker | Baker | 2022-02-28 | San Bernardino | 71 | 99 | 799 | |
381752 | 381752 | Diablo | Diablo | 2022-02-28 | Contra Costa | 13 | 100 | 818 | |
382378 | 382378 | 95960 | 95960: North San Juan | 2022-02-28 | Nevada | 57 | 116 | 825 | |
382564 | 382564 | Lytle Creek | Lytle Creek | 2022-02-28 | San Bernardino | 71 | 144 | 837 | |
382242 | 382242 | Unincorporated - Westhills | Westhills | 2022-02-28 | Los Angeles | 37 | 127 | 839 | |
382199 | 382199 | Unincorporated - Palmdale | Unincorporated - Palmdale | 2022-02-28 | Los Angeles | 37 | 214 | 842 | |
382439 | 382439 | 95701 | 95701: Alta | 2022-02-28 | Placer | 61 | 106 | 842 | |
382839 | 382839 | 94923 | 94923: Bodega Bay | 2022-02-28 | Sonoma | 97 | 103 | 846 | |
382212 | 382212 | Unincorporated - San Francisquito Canyon/Bouquet Canyon | San Francisquito Canyon/Bouquet Canyon | 2022-02-28 | Los Angeles | 37 | 34 | 858 | |
382191 | 382191 | Unincorporated - Llano | Llano | 2022-02-28 | Los Angeles | 37 | 101 | 877 | |
381879 | 381879 | Stratford | Stratford | 2022-02-28 | Kings | 31 | 443 | 878 | |
382541 | 382541 | Blue Jay | Blue Jay | 2022-02-28 | San Bernardino | 71 | 342 | 900 | |
382551 | 382551 | Forest Falls | Forest Falls | 2022-02-28 | San Bernardino | 71 | 118 | 920 | |
382207 | 382207 | Unincorporated - Roosevelt | Roosevelt | 2022-02-28 | Los Angeles | 37 | 216 | 931 | |
382451 | 382451 | 96141 | 96141: Homewood | 2022-02-28 | Placer | 61 | 64 | 933 | |
381773 | 381773 | Biola | Biola | 2022-02-28 | Fresno | 19 | 300 | 949 | |
382366 | 382366 | West Napa Area | West Napa Area | 2022-02-28 | Napa | 55 | 92 | 951 | |
382237 | 382237 | Unincorporated - West LA | Unincorporated - West LA | 2022-02-28 | Los Angeles | 37 | 534 | 952 | |
382765 | 382765 | La Honda | La Honda | 2022-02-28 | San Mateo | 81 | 62 | 960 | |
382862 | 382862 | 95452 | 95452: Kenwood | 2022-02-28 | Sonoma | 97 | 87 | 970 | |
382361 | 382361 | North Calistoga | North Calistoga | 2022-02-28 | Napa | 55 | 85 | 980 | |
381852 | 381852 | 93518 | 93518: Caliente | 2022-02-28 | Kern | 29 | 85 | 995 | |
381739 | 381739 | 95254 | 95254 | 2022-02-28 | Calaveras | 9 | 82 | 1035 | |
381923 | 381923 | City of Bradbury | Bradbury | 2022-02-28 | Los Angeles | 37 | 63 | 1069 | |
382146 | 382146 | Unincorporated - Bouquet Canyon | Bouquet Canyon | 2022-02-28 | Los Angeles | 37 | 147 | 1073 | |
382175 | 382175 | Unincorporated - Hi Vista | Hi Vista | 2022-02-28 | Los Angeles | 37 | 132 | 1098 | |
381774 | 381774 | Cantua Creek | Cantua Creek | 2022-02-28 | Fresno | 19 | 202 | 1125 | |
381803 | 381803 | Tranquillity | Tranquillity | 2022-02-28 | Fresno | 19 | 175 | 1132 | |
382575 | 382575 | Oro Grande | Oro Grande | 2022-02-28 | San Bernardino | 71 | 198 | 1137 | |
382751 | 382751 | Shandon | Shandon | 2022-02-28 | San Luis Obispo | 79 | 381 | 1141 | |
381737 | 381737 | 95246, 95250 | 95246, 95250 | 2022-02-28 | Calaveras | 9 | 152 | 1159 | |
382868 | 382868 | 95497 | 95497: The Sea Ranch | 2022-02-28 | Sonoma | 97 | 30 | 1161 | |
382586 | 382586 | Trona | Trona | 2022-02-28 | San Bernardino | 71 | 90 | 1191 | |
382209 | 382209 | Unincorporated - Rosewood/East Gardena | Rosewood/East Gardena | 2022-02-28 | Los Angeles | 37 | 405 | 1193 | |
382349 | 382349 | 95039 | 95039: Moss Landing | 2022-02-28 | Monterey | 53 | 245 | 1195 | |
382195 | 382195 | Unincorporated - North Lancaster | North Lancaster | 2022-02-28 | Los Angeles | 37 | 335 | 1198 | |
382438 | 382438 | 95681 | 95681: Sheridan | 2022-02-28 | Placer | 61 | 209 | 1241 | |
382139 | 382139 | Unincorporated - Angeles National Forest | Unincorporated - Angeles National Forest | 2022-02-28 | Los Angeles | 37 | 72 | 1245 | |
382750 | 382750 | Santa Margarita | Santa Margarita | 2022-02-28 | San Luis Obispo | 79 | 386 | 1252 | |
382558 | 382558 | Hinkley | Hinkley | 2022-02-28 | San Bernardino | 71 | 124 | 1259 | |
382539 | 382539 | Big River | Big River | 2022-02-28 | San Bernardino | 71 | 47 | 1264 | |
382863 | 382863 | 95462 | 95462: Monte Rio | 2022-02-28 | Sonoma | 97 | 109 | 1265 | |
382734 | 382734 | Avila | Avila | 2022-02-28 | San Luis Obispo | 79 | 111 | 1273 | |
382363 | 382363 | Pope Valley Area | Pope Valley Area | 2022-02-28 | Napa | 55 | 87 | 1275 | |
382208 | 382208 | Unincorporated - Rosewood | Rosewood | 2022-02-28 | Los Angeles | 37 | 394 | 1286 | |
382227 | 382227 | Unincorporated - Sunrise Village | Sunrise Village | 2022-02-28 | Los Angeles | 37 | 413 | 1296 | |
382189 | 382189 | Unincorporated - Littlerock/Juniper Hills | Littlerock/Juniper Hills | 2022-02-28 | Los Angeles | 37 | 277 | 1297 | |
382241 | 382241 | Unincorporated - Westfield/Academy Hills | Westfield/Academy Hills | 2022-02-28 | Los Angeles | 37 | 159 | 1300 | |
382758 | 382758 | Colma | Colma | 2022-02-28 | San Mateo | 81 | 615 | 1302 | |
382106 | 382106 | Los Angeles - Toluca Terrace | Toluca Terrace | 2022-02-28 | Los Angeles | 37 | 354 | 1306 | |
381747 | 381747 | Byron | Byron | 2022-02-28 | Contra Costa | 13 | 249 | 1325 | |
382455 | 382455 | 96146 | 96146: Olympic Valley | 2022-02-28 | Placer | 61 | 235 | 1326 | |
381813 | 381813 | 92257 | 92257: Niland | 2022-02-28 | Imperial | 25 | 305 | 1332 | |
381722 | 381722 | 94720 | 94720: Berkeley | 2022-02-28 | Alameda | 1 | 690 | 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 );