nh_gen_info_geocoded_final

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

37 rows where Health Inspection Rating = 2 and Rating Cycle 2 Number of Complaint Health Deficiencies = 11

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, nmbr_beds, Abuse Icon, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing 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 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Health Revisit Score, Rating Cycle 3 Total Health Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, Rating Cycle 3 Standard Health Survey Date (date)

Link rowid ▼ address lat lng geocode_flag geocode_accuracy prvdr_nmbr prvdr_nm prvdr_add prvdr_city prvdr_state prvdr_zip prvdr_phn prvdr_cnty prvdr_cnty_name ownership nmbr_beds avg_residents prvdr_type Provider Resides in Hospital Legal Business Name Date First Approved to Provide Medicare and Medicaid services Continuing Care Retirement Community Special Focus Status Abuse Icon Most Recent Health Inspection More Than 2 Years Ago Provider Changed Ownership in Last 12 Months With a Resident and Family Council Automatic Sprinkler Systems in All Required Areas Overall Rating Overall Rating Footnote Health Inspection Rating Health Inspection Rating Footnote QM Rating QM Rating Footnote Long-Stay QM Rating Long-Stay QM Rating Footnote Short-Stay QM Rating Short-Stay QM Rating Footnote Staffing Rating Staffing Rating Footnote RN Staffing Rating RN Staffing Rating Footnote Reported Staffing Footnote Physical Therapist Staffing Footnote Reported Nurse Aide Staffing Hours per Resident per Day Reported LPN Staffing Hours per Resident per Day Reported RN Staffing Hours per Resident per Day Reported Licensed Staffing Hours per Resident per Day Reported Total Nurse Staffing Hours per Resident per Day Reported Physical Therapist Staffing Hours per Resident Per Day Case-Mix Nurse Aide Staffing Hours per Resident per Day Case-Mix LPN Staffing Hours per Resident per Day Case-Mix RN Staffing Hours per Resident per Day Case-Mix Total Nurse Staffing Hours per Resident per Day Adjusted Nurse Aide Staffing Hours per Resident per Day Adjusted LPN Staffing Hours per Resident per Day Adjusted RN Staffing Hours per Resident per Day Adjusted Total Nurse Staffing Hours per Resident per Day Rating Cycle 1 Standard Survey Health Date Rating Cycle 1 Total Number of Health Deficiencies Rating Cycle 1 Number of Standard Health Deficiencies Rating Cycle 1 Number of Complaint Health Deficiencies Rating Cycle 1 Health Deficiency Score Rating Cycle 1 Number of Health Revisits Rating Cycle 1 Health Revisit Score Rating Cycle 1 Total Health Score Rating Cycle 2 Standard Health Survey Date Rating Cycle 2 Total Number of Health Deficiencies Rating Cycle 2 Number of Standard Health Deficiencies Rating Cycle 2 Number of Complaint Health Deficiencies Rating Cycle 2 Health Deficiency Score Rating Cycle 2 Number of Health Revisits Rating Cycle 2 Health Revisit Score Rating Cycle 2 Total Health Score Rating Cycle 3 Standard Health Survey Date Rating Cycle 3 Total Number of Health Deficiencies Rating Cycle 3 Number of Standard Health Deficiencies Rating Cycle 3 Number of Complaint Health Deficiencies Rating Cycle 3 Number of Health Revisits Rating Cycle 3 Health Deficiency Score Rating Cycle 3 Health Revisit Score Rating Cycle 3 Total Health Score Total Weighted Health Survey Score Number of Facility Reported Incidents Number of Substantiated Complaints Number of Fines Total Amount of Fines in Dollars Number of Payment Denials Total Number of Penalties Location Processing Date
143 143 4904 WAR ADMIRAL DRIVE INDIANAPOLIS, IN 46237 39.64103 -86.08272 0   155823 SOUTHPOINTE HEALTHCARE CENTER 4904 WAR ADMIRAL DRIVE INDIANAPOLIS IN 46237 3178853333 480 Marion Government - County 100 90.4 Medicare and Medicaid false HANCOCK REGIONAL HOSPITAL 08/26/2014 false   false false false Resident Yes 3   2   5   5   5   3   3       1.99279 0.9529 0.79353 1.74642 3.73921 0.24996 2.2959 0.94351 0.54366 3.78307 1.80395 0.75942 0.54937 3.16948 01/22/2019 17 13 4 64 1 0 64 12/20/2017 13 2 11 84 1 0 84 2016-11-01 2 0 2 0 24 0 24 64 0 20 2 17350.00 0 2 4904 WAR ADMIRAL DRIVE INDIANAPOLIS, IN 46237 (39.64103, -86.08272) 02/01/2020
213 213 1919 QUENTIN ST AURORA, CO 80045 39.745983 -104.844679 0   65380 COLORADO STATE VETERANS HOME AT FITZSIMONS 1919 QUENTIN ST AURORA CO 80045 7208576400 0 Adams Government - State 180 151.5 Medicare and Medicaid false STATE OF COLORADO 03/01/2003 false   false false false Resident Yes 3   2   4   3   4   5   5       2.73786 0.80872 1.14542 1.95414 4.692 0.03751 1.91768 0.64514 0.27821 2.84104 2.96722 0.94261 1.54959 5.29583 01/24/2019 15 11 4 80 1 0 80 05/25/2017 24 13 11 148 1 0 148 2016-05-11 5 4 1 1 20 0 20 92.667 3 13 0 0.00 1 1 1919 QUENTIN ST AURORA, CO 80045 (39.745983, -104.844679) 02/01/2020
411 411 2299 NORTH INDIAN CANYON DRIVE PALM SPRINGS, CA 92262 33.850151 -116.545581 0   56428 CALIFORNIA NURSING & REHABILITATION CENTER 2299 NORTH INDIAN CANYON DRIVE PALM SPRINGS CA 92262 7603252937 430 Riverside For profit - Partnership 80 64.9 Medicare and Medicaid false CNRC, LLC 02/01/1978 false   false false false Resident Yes 2   2   3   5   1   3   3       2.16833 1.18512 0.58689 1.77201 3.94034 0.07769 2.03659 0.75883 0.3694 3.16481 2.21278 1.17436 0.59799 3.99244 06/13/2019 17 13 4 88 1 0 88 06/14/2018 30 19 11 124 1 0 124 2017-06-08 24 16 9 1 140 0 140 108.667 3 10 0 0.00 0 0 2299 NORTH INDIAN CANYON DRIVE PALM SPRINGS, CA 92262 (33.850151, -116.545581) 02/01/2020
675 675 7991 W 71ST AVE ARVADA, CO 80004 39.8263 -105.082666 0   65330 ARBOR VIEW 7991 W 71ST AVE ARVADA CO 80004 3034033100 290 Jefferson For profit - Corporation 120 105.2 Medicare and Medicaid false HACKBERRY HILL OPCO LLC 09/26/1994 false   false false false Resident Yes 3   2   4   4     2 4   4       2.2825 0.7052 0.65969 1.3649 3.6474 0.0392 2.10238 0.67346 0.29596 3.0718 2.2564 0.78738 0.83895 3.80753 03/05/2019 10 8 2 56 1 0 56 11/16/2017 11 6 11 80 1 0 80 2016-09-01 7 7 0 1 36 0 36 60.667 0 12 1 18856.00 0 1 7991 W 71ST AVE ARVADA, CO 80004 (39.8263, -105.082666) 02/01/2020
1297 1297 350 NORTH VILLA STREET PORTERVILLE, CA 93257 36.072328 -119.030618 0   55551 SEQUOIA TRANSITIONAL CARE 350 NORTH VILLA STREET PORTERVILLE CA 93257 5597846644 640 Tulare For profit - Corporation 99 94.5 Medicare and Medicaid false SUN VILLAIDENCE OPCO, LLC 02/01/1978 false   false false false Resident Yes 3   2   5   5   2   2   1       2.52669 0.95898 0.11985 1.07883 3.60552 0.17195 2.03247 0.70362 0.32134 3.05743 2.58371 1.02484 0.14038 3.7815 01/30/2019 9 7 2 48 1 0 48 01/11/2018 23 12 11 100 1 0 100 2017-01-06 19 14 5 2 104 52 156 83.333 5 18 0 0.00 0 0 350 NORTH VILLA STREET PORTERVILLE, CA 93257 (36.072328, -119.030618) 02/01/2020
2005 2005 9020 GARFIELD STREET RIVERSIDE, CA 92503 33.928554 -117.440269 0   55042 ALTA VISTA HEALTHCARE & WELLNESS CENTRE 9020 GARFIELD STREET RIVERSIDE CA 92503 9516888200 430 Riverside For profit - Corporation 99 92.9 Medicare and Medicaid false RIVERSIDE HEALTHCARE & WELLNESS CENTRE LLC 01/01/1973 false   false false false Resident Yes 2   2   4   5   2   3   3       2.42637 1.00398 0.50585 1.50983 3.9362 0.13051 2.14362 0.77435 0.36387 3.28183 2.35248 0.97493 0.52326 3.84605 09/06/2019 19 14 6 96 1 0 96 09/27/2018 25 14 11 100 1 0 100 2017-09-21 18 9 10 1 92 0 92 96.667 14 9 1 8775.00 0 1 9020 GARFIELD STREET RIVERSIDE, CA 92503 (33.928554, -117.440269) 02/01/2020
2140 2140 900 ELMHURST BLVD SALINA, KS 67401 38.829973 -97.596572 0   175200 KENWOOD VIEW HEALTH AND REHABILITATION CENTER 900 ELMHURST BLVD SALINA KS 67401 7858255471 840 Saline For profit - Partnership 82 62.7 Medicare and Medicaid false ELMHURST OPERATIONS LLC 02/01/1991 false   false false false Both Yes 3   2   3   4   2   4   5       2.2179 0.54866 1.10935 1.65801 3.87591 0.03966 2.00766 0.76006 0.3673 3.13502 2.29598 0.54279 1.13678 3.96448 01/29/2019 16 13 16 124 1 0 124 10/17/2017 11 7 11 56 1 0 56 2016-02-29 8 8 0 1 32 0 32 86 1 9 1 11278.00 0 1 900 ELMHURST BLVD SALINA, KS 67401 (38.829973, -97.596572) 02/01/2020
2925 2925 7200 NORTH SHERIDAN ROAD CHICAGO, IL 60626 42.013194 -87.663674 0   145244 MOSAIC OF LAKESHORE, THE 7200 NORTH SHERIDAN ROAD CHICAGO IL 60626 7739737200 141 Cook For profit - Individual 313 230.8 Medicare and Medicaid false LAKE SHORE HEALTHCARE & REHABILITATION CENTRE LLC 05/12/1972 false   false false false Resident Yes 1   2   3   4   2   1   1       1.96847 0.96396 0.30876 1.27271 3.24118 0 2.39076 0.83691 0.44903 3.67669 1.71123 0.86609 0.25881 2.82682 11/07/2019 7 0 7 48 1 0 48 10/18/2018 20 12 11 164 1 0 164 2017-12-15 12 4 8 1 72 0 72 90.667 1 38 0 0.00 0 0 7200 NORTH SHERIDAN ROAD CHICAGO, IL 60626 (42.013194, -87.663674) 02/01/2020
2983 2983 2050 CHESTER BLVD RICHMOND, IN 47374 39.861691 -84.88873 0   155230 ROSEBUD VILLAGE 2050 CHESTER BLVD RICHMOND IN 47374 7659354440 880 Wayne For profit - Corporation 110 93.6 Medicare and Medicaid false THE HEALTH AND HOSPITAL CORPORATION OF MARION COUNTY 03/15/1984 false   false false false Resident Yes 2   2   4   4   5   3   3       2.11975 0.78929 0.67644 1.46573 3.58548 0.06941 2.20675 0.7924 0.40022 3.39938 1.9964 0.74899 0.63614 3.38222 04/17/2019 10 10 0 44 1 0 44 03/06/2018 13 5 11 56 1 0 56 2017-02-24 22 12 12 1 104 0 104 58 0 33 0 0.00 0 0 2050 CHESTER BLVD RICHMOND, IN 47374 (39.861691, -84.88873) 02/01/2020
3420 3420 18200 W 13 MILE ROAD BEVERLY HILLS, MI 48025 42.517032 -83.224915 0   235664 CAMBRIDGE SOUTH HEALTHCARE CTR 18200 W 13 MILE ROAD BEVERLY HILLS MI 48025 2486476500 620 Oakland For profit - Corporation 96 72.1 Medicare and Medicaid false SSC BEVERLY HILLS OPERATING COMPANY LLC 05/10/2013 false   false false false Both Yes 2   2   3   4   2   3   3       2.07218 1.1794 0.45078 1.63019 3.70237 0.12006 2.02114 0.70412 0.31549 3.04075 2.13083 1.2595 0.53778 3.90438 05/15/2019 23 20 4 136 1 0 136 04/25/2018 29 18 11 164 1 0 164 2017-03-23 26 16 11 1 180 0 180 152.667 8 25 1 11375.00 0 1 18200 W 13 MILE ROAD BEVERLY HILLS, MI 48025 (42.517032, -83.224915) 02/01/2020
4326 4326 527 MEMORIAL DRIVE POCATELLO, ID 83201 42.868832 -112.431284 0   135011 GATEWAY TRANSITIONAL CARE CENTER 527 MEMORIAL DRIVE POCATELLO ID 83201 2084783333 20 Bannock For profit - Limited Liability company 88 77.5 Medicare and Medicaid false POCATELLO HEALTH SERVICES, INC. 01/01/1967 false   false false false Resident Yes 3   2   4   5   4   4   4       2.11326 1.02301 0.89298 1.91599 4.02925 0.2914 2.08961 0.81574 0.41201 3.31736 2.10187 0.943 0.81576 3.8948 04/12/2019 12 7 8 72 1 0 72 10/13/2017 23 12 11 170 2 85 255 2016-06-24 3 3 0 1 12 0 12 123 0 11 1 42339.00 0 1 527 MEMORIAL DRIVE POCATELLO, ID 83201 (42.868832, -112.431284) 02/01/2020
5216 5216 1001 SOUTH STATE STREET JERSEYVILLE, IL 62052 39.108823 -90.318474 0   145465 JERSEYVILLE NSG & REHAB CENTER 1001 SOUTH STATE STREET JERSEYVILLE IL 62052 6184986496 500 Jersey For profit - Corporation 111 76.4 Medicare and Medicaid false HELIA HEALTHCARE OF JERSEYVILLE LLC 06/01/1983 false   false false false Resident Yes 3   2   5   4   5   3   3       2.14977 0.61836 0.51619 1.13455 3.28431 0.02008 2.23273 0.74622 0.32526 3.30421 2.00111 0.6231 0.59732 3.18735 01/14/2019 7 7 5 28 1 0 28 03/26/2018 16 8 11 124 1 0 124 2017-02-14 12 8 4 1 84 0 84 69.333 0 15 3 41477.00 0 3 1001 SOUTH STATE STREET JERSEYVILLE, IL 62052 (39.108823, -90.318474) 02/01/2020
5356 5356 624 PINEWOOD AVENUE SEWARD, NE 68434 40.923357 -97.099808 0   285279 RIDGEWOOD REHABILITATION & CARE CENTER 624 PINEWOOD AVENUE SEWARD NE 68434 4026432902 790 Seward Non profit - Corporation 82 69.4 Medicare and Medicaid false VSL SEWARD LLC 02/01/2009 false   false false false Resident Yes 3   2   3   5   2   5   5       2.96021 0.58109 0.8853 1.4664 4.42661 0.03044 2.0262 0.6797 0.30631 3.01221 3.03639 0.64286 1.08782 4.71237 09/12/2019 7 7 0 40 1 0 40 06/05/2018 11 11 11 72 2 36 108 2017-05-04 3 3 1 1 12 0 12 58 7 0 0 0.00 0 0 624 PINEWOOD AVENUE SEWARD, NE 68434 (40.923357, -97.099808) 02/01/2020
6736 6736 714 S EICKHOFF RD EVANSVILLE, IN 47712 37.970849 -87.676811 0   155785 WEST RIVER HEALTH CAMPUS 714 S EICKHOFF RD EVANSVILLE IN 47712 8129859878 810 Vanderburgh Non profit - Corporation 61 51 Medicare and Medicaid false GOOD SAMARITAN HOSPITAL 02/07/2011 false   false false false Resident Yes 3   2   5   5   5   3   4       1.84099 0.77214 1.0124 1.78454 3.62553 0.11307 2.3212 0.83462 0.38336 3.53919 1.64837 0.69565 0.99397 3.2849 10/17/2018 11 5 6 48 1 0 48 10/05/2017 11 10 11 60 1 0 60 2016-09-29 10 10 0 1 44 0 44 51.333 0 10 0 0.00 0 0 714 S EICKHOFF RD EVANSVILLE, IN 47712 (37.970849, -87.676811) 02/01/2020
6922 6922 8444 ENGLEMAN CENTER LINE, MI 48015 42.481187 -83.020825 0   235298 FATHER MURRAY, A VILLA CENTER 8444 ENGLEMAN CENTER LINE MI 48015 5867552400 490 Macomb For profit - Limited Liability company 231 205.1 Medicare and Medicaid false FATHER MURRAY NURSING AND REHABILITATION CENTRE 05/01/1976 false   true false false Resident Yes 2   2   4   3   4   2   2       1.87583 1.28266 0.2809 1.56357 3.4394 0.03894 1.96048 0.6902 0.30404 2.95471 1.9886 1.39741 0.34775 3.73268 07/31/2019 29 18 12 208 1 0 208 06/22/2018 17 11 11 104 1 0 104 2017-04-12 16 11 9 1 108 0 108 156.667 7 55 0 0.00 0 0 8444 ENGLEMAN CENTER LINE, MI 48015 (42.481187, -83.020825) 02/01/2020
7060 7060 300 EAST HORNBECK STREET SENATH, MO 63876 36.126758 -90.154429 0   265832 SENATH SOUTH HEALTH CARE CENTER 300 EAST HORNBECK STREET, PO BOX 940 SENATH MO 63876 5737382627 340 Dunklin For profit - Limited Liability company 30 24.2 Medicare and Medicaid false SENATH SOUTH HEALTH CARE CENTER LLC 01/25/2010 false   false false false Resident Yes 3   2   5   5     2   2   2 6 6                             10/30/2019 13 12 1 48 1 0 48 12/12/2018 18 7 11 144 1 0 144 2017-11-02 7 5 2 1 28 0 28 76.667 1 9 1 11050.00 0 1 300 EAST HORNBECK STREET SENATH, MO 63876 (36.126758, -90.154429) 02/01/2020
7249 7249 3919 WEST FOSTER AVENUE CHICAGO, IL 60625 41.975505 -87.726353 0   145775 HARMONY NURSING & REHAB CENTER 3919 WEST FOSTER AVENUE CHICAGO IL 60625 7735889500 141 Cook For profit - Corporation 180 155.3 Medicare and Medicaid false HARMONY NURSING & REHABILITATION CENTER INC 02/15/1994 false   false false false Both Yes 2   2   3   3   3   2   3       2.09211 0.77786 0.52195 1.29981 3.39192 0.05332 2.49273 0.79313 0.34979 3.63564 1.74432 0.73747 0.56163 2.9917 08/30/2019 16 5 12 92 1 0 92 10/04/2018 13 4 11 52 1 0 52 2017-09-22 14 10 5 1 88 0 88 78 3 43 1 2013.00 0 1 3919 WEST FOSTER AVENUE CHICAGO, IL 60625 (41.975505, -87.726353) 02/01/2020
7348 7348 725 Fuller Ave, Big Rapids, MI 49307, USA 43.6908189 -85.4928619 1 ROOFTOP 235312 METRON OF BIG RAPIDS 725 W FULLER BIG RAPIDS MI 49307 2317962631 530 Mecosta For profit - Corporation 78 66.2 Medicare and Medicaid false GREENRIDGE NURSING CENTER, INC 05/01/1978 false   true false false Both Yes 3   2   3   3   3   4   5       2.3812 0.39639 0.95139 1.34778 3.72898 0.05173 2.04361 0.65378 0.29583 2.99322 2.42166 0.4559 1.21046 3.99489 05/17/2019 18 17 1 104 1 0 104 06/07/2018 26 15 11 164 1 0 164 2017-05-05 20 11 9 1 128 0 128 128 31 13 2 26000.00 0 2   02/01/2020
8110 8110 9025 COLORADO AVENUE RIVERSIDE, CA 92503 33.937871 -117.447787 0   56315 CYPRESS GARDENS CARE CENTER 9025 COLORADO AVENUE RIVERSIDE CA 92503 9516883643 430 Riverside For profit - Limited Liability company 120 98.9 Medicare and Medicaid false 9025 COLORADO AVENUE LLC 11/01/1971 false   false false false Resident Yes 2   2   3   5   1   3   2       2.68715 1.04063 0.31519 1.35582 4.04297 0.01654 1.93666 0.71497 0.32881 2.98044 2.88372 1.09445 0.36079 4.34984 10/25/2019 17 5 13 84 1 0 84 10/12/2018 25 14 11 132 1 0 132 2017-10-12 28 10 18 1 132 0 132 108 3 24 0 0.00 0 0 9025 COLORADO AVENUE RIVERSIDE, CA 92503 (33.937871, -117.447787) 02/01/2020
8538 8538 1201 34TH ST SAN DIEGO, CA 92102 32.718211 -117.12102 0   56182 GOLDEN HILL SUBACUTE & REHAB CTR 1201 34TH ST. SAN DIEGO CA 92102 6192322946 470 San Diego For profit - Corporation 99 79 Medicare and Medicaid false WINDSOR HEALTHCARE GOLDEN PALMS LLC 08/22/1972 false   false false false Resident Yes 2   2   2   1   3   3   3       2.08461 1.71623 1.00209 2.71833 4.80294 0.07238 2.23561 0.8522 0.69342 3.78122 1.93796 1.51433 0.54393 4.07312 10/10/2019 13 10 3 56 1 0 56 10/04/2018 28 18 11 128 1 0 128 2017-08-25 15 13 6 1 80 0 80 84 6 8 1 3097.00 0 1 1201 34TH ST SAN DIEGO, CA 92102 (32.718211, -117.12102) 02/01/2020
8565 8565 200 S MAPLE STREET HAZEN, AR 72064 34.778946 -91.56222 0   45228 MAPLE HEALTHCARE 200 S MAPLE STREET HAZEN AR 72064 8702554323 580 Prairie For profit - Limited Liability company 70 47.9 Medicare and Medicaid false HAZEN SNF OPERATOR LLC 01/01/1994 false   false false false Resident Yes 1   2   2   2     2 1 12 1 12 6 6                             02/21/2019 5 5 0 56 1 0 56 05/03/2018 23 12 11 212 1 0 212 2017-02-03 15 15 0 1 148 0 148 123.333 0 14 1 10400.00 0 1 200 S MAPLE STREET HAZEN, AR 72064 (34.778946, -91.56222) 02/01/2020
8752 8752 920 THURBER DRIVE WEST COLUMBUS, OH 43215 39.97972 -83.016289 0   365315 CAPITAL CITY GARDENS REHABILITATION AND NURSING CE 920 THURBER DRIVE WEST COLUMBUS OH 43215 6144642273 250 Franklin For profit - Corporation 104 96.8 Medicare and Medicaid false GARDEN REHAB AND HEALTH CARE AT VICTORIAN VILLAGE LLC 02/10/1975 false   false false false Resident Yes 1   2   3   4   3   1   1       1.6304 0.92546 0.36277 1.28824 2.91864 0.04126 2.01972 0.87086 0.46788 3.35846 1.67772 0.79908 0.29183 2.78672 10/09/2019 3 0 3 12 1 0 12 10/25/2018 26 17 11 136 1 0 136 2017-08-03 10 9 1 1 52 0 52 60 0 8 0 0.00 0 0 920 THURBER DRIVE WEST COLUMBUS, OH 43215 (39.97972, -83.016289) 02/01/2020
8777 8777 616 W RUSSELL PL SAN ANTONIO, TX 78212 29.451044 -98.499774 0   455450 MERIDIAN CARE MONTE VISTA 616 W RUSSELL PL SAN ANTONIO TX 78212 2107359233 130 Bexar For profit - Limited Liability company 106 45.8 Medicare and Medicaid false RJ MERIDIAN CARE ALTA VISTA LLC 01/01/1978 false   false false false Resident Yes 3   2   4   4     2 4   3       2.22358 1.52909 0.43677 1.96586 4.18944 0.12485 2.00958 0.64608 0.24969 2.90535 2.29966 1.77963 0.6584 4.62392 09/13/2019 8 8 0 56 1 0 56 09/21/2018 12 8 11 112 1 0 112 2017-09-28 9 9 0 1 96 0 96 81.333 1 0 0 0.00 0 0 616 W RUSSELL PL SAN ANTONIO, TX 78212 (29.451044, -98.499774) 02/01/2020
9599 9599 16530 S BROADWAY STREET GARDENA, CA 90248 33.880962 -118.278196 0   555410 GREENFIELD CARE CENTER OF GARDENA 16530 S BROADWAY STREET GARDENA CA 90248 3103299929 200 Los Angeles For profit - Corporation 50 40.8 Medicare and Medicaid false Legal Business Name Not Available 10/01/1989 false   false false false Resident Yes 4   2   5   5   5   4   3       2.60493 1.18593 0.5353 1.72124 4.32617 0.02013 1.96225 0.72679 0.30905 2.99809 2.75903 1.22698 0.65194 4.62713 10/08/2019 20 17 5 80 1 0 80 10/06/2018 22 11 11 116 1 0 116 2017-11-09 17 8 9 1 112 0 112 97.333 13 12 0 0.00 0 0 16530 S BROADWAY STREET GARDENA, CA 90248 (33.880962, -118.278196) 02/01/2020
9928 9928 9827 NORTH NEVADA SPOKANE, WA 99218 47.746143 -117.395374 0   505496 AVALON CARE CENTER AT NORTHPOINTE 9827 NORTH NEVADA SPOKANE WA 99218 5094687000 310 Spokane For profit - Corporation 119 107.3 Medicare and Medicaid false AVALON CARE CENTER - SPOKANE, LLC 05/08/1996 false   false false false Resident Yes 4   2   5   5   5   4   4       2.32886 0.66499 0.87913 1.54412 3.87299 0.18209 2.07445 0.76071 0.36059 3.19574 2.33323 0.65733 0.91764 3.88622 05/17/2019 26 16 12 132 1 0 132 03/30/2018 29 20 11 239 1 0 239 2017-04-26 20 12 8 1 100 0 100 162.333 14 19 3 29146.00 0 3 9827 NORTH NEVADA SPOKANE, WA 99218 (47.746143, -117.395374) 02/01/2020
10316 10316 960 S RAPIDS RD MANITOWOC, WI 54220 44.088832 -87.707091 0   525475 RIVER'S BEND HEALTH SERVICES 960 S RAPIDS RD MANITOWOC WI 54220 9206841144 350 Manitowoc For profit - Limited Liability company 100 81.4 Medicare and Medicaid false NSH MANITOWOC LLC 07/01/1991 false   false false false Resident Yes 2   2   4   5   4   3   4       2.0106 0.54576 0.87231 1.41807 3.42867 0.05088 2.18293 0.79329 0.34827 3.32449 1.91426 0.51731 0.94273 3.30715 08/28/2019 11 10 5 56 1 0 56 08/23/2018 13 2 11 115 1 0 115 2017-07-20 8 6 2 1 36 0 36 72.333 0 6 0 0.00 0 0 960 S RAPIDS RD MANITOWOC, WI 54220 (44.088832, -87.707091) 02/01/2020
10693 10693 1020 GREEN AVENUE ALTOONA, PA 16601 40.517007 -78.399242 0   395985 ALTOONA CENTER FOR NURSING CARE 1020 GREEN AVENUE ALTOONA PA 16601 8149462700 120 Blair For profit - Corporation 120 107.9 Medicare and Medicaid false ALTOONA CENTER FOR NURSING CARE, LLC 04/18/1996 false   false false false Resident Yes 2   2   3   3   2   2   3       1.82783 0.8639 0.73336 1.59726 3.42508 0.04423 2.20852 0.86231 0.46622 3.53705 1.72008 0.75333 0.59205 3.10515 02/07/2019 17 16 1 88 1 0 88 03/23/2018 20 13 11 84 1 0 84 2017-03-23 18 14 4 1 88 0 88 86.667 1 8 0 0.00 0 0 1020 GREEN AVENUE ALTOONA, PA 16601 (40.517007, -78.399242) 02/01/2020
10739 10739 1565 HILL ROAD NOVATO, CA 94947 38.096499 -122.576033 0   555844 NOVATO HEALTHCARE CENTER 1565 HILL ROAD NOVATO CA 94947 4158976161 310 Marin For profit - Limited Liability company 181 174.1 Medicare and Medicaid false NOVATO HEALTHCARE CENTER LLC 10/31/2007 false   false false false Both Yes 2   2   4   3   4   3   3       2.31254 0.71009 0.51645 1.22653 3.53908 0.0629 1.82913 0.65304 0.30877 2.79094 2.62762 0.81763 0.62953 4.06624 08/01/2019 13 4 9 64 1 0 64 05/18/2018 23 13 11 100 1 0 100 2017-05-12 17 10 12 1 140 0 140 88.667 23 22 0 0.00 0 0 1565 HILL ROAD NOVATO, CA 94947 (38.096499, -122.576033) 02/01/2020
10764 10764 1601 SOUTH MAIN STREET ROSWELL, NM 88203 33.374132 -104.522985 0   325086 CASA MARIA HEALTHCARE CENTER AND PECOS VALLEY REHA 1601 SOUTH MAIN STREET ROSWELL NM 88203 5756236008 20 Chaves For profit - Corporation 118 92.3 Medicare and Medicaid false CASA MARIA OF NEW MEXICO, LLC 03/27/1998 false   false false false Both Yes 2   2   2   2   2   3   4       1.73783 0.49808 0.9223 1.42037 3.15821 0.17122 2.02389 0.76987 0.38441 3.17817 1.78458 0.48648 0.90304 3.18651 02/06/2019 13 13 2 112 1 0 112 12/20/2017 26 19 11 304 1 0 304 2017-02-10 11 11 10 1 147 0 147 181.833 0 4 2 52203.00 0 2 1601 SOUTH MAIN STREET ROSWELL, NM 88203 (33.374132, -104.522985) 02/01/2020
10823 10823 26 SECOND STREET MONTEAGLE, TN 37356 35.242512 -85.828627 0   445393 SIGNATURE HEALTHCARE OF MONTEAGLE REHAB & WELLNESS 26 SECOND STREET MONTEAGLE TN 37356 9319242041 300 Grundy For profit - Corporation 150 95.3 Medicare and Medicaid false LP MONTEAGLE LLC 07/01/1997 false   true false false Resident Yes 2   2   3   2   3   2   2       1.87236 1.04508 0.32934 1.37442 3.24677 0.06573 2.05341 0.7725 0.38337 3.20928 1.89508 1.01727 0.32334 3.24412 05/15/2019 5 3 2 20 1 0 20 05/24/2018 16 8 11 76 1 0 76 2017-03-29 4 1 3 1 12 0 12 37.333 23 2 0 0.00 0 0 26 SECOND STREET MONTEAGLE, TN 37356 (35.242512, -85.828627) 02/01/2020
11450 11450 1600 SAINT PARIS PIKE SPRINGFIELD, OH 45504 39.944938 -83.819349 0   365527 ARBORS AT SPRINGFIELD 1600 SAINT PARIS PIKE SPRINGFIELD OH 45504 9373998131 110 Clark For profit - Partnership 50 34.2 Medicare and Medicaid false SPRINGFIELD OPCO LLC 06/02/1980 false   false false false Resident Yes 2   2   4   3   5   3   3       2.34246 1.28141 1.03043 2.31184 4.6543 0.07605 2.22088 0.89876 0.74225 3.86189 2.19212 1.07208 0.52252 3.86463 10/03/2019 12 10 2 76 1 0 76 09/06/2018 15 5 11 76 1 0 76 2017-07-07 2 0 2 0 4 0 4 64 0 12 0 0.00 0 0 1600 SAINT PARIS PIKE SPRINGFIELD, OH 45504 (39.944938, -83.819349) 02/01/2020
11676 11676 1501 CLAYTON AVENUE POTEAU, OK 74953 35.045786 -94.611928 0   375166 THE OAKS HEALTHCARE CENTER 1501 CLAYTON AVENUE POTEAU OK 74953 9186478236 390 Le Flore For profit - Corporation 158 91.2 Medicare and Medicaid false THE OAKS HEALTHCARE CENTER - POTEAU, LLC 04/01/1994 false   false false false Both Yes 2   2   2   1   3   2   2       2.45613 0.65951 0.35761 1.01713 3.47326 0.01485 1.9162 0.72023 0.33932 2.97575 2.66395 0.68855 0.39668 3.74277 12/05/2019 4 0 4 32 0 0 32 11/01/2018 18 7 11 144 1 0 144 2017-08-17 11 10 1 1 80 0 80 77.333 0 4 0 0.00 0 0 1501 CLAYTON AVENUE POTEAU, OK 74953 (35.045786, -94.611928) 02/01/2020
13054 13054 106 N BARON BELLVILLE, TX 77418 29.954377 -96.26313 0   676164 COLONIAL BELLE NURSING HOME 106 N BARON BELLVILLE TX 77418 9798653689 70 Austin For profit - Corporation 85 36.2 Medicare and Medicaid false LTC OF AUSTIN COUNTY II, LLC 12/16/2007 false   false false false Resident Yes 1   2   1   1     2 1 12 1 12     1.78671 1.01328 0.22188 1.23516 3.02187 0.00693 1.91027 0.68645 0.31873 2.91545 1.9439 1.10995 0.26201 3.32371 06/21/2019 7 6 1 72 1 0 72 06/28/2018 11 6 11 96 1 0 96 2017-05-18 14 9 14 1 140 0 140 91.333 3 11 1 7153.00 0 1 106 N BARON BELLVILLE, TX 77418 (29.954377, -96.26313) 02/01/2020
13295 13295 1617 RAMIREZ STREET MARYSVILLE, CA 95901 39.153817 -121.583294 0   555682 MARYSVILLE POST-ACUTE 1617 RAMIREZ STREET MARYSVILLE CA 95901 5307427311 680 Yuba For profit - Corporation 86 80.2 Medicare and Medicaid false MELON HOLDINGS LLC 11/07/1996 false   false false false Both Yes 2   2   4   4   4   3   2       2.73587 1.01709 0.42327 1.44037 4.17624 0 2.12429 0.749 0.33754 3.21083 2.67669 1.02108 0.47199 4.17082 02/01/2019 12 8 4 76 1 0 76 12/21/2017 13 2 11 56 1 0 56 2016-10-25 29 25 4 1 192 0 192 88.667 7 12 0 0.00 0 0 1617 RAMIREZ STREET MARYSVILLE, CA 95901 (39.153817, -121.583294) 02/01/2020
13872 13872 5414 HANKINS ROAD MIDDLETOWN, OH 45044 39.432175 -84.434802 0   365813 HAWTHORN GLEN NURSING CENTER 5414 HANKINS ROAD MIDDLETOWN OH 45044 5138637775 80 Butler For profit - Corporation 74 52.7 Medicare and Medicaid false SEMMA ENTERPRISES, INC. 11/16/1990 false   false false false Both Yes 2   2   3   2   4   2   2       1.76488 0.95325 0.40219 1.35544 3.12032 0.05455 1.95957 0.76666 0.39734 3.12357 1.87185 0.93495 0.38098 3.20332 11/06/2019 11 11 0 80 1 0 80 10/04/2018 14 3 11 96 1 0 96 2017-08-03 3 3 0 2 32 16 48 80 0 5 1 10000.00 0 1 5414 HANKINS ROAD MIDDLETOWN, OH 45044 (39.432175, -84.434802) 02/01/2020
14003 14003 1508 WEST SEVENTH AVENUE KENNEWICK, WA 99336 46.202192 -119.139428 0   505080 LIFE CARE CENTER OF KENNEWICK 1508 WEST SEVENTH AVENUE KENNEWICK WA 99336 5095869185 20 Benton For profit - Corporation 136 55.9 Medicare and Medicaid false KENNEWICK MEDICAL INVESTORS, LLC 06/01/1974 false   false false false Resident Yes 3   2   2   2   3   4   5       2.50366 0.66047 1.11001 1.77048 4.27414 0.08399 2.32054 0.77612 0.38046 3.47712 2.24235 0.63989 1.09812 3.94169 03/05/2019 25 11 14 164 1 0 164 04/12/2018 29 22 11 263 1 0 263 2017-01-13 22 15 7 1 176 0 176 199 9 19 2 75267.00 0 2 1508 WEST SEVENTH AVENUE KENNEWICK, WA 99336 (46.202192, -119.139428) 02/01/2020
14170 14170 3876 SAXONBURG BOULEVARD CHESWICK, PA 15024 40.597008 -79.872183 0   395538 CHESWICK REHABILITATION AND WELLNESS CENTER, LLC 3876 SAXONBURG BOULEVARD CHESWICK PA 15024 4127674998 10 Allegheny For profit - Corporation 121 112.3 Medicare and Medicaid false CHESWICK REHABILITATION AND WELLNESS CENTER LLC 09/01/1982 false   false false false Resident Yes 2   2   4   4   4   2   2       2.09138 0.63551 0.48597 1.12148 3.21286 0.0907 2.06016 0.83221 0.44361 3.33598 2.10984 0.57421 0.41232 3.08832 10/31/2019 11 8 3 84 1 0 84 11/21/2018 16 8 11 104 1 0 104 2017-10-11 12 8 9 1 68 0 68 88 1 34 0 0.00 1 1 3876 SAXONBURG BOULEVARD CHESWICK, PA 15024 (40.597008, -79.872183) 02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [nh_gen_info_geocoded_final] (
   [address] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [prvdr_nmbr] INTEGER,
   [prvdr_nm] TEXT,
   [prvdr_add] TEXT,
   [prvdr_city] TEXT,
   [prvdr_state] TEXT,
   [prvdr_zip] INTEGER,
   [prvdr_phn] INTEGER,
   [prvdr_cnty] INTEGER,
   [prvdr_cnty_name] TEXT,
   [ownership] TEXT,
   [nmbr_beds] INTEGER,
   [avg_residents] TEXT,
   [prvdr_type] TEXT,
   [Provider Resides in Hospital] TEXT,
   [Legal Business Name] TEXT,
   [Date First Approved to Provide Medicare and Medicaid services] TEXT,
   [Continuing Care Retirement Community] TEXT,
   [Special Focus Status] TEXT,
   [Abuse Icon] TEXT,
   [Most Recent Health Inspection More Than 2 Years Ago] TEXT,
   [Provider Changed Ownership in Last 12 Months] TEXT,
   [With a Resident and Family Council] TEXT,
   [Automatic Sprinkler Systems in All Required Areas] TEXT,
   [Overall Rating] INTEGER,
   [Overall Rating Footnote] TEXT,
   [Health Inspection Rating] INTEGER,
   [Health Inspection Rating Footnote] TEXT,
   [QM Rating] INTEGER,
   [QM Rating Footnote] TEXT,
   [Long-Stay QM Rating] TEXT,
   [Long-Stay QM Rating Footnote] TEXT,
   [Short-Stay QM Rating] TEXT,
   [Short-Stay QM Rating Footnote] TEXT,
   [Staffing Rating] TEXT,
   [Staffing Rating Footnote] TEXT,
   [RN Staffing Rating] TEXT,
   [RN Staffing Rating Footnote] TEXT,
   [Reported Staffing Footnote] TEXT,
   [Physical Therapist Staffing Footnote] TEXT,
   [Reported Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Reported LPN Staffing Hours per Resident per Day] TEXT,
   [Reported RN Staffing Hours per Resident per Day] TEXT,
   [Reported Licensed Staffing Hours per Resident per Day] TEXT,
   [Reported Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Reported Physical Therapist Staffing Hours per Resident Per Day] TEXT,
   [Case-Mix Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Case-Mix LPN Staffing Hours per Resident per Day] TEXT,
   [Case-Mix RN Staffing Hours per Resident per Day] TEXT,
   [Case-Mix Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Adjusted Nurse Aide Staffing Hours per Resident per Day] TEXT,
   [Adjusted LPN Staffing Hours per Resident per Day] TEXT,
   [Adjusted RN Staffing Hours per Resident per Day] TEXT,
   [Adjusted Total Nurse Staffing Hours per Resident per Day] TEXT,
   [Rating Cycle 1 Standard Survey Health Date] TEXT,
   [Rating Cycle 1 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 1 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 1 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 1 Health Deficiency Score] INTEGER,
   [Rating Cycle 1 Number of Health Revisits] INTEGER,
   [Rating Cycle 1 Health Revisit Score] INTEGER,
   [Rating Cycle 1 Total Health Score] INTEGER,
   [Rating Cycle 2 Standard Health Survey Date] TEXT,
   [Rating Cycle 2 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 2 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 2 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 2 Health Deficiency Score] INTEGER,
   [Rating Cycle 2 Number of Health Revisits] INTEGER,
   [Rating Cycle 2 Health Revisit Score] INTEGER,
   [Rating Cycle 2 Total Health Score] INTEGER,
   [Rating Cycle 3 Standard Health Survey Date] TEXT,
   [Rating Cycle 3 Total Number of Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Standard Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Complaint Health Deficiencies] INTEGER,
   [Rating Cycle 3 Number of Health Revisits] INTEGER,
   [Rating Cycle 3 Health Deficiency Score] INTEGER,
   [Rating Cycle 3 Health Revisit Score] INTEGER,
   [Rating Cycle 3 Total Health Score] INTEGER,
   [Total Weighted Health Survey Score] TEXT,
   [Number of Facility Reported Incidents] INTEGER,
   [Number of Substantiated Complaints] INTEGER,
   [Number of Fines] INTEGER,
   [Total Amount of Fines in Dollars] TEXT,
   [Number of Payment Denials] INTEGER,
   [Total Number of Penalties] INTEGER,
   [Location] TEXT,
   [Processing Date] TEXT
);