+---------+----------------------------------------+---------+----------+----------------+--------------------+--------------+---------------------+-------------------+--------------+---------------+-------------+-------------+--------------+-------------------+--------------------------+-------------+-----------------+--------------+--------------------------------+-------------------------------+-----------------------------------------------------------------+----------------------------------------+------------------------+--------------+-------------------------------------------------------+------------------------------------------------+--------------------------------------+-----------------------------------------------------+------------------+---------------------------+----------------------------+-------------------------------------+-------------+----------------------+-----------------------+--------------------------------+------------------------+---------------------------------+-------------------+----------------------------+----------------------+-------------------------------+------------------------------+----------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+---------------------------------------------------------+------------------------------------------------------------+-------------------------------------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+------------------------------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+------------------------------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+------------------------------------------+--------------------------------------------+---------------------------------------+-------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+------------------------------------------+--------------------------------------------+---------------------------------------+-------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+--------------------------------------------+------------------------------------------+---------------------------------------+-------------------------------------+--------------------------------------+-----------------------------------------+--------------------------------------+-------------------+------------------------------------+-----------------------------+-----------------------------+----------------------------------------------------------------+-------------------+
|   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   |
|---------+----------------------------------------+---------+----------+----------------+--------------------+--------------+---------------------+-------------------+--------------+---------------+-------------+-------------+--------------+-------------------+--------------------------+-------------+-----------------+--------------+--------------------------------+-------------------------------+-----------------------------------------------------------------+----------------------------------------+------------------------+--------------+-------------------------------------------------------+------------------------------------------------+--------------------------------------+-----------------------------------------------------+------------------+---------------------------+----------------------------+-------------------------------------+-------------+----------------------+-----------------------+--------------------------------+------------------------+---------------------------------+-------------------+----------------------------+----------------------+-------------------------------+------------------------------+----------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+---------------------------------------------------------+------------------------------------------------------------+-------------------------------------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+------------------------------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+------------------------------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+------------------------------------------+--------------------------------------------+---------------------------------------+-------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+------------------------------------------+--------------------------------------------+---------------------------------------+-------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+--------------------------------------------+------------------------------------------+---------------------------------------+-------------------------------------+--------------------------------------+-----------------------------------------+--------------------------------------+-------------------+------------------------------------+-----------------------------+-----------------------------+----------------------------------------------------------------+-------------------|
|      99 | 2900 FIRST STREET HUNTINGTON, WV 25702 | 38.4318 | -82.4013 |              0 |                    |       515113 | ST. MARY'S HOSPITAL | 2900 FIRST STREET | HUNTINGTON   | WV            |       25702 |  3045268983 |           50 | Cabell            | Non profit - Corporation |          19 |            15.6 | Medicare     | true                           | ST. MARY'S MEDICAL CENTER INC | 10/31/1991                                                      | false                                  |                        | false        | false                                                 | false                                          | None                                 | Yes                                                 |                3 |                           |                          4 |                                     |           3 |                      |                       |                              2 |                      3 |                                 |                 1 |                         12 |                    1 |                            12 |                            6 |                                      6 |                                                           |                                                    |                                                   |                                                         |                                                            |                                                                   |                                                           |                                                    |                                                   |                                                            |                                                           |                                                    |                                                   |                                                            | 04/17/2019                                   |                                                    6 |                                                       6 |                                                        0 |                                       40 |                                          1 |                                     0 |                                  40 | 05/09/2018                                   |                                                    2 |                                                       2 |                                                        0 |                                       16 |                                          1 |                                     0 |                                  16 | 2017-04-20                                   |                                                    2 |                                                       2 |                                                        0 |                                          1 |                                        8 |                                     0 |                                   8 |                               26.667 |                                       0 |                                    0 |                 0 |                                  0 |                           0 |                           0 | 2900 FIRST STREET HUNTINGTON, WV 25702 (38.431833, -82.401335) | 02/01/2020        |
+---------+----------------------------------------+---------+----------+----------------+--------------------+--------------+---------------------+-------------------+--------------+---------------+-------------+-------------+--------------+-------------------+--------------------------+-------------+-----------------+--------------+--------------------------------+-------------------------------+-----------------------------------------------------------------+----------------------------------------+------------------------+--------------+-------------------------------------------------------+------------------------------------------------+--------------------------------------+-----------------------------------------------------+------------------+---------------------------+----------------------------+-------------------------------------+-------------+----------------------+-----------------------+--------------------------------+------------------------+---------------------------------+-------------------+----------------------------+----------------------+-------------------------------+------------------------------+----------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+---------------------------------------------------------+------------------------------------------------------------+-------------------------------------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+------------------------------------------------------------+-----------------------------------------------------------+----------------------------------------------------+---------------------------------------------------+------------------------------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+------------------------------------------+--------------------------------------------+---------------------------------------+-------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+------------------------------------------+--------------------------------------------+---------------------------------------+-------------------------------------+----------------------------------------------+------------------------------------------------------+---------------------------------------------------------+----------------------------------------------------------+--------------------------------------------+------------------------------------------+---------------------------------------+-------------------------------------+--------------------------------------+-----------------------------------------+--------------------------------------+-------------------+------------------------------------+-----------------------------+-----------------------------+----------------------------------------------------------------+-------------------+