FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
37 rows where Short_Form_First_Name = "John D."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number >30
- Wilmer, Cutler & Pickering 3
- Hill and Knowlton Strategies, LLC 2
- GCI Group, Inc. 2
- Cummings, Sellers, Reeves & Conner 1
- U.S. Office of the British Broadcasting Corporation 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Pan-American Public Relations, Ltd. 1
- Jamaica Tourist Board, New York 1
- Ogilvy & Mather, Inc. 1
- Jamaica Tourist Board, Chicago 1
- New Zealand Government Tourist Office 1
- Doremus & Company 1
- New Zealand Tourist & Publicity Office 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Arent Fox Kintner Plotkin & Kahn, PLLC 1
- John D. Brady & Associates, Inc. 1
- Winston Advertising, Inc. 1
- Washington International Group, Inc. 1
- O'Melveny & Myers 1
- COGEMA, Inc. 1
- Fleishman-Hillard, Inc. 1
- Goodwin Procter, LLP 1
- Miner, Fraser & Gabriel Public Affairs, Inc. 1
- Washington Group 1
- Jellinek, Schwartz & Connolly, Inc. 1
- Icon Group 1
- Leventhal, Senter & Lerman, PLLC 1
- American Worldwide Inc. 1
- Mohamed, Koshin A. 1
- Washington Group 1
- …
Registrant_Name >30
- Wilmer, Cutler & Pickering 3
- GCI Group, Inc. 2
- Hill and Knowlton Strategies, LLC 2
- Washington Group 2
- American Worldwide Inc. 1
- Arent Fox Kintner Plotkin & Kahn, PLLC 1
- Ashcroft Law Firm, LLC 1
- COGEMA, Inc. 1
- Capitol Counsel, LLC 1
- Cummings, Sellers, Reeves & Conner 1
- Doremus & Company 1
- Fleishman-Hillard, Inc. 1
- Goodwin Procter, LLP 1
- Greenberg Traurig, LLP 1
- Icon Group 1
- Jamaica Tourist Board, Chicago 1
- Jamaica Tourist Board, New York 1
- Jellinek, Schwartz & Connolly, Inc. 1
- John D. Brady & Associates, Inc. 1
- Leventhal, Senter & Lerman, PLLC 1
- Miner, Fraser & Gabriel Public Affairs, Inc. 1
- Mohamed, Koshin A. 1
- New Zealand Government Tourist Office 1
- New Zealand Tourist & Publicity Office 1
- O'Melveny & Myers 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Ogilvy & Mather, Inc. 1
- Pan-American Public Relations, Ltd. 1
- Squire, Sanders & Dempsey, L.L.P. 1
- U.S. Office of the British Broadcasting Corporation 1
- …
City 12
- Washington 17
- New York 9
- Bethesda 2
- Arlington 1
- Bronxville 1
- Chicago 1
- Houston 1
- Kansas City 1
- Kent 1
- Los Angeles 1
- Palo Alto 1
- St. Louis 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43 | 43 | Raffaelli | John D. | Mohamed, Koshin A. 5653 | 2004-10-26 | Mohamed, Koshin A. | 1215 Central Avenue South | Suite 215 | Kent | WA | 98032-7437 | ||
3059 | 3059 | 1986-01-02 | 1981-12-31 | Wickett | John D. | Winston Advertising, Inc. 3319 | 1981-12-31 | Winston Advertising, Inc. | 3530 West Bayshore Road | Palo Alto | CA | 94303 | |
3823 | 3823 | 2006-01-15 | 2005-09-30 | Raffaelli | John D. | Washington Group 5711 | 2005-09-30 | Washington Group | 1401 K Street, NW | Suite 1000 | Washington | DC | 20005-3422 |
3973 | 3973 | 1995-01-17 | 1994-03-11 | Greenwald | John D. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
4101 | 4101 | 1996-01-19 | 1991-08-12 | Bergen | John D. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
7979 | 7979 | 1991-02-28 | 1988-06-30 | Bergen | John D. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
9056 | 9056 | 1995-03-03 | 1987-03-25 | Lawrence | John D. | Washington International Group, Inc. 3320 | 1982-01-05 | Washington International Group, Inc. | 815 Connecticut Avenue, N.W. | Suite 800 | Washington | DC | 20006 |
11684 | 11684 | 1992-03-31 | 1991-11-08 | Greenwald | John D. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
13226 | 13226 | 1993-04-12 | 1982-05-13 | Holum | John D. | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | 555 - 13th Street, N.W. | Suite 500 West | Washington | DC | 20004 |
14870 | 14870 | 2002-04-30 | 2001-04-06 | Moore | John D. | American Worldwide Inc. 5425 | 2001-04-06 | American Worldwide Inc. | 3 Bethesda Metro Center | Suite 600 | Bethesda | MD | 20814-6332 |
15637 | 15637 | 1994-05-03 | 1974-08-12 | Walker | John D. | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
15929 | 15929 | 1989-05-08 | 1984-05-08 | Greenwald | John D. | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | 2445 M Street, N.W. | Washington | DC | 20037-1420 | |
17492 | 17492 | 2001-05-30 | 1986-10-30 | Aldock | John D. | Goodwin Procter, LLP 3901 | 1986-10-30 | Goodwin Procter, LLP | 901 New York Avenue, N.W. | Washington | DC | 20001 | |
18276 | 18276 | 2023-05-31 | 2017-06-09 | Ashcroft | John D. | Ashcroft Law Firm, LLC 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2710 | Kansas City | MO | 64105 |
18689 | 18689 | 2013-06-02 | 2007-11-29 | Altenburg, Jr. | John D. | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | 2101 L Street, NW | Suite 1000 | Washington | DC | 20037 |
19544 | 19544 | 1987-06-15 | 1978-01-04 | Cummins | John D. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
20837 | 20837 | 1971-06-30 | 1970-10-20 | Walker | John D. | Ogilvy & Mather, Inc. 1826 | 1964-12-03 | Ogilvy & Mather, Inc. | 2 East 48th Street | New York | NY | 10017 | |
22711 | 22711 | 1994-07-07 | 1993-05-11 | Forbes | John D. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
22838 | 22838 | 1982-07-09 | 1981-10-08 | Brady | John D. | John D. Brady & Associates, Inc. 3288 | 1981-10-08 | John D. Brady & Associates, Inc. | 1 West Loop, South | Suite 206 | Houston | TX | 77027 |
24922 | 24922 | 1998-07-31 | 1989-06-12 | Atkins | John D. | COGEMA, Inc. 3587 | 1984-05-17 | COGEMA, Inc. | 7401 Wisconsin Avenue | Bethesda | MD | 20814-3416 | |
24973 | 24973 | 2000-07-31 | 1994-07-08 | Forbes | John D. | Icon Group 4926 | 1994-07-08 | Icon Group | 130 Pondfield Road | Suite 1 | Bronxville | NY | 10708 |
26003 | 26003 | 2004-08-05 | 1986-02-05 | Graham | John D. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
26155 | 26155 | 1981-08-07 | 1981-03-23 | Husband | John D. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
26943 | 26943 | 1991-08-18 | 1976-02-18 | Hushon | John D. | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | 1976-02-18 | Arent Fox Kintner Plotkin & Kahn, PLLC | 1050 Connecticut Ave., NW #500 | Washington | DC | 20036-5339 | |
27207 | 27207 | 1988-08-22 | 1988-03-11 | Sparks | John D. | Miner, Fraser & Gabriel Public Affairs, Inc. 4022 | 1987-08-11 | Miner, Fraser & Gabriel Public Affairs, Inc. | 1025 Connecticut Avenue, N.W. | Suite 700 | Washington | DC | 20036 |
31004 | 31004 | 1987-09-30 | 1986-08-07 | Gordley | John D. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
31078 | 31078 | 1991-09-30 | 1979-10-03 | Lynch | John D. | Jamaica Tourist Board, Chicago 2118 | 1968-12-16 | Jamaica Tourist Board, Chicago | 4655 S. Dr. Martin Luther King Drive | Suite 201 | Chicago | IL | 60653 |
31374 | 31374 | 2007-09-30 | 1997-03-04 | Poutasse | John D. | Leventhal, Senter & Lerman, PLLC 5161 | 1997-03-04 | Leventhal, Senter & Lerman, PLLC | 2000 K Street, N.W. | Suite 600 | Washington | DC | 20006-1809 |
34006 | 34006 | 1958-10-30 | 1957-05-18 | Wareham | John D. | Pan-American Public Relations, Ltd. 1019 | 1957-04-30 | Pan-American Public Relations, Ltd. | 375 Fifth Avenue | New York | NY | ||
34316 | 34316 | 1991-10-31 | 1990-02-23 | Freshman | John D. | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
34321 | 34321 | 1991-10-31 | 1979-04-19 | Rasmussen | John D. | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | 10960 Wilshire Boulevard | Suite 1530 | Los Angeles | CA | 90024 |
34804 | 34804 | 1960-11-01 | 1957-03-18 | Conner | John D. | Cummings, Sellers, Reeves & Conner 420 | 1947-01-09 | Cummings, Sellers, Reeves & Conner | 1616 K Street, N.W. | Washington | DC | ||
35183 | 35183 | 2014-11-03 | 2014-09-26 | Raffaelli | John D. | Capitol Counsel, LLC 6253 | 2014-09-26 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
39379 | 39379 | 1988-12-30 | 1973-04-10 | Humphrys | John D. | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
40257 | 40257 | 1983-12-31 | 1982-06-21 | Lynch | John D. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
40700 | 40700 | 1991-12-31 | 1985-08-13 | Rasmussen | John D. | New Zealand Tourist & Publicity Office 2328 | 1972-03-27 | New Zealand Tourist & Publicity Office | 630 Fifth Avenue | Suite 530 | New York | NY | 10111 |
41069 | 41069 | 1998-12-31 | 1990-01-18 | Raffaelli | John D. | Washington Group 4332 | 1990-01-18 | Washington Group | 1401 K Street, N.W. | Suite 400 | 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]) );