nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Number of Fines = 4 and Physical Therapist Staffing Footnote = 6
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Special Focus Status, Abuse Icon, With a Resident and Family Council, 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, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Standard Health Survey Date, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Facility Reported Incidents, Number of Substantiated Complaints, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 79 | 4557 QUICK RD PENINSULA, OH 44264 | 41.195452 | -81.510865 | 0 | 366323 | WAYSIDE FARM INC | 4557 QUICK RD | PENINSULA | OH | 44264 | 3309237828 | 780 | Summit | For profit - Corporation | 95 | 92.6 | Medicare and Medicaid | false | Legal Business Name Not Available | 12/08/2005 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 05/10/2019 | 8 | 3 | 5 | 531 | 1 | 0 | 531 | 02/01/2018 | 13 | 13 | 0 | 96 | 1 | 0 | 96 | 2016-11-04 | 7 | 4 | 3 | 1 | 152 | 0 | 152 | 322.833 | 0 | 2 | 4 | 163596.00 | 0 | 4 | 4557 QUICK RD PENINSULA, OH 44264 (41.195452, -81.510865) | 02/01/2020 | ||||||||||||||||||||
5710 | 5710 | 128 CEDAR AVENUE WATERBURY, CT 06705 | 41.549392 | -72.996781 | 0 | 75210 | WATERBURY GARDENS NURSING AND REHAB | 128 CEDAR AVENUE | WATERBURY | CT | 6705 | 2037579271 | 40 | New Haven | For profit - Partnership | 150 | 108.9 | Medicare and Medicaid | false | WATERBURY GARDENS NURSING AND REHAB LLC | 11/22/1971 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 3 | 1 | 12 | 1 | 12 | 6 | 6 | 03/14/2019 | 36 | 34 | 26 | 208 | 2 | 104 | 312 | 02/21/2018 | 17 | 17 | 17 | 84 | 1 | 0 | 84 | 2017-03-03 | 10 | 10 | 4 | 1 | 56 | 0 | 56 | 193.333 | 3 | 9 | 4 | 39547.00 | 0 | 4 | 128 CEDAR AVENUE WATERBURY, CT 06705 (41.549392, -72.996781) | 02/01/2020 | ||||||||||||||||||||
6223 | 6223 | 563 KAUMANA DRIVE HILO, HI 96720 | 19.7042 | -155.111039 | 0 | 125065 | LEGACY HILO REHABILITATION & NURSING CENTER | 563 KAUMANA DRIVE | HILO | HI | 96720 | 8084980184 | 10 | Hawaii | For profit - Partnership | 100 | 72.3 | Medicare and Medicaid | false | KAUMANA DRIVE PARTNERS LLC | 01/20/2016 | false | SFF | true | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 08/09/2019 | 6 | 0 | 6 | 155 | 1 | 0 | 155 | 02/08/2019 | 22 | 10 | 12 | 144 | 1 | 0 | 144 | 2018-08-16 | 9 | 9 | 0 | 1 | 36 | 0 | 36 | 131.5 | 1 | 10 | 4 | 232031.00 | 2 | 6 | 563 KAUMANA DRIVE HILO, HI 96720 (19.7042, -155.111039) | 02/01/2020 | ||||||||||||||||||||||
7340 | 7340 | 29270 MORLOCK LIVONIA, MI 48152 | 42.439839 | -83.334193 | 0 | 235365 | SKLD LIVONIA | 29270 MORLOCK | LIVONIA | MI | 48152 | 2484760555 | 810 | Wayne | For profit - Individual | 110 | 102.9 | Medicare and Medicaid | false | LIVONIA SNF LLC | 01/01/1979 | false | false | false | false | None | Yes | 1 | 2 | 3 | 3 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 12/11/2019 | 20 | 11 | 10 | 203 | 1 | 0 | 203 | 10/04/2018 | 10 | 7 | 3 | 96 | 1 | 0 | 96 | 2017-08-10 | 8 | 6 | 4 | 1 | 84 | 0 | 84 | 147.5 | 6 | 22 | 4 | 59653.00 | 0 | 4 | 29270 MORLOCK LIVONIA, MI 48152 (42.439839, -83.334193) | 02/01/2020 | |||||||||||||||||||||
11311 | 11311 | 2818 NORTHEAST 145TH STREET SEATTLE, WA 98155 | 47.73379 | -122.297228 | 0 | 505262 | SHORELINE HEALTH AND REHABILITATION | 2818 NORTHEAST 145TH STREET | SEATTLE | WA | 98155 | 2064182900 | 160 | King | For profit - Individual | 114 | 81.9 | Medicare and Medicaid | false | NORTH LAKE 5-O LLC | 04/01/1982 | false | false | false | false | Resident | Yes | 1 | 2 | 4 | 4 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 12/05/2019 | 36 | 30 | 6 | 228 | 0 | 0 | 228 | 09/26/2018 | 16 | 14 | 3 | 100 | 1 | 0 | 100 | 2017-10-12 | 36 | 28 | 23 | 1 | 379 | 0 | 379 | 210.5 | 10 | 22 | 4 | 106865.00 | 0 | 4 | 2818 NORTHEAST 145TH STREET SEATTLE, WA 98155 (47.73379, -122.297228) | 02/01/2020 | |||||||||||||||||||||
13196 | 13196 | 230 EAST PRESNELL STREET ASHEBORO, NC 27203 | 35.71458 | -79.808406 | 0 | 345155 | ALPINE HEALTH AND REHABILITATION OF ASHEBORO | 230 EAST PRESNELL STREET | ASHEBORO | NC | 27203 | 3366291447 | 750 | Randolph | For profit - Corporation | 238 | 119.6 | Medicare and Medicaid | false | ALPINE HEALTH AND REHABILITATION OF ASHEBORO | 05/21/1976 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 04/05/2019 | 6 | 4 | 2 | 32 | 1 | 0 | 32 | 02/01/2018 | 30 | 18 | 13 | 364 | 1 | 0 | 364 | 2017-02-09 | 21 | 17 | 20 | 1 | 296 | 0 | 296 | 186.667 | 0 | 17 | 4 | 157249.00 | 2 | 6 | 230 EAST PRESNELL STREET ASHEBORO, NC 27203 (35.71458, -79.808406) | 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 );