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

20 rows where Overall Rating = 1 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-03-02

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_city, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, 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 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
1023 1023 1310 37TH ST VERO BEACH, FL 32960 27.660261 -80.398779 0   105474 CONSULATE HEALTH CARE OF VERO BEACH 1310 37TH ST VERO BEACH FL 32960 7725695107 300 Indian River For profit - Corporation 159 145.7 Medicare and Medicaid false VERO BEACH FACILITY OPERATIONS LLC 10/06/1984 false   false false false Both Yes 1   1   2   4   1   2   2       2.50257 1.01092 0.37973 1.39065 3.89322 0.04616 2.0351 0.71262 0.34464 3.09236 2.55573 1.0667 0.41471 4.03712 05/17/2019 24 16 8 124 1 0 124 04/05/2018 17 11 6 100 1 0 100 2017-03-02 15 9 6 1 64 0 64 106 1 13 1 1677.00 0 1 1310 37TH ST VERO BEACH, FL 32960 (27.660261, -80.398779) 02/01/2020
1578 1578 5608 SW 9TH STREET DES MOINES, IA 50315 41.532902 -93.625701 0   165175 GENESIS SENIOR LIVING 5608 SW 9TH STREET DES MOINES IA 50315 5152853070 760 Polk For profit - Corporation 77 50.1 Medicare and Medicaid false DSM HEALTHCARE MANAGEMENT 11/01/1992 false   false false false Resident Yes 1   2   3   4   2   1 12 1 12     1.79874 0.91245 0.29341 1.20586 3.0046 0.03491 2.12967 0.75271 0.33486 3.21724 1.75538 0.91152 0.32979 2.99472 07/24/2019 7 7 0 28 1 0 28 04/05/2018 5 3 2 40 1 0 40 2017-03-02 3 1 2 1 12 0 12 29.333 0 3 0 0.00 0 0 5608 SW 9TH STREET DES MOINES, IA 50315 (41.532902, -93.625701) 02/01/2020
2019 2019 800 ESSEX STREET LAWRENCE, MA 01841 42.701912 -71.175629 0   225505 ROYAL WOOD MILL CENTER 800 ESSEX STREET LAWRENCE MA 1841 9786862994 40 Essex For profit - Corporation 94 81.1 Medicare and Medicaid false LOWN ACQUISITION LLC 07/01/1990 false   false false false Resident Yes 1   1   3   1   5   3   3       1.88558 0.8683 0.50385 1.37214 3.25772 0.01311 1.85522 0.58893 0.26723 2.71138 2.11234 1.10864 0.70965 3.85281 05/24/2019 13 13 0 80 3 56 136 05/03/2018 18 15 3 112 1 0 112 2017-03-02 8 8 0 1 32 0 32 110.667 0 1 2 26687.00 0 2 800 ESSEX STREET LAWRENCE, MA 01841 (42.701912, -71.175629) 02/01/2020
3761 3761 1026 ALBEE FARM RD VENICE, FL 34292 27.106053 -82.433489 0   105443 BAY BREEZE HEALTH AND REHABILITATION CENTER 1026 ALBEE FARM RD VENICE FL 34292 9414840425 570 Sarasota For profit - Limited Liability company 120 111.1 Medicare and Medicaid false 1026 ALBEE FARM ROAD OPERATIONS LLC 12/29/1983 false   false false false Resident Yes 1   1   3   4   3   3   2       2.6815 0.92452 0.32035 1.24487 3.92638 0.04835 1.98238 0.65611 0.30111 2.93961 2.81129 1.05955 0.40043 4.28307 01/10/2019 12 12 3 92 1 0 92 01/11/2018 10 7 3 108 1 0 108 2017-03-02 7 7 0 2 32 16 48 90 0 4 2 85780.00 0 2 1026 ALBEE FARM RD VENICE, FL 34292 (27.106053, -82.433489) 02/01/2020
4685 4685 402 WEST FIRST STREET ADRIAN, MO 64720 38.394542 -94.359107 0   265780 ADRIAN MANOR HEALTH & REHABILITATION CENTER 402 WEST FIRST STREET ADRIAN MO 64720 8162972107 60 Bates Government - City 60 42.4 Medicare and Medicaid false CITY OF ADRIAN - ADRIAN MANOR HEALTH AND REHAB 02/19/2004 false   false false false Resident Yes 1   1   2   1   4   2   2       2.50125 0.63622 0.33634 0.97256 3.47381 0.01197 2.00003 0.65524 0.28216 2.93742 2.59918 0.73012 0.44866 3.79221 01/17/2019 19 19 0 179 1 0 179 04/19/2018 5 5 0 36 1 0 36 2017-03-02 7 6 1 1 40 0 40 108.167 0 1 1 42110.00 1 2 402 WEST FIRST STREET ADRIAN, MO 64720 (38.394542, -94.359107) 02/01/2020
5095 5095 28550 FIVE MILE RD LIVONIA, MI 48154 42.399237 -83.326683 0   235057 HEARTLAND HEALTH CARE CENTER-LIVONIA 28550 FIVE MILE RD LIVONIA MI 48154 7344278270 810 Wayne Non profit - Corporation 142 107.4 Medicare and Medicaid false HEARTLAND-UNIVERSITY OF LIVONIA MI LLC 01/01/1967 false   false false false Resident Yes 1   2   3   2   3   1 12 1 12     1.89137 1.23142 0.38433 1.61575 3.50712 0.1112 2.19655 0.73641 0.32773 3.26068 1.78959 1.25739 0.4414 3.44902 03/20/2019 18 13 8 108 1 0 108 12/14/2017 8 7 1 103 1 0 103 2017-03-02 17 16 1 1 124 0 124 109 6 11 2 107153.00 0 2 28550 FIVE MILE RD LIVONIA, MI 48154 (42.399237, -83.326683) 02/01/2020
6491 6491 671 NORTH CHEROKEE ROAD SOCIAL CIRCLE, GA 30025 33.665593 -83.712577 0   115532 SOCIAL CIRCLE NSG & REHAB CTR 671 NORTH CHEROKEE ROAD SOCIAL CIRCLE GA 30025 7704642019 930 Walton For profit - Corporation 65 59.5 Medicare and Medicaid false SOCIAL CIRCLE CYPRESS LLC 10/01/1992 false   false false false Resident Yes 1   1   3   4   3   2   2       2.17322 1.16551 0.4119 1.57741 3.75064 0 2.04107 0.7833 0.37246 3.19683 2.2129 1.11885 0.41625 3.76218 01/26/2019 11 11 0 56 1 0 56 02/01/2018 8 8 0 32 1 0 32 2017-03-02 2 2 1 1 4 0 4 39.333 0 0 1 17375.00 0 1 671 NORTH CHEROKEE ROAD SOCIAL CIRCLE, GA 30025 (33.665593, -83.712577) 02/01/2020
6784 6784 308 CEDAR AVENUE JONESBURG, MO 63351 38.854896 -91.299097 0   265333 JONESBURG NURSING & REHAB 308 CEDAR AVENUE, PO BOX 218 JONESBURG MO 63351 6364885400 690 Montgomery For profit - Corporation 90 74 Medicare and Medicaid false N & R OF JONESBURG, INC. 10/04/1988 false   false false false Resident Yes 1   1   4   4     2 1   1       1.76331 0.73616 0.18859 0.92475 2.68806 0.06072 1.83842 0.63144 0.28052 2.75038 1.99343 0.87664 0.25304 3.13401 03/07/2019 23 19 4 246 1 0 246 04/06/2018 12 8 4 72 2 36 108 2017-03-02 4 4 0 1 24 0 24 163 0 9 1 11278.00 0 1 308 CEDAR AVENUE JONESBURG, MO 63351 (38.854896, -91.299097) 02/01/2020
7584 7584 730 KIMOLE LN ADRIAN, MI 49221 41.915356 -84.047674 0   235182 LYNWOOD MANOR HEALTHCARE CENTER 730 KIMOLE LN ADRIAN MI 49221 5172636771 450 Lenawee For profit - Corporation 84 71.4 Medicare and Medicaid false CRG LYNWOOD, LLC 10/01/1974 false   false false false Both Yes 1   1   1   1   3   2   2       2.00891 0.89771 0.42589 1.32361 3.33252 0.06497 1.86878 0.72072 0.35306 2.94256 2.23419 0.93659 0.45403 3.63162 05/08/2019 21 19 8 132 2 66 198 05/03/2018 19 13 6 124 2 62 186 2017-03-02 28 24 14 2 227 114 341 217.833 7 29 1 13811.00 0 1 730 KIMOLE LN ADRIAN, MI 49221 (41.915356, -84.047674) 02/01/2020
8976 8976 1515 N ELM ST LANCASTER, TX 75134 32.606835 -96.76434 0   675810 LANCASTER LTC PARTNERS INC 1515 N ELM ST LANCASTER TX 75134 9722276066 390 Dallas For profit - Limited Liability company 120 53.6 Medicare and Medicaid false LANCASTER LTC PARTNERS INC 10/12/1999 false   false false false Resident Yes 1   3   1   3   1   1 12 1 12     2.07403 1.1761 0.12324 1.29933 3.37337 0.04367 2.01414 0.77068 0.39005 3.17487 2.14014 1.14751 0.11892 3.40715 03/15/2019 6 6 6 40 1 0 40 03/08/2018 3 2 1 20 1 0 20 2017-03-02 8 3 5 1 132 0 132 48.667 6 4 3 22934.00 0 3 1515 N ELM ST LANCASTER, TX 75134 (32.606835, -96.76434) 02/01/2020
9039 9039 306 DEER PARK ROAD NEBO, NC 28761 35.651618 -81.885364 0   345233 DEER PARK HEALTH & REHABILITATION 306 DEER PARK ROAD NEBO NC 28761 8286523032 550 Mc Dowell Non profit - Corporation 140 111.3 Medicare and Medicaid false SENIOR CARE GROUP OF MCDOWELL, LLC 03/03/1983 false   true false false Resident Yes 1   1   2   2   3   3   3       2.0536 0.62481 0.53922 1.16403 3.21763 0.04113 2.11834 0.74321 0.39006 3.25161 2.01482 0.63215 0.52031 3.17315 02/01/2019 16 12 12 159 2 80 239 04/12/2018 5 4 1 20 1 0 20 2017-03-02 15 15 7 2 80 40 120 146.167 6 20 1 19885.00 1 2 306 DEER PARK ROAD NEBO, NC 28761 (35.651618, -81.885364) 02/01/2020
9870 9870 600 S HILLSIDE DR BEEVILLE, TX 78102 28.403714 -97.730466 0   455923 WOODRIDGE NURSING & REHABILITATION 600 S HILLSIDE DR BEEVILLE TX 78102 3613588880 113 Bee For profit - Partnership 120 78.7 Medicare and Medicaid false PINNACLE HEALTH FACILITIES XV LP 04/12/1991 false   false false false Resident Yes 1   2   4   5   3   1   1       1.98298 0.95001 0.18347 1.13348 3.11646 0.01009 2.01159 0.77198 0.4016 3.18517 2.04878 0.92535 0.17195 3.13749 03/22/2019 8 8 0 52 1 0 52 03/16/2018 16 10 6 128 1 0 128 2017-03-02 4 2 2 1 40 0 40 75.333 2 3 0 0.00 0 0 600 S HILLSIDE DR BEEVILLE, TX 78102 (28.403714, -97.730466) 02/01/2020
10016 10016 1150 COLONY DRIVE WESTERVILLE, OH 43081 40.097688 -82.8917 0   365421 COLUMBUS COLONY ELDERLY CARE 1150 COLONY DRIVE WESTERVILLE OH 43081 6148915055 250 Franklin Non profit - Corporation 150 136.6 Medicare and Medicaid false COLUMBUS COLONY FOR ELDERLY CARE, INC 08/03/1979 false   false false false Resident Yes 1   1   3   4   2   1 12 1 12     2.10324 0.72713 0.422 1.14913 3.25237 0.00881 1.9295 0.81525 0.41992 3.16467 2.26548 0.67066 0.37825 3.29552 04/25/2019 27 16 11 164 1 0 164 04/19/2018 17 6 11 112 1 0 112 2017-03-02 55 14 45 2 328 164 492 201.333 0 41 3 44364.00 2 5 1150 COLONY DRIVE WESTERVILLE, OH 43081 (40.097688, -82.8917) 02/01/2020
12626 12626 463 NORTH HUNTER HWY DRUMS, PA 18222 41.049811 -75.958094 0   395484 KADIMA REHABILITATION & NURSING AT LUZERNE 463 NORTH HUNTER HWY DRUMS PA 18222 5707884175 480 Luzerne For profit - Corporation 37 31.3 Medicare and Medicaid false LUZERNE REHABILITATION & NURSING, LLC 04/01/1980 false   false false false Resident Yes 1   1   2   3   2   2   3       1.98336 0.74931 0.79882 1.54813 3.53148 0.12236 2.33686 0.8637 0.45299 3.65355 1.76394 0.65235 0.66373 3.09952 03/22/2019 22 21 11 144 2 72 216 02/09/2018 10 10 0 44 1 0 44 2017-03-02 14 7 9 1 100 0 100 139.333 2 22 1 6893.00 0 1 463 NORTH HUNTER HWY DRUMS, PA 18222 (41.049811, -75.958094) 02/01/2020
12766 12766 1700 N WASHINGTON PILOT POINT, TX 76258 33.412437 -96.942788 0   455930 COUNTRYSIDE NURSING AND REHABILITATION LP 1700 N WASHINGTON PILOT POINT TX 76258 9406865556 410 Denton For profit - Limited Liability company 108 91 Medicare and Medicaid false COUNTRYSIDE NURSING AND REHABILITATION LP 07/18/1991 false SFF Candidate true false false Both Yes 1   1   3   3   4   1   1       1.66268 1.14009 0.28601 1.4261 3.08877 0.06249 2.03654 0.82167 0.442 3.30021 1.6968 1.04334 0.24355 3.00122 05/09/2019 11 1 11 824 1 0 824 03/09/2018 2 2 0 16 1 0 16 2017-03-02 2 2 0 1 16 0 16 420 2 1 2 46660.00 0 2 1700 N WASHINGTON PILOT POINT, TX 76258 (33.412437, -96.942788) 02/01/2020
13370 13370 1001 CENTRAL BLVD BROWNSVILLE, TX 78520 25.920414 -97.512024 0   675635 EBONY LAKE NURSING AND REHABILITATION CENTER 1001 CENTRAL BLVD BROWNSVILLE TX 78520 9565410917 240 Cameron For profit - Corporation 107 100.2 Medicare and Medicaid false REGENCY IHS OF EBONY LAKE LLC 09/11/1996 false   false false false Resident Yes 1   1   4   3   5   1   1       2.26261 0.99221 0.16797 1.16018 3.42279 0.04008 2.27123 0.85388 0.43975 3.56486 2.07045 0.87376 0.14376 3.07887 05/02/2019 14 10 4 100 1 0 100 03/22/2018 21 14 7 192 1 0 192 2017-03-02 21 9 12 1 128 0 128 135.333 3 4 0 0.00 0 0 1001 CENTRAL BLVD BROWNSVILLE, TX 78520 (25.920414, -97.512024) 02/01/2020
14006 14006 250 BELLEBROOK RD BRISTOL, TN 37620 36.556952 -82.188447 0   445190 CAMBRIDGE HOUSE, THE 250 BELLEBROOK RD BRISTOL TN 37620 4239684123 810 Sullivan For profit - Corporation 130 54.9 Medicare and Medicaid false Legal Business Name Not Available 10/02/1986 false SFF Candidate false false false Resident Yes 1   1   1   2   1   2   3       1.73147 0.48168 0.5211 1.00278 2.73425 0.0067 2.19514 0.65772 0.29778 3.15064 1.63934 0.55068 0.65864 2.78286 04/26/2019 7 7 0 245 1 0 245 05/16/2018 11 9 5 112 2 56 168 2017-03-02 7 7 6 1 329 0 329 233.333 3 1 4 282571.00 2 6 250 BELLEBROOK RD BRISTOL, TN 37620 (36.556952, -82.188447) 02/01/2020
14054 14054 601 Midwestern Pkwy E, Wichita Falls, TX 76302, USA 33.8753825 -98.4761011 1 ROOFTOP 675128 MIDWESTERN HEALTHCARE CENTER 601 MIDWESTERN PKWY WICHITA FALLS TX 76302 9407230885 960 Wichita For profit - Corporation 121 62 Medicare and Medicaid false DECATUR HOSPITAL AUTHORITY 02/08/1993 false   false false false Resident Yes 1   2   2   5   1   1   1       1.87259 1.0715 0.31906 1.39056 3.26315 0.01548 1.99218 0.77277 0.38579 3.15074 1.95358 1.04262 0.31127 3.32107 02/28/2019 10 7 8 80 1 0 80 03/08/2018 7 3 4 71 1 0 71 2017-03-02 5 5 0 1 60 0 60 73.667 6 5 1 13655.00 0 1   02/01/2020
14790 14790 2741 BOULEVARD AVENUE SCRANTON, PA 18509 41.442118 -75.638409 0   395067 GREEN RIDGE CARE CENTER 2741 BOULEVARD AVENUE SCRANTON PA 18509 5703446121 420 Lackawanna For profit - Corporation 95 88.6 Medicare and Medicaid false GREEN RIDGE HEALTHCARE GROUP, LLC 02/21/1972 true   false false false Resident Yes 1   1   3   5   2   2   2       1.9796 0.77997 0.59771 1.37768 3.35728 0.06062 2.17385 0.8488 0.45968 3.48233 1.89262 0.69097 0.4894 3.09151 03/15/2019 20 20 3 112 1 0 112 02/02/2018 9 9 1 52 2 26 78 2017-03-02 22 16 8 2 128 64 192 114 2 10 0 0.00 0 0 2741 BOULEVARD AVENUE SCRANTON, PA 18509 (41.442118, -75.638409) 02/01/2020
15052 15052 3808 S CENTRAL DALLAS, TX 75215 32.75653 -96.766924 0   675440 SOUTH DALLAS NURSING & REHABILITATION 3808 S CENTRAL EXPWY DALLAS TX 75215 2144282851 390 Dallas For profit - Limited Liability company 91 69.7 Medicare and Medicaid false MODERN SENIOR LIVING LLC 01/24/1995 false   false false false Resident Yes 1   2   2   2   1   1 12 1 12     1.37472 0.79654 0.11539 0.91193 2.28665 0.00967 1.89452 0.70732 0.34263 2.94447 1.5081 0.84679 0.12676 2.49027 02/22/2019 7 5 6 56 1 0 56 03/02/2018 11 8 5 139 1 0 139 2017-03-02 10 10 0 1 88 0 88 89 7 4 1 8128.00 0 1 3808 S CENTRAL DALLAS, TX 75215 (32.75653, -96.766924) 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
);