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,275 rows where fips = 59 sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

fips

  • 59 · 8,275

county

Link rowid date ▲ county fips place confirmed_cases note x y
547 2020-10-23 Orange 59 Aliso Viejo 415   -117.726298 33.56846
548 2020-10-23 Orange 59 Anaheim 9927   -117.889722 33.836111
549 2020-10-23 Orange 59 Brea 543   -117.900292 33.916475
550 2020-10-23 Orange 59 Buena Park 1657   -117.998139 33.867404
551 2020-10-23 Orange 59 Costa Mesa 1979   -117.904743 33.663844
552 2020-10-23 Orange 59 Coto de Caza 50   -117.587778 33.595833
553 2020-10-23 Orange 59 Cypress 592   -118.036851 33.816937
554 2020-10-23 Orange 59 Dana Point 306   -117.698912 33.467458
555 2020-10-23 Orange 59 Fountain Valley 555   -117.956243 33.720285
556 2020-10-23 Orange 59 Fullerton 2774   -117.925205 33.871972
557 2020-10-23 Orange 59 Garden Grove 3184   -117.940639 33.77322
558 2020-10-23 Orange 59 Huntington Beach 2544   -118.000278 33.692778
559 2020-10-23 Orange 59 Irvine 1829   -117.8436 33.686502
560 2020-10-23 Orange 59 La Habra 1568   -117.965359 33.926246
561 2020-10-23 Orange 59 La Palma 169   -118.046139 33.846322
562 2020-10-23 Orange 59 Ladera Ranch 185   -117.654344 33.550805
563 2020-10-23 Orange 59 Laguna Beach 242   -117.785357 33.542719
564 2020-10-23 Orange 59 Laguna Hills 338   -117.69866 33.591643
565 2020-10-23 Orange 59 Laguna Niguel 490   -117.74145 33.529249
566 2020-10-23 Orange 59 Laguna Woods 70   -117.725116 33.61017
567 2020-10-23 Orange 59 Lake Forest 897   -117.708689 33.656746
568 2020-10-23 Orange 59 Los Alamitos 222   -118.071889 33.803201
569 2020-10-23 Orange 59 Midway City 131   -117.987 33.7447
570 2020-10-23 Orange 59 Mission Viejo 934   -117.730609 33.602
571 2020-10-23 Orange 59 Newport Beach 1205   -117.940778 33.61799
572 2020-10-23 Orange 59 Orange 2699   -117.887465 33.807614
573 2020-10-23 Orange 59 Placentia 1015   -117.885835 33.881894
574 2020-10-23 Orange 59 Rancho Mission Viejo 76   -117.61 33.6
575 2020-10-23 Orange 59 Rancho Santa Margarita 380   -117.630248 33.627933
576 2020-10-23 Orange 59 Rossmoor 69   -118.079722 33.788889
577 2020-10-23 Orange 59 San Clemente 595   -117.620278 33.437778
578 2020-10-23 Orange 59 San Juan Capistrano 621   -117.683894 33.506334
579 2020-10-23 Orange 59 Santa Ana 11197   -117.881389 33.740833
580 2020-10-23 Orange 59 Seal Beach 296   -118.0825 33.759167
581 2020-10-23 Orange 59 Silverado 43   -117.63611 33.74611
582 2020-10-23 Orange 59 Stanton 705   -118.010462 33.79474
583 2020-10-23 Orange 59 Trabuco Canyon 216   -117.586986 33.665508
584 2020-10-23 Orange 59 Tustin 1417   -117.836714 33.733512
585 2020-10-23 Orange 59 Villa Park 60   -117.822072 33.814006
586 2020-10-23 Orange 59 Westminster 1131   -118.029078 33.746996
587 2020-10-23 Orange 59 Yorba Linda 815   -117.834681 33.890894
1552 2020-10-22 Orange 59 Aliso Viejo 413   -117.726298 33.56846
1553 2020-10-22 Orange 59 Anaheim 9898   -117.889722 33.836111
1554 2020-10-22 Orange 59 Brea 541   -117.900292 33.916475
1555 2020-10-22 Orange 59 Buena Park 1651   -117.998139 33.867404
1556 2020-10-22 Orange 59 Costa Mesa 1969   -117.904743 33.663844
1557 2020-10-22 Orange 59 Coto de Caza 50   -117.587778 33.595833
1558 2020-10-22 Orange 59 Cypress 588   -118.036851 33.816937
1559 2020-10-22 Orange 59 Dana Point 306   -117.698912 33.467458
1560 2020-10-22 Orange 59 Fountain Valley 554   -117.956243 33.720285
1561 2020-10-22 Orange 59 Fullerton 2764   -117.925205 33.871972
1562 2020-10-22 Orange 59 Garden Grove 3174   -117.940639 33.77322
1563 2020-10-22 Orange 59 Huntington Beach 2539   -118.000278 33.692778
1564 2020-10-22 Orange 59 Irvine 1822   -117.8436 33.686502
1565 2020-10-22 Orange 59 La Habra 1563   -117.965359 33.926246
1566 2020-10-22 Orange 59 La Palma 169   -118.046139 33.846322
1567 2020-10-22 Orange 59 Ladera Ranch 185   -117.654344 33.550805
1568 2020-10-22 Orange 59 Laguna Beach 242   -117.785357 33.542719
1569 2020-10-22 Orange 59 Laguna Hills 335   -117.69866 33.591643
1570 2020-10-22 Orange 59 Laguna Niguel 488   -117.74145 33.529249
1571 2020-10-22 Orange 59 Laguna Woods 70   -117.725116 33.61017
1572 2020-10-22 Orange 59 Lake Forest 896   -117.708689 33.656746
1573 2020-10-22 Orange 59 Los Alamitos 222   -118.071889 33.803201
1574 2020-10-22 Orange 59 Midway City 130   -117.987 33.7447
1575 2020-10-22 Orange 59 Mission Viejo 930   -117.730609 33.602
1576 2020-10-22 Orange 59 Newport Beach 1202   -117.940778 33.61799
1577 2020-10-22 Orange 59 Orange 2691   -117.887465 33.807614
1578 2020-10-22 Orange 59 Placentia 1011   -117.885835 33.881894
1579 2020-10-22 Orange 59 Rancho Mission Viejo 76   -117.61 33.6
1580 2020-10-22 Orange 59 Rancho Santa Margarita 377   -117.630248 33.627933
1581 2020-10-22 Orange 59 Rossmoor 69   -118.079722 33.788889
1582 2020-10-22 Orange 59 San Clemente 584   -117.620278 33.437778
1583 2020-10-22 Orange 59 San Juan Capistrano 615   -117.683894 33.506334
1584 2020-10-22 Orange 59 Santa Ana 11168   -117.881389 33.740833
1585 2020-10-22 Orange 59 Seal Beach 296   -118.0825 33.759167
1586 2020-10-22 Orange 59 Silverado 43   -117.63611 33.74611
1587 2020-10-22 Orange 59 Stanton 704   -118.010462 33.79474
1588 2020-10-22 Orange 59 Trabuco Canyon 216   -117.586986 33.665508
1589 2020-10-22 Orange 59 Tustin 1414   -117.836714 33.733512
1590 2020-10-22 Orange 59 Villa Park 60   -117.822072 33.814006
1591 2020-10-22 Orange 59 Westminster 1129   -118.029078 33.746996
1592 2020-10-22 Orange 59 Yorba Linda 813   -117.834681 33.890894
2522 2020-10-21 Orange 59 Aliso Viejo 413   -117.726298 33.56846
2523 2020-10-21 Orange 59 Anaheim 9869   -117.889722 33.836111
2524 2020-10-21 Orange 59 Brea 537   -117.900292 33.916475
2525 2020-10-21 Orange 59 Buena Park 1638   -117.998139 33.867404
2526 2020-10-21 Orange 59 Costa Mesa 1960   -117.904743 33.663844
2527 2020-10-21 Orange 59 Coto de Caza 47   -117.587778 33.595833
2528 2020-10-21 Orange 59 Cypress 585   -118.036851 33.816937
2529 2020-10-21 Orange 59 Dana Point 306   -117.698912 33.467458
2530 2020-10-21 Orange 59 Fountain Valley 549   -117.956243 33.720285
2531 2020-10-21 Orange 59 Fullerton 2753   -117.925205 33.871972
2532 2020-10-21 Orange 59 Garden Grove 3162   -117.940639 33.77322
2533 2020-10-21 Orange 59 Huntington Beach 2531   -118.000278 33.692778
2534 2020-10-21 Orange 59 Irvine 1814   -117.8436 33.686502
2535 2020-10-21 Orange 59 La Habra 1557   -117.965359 33.926246
2536 2020-10-21 Orange 59 La Palma 168   -118.046139 33.846322
2537 2020-10-21 Orange 59 Ladera Ranch 184   -117.654344 33.550805
2538 2020-10-21 Orange 59 Laguna Beach 242   -117.785357 33.542719
2539 2020-10-21 Orange 59 Laguna Hills 335   -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 924.696ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals