latimes_place_totals

⚠️ 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

68,931 rows where county = "Los Angeles" sorted by date descending

✎ View and edit SQL

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

fips

  • 37 68,931

county

  • Los Angeles · 68,931 ✖
Link rowid date ▲ county fips place confirmed_cases note x y
192 192 2020-10-30 Los Angeles 37 Acton 85   -118.216138 34.481366
193 193 2020-10-30 Los Angeles 37 Adams-Normandie 312   -118.302397 34.029122
194 194 2020-10-30 Los Angeles 37 Agoura Hills 222   -118.760876 34.151007
195 195 2020-10-30 Los Angeles 37 Agua Dulce 37   -118.32381 34.497963
196 196 2020-10-30 Los Angeles 37 Alhambra 1446   -118.135504 34.083961
197 197 2020-10-30 Los Angeles 37 Alsace 407   -118.362349 34.029571
198 198 2020-10-30 Los Angeles 37 Altadena 798   -118.135675 34.193482
199 199 2020-10-30 Los Angeles 37 Anaverde 21   -118.133856 34.535644
200 200 2020-10-30 Los Angeles 37 Angeles National Forest 2   -118.279007 34.275218
201 201 2020-10-30 Los Angeles 37 Angelino Heights 81   -118.251986 34.068331
202 202 2020-10-30 Los Angeles 37 Arcadia 598   -118.037297 34.134186
203 203 2020-10-30 Los Angeles 37 Arleta 1722   -118.431775 34.241478
204 204 2020-10-30 Los Angeles 37 Artesia 412   -118.08063 33.867577
205 205 2020-10-30 Los Angeles 37 Athens Village 266   -118.273697 33.919783
206 206 2020-10-30 Los Angeles 37 Athens-Westmont 1693   -118.302483 33.934033
207 207 2020-10-30 Los Angeles 37 Atwater Village 273   -118.258308 34.119421
208 208 2020-10-30 Los Angeles 37 Avalon 5   -118.331354 33.333921
209 209 2020-10-30 Los Angeles 37 Avocado Heights 320   -117.990979 34.040819
210 210 2020-10-30 Los Angeles 37 Azusa 1737   -117.912351 34.138622
211 211 2020-10-30 Los Angeles 37 Baldwin Hills 698   -118.356095 34.014825
212 212 2020-10-30 Los Angeles 37 Baldwin Park 3388   -117.972142 34.082841
213 213 2020-10-30 Los Angeles 37 Bassett 723   -117.977406 34.057144
214 214 2020-10-30 Los Angeles 37 Bel Air 107   -118.460296 34.098692
215 215 2020-10-30 Los Angeles 37 Bell 1783   -118.179783 33.980058
216 216 2020-10-30 Los Angeles 37 Bell Gardens 2271   -118.155014 33.966323
217 217 2020-10-30 Los Angeles 37 Bellflower 2690   -118.127136 33.888021
218 218 2020-10-30 Los Angeles 37 Beverly Crest 151   -118.424404 34.11298
219 219 2020-10-30 Los Angeles 37 Beverly Hills 756   -118.402109 34.078543
220 220 2020-10-30 Los Angeles 37 Beverlywood 195   -118.394492 34.044747
221 221 2020-10-30 Los Angeles 37 Bouquet Canyon 10   -118.363392 34.595497
222 222 2020-10-30 Los Angeles 37 Boyle Heights 4728   -118.20533 34.03815
223 223 2020-10-30 Los Angeles 37 Bradbury 19   -117.968387 34.153532
224 224 2020-10-30 Los Angeles 37 Brentwood 341   -118.485909 34.08524
225 225 2020-10-30 Los Angeles 37 Brookside 5   -118.336327 34.058936
226 226 2020-10-30 Los Angeles 37 Burbank 1933   -118.323487 34.1879
227 227 2020-10-30 Los Angeles 37 Cadillac-Corning 144   -118.381794 34.042513
228 228 2020-10-30 Los Angeles 37 Calabasas 319   -118.668881 34.13747
229 229 2020-10-30 Los Angeles 37 Canoga Park 2342   -118.600829 34.208098
230 230 2020-10-30 Los Angeles 37 Canyon Country 174   -118.434197 34.454977
231 231 2020-10-30 Los Angeles 37 Carson 2077   -118.255878 33.837391
232 232 2020-10-30 Los Angeles 37 Carthay 252   -118.372894 34.07124
233 233 2020-10-30 Los Angeles 37 Castaic 2189   -118.628355 34.610162
234 234 2020-10-30 Los Angeles 37 Central 2359   -118.258141 34.016399
235 235 2020-10-30 Los Angeles 37 Century City 139   -118.419399 34.052715
236 236 2020-10-30 Los Angeles 37 Century Palms/Cove 1652   -118.267985 33.932641
237 237 2020-10-30 Los Angeles 37 Cerritos 658   -118.068587 33.867752
238 238 2020-10-30 Los Angeles 37 Chatsworth 798   -118.596089 34.256617
239 239 2020-10-30 Los Angeles 37 Cheviot Hills 99   -118.408801 34.041277
240 240 2020-10-30 Los Angeles 37 Chinatown 150   -118.240969 34.06146
241 241 2020-10-30 Los Angeles 37 Claremont 471   -117.715319 34.125904
242 242 2020-10-30 Los Angeles 37 Cloverdale/Cochran 353   -118.356007 34.038941
243 243 2020-10-30 Los Angeles 37 Commerce 656   -118.151914 33.996345
244 244 2020-10-30 Los Angeles 37 Compton 4496   -118.22753 33.892938
245 245 2020-10-30 Los Angeles 37 Country Club Park 407   -118.325579 34.054301
246 246 2020-10-30 Los Angeles 37 Covina 1568   -117.881821 34.090264
247 247 2020-10-30 Los Angeles 37 Covina (Charter Oak) 359   -117.865044 34.100802
248 248 2020-10-30 Los Angeles 37 Crenshaw District 348   -118.335877 34.023057
249 249 2020-10-30 Los Angeles 37 Crestview 212   -118.378658 34.049595
250 250 2020-10-30 Los Angeles 37 Cudahy 1190   -118.183118 33.963116
251 251 2020-10-30 Los Angeles 37 Culver City 427   -118.396806 34.005798
252 252 2020-10-30 Los Angeles 37 Del Aire 79   -118.372296 33.922831
253 253 2020-10-30 Los Angeles 37 Del Rey 404   -118.424311 33.989764
254 254 2020-10-30 Los Angeles 37 Del Sur 23   -118.284121 34.764411
255 255 2020-10-30 Los Angeles 37 Desert View Highlands 61   -118.153557 34.590253
256 256 2020-10-30 Los Angeles 37 Diamond Bar 640   -117.81613 33.999164
257 257 2020-10-30 Los Angeles 37 Downey 4714   -118.131148 33.937862
258 258 2020-10-30 Los Angeles 37 Downtown 912   -118.257803 34.044724
259 259 2020-10-30 Los Angeles 37 Duarte 629   -117.950531 34.16094
260 260 2020-10-30 Los Angeles 37 Eagle Rock 752   -118.205209 34.135207
261 261 2020-10-30 Los Angeles 37 East Covina 4   -117.835314 34.088091
262 262 2020-10-30 Los Angeles 37 East Hollywood 715   -118.292538 34.09217
263 263 2020-10-30 Los Angeles 37 East La Mirada 125   -117.984485 33.922235
264 264 2020-10-30 Los Angeles 37 East Lancaster 2   -117.995982 34.667605
265 265 2020-10-30 Los Angeles 37 East Los Angeles 7123   -118.169189 34.032673
266 266 2020-10-30 Los Angeles 37 East Pasadena 89   -118.082551 34.161732
267 267 2020-10-30 Los Angeles 37 East Rancho Dominguez 721   -118.195596 33.894857
268 268 2020-10-30 Los Angeles 37 East Whittier 105   -117.994826 33.927445
269 269 2020-10-30 Los Angeles 37 Echo Park 296   -118.255001 34.082177
270 270 2020-10-30 Los Angeles 37 El Camino Village 183   -118.334992 33.888441
271 271 2020-10-30 Los Angeles 37 El Monte 4932   -118.029074 34.073948
272 272 2020-10-30 Los Angeles 37 El Segundo 148   -118.402004 33.916898
273 273 2020-10-30 Los Angeles 37 El Sereno 1451   -118.177515 34.081112
274 274 2020-10-30 Los Angeles 37 Elizabeth Lake 9   -118.386954 34.674457
275 275 2020-10-30 Los Angeles 37 Elysian Park 112   -118.240334 34.078256
276 276 2020-10-30 Los Angeles 37 Elysian Valley 307   -118.237642 34.092694
277 277 2020-10-30 Los Angeles 37 Encino 803   -118.501697 34.155925
278 278 2020-10-30 Los Angeles 37 Exposition 80   -118.349778 34.026624
279 279 2020-10-30 Los Angeles 37 Exposition Park 1512   -118.297919 34.018599
280 280 2020-10-30 Los Angeles 37 Faircrest Heights 42   -118.371706 34.038691
281 281 2020-10-30 Los Angeles 37 Figueroa Park Square 357   -118.286739 33.93256
282 282 2020-10-30 Los Angeles 37 Florence-Firestone 2560   -118.267376 33.974897
283 283 2020-10-30 Los Angeles 37 Gardena 1354   -118.307231 33.894352
284 284 2020-10-30 Los Angeles 37 Glassell Park 791   -118.231508 34.118242
285 285 2020-10-30 Los Angeles 37 Glendale 4617   -118.246803 34.181933
286 286 2020-10-30 Los Angeles 37 Glendora 1345   -117.846736 34.144935
287 287 2020-10-30 Los Angeles 37 Gramercy Place 278   -118.309409 33.951267
288 288 2020-10-30 Los Angeles 37 Granada Hills 1456   -118.504152 34.291056
289 289 2020-10-30 Los Angeles 37 Green Meadows 1022   -118.263144 33.950734
290 290 2020-10-30 Los Angeles 37 Hacienda Heights 1189   -117.978311 34.000107
291 291 2020-10-30 Los Angeles 37 Hancock Park 269   -118.32887 34.069715

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT
);
Powered by Datasette · Query took 1598.772ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals