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-09-02 sorted by patients_confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
611506 | 611506 | 2020-09-02 | 140000686 | 140000686-alameda-hospital-d-p-snf | ALAMEDA HOSPITAL D/P SNF | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611507 | 611507 | 2020-09-02 | 630013891 | 630013891-all-saint-s-maubert | ALL SAINT'S MAUBERT | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611508 | 611508 | 2020-09-02 | 20000070 | 020000070-all-saints-subacute-transitional-care | ALL SAINTS SUBACUTE & TRANSITIONAL CARE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611509 | 611509 | 2020-09-02 | 20000010 | 020000010-ashby-care-center | ASHBY CARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611510 | 611510 | 2020-09-02 | 140001291 | 140001291-avondale-villa-post-acute | AVONDALE VILLA POST-ACUTE | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611511 | 611511 | 2020-09-02 | 20000015 | 020000015-bancroft-healthcare-center | BANCROFT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611514 | 611514 | 2020-09-02 | 20000060 | 020000060-baypoint-healthcare-center | BAYPOINT HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611515 | 611515 | 2020-09-02 | 630011713 | 630011713-baywood-court-health-center | BAYWOOD COURT HEALTH CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611516 | 611516 | 2020-09-02 | 20001250 | 020001250-bellaken-skilled-nursing-center | BELLAKEN SKILLED NURSING CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611518 | 611518 | 2020-09-02 | 20000029 | 020000029-bethesda-home | BETHESDA HOME | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611523 | 611523 | 2020-09-02 | 20000087 | 020000087-crown-bay-nursing-rehabilitation-center | CROWN BAY NURSING & REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611531 | 611531 | 2020-09-02 | 20000123 | 020000123-hayward-convalescent-hospital | HAYWARD CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611533 | 611533 | 2020-09-02 | 20000047 | 020000047-hayward-hills-health-care-center | HAYWARD HILLS HEALTH CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611534 | 611534 | 2020-09-02 | 20000111 | 020000111-jones-convalescent-hospital | JONES CONVALESCENT HOSPITAL | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611536 | 611536 | 2020-09-02 | 20000112 | 020000112-kyakameena-care-center | KYAKAMEENA CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611537 | 611537 | 2020-09-02 | 20000110 | 020000110-lake-merritt-healthcare-center-llc | LAKE MERRITT HEALTHCARE CENTER LLC | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611538 | 611538 | 2020-09-02 | 20000114 | 020000114-lake-park-retirement-residence | LAKE PARK RETIREMENT RESIDENCE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611540 | 611540 | 2020-09-02 | 20000040 | 020000040-masonic-home | MASONIC HOME | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611541 | 611541 | 2020-09-02 | 20000099 | 020000099-mcclure-post-acute | MCCLURE POST ACUTE | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611547 | 611547 | 2020-09-02 | 20000880 | 020000880-oakland-heights-nursing-and-rehabilitation | OAKLAND HEIGHTS NURSING AND REHABILITATION | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611549 | 611549 | 2020-09-02 | 20000094 | 020000094-park-central-care-and-rehabilitation-center | PARK CENTRAL CARE AND REHABILITATION CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611551 | 611551 | 2020-09-02 | 20000091 | 020000091-piedmont-gardens-health-facility | PIEDMONT GARDENS HEALTH FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611558 | 611558 | 2020-09-02 | 20000005 | 020000005-st-anthony-care-center | ST ANTHONY CARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611559 | 611559 | 2020-09-02 | 20000076 | 020000076-st-francis-healthcare-center | ST FRANCIS HEALTHCARE CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611560 | 611560 | 2020-09-02 | 20000068 | 020000068-st-john-kronstadt-convalescent-center | ST JOHN KRONSTADT CONVALESCENT CENTER | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611561 | 611561 | 2020-09-02 | 20000064 | 020000064-st-pauls-towers | ST PAULS TOWERS | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611565 | 611565 | 2020-09-02 | 140000122 | 140000122-the-vineyards-healthcare-center | THE VINEYARDS HEALTHCARE CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611566 | 611566 | 2020-09-02 | 140000626 | 140000626-valley-memorial-hospital-d-p-snf | VALLEY MEMORIAL HOSPITAL D/P SNF | Alameda | 0 | 0 | 0 | 0 | 1 | ||||
611569 | 611569 | 2020-09-02 | 20000275 | 020000275-washington-center | WASHINGTON CENTER | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611570 | 611570 | 2020-09-02 | 20000065 | 020000065-we-care-skilled-nursing-facility | WE CARE SKILLED NURSING FACILITY | Alameda | 1 | 0 | 0 | 0 | 1 | <11 | |||
611580 | 611580 | 2020-09-02 | 230000327 | 230000327-orchard-hospital-d-p-snf | ORCHARD HOSPITAL D/P SNF | Butte | 0 | 0 | 0 | 0 | 7 | ||||
611581 | 611581 | 2020-09-02 | 230000221 | 230000221-oroville-hospital-post-acute-center | OROVILLE HOSPITAL POST-ACUTE CENTER | Butte | 1 | 0 | 0 | 0 | 7 | <11 | |||
611583 | 611583 | 2020-09-02 | 230000037 | 230000037-shadowbrook-post-acute | SHADOWBROOK POST ACUTE | Butte | 0 | 0 | 0 | 0 | 7 | ||||
611589 | 611589 | 2020-09-02 | 140000574 | 140000574-alhambra-convalescent-hospital | ALHAMBRA CONVALESCENT HOSPITAL | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
611592 | 611592 | 2020-09-02 | 140000130 | 140000130-danville-post-acute-rehab | DANVILLE POST-ACUTE REHAB | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611593 | 611593 | 2020-09-02 | 140000003 | 140000003-delta-view-post-acute | DELTA VIEW POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611595 | 611595 | 2020-09-02 | 140000038 | 140000038-greenridge-post-acute | GREENRIDGE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611596 | 611596 | 2020-09-02 | 140000051 | 140000051-la-casa-via-transitional-care-center | LA CASA VIA TRANSITIONAL CARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
611598 | 611598 | 2020-09-02 | 140000105 | 140000105-lone-tree-post-acute | LONE TREE POST ACUTE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611607 | 611607 | 2020-09-02 | 140000049 | 140000049-richmond-post-acute-care | RICHMOND POST ACUTE CARE | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611611 | 611611 | 2020-09-02 | 140000396 | 140000396-shields-nursing-center | SHIELDS NURSING CENTER | Contra Costa | 0 | 0 | 0 | 1 | 13 | <11 | |||
611612 | 611612 | 2020-09-02 | 140000080 | 140000080-shields-richmond-nursing-center | SHIELDS RICHMOND NURSING CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611613 | 611613 | 2020-09-02 | 140000733 | 140000733-stonebrook-healthcare-center | STONEBROOK HEALTHCARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611615 | 611615 | 2020-09-02 | 140001185 | 140001185-the-reutlinger-community | THE REUTLINGER COMMUNITY | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611617 | 611617 | 2020-09-02 | 140000083 | 140000083-walnut-creek-skilled-nursing-rehabilitation-center | WALNUT CREEK SKILLED NURSING & REHABILITATION CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611618 | 611618 | 2020-09-02 | 140000121 | 140000121-willow-pass-healthcare-center | WILLOW PASS HEALTHCARE CENTER | Contra Costa | 0 | 0 | 0 | 0 | 13 | ||||
611620 | 611620 | 2020-09-02 | 140000082 | 140000082-windsor-rosewood-care-center | WINDSOR ROSEWOOD CARE CENTER | Contra Costa | 1 | 0 | 0 | 0 | 13 | <11 | |||
611621 | 611621 | 2020-09-02 | 10000004 | 010000004-crescent-city-skilled-nursing | CRESCENT CITY SKILLED NURSING | Del Norte | 0 | 0 | 0 | 0 | 15 | ||||
611623 | 611623 | 2020-09-02 | 30000063 | 030000063-gold-country-health-center | GOLD COUNTRY HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
611624 | 611624 | 2020-09-02 | 30001064 | 030001064-marshall-medical-center-d-p-snf | MARSHALL MEDICAL CENTER D/P SNF | El Dorado | 0 | 0 | 0 | 0 | 17 | ||||
611626 | 611626 | 2020-09-02 | 30000047 | 030000047-western-slope-health-center | WESTERN SLOPE HEALTH CENTER | El Dorado | 1 | 0 | 0 | 0 | 17 | <11 | |||
611633 | 611633 | 2020-09-02 | 40000033 | 040000033-dycora-transitional-health-fowler | DYCORA TRANSITIONAL HEALTH - FOWLER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
611646 | 611646 | 2020-09-02 | 40000036 | 040000036-manning-gardens-care-center-inc | MANNING GARDENS CARE CENTER, INC. | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
611647 | 611647 | 2020-09-02 | 40000059 | 040000059-north-pointe-healthcare-centre | NORTH POINTE HEALTHCARE CENTRE | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
611652 | 611652 | 2020-09-02 | 40000052 | 040000052-rolling-hills-care-center | ROLLING HILLS CARE CENTER | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
611658 | 611658 | 2020-09-02 | 630014894 | 630014894-veterans-home-of-california-fresno | VETERANS HOME OF CALIFORNIA - FRESNO | Fresno | 1 | 0 | 0 | 0 | 19 | <11 | |||
611660 | 611660 | 2020-09-02 | 230000044 | 230000044-willows-post-acute | WILLOWS POST ACUTE | Glenn | 1 | 0 | 0 | 0 | 21 | <11 | |||
611661 | 611661 | 2020-09-02 | 10000078 | 010000078-eureka-rehab-wellness-center-lp | EUREKA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
611662 | 611662 | 2020-09-02 | 10000075 | 010000075-fortuna-rehabilitation-wellness-center-lp | FORTUNA REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
611663 | 611663 | 2020-09-02 | 10000024 | 010000024-granada-rehab-wellness-center-lp | GRANADA REHAB & WELLNESS CENTER, LP | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
611664 | 611664 | 2020-09-02 | 110000621 | 110000621-jerold-phelps-community-hospital-d-p-snf | JEROLD PHELPS COMMUNITY HOSPITAL D/P SNF | Humboldt | 0 | 0 | 0 | 0 | 23 | ||||
611666 | 611666 | 2020-09-02 | 10000060 | 010000060-seaview-rehabilitation-wellness-center-lp | SEAVIEW REHABILITATION & WELLNESS CENTER, LP | Humboldt | 1 | 0 | 0 | 0 | 23 | <11 | |||
611671 | 611671 | 2020-09-02 | 240001102 | 240001102-southern-inyo-hospital-d-p-snf | SOUTHERN INYO HOSPITAL D/P SNF | Inyo | 0 | 0 | 0 | 0 | 27 | ||||
611672 | 611672 | 2020-09-02 | 120000399 | 120000399-adventist-health-delano-d-p-snf | ADVENTIST HEALTH DELANO D/P SNF | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
611673 | 611673 | 2020-09-02 | 120000323 | 120000323-bella-sera | BELLA SERA | Kern | 0 | 0 | 0 | 0 | 29 | ||||
611681 | 611681 | 2020-09-02 | 630013665 | 630013665-ridgecrest-regional-transitional-care-and-rehabilitation-unit | RIDGECREST REGIONAL TRANSITIONAL CARE AND REHABILITATION UNIT | Kern | 0 | 0 | 0 | 0 | 29 | ||||
611688 | 611688 | 2020-09-02 | 120000325 | 120000325-valley-view-care-center | VALLEY VIEW CARE CENTER | Kern | 1 | 0 | 0 | 0 | 29 | <11 | |||
611692 | 611692 | 2020-09-02 | 40001364 | 040001364-hanford-post-acute | HANFORD POST ACUTE | Kings | 1 | 0 | 0 | 0 | 31 | <11 | |||
611695 | 611695 | 2020-09-02 | 110001250 | 110001250-meadowood-nursing-center | MEADOWOOD NURSING CENTER | Lake | 1 | 0 | 0 | 0 | 33 | <11 | |||
611696 | 611696 | 2020-09-02 | 110001248 | 110001248-rocky-point-care-center | ROCKY POINT CARE CENTER | Lake | 0 | 0 | 0 | 0 | 33 | ||||
611697 | 611697 | 2020-09-02 | 230000039 | 230000039-lassen-nursing-rehabilitation-center | LASSEN NURSING & REHABILITATION CENTER | Lassen | 0 | 0 | 0 | 0 | 35 | ||||
611700 | 611700 | 2020-09-02 | 940000062 | 940000062-alamitos-belmont-rehabilitation-hospital | ALAMITOS BELMONT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611701 | 611701 | 2020-09-02 | 970000001 | 970000001-alcott-rehabilitation-hospital | ALCOTT REHABILITATION HOSPITAL | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
611705 | 611705 | 2020-09-02 | 930000793 | 930000793-alhambra-hospital-medical-center-d-p-snf | ALHAMBRA HOSPITAL MEDICAL CENTER D/P SNF | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611714 | 611714 | 2020-09-02 | 940000093 | 940000093-artesia-christian-home-inc | ARTESIA CHRISTIAN HOME INC. | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611727 | 611727 | 2020-09-02 | 940000010 | 940000010-bel-vista-healthcare-center | BEL VISTA HEALTHCARE CENTER | Los Angeles | 1 | 0 | 1 | 0 | 37 | <11 | <11 | ||
611730 | 611730 | 2020-09-02 | 910000014 | 910000014-berkley-east-healthcare-center | BERKLEY EAST HEALTHCARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611732 | 611732 | 2020-09-02 | 910000013 | 910000013-berkley-west-healthcare-center | BERKLEY WEST HEALTHCARE CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
611754 | 611754 | 2020-09-02 | 930000669 | 930000669-catalina-island-medical-center-d-p-snf | CATALINA ISLAND MEDICAL CENTER D/P SNF | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
611763 | 611763 | 2020-09-02 | 950000002 | 950000002-claremont-care-center | CLAREMONT CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611766 | 611766 | 2020-09-02 | 910000025 | 910000025-clear-view-sanitarium | CLEAR VIEW SANITARIUM | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611767 | 611767 | 2020-09-02 | 950000047 | 950000047-coast-care-convalescent-center | COAST CARE CONVALESCENT CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611795 | 611795 | 2020-09-02 | 920000051 | 920000051-desert-canyon-post-acute-llc | DESERT CANYON POST ACUTE, LLC | Los Angeles | 1 | 0 | 0 | 1 | 37 | <11 | <11 | ||
611798 | 611798 | 2020-09-02 | 920000015 | 920000015-dreier-s-nursing-care-center | DREIER'S NURSING CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611802 | 611802 | 2020-09-02 | 940000043 | 940000043-edgewater-skilled-nursing-center | EDGEWATER SKILLED NURSING CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611807 | 611807 | 2020-09-02 | 950000236 | 950000236-emanate-health-hospice | EMANATE HEALTH HOSPICE | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611808 | 611808 | 2020-09-02 | 930001498 | 930001498-emanate-health-inter-community-hospital-d-p-snf | EMANATE HEALTH INTER-COMMUNITY HOSPITAL, D/P SNF | Los Angeles | 12 | 0 | 0 | 0 | 37 | ||||
611809 | 611809 | 2020-09-02 | 930000865 | 930000865-encino-hospital-medical-center | ENCINO HOSPITAL MEDICAL CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611810 | 611810 | 2020-09-02 | 950000006 | 950000006-fidelity-health-care | FIDELITY HEALTH CARE | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611811 | 611811 | 2020-09-02 | 910000038 | 910000038-fireside-health-care-center | FIRESIDE HEALTH CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611816 | 611816 | 2020-09-02 | 970000062 | 970000062-garden-crest-rehabilitation-center | GARDEN CREST REHABILITATION CENTER | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
611817 | 611817 | 2020-09-02 | 950000023 | 950000023-garden-view-post-acute-rehabilitation | GARDEN VIEW POST-ACUTE REHABILITATION | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611838 | 611838 | 2020-09-02 | 930001562 | 930001562-greater-el-monte-community-hospital-d-p-snf | GREATER EL MONTE COMMUNITY HOSPITAL D/P SNF | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611844 | 611844 | 2020-09-02 | 950000046 | 950000046-harvard-creek-post-acute | HARVARD CREEK POST ACUTE | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611850 | 611850 | 2020-09-02 | 920000068 | 920000068-holiday-manor-care-center | HOLIDAY MANOR CARE CENTER | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611853 | 611853 | 2020-09-02 | 930000575 | 930000575-hollywood-presbyterian-medical-center-d-p-snf | HOLLYWOOD PRESBYTERIAN MEDICAL CENTER D/P SNF | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611866 | 611866 | 2020-09-02 | 940000064 | 940000064-intercommunity-healthcare-rehabilitation-center | INTERCOMMUNITY HEALTHCARE & REHABILITATION CENTER | Los Angeles | 12 | 0 | 0 | 1 | 37 | <11 | |||
611887 | 611887 | 2020-09-02 | 910000054 | 910000054-little-sisters-of-the-poor | LITTLE SISTERS OF THE POOR | Los Angeles | 1 | 0 | 0 | 0 | 37 | <11 | |||
611893 | 611893 | 2020-09-02 | 940000101 | 940000101-long-beach-post-acute | LONG BEACH POST ACUTE | Los Angeles | 0 | 0 | 0 | 0 | 37 | ||||
611895 | 611895 | 2020-09-02 | 930001558 | 930001558-los-angeles-community-hospital-d-p-snf | LOS ANGELES COMMUNITY HOSPITAL D/P SNF | Los Angeles | 1 | 0 | 0 | 0 | 37 | <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 );