nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
31 rows where With a Resident and Family Council = "Family"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Legal Business Name, Continuing Care Retirement Community, Abuse Icon, Most Recent Health Inspection More Than 2 Years Ago, Provider Changed Ownership in Last 12 Months, Overall Rating, Overall Rating Footnote, Health Inspection Rating, Health Inspection Rating Footnote, QM Rating, QM Rating Footnote, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Reported Nurse Aide Staffing Hours per Resident per Day, Reported LPN Staffing Hours per Resident per Day, Reported RN Staffing Hours per Resident per Day, Reported Licensed Staffing Hours per Resident per Day, Reported Total Nurse Staffing Hours per Resident per Day, Reported Physical Therapist Staffing Hours per Resident Per Day, Case-Mix Nurse Aide Staffing Hours per Resident per Day, Case-Mix LPN Staffing Hours per Resident per Day, Case-Mix RN Staffing Hours per Resident per Day, Case-Mix Total Nurse Staffing Hours per Resident per Day, Adjusted Nurse Aide Staffing Hours per Resident per Day, Adjusted LPN Staffing Hours per Resident per Day, Adjusted RN Staffing Hours per Resident per Day, Adjusted Total Nurse Staffing Hours per Resident per Day, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 1 Total Health Score, Rating Cycle 2 Standard Health Survey Date, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Health Revisit Score, Rating Cycle 3 Total Health Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Number of Payment Denials, Total Number of Penalties, Location, Rating Cycle 3 Standard Health Survey Date (date)
Link | rowid ▼ | address | lat | lng | geocode_flag | geocode_accuracy | prvdr_nmbr | prvdr_nm | prvdr_add | prvdr_city | prvdr_state | prvdr_zip | prvdr_phn | prvdr_cnty | prvdr_cnty_name | ownership | nmbr_beds | avg_residents | prvdr_type | Provider Resides in Hospital | Legal Business Name | Date First Approved to Provide Medicare and Medicaid services | Continuing Care Retirement Community | Special Focus Status | Abuse Icon | Most Recent Health Inspection More Than 2 Years Ago | Provider Changed Ownership in Last 12 Months | With a Resident and Family Council | Automatic Sprinkler Systems in All Required Areas | Overall Rating | Overall Rating Footnote | Health Inspection Rating | Health Inspection Rating Footnote | QM Rating | QM Rating Footnote | Long-Stay QM Rating | Long-Stay QM Rating Footnote | Short-Stay QM Rating | Short-Stay QM Rating Footnote | Staffing Rating | Staffing Rating Footnote | RN Staffing Rating | RN Staffing Rating Footnote | Reported Staffing Footnote | Physical Therapist Staffing Footnote | Reported Nurse Aide Staffing Hours per Resident per Day | Reported LPN Staffing Hours per Resident per Day | Reported RN Staffing Hours per Resident per Day | Reported Licensed Staffing Hours per Resident per Day | Reported Total Nurse Staffing Hours per Resident per Day | Reported Physical Therapist Staffing Hours per Resident Per Day | Case-Mix Nurse Aide Staffing Hours per Resident per Day | Case-Mix LPN Staffing Hours per Resident per Day | Case-Mix RN Staffing Hours per Resident per Day | Case-Mix Total Nurse Staffing Hours per Resident per Day | Adjusted Nurse Aide Staffing Hours per Resident per Day | Adjusted LPN Staffing Hours per Resident per Day | Adjusted RN Staffing Hours per Resident per Day | Adjusted Total Nurse Staffing Hours per Resident per Day | Rating Cycle 1 Standard Survey Health Date | Rating Cycle 1 Total Number of Health Deficiencies | Rating Cycle 1 Number of Standard Health Deficiencies | Rating Cycle 1 Number of Complaint Health Deficiencies | Rating Cycle 1 Health Deficiency Score | Rating Cycle 1 Number of Health Revisits | Rating Cycle 1 Health Revisit Score | Rating Cycle 1 Total Health Score | Rating Cycle 2 Standard Health Survey Date | Rating Cycle 2 Total Number of Health Deficiencies | Rating Cycle 2 Number of Standard Health Deficiencies | Rating Cycle 2 Number of Complaint Health Deficiencies | Rating Cycle 2 Health Deficiency Score | Rating Cycle 2 Number of Health Revisits | Rating Cycle 2 Health Revisit Score | Rating Cycle 2 Total Health Score | Rating Cycle 3 Standard Health Survey Date | Rating Cycle 3 Total Number of Health Deficiencies | Rating Cycle 3 Number of Standard Health Deficiencies | Rating Cycle 3 Number of Complaint Health Deficiencies | Rating Cycle 3 Number of Health Revisits | Rating Cycle 3 Health Deficiency Score | Rating Cycle 3 Health Revisit Score | Rating Cycle 3 Total Health Score | Total Weighted Health Survey Score | Number of Facility Reported Incidents | Number of Substantiated Complaints | Number of Fines | Total Amount of Fines in Dollars | Number of Payment Denials | Total Number of Penalties | Location | Processing Date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
234 | 234 | 700 WEST BLACK ROAD SHOREWOOD, IL 60404 | 41.536018 | -88.20584 | 0 | 146183 | ALDEN COURTS OF SHOREWOOD | 700 WEST BLACK ROAD | SHOREWOOD | IL | 60404 | 8152308700 | 989 | Will | For profit - Corporation | 50 | 40.6 | Medicare and Medicaid | false | ALDEN COURTS OF SHOREWOOD, INC | 05/23/2017 | false | false | false | false | Family | Yes | 4 | 4 | 3 | 4 | 2 | 4 | 5 | 2.26083 | 0.31093 | 1.84584 | 2.15677 | 4.4176 | 0.1415 | 2.29087 | 0.83273 | 0.38567 | 3.50927 | 2.05109 | 0.28076 | 1.80139 | 4.03667 | 08/15/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 07/27/2018 | 7 | 6 | 1 | 48 | 1 | 0 | 48 | 2017-05-04 | 1 | 0 | 1 | 0 | 4 | 0 | 4 | 24.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 700 WEST BLACK ROAD SHOREWOOD, IL 60404 (41.536018, -88.20584) | 02/01/2020 | |||||||||||
263 | 263 | 6163 SUMMER STREET HONOLULU, HI 96821 | 21.285518 | -157.720798 | 0 | 125050 | HALE MALAMALAMA | 6163 SUMMER STREET | HONOLULU | HI | 96821 | 8083960537 | 20 | Honolulu | For profit - Corporation | 40 | 38.8 | Medicare and Medicaid | false | ONO ENTERPRISE LTD | 09/16/1999 | false | false | false | false | Family | Yes | 4 | 3 | 5 | 5 | 2 | 3 | 5 | 2.19471 | 0 | 0.88137 | 0.88137 | 3.07608 | 0.00256 | 2.26573 | 0.65013 | 0.2997 | 3.21556 | 2.01319 | 0 | 1.10689 | 3.06756 | 07/01/2019 | 9 | 9 | 0 | 36 | 1 | 0 | 36 | 07/20/2018 | 9 | 9 | 0 | 36 | 1 | 0 | 36 | 2017-05-19 | 9 | 9 | 0 | 1 | 64 | 0 | 64 | 40.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 6163 SUMMER STREET HONOLULU, HI 96821 (21.285518, -157.720798) | 02/01/2020 | |||||||||||
2680 | 2680 | 1962 VANDOLAH RD WAUCHULA, FL 33873 | 27.545127 | -81.921193 | 0 | 106054 | LAKESIDE NEUROLOGIC | 1962 VANDOLAH RD | WAUCHULA | FL | 33873 | 8637732857 | 240 | Hardee | For profit - Limited Liability company | 25 | 4.8 | Medicare and Medicaid | false | SF III FNH LLC | 07/16/2003 | false | false | false | false | Family | Yes | 5 | 5 | 2 | 2 | 2 | 5 | 5 | 4.80862 | 1.13424 | 6.02948 | 7.16372 | 11.97234 | 0.04195 | 2.55266 | 1.01504 | 0.89383 | 4.46153 | 3.9151 | 0.84024 | 2.53895 | 8.60494 | 06/13/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 03/29/2018 | 3 | 3 | 0 | 28 | 1 | 0 | 28 | 2017-04-27 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 11.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1962 VANDOLAH RD WAUCHULA, FL 33873 (27.545127, -81.921193) | 02/01/2020 | |||||||||||
2706 | 2706 | 251 IN-66, New Harmony, IN 47631, USA | 38.1307792 | -87.92187419999999 | 1 | ROOFTOP | 155370 | PREMIER HEALTHCARE OF NEW HARMONY | 251 HIGHWAY 66 | NEW HARMONY | IN | 47631 | 8126824104 | 640 | Posey | For profit - Corporation | 96 | 50.9 | Medicare and Medicaid | false | DAVIESS COUNTY HOSPITAL | 02/08/1991 | false | false | false | false | Family | Yes | 3 | 2 | 5 | 5 | 4 | 2 | 3 | 1.81567 | 0.51287 | 0.65447 | 1.16734 | 2.983 | 0 | 2.16411 | 0.80515 | 0.41565 | 3.38492 | 1.7437 | 0.47898 | 0.59264 | 2.82591 | 01/09/2019 | 9 | 9 | 0 | 52 | 1 | 0 | 52 | 11/08/2017 | 10 | 7 | 10 | 72 | 1 | 0 | 72 | 2016-09-06 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 53.333 | 0 | 5 | 1 | 8510.00 | 0 | 1 | 02/01/2020 | |||||||||||
3507 | 3507 | 150 NEW PROVIDENCE ROAD MOUNTAINSIDE, NJ 07092 | 40.668692 | -74.353977 | 0 | 315239 | CHILDRENS SPECIALIZED HOSPITAL MOUNTAINSIDE | 150 NEW PROVIDENCE ROAD | MOUNTAINSIDE | NJ | 7092 | 9082333720 | 370 | Union | Non profit - Other | 46 | 44.7 | Medicare and Medicaid | true | Legal Business Name Not Available | 10/06/1986 | false | false | false | false | Family | Yes | 4 | 2 | 5 | 5 | 2 | 4 | 4 | 2.7327 | 1.33287 | 2.41396 | 3.74683 | 6.47953 | 0.06525 | 2.41554 | 0.99556 | 1.19563 | 4.60673 | 2.35122 | 1.00671 | 0.75991 | 4.51028 | 10/22/2019 | 3 | 2 | 1 | 16 | 0 | 0 | 16 | 10/26/2018 | 6 | 5 | 1 | 40 | 1 | 0 | 40 | 2017-08-02 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 22.667 | 0 | 4 | 0 | 0.00 | 0 | 0 | 150 NEW PROVIDENCE ROAD MOUNTAINSIDE, NJ 07092 (40.668692, -74.353977) | 02/01/2020 | |||||||||||
4129 | 4129 | 1991 RANDI DRIVE AURORA, IL 60504 | 41.737378 | -88.269099 | 0 | 146182 | ALDEN COURTS OF WATERFORD | 1991 RANDI DRIVE | AURORA | IL | 60504 | 6308511466 | 530 | Kane | For profit - Corporation | 20 | 18.1 | Medicare and Medicaid | false | ALDEN COURTS OF WATERFORD LLC | 03/20/2017 | false | false | false | false | Family | Yes | 5 | 5 | 2 | 3 | 1 | 4 | 5 | 1.9854 | 0 | 1.43754 | 1.43754 | 3.42294 | 0.14739 | 2.20255 | 0.82994 | 0.35624 | 3.38873 | 1.87343 | 0 | 1.51884 | 3.23903 | 09/19/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 10/12/2018 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-12-07 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 13.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1991 RANDI DRIVE AURORA, IL 60504 (41.737378, -88.269099) | 02/01/2020 | |||||||||||
4522 | 4522 | 1100 EAST MARKET STREET LOUISVILLE, KY 40206 | 38.252548 | -85.732128 | 0 | 185154 | HOME OF THE INNOCENTS | 1100 EAST MARKET STREET | LOUISVILLE | KY | 40206 | 5025961000 | 550 | Jefferson | Non profit - Corporation | 76 | 73.8 | Medicare and Medicaid | false | Legal Business Name Not Available | 06/12/1978 | false | false | false | false | Family | Yes | 2 | 1 | 4 | 4 | 2 | 4 | 4 | 4.03513 | 2.91321 | 2.01285 | 4.92606 | 8.96119 | 0.13388 | 2.34308 | 0.94155 | 0.77718 | 4.06181 | 3.57921 | 2.32654 | 0.97481 | 7.07456 | 08/30/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 07/07/2017 | 8 | 3 | 5 | 294 | 1 | 0 | 294 | 2016-05-12 | 2 | 2 | 0 | 1 | 16 | 0 | 16 | 100.667 | 1 | 0 | 1 | 13627.00 | 0 | 1 | 1100 EAST MARKET STREET LOUISVILLE, KY 40206 (38.252548, -85.732128) | 02/01/2020 | |||||||||||
5205 | 5205 | 694 Worcester St, Wellesley, MA 02482, USA | 42.3054929 | -71.2967937 | 1 | ROOFTOP | 225222 | NEWTON WELLESLEY CENTER FOR ALZHEIMER'S CARE | 694 WORCESTER RD | WELLESLEY FMS | MA | 2181 | 7812376400 | 130 | Norfolk | For profit - Corporation | 110 | 107.5 | Medicare and Medicaid | false | VK WELLESLEY LLC | 06/01/1974 | false | false | false | false | Family | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 3 | 2.15581 | 0.66689 | 0.48703 | 1.15391 | 3.30972 | 0.04276 | 2.43793 | 0.63416 | 0.31019 | 3.38227 | 1.83783 | 0.79075 | 0.59097 | 3.13788 | 11/06/2018 | 4 | 2 | 2 | 20 | 1 | 0 | 20 | 07/27/2017 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 2016-09-16 | 7 | 7 | 0 | 1 | 36 | 0 | 36 | 20 | 1 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
5592 | 5592 | 61 W JIMMIE LEEDS ROAD POMONA, NJ 08240 | 39.476252 | -74.539394 | 0 | 315495 | RENAISSANCE PAVILION | 61 W JIMMIE LEEDS ROAD | POMONA | NJ | 8240 | 6094043287 | 0 | Atlantic | Non profit - Corporation | 30 | 25.7 | Medicare | true | BACHARACH INSTITUTE FOR REHABILITATION, INC. | 02/22/2006 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 2 | 5 | 5 | 5 | 2.86075 | 1.06831 | 2.27048 | 3.33879 | 6.19954 | 0.89802 | 2.18766 | 1.05448 | 0.65274 | 3.89488 | 2.71779 | 0.7618 | 1.30922 | 5.10409 | 03/15/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 04/26/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-05-02 | 1 | 1 | 0 | 1 | 16 | 0 | 16 | 2.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 61 W JIMMIE LEEDS ROAD POMONA, NJ 08240 (39.476252, -74.539394) | 02/01/2020 | |||||||||||
5882 | 5882 | 2 PENROSE BLVD COLORADO SPRINGS, CO 80906 | 38.786219 | -104.858447 | 0 | 06A196 | NAMASTE ALZHEIMER CENTER | 2 PENROSE BLVD | COLORADO SPRINGS | CO | 80906 | 7194424240 | 200 | El Paso | Non profit - Corporation | 64 | 63 | Medicaid | false | Legal Business Name Not Available | 05/29/2003 | false | true | false | false | Family | Yes | 2 | 1 | 5 | 5 | 2 | 4 | 4 | 2.56191 | 0.42351 | 0.53411 | 0.95761 | 3.51952 | 0 | 2.01156 | 0.58379 | 0.24957 | 2.84492 | 2.64695 | 0.54549 | 0.80552 | 3.96704 | 12/10/2019 | 16 | 11 | 5 | 104 | 1 | 0 | 104 | 11/15/2018 | 11 | 10 | 10 | 100 | 1 | 0 | 100 | 2017-03-09 | 16 | 12 | 4 | 1 | 88 | 0 | 88 | 100 | 0 | 12 | 0 | 0.00 | 0 | 0 | 2 PENROSE BLVD COLORADO SPRINGS, CO 80906 (38.786219, -104.858447) | 02/01/2020 | |||||||||||
6146 | 6146 | 252 W 5th St, La Center, KY 42056, USA | 37.0786856 | -88.9762762 | 1 | ROOFTOP | 185320 | LIFE CARE CENTER OF LA CENTER | 252 W. 5TH STREET | LA CENTER | KY | 42056 | 2706655681 | 30 | Ballard | For profit - Individual | 70 | 55.1 | Medicare and Medicaid | false | LA CENTER OPERATIONS LLC | 02/01/1992 | false | false | false | false | Family | Yes | 3 | 3 | 2 | 2 | 1 | 3 | 4 | 2.19705 | 0.59558 | 0.83524 | 1.43082 | 3.62787 | 0.06914 | 2.13852 | 0.81293 | 0.42017 | 3.37161 | 2.13522 | 0.5509 | 0.7482 | 3.45038 | 09/27/2018 | 6 | 6 | 0 | 36 | 1 | 0 | 36 | 07/27/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-07-08 | 4 | 4 | 0 | 1 | 16 | 0 | 16 | 20.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
6915 | 6915 | 210 EAST COLLEGE ENERGY, IL 62933 | 37.773915 | -89.023648 | 0 | 146045 | HELIA HEALTHCARE OF ENERGY | 210 EAST COLLEGE, PO BOX 519 | ENERGY | IL | 62933 | 6189427014 | 990 | Williamson | For profit - Corporation | 91 | 54.1 | Medicare and Medicaid | false | HELIA HEALTHCARE OF ENERGY LLC | 02/14/2003 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 5 | 3 | 4 | 2.06474 | 0.4472 | 1.02135 | 1.46855 | 3.53329 | 0.08857 | 2.41715 | 0.84777 | 0.39897 | 3.66389 | 1.77533 | 0.39665 | 0.96354 | 3.09236 | 12/13/2018 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 11/17/2017 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2016-12-16 | 11 | 9 | 2 | 1 | 60 | 0 | 60 | 16.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 210 EAST COLLEGE ENERGY, IL 62933 (37.773915, -89.023648) | 02/01/2020 | |||||||||||
7369 | 7369 | 94 STEVENS ROAD TOMS RIVER, NJ 08755 | 40.011561 | -74.220903 | 0 | 315443 | CHILDRENS SPECIALIZED HOSPITAL TOMS RIVER | 94 STEVENS ROAD | TOMS RIVER | NJ | 8755 | 7327973800 | 310 | Ocean | Non profit - Other | 26 | 21.2 | Medicare and Medicaid | true | Legal Business Name Not Available | 06/23/1997 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 2 | 5 | 5 | 2.98312 | 0.91843 | 2.67833 | 3.59676 | 6.57988 | 0.20952 | 2.21251 | 0.87047 | 0.37476 | 3.45774 | 2.80222 | 0.79337 | 2.68994 | 6.1021 | 09/16/2019 | 1 | 1 | 0 | 8 | 0 | 0 | 8 | 10/16/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-08-10 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 4.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 94 STEVENS ROAD TOMS RIVER, NJ 08755 (40.011561, -74.220903) | 02/01/2020 | |||||||||||
7446 | 7446 | 78 BOSTON ROAD NORTH BILLERICA, MA 01862 | 42.592554 | -71.297104 | 0 | 22A345 | NEW ENGLAND PEDIATRIC CARE | 78 BOSTON ROAD | NORTH BILLERICA | MA | 1862 | 9786675123 | 90 | Middlesex | For profit - Corporation | 80 | 73.5 | Medicaid | false | Legal Business Name Not Available | 10/17/1986 | false | false | false | false | Family | Yes | 5 | 4 | 5 | 5 | 2 | 4 | 4 | 3.13047 | 1.28557 | 1.49412 | 2.77969 | 5.91016 | 0.09712 | 2.39129 | 0.97059 | 0.73266 | 4.09454 | 2.72078 | 0.99596 | 0.76756 | 4.62857 | 04/25/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 05/02/2018 | 2 | 2 | 0 | 24 | 1 | 0 | 24 | 2017-02-13 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 18 | 0 | 0 | 0 | 0.00 | 0 | 0 | 78 BOSTON ROAD NORTH BILLERICA, MA 01862 (42.592554, -71.297104) | 02/01/2020 | |||||||||||
8435 | 8435 | 1040 LINCOLN AVENUE DETROIT LAKES, MN 56501 | 46.814181 | -95.843354 | 0 | 245212 | ESSENTIA HEALTH OAK CROSSING | 1040 LINCOLN AVENUE | DETROIT LAKES | MN | 56501 | 2188440700 | 20 | Becker | Non profit - Corporation | 94 | 82 | Medicare and Medicaid | true | ST MARYS REGIONAL HEALTH CENTER | 11/01/1976 | false | false | false | false | Family | Yes | 5 | 5 | 4 | 4 | 3 | 5 | 5 | 3.39768 | 0.69781 | 1.10805 | 1.80587 | 5.20355 | 0.06193 | 2.00067 | 0.63614 | 0.28681 | 2.92362 | 3.52958 | 0.82484 | 1.45413 | 5.70732 | 08/29/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 07/26/2018 | 7 | 7 | 0 | 32 | 1 | 0 | 32 | 2017-08-17 | 3 | 3 | 0 | 1 | 8 | 0 | 8 | 14 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1040 LINCOLN AVENUE DETROIT LAKES, MN 56501 (46.814181, -95.843354) | 02/01/2020 | |||||||||||
9427 | 9427 | 3777 SOUTH BASCOM AVENUE CAMPBELL, CA 95008 | 37.259733 | -121.947002 | 0 | 555734 | CHILDREN'S RECOVERY CENTER OF NO CA D/P SNF | 3777 SOUTH BASCOM AVENUE | CAMPBELL | CA | 95008 | 4085583640 | 530 | Santa Clara | For profit - Corporation | 27 | 24.8 | Medicare and Medicaid | false | CHILDRENS RECOVERY CENTER 1 LLC | 03/03/1999 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 2 | 4 | 4 | 4.55003 | 3.49351 | 3.1214 | 6.6149 | 11.16493 | 0 | 2.45737 | 1.09525 | 1.39743 | 4.95005 | 3.84822 | 2.39845 | 0.84072 | 7.23269 | 10/31/2019 | 7 | 7 | 0 | 32 | 1 | 0 | 32 | 02/27/2019 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 2018-02-22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 21.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3777 SOUTH BASCOM AVENUE CAMPBELL, CA 95008 (37.259733, -121.947002) | 02/01/2020 | |||||||||||
9438 | 9438 | 4060 E WHITTIER BLVD LOS ANGELES, CA 90023 | 34.02393 | -118.184285 | 0 | 555255 | EAST LOS ANGELES DOCTORS HOSP | 4060 E. WHITTIER BLVD. | LOS ANGELES | CA | 90023 | 3232604230 | 200 | Los Angeles | For profit - Corporation | 25 | 23.3 | Medicare and Medicaid | true | ELADH LP | 01/13/1987 | false | false | false | false | Family | Yes | 2 | 2 | 4 | 4 | 2 | 3 | 2 | 3.31302 | 3.283 | 1.48985 | 4.77285 | 8.08587 | 0.01527 | 2.49539 | 1.09704 | 1.69799 | 5.29042 | 2.75932 | 2.25027 | 0.33025 | 4.90106 | 11/10/2019 | 16 | 14 | 2 | 80 | 1 | 0 | 80 | 11/04/2018 | 20 | 17 | 3 | 120 | 1 | 0 | 120 | 2017-11-04 | 11 | 11 | 0 | 1 | 44 | 0 | 44 | 87.333 | 4 | 3 | 0 | 0.00 | 0 | 0 | 4060 E WHITTIER BLVD LOS ANGELES, CA 90023 (34.02393, -118.184285) | 02/01/2020 | |||||||||||
9502 | 9502 | 100 S RAYMOND AVE ALHAMBRA, CA 91801 | 34.090156 | -118.145017 | 0 | 555850 | ALHAMBRA HOSPITAL MED CTR DP/SNF | 100 S RAYMOND AVE | ALHAMBRA | CA | 91801 | 6265701606 | 200 | Los Angeles | For profit - Partnership | 26 | 24.7 | Medicare and Medicaid | true | ALHAMBRA HOSPITAL MEDICAL CENTER, LP | 04/01/2008 | false | false | false | false | Family | Yes | 5 | 4 | 5 | 5 | 2 | 4 | 3 | 3.06855 | 1.53816 | 2.72668 | 4.26484 | 7.33339 | 0.02391 | 2.49169 | 1.10909 | 1.64419 | 5.24498 | 2.5595 | 1.04284 | 0.62418 | 4.48347 | 08/01/2019 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 07/24/2018 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 2017-07-15 | 10 | 10 | 0 | 1 | 48 | 0 | 48 | 34.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 100 S RAYMOND AVE ALHAMBRA, CA 91801 (34.090156, -118.145017) | 02/01/2020 | |||||||||||
9804 | 9804 | 1400 WEST 21ST STREET CLOVIS, NM 88101 | 34.41931 | -103.222421 | 0 | 325076 | ST ANTHONY HEALTHCARE AND REHAB CENTER, L | 1400 WEST 21ST STREET | CLOVIS | NM | 88101 | 5757624705 | 40 | Curry | Non profit - Corporation | 70 | 40.2 | Medicare and Medicaid | false | ST. ANTHONY HEALTHCARE AND REHABILITATION CENTER, LLC | 09/01/1992 | false | false | false | false | Family | Yes | 3 | 2 | 2 | 1 | 4 | 4 | 4 | 1.86492 | 0.8473 | 0.65039 | 1.49769 | 3.36261 | 0.13379 | 2.04442 | 0.6605 | 0.30017 | 3.00509 | 1.89586 | 0.96461 | 0.81551 | 3.58816 | 05/22/2019 | 24 | 19 | 5 | 140 | 1 | 0 | 140 | 04/13/2018 | 17 | 17 | 0 | 160 | 1 | 0 | 160 | 2017-02-24 | 7 | 7 | 0 | 1 | 68 | 0 | 68 | 134.667 | 4 | 5 | 1 | 9753.00 | 1 | 2 | 1400 WEST 21ST STREET CLOVIS, NM 88101 (34.41931, -103.222421) | 02/01/2020 | |||||||||||
9943 | 9943 | 1700 WOODGATE DRIVE WACO, TX 76712 | 31.481902 | -97.215745 | 0 | 676211 | WESLEY WOODS HEALTH & REHABILITATION | 1700 WOODGATE DRIVE | WACO | TX | 76712 | 2546665454 | 780 | Mc Lennan | For profit - Limited Liability company | 120 | 99.3 | Medicare and Medicaid | false | CORYELL COUNTY MEMORIAL HOSPITAL AUTHORITY | 02/01/2009 | false | false | false | false | Family | Yes | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2.67031 | 0.93294 | 0.35521 | 1.28815 | 3.95846 | 0.03277 | 2.14479 | 0.79274 | 0.41839 | 3.35591 | 2.58757 | 0.88493 | 0.31955 | 3.78241 | 05/30/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 04/18/2018 | 8 | 7 | 1 | 52 | 1 | 0 | 52 | 2017-03-08 | 7 | 2 | 5 | 1 | 116 | 0 | 116 | 44.667 | 1 | 2 | 1 | 6840.00 | 0 | 1 | 1700 WOODGATE DRIVE WACO, TX 76712 (31.481902, -97.215745) | 02/01/2020 | |||||||||||
10729 | 10729 | 2802 PAPERMILL ROAD WYOMISSING, PA 19610 | 40.360926 | -75.988508 | 0 | 395941 | TRANSITIONAL SUB-ACUTE UNIT | 2802 PAPERMILL ROAD | WYOMISSING | PA | 19610 | 4843882721 | 110 | Berks | Non profit - Corporation | 50 | 48.6 | Medicare | true | READING HOSPITAL | 10/05/1994 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 2 | 5 | 5 | 5 | 2.80142 | 0 | 3.68218 | 3.68218 | 6.48361 | 0.71699 | 1.88445 | 0.96342 | 0.55806 | 3.40593 | 3.08966 | 0 | 2.48344 | 6.10427 | 06/28/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 06/14/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-05-18 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 0.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2802 PAPERMILL ROAD WYOMISSING, PA 19610 (40.360926, -75.988508) | 02/01/2020 | |||||||||||
11492 | 11492 | 400 SEXTON STREET STRUTHERS, OH 44471 | 41.053872 | -80.606471 | 0 | 366191 | MAPLECREST NURSING AND HTA | 400 SEXTON STREET | STRUTHERS | OH | 44471 | 3307551466 | 510 | Mahoning | For profit - Corporation | 55 | 49.9 | Medicare and Medicaid | false | CRED KAP INC | 03/01/2000 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 2.21813 | 1.13167 | 0.42929 | 1.56096 | 3.77909 | 0.01583 | 2.04543 | 0.78455 | 0.38396 | 3.21394 | 2.25381 | 1.08464 | 0.42081 | 3.77053 | 08/29/2019 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 06/21/2018 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 2017-04-27 | 3 | 2 | 1 | 1 | 24 | 0 | 24 | 8 | 0 | 2 | 1 | 6500.00 | 0 | 1 | 400 SEXTON STREET STRUTHERS, OH 44471 (41.053872, -80.606471) | 02/01/2020 | |||||||||
11927 | 11927 | 1739 KIRBY ROAD MC LEAN, VA 22101 | 38.920087 | -77.154866 | 0 | 495410 | ARLEIGH BURKE PAVILION | 1739 KIRBY ROAD | MC LEAN | VA | 22101 | 7035066900 | 290 | Fairfax | Non profit - Corporation | 49 | 45.3 | Medicare | false | VINSON HALL LLC | 12/17/2012 | true | false | true | false | Family | Yes | 4 | 4 | 4 | 4 | 5 | 4 | 3 | 2.86775 | 1.56756 | 0.68543 | 2.25299 | 5.12074 | 0.19495 | 2.29365 | 0.78705 | 0.3885 | 3.4692 | 2.59854 | 1.49764 | 0.66405 | 4.73322 | 11/15/2017 | 3 | 3 | 0 | 28 | 1 | 0 | 28 | 11/16/2016 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 2015-11-13 | 2 | 2 | 0 | 1 | 20 | 0 | 20 | 22.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1739 KIRBY ROAD MC LEAN, VA 22101 (38.920087, -77.154866) | 02/01/2020 | |||||||||||
12345 | 12345 | S Hwy 501, Marion, SC 29571, USA | 34.1615973 | -79.39602219999999 | 1 | GEOMETRIC_CENTER | 425416 | SENIOR CARE OF MARION | 2770 S HIGHWAY 501 | MARION | SC | 29571 | 8555738466 | 330 | Marion | For profit - Partnership | 95 | Medicare | false | SENIOR CARE OF MARION LLC | 10/10/2019 | false | false | false | false | Family | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 10/10/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
12962 | 12962 | 250 PANTOPS MOUNTAIN RD CHARLOTTESVILLE, VA 22911 | 38.028877 | -78.438418 | 0 | 495225 | WESTMINSTER CANTERBURY BLUE RI | 250 PANTOPS MOUNTAIN RD | CHARLOTTESVILLE | VA | 22911 | 4349723100 | 10 | Albemarle | Non profit - Corporation | 27 | 20.9 | Medicare and Medicaid | false | WESTMINSTER-CANTERBURY OF THE BLUE RIDGE | 11/21/1990 | true | false | false | false | Family | Yes | 5 | 4 | 5 | 2 | 5 | 5 | 5 | 3.54586 | 0.76112 | 1.44586 | 2.20698 | 5.75284 | 0.45083 | 2.11761 | 0.7926 | 0.40718 | 3.31739 | 3.48009 | 0.72208 | 1.33651 | 5.56082 | 07/18/2019 | 7 | 7 | 0 | 52 | 1 | 0 | 52 | 07/19/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-06-14 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 34.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 250 PANTOPS MOUNTAIN RD CHARLOTTESVILLE, VA 22911 (38.028877, -78.438418) | 02/01/2020 | |||||||||||
13070 | 13070 | WA-902 & Salnave Rd, Medical Lake, WA 99022, USA | 47.55102369999999 | -117.7044559 | 1 | GEOMETRIC_CENTER | 50A263 | LAKELAND VILLAGE NURSING FACILITY | STATE HIGHWAY 902 & SALNAVE ROAD | MEDICAL LAKE | WA | 99022 | 5092991800 | 310 | Spokane | Government - State | 93 | 87.7 | Medicaid | false | Legal Business Name Not Available | 05/23/1994 | false | false | false | false | Family | Yes | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 6 | 6 | 03/19/2019 | 9 | 4 | 5 | 102 | 1 | 0 | 102 | 02/23/2018 | 13 | 12 | 1 | 56 | 1 | 0 | 56 | 2017-01-18 | 7 | 3 | 4 | 1 | 28 | 0 | 28 | 74.333 | 8 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
13614 | 13614 | 4929 VAN NUYS BLVD SHERMAN OAKS, CA 91403 | 34.15981 | -118.448705 | 0 | 555885 | SHERMAN OAKS HOSPITAL SNF DP | 4929 VAN NUYS BLVD | SHERMAN OAKS | CA | 91403 | 8189074540 | 200 | Los Angeles | For profit - Corporation | 22 | 19.8 | Medicare and Medicaid | false | PRIME HEALTHCARE SERVICES-SHERMAN OAKS, LLC | 05/28/2014 | false | false | false | false | Family | Yes | 5 | 4 | 5 | 5 | 2 | 4 | 3 | 4.22029 | 2.66526 | 2.82281 | 5.48807 | 9.70836 | 0 | 2.50314 | 1.07716 | 1.77 | 5.3503 | 3.50406 | 1.86056 | 0.60026 | 5.81863 | 10/30/2019 | 6 | 6 | 0 | 28 | 1 | 0 | 28 | 11/10/2018 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 2017-11-19 | 7 | 7 | 0 | 1 | 28 | 0 | 28 | 29.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 4929 VAN NUYS BLVD SHERMAN OAKS, CA 91403 (34.15981, -118.448705) | 02/01/2020 | |||||||||||
14058 | 14058 | 2601 EAST CHAPMAN AVENUE ORANGE, CA 92869 | 33.787878 | -117.827058 | 0 | 555709 | CHAPMAN GLOBAL MEDICAL CENTER D/P SNF | 2601 EAST CHAPMAN AVENUE | ORANGE | CA | 92869 | 7146330011 | 400 | Orange | For profit - Corporation | 27 | 25 | Medicare and Medicaid | true | CHAPMAN GLOBAL MEDICAL CENTER INC | 08/01/1997 | false | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 2 | 3 | 2 | 3.60117 | 3.29254 | 1.27981 | 4.57235 | 8.17352 | 0 | 2.46583 | 1.13968 | 1.35793 | 4.96343 | 3.03527 | 2.17236 | 0.35473 | 5.28056 | 10/08/2019 | 6 | 5 | 1 | 12 | 1 | 0 | 12 | 12/12/2018 | 5 | 4 | 1 | 28 | 1 | 0 | 28 | 2018-01-09 | 12 | 12 | 0 | 1 | 44 | 0 | 44 | 22.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 2601 EAST CHAPMAN AVENUE ORANGE, CA 92869 (33.787878, -117.827058) | 02/01/2020 | |||||||||||
14278 | 14278 | 800 FRONT STREET HEMPSTEAD, NY 11550 | 40.709383 | -73.601531 | 0 | 335808 | HEMPSTEAD PARK NURSING HOME | 800 FRONT STREET | HEMPSTEAD | NY | 11550 | 5167059700 | 400 | Nassau | For profit - Corporation | 251 | 231.3 | Medicare and Medicaid | false | SUNSHINE CARE CORP | 09/30/1998 | true | false | false | false | Family | Yes | 3 | 3 | 3 | 5 | 1 | 2 | 2 | 1.99163 | 0.65818 | 0.29823 | 0.95641 | 2.94804 | 0.04529 | 1.81234 | 0.70666 | 0.34606 | 2.86506 | 2.28394 | 0.70035 | 0.32437 | 3.29953 | 05/10/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 03/26/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2016-12-22 | 9 | 9 | 0 | 1 | 36 | 0 | 36 | 18 | 0 | 0 | 0 | 0.00 | 0 | 0 | 800 FRONT STREET HEMPSTEAD, NY 11550 (40.709383, -73.601531) | 02/01/2020 | |||||||||||
14378 | 14378 | 1050 E MOUNTAIN VIEW ELLENSBURG, WA 98926 | 46.984636 | -120.531086 | 0 | 505263 | PRESTIGE POST-ACUTE & REHAB CTR - KITTITAS VALLLEY | 1050 E MOUNTAIN VIEW | ELLENSBURG | WA | 98926 | 5099254171 | 180 | Kittitas | For profit - Corporation | 74 | 56.5 | Medicare and Medicaid | false | CARE CENTER ELLENSBURG, INC. | 12/21/1981 | true | false | false | false | Family | Yes | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 2.32941 | 0.76806 | 0.80262 | 1.57069 | 3.9001 | 0.10952 | 2.09318 | 0.72124 | 0.34623 | 3.16066 | 2.31289 | 0.80075 | 0.87252 | 3.95686 | 12/17/2019 | 2 | 0 | 2 | 12 | 1 | 0 | 12 | 10/11/2018 | 13 | 9 | 4 | 64 | 1 | 0 | 64 | 2017-12-18 | 13 | 9 | 4 | 1 | 68 | 0 | 68 | 38.667 | 3 | 3 | 1 | 5000.00 | 0 | 1 | 1050 E MOUNTAIN VIEW ELLENSBURG, WA 98926 (46.984636, -120.531086) | 02/01/2020 | |||||||||||
14838 | 14838 | 110 E LIVE OAK ST AUSTIN, TX 78704 | 30.241778 | -97.752028 | 0 | 675733 | FOCUSED CARE AT STONEBRIAR | 110 E LIVE OAK ST | AUSTIN | TX | 78704 | 5124443511 | 940 | Travis | For profit - Corporation | 134 | 97.5 | Medicare and Medicaid | false | HAMILTON COUNTY HOSPITAL DISTRICT | 09/15/1997 | false | false | false | true | Family | Yes | 3 | 4 | 3 | 2 | 4 | 1 | 1 | 1.7762 | 0.9231 | 0.21238 | 1.13548 | 2.91167 | 0.01586 | 2.07068 | 0.85014 | 0.47197 | 3.39279 | 1.78276 | 0.81647 | 0.16937 | 2.75193 | 01/10/2019 | 4 | 2 | 2 | 28 | 1 | 0 | 28 | 01/25/2018 | 6 | 6 | 0 | 48 | 1 | 0 | 48 | 2017-02-01 | 6 | 5 | 1 | 1 | 44 | 0 | 44 | 37.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 110 E LIVE OAK ST AUSTIN, TX 78704 (30.241778, -97.752028) | 02/01/2020 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [nh_gen_info_geocoded_final] ( [address] TEXT, [lat] TEXT, [lng] TEXT, [geocode_flag] INTEGER, [geocode_accuracy] TEXT, [prvdr_nmbr] INTEGER, [prvdr_nm] TEXT, [prvdr_add] TEXT, [prvdr_city] TEXT, [prvdr_state] TEXT, [prvdr_zip] INTEGER, [prvdr_phn] INTEGER, [prvdr_cnty] INTEGER, [prvdr_cnty_name] TEXT, [ownership] TEXT, [nmbr_beds] INTEGER, [avg_residents] TEXT, [prvdr_type] TEXT, [Provider Resides in Hospital] TEXT, [Legal Business Name] TEXT, [Date First Approved to Provide Medicare and Medicaid services] TEXT, [Continuing Care Retirement Community] TEXT, [Special Focus Status] TEXT, [Abuse Icon] TEXT, [Most Recent Health Inspection More Than 2 Years Ago] TEXT, [Provider Changed Ownership in Last 12 Months] TEXT, [With a Resident and Family Council] TEXT, [Automatic Sprinkler Systems in All Required Areas] TEXT, [Overall Rating] INTEGER, [Overall Rating Footnote] TEXT, [Health Inspection Rating] INTEGER, [Health Inspection Rating Footnote] TEXT, [QM Rating] INTEGER, [QM Rating Footnote] TEXT, [Long-Stay QM Rating] TEXT, [Long-Stay QM Rating Footnote] TEXT, [Short-Stay QM Rating] TEXT, [Short-Stay QM Rating Footnote] TEXT, [Staffing Rating] TEXT, [Staffing Rating Footnote] TEXT, [RN Staffing Rating] TEXT, [RN Staffing Rating Footnote] TEXT, [Reported Staffing Footnote] TEXT, [Physical Therapist Staffing Footnote] TEXT, [Reported Nurse Aide Staffing Hours per Resident per Day] TEXT, [Reported LPN Staffing Hours per Resident per Day] TEXT, [Reported RN Staffing Hours per Resident per Day] TEXT, [Reported Licensed Staffing Hours per Resident per Day] TEXT, [Reported Total Nurse Staffing Hours per Resident per Day] TEXT, [Reported Physical Therapist Staffing Hours per Resident Per Day] TEXT, [Case-Mix Nurse Aide Staffing Hours per Resident per Day] TEXT, [Case-Mix LPN Staffing Hours per Resident per Day] TEXT, [Case-Mix RN Staffing Hours per Resident per Day] TEXT, [Case-Mix Total Nurse Staffing Hours per Resident per Day] TEXT, [Adjusted Nurse Aide Staffing Hours per Resident per Day] TEXT, [Adjusted LPN Staffing Hours per Resident per Day] TEXT, [Adjusted RN Staffing Hours per Resident per Day] TEXT, [Adjusted Total Nurse Staffing Hours per Resident per Day] TEXT, [Rating Cycle 1 Standard Survey Health Date] TEXT, [Rating Cycle 1 Total Number of Health Deficiencies] INTEGER, [Rating Cycle 1 Number of Standard Health Deficiencies] INTEGER, [Rating Cycle 1 Number of Complaint Health Deficiencies] INTEGER, [Rating Cycle 1 Health Deficiency Score] INTEGER, [Rating Cycle 1 Number of Health Revisits] INTEGER, [Rating Cycle 1 Health Revisit Score] INTEGER, [Rating Cycle 1 Total Health Score] INTEGER, [Rating Cycle 2 Standard Health Survey Date] TEXT, [Rating Cycle 2 Total Number of Health Deficiencies] INTEGER, [Rating Cycle 2 Number of Standard Health Deficiencies] INTEGER, [Rating Cycle 2 Number of Complaint Health Deficiencies] INTEGER, [Rating Cycle 2 Health Deficiency Score] INTEGER, [Rating Cycle 2 Number of Health Revisits] INTEGER, [Rating Cycle 2 Health Revisit Score] INTEGER, [Rating Cycle 2 Total Health Score] INTEGER, [Rating Cycle 3 Standard Health Survey Date] TEXT, [Rating Cycle 3 Total Number of Health Deficiencies] INTEGER, [Rating Cycle 3 Number of Standard Health Deficiencies] INTEGER, [Rating Cycle 3 Number of Complaint Health Deficiencies] INTEGER, [Rating Cycle 3 Number of Health Revisits] INTEGER, [Rating Cycle 3 Health Deficiency Score] INTEGER, [Rating Cycle 3 Health Revisit Score] INTEGER, [Rating Cycle 3 Total Health Score] INTEGER, [Total Weighted Health Survey Score] TEXT, [Number of Facility Reported Incidents] INTEGER, [Number of Substantiated Complaints] INTEGER, [Number of Fines] INTEGER, [Total Amount of Fines in Dollars] TEXT, [Number of Payment Denials] INTEGER, [Total Number of Penalties] INTEGER, [Location] TEXT, [Processing Date] TEXT );