Here's a different take on the Bureau of Labor Statistics Employment and Wage estimates page. I've downloaded all the data and ranked states (for every occupation with at least 100 workers).

You can use the drop-down menus to filter by state or by occupation.

Occupation Selected: Mental health and substance abuse social workers

Click on state name to filter.
State Jobs Average
Salary
Rank
Wisconsin 1,830 $49,020 1
New Jersey 2,270 $48,900 2
Hawaii 240 $48,500 3
Minnesota 2,070 $46,860 4
Maryland 2,200 $46,600 5
District of Columbia 510 $45,920 6
Connecticut 3,280 $45,790 7
Virginia 3,450 $44,370 8
Rhode Island 1,240 $44,170 9
Louisiana 810 $43,210 10
Delaware 450 $42,580 11
New York 9,870 $42,420 12
Vermont 460 $41,690 13
Maine 1,800 $41,610 14
Massachusetts 3,820 $41,460 15
Michigan 4,180 $39,550 16
California 12,130 $39,430 17
Indiana 1,760 $39,010 18
North Carolina 3,740 $38,790 19
Washington 2,090 $38,760 20
Arkansas 630 $37,970 21
Alaska 330 $37,790 22
New Hampshire 360 $37,490 23
Arizona 1,630 $37,110 24
North Dakota 310 $36,900 25
Kansas 1,430 $36,180 26
Ohio 5,040 $36,150 27
Montana 340 $35,970 28
Utah 1,450 $35,830 29
Kentucky 1,790 $35,690 30
Idaho 470 $35,640 31
Georgia 1,200 $34,520 32
New Mexico 1,390 $34,340 33
Iowa 1,520 $34,320 34
Pennsylvania 9,620 $34,180 35
Oregon 2,440 $34,010 36.5
Colorado 1,660 $34,010 36.5
Texas 3,390 $33,630 38
Illinois 3,430 $33,620 39
Florida 6,160 $32,950 40
Nebraska 1,050 $32,820 41
South Dakota 220 $32,660 42
Mississippi 1,000 $31,500 43
Missouri 2,400 $31,450 44
Alabama 970 $29,570 45
Tennessee 2,600 $28,850 46
Oklahoma 810 $28,100 47
Wyoming 230 $27,640 48
West Virginia 1,450 $22,810 49