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

27 rows where Health Inspection Rating = 3 and geocode_accuracy = "GEOMETRIC_CENTER"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: prvdr_city, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Legal Business Name, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, 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 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 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, 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
36 36 905 US-127, Owenton, KY 40359, USA 38.5470262 -84.84262 1 GEOMETRIC_CENTER 185364 OWENTON CENTER 905 HWY 127 NORTH OWENTON KY 40359 5024845721 930 Owen For profit - Corporation 100 92.8 Medicare and Medicaid false OWENTON MANOR NURSING, LLC 01/21/1993 false   false false false Resident Yes 3   3   2   2   3   3   3       2.12006 0.5786 0.54371 1.12231 3.24237 0.05767 1.99706 0.72374 0.35697 3.07776 2.20635 0.60114 0.57328 3.37816 08/23/2018 4 4 0 20 1 0 20 06/22/2017 2 1 1 20 1 0 20 2016-04-28 8 8 0 1 44 0 44 24 0 0 0 0.00 0 0   02/01/2020
323 323 W Sullivan Rd, Aurora, IL 60506, USA 41.7894852 -88.3779426 1 GEOMETRIC_CENTER 145944 PRESENCE MCAULEY MANOR 400 WEST SULLIVAN ROAD AURORA IL 60506 6308593700 530 Kane Non profit - Corporation 87 45.9 Medicare and Medicaid false PRESENCE LIFE CONNECTIONS 10/16/1997 false   false false false Resident Yes 4   3   4   4   5   4   5       1.91052 0.05215 1.89617 1.94832 3.85884 0.11282 2.2162 0.79019 0.35109 3.35748 1.79167 0.04963 2.0328 3.6855 04/18/2019 7 7 0 40 1 0 40 05/10/2018 12 10 2 88 1 0 88 2017-06-09 6 5 1 1 28 0 28 54 0 3 0 0.00 0 0   02/01/2020
949 949 60 N. Highway 17-92, DeBary, FL 32713, USA 28.893402 -81.30668399999999 1 GEOMETRIC_CENTER 105514 DEBARY HEALTH AND REHABILITATION CENTER 60 N HWY 17/92 DEBARY FL 32713 3866684426 630 Volusia For profit - Corporation 120 115 Medicare and Medicaid false MF DEBARY LLC 07/01/1985 false   false false false Both Yes 4   3   5   5   5   3   3       2.62896 0.86506 0.67336 1.53843 4.16738 0.05797 2.14731 0.74384 0.34966 3.24082 2.54451 0.87448 0.72482 4.12346 10/18/2018 10 9 1 44 1 0 44 08/10/2017 5 5 0 20 1 0 20 2016-06-30 5 5 0 1 24 0 24 32.667 1 0 0 0.00 0 0   02/01/2020
1199 1199 E Creek Rd, Nantucket, MA 02554, USA 41.274316 -70.090683 1 GEOMETRIC_CENTER 225772 OUR ISLAND HOME EAST CREEK ROAD NANTUCKET MA 2554 5082280462 120 Nantucket Government - City/county 45 39.4 Medicare and Medicaid false TOWN OF NANTUCKET 08/01/2007 false   false false false Both Yes 3   3   1   3   1   4   4       2.46416 0.79923 0.79774 1.59696 4.06112 0.03251 1.96195 0.66605 0.29099 2.91899 2.61034 0.90229 1.03183 4.46135 02/27/2019 5 5 0 20 1 0 20 11/09/2017 5 5 0 40 1 0 40 2016-09-27 6 6 0 1 36 0 36 29.333 0 0 1 8778.00 0 1   02/01/2020
1328 1328 Elders Drive 7835 State Highway 87, Rushville, NE 69360, USA 42.9911956 -102.5576171 1 GEOMETRIC_CENTER 2.8e+301 OGLALA SIOUX LAKOTA NURSING HOME 7835 ELDERS DRIVE, STATE HIGHWAY 87 RUSHVILLE NE 69360 3088624020 800 Sheridan Non profit - Corporation 60 37.2 Medicaid false Legal Business Name Not Available 11/11/2016 false   false false false Resident Yes 4   3   2   2     2 4   4       3.61864 0.31798 0.59854 0.91652 4.53516 0 1.76159 0.6139 0.24101 2.6165 4.2693 0.38948 0.93473 5.55808 10/16/2018 9 8 1 40 1 0 40 11/16/2017 11 10 5 56 1 0 56 2016-11-08 1 1 0 1 16 0 16 41.333 4 1 0 0.00 0 0   02/01/2020
2752 2752 Indian Hills Dr, Macy, NE 68039, USA 42.1187092 -96.35944669999999 1 GEOMETRIC_CENTER 28A065 CARL T CURTIS HEALTH EDUCATION CENTER NURSING HOME P O BOX 250 MACY NE 68039 4028375381 860 Thurston Non profit - Other 25 20.8 Medicaid false Legal Business Name Not Available 10/02/1990 false   false false false Resident Yes 2   3   2   2     2 1 12 1 12 6 6                             11/01/2018 1 1 0 16 1 0 16 10/16/2017 11 10 11 108 1 0 108 2016-07-06 1 1 0 1 4 0 4 44.667 2 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
3516 3516 Cartwright Ln, Columbia, MO 65201, USA 38.9069723 -92.2908662 1 GEOMETRIC_CENTER 265639 LENOIR HEALTH CARE CENTER 3850 CARTWRIGHT LANE COLUMBIA MO 65201 5738765800 90 Boone Non profit - Corporation 46 36.4 Medicare and Medicaid false LUTHERAN SENIOR SERVICES 02/21/1996 true   false false false Resident Yes 4   3   4   4   4   5   5       2.46838 1.3566 1.2082 2.5648 5.03318 0.1135 2.09044 0.74769 0.37829 3.21642 2.45408 1.36432 1.20211 5.01791 11/02/2018 11 10 1 72 1 0 72 10/20/2017 3 3 0 16 1 0 16 2016-08-18 0 0 0 0 0 0 0 41.333 0 1 0 0.00 0 0   02/01/2020
4632 4632 IL-17, Toulon, IL, USA 41.0939546 -89.8648142 1 GEOMETRIC_CENTER 145442 TOULON REHAB & HEALTH CARE CENTER HIGHWAY 17 EAST P O BOX 209 TOULON IL 61483 3092862631 960 Stark For profit - Corporation 136 72.4 Medicare and Medicaid false PETERSEN MANAGEMENT COMPANY, LLC 02/01/1982 false   false false false Both Yes 2   3   2   3   1   1   1       1.49325 0.87646 0.18028 1.05674 2.54999 0.01228 2.03051 0.72383 0.32104 3.07539 1.52842 0.9105 0.21135 2.65883 09/25/2019 3 3 0 28 1 0 28 08/24/2018 9 9 0 48 1 0 48 2017-10-05 10 9 1 1 56 0 56 39.333 0 1 0 0.00 0 0   02/01/2020
4728 4728 Cal Hill Spur, Pine Knot, KY, USA 36.6543057 -84.43773399999999 1 GEOMETRIC_CENTER 185211 SIGNATURE HEALTHCARE OF MCCREARY COUNTY REHAB & WE 58 CAL HILL ROAD PINE KNOT KY 42635 6063543155 730 Mc Creary For profit - Corporation 60 53.7 Medicare and Medicaid false LP PINE KNOT LLC 09/04/1990 false   false false false Resident Yes 2   3   1   1   1   2   2       2.2067 0.91642 0.51546 1.43188 3.63858 0.03713 2.32344 0.90541 0.41908 3.64793 1.97391 0.76108 0.46295 3.19844 05/02/2019 6 4 2 28 1 0 28 03/01/2018 3 3 0 12 1 0 12 2016-12-07 12 12 0 1 56 0 56 27.333 1 0 0 0.00 0 0   02/01/2020
5149 5149 Residential Center Rd, Pearl River, MS 39350, USA 32.7806736 -89.22993869999999 1 GEOMETRIC_CENTER 255339 CHOCTAW RESIDENTIAL CENTER 135 RESIDENTIAL CENTER RD CHOCTAW MS 39350 6016562582 490 Neshoba Government - Federal 120 99.1 Medicare and Medicaid false MISSISSIPPI BAND OF CHOCTAW INDIANS 08/25/2013 false   false false false Resident Yes 2   3   1   2   1   3   2       2.44975 1.08068 0.35221 1.43289 3.88264 0.02027 2.00511 0.68147 0.3082 2.99479 2.53921 1.19244 0.43013 4.15733 12/07/2018 4 4 0 16 1 0 16 08/11/2017 4 4 0 28 1 0 28 2016-09-14 9 8 1 1 44 0 44 24.667 1 0 0 0.00 0 0   02/01/2020
5771 5771 Deaconess Rd, Concord, MA 01742, USA 42.4513243 -71.37698940000001 1 GEOMETRIC_CENTER 225080 RIVERCREST LONG TERM CARE DEACONESS ROAD W CONCORD MA 1742 9783695151 90 Middlesex Non profit - Corporation 108 43.4 Medicare and Medicaid false NEW ENGLAND DEACONESS ASSOCIATION 01/01/1967 true   false false false Resident Yes 4   3   3   4   2   4   5       2.04729 0.69959 0.98974 1.68933 3.73661 0.16561 2.06101 0.72463 0.33912 3.12476 2.0645 0.72595 1.0985 3.83455 02/13/2019 9 9 0 36 1 0 36 10/25/2017 4 4 0 20 1 0 20 2016-09-22 3 3 0 1 16 0 16 27.333 0 0 0 0.00 0 0   02/01/2020
6651 6651 Scott Swamp Rd, Farmington, CT 06032, USA 41.7051006 -72.8674315 1 GEOMETRIC_CENTER 75251 TOUCHPOINTS AT FARMINGTON SCOTT SWAMP RD FARMINGTON CT 6032 8606777707 10 Hartford For profit - Limited Liability company 105 91.2 Medicare and Medicaid false FARMINGTON CARE CENTER, LLC 03/01/1976 false   false false false Resident Yes 4   3   5   5   5   2   2       1.72482 0.86882 0.47339 1.3422 3.06702 0.18913 2.05468 0.71233 0.35976 3.12677 1.74468 0.91713 0.49526 3.14539 05/23/2019 15 15 4 56 1 0 56 03/29/2018 6 6 0 24 1 0 24 2017-04-20 8 8 0 1 32 0 32 41.333 1 2 0 0.00 0 0   02/01/2020
6840 6840 1156 KS-14, Ellsworth, KS 67439, USA 38.7177013 -98.2356538 1 GEOMETRIC_CENTER 175231 GOOD SAMARITAN SOCIETY - ELLSWORTH VILLAGE 1156 HIGHWAY 14 ELLSWORTH KS 67439 7854723167 260 Ellsworth Non profit - Corporation 45 43.1 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 11/01/1992 false   false false false Both Yes 3   3   4   3   5   3   3       2.21339 0.47486 0.5175 0.99235 3.20574 0.01505 2.0437 0.7323 0.33124 3.10724 2.2509 0.48759 0.58802 3.30831 12/11/2019 0 0 0 0 0 0 0 12/17/2018 8 7 1 139 1 0 139 2017-08-10 6 6 6 1 44 0 44 53.667 1 1 2 23121.00 1 3   02/01/2020
8671 8671 301 S, Co Rd 12B, Park River, ND 58270, USA 48.3962509 -97.7550294 1 GEOMETRIC_CENTER 355089 GOOD SAMARITAN SOCIETY - PARK RIVER 301 SOUTH COUNTY ROAD 12B PARK RIVER ND 58270 7012847115 490 Walsh Non profit - Corporation 54 49.3 Medicare and Medicaid false THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY 01/01/1984 false   false false false Resident Yes 4   3   2   2     2 4   4       2.71007 0.67207 0.63109 1.30317 4.01324 0.01088 1.8945 0.63502 0.25837 2.78789 2.97305 0.79582 0.91937 4.61608 11/21/2019 7 7 0 36 1 0 36 10/31/2018 5 5 0 24 1 0 24 2017-10-18 2 2 0 1 4 0 4 26.667 0 0 0 0.00 0 0   02/01/2020
9228 9228 1114 Neighborhood Dr, Batavia, OH 45103, USA 39.0746553 -84.24747099999999 1 GEOMETRIC_CENTER 366439 OTTERBEIN UNION TOWNSHIP 1114 NEIGHBORHOOD DRIVE BATAVIA OH 45103 5139335409 120 Clermont Non profit - Church related 50 46.5 Medicare and Medicaid false OTTERBEIN BATAVIA LLC 02/26/2016 false   false false false Resident Yes 4   3   3   2   3   4   4       4.27654 0.44709 0.89523 1.34233 5.61887 0.09998 2.19404 0.81937 0.44366 3.45708 4.05101 0.4103 0.75947 5.21186 07/31/2019 6 6 0 36 1 0 36 07/19/2018 4 4 0 20 1 0 20 2017-05-18 2 2 0 1 12 0 12 26.667 0 0 0 0.00 0 0   02/01/2020
9338 9338 San Lucas, Calle San Cosme, San Juan, 00926, Puerto Rico 18.3442773 -66.0857003 1 GEOMETRIC_CENTER 405030 MILLENNIUM INSTITUTE FOR ADVANCE NURSING CARE INC CALLE COSME REPARTO SAN LUCAS ENTRADA SECTOR CANEJ RIO PIEDRAS PR 926 7877080138 640 San Juan For profit - Corporation 35   Medicare false MILLENNIUM INSTITUTE FOR ADVANCE NURSING CARE INC. 02/12/2015 false   false false false None Yes 2   3   4     2 4   1 12 1 12 6 6                             03/13/2019 10 10 0 104 1 0 104 08/24/2018 2 2 0 16 1 0 16 2017-05-26 12 12 0 1 136 0 136 80 0 0 1 5551.00 0 1   02/01/2020
9673 9673 Howison Cir, Menomonie, WI 54751, USA 44.888394 -91.891125 1 GEOMETRIC_CENTER 525713 NEIGHBORS - EAST NEIGHBORHOOD (THE) 658 HOWISON CIRCLE MENOMONIE WI 54751 7152322661 160 Dunn Government - County 46 44.7 Medicare and Medicaid false COUNTY OF DUNN 10/01/2013 false   false false false Resident Yes 5   3   5   5     2 5   5       2.95315 0.34189 0.8322 1.17409 4.12724 0.0033 1.97615 0.62033 0.26354 2.86003 3.10586 0.41443 1.18852 4.62746 06/12/2019 5 5 0 24 1 0 24 04/19/2018 0 0 0 0 0 0 0 2017-06-07 8 5 3 1 52 0 52 20.667 0 1 1 23230.00 0 1   02/01/2020
12343 12343 Bradley Ave, Mt Vernon, NY 10552, USA 40.9191878 -73.8149409 1 GEOMETRIC_CENTER 335269 THE WARTBURG HOME BRADLEY AVENUE MOUNT VERNON NY 10552 9146990800 800 Westchester Non profit - Corporation 240 200.2 Medicare and Medicaid false WARTBURG HOME OF THE EVANGELICAL LUTHERAN CHURCH 06/07/1968 false   false false false Both Yes 4   3   5   5   5   3   3       2.65071 0.72434 0.62529 1.34962 4.00034 0.22965 2.20792 0.80977 0.42859 3.44628 2.49513 0.67261 0.54912 3.72219 10/04/2019 7 7 0 32 1 0 32 01/16/2018 4 4 0 16 1 0 16 2016-09-23 0 0 0 0 0 0 0 21.333 0 0 0 0.00 0 0   02/01/2020
12357 12357 US-69 & 6th St, Oklahoma 74339, USA 36.939885 -94.86741339999999 1 GEOMETRIC_CENTER 375529 EASTWOOD MANOR 6TH AND HIGHWAY 69 COMMERCE OK 74339 9186754455 570 Ottawa For profit - Individual 80 74.3 Medicare and Medicaid false EASTWOOD MANOR, LLC 07/25/2008 false   false false false Both Yes 1   3   1   1   1   1 12 1 12     2.724 0.79713 0.41802 1.21515 3.93915 0.07194 1.95752 0.71327 0.3342 3.00499 2.89212 0.84036 0.47078 4.20352 11/18/2019 6 6 0 48 0 0 48 09/10/2018 8 8 0 60 1 0 60 2017-06-13 9 9 0 1 56 0 56 53.333 0 0 0 0.00 0 0   02/01/2020
12497 12497 TX-121, Athens, TX 75751, USA 32.2048735 -95.8555207 1 GEOMETRIC_CENTER 675424 ADVANCED REHABILITATION AND HEALTHCARE OF ATHENS 121 COMMONS DRIVE ATHENS TX 75751 9036773434 640 Henderson For profit - Corporation 114 64.4 Medicare and Medicaid false Legal Business Name Not Available 11/04/1994 false   false false false Resident Yes 3   3   3   4   2   2   2       1.72719 0.80133 0.42646 1.22779 2.95498 0.12036 1.95047 0.77349 0.40911 3.13307 1.84042 0.779 0.39235 3.02438 12/12/2018 8 4 4 60 1 0 60 12/07/2017 3 3 0 32 1 0 32 2016-11-09 2 2 0 1 24 0 24 44.667 0 5 0 0.00 0 0   02/01/2020
12541 12541 NY-100, Somers, NY 10589, USA 41.29375599999999 -73.705187 1 GEOMETRIC_CENTER 335261 THE PARAMOUNT AT SOMERS REHAB AND NURSING CENTER ROUTE 100 SOMERS NY 10589 9142325101 800 Westchester For profit - Corporation 300 284.1 Medicare and Medicaid false SOMERS OPERATING LLC 07/01/1970 false   false false false Both Yes 4   3   5   5   4   2   2       1.73947 0.65811 0.53796 1.19607 2.93554 0.13697 2.11871 0.91794 0.51267 3.54932 1.70632 0.5391 0.39495 2.65214 02/13/2019 6 5 1 32 1 0 32 06/05/2017 1 0 1 4 0 0 4 2016-03-22 3 3 0 1 12 0 12 19.333 0 3 0 0.00 0 0   02/01/2020
13376 13376 Gracedale Ave, Nazareth, PA 18064, USA 40.7380705 -75.3295748 1 GEOMETRIC_CENTER 395476 NORTHAMPTON COUNTY-GRACEDALE GRACEDALE AVENUE NAZARETH PA 18064 6107461900 590 Northampton Government - City/county 688 649.3 Medicare and Medicaid false COUNTY OF NORTHAMPTON 11/01/1980 false   false false false Both Yes 2   3   1   1   1   2   2       1.87815 0.85365 0.40697 1.26063 3.13878 0.0411 1.99103 0.70291 0.34361 3.03755 1.96051 0.91319 0.44579 3.31353 12/14/2018 13 11 2 52 1 0 52 11/17/2017 5 3 2 24 1 0 24 2017-01-13 10 9 1 2 40 20 60 44 0 5 0 0.00 0 0   02/01/2020
13775 13775 W Barlow Rd, Ohio 44236, USA 41.2251983 -81.49494990000001 1 GEOMETRIC_CENTER 366404 HERITAGE OF HUDSON 1212 WEST BARLOW ROAD HUDSON OH 44236 3306500023 780 Summit For profit - Corporation 80 73 Medicare and Medicaid false HUDSON HEALTH AND REHABILITATION CENTER INC 03/19/2013 false   false false false Resident Yes 3   3   2   3   2   2   3       1.79527 0.79276 0.58743 1.38019 3.17546 0.02912 2.25809 0.84318 0.42547 3.52674 1.65235 0.70698 0.51966 2.88726 02/28/2019 6 6 0 48 1 0 48 01/05/2018 0 0 0 0 0 0 0 2016-12-01 5 3 2 1 28 0 28 28.667 0 2 0 0.00 0 0   02/01/2020
14235 14235 264 us-6, Milford, PA 18337, USA 41.3484928 -74.74256439999999 1 GEOMETRIC_CENTER 395466 MILFORD HEALTHCARE AND REHABILITATION CENTER 264 ROUTE 6 & 209 MILFORD PA 18337 5704914121 630 Pike For profit - Corporation 80 76.5 Medicare and Medicaid false MILFORD VALLEY CONVALESCENT HOME INC 04/01/1980 false   false false false Both Yes 3   3   3   4   3   2   2       1.60325 0.81973 0.58991 1.40965 3.0129 0.08546 2.23855 0.9027 0.51163 3.65288 1.4885 0.68283 0.43398 2.64486 09/06/2019 7 5 2 40 1 0 40 08/10/2018 6 6 2 40 2 20 60 2017-09-01 7 6 1 2 32 16 48 48 0 4 0 0.00 0 0   02/01/2020
14749 14749 864 US Hwy. 158 Business West, Warrenton, NC 27589, USA 36.4181945 -78.1706755 1 GEOMETRIC_CENTER 345240 WARREN HILLS NURSING CENTER 864 US HWY 158 BUSINESS WEST WARRENTON NC 27589 2522572011 920 Warren For profit - Corporation 140 97.9 Medicare and Medicaid false LIBERTY HEALTHCARE GROUP, LLC 12/01/1983 false   false false false Resident Yes 1   3   1   1   2   1 12 1 12     2.2411 0.86724 0.18025 1.04748 3.28859 0.05449 2.11526 0.68707 0.30421 3.10654 2.20198 0.94912 0.22301 3.39458 08/29/2019 6 6 0 12 1 0 12 08/30/2018 6 6 0 32 1 0 32 2017-08-24 6 5 6 1 40 0 40 23.333 0 3 1 9592.00 0 1   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

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