home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

80 rows where "Short_Form_Termination_Date" is on date 1991-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)

Registration_Number >30

  • Doremus, Porter & Novelli 16
  • Squire Patton Boggs, LLP 4
  • Frankl, Wolfe J. 4
  • GCI Group, Inc. 4
  • Edward Aycoth & Company, Inc. 4
  • Hori & Bunker, Inc. 3
  • Law Offices of Jonathan W. Cuneo 3
  • International Public Relations Company, Ltd. 2
  • New Zealand Tourist & Publicity Office 2
  • White & Case, LLP 2
  • Hill and Knowlton Strategies, LLC 2
  • Yorkshire & Humberside Development Association, California 2
  • Weill & Paxton 2
  • Thomson-CSF, Inc. 2
  • International Registries, Inc. 2
  • Netherlands Chamber of Commerce in the U.S., Inc. 1
  • Cleary, Gottlieb, Steen & Hamilton, LLP 1
  • Amtorg Trading Corporation 1
  • Milbank, Tweed, Hadley & McCloy 1
  • Tourism Authority of Thailand, New York 1
  • Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
  • Shaw, Pittman, Potts & Trowbridge 1
  • Arent Fox Kintner Plotkin & Kahn, PLLC 1
  • Mayer, Brown & Platt 1
  • Curacao Tourist Board, New York 1
  • Jones Day 1
  • Friends of Fianna Fail, Inc. 1
  • Saatchi & Saatchi North America, Inc. 1
  • Korea International Trade Association 1
  • Collier Shannon Scott, PLLC 1
  • …

Registrant_Name >30

  • Doremus, Porter & Novelli 16
  • Edward Aycoth & Company, Inc. 4
  • Frankl, Wolfe J. 4
  • GCI Group, Inc. 4
  • Squire Patton Boggs, LLP 4
  • Hori & Bunker, Inc. 3
  • Law Offices of Jonathan W. Cuneo 3
  • Hill and Knowlton Strategies, LLC 2
  • International Public Relations Company, Ltd. 2
  • International Registries, Inc. 2
  • New Zealand Tourist & Publicity Office 2
  • Thomson-CSF, Inc. 2
  • Weill & Paxton 2
  • White & Case, LLP 2
  • Yorkshire & Humberside Development Association, California 2
  • Amtorg Trading Corporation 1
  • Arent Fox Kintner Plotkin & Kahn, PLLC 1
  • Cadwalader, Wickersham & Taft 1
  • Cleary, Gottlieb, Steen & Hamilton, LLP 1
  • Cliff Madison Government Relations, Inc. 1
  • Collier Shannon Scott, PLLC 1
  • Curacao Tourist Board, New York 1
  • Davis Wright Tremaine 1
  • Farella, Braun & Martel 1
  • Friends of Fianna Fail, Inc. 1
  • Grey Entertainment & Media, Inc. 1
  • Invest Northern Ireland 1
  • Jones Day 1
  • Korea International Trade Association 1
  • MWW/Strategic Communications, Inc. 1
  • …

City 10

  • Washington 43
  • New York 23
  • Newton 3
  • Arlington 2
  • Jackson 2
  • Palo Alto 2
  • Reston 2
  • Bannockburn 1
  • Bethesda 1
  • San Francisco 1

State 8

  • DC 43
  • NY 23
  • VA 4
  • CA 3
  • MA 3
  • MS 2
  • IL 1
  • MD 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
