nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
21 rows where Health Inspection Rating = 1 and ownership = "Government - State"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, nmbr_beds, prvdr_type, Provider Resides in Hospital, Legal Business Name, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44 | 44 | 3550 MS-468, Pearl, MS 39208, USA | 32.2419352 | -90.07072869999999 | 1 | ROOFTOP | 25A403 | JNH-ADAMS INN | 3550 HIGHWAY 468 WEST PO BOX 207, BUILDING 31 | WHITFIELD | MS | 39193 | 6013518015 | 600 | Rankin | Government - State | 59 | 45 | Medicaid | false | Legal Business Name Not Available | 06/25/2001 | false | false | false | false | Both | Yes | 1 | 1 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 06/13/2019 | 8 | 8 | 0 | 40 | 1 | 0 | 40 | 06/28/2017 | 5 | 1 | 4 | 84 | 1 | 0 | 84 | 2016-04-15 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 51.333 | 1 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
1082 | 1082 | 1620 WHEELER STREET EMPORIA, KS 66801 | 38.418428 | -96.212357 | 0 | 175280 | FLINT HILLS CARE CENTER | 1620 WHEELER STREET | EMPORIA | KS | 66801 | 6203423280 | 550 | Lyon | Government - State | 41 | 38.9 | Medicare and Medicaid | false | Legal Business Name Not Available | 11/01/1994 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 2.4447 | 0.48389 | 0.5828 | 1.06669 | 3.51139 | 0.01275 | 1.82091 | 0.71055 | 0.35575 | 2.88721 | 2.7903 | 0.51208 | 0.6166 | 3.8999 | 02/06/2019 | 18 | 16 | 2 | 116 | 1 | 0 | 116 | 02/14/2018 | 19 | 17 | 7 | 112 | 1 | 0 | 112 | 2016-07-28 | 16 | 14 | 2 | 1 | 261 | 0 | 261 | 138.833 | 4 | 2 | 1 | 7414.00 | 0 | 1 | 1620 WHEELER STREET EMPORIA, KS 66801 (38.418428, -96.212357) | 02/01/2020 | |||||||||||
1142 | 1142 | 821 21ST AVENUE LEWISTON, ID 83501 | 46.398541 | -117.019311 | 0 | 135133 | IDAHO STATE VETERANS HOME - LEWISTON | 821 21ST AVENUE | LEWISTON | ID | 83501 | 2087503600 | 340 | Nez Perce | Government - State | 66 | 54.8 | Medicare and Medicaid | false | DIVISION OF VETERANS SERVICES | 12/01/2007 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 2 | 5 | 5 | 2.10586 | 0.60858 | 0.93206 | 1.54064 | 3.6465 | 0.01474 | 1.9119 | 0.6686 | 0.29819 | 2.87868 | 2.28918 | 0.68445 | 1.17648 | 4.06196 | 04/26/2019 | 10 | 9 | 4 | 247 | 3 | 173 | 420 | 01/26/2018 | 8 | 8 | 2 | 68 | 1 | 0 | 68 | 2016-10-06 | 5 | 4 | 1 | 1 | 32 | 0 | 32 | 238 | 0 | 3 | 2 | 63902.00 | 0 | 2 | 821 21ST AVENUE LEWISTON, ID 83501 (46.398541, -117.019311) | 02/01/2020 | ||||||||||
1414 | 1414 | 800 CASINO CREEK DR LEWISTOWN, MT 59457 | 47.056606 | -109.423964 | 0 | 27A052 | MONTANA MENTAL HEALTH NURSING HOME | 800 CASINO CREEK DR | LEWISTOWN | MT | 59457 | 4065387451 | 130 | Fergus | Government - State | 117 | 76.2 | Medicaid | false | Legal Business Name Not Available | 06/01/1991 | false | SFF Candidate | false | false | false | None | Yes | 2 | 1 | 5 | 5 | 2 | 5 | 5 | 3.86057 | 0.01878 | 1.36033 | 1.37912 | 5.23969 | 0 | 1.73868 | 0.56394 | 0.25589 | 2.55852 | 4.61474 | 0.02505 | 2.00089 | 6.56705 | 04/18/2019 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 02/22/2018 | 22 | 18 | 4 | 497 | 2 | 249 | 746 | 2016-09-01 | 13 | 6 | 7 | 1 | 342 | 0 | 342 | 317.667 | 0 | 8 | 0 | 0.00 | 0 | 0 | 800 CASINO CREEK DR LEWISTOWN, MT 59457 (47.056606, -109.423964) | 02/01/2020 | ||||||||||
1641 | 1641 | 500 PEABODY PEABODY, KS 66866 | 38.169458 | -97.116319 | 0 | 1.7e+211 | FRANKLIN HEALTHCARE OF PEABODY LLC | 500 PEABODY | PEABODY | KS | 66866 | 6209832165 | 570 | Marion | Government - State | 45 | 36.6 | Medicaid | false | Legal Business Name Not Available | 01/01/1982 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 1.16723 | 0.60517 | 0.41165 | 1.01682 | 2.18405 | 0 | 1.37735 | 0.55856 | 0.25742 | 2.19333 | 1.76128 | 0.8147 | 0.60188 | 3.1931 | 02/28/2019 | 20 | 19 | 3 | 152 | 1 | 0 | 152 | 03/05/2018 | 21 | 11 | 10 | 247 | 1 | 0 | 247 | 2016-05-18 | 2 | 1 | 1 | 1 | 20 | 0 | 20 | 161.667 | 4 | 4 | 0 | 0.00 | 0 | 0 | 500 PEABODY PEABODY, KS 66866 (38.169458, -97.116319) | 02/01/2020 | |||||||||
1958 | 1958 | 445 N WESTVIEW DR DERBY, KS 67037 | 37.547318 | -97.264453 | 0 | 175218 | WESTVIEW OF DERBY | 445 N WESTVIEW DR | DERBY | KS | 67037 | 3167883739 | 860 | Sedgwick | Government - State | 45 | 34.4 | Medicare and Medicaid | false | LSL OF DERBY KS LLC | 04/01/1992 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 1 | 12 | 1 | 12 | 2.19942 | 0.78946 | 0.2983 | 1.08775 | 3.28717 | 0 | 1.94018 | 0.65834 | 0.28824 | 2.88675 | 2.35604 | 0.9017 | 0.38952 | 3.65145 | 12/03/2019 | 9 | 0 | 9 | 135 | 1 | 0 | 135 | 09/11/2018 | 9 | 5 | 5 | 236 | 1 | 0 | 236 | 2017-02-07 | 13 | 11 | 10 | 1 | 92 | 0 | 92 | 161.5 | 5 | 7 | 0 | 0.00 | 0 | 0 | 445 N WESTVIEW DR DERBY, KS 67037 (37.547318, -97.264453) | 02/01/2020 | |||||||||
2473 | 2473 | 132 EVERGREEN RD EDISON, NJ 08818 | 40.553918 | -74.332987 | 0 | 315459 | NEW JERSEY VETERANS MEMORIAL HOME MENLO | 132 EVERGREEN RD | EDISON | NJ | 8818 | 7324524100 | 270 | Middlesex | Government - State | 328 | 289.1 | Medicare | false | NEW JERSEY VETERANS MEMORIAL HOME MENLO PARK | 10/26/1999 | false | false | false | false | Both | Yes | 2 | 1 | 2 | 3 | 1 | 5 | 5 | 2.66109 | 0.81017 | 0.79769 | 1.60786 | 4.26895 | 0.03983 | 1.89949 | 0.60734 | 0.25499 | 2.76182 | 2.91165 | 1.00306 | 1.17746 | 4.95655 | 01/15/2019 | 15 | 14 | 1 | 60 | 1 | 0 | 60 | 09/29/2017 | 7 | 7 | 0 | 36 | 1 | 0 | 36 | 2016-09-19 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 46 | 0 | 2 | 0 | 0.00 | 0 | 0 | 132 EVERGREEN RD EDISON, NJ 08818 (40.553918, -74.332987) | 02/01/2020 | |||||||||||
2498 | 2498 | 1005 E CENTENNIAL DRIVE PITTSBURG, KS 66762 | 37.381788 | -94.688739 | 0 | 175208 | PITTSBURG OPERATOR LLC | 1005 E CENTENNIAL DRIVE | PITTSBURG | KS | 66762 | 6202311120 | 180 | Crawford | Government - State | 86 | 63.2 | Medicare and Medicaid | false | PITTSBURG OPERATOR, LLC | 05/15/1991 | false | true | false | true | Resident | Yes | 1 | 1 | 3 | 2 | 5 | 3 | 3 | 2.59714 | 0.4351 | 0.64413 | 1.07922 | 3.67636 | 0 | 1.85742 | 0.69344 | 0.33425 | 2.88511 | 2.90603 | 0.47181 | 0.72532 | 4.08611 | 08/05/2019 | 20 | 15 | 19 | 160 | 1 | 0 | 160 | 09/27/2018 | 28 | 22 | 13 | 192 | 1 | 0 | 192 | 2016-12-01 | 14 | 13 | 1 | 1 | 390 | 0 | 390 | 209 | 2 | 11 | 3 | 79057.00 | 1 | 4 | 1005 E CENTENNIAL DRIVE PITTSBURG, KS 66762 (37.381788, -94.688739) | 02/01/2020 | |||||||||||
3525 | 3525 | 505 N MAIN STREET ESKRIDGE, KS 66423 | 38.8633 | -96.104597 | 0 | 175455 | ESKRIDGE OPERATOR LLC | 505 N. MAIN STREET | ESKRIDGE | KS | 66423 | 7854492294 | 980 | Wabaunsee | Government - State | 60 | 57.8 | Medicare and Medicaid | false | ESKRIDGE OPERATOR LLC | 07/23/2002 | false | false | false | true | Resident | Yes | 1 | 1 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 01/15/2019 | 15 | 15 | 4 | 140 | 1 | 0 | 140 | 12/14/2017 | 10 | 10 | 2 | 92 | 1 | 0 | 92 | 2016-02-23 | 14 | 6 | 8 | 1 | 136 | 0 | 136 | 123.333 | 2 | 7 | 2 | 19810.00 | 0 | 2 | 505 N MAIN STREET ESKRIDGE, KS 66423 (38.8633, -96.104597) | 02/01/2020 | |||||||||||||||||||||
4356 | 4356 | 900 COUNTRY CLUB LANE EL DORADO, KS 67042 | 37.839212 | -96.838869 | 0 | 175324 | EL DORADO OPERATOR LLC | 900 COUNTRY CLUB LANE | EL DORADO | KS | 67042 | 3163214444 | 70 | Butler | Government - State | 50 | 39.1 | Medicare and Medicaid | false | EL DORADO OPERATOR LLC | 10/01/1994 | false | false | false | true | Resident | Yes | 1 | 1 | 1 | 1 | 3 | 1 | 12 | 1 | 12 | 2.38169 | 0.80476 | 0.5976 | 1.40236 | 3.78405 | 0 | 1.8789 | 0.74949 | 0.36643 | 2.99482 | 2.6345 | 0.80739 | 0.61384 | 4.05172 | 06/27/2019 | 15 | 15 | 2 | 144 | 1 | 0 | 144 | 09/27/2018 | 9 | 6 | 3 | 44 | 1 | 0 | 44 | 2017-03-08 | 20 | 13 | 7 | 1 | 148 | 0 | 148 | 111.333 | 9 | 0 | 1 | 3900.00 | 1 | 2 | 900 COUNTRY CLUB LANE EL DORADO, KS 67042 (37.839212, -96.838869) | 02/01/2020 | |||||||||
5242 | 5242 | 2401 JOHN ASHLEY DRIVE NORTH LITTLE ROCK, AR 72114 | 34.780813 | -92.289742 | 0 | 45462 | ARKANSAS STATE VETERANS HOME AT NORTH LITTLE ROCK | 2401 JOHN ASHLEY DRIVE | NORTH LITTLE ROCK | AR | 72114 | 5016832382 | 590 | Pulaski | Government - State | 96 | 91.9 | Medicare and Medicaid | false | STATE OF ARKANSAS | 04/27/2017 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 5 | 5 | 2.87967 | 1.16505 | 0.74425 | 1.9093 | 4.78897 | 0.00758 | 1.65401 | 0.60323 | 0.26694 | 2.52417 | 3.61843 | 1.45227 | 1.04941 | 6.08381 | 05/23/2019 | 21 | 20 | 1 | 196 | 1 | 0 | 196 | 07/13/2018 | 10 | 5 | 5 | 490 | 1 | 0 | 490 | 2017-04-27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 261.333 | 2 | 3 | 1 | 63060.00 | 0 | 1 | 2401 JOHN ASHLEY DRIVE NORTH LITTLE ROCK, AR 72114 (34.780813, -92.289742) | 02/01/2020 | |||||||||||
7696 | 7696 | 750 BLAKE STREET EDWARDSVILLE, KS 66111 | 39.056904 | -94.816912 | 0 | 175219 | KAW RIVER OPERATOR, LLC | 750 BLAKE STREET | EDWARDSVILLE | KS | 66111 | 9134225832 | 986 | Wyandotte | Government - State | 45 | 39.5 | Medicare and Medicaid | false | KAW RIVER OPERATOR, LLC | 03/01/1992 | false | true | false | true | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 2.57581 | 0.5828 | 0.42928 | 1.01208 | 3.58789 | 0.02142 | 1.9812 | 0.75096 | 0.37576 | 3.10793 | 2.7021 | 0.58356 | 0.42999 | 3.70187 | 03/04/2019 | 11 | 9 | 2 | 115 | 1 | 0 | 115 | 04/17/2018 | 20 | 19 | 20 | 152 | 1 | 0 | 152 | 2016-02-22 | 8 | 8 | 0 | 1 | 64 | 0 | 64 | 118.833 | 3 | 2 | 1 | 13328.00 | 0 | 1 | 750 BLAKE STREET EDWARDSVILLE, KS 66111 (39.056904, -94.816912) | 02/01/2020 | |||||||||
7717 | 7717 | 1112 SE REPUBLICAN AVENUE TOPEKA, KS 66607 | 39.041478 | -95.648537 | 0 | 175418 | PROVIDENCE LIVING CENTER | 1112 SE REPUBLICAN AVENUE | TOPEKA | KS | 66607 | 7852330588 | 880 | Shawnee | Government - State | 78 | 65.8 | Medicare and Medicaid | false | PROVIDENCE LIVING CENTER, INC. | 08/01/1997 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 06/13/2019 | 5 | 5 | 5 | 32 | 1 | 0 | 32 | 07/26/2018 | 27 | 23 | 15 | 264 | 1 | 0 | 264 | 2016-11-29 | 13 | 12 | 1 | 2 | 267 | 134 | 401 | 170.833 | 3 | 15 | 1 | 37877.00 | 1 | 2 | 1112 SE REPUBLICAN AVENUE TOPEKA, KS 66607 (39.041478, -95.648537) | 02/01/2020 | |||||||||||||||||||||
8261 | 8261 | 54 Hospital Rd, Kapaau, HI 96755, USA | 20.2305329 | -155.7986628 | 1 | RANGE_INTERPOLATED | 125031 | KOHALA HOSPITAL | 54-383 HOSPITAL ROAD | KAPAAU | HI | 96755 | 8088896211 | 10 | Hawaii | Government - State | 22 | 20.5 | Medicare and Medicaid | true | KOHALA HOSPITAL | 01/01/1977 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 2 | 2 | 2 | 5 | 5 | 3.1252 | 0.22942 | 1.50146 | 1.73088 | 4.85608 | 0.06877 | 1.87854 | 0.65177 | 0.30881 | 2.83913 | 3.45758 | 0.26468 | 1.82998 | 5.48472 | 06/06/2019 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 06/06/2018 | 25 | 19 | 8 | 585 | 1 | 0 | 585 | 2016-12-09 | 13 | 13 | 0 | 1 | 80 | 0 | 80 | 224.333 | 3 | 1 | 2 | 159798.00 | 0 | 2 | 02/01/2020 | ||||||||||
10338 | 10338 | 150 HOPEMONT DRIVE TERRA ALTA, WV 26764 | 39.437903 | -79.519598 | 0 | 5.1e+149 | HOPEMONT HOSPITAL | 150 HOPEMONT DRIVE | TERRA ALTA | WV | 26764 | 3047892411 | 380 | Preston | Government - State | 98 | 48.8 | Medicaid | false | Legal Business Name Not Available | 03/30/1988 | false | false | false | false | Both | Yes | 2 | 1 | 3 | 3 | 2 | 4 | 3 | 3.34755 | 1.0995 | 0.45635 | 1.55585 | 4.9034 | 0.01069 | 1.76166 | 0.59981 | 0.27738 | 2.63884 | 3.94931 | 1.37837 | 0.61924 | 5.9585 | 02/08/2019 | 23 | 19 | 4 | 212 | 1 | 0 | 212 | 11/02/2017 | 15 | 9 | 6 | 233 | 1 | 0 | 233 | 2016-10-05 | 12 | 3 | 9 | 1 | 72 | 0 | 72 | 195.667 | 0 | 10 | 0 | 0.00 | 0 | 0 | 150 HOPEMONT DRIVE TERRA ALTA, WV 26764 (39.437903, -79.519598) | 02/01/2020 | |||||||||||
11293 | 11293 | 21425 E SPRING ST UNION GROVE, WI 53182 | 42.698622 | -88.081171 | 0 | 525688 | WI VETERANS HOME-BOLAND HALL | 21425 E SPRING ST | UNION GROVE | WI | 53182 | 2628786702 | 500 | Racine | Government - State | 158 | 150.3 | Medicare and Medicaid | false | STATE OF WISCONSIN | 12/01/2006 | false | false | false | false | Both | Yes | 2 | 1 | 4 | 4 | 3 | 5 | 5 | 2.79908 | 0.6311 | 1.11753 | 1.74863 | 4.5477 | 0.02404 | 1.97375 | 0.6752 | 0.28841 | 2.93736 | 2.9474 | 0.70283 | 1.4584 | 4.96464 | 02/21/2019 | 20 | 20 | 5 | 128 | 1 | 0 | 128 | 12/19/2017 | 22 | 17 | 22 | 187 | 1 | 0 | 187 | 2016-09-14 | 14 | 13 | 1 | 1 | 72 | 0 | 72 | 138.333 | 2 | 6 | 3 | 67246.00 | 0 | 3 | 21425 E SPRING ST UNION GROVE, WI 53182 (42.698622, -88.081171) | 02/01/2020 | |||||||||||
11864 | 11864 | 1301 ORTING-KAPOWSIN HWY E ORTING, WA 98360 | 47.082367 | -122.214314 | 0 | 505516 | WASHINGTON SOLDIERS HOME | 1301 ORTING-KAPOWSIN HWY E | ORTING | WA | 98360 | 3608934515 | 260 | Pierce | Government - State | 97 | 86.4 | Medicare and Medicaid | false | STATE OF WASHINGTON WASHINGTON SOLDIERS HOME | 01/01/2007 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 3 | 3 | 4 | 5 | 5 | 2.81674 | 0.92989 | 0.99652 | 1.92641 | 4.74315 | 0.01829 | 1.97169 | 0.70307 | 0.30886 | 2.98362 | 2.9691 | 0.99453 | 1.21437 | 5.09773 | 03/13/2019 | 12 | 12 | 0 | 60 | 1 | 0 | 60 | 03/02/2018 | 16 | 16 | 0 | 84 | 1 | 0 | 84 | 2017-04-07 | 50 | 31 | 43 | 2 | 1453 | 727 | 2180 | 421.333 | 21 | 1 | 1 | 16084.00 | 0 | 1 | 1301 ORTING-KAPOWSIN HWY E ORTING, WA 98360 (47.082367, -122.214314) | 02/01/2020 | ||||||||||
12009 | 12009 | 2200 HARDEN STREET COLUMBIA, SC 29203 | 34.018869 | -81.024785 | 0 | 425360 | C M TUCKER NURSING CARE CENTER / RODDEY | 2200 HARDEN STREET | COLUMBIA | SC | 29203 | 8037375300 | 390 | Richland | Government - State | 308 | 168.6 | Medicare and Medicaid | false | SOUTH CAROLINA DEPT OF MENTAL HEALTH ACCOUNTING OFFICE | 10/03/1997 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 2 | 5 | 5 | 3.9608 | 1.08056 | 1.12519 | 2.20575 | 6.16655 | 0.05474 | 1.92411 | 0.60579 | 0.2607 | 2.7906 | 4.27827 | 1.34126 | 1.62447 | 7.08594 | 10/04/2018 | 7 | 7 | 0 | 28 | 1 | 0 | 28 | 08/16/2017 | 13 | 13 | 0 | 461 | 1 | 0 | 461 | 2016-09-09 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 169 | 0 | 0 | 3 | 118669.00 | 0 | 3 | 2200 HARDEN STREET COLUMBIA, SC 29203 (34.018869, -81.024785) | 02/01/2020 | |||||||||||
12373 | 12373 | 500 Municipal Dr, Hollidaysburg, PA 16648, USA | 40.44388970000001 | -78.4153366 | 1 | ROOFTOP | 39A437 | HOLLIDAYSBURG VETERANS HOME | PO BOX 319 | HOLLIDAYSBURG | PA | 16648 | 8146965356 | 120 | Blair | Government - State | 257 | 231.5 | Medicaid | false | Legal Business Name Not Available | 01/01/2009 | false | false | false | false | Both | Yes | 2 | 1 | 5 | 5 | 2 | 5 | 5 | 2.61088 | 1.17805 | 0.89235 | 2.07039 | 4.68127 | 0.02376 | 2.0074 | 0.62525 | 0.28279 | 2.91543 | 2.70314 | 1.41675 | 1.1877 | 5.14889 | 10/25/2018 | 24 | 22 | 3 | 124 | 1 | 0 | 124 | 12/15/2017 | 14 | 14 | 1 | 72 | 1 | 0 | 72 | 2017-02-17 | 17 | 15 | 2 | 1 | 68 | 0 | 68 | 97.333 | 1 | 4 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
13890 | 13890 | South Mountain, PA, USA | 39.8465059 | -77.4901975 | 1 | APPROXIMATE | 395583 | SOUTH MOUNTAIN RESTORATION CEN | BUILDING #1 | SOUTH MOUNTAIN | PA | 17261 | 7177493121 | 350 | Franklin | Government - State | 159 | 134.2 | Medicare and Medicaid | false | PENNSYLVANIA DEPARTMENT OF HUMAN SERVICES | 07/01/1985 | false | false | false | false | Both | Yes | 2 | 1 | 4 | 4 | 2 | 5 | 5 | 2.36184 | 0.96438 | 1.01733 | 1.98172 | 4.34356 | 0.03726 | 1.99816 | 0.62003 | 0.26629 | 2.88448 | 2.45661 | 1.16955 | 1.43795 | 4.82871 | 02/07/2019 | 24 | 22 | 6 | 112 | 1 | 0 | 112 | 03/15/2018 | 9 | 9 | 0 | 44 | 1 | 0 | 44 | 2017-03-30 | 19 | 14 | 5 | 2 | 225 | 113 | 338 | 127 | 2 | 5 | 1 | 9899.00 | 0 | 1 | 02/01/2020 | |||||||||||
14554 | 14554 | 2461 SIDNEY ROAD WALTERBORO, SC 29488 | 32.949562 | -80.612836 | 0 | 425386 | VETERANS VICTORY HOUSE | 2461 SIDNEY ROAD | WALTERBORO | SC | 29488 | 8435383000 | 140 | Colleton | Government - State | 220 | 214.3 | Medicare and Medicaid | false | SOUTH CAROLINA DEPT OF MENTAL HEALTH ACCOUNTING OFFICE | 10/03/2007 | false | SFF Candidate | true | false | false | Both | Yes | 2 | 1 | 5 | 5 | 2 | 4 | 4 | 2.61741 | 0.9092 | 0.54051 | 1.44971 | 4.06712 | 0.02195 | 1.83043 | 0.59088 | 0.24755 | 2.66886 | 2.97189 | 1.15704 | 0.82181 | 4.88668 | 05/31/2019 | 7 | 2 | 5 | 104 | 1 | 0 | 104 | 03/02/2018 | 10 | 3 | 7 | 848 | 1 | 0 | 848 | 2016-11-17 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 338 | 19 | 0 | 1 | 260746.00 | 1 | 2 | 2461 SIDNEY ROAD WALTERBORO, SC 29488 (32.949562, -80.612836) | 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 );