FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where "Short_Form_Termination_Date" is on date 2009-06-30 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21613 | 21613 | 2009-06-30 | 2007-01-22 | Marcus | Richard | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
21614 | 21614 | 2009-06-30 | 2008-01-29 | Fogan | Byron | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
21616 | 21616 | 2009-06-30 | 2009-02-17 | D'Arcy | Christopher | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21617 | 21617 | 2009-06-30 | 2009-02-17 | O'Hanlon | G. John | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21618 | 21618 | 2009-06-30 | 2009-02-17 | Edwards | Melissa M. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21619 | 21619 | 2009-06-30 | 2009-02-17 | Farmer | Kimberley | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21620 | 21620 | 2009-06-30 | 2009-02-17 | Lobo | Paul | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21621 | 21621 | 2009-06-30 | 2009-02-17 | Noone | James A. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21622 | 21622 | 2009-06-30 | 2009-02-17 | Speed | Tonya M. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21623 | 21623 | 2009-06-30 | 2009-02-17 | West | Fowler | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21624 | 21624 | 2009-06-30 | 2008-02-27 | O'Hanlon | G. John | Integrated Solutions Group, LLC 5855 | 2008-02-27 | Integrated Solutions Group, LLC | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
21625 | 21625 | 2009-06-30 | 2008-02-27 | Boyd | Moses | Integrated Solutions Group, LLC 5855 | 2008-02-27 | Integrated Solutions Group, LLC | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
21626 | 21626 | 2009-06-30 | 2008-02-27 | Olsen | Adam S. | Integrated Solutions Group, LLC 5855 | 2008-02-27 | Integrated Solutions Group, LLC | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
21629 | 21629 | 2009-06-30 | 2009-03-06 | Brennan | Patrick T. | Vision Americas, LLC 5907 | 2009-02-19 | Vision Americas, LLC | 1150 K Street, NW | Suite 1411 | Washington | DC | 20005 |
21630 | 21630 | 2009-06-30 | 2008-04-01 | Sforza | Scott | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
21631 | 21631 | 2009-06-30 | 1999-04-29 | Denysyk | Bohdan | Global USA, Inc. 5292 | 1998-12-16 | Global USA, Inc. | 1990 M Street, NW | #200 | Washington | DC | 20036 |
21632 | 21632 | 2009-06-30 | 1999-04-29 | Kopp | George S. | Global USA, Inc. 5292 | 1998-12-16 | Global USA, Inc. | 1990 M Street, NW | #200 | Washington | DC | 20036 |
21633 | 21633 | 2009-06-30 | 2007-04-30 | Triaca | Matthew | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
21634 | 21634 | 2009-06-30 | 2003-05-01 | Harmon | Keith Eugene | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
21635 | 21635 | 2009-06-30 | 2003-05-06 | Peters | Stephanie J. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21636 | 21636 | 2009-06-30 | 2009-05-11 | Ellis | Steve | AGA Group, LLC 5600 | 2004-02-13 | AGA Group, LLC | 1700 K Street, NW | Suite 730 | Washington | DC | 20006 |
21637 | 21637 | 2009-06-30 | 2009-05-11 | Grabowski | Gene | AGA Group, LLC 5600 | 2004-02-13 | AGA Group, LLC | 1700 K Street, NW | Suite 730 | Washington | DC | 20006 |
21638 | 21638 | 2009-06-30 | 2009-05-11 | McAlpin | Derede | AGA Group, LLC 5600 | 2004-02-13 | AGA Group, LLC | 1700 K Street, NW | Suite 730 | Washington | DC | 20006 |
21639 | 21639 | 2009-06-30 | 2009-05-11 | Phalen | Susan | AGA Group, LLC 5600 | 2004-02-13 | AGA Group, LLC | 1700 K Street, NW | Suite 730 | Washington | DC | 20006 |
21640 | 21640 | 2009-06-30 | 2007-05-24 | Horwitz | Seth | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
21641 | 21641 | 2009-06-30 | 2006-06-20 | Geoffrey | Gleason | PD Frazer Consulting Inc. 5754 | 2006-06-16 | PD Frazer Consulting Inc. | 3 Click Solutions | 805 15th Street, NW Suite 425 | Washington | DC | 20005 |
21646 | 21646 | 2009-06-30 | 2008-11-03 | Ryou | Thomas H. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 |
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]) );