FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Address_1 = "Washington" and Country/Location_Represented = "AUSTRALIA" sorted by Foreign_Principal_Registration_Date descending
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date)
Registrant_Name 8
Registrant_Date (date) 8 ✖
- 1985-06-24 3
- 1977-10-12 2
- 1942-11-05 1
- 1976-12-17 1
- 1983-04-26 1
- 1984-06-20 1
- 1989-02-22 1
- 1989-05-25 1
Foreign_Principal 8
State 1
- DC 11
Country/Location_Represented 1
- AUSTRALIA · 11 ✖
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14465 | 14465 | 1996-11-30 | Broken Hill Proprietary Company, Ltd. | 1996-03-18 | AUSTRALIA | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Washington | DC | |||
16429 | 16429 | 1998-12-31 | Australia-U.S. Business Council | 1996-01-24 | AUSTRALIA | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Washington | DC | |||
2490 | 2490 | 1994-02-14 | Alliance for British Australian Tax Equity (ABATE) | 1992-07-17 | AUSTRALIA | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Washington | DC | |||
13586 | 13586 | 1991-11-01 | Embassy of Australia | 1991-03-29 | AUSTRALIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
8882 | 8882 | 1991-07-01 | Alliance for British Australian Tax Equity (ABATE) | 1990-09-06 | AUSTRALIA | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Washington | DC | |||
13733 | 13733 | 1990-11-05 | Embassy of Australia | 1990-08-13 | AUSTRALIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | Washington | DC | |||
2704 | 2704 | 1989-02-22 | Australian Embassy | 1989-02-22 | AUSTRALIA | Aviso, Inc. 4220 | 1989-02-22 | Aviso, Inc. | Washington | DC | |||
9464 | 9464 | 1988-07-25 | Australian Department of Immigration | 1988-07-07 | AUSTRALIA | Ernest Beyl Public Relations, Inc. 3463 | 1983-04-26 | Ernest Beyl Public Relations, Inc. | Washington | DC | |||
7063 | 7063 | 1988-05-31 | Embassy of Australia | 1987-09-18 | AUSTRALIA | APCO Associates 3597 | 1984-06-20 | APCO Associates | Washington | DC | |||
6178 | 6178 | 1982-05-01 | Australian Information Service, Australian Embassy | 1981-03-05 | AUSTRALIA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Washington | DC | |||
13715 | 13715 | 1942-11-05 | Australian Legation | 1942-11-05 | AUSTRALIA | Minor, Gatley & Drury 153 | 1942-11-05 | Minor, Gatley & Drury | 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]) );