FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where "Short_Form_Date" is on date 2007-12-31 sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_1, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2485 | 2485 | 2007-12-31 | Gran | Beate Christin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 | |
21695 | 21695 | 2011-06-30 | 2007-12-31 | Dahle | Kristin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
6428 | 6428 | 2012-02-08 | 2007-12-31 | Greene | Imani | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
6876 | 6876 | 2011-02-14 | 2007-12-31 | Connell | William V. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
11091 | 11091 | 2013-03-29 | 2007-12-31 | Douglas | Tim | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12150 | 12150 | 2013-03-31 | 2007-12-31 | Hardeman | Rajene | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12151 | 12151 | 2013-03-31 | 2007-12-31 | Hardy | Laura W. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12152 | 12152 | 2013-03-31 | 2007-12-31 | Kehoe | Louise | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12153 | 12153 | 2013-03-31 | 2007-12-31 | Mullen | Kellie | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12154 | 12154 | 2013-03-31 | 2007-12-31 | Rangel | Nicholas Salvador | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
12155 | 12155 | 2013-03-31 | 2007-12-31 | Smith | Thomas | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
19255 | 19255 | 2010-06-11 | 2007-12-31 | Wexler | Benjamin Nguyen | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
19367 | 19367 | 2008-06-13 | 2007-12-31 | Cameron | Lauren | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
20401 | 20401 | 2008-06-27 | 2007-12-31 | Reid II | Harold S. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
23799 | 23799 | 2010-07-22 | 2007-12-31 | Stein | Lauren | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
24034 | 24034 | 2008-07-25 | 2007-12-31 | Tamasi | David | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
24390 | 24390 | 2009-07-29 | 2007-12-31 | Franck | Kelly | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
26784 | 26784 | 2008-08-15 | 2007-12-31 | Rabinowitz | Levi | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
27497 | 27497 | 2008-08-26 | 2007-12-31 | Bridgman | Jeremy D. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
32034 | 32034 | 2009-10-01 | 2007-12-31 | Quinn | Gloria | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
32597 | 32597 | 2008-10-10 | 2007-12-31 | Sciulli | Alan | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41647 | 41647 | 2008-12-31 | 2007-12-31 | Mangi | Michael | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41598 | 41598 | 2007-12-31 | 2007-12-31 | Bafalis | L.A. Skip"" | Alcalde and Fay 5844 | 2007-12-31 | Alcalde and Fay | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
41599 | 41599 | 2007-12-31 | 2007-12-31 | Davenport | Jim | Alcalde and Fay 5844 | 2007-12-31 | Alcalde and Fay | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
41600 | 41600 | 2007-12-31 | 2007-12-31 | Kurland | Maurice | Alcalde and Fay 5844 | 2007-12-31 | Alcalde and Fay | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
41601 | 41601 | 2007-12-31 | 2007-12-31 | Zorthian | Barry | Alcalde and Fay 5844 | 2007-12-31 | Alcalde and Fay | 2111 Wilson Boulevard | 8th Floor | Arlington | VA | 22201 |
2486 | 2486 | 2007-12-31 | Haughian | Andrea | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 | |
18118 | 18118 | 2013-05-31 | 2007-12-31 | Healy | Michelle | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
25171 | 25171 | 2010-07-31 | 2007-12-31 | Mulhern | Lisa Marie | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
25199 | 25199 | 2013-07-31 | 2007-12-31 | Dawson | Jane | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
25661 | 25661 | 2008-08-01 | 2007-12-31 | Howe | Louise | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
35672 | 35672 | 2018-11-12 | 2007-12-31 | Hanley | Gary | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
41993 | 41993 | 2014-12-31 | 2007-12-31 | Logan | John | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
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]) );