nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
34 rows where Overall Rating = 4 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-04-06
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, 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 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 Total Health 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
883 | 883 | 1101 SNOWS MILL AVENUE TUSCALOOSA, AL 35406 | 33.228213 | -87.56034 | 0 | 15371 | HERITAGE HEALTH CARE & REHAB INC | 1101 SNOWS MILL AVENUE | TUSCALOOSA | AL | 35406 | 2057595179 | 620 | Tuscaloosa | For profit - Individual | 216 | 162.9 | Medicare and Medicaid | false | HERITAGE HEALTH CARE & REHAB, INC. | 08/01/1977 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 5 | 3 | 4 | 3 | 2.56397 | 0.913 | 0.50359 | 1.41659 | 3.98056 | 0.00666 | 1.90049 | 0.64241 | 0.27168 | 2.81458 | 2.80391 | 1.06868 | 0.69766 | 4.53507 | 05/16/2019 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 05/24/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-06 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 20 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1101 SNOWS MILL AVENUE TUSCALOOSA, AL 35406 (33.228213, -87.56034) | 02/01/2020 | |||||||||||
1353 | 1353 | 13714 NORTH PLAZA DEL RIO BLVD PEORIA, AZ 85381 | 33.608627 | -112.257628 | 0 | 35256 | FREEDOM PLAZA CARE CENTER | 13714 NORTH PLAZA DEL RIO BLVD | PEORIA | AZ | 85381 | 6238156100 | 60 | Maricopa | For profit - Partnership | 111 | 57.8 | Medicare | false | FREEDOM PLAZA OPERATING COMPANY LLC | 12/15/1999 | true | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 5 | 5 | 2.87789 | 1.26959 | 1.42964 | 2.69923 | 5.57712 | 0.22725 | 2.14496 | 0.79899 | 0.43122 | 3.37518 | 2.7885 | 1.19483 | 1.24783 | 5.29867 | 08/07/2019 | 2 | 2 | 1 | 24 | 1 | 0 | 24 | 05/17/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-04-06 | 1 | 0 | 1 | 0 | 4 | 0 | 4 | 18 | 1 | 1 | 0 | 0.00 | 0 | 0 | 13714 NORTH PLAZA DEL RIO BLVD PEORIA, AZ 85381 (33.608627, -112.257628) | 02/01/2020 | |||||||||||
2130 | 2130 | 260 WEST WALNUT STREET SYLACAUGA, AL 35150 | 33.163735 | -86.254687 | 0 | 15010 | COOSA VALLEY HEALTHCARE CENTER | 260 WEST WALNUT STREET | SYLACAUGA | AL | 35150 | 2562495604 | 600 | Talladega | For profit - Corporation | 85 | 75 | Medicare and Medicaid | false | COOSA VALLEY HEALTHCARE CENTER LLC | 01/01/1967 | false | false | false | false | Both | Yes | 4 | 3 | 4 | 3 | 5 | 5 | 5 | 3.35145 | 0.8938 | 1.10351 | 1.99732 | 5.34877 | 0.01884 | 1.95955 | 0.70609 | 0.3093 | 2.97494 | 3.5546 | 0.95184 | 1.34286 | 5.76538 | 06/13/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 06/07/2018 | 4 | 4 | 0 | 32 | 1 | 0 | 32 | 2017-04-06 | 7 | 7 | 0 | 1 | 36 | 0 | 36 | 18.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 260 WEST WALNUT STREET SYLACAUGA, AL 35150 (33.163735, -86.254687) | 02/01/2020 | |||||||||||
2227 | 2227 | 240 CHURCH ST NEWINGTON, CT 06111 | 41.665919 | -72.739363 | 0 | 75286 | NEWINGTON RAPID RECOVERY REHAB CENTER | 240 CHURCH ST | NEWINGTON | CT | 6111 | 8606672256 | 10 | Hartford | For profit - Corporation | 180 | 158.8 | Medicare and Medicaid | false | SENIOR PHILANTHROPY OF NEWINGTON LLC | 02/01/1979 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 3 | 1.94898 | 0.69943 | 0.60275 | 1.30217 | 3.25115 | 0.03269 | 1.96911 | 0.67898 | 0.31993 | 2.96802 | 2.05709 | 0.77459 | 0.7091 | 3.51256 | 05/02/2019 | 15 | 6 | 9 | 48 | 1 | 0 | 48 | 03/21/2018 | 7 | 7 | 0 | 28 | 1 | 0 | 28 | 2017-04-06 | 4 | 3 | 1 | 1 | 20 | 0 | 20 | 36.667 | 2 | 3 | 0 | 0.00 | 0 | 0 | 240 CHURCH ST NEWINGTON, CT 06111 (41.665919, -72.739363) | 02/01/2020 | |||||||||||
2814 | 2814 | 2641 SOUTH C ST OXNARD, CA 93033 | 34.175581 | -119.181216 | 0 | 55597 | MAYWOOD ACRES HEALTHCARE | 2641 SOUTH C ST | OXNARD | CA | 93033 | 8054877840 | 660 | Ventura | For profit - Corporation | 98 | 77.2 | Medicare and Medicaid | false | MILWOOD HEALTHCARE, INC | 01/01/1973 | false | false | false | false | Both | Yes | 4 | 3 | 4 | 5 | 3 | 4 | 4 | 2.53468 | 0.70461 | 0.65497 | 1.35958 | 3.89426 | 0.0704 | 2.01784 | 0.69062 | 0.31414 | 3.02261 | 2.61067 | 0.76717 | 0.78474 | 4.13139 | 02/21/2019 | 9 | 7 | 2 | 36 | 1 | 0 | 36 | 03/22/2018 | 18 | 18 | 0 | 80 | 1 | 0 | 80 | 2017-04-06 | 17 | 9 | 8 | 1 | 92 | 0 | 92 | 60 | 3 | 4 | 0 | 0.00 | 0 | 0 | 2641 SOUTH C ST OXNARD, CA 93033 (34.175581, -119.181216) | 02/01/2020 | |||||||||||
3619 | 3619 | 745 MAIN ST EAST HARTFORD, CT 06108 | 41.766505 | -72.64546 | 0 | 75257 | RIVERSIDE HEALTH & REHABILITAT | 745 MAIN ST | EAST HARTFORD | CT | 6108 | 8602892791 | 10 | Hartford | For profit - Corporation | 345 | 321.5 | Medicare and Medicaid | false | RIVERSIDE HEALTH CARE CENTER, INC. | 05/01/1976 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 2 | 2.04762 | 0.82546 | 0.36501 | 1.19047 | 3.23809 | 0.04194 | 2.01904 | 0.66112 | 0.30565 | 2.98581 | 2.10776 | 0.93886 | 0.44947 | 3.4776 | 05/02/2019 | 3 | 3 | 1 | 20 | 1 | 0 | 20 | 03/21/2018 | 14 | 10 | 8 | 64 | 1 | 0 | 64 | 2017-04-06 | 7 | 7 | 0 | 1 | 40 | 0 | 40 | 38 | 0 | 4 | 0 | 0.00 | 0 | 0 | 745 MAIN ST EAST HARTFORD, CT 06108 (41.766505, -72.64546) | 02/01/2020 | |||||||||||
3930 | 3930 | 16455 E Ave of the Fountains, Fountain Hills, AZ 85268, USA | 33.6083839 | -111.7276719 | 1 | ROOFTOP | 35260 | FOUNTAIN VIEW VILLAGE | 16455 EAST AVENUE OF THE FOUNTAINS | FOUNTAIN HILLS | AZ | 85268 | 4808364800 | 60 | Maricopa | For profit - Corporation | 48 | 31.4 | Medicare | false | SL FOUNTAIN VIEW VILLAGE LLC | 11/26/2001 | true | false | false | false | Resident | Yes | 4 | 4 | 4 | 2 | 4 | 4 | 4 | 1.95235 | 0.79566 | 1.34581 | 2.14147 | 4.09383 | 0.17767 | 2.18731 | 0.90465 | 0.5268 | 3.61876 | 1.85509 | 0.66135 | 0.96155 | 3.62763 | 07/25/2019 | 5 | 5 | 1 | 20 | 1 | 0 | 20 | 06/06/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-04-06 | 5 | 5 | 0 | 1 | 32 | 0 | 32 | 16.667 | 1 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
4248 | 4248 | 119 FAUST STREET SOUTHEAST PIERZ, MN 56364 | 45.978737 | -94.10005 | 0 | 245286 | PIERZ VILLA INC | 119 FAUST STREET SOUTHEAST | PIERZ | MN | 56364 | 3204686405 | 480 | Morrison | For profit - Corporation | 50 | 43.4 | Medicare and Medicaid | false | PIERZ VILLA, INC. | 08/01/1985 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 4 | 2 | 4 | 4 | 2.95833 | 0.43275 | 0.7647 | 1.19745 | 4.15578 | 0.03575 | 1.96712 | 0.64431 | 0.2892 | 2.90062 | 3.1256 | 0.50504 | 0.99525 | 4.59425 | 06/20/2019 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 05/23/2018 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 2017-04-06 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 24.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 119 FAUST STREET SOUTHEAST PIERZ, MN 56364 (45.978737, -94.10005) | 02/01/2020 | |||||||||||
4560 | 4560 | 208 W PROUT STREET HILL CITY, KS 67642 | 39.371793 | -99.843567 | 0 | inf | DAWSON PLACE | 208 W PROUT STREET | HILL CITY | KS | 67642 | 7854213414 | 320 | Graham | Non profit - Corporation | 36 | 35.2 | Medicaid | false | Legal Business Name Not Available | 07/06/1976 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 2 | 4 | 4 | 2.47394 | 0.46683 | 0.65017 | 1.117 | 3.59094 | 0.00705 | 1.81239 | 0.66705 | 0.30985 | 2.78928 | 2.83697 | 0.52624 | 0.78979 | 4.12828 | 07/09/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 10/25/2018 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 2017-04-06 | 12 | 12 | 0 | 1 | 68 | 0 | 68 | 25.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 208 W PROUT STREET HILL CITY, KS 67642 (39.371793, -99.843567) | 02/01/2020 | |||||||||||
5970 | 5970 | 910 SOUTH 40TH STREET OMAHA, NE 68105 | 41.250839 | -95.973372 | 0 | 285218 | AZRIA HEALTH MIDTOWN | 910 SOUTH 40TH STREET | OMAHA | NE | 68105 | 4023422015 | 270 | Douglas | For profit - Individual | 61 | 45.9 | Medicare and Medicaid | false | AZM LLC | 12/01/1997 | false | false | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 4 | 4 | 4 | 2.52242 | 0.61541 | 1.09732 | 1.71273 | 4.23515 | 0.1107 | 2.10181 | 0.81808 | 0.42227 | 3.34216 | 2.49425 | 0.56565 | 0.97808 | 4.06344 | 09/09/2019 | 8 | 6 | 2 | 40 | 0 | 0 | 40 | 06/12/2018 | 9 | 5 | 7 | 76 | 1 | 0 | 76 | 2017-04-06 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 47.333 | 2 | 6 | 0 | 0.00 | 0 | 0 | 910 SOUTH 40TH STREET OMAHA, NE 68105 (41.250839, -95.973372) | 02/01/2020 | |||||||||||
7209 | 7209 | 625 EAST MONROE STREET CUBA, IL 61427 | 40.48841 | -90.192034 | 0 | 146151 | CLAYBERG, THE | 625 EAST MONROE STREET | CUBA | IL | 61427 | 3097855012 | 370 | Fulton | Government - County | 49 | 47.4 | Medicare and Medicaid | false | COUNTY OF FULTON | 07/07/2011 | false | false | false | false | Both | Yes | 4 | 4 | 2 | 2 | 2 | 3 | 4 | 2.34536 | 0.56742 | 0.63048 | 1.1979 | 3.54326 | 0 | 2.12478 | 0.73815 | 0.32477 | 3.18769 | 2.2941 | 0.57802 | 0.73069 | 3.56435 | 03/27/2019 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 05/10/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-04-06 | 12 | 12 | 0 | 1 | 96 | 0 | 96 | 29.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 625 EAST MONROE STREET CUBA, IL 61427 (40.48841, -90.192034) | 02/01/2020 | |||||||||||
7241 | 7241 | 1012 RICHWOOD WAY LA GRANGE, KY 40031 | 38.392557 | -85.369235 | 0 | 185438 | RICHWOOD NURSING & REHAB | 1012 RICHWOOD WAY | LA GRANGE | KY | 40031 | 5022223186 | 920 | Oldham | For profit - Limited Liability company | 120 | 101.3 | Medicare and Medicaid | false | RICHWOODIDENCE OPCO LLC | 01/12/1998 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 1.81782 | 1.15222 | 0.47157 | 1.62378 | 3.44161 | 0.11792 | 2.0875 | 0.81654 | 0.43165 | 3.33569 | 1.80984 | 1.06106 | 0.41119 | 3.30848 | 07/26/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 05/17/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-04-06 | 3 | 3 | 0 | 1 | 32 | 0 | 32 | 12.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1012 RICHWOOD WAY LA GRANGE, KY 40031 (38.392557, -85.369235) | 02/01/2020 | |||||||||||
7338 | 7338 | 16412 LOS GATOS BOULEVARD LOS GATOS, CA 95032 | 37.230412 | -121.965447 | 0 | 55798 | VASONA CREEK HEALTHCARE CENTER | 16412 LOS GATOS BOULEVARD | LOS GATOS | CA | 95032 | 4083562191 | 530 | Santa Clara | For profit - Partnership | 148 | 141.1 | Medicare and Medicaid | false | GOLDEN OAKS HOLDINGS, LLC | 03/01/1980 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 5 | 4 | 4 | 4 | 2.34503 | 1.16831 | 0.91797 | 2.08628 | 4.4313 | 0.26939 | 2.10664 | 0.82125 | 0.39293 | 3.32081 | 2.31352 | 1.06971 | 0.87932 | 4.27898 | 05/10/2019 | 18 | 14 | 4 | 68 | 1 | 0 | 68 | 04/19/2018 | 12 | 9 | 3 | 44 | 1 | 0 | 44 | 2017-04-06 | 17 | 16 | 1 | 1 | 72 | 0 | 72 | 60.667 | 0 | 7 | 0 | 0.00 | 0 | 0 | 16412 LOS GATOS BOULEVARD LOS GATOS, CA 95032 (37.230412, -121.965447) | 02/01/2020 | |||||||||||
7355 | 7355 | 4801 SE COVE RD STUART, FL 34997 | 27.140768 | -80.189473 | 0 | 105509 | SALERNO BAY HEALTH AND REHABILITATION CENTER | 4801 SE COVE RD | STUART | FL | 34997 | 7722869440 | 420 | Martin | For profit - Corporation | 120 | 118.5 | Medicare and Medicaid | false | SF SALERNO LLC | 07/17/1985 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 3 | 3 | 3 | 2.44921 | 0.87345 | 0.52515 | 1.39861 | 3.84782 | 0.05498 | 2.1727 | 0.71072 | 0.3302 | 3.21362 | 2.34284 | 0.92411 | 0.5986 | 3.83948 | 06/13/2019 | 7 | 7 | 0 | 28 | 1 | 0 | 28 | 05/04/2018 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 2017-04-06 | 3 | 3 | 0 | 1 | 20 | 0 | 20 | 18.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 4801 SE COVE RD STUART, FL 34997 (27.140768, -80.189473) | 02/01/2020 | |||||||||||
7526 | 7526 | 1400 LINDBERG DRIVE SLIDELL, LA 70458 | 30.281541 | -89.754008 | 0 | 195177 | TRINITY NEUROLOGIC REHABILITATION CENTER | 1400 LINDBERG DRIVE | SLIDELL | LA | 70458 | 9856414985 | 510 | St. Tammany | For profit - Corporation | 110 | 100.1 | Medicare and Medicaid | false | TRINITY NEUROLOGIC REHABILITATION CENTER IGH, LLC | 01/15/1985 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 1 | 2 | 2 | 2.24397 | 1.5655 | 0.55047 | 2.11597 | 4.35994 | 0.05457 | 2.09115 | 0.80375 | 0.65129 | 3.54619 | 2.23022 | 1.46459 | 0.31812 | 3.9425 | 05/22/2019 | 3 | 2 | 1 | 12 | 1 | 0 | 12 | 04/26/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-04-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 1 | 0 | 0.00 | 0 | 0 | 1400 LINDBERG DRIVE SLIDELL, LA 70458 (30.281541, -89.754008) | 02/01/2020 | |||||||||||
8358 | 8358 | 120 SPRING STREET NEWNAN, GA 30263 | 33.37432 | -84.808784 | 0 | 115528 | AVALON HEALTH AND REHABILITATION | 120 SPRING STREET | NEWNAN | GA | 30263 | 7702531475 | 320 | Coweta | For profit - Corporation | 90 | 80.5 | Medicare and Medicaid | false | AVALON HEALTH CARE LLC | 07/01/1992 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 2 | 2.32301 | 1.00791 | 0.31128 | 1.31919 | 3.6422 | 0.04502 | 2.32625 | 0.68905 | 0.30397 | 3.31927 | 2.07544 | 1.09991 | 0.38543 | 3.51864 | 08/15/2019 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 05/31/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-04-06 | 5 | 5 | 5 | 1 | 40 | 0 | 40 | 13.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 120 SPRING STREET NEWNAN, GA 30263 (33.37432, -84.808784) | 02/01/2020 | |||||||||||
8626 | 8626 | 2065 LYON STREET GASTONIA, NC 28052 | 35.233776 | -81.20547 | 0 | 345457 | BELAIRE HEALTH CARE CENTER | 2065 LYON STREET | GASTONIA | NC | 28052 | 7048677300 | 350 | Gaston | For profit - Corporation | 80 | 70.8 | Medicare and Medicaid | false | BELAIRE HEALTH CARE CENTER, INC. | 05/13/1994 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 3 | 3 | 3 | 2.07298 | 1.02801 | 0.58342 | 1.61144 | 3.68442 | 0.14191 | 2.08088 | 0.78951 | 0.38588 | 3.25626 | 2.07045 | 0.9791 | 0.56907 | 3.62829 | 04/11/2019 | 2 | 1 | 1 | 4 | 0 | 0 | 4 | 03/22/2018 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 2017-04-06 | 3 | 2 | 1 | 1 | 16 | 0 | 16 | 11.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 2065 LYON STREET GASTONIA, NC 28052 (35.233776, -81.20547) | 02/01/2020 | |||||||||||
9843 | 9843 | 1314 3RD STREET CORPUS CHRISTI, TX 78401 | 27.778437 | -97.396418 | 0 | 455359 | VISTA DEL MAR HEALTH & REHABILITATION | 1314 3RD STREET | CORPUS CHRISTI | TX | 78401 | 3618885511 | 830 | Nueces | For profit - Partnership | 114 | 50.9 | Medicare and Medicaid | false | CORPUS NURSING AND REHABILITATION LP | 07/24/1969 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 3 | 5 | 2 | 1 | 2.02339 | 1.53891 | 0.41766 | 1.95657 | 3.97996 | 0.02101 | 1.99761 | 0.81843 | 0.50391 | 3.31995 | 2.10516 | 1.41389 | 0.31196 | 3.84416 | 05/17/2019 | 6 | 4 | 2 | 32 | 1 | 0 | 32 | 04/19/2018 | 8 | 7 | 1 | 64 | 1 | 0 | 64 | 2017-04-06 | 16 | 13 | 11 | 1 | 108 | 0 | 108 | 55.333 | 5 | 6 | 1 | 26006.00 | 0 | 1 | 1314 3RD STREET CORPUS CHRISTI, TX 78401 (27.778437, -97.396418) | 02/01/2020 | |||||||||||
9930 | 9930 | 800 Ambrose Dr, Delphos, OH 45833, USA | 40.8514747 | -84.31491849999999 | 1 | ROOFTOP | 365405 | MEADOWS OF DELPHOS THE | 800 AMBOSE DRIVE | DELPHOS | OH | 45833 | 4196433161 | 820 | Van Wert | For profit - Limited Liability company | 54 | 44.9 | Medicare and Medicaid | false | TRILOGY HEALTHCARE OF ALLEN LLC | 01/09/1979 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 3 | 2 | 3 | 1.5984 | 0.8931 | 0.66181 | 1.55491 | 3.15331 | 0.05162 | 2.06212 | 0.84606 | 0.44001 | 3.34819 | 1.61097 | 0.79374 | 0.56611 | 3.02002 | 08/29/2019 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 06/28/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-04-06 | 4 | 4 | 0 | 1 | 16 | 0 | 16 | 20 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
10605 | 10605 | 402 GOLF VIEW LANE HIGHLAND HEIGHTS, OH 44143 | 41.560151 | -81.474255 | 0 | 366440 | HIGHLAND POINTE HEALTH & REHAB CENTER | 402 GOLF VIEW LANE | HIGHLAND HEIGHTS | OH | 44143 | 4404430900 | 170 | Cuyahoga | For profit - Corporation | 96 | 83.9 | Medicare and Medicaid | false | HIGH POINTE HEALTH & REHAB CENTER LLC | 02/13/2016 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 4 | 5 | 2 | 2 | 1.71581 | 0.96756 | 0.59609 | 1.56365 | 3.27946 | 0.05264 | 2.25667 | 0.89232 | 0.47662 | 3.6256 | 1.58022 | 0.81535 | 0.47073 | 2.90052 | 07/25/2019 | 3 | 3 | 2 | 12 | 1 | 0 | 12 | 06/07/2018 | 16 | 9 | 7 | 84 | 1 | 0 | 84 | 2017-04-06 | 3 | 2 | 1 | 1 | 12 | 0 | 12 | 36 | 0 | 5 | 0 | 0.00 | 0 | 0 | 402 GOLF VIEW LANE HIGHLAND HEIGHTS, OH 44143 (41.560151, -81.474255) | 02/01/2020 | |||||||||||
10755 | 10755 | 208 MAPLE ST LULING, TX 78648 | 29.672607 | -97.632235 | 0 | 675075 | DIVERSICARE OF LULING | 208 MAPLE ST | LULING | TX | 78648 | 8308755219 | 223 | Caldwell | For profit - Corporation | 60 | 35.2 | Medicare and Medicaid | false | DEWITT MEDICAL DISTRICT | 08/27/1992 | false | false | false | true | Resident | Yes | 4 | 4 | 3 | 2 | 3 | 3 | 3 | 1.40027 | 1.05236 | 0.66268 | 1.71504 | 3.11531 | 0 | 1.93661 | 0.78225 | 0.40417 | 3.12302 | 1.50275 | 1.01159 | 0.61712 | 3.19875 | 06/14/2019 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 05/31/2018 | 5 | 4 | 1 | 40 | 1 | 0 | 40 | 2017-04-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 208 MAPLE ST LULING, TX 78648 (29.672607, -97.632235) | 02/01/2020 | |||||||||||
11016 | 11016 | 1285 WEST A STREET KANNAPOLIS, NC 28081 | 35.513723 | -80.632173 | 0 | 345342 | BIG ELM RETIREMENT AND NURSING CENTERS | 1285 WEST A STREET | KANNAPOLIS | NC | 28081 | 7049320000 | 790 | Rowan | Non profit - Church related | 50 | 46.5 | Medicare and Medicaid | false | SENIOR VENTURES & MANAGEMENT INC | 01/01/1991 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 3 | 2 | 4 | 3 | 2.93716 | 1.06992 | 0.52215 | 1.59206 | 4.52922 | 0.09251 | 2.08354 | 0.76817 | 0.38577 | 3.23748 | 2.92982 | 1.04732 | 0.50944 | 4.4861 | 03/13/2019 | 5 | 5 | 1 | 16 | 1 | 0 | 16 | 03/15/2018 | 4 | 4 | 0 | 24 | 1 | 0 | 24 | 2017-04-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 0 | 2 | 0 | 0.00 | 0 | 0 | 1285 WEST A STREET KANNAPOLIS, NC 28081 (35.513723, -80.632173) | 02/01/2020 | |||||||||||
11524 | 11524 | 11902 RESOURCE PKWY HOUSTON, TX 77089 | 29.585839 | -95.209096 | 0 | 675819 | PARK MANOR OF SOUTH BELT | 11902 RESOURCE PKWY | HOUSTON | TX | 77089 | 2819226802 | 610 | Harris | Government - Hospital district | 120 | 107.9 | Medicare and Medicaid | false | WINNIE-STOWELL HOSPITAL DISTRICT | 01/07/2000 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 2 | 1.78399 | 0.85005 | 0.3381 | 1.18815 | 2.97214 | 0.04714 | 2.06809 | 0.77214 | 0.36803 | 3.20825 | 1.79283 | 0.82781 | 0.34578 | 2.97067 | 02/15/2019 | 5 | 3 | 2 | 28 | 1 | 0 | 28 | 03/09/2018 | 7 | 4 | 3 | 76 | 1 | 0 | 76 | 2017-04-06 | 5 | 5 | 0 | 1 | 64 | 0 | 64 | 50 | 0 | 4 | 1 | 8648.00 | 0 | 1 | 11902 RESOURCE PKWY HOUSTON, TX 77089 (29.585839, -95.209096) | 02/01/2020 | |||||||||||
11533 | 11533 | 100 VISTA DRIVE LISBON, OH 44432 | 40.782139 | -80.769139 | 0 | 366087 | VISTA CENTER, THE | 100 VISTA DRIVE | LISBON | OH | 44432 | 3304245852 | 140 | Columbiana | For profit - Corporation | 57 | 53.5 | Medicare and Medicaid | false | LISBON SKILLED NURSING AND RESIDENTIAL CARE LLC | 10/04/1996 | false | false | false | false | None | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 2 | 2.3098 | 0.87894 | 0.42968 | 1.30861 | 3.61842 | 0.02157 | 2.52129 | 0.86685 | 0.4508 | 3.83894 | 1.904 | 0.76243 | 0.35875 | 3.02246 | 08/22/2019 | 12 | 12 | 0 | 64 | 1 | 0 | 64 | 06/28/2018 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 2017-04-06 | 2 | 1 | 1 | 1 | 8 | 0 | 8 | 37.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 100 VISTA DRIVE LISBON, OH 44432 (40.782139, -80.769139) | 02/01/2020 | |||||||||||
11810 | 11810 | 4900 HENDRICKSON ROAD MIDDLETOWN, OH 45044 | 39.481331 | -84.340681 | 0 | 366437 | ARLINGTON POINTE | 4900 HENDRICKSON ROAD | MIDDLETOWN | OH | 45044 | 5136052700 | 80 | Butler | For profit - Corporation | 99 | 92.8 | Medicare and Medicaid | false | ARLINGTON POINTE INVESTMENT GROUP LLC | 02/09/2016 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 4 | 3 | 2 | 2 | 2.10176 | 1.25155 | 0.64466 | 1.89622 | 3.99798 | 0.05819 | 2.31498 | 0.90464 | 0.48485 | 3.70447 | 1.88692 | 1.04029 | 0.50045 | 3.46073 | 07/25/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 06/21/2018 | 7 | 5 | 2 | 40 | 1 | 0 | 40 | 2017-04-06 | 3 | 3 | 1 | 1 | 12 | 0 | 12 | 15.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 4900 HENDRICKSON ROAD MIDDLETOWN, OH 45044 (39.481331, -84.340681) | 02/01/2020 | |||||||||||
11998 | 11998 | 37800 FRENCH CREEK RD AVON, OH 44011 | 41.450552 | -82.044416 | 0 | 365762 | AVON OAKS NURSING HOME | 37800 FRENCH CREEK RD | AVON | OH | 44011 | 4409345204 | 480 | Lorain | For profit - Corporation | 105 | 94.8 | Medicare and Medicaid | false | R & J INVESTMENT CO INC | 09/29/1989 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 2.46875 | 1.00599 | 0.6697 | 1.67569 | 4.14444 | 0.07749 | 2.15316 | 0.78195 | 0.38101 | 3.31612 | 2.38295 | 0.96738 | 0.66157 | 4.00763 | 07/18/2019 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 06/07/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-04-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 37800 FRENCH CREEK RD AVON, OH 44011 (41.450552, -82.044416) | 02/01/2020 | |||||||||||
12501 | 12501 | 475 MORGAN HIGHWAY SCRANTON, PA 18508 | 41.449425 | -75.674264 | 0 | 396135 | ALLIED SERVICES TRANSITIONAL REHAB UNIT | 475 MORGAN HIGHWAY | SCRANTON | PA | 18508 | 5703481300 | 420 | Lackawanna | Non profit - Corporation | 55 | 35 | Medicare | true | ALLIED SERVICES INSTITUTE OF REHABILITATION MEDICINE | 07/09/2014 | false | false | false | false | None | Yes | 4 | 3 | 5 | 2 | 5 | 3 | 3 | 2.19262 | 1.23399 | 1.16459 | 2.39858 | 4.59119 | 0.75685 | 2.30597 | 1.08199 | 0.63029 | 4.01826 | 1.97617 | 0.85757 | 0.69544 | 3.66387 | 02/22/2019 | 6 | 6 | 0 | 36 | 2 | 18 | 54 | 03/09/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-04-06 | 5 | 5 | 0 | 1 | 28 | 0 | 28 | 35.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 475 MORGAN HIGHWAY SCRANTON, PA 18508 (41.449425, -75.674264) | 02/01/2020 | |||||||||||
12538 | 12538 | 5100 JOHN D RYAN BLVD SAN ANTONIO, TX 78245 | 29.383648 | -98.734965 | 0 | 675786 | AFV II HEALTH CARE CENTER | 5100 JOHN D RYAN BLVD | SAN ANTONIO | TX | 78245 | 2105683401 | 130 | Bexar | Non profit - Corporation | 64 | 27.7 | Medicare | false | BST HEALTH SERVICES CORP | 03/01/1999 | true | false | false | false | Resident | Yes | 4 | 3 | 2 | 3 | 2 | 4 | 3 | 2.66938 | 1.48119 | 0.67111 | 2.1523 | 4.82168 | 0.18098 | 2.03638 | 0.76392 | 0.35837 | 3.15867 | 2.72438 | 1.45795 | 0.70486 | 4.89494 | 05/17/2019 | 11 | 10 | 1 | 72 | 1 | 0 | 72 | 04/19/2018 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 2017-04-06 | 3 | 3 | 0 | 1 | 28 | 0 | 28 | 43.333 | 1 | 0 | 0 | 0.00 | 0 | 0 | 5100 JOHN D RYAN BLVD SAN ANTONIO, TX 78245 (29.383648, -98.734965) | 02/01/2020 | |||||||||||
12893 | 12893 | 11001 CRESCENT MOON DR HOUSTON, TX 77064 | 29.926571 | -95.583109 | 0 | 675818 | PARK MANOR OF CYFAIR | 11001 CRESCENT MOON DR | HOUSTON | TX | 77064 | 2814778877 | 610 | Harris | For profit - Limited Liability company | 120 | 107.1 | Medicare and Medicaid | false | WINNIE-STOWELL HOSPITAL DISTRICT | 01/10/2000 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 5 | 2 | 2 | 2 | 1.87829 | 0.60863 | 0.54967 | 1.1583 | 3.03659 | 0.05178 | 2.16113 | 0.81602 | 0.45597 | 3.43312 | 1.80633 | 0.56083 | 0.45373 | 2.83629 | 03/29/2019 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 03/23/2018 | 4 | 3 | 1 | 36 | 1 | 0 | 36 | 2017-04-06 | 6 | 5 | 1 | 1 | 60 | 0 | 60 | 24 | 0 | 1 | 0 | 0.00 | 0 | 0 | 11001 CRESCENT MOON DR HOUSTON, TX 77064 (29.926571, -95.583109) | 02/01/2020 | |||||||||||
12952 | 12952 | 489 CASTLE SHANNON BLVD PITTSBURGH, PA 15234 | 40.372017 | -80.033437 | 0 | 395020 | BAPTIST HOMES OF WESTERN PENNSYLVANIA | 489 CASTLE SHANNON BLVD | PITTSBURGH | PA | 15234 | 4125636550 | 10 | Allegheny | Non profit - Corporation | 126 | 114.4 | Medicare and Medicaid | false | BAPTIST HOMES SOCIETY | 01/01/1967 | true | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 4 | 4 | 5 | 2.44345 | 0.39605 | 1.18744 | 1.58349 | 4.02694 | 0.0485 | 2.34682 | 0.78309 | 0.36873 | 3.49864 | 2.16391 | 0.3803 | 1.21209 | 3.69088 | 03/28/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 02/12/2018 | 7 | 6 | 1 | 20 | 1 | 0 | 20 | 2017-04-06 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 18 | 0 | 1 | 0 | 0.00 | 0 | 0 | 489 CASTLE SHANNON BLVD PITTSBURGH, PA 15234 (40.372017, -80.033437) | 02/01/2020 | |||||||||||
13192 | 13192 | 3830 MUSTANG ROAD ALVIN, TX 77511 | 29.389041 | -95.235784 | 0 | 675495 | LAUREL COURT | 3830 MUSTANG ROAD | ALVIN | TX | 77511 | 2815858484 | 180 | Brazoria | For profit - Corporation | 125 | 79.9 | Medicare and Medicaid | false | SWEENY HOSPITAL DISTRICT | 06/12/1995 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 4 | 2 | 2 | 1.69289 | 1.17944 | 0.39365 | 1.57309 | 3.26597 | 0.13369 | 2.01911 | 0.80486 | 0.41483 | 3.23881 | 1.74254 | 1.10189 | 0.35717 | 3.23356 | 01/18/2019 | 3 | 1 | 2 | 16 | 1 | 0 | 16 | 02/16/2018 | 5 | 0 | 5 | 40 | 0 | 0 | 40 | 2017-04-06 | 3 | 3 | 0 | 1 | 32 | 0 | 32 | 26.667 | 6 | 4 | 0 | 0.00 | 0 | 0 | 3830 MUSTANG ROAD ALVIN, TX 77511 (29.389041, -95.235784) | 02/01/2020 | |||||||||||
13335 | 13335 | 189 MONICA BLVD LYNCHBURG, VA 24502 | 37.33636 | -79.175229 | 0 | 495411 | LIBERTY RIDGE HEALTH & REHAB | 189 MONICA BLVD | LYNCHBURG | VA | 24502 | 4348472860 | 551 | Lynchburg City | For profit - Corporation | 90 | 72 | Medicare and Medicaid | false | LIBERTY RIDGE HEALTHCARE GROUP LLC | 04/12/2013 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 4 | 5 | 2 | 2 | 1.98239 | 1.06401 | 0.48457 | 1.54858 | 3.53097 | 0.21405 | 2.18638 | 0.82555 | 0.41742 | 3.42936 | 1.88442 | 0.96913 | 0.43693 | 3.30167 | 06/13/2019 | 9 | 9 | 0 | 52 | 1 | 0 | 52 | 06/14/2018 | 7 | 7 | 1 | 56 | 2 | 28 | 84 | 2017-04-06 | 5 | 5 | 0 | 1 | 28 | 0 | 28 | 58.667 | 0 | 5 | 1 | 8648.00 | 0 | 1 | 189 MONICA BLVD LYNCHBURG, VA 24502 (37.33636, -79.175229) | 02/01/2020 | |||||||||||
14329 | 14329 | 105 SOUTH EISENHOWER DRIVE BECKLEY, WV 25801 | 37.78139 | -81.167552 | 0 | 5.1e+110 | JACKIE WITHROW HOSPITAL | 105 SOUTH EISENHOWER DRIVE | BECKLEY | WV | 25801 | 3042566600 | 400 | Raleigh | Government - State | 199 | 72.4 | Medicaid | false | Legal Business Name Not Available | 09/29/1981 | false | false | false | false | Resident | Yes | 4 | 3 | 2 | 2 | 2 | 4 | 4 | 1.72415 | 1.23721 | 0.71684 | 1.95406 | 3.67821 | 0.01749 | 1.67991 | 0.60603 | 0.26544 | 2.55138 | 2.13307 | 1.53508 | 1.01647 | 4.62289 | 10/02/2019 | 7 | 7 | 0 | 36 | 1 | 0 | 36 | 07/12/2018 | 10 | 10 | 1 | 56 | 1 | 0 | 56 | 2017-04-06 | 19 | 17 | 2 | 1 | 116 | 0 | 116 | 56 | 0 | 2 | 0 | 0.00 | 0 | 0 | 105 SOUTH EISENHOWER DRIVE BECKLEY, WV 25801 (37.78139, -81.167552) | 02/01/2020 | |||||||||||
14496 | 14496 | 8575 RIXLEW LANE MANASSAS, VA 20109 | 38.77161 | -77.50255 | 0 | 495038 | MANASSAS HEALTH AND REHAB CENTER | 8575 RIXLEW LANE | MANASSAS | VA | 20109 | 7032579770 | 563 | Manassas City | For profit - Individual | 120 | 113.5 | Medicare and Medicaid | false | MANASSAS HEALTH CARE LLC | 03/01/1979 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 3 | 2.25754 | 1.00649 | 0.75561 | 1.7621 | 4.01964 | 0.02395 | 2.19513 | 0.82578 | 0.43791 | 3.45882 | 2.13743 | 0.91649 | 0.64944 | 3.72659 | 06/20/2019 | 11 | 11 | 0 | 48 | 1 | 0 | 48 | 05/10/2018 | 18 | 18 | 0 | 80 | 1 | 0 | 80 | 2017-04-06 | 13 | 13 | 0 | 1 | 64 | 0 | 64 | 61.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 8575 RIXLEW LANE MANASSAS, VA 20109 (38.77161, -77.50255) | 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 );