la_times_cdph_skilled_nursing_facilities

⚠️ 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: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_skilled_nursing_facilities

67,543 rows sorted by date descending

View and edit SQL

Link rowid date ▲ id name county fips staff_active_cases patients_active_cases staff_confirmed_cases patients_confirmed_cases staff_confirmed_cases_note patients_confirmed_cases_note staff_deaths patients_deaths staff_deaths_note patients_deaths_note
4893 2020-06-28 140000321 ALAMEDA COUNTY MEDICAL CENTER D/P SNF Alameda 1 0 0 0 1   10 or fewer 0 0    
4894 2020-06-28 20000043 ALAMEDA HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4895 2020-06-28 630011864 ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
4896 2020-06-28 140000686 ALAMEDA HOSPITAL D/P SNF Alameda 1 0 0 0 0     0 0    
4897 2020-06-28 630013891 ALL SAINT'S MAUBERT Alameda 1 0 0 0 0     0 0    
4898 2020-06-28 20000070 ALL SAINTS SUBACUTE & TRANSITIONAL CARE Alameda 1 0 0 1 0 10 or fewer   0 0    
4899 2020-06-28 20000010 ASHBY CARE CENTER Alameda 1 0 0 0 0     0 0    
4900 2020-06-28 20000015 BANCROFT HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4901 2020-06-28 20000135 BAY AREA HEALTHCARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
4902 2020-06-28 20000026 BAY VIEW REHABILITATION HOSPITAL, LLC Alameda 1 0 0 1 0 10 or fewer   0 0    
4903 2020-06-28 20000060 BAYPOINT HEALTHCARE CENTER Alameda 1 0 0 0 0     0 0    
4904 2020-06-28 630011713 BAYWOOD COURT HEALTH CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4905 2020-06-28 20001250 BELLAKEN SKILLED NURSING CENTER Alameda 1 0 0 0 0     0 0    
4906 2020-06-28 20000028 BERKELEY PINES SKILLED NURSING CENTER Alameda 1 0 0 0 0     0 0    
4907 2020-06-28 20000029 BETHESDA HOME Alameda 1 0 0 0 0     0 0    
4908 2020-06-28 20000048 CHAPARRAL HOUSE Alameda 1 0 0 0 1   10 or fewer 0 0    
4909 2020-06-28 630015174 CREEKVIEW SKILLED NURSING Alameda 1 0 1 1 1 10 or fewer 10 or fewer 0 0    
4910 2020-06-28 20000053 CRESTWOOD MANOR - FREMONT Alameda 1 0 0 1 0 10 or fewer   0 0    
4911 2020-06-28 20000129 CRESTWOOD TREATMENT CENTER Alameda 1 0 0 0 0     0 0    
4912 2020-06-28 20000087 CROWN BAY NURSING & REHABILITATION CENTER Alameda 1 0 0 0 0     0 0    
4913 2020-06-28 20000133 DRIFTWOOD HEALTHCARE CENTER - HAYWARD Alameda 1 0 13 11 30     0 1   10 or fewer
4914 2020-06-28 20000116 EAST BAY POST-ACUTE Alameda 1 0 0 24 33     0 16    
4915 2020-06-28 20000128 ELMWOOD CARE CENTER Alameda 1 0 0 0 1   10 or fewer 0 1   10 or fewer
4916 2020-06-28 20000093 EXCELL HEALTH CARE CENTER Alameda 1 0 1 23 43     0 1   10 or fewer
4917 2020-06-28 20000132 FREMONT HEALTHCARE CENTER Alameda 1 0 0 1 37 10 or fewer   0 1   10 or fewer
4918 2020-06-28 20000124 FRUITVALE HEALTHCARE CENTER Alameda 1 0 0 0 0     0 0    
4919 2020-06-28 20000125 GARFIELD NEUROBEHAVIORAL CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4920 2020-06-28 20000037 GATEWAY CARE & REHABILITATION CENTER Alameda 1 0 0 31 48     0 19    
4921 2020-06-28 20000123 HAYWARD CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
4922 2020-06-28 20000039 HAYWARD HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   1 0 10 or fewer  
4923 2020-06-28 20000047 HAYWARD HILLS HEALTH CARE CENTER Alameda 1 0 0 0 0     0 0    
4924 2020-06-28 20000101 HILLSIDE SENIOR CARE Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
4925 2020-06-28 20000111 JONES CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
4926 2020-06-28 20000042 KAISER PERMANENTE POST-ACUTE CARE CENTER Alameda 1 0 1 1 11 10 or fewer   0 0    
4927 2020-06-28 20000112 KYAKAMEENA CARE CENTER Alameda 1 0 0 0 0     0 0    
4928 2020-06-28 20000110 LAKE MERRITT HEALTHCARE CENTER LLC Alameda 1 0 0 1 0 10 or fewer   0 0    
4929 2020-06-28 20000114 LAKE PARK RETIREMENT RESIDENCE Alameda 1 0 0 0 0     0 0    
4930 2020-06-28 20000104 MARINA GARDEN NURSING CENTER Alameda 1 0 0 0 0     0 0    
4931 2020-06-28 20000040 MASONIC HOME Alameda 1 0 0 1 0 10 or fewer   0 0    
4932 2020-06-28 20000099 MCCLURE POST ACUTE Alameda 1 0 0 0 0     0 0    
4933 2020-06-28 20000079 MEDICAL HILL HEALTHCARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4934 2020-06-28 20000100 MERCY RETIREMENT & CARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
4935 2020-06-28 630014957 MOCHO PARK CARE CENTER Alameda 1 0 0 0 0     0 0    
4936 2020-06-28 20000808 MORTON BAKAR CENTER Alameda 1 0 0 0 0     0 0    
4937 2020-06-28 20000115 OAKLAND HEALTHCARE & WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4938 2020-06-28 20000880 OAKLAND HEIGHTS NURSING AND REHABILITATION Alameda 1 0 0 0 0     0 0    
4939 2020-06-28 630014635 PARK BRIDGE REHABILITATION AND WELLNESS CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4940 2020-06-28 20000094 PARK CENTRAL CARE AND REHABILITATION CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4941 2020-06-28 20000090 PARKVIEW HEALTHCARE CENTER Alameda 1 0 0 19 39     0 1   10 or fewer
4942 2020-06-28 20000091 PIEDMONT GARDENS HEALTH FACILITY Alameda 1 0 0 0 0     0 0    
4943 2020-06-28 140000086 PLEASANTON NURSING AND REHABILITATION CENTER Alameda 1 0 0 0 0     0 0    
4944 2020-06-28 20000054 PRINCETON MANOR HEALTHCARE CENTER, LLC Alameda 1 0 0 0 0     0 0    
4945 2020-06-28 20000276 REDWOOD CONVALESCENT HOSPITAL, INC. Alameda 1 0 1 1 16 10 or fewer   0 0    
4946 2020-06-28 20000119 REDWOOD HEALTHCARE CENTER LLC Alameda 1 0 0 15 29     0 1   10 or fewer
4947 2020-06-28 20000077 SAN LEANDRO HEALTHCARE CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 1   10 or fewer
4948 2020-06-28 140001291 SILVER OAK MANOR Alameda 1 0 0 0 0     0 0    
4949 2020-06-28 20000005 ST ANTHONY CARE CENTER Alameda 1 0 0 0 0     0 0    
4950 2020-06-28 20000074 ST CHRISTOPHER CONVALESCENT HOSPITAL Alameda 1 0 0 0 0     0 0    
4951 2020-06-28 20000076 ST FRANCIS HEALTHCARE CENTER Alameda 1 0 0 0 0     0 0    
4952 2020-06-28 20000068 ST JOHN KRONSTADT CONVALESCENT CENTER Alameda 1 0 0 0 0     0 0    
4953 2020-06-28 20000064 ST PAULS TOWERS Alameda 1 0 0 0 0     0 0    
4954 2020-06-28 20000274 THE REHABILITATION CENTER OF OAKLAND Alameda 1 0 0 0 1   10 or fewer 0 0    
4955 2020-06-28 140000122 THE VINEYARDS HEALTHCARE CENTER Alameda 1 0 1 1 0 10 or fewer   0 0    
4956 2020-06-28 140000626 VALLEY MEMORIAL HOSPITAL D/P SNF Alameda 1 0 0 0 0     0 0    
4957 2020-06-28 20000066 VALLEY POINTE NURSING & REHABILITATION CENTER Alameda 1 0 0 1 1 10 or fewer 10 or fewer 0 0    
4958 2020-06-28 20000019 VISTA POST ACUTE Alameda 1 0 1 19 48     0 1   10 or fewer
4959 2020-06-28 20000275 WASHINGTON CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4960 2020-06-28 20000065 WE CARE SKILLED NURSING FACILITY Alameda 1 0 0 1 0 10 or fewer   0 0    
4961 2020-06-28 20000020 WINDSOR COUNTRY DRIVE CARE CENTER Alameda 1 0 0 1 0 10 or fewer   0 0    
4962 2020-06-28 20000103 WINDSOR GARDENS CARE CENTER OF HAYWARD Alameda 1 0 0 1 0 10 or fewer   0 0    
4963 2020-06-28 20000277 WINDSOR HEALTHCARE CENTER OF OAKLAND Alameda 1 0 0 1 0 10 or fewer   0 0    
4964 2020-06-28 20000036 WINDSOR PARK CARE CENTER OF FREMONT Alameda 1 0 0 0 1   10 or fewer 0 0    
4965 2020-06-28 20000071 WINDSOR POST-ACUTE CARE CENTER OF HAYWARD Alameda 1 0 0 19 25     0 1   10 or fewer
4966 2020-06-28 30000074 KIT CARSON NURSING & REHABILITATION CENTER Amador 5 0 0 0 0     0 0    
4967 2020-06-28 230000255 ARBOR POST ACUTE Butte 7 0 0 0 0     0 0    
4968 2020-06-28 230000546 CALIFORNIA PARK REHABILITATION HOSPITAL Butte 7 0 0 0 0     0 0    
4969 2020-06-28 230000802 COUNTRY CREST POST ACUTE Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
4970 2020-06-28 230000327 ORCHARD HOSPITAL D/P SNF Butte 7 0 0 0 0     0 0    
4971 2020-06-28 230000221 OROVILLE HOSPITAL POST-ACUTE CENTER Butte 7 0 0 1 0 10 or fewer   0 0    
4972 2020-06-28 230000036 RIVERSIDE CONVALESCENT HOSPITAL Butte 7 0 0 1 1 10 or fewer 10 or fewer 0 0    
4973 2020-06-28 230000037 SHADOWBROOK POST ACUTE Butte 7 0 0 0 0     0 0    
4974 2020-06-28 230000025 WINDSOR CHICO CARE CENTER Butte 7 0 0 0 0     0 0    
4975 2020-06-28 230000029 WINDSOR CHICO CREEK CARE AND REHABILITATION CENTER Butte 7 0 0 0 0     0 0    
4976 2020-06-28 30000012 AVALON HEALTH CARE - SAN ANDREAS Calaveras 9 0 0 0 0     0 0    
4977 2020-06-28 230000424 COLUSA MEDICAL CENTER - SNF Colusa 11 0 0 0 0     0 0    
4978 2020-06-28 230000283 VALLEY WEST POST ACUTE Colusa 11 0 0 0 0     0 0    
4979 2020-06-28 140000574 ALHAMBRA CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
4980 2020-06-28 140000003 ANTIOCH CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
4981 2020-06-28 140000023 BAYBERRY SKILLED NURSING & HEALTHCARE CENTER Contra Costa 13 0 0 1 0 10 or fewer   0 0    
4982 2020-06-28 140000138 CREEKSIDE HEALTHCARE CENTER Contra Costa 13 0 0 0 0     0 0    
4983 2020-06-28 140000130 DANVILLE POST-ACUTE REHAB Contra Costa 13 0 0 0 0     0 0    
4984 2020-06-28 140000564 DIAMOND RIDGE HEALTHCARE CENTER Contra Costa 13 0 1 0 1   10 or fewer 0 0    
4985 2020-06-28 140000038 GREENRIDGE SENIOR CARE Contra Costa 13 0 0 0 0     0 0    
4986 2020-06-28 140000051 LA CASA VIA TRANSITIONAL CARE CENTER Contra Costa 13 0 0 0 0     0 0    
4987 2020-06-28 140000102 LEGACY NURSING AND REHABILITATION CENTER Contra Costa 13 0 0 1 0 10 or fewer   0 0    
4988 2020-06-28 140000105 LONE TREE CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
4989 2020-06-28 140001126 MANOR CARE HEALTH SERVICES-TICE VALLEY Contra Costa 13 0 33 16 55     0 1   10 or fewer
4990 2020-06-28 140000745 MANORCARE HEALTH SERVICES - ROSSMOOR Contra Costa 13 0 0 0 0     0 0    
4991 2020-06-28 140000106 MARTINEZ CONVALESCENT HOSPITAL Contra Costa 13 0 0 0 0     0 0    
4992 2020-06-28 140000081 MORAGA POST ACUTE Contra Costa 13 0 0 1 1 10 or fewer 10 or fewer 0 0    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_cdph_skilled_nursing_facilities] (
   [date] TEXT,
   [id] INTEGER,
   [name] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [staff_active_cases] INTEGER,
   [patients_active_cases] INTEGER,
   [staff_confirmed_cases] INTEGER,
   [patients_confirmed_cases] INTEGER,
   [staff_confirmed_cases_note] TEXT,
   [patients_confirmed_cases_note] TEXT,
   [staff_deaths] INTEGER,
   [patients_deaths] INTEGER,
   [staff_deaths_note] TEXT,
   [patients_deaths_note] TEXT
);
Powered by Datasette · Query took 22.819ms · Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_skilled_nursing_facilities