nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where RN Staffing Rating Footnote = 2 and geocode_flag = 1
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_accuracy, prvdr_state, ownership, prvdr_type, Legal Business Name, Abuse Icon, Most Recent Health Inspection More Than 2 Years Ago, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating 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 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 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 Total Health Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Total Number of Penalties, Rating Cycle 3 Standard Health Survey Date (date)
Link | rowid ▼ | address | lat | lng | geocode_flag | geocode_accuracy | prvdr_nmbr | prvdr_nm | prvdr_add | prvdr_city | prvdr_state | prvdr_zip | prvdr_phn | prvdr_cnty | prvdr_cnty_name | ownership | nmbr_beds | avg_residents | prvdr_type | Provider Resides in Hospital | Legal Business Name | Date First Approved to Provide Medicare and Medicaid services | Continuing Care Retirement Community | Special Focus Status | Abuse Icon | Most Recent Health Inspection More Than 2 Years Ago | Provider Changed Ownership in Last 12 Months | With a Resident and Family Council | Automatic Sprinkler Systems in All Required Areas | Overall Rating | Overall Rating Footnote | Health Inspection Rating | Health Inspection Rating Footnote | QM Rating | QM Rating Footnote | Long-Stay QM Rating | Long-Stay QM Rating Footnote | Short-Stay QM Rating | Short-Stay QM Rating Footnote | Staffing Rating | Staffing Rating Footnote | RN Staffing Rating | RN Staffing Rating Footnote | Reported Staffing Footnote | Physical Therapist Staffing Footnote | Reported Nurse Aide Staffing Hours per Resident per Day | Reported LPN Staffing Hours per Resident per Day | Reported RN Staffing Hours per Resident per Day | Reported Licensed Staffing Hours per Resident per Day | Reported Total Nurse Staffing Hours per Resident per Day | Reported Physical Therapist Staffing Hours per Resident Per Day | Case-Mix Nurse Aide Staffing Hours per Resident per Day | Case-Mix LPN Staffing Hours per Resident per Day | Case-Mix RN Staffing Hours per Resident per Day | Case-Mix Total Nurse Staffing Hours per Resident per Day | Adjusted Nurse Aide Staffing Hours per Resident per Day | Adjusted LPN Staffing Hours per Resident per Day | Adjusted RN Staffing Hours per Resident per Day | Adjusted Total Nurse Staffing Hours per Resident per Day | Rating Cycle 1 Standard Survey Health Date | Rating Cycle 1 Total Number of Health Deficiencies | Rating Cycle 1 Number of Standard Health Deficiencies | Rating Cycle 1 Number of Complaint Health Deficiencies | Rating Cycle 1 Health Deficiency Score | Rating Cycle 1 Number of Health Revisits | Rating Cycle 1 Health Revisit Score | Rating Cycle 1 Total Health Score | Rating Cycle 2 Standard Health Survey Date | Rating Cycle 2 Total Number of Health Deficiencies | Rating Cycle 2 Number of Standard Health Deficiencies | Rating Cycle 2 Number of Complaint Health Deficiencies | Rating Cycle 2 Health Deficiency Score | Rating Cycle 2 Number of Health Revisits | Rating Cycle 2 Health Revisit Score | Rating Cycle 2 Total Health Score | Rating Cycle 3 Standard Health Survey Date | Rating Cycle 3 Total Number of Health Deficiencies | Rating Cycle 3 Number of Standard Health Deficiencies | Rating Cycle 3 Number of Complaint Health Deficiencies | Rating Cycle 3 Number of Health Revisits | Rating Cycle 3 Health Deficiency Score | Rating Cycle 3 Health Revisit Score | Rating Cycle 3 Total Health Score | Total Weighted Health Survey Score | Number of Facility Reported Incidents | Number of Substantiated Complaints | Number of Fines | Total Amount of Fines in Dollars | Number of Payment Denials | Total Number of Penalties | Location | Processing Date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | 3115 Bowman Rd, Little Rock, AR 72211, USA | 34.7245501 | -92.4070758 | 1 | RANGE_INTERPOLATED | 45288 | ALLAY HEALTH AND REHAB | 3115 BOWMAN ROAD | LITTLE ROCK | AR | 72211 | 5012284848 | 590 | Pulaski | For profit - Limited Liability company | 70 | 14.4 | Medicare and Medicaid | false | CLR HEALTHCARE OPERATIONS LLC | 06/30/1995 | false | false | false | false | None | Yes | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 6 | 6 | 09/06/2019 | 8 | 8 | 0 | 72 | 1 | 0 | 72 | 09/19/2018 | 8 | 8 | 0 | 52 | 1 | 0 | 52 | 2017-07-21 | 6 | 4 | 2 | 1 | 298 | 0 | 298 | 103 | 0 | 2 | 2 | 28096.00 | 0 | 2 | 02/01/2020 | |||||||||||||||||||||||
2105 | 2105 | 1027 E Hwy 98, Panama City, FL 32401, USA | 30.15668359999999 | -85.64594819999999 | 1 | ROOFTOP | 105775 | GLENCOVE HEALTH AND REHABILITATION CENTER | 1027 E HWY 98 | PANAMA CITY | FL | 32401 | 8508721438 | 20 | Bay | For profit - Corporation | 115 | Medicare and Medicaid | false | NF GLEN COVE LLC | 09/16/1992 | false | false | true | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 2 | 2 | 6 | 6 | 01/10/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 03/10/2017 | 3 | 2 | 1 | 8 | 1 | 0 | 8 | 2015-12-04 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 12 | 0 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | ||||||||||||||||||||||||
2370 | 2370 | 6700 US-165, Monroe, LA 71203, USA | 32.5898929 | -92.066053 | 1 | ROOFTOP | 195628 | NORTHEAST LA WAR VETERANS HOME | 6700 HIGHWAY 165 NORTH | MONROE | LA | 71211 | 3183624206 | 360 | Ouachita | Government - State | 10 | 2.6 | Medicare | false | NORTHEAST LOUISANA VETERANS HOME | 12/04/2008 | false | false | false | false | Resident | Yes | 3 | 4 | 1 | 2 | 1 | 2 | 2 | 6 | 6 | 08/05/2019 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 07/17/2018 | 4 | 4 | 0 | 24 | 1 | 0 | 24 | 2017-07-06 | 2 | 1 | 1 | 1 | 8 | 0 | 8 | 9.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
5569 | 5569 | 275 S Lasalle St, Aurora, IL 60505, USA | 41.751409 | -88.3177809 | 1 | ROOFTOP | 14A539 | JENNINGS TERRACE | 275 SOUTH LASALLE | AURORA | IL | 60505 | 6308976947 | 530 | Kane | Non profit - Other | 60 | 14.5 | Medicaid | false | Legal Business Name Not Available | 09/18/2008 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 6 | 6 | 12/12/2019 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 11/29/2018 | 5 | 4 | 1 | 32 | 1 | 0 | 32 | 2018-01-16 | 12 | 9 | 3 | 1 | 56 | 0 | 56 | 20 | 1 | 2 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
7737 | 7737 | 6800 Joliet Rd, Indian Head Park, IL 60525, USA | 41.7692481 | -87.8901817 | 1 | ROOFTOP | 145784 | BRIAR PLACE NURSING | 6800 WEST JOLIET | INDIAN HEAD PARK | IL | 60525 | 7082468500 | 141 | Cook | For profit - Corporation | 232 | 205.4 | Medicare and Medicaid | false | BRIAR PLACE NURSING LLC | 02/01/1994 | false | true | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 2 | 2 | 6 | 6 | 08/21/2019 | 20 | 11 | 9 | 136 | 1 | 0 | 136 | 10/26/2018 | 16 | 5 | 11 | 112 | 1 | 0 | 112 | 2017-09-01 | 21 | 10 | 12 | 1 | 128 | 0 | 128 | 126.667 | 1 | 30 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
10380 | 10380 | 15230 15th Ave NE, Shoreline, WA 98155, USA | 47.740384 | -122.3105044 | 1 | ROOFTOP | 50A260 | FIRCREST SCHOOL, PAT N | 15230-15TH NORTHEAST | SEATTLE | WA | 98155 | 2063613511 | 160 | King | Government - State | 92 | 109.2 | Medicaid | false | Legal Business Name Not Available | 05/13/1994 | false | false | false | false | None | Yes | 5 | 4 | 5 | 5 | 2 | 2 | 2 | 6 | 6 | 08/15/2019 | 8 | 4 | 5 | 52 | 1 | 0 | 52 | 05/17/2018 | 8 | 1 | 7 | 52 | 1 | 0 | 52 | 2017-04-14 | 8 | 3 | 7 | 1 | 80 | 0 | 80 | 56.667 | 5 | 9 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
13070 | 13070 | WA-902 & Salnave Rd, Medical Lake, WA 99022, USA | 47.55102369999999 | -117.7044559 | 1 | GEOMETRIC_CENTER | 50A263 | LAKELAND VILLAGE NURSING FACILITY | STATE HIGHWAY 902 & SALNAVE ROAD | MEDICAL LAKE | WA | 99022 | 5092991800 | 310 | Spokane | Government - State | 93 | 87.7 | Medicaid | false | Legal Business Name Not Available | 05/23/1994 | false | false | false | false | Family | Yes | 4 | 4 | 4 | 4 | 2 | 2 | 2 | 6 | 6 | 03/19/2019 | 9 | 4 | 5 | 102 | 1 | 0 | 102 | 02/23/2018 | 13 | 12 | 1 | 56 | 1 | 0 | 56 | 2017-01-18 | 7 | 3 | 4 | 1 | 28 | 0 | 28 | 74.333 | 8 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||||
13865 | 13865 | 932 Old US Hwy 70, Black Mountain, NC 28711, USA | 35.612557 | -82.356127 | 1 | ROOFTOP | 34A001 | BLACK MOUNTAIN NEURO-MEDICAL TREATMENT CENTER | 932 OLD US HIGHWAY 70 | BLACK MOUNTAIN | NC | 28711 | 8282596700 | 100 | Buncombe | Government - State | 165 | 156.3 | Medicaid | false | Legal Business Name Not Available | 10/04/1991 | false | false | false | true | Resident | Yes | 5 | 4 | 5 | 5 | 2 | 2 | 2 | 6 | 6 | 05/09/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 05/03/2018 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-05-25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0.00 | 0 | 0 | 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 );