nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
21 rows where Overall Rating = 1 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-07-20
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, Continuing Care Retirement Community, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1024 | 1024 | 11240 CANAL ROAD GULFPORT, MS 39503 | 30.448614 | -89.136925 | 0 | 255341 | GULFPORT CARE CENTER | 11240 CANAL ROAD | GULFPORT | MS | 39503 | 2287011500 | 230 | Harrison | For profit - Corporation | 90 | 76.8 | Medicare and Medicaid | false | GULFPORT HEALTHCARE LLC | 08/18/2014 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 3 | 2 | 2.51848 | 1.42281 | 0.40413 | 1.82694 | 4.34542 | 0.08037 | 2.19264 | 0.76818 | 0.36744 | 3.32827 | 2.38718 | 1.39272 | 0.41397 | 4.18664 | 12/19/2019 | 7 | 6 | 1 | 28 | 0 | 0 | 28 | 10/24/2018 | 11 | 8 | 3 | 120 | 1 | 0 | 120 | 2017-07-20 | 9 | 6 | 3 | 1 | 84 | 0 | 84 | 68 | 2 | 3 | 1 | 8781.00 | 0 | 1 | 11240 CANAL ROAD GULFPORT, MS 39503 (30.448614, -89.136925) | 02/01/2020 | |||||||||||
2067 | 2067 | 3520 KENNETH DRIVE MACON, GA 31206 | 32.795431 | -83.695568 | 0 | 115652 | CHERRY BLOSSOM HEALTH AND REHABILITATION | 3520 KENNETH DRIVE | MACON | GA | 31206 | 4787817553 | 90 | Bibb | Non profit - Other | 82 | 72 | Medicare and Medicaid | false | CHERRY BLOSSOM HEALTH CARE CENTER LLC | 02/01/1998 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 2 | 2 | 1.88059 | 1.04064 | 0.35181 | 1.39246 | 3.27305 | 0.06936 | 2.15176 | 0.78166 | 0.37672 | 3.31014 | 1.81642 | 1.00108 | 0.35149 | 3.17073 | 12/05/2019 | 9 | 2 | 7 | 199 | 1 | 0 | 199 | 07/26/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-07-20 | 2 | 2 | 0 | 1 | 32 | 0 | 32 | 110.167 | 0 | 4 | 1 | 13905.00 | 0 | 1 | 3520 KENNETH DRIVE MACON, GA 31206 (32.795431, -83.695568) | 02/01/2020 | |||||||||||
2543 | 2543 | 178 WEST CAMPBELLTON STREET FAIRBURN, GA 30213 | 33.571177 | -84.584444 | 0 | 115298 | FAIRBURN HEALTH CARE CENTER | 178 WEST CAMPBELLTON STREET | FAIRBURN | GA | 30213 | 7709641320 | 470 | Fulton | For profit - Corporation | 120 | 89.7 | Medicare and Medicaid | false | GAFAIRBURN SNF LLC | 05/07/1982 | false | false | false | false | Resident | Yes | 1 | 2 | 2 | 1 | 3 | 1 | 12 | 1 | 12 | 6 | 6 | 08/08/2019 | 7 | 4 | 3 | 28 | 1 | 0 | 28 | 05/24/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-07-20 | 2 | 2 | 0 | 1 | 40 | 0 | 40 | 23.333 | 0 | 3 | 1 | 7475.00 | 1 | 2 | 178 WEST CAMPBELLTON STREET FAIRBURN, GA 30213 (33.571177, -84.584444) | 02/01/2020 | |||||||||||||||||||||
3403 | 3403 | 139 MORAN LAKE ROAD ROME, GA 30161 | 34.259118 | -85.111098 | 0 | 115720 | EVERGREEN HEALTH AND REHABILITATION CENTER | 139 MORAN LAKE ROAD, NE | ROME | GA | 30161 | 7063783383 | 460 | Floyd | For profit - Individual | 100 | 92.2 | Medicare and Medicaid | false | DUKE EQUITIES LLC | 07/31/2008 | false | false | false | true | Resident | Yes | 1 | 2 | 2 | 3 | 2 | 1 | 1 | 1.97904 | 0.91547 | 0.23064 | 1.1461 | 3.12515 | 0.24275 | 2.01016 | 0.77516 | 0.4062 | 3.19153 | 2.04616 | 0.88805 | 0.2137 | 3.13997 | 09/06/2019 | 5 | 4 | 1 | 32 | 1 | 0 | 32 | 06/14/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-07-20 | 5 | 5 | 0 | 1 | 36 | 0 | 36 | 24.667 | 0 | 2 | 2 | 22093.00 | 0 | 2 | 139 MORAN LAKE ROAD ROME, GA 30161 (34.259118, -85.111098) | 02/01/2020 | |||||||||||
3727 | 3727 | 815 EAST 63 STREET SAVANNAH, GA 31405 | 32.032406 | -81.094115 | 0 | 115120 | SIGNATURE HEALTHCARE OF SAVANNAH | 815 EAST 63 STREET | SAVANNAH | GA | 31405 | 9123528615 | 220 | Chatham | For profit - Corporation | 120 | 104.4 | Medicare and Medicaid | false | LP SAVANNAH, LLC | 03/31/1972 | true | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 2 | 1 | 2.07493 | 1.1946 | 0.29569 | 1.49029 | 3.56522 | 0.09818 | 2.02239 | 0.77268 | 0.38054 | 3.17562 | 2.13233 | 1.16253 | 0.29245 | 3.60007 | 08/08/2019 | 9 | 6 | 3 | 60 | 1 | 0 | 60 | 06/07/2018 | 10 | 10 | 0 | 40 | 1 | 0 | 40 | 2017-07-20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 43.333 | 0 | 1 | 1 | 16353.00 | 0 | 1 | 815 EAST 63 STREET SAVANNAH, GA 31405 (32.032406, -81.094115) | 02/01/2020 | |||||||||||
5858 | 5858 | 54 PEACHTREE PARK DRIVE N E ATLANTA, GA 30309 | 33.812329 | -84.390884 | 0 | 115110 | SIGNATURE HEALTHCARE OF BUCKHEAD | 54 PEACHTREE PARK DRIVE N.E. | ATLANTA | GA | 30309 | 4043516041 | 470 | Fulton | For profit - Corporation | 179 | 106.5 | Medicare and Medicaid | false | LP ATLANTA LLC | 06/01/1976 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 2.02781 | 1.54295 | 0.46478 | 2.00773 | 4.03553 | 0.12576 | 2.28593 | 0.82412 | 0.41345 | 3.5235 | 1.84366 | 1.40781 | 0.42311 | 3.67265 | 08/01/2019 | 7 | 3 | 4 | 141 | 1 | 0 | 141 | 05/17/2018 | 6 | 2 | 4 | 32 | 1 | 0 | 32 | 2017-07-20 | 4 | 1 | 3 | 1 | 32 | 0 | 32 | 86.5 | 0 | 11 | 1 | 400694.00 | 0 | 1 | 54 PEACHTREE PARK DRIVE N E ATLANTA, GA 30309 (33.812329, -84.390884) | 02/01/2020 | |||||||||||
7802 | 7802 | 5400 WEST 87TH STREET BURBANK, IL 60459 | 41.734326 | -87.755774 | 0 | 145211 | BURBANK REHABILITATION CENTER | 5400 WEST 87TH STREET | BURBANK | IL | 60459 | 7084231200 | 141 | Cook | For profit - Limited Liability company | 163 | 81.3 | Medicare and Medicaid | false | BURBANK REHABILITATION CENTER LLC | 08/25/1969 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 3 | 2 | 2 | 1.7744 | 1.4878 | 0.63489 | 2.12269 | 3.89709 | 0.11253 | 2.21713 | 0.90783 | 0.63864 | 3.7636 | 1.66332 | 1.23232 | 0.37418 | 3.3204 | 09/12/2019 | 16 | 9 | 8 | 112 | 1 | 0 | 112 | 08/09/2018 | 16 | 12 | 4 | 68 | 1 | 0 | 68 | 2017-07-20 | 28 | 14 | 16 | 1 | 184 | 0 | 184 | 109.333 | 0 | 41 | 4 | 34975.00 | 0 | 4 | 5400 WEST 87TH STREET BURBANK, IL 60459 (41.734326, -87.755774) | 02/01/2020 | |||||||||||
9058 | 9058 | 911 WESTERN BOULEVARD TARBORO, NC 27886 | 35.895666 | -77.555646 | 0 | 345510 | PRODIGY TRANSITIONAL REHAB | 911 WESTERN BOULEVARD | TARBORO | NC | 27886 | 2528232041 | 320 | Edgecombe | For profit - Limited Liability company | 118 | 110.3 | Medicare and Medicaid | false | TARBORO CARE LLC | 01/04/2001 | false | false | false | false | Resident | Yes | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2.22208 | 1.00937 | 0.34107 | 1.35044 | 3.57252 | 0.03217 | 2.19589 | 0.80728 | 0.42479 | 3.42795 | 2.10312 | 0.94018 | 0.30221 | 3.3419 | 08/23/2019 | 3 | 3 | 0 | 32 | 1 | 0 | 32 | 08/10/2018 | 6 | 5 | 2 | 103 | 1 | 0 | 103 | 2017-07-20 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 51.667 | 0 | 1 | 2 | 22033.00 | 0 | 2 | 911 WESTERN BOULEVARD TARBORO, NC 27886 (35.895666, -77.555646) | 02/01/2020 | |||||||||||
9693 | 9693 | 275 KIENLE DRIVE PIQUA, OH 45356 | 40.148017 | -84.207982 | 0 | 365607 | PIQUA HEALTHCARE | 275 KIENLE DRIVE | PIQUA | OH | 45356 | 9377739346 | 560 | Miami | For profit - Corporation | 99 | 58.8 | Medicare and Medicaid | false | PIQUA HEALTHCARE LLC | 01/11/1984 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 2 | 2 | 1.51488 | 0.86998 | 0.53904 | 1.40901 | 2.92389 | 0.10702 | 2.03108 | 0.81645 | 0.4091 | 3.25663 | 1.55012 | 0.80124 | 0.49594 | 2.87903 | 10/10/2019 | 10 | 6 | 4 | 68 | 1 | 0 | 68 | 09/06/2018 | 15 | 13 | 2 | 183 | 1 | 0 | 183 | 2017-07-20 | 2 | 0 | 2 | 0 | 8 | 0 | 8 | 96.333 | 1 | 6 | 1 | 13627.00 | 0 | 1 | 275 KIENLE DRIVE PIQUA, OH 45356 (40.148017, -84.207982) | 02/01/2020 | |||||||||||
10185 | 10185 | 1883 SHUMWAY HILL ROAD WELLSBORO, PA 16901 | 41.742176 | -77.270164 | 0 | 395352 | BROAD ACRES HEALTH AND REHAB | 1883 SHUMWAY HILL ROAD | WELLSBORO | PA | 16901 | 5707243559 | 710 | Tioga | Non profit - Corporation | 120 | 109.3 | Medicare and Medicaid | false | BROAD ACRES NURSING HOME ASSOCIATION | 11/01/1978 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 4 | 2 | 2 | 2.1703 | 0.85844 | 0.47212 | 1.33057 | 3.50087 | 0.08987 | 2.22279 | 0.84645 | 0.4455 | 3.51474 | 2.02926 | 0.76259 | 0.39888 | 3.194 | 05/17/2019 | 15 | 15 | 0 | 80 | 2 | 40 | 120 | 06/08/2018 | 22 | 22 | 1 | 104 | 1 | 0 | 104 | 2017-07-20 | 15 | 12 | 3 | 2 | 76 | 38 | 114 | 113.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 1883 SHUMWAY HILL ROAD WELLSBORO, PA 16901 (41.742176, -77.270164) | 02/01/2020 | |||||||||||
10269 | 10269 | 109 N MCKINNEY SWEENY, TX 77480 | 29.047278 | -95.689958 | 0 | 675344 | SWEENY HOUSE | 109 N MCKINNEY | SWEENY | TX | 77480 | 9795483383 | 180 | Brazoria | For profit - Limited Liability company | 90 | 69.4 | Medicare and Medicaid | false | SSC SWEENY OPERATING COMPANY LLC | 05/31/1994 | false | false | false | false | Resident | Yes | 1 | 2 | 1 | 2 | 1 | 1 | 12 | 1 | 12 | 1.7226 | 1.05609 | 0.24992 | 1.30601 | 3.02861 | 0.08267 | 1.92909 | 0.76765 | 0.40111 | 3.09784 | 1.85588 | 1.03448 | 0.23452 | 3.135 | 06/28/2019 | 12 | 11 | 4 | 104 | 1 | 0 | 104 | 06/29/2018 | 6 | 6 | 0 | 44 | 1 | 0 | 44 | 2017-07-20 | 7 | 5 | 2 | 1 | 68 | 0 | 68 | 78 | 3 | 3 | 0 | 0.00 | 0 | 0 | 109 N MCKINNEY SWEENY, TX 77480 (29.047278, -95.689958) | 02/01/2020 | |||||||||
10378 | 10378 | 1100 N 4TH ST LONGVIEW, TX 75601 | 32.509166 | -94.730852 | 0 | 675133 | HIGHLAND PINES NURSING HOME | 1100 N 4TH ST | LONGVIEW | TX | 75601 | 9037537661 | 570 | Gregg | For profit - Corporation | 137 | 94.7 | Medicare and Medicaid | false | HP NURSING & REHAB LLC | 05/01/1993 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 1.83608 | 1.44188 | 0.39738 | 1.83926 | 3.67533 | 0.03199 | 2.16099 | 0.87593 | 0.51773 | 3.55466 | 1.76585 | 1.23777 | 0.28889 | 3.31552 | 06/06/2019 | 14 | 4 | 14 | 221 | 1 | 0 | 221 | 07/20/2018 | 24 | 19 | 24 | 252 | 1 | 0 | 252 | 2017-07-20 | 10 | 9 | 6 | 1 | 132 | 0 | 132 | 216.5 | 3 | 6 | 4 | 47223.00 | 0 | 4 | 1100 N 4TH ST LONGVIEW, TX 75601 (32.509166, -94.730852) | 02/01/2020 | |||||||||||
10549 | 10549 | 6757 MAYFIELD RD MAYFIELD HEIGHTS, OH 44124 | 41.520132 | -81.434589 | 0 | 365355 | MAYFIELD HEIGHTS HEALTHCARE. | 6757 MAYFIELD RD | MAYFIELD HEIGHTS | OH | 44124 | 4404730090 | 170 | Cuyahoga | For profit - Corporation | 150 | 103.4 | Medicare and Medicaid | false | MAYFIELD HEIGHTS HEALTHCARE LLC | 07/01/1979 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 1.6303 | 0.77339 | 0.49832 | 1.27171 | 2.90201 | 0.07235 | 2.00268 | 0.81722 | 0.4281 | 3.248 | 1.69188 | 0.71161 | 0.43812 | 2.86508 | 11/06/2019 | 14 | 8 | 10 | 100 | 0 | 0 | 100 | 09/27/2018 | 20 | 12 | 12 | 140 | 1 | 0 | 140 | 2017-07-20 | 2 | 1 | 1 | 1 | 8 | 0 | 8 | 98 | 0 | 14 | 0 | 0.00 | 0 | 0 | 6757 MAYFIELD RD MAYFIELD HEIGHTS, OH 44124 (41.520132, -81.434589) | 02/01/2020 | |||||||||||
10691 | 10691 | 1448 HOUSTON ST WILLS POINT, TX 75169 | 32.699773 | -95.99279 | 0 | 675597 | FREE STATE CRESTWOOD | 1448 HOUSTON ST | WILLS POINT | TX | 75169 | 9038735400 | 947 | Van Zandt | For profit - Limited Liability company | 59 | 66.8 | Medicare and Medicaid | false | Legal Business Name Not Available | 05/29/1996 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 3 | 3 | 1.92525 | 0.78773 | 0.5772 | 1.36493 | 3.29018 | 0.08652 | 2.04567 | 0.7841 | 0.40366 | 3.23343 | 1.95599 | 0.75542 | 0.5382 | 3.26294 | 08/08/2019 | 11 | 9 | 2 | 112 | 1 | 0 | 112 | 08/16/2018 | 17 | 7 | 10 | 503 | 1 | 0 | 503 | 2017-07-20 | 15 | 13 | 11 | 1 | 152 | 0 | 152 | 249 | 0 | 14 | 2 | 55925.00 | 0 | 2 | 1448 HOUSTON ST WILLS POINT, TX 75169 (32.699773, -95.99279) | 02/01/2020 | |||||||||||
12249 | 12249 | 1210 SOUTH 6TH STREET BLACKWELL, OK 74631 | 36.792176 | -97.291963 | 0 | 375402 | HILLCREST MANOR NURSING CENTER | 1210 SOUTH 6TH STREET | BLACKWELL | OK | 74631 | 5803633244 | 350 | Kay | For profit - Limited Liability company | 137 | 45.1 | Medicare and Medicaid | false | BEDLAM PROPERTIES, LLC | 08/29/2001 | false | false | false | false | Both | Yes | 1 | 1 | 1 | 1 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 12/17/2019 | 6 | 6 | 0 | 107 | 0 | 0 | 107 | 10/02/2018 | 24 | 24 | 0 | 252 | 2 | 126 | 378 | 2017-07-20 | 5 | 2 | 3 | 1 | 52 | 0 | 52 | 188.167 | 0 | 2 | 2 | 54617.00 | 1 | 3 | 1210 SOUTH 6TH STREET BLACKWELL, OK 74631 (36.792176, -97.291963) | 02/01/2020 | |||||||||||||||||||||
12375 | 12375 | 1471 WILLS CREEK VALLEY DRIVE CAMBRIDGE, OH 43725 | 40.046775 | -81.580488 | 0 | 365770 | CAMBRIDGE CARE AND REHABILITATION | 1471 WILLS CREEK VALLEY DRIVE | CAMBRIDGE | OH | 43725 | 7404394437 | 300 | Guernsey | For profit - Corporation | 144 | 83.2 | Medicare and Medicaid | false | CAMBRIDGE HEALTH LEASING LLC | 11/28/1989 | false | false | false | false | Both | Yes | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 1.65528 | 0.42592 | 0.56578 | 0.9917 | 2.64698 | 0.03298 | 1.9661 | 0.82657 | 0.42386 | 3.21652 | 1.74978 | 0.38747 | 0.50241 | 2.63886 | 10/24/2019 | 10 | 9 | 1 | 44 | 0 | 0 | 44 | 09/20/2018 | 26 | 20 | 8 | 184 | 1 | 0 | 184 | 2017-07-20 | 9 | 3 | 6 | 1 | 40 | 0 | 40 | 90 | 0 | 8 | 0 | 0.00 | 0 | 0 | 1471 WILLS CREEK VALLEY DRIVE CAMBRIDGE, OH 43725 (40.046775, -81.580488) | 02/01/2020 | |||||||||||
12566 | 12566 | 1700 MARKET STREET CAMP HILL, PA 17011 | 40.240015 | -76.913592 | 0 | 395440 | MANORCARE HEALTH SERVICES-CAMP HILL | 1700 MARKET STREET | CAMP HILL | PA | 17011 | 7177378551 | 270 | Cumberland | Non profit - Other | 123 | 109.7 | Medicare and Medicaid | false | MANOR CARE OF CAMP HILL PA LLC | 04/01/1979 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 4 | 3 | 3 | 1.86602 | 0.99279 | 0.68976 | 1.68255 | 3.54857 | 0.10109 | 2.19237 | 0.77734 | 0.3741 | 3.34381 | 1.76896 | 0.96035 | 0.69397 | 3.40302 | 05/09/2019 | 19 | 14 | 5 | 255 | 1 | 0 | 255 | 06/07/2018 | 11 | 11 | 0 | 44 | 1 | 0 | 44 | 2017-07-20 | 20 | 17 | 3 | 1 | 116 | 0 | 116 | 161.5 | 3 | 6 | 0 | 0.00 | 0 | 0 | 1700 MARKET STREET CAMP HILL, PA 17011 (40.240015, -76.913592) | 02/01/2020 | |||||||||||
13146 | 13146 | 5215 S SUGAR RD EDINBURG, TX 78539 | 26.253429 | -98.186307 | 0 | 675785 | EDINBURG NURSING AND REHABILITATION CENTER | 5215 S SUGAR RD | EDINBURG | TX | 78539 | 9567829666 | 650 | Hidalgo | For profit - Corporation | 120 | 108.3 | Medicare and Medicaid | false | REGENCY IHS OF EDINBURG LLC | 05/12/1999 | false | false | false | false | Resident | Yes | 1 | 2 | 3 | 3 | 3 | 1 | 1 | 2.29958 | 0.81339 | 0.35537 | 1.16876 | 3.46834 | 0.02753 | 2.23089 | 0.87605 | 0.44168 | 3.54861 | 2.14233 | 0.69816 | 0.30284 | 3.13412 | 10/03/2019 | 13 | 8 | 5 | 72 | 1 | 0 | 72 | 08/27/2018 | 12 | 11 | 1 | 88 | 1 | 0 | 88 | 2017-07-20 | 3 | 2 | 1 | 1 | 16 | 0 | 16 | 68 | 0 | 2 | 0 | 0.00 | 0 | 0 | 5215 S SUGAR RD EDINBURG, TX 78539 (26.253429, -98.186307) | 02/01/2020 | |||||||||||
13526 | 13526 | 7210 NORTHLINE DR HOUSTON, TX 77076 | 29.86649 | -95.397795 | 0 | 675423 | ASHFORD GARDENS | 7210 NORTHLINE DR | HOUSTON | TX | 77076 | 7136992882 | 610 | Harris | Government - Hospital district | 202 | 86.2 | Medicare and Medicaid | false | MEMORIAL MEDICAL CENTER | 10/06/1994 | false | false | false | false | Both | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 2.14697 | 1.09963 | 0.2094 | 1.30903 | 3.456 | 0.04737 | 2.05745 | 0.8481 | 0.45743 | 3.36299 | 2.16876 | 0.97495 | 0.1723 | 3.29535 | 06/20/2019 | 11 | 9 | 2 | 64 | 1 | 0 | 64 | 06/29/2018 | 19 | 12 | 7 | 350 | 1 | 0 | 350 | 2017-07-20 | 10 | 5 | 5 | 1 | 64 | 0 | 64 | 159.333 | 1 | 15 | 1 | 87793.00 | 0 | 1 | 7210 NORTHLINE DR HOUSTON, TX 77076 (29.86649, -95.397795) | 02/01/2020 | |||||||||
13734 | 13734 | 7143 US-23, Piketon, OH 45661, USA | 39.0588142 | -83.02134939999999 | 1 | ROOFTOP | 365446 | THE PAVILION AT PIKETON | 7143 ROUTE 23 SOUTH | PIKETON | OH | 45661 | 7402892394 | 670 | Pike | For profit - Corporation | 155 | 109.4 | Medicare and Medicaid | false | PAVILION AT PIKETON FOR NURSING AND REHABILITATION LLC | 02/08/1980 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 1.81574 | 0.66592 | 0.51468 | 1.18061 | 2.99635 | 0.04556 | 2.10273 | 0.93879 | 0.56879 | 3.61031 | 1.79468 | 0.53338 | 0.34058 | 2.66134 | 11/07/2019 | 14 | 12 | 2 | 64 | 1 | 0 | 64 | 10/04/2018 | 16 | 14 | 9 | 218 | 1 | 0 | 218 | 2017-07-20 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 106.667 | 0 | 7 | 1 | 27254.00 | 0 | 1 | 02/01/2020 | |||||||||||
13995 | 13995 | 68637 BANNOCK ROAD ST CLAIRSVILLE, OH 43950 | 40.083051 | -80.971945 | 0 | 366177 | CUMBERLAND POINTE CARE CENTER | 68637 BANNOCK ROAD | ST CLAIRSVILLE | OH | 43950 | 7406952500 | 60 | Belmont | For profit - Corporation | 90 | 73.9 | Medicare and Medicaid | false | ST. CLAIRSVILLE POINTE, INC. | 07/27/1999 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 2 | 2 | 1.91082 | 0.90265 | 0.6191 | 1.52175 | 3.43257 | 0.07258 | 2.22911 | 0.92539 | 0.65443 | 3.80893 | 1.78157 | 0.73347 | 0.35606 | 2.88981 | 10/04/2019 | 17 | 11 | 6 | 151 | 1 | 0 | 151 | 09/13/2018 | 21 | 12 | 9 | 108 | 1 | 0 | 108 | 2017-07-20 | 22 | 13 | 9 | 1 | 104 | 0 | 104 | 128.833 | 0 | 20 | 0 | 0.00 | 1 | 1 | 68637 BANNOCK ROAD ST CLAIRSVILLE, OH 43950 (40.083051, -80.971945) | 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 );