FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Last_Name = "Mueller"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 13
- Austrian Tourist Office, Inc. 1
- Austrian Trade Commission, New York 1
- Austrian Trade Commissioner in the U.S., Chicago 1
- University Travel Company 1
- German-American Chamber of Commerce, Inc., New York 1
- International Public Relations Company, Ltd. 1
- Government of Ontario, Canada 1
- Austrian National Tourist Office, Midwest Office 1
- Burson-Marsteller 1
- Dow, Lohnes & Albertson, L.L.P. 1
- Keene, Shirley & Associates, Inc. 1
- Creative Response Concepts 1
- BerlinRosen Ltd. 1
Registrant_Name 13
- Austrian National Tourist Office, Midwest Office 1
- Austrian Tourist Office, Inc. 1
- Austrian Trade Commission, New York 1
- Austrian Trade Commissioner in the U.S., Chicago 1
- BerlinRosen Ltd. 1
- Burson-Marsteller 1
- Creative Response Concepts 1
- Dow, Lohnes & Albertson, L.L.P. 1
- German-American Chamber of Commerce, Inc., New York 1
- Government of Ontario, Canada 1
- International Public Relations Company, Ltd. 1
- Keene, Shirley & Associates, Inc. 1
- University Travel Company 1
City 5
- New York 6
- Alexandria 2
- Chicago 2
- Washington 2
- Cambridge 1
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4821 | 4821 | 1987-01-30 | 1983-03-17 | Mueller | Lita C. | Dow, Lohnes & Albertson, L.L.P. 3452 | 1983-03-17 | Dow, Lohnes & Albertson, L.L.P. | 1200 New Hampshire Avenue, N.W | Suite 800 | Washington | DC | 20036 |
7855 | 7855 | 1969-02-28 | 1967-02-16 | Mueller | Hans | Austrian Trade Commission, New York 625 | 1950-05-11 | Austrian Trade Commission, New York | 150 East 52nd Street | 32nd Floor | New York | NY | 10022 |
9339 | 9339 | 1960-03-07 | 1959-04-16 | Mueller | Hans | University Travel Company 1218 | 1959-04-16 | University Travel Company | 18 Brattle Street | Cambridge | MA | ||
16129 | 16129 | 1989-05-12 | 1985-10-03 | Mueller | Kenneth M. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
16406 | 16406 | 1989-05-15 | 1977-11-23 | Mueller | Hans G. | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | 352 Park Avenue, South | Suite 705 | New York | NY | 10010 |
17027 | 17027 | 1993-05-24 | 1991-03-15 | Mueller | Ronald R. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
19859 | 19859 | 1991-06-19 | 1988-06-10 | Mueller | Gregory R. | Keene, Shirley & Associates, Inc. 3997 | 1987-06-19 | Keene, Shirley & Associates, Inc. | 919 Prince Street | Alexandria | VA | 22314 | |
24469 | 24469 | 1974-07-30 | 1972-03-21 | Mueller | Gerald | Austrian Trade Commissioner in the U.S., Chicago 874 | 1955-02-21 | Austrian Trade Commissioner in the U.S., Chicago | 500 North Michigan Avenue | Suite 1950 | Chicago | IL | 60611 |
24470 | 24470 | 1974-07-30 | 1973-11-28 | Mueller | Gerald | Austrian National Tourist Office, Midwest Office 2457 | 1973-09-04 | Austrian National Tourist Office, Midwest Office | 500 North Michigan Avenue | Suite 1950 | Chicago | IL | 60611 |
25562 | 25562 | 1988-08-01 | 1957-08-02 | Mueller | William C. | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
29035 | 29035 | 1993-09-02 | 1991-02-28 | Mueller | Gregory R. | Creative Response Concepts 4477 | 1991-02-28 | Creative Response Concepts | 1150 South Washington Street | Suite 230 | Alexandria | VA | 22314-2824 |
30565 | 30565 | 2018-09-26 | 2018-03-07 | Mueller | Stephanie Chapman | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
32776 | 32776 | 1994-10-14 | 1989-06-05 | Mueller | Erwin | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | 40 West 57th Street | New York | NY | 10019-4092 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_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]) );