nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Number of Facility Reported Incidents = 21
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Provider Resides in Hospital, Special Focus Status, Abuse Icon, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Number of Complaint 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 Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Fines, Total Amount of Fines in Dollars, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1361 | 1361 | 300 NORTH PATTERSON RD REED CITY, MI 49677 | 43.87848 | -85.522916 | 0 | 235205 | SPECTRUM HEALTH - REED CITY CA | 300 NORTH PATTERSON RD | REED CITY | MI | 49677 | 2318327120 | 660 | Osceola | Non profit - Corporation | 50 | 47.3 | Medicare and Medicaid | true | REED CITY HOSPITAL CORPORATION | 04/01/1971 | false | false | false | false | Resident | Yes | 4 | 2 | 5 | 2 | 5 | 5 | 5 | 2.91872 | 0.5138 | 0.97124 | 1.48505 | 4.40377 | 0 | 2.10005 | 0.70147 | 0.29978 | 3.1013 | 2.88854 | 0.55077 | 1.21944 | 4.55337 | 02/02/2019 | 20 | 11 | 10 | 120 | 1 | 0 | 120 | 02/13/2018 | 11 | 7 | 4 | 76 | 1 | 0 | 76 | 2017-01-19 | 13 | 8 | 5 | 1 | 96 | 0 | 96 | 101.333 | 21 | 0 | 0 | 0.00 | 0 | 0 | 300 NORTH PATTERSON RD REED CITY, MI 49677 (43.87848, -85.522916) | 02/01/2020 | |||||||||||
5524 | 5524 | 90 N MICHIGAN AVE COLDWATER, MI 49036 | 41.940512 | -84.980906 | 0 | 235302 | LAURELS OF COLDWATER,THE | 90 N MICHIGAN AVE | COLDWATER | MI | 49036 | 5172799808 | 110 | Branch | For profit - Corporation | 169 | 112.7 | Medicare and Medicaid | false | OAK HEALTH CARE INVESTORS OF COLDWATER, INC | 07/01/1976 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 4 | 4 | 2.35626 | 0.7578 | 0.73 | 1.4878 | 3.84406 | 0.08029 | 2.06814 | 0.69747 | 0.33673 | 3.10234 | 2.36788 | 0.81699 | 0.81596 | 3.97332 | 05/28/2019 | 28 | 22 | 16 | 172 | 2 | 86 | 258 | 06/12/2018 | 25 | 18 | 7 | 271 | 2 | 136 | 407 | 2017-02-23 | 36 | 32 | 12 | 2 | 430 | 215 | 645 | 372.167 | 21 | 20 | 3 | 168151.00 | 3 | 6 | 90 N MICHIGAN AVE COLDWATER, MI 49036 (41.940512, -84.980906) | 02/01/2020 | ||||||||||
9813 | 9813 | 5129 HILLTOP ROAD EVERETT, WA 98203 | 47.949961 | -122.228231 | 0 | 505362 | VIEW RIDGE CARE CENTER | 5129 HILLTOP ROAD | EVERETT | WA | 98203 | 4252584474 | 300 | Snohomish | For profit - Corporation | 70 | 68.4 | Medicare and Medicaid | false | VIEW RIDGE CARE CENTER LLC | 12/01/1989 | false | true | false | false | Resident | Yes | 2 | 1 | 5 | 4 | 5 | 2 | 1 | 2.5292 | 1.12236 | 0.28448 | 1.40684 | 3.93604 | 0.03882 | 2.23329 | 0.80459 | 0.38629 | 3.42417 | 2.35371 | 1.04891 | 0.27719 | 3.68601 | 12/14/2018 | 40 | 21 | 19 | 220 | 1 | 0 | 220 | 02/08/2018 | 26 | 23 | 3 | 243 | 1 | 0 | 243 | 2016-12-30 | 46 | 33 | 13 | 1 | 514 | 0 | 514 | 276.667 | 21 | 15 | 4 | 114464.00 | 0 | 4 | 5129 HILLTOP ROAD EVERETT, WA 98203 (47.949961, -122.228231) | 02/01/2020 | |||||||||||
11864 | 11864 | 1301 ORTING-KAPOWSIN HWY E ORTING, WA 98360 | 47.082367 | -122.214314 | 0 | 505516 | WASHINGTON SOLDIERS HOME | 1301 ORTING-KAPOWSIN HWY E | ORTING | WA | 98360 | 3608934515 | 260 | Pierce | Government - State | 97 | 86.4 | Medicare and Medicaid | false | STATE OF WASHINGTON WASHINGTON SOLDIERS HOME | 01/01/2007 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 3 | 3 | 4 | 5 | 5 | 2.81674 | 0.92989 | 0.99652 | 1.92641 | 4.74315 | 0.01829 | 1.97169 | 0.70307 | 0.30886 | 2.98362 | 2.9691 | 0.99453 | 1.21437 | 5.09773 | 03/13/2019 | 12 | 12 | 0 | 60 | 1 | 0 | 60 | 03/02/2018 | 16 | 16 | 0 | 84 | 1 | 0 | 84 | 2017-04-07 | 50 | 31 | 43 | 2 | 1453 | 727 | 2180 | 421.333 | 21 | 1 | 1 | 16084.00 | 0 | 1 | 1301 ORTING-KAPOWSIN HWY E ORTING, WA 98360 (47.082367, -122.214314) | 02/01/2020 | ||||||||||
12811 | 12811 | 1550 NORTH PARK AVENUE POMONA, CA 91768 | 34.074437 | -117.754871 | 0 | 555852 | PARK AVENUE HEALTHCARE & WELLNESS CENTER | 1550 NORTH PARK AVENUE | POMONA | CA | 91768 | 9096230791 | 200 | Los Angeles | For profit - Individual | 231 | 222.3 | Medicare and Medicaid | false | POMONA HEALTHCARE & WELLNESS CENTER, LLC | 09/08/2008 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 3 | 5 | 1 | 2 | 1 | 2.4657 | 1.08262 | 0.37566 | 1.45828 | 3.92397 | 0.05235 | 2.00438 | 0.7157 | 0.45391 | 3.174 | 2.55667 | 1.13744 | 0.31149 | 3.96436 | 02/07/2019 | 25 | 0 | 25 | 612 | 1 | 0 | 612 | 02/07/2018 | 36 | 26 | 15 | 216 | 1 | 0 | 216 | 2017-03-10 | 31 | 20 | 11 | 2 | 208 | 104 | 312 | 430 | 21 | 33 | 0 | 0.00 | 0 | 0 | 1550 NORTH PARK AVENUE POMONA, CA 91768 (34.074437, -117.754871) | 02/01/2020 | ||||||||||
15348 | 15348 | 1000 EAST ELEP STREET COLVILLE, WA 99114 | 48.539714 | -117.892449 | 0 | 505275 | PRESTIGE CARE & REHABILITATION - PINEWOOD TERRACE | 1000 EAST ELEP STREET | COLVILLE | WA | 99114 | 5096842573 | 320 | Stevens | For profit - Corporation | 92 | 71.2 | Medicare and Medicaid | false | CARE CENTER COLVILLE INC. | 09/01/1983 | false | true | false | false | Resident | Yes | 2 | 1 | 3 | 3 | 3 | 5 | 5 | 2.60504 | 0.46008 | 0.86041 | 1.32049 | 3.92553 | 0.0321 | 2.01986 | 0.64269 | 0.29967 | 2.96222 | 2.68045 | 0.53829 | 1.08069 | 4.24947 | 07/19/2019 | 31 | 20 | 16 | 188 | 1 | 0 | 188 | 06/26/2018 | 26 | 13 | 13 | 322 | 1 | 0 | 322 | 2017-05-15 | 17 | 11 | 17 | 1 | 116 | 0 | 116 | 220.667 | 21 | 11 | 6 | 75105.00 | 0 | 6 | 1000 EAST ELEP STREET COLVILLE, WA 99114 (48.539714, -117.892449) | 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 );