nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
5 rows where Most Recent Health Inspection More Than 2 Years Ago = "true" and Rating Cycle 2 Number of Standard Health Deficiencies = 3
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, Overall Rating, 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, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1860 | 1860 | 5 REDLANDS ROAD W ROXBURY, MA 02132 | 42.287639 | -71.151199 | 0 | 225429 | STONEHEDGE HEALTH CARE CENTER | 5 REDLANDS ROAD | W ROXBURY | MA | 2132 | 6173276325 | 160 | Suffolk | For profit - Corporation | 79 | 76.5 | Medicare and Medicaid | false | STONEHEDGE MA SNF LLC | 07/01/1990 | false | false | true | false | Resident | Yes | 1 | 2 | 1 | 1 | 2 | 2 | 2 | 1.98346 | 0.81464 | 0.31582 | 1.13047 | 3.11393 | 0.14636 | 2.00643 | 0.67071 | 0.29834 | 2.97548 | 2.05455 | 0.9133 | 0.39844 | 3.35586 | 10/17/2017 | 20 | 19 | 5 | 116 | 1 | 0 | 116 | 12/07/2016 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2015-12-23 | 5 | 3 | 2 | 1 | 24 | 0 | 24 | 66 | 0 | 3 | 1 | 71689.00 | 0 | 1 | 5 REDLANDS ROAD W ROXBURY, MA 02132 (42.287639, -71.151199) | 02/01/2020 | |||||||||||
1956 | 1956 | 260 EASTHAMPTON ROAD HOLYOKE, MA 01040 | 42.225911 | -72.646613 | 0 | 225236 | CARE ONE AT HOLYOKE | 260 EASTHAMPTON ROAD | HOLYOKE | MA | 1040 | 4135389733 | 70 | Hampden | For profit - Corporation | 164 | 156.9 | Medicare and Medicaid | false | 260 EASTHAMPTON ROAD OPERATING COMPANY LLC | 06/26/1975 | false | false | true | false | Resident | Yes | 5 | 5 | 2 | 4 | 1 | 3 | 3 | 1.89308 | 0.90123 | 0.49013 | 1.39136 | 3.28444 | 0.03148 | 1.57937 | 0.59365 | 0.26958 | 2.4426 | 2.49117 | 1.14154 | 0.6843 | 4.31184 | 01/18/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 11/18/2016 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2015-09-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0.00 | 0 | 0 | 260 EASTHAMPTON ROAD HOLYOKE, MA 01040 (42.225911, -72.646613) | 02/01/2020 | |||||||||||
5980 | 5980 | 390 ORLEANS ROAD NORTH CHATHAM, MA 02650 | 41.70068 | -69.965861 | 0 | 225330 | LIBERTY COMMONS | 390 ORLEANS ROAD | NORTH CHATHAM | MA | 2650 | 5089454611 | 0 | Barnstable | For profit - Corporation | 132 | 125.4 | Medicare and Medicaid | false | BROAD REACH OF CHATHAM INC | 02/02/1989 | false | false | true | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 2.23568 | 0.60631 | 1.06715 | 1.67347 | 3.90914 | 0.14749 | 2.05587 | 0.73896 | 0.35651 | 3.15134 | 2.26011 | 0.61696 | 1.12665 | 3.97777 | 11/08/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 09/01/2016 | 6 | 3 | 3 | 56 | 1 | 0 | 56 | 2015-06-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18.667 | 0 | 1 | 1 | 7963.00 | 0 | 1 | 390 ORLEANS ROAD NORTH CHATHAM, MA 02650 (41.70068, -69.965861) | 02/01/2020 | |||||||||||
7875 | 7875 | 40 MARTIN STREET MELROSE, MA 02176 | 42.456878 | -71.074708 | 0 | 225329 | MELROSE HEALTHCARE | 40 MARTIN STREET | MELROSE | MA | 2176 | 7816657050 | 90 | Middlesex | For profit - Corporation | 106 | 88 | Medicare and Medicaid | false | 40 MARTIN STREET OPERATOR LLC | 02/13/1989 | false | false | true | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 3 | 3 | 1.50066 | 0.77704 | 0.50587 | 1.2829 | 2.78357 | 0.01716 | 1.90021 | 0.62371 | 0.26569 | 2.78961 | 1.64134 | 0.93679 | 0.71662 | 3.19972 | 11/08/2017 | 3 | 2 | 1 | 16 | 1 | 0 | 16 | 10/25/2016 | 6 | 3 | 3 | 72 | 3 | 50 | 122 | 2015-11-12 | 14 | 7 | 7 | 2 | 176 | 88 | 264 | 92.667 | 3 | 4 | 3 | 90919.00 | 0 | 3 | 40 MARTIN STREET MELROSE, MA 02176 (42.456878, -71.074708) | 02/01/2020 | |||||||||||
8496 | 8496 | 925 WEST MANGUM AVENUE MENDENHALL, MS 39114 | 31.968387 | -89.885456 | 0 | 255150 | BEDFORD CARE CENTER OF MENDENH | 925 WEST MANGUM AVENUE | MENDENHALL | MS | 39114 | 6018471311 | 630 | Simpson | For profit - Corporation | 60 | Medicare and Medicaid | false | BEDFORD CARE CENTER OF MENDENHALL LLC | 11/01/1992 | false | false | true | false | Resident | Yes | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 6 | 6 | 10/12/2017 | 5 | 5 | 0 | 36 | 1 | 0 | 36 | 01/06/2017 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 2015-12-04 | 1 | 1 | 0 | 1 | 16 | 0 | 16 | 26 | 2 | 0 | 0 | 0.00 | 0 | 0 | 925 WEST MANGUM AVENUE MENDENHALL, MS 39114 (31.968387, -89.885456) | 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 );