FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where "Short_Form_Termination_Date" is on date 2005-06-30 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21520 | 21520 | 2005-06-30 | 2004-01-26 | Bartram | Darin R. | Baker & Hostetler, LLP 5599 | 2004-01-26 | Baker & Hostetler, LLP | 1050 Connecticut Avenue, N.W. | Washington Square, Suite 1100 | Washington | DC | 20036-5304 |
21521 | 21521 | 2005-06-30 | 2004-01-26 | Casey | Lee A. | Baker & Hostetler, LLP 5599 | 2004-01-26 | Baker & Hostetler, LLP | 1050 Connecticut Avenue, N.W. | Washington Square, Suite 1100 | Washington | DC | 20036-5304 |
21522 | 21522 | 2005-06-30 | 2004-01-26 | Rivkin | David B. Jr., | Baker & Hostetler, LLP 5599 | 2004-01-26 | Baker & Hostetler, LLP | 1050 Connecticut Avenue, N.W. | Washington Square, Suite 1100 | Washington | DC | 20036-5304 |
21523 | 21523 | 2005-06-30 | 2004-01-26 | Schweitzer | William H. | Baker & Hostetler, LLP 5599 | 2004-01-26 | Baker & Hostetler, LLP | 1050 Connecticut Avenue, N.W. | Washington Square, Suite 1100 | Washington | DC | 20036-5304 |
21527 | 21527 | 2005-06-30 | 2005-02-04 | Goode | Catherine | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21529 | 21529 | 2005-06-30 | 1998-03-13 | Laughlin | Gregory H. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21530 | 21530 | 2005-06-30 | 2005-05-11 | Mirijanian | Peter G. | Mirijanian, Peter G. 5683 | 2005-05-11 | Mirijanian, Peter G. | 1133 Connecticut Avenue, N.W. | Suite 675 | Washington | DC | 20036 |
21531 | 21531 | 2005-06-30 | 2005-05-23 | Hatch | Paul David | McDermott Will & Emery, LLP 5686 | 2005-05-23 | McDermott Will & Emery, LLP | 600 13th Street, NW | Washington | DC | 20005 | |
21532 | 21532 | 2005-06-30 | 2005-05-23 | Lemov | Michael R. | Sonnenschein Nath & Rosenthal, LLP 5650 | 2004-10-08 | Sonnenschein Nath & Rosenthal, LLP | 1301 K Street, N.W. | Suite 600, East Tower | Washington | DC | 20005 |
21533 | 21533 | 2005-06-30 | 2005-05-23 | Steen | Gretchen P. | McDermott Will & Emery, LLP 5686 | 2005-05-23 | McDermott Will & Emery, LLP | 600 13th Street, NW | Washington | DC | 20005 | |
21534 | 21534 | 2005-06-30 | 2005-06-03 | DeLaquil | Mark Wendell | Baker & Hostetler, LLP 5599 | 2004-01-26 | Baker & Hostetler, LLP | 1050 Connecticut Avenue, N.W. | Washington Square, Suite 1100 | Washington | DC | 20036-5304 |
21542 | 21542 | 2005-06-30 | 2004-06-22 | Chernow | Jo Ellen | Latin America Information Office LLC 5609 | 2004-02-27 | Latin America Information Office LLC | 2000 P Street, NW | Suite 240 | Washington | DC | 20036 |
21544 | 21544 | 2005-06-30 | 2003-08-04 | Raboy | David | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21546 | 21546 | 2005-06-30 | 2005-08-22 | House | Michael P. | McDermott Will & Emery, LLP 5686 | 2005-05-23 | McDermott Will & Emery, LLP | 600 13th Street, NW | Washington | DC | 20005 | |
21547 | 21547 | 2005-06-30 | 2004-08-25 | Evans | Christina | Hunton & Williams, LLP 5627 | 2004-06-15 | Hunton & Williams, LLP | 1900 K Street, N.W. | Suite 1200 | Washington | DC | 20006 |
21548 | 21548 | 2005-06-30 | 2002-09-04 | Motojima | Akinobu | JFCC, Washington Office 4440 | 1990-11-21 | JFCC, Washington Office | 1120 Connecticut Avenue, NW | Suite 440 | Washington | DC | 20036 |
21551 | 21551 | 2005-06-30 | 2004-11-01 | Kaplan | Philip S. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21552 | 21552 | 2005-06-30 | 2002-12-18 | Roh | Charles E. | Weil, Gotshal & Manges LLP 5534 | 2002-12-18 | Weil, Gotshal & Manges LLP | 1501 K Street, N.W. | Suite 100 | Washington | DC | 20005 |
21553 | 21553 | 2005-06-30 | 2004-12-22 | Connaughton | Jeffrey | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21554 | 21554 | 2005-06-30 | 2004-12-22 | Hacker | Michael | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21555 | 21555 | 2005-06-30 | 2004-12-22 | Hoppe | John David | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21556 | 21556 | 2005-06-30 | 2004-12-22 | Hume | Virginia | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21557 | 21557 | 2005-06-30 | 2004-12-22 | Lampkin | Marc S. | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21558 | 21558 | 2005-06-30 | 2004-12-22 | Maduros | Nicolas | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
21559 | 21559 | 2005-06-30 | 2004-12-22 | Quinn | Jack | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
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]) );