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
46 rows where county = "Sacramento" and "date" is on date 2021-06-27 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_confirmed_cases_note, staff_deaths_note
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
589 | 589 | 2021-06-27 | Acc Maple Tree Village | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <11 | ||
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 | |
592 | 592 | 2021-06-27 | Apple Ridge Assisted Living | Sacramento | 1 | 16 | 0 | 0 | 67 | <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 | |||
595 | 595 | 2021-06-27 | Brookdale Citrus Heights | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <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 | |||
599 | 599 | 2021-06-27 | Carlton Senior Living Orangevale | Sacramento | 30 | 18 | 0 | 0 | 67 | ||||
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 | |||
604 | 604 | 2021-06-27 | Country Club Manor | Sacramento | 23 | 33 | 0 | 0 | 67 | ||||
605 | 605 | 2021-06-27 | Courte At Citrus Heights, The | Sacramento | 1 | 27 | 0 | 1 | 67 | <11 | <11 | ||
606 | 606 | 2021-06-27 | Ehimas Residential Care | Sacramento | 1 | 15 | 0 | 0 | 67 | <11 | |||
607 | 607 | 2021-06-27 | Elk Grove Park Asst. Lvg And Memory Care Community | Sacramento | 18 | 22 | 0 | 1 | 67 | <11 | |||
608 | 608 | 2021-06-27 | Empire Ranch Alzheimer's Special Care Center | Sacramento | 1 | 11 | 0 | 0 | 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 | |
612 | 612 | 2021-06-27 | Fair Oaks Estates Inc | Sacramento | 1 | 27 | 0 | 0 | 67 | <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 | ||
617 | 617 | 2021-06-27 | Meadows At Country Place, The | Sacramento | 17 | 24 | 0 | 11 | 67 | ||||
618 | 618 | 2021-06-27 | Meadows Senior Living, The | Sacramento | 12 | 20 | 0 | 1 | 67 | <11 | |||
619 | 619 | 2021-06-27 | Mercy Mcmahon Terrace | Sacramento | 1 | 1 | 0 | 0 | 67 | <11 | <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 | |||
623 | 623 | 2021-06-27 | Oars At Greenback Lane, The | Sacramento | 18 | 11 | 0 | 0 | 67 | ||||
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 | |||
630 | 630 | 2021-06-27 | Sunrise Assisted Living Of Carmichael | Sacramento | 15 | 14 | 0 | 0 | 67 | ||||
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 | ||
634 | 634 | 2021-06-27 | Waterleaf At Land Park, The | Sacramento | 20 | 47 | 0 | 18 | 67 |
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 );