FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Short_Form_Termination_Date = "2012-06-30"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 10
- Blue Star Strategies, LLC 4
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- Whitaker Group, Inc. 2
- Podesta Group, Inc. 2
- GAGE International, LLC 2
- Quebec Government Office 1
- Korea National Tourism Organization, Los Angeles 1
- Korea National Tourism Organization, New Jersey 1
- Endeavor Law Firm, PC 1
- Vista Group Corp. 1
Registrant_Name 10
- Blue Star Strategies, LLC 4
- Akin, Gump, Strauss, Hauer & Feld, LLP 2
- GAGE International, LLC 2
- Podesta Group, Inc. 2
- Whitaker Group, Inc. 2
- Endeavor Law Firm, PC 1
- Korea National Tourism Organization, Los Angeles 1
- Korea National Tourism Organization, New Jersey 1
- Quebec Government Office 1
- Vista Group Corp. 1
City 5
- Washington 13
- Fort Lee 1
- Los Angeles 1
- New York 1
- Panama 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21696 | 21696 | 2012-06-30 | 2011-03-02 | Paulsen | Zachary | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21697 | 21697 | 2012-06-30 | 2011-03-24 | Bohn III | Carl H. | Vista Group Corp. 6028 | 2011-03-24 | Vista Group Corp. | P.O. Box 0831-02638 | Panama | |||
21698 | 21698 | 2012-06-30 | 2009-05-08 | Mansfield | Carolyn | Endeavor Law Firm, PC 5934 | 2009-05-08 | Endeavor Law Firm, PC | 1775 Pennsylvania Avenue, NW | Washington | DC | 20006 | |
21699 | 21699 | 2012-06-30 | 2009-05-26 | Min | Min Hong | Korea National Tourism Organization, New Jersey 2614 | 1975-10-04 | Korea National Tourism Organization, New Jersey | 400 Kelby Street | Suite 1602 | Fort Lee | NJ | 07024 |
21700 | 21700 | 2012-06-30 | 2005-06-23 | Tucker | Jamie | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21701 | 21701 | 2012-06-30 | 2011-07-29 | Brathwaite | Paul | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
21702 | 21702 | 2012-06-30 | 2011-07-29 | James | Claudia | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
21703 | 21703 | 2012-06-30 | 2009-09-14 | Hyndman | Patrick | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21704 | 21704 | 2012-06-30 | 2010-09-30 | Pence | Eliot | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | Washington | DC | 20036 |
21705 | 21705 | 2012-06-30 | 2009-12-02 | Kim | Myongsun | Korea National Tourism Organization, Los Angeles 2544 | 1974-10-25 | Korea National Tourism Organization, Los Angeles | 5509 Wilshire Boulevard | Suite 201 | Los Angeles | CA | 90036 |
21706 | 21706 | 2012-06-30 | 2010-12-21 | Giacometto | Leo A. | GAGE International, LLC 6011 | 2010-12-21 | GAGE International, LLC | 122 C Street, NW | Suite 380 | Washington | DC | 20001 |
21707 | 21707 | 2012-06-30 | 2010-12-21 | Rehberg | AJ | GAGE International, LLC 6011 | 2010-12-21 | GAGE International, LLC | 122 C Street, NW | Suite 380 | Washington | DC | 20001 |
21708 | 21708 | 2012-06-30 | 2011-12-22 | Espinosa | Carlos | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21709 | 21709 | 2012-06-30 | 2011-12-22 | Korkoian | David | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21710 | 21710 | 2012-06-30 | 2011-12-22 | Tramontano | Karen A. | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21711 | 21711 | 2012-06-30 | 2011-12-22 | Zinny | Gabriel Sanchez | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21712 | 21712 | 2012-06-30 | 2005-12-27 | Hruby | Aubrey | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | 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]) );