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

43 rows where "Short_Form_Termination_Date" is on date 1991-12-31 and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

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