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 2010-01-01
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2869 | 2869 | 2010-01-01 | 2006-02-06 | Shearer | Ean K. | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
2870 | 2870 | 2010-01-01 | 2009-02-10 | Kanfer | Laura | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
2871 | 2871 | 2010-01-01 | 2009-02-10 | Sheth | Purvi | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
2872 | 2872 | 2010-01-01 | 2006-03-24 | Osborne | Jason | MITA Group, Inc. 5741 | 2006-03-24 | MITA Group, Inc. | 8320 Old Courthouse Road | Suite 200 | Vienna | VA | 22182 |
2873 | 2873 | 2010-01-01 | 2009-04-01 | Scofield | John | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
2874 | 2874 | 2010-01-01 | 2007-04-13 | Muir | Frederick M. | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
2875 | 2875 | 2010-01-01 | 2005-05-02 | Swett | Richard N. | International Trade & Development Agency, Inc. 3690 | 1985-06-13 | International Trade & Development Agency, Inc. | 2 Split Rock Road Spur | Muttontown | NY | 11732 | |
2876 | 2876 | 2010-01-01 | 1982-06-02 | Cashen | Henry C. , II | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
2877 | 2877 | 2010-01-01 | 2009-09-23 | Christie | Katherine | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1875 I Street, NW | Suite 500 | Washington | DC | 20006 |
2878 | 2878 | 2010-01-01 | 2009-09-25 | Lewin | Andrew | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
2879 | 2879 | 2010-01-01 | 2009-09-25 | Young | Nicole | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
2880 | 2880 | 2010-01-01 | 2009-09-28 | Gladstone | Karyn | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | 1010 Vermont Avenue, NW | Suite 1100 | Washington | DC | 20005 |
2881 | 2881 | 2010-01-01 | 2009-09-28 | Parry | Karen | Fenton Communications 5945 | 2009-06-26 | Fenton Communications | 1010 Vermont Avenue, NW | Suite 1100 | Washington | DC | 20005 |
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 |
2883 | 2883 | 2010-01-01 | 2009-11-04 | Galloway | Michael | MITA Group, Inc. 5741 | 2006-03-24 | MITA Group, Inc. | 8320 Old Courthouse Road | Suite 200 | Vienna | VA | 22182 |
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]) );