FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
39 rows where "Short_Form_Termination_Date" is on date 2009-06-30
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_1, Address_2, Short_Form_Date (date)
Registration_Number 17
- Clark & Weinstock 8
- Harbour Group, LLC 5
- AGA Group, LLC 4
- Spectrum Group Members, LLC 4
- Integrated Solutions Group, LLC 3
- Squire Patton Boggs, LLP 2
- Global USA, Inc. 2
- Pepperwood International Corp. 2
- VisitDenmark 1
- Singapore Economic Development Board 1
- Burson-Marsteller 1
- Korea National Tourism Organization, Los Angeles 1
- St. Lucia National Development Corporation 1
- Deutsche Telekom, Inc. 1
- Williams Mullen Strategies, Inc. 1
- PD Frazer Consulting Inc. 1
- Vision Americas, LLC 1
Registrant_Name 17
- Clark & Weinstock 8
- Harbour Group, LLC 5
- AGA Group, LLC 4
- Spectrum Group Members, LLC 4
- Integrated Solutions Group, LLC 3
- Global USA, Inc. 2
- Pepperwood International Corp. 2
- Squire Patton Boggs, LLP 2
- Burson-Marsteller 1
- Deutsche Telekom, Inc. 1
- Korea National Tourism Organization, Los Angeles 1
- PD Frazer Consulting Inc. 1
- Singapore Economic Development Board 1
- St. Lucia National Development Corporation 1
- Vision Americas, LLC 1
- VisitDenmark 1
- Williams Mullen Strategies, Inc. 1
City 6
- Washington 27
- Alexandria 4
- New York 4
- Eureka 2
- Los Angeles 1
- Richmond 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21612 | 21612 | 2009-06-30 | 2009-01-15 | Lee | Jae Kyong | 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 |
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 |
21615 | 21615 | 2009-06-30 | 2008-02-04 | Tham | Aaron Chee-Chong | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
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 |
21627 | 21627 | 2009-06-30 | 2009-02-27 | Hannaford | Peter D. | Pepperwood International Corp. 5912 | 2009-02-27 | Pepperwood International Corp. | 3555 J Street | Eureka | CA | 95503-5419 | |
21628 | 21628 | 2009-06-30 | 2009-02-27 | Spinck | Darren | Pepperwood International Corp. 5912 | 2009-02-27 | Pepperwood International Corp. | 3555 J Street | Eureka | CA | 95503-5419 | |
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 |
21642 | 21642 | 2009-06-30 | 2005-07-21 | Robertson | Mark John | Williams Mullen Strategies, Inc. 5698 | 2005-07-21 | Williams Mullen Strategies, Inc. | Two James Center, 1021 East Cary Street | P.O. Box 1320 | Richmond | VA | 23218 |
21643 | 21643 | 2009-06-30 | 2001-08-08 | Jakubek | Wolfgang P. | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
21644 | 21644 | 2009-06-30 | 2008-09-10 | Giery | Catrine A. | VisitDenmark 634 | 1950-07-25 | VisitDenmark | 655 Third Avenue | 18th Floor, Suite 2010 | New York | NY | 10017 |
21645 | 21645 | 2009-06-30 | 1999-10-15 | Pilgrim | Carl | St. Lucia National Development Corporation 2796 | 1977-06-24 | St. Lucia National Development Corporation | 800 2nd Avenue | Suite 910 | New York | NY | 10017-4709 |
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 | |
21647 | 21647 | 2009-06-30 | 2008-12-01 | Cosgrove | Daniel P. | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 11 Canal Center Plaza | Suite 103 | Alexandria | VA | 22314 |
21648 | 21648 | 2009-06-30 | 2008-12-01 | Hall Jr. | John B. | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 11 Canal Center Plaza | Suite 103 | Alexandria | VA | 22314 |
21649 | 21649 | 2009-06-30 | 2008-12-01 | Pearson | William R. | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 11 Canal Center Plaza | Suite 103 | Alexandria | VA | 22314 |
21650 | 21650 | 2009-06-30 | 2009-12-04 | Waskow | Thomas C. | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 11 Canal Center Plaza | Suite 103 | Alexandria | VA | 22314 |
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]) );