latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
1,051 rows where "date" is on date 2020-05-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 25
county 25
- Los Angeles 353
- San Diego 110
- Riverside 64
- San Bernardino 64
- Orange 41
- Fresno 32
- Placer 32
- Sonoma 32
- Tulare 28
- San Francisco 26
- Ventura 25
- San Luis Obispo 22
- Napa 18
- Imperial 17
- Santa Clara 15
- Santa Barbara 11
- Merced 10
- Stanislaus 10
- Kings 9
- Sacramento 8
- Solano 8
- Mendocino 5
- Yolo 5
- El Dorado 3
- Mono 3
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1206627 | 1206627 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2020-05-05 | El Dorado | 17 | 0 | 35294 | |
1206628 | 1206628 | South County | South County | 2020-05-05 | El Dorado | 17 | 1 | 10345 | |
1206629 | 1206629 | Tahoe Region | Tahoe Region | 2020-05-05 | El Dorado | 17 | 20 | 30275 | |
1206630 | 1206630 | Auberry | Auberry | 2020-05-05 | Fresno | 19 | 0 | 3994 | |
1206631 | 1206631 | Biola | Biola | 2020-05-05 | Fresno | 19 | 0 | 949 | |
1206632 | 1206632 | Cantua Creek | Cantua Creek | 2020-05-05 | Fresno | 19 | 0 | 1125 | |
1206633 | 1206633 | Caruthers | Caruthers | 2020-05-05 | Fresno | 19 | 0 | 5887 | |
1206634 | 1206634 | Clovis | Clovis | 2020-05-05 | Fresno | 19 | 43 | 122949 | |
1206635 | 1206635 | Coalinga | Coalinga | 2020-05-05 | Fresno | 19 | 4 | 4 or fewer | 19345 |
1206636 | 1206636 | Del Rey | Del Rey | 2020-05-05 | Fresno | 19 | 0 | 2759 | |
1206637 | 1206637 | Dinuba | Dinuba | 2020-05-05 | Fresno | 19 | 0 | 0 | |
1206638 | 1206638 | Dos Palos | Dos Palos | 2020-05-05 | Fresno | 19 | 0 | ||
1206639 | 1206639 | Dunlap | Dunlap | 2020-05-05 | Fresno | 19 | 0 | ||
1206640 | 1206640 | Firebaugh | Firebaugh | 2020-05-05 | Fresno | 19 | 19 | 9965 | |
1206641 | 1206641 | Five Points | Five Points | 2020-05-05 | Fresno | 19 | 0 | 0 | |
1206642 | 1206642 | Fowler | Fowler | 2020-05-05 | Fresno | 19 | 4 | 4 or fewer | 7917 |
1206643 | 1206643 | Fresno | Fresno | 2020-05-05 | Fresno | 19 | 375 | 608579 | |
1206644 | 1206644 | Friant | Friant | 2020-05-05 | Fresno | 19 | 0 | 1930 | |
1206645 | 1206645 | Huron | Huron | 2020-05-05 | Fresno | 19 | 19 | 7579 | |
1206646 | 1206646 | Kerman | Kerman | 2020-05-05 | Fresno | 19 | 8 | 21009 | |
1206647 | 1206647 | Kingsburg | Kingsburg | 2020-05-05 | Fresno | 19 | 14 | 17086 | |
1206648 | 1206648 | Laton | Laton | 2020-05-05 | Fresno | 19 | 5 | 3513 | |
1206649 | 1206649 | Mendota | Mendota | 2020-05-05 | Fresno | 19 | 28 | 13576 | |
1206650 | 1206650 | Orange Cove | Orange Cove | 2020-05-05 | Fresno | 19 | 19 | 11320 | |
1206651 | 1206651 | Parlier | Parlier | 2020-05-05 | Fresno | 19 | 30 | 17097 | |
1206652 | 1206652 | Prather | Prather | 2020-05-05 | Fresno | 19 | 0 | 0 | |
1206653 | 1206653 | Raisin | Raisin | 2020-05-05 | Fresno | 19 | 0 | 380 | |
1206654 | 1206654 | Reedley | Reedley | 2020-05-05 | Fresno | 19 | 35 | 31129 | |
1206655 | 1206655 | Riverdale | Riverdale | 2020-05-05 | Fresno | 19 | 0 | 6459 | |
1206656 | 1206656 | San Joaquin | San Joaquin | 2020-05-05 | Fresno | 19 | 4 | 4 or fewer | 4633 |
1206657 | 1206657 | Sanger | Sanger | 2020-05-05 | Fresno | 19 | 52 | 38252 | |
1206658 | 1206658 | Selma | Selma | 2020-05-05 | Fresno | 19 | 50 | 31726 | |
1206659 | 1206659 | Squaw Valley | Squaw Valley | 2020-05-05 | Fresno | 19 | 0 | 3908 | |
1206660 | 1206660 | Tollhouse | Tollhouse | 2020-05-05 | Fresno | 19 | 0 | 2712 | |
1206661 | 1206661 | Tranquillity | Tranquillity | 2020-05-05 | Fresno | 19 | 0 | 1132 | |
1206662 | 1206662 | 92222 | 92222: Bard | 2020-05-05 | Imperial | 25 | 0 | 0 | |
1206663 | 1206663 | 92227 | 92227: Brawley | 2020-05-05 | Imperial | 25 | 84 | 27255 | |
1206664 | 1206664 | 92231 | 92231: Calexico | 2020-05-05 | Imperial | 25 | 108 | 40019 | |
1206665 | 1206665 | 92233 | 92233: Calipatria | 2020-05-05 | Imperial | 25 | 7 | 7618 | |
1206666 | 1206666 | 92243 | 92243: El Centro | 2020-05-05 | Imperial | 25 | 0 | 50484 | |
1206667 | 1206667 | 92244 | 92244: El Centro | 2020-05-05 | Imperial | 25 | 0 | 0 | |
1206668 | 1206668 | 92249 | 92249: Heber | 2020-05-05 | Imperial | 25 | 15 | 7898 | |
1206669 | 1206669 | 92250 | 92250: Holtville | 2020-05-05 | Imperial | 25 | 13 | 8979 | |
1206670 | 1206670 | 92251 | 92251: Imperial | 2020-05-05 | Imperial | 25 | 38 | 23388 | |
1206671 | 1206671 | 92257 | 92257: Niland | 2020-05-05 | Imperial | 25 | 1 | 1332 | |
1206672 | 1206672 | 92259 | 92259: Ocotillo | 2020-05-05 | Imperial | 25 | 0 | 94 | |
1206673 | 1206673 | 92266 | 92266: Palo Verde | 2020-05-05 | Imperial | 25 | 0 | 108 | |
1206674 | 1206674 | 92273 | 92273: Seeley | 2020-05-05 | Imperial | 25 | 0 | 1704 | |
1206675 | 1206675 | 92274 | 92274: Thermal | 2020-05-05 | Imperial | 25 | 7 | 15118 | |
1206676 | 1206676 | 92275 | 92275: Salton City | 2020-05-05 | Imperial | 25 | 5 | 2456 | |
1206677 | 1206677 | 92281 | 92281: Westmorland | 2020-05-05 | Imperial | 25 | 6 | 2859 | |
1206678 | 1206678 | 92283 | 92283: Winterhaven | 2020-05-05 | Imperial | 25 | 2 | 1694 | |
1206679 | 1206679 | Armona | Armona | 2020-05-05 | Kings | 31 | 0 | 3795 | |
1206680 | 1206680 | Avenal | Avenal | 2020-05-05 | Kings | 31 | 9 | 5 to 9 | 12923 |
1206681 | 1206681 | Corcoran | Corcoran | 2020-05-05 | Kings | 31 | 32 | 22301 | |
1206682 | 1206682 | Correctional facilities | Prisons | 2020-05-05 | Kings | 31 | 0 | ||
1206683 | 1206683 | Hanford | Hanford | 2020-05-05 | Kings | 31 | 100 | 55893 | |
1206684 | 1206684 | Kettleman City | Kettleman City | 2020-05-05 | Kings | 31 | 0 | 1395 | |
1206685 | 1206685 | Lemoore | Lemoore | 2020-05-05 | Kings | 31 | 35 | 25791 | |
1206686 | 1206686 | Stratford | Stratford | 2020-05-05 | Kings | 31 | 0 | 878 | |
1206687 | 1206687 | Unincorporated | Other | 2020-05-05 | Kings | 31 | 22 | ||
1206688 | 1206688 | 90802 | 90802: Long Beach | 2020-05-05 | Los Angeles | 37 | 70 | 39453 | |
1206689 | 1206689 | 90803 | 90803: Long Beach | 2020-05-05 | Los Angeles | 37 | 80 | 32389 | |
1206690 | 1206690 | 90804 | 90804: Long Beach | 2020-05-05 | Los Angeles | 37 | 60 | 39344 | |
1206691 | 1206691 | 90805 | 90805: Long Beach | 2020-05-05 | Los Angeles | 37 | 131 | 96708 | |
1206692 | 1206692 | 90806 | 90806: Long Beach | 2020-05-05 | Los Angeles | 37 | 74 | 42817 | |
1206693 | 1206693 | 90807 | 90807: Long Beach | 2020-05-05 | Los Angeles | 37 | 95 | 32067 | |
1206694 | 1206694 | 90808 | 90808: Long Beach | 2020-05-05 | Los Angeles | 37 | 33 | 38860 | |
1206695 | 1206695 | 90810 | 90810: Long Beach | 2020-05-05 | Los Angeles | 37 | 67 | 38579 | |
1206696 | 1206696 | 90813 | 90813: Long Beach | 2020-05-05 | Los Angeles | 37 | 86 | 59000 | |
1206697 | 1206697 | 90814 | 90814: Long Beach | 2020-05-05 | Los Angeles | 37 | 17 | 18587 | |
1206698 | 1206698 | 90815 | 90815: Long Beach | 2020-05-05 | Los Angeles | 37 | 42 | 41026 | |
1206699 | 1206699 | 91101 | 91101: Pasadena | 2020-05-05 | Los Angeles | 37 | 0 | 20719 | |
1206700 | 1206700 | 91103 | 91103: Pasadena | 2020-05-05 | Los Angeles | 37 | 0 | 28435 | |
1206701 | 1206701 | 91104 | 91104: Pasadena | 2020-05-05 | Los Angeles | 37 | 0 | 39178 | |
1206702 | 1206702 | 91105 | 91105: Pasadena | 2020-05-05 | Los Angeles | 37 | 0 | 11907 | |
1206703 | 1206703 | 91106 | 91106: Pasadena | 2020-05-05 | Los Angeles | 37 | 0 | 25479 | |
1206704 | 1206704 | 91107 | 91107: Pasadena | 2020-05-05 | Los Angeles | 37 | 0 | 321 | |
1206705 | 1206705 | City of Agoura Hills | Agoura Hills | 2020-05-05 | Los Angeles | 37 | 31 | 20883 | |
1206706 | 1206706 | City of Alhambra | Alhambra | 2020-05-05 | Los Angeles | 37 | 99 | 86724 | |
1206707 | 1206707 | City of Arcadia | Arcadia | 2020-05-05 | Los Angeles | 37 | 46 | 57754 | |
1206708 | 1206708 | City of Artesia | Artesia | 2020-05-05 | Los Angeles | 37 | 15 | 16795 | |
1206709 | 1206709 | City of Avalon | Avalon | 2020-05-05 | Los Angeles | 37 | 0 | 3869 | |
1206710 | 1206710 | City of Azusa | Azusa | 2020-05-05 | Los Angeles | 37 | 83 | 50040 | |
1206711 | 1206711 | City of Baldwin Park | Baldwin Park | 2020-05-05 | Los Angeles | 37 | 116 | 76769 | |
1206712 | 1206712 | City of Bell | Bell | 2020-05-05 | Los Angeles | 37 | 137 | 36332 | |
1206713 | 1206713 | City of Bell Gardens | Bell Gardens | 2020-05-05 | Los Angeles | 37 | 117 | 43071 | |
1206714 | 1206714 | City of Bellflower | Bellflower | 2020-05-05 | Los Angeles | 37 | 155 | 77735 | |
1206715 | 1206715 | City of Beverly Hills | Beverly Hills | 2020-05-05 | Los Angeles | 37 | 114 | 34520 | |
1206716 | 1206716 | City of Bradbury | Bradbury | 2020-05-05 | Los Angeles | 37 | 1 | 1069 | |
1206717 | 1206717 | City of Burbank | Burbank | 2020-05-05 | Los Angeles | 37 | 270 | 107180 | |
1206718 | 1206718 | City of Calabasas | Calabasas | 2020-05-05 | Los Angeles | 37 | 46 | 24323 | |
1206719 | 1206719 | City of Carson | Carson | 2020-05-05 | Los Angeles | 37 | 266 | 93846 | |
1206720 | 1206720 | City of Cerritos | Cerritos | 2020-05-05 | Los Angeles | 37 | 60 | 50067 | |
1206721 | 1206721 | City of Claremont | Claremont | 2020-05-05 | Los Angeles | 37 | 27 | 36484 | |
1206722 | 1206722 | City of Commerce | Commerce | 2020-05-05 | Los Angeles | 37 | 12 | 13069 | |
1206723 | 1206723 | City of Compton | Compton | 2020-05-05 | Los Angeles | 37 | 242 | 99904 | |
1206724 | 1206724 | City of Covina | Covina | 2020-05-05 | Los Angeles | 37 | 101 | 49032 | |
1206725 | 1206725 | City of Cudahy | Cudahy | 2020-05-05 | Los Angeles | 37 | 83 | 24347 | |
1206726 | 1206726 | City of Culver City | Culver City | 2020-05-05 | Los Angeles | 37 | 85 | 39865 |
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 );