FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_Last_Name = "Maguire"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 14
- Brownstein Hyatt Farber Schreck, LLP 3
- Government of Ontario, Canada 1
- AC&R Public Relations 1
- Enterprise Ireland 1
- White & Case, LLP 1
- M. Silver Associates, Inc. 1
- Manufactured Imports and Investment Promotion Organization (MIPRO) 1
- Ablondi, Foster, Sobin & Davidow, P.C. 1
- Hill and Knowlton Strategies, LLC 1
- Buchanan & Ingersoll, Professional Corporation 1
- Holland & Knight 1
- Crowell & Moring International, LLC 1
- Porter/Novelli 1
- Medley Global Advisors 1
Registrant_Name 14
- Brownstein Hyatt Farber Schreck, LLP 3
- AC&R Public Relations 1
- Ablondi, Foster, Sobin & Davidow, P.C. 1
- Buchanan & Ingersoll, Professional Corporation 1
- Crowell & Moring International, LLC 1
- Enterprise Ireland 1
- Government of Ontario, Canada 1
- Hill and Knowlton Strategies, LLC 1
- Holland & Knight 1
- M. Silver Associates, Inc. 1
- Manufactured Imports and Investment Promotion Organization (MIPRO) 1
- Medley Global Advisors 1
- Porter/Novelli 1
- White & Case, LLP 1
City 3
- Washington 7
- New York 6
- Denver 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
810 | 810 | 2019-04-16 | Maguire | Douglas | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 | |
4358 | 4358 | 1996-01-24 | 1989-08-22 | Maguire | Robert T. | Ablondi, Foster, Sobin & Davidow, P.C. 3235 | 1981-05-04 | Ablondi, Foster, Sobin & Davidow, P.C. | 1150 18th Street, N.W. | Suite 900 | Washington | DC | 20036-4129 |
14948 | 14948 | 2007-04-30 | 2006-01-12 | Maguire | Paul | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
16787 | 16787 | 2018-05-20 | 2017-12-06 | Maguire | Douglas | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
17306 | 17306 | 2002-05-28 | 1991-03-26 | Maguire | Sioban | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 |
19048 | 19048 | 1990-06-08 | 1989-02-14 | Maguire | Mary | Manufactured Imports and Investment Promotion Organization (MIPRO) 3196 | 1981-02-05 | Manufactured Imports and Investment Promotion Organization (MIPRO) | 1225 19th Street, NW | Suite 310 | Washington | DC | 20036 |
26278 | 26278 | 1998-08-08 | 1992-02-03 | Maguire | Amelia | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | 800 17th Street, N.W. | Suite 1100 | Washington | DC | 20006 |
27702 | 27702 | 1985-08-29 | 1982-11-30 | Maguire | Edward | Buchanan & Ingersoll, Professional Corporation 3423 | 1982-11-30 | Buchanan & Ingersoll, Professional Corporation | 1667 K Street, N.W. | Suite 900 | Washington | DC | 20006 |
31291 | 31291 | 2002-09-30 | 2002-03-11 | Maguire | John | Medley Global Advisors 5484 | 2002-03-11 | Medley Global Advisors | 451 Greenwich Street | 6th Floor | New York | NY | 10013 |
31888 | 31888 | 1985-10-01 | 1987-05-21 | Maguire | Jennifer | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
32387 | 32387 | 2017-10-06 | 2017-02-07 | Maguire | Douglas | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
35364 | 35364 | 1986-11-07 | 1984-09-18 | Maguire | J. Robert | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35632 | 35632 | 2009-11-11 | 2007-03-13 | Maguire | Jennifer | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 747 Third Avenue, 23rd Floor | New York | NY | 10017-2803 | |
35806 | 35806 | 1974-11-15 | 1973-10-26 | Maguire | Ann | AC&R Public Relations 2431 | 1973-06-12 | AC&R Public Relations | 136 Madison Avenue | New York | NY | 10016 | |
38393 | 38393 | 1985-12-15 | 1983-05-25 | Maguire | Robert A. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
40853 | 40853 | 1995-12-31 | 1992-05-18 | Maguire | Susan | Porter/Novelli 4671 | 1992-05-18 | Porter/Novelli | 1909 K Street | Suite 400 | Washington | DC | 20006 |
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]) );