COVID_HospitalBeds_CountyDemographics_NursingHomes: nh_gen_info_geocoded_final: 1,277 rows where where Total Number of Penalties = 2 sorted by Case-Mix Total Nurse Staffing Hours per Resident per Day

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

1,277 rows where Total Number of Penalties = 2 sorted by Case-Mix Total Nurse Staffing Hours per Resident per Day

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
33	33	304 W 7TH ST WELLSVILLE, KS 66092	38.716794	-95.084996	0		175250	WELLSVILLE MANOR	304 W 7TH ST	WELLSVILLE	KS	66092	7858834101	290	Franklin	For profit - Individual	60	54.4	Medicare and Medicaid	false	MYSTERE LIVING & HEALTHCARE, INC.	04/15/1993	true		false	false	false	Resident	Yes	4		4		5		5		4		1	12	1	12	6	6															08/22/2019	5	5	0	44	1	0	44	10/31/2018	0	0	0	0	0	0	0	2017-06-20	4	2	3	1	48	0	48	30	2	0	2	17544.00	0	2	304 W 7TH ST WELLSVILLE, KS 66092 (38.716794, -95.084996)	02/01/2020
34	34	736 HEYLMAN STREET FORT SCOTT, KS 66701	37.832805	-94.71812	0		175384	FORT SCOTT MANOR	736 HEYLMAN STREET	FORT SCOTT	KS	66701	6202233120	50	Bourbon	For profit - Corporation	45		Medicare and Medicaid	false	Legal Business Name Not Available	08/01/1996	false	SFF Candidate	false	true	false	Resident	Yes	1		1			2		2		2	1	12	1	12	6	6															10/30/2017	15	15	14	116	2	58	174	03/18/2016	26	16	10	349	2	175	524	2014-12-05	17	16	1	1	128	0	128	283	4	5	0	0.00	2	2	736 HEYLMAN STREET FORT SCOTT, KS 66701 (37.832805, -94.71812)	02/01/2020
51	51	2555 Norterre Cir, Liberty, MO 64068, USA	39.2772588	-94.4212769	1	ROOFTOP	265867	NORTERRE	2555 NORTERRE CIRCLE	LIBERTY	MO	64068	8164794793	230	Clay	For profit - Corporation	60	34	Medicare	false	LHLC OPERATIONS LLC	02/28/2018	true		false	false	false	Resident	Yes	2		1		5		5		4		1	12	1	12	6	6															08/23/2019	9	7	2	44	1	0	44	12/13/2018	22	22	0	224	1	0	224	2018-02-28	0	0	0	0	0	0	0	96.667	0	3	1	33280.00	1	2		02/01/2020
54	54	Heritage Rd, Crow Agency, MT 59022, USA	45.5810378	-107.4506532	1	GEOMETRIC_CENTER	275153	AWE KUALAWAACHE CARE CENTER	10131 S HERITAGE RD	CROW AGENCY	MT	59022	4066389111	10	Big Horn	Non profit - Other	40	26.5	Medicare and Medicaid	false	Legal Business Name Not Available	06/09/1998	false	SFF Candidate	false	false	false	Resident	Yes	2		1		5		5			2	1	12	1	12	6	6															02/05/2019	7	7	0	56	1	0	56	09/06/2018	12	9	3	414	1	0	414	2017-05-04	22	22	0	2	244	122	366	227	0	2	0	0.00	2	2		02/01/2020
112	112	7146 BAKER BLVD RICHLAND HILLS, TX 76118	32.809052	-97.226391	0		675840	LEXINGTON PLACE NURSING & REHABILITATION	7146 BAKER BLVD	RICHLAND HILLS	TX	76118	8175891734	910	Tarrant	For profit - Partnership	114	80.8	Medicare and Medicaid	false	PINNACLE HEALTH FACILITIES XV LP	08/01/2000	false		false	false	false	Resident	Yes	4		4		5		5		4		1	12	1	12	6	6															03/28/2019	5	5	5	36	1	0	36	04/12/2018	2	2	0	28	1	0	28	2017-05-11	0	0	0	0	0	0	0	27.333	0	0	1	9428.00	1	2	7146 BAKER BLVD RICHLAND HILLS, TX 76118 (32.809052, -97.226391)	02/01/2020
163	163	4005 RIPA AVENUE SAINT LOUIS, MO 63125	38.533679	-90.302787	0		265417	ALEXIAN BROTHERS SHERBROOKE VILLAGE	4005 RIPA AVENUE	SAINT LOUIS	MO	63125	3145441111	940	St. Louis	Non profit - Church related	167	129.8	Medicare and Medicaid	false	ALEXIAN BROTHERS SHERBROOKE VILLAGE	02/20/1990	false		true	false	false	Resident	Yes	1		1		3		2		5		1	12	1	12	6	6															08/16/2019	18	13	7	215	1	0	215	08/24/2018	13	11	3	80	1	0	80	2017-09-12	13	12	2	1	56	0	56	143.5	5	7	2	64318.00	0	2	4005 RIPA AVENUE SAINT LOUIS, MO 63125 (38.533679, -90.302787)	02/01/2020
240	240	501 S PALM AVE PALATKA, FL 32177	29.644579	-81.662198	0		105805	CRESTWOOD NURSING CENTER	501 S PALM AVE	PALATKA	FL	32177	3863281472	530	Putnam	For profit - Corporation	65	44.3	Medicare and Medicaid	false	CRESTWOOD NURSING CENTER INC	07/01/1993	false	SFF Candidate	true	false	false	Resident	Yes	1		1		2		2		3		1	12	1	12	6	6															08/08/2019	24	12	12	975	1	0	975	06/01/2018	11	9	2	60	1	0	60	2017-06-08	13	10	3	1	60	0	60	517.5	0	12	1	41857.00	1	2	501 S PALM AVE PALATKA, FL 32177 (29.644579, -81.662198)	02/01/2020
328	328	2203 OAK STREET SEWARD, AK 99664	60.132402	-149.443395	0		25024	PROVIDENCE SEWARD MED & CARE CENTER LTC	2203 OAK STREET (P.O. BOX 430)	SEWARD	AK	99664	9072245241	210	Kenai Peninsula	Government - City	40	33.1	Medicare and Medicaid	true	CITY OF SEWARD	01/01/1994	false		false	false	false	Resident	Yes	1		2		1		1			2		2		2	6	6															10/09/2018	27	25	4	220	1	0	220	09/14/2017	7	7	0	32	1	0	32	2016-09-15	9	9	0	1	56	0	56	130	5	1	2	59795.00	0	2	2203 OAK STREET SEWARD, AK 99664 (60.132402, -149.443395)	02/01/2020
428	428	4809 REDMAN AVENUE OMAHA, NE 68104	41.310356	-95.986244	0		285107	SORENSEN CARE AND REHABILITATION CENTER, LLC	4809 REDMAN AVENUE	OMAHA	NE	68104	4024555025	270	Douglas	For profit - Corporation	74		Medicare and Medicaid	false	Legal Business Name Not Available	07/01/1991	false		false	false	false	Resident	Yes	1		1		2		2			2	1	12	1	12	6	6															08/30/2018	33	33	0	288	1	0	288	06/15/2017	11	11	11	84	1	0	84	2016-04-05	10	8	2	1	44	0	44	179.333	2	2	1	9100.00	1	2	4809 REDMAN AVENUE OMAHA, NE 68104 (41.310356, -95.986244)	02/01/2020
541	541	6515 W 103RD STREET OVERLAND PARK, KS 66212	38.942075	-94.662459	0		175176	INDIAN CREEK HEALTHCARE CENTER	6515 W 103RD STREET	OVERLAND PARK	KS	66212	9136425545	450	Johnson	For profit - Corporation	120	88.5	Medicare and Medicaid	false	OVERLAND PARK KS OPCO LLC	09/01/1988	false	SFF Candidate	false	false	true	Resident	Yes	1		1		4		4		3		1	12	1	12	6	6															10/15/2019	22	22	22	168	1	0	168	09/07/2018	5	5	5	32	1	0	32	2017-03-17	27	15	24	1	931	0	931	249.833	4	35	2	44257.00	0	2	6515 W 103RD STREET OVERLAND PARK, KS 66212 (38.942075, -94.662459)	02/01/2020
2128	2128	501 EAST MCCARTY ST SANDERSVILLE, GA 31082	32.98836	-82.802057	0		115691	SMITH MEDICAL NURSING CARE CTR	501 EAST MCCARTY ST	SANDERSVILLE	GA	31082	4785525155	950	Washington	For profit - Corporation	56	50.6	Medicare and Medicaid	false	Legal Business Name Not Available	12/13/2004	false		false	false	false	None	Yes	1		1		3		3			2	1	12	1	12	6	6															10/04/2018	14	12	14	112	1	0	112	10/12/2017	4	4	0	28	1	0	28	2016-12-15	17	17	0	1	509	0	509	150.167	0	3	1	38170.00	1	2	501 EAST MCCARTY ST SANDERSVILLE, GA 31082 (32.98836, -82.802057)	02/01/2020
2543	2543	178 WEST CAMPBELLTON STREET FAIRBURN, GA 30213	33.571177	-84.584444	0		115298	FAIRBURN HEALTH CARE CENTER	178 WEST CAMPBELLTON STREET	FAIRBURN	GA	30213	7709641320	470	Fulton	For profit - Corporation	120	89.7	Medicare and Medicaid	false	GAFAIRBURN SNF LLC	05/07/1982	false		false	false	false	Resident	Yes	1		2		2		1		3		1	12	1	12	6	6															08/08/2019	7	4	3	28	1	0	28	05/24/2018	2	2	0	8	1	0	8	2017-07-20	2	2	0	1	40	0	40	23.333	0	3	1	7475.00	1	2	178 WEST CAMPBELLTON STREET FAIRBURN, GA 30213 (33.571177, -84.584444)	02/01/2020
2861	2861	2550 NORTH NYE AVENUE FREMONT, NE 68025	41.454318	-96.502103	0		285103	PREMIER ESTATES OF FREMONT, LLC	2550 NORTH NYE AVENUE	FREMONT	NE	68025	4027271710	260	Dodge	For profit - Corporation	147	5.1	Medicare and Medicaid	false	Legal Business Name Not Available	01/07/1991	false		false	false	false	Resident	Yes	1		1		3		3			2		2		2	6	6															04/01/2019	11	9	6	44	1	0	44	09/25/2018	23	21	3	144	2	72	216	2018-03-08	22	11	16	1	176	0	176	123.333	11	19	1	7150.00	1	2	2550 NORTH NYE AVENUE FREMONT, NE 68025 (41.454318, -96.502103)	02/01/2020
3398	3398	3354 JEROME LANE CAHOKIA, IL 62206	38.551496	-90.149391	0		145613	BRIA OF CAHOKIA	3354 JEROME LANE	CAHOKIA	IL	62206	6183379400	900	St. Clair	For profit - Individual	133	118.6	Medicare and Medicaid	false	CAHOKIA HEALTH CARE CENTER LLC	02/22/1989	false		true	false	false	None	Yes	1		1		1		1		1		1	12	1	12	6	6															04/02/2019	14	7	11	76	1	0	76	04/11/2018	28	15	13	329	1	0	329	2017-04-20	8	6	2	1	56	0	56	157	1	25	2	129220.00	0	2	3354 JEROME LANE CAHOKIA, IL 62206 (38.551496, -90.149391)	02/01/2020
3525	3525	505 N MAIN STREET ESKRIDGE, KS 66423	38.8633	-96.104597	0		175455	ESKRIDGE OPERATOR LLC	505 N. MAIN STREET	ESKRIDGE	KS	66423	7854492294	980	Wabaunsee	Government - State	60	57.8	Medicare and Medicaid	false	ESKRIDGE OPERATOR LLC	07/23/2002	false		false	false	true	Resident	Yes	1		1		4		4			2	1	12	1	12	6	6															01/15/2019	15	15	4	140	1	0	140	12/14/2017	10	10	2	92	1	0	92	2016-02-23	14	6	8	1	136	0	136	123.333	2	7	2	19810.00	0	2	505 N MAIN STREET ESKRIDGE, KS 66423 (38.8633, -96.104597)	02/01/2020
3526	3526	300 EAST HORNBECK STREET SENATH, MO 63876	36.126758	-90.154429	0		265388	SENATH HEALTH CARE CENTER	300 EAST HORNBECK STREET, PO BOX 940	SENATH	MO	63876	5737382627	340	Dunklin	For profit - Limited Liability company	120	85.1	Medicare and Medicaid	false	SENATH HEALTH CARE CENTER LLC	08/21/1989	false		false	false	false	Resident	Yes	1		1		4		4			2		2		2	6	6															10/30/2019	26	21	5	120	1	0	120	12/07/2018	18	9	13	180	1	0	180	2017-11-02	3	2	1	1	16	0	16	122.667	0	12	0	0.00	2	2	300 EAST HORNBECK STREET SENATH, MO 63876 (36.126758, -90.154429)	02/01/2020
3805	3805	8540 SOUTH HARLEM BRIDGEVIEW, IL 60455	41.735931	-87.799224	0		145778	MIDWAY NEUROLOGICAL / REHAB CENTER	8540 SOUTH HARLEM	BRIDGEVIEW	IL	60455	7085982605	141	Cook	For profit - Corporation	404	365.2	Medicare and Medicaid	false	MIDWAY NEUROLOGICAL AND REHABILITATION CENTER LLC	12/01/1993	false		false	false	false	Resident	Yes	2		2		3		5		1			2		2	6	6															06/27/2019	4	3	1	24	1	0	24	05/09/2018	15	12	3	152	1	0	152	2017-04-21	33	16	20	1	184	0	184	93.333	0	31	2	17500.00	0	2	8540 SOUTH HARLEM BRIDGEVIEW, IL 60455 (41.735931, -87.799224)	02/01/2020
3949	3949	1611 RITCHIE WINFIELD, KS 67156	37.233359	-96.980144	0		175488	WINFIELD REST HAVEN II, LLC	1611 RITCHIE	WINFIELD	KS	67156	6202219290	170	Cowley	Non profit - Church related	41	34.8	Medicare and Medicaid	false	WINFIELD REST HAVEN INC	06/23/2006	false		false	false	false	None	Yes	2		3		2		1		4		1	12	1	12	6	6															12/12/2019	5	5	0	20	0	0	20	12/12/2018	12	9	3	84	1	0	84	2017-09-29	17	9	10	2	76	38	114	57	2	3	1	7150.00	1	2	1611 RITCHIE WINFIELD, KS 67156 (37.233359, -96.980144)	02/01/2020
4432	4432	150 NORTH 27TH STREET BELLEVILLE, IL 62226	38.525934	-90.009532	0		145668	BRIA OF BELLEVILLE	150 NORTH 27TH STREET	BELLEVILLE	IL	62226	6182356600	900	St. Clair	For profit - Corporation	140	116.6	Medicare and Medicaid	false	BELLEVILLE HEALTHCARE & REHAB CENTER	12/29/1989	false	SFF Candidate	true	false	false	Resident	Yes	1		1		2		2		3		1	12	1	12	6	6															06/07/2019	35	17	22	268	2	134	402	07/24/2018	10	8	2	64	1	0	64	2017-06-23	20	10	11	1	112	0	112	241	0	35	1	24555.00	1	2	150 NORTH 27TH STREET BELLEVILLE, IL 62226 (38.525934, -90.009532)	02/01/2020
4746	4746	14792 CATLIN TILTON ROAD DANVILLE, IL 61834	40.098308	-87.663669	0		145926	GARDENVIEW MANOR	14792 CATLIN TILTON ROAD	DANVILLE	IL	61834	2174436430	982	Vermilion	For profit - Partnership	213	96	Medicare and Medicaid	false	GARDENVIEW MANOR, LLC	05/01/1997	false	SFF Candidate	true	false	false	Resident	Yes	1		1		1		1		2		1	12	1	12	6	6															05/17/2019	66	23	44	440	1	0	440	05/29/2018	44	16	28	327	1	0	327	2017-09-15	19	9	10	1	80	0	80	342.333	1	53	0	0.00	2	2	14792 CATLIN TILTON ROAD DANVILLE, IL 61834 (40.098308, -87.663669)	02/01/2020
5641	5641	519 MAIN STREET MEDFIELD, MA 02052	42.185978	-71.307339	0		225645	THOMAS UPHAM HOUSE	519 MAIN STREET	MEDFIELD	MA	2052	5083596050	130	Norfolk	For profit - Corporation	42	40.1	Medicare and Medicaid	false	519 MAIN ST., INC.	09/01/1994	false		true	false	false	Resident	Yes	1		2		2		3		2		1	12	1	12	6	6															03/20/2018	7	5	2	76	2	38	114	12/28/2016	5	5	0	44	1	0	44	2015-09-21	0	0	0	0	0	0	0	71.667	1	0	2	16047.00	0	2	519 MAIN STREET MEDFIELD, MA 02052 (42.185978, -71.307339)	02/01/2020
6046	6046	56-117 Pualalea St, Kahuku, HI 96731, USA	21.6763946	-157.9541328	1	ROOFTOP	125030	KAHUKU MEDICAL CENTER	56-117 PUALALEA STREET	KAHUKU	HI	96731	8082939221	20	Honolulu	Non profit - Other	6	5.9	Medicare and Medicaid	true	KAHUKU MEDICAL CENTER	01/01/1977	false		false	false	false	Resident	Yes	1		2			2		2		2	1	12	1	12	6	6															06/04/2019	6	6	0	28	1	0	28	07/06/2018	5	5	0	60	1	0	60	2017-07-14	10	10	0	2	119	60	179	63.833	0	0	1	19500.00	1	2		02/01/2020
6054	6054	960 PROSPECT ROAD WEST POINT, NE 68788	41.842632	-96.701765	0		285158	PREMIER ESTATES OF WEST POINT, LLC	960 PROSPECT ROAD	WEST POINT	NE	68788	4023722441	190	Cuming	For profit - Corporation	64	5	Medicare and Medicaid	false	Legal Business Name Not Available	01/12/1995	false		false	false	false	Resident	Yes	2		1		5		5			2		2		2	6	6															06/12/2018	19	19	6	100	2	50	150	04/11/2017	26	12	14	152	1	0	152	2016-03-10	17	13	4	1	148	0	148	150.333	1	34	1	12423.00	1	2	960 PROSPECT ROAD WEST POINT, NE 68788 (41.842632, -96.701765)	02/01/2020
6294	6294	2480 S CLERMONT ST DENVER, CO 80222	39.670949	-104.935326	0		65344	SUITES AT CLERMONT PARK CARE CENTER	2480 S CLERMONT ST	DENVER	CO	80222	7209743901	150	Denver	Non profit - Corporation	63	61.7	Medicare and Medicaid	false	CHRISTIAN LIVING COMMUNITIES	03/01/1996	true		false	false	false	Resident	Yes	2		2		5		5		5		1	12	1	12	6	6															11/12/2019	6	6	0	24	1	0	24	11/01/2018	5	5	0	36	1	0	36	2017-04-27	3	3	0	1	149	0	149	48.833	0	0	2	50523.00	0	2	2480 S CLERMONT ST DENVER, CO 80222 (39.670949, -104.935326)	02/01/2020
6731	6731	490 WEST 16TH PLACE CHICAGO HEIGHTS, IL 60411	41.501315	-87.66181	0		145180	APERION CARE CHICAGO HEIGHTS	490 WEST 16TH PLACE	CHICAGO HEIGHTS	IL	60411	7084814444	141	Cook	For profit - Corporation	200	188.3	Medicare and Medicaid	false	RIVIERA CARE CENTER, LLC	11/01/1967	false		false	false	false	Resident	Yes	3		2		5		5			2		2		2	6	6															12/06/2018	9	7	2	112	1	0	112	11/17/2017	7	7	2	36	1	0	36	2016-10-21	15	4	11	1	104	0	104	85.333	1	10	1	35451.00	1	2	490 WEST 16TH PLACE CHICAGO HEIGHTS, IL 60411 (41.501315, -87.66181)	02/01/2020
6779	6779	515 NORTH MAIN SANDWICH, IL 60548	41.65054	-88.62183	0		145712	WILLOW CREST NURSING PAVILION	515 NORTH MAIN	SANDWICH	IL	60548	8157868426	170	De Kalb	For profit - Individual	113	92.6	Medicare and Medicaid	false	WILLOW CREST NURSING PAVILLION, LTD.	03/01/1992	false		false	false	false	Resident	Yes	1		1		2		1		2		1	12	1	12	6	6															04/11/2019	19	11	8	80	1	0	80	03/16/2018	29	16	13	232	2	116	348	2017-02-16	15	6	9	1	92	0	92	171.333	7	16	1	20816.00	1	2	515 NORTH MAIN SANDWICH, IL 60548 (41.65054, -88.62183)	02/01/2020
7059	7059	560 WOODBURY ROAD WATERTOWN, CT 06795	41.60198	-73.138173	0		75340	WATERTOWN CONVALARIUM, INC	560 WOODBURY ROAD	WATERTOWN	CT	6795	8602746748	20	Litchfield	For profit - Corporation	46	37.7	Medicare and Medicaid	false	MVM INC	09/14/1990	false		false	false	false	Resident	Yes	1		1		2		2		2		1	12	1	12	6	6															09/12/2019	7	7	0	92	2	46	138	11/29/2018	16	16	0	114	2	57	171	2018-01-05	5	5	0	1	24	0	24	130	0	0	1	10318.00	1	2	560 WOODBURY ROAD WATERTOWN, CT 06795 (41.60198, -73.138173)	02/01/2020
7132	7132	425 FISHER ST MARQUETTE, MI 49855	46.540075	-87.401901	0		235724	DJ JACOBETTI HOME FOR VETERANS	425 FISHER ST	MARQUETTE	MI	49855	9062263576	510	Marquette	Government - State	81	73.9	Medicare and Medicaid	false	STATE OF MICHIGAN	09/30/2018	false		false	false	false	Both	Yes	2		2		2		2			2		2		2	6	6															09/12/2019	9	8	1	198	1	0	198	08/31/2018	0	0	0	0	0	0	0		.	.	.	.	.	.	.	118.8	8	0	1	26745.00	1	2	425 FISHER ST MARQUETTE, MI 49855 (46.540075, -87.401901)	02/01/2020
7184	7184	2829 SOUTH CALIFORNIA BLVD CHICAGO, IL 60608	41.840642	-87.694262	0		145625	CALIFORNIA GARDENS N & REHAB C	2829 SOUTH CALIFORNIA BLVD	CHICAGO	IL	60608	7738478061	141	Cook	For profit - Individual	297	281	Medicare and Medicaid	false	SYMPHONY OF CALIFORNIA GARDENS LLC	06/09/1989	false		false	false	true	Resident	Yes	1		1		4		5		2		1	12	1	12	6	6															10/23/2019	26	24	2	176	1	0	176	09/13/2018	24	16	8	128	1	0	128	2017-08-11	9	5	4	1	68	0	68	142	0	13	1	12760.00	1	2	2829 SOUTH CALIFORNIA BLVD CHICAGO, IL 60608 (41.840642, -87.694262)	02/01/2020
7357	7357	300 BARBER AVENUE WORCESTER, MA 01606	42.296099	-71.797144	0		225648	HOLY TRINITY EASTERN ORTHODOX N & R CENTER	300 BARBER AVENUE	WORCESTER	MA	1606	5088521000	170	Worcester	Non profit - Corporation	113	104.3	Medicare and Medicaid	false	EASTERN ORTHODOX MANAGEMENT CORPORATION	08/22/1994	false		false	false	false	Both	Yes	1		2		4		3		5		1	12	1	12	6	6															03/15/2019	1	0	1	4	0	0	4	11/10/2017	4	4	0	16	1	0	16	2016-10-25	15	9	6	2	164	82	246	48.333	1	1	2	138424.00	0	2	300 BARBER AVENUE WORCESTER, MA 01606 (42.296099, -71.797144)	02/01/2020
7717	7717	1112 SE REPUBLICAN AVENUE TOPEKA, KS 66607	39.041478	-95.648537	0		175418	PROVIDENCE LIVING CENTER	1112 SE REPUBLICAN AVENUE	TOPEKA	KS	66607	7852330588	880	Shawnee	Government - State	78	65.8	Medicare and Medicaid	false	PROVIDENCE LIVING CENTER, INC.	08/01/1997	false		false	false	false	Resident	Yes	1		1		3		3			2	1	12	1	12	6	6															06/13/2019	5	5	5	32	1	0	32	07/26/2018	27	23	15	264	1	0	264	2016-11-29	13	12	1	2	267	134	401	170.833	3	15	1	37877.00	1	2	1112 SE REPUBLICAN AVENUE TOPEKA, KS 66607 (39.041478, -95.648537)	02/01/2020
7827	7827	1915 E REZANOF DRIVE KODIAK, AK 99615	57.800835	-152.373943	0		25030	PROVIDENCE KODIAK ISLAND MED LTC	1915 E REZANOF DRIVE	KODIAK	AK	99615	9074867800	150	Kodiak Island Borough	Non profit - Corporation	22	20.4	Medicare and Medicaid	false	Legal Business Name Not Available	09/20/1994	false		false	false	false	Both	Yes	5		4		5		5			2		2		2	6	6															03/15/2019	2	2	0	20	1	0	20	05/18/2018	6	6	0	40	1	0	40	2017-03-20	22	22	0	1	191	0	191	55.167	0	0	2	26312.00	0	2	1915 E REZANOF DRIVE KODIAK, AK 99615 (57.800835, -152.373943)	02/01/2020
8074	8074	7301 St Charles Rock Rd, St. Louis, MO 63133, USA	38.691502	-90.3070879	1	ROOFTOP	265578	NORMANDY NURSING CENTER	7301 ST CHARLES ROCK RD	SAINT LOUIS	MO	63133	3148620555	940	St. Louis	For profit - Limited Liability company	116	3.4	Medicare and Medicaid	false	NORMANDY HEALTHCARE LLC	03/11/1994	false	SFF Candidate	false	false	false	Resident	Yes	2		1		5		5			2	1	12	1	12	6	6															02/07/2019	19	19	0	140	1	0	140	04/09/2018	41	26	15	391	1	0	391	2017-04-20	10	8	4	1	80	0	80	213.667	4	9	1	65471.00	1	2		02/01/2020
8286	8286	919 OLD WINTER HAVEN RD AUBURNDALE, FL 33823	28.058697	-81.77095	0		105302	OAK HAVEN REHAB AND NURSING CENTER	919 OLD WINTER HAVEN RD	AUBURNDALE	FL	33823	8639674125	520	Polk	For profit - Corporation	120	99.2	Medicare and Medicaid	false	AUBURNDALE OAKS CARE ACQUISITION, LLC	01/01/1977	false	SFF	true	false	false	Resident	Yes		18		18		18		18		18		18		18	6	6															12/13/2018	15	13	9	394	2	197	591	09/22/2017	7	4	3	32	1	0	32	2016-07-28	9	7	2	1	44	0	44	313.5	0	16	1	147689.00	1	2	919 OLD WINTER HAVEN RD AUBURNDALE, FL 33823 (28.058697, -81.77095)	02/01/2020
8558	8558	5500 WEST 123RD ST OVERLAND PARK, KS 66209	38.906056	-94.650403	0		175441	VILLAGE SHALOM INC	5500 WEST 123RD ST	OVERLAND PARK	KS	66209	9133172600	450	Johnson	Non profit - Corporation	76		Medicare and Medicaid	false	VILLAGE SHALOM, INC	10/31/2000	true		false	false	false	Resident	Yes	3		3		3		1		4			2		2	6	6															04/25/2019	6	5	6	24	1	0	24	06/21/2018	7	7	0	84	1	0	84	2016-06-15	3	0	3	0	95	0	95	55.833	2	4	2	23972.00	0	2	5500 WEST 123RD ST OVERLAND PARK, KS 66209 (38.906056, -94.650403)	02/01/2020
9086	9086	837 W MANCHESTER AVE LOS ANGELES, CA 90044	33.960069	-118.288268	0		555273	MANCHESTER MANOR CONV HOSPITAL	837 W. MANCHESTER AVE.	LOS ANGELES	CA	90044	3237531789	200	Los Angeles	For profit - Corporation	49	42.6	Medicare and Medicaid	false	MANCHESTER MANOR CONVALESCENT HOSPITAL	01/01/1987	false		false	false	false	Resident	Yes	2		1		5		5			2	1	12	1	12	6	6															04/24/2019	8	8	0	52	1	0	52	05/06/2018	19	18	1	112	1	0	112	2017-08-01	27	19	8	2	296	148	444	137.333	0	10	1	41773.00	1	2	837 W MANCHESTER AVE LOS ANGELES, CA 90044 (33.960069, -118.288268)	02/01/2020
9161	9161	1800 RIVERSIDE DRIVE COLUMBUS, OH 43212	39.992341	-83.066354	0		365047	FIRST COMMUNITY VILLAGE HEALTHCARE CTR	1800 RIVERSIDE DRIVE	COLUMBUS	OH	43212	6144869511	250	Franklin	Non profit - Corporation	138	59.9	Medicare and Medicaid	false	FIRST COMMUNITY VILLAGE	01/01/1967	true		false	false	false	Both	Yes	2		2		5		4		5		1	12	1	12	6	6															01/31/2019	11	11	0	56	1	0	56	04/05/2018	10	8	2	56	1	0	56	2017-02-15	10	7	3	1	84	0	84	60.667	0	4	2	43393.00	0	2	1800 RIVERSIDE DRIVE COLUMBUS, OH 43212 (39.992341, -83.066354)	02/01/2020
9349	9349	198 County Rd D F, Juneau, WI 53039, USA	43.414556	-88.6987043	1	ROOFTOP	525453	CLEARVIEW	198 COUNTY DF	JUNEAU	WI	53039	9203863400	130	Dodge	Government - County	120	101.9	Medicare and Medicaid	false	MARSH COUNTRY HEALTH ALLIANCE	12/01/1989	false		false	false	false	Resident	Yes	2		3		4		2		5		1	12	1	12	6	6															02/26/2019	1	1	0	20	1	0	20	11/09/2017	1	1	0	20	1	0	20	2016-10-20	3	1	2	1	20	0	20	20	0	1	2	14839.00	0	2		02/01/2020
9380	9380	1331 CAMDEN AVENUE CAMPBELL, CA 95008	37.269214	-121.945071	0		555838	CAMDEN POSTACUTE CARE, INC	1331 CAMDEN AVENUE	CAMPBELL	CA	95008	4083774030	530	Santa Clara	For profit - Corporation	60	55.4	Medicare and Medicaid	false	CAMDEN POSTACUTE CARE, INC	11/17/2006	false		false	false	false	Resident	Yes	1		1		4		5		4		1	12	1	12	6	6															03/07/2019	38	24	16	246	1	0	246	05/24/2018	24	17	9	100	1	0	100	2017-06-09	17	11	7	1	92	0	92	171.667	12	18	2	44798.00	0	2	1331 CAMDEN AVENUE CAMPBELL, CA 95008 (37.269214, -121.945071)	02/01/2020
9476	9476	581 NEWBERRY HIGHWAY SALUDA, SC 29138	34.02135	-81.768234	0		425081	SALUDA NURSING CENTER	581 NEWBERRY HIGHWAY	SALUDA	SC	29138	8644452146	400	Saluda	Government - County	176	170.9	Medicare and Medicaid	false	SALUDA NURSING CENTER	08/16/1971	false		true	false	false	Resident	Yes	2		2		5		5		5		1	12	1	12	6	6															03/30/2019	5	5	0	72	1	0	72	03/01/2018	12	12	0	64	1	0	64	2016-11-03	0	0	0	0	0	0	0	57.333	0	0	1	27810.00	1	2	581 NEWBERRY HIGHWAY SALUDA, SC 29138 (34.02135, -81.768234)	02/01/2020
9608	9608	3549 NORRISWOOD MEMPHIS, TN 38111	35.121209	-89.943555	0		445165	THE HIGHLANDS OF MEMPHIS HEALTH & REHABILITATION	3549 NORRISWOOD	MEMPHIS	TN	38111	9013257820	780	Shelby	For profit - Limited Liability company	180	143.7	Medicare and Medicaid	false	TN MEM OP LLC	06/25/1984	false		false	false	false	Resident	Yes	1		1		4		3		4		1	12	1	12	6	6															10/22/2019	11	3	10	56	1	0	56	12/06/2018	7	5	2	32	1	0	32	2018-01-25	6	3	3	1	72	0	72	50.667	4	16	2	37410.00	0	2	3549 NORRISWOOD MEMPHIS, TN 38111 (35.121209, -89.943555)	02/01/2020
9684	9684	6800 N 76TH STREET MILWAUKEE, WI 53223	43.142198	-88.005448	0		525529	BRIDGES OF MILWAUKEE REHAB AND CARE CENTER (THE)	6800 N 76TH STREET	MILWAUKEE	WI	53223	4143535000	390	Milwaukee	For profit - Corporation	144	74.4	Medicare and Medicaid	false	JB MILWAUKEE HEALTHCARE LLC	04/01/1994	false	SFF	false	false	false	Resident	Yes		18		18		18		18		18		18		18	6	6															07/23/2019	20	15	5	270	2	135	405	02/26/2019	34	24	19	319	1	0	319	2017-11-27	22	15	12	2	112	56	168	336.833	4	20	0	0.00	2	2	6800 N 76TH STREET MILWAUKEE, WI 53223 (43.142198, -88.005448)	02/01/2020
10050	10050	3400 N County Rd F, Janesville, WI 53545, USA	42.7228203	-89.0285024	1	ROOFTOP	525390	ROCK HAVEN	3400 N CTY TRK HWY F PO BOX 920	JANESVILLE	WI	53547	6087575076	520	Rock	Government - County	128	120.1	Medicare and Medicaid	false	COUNTY OF ROCK COUNTY CLERK	07/01/1985	false		false	false	false	Resident	Yes	1		1		3		2		4		1	12	1	12	6	6															04/04/2019	7	7	0	60	1	0	60	02/22/2018	9	6	4	177	1	0	177	2016-12-08	6	4	2	1	24	0	24	93	2	2	2	41653.00	0	2		02/01/2020
10826	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	Legal Business Name Not Available	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
11285	11285	564 State Line Rd, Colcord, OK 74338, USA	36.1806625	-94.5670008	1	ROOFTOP	375386	QUAIL RIDGE LIVING CENTER, INC	564 STATE LINE ROAD	COLCORD	OK	74338	9184225138	200	Delaware	For profit - Corporation	120	77.3	Medicare and Medicaid	false	QUAIL RIDGE LIVING CENTER INC	07/10/2000	false		false	false	false	Resident	Yes	1		1		3		3		3		1	12	1	12	6	6															10/08/2018	6	6	0	44	1	0	44	08/29/2017	6	2	4	395	1	0	395	2016-06-27	9	9	0	1	185	0	185	184.5	0	1	1	85600.00	1	2		02/01/2020
12420	12420	922 WEST PARKLAND AVENUE PRAGUE, OK 74864	35.496028	-96.687251	0		375385	PARKLAND MANOR LIVING CENTER	922 WEST PARKLAND AVENUE	PRAGUE	OK	74864	4055672201	400	Lincoln	For profit - Corporation	78		Medicare and Medicaid	false	PARKLAND MANOR LIVING CENTER LLC	03/22/2000	false		false	false	false	Resident	Yes	2		1		5		5			2	1	12	1	12	6	6															08/02/2018	10	10	0	60	1	0	60	04/04/2017	23	23	0	252	1	0	252	2016-02-24	2	2	0	1	12	0	12	116	0	0	1	13852.00	1	2	922 WEST PARKLAND AVENUE PRAGUE, OK 74864 (35.496028, -96.687251)	02/01/2020
12997	12997	1251 WEST HOUSTON BROKEN ARROW, OK 74012	36.046419	-95.803901	0		375351	ASPEN HEALTH AND REHAB	1251 WEST HOUSTON	BROKEN ARROW	OK	74012	5393674500	710	Tulsa	For profit - Corporation	126	1.9	Medicare and Medicaid	false	PARKS EDGE CARE CENTER INC	09/14/1998	false		false	false	false	Resident	Yes	1		2		3		3			2	1	12	1	12	6	6															10/25/2018	0	0	0	0	1	0	0	08/16/2017	6	6	0	48	1	0	48	2016-05-26	10	4	6	1	335	0	335	71.833	0	2	2	33791.00	0	2	1251 WEST HOUSTON BROKEN ARROW, OK 74012 (36.046419, -95.803901)	02/01/2020
13045	13045	451 S EL CAMINO CROSSING SAN AUGUSTINE, TX 75972	31.528587	-94.125466	0		675729	TWIN LAKES REHABILITATION AND CARE CENTER	451 S EL CAMINO CROSSING	SAN AUGUSTINE	TX	75972	9362752900	883	San Augustine	For profit - Partnership	90	55.6	Medicare and Medicaid	false	NACOGDOCHES COUNTY HOSPITAL DISTRICT	09/24/1997	false		false	false	false	Both	Yes	1		2		3		2		5		1	12	1	12	6	6															08/15/2019	6	6	0	95	1	0	95	09/19/2018	6	6	1	36	1	0	36	2017-07-12	7	5	2	1	88	0	88	74.167	1	2	1	11512.00	1	2	451 S EL CAMINO CROSSING SAN AUGUSTINE, TX 75972 (31.528587, -94.125466)	02/01/2020
13268	13268	4718 HALLMARK DR HOUSTON, TX 77056	29.750299	-95.458765	0		676423	THE HALLMARK	4718 HALLMARK DR	HOUSTON	TX	77056	7136226633	610	Harris	Non profit - Corporation	32	22.3	Medicare and Medicaid	false	BRAZOS PRESBYTERIAN HOMES INC	05/26/2017	false		false	false	false	Resident	Yes	2		2		3		4		2			2		2	6	6															02/15/2019	9	9	8	76	2	38	114	02/08/2018	5	5	0	32	1	0	32	2017-04-27	5	5	0	1	56	0	56	77	0	0	1	24830.00	1	2	4718 HALLMARK DR HOUSTON, TX 77056 (29.750299, -95.458765)	02/01/2020
13630	13630	300 SOUTH 18TH STREET MOUNT VERNON, WA 98274	48.419115	-122.318825	0		505315	MIRA VISTA CARE CENTER	300 SOUTH 18TH STREET	MOUNT VERNON	WA	98274	3604241320	280	Skagit	For profit - Corporation	94	84.2	Medicare and Medicaid	false	LOOKOUT POST ACUTE LLC	11/01/1987	false		false	false	false	Resident	Yes	1		1		4		4		4		1	12	1	12	6	6															02/04/2019	40	31	9	224	1	0	224	10/07/2017	23	17	7	253	1	0	253	2016-08-18	23	16	7	1	120	0	120	216.333	2	12	2	35611.00	0	2	300 SOUTH 18TH STREET MOUNT VERNON, WA 98274 (48.419115, -122.318825)	02/01/2020
14266	14266	7500 W DEAN RD MILWAUKEE, WI 53223	43.170585	-88.003209	0		525498	BRIA OF TRINITY VILLAGE	7500 W DEAN RD	MILWAUKEE	WI	53223	4143717595	390	Milwaukee	For profit - Limited Liability company	87	79.8	Medicare and Medicaid	false	TRN MILWAUKEE LLC	10/01/1992	true	SFF Candidate	true	false	false	Both	Yes	1		1		3		2		4		1	12	1	12	6	6															10/23/2019	33	16	20	402	1	0	402	07/31/2018	23	1	23	116	1	0	116	2017-09-21	32	21	22	1	441	0	441	313.167	3	28	2	122267.00	0	2	7500 W DEAN RD MILWAUKEE, WI 53223 (43.170585, -88.003209)	02/01/2020
14481	14481	915 PEE DEE ROAD ABERDEEN, NC 28315	35.12131	-79.414904	0		345509	ACCORDIUS HEALTH AT ABERDEEN	915 PEE DEE ROAD	ABERDEEN	NC	28315	9109448999	620	Moore	For profit - Individual	90	82.5	Medicare and Medicaid	false	ACCORDIUS HEALTH AT ABERDEEN LLC	12/07/2000	false		false	false	false	Resident	Yes	1		1		2		4		1		1	12	1	12	6	6															05/16/2019	15	13	4	64	1	0	64	03/01/2018	9	9	0	48	1	0	48	2017-09-21	37	10	28	1	434	0	434	120.333	0	22	2	282144.00	0	2	915 PEE DEE ROAD ABERDEEN, NC 28315 (35.12131, -79.414904)	02/01/2020
14902	14902	1131 ARIZONA AVE SANTA MONICA, CA 90401	34.023654	-118.489446	0		555061	GOOD SHEPHERD HLTH CARE CTR OF SANTA MONICA	1131 ARIZONA AVE.	SANTA MONICA	CA	90401	3104514800	200	Los Angeles	For profit - Corporation	48	41.5	Medicare and Medicaid	false	GOOD SHEPHERD HEALTHCARE CENTER OF SANTA MONICA	03/22/1977	false	SFF Candidate	false	false	false	Resident	Yes	1		1		2		3		2		1	12	1	12	6	6															12/19/2019	13	13	0	52	1	0	52	12/21/2018	28	16	12	148	1	0	148	2018-01-16	32	21	14	2	701	351	1052	250.667	7	24	2	103888.00	0	2	1131 ARIZONA AVE SANTA MONICA, CA 90401 (34.023654, -118.489446)	02/01/2020
15261	15261	8781 LAKEVIEW AVENUE RIVERSIDE, CA 92509	33.971384	-117.475534	0		555330	RIVERSIDE POSTACUTE CARE	8781 LAKEVIEW AVENUE	RIVERSIDE	CA	92509	9516851531	430	Riverside	For profit - Limited Liability company	188	172.6	Medicare and Medicaid	false	RIVERSIDE POSTACUTE CARE LLC	10/28/1988	false	SFF Candidate	true	false	false	Resident	Yes	2		1		5		5		4		1	12	1	12	6	6															12/06/2019	20	11	9	112	1	0	112	02/15/2019	39	17	22	472	2	236	708	2018-02-16	64	21	47	1	280	0	280	338.667	9	40	1	130670.00	1	2	8781 LAKEVIEW AVENUE RIVERSIDE, CA 92509 (33.971384, -117.475534)	02/01/2020
4415	4415	7001 CLEVELAND AVENUE KANSAS CITY, MO 64132	38.999302	-94.542853	0		265721	GREGORY RIDGE HEALTH CARE CENTER	7001 CLEVELAND AVENUE	KANSAS CITY	MO	64132	8163330700	470	Jackson	For profit - Limited Liability company	116	110.7	Medicare and Medicaid	false	GREGORY RIDGE HEALTH CARE CENTER, L.L.C.	10/05/2001	false	SFF Candidate	true	false	false	Both	Yes	1		1		4		4			2	2		1				1.97858	0.6861	0.13862	0.82471	2.80329	0	1.33826	0.55671	0.24557	2.14054	3.07275	0.92671	0.21246	4.19951	04/11/2019	21	14	8	203	2	102	305	05/16/2018	24	22	4	168	1	0	168	2017-06-05	17	14	3	1	92	0	92	223.833	9	4	1	11278.00	1	2	7001 CLEVELAND AVENUE KANSAS CITY, MO 64132 (38.999302, -94.542853)	02/01/2020
8915	8915	301 BROADWAY LEXINGTON, OK 73051	35.796452	-97.677791	0		375491	BROADWAY LIVING CENTER	301 BROADWAY	LEXINGTON	OK	73051	4055276519	130	Cleveland	For profit - Partnership	101	87.5	Medicare and Medicaid	false	MM OF LEXINGTON LLC	08/29/2005	false		false	false	false	Resident	Yes	3		2		5		5			2	3		2				1.95318	0.75544	0.31877	1.07421	3.02739	0	1.42821	0.57236	0.25554	2.25612	2.84227	0.99245	0.46951	4.30288	01/08/2019	6	4	2	32	1	0	32	11/16/2017	15	14	1	96	1	0	96	2016-08-31	13	10	3	1	112	0	112	66.667	0	5	1	6152.00	1	2	301 BROADWAY LEXINGTON, OK 73051 (35.796452, -97.677791)	02/01/2020
8473	8473	649 SOUTH WALNUT SAINT ELIZABETH, MO 65075	38.244553	-92.268764	0		265676	ST ELIZABETH CARE CENTER	649 SOUTH WALNUT	SAINT ELIZABETH	MO	65075	5734932215	650	Miller	For profit - Individual	63	56.8	Medicare and Medicaid	false	MMA HEALTHCARE OF ST ELIZABETH INC	08/01/1997	false		false	false	false	None	Yes	2		3		4		4			2	1		1				1.46033	0.46388	0.16659	0.63047	2.0908	0	1.46425	0.55485	0.24878	2.26788	2.07277	0.62866	0.25203	2.95628	09/26/2019	3	3	0	28	1	0	28	07/13/2018	6	6	0	48	1	0	48	2017-08-14	6	6	0	2	36	18	54	39	0	0	1	8125.00	1	2	649 SOUTH WALNUT SAINT ELIZABETH, MO 65075 (38.244553, -92.268764)	02/01/2020
6938	6938	2800 HIGHWAY SEDALIA, MO 65301	38.689363	-93.152826	0		265149	FOUR SEASONS LIVING CENTER	2800 HIGHWAY TT	SEDALIA	MO	65301	6608268803	790	Pettis	For profit - Corporation	239	234.5	Medicare and Medicaid	false	FOUR SEASONS LIVING CENTER, LLC	10/01/1980	false		true	false	false	Resident	Yes	1		1		4		4		4		1		1				1.44961	0.54096	0.05053	0.59148	2.0411	0	1.50193	0.56354	0.24314	2.30861	2.00594	0.72181	0.07821	2.83508	10/28/2019	9	5	4	157	1	0	157	09/07/2018	5	3	2	44	1	0	44	2017-10-06	17	13	4	1	96	0	96	109.167	3	7	1	7296.00	1	2	2800 HIGHWAY SEDALIA, MO 65301 (38.689363, -93.152826)	02/01/2020
5132	5132	2415 NORTH KINGSHIGHWAY SAINT LOUIS, MO 63113	38.667584	-90.258384	0		265524	NORTHVIEW VILLAGE	2415 NORTH KINGSHIGHWAY	SAINT LOUIS	MO	63113	3143611300	950	St. Louis City	For profit - Corporation	320	258.9	Medicare and Medicaid	false	NORTHVIEW VILLAGE, INC.	12/07/1992	false		false	false	false	Both	Yes	1		1		3		4		2		1		1				1.54061	0.6298	0.17527	0.80506	2.34567	0.01479	1.50339	0.57026	0.24846	2.32212	2.12979	0.83044	0.2655	3.23919	12/20/2019	16	15	1	108	0	0	108	02/25/2019	13	12	1	139	1	0	139	2018-02-22	10	6	6	1	84	0	84	114.333	2	9	2	18158.00	0	2	2415 NORTH KINGSHIGHWAY SAINT LOUIS, MO 63113 (38.667584, -90.258384)	02/01/2020
7848	7848	518 E MARSHALL SWEET SPRINGS, MO 65351	38.964728	-93.407384	0		265606	SWEET SPRINGS VILLA	518 E MARSHALL	SWEET SPRINGS	MO	65351	6603356391	970	Saline	For profit - Individual	120	39.3	Medicare and Medicaid	false	N & R OF SWEET SPRINGS, INC.	02/03/1995	false		false	false	false	None	Yes	1		1		2		2			2	3		2				2.62497	0.83289	0.32222	1.15511	3.78007	0.02097	1.50375	0.58429	0.26911	2.35715	3.62796	1.07187	0.45066	5.1424	07/18/2019	3	3	0	28	1	0	28	09/27/2018	18	10	8	250	1	0	250	2017-08-18	9	2	7	1	52	0	52	106	8	12	1	61466.00	1	2	518 E MARSHALL SWEET SPRINGS, MO 65351 (38.964728, -93.407384)	02/01/2020
729	729	501 ASSEMBLY LANE PAOLA, KS 66071	38.566718	-94.86132	0		175413	MEDICALODGES PAOLA	501 ASSEMBLY LANE	PAOLA	KS	66071	9132943345	600	Miami	For profit - Corporation	93	73.7	Medicare and Medicaid	false	MEDICALODGES INC	02/01/1997	false		false	false	false	Resident	Yes	2		2		4		4			2	3		4				1.39401	0.42651	0.58987	1.01639	2.4104	0.01133	1.49402	0.61171	0.29051	2.39624	1.93921	0.52429	0.76423	3.2256	02/27/2019	7	7	7	40	1	0	40	04/05/2018	3	3	0	28	1	0	28	2016-06-20	8	6	2	1	227	0	227	67.167	2	4	1	9750.00	1	2	501 ASSEMBLY LANE PAOLA, KS 66071 (38.566718, -94.86132)	02/01/2020
5484	5484	151 HILLSIDE AVE HARTFORD, CT 06106	41.748736	-72.698044	0		75268	TRINITY HILL CARE CENTER	151 HILLSIDE AVE	HARTFORD	CT	6106	8609511060	10	Hartford	For profit - Corporation	144	135.2	Medicare and Medicaid	false	TRINITY HILL CARE CENTER LLC	04/09/1976	false		false	false	false	Resident	Yes	2		2		2		2		2		3		3				2.06718	0.75559	0.43694	1.19253	3.25971	0.02363	1.53927	0.59512	0.28235	2.41675	2.79112	0.95469	0.58246	4.32514	01/09/2019	10	10	1	40	1	0	40	11/02/2017	17	6	17	100	1	0	100	2017-01-06	3	3	0	1	8	0	8	54.667	3	5	2	14446.00	0	2	151 HILLSIDE AVE HARTFORD, CT 06106 (41.748736, -72.698044)	02/01/2020
1839	1839	1211 NJ-72, Manahawkin, NJ 08050, USA	39.7215926	-74.29019079999999	1	ROOFTOP	315206	MANAHAWKIN CONV CTR	1211 RT 72 WEST	MANAHAWKIN	NJ	8050	6095978500	310	Ocean	For profit - Limited Liability company	120	81.2	Medicare and Medicaid	false	MR OF MANAHAWKIN LLC	06/06/1984	false		false	false	false	Resident	Yes	2		2		4		5		2		2		2				1.59773	0.97891	0.3211	1.30001	2.89774	0.06373	1.54293	0.60255	0.27797	2.42344	2.15215	1.22161	0.43479	3.83424	09/12/2019	2	1	1	8	0	0	8	08/16/2018	5	4	1	40	1	0	40	2017-06-30	5	4	5	1	32	0	32	22.667	0	11	2	12817.00	0	2		02/01/2020
1527	1527	900 3RD STREET SOUTH FRANKLIN, MN 55333	44.521213	-94.883988	0		245273	FRANKLIN REHABILITATION & HEALTHCARE CENTER	900 3RD STREET SOUTH	FRANKLIN	MN	55333	5075572211	640	Renville	For profit - Corporation	40	29.6	Medicare and Medicaid	false	FRANKLIN OPERATIONS LLC	03/01/1985	true		true	false	false	Resident	Yes	1		1		1		1			2	5		5				2.40924	0.52288	0.94118	1.46406	3.8733	0.18337	1.57369	0.58387	0.26688	2.42444	3.18183	0.6734	1.32736	5.12299	10/21/2019	18	14	10	152	0	0	152	11/02/2018	10	6	6	88	1	0	88	2017-12-08	10	10	0	1	44	0	44	112.667	7	10	0	0.00	2	2	900 3RD STREET SOUTH FRANKLIN, MN 55333 (44.521213, -94.883988)	02/01/2020
4701	4701	5002 LA-10, Jackson, LA 70748, USA	30.834003	-91.1849992	1	RANGE_INTERPOLATED	195150	VILLA FELICIANA CHRONIC DISEASE	5002 HIGHWAY 10	JACKSON	LA	70748	2256344000	180	East Feliciana	For profit - Corporation	297	156.7	Medicare and Medicaid	false	VILLA FELICIANA MEDICAL COMPLEX	01/01/1978	false		false	false	false	Resident	Yes	2		1		2		2			2	4		4				2.18978	0.98408	0.73201	1.71609	3.90587	0.02677	1.60565	0.60351	0.26805	2.47721	2.83443	1.22611	1.02785	5.05601	09/12/2019	0	0	0	0	0	0	0	08/23/2018	9	4	6	277	1	0	277	2017-08-10	0	0	0	0	0	0	0	92.333	7	5	2	29330.00	0	2		02/01/2020
5277	5277	610 PRIGGE ROAD SAINT LOUIS, MO 63138	38.77779	-90.182706	0		265776	ESTATES OF SPANISH LAKE, THE	610 PRIGGE ROAD	SAINT LOUIS	MO	63138	3147419393	940	St. Louis	For profit - Corporation	150	68.6	Medicare and Medicaid	false	THE ESTATES OF SPANISH LAKE, LLC	03/19/2004	false		false	false	false	Resident	Yes	1		1		4		4			2	1	12	1	12			2.45018	0.82068	0.07457	0.89525	3.34543	0	1.62904	0.59371	0.25967	2.48242	3.12595	1.0394	0.10808	4.32144	06/21/2019	20	20	4	132	1	0	132	06/26/2018	20	14	7	183	1	0	183	2017-06-30	17	17	3	1	128	0	128	148.333	5	11	0	0.00	2	2	610 PRIGGE ROAD SAINT LOUIS, MO 63138 (38.77779, -90.182706)	02/01/2020
11464	11464	890 US-20, Basin, WY 82410, USA	44.36584209999999	-108.0422587	1	ROOFTOP	535021	WYOMING RETIREMENT CENTER	890 US HWY 20 SOUTH	BASIN	WY	82410	3075682431	10	Big Horn	Government - State	90	70.5	Medicare and Medicaid	false	STATE OF WYOMING	09/12/1984	false		false	false	false	Resident	Yes	3		2		3		3			2	5		5				2.08772	0.40998	0.8377	1.24768	3.3354	0.00752	1.63144	0.58324	0.2692	2.48388	2.6596	0.52857	1.17124	4.30596	06/13/2019	7	6	1	32	1	0	32	04/26/2018	11	8	3	68	1	0	68	2017-05-11	11	11	0	2	88	44	132	60.667	1	0	1	3775.00	1	2		02/01/2020
711	711	301 WEST DUNLOP STREET CENTER, MO 63436	39.511528	-91.53223	0		265423	WESTVIEW NURSING HOME	301 WEST DUNLOP STREET	CENTER	MO	63436	5732673920	860	Ralls	For profit - Limited Liability company	60	55.8	Medicare and Medicaid	false	MMA HEALTHCARE OF CENTER, INC.	04/06/1990	false		false	false	false	Resident	Yes	1		1		3		5		2		1		1				1.38045	0.4668	0.16087	0.62768	2.00813	0	1.62759	0.59464	0.26225	2.48448	1.76276	0.59028	0.23089	2.59185	12/17/2019	17	15	2	144	0	0	144	02/27/2019	10	9	1	80	1	0	80	2017-12-08	11	11	0	1	44	0	44	106	3	2	1	6500.00	1	2	301 WEST DUNLOP STREET CENTER, MO 63436 (39.511528, -91.53223)	02/01/2020
5579	5579	552 GOLF LINKS ROAD HOT SPRINGS, AR 71901	34.472615	-93.04697	0		45098	HOT SPRINGS NURSING AND REHABILITATION- A WATERS C	552 GOLF LINKS ROAD	HOT SPRINGS	AR	71901	5016247149	250	Garland	For profit - Corporation	152	108.7	Medicare and Medicaid	false	HOT SPRINGS NURSING AND REHABILITATION-A WATERS COMMUNITY LLC	11/01/1984	false		false	false	false	Both	Yes	1		1		3		3		2		3		2				2.62978	0.77446	0.2445	1.01896	3.64873	0.00846	1.64465	0.59498	0.26668	2.50631	3.32325	0.97877	0.34507	4.66832	11/09/2018	11	4	7	179	1	0	179	10/13/2017	10	1	9	56	1	0	56	2016-11-04	23	5	18	1	156	0	156	134.167	3	17	2	76697.00	0	2	552 GOLF LINKS ROAD HOT SPRINGS, AR 71901 (34.472615, -93.04697)	02/01/2020
3768	3768	10 LAKE DRIVE BONNE TERRE, MO 63628	37.913804	-90.554169	0		265701	ST JOE MANOR	10 LAKE DRIVE	BONNE TERRE	MO	63628	5733582800	930	St. Francois	For profit - Individual	120	75.6	Medicare and Medicaid	false	ST JOE MANOR INC	11/12/1999	false		true	false	false	Resident	Yes	1		1		3		3			2	2		2				2.07251	0.56259	0.34762	0.91021	2.98272	0.04612	1.68029	0.57649	0.26523	2.52202	2.56346	0.73381	0.4933	3.79243	09/27/2019	18	11	7	210	1	0	210	11/30/2018	11	11	0	72	1	0	72	2017-09-29	6	3	3	1	52	0	52	137.667	0	4	1	26790.00	1	2	10 LAKE DRIVE BONNE TERRE, MO 63628 (37.913804, -90.554169)	02/01/2020
4588	4588	430 NORTH WEST STREET PERRYVILLE, MO 63775	37.730655	-89.864817	0		265704	ESTATES OF PERRYVILLE, LLC, THE	430 NORTH WEST STREET	PERRYVILLE	MO	63775	5735471011	780	Perry	For profit - Limited Liability company	156	86.8	Medicare and Medicaid	false	THE ESTATES OF PERRYVILLE LLC	03/14/2000	false		false	false	false	Resident	Yes	1		2		1		2		1		2		2				1.45743	0.43117	0.30493	0.7361	2.19353	0.01204	1.63524	0.61247	0.28254	2.53025	1.85235	0.52935	0.40622	2.77993	03/22/2019	18	18	0	56	1	0	56	01/11/2018	14	11	3	68	1	0	68	2017-02-16	13	9	4	1	151	0	151	75.833	1	8	1	17110.00	1	2	430 NORTH WEST STREET PERRYVILLE, MO 63775 (37.730655, -89.864817)	02/01/2020
360	360	4960 LACLEDE AVENUE SAINT LOUIS, MO 63108	38.640799	-90.264446	0		265378	ROYAL OAK NURSING & REHAB	4960 LACLEDE AVENUE	SAINT LOUIS	MO	63108	3143616240	950	St. Louis City	For profit - Corporation	168	98.6	Medicare and Medicaid	false	SIRO OP ROYAL OAK LLC	04/28/1989	false		false	false	true	Resident	Yes	1		1		3		5		2		3		3				1.9772	0.64107	0.43397	1.07504	3.05224	0.01176	1.6358	0.62315	0.27542	2.53437	2.5121	0.77357	0.59305	3.86191	08/14/2019	25	25	0	160	1	0	160	07/31/2018	25	23	2	176	1	0	176	2017-09-29	14	9	5	1	183	0	183	169.167	2	9	1	75370.00	1	2	4960 LACLEDE AVENUE SAINT LOUIS, MO 63108 (38.640799, -90.264446)	02/01/2020
773	773	99 MULFORD ROAD ANDOVER, NJ 07821	41.045705	-74.700256	0		315248	ANDOVER SUBACUTE AND REHAB II	99 MULFORD ROAD	ANDOVER	NJ	7821	9733836200	360	Sussex	For profit - Limited Liability company	543	504.4	Medicare and Medicaid	false	ALLIANCE HC 11 LLC	12/01/1987	false		false	false	false	Resident	Yes	1		1		3		4		3		2		2				2.09705	0.4962	0.2699	0.7661	2.86315	0.01042	1.69679	0.5889	0.24962	2.53532	2.5686	0.63358	0.40695	3.6213	03/01/2019	5	1	4	40	1	0	40	11/14/2017	5	2	3	107	1	0	107	2016-11-29	6	6	0	1	12	0	12	57.667	1	23	2	21578.00	0	2	99 MULFORD ROAD ANDOVER, NJ 07821 (41.045705, -74.700256)	02/01/2020
5296	5296	3002 NORTH 18TH ST SAINT JOSEPH, MO 64505	39.790246	-94.838969	0		265754	DIVERSICARE OF ST JOSEPH	3002 NORTH 18TH ST	SAINT JOSEPH	MO	64505	8163644200	100	Buchanan	For profit - Corporation	180	88.7	Medicare and Medicaid	false	DIVERSICARE OF ST. JOSEPH LLC	03/27/2003	false		false	false	false	Resident	Yes	2		2		2		3		2		3		3				2.03277	0.63995	0.42855	1.0685	3.10127	0.03039	1.63697	0.62705	0.29843	2.56246	2.58084	0.76741	0.54048	3.88092	06/20/2019	9	9	0	36	1	0	36	08/24/2018	3	2	1	28	1	0	28	2018-02-26	15	12	3	1	130	0	130	49	2	4	2	24638.00	0	2	3002 NORTH 18TH ST SAINT JOSEPH, MO 64505 (39.790246, -94.838969)	02/01/2020
281	281	1347 EAST VALLEY WATERMILL ROAD SPRINGFIELD, MO 65803	37.262253	-93.269739	0		265749	WOODLAND MANOR	1347 EAST VALLEY WATERMILL ROAD	SPRINGFIELD	MO	65803	4178331220	380	Greene	For profit - Corporation	180	82.8	Medicare and Medicaid	false	EBG HEALTH CARE III INC	12/27/2002	false		false	false	false	Resident	Yes	1		2		2		3		2		1	12	1	12			2.02448	0.9202	0.14374	1.06394	3.08842	0.03386	1.64637	0.63272	0.28903	2.56813	2.55565	1.09358	0.18719	3.85632	01/24/2019	4	4	0	40	1	0	40	03/26/2018	11	6	5	177	1	0	177	2017-03-03	8	3	5	1	56	0	56	88.333	4	4	1	20890.00	1	2	1347 EAST VALLEY WATERMILL ROAD SPRINGFIELD, MO 65803 (37.262253, -93.269739)	02/01/2020
2816	2816	78 VIETS ST EXTENSION NEW LONDON, CT 06320	41.338131	-72.11074	0		75196	HARBOR VILLAGE NORTH HEALTH AND REHABILITATION CEN	78 VIETS ST EXTENSION	NEW LONDON	CT	6320	8604471416	50	New London	For profit - Limited Liability company	128	122.5	Medicare and Medicaid	false	WV-CROSSINGS EAST LLC	09/01/1971	false		false	false	false	Resident	Yes	1		1		4		4		5		2		2				1.59893	0.79292	0.26103	1.05395	2.65287	0.0454	1.69541	0.61666	0.27917	2.59124	1.96006	0.96687	0.35192	3.28293	07/17/2019	12	12	4	56	1	0	56	05/11/2018	16	9	10	108	1	0	108	2017-05-25	14	9	10	1	108	0	108	82	8	4	2	27230.00	0	2	78 VIETS ST EXTENSION NEW LONDON, CT 06320 (41.338131, -72.11074)	02/01/2020
7555	7555	303 E BUFFALO ST GLASCO, KS 67445	39.362048	-97.837072	0		175473	THE NICOL HOME	303 E BUFFALO ST	GLASCO	KS	67445	7855682251	140	Cloud	Non profit - Corporation	32	28.6	Medicare and Medicaid	false	THE NICOL HOME, INC.	03/01/2004	false		false	false	false	Resident	Yes	2		2		2		2			2	3		2				3.23709	0.80566	0.30836	1.11402	4.35111	0.01834	1.68735	0.62682	0.28841	2.60257	3.98718	0.96649	0.40242	5.36105	05/28/2019	5	5	5	36	1	0	36	08/20/2018	14	12	3	187	1	0	187	2017-01-10	5	5	0	1	52	0	52	89	1	2	1	17010.00	1	2	303 E BUFFALO ST GLASCO, KS 67445 (39.362048, -97.837072)	02/01/2020
4254	4254	524 WARDELL ROAD TINTON FALLS, NJ 07753	40.223864	-74.09928	0		315414	WARDELL GARDENS AT TINTON FALLS	524 WARDELL ROAD	TINTON FALLS	NJ	7753	7329229330	290	Monmouth	For profit - Partnership	100	62.8	Medicare and Medicaid	false	TF HEALTHCARE LLC	07/10/1997	false		false	false	false	Resident	Yes	1		1		2		5		1		3		3				1.90101	0.86303	0.45614	1.31917	3.22019	0.09189	1.70709	0.62112	0.27442	2.60262	2.31444	1.04481	0.62563	3.96756	08/21/2019	7	7	0	40	1	0	40	10/19/2018	4	3	1	20	1	0	20	2017-06-30	15	14	1	1	96	0	96	42.667	0	9	2	19030.00	0	2	524 WARDELL ROAD TINTON FALLS, NJ 07753 (40.223864, -74.09928)	02/01/2020
6494	6494	1685 EATON ST LAKEWOOD, CO 80214	39.743673	-105.059049	0		65296	CAMBRIDGE CARE CENTER	1685 EATON ST	LAKEWOOD	CO	80214	3032324405	290	Jefferson	For profit - Corporation	100	90.5	Medicare and Medicaid	false	QL CAMBRIDGE CARE CENTER LLC	12/01/1991	false		false	false	false	Resident	Yes	4		3		2		2			2	4		4				1.72106	0.79518	0.6607	1.45589	3.17694	0.01435	1.64577	0.66252	0.29511	2.6034	2.17342	0.90251	0.84265	3.91311	07/24/2019	6	3	3	48	1	0	48	06/28/2018	2	2	0	40	1	0	40	2017-01-18	3	3	0	1	20	0	20	40.667	0	2	2	23950.00	0	2	1685 EATON ST LAKEWOOD, CO 80214 (39.743673, -105.059049)	02/01/2020
7709	7709	1313 SOUTH 25TH ST BETHANY, MO 64424	40.256602	-94.026919	0		265807	CRESTVIEW HOME	1313 SOUTH 25TH ST, PO BOX 430	BETHANY	MO	64424	6604253128	400	Harrison	For profit - Corporation	92	69.3	Medicare and Medicaid	false	N & R OF CRESTVIEW LLC	12/13/2006	false	SFF Candidate	false	false	false	Resident	Yes	1		1		4		4			2	3		3				2.02871	0.29902	0.37294	0.67196	2.70067	0.02972	1.71894	0.60913	0.27644	2.60451	2.45287	0.36913	0.50778	3.32506	05/23/2019	21	9	12	112	2	56	168	05/03/2018	18	10	8	242	3	169	411	2017-05-05	10	7	4	1	76	0	76	233.667	0	21	1	50567.00	1	2	1313 SOUTH 25TH ST BETHANY, MO 64424 (40.256602, -94.026919)	02/01/2020
3024	3024	15600 WOODS CHAPEL ROAD KANSAS CITY, MO 64139	38.983644	-94.398972	0		265850	SEASONS CARE CENTER	15600 WOODS CHAPEL ROAD	KANSAS CITY	MO	64139	8164784757	470	Jackson	For profit - Limited Liability company	78	74.9	Medicare and Medicaid	false	SEASONS CARE CENTER LLC	06/17/2014	false		true	false	false	None	Yes	1		1		3		3			2	1	12	1	12			2.52889	0.84363	0.13155	0.97518	3.50406	0.01204	1.78142	0.57922	0.25243	2.61307	2.95038	1.0952	0.19615	4.30005	06/28/2019	18	16	2	124	2	62	186	05/16/2018	9	8	1	52	1	0	52	2017-03-06	11	9	2	1	84	0	84	124.333	2	3	1	3711.00	1	2	15600 WOODS CHAPEL ROAD KANSAS CITY, MO 64139 (38.983644, -94.398972)	02/01/2020
13352	13352	205 NORTH LINCOLN AVENUE WAGONER, OK 74467	35.962929	-95.389577	0		375369	WAGONER HEALTH & REHAB	205 NORTH LINCOLN AVENUE	WAGONER	OK	74467	9184852203	720	Wagoner	For profit - Corporation	117	48.9	Medicare and Medicaid	false	WAGONER HEALTH & REHAB LLC	02/22/1999	false		false	false	false	Both	Yes	1		2		1		1		3		3		3				2.29839	0.52112	0.46404	0.98516	3.28355	0.00356	1.73273	0.61671	0.26785	2.61729	2.75682	0.6354	0.65206	4.02295	09/04/2019	10	10	0	80	1	0	80	10/09/2018	15	11	4	140	1	0	140	2017-07-19	10	3	7	1	76	0	76	99.333	0	3	1	6646.00	1	2	205 NORTH LINCOLN AVENUE WAGONER, OK 74467 (35.962929, -95.389577)	02/01/2020
6428	6428	5000 E SEVEN MILE RD DETROIT, MI 48234	42.433338	-83.053844	0		235372	THE BAY AT CRANBROOK HEALTH & REHABILITATION CTR	5000 E SEVEN MILE RD	DETROIT	MI	48234	3133662900	810	Wayne	For profit - Partnership	66	28.1	Medicare and Medicaid	false	THE BAY AT CRANBROOK HEALTH AND REHABILITATION CENTER, LLC	05/01/1978	false		false	false	false	Resident	Yes	1		2		3		3			2	1	12	1	12			1.73339	0.72132	0.33739	1.05871	2.7921	0	1.76603	0.59734	0.25934	2.62272	2.03992	0.908	0.48965	3.41375	06/20/2019	10	10	0	84	1	0	84	08/01/2018	15	10	6	84	1	0	84	2017-07-19	21	12	9	2	286	143	429	141.5	5	13	1	46745.00	1	2	5000 E SEVEN MILE RD DETROIT, MI 48234 (42.433338, -83.053844)	02/01/2020
4920	4920	1021 CARON ROAD ROCHELLE, IL 61068	41.930096	-89.054507	0		146152	ROCHELLE GARDENS CARE CENTER	1021 CARON ROAD	ROCHELLE	IL	61068	8155624047	790	Ogle	For profit - Individual	74	49.9	Medicare and Medicaid	false	PETERSEN HEALTH NETWORK, LLC	10/15/2011	false		false	false	false	Both	Yes	1		1		2		2			2	3		4				1.53294	0.15841	0.75972	0.91814	2.45108	0.00626	1.6113	0.71504	0.29714	2.62348	1.97726	0.16659	0.96234	2.99594	05/03/2019	19	16	3	116	1	0	116	06/12/2018	23	16	7	136	2	68	204	2017-07-27	11	6	5	1	135	0	135	148.5	1	7	1	69707.00	1	2	1021 CARON ROAD ROCHELLE, IL 61068 (41.930096, -89.054507)	02/01/2020
6162	6162	111 EAST STREET CLARENCE, MO 63437	39.742599	-92.253619	0		265599	CLARENCE CARE CENTER	111 EAST STREET	CLARENCE	MO	63437	6606992118	984	Shelby	Government - County	60	32.2	Medicare and Medicaid	false	CLARENCE NURSING HOME DISTRICT	11/18/1994	false		false	false	false	Resident	Yes	4		2		5		5		4		4		3				2.78125	0.59675	0.43309	1.02984	3.81109	0.02102	1.70607	0.62927	0.28919	2.62453	3.38813	0.71308	0.56367	4.65641	04/04/2019	6	6	0	56	1	0	56	06/05/2018	7	7	0	56	1	0	56	2017-05-18	6	4	2	1	103	0	103	63.833	2	0	1	9920.00	1	2	111 EAST STREET CLARENCE, MO 63437 (39.742599, -92.253619)	02/01/2020
12737	12737	1400 NORTH COLLEGE CORDELL, OK 73632	35.30336	-98.990328	0		375306	CORDELL CHRISTIAN HOME	1400 NORTH COLLEGE	CORDELL	OK	73632	5808323371	740	Washita	Non profit - Corporation	110	52.8	Medicare and Medicaid	false	CORDELL CHRISTIAN HOME INCORPORATED	07/01/1997	false		false	false	false	Resident	Yes	3		3		3		3			2	3		1				2.98226	0.43234	0.21584	0.64819	3.63044	0.00638	1.76972	0.59288	0.26509	2.62768	3.50233	0.54833	0.30647	4.43036	12/12/2019	3	3	0	24	0	0	24	11/01/2018	5	5	0	40	1	0	40	2017-09-19	12	8	4	1	189	0	189	56.833	0	2	2	51493.00	0	2	1400 NORTH COLLEGE CORDELL, OK 73632 (35.30336, -98.990328)	02/01/2020
7621	7621	289 ELM STREET EVERETT, MA 02149	42.415154	-71.034913	0		225300	REHABILITATION & NURSING CENTER AT EVERETT (THE)	289 ELM STREET	EVERETT	MA	2149	6173876560	90	Middlesex	For profit - Corporation	183	119.8	Medicare and Medicaid	false	ERNC OPERATING LLC	04/10/1987	false		false	false	false	Resident	Yes	1		1		3		4		2		3		3				1.57548	0.97526	0.46573	1.44099	3.01647	0.01343	1.74463	0.61168	0.27907	2.63538	1.87683	1.19888	0.62814	3.67035	12/10/2018	14	14	0	80	1	0	80	09/15/2017	21	21	0	156	2	78	234	2016-09-15	10	8	2	1	199	0	199	151.167	2	0	1	108940.00	1	2	289 ELM STREET EVERETT, MA 02149 (42.415154, -71.034913)	02/01/2020
2117	2117	3612 BAKER BLVD BAKER, LA 70714	30.594064	-91.159561	0		195561	NORTHRIDGE CARE CENTER	3612 BAKER BLVD	BAKER	LA	70714	2257780573	160	E. Baton Rouge	For profit - Corporation	132	91.4	Medicare and Medicaid	false	NORTHRIDGE CARE CENTER LLC	06/23/2002	false		false	false	false	Both	Yes	1		1		2		5		1		2		1				2.06782	1.03735	0.15143	1.18878	3.2566	0.05098	1.71433	0.63539	0.29316	2.64288	2.50689	1.22764	0.19442	3.95131	07/25/2019	4	1	3	137	1	0	137	07/26/2018	2	2	0	12	1	0	12	2017-06-29	9	8	1	1	72	0	72	84.5	0	2	1	7296.00	1	2	3612 BAKER BLVD BAKER, LA 70714 (30.594064, -91.159561)	02/01/2020
4042	4042	438 12TH STREET PAWNEE CITY, NE 68420	40.114662	-96.15601	0		285157	PREMIER ESTATES OF PAWNEE, LLC	P O BOX 513, 438 12TH STREET	PAWNEE CITY	NE	68420	4028522975	660	Pawnee	For profit - Corporation	64	33.4	Medicare and Medicaid	false	PREMIER ESTATES OF PAWNEE, LLC	11/01/1994	false		false	false	false	Resident	Yes	2		1		2		2			2	4		4				1.93922	0.44161	0.62922	1.07082	3.01004	0.01688	1.72253	0.62753	0.29496	2.64502	2.33978	0.52916	0.8029	3.64919	09/16/2019	32	23	9	312	1	0	312	05/14/2018	3	2	2	32	1	0	32	2017-05-11	4	4	3	1	44	0	44	174	2	9	1	8957.00	1	2	438 12TH STREET PAWNEE CITY, NE 68420 (40.114662, -96.15601)	02/01/2020
4041	4041	1201 S POLK MAYSVILLE, MO 64469	39.881229	-94.359306	0		265745	SUNSET HOME	1201 S. POLK	MAYSVILLE	MO	64469	8164492158	310	De Kalb	For profit - Corporation	60	55.2	Medicare and Medicaid	false	N & R OF MAYSVILLE, LLC	12/01/2002	false		false	false	false	Resident	Yes	2		1		5		3		5		2		2				1.42289	0.57177	0.36496	0.93673	2.35961	0.02063	1.73219	0.62387	0.29015	2.64621	1.70722	0.68914	0.47343	2.85937	11/08/2019	12	12	0	68	1	0	68	02/22/2019	18	18	0	112	1	0	112	2017-12-20	13	10	3	1	151	0	151	96.5	1	3	1	13909.00	1	2	1201 S POLK MAYSVILLE, MO 64469 (39.881229, -94.359306)	02/01/2020
2828	2828	11900 JESSICA LANE RAYTOWN, MO 64138	38.976689	-94.442726	0		265425	EDGEWOOD MANOR CENTER FOR REHAB AND HEALTHCARE	11900 JESSICA LANE	RAYTOWN	MO	64138	8163587858	470	Jackson	For profit - Limited Liability company	66	44.3	Medicare and Medicaid	false	EDGEWOOD MANOR OPCO LLC	04/12/1990	false	SFF Candidate	false	false	false	Resident	Yes	1		1		2		3		2		1	12	1	12			2.36105	1.10075	0.11215	1.2129	3.57395	0.02849	1.72908	0.63119	0.29263	2.6529	2.83796	1.31133	0.14425	4.31997	02/01/2019	20	19	1	269	1	0	269	12/11/2017	14	12	2	72	1	0	72	2016-09-20	23	21	2	1	164	0	164	185.833	3	7	0	0.00	2	2	11900 JESSICA LANE RAYTOWN, MO 64138 (38.976689, -94.442726)	02/01/2020
15161	15161	992 S Broadway St, Truth or Consequences, NM 87901, USA	33.1210549	-107.2616807	1	ROOFTOP	325092	NEW MEXICO STATE VETERANS HOME	992 SOUTH BROADWAY	TRUTH OR CONSEQUENCE	NM	87901	5758944200	250	Sierra	Government - State	135	99.8	Medicare and Medicaid	false	STATE OF NEW MEXICO	01/25/1994	false		false	false	false	Both	Yes	4		4		1		1			2	5		5				3.76133	0.51602	0.8963	1.41232	5.17365	0.04791	1.7827	0.60593	0.26641	2.65505	4.38509	0.64037	1.26627	6.24853	09/17/2018	0	0	0	0	1	0	0	07/07/2017	16	7	9	215	1	0	215	2016-04-25	7	7	0	1	52	0	52	80.333	1	1	1	85400.00	1	2		02/01/2020
7933	7933	2963 DODDRIDGE AVENUE MARYLAND HEIGHTS, MO 63043	38.728219	-90.434274	0		265486	STONEBRIDGE MARYLAND HEIGHTS	2963 DODDRIDGE AVENUE	MARYLAND HEIGHTS	MO	63043	3142914557	940	St. Louis	For profit - Corporation	223	183.2	Medicare and Medicaid	false	BROOK VIEW NURSING HOME, INC.	02/10/1992	false		true	false	false	Resident	Yes	1		1		2		2		3		2		2				1.67754	0.91388	0.28104	1.19492	2.87247	0.02686	1.7486	0.62693	0.28375	2.65927	1.99389	1.09612	0.37279	3.46374	10/29/2018	22	14	11	160	1	0	160	08/17/2017	12	10	3	72	1	0	72	2016-09-23	7	7	0	1	76	0	76	116.667	4	9	2	48149.00	0	2	2963 DODDRIDGE AVENUE MARYLAND HEIGHTS, MO 63043 (38.728219, -90.434274)	02/01/2020
14015	14015	3400 KNIGHTON ROAD REDDING, CA 96002	40.506978	-122.312388	0		555891	VETERANS HOME OF CALIFORNIA - REDDING	3400 KNIGHTON ROAD	REDDING	CA	96002	5302243300	550	Shasta	Government - State	60	56.7	Medicare and Medicaid	false	DEPARTMENT OF VETERANS AFFAIRS OF THE STATE OF CALIFORNIA	04/29/2015	true		false	false	false	Both	Yes	5		4		4		4			2	5		5				3.42748	0.80355	1.92906	2.7326	6.16009	0.12658	1.77817	0.61209	0.27785	2.66811	4.00607	0.98714	2.61314	7.40348	05/16/2019	10	7	3	48	1	0	48	05/18/2018	2	2	0	8	1	0	8	2017-05-19	5	3	2	1	56	0	56	36	5	1	2	14097.00	0	2	3400 KNIGHTON ROAD REDDING, CA 96002 (40.506978, -122.312388)	02/01/2020
14554	14554	2461 SIDNEY ROAD WALTERBORO, SC 29488	32.949562	-80.612836	0		425386	VETERANS VICTORY HOUSE	2461 SIDNEY ROAD	WALTERBORO	SC	29488	8435383000	140	Colleton	Government - State	220	214.3	Medicare and Medicaid	false	SOUTH CAROLINA DEPT OF MENTAL HEALTH ACCOUNTING OFFICE	10/03/2007	false	SFF Candidate	true	false	false	Both	Yes	2		1		5		5			2	4		4				2.61741	0.9092	0.54051	1.44971	4.06712	0.02195	1.83043	0.59088	0.24755	2.66886	2.97189	1.15704	0.82181	4.88668	05/31/2019	7	2	5	104	1	0	104	03/02/2018	10	3	7	848	1	0	848	2016-11-17	4	4	0	1	20	0	20	338	19	0	1	260746.00	1	2	2461 SIDNEY ROAD WALTERBORO, SC 29488 (32.949562, -80.612836)	02/01/2020
1030	1030	1410 WEST LINE STREET PALMYRA, MO 63461	39.787768	-91.527847	0		265237	MAPLE LAWN NURSING HOME	1410 WEST LINE STREET, PO BOX 232	PALMYRA	MO	63461	5737692213	630	Marion	Government - County	110	71	Medicare and Medicaid	false	MARION CO. NURSING HOME DISTRICT	05/09/1984	false		false	false	false	Resident	Yes	2		2		4		5		4		2		2				1.91408	1.0006	0.37931	1.37991	3.29399	0.00983	1.7737	0.614	0.29146	2.67916	2.24283	1.2254	0.48982	3.94255	12/04/2018	5	5	1	119	1	0	119	02/26/2018	2	2	0	16	1	0	16	2016-12-07	8	7	1	1	76	0	76	77.5	1	1	1	28532.00	1	2	1410 WEST LINE STREET PALMYRA, MO 63461 (39.787768, -91.527847)	02/01/2020
3585	3585	464 E GRAND BLVD DETROIT, MI 48207	42.356104	-83.007775	0		235242	BOULEVARD MANOR, LLC	464 E GRAND BLVD	DETROIT	MI	48207	3135792255	810	Wayne	For profit - Individual	87	70.3	Medicare and Medicaid	false	BOULEVARD MANOR LLC	01/01/1976	false		false	false	false	Resident	Yes	1		1		3		4		2		2		2				1.69691	0.88604	0.24565	1.13168	2.82859	0.01918	1.75467	0.64239	0.28515	2.68221	2.00992	1.03714	0.32424	3.38166	12/12/2019	19	17	2	188	0	0	188	02/12/2019	18	12	6	152	1	0	152	2018-04-19	21	12	9	1	267	0	267	189.167	2	16	2	31160.00	0	2	464 E GRAND BLVD DETROIT, MI 48207 (42.356104, -83.007775)	02/01/2020
13417	13417	1111 Ln 12, Lovell, WY 82431, USA	44.8257945	-108.3906688	1	RANGE_INTERPOLATED	535030	NEW HORIZONS CARE CENTER	1111 LANE 12	LOVELL	WY	82431	3075485200	10	Big Horn	For profit - Corporation	85	69.2	Medicare and Medicaid	true	NORTH BIG HORN HOSPITAL	01/13/1988	false	SFF Candidate	true	false	false	Both	Yes	3		2		4		4			2	4		4				2.36082	0.55502	0.51573	1.07075	3.43157	0.00216	1.8243	0.60272	0.25791	2.68493	2.68956	0.69243	0.75265	4.09839	06/27/2019	12	11	1	84	1	0	84	05/17/2018	7	7	0	44	1	0	44	2017-04-06	19	15	4	1	116	0	116	76	1	4	2	114614.00	0	2		02/01/2020
6903	6903	710 N CHRISTIAN AVENUE MOUNDRIDGE, KS 67107	38.209918	-97.519081	0		175553	MOUNDRIDGE MANOR	710 N CHRISTIAN AVENUE	MOUNDRIDGE	KS	67107	6203456364	560	Mcpherson	Non profit - Church related	78	74	Medicare and Medicaid	false	MOUNDRIDGE MANOR INC	12/23/2015	true		false	false	false	Resident	Yes	5		5		5		5			2	4		4				3.5436	0.55437	0.59189	1.14626	4.68985	0.00993	1.78598	0.62596	0.27428	2.68622	4.12367	0.66594	0.81222	5.59849	06/20/2019	0	0	0	0	0	0	0	09/27/2018	0	0	0	0	0	0	0	2017-03-06	0	0	0	0	0	0	0	0	0	0	1	23862.00	1	2	710 N CHRISTIAN AVENUE MOUNDRIDGE, KS 67107 (38.209918, -97.519081)	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
);