FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
38 rows where Address_1 = "601 Pennsylvania Avenue, NW"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
537 | 537 | 2022-03-09 | Hsia | Andrew | KMT Representative Office in the United States 7093 | 2022-03-09 | KMT Representative Office in the United States | 601 Pennsylvania Avenue, NW | Suite 965 | Washington | DC | 20004 | |
538 | 538 | 2022-03-09 | Huang | Alexander | KMT Representative Office in the United States 7093 | 2022-03-09 | KMT Representative Office in the United States | 601 Pennsylvania Avenue, NW | Suite 965 | Washington | DC | 20004 | |
539 | 539 | 2022-03-09 | Huang | Eric | KMT Representative Office in the United States 7093 | 2022-03-09 | KMT Representative Office in the United States | 601 Pennsylvania Avenue, NW | Suite 965 | Washington | DC | 20004 | |
676 | 676 | 2019-03-29 | Taylor | Tracy | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
871 | 871 | 2018-04-25 | Rudd | David | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
1002 | 1002 | 2023-05-11 | Chin | Victor J | KMT Representative Office in the United States 7093 | 2022-03-09 | KMT Representative Office in the United States | 601 Pennsylvania Avenue, NW | Suite 965 | Washington | DC | 20004 | |
1800 | 1800 | 2015-09-18 | Anderson | Rebecca | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
1801 | 1801 | 2015-09-18 | Beer | Michael | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
1802 | 1802 | 2015-09-18 | Carp | Bertram | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
1803 | 1803 | 2015-09-18 | DiJames | Jennifer | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
1804 | 1804 | 2015-09-18 | Jardot | Leo | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 | |
2882 | 2882 | 2010-01-01 | 2005-10-14 | Thomas | Doug | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
5884 | 5884 | 2016-02-01 | 2010-02-22 | Jackson | Jaimon Maurice | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
5888 | 5888 | 2016-02-01 | 2015-07-09 | Dellums | Ronald V. | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
5889 | 5889 | 2016-02-01 | 2004-08-27 | Pruitt | Steven Lawrence | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
5890 | 5890 | 2016-02-01 | 2004-08-27 | Sailor | Elroy P. | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
5891 | 5891 | 2016-02-01 | 2004-08-27 | Watts | J.C. Jr., | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
8187 | 8187 | 2005-02-28 | 2004-08-27 | Egge | Rob | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
8188 | 8188 | 2005-02-28 | 2004-08-27 | Humphrey | Calvin | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
10897 | 10897 | 2007-03-27 | 2005-10-14 | Mitchell | Lindsey | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
11220 | 11220 | 2012-03-30 | 2012-02-17 | Davis | Lincoln | Advantage Associates International, LTD., through Raza Bokhari 6062 | 2011-09-10 | Advantage Associates International, LTD., through Raza Bokhari | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
11221 | 11221 | 2012-03-30 | 2011-09-10 | Sarpalius | Bill | Advantage Associates International, LTD., through Raza Bokhari 6062 | 2011-09-10 | Advantage Associates International, LTD., through Raza Bokhari | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
11222 | 11222 | 2012-03-30 | 2011-09-10 | Tallon | Robin | Advantage Associates International, LTD., through Raza Bokhari 6062 | 2011-09-10 | Advantage Associates International, LTD., through Raza Bokhari | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
11223 | 11223 | 2012-03-30 | 2011-09-10 | Terry | Mike | Advantage Associates International, LTD., through Raza Bokhari 6062 | 2011-09-10 | Advantage Associates International, LTD., through Raza Bokhari | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
18015 | 18015 | 2006-05-31 | 2005-10-14 | Park | Andrew J. | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
18546 | 18546 | 2010-06-01 | 2006-12-05 | Baird | Fredrick Tripp"" | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
25084 | 25084 | 2006-07-31 | 2006-03-30 | Gillette | Robert | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
25167 | 25167 | 2010-07-31 | 2010-01-07 | Engone | Roger | Capitol Law & Policy Group, PLLC 5969 | 2010-01-07 | Capitol Law & Policy Group, PLLC | 601 Pennsylvania Avenue, NW | Suite 407 North | Washington | DC | 20004 |
25168 | 25168 | 2010-07-31 | 2010-01-07 | Frazer | Victor O. | Capitol Law & Policy Group, PLLC 5969 | 2010-01-07 | Capitol Law & Policy Group, PLLC | 601 Pennsylvania Avenue, NW | Suite 407 North | Washington | DC | 20004 |
25169 | 25169 | 2010-07-31 | 2010-01-07 | Hoffman | Adonis E. | Capitol Law & Policy Group, PLLC 5969 | 2010-01-07 | Capitol Law & Policy Group, PLLC | 601 Pennsylvania Avenue, NW | Suite 407 North | Washington | DC | 20004 |
28506 | 28506 | 2007-08-31 | 2006-08-23 | Bailey | Nawel | Gilberts Washington, Inc. 5763 | 2006-09-28 | Gilberts Washington, Inc. | 601 Pennsylvania Avenue, NW | Suite 922 | Washington | DC | 20004-2601 |
28507 | 28507 | 2007-08-31 | 2006-08-23 | Johnstone | Jeff | Gilberts Washington, Inc. 5763 | 2006-09-28 | Gilberts Washington, Inc. | 601 Pennsylvania Avenue, NW | Suite 922 | Washington | DC | 20004-2601 |
28965 | 28965 | 2010-09-01 | 2010-02-22 | Mantis | LaVerne Pamela | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
28968 | 28968 | 2010-09-01 | 2007-10-04 | Waskiewicz II | Stephen Andrew | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
32228 | 32228 | 2019-10-03 | 2019-03-29 | Ose | Erika | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 |
33220 | 33220 | 2018-10-19 | 2018-03-13 | Mayor | Daniel | Alignment Government Strategies 6317 | 2015-09-18 | Alignment Government Strategies | 601 Pennsylvania Avenue, NW | South Building, Suite 430 | Washington | DC | 20004 |
33515 | 33515 | 2007-10-23 | 2005-10-14 | Omar | Cheik | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
41516 | 41516 | 2006-12-31 | 2005-10-14 | Alion | Christopher M. | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
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]) );