FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Document_Type = "Short-Form" and Registrant_Name = "Loeffler Tuggey Pauerstein Rosenthal, LLP"
This data as json, CSV (advanced)
Registrant_Name 1
- Loeffler Tuggey Pauerstein Rosenthal, LLP · 18 ✖
Foreign_Principal_Name 1
- - 18
Foreign_Principal_Country 1
- - 18
Document_Type 1
- Short-Form · 18 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
4772 | 4772 | 2006-01-11 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Martinez, Jose E. | Available-FARA-Public-Office | ||
6214 | 6214 | 2007-01-19 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Hensarling, Carolyn Brock | Available-FARA-Public-Office | ||
8528 | 8528 | 2007-01-29 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Henderson, Wallace J. | Available-FARA-Public-Office | ||
27816 | 27816 | 2005-03-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Christy,David S. Jr. | Available-FARA-Public-Office | ||
27817 | 27817 | 2005-03-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Domenick,Julie | Available-FARA-Public-Office | ||
27818 | 27818 | 2005-03-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Farrell,Cynthia | Available-FARA-Public-Office | ||
27819 | 27819 | 2005-03-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Kraker,Marcus A. | Available-FARA-Public-Office | ||
27820 | 27820 | 2005-03-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Luskey,Lane M. | Available-FARA-Public-Office | ||
27821 | 27821 | 2005-03-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Parlin,C. Christopher | Available-FARA-Public-Office | ||
28086 | 28086 | 2006-03-15 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Christy, David S. | Available-FARA-Public-Office | ||
28087 | 28087 | 2006-03-15 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Kraker, Marcus A. | Available-FARA-Public-Office | ||
28088 | 28088 | 2006-03-15 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Parlin, C. Christopher | Available-FARA-Public-Office | ||
28089 | 28089 | 2006-03-15 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Rickhoff, Hans Christopher | Available-FARA-Public-Office | ||
39705 | 39705 | 2005-04-12 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Mondello,Joseph N. | Available-FARA-Public-Office | ||
43316 | 43316 | 2006-04-27 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Loeffler, Thomas G. | Available-FARA-Public-Office | ||
75366 | 75366 | 2006-07-11 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Ball, William L. | Available-FARA-Public-Office | ||
76076 | 76076 | 2005-07-14 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Nelson, Susan E. | Available-FARA-Public-Office | ||
111802 | 111802 | 2005-10-28 | Loeffler Tuggey Pauerstein Rosenthal, LLP | Loeffler Group, LLP 5432 | Short-Form | Merola, Barbara F. | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );