nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2016-10-27
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, ownership, Special Focus Status, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Reported Physical Therapist 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 Health Revisits, Rating Cycle 1 Health Revisit 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 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Number of Facility Reported Incidents, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1248 | 1248 | 1904 PALMYRA ROAD ALBANY, GA 31702 | 31.603176 | -84.169078 | 0 | 115628 | PRUITTHEALTH - PALMYRA | 1904 PALMYRA ROAD | ALBANY | GA | 31702 | 2298830500 | 390 | Dougherty | For profit - Corporation | 250 | 214.4 | Medicare and Medicaid | false | PRUITTHEALTH - PALMYRA, LLC | 01/01/1997 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 4 | 3 | 3 | 3 | 2.16304 | 0.95911 | 0.50326 | 1.46237 | 3.62541 | 0.03991 | 2.06315 | 0.72075 | 0.3109 | 3.09481 | 2.17897 | 1.00061 | 0.60926 | 3.75645 | 12/06/2018 | 8 | 2 | 6 | 408 | 1 | 0 | 408 | 11/16/2017 | 1 | 0 | 1 | 8 | 0 | 0 | 8 | 2016-10-27 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 208 | 0 | 4 | 1 | 186564.00 | 0 | 1 | 1904 PALMYRA ROAD ALBANY, GA 31702 (31.603176, -84.169078) | 02/01/2020 | ||||||||||
1250 | 1250 | 161 WEST RODEO ROAD CASA GRANDE, AZ 85122 | 32.92343 | -111.753174 | 0 | 35276 | OASIS PAVILION NURSING & REHABILITATION CENTER | 161 WEST RODEO ROAD | CASA GRANDE | AZ | 85122 | 5208361772 | 100 | Pinal | For profit - Limited Liability company | 134 | 135.3 | Medicare and Medicaid | false | OASIS PAVILION NURSING AND REHABILITATION CENTER, LLC | 10/04/2010 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 3 | 5 | 2 | 2 | 1.68262 | 0.87719 | 0.32915 | 1.20634 | 2.88896 | 0.13692 | 1.89532 | 0.72463 | 0.3624 | 2.98236 | 1.8451 | 0.91025 | 0.34185 | 3.10625 | 02/12/2019 | 11 | 9 | 3 | 72 | 1 | 0 | 72 | 11/02/2017 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 2016-10-27 | 12 | 12 | 0 | 1 | 84 | 0 | 84 | 60.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 161 WEST RODEO ROAD CASA GRANDE, AZ 85122 (32.92343, -111.753174) | 02/01/2020 | |||||||||||
5209 | 5209 | 13550 S Outer Forty Rd, Chesterfield, MO 63017, USA | 38.6392324 | -90.50228109999999 | 1 | ROOFTOP | 265105 | DELMAR GARDENS WEST | 13550 SOUTH OUTER 40 ROAD | TOWN AND COUNTRY | MO | 63017 | 3148781330 | 940 | St. Louis | For profit - Corporation | 321 | 241.2 | Medicare and Medicaid | false | DELMAR GARDENS WEST OPERATING, LLC | 02/01/1972 | false | true | false | false | Resident | Yes | 2 | 2 | 4 | 2 | 5 | 2 | 2 | 2.27808 | 0.5966 | 0.32004 | 0.91664 | 3.19472 | 0.04962 | 1.85344 | 0.64793 | 0.28823 | 2.7896 | 2.5545 | 0.69237 | 0.41792 | 3.67235 | 12/05/2018 | 8 | 7 | 1 | 68 | 1 | 0 | 68 | 01/19/2018 | 8 | 7 | 4 | 88 | 1 | 0 | 88 | 2016-10-27 | 7 | 6 | 1 | 1 | 48 | 0 | 48 | 71.333 | 2 | 11 | 3 | 46449.00 | 0 | 3 | 02/01/2020 | |||||||||||
5789 | 5789 | 435 STONEVILLE RD ISHPEMING, MI 49849 | 46.479186 | -87.718492 | 0 | 235349 | THE LIGHTHOUSE AT ISHPEMING HEALTH AND REHAB | 435 STONEVILLE RD | ISHPEMING | MI | 49849 | 9064851073 | 510 | Marquette | For profit - Limited Liability company | 122 | 61.1 | Medicare and Medicaid | false | MATHER HEALTHCARE LLC | 02/16/1978 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 2 | 3 | 3 | 1.92965 | 1.07199 | 0.57642 | 1.64842 | 3.57807 | 0.02504 | 2.02736 | 0.6911 | 0.32551 | 3.04397 | 1.97817 | 1.16637 | 0.66651 | 3.7693 | 02/07/2019 | 25 | 13 | 13 | 333 | 2 | 167 | 500 | 11/03/2017 | 47 | 16 | 36 | 368 | 2 | 184 | 552 | 2016-10-27 | 37 | 14 | 23 | 1 | 303 | 0 | 303 | 484.5 | 18 | 71 | 2 | 21640.00 | 0 | 2 | 435 STONEVILLE RD ISHPEMING, MI 49849 (46.479186, -87.718492) | 02/01/2020 | ||||||||||
8131 | 8131 | 615 WEST WEBB STREET CARMI, IL 62821 | 38.08342 | -88.165741 | 0 | 146124 | CARMI MANOR REHAB & NRSG CTR | 615 WEST WEBB STREET, PO BOX 133 | CARMI | IL | 62821 | 6183827270 | 987 | White | For profit - Partnership | 74 | 55.9 | Medicare and Medicaid | false | CARMI MANOR REHABILITATION AND NURSING CENTER LLC | 07/14/2008 | false | true | false | false | None | Yes | 2 | 1 | 5 | 5 | 3 | 4 | 4 | 3.12903 | 1.06521 | 1.26527 | 2.33048 | 5.45951 | 0.05596 | 2.11137 | 0.88442 | 0.50733 | 3.50312 | 3.08007 | 0.90565 | 0.93869 | 4.99748 | 01/10/2019 | 23 | 13 | 10 | 277 | 1 | 0 | 277 | 12/20/2017 | 5 | 5 | 0 | 36 | 1 | 0 | 36 | 2016-10-27 | 5 | 4 | 1 | 1 | 28 | 0 | 28 | 155.167 | 0 | 6 | 0 | 0.00 | 0 | 0 | 615 WEST WEBB STREET CARMI, IL 62821 (38.08342, -88.165741) | 02/01/2020 | |||||||||||
14331 | 14331 | 3600 BUTZ RD MAUMEE, OH 43537 | 41.575424 | -83.717969 | 0 | 366041 | ADDISON HEIGHTS HEALTH AND REHABILITATION CENTER | 3600 BUTZ RD | MAUMEE | OH | 43537 | 4198677926 | 490 | Lucas | For profit - Partnership | 90 | 64.5 | Medicare and Medicaid | false | ADDISON HEIGHTS HEALTH AND REHABILITATION CENTER LLC | 01/02/1996 | false | true | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 1.59942 | 0.74917 | 0.44721 | 1.19638 | 2.7958 | 0.04962 | 1.98471 | 0.77178 | 0.39521 | 3.1517 | 1.67487 | 0.72991 | 0.4259 | 2.84456 | 02/07/2019 | 28 | 20 | 8 | 136 | 1 | 0 | 136 | 01/18/2018 | 26 | 18 | 12 | 136 | 1 | 0 | 136 | 2016-10-27 | 11 | 0 | 11 | 0 | 100 | 0 | 100 | 130 | 0 | 18 | 1 | 10000.00 | 0 | 1 | 3600 BUTZ RD MAUMEE, OH 43537 (41.575424, -83.717969) | 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 );