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

51 rows where "Short_Form_Termination_Date" is on date 2003-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 27

  • GCI Group, Inc. 6
  • Manatt, Phelps & Phillips 4
  • Downey McGrath Group, Inc. 4
  • Dellums, Brauer, Halterman & Associates, LLC 4
  • Geoffrey Weill Associates Inc. 4
  • QORVIS LLC 3
  • Donald N. Martin & Company, Inc. 2
  • Symms, Lehn & Associates, Inc. 2
  • Loeffler Group, LLP 2
  • American Continental Group 2
  • Ethiopian Medhin Democratic Association 2
  • St. Lucia National Development Corporation 1
  • Korea National Tourism Organization, Chicago 1
  • Jones Day 1
  • IPG DXTRA, Inc 1
  • Invest Northern Ireland 1
  • International Registries, Inc. 1
  • APCO Worldwide, Inc. 1
  • Sandler, Travis & Rosenberg, P.A. 1
  • Van Scoyoc Associates, Inc. 1
  • Brian Bruh Associates LLC 1
  • Brouillard Communications 1
  • Arnold Worldwide/NY 1
  • Baker & McKenzie, LLP 1
  • Bockorny, Petrizzo, Inc. 1
  • Pepperwood International Corporation 1
  • Appia Group LLC 1

Registrant_Name 27

  • GCI Group, Inc. 6
  • Dellums, Brauer, Halterman & Associates, LLC 4
  • Downey McGrath Group, Inc. 4
  • Geoffrey Weill Associates Inc. 4
  • Manatt, Phelps & Phillips 4
  • QORVIS LLC 3
  • American Continental Group 2
  • Donald N. Martin & Company, Inc. 2
  • Ethiopian Medhin Democratic Association 2
  • Loeffler Group, LLP 2
  • Symms, Lehn & Associates, Inc. 2
  • APCO Worldwide, Inc. 1
  • Appia Group LLC 1
  • Arnold Worldwide/NY 1
  • Baker & McKenzie, LLP 1
  • Bockorny, Petrizzo, Inc. 1
  • Brian Bruh Associates LLC 1
  • Brouillard Communications 1
  • IPG DXTRA, Inc 1
  • International Registries, Inc. 1
  • Invest Northern Ireland 1
  • Jones Day 1
  • Korea National Tourism Organization, Chicago 1
  • Pepperwood International Corporation 1
  • Sandler, Travis & Rosenberg, P.A. 1
  • St. Lucia National Development Corporation 1
  • Van Scoyoc Associates, Inc. 1

City 10

  • Washington 22
  • New York 15
  • Oakland 4
  • Alexandria 2
  • Chicago 2
  • Silver Spring 2
  • Bannockburn 1
  • Houston 1
  • Potomac 1
  • Reston 1

State 7

  • DC 22
  • NY 15
  • CA 4
  • IL 3
  • MD 3
  • VA 3
  • TX 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
