FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where "Short_Form_Termination_Date" is on date 2007-08-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date)
Registration_Number 10
Registrant_Name 10
City 4
- Washington 20
- New York 2
- Arlington 1
- Sterling Heights 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28490 | 28490 | 2007-08-31 | 2005-01-04 | Letchworth | Elizabeth | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28491 | 28491 | 2007-08-31 | 2007-02-05 | Alomari | Mohammed | Zenith Consulting, Inc. 5792 | 2007-02-05 | Zenith Consulting, Inc. | 5322 Fifteen Mile Road | Suite C | Sterling Heights | MI | 48310 |
28492 | 28492 | 2007-08-31 | 1992-02-26 | Judd | Terry W. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
28493 | 28493 | 2007-08-31 | 2004-03-01 | Rice | Theresa | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
28494 | 28494 | 2007-08-31 | 2004-05-07 | Eizenstat | Stuart E. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28495 | 28495 | 2007-08-31 | 2004-05-07 | Flanagan | Peter L. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28496 | 28496 | 2007-08-31 | 2004-05-07 | Lane | Allegra M. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28497 | 28497 | 2007-08-31 | 2004-05-07 | Smith | Brian D. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28498 | 28498 | 2007-08-31 | 2004-05-12 | Gold | Martin B. | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28499 | 28499 | 2007-08-31 | 2006-05-17 | Patch | Sarabeth V. | Richard L. Collins & Company, Inc. 5537 | 2003-01-22 | Richard L. Collins & Company, Inc. | 2111 Wilson Boulevard | Suite 700 | Arlington | VA | 22201 |
28500 | 28500 | 2007-08-31 | 2006-08-02 | Nakanishi | Leigh | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
28501 | 28501 | 2007-08-31 | 2007-08-03 | Krieger | Kathy L. | James & Hoffman, PC 5822 | 2007-08-03 | James & Hoffman, PC | 1101 17th Street, NW | Suite 510 | Washington | DC | 20036 |
28502 | 28502 | 2007-08-31 | 2007-08-09 | Heikkila | Tiffany | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
28503 | 28503 | 2007-08-31 | 2007-08-09 | Hossain | Sarah | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
28504 | 28504 | 2007-08-31 | 2007-08-09 | Murphy | Sean K. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
28505 | 28505 | 2007-08-31 | 2007-08-09 | Post | Emma | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
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 |
28508 | 28508 | 2007-08-31 | 1991-09-03 | Schumacher | Barry J. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
28509 | 28509 | 2007-08-31 | 2004-10-27 | Chew | Kok Chuan | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
28510 | 28510 | 2007-08-31 | 2006-12-21 | Cook | Randall | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28511 | 28511 | 2007-08-31 | 2006-12-21 | Wichterman | William | Covington & Burling, LLP 5621 | 2004-05-07 | Covington & Burling, LLP | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004 | |
28512 | 28512 | 2007-08-31 | 2004-12-22 | Heng | Teck Thai | 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 |
28513 | 28513 | 2007-08-31 | 2006-12-26 | Saenz | Natalie | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 |
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]) );