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

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

Suggested facets: note, date (date)

fips

  • 59 · 8,275 ✖

county

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