Okay Chukchi, here are a few pointers on empire management. I took the previous save and played forward 2 turns, so these should be similar to the turns you just played.
First, it is really helpful to use a utility program that will alert you to certain things in the game. Personally, I use an older version of Dianthus' MapStat. This screenshot is taken from the second turn. The trading situation has changed, as we have discovered Republic. The happiness warning is from London, which is still resisting.
Perhaps one of your teammates would be good enough to help you get a good utility and set it up.
The next turn I get a warning of unhappiness at Seville, so I zoom to the city. Here you will see another modification that helps with empire management - the "smileys" next to the citizen icons. (I forgot where I got these... so @Team: If Chukchi wants them...hopefully one of you use them and can tell him where to get them...)
As you can see from the screenshot, I'm about to take a citizen off the wine tile near Dog Town and turn it into a specialist.
Here I've converted the citizen into an entertainer (or "clown").
By clicking on the entertainer icon, we can change it to a tax collector or scientist, and inspect the results.
This is what Seville looks like with a Tax Collector:
...and here is what it looks like with a Scientist.
All of this is prior to the revolution. I played another turn to get into anarchy, to show you something else. Here's a shot of my F1 (Domestic Advisor) screen. Pay no attention to the advisors' faces... mine are... different than most.
Anyway, a trick here is that you can sort your cities according to the type of management you're doing. You can sort by production if you click on the shields icon, or you can sort by population if you need to do a happiness check. Since the happiness problems will be the worst in the larger towns, this helps us find the trouble spots quickly.
Here is a technique for solving happiness problems in towns that don't have surplus food. You can use these micromanaging techniques to move citizens to different tiles. This is Punkbass Canal before micromanaging:
...and here it is after micromanaging:
@Chukchi: Does this help? Please ask any questions you may have.