FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where Short_Form_First_Name = "John W."
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date)
Registration_Number >30
- White & Case, LLP 2
- Korean-American Council 1
- Cummings, Sellers, Reeves & Conner 1
- Netherlands Board of Tourism and Conventions (NBTC) 1
- Hapag-Lloyd (America), Inc. 1
- Bennett Tours, Inc. 1
- Sydney Morrell & Company, Inc. 1
- Quebec Government Office 1
- Milbank, Tweed, Hadley & McCloy 1
- Shearman & Sterling 1
- Doremus & Company 1
- Connole & O'Connell 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Cambridge Reports, Inc. 1
- Foley, Lardner, Hollabaugh & Jacobs 1
- Hill and Knowlton Strategies, LLC 1
- Preston, Gates & Ellis, L.L.P. 1
- Brady & Berliner 1
- Daniel J. Edelman, Inc. 1
- IPG DXTRA, Inc 1
- AEGIS Insurance Services, Inc. (AISI) 1
- Kamber Group 1
- DeCamp Legal Services, P.C. 1
- Cassidy & Associates, Inc. 1
- Olsson, Frank & Weeda, P.C. 1
- McGuire, Woods, Battle & Boothe 1
- Olsson, Frank & Weeda, P.C. 1
- Nichols - Dezenhall Communications Management Group, Ltd. 1
- Brady & Berliner, PC 1
- Berliner, Candon & Jimison, PC 1
- …
Registrant_Name >30
- Olsson, Frank & Weeda, P.C. 2
- White & Case, LLP 2
- AEGIS Insurance Services, Inc. (AISI) 1
- Bennett Tours, Inc. 1
- Berliner, Candon & Jimison, PC 1
- Brady & Berliner 1
- Brady & Berliner, PC 1
- Cambridge Reports, Inc. 1
- Cassidy & Associates, Inc. 1
- Cogent Strategies LLC 1
- Connole & O'Connell 1
- Cummings, Sellers, Reeves & Conner 1
- Daniel J. Edelman, Inc. 1
- DeCamp Legal Services, P.C. 1
- Doremus & Company 1
- Foley, Lardner, Hollabaugh & Jacobs 1
- GR Pro, LLC 1
- Hapag-Lloyd (America), Inc. 1
- Hill and Knowlton Strategies, LLC 1
- IPG DXTRA, Inc 1
- Kamber Group 1
- Korean-American Council 1
- McGuire, Woods, Battle & Boothe 1
- Milbank, Tweed, Hadley & McCloy 1
- Netherlands Board of Tourism and Conventions (NBTC) 1
- Nichols - Dezenhall Communications Management Group, Ltd. 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Preston, Gates & Ellis, L.L.P. 1
- Quebec Government Office 1
- Shearman & Sterling 1
- …
City 8
- Washington 15
- New York 12
- Cambridge 1
- Jersey City 1
- Lincoln 1
- Oklahoma City 1
- Seattle 1
- Staten Island 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6044 | 6044 | 1978-02-03 | 1957-11-14 | Oelsner | John W. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
6366 | 6366 | 1977-02-08 | 1976-03-23 | Gorman | John W. | Cambridge Reports, Inc. 2670 | 1976-03-23 | Cambridge Reports, Inc. | 12-14 Mifflin Place | Cambridge | MA | 02138 | |
6538 | 6538 | 1989-02-10 | 1988-07-06 | Leslie | John W. | Kamber Group 4150 | 1988-07-06 | Kamber Group | 1920 L Street, N.W. | Washington | DC | 20036 | |
6551 | 6551 | 1992-02-10 | 1978-03-06 | Dean | John W. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
8953 | 8953 | 1960-03-02 | 1959-08-28 | Knudsen | John W. | Bennett Tours, Inc. 1260 | 1959-08-28 | Bennett Tours, Inc. | 290 Madison Avenue | New York | NY | ||
9972 | 9972 | 1993-03-15 | 1992-09-14 | Walker | John W. | 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 |
11790 | 11790 | 1998-03-31 | 1998-08-12 | Jimison | John W. | Brady & Berliner, PC 5222 | 1997-04-02 | Brady & Berliner, PC | 1225 19th Street, N.W. | Suite 800 | Washington | DC | 20036 |
12364 | 12364 | 1955-04-01 | 1949-02-08 | Cross | John W. | Cummings, Sellers, Reeves & Conner 420 | 1947-01-09 | Cummings, Sellers, Reeves & Conner | 1616 K Street, N.W. | Washington | DC | ||
12582 | 12582 | 2019-04-01 | 2018-01-09 | Anderson | John W. | Cogent Strategies LLC 6502 | 2017-12-21 | Cogent Strategies LLC | 2550 M Street, NW | 6th Floor | Washington | DC | 20037 |
13151 | 13151 | 1977-04-11 | 1965-04-22 | Weiser | John W. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
14658 | 14658 | 1994-04-30 | 1991-10-23 | Bode | John W. | Olsson, Frank & Weeda, P.C. 4580 | 1991-10-23 | Olsson, Frank & Weeda, P.C. | 1400 - 16th Street, N.W. | Suite 400 | Washington | DC | 20036-2220 |
14759 | 14759 | 1998-04-30 | 1997-04-21 | Bode | John W. | Olsson, Frank & Weeda, P.C. 5175 | 1997-04-21 | Olsson, Frank & Weeda, P.C. | 1400 - 16th Street, N.W. | Suite 400 | Washington | DC | 20036-2220 |
15256 | 15256 | 2021-04-30 | 2019-10-08 | Richardson III | John W. | GR Pro, LLC 6738 | 2019-10-08 | GR Pro, LLC | 316 N.W. 61st Street | Oklahoma City | OK | 73118 | |
20137 | 20137 | 1980-06-24 | 1978-07-21 | Byrnes | John W. | Foley, Lardner, Hollabaugh & Jacobs 2932 | 1978-07-21 | Foley, Lardner, Hollabaugh & Jacobs | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22240 | 22240 | 1993-07-01 | 1992-09-24 | Burke | John W. | McGuire, Woods, Battle & Boothe 4674 | 1992-05-27 | McGuire, Woods, Battle & Boothe | 1627 I Street, N.W. | Suite 1000 | Washington | DC | 20006 |
24331 | 24331 | 2017-07-28 | 2017-01-28 | Leslie Jr | John W. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
24381 | 24381 | 1997-07-29 | 1987-06-16 | Weber | John W. | AEGIS Insurance Services, Inc. (AISI) 3932 | 1987-01-29 | AEGIS Insurance Services, Inc. (AISI) | 10 Exchange Place | Jersey City | NJ | 07302 | |
29434 | 29434 | 1994-09-08 | 1989-04-14 | Jimison | John W. | Brady & Berliner 3656 | 1985-03-08 | Brady & Berliner | 1225 - 19th Street, N.W. | Suite 800 | Washington | DC | 20036 |
29476 | 29476 | 1988-09-09 | 1984-03-09 | Angus | John W. | Preston, Gates & Ellis, L.L.P. 3567 | 1984-03-22 | Preston, Gates & Ellis, L.L.P. | 5000 Columbia Center | 701 Fifth Avenue | Seattle | WA | 98104-7078 |
30256 | 30256 | 1976-09-22 | 1973-03-21 | O'Connell | John W. | Connole & O'Connell 2413 | 1973-03-21 | Connole & O'Connell | 1 Farragut Square, South | Washington | DC | 20006 | |
30529 | 30529 | 1985-09-26 | 1976-09-15 | O'Connell | John W. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30603 | 30603 | 1991-09-27 | 1972-02-28 | Serbrock | John W. | Netherlands Board of Tourism and Conventions (NBTC) 619 | 1950-03-20 | Netherlands Board of Tourism and Conventions (NBTC) | 215 Park Avenue South | Suite 1302 | New York | NY | 10003 |
35841 | 35841 | 1982-11-15 | 1982-11-15 | Sullivan | John W. | Sydney Morrell & Company, Inc. 1661 | 1963-10-11 | Sydney Morrell & Company, Inc. | 152 East 78th Street | New York | NY | 10021 | |
36820 | 36820 | 1996-11-30 | 1994-06-16 | King | John W. | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | 700 - 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
37858 | 37858 | 1946-12-07 | 1943-12-31 | Staggers | John W. | Korean-American Council 161 | 1942-12-07 | Korean-American Council | 1700 I Street, N.W. | Washington | DC | ||
38049 | 38049 | 1993-12-10 | 1992-11-25 | Wilson | John W. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
38120 | 38120 | 1990-12-11 | 1990-01-09 | Walker | John W. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
38126 | 38126 | 2002-12-11 | 2002-06-26 | Jimison | John W. | Berliner, Candon & Jimison, PC 5513 | 2002-06-26 | Berliner, Candon & Jimison, PC | 1225 19th Street, N.W. | Suite 800 | Washington | DC | 20036 |
39933 | 39933 | 1973-12-31 | 1974-01-21 | Sharp | John W. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
40620 | 40620 | 1990-12-31 | 1989-05-24 | DeCamp | John W. | DeCamp Legal Services, P.C. 4258 | 1989-05-24 | DeCamp Legal Services, P.C. | 300 Executive Building | 521 South 14th Street | Lincoln | NE | 68508 |
40780 | 40780 | 1994-12-31 | 1980-03-28 | Barnum | John W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41033 | 41033 | 1997-12-31 | 1997-06-05 | Weber | John W. | Nichols - Dezenhall Communications Management Group, Ltd. 5184 | 1997-06-05 | Nichols - Dezenhall Communications Management Group, Ltd. | 1211 Connecticut Avenue, N.W. | Suite 812 | Washington | DC | 20036 |
41196 | 41196 | 2000-12-31 | 1982-10-08 | Erickson | John W. | 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]) );