FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

88 rows where Short_Form_First_Name = "John" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_2, Zip, Short_Form_Date (date)

City 3

State 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
68 68   2020-01-06 Coster John Teneo Strategy LLC 6698 2019-07-08 Teneo Strategy LLC 280 Park Avenue 4th Floor New York NY 10017
1678 1678   2022-08-28 Hearty John IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
2658 2658 1987-01-01 1985-10-30 Mitchem John N.W. Ayer & Son, Inc. 3411 1982-09-27 N.W. Ayer & Son, Inc. 1345 Avenue of the Americas   New York NY 10105
2695 2695 1990-01-01 1973-07-02 Connolly John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
2818 2818 2004-01-01 1997-05-15 Corrigan John Enterprise Ireland 2518 1974-06-08 Enterprise Ireland Ireland House 345 Park Avenue, 17th Floor New York NY 10154-0037
3255 3255 2014-01-05 2014-02-06 Banks-Brooks John BLJ Worldwide LTD 5875 2008-06-17 BLJ Worldwide LTD 1359 Broadway Suite 1102 New York NY 10018
3788 3788 1987-01-15 1985-06-12 McElhone John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
4034 4034 1990-01-18 1988-09-16 Soltez John 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
4212 4212 1988-01-21 1987-05-08 Pollock John Warren/Kremer Advertising, Inc. 3977 1987-05-08 Warren/Kremer Advertising, Inc. 2 Park Avenue 18th Floor New York NY 10016
4240 4240 1951-01-22 1947-07-24 Briears John Australian Information Service 418 1946-12-31 Australian Information Service 636 Fifth Avenue   New York NY 10020
4342 4342 1989-01-24 1986-05-08 Ogilvie John Ogilvie, Taylor & Associates, Inc. 3830 1986-05-08 Ogilvie, Taylor & Associates, Inc. 380-2L Rector Place   New York NY 10280
5676 5676 1970-02-01 1964-01-20 Duerkop John National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
6722 6722 1979-02-13 1977-03-30 Odongkara John Free Ugandas 2767 1977-03-30 Free Ugandas C/O Godfrey L. Binaisa 30 Park Avenue, Apartment 5L Mount Vernon NY 10550
6796 6796 1971-02-14 1964-12-09 de Garmo John De Garmo-McCaffery, Inc. 1821 1964-11-25 De Garmo-McCaffery, Inc. 205 East 42nd Street   New York NY 10017
6924 6924 1979-02-15 1978-04-25 Ward John FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
7634 7634 1993-02-25 1990-08-03 Herschend John GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
7636 7636 1993-02-25 1990-08-03 Ordway John GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
7853 7853 1968-02-28 1965-09-30 Gres John Marathon International Productions, Inc. 1695 1964-02-28 Marathon International Productions, Inc. 10 East 49th Street   New York NY 10017
8665 8665 1970-03-01 1967-05-01 Wardle John VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
8914 8914 2019-03-01 2017-04-27 Sklencar John VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
9287 9287 2019-03-06 2017-11-03 Whitcomb John FTI Consulting (SC), Inc. 6484 2017-11-03 FTI Consulting (SC), Inc. 88 Pine Street, 32nd Floor   New York NY 10005
9896 9896 1963-03-15 1963-01-11 Asch John Foreign Research & Development Corporation 1589 1963-01-11 Foreign Research & Development Corporation 575 Madison Avenue   New York NY  
9904 9904 1969-03-15 1956-08-02 Oliver John Development & Resources Corporation 969 1956-08-02 Development & Resources Corporation 44 Wall Street   New York NY  
10030 10030 1966-03-16 1965-05-13 O'Keefe John Sydney Morrell & Company, Inc. 1661 1963-10-11 Sydney Morrell & Company, Inc. 152 East 78th Street   New York NY 10021
10411 10411 1951-03-21 1950-06-08 Carroll John Foreign Supply Company, Inc. 627 1950-06-08 Foreign Supply Company, Inc. 141 Broadway   New York NY  
10514 10514 1994-03-22 1993-01-21 Cantarella John Ogilvy, Adams & Rinehart, Inc. 4455 1990-12-28 Ogilvy, Adams & Rinehart, Inc. 708 Third Avenue 12th Floor New York NY 10017
10740 10740 1975-03-25 1973-07-30 Softness John Softness Group, Inc. 2444 1973-07-30 Softness Group, Inc. 635 Madison Avenue   New York NY 10022
10854 10854 1974-03-27 1965-10-25 Samokish John Package Express & Travel Agency, Inc. 1117 1958-02-24 Package Express & Travel Agency, Inc. 1776 Broadway   New York NY 10019
10938 10938 1972-03-28 1971-11-08 Brandt John Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. 301 East 57th Street   New York NY 10022
11183 11183 2000-03-30 1996-11-29 Dorr John Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
11649 11649 1991-03-31 1985-10-03 Hopkinson John Government of Ontario, Canada 2087 1968-04-11 Government of Ontario, Canada 800 Third Avenue Suite 2800 New York NY 10022
11908 11908 2003-03-31 1995-06-14 Collins John Friends of Sinn Fein, Inc. 5006 1995-04-03 Friends of Sinn Fein, Inc. 1212 Avenue of the Americas 5th Floor New York NY 10036
12243 12243 2019-03-31 2017-05-24 Frazier John Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 48 W 38th Street, 12th Floor   New York NY 10018
12773 12773 1974-04-05 1973-05-01 Savage John Communetics, Inc. 2421 1973-05-01 Communetics, Inc. 485 Madison Avenue   New York NY 10022
12997 12997 1985-04-09 1966-05-13 Skwirtniansky John Package Express & Travel Agency, Inc. 1117 1958-02-24 Package Express & Travel Agency, Inc. 1776 Broadway   New York NY 10019
15332 15332 1974-05-01 1971-04-06 McGowan John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
16793 16793 2020-05-20 2020-05-20 Diviney John Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
17778 17778 1995-05-31 1992-02-14 Cochary John Saatchi & Saatchi North America, Inc. 3605 1984-07-24 Saatchi & Saatchi North America, Inc. Saatchi & Saatchi Building 375 Hudson Street, 10th Floor New York NY 10014-3620
17798 17798 1995-05-31 1994-02-24 Morrison John Saatchi & Saatchi North America, Inc. 3605 1984-07-24 Saatchi & Saatchi North America, Inc. Saatchi & Saatchi Building 375 Hudson Street, 10th Floor New York NY 10014-3620
18445 18445 1981-06-01 1971-04-06 McCarthy John Irish Northern Aid Committee 2239 1971-01-29 Irish Northern Aid Committee 345 Park Avenue 17th Floor, #536 New York NY 10154
18918 18918 2009-06-05 1999-05-10 Sirabella John National Film Board of Canada 437 1944-04-21 National Film Board of Canada 1123 Broadway Suite 307 New York NY 10010
21095 21095 1988-06-30 1985-06-26 Lyons John IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
21505 21505 2004-06-30 2002-07-26 Walsh John South African Tourism 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
23367 23367 1991-07-16 1990-05-02 Henderson John Gavin Anderson Doremus & Company 3378 1982-06-15 Gavin Anderson Doremus & Company 11 West 42nd Street 8th Floor New York NY 10036
23447 23447 1952-07-18 1951-03-06 Wattawa John Poore, John G. 663 1951-03-06 Poore, John G. 27 William Street   New York NY  
23602 23602 1971-07-19 1968-12-02 Loughran John Koppe International, Ltd. 2115 1968-12-02 Koppe International, Ltd. 610 Fifth Avenue   New York NY 10020
23707 23707 1972-07-21 1972-07-03 Savage John Communetics, Inc. 2352 1972-07-03 Communetics, Inc. 485 Madison Avenue   New York NY 10022
23951 23951 1968-07-24 1967-10-03 Lane John Oliver-Beckman, Inc. 2009 1967-03-01 Oliver-Beckman, Inc. Post Office Box 676   New York NY 10021
24163 24163 1960-07-27 1956-11-14 Scotto John Compagnie Generale Transatlantique (French Line) 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
24323 24323 2009-07-28 2009-07-01 O'Donnell, Jr. John Mariner Group 5941 2009-06-17 Mariner Group 4900 Clark Street   Hamburg NY 14075
24333 24333 2017-07-28 2017-04-07 Files III John IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
24740 24740 1985-07-31 1977-03-24 Brion John Doremus & Company 2319 1972-02-18 Doremus & Company 120 Broadway   New York NY 10271
24812 24812 1990-07-31 1978-09-22 McLaughlin John Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. 555 Madison Avenue 12th Floor New York NY 10022
25196 25196 2013-07-31 2008-10-10 Mulqueen John Spring O'Brien & Company, Inc. 5872 2008-06-30 Spring O'Brien & Company, Inc. 20 W 22nd Street Suite 906 New York NY 10010
26276 26276 1996-08-08 1990-11-07 Ploetz John FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
28111 28111 1987-08-31 1986-03-27 Frazier John Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd. 220 Fifth Avenue 3rd Floor New York NY 10001
28719 28719 1950-09-01 1949-11-03 Fisher John Centex, Inc. 598 1949-11-03 Centex, Inc. 465 Lexington Avenue   New York NY  
29330 29330 1989-09-07 1983-10-28 Littlewood John N.W. Ayer & Son, Inc. 3411 1982-09-27 N.W. Ayer & Son, Inc. 1345 Avenue of the Americas   New York NY 10105
29732 29732 1992-09-14 1991-09-12 Scardino John 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
29740 29740 1993-09-14 1992-02-28 Baskind John Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group 14 East 60th Street   New York NY 10022
29748 29748 1993-09-14 1991-06-11 Scanlon John Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group 14 East 60th Street   New York NY 10022
30337 30337 1951-09-24 1950-11-30 Hodul John Centex, Inc. 598 1949-11-03 Centex, Inc. 465 Lexington Avenue   New York NY  
30763 30763 2006-09-29 1990-04-09 Narducci John White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
31198 31198 1998-09-30 1997-04-15 Frazier John Patrice Tanaka & Company, Inc. 5162 1997-03-11 Patrice Tanaka & Company, Inc. 320 West 13th Street 7th Floor New York NY 10014
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
31480 31480 2009-09-30 2007-10-15 Nugent John IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
31936 31936 1993-10-01 1991-10-17 Roberts John Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group 14 East 60th Street   New York NY 10022
32334 32334 1993-10-05 1990-11-07 Bertram John FCB New York 2415 1973-03-28 FCB New York 100 West 33rd Street   New York NY 10001
32542 32542 1953-10-10 1951-05-08 Holy John Slovak National Council Abroad, U.S. Branch 667 1951-04-10 Slovak National Council Abroad, U.S. Branch 34 Park Row   New York NY  
32799 32799 1944-10-15 1944-09-22 Dewey John American Members of the Institut de France, Inc. 245 1944-04-15 American Members of the Institut de France, Inc. Hotel Savoy Plaza 5th Avenue & 59th Street New York NY  
33404 33404 1986-10-22 1978-11-07 Reinsberg John Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. 420 Lexington Avenue   New York NY 10017
33526 33526 1961-10-24 1961-03-22 Adams John Brooks, William F. 1373 1960-06-27 Brooks, William F. 366 Madison Avenue   New York NY  
34252 34252 1984-10-31 1983-12-02 Boland John Hill & Knowlton, Inc. 2740 1976-12-17 Hill & Knowlton, Inc. 420 Lexington Avenue   New York NY 10017
34334 34334 1991-10-31 1991-09-30 Buckley John IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
34488 34488 2003-10-31 2001-04-13 Frazier John Patrice Tanaka & Company, Inc. 5426 2001-04-13 Patrice Tanaka & Company, Inc. 320 West 13th Street 7th Floor New York NY 10016
36548 36548 1991-11-29 1985-11-01 O'Brien John IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
37179 37179 2021-11-30 2021-01-28 Nolan John Ruder Finn, Inc. 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
37391 37391 1987-12-01 1987-12-07 Krasina John Van Brunt & Company Advertising-Marketing, Inc. 1704 1964-04-02 Van Brunt & Company Advertising-Marketing, Inc. 7 Dey Street   New York NY 10017
38576 38576 2016-12-17 2016-04-22 Zagame John Park Strategies, LLC 6350 2016-04-22 Park Strategies, LLC 101 Park Avenue Suite 2506 New York NY 10178
39962 39962 1974-12-31 1971-04-20 Miller John Marplan Research, Inc. 2124 1969-02-26 Marplan Research, Inc. 485 Lexington Avenue   New York NY 10017
40114 40114 1980-12-31 1976-01-17 Stevens John Parke-Scott, Ltd 2735 1976-11-17 Parke-Scott, Ltd 502 Park Avenue   New York NY 10022
41403 41403 2005-12-31 2004-03-25 Staffen John Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41408 41408 2005-12-31 2004-05-20 Bateman John South African Tourism 603 1950-01-04 South African Tourism 500 Fifth Avenue 22nd Floor, Suite 2200 New York NY 10110-0002
41415 41415 2005-12-31 2002-06-05 Fischetti John Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41418 41418 2005-12-31 2002-06-05 Policano John Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41625 41625 2008-12-31 2007-06-05 O'Hanlon John Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
41807 41807 2012-12-31 2009-02-04 Zagame John Park Strategies, LLC 5908 2009-01-09 Park Strategies, LLC 101 Park Avenue Suite 2506 New York NY 10178
41947 41947 2014-12-31 2013-07-26 Isaf John IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);