FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where "Short_Form_Termination_Date" is on date 1988-10-31
This data as json, CSV (advanced)
Registration_Number 9
- Squire, Sanders & Dempsey, L.L.P. 4
- International Public Affairs Consultants, Inc. 4
- J. Woodman Associates, Inc. 2
- Arnold & Porter Kaye Scholer LLP 1
- Scottish Enterprise 1
- Austrian Trade Commission in the U.S., Houston 1
- Heron, Burchette, Ruckert & Rothwell 1
- Debevoise & Plimpton 1
- Alan M. Porten & Associates, Inc. 1
Registrant_Name 9
- International Public Affairs Consultants, Inc. 4
- Squire, Sanders & Dempsey, L.L.P. 4
- J. Woodman Associates, Inc. 2
- Alan M. Porten & Associates, Inc. 1
- Arnold & Porter Kaye Scholer LLP 1
- Austrian Trade Commission in the U.S., Houston 1
- Debevoise & Plimpton 1
- Heron, Burchette, Ruckert & Rothwell 1
- Scottish Enterprise 1
City 7
- Washington 6
- Arlington 4
- Carmel 2
- Cambridge 1
- Houston 1
- New York 1
- Silver Spring 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34277 | 34277 | 1988-10-31 | 1986-01-13 | Goldstein | Miriam Julia | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
34278 | 34278 | 1988-10-31 | 1986-01-13 | Hill | Kimberly Kay | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
34279 | 34279 | 1988-10-31 | 1986-01-31 | Brown | David John Alexander | Scottish Enterprise 3013 | 1979-04-17 | Scottish Enterprise | SCTR Ltd British Consulate | One Broadway 7th Floor | Cambridge | MA | 02109 |
34280 | 34280 | 1988-10-31 | 1986-02-18 | Gingold | Dennis M. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
34281 | 34281 | 1988-10-31 | 1986-02-18 | Miller | John M. | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | 1201 Pennsylvania Avenue, N.W. | Post Office Box 407 | Washington | DC | 20044-0407 |
34282 | 34282 | 1988-10-31 | 1988-05-04 | Mallonee | Thomas S. | Alan M. Porten & Associates, Inc. 4136 | 1988-05-04 | Alan M. Porten & Associates, Inc. | 8700 Georgia Avenue | Suite 300 | Silver Spring | MD | 20910 |
34283 | 34283 | 1988-10-31 | 1986-05-13 | Associates | Jay Parker & , Inc. | International Public Affairs Consultants, Inc. 3730 | 1986-05-13 | International Public Affairs Consultants, Inc. | Post Office Box 9376 | Arlington | VA | 22209 | |
34284 | 34284 | 1988-10-31 | 1986-05-13 | Borie | Yvonne M. | International Public Affairs Consultants, Inc. 3730 | 1986-05-13 | International Public Affairs Consultants, Inc. | Post Office Box 9376 | Arlington | VA | 22209 | |
34285 | 34285 | 1988-10-31 | 1986-05-13 | Kendricks | James W. | International Public Affairs Consultants, Inc. 3730 | 1986-05-13 | International Public Affairs Consultants, Inc. | Post Office Box 9376 | Arlington | VA | 22209 | |
34286 | 34286 | 1988-10-31 | 1986-05-13 | Keyes | William A. | International Public Affairs Consultants, Inc. 3730 | 1986-05-13 | International Public Affairs Consultants, Inc. | Post Office Box 9376 | Arlington | VA | 22209 | |
34287 | 34287 | 1988-10-31 | 1987-06-26 | Peltier | Jack G. | J. Woodman Associates, Inc. 3590 | 1984-05-31 | J. Woodman Associates, Inc. | Post Office Box 1000 | Carmel | NY | 10512-8000 | |
34288 | 34288 | 1988-10-31 | 1988-07-29 | Oriot | Pierre A. | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | 1025 Thomas Jeff. Street, N.W. | Suite 700 | Washington | DC | 20007 |
34289 | 34289 | 1988-10-31 | 1982-09-20 | Merten | Rudolf | Austrian Trade Commission in the U.S., Houston 3410 | 1982-09-20 | Austrian Trade Commission in the U.S., Houston | 1300 Post Oak Boulevard | Suite 1700 | Houston | TX | 77056 |
34290 | 34290 | 1988-10-31 | 1987-09-28 | Clarizio | Lynda M. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
34291 | 34291 | 1988-10-31 | 1987-09-29 | Luhn | Dorothy C. | J. Woodman Associates, Inc. 3590 | 1984-05-31 | J. Woodman Associates, Inc. | Post Office Box 1000 | Carmel | NY | 10512-8000 | |
34292 | 34292 | 1988-10-31 | 1987-11-05 | Roiter | Eric D. | Debevoise & Plimpton 3527 | 1983-10-05 | Debevoise & Plimpton | 919 Third Avenue | 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]) );