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-09 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
754599 | 754599 | 2020-05-09 | 230000278 | 230000278-marysville-post-acute | MARYSVILLE POST-ACUTE | Yuba | 0 | 0 | 0 | 0 | 115 | ||||
754598 | 754598 | 2020-05-09 | 30001812 | 030001812-woodland-skilled-nursing-facility | WOODLAND SKILLED NURSING FACILITY | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
754597 | 754597 | 2020-05-09 | 100001676 | 100001676-university-retirement-community-at-davis | UNIVERSITY RETIREMENT COMMUNITY AT DAVIS | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
754596 | 754596 | 2020-05-09 | 100000100 | 100000100-stollwood-convalescent-hospital | STOLLWOOD CONVALESCENT HOSPITAL | Yolo | 13 | 32 | 1 | 14 | 113 | <11 | |||
754595 | 754595 | 2020-05-09 | 100000027 | 100000027-river-bend-nursing-center | RIVER BEND NURSING CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
754594 | 754594 | 2020-05-09 | 30001815 | 030001815-courtyard-health-care-center | COURTYARD HEALTH CARE CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
754593 | 754593 | 2020-05-09 | 30001817 | 030001817-cottonwood-health-care-center | COTTONWOOD HEALTH CARE CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
754592 | 754592 | 2020-05-09 | 100000030 | 100000030-alderson-convalescent-hospital | ALDERSON CONVALESCENT HOSPITAL | Yolo | 1 | 0 | 0 | 0 | 113 | <11 | |||
754591 | 754591 | 2020-05-09 | 50001409 | 050001409-windsor-terrace-of-westlake-village | WINDSOR TERRACE OF WESTLAKE VILLAGE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754590 | 754590 | 2020-05-09 | 50000595 | 050000595-victoria-care-center | VICTORIA CARE CENTER | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
754589 | 754589 | 2020-05-09 | 50000072 | 050000072-ventura-post-acute | VENTURA POST ACUTE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754588 | 754588 | 2020-05-09 | 50000067 | 050000067-thousand-oaks-post-acute-llc | THOUSAND OAKS POST ACUTE, LLC | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754587 | 754587 | 2020-05-09 | 50000248 | 050000248-st-johns-pleasant-valley-hospital-d-p-snf | ST JOHNS PLEASANT VALLEY HOSPITAL D/P SNF | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754586 | 754586 | 2020-05-09 | 50000070 | 050000070-simi-valley-care-center | SIMI VALLEY CARE CENTER | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
754585 | 754585 | 2020-05-09 | 50000002 | 050000002-shoreline-care-center | SHORELINE CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754584 | 754584 | 2020-05-09 | 50000068 | 050000068-santa-paula-post-acute-center | SANTA PAULA POST ACUTE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754583 | 754583 | 2020-05-09 | 50000058 | 050000058-oxnard-manor-healthcare-center | OXNARD MANOR HEALTHCARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754582 | 754582 | 2020-05-09 | 50000141 | 050000141-ojai-valley-community-skilled-nursing-facility | OJAI VALLEY COMMUNITY SKILLED NURSING FACILITY | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754581 | 754581 | 2020-05-09 | 50000043 | 050000043-ojai-health-rehabilitation | OJAI HEALTH & REHABILITATION | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754580 | 754580 | 2020-05-09 | 630011658 | 630011658-oakview-skilled-nursing | OAKVIEW SKILLED NURSING | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
754579 | 754579 | 2020-05-09 | 50000056 | 050000056-maywood-acres-healthcare | MAYWOOD ACRES HEALTHCARE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754578 | 754578 | 2020-05-09 | 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 | |||
754577 | 754577 | 2020-05-09 | 50000049 | 050000049-greenfield-care-center-of-fillmore-llc | GREENFIELD CARE CENTER OF FILLMORE, LLC | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
754576 | 754576 | 2020-05-09 | 50000050 | 050000050-glenwood-care-center | GLENWOOD CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754575 | 754575 | 2020-05-09 | 50000066 | 050000066-coastal-view-healthcare-center | COASTAL VIEW HEALTHCARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754574 | 754574 | 2020-05-09 | 50000006 | 050000006-camarillo-healthcare-center | CAMARILLO HEALTHCARE CENTER | Ventura | 0 | 1 | 0 | 0 | 111 | <11 | |||
754573 | 754573 | 2020-05-09 | 50001383 | 050001383-brookdale-camarillo | BROOKDALE CAMARILLO | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
754572 | 754572 | 2020-05-09 | 30001615 | 030001615-avalon-care-center-sonora | AVALON CARE CENTER - SONORA | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
754571 | 754571 | 2020-05-09 | 630014616 | 630014616-adventist-health-sonora-d-p-snf-unit-7 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 7) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
754570 | 754570 | 2020-05-09 | 30000023 | 030000023-adventist-health-sonora-d-p-snf-unit-6 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 6) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
754569 | 754569 | 2020-05-09 | 120001431 | 120001431-westgate-gardens-care-center | WESTGATE GARDENS CARE CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754568 | 754568 | 2020-05-09 | 630012057 | 630012057-twin-oaks-rehabilitation-nursing-center | TWIN OAKS REHABILITATION & NURSING CENTER | Tulare | 1 | 1 | 0 | 0 | 107 | <11 | <11 | ||
754567 | 754567 | 2020-05-09 | 120001408 | 120001408-tulare-nursing-rehabilitation-center | TULARE NURSING & REHABILITATION CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754566 | 754566 | 2020-05-09 | 120001466 | 120001466-sierra-view-medical-center | SIERRA VIEW MEDICAL CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754565 | 754565 | 2020-05-09 | 120001442 | 120001442-sierra-valley-rehabilitation-center | SIERRA VALLEY REHABILITATION CENTER | Tulare | 1 | 57 | 0 | 1 | 107 | <11 | <11 | ||
754564 | 754564 | 2020-05-09 | 120001474 | 120001474-sequoia-transitional-care | SEQUOIA TRANSITIONAL CARE | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
754563 | 754563 | 2020-05-09 | 120001469 | 120001469-redwood-springs-healthcare-center | REDWOOD SPRINGS HEALTHCARE CENTER | Tulare | 66 | 117 | 0 | 28 | 107 | ||||
754562 | 754562 | 2020-05-09 | 170001876 | 170001876-porterville-developmental-center-d-p-snf | PORTERVILLE DEVELOPMENTAL CENTER D/P SNF | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754561 | 754561 | 2020-05-09 | 120001522 | 120001522-porterville-convalescent-hospital | PORTERVILLE CONVALESCENT HOSPITAL | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754560 | 754560 | 2020-05-09 | 120001462 | 120001462-merritt-manor-convalescent-hospital | MERRITT MANOR CONVALESCENT HOSPITAL | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
754559 | 754559 | 2020-05-09 | 120001477 | 120001477-linwood-meadows-care-center | LINWOOD MEADOWS CARE CENTER | Tulare | 1 | 15 | 0 | 1 | 107 | <11 | <11 | ||
754558 | 754558 | 2020-05-09 | 120001526 | 120001526-lindsay-gardens-nursing-rehabilitation | LINDSAY GARDENS NURSING & REHABILITATION | Tulare | 27 | 72 | 0 | 1 | 107 | <11 | |||
754557 | 754557 | 2020-05-09 | 120001472 | 120001472-kaweah-manor-convalescent-hospital | KAWEAH MANOR CONVALESCENT HOSPITAL | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754556 | 754556 | 2020-05-09 | 120001449 | 120001449-kaweah-delta-skilled-nursing-center | KAWEAH DELTA SKILLED NURSING CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754555 | 754555 | 2020-05-09 | 120001451 | 120001451-kaweah-delta-medical-center-d-p-snf | KAWEAH DELTA MEDICAL CENTER D/P SNF | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754554 | 754554 | 2020-05-09 | 120001421 | 120001421-gateway-post-acute | GATEWAY POST ACUTE | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
754553 | 754553 | 2020-05-09 | 120001440 | 120001440-dinuba-healthcare | DINUBA HEALTHCARE | Tulare | 1 | 45 | 0 | 0 | 107 | <11 | |||
754552 | 754552 | 2020-05-09 | 120001402 | 120001402-delta-nursing-rehabilitation-center | DELTA NURSING & REHABILITATION CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
754551 | 754551 | 2020-05-09 | 230000197 | 230000197-trinity-hospital-skilled-nursing-facility | TRINITY HOSPITAL SKILLED NURSING FACILITY | Trinity | 0 | 0 | 0 | 0 | 105 | ||||
754550 | 754550 | 2020-05-09 | 230000028 | 230000028-red-bluff-health-care-center | RED BLUFF HEALTH CARE CENTER | Tehama | 0 | 0 | 0 | 0 | 103 | ||||
754549 | 754549 | 2020-05-09 | 230000027 | 230000027-brentwood-post-acute | BRENTWOOD POST ACUTE | Tehama | 0 | 0 | 0 | 0 | 103 | ||||
754548 | 754548 | 2020-05-09 | 230000275 | 230000275-yuba-city-post-acute | YUBA CITY POST ACUTE | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
754547 | 754547 | 2020-05-09 | 230000370 | 230000370-the-fountains | THE FOUNTAINS | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
754546 | 754546 | 2020-05-09 | 230000460 | 230000460-river-valley-care-center | RIVER VALLEY CARE CENTER | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
754545 | 754545 | 2020-05-09 | 230000284 | 230000284-bridgeview-post-acute | BRIDGEVIEW POST ACUTE | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
754544 | 754544 | 2020-05-09 | 100000038 | 100000038-windsor-post-acute-healthcare-center-of-modesto | WINDSOR POST-ACUTE HEALTHCARE CENTER OF MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754543 | 754543 | 2020-05-09 | 100000851 | 100000851-vintage-faire-nursing-rehabilitation-center | VINTAGE FAIRE NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754542 | 754542 | 2020-05-09 | 30000288 | 030000288-turlock-nursing-and-rehabilitation-center | TURLOCK NURSING AND REHABILITATION CENTER | Stanislaus | 38 | 97 | 0 | 11 | 99 | ||||
754541 | 754541 | 2020-05-09 | 30000096 | 030000096-san-luis-care-center | SAN LUIS CARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754540 | 754540 | 2020-05-09 | 30000079 | 030000079-oakdale-nursing-and-rehabilitation-center | OAKDALE NURSING AND REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754539 | 754539 | 2020-05-09 | 30000016 | 030000016-north-starr-postacute-care | NORTH STARR POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754538 | 754538 | 2020-05-09 | 100000107 | 100000107-modesto-post-acute-center | MODESTO POST ACUTE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754537 | 754537 | 2020-05-09 | 30000050 | 030000050-main-west-postacute-care | MAIN WEST POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754536 | 754536 | 2020-05-09 | 100000072 | 100000072-hy-lond-health-care-center-modesto | HY-LOND HEALTH CARE CENTER - MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754535 | 754535 | 2020-05-09 | 100000055 | 100000055-garden-city-healthcare-center | GARDEN CITY HEALTHCARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754534 | 754534 | 2020-05-09 | 100000051 | 100000051-english-oaks-convalescent-rehabilitation-hospital | ENGLISH OAKS CONVALESCENT & REHABILITATION HOSPITAL | Stanislaus | 0 | 1 | 0 | 1 | 99 | <11 | <11 | ||
754533 | 754533 | 2020-05-09 | 100000036 | 100000036-crestwood-manor | CRESTWOOD MANOR | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754532 | 754532 | 2020-05-09 | 30001657 | 030001657-covenant-village-of-turlock-care-center | COVENANT VILLAGE OF TURLOCK CARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754531 | 754531 | 2020-05-09 | 30000066 | 030000066-ceres-postacute-care | CERES POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754530 | 754530 | 2020-05-09 | 30001202 | 030001202-central-valley-specialty-hospital-skilled-nursing-facility | CENTRAL VALLEY SPECIALTY HOSPITAL - SKILLED NURSING FACILITY | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754529 | 754529 | 2020-05-09 | 100000026 | 100000026-central-valley-post-acute-modesto | CENTRAL VALLEY POST ACUTE - MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754528 | 754528 | 2020-05-09 | 30000088 | 030000088-central-valley-post-acute | CENTRAL VALLEY POST ACUTE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754527 | 754527 | 2020-05-09 | 100000031 | 100000031-casa-de-modesto | CASA DE MODESTO | Stanislaus | 1 | 0 | 0 | 0 | 99 | <11 | |||
754526 | 754526 | 2020-05-09 | 30000852 | 030000852-brandel-manor | BRANDEL MANOR | Stanislaus | 0 | 1 | 0 | 0 | 99 | <11 | |||
754525 | 754525 | 2020-05-09 | 100000042 | 100000042-acacia-park-nursing-rehabilitation-center | ACACIA PARK NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
754524 | 754524 | 2020-05-09 | 10000005 | 010000005-windsor-care-center-of-petaluma | WINDSOR CARE CENTER OF PETALUMA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754523 | 754523 | 2020-05-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754522 | 754522 | 2020-05-09 | 110000233 | 110000233-valley-of-the-moon-post-acute | VALLEY OF THE MOON POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754521 | 754521 | 2020-05-09 | 10000076 | 010000076-summerfield-healthcare-center | SUMMERFIELD HEALTHCARE CENTER | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754520 | 754520 | 2020-05-09 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754519 | 754519 | 2020-05-09 | 10000059 | 010000059-sonoma-postacute-care | SONOMA POSTACUTE CARE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754518 | 754518 | 2020-05-09 | 10000034 | 010000034-sonoma-post-acute | SONOMA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754517 | 754517 | 2020-05-09 | 10000033 | 010000033-santa-rosa-post-acute | SANTA ROSA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754516 | 754516 | 2020-05-09 | 140001278 | 140001278-santa-rosa-memorial-hospital-d-p-snf | SANTA ROSA MEMORIAL HOSPITAL D/P SNF | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754515 | 754515 | 2020-05-09 | 10000052 | 010000052-petaluma-post-acute-rehab | PETALUMA POST-ACUTE REHAB | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754514 | 754514 | 2020-05-09 | 10000043 | 010000043-park-view-post-acute | PARK VIEW POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754513 | 754513 | 2020-05-09 | 10000079 | 010000079-hillcrest-post-acute | HILLCREST POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754512 | 754512 | 2020-05-09 | 10000029 | 010000029-healdsburg-senior-living-community | HEALDSBURG SENIOR LIVING COMMUNITY | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754511 | 754511 | 2020-05-09 | 110000702 | 110000702-healdsburg-district-hospital-d-p-snf | HEALDSBURG DISTRICT HOSPITAL D/P SNF | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754510 | 754510 | 2020-05-09 | 10000022 | 010000022-friends-house | FRIENDS HOUSE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754509 | 754509 | 2020-05-09 | 10000028 | 010000028-empres-post-acute-rehabilitation | EMPRES POST ACUTE REHABILITATION | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754508 | 754508 | 2020-05-09 | 10000003 | 010000003-creekside-rehabilitation-behavioral-health | CREEKSIDE REHABILITATION & BEHAVIORAL HEALTH | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754507 | 754507 | 2020-05-09 | 10000037 | 010000037-cloverdale-healthcare-center | CLOVERDALE HEALTHCARE CENTER | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754506 | 754506 | 2020-05-09 | 10000066 | 010000066-broadway-villa-post-acute | BROADWAY VILLA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754505 | 754505 | 2020-05-09 | 10001140 | 010001140-arbol-residences-of-santa-rosa | ARBOL RESIDENCES OF SANTA ROSA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
754504 | 754504 | 2020-05-09 | 10000026 | 010000026-apple-valley-post-acute-rehab | APPLE VALLEY POST-ACUTE REHAB | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
754503 | 754503 | 2020-05-09 | 110000013 | 110000013-windsor-vallejo-nursing-rehabilitation-center | WINDSOR VALLEJO NURSING & REHABILITATION CENTER | Solano | 27 | 87 | 0 | 1 | 95 | <11 | |||
754502 | 754502 | 2020-05-09 | 110000467 | 110000467-vacaville-convalescent-and-rehabilitation-center | VACAVILLE CONVALESCENT AND REHABILITATION CENTER | Solano | 0 | 0 | 0 | 0 | 95 | ||||
754501 | 754501 | 2020-05-09 | 110000074 | 110000074-springs-road-healthcare | SPRINGS ROAD HEALTHCARE | Solano | 0 | 0 | 0 | 0 | 95 | ||||
754500 | 754500 | 2020-05-09 | 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 );