FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Austin"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Date (date)
Registration_Number 11
Registrant_Name 11
City 5
- New York 5
- Washington 4
- Boston 1
- Los Angeles 1
- San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2969 | 2969 | 2016-01-01 | 2014-11-05 | Austin | Avelyn | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
17753 | 17753 | 1991-05-31 | 1989-10-10 | Austin | R. Hugh | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
20431 | 20431 | 1991-06-28 | 1989-01-19 | Austin | Robert | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
23648 | 23648 | 1976-07-20 | 1971-06-24 | Austin | Robert E. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
24689 | 24689 | 1977-07-31 | 1977-06-21 | Austin | Alan K. | McKee, William D. 2794 | 1977-06-21 | McKee, William D. | 600 Montgomery Street | 12th Floor | San Francisco | CA | 94111 |
26539 | 26539 | 1993-08-13 | 1993-05-28 | Austin | Claire H. | Hofman, Steven I. 4810 | 1993-05-28 | Hofman, Steven I. | 1001 Pennsylvania Avenue, N.W. | Suite 350 N | Washington | DC | 20004 |
28459 | 28459 | 2006-08-31 | 2006-01-30 | Austin | Marcia | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
33298 | 33298 | 1988-10-21 | 1988-04-08 | Austin | Margo | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
34032 | 34032 | 1974-10-30 | 1969-05-14 | Austin | Max | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
35596 | 35596 | 2003-11-10 | 1990-09-11 | Austin | Marcia S. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
36403 | 36403 | 2013-11-25 | 2007-10-15 | Austin | Doreen | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 565 Fifth Avenue | 4th Floor | New York | NY | 10017 |
36846 | 36846 | 1997-11-30 | 1996-04-25 | Austin | David F. T. | Friends of Fine Gael, Inc. 5068 | 1995-11-08 | Friends of Fine Gael, Inc. | 55 Union Street | Suite 200 | Boston | MA | 02108-2400 |
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]) );