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

41 rows where Health Inspection Rating = 4 and Rating Cycle 1 Total Number of Health Deficiencies = 12

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Health Revisit Score, Rating Cycle 3 Total Health Score, Total Weighted Health Survey Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of 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
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
100 100 Fort Ashby, WV 26719, USA 39.5031465 -78.76862969999999 1 APPROXIMATE 515163 DAWN VIEW CENTER PO BOX 686 FORT ASHBY WV 26719 3042983602 280 Mineral For profit - Corporation 66 61.7 Medicare and Medicaid false DIANE DRIVE OPERATIONS LLC 06/15/1998 false   false false false Both Yes 3   4   1   2   1   2   2       2.04317 0.51817 0.62891 1.14708 3.19025 0.03909 2.11175 0.83981 0.47504 3.4266 2.01084 0.46395 0.4983 2.98548 06/06/2019 12 12 0 76 1 0 76 02/15/2018 6 6 0 24 1 0 24 2017-01-06 2 2 0 1 12 0 12 48 0 0 0 0.00 0 0   02/01/2020
136 136 520 KERR AVENUE DENTON, MD 21629 38.87852 -75.824963 0   215083 CAROLINE CENTER FOR REHABILITATION AND HEALTHCARE 520 KERR AVENUE DENTON MD 21629 4104792130 50 Caroline For profit - Limited Liability company 87 83 Medicare and Medicaid false AXIS HEALTH AT CAROLINE OPCO LLC 12/13/1971 false   false false false Resident Yes 5   4   5   4   5   3   3       2.08019 0.68257 0.52321 1.20578 3.28597 0.07733 2.181 0.77161 0.3869 3.33952 1.98227 0.66517 0.50899 3.15524 10/11/2019 12 11 5 52 1 0 52 05/18/2018 10 7 3 44 1 0 44 2017-03-02 4 4 0 1 20 0 20 44 2 3 0 0.00 0 0 520 KERR AVENUE DENTON, MD 21629 (38.87852, -75.824963) 02/01/2020
201 201 3232 THUNDER DRIVE OCEANSIDE, CA 92056 33.187154 -117.288248 0   55335 LA PALOMA HEALTHCARE CENTER 3232 THUNDER DRIVE OCEANSIDE CA 92056 7607242193 470 San Diego For profit - Corporation 93 91.3 Medicare and Medicaid false ITALIAN MAPLE HOLDINGS LLC 01/01/1967 false   false false false Resident Yes 5   4   5   5   4   2   2       2.12569 1.07474 0.46775 1.54249 3.66818 0.2595 2.17698 0.74068 0.37118 3.28884 2.02937 1.09107 0.47431 3.57652 04/26/2019 12 12 0 64 1 0 64 04/20/2018 5 3 2 20 1 0 20 2017-02-02 3 2 1 1 12 0 12 40.667 0 5 0 0.00 0 0 3232 THUNDER DRIVE OCEANSIDE, CA 92056 (33.187154, -117.288248) 02/01/2020
596 596 3551 WEST OLYMPIC BLVD LOS ANGELES, CA 90019 34.052514 -118.316701 0   56293 ALCOTT REHABILITATION HOSPITAL 3551 WEST OLYMPIC BLVD. LOS ANGELES CA 90019 3237372000 200 Los Angeles For profit - Corporation 121 114.6 Medicare and Medicaid false INLAND MEDICAL ENTERPRISES INC 09/01/1977 false   false false false Resident Yes 4   4   5   5   5   1 12 1 12     2.01651 0.62769 0.56972 1.19741 3.21392 0.12148 2.30266 0.77918 0.36444 3.44628 1.82006 0.60574 0.58839 2.99045 01/28/2019 12 10 2 64 1 0 64 02/18/2018 7 7 1 24 1 0 24 2017-02-15 7 7 0 1 24 0 24 44 1 1 0 0.00 0 0 3551 WEST OLYMPIC BLVD LOS ANGELES, CA 90019 (34.052514, -118.316701) 02/01/2020
803 803 1911 OAK PARK BOULEVARD PLEASANT HILL, CA 94523 37.933692 -122.074713 0   56476 WINDSOR ROSEWOOD CARE CENTER 1911 OAK PARK BOULEVARD PLEASANT HILL CA 94523 9259356630 60 Contra Costa For profit - Limited Liability company 113 102.5 Medicare and Medicaid false WINDSOR ROSEWOOD CARE CENTER, LLC 07/01/1977 false   false false false Resident Yes 3   4   1   1   1   3   3       2.22383 1.29507 0.82219 2.11726 4.34109 0.0563 2.22009 0.854 0.59287 3.66696 2.08184 1.14029 0.52197 3.79617 02/01/2019 12 12 0 48 1 0 48 02/08/2018 7 4 3 20 1 0 20 2017-02-17 13 12 2 1 68 0 68 42 2 2 0 0.00 0 0 1911 OAK PARK BOULEVARD PLEASANT HILL, CA 94523 (37.933692, -122.074713) 02/01/2020
1303 1303 622 SOUTH ANZA STREET EL CAJON, CA 92020 32.789485 -116.948196 0   55806 VILLA LAS PALMAS HEALTHCARE CENTER 622 SOUTH ANZA STREET EL CAJON CA 92020 6194420544 470 San Diego For profit - Corporation 151 141.2 Medicare and Medicaid false JEFFREY PINE HOLDINGS LLC 08/17/1967 false   false false false Resident Yes 5   4   5   5   5   3   3       2.32608 0.88747 0.72085 1.60831 3.9344 0.13588 2.11991 0.73214 0.43869 3.29075 2.28046 0.91146 0.61846 3.83386 03/22/2019 12 10 3 48 1 0 48 03/26/2018 10 6 4 48 1 0 48 2016-12-15 13 11 2 1 60 0 60 50 5 3 0 0.00 0 0 622 SOUTH ANZA STREET EL CAJON, CA 92020 (32.789485, -116.948196) 02/01/2020
1892 1892 812 WEST MAIN STREET TURLOCK, CA 95380 37.492695 -120.858576 0   55475 MAIN WEST POSTACUTE CARE 812 WEST MAIN STREET TURLOCK CA 95380 2096672828 600 Stanislaus For profit - Corporation 99 91.5 Medicare and Medicaid false VISTA DEL SOL POSTACUTE CARE 01/01/1967 false   false false false Resident Yes 3   4   4   4   3   1 12 1 12 6 6                             01/11/2019 12 11 2 56 1 0 56 10/13/2017 8 6 3 32 1 0 32 2016-07-29 5 4 1 1 20 0 20 42 8 6 0 0.00 0 0 812 WEST MAIN STREET TURLOCK, CA 95380 (37.492695, -120.858576) 02/01/2020
2149 2149 10410 COLOMA RD RANCHO CORDOVA, CA 95670 38.598075 -121.303395 0   56495 CASA COLOMA HEALTH CARE CENTER 10410 COLOMA RD RANCHO CORDOVA CA 95670 9163634843 440 Sacramento For profit - Partnership 138 123.1 Medicare and Medicaid false ABCD ASSOCIATES 11/19/1975 false   false false false Resident Yes 5   4   5   5   5   4   4       2.70438 0.87791 0.52057 1.39848 4.10286 0 2.05206 0.63333 0.26714 2.95252 2.73901 1.04233 0.73345 4.45601 04/11/2019 12 11 1 44 1 0 44 04/12/2018 10 10 0 44 1 0 44 2017-04-06 6 6 0 1 44 0 44 44 0 2 0 0.00 0 0 10410 COLOMA RD RANCHO CORDOVA, CA 95670 (38.598075, -121.303395) 02/01/2020
2401 2401 2131 O STREET NW WASHINGTON, DC 20037 38.908579 -77.047979 0   95031 INSPIRE REHABILITATION AND HEALTH CENTER LLC 2131 O STREET NW WASHINGTON DC 20037 2027852577 0 The District For profit - Corporation 180 170.7 Medicare and Medicaid false INSPIRE REHABILITATION AND HEALTH CENTER LLC 03/21/1995 false   false false false Resident Yes 5   4   5   5   5   4   4       2.39253 0.8931 0.87046 1.76356 4.15609 0.08042 2.00902 0.80543 0.43335 3.24779 2.47508 0.83379 0.75604 4.10346 03/05/2019 12 12 0 72 1 0 72 01/16/2018 11 11 0 68 1 0 68 2016-12-16 5 5 0 1 32 0 32 64 0 0 0 0.00 0 0 2131 O STREET NW WASHINGTON, DC 20037 (38.908579, -77.047979) 02/01/2020
2738 2738 57 JACKSON STREET LONACONING, MD 21539 39.563065 -78.979002 0   215307 EGLE NURSING HOME 57 JACKSON STREET LONACONING MD 21539 3014635451 0 Allegany For profit - Corporation 66 61.1 Medicare and Medicaid false EGLE NURSING HOME MANAGEMENT INC 07/11/1997 false   false false false Resident Yes 4   4   4   3   5   4   4       2.62625 0.5983 0.91036 1.50866 4.13492 0.02792 2.14425 0.77863 0.40643 3.32931 2.54553 0.57779 0.84305 3.98259 05/16/2019 12 10 3 64 1 0 64 12/14/2017 4 4 0 28 1 0 28 2017-01-11 5 2 3 1 20 0 20 44.667 9 1 0 0.00 0 0 57 JACKSON STREET LONACONING, MD 21539 (39.563065, -78.979002) 02/01/2020
3190 3190 40 SUNSET AVENUE LENOX, MA 01240 42.359087 -73.288591 0   225764 KIMBALL FARMS NURSING CARE CENTER 40 SUNSET AVENUE LENOX MA 1240 4136375011 10 Berkshire Non profit - Corporation 74 71.5 Medicare and Medicaid false BERKSHIRE EXTENDED CARE SERVICES INC 05/06/2002 true   false false false Resident Yes 5   4   5   5   5   4   4       2.13519 1.05856 0.80351 1.86207 3.99726 0.07795 2.26537 0.74294 0.35254 3.36084 1.95891 1.07139 0.85785 3.81388 04/16/2019 12 12 0 36 1 0 36 12/13/2017 2 2 0 12 1 0 12 2016-09-27 4 2 2 1 20 0 20 25.333 1 0 0 0.00 0 0 40 SUNSET AVENUE LENOX, MA 01240 (42.359087, -73.288591) 02/01/2020
3675 3675 3315 8TH STREET LEWISTON, ID 83501 46.382763 -116.991451 0   135021 LEWISTON TRANSITIONAL CARE OF CASCADIA 3315 8TH STREET LEWISTON ID 83501 2087439543 340 Nez Perce For profit - Corporation 96 60.7 Medicare and Medicaid false LEWISTON OF CASCADIA, LLC 09/01/1972 false   false false false Resident Yes 4   4   3   2   4   4   4       2.31172 0.6921 0.78628 1.47839 3.7901 0.10033 2.08349 0.733 0.35855 3.17504 2.306 0.70999 0.82539 3.82785 07/27/2018 12 12 2 64 1 0 64 09/22/2016 4 4 0 16 1 0 16 2015-06-19 10 10 0 1 44 0 44 44.667 0 1 1 25561.00 0 1 3315 8TH STREET LEWISTON, ID 83501 (46.382763, -116.991451) 02/01/2020
3990 3990 516 WILLOW STREET ALAMEDA, CA 94501 37.760042 -122.254987 0   56348 BAY VIEW REHABILITATION HOSPITAL, LLC 516 WILLOW STREET ALAMEDA CA 94501 5105215600 0 Alameda For profit - Corporation 180 165.6 Medicare and Medicaid false BAY VIEW REHABILITATION HOSPITAL LLC 08/31/1972 false   false false false Both Yes 5   4   5   5   3   2   2       2.28565 1.00697 0.34306 1.35003 3.63568 0.08131 1.99053 0.72468 0.35334 3.06855 2.38647 1.04485 0.36543 3.79932 03/29/2019 12 7 5 52 1 0 52 04/26/2018 11 6 5 36 1 0 36 2017-04-13 14 12 2 1 64 0 64 48.667 3 11 0 0.00 0 0 516 WILLOW STREET ALAMEDA, CA 94501 (37.760042, -122.254987) 02/01/2020
4508 4508 1514 E LINCOLN AVENUE ANAHEIM, CA 92805 33.839411 -117.896867 0   55671 PARKVIEW HEALTHCARE CENTER 1514 E. LINCOLN AVENUE ANAHEIM CA 92805 7147742222 400 Orange For profit - Corporation 41 39.7 Medicare and Medicaid false PARKVIEW HEALTHCARE CENTER OPERATING COMPANY, LLC 04/01/1979 false   false false false Resident Yes 5   4   5   5     2 3   2       2.4161 1.0956 0.29595 1.39155 3.80764 0.07235 2.01467 0.63461 0.27451 2.92379 2.49244 1.29816 0.40579 4.17603 10/29/2019 12 7 5 36 1 0 36 11/30/2018 13 13 0 52 1 0 52 2017-12-05 12 11 1 1 40 0 40 42 1 2 0 0.00 0 0 1514 E LINCOLN AVENUE ANAHEIM, CA 92805 (33.839411, -117.896867) 02/01/2020
5400 5400 203 S HURON ST YPSILANTI, MI 48197 42.238236 -83.613056 0   2.3e+105 GILBERT RESIDENCE (THE) 203 S HURON ST YPSILANTI MI 48197 7344829498 800 Washtenaw Non profit - Corporation 32 29.2 Medicaid false Legal Business Name Not Available 12/01/1974 false   false false false Resident Yes 5   4   5   5     2 5   5       2.51422 0.71959 0.7 1.41959 3.93381 0 2.13342 0.60492 0.24532 2.98366 2.4493 0.89448 1.07399 4.22783 05/29/2019 12 11 1 68 1 0 68 05/02/2018 10 10 0 60 1 0 60 2017-04-06 3 2 1 1 24 0 24 58 5 2 0 0.00 0 0 203 S HURON ST YPSILANTI, MI 48197 (42.238236, -83.613056) 02/01/2020
6631 6631 1912 MARSH ROAD WILMINGTON, DE 19810 39.807772 -75.499906 0   85036 FORWOOD MANOR 1912 MARSH ROAD WILMINGTON DE 19810 3025291601 10 New Castle For profit - Corporation 72 43.2 Medicare and Medicaid false Legal Business Name Not Available 12/20/1988 true   false false false Resident Yes 5   4   5   4   5   5   5       2.44261 1.28104 1.46121 2.74225 5.18487 0.19388 1.97905 0.69495 0.33553 3.00953 2.56515 1.38609 1.63914 5.52448 10/22/2019 12 11 1 76 1 0 76 11/08/2018 2 2 0 12 1 0 12 2017-11-01 11 11 0 1 68 0 68 53.333 0 3 0 0.00 0 0 1912 MARSH ROAD WILMINGTON, DE 19810 (39.807772, -75.499906) 02/01/2020
6752 6752 1285 CLEAVER RD CARO, MI 48723 43.503623 -83.387788 0   235089 TUSCOLA COUNTY MEDICAL CARE FACILITY 1285 CLEAVER RD CARO MI 48723 9896734117 780 Tuscola Government - County 159 157.8 Medicare and Medicaid false TUSCOLA COUNTY MEDICAL CARE FACILITY 01/16/1967 false   false false false Resident Yes 5   4   5   5   5   5   5       4.12064 1.07916 0.88986 1.96901 6.08965 0.03469 2.01547 0.66105 0.29158 2.96811 4.24916 1.22753 1.14865 6.57909 07/11/2019 12 12 0 76 1 0 76 07/11/2018 7 7 0 32 1 0 32 2017-04-21 6 6 0 1 40 0 40 55.333 0 0 0 0.00 0 0 1285 CLEAVER RD CARO, MI 48723 (43.503623, -83.387788) 02/01/2020
7553 7553 3160 GRACEFIELD ROAD SILVER SPRING, MD 20904 39.056043 -76.95081 0   215343 RIDERWOOD VILLAGE 3160 GRACEFIELD ROAD SILVER SPRING MD 20904 3015728420 160 Prince Georges Non profit - Corporation 117 101.7 Medicare and Medicaid false RIDERWOOD VILLAGE, INC. 06/06/2003 true   false false false Both Yes 5   4   5   5   5   5   5       3.06362 0.69336 1.18989 1.88325 4.94686 0.12266 2.23666 0.69301 0.32679 3.25646 2.84675 0.75232 1.37048 4.87122 02/07/2019 12 10 2 48 1 0 48 10/12/2017 6 6 6 32 1 0 32 2016-07-22 2 2 0 1 8 0 8 36 0 4 0 0.00 0 0 3160 GRACEFIELD ROAD SILVER SPRING, MD 20904 (39.056043, -76.95081) 02/01/2020
8058 8058 402 N SANTA FE AVENUE ST JOHN, KS 67576 38.003321 -98.75434 0   175529 LEISURE HOMESTEAD AT ST JOHN 402 N SANTA FE AVENUE ST JOHN KS 67576 6205493541 920 Stafford Non profit - Corporation 30 26.6 Medicare and Medicaid false LEISURE HOMESTEAD ASSOCIATION 07/16/2012 false   false false false Resident Yes 5   4   5   5     2 5   5       2.71027 0.13447 0.98553 1.12 3.83027 0.00264 1.75871 0.61388 0.27681 2.6494 3.20284 0.16471 1.34004 4.63591 04/22/2019 12 12 8 44 1 0 44 05/01/2018 4 4 0 32 1 0 32 2016-02-16 2 2 0 1 8 0 8 34 0 0 0 0.00 0 0 402 N SANTA FE AVENUE ST JOHN, KS 67576 (38.003321, -98.75434) 02/01/2020
8484 8484 6041 FAIR OAKS BLVD CARMICHAEL, CA 95608 38.611398 -121.328784 0   56101 RIVER POINTE POST-ACUTE 6041 FAIR OAKS BLVD CARMICHAEL CA 95608 9164838103 440 Sacramento For profit - Partnership 112 109 Medicare and Medicaid false Legal Business Name Not Available 05/01/1980 false   false false false Resident Yes 4   4   3   4   2   2   2       2.24326 1.03926 0.44964 1.4889 3.73216 0.14594 1.97697 0.7356 0.35157 3.06414 2.35828 1.06235 0.48138 3.90576 07/11/2019 12 7 5 68 1 0 68 08/16/2018 6 5 1 28 1 0 28 2017-07-14 8 6 2 1 36 0 36 49.333 3 6 0 0.00 0 0 6041 FAIR OAKS BLVD CARMICHAEL, CA 95608 (38.611398, -121.328784) 02/01/2020
8504 8504 1285 E CACTUS AVENUE LAS VEGAS, NV 89183 35.999113 -115.13696 0   295102 ADVANCED HEALTH CARE OF HENDERSON 1285 E CACTUS AVENUE LAS VEGAS NV 89183 2084526392 10 Clark For profit - Corporation 38 37.6 Medicare false AHC OF HENDERSON, LLC 01/22/2019 false   false false false None Yes 5   4   4     2 4   5   5       3.392 0.32658 2.04373 2.3703 5.7623 0.45125 2.27216 1.0893 0.64417 4.00563 3.10265 0.22544 1.19414 4.61295 12/19/2019 12 12 0 60 0 0 60 01/09/2019 5 5 0 24 1 0 24   . . . . . . . 45.6 0 0 0 0.00 0 0 1285 E CACTUS AVENUE LAS VEGAS, NV 89183 (35.999113, -115.13696) 02/01/2020
9619 9619 200 MONDAY DRIVE HAMLIN, WV 25523 38.286248 -82.105475 0   515171 LINCOLN NURSING AND REHABILITATION CENTER 200 MONDAY DRIVE HAMLIN WV 25523 3048243133 210 Lincoln For profit - Corporation 60 57.1 Medicare and Medicaid false LINCOLN NURSING & REHABILITATION CENTER LLC 12/21/1999 false   false false false Both Yes 4   4   4   4   5   3   3       2.20123 0.81705 0.78604 1.60309 3.80432 0.05671 2.16605 0.8371 0.46232 3.46547 2.11209 0.73393 0.63993 3.5202 01/17/2019 12 12 0 76 1 0 76 02/02/2018 2 2 0 8 1 0 8 2016-11-30 0 0 0 0 0 0 0 40.667 0 0 0 0.00 0 0 200 MONDAY DRIVE HAMLIN, WV 25523 (38.286248, -82.105475) 02/01/2020
9755 9755 6641 W AMARILLO BLVD AMARILLO, TX 79106 35.198366 -101.91033 0   676347 AMARILLO CENTER FOR SKILLED CARE 6641 W AMARILLO BLVD AMARILLO TX 79106 8063528800 860 Potter For profit - Corporation 122 89.8 Medicare and Medicaid false AMARILLO II ENTERPRISES LLC 11/04/2013 false   false false false Resident Yes 3   4   4   2   5   1   1       1.7964 1.56933 0.28811 1.85744 3.65384 0.02825 2.06656 0.85801 0.45766 3.38223 1.80664 1.37532 0.23694 3.46417 07/10/2019 12 9 3 48 1 0 48 06/14/2018 2 2 0 12 1 0 12 2017-05-17 5 4 1 1 32 0 32 33.333 0 1 0 0.00 0 0 6641 W AMARILLO BLVD AMARILLO, TX 79106 (35.198366, -101.91033) 02/01/2020
9812 9812 6401 AUBURN DR VIRGINIA BEACH, VA 23464 36.807548 -76.215405 0   495186 BETH SHOLOM HOME OF EASTERN VI 6401 AUBURN DR VIRGINIA BEACH VA 23464 7574202512 921 Virginia Beach City Non profit - Other 120 99.4 Medicare and Medicaid false BETH SHOLOM HOME OF EASTERN VIRGINIA 01/20/1989 false   false false false Resident Yes 5   4   5   5   5   3   2       3.29476 1.76415 0.40752 2.17167 5.46643 0.06345 2.11706 0.70737 0.31041 3.13483 3.2345 1.87532 0.49413 5.59168 04/20/2018 12 7 5 72 1 0 72 01/06/2017 0 0 0 0 0 0 0 2016-02-04 3 3 0 1 16 0 16 38.667 0 1 0 0.00 0 0 6401 AUBURN DR VIRGINIA BEACH, VA 23464 (36.807548, -76.215405) 02/01/2020
9825 9825 1100 EAST NELSON ROAD MOSES LAKE, WA 98837 47.116478 -119.260087 0   505320 COLUMBIA CREST CENTER 1100 EAST NELSON ROAD MOSES LAKE WA 98837 5097656788 120 Grant For profit - Corporation 111 73 Medicare and Medicaid false SUNBRIDGE HEALTHCARE LLC 09/21/1988 false   false false false Resident Yes 5   4   5   5   4   4   4       2.24885 0.61962 0.74943 1.36906 3.6179 0.09463 1.99133 0.73538 0.34554 3.07226 2.3471 0.63357 0.81633 3.77618 11/08/2018 12 7 5 88 1 0 88 01/12/2018 8 6 2 52 1 0 52 2016-12-08 11 10 1 1 68 0 68 72.667 6 3 3 39549.00 0 3 1100 EAST NELSON ROAD MOSES LAKE, WA 98837 (47.116478, -119.260087) 02/01/2020
9905 9905 206 HOSPITAL CIRCLE WESTMINSTER, CA 92683 33.762397 -117.994629 0   555211 EXTENDED CARE HOSP WESTMINSTER 206 HOSPITAL CIRCLE WESTMINSTER CA 92683 7148912769 400 Orange For profit - Partnership 99 96.3 Medicare and Medicaid false EXTENDED CARE HOSPITAL OF WESTMINSTER 09/05/1985 false   false false false Resident Yes 5   4   5   5     2 3   2       2.65173 0.95968 0.22365 1.18333 3.83505 0.00169 1.8113 0.57123 0.2399 2.62242 3.04267 1.26328 0.35089 4.68945 07/02/2019 12 10 4 52 1 0 52 06/19/2018 10 9 1 40 1 0 40 2017-06-16 12 12 0 1 52 0 52 48 2 2 0 0.00 0 0 206 HOSPITAL CIRCLE WESTMINSTER, CA 92683 (33.762397, -117.994629) 02/01/2020
9949 9949 3919 SOUTH 19TH STREET TACOMA, WA 98405 47.242815 -122.490149 0   505239 PARK ROSE CARE CENTER 3919 SOUTH 19TH STREET TACOMA WA 98405 2537525677 260 Pierce For profit - Limited Liability company 139 93 Medicare and Medicaid false BD TACOMA I, LLC 04/30/1976 false   false false false Resident Yes 4   4   5   5   5   1   1       2.90417 1.21384 0.59889 1.81273 4.7169 0.05149 2.32537 0.97271 0.97529 4.27338 2.59564 0.93834 0.23113 3.53947 07/31/2019 12 8 4 44 1 0 44 08/23/2018 10 9 1 48 1 0 48 2017-07-19 11 11 0 1 131 0 131 59.833 1 7 1 8128.00 0 1 3919 SOUTH 19TH STREET TACOMA, WA 98405 (47.242815, -122.490149) 02/01/2020
11677 11677 5220 NORTHEAST HAZEL DELL AVENUE VANCOUVER, WA 98663 45.660743 -122.667935 0   505341 DISCOVERY NURSING & REHAB OF VANCOUVER 5220 NORTHEAST HAZEL DELL AVENUE VANCOUVER WA 98663 3606931474 50 Clark For profit - Corporation 89 68.8 Medicare and Medicaid false CARE CENTER HAZEL DELL INC 06/02/1989 false   false false false Resident Yes 5   4   5   5   3   4   5       2.08793 0.69885 0.95424 1.6531 3.74102 0.07962 2.15875 0.69018 0.32437 3.1733 2.01015 0.76139 1.10727 3.78036 04/22/2019 12 8 5 92 1 0 92 05/25/2018 7 4 3 32 1 0 32 2017-04-11 8 8 0 1 52 0 52 65.333 1 6 0 0.00 0 0 5220 NORTHEAST HAZEL DELL AVENUE VANCOUVER, WA 98663 (45.660743, -122.667935) 02/01/2020
11957 11957 1611 HEIGHT STREET BAKERSFIELD, CA 93305 35.393887 -118.973009 0   555902 HEIGHT STREET SKILLED CARE 1611 HEIGHT STREET BAKERSFIELD CA 93305 6617481300 140 Kern For profit - Individual 99 73.8 Medicare and Medicaid false HEIGHT STREET SKILLED CARE LLC 04/03/2017 false   false false false None Yes 4   4   3   4   3   4   3       2.60914 0.99048 0.5177 1.50818 4.11732 0.06359 1.9092 0.66127 0.29279 2.86325 2.84029 1.1263 0.6655 4.61114 03/07/2019 12 11 1 68 1 0 68 02/08/2018 6 6 0 32 1 0 32 2017-02-08 0 0 0 0 0 0 0 44.667 1 0 0 0.00 0 0 1611 HEIGHT STREET BAKERSFIELD, CA 93305 (35.393887, -118.973009) 02/01/2020
11986 11986 12681 HASTER STREET GARDEN GROVE, CA 92840 33.778983 -117.906141 0   555667 GARDEN PARK CARE CENTER 12681 HASTER STREET GARDEN GROVE CA 92840 7149712153 400 Orange For profit - Corporation 124 116.4 Medicare and Medicaid false GARDEN PARK CARE CENTER, LLC 05/16/1996 false   false false false Resident Yes 4   4   5   5   5   1 12 1 12     2.24126 1.15538 0.50156 1.65694 3.89821 0.07003 2.27636 0.87241 0.66508 3.81385 2.04629 0.99584 0.28385 3.27759 04/23/2019 12 9 3 52 1 0 52 05/23/2018 7 7 0 32 1 0 32 2017-05-02 17 14 3 1 56 0 56 46 0 1 0 0.00 0 0 12681 HASTER STREET GARDEN GROVE, CA 92840 (33.778983, -117.906141) 02/01/2020
13026 13026 4755 SOUTH 48TH TACOMA, WA 98409 47.213817 -122.503497 0   505093 ORCHARD PARK HEALTH CARE & REHAB CENTER 4755 SOUTH 48TH TACOMA WA 98409 2534754611 260 Pierce For profit - Corporation 147 115.8 Medicare and Medicaid false 4755 SOUTH 48TH STREET OPERATIONS LLC 11/01/1970 false   false false false Resident Yes 5   4   5   5   5   4   4       2.25399 0.79989 0.88043 1.68032 3.93431 0.10204 2.08912 0.77049 0.37136 3.23097 2.24236 0.78063 0.89236 3.90472 12/05/2018 12 12 0 64 1 0 64 12/15/2017 16 13 5 104 1 0 104 2017-01-10 9 7 2 1 32 0 32 72 3 8 1 36714.00 0 1 4755 SOUTH 48TH TACOMA, WA 98409 (47.213817, -122.503497) 02/01/2020
13239 13239 2508 7TH ST SOUTHEAST PUYALLUP, WA 98374 47.167558 -122.28544 0   505526 LIFE CARE CENTER OF SOUTH HILL 2508 7TH ST SOUTHEAST PUYALLUP WA 98374 2536615948 260 Pierce For profit - Corporation 100 81.7 Medicare and Medicaid false SOUTH HILL OPERATIONS LLC 06/24/2015 false   false false false Resident Yes 5   4   5   5   5   3   3       2.535 1.8235 0.77105 2.59456 5.12956 0.34907 2.26318 1.04367 0.5586 3.86545 2.32795 1.3138 0.51954 4.25533 06/21/2019 12 11 1 52 1 0 52 08/08/2018 8 8 0 40 1 0 40 2017-08-01 4 4 0 1 20 0 20 42.667 0 1 0 0.00 0 0 2508 7TH ST SOUTHEAST PUYALLUP, WA 98374 (47.167558, -122.28544) 02/01/2020
13312 13312 308 WEST EMMA UNION GAP, WA 98903 46.552948 -120.479857 0   505401 PRESTIGE CARE & REHABILITATION - PARKSIDE 308 WEST EMMA UNION GAP WA 98903 5092481985 380 Yakima For profit - Corporation 88 56.6 Medicare and Medicaid false CARE CENTER UNION GAP INC. 12/01/1991 false   false false false Resident Yes 5   4   5   5   5   4   4       2.24757 0.46396 0.84258 1.30654 3.55411 0.09214 2.0187 0.74383 0.33752 3.10006 2.31397 0.46902 0.93959 3.67633 10/10/2019 12 10 2 64 1 0 64 11/02/2018 17 14 3 88 1 0 88 2017-10-31 5 0 5 1 40 0 40 68 8 7 0 0.00 0 0 308 WEST EMMA UNION GAP, WA 98903 (46.552948, -120.479857) 02/01/2020
13779 13779 645 SOUTH BEACH BLVD ANAHEIM, CA 92804 33.82334 -117.993417 0   555388 WEST ANAHEIM EXTENDED CARE 645 SOUTH BEACH BLVD. ANAHEIM CA 92804 7148211993 400 Orange For profit - Partnership 138 133.2 Medicare and Medicaid false WEST ANAHEIM EXTENDED CARE 10/03/1989 false   false false false Resident Yes 5   4   5   5   5   4   3       2.39411 1.094 0.41382 1.50782 3.90194 0.03838 1.8834 0.62096 0.25973 2.76409 2.64192 1.32475 0.59969 4.5267 09/24/2019 12 5 7 40 1 0 40 10/03/2018 15 15 0 52 1 0 52 2017-10-05 18 17 1 1 76 0 76 50 2 2 0 0.00 0 0 645 SOUTH BEACH BLVD ANAHEIM, CA 92804 (33.82334, -117.993417) 02/01/2020
13900 13900 22 W 1ST STREET TONASKET, WA 98855 48.708752 -119.441828 0   505454 NORTH VALLEY HOSPITAL 22 W 1ST STREET TONASKET WA 98855 5094862151 230 Okanogan Government - Hospital district 42 40.2 Medicare and Medicaid true LONG TERM CARE DIVISION OF OCPHD 4 01/01/1992 false   false false false Resident Yes 5   4   4   4     2 5   5       2.68983 0.53935 0.83518 1.37453 4.06436 0.00953 2.23458 0.65018 0.26276 3.14752 2.50176 0.62375 1.19635 4.14073 07/17/2019 12 10 3 88 1 0 88 08/24/2018 9 7 2 32 1 0 32 2017-09-13 8 8 0 1 24 0 24 58.667 2 1 1 14394.00 0 1 22 W 1ST STREET TONASKET, WA 98855 (48.708752, -119.441828) 02/01/2020
13989 13989 15632 POMERADO ROAD POWAY, CA 92064 32.997471 -117.057985 0   555136 POWAY HEALTHCARE CENTER 15632 POMERADO ROAD POWAY CA 92064 8584855153 470 San Diego For profit - Corporation 99 94.3 Medicare and Medicaid false POPLAR HOLDINGS LLC 08/14/1981 false   false false false Both Yes 5   4   5   5   5   3   3       2.25735 1.01774 0.44967 1.46741 3.72476 0.19141 2.13995 0.74907 0.33279 3.22181 2.19236 1.02164 0.50857 3.70725 04/11/2019 12 12 0 52 1 0 52 04/19/2018 3 2 1 12 1 0 12 2017-01-26 5 3 2 1 20 0 20 33.333 1 2 0 0.00 0 0 15632 POMERADO ROAD POWAY, CA 92064 (32.997471, -117.057985) 02/01/2020
14219 14219 1720 MOUNTAIN VIEW LOMA LINDA, CA 92354 34.069701 -117.243705 0   555587 TOTALLY KIDS REHABILITATION HOSPITAL - D/P SNF 1720 MOUNTAIN VIEW LOMA LINDA CA 92354 9097966915 460 San Bernardino For profit - Corporation 56 52.6 Medicare and Medicaid true MOUNTAIN VIEW CHILD CARE, INC. 02/04/1994 false   false false false None Yes 5   4   5   5     2 3   2       4.06987 3.77887 1.64823 5.4271 9.49697 0.17426 2.50611 1.07803 1.89717 5.48131 3.37517 2.63583 0.327 5.55589 01/11/2019 12 11 1 64 1 0 64 01/05/2018 4 4 0 16 1 0 16 2016-12-23 3 3 0 1 12 0 12 39.333 1 0 0 0.00 0 0 1720 MOUNTAIN VIEW LOMA LINDA, CA 92354 (34.069701, -117.243705) 02/01/2020
14263 14263 4210 Sabana Grande Ave SE, Rio Rancho, NM 87124, USA 35.2426957 -106.6527598 1 ROOFTOP 325033 RIO RANCHO CENTER 4210 SABANA GRANDE SE RIO RANCHO NM 87124 5058167566 210 Sandoval For profit - Corporation 120 105.9 Medicare and Medicaid false PEAK MEDICAL NEW MEXICO NO 3 LLC 11/04/1982 false   false false false Resident Yes 4   4   4   4   4   4   4       2.11726 0.52723 0.70343 1.23066 3.34792 0.05507 1.98759 0.68728 0.29776 2.97263 2.21393 0.57683 0.88917 3.6115 03/07/2019 12 10 3 108 1 0 108 02/12/2018 12 10 2 96 1 0 96 2017-02-14 4 4 4 1 20 0 20 89.333 0 3 0 0.00 0 0   02/01/2020
14675 14675 4550 CARMAN DRIVE LAKE OSWEGO, OR 97035 45.419823 -122.723085 0   385271 PEARL AT KRUSE WAY, THE 4550 CARMAN DRIVE LAKE OSWEGO OR 97035 5036756055 20 Clackamas For profit - Corporation 74 43.2 Medicare and Medicaid false AVAMERE LAKE OSWEGO OPERATIONS INVESTORS, LLC 01/25/2006 false   false false false Resident Yes 4   4   3     2 3   3   3       2.75754 1.60429 1.00685 2.61114 5.36868 0.467 2.3273 1.01877 0.57745 3.92352 2.46256 1.1841 0.65627 4.38778 03/19/2018 12 6 6 56 1 0 56 01/27/2017 6 6 0 24 1 0 24 2015-11-20 7 7 0 2 48 24 72 48 0 5 0 0.00 0 0 4550 CARMAN DRIVE LAKE OSWEGO, OR 97035 (45.419823, -122.723085) 02/01/2020
14819 14819 414 ALGONQUIN RD HAMPTON, VA 23661 37.012207 -76.365615 0   495308 RIVERSIDE REHABILITATION CENTER AT HAMPTON 414 ALGONQUIN RD HAMPTON VA 23661 7577229881 411 Hampton City Non profit - Corporation 130 109.3 Medicare and Medicaid false RIVERSIDE CONVALESCENT CENTERS, INC. 03/06/1996 false   false false false Resident Yes 5   4   5   5   5   2   2       1.93609 1.34097 0.30397 1.64494 3.58103 0.09038 2.22865 0.7305 0.28535 3.2445 1.80551 1.38034 0.40094 3.53927 03/22/2019 12 12 12 44 1 0 44 08/04/2017 3 3 2 32 1 0 32 2016-06-10 3 3 0 1 16 0 16 35.333 0 7 0 0.00 0 0 414 ALGONQUIN RD HAMPTON, VA 23661 (37.012207, -76.365615) 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
);