nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
21 rows where Health Inspection Rating = 4 and Rating Cycle 3 Number of Complaint Health Deficiencies = 7
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Legal Business Name, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, QM Rating, 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, 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 Total Health Score, 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 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
287 | 287 | 4720 23RD AVENUE MISSOULA, MT 59803 | 46.827591 | -114.035396 | 0 | 275027 | HILLSIDE HEALTH & REHABILITATION | 4720 23RD AVENUE | MISSOULA | MT | 59803 | 4062515100 | 310 | Missoula | For profit - Partnership | 95 | 64.4 | Medicare and Medicaid | false | HILLSIDE HEALTH CARE CENTER, LLC | 03/02/1971 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 4 | 3 | 3 | 2.25499 | 0.26611 | 0.65127 | 0.91738 | 3.17237 | 0.03066 | 1.92475 | 0.73713 | 0.35084 | 3.01272 | 2.43493 | 0.27145 | 0.69869 | 3.37659 | 12/13/2018 | 2 | 2 | 0 | 24 | 1 | 0 | 24 | 08/17/2017 | 3 | 2 | 1 | 36 | 1 | 0 | 36 | 2016-07-07 | 11 | 4 | 7 | 1 | 72 | 0 | 72 | 36 | 0 | 6 | 1 | 3060.00 | 0 | 1 | 4720 23RD AVENUE MISSOULA, MT 59803 (46.827591, -114.035396) | 02/01/2020 | |||||||||||
300 | 300 | 1095 MEDICAL PARK DR GRAND RAPIDS, MI 49506 | 42.942952 | -85.557428 | 0 | 235366 | METRON OF FOREST HILLS | 1095 MEDICAL PARK DR | GRAND RAPIDS | MI | 49506 | 6169497220 | 400 | Kent | For profit - Corporation | 58 | 57.2 | Medicare and Medicaid | false | CASCADE CARE CENTER, INC | 09/01/1978 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 4 | 4 | 2.20722 | 0.63146 | 0.76365 | 1.39511 | 3.60233 | 0.01775 | 1.85391 | 0.65632 | 0.30246 | 2.81269 | 2.47442 | 0.72346 | 0.95029 | 4.10691 | 01/17/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 11/16/2017 | 9 | 7 | 2 | 64 | 1 | 0 | 64 | 2016-10-26 | 16 | 9 | 7 | 1 | 100 | 0 | 100 | 46 | 10 | 5 | 1 | 17005.00 | 0 | 1 | 1095 MEDICAL PARK DR GRAND RAPIDS, MI 49506 (42.942952, -85.557428) | 02/01/2020 | |||||||||||
2444 | 2444 | 6305 CORTEZ RD W BRADENTON, FL 34210 | 27.462525 | -82.624886 | 0 | 106017 | BRADENTON HEALTH CARE | 6305 CORTEZ RD W | BRADENTON | FL | 34210 | 9417613499 | 400 | Manatee | For profit - Limited Liability company | 105 | 98.3 | Medicare and Medicaid | false | 6305 CORTEZ ROAD WEST OPERATIONS LLC | 12/09/1999 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 3 | 2.54803 | 0.66614 | 0.80584 | 1.47198 | 4.02001 | 0.07684 | 2.16982 | 0.80237 | 0.42186 | 3.39405 | 2.44061 | 0.62427 | 0.71896 | 3.79806 | 08/23/2019 | 5 | 4 | 1 | 24 | 1 | 0 | 24 | 11/08/2018 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 2017-08-04 | 7 | 0 | 7 | 0 | 28 | 0 | 28 | 18 | 0 | 11 | 1 | 1363.00 | 0 | 1 | 6305 CORTEZ RD W BRADENTON, FL 34210 (27.462525, -82.624886) | 02/01/2020 | |||||||||||
2516 | 2516 | 19 GENERAL MOORE WAY ELLSWORTH, ME 04605 | 44.546623 | -68.425491 | 0 | 205145 | SEAPORT VILLAGE HEALTHCARE | 19 GENERAL MOORE WAY | ELLSWORTH | ME | 4605 | 2076679336 | 40 | Hancock | For profit - Corporation | 61 | 57.5 | Medicare and Medicaid | false | SEAPORT VILLAGE SKILLED NURSING CENTER LLC | 03/01/1994 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 2.75377 | 0.74513 | 0.86171 | 1.60684 | 4.36061 | 0.12414 | 2.08125 | 0.72 | 0.32111 | 3.12236 | 2.74991 | 0.77818 | 1.01006 | 4.47834 | 04/03/2019 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 03/21/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-05-04 | 7 | 7 | 7 | 1 | 36 | 0 | 36 | 12 | 2 | 1 | 0 | 0.00 | 0 | 0 | 19 GENERAL MOORE WAY ELLSWORTH, ME 04605 (44.546623, -68.425491) | 02/01/2020 | |||||||||||
3219 | 3219 | 3636 NORTH RIDGE RD WICHITA, KS 67205 | 37.749425 | -97.426269 | 0 | 175539 | VIA CHRISTI VILLAGE RIDGE | 3636 NORTH RIDGE RD BLDG 400 | WICHITA | KS | 67205 | 3164627502 | 860 | Sedgwick | Non profit - Corporation | 80 | 67.7 | Medicare and Medicaid | false | CORNERSTONE ASSISTED LIVING INC | 09/05/2013 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 5 | 5 | 2.18754 | 0.90565 | 1.20236 | 2.10801 | 4.29555 | 0.12048 | 2.19583 | 0.726 | 0.33663 | 3.25846 | 2.07049 | 0.93801 | 1.34437 | 4.22727 | 05/20/2019 | 7 | 4 | 3 | 32 | 1 | 0 | 32 | 06/19/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2016-05-17 | 13 | 6 | 7 | 1 | 108 | 0 | 108 | 35.333 | 0 | 3 | 2 | 46940.00 | 0 | 2 | 3636 NORTH RIDGE RD WICHITA, KS 67205 (37.749425, -97.426269) | 02/01/2020 | |||||||||||
4249 | 4249 | 2810 SOUTH JACKSON AVENUE JOPLIN, MO 64804 | 37.059352 | -94.523147 | 0 | 265853 | JOPLIN GARDENS | 2810 SOUTH JACKSON AVENUE | JOPLIN | MO | 64804 | 4175720041 | 480 | Jasper | For profit - Limited Liability company | 92 | 77.6 | Medicare and Medicaid | false | N & R OF JOPLIN LLC | 12/14/2015 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 2 | 4 | 3 | 2 | 2.22974 | 1.17817 | 0.31568 | 1.49385 | 3.72359 | 0.12288 | 1.88002 | 0.71878 | 0.34407 | 2.94288 | 2.46494 | 1.23252 | 0.34532 | 4.05735 | 10/18/2019 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 12/13/2018 | 5 | 3 | 2 | 20 | 1 | 0 | 20 | 2017-11-02 | 10 | 3 | 7 | 1 | 88 | 0 | 88 | 29.333 | 0 | 5 | 1 | 8125.00 | 0 | 1 | 2810 SOUTH JACKSON AVENUE JOPLIN, MO 64804 (37.059352, -94.523147) | 02/01/2020 | |||||||||||
5382 | 5382 | 512 ROCKWELL DRIVE OKOLONA, MS 38860 | 34.002835 | -88.75706 | 0 | 25A162 | SHEARER-RICHARDSON MEMORIAL NURSING HOME | 512 ROCKWELL DRIVE / PO BOX 420 | OKOLONA | MS | 38860 | 6624475463 | 80 | Chickasaw | Government - City/county | 73 | 69.7 | Medicaid | false | Legal Business Name Not Available | 02/02/1975 | false | false | false | false | Resident | Yes | 4 | 4 | 1 | 1 | 2 | 5 | 5 | 2.67824 | 0.32638 | 1.08179 | 1.40817 | 4.0864 | 0.03789 | 1.80154 | 0.63685 | 0.28041 | 2.7188 | 3.08974 | 0.38536 | 1.45204 | 4.81967 | 07/26/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 09/06/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-05-11 | 11 | 4 | 7 | 1 | 56 | 0 | 56 | 14.667 | 1 | 1 | 0 | 0.00 | 0 | 0 | 512 ROCKWELL DRIVE OKOLONA, MS 38860 (34.002835, -88.75706) | 02/01/2020 | |||||||||||
5416 | 5416 | 1162 S DORA ST UKIAH, CA 95482 | 39.135241 | -123.209479 | 0 | 55853 | REDWOOD COVE HEALTHCARE CENTER | 1162 S DORA ST. | UKIAH | CA | 95482 | 7074621436 | 330 | Mendocino | For profit - Limited Liability company | 68 | 47.1 | Medicare and Medicaid | false | NIGHTSHADE HOLDINGS, LLC | 09/01/1968 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 2 | 2.87921 | 1.22736 | 0.38096 | 1.60832 | 4.48753 | 0.21381 | 2.16812 | 0.69718 | 0.34501 | 3.21031 | 2.75998 | 1.32376 | 0.4156 | 4.48242 | 08/22/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 07/16/2018 | 2 | 1 | 1 | 12 | 1 | 0 | 12 | 2017-04-17 | 17 | 11 | 7 | 1 | 152 | 0 | 152 | 29.333 | 4 | 4 | 1 | 2013.00 | 0 | 1 | 1162 S DORA ST UKIAH, CA 95482 (39.135241, -123.209479) | 02/01/2020 | |||||||||||
5470 | 5470 | 4000 RIVER CRESCENT DRIVE ANNAPOLIS, MD 21401 | 38.960914 | -76.558618 | 0 | 215174 | GINGER COVE | 4000 RIVER CRESCENT DRIVE | ANNAPOLIS | MD | 21401 | 4102667300 | 10 | Anne Arundel | Non profit - Corporation | 55 | 45.9 | Medicare | false | ANNAPOLIS LIFE CARE, INC. | 09/16/1988 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 2.97839 | 1.03908 | 0.98078 | 2.01986 | 4.99826 | 0.05029 | 2.30426 | 0.72095 | 0.33876 | 3.36398 | 2.68638 | 1.08374 | 1.08969 | 4.76451 | 06/07/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 02/09/2018 | 8 | 8 | 0 | 36 | 1 | 0 | 36 | 2016-11-04 | 15 | 8 | 7 | 1 | 104 | 0 | 104 | 33.333 | 5 | 0 | 0 | 0.00 | 0 | 0 | 4000 RIVER CRESCENT DRIVE ANNAPOLIS, MD 21401 (38.960914, -76.558618) | 02/01/2020 | |||||||||||
6374 | 6374 | 9730 PRAIRIE LAKES BLVD EAST NOBLESVILLE, IN 46060 | 39.997817 | -85.99555 | 0 | 155779 | PRAIRIE LAKES HEALTH CAMPUS | 9730 PRAIRIE LAKES BLVD EAST | NOBLESVILLE | IN | 46060 | 3177703644 | 280 | Hamilton | For profit - Corporation | 61 | 52.8 | Medicare and Medicaid | false | HANCOCK REGIONAL HOSPITAL | 06/22/2010 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 5 | 3 | 4 | 2.00281 | 0.85475 | 0.96247 | 1.81722 | 3.82003 | 0.08069 | 2.30898 | 0.8092 | 0.39134 | 3.50951 | 1.80275 | 0.79426 | 0.9257 | 3.49038 | 10/15/2019 | 7 | 6 | 1 | 28 | 1 | 0 | 28 | 10/10/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2018-01-09 | 12 | 5 | 7 | 1 | 56 | 0 | 56 | 27.333 | 0 | 3 | 0 | 0.00 | 0 | 0 | 9730 PRAIRIE LAKES BLVD EAST NOBLESVILLE, IN 46060 (39.997817, -85.99555) | 02/01/2020 | |||||||||||
6745 | 6745 | 2732 NORTH HAMPDEN COURT CHICAGO, IL 60614 | 41.931911 | -87.642214 | 0 | 145875 | WARREN BARR LINCOLN PARK | 2732 NORTH HAMPDEN COURT | CHICAGO | IL | 60614 | 7732486000 | 141 | Cook | For profit - Limited Liability company | 109 | 82.3 | Medicare and Medicaid | false | LINCOLN PARK SKILLED NURSING FACILITY LLC | 07/01/1996 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 2 | 3 | 1.96931 | 0.7003 | 0.75498 | 1.45529 | 3.4246 | 0.09593 | 2.31581 | 0.87943 | 0.46884 | 3.66408 | 1.76737 | 0.59878 | 0.6061 | 2.99707 | 10/17/2019 | 8 | 6 | 2 | 32 | 1 | 0 | 32 | 10/25/2018 | 6 | 6 | 1 | 28 | 1 | 0 | 28 | 2017-11-17 | 10 | 3 | 7 | 1 | 56 | 0 | 56 | 34.667 | 1 | 10 | 1 | 6500.00 | 0 | 1 | 2732 NORTH HAMPDEN COURT CHICAGO, IL 60614 (41.931911, -87.642214) | 02/01/2020 | |||||||||||
8335 | 8335 | 502 NORTH STATE STREET FRANKLIN GROVE, IL 61031 | 41.847045 | -89.303324 | 0 | 145200 | FRANKLIN GROVE LIVING AND REHAB | 502 NORTH STATE STREET | FRANKLIN GROVE | IL | 61031 | 8154562374 | 600 | Lee | For profit - Corporation | 132 | 82.4 | Medicare and Medicaid | false | FRANKLIN GROVE LIVING & REHABILITATION CENTER, LLC | 12/01/1975 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 4 | 5 | 3 | 3 | 2.28143 | 0.61456 | 0.51078 | 1.12535 | 3.40677 | 0.06661 | 2.34502 | 0.76487 | 0.34777 | 3.45766 | 2.02197 | 0.60418 | 0.5528 | 3.15947 | 07/18/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 01/10/2019 | 7 | 3 | 4 | 24 | 1 | 0 | 24 | 2018-01-11 | 17 | 10 | 7 | 1 | 96 | 0 | 96 | 32 | 2 | 9 | 1 | 8125.00 | 0 | 1 | 502 NORTH STATE STREET FRANKLIN GROVE, IL 61031 (41.847045, -89.303324) | 02/01/2020 | |||||||||||
8580 | 8580 | 12340 QUIVIRA ROAD OVERLAND PARK, KS 66213 | 38.904751 | -94.723811 | 0 | 175549 | STRATFORD COMMONS REHAB & HEALTH CARE CENTER | 12340 QUIVIRA ROAD | OVERLAND PARK | KS | 66213 | 9138510215 | 450 | Johnson | For profit - Corporation | 45 | 42.3 | Medicare and Medicaid | false | STRATFORD COMMONS REHABILITATION & HEALTH CARE CENTER LLC | 11/24/2015 | false | false | false | false | Both | Yes | 4 | 4 | 3 | 1 | 4 | 4 | 4 | 2.1018 | 0.88055 | 1.15591 | 2.03646 | 4.13825 | 0.31089 | 2.02167 | 0.8673 | 0.4511 | 3.34007 | 2.16071 | 0.76343 | 0.96446 | 3.97297 | 08/22/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 08/09/2018 | 6 | 6 | 6 | 32 | 1 | 0 | 32 | 2017-02-21 | 8 | 8 | 7 | 1 | 56 | 0 | 56 | 26 | 0 | 3 | 0 | 0.00 | 0 | 0 | 12340 QUIVIRA ROAD OVERLAND PARK, KS 66213 (38.904751, -94.723811) | 02/01/2020 | |||||||||||
8766 | 8766 | 5905 SE POWELL VALLEY RD GRESHAM, OR 97080 | 45.488245 | -122.373495 | 0 | 385015 | REGENCY GRESHAM NURSING & REHAB CENTER | 5905 SE POWELL VALLEY RD | GRESHAM | OR | 97080 | 5036651151 | 250 | Multnomah | For profit - Corporation | 128 | 84.4 | Medicare and Medicaid | false | REGENCY GRESHAM NURSING & REHABILITATION CENTER, LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 2 | 3.21138 | 0.8044 | 0.44275 | 1.24715 | 4.45853 | 0.06411 | 1.9812 | 0.73503 | 0.3404 | 3.05664 | 3.36883 | 0.82291 | 0.48954 | 4.67737 | 05/06/2019 | 7 | 7 | 2 | 28 | 1 | 0 | 28 | 10/06/2017 | 6 | 2 | 4 | 28 | 1 | 0 | 28 | 2016-08-16 | 11 | 4 | 7 | 1 | 64 | 0 | 64 | 34 | 4 | 9 | 0 | 0.00 | 0 | 0 | 5905 SE POWELL VALLEY RD GRESHAM, OR 97080 (45.488245, -122.373495) | 02/01/2020 | |||||||||||
10280 | 10280 | 2884 NORTH ROAD RUNNER PARKWAY LAS CRUCES, NM 88011 | 32.355071 | -106.754005 | 0 | 325111 | VILLAGE AT NORTHRISE (THE) - DESERT WILLOW I | 2884 NORTH ROAD RUNNER PARKWAY | LAS CRUCES | NM | 88011 | 5755221110 | 60 | Dona Ana | For profit - Limited Liability company | 30 | 24.2 | Medicare | false | PEAK MEDICAL ASSISTED LIVING LLC | 01/08/2001 | false | false | false | false | Resident | Yes | 5 | 4 | 4 | 2 | 4 | 5 | 5 | 2.92941 | 1.26453 | 1.82769 | 3.09223 | 6.02163 | 0.2694 | 2.14253 | 1.01955 | 0.61954 | 3.78162 | 2.84164 | 0.93262 | 1.11036 | 5.1061 | 09/09/2019 | 11 | 11 | 0 | 72 | 1 | 0 | 72 | 08/10/2018 | 11 | 10 | 1 | 64 | 1 | 0 | 64 | 2017-08-25 | 13 | 6 | 7 | 1 | 136 | 0 | 136 | 80 | 0 | 2 | 1 | 4026.00 | 0 | 1 | 2884 NORTH ROAD RUNNER PARKWAY LAS CRUCES, NM 88011 (32.355071, -106.754005) | 02/01/2020 | |||||||||||
10380 | 10380 | 15230 15th Ave NE, Shoreline, WA 98155, USA | 47.740384 | -122.3105044 | 1 | ROOFTOP | 50A260 | FIRCREST SCHOOL, PAT N | 15230-15TH NORTHEAST | SEATTLE | WA | 98155 | 2063613511 | 160 | King | Government - State | 92 | 109.2 | Medicaid | false | Legal Business Name Not Available | 05/13/1994 | false | false | false | false | None | Yes | 5 | 4 | 5 | 5 | 2 | 2 | 2 | 6 | 6 | 08/15/2019 | 8 | 4 | 5 | 52 | 1 | 0 | 52 | 05/17/2018 | 8 | 1 | 7 | 52 | 1 | 0 | 52 | 2017-04-14 | 8 | 3 | 7 | 1 | 80 | 0 | 80 | 56.667 | 5 | 9 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
10473 | 10473 | 1023 6TH AVE SW ALBANY, OR 97321 | 44.632167 | -123.115916 | 0 | 385107 | TIMBERVIEW CARE CENTER | 1023 6TH AVE SW | ALBANY | OR | 97321 | 5419268664 | 210 | Linn | For profit - Corporation | 67 | 57.8 | Medicare and Medicaid | false | PCI CARE VENTURE I INC. | 06/03/1983 | true | false | false | false | Resident | Yes | 4 | 4 | 3 | 4 | 3 | 3 | 3 | 2.86603 | 0.6853 | 0.52242 | 1.20772 | 4.07375 | 0.0914 | 2.23392 | 0.73752 | 0.34645 | 3.31788 | 2.66643 | 0.6987 | 0.56756 | 3.93719 | 05/31/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 12/19/2017 | 10 | 10 | 0 | 60 | 1 | 0 | 60 | 2016-09-12 | 9 | 2 | 7 | 1 | 36 | 0 | 36 | 28 | 0 | 4 | 0 | 0.00 | 0 | 0 | 1023 6TH AVE SW ALBANY, OR 97321 (44.632167, -123.115916) | 02/01/2020 | |||||||||||
10492 | 10492 | 4800 CLAGUE ROAD NORTH OLMSTED, OH 44070 | 41.419233 | -81.877383 | 0 | 366272 | O'NEILL HEALTHCARE NORTH OLMSTED | 4800 CLAGUE ROAD | NORTH OLMSTED | OH | 44070 | 4407349933 | 170 | Cuyahoga | For profit - Corporation | 56 | 49.3 | Medicare and Medicaid | false | WELLINGTON PLACE, LLC | 06/12/2003 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 1.94667 | 0.88982 | 0.74194 | 1.63176 | 3.57843 | 0.21802 | 2.21138 | 0.84215 | 0.43836 | 3.49189 | 1.82956 | 0.7945 | 0.63704 | 3.28613 | 04/11/2019 | 2 | 1 | 1 | 20 | 1 | 0 | 20 | 02/22/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-04-27 | 7 | 0 | 7 | 0 | 44 | 0 | 44 | 25.333 | 0 | 1 | 1 | 6500.00 | 0 | 1 | 4800 CLAGUE ROAD NORTH OLMSTED, OH 44070 (41.419233, -81.877383) | 02/01/2020 | |||||||||||
13432 | 13432 | 30 PORTER DRIVE MIDDLEBURY, VT 05753 | 43.999277 | -73.169206 | 0 | 475017 | HELEN PORTER HEALTHCARE & REHAB | 30 PORTER DRIVE | MIDDLEBURY | VT | 5753 | 8023884001 | 0 | Addison | Non profit - Corporation | 105 | 87.5 | Medicare and Medicaid | false | HELEN PORTER NURSING HOME, INC. | 06/26/1970 | false | false | false | false | Resident | Yes | 5 | 4 | 4 | 4 | 4 | 5 | 5 | 2.51891 | 0.91377 | 0.95995 | 1.87373 | 4.39263 | 0.19834 | 2.22405 | 0.69562 | 0.31774 | 3.2374 | 2.35388 | 0.98775 | 1.13714 | 4.35092 | 03/13/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 02/28/2018 | 4 | 4 | 0 | 8 | 1 | 0 | 8 | 2017-03-16 | 9 | 5 | 7 | 1 | 40 | 0 | 40 | 9.333 | 5 | 0 | 0 | 0.00 | 0 | 0 | 30 PORTER DRIVE MIDDLEBURY, VT 05753 (43.999277, -73.169206) | 02/01/2020 | |||||||||||
14379 | 14379 | 1301 NORTH 5TH STREET TONKAWA, OK 74653 | 36.693262 | -97.305776 | 0 | 375555 | WILLOW HAVEN NURSING HOME | 1301 NORTH 5TH STREET | TONKAWA | OK | 74653 | 5806282529 | 350 | Kay | For profit - Individual | 49 | 31.8 | Medicare and Medicaid | false | ILA SEATON, LLC | 09/26/2013 | false | false | false | false | Resident | Yes | 3 | 4 | 1 | 2 | 1 | 3 | 2 | 2.59798 | 0.76577 | 0.32935 | 1.09511 | 3.69309 | 0.01238 | 1.88571 | 0.6349 | 0.27771 | 2.79832 | 2.86336 | 0.90692 | 0.44638 | 4.232 | 11/18/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 08/29/2018 | 4 | 4 | 0 | 52 | 1 | 0 | 52 | 2017-06-15 | 8 | 7 | 7 | 1 | 48 | 0 | 48 | 25.333 | 0 | 1 | 1 | 7673.00 | 0 | 1 | 1301 NORTH 5TH STREET TONKAWA, OK 74653 (36.693262, -97.305776) | 02/01/2020 | |||||||||||
14607 | 14607 | 11959 APPLE VALLEY ROAD APPLE VALLEY, CA 92308 | 34.468125 | -117.242282 | 0 | 555476 | APPLE VALLEY POST ACUTE CENTER | 11959 APPLE VALLEY ROAD | APPLE VALLEY | CA | 92308 | 7602405051 | 460 | San Bernardino | For profit - Individual | 99 | 102.2 | Medicare and Medicaid | false | Legal Business Name Not Available | 09/26/1991 | false | false | false | false | Resident | Yes | 3 | 4 | 4 | 4 | 3 | 1 | 12 | 1 | 12 | 1.94409 | 1.08035 | 0.26303 | 1.34338 | 3.28747 | 0.12256 | 2.15252 | 0.91219 | 0.493 | 3.55771 | 1.87709 | 0.89055 | 0.20081 | 2.96308 | 12/24/2018 | 9 | 8 | 1 | 36 | 1 | 0 | 36 | 12/08/2017 | 3 | 0 | 3 | 28 | 0 | 0 | 28 | 2016-12-01 | 13 | 6 | 7 | 1 | 72 | 0 | 72 | 39.333 | 4 | 8 | 0 | 0.00 | 0 | 0 | 11959 APPLE VALLEY ROAD APPLE VALLEY, CA 92308 (34.468125, -117.242282) | 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 );