latimes_place_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

977,233 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips >30

county >30

Link rowid id name date ▲ county fips confirmed_cases note population
101 101 Coalinga Coalinga 2022-05-21 Fresno 19 5023   19345
102 102 Del Rey Del Rey 2022-05-21 Fresno 19 482   2759
103 103 Dinuba Dinuba 2022-05-21 Fresno 19 77   0
104 104 Firebaugh Firebaugh 2022-05-21 Fresno 19 1640   9965
105 105 Five Points Five Points 2022-05-21 Fresno 19 82   0
106 106 Fowler Fowler 2022-05-21 Fresno 19 1651   7917
107 107 Fresno Fresno 2022-05-21 Fresno 19 101523   608579
108 108 Friant Friant 2022-05-21 Fresno 19 170   1930
109 109 Huron Huron 2022-05-21 Fresno 19 1145   7579
110 110 Kerman Kerman 2022-05-21 Fresno 19 3818   21009
111 111 Kingsburg Kingsburg 2022-05-21 Fresno 19 2277   17086
112 112 Laton Laton 2022-05-21 Fresno 19 594   3513
113 113 Mendota Mendota 2022-05-21 Fresno 19 2355   13576
114 114 Orange Cove Orange Cove 2022-05-21 Fresno 19 2348   11320
115 115 Parlier Parlier 2022-05-21 Fresno 19 3781   17097
116 116 Prather Prather 2022-05-21 Fresno 19 128   0
117 117 Raisin Raisin 2022-05-21 Fresno 19 95   380
118 118 Reedley Reedley 2022-05-21 Fresno 19 5553   31129
119 119 Riverdale Riverdale 2022-05-21 Fresno 19 1186   6459
120 120 San Joaquin San Joaquin 2022-05-21 Fresno 19 780   4633
121 121 Sanger Sanger 2022-05-21 Fresno 19 7504   38252
122 122 Selma Selma 2022-05-21 Fresno 19 6741   31726
123 123 Squaw Valley Squaw Valley 2022-05-21 Fresno 19 250   3908
124 124 Tollhouse Tollhouse 2022-05-21 Fresno 19 173   2712
125 125 Tranquillity Tranquillity 2022-05-21 Fresno 19 175   1132
126 126 Greater Fortuna Area Greater Fortuna Area 2022-05-21 Humboldt 23 2475   20858
127 127 Greater Humboldt Bay Greater Humboldt Bay 2022-05-21 Humboldt 23 7906   78013
128 128 North North 2022-05-21 Humboldt 23 2985   30236
129 129 South South 2022-05-21 Humboldt 23 756   7601
130 130 92222 92222: Bard 2022-05-21 Imperial 25 13   0
131 131 92227 92227: Brawley 2022-05-21 Imperial 25 9207   27255
132 132 92231 92231: Calexico 2022-05-21 Imperial 25 13571   40019
133 133 92233 92233: Calipatria 2022-05-21 Imperial 25 1090   7618
134 134 92243 92243: El Centro 2022-05-21 Imperial 25 14004   50484
135 135 92244 92244: El Centro 2022-05-21 Imperial 25 225   0
136 136 92249 92249: Heber 2022-05-21 Imperial 25 2127   7898
137 137 92250 92250: Holtville 2022-05-21 Imperial 25 2038   8979
138 138 92251 92251: Imperial 2022-05-21 Imperial 25 6493   23388
139 139 92257 92257: Niland 2022-05-21 Imperial 25 319   1332
140 140 92259 92259: Ocotillo 2022-05-21 Imperial 25 28   94
141 141 92266 92266: Palo Verde 2022-05-21 Imperial 25 15   108
142 142 92273 92273: Seeley 2022-05-21 Imperial 25 412   1704
143 143 92274 92274: Thermal 2022-05-21 Imperial 25 1062   15118
144 144 92275 92275: Salton City 2022-05-21 Imperial 25 67   2456
145 145 92281 92281: Westmorland 2022-05-21 Imperial 25 590   2859
146 146 92283 92283: Winterhaven 2022-05-21 Imperial 25 807   1694
147 147 93203 93203: Arvin 2022-05-21 Kern 29 5929   22471
148 148 93205 93205: Bodfish 2022-05-21 Kern 29 313   1593
149 149 93206 93206: Buttonwillow 2022-05-21 Kern 29 516   2044
150 150 93215 93215: Delano 2022-05-21 Kern 29 17898   55845
151 151 93220 93220: Edison 2022-05-21 Kern 29 32   313
152 152 93222 93222: Pine Mountain Club 2022-05-21 Kern 29 158   1420
153 153 93224 93224: Fellows 2022-05-21 Kern 29 96   402
154 154 93225 93225: Frazier Park 2022-05-21 Kern 29 758   5319
155 155 93226 93226: Glennville 2022-05-21 Kern 29 37   195
156 156 93238 93238: Kernville 2022-05-21 Kern 29 210   1408
157 157 93240 93240: Lake Isabella 2022-05-21 Kern 29 1031   6960
158 158 93241 93241: Lamont 2022-05-21 Kern 29 4600   16969
159 159 93243 93243: Lebec 2022-05-21 Kern 29 236   1709
160 160 93249 93249: Lost Hills 2022-05-21 Kern 29 566   2264
161 161 93250 93250: Mc Farland 2022-05-21 Kern 29 4550   15523
162 162 93251 93251: Mc Kittrick 2022-05-21 Kern 29 53   243
163 163 93252 93252: Maricopa 2022-05-21 Kern 29 284   3188
164 164 93255 93255: Onyx 2022-05-21 Kern 29 46   707
165 165 93263 93263: Shafter 2022-05-21 Kern 29 6920   20710
166 166 93268 93268: Taft 2022-05-21 Kern 29 4285   17620
167 167 93276 93276: Tupman 2022-05-21 Kern 29 61   159
168 168 93280 93280: Wasco 2022-05-21 Kern 29 11132   27552
169 169 93283 93283: Weldon 2022-05-21 Kern 29 232   2086
170 170 93285 93285: Wofford Heights 2022-05-21 Kern 29 302   1723
171 171 93287 93287: Woody 2022-05-21 Kern 29 24   74
172 172 93301 93301: Bakersfield 2022-05-21 Kern 29 4282   12345
173 173 93304 93304: Bakersfield 2022-05-21 Kern 29 14352   50787
174 174 93305 93305: Bakersfield 2022-05-21 Kern 29 10362   39114
175 175 93306 93306: Bakersfield 2022-05-21 Kern 29 20782   70208
176 176 93307 93307: Bakersfield 2022-05-21 Kern 29 25091   84948
177 177 93308 93308: Bakersfield 2022-05-21 Kern 29 12763   54042
178 178 93309 93309: Bakersfield 2022-05-21 Kern 29 15943   60893
179 179 93311 93311: Bakersfield 2022-05-21 Kern 29 12554   44862
180 180 93312 93312: Bakersfield 2022-05-21 Kern 29 15069   59359
181 181 93313 93313: Bakersfield 2022-05-21 Kern 29 16528   51245
182 182 93314 93314: Bakersfield 2022-05-21 Kern 29 8538   26992
183 183 93501 93501: Mojave 2022-05-21 Kern 29 1056   5063
184 184 93505 93505: California City 2022-05-21 Kern 29 3206   13445
185 185 93516 93516: Boron 2022-05-21 Kern 29 459   2425
186 186 93518 93518: Caliente 2022-05-21 Kern 29 94   995
187 187 93519 93519: Cantil 2022-05-21 Kern 29 3   28
188 188 93523 93523: Edwards 2022-05-21 Kern 29 394   3312
189 189 93524 93524: Edwards 2022-05-21 Kern 29 50   168
190 190 93527 93527: Inyokern 2022-05-21 Kern 29 306   1852
191 191 93528 93528: Johannesburg 2022-05-21 Kern 29 14   124
192 192 93531 93531: Keene 2022-05-21 Kern 29 72   422
193 193 93554 93554: Randsburg 2022-05-21 Kern 29 10   143
194 194 93555 93555: Ridgecrest 2022-05-21 Kern 29 6202   34075
195 195 93560 93560: Rosamond 2022-05-21 Kern 29 5200   20797
196 196 93561 93561: Tehachapi 2022-05-21 Kern 29 8937   34271
197 197 Armona Armona 2022-05-21 Kings 31 1493   3795
198 198 Avenal Avenal 2022-05-21 Kings 31 7047   12923
199 199 Corcoran Corcoran 2022-05-21 Kings 31 10453   22301
200 200 Correctional facilities Prisons 2022-05-21 Kings 31 9767    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);