FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where Short_Form_Last_Name = "McDonald"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 22
- Doremus & Company 2
- Jack McDonald Associates, Inc. 2
- Hill and Knowlton Strategies, LLC 2
- DLA Piper US LLP 2
- Bermuda Tourism Authority 1
- Clinton E. Frank, Inc., New York 1
- Buchen Advertising, Inc. 1
- IDA Ireland 1
- Conant & Company Public Relations, Inc. 1
- United World Films, Inc. 1
- Government of Ontario, Canada 1
- White & Case, LLP 1
- Scottish Enterprise 1
- Jones Day 1
- Arter & Hadden 1
- Jack H. McDonald Company 1
- Lord Day & Lord, Barrett Smith 1
- JWI, LLC 1
- Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- APCO Worldwide, Inc. 1
- BerlinRosen Ltd. 1
Registrant_Name 22
- DLA Piper US LLP 2
- Doremus & Company 2
- Hill and Knowlton Strategies, LLC 2
- Jack McDonald Associates, Inc. 2
- APCO Worldwide, Inc. 1
- Arter & Hadden 1
- BerlinRosen Ltd. 1
- Bermuda Tourism Authority 1
- Buchen Advertising, Inc. 1
- Clinton E. Frank, Inc., New York 1
- Conant & Company Public Relations, Inc. 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- Government of Ontario, Canada 1
- IDA Ireland 1
- JWI, LLC 1
- Jack H. McDonald Company 1
- Jones Day 1
- Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP 1
- Lord Day & Lord, Barrett Smith 1
- Scottish Enterprise 1
- United World Films, Inc. 1
- White & Case, LLP 1
City 4
- Washington 13
- New York 11
- Cambridge 1
- Chicago 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2044 | 2044 | 2022-10-27 | McDonald | Jackson | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 | |
2810 | 2810 | 2003-01-01 | 2001-02-22 | McDonald | Michael K. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4245 | 4245 | 1968-01-22 | 1964-04-06 | McDonald | John M. | Buchen Advertising, Inc. 1689 | 1964-02-13 | Buchen Advertising, Inc. | 10 South Riverside Plaza | Chicago | IL | 60606 | |
4709 | 4709 | 1993-01-28 | 1982-12-10 | McDonald | Kevin D. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
6251 | 6251 | 1998-02-06 | 1990-12-06 | McDonald | Thomas F. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
7721 | 7721 | 1993-02-26 | 1990-08-29 | McDonald | Lillian E. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
13106 | 13106 | 2002-04-10 | 1993-10-28 | McDonald | Andrew Ronald | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
15110 | 15110 | 2018-04-30 | 2018-03-13 | McDonald | Devyn | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
15379 | 15379 | 1986-05-01 | 1979-07-13 | McDonald | Jack | Jack McDonald Associates, Inc. 3038 | 1979-07-13 | Jack McDonald Associates, Inc. | 1800 M Street, N.W. | Suite 950 North | Washington | DC | 20036 |
15816 | 15816 | 1991-05-06 | 1987-06-11 | McDonald | Jack H. | Jack H. McDonald Company 3956 | 1987-04-01 | Jack H. McDonald Company | 1001 Pennsylvania Avenue, N.W. | Suite 625 South | Washington | DC | 20004 |
16865 | 16865 | 1972-05-22 | 1969-08-15 | McDonald | Peter | United World Films, Inc. 1952 | 1966-01-14 | United World Films, Inc. | 221 Park Avenue, South | New York | NY | 10003 | |
23223 | 23223 | 1982-07-15 | 1981-12-31 | McDonald | James P. | Jack McDonald Associates, Inc. 3038 | 1979-07-13 | Jack McDonald Associates, Inc. | 1800 M Street, N.W. | Suite 950 North | Washington | DC | 20036 |
25173 | 25173 | 2011-07-31 | 2009-04-17 | McDonald | Michael Kirk | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP 5355 | 2000-01-31 | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP | 499 South Capitol Street, S.W. | Suite 600 | Washington | DC | 20003 |
27858 | 27858 | 1965-08-31 | 1965-05-27 | McDonald | James Joseph , Jr. | Conant & Company Public Relations, Inc. 1896 | 1965-05-27 | Conant & Company Public Relations, Inc. | 10 East 40th Street | New York | NY | ||
28242 | 28242 | 1994-08-31 | 1994-02-02 | McDonald | Joseph F. | Lord Day & Lord, Barrett Smith 4889 | 1994-02-02 | Lord Day & Lord, Barrett Smith | 1675 Broadway | New York | NY | 10019 | |
30496 | 30496 | 1985-09-26 | 1978-01-30 | McDonald | Jack H. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30497 | 30497 | 1985-09-26 | 1978-01-30 | McDonald | James P. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30564 | 30564 | 2018-09-26 | 2018-03-07 | McDonald | Andrew | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
33438 | 33438 | 2002-10-22 | 1998-08-27 | McDonald | Jack Harvey | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
33530 | 33530 | 1968-10-24 | 1964-01-21 | McDonald | William John | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
33742 | 33742 | 1972-10-28 | 1970-08-13 | McDonald | James P. | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
33771 | 33771 | 1993-10-28 | 1990-05-11 | McDonald | Peter R. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
34188 | 34188 | 1977-10-31 | 1976-03-22 | McDonald | Patrick Edward | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
34305 | 34305 | 1990-10-31 | 1987-05-12 | McDonald | Tom | Arter & Hadden 3942 | 1987-03-03 | Arter & Hadden | 1801 K Street, N.W. | Suite 400K | Washington | DC | 20006 |
36036 | 36036 | 2016-11-18 | 2012-12-31 | McDonald | Jackson C. | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 700 New Hampshire Avenue, NW | Watergate South, Suite 1019 | Washington | DC | 20037 |
40966 | 40966 | 1996-12-31 | 1980-03-28 | McDonald | Willis , IV | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );