FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Short_Form_Last_Name = "McGrath"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
- Casey, Lane & Mittendorf 1
- Clinton E. Frank, Inc., New York 1
- Clinton E. Frank, Inc. 1
- Barnes, Richardson & Colburn 1
- Jordan, McGrath, Case & Taylor, Inc. 1
- Invest Northern Ireland 1
- Carl Byoir & Associates 1
- Lord Group 1
- Downey McGrath Group, Inc. 1
- Arnold Worldwide/NY 1
- Downey McGrath Group, Inc. 1
Registrant_Name 10
City 3
- New York 7
- Washington 3
- Bannockburn 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4348 | 4348 | 1992-01-24 | 1991-09-09 | McGrath | George B. | Carl Byoir & Associates 4411 | 1990-09-12 | Carl Byoir & Associates | 420 Lexington Avenue | New York | NY | 10017 | |
6588 | 6588 | 1998-02-10 | 1989-08-08 | McGrath | Matthew T. | Barnes, Richardson & Colburn 2751 | 1977-02-10 | Barnes, Richardson & Colburn | 1225 Eye Street, N.W. | Suite 1150 | Washington | DC | 20005 |
8263 | 8263 | 2013-02-28 | 2012-08-07 | McGrath | Raymond J. | Downey McGrath Group, Inc. 6122 | 2012-08-07 | Downey McGrath Group, Inc. | 1225 I Street, NW | Suite 600 | Washington | DC | 20005 |
22497 | 22497 | 2021-07-02 | 2018-09-27 | McGrath | Michael | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
22955 | 22955 | 1978-07-11 | 1975-05-28 | McGrath | George E. | Clinton E. Frank, Inc. 2586 | 1975-05-28 | Clinton E. Frank, Inc. | 866 Third Avenue | New York | NY | 10022 | |
26251 | 26251 | 1978-08-08 | 1964-05-08 | McGrath | John William , III | Casey, Lane & Mittendorf 1553 | 1962-07-02 | Casey, Lane & Mittendorf | 26 Broadway | New York | NY | 10004 | |
28304 | 28304 | 1997-08-31 | 1992-03-30 | McGrath | Anne Allen | Lord Group 4556 | 1991-08-14 | Lord Group | 810 Seventh Avenue | New York | NY | 10019 | |
33533 | 33533 | 1968-10-24 | 1964-01-22 | McGrath | George E. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
40596 | 40596 | 1989-12-31 | 1982-12-23 | McGrath | Patrick J. | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
41264 | 41264 | 2002-12-31 | 2002-06-05 | McGrath | Patrick | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41301 | 41301 | 2003-12-31 | 2001-03-20 | McGrath | Raymond J. | Downey McGrath Group, Inc. 5411 | 2001-02-13 | Downey McGrath Group, Inc. | 1225 I Street, N.W. | Suite 600 | Washington | DC | 20005 |
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]) );