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-24 sorted by name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
772784 | 772784 | 2020-04-24 | 70000095 | 070000095-a-grace-sub-acute-skilled-care | A GRACE SUB ACUTE & SKILLED CARE | Santa Clara | 1 | 0 | 0 | 0 | 85 | <11 | |||
772615 | 772615 | 2020-04-24 | 80000056 | 080000056-abby-gardens-healthcare-center | ABBY GARDENS HEALTHCARE CENTER | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
772885 | 772885 | 2020-04-24 | 100000042 | 100000042-acacia-park-nursing-rehabilitation-center | ACACIA PARK NURSING & REHABILITATION CENTER | Stanislaus | 0 | 0 | 0 | 0 | 99 | ||||
772521 | 772521 | 2020-04-24 | 30001829 | 030001829-acc-care-center | ACC CARE CENTER | Sacramento | 1 | 0 | 0 | 0 | 67 | <11 | |||
772522 | 772522 | 2020-04-24 | 630017757 | 630017757-advanced-health-care-of-sacramento | ADVANCED HEALTH CARE OF SACRAMENTO | Sacramento | 0 | 0 | 0 | 0 | 67 | ||||
772384 | 772384 | 2020-04-24 | 60000051 | 060000051-advanced-rehab-center-of-tustin | ADVANCED REHAB CENTER OF TUSTIN | Orange | 0 | 1 | 0 | 0 | 59 | <11 | |||
772930 | 772930 | 2020-04-24 | 30000023 | 030000023-adventist-health-sonora-d-p-snf-unit-6 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 6) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
772931 | 772931 | 2020-04-24 | 630014616 | 630014616-adventist-health-sonora-d-p-snf-unit-7 | ADVENTIST HEALTH SONORA - D/P SNF (UNIT 7) | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
771930 | 771930 | 2020-04-24 | 940000049 | 940000049-affinity-healthcare-center | AFFINITY HEALTHCARE CENTER | Los Angeles | 12 | 16 | 0 | 1 | 37 | <11 | |||
771931 | 771931 | 2020-04-24 | 920000077 | 920000077-alameda-care-center | ALAMEDA CARE CENTER | Los Angeles | 32 | 12 | 0 | 13 | 37 | ||||
771736 | 771736 | 2020-04-24 | 140000321 | 140000321-alameda-county-medical-center-d-p-snf | ALAMEDA COUNTY MEDICAL CENTER D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
771737 | 771737 | 2020-04-24 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
771738 | 771738 | 2020-04-24 | 630011864 | 630011864-alameda-hospital-southshore-convalescent | ALAMEDA HOSPITAL - SOUTHSHORE CONVALESCENT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
771739 | 771739 | 2020-04-24 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
771932 | 771932 | 2020-04-24 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
772385 | 772385 | 2020-04-24 | 60000022 | 060000022-alamitos-west-health-rehabilitation | ALAMITOS WEST HEALTH & REHABILITATION | Orange | 1 | 11 | 0 | 0 | 59 | <11 | |||
771933 | 771933 | 2020-04-24 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 13 | 21 | 0 | 11 | 37 | ||||
771934 | 771934 | 2020-04-24 | 970000121 | 970000121-alden-terrace-convalescent-hospital | ALDEN TERRACE CONVALESCENT HOSPITAL | Los Angeles | 11 | 38 | 0 | 1 | 37 | <11 | |||
772324 | 772324 | 2020-04-24 | 10001005 | 010001005-aldersly-skilled-nursing-facility | ALDERSLY SKILLED NURSING FACILITY | Marin | 0 | 0 | 0 | 0 | 41 | ||||
772952 | 772952 | 2020-04-24 | 100000030 | 100000030-alderson-convalescent-hospital | ALDERSON CONVALESCENT HOSPITAL | Yolo | 1 | 0 | 0 | 0 | 113 | <11 | |||
771935 | 771935 | 2020-04-24 | 970000003 | 970000003-alexandria-care-center | ALEXANDRIA CARE CENTER | Los Angeles | 1 | 15 | 0 | 1 | 37 | <11 | <11 | ||
771822 | 771822 | 2020-04-24 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
771936 | 771936 | 2020-04-24 | 950000101 | 950000101-alhambra-healthcare-wellness-centre-lp | ALHAMBRA HEALTHCARE & WELLNESS CENTRE, LP | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
771937 | 771937 | 2020-04-24 | 930000793 | 930000793-alhambra-hospital-medical-center-d-p-snf | ALHAMBRA HOSPITAL MEDICAL CENTER D/P SNF | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
771740 | 771740 | 2020-04-24 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
771938 | 771938 | 2020-04-24 | 920000001 | 920000001-all-saints-healthcare | ALL SAINTS HEALTHCARE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
771741 | 771741 | 2020-04-24 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
772785 | 772785 | 2020-04-24 | 70000043 | 070000043-almaden-healthcare-and-rehabilitation-center | ALMADEN HEALTHCARE AND REHABILITATION CENTER | Santa Clara | 0 | 0 | 0 | 0 | 85 | ||||
772386 | 772386 | 2020-04-24 | 80001542 | 080001542-alta-gardens-care-center | ALTA GARDENS CARE CENTER | Orange | 0 | 0 | 0 | 0 | 59 | ||||
772467 | 772467 | 2020-04-24 | 250000010 | 250000010-alta-vista-healthcare-wellness-centre | ALTA VISTA HEALTHCARE & WELLNESS CENTRE | Riverside | 1 | 0 | 0 | 0 | 65 | <11 | |||
772770 | 772770 | 2020-04-24 | 50000007 | 050000007-alto-lucero-transitional-care | ALTO LUCERO TRANSITIONAL CARE | Santa Barbara | 0 | 0 | 0 | 0 | 83 | ||||
772616 | 772616 | 2020-04-24 | 90000102 | 090000102-amaya-springs-health-care-center | AMAYA SPRINGS HEALTH CARE CENTER | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
772786 | 772786 | 2020-04-24 | 70000096 | 070000096-amberwood-gardens | AMBERWOOD GARDENS | Santa Clara | 1 | 1 | 0 | 0 | 85 | <11 | <11 | ||
772523 | 772523 | 2020-04-24 | 30001004 | 030001004-american-river-center | AMERICAN RIVER CENTER | Sacramento | 0 | 0 | 0 | 0 | 67 | ||||
772387 | 772387 | 2020-04-24 | 60000031 | 060000031-anaheim-crest-nursing-center | ANAHEIM CREST NURSING CENTER | Orange | 0 | 0 | 0 | 0 | 59 | ||||
772388 | 772388 | 2020-04-24 | 60000196 | 060000196-anaheim-healthcare-center-llc | ANAHEIM HEALTHCARE CENTER, LLC | Orange | 16 | 33 | 0 | 1 | 59 | <11 | |||
772389 | 772389 | 2020-04-24 | 80001540 | 080001540-anaheim-terrace-care-center | ANAHEIM TERRACE CARE CENTER | Orange | 0 | 0 | 0 | 0 | 59 | ||||
772344 | 772344 | 2020-04-24 | 40000225 | 040000225-anberry-nursing-and-rehabilitation-center | ANBERRY NURSING AND REHABILITATION CENTER | Merced | 0 | 0 | 0 | 0 | 47 | ||||
772345 | 772345 | 2020-04-24 | 630016406 | 630016406-anberry-transitional-care | ANBERRY TRANSITIONAL CARE | Merced | 0 | 0 | 0 | 0 | 47 | ||||
771939 | 771939 | 2020-04-24 | 970000123 | 970000123-angels-nursing-health-center | ANGELS NURSING HEALTH CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
771940 | 771940 | 2020-04-24 | 920000280 | 920000280-antelope-valley-care-center | ANTELOPE VALLEY CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
771823 | 771823 | 2020-04-24 | 140000003 | 140000003-antioch-convalescent-hospital | ANTIOCH CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
772561 | 772561 | 2020-04-24 | 240001011 | 240001011-apple-valley-post-acute-center | APPLE VALLEY POST ACUTE CENTER | San Bernardino | 0 | 0 | 0 | 0 | 71 | ||||
772864 | 772864 | 2020-04-24 | 10000026 | 010000026-apple-valley-post-acute-rehab | APPLE VALLEY POST-ACUTE REHAB | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
772524 | 772524 | 2020-04-24 | 100000089 | 100000089-applewood-post-acute | APPLEWOOD POST ACUTE | Sacramento | 0 | 0 | 0 | 0 | 67 | ||||
771941 | 771941 | 2020-04-24 | 970000091 | 970000091-ararat-convalescent-hospital | ARARAT CONVALESCENT HOSPITAL | Los Angeles | 16 | 1 | 0 | 1 | 37 | <11 | <11 | ||
771942 | 771942 | 2020-04-24 | 920000292 | 920000292-ararat-nursing-facility | ARARAT NURSING FACILITY | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
772865 | 772865 | 2020-04-24 | 10001140 | 010001140-arbol-residences-of-santa-rosa | ARBOL RESIDENCES OF SANTA ROSA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
771943 | 771943 | 2020-04-24 | 950000012 | 950000012-arbor-glen-care-center | ARBOR GLEN CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
772617 | 772617 | 2020-04-24 | 80000070 | 080000070-arbor-hills-nursing-center | ARBOR HILLS NURSING CENTER | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
771810 | 771810 | 2020-04-24 | 230000255 | 230000255-arbor-post-acute | ARBOR POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
772720 | 772720 | 2020-04-24 | 100000022 | 100000022-arbor-rehabilitation-nursing-center | ARBOR REHABILITATION & NURSING CENTER | San Joaquin | 0 | 0 | 0 | 0 | 77 | ||||
771944 | 771944 | 2020-04-24 | 950000045 | 950000045-arcadia-care-center | ARCADIA CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
772525 | 772525 | 2020-04-24 | 100000025 | 100000025-arden-post-acute-rehab | ARDEN POST ACUTE REHAB | Sacramento | 0 | 0 | 0 | 0 | 67 | ||||
772468 | 772468 | 2020-04-24 | 250000015 | 250000015-arlington-gardens-care-center | ARLINGTON GARDENS CARE CENTER | Riverside | 1 | 1 | 0 | 1 | 65 | <11 | <11 | <11 | |
772562 | 772562 | 2020-04-24 | 240000106 | 240000106-arrowhead-healthcare-center-llc | ARROWHEAD HEALTHCARE CENTER, LLC | San Bernardino | 0 | 0 | 0 | 0 | 71 | ||||
772746 | 772746 | 2020-04-24 | 50000003 | 050000003-arroyo-grande-care-center | ARROYO GRANDE CARE CENTER | San Luis Obispo | 0 | 0 | 0 | 0 | 79 | ||||
772618 | 772618 | 2020-04-24 | 90000029 | 090000029-arroyo-vista-nursing-center | ARROYO VISTA NURSING CENTER | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
771945 | 771945 | 2020-04-24 | 940000093 | 940000093-artesia-christian-home-inc | ARTESIA CHRISTIAN HOME INC. | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
772526 | 772526 | 2020-04-24 | 100000001 | 100000001-asbury-park-nursing-and-rehabilitation-center | ASBURY PARK NURSING AND REHABILITATION CENTER | Sacramento | 0 | 0 | 0 | 0 | 67 | ||||
771742 | 771742 | 2020-04-24 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
772563 | 772563 | 2020-04-24 | 240000700 | 240000700-asistencia-villa-rehabilitation-and-care-center | ASISTENCIA VILLA REHABILITATION AND CARE CENTER | San Bernardino | 1 | 1 | 0 | 1 | 71 | <11 | <11 | <11 | |
772619 | 772619 | 2020-04-24 | 80000761 | 080000761-astor-healthcare-center | ASTOR HEALTHCARE CENTER | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
771946 | 771946 | 2020-04-24 | 920000002 | 920000002-astoria-nursing-and-rehab-center | ASTORIA NURSING AND REHAB CENTER | Los Angeles | 1 | 1 | 0 | 0 | 37 | <11 | <11 | ||
771947 | 771947 | 2020-04-24 | 950000039 | 950000039-atherton-baptist-home-sam-b-west | ATHERTON BAPTIST HOME-SAM B. WEST | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
772753 | 772753 | 2020-04-24 | 220000047 | 220000047-atherton-regency | ATHERTON REGENCY | San Mateo | 0 | 0 | 0 | 0 | 81 | ||||
771948 | 771948 | 2020-04-24 | 940000007 | 940000007-atlantic-memorial-healthcare-center | ATLANTIC MEMORIAL HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
772771 | 772771 | 2020-04-24 | 50000064 | 050000064-atterdag-care-center | ATTERDAG CARE CENTER | Santa Barbara | 0 | 0 | 0 | 0 | 83 | ||||
772455 | 772455 | 2020-04-24 | 30000280 | 030000280-auburn-oaks-care-center | AUBURN OAKS CARE CENTER | Placer | 0 | 0 | 0 | 0 | 61 | ||||
772456 | 772456 | 2020-04-24 | 30000013 | 030000013-auburn-ravine-terrace | AUBURN RAVINE TERRACE | Placer | 0 | 0 | 0 | 0 | 61 | ||||
771949 | 771949 | 2020-04-24 | 920000306 | 920000306-autumn-hills-health-care-center | AUTUMN HILLS HEALTH CARE CENTER | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | <11 | |
772932 | 772932 | 2020-04-24 | 30001615 | 030001615-avalon-care-center-sonora | AVALON CARE CENTER - SONORA | Tuolumne | 0 | 0 | 0 | 0 | 109 | ||||
772318 | 772318 | 2020-04-24 | 40000073 | 040000073-avalon-health-care-madera | AVALON HEALTH CARE - MADERA | Madera | 0 | 0 | 0 | 0 | 39 | ||||
771819 | 771819 | 2020-04-24 | 30000012 | 030000012-avalon-health-care-san-andreas | AVALON HEALTH CARE - SAN ANDREAS | Calaveras | 0 | 0 | 0 | 0 | 9 | ||||
771950 | 771950 | 2020-04-24 | 940000051 | 940000051-avalon-villa-care-center | AVALON VILLA CARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
772356 | 772356 | 2020-04-24 | 70000019 | 070000019-ave-maria-convalescent-hospital | AVE MARIA CONVALESCENT HOSPITAL | Monterey | 0 | 0 | 0 | 0 | 53 | ||||
772620 | 772620 | 2020-04-24 | 80000077 | 080000077-aviara-healthcare-center | AVIARA HEALTHCARE CENTER | San Diego | 0 | 0 | 0 | 0 | 73 | ||||
772621 | 772621 | 2020-04-24 | 90000020 | 090000020-avocado-post-acute | AVOCADO POST ACUTE | San Diego | 12 | 20 | 0 | 1 | 73 | <11 | |||
772622 | 772622 | 2020-04-24 | 90000065 | 090000065-balboa-nursing-rehabilitation-center | BALBOA NURSING & REHABILITATION CENTER | San Diego | 1 | 1 | 0 | 0 | 73 | <11 | <11 | ||
771951 | 771951 | 2020-04-24 | 950000015 | 950000015-baldwin-gardens-nursing-center | BALDWIN GARDENS NURSING CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
771743 | 771743 | 2020-04-24 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
772469 | 772469 | 2020-04-24 | 250000016 | 250000016-banning-healthcare | BANNING HEALTHCARE | Riverside | 0 | 0 | 0 | 0 | 65 | ||||
771855 | 771855 | 2020-04-24 | 30001525 | 030001525-barton-hospital-d-p-snf | BARTON HOSPITAL D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
771744 | 771744 | 2020-04-24 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
771952 | 771952 | 2020-04-24 | 910000009 | 910000009-bay-crest-care-center | BAY CREST CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
771745 | 771745 | 2020-04-24 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
771824 | 771824 | 2020-04-24 | 140000023 | 140000023-bayberry-skilled-nursing-healthcare-center | BAYBERRY SKILLED NURSING & HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
771746 | 771746 | 2020-04-24 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
772747 | 772747 | 2020-04-24 | 50000139 | 050000139-bayside-care-center | BAYSIDE CARE CENTER | San Luis Obispo | 0 | 0 | 0 | 0 | 79 | ||||
771747 | 771747 | 2020-04-24 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
772390 | 772390 | 2020-04-24 | 60000045 | 060000045-beachside-nursing-center | BEACHSIDE NURSING CENTER | Orange | 0 | 0 | 0 | 0 | 59 | ||||
771953 | 771953 | 2020-04-24 | 940000097 | 940000097-beachside-post-acute | BEACHSIDE POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
771954 | 771954 | 2020-04-24 | 910000017 | 910000017-beachwood-post-acute-rehab | BEACHWOOD POST-ACUTE & REHAB | Los Angeles | 11 | 20 | 0 | 0 | 37 | ||||
771955 | 771955 | 2020-04-24 | 950000054 | 950000054-beacon-healthcare-center | BEACON HEALTHCARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
772564 | 772564 | 2020-04-24 | 240000979 | 240000979-bear-valley-community-hospital-d-p-snf | BEAR VALLEY COMMUNITY HOSPITAL D/P SNF | San Bernardino | 0 | 0 | 0 | 0 | 71 | ||||
771956 | 771956 | 2020-04-24 | 940000047 | 940000047-bel-tooren-villa-convalescent-hospital | BEL TOOREN VILLA CONVALESCENT HOSPITAL | Los Angeles | 1 | 1 | 0 | 1 | 37 | <11 | <11 | <11 | |
771957 | 771957 | 2020-04-24 | 940000010 | 940000010-bel-vista-healthcare-center | BEL VISTA HEALTHCARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
771958 | 771958 | 2020-04-24 | 940000011 | 940000011-bell-convalescent-hospital | BELL CONVALESCENT HOSPITAL | Los Angeles | 14 | 51 | 0 | 24 | 37 | ||||
771904 | 771904 | 2020-04-24 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
772623 | 772623 | 2020-04-24 | 90000044 | 090000044-bella-vista-health-center | BELLA VISTA HEALTH CENTER | San Diego | 0 | 0 | 0 | 0 | 73 |
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 );