FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Registration_Number = 5807 and "Short_Form_Date" is on date 2011-10-17 sorted by State
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Termination_Date (date), Registration_Date (date)
State 1
- DC 27
Registration_Number 1
- Ogilvy Public Relations Worldwide · 27 ✖
Registrant_Name 1
City 1
- Washington 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2903 | 2903 | 2013-01-01 | 2011-10-17 | Rojas | Felipe Carlos Benitez | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
7405 | 7405 | 2013-02-22 | 2011-10-17 | Garvey | Kelsey | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
8266 | 8266 | 2013-02-28 | 2011-10-17 | Winokur | Matthew | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
9194 | 9194 | 2012-03-05 | 2011-10-17 | Mordkowski | Debora | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
10090 | 10090 | 2012-03-16 | 2011-10-17 | Daly | Brendan | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12550 | 12550 | 2012-04-01 | 2011-10-17 | Lear | Robert Neil | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
13591 | 13591 | 2013-04-16 | 2011-10-17 | Miller | Kimberly | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
16626 | 16626 | 2013-05-17 | 2011-10-17 | Levin | Josh | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
19775 | 19775 | 2011-06-17 | 2011-10-17 | Marley | Jennifer | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
20478 | 20478 | 2013-06-28 | 2011-10-17 | Ryan | Kimberly | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21787 | 21787 | 2013-06-30 | 2011-10-17 | D'Agostino | Heidi | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21788 | 21788 | 2013-06-30 | 2011-10-17 | Brown | Allison | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21789 | 21789 | 2013-06-30 | 2011-10-17 | Engstrom | Lizelda Lopez | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21790 | 21790 | 2013-06-30 | 2011-10-17 | Esparza | Yazmine | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21791 | 21791 | 2013-06-30 | 2011-10-17 | Gutierrez | Michelle J. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21792 | 21792 | 2013-06-30 | 2011-10-17 | Kalman | Zachary | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21793 | 21793 | 2013-06-30 | 2011-10-17 | Kosnar | Andrew | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21794 | 21794 | 2013-06-30 | 2011-10-17 | Ludlum | Nicholas | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21795 | 21795 | 2013-06-30 | 2011-10-17 | Mullins | Tara | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21796 | 21796 | 2013-06-30 | 2011-10-17 | Pomerantz | Carrie | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
21797 | 21797 | 2013-06-30 | 2011-10-17 | Risi | Jennifer | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
27284 | 27284 | 2013-08-23 | 2011-10-17 | Ashour | Nabil | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
29695 | 29695 | 2012-09-13 | 2011-10-17 | Revis | Layla | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
32712 | 32712 | 2012-10-12 | 2011-10-17 | Kelerstein | Max | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
38327 | 38327 | 2012-12-14 | 2011-10-17 | Knapp | Teagan | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41793 | 41793 | 2011-12-31 | 2011-10-17 | Miracle | Virginia Welford | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41846 | 41846 | 2012-12-31 | 2011-10-17 | Rees | Rachael | 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]) );