41293 41293 2003-12-31 2003-01-09 Bergner Jeffrey T. Bockorny, Petrizzo, Inc. 5555 2003-01-09 Bockorny, Petrizzo, Inc. 1101 16th Street, N.W. Suite 500 Washington DC 20036
41294 41294 2003-12-31 2001-02-13 Downey Thomas J. Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41295 41295 2003-12-31 2001-02-13 Painter Sally Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41296 41296 2003-12-31 1998-02-25 Khodra Petula St. Lucia National Development Corporation 2796 1977-06-24 St. Lucia National Development Corporation 800 2nd Avenue Suite 910 New York NY 10017-4709
41297 41297 2003-12-31 2003-02-25 Flusche Bernard A. GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
41298 41298 2003-12-31 2003-02-25 Osta Jean GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
41299 41299 2003-12-31 2003-02-27 Neeley Jeffrey S. Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41300 41300 2003-12-31 2001-03-06 Stein Donald Steven Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41301 41301 2003-12-31 2001-03-20 McGrath Raymond J. Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41302 41302 2003-12-31 2002-03-26 Morse Casey Beth Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41303 41303 2003-12-31 2000-03-30 Rowe Lorraine S. Henderson International Registries, Inc. 4533 1991-07-01 International Registries, Inc. 11495 Commerce Park Drive   Reston VA 20191-1506
41304 41304 2003-12-31 1989-04-19 Bradfield Michael Jones Day 3427 1982-12-10 Jones Day 51 Louisiana Avenue, N.W.   Washington DC 20001-2113
41305 41305 2003-12-31 1999-04-27 Louison Deborah APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. 700 12th Street, NW Suite 800 Washington DC 20005
41306 41306 2003-12-31 2003-04-29 Bell Christine T. IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
41307 41307 2003-12-31 1995-05-01 Martin Neil S. Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. One Rockefeller Plaza Suite 214 New York NY 10020
41308 41308 2003-12-31 1998-05-29 Altschuler Irwin P. Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41309 41309 2003-12-31 2003-05-29 Hannaford Peter D. Pepperwood International Corporation 5574 2003-05-29 Pepperwood International Corporation 1615 L Street, N.W. Suite 900 Washington DC 20036-5610
41310 41310 2003-12-31 2001-05-30 Hwang Kee-Hak Korea National Tourism Organization, Chicago 3069 1979-11-23 Korea National Tourism Organization, Chicago 737 North Michigan Avenue Suite 910 Chicago IL 60611
41311 41311 2003-12-31 2002-05-31 Franz Mark Allan Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
41312 41312 2003-12-31 2002-06-05 Quero Nicole Arnold Worldwide/NY 5500 2002-06-05 Arnold Worldwide/NY 110 Fifth Avenue   New York NY 10011
41313 41313 2003-12-31 2003-06-13 Birnbaum Rise Jill QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41314 41314 2003-12-31 2003-06-13 Laschever Ann Rebecca Geoffrey Weill Associates Inc. 5563 2003-06-13 Geoffrey Weill Associates Inc. 27 West 24th Street   New York NY 10010
41315 41315 2003-12-31 2003-06-13 Philip Tania Geoffrey Weill Associates Inc. 5563 2003-06-13 Geoffrey Weill Associates Inc. 27 West 24th Street   New York NY 10010
41316 41316 2003-12-31 2003-06-13 Rodgers Janet Geoffrey Weill Associates Inc. 5563 2003-06-13 Geoffrey Weill Associates Inc. 27 West 24th Street   New York NY 10010
41317 41317 2003-12-31 2003-06-13 Rutimann Sophie Geoffrey Weill Associates Inc. 5563 2003-06-13 Geoffrey Weill Associates Inc. 27 West 24th Street   New York NY 10010
41318 41318 2003-12-31 2003-06-26 Wolde Goshu Ethiopian Medhin Democratic Association 5565 2003-06-26 Ethiopian Medhin Democratic Association 8115 Fenton Street Suite 305 Silver Spring MD 20910
41319 41319 2003-12-31 2003-06-26 Woldeyohannes Bisrat Ethiopian Medhin Democratic Association 5565 2003-06-26 Ethiopian Medhin Democratic Association 8115 Fenton Street Suite 305 Silver Spring MD 20910
41320 41320 2003-12-31 2003-07-03 Roberts David Van Scoyoc Associates, Inc. 5401 2000-12-14 Van Scoyoc Associates, Inc. 800 Maine Avenue, SW Suite 800 Washington DC 20024
41321 41321 2003-12-31 2001-07-26 Dellums Cynthia Lewis Dellums, Brauer, Halterman & Associates, LLC 5442 2001-06-18 Dellums, Brauer, Halterman & Associates, LLC 1736 Franklin Street Suite 500 Oakland CA 94612
41322 41322 2003-12-31 2001-07-26 Dellums Ronald V. Dellums, Brauer, Halterman & Associates, LLC 5442 2001-06-18 Dellums, Brauer, Halterman & Associates, LLC 1736 Franklin Street Suite 500 Oakland CA 94612
41323 41323 2003-12-31 2001-07-26 Halterman H. Lee Dellums, Brauer, Halterman & Associates, LLC 5442 2001-06-18 Dellums, Brauer, Halterman & Associates, LLC 1736 Franklin Street Suite 500 Oakland CA 94612
41324 41324 2003-12-31 2001-07-26 Stephenson Charles C. Dellums, Brauer, Halterman & Associates, LLC 5442 2001-06-18 Dellums, Brauer, Halterman & Associates, LLC 1736 Franklin Street Suite 500 Oakland CA 94612
41325 41325 2003-12-31 2007-07-31 Rossman-McKinney Kelly QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41326 41326 2003-12-31 2001-08-02 Mc Erlean Michael Invest Northern Ireland 4364 1990-04-13 Invest Northern Ireland 2201 Waukegan Road Suite 150 South Bannockburn IL 60015
41327 41327 2003-12-31 2003-08-08 Kishlicky Ann GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
41328 41328 2003-12-31 2003-08-08 Parkinson Shauna GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
41329 41329 2003-12-31 2002-08-12 Benedetto Allison GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
41330 41330 2003-12-31 2002-08-12 Zinn Patrick GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 825 Third Avenue 24th Floor New York NY 10022-7519
41331 41331 2003-12-31 2003-08-15 Mulder Steven J . Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41332 41332 2003-12-31 2003-08-20 Kandel Kara D. Appia Group LLC 5576 2003-08-20 Appia Group LLC 1101 Pennsylvania Avenue, N.W. Suite 700 Washington DC 20004-2520
41333 41333 2003-12-31 2001-08-27 Bruh Brian M. Brian Bruh Associates LLC 5404 2001-01-05 Brian Bruh Associates LLC 9401 Wooden Bridge Road   Potomac MD 20854
41334 41334 2003-12-31 2004-08-31 Hampe Carl W. Baker & McKenzie, LLP 5547 2003-03-24 Baker & McKenzie, LLP One Prudential Plaza 130 East Randolph Drive Chicago IL 60601
41335 41335 2003-12-31 2006-10-16 Walton Kenneth W. QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41336 41336 2003-12-31 2002-10-18 Miller Melissa Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. 1300 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20004-3002
41337 41337 2003-12-31 2003-10-22 Bierman Everett Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
41338 41338 2003-12-31 2002-11-01 Wagner John Brouillard Communications 5415 2001-03-16 Brouillard Communications 10111 Richmond Avenue Suite 375 Houston TX 77042
41339 41339 2003-12-31 1984-12-06 Friis-Jacobsen Hans C. Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. One Rockefeller Plaza Suite 214 New York NY 10020
41340 41340 2003-12-31 1995-12-12 Symms Steve Symms, Lehn & Associates, Inc. 4880 1993-12-21 Symms, Lehn & Associates, Inc. 127 South Fairfax Street Suite 137 Alexandria VA 22314-3301
41341 41341 2003-12-31 2002-12-19 Ross Steven G. American Continental Group 5536 2002-12-19 American Continental Group 2099 Pennsylvania Avenue, N.W. Suite 850 Washington DC 20006
41342 41342 2003-12-31 2002-12-19 Smeallie Shawn H. American Continental Group 5536 2002-12-19 American Continental Group 2099 Pennsylvania Avenue, N.W. Suite 850 Washington DC 20006
41343 41343 2003-12-31 1993-12-21 Lehn Alfred M. Symms, Lehn & Associates, Inc. 4880 1993-12-21 Symms, Lehn & Associates, Inc. 127 South Fairfax Street Suite 137 Alexandria VA 22314-3301

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 698.394ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history