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

53 rows where Long-Stay QM Rating Footnote = 2 and geocode_flag = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_accuracy, prvdr_state, ownership, nmbr_beds, prvdr_type, Provider Resides in Hospital, Continuing Care Retirement Community, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, 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 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 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, 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
3 3 3115 Bowman Rd, Little Rock, AR 72211, USA 34.7245501 -92.4070758 1 RANGE_INTERPOLATED 45288 ALLAY HEALTH AND REHAB 3115 BOWMAN ROAD LITTLE ROCK AR 72211 5012284848 590 Pulaski For profit - Limited Liability company 70 14.4 Medicare and Medicaid false CLR HEALTHCARE OPERATIONS LLC 06/30/1995 false   false false false None Yes 1   2   1     2 1     2   2 6 6                             09/06/2019 8 8 0 72 1 0 72 09/19/2018 8 8 0 52 1 0 52 2017-07-21 6 4 2 1 298 0 298 103 0 2 2 28096.00 0 2   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
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
1592 1592 2350 Ione Rd, Las Vegas, NV 89183, USA 36.009279 -115.1195258 1 ROOFTOP 295098 SAGE CREEK POST-ACUTE 2350 IONE ROAD LAS VEGAS NV 89123 7027903000 10 Clark For profit - Limited Liability company 60 44.1 Medicare false GRAPE HOLDINGS LLC 10/31/2017 false   false false false Resident Yes 5   5   3     2 3   4   4       2.89227 2.08264 1.49131 3.57395 6.46622 0.71691 2.2678 0.9716 0.58959 3.82899 2.65063 1.6118 0.95203 5.41526 11/21/2019 12 11 1 48 1 0 48 10/12/2018 8 6 2 24 1 0 24 2017-10-13 0 0 0 0 0 0 0 32 0 5 0 0.00 0 0   02/01/2020
1798 1798 16529 SE 86th Belle Meade Cir, The Villages, FL 32162, USA 28.9804627 -82.00946189999999 1 ROOFTOP 106095 CLUB HEALTH AND REHABILITATION CENTER AT THE VILLA 16529 SE 86TH BELLE MEADE CIRCLE THE VILLAGES FL 32162 3523858200 0 Alachua For profit - Corporation 68 61.7 Medicare and Medicaid false MULBERRY GROVE NH LLC 10/18/2012 false   false false false Resident Yes 5   4   5     2 5   3   3       2.47684 1.07199 0.93392 2.00592 4.48276 0.57123 2.2389 1.0174 0.60635 3.86265 2.29921 0.79229 0.57972 3.72146 06/20/2019 3 3 0 16 1 0 16 04/19/2018 2 2 0 20 1 0 20 2017-05-25 3 3 0 1 24 0 24 18.667 0 0 0 0.00 0 0   02/01/2020
2370 2370 6700 US-165, Monroe, LA 71203, USA 32.5898929 -92.066053 1 ROOFTOP 195628 NORTHEAST LA WAR VETERANS HOME 6700 HIGHWAY 165 NORTH MONROE LA 71211 3183624206 360 Ouachita Government - State 10 2.6 Medicare false NORTHEAST LOUISANA VETERANS HOME 12/04/2008 false   false false false Resident Yes 3   4   1     2 1     2   2 6 6                             08/05/2019 0 0 0 0 1 0 0 07/17/2018 4 4 0 24 1 0 24 2017-07-06 2 1 1 1 8 0 8 9.333 0 1 0 0.00 0 0   02/01/2020
2627 2627 N 11th St & Broadway St, Quincy, IL 62301, USA 39.9356331 -91.3983503 1 GEOMETRIC_CENTER 145643 BLESSING HOSPITAL SNU BROADWAY AT 11TH STREET QUINCY IL 62301 2172238400 0 Adams Non profit - Corporation 20 15.1 Medicare false BLESSING HOSPITAL 06/20/1989 false   false false false None Yes 4   5   4     2 4   1 12 1 12 6 6                             02/28/2019 0 0 0 0 0 0 0 04/19/2018 3 3 0 32 1 0 32 2017-05-24 3 3 0 1 16 0 16 13.333 0 0 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
3379 3379 6500 France Ave S, Minneapolis, MN 55435, USA 44.88533349999999 -93.3293691 1 ROOFTOP 245634 AURORA ON FRANCE 6500 FRANCE AVENUE EDINA MN 55435 9528488888 260 Hennepin For profit - Partnership 63 58.2 Medicare and Medicaid false EDINA SENIOR LIVING LLC 01/05/2017 false   false false false Both Yes 5   5   3     2 3   5   5       2.80933 0.56013 2.75942 3.31955 6.12888 0.21083 2.18309 1.02516 0.5489 3.75714 2.67454 0.41085 1.89216 5.23091 01/18/2019 2 2 1 8 1 0 8 11/02/2017 1 1 0 4 1 0 4 2017-01-04 0 0 0 0 0 0 0 5.333 2 0 0 0.00 0 0   02/01/2020
3930 3930 16455 E Ave of the Fountains, Fountain Hills, AZ 85268, USA 33.6083839 -111.7276719 1 ROOFTOP 35260 FOUNTAIN VIEW VILLAGE 16455 EAST AVENUE OF THE FOUNTAINS FOUNTAIN HILLS AZ 85268 4808364800 60 Maricopa For profit - Corporation 48 31.4 Medicare false SL FOUNTAIN VIEW VILLAGE LLC 11/26/2001 true   false false false Resident Yes 4   4   4     2 4   4   4       1.95235 0.79566 1.34581 2.14147 4.09383 0.17767 2.18731 0.90465 0.5268 3.61876 1.85509 0.66135 0.96155 3.62763 07/25/2019 5 5 1 20 1 0 20 06/06/2018 1 1 0 4 1 0 4 2017-04-06 5 5 0 1 32 0 32 16.667 1 0 0 0.00 0 0   02/01/2020
4617 4617 4739 LA-10, Jackson, LA 70748, USA 30.8259277 -91.1650719 1 ROOFTOP 195629 LOUISIANA WAR VETERANS HOME 4739 HIGHWAY 10 JACKSON LA 70748 2253428998 180 East Feliciana Government - State 10 14.3 Medicare false LOUISIANA WAR VETERANS HOME 02/20/2009 false   false false false Resident Yes 4   5     2   2   2 1 12 1 12 6 6                             06/05/2019 1 1 0 8 1 0 8 05/16/2018 0 0 0 0 0 0 0 2017-05-10 2 2 0 1 8 0 8 5.333 0 0 0 0.00 0 0   02/01/2020
4778 4778 13695 US-1, Sebastian, FL 32958, USA 27.8435297 -80.48887529999999 1 ROOFTOP 106101 STEWARD SEBASTIAN RIVER MEDICAL CENTER 13695 US 1 SEBASTIAN FL 32958 5615893186 300 Indian River For profit - Corporation 33 14.6 Medicare false STEWARD SEBASTIAN RIVER MEDICAL CENTER INC 09/09/2013 false   false false false None Yes 5   4   4     2 4   5   5       3.38972 1.91634 3.34035 5.25669 8.64641 0.3978 2.02599 1.01784 0.56143 3.60526 3.4773 1.41571 2.23939 7.69046 04/25/2019 4 4 0 16 1 0 16 03/29/2018 1 1 0 0 1 0 0 2017-03-09 5 5 0 1 32 0 32 13.333 0 0 0 0.00 0 0   02/01/2020
4989 4989 5825 St Croix Ave N, Minneapolis, MN 55422, USA 44.9955348 -93.3539643 1 ROOFTOP 245322 COVENANT LIVING OF GOLDEN VALLEY CARE & REHAB CTR 5825 ST CROIX AVENUE GOLDEN VALLEY MN 55422 7635441555 260 Hennepin Non profit - Church related 38 28.5 Medicare false COVENANT LIVING OF GOLDEN VALLEY 07/01/1986 true   false false false Both Yes 5   4   5     2 5   5   5       2.54376 1.02942 2.27799 3.30742 5.85118 0.33208 2.23684 0.96218 0.48451 3.68353 2.36351 0.80449 1.76963 5.09368 08/08/2019 3 3 0 12 1 0 12 05/31/2018 4 4 0 28 1 0 28 2017-07-14 7 7 0 1 56 0 56 24.667 0 0 0 0.00 0 0   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
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
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
6983 6983 1 Medford Leas, Medford, NJ 08055, USA 39.9089645 -74.8150241 1 ROOFTOP 315144 MEDFORD LEAS ONE MEDFORD LEAS WAY MEDFORD NJ 8055 6096543000 150 Burlington Non profit - Corporation 24 15.4 Medicare false THE ESTAUGH T/A MEDFORD LEAS 04/01/1973 true   false false false Both Yes 5   4   4     2 4   5   5       2.83985 0.70464 3.04364 3.74828 6.58814 0.69368 2.1953 1.02261 0.57006 3.78797 2.68855 0.51814 2.00958 5.57711 08/23/2019 2 2 0 12 0 0 12 09/20/2018 3 3 0 8 1 0 8 2017-06-09 0 0 0 0 0 0 0 8.667 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
7744 7744 776 Old State Rte 74, Cincinnati, OH 45245, USA 39.1073493 -84.2773397 1 ROOFTOP 366408 ATLANTES THE 776 OLD STATE ROUTE 74 CINCINNATI OH 45245 5133996225 120 Clermont For profit - Individual 30 17.7 Medicare and Medicaid false THE ATLANTES LLC 06/21/2013 false   false false false Resident Yes 5   5   5     2 5   4   4       3.30169 1.79387 1.37853 3.17239 6.47408 0.24601 2.23057 1.04717 0.59045 3.86819 3.07635 1.28812 0.87875 5.3669 01/24/2019 1 1 0 4 1 0 4 04/19/2018 5 3 2 16 1 0 16 2017-02-23 0 0 0 0 0 0 0 7.333 0 1 0 0.00 0 0   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
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
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
9374 9374 250 W Social Row Rd, Washington Township, OH 45458, USA 39.5904177 -84.1690374 1 ROOFTOP 366466 SOCIAL ROW TRANSITIONAL CARE 250 WEST SOCIAL ROW ROAD CENTERVILLE OH 45458 9378868800 580 Montgomery For profit - Corporation 100 23.3 Medicare and Medicaid false SOCIAL ROW TRANSITIONAL CARE INC 08/28/2018 false   false false false Both Yes 5   4   5     2 5   4   4       2.52276 0.70323 1.05381 1.75704 4.2798 0.25302 2.19442 0.80029 0.41866 3.41338 2.38931 0.66074 0.9474 4.02062 10/10/2019 4 4 0 40 1 0 40 08/28/2018 0 0 0 0 0 0 0   . . . . . . . 24 0 0 0 0.00 0 0   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
9633 9633 3219 E Grande Blvd, Tyler, TX 75707, USA 32.2778831 -95.2551814 1 ROOFTOP 676443 THE CENTER AT GRANDE 3219 EAST GRANDE BOULEVARD TYLER TX 75707 7195222000 892 Smith For profit - Corporation 96 86.5 Medicare and Medicaid false THE CENTER AT GRANDE LLC 04/05/2018 false   false false false Both Yes 2   2   4     2 4   3   3       2.12812 1.06363 1.06928 2.13291 4.26103 0.31266 2.27587 1.0874 0.61191 3.97518 1.94341 0.73551 0.65771 3.43725 01/24/2019 9 7 2 115 1 0 115 04/05/2018 3 0 3 24 0 0 24   . . . . . . . 78.6 1 5 1 44071.00 0 1   02/01/2020
9786 9786 3660 Greentree SW, Canton, OH 44706, USA 40.753918 -81.402542 1 ROOFTOP 366451 LODGE AT NEW DAWN THE 3660 GREENTREE AVENUE SW CANTON OH 44706 3304845888 770 Stark For profit - Corporation 16 8 Medicare false THE LODGE AT NEW DAWN INC 03/06/2017 true   false false false Resident Yes 2   3   4     2 4   1 12 1 12     3.19444 2.85772 1.33089 4.18862 7.38306 0.09768 2.07312 0.89066 0.48847 3.45225 3.20249 2.41263 1.02549 6.85784 02/13/2019 12 12 0 52 1 0 52 01/05/2018 3 3 0 16 1 0 16 2017-03-06 0 0 0 0 0 0 0 31.333 0 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
10151 10151 700 Myrtle Way, Janesville, WI 53545, USA 42.6718124 -88.98939159999999 1 ROOFTOP 525728 OAK PARK PLACE OF JANESVILLE 700 MYRTLE WAY JANESVILLE WI 53545 6085305700 520 Rock For profit - Corporation 35 15.1 Medicare false OAK PARK PLACE OF JANESVILLE LLC 01/16/2019 false   false false false Resident Yes 5   4   4     2 4   5   5       2.74903 0.45898 2.3106 2.76957 5.5186 0 2.19646 1.00411 0.52209 3.72265 2.60119 0.34371 1.66577 4.75368 09/30/2019 3 3 0 24 1 0 24 11/20/2018 0 0 0 0 0 0 0   . . . . . . . 14.4 0 0 0 0.00 0 0   02/01/2020
10717 10717 Colinas Del Oeste, Hormigueros, 00660, Puerto Rico 18.1435687 -67.1179574 1 APPROXIMATE 405029 SERVICIOS INTEGRADOS DE REHABILITACION (SIRO) INC CALLE 4-L-10 URB COLINAS DEL OESTE HORMIGUEROS PR 660 7878492179 330 Hormigueros For profit - Corporation 19 15.4 Medicare false SERVICIOS INTERGRADOS DE REHABILITACION DEL OESTE INC. 07/13/2006 false   false false false None Yes 5   5   4     2 4   5   5       0 3.03028 2.68359 5.71387 5.71387 0.45634 1.82696 0.9582 0.53232 3.31748 0 2.37799 1.89747 5.52301 03/27/2019 2 2 0 0 1 0 0 07/23/2018 7 7 0 36 1 0 36 2017-05-18 10 10 0 1 124 0 124 32.667 0 0 1 7800.00 0 1   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
11637 11637 3630 Imperial Hwy, Lynwood, CA 90262, USA 33.9310586 -118.2037268 1 RANGE_INTERPOLATED 555238 SAINT FRANCIS MED CTR DP 3630 IMPERIAL HWY. LYNWOOD CA 90262 3109009800 200 Los Angeles Non profit - Corporation 30 17.3 Medicare and Medicaid false Legal Business Name Not Available 09/30/1986 false   false false false None Yes 4   2   5     2 5   5   5       2.47868 1.49674 2.2024 3.69914 6.17782 0 1.84775 0.75642 0.36395 2.96811 2.78801 1.48788 2.27765 6.67434 12/09/2018 12 8 4 76 1 0 76 01/07/2018 11 11 0 76 1 0 76 2017-01-15 16 16 0 1 88 0 88 78 1 1 0 0.00 0 0   02/01/2020
11874 11874 300 Clynelish Close, Pittsboro, NC 27312, USA 35.7928629 -79.0964845 1 ROOFTOP 345539 THE ARBOR 300 CLYNELISH CLOSE PITTSBORO NC 27312 9195452660 180 Chatham For profit - Individual 16 4.6 Medicare false GALLOWAY RIDGE, INC 09/28/2006 true   false false false Resident Yes 5   5   5     2 5   1 12 1 12 6 6                             06/25/2019 2 2 0 8 1 0 8 05/16/2018 0 0 0 0 0 0 0 2017-04-26 0 0 0 0 0 0 0 4 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
12056 12056 16219 Ranch Rd 620 N, Austin, TX 78717, USA 30.4914293 -97.72626699999999 1 ROOFTOP 676440 RAPID RECOVERY CENTER OF ROUND ROCK 16219 RANCH ROAD 620 NORTH AUSTIN TX 78717 5125201834 970 Williamson For profit - Corporation 30 37.3 Medicare and Medicaid false MOC ROUND ROCK LLC 02/21/2018 false   false false false Resident Yes 5   5   4     2 4   4   4       2.9959 2.2992 1.67495 3.97415 6.97005 0.33539 2.28912 1.09973 0.61236 4.00121 2.72003 1.57207 1.0295 5.58595 02/06/2019 3 3 0 32 1 0 32 02/21/2018 0 0 0 0 0 0 0   . . . . . . . 19.2 0 0 0 0.00 0 0   02/01/2020
12205 12205 100 Lancaster Ave, Wynnewood, PA 19096, USA 39.9885015 -75.25734 1 ROOFTOP 396001 ABRAMSON SENIOR CARE AT LANKENAU MEDICAL CENTER 100 LANCASTER AVENUE WYNNEWOOD PA 19096 4843285900 560 Montgomery Non profit - Corporation 35 17.9 Medicare false MADLYN AND LEONARD ABRAMSON CENTER FOR JEWISH LIFE 08/06/1996 false   false false false Resident Yes 5   5   5     2 5   1 12 1 12     3.01655 0 2.7085 2.7085 5.72505 0.45747 2.19137 1.03435 0.57788 3.8036 2.86095 0 1.76409 4.82655 06/03/2019 2 2 0 12 1 0 12 05/24/2018 0 0 0 0 0 0 0 2017-04-20 7 7 0 1 36 0 36 12 0 0 0 0.00 0 0   02/01/2020
12679 12679 Hickory St, Greenville, NC 27858, USA 35.6090089 -77.34817799999999 1 GEOMETRIC_CENTER 345512 CYPRESS GLEN RETIREMENT COMMUNITY 1000 HICKORY STREET GREENVILLE NC 27858 2528300036 730 Pitt Non profit - Corporation 6 2.8 Medicare false THE UNITED METHODIST RETIREMENT HOMES, INCORPORATED 01/10/2002 true   false false false Both Yes 5   4   4     2 4   5   5       3.3278 0.35448 2.3729 2.72737 6.05517 0.73166 2.09569 0.9621 0.55962 3.61742 3.30024 0.27705 1.59593 5.36761 06/04/2019 3 3 0 16 1 0 16 05/01/2018 0 0 0 0 0 0 0 2017-03-16 0 0 0 0 0 0 0 8 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
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
13906 13906 5501 Old York Rd, Philadelphia, PA 19141, USA 40.0366347 -75.14235339999999 1 ROOFTOP 395515 WILLOWCREST ALBERT EINSTEIN MED CTR PHILADELPHIA PA 19141 2154568632 620 Philadelphia Non profit - Corporation 44 39.2 Medicare and Medicaid false ALBERT EINSTEIN MEDICAL CENTER 09/21/1981 false   false false false Resident Yes 5   3   5     2 5   5   5       2.11808 0.75248 2.23192 2.9844 5.10248 0.34544 2.10429 0.97804 0.55136 3.63369 2.09196 0.57853 1.5236 4.50285 05/20/2019 5 5 0 44 1 0 44 08/31/2018 6 3 3 40 1 0 40 2017-06-02 6 6 0 1 24 0 24 39.333 0 1 1 6893.00 0 1   02/01/2020
14385 14385 113 NJ-73, Voorhees Township, NJ 08043, USA 39.8319068 -74.9276362 1 ROOFTOP 315513 POWERBACK REHABILITATION, ROUTE 73 113 SOUTH ROUTE 73 VOORHEES NJ 8043 8568093500 160 Camden For profit - Corporation 124 113.8 Medicare and Medicaid false SR-73 AND LAKESIDE AVENUE OPERATIONS LLC 02/07/2013 false   false false false Resident Yes 5   3   5     2 5   4   4       1.82093 1.3423 1.43496 2.77726 4.59819 0.4167 2.07987 0.96087 0.5617 3.60245 1.81959 1.05043 0.96154 4.09301 07/09/2019 3 3 0 12 0 0 12 05/24/2018 3 3 0 24 1 0 24 2017-03-31 4 3 1 1 16 0 16 16.667 0 3 1 3250.00 0 1   02/01/2020
14649 14649 3001 Lititz Pike, Lititz, PA 17543, USA 40.1106773 -76.3044756 1 ROOFTOP 396140 REHABILITATION CENTER AT BRETHREN VILLAGE LLC 3001 LITITZ PIKE LANCASTER PA 17606 7175692657 440 Lancaster Non profit - Corporation 20 12.2 Medicare false REHABILITATION CENTER AT BRETHREN VILLAGE LLC 05/10/2016 true   false false false None Yes 5   5   5     2 5   5   5       3.6683 0.83214 3.50156 4.33371 8.00201 0.51363 2.28599 1.0958 0.59095 3.97274 3.33508 0.57102 2.2302 6.45895 12/20/2018 0 0 0 0 0 0 0 01/12/2018 1 1 0 8 1 0 8 2017-02-24 0 0 0 0 0 0 0 2.667 0 0 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
14789 14789 1 Hospital Way, Butler, PA 16001, USA 40.86727399999999 -79.8805124 1 ROOFTOP 395869 BUTLER MEMORIAL HOSP TCF ONE HOSPITAL WAY BUTLER PA 16001 7242844526 150 Butler Non profit - Other 25 20.8 Medicare false BUTLER HEALTH CARE PROVIDERS 11/26/1991 false   false false false None Yes 5   5   4     2 4   4   5       1.52394 1.21343 1.68003 2.89347 4.41741 0.5544 2.33189 0.96528 0.55665 3.85382 1.35824 0.94525 1.13598 3.67561 06/06/2019 0 0 0 0 0 0 0 07/19/2018 0 0 0 0 0 0 0 2017-06-15 1 1 0 1 8 0 8 1.333 0 0 0 0.00 0 0   02/01/2020
15063 15063 3140 El Camino Real, Carlsbad, CA 92008, USA 33.1740346 -117.3234049 1 ROOFTOP 555745 BROOKDALE CARLSBAD 3140 EL CAMINO REAL CARLSBAD CA 92008 7607209898 470 San Diego For profit - Corporation 45 36.6 Medicare false S-H OPCO CARLSBAD LLC 10/04/1999 true   false false false Both Yes 5   5   5     2 5   4   4       3.49436 1.00995 1.15062 2.16058 5.65493 0.30853 2.2155 0.95305 0.51823 3.68678 3.27801 0.79684 0.83569 4.91851 06/14/2019 3 2 1 12 1 0 12 05/04/2018 2 2 0 8 1 0 8 2017-03-09 2 2 0 1 8 0 8 10 1 0 0 0.00 0 0   02/01/2020
15079 15079 900 E Airport Rd, Okmulgee, OK 74447, USA 35.6675915 -95.9597392 1 ROOFTOP 375314 MUSCOGEE (CREEK) NATION SKILLED NURSING FACILITY 900 EAST AIRPORT ROAD OKMULGEE OK 74447 9187569211 550 Okmulgee Government - Federal 8 6.2 Medicare false CREEK NATION HOSPITAL & CLINICS 07/08/1997 false   false false false None Yes 4   4   5     2 5   1 12 1 12     3.94264 4.94702 3.41021 8.35723 12.29988 0.55692 1.97141 1.02093 0.59448 3.58682 4.15648 3.64359 2.15912 10.99623 04/25/2019 7 7 0 52 1 0 52 06/13/2018 2 2 0 8 1 0 8 2017-04-26 4 4 0 1 32 0 32 34 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
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
15432 15432 24854 Cathedral Lakes Parkway, Spring, TX 77386, USA 30.1210872 -95.43620089999999 1 ROOFTOP 676456 THE MEDICAL RESORT AT WOODLANDS 24854 CATHEDRAL LAKES PKWY SPRING TX 77386 3468310656 801 Montgomery For profit - Partnership 90 38.3 Medicare and Medicaid false APOLLO REHAB AT WOODLANDS LLC 09/06/2018 false   false false false None Yes 4   4   2     2 2   4   3       2.64333 1.67933 0.95753 2.63686 5.28019 0.16115 2.0213 0.9394 0.53757 3.49828 2.71792 1.34421 0.67042 4.84003 09/20/2019 5 5 4 40 2 20 60 09/06/2018 0 0 0 0 0 0 0   . . . . . . . 36 0 1 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
);