FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Short_Form_Date = "2010-12-20" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12147 | 12147 | 2013-03-31 | 2010-12-20 | Coursen | Cameron | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12148 | 12148 | 2013-03-31 | 2010-12-20 | Rosenbloom | Randi Appelbaum | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
15495 | 15495 | 2013-05-01 | 2010-12-20 | Essif | Mason L. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
15496 | 15496 | 2013-05-01 | 2010-12-20 | Henderson | Rachel | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
15497 | 15497 | 2013-05-01 | 2010-12-20 | Omer | Amal | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
20590 | 20590 | 2012-06-29 | 2010-12-20 | Melzer | Jon | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
23683 | 23683 | 2012-07-20 | 2010-12-20 | Esquivel | Kety | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
26059 | 26059 | 2011-08-05 | 2010-12-20 | Arthur-Asmah | Enoch | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
26564 | 26564 | 2010-08-13 | 2010-12-20 | Wan | Melissa Ariel | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
28970 | 28970 | 2011-09-01 | 2010-12-20 | Tjaden | Elizabeth | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
30387 | 30387 | 2010-09-24 | 2010-12-20 | Carpio | Allison | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
30457 | 30457 | 2011-09-25 | 2010-12-20 | Gerth | Josh | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
37928 | 37928 | 2011-12-08 | 2010-12-20 | Merwin | Michael | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
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]) );