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-04-27 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
769287 | 769287 | 2020-04-27 | 230000278 | 230000278-marysville-post-acute | MARYSVILLE POST-ACUTE | Yuba | 0 | 0 | 0 | 0 | 115 | ||||
769286 | 769286 | 2020-04-27 | 30001812 | 030001812-woodland-skilled-nursing-facility | WOODLAND SKILLED NURSING FACILITY | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
769285 | 769285 | 2020-04-27 | 100001676 | 100001676-university-retirement-community-at-davis | UNIVERSITY RETIREMENT COMMUNITY AT DAVIS | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
769284 | 769284 | 2020-04-27 | 100000100 | 100000100-stollwood-convalescent-hospital | STOLLWOOD CONVALESCENT HOSPITAL | Yolo | 13 | 32 | 0 | 1 | 113 | <11 | |||
769283 | 769283 | 2020-04-27 | 100000027 | 100000027-river-bend-nursing-center | RIVER BEND NURSING CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
769282 | 769282 | 2020-04-27 | 30001815 | 030001815-courtyard-health-care-center | COURTYARD HEALTH CARE CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
769281 | 769281 | 2020-04-27 | 30001817 | 030001817-cottonwood-health-care-center | COTTONWOOD HEALTH CARE CENTER | Yolo | 0 | 0 | 0 | 0 | 113 | ||||
769280 | 769280 | 2020-04-27 | 100000030 | 100000030-alderson-convalescent-hospital | ALDERSON CONVALESCENT HOSPITAL | Yolo | 1 | 0 | 0 | 0 | 113 | <11 | |||
769279 | 769279 | 2020-04-27 | 50001409 | 050001409-windsor-terrace-of-westlake-village | WINDSOR TERRACE OF WESTLAKE VILLAGE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769278 | 769278 | 2020-04-27 | 50000595 | 050000595-victoria-care-center | VICTORIA CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769277 | 769277 | 2020-04-27 | 50000072 | 050000072-ventura-post-acute | VENTURA POST ACUTE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769276 | 769276 | 2020-04-27 | 50000067 | 050000067-thousand-oaks-post-acute-llc | THOUSAND OAKS POST ACUTE, LLC | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769275 | 769275 | 2020-04-27 | 50000248 | 050000248-st-johns-pleasant-valley-hospital-d-p-snf | ST JOHNS PLEASANT VALLEY HOSPITAL D/P SNF | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769274 | 769274 | 2020-04-27 | 50000070 | 050000070-simi-valley-care-center | SIMI VALLEY CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769273 | 769273 | 2020-04-27 | 50000002 | 050000002-shoreline-care-center | SHORELINE CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769272 | 769272 | 2020-04-27 | 50000068 | 050000068-santa-paula-post-acute-center | SANTA PAULA POST ACUTE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769271 | 769271 | 2020-04-27 | 50000058 | 050000058-oxnard-manor-healthcare-center | OXNARD MANOR HEALTHCARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769270 | 769270 | 2020-04-27 | 50000141 | 050000141-ojai-valley-community-skilled-nursing-facility | OJAI VALLEY COMMUNITY SKILLED NURSING FACILITY | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769269 | 769269 | 2020-04-27 | 50000043 | 050000043-ojai-health-rehabilitation | OJAI HEALTH & REHABILITATION | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769268 | 769268 | 2020-04-27 | 630011658 | 630011658-oakview-skilled-nursing | OAKVIEW SKILLED NURSING | Ventura | 1 | 0 | 0 | 0 | 111 | <11 | |||
769267 | 769267 | 2020-04-27 | 50000056 | 050000056-maywood-acres-healthcare | MAYWOOD ACRES HEALTHCARE | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769266 | 769266 | 2020-04-27 | 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 | |||
769265 | 769265 | 2020-04-27 | 50000049 | 050000049-greenfield-care-center-of-fillmore-llc | GREENFIELD CARE CENTER OF FILLMORE, LLC | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769264 | 769264 | 2020-04-27 | 50000050 | 050000050-glenwood-care-center | GLENWOOD CARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769263 | 769263 | 2020-04-27 | 50000066 | 050000066-coastal-view-healthcare-center | COASTAL VIEW HEALTHCARE CENTER | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769262 | 769262 | 2020-04-27 | 50000006 | 050000006-camarillo-healthcare-center | CAMARILLO HEALTHCARE CENTER | Ventura | 0 | 1 | 0 | 0 | 111 | <11 | |||
769261 | 769261 | 2020-04-27 | 50001383 | 050001383-brookdale-camarillo | BROOKDALE CAMARILLO | Ventura | 0 | 0 | 0 | 0 | 111 | ||||
769260 | 769260 | 2020-04-27 | 30001615 | 030001615-avalon-care-center-sonora | AVALON CARE CENTER - SONORA | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
769259 | 769259 | 2020-04-27 | 630014616 | 630014616-adventist-health-sonora-d-p-snf-unit-7 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 7) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
769258 | 769258 | 2020-04-27 | 30000023 | 030000023-adventist-health-sonora-d-p-snf-unit-6 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 6) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
769257 | 769257 | 2020-04-27 | 120001431 | 120001431-westgate-gardens-care-center | WESTGATE GARDENS CARE CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769256 | 769256 | 2020-04-27 | 630012057 | 630012057-twin-oaks-rehabilitation-nursing-center | TWIN OAKS REHABILITATION & NURSING CENTER | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
769255 | 769255 | 2020-04-27 | 120001408 | 120001408-tulare-nursing-rehabilitation-center | TULARE NURSING & REHABILITATION CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769254 | 769254 | 2020-04-27 | 120001466 | 120001466-sierra-view-medical-center | SIERRA VIEW MEDICAL CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769253 | 769253 | 2020-04-27 | 120001442 | 120001442-sierra-valley-rehabilitation-center | SIERRA VALLEY REHABILITATION CENTER | Tulare | 0 | 1 | 0 | 0 | 107 | <11 | |||
769252 | 769252 | 2020-04-27 | 120001474 | 120001474-sequoia-transitional-care | SEQUOIA TRANSITIONAL CARE | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769251 | 769251 | 2020-04-27 | 120001469 | 120001469-redwood-springs-healthcare-center | REDWOOD SPRINGS HEALTHCARE CENTER | Tulare | 54 | 111 | 0 | 24 | 107 | ||||
769250 | 769250 | 2020-04-27 | 170001876 | 170001876-porterville-developmental-center-d-p-snf | PORTERVILLE DEVELOPMENTAL CENTER D/P SNF | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769249 | 769249 | 2020-04-27 | 120001522 | 120001522-porterville-convalescent-hospital | PORTERVILLE CONVALESCENT HOSPITAL | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769248 | 769248 | 2020-04-27 | 120001462 | 120001462-merritt-manor-convalescent-hospital | MERRITT MANOR CONVALESCENT HOSPITAL | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
769247 | 769247 | 2020-04-27 | 120001477 | 120001477-linwood-meadows-care-center | LINWOOD MEADOWS CARE CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769246 | 769246 | 2020-04-27 | 120001526 | 120001526-lindsay-gardens-nursing-rehabilitation | LINDSAY GARDENS NURSING & REHABILITATION | Tulare | 15 | 35 | 0 | 0 | 107 | ||||
769245 | 769245 | 2020-04-27 | 120001472 | 120001472-kaweah-manor-convalescent-hospital | KAWEAH MANOR CONVALESCENT HOSPITAL | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769244 | 769244 | 2020-04-27 | 120001449 | 120001449-kaweah-delta-skilled-nursing-center | KAWEAH DELTA SKILLED NURSING CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769243 | 769243 | 2020-04-27 | 120001451 | 120001451-kaweah-delta-medical-center-d-p-snf | KAWEAH DELTA MEDICAL CENTER D/P SNF | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769242 | 769242 | 2020-04-27 | 120001421 | 120001421-gateway-post-acute | GATEWAY POST ACUTE | Tulare | 1 | 0 | 0 | 0 | 107 | <11 | |||
769241 | 769241 | 2020-04-27 | 120001440 | 120001440-dinuba-healthcare | DINUBA HEALTHCARE | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769240 | 769240 | 2020-04-27 | 120001402 | 120001402-delta-nursing-rehabilitation-center | DELTA NURSING & REHABILITATION CENTER | Tulare | 0 | 0 | 0 | 0 | 107 | ||||
769239 | 769239 | 2020-04-27 | 230000197 | 230000197-trinity-hospital-skilled-nursing-facility | TRINITY HOSPITAL SKILLED NURSING FACILITY | Trinity | 0 | 0 | 0 | 0 | 105 | ||||
769238 | 769238 | 2020-04-27 | 230000028 | 230000028-red-bluff-health-care-center | RED BLUFF HEALTH CARE CENTER | Tehama | 0 | 0 | 0 | 0 | 103 | ||||
769237 | 769237 | 2020-04-27 | 230000027 | 230000027-brentwood-post-acute | BRENTWOOD POST ACUTE | Tehama | 0 | 0 | 0 | 0 | 103 | ||||
769236 | 769236 | 2020-04-27 | 230000275 | 230000275-yuba-city-post-acute | YUBA CITY POST ACUTE | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
769235 | 769235 | 2020-04-27 | 230000370 | 230000370-the-fountains | THE FOUNTAINS | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
769234 | 769234 | 2020-04-27 | 230000460 | 230000460-river-valley-care-center | RIVER VALLEY CARE CENTER | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
769233 | 769233 | 2020-04-27 | 230000284 | 230000284-bridgeview-post-acute | BRIDGEVIEW POST ACUTE | Sutter | 0 | 0 | 0 | 0 | 101 | ||||
769232 | 769232 | 2020-04-27 | 100000038 | 100000038-windsor-post-acute-healthcare-center-of-modesto | WINDSOR POST-ACUTE HEALTHCARE CENTER OF MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769231 | 769231 | 2020-04-27 | 100000851 | 100000851-vintage-faire-nursing-rehabilitation-center | VINTAGE FAIRE NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769230 | 769230 | 2020-04-27 | 30000288 | 030000288-turlock-nursing-and-rehabilitation-center | TURLOCK NURSING AND REHABILITATION CENTER | Stanislaus | 1 | 26 | 0 | 1 | 99 | <11 | <11 | ||
769229 | 769229 | 2020-04-27 | 30000096 | 030000096-san-luis-care-center | SAN LUIS CARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769228 | 769228 | 2020-04-27 | 30000079 | 030000079-oakdale-nursing-and-rehabilitation-center | OAKDALE NURSING AND REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769227 | 769227 | 2020-04-27 | 30000016 | 030000016-north-starr-postacute-care | NORTH STARR POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769226 | 769226 | 2020-04-27 | 100000107 | 100000107-modesto-post-acute-center | MODESTO POST ACUTE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769225 | 769225 | 2020-04-27 | 30000050 | 030000050-main-west-postacute-care | MAIN WEST POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769224 | 769224 | 2020-04-27 | 100000072 | 100000072-hy-lond-health-care-center-modesto | HY-LOND HEALTH CARE CENTER - MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769223 | 769223 | 2020-04-27 | 100000055 | 100000055-garden-city-healthcare-center | GARDEN CITY HEALTHCARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769222 | 769222 | 2020-04-27 | 100000051 | 100000051-english-oaks-convalescent-rehabilitation-hospital | ENGLISH OAKS CONVALESCENT & REHABILITATION HOSPITAL | Stanislaus | 0 | 1 | 0 | 1 | 99 | <11 | <11 | ||
769221 | 769221 | 2020-04-27 | 100000036 | 100000036-crestwood-manor | CRESTWOOD MANOR | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769220 | 769220 | 2020-04-27 | 30001657 | 030001657-covenant-village-of-turlock-care-center | COVENANT VILLAGE OF TURLOCK CARE CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769219 | 769219 | 2020-04-27 | 30000066 | 030000066-ceres-postacute-care | CERES POSTACUTE CARE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769218 | 769218 | 2020-04-27 | 30001202 | 030001202-central-valley-specialty-hospital-skilled-nursing-facility | CENTRAL VALLEY SPECIALTY HOSPITAL - SKILLED NURSING FACILITY | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769217 | 769217 | 2020-04-27 | 100000026 | 100000026-central-valley-post-acute-modesto | CENTRAL VALLEY POST ACUTE - MODESTO | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769216 | 769216 | 2020-04-27 | 30000088 | 030000088-central-valley-post-acute | CENTRAL VALLEY POST ACUTE | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769215 | 769215 | 2020-04-27 | 100000031 | 100000031-casa-de-modesto | CASA DE MODESTO | Stanislaus | 1 | 0 | 0 | 0 | 99 | <11 | |||
769214 | 769214 | 2020-04-27 | 30000852 | 030000852-brandel-manor | BRANDEL MANOR | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769213 | 769213 | 2020-04-27 | 100000042 | 100000042-acacia-park-nursing-rehabilitation-center | ACACIA PARK NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
769212 | 769212 | 2020-04-27 | 10000005 | 010000005-windsor-care-center-of-petaluma | WINDSOR CARE CENTER OF PETALUMA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769211 | 769211 | 2020-04-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769210 | 769210 | 2020-04-27 | 110000233 | 110000233-valley-of-the-moon-post-acute | VALLEY OF THE MOON POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769209 | 769209 | 2020-04-27 | 10000076 | 010000076-summerfield-healthcare-center | SUMMERFIELD HEALTHCARE CENTER | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769208 | 769208 | 2020-04-27 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769207 | 769207 | 2020-04-27 | 10000059 | 010000059-sonoma-postacute-care | SONOMA POSTACUTE CARE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769206 | 769206 | 2020-04-27 | 10000034 | 010000034-sonoma-post-acute | SONOMA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769205 | 769205 | 2020-04-27 | 10000033 | 010000033-santa-rosa-post-acute | SANTA ROSA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769204 | 769204 | 2020-04-27 | 140001278 | 140001278-santa-rosa-memorial-hospital-d-p-snf | SANTA ROSA MEMORIAL HOSPITAL D/P SNF | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769203 | 769203 | 2020-04-27 | 10000052 | 010000052-petaluma-post-acute-rehab | PETALUMA POST-ACUTE REHAB | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769202 | 769202 | 2020-04-27 | 10000043 | 010000043-park-view-post-acute | PARK VIEW POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769201 | 769201 | 2020-04-27 | 10000079 | 010000079-hillcrest-post-acute | HILLCREST POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769200 | 769200 | 2020-04-27 | 10000029 | 010000029-healdsburg-senior-living-community | HEALDSBURG SENIOR LIVING COMMUNITY | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769199 | 769199 | 2020-04-27 | 110000702 | 110000702-healdsburg-district-hospital-d-p-snf | HEALDSBURG DISTRICT HOSPITAL D/P SNF | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769198 | 769198 | 2020-04-27 | 10000022 | 010000022-friends-house | FRIENDS HOUSE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769197 | 769197 | 2020-04-27 | 10000028 | 010000028-empres-post-acute-rehabilitation | EMPRES POST ACUTE REHABILITATION | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769196 | 769196 | 2020-04-27 | 10000003 | 010000003-creekside-rehabilitation-behavioral-health | CREEKSIDE REHABILITATION & BEHAVIORAL HEALTH | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769195 | 769195 | 2020-04-27 | 10000037 | 010000037-cloverdale-healthcare-center | CLOVERDALE HEALTHCARE CENTER | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769194 | 769194 | 2020-04-27 | 10000066 | 010000066-broadway-villa-post-acute | BROADWAY VILLA POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769193 | 769193 | 2020-04-27 | 10001140 | 010001140-arbol-residences-of-santa-rosa | ARBOL RESIDENCES OF SANTA ROSA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
769192 | 769192 | 2020-04-27 | 10000026 | 010000026-apple-valley-post-acute-rehab | APPLE VALLEY POST-ACUTE REHAB | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
769191 | 769191 | 2020-04-27 | 110000013 | 110000013-windsor-vallejo-nursing-rehabilitation-center | WINDSOR VALLEJO NURSING & REHABILITATION CENTER | Solano | 1 | 70 | 0 | 0 | 95 | <11 | |||
769190 | 769190 | 2020-04-27 | 110000467 | 110000467-vacaville-convalescent-and-rehabilitation-center | VACAVILLE CONVALESCENT AND REHABILITATION CENTER | Solano | 0 | 0 | 0 | 0 | 95 | ||||
769189 | 769189 | 2020-04-27 | 110000074 | 110000074-springs-road-healthcare | SPRINGS ROAD HEALTHCARE | Solano | 0 | 0 | 0 | 0 | 95 | ||||
769188 | 769188 | 2020-04-27 | 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 );