FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
24 rows where Short_Form_Termination_Date = "2002-09-30"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Date (date)
Registration_Number 18
- Daniel J. Edelman, Inc. 3
- Baker, Donelson, Bearman & Caldwell 3
- Public Strategies, Inc. 3
- KOTRA 1
- Hong Kong Tourism Board 1
- Far East Trade Services, Inc. 1
- Welsh Development Agency 1
- IPG DXTRA, Inc 1
- Tripp, Umbach & Associates, Inc. 1
- Dyer Ellis & Joseph, P.C. 1
- Medialink Worldwide Inc. 1
- Advantage Associates Inc. 1
- Clark & Weinstock 1
- Philip S. Smith & Associates, Inc. 1
- Global Market Solutions 1
- Ryberg and Smith, LLP 1
- Harbour Group, LLC 1
- Medley Global Advisors 1
Registrant_Name 18
- Baker, Donelson, Bearman & Caldwell 3
- Daniel J. Edelman, Inc. 3
- Public Strategies, Inc. 3
- Advantage Associates Inc. 1
- Clark & Weinstock 1
- Dyer Ellis & Joseph, P.C. 1
- Far East Trade Services, Inc. 1
- Global Market Solutions 1
- Harbour Group, LLC 1
- Hong Kong Tourism Board 1
- IPG DXTRA, Inc 1
- KOTRA 1
- Medialink Worldwide Inc. 1
- Medley Global Advisors 1
- Philip S. Smith & Associates, Inc. 1
- Ryberg and Smith, LLP 1
- Tripp, Umbach & Associates, Inc. 1
- Welsh Development Agency 1
City 7
- Washington 10
- New York 7
- Austin 3
- Chicago 1
- Los Angeles 1
- Pittsburgh 1
- Santa Clara 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31283 | 31283 | 2002-09-30 | 2002-01-25 | Yo | Ying Ling | Far East Trade Services, Inc. 2985 | 1978-12-06 | Far East Trade Services, Inc. | 5201 Great America Parkway | Suite 306 | Santa Clara | CA | 95054-1122 |
31284 | 31284 | 2002-09-30 | 2002-02-11 | Smith | Philip S. | Philip S. Smith & Associates, Inc. 5471 | 2002-02-11 | Philip S. Smith & Associates, Inc. | 611 Pennsylvania Avenue, S.E. | Suite 381 | Washington | DC | 20003 |
31285 | 31285 | 2002-09-30 | 2002-02-14 | Dickie | Joseph R. | Public Strategies, Inc. 5472 | 2002-02-14 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 900 | Austin | TX | 78701 |
31286 | 31286 | 2002-09-30 | 2002-02-14 | Glaudemaus | Jon | Public Strategies, Inc. 5472 | 2002-02-14 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 900 | Austin | TX | 78701 |
31287 | 31287 | 2002-09-30 | 2002-02-14 | Wallace | Roger Windham | Public Strategies, Inc. 5472 | 2002-02-14 | Public Strategies, Inc. | 98 San Jacinto Boulevard | Suite 900 | Austin | TX | 78701 |
31288 | 31288 | 2002-09-30 | 2002-02-25 | Ervin | Roger M. | Global Market Solutions 5475 | 2002-02-25 | Global Market Solutions | 4711 Albemarle Street, N.W. | Washington | DC | 20016 | |
31289 | 31289 | 2002-09-30 | 2002-03-01 | Ryberg | Paul Jr., | Ryberg and Smith, LLP 5477 | 2002-03-01 | Ryberg and Smith, LLP | 1054 Thirty-First Street, N.W. | Suite 300 | Washington | DC | 20007 |
31290 | 31290 | 2002-09-30 | 2002-03-04 | Marcus | Richard | Harbour Group, LLC 5478 | 2002-03-04 | Harbour Group, LLC | 2101 L Street, NW | Suite 800 | Washington | DC | 20037 |
31291 | 31291 | 2002-09-30 | 2002-03-11 | Maguire | John | Medley Global Advisors 5484 | 2002-03-11 | Medley Global Advisors | 451 Greenwich Street | 6th Floor | New York | NY | 10013 |
31292 | 31292 | 2002-09-30 | 2001-03-21 | Works | George | Advantage Associates Inc. 5419 | 2001-03-21 | Advantage Associates Inc. | 908 Pennsylvania Avenue S.E. | Washington | DC | 20003 | |
31293 | 31293 | 2002-09-30 | 2002-04-02 | Lamoriello | Francine | Baker, Donelson, Bearman & Caldwell 5274 | 1998-09-17 | Baker, Donelson, Bearman & Caldwell | 555 Eleventh Street, N.W. | 6th Floor | Washington | DC | 20004 |
31294 | 31294 | 2002-09-30 | 2002-04-02 | McEntee | Joan M. | Baker, Donelson, Bearman & Caldwell 5274 | 1998-09-17 | Baker, Donelson, Bearman & Caldwell | 555 Eleventh Street, N.W. | 6th Floor | Washington | DC | 20004 |
31295 | 31295 | 2002-09-30 | 2003-05-27 | Abrams | Jennifer | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31296 | 31296 | 2002-09-30 | 2003-05-27 | Bortz | Amy | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31297 | 31297 | 2002-09-30 | 2003-05-27 | Hershman | Elisabeth | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31298 | 31298 | 2002-09-30 | 1996-05-31 | Smits | Kathryn Nedelman | Hong Kong Tourism Board 2110 | 1968-10-29 | Hong Kong Tourism Board | 5901 W CENTURY BLVD. | SUITE 650 | Los Angeles | CA | 90045 |
31299 | 31299 | 2002-09-30 | 1994-06-22 | Williams | Scott | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
31300 | 31300 | 2002-09-30 | 2002-07-30 | Vernaza | Luis J. | Dyer Ellis & Joseph, P.C. 5345 | 1999-12-01 | Dyer Ellis & Joseph, P.C. | 600 New Hampshire Avenue, N.W. | 11th Floor | Washington | DC | 20037 |
31301 | 31301 | 2002-09-30 | 2000-09-05 | Hirst | Nick | Medialink Worldwide Inc. 5382 | 2000-09-05 | Medialink Worldwide Inc. | 708 Third Avenue | 9th Floor | New York | NY | 10017 |
31302 | 31302 | 2002-09-30 | 2001-09-10 | Garcia | Helio Fred | Clark & Weinstock 5457 | 2001-09-10 | Clark & Weinstock | 601 13th Street, N.W. | Suite 410 South | Washington | DC | 20005 |
31303 | 31303 | 2002-09-30 | 1998-09-17 | Eagleburger | Lawrence S. | Baker, Donelson, Bearman & Caldwell 5274 | 1998-09-17 | Baker, Donelson, Bearman & Caldwell | 555 Eleventh Street, N.W. | 6th Floor | Washington | DC | 20004 |
31304 | 31304 | 2002-09-30 | 2001-10-09 | Wright | Paul | Welsh Development Agency 3819 | 1986-04-24 | Welsh Development Agency | 191 North Wacker Drive | Suite 1685 | Chicago | IL | 60606 |
31305 | 31305 | 2002-09-30 | 1992-10-20 | Howard-Tripp | Simon James | Tripp, Umbach & Associates, Inc. 4724 | 1992-10-20 | Tripp, Umbach & Associates, Inc. | Fort Pitt Commons, Suite 220 | 445 Fort Pitt Boulevard | Pittsburgh | PA | 15219 |
31306 | 31306 | 2002-09-30 | 2000-12-06 | Seo | Jong-Seog | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
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]) );