FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
38 rows where "Short_Form_Termination_Date" is on date 2009-12-31
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Short_Form_Date (date)
Registration_Number 22
- Fleishman-Hillard, Inc. 7
- Ogilvy Public Relations Worldwide 5
- BKSH & Associates 4
- Hill and Knowlton Strategies, LLC 2
- Daniel J. Edelman, Inc. 2
- Public Strategies, Inc. 2
- Netherlands Board of Tourism and Conventions (NBTC) 1
- Enterprise Ireland 1
- DLA Piper US LLP 1
- Invest Northern Ireland 1
- Lloyd's of London Market Representatives 1
- Czech Center, New York 1
- Dentsu America, Inc. 1
- LISCR, LLC 1
- Cassidy & Associates, Inc. 1
- Global Communicators, LLC 1
- Fulbright & Jaworski, LLP 1
- Locke Lord Strategies, L.P. 1
- Manatt, Phelps & Phillips, LLP 1
- Jacobs, Barry 1
- DUTKO Worldwide, LLC 1
- Global Policy Initiatives 1
Registrant_Name 22
- Fleishman-Hillard, Inc. 7
- Ogilvy Public Relations Worldwide 5
- BKSH & Associates 4
- Daniel J. Edelman, Inc. 2
- Hill and Knowlton Strategies, LLC 2
- Public Strategies, Inc. 2
- Cassidy & Associates, Inc. 1
- Czech Center, New York 1
- DLA Piper US LLP 1
- DUTKO Worldwide, LLC 1
- Dentsu America, Inc. 1
- Enterprise Ireland 1
- Fulbright & Jaworski, LLP 1
- Global Communicators, LLC 1
- Global Policy Initiatives 1
- Invest Northern Ireland 1
- Jacobs, Barry 1
- LISCR, LLC 1
- Lloyd's of London Market Representatives 1
- Locke Lord Strategies, L.P. 1
- Manatt, Phelps & Phillips, LLP 1
- Netherlands Board of Tourism and Conventions (NBTC) 1
City 11
- Washington 17
- St. Louis 7
- New York 4
- Austin 2
- Chicago 2
- Bannockburn 1
- Buffalo Grove 1
- Dulles 1
- Houston 1
- London 1
- McLean 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41648 | 41648 | 2009-12-31 | 2009-01-21 | Sanchez-Zinny | Gabriel | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
41649 | 41649 | 2009-12-31 | 2009-02-10 | Froemming | Courtney | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41650 | 41650 | 2009-12-31 | 2009-02-10 | Yunga | Ebie | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41651 | 41651 | 2009-12-31 | 2010-02-22 | Harris | Hadley | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
41652 | 41652 | 2009-12-31 | 2010-02-22 | Moeenziai | Ladan | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
41653 | 41653 | 2009-12-31 | 2005-02-28 | Tolle | Rolf | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
41654 | 41654 | 2009-12-31 | 2009-03-05 | Eller | Jeff | Public Strategies, Inc. 5913 | 2009-03-05 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 1200 | Austin | TX | 78701 |
41655 | 41655 | 2009-12-31 | 2009-03-05 | Lanphear | Whitney | Public Strategies, Inc. 5913 | 2009-03-05 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 1200 | Austin | TX | 78701 |
41656 | 41656 | 2009-12-31 | 2007-03-15 | Palkova-Claudino | Michaela | Czech Center, New York 5115 | 1996-06-21 | Czech Center, New York | 321 E 73rd Street | New York | NY | 10021 | |
41657 | 41657 | 2009-12-31 | 2009-03-24 | Capel | Rodney S. | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41658 | 41658 | 2009-12-31 | 2002-04-02 | Keohane | Lynda Jill | LISCR, LLC 5490 | 2002-04-02 | LISCR, LLC | 22980 Indian Creek Drive | Suite 200 | Dulles | VA | 20166 |
41659 | 41659 | 2009-12-31 | 2007-05-07 | Mathias | Robert F. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41660 | 41660 | 2009-12-31 | 2008-05-09 | Coffee | Roy | Locke Lord Strategies, L.P. 5856 | 2008-03-07 | Locke Lord Strategies, L.P. | 701 8th Street, NW | Suite 700 | Washington | DC | 20001 |
41661 | 41661 | 2009-12-31 | 2007-05-29 | LaBrache | Lisa | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41662 | 41662 | 2009-12-31 | 2006-05-30 | Greer | John | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
41663 | 41663 | 2009-12-31 | 2009-06-23 | Dunagan | John | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41664 | 41664 | 2009-12-31 | 2009-06-23 | Sweezy | Dallas | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41665 | 41665 | 2009-12-31 | 2009-06-23 | Taylor | Jeffrey L. | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41666 | 41666 | 2009-12-31 | 2007-06-26 | Morales | Michiko M. | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1875 I Street, NW | Suite 500 | Washington | DC | 20006 |
41667 | 41667 | 2009-12-31 | 2009-06-30 | O'Farrell | Sandra | Enterprise Ireland 2518 | 1974-06-08 | Enterprise Ireland | Ireland House | 345 Park Avenue, 17th Floor | New York | NY | 10154-0037 |
41668 | 41668 | 2009-12-31 | 2008-07-01 | Ross | Lisa Osborne | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41669 | 41669 | 2009-12-31 | 2009-07-02 | Murphy | Aaron | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41670 | 41670 | 2009-12-31 | 2009-07-02 | Stauffer | John | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41671 | 41671 | 2009-12-31 | 2002-07-22 | Brown | Barbara Veldramp | Netherlands Board of Tourism and Conventions (NBTC) 619 | 1950-03-20 | Netherlands Board of Tourism and Conventions (NBTC) | 215 Park Avenue South | Suite 1302 | New York | NY | 10003 |
41672 | 41672 | 2009-12-31 | 2009-07-29 | Black, Jr., | Charles R. | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41673 | 41673 | 2009-12-31 | 2009-07-30 | McNabb | Stephen M. | Fulbright & Jaworski, LLP 5842 | 2007-12-28 | Fulbright & Jaworski, LLP | 1301 McKinney #5100 | Fulbright Tower | Houston | TX | 77010-3095 |
41674 | 41674 | 2009-12-31 | 2009-07-31 | Godoua | Caitlin | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41675 | 41675 | 2009-12-31 | 2009-07-31 | Schwartz | Stacy | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41676 | 41676 | 2009-12-31 | 2009-08-31 | Colangelo | Lisa Cotter | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41677 | 41677 | 2009-12-31 | 2009-08-31 | Pastrick | R. Scott | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41678 | 41678 | 2009-12-31 | 2009-08-31 | Peckham | Gardner | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41679 | 41679 | 2009-12-31 | 2007-09-07 | McSherry | Michael T. | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41680 | 41680 | 2009-12-31 | 2007-09-07 | Sandlin | Max A. | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41681 | 41681 | 2009-12-31 | 2007-09-07 | Sweet | Paul | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
41682 | 41682 | 2009-12-31 | 2004-09-10 | Benitez | Juan Carlos | Cassidy & Associates, Inc. 5643 | 2004-09-10 | Cassidy & Associates, Inc. | 700 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
41683 | 41683 | 2009-12-31 | 2009-09-30 | Footlik | Jay K. | Global Policy Initiatives 5954 | 2009-09-30 | Global Policy Initiatives | 1411 Johnson Drive | #1315 | Buffalo Grove | IL | 60089 |
41684 | 41684 | 2009-12-31 | 2008-12-16 | Jacobs | Barry | Jacobs, Barry 5900 | 2008-12-16 | Jacobs, Barry | Chartwell Consultancy, LLC | 1206 Old Stable Road | McLean | VA | 22102 |
41685 | 41685 | 2009-12-31 | 2009-12-30 | Brown | Christopher | Manatt, Phelps & Phillips, LLP 5864 | 2008-05-16 | Manatt, Phelps & Phillips, LLP | 700 12th Street, NW | Suite 1100 | Washington | DC | 20005 |
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]) );