FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
158 rows where Registration_Number = 97 sorted by rowid descending
This data as json, CSV (advanced)
Foreign_Principal >30
- Adam Stricker 1
- Adolph Lipschuetz 1
- Albert Friedrich Wilhelm 1
- Alois Muller 1
- Anna Kley 1
- Anna Willmy nee Stricker 1
- Anton Muller 1
- Anton Stricker 1
- August Kley 1
- Auguste Ackermann 1
- Auguste Figge 1
- Bernhard Kopp 1
- Berta Steimel 1
- Berta Tucholsky 1
- Bertha Oberst 1
- Carl Neithold 1
- Carl Rettkowski, Jr. 1
- Christian Bidenbach 1
- Christian Kley 1
- Curt Rettkowski 1
- Elisabeth Kreyser 1
- Elisabeth Paetsch 1
- Elise Fritz 1
- Elise Meck nee Finskh 1
- Elise Natter 1
- Elise Oberst 1
- Else Huhs nee Lueders 1
- Emil Becker 1
- Emil Kreher 1
- Emil Wilhelm Josel 1
- …
State 1
- - 58
Registrant_Name 1
Country/Location_Represented 1
City 1
- - 58
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10405 | 10405 | 1943-08-15 | Fritz Stephan | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10404 | 10404 | 1943-08-15 | Fritz Sickel | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10403 | 10403 | 1943-08-15 | Fritz Saalmuller | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10402 | 10402 | 1943-08-15 | Friedrich von Bodelschwingh | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10401 | 10401 | 1943-08-15 | Friedrich Wilhelm Oberst | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10400 | 10400 | 1943-08-15 | Friedrich Sapper | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10399 | 10399 | 1943-08-15 | Friedrich Reimer | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10398 | 10398 | 1943-08-15 | Friedrich Jung | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10397 | 10397 | 1943-08-15 | Friedrich Horz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10396 | 10396 | 1943-08-15 | Friedrich (Fritz) Horz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10395 | 10395 | 1943-08-15 | Frieda Stephan | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10394 | 10394 | 1943-08-15 | Frieda Josel | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10393 | 10393 | 1943-08-15 | Frida Schellborn nee Nagler | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10392 | 10392 | 1943-08-15 | Franziska Boehm nee Chudoba | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10391 | 10391 | 1943-08-15 | Franz Pusch | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10390 | 10390 | 1943-08-15 | Franz North | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10389 | 10389 | 1943-08-15 | Frantisek Dockal | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10388 | 10388 | 1943-08-15 | Ferd. Homrich & Sohn | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10387 | 10387 | 1943-08-15 | Eva Willaret nee Stephan | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10386 | 10386 | 1943-08-15 | Ernst Jung | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10385 | 10385 | 1943-08-15 | Ernst Horz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10384 | 10384 | 1943-08-15 | Ernst Finskh | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10383 | 10383 | 1943-08-15 | Ernestine Huber nee Stephan | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10382 | 10382 | 1943-08-15 | Ernestine Beinen | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10381 | 10381 | 1943-08-15 | Erich Wolff | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10380 | 10380 | 1943-08-15 | Engelbert Muller | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10379 | 10379 | 1943-08-15 | Emma Keck nee Heugele | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10378 | 10378 | 1943-08-15 | Emilie Hartman nee Horz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10377 | 10377 | 1943-08-15 | Emil Wilhelm Josel | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10376 | 10376 | 1943-08-15 | Emil Kreher | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10375 | 10375 | 1943-08-15 | Emil Becker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10374 | 10374 | 1943-08-15 | Else Huhs nee Lueders | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10373 | 10373 | 1943-08-15 | Elise Oberst | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10372 | 10372 | 1943-08-15 | Elise Natter | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10371 | 10371 | 1943-08-15 | Elise Meck nee Finskh | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10370 | 10370 | 1943-08-15 | Elise Fritz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10369 | 10369 | 1943-08-15 | Elisabeth Paetsch | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10368 | 10368 | 1943-08-15 | Elisabeth Kreyser | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10367 | 10367 | 1943-08-15 | Curt Rettkowski | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10366 | 10366 | 1943-08-15 | Christian Kley | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10365 | 10365 | 1943-08-15 | Christian Bidenbach | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10364 | 10364 | 1943-08-15 | Carl Rettkowski, Jr. | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10363 | 10363 | 1943-08-15 | Carl Neithold | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10362 | 10362 | 1943-08-15 | Bertha Oberst | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10361 | 10361 | 1943-08-15 | Berta Tucholsky | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10360 | 10360 | 1943-08-15 | Berta Steimel | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10359 | 10359 | 1943-08-15 | Bernhard Kopp | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10358 | 10358 | 1943-08-15 | Auguste Figge | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10357 | 10357 | 1943-08-15 | Auguste Ackermann | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10356 | 10356 | 1943-08-15 | August Kley | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10355 | 10355 | 1943-08-15 | Anton Stricker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10354 | 10354 | 1943-08-15 | Anton Muller | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10353 | 10353 | 1943-08-15 | Anna Willmy nee Stricker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10352 | 10352 | 1943-08-15 | Anna Kley | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10351 | 10351 | 1943-08-15 | Alois Muller | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10350 | 10350 | 1943-08-15 | Albert Friedrich Wilhelm | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10349 | 10349 | 1943-08-15 | Adolph Lipschuetz | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. | |||||
10348 | 10348 | 1943-08-15 | Adam Stricker | 1942-08-15 | GERMANY, FEDERAL REPUBLIC OF | Gebhardt, H.A. 97 | 1942-08-15 | Gebhardt, H.A. |
Advanced export
JSON shape: default, array, newline-delimited
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]) );