nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-06-29
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, 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, 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 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 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 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 Revisit Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83 | 83 | Southbrook Healthcare, 832 Isabel St, Ardmore, OK 73401, USA | 34.163812 | -97.141657 | 1 | ROOFTOP | 375255 | SOUTHBROOK HEALTHCARE, INC | 832 ISABEL SOUTHWEST | ARDMORE | OK | 73401 | 5802235901 | 90 | Carter | For profit - Corporation | 114 | 63.9 | Medicare and Medicaid | false | SOUTHBROOK HEALTHCARE, INC. | 05/13/1996 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 1.69311 | 0.70155 | 0.59142 | 1.29297 | 2.98608 | 0.00489 | 1.81843 | 0.64781 | 0.28645 | 2.75269 | 1.93511 | 0.81431 | 0.7771 | 3.47854 | 10/17/2019 | 10 | 8 | 2 | 88 | 1 | 0 | 88 | 08/09/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-29 | 5 | 3 | 2 | 1 | 36 | 0 | 36 | 50 | 0 | 3 | 1 | 5691.00 | 0 | 1 | 02/01/2020 | |||||||||||
940 | 940 | 140 EAST TULARE AVENUE SHAFTER, CA 93263 | 35.507077 | -119.276705 | 0 | 56035 | GOLDEN LIVINGCENTER - SHAFTER | 140 EAST TULARE AVENUE | SHAFTER | CA | 93263 | 6617463912 | 140 | Kern | For profit - Limited Liability company | 99 | 89.1 | Medicare and Medicaid | false | GGNSC SHAFTER LP | 01/01/1971 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 4 | 3 | 2 | 1 | 2.52266 | 0.98442 | 0.1779 | 1.16232 | 3.68498 | 0.00753 | 2.04028 | 0.62143 | 0.27561 | 2.93732 | 2.56972 | 1.19116 | 0.24295 | 4.02288 | 05/16/2019 | 14 | 10 | 5 | 124 | 1 | 0 | 124 | 05/24/2018 | 22 | 13 | 9 | 104 | 1 | 0 | 104 | 2017-06-29 | 20 | 13 | 9 | 1 | 120 | 0 | 120 | 116.667 | 9 | 7 | 0 | 0.00 | 0 | 0 | 140 EAST TULARE AVENUE SHAFTER, CA 93263 (35.507077, -119.276705) | 02/01/2020 | |||||||||||
2095 | 2095 | 1501 SE 24TH RD OCALA, FL 34471 | 29.160965 | -82.118211 | 0 | 105465 | OAKHURST CENTER | 1501 SE 24TH RD | OCALA | FL | 34471 | 3526298900 | 410 | Marion | For profit - Corporation | 180 | 159.4 | Medicare and Medicaid | false | 1501 SE 24TH ROAD LLC | 05/31/1984 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 3 | 2 | 2.47355 | 1.12397 | 0.3665 | 1.49047 | 3.96401 | 0.07214 | 1.89345 | 0.6904 | 0.31986 | 2.90371 | 2.71508 | 1.22415 | 0.43126 | 4.37759 | 11/21/2019 | 20 | 5 | 15 | 420 | 0 | 0 | 420 | 08/23/2018 | 13 | 9 | 4 | 72 | 1 | 0 | 72 | 2017-06-29 | 10 | 8 | 2 | 1 | 52 | 0 | 52 | 242.667 | 0 | 26 | 1 | 233688.00 | 0 | 1 | 1501 SE 24TH RD OCALA, FL 34471 (29.160965, -82.118211) | 02/01/2020 | ||||||||||
4661 | 4661 | 350 N CENTER ST LOWELL, MI 49331 | 42.935798 | -85.350098 | 0 | 235253 | LAURELS OF KENT (THE) | 350 N CENTER ST | LOWELL | MI | 49331 | 6168978473 | 400 | Kent | For profit - Corporation | 153 | 113.3 | Medicare and Medicaid | false | LAUREL HEALTH CARE COMPANY OF LOWELL | 07/01/1978 | false | true | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 4 | 3 | 3 | 2.18955 | 0.69964 | 0.44632 | 1.14597 | 3.33552 | 0.08528 | 1.98623 | 0.68886 | 0.3254 | 3.00049 | 2.29108 | 0.76372 | 0.51625 | 3.56471 | 10/23/2019 | 16 | 9 | 10 | 88 | 1 | 0 | 88 | 08/16/2018 | 10 | 3 | 7 | 131 | 1 | 0 | 131 | 2017-06-29 | 24 | 13 | 11 | 1 | 156 | 0 | 156 | 113.667 | 18 | 21 | 2 | 133076.00 | 1 | 3 | 350 N CENTER ST LOWELL, MI 49331 (42.935798, -85.350098) | 02/01/2020 | |||||||||||
7125 | 7125 | 5401 SAWYER RD SARASOTA, FL 34233 | 27.274694 | -82.489331 | 0 | 105842 | HEARTLAND HEALTH CARE & REHABILITATION CENTER | 5401 SAWYER RD | SARASOTA | FL | 34233 | 9419253427 | 570 | Sarasota | For profit - Corporation | 140 | 85.8 | Medicare and Medicaid | false | HEARTLAND OF SARASOTA FL LLC | 11/23/1993 | false | true | false | false | Both | Yes | 2 | 1 | 5 | 5 | 5 | 4 | 4 | 2.41179 | 0.71255 | 0.97088 | 1.68343 | 4.09522 | 0.20975 | 2.18559 | 0.86628 | 0.46241 | 3.51428 | 2.29344 | 0.61851 | 0.79026 | 3.73675 | 08/15/2019 | 10 | 7 | 3 | 88 | 1 | 0 | 88 | 07/26/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-06-29 | 5 | 5 | 0 | 1 | 16 | 0 | 16 | 52 | 1 | 0 | 1 | 68744.00 | 0 | 1 | 5401 SAWYER RD SARASOTA, FL 34233 (27.274694, -82.489331) | 02/01/2020 | |||||||||||
8437 | 8437 | 2700 CANAL BLVD HAYS, KS 67601 | 38.885996 | -99.333942 | 0 | 175322 | GOOD SAMARITAN SOCIETY - HAYS | 2700 CANAL BLVD | HAYS | KS | 67601 | 7856257331 | 250 | Ellis | Non profit - Corporation | 70 | 60 | Medicare and Medicaid | false | THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY | 12/01/1994 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 3 | 3 | 3 | 2.44171 | 0.52595 | 0.533 | 1.05895 | 3.50066 | 0.00988 | 2.08096 | 0.6971 | 0.32963 | 3.1077 | 2.43863 | 0.56732 | 0.6086 | 3.61214 | 08/28/2019 | 10 | 8 | 2 | 131 | 1 | 0 | 131 | 11/14/2018 | 11 | 7 | 10 | 104 | 1 | 0 | 104 | 2017-06-29 | 17 | 13 | 4 | 1 | 136 | 0 | 136 | 122.833 | 4 | 8 | 3 | 58514.00 | 1 | 4 | 2700 CANAL BLVD HAYS, KS 67601 (38.885996, -99.333942) | 02/01/2020 | |||||||||||
8631 | 8631 | 9625 MARKET STREET NORTH LIMA, OH 44452 | 40.978522 | -80.661856 | 0 | 365708 | IVY WOODS HEALTHCARE AND REHABILITATION CENTER | 9625 MARKET STREET | NORTH LIMA | OH | 44452 | 3305493939 | 510 | Mahoning | For profit - Corporation | 91 | 84.5 | Medicare and Medicaid | false | ROLLING ACRES CARE CENTER LLC | 01/28/1988 | false | SFF Candidate | true | false | false | Both | Yes | 1 | 1 | 3 | 3 | 2 | 1 | 1 | 1.95097 | 0.87384 | 0.34814 | 1.22198 | 3.17296 | 0.03428 | 1.86566 | 0.79656 | 0.41908 | 3.08131 | 2.17337 | 0.82489 | 0.31267 | 3.30204 | 10/24/2019 | 11 | 8 | 3 | 513 | 1 | 0 | 513 | 08/29/2018 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 2017-06-29 | 4 | 2 | 2 | 1 | 32 | 0 | 32 | 267.167 | 0 | 3 | 1 | 2717.00 | 0 | 1 | 9625 MARKET STREET NORTH LIMA, OH 44452 (40.978522, -80.661856) | 02/01/2020 | ||||||||||
10826 | 10826 | 741 N MAIN STREET CEDARVILLE, CA 96104 | 41.531931 | -120.171899 | 0 | 555221 | SURPRISE VALLEY COMMUNITY HOSPITAL D/P SNF | 741 N. MAIN STREET | CEDARVILLE | CA | 96104 | 5302796111 | 350 | Modoc | Government - Hospital district | 22 | 16.9 | Medicare and Medicaid | false | Legal Business Name Not Available | 04/15/1986 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 07/17/2019 | 25 | 13 | 12 | 132 | 1 | 0 | 132 | 07/26/2018 | 16 | 11 | 5 | 108 | 1 | 0 | 108 | 2017-06-29 | 22 | 19 | 3 | 2 | 164 | 82 | 246 | 143 | 17 | 6 | 1 | 9984.00 | 1 | 2 | 741 N MAIN STREET CEDARVILLE, CA 96104 (41.531931, -120.171899) | 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 );