nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
11 rows where Long-Stay QM Rating Footnote = 18 and Total Number of Penalties = 5
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Date First Approved to Provide Medicare and Medicaid services, Abuse Icon, With a Resident and Family Council, 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 Number of Health Revisits, Rating Cycle 1 Health Revisit 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 Revisit Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Number of Payment Denials, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2478 | 2478 | 12942 WORNALL ROAD KANSAS CITY, MO 64145 | 38.891263 | -94.595164 | 0 | 265830 | KANSAS CITY CENTER FOR REHABILITATION AND HEALTHCA | 12942 WORNALL ROAD | KANSAS CITY | MO | 64145 | 8164238500 | 470 | Jackson | For profit - Limited Liability company | 180 | 112.4 | Medicare and Medicaid | false | BROOK OPERATIONS LLC | 06/29/2009 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.25224 | 1.2764 | 0.41639 | 1.6928 | 3.94504 | 0.04189 | 1.73081 | 0.63292 | 0.29802 | 2.66175 | 2.70446 | 1.51644 | 0.52589 | 4.75266 | 04/19/2019 | 43 | 37 | 17 | 240 | 3 | 168 | 408 | 04/20/2018 | 41 | 34 | 15 | 332 | 2 | 166 | 498 | 2017-02-17 | 26 | 25 | 5 | 1 | 140 | 0 | 140 | 393.333 | 4 | 30 | 3 | 162309.00 | 2 | 5 | 12942 WORNALL ROAD KANSAS CITY, MO 64145 (38.891263, -94.595164) | 02/01/2020 | ||||||||||
5221 | 5221 | 930 MILL HILL TERRACE SOUTHPORT, CT 06890 | 41.14438 | -73.286615 | 0 | 75200 | REGALCARE AT SOUTHPORT | 930 MILL HILL TERRACE | SOUTHPORT | CT | 6890 | 2032597894 | 0 | Fairfield | For profit - Partnership | 120 | 108.2 | Medicare and Medicaid | false | FAIRVIEW HEALTH OF SOUTHPORT LLC | 06/01/1977 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.04457 | 0.9491 | 0.43656 | 1.38566 | 3.43023 | 0.04559 | 1.79219 | 0.67576 | 0.32482 | 2.79277 | 2.37101 | 1.0561 | 0.50587 | 3.9386 | 06/12/2019 | 8 | 5 | 3 | 32 | 1 | 0 | 32 | 11/30/2018 | 17 | 16 | 9 | 162 | 1 | 0 | 162 | 2018-05-24 | 52 | 19 | 50 | 3 | 625 | 438 | 1063 | 247.167 | 8 | 9 | 4 | 27108.00 | 1 | 5 | 930 MILL HILL TERRACE SOUTHPORT, CT 06890 (41.14438, -73.286615) | 02/01/2020 | ||||||||||
6606 | 6606 | 9350 GREEN PARK ROAD SAINT LOUIS, MO 63123 | 38.524626 | -90.333738 | 0 | 265703 | GREEN PARK SENIOR LIVING COMMUNITY | 9350 GREEN PARK ROAD | SAINT LOUIS | MO | 63123 | 3148450900 | 940 | St. Louis | For profit - Corporation | 188 | 158.8 | Medicare and Medicaid | false | GREEN PARK LEASING CO LLC | 01/21/2000 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.8986 | 0.93923 | 0.42898 | 1.36822 | 3.26681 | 0.02783 | 1.76927 | 0.64017 | 0.2982 | 2.70764 | 2.23025 | 1.10322 | 0.54146 | 3.86889 | 10/11/2019 | 17 | 11 | 10 | 163 | 1 | 0 | 163 | 05/22/2019 | 33 | 30 | 9 | 176 | 1 | 0 | 176 | 2018-09-10 | 26 | 23 | 9 | 1 | 172 | 0 | 172 | 168.833 | 4 | 34 | 2 | 58468.00 | 3 | 5 | 9350 GREEN PARK ROAD SAINT LOUIS, MO 63123 (38.524626, -90.333738) | 02/01/2020 | ||||||||||
6648 | 6648 | 850 9TH STREET ALABASTER, AL 35007 | 33.253789 | -86.826548 | 0 | 15144 | AHAVA HEALTHCARE OF ALABASTER | 850 9TH STREET, NORTHWEST | ALABASTER | AL | 35007 | 2056633859 | 580 | Shelby | For profit - Corporation | 198 | 154.3 | Medicare and Medicaid | false | ALABASTER OPERATING GROUP LLC | 06/01/1976 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.66724 | 0.80895 | 0.3797 | 1.18865 | 2.85589 | 0.04646 | 1.91309 | 0.66621 | 0.30806 | 2.88735 | 1.81125 | 0.91306 | 0.46392 | 3.17172 | 07/11/2019 | 5 | 5 | 5 | 20 | 1 | 0 | 20 | 01/16/2019 | 17 | 9 | 8 | 136 | 2 | 68 | 204 | 2017-10-19 | 15 | 8 | 9 | 2 | 448 | 224 | 672 | 190 | 1 | 5 | 4 | 110470.00 | 1 | 5 | 850 9TH STREET ALABASTER, AL 35007 (33.253789, -86.826548) | 02/01/2020 | ||||||||||
6700 | 6700 | 5301 W FIRST AVE LAKEWOOD, CO 80226 | 39.718574 | -105.054985 | 0 | 65248 | BETHANY NURSING & REHAB CENTER | 5301 W FIRST AVE | LAKEWOOD | CO | 80226 | 3032388333 | 290 | Jefferson | For profit - Corporation | 170 | 137.5 | Medicare and Medicaid | false | BETHANY NURSING & REHAB CENTER LLC | 03/01/1989 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.14861 | 0.54414 | 0.32874 | 0.87289 | 2.0215 | 0.02956 | 1.94198 | 0.70019 | 0.32477 | 2.96695 | 1.22926 | 0.58436 | 0.38098 | 2.18482 | 12/10/2019 | 17 | 11 | 6 | 80 | 0 | 0 | 80 | 05/16/2019 | 25 | 10 | 15 | 265 | 1 | 0 | 265 | 2018-11-29 | 35 | 10 | 25 | 1 | 345 | 0 | 345 | 185.833 | 3 | 24 | 4 | 255169.00 | 1 | 5 | 5301 W FIRST AVE LAKEWOOD, CO 80226 (39.718574, -105.054985) | 02/01/2020 | ||||||||||
8273 | 8273 | 1509 NORTH CALHOUN STREET BLOOMINGTON, IL 61701 | 40.493115 | -89.005883 | 0 | 145371 | APERION CARE BLOOMINGTON | 1509 NORTH CALHOUN STREET | BLOOMINGTON | IL | 61701 | 3098276046 | 650 | Mc Lean | For profit - Corporation | 115 | 68.9 | Medicare and Medicaid | false | APERION CARE BLOOMINGTON LLC | 03/29/1978 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.98157 | 0.54591 | 0.33186 | 0.87777 | 2.85934 | 0.00676 | 2.13815 | 0.86696 | 0.52719 | 3.53229 | 1.92614 | 0.47349 | 0.23693 | 2.59575 | 09/25/2019 | 27 | 10 | 17 | 235 | 1 | 0 | 235 | 05/20/2019 | 21 | 16 | 5 | 92 | 1 | 0 | 92 | 2018-10-01 | 100 | 16 | 84 | 1 | 814 | 0 | 814 | 283.833 | 0 | 68 | 3 | 183544.00 | 2 | 5 | 1509 NORTH CALHOUN STREET BLOOMINGTON, IL 61701 (40.493115, -89.005883) | 02/01/2020 | ||||||||||
8682 | 8682 | 12260 FOOTHILL BLVD SYLMAR, CA 91342 | 34.282013 | -118.403063 | 0 | 555814 | SAN FERNANDO POST ACUTE HOSPITAL | 12260 FOOTHILL BLVD | SYLMAR | CA | 91342 | 8188999545 | 200 | Los Angeles | For profit - Corporation | 204 | 150 | Medicare and Medicaid | false | Legal Business Name Not Available | 11/24/2004 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.55203 | 1.93247 | 0.47791 | 2.41038 | 4.96241 | 0.02789 | 2.14524 | 0.79741 | 0.74916 | 3.6918 | 2.47244 | 1.82227 | 0.24011 | 4.3103 | 07/01/2019 | 25 | 15 | 13 | 140 | 1 | 0 | 140 | 01/14/2019 | 22 | 16 | 8 | 128 | 1 | 0 | 128 | 2018-07-16 | 19 | 11 | 8 | 1 | 221 | 0 | 221 | 149.5 | 12 | 17 | 4 | 256613.00 | 1 | 5 | 12260 FOOTHILL BLVD SYLMAR, CA 91342 (34.282013, -118.403063) | 02/01/2020 | ||||||||||
8904 | 8904 | 12921 MISTY WILLOW DR HOUSTON, TX 77070 | 29.960344 | -95.556132 | 0 | 676251 | MISTY WILLOW HEALTHCARE AND REHABILITATION CENTER | 12921 MISTY WILLOW DR | HOUSTON | TX | 77070 | 2814697881 | 610 | Harris | For profit - Corporation | 124 | 58.7 | Medicare and Medicaid | false | LIBERTY COUNTY HOSPITAL DISTRICT NO 1 | 04/21/2010 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.03912 | 1.36993 | 0.35134 | 1.72128 | 3.7604 | 0.12721 | 2.09128 | 0.87391 | 0.47783 | 3.44301 | 2.02651 | 1.17874 | 0.27675 | 3.50226 | 07/18/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01/12/2019 | 10 | 4 | 7 | 108 | 1 | 0 | 108 | 2018-07-13 | 20 | 6 | 14 | 1 | 1439 | 0 | 1439 | 275.833 | 4 | 24 | 3 | 94714.00 | 2 | 5 | 12921 MISTY WILLOW DR HOUSTON, TX 77070 (29.960344, -95.556132) | 02/01/2020 | ||||||||||
9327 | 9327 | 3195 OLD MURPHY ROAD FRANKLIN, NC 28734 | 35.167118 | -83.433528 | 0 | 345263 | MACON VALLEY NURSING AND REHABILITATION CENTER | 3195 OLD MURPHY ROAD | FRANKLIN | NC | 28734 | 8285247806 | 560 | Macon | For profit - Corporation | 200 | 78.2 | Medicare and Medicaid | false | GRANITE FALLS LTC, LLC | 07/14/1987 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.38615 | 0.70726 | 1.20815 | 1.91541 | 4.30155 | 0.04949 | 2.14012 | 0.80457 | 0.40617 | 3.35086 | 2.31726 | 0.661 | 1.11954 | 4.11644 | 08/29/2019 | 3 | 0 | 3 | 44 | 0 | 0 | 44 | 02/22/2019 | 36 | 5 | 31 | 656 | 1 | 0 | 656 | 2018-04-13 | 13 | 8 | 13 | 2 | 68 | 34 | 102 | 257.667 | 1 | 39 | 4 | 433149.00 | 1 | 5 | 3195 OLD MURPHY ROAD FRANKLIN, NC 28734 (35.167118, -83.433528) | 02/01/2020 | ||||||||||
13193 | 13193 | 4403 FOREST HILL AVENUE RICHMOND, VA 23225 | 37.519708 | -77.481539 | 0 | 495327 | ENVOY OF WESTOVER HILLS | 4403 FOREST HILL AVENUE | RICHMOND | VA | 23225 | 8042310231 | 791 | Richmond City | For profit - Corporation | 174 | 146.7 | Medicare and Medicaid | false | ENVOY OF RICHMOND, LLC | 02/01/1998 | false | SFF | true | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.99688 | 1.06524 | 0.50247 | 1.56771 | 3.56459 | 0.06543 | 1.95113 | 0.72582 | 0.35943 | 3.03638 | 2.12707 | 1.10358 | 0.52617 | 3.7645 | 07/25/2019 | 22 | 16 | 8 | 168 | 1 | 0 | 168 | 01/31/2019 | 35 | 15 | 20 | 200 | 2 | 100 | 300 | 2018-07-23 | 52 | 30 | 39 | 2 | 584 | 292 | 876 | 330 | 0 | 38 | 4 | 668716.00 | 1 | 5 | 4403 FOREST HILL AVENUE RICHMOND, VA 23225 (37.519708, -77.481539) | 02/01/2020 | ||||||||||
13608 | 13608 | 821 I-35BL, New Braunfels, TX 78130, USA | 29.6911115 | -98.1237433 | 1 | ROOFTOP | 455020 | COLONIAL MANOR CARE CENTER | 821 US HWY 81 W | NEW BRAUNFELS | TX | 78130 | 8306257526 | 320 | Comal | For profit - Corporation | 154 | 126.9 | Medicare and Medicaid | false | COLONIAL NEW BRAUNFELS CARE CENTER LLC | 06/01/1976 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.13263 | 1.26971 | 0.22817 | 1.49788 | 3.63051 | 0 | 1.9021 | 0.79213 | 0.4156 | 3.10984 | 2.33022 | 1.20529 | 0.20664 | 3.74354 | 02/26/2019 | 39 | 31 | 11 | 830 | 1 | 0 | 830 | 02/02/2018 | 26 | 21 | 5 | 212 | 1 | 0 | 212 | 2017-01-12 | 19 | 5 | 14 | 1 | 793 | 0 | 793 | 617.833 | 9 | 26 | 4 | 220368.00 | 1 | 5 | 02/01/2020 |
Advanced export
JSON shape: default, array, newline-delimited
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 );