nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Overall Rating = 3 and Rating Cycle 2 Number of Standard Health Deficiencies = 24
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty_name, ownership, Provider Resides in Hospital, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, 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 Number of Health Revisits, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
424 | 424 | 716 SOUTH FAIR OAKS AVE PASADENA, CA 91105 | 34.133578 | -118.150352 | 0 | 55341 | GEM TRANSITIONAL | 716 SOUTH FAIR OAKS AVE | PASADENA | CA | 91105 | 6267370560 | 200 | Los Angeles | For profit - Corporation | 75 | 63.6 | Medicare and Medicaid | false | GEM HEALTHCARE, LLC | 04/01/1972 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 5 | 4 | 4 | 4 | 2.53517 | 1.20816 | 0.7384 | 1.94656 | 4.48173 | 0.11765 | 2.08354 | 0.72526 | 0.3551 | 3.1639 | 2.52883 | 1.25261 | 0.78267 | 4.54231 | 11/21/2019 | 10 | 9 | 1 | 40 | 1 | 0 | 40 | 11/30/2018 | 30 | 24 | 6 | 132 | 1 | 0 | 132 | 2017-12-12 | 21 | 19 | 2 | 1 | 108 | 0 | 108 | 82 | 0 | 9 | 0 | 0.00 | 0 | 0 | 716 SOUTH FAIR OAKS AVE PASADENA, CA 91105 (34.133578, -118.150352) | 02/01/2020 | |||||||||||
2743 | 2743 | Wrangell, AK, USA | 56.4708333 | -132.3766666 | 1 | APPROXIMATE | 25015 | WRANGELL MEDICAL CENTER LTC | P.O. BOX 1081 | WRANGELL | AK | 99929 | 9078747000 | 280 | Wrangell | Non profit - Corporation | 15 | 12.8 | Medicare and Medicaid | true | SOUTHEAST ALASKA REGIONAL HEALTH CONSORTIUM | 07/01/1976 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 3 | 2 | 5 | 5 | 6.07733 | 0 | 3.31231 | 3.31231 | 9.38964 | 0.00318 | 2.08378 | 0.65668 | 0.30052 | 3.04099 | 6.06145 | 0 | 4.14843 | 9.90118 | 04/24/2019 | 14 | 14 | 0 | 120 | 1 | 0 | 120 | 04/30/2018 | 24 | 24 | 0 | 152 | 1 | 0 | 152 | 2017-06-09 | 2 | 2 | 0 | 1 | 4 | 0 | 4 | 111.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
4988 | 4988 | 5538 W DUNCAN DR LAS VEGAS, NV 89130 | 36.228951 | -115.217752 | 0 | 295008 | EL JEN CONVALESCENT HOSPITAL AND RETIREMENT CENTER | 5538 W DUNCAN DR | LAS VEGAS | NV | 89130 | 7026452606 | 10 | Clark | For profit - Individual | 144 | 131.7 | Medicare and Medicaid | false | ELJEN MEDICAL HOSPITAL | 10/01/1969 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 3 | 2 | 4 | 4 | 2.27053 | 0.75821 | 0.64494 | 1.40315 | 3.67368 | 0.03931 | 1.90069 | 0.68309 | 0.31902 | 2.90281 | 2.48275 | 0.83463 | 0.7609 | 4.05823 | 11/01/2019 | 9 | 9 | 0 | 48 | 1 | 0 | 48 | 11/16/2018 | 29 | 24 | 5 | 116 | 1 | 0 | 116 | 2017-10-13 | 7 | 7 | 0 | 1 | 44 | 0 | 44 | 70 | 0 | 3 | 0 | 0.00 | 0 | 0 | 5538 W DUNCAN DR LAS VEGAS, NV 89130 (36.228951, -115.217752) | 02/01/2020 | |||||||||||
9568 | 9568 | 510 NORTH PARKWAY BATTLE GROUND, WA 98604 | 45.784786 | -122.537292 | 0 | 505331 | BROOKFIELD HEALTH AND REHAB OF CASCADIA | 510 NORTH PARKWAY | BATTLE GROUND | WA | 98604 | 3606875141 | 50 | Clark | For profit - Limited Liability company | 83 | 48.2 | Medicare and Medicaid | false | BATTLEGROUND OF CASCADIA LLC | 03/09/1989 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 1 | 5 | 5 | 5 | 2.46941 | 0.41971 | 1.18124 | 1.60095 | 4.07036 | 0.01106 | 2.06535 | 0.73709 | 0.38534 | 3.18778 | 2.48494 | 0.42817 | 1.15379 | 4.09447 | 02/28/2019 | 11 | 10 | 1 | 64 | 1 | 0 | 64 | 03/01/2018 | 28 | 24 | 4 | 232 | 1 | 0 | 232 | 2017-04-24 | 20 | 11 | 9 | 1 | 212 | 0 | 212 | 144.667 | 3 | 11 | 2 | 69076.00 | 0 | 2 | 510 NORTH PARKWAY BATTLE GROUND, WA 98604 (45.784786, -122.537292) | 02/01/2020 | |||||||||||
10036 | 10036 | 805 19TH AVENUE SE ALBANY, OR 97321 | 44.623197 | -123.092175 | 0 | 385220 | REGENCY ALBANY | 805 19TH AVENUE SE | ALBANY | OR | 97321 | 5419264741 | 210 | Linn | For profit - Corporation | 74 | 45.3 | Medicare and Medicaid | false | Legal Business Name Not Available | 06/13/1990 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 5 | 1 | 4 | 3 | 3.03882 | 1.17176 | 0.52283 | 1.69458 | 4.7334 | 0.12755 | 2.05958 | 0.75533 | 0.34338 | 3.15829 | 3.06649 | 1.1665 | 0.57308 | 4.80589 | 12/13/2019 | 11 | 6 | 8 | 48 | 0 | 0 | 48 | 05/01/2018 | 25 | 24 | 6 | 176 | 1 | 0 | 176 | 2017-03-10 | 15 | 8 | 8 | 1 | 100 | 0 | 100 | 99.333 | 2 | 11 | 2 | 71243.00 | 0 | 2 | 805 19TH AVENUE SE ALBANY, OR 97321 (44.623197, -123.092175) | 02/01/2020 | |||||||||||
15274 | 15274 | 2726 ALDERWOOD AVENUE BELLINGHAM, WA 98225 | 48.779864 | -122.502503 | 0 | 505092 | ALDERWOOD PARK HEALTH AND REHABILITATION | 2726 ALDERWOOD AVENUE | BELLINGHAM | WA | 98225 | 3607332322 | 360 | Whatcom | For profit - Limited Liability company | 102 | 71.1 | Medicare and Medicaid | false | EMPRES AT ALDERWOOD, LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 5 | 4 | 4 | 2.27342 | 0.42535 | 1.00581 | 1.43116 | 3.70458 | 0.08089 | 2.03133 | 0.77876 | 0.38027 | 3.19037 | 2.32603 | 0.4107 | 0.99552 | 3.7235 | 08/23/2019 | 31 | 27 | 7 | 156 | 1 | 0 | 156 | 06/14/2018 | 25 | 24 | 3 | 148 | 1 | 0 | 148 | 2017-03-30 | 35 | 16 | 19 | 1 | 464 | 0 | 464 | 204.667 | 8 | 7 | 3 | 102256.00 | 0 | 3 | 2726 ALDERWOOD AVENUE BELLINGHAM, WA 98225 (48.779864, -122.502503) | 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 );