nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
7 rows where Overall Rating Footnote = 18 and geocode_flag = 1
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_accuracy, nmbr_beds, Continuing Care Retirement Community, Abuse Icon, With a Resident and Family Council, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Revisit Score, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4164 | 4164 | 621 W 21st St, Andover, KS 67002, USA | 37.72251 | -97.1414099 | 1 | ROOFTOP | 175157 | LIFE CARE CENTER OF ANDOVER | 621 W 21ST, PO BOX 100 | ANDOVER | KS | 67002 | 3167331349 | 70 | Butler | For profit - Corporation | 154 | 76.8 | Medicare and Medicaid | false | ANDOVER MEDICAL INVESTORS, LLC | 10/31/1986 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.13408 | 0.98012 | 0.32956 | 1.30968 | 3.44377 | 0.14483 | 2.04491 | 0.73652 | 0.3436 | 3.12503 | 2.16897 | 1.00064 | 0.36101 | 3.53372 | 02/07/2019 | 41 | 26 | 22 | 434 | 2 | 217 | 651 | 03/06/2018 | 32 | 26 | 15 | 256 | 1 | 0 | 256 | 2016-09-06 | 36 | 27 | 9 | 2 | 364 | 182 | 546 | 501.833 | 3 | 28 | 5 | 350261.00 | 1 | 6 | 02/01/2020 | ||||||||||
10411 | 10411 | 1104 US-12, Hettinger, ND 58639, USA | 46.0026439 | -102.6256355 | 1 | ROOFTOP | 355042 | WESTERN HORIZONS CARE CENTER | 1104 HWY 12 | HETTINGER | ND | 58639 | 7015672401 | 0 | Adams | Non profit - Corporation | 45 | 38.7 | Medicare and Medicaid | false | WESTERN HORIZONS LIVING CENTERS | 05/01/1978 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.9425 | 0.60227 | 0.58489 | 1.18716 | 4.12966 | 0.00793 | 2.00509 | 0.62943 | 0.24733 | 2.88185 | 3.04999 | 0.71949 | 0.8901 | 4.59511 | 07/11/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 12/20/2018 | 8 | 8 | 0 | 36 | 1 | 0 | 36 | 2018-01-25 | 52 | 16 | 36 | 1 | 551 | 0 | 551 | 111.833 | 0 | 17 | 1 | 193772.00 | 0 | 1 | 02/01/2020 | ||||||||||
10713 | 10713 | 1 Penn Blvd, Philadelphia, PA 19144, USA | 40.0403868 | -75.1595035 | 1 | ROOFTOP | 396129 | WILLOW TERRACE | ONE PENN BOULEVARD | PHILADELPHIA | PA | 19144 | 2159518500 | 620 | Philadelphia | For profit - Corporation | 174 | 157.5 | Medicare and Medicaid | false | WT OPERATING LLC | 08/13/2010 | true | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.20546 | 1.00255 | 0.40408 | 1.40664 | 3.6121 | 0.06443 | 1.9975 | 0.81605 | 0.4388 | 3.25235 | 2.29471 | 0.92379 | 0.34661 | 3.56135 | 06/19/2019 | 27 | 24 | 5 | 172 | 1 | 0 | 172 | 05/02/2018 | 51 | 32 | 26 | 605 | 2 | 303 | 908 | 2017-03-01 | 9 | 4 | 5 | 1 | 52 | 0 | 52 | 397.333 | 2 | 39 | 2 | 202672.00 | 1 | 3 | 02/01/2020 | ||||||||||
11217 | 11217 | 813 1/2 Marion Pike, Coal Grove, OH 45638, USA | 38.4998253 | -82.6373679 | 1 | ROOFTOP | 366202 | CRYSTAL CARE OF COAL GROVE | 813 1/2 MARION PIKE | COAL GROVE | OH | 45638 | 7405320449 | 450 | Lawrence | For profit - Partnership | 57 | 44.8 | Medicare and Medicaid | false | CRYSTAL CARE OF IRONTON, LLC | 08/10/2000 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.10044 | 0.97837 | 0.06223 | 1.0406 | 3.14105 | 0.01995 | 2.26517 | 0.89473 | 0.46124 | 3.62115 | 1.9272 | 0.82223 | 0.05078 | 2.78151 | 11/21/2019 | 24 | 13 | 11 | 144 | 0 | 0 | 144 | 06/24/2019 | 70 | 52 | 18 | 636 | 1 | 0 | 636 | 2018-05-09 | 31 | 29 | 3 | 1 | 240 | 0 | 240 | 324 | 1 | 12 | 0 | 0.00 | 1 | 1 | 02/01/2020 | ||||||||||
13608 | 13608 | 821 I-35BL, New Braunfels, TX 78130, USA | 29.6911115 | -98.1237433 | 1 | ROOFTOP | 455020 | COLONIAL MANOR CARE CENTER | 821 US HWY 81 W | NEW BRAUNFELS | TX | 78130 | 8306257526 | 320 | Comal | For profit - Corporation | 154 | 126.9 | Medicare and Medicaid | false | COLONIAL NEW BRAUNFELS CARE CENTER LLC | 06/01/1976 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.13263 | 1.26971 | 0.22817 | 1.49788 | 3.63051 | 0 | 1.9021 | 0.79213 | 0.4156 | 3.10984 | 2.33022 | 1.20529 | 0.20664 | 3.74354 | 02/26/2019 | 39 | 31 | 11 | 830 | 1 | 0 | 830 | 02/02/2018 | 26 | 21 | 5 | 212 | 1 | 0 | 212 | 2017-01-12 | 19 | 5 | 14 | 1 | 793 | 0 | 793 | 617.833 | 9 | 26 | 4 | 220368.00 | 1 | 5 | 02/01/2020 | ||||||||||
13685 | 13685 | 2400 E Mitchell St, Humboldt, TN 38343, USA | 35.8227245 | -88.9042207 | 1 | ROOFTOP | 445339 | BAILEY PARK CLC | 2400 MITCHELL STREET | HUMBOLDT | TN | 38343 | 7317845183 | 260 | Gibson | For profit - Individual | 50 | 36.1 | Medicare and Medicaid | false | CLC OF HUMBOLDT, LLC | 11/02/1994 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.03168 | 1.29206 | 0.54092 | 1.83298 | 3.86467 | 0.11876 | 2.24378 | 0.79897 | 0.3785 | 3.42124 | 1.88188 | 1.21601 | 0.5379 | 3.62228 | 12/04/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 02/28/2019 | 9 | 9 | 0 | 612 | 1 | 0 | 612 | 2018-04-11 | 5 | 5 | 0 | 1 | 24 | 0 | 24 | 212 | 0 | 0 | 2 | 326998.00 | 1 | 3 | 02/01/2020 | ||||||||||
15107 | 15107 | NC-177, Hamlet, NC, USA | 34.8920793 | -79.7027708 | 1 | GEOMETRIC_CENTER | 345293 | RICHMOND PINES HEALTHCARE AND REHABILITATION CENTE | HIGHWAY 177 S BOX 1489 | HAMLET | NC | 28345 | 9105820021 | 760 | Richmond | For profit - Corporation | 105 | 88.5 | Medicare and Medicaid | false | SPRUCE LTC GROUP, LLC | 01/18/1989 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.10043 | 0.82314 | 0.55654 | 1.37969 | 3.48012 | 0.0587 | 1.94029 | 0.73343 | 0.36447 | 3.03819 | 2.24987 | 0.84392 | 0.57474 | 3.6731 | 10/03/2019 | 15 | 15 | 1 | 72 | 1 | 0 | 72 | 04/04/2019 | 25 | 19 | 12 | 132 | 1 | 0 | 132 | 2018-10-18 | 34 | 22 | 15 | 1 | 355 | 0 | 355 | 139.167 | 1 | 44 | 4 | 133263.00 | 2 | 6 | 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 );