nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
23 rows where Overall Rating = 2 and ownership = "Government - State"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, 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, Health Inspection 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
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 | |||||||||||
3355 | 3355 | 3550 MS-468, Pearl, MS 39208, USA | 32.2419352 | -90.07072869999999 | 1 | ROOFTOP | 25A402 | JNH-JEFFERSON INN | 3550 HWY 468 WEST - PO BOX 207 BLDG 33 | WHITFIELD | MS | 39193 | 6013518015 | 600 | Rankin | Government - State | 89 | 73.5 | Medicaid | false | Legal Business Name Not Available | 06/04/2001 | false | false | false | false | Both | Yes | 2 | 2 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 07/26/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 09/26/2018 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-05-24 | 9 | 8 | 2 | 1 | 48 | 0 | 48 | 26 | 0 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
3663 | 3663 | 100 MYRTLE BLVD GRACEWOOD, GA 30812 | 33.368396 | -82.026277 | 0 | 11A200 | GRACEWOOD NSG FACILITY(UNIT 9) | 100 MYRTLE BLVD., EAST CENTRAL REG HOSP | GRACEWOOD | GA | 30812 | 7067902097 | 840 | Richmond | Government - State | 56 | 24.4 | Medicaid | false | Legal Business Name Not Available | 10/01/1977 | false | false | false | false | Both | Yes | 2 | 3 | 4 | 4 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 09/26/2019 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 08/19/2018 | 3 | 3 | 0 | 32 | 1 | 0 | 32 | 2017-08-13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 100 MYRTLE BLVD GRACEWOOD, GA 30812 (33.368396, -82.026277) | 02/01/2020 | |||||||||||||||||||||
3810 | 3810 | 3851 N RIVER RD WEST LAFAYETTE, IN 47906 | 40.471635 | -86.885096 | 0 | 155787 | INDIANA VETERANS HOME | 3851 N RIVER RD | WEST LAFAYETTE | IN | 47906 | 7654631502 | 780 | Tippecanoe | Government - State | 331 | 164.3 | Medicare and Medicaid | false | STATE OF INDIANA AUDITOR OF STATE | 03/04/2011 | false | false | false | false | Resident | Yes | 2 | 2 | 1 | 2 | 1 | 4 | 4 | 2.9056 | 0.60444 | 0.65379 | 1.25823 | 4.16383 | 0.01511 | 1.86715 | 0.63662 | 0.28561 | 2.78938 | 3.23425 | 0.71393 | 0.86158 | 4.78673 | 05/22/2019 | 8 | 8 | 0 | 56 | 1 | 0 | 56 | 04/19/2018 | 12 | 7 | 5 | 72 | 1 | 0 | 72 | 2017-04-03 | 8 | 6 | 2 | 1 | 52 | 0 | 52 | 60.667 | 3 | 8 | 0 | 0.00 | 0 | 0 | 3851 N RIVER RD WEST LAFAYETTE, IN 47906 (40.471635, -86.885096) | 02/01/2020 | |||||||||||
5240 | 5240 | 200 CUSTER FORT DODGE, KS 67801 | 37.731931 | -99.935564 | 0 | 175513 | KANSAS SOLDIERS HOME | 200 CUSTER, UNIT 98 | FORT DODGE | KS | 67801 | 6202272121 | 280 | Ford | Government - State | 56 | 52.4 | Medicare and Medicaid | false | STATE OF KANSAS ACCOUNTING SERVICES | 09/17/2009 | false | true | false | false | Resident | Yes | 2 | 2 | 1 | 1 | 2 | 5 | 5 | 4.10009 | 0.34781 | 0.95926 | 1.30707 | 5.40716 | 0.00589 | 1.80544 | 0.61484 | 0.27543 | 2.69572 | 4.71982 | 0.42537 | 1.31086 | 6.43203 | 03/04/2019 | 20 | 13 | 20 | 128 | 1 | 0 | 128 | 03/08/2018 | 4 | 4 | 4 | 20 | 1 | 0 | 20 | 2016-02-11 | 12 | 10 | 2 | 1 | 84 | 0 | 84 | 84.667 | 1 | 5 | 1 | 22094.00 | 1 | 2 | 200 CUSTER FORT DODGE, KS 67801 (37.731931, -99.935564) | 02/01/2020 | |||||||||||
5963 | 5963 | 612 WALNUT COTTONWOOD FALLS, KS 66845 | 38.363869 | -96.538969 | 0 | 175223 | CHASE COUNTY OPERATOR LLC | 612 WALNUT, PO BOX 589 | COTTONWOOD FALLS | KS | 66845 | 6202736360 | 80 | Chase | Government - State | 45 | 24.3 | Medicare and Medicaid | false | CHASE COUNTY OPERATOR, LLC | 06/01/1992 | false | false | false | true | Resident | Yes | 2 | 2 | 3 | 5 | 2 | 3 | 3 | 1.95219 | 0.78956 | 0.51794 | 1.3075 | 3.25969 | 0 | 1.8932 | 0.73571 | 0.37897 | 3.00788 | 2.1431 | 0.80697 | 0.51441 | 3.47511 | 04/01/2019 | 11 | 11 | 3 | 100 | 1 | 0 | 100 | 06/08/2018 | 9 | 7 | 2 | 88 | 1 | 0 | 88 | 2016-08-16 | 15 | 15 | 0 | 1 | 92 | 0 | 92 | 94.667 | 1 | 2 | 0 | 0.00 | 0 | 0 | 612 WALNUT COTTONWOOD FALLS, KS 66845 (38.363869, -96.538969) | 02/01/2020 | |||||||||||
6185 | 6185 | 509 GROVE STREET WAKEFIELD, KS 67487 | 39.21529 | -97.017642 | 0 | 175272 | WAKEFIELD OPERATOR LLC | 509 GROVE STREET | WAKEFIELD | KS | 67487 | 7854615417 | 130 | Clay | Government - State | 45 | 43.5 | Medicare and Medicaid | false | WAKEFIELD OPERATOR LLC | 11/01/1993 | false | false | false | true | Resident | Yes | 2 | 3 | 1 | 1 | 1 | 3 | 4 | 2.24016 | 0.22809 | 0.84494 | 1.07302 | 3.31318 | 0 | 1.90284 | 0.74325 | 0.36707 | 3.01317 | 2.44676 | 0.23075 | 0.86637 | 3.52594 | 04/04/2019 | 4 | 4 | 4 | 16 | 1 | 0 | 16 | 02/14/2018 | 17 | 17 | 0 | 144 | 1 | 0 | 144 | 2016-06-16 | 1 | 0 | 1 | 0 | 4 | 0 | 4 | 56.667 | 0 | 2 | 0 | 0.00 | 1 | 1 | 509 GROVE STREET WAKEFIELD, KS 67487 (39.21529, -97.017642) | 02/01/2020 | |||||||||||
7078 | 7078 | 1220 Ww II Memorial Dr, Winfield, KS 67156, USA | 37.2607767 | -96.96890440000001 | 1 | ROOFTOP | 175516 | KANSAS VETERANS HOME | 1220 WORLD WAR II MEMORIAL DRIVE | WINFIELD | KS | 67156 | 6202219479 | 170 | Cowley | Government - State | 142 | 86.5 | Medicare and Medicaid | false | STATE OF KANSAS ACCOUNTING SERVICES | 09/01/2010 | false | false | false | false | Both | Yes | 2 | 2 | 1 | 1 | 2 | 4 | 4 | 3.68551 | 1.06603 | 0.79352 | 1.85955 | 5.54506 | 0.01222 | 2.12737 | 0.67248 | 0.30317 | 3.10303 | 3.60055 | 1.19199 | 0.98514 | 5.73025 | 04/03/2019 | 7 | 7 | 0 | 48 | 1 | 0 | 48 | 06/01/2018 | 16 | 15 | 1 | 112 | 1 | 0 | 112 | 2016-09-27 | 16 | 14 | 2 | 1 | 148 | 0 | 148 | 86 | 3 | 3 | 3 | 26275.00 | 1 | 4 | 02/01/2020 | |||||||||||
7132 | 7132 | 425 FISHER ST MARQUETTE, MI 49855 | 46.540075 | -87.401901 | 0 | 235724 | DJ JACOBETTI HOME FOR VETERANS | 425 FISHER ST | MARQUETTE | MI | 49855 | 9062263576 | 510 | Marquette | Government - State | 81 | 73.9 | Medicare and Medicaid | false | STATE OF MICHIGAN | 09/30/2018 | false | false | false | false | Both | Yes | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 6 | 6 | 09/12/2019 | 9 | 8 | 1 | 198 | 1 | 0 | 198 | 08/31/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | . | . | . | . | . | . | . | 118.8 | 8 | 0 | 1 | 26745.00 | 1 | 2 | 425 FISHER ST MARQUETTE, MI 49855 (46.540075, -87.401901) | 02/01/2020 | ||||||||||||||||||||||||
7583 | 7583 | 102 W BOTKIN STREET WELLINGTON, KS 67152 | 37.253251 | -97.398219 | 0 | 175337 | WELLINGTON OPERATOR LLC | 102 W BOTKIN STREET | WELLINGTON | KS | 67152 | 6203267437 | 950 | Sumner | Government - State | 45 | 40.2 | Medicare and Medicaid | false | WELLINGTON OPERATOR LLC | 12/15/1994 | false | false | false | true | Resident | Yes | 2 | 4 | 1 | 1 | 2 | 1 | 12 | 1 | 12 | 2.35234 | 0.50587 | 0.32411 | 0.82998 | 3.18232 | 0 | 1.86113 | 0.7052 | 0.33325 | 2.89958 | 2.62688 | 0.5394 | 0.36606 | 3.51935 | 12/07/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 09/12/2017 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 2016-02-08 | 6 | 6 | 0 | 1 | 44 | 0 | 44 | 21.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 102 W BOTKIN STREET WELLINGTON, KS 67152 (37.253251, -97.398219) | 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 | ||||||||||
8813 | 8813 | 200 VETERANS DR FLORESVILLE, TX 78114 | 29.129548 | -98.145702 | 0 | 675863 | FRANK M TEJEDA TEXAS STATE VETERANS HOME | 200 VETERANS DR | FLORESVILLE | TX | 78114 | 8302169456 | 971 | Wilson | Government - State | 160 | 152 | Medicare and Medicaid | false | STATE OF TEXAS VETERANS LAND BOARD | 01/25/2001 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 2 | 2 | 2 | 1.80947 | 0.85899 | 0.32205 | 1.18104 | 2.99051 | 0.02466 | 1.84623 | 0.62526 | 0.28118 | 2.75267 | 2.03695 | 1.03302 | 0.4311 | 3.48372 | 12/13/2019 | 20 | 20 | 0 | 128 | 1 | 0 | 128 | 12/07/2018 | 10 | 10 | 0 | 72 | 1 | 0 | 72 | 2017-11-17 | 9 | 9 | 0 | 1 | 80 | 0 | 80 | 101.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 200 VETERANS DR FLORESVILLE, TX 78114 (29.129548, -98.145702) | 02/01/2020 | |||||||||||
9978 | 9978 | 301 E YUMA AVE MCALLEN, TX 78503 | 26.177951 | -98.219627 | 0 | 676063 | ALFREDO GONZALEZ TEXAS STATE VETERANS HOME | 301 E YUMA AVE | MCALLEN | TX | 78503 | 9566824224 | 650 | Hidalgo | Government - State | 160 | 155.6 | Medicare and Medicaid | false | STATE OF TEXAS VETERANS LAND BOARD | 07/14/2005 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 5 | 1 | 2 | 2 | 2.13081 | 0.82817 | 0.35279 | 1.18096 | 3.31178 | 0.01018 | 2.15894 | 0.67496 | 0.2949 | 3.12879 | 2.05126 | 0.92263 | 0.45027 | 3.3942 | 09/12/2019 | 9 | 8 | 1 | 68 | 1 | 0 | 68 | 09/14/2018 | 13 | 12 | 1 | 112 | 1 | 0 | 112 | 2017-08-04 | 17 | 13 | 4 | 1 | 152 | 0 | 152 | 96.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 301 E YUMA AVE MCALLEN, TX 78503 (26.177951, -98.219627) | 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 | |||||||||||
11030 | 11030 | 454 MCDOWELL STREET WELCH, WV 24801 | 37.438822 | -81.589295 | 0 | 51A009 | WELCH COMMUNITY HOSPITAL | 454 MCDOWELL STREET | WELCH | WV | 24801 | 3044368680 | 230 | Mc Dowell | Government - State | 59 | 24.6 | Medicaid | true | Legal Business Name Not Available | 04/05/1999 | false | false | false | false | None | Yes | 2 | 4 | 1 | 1 | 2 | 1 | 12 | 1 | 12 | 2.45029 | 2.44107 | 0.57663 | 3.01769 | 5.46798 | 0 | 1.7288 | 0.62962 | 0.2824 | 2.64081 | 2.94571 | 2.91532 | 0.76853 | 6.63961 | 08/28/2019 | 9 | 9 | 0 | 32 | 1 | 0 | 32 | 08/17/2018 | 12 | 12 | 0 | 64 | 1 | 0 | 64 | 2017-06-22 | 9 | 9 | 0 | 1 | 68 | 0 | 68 | 48.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 454 MCDOWELL STREET WELCH, WV 24801 (37.438822, -81.589295) | 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 );