FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where Short_Form_Termination_Date = "1991-10-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date, Address_2, Short_Form_Date (date)
Registration_Number 17
- New Zealand Government Tourist Office 4
- Hill and Knowlton Strategies, LLC 3
- Jones Day 3
- Provisional Government of Eritrea - EPLF 2
- Jellinek, Schwartz & Connolly, Inc. 2
- Austrian Trade Commissioner in the U.S., Chicago 1
- Modern Education Services, Inc. 1
- Government of Ontario, Canada 1
- Aaron D. Cushman & Associates, Inc. 1
- Graydon Associates, Inc. 1
- Polish National Tourist Office, Chicago 1
- IPG DXTRA, Inc 1
- First Associates, Inc. 1
- Bannerman & Associates, Inc. 1
- Peiris, James Elroy Sheron 1
- Carl Byoir & Associates 1
- Boasberg Valentine-Radford, Inc. 1
Registrant_Name 17
- New Zealand Government Tourist Office 4
- Hill and Knowlton Strategies, LLC 3
- Jones Day 3
- Jellinek, Schwartz & Connolly, Inc. 2
- Provisional Government of Eritrea - EPLF 2
- Aaron D. Cushman & Associates, Inc. 1
- Austrian Trade Commissioner in the U.S., Chicago 1
- Bannerman & Associates, Inc. 1
- Boasberg Valentine-Radford, Inc. 1
- Carl Byoir & Associates 1
- First Associates, Inc. 1
- Government of Ontario, Canada 1
- Graydon Associates, Inc. 1
- IPG DXTRA, Inc 1
- Modern Education Services, Inc. 1
- Peiris, James Elroy Sheron 1
- Polish National Tourist Office, Chicago 1
City 9
- Washington 9
- Los Angeles 4
- Arlington 3
- Chicago 3
- New York 3
- Alexandria 1
- Culver City 1
- Kansas City 1
- Red Bank 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34313 | 34313 | 1991-10-31 | 1937-01-01 | Chapman | David R. | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | 10960 Wilshire Boulevard | Suite 1530 | Los Angeles | CA | 90024 |
34314 | 34314 | 1991-10-31 | 1972-01-11 | Scholten | Harold Bernard | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
34315 | 34315 | 1991-10-31 | 1988-02-17 | Fiamma | Stephen E. | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
34316 | 34316 | 1991-10-31 | 1990-02-23 | Freshman | John D. | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
34317 | 34317 | 1991-10-31 | 1987-02-25 | Roberson | Floyd I. | First Associates, Inc. 3941 | 1987-02-25 | First Associates, Inc. | 4320 Lorcom Lane | Arlington | VA | 22207 | |
34318 | 34318 | 1991-10-31 | 1989-03-02 | Kaufman | Steve L. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34319 | 34319 | 1991-10-31 | 1991-03-28 | Kast | Lawrence P. | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
34320 | 34320 | 1991-10-31 | 1991-04-01 | Schleicher | Jerry L. | Boasberg Valentine-Radford, Inc. 4492 | 1991-04-01 | Boasberg Valentine-Radford, Inc. | 4600 Madison Avenue | Kansas City | MO | 64112 | |
34321 | 34321 | 1991-10-31 | 1979-04-19 | Rasmussen | John D. | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | 10960 Wilshire Boulevard | Suite 1530 | Los Angeles | CA | 90024 |
34322 | 34322 | 1991-10-31 | 1990-04-24 | Peiris | James Elroy Sheron | Peiris, James Elroy Sheron 4369 | 1990-04-24 | Peiris, James Elroy Sheron | C/O Alliance Bank | 100 Corporate Pointe | Culver City | CA | 90230 |
34323 | 34323 | 1991-10-31 | 1991-04-24 | Balcerzak | Stephanie | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
34324 | 34324 | 1991-10-31 | 1991-04-24 | Pliotis | Pano | Jones Day 3427 | 1982-12-10 | Jones Day | 51 Louisiana Avenue, N.W. | Washington | DC | 20001-2113 | |
34325 | 34325 | 1991-10-31 | 1986-05-09 | Ofiarski | Marcel | Polish National Tourist Office, Chicago 3360 | 1982-04-21 | Polish National Tourist Office, Chicago | 333 North Michigan Avenue | Suite 228 | Chicago | IL | 60601 |
34326 | 34326 | 1991-10-31 | 1990-06-13 | Frankfother | Kent P. | Aaron D. Cushman & Associates, Inc. 2572 | 1975-04-07 | Aaron D. Cushman & Associates, Inc. | 35 East Wacker Drive | Suite 850 | Chicago | IL | 60601 |
34327 | 34327 | 1991-10-31 | 1980-08-01 | Eddington | Barry Craig | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | 10960 Wilshire Boulevard | Suite 1530 | Los Angeles | CA | 90024 |
34328 | 34328 | 1991-10-31 | 1988-08-04 | Perugino | Roxanne | Bannerman & Associates, Inc. 3964 | 1987-04-28 | Bannerman & Associates, Inc. | 3 Wilkes Street | Alexandria | VA | 22314 | |
34329 | 34329 | 1991-10-31 | 1991-08-21 | Hearle | Douglas G. | Carl Byoir & Associates 4411 | 1990-09-12 | Carl Byoir & Associates | 420 Lexington Avenue | New York | NY | 10017 | |
34330 | 34330 | 1991-10-31 | 1990-08-27 | Clevenger | Nathaniel J. , III | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34331 | 34331 | 1991-10-31 | 1990-08-27 | Miller | Tristan M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
34332 | 34332 | 1991-10-31 | 1988-09-27 | Medhani | Rezene | Provisional Government of Eritrea - EPLF 3745 | 1985-10-08 | Provisional Government of Eritrea - EPLF | Post Office Box 65685 | Washington | DC | 20035 | |
34333 | 34333 | 1991-10-31 | 1989-09-27 | Glantschnig | Ewald | Austrian Trade Commissioner in the U.S., Chicago 874 | 1955-02-21 | Austrian Trade Commissioner in the U.S., Chicago | 500 North Michigan Avenue | Suite 1950 | Chicago | IL | 60611 |
34334 | 34334 | 1991-10-31 | 1991-09-30 | Buckley | John | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
34335 | 34335 | 1991-10-31 | 1981-10-26 | Marks | Nicholas C. | New Zealand Government Tourist Office 2307 | 1972-01-17 | New Zealand Government Tourist Office | 10960 Wilshire Boulevard | Suite 1530 | Los Angeles | CA | 90024 |
34336 | 34336 | 1991-10-31 | 1989-11-15 | Meky | Salih | Provisional Government of Eritrea - EPLF 3745 | 1985-10-08 | Provisional Government of Eritrea - EPLF | Post Office Box 65685 | Washington | DC | 20035 | |
34337 | 34337 | 1991-10-31 | 1979-11-19 | Etheridge | Edgar E. | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | 1015 - 18th Street, N.W. | Suite 704 | Washington | DC | 20036 |
34338 | 34338 | 1991-10-31 | 1975-12-10 | Byck | Donald M. | Graydon Associates, Inc. 2639 | 1975-12-10 | Graydon Associates, Inc. | 216 Maple Avenue | Post Office Box 566 | Red Bank | NJ | 07701 |
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]) );