FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Date" is on date 1987-04-15 sorted by Short_Form_First_Name
This data as json, CSV (advanced)
Suggested facets: Address_1, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20523 | 20523 | 1987-06-29 | 1987-04-15 | Allen | Alexis B. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
12779 | 12779 | 1989-04-05 | 1987-04-15 | Edson | Andrew S. | Padilla, Speer, Burdick & Beardsley, Inc. 3959 | 1987-04-15 | Padilla, Speer, Burdick & Beardsley, Inc. | 950 Third Avenue | New York | NY | 10022 | |
12828 | 12828 | 1988-04-06 | 1987-04-15 | Marsh | Bennett A. | Manchester Associates, Ltd. 3046 | 1979-08-09 | Manchester Associates, Ltd. | 1707 L Street, N.W. | Suite 725 | Washington | DC | 20036 |
12780 | 12780 | 1989-04-05 | 1987-04-15 | Kogut | David H. | Padilla, Speer, Burdick & Beardsley, Inc. 3959 | 1987-04-15 | Padilla, Speer, Burdick & Beardsley, Inc. | 950 Third Avenue | New York | NY | 10022 | |
26623 | 26623 | 1991-08-14 | 1987-04-15 | Pryor | David H. , Jr. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
28138 | 28138 | 1989-08-31 | 1987-04-15 | Solymossy | Diana Sun | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
19429 | 19429 | 1989-06-14 | 1987-04-15 | Spong | Douglas K. | Colle & McVoy Public Relations 3960 | 1987-04-15 | Colle & McVoy Public Relations | 7900 International Drive | Minneapolis | MN | 55425 | |
19164 | 19164 | 1993-06-10 | 1987-04-15 | Kobran-Deitz | Holly | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
40476 | 40476 | 1988-12-31 | 1987-04-15 | Webb | Horace | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
13096 | 13096 | 1995-04-10 | 1987-04-15 | Currier | Jerry | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
11599 | 11599 | 1989-03-31 | 1987-04-15 | Rhee | Kwang Sik | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
19427 | 19427 | 1989-06-14 | 1987-04-15 | Holte | Laura | Colle & McVoy Public Relations 3960 | 1987-04-15 | Colle & McVoy Public Relations | 7900 International Drive | Minneapolis | MN | 55425 | |
4519 | 4519 | 1988-01-26 | 1987-04-15 | Mudd | Matthew | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
7172 | 7172 | 1992-02-17 | 1987-04-15 | Barbis | Patricia Q. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
32904 | 32904 | 1991-10-15 | 1987-04-15 | Victor | Paul A. | Dublirer, Haydon, Straci & Victor 3961 | 1987-04-15 | Dublirer, Haydon, Straci & Victor | 17 Battery Place | New York | NY | 10004 | |
32903 | 32903 | 1991-10-15 | 1987-04-15 | Straci | Ronald A. | Dublirer, Haydon, Straci & Victor 3961 | 1987-04-15 | Dublirer, Haydon, Straci & Victor | 17 Battery Place | New York | NY | 10004 | |
36702 | 36702 | 1988-11-30 | 1987-04-15 | Song | Sung Soo | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
19428 | 19428 | 1989-06-14 | 1987-04-15 | Nehring | Susan Busch | Colle & McVoy Public Relations 3960 | 1987-04-15 | Colle & McVoy Public Relations | 7900 International Drive | Minneapolis | MN | 55425 | |
9120 | 9120 | 1988-03-04 | 1987-04-15 | Bowman | Tracie | Colle & McVoy Public Relations 3960 | 1987-04-15 | Colle & McVoy Public Relations | 7900 International Drive | Minneapolis | MN | 55425 | |
11623 | 11623 | 1990-03-31 | 1987-04-15 | Sunwoo | Young-Il | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 111 East Wacker Drive | Suite 2229 | Chicago | IL | 60601 |
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]) );