Medicaid Expenditure Report Prepaid Services Expenditures January - December 2007
| District |
Total Prepaid Care |
Managed Care |
Premiums |
| HMO |
LTC |
FHP |
Mental Health |
SMI |
TPHI* |
| Statewide Total |
$8,499,540,845 |
$4,904,693,052 |
$912,057,665 |
$1,565,905,779 |
$62,667,837 |
$1,033,932,703 |
$20,283,809 |
| Other State Agency Total |
$19,587,527 |
$124,399 |
$0 |
$344 |
$5,081,835 |
$14,380,949 |
$0 |
| New York City & Rest of State Total |
$8,479,953,318 |
$4,904,568,653 |
$912,057,665 |
$1,565,905,435 |
$57,586,002 |
$1,019,551,754 |
$20,283,809 |
| New York City Total |
$6,230,779,122 |
$3,575,799,155 |
$815,380,400 |
$1,067,984,776 |
$21,757,386 |
$745,565,506 |
$4,291,899 |
| Rest of State Total |
$2,249,174,195 |
$1,328,769,498 |
$96,677,265 |
$497,920,659 |
$35,828,616 |
$273,986,247 |
$15,991,910 |
| Albany |
$62,534,972 |
$41,438,757 |
$162,341 |
$11,488,059 |
$1,475,793 |
$7,809,605 |
$160,417 |
| Allegany |
$9,586,707 |
$4,358,650 |
$0 |
$3,466,941 |
$133,123 |
$1,513,608 |
$114,385 |
| Broome |
$45,785,480 |
$25,668,749 |
$0 |
$12,624,582 |
$1,270,253 |
$5,813,413 |
$408,483 |
| Cattaraugus |
$23,858,336 |
$14,817,698 |
$0 |
$5,792,495 |
$34,588 |
$2,669,562 |
$543,993 |
| Cayuga |
$5,698,035 |
($15,845) |
$0 |
$3,659,668 |
$0 |
$2,013,524 |
$40,688 |
| Chautauqua |
$44,896,365 |
$30,255,584 |
$0 |
$8,511,429 |
$319,538 |
$4,604,082 |
$1,205,732 |
| Chemung |
$11,309,616 |
$1,387,196 |
$0 |
$6,177,911 |
$411,772 |
$3,142,042 |
$190,695 |
| Chenango |
$5,922,823 |
$762 |
$0 |
$3,817,094 |
$29,646 |
$1,806,288 |
$269,033 |
| Clinton |
$7,192,725 |
$28,575 |
$0 |
$4,282,432 |
$0 |
$2,775,823 |
$105,895 |
| Columbia |
$11,387,934 |
$6,914,523 |
$0 |
$2,614,070 |
$9,882 |
$1,747,177 |
$102,282 |
| Cortland |
$8,539,876 |
$3,722,396 |
$0 |
$3,403,553 |
$0 |
$1,328,560 |
$85,367 |
| Delaware |
$4,397,626 |
($57,151) |
$0 |
$2,682,731 |
$9,882 |
$1,527,345 |
$234,819 |
| Dutchess |
$35,790,131 |
$21,188,799 |
$545 |
$8,707,559 |
$359,066 |
$5,398,835 |
$135,327 |
| Erie |
$239,351,232 |
$151,892,935 |
$4,301,372 |
$50,042,626 |
$2,200,513 |
$28,303,517 |
$2,610,269 |
| Essex |
$3,949,326 |
$11,450 |
$0 |
$2,730,473 |
$0 |
$1,133,399 |
$74,004 |
| Franklin |
$5,769,434 |
($32,257) |
$0 |
$3,868,051 |
$9,882 |
$1,775,064 |
$148,694 |
| Fulton |
$12,691,585 |
$5,808,390 |
$10,345 |
$4,353,451 |
$51,058 |
$2,360,176 |
$108,165 |
| Genesee |
$13,658,620 |
$8,625,332 |
$0 |
$3,500,588 |
$13,176 |
$1,173,278 |
$346,246 |
| Greene |
$12,498,976 |
$8,427,762 |
$979 |
$2,608,684 |
$0 |
$1,418,032 |
$43,519 |
| Hamilton |
$398,087 |
$17,887 |
$0 |
$250,160 |
$0 |
$133,687 |
($3,647) |
| Herkimer |
$20,372,360 |
$11,626,445 |
$509,706 |
$5,262,291 |
$798,839 |
$2,079,806 |
$95,273 |
| Jefferson |
$12,871,102 |
$4,900 |
$0 |
$9,550,046 |
$100,473 |
$3,022,494 |
$193,189 |
| Lewis |
$3,094,959 |
$0 |
$0 |
$2,135,455 |
$19,764 |
$890,154 |
$49,586 |
| Livingston |
$11,740,008 |
$7,810,899 |
$0 |
$2,741,764 |
$16,470 |
$951,333 |
$219,542 |
| Madison |
$5,183,429 |
($204) |
$0 |
$3,545,660 |
$37,881 |
$1,536,221 |
$63,871 |
| Monroe |
$205,485,349 |
$140,691,630 |
$13,208,370 |
$30,768,713 |
$174,592 |
$19,551,491 |
$1,090,553 |
| Montgomery |
$10,733,180 |
$5,391,030 |
$817 |
$3,687,660 |
$18,117 |
$1,632,782 |
$2,774 |
| Nassau |
$233,777,023 |
$117,258,276 |
$27,744,952 |
$55,966,749 |
$184,476 |
$31,539,487 |
$1,083,083 |
| Niagara |
$59,401,911 |
$43,591,087 |
$0 |
$10,321,939 |
$452,950 |
$4,991,900 |
$44,035 |
| Oneida |
$76,324,374 |
$44,142,323 |
$7,065,930 |
$14,089,040 |
$2,767,418 |
$7,296,411 |
$963,252 |
| Onondaga |
$121,401,462 |
$67,029,989 |
$15,067,218 |
$23,555,040 |
$3,796,176 |
$11,025,374 |
$927,665 |
| Ontario |
$20,758,515 |
$14,219,829 |
$0 |
$4,340,173 |
$204,240 |
$1,807,027 |
$187,246 |
| Orange |
$88,198,578 |
$56,678,615 |
$7,152,246 |
$15,634,831 |
$1,334,145 |
$6,715,056 |
$683,685 |
| Orleans |
$11,453,640 |
$7,600,276 |
$0 |
$2,545,874 |
$21,411 |
$1,156,345 |
$129,734 |
| Oswego |
$39,055,941 |
$25,277,988 |
$96,876 |
$10,580,478 |
$95,533 |
$2,935,144 |
$69,922 |
| Otsego |
$6,470,098 |
$1,198,773 |
$0 |
$3,530,735 |
$74,121 |
$1,533,208 |
$133,261 |
| Putnam |
$6,996,988 |
$3,159,195 |
$0 |
$2,240,696 |
$530,364 |
$1,076,345 |
($9,612) |
| Rensselaer |
$36,579,220 |
$26,749,815 |
$3,325 |
$5,866,694 |
$49,410 |
$3,793,076 |
$116,900 |
| Rockland |
$106,997,093 |
$78,156,814 |
$2,248,296 |
$17,668,853 |
$181,180 |
$8,460,034 |
$281,916 |
| St. Lawrence |
$16,789,959 |
($50,107) |
$0 |
$6,818,429 |
$5,048,331 |
$3,903,505 |
$1,069,801 |
| Saratoga |
$24,708,353 |
$14,101,326 |
$0 |
$6,998,486 |
$9,882 |
$3,472,805 |
$125,854 |
| Schenectady |
$27,426,956 |
$14,215,898 |
$3,655,903 |
$4,373,294 |
$857,698 |
$4,323,032 |
$1,131 |
| Schoharie |
$3,210,795 |
$320,617 |
$46,329 |
$1,971,541 |
$9,882 |
$798,720 |
$63,706 |
| Schuyler |
$1,992,071 |
$48,077 |
$0 |
$1,364,955 |
$1,647 |
$494,996 |
$82,396 |
| Seneca |
$7,508,015 |
$4,830,118 |
$0 |
$1,738,763 |
$181,117 |
$703,654 |
$54,363 |
| Steuben |
$10,911,166 |
$563,108 |
$0 |
$7,015,848 |
$29,647 |
$3,222,005 |
$80,558 |
| Suffolk |
$212,151,794 |
$135,411,059 |
$7,368,691 |
$35,478,082 |
$5,420,573 |
$27,940,779 |
$532,610 |
| Sullivan |
$23,748,780 |
$15,330,746 |
$0 |
$5,355,427 |
$517,188 |
$2,383,528 |
$161,891 |
| Tioga |
$4,792,769 |
$685,764 |
$0 |
$2,801,533 |
$44,469 |
$1,199,678 |
$61,325 |
| Tompkins |
$8,278,847 |
$3,081,228 |
$0 |
$3,247,652 |
$36,236 |
$1,852,851 |
$60,880 |
| Ulster |
$36,377,859 |
$21,416,371 |
$1,087 |
$9,235,229 |
$1,220,495 |
$4,209,462 |
$295,215 |
| Warren |
$5,947,941 |
$1,339,618 |
$0 |
$2,721,662 |
$0 |
$1,835,828 |
$50,833 |
| Washington |
$9,274,157 |
$4,638,789 |
$0 |
$2,850,302 |
$0 |
$1,721,407 |
$63,659 |
| Wayne |
$11,960,693 |
$6,630,426 |
$0 |
$3,623,468 |
$29,646 |
$1,789,220 |
($112,067) |
| Westchester |
$192,035,996 |
$126,778,842 |
$8,031,937 |
$29,649,846 |
$5,236,073 |
$22,256,870 |
$82,428 |
| Wyoming |
$2,939,134 |
$3,121 |
$0 |
$2,078,052 |
$0 |
$818,992 |
$38,969 |
| Yates |
$7,005,790 |
$4,376,625 |
$0 |
$1,982,842 |
$0 |
$618,206 |
$28,117 |
- Data Sources: January - December, 2007 MARS 72 & 73, Schedule E, & SMI Reports
*TPHI includes insurance premiums paid and recoupments from Schedule E
