nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Overall Rating = 4 and Rating Cycle 2 Number of Standard Health Deficiencies = 19
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Provider Resides in Hospital, Date First Approved to Provide Medicare and Medicaid services, Abuse Icon, 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, RN Staffing Rating, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of 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 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, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2059 | 2059 | 1221 EAST ARROW HWY UPLAND, CA 91786 | 34.099786 | -117.634854 | 0 | 55374 | UPLAND REHABILITATION AND CARE CENTER | 1221 EAST ARROW HWY | UPLAND | CA | 91786 | 9099851903 | 460 | San Bernardino | For profit - Individual | 206 | 178.3 | Medicare and Medicaid | false | UPLAND COMMUNITY CARE INC | 01/01/1967 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 1 | 2.51971 | 1.88939 | 0.47227 | 2.36165 | 4.88136 | 0.11543 | 2.29508 | 0.8216 | 0.65209 | 3.76876 | 2.28175 | 1.7292 | 0.27259 | 4.15332 | 08/09/2019 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 07/27/2018 | 22 | 19 | 3 | 152 | 1 | 0 | 152 | 2017-08-10 | 8 | 6 | 2 | 1 | 48 | 0 | 48 | 70.667 | 0 | 6 | 0 | 0.00 | 0 | 0 | 1221 EAST ARROW HWY UPLAND, CA 91786 (34.099786, -117.634854) | 02/01/2020 | |||||||||||
3539 | 3539 | 814 E LINCOLN AVE IONIA, MI 48846 | 42.987357 | -85.043907 | 0 | 235032 | SKLD IONIA | 814 E LINCOLN AVE | IONIA | MI | 48846 | 6165270080 | 330 | Ionia | For profit - Limited Liability company | 107 | 71.5 | Medicare and Medicaid | false | IONIA SNF LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 4 | 3 | 3 | 3 | 3 | 4 | 4 | 2.41983 | 0.742 | 0.61454 | 1.35654 | 3.77637 | 0.07387 | 2.17212 | 0.70495 | 0.31131 | 3.18837 | 2.31535 | 0.79146 | 0.74301 | 3.79803 | 01/17/2019 | 5 | 5 | 0 | 48 | 1 | 0 | 48 | 12/19/2017 | 23 | 19 | 4 | 164 | 1 | 0 | 164 | 2016-10-12 | 8 | 7 | 1 | 1 | 56 | 0 | 56 | 88 | 7 | 3 | 2 | 27349.00 | 0 | 2 | 814 E LINCOLN AVE IONIA, MI 48846 (42.987357, -85.043907) | 02/01/2020 | |||||||||||
4145 | 4145 | 3322 SILVERSIDE ROAD WILMINGTON, DE 19810 | 39.808573 | -75.539564 | 0 | 85056 | CADIA REHABILITATION SILVERSIDE | 3322 SILVERSIDE ROAD | WILMINGTON | DE | 19810 | 3024788889 | 10 | New Castle | For profit - Corporation | 128 | 106.3 | Medicare and Medicaid | false | ONIX SILVERSIDE LLC | 12/05/2012 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 4 | 5 | 5 | 5 | 1.93136 | 0.7205 | 1.43767 | 2.15817 | 4.08953 | 0.19562 | 2.06908 | 0.77071 | 0.36637 | 3.20617 | 1.94 | 0.70295 | 1.47695 | 4.09016 | 06/25/2019 | 14 | 9 | 5 | 80 | 1 | 0 | 80 | 05/30/2018 | 19 | 19 | 0 | 88 | 1 | 0 | 88 | 2017-03-23 | 7 | 6 | 3 | 1 | 36 | 0 | 36 | 75.333 | 2 | 5 | 0 | 0.00 | 0 | 0 | 3322 SILVERSIDE ROAD WILMINGTON, DE 19810 (39.808573, -75.539564) | 02/01/2020 | |||||||||||
5272 | 5272 | 7900 WEST 28TH STREET SAINT LOUIS PARK, MN 55426 | 44.953026 | -93.380111 | 0 | 245187 | TEXAS TERRACE A VILLA CENTER | 7900 WEST 28TH STREET | SAINT LOUIS PARK | MN | 55426 | 9529208380 | 260 | Hennepin | For profit - Corporation | 112 | 83.4 | Medicare and Medicaid | false | ST. LOUIS PARK OPCO, LLC | 02/01/1978 | false | false | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 3 | 4 | 4 | 1.85479 | 0.72718 | 0.72053 | 1.44771 | 3.30251 | 0.04599 | 1.94122 | 0.68169 | 0.31951 | 2.94242 | 1.98581 | 0.80212 | 0.84878 | 3.59909 | 06/20/2019 | 4 | 0 | 4 | 32 | 1 | 0 | 32 | 08/02/2018 | 19 | 19 | 2 | 88 | 2 | 44 | 132 | 2017-06-29 | 11 | 11 | 0 | 2 | 48 | 24 | 72 | 72 | 5 | 3 | 0 | 0.00 | 0 | 0 | 7900 WEST 28TH STREET SAINT LOUIS PARK, MN 55426 (44.953026, -93.380111) | 02/01/2020 | |||||||||||
13109 | 13109 | 393 S TUSTIN ST ORANGE, CA 92866 | 33.782772 | -117.835745 | 0 | 555753 | HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE D/P SNF | 393 S TUSTIN ST | ORANGE | CA | 92866 | 7142892400 | 400 | Orange | For profit - Partnership | 21 | 17 | Medicare and Medicaid | true | HEALTHBRIDGE CHILDREN'S HOSPITAL ORANGE CA LP | 02/23/2000 | false | false | false | false | None | Yes | 4 | 2 | 5 | 5 | 2 | 4 | 4 | 3.0367 | 2.58056 | 3.44752 | 6.02808 | 9.06478 | 0 | 2.47789 | 1.1477 | 1.4977 | 5.1233 | 2.54703 | 1.69071 | 0.86639 | 5.67363 | 11/20/2019 | 17 | 11 | 6 | 48 | 1 | 0 | 48 | 12/21/2018 | 28 | 19 | 15 | 116 | 1 | 0 | 116 | 2018-02-27 | 19 | 14 | 5 | 1 | 104 | 0 | 104 | 80 | 1 | 15 | 0 | 0.00 | 0 | 0 | 393 S TUSTIN ST ORANGE, CA 92866 (33.782772, -117.835745) | 02/01/2020 | |||||||||||
14844 | 14844 | 265 NORTH 300 WEST ROOSEVELT, UT 84066 | 40.302939 | -109.997087 | 0 | 465084 | UINTAH BASIN REHABILITATION AND SENIOR VILLA | 265 NORTH 300 WEST | ROOSEVELT | UT | 84066 | 4357252051 | 60 | Duchesne | Government - County | 90 | 49.7 | Medicare and Medicaid | false | COUNTY OF DUCHESNE | 10/01/1981 | false | false | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 4 | 4 | 2.96049 | 0.78432 | 0.93034 | 1.71466 | 4.67515 | 0.10223 | 2.13208 | 0.78902 | 0.38846 | 3.30956 | 2.88586 | 0.74746 | 0.90143 | 4.5298 | 06/06/2019 | 12 | 12 | 0 | 76 | 1 | 0 | 76 | 04/05/2018 | 19 | 19 | 0 | 140 | 1 | 0 | 140 | 2016-12-08 | 9 | 9 | 0 | 1 | 44 | 0 | 44 | 92 | 0 | 0 | 2 | 37625.00 | 0 | 2 | 265 NORTH 300 WEST ROOSEVELT, UT 84066 (40.302939, -109.997087) | 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 );