la_times_cdph_adult_and_senior_care_facilities
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_adult_and_senior_care_facilities
4,289 rows where county = "Sacramento" and patients_deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: patients_confirmed_cases_note, date (date)
Link | rowid | date ▲ | name | county | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | fips | staff_confirmed_cases_note | patients_confirmed_cases_note | staff_deaths_note | patients_deaths_note |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
590 | 590 | 2021-06-27 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
591 | 591 | 2021-06-27 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
593 | 593 | 2021-06-27 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
594 | 594 | 2021-06-27 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
596 | 596 | 2021-06-27 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
597 | 597 | 2021-06-27 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
598 | 598 | 2021-06-27 | Carlton Plaza Of Sacramento | Sacramento | 39 | 34 | 0 | 1 | 67 | <11 | |||
600 | 600 | 2021-06-27 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
601 | 601 | 2021-06-27 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
602 | 602 | 2021-06-27 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
603 | 603 | 2021-06-27 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
605 | 605 | 2021-06-27 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
607 | 607 | 2021-06-27 | Elk Grove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
609 | 609 | 2021-06-27 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
610 | 610 | 2021-06-27 | Eskaton Village | Sacramento | 33 | 21 | 1 | 1 | 67 | <11 | <11 | ||
611 | 611 | 2021-06-27 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
613 | 613 | 2021-06-27 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
614 | 614 | 2021-06-27 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
615 | 615 | 2021-06-27 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
616 | 616 | 2021-06-27 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
618 | 618 | 2021-06-27 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
620 | 620 | 2021-06-27 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
621 | 621 | 2021-06-27 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
622 | 622 | 2021-06-27 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
624 | 624 | 2021-06-27 | Prairie City Landing | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
625 | 625 | 2021-06-27 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
626 | 626 | 2021-06-27 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
627 | 627 | 2021-06-27 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
628 | 628 | 2021-06-27 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
629 | 629 | 2021-06-27 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
631 | 631 | 2021-06-27 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
632 | 632 | 2021-06-27 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
633 | 633 | 2021-06-27 | Walnut House | Sacramento | 1 | 37 | 0 | 1 | 67 | <11 | <11 | ||
1604 | 1604 | 2021-05-11 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
1605 | 1605 | 2021-05-11 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
1607 | 1607 | 2021-05-11 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
1608 | 1608 | 2021-05-11 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
1610 | 1610 | 2021-05-11 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
1611 | 1611 | 2021-05-11 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
1612 | 1612 | 2021-05-11 | Carlton Plaza Of Sacramento | Sacramento | 39 | 34 | 0 | 1 | 67 | <11 | |||
1614 | 1614 | 2021-05-11 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
1615 | 1615 | 2021-05-11 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
1616 | 1616 | 2021-05-11 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
1617 | 1617 | 2021-05-11 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
1619 | 1619 | 2021-05-11 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
1621 | 1621 | 2021-05-11 | Elk Grove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
1623 | 1623 | 2021-05-11 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
1624 | 1624 | 2021-05-11 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
1625 | 1625 | 2021-05-11 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
1627 | 1627 | 2021-05-11 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
1628 | 1628 | 2021-05-11 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
1629 | 1629 | 2021-05-11 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
1630 | 1630 | 2021-05-11 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
1632 | 1632 | 2021-05-11 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
1634 | 1634 | 2021-05-11 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
1635 | 1635 | 2021-05-11 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
1636 | 1636 | 2021-05-11 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
1638 | 1638 | 2021-05-11 | Prairie City Landing | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
1639 | 1639 | 2021-05-11 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
1640 | 1640 | 2021-05-11 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
1641 | 1641 | 2021-05-11 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
1642 | 1642 | 2021-05-11 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
1643 | 1643 | 2021-05-11 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
1645 | 1645 | 2021-05-11 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
1646 | 1646 | 2021-05-11 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
1647 | 1647 | 2021-05-11 | Walnut House | Sacramento | 1 | 37 | 0 | 1 | 67 | <11 | <11 | ||
2639 | 2639 | 2021-04-27 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 | ||
2640 | 2640 | 2021-04-27 | Almond Heights | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2642 | 2642 | 2021-04-27 | Atria Carmichael Oaks | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2643 | 2643 | 2021-04-27 | Atria El Camino Gardens | Sacramento | 27 | 32 | 0 | 1 | 67 | <11 | |||
2645 | 2645 | 2021-04-27 | Carlton Crown Plaza | Sacramento | 1 | 16 | 0 | 1 | 67 | <11 | <11 | ||
2646 | 2646 | 2021-04-27 | Carlton Plaza Of Elk Grove | Sacramento | 32 | 21 | 0 | 1 | 67 | <11 | |||
2647 | 2647 | 2021-04-27 | Carlton Plaza Of Sacramento | Sacramento | 37 | 34 | 0 | 1 | 67 | <11 | |||
2649 | 2649 | 2021-04-27 | Chalet, The | Sacramento | 1 | 17 | 1 | 1 | 67 | <11 | <11 | <11 | |
2650 | 2650 | 2021-04-27 | Chateau At River's Edge, The | Sacramento | 13 | 19 | 0 | 1 | 67 | <11 | |||
2651 | 2651 | 2021-04-27 | Citrus Heights Terrace | Sacramento | 13 | 30 | 0 | 1 | 67 | <11 | |||
2652 | 2652 | 2021-04-27 | City Creek Assisted Living | Sacramento | 15 | 43 | 0 | 1 | 67 | <11 | |||
2654 | 2654 | 2021-04-27 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
2656 | 2656 | 2021-04-27 | Elk Gove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
2658 | 2658 | 2021-04-27 | Eskaton Gold River Lodge | Sacramento | 18 | 25 | 0 | 1 | 67 | <11 | |||
2659 | 2659 | 2021-04-27 | Eskaton Village | Sacramento | 31 | 19 | 1 | 1 | 67 | <11 | <11 | ||
2660 | 2660 | 2021-04-27 | Fair Oaks Community At Sunset | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2662 | 2662 | 2021-04-27 | Fruitridge Villa | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2663 | 2663 | 2021-04-27 | Greenhaven Estates | Sacramento | 15 | 1 | 0 | 1 | 67 | <11 | <11 | ||
2664 | 2664 | 2021-04-27 | Greenhaven Place Independent Lvg And Assisted Lvg | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2665 | 2665 | 2021-04-27 | Lakewood Villa | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
2667 | 2667 | 2021-04-27 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
2669 | 2669 | 2021-04-27 | Oakmont Of Carmichael | Sacramento | 22 | 41 | 0 | 1 | 67 | <11 | |||
2670 | 2670 | 2021-04-27 | Oakmont Of Fair Oaks | Sacramento | 26 | 53 | 0 | 1 | 67 | <11 | |||
2671 | 2671 | 2021-04-27 | Oakmont Of Folsom | Sacramento | 13 | 34 | 0 | 1 | 67 | <11 | |||
2673 | 2673 | 2021-04-27 | Prairie City Landing | Sacramento | 1 | 14 | 0 | 1 | 67 | <11 | <11 | ||
2674 | 2674 | 2021-04-27 | Revere Court | Sacramento | 27 | 42 | 0 | 1 | 67 | <11 | |||
2675 | 2675 | 2021-04-27 | Sky Park Gardens | Sacramento | 34 | 30 | 0 | 1 | 67 | <11 | |||
2676 | 2676 | 2021-04-27 | Spiva Acres | Sacramento | 1 | 1 | 0 | 1 | 67 | <11 | <11 | <11 | |
2677 | 2677 | 2021-04-27 | Summerset Assisted Living | Sacramento | 1 | 24 | 0 | 1 | 67 | <11 | <11 | ||
2678 | 2678 | 2021-04-27 | Sun Oak Assisted Living | Sacramento | 17 | 22 | 0 | 1 | 67 | <11 | |||
2680 | 2680 | 2021-04-27 | Sunrise Assisted Living Of Fair Oaks | Sacramento | 14 | 18 | 0 | 1 | 67 | <11 | |||
2681 | 2681 | 2021-04-27 | Sunrise Assisted Living Of Sacramento | Sacramento | 25 | 25 | 0 | 1 | 67 | <11 | |||
2682 | 2682 | 2021-04-27 | Walnut House | Sacramento | 1 | 38 | 0 | 1 | 67 | <11 | <11 | ||
3688 | 3688 | 2021-04-21 | Almond Avenue Residence Club | Sacramento | 1 | 20 | 0 | 1 | 67 | <11 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_cdph_adult_and_senior_care_facilities] ( [date] TEXT, [name] TEXT, [county] TEXT, [staff_confirmed_cases] INTEGER, [patients_confirmed_cases] INTEGER, [staff_deaths] INTEGER, [patients_deaths] INTEGER, [fips] INTEGER, [staff_confirmed_cases_note] TEXT, [patients_confirmed_cases_note] TEXT, [staff_deaths_note] TEXT, [patients_deaths_note] TEXT );