nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Rating Cycle 1 Health Revisit Score = 44
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, nmbr_beds, Provider Resides in Hospital, Special Focus Status, Abuse Icon, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, 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 Total Health Score, 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 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3363 | 3363 | 911 S 3RD ST NILES, MI 49120 | 41.819191 | -86.251737 | 0 | 235361 | CHALET OF NILES, LLC | 911 S 3RD ST | NILES | MI | 49120 | 2696844320 | 100 | Berrien | For profit - Individual | 100 | 54.6 | Medicare and Medicaid | false | CHALET OF NILES LLC | 07/01/1978 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 3 | 2 | 2 | 1.49935 | 0.84183 | 0.33979 | 1.18161 | 2.68097 | 0.02973 | 2.03126 | 0.70772 | 0.32533 | 3.06431 | 1.5341 | 0.89443 | 0.39311 | 2.80551 | 02/21/2019 | 17 | 10 | 7 | 88 | 2 | 44 | 132 | 09/13/2018 | 15 | 9 | 6 | 80 | 1 | 0 | 80 | 2018-03-30 | 28 | 19 | 15 | 1 | 342 | 0 | 342 | 149.667 | 17 | 35 | 2 | 406151.00 | 4 | 6 | 911 S 3RD ST NILES, MI 49120 (41.819191, -86.251737) | 02/01/2020 | |||||||||||
3889 | 3889 | 1111 DRURY LN ENGLEWOOD, FL 34224 | 26.94116 | -82.325012 | 0 | 105452 | ENGLEWOOD HEALTHCARE AND REHAB | 1111 DRURY LN | ENGLEWOOD | FL | 34224 | 9414749371 | 570 | Sarasota | For profit - Limited Liability company | 120 | 104.7 | Medicare and Medicaid | false | 1111 DRURY LANE OPERATIONS LLC | 09/02/1983 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 4 | 3 | 3 | 2.63324 | 0.89741 | 0.5741 | 1.47151 | 4.10476 | 0.03806 | 2.00708 | 0.72483 | 0.33256 | 3.06448 | 2.72672 | 0.93098 | 0.64974 | 4.2952 | 08/08/2019 | 16 | 11 | 7 | 88 | 2 | 44 | 132 | 06/28/2018 | 3 | 1 | 2 | 24 | 2 | 12 | 36 | 2017-05-25 | 6 | 6 | 0 | 1 | 56 | 0 | 56 | 87.333 | 1 | 4 | 3 | 81310.00 | 0 | 3 | 1111 DRURY LN ENGLEWOOD, FL 34224 (26.94116, -82.325012) | 02/01/2020 | |||||||||||
4005 | 4005 | 29449 CHARLOTTE HALL ROAD CHARLOTTE HALL, MD 20622 | 38.477531 | -76.777703 | 0 | 215161 | CHARLOTTE HALL VETERANS HOME | 29449 CHARLOTTE HALL ROAD | CHARLOTTE HALL | MD | 20622 | 3018848171 | 180 | St. Marys | For profit - Corporation | 286 | 275.2 | Medicare and Medicaid | false | HMR OF MARYLAND LLC | 03/17/1986 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 2.81736 | 0.81884 | 0.53302 | 1.35186 | 4.16921 | 0.04068 | 2.10868 | 0.67596 | 0.30882 | 3.09346 | 2.77682 | 0.91089 | 0.64963 | 4.32178 | 12/04/2018 | 10 | 9 | 3 | 87 | 2 | 44 | 131 | 08/10/2017 | 8 | 4 | 4 | 52 | 1 | 0 | 52 | 2016-05-26 | 8 | 4 | 4 | 1 | 32 | 0 | 32 | 88.167 | 15 | 9 | 1 | 13790.00 | 0 | 1 | 29449 CHARLOTTE HALL ROAD CHARLOTTE HALL, MD 20622 (38.477531, -76.777703) | 02/01/2020 | |||||||||||
5726 | 5726 | 494 ELM ST STAMFORD, CT 06902 | 41.049972 | -73.526723 | 0 | 75320 | ST CAMILLUS REHABILITATION & NURSING CENTER | 494 ELM ST | STAMFORD | CT | 6902 | 2033250200 | 0 | Fairfield | For profit - Corporation | 124 | 108.9 | Medicare and Medicaid | false | HBR STAMFORD LLC | 10/05/1988 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 4 | 4 | 4 | 4 | 4 | 1.84172 | 0.79898 | 0.57399 | 1.37296 | 3.21468 | 0.04363 | 1.85667 | 0.64608 | 0.28652 | 2.78927 | 2.0616 | 0.92989 | 0.754 | 3.69573 | 07/11/2019 | 16 | 11 | 5 | 88 | 2 | 44 | 132 | 05/07/2018 | 25 | 10 | 22 | 219 | 1 | 0 | 219 | 2017-05-24 | 9 | 9 | 1 | 1 | 64 | 0 | 64 | 149.667 | 5 | 8 | 3 | 44860.00 | 0 | 3 | 494 ELM ST STAMFORD, CT 06902 (41.049972, -73.526723) | 02/01/2020 | ||||||||||
7937 | 7937 | 466 FLAGSHIP ROAD NEWPORT BEACH, CA 92663 | 33.628337 | -117.928651 | 0 | 55121 | FLAGSHIP HEALTHCARE CENTER | 466 FLAGSHIP ROAD | NEWPORT BEACH | CA | 92663 | 9496428044 | 400 | Orange | For profit - Corporation | 167 | 127.3 | Medicare and Medicaid | false | SSC NEWPORT BEACH OPERATING COMPANY LP | 05/01/1978 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 5 | 3 | 2 | 2.85887 | 1.28159 | 0.37474 | 1.65633 | 4.5152 | 0.14854 | 2.21184 | 0.74666 | 0.34332 | 3.30183 | 2.68631 | 1.29065 | 0.41083 | 4.38506 | 04/15/2019 | 18 | 16 | 5 | 88 | 2 | 44 | 132 | 05/03/2018 | 9 | 7 | 2 | 24 | 1 | 0 | 24 | 2017-11-02 | 24 | 16 | 8 | 1 | 104 | 0 | 104 | 91.333 | 8 | 4 | 0 | 0.00 | 0 | 0 | 466 FLAGSHIP ROAD NEWPORT BEACH, CA 92663 (33.628337, -117.928651) | 02/01/2020 | |||||||||||
7952 | 7952 | 1224 EIGHTH STREET RUPERT, ID 83350 | 42.619625 | -113.685362 | 0 | 135064 | COUNTRYSIDE CARE & REHABILITATION | 1224 EIGHTH STREET | RUPERT | ID | 83350 | 2084360481 | 330 | Minidoka | Government - County | 46 | 37.5 | Medicare and Medicaid | true | MINIDOKA MEMORIAL HOSPITAL | 12/01/1976 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 3.61452 | 1.18376 | 0.6237 | 1.80746 | 5.42198 | 0.02602 | 2.17672 | 0.63345 | 0.28319 | 3.09336 | 3.45116 | 1.40518 | 0.82895 | 5.62057 | 09/28/2018 | 13 | 13 | 0 | 88 | 2 | 44 | 132 | 05/04/2017 | 8 | 8 | 0 | 56 | 1 | 0 | 56 | 2016-02-19 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 86.667 | 0 | 0 | 1 | 8957.00 | 0 | 1 | 1224 EIGHTH STREET RUPERT, ID 83350 (42.619625, -113.685362) | 02/01/2020 | |||||||||||
12427 | 12427 | 432 MAPLE AVENUE DOYLESTOWN, PA 18901 | 40.315749 | -75.121335 | 0 | 395277 | HARBORVIEW REHABILITATION CARE CENTER AT DOYLESTOW | 432 MAPLE AVENUE | DOYLESTOWN | PA | 18901 | 2153451452 | 140 | Bucks | For profit - Corporation | 120 | 81.6 | Medicare and Medicaid | false | HARBORVIEW REHABILITATION AND CARE CENTER AT DOYLESTOWN LLC | 03/23/1970 | false | false | false | false | Resident | Yes | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 1.81257 | 1.00899 | 0.61723 | 1.62621 | 3.43879 | 0.04507 | 2.12167 | 0.87882 | 0.48579 | 3.48628 | 1.77556 | 0.86331 | 0.47822 | 3.16298 | 07/24/2019 | 15 | 13 | 2 | 88 | 2 | 44 | 132 | 08/17/2018 | 9 | 8 | 1 | 44 | 1 | 0 | 44 | 2017-07-14 | 5 | 4 | 1 | 1 | 28 | 0 | 28 | 85.333 | 0 | 7 | 0 | 0.00 | 0 | 0 | 432 MAPLE AVENUE DOYLESTOWN, PA 18901 (40.315749, -75.121335) | 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 );