nh_gen_info_geocoded_final

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

72 rows where Provider Resides in Hospital = "true" and geocode_flag = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_accuracy, ownership, prvdr_type, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, 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, 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 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 Health Revisit 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, 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
1 1 83825 AL-9, Ashland, AL 36251, USA 33.2771472 -85.82382199999999 1 ROOFTOP 15124 CLAY COUNTY NURSING HOME 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 2563542131 130 Clay Non profit - Other 83 75.9 Medicare and Medicaid true CLAY COUNTY HEALTHCARE AUTHORITY 12/01/1974 false   false false false Both Yes 5   3   5   5     2 4   4       2.26468 0.78644 0.54804 1.33448 3.59916 0.00014 1.79947 0.59241 0.25352 2.6454 2.61563 0.99823 0.81362 4.36276 05/16/2019 2 2 0 16 1 0 16 06/21/2018 4 4 0 28 1 0 28 2017-05-11 4 4 0 1 20 0 20 20.667 0 0 0 0.00 0 0   02/01/2020
61 61 1 Bay St, Montclair, NJ 07042, USA 40.8120546 -74.2036597 1 ROOFTOP 315389 HACKENSACK-UMC MOUNTAINSIDE ONE BAY AVE MONTCLAIR NJ 7042 9734296949 200 Essex For profit - Corporation 18 28.3 Medicare true MONTCLAIR HOSPITAL LLC 01/08/1998 false   false false false None Yes 5   5   5     2 5   3   5       0.26961 0 1.9601 1.9601 2.22971 0.37038 2.06033 0.86985 0.48637 3.41655 0.27196 0 1.51686 2.09273 07/22/2019 0 0 0 0 0 0 0 08/22/2018 0 0 0 0 0 0 0 2017-05-25 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0   02/01/2020
67 67 45th Ave & Parsons Blvd, Queens, NY 11355, USA 40.7556207 -73.81563659999999 1 GEOMETRIC_CENTER 335864 FLUSHING HOSPITAL MEDICAL CENTER T C U 45TH AVENUE AND PARSONS BOULEVARD FLUSHING NY 11355 7182066595 590 Queens Non profit - Corporation 6 4.1 Medicare true Legal Business Name Not Available 08/12/2011 false   false false false Resident Yes 5   4   4     2 4   5   5       1.26623 0 3.81296 3.81296 5.07918 0.29037 1.97479 0.83307 0.61688 3.42474 1.33262 0 2.32643 4.75576 11/26/2019 0 0 0 0 0 0 0 08/03/2018 4 4 0 24 1 0 24 2017-06-12 0 0 0 0 0 0 0 8 0 0 0 0.00 0 0   02/01/2020
88 88 Carretera #2 Km, Vega Baja, 00693, Puerto Rico 18.445622 -66.398985 1 GEOMETRIC_CENTER 405025 CENTRO MEDICO WILMA N VAZQUEZ SNF ROAD 2 KM 39 5 BO ALGARROBO VEGA BAJA PR 693 7878581580 730 Vega Baja For profit - Corporation 45 20 Medicare true INSTITUTO MEDICO DEL NORTE INC 08/09/1989 false   false false false None Yes 4   4   5     2 5   1 12 1 12 6 6                             05/15/2019 12 12 0 72 1 0 72 08/20/2018 5 5 0 24 1 0 24 2017-05-25 5 5 0 1 48 0 48 52 0 0 1 8447.00 0 1   02/01/2020
581 581 43563 CA-299, Fall River Mills, CA 96028, USA 41.0237722 -121.423551 1 ROOFTOP 56416 MAYERS MEMORIAL HOSPITAL 43563 HWY 299 E FALL RIVER MILLS CA 96028 5303365511 550 Shasta Government - Hospital district 99 75.5 Medicare and Medicaid true MAYERS MEMORIAL HOSPITAL DISTRICT 11/08/1973 false   false false false Resident Yes 2   2   2   2     2 3   2       2.96918 1.42881 0.29062 1.71943 4.68861 0 2.04598 0.61898 0.26427 2.92923 3.01613 1.73573 0.41392 5.13268 10/10/2019 5 3 2 16 1 0 16 11/29/2018 13 10 3 48 1 0 48 2018-02-01 27 18 9 2 204 102 306 75 8 5 2 133641.00 1 3   02/01/2020
687 687 1 John H Stewart Dr, Newington, CT 06111, USA 41.6953009 -72.7149347 1 ROOFTOP 75293 JEFFERSON HOUSE ONE JOHN STEWART DR NEWINGTON CT 6111 8606674453 10 Hartford For profit - Corporation 104 100 Medicare and Medicaid true HARTFORD HOSPITAL 09/24/1979 false   false false false Both Yes 5   5   5   5   5   5   5       3.08873 0.18431 1.87745 2.06175 5.15048 0.27451 2.15826 0.71368 0.32673 3.19867 2.97434 0.19419 2.16278 5.16335 03/21/2019 2 2 0 12 1 0 12 03/01/2018 3 3 0 12 1 0 12 2017-04-13 1 1 0 1 8 0 8 11.333 0 0 0 0.00 0 0   02/01/2020
824 824 Eldridge, CA 95431, USA 38.3634225 -122.5279928 1 APPROXIMATE 05A213 SONOMA DEVELOPMENTAL CENTER D/P SNF P.O. BOX 1493 ELDRIDGE CA 95431 7079386000 590 Sonoma Government - State 427   Medicaid true Legal Business Name Not Available 09/01/1974 false   false false false Both Yes 4   5     2   2   2 1 12 1 12 6 6                             07/26/2018 3 3 0 20 1 0 20 08/31/2017 3 3 0 12 1 0 12 2016-09-16 7 5 2 1 44 0 44 21.333 3 0 0 0.00 0 0   02/01/2020
1007 1007 6051 US 49, Hattiesburg, MS 39401, USA 31.3185784 -89.32952639999999 1 ROOFTOP 255335 FORREST GENERAL HOSPITAL SKILLED NURSING UNIT 6051 US HIGHWAY 49 SOUTH HATTIESBURG MS 39401 6012887000 170 Forrest Government - County 20 17.8 Medicare true FORREST COUNTY GENERAL HOSPITAL 05/10/2012 false   false false false None Yes 5   5   5     2 5   5   5       3.88102 1.26569 4.67885 5.94455 9.82556 0.42185 2.30367 0.89895 0.53855 3.74117 3.5014 1.0587 3.26996 8.42176 06/13/2019 2 2 0 8 1 0 8 07/19/2018 0 0 0 0 0 0 0 2017-06-28 0 0 0 0 0 0 0 4 0 0 0 0.00 0 0   02/01/2020
1323 1323 3340 Hospital Rd, Saginaw, MI 48603, USA 43.4551416 -84.0513038 1 ROOFTOP 235150 HEALTHSOURCE SAGINAW, INC 3340 HOSPITAL RD SAGINAW MI 48603 9897907700 720 Saginaw Non profit - Other 213 202.8 Medicare and Medicaid true HEALTHSOURCE SAGINAW INC 02/23/1968 false   false false false Resident Yes 2   1   4   4   5   4   4       2.6567 0.8195 0.67999 1.49949 4.15619 0.11139 2.02249 0.69892 0.34315 3.06457 2.73006 0.88166 0.74585 4.3489 05/30/2019 19 16 5 278 2 139 417 06/14/2018 9 8 1 64 1 0 64 2017-04-07 26 24 5 1 172 0 172 258.5 0 21 2 69261.00 1 3   02/01/2020
1967 1967 1 Old Hwy 5, Centerville, IA 52544, USA 40.7555228 -92.8568047 1 ROOFTOP inf MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH DRIVE CENTERVILLE IA 52544 6414374111 30 Appanoose Non profit - Church related 19 18.4 Medicaid true Legal Business Name Not Available 04/01/2008 false   false false false Resident Yes 3   2   3   3     2 5   5       1.16622 2.36431 0.90605 3.27035 4.43658 0 1.79181 0.6027 0.26694 2.66145 1.35271 2.94977 1.2775 5.34543 06/27/2019 3 3 0 12 1 0 12 03/22/2018 2 1 1 83 1 0 83 2017-01-19 4 4 0 1 40 0 40 40.333 2 0 0 0.00 0 0   02/01/2020
2384 2384 Mars Hill, ME 04758, USA 46.5557595 -67.8644119 1 APPROXIMATE 205018 AROOSTOOK HEALTH CENTER PO BOX 410 MARS HILL ME 4758 2077684915 10 Aroostook Non profit - Corporation 72 56.9 Medicare and Medicaid true AROOSTOOK MEDICAL CENTER 01/04/1967 false   false false false Resident Yes 5   5   4   4   3   5   5       3.42296 0.34497 1.88246 2.22744 5.6504 0.09389 2.23986 0.70506 0.28656 3.23148 3.17611 0.36791 2.47252 5.607 06/19/2019 2 2 0 8 1 0 8 07/18/2018 1 0 1 0 0 0 0 2017-06-14 2 2 0 1 12 0 12 6 0 1 0 0.00 0 0   02/01/2020
2743 2743 Wrangell, AK, USA 56.4708333 -132.3766666 1 APPROXIMATE 25015 WRANGELL MEDICAL CENTER LTC P.O. BOX 1081 WRANGELL AK 99929 9078747000 280 Wrangell Non profit - Corporation 15 12.8 Medicare and Medicaid true SOUTHEAST ALASKA REGIONAL HEALTH CONSORTIUM 07/01/1976 false   false false false Resident Yes 3   2   3   3     2 5   5       6.07733 0 3.31231 3.31231 9.38964 0.00318 2.08378 0.65668 0.30052 3.04099 6.06145 0 4.14843 9.90118 04/24/2019 14 14 0 120 1 0 120 04/30/2018 24 24 0 152 1 0 152 2017-06-09 2 2 0 1 4 0 4 111.333 0 0 0 0.00 0 0   02/01/2020
2778 2778 1760 County Rd J, Wahoo, NE 68066, USA 41.19339189999999 -96.6356701 1 ROOFTOP 285296 SAUNDERS MEDICAL CENTER 1760 COUNTY RD J WAHOO NE 68066 4024434685 770 Saunders Government - County 60 55.8 Medicare and Medicaid true SAUNDERS MEDICAL CENTER 09/08/2016 false   false false false Resident Yes 4   4   2   2     2 4   4       2.78396 0.50199 0.78095 1.28294 4.0669 0.00944 2.04874 0.65444 0.29998 3.00317 2.82418 0.57678 0.97984 4.34247 04/10/2018 4 4 1 28 1 0 28 02/14/2017 1 1 1 8 1 0 8 2015-11-30 4 4 0 1 20 0 20 20 2 0 0 0.00 1 1   02/01/2020
2899 2899 1310 Southern Ave SE #200, Washington, DC 20032, USA 38.8359393 -76.9849936 1 ROOFTOP 95039 UNITED MEDICAL NURSING HOME 1310 SOUTHERN AVENUE, SE, SUITE 200 WASHINGTON DC 20032 2025747123 0 The District Non profit - Corporation 120 86.5 Medicare and Medicaid true NOT-FOR-PROFIT HOSPITAL CORPORATION 02/27/2009 false   false false false Both Yes 2   1   4   5   2   5   5       2.91113 0.64912 1.30984 1.95896 4.87008 0.15475 1.91582 0.71543 0.34049 2.97174 3.15807 0.68225 1.44793 5.25507 11/16/2018 24 23 1 291 1 0 291 11/14/2017 26 23 3 104 1 0 104 2016-12-05 21 18 3 2 152 76 228 218.167 2 5 2 171135.00 0 2   02/01/2020
3178 3178 1305 US-6, Cambridge, NE 69022, USA 40.2804314 -100.180273 1 ROOFTOP 2.8e+196 CAMBRIDGE MANOR P O BOX 488, WEST HWY 6 & 34 CAMBRIDGE NE 69022 3086973329 320 Furnas Non profit - Corporation 34   Medicaid true Legal Business Name Not Available 10/01/1980 false   false false false Resident Yes 2   3   4   4     2 1 12 1 12 6 6                             05/16/2018 6 6 0 24 1 0 24 06/22/2017 14 14 0 84 1 0 84 2016-05-19 2 2 0 1 12 0 12 42 0 0 0 0.00 0 0   02/01/2020
3249 3249 Mark St, Ortonville, MN 56278, USA 45.3180719 -96.4507215 1 GEOMETRIC_CENTER 245451 FAIRWAY VIEW NEIGHBORHOODS 201 MARK DRIVE ORTONVILLE MN 56278 3208396113 50 Big Stone Government - City 51 49.8 Medicare and Medicaid true ORTONVILLE AREA HEALTH SERVICES 04/01/1987 false   false false false Both Yes 5   3   5   5     2 4   4       2.8891 0.46015 0.57268 1.03283 3.92193 0.01246 1.87418 0.61769 0.26662 2.7585 3.20382 0.56015 0.80843 4.55911 03/07/2019 4 4 1 16 1 0 16 05/03/2018 11 11 0 48 2 24 72 2017-03-30 8 8 0 1 24 0 24 36 1 0 0 0.00 0 0   02/01/2020
3321 3321 118 N 7th Ave, Sheldon, IA 51201, USA 43.1871696 -95.84581879999999 1 ROOFTOP 1.6e+264 SANFORD SENIOR CARE SHELDON 118 NORTH SEVENTH AVENUE, PO BOX 250 SHELDON IA 51201 7123246453 700 Obrien Non profit - Corporation 70 52.8 Medicaid true Legal Business Name Not Available 05/01/1978 false   false false false Both Yes 1   2   3   3     2 1 12 1 12     2.34859 0.37083 0.79227 1.1631 3.51169 0 1.76315 0.58668 0.2631 2.61294 2.76843 0.47529 1.13339 4.30963 11/29/2018 6 6 0 24 1 0 24 08/03/2017 2 2 0 8 1 0 8 2016-06-23 11 4 7 1 185 0 185 45.5 4 4 0 0.00 0 0   02/01/2020
3358 3358 301 St Paul Pl, Baltimore, MD 21202, USA 39.292837 -76.61324599999999 1 ROOFTOP 215283 TRANSITIONAL CARE SERVICES AT MERCY MEDICAL CENTER 301 ST. PAUL PLACE BALTIMORE MD 21202 4103329287 30 Baltimore City Government - Federal 35 24 Medicare and Medicaid true MERCY TRANSITIONAL CARE SERVICES 04/18/1996 false   false false false None Yes 5   5   5     2 5   5   5       3.03125 1.52372 3.11977 4.64349 7.67474 0.28006 1.87912 0.94213 0.5327 3.35395 3.35262 1.21613 2.20429 7.33772 05/08/2019 1 1 0 4 1 0 4 01/05/2018 2 2 0 8 1 0 8 2017-01-13 2 2 0 1 12 0 12 6.667 0 0 0 0.00 0 0   02/01/2020
3374 3374 421 S Maple St, Garnett, KS 66032, USA 38.2797193 -95.25165249999999 1 ROOFTOP inf ANDERSON COUNTY HOSPITAL LTCU 421 S MAPLE STREET PO BOX 309 GARNETT KS 66032 7852044016 10 Anderson Non profit - Corporation 36 26.3 Medicaid true Legal Business Name Not Available 05/29/1991 false   false false false Resident Yes 4   3   2   2     2 5   5       3.10863 0.84866 0.97288 1.82154 4.93017 0.00024 1.90936 0.59577 0.25378 2.75892 3.38373 1.07112 1.44288 5.73029 01/10/2019 4 0 4 48 1 0 48 12/05/2017 4 4 1 40 1 0 40 2016-03-16 3 2 1 1 36 0 36 43.333 4 1 0 0.00 0 0   02/01/2020
3639 3639 W 1st St & A St, Hawthorne, NV 89415, USA 38.51818189999999 -118.6283412 1 GEOMETRIC_CENTER 295001 LEFA SERAN SNF 1ST AND A ST/ PO BOX 1510 HAWTHORNE NV 89415 7759452461 100 Mineral Government - County 24 22.7 Medicare and Medicaid true MT GRANT GENERAL HOSPITAL 01/01/1967 false   false false false Resident Yes 3   2   3   3     2 5   5       2.97022 0.59406 0.91778 1.51185 4.48206 0.01304 1.89967 0.66216 0.27783 2.83966 3.24957 0.67462 1.24335 5.06133 10/16/2019 16 16 0 76 1 0 76 01/10/2019 12 11 1 60 1 0 60 2017-10-12 14 14 0 1 96 0 96 74 0 1 0 0.00 0 0   02/01/2020
3670 3670 1100 E Michigan Ave, Grayling, MI 49738, USA 44.6676119 -84.7074677 1 ROOFTOP 235201 MUNSON HEALTHCARE CRAWFORD CONTINUING CARE CENTER 1100 MICHIGAN AVE GRAYLING MI 49738 9893480317 190 Crawford For profit - Individual 39 35.3 Medicare and Medicaid true MUNSON HEALTHCARE GRAYLING 07/01/1976 false   false false false Resident Yes 2   1   5   5   5   5   5       2.60835 0.35339 1.3382 1.69159 4.29994 0.04798 1.84002 0.6985 0.32256 2.86108 2.94618 0.38043 1.56148 4.81931 06/17/2019 11 11 0 240 1 0 240 05/11/2018 5 5 0 44 2 22 66 2017-06-01 7 7 0 1 44 0 44 149.333 0 0 1 132282.00 0 1   02/01/2020
4311 4311 35625 MO-72, Salem, MO 65560, USA 37.6591179 -91.5659881 1 ROOFTOP 26A381 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, 35629 HIGHWAY 72 SALEM MO 65560 5737296626 320 Dent Government - Hospital district 18 17.9 Medicaid true Legal Business Name Not Available 06/25/1992 false   false false false Resident Yes 5   5   5   5     2 1 12 1 12 6 6                             11/06/2019 1 1 0 16 1 0 16 10/10/2018 0 0 0 0 0 0 0 2017-08-10 2 2 0 1 8 0 8 9.333 0 0 0 0.00 0 0   02/01/2020
4774 4774 1000 Greg Kruschek Avenue, Nome, AK 99762, USA 64.4992304 -165.3784042 1 ROOFTOP 25026 QUYANNA CARE CENTER 1100 GREG KRUSCHEK AVENUE (P.O. BOX 966) NOME AK 99762 9074433311 180 Nome Non profit - Corporation 18 16.9 Medicare and Medicaid true NORTON SOUND HEALTH CORPORATION 06/01/1994 false   false false false Resident Yes 2   1   2   2     2 5   5       5.29221 1.13167 3.39518 4.52686 9.81906 0.07245 1.94421 0.59541 0.25598 2.79561 5.65729 1.42917 4.9921 11.2628 05/03/2019 12 12 0 222 1 0 222 04/06/2018 20 17 3 148 1 0 148 2017-02-16 4 4 0 1 28 0 28 165 1 2 2 34325.00 0 2   02/01/2020
4799 4799 26501 Ave 140, Porterville, CA 93257, USA 36.0438161 -118.9803525 1 ROOFTOP 05A198 PORTERVILLE DEVELOPMENTAL CENTER 26501 AVENUE 140 PORTERVILLE CA 93257 5597822222 640 Tulare Government - State 201 9.9 Medicaid true Legal Business Name Not Available 09/01/1974 false   false false false Resident Yes 5   5   5   5     2 1 12 1 12 6 6                             06/06/2019 5 4 1 28 1 0 28 05/04/2018 2 2 0 8 1 0 8 2017-06-15 5 2 3 1 20 0 20 20 4 0 0 0.00 0 0   02/01/2020
4802 4802 45-547 Plumeria St, Honokaa, HI 96727, USA 20.0763494 -155.4697034 1 ROOFTOP 125032 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 8089324100 10 Hawaii Government - State 66 61.2 Medicare and Medicaid true HALE HO OLA HAMAKUA 01/01/1977 false   false false false Resident Yes 4   3   4   4     2 5   5       3.2361 0.42875 1.09155 1.5203 4.7564 0 2.21617 0.66506 0.28419 3.16542 3.03483 0.48476 1.44566 4.81836 07/19/2019 6 6 0 28 1 0 28 08/06/2018 10 10 0 52 1 0 52 2017-05-12 6 4 2 1 44 0 44 38.667 0 1 1 6893.00 0 1   02/01/2020
4811 4811 250 Jordan Dr, Granite Falls, MN 56241, USA 44.8118144 -95.5236094 1 ROOFTOP 245243 AVERA GRANITE FALLS CARE CENTER 250 JORDAN DRIVE GRANITE FALLS MN 56241 3205643111 860 Yellow Medcine Government - City 48 47 Medicare and Medicaid true Legal Business Name Not Available 07/06/1981 false   false false false Both Yes 5   4   5   5     2 5   5       2.62579 0.63098 0.90013 1.53111 4.15691 0.01724 1.98458 0.63236 0.26698 2.88392 2.74984 0.75031 1.26901 4.62211 12/06/2018 3 3 0 20 1 0 20 01/26/2018 1 1 0 16 1 0 16 2016-12-01 7 7 0 1 32 0 32 20.667 0 0 0 0.00 0 0   02/01/2020
5063 5063 528 Chief Eddie Hoffman Hwy, Bethel, AK 99559, USA 60.78834669999999 -161.7851781 1 ROOFTOP 25037 YUKON KUSKOKWIM ELDER'S HOME 1100 CHIEF EDDIE HOFFMAN HWY, PO BOX 528 BETHEL AK 99559 9075436782 50 Bethel Government - Federal 18 16.5 Medicare and Medicaid true YUKON-KUSKOKWIM HEALTH CORPORATION 04/10/2014 false   false false false Resident Yes 2   1   5   5     2 5   5       3.60122 3.34976 3.12141 6.47118 10.07239 0 2.06157 0.60747 0.26042 2.92946 3.6305 4.14644 4.5113 11.02548 11/09/2018 18 18 0 108 1 0 108 02/02/2018 25 25 4 264 2 132 396 2017-02-14 16 16 0 1 239 0 239 225.833 0 2 3 31012.00 0 3   02/01/2020
6046 6046 56-117 Pualalea St, Kahuku, HI 96731, USA 21.6763946 -157.9541328 1 ROOFTOP 125030 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 8082939221 20 Honolulu Non profit - Other 6 5.9 Medicare and Medicaid true KAHUKU MEDICAL CENTER 01/01/1977 false   false false false Resident Yes 1   2     2   2   2 1 12 1 12 6 6                             06/04/2019 6 6 0 28 1 0 28 07/06/2018 5 5 0 60 1 0 60 2017-07-14 10 10 0 2 119 60 179 63.833 0 0 1 19500.00 1 2   02/01/2020
6091 6091 5211 Hwy 110, Aurora, MN 55705, USA 47.51805479999999 -92.22954469999999 1 ROOFTOP 245469 ESSENTIA HEALTH NORTHERN PINES MEDICAL CENTER 5211 HIGHWAY 110 AURORA MN 55705 2182294222 680 St. Louis Non profit - Corporation 33 31.2 Medicare and Medicaid true NORTHERN PINES MEDICAL CENTER 04/01/1987 false   false false false Resident Yes 5   3   5   5     2 4   4       2.26421 0.40783 0.65766 1.06549 3.3297 0.00405 1.95425 0.62573 0.2466 2.82658 2.40798 0.49009 1.00376 3.77743 01/24/2019 4 4 0 28 1 0 28 12/07/2017 11 11 0 44 1 0 44 2017-02-16 3 3 0 1 8 0 8 30 0 0 0 0.00 0 0   02/01/2020
6096 6096 99 NJ-37, Toms River, NJ 08755, USA 39.9642549 -74.2156583 1 ROOFTOP 315490 COMMUNITY MEDICAL CENTER TCU 99 ROUTE 37 WEST TOMS RIVER NJ 8755 7325578000 310 Ocean Non profit - Corporation 25 15.7 Medicare true COMMUNITY MEDICAL CENTER, INC. 02/10/2005 false   false false false None Yes 5   5   4     2 4   5   5       1.51765 0 3.05657 3.05657 4.57422 0.62433 1.85745 0.9215 0.49468 3.27363 1.69813 0 2.32563 4.48064 10/25/2019 0 0 0 0 0 0 0 11/21/2018 0 0 0 0 0 0 0 2017-11-01 1 1 0 1 4 0 4 0.667 0 0 0 0.00 0 0   02/01/2020
6401 6401 1140 NJ-72, Stafford Township, NJ 08050, USA 39.7204304 -74.2850856 1 ROOFTOP 315478 SOUTHERN OCEAN MEDICAL CENTER 1140 ROUTE 72 WEST MANAHAWKIN NJ 8050 6099784182 310 Ocean Non profit - Corporation 20 15.4 Medicare true HMH HOSPITALS CORPORATION 08/27/2002 false   false false false None Yes 5   5   5     2 5   5   5       2.04531 1.60287 2.54274 4.14561 6.19092 0.70348 2.30545 1.09058 0.64267 4.03869 1.84383 1.10516 1.48918 4.9155 03/28/2019 0 0 0 0 0 0 0 05/03/2018 0 0 0 0 0 0 0 2017-05-05 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0   02/01/2020
6512 6512 541 Historic Hwy #441-N, Demorest, GA 30535, USA 34.5810438 -83.53708859999999 1 ROOFTOP 115099 HABERSHAM HOME HIGHWAY 441 NORTH, BOX 37 DEMOREST GA 30535 7067543113 540 Habersham Non profit - Other 84 76 Medicare and Medicaid true THE HOSPITAL AUTHORITY OF HABERSHAM COUNTY 03/06/1969 false   false false false Resident Yes 1   1   3   4   3   2   2       2.08323 1.17353 0.26927 1.4428 3.52603 0 2.26045 0.66078 0.29369 3.21491 1.91539 1.33544 0.34509 3.51698 06/27/2019 8 6 8 60 1 0 60 05/02/2018 6 4 2 28 1 0 28 2017-05-18 7 7 7 1 36 0 36 45.333 0 3 1 18605.00 0 1   02/01/2020
6529 6529 1 Genesys Pkwy, Grand Blanc, MI 48439, USA 42.8903226 -83.6367994 1 ROOFTOP 235713 GENESYS SHORT-TERM REHABILITATION CENTER ONE GENESYS PARKWAY GRAND BLANC MI 48439 8106066190 240 Genesee Non profit - Church related 12 7.9 Medicare true ASCENSION GENESYS HOSPITAL 11/24/2015 false   false false false None Yes 5   5   5     2 5   5   5       2.75394 0.45436 6.02351 6.47787 9.23181 0.21267 1.8145 0.95323 0.55868 3.3264 3.15438 0.35841 4.05807 8.8995 03/27/2019 2 2 0 16 1 0 16 04/17/2018 4 4 0 28 1 0 28 2017-03-06 4 4 0 1 20 0 20 20.667 0 0 0 0.00 0 0   02/01/2020
6587 6587 401 S Van Buren St, Mt Pleasant, IA 52641, USA 40.9636572 -91.5588478 1 ROOFTOP 165147 HENRY COUNTY HEALTH CENTER 401 SOUTH VAN BUREN MOUNT PLEASANT IA 52641 3193856192 430 Henry Government - Hospital district 49 36.4 Medicare and Medicaid true HENRY COUNTY SOLDIERS' AND SAILORS' MEMORIAL HOSPITAL 01/16/1989 false   false false false Both Yes 3   3   5   5     2 1 12 1 12 6 6                             10/17/2019 2 2 0 12 1 0 12 08/02/2018 1 1 0 4 1 0 4 2017-05-11 11 8 3 1 68 0 68 18.667 1 1 0 0.00 0 0   02/01/2020
6795 6795 103 Fram St, Petersburg, AK 99833, USA 56.8128691 -132.9554619 1 ROOFTOP 25019 PETERSBURG MEDICAL CENTER LTC P.O. BOX 589 PETERSBURG AK 99833 9077724291 195 Petersburg Borough Government - City/county 15 13.2 Medicare and Medicaid true THE PETERSBURG MEDICAL CENTER 01/01/1981 false   false false false Resident Yes 5   5   5   5     2 5   5       4.69812 0.39221 1.92334 2.31555 7.01367 0.04269 2.12301 0.67905 0.27674 3.0788 4.59927 0.43431 2.61584 7.30494 04/12/2019 5 5 0 20 1 0 20 04/27/2018 8 8 0 84 1 0 84 2017-03-17 6 6 0 1 32 0 32 43.333 0 0 0 0.00 0 0   02/01/2020
7047 7047 213 S Whitacre St, Yerington, NV 89447, USA 38.9838961 -119.1673158 1 ROOFTOP 295011 SOUTH LYON MEDICAL CENTER P.O. BOX 940 YERINGTON NV 89447 7754632301 90 Lyon Non profit - Corporation 49 36.5 Medicare and Medicaid true SOUTH LYON HEALTH CENTER INC 01/15/1967 false   false false false Resident Yes 4   4   5   5   5   1 12 1 12     3.38682 1.39727 0.4958 1.89306 5.27989 0.01162 2.06734 0.61043 0.27895 2.95673 3.40483 1.72117 0.66897 5.72619 11/14/2019 11 11 0 68 1 0 68 10/11/2018 5 5 1 28 1 0 28 2017-12-07 8 7 1 1 28 0 28 48 0 0 0 0.00 0 0   02/01/2020
7297 7297 251 N 4th St, Oakland, MD 21550, USA 39.413393 -79.4010325 1 ROOFTOP 215310 GARRETT COUNTY SUBACUTE UNIT 251 NORTH FOURTH STREET OAKLAND MD 21550 3015334220 110 Garrett Government - County 10 7.8 Medicare and Medicaid true GARRETT COUNTY MEMORIAL HOSPITAL 08/06/1997 false   false false false Resident Yes 5   4   5     2 5   5   5       3.4391 0 3.96814 3.96814 7.40724 0.21029 2.09724 1.02242 0.59444 3.7141 3.4081 0 2.51252 6.39523 12/13/2018 5 5 0 24 1 0 24 09/05/2017 1 1 0 4 1 0 4 2016-09-26 5 5 0 1 24 0 24 17.333 0 0 0 0.00 0 0   02/01/2020
7325 7325 2500 Hwy 65 S, Clinton, AR 72031, USA 35.559199 -92.452208 1 ROOFTOP 45414 OZARK HEALTH NURSING AND REHAB CENTER 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 5017457000 700 Van Buren Non profit - Corporation 118 70.9 Medicare and Medicaid true OZARK HEALTH, INC 07/25/2006 false   false false false Resident Yes 4   4   4   3   4   4   4       3.43758 1.213 0.63577 1.84878 5.28636 0.03269 1.96978 0.62095 0.27334 2.86407 3.62703 1.4689 0.87544 5.9187 12/14/2018 3 3 0 12 1 0 12 01/26/2018 5 4 1 36 1 0 36 2016-10-14 8 8 0 1 56 0 56 27.333 0 1 0 0.00 0 0   02/01/2020
7455 7455 Old Hwy 60, Kentucky 40146, USA 37.8033267 -86.3259743 1 GEOMETRIC_CENTER 185285 BRECKINRIDGE MEMORIAL NURSING FACILITY 1011 OLD HIGHWAY 60 HARDINSBURG KY 40143 2707567000 130 Breckinridge For profit - Corporation 18 18 Medicare and Medicaid true BRECKINRIDGE HEALTH, INC. 07/11/1991 false   false false false Resident Yes 4   4   5   5     2 1 12 1 12     3.06103 0.54266 1.10254 1.6452 4.70622 0 2.24801 0.69421 0.28061 3.22283 2.82999 0.58779 1.47882 4.68261 07/02/2019 1 1 0 16 1 0 16 05/23/2018 1 1 0 4 1 0 4 2017-03-30 3 2 1 1 20 0 20 12.667 1 0 0 0.00 0 0   02/01/2020
8062 8062 459 GA-119, Springfield, GA 31329, USA 32.3643545 -81.32012089999999 1 ROOFTOP 115106 EFFINGHAM CARE & REHABILITATION CENTER 459 HIGHWAY 119 SOUTH SPRINGFIELD GA 31329 9127546451 421 Effingham Non profit - Corporation 105 99.3 Medicare and Medicaid true EFFINGHAM HOSPITAL INC 08/25/1969 false   false false false Both Yes 2   2   4   3   5   3   2       3.56213 1.08055 0.31186 1.39241 4.95454 0.00878 2.01439 0.64908 0.29337 2.95684 3.67521 1.25178 0.40011 5.37314 08/16/2018 3 3 0 44 1 0 44 09/28/2017 0 0 0 0 0 0 0 2016-04-29 0 0 0 0 0 0 0 22 0 0 1 12005.00 0 1   02/01/2020
8167 8167 Old Rd to 9 Acre Corner, Concord, MA 01742, USA 42.44335299999999 -71.37656799999999 1 GEOMETRIC_CENTER 225692 EMERSON REHABILITATION & TRANSITIONAL CARE UNIT OLD ROAD TO NINE ACRE CORNER WEST CONCORD MA 1742 9782873620 90 Middlesex Non profit - Corporation 20 15.5 Medicare and Medicaid true EMERSON HOSPITAL 11/17/1995 false   false false false Resident Yes 5   5   5     2 5   5   5       2.34333 0.33439 4.30591 4.64029 6.98363 0.80579 2.03071 0.98409 0.53454 3.54934 2.3983 0.2555 3.03188 6.30938 07/03/2019 0 0 0 0 0 0 0 09/05/2018 0 0 0 0 0 0 0 2017-06-09 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0   02/01/2020
8261 8261 54 Hospital Rd, Kapaau, HI 96755, USA 20.2305329 -155.7986628 1 RANGE_INTERPOLATED 125031 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 8088896211 10 Hawaii Government - State 22 20.5 Medicare and Medicaid true KOHALA HOSPITAL 01/01/1977 false SFF Candidate false false false Resident Yes 2   1   2   2     2 5   5       3.1252 0.22942 1.50146 1.73088 4.85608 0.06877 1.87854 0.65177 0.30881 2.83913 3.45758 0.26468 1.82998 5.48472 06/06/2019 6 6 0 32 1 0 32 06/06/2018 25 19 8 585 1 0 585 2016-12-09 13 13 0 1 80 0 80 224.333 3 1 2 159798.00 0 2   02/01/2020
8672 8672 12 3rd St SE, Hillsboro, ND 58045, USA 47.4032378 -97.05579159999999 1 ROOFTOP 355061 SANFORD HILLSBORO CARE CENTER 12 3RD ST SE HILLSBORO ND 58045 7016363235 480 Traill Non profit - Corporation 30 29.8 Medicare and Medicaid true SANFORD HEALTH NETWORK NORTH 06/01/1978 false   false false false Resident Yes 5   5   5   5     2 5   5       2.99188 0.66786 0.80651 1.47437 4.46625 0.01431 1.6781 0.60498 0.25069 2.53376 3.70546 0.83011 1.21089 5.65236 04/10/2019 1 1 0 4 1 0 4 04/19/2018 3 3 0 12 1 0 12 2017-03-01 4 4 0 1 8 0 8 7.333 0 0 0 0.00 0 0   02/01/2020
8709 8709 931 N Broadway St, Aspermont, TX 79502, USA 33.1481491 -100.2274452 1 RANGE_INTERPOLATED 676077 GIBSON CARE CENTER 931 N BROADWAY ASPERMONT TX 79502 9409893526 903 Stonewall For profit - Corporation 80 26.2 Medicare and Medicaid true STONEWALL MEMORIAL HOSPITAL 09/13/2005 false   false false false Both Yes 4   5   2   2     2 1 12 1 12 6 6                             03/25/2019 2 1 1 8 1 0 8 02/28/2018 0 0 0 0 0 0 0 2017-01-05 5 5 0 1 48 0 48 12 0 1 0 0.00 0 0   02/01/2020
8757 8757 1st St, Portola, CA 96122, USA 39.8124724 -120.4662631 1 GEOMETRIC_CENTER 555433 EASTERN PLUMAS HOSPITAL- PORTOLA CAMPUS DP/SNF 500 FIRST STREET PORTOLA CA 96122 5308324277 420 Plumas Government - Hospital district 66 56.2 Medicare and Medicaid true EASTERN PLUMAS HEALTH CARE DISTRICT 09/11/1990 false   true false false Resident Yes 1   1   4   4     2 1 12 1 12     2.73887 1.27516 0.49137 1.76653 4.5054 0.0632 1.90677 0.61611 0.2534 2.77628 2.9853 1.5563 0.72985 5.20383 12/14/2019 42 21 21 232 1 0 232 11/20/2018 14 5 9 60 1 0 60 2017-12-22 11 9 2 1 64 0 64 146.667 19 2 0 0.00 0 0   02/01/2020
8786 8786 1 Clara Maass Dr, Belleville, NJ 07109, USA 40.7856181 -74.17709119999999 1 ROOFTOP 315505 CLARA MAASS MEDICAL CENTER ONE CLARA MAASS DRIVE BELLEVILLE NJ 7109 9734502963 200 Essex Non profit - Corporation 20 14.9 Medicare true CLARA MAASS MEDICAL CENTER 10/07/2009 false   false false false None Yes 5   4   5     2 5   5   5       2.39211 0 3.6392 3.6392 6.03131 0.63964 1.9274 0.95691 0.55194 3.43625 2.57944 0 2.48168 5.62833 07/17/2019 3 3 0 16 0 0 16 08/23/2018 1 1 0 4 1 0 4 2017-08-10 0 0 0 0 0 0 0 9.333 0 0 0 0.00 0 0   02/01/2020
9118 9118 196 North St, Geneva, NY 14456, USA 42.876489 -76.9883041 1 ROOFTOP 335098 FINGER LAKES HEALTH 196-198 NORTH STREET GENEVA NY 14456 3157874730 530 Ontario Non profit - Corporation 345 277.5 Medicare and Medicaid true GENEVA NURSING HOME INC 01/01/1967 false   false false false Resident Yes 2   2   4   4   4   3   3       1.80866 0.76853 0.48769 1.25622 3.06488 0.06311 2.00645 0.66561 0.31047 2.98252 1.87346 0.86821 0.59124 3.29521 08/31/2018 6 6 0 20 1 0 20 04/28/2017 10 7 5 52 1 0 52 2016-01-29 10 10 0 1 48 0 48 35.333 1 3 1 6893.00 0 1   02/01/2020
9372 9372 886 US-411, Etowah, TN 37331, USA 35.3449719 -84.5230381 1 ROOFTOP 445277 STARR REGIONAL HEALTH & REHABILITATION 886 HWY 411 NORTH ETOWAH TN 37331 4232633646 530 Mc Minn For profit - Corporation 88 77.1 Medicare and Medicaid true ATHENS REGIONAL MEDICAL CENTER LLC 03/05/1992 false   false false false Resident Yes 5   3   5   4   5   4   4       2.18853 0.85655 0.94703 1.80357 3.9921 0.06884 2.13848 0.69574 0.34213 3.17635 2.12698 0.92574 1.04183 4.0302 09/05/2019 0 0 0 0 0 0 0 08/01/2018 1 1 0 16 1 0 16 2017-06-01 9 4 5 1 80 0 80 18.667 2 1 1 55235.00 0 1   02/01/2020
9471 9471 N 17th St & W Chew St, Allentown, PA 18104, USA 40.60077769999999 -75.4942301 1 GEOMETRIC_CENTER 395951 LEHIGH VALLEY HOSPITAL TSU 17TH & CHEW STS ALLENTOWN PA 18105 6109694225 470 Lehigh Non profit - Corporation 52 36.2 Medicare true LEHIGH VALLEY HOSPITAL 03/23/1995 false   false false false Resident Yes 5   5   4     2 4   5   5       2.38569 0 3.57471 3.57471 5.9604 0.59354 2.11223 1.03241 0.58569 3.73032 2.34741 0 2.29724 5.12368 10/03/2019 0 0 0 0 0 0 0 11/19/2018 0 0 0 0 0 0 0 2017-12-01 1 1 0 1 4 0 4 0.667 0 0 0 0.00 0 0   02/01/2020
9584 9584 3520 Highland Dr, Millcreek, UT 84106, USA 40.6949272 -111.849639 1 ROOFTOP 465185 MILLCREEK REHABILITATION AND NURSING, LLC 3520 SOUTH HIGHLAND DRIVE SALT LAKE CITY UT 84106 8014847638 170 Salt Lake Government - City 61 43.1 Medicare and Medicaid true BEAVER VALLEY HOSPITAL 04/04/2016 false SFF Candidate false false false Resident Yes 1   1   3   4   3   3   4       1.88533 0.14658 1.07926 1.22583 3.11116 0.00729 1.83421 0.8228 0.44572 3.10273 2.13626 0.13395 0.91136 3.21537 05/14/2019 38 30 8 377 1 0 377 08/15/2018 12 12 0 48 1 0 48 2017-05-10 6 3 3 1 44 0 44 211.833 0 10 1 38695.00 0 1   02/01/2020
10001 10001 1201 SD-71, Hot Springs, SD 57747, USA 43.4172935 -103.4799902 1 ROOFTOP 435072 SEVEN SISTERS LIVING CENTER 1201 HWY 71 SOUTH HOT SPRINGS SD 57747 6057453460 230 Fall River Non profit - Corporation 51 47.3 Medicare and Medicaid true FALL RIVER HEALTH SERVICES 08/01/1993 false   false false false Resident Yes 4   3   4   4     2 4   4       2.87511 0.6491 0.67082 1.31992 4.19504 0 1.89353 0.60946 0.26205 2.76504 3.15572 0.80085 0.9635 4.86505 08/21/2019 4 4 0 24 1 0 24 06/21/2018 5 5 0 24 1 0 24 2017-07-12 4 4 0 1 28 0 28 24.667 0 0 0 0.00 0 0   02/01/2020
10023 10023 7571 NY-54, Bath, NY 14810, USA 42.3741156 -77.2782591 1 ROOFTOP 335706 IRA DAVENPORT MEMORIAL HOSPITAL S N F/ H R F 7571 STATE ROUTE 54 BATH NY 14810 6077768500 690 Steuben Non profit - Corporation 120 101.9 Medicare and Medicaid true IRA DAVENPORT MEMORIAL HOSPITAL, INC. 10/02/1989 false   false false false Both Yes 2   2   4   4   3   3   3       2.25387 0.9944 0.48413 1.47853 3.7324 0.04621 2.09043 0.68472 0.33256 3.10771 2.24083 1.09203 0.54792 3.85124 04/11/2019 9 9 0 36 1 0 36 12/15/2017 12 10 2 52 1 0 52 2016-09-15 8 7 1 1 32 0 32 40.667 7 0 0 0.00 0 0   02/01/2020
10045 10045 2018 Pulliam St, San Angelo, TX 76905, USA 31.4708011 -100.4046882 1 ROOFTOP 455691 SHANNON MEDICAL CENTER 2018 PULLIAM SAN ANGELO TX 76903 3256536741 930 Tom Green Non profit - Corporation 28 17.3 Medicare true SHANNON MEDICAL CENTER 09/12/1986 false   false false false None Yes 5   5   5     2 5   5   5       3.09813 1.8883 3.35435 5.24265 8.34078 0.3756 1.87456 0.85773 0.49912 3.23142 3.43491 1.6554 2.52951 8.27688 12/11/2019 2 2 0 12 1 0 12 12/19/2018 1 1 0 8 1 0 8 2018-01-17 1 0 1 0 20 0 20 12 1 0 1 5000.00 0 1   02/01/2020
10450 10450 89-40 135th St, Jamaica, NY 11418, USA 40.7001767 -73.8165573 1 ROOFTOP 335436 JAMAICA HOSPITAL NURSING HOME CO INC 89-40 135TH STREET JAMAICA NY 11418 7182065000 590 Queens Non profit - Corporation 226 221.6 Medicare and Medicaid true JAMAICA HOSPITAL NURSING HOME CO INC 01/01/1975 false   false false false Resident Yes 5   5   5   5   5   2   3       1.98555 0.48679 0.62707 1.11386 3.09942 0.12783 2.21501 0.72647 0.3453 3.28679 1.86304 0.50386 0.68351 3.02385 12/20/2018 0 0 0 0 0 0 0 04/07/2017 0 0 0 0 0 0 0 2016-02-29 0 0 0 0 0 0 0 0 0 0 0 0.00 0 0   02/01/2020
11247 11247 631 N Broad St, Grove City, PA 16127, USA 41.1709935 -80.0852572 1 ROOFTOP 395990 TRANSITIONAL CARE CENTER AT GROVE CITY MED CTR,THE 631 NORTH BROAD ST GROVE CITY PA 16127 7244584845 530 Mercer For profit - Corporation 20 9.1 Medicare true TRANSITIONAL CARE CENTER LP 08/15/1996 false   false false false Resident Yes 5   4   5     2 5   5   5       2.7087 1.38478 3.56014 4.94493 7.65362 0.23617 2.26462 1.10625 0.63024 4.00111 2.48589 0.94126 2.12614 6.13394 04/05/2019 4 4 0 16 1 0 16 05/31/2018 2 2 0 16 1 0 16 2017-04-13 3 3 0 1 16 0 16 16 0 0 0 0.00 0 0   02/01/2020
11795 11795 20 E 5th St, Platte, SD 57369, USA 43.3859378 -98.8438144 1 ROOFTOP 43A072 PLATTE CARE CENTER 609 EAST 7TH POST OFFICE BOX 200 PLATTE SD 57369 6053373131 110 Charles Mix Non profit - Corporation 48 41.8 Medicaid true Legal Business Name Not Available 07/01/1982 false   false false false Resident Yes 5   4   5   5     2 4   5       2.45659 0.34692 0.7777 1.12462 3.58121 0 2.03681 0.60222 0.25875 2.89778 2.50667 0.43317 1.13125 3.96293 11/07/2018 5 5 0 32 1 0 32 08/09/2017 0 0 0 0 0 0 0 2016-06-22 5 5 0 1 24 0 24 20 0 0 0 0.00 0 0   02/01/2020
12005 12005 1 Nolte Dr, Kittanning, PA 16201, USA 40.8085788 -79.56145769999999 1 ROOFTOP 395890 SNU ARMSTRONG CO MEMORIAL HOSP ONE NOLTE DRIVE KITTANNING PA 16201 7245438458 70 Armstrong Non profit - Other 17 8.9 Medicare true ARMSTRONG COUNTY MEMORIAL HOSPITAL 02/23/1993 false   false false false None Yes 5   5   5     2 5   1 12 1 12 6 6                             09/06/2019 0 0 0 0 0 0 0 08/13/2018 1 1 0 16 1 0 16 2017-08-30 1 1 0 1 4 0 4 6 0 0 0 0.00 0 0   02/01/2020
12103 12103 42158 NY-28, Margaretville, NY 12455, USA 42.1460337 -74.6411869 1 ROOFTOP 335339 MOUNTAINSIDE RESIDENTIAL CARE CENTER 42158 STATE HIGHWAY 28 MARGARETVILLE NY 12455 8455861800 220 Delaware Non profit - Corporation 82 74.1 Medicare and Medicaid true MARGARETVILLE NURSING HOME INC 11/14/1971 true   false false false Both Yes 4   3   3   5   1   4   5       1.85601 0.81411 0.87559 1.6897 3.54571 0.05927 2.08799 0.65703 0.29247 3.03748 1.84743 0.93172 1.12682 3.7432 09/19/2019 5 5 0 20 1 0 20 03/29/2018 4 3 1 24 1 0 24 2016-08-25 0 0 0 0 0 0 0 18 1 0 0 0.00 0 0   02/01/2020
12336 12336 11600 Indian Hills Rd, Mission Hills, CA 91345, USA 34.2811443 -118.4577635 1 ROOFTOP 555074 PROVIDENCE HOLY CROSS MED CTR D/P SNF 11600A INDIAN HILLS ROAD, MISSION HILLS, CA 91345 MISSION HILLS CA 91345 8188984630 200 Los Angeles Non profit - Church related 48 39.4 Medicare and Medicaid true PROVIDENCE HEALTH SYSTEM - SOUTHERN CALIFORNIA 10/01/1978 false   false false false Both Yes 5   4   5   5     2 4   4       3.39428 1.23826 4.00196 5.24022 8.6345 0.04638 2.46639 1.13144 1.53199 5.12982 2.86023 0.82293 0.98322 5.39745 04/29/2019 8 8 0 52 1 0 52 04/22/2018 8 8 0 48 1 0 48 2017-04-23 8 8 0 1 40 0 40 48.667 0 0 0 0.00 0 0   02/01/2020
12774 12774 56-45 Main St, Queens, NY 11435, USA 40.7471198 -73.8253655 1 ROOFTOP 335862 NEW YORK-PRESBYTERIAN / QUEENS T C U 56-45 MAIN STREET FLUSHING NY 11355 9999999991 590 Queens Non profit - Corporation 16 16.2 Medicare true Legal Business Name Not Available 08/13/2012 false   false false false None Yes 5   5   5     2 5   4   5       1.13942 0.96102 1.85908 2.8201 3.95952 0.50047 2.40797 1.06477 0.54088 4.01362 0.98345 0.67867 1.29368 3.16344 11/27/2019 0 0 0 0 0 0 0 10/18/2018 2 2 0 4 1 0 4 2017-05-18 0 0 0 0 0 0 0 1.333 0 0 0 0.00 0 0   02/01/2020
12943 12943 4988 NY-30, Amsterdam, NY 12010, USA 42.9590921 -74.1872746 1 ROOFTOP 335857 WILKINSON RESIDENTIAL HEALTH CARE FACILITY 4988 STATE HWY 30 AMSTERDAM NY 12010 5188413572 380 Montgomery Non profit - Other 160 152.1 Medicare and Medicaid true ST. MARY'S HEALTHCARE 06/17/2009 false   false false false Resident Yes 5   3   5   5   5   4   4       2.17353 0.99325 0.62194 1.61519 3.78872 0.01194 2.15937 0.67917 0.32043 3.15897 2.09196 1.09967 0.73055 3.84592 11/20/2018 3 3 1 16 1 0 16 02/02/2017 3 3 0 20 1 0 20 2015-11-06 4 2 2 1 20 0 20 18 1 3 0 0.00 0 0   02/01/2020
13324 13324 1 Norton Ave, Oneonta, NY 13820, USA 42.4578897 -75.05229159999999 1 ROOFTOP 335204 AURELIA OSBORN FOX MEMORIAL HOSPITAL ONE NORTON AVENUE ONEONTA NY 13820 6074315980 570 Otsego Non profit - Corporation 131 126.2 Medicare and Medicaid true AURELIA OSBORN FOX MEMORIAL HOSPITAL STAMFORD 03/21/1967 false   false false false Resident Yes 3   2   5   5   5   2   2       2.11417 0.78143 0.41964 1.20107 3.31525 0.05346 2.11445 0.69649 0.34321 3.15415 2.07806 0.84364 0.46021 3.37044 10/31/2019 8 8 0 40 1 0 40 05/04/2018 10 10 0 52 1 0 52 2016-09-29 3 3 0 1 16 0 16 40 0 0 1 12025.00 0 1   02/01/2020
13417 13417 1111 Ln 12, Lovell, WY 82431, USA 44.8257945 -108.3906688 1 RANGE_INTERPOLATED 535030 NEW HORIZONS CARE CENTER 1111 LANE 12 LOVELL WY 82431 3075485200 10 Big Horn For profit - Corporation 85 69.2 Medicare and Medicaid true NORTH BIG HORN HOSPITAL 01/13/1988 false SFF Candidate true false false Both Yes 3   2   4   4     2 4   4       2.36082 0.55502 0.51573 1.07075 3.43157 0.00216 1.8243 0.60272 0.25791 2.68493 2.68956 0.69243 0.75265 4.09839 06/27/2019 12 11 1 84 1 0 84 05/17/2018 7 7 0 44 1 0 44 2017-04-06 19 15 4 1 116 0 116 76 1 4 2 114614.00 0 2   02/01/2020
13575 13575 2213 Ponce Bypass, Ponce, 00717, Puerto Rico 17.9970214 -66.6180176 1 ROOFTOP 405023 DAMAS HOSPITAL SNF 2213 PONCE BY PASS PONCE PR 717 7878408686 560 Ponce Non profit - Corporation 25 17.9 Medicare true HOSPITAL DAMAS INC 09/08/1988 false   false false false None Yes 5   3   5     2 5   5   5       0 0.91687 3.82047 4.73734 4.73734 0.92898 1.94753 0.99863 0.54979 3.49595 0 0.69038 2.61546 4.34532 03/28/2019 6 6 0 80 1 0 80 07/27/2018 4 4 0 16 1 0 16 2017-05-25 12 12 4 1 612 0 612 147.333 0 2 1 7150.00 0 1   02/01/2020
13778 13778 22691 Campus Dr, Watertown, NY 13601, USA 43.94879760000001 -75.9078681 1 ROOFTOP 335865 SAMARITAN SENIOR VILLAGE, INC 22691 CAMPUS DRIVE WATERTOWN NY 13601 3157826800 330 Jefferson Non profit - Corporation 168 165.3 Medicare and Medicaid true SAMARITAN SENIOR VILLAGE INC 04/05/2013 false   false false false Both Yes 2   2   4   3   5   3   2       2.50132 1.19364 0.3723 1.56594 4.06726 0.04209 2.1249 0.74294 0.36149 3.22933 2.4465 1.2081 0.38764 4.03871 10/11/2019 5 5 0 20 1 0 20 01/26/2018 5 5 0 24 1 0 24 2016-09-23 5 5 0 1 44 0 44 25.333 0 0 0 0.00 0 0   02/01/2020
14291 14291 235 Old Waterford Rd NW, Leesburg, VA 20176, USA 39.1205911 -77.5681802 1 ROOFTOP 495275 LOUDOUN NURSING AND REHAB CNTR 235 OLD WATERFORD ROAD, NORTHWEST LEESBURG VA 20176 7037712841 530 Loudoun Non profit - Corporation 100 91.3 Medicare and Medicaid true LOUDOUN NURSING AND REHABILIATION CENTER 04/01/1993 false   false false false Both Yes 5   3   5   5   5   5   5       2.18244 1.29593 1.23218 2.52811 4.71055 0.20651 2.24863 0.83024 0.38868 3.46756 2.01716 1.17371 1.1932 4.35614 03/21/2019 9 8 1 44 1 0 44 02/01/2018 9 9 0 40 1 0 40 2016-11-16 11 7 4 1 60 0 60 45.333 0 4 0 0.00 0 0   02/01/2020
14540 14540 1000 N Shenandoah Ave, Front Royal, VA 22630, USA 38.930951 -78.19865899999999 1 ROOFTOP 495316 WARREN MEMORIAL HOSP LYNN CARE 1000 SHENANDOAH AVENUE FRONT ROYAL VA 22630 5406360300 930 Warren Non profit - Corporation 120 116.8 Medicare and Medicaid true Legal Business Name Not Available 03/01/1997 false   false false false Resident Yes 4   4   4   4   4   2   2       2.42445 1.08263 0.53497 1.61761 4.04205 0.07715 2.09373 0.82055 0.40398 3.31826 2.40662 0.99211 0.49843 3.90611 05/23/2019 4 4 0 16 1 0 16 04/06/2018 11 11 0 56 1 0 56 2017-02-24 3 3 0 1 16 0 16 29.333 0 1 0 0.00 0 0   02/01/2020
14777 14777 Market St & N 39th St, Philadelphia, PA 19104, USA 39.9568765 -75.1996224 1 GEOMETRIC_CENTER 395749 PRESBYTERIAN CTR FOR CONT CARE 39TH AND MARKET STREETS PHILADELPHIA PA 19104 2156628186 620 Philadelphia Non profit - Corporation 25 17.6 Medicare true PRESBYTERIAN MEDICAL CENTER OF THE UNIVERSITY OF PENNSYLVANIA HEALTH S 02/01/1988 false   false false false None Yes 5   4   3     2 3   5   5       2.74769 0.27593 3.11755 3.39348 6.14116 0.7625 1.90399 0.95573 0.53656 3.39627 2.9993 0.21709 2.18689 5.79831 09/12/2019 7 7 0 28 1 0 28 10/11/2018 1 1 0 4 1 0 4 2017-09-08 3 3 0 1 12 0 12 17.333 0 0 0 0.00 0 0   02/01/2020
14786 14786 PR-844, San Juan, 00926, Puerto Rico 18.3551846 -66.0400062 1 GEOMETRIC_CENTER 405031 HIMA SAN PABLO CUPEY SNF CARR 844 KM 0 5 CUPEY BAJO RIO PIEDRAS PR 928 7877618383 640 San Juan For profit - Corporation 25 5 Medicare true CENTRO MEDICO DEL TURABO INC 06/06/2017 false   false false false None Yes 2   3   4     2 4   1 12 1 12 6 6                             05/16/2019 1 1 0 4 1 0 4 07/19/2018 6 6 0 52 1 0 52 2017-03-16 23 23 0 1 364 0 364 80 0 0 0 0.00 0 0   02/01/2020
15250 15250 N Sabana, Barrigada, 96913, Guam 13.489582 144.824937 1 GEOMETRIC_CENTER 655000 GUAM MEMORIAL HOSPITAL AUTHORITY 499 NORTH SABANA DRIVE BARRIGADA GU 96913 6716331800 10 Guam Government - State 42 18.8 Medicare and Medicaid true GUAM MEMORIAL HOSPITAL 01/01/1968 false   false false false Resident Yes 3   2   4     2 4   5   5       3.40017 1.70802 3.38434 5.09236 8.49253 0.2073 1.89652 0.73503 0.50271 3.13425 3.72615 1.74733 2.53388 8.68872 01/30/2019 13 13 0 60 1 0 60 08/24/2017 11 11 0 64 1 0 64 2016-09-29 19 19 0 1 200 0 200 84.667 0 0 0 0.00 0 0   02/01/2020
15408 15408 WI-77, Hayward, WI, USA 46.01939489999999 -91.4771351 1 GEOMETRIC_CENTER 525632 WATER'S EDGE 11040 NORTH STATE RD 77 HAYWARD WI 54843 7159344321 560 Sawyer Non profit - Corporation 50 47.1 Medicare and Medicaid true MEDICAL SERVICES, INC 11/01/1997 false   false false false Resident Yes 4   5   1   1   1   5   5       2.88671 0.32866 0.98471 1.31337 4.20007 0.1179 2.05336 0.66599 0.30361 3.02297 2.92182 0.37107 1.22073 4.4553 03/05/2019 0 0 0 0 0 0 0 01/05/2018 3 3 0 12 1 0 12 2017-03-23 0 0 0 0 0 0 0 4 0 0 0 0.00 0 0   02/01/2020
15427 15427 51 Rte 9W, West Haverstraw, NY 10993, USA 41.214151 -73.988535 1 ROOFTOP 335873 HELEN HAYES HOSPITAL T C U 51 N ROUTE 9W WEST HAVERSTRAW NY 10993 8457864000 620 Rockland Government - State 24 17.7 Medicare true STATE OF NEW YORK COMPTROLLERS OFFICE 08/10/2016 false   false false false None Yes 5   4   5     2 5   5   5       3.77007 0.12108 3.23815 3.35923 7.1293 1.05954 2.21321 1.10908 0.68151 4.0038 3.54032 0.08209 1.78836 5.70989 05/07/2018 2 2 0 8 0 0 8 04/13/2017 1 1 0 4 1 0 4 2016-08-10 0 0 0 0 0 0 0 5.333 0 0 1 4475.00 0 1   02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);