nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
5 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2016-12-08
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, ownership, prvdr_type, Special Focus Status, Provider Changed Ownership in Last 12 Months, 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 2 Number of Complaint 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9483 | 9483 | 1450 WEST MAIN STREET NEWARK, OH 43055 | 40.04589 | -82.454643 | 0 | 365485 | FLINT RIDGE NRSG & REHAB CTR | 1450 WEST MAIN STREET | NEWARK | OH | 43055 | 7403449465 | 460 | Licking | For profit - Corporation | 78 | 60.2 | Medicare and Medicaid | false | FLINT RIDGE HEALTHCARE LLC | 03/24/1980 | false | true | false | true | Resident | Yes | 1 | 1 | 3 | 2 | 3 | 2 | 2 | 1.803 | 1.3575 | 0.41673 | 1.77422 | 3.57723 | 0.07126 | 2.01345 | 0.78234 | 0.40705 | 3.20284 | 1.86111 | 1.30475 | 0.38533 | 3.58149 | 03/14/2019 | 28 | 18 | 10 | 156 | 1 | 0 | 156 | 02/14/2018 | 26 | 18 | 8 | 164 | 1 | 0 | 164 | 2016-12-08 | 7 | 4 | 3 | 1 | 28 | 0 | 28 | 137.333 | 0 | 15 | 1 | 6000.00 | 0 | 1 | 1450 WEST MAIN STREET NEWARK, OH 43055 (40.04589, -82.454643) | 02/01/2020 | |||||||||||
10576 | 10576 | 210 SOUTH ADAIR PRYOR, OK 74361 | 36.303069 | -95.318821 | 0 | 375334 | SHADY REST CARE CENTER | 210 SOUTH ADAIR | PRYOR | OK | 74361 | 9188254455 | 480 | Mayes | For profit - Corporation | 65 | 27.9 | Medicare and Medicaid | false | SHADY REST CARE CENTER, LLC | 03/02/1998 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 2 | 4 | 1 | 4 | 3 | 2.46341 | 0.96566 | 0.50161 | 1.46727 | 3.93068 | 0.01414 | 1.73587 | 0.67411 | 0.29114 | 2.70112 | 2.94942 | 1.07715 | 0.64848 | 4.66635 | 04/18/2019 | 28 | 28 | 0 | 425 | 1 | 0 | 425 | 03/07/2018 | 9 | 9 | 0 | 56 | 1 | 0 | 56 | 2016-12-08 | 8 | 8 | 0 | 1 | 64 | 0 | 64 | 241.833 | 0 | 0 | 1 | 70972.00 | 0 | 1 | 210 SOUTH ADAIR PRYOR, OK 74361 (36.303069, -95.318821) | 02/01/2020 | ||||||||||
11767 | 11767 | 1100 Georgia St, Jones, OK 73049, USA | 35.5636213 | -97.29572209999999 | 1 | ROOFTOP | 375117 | OAK HILLS LIVING CENTER | 1100 WEST GEORGIA | JONES | OK | 73049 | 4054002295 | 540 | Oklahoma | For profit - Individual | 160 | 86.5 | Medicare and Medicaid | false | OAK HILLS CARE CENTER RECEIVERSHIP, LLC | 02/10/1992 | false | true | false | true | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 04/16/2019 | 26 | 12 | 18 | 244 | 1 | 0 | 244 | 03/06/2018 | 21 | 15 | 6 | 156 | 1 | 0 | 156 | 2016-12-08 | 9 | 5 | 4 | 1 | 56 | 0 | 56 | 183.333 | 0 | 19 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
12802 | 12802 | 401 PENN AVENUE SCRANTON, PA 18503 | 41.412527 | -75.663012 | 0 | 39A433 | GINO J MERLI VETERANS CENTER | 401 PENN AVENUE | SCRANTON | PA | 18503 | 5709614300 | 420 | Lackawanna | Government - State | 196 | 179.6 | Medicaid | false | Legal Business Name Not Available | 01/01/2009 | false | true | false | false | Both | Yes | 3 | 2 | 3 | 3 | 2 | 4 | 4 | 2.32648 | 0.87107 | 0.74916 | 1.62023 | 3.94671 | 0.02669 | 2.11361 | 0.66605 | 0.31223 | 3.09189 | 2.28765 | 0.9834 | 0.90309 | 4.09321 | 12/07/2018 | 6 | 5 | 1 | 56 | 1 | 0 | 56 | 01/26/2018 | 7 | 7 | 0 | 48 | 1 | 0 | 48 | 2016-12-08 | 16 | 11 | 5 | 1 | 104 | 0 | 104 | 61.333 | 1 | 6 | 0 | 0.00 | 0 | 0 | 401 PENN AVENUE SCRANTON, PA 18503 (41.412527, -75.663012) | 02/01/2020 | |||||||||||
13674 | 13674 | 850 EAST MIDLOTHIAN BLVD YOUNGSTOWN, OH 44507 | 41.060774 | -80.639202 | 0 | 365795 | OASIS CENTER FOR REHABILITATION AND HEALING | 850 EAST MIDLOTHIAN BLVD | YOUNGSTOWN | OH | 44507 | 3307883038 | 510 | Mahoning | For profit - Corporation | 99 | 82.2 | Medicare and Medicaid | false | OASIS NURSING LLC | 07/02/1990 | false | SFF Candidate | true | false | false | Both | Yes | 2 | 1 | 5 | 5 | 2 | 3 | 3 | 2.26251 | 0.88032 | 0.69862 | 1.57894 | 3.84145 | 0.09135 | 1.97749 | 0.89537 | 0.48246 | 3.35532 | 2.3779 | 0.7393 | 0.54502 | 3.67125 | 03/18/2019 | 21 | 20 | 3 | 316 | 1 | 0 | 316 | 02/01/2018 | 11 | 3 | 8 | 84 | 1 | 0 | 84 | 2016-12-08 | 26 | 23 | 3 | 2 | 152 | 76 | 228 | 224 | 2 | 12 | 1 | 114381.00 | 0 | 1 | 850 EAST MIDLOTHIAN BLVD YOUNGSTOWN, OH 44507 (41.060774, -80.639202) | 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 );