FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Registrant_Name = "O'Connor & Hannan, LLP", Registration_Number = 5589 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- DC · 6 ✖
Registration_Number 1
- O'Connor & Hannan, LLP · 6 ✖
Registrant_Name 1
- O'Connor & Hannan, LLP · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31325 | 31325 | 2004-09-30 | 2004-09-13 | Mannina | George J. Jr., | O'Connor & Hannan, LLP 5589 | 2003-11-18 | O'Connor & Hannan, LLP | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006-2803 |
31333 | 31333 | 2004-09-30 | 2003-11-18 | Hirsch | Emil | O'Connor & Hannan, LLP 5589 | 2003-11-18 | O'Connor & Hannan, LLP | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006-2803 |
31334 | 31334 | 2004-09-30 | 2003-11-19 | Himmelberg | John M. | O'Connor & Hannan, LLP 5589 | 2003-11-18 | O'Connor & Hannan, LLP | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006-2803 |
31335 | 31335 | 2004-09-30 | 2003-11-19 | Hochbrueckner | George J. | O'Connor & Hannan, LLP 5589 | 2003-11-18 | O'Connor & Hannan, LLP | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006-2803 |
31336 | 31336 | 2004-09-30 | 2003-11-19 | Raz | Edny | O'Connor & Hannan, LLP 5589 | 2003-11-18 | O'Connor & Hannan, LLP | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006-2803 |
31337 | 31337 | 2004-09-30 | 2003-11-19 | Symington | James W. | O'Connor & Hannan, LLP 5589 | 2003-11-18 | O'Connor & Hannan, LLP | 1666 K Street, N.W. | Suite 500 | Washington | DC | 20006-2803 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );