FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Short_Form_Last_Name = "McGuire"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 9
- Ronny Caire Advertising Agency, Inc. 1
- Tromson Monroe Advertising, Inc. 1
- Office of the Deputy Commissioner of Maritime Affairs, R.L. 1
- Liberian Services, Inc. 1
- Capital Services of Washington, Inc. 1
- Aviso, Inc. 1
- International Registries, Inc. 1
- Ketchum Inc. NY 1
- Brownstein Hyatt Farber Schreck, LLP 1
Registrant_Name 9
- Aviso, Inc. 1
- Brownstein Hyatt Farber Schreck, LLP 1
- Capital Services of Washington, Inc. 1
- International Registries, Inc. 1
- Ketchum Inc. NY 1
- Liberian Services, Inc. 1
- Office of the Deputy Commissioner of Maritime Affairs, R.L. 1
- Ronny Caire Advertising Agency, Inc. 1
- Tromson Monroe Advertising, Inc. 1
City 6
- New York 4
- Alameda 1
- Denver 1
- New Orleans 1
- Reston 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
813 | 813 | 2021-04-16 | McGuire | Brian | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 | |
2977 | 2977 | 2016-01-01 | 2014-11-05 | McGuire | Darryl Hamilton | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
9051 | 9051 | 1994-03-03 | 1991-07-01 | McGuire | James E. | International Registries, Inc. 4533 | 1991-07-01 | International Registries, Inc. | 11495 Commerce Park Drive | Reston | VA | 20191-1506 | |
20721 | 20721 | 1962-06-30 | 1962-01-04 | McGuire | Katherine Daly | Ronny Caire Advertising Agency, Inc. 1504 | 1961-12-29 | Ronny Caire Advertising Agency, Inc. | 704 Cigali Building | New Orleans | LA | ||
27764 | 27764 | 1990-08-30 | 1990-02-27 | McGuire | Kara M. | Capital Services of Washington, Inc. 4175 | 1988-09-13 | Capital Services of Washington, Inc. | 1802 T Street, N.W. | Washington | DC | 20009 | |
28224 | 28224 | 1993-08-31 | 1990-04-12 | McGuire | James E. | Liberian Services, Inc. 2719 | 1976-09-15 | Liberian Services, Inc. | 551 Fifth Avenue | New York | NY | 10176 | |
28233 | 28233 | 1993-08-31 | 1987-08-12 | McGuire | James Erwin | Office of the Deputy Commissioner of Maritime Affairs, R.L. 2606 | 1975-09-12 | Office of the Deputy Commissioner of Maritime Affairs, R.L. | 551 Fifth Avenue | New York | NY | 10176 | |
30978 | 30978 | 1986-09-30 | 1973-01-09 | McGuire | John Morton | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | 450 Park Avenue, South | New York | NY | 10016 | |
31929 | 31929 | 1993-10-01 | 1991-03-28 | McGuire | Janet | Aviso, Inc. 4220 | 1989-02-22 | Aviso, Inc. | 1150 Marina Village Parkway | Suite 104 | Alameda | CA | 94501 |
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]) );