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-15
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
903100 | 903100 | 93205 | 93205: Bodfish | 2021-01-15 | Kern | 29 | 55 | 1593 | |
903101 | 903101 | 93206 | 93206: Buttonwillow | 2021-01-15 | Kern | 29 | 224 | 2044 | |
903102 | 903102 | 93215 | 93215: Delano | 2021-01-15 | Kern | 29 | 7050 | 55845 | |
903103 | 903103 | 93220 | 93220: Edison | 2021-01-15 | Kern | 29 | 18 | 313 | |
903104 | 903104 | 93222 | 93222: Pine Mountain Club | 2021-01-15 | Kern | 29 | 36 | 1420 | |
903105 | 903105 | 93224 | 93224: Fellows | 2021-01-15 | Kern | 29 | 24 | 402 | |
903106 | 903106 | 93225 | 93225: Frazier Park | 2021-01-15 | Kern | 29 | 185 | 5319 | |
903107 | 903107 | 93527 | 93527: Inyokern | 2021-01-15 | Kern | 29 | 47 | 1852 | |
903108 | 903108 | 93528 | 93528: Johannesburg | 2021-01-15 | Kern | 29 | 2 | 124 | |
903109 | 903109 | 93531 | 93531: Keene | 2021-01-15 | Kern | 29 | 20 | 422 | |
903110 | 903110 | 93554 | 93554: Randsburg | 2021-01-15 | Kern | 29 | 6 | 143 | |
903111 | 903111 | 93555 | 93555: Ridgecrest | 2021-01-15 | Kern | 29 | 1340 | 34075 | |
903112 | 903112 | 93560 | 93560: Rosamond | 2021-01-15 | Kern | 29 | 1594 | 20797 | |
903113 | 903113 | 93561 | 93561: Tehachapi | 2021-01-15 | Kern | 29 | 3091 | 34271 | |
903114 | 903114 | Armona | Armona | 2021-01-15 | Kings | 31 | 445 | 3795 | |
903115 | 903115 | Avenal | Avenal | 2021-01-15 | Kings | 31 | 933 | 12923 | |
903116 | 903116 | Corcoran | Corcoran | 2021-01-15 | Kings | 31 | 1569 | 22301 | |
903117 | 903117 | Correctional facilities | Prisons | 2021-01-15 | Kings | 31 | 6967 | ||
903118 | 903118 | Hanford | Hanford | 2021-01-15 | Kings | 31 | 5799 | 55893 | |
903119 | 903119 | Kettleman City | Kettleman City | 2021-01-15 | Kings | 31 | 132 | 1395 | |
903120 | 903120 | Lemoore | Lemoore | 2021-01-15 | Kings | 31 | 2580 | 25791 | |
903121 | 903121 | Other Area | Other | 2021-01-15 | Kings | 31 | 182 | ||
903122 | 903122 | Stratford | Stratford | 2021-01-15 | Kings | 31 | 103 | 878 | |
903123 | 903123 | 95422 | 95422 | 2021-01-15 | Lake | 33 | 548 | 15550 | |
903124 | 903124 | 95423 | 95423 | 2021-01-15 | Lake | 33 | 93 | 3757 | |
903125 | 903125 | 95424 | 95424 | 2021-01-15 | Lake | 33 | 7 | 0 | |
903126 | 903126 | 95426 | 95426 | 2021-01-15 | Lake | 33 | 19 | 1404 | |
903127 | 903127 | 95435 | 95435 | 2021-01-15 | Lake | 33 | 23 | 14 | |
903128 | 903128 | 95443 | 95443 | 2021-01-15 | Lake | 33 | 2 | 270 | |
903129 | 903129 | 95451 | 95451 | 2021-01-15 | Lake | 33 | 451 | 11627 | |
903130 | 903130 | 95453 | 95453 | 2021-01-15 | Lake | 33 | 592 | 11092 | |
903131 | 903131 | 95457 | 95457 | 2021-01-15 | Lake | 33 | 101 | 3330 | |
903132 | 903132 | 95458 | 95458 | 2021-01-15 | Lake | 33 | 78 | 3019 | |
903133 | 903133 | 95461 | 95461 | 2021-01-15 | Lake | 33 | 57 | 2440 | |
903134 | 903134 | 95464 | 95464 | 2021-01-15 | Lake | 33 | 87 | 2538 | |
903135 | 903135 | 95467 | 95467 | 2021-01-15 | Lake | 33 | 99 | 6044 | |
903136 | 903136 | 95485 | 95485 | 2021-01-15 | Lake | 33 | 55 | 2688 | |
903137 | 903137 | 95493 | 95493 | 2021-01-15 | Lake | 33 | 1 | 241 | |
903138 | 903138 | 90802 | 90802: Long Beach | 2021-01-15 | Los Angeles | 37 | 3109 | 39453 | |
903139 | 903139 | 90803 | 90803: Long Beach | 2021-01-15 | Los Angeles | 37 | 1515 | 32389 | |
903140 | 903140 | 90804 | 90804: Long Beach | 2021-01-15 | Los Angeles | 37 | 3715 | 39344 | |
903141 | 903141 | 90805 | 90805: Long Beach | 2021-01-15 | Los Angeles | 37 | 10798 | 96708 | |
903142 | 903142 | 90806 | 90806: Long Beach | 2021-01-15 | Los Angeles | 37 | 5005 | 42817 | |
903143 | 903143 | 90807 | 90807: Long Beach | 2021-01-15 | Los Angeles | 37 | 2303 | 32067 | |
903144 | 903144 | 90808 | 90808: Long Beach | 2021-01-15 | Los Angeles | 37 | 2099 | 38860 | |
903145 | 903145 | 90810 | 90810: Long Beach | 2021-01-15 | Los Angeles | 37 | 3782 | 38579 | |
903146 | 903146 | 90813 | 90813: Long Beach | 2021-01-15 | Los Angeles | 37 | 6476 | 59000 | |
903147 | 903147 | 90814 | 90814: Long Beach | 2021-01-15 | Los Angeles | 37 | 1035 | 18587 | |
903148 | 903148 | 90815 | 90815: Long Beach | 2021-01-15 | Los Angeles | 37 | 2264 | 41026 | |
903149 | 903149 | 91101 | 91101: Pasadena | 2021-01-15 | Los Angeles | 37 | 1140 | 20719 | |
903150 | 903150 | 91103 | 91103: Pasadena | 2021-01-15 | Los Angeles | 37 | 3060 | 28435 | |
903151 | 903151 | 91104 | 91104: Pasadena | 2021-01-15 | Los Angeles | 37 | 1961 | 39178 | |
903152 | 903152 | 91105 | 91105: Pasadena | 2021-01-15 | Los Angeles | 37 | 587 | 11907 | |
903153 | 903153 | 91106 | 91106: Pasadena | 2021-01-15 | Los Angeles | 37 | 1233 | 25479 | |
903154 | 903154 | 91107 | 91107: Pasadena | 2021-01-15 | Los Angeles | 37 | 1019 | 321 | |
903155 | 903155 | City of Agoura Hills | Agoura Hills | 2021-01-15 | Los Angeles | 37 | 751 | 20883 | |
903156 | 903156 | City of Alhambra | Alhambra | 2021-01-15 | Los Angeles | 37 | 5445 | 86724 | |
903157 | 903157 | City of Arcadia | Arcadia | 2021-01-15 | Los Angeles | 37 | 2085 | 57754 | |
903158 | 903158 | City of Artesia | Artesia | 2021-01-15 | Los Angeles | 37 | 1626 | 16795 | |
903159 | 903159 | City of Avalon | Avalon | 2021-01-15 | Los Angeles | 37 | 8 | 3869 | |
903160 | 903160 | City of Azusa | Azusa | 2021-01-15 | Los Angeles | 37 | 5150 | 50040 | |
903161 | 903161 | City of Baldwin Park | Baldwin Park | 2021-01-15 | Los Angeles | 37 | 10834 | 76769 | |
903162 | 903162 | City of Bell | Bell | 2021-01-15 | Los Angeles | 37 | 5486 | 36332 | |
903163 | 903163 | City of Bell Gardens | Bell Gardens | 2021-01-15 | Los Angeles | 37 | 6898 | 43071 | |
903164 | 903164 | City of Bellflower | Bellflower | 2021-01-15 | Los Angeles | 37 | 8679 | 77735 | |
903165 | 903165 | City of Beverly Hills | Beverly Hills | 2021-01-15 | Los Angeles | 37 | 2018 | 34520 | |
903166 | 903166 | City of Bradbury | Bradbury | 2021-01-15 | Los Angeles | 37 | 32 | 1069 | |
903167 | 903167 | City of Burbank | Burbank | 2021-01-15 | Los Angeles | 37 | 6638 | 107180 | |
903168 | 903168 | City of Calabasas | Calabasas | 2021-01-15 | Los Angeles | 37 | 881 | 24323 | |
903169 | 903169 | City of Carson | Carson | 2021-01-15 | Los Angeles | 37 | 7103 | 93846 | |
903170 | 903170 | City of Cerritos | Cerritos | 2021-01-15 | Los Angeles | 37 | 2283 | 50067 | |
903171 | 903171 | City of Claremont | Claremont | 2021-01-15 | Los Angeles | 37 | 1778 | 36484 | |
903172 | 903172 | City of Commerce | Commerce | 2021-01-15 | Los Angeles | 37 | 2080 | 13069 | |
903173 | 903173 | City of Compton | Compton | 2021-01-15 | Los Angeles | 37 | 13669 | 99904 | |
903174 | 903174 | City of Covina | Covina | 2021-01-15 | Los Angeles | 37 | 5215 | 49032 | |
903175 | 903175 | City of Cudahy | Cudahy | 2021-01-15 | Los Angeles | 37 | 3933 | 24347 | |
903176 | 903176 | City of Culver City | Culver City | 2021-01-15 | Los Angeles | 37 | 1660 | 39865 | |
903177 | 903177 | City of Diamond Bar | Diamond Bar | 2021-01-15 | Los Angeles | 37 | 2505 | 57515 | |
903178 | 903178 | City of Downey | Downey | 2021-01-15 | Los Angeles | 37 | 14546 | 114263 | |
903179 | 903179 | City of Duarte | Duarte | 2021-01-15 | Los Angeles | 37 | 1845 | 22016 | |
903180 | 903180 | City of El Monte | El Monte | 2021-01-15 | Los Angeles | 37 | 14101 | 117269 | |
903181 | 903181 | City of El Segundo | El Segundo | 2021-01-15 | Los Angeles | 37 | 510 | 16786 | |
903182 | 903182 | City of Gardena | Gardena | 2021-01-15 | Los Angeles | 37 | 4892 | 61310 | |
903183 | 903183 | City of Glendale | Glendale | 2021-01-15 | Los Angeles | 37 | 14557 | 206493 | |
903184 | 903184 | City of Glendora | Glendora | 2021-01-15 | Los Angeles | 37 | 3798 | 52764 | |
903185 | 903185 | City of Hawaiian Gardens | Hawaiian Gardens | 2021-01-15 | Los Angeles | 37 | 1859 | 14676 | |
903186 | 903186 | City of Hawthorne | Hawthorne | 2021-01-15 | Los Angeles | 37 | 7933 | 88787 | |
903187 | 903187 | City of Hermosa Beach | Hermosa Beach | 2021-01-15 | Los Angeles | 37 | 736 | 19670 | |
903188 | 903188 | City of Hidden Hills | Hidden Hills | 2021-01-15 | Los Angeles | 37 | 60 | 1890 | |
903189 | 903189 | City of Huntington Park | Huntington Park | 2021-01-15 | Los Angeles | 37 | 9429 | 59484 | |
903190 | 903190 | City of Industry | Industry | 2021-01-15 | Los Angeles | 37 | 121 | 437 | |
903191 | 903191 | City of Inglewood | Inglewood | 2021-01-15 | Los Angeles | 37 | 10557 | 113582 | |
903192 | 903192 | City of Irwindale | Irwindale | 2021-01-15 | Los Angeles | 37 | 211 | 1459 | |
903193 | 903193 | City of La Canada Flintridge | La Canada Flintridge | 2021-01-15 | Los Angeles | 37 | 602 | 20693 | |
903194 | 903194 | City of La Habra Heights | La Habra Heights | 2021-01-15 | Los Angeles | 37 | 90 | 5455 | |
903195 | 903195 | City of La Mirada | La Mirada | 2021-01-15 | Los Angeles | 37 | 3366 | 49599 | |
903196 | 903196 | City of La Puente | La Puente | 2021-01-15 | Los Angeles | 37 | 5531 | 40697 | |
903197 | 903197 | City of La Verne | La Verne | 2021-01-15 | Los Angeles | 37 | 2212 | 33282 | |
903198 | 903198 | City of Lakewood | Lakewood | 2021-01-15 | Los Angeles | 37 | 5627 | 80362 | |
903199 | 903199 | City of Lancaster | Lancaster | 2021-01-15 | Los Angeles | 37 | 17113 | 161570 |
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 );