nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-07-28
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, prvdr_type, Continuing Care Retirement Community, 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 Physical Therapist Staffing Hours per Resident Per Day, 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 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 3 Number of Standard 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, Number of Facility Reported Incidents, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6154 | 6154 | 2030 N GAREY AVE POMONA, CA 91767 | 34.083709 | -117.752566 | 0 | 05A134 | LANDMARK MEDICAL CENTER | 2030 N. GAREY AVE. | POMONA | CA | 91767 | 9095932585 | 200 | Los Angeles | For profit - Corporation | 95 | 93.9 | Medicaid | false | Legal Business Name Not Available | 03/31/1974 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 2 | 2 | 1 | 2.03403 | 0.70375 | 0.09013 | 0.79388 | 2.82791 | 0 | 1.43196 | 0.52772 | 0.22824 | 2.18793 | 2.95217 | 1.00277 | 0.14862 | 4.14463 | 08/01/2019 | 11 | 8 | 3 | 52 | 1 | 0 | 52 | 07/17/2018 | 9 | 5 | 4 | 56 | 1 | 0 | 56 | 2017-07-28 | 16 | 10 | 7 | 1 | 80 | 0 | 80 | 58 | 17 | 0 | 0 | 0.00 | 0 | 0 | 2030 N GAREY AVE POMONA, CA 91767 (34.083709, -117.752566) | 02/01/2020 | |||||||||||
11085 | 11085 | 200 LIVE OAK ST ATLANTA, TX 75551 | 33.107136 | -94.16461 | 0 | 675603 | ROSE HAVEN RETREAT | 200 LIVE OAK ST | ATLANTA | TX | 75551 | 9037964127 | 260 | Cass | Government - Hospital district | 108 | 51.7 | Medicare and Medicaid | false | WINNIE-STOWELL HOSPITAL DISTRICT | 06/14/1996 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 2 | 1 | 2.04815 | 1.38309 | 0.29988 | 1.68297 | 3.73112 | 0.007 | 1.97003 | 0.79106 | 0.4227 | 3.18379 | 2.16076 | 1.31469 | 0.26702 | 3.75793 | 05/16/2019 | 8 | 0 | 8 | 411 | 1 | 0 | 411 | 06/14/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-07-28 | 13 | 8 | 10 | 1 | 362 | 0 | 362 | 265.833 | 7 | 3 | 2 | 46571.00 | 0 | 2 | 200 LIVE OAK ST ATLANTA, TX 75551 (33.107136, -94.16461) | 02/01/2020 | |||||||||||
11710 | 11710 | 3701 WASSON RD BIG SPRING, TX 79720 | 32.211102 | -101.492449 | 0 | 676380 | BIG SPRING CENTER FOR SKILLED CARE | 3701 WASSON RD | BIG SPRING | TX | 79720 | 4326065012 | 661 | Howard | For profit - Individual | 120 | 71.5 | Medicare and Medicaid | false | BIG SPRING I ENTERPRISES, LLC | 03/13/2015 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 3 | 1 | 12 | 1 | 12 | 2.41958 | 0.81199 | 0.26906 | 1.08105 | 3.50063 | 0.07375 | 2.11488 | 0.78248 | 0.403 | 3.30037 | 2.37777 | 0.7803 | 0.25129 | 3.40124 | 09/19/2019 | 11 | 6 | 5 | 326 | 1 | 0 | 326 | 09/13/2018 | 6 | 4 | 6 | 48 | 1 | 0 | 48 | 2017-07-28 | 3 | 3 | 0 | 1 | 20 | 0 | 20 | 182.333 | 4 | 1 | 0 | 0.00 | 1 | 1 | 3701 WASSON RD BIG SPRING, TX 79720 (32.211102, -101.492449) | 02/01/2020 | |||||||||
12830 | 12830 | 1555 EAST END BOULEVARD PLAINS WILKES BARRE, PA 18711 | 41.248912 | -75.836029 | 0 | 395148 | TIMBER RIDGE HEALTH CENTER | 1555 EAST END BOULEVARD PLAINS TWP | WILKES BARRE | PA | 18711 | 5708261011 | 480 | Luzerne | For profit - Corporation | 180 | 168.9 | Medicare and Medicaid | false | VALLEY CREST NURSING, INC. | 01/01/1967 | false | true | false | false | None | Yes | 2 | 2 | 3 | 4 | 2 | 2 | 2 | 2.30523 | 0.86056 | 0.44657 | 1.30713 | 3.61237 | 0.05457 | 2.15874 | 0.84867 | 0.44788 | 3.4553 | 2.21937 | 0.76248 | 0.37528 | 3.35243 | 07/26/2019 | 5 | 5 | 1 | 32 | 1 | 0 | 32 | 08/03/2018 | 12 | 11 | 2 | 60 | 1 | 0 | 60 | 2017-07-28 | 21 | 12 | 9 | 2 | 120 | 60 | 180 | 66 | 1 | 10 | 0 | 0.00 | 1 | 1 | 1555 EAST END BOULEVARD PLAINS WILKES BARRE, PA 18711 (41.248912, -75.836029) | 02/01/2020 | |||||||||||
13144 | 13144 | 120 LAKESIDE DRIVE WORTHINGTON, PA 16262 | 40.896932 | -79.673697 | 0 | 395410 | QUALITY LIFE SERVICES - SUGAR CREEK | 120 LAKESIDE DRIVE | WORTHINGTON | PA | 16262 | 7244453146 | 70 | Armstrong | For profit - Partnership | 114 | 96.6 | Medicare and Medicaid | false | SUGAR CREEK REST, LTD PTR | 04/06/1978 | true | true | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 4 | 2 | 2 | 1.80066 | 1.09068 | 0.55206 | 1.64275 | 3.44341 | 0.02188 | 2.15974 | 0.82215 | 0.44081 | 3.4227 | 1.73279 | 0.99755 | 0.47137 | 3.22606 | 06/20/2019 | 7 | 5 | 2 | 68 | 1 | 0 | 68 | 06/05/2018 | 6 | 6 | 1 | 36 | 1 | 0 | 36 | 2017-07-28 | 6 | 5 | 2 | 1 | 44 | 0 | 44 | 53.333 | 1 | 6 | 0 | 0.00 | 0 | 0 | 120 LAKESIDE DRIVE WORTHINGTON, PA 16262 (40.896932, -79.673697) | 02/01/2020 | |||||||||||
13283 | 13283 | 515 W ASHBY PL SAN ANTONIO, TX 78212 | 29.449138 | -98.498824 | 0 | 455689 | SAN PEDRO MANOR | 515 W ASHBY PL | SAN ANTONIO | TX | 78212 | 2107325181 | 130 | Bexar | For profit - Limited Liability company | 150 | 94.5 | Medicare and Medicaid | false | UVALDE COUNTY HOSPITAL AUTHORITY | 02/18/1987 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 1 | 1 | 1.71552 | 1.07604 | 0.29193 | 1.36797 | 3.08349 | 0 | 2.01244 | 0.80048 | 0.41464 | 3.22756 | 1.77169 | 1.01079 | 0.265 | 3.06352 | 08/16/2019 | 14 | 12 | 3 | 124 | 1 | 0 | 124 | 08/17/2018 | 22 | 12 | 11 | 216 | 1 | 0 | 216 | 2017-07-28 | 10 | 8 | 3 | 1 | 80 | 0 | 80 | 147.333 | 5 | 8 | 1 | 12906.00 | 0 | 1 | 515 W ASHBY PL SAN ANTONIO, TX 78212 (29.449138, -98.498824) | 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 );