nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
34 rows where Health Inspection Rating = 4 and Number of Fines = 2
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, Continuing Care Retirement Community, With a Resident and Family Council, Overall 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 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 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33 | 33 | 304 W 7TH ST WELLSVILLE, KS 66092 | 38.716794 | -95.084996 | 0 | 175250 | WELLSVILLE MANOR | 304 W 7TH ST | WELLSVILLE | KS | 66092 | 7858834101 | 290 | Franklin | For profit - Individual | 60 | 54.4 | Medicare and Medicaid | false | MYSTERE LIVING & HEALTHCARE, INC. | 04/15/1993 | true | false | false | false | Resident | Yes | 4 | 4 | 5 | 5 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 08/22/2019 | 5 | 5 | 0 | 44 | 1 | 0 | 44 | 10/31/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-20 | 4 | 2 | 3 | 1 | 48 | 0 | 48 | 30 | 2 | 0 | 2 | 17544.00 | 0 | 2 | 304 W 7TH ST WELLSVILLE, KS 66092 (38.716794, -95.084996) | 02/01/2020 | |||||||||||||||||||||
665 | 665 | 30 PARK LANE EAST NEW MILFORD, CT 06776 | 41.597485 | -73.401891 | 0 | 75416 | CANDLEWOOD VALLEY HEALTH & REHABILITATION CENTER | 30 PARK LANE EAST | NEW MILFORD | CT | 6776 | 8603550971 | 20 | Litchfield | For profit - Limited Liability company | 148 | 135.8 | Medicare and Medicaid | false | NEW MILFORD REHABILITATION LLC | 06/16/1998 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 5 | 3 | 3 | 2.27929 | 0.96442 | 0.60543 | 1.56985 | 3.84915 | 0.08757 | 2.1414 | 0.70547 | 0.33673 | 3.18359 | 2.21217 | 1.02796 | 0.67673 | 3.87704 | 05/23/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 04/09/2018 | 2 | 2 | 0 | 24 | 1 | 0 | 24 | 2017-04-27 | 11 | 8 | 9 | 1 | 64 | 0 | 64 | 24.667 | 2 | 3 | 2 | 10466.00 | 0 | 2 | 30 PARK LANE EAST NEW MILFORD, CT 06776 (41.597485, -73.401891) | 02/01/2020 | |||||||||||
1625 | 1625 | 165 FAIRFIELD AVE WEST CALDWELL, NJ 07006 | 40.858442 | -74.286087 | 0 | 315247 | HACKENSACK MERIDIAN HEALTH WEST CALDWELL C | 165 FAIRFIELD AVE | WEST CALDWELL | NJ | 7006 | 9732261100 | 200 | Essex | For profit - Corporation | 180 | 139.7 | Medicare and Medicaid | false | ESSEX RESIDENTIAL CARE LLC | 10/01/1987 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 1.78754 | 0.41964 | 0.95334 | 1.37298 | 3.16052 | 0.11668 | 2.11394 | 0.69241 | 0.30655 | 3.11289 | 1.75744 | 0.45572 | 1.17053 | 3.25572 | 04/25/2019 | 1 | 1 | 0 | 4 | 0 | 0 | 4 | 02/23/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-01-13 | 5 | 4 | 1 | 1 | 20 | 0 | 20 | 10.667 | 0 | 3 | 2 | 70914.00 | 0 | 2 | 165 FAIRFIELD AVE WEST CALDWELL, NJ 07006 (40.858442, -74.286087) | 02/01/2020 | |||||||||||
1794 | 1794 | 2567 WEST GRAND BOULEVARD DETROIT, MI 48208 | 42.363583 | -83.091363 | 0 | 235498 | BOULEVARD TEMPLE CARE CENTER, LLC | 2567 WEST GRAND BOULEVARD | DETROIT | MI | 48208 | 3138955340 | 810 | Wayne | For profit - Corporation | 124 | 114.1 | Medicare and Medicaid | false | BOULEVARD TEMPLE CARE CENTER, LLC | 05/03/1990 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 3 | 3 | 2.42559 | 0.85251 | 0.55852 | 1.41103 | 3.83662 | 0 | 1.98678 | 0.70695 | 0.32265 | 3.01637 | 2.53737 | 0.90676 | 0.65154 | 4.07865 | 05/21/2019 | 4 | 3 | 1 | 20 | 1 | 0 | 20 | 03/13/2018 | 3 | 3 | 0 | 40 | 1 | 0 | 40 | 2017-02-15 | 11 | 10 | 1 | 1 | 84 | 0 | 84 | 37.333 | 4 | 6 | 2 | 29681.00 | 0 | 2 | 2567 WEST GRAND BOULEVARD DETROIT, MI 48208 (42.363583, -83.091363) | 02/01/2020 | |||||||||||
1900 | 1900 | 831 NORTH BATAVIA AVENUE BATAVIA, IL 60510 | 41.863276 | -88.313678 | 0 | 145409 | MICHAELSEN HEALTH CENTER | 831 NORTH BATAVIA AVENUE | BATAVIA | IL | 60510 | 6308794300 | 530 | Kane | Non profit - Church related | 99 | 81.8 | Medicare and Medicaid | false | COVENANT HEALTHCARE CENTER, INC. | 11/01/1980 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 2.62746 | 0.1744 | 1.20892 | 1.38333 | 4.01079 | 0.11024 | 2.14105 | 0.72055 | 0.3386 | 3.2002 | 2.5505 | 0.182 | 1.34384 | 4.01889 | 04/09/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 03/22/2018 | 8 | 4 | 4 | 64 | 1 | 0 | 64 | 2017-02-24 | 10 | 6 | 4 | 1 | 72 | 0 | 72 | 37.333 | 1 | 9 | 2 | 15300.00 | 0 | 2 | 831 NORTH BATAVIA AVENUE BATAVIA, IL 60510 (41.863276, -88.313678) | 02/01/2020 | |||||||||||
1929 | 1929 | 12856 DEAUVILLE DRIVE OMAHA, NE 68137 | 41.20249 | -96.113841 | 0 | 285098 | GOOD SAMARITAN SOCIETY - MILLARD | 12856 DEAUVILLE DRIVE | OMAHA | NE | 68137 | 4028952266 | 270 | Douglas | Non profit - Corporation | 106 | 82.1 | Medicare and Medicaid | false | THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY | 07/16/1990 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 3 | 4 | 4 | 2.29242 | 0.70625 | 0.62743 | 1.33369 | 3.62611 | 0.02175 | 2.0581 | 0.68799 | 0.29035 | 3.03645 | 2.31496 | 0.7719 | 0.81335 | 3.82938 | 08/06/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 04/24/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-02-21 | 11 | 9 | 11 | 1 | 84 | 0 | 84 | 19.333 | 2 | 2 | 2 | 10990.00 | 1 | 3 | 12856 DEAUVILLE DRIVE OMAHA, NE 68137 (41.20249, -96.113841) | 02/01/2020 | |||||||||||
2767 | 2767 | 2120 WEST WASHINGTON SPRINGFIELD, IL 62702 | 39.80136 | -89.691138 | 0 | 146139 | REGENCY CARE | 2120 WEST WASHINGTON | SPRINGFIELD | IL | 62702 | 2177934880 | 920 | Sangamon | For profit - Corporation | 99 | 67.6 | Medicare and Medicaid | false | RUTLEDGE-REGENCY OPERATIONS, LLC | 02/18/2010 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 5 | 2 | 4 | 4 | 2.70459 | 0.85036 | 0.76762 | 1.61798 | 4.32257 | 0.05353 | 2.26885 | 0.71267 | 0.31984 | 3.30136 | 2.47748 | 0.89722 | 0.90334 | 4.19857 | 03/18/2019 | 8 | 3 | 5 | 32 | 1 | 0 | 32 | 04/13/2018 | 6 | 5 | 1 | 40 | 1 | 0 | 40 | 2017-03-23 | 8 | 4 | 4 | 1 | 48 | 0 | 48 | 37.333 | 1 | 4 | 2 | 35470.00 | 0 | 2 | 2120 WEST WASHINGTON SPRINGFIELD, IL 62702 (39.80136, -89.691138) | 02/01/2020 | |||||||||||
3065 | 3065 | 7401 22 MILE ROAD SHELBY TOWNSHIP, MI 48317 | 42.655038 | -83.0393 | 0 | 235710 | REGENCY AT SHELBY TOWNSHIP | 7401 22 MILE ROAD | SHELBY TOWNSHIP | MI | 48317 | 5865805500 | 490 | Macomb | For profit - Corporation | 116 | 112.6 | Medicare and Medicaid | false | SHELBY TOWNSHIP CARE CENTER, LLC | 11/12/2015 | false | false | false | false | None | Yes | 4 | 4 | 4 | 4 | 5 | 3 | 3 | 1.68664 | 1.50445 | 0.50416 | 2.00861 | 3.69525 | 0.13382 | 2.05928 | 0.77563 | 0.36751 | 3.20242 | 1.70225 | 1.45849 | 0.51633 | 3.70014 | 12/10/2019 | 6 | 6 | 1 | 40 | 1 | 0 | 40 | 10/18/2018 | 7 | 7 | 6 | 28 | 1 | 0 | 28 | 2017-08-16 | 11 | 5 | 6 | 1 | 155 | 0 | 155 | 55.167 | 2 | 15 | 2 | 18775.00 | 0 | 2 | 7401 22 MILE ROAD SHELBY TOWNSHIP, MI 48317 (42.655038, -83.0393) | 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 | |||||||||||
3392 | 3392 | 2530 Solace Pl, Mountain View, CA 94040, USA | 37.3663584 | -122.0804703 | 1 | ROOFTOP | 55316 | MOUNTAIN VIEW HEALTHCARE CENTER | 2530 SOLACE PLACE | MOUNTAIN VIEW | CA | 94040 | 6509616161 | 530 | Santa Clara | For profit - Corporation | 138 | 95.1 | Medicare and Medicaid | false | PALMERO ENTERPRISES INC | 01/01/1967 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.39856 | 0.89439 | 0.87949 | 1.77388 | 4.17244 | 0.08697 | 2.11331 | 0.70649 | 0.34465 | 3.16445 | 2.35887 | 0.95193 | 0.96047 | 4.22809 | 01/29/2019 | 8 | 7 | 1 | 40 | 1 | 0 | 40 | 12/14/2017 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 2016-12-30 | 9 | 7 | 2 | 1 | 84 | 0 | 84 | 39.333 | 0 | 6 | 2 | 23813.00 | 0 | 2 | 02/01/2020 | |||||||||||
3790 | 3790 | 3000 LENORA CHURCH DRIVE SNELLVILLE, GA 30078 | 33.837228 | -84.008308 | 0 | 115643 | PARKSIDE POST ACUTE AND REHABILITATION | 3000 LENORA CHURCH DRIVE | SNELLVILLE | GA | 30078 | 7709722040 | 530 | Gwinnett | For profit - Limited Liability company | 167 | 152.7 | Medicare and Medicaid | false | LENORA CHURCH ROAD PROPERTY- SNF LLC | 08/01/1997 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 3 | 2 | 2 | 2 | 1.99225 | 1.09334 | 0.44044 | 1.53378 | 3.52604 | 0.08657 | 2.21954 | 0.78572 | 0.39837 | 3.40362 | 1.86551 | 1.04634 | 0.41614 | 3.32199 | 12/13/2018 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 11/16/2017 | 2 | 0 | 2 | 8 | 0 | 0 | 8 | 2016-10-07 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 8.667 | 0 | 1 | 2 | 61469.00 | 1 | 3 | 3000 LENORA CHURCH DRIVE SNELLVILLE, GA 30078 (33.837228, -84.008308) | 02/01/2020 | |||||||||||
4280 | 4280 | 3116 WILLIAMSON COUNTY PARKWAY MARION, IL 62959 | 37.750143 | -88.982944 | 0 | 145841 | PARKWAY MANOR | 3116 WILLIAMSON COUNTY PARKWAY | MARION | IL | 62959 | 6189938600 | 990 | Williamson | Non profit - Corporation | 131 | 103.7 | Medicare and Medicaid | false | UNLIMITED DEVELOPMENT, INC | 06/22/1995 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 3 | 3 | 2.94305 | 1.08256 | 0.72792 | 1.81048 | 4.75354 | 0.08545 | 2.3051 | 0.85873 | 0.41456 | 3.57839 | 2.65353 | 0.94794 | 0.66088 | 4.25973 | 03/22/2019 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 02/06/2018 | 6 | 4 | 2 | 36 | 1 | 0 | 36 | 2017-03-24 | 6 | 2 | 4 | 1 | 68 | 0 | 68 | 33.333 | 0 | 9 | 2 | 31000.00 | 0 | 2 | 3116 WILLIAMSON COUNTY PARKWAY MARION, IL 62959 (37.750143, -88.982944) | 02/01/2020 | |||||||||||
4758 | 4758 | 2309 S MILLER ST SHELBYVILLE, IN 46176 | 39.502516 | -85.787316 | 0 | 155022 | HERITAGE HOUSE OF SHELBYVILLE | 2309 S MILLER ST | SHELBYVILLE | IN | 46176 | 3173989781 | 720 | Shelby | Government - City/county | 141 | 67.9 | Medicare and Medicaid | false | MAJOR HOSPITAL | 01/01/1967 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 4 | 2 | 2 | 1.83484 | 0.7522 | 0.42036 | 1.17256 | 3.0074 | 0.04558 | 2.21118 | 0.77848 | 0.40084 | 3.3905 | 1.7246 | 0.72656 | 0.39472 | 2.84434 | 06/17/2019 | 7 | 6 | 1 | 28 | 1 | 0 | 28 | 05/04/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-05 | 6 | 4 | 2 | 1 | 44 | 0 | 44 | 25.333 | 2 | 5 | 2 | 26793.00 | 0 | 2 | 2309 S MILLER ST SHELBYVILLE, IN 46176 (39.502516, -85.787316) | 02/01/2020 | |||||||||||
4970 | 4970 | 3251 NETTIE ST BUTTE, MT 59701 | 45.990377 | -112.488108 | 0 | 275060 | COPPER RIDGE HEALTH AND REHABILITATION CENTER | 3251 NETTIE ST | BUTTE | MT | 59701 | 4067233225 | 460 | Silver Bow | For profit - Corporation | 186 | 66.8 | Medicare and Medicaid | false | COPPER RIDGE NURSING AND REHAB CENTER LLC | 12/01/1977 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 3 | 5 | 4 | 4 | 2.01437 | 0.72171 | 0.85886 | 1.58057 | 3.59494 | 0.13385 | 1.97563 | 0.79379 | 0.41227 | 3.18169 | 2.11909 | 0.68366 | 0.7841 | 3.62315 | 02/21/2019 | 4 | 2 | 2 | 32 | 1 | 0 | 32 | 12/20/2017 | 8 | 5 | 3 | 72 | 1 | 0 | 72 | 2017-01-11 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 43.333 | 0 | 5 | 2 | 45266.00 | 0 | 2 | 3251 NETTIE ST BUTTE, MT 59701 (45.990377, -112.488108) | 02/01/2020 | |||||||||||
5389 | 5389 | 509 NORTH HAYDEN AVENUE SALEM, KY 42078 | 37.27109 | -88.241043 | 0 | 185046 | SALEM SPRINGLAKE HEALTH & REHABILITATION CENTER | 509 NORTH HAYDEN AVENUE | SALEM | KY | 42078 | 2709884572 | 690 | Livingston | For profit - Corporation | 75 | 50.9 | Medicare and Medicaid | false | ORION SALEM LLC | 02/23/1967 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 1 | 5 | 2 | 3 | 1.92148 | 0.61156 | 0.79308 | 1.40464 | 3.32612 | 0.46187 | 2.16614 | 0.86049 | 0.46742 | 3.49405 | 1.84359 | 0.53441 | 0.63862 | 3.05254 | 01/11/2019 | 1 | 0 | 1 | 4 | 1 | 0 | 4 | 11/16/2017 | 3 | 0 | 3 | 16 | 0 | 0 | 16 | 2016-10-20 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 8 | 0 | 4 | 2 | 15103.00 | 0 | 2 | 509 NORTH HAYDEN AVENUE SALEM, KY 42078 (37.27109, -88.241043) | 02/01/2020 | |||||||||||
6773 | 6773 | 2155 PFINGSTEN ROAD NORTHBROOK, IL 60062 | 42.11383 | -87.848911 | 0 | 145527 | BRANDEL HEALTH AND REHAB | 2155 PFINGSTEN ROAD | NORTHBROOK | IL | 60062 | 8474806350 | 141 | Cook | Non profit - Church related | 102 | 80.5 | Medicare and Medicaid | false | COVENANT HEALTHCARE CENTER, INC. | 10/08/1985 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 4 | 5 | 5 | 2.83969 | 0.38393 | 1.15912 | 1.54305 | 4.38275 | 0 | 2.17849 | 0.6753 | 0.31396 | 3.16775 | 2.70914 | 0.42751 | 1.38957 | 4.43658 | 04/25/2019 | 5 | 5 | 0 | 36 | 1 | 0 | 36 | 06/27/2018 | 1 | 1 | 0 | 20 | 1 | 0 | 20 | 2017-05-25 | 3 | 3 | 0 | 1 | 40 | 0 | 40 | 31.333 | 0 | 0 | 2 | 20104.00 | 0 | 2 | 2155 PFINGSTEN ROAD NORTHBROOK, IL 60062 (42.11383, -87.848911) | 02/01/2020 | |||||||||||
7827 | 7827 | 1915 E REZANOF DRIVE KODIAK, AK 99615 | 57.800835 | -152.373943 | 0 | 25030 | PROVIDENCE KODIAK ISLAND MED LTC | 1915 E REZANOF DRIVE | KODIAK | AK | 99615 | 9074867800 | 150 | Kodiak Island Borough | Non profit - Corporation | 22 | 20.4 | Medicare and Medicaid | false | Legal Business Name Not Available | 09/20/1994 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 2 | 2 | 2 | 6 | 6 | 03/15/2019 | 2 | 2 | 0 | 20 | 1 | 0 | 20 | 05/18/2018 | 6 | 6 | 0 | 40 | 1 | 0 | 40 | 2017-03-20 | 22 | 22 | 0 | 1 | 191 | 0 | 191 | 55.167 | 0 | 0 | 2 | 26312.00 | 0 | 2 | 1915 E REZANOF DRIVE KODIAK, AK 99615 (57.800835, -152.373943) | 02/01/2020 | |||||||||||||||||||||||
7829 | 7829 | 6450 OLD TUSCALOOSA HIGHWAY MC CALLA, AL 35111 | 33.322518 | -87.033532 | 0 | 15015 | PLANTATION MANOR NURSING HOME | 6450 OLD TUSCALOOSA HIGHWAY P O BOX 97 | MC CALLA | AL | 35111 | 2054776161 | 360 | Jefferson | For profit - Individual | 103 | 93.8 | Medicare and Medicaid | false | C & G HEALTHCARE SERVICES, INC. | 07/01/1971 | true | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 4 | 3 | 2 | 2.3804 | 0.97941 | 0.29997 | 1.27937 | 3.65977 | 0 | 1.88743 | 0.64577 | 0.29924 | 2.83243 | 2.62118 | 1.14043 | 0.3773 | 4.14331 | 05/02/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 04/19/2018 | 7 | 7 | 0 | 28 | 1 | 0 | 28 | 2017-03-09 | 2 | 2 | 0 | 1 | 16 | 0 | 16 | 14 | 0 | 0 | 2 | 29611.00 | 0 | 2 | 6450 OLD TUSCALOOSA HIGHWAY MC CALLA, AL 35111 (33.322518, -87.033532) | 02/01/2020 | |||||||||||
8044 | 8044 | 200 NJ-10, Succasunna, NJ 07876, USA | 40.8693137 | -74.6409124 | 1 | ROOFTOP | 315057 | MERRY HEART NURSING HOME | 200 RT 10 WEST | SUCCASUNNA | NJ | 7876 | 9735844000 | 300 | Morris | For profit - Partnership | 113 | 102.2 | Medicare and Medicaid | false | MERRY HEART NURSING & CONV CENT | 01/19/1967 | false | false | false | false | Resident | Yes | 4 | 4 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 1.60519 | 0.47022 | 0.4727 | 0.94291 | 2.54811 | 0.16499 | 2.27804 | 0.70838 | 0.3456 | 3.33203 | 1.46447 | 0.49913 | 0.5148 | 2.45224 | 11/12/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 11/05/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-07-26 | 2 | 2 | 0 | 1 | 24 | 0 | 24 | 10 | 0 | 0 | 2 | 13528.00 | 0 | 2 | 02/01/2020 | |||||||||
8158 | 8158 | 377 WESTRIDGE BLVD GREENWOOD, IN 46142 | 39.618366 | -86.146024 | 0 | 155193 | GREENWOOD HEALTHCARE CENTER | 377 WESTRIDGE BLVD | GREENWOOD | IN | 46142 | 3178884948 | 400 | Johnson | Non profit - Other | 185 | 166.2 | Medicare and Medicaid | false | HANCOCK REGIONAL HOSPITAL | 09/25/1980 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 2.14512 | 0.61181 | 0.98594 | 1.59775 | 3.74287 | 0.06149 | 2.23253 | 0.89757 | 0.50846 | 3.63855 | 1.99697 | 0.51255 | 0.72984 | 3.29859 | 06/19/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 04/06/2018 | 3 | 3 | 0 | 28 | 1 | 0 | 28 | 2017-03-01 | 6 | 3 | 6 | 1 | 40 | 0 | 40 | 22 | 0 | 6 | 2 | 25532.00 | 0 | 2 | 377 WESTRIDGE BLVD GREENWOOD, IN 46142 (39.618366, -86.146024) | 02/01/2020 | |||||||||||
8221 | 8221 | 3312 WOODLEY ROAD MONTGOMERY, AL 36116 | 32.318021 | -86.261591 | 0 | 15037 | CRIMSON HEALTH AND REHAB, LLC | 3312 WOODLEY ROAD | MONTGOMERY | AL | 36116 | 3342882780 | 500 | Montgomery | For profit - Corporation | 105 | 44.9 | Medicare and Medicaid | false | Legal Business Name Not Available | 01/01/1970 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 2 | 4 | 3 | 3 | 1.97642 | 0.62396 | 0.51766 | 1.14163 | 3.11805 | 0.06965 | 1.82809 | 0.69331 | 0.30667 | 2.82807 | 2.24698 | 0.67673 | 0.63534 | 3.53547 | 10/10/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 10/11/2018 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2018-04-06 | 6 | 6 | 0 | 1 | 28 | 0 | 28 | 9.333 | 0 | 0 | 2 | 33899.00 | 0 | 2 | 3312 WOODLEY ROAD MONTGOMERY, AL 36116 (32.318021, -86.261591) | 02/01/2020 | |||||||||||
8535 | 8535 | 2385 SPRINGFIELD AVENUE VAUXHALL, NJ 07088 | 40.717751 | -74.288026 | 0 | 315283 | SOUTH MOUNTAIN HC | 2385 SPRINGFIELD AVENUE | VAUXHALL | NJ | 7088 | 9086883400 | 370 | Union | For profit - Partnership | 195 | 181.9 | Medicare and Medicaid | false | SOUTH MOUNTAIN HEALTHCARE AND REHABILITATION CENTER | 08/03/1989 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 4 | 5 | 4 | 4 | 2.25475 | 0.66139 | 0.95699 | 1.61838 | 3.87313 | 0.1046 | 2.16891 | 0.72938 | 0.34422 | 3.2425 | 2.16059 | 0.68185 | 1.04642 | 3.83032 | 12/11/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 01/25/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2018-01-25 | 9 | 8 | 1 | 1 | 32 | 0 | 32 | 7.333 | 0 | 3 | 2 | 26878.00 | 0 | 2 | 2385 SPRINGFIELD AVENUE VAUXHALL, NJ 07088 (40.717751, -74.288026) | 02/01/2020 | |||||||||||
9090 | 9090 | 1505 SOUTHEAST CARPENTER ROAD LACEY, WA 98503 | 47.032835 | -122.791466 | 0 | 505254 | ROO-LAN HEALTHCARE CENTER | 1505 SOUTHEAST CARPENTER ROAD | LACEY | WA | 98503 | 3604911765 | 330 | Thurston | For profit - Corporation | 96 | 78.3 | Medicare and Medicaid | false | LACEY NURSING CENTER, INC. | 04/01/1980 | true | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 5 | 3 | 3 | 2.34371 | 0.87257 | 0.44201 | 1.31458 | 3.65829 | 0.0079 | 2.22748 | 0.67212 | 0.2879 | 3.1875 | 2.18678 | 0.9762 | 0.57786 | 3.68028 | 02/13/2019 | 17 | 16 | 1 | 100 | 1 | 0 | 100 | 03/23/2018 | 6 | 6 | 1 | 36 | 1 | 0 | 36 | 2017-04-27 | 8 | 5 | 3 | 1 | 56 | 0 | 56 | 71.333 | 2 | 2 | 2 | 8937.00 | 0 | 2 | 1505 SOUTHEAST CARPENTER ROAD LACEY, WA 98503 (47.032835, -122.791466) | 02/01/2020 | |||||||||||
9818 | 9818 | 1515 SOUTH SUNSET AVE ROSWELL, NM 88203 | 33.374556 | -104.541138 | 0 | 325117 | SUNSET VILLA CARE CENTER | 1515 SOUTH SUNSET AVE | ROSWELL | NM | 88203 | 5756237097 | 20 | Chaves | For profit - Corporation | 52 | 44 | Medicare and Medicaid | false | THI OF NEW MEXICO AT SUNSET VILLA, LLC | 04/23/2004 | false | false | false | false | Both | Yes | 3 | 4 | 1 | 2 | 1 | 3 | 4 | 1.92601 | 0.68763 | 0.80397 | 1.4916 | 3.41761 | 0.18979 | 2.12947 | 0.72669 | 0.3472 | 3.20336 | 1.87976 | 0.71153 | 0.87154 | 3.42113 | 07/18/2019 | 14 | 13 | 1 | 116 | 1 | 0 | 116 | 10/16/2018 | 7 | 7 | 0 | 72 | 1 | 0 | 72 | 2017-08-31 | 3 | 1 | 2 | 1 | 36 | 0 | 36 | 88 | 1 | 2 | 2 | 21532.00 | 1 | 3 | 1515 SOUTH SUNSET AVE ROSWELL, NM 88203 (33.374556, -104.541138) | 02/01/2020 | |||||||||||
10051 | 10051 | 206 SOUTH TENTH AVENUE YAKIMA, WA 98902 | 46.595344 | -120.521393 | 0 | 505010 | GARDEN VILLAGE | 206 SOUTH TENTH AVENUE | YAKIMA | WA | 98902 | 5094534854 | 380 | Yakima | Non profit - Corporation | 101 | 95.8 | Medicare and Medicaid | false | GARDEN VILLAGE | 01/01/1967 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 2.72383 | 0.56931 | 0.45819 | 1.0275 | 3.75133 | 0.02534 | 2.21218 | 0.73402 | 0.39169 | 3.3379 | 2.55903 | 0.5832 | 0.44029 | 3.60384 | 07/19/2019 | 9 | 8 | 1 | 36 | 1 | 0 | 36 | 06/14/2018 | 20 | 11 | 13 | 136 | 1 | 0 | 136 | 2017-05-11 | 18 | 14 | 4 | 1 | 116 | 0 | 116 | 82.667 | 14 | 5 | 2 | 15513.00 | 0 | 2 | 206 SOUTH TENTH AVENUE YAKIMA, WA 98902 (46.595344, -120.521393) | 02/01/2020 | |||||||||||
10853 | 10853 | 3625 EAST B STREET TACOMA, WA 98404 | 47.225422 | -122.429736 | 0 | 505264 | AVAMERE AT PACIFIC RIDGE | 3625 EAST B STREET | TACOMA | WA | 98404 | 2534752507 | 260 | Pierce | For profit - Corporation | 102 | 95.5 | Medicare and Medicaid | false | TACOMA REHAB, LLC | 04/01/1982 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 2 | 3 | 3 | 2.29339 | 0.79748 | 0.58294 | 1.38042 | 3.67381 | 0.0083 | 2.07353 | 0.72912 | 0.31435 | 3.11701 | 2.2987 | 0.82244 | 0.69796 | 3.77947 | 01/11/2019 | 14 | 13 | 2 | 64 | 1 | 0 | 64 | 01/17/2018 | 15 | 14 | 1 | 92 | 1 | 0 | 92 | 2017-04-25 | 10 | 7 | 3 | 1 | 60 | 0 | 60 | 72.667 | 8 | 1 | 2 | 25428.00 | 0 | 2 | 3625 EAST B STREET TACOMA, WA 98404 (47.225422, -122.429736) | 02/01/2020 | |||||||||||
11141 | 11141 | 1758 HILLWOOD DRIVE KNOXVILLE, TN 37920 | 35.95814 | -83.891578 | 0 | 445476 | ISLAND HOME PARK HEALTH AND REHAB | 1758 HILLWOOD DRIVE | KNOXVILLE | TN | 37920 | 8655739621 | 460 | Knox | Non profit - Corporation | 95 | 83.2 | Medicare and Medicaid | false | HILLCREST HEALTHCARE COMMUNITIES INC | 04/01/2004 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 4 | 3 | 2 | 2 | 2.14537 | 0.95686 | 0.45895 | 1.41582 | 3.56119 | 0.02396 | 2.18005 | 0.7543 | 0.3591 | 3.29345 | 2.04527 | 0.95387 | 0.48105 | 3.46734 | 07/31/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 08/08/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-06-07 | 3 | 3 | 0 | 2 | 28 | 14 | 42 | 7 | 2 | 1 | 2 | 6900.00 | 0 | 2 | 1758 HILLWOOD DRIVE KNOXVILLE, TN 37920 (35.95814, -83.891578) | 02/01/2020 | |||||||||||
11326 | 11326 | 800 NORTH MEDCALF MONTESANO, WA 98563 | 46.988672 | -123.585824 | 0 | 505503 | MONTESANO HEALTH & REHABILITATION | 800 NORTH MEDCALF | MONTESANO | WA | 98563 | 3602492273 | 130 | Grays Harbor | For profit - Corporation | 94 | 81.8 | Medicare and Medicaid | false | 800 MEDCALF LANE NORTH OPERATIONS LLC | 07/23/1997 | false | false | false | false | None | Yes | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 1.98273 | 0.83766 | 0.55113 | 1.3888 | 3.37152 | 0.1395 | 2.14767 | 0.7914 | 0.39123 | 3.3303 | 1.91872 | 0.7959 | 0.53022 | 3.24635 | 03/25/2019 | 9 | 0 | 9 | 36 | 1 | 0 | 36 | 04/22/2018 | 7 | 5 | 2 | 32 | 1 | 0 | 32 | 2017-05-12 | 17 | 7 | 12 | 1 | 120 | 0 | 120 | 48.667 | 6 | 16 | 2 | 30907.00 | 0 | 2 | 800 NORTH MEDCALF MONTESANO, WA 98563 (46.988672, -123.585824) | 02/01/2020 | |||||||||||
11389 | 11389 | 14820 EAST FOURTH SPOKANE, WA 99216 | 47.653403 | -117.205272 | 0 | 505383 | SULLIVAN PARK CARE CENTER | 14820 EAST FOURTH | SPOKANE | WA | 99216 | 5099221644 | 310 | Spokane | For profit - Corporation | 125 | 110.1 | Medicare and Medicaid | false | CARE CENTER (SULLIVAN PARK), INC. | 06/12/1991 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.2474 | 0.71265 | 0.86809 | 1.58073 | 3.82814 | 0.09085 | 2.17209 | 0.76771 | 0.33648 | 3.27628 | 2.15039 | 0.69801 | 0.97103 | 3.74679 | 04/18/2019 | 10 | 6 | 4 | 56 | 1 | 0 | 56 | 02/08/2018 | 12 | 6 | 9 | 92 | 1 | 0 | 92 | 2016-12-20 | 11 | 11 | 0 | 1 | 40 | 0 | 40 | 65.333 | 4 | 6 | 2 | 16633.00 | 0 | 2 | 14820 EAST FOURTH SPOKANE, WA 99216 (47.653403, -117.205272) | 02/01/2020 | |||||||||||
12181 | 12181 | 1841 EAST UPRIVER DRIVE SPOKANE, WA 99207 | 47.676935 | -117.382301 | 0 | 505291 | RIVERVIEW LUTHERAN RETIREMENT COMMUNITY OF SPOKANE | 1841 EAST UPRIVER DRIVE | SPOKANE | WA | 99207 | 5094894466 | 310 | Spokane | Non profit - Corporation | 75 | 49.8 | Medicare and Medicaid | false | RIVERVIEW LUTHERAN RETIREMENT COMMUNITY OF SPOKANE | 02/25/1985 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.81832 | 0.40495 | 0.99094 | 1.39589 | 4.2142 | 0.47805 | 2.37267 | 0.80487 | 0.40094 | 3.57848 | 2.4687 | 0.37832 | 0.93025 | 3.77633 | 10/11/2019 | 18 | 16 | 18 | 112 | 1 | 0 | 112 | 09/11/2018 | 9 | 7 | 3 | 40 | 1 | 0 | 40 | 2017-08-16 | 10 | 8 | 2 | 1 | 84 | 0 | 84 | 83.333 | 4 | 6 | 2 | 13402.00 | 0 | 2 | 1841 EAST UPRIVER DRIVE SPOKANE, WA 99207 (47.676935, -117.382301) | 02/01/2020 | |||||||||||
12265 | 12265 | 4416 SOUTH BRANDON STREET SEATTLE, WA 98118 | 47.553396 | -122.278727 | 0 | 505453 | KIN ON HEALTH CARE CENTER | 4416 SOUTH BRANDON STREET | SEATTLE | WA | 98118 | 2067213630 | 160 | King | Non profit - Corporation | 100 | 96.2 | Medicare and Medicaid | false | KIN ON HEALTH CARE CENTER | 01/01/1992 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 4 | 4 | 5 | 2.12713 | 0.45941 | 0.99821 | 1.45762 | 3.58475 | 0.01754 | 2.45863 | 0.77182 | 0.28898 | 3.51942 | 1.79811 | 0.44758 | 1.30014 | 3.26618 | 06/26/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 05/04/2018 | 13 | 6 | 7 | 108 | 1 | 0 | 108 | 2017-03-16 | 21 | 16 | 5 | 1 | 180 | 0 | 180 | 72 | 2 | 7 | 2 | 108938.00 | 0 | 2 | 4416 SOUTH BRANDON STREET SEATTLE, WA 98118 (47.553396, -122.278727) | 02/01/2020 | |||||||||||
13394 | 13394 | 14500 FRUITVALE AVENUE SARATOGA, CA 95070 | 37.257078 | -122.01367 | 0 | 555343 | SARATOGA RETIREMENT COMMUNITY HEALTH CENTER | 14500 FRUITVALE AVENUE | SARATOGA | CA | 95070 | 4087417100 | 530 | Santa Clara | Non profit - Corporation | 94 | 71.9 | Medicare and Medicaid | false | ODD FELLOWS HOME OF CALIFORNIA | 11/01/1988 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 3 | 2 | 3.27689 | 1.35002 | 0.40221 | 1.75224 | 5.02913 | 0.08218 | 2.34068 | 0.70072 | 0.3256 | 3.36699 | 2.90962 | 1.44871 | 0.46495 | 4.78965 | 01/04/2019 | 3 | 2 | 1 | 32 | 1 | 0 | 32 | 01/25/2018 | 5 | 3 | 2 | 52 | 1 | 0 | 52 | 2017-01-25 | 3 | 2 | 1 | 1 | 12 | 0 | 12 | 35.333 | 3 | 0 | 2 | 20296.00 | 0 | 2 | 14500 FRUITVALE AVENUE SARATOGA, CA 95070 (37.257078, -122.01367) | 02/01/2020 | |||||||||||
14015 | 14015 | 3400 KNIGHTON ROAD REDDING, CA 96002 | 40.506978 | -122.312388 | 0 | 555891 | VETERANS HOME OF CALIFORNIA - REDDING | 3400 KNIGHTON ROAD | REDDING | CA | 96002 | 5302243300 | 550 | Shasta | Government - State | 60 | 56.7 | Medicare and Medicaid | false | DEPARTMENT OF VETERANS AFFAIRS OF THE STATE OF CALIFORNIA | 04/29/2015 | true | false | false | false | Both | Yes | 5 | 4 | 4 | 4 | 2 | 5 | 5 | 3.42748 | 0.80355 | 1.92906 | 2.7326 | 6.16009 | 0.12658 | 1.77817 | 0.61209 | 0.27785 | 2.66811 | 4.00607 | 0.98714 | 2.61314 | 7.40348 | 05/16/2019 | 10 | 7 | 3 | 48 | 1 | 0 | 48 | 05/18/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-05-19 | 5 | 3 | 2 | 1 | 56 | 0 | 56 | 36 | 5 | 1 | 2 | 14097.00 | 0 | 2 | 3400 KNIGHTON ROAD REDDING, CA 96002 (40.506978, -122.312388) | 02/01/2020 | |||||||||||
14578 | 14578 | 4070 HAMILTON MASON ROAD HAMILTON, OH 45011 | 39.375817 | -84.482491 | 0 | 366159 | BIRCHWOOD CARE CENTER | 4070 HAMILTON MASON ROAD | HAMILTON | OH | 45011 | 5138683300 | 80 | Butler | For profit - Corporation | 75 | 67 | Medicare and Medicaid | false | HILLANDALE NURSING CARE, LTD. | 06/05/1998 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 3 | 3 | 3 | 1.97292 | 1.01974 | 0.5456 | 1.56534 | 3.53826 | 0.00912 | 2.15987 | 0.72341 | 0.35499 | 3.23828 | 1.89844 | 1.05995 | 0.57847 | 3.50371 | 10/03/2019 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 08/23/2018 | 8 | 8 | 0 | 40 | 1 | 0 | 40 | 2017-06-08 | 5 | 4 | 1 | 1 | 48 | 0 | 48 | 21.333 | 1 | 0 | 2 | 31933.00 | 0 | 2 | 4070 HAMILTON MASON ROAD HAMILTON, OH 45011 (39.375817, -84.482491) | 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 );