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

8,439 rows where county = "Orange" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

  • 59 8,439

county

  • Orange · 8,439
Link rowid date ▲ county fips place confirmed_cases note x y
587 2020-10-27 Orange 59 Aliso Viejo 424   -117.726298 33.56846
588 2020-10-27 Orange 59 Anaheim 10091   -117.889722 33.836111
589 2020-10-27 Orange 59 Brea 557   -117.900292 33.916475
590 2020-10-27 Orange 59 Buena Park 1692   -117.998139 33.867404
591 2020-10-27 Orange 59 Costa Mesa 2009   -117.904743 33.663844
592 2020-10-27 Orange 59 Coto de Caza 52   -117.587778 33.595833
593 2020-10-27 Orange 59 Cypress 604   -118.036851 33.816937
594 2020-10-27 Orange 59 Dana Point 310   -117.698912 33.467458
595 2020-10-27 Orange 59 Fountain Valley 565   -117.956243 33.720285
596 2020-10-27 Orange 59 Fullerton 2829   -117.925205 33.871972
597 2020-10-27 Orange 59 Garden Grove 3231   -117.940639 33.77322
598 2020-10-27 Orange 59 Huntington Beach 2581   -118.000278 33.692778
599 2020-10-27 Orange 59 Irvine 1865   -117.8436 33.686502
600 2020-10-27 Orange 59 La Habra 1613   -117.965359 33.926246
601 2020-10-27 Orange 59 La Palma 171   -118.046139 33.846322
602 2020-10-27 Orange 59 Ladera Ranch 186   -117.654344 33.550805
603 2020-10-27 Orange 59 Laguna Beach 248   -117.785357 33.542719
604 2020-10-27 Orange 59 Laguna Hills 346   -117.69866 33.591643
605 2020-10-27 Orange 59 Laguna Niguel 498   -117.74145 33.529249
606 2020-10-27 Orange 59 Laguna Woods 70   -117.725116 33.61017
607 2020-10-27 Orange 59 Lake Forest 913   -117.708689 33.656746
608 2020-10-27 Orange 59 Los Alamitos 227   -118.071889 33.803201
609 2020-10-27 Orange 59 Midway City 132   -117.987 33.7447
610 2020-10-27 Orange 59 Mission Viejo 951   -117.730609 33.602
611 2020-10-27 Orange 59 Newport Beach 1228   -117.940778 33.61799
612 2020-10-27 Orange 59 Orange 2741   -117.887465 33.807614
613 2020-10-27 Orange 59 Placentia 1036   -117.885835 33.881894
614 2020-10-27 Orange 59 Rancho Mission Viejo 77   -117.61 33.6
615 2020-10-27 Orange 59 Rancho Santa Margarita 387   -117.630248 33.627933
616 2020-10-27 Orange 59 Rossmoor 71   -118.079722 33.788889
617 2020-10-27 Orange 59 San Clemente 601   -117.620278 33.437778
618 2020-10-27 Orange 59 San Juan Capistrano 634   -117.683894 33.506334
619 2020-10-27 Orange 59 Santa Ana 11392   -117.881389 33.740833
620 2020-10-27 Orange 59 Seal Beach 298   -118.0825 33.759167
621 2020-10-27 Orange 59 Silverado 43   -117.63611 33.74611
622 2020-10-27 Orange 59 Stanton 719   -118.010462 33.79474
623 2020-10-27 Orange 59 Trabuco Canyon 218   -117.586986 33.665508
624 2020-10-27 Orange 59 Tustin 1437   -117.836714 33.733512
625 2020-10-27 Orange 59 Villa Park 62   -117.822072 33.814006
626 2020-10-27 Orange 59 Westminster 1150   -118.029078 33.746996
627 2020-10-27 Orange 59 Yorba Linda 829   -117.834681 33.890894
1549 2020-10-26 Orange 59 Aliso Viejo 420   -117.726298 33.56846
1550 2020-10-26 Orange 59 Anaheim 10043   -117.889722 33.836111
1551 2020-10-26 Orange 59 Brea 555   -117.900292 33.916475
1552 2020-10-26 Orange 59 Buena Park 1681   -117.998139 33.867404
1553 2020-10-26 Orange 59 Costa Mesa 2000   -117.904743 33.663844
1554 2020-10-26 Orange 59 Coto de Caza 52   -117.587778 33.595833
1555 2020-10-26 Orange 59 Cypress 598   -118.036851 33.816937
1556 2020-10-26 Orange 59 Dana Point 309   -117.698912 33.467458
1557 2020-10-26 Orange 59 Fountain Valley 560   -117.956243 33.720285
1558 2020-10-26 Orange 59 Fullerton 2811   -117.925205 33.871972
1559 2020-10-26 Orange 59 Garden Grove 3223   -117.940639 33.77322
1560 2020-10-26 Orange 59 Huntington Beach 2572   -118.000278 33.692778
1561 2020-10-26 Orange 59 Irvine 1861   -117.8436 33.686502
1562 2020-10-26 Orange 59 La Habra 1603   -117.965359 33.926246
1563 2020-10-26 Orange 59 La Palma 170   -118.046139 33.846322
1564 2020-10-26 Orange 59 Ladera Ranch 186   -117.654344 33.550805
1565 2020-10-26 Orange 59 Laguna Beach 247   -117.785357 33.542719
1566 2020-10-26 Orange 59 Laguna Hills 345   -117.69866 33.591643
1567 2020-10-26 Orange 59 Laguna Niguel 495   -117.74145 33.529249
1568 2020-10-26 Orange 59 Laguna Woods 70   -117.725116 33.61017
1569 2020-10-26 Orange 59 Lake Forest 911   -117.708689 33.656746
1570 2020-10-26 Orange 59 Los Alamitos 223   -118.071889 33.803201
1571 2020-10-26 Orange 59 Midway City 132   -117.987 33.7447
1572 2020-10-26 Orange 59 Mission Viejo 949   -117.730609 33.602
1573 2020-10-26 Orange 59 Newport Beach 1221   -117.940778 33.61799
1574 2020-10-26 Orange 59 Orange 2733   -117.887465 33.807614
1575 2020-10-26 Orange 59 Placentia 1029   -117.885835 33.881894
1576 2020-10-26 Orange 59 Rancho Mission Viejo 76   -117.61 33.6
1577 2020-10-26 Orange 59 Rancho Santa Margarita 388   -117.630248 33.627933
1578 2020-10-26 Orange 59 Rossmoor 70   -118.079722 33.788889
1579 2020-10-26 Orange 59 San Clemente 598   -117.620278 33.437778
1580 2020-10-26 Orange 59 San Juan Capistrano 633   -117.683894 33.506334
1581 2020-10-26 Orange 59 Santa Ana 11340   -117.881389 33.740833
1582 2020-10-26 Orange 59 Seal Beach 298   -118.0825 33.759167
1583 2020-10-26 Orange 59 Silverado 43   -117.63611 33.74611
1584 2020-10-26 Orange 59 Stanton 715   -118.010462 33.79474
1585 2020-10-26 Orange 59 Trabuco Canyon 217   -117.586986 33.665508
1586 2020-10-26 Orange 59 Tustin 1435   -117.836714 33.733512
1587 2020-10-26 Orange 59 Villa Park 62   -117.822072 33.814006
1588 2020-10-26 Orange 59 Westminster 1145   -118.029078 33.746996
1589 2020-10-26 Orange 59 Yorba Linda 829   -117.834681 33.890894
2387 2020-10-25 Orange 59 Aliso Viejo 421   -117.726298 33.56846
2388 2020-10-25 Orange 59 Anaheim 10017   -117.889722 33.836111
2389 2020-10-25 Orange 59 Brea 552   -117.900292 33.916475
2390 2020-10-25 Orange 59 Buena Park 1676   -117.998139 33.867404
2391 2020-10-25 Orange 59 Costa Mesa 1993   -117.904743 33.663844
2392 2020-10-25 Orange 59 Coto de Caza 52   -117.587778 33.595833
2393 2020-10-25 Orange 59 Cypress 598   -118.036851 33.816937
2394 2020-10-25 Orange 59 Dana Point 308   -117.698912 33.467458
2395 2020-10-25 Orange 59 Fountain Valley 560   -117.956243 33.720285
2396 2020-10-25 Orange 59 Fullerton 2799   -117.925205 33.871972
2397 2020-10-25 Orange 59 Garden Grove 3214   -117.940639 33.77322
2398 2020-10-25 Orange 59 Huntington Beach 2569   -118.000278 33.692778
2399 2020-10-25 Orange 59 Irvine 1860   -117.8436 33.686502
2400 2020-10-25 Orange 59 La Habra 1591   -117.965359 33.926246
2401 2020-10-25 Orange 59 La Palma 169   -118.046139 33.846322
2402 2020-10-25 Orange 59 Ladera Ranch 186   -117.654344 33.550805
2403 2020-10-25 Orange 59 Laguna Beach 246   -117.785357 33.542719
2404 2020-10-25 Orange 59 Laguna Hills 344   -117.69866 33.591643

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 1031.269ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals