nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Physical Therapist Staffing Footnote = 6 and Special Focus Status = "SFF"
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, Abuse Icon, With a Resident and Family Council, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Facility Reported Incidents, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26 | 26 | 700 E 21ST AVE GARY, IN 46407 | 41.58031 | -87.327837 | 0 | 155845 | SIMMONS LOVING CARE HEALTH FACILITY | 700 E 21ST AVE | GARY | IN | 46407 | 2198822563 | 440 | Lake | Non profit - Corporation | 46 | 18.7 | Medicare and Medicaid | false | PULASKI MEMORIAL HOSPITAL | 04/26/2016 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 11/20/2019 | 34 | 27 | 7 | 321 | 0 | 0 | 321 | 03/28/2019 | 42 | 34 | 8 | 260 | 1 | 0 | 260 | 2018-06-14 | 38 | 27 | 11 | 2 | 264 | 132 | 396 | 313.167 | 0 | 27 | 1 | 13673.00 | 2 | 3 | 700 E 21ST AVE GARY, IN 46407 (41.58031, -87.327837) | 02/01/2020 | ||||||||||||||||||||||
49 | 49 | 3333 BROWN ROAD SAINT LOUIS, MO 63114 | 38.712458 | -90.349985 | 0 | 265733 | ST JOHNS PLACE | 3333 BROWN ROAD | SAINT LOUIS | MO | 63114 | 3144262211 | 940 | St. Louis | For profit - Corporation | 94 | 62.2 | Medicare and Medicaid | false | Legal Business Name Not Available | 06/01/2002 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 09/13/2019 | 10 | 7 | 3 | 60 | 1 | 0 | 60 | 02/22/2019 | 9 | 7 | 2 | 115 | 1 | 0 | 115 | 2018-09-13 | 18 | 8 | 13 | 1 | 320 | 0 | 320 | 121.667 | 3 | 15 | 3 | 204231.00 | 1 | 4 | 3333 BROWN ROAD SAINT LOUIS, MO 63114 (38.712458, -90.349985) | 02/01/2020 | ||||||||||||||||||||||
6223 | 6223 | 563 KAUMANA DRIVE HILO, HI 96720 | 19.7042 | -155.111039 | 0 | 125065 | LEGACY HILO REHABILITATION & NURSING CENTER | 563 KAUMANA DRIVE | HILO | HI | 96720 | 8084980184 | 10 | Hawaii | For profit - Partnership | 100 | 72.3 | Medicare and Medicaid | false | KAUMANA DRIVE PARTNERS LLC | 01/20/2016 | false | SFF | true | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 08/09/2019 | 6 | 0 | 6 | 155 | 1 | 0 | 155 | 02/08/2019 | 22 | 10 | 12 | 144 | 1 | 0 | 144 | 2018-08-16 | 9 | 9 | 0 | 1 | 36 | 0 | 36 | 131.5 | 1 | 10 | 4 | 232031.00 | 2 | 6 | 563 KAUMANA DRIVE HILO, HI 96720 (19.7042, -155.111039) | 02/01/2020 | ||||||||||||||||||||||
8286 | 8286 | 919 OLD WINTER HAVEN RD AUBURNDALE, FL 33823 | 28.058697 | -81.77095 | 0 | 105302 | OAK HAVEN REHAB AND NURSING CENTER | 919 OLD WINTER HAVEN RD | AUBURNDALE | FL | 33823 | 8639674125 | 520 | Polk | For profit - Corporation | 120 | 99.2 | Medicare and Medicaid | false | AUBURNDALE OAKS CARE ACQUISITION, LLC | 01/01/1977 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 12/13/2018 | 15 | 13 | 9 | 394 | 2 | 197 | 591 | 09/22/2017 | 7 | 4 | 3 | 32 | 1 | 0 | 32 | 2016-07-28 | 9 | 7 | 2 | 1 | 44 | 0 | 44 | 313.5 | 0 | 16 | 1 | 147689.00 | 1 | 2 | 919 OLD WINTER HAVEN RD AUBURNDALE, FL 33823 (28.058697, -81.77095) | 02/01/2020 | ||||||||||||||||||||||
9684 | 9684 | 6800 N 76TH STREET MILWAUKEE, WI 53223 | 43.142198 | -88.005448 | 0 | 525529 | BRIDGES OF MILWAUKEE REHAB AND CARE CENTER (THE) | 6800 N 76TH STREET | MILWAUKEE | WI | 53223 | 4143535000 | 390 | Milwaukee | For profit - Corporation | 144 | 74.4 | Medicare and Medicaid | false | JB MILWAUKEE HEALTHCARE LLC | 04/01/1994 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 07/23/2019 | 20 | 15 | 5 | 270 | 2 | 135 | 405 | 02/26/2019 | 34 | 24 | 19 | 319 | 1 | 0 | 319 | 2017-11-27 | 22 | 15 | 12 | 2 | 112 | 56 | 168 | 336.833 | 4 | 20 | 0 | 0.00 | 2 | 2 | 6800 N 76TH STREET MILWAUKEE, WI 53223 (43.142198, -88.005448) | 02/01/2020 | ||||||||||||||||||||||
11351 | 11351 | 2611 SOUTH DEARBORN SEATTLE, WA 98144 | 47.595543 | -122.298278 | 0 | 505511 | PARAMOUNT REHABILITATION AND NURSING | 2611 SOUTH DEARBORN | SEATTLE | WA | 98144 | 2063256700 | 160 | King | For profit - Limited Liability company | 165 | 92.1 | Medicare and Medicaid | false | PARAMOUNT REHABILITATION AND NURSING LLC | 06/11/2003 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 09/24/2019 | 56 | 45 | 11 | 518 | 1 | 0 | 518 | 04/05/2019 | 37 | 22 | 17 | 224 | 1 | 0 | 224 | 2018-10-18 | 40 | 29 | 17 | 1 | 220 | 0 | 220 | 370.333 | 19 | 26 | 3 | 51132.00 | 1 | 4 | 2611 SOUTH DEARBORN SEATTLE, WA 98144 (47.595543, -122.298278) | 02/01/2020 | ||||||||||||||||||||||
13249 | 13249 | 504 N JOHN REDDITT DR LUFKIN, TX 75904 | 31.336977 | -94.7615 | 0 | 455855 | KENNEDY HEALTH & REHAB | 504 N JOHN REDDITT DR | LUFKIN | TX | 75904 | 9366323331 | 20 | Angelina | For profit - Individual | 145 | 75.4 | Medicare and Medicaid | false | KENNEDY REHABILITATION & HEALTHCARE LLC | 12/05/1989 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 09/17/2019 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 10/17/2018 | 6 | 4 | 2 | 48 | 1 | 0 | 48 | 2017-11-30 | 41 | 13 | 28 | 1 | 1033 | 0 | 1033 | 204.167 | 14 | 13 | 2 | 172485.00 | 1 | 3 | 504 N JOHN REDDITT DR LUFKIN, TX 75904 (31.336977, -94.7615) | 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 );