40655 40655 1991-12-31 1986-01-07 Styles Deborah M. Styles, Deborah M. 3924 1987-01-07 Styles, Deborah M. 1706 - 18th Street, N.W.   Washington DC 20009
40656 40656 1991-12-31 1985-01-16 Wirth Henry H. Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40657 40657 1991-12-31 1988-01-21 Kelley Sheila S. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40658 40658 1991-12-31 1988-01-21 Lawrence Robert C. , III Cadwalader, Wickersham & Taft 4083 1988-01-21 Cadwalader, Wickersham & Taft 1333 New Hampshire Avenue, NW Suite 700 Washington DC 20036
40659 40659 1991-12-31 1988-01-21 Palmer Nina Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40660 40660 1991-12-31 1988-01-21 Pomerantz Joel S. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40661 40661 1991-12-31 1988-01-21 Sennett Lawrence Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40662 40662 1991-12-31 1988-01-21 Seymour Gerald Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40663 40663 1991-12-31 1988-01-21 Truesdell Wesley E. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40664 40664 1991-12-31 1988-01-21 Truitt Richard H. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40665 40665 1991-12-31 1988-01-26 Arnold R. Arthur Netherlands Chamber of Commerce in the U.S., Inc. 456 1947-04-16 Netherlands Chamber of Commerce in the U.S., Inc. One Rockefeller Plaza   New York NY 10020
40666 40666 1991-12-31 1991-01-31 Davison Jaymi GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40667 40667 1991-12-31 1991-01-31 Perez Maria Isabel GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40668 40668 1991-12-31 1991-01-31 Siegmann Robert J. GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40669 40669 1991-12-31 1991-02-04 III John Hudson Edward Aycoth & Company, Inc. 4436 1990-11-14 Edward Aycoth & Company, Inc. 1667 K Street, N.W. Suite 340 Washington DC 20006
40670 40670 1991-12-31 1982-02-11 de Boer Kurt W. Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40671 40671 1991-12-31 1982-02-16 Bechtle J.R. Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40672 40672 1991-12-31 1976-02-18 Efron Samuel 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
40673 40673 1991-12-31 1991-02-20 Levy David E. International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd. 352 Park Avenue, South Suite 705 New York NY 10010
40674 40674 1991-12-31 1991-02-20 Porwick Julie Grey Entertainment & Media, Inc. 4473 1991-02-20 Grey Entertainment & Media, Inc. 875 Third Avenue   New York NY 10022
40675 40675 1991-12-31 1981-03-10 Hernandez Eitel Curacao Tourist Board, New York 3209 1981-03-10 Curacao Tourist Board, New York 475 Park Avenue, South Suite 2000 New York NY 10016
40676 40676 1991-12-31 1986-03-11 Connolly John P. Friends of Fianna Fail, Inc. 3596 1984-06-08 Friends of Fianna Fail, Inc. C/O Richardson Mahon Casey & Rooney, LLP 1270 Avenue of the Americas #2911 New York NY 10020
40677 40677 1991-12-31 1988-03-25 Luxton-Jones Roger Yorkshire & Humberside Development Association, California 3706 1985-07-24 Yorkshire & Humberside Development Association, California 435 Tasso Street Suite 140 Palo Alto CA 94301
40678 40678 1991-12-31 1988-03-25 White-Hunt Keith Yorkshire & Humberside Development Association, California 3706 1985-07-24 Yorkshire & Humberside Development Association, California 435 Tasso Street Suite 140 Palo Alto CA 94301
40679 40679 1991-12-31 1990-04-09 Obeidat Thamer A. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
40680 40680 1991-12-31 1990-04-13 O'Hare Declan Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
40681 40681 1991-12-31 1987-04-17 Rose Jonathan C. Jones Day 3427 1982-12-10 Jones Day 51 Louisiana Avenue, N.W.   Washington DC 20001-2113
40682 40682 1991-12-31 1989-04-19 Wilson Scott A. Maupin Taylor Ellis & Adams, P.C. 4242 1989-04-19 Maupin Taylor Ellis & Adams, P.C. 1130 Connecticut Avenue, N.W. Suite 750 Washington DC 20036
40683 40683 1991-12-31 1991-04-23 Rokit David J. International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd. 352 Park Avenue, South Suite 705 New York NY 10010
40684 40684 1991-12-31 1980-04-28 Phillips William E. 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
40685 40685 1991-12-31 1989-05-18 Kim Dae-Kyum Korea International Trade Association 3636 1984-12-21 Korea International Trade Association 1800 K Street, N.W. Suite 700 Washington DC 20006
40686 40686 1991-12-31 1990-06-05 Cohen Edward B. Davis Wright Tremaine 4382 1990-06-05 Davis Wright Tremaine 701 Pennsylvania Avenue, N.W. Suite 600 Washington DC 20004
40687 40687 1991-12-31 1979-06-15 Jones Carleton S. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40688 40688 1991-12-31 1987-06-16 Kronmiller Theodore G. Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
40689 40689 1991-12-31 1985-06-24 Allen Pamela Joyce Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC 3050 K Street N.W. Suite 400 Washington DC 20007-5108
40690 40690 1991-12-31 1986-07-11 Velasquez Rose GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
40691 40691 1991-12-31 1991-07-12 LaPlace John P. MWW/Strategic Communications, Inc. 4542 1991-07-12 MWW/Strategic Communications, Inc. 1101 - 17th Street, N.W. Suite 202 Washington DC 20036
40692 40692 1991-12-31 1989-07-17 Bunker Earl Henry Hori & Bunker, Inc. 4272 1989-07-17 Hori & Bunker, Inc. 290 Centre Street   Newton MA 02158
40693 40693 1991-12-31 1989-07-17 Ito Yuko Hori & Bunker, Inc. 4272 1989-07-17 Hori & Bunker, Inc. 290 Centre Street   Newton MA 02158
40694 40694 1991-12-31 1990-07-23 Phillips Robert Bruce Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
40695 40695 1991-12-31 1991-08-08 Banner Roger H. International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
40696 40696 1991-12-31 1991-08-08 Hawken Wendell International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
40697 40697 1991-12-31 1989-08-11 Paxton John Weill & Paxton 4280 1989-08-11 Weill & Paxton 405 Tombigbee Street   Jackson MS 39201
40698 40698 1991-12-31 1989-08-11 Weill Jeff Weill & Paxton 4280 1989-08-11 Weill & Paxton 405 Tombigbee Street   Jackson MS 39201
40699 40699 1991-12-31 1971-08-13 Connick Andrew J. Milbank, Tweed, Hadley & McCloy 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
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
40701 40701 1991-12-31 1990-08-17 Astoriano Michael 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
40702 40702 1991-12-31 1985-08-23 Winchester Maxwell E. New Zealand Tourist & Publicity Office 2328 1972-03-27 New Zealand Tourist & Publicity Office 630 Fifth Avenue Suite 530 New York NY 10111
40703 40703 1991-12-31 1988-08-24 Messick Richard Edward Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
40704 40704 1991-12-31 1987-08-27 Cady Donald H. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40705 40705 1991-12-31 1987-08-27 Devine John P. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40706 40706 1991-12-31 1987-08-27 Druckenmiller Robert Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40707 40707 1991-12-31 1987-08-27 Gould Robert J. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40708 40708 1991-12-31 1987-08-27 Nichols David A. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40709 40709 1991-12-31 1987-08-27 Pederson Wayne Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40710 40710 1991-12-31 1987-08-27 Porter John H. Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40711 40711 1991-12-31 1987-08-27 Rose Merrill Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40712 40712 1991-12-31 1987-08-27 Snyder Danny Doremus, Porter & Novelli 4031 1987-08-27 Doremus, Porter & Novelli 1001 - 30th Street, N.W.   Washington DC 20007
40713 40713 1991-12-31 1990-08-29 Meblin Samuel D. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
40714 40714 1991-12-31 1990-08-30 Grillo Joseph M. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
40715 40715 1991-12-31 1989-09-07 Liao Robert C. Hori & Bunker, Inc. 4272 1989-07-17 Hori & Bunker, Inc. 290 Centre Street   Newton MA 02158
40716 40716 1991-12-31 1991-09-23 Sanders David G. Washington Public Affairs Group 4543 1991-07-15 Washington Public Affairs Group 5910 Woodacres Drive   Bethesda MD 20816
40717 40717 1991-12-31 1989-09-29 Cohen Sheldon S. Morgan, Lewis & Bockius, L.L.P. 3794 1986-03-12 Morgan, Lewis & Bockius, L.L.P. 1111 Pennsylvania Avenue, N.W.   Washington DC 20004
40718 40718 1991-12-31 1989-10-04 Kambolin Anatoly E. Amtorg Trading Corporation 596 1949-11-07 Amtorg Trading Corporation 15 West 36th Street 6th Floor New York NY 10018
40719 40719 1991-12-31 1988-10-07 Chauvet Isabelle White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
40720 40720 1991-12-31 1990-10-09 Hoyle Brian J. Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
40721 40721 1991-12-31 1991-10-09 Wangsai Paisan Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
40722 40722 1991-12-31 1978-11-06 Marans J. Eugene Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP 2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
40723 40723 1991-12-31 1990-11-14 Aycoth John Edward Edward Aycoth & Company, Inc. 4436 1990-11-14 Edward Aycoth & Company, Inc. 1667 K Street, N.W. Suite 340 Washington DC 20006
40724 40724 1991-12-31 1990-11-14 Fiske David Holland Edward Aycoth & Company, Inc. 4436 1990-11-14 Edward Aycoth & Company, Inc. 1667 K Street, N.W. Suite 340 Washington DC 20006
40725 40725 1991-12-31 1990-11-14 Walker Reid Allen Edward Aycoth & Company, Inc. 4436 1990-11-14 Edward Aycoth & Company, Inc. 1667 K Street, N.W. Suite 340 Washington DC 20006
40726 40726 1991-12-31 1987-11-19 Madison Cliff Cliff Madison Government Relations, Inc. 4060 1987-11-19 Cliff Madison Government Relations, Inc. 208-A Justice Court, N.E.   Washington DC 20002
40727 40727 1991-12-31 1990-11-30 Bell James D. Thomson-CSF, Inc. 4447 1990-11-29 Thomson-CSF, Inc. 2231 Crystal Drive   Arlington VA 22202
40728 40728 1991-12-31 1990-12-03 Farella Frank E. Farella, Braun & Martel 4443 1990-12-03 Farella, Braun & Martel 235 Montgomery Street Suite 3000 San Francisco CA 94104
40729 40729 1991-12-31 1990-12-07 Mathias Charles McC. , Jr. Thomson-CSF, Inc. 4447 1990-11-29 Thomson-CSF, Inc. 2231 Crystal Drive   Arlington VA 22202
40730 40730 1991-12-31 1979-12-13 Smith Richard M. Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt 2000 Pennsylvania Avenue, N.W.   Washington DC 20006-1882
40731 40731 1991-12-31 1984-12-14 Spiller Hans-Juergen Frankl, Wolfe J. 3173 1980-12-01 Frankl, Wolfe J. Berlin Economic Develop. Corp. 767 Third Avenue New York NY 10017
40732 40732 1991-12-31 1990-12-17 Cuneo Jonathan W. Law Offices of Jonathan W. Cuneo 4448 1990-12-17 Law Offices of Jonathan W. Cuneo 1300 I Street, N.W. East Tower, Suite 480 Washington DC 20005
40733 40733 1991-12-31 1990-12-17 Duncan Daniel C. Law Offices of Jonathan W. Cuneo 4448 1990-12-17 Law Offices of Jonathan W. Cuneo 1300 I Street, N.W. East Tower, Suite 480 Washington DC 20005
40734 40734 1991-12-31 1990-12-17 Schweitzer James J. Law Offices of Jonathan W. Cuneo 4448 1990-12-17 Law Offices of Jonathan W. Cuneo 1300 I Street, N.W. East Tower, Suite 480 Washington DC 20005

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])
);
Powered by Datasette · Queries took 703.734ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history