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

37 rows where "Short_Form_Termination_Date" is on date 2006-08-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date)

Registration_Number 14

  • Hill and Knowlton Strategies, LLC 15
  • Shearman & Sterling, LLP 4
  • United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 3
  • Widmeyer Communications, Inc. 3
  • Burson-Marsteller 2
  • Zuckert, Scoutt & Rasenberger, L.L.P. 2
  • Bermuda Tourism Authority 1
  • VisitBritain 1
  • Singapore Economic Development Board 1
  • Hogan Lovells US LLP 1
  • White & Case, LLP 1
  • GoodWorks International, LLC 1
  • Stanton Communications 1
  • GAGE International, LLC 1

Registrant_Name 14

  • Hill and Knowlton Strategies, LLC 15
  • Shearman & Sterling, LLP 4
  • United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 3
  • Widmeyer Communications, Inc. 3
  • Burson-Marsteller 2
  • Zuckert, Scoutt & Rasenberger, L.L.P. 2
  • Bermuda Tourism Authority 1
  • GAGE International, LLC 1
  • GoodWorks International, LLC 1
  • Hogan Lovells US LLP 1
  • Singapore Economic Development Board 1
  • Stanton Communications 1
  • VisitBritain 1
  • White & Case, LLP 1

State 3

  • DC 26
  • NY 8
  • CA 3

City 3

  • Washington 26
  • New York 8
  • Fresno 3
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
28453 28453 2006-08-31 2005-01-05 Majorosova Pavlina Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28454 28454 2006-08-31 2005-01-05 Meyer Don Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28455 28455 2006-08-31 2005-01-05 Sendelbach Patricia Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28456 28456 2006-08-31 2006-01-05 Law Tat-Win Singapore Economic Development Board 2003 1967-02-02 Singapore Economic Development Board 55 East 59th Street Suite 21 B, 21st Floor New York NY 10022
28457 28457 2006-08-31 2001-01-24 Hymel Gary Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28458 28458 2006-08-31 2005-01-26 Butterfield Christin Bermuda Tourism Authority 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
28459 28459 2006-08-31 2006-01-30 Austin Marcia Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28460 28460 2006-08-31 2006-01-30 Bottary Leo Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28461 28461 2006-08-31 2006-01-30 Drevna Nathan Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28462 28462 2006-08-31 2006-01-30 Griscti Paul Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28463 28463 2006-08-31 2006-01-30 Vocke Elizabeth Freid Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28464 28464 2006-08-31 2006-01-30 Williams Molly Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28465 28465 2006-08-31 2005-02-25 Koslowe Neil H. Shearman & Sterling, LLP 5670 2005-02-25 Shearman & Sterling, LLP 599 Lexington Avenue   New York NY 10022-6069
28466 28466 2006-08-31 2005-02-25 Wilner Thomas B. Shearman & Sterling, LLP 5670 2005-02-25 Shearman & Sterling, LLP 599 Lexington Avenue   New York NY 10022-6069
28467 28467 2006-08-31 2006-03-15 Johnson Jeffrey C. GAGE International, LLC 5739 2006-03-15 GAGE International, LLC 122 C Street, NW Suite 380 Washington DC 20001
28468 28468 2006-08-31 1988-03-29 Carneal George U. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
28469 28469 2006-08-31 2004-04-28 Rimi Aisha GoodWorks International, LLC 5414 2001-03-02 GoodWorks International, LLC 1700 K Street NW Suite 430 Washington DC 20006-3806
28470 28470 2006-08-31 2006-06-01 Marti Monica D. Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
28471 28471 2006-08-31 2005-06-10 Costello Harold J. (Harry) Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28472 28472 2006-08-31 1994-08-01 Trinder Rachel B. Zuckert, Scoutt & Rasenberger, L.L.P. 4933 1994-08-01 Zuckert, Scoutt & Rasenberger, L.L.P. 888 - 17th Street, N.W. Suite 700 Washington DC 20006-3309
28473 28473 2006-08-31 2006-08-02 Andrews Mary Catherine Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28474 28474 2006-08-31 2006-08-02 Gebhart Devon Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28475 28475 2006-08-31 2006-08-02 Helmick Susan Elizabeth Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28476 28476 2006-08-31 2004-08-11 Vang Dang United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 5639 2004-08-11 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 4903 E. Kings Canyon Road Suite 221 Fresno CA 93727
28477 28477 2006-08-31 2004-08-11 Vang Hue United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 5639 2004-08-11 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 4903 E. Kings Canyon Road Suite 221 Fresno CA 93727
28478 28478 2006-08-31 2004-08-11 Vangyi Shur V. United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 5639 2004-08-11 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 4903 E. Kings Canyon Road Suite 221 Fresno CA 93727
28479 28479 2006-08-31 2003-08-20 Howe Jonathan Zuckert, Scoutt & Rasenberger, L.L.P. 4933 1994-08-01 Zuckert, Scoutt & Rasenberger, L.L.P. 888 - 17th Street, N.W. Suite 700 Washington DC 20006-3309
28480 28480 2006-08-31 2005-08-30 Engleka C. Henry Widmeyer Communications, Inc. 5706 2005-08-30 Widmeyer Communications, Inc. 1825 Connecticut Avenue, NW Fifth Floor Washington DC 20009
28481 28481 2006-08-31 2005-08-30 Moniz Paul J. Widmeyer Communications, Inc. 5706 2005-08-30 Widmeyer Communications, Inc. 1825 Connecticut Avenue, NW Fifth Floor Washington DC 20009
28482 28482 2006-08-31 2005-08-30 Widmeyer Scott Widmeyer Communications, Inc. 5706 2005-08-30 Widmeyer Communications, Inc. 1825 Connecticut Avenue, NW Fifth Floor Washington DC 20009
28483 28483 2006-08-31 2005-09-26 Davenport Maureen Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28484 28484 2006-08-31 2005-09-30 Lo Laurelle C. Shearman & Sterling, LLP 5670 2005-02-25 Shearman & Sterling, LLP 599 Lexington Avenue   New York NY 10022-6069
28485 28485 2006-08-31 2005-09-30 Shafer Amanda E. Shearman & Sterling, LLP 5670 2005-02-25 Shearman & Sterling, LLP 599 Lexington Avenue   New York NY 10022-6069
28486 28486 2006-08-31 2005-10-04 Reid Justin VisitBritain 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
28487 28487 2006-08-31 2002-11-12 Mullaney Kelley Rodane Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
28488 28488 2006-08-31 2005-11-15 Prados Javier White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
28489 28489 2006-08-31 2005-12-23 Stanton Peter V. Stanton Communications 5724 2005-12-23 Stanton Communications 1150 Connecticut Avenue, NW Suite 810 Washington DC 20036

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