FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Short_Form_Termination_Date" is on date 2009-01-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 8
Registrant_Name 8
City 5
- Washington 10
- Chicago 2
- Alexandria 1
- Montreal, Quebec 1
- New York 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5412 | 5412 | 2009-01-31 | 2007-01-10 | Ben-Menashe | Ari | Dickens & Madson Canada, Inc. 5784 | 2007-01-10 | Dickens & Madson Canada, Inc. | 740 Notre Dame Ouest | Suite 1250 | Montreal, Quebec | ||
5413 | 5413 | 2009-01-31 | 2007-01-22 | Pflasterer | Jennifer | Plexus Consulting Group, LLC 5373 | 2000-06-08 | Plexus Consulting Group, LLC | 1620 Eye Street, N.W. | Suite 210 | Washington | DC | 20006 |
5414 | 5414 | 2009-01-31 | 2000-01-31 | Cambon | Paul F. | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP 5355 | 2000-01-31 | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP | 499 South Capitol Street, S.W. | Suite 600 | Washington | DC | 20003 |
5415 | 5415 | 2009-01-31 | 2000-01-31 | Jaskot | John J. | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP 5355 | 2000-01-31 | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP | 499 South Capitol Street, S.W. | Suite 600 | Washington | DC | 20003 |
5416 | 5416 | 2009-01-31 | 2000-01-31 | Johnsen | R. Christian | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP 5355 | 2000-01-31 | Jones, Walker, Waechter, Poitevent, Carrere & Denegre, LLP | 499 South Capitol Street, S.W. | Suite 600 | Washington | DC | 20003 |
5417 | 5417 | 2009-01-31 | 2008-02-11 | Brennan | Patrick Theodore | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
5418 | 5418 | 2009-01-31 | 2000-06-08 | Worth | Steven M. | Plexus Consulting Group, LLC 5373 | 2000-06-08 | Plexus Consulting Group, LLC | 1620 Eye Street, N.W. | Suite 210 | Washington | DC | 20006 |
5419 | 5419 | 2009-01-31 | 2003-06-10 | Cardenas | Alberto R. | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
5420 | 5420 | 2009-01-31 | 2008-08-22 | Drucker | Joy | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
5421 | 5421 | 2009-01-31 | 2006-09-19 | Shinaprayoon | Bangornrat | Tourism Authority of Thailand, New York 1897 | 1965-06-01 | Tourism Authority of Thailand, New York | 61 Broadway | Suite 2810 | New York | NY | 10006 |
5422 | 5422 | 2009-01-31 | 2008-11-17 | Fenwick | Ryan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
5423 | 5423 | 2009-01-31 | 2008-11-17 | Naguib | Amgad | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
5424 | 5424 | 2009-01-31 | 2005-11-23 | Noriega | Roger | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
5425 | 5425 | 2009-01-31 | 2008-12-01 | Davis | James B. | Spectrum Group Members, LLC 5894 | 2008-12-01 | Spectrum Group Members, LLC | 11 Canal Center Plaza | Suite 103 | Alexandria | VA | 22314 |
5426 | 5426 | 2009-01-31 | 2005-12-12 | Baldwin | Donald | Plexus Consulting Group, LLC 5373 | 2000-06-08 | Plexus Consulting Group, LLC | 1620 Eye Street, N.W. | Suite 210 | Washington | DC | 20006 |
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]) );