nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
29 rows where Long-Stay QM Rating Footnote = 1 and geocode_flag = 1
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_accuracy, prvdr_state, prvdr_phn, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, avg_residents, prvdr_type, Legal Business Name, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, With a Resident and Family Council, Reported Staffing Footnote, Reported Nurse Aide Staffing Hours per Resident per Day, Reported LPN 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 RN Staffing Hours per Resident per Day, Case-Mix Total Nurse Staffing Hours per Resident per Day, Rating Cycle 1 Standard Survey Health Date, Number of Facility Reported Incidents
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52 | 52 | 3130 S John Duffy Dr, Joplin, MO 64804, USA | 37.0563566 | -94.5886796 | 1 | RANGE_INTERPOLATED | 265877 | WESTGATE | 3130 JOHN DUFFY DR | JOPLIN | MO | 64804 | 4175533688 | 480 | Jasper | For profit - Limited Liability company | 120 | 26.9 | Medicare and Medicaid | false | JOPLIN NO 10 LLC | 07/16/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.78035 | 1.09527 | 1.0944 | 2.18967 | 4.97002 | 0.01571 | 2.03434 | 0.64967 | 0.29061 | 2.97462 | 07/16/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
91 | 91 | 60 Okatie Village Dr, Okatie, SC 29909, USA | 32.2963223 | -80.94367179999999 | 1 | ROOFTOP | 425415 | SPRENGER HEALTHCARE OF BLUFFTON | 60 OKATIE VILLAGE DRIVE | BLUFFTON | SC | 29909 | 8332546634 | 260 | Jasper | For profit - Corporation | 60 | 3.5 | Medicare and Medicaid | false | SPRENGER HEALTHCARE OF BLUFFTON INC | 07/01/2019 | true | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 06/13/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||||||||||
1396 | 1396 | 10250 U.S. Hwy 42, Union, KY 41091, USA | 38.9623133 | -84.67945929999999 | 1 | RANGE_INTERPOLATED | 185486 | BOONESPRING TRANSITIONAL CARE CENTER, LLC | 10250 US HWY 42 | UNION | KY | 41091 | 8593841200 | 70 | Boone | For profit - Corporation | 143 | 94.5 | Medicare and Medicaid | false | BOONESPRING TRANSITIONAL CARE CENTER, LLC | 03/05/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.12726 | 0.97201 | 1.0344 | 2.00642 | 4.13368 | 0.11569 | 2.3011 | 0.83356 | 0.40891 | 3.54357 | 03/05/2019 | . | . | . | . | . | . | . | . | . | 1 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
1769 | 1769 | 517 33rd St, Meridian, MS 39305, USA | 32.3914922 | -88.6847813 | 1 | ROOFTOP | 255348 | TREND HEALTH & REHAB OF MERIDIAN LLC | 517 33RD STREET | MERIDIAN | MS | 39305 | 6012821300 | 370 | Lauderdale | For profit - Individual | 58 | Medicare and Medicaid | false | TREND HEALTH & REHAB OF MERIDIAN LLC | 11/27/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 11/27/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
2389 | 2389 | 14660 W Parkwood Dr, Surprise, AZ 85374, USA | 33.6492867 | -112.3760141 | 1 | ROOFTOP | 35297 | SURPRISE HEALTH AND REHABILITATION CENTER | 14660 W PARKWOOD DRIVE | SURPRISE | AZ | 85374 | 6235465030 | 60 | Maricopa | For profit - Corporation | 100 | Medicare | false | LUDDEN HEALTHCARE, INC. | 10/04/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 09/25/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
3350 | 3350 | 400 Winchester Rd, Bernie, MO 63822, USA | 36.6656408 | -89.98114389999999 | 1 | ROOFTOP | 265874 | WINCHESTER NURSING CENTER, INC | 400 WINCHESTER DR, PO BOX 760 | BERNIE | MO | 63822 | 5732936702 | 985 | Stoddard | For profit - Corporation | 40 | 34.9 | Medicare and Medicaid | false | WINCHESTER NURSING CENTER, INC | 01/09/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.2797 | 0.49897 | 0.72684 | 1.22581 | 3.5055 | 0.05017 | 1.98294 | 0.69796 | 0.32387 | 3.00477 | 01/09/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
3801 | 3801 | 1521 N Pine Cliff Dr, Flagstaff, AZ 86001, USA | 35.2072208 | -111.6352139 | 1 | ROOFTOP | 35296 | WELBROOK SENIOR LIVING FLAGSTAFF LLC | 1521 NORTH PINE CLIFF DRIVE | EAST FLAGSTAFF | AZ | 86001 | 9284402350 | 20 | Coconino | For profit - Corporation | 50 | 27.9 | Medicare | false | WELBROOK SENIOR LIVING FLAGSTAFF LLC | 10/11/2018 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.59385 | 1.35367 | 1.5853 | 2.93897 | 5.53282 | 0.46782 | 1.96303 | 0.96939 | 0.53901 | 3.47144 | 10/04/2018 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
3806 | 3806 | W Village Cir, Wichita, KS 67205, USA | 37.757614 | -97.41983 | 1 | GEOMETRIC_CENTER | 175563 | THE HEALTHCARE RESORT OF WICHITA | 7057 WEST VILLAGE CIRCLE | WICHITA | KS | 67205 | 3169777015 | 860 | Sedgwick | For profit - Corporation | 70 | 17.3 | Medicare and Medicaid | false | MOC WICHITA LLC | 05/02/2019 | true | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4.98718 | 1.64176 | 1.66029 | 3.30205 | 8.28923 | 0 | 2.36944 | 1.12306 | 0.60673 | 4.09922 | 05/02/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
4933 | 4933 | 2355 Vidina Dr, Melbourne, FL 32940, USA | 28.2256546 | -80.72861929999999 | 1 | ROOFTOP | 106123 | VIERA DEL MAR HEALTH AND REHABILITATION CENTER | 2355 VIDINA DRIVE | VIERA | FL | 32940 | 3217756800 | 40 | Brevard | For profit - Corporation | 131 | 25.2 | Medicare and Medicaid | false | BREVARD OAKS CENTER, LLC | 05/22/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4.19286 | 3.18952 | 1.93219 | 5.12171 | 9.31458 | 0.34781 | 2.33761 | 1.0947 | 0.56421 | 3.99652 | 05/22/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
5328 | 5328 | 712 Copper Rock Drive, Rogersville, MO 65742, USA | 37.1013661 | -93.06327089999999 | 1 | ROOFTOP | 265878 | COPPER ROCK HEALTHCARE | 712 COPPER ROCK DRIVE | ROGERSVILLE | MO | 65742 | 4172024606 | 994 | Webster | Non profit - Corporation | 90 | Medicare and Medicaid | false | WILLOW HEALTH CARE INC | 10/03/2019 | false | false | false | false | Both | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 10/03/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
5481 | 5481 | 3980 Lake Placid Dr, Reno, NV 89511, USA | 39.3929796 | -119.7897845 | 1 | ROOFTOP | 295103 | NEURORESTORATIVE NEVADA | 3980 LAKE PLACID DRIVE | RENO | NV | 89511 | 7024999523 | 150 | Washoe | For profit - Limited Liability company | 24 | Medicare and Medicaid | false | CAREMERIDIAN LLC | 04/10/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 03/13/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
6352 | 6352 | 3640 Central Ave, Indianapolis, IN 46205, USA | 39.8224421 | -86.15029489999999 | 1 | ROOFTOP | 155857 | TRANQUILITY NURSING AND REHAB | 3640 N CENTRAL AVENUE | INDIANAPOLIS | IN | 46205 | 3174800806 | 480 | Marion | For profit - Individual | 78 | 5.3 | Medicare and Medicaid | false | DECATUR COUNTY MEMORIAL HOSPITAL | 06/01/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 05/31/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||||||||||
7318 | 7318 | 800 E County Rd 540A, Lakeland, FL 33813, USA | 27.9524791 | -81.9469546 | 1 | RANGE_INTERPOLATED | 106120 | SCOTT LAKE HEALTH AND REHABILITATION CENTER | 800 E COUNTY RD 540A | LAKELAND | FL | 33813 | 8635004015 | 520 | Polk | For profit - Corporation | 120 | 70.6 | Medicare and Medicaid | false | LAKELAND SNF INVESTORS LLC | 10/16/2018 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.92013 | 1.01051 | 0.75447 | 1.76498 | 4.68511 | 0.16209 | 2.07263 | 0.78988 | 0.41457 | 3.27709 | 10/16/2018 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
7349 | 7349 | 3265 E Meridian Loop, Wasilla, AK 99654, USA | 61.5884294 | -149.3588151 | 1 | RANGE_INTERPOLATED | 25038 | MAPLE SPRINGS OF WASILLA | 3265 E MERIDIAN LOOP | WASILLA | AK | 99654 | 9078411217 | 170 | Matanuska-Susitna | For profit - Corporation | 67 | 15.2 | Medicare and Medicaid | false | MAPLE SPRINGS OF WASILLA SNF HOLDINGS LLC | 07/23/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 07/22/2019 | . | . | . | . | . | . | . | . | . | 1 | 2 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||||||||||
8187 | 8187 | 4356 24th Street Rd, Greeley, CO 80634, USA | 40.396826 | -104.7481153 | 1 | ROOFTOP | 65431 | CENTER AT CENTERPLACE LLC, THE | 4356 24TH ST RD | GREELEY | CO | 80634 | 9707027400 | 610 | Weld | For profit - Limited Liability company | 54 | Medicare | false | CENTER AT CENTERPLACE, LLC | 10/17/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 09/26/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
8379 | 8379 | 6100 Arrowhead Dr, Osage Beach, MO 65065, USA | 38.1219085 | -92.6953317 | 1 | ROOFTOP | 265876 | ARROWHEAD SENIOR LIVING COMMUNITY | 6100 ARROWHEAD DRIVE | OSAGE BEACH | MO | 65065 | 5733027111 | 140 | Camden | For profit - Limited Liability company | 80 | 21.8 | Medicare and Medicaid | false | ARROWHEAD RETIREMENT OPERATIONS LLC | 04/12/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3.17438 | 0.90225 | 1.5023 | 2.40455 | 5.57892 | 0.11131 | 1.94239 | 0.85191 | 0.45994 | 3.25424 | 04/12/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
9224 | 9224 | 3421 Story Rd W, Irving, TX 75038, USA | 32.8715582 | -96.9932719 | 1 | ROOFTOP | 676464 | LAS BRISAS REHABILITATION AND WELLNESS SUITES | 3421 W STORY RD | IRVING | TX | 75038 | 8322854798 | 390 | Dallas | For profit - Corporation | 128 | 46.8 | Medicare and Medicaid | false | IRVING LONG TERM CARE LLC | 03/06/2019 | false | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.26955 | 1.37879 | 0.50264 | 1.88142 | 4.15098 | 0.01373 | 2.18339 | 0.91783 | 0.50261 | 3.60383 | 03/05/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
9759 | 9759 | 6975 Graphics Way, Lewis Center, OH 43035, USA | 40.1887853 | -83.0222383 | 1 | RANGE_INTERPOLATED | 366472 | CAPRI GARDENS | 6975 GRAPHICS WAY | LEWIS CENTER | OH | 43035 | 7409010754 | 210 | Delaware | For profit - Corporation | 50 | Medicare and Medicaid | false | CARDINAL DELAWARE INC | 10/01/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 10/01/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
10158 | 10158 | Eagle Butte, SD 57625, USA | 44.9886537 | -101.2224805 | 1 | APPROXIMATE | 43A138 | MEDICINE WHEEL VILLAGE | 24266 AIRPORT ROAD PO BOX 880 | EAGLE BUTTE | SD | 57625 | 6059648155 | 200 | Dewey | Non profit - Other | 50 | 22.8 | Medicaid | false | Legal Business Name Not Available | 02/05/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4.00312 | 1.3967 | 1.38696 | 2.78366 | 6.78678 | 0 | 1.75731 | 0.62804 | 0.28224 | 2.66759 | 02/05/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
10541 | 10541 | 13600 Birdcall Ln, Cypress, TX 77429, USA | 29.9524436 | -95.6288139 | 1 | ROOFTOP | 676467 | CYPRESS CREEK REHABILITATION AND HEALTHCARE CENTER | 13600 BIRDCALL LANE | CYPRESS | TX | 77429 | 5124382630 | 610 | Harris | For profit - Individual | 122 | Medicare and Medicaid | false | NWH REHAB LLC | 08/22/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 08/22/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
11747 | 11747 | 701 Butler Blvd, Dimmitt, TX 79027, USA | 34.5412931 | -102.3238318 | 1 | ROOFTOP | 676461 | CASTRO COUNTY HOSPITAL DISTRICT DBA COUNTRY VIEW L | 701 BUTLER BLVD. | DIMMITT | TX | 79027 | 5124382630 | 270 | Castro | Government - Hospital district | 40 | 19.4 | Medicare and Medicaid | false | CASTRO COUNTY HOSPITAL DISTRICT | 04/18/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 4.96221 | 2.21952 | 1.06927 | 3.28879 | 8.25101 | 0.0397 | 1.93451 | 0.74778 | 0.38238 | 3.06467 | 04/18/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
12157 | 12157 | 5280 SW 157th Ave, Miami, FL 33185, USA | 25.7025198 | -80.4467755 | 1 | ROOFTOP | 686123 | KENDALL LAKES HEALTH AND REHABILITATION CENTER | 5280 SW 157 AVENUE | MIAMI | FL | 33185 | 7864337400 | 120 | Miami-Dade | For profit - Corporation | 150 | 100.5 | Medicare and Medicaid | false | LA MER NH LLC | 05/29/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.4198 | 0.66675 | 0.56965 | 1.2364 | 3.6562 | 0.13303 | 2.26796 | 0.84492 | 0.39244 | 3.50532 | 05/29/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
12345 | 12345 | S Hwy 501, Marion, SC 29571, USA | 34.1615973 | -79.39602219999999 | 1 | GEOMETRIC_CENTER | 425416 | SENIOR CARE OF MARION | 2770 S HIGHWAY 501 | MARION | SC | 29571 | 8555738466 | 330 | Marion | For profit - Partnership | 95 | Medicare | false | SENIOR CARE OF MARION LLC | 10/10/2019 | false | false | false | false | Family | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 10/10/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
12763 | 12763 | 201 Nelson Ave, Farmington, NM 87401, USA | 36.7248998 | -108.2207629 | 1 | ROOFTOP | 325133 | WELBROOK SENIOR LIVING, LLC | 201 NELSON AVENUE | FARMINGTON | NM | 87401 | 5056754545 | 220 | San Juan | For profit - Limited Liability company | 50 | Medicare | false | WELBROOK SENIOR LIVING FARMINGTON LLC | 09/16/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 09/16/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
14256 | 14256 | 19279 McKay Dr, Humble, TX 77338, USA | 29.9975359 | -95.2776516 | 1 | ROOFTOP | 676463 | CRIMSON HEIGHTS HEALTH & WELLNESS | 19279 MCKAY DR. | HUMBLE | TX | 77338 | 5124382630 | 610 | Harris | For profit - Corporation | 95 | 44.8 | Medicare and Medicaid | false | MCKAY HEALTH CARE LLC | 04/17/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2.48326 | 1.1354 | 0.29972 | 1.43512 | 3.91838 | 0.01652 | 2.07672 | 0.87031 | 0.44788 | 3.3949 | 04/17/2019 | . | . | . | . | . | . | . | . | . | 0 | 2 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||||||||
14373 | 14373 | 14041 Cottingham Rd, Pearland, TX 77581, USA | 29.600774 | -95.3408833 | 1 | ROOFTOP | 45F886 | RICHARD A. ANDERSON (STATE OF TEXAS VETERANS LAND | 14041 COTTINGHAM ROAD | HOUSTON | TX | 77048 | 2108285686 | 610 | Harris | Government - State | 2 | Medicaid | false | Legal Business Name Not Available | 11/05/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 11/05/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
15257 | 15257 | 1400 Liberty, Midtown Ave, Mt Pleasant, SC 29464, USA | 32.8125724 | -79.8401718 | 1 | GEOMETRIC_CENTER | 425417 | SHEM CREEK NURSING AND REHAB | 1400 LIBERTY MIDTOWN DRIVE, SUITE 420 | MOUNT PLEASANT | SC | 29464 | 8439362801 | 90 | Charleston | For profit - Limited Liability company | 40 | Medicare | false | SOUTH BAY AT MT PLEASANT LLC | 11/05/2019 | true | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 11/05/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
15429 | 15429 | 750 Hwy 352, Mesquite, TX 75149, USA | 32.7721202 | -96.5722369 | 1 | ROOFTOP | 676466 | CHEYENNE MEDICAL LODGE | 750 HIGHWAY 352 | MESQUITE | TX | 75149 | 5124382630 | 390 | Dallas | For profit - Corporation | 139 | Medicare and Medicaid | false | FOURSQUARE TEXAS 16 LLC | 08/28/2019 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 08/28/2019 | . | . | . | . | . | . | . | . | . | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||||||||||||||||||
15438 | 15438 | 4588 Wesley Woods Blvd, New Albany, OH 43054, USA | 40.0749599 | -82.8526526 | 1 | ROOFTOP | 366470 | WESLEY WOODS AT NEW ALBANY | 4588 WESLEY WOODS BLVD | NEW ALBANY | OH | 43054 | 6146564100 | 250 | Franklin | Non profit - Corporation | 16 | 8.6 | Medicare and Medicaid | false | WESLEY WOODS AT NEW ALBANY | 02/07/2019 | true | false | false | false | None | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3.39987 | 1.01072 | 2.39206 | 3.40277 | 6.80265 | 0.05651 | 2.27985 | 0.90782 | 0.39234 | 3.58001 | 02/07/2019 | . | . | . | . | . | . | . | . | . | 0 | 1 | 0 | 0.00 | 0 | 0 | 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 );