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

27 rows where Registration_Number = 5432

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Loeffler Group, LLP · 27 ✖

Registrant_Name 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
4639 4639 2005-01-27 2001-05-22 Plebani Jon W. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
4640 4640 2005-01-27 2002-05-31 Frazier Michael James Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
8234 8234 2009-02-28 2003-10-28 Kraker Marcus A. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
11186 11186 2002-03-30 2001-05-22 Cohen Daniel Lawrence Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
12649 12649 2007-04-02 2003-10-28 Christy David S. Jr. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
12650 12650 2007-04-02 2003-10-28 Parlin C. Christopher Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
15945 15945 2003-05-08 2003-01-29 Barnett Robert M. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
18046 18046 2009-05-31 2003-01-16 Martinez Jose E. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
18048 18048 2009-05-31 2005-03-14 Luskey Lane M. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
18049 18049 2009-05-31 2001-05-22 Loeffler Thomas G. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
18060 18060 2009-05-31 2003-10-28 Rickhoff Hans Christopher Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
20471 20471 2007-06-28 2004-05-13 Gullott Kristen Marie Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
23073 23073 2007-07-13 2005-07-14 Nelson Susan E. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
24316 24316 2006-07-28 2003-10-22 Farrell Cynthia Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
25049 25049 2004-07-31 2003-06-25 Rangel Noe Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
26776 26776 2008-08-15 2008-03-26 Ball III William L. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
30451 30451 2007-09-25 2007-06-04 Hession Margaret Marie Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
30452 30452 2007-09-25 2007-06-04 Tuggey Timothy Nolan Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
31360 31360 2006-09-30 2005-04-12 Mondello Joseph N. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
31368 31368 2007-09-30 2007-01-19 Hensarling Carolyn Brock Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
34524 34524 2004-10-31 2002-12-06 Jonas W. James III Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
34549 34549 2006-10-31 2005-10-28 Merola Barbara F. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
36947 36947 2006-11-30 2004-06-29 Domenick Julie Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
36954 36954 2006-11-30 2006-07-11 Ball William L. Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
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
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
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

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