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

49 rows where Number of Fines = 1 and ownership = "Government - Hospital district"

View and edit SQL

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, Provider Resides in Hospital, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, 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, 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 Number of Health Revisits, Rating Cycle 2 Health Revisit 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, Number of Facility Reported Incidents, Number of Substantiated Complaints, 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
245 505 W ELM BUCKLIN, KS 67834 37.54739 -99.640197 0   175500 HILL TOP HOUSE 505 W ELM, PO BOX 248 BUCKLIN KS 67834 6208263202 280 Ford Government - Hospital district 30 26.7 Medicare and Medicaid false 01/01/2008 false   false false false Resident Yes 4   5   1   1     2 5   5       2.57693 0.11878 1.34157 1.46035 4.03728 0.00417 1.89897 0.63808 0.29316 2.83021 2.82033 0.13998 1.7224 4.57428 11/07/2019 0 0 0 0 0 0 0 10/31/2018 0 0 0 0 0 0 0 2017-03-29 8 8 0 2 64 32 96 16 0 0 1 3316.00 0 1 505 W ELM BUCKLIN, KS 67834 (37.54739, -99.640197) 02/01/2020
488 206 GRACE ST COLQUITT, GA 39837 31.175147 -84.735961 0   115039 MILLER NURSING HOME 206 GRACE ST COLQUITT GA 39837 2297584270 741 Miller Government - Hospital district 127 124.7 Medicare and Medicaid true 02/10/1967 false   false false false Resident Yes 5   4   5   5     2 2   2       2.36799 1.86933 1.28239 3.15172 5.51971 0.01797 2.37194 0.93188 1.45507 4.75888 2.07488 1.50838 0.33172 3.71933 11/07/2019 2 2 0 12 1 0 12 06/28/2018 1 1 1 8 1 0 8 2017-07-13 1 1 0 1 4 0 4 9.333 0 0 1 17835.00 1 2 206 GRACE ST COLQUITT, GA 39837 (31.175147, -84.735961) 02/01/2020
530 419 S CORAL ST KALKASKA, MI 49646 44.730897 -85.183837 0   235407 KALKASKA MEMORIAL HEALTH CENTER 419 S CORAL ST KALKASKA MI 49646 2312587500 390 Kalkaska Government - Hospital district 104 94.9 Medicare and Medicaid true 06/29/1980 false   false false false Resident Yes 5   4   3   3   3   5   5       3.17648 0.31635 0.86569 1.18204 4.35852 0 1.84694 0.63329 0.28139 2.76161 3.57446 0.37562 1.15796 5.06093 08/08/2019 8 6 2 32 1 0 32 07/13/2018 14 10 4 84 2 42 126 2017-04-12 6 3 3 1 40 0 40 64.667 6 5 1 10000.00 0 1 419 S CORAL ST KALKASKA, MI 49646 (44.730897, -85.183837) 02/01/2020
559 301 W ESSEX ST LEBANON, IN 46052 40.056314 -86.471383 0   155404 ESSEX NURSING AND REHABILITATION CENTER 301 W ESSEX ST LEBANON IN 46052 7654821950 50 Boone Government - Hospital district 38 28.7 Medicare and Medicaid false 11/01/1991 false SFF Candidate false false false Resident Yes 1   1   1   1     2 3   4       1.23689 0.47639 0.94884 1.42523 2.66211 0.06785 1.8606 0.80601 0.42192 3.08852 1.38164 0.44443 0.84644 2.76394 08/15/2019 17 16 1 124 1 0 124 09/14/2018 11 10 5 429 2 215 644 2017-10-16 8 8 0 1 36 0 36 282.667 0 3 1 157425.00 1 2 301 W ESSEX ST LEBANON, IN 46052 (40.056314, -86.471383) 02/01/2020
709 705 N BRADY STREET ABILENE, KS 67410 38.922145 -97.204623 0   175244 MEMORIAL HOSPITAL LTCU (VILLAGE MANOR) 705 N BRADY STREET ABILENE KS 67410 7852631431 200 Dickinson Government - Hospital district 78 68.4 Medicare and Medicaid true 04/01/1993 true   false false false Resident Yes 3   4   1   1     2 4   3       3.36895 0.50608 0.50682 1.01291 4.38186 0.02492 1.98119 0.62558 0.27501 2.88178 3.53414 0.6083 0.69365 4.87584 06/24/2019 2 2 2 8 1 0 8 09/10/2018 4 4 0 28 1 0 28 2017-02-20 3 1 3 1 32 0 32 18.667 0 1 1 7150.00 0 1 705 N BRADY STREET ABILENE, KS 67410 (38.922145, -97.204623) 02/01/2020
1027 405 RIO VISTA LN RISING SUN, IN 47040 38.943005 -84.861849 0   155483 WATERS OF RISING SUN, THE 405 RIO VISTA LN RISING SUN IN 47040 8124382219 570 Ohio Government - Hospital district 58 43.8 Medicare and Medicaid false 05/01/1993 false   false false false Resident Yes 3   3   3   5   2   2   2       1.6915 0.92781 0.47258 1.40039 3.09189 0.0846 2.15207 0.77976 0.37313 3.30496 1.63355 0.89471 0.47671 2.99993 07/25/2019 12 9 3 64 1 0 64 06/22/2018 7 7 0 28 1 0 28 2017-05-26 3 2 1 1 16 0 16 44 1 5 1 11278.00 0 1 405 RIO VISTA LN RISING SUN, IN 47040 (38.943005, -84.861849) 02/01/2020
2289 32 NORTH 2ND STREET GREENSBURG, LA 70441 30.830385 -90.665362 0   195610 ST HELENA PARISH NURSING HOME 32 NORTH 2ND STREET GREENSBURG LA 70441 2252224102 450 St. Helena Government - Hospital district 72 57.9 Medicare and Medicaid true 10/22/2004 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.63441 1.34785 0.40905 1.7569 4.39131 0.00394 2.03035 0.6119 0.27388 2.91613 2.69667 1.65633 0.56215 4.82881 12/05/2019 0 0 0 0 1 0 0 06/26/2019 6 1 5 369 1 0 369 2018-06-28 3 3 0 1 16 0 16 125.667 0 3 1 26534.00 0 1 32 NORTH 2ND STREET GREENSBURG, LA 70441 (30.830385, -90.665362) 02/01/2020
5568 200 VALLEY VIEW DRIVE PENDER, NE 68047 42.107508 -96.705466 0   285186 LEGACY GARDEN REHABILITATION & LIVING CENTER 200 VALLEY VIEW DRIVE PENDER NE 68047 4023853072 860 Thurston Government - Hospital district 42 33.4 Medicare and Medicaid false 05/01/1996 false   false false false Both Yes 4   2   5   5   4   5   5       2.54338 0.22373 0.92483 1.14856 3.69193 0.01263 1.91333 0.58736 0.27685 2.77754 2.76273 0.28642 1.25732 4.26233 10/04/2018 6 6 6 56 1 0 56 07/20/2017 9 9 9 68 1 0 68 2016-07-13 2 2 0 1 36 0 36 56.667 1 0 1 10400.00 1 2 200 VALLEY VIEW DRIVE PENDER, NE 68047 (42.107508, -96.705466) 02/01/2020
8848 5665 CREEKSIDE FOREST DRIVE THE WOODLANDS, TX 77389 30.141333 -95.508256 0   676357 THE BROADMOOR AT CREEKSIDE PARK 5665 CREEKSIDE FOREST DRIVE THE WOODLANDS TX 77389 2812558180 801 Montgomery Government - Hospital district 112 103.3 Medicare and Medicaid false 04/10/2014 false   false false false Resident Yes 1   2   4   3   4   1   1       1.60872 0.90939 0.30757 1.21696 2.82568 0.09441 2.06525 0.88455 0.49328 3.44308 1.61891 0.77306 0.23468 2.63166 07/12/2019 7 5 4 36 1 0 36 08/17/2018 21 5 18 184 1 0 184 2017-06-29 3 2 1 1 32 0 32 84.667 2 39 1 7803.00 0 1 5665 CREEKSIDE FOREST DRIVE THE WOODLANDS, TX 77389 (30.141333, -95.508256) 02/01/2020
8857 646 16TH STREET ASTORIA, OR 97103 46.186735 -123.825496 0   385144 CLATSOP CARE CENTER 646 16TH STREET ASTORIA OR 97103 5033250313 30 Clatsop Government - Hospital district 71 28 Medicare and Medicaid false 11/01/1979 false   false false false Resident Yes 2   3   4   3   4   1 12 1 12     2.76071 0.73177 0.98556 1.71733 4.47804 0 2.17169 0.74932 0.34579 3.2668 2.64204 0.73433 1.07274 4.39561 11/09/2018 4 4 0 24 1 0 24 07/28/2017 11 3 8 52 2 26 78 2016-07-29 11 1 10 1 68 0 68 49.333 3 12 1 6250.00 0 1 646 16TH STREET ASTORIA, OR 97103 (46.186735, -123.825496) 02/01/2020
8914 228 W MC DOWELL AVE ALTURAS, CA 96101 41.479949 -120.545503 0   555420 MODOC MEDICAL CENTER D/P SNF 228 W MC DOWELL AVE ALTURAS CA 96101 5302335131 350 Modoc Government - Hospital district 71 40.4 Medicare and Medicaid true 05/04/1990 false   false false false Both Yes 2   3   2   2     2 1 12 1 12     3.24273 1.60289 0.18412 1.78701 5.02974 0 1.94051 0.59385 0.26326 2.79762 3.47305 2.02962 0.26323 5.76515 11/01/2018 11 10 1 72 1 0 72 11/02/2017 14 10 4 72 1 0 72 2016-09-29 11 11 0 1 52 0 52 68.667 3 2 1 8125.00 0 1 228 W MC DOWELL AVE ALTURAS, CA 96101 (41.479949, -120.545503) 02/01/2020
9580 2300 JACK FINNEY BLVD GREENVILLE, TX 75402 33.07493 -96.105697 0   675774 LEGEND HEALTHCARE AND REHABILITATION - GREENVILLE 2300 JACK FINNEY BLVD GREENVILLE TX 75402 9034557942 670 Hunt Government - Hospital district 126 93.1 Medicare and Medicaid false 02/11/1999 false   false false false Resident Yes 1   2   4   3   5   1   1       1.68949 1.02894 0.25486 1.28381 2.97329 0.22885 2.19787 0.84145 0.43326 3.47257 1.5976 0.91949 0.22141 2.74561 08/08/2019 6 6 0 32 1 0 32 08/24/2018 5 5 1 40 1 0 40 2017-06-29 17 3 15 1 292 0 292 78 1 5 1 6636.00 1 2 2300 JACK FINNEY BLVD GREENVILLE, TX 75402 (33.07493, -96.105697) 02/01/2020
9794 3430 HARRISON BOULEVARD OGDEN, UT 84403 41.201045 -111.948684 0   465009 HARRISON POINTE HEALTHCARE AND REHABILITATION 3430 HARRISON BOULEVARD OGDEN UT 84403 8013995609 280 Weber Government - Hospital district 63 37.2 Medicare and Medicaid false 04/30/1979 false   false false false Resident Yes 5   4   5   5   5   3   4       2.02033 0.50203 1.09903 1.60106 3.62139 0.04899 2.21617 0.86045 0.45923 3.53584 1.89468 0.43872 0.90077 3.28424 11/06/2019 3 3 0 16 1 0 16 10/16/2018 0 0 0 0 0 0 0 2017-06-22 5 5 0 1 60 0 60 18 0 0 1 12678.00 0 1 3430 HARRISON BOULEVARD OGDEN, UT 84403 (41.201045, -111.948684) 02/01/2020
9968 1000 MCKINLEY ST BENBROOK, TX 76126 32.676998 -97.464458 0   675906 BENBROOK NURSING & REHABILITATION CENTER 1000 MCKINLEY ST BENBROOK TX 76126 8172490020 910 Tarrant Government - Hospital district 115 55 Medicare and Medicaid false 03/06/2002 false SFF Candidate false false false Resident Yes 1   1   3   5   1   1   1       2.0532 1.15428 0.26138 1.41566 3.46886 0.16289 1.96327 0.80198 0.4229 3.18815 2.17354 1.08226 0.23263 3.489 12/06/2019 3 3 0 20 0 0 20 01/25/2019 9 2 7 80 1 0 80 2018-07-12 19 3 17 1 1756 0 1756 329.333 4 12 1 13600.00 1 2 1000 MCKINLEY ST BENBROOK, TX 76126 (32.676998, -97.464458) 02/01/2020
10054 372 HILL ROAD SMITHVILLE, TX 78957 30.003493 -97.13483 0   675942 TOWERS NURSING HOME 372 HILL ROAD SMITHVILLE TX 78957 5122374606 100 Bastrop Government - Hospital district 83 85.2 Medicare and Medicaid false 12/17/2002 false   false false false Resident Yes 3   4   2   1   3   1 12 1 12     1.93959 1.18866 0.17055 1.35922 3.29881 0 2.0157 0.82307 0.44213 3.2809 1.99986 1.08594 0.14519 3.22416 06/26/2019 1 1 0 16 1 0 16 07/25/2018 4 4 0 24 1 0 24 2017-07-13 6 6 0 1 56 0 56 25.333 0 0 1 7287.00 0 1 372 HILL ROAD SMITHVILLE, TX 78957 (30.003493, -97.13483) 02/01/2020
10299 733 CEDAR STREET GARBERVILLE, CA 95542 40.101491 -123.792756 0   555516 JEROLD PHELPS COMM HOSP SNF 733 CEDAR STREET GARBERVILLE CA 95542 7079233921 110 Humboldt Government - Hospital district 17 8.8 Medicare and Medicaid true 08/25/1992 false   false false false Resident Yes 3   2   4   4     2 5   5       1.33148 2.9108 2.70093 5.61173 6.94321 0 1.81991 0.63062 0.31134 2.76187 1.52055 3.47079 3.26516 8.06138 08/22/2019 3 3 0 183 1 0 183 07/11/2018 2 2 0 12 1 0 12 2017-06-16 6 6 0 1 64 0 64 106.167 0 0 1 9952.00 0 1 733 CEDAR STREET GARBERVILLE, CA 95542 (40.101491, -123.792756) 02/01/2020
10403 1038 MCGILL LANE SAINT STEPHEN, SC 29479 33.398011 -79.933413 0   425341 LAKE MOULTRIE NURSING HOME 1038 MCGILL LANE SAINT STEPHEN SC 29479 8435672307 70 Berkeley Government - Hospital district 88 84.9 Medicare and Medicaid false 05/01/1995 false   false false false Resident Yes 4   4   4   5   3   4   3       2.67741 0.94218 0.48572 1.42789 4.1053 0.0378 2.07948 0.6035 0.25857 2.94155 2.67594 1.17393 0.70702 4.47531 08/31/2018 6 6 0 20 1 0 20 05/25/2017 4 4 0 16 1 0 16 2016-06-17 3 3 0 1 16 0 16 18 0 0 1 3421.00 0 1 1038 MCGILL LANE SAINT STEPHEN, SC 29479 (33.398011, -79.933413) 02/01/2020
10487 389 SERPENTINE DRIVE SPARTANBURG, SC 29303 34.966404 -81.93694 0   425384 SPARTANBURG HOSPITAL FOR RESTORATIVE CARE SNF 389 SERPENTINE DRIVE SPARTANBURG SC 29303 8645603265 410 Spartanburg Government - Hospital district 25 12.4 Medicare true 03/07/2006 false   true false false Resident Yes 4   2   5     2 5   5   5       2.79881 0.6173 4.3158 4.9331 7.73191 0.47893 1.99646 0.98538 0.5512 3.53304 2.9136 0.47106 2.947 7.01764 03/07/2019 3 0 3 60 0 0 60 04/04/2018 1 1 0 4 1 0 4 2017-02-22 0 0 0 0 0 0 0 31.333 2 0 1 19416.00 0 1 389 SERPENTINE DRIVE SPARTANBURG, SC 29303 (34.966404, -81.93694) 02/01/2020
10523 5915 ELYSIAN FIELDS ROAD MARSHALL, TX 75672 32.503096 -94.30906 0   676187 HERITAGE HOUSE OF MARSHALL HEALTH & REHABILITATION 5915 ELYSIAN FIELDS ROAD MARSHALL TX 75672 9039356700 620 Harrison Government - Hospital district 125 79.9 Medicare and Medicaid false 07/10/2008 false   false false false Resident Yes 1   2   2   3   1   1   1       2.27697 0.97748 0.19358 1.17106 3.44803 0.0183 2.11412 0.79682 0.41051 3.32145 2.23843 0.92242 0.17749 3.32886 05/22/2019 7 2 6 40 1 0 40 04/27/2018 5 5 5 72 1 0 72 2017-05-25 12 11 1 1 164 0 164 71.333 0 5 1 19344.00 1 2 5915 ELYSIAN FIELDS ROAD MARSHALL, TX 75672 (32.503096, -94.30906) 02/01/2020
10627 1802 S 31ST TEMPLE, TX 76504 31.08374 -97.363983 0   455637 WELLINGTON REHABILITATION AND HEALTHCARE 1802 S 31ST TEMPLE TX 76504 2547784231 120 Bell Government - Hospital district 124 61 Medicare and Medicaid true 02/14/1986 false   false false false Resident Yes 3   3   5   5   5   1   1       1.58126 1.22803 0.22906 1.45709 3.03835 0.21351 2.08166 0.8136 0.41807 3.31334 1.57874 1.13495 0.20622 2.94053 03/20/2019 7 7 0 60 1 0 60 03/01/2018 2 2 1 24 1 0 24 2017-01-12 5 3 2 1 80 0 80 51.333 2 0 1 13000.00 0 1 1802 S 31ST TEMPLE, TX 76504 (31.08374, -97.363983) 02/01/2020
10826 741 N MAIN STREET CEDARVILLE, CA 96104 41.531931 -120.171899 0   555221 SURPRISE VALLEY COMMUNITY HOSPITAL D/P SNF 741 N. MAIN STREET CEDARVILLE CA 96104 5302796111 350 Modoc Government - Hospital district 22 16.9 Medicare and Medicaid false 04/15/1986 false   true false false Resident Yes 1   1   2   2     2 1 12 1 12 6 6                             07/17/2019 25 13 12 132 1 0 132 07/26/2018 16 11 5 108 1 0 108 2017-06-29 22 19 3 2 164 82 246 143 17 6 1 9984.00 1 2 741 N MAIN STREET CEDARVILLE, CA 96104 (41.531931, -120.171899) 02/01/2020
10938 1000 E Hwy 82, Sherman, TX 75090, USA 33.66833829999999 -96.6043275 1 ROOFTOP 455573 TEXOMA HEALTHCARE CENTER 1000 HWY 82 E SHERMAN TX 75090 9038939636 564 Grayson Government - Hospital district 179 106.3 Medicare and Medicaid false 11/21/1985 false   false false false Resident Yes 3   3   3   2   4   3   3       2.03971 1.10129 0.6405 1.74179 3.78151 0.18173 2.03316 0.84076 0.43265 3.30657 2.08504 0.98495 0.5572 3.66725 09/19/2019 2 2 0 24 1 0 24 09/20/2018 8 7 1 68 1 0 68 2017-09-13 5 3 3 1 52 0 52 43.333 1 0 1 13627.00 1 2   02/01/2020
11169 2700 WEST 5600 SOUTH ROY, UT 84067 41.161662 -112.045195 0   465003 HERITAGE PARK HEALTHCARE AND REHABILITATION 2700 WEST 5600 SOUTH ROY UT 84067 8018259731 280 Weber Government - Hospital district 176 103.1 Medicare and Medicaid true 01/01/1978 false   false false false Both Yes 3   2   5   5   5   3   3       2.65766 0.33464 1.00346 1.3381 3.99576 0.11807 2.17683 0.85551 0.60164 3.63398 2.53741 0.29413 0.62776 3.5259 02/21/2019 9 7 3 60 1 0 60 01/17/2018 15 13 2 80 1 0 80 2016-08-18 15 10 5 1 100 0 100 73.333 0 13 1 3356.00 0 1 2700 WEST 5600 SOUTH ROY, UT 84067 (41.161662, -112.045195) 02/01/2020
11402 18648 HILLCREST RD DALLAS, TX 75252 33.005004 -96.78344 0   676315 THE HILLCREST OF NORTH DALLAS 18648 HILLCREST RD DALLAS TX 75252 9725177771 390 Dallas Government - Hospital district 120 85.8 Medicare and Medicaid false 06/18/2012 false   false false false Resident Yes 1   1   2   3   1   1   1       1.89411 0.8639 0.3463 1.21019 3.1043 0.07688 2.1772 0.83312 0.44411 3.45443 1.8081 0.77972 0.29349 2.88165 05/13/2019 10 10 4 186 1 0 186 05/18/2018 7 5 6 40 1 0 40 2017-04-28 7 3 7 1 88 0 88 121 3 3 1 13905.00 0 1 18648 HILLCREST RD DALLAS, TX 75252 (33.005004, -96.78344) 02/01/2020
11524 11902 RESOURCE PKWY HOUSTON, TX 77089 29.585839 -95.209096 0   675819 PARK MANOR OF SOUTH BELT 11902 RESOURCE PKWY HOUSTON TX 77089 2819226802 610 Harris Government - Hospital district 120 107.9 Medicare and Medicaid false 01/07/2000 false   false false false Resident Yes 4   3   5   5   5   2   2       1.78399 0.85005 0.3381 1.18815 2.97214 0.04714 2.06809 0.77214 0.36803 3.20825 1.79283 0.82781 0.34578 2.97067 02/15/2019 5 3 2 28 1 0 28 03/09/2018 7 4 3 76 1 0 76 2017-04-06 5 5 0 1 64 0 64 50 0 4 1 8648.00 0 1 11902 RESOURCE PKWY HOUSTON, TX 77089 (29.585839, -95.209096) 02/01/2020
11905 1114 EAST GEORGIA ROAD WOODRUFF, SC 29388 34.750101 -82.017402 0   425179 WOODRUFF MANOR 1114 EAST GEORGIA ROAD WOODRUFF SC 29388 8644767092 410 Spartanburg Government - Hospital district 88 83.3 Medicare and Medicaid false 01/05/1990 false   false false false Resident Yes 4   3   3   2   3   4   4       2.14426 0.60782 0.58606 1.19388 3.33813 0.02056 1.97244 0.60892 0.26273 2.84409 2.25938 0.75058 0.83958 3.76369 10/04/2018 8 8 0 44 1 0 44 09/28/2017 4 4 0 32 1 0 32 2016-09-16 14 12 2 1 60 0 60 42.667 0 0 1 13627.00 0 1 1114 EAST GEORGIA ROAD WOODRUFF, SC 29388 (34.750101, -82.017402) 02/01/2020
11971 103 TEAKWOOD ST CENTERVILLE, TX 75833 31.251578 -95.973091 0   675065 CENTERVILLE HEALTHCARE CENTER 103 TEAKWOOD ST CENTERVILLE TX 75833 9035362596 756 Leon Government - Hospital district 74 34 Medicare and Medicaid false 06/25/1992 false   false false false Resident Yes 4   3   5   5     2 2   2       1.83023 0.95489 0.44045 1.39535 3.22558 0.03204 1.95013 0.82084 0.42621 3.19718 1.95056 0.87475 0.38896 3.23515 10/23/2019 5 5 0 44 0 0 44 10/17/2018 6 5 1 44 1 0 44 2017-09-22 11 6 5 1 168 0 168 64.667 0 3 1 5200.00 0 1 103 TEAKWOOD ST CENTERVILLE, TX 75833 (31.251578, -95.973091) 02/01/2020
12248 1007 S WASHINGTON AVE MARSHALL, TX 75670 32.535369 -94.367932 0   455646 MARSHALL MANOR NURSING & REHABILITATION CENTER 1007 S WASHINGTON AVE MARSHALL TX 75670 9039357971 620 Harrison Government - Hospital district 169 118.2 Medicare and Medicaid false 03/27/1986 false SFF Candidate true false false Resident Yes 1   1   4   5   1   3   2       2.66468 1.30888 0.45096 1.75984 4.42452 0.0224 1.95412 0.7996 0.41351 3.16723 2.83406 1.23086 0.41047 4.4796 08/02/2019 10 10 1 758 1 0 758 06/28/2018 1 1 0 4 1 0 4 2017-05-17 4 4 0 1 28 0 28 385 0 0 1 113370.00 0 1 1007 S WASHINGTON AVE MARSHALL, TX 75670 (32.535369, -94.367932) 02/01/2020
12353 1219 EASTWOOD DR SEGUIN, TX 78155 29.563805 -97.942728 0   675380 WINDSOR NURSING AND REHABILITATION CENTER OF SEGUI 1219 EASTWOOD DR SEGUIN TX 78155 8303797777 581 Guadalupe Government - Hospital district 122 103.7 Medicare and Medicaid false 08/10/1994 false   false false false Resident Yes 1   2   4   4   4   1   1       1.58399 0.74956 0.19832 0.94788 2.53187 0.04929 2.03458 0.84233 0.44658 3.32349 1.61806 0.66913 0.16714 2.44287 04/17/2019 9 8 6 60 1 0 60 05/03/2018 13 12 5 96 1 0 96 2017-06-05 13 12 1 1 216 0 216 98 1 4 1 3999.00 0 1 1219 EASTWOOD DR SEGUIN, TX 78155 (29.563805, -97.942728) 02/01/2020
12842 4910 EMORY LUBBOCK, TX 79416 33.604905 -101.918093 0   676105 THE PLAZA AT LUBBOCK 4910 EMORY LUBBOCK TX 79416 8067400800 770 Lubbock Government - Hospital district 102 106.6 Medicare and Medicaid false 07/05/2006 false   false false false Resident Yes 1   2   4   4   3   1   1       1.66842 1.04684 0.20603 1.25286 2.92129 0.10145 1.98482 0.78871 0.39776 3.17129 1.74704 0.99803 0.19496 2.95387 05/16/2019 10 8 2 112 1 0 112 04/20/2018 12 12 0 92 1 0 92 2017-05-19 6 6 0 1 56 0 56 96 1 1 1 13905.00 0 1 4910 EMORY LUBBOCK, TX 79416 (33.604905, -101.918093) 02/01/2020
13162 930 S BAXTER TYLER, TX 75701 32.338369 -95.285508 0   455429 ROSE TRAIL NURSING AND REHABILITATION CENTER 930 S BAXTER TYLER TX 75701 9035972068 892 Smith Government - Hospital district 76 84.6 Medicare and Medicaid false 01/01/1977 false   false false false Resident Yes 1   3   1   3   1   1   1       2.17001 1.12605 0.38886 1.51491 3.68492 0.06056 2.01575 0.87818 0.49751 3.39144 2.23739 0.96418 0.29418 3.48415 07/18/2019 5 5 0 24 1 0 24 05/11/2018 4 4 0 48 1 0 48 2017-05-24 16 9 16 1 164 0 164 55.333 1 3 1 10784.00 0 1 930 S BAXTER TYLER, TX 75701 (32.338369, -95.285508) 02/01/2020
13384 15015 CYPRESS WOODS MEDICAL DR HOUSTON, TX 77014 29.998241 -95.467217 0   676239 VILLA TOSCANA AT CYPRESS WOODS 15015 CYPRESS WOODS MEDICAL DR HOUSTON TX 77014 2815866088 610 Harris Government - Hospital district 120 98.8 Medicare and Medicaid false 11/04/2009 false SFF Candidate true false false Resident Yes 1   1   4   4   5   2   2       1.98753 0.89274 0.47604 1.36878 3.35631 0.03624 2.1686 0.86806 0.45186 3.48852 1.9048 0.77332 0.39653 3.08513 07/17/2019 19 16 5 482 1 0 482 08/10/2018 13 5 9 120 1 0 120 2017-07-13 8 4 4 1 104 0 104 298.333 4 11 1 34092.00 1 2 15015 CYPRESS WOODS MEDICAL DR HOUSTON, TX 77014 (29.998241, -95.467217) 02/01/2020
13526 7210 NORTHLINE DR HOUSTON, TX 77076 29.86649 -95.397795 0   675423 ASHFORD GARDENS 7210 NORTHLINE DR HOUSTON TX 77076 7136992882 610 Harris Government - Hospital district 202 86.2 Medicare and Medicaid false 10/06/1994 false   false false false Both Yes 1   1   2   2   2   1 12 1 12     2.14697 1.09963 0.2094 1.30903 3.456 0.04737 2.05745 0.8481 0.45743 3.36299 2.16876 0.97495 0.1723 3.29535 06/20/2019 11 9 2 64 1 0 64 06/29/2018 19 12 7 350 1 0 350 2017-07-20 10 5 5 1 64 0 64 159.333 1 15 1 87793.00 0 1 7210 NORTHLINE DR HOUSTON, TX 77076 (29.86649, -95.397795) 02/01/2020
13799 1200 JACKSON ST N SULPHUR SPRINGS, TX 75482 33.153753 -95.597239 0   675664 SUNNY SPRINGS NURSING & REHAB 1200 JACKSON ST N SULPHUR SPRINGS TX 75482 9038856571 654 Hopkins Government - Hospital district 95 59.2 Medicare and Medicaid false 02/08/1997 false   false false false Resident Yes 2   3   4   4   4   1   1       2.2657 0.98149 0.27276 1.25425 3.51995 0.01108 2.0788 0.79415 0.43183 3.30478 2.2652 0.92932 0.23774 3.41544 01/09/2019 2 0 2 12 0 0 12 02/22/2018 8 8 8 88 1 0 88 2017-01-25 12 10 2 1 132 0 132 57.333 0 4 1 4293.00 1 2 1200 JACKSON ST N SULPHUR SPRINGS, TX 75482 (33.153753, -95.597239) 02/01/2020
13889 538 SOUTH 500 EAST AMERICAN FORK, UT 84003 40.366507 -111.785464 0   465178 STONEHENGE OF AMERICAN FORK 538 SOUTH 500 EAST AMERICAN FORK UT 84003 8016422000 240 Utah Government - Hospital district 119 72.9 Medicare and Medicaid false 09/21/2012 false   false false false Resident Yes 5   3   5   5   5   5   5       2.71349 0.72105 1.24601 1.96706 4.68055 0.17258 2.23093 0.86842 0.42996 3.52931 2.52789 0.62434 1.09074 4.25266 08/15/2019 6 6 0 40 1 0 40 07/09/2018 5 5 0 32 1 0 32 2017-03-29 11 11 10 1 72 0 72 42.667 0 3 1 9955.00 1 2 538 SOUTH 500 EAST AMERICAN FORK, UT 84003 (40.366507, -111.785464) 02/01/2020
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 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
14254 1124 WASHINGTON BLVD NEWCASTLE, WY 82701 43.848747 -104.188756 0   535023 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BLVD NEWCASTLE WY 82701 3077464491 220 Weston Government - Hospital district 58 54.4 Medicare and Medicaid true 09/04/1984 false   false false false Resident Yes 5   5   3   3     2 4   4       3.13227 0.47724 0.68337 1.16061 4.29289 0 2.07794 0.63806 0.28693 3.00293 3.13287 0.56243 0.8964 4.58413 04/25/2019 1 1 0 16 1 0 16 03/15/2018 4 4 4 12 1 0 12 2017-02-09 6 6 0 1 44 0 44 19.333 0 0 1 57428.00 0 1 1124 WASHINGTON BLVD NEWCASTLE, WY 82701 (43.848747, -104.188756) 02/01/2020
14287 303 HOLLOW TREE LANE HOUSTON, TX 77090 30.025512 -95.438313 0   676356 THE HEIGHTS OF NORTH HOUSTON 303 HOLLOW TREE LANE HOUSTON TX 77090 8327058700 610 Harris Government - Hospital district 131 96.1 Medicare and Medicaid false 01/23/2014 false   false false false Resident Yes 1   2   3   5   1   1   1       1.8031 0.85638 0.32109 1.17747 2.98057 0.10838 2.03009 0.80098 0.39136 3.22243 1.84596 0.80394 0.30881 2.96599 02/28/2019 10 7 3 80 1 0 80 02/09/2018 12 6 7 76 1 0 76 2017-02-23 7 3 5 1 80 0 80 78.667 6 13 1 2533.00 0 1 303 HOLLOW TREE LANE HOUSTON, TX 77090 (30.025512, -95.438313) 02/01/2020
14456 300 S HIGHWAY 36 BYPASS GATESVILLE, TX 76528 31.426673 -97.715998 0   675201 HILLSIDE MEDICAL LODGE 300 S. HIGHWAY 36 BYPASS GATESVILLE TX 76528 2548657575 341 Coryell Government - Hospital district 128 110.8 Medicare and Medicaid false 11/16/1993 false   false false false Resident Yes 2   4   1   2   1   1   1       1.6729 0.91552 0.10044 1.01596 2.68887 0.05035 2.31199 0.85446 0.42146 3.58791 1.50384 0.80568 0.0897 2.40315 04/24/2019 2 1 1 28 1 0 28 05/10/2018 1 1 0 16 1 0 16 2017-04-05 2 2 0 1 16 0 16 22 0 0 1 13905.00 0 1 300 S HIGHWAY 36 BYPASS GATESVILLE, TX 76528 (31.426673, -97.715998) 02/01/2020
14680 5455 KNICKERBOCKER RD SAN ANGELO, TX 76904 31.401739 -100.481477 0   676100 SAN ANGELO NURSING AND REHAB 5455 KNICKERBOCKER RD SAN ANGELO TX 76904 3259441660 930 Tom Green Government - Hospital district 125 82.5 Medicare and Medicaid false 04/11/2006 false   false false true Resident Yes 1   1   3   2   4   1   1       2.04074 1.21761 0.10959 1.32719 3.36794 0.13374 2.14981 0.82694 0.43083 3.40758 1.9729 1.10717 0.09574 3.16935 05/24/2019 5 5 0 40 1 0 40 05/04/2018 14 7 7 342 1 0 342 2017-03-03 19 16 3 1 224 0 224 171.333 7 6 1 6500.00 1 2 5455 KNICKERBOCKER RD SAN ANGELO, TX 76904 (31.401739, -100.481477) 02/01/2020
14690 2400 QUAKER AVE LUBBOCK, TX 79410 33.57211 -101.905074 0   675842 MI CASITA NURSING AND REHABIITATION CENTER 2400 QUAKER AVE LUBBOCK TX 79410 8067922831 770 Lubbock Government - Hospital district 95 49.8 Medicare and Medicaid false 08/24/2000 false   false false false Both Yes 1   2   3   5   1   1   1       1.79437 1.07532 0.15479 1.23011 3.02448 0.02146 1.6773 0.74084 0.37541 2.79354 2.22341 1.09143 0.15519 3.47175 12/13/2018 7 6 1 72 2 36 108 12/08/2017 20 17 3 120 1 0 120 2017-01-11 7 7 0 1 68 0 68 105.333 1 1 1 21601.00 0 1 2400 QUAKER AVE LUBBOCK, TX 79410 (33.57211, -101.905074) 02/01/2020
14718 815 OLD CHEROKEE ROAD LEXINGTON, SC 29072 34.008581 -81.250825 0   425321 L.M.C.- EXTENDED CARE 815 OLD CHEROKEE ROAD LEXINGTON SC 29072 8033595181 310 Lexington Government - Hospital district 388 329.1 Medicare and Medicaid false 12/17/1991 false   false false false Resident Yes 2   1   5   5   5   3   3       2.12292 0.99337 0.53076 1.52412 3.64704 0.0497 2.06405 0.68093 0.30111 3.04608 2.13762 1.09696 0.66345 3.8393 08/23/2018 3 3 0 12 1 0 12 04/21/2017 14 13 1 527 1 0 527 2016-06-16 5 5 0 1 16 0 16 184.333 1 0 1 13627.00 0 1 815 OLD CHEROKEE ROAD LEXINGTON, SC 29072 (34.008581, -81.250825) 02/01/2020
14740 1941 CHESTNUT ST COLORADO CITY, TX 79512 32.405821 -100.863687 0   676225 MITCHELL COUNTY NURSING AND REHABILITATION CENTER 1941 CHESTNUT ST COLORADO CITY TX 79512 3257285247 797 Mitchell Government - Hospital district 96 53.2 Medicare and Medicaid false 10/15/2009 false   false false false Resident Yes 1   1   2   1   2   1 12 1 12     1.89014 1.0354 0.15509 1.19049 3.08063 0.00693 1.93684 0.81563 0.44524 3.19771 2.02823 0.95455 0.1311 3.08925 08/07/2019 6 6 1 36 1 0 36 08/30/2018 7 7 0 64 1 0 64 2017-06-19 9 9 7 1 735 0 735 161.833 1 2 1 100000.00 1 2 1941 CHESTNUT ST COLORADO CITY, TX 79512 (32.405821, -100.863687) 02/01/2020
14940 11020 DESSAU RD AUSTIN, TX 78754 30.36935 -97.667987 0   676238 LEGEND OAKS HEALTHCARE AND REHABILITATION - NORTH 11020 DESSAU RD AUSTIN TX 78754 5128732244 940 Travis Government - Hospital district 124 93.3 Medicare and Medicaid false 10/20/2009 false   false false false Resident Yes 3   3   5   5   5   1   1       2.05467 0.81898 0.31168 1.13066 3.18533 0.11212 2.22713 0.89039 0.48371 3.60124 1.91739 0.69164 0.24252 2.83632 04/25/2019 5 5 0 40 1 0 40 03/07/2018 9 8 1 60 1 0 60 2017-04-27 8 2 7 1 132 0 132 62 2 3 1 135616.00 1 2 11020 DESSAU RD AUSTIN, TX 78754 (30.36935, -97.667987) 02/01/2020
15149 5301 UNIVERSITY AVE LUBBOCK, TX 79413 33.545631 -101.870339 0   675346 HERITAGE OAKS NURSING AND REHABILITATION CENTER 5301 UNIVERSITY AVE LUBBOCK TX 79413 8067958792 770 Lubbock Government - Hospital district 159 111.7 Medicare and Medicaid false 06/29/1994 false   false false false Resident Yes 1   1   4   3   4   1   1       1.88236 1.52679 0.18693 1.71372 3.59608 0.15019 2.03947 0.79989 0.41066 3.25002 1.91823 1.43526 0.17133 3.5481 11/22/2019 9 7 2 92 1 0 92 10/05/2018 22 14 8 393 1 0 393 2017-10-27 11 11 0 1 76 0 76 189.667 4 7 1 13627.00 1 2 5301 UNIVERSITY AVE LUBBOCK, TX 79413 (33.545631, -101.870339) 02/01/2020
15174 8383 MEADOW RD DALLAS, TX 75231 32.885996 -96.759293 0   455463 THE MEADOWS HEALTH AND REHABILITATION CENTER 8383 MEADOW RD DALLAS TX 75231 2142396000 390 Dallas Government - Hospital district 186 95.5 Medicare and Medicaid false 12/19/1980 false   false false false Resident Yes 1   1   4   4   5   2   2       1.75534 0.9557 0.45584 1.41154 3.16688 0.03028 2.00465 0.81823 0.44181 3.26469 1.81986 0.87827 0.38834 3.11059 10/18/2019 4 4 0 153 1 0 153 11/03/2018 12 11 10 167 1 0 167 2017-10-12 4 2 4 1 32 0 32 137.5 2 4 1 38470.00 0 1 8383 MEADOW RD DALLAS, TX 75231 (32.885996, -96.759293) 02/01/2020
15293 612 MAIN STREET SOLEDAD, CA 93960 36.433181 -121.32437 0   555538 EDEN VALLEY CARE CENTER 612 MAIN STREET SOLEDAD CA 93960 8316782462 370 Monterey Government - Hospital district 59 31.8 Medicare and Medicaid false 01/15/1993 false   false false false Both Yes 5   5   5   5   5   4   4       4.14609 1.41851 0.8816 2.30012 6.4462 0.17505 2.09785 0.72702 0.34202 3.16689 4.10753 1.46713 0.97018 6.52715 07/31/2019 2 2 0 8 1 0 8 07/12/2018 4 4 0 16 1 0 16 2017-07-26 1 0 1 0 20 0 20 12.667 1 0 1 6893.00 0 1 612 MAIN STREET SOLEDAD, CA 93960 (36.433181, -121.32437) 02/01/2020
15363 1101 WINDBELL DR MESQUITE, TX 75149 32.78045 -96.619798 0   676326 EDGEWOOD REHABILITATION AND CARE CENTER 1101 WINDBELL DR MESQUITE TX 75149 9722888800 390 Dallas Government - Hospital district 142 81.6 Medicare and Medicaid false 10/12/2012 false   false false false Resident Yes 1   1   4   4   4   2   2       2.06998 0.86919 0.52991 1.3991 3.46908 0.07051 2.16924 0.79204 0.40252 3.3638 1.98324 0.82518 0.4955 3.30702 02/08/2019 10 10 2 56 1 0 56 01/26/2018 8 0 8 712 0 0 712 2016-11-18 1 0 1 0 8 0 8 266.667 5 6 1 33150.00 0 1 1101 WINDBELL DR MESQUITE, TX 75149 (32.78045, -96.619798) 02/01/2020
15440 575 EAST 1400 SOUTH OREM, UT 84097 40.271489 -111.681473 0   465104 OREM REHABILITATION AND NURSING CENTER 575 EAST 1400 SOUTH OREM UT 84097 8012254741 240 Utah Government - Hospital district 120 71.9 Medicare and Medicaid false 09/04/1986 false   false false false Resident Yes 4   3   5   4   5   3   3       2.15064 0.84046 0.68623 1.52669 3.67733 0.15201 2.00533 0.76093 0.36865 3.13491 2.22893 0.83053 0.70063 3.7615 10/25/2018 4 3 1 28 1 0 28 07/13/2017 11 11 10 64 1 0 64 2016-04-28 15 6 9 1 76 0 76 48 0 12 1 11053.00 1 2 575 EAST 1400 SOUTH OREM, UT 84097 (40.271489, -111.681473) 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
);