My own comprehensive lists are still a work in progress, but I am building from the sources listed here. Follow the links for more information.
the Register of the Department of State and the US Register
various lists contained in NARA finding guides
Walter Burges Smith, America’s Diplomats and Consuls of 1776-1865: A Geographic and Biographic Directory of the Foreign Service from the Declaration of Independence to the End of the Civil War (Arlington VA: Center for the Study of Foreign Affairs, 1986).