Die Bürgerbücher von Cölln an der Spree 1508 - 1611 und 1689 - 1709 und die chronikalischen Nachrichten des ältesten Cöllner Bürgerbuches 1542 - 1610 by Peter Gebhardt, Link below:
https://digital.zlb.de/viewer/readingmode/34285461/1/
https://digital.zlb.de/viewer/resolver?urn=urn:nbn:de:kobv:109-1-15373380 Berlin "Das Aelteste Berliner Burgerbuch"
Link to Citizenship records of Charlottenburg: https://commons.wikimedia.org/wiki/Category:B%C3%BCrgerverzeichnis_Charlottenburg
Following the Thirty Years' War, Berlin's population plummeted to 7,500, prompting the Brandenburg Electors and the first three Prussian kings to successfully rebuild the city's population.
Key Population Drives: The Great Elector Friedrich Wilhelm issued the Edict of Potsdam (1685) to bring French Huguenot refugees to Dorotheenstadt, while Friedrich I and his son actively welcomed further colonists.
The Colonists: Rather than farmers, these immigrants were skilled tradespeople—primarily textile workers, weavers from Sachsen, and religiously persecuted Bohemians.
Historical Records: Sourced from the Preuβ. Geheim Stadtarchiv, pages 19 onward feature an alphabetical directory of these colonists detailing their citizenship date, occupation, origin, religion, age, and settlement district. A secondary, shorter list records 333 sons of colonists.