FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Address_1 = "Melbourne"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal 13
- Australian Canned Fruits Board 1
- Australian Dairy Corporation 1
- Australian National Travel Association 1
- Broadcast Exchange of Australia Party, Ltd. 1
- Broken Hill Proprietary Company, Ltd. 1
- CRA, Ltd. 1
- Department of Industry, Technology & Resources State of Victoria 1
- IPR-Melbourne 1
- International Public Relations Party, Ltd., Melbourne, Australia 1
- National Bank of Australia, Ltd. 1
- Pacific Dunlop, Ltd./Pacific Brands 1
- Reserve Bank of Australia 1
- T.R. Landrigan - Downward's Transport Industries, Inc. 1
Registrant_Name 10
Registrant_Date (date) 10 ✖
- 1967-06-20 3
- 1982-03-12 2
- 1942-07-27 1
- 1957-06-03 1
- 1973-10-23 1
- 1974-08-27 1
- 1975-08-04 1
- 1975-08-07 1
- 1981-05-04 1
- 1987-05-28 1
State 1
- - 13
Country/Location_Represented 1
- AUSTRALIA 13
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56 | 56 | Australian National Travel Association | 1957-06-03 | AUSTRALIA | Tourism Australia 1032 | 1957-06-03 | Tourism Australia | Melbourne | |||||
5232 | 5232 | 1994-04-12 | Broken Hill Proprietary Company, Ltd. | 1988-06-30 | AUSTRALIA | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | Melbourne | ||||
6770 | 6770 | 1991-05-24 | Department of Industry, Technology & Resources State of Victoria | 1989-08-14 | AUSTRALIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Melbourne | ||||
7951 | 7951 | 1981-06-20 | T.R. Landrigan - Downward's Transport Industries, Inc. | 1973-09-14 | AUSTRALIA | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | Melbourne | ||||
7952 | 7952 | 1981-06-20 | IPR-Melbourne | 1968-01-06 | AUSTRALIA | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | Melbourne | ||||
7954 | 7954 | 1981-06-20 | International Public Relations Party, Ltd., Melbourne, Australia | 1967-07-18 | AUSTRALIA | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | Melbourne | ||||
10122 | 10122 | 1975-08-04 | Australian Dairy Corporation | 1975-08-04 | AUSTRALIA | Moore, Robert E. 2597 | 1975-08-04 | Moore, Robert E. | Melbourne | ||||
10186 | 10186 | 1975-08-07 | Australian Canned Fruits Board | 1975-08-07 | AUSTRALIA | Searby, Michael Henry 2599 | 1975-08-07 | Searby, Michael Henry | Melbourne | ||||
11443 | 11443 | 1999-09-08 | Pacific Dunlop, Ltd./Pacific Brands | 1995-06-29 | AUSTRALIA | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Melbourne | ||||
11521 | 11521 | 1984-09-12 | CRA, Ltd. | 1984-03-12 | AUSTRALIA | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | Melbourne | ||||
11855 | 11855 | 1983-09-27 | Reserve Bank of Australia | 1981-05-04 | AUSTRALIA | Finnegan, Henderson, Farabow, Garrett & Dunner 3236 | 1981-05-04 | Finnegan, Henderson, Farabow, Garrett & Dunner | Melbourne | ||||
15204 | 15204 | 1979-12-18 | National Bank of Australia, Ltd. | 1974-08-27 | AUSTRALIA | Shaw, Ian William 2532 | 1974-08-27 | Shaw, Ian William | Melbourne | ||||
15515 | 15515 | 1942-12-31 | Broadcast Exchange of Australia Party, Ltd. | 1942-07-27 | AUSTRALIA | Brown, Howard C. 64 | 1942-07-27 | Brown, Howard C. | Melbourne |
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]) );