nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
33 rows where Overall Rating = 5 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-06-08
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, 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 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 Number of Health Revisits, Rating Cycle 3 Health Deficiency 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
121 | 121 | 233 PROSPECT PLACE CORONADO, CA 92118 | 32.694596 | -117.167748 | 0 | 55074 | VILLA CORONADO D/P SNF | 233 PROSPECT PLACE | CORONADO | CA | 92118 | 6195223900 | 470 | San Diego | Non profit - Corporation | 122 | 97.8 | Medicare and Medicaid | true | SHARP CORONADO HOSPITAL AND HEALTHCARE CENTER | 01/01/1967 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 4 | 4 | 3 | 3.02748 | 2.67747 | 1.62998 | 4.30745 | 7.33493 | 0.14687 | 2.33203 | 1.01071 | 0.90148 | 4.24421 | 2.69813 | 1.99197 | 0.68055 | 5.54181 | 08/22/2019 | 6 | 4 | 5 | 24 | 1 | 0 | 24 | 08/02/2018 | 11 | 7 | 4 | 44 | 1 | 0 | 44 | 2017-06-08 | 6 | 6 | 0 | 1 | 44 | 0 | 44 | 34 | 6 | 6 | 0 | 0.00 | 0 | 0 | 233 PROSPECT PLACE CORONADO, CA 92118 (32.694596, -117.167748) | 02/01/2020 | |||||||||||
476 | 476 | 3620 PHILLIPS PARKWAY SOUTH SAINT LOUIS PARK, MN 55426 | 44.938033 | -93.393743 | 0 | 245574 | SHOLOM HOME WEST | 3620 PHILLIPS PARKWAY SOUTH | SAINT LOUIS PARK | MN | 55426 | 9529356311 | 260 | Hennepin | Non profit - Corporation | 154 | 131.8 | Medicare and Medicaid | false | SHOLOM HOME WEST INC | 07/24/1991 | false | false | false | false | Both | Yes | 5 | 3 | 5 | 4 | 5 | 5 | 5 | 2.57404 | 0.80764 | 0.93452 | 1.74216 | 4.3162 | 0.10068 | 2.11495 | 0.69292 | 0.32136 | 3.12922 | 2.52948 | 0.87644 | 1.09455 | 4.42302 | 05/09/2019 | 6 | 5 | 2 | 32 | 2 | 16 | 48 | 04/12/2018 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 2017-06-08 | 6 | 6 | 0 | 1 | 36 | 0 | 36 | 39.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 3620 PHILLIPS PARKWAY SOUTH SAINT LOUIS PARK, MN 55426 (44.938033, -93.393743) | 02/01/2020 | |||||||||||
1606 | 1606 | 1758 SPRINGHILL AVE MOBILE, AL 36607 | 30.691974 | -88.082071 | 0 | 15151 | AZALEA GARDENS OF MOBILE | 1758 SPRINGHILL AVE | MOBILE | AL | 36607 | 2514790551 | 480 | Mobile | For profit - Limited Liability company | 170 | 98 | Medicare and Medicaid | false | MOBILE NURSING OPERATIONS LLC | 01/21/1977 | false | false | false | false | Resident | Yes | 5 | 5 | 3 | 4 | 3 | 4 | 3 | 2.46902 | 0.97664 | 0.58851 | 1.56515 | 4.03416 | 0.03729 | 1.85018 | 0.67584 | 0.31273 | 2.83874 | 2.77349 | 1.08661 | 0.7083 | 4.55701 | 05/02/2019 | 2 | 2 | 1 | 8 | 1 | 0 | 8 | 04/12/2018 | 2 | 2 | 1 | 4 | 1 | 0 | 4 | 2017-06-08 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 6.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1758 SPRINGHILL AVE MOBILE, AL 36607 (30.691974, -88.082071) | 02/01/2020 | |||||||||||
2077 | 2077 | 2155 WEST PIERCE CHICAGO, IL 60622 | 41.909289 | -87.681922 | 0 | 1.4e+170 | WINSTON MANOR CNV & NURSING | 2155 WEST PIERCE | CHICAGO | IL | 60622 | 7732522066 | 141 | Cook | For profit - Corporation | 180 | 85 | Medicaid | false | Legal Business Name Not Available | 05/13/1975 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 2 | 2 | 3 | 1.01703 | 0.14178 | 0.61008 | 0.75185 | 1.76888 | 0 | 1.63534 | 0.65793 | 0.31575 | 2.60903 | 1.29253 | 0.16203 | 0.72722 | 2.17407 | 04/11/2019 | 8 | 6 | 2 | 48 | 1 | 0 | 48 | 05/11/2018 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 2017-06-08 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 32.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 2155 WEST PIERCE CHICAGO, IL 60622 (41.909289, -87.681922) | 02/01/2020 | |||||||||||
2378 | 2378 | 4200 HOUMA BLVD METAIRIE, LA 70002 | 30.014162 | -90.181468 | 0 | 195199 | EAST JEFFERSON HOSPITAL SNF | 4200 HOUMA BLVD | METAIRIE | LA | 70002 | 5045034306 | 250 | Jefferson | Government - Hospital district | 49 | 20.4 | Medicare | true | EAST JEFFERSON GENERAL HOSPITAL | 06/03/1986 | false | false | false | false | None | Yes | 5 | 5 | 4 | 2 | 4 | 5 | 5 | 2.48429 | 1.29513 | 4.76491 | 6.06004 | 8.54433 | 0.52529 | 1.8562 | 0.89508 | 0.47109 | 3.22237 | 2.78159 | 1.08802 | 3.807 | 8.50268 | 06/13/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 06/28/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 3.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 4200 HOUMA BLVD METAIRIE, LA 70002 (30.014162, -90.181468) | 02/01/2020 | |||||||||||
2414 | 2414 | 7225 BOCA DEL MAR DRIVE BOCA RATON, FL 33433 | 26.346981 | -80.159491 | 0 | 105852 | HEARTLAND HEALTH CARE AND REHABILITATION CENTER OF | 7225 BOCA DEL MAR DRIVE | BOCA RATON | FL | 33433 | 5613629644 | 490 | Palm Beach | Non profit - Corporation | 120 | 80.6 | Medicare and Medicaid | false | HEARTLAND OF BOCA RATON FL LLC | 01/12/1995 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 5 | 4 | 4 | 3 | 2.72415 | 1.33439 | 0.75317 | 2.08756 | 4.81171 | 0.26668 | 2.19177 | 0.85495 | 0.44338 | 3.4901 | 2.58316 | 1.17362 | 0.63936 | 4.42094 | 08/29/2019 | 3 | 3 | 1 | 12 | 1 | 0 | 12 | 07/19/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-06-08 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 9.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 7225 BOCA DEL MAR DRIVE BOCA RATON, FL 33433 (26.346981, -80.159491) | 02/01/2020 | |||||||||||
2514 | 2514 | 1201 GARFIELD AVENUE ALBERT LEA, MN 56007 | 43.659552 | -93.354201 | 0 | 245425 | THORNE CREST RETIREMENT CENTER | 1201 GARFIELD AVENUE | ALBERT LEA | MN | 56007 | 5072059004 | 230 | Freeborn | Non profit - Corporation | 52 | 44.2 | Medicare and Medicaid | false | AMERICAN BAPTIST HOMES OF THE MIDWEST | 02/01/1987 | true | false | false | false | Both | Yes | 5 | 4 | 5 | 4 | 5 | 4 | 4 | 2.89754 | 0.66968 | 0.76747 | 1.43715 | 4.33469 | 0.02409 | 2.11601 | 0.66274 | 0.30009 | 3.07884 | 2.84595 | 0.75982 | 0.96258 | 4.51465 | 06/20/2019 | 6 | 4 | 2 | 40 | 1 | 0 | 40 | 05/09/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-06-08 | 4 | 4 | 0 | 1 | 16 | 0 | 16 | 24 | 1 | 0 | 0 | 0.00 | 0 | 0 | 1201 GARFIELD AVENUE ALBERT LEA, MN 56007 (43.659552, -93.354201) | 02/01/2020 | |||||||||||
3444 | 3444 | 900 Co Rd 466, Lady Lake, FL 32159, USA | 28.9137 | -81.9418623 | 1 | ROOFTOP | 106099 | VILLAGES REHABILITATION AND NURSING CENTER (THE) | 900 HIGHWAY 466 | LADY LAKE | FL | 32159 | 3524300017 | 340 | Lake | For profit - Corporation | 120 | 110.6 | Medicare and Medicaid | false | DBI HEALTH INC | 04/12/2013 | false | false | false | false | None | Yes | 5 | 3 | 5 | 5 | 5 | 4 | 3 | 2.97609 | 1.16284 | 0.89225 | 2.05509 | 5.03118 | 0.27225 | 2.08613 | 0.94701 | 0.53515 | 3.56829 | 2.96497 | 0.92332 | 0.62754 | 4.5213 | 08/08/2019 | 3 | 2 | 3 | 28 | 1 | 0 | 28 | 06/14/2018 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-06-08 | 7 | 6 | 1 | 1 | 40 | 0 | 40 | 28.667 | 1 | 2 | 1 | 14805.00 | 0 | 1 | 02/01/2020 | |||||||||||
4370 | 4370 | 1836 GOLD STREET REDDING, CA 96001 | 40.57839 | -122.394652 | 0 | 55510 | REDDING POST ACUTE | 1836 GOLD STREET | REDDING | CA | 96001 | 5302416756 | 550 | Shasta | For profit - Corporation | 89 | 72.8 | Medicare and Medicaid | false | CALAFIA HOLDINGS LLC | 12/31/1971 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 2 | 1 | 2.58316 | 1.17605 | 0.27407 | 1.45012 | 4.03328 | 0.00805 | 2.11563 | 0.74813 | 0.35108 | 3.21484 | 2.53762 | 1.18204 | 0.29382 | 4.02301 | 06/13/2019 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 06/14/2018 | 10 | 6 | 4 | 40 | 1 | 0 | 40 | 2017-06-08 | 11 | 11 | 0 | 1 | 80 | 0 | 80 | 34.667 | 0 | 4 | 1 | 20166.00 | 0 | 1 | 1836 GOLD STREET REDDING, CA 96001 (40.57839, -122.394652) | 02/01/2020 | |||||||||||
4645 | 4645 | 3154 S State Rd 135, Greenwood, IN 46143, USA | 39.5710766 | -86.15944209999999 | 1 | ROOFTOP | 155821 | ASPEN TRACE HEALTH & LIVING COMMUNITY | 3154 SOUTH STATE ROAD 135 | GREENWOOD | IN | 46143 | 3175353344 | 400 | Johnson | Non profit - Corporation | 104 | 98.9 | Medicare and Medicaid | false | RIVERVIEW HOSPITAL | 06/12/2014 | true | false | false | false | Resident | Yes | 5 | 5 | 4 | 5 | 4 | 3 | 3 | 1.68819 | 1.3866 | 0.68985 | 2.07645 | 3.76464 | 0.16215 | 2.3916 | 0.83219 | 0.42308 | 3.64687 | 1.46706 | 1.25289 | 0.61371 | 3.31021 | 07/02/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 05/09/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-06-08 | 4 | 4 | 3 | 1 | 16 | 0 | 16 | 13.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
5174 | 5174 | 310 OAK RIDGE DRIVE ROSEVILLE, CA 95661 | 38.742136 | -121.269975 | 0 | 55491 | OAK RIDGE HEALTHCARE CENTER | 310 OAK RIDGE DRIVE | ROSEVILLE | CA | 95661 | 9167823188 | 410 | Placer | For profit - Corporation | 67 | 59.5 | Medicare and Medicaid | false | Legal Business Name Not Available | 10/01/1978 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 3 | 2.83745 | 0.52541 | 0.47593 | 1.00134 | 3.83879 | 0.05732 | 2.05577 | 0.71901 | 0.34444 | 3.11921 | 2.86861 | 0.54948 | 0.52007 | 3.94642 | 04/25/2019 | 4 | 4 | 0 | 32 | 1 | 0 | 32 | 06/29/2018 | 7 | 2 | 5 | 36 | 1 | 0 | 36 | 2017-06-08 | 9 | 9 | 0 | 1 | 40 | 0 | 40 | 34.667 | 0 | 7 | 0 | 0.00 | 0 | 0 | 310 OAK RIDGE DRIVE ROSEVILLE, CA 95661 (38.742136, -121.269975) | 02/01/2020 | |||||||||||
5510 | 5510 | 1561 NEWTON AVE BOWLING GREEN, KY 42104 | 36.974962 | -86.43927 | 0 | 185224 | BOWLING GREEN NURSING AND REHABILITATION CENTER | 1561 NEWTON AVE. | BOWLING GREEN | KY | 42104 | 2708421611 | 986 | Warren | For profit - Limited Liability company | 66 | 56.8 | Medicare and Medicaid | false | BOWLING GREEN HEALTH CENTER LLC | 01/07/1991 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 2 | 2 | 2.61423 | 0.62969 | 0.54857 | 1.17826 | 3.79249 | 0.08788 | 2.10377 | 0.80349 | 0.4224 | 3.32966 | 2.58263 | 0.58929 | 0.48881 | 3.6524 | 11/07/2019 | 2 | 0 | 2 | 8 | 0 | 0 | 8 | 08/14/2018 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2017-06-08 | 5 | 1 | 4 | 1 | 20 | 0 | 20 | 10 | 0 | 2 | 0 | 0.00 | 0 | 0 | 1561 NEWTON AVE BOWLING GREEN, KY 42104 (36.974962, -86.43927) | 02/01/2020 | |||||||||||
5688 | 5688 | 2200 NORTH H STREET FAIRBURY, NE 68352 | 40.155422 | -97.176075 | 0 | 285282 | JEFFERSON COMMUNITY HEALTH & LIFE GARDENSIDE | P O BOX 277, 2200 NORTH H STREET | FAIRBURY | NE | 68352 | 4027295220 | 470 | Jefferson | Non profit - Corporation | 39 | 37.4 | Medicare and Medicaid | true | JEFFERSON COMMUNITY HEALTH CENTER INC | 10/01/2009 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 2 | 5 | 5 | 2.47793 | 0.53597 | 0.98654 | 1.52251 | 4.00044 | 0.0465 | 1.97976 | 0.60024 | 0.26362 | 2.84362 | 2.60131 | 0.67143 | 1.40853 | 4.51116 | 09/26/2019 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 06/12/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-06-08 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 20 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2200 NORTH H STREET FAIRBURY, NE 68352 (40.155422, -97.176075) | 02/01/2020 | |||||||||||
6127 | 6127 | 1150 PONCE DE LEON BLVD CLEARWATER, FL 33756 | 27.935176 | -82.798744 | 0 | 105636 | BELLEAIR HEALTH CARE CENTER | 1150 PONCE DE LEON BLVD | CLEARWATER | FL | 33756 | 7275855491 | 510 | Pinellas | For profit - Corporation | 120 | 112.5 | Medicare and Medicaid | false | BELLEAIR EAST HCC, LLC | 12/01/1988 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 3 | 2.59164 | 0.98101 | 0.59882 | 1.57983 | 4.17147 | 0.14017 | 2.15308 | 0.80567 | 0.38531 | 3.34405 | 2.50168 | 0.91559 | 0.58495 | 4.00009 | 11/07/2019 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 07/27/2018 | 7 | 6 | 2 | 28 | 1 | 0 | 28 | 2017-06-08 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 14.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 1150 PONCE DE LEON BLVD CLEARWATER, FL 33756 (27.935176, -82.798744) | 02/01/2020 | |||||||||||
6777 | 6777 | 19333 WEST COUNTRY CLUB DRIVE AVENTURA, FL 33180 | 25.954537 | -80.138608 | 0 | 106076 | VI AT AVENTURA | 19333 WEST COUNTRY CLUB DRIVE | AVENTURA | FL | 33180 | 3056924700 | 120 | Miami-Dade | For profit - Corporation | 40 | 30.3 | Medicare | false | CC-AVENTURA, INC. | 04/26/2007 | true | false | false | false | Resident | Yes | 5 | 5 | 2 | 2 | 3 | 5 | 5 | 3.65377 | 1.5487 | 1.49478 | 3.04348 | 6.69725 | 0.10034 | 2.36073 | 0.86578 | 0.45132 | 3.67784 | 3.2167 | 1.34506 | 1.24658 | 5.83924 | 09/20/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 06/01/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 11.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 19333 WEST COUNTRY CLUB DRIVE AVENTURA, FL 33180 (25.954537, -80.138608) | 02/01/2020 | |||||||||||
7003 | 7003 | 695 MITZI ST NORTH MUSKEGON, MI 49445 | 43.270205 | -86.25241 | 0 | 235522 | HILLCREST NURSING AND REHABILITATION COMMUNITY | 695 MITZI ST | NORTH MUSKEGON | MI | 49445 | 2317441641 | 600 | Muskegon | For profit - Corporation | 39 | 37.7 | Medicare and Medicaid | false | CCG - LAKESHORE, INC. | 08/01/1992 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 2.36328 | 0.42909 | 1.01284 | 1.44193 | 3.80521 | 0.26595 | 2.13821 | 0.7336 | 0.34816 | 3.21997 | 2.2971 | 0.43982 | 1.09496 | 3.78948 | 08/22/2019 | 2 | 2 | 0 | 20 | 1 | 0 | 20 | 09/27/2018 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 2017-06-08 | 9 | 9 | 0 | 1 | 72 | 0 | 72 | 31.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 695 MITZI ST NORTH MUSKEGON, MI 49445 (43.270205, -86.25241) | 02/01/2020 | |||||||||||
7445 | 7445 | 212 WEST SOO STREET PARKERS PRAIRIE, MN 56361 | 46.15336 | -95.331287 | 0 | 245588 | ST WILLIAMS LIVING CENTER | 212 WEST SOO STREET, BOX 30 | PARKERS PRAIRIE | MN | 56361 | 2183384671 | 550 | Otter Tail | Non profit - Corporation | 53 | 50.2 | Medicare and Medicaid | false | ST. WILLIAM'S LIVING CENTER | 12/01/1991 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 4 | 4 | 4 | 2.72557 | 0.81574 | 0.77777 | 1.59351 | 4.31908 | 0.02274 | 1.96708 | 0.65253 | 0.30014 | 2.91974 | 2.87973 | 0.94001 | 0.97536 | 4.74351 | 07/11/2019 | 4 | 4 | 0 | 32 | 1 | 0 | 32 | 08/30/2018 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 2017-06-08 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 20.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 212 WEST SOO STREET PARKERS PRAIRIE, MN 56361 (46.15336, -95.331287) | 02/01/2020 | |||||||||||
7885 | 7885 | NW 11th St, Fairfield, IL 62837, USA | 38.3809194 | -88.3744583 | 1 | GEOMETRIC_CENTER | 145552 | FAIRFIELD MEMORIAL HOSPITAL | NORTH WEST 11TH STREET | FAIRFIELD | IL | 62837 | 6188422611 | 986 | Wayne | Non profit - Other | 30 | 20.7 | Medicare | false | FAIRFIELD MEMORIAL HOSPITAL ASSOCIATION | 03/26/1986 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 2.59882 | 0 | 2.32737 | 2.32737 | 4.92618 | 0.01246 | 1.96408 | 0.63099 | 0.30819 | 2.90326 | 2.74999 | 0 | 2.84237 | 5.44099 | 05/31/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 04/05/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
8886 | 8886 | 12496 PRINCETON RD HUNTSBURG, OH 44046 | 41.530755 | -81.089999 | 0 | 366124 | OHMAN FAMILY LIVING AT BLOSSOM | 12496 PRINCETON RD | HUNTSBURG | OH | 44046 | 4406355567 | 280 | Geauga | For profit - Corporation | 76 | 68.1 | Medicare and Medicaid | false | BLOSSOM HILL CARE CENTER INC | 06/01/1997 | false | false | false | false | Both | Yes | 5 | 5 | 5 | 5 | 5 | 3 | 3 | 2.22403 | 0.72377 | 0.78788 | 1.51165 | 3.73568 | 0 | 2.18136 | 0.84793 | 0.44128 | 3.47057 | 2.119 | 0.64184 | 0.67201 | 3.45161 | 09/05/2019 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 08/16/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0.00 | 0 | 0 | 12496 PRINCETON RD HUNTSBURG, OH 44046 (41.530755, -81.089999) | 02/01/2020 | |||||||||||
8961 | 8961 | 2070 CLINTON AVE ALAMEDA, CA 94501 | 37.76323 | -122.253541 | 0 | 555381 | ALAMEDA HOSPITAL D/P SNF | 2070 CLINTON AVE | ALAMEDA | CA | 94501 | 5108144049 | 0 | Alameda | Non profit - Other | 181 | 173.9 | Medicare and Medicaid | false | ALAMEDA HEALTH SYSTEM | 06/07/1989 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 2.472 | 0.682 | 1.37552 | 2.05752 | 4.52952 | 0.03197 | 2.15198 | 0.76661 | 0.58231 | 3.50089 | 2.38741 | 0.66895 | 0.88909 | 4.14884 | 06/19/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 07/19/2018 | 5 | 3 | 2 | 20 | 1 | 0 | 20 | 2017-06-08 | 7 | 6 | 3 | 1 | 28 | 0 | 28 | 19.333 | 9 | 3 | 0 | 0.00 | 0 | 0 | 2070 CLINTON AVE ALAMEDA, CA 94501 (37.76323, -122.253541) | 02/01/2020 | |||||||||||
9430 | 9430 | 290 HEATHER COURT TEMPLETON, CA 93465 | 35.553435 | -120.717613 | 0 | 555220 | VINEYARD HILLS HEALTH CENTER | 290 HEATHER COURT | TEMPLETON | CA | 93465 | 8054343035 | 500 | San Luis Obispo | For profit - Corporation | 99 | 82.6 | Medicare and Medicaid | false | COASTAL LLC | 04/28/1986 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 3 | 2.70764 | 1.16764 | 0.48503 | 1.65267 | 4.3603 | 0.09272 | 2.31514 | 0.75714 | 0.33575 | 3.40804 | 2.43068 | 1.15961 | 0.54372 | 4.10265 | 06/06/2019 | 7 | 7 | 0 | 32 | 1 | 0 | 32 | 06/07/2018 | 9 | 9 | 1 | 52 | 1 | 0 | 52 | 2017-06-08 | 11 | 9 | 2 | 1 | 56 | 0 | 56 | 42.667 | 1 | 1 | 0 | 0.00 | 0 | 0 | 290 HEATHER COURT TEMPLETON, CA 93465 (35.553435, -120.717613) | 02/01/2020 | |||||||||||
9708 | 9708 | 7400 CLAREWOOD DR HOUSTON, TX 77036 | 29.709747 | -95.514618 | 0 | 676021 | CLAREWOOD HOUSE EXTENDED CARE CENTER | 7400 CLAREWOOD DR | HOUSTON | TX | 77036 | 7137745821 | 610 | Harris | Non profit - Corporation | 60 | 46 | Medicare | false | CLAREWOOD HOUSE, INC | 04/28/2004 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 3.50071 | 0.46682 | 0.81306 | 1.27988 | 4.78059 | 0.10474 | 2.05525 | 0.68177 | 0.31547 | 3.05248 | 3.54004 | 0.51487 | 0.97007 | 5.02206 | 06/27/2019 | 6 | 6 | 0 | 48 | 1 | 0 | 48 | 06/14/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 7 | 7 | 0 | 1 | 68 | 0 | 68 | 35.333 | 0 | 0 | 1 | 7807.00 | 1 | 2 | 7400 CLAREWOOD DR HOUSTON, TX 77036 (29.709747, -95.514618) | 02/01/2020 | |||||||||||
10598 | 10598 | 10501 Lagrima De Oro Rd NE, Albuquerque, NM 87111, USA | 35.1329215 | -106.5212144 | 1 | ROOFTOP | 325035 | LA VIDA LLENA | 10501 LAGRIMA DE ORO NE | ALBUQUERQUE | NM | 87111 | 5052966700 | 0 | Bernalillo | For profit - Corporation | 50 | 43.9 | Medicare and Medicaid | false | LA VIDA LLENA | 03/28/1983 | true | false | false | false | Resident | Yes | 5 | 5 | 5 | 4 | 5 | 3 | 3 | 2.56603 | 0.6455 | 0.4969 | 1.14241 | 3.70844 | 0 | 1.97046 | 0.61962 | 0.27037 | 2.86046 | 2.70651 | 0.78335 | 0.69174 | 4.15727 | 10/09/2019 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 07/13/2018 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
10845 | 10845 | 3150 GERSHWIN DRIVE GREEN BAY, WI 54311 | 44.523812 | -87.926171 | 0 | 525693 | BROWN CTY COMM TREATMENT CTR-BAYSHORE VILLAGE | 3150 GERSHWIN DRIVE | GREEN BAY | WI | 54311 | 9203914700 | 40 | Brown | Government - County | 63 | 60.7 | Medicare and Medicaid | false | COUNTY OF BROWN | 12/29/2007 | false | false | false | false | None | Yes | 5 | 5 | 5 | 5 | 2 | 4 | 4 | 3.14535 | 0.91526 | 0.70019 | 1.61545 | 4.7608 | 0.01785 | 2.04918 | 0.65644 | 0.28922 | 2.99484 | 3.19011 | 1.04841 | 0.91121 | 5.09753 | 09/11/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 08/01/2018 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3150 GERSHWIN DRIVE GREEN BAY, WI 54311 (44.523812, -87.926171) | 02/01/2020 | |||||||||||
11202 | 11202 | 4782 SOUTH HOLLADAY BOULEVARD SALT LAKE CITY, UT 84117 | 40.665761 | -111.821558 | 0 | 465109 | HOLLADAY HEALTHCARE CENTER | 4782 SOUTH HOLLADAY BOULEVARD | SALT LAKE CITY | UT | 84117 | 8012777002 | 170 | Salt Lake | For profit - Corporation | 120 | 80.5 | Medicare and Medicaid | false | BEAVER VALLEY HOSPITAL | 02/13/1987 | false | false | false | false | Resident | Yes | 5 | 3 | 5 | 5 | 5 | 4 | 4 | 2.51702 | 0.47947 | 0.83667 | 1.31614 | 3.83316 | 0.12414 | 2.16075 | 0.8215 | 0.41839 | 3.40064 | 2.42102 | 0.43887 | 0.75267 | 3.61451 | 09/25/2019 | 4 | 4 | 0 | 32 | 1 | 0 | 32 | 09/13/2018 | 5 | 5 | 1 | 32 | 1 | 0 | 32 | 2017-06-08 | 9 | 8 | 1 | 1 | 72 | 0 | 72 | 38.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 4782 SOUTH HOLLADAY BOULEVARD SALT LAKE CITY, UT 84117 (40.665761, -111.821558) | 02/01/2020 | |||||||||||
11230 | 11230 | 6101 FAIR OAKS BOULEVARD CARMICHAEL, CA 95608 | 38.612067 | -121.328765 | 0 | 555889 | MOUNTAIN MANOR SENIOR RESIDENCE | 6101 FAIR OAKS BOULEVARD | CARMICHAEL | CA | 95608 | 9164887211 | 440 | Sacramento | For profit - Corporation | 47 | 44.1 | Medicare and Medicaid | false | GRANDCARE INC | 09/09/2014 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 2 | 3 | 2 | 2.58361 | 1.29793 | 0.33945 | 1.63738 | 4.22099 | 0.06683 | 2.16314 | 0.73364 | 0.32644 | 3.22321 | 2.48233 | 1.33031 | 0.39139 | 4.19932 | 05/16/2019 | 10 | 9 | 1 | 80 | 1 | 0 | 80 | 05/17/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 44 | 0 | 2 | 0 | 0.00 | 0 | 0 | 6101 FAIR OAKS BOULEVARD CARMICHAEL, CA 95608 (38.612067, -121.328765) | 02/01/2020 | |||||||||||
11238 | 11238 | 1224 S HIGH ST ABERDEEN, SD 57401 | 45.450525 | -98.466154 | 0 | 435073 | BETHESDA HOME OF ABERDEEN | 1224 S HIGH ST | ABERDEEN | SD | 57401 | 6052257580 | 60 | Brown | Non profit - Church related | 86 | 83.2 | Medicare and Medicaid | false | BETHESDA HOME OF ABERDEEN, INC. | 10/01/1993 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 4 | 5 | 5 | 2.33056 | 0.46238 | 1.00486 | 1.46724 | 3.79779 | 0.04272 | 2.00478 | 0.64323 | 0.29091 | 2.93892 | 2.41607 | 0.54053 | 1.30008 | 4.14378 | 09/26/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 07/26/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 2 | 1 | 1 | 1 | 24 | 0 | 24 | 10 | 0 | 0 | 1 | 3713.00 | 0 | 1 | 1224 S HIGH ST ABERDEEN, SD 57401 (45.450525, -98.466154) | 02/01/2020 | |||||||||||
12264 | 12264 | 11750 KLINGER AVENUE NE ALLIANCE, OH 44601 | 40.9407 | -81.124943 | 0 | 365402 | ALTERCARE OF ALLIANCE CTR FOR REHAB & NC INC | 11750 KLINGER AVENUE NE | ALLIANCE | OH | 44601 | 3308238263 | 770 | Stark | For profit - Corporation | 97 | 82.8 | Medicare and Medicaid | false | ALTERCARE OF ALLIANCE CENTER FOR REHABILITATION AND NURSING CARE, INC. | 11/28/1978 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 2 | 2 | 2.25715 | 0.6197 | 0.57168 | 1.19138 | 3.44853 | 0.04169 | 2.26056 | 0.88792 | 0.46672 | 3.6152 | 2.0752 | 0.5248 | 0.46103 | 3.05883 | 10/24/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 08/30/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 11750 KLINGER AVENUE NE ALLIANCE, OH 44601 (40.9407, -81.124943) | 02/01/2020 | |||||||||||
12304 | 12304 | 260 HOSPITAL DRIVE BREVARD, NC 28712 | 35.256437 | -82.713054 | 0 | 345484 | TRANSYLVANIA REGIONAL HOSPITAL | 260 HOSPITAL DRIVE | BREVARD | NC | 28712 | 8288835156 | 870 | Transylvania | For profit - Corporation | 10 | 2.5 | Medicare and Medicaid | true | MH TRANSYLVANIA REGIONAL HOSPITAL, LLLP | 05/29/1997 | false | false | false | false | None | Yes | 5 | 4 | 5 | 2 | 5 | 3 | 4 | 2.375 | 0 | 1.2 | 1.2 | 3.575 | 0.125 | 1.9983 | 0.9427 | 0.481 | 3.422 | 2.47012 | 0 | 0.939 | 3.35003 | 05/01/2019 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 04/26/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0.00 | 0 | 0 | 260 HOSPITAL DRIVE BREVARD, NC 28712 (35.256437, -82.713054) | 02/01/2020 | |||||||||||
12900 | 12900 | 5721 S LEWIS AVE TULSA, OK 74105 | 36.079356 | -95.95797 | 0 | 375546 | THE VILLAGES AT SOUTHERN HILLS | 5721 S LEWIS AVE | TULSA | OK | 74105 | 9184476447 | 710 | Tulsa | For profit - Partnership | 110 | 99.4 | Medicare and Medicaid | false | SOUTH LEWIS SH OPCO, LLC | 08/23/2011 | true | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 1 | 1 | 1.97499 | 1.56307 | 0.40287 | 1.96594 | 3.94094 | 0.14973 | 2.2969 | 0.99747 | 0.56622 | 3.86059 | 1.78706 | 1.17831 | 0.2678 | 3.2734 | 07/29/2019 | 4 | 1 | 3 | 28 | 1 | 0 | 28 | 05/03/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-08 | 2 | 0 | 2 | 0 | 12 | 0 | 12 | 16 | 0 | 1 | 0 | 0.00 | 0 | 0 | 5721 S LEWIS AVE TULSA, OK 74105 (36.079356, -95.95797) | 02/01/2020 | |||||||||||
13147 | 13147 | 6720 EAST GREEN LAKE WAY NORTH SEATTLE, WA 98103 | 47.678349 | -122.329151 | 0 | 505027 | HEARTHSTONE, THE | 6720 EAST GREEN LAKE WAY NORTH | SEATTLE | WA | 98103 | 2065259666 | 160 | King | Non profit - Corporation | 44 | 28.1 | Medicare and Medicaid | false | LUTHERAN RETIREMENT HOME OF GREATER SEATTLE INC | 08/18/1981 | true | false | false | false | Resident | Yes | 5 | 3 | 5 | 5 | 4 | 5 | 5 | 3.05882 | 0.93497 | 1.16591 | 2.10089 | 5.15971 | 0.13739 | 2.16637 | 0.76576 | 0.36428 | 3.29642 | 2.93452 | 0.9181 | 1.20464 | 5.01922 | 08/06/2019 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 07/13/2018 | 20 | 18 | 7 | 227 | 1 | 0 | 227 | 2017-06-08 | 14 | 13 | 1 | 1 | 128 | 0 | 128 | 113 | 3 | 2 | 1 | 10000.00 | 0 | 1 | 6720 EAST GREEN LAKE WAY NORTH SEATTLE, WA 98103 (47.678349, -122.329151) | 02/01/2020 | |||||||||||
14044 | 14044 | 1590 Chartwell St, Lancaster, OH 43130, USA | 39.7410358 | -82.561949 | 1 | ROOFTOP | 366215 | LANFAIR CENTER FOR REHAB & NSG CARE INC | 1590 CHARTWELL STREET | LANCASTER | OH | 43130 | 7406875100 | 230 | Fairfield | For profit - Corporation | 84 | 80.2 | Medicare and Medicaid | false | LANFAIR CENTER FOR REHABILITATION & NURSING CARE, INC. | 11/03/2000 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.49607 | 0.72842 | 0.99505 | 1.72348 | 4.21955 | 0.11019 | 2.17522 | 0.8283 | 0.41436 | 3.41789 | 2.38489 | 0.66127 | 0.90385 | 3.95878 | 09/19/2019 | 7 | 4 | 3 | 28 | 1 | 0 | 28 | 08/02/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-06-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.667 | 0 | 5 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
14973 | 14973 | 6557 US-68, West Liberty, OH 43357, USA | 40.267236 | -83.75950689999999 | 1 | ROOFTOP | 365362 | GREEN HILLS CENTER | 6557 US 68 SOUTH | WEST LIBERTY | OH | 43357 | 9374655065 | 470 | Logan | Non profit - Corporation | 99 | 82.5 | Medicare and Medicaid | false | WEST LIBERTY CARE CENTER INC | 10/13/1977 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 4 | 5 | 3 | 3 | 2.65829 | 0.80583 | 0.66989 | 1.47572 | 4.134 | 0.05925 | 2.13697 | 0.82684 | 0.42532 | 3.38913 | 2.58536 | 0.73284 | 0.59281 | 3.91144 | 09/12/2019 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 08/02/2018 | 2 | 2 | 0 | 20 | 1 | 0 | 20 | 2017-06-08 | 3 | 3 | 0 | 1 | 28 | 0 | 28 | 15.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 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 );