FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

158 rows where Registration_Number = 97

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

  • 158

Registrant_Name

Country/Location_Represented

City

  • 158
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
9916 1943-08-15 Adam Stricker 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9917 1943-08-15 Adolph Lipschuetz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9918 1943-08-15 Albert Friedrich Wilhelm 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9919 1943-08-15 Alois Muller 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9920 1943-08-15 Anna Kley 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9921 1943-08-15 Anna Willmy nee Stricker 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9922 1943-08-15 Anton Muller 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9923 1943-08-15 Anton Stricker 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9924 1943-08-15 August Kley 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9925 1943-08-15 Auguste Ackermann 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9926 1943-08-15 Auguste Figge 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9927 1943-08-15 Bernhard Kopp 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9928 1943-08-15 Berta Steimel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9929 1943-08-15 Berta Tucholsky 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9930 1943-08-15 Bertha Oberst 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9931 1943-08-15 Carl Neithold 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9932 1943-08-15 Carl Rettkowski, Jr. 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9933 1943-08-15 Christian Bidenbach 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9934 1943-08-15 Christian Kley 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9935 1943-08-15 Curt Rettkowski 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9936 1943-08-15 Elisabeth Kreyser 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9937 1943-08-15 Elisabeth Paetsch 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9938 1943-08-15 Elise Fritz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9939 1943-08-15 Elise Meck nee Finskh 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9940 1943-08-15 Elise Natter 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9941 1943-08-15 Elise Oberst 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9942 1943-08-15 Else Huhs nee Lueders 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9943 1943-08-15 Emil Becker 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9944 1943-08-15 Emil Kreher 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9945 1943-08-15 Emil Wilhelm Josel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9946 1943-08-15 Emilie Hartman nee Horz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9947 1943-08-15 Emma Keck nee Heugele 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9948 1943-08-15 Engelbert Muller 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9949 1943-08-15 Erich Wolff 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9950 1943-08-15 Ernestine Beinen 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9951 1943-08-15 Ernestine Huber nee Stephan 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9952 1943-08-15 Ernst Finskh 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9953 1943-08-15 Ernst Horz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9954 1943-08-15 Ernst Jung 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9955 1943-08-15 Eva Willaret nee Stephan 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9956 1943-08-15 Ferd. Homrich & Sohn 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9957 1943-08-15 Frantisek Dockal 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9958 1943-08-15 Franz North 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9959 1943-08-15 Franz Pusch 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9960 1943-08-15 Franziska Boehm nee Chudoba 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9961 1943-08-15 Frida Schellborn nee Nagler 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9962 1943-08-15 Frieda Josel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9963 1943-08-15 Frieda Stephan 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9964 1943-08-15 Friedrich (Fritz) Horz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9965 1943-08-15 Friedrich Horz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9966 1943-08-15 Friedrich Jung 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9967 1943-08-15 Friedrich Reimer 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9968 1943-08-15 Friedrich Sapper 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9969 1943-08-15 Friedrich Wilhelm Oberst 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9970 1943-08-15 Friedrich von Bodelschwingh 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9971 1943-08-15 Fritz Saalmuller 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9972 1943-08-15 Fritz Sickel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9973 1943-08-15 Fritz Stephan 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9974 1943-08-15 Gebr. Clauss 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9975 1943-08-15 Gebr. Schreck 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9976 1943-08-15 Georg Horz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9977 1943-08-15 Georg J. Syriacks 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9978 1943-08-15 Georg Marschall 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9979 1943-08-15 Georg Stephan 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9980 1943-08-15 Georg Stricker 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9981 1943-08-15 Gerhard Beerdeh 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9982 1943-08-15 German Theological Seminary 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9983 1943-08-15 Grete Gerber nee Gruse 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9984 1943-08-15 Gustav Horz 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9985 1943-08-15 Gustav Sontag 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9986 1943-08-15 Hedwig Brozda nee Kopp 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9987 1943-08-15 Hedwig Sarfert nee Bleckert 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9988 1943-08-15 Heinz Cyriacks 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9989 1943-08-15 Helene Berthold nee Wolff 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9990 1943-08-15 Helene Han nee Schwedler 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9991 1943-08-15 Helene Scholtz nee Rettkowski 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9992 1943-08-15 Hendricks Heinen 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9993 1943-08-15 Herbert Rettowski 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9994 1943-08-15 Hermann Marschall 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9995 1943-08-15 Ida Niemeyer nee Huning 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9996 1943-08-15 Ida Vornoff nee Ackermann 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9997 1943-08-15 Johann Togel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9998 1943-08-15 Johanna Balser nee Flander 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
9999 1943-08-15 Johanna Neudorder nee North 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10000 1943-08-15 Johannas Riessen 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10001 1943-08-15 Johannes Balser 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10002 1943-08-15 Johannes Frase 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10003 1943-08-15 Josef Grosser 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10004 1943-08-15 Joseph Togel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10005 1943-08-15 Julie Riedmann 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10006 1943-08-15 Karl Chudoba 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10007 1943-08-15 Karl Finckh 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10008 1943-08-15 Karl Friedrich Oberst 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10009 1943-08-15 Karl Jacob Josel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10010 1943-08-15 Karoline Philippine 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10011 1943-08-15 Karoline Wikersheim 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10012 1943-08-15 Kinderhein Kerzenheim 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10013 1943-08-15 Kindermann & Company 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10014 1943-08-15 Klara Borner nee Sickel 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          
10015 1943-08-15 Klara Deutsch 1942-08-15 GERMANY, FEDERAL REPUBLIC OF 97 97 1942-08-15 Gebhardt, H.A.          

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY(Registration_Number) REFERENCES FARA_All_Registrants(Registration_Number)
);
Powered by Datasette · Query took 181.256ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history