FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Address_1 = "Victoria" and Country/Location_Represented = "AUSTRALIA" sorted by Address_1
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 8
Registrant_Date (date) 8 ✖
- 1985-06-24 2
- 1964-10-06 1
- 1972-01-05 1
- 1977-02-10 1
- 1981-08-06 1
- 1989-04-19 1
- 1990-04-11 1
- 1992-09-28 1
Foreign_Principal 8
State 1
- - 9
Country/Location_Represented 1
- AUSTRALIA · 9 ✖
City 1
- - 9
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
867 | 867 | 1984-01-01 | Australian Wool Corporation | 1977-02-10 | AUSTRALIA | Barnes, Richardson & Colburn 2751 | 1977-02-10 | Barnes, Richardson & Colburn | Victoria | ||||
6288 | 6288 | 1993-05-03 | Glaxo Australia Party, Ltd. | 1992-09-28 | AUSTRALIA | Wilson, Scott A. 4711 | 1992-09-28 | Wilson, Scott A. | Victoria | ||||
7414 | 7414 | 1992-06-01 | Glaxo Australia Party, Ltd. | 1989-04-19 | AUSTRALIA | Maupin Taylor Ellis & Adams, P.C. 4242 | 1989-04-19 | Maupin Taylor Ellis & Adams, P.C. | Victoria | ||||
9009 | 9009 | 1978-07-05 | Government Aircraft Factories | 1972-01-05 | AUSTRALIA | Sales Northwest of Australia 2302 | 1972-01-05 | Sales Northwest of Australia | Victoria | ||||
9103 | 9103 | 1993-07-08 | Victorian Government of Australia | 1981-08-06 | AUSTRALIA | Victorian Government Business Office, Los Angeles 3266 | 1981-08-06 | Victorian Government Business Office, Los Angeles | Victoria | ||||
12384 | 12384 | 1997-10-01 | Australian Wheat Board | 1990-04-20 | AUSTRALIA | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Victoria | ||||
13539 | 13539 | 1965-11-01 | Morenco Film Corporation Party, Ltd. | 1964-10-06 | AUSTRALIA | Bretz, Rudy 1799 | 1964-10-06 | Bretz, Rudy | Victoria | ||||
14874 | 14874 | 1992-12-07 | Glaxo Australia Party, Ltd. (Glaxo")" | 1992-03-19 | AUSTRALIA | Hopkins & Sutter 4362 | 1990-04-11 | Hopkins & Sutter | Victoria | ||||
15359 | 15359 | 2003-12-23 | Australian Dairy Industry | 1994-12-21 | AUSTRALIA | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Victoria |
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]) );