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
4 rows
where Overall Rating = 4 and Rating Cycle 1 Number of Standard Health Deficiencies = 19
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: ownership, prvdr_type, Continuing Care Retirement Community, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Total Number of 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 Number of Complaint Health Deficiencies, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Facility Reported Incidents, 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
|
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
|
Health Inspection Rating
|
QM Rating
|
Long-Stay QM Rating
|
Short-Stay QM Rating
|
Staffing Rating
|
RN Staffing Rating
|
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
|
862 |
862 |
725 MOUNT WILSON LANE BALTIMORE, MD 21208 |
39.382079 |
-76.764185 |
0 |
|
215229 |
AUTUMN RIDGE AT NORTH OAKS |
725 MOUNT WILSON LANE |
BALTIMORE |
MD |
21208 |
4106020302 |
20 |
Baltimore |
For profit - Corporation |
37 |
21.9 |
Medicare |
false |
NORTH OAKS PARTNERSHIP |
05/16/1991 |
|
false |
false |
false |
Both |
Yes |
4 |
3 |
3 |
2 |
4 |
5 |
5 |
2.02874 |
1.62397 |
1.0022 |
2.62617 |
4.65491 |
0.05686 |
1.91582 |
0.63896 |
0.29781 |
2.85259 |
2.20084 |
1.91114 |
1.26661 |
5.2327 |
10/15/2019 |
19 |
19 |
0 |
84 |
1 |
0 |
84 |
07/10/2018 |
14 |
14 |
2 |
64 |
1 |
0 |
64 |
2017-03-31 |
1 |
1 |
0 |
1 |
4 |
0 |
4 |
64 |
3 |
0 |
0 |
0.00 |
0 |
0 |
725 MOUNT WILSON LANE BALTIMORE, MD 21208 (39.382079, -76.764185) |
02/01/2020 |
5339 |
5339 |
21414 S VERMONT AVENUE TORRANCE, CA 90502 |
33.833864 |
-118.290281 |
0 |
|
56308 |
HERITAGE REHABILITATION CENTER |
21414 S. VERMONT AVENUE |
TORRANCE |
CA |
90502 |
3103208714 |
200 |
Los Angeles |
For profit - Corporation |
161 |
127.6 |
Medicare and Medicaid |
false |
HERITAGE CARE, LLC |
07/01/1976 |
|
false |
false |
false |
Resident |
Yes |
4 |
2 |
5 |
5 |
4 |
4 |
3 |
2.95827 |
1.45378 |
0.59057 |
2.04435 |
5.00262 |
0.08372 |
2.1234 |
0.75374 |
0.33336 |
3.2105 |
2.89549 |
1.45032 |
0.66678 |
4.99664 |
02/27/2019 |
19 |
19 |
0 |
116 |
1 |
0 |
116 |
02/28/2018 |
17 |
10 |
7 |
92 |
1 |
0 |
92 |
2017-01-23 |
16 |
12 |
4 |
1 |
104 |
0 |
104 |
106 |
1 |
14 |
0 |
0.00 |
0 |
0 |
21414 S VERMONT AVENUE TORRANCE, CA 90502 (33.833864, -118.290281) |
02/01/2020 |
10999 |
10999 |
2075 NW HIGHLAND AVENUE GRANTS PASS, OR 97526 |
42.463313 |
-123.332991 |
0 |
|
385148 |
ROYALE GARDENS HEALTH AND REHABILITATION CENTER |
2075 NW HIGHLAND AVENUE |
GRANTS PASS |
OR |
97526 |
5414768891 |
160 |
Josephine |
For profit - Partnership |
145 |
92.1 |
Medicare and Medicaid |
false |
AVALON HEALTH CARE-ROYALE GARDENS LLC |
04/15/1981 |
|
false |
false |
false |
Resident |
Yes |
4 |
2 |
5 |
5 |
4 |
4 |
4 |
2.99593 |
0.77053 |
0.65826 |
1.42879 |
4.42472 |
0.10423 |
2.09637 |
0.73857 |
0.33174 |
3.16668 |
2.97015 |
0.78448 |
0.74684 |
4.48058 |
06/22/2018 |
24 |
19 |
9 |
144 |
2 |
72 |
216 |
05/04/2017 |
8 |
6 |
2 |
40 |
1 |
0 |
40 |
2016-03-25 |
9 |
9 |
0 |
1 |
68 |
0 |
68 |
132.667 |
0 |
4 |
0 |
0.00 |
0 |
0 |
2075 NW HIGHLAND AVENUE GRANTS PASS, OR 97526 (42.463313, -123.332991) |
02/01/2020 |
12456 |
12456 |
12475 LEE JACKSON MEMORIAL HIGHWAY FAIRFAX, VA 22033 |
38.873129 |
-77.377695 |
0 |
|
495217 |
MANORCARE HEALTH SERVICES-FAIR OAKS |
12475 LEE JACKSON MEMORIAL HIGHWAY |
FAIRFAX |
VA |
22033 |
7033527172 |
290 |
Fairfax |
For profit - Corporation |
155 |
131.5 |
Medicare and Medicaid |
false |
MANOR CARE-FAIR OAKS OF FAIRFAX VA LLC |
09/06/1990 |
|
false |
false |
false |
Resident |
Yes |
4 |
2 |
5 |
5 |
5 |
4 |
5 |
1.55648 |
0.62828 |
1.12846 |
1.75674 |
3.31322 |
0.12735 |
2.14248 |
0.70494 |
0.32095 |
3.16838 |
1.50988 |
0.67017 |
1.32336 |
3.35326 |
05/17/2018 |
19 |
19 |
1 |
100 |
1 |
0 |
100 |
03/23/2017 |
11 |
11 |
0 |
60 |
1 |
0 |
60 |
2016-04-13 |
9 |
9 |
0 |
1 |
56 |
0 |
56 |
79.333 |
0 |
2 |
0 |
0.00 |
0 |
0 |
12475 LEE JACKSON MEMORIAL HIGHWAY FAIRFAX, VA 22033 (38.873129, -77.377695) |
02/01/2020 |
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
);