FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Country/Location_Represented = "AUSTRIA" and State = "DC" sorted by Address_2
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 9
Foreign_Principal 7
State 1
- DC · 10 ✖
Country/Location_Represented 1
- AUSTRIA · 10 ✖
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1048 | 1048 | 1978-01-02 | Federal Republic of Austria | 1976-07-01 | AUSTRIA | Masterman, Edward I. 2704 | 1976-07-01 | Masterman, Edward I. | Washington | DC | |||
2710 | 2710 | 1995-02-22 | Special Delegation of the Government of Austria to the U.S. Regarding the Temelin Nuclear Power Plant | 1994-02-28 | AUSTRIA | Spiegel & McDiarmid 4896 | 1994-02-28 | Spiegel & McDiarmid | Washington | DC | |||
5227 | 5227 | 1993-04-12 | Austrian Press & Information Service | 1993-04-07 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
6757 | 6757 | 1955-05-24 | Austria | 1955-09-21 | AUSTRIA | Schaler, Butler & Associates 718 | 1952-02-26 | Schaler, Butler & Associates | Washington | DC | |||
9232 | 9232 | 1950-07-14 | Ludwig Kleinwaechter | 1947-10-16 | AUSTRIA | National Lecture Management 463 | 1947-05-26 | National Lecture Management | Washington | DC | |||
9555 | 9555 | 1952-07-28 | Government of Austria | 1948-08-23 | AUSTRIA | Cox, Oscar S. 341 | 1946-01-28 | Cox, Oscar S. | Washington | DC | |||
11030 | 11030 | 1994-08-31 | Government of Austria | 1994-02-22 | AUSTRIA | Mullenholz, Brimsek & Belair 4897 | 1994-02-22 | Mullenholz, Brimsek & Belair | Washington | DC | |||
11200 | 11200 | 1952-09-01 | Hans Thalberg | 1952-09-19 | AUSTRIA | National Lecture Management, Inc. 638 | 1950-08-16 | National Lecture Management, Inc. | Washington | DC | |||
13865 | 13865 | 1992-11-10 | Austrian Press & Information Service | 1992-10-13 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
14746 | 14746 | 1959-12-02 | Government of Austria | 1952-12-05 | AUSTRIA | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | Washington | DC |
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]) );