cdph-skilled-nursing-facilities
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- id
- The facility's unique identifier with the state.
- name
- The name of the skilled-nursing facility.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- staff_confirmed_cases
- The current number of confirmed coronavirus case amoung staff at that time.
- patients_confirmed_cases
- The current number of confirmed coronavirus case amoung patients at that time.
- staff_confirmed_cases_note
- In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
- patients_confirmed_cases_note
- In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
- staff_deaths
- The cumulative number of deaths case amoung staff at that time.
- patients_deaths
- The cumulative number of deaths case amoung patients at that time.
- staff_deaths_note
- In cases where the staff_deaths are obscured, this explains the range of possible values.
- patients_deaths_note
- In cases where the patients_deaths are obscured, this explains the range of possible values.
1,224 rows where "date" is on date 2020-05-04 sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▲ | date | id | slug | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
760719 | 760719 | 2020-05-04 | 230000278 | 230000278-marysville-post-acute | MARYSVILLE POST-ACUTE | Yuba | 0 | 0 | 0 | 0 | 115 | ||||
760718 | 760718 | 2020-05-04 | 30001812 | 030001812-woodland-skilled-nursing-facility | WOODLAND SKILLED NURSING FACILITY | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
760717 | 760717 | 2020-05-04 | 100001676 | 100001676-university-retirement-community-at-davis | UNIVERSITY RETIREMENT COMMUNITY AT DAVIS | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
760716 | 760716 | 2020-05-04 | 100000100 | 100000100-stollwood-convalescent-hospital | STOLLWOOD CONVALESCENT HOSPITAL | Yolo | 13 | 32 | 1 | 13 | 113 | <11 | |||
760715 | 760715 | 2020-05-04 | 100000027 | 100000027-river-bend-nursing-center | RIVER BEND NURSING CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
760714 | 760714 | 2020-05-04 | 30001815 | 030001815-courtyard-health-care-center | COURTYARD HEALTH CARE CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
760713 | 760713 | 2020-05-04 | 30001817 | 030001817-cottonwood-health-care-center | COTTONWOOD HEALTH CARE CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
760712 | 760712 | 2020-05-04 | 100000030 | 100000030-alderson-convalescent-hospital | ALDERSON CONVALESCENT HOSPITAL | Yolo | 1 | 0 | 0 | 0 | 113 | <11 | |||
760711 | 760711 | 2020-05-04 | 50001409 | 050001409-windsor-terrace-of-westlake-village | WINDSOR TERRACE OF WESTLAKE VILLAGE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760710 | 760710 | 2020-05-04 | 50000595 | 050000595-victoria-care-center | VICTORIA CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760709 | 760709 | 2020-05-04 | 50000072 | 050000072-ventura-post-acute | VENTURA POST ACUTE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760708 | 760708 | 2020-05-04 | 50000067 | 050000067-thousand-oaks-post-acute-llc | THOUSAND OAKS POST ACUTE, LLC | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760707 | 760707 | 2020-05-04 | 50000248 | 050000248-st-johns-pleasant-valley-hospital-d-p-snf | ST JOHNS PLEASANT VALLEY HOSPITAL D/P SNF | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760706 | 760706 | 2020-05-04 | 50000070 | 050000070-simi-valley-care-center | SIMI VALLEY CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760705 | 760705 | 2020-05-04 | 50000002 | 050000002-shoreline-care-center | SHORELINE CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760704 | 760704 | 2020-05-04 | 50000068 | 050000068-santa-paula-post-acute-center | SANTA PAULA POST ACUTE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760703 | 760703 | 2020-05-04 | 50000058 | 050000058-oxnard-manor-healthcare-center | OXNARD MANOR HEALTHCARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760702 | 760702 | 2020-05-04 | 50000141 | 050000141-ojai-valley-community-skilled-nursing-facility | OJAI VALLEY COMMUNITY SKILLED NURSING FACILITY | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760701 | 760701 | 2020-05-04 | 50000043 | 050000043-ojai-health-rehabilitation | OJAI HEALTH & REHABILITATION | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760700 | 760700 | 2020-05-04 | 630011658 | 630011658-oakview-skilled-nursing | OAKVIEW SKILLED NURSING | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
760699 | 760699 | 2020-05-04 | 50000056 | 050000056-maywood-acres-healthcare | MAYWOOD ACRES HEALTHCARE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760698 | 760698 | 2020-05-04 | 50000055 | 050000055-mary-health-of-the-sick-convalescent-nursing-hospital | MARY HEALTH OF THE SICK CONVALESCENT & NURSING HOSPITAL | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
760697 | 760697 | 2020-05-04 | 50000049 | 050000049-greenfield-care-center-of-fillmore-llc | GREENFIELD CARE CENTER OF FILLMORE, LLC | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760696 | 760696 | 2020-05-04 | 50000050 | 050000050-glenwood-care-center | GLENWOOD CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760695 | 760695 | 2020-05-04 | 50000066 | 050000066-coastal-view-healthcare-center | COASTAL VIEW HEALTHCARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760694 | 760694 | 2020-05-04 | 50000006 | 050000006-camarillo-healthcare-center | CAMARILLO HEALTHCARE CENTER | Ventura | 0 | 1 | 0 | 0 | 111 | <11 | |||
760693 | 760693 | 2020-05-04 | 50001383 | 050001383-brookdale-camarillo | BROOKDALE CAMARILLO | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
760692 | 760692 | 2020-05-04 | 30001615 | 030001615-avalon-care-center-sonora | AVALON CARE CENTER - SONORA | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
760691 | 760691 | 2020-05-04 | 630014616 | 630014616-adventist-health-sonora-d-p-snf-unit-7 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 7) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
760690 | 760690 | 2020-05-04 | 30000023 | 030000023-adventist-health-sonora-d-p-snf-unit-6 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 6) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
760689 | 760689 | 2020-05-04 | 120001431 | 120001431-westgate-gardens-care-center | WESTGATE GARDENS CARE CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760688 | 760688 | 2020-05-04 | 630012057 | 630012057-twin-oaks-rehabilitation-nursing-center | TWIN OAKS REHABILITATION & NURSING CENTER | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
760687 | 760687 | 2020-05-04 | 120001408 | 120001408-tulare-nursing-rehabilitation-center | TULARE NURSING & REHABILITATION CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760686 | 760686 | 2020-05-04 | 120001466 | 120001466-sierra-view-medical-center | SIERRA VIEW MEDICAL CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760685 | 760685 | 2020-05-04 | 120001442 | 120001442-sierra-valley-rehabilitation-center | SIERRA VALLEY REHABILITATION CENTER | Tulare | 1 | 13 | 0 | 0 | 107 | <11 | |||
760684 | 760684 | 2020-05-04 | 120001474 | 120001474-sequoia-transitional-care | SEQUOIA TRANSITIONAL CARE | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760683 | 760683 | 2020-05-04 | 120001469 | 120001469-redwood-springs-healthcare-center | REDWOOD SPRINGS HEALTHCARE CENTER | Tulare | 56 | 114 | 0 | 28 | 107 | ||||
760682 | 760682 | 2020-05-04 | 170001876 | 170001876-porterville-developmental-center-d-p-snf | PORTERVILLE DEVELOPMENTAL CENTER D/P SNF | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760681 | 760681 | 2020-05-04 | 120001522 | 120001522-porterville-convalescent-hospital | PORTERVILLE CONVALESCENT HOSPITAL | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760680 | 760680 | 2020-05-04 | 120001462 | 120001462-merritt-manor-convalescent-hospital | MERRITT MANOR CONVALESCENT HOSPITAL | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
760679 | 760679 | 2020-05-04 | 120001477 | 120001477-linwood-meadows-care-center | LINWOOD MEADOWS CARE CENTER | Tulare | 1 | 11 | 0 | 0 | 107 | <11 | |||
760678 | 760678 | 2020-05-04 | 120001526 | 120001526-lindsay-gardens-nursing-rehabilitation | LINDSAY GARDENS NURSING & REHABILITATION | Tulare | 23 | 63 | 0 | 1 | 107 | <11 | |||
760677 | 760677 | 2020-05-04 | 120001472 | 120001472-kaweah-manor-convalescent-hospital | KAWEAH MANOR CONVALESCENT HOSPITAL | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760676 | 760676 | 2020-05-04 | 120001449 | 120001449-kaweah-delta-skilled-nursing-center | KAWEAH DELTA SKILLED NURSING CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760675 | 760675 | 2020-05-04 | 120001451 | 120001451-kaweah-delta-medical-center-d-p-snf | KAWEAH DELTA MEDICAL CENTER D/P SNF | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760674 | 760674 | 2020-05-04 | 120001421 | 120001421-gateway-post-acute | GATEWAY POST ACUTE | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
760673 | 760673 | 2020-05-04 | 120001440 | 120001440-dinuba-healthcare | DINUBA HEALTHCARE | Tulare | 1 | 18 | 0 | 0 | 107 | <11 | |||
760672 | 760672 | 2020-05-04 | 120001402 | 120001402-delta-nursing-rehabilitation-center | DELTA NURSING & REHABILITATION CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
760671 | 760671 | 2020-05-04 | 230000197 | 230000197-trinity-hospital-skilled-nursing-facility | TRINITY HOSPITAL SKILLED NURSING FACILITY | Trinity | 0 | 0 | 0 | 0 | 105 | ||||
760670 | 760670 | 2020-05-04 | 230000028 | 230000028-red-bluff-health-care-center | RED BLUFF HEALTH CARE CENTER | Tehama | 0 | 0 | 0 | 0 | 103 | ||||
760669 | 760669 | 2020-05-04 | 230000027 | 230000027-brentwood-post-acute | BRENTWOOD POST ACUTE | Tehama | 0 | 0 | 0 | 0 | 103 | ||||
760668 | 760668 | 2020-05-04 | 230000275 | 230000275-yuba-city-post-acute | YUBA CITY POST ACUTE | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
760667 | 760667 | 2020-05-04 | 230000370 | 230000370-the-fountains | THE FOUNTAINS | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
760666 | 760666 | 2020-05-04 | 230000460 | 230000460-river-valley-care-center | RIVER VALLEY CARE CENTER | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
760665 | 760665 | 2020-05-04 | 230000284 | 230000284-bridgeview-post-acute | BRIDGEVIEW POST ACUTE | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
760664 | 760664 | 2020-05-04 | 100000038 | 100000038-windsor-post-acute-healthcare-center-of-modesto | WINDSOR POST-ACUTE HEALTHCARE CENTER OF MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760663 | 760663 | 2020-05-04 | 100000851 | 100000851-vintage-faire-nursing-rehabilitation-center | VINTAGE FAIRE NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760662 | 760662 | 2020-05-04 | 30000288 | 030000288-turlock-nursing-and-rehabilitation-center | TURLOCK NURSING AND REHABILITATION CENTER | Stanislaus | 32 | 69 | 0 | 1 | 99 | <11 | |||
760661 | 760661 | 2020-05-04 | 30000096 | 030000096-san-luis-care-center | SAN LUIS CARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760660 | 760660 | 2020-05-04 | 30000079 | 030000079-oakdale-nursing-and-rehabilitation-center | OAKDALE NURSING AND REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760659 | 760659 | 2020-05-04 | 30000016 | 030000016-north-starr-postacute-care | NORTH STARR POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760658 | 760658 | 2020-05-04 | 100000107 | 100000107-modesto-post-acute-center | MODESTO POST ACUTE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760657 | 760657 | 2020-05-04 | 30000050 | 030000050-main-west-postacute-care | MAIN WEST POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760656 | 760656 | 2020-05-04 | 100000072 | 100000072-hy-lond-health-care-center-modesto | HY-LOND HEALTH CARE CENTER - MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760655 | 760655 | 2020-05-04 | 100000055 | 100000055-garden-city-healthcare-center | GARDEN CITY HEALTHCARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760654 | 760654 | 2020-05-04 | 100000051 | 100000051-english-oaks-convalescent-rehabilitation-hospital | ENGLISH OAKS CONVALESCENT & REHABILITATION HOSPITAL | Stanislaus | 0 | 1 | 0 | 1 | 99 | <11 | <11 | ||
760653 | 760653 | 2020-05-04 | 100000036 | 100000036-crestwood-manor | CRESTWOOD MANOR | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760652 | 760652 | 2020-05-04 | 30001657 | 030001657-covenant-village-of-turlock-care-center | COVENANT VILLAGE OF TURLOCK CARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760651 | 760651 | 2020-05-04 | 30000066 | 030000066-ceres-postacute-care | CERES POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760650 | 760650 | 2020-05-04 | 30001202 | 030001202-central-valley-specialty-hospital-skilled-nursing-facility | CENTRAL VALLEY SPECIALTY HOSPITAL - SKILLED NURSING FACILITY | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760649 | 760649 | 2020-05-04 | 100000026 | 100000026-central-valley-post-acute-modesto | CENTRAL VALLEY POST ACUTE - MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760648 | 760648 | 2020-05-04 | 30000088 | 030000088-central-valley-post-acute | CENTRAL VALLEY POST ACUTE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760647 | 760647 | 2020-05-04 | 100000031 | 100000031-casa-de-modesto | CASA DE MODESTO | Stanislaus | 1 | 0 | 0 | 0 | 99 | <11 | |||
760646 | 760646 | 2020-05-04 | 30000852 | 030000852-brandel-manor | BRANDEL MANOR | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760645 | 760645 | 2020-05-04 | 100000042 | 100000042-acacia-park-nursing-rehabilitation-center | ACACIA PARK NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
760644 | 760644 | 2020-05-04 | 10000005 | 010000005-windsor-care-center-of-petaluma | WINDSOR CARE CENTER OF PETALUMA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760643 | 760643 | 2020-05-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760642 | 760642 | 2020-05-04 | 110000233 | 110000233-valley-of-the-moon-post-acute | VALLEY OF THE MOON POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760641 | 760641 | 2020-05-04 | 10000076 | 010000076-summerfield-healthcare-center | SUMMERFIELD HEALTHCARE CENTER | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760640 | 760640 | 2020-05-04 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760639 | 760639 | 2020-05-04 | 10000059 | 010000059-sonoma-postacute-care | SONOMA POSTACUTE CARE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760638 | 760638 | 2020-05-04 | 10000034 | 010000034-sonoma-post-acute | SONOMA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760637 | 760637 | 2020-05-04 | 10000033 | 010000033-santa-rosa-post-acute | SANTA ROSA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760636 | 760636 | 2020-05-04 | 140001278 | 140001278-santa-rosa-memorial-hospital-d-p-snf | SANTA ROSA MEMORIAL HOSPITAL D/P SNF | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760635 | 760635 | 2020-05-04 | 10000052 | 010000052-petaluma-post-acute-rehab | PETALUMA POST-ACUTE REHAB | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760634 | 760634 | 2020-05-04 | 10000043 | 010000043-park-view-post-acute | PARK VIEW POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760633 | 760633 | 2020-05-04 | 10000079 | 010000079-hillcrest-post-acute | HILLCREST POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760632 | 760632 | 2020-05-04 | 10000029 | 010000029-healdsburg-senior-living-community | HEALDSBURG SENIOR LIVING COMMUNITY | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760631 | 760631 | 2020-05-04 | 110000702 | 110000702-healdsburg-district-hospital-d-p-snf | HEALDSBURG DISTRICT HOSPITAL D/P SNF | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760630 | 760630 | 2020-05-04 | 10000022 | 010000022-friends-house | FRIENDS HOUSE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760629 | 760629 | 2020-05-04 | 10000028 | 010000028-empres-post-acute-rehabilitation | EMPRES POST ACUTE REHABILITATION | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760628 | 760628 | 2020-05-04 | 10000003 | 010000003-creekside-rehabilitation-behavioral-health | CREEKSIDE REHABILITATION & BEHAVIORAL HEALTH | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760627 | 760627 | 2020-05-04 | 10000037 | 010000037-cloverdale-healthcare-center | CLOVERDALE HEALTHCARE CENTER | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760626 | 760626 | 2020-05-04 | 10000066 | 010000066-broadway-villa-post-acute | BROADWAY VILLA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760625 | 760625 | 2020-05-04 | 10001140 | 010001140-arbol-residences-of-santa-rosa | ARBOL RESIDENCES OF SANTA ROSA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
760624 | 760624 | 2020-05-04 | 10000026 | 010000026-apple-valley-post-acute-rehab | APPLE VALLEY POST-ACUTE REHAB | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
760623 | 760623 | 2020-05-04 | 110000013 | 110000013-windsor-vallejo-nursing-rehabilitation-center | WINDSOR VALLEJO NURSING & REHABILITATION CENTER | Solano | 22 | 78 | 0 | 1 | 95 | <11 | |||
760622 | 760622 | 2020-05-04 | 110000467 | 110000467-vacaville-convalescent-and-rehabilitation-center | VACAVILLE CONVALESCENT AND REHABILITATION CENTER | Solano | 0 | 0 | 0 | 0 | 95 | ||||
760621 | 760621 | 2020-05-04 | 110000074 | 110000074-springs-road-healthcare | SPRINGS ROAD HEALTHCARE | Solano | 0 | 0 | 0 | 0 | 95 | ||||
760620 | 760620 | 2020-05-04 | 110000084 | 110000084-orchard-post-acute-care | ORCHARD POST ACUTE CARE | Solano | 0 | 0 | 0 | 0 | 95 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-skilled-nursing-facilities" ( [date] TEXT, [id] INTEGER, [slug] 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 );