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 fips = 37 sorted by date descending

View and edit SQL

fips

  • 37 · 68,931

county

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