Demystifying master bedroom fan wiring

This evening I did a little preliminary detective work to try to figure out the ceiling fan wiring in the master bedroom, in preparation for redoing it. The goal is to reroute the hot and neutral wiring around the switch box, leaving only a single 14/3 switch loop going to the box. That way the fan control will fit properly in the box. More background is here.

Today I just opened up the switch box, disconnected the spliced hot wire, and observed what went dead.

Dead:

Master bedroom – ceiling fixture / Switch
Master bedroom – outlet behind bed
Andrew’s bedroom – outlet at foot of bed
Andrew’s bedroom – outlet behind crib
Andrew’s bedroom – light in closet next to door
Back of basement – ceiling fixture
Basement bathroom – light and fan

Live:

Master bedroom – outlets on wall adjacent to bed (2)
Andrew’s bedroom – outlet behind dresser
Andrew’s bedroom – ceiling fixture
Andrew’s bedroom – light in closet at head of bed

Like everything else in this house, this raises as many questions as it answers. The next step is to inspect the wiring in the attic (there’s very little visible wiring for this circuit in the basement), and work on replacing some of the outlets. As each outlet is disconnected, I can repeat this evening’s exercise and get more info about how the circuit is laid out. Stay tuned..