latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
64 rows where county = "Riverside", "date" is on date 2020-06-27 and fips = 65 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1146651 | 1146651 | Anza | Anza | 2020-06-27 | Riverside | 65 | 6 | 3151 | |
1146652 | 1146652 | Banning | Banning | 2020-06-27 | Riverside | 65 | 178 | 30942 | |
1146653 | 1146653 | Beaumont | Beaumont | 2020-06-27 | Riverside | 65 | 303 | 45403 | |
1146654 | 1146654 | Bermuda Dunes | Bermuda Dunes | 2020-06-27 | Riverside | 65 | 35 | 6817 | |
1146655 | 1146655 | Blythe | Blythe | 2020-06-27 | Riverside | 65 | 213 | 19581 | |
1146656 | 1146656 | Cabazon | Cabazon | 2020-06-27 | Riverside | 65 | 14 | 3367 | |
1146657 | 1146657 | Calimesa | Calimesa | 2020-06-27 | Riverside | 65 | 37 | 8651 | |
1146658 | 1146658 | Canyon Lake | Canyon Lake | 2020-06-27 | Riverside | 65 | 14 | 11106 | |
1146659 | 1146659 | Cathedral City | Cathedral City | 2020-06-27 | Riverside | 65 | 552 | 54037 | |
1146660 | 1146660 | Cherry Valley | Cherry Valley | 2020-06-27 | Riverside | 65 | 18 | 7755 | |
1146661 | 1146661 | Coachella | Coachella | 2020-06-27 | Riverside | 65 | 1000 | 44849 | |
1146662 | 1146662 | Corona | Corona | 2020-06-27 | Riverside | 65 | 662 | 165355 | |
1146663 | 1146663 | Coronita | Coronita | 2020-06-27 | Riverside | 65 | 5 | 3138 | |
1146664 | 1146664 | Desert Edge | Desert Edge | 2020-06-27 | Riverside | 65 | 13 | 3343 | |
1146665 | 1146665 | Desert Hot Springs | Desert Hot Springs | 2020-06-27 | Riverside | 65 | 246 | 28430 | |
1146666 | 1146666 | Desert Palms | Desert Palms | 2020-06-27 | Riverside | 65 | 13 | 6947 | |
1146667 | 1146667 | East Hemet | East Hemet | 2020-06-27 | Riverside | 65 | 68 | 20679 | |
1146668 | 1146668 | Eastvale | Eastvale | 2020-06-27 | Riverside | 65 | 248 | 61337 | |
1146669 | 1146669 | El Cerrito | El Cerrito | 2020-06-27 | Riverside | 65 | 25 | 5471 | |
1146670 | 1146670 | El Sobrante | El Sobrante | 2020-06-27 | Riverside | 65 | 62 | 13966 | |
1146671 | 1146671 | French Valley | French Valley | 2020-06-27 | Riverside | 65 | 75 | 33818 | |
1146672 | 1146672 | Garnet | Garnet | 2020-06-27 | Riverside | 65 | 43 | 5057 | |
1146673 | 1146673 | Good Hope | Good Hope | 2020-06-27 | Riverside | 65 | 68 | 9173 | |
1146674 | 1146674 | Green Acres | Green Acres | 2020-06-27 | Riverside | 65 | 7 | 2542 | |
1146675 | 1146675 | Hemet | Hemet | 2020-06-27 | Riverside | 65 | 407 | 84069 | |
1146676 | 1146676 | Highgrove | Highgrove | 2020-06-27 | Riverside | 65 | 0 | 4986 | |
1146677 | 1146677 | Home Gardens | Home Gardens | 2020-06-27 | Riverside | 65 | 78 | 11442 | |
1146678 | 1146678 | Homeland | Homeland | 2020-06-27 | Riverside | 65 | 19 | 7326 | |
1146679 | 1146679 | Idyllwild-Pine Cove | Idyllwild-Pine Cove | 2020-06-27 | Riverside | 65 | 7 | 2459 | |
1146680 | 1146680 | Indian Wells | Indian Wells | 2020-06-27 | Riverside | 65 | 17 | 5317 | |
1146681 | 1146681 | Indio | Indio | 2020-06-27 | Riverside | 65 | 1190 | 88291 | |
1146682 | 1146682 | Jurupa Valley | Jurupa Valley | 2020-06-27 | Riverside | 65 | 729 | 103784 | |
1146683 | 1146683 | La Quinta | La Quinta | 2020-06-27 | Riverside | 65 | 246 | 40704 | |
1146684 | 1146684 | Lake Elsinore | Lake Elsinore | 2020-06-27 | Riverside | 65 | 259 | 64037 | |
1146685 | 1146685 | Lake Mathews | Lake Mathews | 2020-06-27 | Riverside | 65 | 21 | 6848 | |
1146686 | 1146686 | Lakeland Village | Lakeland Village | 2020-06-27 | Riverside | 65 | 56 | 13170 | |
1146687 | 1146687 | Lakeview | Lakeview | 2020-06-27 | Riverside | 65 | 9 | 2566 | |
1146688 | 1146688 | Mead Valley | Mead Valley | 2020-06-27 | Riverside | 65 | 88 | 19925 | |
1146689 | 1146689 | Meadowbrook | Meadowbrook | 2020-06-27 | Riverside | 65 | 6 | 3033 | |
1146690 | 1146690 | Mecca | Mecca | 2020-06-27 | Riverside | 65 | 162 | 7174 | |
1146691 | 1146691 | Menifee | Menifee | 2020-06-27 | Riverside | 65 | 273 | 88515 | |
1146692 | 1146692 | Moreno Valley | Moreno Valley | 2020-06-27 | Riverside | 65 | 1349 | 205034 | |
1146693 | 1146693 | Murrieta | Murrieta | 2020-06-27 | Riverside | 65 | 229 | 111427 | |
1146694 | 1146694 | Norco | Norco | 2020-06-27 | Riverside | 65 | 120 | 26569 | |
1146695 | 1146695 | North Shore | North Shore | 2020-06-27 | Riverside | 65 | 61 | 2892 | |
1146696 | 1146696 | Nuevo | Nuevo | 2020-06-27 | Riverside | 65 | 33 | 7033 | |
1146697 | 1146697 | Oasis | Oasis | 2020-06-27 | Riverside | 65 | 93 | 3020 | |
1146698 | 1146698 | Palm Desert | Palm Desert | 2020-06-27 | Riverside | 65 | 360 | 52124 | |
1146699 | 1146699 | Palm Springs | Palm Springs | 2020-06-27 | Riverside | 65 | 268 | 47525 | |
1146700 | 1146700 | Perris | Perris | 2020-06-27 | Riverside | 65 | 490 | 76276 | |
1146701 | 1146701 | Rancho Mirage | Rancho Mirage | 2020-06-27 | Riverside | 65 | 90 | 18075 | |
1146702 | 1146702 | Riverside | Riverside | 2020-06-27 | Riverside | 65 | 2258 | 323935 | |
1146703 | 1146703 | Romoland | Romoland | 2020-06-27 | Riverside | 65 | 6 | 2227 | |
1146704 | 1146704 | San Jacinto | San Jacinto | 2020-06-27 | Riverside | 65 | 268 | 47474 | |
1146705 | 1146705 | Sky Valley | Sky Valley | 2020-06-27 | Riverside | 65 | 7 | 2430 | |
1146706 | 1146706 | Temecula | Temecula | 2020-06-27 | Riverside | 65 | 236 | 112230 | |
1146707 | 1146707 | Temescal Valley | Temescal Valley | 2020-06-27 | Riverside | 65 | 78 | 26709 | |
1146708 | 1146708 | Thermal | Thermal | 2020-06-27 | Riverside | 65 | 74 | 1359 | |
1146709 | 1146709 | Thousand Palms | Thousand Palms | 2020-06-27 | Riverside | 65 | 38 | 7814 | |
1146710 | 1146710 | Valle Vista | Valle Vista | 2020-06-27 | Riverside | 65 | 43 | 16879 | |
1146711 | 1146711 | Vista Santa Rosa | Vista Santa Rosa | 2020-06-27 | Riverside | 65 | 39 | 2967 | |
1146712 | 1146712 | Wildomar | Wildomar | 2020-06-27 | Riverside | 65 | 107 | 36162 | |
1146713 | 1146713 | Winchester | Winchester | 2020-06-27 | Riverside | 65 | 2 | 2931 | |
1146714 | 1146714 | Woodcrest | Woodcrest | 2020-06-27 | Riverside | 65 | 47 | 17310 |
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] TEXT );