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

68 rows where "Short_Form_Termination_Date" is on date 2007-12-31 and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
41525 41525 2007-12-31 2005-01-03 Thompson Scott Christian Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
41526 41526 2007-12-31 1995-01-09 Maxwell Rosemary Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
41527 41527 2007-12-31 2006-01-25 Bacchus James L. Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41528 41528 2007-12-31 2006-01-25 Jessel Arturo Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41529 41529 2007-12-31 2006-01-25 Neeley Jeff Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41530 41530 2007-12-31 2006-01-25 Reiff Laura Foote Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41531 41531 2007-12-31 2008-01-28 Boyer Steven Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41532 41532 2007-12-31 2007-01-29 Henderson Wallace J. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
41533 41533 2007-12-31 2008-01-29 Gadoua Caitlin Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41534 41534 2007-12-31 2008-01-29 Goehring Kristal Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41535 41535 2007-12-31 2008-01-29 Husemann Claudia Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41536 41536 2007-12-31 2008-01-29 Hutter Lindalyn L. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41537 41537 2007-12-31 2008-01-29 McConnell Heather Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41538 41538 2007-12-31 2008-01-29 Race Eileen M. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41539 41539 2007-12-31 2008-01-29 Rao Aditi Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41540 41540 2007-12-31 2008-01-29 Richmond Cari Michelle Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41541 41541 2007-12-31 2008-01-29 Schneier Susan Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41542 41542 2007-12-31 2008-01-29 Vu Christine Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41544 41544 2007-12-31 2007-02-12 Wood Julie CLS Strategies 5774 2006-10-06 CLS Strategies 1850 M Street, NW Suite 900 Washington DC 20036
41546 41546 2007-12-31 2002-03-06 Yuen Barbara Y. Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
41547 41547 2007-12-31 2007-03-30 Stedman Louellen Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
41548 41548 2007-12-31 2005-03-31 Frechette Myles Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
41549 41549 2007-12-31 2004-04-23 Allen Christopher Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
41550 41550 2007-12-31 1999-05-17 Collinson J. Nicole Bivens 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
41551 41551 2007-12-31 2003-05-21 Robinson Curtis QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41552 41552 2007-12-31 2007-05-30 Tragakis Charles Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41553 41553 2007-12-31 2005-06-10 Meltz Elizabeth Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41554 41554 2007-12-31 2004-06-15 Friedman Francine E. Hunton & Williams, LLP 5627 2004-06-15 Hunton & Williams, LLP 1900 K Street, N.W. Suite 1200 Washington DC 20006
41556 41556 2007-12-31 2007-06-21 Bearden Milton Hunton & Williams, LLP 5627 2004-06-15 Hunton & Williams, LLP 1900 K Street, N.W. Suite 1200 Washington DC 20006
41557 41557 2007-12-31 2007-06-21 Cors Dylan D. Hunton & Williams, LLP 5627 2004-06-15 Hunton & Williams, LLP 1900 K Street, N.W. Suite 1200 Washington DC 20006
41558 41558 2007-12-31 1985-07-09 Mannion Robert E. Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
41559 41559 2007-12-31 2006-08-02 Baird Patrick M. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41560 41560 2007-12-31 2006-08-02 Robinson Melissa Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41561 41561 2007-12-31 2004-08-09 Melady Margaret B. Melady Associates 5637 2004-08-09 Melady Associates 3016 Tilden Street, N.W. Suite 401 Washington DC 20008
41562 41562 2007-12-31 2004-08-09 Melady Thomas P. Melady Associates 5637 2004-08-09 Melady Associates 3016 Tilden Street, N.W. Suite 401 Washington DC 20008
41563 41563 2007-12-31 2007-08-09 Crane Emily Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41564 41564 2007-12-31 2007-08-09 Layman Heather Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41565 41565 2007-12-31 2007-08-09 Nelson Deborah Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41566 41566 2007-12-31 2007-08-09 Stegeman Saskia Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41567 41567 2007-12-31 2007-08-10 O'Keeffe Tim Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41568 41568 2007-12-31 2007-08-10 O'Neill Dana Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41569 41569 2007-12-31 2007-08-10 Andersen Jay Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41570 41570 2007-12-31 2007-08-10 Hutchison Adam Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41571 41571 2007-12-31 2007-08-10 Maya Luis Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41572 41572 2007-12-31 2007-08-10 Morgan Janelle Nicole Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41573 41573 2007-12-31 2007-08-10 Reynolds Joshua Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41574 41574 2007-12-31 2007-08-10 Talleda Eneida Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41575 41575 2007-12-31 2007-08-29 Cross Kelly Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
41576 41576 2007-12-31 2007-09-19 Roth Susan M+R Strategic Services 5829 2007-09-19 M+R Strategic Services 2120 L Street, NW Suite 600 Washington DC 20037
41577 41577 2007-12-31 2005-09-30 Lewis Rita M. Washington Group 5711 2005-09-30 Washington Group 1401 K Street, NW Suite 1000 Washington DC 20005-3422
41578 41578 2007-12-31 2006-10-03 Giffin Gordon D. McKenna Long & Aldridge, LLP 5772 2006-10-03 McKenna Long & Aldridge, LLP 1900 K Street, NW   Washington DC 20006
41579 41579 2007-12-31 2006-10-03 Nuckolls Charles Randall McKenna Long & Aldridge, LLP 5772 2006-10-03 McKenna Long & Aldridge, LLP 1900 K Street, NW   Washington DC 20006
41580 41580 2007-12-31 2007-10-05 John Ullyot Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41581 41581 2007-12-31 2007-10-05 Ullyot John Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41582 41582 2007-12-31 2006-10-10 Oyman Idil CLS Strategies 5774 2006-10-06 CLS Strategies 1850 M Street, NW Suite 900 Washington DC 20036
41583 41583 2007-12-31 2007-10-15 Siebert Thomas L. Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41584 41584 2007-12-31 2006-10-25 Alderson Kelly CLS Strategies 5774 2006-10-06 CLS Strategies 1850 M Street, NW Suite 900 Washington DC 20036
41585 41585 2007-12-31 2006-10-25 Castillo Sharon J. CLS Strategies 5774 2006-10-06 CLS Strategies 1850 M Street, NW Suite 900 Washington DC 20036
41586 41586 2007-12-31 2006-10-25 Cortinas-Garcia Juan CLS Strategies 5774 2006-10-06 CLS Strategies 1850 M Street, NW Suite 900 Washington DC 20036
41587 41587 2007-12-31 2006-10-25 McCallum Erin CLS Strategies 5774 2006-10-06 CLS Strategies 1850 M Street, NW Suite 900 Washington DC 20036
41589 41589 2007-12-31 2006-11-14 Mulveny Jennifer 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
41590 41590 2007-12-31 2007-12-04 Leacox Jeffrey Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41591 41591 2007-12-31 2007-12-04 Livingston Carol Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41592 41592 2007-12-31 2007-12-04 Livingston Gene Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41593 41593 2007-12-31 2007-12-04 Terry Parke Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41594 41594 2007-12-31 2007-12-04 White Adam Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
41595 41595 2007-12-31 1998-12-07 Travis Thomas G. 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
41596 41596 2007-12-31 2006-12-08 Miller Montserrat Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037

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