Table: 2017_quarter_2_complete_data_set_11_02_17 , fac_name like N*

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  *

fac_no fac_name year_qtr beg_date end_date op_status county_name hsa hfpa type_cntrl type_hosp teach_rurl phone address city zip_code ceo lic_beds avl_beds stf_beds dis_mcar dis_mcar_mc dis_mcal dis_mcal_mc dis_cnty dis_cnty_mc dis_thrd dis_thrd_mc dis_indgnt dis_oth dis_tot dis_ltc day_mcar day_mcar_mc day_mcal day_mcal_mc day_cnty day_cnty_mc day_thrd day_thrd_mc day_indgnt day_oth day_tot day_ltc vis_mcar vis_mcar_mc vis_mcal vis_mcal_mc vis_cnty vis_cnty_mc vis_thrd vis_thrd_mc vis_indgnt vis_oth vis_tot grip_mcar grip_mcar_mc grip_mcal grip_mcal_mc grip_cnty grip_cnty_mc grip_thrd grip_thrd_mc grip_indgnt grip_oth grip_tot grop_mcar grop_mcar_mc grop_mcal grop_mcal_mc grop_cnty grop_cnty_mc grop_thrd grop_thrd_mc grop_indgnt grop_oth grop_tot bad_debt cadj_mcar cadj_mcar_mc cadj_mcal cadj_mcal_mc disp_855 cadj_cnty cadj_cnty_mc cadj_thrd cadj_thrd_mc char_hb char_oth sub_indgnt tch_allow tch_supp ded_oth ded_tot cap_mcar cap_mcal cap_cnty cap_thrd cap_tot net_mcar net_mcar_mc net_mcal net_mcal_mc net_cnty net_cnty_mc net_thrd net_thrd_mc net_indgnt net_oth net_tot oth_op_rev tot_op_exp phy_comp nonop_rev dis_pips day_pips exp_pips exp_pops cap_exp fix_assets disp_trnfr dis_tot_cc pat_day_tot_cc tot_out_vis_cc gros_inpat_rev_cc gros_outpat_rev_cc contr_adj_cc othr_deduct_cc cap_prem_rev_cc net_pat_rev_cc qa_fees qa_suppl_pay mngd_care_qa_pay
106281266 NAPA STATE HOSPITAL 20172 04/01/2017 06/30/2017 Open Napa 03 0407 State State Hospitals None (707) 253-5000 2100 NAPA-VALLEJO HIGHWAY NAPA 94558 FRANK TURLEY 1,418 1,270 1,270 44 0 0 0 0 0 1 0 0 159 204 0 50,414 0 0 0 0 0 205 0 0 56,991 107,610 0 0 0 0 0 0 0 0 0 0 0 0 29,683,549 0 0 0 0 0 120,581 0 0 33,555,951 63,360,081 0 0 0 0 0 0 0 0 0 0 0 0 74 0 0 0 0 0 0 0 0 0 0 0 0 0 16,724 16,798 0 0 0 0 0 29,683,475 0 0 0 0 0 120,581 0 0 33,539,227 63,343,283 0 83,806,537 0 20,463,254 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
106274043 NATIVIDAD MEDICAL CENTER 20172 04/01/2017 06/30/2017 Open Monterey 08 0705 City/County Comparable None (831) 755-4111 1441 CONSTITUTION BOULEVARD SALINAS 93906 GARY GRAY 172 137 137 463 0 611 711 0 0 471 0 7 57 2,320 0 2,712 0 2,243 2,196 0 0 2,103 0 13 147 9,414 0 6,405 0 6,425 19,969 0 0 7,365 0 1,092 2,621 43,877 48,935,612 0 41,335,120 48,814,547 0 0 50,385,550 0 674,629 2,145,176 192,290,634 10,409,512 0 11,912,301 39,717,924 0 0 22,221,336 0 1,400,575 3,931,592 89,593,240 5,717,919 48,764,604 0 45,194,683 75,006,031 (8,436,316) 0 0 40,942,120 0 0 2,075,205 0 0 0 0 209,264,246 0 0 0 0 0 10,580,520 0 16,489,053 13,526,440 0 0 31,664,766 0 0 358,849 72,619,628 1,375,485 67,556,504 0 3,761,798 0 0 0 0 9,082,701 125,119,568 0 0 0 0 0 0 0 0 0 0 0 0 0
106301304 NEWPORT BAY HOSPITAL 20172 04/01/2017 06/30/2017 Open Orange 13 1016 Investor - Corp. Comparable None (949) 650-9750 1501 EAST 16TH STREET NEWPORT BEACH 92663 JAMES E PARKHURST 36 36 36 215 14 0 0 0 0 0 0 0 0 229 0 2,623 217 0 0 0 0 0 0 0 0 2,840 0 0 0 0 0 0 0 0 0 0 0 0 3,751,271 272,787 0 0 0 0 0 0 0 0 4,024,058 0 0 0 0 0 0 0 0 0 0 0 0 1,254,216 114,571 0 0 0 0 0 0 0 0 0 0 0 0 0 1,368,787 0 0 0 0 0 2,497,055 158,216 0 0 0 0 0 0 0 0 2,655,271 325 2,690,612 0 0 0 0 0 0 0 740 0 0 0 0 0 0 0 0 0 0 0 0 0
106514033 NORTH VALLEY BEHAVIORAL HEALTH - PHF 20172 04/01/2017 06/30/2017 Open Sutter 02 0227 Investor - Corp. Psychiatric Health Facilities None (530) 790-2520 1535 PLUMAS COURT YUBA CITY 95993 ARNE HYSON 16 16 16 0 0 0 0 0 0 0 0 0 92 92 0 0 0 0 0 0 0 0 0 0 1,432 1,432 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,235,050 1,235,050 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,235,050 1,235,050 30,150 1,409,599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
106481357 NORTHBAY MEDICAL CENTER 20172 04/01/2017 06/30/2017 Open Solano 03 0408 Non Profit Corp. Comparable None (707) 646-5000 1200 B. GALE WILSON BOULEVARD. FAIRFIELD 94533 B KONARD JONES 182 182 182 948 79 197 584 0 0 84 299 6 18 2,215 0 4,725 372 1,303 2,765 0 0 445 1,060 25 50 10,745 0 21,332 1,529 2,037 19,129 0 0 11,371 18,004 14 1,238 74,654 224,008,495 18,569,204 41,384,488 128,147,770 0 0 15,257,481 57,177,202 1,955,710 2,659,703 489,160,053 116,645,461 7,377,420 23,595,515 133,184,598 0 0 27,704,733 79,989,793 509,693 7,547,828 396,555,041 2,282,488 311,755,122 20,545,644 59,409,385 241,443,220 0 0 0 25,134,756 104,127,885 0 9,818,682 0 0 0 0 774,517,182 0 13,190,251 0 10,042,648 23,232,899 28,898,834 5,400,980 5,570,618 33,079,399 0 0 17,827,458 43,081,758 0 571,764 134,430,811 1,951,164 141,829,794 0 4,595,979 0 0 0 0 10,821,203 190,600,346 0 0 0 0 0 0 0 0 0 0 0 0 0
106454012 NORTHERN CALIFORNIA REHAB HOSPITAL 20172 04/01/2017 06/30/2017 Open Shasta 01 0209 Investor - Corp. Comparable None (530) 246-9000 2801 EUREKA WAY REDDING 96001 CHRIS JONES 88 88 74 227 3 0 48 0 0 1 8 0 0 287 0 4,828 65 0 1,463 0 0 23 308 0 0 6,687 0 919 1 1 3 0 0 11 236 0 0 1,171 33,870,687 668,635 0 10,977,360 0 0 76,339 2,452,823 0 0 48,045,844 854,681 5,973 10,258 42,369 0 0 8,641 158,356 0 0 1,080,278 104,161 27,706,022 542,956 10,258 8,322,324 0 0 0 56,197 2,216,916 0 0 0 0 0 0 38,958,834 0 0 0 0 0 6,915,185 131,652 0 2,697,405 0 0 28,783 394,263 0 0 10,167,288 34,369 7,102,837 0 0 0 0 0 0 301,151 8,359,841 0 0 0 0 0 0 0 0 0 0 0 0 0
106141273 NORTHERN INYO HOSPITAL 20172 04/01/2017 06/30/2017 Open Inyo 12 1203 District Comparable Rural (760) 873-5811 150 PIONEER LANE BISHOP 93514 KEVIN FLANIGAN, MD 25 25 10 140 1 39 36 0 0 9 48 7 6 286 0 443 6 80 76 0 0 21 116 41 19 802 0 7,023 130 1,797 4,312 0 3 1,537 6,337 202 506 21,847 4,526,054 39,237 1,098,983 1,086,917 0 0 370,951 1,657,859 349,035 101,390 9,230,426 9,654,473 260,820 1,894,678 3,295,648 0 6,603 1,381,742 6,654,917 158,179 450,780 23,757,840 335,477 6,021,078 65,558 2,290,673 2,687,356 (532,736) 0 4,438 1,618,814 1,207,701 0 454,691 0 0 0 52,455 14,205,505 0 0 0 0 0 8,159,449 234,498 702,988 2,227,945 0 2,165 133,879 7,105,075 52,523 164,239 18,782,761 26,776 18,647,100 2,467,865 (852,235) 0 0 0 0 16,283 79,787,383 0 0 0 0 0 0 0 0 0 0 0 0 0
106190568 NORTHRIDGE HOSPITAL MEDICAL CENTER 20172 04/01/2017 06/30/2017 Open Los Angeles 11 0905 Non Profit Corp. Comparable None (818) 885-8500 18300 ROSCOE BOULEVARD NORTHRIDGE 91325 SALIBA SALO 412 412 185 1,102 539 369 565 0 0 98 876 0 7 3,556 0 4,960 2,664 1,675 1,879 0 0 381 3,681 0 32 15,272 0 5,226 2,254 2,576 7,449 0 0 1,180 7,081 0 1,719 27,485 132,008,159 63,262,111 43,715,842 49,097,344 0 0 9,684,400 91,498,957 0 565,538 389,832,351 39,865,553 21,571,554 14,720,801 40,856,898 0 0 3,248,118 40,211,329 0 8,562,562 169,036,815 9,431,880 150,741,520 70,789,164 52,961,011 81,770,100 0 0 0 10,146,761 89,400,056 0 (619,737) 0 0 0 4,536,019 469,156,774 0 0 0 0 0 20,331,658 13,852,663 4,713,985 7,770,421 0 0 2,385,061 40,211,957 0 446,647 89,712,392 2,272,969 103,799,749 0 339,192 0 0 0 0 12,882,383 188,802,847 0 0 0 0 0 0 0 0 0 0 0 0 0
106214034 NOVATO COMMUNITY HOSPITAL 20172 04/01/2017 06/30/2017 Open Marin 04 0405 Non Profit Corp. Comparable None (415) 209-1300 180 ROWLAND WAY NOVATO 94945 GRANT DAVIES 47 47 23 287 30 13 49 0 0 4 78 2 5 468 468 998 110 106 170 0 0 8 220 3 8 1,623 2,091 9,561 1,099 427 2,411 0 1 616 8,945 261 321 23,642 16,481,354 1,684,540 1,026,534 2,654,369 0 0 175,628 4,621,826 82,452 247,146 26,973,849 14,705,040 1,605,910 1,173,661 5,685,161 0 4,503 1,013,139 11,562,752 476,346 593,453 36,819,965 634,702 25,365,736 2,694,872 1,584,092 7,673,304 0 0 984 1,188,767 6,595,871 0 558,798 0 0 0 80,793 46,377,919 0 0 0 0 0 5,820,658 595,578 616,103 666,226 0 3,519 0 9,588,707 0 125,104 17,415,895 1,025,682 19,892,480 0 8,624 0 0 0 0 318,974 35,726,106 0 0 0 0 0 0 0 0 0 0 0 0 0