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,223 rows where "date" is on date 2020-07-25 sorted by slug
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
660347 | 660347 | 2020-07-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 11 | 1 | 0 | 0 | 97 | <11 | |||
660333 | 660333 | 2020-07-25 | 10000003 | 010000003-creekside-rehabilitation-behavioral-health | CREEKSIDE REHABILITATION & BEHAVIORAL HEALTH | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
659318 | 659318 | 2020-07-25 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
660348 | 660348 | 2020-07-25 | 10000005 | 010000005-windsor-care-center-of-petaluma | WINDSOR CARE CENTER OF PETALUMA | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
659360 | 659360 | 2020-07-25 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
660329 | 660329 | 2020-07-25 | 10000026 | 010000026-apple-valley-post-acute-rehab | APPLE VALLEY POST-ACUTE REHAB | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
660334 | 660334 | 2020-07-25 | 10000028 | 010000028-empres-post-acute-rehabilitation | EMPRES POST ACUTE REHABILITATION | Sonoma | 1 | 30 | 0 | 1 | 97 | <11 | <11 | ||
660336 | 660336 | 2020-07-25 | 10000029 | 010000029-healdsburg-senior-living-community | HEALDSBURG SENIOR LIVING COMMUNITY | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
660342 | 660342 | 2020-07-25 | 10000033 | 010000033-santa-rosa-post-acute | SANTA ROSA POST ACUTE | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
660343 | 660343 | 2020-07-25 | 10000034 | 010000034-sonoma-post-acute | SONOMA POST ACUTE | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
660332 | 660332 | 2020-07-25 | 10000037 | 010000037-cloverdale-healthcare-center | CLOVERDALE HEALTHCARE CENTER | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
659803 | 659803 | 2020-07-25 | 10000042 | 010000042-mendocino-nursing-care-center | MENDOCINO NURSING CARE CENTER | Mendocino | 1 | 1 | 1 | 1 | 45 | <11 | <11 | <11 | <11 |
660339 | 660339 | 2020-07-25 | 10000043 | 010000043-park-view-post-acute | PARK VIEW POST ACUTE | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
659804 | 659804 | 2020-07-25 | 10000047 | 010000047-northbrook-healthcare-center | NORTHBROOK HEALTHCARE CENTER | Mendocino | 0 | 0 | 0 | 0 | 45 | ||||
659362 | 659362 | 2020-07-25 | 10000051 | 010000051-pacific-rehabilitation-wellness-center-lp | PACIFIC REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 1 | 1 | 1 | 23 | <11 | <11 | <11 | <11 |
660340 | 660340 | 2020-07-25 | 10000052 | 010000052-petaluma-post-acute-rehab | PETALUMA POST-ACUTE REHAB | Sonoma | 13 | 16 | 0 | 1 | 97 | <11 | |||
660338 | 660338 | 2020-07-25 | 10000059 | 010000059-northvine-postacute-care | NORTHVINE POSTACUTE CARE | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
659363 | 659363 | 2020-07-25 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
659806 | 659806 | 2020-07-25 | 10000062 | 010000062-sherwood-oaks-healthcare-center | SHERWOOD OAKS HEALTHCARE CENTER | Mendocino | 1 | 13 | 0 | 1 | 45 | <11 | <11 | ||
660331 | 660331 | 2020-07-25 | 10000066 | 010000066-broadway-villa-post-acute | BROADWAY VILLA POST ACUTE | Sonoma | 21 | 46 | 0 | 1 | 97 | <11 | |||
659359 | 659359 | 2020-07-25 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
660345 | 660345 | 2020-07-25 | 10000076 | 010000076-summerfield-healthcare-center | SUMMERFIELD HEALTHCARE CENTER | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
659358 | 659358 | 2020-07-25 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
660337 | 660337 | 2020-07-25 | 10000079 | 010000079-hillcrest-post-acute | HILLCREST POST ACUTE | Sonoma | 1 | 1 | 0 | 0 | 97 | <11 | <11 | ||
659807 | 659807 | 2020-07-25 | 10000080 | 010000080-ukiah-post-acute | UKIAH POST ACUTE | Mendocino | 0 | 0 | 0 | 0 | 45 | ||||
659805 | 659805 | 2020-07-25 | 10000082 | 010000082-redwood-cove-healthcare-center | REDWOOD COVE HEALTHCARE CENTER | Mendocino | 0 | 0 | 0 | 0 | 45 | ||||
660344 | 660344 | 2020-07-25 | 10000208 | 010000208-spring-lake-village | SPRING LAKE VILLAGE | Sonoma | 1 | 0 | 0 | 0 | 97 | <11 | |||
659789 | 659789 | 2020-07-25 | 10000934 | 010000934-canyon-manor | CANYON MANOR | Marin | 1 | 1 | 1 | 1 | 41 | <11 | <11 | <11 | <11 |
659796 | 659796 | 2020-07-25 | 10000936 | 010000936-san-rafael-healthcare-wellness-center-lp | SAN RAFAEL HEALTHCARE & WELLNESS CENTER, LP | Marin | 1 | 1 | 0 | 1 | 41 | <11 | <11 | <11 | |
659798 | 659798 | 2020-07-25 | 10000938 | 010000938-south-marin-health-wellness-center | SOUTH MARIN HEALTH & WELLNESS CENTER | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
659793 | 659793 | 2020-07-25 | 10000940 | 010000940-novato-healthcare-center | NOVATO HEALTHCARE CENTER | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
659794 | 659794 | 2020-07-25 | 10000949 | 010000949-pine-ridge-care-center | PINE RIDGE CARE CENTER | Marin | 12 | 1 | 0 | 1 | 41 | <11 | <11 | ||
659790 | 659790 | 2020-07-25 | 10000951 | 010000951-marin-convalescent-rehabilitation-hospital | MARIN CONVALESCENT & REHABILITATION HOSPITAL | Marin | 0 | 0 | 0 | 0 | 41 | ||||
659791 | 659791 | 2020-07-25 | 10000959 | 010000959-marin-post-acute | MARIN POST ACUTE | Marin | 20 | 70 | 0 | 13 | 41 | ||||
659795 | 659795 | 2020-07-25 | 10000968 | 010000968-professional-post-acute-center | PROFESSIONAL POST ACUTE CENTER | Marin | 11 | 40 | 0 | 1 | 41 | <11 | |||
659792 | 659792 | 2020-07-25 | 10000980 | 010000980-northgate-postacute-care | NORTHGATE POSTACUTE CARE | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
659800 | 659800 | 2020-07-25 | 10000985 | 010000985-the-tamalpais | THE TAMALPAIS | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
659801 | 659801 | 2020-07-25 | 10000995 | 010000995-villa-marin-retirement-residences | VILLA MARIN RETIREMENT RESIDENCES | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
659788 | 659788 | 2020-07-25 | 10001005 | 010001005-aldersly-skilled-nursing-facility | ALDERSLY SKILLED NURSING FACILITY | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
659799 | 659799 | 2020-07-25 | 10001007 | 010001007-the-redwoods-a-community-of-seniors | THE REDWOODS, A COMMUNITY OF SENIORS | Marin | 0 | 0 | 0 | 0 | 41 | ||||
659797 | 659797 | 2020-07-25 | 10001037 | 010001037-smith-ranch-skilled-nursing-rehabilitation-center | SMITH RANCH SKILLED NURSING & REHABILITATION CENTER | Marin | 1 | 0 | 0 | 0 | 41 | <11 | |||
660330 | 660330 | 2020-07-25 | 10001140 | 010001140-arbol-residences-of-santa-rosa | ARBOL RESIDENCES OF SANTA ROSA | Sonoma | 0 | 0 | 0 | 0 | 97 | ||||
659255 | 659255 | 2020-07-25 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659206 | 659206 | 2020-07-25 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659208 | 659208 | 2020-07-25 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659265 | 659265 | 2020-07-25 | 20000019 | 020000019-vista-post-acute | VISTA POST ACUTE | Alameda | 26 | 48 | 0 | 1 | 1 | <11 | |||
659268 | 659268 | 2020-07-25 | 20000020 | 020000020-windsor-country-drive-care-center | WINDSOR COUNTRY DRIVE CARE CENTER | Alameda | 13 | 1 | 0 | 0 | 1 | <11 | |||
659210 | 659210 | 2020-07-25 | 20000026 | 020000026-bay-view-rehabilitation-hospital-llc | BAY VIEW REHABILITATION HOSPITAL, LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659214 | 659214 | 2020-07-25 | 20000028 | 020000028-berkeley-pines-skilled-nursing-center | BERKELEY PINES SKILLED NURSING CENTER | Alameda | 1 | 18 | 0 | 1 | 1 | <11 | <11 | ||
659215 | 659215 | 2020-07-25 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659271 | 659271 | 2020-07-25 | 20000036 | 020000036-windsor-park-care-center-of-fremont | WINDSOR PARK CARE CENTER OF FREMONT | Alameda | 1 | 15 | 0 | 0 | 1 | <11 | |||
659259 | 659259 | 2020-07-25 | 20000037 | 020000037-st-patrick-s-post-acute | ST. PATRICK'S POST ACUTE | Alameda | 31 | 48 | 0 | 19 | 1 | ||||
659229 | 659229 | 2020-07-25 | 20000039 | 020000039-hayward-healthcare-wellness-center | HAYWARD HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 1 | 1 | 0 | 1 | <11 | <11 | <11 | |
659237 | 659237 | 2020-07-25 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659232 | 659232 | 2020-07-25 | 20000042 | 020000042-kaiser-permanente-post-acute-care-center | KAISER PERMANENTE POST-ACUTE CARE CENTER | Alameda | 1 | 18 | 0 | 1 | 1 | <11 | <11 | ||
659201 | 659201 | 2020-07-25 | 20000043 | 020000043-alameda-healthcare-wellness-center | ALAMEDA HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
659230 | 659230 | 2020-07-25 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659216 | 659216 | 2020-07-25 | 20000048 | 020000048-chaparral-house | CHAPARRAL HOUSE | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
659218 | 659218 | 2020-07-25 | 20000053 | 020000053-crestwood-manor-fremont | CRESTWOOD MANOR - FREMONT | Alameda | 1 | 35 | 0 | 0 | 1 | <11 | |||
659250 | 659250 | 2020-07-25 | 20000054 | 020000054-princeton-manor-healthcare-center-llc | PRINCETON MANOR HEALTHCARE CENTER, LLC | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659211 | 659211 | 2020-07-25 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659258 | 659258 | 2020-07-25 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659267 | 659267 | 2020-07-25 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659264 | 659264 | 2020-07-25 | 20000066 | 020000066-valley-pointe-nursing-rehabilitation-center | VALLEY POINTE NURSING & REHABILITATION CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
659257 | 659257 | 2020-07-25 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659205 | 659205 | 2020-07-25 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659272 | 659272 | 2020-07-25 | 20000071 | 020000071-windsor-post-acute-care-center-of-hayward | WINDSOR POST-ACUTE CARE CENTER OF HAYWARD | Alameda | 26 | 29 | 0 | 1 | 1 | <11 | |||
659254 | 659254 | 2020-07-25 | 20000074 | 020000074-serenethos-care-center-llc | SERENETHOS CARE CENTER, LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659256 | 659256 | 2020-07-25 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659253 | 659253 | 2020-07-25 | 20000077 | 020000077-san-leandro-healthcare-center | SAN LEANDRO HEALTHCARE CENTER | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
659239 | 659239 | 2020-07-25 | 20000079 | 020000079-medical-hill-healthcare-center | MEDICAL HILL HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659220 | 659220 | 2020-07-25 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659247 | 659247 | 2020-07-25 | 20000090 | 020000090-parkview-healthcare-center | PARKVIEW HEALTHCARE CENTER | Alameda | 20 | 61 | 1 | 1 | 1 | <11 | <11 | ||
659248 | 659248 | 2020-07-25 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659224 | 659224 | 2020-07-25 | 20000093 | 020000093-excell-health-care-center | EXCELL HEALTH CARE CENTER | Alameda | 23 | 43 | 0 | 1 | 1 | <11 | |||
659246 | 659246 | 2020-07-25 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659238 | 659238 | 2020-07-25 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659240 | 659240 | 2020-07-25 | 20000100 | 020000100-mercy-retirement-care-center | MERCY RETIREMENT & CARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
659242 | 659242 | 2020-07-25 | 20000101 | 020000101-niles-canyon-post-acute | NILES CANYON POST ACUTE | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
659269 | 659269 | 2020-07-25 | 20000103 | 020000103-windsor-gardens-care-center-of-hayward | WINDSOR GARDENS CARE CENTER OF HAYWARD | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659236 | 659236 | 2020-07-25 | 20000104 | 020000104-marina-garden-nursing-center | MARINA GARDEN NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659234 | 659234 | 2020-07-25 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659231 | 659231 | 2020-07-25 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659233 | 659233 | 2020-07-25 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659235 | 659235 | 2020-07-25 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659243 | 659243 | 2020-07-25 | 20000115 | 020000115-oakland-healthcare-wellness-center | OAKLAND HEALTHCARE & WELLNESS CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659222 | 659222 | 2020-07-25 | 20000116 | 020000116-east-bay-post-acute | EAST BAY POST-ACUTE | Alameda | 25 | 33 | 0 | 1 | 1 | <11 | |||
659252 | 659252 | 2020-07-25 | 20000119 | 020000119-redwood-healthcare-center-llc | REDWOOD HEALTHCARE CENTER LLC | Alameda | 16 | 29 | 0 | 1 | 1 | <11 | |||
659228 | 659228 | 2020-07-25 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
659226 | 659226 | 2020-07-25 | 20000124 | 020000124-fruitvale-healthcare-center | FRUITVALE HEALTHCARE CENTER | Alameda | 1 | 11 | 0 | 0 | 1 | <11 | |||
659227 | 659227 | 2020-07-25 | 20000125 | 020000125-garfield-neurobehavioral-center | GARFIELD NEUROBEHAVIORAL CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659223 | 659223 | 2020-07-25 | 20000128 | 020000128-elmwood-care-center | ELMWOOD CARE CENTER | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
659219 | 659219 | 2020-07-25 | 20000129 | 020000129-crestwood-treatment-center | CRESTWOOD TREATMENT CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
659225 | 659225 | 2020-07-25 | 20000132 | 020000132-fremont-healthcare-center | FREMONT HEALTHCARE CENTER | Alameda | 1 | 38 | 0 | 1 | 1 | <11 | <11 | ||
659221 | 659221 | 2020-07-25 | 20000133 | 020000133-driftwood-healthcare-center-hayward | DRIFTWOOD HEALTHCARE CENTER - HAYWARD | Alameda | 12 | 32 | 0 | 1 | 1 | <11 | |||
659209 | 659209 | 2020-07-25 | 20000135 | 020000135-bay-area-healthcare-center | BAY AREA HEALTHCARE CENTER | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 | ||
659261 | 659261 | 2020-07-25 | 20000274 | 020000274-the-rehabilitation-center-of-oakland | THE REHABILITATION CENTER OF OAKLAND | Alameda | 1 | 1 | 0 | 1 | 1 | <11 | <11 | <11 | |
659266 | 659266 | 2020-07-25 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
659251 | 659251 | 2020-07-25 | 20000276 | 020000276-redwood-convalescent-hospital-inc | REDWOOD CONVALESCENT HOSPITAL, INC. | Alameda | 1 | 20 | 0 | 1 | 1 | <11 | <11 | ||
659270 | 659270 | 2020-07-25 | 20000277 | 020000277-windsor-healthcare-center-of-oakland | WINDSOR HEALTHCARE CENTER OF OAKLAND | Alameda | 1 | 1 | 0 | 0 | 1 | <11 | <11 |
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 );